Data source: Big Local News · About: Big Local

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

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
2240037 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School District: TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2240023 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District: Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2240009 MA Worcester   school 2500587 3515   Old Sturbridge Academy Charter Public School (District) 250058702877 35150205 Old Sturbridge Academy Charter Public School (District): Old Sturbridge Academy Charter Public School   Regular School Yes Elementary KG 03 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2240004 MA Hampden   school 2500586 3514   Libertas Academy Charter School (District) 250058602878 35140305 Libertas Academy Charter School (District): Libertas Academy Charter School   Regular School Yes Middle 06 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2240002 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton (District): New Heights Charter School of Brockton   Regular School Yes Middle 06 09 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239997 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School (District): Bentley Academy Charter School   Regular School Yes Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239990 MA Hampden   school 2500557 3510   Springfield Preparatory Charter School (District) 250055702842 35100205 Springfield Preparatory Charter School (District): Springfield Preparatory Charter School   Regular School Yes Elementary KG 03 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239985 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School (District): Argosy Collegiate Charter School   Regular School Yes Middle 06 09 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239980 MA Hampden   school 2500555 3508   Phoenix Academy Public Charter High School Springfield (District) 250055502821 35080505 Phoenix Academy Public Charter High School Springfield (District): Phoenix Academy Public Charter High School Springfield   Regular School Yes High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239975 MA Bristol   school 2500553 3507   City on a Hill Charter Public School New Bedford (District) 250055302814 35070505 City on a Hill Charter Public School New Bedford (District): City on a Hill Charter Public School New Bedford   Regular School Yes High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239970 MA Middlesex   school 2500546 3506   Pioneer Charter School of Science II (PCSS-II) (District) 250054602780 35060505 Pioneer Charter School of Science II (PCSS-II) (District): Pioneer Charter School of Science II (PCSS-II)   Regular School Yes High 07 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239963 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester (District): UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239952 MA Suffolk   school 2500548 3504   City on a Hill Charter Public School Dudley Square (District) 250054802781 35040505 City on a Hill Charter Public School Dudley Square (District): City on a Hill Charter Public School Dudley Square   Regular School Yes High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239947 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell (District): Collegiate Charter School of Lowell   Regular School Yes Elementary KG 07 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239938 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School (District): Baystate Academy Charter Public School   Regular School Yes Secondary 06 11 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239931 MA Hampshire   school 2500547 3501   Paulo Freire Social Justice Charter School (District) 250054702782 35010505 Paulo Freire Social Justice Charter School (District): Paulo Freire Social Justice Charter School   Regular School Yes High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239926 MA Norfolk   school 2508650 915   Norfolk County Agricultural 250865001386 9150705 Norfolk County Agricultural: Norfolk County Agricultural   Career and Technical School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239921 MA Bristol   school 2503070 910   Bristol County Agricultural 250307000382 9100705 Bristol County Agricultural: Bristol County Agricultural High   Career and Technical School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239916 MA Essex   school 2512950 885   Whittier Regional Vocational Technical 251295002300 8850605 Whittier Regional Vocational Technical: Whittier Regional Vocational   Career and Technical School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239911 MA Barnstable   school 2511800 879   Upper Cape Cod Regional Vocational Technical 251180002296 8790605 Upper Cape Cod Regional Vocational Technical: Upper Cape Cod Vocational Technical   Career and Technical School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239906 MA Norfolk   school 2511735 878   Tri-County Regional Vocational Technical 251173501931 8780605 Tri-County Regional Vocational Technical: Tri-County Regional Vocational Technical   Career and Technical School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239901 MA Worcester   school 2511050 876   Southern Worcester County Regional Vocational Technical 251105001779 8760605 Southern Worcester County Regional Vocational Technical: Bay Path Regional Vocational Technical High School   Career and Technical School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239896 MA Plymouth   school 2510930 873   South Shore Regional Vocational Technical 251093001756 8730605 South Shore Regional Vocational Technical: So Shore Vocational Technical High   Career and Technical School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239891 MA Bristol   school 2511020 872   Southeastern Regional Vocational Technical 251102002290 8720605 Southeastern Regional Vocational Technical: Southeastern Regional Vocational Technical   Career and Technical School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239886 MA Middlesex   school 2510615 871   Shawsheen Valley Regional Vocational Technical 251061501701 8710605 Shawsheen Valley Regional Vocational Technical: Shawsheen Valley Vocational Technical High School   Career and Technical School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239881 MA Hampden   school 2509310 860   Pathfinder Regional Vocational Technical 250931002285 8600605 Pathfinder Regional Vocational Technical: Pathfinder Vocational Technical   Career and Technical School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             1.0                                             1
2239876 MA Bristol   school 2509140 855   Old Colony Regional Vocational Technical 250914001471 8550605 Old Colony Regional Vocational Technical: Old Colony Regional Vocational Technical   Career and Technical School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239871 MA Middlesex   school 2508960 853   Northeast Metropolitan Regional Vocational Technical 250896002283 8530605 Northeast Metropolitan Regional Vocational Technical: Northeast Metro Regional Vocational   Career and Technical School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239866 MA Middlesex   school 2508320 852   Nashoba Valley Regional Vocational Technical 250832001290 8520605 Nashoba Valley Regional Vocational Technical: Nashoba Valley Technical High School   Career and Technical School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             1.0                                             1
2239861 MA Berkshire   school 2508950 851   Northern Berkshire Regional Vocational Technical 250895002282 8510605 Northern Berkshire Regional Vocational Technical: Charles McCann Vocational Technical   Career and Technical School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239856 MA Worcester   school 2508050 832   Montachusett Regional Vocational Technical 250805002279 8320605 Montachusett Regional Vocational Technical: Montachusett Regional Vocational Technical   Career and Technical School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239851 MA Middlesex   school 2507985 830   Minuteman Regional Vocational Technical 250798501264 8300605 Minuteman Regional Vocational Technical: Minuteman Regional High   Career and Technical School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239846 MA Middlesex   school 2511060 829   South Middlesex Regional Vocational Technical 251106002291 8290605 South Middlesex Regional Vocational Technical: Joseph P Keefe Technical High School   Career and Technical School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239841 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Greater Lowell Regional Vocational Technical: Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2018   sped_beyond_grade_12 17 3 5 0   3     0   0                             28.0 17 3 5 0   3     0   0                       28
2239836 MA Bristol   school 2508440 825   Greater New Bedford Regional Vocational Technical 250844002266 8250605 Greater New Bedford Regional Vocational Technical: Gr New Bedford Vocational Technical   Career and Technical School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239831 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Greater Lawrence Regional Vocational Technical: Gr Lawrence Regional Vocational Technical   Career and Technical School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239826 MA Bristol   school 2505485 821   Greater Fall River Regional Vocational Technical 250548502269 8210605 Greater Fall River Regional Vocational Technical: Diman Regional Vocational Technical High   Career and Technical School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             1.0                                             1
2239821 MA Franklin   school 2505020 818   Franklin County Regional Vocational Technical 250502000744 8180605 Franklin County Regional Vocational Technical: Franklin County Technical   Career and Technical School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239816 MA Essex   school 2500554 817   Essex North Shore Agricultural and Technical School District 250055402833 8170505 Essex North Shore Agricultural and Technical School District: Essex Technical High School   Career and Technical School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239811 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Regional Vocational Technical: Cape Cod Region Vocational Technical   Career and Technical School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             3.0                                             3
2239806 MA Bristol   school 2503080 810   Bristol-Plymouth Regional Vocational Technical 250308002262 8100605 Bristol-Plymouth Regional Vocational Technical: Bristol-Plymouth Vocational Technical   Career and Technical School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239801 MA Norfolk   school 2502740 806   Blue Hills Regional Vocational Technical 250274000193 8060605 Blue Hills Regional Vocational Technical: Blue Hills Regional Vocational Technical   Career and Technical School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239796 MA Worcester   school 2502710 805   Blackstone Valley Regional Vocational Technical 250271000191 8050605 Blackstone Valley Regional Vocational Technical: Blackstone Valley   Career and Technical School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239791 MA Middlesex   school 2502110 801   Assabet Valley Regional Vocational Technical 250211002257 8010605 Assabet Valley Regional Vocational Technical: Assabet Valley Vocational High School   Career and Technical School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239786 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman-Hanson: Whitman Hanson Regional   Regular School No High 09 12 2018   sped_beyond_grade_12 7 0 0 0   1     0   0                             8.0 7 0 0 0   1     0   0                       8
2239781 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Whitman-Hanson: Hanson Middle School   Regular School No Middle 06 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239777 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman-Hanson: Whitman Middle   Regular School No Middle 06 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239773 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Whitman-Hanson: Indian Head   Regular School No Elementary 03 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239769 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000200 7800030 Whitman-Hanson: John H Duval   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239762 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000199 7800025 Whitman-Hanson: Maquan Elementary   Regular School No Elementary PK 02 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239757 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000190 7800010 Whitman-Hanson: Louise A Conley   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239750 MA Worcester   school 2512100 778   Quaboag Regional 251210001994 7780505 Quaboag Regional: Quaboag Regional High   Regular School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239745 MA Worcester   school 2512100 778   Quaboag Regional 251210002794 7780305 Quaboag Regional: Quaboag Regional Middle Innovation School   Regular School No Middle 07 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239742 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 Quaboag Regional: West Brookfield Elementary   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239733 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Quaboag Regional: Warren Elementary   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239724 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett: Wachusett Regional High   Regular School No High 09 12 2018   sped_beyond_grade_12 11 0 0 0   1     0   1                             13.0 11 0 0 0   1     0   1                       13
2239719 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Wachusett: Chocksett Middle School   Regular School No Middle 05 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239714 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Wachusett: Central Tree Middle   Regular School No Middle 06 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239710 MA Worcester   school 2511880 775   Wachusett 251188000888 7750305 Wachusett: Mountview Middle   Regular School No Middle 06 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239706 MA Worcester   school 2511880 775   Wachusett 251188002131 7750060 Wachusett: Glenwood Elementary School   Regular School No Elementary 03 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239702 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Wachusett: Thomas Prince   Regular School No Elementary KG 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239692 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Wachusett: Paxton Center   Regular School No Elementary KG 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239682 MA Worcester   school 2511880 775   Wachusett 251188001488 7750032 Wachusett: Leroy E.Mayo   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239675 MA Worcester   school 2511880 775   Wachusett 251188001476 7750027 Wachusett: Houghton Elementary   Regular School No Elementary KG 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239669 MA Worcester   school 2511880 775   Wachusett 251188000884 7750020 Wachusett: Dawson   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239662 MA Worcester   school 2511880 775   Wachusett 251188001607 7750018 Wachusett: Davis Hill Elementary   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239655 MA Worcester   school 2511880 775   Wachusett 251188002693 7750005 Wachusett: Naquag Elementary School   Regular School No Elementary KG 02 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239651 MA Worcester   school 2511880 775   Wachusett 251188002730 7750001 Wachusett: Early Childhood Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
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
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
2239631 MA Essex   school 2511740 773   Triton 251174001932 7730505 Triton: Triton Regional High School   Regular School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239626 MA Essex   school 2511740 773   Triton 251174001470 7730405 Triton: Triton Regional Middle School   Regular School No Middle 07 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239623 MA Essex   school 2511740 773   Triton 251174001651 7730025 Triton: Pine Grove   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239614 MA Essex   school 2511740 773   Triton 251174001348 7730020 Triton: Newbury Elementary   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239605 MA Essex   school 2511740 773   Triton 251174001669 7730015 Triton: Salisbury Elementary   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239596 MA Worcester   school 2511490 770   Tantasqua 251149001901 7700605 Tantasqua: Tantasqua Regional Vocational   Career and Technical School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239591 MA Worcester   school 2511490 770   Tantasqua 251149001900 7700505 Tantasqua: Tantasqua Regional Sr High   Regular School No High 09 12 2018   sped_beyond_grade_12 8 0 0 0   0     0   0                             8.0 8 0 0 0   0     0   0                       8
2239586 MA Worcester   school 2511490 770   Tantasqua 251149001899 7700405 Tantasqua: Tantasqua Regional Jr High   Regular School No Middle 07 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
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
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
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
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
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
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
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
2239541 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Southern Berkshire: Mt Everett Regional   Regular School No High 07 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239534 MA Berkshire   school 2511040 765   Southern Berkshire 251104000428 7650035 Southern Berkshire: Undermountain   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239525 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 Southern Berkshire: New Marlborough Central   Regular School No Elementary PK 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239518 MA Bristol   school 2500541 763   Somerset Berkley Regional School District 250054102728 7630505 Somerset Berkley Regional School District: Somerset Berkley Regional High School   Regular School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             2.0                                             2
2239513 MA Plymouth   school 2510830 760   Silver Lake 251083001722 7600505 Silver Lake: Silver Lake Regional High   Regular School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239507 MA Plymouth   school 2510830 760   Silver Lake 251083001721 7600405 Silver Lake: Silver Lake Regional Middle School   Regular School No Middle 07 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239504 MA Franklin   school 2509900 755   Ralph C Mahar 250990002707 7550525 Ralph C Mahar: The Gateway to College   Regular School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239500 MA Franklin   school 2509900 755   Ralph C Mahar 250990002701 7550515 Ralph C Mahar: Pathways Early College Innovation School   Regular School No High 11 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239497 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar: Ralph C Mahar Regional   Regular School No High 07 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
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
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
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
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
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
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

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