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 "P0010039" = :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	P0010057	P0010058	P0010059	P0010063	P0010064	P0010068	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	P0020048	P0020049	P0020050	P0020051	P0020052	P0020053	P0020054	P0020055	P0020056	P0020059	P0020060	P0020065	P0020066	P0020072	P0020073
2	5	52568	51415	13436	2784	81	32795	18	2301	1153	1083	161	49	432	9	152	22	38	1	43	63	4	8	31	59	11	58	19	6	0	11	4	0	1	3	2	1	1	0	2	0	2	0	3	1	1	1	11	4	0	5	0	0	0	0	0	0	2	0	1	1	0	0	0	52568	5910	46658	45884	10739	2299	33	32708	13	92	774	742	89	37	412	7	17	18	33	1	3	60	2	0	30	33	0	27	9	6	0	0	4	0	0	2	1	0	1	0	0	0	0	0	3	1	0	4	2	0	0	0	0	0	0	0	2	1	1	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	3	3	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	13	11	0	1	0	0	0	1	0	0	2	2	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	2	0	0	2	2	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	6	12	9	0	0	1	0	0	0	2	0	0	0	1	1
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	1	1	1	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	21	16	3	0	0	1	0	1	0	0	1	1	0	0
12	20	102624	100080	84116	4511	183	9024	34	2212	2544	2359	337	135	1206	22	302	63	54	3	89	10	1	21	29	75	12	173	77	23	1	11	14	0	2	20	16	0	2	0	2	0	2	1	0	1	0	1	11	6	0	5	0	0	0	0	0	0	0	0	1	0	1	0	0	102624	8609	94015	92070	78880	3855	87	8958	25	265	1945	1822	258	107	1148	22	65	55	49	2	12	9	1	4	29	61	0	117	50	17	1	2	11	0	1	18	10	0	2	0	1	0	2	1	0	0	1	6	3	0	3	0	0	0	0	0	0	0	0	0	0
38	63	108646	106194	49114	48543	326	5091	24	3096	2452	2277	488	72	375	11	256	97	271	92	404	36	5	26	15	104	25	159	41	57	2	16	4	0	6	0	3	0	6	0	2	1	14	7	0	0	0	0	15	5	1	5	1	0	2	0	1	0	0	0	1	1	0	0	0	108646	9247	99399	97652	45309	46606	198	5045	22	472	1747	1619	362	59	336	11	52	88	258	90	225	33	2	2	12	86	3	123	29	49	1	11	4	0	0	0	3	0	5	0	2	1	13	5	0	0	0	5	1	0	1	1	0	2	0	0	0	0	0	0	0
54	84	48196	46319	33297	6470	158	4519	21	1854	1877	1735	327	104	710	14	180	101	49	16	112	6	1	23	15	64	13	137	59	28	3	11	5	0	4	5	7	0	6	0	2	2	3	2	0	0	0	0	4	2	0	2	0	0	0	0	0	0	0	0	1	1	0	0	0	48196	6078	42118	40735	30066	5935	79	4451	15	189	1383	1293	265	62	690	11	34	85	46	11	24	4	1	2	15	43	0	88	36	21	3	5	2	0	3	5	5	0	5	0	1	1	1	0	0	0	0	2	2	0	0	0	0	0	0	0	0	0	0	0	0