precinct_block_key

Just a list of US Census block numbers and the precincts 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 & NYC Open Data Portal, combined by John Keefe

39,148 rows sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▲ geoid10 precinct
39148 39148 360859901000013  
39147 39147 360859901000012  
39146 39146 360859901000011  
39145 39145 360859901000010  
39144 39144 360859901000009  
39143 39143 360859901000008  
39142 39142 360859901000007  
39141 39141 360859901000006  
39140 39140 360859901000005  
39139 39139 360859901000004  
39138 39138 360859901000003  
39137 39137 360859901000002  
39136 39136 360859901000001  
39135 39135 360850323001026 120
39134 39134 360850323001025 120
39133 39133 360850323001024 120
39132 39132 360850323001023 120
39131 39131 360850323001022 120
39130 39130 360850323001021 120
39129 39129 360850323001020 120
39128 39128 360850323001019 120
39127 39127 360850323001018 120
39126 39126 360850323001017 120
39125 39125 360850323001016 120
39124 39124 360850323001015 120
39123 39123 360850323001014 120
39122 39122 360850323001013 120
39121 39121 360850323001012 120
39120 39120 360850323001011 120
39119 39119 360850323001010 120
39118 39118 360850323001009 120
39117 39117 360850323001008 120
39116 39116 360850323001007 120
39115 39115 360850323001006 120
39114 39114 360850323001005 120
39113 39113 360850323001004 120
39112 39112 360850323001003 120
39111 39111 360850323001002 120
39110 39110 360850323001001 120
39109 39109 360850323001000 120
39108 39108 360850323000002  
39107 39107 360850323000001  
39106 39106 360850319023012 120
39105 39105 360850319023011 120
39104 39104 360850319023010 120
39103 39103 360850319023009 120
39102 39102 360850319023008 120
39101 39101 360850319023007 120
39100 39100 360850319023006 120
39099 39099 360850319023005 120
39098 39098 360850319023004 120
39097 39097 360850319023003 120
39096 39096 360850319023002 120
39095 39095 360850319023001 120
39094 39094 360850319023000 120
39093 39093 360850319022007 120
39092 39092 360850319022006 120
39091 39091 360850319022005 120
39090 39090 360850319022004 120
39089 39089 360850319022003 120
39088 39088 360850319022002 120
39087 39087 360850319022001 120
39086 39086 360850319022000 120
39085 39085 360850319021005 120
39084 39084 360850319021004 120
39083 39083 360850319021003 120
39082 39082 360850319021002 120
39081 39081 360850319021001 120
39080 39080 360850319021000 120
39079 39079 360850319020002  
39078 39078 360850319020001  
39077 39077 360850319012009 120
39076 39076 360850319012008 120
39075 39075 360850319012007 120
39074 39074 360850319012006 120
39073 39073 360850319012005 120
39072 39072 360850319012004 120
39071 39071 360850319012003 120
39070 39070 360850319012002 120
39069 39069 360850319012001 120
39068 39068 360850319012000 120
39067 39067 360850319011004 120
39066 39066 360850319011003 120
39065 39065 360850319011002 120
39064 39064 360850319011001 120
39063 39063 360850319011000 120
39062 39062 360850303024008 120
39061 39061 360850303024007 120
39060 39060 360850303024006 120
39059 39059 360850303024005 120
39058 39058 360850303024004 120
39057 39057 360850303024003 120
39056 39056 360850303024002 120
39055 39055 360850303024001 120
39054 39054 360850303024000 120
39053 39053 360850303023010 120
39052 39052 360850303023009 120
39051 39051 360850303023008 120
39050 39050 360850303023007 120
39049 39049 360850303023006 120

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "precinct_block_key" (
"geoid10" INTEGER,
  "precinct" INTEGER
);