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 "P0010052" = :p0 order by P0010037 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	P0020034	P0020035	P0020036	P0020037	P0020038	P0020039	P0020040	P0020041	P0020042	P0020043	P0020044	P0020045	P0020046	P0020047	P0020048	P0020049	P0020050	P0020051	P0020052	P0020053	P0020054	P0020055	P0020056	P0020059	P0020061	P0020064	P0020065	P0020066	P0020067	P0020072	P0020073
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	0	0	1	0	0	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	0	21	16	3	0	0	1	0	1	0	0	0	1	1	0	0	0
37	62	181981	178420	100902	1894	537	63153	156	11778	3561	3431	296	128	1261	67	1123	20	80	6	66	94	1	58	36	155	40	112	41	9	2	6	6	0	7	11	15	4	1	2	0	1	3	0	3	0	1	0	13	11	0	0	0	2	0	0	0	0	0	0	0	0	0	0	4	3	0	1	1	1	181981	24239	157742	155581	90741	1362	145	62901	47	385	2161	2093	201	83	1206	58	228	13	74	6	15	88	1	0	35	81	4	55	12	7	2	1	4	0	0	11	10	1	0	1	0	1	3	0	2	0	0	0	9	9	0	0	0	0	0	0	0	0	0	3	3	0	1	1
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	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	1	0	1	0	0
62	104	170190	164755	120143	4320	934	13384	87	25887	5435	5058	777	229	669	102	2229	35	78	21	334	68	16	169	22	208	101	352	144	22	3	56	13	0	19	8	25	5	3	0	8	2	22	11	0	4	7	0	21	12	0	4	1	2	0	0	0	0	0	0	0	2	0	0	4	2	2	0	0	0	170190	58947	111243	109604	93378	2368	222	13118	32	486	1639	1543	300	96	599	91	143	20	60	15	35	58	3	3	22	90	8	83	26	12	0	4	9	0	2	8	3	0	2	0	0	0	14	3	0	0	0	0	13	11	0	0	0	2	0	0	0	0	0	0	0	0	0	0
68	110	172634	163788	50935	11427	1700	57640	75	42011	8846	8477	623	156	812	37	4303	111	158	22	456	406	6	330	145	757	155	326	55	17	4	70	8	0	47	5	17	21	3	0	5	0	17	18	4	25	8	2	37	17	0	13	0	2	2	0	0	0	3	0	0	0	0	0	6	3	3	0	0	0	172634	90314	82320	79786	12352	9091	299	57253	39	752	2534	2437	111	27	718	21	113	88	146	17	73	386	1	8	140	575	13	75	8	11	2	1	6	0	0	4	4	1	3	0	0	0	13	8	0	11	1	2	18	16	0	2	0	0	0	0	0	0	0	4	2	2	0	0
19	30	60685	56601	14707	21103	816	1465	42	18468	4084	3730	701	113	178	5	1264	169	88	37	726	18	5	229	10	107	80	322	135	22	1	83	5	4	11	2	12	4	4	4	10	1	5	1	0	10	6	2	29	6	0	14	1	2	0	0	1	2	0	0	0	0	3	0	3	3	0	0	0	0	60685	34825	25860	24895	6178	16951	161	1369	19	217	965	849	265	55	164	2	37	120	77	24	64	11	0	5	8	16	1	106	65	14	1	2	4	0	0	2	3	1	4	4	1	1	3	0	0	0	1	0	7	3	0	2	1	1	0	0	0	0	0	3	3	0	0	0
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	0	0	1	0	0	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	0	1	11	9	0	2	0	0	0	0	0	0	0	1	1	0	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	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	1	0	1	0	0
25	42	79762	75079	13814	38416	1357	448	240	20804	4683	4348	587	64	40	14	1329	489	80	81	1112	18	14	282	3	104	131	315	68	19	2	57	0	0	18	0	2	6	6	0	79	3	10	16	1	18	7	3	15	5	0	3	0	2	0	0	0	0	0	0	5	0	0	0	1	1	0	0	4	4	79762	46013	33749	33114	918	31387	230	358	22	199	635	557	146	11	16	2	18	160	57	61	67	6	1	3	0	5	4	70	35	10	2	4	0	0	1	0	0	0	5	0	7	0	5	1	0	0	0	0	3	1	0	0	0	2	0	0	0	0	0	1	1	0	4	4
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	0	1	7	6	0	3	0	5	1	1	1	0	1	0	1	17	10	0	4	0	2	0	0	0	1	0	0	0	0	0	0
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	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	2	2	2	0	0	0
53	83	112634	106366	34183	28095	1522	4953	135	37478	6268	5892	820	141	215	37	2618	175	127	71	872	59	26	325	25	192	189	359	91	17	4	68	4	0	33	7	20	28	11	0	9	5	17	16	1	16	5	7	17	7	0	5	0	2	0	1	0	0	1	0	1	0	0	0	0	0	0	0	0	0	112634	73616	39018	37849	9564	22688	201	4776	31	589	1169	1071	235	34	170	14	55	115	103	52	129	32	0	10	19	92	11	88	27	11	2	3	2	0	0	7	5	0	9	0	1	5	8	3	0	4	0	1	10	5	0	1	0	2	0	1	1	0	0	0	0	0	0	0