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

View and edit SQL

Link rowid ▼ geoid10 precinct
101 360050004003010 43
102 360050004003011 43
103 360050004003012 43
104 360050004003013 43
105 360050004004000 43
106 360050004004001 43
107 360050004004002 43
108 360050004004003 43
109 360050004004004 43
110 360050004004005 43
111 360050004004006 43
112 360050004004007 43
113 360050004004008 43
114 360050004004009 43
115 360050016001000 43
116 360050016002000 43
117 360050016002001 43
118 360050016002002 43
119 360050016002003 43
120 360050016002004 43
121 360050016002005 43
122 360050016003000 43
123 360050016004000 43
124 360050016004001 43
125 360050016004002 43
126 360050016004003 43
127 360050016004004 43
128 360050016004005 43
129 360050016004006 43
130 360050016004007 43
131 360050016004008 43
132 360050016004009 43
133 360050016004010 43
134 360050016004011 43
135 360050019000001  
136 360050019000002  
137 360050019000003  
138 360050019001000 40
139 360050019001001 40
140 360050019001002 40
141 360050019001003 40
142 360050019001004 40
143 360050019001005 40
144 360050019001006 40
145 360050019001007 40
146 360050019001008 40
147 360050019001009 40
148 360050019001010 40
149 360050019001011 40
150 360050019001012 40
151 360050019001013 40
152 360050019001014 40
153 360050019001015 40
154 360050019001016 40
155 360050019001017 40
156 360050019001018 40
157 360050019001019 40
158 360050019001020 40
159 360050019001021 40
160 360050019001022 40
161 360050019002000 40
162 360050019002001 40
163 360050019002002 40
164 360050019002003 40
165 360050019002004 40
166 360050019002005 40
167 360050019002006 40
168 360050019002007 40
169 360050019002008 40
170 360050019002009 40
171 360050019002010 40
172 360050019002011 40
173 360050019003000 40
174 360050019003001 40
175 360050019003002 40
176 360050019003003 40
177 360050019003004 40
178 360050019003005 40
179 360050019003006 40
180 360050019003007 40
181 360050019003008 40
182 360050019003009 40
183 360050019003010 40
184 360050019003011 40
185 360050019003012 40
186 360050019003013 40
187 360050019003014 40
188 360050019003015 40
189 360050019003016 40
190 360050019003017 40
191 360050019003018 40
192 360050019003019 40
193 360050019003020 40
194 360050019003021 40
195 360050019003022 40
196 360050019003023 40
197 360050019003024 40
198 360050019003025 40
199 360050019003026 40
200 360050019003027 40

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "precinct_block_key" (
"geoid10" INTEGER,
  "precinct" INTEGER
);
Powered by Datasette · Query took 1.737ms · Data license: CC BY-SA 4.0 · Data source: US Census & NYC Open Data Portal, combined by John Keefe