new_york_city

Custom SQL query returning 26 rows (hide)

select rowid, precinct_2020, P0010001, P0010002, P0010003, P0010004, P0010005, P0010006, P0010007, P0010008, P0010009, P0010010, P0010011, P0010012, P0010013, P0010014, P0010015, P0010016, P0010017, P0010018, P0010019, P0010020, P0010021, P0010022, P0010023, P0010024, P0010025, P0010026, P0010027, P0010028, P0010029, P0010030, P0010031, P0010032, P0010033, P0010034, P0010035, P0010036, P0010037, P0010038, P0010039, P0010040, P0010041, P0010042, P0010043, P0010044, P0010045, P0010046, P0010047, P0010048, P0010049, P0010050, P0010051, P0010052, P0010053, P0010054, P0010055, P0010056, P0010057, P0010058, P0010059, P0010060, P0010061, P0010062, P0010063, P0010064, P0010065, P0010066, P0010067, P0010068, P0010069, P0010070, P0010071, P0020001, P0020002, P0020003, P0020004, P0020005, P0020006, P0020007, P0020008, P0020009, P0020010, P0020011, P0020012, P0020013, P0020014, P0020015, P0020016, P0020017, P0020018, P0020019, P0020020, P0020021, P0020022, P0020023, P0020024, P0020025, P0020026, P0020027, P0020028, P0020029, P0020030, P0020031, P0020032, P0020033, P0020034, P0020035, P0020036, P0020037, P0020038, P0020039, P0020040, P0020041, P0020042, P0020043, P0020044, P0020045, P0020046, P0020047, P0020048, P0020049, P0020050, P0020051, P0020052, P0020053, P0020054, P0020055, P0020056, P0020057, P0020058, P0020059, P0020060, P0020061, P0020062, P0020063, P0020064, P0020065, P0020066, P0020067, P0020068, P0020069, P0020070, P0020071, P0020072, P0020073 from nyc_2010pop_2020precincts where "P0020065" = :p0 order by P0010025 limit 101

Query parameters

This data as json, CSV

rowid	precinct_2020	P0010001	P0010002	P0010003	P0010004	P0010005	P0010006	P0010007	P0010008	P0010009	P0010010	P0010011	P0010012	P0010013	P0010014	P0010015	P0010016	P0010017	P0010018	P0010019	P0010020	P0010021	P0010022	P0010023	P0010024	P0010025	P0010026	P0010027	P0010028	P0010029	P0010030	P0010031	P0010032	P0010033	P0010034	P0010035	P0010036	P0010037	P0010038	P0010039	P0010040	P0010041	P0010042	P0010043	P0010044	P0010045	P0010046	P0010047	P0010048	P0010049	P0010050	P0010051	P0010052	P0010053	P0010054	P0010055	P0010056	P0010057	P0010058	P0010059	P0010060	P0010061	P0010062	P0010063	P0010064	P0010065	P0010066	P0010068	P0010069	P0010070	P0010071	P0020001	P0020002	P0020003	P0020004	P0020005	P0020006	P0020007	P0020008	P0020009	P0020010	P0020011	P0020012	P0020013	P0020014	P0020015	P0020016	P0020017	P0020018	P0020019	P0020020	P0020021	P0020022	P0020023	P0020024	P0020025	P0020026	P0020027	P0020028	P0020029	P0020030	P0020031	P0020032	P0020033	P0020034	P0020035	P0020036	P0020037	P0020038	P0020039	P0020040	P0020041	P0020042	P0020043	P0020044	P0020045	P0020046	P0020047	P0020048	P0020049	P0020050	P0020051	P0020052	P0020053	P0020054	P0020055	P0020056	P0020057	P0020059	P0020060	P0020061	P0020062	P0020063	P0020072	P0020073
13	22	25	25	6	18	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	25	6	19	19	2	16	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
9	17	79126	77567	63691	1711	71	11097	45	952	1559	1455	216	47	774	17	143	14	46	2	17	8	1	10	22	135	3	97	29	22	0	5	7	0	1	10	15	2	2	0	0	3	0	0	0	0	0	1	4	3	0	1	0	0	0	0	0	0	0	0	0	0	0	0	3	2	1	0	0	0	0	0	79126	4595	74531	73194	60226	1583	44	11038	35	268	1337	1261	177	39	751	17	52	11	45	1	9	6	0	0	21	129	3	73	20	21	0	0	7	0	1	9	12	0	1	0	0	2	0	0	0	0	0	0	3	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0
77	123	98032	96794	89264	1399	122	4551	33	1425	1238	1170	268	87	332	25	328	11	7	1	18	8	5	4	4	68	4	67	29	12	1	5	1	0	2	1	12	0	0	0	0	0	2	2	0	0	0	0	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	98032	7982	90050	89245	83295	1216	64	4521	25	124	805	768	218	70	319	23	57	8	6	0	4	8	5	1	3	46	0	37	15	7	1	3	1	0	2	1	3	0	0	0	0	0	2	2	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
8	14	20651	20019	12868	1481	56	4964	13	637	632	586	91	31	196	13	92	29	16	0	34	18	0	10	19	31	6	42	26	1	1	4	4	0	0	2	2	0	1	0	1	0	0	0	0	0	0	0	4	0	0	3	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	20651	2198	18453	18005	11605	1353	34	4933	11	69	448	414	45	25	188	11	34	25	14	0	7	18	0	1	16	27	3	33	19	1	1	3	4	0	0	2	2	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0
10	18	54066	52216	37624	3106	168	8462	27	2829	1850	1721	262	98	570	14	407	32	61	5	95	21	0	24	25	98	9	121	59	4	0	17	9	0	2	13	12	2	2	0	1	0	0	0	0	0	0	0	7	2	1	2	0	0	0	0	1	0	0	0	1	0	0	0	1	1	0	0	0	0	0	0	54066	8883	45183	44019	32682	2637	68	8389	25	218	1164	1088	179	60	537	13	65	25	60	5	30	20	0	1	24	68	1	73	40	2	0	2	6	0	1	12	8	0	2	0	0	0	0	0	0	0	0	0	3	1	0	2	0	0	0	0	0	0	0	0	0	0	0	0
7	13	93640	90828	70786	4864	194	12883	39	2062	2812	2562	429	108	1268	21	295	71	64	6	82	24	0	21	34	127	12	223	104	32	2	9	16	2	7	14	17	4	1	0	2	0	6	1	0	0	0	6	24	11	1	8	1	0	0	1	0	0	2	0	0	0	0	0	2	2	0	0	0	0	1	1	93640	8565	85075	82936	65354	4369	100	12785	31	297	2139	1975	287	84	1208	19	69	59	59	6	26	20	0	1	33	99	5	151	75	22	2	3	13	2	1	13	10	0	1	0	0	0	3	0	0	0	0	6	12	9	0	0	1	0	0	0	0	2	0	0	0	0	1	1
12	20	102624	100080	84116	4511	183	9024	34	2212	2544	2359	337	135	1206	22	302	63	54	3	89	10	1	21	29	75	12	173	77	23	1	11	14	0	2	20	16	0	2	0	2	0	2	1	0	1	0	1	11	6	0	5	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	1	0	0	0	102624	8609	94015	92070	78880	3855	87	8958	25	265	1945	1822	258	107	1148	22	65	55	49	2	12	9	1	4	29	61	0	117	50	17	1	2	11	0	1	18	10	0	2	0	1	0	2	1	0	0	0	1	6	3	0	3	0	0	0	0	0	0	0	0	0	0	0	0
54	84	48196	46319	33297	6470	158	4519	21	1854	1877	1735	327	104	710	14	180	101	49	16	112	6	1	23	15	64	13	137	59	28	3	11	5	0	4	5	7	0	6	0	2	2	3	2	0	0	0	0	4	2	0	2	0	0	0	0	0	0	0	0	0	0	0	0	1	1	0	0	0	0	0	0	48196	6078	42118	40735	30066	5935	79	4451	15	189	1383	1293	265	62	690	11	34	85	46	11	24	4	1	2	15	43	0	88	36	21	3	5	2	0	3	5	5	0	5	0	1	1	1	0	0	0	0	0	2	2	0	0	0	0	0	0	0	0	0	0	0	0	0	0
42	69	84480	82675	6885	70837	311	2273	14	2355	1805	1658	352	23	93	15	139	191	234	138	379	13	1	9	12	39	20	133	27	30	1	16	1	0	1	6	2	4	10	1	8	8	10	8	0	0	0	0	13	5	0	5	2	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	1	1	84480	7059	77421	76134	4972	68396	193	2233	8	332	1287	1171	248	16	85	13	10	162	217	128	237	10	0	1	12	27	5	102	20	28	1	11	1	0	1	6	0	3	9	1	1	8	8	4	0	0	0	0	13	5	0	5	2	0	0	0	0	0	0	0	0	1	1	1
57	94	56247	54566	45462	2037	188	3293	36	3550	1681	1569	224	126	537	18	422	12	41	4	69	7	0	15	15	55	24	103	43	7	0	11	12	0	2	4	12	5	1	0	0	1	0	1	0	4	0	0	3	2	0	0	0	0	0	1	0	0	0	0	0	0	0	0	3	3	0	0	0	0	3	3	56247	9088	47159	46152	40844	1688	84	3255	26	255	1007	954	154	91	503	18	50	11	35	3	14	5	0	2	15	40	13	50	25	5	0	3	7	0	0	4	5	0	1	0	0	0	0	0	0	0	0	0	2	2	0	0	0	0	0	0	0	0	0	0	0	0	1	1
38	63	108646	106194	49114	48543	326	5091	24	3096	2452	2277	488	72	375	11	256	97	271	92	404	36	5	26	15	104	25	159	41	57	2	16	4	0	6	0	3	0	6	0	2	1	14	7	0	0	0	0	15	5	1	5	1	0	2	0	1	0	0	0	0	0	0	0	1	1	0	0	0	0	0	0	108646	9247	99399	97652	45309	46606	198	5045	22	472	1747	1619	362	59	336	11	52	88	258	90	225	33	2	2	12	86	3	123	29	49	1	11	4	0	0	0	3	0	5	0	2	1	13	5	0	0	0	0	5	1	0	1	1	0	2	0	0	0	0	0	0	0	0	0
17	26	49508	47048	23703	11610	326	6220	29	5160	2460	2229	485	108	661	11	356	98	70	9	228	10	3	61	21	76	32	213	97	26	1	36	10	1	2	5	8	0	4	2	8	0	4	2	0	3	4	0	15	7	0	3	1	1	0	1	0	0	0	1	1	0	0	0	3	3	0	0	0	0	0	0	49508	12277	37231	35842	19207	10158	113	6163	23	178	1389	1266	277	64	629	7	34	82	68	5	30	6	1	2	20	41	0	114	62	22	1	5	6	0	0	5	6	0	1	2	0	0	2	0	0	2	0	0	9	4	0	3	1	0	0	1	0	0	0	0	0	0	0	0
75	121	118708	114773	73769	16688	557	13217	78	10464	3935	3643	789	136	547	46	973	149	127	20	328	106	3	40	25	318	36	255	120	23	6	30	4	4	9	4	28	5	5	2	7	1	5	1	1	0	0	0	37	15	5	8	0	4	0	0	1	1	1	0	1	0	1	0	0	0	0	0	0	0	0	0	118708	27252	91456	89367	60934	14798	199	13050	43	343	2089	1949	570	93	479	39	97	115	113	18	56	93	1	2	24	242	7	121	62	15	6	5	2	4	2	4	9	0	5	2	1	1	2	0	1	0	0	0	19	10	3	3	0	1	0	0	1	0	0	0	0	1	0	0
48	76	43694	41958	29343	7204	210	2060	21	3120	1736	1592	277	74	547	15	344	81	31	4	109	4	0	17	7	42	40	130	68	17	0	5	5	1	3	10	9	2	4	0	0	1	2	1	0	1	0	1	14	8	0	4	1	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	43694	9543	34151	33137	24791	6097	65	2018	16	150	1014	937	172	45	526	13	33	62	26	4	19	4	0	1	7	21	4	75	38	15	0	0	4	1	1	9	4	0	2	0	0	1	0	0	0	0	0	0	2	1	0	0	1	0	0	0	0	0	0	0	0	0	0	0
51	79	90263	87018	20375	54877	600	2443	88	8635	3245	2956	645	79	216	21	552	406	166	57	579	18	8	87	10	58	54	268	137	20	1	25	5	0	4	2	12	6	17	1	15	4	7	6	1	3	2	0	21	7	1	5	1	5	0	0	0	1	0	1	0	0	0	0	0	0	0	0	0	0	0	0	90263	20014	70249	68615	14506	51142	210	2390	55	312	1634	1471	458	40	201	17	37	349	140	50	134	11	3	2	10	18	1	151	82	19	1	9	5	0	0	1	6	2	9	1	5	4	5	2	0	0	0	0	12	7	0	2	1	1	0	0	0	0	1	0	0	0	0	0
56	90	116836	113116	80364	9974	805	5544	68	16361	3720	3448	528	166	489	46	1298	111	44	17	368	36	0	132	30	123	60	243	107	15	1	37	5	3	10	10	14	10	1	1	9	1	4	3	4	3	5	0	24	4	0	4	5	0	0	1	0	1	2	5	2	0	0	0	5	5	0	0	0	0	0	0	116836	37920	78916	77711	64467	7294	122	5456	28	344	1205	1122	179	97	450	35	127	70	29	9	26	20	0	2	30	46	2	77	48	4	0	3	3	0	0	8	6	1	1	1	0	1	1	0	0	0	0	0	6	3	0	0	1	0	0	1	0	0	0	1	0	0	0	0
39	66	191382	187193	134948	5312	709	34011	48	12165	4189	3886	472	144	903	61	1223	55	204	23	196	186	0	82	30	243	64	276	150	23	1	17	11	1	6	3	18	8	4	0	1	6	17	1	0	2	5	2	21	12	1	1	6	0	0	0	0	0	0	1	0	0	0	0	1	1	0	0	0	0	5	5	191382	24854	166528	164193	125152	4338	179	33856	22	646	2335	2246	288	72	875	43	206	43	189	23	79	183	0	14	29	192	10	82	13	21	1	0	10	0	0	1	11	0	4	0	1	4	15	0	0	1	0	0	6	2	0	0	3	0	0	0	0	0	1	0	0	0	1	1
32	49	114712	109631	50305	28570	997	8838	75	20846	5081	4668	834	136	361	24	1562	239	171	87	638	49	9	181	19	276	82	382	160	19	2	96	1	0	8	8	10	22	2	3	8	9	8	15	0	4	5	2	30	12	1	8	0	1	0	0	0	0	1	2	0	4	1	0	0	0	0	0	0	0	1	1	114712	48721	65991	64397	31212	23367	265	8697	34	822	1594	1487	277	42	314	14	115	139	148	82	86	36	1	10	19	189	15	94	52	8	2	7	1	0	1	2	2	0	1	2	0	5	4	3	0	1	1	2	13	6	0	0	0	0	0	0	0	1	2	0	3	1	0	0
24	41	52246	48506	12955	15828	1041	455	50	18177	3740	3451	589	106	39	3	1232	233	33	19	747	20	3	229	0	97	101	266	127	3	0	31	2	0	8	1	10	8	4	0	53	0	6	5	0	4	4	0	20	2	0	11	0	4	0	0	1	0	0	0	1	1	0	0	0	0	0	0	0	0	3	3	52246	39089	13157	12807	694	11536	92	331	10	144	350	306	87	19	21	2	13	67	27	7	37	6	1	2	0	16	1	42	25	3	0	0	0	0	0	0	0	0	4	0	10	0	0	0	0	0	0	0	2	2	0	0	0	0	0	0	0	0	0	0	0	0	0	0
62	104	170190	164755	120143	4320	934	13384	87	25887	5435	5058	777	229	669	102	2229	35	78	21	334	68	16	169	22	208	101	352	144	22	3	56	13	0	19	8	25	5	3	0	8	2	22	11	0	4	7	0	21	12	0	4	1	2	0	0	0	0	0	0	0	2	0	0	4	2	2	0	0	0	0	0	170190	58947	111243	109604	93378	2368	222	13118	32	486	1639	1543	300	96	599	91	143	20	60	15	35	58	3	3	22	90	8	83	26	12	0	4	9	0	2	8	3	0	2	0	0	0	14	3	0	0	0	0	13	11	0	0	0	2	0	0	0	0	0	0	0	0	0	0
30	47	152374	147258	21739	105538	1241	2982	89	15669	5116	4639	898	73	128	15	768	446	400	175	1001	70	9	116	25	342	173	441	172	36	1	64	4	0	3	1	18	7	18	4	29	8	36	21	0	6	10	3	32	13	0	6	4	1	0	0	0	0	0	0	3	4	1	0	2	2	0	0	0	0	2	2	152374	34919	117455	114957	10871	99102	587	2872	50	1475	2498	2266	456	28	111	4	44	333	373	164	338	55	3	17	19	266	55	216	90	21	1	24	0	0	0	0	5	1	7	2	10	6	30	14	0	1	1	3	14	7	0	1	4	0	0	0	0	0	0	1	0	1	2	2
53	83	112634	106366	34183	28095	1522	4953	135	37478	6268	5892	820	141	215	37	2618	175	127	71	872	59	26	325	25	192	189	359	91	17	4	68	4	0	33	7	20	28	11	0	9	5	17	16	1	16	5	7	17	7	0	5	0	2	0	1	0	0	1	0	1	0	0	0	0	0	0	0	0	0	0	0	112634	73616	39018	37849	9564	22688	201	4776	31	589	1169	1071	235	34	170	14	55	115	103	52	129	32	0	10	19	92	11	88	27	11	2	3	2	0	0	7	5	0	9	0	1	5	8	3	0	4	0	1	10	5	0	1	0	2	0	1	0	1	0	0	0	0	0	0
31	48	83266	78828	23662	28195	1377	1027	98	24469	4438	4142	698	88	101	12	1313	276	98	64	827	39	18	251	14	111	232	271	75	3	0	51	4	1	6	0	5	35	3	1	31	0	15	9	0	22	8	2	20	4	0	12	0	0	0	0	0	0	0	1	0	1	2	0	5	3	2	0	0	0	0	0	83266	53447	29819	29144	6219	21548	172	930	22	253	675	633	163	19	76	7	13	112	76	52	55	13	2	3	6	27	9	38	20	2	0	2	0	1	0	0	0	0	2	0	1	0	7	1	0	2	0	0	4	2	0	0	0	0	0	0	0	0	1	0	0	1	0	0
23	40	91497	86028	21270	31385	1782	646	72	30873	5469	5127	607	81	62	16	1902	423	78	25	1201	39	13	293	3	110	274	321	74	14	3	56	0	1	7	4	6	27	6	6	64	4	3	23	1	10	10	2	19	5	0	6	1	0	0	0	0	0	0	0	0	4	3	0	2	0	0	1	0	1	0	0	91497	64887	26610	26043	1428	23680	177	525	17	216	567	518	148	7	40	6	9	114	50	17	85	19	0	1	3	17	2	49	22	10	0	0	0	0	0	3	0	0	5	1	1	1	2	3	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
34	52	139307	130239	37395	35034	2243	9458	117	45992	9068	8374	1395	137	270	32	2979	296	181	103	1613	166	19	500	51	358	274	638	181	45	7	138	2	14	27	0	24	42	8	3	23	11	27	31	0	30	25	0	46	15	0	19	0	3	1	0	3	1	0	1	1	1	1	0	4	4	0	0	0	0	6	6	139307	90981	48326	46654	10034	26171	317	9156	33	943	1672	1551	284	29	205	21	67	142	147	76	159	121	4	33	47	187	29	110	24	24	1	6	1	8	0	0	2	0	5	2	5	8	14	2	0	6	2	0	11	8	0	0	0	0	1	0	0	0	1	0	0	1	0	0
22	34	113062	104866	47323	12314	1462	2911	65	40791	8196	7416	1379	200	456	30	2817	122	72	26	1292	41	13	423	8	244	293	717	222	55	4	185	11	3	36	9	31	31	8	0	17	1	6	26	0	52	17	3	55	19	0	21	0	2	3	0	1	1	0	0	4	2	0	2	7	7	0	0	0	0	1	1	113062	77808	35254	34101	25547	5335	115	2685	15	404	1153	1029	280	73	386	12	62	58	61	8	24	13	0	3	5	40	4	107	50	18	0	6	6	0	1	7	6	0	3	0	5	1	1	1	0	1	0	1	17	10	0	4	0	2	0	0	0	0	0	1	0	0	0	0