new_york_city

Custom SQL query returning 17 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 "P0010021" = :p0 order by P0020026 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	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	P0010061	P0010062	P0010063	P0010064	P0010065	P0010067	P0010070	P0010071	P0020001	P0020002	P0020003	P0020004	P0020005	P0020006	P0020007	P0020008	P0020009	P0020010	P0020011	P0020012	P0020013	P0020014	P0020015	P0020016	P0020017	P0020018	P0020019	P0020020	P0020021	P0020022	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	P0020063	P0020065	P0020066	P0020067	P0020069	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	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	0	0
16	25	47405	44920	10886	21943	608	1300	41	10142	2485	2268	474	46	110	3	710	227	71	17	437	13	95	3	34	28	197	115	10	2	19	4	0	9	1	6	3	6	1	8	1	3	3	1	3	2	0	18	6	1	10	0	1	0	0	0	0	0	0	0	0	0	2	1	1	0	0	0	47405	22634	24771	24064	3578	19008	114	1226	6	132	707	637	219	17	100	1	16	147	57	15	52	4	0	1	5	3	58	34	8	2	4	2	0	0	1	1	0	3	0	0	1	1	0	1	0	0	0	10	3	1	6	0	0	0	0	0	0	0	0	0	2	1	1	0	0	0
44	71	98429	95882	20812	70414	358	1253	35	3010	2547	2296	534	59	182	8	199	292	270	140	536	5	23	4	27	17	235	106	55	0	17	3	0	4	3	3	1	7	0	13	7	7	8	0	0	1	0	12	4	2	2	0	0	0	0	1	0	0	0	1	2	0	4	4	0	0	0	0	98429	9157	89272	87601	18825	66958	199	1214	25	380	1671	1506	405	32	173	7	33	254	239	134	200	3	8	4	13	1	152	62	44	0	10	2	0	0	3	3	0	6	0	3	7	6	5	0	0	1	0	9	3	1	1	0	0	0	0	1	0	0	1	2	4	4	0	0	0	0
18	28	44781	42566	9799	27033	321	1607	43	3763	2215	1934	526	64	221	12	223	251	118	28	347	19	46	2	41	36	250	141	24	5	11	5	0	3	3	13	3	5	2	23	3	1	7	1	0	0	0	27	16	1	4	0	0	1	0	2	0	0	1	0	1	1	4	3	1	0	0	0	44781	9393	35388	34184	7227	25067	114	1570	27	179	1204	1057	350	37	218	8	14	165	103	26	96	14	7	1	17	1	136	88	15	3	3	2	0	0	3	6	1	4	0	3	3	1	3	1	0	0	0	7	5	1	0	0	0	0	0	0	0	1	0	0	4	3	1	0	0	0
48	76	43694	41958	29343	7204	210	2060	21	3120	1736	1592	277	74	547	15	344	81	31	4	109	4	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	43694	9543	34151	33137	24791	6097	65	2018	16	150	1014	937	172	45	526	13	33	62	26	4	19	4	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	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	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	20651	2198	18453	18005	11605	1353	34	4933	11	69	448	414	45	25	188	11	34	25	14	0	7	18	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	0	0	0
3	6	62226	60490	53227	1316	80	5023	21	823	1736	1596	286	121	883	13	120	23	41	1	29	7	6	27	37	2	119	53	10	0	10	14	0	2	12	12	1	1	0	2	0	1	1	0	0	0	0	18	14	0	3	0	0	0	1	0	0	0	0	0	0	0	3	3	0	0	0	0	62226	3781	58445	56956	50468	1214	47	4983	20	224	1489	1384	244	92	863	8	45	20	35	1	9	7	0	27	32	1	90	41	8	0	5	12	0	1	12	8	1	1	0	0	0	1	0	0	0	0	0	13	11	0	1	0	0	0	1	0	0	0	0	0	2	2	0	0	0	0
57	94	56247	54566	45462	2037	188	3293	36	3550	1681	1569	224	126	537	18	422	12	41	4	69	7	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	3	3	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	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	0	0	0	1	1
56	90	116836	113116	80364	9974	805	5544	68	16361	3720	3448	528	166	489	46	1298	111	44	17	368	36	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	5	5	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	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	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	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	1	1	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	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	0	0	0
76	122	138982	136452	119790	3397	330	8474	43	4418	2530	2358	469	166	658	29	649	52	52	9	85	32	18	23	99	17	154	52	8	0	17	17	0	3	10	29	5	4	1	0	1	4	0	0	3	0	0	17	10	1	3	0	2	1	0	0	0	0	0	0	0	0	1	0	1	0	0	0	138982	15903	123079	121540	109879	2863	168	8370	32	228	1539	1434	361	135	583	25	89	42	39	9	19	29	5	22	75	1	96	32	5	0	7	16	0	0	10	15	0	4	1	0	1	4	0	0	1	0	0	8	4	0	1	0	2	1	0	0	0	0	0	0	1	0	1	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	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	2	2	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	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	0	0	0	1	1
36	61	159645	156825	121073	5940	299	24223	22	5268	2820	2690	312	83	1090	87	588	59	55	15	135	32	33	27	147	27	123	39	6	0	17	5	0	9	4	28	2	2	1	1	1	7	0	0	0	1	0	6	4	0	0	1	0	0	0	0	1	0	0	0	0	0	1	0	1	0	0	0	159645	13029	146616	144553	114720	5298	88	24107	14	326	2063	1993	237	64	1060	83	231	46	54	13	30	30	2	25	106	12	65	11	6	0	5	3	0	0	3	25	2	2	1	0	1	5	0	0	0	1	0	4	3	0	0	1	0	0	0	0	0	0	0	0	1	0	1	0	0	0
41	68	124491	121140	85271	2288	329	25884	39	7329	3351	3196	527	168	1170	60	761	33	79	7	105	35	38	20	183	10	135	59	21	2	14	6	2	9	7	11	0	0	1	1	0	1	0	1	0	0	0	19	8	0	5	0	4	0	0	1	0	0	1	0	0	0	1	0	0	1	0	0	124491	17868	106623	104486	76537	1757	97	25743	23	329	2137	2071	347	109	1110	57	118	27	73	4	36	35	1	19	133	2	59	18	15	1	3	4	2	0	6	7	0	0	1	0	0	1	0	1	0	0	0	6	5	0	0	0	0	0	0	0	0	1	0	0	1	0	0	1	0	0
39	66	191382	187193	134948	5312	709	34011	48	12165	4189	3886	472	144	903	61	1223	55	204	23	196	186	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	1	1	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	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	0	0	0	1	1
70	112	112070	108553	71381	3240	223	29356	46	4307	3517	3271	385	95	1209	70	643	64	102	4	96	102	20	81	377	23	215	77	29	2	33	6	0	5	12	30	4	0	0	4	0	7	1	1	0	2	2	24	14	0	4	1	4	1	0	0	0	0	0	0	0	0	7	5	2	0	0	0	112070	15128	96942	94549	61927	2792	104	29200	29	497	2393	2260	218	36	1126	69	134	42	95	4	29	98	3	79	324	3	112	35	27	2	4	6	0	0	12	14	3	0	0	1	0	4	1	1	0	0	2	17	11	0	3	1	2	0	0	0	0	0	0	0	4	3	1	0	0	0
67	109	247354	240457	95236	6596	555	122496	106	15468	6897	6559	513	143	2131	35	1780	77	189	16	246	305	110	152	781	81	279	82	36	1	44	7	0	23	12	30	8	4	3	3	1	9	7	2	6	0	1	53	25	0	8	0	11	0	0	0	0	4	0	0	5	0	4	4	0	0	2	2	247354	41164	206190	202136	73668	5512	215	122012	82	647	4054	3900	273	61	2030	31	120	58	181	10	64	298	2	147	619	6	120	38	25	0	1	6	0	0	11	18	0	4	2	0	1	6	4	2	1	0	1	30	20	0	1	0	3	0	0	0	1	0	0	5	4	4	0	0	0	0