new_york_city

Custom SQL query returning 7 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 "P0010048" = :p0 order by P0010050 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	P0010054	P0010055	P0010056	P0010057	P0010058	P0010059	P0010060	P0010061	P0010063	P0010064	P0010065	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	P0020036	P0020037	P0020038	P0020039	P0020040	P0020041	P0020042	P0020043	P0020044	P0020045	P0020046	P0020047	P0020049	P0020050	P0020051	P0020052	P0020053	P0020056	P0020057	P0020060	P0020061	P0020063	P0020065	P0020066	P0020067
36	61	159645	156825	121073	5940	299	24223	22	5268	2820	2690	312	83	1090	87	588	59	55	15	135	32	0	33	27	147	27	123	39	6	0	17	5	0	9	4	28	2	2	1	1	1	7	0	0	0	1	0	6	4	0	0	1	0	0	0	1	0	0	0	0	0	1	0	1	159645	13029	146616	144553	114720	5298	88	24107	14	326	2063	1993	237	64	1060	83	231	46	54	13	30	30	0	2	25	106	12	65	11	6	0	5	3	0	3	25	2	2	1	0	1	5	0	0	0	1	4	3	0	0	1	0	0	0	0	0	1	0	1
44	71	98429	95882	20812	70414	358	1253	35	3010	2547	2296	534	59	182	8	199	292	270	140	536	5	0	23	4	27	17	235	106	55	0	17	3	0	4	3	3	1	7	0	13	7	7	8	0	0	1	0	12	4	2	2	0	0	0	1	0	0	0	1	0	2	4	4	0	98429	9157	89272	87601	18825	66958	199	1214	25	380	1671	1506	405	32	173	7	33	254	239	134	200	3	0	8	4	13	1	152	62	44	0	10	2	0	3	3	0	6	0	3	7	6	5	0	0	1	9	3	1	1	0	0	1	0	1	2	4	4	0
56	90	116836	113116	80364	9974	805	5544	68	16361	3720	3448	528	166	489	46	1298	111	44	17	368	36	0	132	30	123	60	243	107	15	1	37	5	3	10	10	14	10	1	1	9	1	4	3	4	3	5	0	24	4	0	4	5	0	1	0	1	2	5	2	0	0	5	5	0	116836	37920	78916	77711	64467	7294	122	5456	28	344	1205	1122	179	97	450	35	127	70	29	9	26	20	0	2	30	46	2	77	48	4	0	3	3	0	8	6	1	1	1	0	1	1	0	0	0	0	6	3	0	0	1	1	0	0	1	0	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	2	0	0	0	1	1	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	2	1	0	1	0	0	0	0	0	3	1	0	4	2	0	0	0	0	0	2	0	0	1	1	0
58	100	47913	46726	29895	12694	165	1347	17	2608	1187	1058	248	65	106	6	197	104	65	19	139	14	3	13	3	55	21	116	46	12	1	14	2	0	3	1	3	2	4	2	9	7	0	5	0	3	2	0	10	4	0	5	0	1	0	0	0	0	0	0	0	0	3	3	0	47913	7161	40752	40067	26793	11609	94	1320	14	237	685	623	170	50	92	5	22	77	56	19	71	10	0	3	3	41	4	53	14	4	1	3	2	0	1	3	0	3	2	4	7	0	5	0	2	2	6	4	0	2	0	0	0	0	0	0	3	3	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	1	1	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	12	7	0	1	0	0	3	9	1	0	2	0	2	2	0	0	0	0	0	0	0	0	1	1	0
31	48	83266	78828	23662	28195	1377	1027	98	24469	4438	4142	698	88	101	12	1313	276	98	64	827	39	18	251	14	111	232	271	75	3	0	51	4	1	6	0	5	35	3	1	31	0	15	9	0	22	8	2	20	4	0	12	0	0	0	0	0	0	1	0	1	2	5	3	2	83266	53447	29819	29144	6219	21548	172	930	22	253	675	633	163	19	76	7	13	112	76	52	55	13	2	3	6	27	9	38	20	2	0	2	0	1	0	0	0	2	0	1	0	7	1	0	2	0	4	2	0	0	0	0	0	1	0	1	0	0	0