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 "P0010021" = :p0 order by P0010012 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	P0010057	P0010059	P0010060	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	P0020023	P0020024	P0020025	P0020026	P0020027	P0020028	P0020029	P0020030	P0020031	P0020032	P0020033	P0020034	P0020035	P0020036	P0020037	P0020038	P0020039	P0020040	P0020041	P0020042	P0020043	P0020044	P0020045	P0020046	P0020048	P0020049	P0020050	P0020051	P0020052	P0020054	P0020055	P0020056	P0020059	P0020061	P0020065	P0020066	P0020072	P0020073
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	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	0	1	3	2	0	19	1	7	16	13	11	0	0	0	17	14	0	0	2	0	1	0	0	6	6	1	1
52	81	62722	60811	4581	50302	408	1096	20	4404	1911	1740	424	36	44	5	243	334	112	27	410	10	2	22	4	34	33	148	55	28	4	29	0	0	2	0	2	0	4	2	7	3	6	4	0	0	1	1	20	13	0	3	1	2	0	0	0	0	0	1	3	2	1	0	0	0	62722	10474	52248	51243	2128	47638	243	1068	12	154	1005	910	286	11	44	1	8	277	99	23	133	10	2	6	4	6	0	83	37	18	4	5	0	0	0	0	1	0	3	1	4	3	2	4	0	0	1	11	9	0	2	0	0	0	0	0	1	1	0	0
49	77	90744	87649	15454	65502	388	2368	45	3892	3095	2796	711	63	359	7	217	352	193	98	647	11	2	41	13	50	32	254	131	29	4	16	9	0	1	5	8	0	12	1	8	3	13	10	1	1	1	1	40	22	1	11	0	3	1	0	1	0	1	0	1	1	0	0	4	4	90744	10759	79985	77899	13017	61952	203	2338	24	365	2086	1913	562	43	343	7	21	306	179	93	309	11	1	0	12	16	10	150	80	22	4	6	8	0	0	3	3	0	7	0	1	2	9	3	1	0	1	22	17	1	1	2	1	0	0	0	1	1	0	0
69	111	116431	114018	61915	2633	101	45921	18	3430	2413	2270	271	84	819	18	576	16	88	4	41	70	2	16	63	189	13	131	32	35	0	13	4	0	0	14	15	0	1	0	1	3	10	1	0	2	0	0	11	4	0	7	0	0	0	0	0	0	0	0	1	1	0	0	0	0	116431	11676	104755	103197	54690	2400	62	45763	14	268	1558	1485	157	61	761	17	104	13	79	4	9	68	2	0	63	145	2	70	13	21	0	0	1	0	0	12	7	0	1	0	0	3	9	1	0	2	0	2	2	0	0	0	0	0	0	0	1	1	0	0
33	50	101720	96855	54359	15730	757	5184	42	20783	4865	4377	1018	126	441	18	1404	132	85	19	656	26	2	163	17	166	104	441	207	38	10	71	6	2	17	3	10	16	5	4	10	0	12	4	0	12	14	0	36	11	0	20	2	1	1	0	0	0	0	1	10	6	1	3	1	1	101720	44156	57564	56199	39181	11432	146	5022	26	392	1365	1224	384	51	394	14	70	67	62	15	48	18	1	6	13	71	10	127	70	17	10	3	2	0	6	1	4	2	4	2	2	0	3	1	0	0	0	10	3	0	6	1	0	0	0	0	4	4	0	0
65	107	151107	144396	65452	20719	643	47326	130	10126	6711	6269	777	134	1788	77	1060	201	454	46	447	232	2	63	112	784	92	390	142	69	7	31	9	3	7	10	23	8	7	1	5	0	47	4	0	9	4	4	49	29	0	10	0	5	0	0	0	1	4	0	3	3	0	0	0	0	151107	25621	125486	120925	52871	19107	352	47039	91	1465	4561	4297	450	65	1705	74	137	173	419	46	183	220	2	15	109	641	58	236	77	55	6	8	7	0	0	6	14	2	5	1	2	0	42	3	0	6	2	27	18	0	1	4	0	0	1	3	1	1	0	0
11	19	208259	203870	178395	5365	231	16859	57	2963	4389	4098	610	243	2094	49	519	67	124	8	99	25	2	24	38	176	20	261	118	47	0	18	14	1	3	22	24	0	0	1	2	3	4	1	0	0	2	1	29	19	3	3	0	2	0	1	0	0	1	0	1	1	0	0	0	0	208259	13827	194432	190952	168711	4817	116	16727	48	533	3480	3298	469	189	2021	46	153	48	111	6	48	23	1	0	36	139	8	160	68	31	0	7	10	1	0	20	14	0	0	1	0	3	4	1	0	0	0	21	16	3	0	1	0	1	0	0	1	1	0	0