jordanijames / School-Segregation

MIT License
1 stars 0 forks source link

Getting Data #2

Closed AaronGullickson closed 1 week ago

AaronGullickson commented 1 month ago

Ok, I want to move our conversation over to the correct repository and also provide some more thoughts. The place that you want to use for getting data is the NCES Table Generator. You can use this to define custom extracts of just the data you want. I think you want to use this to generate two different extracts.

  1. A dataset of private schools. I think you can get something better here than the data you already uploaded to GH, because I don't think that data has any geographical identifier. Remember that all we really want here is a count of the number of private schools, so you don't need detailed information on enrollment here, although I would get overall enrollment. You may want to consider school type or other ways you might want to separate out those counts as well. In looking through it, it does not seem like private schools are identified by school district, so I think instead of school district you may need to use the county identifier.
  2. A dataset of public schools. Here you want the enrollment data by race which you can get under the Enrollment tab. Since we are going to only have county id for the private school data, you should use that here as well.
AaronGullickson commented 1 month ago

Forgot to mention @jordanijames