new_york_city

Custom SQL query returning 12 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 "P0020024" = :p0 order by P0010031 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	P0010054	P0010055	P0010057	P0010058	P0010059	P0010060	P0010061	P0010063	P0010064	P0010065	P0010066	P0010067	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	P0020047	P0020048	P0020049	P0020050	P0020051	P0020052	P0020053	P0020054	P0020056	P0020057	P0020059	P0020060	P0020063	P0020065	P0020066	P0020067	P0020069	P0020072	P0020073
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	4	3	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	1	0	0	0	0	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	1	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	13	5	0	5	2	0	0	0	0	0	1	0	0	0	0	1	1
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	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
1	1	66679	64416	50484	2162	89	10569	26	1086	2263	2098	348	115	1151	28	174	48	53	0	39	8	1	5	26	99	3	151	64	28	1	8	3	1	3	20	16	1	2	0	1	1	2	0	0	0	0	0	13	7	1	3	0	1	0	1	0	0	0	0	0	1	1	0	0	0	0	0	0	66679	4676	62003	60094	47231	1982	57	10520	23	281	1909	1784	280	85	1110	26	61	44	52	0	20	7	1	1	25	71	1	113	52	22	1	3	2	1	1	15	12	1	2	0	0	0	1	0	0	0	0	11	6	1	2	0	1	0	1	0	0	0	1	1	0	0	0	0
35	60	104278	101803	66276	14998	558	12372	32	7567	2475	2331	333	73	479	56	618	118	67	16	303	49	6	36	5	142	30	123	65	13	1	9	3	0	4	5	4	2	0	1	0	1	7	2	0	1	3	2	18	8	0	4	4	0	0	0	0	2	0	0	0	2	2	0	0	0	0	1	1	104278	17423	86855	85553	59405	13401	183	12294	16	254	1302	1230	178	36	461	53	111	105	66	11	40	47	1	1	5	113	2	61	34	6	1	2	2	0	1	3	4	0	0	0	0	1	3	0	0	2	2	10	8	0	0	0	0	0	0	0	2	0	1	1	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	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	1	0	0	0	0	1	0	0	0	0	0	0	0	0	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	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	1	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	2	1	0	0	1	0	0	0	0	0	0	0	0	0	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	0	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	1	0	1	0	0	0	1	0	0	0	1	0	0	0	124491	17868	106623	104486	76537	1757	97	25743	23	329	2137	2071	347	109	1110	57	118	27	73	4	36	35	0	1	19	133	2	59	18	15	1	3	4	2	0	6	7	0	0	1	0	0	1	0	1	0	0	6	5	0	0	0	0	0	0	0	1	0	1	0	0	1	0	0
4	7	56355	54055	21520	5992	326	19328	28	6861	2300	2108	365	98	403	12	588	73	90	3	195	45	10	75	22	86	43	164	69	19	1	19	9	0	1	6	15	6	3	1	1	0	3	0	0	7	4	0	25	16	0	6	0	0	1	0	0	0	2	0	0	3	0	3	0	0	0	0	0	56355	17976	38379	37470	13479	4578	95	19192	10	116	909	819	166	46	355	6	16	56	76	2	16	35	1	1	21	21	1	72	35	14	1	1	8	0	0	4	4	0	3	0	1	0	1	0	0	0	0	16	14	0	1	0	0	1	0	0	0	0	2	0	2	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	1	0	0	1	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	3	1	0	2	0	0	0	0	0	0	0	0	0	0	0	0	0
55	88	51421	48902	18769	23376	238	3393	11	3115	2519	2236	628	72	504	16	266	234	143	21	230	8	3	24	12	65	10	261	137	48	3	16	9	2	3	8	9	0	9	1	4	0	4	7	0	0	1	0	20	17	0	2	0	1	0	0	0	0	0	0	0	2	1	1	0	0	0	0	0	51421	8093	43328	41581	15904	21986	126	3341	8	216	1747	1534	504	43	480	14	22	197	133	17	56	7	3	1	12	45	0	194	112	36	3	5	7	0	1	8	5	0	6	1	1	0	2	6	0	1	0	17	16	0	0	0	1	0	0	0	0	0	2	1	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	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	1	0	2	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	6	12	9	0	0	1	0	0	0	2	0	0	0	0	0	0	1	1