17 Jul
2012
17 Jul
'12
12:47 p.m.
I've noticed that the table codes used in the API requests don't seem to match
the table codes used in the table master lists or in American Fact Finder. For example the
ACS 5-year table number for "Total Population" is B01003, but in the examples of
API requests here<http://www.census.gov/developers/> the table number used to fetch
population statistics for California and New York is B02001_001E, which the master list
would have me believe is the table code for race (plus the "_001E" which
I'm mystified by).
Is there a separate list of table IDs that the API recognizes / am I using the wrong
lists?
Sam Ennis
17 Jul
17 Jul
1:05 p.m.
Look here ( http://www.census.gov/developers/data/2010acs5_variables.xml ) for
the list of tables for which it pulls the data. B*****_**{E,M} gives you
the Estimate and MOE respectively.
On Tue, Jul 17, 2012 at 12:47 PM, Ennis, Samuel <sennis(a)cambridgema.gov>wrote:
I’ve noticed that the table codes used in the API
requests don’t seem to
match the table codes used in the table master lists or in American Fact
Finder. For example the ACS 5-year table number for “Total Population” is
B01003, but in the examples of API requests
here<http://www.census.gov/developers/>the table number used to fetch population
statistics for California and New
York is B02001_001E, which the master list would have me believe is the
table code for race (plus the “_001E” which I’m mystified by). ****
** **
Is there a separate list of table IDs that the API recognizes / am I using
the wrong lists?****
** **
Sam Ennis****
** **
_______________________________________________
ctpp-news mailing list
ctpp-news(a)ryoko.chrispy.net
http://ryoko.chrispy.net/mailman/listinfo/ctpp-news
--
Krishnan Viswanathan
5628 Burnside Circle
Tallahassee FL 32312
1:38 p.m.
B02001 is Race, which includes population. 001E looks suspiciously like the
sort of table designator you find in the downloaded summary file version of
the ACS 5 year data. B02001_001 is the total population there, but I have no
idea what the E is for.
Mara Kaminowitz, GISP
GIS Analyst
.........................................................................
Baltimore Metropolitan Council
Offices at McHenry Row
1500 Whetstone Way
Suite 300
Baltimore, MD 21230
410-732-0500 ext. 1030
<mailto:mkaminowitz(a)baltometro.org> mkaminowitz(a)baltometro.org
www.baltometro.org
From: Ennis, Samuel [mailto:sennis(a)cambridgema.gov]
Sent: Tuesday, July 17, 2012 12:47 PM
To: ctpp-news(a)ryoko.chrispy.net
Subject: [CTPP] API Request Table Codes
I've noticed that the table codes used in the API requests don't seem to
match the table codes used in the table master lists or in American Fact
Finder. For example the ACS 5-year table number for "Total Population" is
B01003, but in the examples of API requests here
<http://www.census.gov/developers/> the table number used to fetch
population statistics for California and New York is B02001_001E, which the
master list would have me believe is the table code for race (plus the
"_001E" which I'm mystified by).
Is there a separate list of table IDs that the API recognizes / am I using
the wrong lists?
Sam Ennis
2:38 p.m.
In looking at http://www2.census.gov/acs2009_5yr/summaryfile/ACS_2005-2009_SF_Tech_Doc.pdf
pg 40, it shows B02001 is race. Unlike the SF1/SF3 documentation, it only lists that and
not the specific tables. In comparing it with AFF2, B02002_001E is table 1 estimate (the
total population). If you put 'M' instead of E, data is returned, that's
the MOE.
For example, try
http://thedataweb.rm.census.gov/data/2010/acs5?key={YOUR_KEY_HERE}&get=…
You should get a response of
[["B02001_001E","B02001_001M","B02001_002E","B02001_002M","NAME","state"],
["36637290","0","22392713","29506","California","06"],
["19229752","0","12764402","12714","New
York","36"]]
If you look at the ACS 2006-2010 estimates through Factfinder2, you will see that
B02001_001E is the total population (and no MOE is published for those), and B02001_002E
and B02001_002M matches the data for the white population and the MOE for those (see below
if you don't want to mess with AFF2).
[cid:image003.jpg(a)01CD6429.CB8A5610]
The API appears to be unfinished. I can't seem to get any household data (not even
total households) pulled from SF1, SF3 returns an error (and we don't know if that
will ever be supported by the API), and there appears to be a limit of pulling 5 fields at
a time (hopefully they release that to allow us to pull at least 12 or 15). Also, I
applied to join the developer's forum and haven't heard anything back. I was
able to get a key to try some tests, though. Hopefully we'll hear and see more in
the next few weeks, as this looks pretty promising.
Andrew Rohne
OKI Regional Council
PS: If you'd rather pull tables with Python as opposed to through URL lines, take a
look at https://gist.github.com/3122936 . If you're on Windows and don't have
Cairoplot and GTK installed, you may want to remove the import for cairoplot and the very
last line and code around the rest. It is simple, but I'd expect people to take it
and change it to suit their own needs.
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf
Of mkaminowitz(a)baltometro.org
Sent: Tuesday, July 17, 2012 1:39 PM
To: ctpp-news(a)chrispy.net
Subject: Re: [CTPP] API Request Table Codes
B02001 is Race, which includes population. 001E looks suspiciously like the sort of table
designator you find in the downloaded summary file version of the ACS 5 year data.
B02001_001 is the total population there, but I have no idea what the E is for.
Mara Kaminowitz, GISP
GIS Analyst
.........................................................................
Baltimore Metropolitan Council
Offices at McHenry Row
1500 Whetstone Way
Suite 300
Baltimore, MD 21230
410-732-0500 ext. 1030
mkaminowitz(a)baltometro.org<mailto:mkaminowitz(a)baltometro.org>
www.baltometro.org<http://www.baltometro.org>
From: Ennis, Samuel [mailto:sennis(a)cambridgema.gov]
Sent: Tuesday, July 17, 2012 12:47 PM
To: ctpp-news(a)ryoko.chrispy.net<mailto:ctpp-news(a)ryoko.chrispy.net>
Subject: [CTPP] API Request Table Codes
I've noticed that the table codes used in the API requests don't seem to match
the table codes used in the table master lists or in American Fact Finder. For example the
ACS 5-year table number for "Total Population" is B01003, but in the examples of
API requests here<http://www.census.gov/developers/> the table number used to fetch
population statistics for California and New York is B02001_001E, which the master list
would have me believe is the table code for race (plus the "_001E" which
I'm mystified by).
Is there a separate list of table IDs that the API recognizes / am I using the wrong
lists?
Sam Ennis
24 Jul
24 Jul
2:33 p.m.
Has anyone had any luck getting approved by the API developer forum? I've been in
moderator-approval-limbo for the last week and I'm curious what other people are
putting together.
Sam Ennis
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf
Of Andrew Rohne
Sent: Tuesday, July 17, 2012 2:38 PM
To: ctpp-news(a)chrispy.net
Subject: Re: [CTPP] API Request Table Codes
In looking at http://www2.census.gov/acs2009_5yr/summaryfile/ACS_2005-2009_SF_Tech_Doc.pdf
pg 40, it shows B02001 is race. Unlike the SF1/SF3 documentation, it only lists that and
not the specific tables. In comparing it with AFF2, B02002_001E is table 1 estimate (the
total population). If you put 'M' instead of E, data is returned, that's
the MOE.
For example, try
http://thedataweb.rm.census.gov/data/2010/acs5?key={YOUR_KEY_HERE}&get=…
You should get a response of
[["B02001_001E","B02001_001M","B02001_002E","B02001_002M","NAME","state"],
["36637290","0","22392713","29506","California","06"],
["19229752","0","12764402","12714","New
York","36"]]
If you look at the ACS 2006-2010 estimates through Factfinder2, you will see that
B02001_001E is the total population (and no MOE is published for those), and B02001_002E
and B02001_002M matches the data for the white population and the MOE for those (see below
if you don't want to mess with AFF2).
[cid:image001.jpg(a)01CD69A9.460FEA10]
The API appears to be unfinished. I can't seem to get any household data (not even
total households) pulled from SF1, SF3 returns an error (and we don't know if that
will ever be supported by the API), and there appears to be a limit of pulling 5 fields at
a time (hopefully they release that to allow us to pull at least 12 or 15). Also, I
applied to join the developer's forum and haven't heard anything back. I was
able to get a key to try some tests, though. Hopefully we'll hear and see more in
the next few weeks, as this looks pretty promising.
Andrew Rohne
OKI Regional Council
PS: If you'd rather pull tables with Python as opposed to through URL lines, take a
look at https://gist.github.com/3122936 . If you're on Windows and don't have
Cairoplot and GTK installed, you may want to remove the import for cairoplot and the very
last line and code around the rest. It is simple, but I'd expect people to take it
and change it to suit their own needs.
From: ctpp-news-bounces(a)chrispy.net<mailto:ctpp-news-bounces(a)chrispy.net>
[mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of
mkaminowitz(a)baltometro.org<mailto:mkaminowitz(a)baltometro.org>
Sent: Tuesday, July 17, 2012 1:39 PM
To: ctpp-news(a)chrispy.net<mailto:ctpp-news(a)chrispy.net>
Subject: Re: [CTPP] API Request Table Codes
B02001 is Race, which includes population. 001E looks suspiciously like the sort of table
designator you find in the downloaded summary file version of the ACS 5 year data.
B02001_001 is the total population there, but I have no idea what the E is for.
Mara Kaminowitz, GISP
GIS Analyst
.........................................................................
Baltimore Metropolitan Council
Offices at McHenry Row
1500 Whetstone Way
Suite 300
Baltimore, MD 21230
410-732-0500 ext. 1030
mkaminowitz(a)baltometro.org<mailto:mkaminowitz(a)baltometro.org>
www.baltometro.org<http://www.baltometro.org>
From: Ennis, Samuel [mailto:sennis(a)cambridgema.gov]
Sent: Tuesday, July 17, 2012 12:47 PM
To: ctpp-news(a)ryoko.chrispy.net<mailto:ctpp-news(a)ryoko.chrispy.net>
Subject: [CTPP] API Request Table Codes
I've noticed that the table codes used in the API requests don't seem to match
the table codes used in the table master lists or in American Fact Finder. For example the
ACS 5-year table number for "Total Population" is B01003, but in the examples of
API requests here<http://www.census.gov/developers/> the table number used to fetch
population statistics for California and New York is B02001_001E, which the master list
would have me believe is the table code for race (plus the "_001E" which
I'm mystified by).
Is there a separate list of table IDs that the API recognizes / am I using the wrong
lists?
Sam Ennis
3:07 p.m.
Sam-
I have applied and currently in the same moderator-approval-limbo since a day after the
API was announced here.
I share your same curiosity as to what others are doing. I haven't done much (other
than what I have posted here), but if I do anything the first way to see it is on Github
(you can follow me on there if you use it at github.com/okiandrew). The second way to see
it is twitter (@okiAndrew). Hopefully both of these tools are not blocked for you.
Andrew Rohne
OKI Regional Council
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf
Of Ennis, Samuel
Sent: Tuesday, July 24, 2012 2:33 PM
To: ctpp-news(a)chrispy.net
Subject: Re: [CTPP] API Request Table Codes
Has anyone had any luck getting approved by the API developer forum? I've been in
moderator-approval-limbo for the last week and I'm curious what other people are
putting together.
Sam Ennis
From: ctpp-news-bounces(a)chrispy.net<mailto:ctpp-news-bounces(a)chrispy.net>
[mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Andrew Rohne
Sent: Tuesday, July 17, 2012 2:38 PM
To: ctpp-news(a)chrispy.net<mailto:ctpp-news(a)chrispy.net>
Subject: Re: [CTPP] API Request Table Codes
In looking at http://www2.census.gov/acs2009_5yr/summaryfile/ACS_2005-2009_SF_Tech_Doc.pdf
pg 40, it shows B02001 is race. Unlike the SF1/SF3 documentation, it only lists that and
not the specific tables. In comparing it with AFF2, B02002_001E is table 1 estimate (the
total population). If you put 'M' instead of E, data is returned, that's
the MOE.
For example, try
http://thedataweb.rm.census.gov/data/2010/acs5?key={YOUR_KEY_HERE}&get=…
You should get a response of
[["B02001_001E","B02001_001M","B02001_002E","B02001_002M","NAME","state"],
["36637290","0","22392713","29506","California","06"],
["19229752","0","12764402","12714","New
York","36"]]
If you look at the ACS 2006-2010 estimates through Factfinder2, you will see that
B02001_001E is the total population (and no MOE is published for those), and B02001_002E
and B02001_002M matches the data for the white population and the MOE for those (see below
if you don't want to mess with AFF2).
[cid:image001.jpg(a)01CD69AD.E6D09360]
The API appears to be unfinished. I can't seem to get any household data (not even
total households) pulled from SF1, SF3 returns an error (and we don't know if that
will ever be supported by the API), and there appears to be a limit of pulling 5 fields at
a time (hopefully they release that to allow us to pull at least 12 or 15). Also, I
applied to join the developer's forum and haven't heard anything back. I was
able to get a key to try some tests, though. Hopefully we'll hear and see more in
the next few weeks, as this looks pretty promising.
Andrew Rohne
OKI Regional Council
PS: If you'd rather pull tables with Python as opposed to through URL lines, take a
look at https://gist.github.com/3122936 . If you're on Windows and don't have
Cairoplot and GTK installed, you may want to remove the import for cairoplot and the very
last line and code around the rest. It is simple, but I'd expect people to take it
and change it to suit their own needs.
From: ctpp-news-bounces(a)chrispy.net<mailto:ctpp-news-bounces(a)chrispy.net>
[mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of
mkaminowitz(a)baltometro.org<mailto:mkaminowitz(a)baltometro.org>
Sent: Tuesday, July 17, 2012 1:39 PM
To: ctpp-news(a)chrispy.net<mailto:ctpp-news(a)chrispy.net>
Subject: Re: [CTPP] API Request Table Codes
B02001 is Race, which includes population. 001E looks suspiciously like the sort of table
designator you find in the downloaded summary file version of the ACS 5 year data.
B02001_001 is the total population there, but I have no idea what the E is for.
Mara Kaminowitz, GISP
GIS Analyst
.........................................................................
Baltimore Metropolitan Council
Offices at McHenry Row
1500 Whetstone Way
Suite 300
Baltimore, MD 21230
410-732-0500 ext. 1030
mkaminowitz(a)baltometro.org<mailto:mkaminowitz(a)baltometro.org>
www.baltometro.org<http://www.baltometro.org>
From: Ennis, Samuel [mailto:sennis(a)cambridgema.gov]
Sent: Tuesday, July 17, 2012 12:47 PM
To: ctpp-news(a)ryoko.chrispy.net<mailto:ctpp-news(a)ryoko.chrispy.net>
Subject: [CTPP] API Request Table Codes
I've noticed that the table codes used in the API requests don't seem to match
the table codes used in the table master lists or in American Fact Finder. For example the
ACS 5-year table number for "Total Population" is B01003, but in the examples of
API requests here<http://www.census.gov/developers/> the table number used to fetch
population statistics for California and New York is B02001_001E, which the master list
would have me believe is the table code for race (plus the "_001E" which
I'm mystified by).
Is there a separate list of table IDs that the API recognizes / am I using the wrong
lists?
Sam Ennis
3:30 p.m.
Hi Everyone -
I am glad to hear that several of you are TRYING to get into this forum! I have passed
the problem along to someone in the ACS office, and perhaps they will be able to figure
out the problem soon.
Elaine
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf
Of Andrew Rohne
Sent: Tuesday, July 24, 2012 12:08 PM
To: ctpp-news(a)chrispy.net
Subject: Re: [CTPP] API Request Table Codes
Sam-
I have applied and currently in the same moderator-approval-limbo since a day after the
API was announced here.
I share your same curiosity as to what others are doing. I haven't done much (other
than what I have posted here), but if I do anything the first way to see it is on Github
(you can follow me on there if you use it at github.com/okiandrew). The second way to see
it is twitter (@okiAndrew). Hopefully both of these tools are not blocked for you.
Andrew Rohne
OKI Regional Council
From: ctpp-news-bounces(a)chrispy.net<mailto:ctpp-news-bounces(a)chrispy.net>
[mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Ennis, Samuel
Sent: Tuesday, July 24, 2012 2:33 PM
To: ctpp-news(a)chrispy.net<mailto:ctpp-news(a)chrispy.net>
Subject: Re: [CTPP] API Request Table Codes
Has anyone had any luck getting approved by the API developer forum? I've been in
moderator-approval-limbo for the last week and I'm curious what other people are
putting together.
Sam Ennis
From: ctpp-news-bounces(a)chrispy.net<mailto:ctpp-news-bounces(a)chrispy.net>
[mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Andrew Rohne
Sent: Tuesday, July 17, 2012 2:38 PM
To: ctpp-news(a)chrispy.net<mailto:ctpp-news(a)chrispy.net>
Subject: Re: [CTPP] API Request Table Codes
In looking at http://www2.census.gov/acs2009_5yr/summaryfile/ACS_2005-2009_SF_Tech_Doc.pdf
pg 40, it shows B02001 is race. Unlike the SF1/SF3 documentation, it only lists that and
not the specific tables. In comparing it with AFF2, B02002_001E is table 1 estimate (the
total population). If you put 'M' instead of E, data is returned, that's
the MOE.
For example, try
http://thedataweb.rm.census.gov/data/2010/acs5?key={YOUR_KEY_HERE}&get=…
You should get a response of
[["B02001_001E","B02001_001M","B02001_002E","B02001_002M","NAME","state"],
["36637290","0","22392713","29506","California","06"],
["19229752","0","12764402","12714","New
York","36"]]
If you look at the ACS 2006-2010 estimates through Factfinder2, you will see that
B02001_001E is the total population (and no MOE is published for those), and B02001_002E
and B02001_002M matches the data for the white population and the MOE for those (see below
if you don't want to mess with AFF2).
[cid:image001.jpg(a)01CD6998.12D448A0]
The API appears to be unfinished. I can't seem to get any household data (not even
total households) pulled from SF1, SF3 returns an error (and we don't know if that
will ever be supported by the API), and there appears to be a limit of pulling 5 fields at
a time (hopefully they release that to allow us to pull at least 12 or 15). Also, I
applied to join the developer's forum and haven't heard anything back. I was
able to get a key to try some tests, though. Hopefully we'll hear and see more in
the next few weeks, as this looks pretty promising.
Andrew Rohne
OKI Regional Council
PS: If you'd rather pull tables with Python as opposed to through URL lines, take a
look at https://gist.github.com/3122936 . If you're on Windows and don't have
Cairoplot and GTK installed, you may want to remove the import for cairoplot and the very
last line and code around the rest. It is simple, but I'd expect people to take it
and change it to suit their own needs.
From: ctpp-news-bounces(a)chrispy.net<mailto:ctpp-news-bounces(a)chrispy.net>
[mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of
mkaminowitz(a)baltometro.org<mailto:mkaminowitz(a)baltometro.org>
Sent: Tuesday, July 17, 2012 1:39 PM
To: ctpp-news(a)chrispy.net<mailto:ctpp-news(a)chrispy.net>
Subject: Re: [CTPP] API Request Table Codes
B02001 is Race, which includes population. 001E looks suspiciously like the sort of table
designator you find in the downloaded summary file version of the ACS 5 year data.
B02001_001 is the total population there, but I have no idea what the E is for.
Mara Kaminowitz, GISP
GIS Analyst
.........................................................................
Baltimore Metropolitan Council
Offices at McHenry Row
1500 Whetstone Way
Suite 300
Baltimore, MD 21230
410-732-0500 ext. 1030
mkaminowitz(a)baltometro.org<mailto:mkaminowitz(a)baltometro.org>
www.baltometro.org<http://www.baltometro.org>
From: Ennis, Samuel [mailto:sennis(a)cambridgema.gov]
Sent: Tuesday, July 17, 2012 12:47 PM
To: ctpp-news(a)ryoko.chrispy.net<mailto:ctpp-news(a)ryoko.chrispy.net>
Subject: [CTPP] API Request Table Codes
I've noticed that the table codes used in the API requests don't seem to match
the table codes used in the table master lists or in American Fact Finder. For example the
ACS 5-year table number for "Total Population" is B01003, but in the examples of
API requests here<http://www.census.gov/developers/> the table number used to fetch
population statistics for California and New York is B02001_001E, which the master list
would have me believe is the table code for race (plus the "_001E" which
I'm mystified by).
Is there a separate list of table IDs that the API recognizes / am I using the wrong
lists?
Sam Ennis
3:50 p.m.
I've run into the same limitations for number of tables, but I haven't run into
a similar limit on census tracts; I'm able to grab 5 tables for 30 census tracts at a
time with no snags. I would guess (although I haven't tested it) that it's the
same for other region types.
Sam Ennis
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf
Of Andrew Rohne
Sent: Tuesday, July 17, 2012 2:38 PM
To: ctpp-news(a)chrispy.net
Subject: Re: [CTPP] API Request Table Codes
In looking at http://www2.census.gov/acs2009_5yr/summaryfile/ACS_2005-2009_SF_Tech_Doc.pdf
pg 40, it shows B02001 is race. Unlike the SF1/SF3 documentation, it only lists that and
not the specific tables. In comparing it with AFF2, B02002_001E is table 1 estimate (the
total population). If you put 'M' instead of E, data is returned, that's
the MOE.
For example, try
http://thedataweb.rm.census.gov/data/2010/acs5?key={YOUR_KEY_HERE}&get=…
You should get a response of
[["B02001_001E","B02001_001M","B02001_002E","B02001_002M","NAME","state"],
["36637290","0","22392713","29506","California","06"],
["19229752","0","12764402","12714","New
York","36"]]
If you look at the ACS 2006-2010 estimates through Factfinder2, you will see that
B02001_001E is the total population (and no MOE is published for those), and B02001_002E
and B02001_002M matches the data for the white population and the MOE for those (see below
if you don't want to mess with AFF2).
[cid:image001.jpg(a)01CD69B3.47511110]
The API appears to be unfinished. I can't seem to get any household data (not even
total households) pulled from SF1, SF3 returns an error (and we don't know if that
will ever be supported by the API), and there appears to be a limit of pulling 5 fields at
a time (hopefully they release that to allow us to pull at least 12 or 15). Also, I
applied to join the developer's forum and haven't heard anything back. I was
able to get a key to try some tests, though. Hopefully we'll hear and see more in
the next few weeks, as this looks pretty promising.
Andrew Rohne
OKI Regional Council
PS: If you'd rather pull tables with Python as opposed to through URL lines, take a
look at https://gist.github.com/3122936 . If you're on Windows and don't have
Cairoplot and GTK installed, you may want to remove the import for cairoplot and the very
last line and code around the rest. It is simple, but I'd expect people to take it
and change it to suit their own needs.
From: ctpp-news-bounces(a)chrispy.net<mailto:ctpp-news-bounces(a)chrispy.net>
[mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of
mkaminowitz(a)baltometro.org<mailto:mkaminowitz(a)baltometro.org>
Sent: Tuesday, July 17, 2012 1:39 PM
To: ctpp-news(a)chrispy.net<mailto:ctpp-news(a)chrispy.net>
Subject: Re: [CTPP] API Request Table Codes
B02001 is Race, which includes population. 001E looks suspiciously like the sort of table
designator you find in the downloaded summary file version of the ACS 5 year data.
B02001_001 is the total population there, but I have no idea what the E is for.
Mara Kaminowitz, GISP
GIS Analyst
.........................................................................
Baltimore Metropolitan Council
Offices at McHenry Row
1500 Whetstone Way
Suite 300
Baltimore, MD 21230
410-732-0500 ext. 1030
mkaminowitz(a)baltometro.org<mailto:mkaminowitz(a)baltometro.org>
www.baltometro.org<http://www.baltometro.org>
From: Ennis, Samuel [mailto:sennis(a)cambridgema.gov]
Sent: Tuesday, July 17, 2012 12:47 PM
To: ctpp-news(a)ryoko.chrispy.net<mailto:ctpp-news(a)ryoko.chrispy.net>
Subject: [CTPP] API Request Table Codes
I've noticed that the table codes used in the API requests don't seem to match
the table codes used in the table master lists or in American Fact Finder. For example the
ACS 5-year table number for "Total Population" is B01003, but in the examples of
API requests here<http://www.census.gov/developers/> the table number used to fetch
population statistics for California and New York is B02001_001E, which the master list
would have me believe is the table code for race (plus the "_001E" which
I'm mystified by).
Is there a separate list of table IDs that the API recognizes / am I using the wrong
lists?
Sam Ennis
4757
days inactive
4764
days old
ctpp@listserv.transportation.org
7 comments
5 participants
participants (5)
-
Andrew Rohne -
Elaine.Murakami＠dot.gov -
Ennis -
Krishnan Viswanathan -
mkaminowitz＠baltometro.org