Documentation
> Workflows & Code
> Explore Metadata
> NHGIS
> Time Series Metadata
IPUMS NHGIS Time Series Metadata
An NHGIS time series table links together comparable statistics from multiple datasets into one table. An in-depth introduction and a full catalog of NHGIS time series tables are availble on the NHGIS website.
Get High-Level Metadata for Time Series Tables
This API call will return a list of all available time series tables. The entry for each time series table includes metadata for the table’s description, geographic levels, year availability, and geographic integration. The unique identifier for each time series table is in the name field. This is needed for retrieving details about a single time series table (see next section).
my_headers = {"Authorization": my_key}
url = "https://api.ipums.org/metadata/time_series_tables?collection=nhgis&version=2&pageSize=10"
nhgis_metadata = requests.get(url, headers=my_headers)
pprint(nhgis_metadata.json())
# Results
{ 'data': [ { 'description': 'Total Population',
'geogLevels': [ { 'description': 'State',
'name': 'state',
'sequence': 4},
{ 'description': 'State--County',
'name': 'county',
'sequence': 25}],
'geographicIntegration': 'Nominal',
'name': 'A00',
'sequence': 100.01,
'timeSeries': [ { 'description': 'Persons: Total',
'name': 'AA',
'sequence': 1}],
'years': [ {'description': '1790', 'name': '1790', 'sequence': 1},
{'description': '1800', 'name': '1800', 'sequence': 2},
{'description': '1810', 'name': '1810', 'sequence': 3},
{'description': '1820', 'name': '1820', 'sequence': 4},
{'description': '1830', 'name': '1830', 'sequence': 5},
{'description': '1840', 'name': '1840', 'sequence': 6},
{'description': '1850', 'name': '1850', 'sequence': 7},
{'description': '1860', 'name': '1860', 'sequence': 8},
{ 'description': '1870',
'name': '1870',
'sequence': 12},
{ 'description': '1880',
'name': '1880',
'sequence': 22},
{ 'description': '1890',
'name': '1890',
'sequence': 29},
{ 'description': '1900',
'name': '1900',
'sequence': 30},
{ 'description': '1910',
'name': '1910',
'sequence': 32},
{ 'description': '1920',
'name': '1920',
'sequence': 38},
{ 'description': '1930',
'name': '1930',
'sequence': 48},
{ 'description': '1940',
'name': '1940',
'sequence': 58},
{ 'description': '1950',
'name': '1950',
'sequence': 68},
{ 'description': '1960',
'name': '1960',
'sequence': 78},
{ 'description': '1970',
'name': '1970',
'sequence': 88},
{ 'description': '1980',
'name': '1980',
'sequence': 98},
{ 'description': '1990',
'name': '1990',
'sequence': 108},
{ 'description': '2000',
'name': '2000',
'sequence': 118},
{ 'description': '2010',
'name': '2010',
'sequence': 131},
{ 'description': '2020',
'name': '2020',
'sequence': 155}]},
{ 'description': 'Total Population',
'geogLevels': [ { 'description': 'State',
'name': 'state',
'hasGeogExtentSelection': true,
'sequence': 4},
{ 'description': 'State--County',
'name': 'county',
'hasGeogExtentSelection': true,
'sequence': 25},
{ 'description': 'State--County--Census Tract',
'name': 'tract',
'hasGeogExtentSelection': true,
'sequence': 65},
{ 'description': 'State--County--County '
'Subdivision',
'name': 'cty_sub',
'hasGeogExtentSelection': true,
'sequence': 100},
{ 'description': 'State--Place',
'name': 'place',
'hasGeogExtentSelection': true,
'sequence': 145}],
'geographicIntegration': 'Nominal',
'name': 'AV0',
'sequence': 100.02,
'timeSeries': [ { 'description': 'Persons: Total',
'name': 'AA',
'sequence': 1}],
'years': [ { 'description': '1970',
'name': '1970',
'sequence': 88},
{ 'description': '1980',
'name': '1980',
'sequence': 98},
{ 'description': '1990',
'name': '1990',
'sequence': 108},
{ 'description': '2000',
'name': '2000',
'sequence': 118},
{ 'description': '2010',
'name': '2010',
'sequence': 131},
{ 'description': '2006-2010',
'name': '105',
'sequence': 133},
{ 'description': '2007-2011',
'name': '115',
'sequence': 136},
{ 'description': '2008-2012',
'name': '125',
'sequence': 139},
{ 'description': '2009-2013',
'name': '135',
'sequence': 142},
{ 'description': '2010-2014',
'name': '145',
'sequence': 144},
{ 'description': '2011-2015',
'name': '155',
'sequence': 146},
{ 'description': '2012-2016',
'name': '165',
'sequence': 148},
{ 'description': '2013-2017',
'name': '175',
'sequence': 150},
{ 'description': '2014-2018',
'name': '185',
'sequence': 152},
{ 'description': '2015-2019',
'name': '195',
'sequence': 154},
{ 'description': '2020',
'name': '2020',
'sequence': 155},
{ 'description': '2016-2020',
'name': '205',
'sequence': 156}]},
{ 'description': 'Total Population',
'geogLevels': [ { 'description': 'Nation',
'name': 'nation',
'hasGeogExtentSelection': false,
'sequence': 1},
{ 'description': 'Region',
'name': 'region',
'hasGeogExtentSelection': false,
'sequence': 2},
{ 'description': 'Division',
'name': 'division',
'hasGeogExtentSelection': false,
'sequence': 3},
{ 'description': 'State',
'name': 'state',
'hasGeogExtentSelection': true,
'sequence': 4},
{ 'description': 'State--County',
'name': 'county',
'hasGeogExtentSelection': true,
'sequence': 25},
{ 'description': 'State--County--Census Tract',
'name': 'tract',
'hasGeogExtentSelection': true,
'sequence': 65},
{ 'description': 'State--County--County '
'Subdivision',
'name': 'cty_sub',
'hasGeogExtentSelection': true,
'sequence': 100},
{ 'description': 'State--Place',
'name': 'place',
'hasGeogExtentSelection': true,
'sequence': 145}],
'geographicIntegration': 'Nominal',
'name': 'B78',
'sequence': 100.03,
'timeSeries': [ { 'description': 'Persons: Total',
'name': 'AA',
'sequence': 1}],
'years': [ { 'description': '1980',
'name': '1980',
'sequence': 98},
{ 'description': '1990',
'name': '1990',
'sequence': 108},
{ 'description': '2000',
'name': '2000',
'sequence': 118},
{ 'description': '2010',
'name': '2010',
'sequence': 131},
{ 'description': '2006-2010',
'name': '105',
'sequence': 133},
{ 'description': '2007-2011',
'name': '115',
'sequence': 136},
{ 'description': '2008-2012',
'name': '125',
'sequence': 139},
{ 'description': '2009-2013',
'name': '135',
'sequence': 142},
{ 'description': '2010-2014',
'name': '145',
'sequence': 144},
{ 'description': '2011-2015',
'name': '155',
'sequence': 146},
{ 'description': '2012-2016',
'name': '165',
'sequence': 148},
{ 'description': '2013-2017',
'name': '175',
'sequence': 150},
{ 'description': '2014-2018',
'name': '185',
'sequence': 152},
{ 'description': '2015-2019',
'name': '195',
'sequence': 154},
{ 'description': '2020',
'name': '2020',
'sequence': 155},
{ 'description': '2016-2020',
'name': '205',
'sequence': 156}]},
{ 'description': 'Total Population',
'geogLevels': [ { 'description': 'State',
'name': 'state',
'hasGeogExtentSelection': true,
'sequence': 4},
{ 'description': 'State--County',
'name': 'county',
'hasGeogExtentSelection': true,
'sequence': 25},
{ 'description': 'State--County--Census Tract',
'name': 'tract',
'hasGeogExtentSelection': true,
'sequence': 65},
{ 'description': 'State--County--Census '
'Tract--Block Group',
'name': 'blck_grp',
'hasGeogExtentSelection': true,
'sequence': 83},
{ 'description': 'State--County--County '
'Subdivision',
'name': 'cty_sub',
'hasGeogExtentSelection': true,
'sequence': 100},
{ 'description': 'State--Place',
'name': 'place',
'hasGeogExtentSelection': true,
'sequence': 145},
{ 'description': 'State--Congressional District '
'(2007-2013, 110th-112th '
'Congress)',
'name': 'cd111th',
'hasGeogExtentSelection': true,
'sequence': 210},
{ 'description': 'Metropolitan Statistical '
'Area/Micropolitan Statistical '
'Area',
'name': 'cbsa',
'hasGeogExtentSelection': false,
'sequence': 319},
{ 'description': 'Urban Area',
'name': 'urb_area',
'hasGeogExtentSelection': false,
'sequence': 353},
{ 'description': '5-Digit ZIP Code Tabulation '
'Area',
'name': 'zcta',
'hasGeogExtentSelection': false,
'sequence': 363}],
'geographicIntegration': 'Standardized to 2010',
'name': 'CL8',
'sequence': 100.04,
'timeSeries': [ { 'description': 'Persons: Total',
'name': 'AA',
'sequence': 1}],
'years': [ { 'description': '1990',
'name': '1990',
'sequence': 108},
{ 'description': '2000',
'name': '2000',
'sequence': 118},
{ 'description': '2010',
'name': '2010',
'sequence': 131},
{ 'description': '2020',
'name': '2020',
'sequence': 155}]},
{ 'description': 'Persons by Urban/Rural Status [4]',
'geogLevels': [ { 'description': 'State',
'name': 'state',
'hasGeogExtentSelection': true,
'sequence': 4},
{ 'description': 'State--County',
'name': 'county',
'hasGeogExtentSelection': true,
'sequence': 25},
{ 'description': 'State--County--County '
'Subdivision',
'name': 'cty_sub',
'hasGeogExtentSelection': true,
'sequence': 100},
{ 'description': 'State--Place',
'name': 'place',
'hasGeogExtentSelection': true,
'sequence': 145}],
'geographicIntegration': 'Nominal',
'name': 'A57',
'sequence': 101.01,
'timeSeries': [ { 'description': 'Persons: Urban',
'name': 'AA',
'sequence': 1},
{ 'description': 'Persons: Urban--Inside '
'urbanized areas',
'name': 'AB',
'sequence': 2},
{ 'description': 'Persons: Urban--Outside '
'urbanized areas (in urban '
'clusters)',
'name': 'AC',
'sequence': 3},
{ 'description': 'Persons: Rural',
'name': 'AD',
'sequence': 4}],
'years': [ { 'description': '1970',
'name': '1970',
'sequence': 88},
{ 'description': '1980',
'name': '1980',
'sequence': 98},
{ 'description': '1990',
'name': '1990',
'sequence': 108},
{ 'description': '2000',
'name': '2000',
'sequence': 118},
{ 'description': '2010',
'name': '2010',
'sequence': 131}]},
{ 'description': 'Persons by Urban/Rural Status [4]',
'geogLevels': [ { 'description': 'Nation',
'name': 'nation',
'hasGeogExtentSelection': false,
'sequence': 1},
{ 'description': 'Region',
'name': 'region',
'hasGeogExtentSelection': false,
'sequence': 2},
{ 'description': 'Division',
'name': 'division',
'hasGeogExtentSelection': false,
'sequence': 3},
{ 'description': 'State',
'name': 'state',
'hasGeogExtentSelection': true,
'sequence': 4},
{ 'description': 'State--County',
'name': 'county',
'hasGeogExtentSelection': true,
'sequence': 25},
{ 'description': 'State--County--Census Tract',
'name': 'tract',
'hasGeogExtentSelection': true,
'sequence': 65},
{ 'description': 'State--County--County '
'Subdivision',
'name': 'cty_sub',
'hasGeogExtentSelection': true,
'sequence': 100},
{ 'description': 'State--Place',
'name': 'place',
'hasGeogExtentSelection': true,
'sequence': 145}],
'geographicIntegration': 'Nominal',
'name': 'A59',
'sequence': 101.02,
'timeSeries': [ { 'description': 'Persons: Urban',
'name': 'AA',
'sequence': 1},
{ 'description': 'Persons: Urban--Inside '
'urbanized areas',
'name': 'AB',
'sequence': 2},
{ 'description': 'Persons: Urban--Outside '
'urbanized areas (in urban '
'clusters)',
'name': 'AC',
'sequence': 3},
{ 'description': 'Persons: Rural',
'name': 'AD',
'sequence': 4}],
'years': [ { 'description': '1980',
'name': '1980',
'sequence': 98},
{ 'description': '1990',
'name': '1990',
'sequence': 108},
{ 'description': '2000',
'name': '2000',
'sequence': 118},
{ 'description': '2010',
'name': '2010',
'sequence': 131}]},
{ 'description': 'Persons by Urban/Rural Status [4]',
'geogLevels': [ { 'description': 'State',
'name': 'state',
'hasGeogExtentSelection': true,
'sequence': 4},
{ 'description': 'State--County',
'name': 'county',
'hasGeogExtentSelection': true,
'sequence': 25},
{ 'description': 'State--County--Census Tract',
'name': 'tract',
'hasGeogExtentSelection': true,
'sequence': 65},
{ 'description': 'State--County--Census '
'Tract--Block Group',
'name': 'blck_grp',
'hasGeogExtentSelection': true,
'sequence': 83},
{ 'description': 'State--County--County '
'Subdivision',
'name': 'cty_sub',
'hasGeogExtentSelection': true,
'sequence': 100},
{ 'description': 'State--Place',
'name': 'place',
'hasGeogExtentSelection': true,
'sequence': 145},
{ 'description': 'State--Congressional District '
'(2007-2013, 110th-112th '
'Congress)',
'name': 'cd111th',
'hasGeogExtentSelection': true,
'sequence': 210},
{ 'description': 'Metropolitan Statistical '
'Area/Micropolitan Statistical '
'Area',
'name': 'cbsa',
'hasGeogExtentSelection': false,
'sequence': 319},
{ 'description': 'Urban Area',
'name': 'urb_area',
'hasGeogExtentSelection': false,
'sequence': 353},
{ 'description': '5-Digit ZIP Code Tabulation '
'Area',
'name': 'zcta',
'hasGeogExtentSelection': false,
'sequence': 363}],
'geographicIntegration': 'Standardized to 2010',
'name': 'CL9',
'sequence': 101.03,
'timeSeries': [ { 'description': 'Persons: Urban',
'name': 'AA',
'sequence': 1},
{ 'description': 'Persons: Urban--Inside '
'urbanized areas',
'name': 'AB',
'sequence': 2},
{ 'description': 'Persons: Urban--Outside '
'urbanized areas (in urban '
'clusters)',
'name': 'AC',
'sequence': 3},
{ 'description': 'Persons: Rural',
'name': 'AD',
'sequence': 4}],
'years': [ { 'description': '1990',
'name': '1990',
'sequence': 108},
{ 'description': '2000',
'name': '2000',
'sequence': 118},
{ 'description': '2010',
'name': '2010',
'sequence': 131}]},
{ 'description': 'Persons by Sex [2]',
'geogLevels': [ { 'description': 'State',
'name': 'state',
'hasGeogExtentSelection': true,
'sequence': 4},
{ 'description': 'State--County',
'name': 'county',
'hasGeogExtentSelection': true,
'sequence': 25}],
'geographicIntegration': 'Nominal',
'name': 'A08',
'sequence': 102.01,
'timeSeries': [ { 'description': 'Persons: Male',
'name': 'AA',
'sequence': 1},
{ 'description': 'Persons: Female',
'name': 'AB',
'sequence': 2}],
'years': [ {'description': '1820', 'name': '1820', 'sequence': 4},
{'description': '1830', 'name': '1830', 'sequence': 5},
{'description': '1840', 'name': '1840', 'sequence': 6},
{'description': '1850', 'name': '1850', 'sequence': 7},
{'description': '1860', 'name': '1860', 'sequence': 8},
{ 'description': '1870',
'name': '1870',
'sequence': 12},
{ 'description': '1880',
'name': '1880',
'sequence': 22},
{ 'description': '1890',
'name': '1890',
'sequence': 29},
{ 'description': '1900',
'name': '1900',
'sequence': 30},
{ 'description': '1910',
'name': '1910',
'sequence': 32},
{ 'description': '1920',
'name': '1920',
'sequence': 38},
{ 'description': '1930',
'name': '1930',
'sequence': 48},
{ 'description': '1940',
'name': '1940',
'sequence': 58},
{ 'description': '1950',
'name': '1950',
'sequence': 68},
{ 'description': '1960',
'name': '1960',
'sequence': 78},
{ 'description': '1970',
'name': '1970',
'sequence': 88},
{ 'description': '1980',
'name': '1980',
'sequence': 98},
{ 'description': '1990',
'name': '1990',
'sequence': 108},
{ 'description': '2000',
'name': '2000',
'sequence': 118},
{ 'description': '2010',
'name': '2010',
'sequence': 131}]},
{ 'description': 'Persons by Sex [2]',
'geogLevels': [ { 'description': 'State',
'name': 'state',
'hasGeogExtentSelection': true,
'sequence': 4},
{ 'description': 'State--County',
'name': 'county',
'hasGeogExtentSelection': true,
'sequence': 25},
{ 'description': 'State--County--Census Tract',
'name': 'tract',
'hasGeogExtentSelection': true,
'sequence': 65},
{ 'description': 'State--County--County '
'Subdivision',
'name': 'cty_sub',
'hasGeogExtentSelection': true,
'sequence': 100},
{ 'description': 'State--Place',
'name': 'place',
'hasGeogExtentSelection': true,
'sequence': 145}],
'geographicIntegration': 'Nominal',
'name': 'AV1',
'sequence': 102.02,
'timeSeries': [ { 'description': 'Persons: Male',
'name': 'AA',
'sequence': 1},
{ 'description': 'Persons: Female',
'name': 'AB',
'sequence': 2}],
'years': [ { 'description': '1970',
'name': '1970',
'sequence': 88},
{ 'description': '1980',
'name': '1980',
'sequence': 98},
{ 'description': '1990',
'name': '1990',
'sequence': 108},
{ 'description': '2000',
'name': '2000',
'sequence': 118},
{ 'description': '2010',
'name': '2010',
'sequence': 131},
{ 'description': '2006-2010',
'name': '105',
'sequence': 133},
{ 'description': '2007-2011',
'name': '115',
'sequence': 136},
{ 'description': '2008-2012',
'name': '125',
'sequence': 139},
{ 'description': '2009-2013',
'name': '135',
'sequence': 142},
{ 'description': '2010-2014',
'name': '145',
'sequence': 144},
{ 'description': '2011-2015',
'name': '155',
'sequence': 146},
{ 'description': '2012-2016',
'name': '165',
'sequence': 148},
{ 'description': '2013-2017',
'name': '175',
'sequence': 150},
{ 'description': '2014-2018',
'name': '185',
'sequence': 152},
{ 'description': '2015-2019',
'name': '195',
'sequence': 154},
{ 'description': '2016-2020',
'name': '205',
'sequence': 156}]},
{ 'description': 'Persons by Sex [2]',
'geogLevels': [ { 'description': 'State',
'name': 'state',
'hasGeogExtentSelection': true,
'sequence': 4},
{ 'description': 'State--County',
'name': 'county',
'hasGeogExtentSelection': true,
'sequence': 25},
{ 'description': 'State--County--Census Tract',
'name': 'tract',
'hasGeogExtentSelection': true,
'sequence': 65},
{ 'description': 'State--County--Census '
'Tract--Block Group',
'name': 'blck_grp',
'hasGeogExtentSelection': true,
'sequence': 83},
{ 'description': 'State--County--County '
'Subdivision',
'name': 'cty_sub',
'hasGeogExtentSelection': true,
'sequence': 100},
{ 'description': 'State--Place',
'name': 'place',
'hasGeogExtentSelection': true,
'sequence': 145},
{ 'description': 'State--Congressional District '
'(2007-2013, 110th-112th '
'Congress)',
'name': 'cd111th',
'hasGeogExtentSelection': true,
'sequence': 210},
{ 'description': 'Metropolitan Statistical '
'Area/Micropolitan Statistical '
'Area',
'name': 'cbsa',
'hasGeogExtentSelection': false,
'sequence': 319},
{ 'description': 'Urban Area',
'name': 'urb_area',
'hasGeogExtentSelection': false,
'sequence': 353},
{ 'description': '5-Digit ZIP Code Tabulation '
'Area',
'name': 'zcta',
'hasGeogExtentSelection': false,
'sequence': 363}],
'geographicIntegration': 'Standardized to 2010',
'name': 'CM0',
'sequence': 102.03,
'timeSeries': [ { 'description': 'Persons: Male',
'name': 'AA',
'sequence': 1},
{ 'description': 'Persons: Female',
'name': 'AB',
'sequence': 2}],
'years': [ { 'description': '1990',
'name': '1990',
'sequence': 108},
{ 'description': '2000',
'name': '2000',
'sequence': 118},
{ 'description': '2010',
'name': '2010',
'sequence': 131}]}],
'links': { 'nextPage': 'https://api.ipums.org/metadata/time_series_tables?collection=nhgis&pageNumber=2&pageSize=10&version=2',
'previousPage': None},
'pageNumber': 1,
'pageSize': 10,
'totalCount': 389}url <- "https://api.ipums.org/metadata/time_series_tables?collection=nhgis&version=2&pageSize=10"
result <- GET(url, add_headers(Authorization = my_key))
res_df <- content(result, "parsed", simplifyDataFrame = TRUE)
head(res_df, n = 20L) # Contains metadata
# Results
$data
name description geographicIntegration sequence
1 A00 Total Population Nominal 100.01
2 AV0 Total Population Nominal 100.02
3 B78 Total Population Nominal 100.03
4 CL8 Total Population Standardized to 2010 100.04
5 A57 Persons by Urban/Rural Status [4] Nominal 101.01
6 A59 Persons by Urban/Rural Status [4] Nominal 101.02
7 CL9 Persons by Urban/Rural Status [4] Standardized to 2010 101.03
8 A08 Persons by Sex [2] Nominal 102.01
9 AV1 Persons by Sex [2] Nominal 102.02
10 CM0 Persons by Sex [2] Standardized to 2010 102.03
timeSeries
1 AA, Persons: Total, 1
2 AA, Persons: Total, 1
3 AA, Persons: Total, 1
4 AA, Persons: Total, 1
5 AA, AB, AC, AD, Persons: Urban, Persons: Urban--Inside urbanized areas, Persons: Urban--Outside urbanized areas (in urban clusters), Persons: Rural, 1, 2, 3, 4
6 AA, AB, AC, AD, Persons: Urban, Persons: Urban--Inside urbanized areas, Persons: Urban--Outside urbanized areas (in urban clusters), Persons: Rural, 1, 2, 3, 4
7 AA, AB, AC, AD, Persons: Urban, Persons: Urban--Inside urbanized areas, Persons: Urban--Outside urbanized areas (in urban clusters), Persons: Rural, 1, 2, 3, 4
8 AA, AB, Persons: Male, Persons: Female, 1, 2
9 AA, AB, Persons: Male, Persons: Female, 1, 2
10 AA, AB, Persons: Male, Persons: Female, 1, 2
years
1 1790, 1800, 1810, 1820, 1830, 1840, 1850, 1860, 1870, 1880, 1890, 1900, 1910, 1920, 1930, 1940, 1950, 1960, 1970, 1980, 1990, 2000, 2010, 2020, 1790, 1800, 1810, 1820, 1830, 1840, 1850, 1860, 1870, 1880, 1890, 1900, 1910, 1920, 1930, 1940, 1950, 1960, 1970, 1980, 1990, 2000, 2010, 2020, 1, 2, 3, 4, 5, 6, 7, 8, 12, 22, 29, 30, 32, 38, 48, 58, 68, 78, 88, 98, 108, 118, 131, 155
2 1970, 1980, 1990, 2000, 2010, 105, 115, 125, 135, 145, 155, 165, 175, 185, 195, 2020, 205, 1970, 1980, 1990, 2000, 2010, 2006-2010, 2007-2011, 2008-2012, 2009-2013, 2010-2014, 2011-2015, 2012-2016, 2013-2017, 2014-2018, 2015-2019, 2020, 2016-2020, 88, 98, 108, 118, 131, 133, 136, 139, 142, 144, 146, 148, 150, 152, 154, 155, 156
3 1980, 1990, 2000, 2010, 105, 115, 125, 135, 145, 155, 165, 175, 185, 195, 2020, 205, 1980, 1990, 2000, 2010, 2006-2010, 2007-2011, 2008-2012, 2009-2013, 2010-2014, 2011-2015, 2012-2016, 2013-2017, 2014-2018, 2015-2019, 2020, 2016-2020, 98, 108, 118, 131, 133, 136, 139, 142, 144, 146, 148, 150, 152, 154, 155, 156
4 1990, 2000, 2010, 2020, 1990, 2000, 2010, 2020, 108, 118, 131, 155
5 1970, 1980, 1990, 2000, 2010, 1970, 1980, 1990, 2000, 2010, 88, 98, 108, 118, 131
6 1980, 1990, 2000, 2010, 1980, 1990, 2000, 2010, 98, 108, 118, 131
7 1990, 2000, 2010, 1990, 2000, 2010, 108, 118, 131
8 1820, 1830, 1840, 1850, 1860, 1870, 1880, 1890, 1900, 1910, 1920, 1930, 1940, 1950, 1960, 1970, 1980, 1990, 2000, 2010, 1820, 1830, 1840, 1850, 1860, 1870, 1880, 1890, 1900, 1910, 1920, 1930, 1940, 1950, 1960, 1970, 1980, 1990, 2000, 2010, 4, 5, 6, 7, 8, 12, 22, 29, 30, 32, 38, 48, 58, 68, 78, 88, 98, 108, 118, 131
9 1970, 1980, 1990, 2000, 2010, 105, 115, 125, 135, 145, 155, 165, 175, 185, 195, 205, 1970, 1980, 1990, 2000, 2010, 2006-2010, 2007-2011, 2008-2012, 2009-2013, 2010-2014, 2011-2015, 2012-2016, 2013-2017, 2014-2018, 2015-2019, 2016-2020, 88, 98, 108, 118, 131, 133, 136, 139, 142, 144, 146, 148, 150, 152, 154, 156
10 1990, 2000, 2010, 1990, 2000, 2010, 108, 118, 131
geogLevels
1 state, county, State, State--County, TRUE, FALSE, 4, 25
2 state, county, tract, cty_sub, place, State, State--County, State--County--Census Tract, State--County--County Subdivision, State--Place, TRUE, TRUE, TRUE, TRUE, TRUE, 4, 25, 65, 100, 145
3 nation, region, division, state, county, tract, cty_sub, place, Nation, Region, Division, State, State--County, State--County--Census Tract, State--County--County Subdivision, State--Place, FALSE, FALSE, FALSE, TRUE, TRUE, TRUE, TRUE, TRUE, 1, 2, 3, 4, 25, 65, 100, 145
4 state, county, tract, blck_grp, cty_sub, place, cd111th, cbsa, urb_area, zcta, State, State--County, State--County--Census Tract, State--County--Census Tract--Block Group, State--County--County Subdivision, State--Place, State--Congressional District (2007-2013, 110th-112th Congress), Metropolitan Statistical Area/Micropolitan Statistical Area, Urban Area, 5-Digit ZIP Code Tabulation Area, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, FALSE, FALSE, FALSE, 4, 25, 65, 83, 100, 145, 210, 319, 353, 363
5 state, county, cty_sub, place, State, State--County, State--County--County Subdivision, State--Place, TRUE, TRUE, TRUE, TRUE, 4, 25, 100, 145
6 nation, region, division, state, county, tract, cty_sub, place, Nation, Region, Division, State, State--County, State--County--Census Tract, State--County--County Subdivision, State--Place, FALSE, FALSE, FALSE, TRUE, TRUE, TRUE, TRUE, TRUE, 1, 2, 3, 4, 25, 65, 100, 145
7 state, county, tract, blck_grp, cty_sub, place, cd111th, cbsa, urb_area, zcta, State, State--County, State--County--Census Tract, State--County--Census Tract--Block Group, State--County--County Subdivision, State--Place, State--Congressional District (2007-2013, 110th-112th Congress), Metropolitan Statistical Area/Micropolitan Statistical Area, Urban Area, 5-Digit ZIP Code Tabulation Area, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, FALSE, FALSE, FALSE, 4, 25, 65, 83, 100, 145, 210, 319, 353, 363
8 state, county, State, State--County, TRUE, TRUE, 4, 25
9 state, county, tract, cty_sub, place, State, State--County, State--County--Census Tract, State--County--County Subdivision, State--Place, TRUE, TRUE, TRUE, TRUE, TRUE, 4, 25, 65, 100, 145
10 state, county, tract, blck_grp, cty_sub, place, cd111th, cbsa, urb_area, zcta, State, State--County, State--County--Census Tract, State--County--Census Tract--Block Group, State--County--County Subdivision, State--Place, State--Congressional District (2007-2013, 110th-112th Congress), Metropolitan Statistical Area/Micropolitan Statistical Area, Urban Area, 5-Digit ZIP Code Tabulation Area, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, FALSE, FALSE, FALSE, 4, 25, 65, 83, 100, 145, 210, 319, 353, 363
$pageNumber
[1] 1
$pageSize
[1] 10
$totalCount
[1] 389
$links
$links$previousPage
NULL
$links$nextPage
[1] "https://api.ipums.org/metadata/time_series_tables?collection=nhgis&pageNumber=2&pageSize=10&version=2"curl -X GET \
"https://api.ipums.org/metadata/time_series_tables?collection=nhgis&version=2&pageSize=10" \
-H "Authorization: $MY_KEY"
# Results
{
"data": [
{
"name": "A00",
"description": "Total Population",
"geographicIntegration": "Nominal",
"sequence": 100.01,
"timeSeries": [
{
"name": "AA",
"description": "Persons: Total",
"sequence": 1
}
],
"years": [
{
"name": "1790",
"description": "1790",
"sequence": 1
},
{
"name": "1800",
"description": "1800",
"sequence": 2
},
{
"name": "1810",
"description": "1810",
"sequence": 3
},
{
"name": "1820",
"description": "1820",
"sequence": 4
},
{
"name": "1830",
"description": "1830",
"sequence": 5
},
{
"name": "1840",
"description": "1840",
"sequence": 6
},
{
"name": "1850",
"description": "1850",
"sequence": 7
},
{
"name": "1860",
"description": "1860",
"sequence": 8
},
{
"name": "1870",
"description": "1870",
"sequence": 12
},
{
"name": "1880",
"description": "1880",
"sequence": 22
},
{
"name": "1890",
"description": "1890",
"sequence": 29
},
{
"name": "1900",
"description": "1900",
"sequence": 30
},
{
"name": "1910",
"description": "1910",
"sequence": 32
},
{
"name": "1920",
"description": "1920",
"sequence": 38
},
{
"name": "1930",
"description": "1930",
"sequence": 48
},
{
"name": "1940",
"description": "1940",
"sequence": 58
},
{
"name": "1950",
"description": "1950",
"sequence": 68
},
{
"name": "1960",
"description": "1960",
"sequence": 78
},
{
"name": "1970",
"description": "1970",
"sequence": 88
},
{
"name": "1980",
"description": "1980",
"sequence": 98
},
{
"name": "1990",
"description": "1990",
"sequence": 108
},
{
"name": "2000",
"description": "2000",
"sequence": 118
},
{
"name": "2010",
"description": "2010",
"sequence": 131
},
{
"name": "2020",
"description": "2020",
"sequence": 155
}
],
"geogLevels": [
{
"name": "state",
"description": "State",
"hasGeogExtentSelection": true,
"sequence": 4
},
{
"name": "county",
"description": "State--County",
"hasGeogExtentSelection": true,
"sequence": 25
}
]
},
{
"name": "AV0",
"description": "Total Population",
"geographicIntegration": "Nominal",
"sequence": 100.02,
"timeSeries": [
{
"name": "AA",
"description": "Persons: Total",
"sequence": 1
}
],
"years": [
{
"name": "1970",
"description": "1970",
"sequence": 88
},
{
"name": "1980",
"description": "1980",
"sequence": 98
},
{
"name": "1990",
"description": "1990",
"sequence": 108
},
{
"name": "2000",
"description": "2000",
"sequence": 118
},
{
"name": "2010",
"description": "2010",
"sequence": 131
},
{
"name": "105",
"description": "2006-2010",
"sequence": 133
},
{
"name": "115",
"description": "2007-2011",
"sequence": 136
},
{
"name": "125",
"description": "2008-2012",
"sequence": 139
},
{
"name": "135",
"description": "2009-2013",
"sequence": 142
},
{
"name": "145",
"description": "2010-2014",
"sequence": 144
},
{
"name": "155",
"description": "2011-2015",
"sequence": 146
},
{
"name": "165",
"description": "2012-2016",
"sequence": 148
},
{
"name": "175",
"description": "2013-2017",
"sequence": 150
},
{
"name": "185",
"description": "2014-2018",
"sequence": 152
},
{
"name": "195",
"description": "2015-2019",
"sequence": 154
},
{
"name": "2020",
"description": "2020",
"sequence": 155
},
{
"name": "205",
"description": "2016-2020",
"sequence": 156
}
],
"geogLevels": [
{
"name": "state",
"description": "State",
"hasGeogExtentSelection": true,
"sequence": 4
},
{
"name": "county",
"description": "State--County",
"hasGeogExtentSelection": true,
"sequence": 25
},
{
"name": "tract",
"description": "State--County--Census Tract",
"hasGeogExtentSelection": true,
"sequence": 65
},
{
"name": "cty_sub",
"description": "State--County--County Subdivision",
"hasGeogExtentSelection": true,
"sequence": 100
},
{
"name": "place",
"description": "State--Place",
"hasGeogExtentSelection": true,
"sequence": 145
}
]
},
{
"name": "B78",
"description": "Total Population",
"geographicIntegration": "Nominal",
"sequence": 100.03,
"timeSeries": [
{
"name": "AA",
"description": "Persons: Total",
"sequence": 1
}
],
"years": [
{
"name": "1980",
"description": "1980",
"sequence": 98
},
{
"name": "1990",
"description": "1990",
"sequence": 108
},
{
"name": "2000",
"description": "2000",
"sequence": 118
},
{
"name": "2010",
"description": "2010",
"sequence": 131
},
{
"name": "105",
"description": "2006-2010",
"sequence": 133
},
{
"name": "115",
"description": "2007-2011",
"sequence": 136
},
{
"name": "125",
"description": "2008-2012",
"sequence": 139
},
{
"name": "135",
"description": "2009-2013",
"sequence": 142
},
{
"name": "145",
"description": "2010-2014",
"sequence": 144
},
{
"name": "155",
"description": "2011-2015",
"sequence": 146
},
{
"name": "165",
"description": "2012-2016",
"sequence": 148
},
{
"name": "175",
"description": "2013-2017",
"sequence": 150
},
{
"name": "185",
"description": "2014-2018",
"sequence": 152
},
{
"name": "195",
"description": "2015-2019",
"sequence": 154
},
{
"name": "2020",
"description": "2020",
"sequence": 155
},
{
"name": "205",
"description": "2016-2020",
"sequence": 156
}
],
"geogLevels": [
{
"name": "nation",
"description": "Nation",
"hasGeogExtentSelection": false,
"sequence": 1
},
{
"name": "region",
"description": "Region",
"hasGeogExtentSelection": false,
"sequence": 2
},
{
"name": "division",
"description": "Division",
"hasGeogExtentSelection": false,
"sequence": 3
},
{
"name": "state",
"description": "State",
"hasGeogExtentSelection": true,
"sequence": 4
},
{
"name": "county",
"description": "State--County",
"hasGeogExtentSelection": true,
"sequence": 25
},
{
"name": "tract",
"description": "State--County--Census Tract",
"hasGeogExtentSelection": true,
"sequence": 65
},
{
"name": "cty_sub",
"description": "State--County--County Subdivision",
"hasGeogExtentSelection": true,
"sequence": 100
},
{
"name": "place",
"description": "State--Place",
"hasGeogExtentSelection": true,
"sequence": 145
}
]
},
{
"name": "CL8",
"description": "Total Population",
"geographicIntegration": "Standardized to 2010",
"sequence": 100.04,
"timeSeries": [
{
"name": "AA",
"description": "Persons: Total",
"sequence": 1
}
],
"years": [
{
"name": "1990",
"description": "1990",
"sequence": 108
},
{
"name": "2000",
"description": "2000",
"sequence": 118
},
{
"name": "2010",
"description": "2010",
"sequence": 131
},
{
"name": "2020",
"description": "2020",
"sequence": 155
}
],
"geogLevels": [
{
"name": "state",
"description": "State",
"hasGeogExtentSelection": true,
"sequence": 4
},
{
"name": "county",
"description": "State--County",
"hasGeogExtentSelection": true,
"sequence": 25
},
{
"name": "tract",
"description": "State--County--Census Tract",
"hasGeogExtentSelection": true,
"sequence": 65
},
{
"name": "blck_grp",
"description": "State--County--Census Tract--Block Group",
"hasGeogExtentSelection": true,
"sequence": 83
},
{
"name": "cty_sub",
"description": "State--County--County Subdivision",
"hasGeogExtentSelection": true,
"sequence": 100
},
{
"name": "place",
"description": "State--Place",
"hasGeogExtentSelection": true,
"sequence": 145
},
{
"name": "cd111th",
"description": "State--Congressional District (2007-2013, 110th-112th Congress)",
"hasGeogExtentSelection": true,
"sequence": 210
},
{
"name": "cbsa",
"description": "Metropolitan Statistical Area/Micropolitan Statistical Area",
"hasGeogExtentSelection": false,
"sequence": 319
},
{
"name": "urb_area",
"description": "Urban Area",
"hasGeogExtentSelection": false,
"sequence": 353
},
{
"name": "zcta",
"description": "5-Digit ZIP Code Tabulation Area",
"hasGeogExtentSelection": false,
"sequence": 363
}
]
},
{
"name": "A57",
"description": "Persons by Urban/Rural Status [4]",
"geographicIntegration": "Nominal",
"sequence": 101.01,
"timeSeries": [
{
"name": "AA",
"description": "Persons: Urban",
"sequence": 1
},
{
"name": "AB",
"description": "Persons: Urban--Inside urbanized areas",
"sequence": 2
},
{
"name": "AC",
"description": "Persons: Urban--Outside urbanized areas (in urban clusters)",
"sequence": 3
},
{
"name": "AD",
"description": "Persons: Rural",
"sequence": 4
}
],
"years": [
{
"name": "1970",
"description": "1970",
"sequence": 88
},
{
"name": "1980",
"description": "1980",
"sequence": 98
},
{
"name": "1990",
"description": "1990",
"sequence": 108
},
{
"name": "2000",
"description": "2000",
"sequence": 118
},
{
"name": "2010",
"description": "2010",
"sequence": 131
}
],
"geogLevels": [
{
"name": "state",
"description": "State",
"hasGeogExtentSelection": true,
"sequence": 4
},
{
"name": "county",
"description": "State--County",
"hasGeogExtentSelection": true,
"sequence": 25
},
{
"name": "cty_sub",
"description": "State--County--County Subdivision",
"hasGeogExtentSelection": true,
"sequence": 100
},
{
"name": "place",
"description": "State--Place",
"hasGeogExtentSelection": true,
"sequence": 145
}
]
},
{
"name": "A59",
"description": "Persons by Urban/Rural Status [4]",
"geographicIntegration": "Nominal",
"sequence": 101.02,
"timeSeries": [
{
"name": "AA",
"description": "Persons: Urban",
"sequence": 1
},
{
"name": "AB",
"description": "Persons: Urban--Inside urbanized areas",
"sequence": 2
},
{
"name": "AC",
"description": "Persons: Urban--Outside urbanized areas (in urban clusters)",
"sequence": 3
},
{
"name": "AD",
"description": "Persons: Rural",
"sequence": 4
}
],
"years": [
{
"name": "1980",
"description": "1980",
"sequence": 98
},
{
"name": "1990",
"description": "1990",
"sequence": 108
},
{
"name": "2000",
"description": "2000",
"sequence": 118
},
{
"name": "2010",
"description": "2010",
"sequence": 131
}
],
"geogLevels": [
{
"name": "nation",
"description": "Nation",
"hasGeogExtentSelection": false,
"sequence": 1
},
{
"name": "region",
"description": "Region",
"hasGeogExtentSelection": false,
"sequence": 2
},
{
"name": "division",
"description": "Division",
"hasGeogExtentSelection": false,
"sequence": 3
},
{
"name": "state",
"description": "State",
"hasGeogExtentSelection": true,
"sequence": 4
},
{
"name": "county",
"description": "State--County",
"hasGeogExtentSelection": true,
"sequence": 25
},
{
"name": "tract",
"description": "State--County--Census Tract",
"hasGeogExtentSelection": true,
"sequence": 65
},
{
"name": "cty_sub",
"description": "State--County--County Subdivision",
"hasGeogExtentSelection": true,
"sequence": 100
},
{
"name": "place",
"description": "State--Place",
"hasGeogExtentSelection": true,
"sequence": 145
}
]
},
{
"name": "CL9",
"description": "Persons by Urban/Rural Status [4]",
"geographicIntegration": "Standardized to 2010",
"sequence": 101.03,
"timeSeries": [
{
"name": "AA",
"description": "Persons: Urban",
"sequence": 1
},
{
"name": "AB",
"description": "Persons: Urban--Inside urbanized areas",
"sequence": 2
},
{
"name": "AC",
"description": "Persons: Urban--Outside urbanized areas (in urban clusters)",
"sequence": 3
},
{
"name": "AD",
"description": "Persons: Rural",
"sequence": 4
}
],
"years": [
{
"name": "1990",
"description": "1990",
"sequence": 108
},
{
"name": "2000",
"description": "2000",
"sequence": 118
},
{
"name": "2010",
"description": "2010",
"sequence": 131
}
],
"geogLevels": [
{
"name": "state",
"description": "State",
"hasGeogExtentSelection": true,
"sequence": 4
},
{
"name": "county",
"description": "State--County",
"hasGeogExtentSelection": true,
"sequence": 25
},
{
"name": "tract",
"description": "State--County--Census Tract",
"hasGeogExtentSelection": true,
"sequence": 65
},
{
"name": "blck_grp",
"description": "State--County--Census Tract--Block Group",
"hasGeogExtentSelection": true,
"sequence": 83
},
{
"name": "cty_sub",
"description": "State--County--County Subdivision",
"hasGeogExtentSelection": true,
"sequence": 100
},
{
"name": "place",
"description": "State--Place",
"hasGeogExtentSelection": true,
"sequence": 145
},
{
"name": "cd111th",
"description": "State--Congressional District (2007-2013, 110th-112th Congress)",
"hasGeogExtentSelection": true,
"sequence": 210
},
{
"name": "cbsa",
"description": "Metropolitan Statistical Area/Micropolitan Statistical Area",
"hasGeogExtentSelection": false,
"sequence": 319
},
{
"name": "urb_area",
"description": "Urban Area",
"hasGeogExtentSelection": false,
"sequence": 353
},
{
"name": "zcta",
"description": "5-Digit ZIP Code Tabulation Area",
"hasGeogExtentSelection": false,
"sequence": 363
}
]
},
{
"name": "A08",
"description": "Persons by Sex [2]",
"geographicIntegration": "Nominal",
"sequence": 102.01,
"timeSeries": [
{
"name": "AA",
"description": "Persons: Male",
"sequence": 1
},
{
"name": "AB",
"description": "Persons: Female",
"sequence": 2
}
],
"years": [
{
"name": "1820",
"description": "1820",
"sequence": 4
},
{
"name": "1830",
"description": "1830",
"sequence": 5
},
{
"name": "1840",
"description": "1840",
"sequence": 6
},
{
"name": "1850",
"description": "1850",
"sequence": 7
},
{
"name": "1860",
"description": "1860",
"sequence": 8
},
{
"name": "1870",
"description": "1870",
"sequence": 12
},
{
"name": "1880",
"description": "1880",
"sequence": 22
},
{
"name": "1890",
"description": "1890",
"sequence": 29
},
{
"name": "1900",
"description": "1900",
"sequence": 30
},
{
"name": "1910",
"description": "1910",
"sequence": 32
},
{
"name": "1920",
"description": "1920",
"sequence": 38
},
{
"name": "1930",
"description": "1930",
"sequence": 48
},
{
"name": "1940",
"description": "1940",
"sequence": 58
},
{
"name": "1950",
"description": "1950",
"sequence": 68
},
{
"name": "1960",
"description": "1960",
"sequence": 78
},
{
"name": "1970",
"description": "1970",
"sequence": 88
},
{
"name": "1980",
"description": "1980",
"sequence": 98
},
{
"name": "1990",
"description": "1990",
"sequence": 108
},
{
"name": "2000",
"description": "2000",
"sequence": 118
},
{
"name": "2010",
"description": "2010",
"sequence": 131
}
],
"geogLevels": [
{
"name": "state",
"description": "State",
"hasGeogExtentSelection": true,
"sequence": 4
},
{
"name": "county",
"description": "State--County",
"hasGeogExtentSelection": true,
"sequence": 25
}
]
},
{
"name": "AV1",
"description": "Persons by Sex [2]",
"geographicIntegration": "Nominal",
"sequence": 102.02,
"timeSeries": [
{
"name": "AA",
"description": "Persons: Male",
"sequence": 1
},
{
"name": "AB",
"description": "Persons: Female",
"sequence": 2
}
],
"years": [
{
"name": "1970",
"description": "1970",
"sequence": 88
},
{
"name": "1980",
"description": "1980",
"sequence": 98
},
{
"name": "1990",
"description": "1990",
"sequence": 108
},
{
"name": "2000",
"description": "2000",
"sequence": 118
},
{
"name": "2010",
"description": "2010",
"sequence": 131
},
{
"name": "105",
"description": "2006-2010",
"sequence": 133
},
{
"name": "115",
"description": "2007-2011",
"sequence": 136
},
{
"name": "125",
"description": "2008-2012",
"sequence": 139
},
{
"name": "135",
"description": "2009-2013",
"sequence": 142
},
{
"name": "145",
"description": "2010-2014",
"sequence": 144
},
{
"name": "155",
"description": "2011-2015",
"sequence": 146
},
{
"name": "165",
"description": "2012-2016",
"sequence": 148
},
{
"name": "175",
"description": "2013-2017",
"sequence": 150
},
{
"name": "185",
"description": "2014-2018",
"sequence": 152
},
{
"name": "195",
"description": "2015-2019",
"sequence": 154
},
{
"name": "205",
"description": "2016-2020",
"sequence": 156
}
],
"geogLevels": [
{
"name": "state",
"description": "State",
"hasGeogExtentSelection": true,
"sequence": 4
},
{
"name": "county",
"description": "State--County",
"hasGeogExtentSelection": true,
"sequence": 25
},
{
"name": "tract",
"description": "State--County--Census Tract",
"hasGeogExtentSelection": true,
"sequence": 65
},
{
"name": "cty_sub",
"description": "State--County--County Subdivision",
"hasGeogExtentSelection": true,
"sequence": 100
},
{
"name": "place",
"description": "State--Place",
"hasGeogExtentSelection": true,
"sequence": 145
}
]
},
{
"name": "CM0",
"description": "Persons by Sex [2]",
"geographicIntegration": "Standardized to 2010",
"sequence": 102.03,
"timeSeries": [
{
"name": "AA",
"description": "Persons: Male",
"sequence": 1
},
{
"name": "AB",
"description": "Persons: Female",
"sequence": 2
}
],
"years": [
{
"name": "1990",
"description": "1990",
"sequence": 108
},
{
"name": "2000",
"description": "2000",
"sequence": 118
},
{
"name": "2010",
"description": "2010",
"sequence": 131
}
],
"geogLevels": [
{
"name": "state",
"description": "State",
"hasGeogExtentSelection": true,
"sequence": 4
},
{
"name": "county",
"description": "State--County",
"hasGeogExtentSelection": true,
"sequence": 25
},
{
"name": "tract",
"description": "State--County--Census Tract",
"hasGeogExtentSelection": true,
"sequence": 65
},
{
"name": "blck_grp",
"description": "State--County--Census Tract--Block Group",
"hasGeogExtentSelection": true,
"sequence": 83
},
{
"name": "cty_sub",
"description": "State--County--County Subdivision",
"hasGeogExtentSelection": true,
"sequence": 100
},
{
"name": "place",
"description": "State--Place",
"hasGeogExtentSelection": true,
"sequence": 145
},
{
"name": "cd111th",
"description": "State--Congressional District (2007-2013, 110th-112th Congress)",
"hasGeogExtentSelection": true,
"sequence": 210
},
{
"name": "cbsa",
"description": "Metropolitan Statistical Area/Micropolitan Statistical Area",
"hasGeogExtentSelection": false,
"sequence": 319
},
{
"name": "urb_area",
"description": "Urban Area",
"hasGeogExtentSelection": false,
"sequence": 353
},
{
"name": "zcta",
"description": "5-Digit ZIP Code Tabulation Area",
"hasGeogExtentSelection": false,
"sequence": 363
}
]
}
],
"pageNumber": 1,
"pageSize": 10,
"totalCount": 389,
"links": {
"previousPage": null,
"nextPage": "https://api.ipums.org/metadata/time_series_tables?collection=nhgis&pageNumber=2&pageSize=10&version=2"
}
}Note that this is a paginated endpoint. The default page size is 500 items, but here we have used the pageSize parameter to set 10 items per page. The links->nextPage field contains the URL to retrieve the next page of results.
Get Detailed Metadata for a Single Time Series Table
This API call will return the details of a single time series table, A00 in this example. The details repeat a lot of the information from the time series table call above, but also contain additional information on the individual time series contained within the table.
my_headers = {"Authorization": my_key}
url = "https://api.ipums.org/metadata/time_series_tables/A00?collection=nhgis&version=2"
nhgis_metadata = requests.get(url, headers=my_headers)
pprint(nhgis_metadata.json())git co
# Results
{ 'description': 'Total Population',
'geogLevels': [ {'description': 'State',
'name': 'state',
'hasGeogExtentSelection': true,
'sequence': 4},
{ 'description': 'State--County',
'name': 'county',
'hasGeogExtentSelection': true,
'sequence': 25}],
'geographicIntegration': 'Nominal',
'name': 'A00',
'sequence': 100.01,
'timeSeries': [ { 'description': 'Persons: Total',
'name': 'AA',
'sequence': 1}],
'years': [ {'description': '1790', 'name': '1790', 'sequence': 1},
{'description': '1800', 'name': '1800', 'sequence': 2},
{'description': '1810', 'name': '1810', 'sequence': 3},
{'description': '1820', 'name': '1820', 'sequence': 4},
{'description': '1830', 'name': '1830', 'sequence': 5},
{'description': '1840', 'name': '1840', 'sequence': 6},
{'description': '1850', 'name': '1850', 'sequence': 7},
{'description': '1860', 'name': '1860', 'sequence': 8},
{'description': '1870', 'name': '1870', 'sequence': 12},
{'description': '1880', 'name': '1880', 'sequence': 22},
{'description': '1890', 'name': '1890', 'sequence': 29},
{'description': '1900', 'name': '1900', 'sequence': 30},
{'description': '1910', 'name': '1910', 'sequence': 32},
{'description': '1920', 'name': '1920', 'sequence': 38},
{'description': '1930', 'name': '1930', 'sequence': 48},
{'description': '1940', 'name': '1940', 'sequence': 58},
{'description': '1950', 'name': '1950', 'sequence': 68},
{'description': '1960', 'name': '1960', 'sequence': 78},
{'description': '1970', 'name': '1970', 'sequence': 88},
{'description': '1980', 'name': '1980', 'sequence': 98},
{'description': '1990', 'name': '1990', 'sequence': 108},
{'description': '2000', 'name': '2000', 'sequence': 118},
{'description': '2010', 'name': '2010', 'sequence': 131},
{'description': '2020', 'name': '2020', 'sequence': 155}],
'geographicInstances': [ {'name': '010', 'description': 'Alabama'},
{'name': '020', 'description': 'Alaska'},
{'name': '025', 'description': 'Alaska Territory'},
{'name': '040', 'description': 'Arizona'},
{'name': '045', 'description': 'Arizona Territory'},
{'name': '050', 'description': 'Arkansas'},
{'name': '055', 'description': 'Arkansas Territory'},
{'name': '060', 'description': 'California'},
{'name': '080', 'description': 'Colorado'},
{'name': '085', 'description': 'Colorado Territory'},
{'name': '090', 'description': 'Connecticut'},
{'name': '095', 'description': 'Dakota Territory'},
{'name': '100', 'description': 'Delaware'},
{'name': '110', 'description': 'District of Columbia'},
{'name': '120', 'description': 'Florida'},
{'name': '125', 'description': 'Florida Territory'},
{'name': '130', 'description': 'Georgia'},
{'name': '150', 'description': 'Hawaii'},
{'name': '155', 'description': 'Hawaii Territory'},
{'name': '160', 'description': 'Idaho'},
{'name': '165', 'description': 'Idaho Territory'},
{'name': '170', 'description': 'Illinois'},
{'name': '175', 'description': 'Illinois Territory'},
{'name': '178', 'description': 'Indian Territory'},
{'name': '180', 'description': 'Indiana'},
{'name': '185', 'description': 'Indiana Territory'},
{'name': '190', 'description': 'Iowa'},
{'name': '195', 'description': 'Iowa Territory'},
{'name': '200', 'description': 'Kansas'},
{'name': '205', 'description': 'Kansas Territory'},
{'name': '210', 'description': 'Kentucky'},
{'name': '220', 'description': 'Louisiana'},
{'name': '225', 'description': 'Louisiana Territory'},
{'name': '230', 'description': 'Maine'},
{'name': '240', 'description': 'Maryland'},
{'name': '250', 'description': 'Massachusetts'},
{'name': '260', 'description': 'Michigan'},
{'name': '265', 'description': 'Michigan Territory'},
{'name': '270', 'description': 'Minnesota'},
{'name': '275', 'description': 'Minnesota Territory'},
{'name': '280', 'description': 'Mississippi'},
{'name': '285', 'description': 'Mississippi Territory'},
{'name': '290', 'description': 'Missouri'},
{'name': '295', 'description': 'Missouri Territory'},
{'name': '300', 'description': 'Montana'},
{'name': '305', 'description': 'Montana Territory'},
{'name': '310', 'description': 'Nebraska'},
{'name': '315', 'description': 'Nebraska Territory'},
{'name': '320', 'description': 'Nevada'},
{'name': '325', 'description': 'Nevada Territory'},
{'name': '330', 'description': 'New Hampshire'},
{'name': '340', 'description': 'New Jersey'},
{'name': '350', 'description': 'New Mexico'},
{'name': '355', 'description': 'New Mexico Territory'},
{'name': '360', 'description': 'New York'},
{'name': '370', 'description': 'North Carolina'},
{'name': '380', 'description': 'North Dakota'},
{'name': '385', 'description': 'Northwest Territory'},
{'name': '390', 'description': 'Ohio'},
{'name': '400', 'description': 'Oklahoma'},
{'name': '405', 'description': 'Oklahoma Territory'},
{'name': '410', 'description': 'Oregon'},
{'name': '413', 'description': 'Oregon Territory'},
{'name': '417', 'description': 'Orleans Territory'},
{'name': '420', 'description': 'Pennsylvania'},
{'name': '440', 'description': 'Rhode Island'},
{'name': '450', 'description': 'South Carolina'},
{'name': '460', 'description': 'South Dakota'},
{'name': '465', 'description': 'Southwest Territory'},
{'name': '470', 'description': 'Tennessee'},
{'name': '480', 'description': 'Texas'},
{'name': '490', 'description': 'Utah'},
{'name': '495', 'description': 'Utah Territory'},
{'name': '500', 'description': 'Vermont'},
{'name': '510', 'description': 'Virginia'},
{'name': '530', 'description': 'Washington'},
{'name': '535', 'description': 'Washington Territory'},
{'name': '540', 'description': 'West Virginia'},
{'name': '550', 'description': 'Wisconsin'},
{'name': '555', 'description': 'Wisconsin Territory'},
{'name': '560', 'description': 'Wyoming'},
{'name': '565', 'description': 'Wyoming Territory'},
{'name': '720', 'description': 'Puerto Rico'},
{'name': '999', 'description': 'Persons in the Military'}]
}url <- "https://demo.api.ipums.org/metadata/time_series_tables/A00?collection=nhgis&version=2"
result <- GET(url, add_headers(Authorization = my_key))
res_df <- content(result, "parsed", simplifyDataFrame = TRUE)
head(res_df, n = 20L) # Contains metadata
# Results
$name
[1] "A00"
$description
[1] "Total Population"
$geographicIntegration
[1] "Nominal"
$sequence
[1] 100.01
$timeSeries
name description sequence
1 AA Persons: Total 1
$years
name description sequence
1 1790 1790 1
2 1800 1800 2
3 1810 1810 3
4 1820 1820 4
5 1830 1830 5
6 1840 1840 6
7 1850 1850 7
8 1860 1860 8
9 1870 1870 12
10 1880 1880 22
11 1890 1890 29
12 1900 1900 30
13 1910 1910 32
14 1920 1920 38
15 1930 1930 48
16 1940 1940 58
17 1950 1950 68
18 1960 1960 78
19 1970 1970 88
20 1980 1980 98
21 1990 1990 108
22 2000 2000 118
23 2010 2010 131
24 2020 2020 155
$geogLevels
name description hasGeogExtentSelection sequence
1 state State TRUE 4
2 county State--County TRUE 25
$geographicInstances
name description
1 010 Alabama
2 020 Alaska
3 025 Alaska Territory
4 040 Arizona
5 045 Arizona Territory
6 050 Arkansas
7 055 Arkansas Territory
8 060 California
9 080 Colorado
10 085 Colorado Territory
11 090 Connecticut
12 095 Dakota Territory
13 100 Delaware
14 110 District of Columbia
15 120 Florida
16 125 Florida Territory
17 130 Georgia
18 150 Hawaii
19 155 Hawaii Territory
20 160 Idaho
21 165 Idaho Territory
22 170 Illinois
23 175 Illinois Territory
24 178 Indian Territory
25 180 Indiana
26 185 Indiana Territory
27 190 Iowa
28 195 Iowa Territory
29 200 Kansas
30 205 Kansas Territory
31 210 Kentucky
32 220 Louisiana
33 225 Louisiana Territory
34 230 Maine
35 240 Maryland
36 250 Massachusetts
37 260 Michigan
38 265 Michigan Territory
39 270 Minnesota
40 275 Minnesota Territory
41 280 Mississippi
42 285 Mississippi Territory
43 290 Missouri
44 295 Missouri Territory
45 300 Montana
46 305 Montana Territory
47 310 Nebraska
48 315 Nebraska Territory
49 320 Nevada
50 325 Nevada Territory
51 330 New Hampshire
52 340 New Jersey
53 350 New Mexico
54 355 New Mexico Territory
55 360 New York
56 370 North Carolina
57 380 North Dakota
58 385 Northwest Territory
59 390 Ohio
60 400 Oklahoma
61 405 Oklahoma Territory
62 410 Oregon
63 413 Oregon Territory
64 417 Orleans Territory
65 420 Pennsylvania
66 440 Rhode Island
67 450 South Carolina
68 460 South Dakota
69 465 Southwest Territory
70 470 Tennessee
71 480 Texas
72 490 Utah
73 495 Utah Territory
74 500 Vermont
75 510 Virginia
76 530 Washington
77 535 Washington Territory
78 540 West Virginia
79 550 Wisconsin
80 555 Wisconsin Territory
81 560 Wyoming
82 565 Wyoming Territory
83 720 Puerto Rico
84 999 Persons in the Militarycurl -X GET \
"https://api.ipums.org/metadata/time_series_tables/A00?collection=nhgis&version=2" \
-H "Authorization: $MY_KEY" | jq
# Results
{
"name": "A00",
"description": "Total Population",
"geographicIntegration": "Nominal",
"sequence": 100.01,
"timeSeries": [
{
"name": "AA",
"description": "Persons: Total",
"sequence": 1
}
],
"years": [
{
"name": "1790",
"description": "1790",
"sequence": 1
},
{
"name": "1800",
"description": "1800",
"sequence": 2
},
{
"name": "1810",
"description": "1810",
"sequence": 3
},
{
"name": "1820",
"description": "1820",
"sequence": 4
},
{
"name": "1830",
"description": "1830",
"sequence": 5
},
{
"name": "1840",
"description": "1840",
"sequence": 6
},
{
"name": "1850",
"description": "1850",
"sequence": 7
},
{
"name": "1860",
"description": "1860",
"sequence": 8
},
{
"name": "1870",
"description": "1870",
"sequence": 12
},
{
"name": "1880",
"description": "1880",
"sequence": 22
},
{
"name": "1890",
"description": "1890",
"sequence": 29
},
{
"name": "1900",
"description": "1900",
"sequence": 30
},
{
"name": "1910",
"description": "1910",
"sequence": 32
},
{
"name": "1920",
"description": "1920",
"sequence": 38
},
{
"name": "1930",
"description": "1930",
"sequence": 48
},
{
"name": "1940",
"description": "1940",
"sequence": 58
},
{
"name": "1950",
"description": "1950",
"sequence": 68
},
{
"name": "1960",
"description": "1960",
"sequence": 78
},
{
"name": "1970",
"description": "1970",
"sequence": 88
},
{
"name": "1980",
"description": "1980",
"sequence": 98
},
{
"name": "1990",
"description": "1990",
"sequence": 108
},
{
"name": "2000",
"description": "2000",
"sequence": 118
},
{
"name": "2010",
"description": "2010",
"sequence": 131
},
{
"name": "2020",
"description": "2020",
"sequence": 155
}
],
"geogLevels": [
{
"name": "state",
"description": "State",
"hasGeogExtentSelection": true,
"sequence": 4
},
{
"name": "county",
"description": "State--County",
"hasGeogExtentSelection": true,
"sequence": 25
}
],
"geographicInstances": [
{
"name": "010",
"description": "Alabama"
},
{
"name": "020",
"description": "Alaska"
},
{
"name": "025",
"description": "Alaska Territory"
},
{
"name": "040",
"description": "Arizona"
},
{
"name": "045",
"description": "Arizona Territory"
},
{
"name": "050",
"description": "Arkansas"
},
{
"name": "055",
"description": "Arkansas Territory"
},
{
"name": "060",
"description": "California"
},
{
"name": "080",
"description": "Colorado"
},
{
"name": "085",
"description": "Colorado Territory"
},
{
"name": "090",
"description": "Connecticut"
},
{
"name": "095",
"description": "Dakota Territory"
},
{
"name": "100",
"description": "Delaware"
},
{
"name": "110",
"description": "District of Columbia"
},
{
"name": "120",
"description": "Florida"
},
{
"name": "125",
"description": "Florida Territory"
},
{
"name": "130",
"description": "Georgia"
},
{
"name": "150",
"description": "Hawaii"
},
{
"name": "155",
"description": "Hawaii Territory"
},
{
"name": "160",
"description": "Idaho"
},
{
"name": "165",
"description": "Idaho Territory"
},
{
"name": "170",
"description": "Illinois"
},
{
"name": "175",
"description": "Illinois Territory"
},
{
"name": "178",
"description": "Indian Territory"
},
{
"name": "180",
"description": "Indiana"
},
{
"name": "185",
"description": "Indiana Territory"
},
{
"name": "190",
"description": "Iowa"
},
{
"name": "195",
"description": "Iowa Territory"
},
{
"name": "200",
"description": "Kansas"
},
{
"name": "205",
"description": "Kansas Territory"
},
{
"name": "210",
"description": "Kentucky"
},
{
"name": "220",
"description": "Louisiana"
},
{
"name": "225",
"description": "Louisiana Territory"
},
{
"name": "230",
"description": "Maine"
},
{
"name": "240",
"description": "Maryland"
},
{
"name": "250",
"description": "Massachusetts"
},
{
"name": "260",
"description": "Michigan"
},
{
"name": "265",
"description": "Michigan Territory"
},
{
"name": "270",
"description": "Minnesota"
},
{
"name": "275",
"description": "Minnesota Territory"
},
{
"name": "280",
"description": "Mississippi"
},
{
"name": "285",
"description": "Mississippi Territory"
},
{
"name": "290",
"description": "Missouri"
},
{
"name": "295",
"description": "Missouri Territory"
},
{
"name": "300",
"description": "Montana"
},
{
"name": "305",
"description": "Montana Territory"
},
{
"name": "310",
"description": "Nebraska"
},
{
"name": "315",
"description": "Nebraska Territory"
},
{
"name": "320",
"description": "Nevada"
},
{
"name": "325",
"description": "Nevada Territory"
},
{
"name": "330",
"description": "New Hampshire"
},
{
"name": "340",
"description": "New Jersey"
},
{
"name": "350",
"description": "New Mexico"
},
{
"name": "355",
"description": "New Mexico Territory"
},
{
"name": "360",
"description": "New York"
},
{
"name": "370",
"description": "North Carolina"
},
{
"name": "380",
"description": "North Dakota"
},
{
"name": "385",
"description": "Northwest Territory"
},
{
"name": "390",
"description": "Ohio"
},
{
"name": "400",
"description": "Oklahoma"
},
{
"name": "405",
"description": "Oklahoma Territory"
},
{
"name": "410",
"description": "Oregon"
},
{
"name": "413",
"description": "Oregon Territory"
},
{
"name": "417",
"description": "Orleans Territory"
},
{
"name": "420",
"description": "Pennsylvania"
},
{
"name": "440",
"description": "Rhode Island"
},
{
"name": "450",
"description": "South Carolina"
},
{
"name": "460",
"description": "South Dakota"
},
{
"name": "465",
"description": "Southwest Territory"
},
{
"name": "470",
"description": "Tennessee"
},
{
"name": "480",
"description": "Texas"
},
{
"name": "490",
"description": "Utah"
},
{
"name": "495",
"description": "Utah Territory"
},
{
"name": "500",
"description": "Vermont"
},
{
"name": "510",
"description": "Virginia"
},
{
"name": "530",
"description": "Washington"
},
{
"name": "535",
"description": "Washington Territory"
},
{
"name": "540",
"description": "West Virginia"
},
{
"name": "550",
"description": "Wisconsin"
},
{
"name": "555",
"description": "Wisconsin Territory"
},
{
"name": "560",
"description": "Wyoming"
},
{
"name": "565",
"description": "Wyoming Territory"
},
{
"name": "720",
"description": "Puerto Rico"
},
{
"name": "999",
"description": "Persons in the Military"
}
]
}Time Series Table Attributes
name: The unique identifier of the time series table.description: A short description of the time series table.geographicIntegration: How the time series tables align geographic units across time. See our geographic integration method documentation.sequence: The order in which the time series table will appear in the metadata API and extracts.timeSeries: A list of time series for this time series table.years: A list of years for this time series table.geogLevels: A list of geographic levels available for this dataset.name: The unique identifier of the geographic level.description: A short description of the geographic level.hasGeogExtentSelection: Whether or not extent selection is applied for this geography level. SeegeographicInstancesfor a list of valid extents.
geographicInstances: A list of the valid geographic extents for this time series table. Includes all states or state equivalents that are valid for any year in the time series table. (Some instances may be valid for some but not all years.)