Data source: Big Local News · About: Big Local

4,267 rows where grade = "sped_beyond_grade_12" and state = "MA" sorted by school_nces_id

View and edit SQL

year

grade

  • sped_beyond_grade_12 · 4,267
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
941586 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin Regional High School   Regular School No 3 09 12 2016   sped_beyond_grade_12 * * * *   *     *   *   2 1                       3                         2 1                 3
1132662 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin Regional High School   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1373825 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin Regional High School   Regular School No High 09 12 2020   sped_beyond_grade_12 * * * *   *     *   *   2 2 *                     4.0                         2 2                 4
1681073 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin - Quabbin Regional High School   Regular School No High 09 12 2021   sped_beyond_grade_12 6 0 0 0   0     0   0   2 4 *                     6.0 6 0 0 0   0     0   0   2 4                 6
2048891 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin Regional High School   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             1.0                                             1
2239487 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin: Quabbin Regional High School   Regular School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1132657 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin Regional Middle School   Regular School No Middle 07 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2239482 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin: Quabbin Regional Middle School   Regular School No Middle 07 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1132628 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2239453 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Quabbin: Hardwick Elementary   Regular School No Elementary KG 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1132636 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2239461 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Quabbin: Hubbardston Center   Regular School No Elementary KG 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1132640 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No Elementary PK 01 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2239464 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 Quabbin: New Braintree Grade   Regular School No Elementary KG 01 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1132646 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2239470 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Quabbin: Oakham Center   Regular School No Elementary 02 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1132654 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2239479 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Quabbin: Ruggles Lane   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1132665 MA Worcester   school 2500001 753   Quabbin 250000102797 7530515 IB School of Quabbin   Regular School No High 11 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2239490 MA Worcester   school 2500001 753   Quabbin 250000102797 7530515 Quabbin: IB School of Quabbin   Regular School No High 11 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1132763 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2239578 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Spencer-E Brookfield: Knox Trail Middle School   Regular School No Middle 05 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1132752 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2239567 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 Spencer-E Brookfield: East Brookfield Elementary   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
941674 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No 3 09 12 2016   sped_beyond_grade_12 * * * *   *     *   *   3 1                       4                         3 1                 4
1132768 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1681148 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 Spencer-E Brookfield - David Prouty High   Regular School No High 09 12 2021   sped_beyond_grade_12 * * * *   *     *   *   1 2 *                     3.0                         1 2                 3
2048973 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             1.0                                             1
2239583 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 Spencer-E Brookfield: David Prouty High   Regular School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             3.0                                             3
1132758 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Wire Village School   Regular School No Elementary KG 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2239573 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Spencer-E Brookfield: Wire Village School   Regular School No Elementary KG 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1132743 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2048951 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             3.0                                             3
2239558 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick-Tolland-Granville Regional School District: Southwick Regional School   Regular School No High 07 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             2.0                                             2
1132724 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2239546 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Southwick-Tolland-Granville Regional School District: Woodland School   Regular School No Elementary PK 02 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1132736 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No Elementary 03 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2239551 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Southwick-Tolland-Granville Regional School District: Powder Mill School   Regular School No Elementary 03 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1132731 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302847 7660215 Granville Village School   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131941 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2238771 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 Chesterfield-Goshen: New Hingham Regional Elementary   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131133 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes Other 05 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237960 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public (District): Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131181 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2238009 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public (District): Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131241 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2238072 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter (District): Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131250 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes Other 05 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2238081 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter (District): Innovation Academy Charter School   Regular School Yes High 05 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131263 MA Suffolk   school 2500026 437   City on a Hill Charter Public School Circuit Street (District) 250002600530 4370505 City on a Hill Charter Public School Circuit Street   Regular School Yes High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2238094 MA Suffolk   school 2500026 437   City on a Hill Charter Public School Circuit Street (District) 250002600530 4370505 City on a Hill Charter Public School Circuit Street (District): City on a Hill Charter Public School Circuit Street   Regular School Yes High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131300 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2238131 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect (District): Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131314 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2238145 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter (District): Sabis International Charter School   Regular School Yes Other KG 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131325 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes Elementary PK 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2238157 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter (District): Neighborhood House Charter School   Regular School Yes Other PK 09 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131363 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2238195 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public (District): Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131382 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2238214 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public (District): Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131408 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2238240 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter (District): Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131434 MA Middlesex   school 2500033 458   Lowell Middlesex Academy Charter (District) 250003300555 4580505 Lowell Middlesex Academy Charter School   Regular School Yes High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2238266 MA Middlesex   school 2500033 458   Lowell Middlesex Academy Charter (District) 250003300555 4580505 Lowell Middlesex Academy Charter (District): Lowell Middlesex Academy Charter School   Regular School Yes High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131448 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes Elementary 04 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2238281 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public (District): Marblehead Community Charter Public School   Regular School Yes Middle 04 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131462 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2238295 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter (District): Martha's Vineyard Charter School   Regular School Yes Other KG 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131465 MA Worcester   school 2500036 468   Ma Academy for Math and Science 250003600576 4680505 Ma Academy for Math and Science School   Regular School No High 11 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2238298 MA Worcester   school 2500036 468   Ma Academy for Math and Science 250003600576 4680505 Ma Academy for Math and Science: Ma Academy for Math and Science School   Regular School No High 11 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131515 MA Middlesex   school 2500038 478   Francis W. Parker Charter Essential (District) 250003800581 4780505 Francis W. Parker Charter Essential School   Regular School Yes High 07 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2238348 MA Middlesex   school 2500038 478   Francis W. Parker Charter Essential (District) 250003800581 4780505 Francis W. Parker Charter Essential (District): Francis W. Parker Charter Essential School   Regular School Yes High 07 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131535 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2238368 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public (District): Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131607 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public School   Regular School Yes Other KG 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2238441 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public (District): South Shore Charter Public School   Regular School Yes Other KG 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131625 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 11 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2238460 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District): Atlantis Charter School   Regular School Yes Other KG 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1132823 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2239638 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Up-Island Regional: Chilmark Elementary   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1132834 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2239649 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 Up-Island Regional: West Tisbury Elementary   Regular School No Elementary PK 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131522 MA Hampshire   school 2500044 479   Pioneer Valley Performing Arts Charter Public (District) 250004400816 4790505 Pioneer Valley Performing Arts Charter Public School   Regular School Yes High 07 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2238355 MA Hampshire   school 2500044 479   Pioneer Valley Performing Arts Charter Public (District) 250004400816 4790505 Pioneer Valley Performing Arts Charter Public (District): Pioneer Valley Performing Arts Charter Public School   Regular School Yes High 07 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131579 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter School   Regular School Yes Elementary KG 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2238413 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter Public (District): Seven Hills Charter School   Regular School Yes Elementary KG 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131593 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2238427 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter (District): Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131186 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter School   Regular School Yes High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2238013 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter (District): Boston Day and Evening Academy Charter School   Regular School Yes High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131339 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2238171 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public (District): Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131353 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2238185 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter (District): Foxborough Regional Charter School   Regular School Yes Other KG 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131372 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes Other 05 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2238204 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter (District): Boston Collegiate Charter School   Regular School Yes High 05 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131387 MA Suffolk   school 2500054 452   Edward M. Kennedy Academy for Health Careers (Horace Mann Charter) (District) 250005401258 4520505 Edward M. Kennedy Academy for Health Careers (Horace Mann Charter School)   Regular School Yes High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2238219 MA Suffolk   school 2500054 452   Edward M. Kennedy Academy for Health Careers (Horace Mann Charter) (District) 250005401258 4520505 Edward M. Kennedy Academy for Health Careers (Horace Mann Charter) (District): Edward M. Kennedy Academy for Health Careers (Horace Mann Charter School)   Regular School Yes High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131494 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);