new_york_city

Custom SQL query returning 16 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 "P0010049" = :p0 order by P0020022 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	P0020055	P0020056	P0020057	P0020059	P0020060	P0020062	P0020063	P0020065	P0020066	P0020067	P0020068	P0020072	P0020073
20	32	70942	68227	7498	51411	541	1282	33	7462	2715	2376	622	47	145	10	335	385	117	44	515	2	4	41	7	54	48	308	173	32	0	30	11	0	3	1	4	1	12	3	12	10	7	4	1	1	2	1	27	14	1	8	0	1	0	0	1	0	0	0	0	2	0	0	4	2	1	1	0	0	70942	16299	54643	53275	3823	47791	242	1217	19	183	1368	1163	398	34	132	4	14	305	98	34	114	2	3	0	5	20	0	184	119	22	0	15	3	0	0	1	1	0	7	2	2	7	4	1	0	0	0	0	18	13	0	3	0	0	0	0	0	0	0	2	0	3	1	1	1	0	0
16	25	47405	44920	10886	21943	608	1300	41	10142	2485	2268	474	46	110	3	710	227	71	17	437	13	0	95	3	34	28	197	115	10	2	19	4	0	9	1	6	3	6	1	8	1	3	3	1	3	2	0	18	6	1	10	0	1	0	0	0	0	0	0	0	0	0	0	2	1	1	0	0	0	47405	22634	24771	24064	3578	19008	114	1226	6	132	707	637	219	17	100	1	16	147	57	15	52	4	0	0	1	5	3	58	34	8	2	4	2	0	0	1	1	0	3	0	0	1	1	0	1	0	0	0	10	3	1	6	0	0	0	0	0	0	0	0	0	2	1	1	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	0	1	0	0	0	0	1	1	0	0	0	0
49	77	90744	87649	15454	65502	388	2368	45	3892	3095	2796	711	63	359	7	217	352	193	98	647	11	2	41	13	50	32	254	131	29	4	16	9	0	1	5	8	0	12	1	8	3	13	10	1	1	1	1	40	22	1	11	0	3	1	0	1	0	0	0	1	0	0	0	1	1	0	0	4	4	90744	10759	79985	77899	13017	61952	203	2338	24	365	2086	1913	562	43	343	7	21	306	179	93	309	11	1	0	12	16	10	150	80	22	4	6	8	0	0	3	3	0	7	0	1	2	9	3	1	0	0	1	22	17	1	1	0	2	1	0	0	0	0	0	0	1	1	0	0	0	0
51	79	90263	87018	20375	54877	600	2443	88	8635	3245	2956	645	79	216	21	552	406	166	57	579	18	8	87	10	58	54	268	137	20	1	25	5	0	4	2	12	6	17	1	15	4	7	6	1	3	2	0	21	7	1	5	1	5	0	0	0	1	0	1	0	0	0	0	0	0	0	0	0	0	90263	20014	70249	68615	14506	51142	210	2390	55	312	1634	1471	458	40	201	17	37	349	140	50	134	11	3	2	10	18	1	151	82	19	1	9	5	0	0	1	6	2	9	1	5	4	5	2	0	0	0	0	12	7	0	2	1	1	0	0	0	0	1	0	0	0	0	0	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	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	0	0	0	0	5	5	0	0	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	0	0	1	0	0	4	3	1	0	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	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	0	0	0	2	0	0	0	0	0	0	0	1	1
10	18	54066	52216	37624	3106	168	8462	27	2829	1850	1721	262	98	570	14	407	32	61	5	95	21	0	24	25	98	9	121	59	4	0	17	9	0	2	13	12	2	2	0	1	0	0	0	0	0	0	0	7	2	1	2	0	0	0	0	1	0	0	0	1	0	0	0	1	1	0	0	0	0	54066	8883	45183	44019	32682	2637	68	8389	25	218	1164	1088	179	60	537	13	65	25	60	5	30	20	0	1	24	68	1	73	40	2	0	2	6	0	1	12	8	0	2	0	0	0	0	0	0	0	0	0	3	1	0	2	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
76	122	138982	136452	119790	3397	330	8474	43	4418	2530	2358	469	166	658	29	649	52	52	9	85	32	0	18	23	99	17	154	52	8	0	17	17	0	3	10	29	5	4	1	0	1	4	0	0	3	0	0	17	10	1	3	0	2	1	0	0	0	0	0	0	0	0	0	1	0	1	0	0	0	138982	15903	123079	121540	109879	2863	168	8370	32	228	1539	1434	361	135	583	25	89	42	39	9	19	29	0	5	22	75	1	96	32	5	0	7	16	0	0	10	15	0	4	1	0	1	4	0	0	1	0	0	8	4	0	1	0	2	1	0	0	0	0	0	0	1	0	1	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	0	0	0	0	1	1	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	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	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	0	1	2	3	1	0	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	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	0
39	66	191382	187193	134948	5312	709	34011	48	12165	4189	3886	472	144	903	61	1223	55	204	23	196	186	0	82	30	243	64	276	150	23	1	17	11	1	6	3	18	8	4	0	1	6	17	1	0	2	5	2	21	12	1	1	6	0	0	0	0	0	0	1	0	0	0	0	1	1	0	0	5	5	191382	24854	166528	164193	125152	4338	179	33856	22	646	2335	2246	288	72	875	43	206	43	189	23	79	183	0	14	29	192	10	82	13	21	1	0	10	0	0	1	11	0	4	0	1	4	15	0	0	1	0	0	6	2	0	0	3	0	0	0	0	0	1	0	0	0	0	0	0	1	1
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	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	0	1	0	0	1	0	1	3	3	0	0	0	0
66	108	113200	107851	50190	2937	940	36453	57	17274	5349	5107	472	164	923	35	2023	31	104	13	173	354	1	136	98	514	66	206	57	19	2	25	10	0	21	11	30	7	1	0	0	1	6	4	1	7	3	1	35	22	1	6	0	3	0	0	0	0	2	1	0	0	0	0	1	1	0	0	0	0	113200	39207	73993	71623	32470	2132	187	36239	36	559	2370	2257	223	57	837	24	127	20	99	8	33	329	0	2	94	391	13	85	22	18	0	6	3	0	0	9	10	2	0	0	0	1	6	1	1	6	0	0	27	18	1	4	0	3	0	0	0	1	0	0	0	1	1	0	0	0	0