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 desc limit 101

Query parameters

This data as json, CSV

rowid	state	admin_level	district_state_id	district	school_nces_id	school_state_id	school	school_state_type	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
2433332	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2019	kindergarten												0												0
2434781	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2019	grade_1												0												0
2436230	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2019	grade_2												0												0
2437679	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2019	grade_3												0												0
2439128	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2019	grade_4												0												0
2440577	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2019	grade_5												0												0
2442026	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2019	grade_6												0												0
2443475	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2019	grade_7												0												0
2444924	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2019	grade_8												0												0
2446373	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2019	grade_9												0												0
2447822	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2019	grade_10												0												0
2449271	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2019	grade_11												0												0
2450720	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2019	grade_12												0												0
2452169	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2019	pk_12_total	0	*	*	0	0	0	0	*	*	0	*	*	0			0	0	0	0			0
2759206	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2020	kindergarten												0												0
2760667	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2020	grade_1												0												0
2762128	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2020	grade_2												0												0
2763589	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2020	grade_3												0												0
2765050	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2020	grade_4												0												0
2766511	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2020	grade_5												0												0
2767972	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2020	grade_6												0												0
2769433	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2020	grade_7												0												0
2770894	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2020	grade_8												0												0
2772355	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2020	grade_9												0												0
2773816	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2020	grade_10												0												0
2775277	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2020	grade_11												0												0
2776738	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2020	grade_12												0												0
2778199	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2020	pk_12_total	*	*	*	0	0	0	0	*	*	0	8	8				0	0	0	0			0	8	8
2738986	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2021	kindergarten												0												0
2740430	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2021	grade_1												0												0
2741874	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2021	grade_2												0												0
2743318	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2021	grade_3												0												0
2744762	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2021	grade_4												0												0
2746206	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2021	grade_5												0												0
2747650	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2021	grade_6												0												0
2749094	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2021	grade_7												0												0
2750538	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2021	grade_8												0												0
2751982	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2021	grade_9												0												0
2753426	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2021	grade_10												0												0
2754870	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2021	grade_11												0												0
2756314	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2021	grade_12												0												0
2757758	CT	school	640011	Hartford School District		640810	iGOAL Pre-K - Rawson School	Program	2021	pk_12_total	*	0	*	0	*	0	0	7	0	0	7	7		0		0		0	0	7	0	0	7	7
2433331	CT	school	640011	Hartford School District		640710	iGOAL Pre-K - Naylor School	Program	2019	kindergarten												0												0
2434780	CT	school	640011	Hartford School District		640710	iGOAL Pre-K - Naylor School	Program	2019	grade_1												0												0
2436229	CT	school	640011	Hartford School District		640710	iGOAL Pre-K - Naylor School	Program	2019	grade_2												0												0
2437678	CT	school	640011	Hartford School District		640710	iGOAL Pre-K - Naylor School	Program	2019	grade_3												0												0
2439127	CT	school	640011	Hartford School District		640710	iGOAL Pre-K - Naylor School	Program	2019	grade_4												0												0
2440576	CT	school	640011	Hartford School District		640710	iGOAL Pre-K - Naylor School	Program	2019	grade_5												0												0
2442025	CT	school	640011	Hartford School District		640710	iGOAL Pre-K - Naylor School	Program	2019	grade_6												0												0
2443474	CT	school	640011	Hartford School District		640710	iGOAL Pre-K - Naylor School	Program	2019	grade_7												0												0
2444923	CT	school	640011	Hartford School District		640710	iGOAL Pre-K - Naylor School	Program	2019	grade_8												0												0
2446372	CT	school	640011	Hartford School District		640710	iGOAL Pre-K - Naylor School	Program	2019	grade_9												0												0
2447821	CT	school	640011	Hartford School District		640710	iGOAL Pre-K - Naylor School	Program	2019	grade_10												0												0
2449270	CT	school	640011	Hartford School District		640710	iGOAL Pre-K - Naylor School	Program	2019	grade_11												0												0
2450719	CT	school	640011	Hartford School District		640710	iGOAL Pre-K - Naylor School	Program	2019	grade_12												0												0
2452168	CT	school	640011	Hartford School District		640710	iGOAL Pre-K - Naylor School	Program	2019	pk_12_total	0	*	*	0	0	0	0	*	*	0	10	10	0			0	0	0	0			0	10	10
2759205	CT	school	640011	Hartford School District		640710	iGOAL Pre-K - Naylor School	Program	2020	kindergarten												0												0
2760666	CT	school	640011	Hartford School District		640710	iGOAL Pre-K - Naylor School	Program	2020	grade_1												0												0
2762127	CT	school	640011	Hartford School District		640710	iGOAL Pre-K - Naylor School	Program	2020	grade_2												0												0
2763588	CT	school	640011	Hartford School District		640710	iGOAL Pre-K - Naylor School	Program	2020	grade_3												0												0
2765049	CT	school	640011	Hartford School District		640710	iGOAL Pre-K - Naylor School	Program	2020	grade_4												0												0
2766510	CT	school	640011	Hartford School District		640710	iGOAL Pre-K - Naylor School	Program	2020	grade_5												0												0
2767971	CT	school	640011	Hartford School District		640710	iGOAL Pre-K - Naylor School	Program	2020	grade_6												0												0
2769432	CT	school	640011	Hartford School District		640710	iGOAL Pre-K - Naylor School	Program	2020	grade_7												0												0
2770893	CT	school	640011	Hartford School District		640710	iGOAL Pre-K - Naylor School	Program	2020	grade_8												0												0
2772354	CT	school	640011	Hartford School District		640710	iGOAL Pre-K - Naylor School	Program	2020	grade_9												0												0
2773815	CT	school	640011	Hartford School District		640710	iGOAL Pre-K - Naylor School	Program	2020	grade_10												0												0
2775276	CT	school	640011	Hartford School District		640710	iGOAL Pre-K - Naylor School	Program	2020	grade_11												0												0
2776737	CT	school	640011	Hartford School District		640710	iGOAL Pre-K - Naylor School	Program	2020	grade_12												0												0
2778198	CT	school	640011	Hartford School District		640710	iGOAL Pre-K - Naylor School	Program	2020	pk_12_total	*	*	6	0	0	0	*	9	0	0	9	9			6	0	0	0		9	0	0	9	9
2433367	CT	school	640011	Hartford School District		645011	iGOAL 2 - Weaver High School		2019	kindergarten												0												0
2434816	CT	school	640011	Hartford School District		645011	iGOAL 2 - Weaver High School		2019	grade_1												0												0
2436265	CT	school	640011	Hartford School District		645011	iGOAL 2 - Weaver High School		2019	grade_2												0												0
2437714	CT	school	640011	Hartford School District		645011	iGOAL 2 - Weaver High School		2019	grade_3												0												0
2439163	CT	school	640011	Hartford School District		645011	iGOAL 2 - Weaver High School		2019	grade_4												0												0
2440612	CT	school	640011	Hartford School District		645011	iGOAL 2 - Weaver High School		2019	grade_5												0												0
2442061	CT	school	640011	Hartford School District		645011	iGOAL 2 - Weaver High School		2019	grade_6												0												0
2443510	CT	school	640011	Hartford School District		645011	iGOAL 2 - Weaver High School		2019	grade_7												0												0
2444959	CT	school	640011	Hartford School District		645011	iGOAL 2 - Weaver High School		2019	grade_8												0												0
2446408	CT	school	640011	Hartford School District		645011	iGOAL 2 - Weaver High School		2019	grade_9												*
2447857	CT	school	640011	Hartford School District		645011	iGOAL 2 - Weaver High School		2019	grade_10												*
2449306	CT	school	640011	Hartford School District		645011	iGOAL 2 - Weaver High School		2019	grade_11												*
2450755	CT	school	640011	Hartford School District		645011	iGOAL 2 - Weaver High School		2019	grade_12												6												6
2452204	CT	school	640011	Hartford School District		645011	iGOAL 2 - Weaver High School		2019	pk_12_total	0	6	9	0	0	0	0	8	7	*	15	15	0	6	9	0	0	0	0	8	7		15	15
2759240	CT	school	640011	Hartford School District		645011	iGOAL 2 - Weaver High School		2020	kindergarten												0												0
2760701	CT	school	640011	Hartford School District		645011	iGOAL 2 - Weaver High School		2020	grade_1												0												0
2762162	CT	school	640011	Hartford School District		645011	iGOAL 2 - Weaver High School		2020	grade_2												0												0
2763623	CT	school	640011	Hartford School District		645011	iGOAL 2 - Weaver High School		2020	grade_3												0												0
2765084	CT	school	640011	Hartford School District		645011	iGOAL 2 - Weaver High School		2020	grade_4												0												0
2766545	CT	school	640011	Hartford School District		645011	iGOAL 2 - Weaver High School		2020	grade_5												0												0
2768006	CT	school	640011	Hartford School District		645011	iGOAL 2 - Weaver High School		2020	grade_6												0												0
2769467	CT	school	640011	Hartford School District		645011	iGOAL 2 - Weaver High School		2020	grade_7												0												0
2770928	CT	school	640011	Hartford School District		645011	iGOAL 2 - Weaver High School		2020	grade_8												0												0
2772389	CT	school	640011	Hartford School District		645011	iGOAL 2 - Weaver High School		2020	grade_9												*
2773850	CT	school	640011	Hartford School District		645011	iGOAL 2 - Weaver High School		2020	grade_10												*
2775311	CT	school	640011	Hartford School District		645011	iGOAL 2 - Weaver High School		2020	grade_11												*
2776772	CT	school	640011	Hartford School District		645011	iGOAL 2 - Weaver High School		2020	grade_12												9												9
2778233	CT	school	640011	Hartford School District		645011	iGOAL 2 - Weaver High School		2020	pk_12_total	0	6	10	0	0	0	0	*	*	*	16	16	0	6	10	0	0	0	0				16	16
2433330	CT	school	640011	Hartford School District	90192001764	648511	iGOAL 2 - Moylan School	Program	2019	kindergarten												*
2434779	CT	school	640011	Hartford School District	90192001764	648511	iGOAL 2 - Moylan School	Program	2019	grade_1												0												0
2436228	CT	school	640011	Hartford School District	90192001764	648511	iGOAL 2 - Moylan School	Program	2019	grade_2												0												0