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 "P0010021" = :p0 order by P0020015 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	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	P0020056	P0020057	P0020063	P0020065	P0020066	P0020067
24	41	52246	48506	12955	15828	1041	455	50	18177	3740	3451	589	106	39	3	1232	233	33	19	747	20	3	229	0	97	101	266	127	3	0	31	2	0	8	1	10	8	4	0	53	0	6	5	0	4	4	0	20	2	0	11	0	4	0	1	0	0	0	1	1	0	0	0	0	3	3	52246	39089	13157	12807	694	11536	92	331	10	144	350	306	87	19	21	2	13	67	27	7	37	6	1	2	0	16	1	42	25	3	0	0	0	0	0	0	0	0	4	0	10	0	0	0	0	0	0	0	2	2	0	0	0	0	0	0	0	0	0	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	0	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	0	1	3	0	3	2	4	7	0	5	0	2	2	0	6	4	0	2	0	0	0	0	0	3	3	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	1	0	1	0	0	0	1	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	1	1	1	0
75	121	118708	114773	73769	16688	557	13217	78	10464	3935	3643	789	136	547	46	973	149	127	20	328	106	3	40	25	318	36	255	120	23	6	30	4	4	9	4	28	5	5	2	7	1	5	1	1	0	0	0	37	15	5	8	0	4	0	1	1	1	0	1	0	1	0	0	0	0	0	118708	27252	91456	89367	60934	14798	199	13050	43	343	2089	1949	570	93	479	39	97	115	113	18	56	93	1	2	24	242	7	121	62	15	6	5	2	4	2	4	9	0	5	2	1	1	2	0	1	0	0	0	19	10	3	3	0	1	0	1	1	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	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	2	1	1
17	26	49508	47048	23703	11610	326	6220	29	5160	2460	2229	485	108	661	11	356	98	70	9	228	10	3	61	21	76	32	213	97	26	1	36	10	1	2	5	8	0	4	2	8	0	4	2	0	3	4	0	15	7	0	3	1	1	1	0	0	0	1	1	0	0	3	3	0	0	0	49508	12277	37231	35842	19207	10158	113	6163	23	178	1389	1266	277	64	629	7	34	82	68	5	30	6	1	2	20	41	0	114	62	22	1	5	6	0	0	5	6	0	1	2	0	0	2	0	0	2	0	0	9	4	0	3	1	0	1	0	0	0	0	0
72	114	202766	195116	116720	23533	1176	29341	168	24178	7650	7157	1118	317	1396	81	2314	204	199	40	509	221	3	142	78	461	74	430	158	40	4	65	12	3	26	19	28	10	7	4	6	3	18	3	4	9	9	2	60	34	0	9	1	12	2	0	0	0	1	0	1	0	3	3	0	0	0	202766	54441	148325	144175	91531	21019	354	28947	133	2191	4150	3911	727	173	1286	74	448	151	177	35	184	204	3	18	74	343	14	218	87	22	4	16	9	2	0	18	15	6	7	4	2	3	10	1	2	5	3	2	19	12	0	2	0	3	2	0	0	2	2	0