Skip to content

Instantly share code, notes, and snippets.

View JCarpenter-WPI's full-sized avatar

Janet Carpenter JCarpenter-WPI

View GitHub Profile
@JCarpenter-WPI
JCarpenter-WPI / NACRO member survey.csv
Last active September 18, 2019 15:06
We can't make this file beautiful and searchable because it's too large.
Year,3 Yr Change in CR Staffing,Active Centers,Activity: (External) Communications,Activity: (External) Community relations,Activity: (External) Government relations,Activity: (External) New prospect cultivation,Activity: (External) Stewardship of existing relationships,Activity: (Internal) Meetings with faculty and staff,Activity: (Internal) Meetings with university leadership,Activity: (Internal) Proposal and other writing,Activity: (Internal) Prospect research and qualification,Activity: (Internal) Reporting,Activity: (Internal) Talent acquisition/recruiting,Additional Benefits,Additional Comments,Age,Benefits: Annual Bonus,Benefits: Car Allowance,Benefits: Defined Contribution,Benefits: Dental Plan,Benefits: Health Plan,Benefits: Matching Retirement,Benefits: None,Benefits: Other,Benefits: Paid Parental Leave,Benefits: Pension,Benefits: Phone Allowance,Benefits: Travel Bonus,Benefits: Tuition Waivers,Benefits: Vision Plan,Central Office,Classification,Conf Location,CR Experience,CR Experience: Other,CR St
@JCarpenter-WPI
JCarpenter-WPI / College Scorecard Data Select Variables.csv
Last active September 18, 2019 15:04
We can't make this file beautiful and searchable because it's too large.
UNITID,INSTNM,CITY,STABBR,HCM2,PREDDEG,HIGHDEG,CONTROL,LOCALE,HBCU,PBI,ANNHI,TRIBAL,AANAPII,HSI,NANTI,MENONLY,WOMENONLY,SATVR25,SATVR75,SATMT25,SATMT75,SATWR25,SATWR75,SATVRMID,SATMTMID,SATWRMID,ACTCM25,ACTCM75,ACTEN25,ACTEN75,ACTMT25,ACTMT75,ACTWR25,ACTWR75,ACTCMMID,ACTENMID,ACTMTMID,ACTWRMID,SAT_AVG,SAT_AVG_ALL,PCIP01,PCIP03,PCIP04,PCIP05,PCIP09,PCIP10,PCIP11,PCIP12,PCIP13,PCIP14,PCIP15,PCIP16,PCIP19,PCIP22,PCIP23,PCIP24,PCIP25,PCIP26,PCIP27,PCIP29,PCIP30,PCIP31,PCIP38,PCIP39,PCIP40,PCIP41,PCIP42,PCIP43,PCIP44,PCIP45,PCIP46,PCIP47,PCIP48,PCIP49,PCIP50,PCIP51,PCIP52,PCIP54,DISTANCEONLY,UGDS,UGDS_WHITE,UGDS_BLACK,UGDS_HISP,UGDS_ASIAN,UGDS_AIAN,UGDS_NHPI,UGDS_2MOR,UGDS_NRA,UGDS_UNKN,PPTUG_EF,CURROPER,NPT4_PUB,NPT4_PRIV,NPT41_PUB,NPT42_PUB,NPT43_PUB,NPT44_PUB,NPT45_PUB,NPT41_PRIV,NPT42_PRIV,NPT43_PRIV,NPT44_PRIV,NPT45_PRIV,PCTPELL,PCTFLOAN,UG25ABV,MD_EARN_WNE_P10,OPEFLAG
100654,Alabama A & M University,Normal,AL,0,3,4,1,12,1,0,0,0,0,0,0,0,0,365,485,360,495,370,457,425,428,414,16,19,14,20,15,18,NULL,NULL,18,17,1
@JCarpenter-WPI
JCarpenter-WPI / College Scorecard Data Outcomes Select Variables.csv
Last active September 18, 2019 15:04
We can't make this file beautiful and searchable because it's too large.
UNITID,INSTNM,AGEGE24,PCT_WHITE,PCT_BLACK,PCT_ASIAN,PCT_HISPANIC,PCT_BA,PCT_GRAD_PROF,PCT_BORN_US,MEDIAN_HH_INC,POVERTY_RATE,UNEMP_RATE,LN_MEDIAN_HH_INC,COUNT_NWNE_P10,COUNT_WNE_P10,MN_EARN_WNE_P10,MD_EARN_WNE_P10,PCT10_EARN_WNE_P10,PCT25_EARN_WNE_P10,PCT75_EARN_WNE_P10,PCT90_EARN_WNE_P10,SD_EARN_WNE_P10,COUNT_WNE_INC1_P10,COUNT_WNE_INC2_P10,COUNT_WNE_INC3_P10,COUNT_WNE_INDEP0_INC1_P10,COUNT_WNE_INDEP0_P10,COUNT_WNE_INDEP1_P10,COUNT_WNE_MALE0_P10,COUNT_WNE_MALE1_P10,GT_25K_P10,MN_EARN_WNE_INC1_P10,MN_EARN_WNE_INC2_P10,MN_EARN_WNE_INC3_P10,MN_EARN_WNE_INDEP0_INC1_P10,MN_EARN_WNE_INDEP0_P10,MN_EARN_WNE_INDEP1_P10,MN_EARN_WNE_MALE0_P10,MN_EARN_WNE_MALE1_P10,COUNT_NWNE_P6,COUNT_WNE_P6,MN_EARN_WNE_P6,MD_EARN_WNE_P6,PCT10_EARN_WNE_P6,PCT25_EARN_WNE_P6,PCT75_EARN_WNE_P6,PCT90_EARN_WNE_P6,SD_EARN_WNE_P6,COUNT_WNE_INC1_P6,COUNT_WNE_INC2_P6,COUNT_WNE_INC3_P6,COUNT_WNE_INDEP0_INC1_P6,COUNT_WNE_INDEP0_P6,COUNT_WNE_INDEP1_P6,COUNT_WNE_MALE0_P6,COUNT_WNE_MALE1_P6,GT_25K_P6,MN_EARN_WNE_INC1_P6,MN_EARN_WNE_INC2_P6,MN_EARN_WN
@JCarpenter-WPI
JCarpenter-WPI / NACRO member geography.csv
Last active September 18, 2019 14:57
Institution Name Number of Members INSTNM CITY STABBR ZIP ST_FIPS REGION LATITUDE LONGITUDE Flag
American University 1 American University Washington DC 20016-8001 11 2 38.936005 -77.088875
Arizona State University-Tempe 7 Arizona State University-Tempe Tempe AZ 85287 4 6 33.417721 -111.934383
Auburn University 5 Auburn University Auburn AL 36849 1 5 32.599378 -85.488258
Augsburg College 1 Augsburg University Minneapolis MN 55454 27 4 44.966307 -93.240436 ?
Baylor College of Medicine 1 Baylor College of Medicine Houston TX 77030-3498 48 6 29.7106 -95.395743
Baylor University 1 Baylor University Waco TX 76798 48 6 31.546872 -97.121041
Bentley University 1 Bentley University Waltham MA 02452-4705 25 1 42.385995 -71.222839
Bloomsburg University of Pennsylvania 1 Bloomsburg University of Pennsylvania Bloomsburg PA 17815 42 2 41.00782 -76.447844
Boise State University 1 Boise State University Boise ID 83725 16 7 43.604284 -116.203301
@JCarpenter-WPI
JCarpenter-WPI / NACRO office types.csv
Last active October 4, 2019 15:42
Office Type Number
Corporate Relations Holistic 82
Corporate and Foundation Relations 69
Corporate Relations Development 50
Other 28
Corporate Relations Researc 18
Career Services 9
Research/Sponsored Research 8
Economic Development 5
Licensing or Technology Transfer 5
@JCarpenter-WPI
JCarpenter-WPI / NACRO office types by enrollment
Last active October 4, 2019 17:27
Office Type,Total,Under 250,251 – 500,"501 – 1,000","1,001 – 2,500","2,501 – 5,000","5,001 – 10,000","10,001 – 20,000","20,001 – 30,000","30,001 – 40,000","Over 40,000"
Career Services,9,,,,,,3,1,1,,4
Corporate and Foundation Relations,68,,,,3,5,7,14,16,6,17
Corporate Relations Development,49,,,,,2,4,11,11,9,12
Corporate Relations Holistic,82,,,,2,2,15,12,11,16,24
Corporate Relations Research,18,,,,,,2,3,3,4,6
Economic Development,5,,,,1,,,,1,1,2
Foundation Relations,4,,,,2,,,1,,1,
Government Relations,1,,,,,,,,1,,
Individual or Alumni Giving,1,,,1,,,,,,,
@JCarpenter-WPI
JCarpenter-WPI / NACRO member institutions by tier
Last active October 9, 2019 18:19
Org Name,Org Type,Tiers: Total,Level,LATITUDE,LONGITUDE
American University,Private higher education,1-5,1,38.936005,-77.088875
Northwestern University,Private higher education,1-5,1,42.050356,-87.679858
University of Arkansas for Medical Sciences,Public higher education,1-5,1,34.749048,-92.320046
University of Chicago,Private higher education,1-5,1,41.787994,-87.599539
Clemson University,Public higher education,6-10,2,34.679381,-82.835114
Fitchburg State University,Public higher education,11-20,3,42.588298,-71.789666
Penn State Health and College of Medicine,Public higher education,11-20,3,40.264245,-76.67408
Pennsylvania State University-Main Campus,Public higher education,11-20,3,40.7965,-77.862848
Regent University,Private higher education,11-20,3,36.801173,-76.194627
@JCarpenter-WPI
JCarpenter-WPI / NACRO office types and organizational characteristics.csv
Last active October 10, 2019 18:23
Classification Enrollment Office Type Org Type
M1 5,001 – 10,000 Corporate and Foundation Relations Private
M1 2,501 – 5,000 Other Private
M2 10,001 – 20,000 Corporate Relations Development Private
M3 1,001 – 2,500 Corporate and Foundation Relations Private
M3 2,501 – 5,000 Corporate and Foundation Relations Private
M3 5,001 – 10,000 Corporate and Foundation Relations Private
M3 1,001 – 2,500 Corporate and Foundation Relations Private
M3 2,501 – 5,000 Corporate Relations Development Private
M3 1,001 – 2,500 Corporate Relations Holistic Private
@JCarpenter-WPI
JCarpenter-WPI / NACRO tiers with CW price and earnings.csv
Last active October 18, 2019 17:02
Org Name Number of Companies Price Earnings Tier
American University 1-5 36567 46700 1
Northwestern University 1-5 24047 71900 1
University of Chicago 1-5 25455 72100 1
Clemson University 6-10 17696 48100 2
Fitchburg State University 11-20 16009 37700 3
University of California, Santa Cruz 11-20 17877 38400 3
Pennsylvania State University-Main Campus 11-20 30373 43600 3
Regent University 11-20 17842 34800 3
Rollins College 11-20 30194 40300 3