new_york_city

Custom SQL query returning 4 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 "P0010041" = :p0 order by P0020051 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	P0010050	P0010051	P0010052	P0010059	P0010061	P0010063	P0010064	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	P0020046	P0020048	P0020049	P0020050	P0020052	P0020053	P0020054	P0020063	P0020065	P0020066	P0020072	P0020073
15	24	106460	102158	72133	14662	458	7063	55	7787	4302	3859	876	176	994	32	801	192	100	19	362	24	4	96	21	116	46	402	209	34	1	56	10	3	20	12	11	4	4	0	13	4	10	0	2	5	2	2	36	16	15	0	4	1	0	3	3	2	2	106460	22738	83722	81494	61970	11979	134	6975	30	406	2228	2026	499	100	937	20	74	139	89	17	47	22	1	5	20	54	2	188	121	24	1	5	5	1	0	12	7	1	2	0	0	4	4	0	0	1	13	11	0	0	2	0	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	3	0	2	5	0	1	1	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	3	1	0	0	2	0	1	1	4	4
42	69	84480	82675	6885	70837	311	2273	14	2355	1805	1658	352	23	93	15	139	191	234	138	379	13	1	9	12	39	20	133	27	30	1	16	1	0	1	6	2	4	10	1	8	8	10	8	0	0	0	0	13	5	5	2	0	0	1	0	0	1	1	84480	7059	77421	76134	4972	68396	193	2233	8	332	1287	1171	248	16	85	13	10	162	217	128	237	10	0	1	12	27	5	102	20	28	1	11	1	0	1	6	0	3	9	1	1	8	8	4	0	0	13	5	5	2	0	1	0	0	1	1
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	7	0	0	0	0	1	1	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	2	0	2	2	0	0	0	0	1	1	0	0