new_york_city

Custom SQL query returning 8 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 "P0010057" = :p0 order by P0020046 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	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	P0020056	P0020057	P0020059	P0020060	P0020061	P0020062	P0020063	P0020065	P0020066	P0020067	P0020069	P0020071
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	0	1	1	1	0	1	0	1	0	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	0	1	0	0	0	0	0
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	1	2	0	3	1	0	0	0	0	0
28	45	120833	116361	61310	31256	792	5668	68	17267	4472	4065	916	108	307	33	1313	241	110	28	584	68	3	101	10	145	98	367	197	18	1	50	14	0	3	2	25	9	5	1	8	2	8	13	1	5	3	2	38	24	1	7	0	3	0	0	1	0	1	0	0	0	1	0	1	1	0	0	0	1	1	120833	44175	76658	75118	41615	26967	277	5506	33	720	1540	1381	387	60	259	26	83	176	99	25	79	58	1	8	10	95	15	145	77	11	0	7	6	0	0	2	12	6	3	0	1	1	7	6	1	3	2	0	13	9	1	2	0	0	0	0	0	0	0	0	1	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	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	0	1	1	0	0	5	1	4	0	0
53	83	112634	106366	34183	28095	1522	4953	135	37478	6268	5892	820	141	215	37	2618	175	127	71	872	59	26	325	25	192	189	359	91	17	4	68	4	0	33	7	20	28	11	0	9	5	17	16	1	16	5	7	17	7	0	5	0	2	0	1	0	0	1	0	1	0	0	0	0	0	0	0	0	0	0	112634	73616	39018	37849	9564	22688	201	4776	31	589	1169	1071	235	34	170	14	55	115	103	52	129	32	0	10	19	92	11	88	27	11	2	3	2	0	0	7	5	0	9	0	1	5	8	3	0	4	0	1	10	5	0	1	0	2	1	0	1	0	0	0	0	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	0	1	0	4	0	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	0	1	1	0	0	0
63	105	188582	180965	33672	107918	941	27881	157	10396	7617	7046	849	130	471	9	752	480	1041	184	1063	330	5	114	71	1436	111	513	169	81	1	57	7	0	1	2	24	2	14	2	5	5	89	9	2	8	22	13	54	23	1	6	4	8	2	1	5	0	1	1	0	0	1	1	3	3	0	0	0	1	1	188582	22337	166245	160557	24611	104029	670	27688	125	3434	5688	5306	587	64	419	8	87	418	999	178	658	319	3	47	71	1360	88	352	112	65	1	20	1	0	0	2	20	0	9	2	0	5	83	9	2	7	3	11	27	16	1	0	2	5	1	0	0	1	0	0	1	3	3	0	0	0
60	102	144215	133130	53920	14911	1824	31644	193	30638	11085	10365	878	250	727	43	2386	127	1448	175	1045	461	7	358	61	2075	324	665	159	29	3	53	11	0	23	7	37	5	35	6	8	30	135	35	5	45	22	17	50	16	2	6	4	3	3	0	5	0	1	0	2	0	8	0	4	0	1	1	2	1	1	144215	58785	85430	78849	28658	12026	962	31317	149	5737	6581	6141	319	60	653	37	114	103	1405	167	586	427	7	118	61	1904	180	411	55	16	2	12	4	0	1	7	18	0	31	6	4	29	129	28	5	40	11	13	26	10	0	0	3	1	0	1	1	0	2	0	8	3	0	0	1	2