new_york_city

Custom SQL query returning 7 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 "P0010031" = :p0 order by P0010021 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	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	P0020046	P0020047	P0020048	P0020049	P0020050	P0020052	P0020053	P0020054	P0020056	P0020059	P0020060	P0020061	P0020062	P0020063	P0020064	P0020065	P0020066	P0020067	P0020072	P0020073
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	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	5	2	0	0	0	0	0	0	1	0	0	0	0	1	1
43	70	160664	156129	67162	60984	778	15281	64	11860	4535	4203	723	126	679	22	809	226	301	124	756	115	4	69	32	184	33	291	101	57	6	19	1	1	7	5	24	10	8	0	7	7	23	7	0	4	3	1	30	16	0	4	2	4	1	2	0	0	0	0	0	0	1	0	11	5	0	6	0	0	160664	25165	135499	132816	59590	56948	346	15147	37	748	2683	2465	470	49	648	18	127	188	284	111	297	105	1	5	31	126	5	191	67	45	6	5	1	1	0	2	20	4	6	0	2	7	19	3	0	2	1	22	12	2	2	3	2	0	0	0	0	1	0	5	5	0	0	0
59	101	67065	64391	19193	35263	533	1278	66	8058	2674	2485	371	37	102	9	654	262	135	64	505	35	4	74	3	135	95	178	74	9	2	35	1	0	7	3	4	3	12	0	5	2	7	8	0	3	2	1	9	6	0	0	0	0	1	0	0	0	0	1	0	1	0	0	2	2	0	0	0	0	67065	16941	50124	48859	13666	33054	215	1235	49	640	1265	1162	235	21	88	6	29	228	124	62	205	31	1	4	3	105	20	99	42	7	2	6	1	0	2	3	1	2	12	0	3	2	5	8	2	0	1	2	2	0	0	0	0	0	0	0	0	0	0	2	2	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	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
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	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	1	1	2	13	6	0	0	0	0	1	2	0	3	1	0	0	0	0	0	0
71	113	120132	116234	3036	104953	696	2615	55	4879	3898	3477	570	39	23	2	188	637	513	214	823	40	13	67	22	243	83	387	166	64	1	24	1	0	3	0	4	5	18	0	19	7	45	12	0	5	3	10	25	13	0	8	0	0	0	0	0	0	0	0	0	0	2	2	9	8	1	0	0	0	120132	9783	110349	107371	1057	101721	511	2577	42	1463	2978	2660	434	27	21	2	9	578	498	207	493	34	13	35	21	227	61	294	127	57	1	8	1	0	0	0	2	0	17	0	12	6	38	11	2	3	9	15	6	5	0	0	0	0	0	0	0	2	2	9	8	1	0	0
29	46	128200	120132	23931	46932	2326	2140	133	44670	8068	7408	1308	117	70	20	2410	398	173	55	1610	91	18	545	7	254	332	618	200	27	4	78	1	1	30	1	26	33	14	1	60	2	19	41	2	25	44	9	35	2	0	8	1	1	1	0	1	4	2	2	10	2	0	1	1	1	0	0	6	6	128200	85600	42600	41479	1791	36795	318	1902	47	626	1121	995	236	11	35	3	34	215	150	43	118	35	2	19	7	82	5	118	59	19	1	3	0	0	4	0	2	3	6	0	6	2	2	5	4	0	2	7	0	1	0	0	0	1	2	3	0	0	0	1	1	0	0	0