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 "P0010053" = :p0 order by P0020038 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	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	P0020046	P0020047	P0020048	P0020049	P0020050	P0020051	P0020052	P0020053	P0020054	P0020055	P0020056	P0020059	P0020060	P0020061	P0020063	P0020064	P0020065	P0020066	P0020067	P0020069
21	33	76958	71025	22218	14215	1277	2315	62	30938	5933	5374	941	126	233	16	2034	152	68	16	996	37	19	361	12	150	213	521	149	41	2	154	4	5	19	0	23	12	5	0	21	0	6	13	2	52	11	2	30	5	0	18	0	0	1	1	0	2	0	0	2	0	0	1	8	4	3	0	1	0	0	0	76958	57168	19790	19009	7895	8619	113	2109	5	268	781	701	214	37	182	5	29	89	53	12	31	6	0	8	7	27	1	72	39	15	0	2	2	1	1	0	3	0	4	0	2	0	2	1	0	0	0	0	3	3	0	0	0	0	0	0	0	0	0	0	0	5	1	3	1
27	44	146441	137552	25956	58890	2114	2504	110	47978	8889	8248	1233	111	144	27	2932	512	134	95	1841	86	8	500	21	262	342	603	160	31	3	138	5	0	22	1	27	28	10	2	54	1	28	36	5	24	21	7	31	12	0	7	0	2	1	0	2	2	0	1	1	1	0	2	5	4	1	0	0	0	2	2	146441	92338	54103	52721	2193	47344	310	2232	26	616	1382	1243	268	17	105	4	16	271	99	86	159	50	1	15	20	109	23	130	62	20	2	6	1	0	0	1	7	0	4	0	5	0	12	0	1	3	0	6	7	4	0	1	0	0	0	0	0	0	0	0	2	2	2	0	0
34	52	139307	130239	37395	35034	2243	9458	117	45992	9068	8374	1395	137	270	32	2979	296	181	103	1613	166	19	500	51	358	274	638	181	45	7	138	2	14	27	0	24	42	8	3	23	11	27	31	0	30	25	0	46	15	0	19	0	3	1	0	3	1	0	1	1	1	1	0	4	4	0	0	0	0	6	6	139307	90981	48326	46654	10034	26171	317	9156	33	943	1672	1551	284	29	205	21	67	142	147	76	159	121	4	33	47	187	29	110	24	24	1	6	1	8	0	0	2	0	5	2	5	8	14	2	0	6	2	0	11	8	0	0	0	0	1	0	0	1	0	1	0	0	0	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	0	0	1	0	0	0	1	1	0	0	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	0	1	22	17	1	1	0	2	1	0	0	0	0	0	0	1	1	0	0
76	122	138982	136452	119790	3397	330	8474	43	4418	2530	2358	469	166	658	29	649	52	52	9	85	32	0	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	0	1	0	1	0	0	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	0	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
18	28	44781	42566	9799	27033	321	1607	43	3763	2215	1934	526	64	221	12	223	251	118	28	347	19	0	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	0	1	1	4	3	1	0	0	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	0	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	1	0	0	0	4	3	1	0
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	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	0	5	15	1	1	0	0	0	11	2	1	2	0	0	17	16	0	0	0	1	0	0	0	0	0	0	0	1	0	1	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	0	0	1	0	0	10	6	1	0	3	0	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	0	10	3	0	6	0	1	0	0	0	0	0	0	0	4	4	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	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	0	2	0	1	2	2	0	0	0	0	0	0	0	0	0	0	0	2	2	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	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	0	4	0	2	7	0	0	1	0	0	0	0	1	2	3	0	0	1	1	0	0
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	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	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
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	0	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	0	2	1	22	12	0	2	2	3	0	2	0	0	0	1	0	5	5	0	0