new_york_city

Custom SQL query returning 9 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 "P0020039" = :p0 order by P0010007 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	P0010055	P0010056	P0010057	P0010058	P0010059	P0010060	P0010061	P0010063	P0010064	P0010065	P0010066	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	P0020057	P0020059	P0020060	P0020061	P0020063	P0020065	P0020066	P0020067	P0020072	P0020073
6	10	50180	48333	35838	4171	170	5653	15	2486	1847	1670	407	113	545	9	288	75	32	6	77	16	4	20	12	54	12	161	86	14	1	15	0	0	1	5	15	3	5	0	5	1	7	0	0	0	3	0	12	6	0	5	0	0	0	0	0	0	0	1	0	0	4	2	1	0	1	0	0	50180	8821	41359	40202	30799	3518	71	5604	12	198	1157	1062	250	75	509	8	58	59	28	6	9	14	2	0	12	31	1	88	50	10	0	6	0	0	0	5	10	0	5	0	0	0	2	0	0	0	0	0	5	5	0	0	0	0	0	0	0	0	0	0	2	1	1	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	0	0	1	1	0	0	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	0	2	2	0	0	0	0	0	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	1	0	0	0	0	0	0	1	1	0	0	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	0	5	1	0	1	1	0	2	0	0	0	0	0	0	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	2	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	2	1	1	0	0
23	40	91497	86028	21270	31385	1782	646	72	30873	5469	5127	607	81	62	16	1902	423	78	25	1201	39	13	293	3	110	274	321	74	14	3	56	0	1	7	4	6	27	6	6	64	4	3	23	1	10	10	2	19	5	0	6	1	0	0	0	0	0	0	0	4	3	2	0	0	1	1	0	0	91497	64887	26610	26043	1428	23680	177	525	17	216	567	518	148	7	40	6	9	114	50	17	85	19	0	1	3	17	2	49	22	10	0	0	0	0	0	3	0	0	5	1	1	1	2	3	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
75	121	118708	114773	73769	16688	557	13217	78	10464	3935	3643	789	136	547	46	973	149	127	20	328	106	3	40	25	318	36	255	120	23	6	30	4	4	9	4	28	5	5	2	7	1	5	1	1	0	0	0	37	15	5	8	0	4	0	1	1	1	0	1	0	1	0	0	0	0	0	0	0	118708	27252	91456	89367	60934	14798	199	13050	43	343	2089	1949	570	93	479	39	97	115	113	18	56	93	1	2	24	242	7	121	62	15	6	5	2	4	2	4	9	0	5	2	1	1	2	0	1	0	0	0	19	10	3	3	0	1	0	1	0	0	0	1	0	0	0	0	0
34	52	139307	130239	37395	35034	2243	9458	117	45992	9068	8374	1395	137	270	32	2979	296	181	103	1613	166	19	500	51	358	274	638	181	45	7	138	2	14	27	0	24	42	8	3	23	11	27	31	0	30	25	0	46	15	0	19	0	3	1	3	1	0	1	1	1	1	4	4	0	0	0	6	6	139307	90981	48326	46654	10034	26171	317	9156	33	943	1672	1551	284	29	205	21	67	142	147	76	159	121	4	33	47	187	29	110	24	24	1	6	1	8	0	0	2	0	5	2	5	8	14	2	0	6	2	0	11	8	0	0	0	0	1	0	0	1	0	1	0	0	0	0	0
65	107	151107	144396	65452	20719	643	47326	130	10126	6711	6269	777	134	1788	77	1060	201	454	46	447	232	2	63	112	784	92	390	142	69	7	31	9	3	7	10	23	8	7	1	5	0	47	4	0	9	4	4	49	29	0	10	0	5	0	0	0	1	0	4	0	0	3	3	0	0	0	0	0	151107	25621	125486	120925	52871	19107	352	47039	91	1465	4561	4297	450	65	1705	74	137	173	419	46	183	220	2	15	109	641	58	236	77	55	6	8	7	0	0	6	14	2	5	1	2	0	42	3	0	6	0	2	27	18	0	1	0	4	0	0	1	0	3	0	1	1	0	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	5	0	0	1	1	0	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	0	1	1	0	4	4