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 "P0010064" = :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	P0010056	P0010057	P0010058	P0010059	P0010060	P0010061	P0010062	P0010063	P0010064	P0010065	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	P0020061	P0020063	P0020065	P0020066	P0020067	P0020072	P0020073
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	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
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	0	2	0	0	0	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	0	4	2	0	0	0	0	0	0	0	0	2	0	0	1	1	0	0	0
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	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
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	0	1	0	0	0	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	0	21	16	3	0	0	1	0	1	0	0	0	0	0	1	1	0	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	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
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	0	5	0	0	0	1	1	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	0	1	1	0	4	4
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	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
29	46	128200	120132	23931	46932	2326	2140	133	44670	8068	7408	1308	117	70	20	2410	398	173	55	1610	91	18	545	7	254	332	618	200	27	4	78	1	1	30	1	26	33	14	1	60	2	19	41	2	25	44	9	35	2	0	8	1	1	1	0	1	4	2	2	10	2	0	1	1	1	0	6	6	128200	85600	42600	41479	1791	36795	318	1902	47	626	1121	995	236	11	35	3	34	215	150	43	118	35	2	19	7	82	5	118	59	19	1	3	0	0	4	0	2	3	6	0	6	2	2	5	0	4	0	2	7	0	0	1	0	0	0	0	0	1	2	3	0	1	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	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
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	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	1	1
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	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
50	78	66664	63672	49139	6940	221	3957	31	3384	2992	2744	607	165	1144	24	314	76	126	12	104	13	1	50	19	82	7	231	109	37	1	21	9	0	7	13	18	0	4	0	5	0	5	0	0	0	2	0	15	7	0	5	1	1	0	0	1	0	0	0	0	0	0	0	1	1	0	1	1	66664	10248	56416	54326	43996	6036	92	3891	18	293	2090	1955	457	95	1072	21	26	62	117	12	20	9	1	3	18	41	1	127	50	26	1	6	5	0	3	12	15	0	4	0	0	0	5	0	0	0	0	0	7	5	0	1	1	0	0	0	0	0	0	0	0	1	1	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	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	0	2	2	0	0	0	0	0	0	0	0	0	0	0	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	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	0	0	0	0	2	1	1	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	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
69	111	116431	114018	61915	2633	101	45921	18	3430	2413	2270	271	84	819	18	576	16	88	4	41	70	2	16	63	189	13	131	32	35	0	13	4	0	0	14	15	0	1	0	1	3	10	1	0	2	0	0	11	4	0	7	0	0	0	0	0	0	0	0	0	0	0	0	1	1	0	0	0	116431	11676	104755	103197	54690	2400	62	45763	14	268	1558	1485	157	61	761	17	104	13	79	4	9	68	2	0	63	145	2	70	13	21	0	0	1	0	0	12	7	0	1	0	0	3	9	1	0	2	0	0	2	2	0	0	0	0	0	0	0	0	0	0	0	1	1	0	0	0