enrollments
Data source: Big Local News · About: Big Local
7 rows where grade = "grade_unknown" and state = "WI" sorted by free_and_reduced_int
This data as json, CSV (advanced)
Link | 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
329770 | 329770 | WI | Sawyer | school | 5506270 | 2478 | Public school | Hayward Community | 550627002794 | 130 | Hayward 4 Learning | Regular School | No | Elementary | PK | PK | 2017 | grade_unknown | 54 | 54 | ||||||||||||||||||||||||||||||||||||||||||||||||||
333724 | 333724 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001220 | 277 | Morgandale Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_unknown | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||
335512 | 335512 | WI | Winnebago | school | 5511190 | 4179 | Public school | Oshkosh Area | 551119001501 | 440 | South Park Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_unknown | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||
335693 | 335693 | WI | Milwaukee | school | 5500078 | 8138 | Non District Charter Schools | Penfield Montessori Academy | 550007803048 | 8138 | Penfield Montessori Academy | charter | Regular School | Yes | Elementary | PK | 08 | 2017 | grade_unknown | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
336726 | 336726 | WI | Fond du Lac | school | 5513020 | 4872 | Public school | Ripon Area | 551302001893 | 110 | Barlow Park Elementary | Regular School | No | Elementary | PK | 02 | 2017 | grade_unknown | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3090315 | 3090315 | WI | Ozaukee | school | 5502460 | 1015 | Public school | Cedarburg | 550246002772 | 110 | Early Learning Center | Special Education School | No | Prekindergarten | PK | PK | 2018 | grade_unknown | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3093150 | 3093150 | WI | Saint Croix | school | 5506690 | 2611 | Public school | Hudson | 550669002735 | 150 | River Crest Elementary | Regular School | No | Elementary | PK | 05 | 2018 | grade_unknown | 7 | 7 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "enrollments" ( [state] TEXT, [county] TEXT, [county_state_id] INTEGER, [admin_level] TEXT, [district_nces_id] INTEGER, [district_state_id] TEXT, [district_state_type] TEXT, [district] TEXT, [school_nces_id] INTEGER, [school_state_id] INTEGER, [school] TEXT, [school_state_type] TEXT, [ccd_school_type] TEXT, [ccd_charter_school] TEXT, [ccd_school_lvl] TEXT, [ccd_school_low_grade] TEXT, [ccd_school_high_grade] TEXT, [year] INTEGER, [term] TEXT, [grade] TEXT, [white] TEXT, [black] TEXT, [hispanic] TEXT, [native_american] TEXT, [native_american_alaskan_native] TEXT, [asian] TEXT, [native_hawaiian] TEXT, [asian_pacific_islander] TEXT, [native_hawaiian_pacific_islander] TEXT, [pacific_islander] TEXT, [multiracial] TEXT, [unknown_race] TEXT, [male] TEXT, [female] TEXT, [non_binary] TEXT, [unknown_gender] TEXT, [ell] TEXT, [ell_percent] TEXT, [homeless] TEXT, [homeless_percent] TEXT, [low_income] TEXT, [free_and_reduced] TEXT, [free_and_reduced_percent] TEXT, [disability] TEXT, [section_504] TEXT, [total] TEXT , [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER); CREATE INDEX [idx_enrollments_state_grade] ON [enrollments] ([state], [grade]); CREATE INDEX [idx_enrollments_grade] ON [enrollments] ([grade]); CREATE INDEX [idx_enrollments_year] ON [enrollments] ([year]); CREATE INDEX [idx_enrollments_state_year] ON [enrollments] ([state], [year]); CREATE INDEX [idx_enrollments_school_nces_id] ON [enrollments] ([school_nces_id]); CREATE INDEX [idx_enrollments_district_nces_id] ON [enrollments] ([district_nces_id]);