new_york_city

Custom SQL query returning 6 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 "P0020049" = :p0 order by P0020054 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	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	P0020035	P0020036	P0020037	P0020038	P0020039	P0020040	P0020041	P0020042	P0020043	P0020044	P0020045	P0020046	P0020047	P0020048	P0020049	P0020050	P0020051	P0020052	P0020053	P0020054	P0020056	P0020060	P0020061	P0020063	P0020065	P0020066	P0020067	P0020072	P0020073
45	72	126230	120736	52711	5849	1573	33565	62	26976	5494	5080	710	508	770	34	1869	63	151	12	347	67	11	214	44	201	79	372	125	23	1	64	18	0	39	6	30	26	3	0	3	0	14	2	1	8	8	1	37	16	7	4	0	2	1	0	0	2	2	0	0	0	0	3	5	3	1	1	0	0	126230	57375	68855	67085	29464	3688	178	33288	33	434	1770	1643	316	88	723	24	51	42	143	12	52	53	1	3	40	94	1	109	49	12	0	3	7	0	5	15	1	1	0	0	0	11	2	1	2	0	0	17	16	0	0	0	1	0	0	0	0	1	0	1	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	0	0	0	2	1	1	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	1	8	5	0	6	1	1	0	2	6	0	0	1	0	17	16	0	0	0	1	0	0	0	0	2	1	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	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	1	7	6	0	3	0	5	1	1	1	0	1	0	1	17	10	0	4	0	2	0	0	1	0	0	0	0	0	0
40	67	155252	151852	3902	142116	519	1777	59	3479	3400	3087	496	11	72	1	127	373	454	277	1109	24	2	34	3	74	30	277	102	53	5	31	0	0	2	3	2	0	19	1	8	17	18	15	0	1	0	0	29	20	0	3	0	5	0	1	0	0	0	0	0	0	0	0	6	6	0	0	1	1	155252	10536	144716	142238	2204	137243	405	1734	52	600	2478	2243	380	5	70	1	10	336	414	266	665	18	2	9	2	46	19	211	79	38	3	18	0	1	3	2	0	19	1	7	16	13	11	0	0	0	0	17	14	0	0	0	2	1	0	0	0	6	6	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	0	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	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	0	3	79	324	3	112	35	27	2	4	6	0	12	14	3	0	0	1	0	4	1	1	0	0	2	17	11	0	3	1	2	0	0	0	0	4	3	1	0	0
61	103	105803	98584	12006	48235	1509	17704	166	18964	7219	6678	468	70	192	6	1448	301	806	148	1028	318	13	273	52	1368	187	500	125	41	2	54	2	0	18	1	24	13	20	6	15	15	89	33	2	19	7	14	36	7	3	12	2	7	2	0	0	0	0	1	0	0	1	1	5	4	1	0	0	0	105803	29343	76460	71857	2765	45835	879	17579	126	4673	4603	4246	262	17	182	5	48	259	785	145	672	305	9	114	52	1269	122	335	91	35	2	19	1	0	1	11	1	16	6	5	12	80	26	2	13	0	14	17	5	1	4	2	3	0	1	0	1	5	4	1	0	0