new_york_city

Custom SQL query returning 9 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 P0010034 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	P0010055	P0010056	P0010058	P0010059	P0010060	P0010061	P0010062	P0010063	P0010064	P0010065	P0010066	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	P0020035	P0020036	P0020037	P0020038	P0020039	P0020040	P0020041	P0020042	P0020043	P0020044	P0020045	P0020046	P0020047	P0020048	P0020049	P0020050	P0020051	P0020052	P0020053	P0020054	P0020057	P0020060	P0020061	P0020062	P0020063	P0020065	P0020066	P0020067	P0020068
46	73	86468	83795	5148	70679	675	633	35	6625	2673	2466	438	25	42	11	456	376	137	111	657	21	9	83	10	33	57	185	64	10	0	19	4	2	3	0	0	5	6	3	25	5	7	19	0	10	3	0	12	3	1	1	0	0	2	0	0	0	0	2	0	3	8	8	0	0	0	2	2	86468	17369	69099	67975	858	65930	287	604	16	280	1124	1032	224	12	27	4	13	299	123	100	177	12	8	9	9	13	2	82	43	5	0	3	1	0	0	0	0	6	3	7	3	7	2	0	1	1	0	5	3	1	1	0	0	0	0	0	0	0	5	5	0	0
20	32	70942	68227	7498	51411	541	1282	33	7462	2715	2376	622	47	145	10	335	385	117	44	515	2	4	41	7	54	48	308	173	32	0	30	11	0	3	1	4	1	12	3	12	10	7	4	1	1	2	1	27	14	1	8	0	1	0	1	0	0	0	2	0	0	4	2	1	1	0	0	0	70942	16299	54643	53275	3823	47791	242	1217	19	183	1368	1163	398	34	132	4	14	305	98	34	114	2	3	0	5	20	0	184	119	22	0	15	3	0	1	1	0	7	2	2	7	4	1	0	0	0	0	18	13	0	3	0	0	0	0	0	2	0	3	1	1	1
51	79	90263	87018	20375	54877	600	2443	88	8635	3245	2956	645	79	216	21	552	406	166	57	579	18	8	87	10	58	54	268	137	20	1	25	5	0	4	2	12	6	17	1	15	4	7	6	1	3	2	0	21	7	1	5	1	5	0	0	1	1	0	0	0	0	0	0	0	0	0	0	0	90263	20014	70249	68615	14506	51142	210	2390	55	312	1634	1471	458	40	201	17	37	349	140	50	134	11	3	2	10	18	1	151	82	19	1	9	5	0	1	6	2	9	1	5	4	5	2	0	0	0	0	12	7	0	2	1	1	0	1	0	0	0	0	0	0	0
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	1	0	2	0	4	4	0	0	0	0	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	0	9	3	1	1	0	0	1	0	1	0	2	4	4	0	0
59	101	67065	64391	19193	35263	533	1278	66	8058	2674	2485	371	37	102	9	654	262	135	64	505	35	4	74	3	135	95	178	74	9	2	35	1	0	7	3	4	3	12	0	5	2	7	8	0	3	2	1	9	6	0	0	0	0	1	0	0	1	0	1	0	0	2	2	0	0	0	0	0	67065	16941	50124	48859	13666	33054	215	1235	49	640	1265	1162	235	21	88	6	29	228	124	62	205	31	1	4	3	105	20	99	42	7	2	6	1	2	3	1	2	12	0	3	2	5	8	0	2	0	1	2	2	0	0	0	0	0	0	0	0	0	2	2	0	0
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	0	0	0	0	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	0	4	3	0	0	1	0	0	0	0	0	0	1	0	1	0
6	10	50180	48333	35838	4171	170	5653	15	2486	1847	1670	407	113	545	9	288	75	32	6	77	16	4	20	12	54	12	161	86	14	1	15	0	0	1	5	15	3	5	0	5	1	7	0	0	0	3	0	12	6	0	5	0	0	0	0	0	0	1	0	0	0	4	2	1	0	1	0	0	50180	8821	41359	40202	30799	3518	71	5604	12	198	1157	1062	250	75	509	8	58	59	28	6	9	14	2	0	12	31	1	88	50	10	0	6	0	0	5	10	0	5	0	0	0	2	0	0	0	0	0	5	5	0	0	0	0	0	0	0	0	0	2	1	1	0
35	60	104278	101803	66276	14998	558	12372	32	7567	2475	2331	333	73	479	56	618	118	67	16	303	49	6	36	5	142	30	123	65	13	1	9	3	0	4	5	4	2	0	1	0	1	7	2	0	1	3	2	18	8	0	4	4	0	0	0	0	2	0	0	0	0	2	2	0	0	0	1	1	104278	17423	86855	85553	59405	13401	183	12294	16	254	1302	1230	178	36	461	53	111	105	66	11	40	47	1	1	5	113	2	61	34	6	1	2	2	1	3	4	0	0	0	0	1	3	0	0	0	2	2	10	8	0	0	0	0	0	2	0	0	0	1	1	0	0
70	112	112070	108553	71381	3240	223	29356	46	4307	3517	3271	385	95	1209	70	643	64	102	4	96	102	0	20	81	377	23	215	77	29	2	33	6	0	5	12	30	4	0	0	4	0	7	1	1	0	2	2	24	14	0	4	1	4	1	0	0	0	0	0	0	0	7	5	2	0	0	0	0	112070	15128	96942	94549	61927	2792	104	29200	29	497	2393	2260	218	36	1126	69	134	42	95	4	29	98	0	3	79	324	3	112	35	27	2	4	6	0	12	14	3	0	0	1	0	4	1	1	0	0	2	17	11	0	3	1	2	0	0	0	0	0	4	3	1	0