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 "P0010032" = :p0 order by P0020048 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	P0020059	P0020060	P0020061	P0020065	P0020066	P0020067	P0020069	P0020071	P0020072	P0020073
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	4	4	0	0	0	0	0
41	68	124491	121140	85271	2288	329	25884	39	7329	3351	3196	527	168	1170	60	761	33	79	7	105	35	0	38	20	183	10	135	59	21	2	14	6	2	9	7	11	0	0	1	1	0	1	0	1	0	0	0	19	8	0	5	0	4	0	0	1	0	0	1	0	0	0	0	1	0	0	0	1	0	0	0	124491	17868	106623	104486	76537	1757	97	25743	23	329	2137	2071	347	109	1110	57	118	27	73	4	36	35	0	1	19	133	2	59	18	15	1	3	4	2	0	6	7	0	0	1	0	0	1	0	1	0	0	0	6	5	0	0	0	0	0	1	0	1	0	0	1	0	0	0
46	73	86468	83795	5148	70679	675	633	35	6625	2673	2466	438	25	42	11	456	376	137	111	657	21	9	83	10	33	57	185	64	10	0	19	4	2	3	0	0	5	6	3	25	5	7	19	0	10	3	0	12	3	1	1	0	0	2	0	0	0	0	0	0	2	0	3	8	8	0	0	0	0	2	2	86468	17369	69099	67975	858	65930	287	604	16	280	1124	1032	224	12	27	4	13	299	123	100	177	12	8	9	9	13	2	82	43	5	0	3	1	0	0	0	0	0	6	3	7	3	7	2	0	1	1	0	5	3	1	1	0	0	0	0	0	5	5	0	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	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	2	1	1	0	0	0	0
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	0	0	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	3	3	0	0	0	1	1
26	43	172122	162252	40191	65492	2207	10187	174	44001	9870	8997	1368	167	304	37	2715	602	345	90	1636	210	19	486	30	600	388	814	342	66	1	116	7	2	28	0	33	22	31	6	55	11	30	7	0	28	21	8	52	11	5	18	0	5	6	0	0	0	0	4	1	1	0	1	7	2	3	1	0	1	0	0	172122	99213	72909	70277	4739	53042	562	9866	71	1997	2632	2368	411	30	198	14	49	330	289	75	281	179	2	56	30	361	63	242	89	38	0	14	3	1	1	0	5	0	16	4	19	8	12	2	0	13	12	5	19	6	1	5	0	2	0	4	1	3	0	2	0	1	0	0
7	13	93640	90828	70786	4864	194	12883	39	2062	2812	2562	429	108	1268	21	295	71	64	6	82	24	0	21	34	127	12	223	104	32	2	9	16	2	7	14	17	4	1	0	2	0	6	1	0	0	0	6	24	11	1	8	1	0	0	1	0	0	2	0	0	0	0	0	2	2	0	0	0	0	1	1	93640	8565	85075	82936	65354	4369	100	12785	31	297	2139	1975	287	84	1208	19	69	59	59	6	26	20	0	1	33	99	5	151	75	22	2	3	13	2	1	13	10	0	1	0	0	0	3	0	0	0	0	6	12	9	0	0	1	0	2	0	0	0	0	0	0	0	1	1