enrollments

Data source: Big Local News · About: Big Local

572 rows where grade = "grade_6", state = "MA" and year = 2020 sorted by county

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 572 ✖

grade ✖

  • grade_6 · 572 ✖
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
1365094 1365094 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No Middle 06 07 2020   grade_6 242 24 78 4   8     1   18   202 173 *                     375.0 242 24 78 4   8     1   18   202 173                 375
1366064 1366064 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 06 08 2020   grade_6 149 5 8 4   4     0   4   80 94 *                     174.0 149 5 8 4   4     0   4   80 94                 174
1367236 1367236 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No Middle 05 06 2020   grade_6 217 9 15 11   4     0   24   148 132 *                     280.0 217 9 15 11   4     0   24   148 132                 280
1368800 1368800 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2020   grade_6 97 6 4 8   2     0   6   63 60 *                     123.0 97 6 4 8   2     0   6   63 60                 123
1370097 1370097 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2020   grade_6 10 2 2 0   0     0   3   9 8 *                     17.0 10 2 2 0   0     0   3   9 8                 17
1370446 1370446 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No Elementary 03 06 2020   grade_6 187 4 3 2   5     0   2   101 102 *                     203.0 187 4 3 2   5     0   2   101 102                 203
1371352 1371352 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2020   grade_6 * * * *   *     *   *   2 3 *                     5.0                         2 3                 5
1372577 1372577 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_6 71 1 4 0   2     0   3   42 39 *                     81.0 71 1 4 0   2     0   3   42 39                 81
1373252 1373252 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No Middle 06 07 2020   grade_6 133 29 44 7   4     1   12   119 111 *                     230.0 133 29 44 7   4     1   12   119 111                 230
1373317 1373317 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No Middle 06 08 2020   grade_6 154 7 14 0   5     0   5   95 89 *                     185.0 154 7 14 0   5     0   5   95 89                 185
1373564 1373564 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No Middle 05 07 2020   grade_6 102 8 9 2   2     0   13   65 71 *                     136.0 102 8 9 2   2     0   13   65 71                 136
1366688 1366688 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2020   grade_6 33 0 0 0   0     0   1   14 20 *                     34.0 33 0 0 0   0     0   1   14 20                 34
1367296 1367296 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2020   grade_6 14 0 0 0   0     0   0   9 5 *                     14.0 14 0 0 0   0     0   0   9 5                 14
1367601 1367601 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2020   grade_6 * * * *   *     *   *   2 2 *                     4.0                         2 2                 4
1368076 1368076 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No Elementary PK 06 2020   grade_6 29 0 5 0   3     0   1   15 22 *                     38.0 29 0 5 0   3     0   1   15 22                 38
1368105 1368105 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No High 06 12 2020   grade_6 52 1 4 0   3     0   4   35 29 *                     64.0 52 1 4 0   3     0   4   35 29                 64
1369497 1369497 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 Colegrove Park Elementary   Regular School No Elementary PK 06 2020   grade_6 24 3 2 0   0     0   2   16 15 *                     31.0 24 3 2 0   0     0   2   16 15                 31
1369505 1369505 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 Greylock   Regular School No Elementary PK 06 2020   grade_6 24 1 2 0   0     1   4   17 15 *                     32.0 24 1 2 0   0     1   4   17 15                 32
1369513 1369513 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No Elementary PK 06 2020   grade_6 27 4 3 0   0     0   0   18 16 *                     34.0 27 4 3 0   0     0   0   18 16                 34
1369997 1369997 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 John T Reid Middle   Regular School No Middle 06 08 2020   grade_6 108 17 28 1   2     0   21   98 79 *                     177.0 108 17 28 1   2     0   21   98 79                 177
1370000 1370000 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Theodore Herberg Middle   Regular School No Middle 06 08 2020   grade_6 127 9 25 1   3     0   9   87 87 *                     174.0 127 9 25 1   3     0   9   87 87                 174
1370331 1370331 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2020   grade_6 11 0 2 0   0     0   1   4 10 *                     14.0 11 0 2 0   0     0   1   4 10                 14
1372482 1372482 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_6 50 9 9 0   1     0   3   39 33 *                     72.0 50 9 9 0   1     0   3   39 33                 72
1373037 1373037 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Middle School   Regular School No Middle 04 07 2020   grade_6 97 3 2 0   0     0   2   52 52 *                     104.0 97 3 2 0   0     0   2   52 52                 104
1373121 1373121 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No Middle 05 08 2020   grade_6 62 0 10 0   3     0   4   42 37 *                     79.0 62 0 10 0   3     0   4   42 37                 79
1373225 1373225 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No Middle 06 08 2020   grade_6 105 0 3 1   0     0   1   55 55 *                     110.0 105 0 3 1   0     0   1   55 55                 110
1373331 1373331 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2020   grade_6 13 0 0 0   0     0   0   11 2 *                     13.0 13 0 0 0   0     0   0   11 2                 13
1373578 1373578 MA Berkshire   school 2508160 715   Mount Greylock 250816002887 7150005 Lanesborough Elementary   Regular School No Elementary PK 06 2020   grade_6 23 1 0 0   0     0   0   15 9 *                     24.0 23 1 0 0   0     0   0   15 9                 24
1373586 1373586 MA Berkshire   school 2508160 715   Mount Greylock 250816002899 7150010 Williamstown Elementary   Regular School No Elementary PK 06 2020   grade_6 44 0 7 0   0     0   1   23 29 *                     52.0 44 0 7 0   0     0   1   23 29                 52
1373858 1373858 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Mt Everett Regional   Regular School No High 06 12 2020   grade_6 35 0 2 0   0     0   2   21 18 *                     39.0 35 0 2 0   0     0   2   21 18                 39
1364806 1364806 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2020   grade_6 97 1 2 0   1     0   0   57 44 *                     101.0 97 1 2 0   1     0   0   57 44                 101
1365021 1365021 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2020   grade_6 111 16 9 2   10     0   14   82 80 *                     162.0 111 16 9 2   10     0   14   82 80                 162
1365025 1365025 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2020   grade_6 94 2 20 0   10     0   15   69 72 *                     141.0 94 2 20 0   10     0   15   69 72                 141
1365029 1365029 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No Middle 05 08 2020   grade_6 108 8 27 0   6     0   8   86 71 *                     157.0 108 8 27 0   6     0   8   86 71                 157
1365190 1365190 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2020   grade_6 107 0 1 0   0     0   6   59 55 *                     114.0 107 0 1 0   0     0   6   59 55                 114
1366811 1366811 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth Middle   Regular School No Middle 06 08 2020   grade_6 245 3 13 0   2     0   9   117 155 *                     272.0 245 3 13 0   2     0   9   117 155                 272
1367001 1367001 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No Middle 06 08 2020   grade_6 223 15 18 0   13     0   8   141 136 *                     277.0 223 15 18 0   13     0   8   141 136                 277
1367106 1367106 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Hastings Middle   Regular School No Middle 06 08 2020   grade_6 125 6 14 1   4     0   5   79 76 *                     155.0 125 6 14 1   4     0   5   79 76                 155
1367148 1367148 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No Elementary PK 08 2020   grade_6 35 6 29 0   4     0   13   55 32 *                     87.0 35 6 29 0   4     0   13   55 32                 87
1367158 1367158 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No Elementary PK 08 2020   grade_6 25 4 18 0   1     0   3   28 23 *                     51.0 25 4 18 0   1     0   3   28 23                 51
1367187 1367187 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No Middle 06 08 2020   grade_6 81 14 60 1   6     0   25   97 90 *                     187.0 81 14 60 1   6     0   25   97 90                 187
1367190 1367190 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No Middle 06 08 2020   grade_6 117 16 53 1   9     0   18   122 92 *                     214.0 117 16 53 1   9     0   18   122 92                 214
1367193 1367193 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No Middle 06 08 2020   grade_6 145 18 57 0   13     0   23   122 134 *                     256.0 145 18 57 0   13     0   23   122 134                 256
1368693 1368693 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Harold L Qualters Middle   Regular School No Middle 06 08 2020   grade_6 231 9 20 0   16     0   7   149 134 *                     283.0 231 9 20 0   16     0   7   149 134                 283
1369328 1369328 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No Middle 06 08 2020   grade_6 120 59 143 2   3     0   34   202 159 *                     361.0 120 59 143 2   3     0   34   202 159                 361
1369331 1369331 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No Middle 06 08 2020   grade_6 182 32 136 0   5     0   12   201 166 *                     367.0 182 32 136 0   5     0   12   201 166                 367
1369334 1369334 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No Middle 06 08 2020   grade_6 101 43 128 1   0     1   14   146 142 *                     288.0 101 43 128 1   0     1   14   146 142                 288
1369343 1369343 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No Other 04 12 2020   grade_6 6 2 2 0   0     0   1   9 2 *                     11.0 6 2 2 0   0     0   1   9 2                 11
1369620 1369620 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No Middle 06 08 2020   grade_6 268 12 19 1   22     0   16   161 177 *                     338.0 268 12 19 1   22     0   16   161 177                 338
1369720 1369720 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton Middle   Regular School No Middle 06 08 2020   grade_6 182 5 4 0   7     0   9   103 104 *                     207.0 182 5 4 0   7     0   9   103 104                 207
1370539 1370539 MA Bristol   school 2510590 265   Seekonk 251059001700 2650405 Dr. Kevin M. Hurley Middle School   Regular School No Middle 06 08 2020   grade_6 111 4 11 0   13     0   5   72 72 *                     144.0 111 4 11 0   13     0   5   72 72                 144
1370636 1370636 MA Bristol   school 2510860 273   Somerset 251086002537 2730305 Somerset Middle School   Regular School No Middle 06 08 2020   grade_6 197 4 12 1   3     0   5   105 117 *                     222.0 197 4 12 1   3     0   5   105 117                 222
1371244 1371244 MA Bristol   school 2511460 292   Swansea 251146001894 2920305 Joseph Case Jr High   Regular School No Middle 06 08 2020   grade_6 169 0 3 1   4     0   1   81 97 *                     178.0 169 0 3 1   4     0   1   81 97                 178
1371285 1371285 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Joseph H Martin   Regular School No Middle 05 07 2020   grade_6 157 38 23 0   2     0   13   124 109 *                     233.0 157 38 23 0   2     0   13   124 109                 233
1371293 1371293 MA Bristol   school 2511520 293   Taunton 251152002416 2930305 John F Parker Middle   Regular School No Middle 05 07 2020   grade_6 86 32 25 2   1     1   9   68 88 *                     156.0 86 32 25 2   1     1   9   68 88                 156
1371296 1371296 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Benjamin Friedman Middle   Regular School No Middle 05 07 2020   grade_6 204 27 16 0   2     0   11   137 123 *                     260.0 204 27 16 0   2     0   11   137 123                 260
1371828 1371828 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport Elementary   Regular School No Elementary 03 06 2020   grade_6 102 0 4 0   0     0   7   67 46 *                     113.0 102 0 4 0   0     0   7   67 46                 113
1372449 1372449 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_6 28 15 51 0   0     0   2   40 56 *                     96.0 28 15 51 0   0     0   2   40 56                 96
1372918 1372918 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2020   grade_6 91 2 15 0   2     0   0   51 59 *                     110.0 91 2 15 0   2     0   0   51 59                 110
1372949 1372949 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_6 38 10 39 0   2     0   4   48 45 *                     93.0 38 10 39 0   2     0   4   48 45                 93
1373182 1373182 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002657 6250300 Williams Intermediate School   Regular School No Middle 04 06 2020   grade_6 217 22 7 0   6     0   8   134 126 *                     260.0 217 22 7 0   6     0   8   134 126                 260
1373184 1373184 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Raynham Middle School   Regular School No Middle 05 08 2020   grade_6 145 15 1 0   5     0   5   92 79 *                     171.0 145 15 1 0   5     0   5   92 79                 171
1373272 1373272 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No Middle 05 08 2020   grade_6 95 2 5 0   1     0   4   62 45 *                     107.0 95 2 5 0   1     0   4   62 45                 107
1373276 1373276 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dorothy L Beckwith   Regular School No Middle 05 08 2020   grade_6 123 2 7 1   2     0   5   69 71 *                     140.0 123 2 7 1   2     0   5   69 71                 140
1373343 1373343 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville Middle School   Regular School No Middle 06 09 2020   grade_6 223 4 0 0   2     0   3   121 111 *                     232.0 223 4 0 0   2     0   3   121 111                 232
1374234 1374234 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Secondary 06 11 2020   grade_6 57 15 40 0   3     1   2   59 59 *                     118.0 57 15 40 0   3     1   2   59 59                 118
1367016 1367016 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No Elementary PK 08 2020   grade_6 26 3 9 1   0     0   2   17 24 *                     41.0 26 3 9 1   0     0   2   17 24                 41
1369792 1369792 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No Elementary PK 08 2020   grade_6 32 2 15 0   1     0   2   25 27 *                     52.0 32 2 15 0   1     0   2   25 27                 52
1371334 1371334 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No Elementary PK 08 2020   grade_6 21 1 18 0   0     0   2   15 27 *                     42.0 21 1 18 0   0     0   2   15 27                 42
1372777 1372777 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_6 9 0 2 0   0     0   2   4 9 *                     13.0 9 0 2 0   0     0   2   4 9                 13
1373954 1373954 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2020   grade_6 47 1 3 1   0     0   5   25 32 *                     57.0 47 1 3 1   0     0   5   25 32                 57
1374313 1374313 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_6 * * * *   *     *   *   * * *                     0.0                                             0
1364851 1364851 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2020   grade_6 128 4 18 0   2     0   10   96 66 *                     162.0 128 4 18 0   2     0   10   96 66                 162
1364916 1364916 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No Middle 06 08 2020   grade_6 121 3 13 0   14     0   7   74 84 *                     158.0 121 3 13 0   14     0   7   74 84                 158
1364919 1364919 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No Middle 06 08 2020   grade_6 120 10 12 0   39     0   3   94 90 *                     184.0 120 10 12 0   39     0   3   94 90                 184
1364922 1364922 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2020   grade_6 69 3 9 0   37     1   6   56 69 *                     125.0 69 3 9 0   37     1   6   56 69                 125
1365220 1365220 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly Middle School   Regular School No Middle 05 08 2020   grade_6 295 13 58 0   8     1   17   205 187 *                     392.0 295 13 58 0   8     1   17   205 187                 392
1366079 1366079 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No Elementary 03 06 2020   grade_6 90 1 3 0   6     0   7   56 51 *                     107.0 90 1 3 0   6     0   7   56 51                 107
1366783 1366783 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No Middle 06 08 2020   grade_6 225 5 27 0   7     0   8   152 120 *                     272.0 225 5 27 0   7     0   8   152 120                 272
1367468 1367468 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2020   grade_6 112 1 1 0   0     1   1   59 57 *                     116.0 112 1 1 0   0     1   1   59 57                 116
1367506 1367506 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No Middle 06 08 2020   grade_6 178 3 26 1   3     0   7   112 106 *                     218.0 178 3 26 1   3     0   7   112 106                 218
1367660 1367660 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Caleb Dustin Hunking School   Regular School No Elementary KG 08 2020   grade_6 114 12 43 1   3     0   1   90 84 *                     174.0 114 12 43 1   3     0   1   90 84                 174
1367668 1367668 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No Middle 05 08 2020   grade_6 54 8 69 0   2     0   2   76 59 *                     135.0 54 8 69 0   2     0   2   76 59                 135
1367686 1367686 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_6 * * * *   *     *   *   1 * *                     1.0                         1                   1
1367701 1367701 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2020   grade_6 60 7 64 0   2     1   3   60 77 *                     137.0 60 7 64 0   2     1   3   60 77                 137
1367705 1367705 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 05 08 2020   grade_6 83 4 108 0   7     0   4   116 90 *                     206.0 83 4 108 0   7     0   4   116 90                 206
1367710 1367710 MA Essex   school 2505970 128   Haverhill 250597002906 1280105 Tilton Upper Middle School   Regular School No Middle 04 06 2020   grade_6 6 2 19 0   0     0   0   15 12 *                     27.0 6 2 19 0   0     0   0   15 12                 27
1367946 1367946 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich Middle School   Regular School No Middle 06 08 2020   grade_6 106 2 10 0   2     0   5   67 58 *                     125.0 106 2 10 0   2     0   5   67 58                 125
1367980 1367980 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Middle 03 08 2020   grade_6 3 1 87 0   2     0   0   46 47 *                     93.0 3 1 87 0   2     0   0   46 47                 93
1367984 1367984 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2020   grade_6 4 0 140 1   0     0   0   69 75 *                     145.0 4 0 140 1   0     0   0   69 75                 145
1368001 1368001 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2020   grade_6 1 3 135 0   1     0   0   86 54 *                     140.0 1 3 135 0   1     0   0   86 54                 140
1368005 1368005 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2020   grade_6 6 0 153 0   1     0   1   78 83 *                     161.0 6 0 153 0   1     0   1   78 83                 161
1368018 1368018 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2020   grade_6 0 0 97 0   0     0   0   46 50 *                     97.0 0 0 97 0   0     0   0   46 50                 97
1368037 1368037 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2020   grade_6 5 1 72 0   0     0   0   36 42 *                     78.0 5 1 72 0   0     0   0   36 42                 78
1368040 1368040 MA Essex   school 2506660 149   Lawrence 250666002758 1490085 Spark Academy   Regular School No Middle 06 08 2020   grade_6 8 1 148 0   2     0   1   82 78 *                     160.0 8 1 148 0   2     0   1   82 78                 160
1368043 1368043 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No Middle 06 08 2020   grade_6 4 0 110 0   0     0   0   53 61 *                     114.0 4 0 110 0   0     0   0   53 61                 114
1368052 1368052 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2020   grade_6 11 3 117 0   2     0   5   78 60 *                     138.0 11 3 117 0   2     0   5   78 60                 138
1368061 1368061 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other KG 12 2020   grade_6 0 0 9 0   0     0   0   8 1 *                     9.0 0 0 9 0   0     0   0   8 1                 9
1368583 1368583 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No Middle 06 08 2020   grade_6 43 57 350 1   27     0   19   255 242 *                     497.0 43 57 350 1   27     0   19   255 242                 497
1368586 1368586 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No Middle 06 08 2020   grade_6 36 48 359 1   54     0   19   260 257 *                     517.0 36 48 359 1   54     0   19   260 257                 517

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