new_york_city

Custom SQL query returning 13 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 "P0020038" = :p0 order by P0020066 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	P0020056	P0020057	P0020060	P0020061	P0020063	P0020065	P0020066	P0020067	P0020072	P0020073
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	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	1	1	0	0	0	2	2
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
56	90	116836	113116	80364	9974	805	5544	68	16361	3720	3448	528	166	489	46	1298	111	44	17	368	36	0	132	30	123	60	243	107	15	1	37	5	3	10	10	14	10	1	1	9	1	4	3	4	3	5	0	24	4	0	4	5	0	0	1	0	1	2	5	2	0	0	0	5	5	0	0	0	0	116836	37920	78916	77711	64467	7294	122	5456	28	344	1205	1122	179	97	450	35	127	70	29	9	26	20	0	2	30	46	2	77	48	4	0	3	3	0	0	8	6	1	1	1	0	1	1	0	0	0	0	0	6	3	0	0	1	0	1	0	0	1	0	0	0	0	0	0
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	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	1	1	0	0	0
15	24	106460	102158	72133	14662	458	7063	55	7787	4302	3859	876	176	994	32	801	192	100	19	362	24	4	96	21	116	46	402	209	34	1	56	10	3	20	12	11	4	4	0	13	4	10	0	2	5	2	2	36	16	0	15	0	4	0	0	0	0	0	0	1	0	0	0	3	3	0	0	2	2	106460	22738	83722	81494	61970	11979	134	6975	30	406	2228	2026	499	100	937	20	74	139	89	17	47	22	1	5	20	54	2	188	121	24	1	5	5	1	0	12	7	1	2	0	0	4	4	0	0	0	0	1	13	11	0	0	0	2	0	0	0	0	0	1	1	0	0	0
73	115	171576	162076	66142	13700	1914	27250	85	52985	9500	9029	818	243	671	35	4821	113	166	77	515	260	17	438	66	660	129	421	113	33	1	74	16	0	36	7	48	29	9	1	4	0	15	11	1	7	13	3	44	25	5	3	0	8	0	0	0	0	1	1	1	0	0	0	6	2	4	0	0	0	171576	110108	61468	59259	20334	10683	243	26996	30	973	2209	2068	194	25	562	23	133	96	149	60	75	229	0	6	65	442	9	113	33	27	1	7	5	0	0	3	7	1	6	1	2	0	12	1	1	3	0	3	23	19	0	0	0	2	0	0	1	1	0	5	1	4	0	0
3	6	62226	60490	53227	1316	80	5023	21	823	1736	1596	286	121	883	13	120	23	41	1	29	7	0	6	27	37	2	119	53	10	0	10	14	0	2	12	12	1	1	0	2	0	1	1	0	0	0	0	18	14	0	3	0	0	0	1	0	0	0	0	0	0	0	0	3	3	0	0	0	0	62226	3781	58445	56956	50468	1214	47	4983	20	224	1489	1384	244	92	863	8	45	20	35	1	9	7	0	0	27	32	1	90	41	8	0	5	12	0	1	12	8	1	1	0	0	0	1	0	0	0	0	0	13	11	0	1	0	0	1	0	0	0	0	2	2	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
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	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	1	0	0	4	3	1	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
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
47	75	183328	175374	26869	105452	1814	9134	177	31928	7954	7347	1010	105	178	7	2145	599	435	163	1495	172	9	284	33	498	214	564	181	40	6	101	4	2	15	0	15	22	16	2	25	7	62	25	1	15	22	3	32	9	0	9	0	10	0	0	1	1	0	1	0	0	1	0	10	9	0	1	1	1	183328	67131	116197	113289	6245	94685	715	8979	85	2580	2908	2667	371	35	128	5	46	415	391	131	420	161	4	59	25	408	68	219	75	28	4	7	3	1	0	0	6	1	13	2	7	6	44	14	0	5	2	1	18	7	0	3	0	8	0	0	0	0	0	3	3	0	1	1
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	0	1	11	1	16	6	5	12	80	26	2	13	0	14	17	5	1	4	2	3	0	0	1	0	1	5	4	1	0	0