enrollments

Data source: Big Local News · About: Big Local

500 rows where grade = "grade_8", state = "MA" and year = 2020 sorted by county

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 500 ✖

grade ✖

  • grade_8 · 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
1365096 1365096 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2020   grade_8 273 31 71 1   8     0   22   217 188 *                     406.0 273 31 71 1   8     0   22   217 188                 406
1366066 1366066 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 06 08 2020   grade_8 150 2 9 3   2     0   5   86 85 *                     171.0 150 2 9 3   2     0   5   86 85                 171
1367238 1367238 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No Middle 07 08 2020   grade_8 204 19 16 1   2     0   14   130 126 *                     256.0 204 19 16 1   2     0   14   130 126                 256
1368796 1368796 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2020   grade_8 85 4 4 6   3     0   7   59 50 *                     109.0 85 4 4 6   3     0   7   59 50                 109
1370099 1370099 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2020   grade_8 6 4 3 0   0     0   2   7 8 *                     15.0 6 4 3 0   0     0   2   7 8                 15
1370448 1370448 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich STEM Academy   Regular School No Middle 07 08 2020   grade_8 221 1 3 0   2     0   2   110 118 *                     229.0 221 1 3 0   2     0   2   110 118                 229
1372579 1372579 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2020   grade_8 62 3 5 0   1     0   6   38 39 *                     77.0 62 3 5 0   1     0   6   38 39                 77
1373254 1373254 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2020   grade_8 140 17 35 5   4     0   16   108 109 *                     217.0 140 17 35 5   4     0   16   108 109                 217
1373319 1373319 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No Middle 06 08 2020   grade_8 160 6 15 0   4     0   7   90 102 *                     192.0 160 6 15 0   4     0   7   90 102                 192
1373566 1373566 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No High 08 12 2020   grade_8 98 14 12 0   1     1   7   67 66 *                     133.0 98 14 12 0   1     1   7   67 66                 133
1366690 1366690 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2020   grade_8 14 1 0 0   0     0   1   7 9 *                     16.0 14 1 0 0   0     0   1   7 9                 16
1367298 1367298 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2020   grade_8 7 0 0 0   0     0   0   1 6 *                     7.0 7 0 0 0   0     0   0   1 6                 7
1368078 1368078 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No High 07 12 2020   grade_8 50 1 4 0   2     0   1   31 27 *                     58.0 50 1 4 0   2     0   1   31 27                 58
1368107 1368107 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No High 06 12 2020   grade_8 59 0 9 0   2     0   2   42 30 *                     72.0 59 0 9 0   2     0   2   42 30                 72
1369515 1369515 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No High 07 12 2020   grade_8 98 4 5 0   1     1   5   60 54 *                     114.0 98 4 5 0   1     1   5   60 54                 114
1369999 1369999 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 John T Reid Middle   Regular School No Middle 06 08 2020   grade_8 111 25 17 0   2     0   17   90 82 *                     172.0 111 25 17 0   2     0   17   90 82                 172
1370002 1370002 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Theodore Herberg Middle   Regular School No Middle 06 08 2020   grade_8 144 25 31 0   4     0   14   108 110 *                     218.0 144 25 31 0   4     0   14   108 110                 218
1370333 1370333 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2020   grade_8 18 0 3 0   0     0   1   12 10 *                     22.0 18 0 3 0   0     0   1   12 10                 22
1372484 1372484 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes High 06 12 2020   grade_8 48 5 10 0   2     0   3   37 31 *                     68.0 48 5 10 0   2     0   3   37 31                 68
1373039 1373039 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley High School   Regular School No High 08 12 2020   grade_8 87 2 1 1   0     0   1   45 47 *                     92.0 87 2 1 1   0     0   1   45 47                 92
1373123 1373123 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No Middle 05 08 2020   grade_8 65 2 5 1   5     0   6   42 42 *                     84.0 65 2 5 1   5     0   6   42 42                 84
1373227 1373227 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No Middle 06 08 2020   grade_8 127 0 4 0   2     0   6   70 69 *                     139.0 127 0 4 0   2     0   6   70 69                 139
1373588 1373588 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No High 07 12 2020   grade_8 124 2 1 0   2     0   1   56 74 *                     130.0 124 2 1 0   2     0   1   56 74                 130
1373860 1373860 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Mt Everett Regional   Regular School No High 06 12 2020   grade_8 37 0 1 0   0     0   2   16 24 *                     40.0 37 0 1 0   0     0   2   16 24                 40
1364808 1364808 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2020   grade_8 112 2 2 0   1     0   3   62 58 *                     120.0 112 2 2 0   1     0   3   62 58                 120
1365023 1365023 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2020   grade_8 124 8 23 0   10     0   12   91 86 *                     177.0 124 8 23 0   10     0   12   91 86                 177
1365027 1365027 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2020   grade_8 95 10 27 1   9     0   9   74 77 *                     151.0 95 10 27 1   9     0   9   74 77                 151
1365031 1365031 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No Middle 05 08 2020   grade_8 97 6 23 0   8     0   11   81 64 *                     145.0 97 6 23 0   8     0   11   81 64                 145
1365192 1365192 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2020   grade_8 87 2 4 0   0     0   1   50 44 *                     94.0 87 2 4 0   0     0   1   50 44                 94
1366813 1366813 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth Middle   Regular School No Middle 06 08 2020   grade_8 277 5 15 0   0     0   21   170 148 *                     318.0 277 5 15 0   0     0   21   170 148                 318
1367003 1367003 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No Middle 06 08 2020   grade_8 245 12 17 0   10     0   9   154 139 *                     293.0 245 12 17 0   10     0   9   154 139                 293
1367108 1367108 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Hastings Middle   Regular School No Middle 06 08 2020   grade_8 136 2 8 0   5     0   9   92 68 *                     160.0 136 2 8 0   5     0   9   92 68                 160
1367150 1367150 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No Elementary PK 08 2020   grade_8 19 7 17 0   2     0   5   33 17 *                     50.0 19 7 17 0   2     0   5   33 17                 50
1367160 1367160 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No Elementary PK 08 2020   grade_8 22 3 8 0   3     0   5   22 19 *                     41.0 22 3 8 0   3     0   5   22 19                 41
1367189 1367189 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No Middle 06 08 2020   grade_8 72 18 65 0   6     0   13   92 82 *                     174.0 72 18 65 0   6     0   13   92 82                 174
1367192 1367192 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No Middle 06 08 2020   grade_8 112 16 45 0   9     0   13   118 77 *                     195.0 112 16 45 0   9     0   13   118 77                 195
1367195 1367195 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No Middle 06 08 2020   grade_8 138 24 40 0   13     0   11   106 120 *                     226.0 138 24 40 0   13     0   11   106 120                 226
1367199 1367199 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2020   grade_8 3 1 0 0   0     0   4   7 1 *                     8.0 3 1 0 0   0     0   4   7 1                 8
1367208 1367208 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Resiliency Preparatory Academy   Alternative School No High 07 12 2020   grade_8 8 5 11 0   0     0   2   14 12 *                     26.0 8 5 11 0   0     0   2   14 12                 26
1368695 1368695 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Harold L Qualters Middle   Regular School No Middle 06 08 2020   grade_8 236 11 15 0   31     0   9   150 152 *                     302.0 236 11 15 0   31     0   9   150 152                 302
1369330 1369330 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No Middle 06 08 2020   grade_8 132 50 104 1   5     0   18   163 147 *                     310.0 132 50 104 1   5     0   18   163 147                 310
1369333 1369333 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No Middle 06 08 2020   grade_8 224 31 141 1   4     0   18   228 191 *                     419.0 224 31 141 1   4     0   18   228 191                 419
1369336 1369336 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No Middle 06 08 2020   grade_8 102 51 132 1   0     1   10   150 147 *                     297.0 102 51 132 1   0     1   10   150 147                 297
1369345 1369345 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No Other 04 12 2020   grade_8 2 0 5 0   0     0   2   4 5 *                     9.0 2 0 5 0   0     0   2   4 5                 9
1369350 1369350 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No High 06 12 2020   grade_8 3 6 5 0   0     0   0   10 4 *                     14.0 3 6 5 0   0     0   0   10 4                 14
1369622 1369622 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No Middle 06 08 2020   grade_8 300 12 20 0   21     0   13   180 186 *                     366.0 300 12 20 0   21     0   13   180 186                 366
1369722 1369722 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton Middle   Regular School No Middle 06 08 2020   grade_8 165 3 10 1   5     0   9   91 102 *                     193.0 165 3 10 1   5     0   9   91 102                 193
1370541 1370541 MA Bristol   school 2510590 265   Seekonk 251059001700 2650405 Dr. Kevin M. Hurley Middle School   Regular School No Middle 06 08 2020   grade_8 133 5 8 0   6     0   7   78 81 *                     159.0 133 5 8 0   6     0   7   78 81                 159
1370638 1370638 MA Bristol   school 2510860 273   Somerset 251086002537 2730305 Somerset Middle School   Regular School No Middle 06 08 2020   grade_8 205 1 10 0   0     0   2   110 108 *                     218.0 205 1 10 0   0     0   2   110 108                 218
1371246 1371246 MA Bristol   school 2511460 292   Swansea 251146001894 2920305 Joseph Case Jr High   Regular School No Middle 06 08 2020   grade_8 189 3 6 0   1     0   1   105 95 *                     200.0 189 3 6 0   1     0   1   105 95                 200
1371298 1371298 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2020   grade_8 427 122 83 4   8     1   45   356 334 *                     690.0 427 122 83 4   8     1   45   356 334                 690
1371830 1371830 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport Junior/Senior High School   Regular School No High 07 12 2020   grade_8 132 2 7 0   0     0   4   71 74 *                     145.0 132 2 7 0   0     0   4   71 74                 145
1372451 1372451 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 08 2020   grade_8 16 6 21 0   0     0   0   22 21 *                     43.0 16 6 21 0   0     0   0   22 21                 43
1372920 1372920 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2020   grade_8 85 5 16 0   2     0   2   52 58 *                     110.0 85 5 16 0   2     0   2   52 58                 110
1372951 1372951 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes High 05 12 2020   grade_8 34 12 41 1   0     0   3   45 46 *                     91.0 34 12 41 1   0     0   3   45 46                 91
1373186 1373186 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Raynham Middle School   Regular School No Middle 05 08 2020   grade_8 121 12 4 0   7     0   2   66 80 *                     146.0 121 12 4 0   7     0   2   66 80                 146
1373188 1373188 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002659 6250320 Bridgewater Middle School   Regular School No Middle 07 08 2020   grade_8 212 21 3 0   2     0   16   145 109 *                     254.0 212 21 3 0   2     0   16   145 109                 254
1373190 1373190 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No High 07 12 2020   grade_8 * * * *   *     *   *   1 * *                     2.0                         1                   2
1373274 1373274 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No Middle 05 08 2020   grade_8 99 2 4 0   1     0   4   61 49 *                     110.0 99 2 4 0   1     0   4   61 49                 110
1373278 1373278 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dorothy L Beckwith   Regular School No Middle 05 08 2020   grade_8 142 0 7 0   3     0   5   83 74 *                     157.0 142 0 7 0   3     0   5   83 74                 157
1373345 1373345 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville Middle School   Regular School No Middle 06 09 2020   grade_8 252 1 4 1   0     0   4   130 132 *                     262.0 252 1 4 1   0     0   4   130 132                 262
1374236 1374236 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Secondary 06 11 2020   grade_8 65 12 14 0   2     0   5   56 42 *                     98.0 65 12 14 0   2     0   5   56 42                 98
1367018 1367018 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No Elementary PK 08 2020   grade_8 28 2 5 0   0     0   1   17 19 *                     36.0 28 2 5 0   0     0   1   17 19                 36
1369794 1369794 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No Elementary PK 08 2020   grade_8 32 3 7 1   1     0   3   19 28 *                     47.0 32 3 7 1   1     0   3   19 28                 47
1371336 1371336 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No Elementary PK 08 2020   grade_8 17 2 10 2   0     0   7   17 21 *                     38.0 17 2 10 2   0     0   7   17 21                 38
1372779 1372779 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2020   grade_8 18 1 1 0   0     0   1   7 14 *                     21.0 18 1 1 0   0     0   1   7 14                 21
1373956 1373956 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2020   grade_8 37 0 2 1   1     0   3   29 15 *                     44.0 37 0 2 1   1     0   3   29 15                 44
1374315 1374315 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
1364853 1364853 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2020   grade_8 137 6 21 0   0     1   4   85 84 *                     169.0 137 6 21 0   0     1   4   85 84                 169
1364918 1364918 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No Middle 06 08 2020   grade_8 141 4 14 0   17     0   5   77 104 *                     181.0 141 4 14 0   17     0   5   77 104                 181
1364921 1364921 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No Middle 06 08 2020   grade_8 121 10 10 0   28     0   3   86 86 *                     172.0 121 10 10 0   28     0   3   86 86                 172
1364924 1364924 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2020   grade_8 79 4 14 0   46     0   5   81 67 *                     148.0 79 4 14 0   46     0   5   81 67                 148
1365222 1365222 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly Middle School   Regular School No Middle 05 08 2020   grade_8 239 9 54 0   9     0   9   175 145 *                     320.0 239 9 54 0   9     0   9   175 145                 320
1366785 1366785 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No Middle 06 08 2020   grade_8 235 5 24 0   9     0   6   142 137 *                     279.0 235 5 24 0   9     0   6   142 137                 279
1367470 1367470 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No Middle 07 08 2020   grade_8 91 2 3 0   0     0   0   50 46 *                     96.0 91 2 3 0   0     0   0   50 46                 96
1367508 1367508 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No Middle 06 08 2020   grade_8 201 4 19 0   4     1   8   123 114 *                     237.0 201 4 19 0   4     1   8   123 114                 237
1367662 1367662 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Caleb Dustin Hunking School   Regular School No Elementary KG 08 2020   grade_8 153 11 40 0   5     1   4   111 103 *                     214.0 153 11 40 0   5     1   4   111 103                 214
1367670 1367670 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No Middle 05 08 2020   grade_8 50 5 66 0   1     1   2   61 64 *                     125.0 50 5 66 0   1     1   2   61 64                 125
1367688 1367688 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_8 * * * *   *     *   *   2 * *                     2.0                         2                   2
1367703 1367703 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2020   grade_8 73 7 41 1   3     0   1   67 59 *                     126.0 73 7 41 1   3     0   1   67 59                 126
1367707 1367707 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 05 08 2020   grade_8 101 9 100 1   4     0   1   119 97 *                     216.0 101 9 100 1   4     0   1   119 97                 216
1367948 1367948 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich Middle School   Regular School No Middle 06 08 2020   grade_8 127 2 11 1   3     0   3   74 73 *                     147.0 127 2 11 1   3     0   3   74 73                 147
1367982 1367982 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Middle 03 08 2020   grade_8 4 2 82 0   3     0   0   48 43 *                     91.0 4 2 82 0   3     0   0   48 43                 91
1367986 1367986 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2020   grade_8 2 1 146 0   0     0   0   74 73 *                     149.0 2 1 146 0   0     0   0   74 73                 149
1368003 1368003 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2020   grade_8 0 3 105 0   1     0   0   50 59 *                     109.0 0 3 105 0   1     0   0   50 59                 109
1368007 1368007 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2020   grade_8 7 0 130 0   0     0   2   58 81 *                     139.0 7 0 130 0   0     0   2   58 81                 139
1368020 1368020 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2020   grade_8 6 0 110 0   1     0   1   62 56 *                     118.0 6 0 110 0   1     0   1   62 56                 118
1368039 1368039 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2020   grade_8 0 1 65 0   2     0   0   31 37 *                     68.0 0 1 65 0   2     0   0   31 37                 68
1368042 1368042 MA Essex   school 2506660 149   Lawrence 250666002758 1490085 Spark Academy   Regular School No Middle 06 08 2020   grade_8 3 3 146 0   4     0   0   81 75 *                     156.0 3 3 146 0   4     0   0   81 75                 156
1368045 1368045 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No Middle 06 08 2020   grade_8 0 1 102 0   1     0   0   60 44 *                     104.0 0 1 102 0   1     0   0   60 44                 104
1368054 1368054 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2020   grade_8 9 4 112 0   4     0   0   58 71 *                     129.0 9 4 112 0   4     0   0   58 71                 129
1368063 1368063 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other KG 12 2020   grade_8 1 0 12 0   0     0   0   11 2 *                     13.0 1 0 12 0   0     0   0   11 2                 13
1368585 1368585 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No Middle 06 08 2020   grade_8 28 40 274 0   21     0   10   187 186 *                     373.0 28 40 274 0   21     0   10   187 186                 373
1368588 1368588 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No Middle 06 08 2020   grade_8 29 21 231 0   29     0   10   172 148 *                     320.0 29 21 231 0   29     0   10   172 148                 320
1368591 1368591 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Pickering Middle   Regular School No Middle 06 08 2020   grade_8 57 8 89 1   16     0   10   100 81 *                     181.0 57 8 89 1   16     0   10   100 81                 181
1368602 1368602 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No High 06 12 2020   grade_8 3 2 6 0   0     0   1   9 3 *                     12.0 3 2 6 0   0     0   1   9 3                 12
1368610 1368610 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No Other PK 12 2020   grade_8 37 29 194 0   15     0   12   159 128 *                     287.0 37 29 194 0   15     0   12   159 128                 287
1368630 1368630 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield Middle School   Regular School No Middle 05 08 2020   grade_8 153 2 9 0   7     0   4   85 90 *                     175.0 153 2 9 0   7     0   4   85 90                 175
1368714 1368714 MA Essex   school 2507260 168   Marblehead 250726001789 1680300 Marblehead Veterans Middle School   Regular School No Middle 07 08 2020   grade_8 188 10 18 2   2     0   8   112 116 *                     228.0 188 10 18 2   2     0   8   112 116                 228
1368947 1368947 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No Elementary PK 08 2020   grade_8 77 1 46 0   10     0   7   70 71 *                     141.0 77 1 46 0   10     0   7   70 71                 141

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