Data source: Big Local News · About: Big Local

4,038 rows where grade = "grade_6" and state = "MA" sorted by total

View and edit SQL

year

grade

  • grade_6 · 3,938
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
2040524 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Condon K-8   Regular School No Elementary PK 08 2019   grade_6 24 37 33 1   6     0   1   44 58                       102.0 24 37 33 1   6     0   1   44 58                 102
2041341 MA Middlesex   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No Elementary KG 08 2019   grade_6 59 4 9 0   22     0   8   52 50                       102.0 59 4 9 0   22     0   8   52 50                 102
2041537 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge Street Upper School   Regular School No Middle 06 08 2019   grade_6 49 19 14 1   10     0   9   58 44                       102.0 49 19 14 1   10     0   9   58 44                 102
2230063 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Boston: Clarence R Edwards Middle   Regular School No Middle 06 08 2018   grade_6 7 13 69 0   11     0   2   61 41                       102.0 7 13 69 0   11     0   2   61 41                 102
2230071 MA Suffolk   school 2502790 35   Boston 250279000258 350485 Boston: James P Timilty Middle   Regular School No Middle 06 08 2018   grade_6 0 31 67 0   2     0   2   43 59                       102.0 0 31 67 0   2     0   2   43 59                 102
2233398 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Malden: Linden   Regular School No Elementary KG 08 2018   grade_6 44 19 14 1   21     0   3   55 47                       102.0 44 19 14 1   21     0   3   55 47                 102
2233563 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Mashpee: Quashnet School   Regular School No Elementary 03 06 2018   grade_6 82 3 3 7   1     0   6   59 43                       102.0 82 3 3 7   1     0   6   59 43                 102
744824 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301781 7660305 Powder Mill   Regular School No 2 05 08 2015   grade_6 94 1 7 0   0     0   1   57 46                       103 94 1 7 0   0     0   1   57 46                 103
745172 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes 2 06 06 2015   grade_6 60 17 21 1   0     0   4   58 45                       103 60 17 21 1   0     0   4   58 45                 103
933100 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No 1 PK 08 2016   grade_6 15 18 62 0   3     1   4   52 51                       103 15 18 62 0   3     1   4   52 51                 103
1122711 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2017   grade_6 14 1 86 0   1     0   1   45 58                       103 14 1 86 0   1     0   1   45 58                 103
1126577 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No Elementary KG 08 2017   grade_6 43 15 20 1   21     0   3   52 51                       103 43 15 20 1   21     0   3   52 51                 103
1365409 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2020   grade_6 11 2 88 0   1     0   1   53 50 *                     103.0 11 2 88 0   1     0   1   53 50                 103
1366328 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No Elementary KG 08 2020   grade_6 58 3 11 0   19     0   12   47 56 *                     103.0 58 3 11 0   19     0   12   47 56                 103
1678242 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 Springfield - The Springfield Renaissance School an Expeditionary Learning School   Regular School No High 06 12 2021   grade_6 15 15 70 0   1     0   2   50 52 *                     103.0 15 15 70 0   1     0   2   50 52                 103
1678458 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton - Sutton Middle School   Regular School No Middle 06 08 2021   grade_6 93 2 2 0   3     0   3   52 51 *                     103.0 93 2 2 0   3     0   3   52 51                 103
1680301 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Regional - Hoosac Valley Middle School   Regular School No Middle 04 07 2021   grade_6 92 4 3 0   1     0   3   48 55 *                     103.0 92 4 3 0   1     0   3   48 55                 103
2043707 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2019   grade_6 31 12 17 0   40     0   3   55 48                       103.0 31 12 17 0   40     0   3   55 48                 103
2047383 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Quinsigamond   Regular School No Elementary PK 06 2019   grade_6 29 26 38 0   9     0   1   51 52                       103.0 29 26 38 0   9     0   1   51 52                 103
2048966 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2019   grade_6 84 2 10 1   2     0   4   52 51                       103.0 84 2 10 1   2     0   4   52 51                 103
2233368 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Malden: Beebe   Regular School No Elementary KG 08 2018   grade_6 28 17 12 0   44     1   1   56 47                       103.0 28 17 12 0   44     1   1   56 47                 103
2239981 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_6 64 11 21 0   2     0   5   55 48                       103.0 64 11 21 0   2     0   5   55 48                 103
933582 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No 1 PK 08 2016   grade_6 24 12 51 1   12     0   4   51 53                       104 24 12 51 1   12     0   4   51 53                 104
933632 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Lilla G. Frederick Middle School   Regular School No 2 06 08 2016   grade_6 4 47 39 0   11     0   3   60 44                       104 4 47 39 0   11     0   3   60 44                 104
1123001 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2017   grade_6 3 44 51 0   2     1   3   57 47                       104 3 44 51 0   2     1   3   57 47                 104
1131243 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes Other 05 12 2017   grade_6 85 2 6 0   6     0   5   60 44                       104 85 2 6 0   6     0   5   60 44                 104
1365481 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Condon K-8   Regular School No Elementary PK 08 2020   grade_6 12 33 40 0   13     1   5   46 58 *                     104.0 12 33 40 0   13     1   5   46 58                 104
1367524 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No Elementary 02 06 2020   grade_6 83 2 8 1   6     0   4   65 39 *                     104.0 83 2 8 1   6     0   4   65 39                 104
1370985 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No High 06 12 2020   grade_6 14 24 61 0   2     0   3   54 50 *                     104.0 14 24 61 0   2     0   3   54 50                 104
1372560 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2020   grade_6 77 4 10 0   6     0   7   48 56 *                     104.0 77 4 10 0   6     0   7   48 56                 104
1373037 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Middle School   Regular School No Middle 04 07 2020   grade_6 97 3 2 0   0     0   2   52 52 *                     104.0 97 3 2 0   0     0   2   52 52                 104
1374252 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Secondary 06 11 2020   grade_6 1 89 9 0   0     0   5   49 55 *                     104.0 1 89 9 0   0     0   5   49 55                 104
1672030 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet - Albert F Ford Middle School   Regular School No Middle 05 08 2021   grade_6 92 0 7 0   1     0   4   49 55 *                     104.0 92 0 7 0   1     0   4   49 55                 104
1673257 MA Suffolk   school 2502790 35   Boston 250279002725 350657 Boston - TechBoston Academy   Regular School No High 06 12 2021   grade_6 2 60 31 0   1     0   10   65 39 *                     104.0 2 60 31 0   1     0   10   65 39                 104
1675891 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Malden - Ferryway   Regular School No Elementary KG 08 2021   grade_6 25 21 39 0   15     0   4   45 59 *                     104.0 25 21 39 0   15     0   4   45 59                 104
1678252 MA Hampden   school 2511130 281   Springfield 251113002920 2810315 Springfield - Kiley Prep   Regular School No Middle 06 06 2021   grade_6 8 25 65 0   3     0   3   59 45 *                     104.0 8 25 65 0   3     0   3   59 45                 104
1680095 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston (District) - UP Academy Charter School of Boston   Regular School Yes Middle 06 08 2021   grade_6 2 52 44 1   4     1   0   55 49 *                     104.0 2 52 44 1   4     1   0   55 49                 104
2046060 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No High 06 12 2019   grade_6 20 21 63 0   0     0   0   44 60                       104.0 20 21 63 0   0     0   0   44 60                 104
2231354 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 Easthampton: White Brook Middle School   Regular School No Middle 05 08 2018   grade_6 86 0 10 0   6     0   2   46 58                       104.0 86 0 10 0   6     0   2   46 58                 104
2239303 MA Worcester   school 2508310 725   Nashoba 250831001868 7250310 Nashoba: Hale   Regular School No Middle 06 08 2018   grade_6 101 0 0 0   1     0   2   47 57                       104.0 101 0 0 0   1     0   2   47 57                 104
738947 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No 2 06 08 2015   grade_6 1 1 102 0   1     0   0   52 53                       105 1 1 102 0   1     0   0   52 53                 105
933963 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No 1 KG 08 2016   grade_6 15 73 13 2   0     0   2   52 53                       105 15 73 13 2   0     0   2   52 53                 105
935820 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No 2 06 08 2016   grade_6 5 1 99 0   0     0   0   52 53                       105 5 1 99 0   0     0   0   52 53                 105
939469 MA Plymouth   school 2512420 323   West Bridgewater 251242002036 3230305 Howard School   Regular School No 2 04 06 2016   grade_6 98 2 4 0   1     0   0   59 46                       105 98 2 4 0   1     0   0   59 46                 105
940817 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2016   grade_6 98 5 1 0   1     0   0   54 51                       105 98 5 1 0   1     0   0   54 51                 105
1124419 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No Middle 06 08 2017   grade_6 92 0 9 0   3     0   1   50 55                       105 92 0 9 0   3     0   1   50 55                 105
1133178 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_6 1 92 10 0   0     0   2   55 50                       105 1 92 10 0   0     0   2   55 50                 105
1370176 MA Norfolk   school 2509870 243   Quincy 250987001581 2430320 South West Middle School   Regular School No Middle 05 08 2020   grade_6 44 18 11 0   22     0   10   63 42 *                     105.0 44 18 11 0   22     0   10   63 42                 105
1672651 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Boston - Eliot Elementary   Regular School No Elementary PK 08 2021   grade_6 59 6 22 1   10     0   7   47 58 *                     105.0 59 6 22 1   10     0   7   47 58                 105
1676298 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis - Millis Middle   Regular School No Middle 06 08 2021   grade_6 93 0 6 0   1     0   5   50 55 *                     105.0 93 0 6 0   1     0   5   50 55                 105
1677424 MA Norfolk   school 2509870 243   Quincy 250987001581 2430320 Quincy - South West Middle School   Regular School No Middle 05 08 2021   grade_6 36 9 15 1   38     1   5   74 31 *                     105.0 36 9 15 1   38     1   5   74 31                 105
2039832 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2019   grade_6 94 0 5 0   1     0   5   57 48                       105.0 94 0 5 0   1     0   5   57 48                 105
2233862 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis: Millis Middle   Regular School No Middle 05 08 2018   grade_6 81 1 12 0   5     0   6   58 47                       105.0 81 1 12 0   5     0   6   58 47                 105
2239550 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Southwick-Tolland-Granville Regional School District: Powder Mill School   Regular School No Elementary 03 06 2018   grade_6 93 2 6 0   0     0   4   54 51                       105.0 93 2 6 0   0     0   4   54 51                 105
741983 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Accelerated Middle School (North)   Regular School No 2 06 08 2015   grade_6 3 10 91 0   1     0   1   68 38                       106 3 10 91 0   1     0   1   68 38                 106
744570 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No 2 05 08 2015   grade_6 95 1 5 0   0     0   5   55 51                       106 95 1 5 0   0     0   5   55 51                 106
937786 MA Norfolk   school 2509690 238   Plainville 250969001538 2380005 Beatrice H Wood Elementary   Regular School No 2 04 06 2016   grade_6 87 3 7 0   5     0   4   62 44                       106 87 3 7 0   5     0   4   62 44                 106
1366467 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge Street Upper School   Regular School No Middle 06 08 2020   grade_6 43 27 17 1   7     0   11   62 44 *                     106.0 43 27 17 1   7     0   11   62 44                 106
1367759 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Middle High School   Regular School No High 06 12 2020   grade_6 53 16 19 1   4     0   13   55 51 *                     106.0 53 16 19 1   4     0   13   55 51                 106
2040704 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2019   grade_6 3 52 49 0   1     1   0   50 56                       106.0 3 52 49 0   1     1   0   50 56                 106
2043352 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No Middle 06 08 2019   grade_6 92 1 2 0   7     0   4   50 56                       106.0 92 1 2 0   7     0   4   50 56                 106
2043734 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No Elementary KG 08 2019   grade_6 40 19 14 0   27     0   6   54 52                       106.0 40 19 14 0   27     0   6   54 52                 106
2047633 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2019   grade_6 75 2 6 1   13     0   9   53 53                       106.0 75 2 6 1   13     0   9   53 53                 106
2230310 MA Essex   school 2502880 38   Boxford 250288000358 380013 Boxford: Spofford Pond   Regular School No Elementary 03 06 2018   grade_6 98 0 3 0   4     0   1   42 64                       106.0 98 0 3 0   4     0   1   42 64                 106
2233812 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Middleton: Howe-Manning   Regular School No Elementary 03 06 2018   grade_6 92 1 2 0   6     0   5   55 51                       106.0 92 1 2 0   6     0   5   55 51                 106
740860 MA Plymouth   school 2509420 231   Pembroke 250942001508 2310003 Bryantville Elementary   Regular School No 1 KG 06 2015   grade_6 102 3 2 0   0     0   0   56 51                       107 102 3 2 0   0     0   0   56 51                 107
933241 MA Suffolk   school 2502790 35   Boston 250279000254 350146 James Condon Elementary   Regular School No 1 PK 06 2016   grade_6 25 35 32 0   6     1   8   49 58                       107 25 35 32 0   6     1   8   49 58                 107
1127045 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No Middle 05 08 2017   grade_6 93 1 10 0   0     0   3   54 53                       107 93 1 10 0   0     0   3   54 53                 107
1129330 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No Other 06 12 2017   grade_6 22 24 60 0   1     0   0   55 52                       107 22 24 60 0   1     0   0   55 52                 107
1366079 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No Elementary 03 06 2020   grade_6 90 1 3 0   6     0   7   56 51 *                     107.0 90 1 3 0   6     0   7   56 51                 107
1370169 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Broad Meadows Middle   Regular School No Middle 06 08 2020   grade_6 64 13 8 0   19     0   3   50 57 *                     107.0 64 13 8 0   19     0   3   50 57                 107
1371199 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton Middle School   Regular School No Middle 06 08 2020   grade_6 89 1 5 0   2     0   10   53 54 *                     107.0 89 1 5 0   2     0   10   53 54                 107
1373272 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No Middle 05 08 2020   grade_6 95 2 5 0   1     0   4   62 45 *                     107.0 95 2 5 0   1     0   4   62 45                 107
1673699 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge - Cambridge Street Upper School   Regular School No Middle 06 08 2021   grade_6 49 20 14 0   13     0   11   63 44 *                     107.0 49 20 14 0   13     0   11   63 44                 107
1680488 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Central Berkshire - Nessacus Regional Middle School   Regular School No Middle 06 08 2021   grade_6 90 0 5 0   1     0   11   63 44 *                     107.0 90 0 5 0   1     0   11   63 44                 107
1680964 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 North Middlesex - Hawthorne Brook   Regular School No Middle 05 08 2021   grade_6 95 2 5 0   2     0   3   51 56 *                     107.0 95 2 5 0   2     0   3   51 56                 107
1681256 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Wachusett - Central Tree Middle   Regular School No Middle 06 08 2021   grade_6 96 2 3 1   3     0   2   52 55 *                     107.0 96 2 3 1   3     0   2   52 55                 107
2043102 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2019   grade_6 1 0 106 0   0     0   0   57 50                       107.0 1 0 106 0   0     0   0   57 50                 107
2232319 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook: Holbrook Middle High School   Regular School No High 06 12 2018   grade_6 65 18 12 0   3     0   9   56 51                       107.0 65 18 12 0   3     0   9   56 51                 107
2234795 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer: Palmer High   Regular School No High 06 12 2018   grade_6 85 1 10 0   4     0   7   49 58                       107.0 85 1 10 0   4     0   7   49 58                 107
2239998 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton (District): New Heights Charter School of Brockton   Regular School Yes Middle 06 09 2018   grade_6 2 94 10 1   0     0   0   52 55                       107.0 2 94 10 1   0     0   0   52 55                 107
737883 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No 2 05 08 2015   grade_6 92 4 4 0   3     0   5   50 58                       108 92 4 4 0   3     0   5   50 58                 108
936040 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No 2 06 08 2016   grade_6 96 2 2 0   7     0   1   54 54                       108 96 2 2 0   7     0   1   54 54                 108
941394 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No 2 05 08 2016   grade_6 100 2 4 0   0     1   1   56 52                       108 100 2 4 0   0     1   1   56 52                 108
1123620 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2017   grade_6 19 66 12 0   0     1   10   47 61                       108 19 66 12 0   0     1   10   47 61                 108
1369010 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Howe-Manning   Regular School No Elementary 03 06 2020   grade_6 84 1 10 0   5     0   8   51 57 *                     108.0 84 1 10 0   5     0   8   51 57                 108
1371022 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Academy   Regular School No Middle 06 08 2020   grade_6 3 9 95 0   1     0   0   67 41 *                     108.0 3 9 95 0   1     0   0   67 41                 108
1371713 MA Plymouth   school 2512420 323   West Bridgewater 251242002036 3230305 Howard School   Regular School No Middle 04 06 2020   grade_6 85 7 2 1   1     1   11   50 58 *                     108.0 85 7 2 1   1     1   11   50 58                 108
1373086 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No Middle 05 08 2020   grade_6 93 0 11 0   1     0   3   63 45 *                     108.0 93 0 11 0   1     0   3   63 45                 108
1374064 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No Middle 05 08 2020   grade_6 97 2 4 0   1     0   4   53 55 *                     108.0 97 2 4 0   1     0   4   53 55                 108
1676204 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Methuen - Comprehensive Grammar School   Regular School No Elementary PK 08 2021   grade_6 44 7 49 0   1     0   7   54 54 *                     108.0 44 7 49 0   1     0   7   54 54                 108
1680541 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dighton-Rehoboth - Dorothy L Beckwith   Regular School No Middle 05 08 2021   grade_6 93 5 3 0   3     0   4   47 61 *                     108.0 93 5 3 0   3     0   4   47 61                 108
1681474 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School (District) - Argosy Collegiate Charter School   Regular School Yes Secondary 06 11 2021   grade_6 47 14 32 1   5     0   9   56 52 *                     108.0 47 14 32 1   5     0   9   56 52                 108
2230013 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Boston: Mildred Avenue K-8   Regular School No Elementary PK 08 2018   grade_6 2 72 27 2   0     0   5   54 54                       108.0 2 72 27 2   0     0   5   54 54                 108
2232952 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Longmeadow: Williams Middle   Regular School No Middle 06 08 2018   grade_6 87 1 7 0   10     0   3   49 59                       108.0 87 1 7 0   10     0   3   49 59                 108
2235001 MA Norfolk   school 2509690 238   Plainville 250969001538 2380005 Plainville: Beatrice H Wood Elementary   Regular School No Middle 04 06 2018   grade_6 91 2 9 1   5     0   0   51 57                       108.0 91 2 9 1   5     0   0   51 57                 108
736714 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No 1 PK 08 2015   grade_6 21 20 38 1   26     0   3   56 53                       109 21 20 38 1   26     0   3   56 53                 109
738933 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No 2 05 08 2015   grade_6 12 1 94 0   1     0   1   60 49                       109 12 1 94 0   1     0   1   60 49                 109
743752 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes 4 KG 12 2015   grade_6 65 14 3 0   23     0   4   56 53                       109 65 14 3 0   23     0   4   56 53                 109
933855 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No 1 03 06 2016   grade_6 100 1 1 0   5     0   2   55 54                       109 100 1 1 0   5     0   2   55 54                 109

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