schools
Data source: Big Local News · About: Big Local
districts
state, county, county_state_id, admin_level, district_nces_id, district_state_id, district, district_state_type, ccd_district_type, ccd_charter, ccd_district_lvl, ccd_district_low_grade, ccd_district_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
764,339 rows
enrollments
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
3,371,677 rows
Queries
- grades_by_year_for_state
- race_ethnicity_by_year_for_state_and_grade
- gender_by_year_for_state_and_grade
- learning_categories_by_year_for_state_and_grade
- income_proxies_by_year_for_state_and_grade
- district_race_ethnicity_by_year_for_state_and_grade
- district_gender_by_year_for_state_and_grade
- district_learning_categories_by_year_for_state_and_grade
- district_income_proxies_by_year_for_state_and_grade
Download SQLite DB: schools.db 1.2 GB