enrollments

Data source: Big Local News · About: Big Local

500 rows where grade = "grade_7", state = "MA" and year = 2020 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 500 ✖

grade ✖

  • grade_7 · 500 ✖
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
1368464 1368464 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_7 * * * *   *     *   *   * * *                     0.0                                             0
1374314 1374314 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_7 * * * *   *     *   *   * * *                     0.0                                             0
1373189 1373189 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No High 07 12 2020   grade_7 * * * *   *     *   *   1 * *                     1.0                         1                   1
1370098 1370098 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2020   grade_7 3 5 2 0   0     0   0   3 7 *                     10.0 3 5 2 0   0     0   0   3 7                 10
1371020 1371020 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Balliet Middle School   Regular School No Middle 06 08 2020   grade_7 0 4 6 0   0     0   0   9 1 *                     10.0 0 4 6 0   0     0   0   9 1                 10
1366477 1366477 MA Middlesex   school 2503270 49   Cambridge 250327002756 490320 Vassal Lane Upper School   Regular School No Middle 06 08 2020   grade_7 44 27 3 0   18     0   8   51 48 *                     100.0 44 27 3 0   18     0   8   51 48                 100
1372005 1372005 MA Worcester   school 2513080 343   Winchendon 251308002796 3430315 Murdock Middle School   Regular School No Middle 06 08 2020   grade_7 83 3 6 0   5     1   3   51 50 *                     101.0 83 3 6 0   5     1   3   51 50                 101
1372582 1372582 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes High 05 12 2020   grade_7 75 4 7 0   14     0   1   54 47 *                     101.0 75 4 7 0   14     0   1   54 47                 101
1365897 1365897 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No Middle 06 08 2020   grade_7 1 43 58 0   2     0   0   55 49 *                     104.0 1 43 58 0   2     0   0   55 49                 104
1365410 1365410 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2020   grade_7 6 1 97 0   1     0   0   55 50 *                     105.0 6 1 97 0   1     0   0   55 50                 105
1366864 1366864 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No Middle 06 08 2020   grade_7 96 1 4 0   2     0   2   47 58 *                     105.0 96 1 4 0   2     0   2   47 58                 105
1371029 1371029 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No Middle 06 08 2020   grade_7 12 22 65 0   5     0   2   50 56 *                     106.0 12 22 65 0   5     0   2   50 56                 106
1371039 1371039 MA Hampden   school 2511130 281   Springfield 251113002859 2810480 Rise Academy at Van Sickle   Regular School No Middle 06 08 2020   grade_7 6 19 77 0   0     0   4   63 43 *                     106.0 6 19 77 0   0     0   4   63 43                 106
1371714 1371714 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No High 07 12 2020   grade_7 91 6 5 0   1     0   4   47 60 *                     107.0 91 6 5 0   1     0   4   47 60                 107
1374253 1374253 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_7 4 98 4 0   0     0   1   47 60 *                     107.0 4 98 4 0   0     0   1   47 60                 107
1368259 1368259 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Glenbrook Middle   Regular School No Middle 06 08 2020   grade_7 78 3 7 0   16     1   3   53 55 *                     108.0 78 3 7 0   16     1   3   53 55                 108
1368019 1368019 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2020   grade_7 2 0 106 0   0     0   1   58 51 *                     109.0 2 0 106 0   0     0   1   58 51                 109
1372378 1372378 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No High 07 12 2020   grade_7 8 12 74 1   10     0   4   54 55 *                     109.0 8 12 74 1   10     0   4   54 55                 109
1367198 1367198 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2020   grade_7 2 2 5 0   0     0   2   9 2 *                     11.0 2 2 5 0   0     0   2   9 2                 11
1372919 1372919 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2020   grade_7 83 3 17 0   0     0   7   48 62 *                     110.0 83 3 17 0   0     0   7   48 62                 110
1365529 1365529 MA Suffolk   school 2502790 35   Boston 250279000269 350179 John W McCormack   Regular School No Middle 06 08 2020   grade_7 8 36 61 1   3     0   2   48 63 *                     111.0 8 36 61 1   3     0   2   48 63                 111
1366962 1366962 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No Middle 05 08 2020   grade_7 85 1 17 1   6     0   1   53 58 *                     111.0 85 1 17 1   6     0   1   53 58                 111
1368092 1368092 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No Middle 05 08 2020   grade_7 83 7 13 0   3     0   5   62 49 *                     111.0 83 7 13 0   3     0   5   62 49                 111
1364807 1364807 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2020   grade_7 99 0 6 0   1     0   6   62 50 *                     112.0 99 0 6 0   1     0   6   62 50                 112
1368269 1368269 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No Middle 06 08 2020   grade_7 94 1 3 0   7     0   7   57 55 *                     112.0 94 1 3 0   7     0   7   57 55                 112
1373894 1373894 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2020   grade_7 90 3 12 1   1     0   5   55 57 *                     112.0 90 3 12 1   1     0   5   55 57                 112
1371518 1371518 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware Junior/Senior High School   Regular School No High 07 12 2020   grade_7 100 3 6 0   0     0   4   56 57 *                     113.0 100 3 6 0   0     0   4   56 57                 113
1373087 1373087 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No Middle 05 08 2020   grade_7 93 0 12 1   3     0   4   66 47 *                     113.0 93 0 12 1   3     0   4   66 47                 113
1368289 1368289 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Rogers STEM Academy   Regular School No Elementary KG 08 2020   grade_7 18 19 50 0   24     0   4   57 58 *                     115.0 18 19 50 0   24     0   4   57 58                 115
1372666 1372666 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2020   grade_7 21 61 32 0   1     0   0   56 59 *                     115.0 21 61 32 0   1     0   0   56 59                 115
1366021 1366021 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No High 06 12 2020   grade_7 7 67 35 0   2     0   5   58 58 *                     116.0 7 67 35 0   2     0   5   58 58                 116
1366714 1366714 MA Norfolk   school 2503780 65   Cohasset 250378002910 650305 Cohasset Middle School   Regular School No Middle 06 08 2020   grade_7 108 3 0 0   1     0   4   70 46 *                     116.0 108 3 0 0   1     0   4   70 46                 116
1370170 1370170 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Broad Meadows Middle   Regular School No Middle 06 08 2020   grade_7 75 13 8 0   20     0   1   57 60 *                     117.0 75 13 8 0   20     0   1   57 60                 117
1367568 1367568 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No Middle 05 07 2020   grade_7 88 2 21 0   2     0   5   59 59 *                     118.0 88 2 21 0   2     0   5   59 59                 118
1374065 1374065 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No Middle 05 08 2020   grade_7 106 1 6 1   3     0   1   59 59 *                     118.0 106 1 6 1   3     0   1   59 59                 118
1367086 1367086 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2020   grade_7 15 19 78 0   4     0   3   53 66 *                     119.0 15 19 78 0   4     0   3   53 66                 119
1371361 1371361 MA Middlesex   school 2511760 301   Tyngsborough 251176001715 3010305 Tyngsborough Middle   Regular School No Middle 06 08 2020   grade_7 95 7 11 0   6     0   1   67 53 *                     120.0 95 7 11 0   6     0   1   67 53                 120
1373873 1373873 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2020   grade_7 112 1 4 0   1     0   2   57 63 *                     120.0 112 1 4 0   1     0   2   57 63                 120
1374235 1374235 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Secondary 06 11 2020   grade_7 73 11 26 0   3     0   7   62 58 *                     120.0 73 11 26 0   3     0   7   62 58                 120
1373472 1373472 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire Regional High   Regular School No High 07 12 2020   grade_7 105 1 11 0   1     0   3   63 58 *                     121.0 105 1 11 0   1     0   3   63 58                 121
1367430 1367430 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No Middle 06 08 2020   grade_7 105 2 10 1   4     0   0   68 54 *                     122.0 105 2 10 1   4     0   0   68 54                 122
1368240 1368240 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No Middle 06 08 2020   grade_7 103 1 7 0   7     0   4   63 59 *                     122.0 103 1 7 0   7     0   4   63 59                 122
1368651 1368651 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2020   grade_7 29 24 43 0   17     0   9   61 61 *                     122.0 29 24 43 0   17     0   9   61 61                 122
1369836 1369836 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer High   Regular School No High 06 12 2020   grade_7 96 4 12 0   3     0   7   49 73 *                     122.0 96 4 12 0   3     0   7   49 73                 122
1371200 1371200 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton Middle School   Regular School No Middle 06 08 2020   grade_7 111 1 3 0   1     0   6   59 63 *                     122.0 111 1 3 0   1     0   6   59 63                 122
1373350 1373350 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier Regional   Regular School No High 07 12 2020   grade_7 103 2 9 0   2     0   6   68 54 *                     122.0 103 2 9 0   2     0   6   68 54                 122
1373639 1373639 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No Middle 06 08 2020   grade_7 106 2 9 0   0     1   4   65 57 *                     122.0 106 2 9 0   0     1   4   65 57                 122
1366529 1366529 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No High 06 12 2020   grade_7 116 0 5 1   0     1   0   69 54 *                     123.0 116 0 5 1   0     1   0   69 54                 123
1368002 1368002 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2020   grade_7 5 2 114 0   0     0   2   61 62 *                     123.0 5 2 114 0   0     0   2   61 62                 123
1371829 1371829 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport Junior/Senior High School   Regular School No High 07 12 2020   grade_7 108 1 5 0   1     0   8   77 46 *                     123.0 108 1 5 0   1     0   8   77 46                 123
1368450 1368450 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg Middle School   Regular School No Middle 06 08 2020   grade_7 102 2 16 0   0     1   3   64 60 *                     124.0 102 2 16 0   0     1   3   64 60                 124
1369120 1369120 MA Nantucket   school 2508250 197   Nantucket 250825001281 1970010 Cyrus Peirce   Regular School No Middle 06 08 2020   grade_7 62 11 44 0   3     0   4   64 60 *                     124.0 62 11 44 0   3     0   4   64 60                 124
1372554 1372554 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2020   grade_7 9 19 84 0   8     0   4   66 58 *                     124.0 9 19 84 0   8     0   4   66 58                 124
1369514 1369514 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No High 07 12 2020   grade_7 103 2 8 0   1     1   10   60 65 *                     125.0 103 2 8 0   1     1   10   60 65                 125
1372561 1372561 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_7 87 2 7 1   19     0   9   66 59 *                     125.0 87 2 7 1   19     0   9   66 59                 125
1367433 1367433 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No Middle 06 08 2020   grade_7 104 5 6 0   10     0   1   69 57 *                     126.0 104 5 6 0   10     0   1   69 57                 126
1371448 1371448 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Bird Middle   Regular School No Middle 06 08 2020   grade_7 100 7 11 0   5     0   3   61 65 *                     126.0 100 7 11 0   5     0   3   61 65                 126
1373306 1373306 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley Middle School   Regular School No Middle 05 08 2020   grade_7 113 2 8 1   1     0   1   62 64 *                     126.0 113 2 8 1   1     0   1   62 64                 126
1373826 1373826 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar Regional   Regular School No High 07 12 2020   grade_7 107 1 10 0   2     0   6   75 51 *                     126.0 107 1 10 0   2     0   6   75 51                 126
1367947 1367947 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich Middle School   Regular School No Middle 06 08 2020   grade_7 113 0 10 0   3     0   1   61 66 *                     127.0 113 0 10 0   3     0   1   61 66                 127
1368679 1368679 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Salemwood   Regular School No Elementary KG 08 2020   grade_7 24 30 43 0   25     0   5   54 73 *                     127.0 24 30 43 0   25     0   5   54 73                 127
1374009 1374009 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No Middle 06 08 2020   grade_7 112 2 6 0   4     0   3   65 62 *                     127.0 112 2 6 0   4     0   3   65 62                 127
1370258 1370258 MA Middlesex   school 2509990 246   Reading 250999001605 2460305 Arthur W Coolidge Middle   Regular School No Middle 06 08 2020   grade_7 119 2 3 0   1     0   3   71 57 *                     128.0 119 2 3 0   1     0   3   71 57                 128
1373226 1373226 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No Middle 06 08 2020   grade_7 115 1 7 0   0     0   5   74 54 *                     128.0 115 1 7 0   0     0   5   74 54                 128
1373513 1373513 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional Middle School   Regular School No Middle 06 08 2020   grade_7 124 0 0 0   2     0   2   60 68 *                     128.0 124 0 0 0   2     0   2   60 68                 128
1365891 1365891 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No Middle 06 08 2020   grade_7 15 21 91 0   2     0   0   66 63 *                     129.0 15 21 91 0   2     0   0   66 63                 129
1366181 1366181 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2020   grade_7 16 84 19 1   2     0   7   65 64 *                     129.0 16 84 19 1   2     0   7   65 64                 129
1366592 1366592 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2020   grade_7 7 8 112 0   0     0   2   58 71 *                     129.0 7 8 112 0   0     0   2   58 71                 129
1367061 1367061 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No Elementary KG 08 2020   grade_7 32 21 66 0   7     0   4   65 65 *                     130.0 32 21 66 0   7     0   4   65 65                 130
1368956 1368956 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No Elementary PK 08 2020   grade_7 59 1 61 0   4     0   5   54 76 *                     130.0 59 1 61 0   4     0   5   54 76                 130
1372640 1372640 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2020   grade_7 23 32 60 0   7     0   9   66 65 *                     131.0 23 32 60 0   7     0   9   66 65                 131
1365030 1365030 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No Middle 05 08 2020   grade_7 84 10 20 0   11     0   7   62 70 *                     132.0 84 10 20 0   11     0   7   62 70                 132
1371023 1371023 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Academy   Regular School No Middle 06 08 2020   grade_7 5 11 115 0   1     0   0   73 59 *                     132.0 5 11 115 0   1     0   0   73 59                 132
1364923 1364923 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2020   grade_7 61 3 13 1   53     0   2   73 60 *                     133.0 61 3 13 1   53     0   2   73 60                 133
1370733 1370733 MA Worcester   school 2510980 276   Southborough 251098001221 2760305 P Brent Trottier   Regular School No Middle 06 08 2020   grade_7 99 1 10 0   17     0   7   68 66 *                     134.0 99 1 10 0   17     0   7   68 66                 134
1371375 1371375 MA Worcester   school 2511850 304   Uxbridge 251185002892 3040405 Whitin Intermediate   Regular School No Middle 04 07 2020   grade_7 118 1 8 4   2     0   1   66 68 *                     134.0 118 1 8 4   2     0   1   66 68                 134
1373708 1373708 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No Middle 05 08 2020   grade_7 125 2 1 0   4     0   3   75 60 *                     135.0 125 2 1 0   4     0   3   75 60                 135
1368053 1368053 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2020   grade_7 14 3 109 0   8     0   2   76 60 *                     136.0 14 3 109 0   8     0   2   76 60                 136
1368946 1368946 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No Elementary PK 08 2020   grade_7 95 3 28 0   2     0   8   70 66 *                     136.0 95 3 28 0   2     0   8   70 66                 136
1372507 1372507 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public School   Regular School Yes Middle 06 08 2020   grade_7 64 11 37 1   15     0   8   70 65 *                     136.0 64 11 37 1   15     0   8   70 65                 136
1368976 1368976 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Donald P Timony Grammar   Regular School No Elementary PK 08 2020   grade_7 57 1 63 1   7     0   8   78 59 *                     137.0 57 1 63 1   7     0   8   78 59                 137
1371026 1371026 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Impact Prep at Chestnut   Regular School No Middle 06 08 2020   grade_7 5 18 113 0   0     0   1   79 58 *                     137.0 5 18 113 0   0     0   1   79 58                 137
1367077 1367077 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No Elementary KG 08 2020   grade_7 38 17 74 1   4     0   4   70 68 *                     138.0 38 17 74 1   4     0   4   70 68                 138
1372806 1372806 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2020   grade_7 65 22 20 0   26     0   5   71 67 *                     138.0 65 22 20 0   26     0   5   71 67                 138
1373277 1373277 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dorothy L Beckwith   Regular School No Middle 05 08 2020   grade_7 127 1 4 0   0     0   7   72 67 *                     139.0 127 1 4 0   0     0   7   72 67                 139
1373441 1373441 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Miles River Middle   Regular School No Middle 06 08 2020   grade_7 126 1 4 0   3     0   5   69 70 *                     139.0 126 1 4 0   3     0   5   69 70                 139
1367297 1367297 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2020   grade_7 13 1 0 0   0     0   0   9 5 *                     14.0 13 1 0 0   0     0   0   9 5                 14
1366699 1366699 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Middle 05 08 2020   grade_7 92 7 36 0   1     1   3   83 57 *                     140.0 92 7 36 0   1     1   3   83 57                 140
1373108 1373108 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2020   grade_7 113 3 19 1   1     0   4   78 63 *                     141.0 113 3 19 1   1     0   4   78 63                 141
1368870 1368870 MA Middlesex   school 2507560 176   Medford 250756001638 1760315 Madeleine Dugger Andrews   Regular School No Middle 06 08 2020   grade_7 98 9 11 1   11     0   12   82 60 *                     142.0 98 9 11 1   11     0   12   82 60                 142
1367107 1367107 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Hastings Middle   Regular School No Middle 06 08 2020   grade_7 126 1 7 2   4     0   4   74 70 *                     144.0 126 1 7 2   4     0   4   74 70                 144
1368383 1368383 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 B.F. Butler Middle School   Regular School No Middle 05 08 2020   grade_7 37 11 47 0   41     0   8   71 73 *                     144.0 37 11 47 0   41     0   8   71 73                 144
1371451 1371451 MA Norfolk   school 2511970 307   Walpole 251197001965 3070310 Eleanor N Johnson Middle   Regular School No Middle 06 08 2020   grade_7 112 6 11 2   10     0   4   76 69 *                     145.0 112 6 11 2   10     0   4   76 69                 145
1372831 1372831 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston   Regular School Yes Middle 06 08 2020   grade_7 3 61 77 0   0     1   3   79 66 *                     145.0 3 61 77 0   0     1   3   79 66                 145
1366600 1366600 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No Middle 05 08 2020   grade_7 4 2 140 0   0     0   1   76 71 *                     147.0 4 2 140 0   0     0   1   76 71                 147
1367669 1367669 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No Middle 05 08 2020   grade_7 70 6 59 1   5     1   5   73 74 *                     147.0 70 6 59 1   5     1   5   73 74                 147
1368795 1368795 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2020   grade_7 107 6 5 8   5     0   16   71 76 *                     147.0 107 6 5 8   5     0   16   71 76                 147
1369821 1369821 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford Middle   Regular School No Middle 05 07 2020   grade_7 112 2 23 0   2     0   9   77 71 *                     148.0 112 2 23 0   2     0   9   77 71                 148
1372679 1372679 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2020   grade_7 33 86 4 0   15     0   10   69 79 *                     148.0 33 86 4 0   15     0   10   69 79                 148
1373164 1373164 MA Worcester   school 2502715 622   Blackstone-Millville 250271501082 6220405 Frederick W. Hartnett Middle School   Regular School No Middle 06 08 2020   grade_7 127 0 15 0   2     0   4   63 85 *                     148.0 127 0 15 0   2     0   4   63 85                 148

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