enrollments
Data source: Big Local News · About: Big Local
1,848 rows where grade = "sped_beyond_grade_12", state = "MA" and year = 2018 sorted by asian_pacific_islander_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2228755 | 2228755 | MA | Plymouth | school | 2501650 | 1 | Abington | 250165002727 | 10001 | Abington: Abington Early Education Program | Regular School | No | Prekindergarten | PK | PK | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228758 | 2228758 | MA | Plymouth | school | 2501650 | 1 | Abington | 250165000006 | 10015 | Abington: Woodsdale Elementary School | Regular School | No | Elementary | 03 | 04 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228762 | 2228762 | MA | Plymouth | school | 2501650 | 1 | Abington | 250165000434 | 10020 | Abington: Beaver Brook Elementary | Regular School | No | Elementary | KG | 02 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228767 | 2228767 | MA | Plymouth | school | 2501650 | 1 | Abington | 250165000002 | 10405 | Abington: Abington Middle School | Regular School | No | Middle | 05 | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228772 | 2228772 | MA | Plymouth | school | 2501650 | 1 | Abington | 250165000001 | 10505 | Abington: Abington High | Regular School | No | High | 09 | 12 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 3.0 | 3 | ||||||||||||||||||||||||||||||||||||||||||||
2228779 | 2228779 | MA | Bristol | school | 2501740 | 3 | Acushnet | 250174000014 | 30025 | Acushnet: Acushnet Elementary School | Regular School | No | Elementary | PK | 04 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228784 | 2228784 | MA | Bristol | school | 2501740 | 3 | Acushnet | 250174000015 | 30305 | Acushnet: Albert F Ford Middle School | Regular School | No | Middle | 05 | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228786 | 2228786 | MA | Hampden | school | 2501800 | 5 | Agawam | 250180001499 | 50003 | Agawam: Agawam Early Childhood Center | Regular School | No | Prekindergarten | PK | PK | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228792 | 2228792 | MA | Hampden | school | 2501800 | 5 | Agawam | 250180000028 | 50010 | Agawam: Clifford M Granger | Regular School | No | Elementary | KG | 04 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228798 | 2228798 | MA | Hampden | school | 2501800 | 5 | Agawam | 250180000027 | 50020 | Agawam: Benjamin J Phelps | Regular School | No | Elementary | KG | 04 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228804 | 2228804 | MA | Hampden | school | 2501800 | 5 | Agawam | 250180000032 | 50025 | Agawam: Robinson Park | Regular School | No | Elementary | KG | 04 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228810 | 2228810 | MA | Hampden | school | 2501800 | 5 | Agawam | 250180000030 | 50030 | Agawam: James Clark School | Regular School | No | Elementary | KG | 04 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228813 | 2228813 | MA | Hampden | school | 2501800 | 5 | Agawam | 250180000026 | 50303 | Agawam: Roberta G. Doering School | Regular School | No | Middle | 05 | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228816 | 2228816 | MA | Hampden | school | 2501800 | 5 | Agawam | 250180000025 | 50405 | Agawam: Agawam Junior High | Regular School | No | Middle | 07 | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228821 | 2228821 | MA | Hampden | school | 2501800 | 5 | Agawam | 250180000024 | 50505 | Agawam: Agawam High | Regular School | No | High | 09 | 12 | 2018 | sped_beyond_grade_12 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 10.0 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | |||||||||||||||||||||||||||||||||||||
2228828 | 2228828 | MA | Essex | school | 2501860 | 7 | Amesbury | 250186000033 | 70005 | Amesbury: Amesbury Elementary | Regular School | No | Elementary | PK | 04 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228835 | 2228835 | MA | Essex | school | 2501860 | 7 | Amesbury | 250186000036 | 70010 | Amesbury: Charles C Cashman Elementary | Regular School | No | Elementary | PK | 04 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228840 | 2228840 | MA | Essex | school | 2501860 | 7 | Amesbury | 250186000035 | 70013 | Amesbury: Amesbury Middle | Regular School | No | Middle | 05 | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228845 | 2228845 | MA | Essex | school | 2501860 | 7 | Amesbury | 250186000034 | 70505 | Amesbury: Amesbury High | Regular School | No | High | 09 | 12 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 2.0 | 2 | ||||||||||||||||||||||||||||||||||||||||||||
2228850 | 2228850 | MA | Essex | school | 2501860 | 7 | Amesbury | 250186002841 | 70515 | Amesbury: Amesbury Innovation High School | Regular School | No | High | 09 | 12 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228859 | 2228859 | MA | Hampshire | school | 2501890 | 8 | Amherst | 250189000038 | 80009 | Amherst: Crocker Farm Elementary | Regular School | No | Elementary | PK | 06 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228867 | 2228867 | MA | Hampshire | school | 2501890 | 8 | Amherst | 250189000039 | 80020 | Amherst: Fort River Elementary | Regular School | No | Elementary | KG | 06 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228875 | 2228875 | MA | Hampshire | school | 2501890 | 8 | Amherst | 250189000041 | 80050 | Amherst: Wildwood Elementary | Regular School | No | Elementary | KG | 06 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228882 | 2228882 | MA | Essex | school | 2501950 | 9 | Andover | 250195000047 | 90003 | Andover: Bancroft Elementary | Regular School | No | Elementary | KG | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228889 | 2228889 | MA | Essex | school | 2501950 | 9 | Andover | 250195001676 | 90004 | Andover: High Plain Elementary | Regular School | No | Elementary | KG | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228891 | 2228891 | MA | Essex | school | 2501950 | 9 | Andover | 250195002366 | 90005 | Andover: Shawsheen School | Regular School | No | Prekindergarten | PK | PK | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228898 | 2228898 | MA | Essex | school | 2501950 | 9 | Andover | 250195000048 | 90010 | Andover: Henry C Sanborn Elementary | Regular School | No | Elementary | KG | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228905 | 2228905 | MA | Essex | school | 2501950 | 9 | Andover | 250195000050 | 90020 | Andover: South Elementary | Regular School | No | Elementary | KG | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228912 | 2228912 | MA | Essex | school | 2501950 | 9 | Andover | 250195000051 | 90025 | Andover: West Elementary | Regular School | No | Elementary | KG | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228916 | 2228916 | MA | Essex | school | 2501950 | 9 | Andover | 250195002510 | 90305 | Andover: Doherty Middle | Regular School | No | Middle | 06 | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228920 | 2228920 | MA | Essex | school | 2501950 | 9 | Andover | 250195002511 | 90310 | Andover: Andover West Middle | Regular School | No | Middle | 06 | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228924 | 2228924 | MA | Essex | school | 2501950 | 9 | Andover | 250195001678 | 90350 | Andover: Wood Hill Middle School | Regular School | No | Middle | 06 | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228929 | 2228929 | MA | Essex | school | 2501950 | 9 | Andover | 250195000045 | 90505 | Andover: Andover High | Regular School | No | High | 09 | 12 | 2018 | sped_beyond_grade_12 | 17 | 1 | 0 | 0 | 0 | 0 | 0 | 18.0 | 17 | 1 | 0 | 0 | 0 | 0 | 0 | 18 | |||||||||||||||||||||||||||||||||||||
2228936 | 2228936 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000059 | 100005 | Arlington: John A Bishop | Regular School | No | Elementary | KG | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228943 | 2228943 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000054 | 100010 | Arlington: Brackett | Regular School | No | Elementary | KG | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228950 | 2228950 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000057 | 100025 | Arlington: Cyrus E Dallin | Regular School | No | Elementary | KG | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228957 | 2228957 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000058 | 100030 | Arlington: Hardy | Regular School | No | Elementary | KG | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228959 | 2228959 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198001681 | 100038 | Arlington: Menotomy Preschool | Regular School | No | Prekindergarten | PK | PK | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228966 | 2228966 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000065 | 100045 | Arlington: Peirce | Regular School | No | Elementary | KG | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228973 | 2228973 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000066 | 100050 | Arlington: Thompson | Regular School | No | Elementary | KG | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228980 | 2228980 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000062 | 100055 | Arlington: M Norcross Stratton | Regular School | No | Elementary | KG | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228984 | 2228984 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000063 | 100410 | Arlington: Ottoson Middle | Regular School | No | Middle | 06 | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228989 | 2228989 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000053 | 100505 | Arlington: Arlington High | Regular School | No | High | 09 | 12 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2228991 | 2228991 | MA | Middlesex | school | 2502100 | 14 | Ashland | 250210002455 | 140005 | Ashland: William Pittaway Elementary | Regular School | No | Prekindergarten | PK | PK | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||
2229190 | 2229190 | MA | Norfolk | school | 2502460 | 25 | Bellingham | 250246001683 | 250315 | Bellingham: Bellingham Memorial School | Regular School | No | Middle | 04 | 07 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229196 | 2229196 | MA | Norfolk | school | 2502460 | 25 | Bellingham | 250246000139 | 250505 | Bellingham: Bellingham High School | Regular School | No | High | 08 | 12 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229202 | 2229202 | MA | Norfolk | school | 2502460 | 25 | Bellingham | 250246002543 | 250510 | Bellingham: Keough Memorial Academy | Alternative School | No | High | 08 | 12 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229208 | 2229208 | MA | Middlesex | school | 2502490 | 26 | Belmont | 250249000148 | 260005 | Belmont: Winn Brook | Regular School | No | Elementary | KG | 04 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229214 | 2229214 | MA | Middlesex | school | 2502490 | 26 | Belmont | 250249000146 | 260010 | Belmont: Mary Lee Burbank | Regular School | No | Elementary | KG | 04 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229220 | 2229220 | MA | Middlesex | school | 2502490 | 26 | Belmont | 250249000144 | 260015 | Belmont: Daniel Butler | Regular School | No | Elementary | KG | 04 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229227 | 2229227 | MA | Middlesex | school | 2502490 | 26 | Belmont | 250249000147 | 260035 | Belmont: Roger E Wellington | Regular School | No | Elementary | PK | 04 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229232 | 2229232 | MA | Middlesex | school | 2502490 | 26 | Belmont | 250249000149 | 260305 | Belmont: Winthrop L Chenery Middle | Regular School | No | Middle | 05 | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229237 | 2229237 | MA | Middlesex | school | 2502490 | 26 | Belmont | 250249000143 | 260505 | Belmont: Belmont High | Regular School | No | High | 09 | 12 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229244 | 2229244 | MA | Bristol | school | 2502520 | 27 | Berkley | 250252002513 | 270010 | Berkley: Berkley Community School | Regular School | No | Elementary | PK | 04 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229249 | 2229249 | MA | Bristol | school | 2502520 | 27 | Berkley | 250252001613 | 270305 | Berkley: Berkley Middle School | Regular School | No | Middle | 05 | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229257 | 2229257 | MA | Worcester | school | 2502550 | 28 | Berlin | 250255000159 | 280005 | Berlin: Berlin Memorial | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229259 | 2229259 | MA | Essex | school | 2502640 | 30 | Beverly | 250264002854 | 300002 | Beverly: McKeown School | Regular School | No | Prekindergarten | PK | PK | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229266 | 2229266 | MA | Essex | school | 2502640 | 30 | Beverly | 250264000167 | 300010 | Beverly: Centerville Elementary | Regular School | No | Elementary | KG | 05 | 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]);