new_york_city

Custom SQL query returning 25 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 "P0010029" = :p0 order by P0010021 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	P0010054	P0010055	P0010056	P0010057	P0010058	P0010059	P0010060	P0010061	P0010062	P0010063	P0010064	P0010065	P0010066	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	P0020056	P0020057	P0020059	P0020060	P0020061	P0020063	P0020064	P0020065	P0020066	P0020067	P0020071	P0020072	P0020073
8	14	20651	20019	12868	1481	56	4964	13	637	632	586	91	31	196	13	92	29	16	0	34	18	0	10	19	31	6	42	26	1	1	4	4	0	0	2	2	0	1	0	1	0	0	0	0	0	0	0	4	0	0	3	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	20651	2198	18453	18005	11605	1353	34	4933	11	69	448	414	45	25	188	11	34	25	14	0	7	18	0	1	16	27	3	33	19	1	1	3	4	0	0	2	2	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	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	0	1	6	17	1	0	2	5	2	21	12	1	1	6	0	0	0	0	0	0	1	0	0	0	0	1	1	0	0	0	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	0	0	1	11	0	4	0	1	4	15	0	0	1	0	0	6	2	0	0	3	0	0	0	0	1	0	0	0	0	0	0	0	1	1
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	0	1	0	1	2	5	2	0	0	0	5	5	0	0	0	0	0	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	0	8	6	1	1	1	0	1	1	0	0	0	0	0	6	3	0	0	1	0	1	0	0	0	1	0	0	0	0	0	0	0	0
67	109	247354	240457	95236	6596	555	122496	106	15468	6897	6559	513	143	2131	35	1780	77	189	16	246	305	0	110	152	781	81	279	82	36	1	44	7	0	23	12	30	8	4	3	3	1	9	7	2	6	0	1	53	25	0	8	0	11	0	0	0	0	4	0	0	0	5	0	4	4	0	0	0	0	2	2	247354	41164	206190	202136	73668	5512	215	122012	82	647	4054	3900	273	61	2030	31	120	58	181	10	64	298	0	2	147	619	6	120	38	25	0	1	6	0	0	11	18	0	4	2	0	1	6	4	2	1	0	1	30	20	0	1	0	3	0	0	1	0	0	5	0	4	4	0	0	0	0
1	1	66679	64416	50484	2162	89	10569	26	1086	2263	2098	348	115	1151	28	174	48	53	0	39	8	1	5	26	99	3	151	64	28	1	8	3	1	3	20	16	1	2	0	1	1	2	0	0	0	0	0	13	7	1	3	0	1	0	0	1	0	0	0	0	0	0	0	1	1	0	0	0	0	0	0	66679	4676	62003	60094	47231	1982	57	10520	23	281	1909	1784	280	85	1110	26	61	44	52	0	20	7	1	1	25	71	1	113	52	22	1	3	2	1	1	15	12	1	2	0	0	0	1	0	0	0	0	0	11	6	1	2	0	1	0	1	0	0	0	0	0	1	1	0	0	0	0
12	20	102624	100080	84116	4511	183	9024	34	2212	2544	2359	337	135	1206	22	302	63	54	3	89	10	1	21	29	75	12	173	77	23	1	11	14	0	2	20	16	0	2	0	2	0	2	1	0	1	0	1	11	6	0	5	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	1	0	0	0	102624	8609	94015	92070	78880	3855	87	8958	25	265	1945	1822	258	107	1148	22	65	55	49	2	12	9	1	4	29	61	0	117	50	17	1	2	11	0	1	18	10	0	2	0	1	0	2	1	0	0	0	1	6	3	0	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
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	0	5	2	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	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	0	0	13	5	0	5	2	0	0	0	0	0	0	1	0	0	0	0	0	1	1
50	78	66664	63672	49139	6940	221	3957	31	3384	2992	2744	607	165	1144	24	314	76	126	12	104	13	1	50	19	82	7	231	109	37	1	21	9	0	7	13	18	0	4	0	5	0	5	0	0	0	2	0	15	7	0	5	1	1	0	0	1	0	0	0	0	0	0	0	1	1	0	0	0	0	1	1	66664	10248	56416	54326	43996	6036	92	3891	18	293	2090	1955	457	95	1072	21	26	62	117	12	20	9	1	3	18	41	1	127	50	26	1	6	5	0	3	12	15	0	4	0	0	0	5	0	0	0	0	0	7	5	0	1	1	0	0	0	0	0	0	0	0	1	1	0	0	0	0
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	0	1	0	0	0	1	1	0	0	0	3	3	0	0	0	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	0	0	0	0	0	0	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	0	1	0	1	0	0	0	1	0	1	1	0	0	0	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	0	0	0	1	0	1	1	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	0	0	3	3	0	0	0	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	0	0	0	0	3	3	0	0	0	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	0	0	1	0	0	0	4	2	1	0	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	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	0	0	2	1	1	0	0	0
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	0	15	0	4	0	0	0	0	0	0	1	0	0	0	3	3	0	0	0	0	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	0	0	1	13	11	0	0	0	2	0	0	0	0	0	0	0	1	1	0	0	0	0
19	30	60685	56601	14707	21103	816	1465	42	18468	4084	3730	701	113	178	5	1264	169	88	37	726	18	5	229	10	107	80	322	135	22	1	83	5	4	11	2	12	4	4	4	10	1	5	1	0	10	6	2	29	6	0	14	1	2	0	0	1	2	0	0	0	0	3	0	3	3	0	0	0	0	0	0	60685	34825	25860	24895	6178	16951	161	1369	19	217	965	849	265	55	164	2	37	120	77	24	64	11	0	5	8	16	1	106	65	14	1	2	4	0	0	2	3	1	4	4	1	1	3	0	0	0	1	0	7	3	0	2	1	1	0	0	0	0	0	0	0	3	3	0	0	0	0
63	105	188582	180965	33672	107918	941	27881	157	10396	7617	7046	849	130	471	9	752	480	1041	184	1063	330	5	114	71	1436	111	513	169	81	1	57	7	0	1	2	24	2	14	2	5	5	89	9	2	8	22	13	54	23	1	6	4	8	2	1	5	0	1	1	0	0	1	1	3	3	0	0	0	0	1	1	188582	22337	166245	160557	24611	104029	670	27688	125	3434	5688	5306	587	64	419	8	87	418	999	178	658	319	3	47	71	1360	88	352	112	65	1	20	1	0	0	2	20	0	9	2	0	5	83	9	2	7	3	11	27	16	1	0	2	5	1	0	0	1	0	1	0	3	3	0	0	0	0
77	123	98032	96794	89264	1399	122	4551	33	1425	1238	1170	268	87	332	25	328	11	7	1	18	8	5	4	4	68	4	67	29	12	1	5	1	0	2	1	12	0	0	0	0	0	2	2	0	0	0	0	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	98032	7982	90050	89245	83295	1216	64	4521	25	124	805	768	218	70	319	23	57	8	6	0	4	8	5	1	3	46	0	37	15	7	1	3	1	0	2	1	3	0	0	0	0	0	2	2	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	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	0	0	2	0	0	0	0	2	2	0	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	0	1	3	4	0	0	0	0	1	3	0	0	0	2	2	10	8	0	0	0	0	0	0	0	2	0	0	0	1	1	0	0	0	0
14	23	73106	69507	24574	22948	733	5553	77	15622	3599	3271	592	63	268	15	996	205	67	22	610	55	8	153	38	130	49	293	142	17	1	45	2	0	4	7	14	10	2	0	8	0	12	9	0	6	5	9	29	11	0	17	0	1	0	0	0	0	0	0	0	0	0	0	6	5	0	1	0	0	0	0	73106	36656	36450	35344	10864	18582	131	5428	58	281	1106	986	271	15	237	7	39	145	59	19	58	45	0	2	35	52	2	105	55	12	0	8	2	0	0	7	5	0	2	0	3	0	4	2	0	0	0	5	11	10	0	0	0	1	0	0	0	0	0	0	0	4	4	0	0	0	0
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	0	1	0	1	0	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	0	1	6	2	9	1	5	4	5	2	0	0	0	0	12	7	0	2	1	1	0	0	0	1	0	0	0	0	0	0	0	0	0
30	47	152374	147258	21739	105538	1241	2982	89	15669	5116	4639	898	73	128	15	768	446	400	175	1001	70	9	116	25	342	173	441	172	36	1	64	4	0	3	1	18	7	18	4	29	8	36	21	0	6	10	3	32	13	0	6	4	1	0	0	0	0	0	0	3	4	1	0	2	2	0	0	0	0	2	2	152374	34919	117455	114957	10871	99102	587	2872	50	1475	2498	2266	456	28	111	4	44	333	373	164	338	55	3	17	19	266	55	216	90	21	1	24	0	0	0	0	5	1	7	2	10	6	30	14	0	1	1	3	14	7	0	1	4	0	0	0	0	0	1	1	0	0	0	0	0	2	2
4	7	56355	54055	21520	5992	326	19328	28	6861	2300	2108	365	98	403	12	588	73	90	3	195	45	10	75	22	86	43	164	69	19	1	19	9	0	1	6	15	6	3	1	1	0	3	0	0	7	4	0	25	16	0	6	0	0	0	1	0	0	0	0	2	0	0	0	3	0	3	0	0	0	0	0	56355	17976	38379	37470	13479	4578	95	19192	10	116	909	819	166	46	355	6	16	56	76	2	16	35	1	1	21	21	1	72	35	14	1	1	8	0	0	4	4	0	3	0	1	0	1	0	0	0	0	0	16	14	0	1	0	0	1	0	0	0	0	0	0	2	0	2	0	0	0
45	72	126230	120736	52711	5849	1573	33565	62	26976	5494	5080	710	508	770	34	1869	63	151	12	347	67	11	214	44	201	79	372	125	23	1	64	18	0	39	6	30	26	3	0	3	0	14	2	1	8	8	1	37	16	7	4	0	2	1	0	0	2	2	0	0	0	0	3	5	3	1	1	0	0	0	0	126230	57375	68855	67085	29464	3688	178	33288	33	434	1770	1643	316	88	723	24	51	42	143	12	52	53	1	3	40	94	1	109	49	12	0	3	7	0	0	5	15	1	1	0	0	0	11	2	1	2	0	0	17	16	0	0	0	1	0	0	0	0	0	0	0	1	0	1	0	0	0
71	113	120132	116234	3036	104953	696	2615	55	4879	3898	3477	570	39	23	2	188	637	513	214	823	40	13	67	22	243	83	387	166	64	1	24	1	0	3	0	4	5	18	0	19	7	45	12	0	5	3	10	25	13	0	8	0	0	0	0	0	0	0	0	0	0	2	2	9	8	1	0	0	0	0	0	120132	9783	110349	107371	1057	101721	511	2577	42	1463	2978	2660	434	27	21	2	9	578	498	207	493	34	13	35	21	227	61	294	127	57	1	8	1	0	0	0	2	0	17	0	12	6	38	11	0	2	3	9	15	6	0	5	0	0	0	0	0	0	0	2	2	9	8	1	0	0	0
73	115	171576	162076	66142	13700	1914	27250	85	52985	9500	9029	818	243	671	35	4821	113	166	77	515	260	17	438	66	660	129	421	113	33	1	74	16	0	36	7	48	29	9	1	4	0	15	11	1	7	13	3	44	25	5	3	0	8	0	0	0	0	1	1	1	0	0	0	6	2	4	0	0	0	0	0	171576	110108	61468	59259	20334	10683	243	26996	30	973	2209	2068	194	25	562	23	133	96	149	60	75	229	0	6	65	442	9	113	33	27	1	7	5	0	0	3	7	1	6	1	2	0	12	1	1	3	0	3	23	19	0	0	0	2	0	0	0	1	1	0	0	5	1	4	0	0	0
26	43	172122	162252	40191	65492	2207	10187	174	44001	9870	8997	1368	167	304	37	2715	602	345	90	1636	210	19	486	30	600	388	814	342	66	1	116	7	2	28	0	33	22	31	6	55	11	30	7	0	28	21	8	52	11	5	18	0	5	6	0	0	0	0	4	1	1	0	1	7	2	3	1	0	1	0	0	172122	99213	72909	70277	4739	53042	562	9866	71	1997	2632	2368	411	30	198	14	49	330	289	75	281	179	2	56	30	361	63	242	89	38	0	14	3	1	1	0	5	0	16	4	19	8	12	2	0	13	12	5	19	6	1	5	0	2	0	0	0	4	1	0	0	3	0	2	1	0	0