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
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
) – Joe Dec 27 '14 at 1:46csv
, then usecsvsql
fromcsvkit
: csvkit.readthedocs.org/en/latest – Anton Tarasenko Dec 27 '14 at 22:34