BIDS-collaborative / cega-trace

Pilot study tracing influence of research studies on public policy
BSD 2-Clause "Simplified" License
4 stars 3 forks source link

Develop DB Schema #8

Open davclark opened 8 years ago

davclark commented 8 years ago

(First of two issues from slides today - trying to help you organize in a way that I can see what's going on!)

This can start pretty simple - it can just be the format of a CSV table that you're going to develop, or a google spreadsheet.

But it will be good to be explicit about what columns of data will go into answering your questions. Maybe also include the output table formats - like the table in the slideshow from today!

renai33 commented 8 years ago

Aid data link http://aiddata.org/aiddata-research-releases

davclark commented 8 years ago

It seems that this issue has drifted away from being about a DB schema (the format you want to standardize all of your records into) and more about queries (how to get the data in the first place).

I think they're both relevant issues, but deserve separate issues!