new_york_city

Custom SQL query returning 15 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 rowid 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	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	P0020056	P0020057	P0020058	P0020059	P0020060	P0020061	P0020062	P0020063	P0020065	P0020066	P0020067	P0020068	P0020072	P0020073
1	1	66679	64416	50484	2162	89	10569	26	1086	2263	2098	348	115	1151	28	174	48	53	0	39	8	1	5	26	99	3	151	64	28	1	8	3	1	3	20	16	1	2	0	1	1	2	0	0	0	0	0	13	7	1	3	0	1	0	0	1	0	0	0	0	0	0	0	1	1	0	0	0	0	0	66679	4676	62003	60094	47231	1982	57	10520	23	281	1909	1784	280	85	1110	26	61	44	52	0	20	7	1	1	25	71	1	113	52	22	1	3	2	1	1	15	12	1	2	0	0	0	1	0	0	0	0	0	11	6	1	2	0	1	0	1	0	0	0	0	0	0	1	1	0	0	0	0
5	9	76443	73259	48175	6904	361	10946	45	6828	3184	2877	534	155	912	31	590	123	63	6	199	25	5	73	31	88	42	275	139	28	2	24	11	0	5	17	13	8	6	6	6	0	5	1	0	0	4	0	28	16	4	4	1	1	0	0	2	0	0	0	0	0	0	0	3	2	1	0	0	1	1	76443	18291	58152	56307	39560	5466	127	10831	28	295	1845	1693	370	112	858	24	62	81	51	5	25	23	0	2	30	49	1	136	74	22	1	4	9	0	1	14	4	0	5	1	0	0	1	0	0	0	0	0	14	12	0	1	0	0	0	1	0	0	0	0	0	0	2	1	1	0	0	0
8	14	20651	20019	12868	1481	56	4964	13	637	632	586	91	31	196	13	92	29	16	0	34	18	0	10	19	31	6	42	26	1	1	4	4	0	0	2	2	0	1	0	1	0	0	0	0	0	0	0	4	0	0	3	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	20651	2198	18453	18005	11605	1353	34	4933	11	69	448	414	45	25	188	11	34	25	14	0	7	18	0	1	16	27	3	33	19	1	1	3	4	0	0	2	2	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0
14	23	73106	69507	24574	22948	733	5553	77	15622	3599	3271	592	63	268	15	996	205	67	22	610	55	8	153	38	130	49	293	142	17	1	45	2	0	4	7	14	10	2	0	8	0	12	9	0	6	5	9	29	11	0	17	0	1	0	0	0	0	0	0	0	0	0	0	6	5	0	1	0	0	0	73106	36656	36450	35344	10864	18582	131	5428	58	281	1106	986	271	15	237	7	39	145	59	19	58	45	0	2	35	52	2	105	55	12	0	8	2	0	0	7	5	0	2	0	3	0	4	2	0	0	0	5	11	10	0	0	0	1	0	0	0	0	0	0	0	0	4	4	0	0	0	0
16	25	47405	44920	10886	21943	608	1300	41	10142	2485	2268	474	46	110	3	710	227	71	17	437	13	0	95	3	34	28	197	115	10	2	19	4	0	9	1	6	3	6	1	8	1	3	3	1	3	2	0	18	6	1	10	0	1	0	0	0	0	0	0	0	0	0	0	2	1	1	0	0	0	0	47405	22634	24771	24064	3578	19008	114	1226	6	132	707	637	219	17	100	1	16	147	57	15	52	4	0	0	1	5	3	58	34	8	2	4	2	0	0	1	1	0	3	0	0	1	1	0	1	0	0	0	10	3	1	6	0	0	0	0	0	0	0	0	0	0	2	1	1	0	0	0
17	26	49508	47048	23703	11610	326	6220	29	5160	2460	2229	485	108	661	11	356	98	70	9	228	10	3	61	21	76	32	213	97	26	1	36	10	1	2	5	8	0	4	2	8	0	4	2	0	3	4	0	15	7	0	3	1	1	0	1	0	0	0	1	1	0	0	0	3	3	0	0	0	0	0	49508	12277	37231	35842	19207	10158	113	6163	23	178	1389	1266	277	64	629	7	34	82	68	5	30	6	1	2	20	41	0	114	62	22	1	5	6	0	0	5	6	0	1	2	0	0	2	0	0	2	0	0	9	4	0	3	1	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0
20	32	70942	68227	7498	51411	541	1282	33	7462	2715	2376	622	47	145	10	335	385	117	44	515	2	4	41	7	54	48	308	173	32	0	30	11	0	3	1	4	1	12	3	12	10	7	4	1	1	2	1	27	14	1	8	0	1	0	0	1	0	0	0	0	2	0	0	4	2	1	1	0	0	0	70942	16299	54643	53275	3823	47791	242	1217	19	183	1368	1163	398	34	132	4	14	305	98	34	114	2	3	0	5	20	0	184	119	22	0	15	3	0	0	1	1	0	7	2	2	7	4	1	0	0	0	0	18	13	0	3	0	0	0	0	0	0	0	0	2	0	3	1	1	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	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	0	1	2	3	0	0	1	1	0	0	0	0
30	47	152374	147258	21739	105538	1241	2982	89	15669	5116	4639	898	73	128	15	768	446	400	175	1001	70	9	116	25	342	173	441	172	36	1	64	4	0	3	1	18	7	18	4	29	8	36	21	0	6	10	3	32	13	0	6	4	1	0	0	0	0	0	0	3	4	1	0	2	2	0	0	0	2	2	152374	34919	117455	114957	10871	99102	587	2872	50	1475	2498	2266	456	28	111	4	44	333	373	164	338	55	3	17	19	266	55	216	90	21	1	24	0	0	0	0	5	1	7	2	10	6	30	14	0	1	1	3	14	7	0	1	4	0	0	0	0	0	0	1	0	1	0	0	0	0	2	2
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	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	0	1	1	2	13	6	0	0	0	0	0	0	0	1	2	0	3	1	0	0	0	0	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	0	0	1	0	0	10	6	1	0	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	0	10	3	0	6	0	1	0	0	0	0	0	0	0	0	4	4	0	0	0	0
50	78	66664	63672	49139	6940	221	3957	31	3384	2992	2744	607	165	1144	24	314	76	126	12	104	13	1	50	19	82	7	231	109	37	1	21	9	0	7	13	18	0	4	0	5	0	5	0	0	0	2	0	15	7	0	5	1	1	0	0	1	0	0	0	0	0	0	0	1	1	0	0	0	1	1	66664	10248	56416	54326	43996	6036	92	3891	18	293	2090	1955	457	95	1072	21	26	62	117	12	20	9	1	3	18	41	1	127	50	26	1	6	5	0	3	12	15	0	4	0	0	0	5	0	0	0	0	0	7	5	0	1	1	0	0	0	0	0	0	0	0	0	1	1	0	0	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	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	0	1	8	5	0	6	1	1	0	2	6	0	0	1	0	17	16	0	0	0	1	0	0	0	0	0	0	0	0	2	1	1	0	0	0
58	100	47913	46726	29895	12694	165	1347	17	2608	1187	1058	248	65	106	6	197	104	65	19	139	14	3	13	3	55	21	116	46	12	1	14	2	0	3	1	3	2	4	2	9	7	0	5	0	3	2	0	10	4	0	5	0	1	0	0	0	0	0	0	0	0	0	0	3	3	0	0	0	0	0	47913	7161	40752	40067	26793	11609	94	1320	14	237	685	623	170	50	92	5	22	77	56	19	71	10	0	3	3	41	4	53	14	4	1	3	2	0	0	1	3	0	3	2	4	7	0	5	0	2	2	0	6	4	0	2	0	0	0	0	0	0	0	0	0	0	3	3	0	0	0	0
64	106	122441	110973	43894	22601	1653	22456	182	20187	11468	10708	454	114	352	10	1197	177	2700	308	1437	423	31	247	124	2777	357	702	82	48	5	37	3	0	8	6	30	9	29	4	6	30	231	54	8	45	36	31	55	29	0	4	0	1	0	0	0	2	0	2	7	3	5	2	3	3	0	0	0	0	0	122441	28309	94132	84898	31739	20990	1156	22203	160	8650	9234	8622	224	51	320	9	88	150	2647	307	1168	402	27	145	124	2631	329	563	34	37	4	16	3	0	0	5	23	0	28	4	2	30	220	53	8	37	28	31	46	26	0	1	0	0	0	0	2	0	2	7	3	5	3	3	0	0	0	0