schools

Data source: Big Local News · About: Big Local

Custom SQL query returning 101 rows (hide)

select rowid, state, county, county_state_id, admin_level, district_nces_id, district_state_id, district_state_type, district, school_nces_id, school_state_id, school, school_state_type, ccd_school_type, ccd_charter_school, ccd_school_lvl, ccd_school_low_grade, ccd_school_high_grade, year, term, grade, white, black, hispanic, native_american, native_american_alaskan_native, asian, native_hawaiian, asian_pacific_islander, native_hawaiian_pacific_islander, pacific_islander, multiracial, unknown_race, male, female, non_binary, unknown_gender, ell, ell_percent, homeless, homeless_percent, low_income, free_and_reduced, free_and_reduced_percent, disability, section_504, total, white_int, black_int, hispanic_int, native_american_int, native_american_alaskan_native_int, asian_int, native_hawaiian_int, asian_pacific_islander_int, native_hawaiian_pacific_islander_int, pacific_islander_int, multiracial_int, unknown_race_int, male_int, female_int, non_binary_int, unknown_gender_int, ell_int, homeless_int, low_income_int, free_and_reduced_int, disability_int, section_504_int, total_int from enrollments where "state" = :p0 order by school limit 101

Query parameters

This data as json, CSV

rowid	state	admin_level	district_nces_id	district_state_id	district	school_nces_id	school_state_id	school	school_state_type	ccd_school_type	ccd_charter_school	ccd_school_lvl	ccd_school_low_grade	ccd_school_high_grade	year	grade	white	black	hispanic	native_american_alaskan_native	asian	native_hawaiian_pacific_islander	multiracial	male	female	ell	disability	total	white_int	black_int	hispanic_int	native_american_alaskan_native_int	asian_int	native_hawaiian_pacific_islander_int	multiracial_int	male_int	female_int	ell_int	disability_int	total_int
2433279	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2019	kindergarten												0												0
2434728	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2019	grade_1												0												0
2436177	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2019	grade_2												0												0
2437626	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2019	grade_3												0												0
2439075	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2019	grade_4												0												0
2440524	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2019	grade_5												223												223
2441973	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2019	grade_6												279												279
2443422	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2019	grade_7												0												0
2444871	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2019	grade_8												0												0
2446320	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2019	grade_9												0												0
2447769	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2019	grade_10												0												0
2449218	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2019	grade_11												0												0
2450667	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2019	grade_12												0												0
2452116	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2019	pk_12_total	413	8	40	0	22	0	19	270	232	11	67	502	413	8	40	0	22	0	19	270	232	11	67	502
2759153	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2020	kindergarten												0												0
2760614	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2020	grade_1												0												0
2762075	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2020	grade_2												0												0
2763536	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2020	grade_3												0												0
2764997	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2020	grade_4												0												0
2766458	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2020	grade_5												246												246
2767919	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2020	grade_6												226												226
2769380	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2020	grade_7												0												0
2770841	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2020	grade_8												0												0
2772302	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2020	grade_9												0												0
2773763	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2020	grade_10												0												0
2775224	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2020	grade_11												0												0
2776685	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2020	grade_12												0												0
2778146	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2020	pk_12_total	389	*	31	0	21	*	25	251	221	11	54	472	389		31	0	21		25	251	221	11	54	472
2738931	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2021	kindergarten												0												0
2740375	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2021	grade_1												0												0
2741819	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2021	grade_2												0												0
2743263	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2021	grade_3												0												0
2744707	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2021	grade_4												0												0
2746151	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2021	grade_5												227												227
2747595	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2021	grade_6												241												241
2749039	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2021	grade_7												0												0
2750483	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2021	grade_8												0												0
2751927	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2021	grade_9												0												0
2753371	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2021	grade_10												0												0
2754815	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2021	grade_11												0												0
2756259	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2021	grade_12												0												0
2757703	CT	school	901800	600011	Guilford School District	90180000328	600711	A. Baldwin Middle School	Public Schools	Regular School	No	Middle	05	06	2021	pk_12_total	385	*	30	0	21	*	26	244	224	10	66	468	385		30	0	21		26	244	224	10	66	468
2434281	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2019	kindergarten												0												0
2435730	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2019	grade_1												0												0
2437179	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2019	grade_2												0												0
2438628	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2019	grade_3												0												0
2440077	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2019	grade_4												0												0
2441526	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2019	grade_5												0												0
2442975	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2019	grade_6												0												0
2444424	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2019	grade_7												0												0
2445873	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2019	grade_8												0												0
2447322	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2019	grade_9												183												183
2448771	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2019	grade_10												195												195
2450220	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2019	grade_11												150												150
2451669	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2019	grade_12												149												149
2453118	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2019	pk_12_total	32	177	444	*	13	*	*	339	338	71	64	677	32	177	444		13			339	338	71	64	677
2760163	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2020	kindergarten												0												0
2761624	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2020	grade_1												0												0
2763085	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2020	grade_2												0												0
2764546	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2020	grade_3												0												0
2766007	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2020	grade_4												0												0
2767468	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2020	grade_5												0												0
2768929	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2020	grade_6												0												0
2770390	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2020	grade_7												0												0
2771851	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2020	grade_8												0												0
2773312	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2020	grade_9												215												215
2774773	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2020	grade_10												181												181
2776234	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2020	grade_11												177												177
2777695	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2020	grade_12												143												143
2779156	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2020	pk_12_total	39	177	471	*	14	*	12	369	347	83	92	716	39	177	471		14		12	369	347	83	92	716
2739933	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2021	kindergarten												0												0
2741377	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2021	grade_1												0												0
2742821	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2021	grade_2												0												0
2744265	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2021	grade_3												0												0
2745709	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2021	grade_4												0												0
2747153	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2021	grade_5												0												0
2748597	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2021	grade_6												0												0
2750041	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2021	grade_7												0												0
2751485	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2021	grade_8												0												0
2752929	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2021	grade_9												227												227
2754373	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2021	grade_10												205												205
2755817	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2021	grade_11												175												175
2757261	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2021	grade_12												174												174
2758705	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201136	9001516	A. I. Prince Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2021	pk_12_total	42	204	500	*	13	*	18	406	375	91	124	781	42	204	500		13		18	406	375	91	124	781
2433276	CT	school	901800	600011	Guilford School District	90180000329	600611	A. W. Cox School	Public Schools	Regular School	No	Elementary	KG	04	2019	kindergarten												52												52
2434725	CT	school	901800	600011	Guilford School District	90180000329	600611	A. W. Cox School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_1												40												40
2436174	CT	school	901800	600011	Guilford School District	90180000329	600611	A. W. Cox School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_2												58												58
2437623	CT	school	901800	600011	Guilford School District	90180000329	600611	A. W. Cox School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_3												47												47
2439072	CT	school	901800	600011	Guilford School District	90180000329	600611	A. W. Cox School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_4												69												69
2440521	CT	school	901800	600011	Guilford School District	90180000329	600611	A. W. Cox School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_5												0												0
2441970	CT	school	901800	600011	Guilford School District	90180000329	600611	A. W. Cox School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_6												0												0
2443419	CT	school	901800	600011	Guilford School District	90180000329	600611	A. W. Cox School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_7												0												0
2444868	CT	school	901800	600011	Guilford School District	90180000329	600611	A. W. Cox School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_8												0												0
2446317	CT	school	901800	600011	Guilford School District	90180000329	600611	A. W. Cox School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_9												0												0
2447766	CT	school	901800	600011	Guilford School District	90180000329	600611	A. W. Cox School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_10												0												0
2449215	CT	school	901800	600011	Guilford School District	90180000329	600611	A. W. Cox School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_11												0												0
2450664	CT	school	901800	600011	Guilford School District	90180000329	600611	A. W. Cox School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_12												0												0
2452113	CT	school	901800	600011	Guilford School District	90180000329	600611	A. W. Cox School	Public Schools	Regular School	No	Elementary	KG	04	2019	pk_12_total	225	*	18	0	*	0	12	138	128	11	18	266	225		18	0		0	12	138	128	11	18	266
2759150	CT	school	901800	600011	Guilford School District	90180000329	600611	A. W. Cox School	Public Schools	Regular School	No	Elementary	KG	04	2020	kindergarten												46												46
2760611	CT	school	901800	600011	Guilford School District	90180000329	600611	A. W. Cox School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_1												54												54
2762072	CT	school	901800	600011	Guilford School District	90180000329	600611	A. W. Cox School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_2												41												41