enrollments

Data source: Big Local News · About: Big Local

493 rows where grade = "grade_8", state = "MA" and year = 2019 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 493 ✖

grade ✖

  • grade_8 · 493 ✖
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
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
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
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
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
2040936 2040936 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No Middle 06 08 2019   grade_8 7 17 72 0   8     0   1   63 42                       105.0 7 17 72 0   8     0   1   63 42                 105
2048336 2048336 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No Middle 05 08 2019   grade_8 95 1 4 0   1     0   4   58 47                       105.0 95 1 4 0   1     0   4   58 47                 105
2044124 2044124 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No Middle 05 08 2019   grade_8 89 2 12 0   0     0   3   55 51                       106.0 89 2 12 0   0     0   3   55 51                 106
2049327 2049327 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Middle 06 10 2019   grade_8 1 95 10 0   0     0   2   49 59                       108.0 1 95 10 0   0     0   2   49 59                 108
2047992 2047992 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2019   grade_8 84 9 10 0   4     0   2   60 49                       109.0 84 9 10 0   4     0   2   60 49                 109
2048968 2048968 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2019   grade_8 87 2 17 0   2     0   1   61 48                       109.0 87 2 17 0   2     0   1   61 48                 109
2039834 2039834 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2019   grade_8 108 1 1 0   0     0   1   52 59                       111.0 108 1 1 0   0     0   1   52 59                 111
2040942 2040942 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No Middle 06 08 2019   grade_8 1 43 66 0   0     1   0   48 63                       111.0 1 43 66 0   0     1   0   48 63                 111
2042542 2042542 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No Middle 07 08 2019   grade_8 105 3 1 0   1     0   1   62 49                       111.0 105 3 1 0   1     0   1   62 49                 111
2043344 2043344 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Glenbrook Middle   Regular School No Middle 06 08 2019   grade_8 89 4 4 0   13     0   2   57 55                       112.0 89 4 4 0   13     0   2   57 55                 112
2046118 2046118 MA Hampden   school 2511130 281   Springfield 251113002855 2810485 Van Sickle Academy   Regular School No Middle 06 08 2019   grade_8 13 15 81 0   2     0   1   60 52                       112.0 13 15 81 0   2     0   1   60 52                 112
2046789 2046789 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No High 07 12 2019   grade_8 99 7 5 0   0     0   1   63 49                       112.0 99 7 5 0   0     0   1   63 49                 112
2046062 2046062 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No High 06 12 2019   grade_8 23 21 68 0   1     0   0   62 51                       113.0 23 21 68 0   1     0   0   62 51                 113
2043104 2043104 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2019   grade_8 2 1 111 0   0     0   0   60 54                       114.0 2 1 111 0   0     0   0   60 54                 114
2047879 2047879 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2019   grade_8 59 15 14 0   24     0   2   59 55                       114.0 59 15 14 0   24     0   2   59 55                 114
2048701 2048701 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No Middle 05 08 2019   grade_8 105 0 7 0   0     0   2   61 53                       114.0 105 0 7 0   0     0   2   61 53                 114
2043129 2043129 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No Middle 06 08 2019   grade_8 2 1 111 0   1     0   0   64 51                       115.0 2 1 111 0   1     0   0   64 51                 115
2046102 2046102 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Impact Prep at Chestnut   Regular School No Middle 06 08 2019   grade_8 3 16 97 0   0     0   0   51 65                       116.0 3 16 97 0   0     0   0   51 65                 116
2043177 2043177 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No Middle 06 08 2019   grade_8 94 5 10 0   2     0   7   57 61                       118.0 94 5 10 0   2     0   7   57 61                 118
2043325 2043325 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No Middle 06 08 2019   grade_8 99 0 2 1   9     0   7   58 60                       118.0 99 0 2 1   9     0   7   58 60                 118
2046904 2046904 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport Junior/Senior High School   Regular School No High 07 12 2019   grade_8 108 1 4 0   1     0   5   68 51                       119.0 108 1 4 0   1     0   5   68 51                 119
2040696 2040696 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2019   grade_8 9 2 1 0   0     0   0   4 8                       12.0 9 2 1 0   0     0   0   4 8                 12
2045406 2045406 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2019   grade_8 11 0 0 0   0     0   1   6 6                       12.0 11 0 0 0   0     0   1   6 6                 12
2044910 2044910 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer High   Regular School No High 06 12 2019   grade_8 93 4 15 0   0     0   8   71 49                       120.0 93 4 15 0   0     0   8   71 49                 120
2047738 2047738 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 2019   grade_8 25 61 25 0   3     0   6   64 56                       120.0 25 61 25 0   3     0   6   64 56                 120
2048946 2048946 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2019   grade_8 109 3 4 0   2     0   2   63 57                       120.0 109 3 4 0   2     0   2   63 57                 120
2042159 2042159 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2019   grade_8 13 14 89 0   4     0   1   64 57                       121.0 13 14 89 0   4     0   1   64 57                 121
2048288 2048288 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No Middle 06 08 2019   grade_8 111 2 3 0   0     0   5   56 65                       121.0 111 2 3 0   0     0   5   56 65                 121
2047628 2047628 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2019   grade_8 8 19 90 0   2     0   3   70 52                       122.0 8 19 90 0   2     0   3   70 52                 122
2048415 2048415 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier Regional   Regular School No High 07 12 2019   grade_8 110 2 5 0   2     0   3   62 60                       122.0 110 2 5 0   2     0   3   62 60                 122
2042789 2042789 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2019   grade_8 80 5 34 0   2     1   1   58 65                       123.0 80 5 34 0   2     1   1   58 65                 123
2040573 2040573 MA Suffolk   school 2502790 35   Boston 250279000269 350179 John W McCormack   Regular School No Middle 06 08 2019   grade_8 7 39 73 1   2     0   2   62 62                       124.0 7 39 73 1   2     0   2   62 62                 124
2041662 2041662 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2019   grade_8 11 6 103 0   2     0   2   65 59                       124.0 11 6 103 0   2     0   2   65 59                 124
2045245 2045245 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Broad Meadows Middle   Regular School No Middle 06 08 2019   grade_8 80 11 10 1   18     1   3   54 70                       124.0 80 11 10 1   18     1   3   54 70                 124
2042642 2042642 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield High   Regular School No High 08 12 2019   grade_8 88 2 28 0   1     0   6   65 60                       125.0 88 2 28 0   1     0   6   65 60                 125
2043469 2043469 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 B.F. Butler Middle School   Regular School No Middle 05 08 2019   grade_8 39 9 41 0   31     0   6   63 63                       126.0 39 9 41 0   31     0   6   63 63                 126
2043534 2043534 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg Middle School   Regular School No Middle 06 08 2019   grade_8 105 2 14 0   2     0   3   74 52                       126.0 105 2 14 0   2     0   3   74 52                 126
2047580 2047580 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public School   Regular School Yes Middle 06 08 2019   grade_8 80 2 30 1   9     0   4   66 60                       126.0 80 2 30 1   9     0   4   66 60                 126
2049111 2049111 MA Worcester   school 2512100 778   Quaboag Regional 251210002794 7780305 Quaboag Regional Middle Innovation School   Regular School No Middle 07 08 2019   grade_8 114 0 8 0   0     0   4   65 61                       126.0 114 0 8 0   0     0   4   65 61                 126
2041785 2041785 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No High 06 12 2019   grade_8 118 3 1 0   4     0   1   64 63                       127.0 118 3 1 0   4     0   1   64 63                 127
2048778 2048778 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 Nissitissit Middle School   Regular School No Middle 05 08 2019   grade_8 118 0 3 0   4     0   2   71 56                       127.0 118 0 3 0   4     0   2   71 56                 127
2047713 2047713 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2019   grade_8 23 41 50 0   5     0   9   63 65                       128.0 23 41 50 0   5     0   9   63 65                 128
2048576 2048576 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional Middle School   Regular School No Middle 06 08 2019   grade_8 122 0 0 0   3     0   3   73 55                       128.0 122 0 0 0   3     0   3   73 55                 128
2039951 2039951 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2019   grade_8 77 2 11 0   35     0   4   54 75                       129.0 77 2 11 0   35     0   4   54 75                 129
2043746 2043746 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Salemwood   Regular School No Elementary KG 08 2019   grade_8 30 30 46 0   22     0   1   62 67                       129.0 30 30 46 0   22     0   1   62 67                 129
2040911 2040911 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2019   grade_8 3 2 7 1   0     0   0   7 6                       13.0 3 2 7 1   0     0   0   7 6                 13
2043669 2043669 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No High 06 12 2019   grade_8 1 1 9 1   0     0   1   7 6                       13.0 1 1 9 1   0     0   1   7 6                 13
2043138 2043138 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2019   grade_8 6 2 119 0   2     0   1   71 59                       130.0 6 2 119 0   2     0   1   71 59                 130
2046115 2046115 MA Hampden   school 2511130 281   Springfield 251113002859 2810480 Rise Academy at Van Sickle   Regular School No Middle 06 08 2019   grade_8 11 16 99 0   1     0   3   66 64                       130.0 11 16 99 0   1     0   3   66 64                 130
2048536 2048536 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire Regional High   Regular School No High 07 12 2019   grade_8 121 1 6 0   1     0   1   61 69                       130.0 121 1 6 0   1     0   1   61 69                 130
2041770 2041770 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Middle 05 08 2019   grade_8 93 6 30 0   2     0   0   78 53                       131.0 93 6 30 0   2     0   0   78 53                 131
2044028 2044028 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No Elementary PK 08 2019   grade_8 64 2 49 0   10     0   7   60 72                       132.0 64 2 49 0   10     0   7   60 72                 132
2046277 2046277 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton Middle School   Regular School No Middle 06 08 2019   grade_8 116 3 4 0   4     0   5   72 60                       132.0 116 3 4 0   4     0   5   72 60                 132
2048893 2048893 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar Regional   Regular School No High 07 12 2019   grade_8 114 2 11 0   3     0   2   73 59                       132.0 114 2 11 0   3     0   2   73 59                 132
2041600 2041600 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No High 06 12 2019   grade_8 128 0 2 1   1     0   1   59 74                       133.0 128 0 2 1   1     0   1   59 74                 133
2043087 2043087 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2019   grade_8 4 3 125 0   0     0   1   65 68                       133.0 4 3 125 0   0     0   1   65 68                 133
2046437 2046437 MA Middlesex   school 2511760 301   Tyngsborough 251176001715 3010305 Tyngsborough Middle   Regular School No Middle 06 08 2019   grade_8 112 3 4 0   12     0   3   70 64                       134.0 112 3 4 0   12     0   3   70 64                 134
2046451 2046451 MA Worcester   school 2511850 304   Uxbridge 251185001938 3040505 Uxbridge High   Regular School No High 08 12 2019   grade_8 118 3 7 0   3     0   3   79 55                       134.0 118 3 7 0   3     0   3   79 55                 134
2048505 2048505 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Miles River Middle   Regular School No Middle 06 08 2019   grade_8 124 0 5 0   3     1   2   63 72                       135.0 124 0 5 0   3     1   2   63 72                 135
2049084 2049084 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No Middle 06 08 2019   grade_8 119 0 3 0   5     0   8   72 63                       135.0 119 0 3 0   5     0   8   72 63                 135
2049139 2049139 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No Middle 05 08 2019   grade_8 128 1 4 0   0     0   2   86 49                       135.0 128 1 4 0   0     0   2   86 49                 135
2040050 2040050 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2019   grade_8 109 4 7 0   5     0   11   71 65                       136.0 109 4 7 0   5     0   11   71 65                 136
2041070 2041070 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No High 06 12 2019   grade_8 3 86 38 0   3     1   5   85 51                       136.0 3 86 38 0   3     1   5   85 51                 136
2044192 2044192 MA Nantucket   school 2508250 197   Nantucket 250825001281 1970010 Cyrus Peirce   Regular School No Middle 06 08 2019   grade_8 74 13 41 0   1     0   7   72 64                       136.0 74 13 41 0   1     0   7   72 64                 136
2041666 2041666 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2019   grade_8 3 7 124 1   1     0   1   77 60                       137.0 3 7 124 1   1     0   1   77 60                 137
2043031 2043031 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich Middle School   Regular School No Middle 06 08 2019   grade_8 117 2 8 0   1     0   9   71 66                       137.0 117 2 8 0   1     0   9   71 66                 137
2048225 2048225 MA Worcester   school 2502715 622   Blackstone-Millville 250271501082 6220405 Frederick W. Hartnett Middle School   Regular School No Middle 06 08 2019   grade_8 123 5 4 0   0     0   5   72 65                       137.0 123 5 4 0   0     0   5   72 65                 137
2041670 2041670 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No Middle 05 08 2019   grade_8 9 4 123 0   2     0   0   67 71                       138.0 9 4 123 0   2     0   0   67 71                 138
2042505 2042505 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No Middle 06 08 2019   grade_8 119 3 6 0   9     0   1   62 76                       138.0 119 3 6 0   9     0   1   62 76                 138
2040058 2040058 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No Middle 05 08 2019   grade_8 97 8 24 0   8     0   2   83 56                       139.0 97 8 24 0   8     0   2   83 56                 139
2041067 2041067 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No Elementary PK 08 2019   grade_8 10 5 122 0   1     1   0   77 62                       139.0 10 5 122 0   1     1   0   77 62                 139
2044018 2044018 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No Elementary PK 08 2019   grade_8 97 0 32 0   5     0   5   68 71                       139.0 97 0 32 0   5     0   5   68 71                 139
2044895 2044895 MA Worcester   school 2509270 226   Oxford 250927001482 2260505 Oxford High   Regular School No High 08 12 2019   grade_8 116 2 15 0   4     0   2   74 65                       139.0 116 2 15 0   4     0   2   74 65                 139
2046526 2046526 MA Norfolk   school 2511970 307   Walpole 251197001965 3070310 Eleanor N Johnson Middle   Regular School No Middle 06 08 2019   grade_8 118 2 4 2   10     0   3   70 69                       139.0 118 2 4 2   10     0   3   70 69                 139
2040325 2040325 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No Elementary KG 08 2019   grade_8 3 2 5 0   3     0   1   8 6                       14.0 3 2 5 0   3     0   1   8 6                 14
2042753 2042753 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No Middle 05 08 2019   grade_8 69 7 58 0   5     0   1   75 65                       140.0 69 7 58 0   5     0   1   75 65                 140
2043867 2043867 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2019   grade_8 105 10 2 13   4     0   6   59 81                       140.0 105 10 2 13   4     0   6   59 81                 140
2048183 2048183 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2019   grade_8 109 7 18 3   0     1   3   67 74                       141.0 109 7 18 3   0     1   3   67 74                 141
2044109 2044109 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No High 07 12 2019   grade_8 125 4 10 0   1     0   2   60 82                       142.0 125 4 10 0   1     0   2   60 82                 142
2040054 2040054 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2019   grade_8 85 10 34 1   3     0   10   75 67                       143.0 85 10 34 1   3     0   10   75 67                 143
2045810 2045810 MA Worcester   school 2510980 276   Southborough 251098001221 2760305 P Brent Trottier   Regular School No Middle 06 08 2019   grade_8 105 0 5 0   29     0   4   72 71                       143.0 105 0 5 0   29     0   4   72 71                 143
2048627 2048627 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No High 08 12 2019   grade_8 114 12 10 0   1     0   6   67 76                       143.0 114 12 10 0   1     0   6   67 76                 143
2044048 2044048 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Donald P Timony Grammar   Regular School No Elementary PK 08 2019   grade_8 48 0 85 0   8     0   5   92 54                       146.0 48 0 85 0   8     0   5   92 54                 146
2045842 2045842 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 Michael E. Smith Middle School   Regular School No Middle 05 08 2019   grade_8 115 5 20 0   0     0   6   66 80                       146.0 115 5 20 0   0     0   6   66 80                 146
2047188 2047188 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No Middle 06 08 2019   grade_8 110 6 13 3   12     0   2   70 76                       146.0 110 6 13 3   12     0   2   70 76                 146
2047751 2047751 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2019   grade_8 54 68 5 1   7     0   11   70 76                       146.0 54 68 5 1   7     0   11   70 76                 146
2048340 2048340 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dorothy L Beckwith   Regular School No Middle 05 08 2019   grade_8 134 0 5 0   1     0   6   59 87                       146.0 134 0 5 0   1     0   6   59 87                 146
2045332 2045332 MA Middlesex   school 2509990 246   Reading 250999001605 2460305 Arthur W Coolidge Middle   Regular School No Middle 06 08 2019   grade_8 132 2 3 1   6     0   4   82 66                       148.0 132 2 3 1   6     0   4   82 66                 148
2043484 2043484 MA Middlesex   school 2507020 160   Lowell 250702000073 1600340 James Sullivan Middle School   Regular School No Middle 06 08 2019   grade_8 39 15 66 0   24     0   5   73 76                       149.0 39 15 66 0   24     0   5   73 76                 149

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