2d:null 2e:["$","title",null,{"children":"Census Bureau APIs | Jonas Almeida | Observable"}] 33:[{"id":"c688243497f4fbb922976d128ff6b5e55a2c5265fb3b2751f81e0a26c32c774b6c8d20600796740a72c420628e957d43d119d2179656ea0ad84b76c27109a5fc","href":"https://static.observableusercontent.com/files/c688243497f4fbb922976d128ff6b5e55a2c5265fb3b2751f81e0a26c32c774b6c8d20600796740a72c420628e957d43d119d2179656ea0ad84b76c27109a5fc","name":"Screen Shot 2020-12-20 at 8.25.24 PM.png","type":"image/png","lastModified":1608513951567.802,"size":583084}] 31:{"id":"d79c966946c0de99","slug":"census","title":"Census Bureau APIs","thumbnail":"33b2abbacd2256b7dce7c3ede442d572aafcdcd3d8ecaff205b959b550f7dade","access_level":"public","create_time":"$D2020-08-08T00:52:25.361Z","update_time":"$D2022-07-21T17:59:20.563Z","view_time":null,"first_public_time":"$D2020-08-08T00:52:29.045Z","fork":false,"stars":1,"starred":false,"owner":{"type":"team","id":"0f2e596d5bd6ef6e","login":"episphere","name":"Jonas Almeida","avatar_url":"https://avatars-next.observableusercontent.com/3a0ff5abff6da0cdbd100da305ba323e12d43c8fcb7604275e6c72591db9dc69","tier":"starter_2024"},"version":226,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"4355fe13cb71b11d","login":"episphere","name":"Jonas Almeida","avatar_url":"https://avatars-next.observableusercontent.com/3a0ff5abff6da0cdbd100da305ba323e12d43c8fcb7604275e6c72591db9dc69","tier":null}],"members":[{"type":"individual","id":"4355fe13cb71b11d","login":"episphere","name":"Jonas Almeida","avatar_url":"https://avatars-next.observableusercontent.com/3a0ff5abff6da0cdbd100da305ba323e12d43c8fcb7604275e6c72591db9dc69","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Census Bureau APIs","cells":[{"id":0,"value":"md`# Census Bureau APIs\nExploring the Census Bureau APIs. These include a number of specialized APIs and a master discovery API. See also The API Manual.\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":191,"value":"FileAttachment(\"Screen Shot 2020-12-20 at 8.25.24 PM.png\").image()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":200,"value":"md`https://api.census.gov/data/2019/acs/acs1?get=NAME,B02015_009E,B02015_009M&for=state:*`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":46,"value":"md`\n## SDK (census.js)\nThe Census Bureau controls access with an API Key. Since the use of this SDK will need that key. Therefore, if you want to use it in your own application you'll need to either place your API key at census.key, or you have it in your own proxy pointed at api.census.gov. All APIs respond in JSON, more precisely, as linked data JSON-LD objects.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"//census = require('http://localhost:8000/census/census.js')\ncensus = require('https://episphere.github.io/census/census.js')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":66,"value":"md`\n### Discovery\nThe default /data/ query parameter will return the catalog of ${catalog.dataset.length} APIs:\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":8,"value":"catalog = census.get()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":149,"value":"md`keeping an eye on 2020:`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":143,"value":"APIs2020 = catalog.dataset.filter(x => x.c_vintage > 2019)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":74,"value":"md`\n### American Community Survey (ACS)\nThere are several APIs for ACS data. One in particular, ACS 5-Year Data (2009-2019) will be explored here. Let's start by getting the list of variables. Warning, there are a lot, for example, for the ACS5 data from 2019 there are ${\n Object.keys(var2019ACS5.variables).length\n} variables.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":90,"value":"var2019ACS5 = census.ACS5vars(2019)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":216,"value":"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":85,"value":"detail2019ACS5 = census.get(\n '/data/2019/acs/acs5?get=NAME,group(B01001)&for=us:1'\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":114,"value":"md`\nWe can now create an array of objects with the variable names and concepts for the detail values:\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":119,"value":"detail2019ACS5array = detail2019ACS5[0]\n .map((x, i) => {\n let y = {};\n if (var2019ACS5.variables[x]) {\n y = var2019ACS5.variables[x];\n y.value = detail2019ACS5[1][i];\n if (y.predicateType == \"int\") {\n y.value = parseInt(y.value);\n }\n } else {\n y[x] = detail2019ACS5[1][i];\n if (!y[x]) {\n // it's a nested variable\n y[x] = var2019ACS5.variables[y[x]];\n }\n }\n return y;\n })\n .filter(x => x.label || x.NAME)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":155,"value":"md`Which could, for example, be used to create a table with population stratified for ange and gender. This functionality will be used below to parameterize the analysis in mortalitytracker/strata:`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":158,"value":"{\n let ol = DOM.element('ol');\n ol.style.fontSize = '10px';\n detail2019ACS5array.forEach(x => {\n if (x.label) {\n let li = DOM.element('li');\n ol.appendChild(li);\n li.innerHTML = `${x.label\n .replace('Estimate!!Total:!!', '')\n .replace('!!', ' ')}: ${x.value}`;\n }\n });\n return ol;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":219,"value":"md`\n## STRATA\nConfiguration of real-time analysis published at mortalitytracker/strata. Note that the dereferencing of the variable codes is detailed above at #var2019ACS5.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":187,"value":"md`## Granular demographics\nHow granular can we get for demographic data? All the way to block level, say, for 2019?\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":212,"value":"md`\n### Geographies available\n\n`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":77,"value":"md`## MISCELANEOUS`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"dt2018 = census.get(\n '/data/2018/acs/acs1/subject?get=NAME,group(S0101)&for=us:1'\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":16,"value":"S0101_C01_001E = (await fetch(\n 'https://api.census.gov/data/2018/acs/acs5/subject/variables/S0101_C01_001E.json'\n)).json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":224,"value":"census.key","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":226,"value":"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W33","stdlib":"1","titling":"auto"}} 32:"$31:body"