enrollments

Data source: Big Local News · About: Big Local

3,471 rows where grade = "grade_7" and state = "MA" sorted by hispanic

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 3,371 ✖
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
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
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
1372692 1372692 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2020   grade_7 35 2 0 0   15     0   0   22 30 *                     52.0 35 2 0 0   15     0   0   22 30                 52
1372848 1372848 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes Elementary KG 08 2020   grade_7 26 0 0 0   2     0   4   9 23 *                     32.0 26 0 0 0   2     0   4   9 23                 32
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
1374000 1374000 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No Elementary KG 08 2020   grade_7 42 0 0 0   3     0   1   24 22 *                     46.0 42 0 0 0   3     0   1   24 22                 46
1672413 1672413 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley - Berkley Middle School   Regular School No Middle 05 08 2021   grade_7 104 0 0 0   0     0   5   56 53 *                     109.0 104 0 0 0   0     0   5   56 53                 109
1673917 1673917 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg - Clarksburg Elementary   Regular School No Elementary KG 08 2021   grade_7 30 0 0 0   0     0   0   13 17 *                     30.0 30 0 0 0   0     0   0   13 17                 30
1674431 1674431 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River - Stone PK-12 School   Regular School No Other 01 12 2021   grade_7 7 1 0 0   0     0   0   7 1 *                     8.0 7 1 0 0   0     0   0   7 1                 8
1674531 1674531 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida - Abbott Memorial   Regular School No Elementary PK 08 2021   grade_7 18 0 0 0   0     0   0   11 7 *                     18.0 18 0 0 0   0     0   0   11 7                 18
1676612 1676612 MA Essex   school 2508580 204   Newburyport 250858001355 2040305 Newburyport - Rupert A Nock Middle   Regular School No Middle 06 08 2021   grade_7 156 3 0 0   4     0   2   85 80 *                     165.0 156 3 0 0   4     0   2   85 80                 165
1677506 1677506 MA Middlesex   school 2509990 246   Reading 250999001605 2460305 Reading - Arthur W Coolidge Middle   Regular School No Middle 06 08 2021   grade_7 128 1 0 0   2     0   1   74 58 *                     132.0 128 1 0 0   2     0   1   74 58                 132
1679973 1679973 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public (District) - Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2021   grade_7 24 0 0 0   2     0   5   15 16 *                     31.0 24 0 0 0   2     0   5   15 16                 31
1680610 1680610 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville - Freetown-Lakeville Middle School   Regular School No Middle 06 09 2021   grade_7 220 4 0 0   2     0   3   118 111 *                     229.0 220 4 0 0   2     0   3   118 111                 229
1681034 1681034 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley - Pioneer Valley Regional   Regular School No High 07 12 2021   grade_7 53 1 0 0   1     0   2   28 29 *                     57.0 53 1 0 0   1     0   2   28 29                 57
1681248 1681248 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Wachusett - Thomas Prince   Regular School No Elementary KG 08 2021   grade_7 37 2 0 0   2     0   3   25 19 *                     44.0 37 2 0 0   2     0   3   25 19                 44
2041288 2041288 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 03 12 2019   grade_7 4 2 0 0   0     0   1   5 2                       7.0 4 2 0 0   0     0   1   5 2                 7
2041759 2041759 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2019   grade_7 15 0 0 0   0     0   2   8 9                       17.0 15 0 0 0   0     0   2   8 9                 17
2042270 2042270 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2019   grade_7 3 1 0 0   0     0   5   8 1                       9.0 3 1 0 0   0     0   5   8 1                 9
2042369 2042369 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_7 9 0 0 0   0     0   0   2 7                       9.0 9 0 0 0   0     0   0   2 7                 9
2043007 2043007 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Memorial Middle   Regular School No Middle 06 08 2019   grade_7 59 1 0 0   1     0   2   31 32                       63.0 59 1 0 0   1     0   2   31 32                 63
2045005 2045005 MA Plymouth   school 2509420 231   Pembroke 250942001823 2310305 Pembroke Community Middle School   Regular School No Middle 07 08 2019   grade_7 215 1 0 0   1     1   1   125 94                       219.0 215 1 0 0   1     1   1   125 94                 219
2046861 2046861 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Stony Brook School   Regular School No Middle 06 08 2019   grade_7 145 3 0 0   53     0   7   101 107                       208.0 145 3 0 0   53     0   7   101 107                 208
2047890 2047890 MA Middlesex   school 2500038 478   Francis W. Parker Charter Essential (District) 250003800581 4780505 Francis W. Parker Charter Essential School   Regular School Yes High 07 12 2019   grade_7 67 1 0 0   0     0   2   37 33                       70.0 67 1 0 0   0     0   2   37 33                 70
2048110 2048110 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Middle School   Regular School No Middle 04 07 2019   grade_7 87 2 0 1   0     0   1   44 47                       91.0 87 2 0 1   0     0   1   44 47                 91
2048248 2048248 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002659 6250320 Bridgewater Middle School   Regular School No Middle 07 08 2019   grade_7 211 17 0 0   3     0   15   141 105                       246.0 211 17 0 0   3     0   15   141 105                 246
2229247 2229247 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley: Berkley Middle School   Regular School No Middle 05 08 2018   grade_7 92 0 0 0   0     0   5   47 50                       97.0 92 0 0 0   0     0   5   47 50                 97
2231029 2231029 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg: Clarksburg Elementary   Regular School No Elementary KG 08 2018   grade_7 16 0 0 0   0     0   0   7 9                       16.0 16 0 0 0   0     0   0   7 9                 16
2232521 2232521 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Hull: Memorial Middle   Regular School No Middle 06 08 2018   grade_7 65 0 0 0   0     0   0   40 25                       65.0 65 0 0 0   0     0   0   40 25                 65
2235376 2235376 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond: Richmond Consolidated   Regular School No Elementary PK 08 2018   grade_7 13 0 0 0   0     0   0   8 5                       13.0 13 0 0 0   0     0   0   8 5                 13
2237117 2237117 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Westford: Stony Brook School   Regular School No Middle 06 08 2018   grade_7 174 0 0 0   73     0   4   145 106                       251.0 174 0 0 0   73     0   4   145 106                 251
2238751 2238751 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002659 6250320 Bridgewater-Raynham: Bridgewater Middle School   Regular School No Middle 07 08 2018   grade_7 232 9 0 1   4     0   9   133 122                       255.0 232 9 0 1   4     0   9   133 122                 255
2239138 2239138 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional: Manchester Essex Regional Middle School   Regular School No Middle 06 08 2018   grade_7 121 0 0 0   2     0   2   72 53                       125.0 121 0 0 0   2     0   2   72 53                 125
2239241 2239241 MA Franklin   school 2507990 717   Mohawk Trail 250799001265 7170505 Mohawk Trail: Mohawk Trail Regional High   Regular School No High 07 12 2018   grade_7 54 0 0 0   0     0   0   20 34                       54.0 54 0 0 0   0     0   0   20 34                 54
735681 735681 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No 2 05 08 2015   grade_7 108 1 1 0   1     0   0   55 56                       111 108 1 1 0   1     0   0   55 56                 111
738562 738562 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No 3 07 12 2015   grade_7 28 0 1 0   0     0   2   18 13                       31 28 0 1 0   0     0   2   18 13                 31
738803 738803 MA Middlesex   school 2506330 139   Hopkinton 250633000468 1390305 Hopkinton Middle School   Regular School No 2 06 08 2015   grade_7 247 1 1 1   18     0   3   139 132                       271 247 1 1 1   18     0   3   139 132                 271
739554 739554 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield Middle School   Regular School No 2 05 08 2015   grade_7 150 7 1 0   4     0   5   86 81                       167 150 7 1 0   4     0   5   86 81                 167
740451 740451 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No 1 PK 07 2015   grade_7 38 1 1 0   0     0   2   24 18                       42 38 1 1 0   0     0   2   24 18                 42
741043 741043 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No 1 PK 08 2015   grade_7 2 4 1 0   0     0   1   3 5                       8 2 4 1 0   0     0   1   3 5                 8
741202 741202 MA Middlesex   school 2509990 246   Reading 250999001605 2460305 Arthur W Coolidge Middle   Regular School No 2 06 08 2015   grade_7 140 5 1 0   7     0   4   88 69                       157 140 5 1 0   7     0   4   88 69                 157
741276 741276 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No 1 PK 08 2015   grade_7 20 0 1 0   0     0   0   11 10                       21 20 0 1 0   0     0   0   11 10                 21
742152 742152 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton Middle School   Regular School No 2 06 08 2015   grade_7 112 1 1 0   0     0   3   48 69                       117 112 1 1 0   0     0   3   48 69                 117
743434 743434 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public School   Regular School Yes 3 07 12 2015   grade_7 33 0 1 0   1     0   2   16 21                       37 33 0 1 0   1     0   2   16 21                 37
743635 743635 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes 1 KG 08 2015   grade_7 41 1 1 0   5     0   1   25 24                       49 41 1 1 0   5     0   1   25 24                 49
743806 743806 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes 1 KG 08 2015   grade_7 30 0 1 0   1     0   0   14 18                       32 30 0 1 0   1     0   0   14 18                 32
743810 743810 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public School   Regular School Yes 4 05 12 2015   grade_7 80 0 1 1   3     0   3   38 50                       88 80 0 1 1   3     0   3   38 50                 88
744260 744260 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No 2 06 08 2015   grade_7 168 8 1 1   8     0   6   90 102                       192 168 8 1 1   8     0   6   90 102                 192
744288 744288 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville Middle School   Regular School No 2 06 08 2015   grade_7 248 3 1 0   3     1   2   151 107                       258 248 3 1 0   3     1   2   151 107                 258
744335 744335 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No 2 05 08 2015   grade_7 194 2 1 0   9     1   0   106 101                       207 194 2 1 0   9     1   0   106 101                 207
744602 744602 MA Worcester   school 2508310 725   Nashoba 250831000947 7250305 Luther Burbank Middle School   Regular School No 2 06 08 2015   grade_7 71 2 1 0   1     0   1   38 38                       76 71 2 1 0   1     0   1   38 38                 76
932559 932559 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No 2 05 08 2016   grade_7 114 2 1 0   1     0   0   54 64                       118 114 2 1 0   1     0   0   54 64                 118
932941 932941 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No 2 05 08 2016   grade_7 88 1 1 0   1     0   2   42 51                       93 88 1 1 0   1     0   2   42 51                 93
934001 934001 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative Education School No 4 04 12 2016   grade_7 3 5 1 0   0     0   0   6 3                       9 3 5 1 0   0     0   0   6 3                 9
935192 935192 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No 2 06 08 2016   grade_7 141 3 1 0   7     0   1   79 74                       153 141 3 1 0   7     0   1   79 74                 153
935412 935412 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No 3 07 12 2016   grade_7 35 0 1 0   0     0   0   26 10                       36 35 0 1 0   0     0   0   26 10                 36
935638 935638 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No 3 07 12 2016   grade_7 78 0 1 1   4     0   1   42 43                       85 78 0 1 1   4     0   1   42 43                 85
935693 935693 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Memorial Middle   Regular School No 2 06 08 2016   grade_7 75 2 1 0   0     0   2   38 42                       80 75 2 1 0   0     0   2   38 42                 80
937286 937286 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No 1 PK 07 2016   grade_7 26 1 1 0   0     0   3   21 10                       31 26 1 1 0   0     0   3   21 10                 31
938103 938103 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No 1 PK 08 2016   grade_7 7 1 1 0   0     0   0   3 6                       9 7 1 1 0   0     0   0   3 6                 9
938292 938292 MA Plymouth   school 2510560 264   Scituate 251056001690 2640305 Gates Intermediate School   Regular School No 2 07 08 2016   grade_7 243 7 1 0   2     0   3   126 130                       256 243 7 1 0   2     0   3   126 130                 256
939554 939554 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No 2 06 08 2016   grade_7 143 3 1 2   51     0   5   94 111                       205 143 3 1 2   51     0   5   94 111                 205
940458 940458 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes 1 KG 08 2016   grade_7 30 0 1 0   14     0   3   32 16                       48 30 0 1 0   14     0   3   32 16                 48
940550 940550 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2016   grade_7 12 0 1 0   2     0   1   12 4                       16 12 0 1 0   2     0   1   12 4                 16
940639 940639 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public School   Regular School Yes 4 05 12 2016   grade_7 86 0 1 0   1     0   1   37 52                       89 86 0 1 0   1     0   1   37 52                 89
940917 940917 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Tahanto Regional High   Regular School No 4 06 12 2016   grade_7 76 1 1 0   5     0   3   44 42                       86 76 1 1 0   5     0   3   44 42                 86
941280 941280 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional Middle School   Regular School No 2 06 08 2016   grade_7 125 0 1 0   4     0   1   62 69                       131 125 0 1 0   4     0   1   62 69                 131
941423 941423 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No 1 PK 08 2016   grade_7 97 1 1 0   2     0   0   48 53                       101 97 1 1 0   2     0   0   48 53                 101
941429 941429 MA Worcester   school 2508310 725   Nashoba 250831001868 7250310 Hale   Regular School No 2 06 08 2016   grade_7 82 0 1 0   5     0   0   58 30                       88 82 0 1 0   5     0   0   58 30                 88
941478 941478 MA Plymouth   school 2509150 740   Old Rochester 250915001473 7400405 Old Rochester Regional Jr High   Regular School No 2 07 08 2016   grade_7 216 9 1 0   3     0   10   112 127                       239 216 9 1 0   3     0   10   112 127                 239
941600 941600 MA Plymouth   school 2510830 760   Silver Lake 251083001721 7600405 Silver Lake Regional Middle School   Regular School No 2 06 08 2016   grade_7 295 3 1 0   5     0   1   146 159                       305 295 3 1 0   5     0   1   146 159                 305
941731 941731 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No 1 PK 08 2016   grade_7 16 1 1 1   0     0   0   6 13                       19 16 1 1 1   0     0   0   6 13                 19
1124214 1124214 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2017   grade_7 16 0 1 0   1     0   1   10 9                       19 16 0 1 0   1     0   1   10 9                 19
1125131 1125131 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No Middle 07 08 2017   grade_7 112 1 1 0   2     0   1   66 51                       117 112 1 1 0   2     0   1   66 51                 117
1127103 1127103 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No Middle 05 08 2017   grade_7 91 1 1 0   0     2   3   51 47                       98 91 1 1 0   0     2   3   51 47                 98
1127410 1127410 MA Essex   school 2508580 204   Newburyport 250858001355 2040305 Rupert A Nock Middle   Regular School No Middle 06 08 2017   grade_7 155 2 1 0   1     0   4   98 65                       163 155 2 1 0   1     0   4   98 65                 163
1128468 1128468 MA Middlesex   school 2509990 246   Reading 250999001605 2460305 Arthur W Coolidge Middle   Regular School No Middle 06 08 2017   grade_7 136 5 1 0   9     0   1   85 67                       152 136 5 1 0   9     0   1   85 67                 152
1128555 1128555 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2017   grade_7 20 0 1 0   0     0   0   7 14                       21 20 0 1 0   0     0   0   7 14                 21
1128604 1128604 MA Essex   school 2510200 252   Rockport 251020000506 2520305 Rockport Middle   Regular School No Middle 06 08 2017   grade_7 74 1 1 0   1     0   1   46 32                       78 74 1 1 0   1     0   1   46 32                 78
1128700 1128700 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich STEM Academy   Regular School No Middle 07 08 2017   grade_7 218 4 1 2   3     0   1   122 107                       229 218 4 1 2   3     0   1   122 107                 229
1129582 1129582 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton Middle School   Regular School No Middle 06 08 2017   grade_7 120 0 1 0   1     0   4   61 65                       126 120 0 1 0   1     0   4   61 65                 126
1130298 1130298 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No Middle 06 08 2017   grade_7 144 2 1 2   63     1   1   116 98                       214 144 2 1 2   63     1   1   116 98                 214
1131134 1131134 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public School   Regular School Yes High 07 12 2017   grade_7 33 1 1 0   0     0   1   18 18                       36 33 1 1 0   0     0   1   18 18                 36
1131244 1131244 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes Other 05 12 2017   grade_7 84 4 1 0   9     0   2   47 53                       100 84 4 1 0   9     0   2   47 53                 100
1131456 1131456 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2017   grade_7 10 2 1 0   0     0   1   5 9                       14 10 2 1 0   0     0   1   5 9                 14
1131601 1131601 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public School   Regular School Yes Other KG 12 2017   grade_7 45 14 1 0   2     0   3   38 27                       65 45 14 1 0   2     0   3   38 27                 65
1131664 1131664 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2017   grade_7 32 1 1 0   10     0   5   23 26                       49 32 1 1 0   10     0   5   23 26                 49
1131758 1131758 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No Other 06 12 2017   grade_7 104 6 1 0   1     0   0   58 54                       112 104 6 1 0   1     0   0   58 54                 112
1132416 1132416 MA Franklin   school 2507990 717   Mohawk Trail 250799001265 7170505 Mohawk Trail Regional High   Regular School No High 07 12 2017   grade_7 72 1 1 0   0     0   2   37 39                       76 72 1 1 0   0     0   2   37 39                 76
1132713 1132713 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Mt Everett Regional   Regular School No High 07 12 2017   grade_7 42 1 1 0   0     0   2   27 19                       46 42 1 1 0   0     0   2   27 19                 46
1132832 1132832 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2017   grade_7 38 1 1 3   1     0   2   33 13                       46 38 1 1 3   1     0   2   33 13                 46
1132902 1132902 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No Middle 05 08 2017   grade_7 87 3 1 0   1     0   0   48 44                       92 87 3 1 0   1     0   0   48 44                 92
1366519 1366519 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No Elementary PK 08 2020   grade_7 49 0 1 0   6     0   8   36 28 *                     64.0 49 0 1 0   6     0   8   36 28                 64
1366931 1366931 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No High 07 12 2020   grade_7 151 9 1 1   0     1   6   100 69 *                     169.0 151 9 1 1   0     1   6   100 69                 169
1367469 1367469 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No Middle 07 08 2020   grade_7 84 0 1 0   2     1   0   41 47 *                     88.0 84 0 1 0   2     1   0   41 47                 88
1367638 1367638 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No High 07 12 2020   grade_7 37 0 1 0   0     0   1   22 17 *                     39.0 37 0 1 0   0     0   1   22 17                 39
1369100 1369100 MA Hampden   school 2508040 191   Monson 250804001269 1910505 Monson High School   Regular School No High 07 12 2020   grade_7 56 0 1 0   2     0   1   30 30 *                     60.0 56 0 1 0   2     0   1   30 30                 60
1370375 1370375 MA Essex   school 2510200 252   Rockport 251020000506 2520305 Rockport Middle   Regular School No Middle 06 08 2020   grade_7 62 0 1 0   2     0   0   24 41 *                     65.0 62 0 1 0   2     0   0   24 41                 65
1372476 1372476 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public School   Regular School Yes High 07 12 2020   grade_7 35 0 1 0   0     0   2   16 22 *                     38.0 35 0 1 0   0     0   2   16 22                 38
1372607 1372607 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2020   grade_7 0 18 1 0   0     0   0   9 10 *                     19.0 0 18 1 0   0     0   0   9 10                 19

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