enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
941477 941477 MA Middlesex   school 2508790 735   North Middlesex 250879002705 7350515 Peter Fitzpatrick School   Regular School No 4 UG UG 2016   sped_beyond_grade_12 10 0 0 0   0     0   0   * *                       10 10 0 0 0   0     0   0                       10
1367692 1367692 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   sped_beyond_grade_12 6 0 3 0   0     0   0   5 * *                     9.0 6 0 3 0   0     0   0   5                   9
1368470 1368470 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   sped_beyond_grade_12 6 0 0 0   0     0   0   * * *                     6.0 6 0 0 0   0     0   0                       6
1369818 1369818 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 ACE Program   Special Education School No High 10 12 2020   sped_beyond_grade_12 * * * *   *     *   *   1 * *                     1.0                         1                   1
1374320 1374320 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   sped_beyond_grade_12 * * * *   *     *   *   * * *                     0.0                                             0
1674763 1674763 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   sped_beyond_grade_12 * * * *   *     *   *   * * *                     0.0                                             0
1675711 1675711 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   sped_beyond_grade_12 * * * *   *     *   *   * * *                     4.0                                             4
932824 932824 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No 3 07 12 2016   sped_beyond_grade_12 * * * *   *     *   *   1 1                       2                         1 1                 2
932880 932880 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No 3 09 12 2016   sped_beyond_grade_12 * * * *   *     *   *   1 1                       2                         1 1                 2
933683 933683 MA Suffolk   school 2502790 35   Boston 250279002016 350522 Excel High School   Regular School No 3 09 12 2016   sped_beyond_grade_12 * * * *   *     *   *   3 1                       4                         3 1                 4
934265 934265 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No 3 09 12 2016   sped_beyond_grade_12 * * * *   *     *   *   1 1                       2                         1 1                 2
934384 934384 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No 3 09 12 2016   sped_beyond_grade_12 * * * *   *     *   *   3 1                       4                         3 1                 4
934454 934454 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee High   Regular School No 3 09 12 2016   sped_beyond_grade_12 5 0 2 0   0     0   0   6 1                       7 5 0 2 0   0     0   0   6 1                 7
934684 934684 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut Senior High   Regular School No 3 09 12 2016   sped_beyond_grade_12 * * * *   *     *   *   4 1                       5                         4 1                 5
934744 934744 MA Hampshire   school 2504590 86   Easthampton 250459000612 860505 Easthampton High   Regular School No 3 09 12 2016   sped_beyond_grade_12 * * * *   *     *   *   2 1                       3                         2 1                 3
935219 935219 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No 3 08 12 2016   sped_beyond_grade_12 * * * *   *     *   *   4 1                       5                         4 1                 5
935276 935276 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester High   Regular School No 3 09 12 2016   sped_beyond_grade_12 * * * *   *     *   *   2 1                       3                         2 1                 3
935551 935551 MA Middlesex   school 2506240 136   Holliston 250624000894 1360505 Holliston High   Regular School No 3 09 12 2016   sped_beyond_grade_12 * * * *   *     *   *   2 1                       3                         2 1                 3
935658 935658 MA Middlesex   school 2506330 139   Hopkinton 250633000920 1390505 Hopkinton High   Regular School No 3 09 12 2016   sped_beyond_grade_12 * * * *   *     *   *   3 1                       4                         3 1                 4
937141 937141 MA Essex   school 2508580 204   Newburyport 250858001354 2040505 Newburyport High   Regular School No 3 09 12 2016   sped_beyond_grade_12 * * * *   *     *   *   3 1                       4                         3 1                 4
938485 938485 MA Middlesex   school 2510890 274   Somerville 251089001745 2740505 Somerville High   Regular School No 3 09 12 2016   sped_beyond_grade_12 * * * *   *     *   *   3 1                       4                         3 1                 4
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
940852 940852 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000069 6100505 Oakmont Regional High School   Regular School No 3 09 12 2016   sped_beyond_grade_12 7 0 0 0   0     0   0   6 1                       7 7 0 0 0   0     0   0   6 1                 7
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
941054 941054 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000568 6500505 Dighton-Rehoboth Regional High School   Regular School No 3 09 12 2016   sped_beyond_grade_12 * * * *   *     *   *   2 1                       3                         2 1                 3
941126 941126 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier Regional   Regular School No 3 07 12 2016   sped_beyond_grade_12 * * * *   *     *   *   1 1                       2                         1 1                 2
941147 941147 MA Hampshire   school 2505160 672   Gateway 250516000758 6720505 Gateway Regional High   Regular School No 3 09 12 2016   sped_beyond_grade_12 * * * *   *     *   *   2 1                       3                         2 1                 3
941167 941167 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000807 6730505 Groton Dunstable Regional   Regular School No 3 09 12 2016   sped_beyond_grade_12 * * * *   *     *   *   2 1                       3                         2 1                 3
941246 941246 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire Regional High   Regular School No 3 07 12 2016   sped_beyond_grade_12 * * * *   *     *   *   2 1                       3                         2 1                 3
941290 941290 MA Dukes   school 2507380 700   Martha's Vineyard 250738001145 7000505 Martha's Vineyard Regional High   Regular School No 3 09 12 2016   sped_beyond_grade_12 * * * *   *     *   *   3 1                       4                         3 1                 4
941586 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
941674 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
941925 941925 MA Hampden   school 2509310 860   Pathfinder Regional Vocational Technical 250931002285 8600605 Pathfinder Vocational Technical   Vocational Education School No 3 09 12 2016   sped_beyond_grade_12 * * * *   *     *   *   2 1                       3                         2 1                 3
1365130 1365130 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No High 09 12 2020   sped_beyond_grade_12 5 1 0 0   0     0   1   6 1 *                     7.0 5 1 0 0   0     0   1   6 1                 7
1365970 1365970 MA Suffolk   school 2502790 35   Boston 250279001511 350548 Boston Adult Academy   Alternative School No High 11 12 2020   sped_beyond_grade_12 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1366009 1366009 MA Suffolk   school 2502790 35   Boston 250279002674 350655 Lyon Upper 9-12   Regular School No High 09 12 2020   sped_beyond_grade_12 * * * *   *     *   *   4 1 *                     5.0                         4 1                 5
1366847 1366847 MA Norfolk   school 2504050 73   Dedham 250405000548 730505 Dedham High   Regular School No High 09 12 2020   sped_beyond_grade_12 4 0 2 0   0     0   0   5 1 *                     6.0 4 0 2 0   0     0   0   5 1                 6
1366968 1366968 MA Hampshire   school 2504590 86   Easthampton 250459000612 860505 Easthampton High   Regular School No High 09 12 2020   sped_beyond_grade_12 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1367113 1367113 MA Bristol   school 2504800 94   Fairhaven 250480000642 940505 Fairhaven High   Regular School No High 09 12 2020   sped_beyond_grade_12 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1367243 1367243 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No High 09 12 2020   sped_beyond_grade_12 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1367285 1367285 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg High   Regular School No High 09 12 2020   sped_beyond_grade_12 * * * *   *     *   *   3 1 *                     4.0                         3 1                 4
1367766 1367766 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Middle High School   Regular School No High 06 12 2020   sped_beyond_grade_12 * * * *   *     *   *   3 1 *                     4.0                         3 1                 4
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
1368441 1368441 MA Hampden   school 2507050 161   Ludlow 250705001056 1610505 Ludlow Senior High   Regular School No High 09 12 2020   sped_beyond_grade_12 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1368751 1368751 MA Middlesex   school 2507320 170   Marlborough 250732001133 1700505 Marlborough High   Regular School No High 09 12 2020   sped_beyond_grade_12 6 0 4 0   0     0   0   9 1 *                     10.0 6 0 4 0   0     0   0   9 1                 10
1368937 1368937 MA Middlesex   school 2507620 178   Melrose 250762001193 1780505 Melrose High   Regular School No High 09 12 2020   sped_beyond_grade_12 * * * *   *     *   *   4 1 *                     5.0                         4 1                 5
1368982 1368982 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen High   Regular School No High 09 12 2020   sped_beyond_grade_12 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1369002 1369002 MA Plymouth   school 2507770 182   Middleborough 250777001227 1820505 Middleborough High   Regular School No High 09 12 2020   sped_beyond_grade_12 6 1 1 0   0     0   0   7 1 *                     8.0 6 1 1 0   0     0   0   7 1                 8
1369106 1369106 MA Hampden   school 2508040 191   Monson 250804001269 1910505 Monson High School   Regular School No High 07 12 2020   sped_beyond_grade_12 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1369554 1369554 MA Hampshire   school 2508850 210   Northampton 250885001432 2100505 Northampton High   Regular School No High 09 12 2020   sped_beyond_grade_12 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1369708 1369708 MA Middlesex   school 2508820 217   North Reading 250882001422 2170505 North Reading High   Regular School No High 09 12 2020   sped_beyond_grade_12 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1370366 1370366 MA Plymouth   school 2510170 251   Rockland 251017001643 2510505 Rockland Senior High   Regular School No High 09 12 2020   sped_beyond_grade_12 6 0 0 0   0     0   0   5 1 *                     6.0 6 0 0 0   0     0   0   5 1                 6
1370485 1370485 MA Essex   school 2510500 262   Saugus 251050001684 2620505 Saugus High   Regular School No High 09 12 2020   sped_beyond_grade_12 3 1 1 0   2     0   0   6 1 *                     7.0 3 1 1 0   2     0   0   6 1                 7
1371206 1371206 MA Worcester   school 2511400 290   Sutton 251140001414 2900510 Sutton High School   Regular School No High 09 12 2020   sped_beyond_grade_12 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1371251 1371251 MA Bristol   school 2511460 292   Swansea 251146001893 2920505 Joseph Case High   Regular School No High 09 12 2020   sped_beyond_grade_12 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1371572 1371572 MA Middlesex   school 2512180 314   Watertown 251218002005 3140505 Watertown High   Regular School No High 09 12 2020   sped_beyond_grade_12 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1373316 1373316 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000591 6580505 Shepherd Hill Regional High   Regular School No High 09 12 2020   sped_beyond_grade_12 * * * *   *     *   *   3 1 *                     4.0                         3 1                 4
1373356 1373356 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier Regional   Regular School No High 07 12 2020   sped_beyond_grade_12 7 0 0 0   0     0   0   6 1 *                     7.0 7 0 0 0   0     0   0   6 1                 7
1373398 1373398 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000807 6730505 Groton Dunstable Regional   Regular School No High 09 12 2020   sped_beyond_grade_12 * * * *   *     *   *   3 1 *                     4.0                         3 1                 4
1373471 1373471 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000824 6800505 Minnechaug Regional High   Regular School No High 09 12 2020   sped_beyond_grade_12 * * * *   *     *   *   3 1 *                     4.0                         3 1                 4
1373491 1373491 MA Norfolk   school 2506510 690   King Philip 250651000940 6900505 King Philip Regional High   Regular School No High 09 12 2020   sped_beyond_grade_12 6 0 0 0   0     0   0   5 1 *                     6.0 6 0 0 0   0     0   0   5 1                 6
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
1373624 1373624 MA Franklin   school 2507990 717   Mohawk Trail 250799001265 7170505 Mohawk Trail Regional School   Regular School No High 07 12 2020   sped_beyond_grade_12 * * * *   *     *   *   3 1 *                     4.0                         3 1                 4
1673153 1673153 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Boston - Community Academy   Regular School No High 09 12 2021   sped_beyond_grade_12 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1673158 1673158 MA Suffolk   school 2502790 35   Boston 250279002016 350522 Boston - Excel High School   Regular School No High 09 12 2021   sped_beyond_grade_12 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1673163 1673163 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Boston - Jeremiah E Burke High   Regular School No High 09 12 2021   sped_beyond_grade_12 4 4 1 0   0     0   0   8 1 *                     9.0 4 4 1 0   0     0   0   8 1                 9
1673241 1673241 MA Suffolk   school 2502790 35   Boston 250279001902 350581 Boston - Community Academy of Science and Health   Regular School No High 09 12 2021   sped_beyond_grade_12 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1673246 1673246 MA Suffolk   school 2502790 35   Boston 250279002674 350655 Boston - Lyon Upper 9-12   Regular School No High 09 12 2021   sped_beyond_grade_12 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1673288 1673288 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston - Horace Mann School for the Deaf   Special Education School No Other 01 12 2021   sped_beyond_grade_12 * * * *   *     *   *   4 1 *                     5.0                         4 1                 5
1673292 1673292 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston - Boston Collaborative High School   Alternative School No High 09 12 2021   sped_beyond_grade_12 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1674198 1674198 MA Hampshire   school 2504590 86   Easthampton 250459000612 860505 Easthampton - Easthampton High   Regular School No High 09 12 2021   sped_beyond_grade_12 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1674867 1674867 MA Plymouth   school 2505790 122   Hanover 250579000829 1220505 Hanover - Hanover High   Regular School No High 09 12 2021   sped_beyond_grade_12 * * * *   *     *   *   4 1 *                     5.0                         4 1                 5
1674996 1674996 MA Plymouth   school 2506090 131   Hingham 250609000872 1310505 Hingham - Hingham High   Regular School No High 09 12 2021   sped_beyond_grade_12 * * * *   *     *   *   3 1 *                     4.0                         3 1                 4
1675011 1675011 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook - Holbrook Middle High School   Regular School No High 06 12 2021   sped_beyond_grade_12 * * * *   *     *   *   4 1 *                     5.0                         4 1                 5
1675138 1675138 MA Middlesex   school 2506330 139   Hopkinton 250633000920 1390505 Hopkinton - Hopkinton High   Regular School No High 09 12 2021   sped_beyond_grade_12 5 1 0 0   1     0   0   6 1 *                     7.0 5 1 0 0   1     0   0   6 1                 7
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
1675960 1675960 MA Essex   school 2507260 168   Marblehead 250726001124 1680505 Marblehead - Marblehead High   Regular School No High 09 12 2021   sped_beyond_grade_12 * * * *   *     *   *   4 1 *                     5.0                         4 1                 5
1676077 1676077 MA Middlesex   school 2507500 174   Maynard 250750001153 1740505 Maynard - Maynard High   Regular School No High 09 12 2021   sped_beyond_grade_12 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1676130 1676130 MA Middlesex   school 2507560 176   Medford 250756001176 1760505 Medford - Medford High   Regular School No High 09 12 2021   sped_beyond_grade_12 4 2 0 0   0     0   1   6 1 *                     7.0 4 2 0 0   0     0   1   6 1                 7
1676186 1676186 MA Middlesex   school 2507620 178   Melrose 250762001193 1780505 Melrose - Melrose High   Regular School No High 09 12 2021   sped_beyond_grade_12 6 0 0 0   0     0   0   5 1 *                     6.0 6 0 0 0   0     0   0   5 1                 6
1676250 1676250 MA Plymouth   school 2507770 182   Middleborough 250777001227 1820505 Middleborough - Middleborough High   Regular School No High 09 12 2021   sped_beyond_grade_12 6 1 0 0   0     0   0   6 1 *                     7.0 6 1 0 0   0     0   0   6 1                 7
1676353 1676353 MA Hampden   school 2508040 191   Monson 250804001269 1910505 Monson - Monson High School   Regular School No High 07 12 2021   sped_beyond_grade_12 * * * *   *     *   *   3 1 *                     4.0                         3 1                 4
1676618 1676618 MA Essex   school 2508580 204   Newburyport 250858001354 2040505 Newburyport - Newburyport High   Regular School No High 09 12 2021   sped_beyond_grade_12 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1676974 1676974 MA Bristol   school 2509000 218   Norton 250900001451 2180505 Norton - Norton High   Regular School No High 09 12 2021   sped_beyond_grade_12 * * * *   *     *   *   3 1 *                     4.0                         3 1                 4
1677968 1677968 MA Middlesex   school 2510890 274   Somerville 251089002499 2740510 Somerville - Full Circle High School   Alternative School No High 09 12 2021   sped_beyond_grade_12 * * * *   *     *   *   3 1 *                     4.0                         3 1                 4
1678509 1678509 MA Bristol   school 2511460 292   Swansea 251146001893 2920505 Swansea - Joseph Case High   Regular School No High 09 12 2021   sped_beyond_grade_12 * * * *   *     *   *   3 1 *                     4.0                         3 1                 4
1678776 1678776 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware - Ware Junior/Senior High School   Regular School No High 07 12 2021   sped_beyond_grade_12 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1678913 1678913 MA Norfolk   school 2512270 317   Wellesley 251227002030 3170505 Wellesley - Wellesley Sr High   Regular School No High 09 12 2021   sped_beyond_grade_12 5 0 1 0   0     0   0   5 1 *                     6.0 5 0 1 0   0     0   0   5 1                 6
1679088 1679088 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport - Westport Junior/Senior High School   Regular School No High 07 12 2021   sped_beyond_grade_12 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1679329 1679329 MA Suffolk   school 2513170 346   Winthrop 251317002180 3460505 Winthrop - Winthrop High School   Regular School No High 09 12 2021   sped_beyond_grade_12 * * * *   *     *   *   4 1 *                     5.0                         4 1                 5
1680499 1680499 MA Middlesex   school 2503870 640   Concord-Carlisle 250387000527 6400505 Concord-Carlisle - Concord Carlisle High   Regular School No High 09 12 2021   sped_beyond_grade_12 * * * *   *     *   *   4 1 *                     5.0                         4 1                 5
1680581 1680581 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000591 6580505 Dudley-Charlton Reg - Shepherd Hill Regional High   Regular School No High 09 12 2021   sped_beyond_grade_12 * * * *   *     *   *   4 1 *                     5.0                         4 1                 5
1680643 1680643 MA Hampshire   school 2505160 672   Gateway 250516000758 6720505 Gateway - Gateway Regional High   Regular School No High 09 12 2021   sped_beyond_grade_12 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1680663 1680663 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000807 6730505 Groton-Dunstable - Groton Dunstable Regional   Regular School No High 09 12 2021   sped_beyond_grade_12 * * * *   *     *   *   4 1 *                     5.0                         4 1                 5
1681319 1681319 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman-Hanson - Whitman Hanson Regional   Regular School No High 09 12 2021   sped_beyond_grade_12 7 0 0 0   0     0   0   6 1 *                     7.0 7 0 0 0   0     0   0   6 1                 7
932809 932809 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No 3 09 12 2016   sped_beyond_grade_12 * * * *   *     *   *   1 2                       3                         1 2                 3
933692 933692 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No 3 09 12 2016   sped_beyond_grade_12 1 2 2 1   0     0   0   4 2                       6 1 2 2 1   0     0   0   4 2                 6
933701 933701 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Vocational Education School No 3 09 12 2016   sped_beyond_grade_12 1 13 1 0   3     0   0   16 2                       18 1 13 1 0   3     0   0   16 2                 18
933762 933762 MA Suffolk   school 2502790 35   Boston 250279001898 350579 Urban Science Academy   Regular School No 3 09 12 2016   sped_beyond_grade_12 1 6 0 0   1     0   0   6 2                       8 1 6 0 0   1     0   0   6 2                 8
933796 933796 MA Suffolk   school 2502790 35   Boston 250279002729 350658 West Roxbury Academy   Regular School No 3 09 12 2016   sped_beyond_grade_12 * * * *   *     *   *   1 2                       3                         1 2                 3

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