search

CEIDatUGA / COVID-19-DATA

GNU General Public License v3.0
4 stars 6 forks source link

State Interventions Metadata #5

Closed renikaul closed 4 years ago

renikaul commented 4 years ago

Please add some meta data to the read me. There is an empty template at the bottom of the readme that you can copy and fill in.

rlrichards commented 4 years ago

Added for the main timeseries data set that folks should be using. Leaving open so that someone who compiled the "raw" data on Google sheets can provide metadata on that @arw36 @tierney6

renikaul commented 4 years ago

@rlrichards longform looks corrupted? It is only one line long.

tierney6 commented 4 years ago

also, would anyone oppose putting the state interventions datasets in a separate subfolder? i think as the data in this repo grows, it might be good to clean up the main directory

lsalvador commented 4 years ago

I think that makes sense

rlrichards commented 4 years ago

The metadata I added for the time series seems to have disappeared. Will fix some time tonight.

arw36 commented 4 years ago

metadata is sheet 4 https://docs.google.com/spreadsheets/d/1_mk1J3ElMH5EmPILcrx8s1KqHqdQYXCWroJeKTR3pV4/edit?usp=sharing

Do we need to migrate?

rlrichards commented 4 years ago

@arw36 I think it's best to have the metadata up to date here for the sake of consistency but defer to @renikaul @mvevans89

rlrichards commented 4 years ago

Also I think some of the metadata I put up already has disappeared? Have to update it anyway so I will update the time series meta-data if @arw36 or someone can update the metadata for the scraped google sheet.

lsalvador commented 4 years ago

My vote is to migrate it but defer to you. Some more info about metadata for state_traits:

column type source
NAME character  wikipedia
postalCode character wikipedia
capitol character wikipedia
largest_city character  wikipedia
under60 numeric  US census
60to70 numeric  US census
70to80 numeric  US census
over80 numeric  US census
totalpop numeric  wikipedia
Total_Area_mile2 numeric wikipedia
Land_Area_mile2 numeric wikipedia
Water_Area_mile2 numeric wikipedia

US census file: https://www2.census.gov/programs-surveys/popest/tables/2010-2018/state/asrh/sc-est2018-agesex-civ.csv

rlrichards commented 4 years ago

@lsalvador I think you might have posted in the wrong issue? This issue is about the state intervention data.

rlrichards commented 4 years ago

Also I'm an idiot. The metadata didn't disappear it was just migrated to readme's inside the directories. if @arw36 or someone else could check the metadata for the longform csvs (scraped from the sheet) for this directory and the one on ga counties that would be awesome!

lsalvador commented 4 years ago

@rlrichards Sorry, I was referring to the state_covid_file (link provided above). In any case, if useful, the metadata above is for sheet 2 (traits_metadata) that correspond to sheet 1 (state_traits).

mvevans89 commented 4 years ago

@rlrichards I can update the metadata for these tomorrow. With the new subdirectory structure it should be much easier to see what metadata goes where and which datasets are missing metadata

mvevans89 commented 4 years ago

Metadata has been added for state traits and state interventions. Closing this issue