Is there a place where I can find gov datasets (from data.gov, bea etc) in MySQL format? - free or paid. I could download and parse the files of course, but wanted to check if it is already available somewhere before going down that route
1 Answer
you can search data.gov, this search returns over 300:
http://catalog.data.gov/dataset?q=MySQL&sort=score+desc%2C+name+asc
and this search within datasets hosted by data.gov reveals 12:
http://www.data.gov/search-results?group=site&q=MySQL
INSERT
statements -- you want CSV or tab-deliminated, and useLOAD DATA
. And there is no specific 'mySQL format' (or any SQL 'format' for data ... although some might give sufficient info to generate theCREATE TABLE
)csv
, then usecsvsql
fromcsvkit
: csvkit.readthedocs.org/en/latest