This repository was archived by the owner on Nov 7, 2018. It is now read-only.
This repository was archived by the owner on Nov 7, 2018. It is now read-only.
CSV endpoint is not returning the same number of fields as JSON endpoint? #231
Description
If you query https://api.data.gov/ed/collegescorecard/v1/schools.json?fields=id,school.name,2013.student.size,2013.student.demographics.race_ethnicity.white, you get:
{
metadata: {
total: 7804,
page: 0,
per_page: 20
},
results: [
{
2013.student.demographics.race_ethnicity.white: 0.7962,
id: 238573,
2013.student.size: 157,
school.name: "Columbia College of Nursing"
},
{
2013.student.demographics.race_ethnicity.white: 0.614,
id: 479646,
2013.student.size: 171,
school.name: "ITT Technical Institute-Overland Park"
},
{
2013.student.demographics.race_ethnicity.white: 0.6188,
id: 479655,
2013.student.size: 202,
school.name: "ITT Technical Institute-Springfield"
},
{
2013.student.demographics.race_ethnicity.white: 0.7213,
id: 479664,
2013.student.size: 61,
school.name: "ITT Technical Institute-West Chester"
},
{
2013.student.demographics.race_ethnicity.white: 0.0547,
id: 479770,
2013.student.size: 128,
school.name: "University of Phoenix-McAllen Campus"
},
{
2013.student.demographics.race_ethnicity.white: 0.7523,
id: 479956,
2013.student.size: 4881,
school.name: "Pennsylvania State University-World Campus"
},
{
2013.student.demographics.race_ethnicity.white: 0.4286,
id: 479965,
2013.student.size: 77,
school.name: "Medical Career Institute"
},
{
2013.student.demographics.race_ethnicity.white: 0.1475,
id: 479974,
2013.student.size: 61,
school.name: "Advance Beauty Techs Academy"
},
{
2013.student.demographics.race_ethnicity.white: 0.6327,
id: 479983,
2013.student.size: 49,
school.name: "Longs Peak Academy"
},
{
2013.student.demographics.race_ethnicity.white: 0.3571,
id: 479992,
2013.student.size: 14,
school.name: "Brand College"
},
{
2013.student.demographics.race_ethnicity.white: 0.1607,
id: 480000,
2013.student.size: 56,
school.name: "Hinton Barber College"
},
{
2013.student.demographics.race_ethnicity.white: 0.4357,
id: 480019,
2013.student.size: 241,
school.name: "Advanced Career Institute"
},
{
2013.student.demographics.race_ethnicity.white: 0.1842,
id: 480028,
2013.student.size: 38,
school.name: "Digital Film Academy"
},
{
2013.student.demographics.race_ethnicity.white: 0.5988,
id: 480037,
2013.student.size: 496,
school.name: "MyComputerCareer.com-Raleigh"
},
{
2013.student.demographics.race_ethnicity.white: 0.461,
id: 480073,
2013.student.size: 141,
school.name: "South University-Austin"
},
{
2013.student.demographics.race_ethnicity.white: 0.1513,
id: 480082,
2013.student.size: 238,
school.name: "South University-Cleveland"
},
{
2013.student.demographics.race_ethnicity.white: 0.5375,
id: 480091,
2013.student.size: 2132,
school.name: "Bryant & Stratton College-Online"
},
{
2013.student.demographics.race_ethnicity.white: 0.1507,
id: 480107,
2013.student.size: 458,
school.name: "Virginia College-Florence"
},
{
2013.student.demographics.race_ethnicity.white: 0.2294,
id: 480125,
2013.student.size: 170,
school.name: "Ogle School Hair Skin Nails-San Antonio"
},
{
2013.student.demographics.race_ethnicity.white: 0.8301,
id: 480134,
2013.student.size: 365,
school.name: "Elizabethtown College School of Continuing and Professional Studies"
}
]
}
But if you query https://api.data.gov/ed/collegescorecard/v1/schools.csv?fields=id,school.name,2013.student.size,2013.student.demographics.race_ethnicity.white, you get:
"id","school.name"
"238573","Columbia College of Nursing"
"479646","ITT Technical Institute-Overland Park"
"479655","ITT Technical Institute-Springfield"
"479664","ITT Technical Institute-West Chester"
"479770","University of Phoenix-McAllen Campus"
"479956","Pennsylvania State University-World Campus"
"479965","Medical Career Institute"
"479974","Advance Beauty Techs Academy"
"479983","Longs Peak Academy"
"479992","Brand College"
"480000","Hinton Barber College"
"480019","Advanced Career Institute"
"480028","Digital Film Academy"
"480037","MyComputerCareer.com-Raleigh"
"480073","South University-Austin"
"480082","South University-Cleveland"
"480091","Bryant & Stratton College-Online"
"480107","Virginia College-Florence"
"480125","Ogle School Hair Skin Nails-San Antonio"
"480134","Elizabethtown College School of Continuing and Professional Studies"
The CSV is missing a bunch of columns.