new_york_city

Custom SQL query returning 15 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 "P0020027" = :p0 order by P0010046 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	P0010067	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	P0020049	P0020050	P0020051	P0020052	P0020053	P0020054	P0020055	P0020056	P0020057	P0020060	P0020061	P0020063	P0020065	P0020066	P0020067	P0020069
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	11	6	1	2	0	1	0	0	1	0	0	0	1	1	0	0
3	6	62226	60490	53227	1316	80	5023	21	823	1736	1596	286	121	883	13	120	23	41	1	29	7	0	6	27	37	2	119	53	10	0	10	14	0	2	12	12	1	1	0	2	0	1	1	0	0	0	0	18	14	0	3	0	0	0	1	0	0	0	0	0	0	0	0	3	3	0	0	0	0	0	0	62226	3781	58445	56956	50468	1214	47	4983	20	224	1489	1384	244	92	863	8	45	20	35	1	9	7	0	0	27	32	1	90	41	8	0	5	12	0	1	12	8	1	1	0	0	0	1	0	0	0	0	13	11	0	1	0	0	0	1	0	0	0	0	2	2	0	0
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	16	14	0	1	0	0	0	1	0	0	0	0	2	0	2	0
5	9	76443	73259	48175	6904	361	10946	45	6828	3184	2877	534	155	912	31	590	123	63	6	199	25	5	73	31	88	42	275	139	28	2	24	11	0	5	17	13	8	6	6	6	0	5	1	0	0	4	0	28	16	4	4	1	1	0	0	2	0	0	0	0	0	0	0	3	2	1	0	0	0	1	1	76443	18291	58152	56307	39560	5466	127	10831	28	295	1845	1693	370	112	858	24	62	81	51	5	25	23	0	2	30	49	1	136	74	22	1	4	9	0	1	14	4	0	5	1	0	0	1	0	0	0	0	14	12	0	1	0	0	0	0	1	0	0	0	2	1	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	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	5	5	0	0	0	0	0	0	0	0	0	0	2	1	1	0
10	18	54066	52216	37624	3106	168	8462	27	2829	1850	1721	262	98	570	14	407	32	61	5	95	21	0	24	25	98	9	121	59	4	0	17	9	0	2	13	12	2	2	0	1	0	0	0	0	0	0	0	7	2	1	2	0	0	0	0	1	0	0	0	1	0	0	0	1	1	0	0	0	0	0	0	54066	8883	45183	44019	32682	2637	68	8389	25	218	1164	1088	179	60	537	13	65	25	60	5	30	20	0	1	24	68	1	73	40	2	0	2	6	0	1	12	8	0	2	0	0	0	0	0	0	0	0	3	1	0	2	0	0	0	0	0	0	0	0	0	0	0	0
18	28	44781	42566	9799	27033	321	1607	43	3763	2215	1934	526	64	221	12	223	251	118	28	347	19	0	46	2	41	36	250	141	24	5	11	5	0	3	3	13	3	5	2	23	3	1	7	1	0	0	0	27	16	1	4	0	0	1	0	2	0	0	1	0	0	1	1	4	3	1	0	0	0	0	0	44781	9393	35388	34184	7227	25067	114	1570	27	179	1204	1057	350	37	218	8	14	165	103	26	96	14	0	7	1	17	1	136	88	15	3	3	2	0	0	3	6	1	4	0	3	3	1	3	1	0	0	7	5	1	0	0	0	0	0	0	1	0	0	4	3	1	0
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	0	1	0	0	0	1	1	0	0	0	0	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	2	2	0	0	0	0	0	0	0	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	0	1	0	0	0	1	0	2	0	4	4	0	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	0	3	3	0	6	0	3	7	6	5	0	0	1	9	3	1	1	0	0	0	0	1	0	1	2	4	4	0	0
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	7	5	0	1	1	0	0	0	0	0	0	0	1	1	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	12	7	0	2	1	1	0	0	0	1	0	0	0	0	0	0
76	122	138982	136452	119790	3397	330	8474	43	4418	2530	2358	469	166	658	29	649	52	52	9	85	32	0	18	23	99	17	154	52	8	0	17	17	0	3	10	29	5	4	1	0	1	4	0	0	3	0	0	17	10	1	3	0	2	1	0	0	0	0	0	0	0	0	0	1	0	1	0	0	0	0	0	138982	15903	123079	121540	109879	2863	168	8370	32	228	1539	1434	361	135	583	25	89	42	39	9	19	29	0	5	22	75	1	96	32	5	0	7	16	0	0	10	15	0	4	1	0	1	4	0	0	1	0	8	4	0	1	0	2	1	0	0	0	0	0	1	0	1	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	17	16	0	0	0	1	0	0	0	0	0	0	1	0	1	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	7	3	0	2	1	1	0	0	0	0	0	0	3	3	0	0
21	33	76958	71025	22218	14215	1277	2315	62	30938	5933	5374	941	126	233	16	2034	152	68	16	996	37	19	361	12	150	213	521	149	41	2	154	4	5	19	0	23	12	5	0	21	0	6	13	2	52	11	2	30	5	0	18	0	0	1	1	0	2	0	0	2	0	0	1	8	4	3	0	1	0	0	0	76958	57168	19790	19009	7895	8619	113	2109	5	268	781	701	214	37	182	5	29	89	53	12	31	6	0	8	7	27	1	72	39	15	0	2	2	1	1	0	3	0	4	0	2	0	2	1	0	0	0	3	3	0	0	0	0	0	0	0	0	0	0	5	1	3	1