chicago_2010blocks_2020policedistricts_key

Just a list of US Census block numbers and the police districts in which they sit. Join this to US Census tables to get aggregates by precinct, as those precincts existed in 2020. For details see this blog post.

Data license: CC BY-SA 4.0 · Data source: US Census & Chicago Open Data Portal, combined by John Keefe

93,572 rows

View and edit SQL

Link rowid ▼ GEOID10 dist_num
201 170310901002022 16
202 170311105012005 16
203 170311105022017 16
204 170311001005015 16
205 170311801002002 25
206 170311913011014 25
207 170311906013002 25
208 170311904012036 25
209 170311103004005 16
210 170311505021012 16
211 170311801001012 25
212 170311506004014 16
213 170318315001015 25
214 170311006004053 16
215 170311006002018 16
216 170311002005011 16
217 170310902003021 16
218 170311002005022 16
219 170311904022007 25
220 170311908004003 25
221 170312502001009 25
222 170312503002017 25
223 170312502001017 25
224 170311508004005 16
225 170311503003006 16
226 170311508005005 16
227 170311102002008 16
228 170312505004007 25
229 170312504005003 25
230 170312504005011 25
231 170312505002011 25
232 170312505002007 25
233 170311912001019 25
234 170312503003003 25
235 170312507004007 25
236 170311904022015 25
237 170311906023011 25
238 170311504012010 16
239 170311503007016 16
240 170311504023031 16
241 170311504021017 16
242 170311507004002 16
243 170311002006000 16
244 170312306002002 25
245 170312306003019 25
246 170312306004004 25
247 170311611002004 17
248 170311203003002 17
249 170311302001022 17
250 170311302001010 17
251 170311603003003 17
252 170311602003001 17
253 170311302001014 17
254 170311403021009 17
255 170311404002009 17
256 170318318005027 17
257 170318318004015 17
258 170311610001010 17
259 170311610002006 17
260 170311603001009 17
261 170311602001001 17
262 170311602001002 17
263 170311404005010 17
264 170311404005005 17
265 170311602004027 17
266 170311602004022 17
267 170311602003009 17
268 170311602004000 17
269 170311601001021 17
270 170311404005035 17
271 170312315006007 11
272 170318421005001 11
273 170318421005005 11
274 170312306001009 25
275 170312306001003 25
276 170313501002003 1
277 170310706002004 19
278 170310710002003 18
279 170310710002002 18
280 170310624001007 19
281 170310603002007 19
282 170318378001002 12
283 170312430002014 12
284 170312406001000 14
285 170312222002013 14
286 170312413001014 14
287 170312106023013 14
288 170312105021015 25
289 170318311004024 17
290 170312105011005 25
291 170312209012001 25
292 170312209012006 25
293 170318311001000 17
294 170310715003001 18
295 170310801005014 18
296 170310814012004 18
297 170310101002002 24
298 170310103002012 24
299 170312432002010 12
300 170318310001001 14

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "chicago_2010blocks_2020policedistricts_key" (
"GEOID10" INTEGER,
  "dist_num" INTEGER
);
Powered by Datasette · Query took 6.159ms · Data license: CC BY-SA 4.0 · Data source: US Census & Chicago Open Data Portal, combined by John Keefe