enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • sped_beyond_grade_12 · 4,167 ✖
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
2236582 2236582 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro: Truro Central   Regular School No Elementary PK 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2236954 2236954 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet: Wellfleet Elementary   Regular School No Elementary PK 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2238027 2238027 MA Barnstable   school 2500081 427   Barnstable Community Horace Mann Charter Public (District) 250008101844 4270010 Barnstable Community Horace Mann Charter Public (District): Barnstable Community Horace Mann Charter Public School   Regular School Yes Elementary KG 03 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2238072 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
2238446 2238446 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public (District): Sturgis Charter Public School   Regular School Yes High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2238815 2238815 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Dennis-Yarmouth: Ezra H Baker Innovation School   Regular School No Elementary PK 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2238821 2238821 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Dennis-Yarmouth: Marguerite E Small Elementary   Regular School No Elementary PK 03 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2238826 2238826 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Dennis-Yarmouth: Station Avenue Elementary   Regular School No Elementary KG 03 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2238829 2238829 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 Dennis-Yarmouth: N H Wixon Innovation School   Regular School No Elementary 04 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2238833 2238833 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Dennis-Yarmouth: Mattacheese Middle School   Regular School No Middle 05 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2238839 2238839 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth: Dennis-Yarmouth Regional High   Regular School No High 08 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2238911 2238911 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset: Nauset Regional Middle   Regular School No Middle 06 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2238916 2238916 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset: Nauset Regional High   Regular School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             4.0                                             4
2239189 2239189 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400469 7120001 Monomoy Regional School District: Chatham Elementary School   Regular School No Elementary PK 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239196 2239196 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Monomoy Regional School District: Harwich Elementary School   Regular School No Elementary PK 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239200 2239200 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional School District: Monomoy Regional Middle School   Regular School No Middle 05 07 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239206 2239206 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional School District: Monomoy Regional High School   Regular School No High 08 12 2018   sped_beyond_grade_12 8 1 0 0   0     0   1                             10.0 8 1 0 0   0     0   1                       10
2239811 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
2239911 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
937292 937292 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No 3 08 12 2016   sped_beyond_grade_12 6 0 0 0   0     0   0   3 3                       6 6 0 0 0   0     0   0   3 3                 6
940824 940824 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2016   sped_beyond_grade_12 * * * *   *     *   *   2 1                       3                         2 1                 3
940915 940915 MA Berkshire   school 2502530 618   Berkshire Hills 250253000154 6180505 Monument Mt Regional High   Regular School No 3 09 12 2016   sped_beyond_grade_12 7 1 1 0   0     0   0   8 1                       9 7 1 1 0   0     0   0   8 1                 9
1124216 1124216 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124928 1124928 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125321 1125321 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125754 1125754 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125904 1125904 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125911 1125911 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No High 07 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125937 1125937 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Morris   Regular School No Elementary PK 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125945 1125945 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No Other 06 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1127569 1127569 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 Colegrove Park Elementary   Regular School No Elementary KG 07 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1127578 1127578 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 Greylock   Regular School No Elementary KG 07 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1127588 1127588 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No Elementary PK 07 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1127594 1127594 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No High 08 12 2017   sped_beyond_grade_12 7 0 0 0   0     0   0                             7 7 0 0 0   0     0   0                       7
1128105 1128105 MA Berkshire   school 2509630 236   Pittsfield 250963001516 2360010 Allendale   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128112 1128112 MA Berkshire   school 2509630 236   Pittsfield 250963001519 2360035 Egremont   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128120 1128120 MA Berkshire   school 2509630 236   Pittsfield 250963001522 2360045 Robert T. Capeless Elementary School   Regular School No Elementary PK 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128128 1128128 MA Berkshire   school 2509630 236   Pittsfield 250963001524 2360055 Morningside Community School   Regular School No Elementary PK 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128136 1128136 MA Berkshire   school 2509630 236   Pittsfield 250963001528 2360065 Crosby   Regular School No Elementary PK 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128143 1128143 MA Berkshire   school 2509630 236   Pittsfield 250963002489 2360090 Stearns   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128150 1128150 MA Berkshire   school 2509630 236   Pittsfield 250963001536 2360100 Williams   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128158 1128158 MA Berkshire   school 2509630 236   Pittsfield 250963001535 2360105 Silvio O Conte Community   Regular School No Elementary PK 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128162 1128162 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 John T Reid Middle   Regular School No Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128166 1128166 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Theodore Herberg Middle   Regular School No Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128171 1128171 MA Berkshire   school 2509630 236   Pittsfield 250963001526 2360505 Pittsfield High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128176 1128176 MA Berkshire   school 2509630 236   Pittsfield 250963001534 2360510 Taconic High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128557 1128557 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128754 1128754 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No Elementary PK 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130542 1130542 MA Berkshire   school 2513020 341   Williamstown 251302002146 3410010 Williamstown Elementary   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131148 1131148 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes Other 06 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131749 1131749 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000018 6030004 Cheshire Elementary   Regular School No Elementary PK 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131756 1131756 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000023 6030020 Plunkett Elementary   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131764 1131764 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No Other 06 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131854 1131854 MA Berkshire   school 2502530 618   Berkshire Hills 250253001999 6180035 Muddy Brook Regional Elementary School   Regular School No Elementary PK 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131859 1131859 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No Middle 05 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131864 1131864 MA Berkshire   school 2502530 618   Berkshire Hills 250253000154 6180505 Monument Mt Regional High   Regular School No High 09 12 2017   sped_beyond_grade_12 9 2 0 0   0     0   0                             11 9 2 0 0   0     0   0                       11
1131949 1131949 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Becket Washington School   Regular School No Elementary PK 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131957 1131957 MA Berkshire   school 2503390 635   Central Berkshire 250339000462 6350025 Craneville   Regular School No Elementary PK 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131965 1131965 MA Berkshire   school 2503390 635   Central Berkshire 250339000465 6350035 Kittredge   Regular School No Elementary PK 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131969 1131969 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131974 1131974 MA Berkshire   school 2503390 635   Central Berkshire 250339000467 6350505 Wahconah Regional High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132094 1132094 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132382 1132382 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No High 07 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132700 1132700 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 New Marlborough Central   Regular School No Elementary PK 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132703 1132703 MA Berkshire   school 2511040 765   Southern Berkshire 251104001778 7650030 South Egremont   Regular School No Elementary KG 01 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132712 1132712 MA Berkshire   school 2511040 765   Southern Berkshire 251104000428 7650035 Undermountain   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132719 1132719 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Mt Everett Regional   Regular School No High 07 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1133046 1133046 MA Berkshire   school 2508950 851   Northern Berkshire Regional Vocational Technical 250895002282 8510605 Charles McCann Vocational Technical   Career and Technical School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1368083 1368083 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No High 07 12 2020   sped_beyond_grade_12 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1369520 1369520 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No High 07 12 2020   sped_beyond_grade_12 * * * *   *     *   *   2 3 *                     5.0                         2 3                 5
1370007 1370007 MA Berkshire   school 2509630 236   Pittsfield 250963001526 2360505 Pittsfield High   Regular School No High 09 12 2020   sped_beyond_grade_12 10 0 1 0   0     0   0   8 3 *                     11.0 10 0 1 0   0     0   0   8 3                 11
1373128 1373128 MA Berkshire   school 2502530 618   Berkshire Hills 250253000154 6180505 Monument Mt Regional High   Regular School No High 09 12 2020   sped_beyond_grade_12 7 0 0 0   0     0   0   3 4 *                     7.0 7 0 0 0   0     0   0   3 4                 7
1373593 1373593 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No High 07 12 2020   sped_beyond_grade_12 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1675329 1675329 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee - Lee Middle/High School   Regular School No High 07 12 2021   sped_beyond_grade_12 * * * *   *     *   *   3 1 *                     4.0                         3 1                 4
1677252 1677252 MA Berkshire   school 2509630 236   Pittsfield 250963001526 2360505 Pittsfield - Pittsfield High   Regular School No High 09 12 2021   sped_beyond_grade_12 10 0 3 0   0     0   1   11 3 *                     14.0 10 0 3 0   0     0   1   11 3                 14
2043167 2043167 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No High 07 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             3.0                                             3
2044593 2044593 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No High 07 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             3.0                                             3
2045081 2045081 MA Berkshire   school 2509630 236   Pittsfield 250963001526 2360505 Pittsfield High   Regular School No High 09 12 2019   sped_beyond_grade_12 11 3 1 0   0     0   0                             15.0 11 3 1 0   0     0   0                       15
2048116 2048116 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley High School   Regular School No High 08 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             3.0                                             3
2048202 2048202 MA Berkshire   school 2502530 618   Berkshire Hills 250253000154 6180505 Monument Mt Regional High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             5.0                                             5
2048293 2048293 MA Berkshire   school 2503390 635   Central Berkshire 250339000467 6350505 Wahconah Regional High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             1.0                                             1
2048655 2048655 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No High 07 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             3.0                                             3
2231031 2231031 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg: Clarksburg Elementary   Regular School No Elementary KG 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231756 2231756 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida: Abbott Memorial   Regular School No Elementary PK 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232134 2232134 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock: Hancock Elementary   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232571 2232571 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough: Lanesborough Elementary   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232720 2232720 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee: Lee Elementary   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232727 2232727 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee: Lee Middle/High School   Regular School No High 07 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232753 2232753 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Lenox: Morris   Regular School No Elementary PK 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232761 2232761 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox: Lenox Memorial High   Regular School No High 06 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2234391 2234391 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 North Adams: Colegrove Park Elementary   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2234400 2234400 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 North Adams: Greylock   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2234409 2234409 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 North Adams: Brayton   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2234416 2234416 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 North Adams: Drury High   Regular School No High 07 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             4.0                                             4
2234927 2234927 MA Berkshire   school 2509630 236   Pittsfield 250963001516 2360010 Pittsfield: Allendale   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2234934 2234934 MA Berkshire   school 2509630 236   Pittsfield 250963001519 2360035 Pittsfield: Egremont   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2234942 2234942 MA Berkshire   school 2509630 236   Pittsfield 250963001522 2360045 Pittsfield: Robert T. Capeless Elementary School   Regular School No Elementary PK 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2234950 2234950 MA Berkshire   school 2509630 236   Pittsfield 250963001524 2360055 Pittsfield: Morningside Community School   Regular School No Elementary PK 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2234958 2234958 MA Berkshire   school 2509630 236   Pittsfield 250963001528 2360065 Pittsfield: Crosby   Regular School No Elementary PK 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2234965 2234965 MA Berkshire   school 2509630 236   Pittsfield 250963002489 2360090 Pittsfield: Stearns   Regular School No Elementary KG 05 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]);