new_york_city

Custom SQL query returning 3 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 P0020033 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	P0010039	P0010040	P0010041	P0010042	P0010043	P0010044	P0010045	P0010046	P0010047	P0010048	P0010049	P0010050	P0010051	P0010052	P0010053	P0010054	P0010057	P0010058	P0010059	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	P0020036	P0020037	P0020038	P0020039	P0020041	P0020042	P0020043	P0020044	P0020046	P0020047	P0020048	P0020049	P0020050	P0020052	P0020053	P0020054	P0020056	P0020059	P0020060	P0020065	P0020066	P0020067	P0020072	P0020073
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	9	5	17	16	1	16	5	7	17	7	0	5	0	2	0	1	1	0	1	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	7	5	0	9	1	5	8	3	4	0	1	10	5	1	0	2	1	1	0	0	0	0	0	0
68	110	172634	163788	50935	11427	1700	57640	75	42011	8846	8477	623	156	812	37	4303	111	158	22	456	406	6	330	145	757	155	326	55	17	4	70	8	0	47	5	17	21	3	5	0	17	18	4	25	8	2	37	17	0	13	0	2	2	0	3	0	0	6	3	3	0	0	172634	90314	82320	79786	12352	9091	299	57253	39	752	2534	2437	111	27	718	21	113	88	146	17	73	386	1	8	140	575	13	75	8	11	2	1	6	4	4	1	3	0	0	13	8	11	1	2	18	16	2	0	0	0	0	0	4	2	2	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	1	6	17	1	0	2	5	2	21	12	1	1	6	0	0	0	0	1	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	1	11	0	4	1	4	15	0	1	0	0	6	2	0	3	0	0	0	1	0	0	0	1	1