enrollments

Data source: Big Local News · About: Big Local

3,459 rows where grade = "grade_8" and state = "MA" sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_8 · 3,459 ✖
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
1122006 1122006 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No Middle 05 08 2017   grade_8 * * * *   *     *   *   1 1                       *                         1 1                  
1123449 1123449 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   grade_8 * * * *   *     *   *   1 2                       *                         1 2                  
1123655 1123655 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Frederick Douglass Academy   Regular School No High 07 12 2017   grade_8 * * * *   *     *   *   3 1                       *                         3 1                  
1125194 1125194 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_8 * * * *   *     *   *   * *                       *                                              
1125268 1125268 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_8 * * * *   *     *   *   * *                       *                                              
1125426 1125426 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_8 * * * *   *     *   *   2 3                       *                         2 3                  
1128684 1128684 MA Essex   school 2510380 258   Salem 251038002774 2580515 Salem Prep High School   Regular School No High 08 12 2017   grade_8 * * * *   *     *   *   2 *                       *                         2                    
1368465 1368465 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
1374315 1374315 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
1674758 1674758 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
1675706 1675706 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
2230211 2230211 MA Suffolk   school   35   Boston   350652               2018   grade_8 * * * *   *     *   *   * *                       0.0                                             0
2231645 2231645 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   grade_8 * * * *   *     *   *   * *                       0.0                                             0
2237229 2237229 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_8 * * * *   *     *   *   * *                       0.0                                             0
937587 937587 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Project C.O.F.F.E.E.   Special Education School No 4 05 12 2016   grade_8 * * * *   *     *   *   1 *                       1                         1                   1
939287 939287 MA Plymouth   school 2512060 310   Wareham 251206002668 3100310 West Academy   Regular School No N N N 2016   grade_8 * * * *   *     *   *   * *                       1                                             1
1680452 1680452 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Bridgewater-Raynham - Therapeutic Day School   Special Education School No High 07 12 2021   grade_8 * * * *   *     *   *   1 * *                     1.0                         1                   1
2232023 2232023 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_8 * * * *   *     *   *   * *                       1.0                                             1
2234771 2234771 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Oxford: Project C.O.F.F.E.E.   Special Education School No High 08 12 2018   grade_8 * * * *   *     *   *   1 *                       1.0                         1                   1
741044 741044 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No 1 PK 08 2015   grade_8 5 2 1 0   1     0   1   4 6                       10 5 2 1 0   1     0   1   4 6                 10
741277 741277 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No 1 PK 08 2015   grade_8 8 0 0 0   2     0   0   5 5                       10 8 0 0 0   2     0   0   5 5                 10
1370707 1370707 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 06 08 2020   grade_8 0 2 7 0   1     0   0   8 * *                     10.0 0 2 7 0   1     0   0   8                   10
1674432 1674432 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River - Stone PK-12 School   Regular School No Other 01 12 2021   grade_8 4 2 3 0   0     0   1   8 2 *                     10.0 4 2 3 0   0     0   1   8 2                 10
1675615 1675615 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell - Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2021   grade_8 4 0 6 0   0     0   0   9 * *                     10.0 4 0 6 0   0     0   0   9                   10
1675843 1675843 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Lynn - Fecteau-Leary Junior/Senior High School   Regular School No High 06 12 2021   grade_8 3 0 4 1   0     0   2   8 2 *                     10.0 3 0 4 1   0     0   2   8 2                 10
1676593 1676593 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 New Bedford - Trinity Day Academy   Regular School No Other 04 12 2021   grade_8 2 2 5 0   0     0   1   6 4 *                     10.0 2 2 5 0   0     0   1   6 4                 10
1677347 1677347 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown - Provincetown Schools   Regular School No Elementary PK 08 2021   grade_8 3 5 2 0   0     0   0   3 7 *                     10.0 3 5 2 0   0     0   0   3 7                 10
1678285 1678285 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Springfield - Balliet Middle School   Regular School No Middle 06 08 2021   grade_8 0 4 6 0   0     0   0   8 * *                     10.0 0 4 6 0   0     0   0   8                   10
2232220 2232220 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill: Haverhill Alternative School   Regular School No High 06 12 2018   grade_8 6 1 3 0   0     0   0   7 3                       10.0 6 1 3 0   0     0   0   7 3                 10
2232701 2232701 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence: School for Exceptional Studies   Regular School No Other 01 12 2018   grade_8 1 1 8 0   0     0   0   9 1                       10.0 1 1 8 0   0     0   0   9 1                 10
2235101 2235101 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown: Provincetown Schools   Regular School No Elementary PK 08 2018   grade_8 5 2 3 0   0     0   0   3 7                       10.0 5 2 3 0   0     0   0   3 7                 10
738732 738732 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No 2 04 08 2015   grade_8 8 4 85 0   2     0   1   52 48                       100 8 4 85 0   2     0   1   52 48                 100
743524 743524 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2015   grade_8 86 5 2 0   3     0   4   47 53                       100 86 5 2 0   3     0   4   47 53                 100
743874 743874 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 09 2015   grade_8 86 3 5 0   3     0   3   44 56                       100 86 3 5 0   3     0   3   44 56                 100
932942 932942 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No 2 05 08 2016   grade_8 93 2 4 0   0     0   1   49 51                       100 93 2 4 0   0     0   1   49 51                 100
940345 940345 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2016   grade_8 82 3 4 1   6     0   4   47 53                       100 82 3 4 1   6     0   4   47 53                 100
1131245 1131245 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes Other 05 12 2017   grade_8 77 4 6 0   10     0   3   51 49                       100 77 4 6 0   10     0   3   51 49                 100
1131588 1131588 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2017   grade_8 8 57 24 0   11     0   0   52 48                       100 8 57 24 0   11     0   0   52 48                 100
1372583 1372583 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes High 05 12 2020   grade_8 68 3 12 0   6     0   11   43 56 *                     100.0 68 3 12 0   6     0   11   43 56                 100
1679846 1679846 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter (District) - Innovation Academy Charter School   Regular School Yes High 05 12 2021   grade_8 76 3 7 0   13     0   1   54 46 *                     100.0 76 3 7 0   13     0   1   54 46                 100
1680387 1680387 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Berkshire Hills - W.E.B. Du Bois Regional Middle School   Regular School No Middle 05 08 2021   grade_8 79 3 11 0   2     0   5   60 40 *                     100.0 79 3 11 0   2     0   5   60 40                 100
2043354 2043354 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No Middle 06 08 2019   grade_8 85 1 4 0   7     0   3   60 40                       100.0 85 1 4 0   7     0   3   60 40                 100
2047655 2047655 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes High 05 12 2019   grade_8 81 3 6 0   5     0   5   57 43                       100.0 81 3 6 0   5     0   5   57 43                 100
2231490 2231490 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Everett: Lafayette School   Regular School No Elementary KG 08 2018   grade_8 32 23 37 0   6     0   2   49 51                       100.0 32 23 37 0   6     0   2   49 51                 100
2238076 2238076 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter (District): Innovation Academy Charter School   Regular School Yes High 05 12 2018   grade_8 84 4 1 0   9     0   2   48 52                       100.0 84 4 1 0   9     0   2   48 52                 100
738949 738949 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No 2 06 08 2015   grade_8 2 0 97 1   0     0   1   54 47                       101 2 0 97 1   0     0   1   54 47                 101
739985 739985 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No 2 05 08 2015   grade_8 95 2 2 1   1     0   0   42 59                       101 95 2 2 1   1     0   0   42 59                 101
741950 741950 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No 4 06 12 2015   grade_8 31 27 34 0   2     0   7   52 49                       101 31 27 34 0   2     0   7   52 49                 101
934834 934834 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No 1 KG 08 2016   grade_8 39 12 41 0   7     0   2   54 47                       101 39 12 41 0   7     0   2   54 47                 101
936422 936422 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No 1 KG 08 2016   grade_8 26 15 29 0   24     0   7   54 47                       101 26 15 29 0   24     0   7   54 47                 101
939271 939271 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware Junior/Senior High School   Regular School No 3 07 12 2016   grade_8 86 2 8 0   2     0   3   45 56                       101 86 2 8 0   2     0   3   45 56                 101
1124653 1124653 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No Elementary KG 08 2017   grade_8 34 14 39 0   11     0   3   53 48                       101 34 14 39 0   11     0   3   53 48                 101
1129375 1129375 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Accelerated Middle School (North)   Regular School No Middle 06 08 2017   grade_8 4 6 89 1   1     0   0   63 38                       101 4 6 89 1   1     0   0   63 38                 101
1129379 1129379 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Chestnut Accelerated Middle School (South)   Regular School No Middle 06 08 2017   grade_8 1 11 89 0   0     0   0   54 47                       101 1 11 89 0   0     0   0   54 47                 101
1365411 1365411 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2020   grade_8 9 2 89 0   0     0   1   46 55 *                     101.0 9 2 89 0   0     0   1   46 55                 101
1367053 1367053 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No Elementary KG 08 2020   grade_8 37 9 43 2   6     1   3   54 47 *                     101.0 37 9 43 2   6     1   3   54 47                 101
1674094 1674094 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas - Douglas Middle School   Regular School No Middle 06 08 2021   grade_8 94 1 3 0   1     0   2   47 54 *                     101.0 94 1 3 0   1     0   2   47 54                 101
1679266 1679266 MA Worcester   school 2513080 343   Winchendon 251308002796 3430315 Winchendon - Murdock Middle School   Regular School No Middle 06 08 2021   grade_8 83 5 6 0   4     1   2   53 48 *                     101.0 83 5 6 0   4     1   2   53 48                 101
2232456 2232456 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale: Hopedale Jr Sr High   Regular School No High 07 12 2018   grade_8 94 1 5 0   0     0   1   50 51                       101.0 94 1 5 0   0     0   1   50 51                 101
743419 743419 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes 2 05 08 2015   grade_8 15 9 71 0   6     0   1   52 50                       102 15 9 71 0   6     0   1   52 50                 102
1129964 1129964 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware Junior/Senior High School   Regular School No High 07 12 2017   grade_8 81 4 12 0   0     1   4   59 43                       102 81 4 12 0   0     1   4   59 43                 102
1370178 1370178 MA Norfolk   school 2509870 243   Quincy 250987001581 2430320 South West Middle School   Regular School No Middle 05 08 2020   grade_8 42 11 16 0   25     1   7   57 45 *                     102.0 42 11 16 0   25     1   7   57 45                 102
1372379 1372379 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No High 07 12 2020   grade_8 7 15 71 0   7     0   2   50 52 *                     102.0 7 15 71 0   7     0   2   50 52                 102
2041249 2041249 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2019   grade_8 12 64 15 0   0     1   10   44 58                       102.0 12 64 15 0   0     1   10   44 58                 102
2042034 2042034 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No Middle 05 08 2019   grade_8 81 2 14 0   3     0   2   59 43                       102.0 81 2 14 0   3     0   2   59 43                 102
2042150 2042150 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No Elementary KG 08 2019   grade_8 30 19 47 1   3     0   2   44 58                       102.0 30 19 47 1   3     0   2   44 58                 102
2042842 2042842 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Middle High School   Regular School No High 06 12 2019   grade_8 51 24 14 0   4     0   9   49 53                       102.0 51 24 14 0   4     0   9   49 53                 102
2048197 2048197 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No Middle 05 08 2019   grade_8 87 0 9 0   4     0   2   51 51                       102.0 87 0 9 0   4     0   2   51 51                 102
2048769 2048769 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No Middle 05 08 2019   grade_8 99 0 1 0   0     0   2   45 57                       102.0 99 0 1 0   0     0   2   45 57                 102
2231723 2231723 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Fitchburg: Arthur M Longsjo Middle School   Regular School No Middle 05 08 2018   grade_8 37 5 48 0   6     0   6   56 46                       102.0 37 5 48 0   6     0   6   56 46                 102
2239983 2239983 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   grade_8 76 4 14 1   2     1   4   53 49                       102.0 76 4 14 1   2     1   4   53 49                 102
738549 738549 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2015   grade_8 83 4 3 0   12     0   1   56 47                       103 83 4 3 0   12     0   1   56 47                 103
1125356 1125356 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No Other 06 12 2017   grade_8 83 3 2 0   11     0   4   57 46                       103 83 3 2 0   11     0   4   57 46                 103
1125831 1125831 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2017   grade_8 1 1 100 0   1     0   0   49 54                       103 1 1 100 0   1     0   0   49 54                 103
1126559 1126559 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2017   grade_8 29 20 22 1   26     0   5   70 33                       103 29 20 22 1   26     0   5   70 33                 103
1127589 1127589 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No High 08 12 2017   grade_8 84 2 5 0   0     1   11   55 48                       103 84 2 5 0   0     1   11   55 48                 103
1132377 1132377 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No High 07 12 2017   grade_8 83 3 7 0   2     0   8   51 52                       103 83 3 7 0   2     0   8   51 52                 103
1133165 1133165 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Middle 06 08 2017   grade_8 65 17 16 0   1     0   4   57 46                       103 65 17 16 0   1     0   4   57 46                 103
1369052 1369052 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No Middle 06 08 2020   grade_8 77 2 13 0   5     0   6   56 47 *                     103.0 77 2 13 0   5     0   6   56 47                 103
1678302 1678302 MA Hampden   school 2511130 281   Springfield 251113002859 2810480 Springfield - Rise Academy at Van Sickle   Regular School No Middle 06 08 2021   grade_8 7 20 72 0   0     0   4   59 44 *                     103.0 7 20 72 0   0     0   4   59 44                 103
2044588 2044588 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No High 07 12 2019   grade_8 87 4 5 0   0     0   7   53 50                       103.0 87 4 5 0   0     0   7   53 50                 103
2049311 2049311 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Middle 06 10 2019   grade_8 70 8 17 1   2     0   5   54 49                       103.0 70 8 17 1   2     0   5   54 49                 103
2236151 2236151 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 Springfield: The Springfield Renaissance School an Expeditionary Learning School   Regular School No High 06 12 2018   grade_8 24 26 52 0   1     0   0   54 49                       103.0 24 26 52 0   1     0   0   54 49                 103
744076 744076 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No 2 05 08 2015   grade_8 94 3 3 0   0     0   4   52 52                       104 94 3 3 0   0     0   4   52 52                 104
1124682 1124682 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2017   grade_8 17 30 52 0   3     0   2   48 56                       104 17 30 52 0   3     0   2   48 56                 104
1131858 1131858 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No Middle 05 08 2017   grade_8 87 2 7 0   3     2   3   52 52                       104 87 2 7 0   3     2   3   52 52                 104
1133180 1133180 MA Plymouth   school 2500559 3513   New Heights Charter of Brockton 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Middle 06 08 2017   grade_8 2 88 8 0   4     0   2   51 53                       104 2 88 8 0   4     0   2   51 53                 104
1365892 1365892 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No Middle 06 08 2020   grade_8 7 17 62 0   14     0   4   60 44 *                     104.0 7 17 62 0   14     0   4   60 44                 104
1368045 1368045 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No Middle 06 08 2020   grade_8 0 1 102 0   1     0   0   60 44 *                     104.0 0 1 102 0   1     0   0   60 44                 104
1368643 1368643 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2020   grade_8 27 19 15 0   41     1   1   58 46 *                     104.0 27 19 15 0   41     1   1   58 46                 104
2040454 2040454 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2019   grade_8 11 2 89 0   1     0   1   55 49                       104.0 11 2 89 0   1     0   1   55 49                 104
2233864 2233864 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis: Millis Middle   Regular School No Middle 05 08 2018   grade_8 89 5 6 0   3     0   1   57 47                       104.0 89 5 6 0   3     0   1   57 47                 104
741979 741979 MA Hampden   school 2511130 281   Springfield 251113002733 2810355 South End Middle School   Regular School No 2 06 08 2015   grade_8 3 14 86 0   1     0   1   60 45                       105 3 14 86 0   1     0   1   60 45                 105
744600 744600 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No 1 PK 08 2015   grade_8 94 1 3 0   3     0   4   37 68                       105 94 1 3 0   3     0   4   37 68                 105
933965 933965 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No 1 KG 08 2016   grade_8 17 58 23 2   0     0   5   49 56                       105 17 58 23 2   0     0   5   49 56                 105
1127130 1127130 MA Nantucket   school 2508250 197   Nantucket 250825001281 1970010 Cyrus Peirce   Regular School No Middle 06 08 2017   grade_8 65 15 19 0   2     1   3   56 49                       105 65 15 19 0   2     1   3   56 49                 105
1130196 1130196 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No High 07 12 2017   grade_8 92 2 5 0   2     0   4   46 59                       105 92 2 5 0   2     0   4   46 59                 105
1131208 1131208 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 09 2017   grade_8 7 57 35 1   2     0   3   49 56                       105 7 57 35 1   2     0   3   49 56                 105
1370987 1370987 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No High 06 12 2020   grade_8 17 23 59 0   2     0   4   63 42 *                     105.0 17 23 59 0   2     0   4   63 42                 105
1672758 1672758 MA Suffolk   school 2502790 35   Boston 250279000269 350179 Boston - John W McCormack   Regular School No Middle 06 08 2021   grade_8 5 35 60 0   3     0   2   42 63 *                     105.0 5 35 60 0   3     0   2   42 63                 105

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