BigQuery job for joining source tables

SatcherInstitute / prototype

MIT License

4 stars 4 forks source link

Open mayaspivak opened 3 years ago

mayaspivak commented 3 years ago

Create a BigQuery job that joins source tables on county and stores the resulting table.

slagathorr commented 3 years ago

Trying an initial swag at some of the files. Right now it's a snapshot upload of the CDC provisional deaths file, and the urgent care facility data.

slagathorr commented 3 years ago

Data Notes:

urgent_care_facilities: Unable to find a data dictionary, not sure what the X and Y columns in the downloaded CSV are, as they don’t seem to correlate to anything on the data exploration section on the source webpage. X_26 and Y_27 are the proper lat/long coordinates.
Unable to find the raw data for https://www.countyhealthrankings.org/explore-health-rankings/measures-data-sources/county-health-rankings-model/health-factors/clinical-care/access-to-care/primary-care-physicians