enrollments
Data source: Big Local News · About: Big Local
4,267 rows where grade = "sped_beyond_grade_12" and state = "MA" sorted by school_state_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1122189 | 1122189 | MA | Middlesex | school | 2502100 | 14 | Ashland | 250210000072 | 140010 | Henry E Warren Elementary | Regular School | No | Elementary | KG | 02 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2228995 | 2228995 | MA | Middlesex | school | 2502100 | 14 | Ashland | 250210000072 | 140010 | Ashland: Henry E Warren Elementary | Regular School | No | Elementary | KG | 02 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
1122193 | 1122193 | MA | Middlesex | school | 2502100 | 14 | Ashland | 250210000071 | 140015 | David Mindess | Regular School | No | Elementary | 03 | 05 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2228999 | 2228999 | MA | Middlesex | school | 2502100 | 14 | Ashland | 250210000071 | 140015 | Ashland: David Mindess | Regular School | No | Elementary | 03 | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
1122197 | 1122197 | MA | Middlesex | school | 2502100 | 14 | Ashland | 250210000938 | 140405 | Ashland Middle | Regular School | No | Middle | 06 | 08 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2229003 | 2229003 | MA | Middlesex | school | 2502100 | 14 | Ashland | 250210000938 | 140405 | Ashland: Ashland Middle | Regular School | No | Middle | 06 | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
1122202 | 1122202 | MA | Middlesex | school | 2502100 | 14 | Ashland | 250210000070 | 140505 | Ashland High | Regular School | No | High | 09 | 12 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2229008 | 2229008 | MA | Middlesex | school | 2502100 | 14 | Ashland | 250210000070 | 140505 | Ashland: Ashland High | Regular School | No | High | 09 | 12 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
1122208 | 1122208 | MA | Bristol | school | 2502190 | 16 | Attleboro | 250219000097 | 160001 | A. Irvin Studley Elementary School | Regular School | No | Elementary | KG | 04 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2229014 | 2229014 | MA | Bristol | school | 2502190 | 16 | Attleboro | 250219000097 | 160001 | Attleboro: A. Irvin Studley Elementary School | Regular School | No | Elementary | KG | 04 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
1122210 | 1122210 | MA | Bristol | school | 2502190 | 16 | Attleboro | 250219001610 | 160008 | Early Learning Center | Regular School | No | Elementary | PK | PK | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2229016 | 2229016 | MA | Bristol | school | 2502190 | 16 | Attleboro | 250219001610 | 160008 | Attleboro: Early Learning Center | Regular School | No | Prekindergarten | PK | PK | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
1122216 | 1122216 | MA | Bristol | school | 2502190 | 16 | Attleboro | 250219000098 | 160035 | Thomas Willett Elementary School | Regular School | No | Elementary | KG | 04 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2229022 | 2229022 | MA | Bristol | school | 2502190 | 16 | Attleboro | 250219000098 | 160035 | Attleboro: Thomas Willett Elementary School | Regular School | No | Elementary | KG | 04 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
1122222 | 1122222 | MA | Bristol | school | 2502190 | 16 | Attleboro | 250219000090 | 160040 | Hyman Fine Elementary School | Regular School | No | Elementary | KG | 04 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2229028 | 2229028 | MA | Bristol | school | 2502190 | 16 | Attleboro | 250219000090 | 160040 | Attleboro: Hyman Fine Elementary School | Regular School | No | Elementary | KG | 04 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
1122228 | 1122228 | MA | Bristol | school | 2502190 | 16 | Attleboro | 250219000089 | 160045 | Hill-Roberts Elementary School | Regular School | No | Elementary | KG | 04 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2229034 | 2229034 | MA | Bristol | school | 2502190 | 16 | Attleboro | 250219000089 | 160045 | Attleboro: Hill-Roberts Elementary School | Regular School | No | Elementary | KG | 04 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
1122234 | 1122234 | MA | Bristol | school | 2502190 | 16 | Attleboro | 250219001294 | 160050 | Peter Thacher Elementary School | Regular School | No | Elementary | KG | 04 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2229040 | 2229040 | MA | Bristol | school | 2502190 | 16 | Attleboro | 250219001294 | 160050 | Attleboro: Peter Thacher Elementary School | Regular School | No | Elementary | KG | 04 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
1122239 | 1122239 | MA | Bristol | school | 2502190 | 16 | Attleboro | 250219000096 | 160305 | Robert J. Coelho Middle School | Regular School | No | Middle | 05 | 08 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2229045 | 2229045 | MA | Bristol | school | 2502190 | 16 | Attleboro | 250219000096 | 160305 | Attleboro: Robert J. Coelho Middle School | Regular School | No | Middle | 05 | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
1122244 | 1122244 | MA | Bristol | school | 2502190 | 16 | Attleboro | 250219000087 | 160315 | Cyril K. Brennan Middle School | Regular School | No | Middle | 05 | 08 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2229050 | 2229050 | MA | Bristol | school | 2502190 | 16 | Attleboro | 250219000087 | 160315 | Attleboro: Cyril K. Brennan Middle School | Regular School | No | Middle | 05 | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
1122249 | 1122249 | MA | Bristol | school | 2502190 | 16 | Attleboro | 250219000945 | 160320 | Wamsutta Middle School | Regular School | No | Middle | 05 | 08 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2229055 | 2229055 | MA | Bristol | school | 2502190 | 16 | Attleboro | 250219000945 | 160320 | Attleboro: Wamsutta Middle School | Regular School | No | Middle | 05 | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
932788 | 932788 | MA | Bristol | school | 2502190 | 16 | Attleboro | 250219000084 | 160505 | Attleboro High | Regular School | No | 3 | 09 | 12 | 2016 | sped_beyond_grade_12 | 12 | 0 | 4 | 0 | 0 | 0 | 0 | 11 | 5 | 16 | 12 | 0 | 4 | 0 | 0 | 0 | 0 | 11 | 5 | 16 | |||||||||||||||||||||||||||||||||
1122254 | 1122254 | MA | Bristol | school | 2502190 | 16 | Attleboro | 250219000084 | 160505 | Attleboro High | Regular School | No | High | 09 | 12 | 2017 | sped_beyond_grade_12 | 9 | 0 | 1 | 0 | 0 | 0 | 0 | 10 | 9 | 0 | 1 | 0 | 0 | 0 | 0 | 10 | |||||||||||||||||||||||||||||||||||||
1365036 | 1365036 | MA | Bristol | school | 2502190 | 16 | Attleboro | 250219000084 | 160505 | Attleboro High | Regular School | No | High | 09 | 12 | 2020 | sped_beyond_grade_12 | 12 | 2 | 2 | 0 | 0 | 0 | 0 | 9 | 7 | * | 16.0 | 12 | 2 | 2 | 0 | 0 | 0 | 0 | 9 | 7 | 16 | ||||||||||||||||||||||||||||||||
1672259 | 1672259 | MA | Bristol | school | 2502190 | 16 | Attleboro | 250219000084 | 160505 | Attleboro - Attleboro High | Regular School | No | High | 09 | 12 | 2021 | sped_beyond_grade_12 | 12 | 2 | 1 | 0 | 0 | 0 | 0 | 9 | 6 | * | 15.0 | 12 | 2 | 1 | 0 | 0 | 0 | 0 | 9 | 6 | 15 | ||||||||||||||||||||||||||||||||
2040063 | 2040063 | MA | Bristol | school | 2502190 | 16 | Attleboro | 250219000084 | 160505 | Attleboro High | Regular School | No | High | 09 | 12 | 2019 | sped_beyond_grade_12 | 10 | 1 | 1 | 0 | 1 | 0 | 1 | 14.0 | 10 | 1 | 1 | 0 | 1 | 0 | 1 | 14 | |||||||||||||||||||||||||||||||||||||
2229060 | 2229060 | MA | Bristol | school | 2502190 | 16 | Attleboro | 250219000084 | 160505 | Attleboro: Attleboro High | Regular School | No | High | 09 | 12 | 2018 | sped_beyond_grade_12 | 10 | 0 | 1 | 0 | 0 | 0 | 0 | 11.0 | 10 | 0 | 1 | 0 | 0 | 0 | 0 | 11 | |||||||||||||||||||||||||||||||||||||
1122258 | 1122258 | MA | Bristol | school | 2502190 | 16 | Attleboro | 250219002831 | 160515 | Attleboro Community Academy | Alternative School | No | High | 09 | 12 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2229063 | 2229063 | MA | Bristol | school | 2502190 | 16 | Attleboro | 250219002831 | 160515 | Attleboro: Attleboro Community Academy | Alternative School | No | High | 09 | 12 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
1122262 | 1122262 | MA | Worcester | school | 2502220 | 17 | Auburn | 250222000101 | 170010 | Bryn Mawr | Regular School | No | Elementary | KG | 02 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2229067 | 2229067 | MA | Worcester | school | 2502220 | 17 | Auburn | 250222000101 | 170010 | Auburn: Bryn Mawr | Regular School | No | Elementary | KG | 02 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
1122266 | 1122266 | MA | Worcester | school | 2502220 | 17 | Auburn | 250222000103 | 170025 | Pakachoag School | Regular School | No | Elementary | KG | 02 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2229072 | 2229072 | MA | Worcester | school | 2502220 | 17 | Auburn | 250222000103 | 170025 | Auburn: Pakachoag School | Regular School | No | Elementary | PK | 02 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
1122270 | 1122270 | MA | Worcester | school | 2502220 | 17 | Auburn | 250222002846 | 170030 | Swanson Road Intermediate School | Regular School | No | Elementary | 03 | 05 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2229076 | 2229076 | MA | Worcester | school | 2502220 | 17 | Auburn | 250222002846 | 170030 | Auburn: Swanson Road Intermediate School | Regular School | No | Elementary | 03 | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
1122274 | 1122274 | MA | Worcester | school | 2502220 | 17 | Auburn | 250222002567 | 170305 | Auburn Middle | Regular School | No | Middle | 06 | 08 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2229080 | 2229080 | MA | Worcester | school | 2502220 | 17 | Auburn | 250222002567 | 170305 | Auburn: Auburn Middle | Regular School | No | Middle | 06 | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
932809 | 932809 | MA | Worcester | school | 2502220 | 17 | Auburn | 250222000100 | 170505 | Auburn Senior High | Regular School | No | 3 | 09 | 12 | 2016 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 1 | 2 | 3 | 1 | 2 | 3 | ||||||||||||||||||||||||||||||||||||||||
1122280 | 1122280 | MA | Worcester | school | 2502220 | 17 | Auburn | 250222000100 | 170505 | Auburn Senior High | Regular School | No | High | 09 | 12 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
1672280 | 1672280 | MA | Worcester | school | 2502220 | 17 | Auburn | 250222000100 | 170505 | Auburn - Auburn Senior High | Regular School | No | High | 09 | 12 | 2021 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 2 | 3 | * | 5.0 | 2 | 3 | 5 | |||||||||||||||||||||||||||||||||||||||
2040085 | 2040085 | MA | Worcester | school | 2502220 | 17 | Auburn | 250222000100 | 170505 | Auburn Senior High | Regular School | No | High | 09 | 12 | 2019 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 2.0 | 2 | ||||||||||||||||||||||||||||||||||||||||||||
2229086 | 2229086 | MA | Worcester | school | 2502220 | 17 | Auburn | 250222000100 | 170505 | Auburn: Auburn Senior High | Regular School | No | High | 09 | 12 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 3.0 | 3 | ||||||||||||||||||||||||||||||||||||||||||||
1122289 | 1122289 | MA | Norfolk | school | 2502250 | 18 | Avon | 250225000108 | 180010 | Ralph D Butler | Regular School | No | Elementary | PK | 06 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2229095 | 2229095 | MA | Norfolk | school | 2502250 | 18 | Avon | 250225000108 | 180010 | Avon: Ralph D Butler | Regular School | No | Elementary | PK | 06 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
932824 | 932824 | MA | Norfolk | school | 2502250 | 18 | Avon | 250225001295 | 180510 | Avon Middle High School | Regular School | No | 3 | 07 | 12 | 2016 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 1 | 1 | 2 | 1 | 1 | 2 | ||||||||||||||||||||||||||||||||||||||||
1122296 | 1122296 | MA | Norfolk | school | 2502250 | 18 | Avon | 250225001295 | 180510 | Avon Middle High School | Regular School | No | High | 07 | 12 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2040100 | 2040100 | MA | Norfolk | school | 2502250 | 18 | Avon | 250225001295 | 180510 | Avon Middle High School | Regular School | No | High | 07 | 12 | 2019 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 3.0 | 3 | ||||||||||||||||||||||||||||||||||||||||||||
2229102 | 2229102 | MA | Norfolk | school | 2502250 | 18 | Avon | 250225001295 | 180510 | Avon: Avon Middle High School | Regular School | No | High | 07 | 12 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 3.0 | 3 | ||||||||||||||||||||||||||||||||||||||||||||
1122298 | 1122298 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231002851 | 200001 | Enoch Cobb Early Learning Center | Regular School | No | Elementary | PK | PK | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2229104 | 2229104 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231002851 | 200001 | Barnstable: Enoch Cobb Early Learning Center | Regular School | No | Prekindergarten | PK | PK | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
1122303 | 1122303 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000125 | 200005 | West Barnstable Elementary | Regular School | No | Elementary | KG | 03 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2229109 | 2229109 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000125 | 200005 | Barnstable: West Barnstable Elementary | Regular School | No | Elementary | KG | 03 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
1122308 | 1122308 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000118 | 200010 | Centerville Elementary | Regular School | No | Elementary | KG | 03 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2229114 | 2229114 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000118 | 200010 | Barnstable: Centerville Elementary | Regular School | No | Elementary | KG | 03 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
1122313 | 1122313 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000121 | 200025 | Hyannis West Elementary | Regular School | No | Elementary | KG | 03 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2229119 | 2229119 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000121 | 200025 | Barnstable: Hyannis West Elementary | Regular School | No | Elementary | KG | 03 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
1122318 | 1122318 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231002679 | 200045 | West Villages Elementary School | Regular School | No | Elementary | KG | 03 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2229124 | 2229124 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231002679 | 200045 | Barnstable: West Villages Elementary School | Regular School | No | Elementary | KG | 03 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
1122321 | 1122321 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231002748 | 200050 | Barnstable United Elementary School | Regular School | No | Elementary | 04 | 05 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2229127 | 2229127 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231002748 | 200050 | Barnstable: Barnstable United Elementary School | Regular School | No | Elementary | 04 | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
1122324 | 1122324 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231002678 | 200315 | Barnstable Intermediate School | Regular School | No | Middle | 06 | 07 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2229130 | 2229130 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231002678 | 200315 | Barnstable: Barnstable Intermediate School | Regular School | No | Middle | 06 | 07 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
932851 | 932851 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000116 | 200505 | Barnstable High | Regular School | No | 3 | 08 | 12 | 2016 | sped_beyond_grade_12 | 11 | 0 | 0 | 1 | 0 | 1 | 2 | 10 | 5 | 15 | 11 | 0 | 0 | 1 | 0 | 1 | 2 | 10 | 5 | 15 | |||||||||||||||||||||||||||||||||
1122330 | 1122330 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000116 | 200505 | Barnstable High | Regular School | No | High | 08 | 12 | 2017 | sped_beyond_grade_12 | 9 | 0 | 0 | 0 | 0 | 0 | 1 | 10 | 9 | 0 | 0 | 0 | 0 | 0 | 1 | 10 | |||||||||||||||||||||||||||||||||||||
1365101 | 1365101 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000116 | 200505 | Barnstable High | Regular School | No | High | 08 | 12 | 2020 | sped_beyond_grade_12 | 10 | 0 | 1 | 1 | 1 | 0 | 0 | 7 | 6 | * | 13.0 | 10 | 0 | 1 | 1 | 1 | 0 | 0 | 7 | 6 | 13 | ||||||||||||||||||||||||||||||||
1672325 | 1672325 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000116 | 200505 | Barnstable - Barnstable High | Regular School | No | High | 08 | 12 | 2021 | sped_beyond_grade_12 | 8 | 0 | 1 | 1 | 1 | 0 | 0 | 6 | 5 | * | 11.0 | 8 | 0 | 1 | 1 | 1 | 0 | 0 | 6 | 5 | 11 | ||||||||||||||||||||||||||||||||
2040127 | 2040127 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000116 | 200505 | Barnstable High | Regular School | No | High | 08 | 12 | 2019 | sped_beyond_grade_12 | 9 | 2 | 2 | 1 | 0 | 0 | 0 | 14.0 | 9 | 2 | 2 | 1 | 0 | 0 | 0 | 14 | |||||||||||||||||||||||||||||||||||||
2229136 | 2229136 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000116 | 200505 | Barnstable: Barnstable High | Regular School | No | High | 08 | 12 | 2018 | sped_beyond_grade_12 | 10 | 1 | 1 | 0 | 0 | 0 | 1 | 13.0 | 10 | 1 | 1 | 0 | 0 | 0 | 1 | 13 | |||||||||||||||||||||||||||||||||||||
1122334 | 1122334 | MA | Middlesex | school | 2502400 | 23 | Bedford | 250240000131 | 230010 | Lt Elezer Davis | Regular School | No | Elementary | KG | 02 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2229140 | 2229140 | MA | Middlesex | school | 2502400 | 23 | Bedford | 250240000131 | 230010 | Bedford: Lt Elezer Davis | Regular School | No | Elementary | KG | 02 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
1122338 | 1122338 | MA | Middlesex | school | 2502400 | 23 | Bedford | 250240000132 | 230012 | Lt Job Lane School | Regular School | No | Elementary | 03 | 05 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2229144 | 2229144 | MA | Middlesex | school | 2502400 | 23 | Bedford | 250240000132 | 230012 | Bedford: Lt Job Lane School | Regular School | No | Elementary | 03 | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
1122342 | 1122342 | MA | Middlesex | school | 2502400 | 23 | Bedford | 250240000130 | 230305 | John Glenn Middle | Regular School | No | Middle | 06 | 08 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2229148 | 2229148 | MA | Middlesex | school | 2502400 | 23 | Bedford | 250240000130 | 230305 | Bedford: John Glenn Middle | Regular School | No | Middle | 06 | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
1122348 | 1122348 | MA | Middlesex | school | 2502400 | 23 | Bedford | 250240000128 | 230505 | Bedford High | Regular School | No | High | 09 | 12 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2229154 | 2229154 | MA | Middlesex | school | 2502400 | 23 | Bedford | 250240000128 | 230505 | Bedford: Bedford High | Regular School | No | High | 09 | 12 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
1122351 | 1122351 | MA | Hampshire | school | 2502430 | 24 | Belchertown | 250243000136 | 240005 | Cold Spring | Regular School | No | Elementary | PK | KG | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2229157 | 2229157 | MA | Hampshire | school | 2502430 | 24 | Belchertown | 250243000136 | 240005 | Belchertown: Cold Spring | Regular School | No | Elementary | PK | KG | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
1122355 | 1122355 | MA | Hampshire | school | 2502430 | 24 | Belchertown | 250243001871 | 240006 | Chestnut Hill Community School | Regular School | No | Elementary | 04 | 06 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2229161 | 2229161 | MA | Hampshire | school | 2502430 | 24 | Belchertown | 250243001871 | 240006 | Belchertown: Chestnut Hill Community School | Regular School | No | Middle | 04 | 06 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
1122359 | 1122359 | MA | Hampshire | school | 2502430 | 24 | Belchertown | 250243000836 | 240018 | Swift River Elementary | Regular School | No | Elementary | 01 | 03 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2229165 | 2229165 | MA | Hampshire | school | 2502430 | 24 | Belchertown | 250243000836 | 240018 | Belchertown: Swift River Elementary | Regular School | No | Elementary | 01 | 03 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
1122362 | 1122362 | MA | Hampshire | school | 2502430 | 24 | Belchertown | 250243001873 | 240025 | Jabish Middle School | Regular School | No | Middle | 07 | 08 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2229168 | 2229168 | MA | Hampshire | school | 2502430 | 24 | Belchertown | 250243001873 | 240025 | Belchertown: Jabish Middle School | Regular School | No | Middle | 07 | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
932880 | 932880 | MA | Hampshire | school | 2502430 | 24 | Belchertown | 250243000134 | 240505 | Belchertown High | Regular School | No | 3 | 09 | 12 | 2016 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 1 | 1 | 2 | 1 | 1 | 2 | ||||||||||||||||||||||||||||||||||||||||
1122367 | 1122367 | MA | Hampshire | school | 2502430 | 24 | Belchertown | 250243000134 | 240505 | Belchertown High | Regular School | No | High | 09 | 12 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
1365130 | 1365130 | MA | Hampshire | school | 2502430 | 24 | Belchertown | 250243000134 | 240505 | Belchertown High | Regular School | No | High | 09 | 12 | 2020 | sped_beyond_grade_12 | 5 | 1 | 0 | 0 | 0 | 0 | 1 | 6 | 1 | * | 7.0 | 5 | 1 | 0 | 0 | 0 | 0 | 1 | 6 | 1 | 7 | ||||||||||||||||||||||||||||||||
2040156 | 2040156 | MA | Hampshire | school | 2502430 | 24 | Belchertown | 250243000134 | 240505 | Belchertown High | Regular School | No | High | 09 | 12 | 2019 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 5.0 | 5 | ||||||||||||||||||||||||||||||||||||||||||||
2229173 | 2229173 | MA | Hampshire | school | 2502430 | 24 | Belchertown | 250243000134 | 240505 | Belchertown: Belchertown High | Regular School | No | High | 09 | 12 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 5.0 | 5 | ||||||||||||||||||||||||||||||||||||||||||||
1122369 | 1122369 | MA | Norfolk | school | 2502460 | 25 | Bellingham | 250246000670 | 250003 | Bellingham Early Childhood Center | Regular School | No | Elementary | PK | PK | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2229175 | 2229175 | MA | Norfolk | school | 2502460 | 25 | Bellingham | 250246000670 | 250003 | Bellingham: Bellingham Early Childhood Center | Regular School | No | Prekindergarten | PK | PK | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
1122374 | 1122374 | MA | Norfolk | school | 2502460 | 25 | Bellingham | 250246000142 | 250020 | South Elementary | Regular School | No | Elementary | KG | 03 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2229180 | 2229180 | MA | Norfolk | school | 2502460 | 25 | Bellingham | 250246000142 | 250020 | Bellingham: South Elementary | Regular School | No | Elementary | KG | 03 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
1122379 | 1122379 | MA | Norfolk | school | 2502460 | 25 | Bellingham | 250246000141 | 250025 | Stall Brook | Regular School | No | Elementary | KG | 03 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
2229185 | 2229185 | MA | Norfolk | school | 2502460 | 25 | Bellingham | 250246000141 | 250025 | Bellingham: Stall Brook | Regular School | No | Elementary | KG | 03 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 |
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]);