6 ms·

Wouldn't this be better served by a downloadable SQLite file rather than a web service?

by DrJokepu 14y ago

mparlane 14y ago
How big do you imagine this file would be ? And I am sure someone could eventually create one..
systematical 14y ago
It's database agnostic this way and every language supports JSON.
- jlarocco 14y ago
  Partly to play devil's advocate and partly out of curiosity, do you know of a language with a JSON library but no SQLite library?
  - alecperkins 14y ago
    Browser-based JavaScript. Their CORS and JSONP support suggests they have this use case in mind.
albertsun 14y ago
The downloadable files for this dataset are much larger than anyone would want to download at one go.
smacktoward 14y ago
The Census Bureau has made their data available for download for a looong time, both over the Web (including a bunch of different interfaces for slicing out just the data you want -- see http://www.census.gov/main/www/access.html http://www.census.gov/main/www/access.html) and FTP (http://www2.census.gov/ http://www2.census.gov/) All the stuff that's available via the Web service is already available via download, along with a lot more. They don't provide it in SQLite format AFAIK, but they do offer a range of other formats that should be easy to get into SQLite if you wish. If there's any problem with their downloadable data offerings, it's that they have so many of them that it can be difficult to figure out exactly which one has the data you're looking for.
Yen 14y ago
for you, and your repliers: this data is already available as a downloadable file. Check out ftp://ftp.census.gov/ It's CSV, and it's kinda ugly-looking, but it's available. The 'full' data set is ...rather huge. The full data set for any particular report is rather huge. The advantage of this API, I expect, is it allows people to make quick, machine readable queries for useful subsets of the data. If you want a JavaScript mashup that tells you the number of people who live on your block, use this. If you want to know the population of every block everywhere for data-crunching purposes, just download the CSV.
- awaythrow 14y ago
  Excellent. Much easier than requesting API keys and parsing JSON. But that's just my opinion. CSV is beautiful. Simple and easy to manipulate into some other format if desired.
  - fennecfoxen 14y ago
    CSV is beautiful - for numbers. When you invoke strings, and quoting, and whatnot, it goes downhill fast. :)
josephcooney 14y ago
As other have already commented, this is already available as a download. You can even fire up an EC2 instance with the data pre-downloaded http://aws.amazon.com/datasets/Economics?_encoding=UTF8&jiveRedirect=1 http://aws.amazon.com/datasets/Economics?_encoding=UTF8&...

Wouldn't this be better served by a downloadable SQLite file rather than a web service?

mparlane 14y ago

How big do you imagine this file would be ? And I am sure someone could eventually create one..

systematical 14y ago

It's database agnostic this way and every language supports JSON.

jlarocco 14y ago
Partly to play devil's advocate and partly out of curiosity, do you know of a language with a JSON library but no SQLite library?
- alecperkins 14y ago
  Browser-based JavaScript. Their CORS and JSONP support suggests they have this use case in mind.

albertsun 14y ago

The downloadable files for this dataset are much larger than anyone would want to download at one go.

smacktoward 14y ago

The Census Bureau has made their data available for download for a looong time, both over the Web (including a bunch of different interfaces for slicing out just the data you want -- see http://www.census.gov/main/www/access.html http://www.census.gov/main/www/access.html) and FTP (http://www2.census.gov/ http://www2.census.gov/) All the stuff that's available via the Web service is already available via download, along with a lot more. They don't provide it in SQLite format AFAIK, but they do offer a range of other formats that should be easy to get into SQLite if you wish. If there's any problem with their downloadable data offerings, it's that they have so many of them that it can be difficult to figure out exactly which one has the data you're looking for.

Yen 14y ago

for you, and your repliers: this data is already available as a downloadable file. Check out ftp://ftp.census.gov/ It's CSV, and it's kinda ugly-looking, but it's available. The 'full' data set is ...rather huge. The full data set for any particular report is rather huge. The advantage of this API, I expect, is it allows people to make quick, machine readable queries for useful subsets of the data. If you want a JavaScript mashup that tells you the number of people who live on your block, use this. If you want to know the population of every block everywhere for data-crunching purposes, just download the CSV.

awaythrow 14y ago
Excellent. Much easier than requesting API keys and parsing JSON. But that's just my opinion. CSV is beautiful. Simple and easy to manipulate into some other format if desired.
- fennecfoxen 14y ago
  CSV is beautiful - for numbers. When you invoke strings, and quoting, and whatnot, it goes downhill fast. :)

josephcooney 14y ago

As other have already commented, this is already available as a download. You can even fire up an EC2 instance with the data pre-downloaded http://aws.amazon.com/datasets/Economics?_encoding=UTF8&jiveRedirect=1 http://aws.amazon.com/datasets/Economics?_encoding=UTF8&...