enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 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
2040120 2040120 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No Middle 06 07 2019   grade_6 288 31 56 0   10     2   12   201 198                       399.0 288 31 56 0   10     2   12   201 198                 399
2041123 2041123 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 05 08 2019   grade_6 136 2 11 2   2     0   9   94 68                       162.0 136 2 11 2   2     0   9   94 68                 162
2042306 2042306 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No Middle 05 06 2019   grade_6 210 16 15 2   10     0   16   136 133                       269.0 210 16 15 2   10     0   16   136 133                 269
2043871 2043871 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2019   grade_6 106 4 5 9   4     0   12   68 72                       140.0 106 4 5 9   4     0   12   68 72                 140
2045171 2045171 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2019   grade_6 2 6 1 0   0     0   0   3 6                       9.0 2 6 1 0   0     0   0   3 6                 9
2045520 2045520 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No Elementary 03 06 2019   grade_6 194 4 3 1   2     0   4   107 101                       208.0 194 4 3 1   2     0   4   107 101                 208
2047649 2047649 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2019   grade_6 71 1 4 1   2     0   2   34 47                       81.0 71 1 4 1   2     0   2   34 47                 81
2048314 2048314 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No Middle 06 07 2019   grade_6 160 19 32 6   6     0   12   119 116                       235.0 160 19 32 6   6     0   12   119 116                 235
2048379 2048379 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No Middle 06 08 2019   grade_6 164 9 12 1   3     0   3   94 98                       192.0 164 9 12 1   3     0   3   94 98                 192
2048625 2048625 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No Middle 05 07 2019   grade_6 146 14 14 0   2     1   4   97 84                       181.0 146 14 14 0   2     1   4   97 84                 181
2041758 2041758 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2019   grade_6 21 0 0 0   0     0   2   12 11                       23.0 21 0 0 0   0     0   2   12 11                 23
2042368 2042368 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_6 12 1 0 0   0     0   0   7 6                       13.0 12 1 0 0   0     0   0   7 6                 13
2042674 2042674 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2019   grade_6 * * * *   *     *   *   3 2                       5.0                         3 2                 5
2043160 2043160 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No Elementary PK 06 2019   grade_6 30 0 4 0   3     0   2   11 28                       39.0 30 0 4 0   3     0   2   11 28                 39
2043189 2043189 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No High 06 12 2019   grade_6 46 0 4 0   2     0   2   31 23                       54.0 46 0 4 0   2     0   2   31 23                 54
2044570 2044570 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 Colegrove Park Elementary   Regular School No Elementary PK 06 2019   grade_6 42 1 1 0   1     0   1   22 24                       46.0 42 1 1 0   1     0   1   22 24                 46
2044578 2044578 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 Greylock   Regular School No Elementary PK 06 2019   grade_6 25 1 4 0   0     1   3   20 14                       34.0 25 1 4 0   0     1   3   20 14                 34
2044586 2044586 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No Elementary PK 06 2019   grade_6 34 1 3 0   0     0   3   21 20                       41.0 34 1 3 0   0     0   3   21 20                 41
2045071 2045071 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 John T Reid Middle   Regular School No Middle 06 08 2019   grade_6 127 30 20 1   0     0   16   89 105                       194.0 127 30 20 1   0     0   16   89 105                 194
2045074 2045074 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Theodore Herberg Middle   Regular School No Middle 06 08 2019   grade_6 149 31 32 0   2     0   13   114 113                       227.0 149 31 32 0   2     0   13   114 113                 227
2045404 2045404 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2019   grade_6 18 1 2 0   0     0   0   10 11                       21.0 18 1 2 0   0     0   0   10 11                 21
2047555 2047555 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 2019   grade_6 39 6 6 1   2     0   5   33 26                       59.0 39 6 6 1   2     0   5   33 26                 59
2048109 2048109 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Middle School   Regular School No Middle 04 07 2019   grade_6 85 6 6 0   0     0   0   51 46                       97.0 85 6 6 0   0     0   0   51 46                 97
2048195 2048195 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No Middle 05 08 2019   grade_6 69 3 8 0   2     0   5   50 37                       87.0 69 3 8 0   2     0   5   50 37                 87
2048286 2048286 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No Middle 06 08 2019   grade_6 114 2 5 0   0     0   3   70 54                       124.0 114 2 5 0   0     0   3   70 54                 124
2048394 2048394 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2019   grade_6 13 0 0 0   0     0   0   8 5                       13.0 13 0 0 0   0     0   0   8 5                 13
2048640 2048640 MA Berkshire   school 2508160 715   Mount Greylock 250816002887 7150005 Lanesborough Elementary   Regular School No Elementary PK 06 2019   grade_6 29 1 0 0   0     0   0   14 16                       30.0 29 1 0 0   0     0   0   14 16                 30
2048648 2048648 MA Berkshire   school 2508160 715   Mount Greylock 250816002899 7150010 Williamstown Elementary   Regular School No Elementary PK 06 2019   grade_6 49 0 4 0   0     0   4   33 24                       57.0 49 0 4 0   0     0   4   33 24                 57
2048930 2048930 MA Berkshire   school 2511040 765   Southern Berkshire 251104000428 7650035 Undermountain   Regular School No Elementary PK 06 2019   grade_6 46 0 3 1   0     0   4   30 24                       54.0 46 0 3 1   0     0   4   30 24                 54
2039832 2039832 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2019   grade_6 94 0 5 0   1     0   5   57 48                       105.0 94 0 5 0   1     0   5   57 48                 105
2040048 2040048 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2019   grade_6 120 9 24 0   6     0   10   98 71                       169.0 120 9 24 0   6     0   10   98 71                 169
2040052 2040052 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2019   grade_6 104 10 37 0   9     0   5   91 73                       165.0 104 10 37 0   9     0   5   91 73                 165
2040056 2040056 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No Middle 05 08 2019   grade_6 87 11 19 0   12     0   7   64 72                       136.0 87 11 19 0   12     0   7   64 72                 136
2040216 2040216 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2019   grade_6 84 0 4 0   0     0   2   44 46                       90.0 84 0 4 0   0     0   2   44 46                 90
2041881 2041881 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth Middle   Regular School No Middle 06 08 2019   grade_6 272 3 11 0   2     1   18   173 134                       307.0 272 3 11 0   2     1   18   173 134                 307
2042073 2042073 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No Middle 06 08 2019   grade_6 251 22 15 0   7     0   8   151 152                       303.0 251 22 15 0   7     0   8   151 152                 303
2042179 2042179 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Hastings Middle   Regular School No Middle 06 08 2019   grade_6 132 1 6 2   3     0   4   79 69                       148.0 132 1 6 2   3     0   4   79 69                 148
2042221 2042221 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No Elementary PK 08 2019   grade_6 26 5 37 0   5     0   10   39 44                       83.0 26 5 37 0   5     0   10   39 44                 83
2042231 2042231 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No Elementary PK 08 2019   grade_6 23 2 23 0   0     0   5   27 26                       53.0 23 2 23 0   0     0   5   27 26                 53
2042259 2042259 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No Middle 06 08 2019   grade_6 87 8 65 0   10     0   14   101 83                       184.0 87 8 65 0   10     0   14   101 83                 184
2042262 2042262 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No Middle 06 08 2019   grade_6 127 19 47 1   6     1   23   107 117                       224.0 127 19 47 1   6     1   23   107 117                 224
2042265 2042265 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No Middle 06 08 2019   grade_6 139 18 64 0   11     0   22   111 143                       254.0 139 18 64 0   11     0   22   111 143                 254
2042269 2042269 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2019   grade_6 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2043759 2043759 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Harold L Qualters Middle   Regular School No Middle 06 08 2019   grade_6 222 11 17 1   13     0   5   146 123                       269.0 222 11 17 1   13     0   5   146 123                 269
2044401 2044401 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No Middle 06 08 2019   grade_6 127 56 149 1   6     1   24   198 166                       364.0 127 56 149 1   6     1   24   198 166                 364
2044404 2044404 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No Middle 06 08 2019   grade_6 179 38 150 3   2     0   30   218 184                       402.0 179 38 150 3   2     0   30   218 184                 402
2044407 2044407 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No Middle 06 08 2019   grade_6 116 47 139 0   0     0   20   162 160                       322.0 116 47 139 0   0     0   20   162 160                 322
2044415 2044415 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No Other 04 12 2019   grade_6 2 1 5 0   0     0   0   6 2                       8.0 2 1 5 0   0     0   0   6 2                 8
2044693 2044693 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No Middle 06 08 2019   grade_6 328 8 20 1   17     2   15   170 221                       391.0 328 8 20 1   17     2   15   170 221                 391
2044794 2044794 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton Middle   Regular School No Middle 06 08 2019   grade_6 179 3 7 0   3     0   11   99 104                       203.0 179 3 7 0   3     0   11   99 104                 203
2045614 2045614 MA Bristol   school 2510590 265   Seekonk 251059001700 2650405 Dr. Kevin M. Hurley Middle School   Regular School No Middle 06 08 2019   grade_6 156 0 8 0   4     0   11   103 76                       179.0 156 0 8 0   4     0   11   103 76                 179
2045712 2045712 MA Bristol   school 2510860 273   Somerset 251086002537 2730305 Somerset Middle School   Regular School No Middle 06 08 2019   grade_6 181 4 14 1   1     0   5   105 101                       206.0 181 4 14 1   1     0   5   105 101                 206
2046320 2046320 MA Bristol   school 2511460 292   Swansea 251146001894 2920305 Joseph Case Jr High   Regular School No Middle 06 08 2019   grade_6 182 1 4 0   0     0   2   102 87                       189.0 182 1 4 0   0     0   2   102 87                 189
2046361 2046361 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Joseph H Martin   Regular School No Middle 05 07 2019   grade_6 149 33 29 1   2     1   7   114 108                       222.0 149 33 29 1   2     1   7   114 108                 222
2046369 2046369 MA Bristol   school 2511520 293   Taunton 251152002416 2930305 John F Parker Middle   Regular School No Middle 05 07 2019   grade_6 96 35 31 0   2     1   7   86 86                       172.0 96 35 31 0   2     1   7   86 86                 172
2046372 2046372 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Benjamin Friedman Middle   Regular School No Middle 05 07 2019   grade_6 194 26 26 0   2     0   13   137 124                       261.0 194 26 26 0   2     0   13   137 124                 261
2046902 2046902 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport Elementary   Regular School No Elementary 03 06 2019   grade_6 104 0 4 0   1     0   9   72 46                       118.0 104 0 4 0   1     0   9   72 46                 118
2047522 2047522 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 08 2019   grade_6 8 10 31 0   0     0   0   21 28                       49.0 8 10 31 0   0     0   0   21 28                 49
2047990 2047990 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2019   grade_6 89 3 12 0   0     0   6   51 59                       110.0 89 3 12 0   0     0   6   51 59                 110
2048021 2048021 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes High 05 12 2019   grade_6 36 10 39 1   1     0   2   42 47                       89.0 36 10 39 1   1     0   2   42 47                 89
2048245 2048245 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Raynham Middle School   Regular School No Middle 05 08 2019   grade_6 161 10 0 0   3     0   6   113 67                       180.0 161 10 0 0   3     0   6   113 67                 180
2048334 2048334 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No Middle 05 08 2019   grade_6 83 1 6 0   1     0   5   46 50                       96.0 83 1 6 0   1     0   5   46 50                 96
2048338 2048338 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dorothy L Beckwith   Regular School No Middle 05 08 2019   grade_6 128 0 5 0   0     0   7   72 68                       140.0 128 0 5 0   0     0   7   72 68                 140
2049309 2049309 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Middle 06 10 2019   grade_6 71 8 24 0   1     0   6   57 53                       110.0 71 8 24 0   1     0   6   57 53                 110
2042088 2042088 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No Elementary PK 08 2019   grade_6 25 1 6 2   1     0   2   20 17                       37.0 25 1 6 2   1     0   2   20 17                 37
2044865 2044865 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No Elementary PK 08 2019   grade_6 38 1 9 1   0     0   5   29 25                       54.0 38 1 9 1   0     0   5   29 25                 54
2046410 2046410 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No Elementary PK 08 2019   grade_6 30 3 6 1   0     0   2   25 17                       42.0 30 3 6 1   0     0   2   25 17                 42
2047848 2047848 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2019   grade_6 14 1 4 0   0     0   2   10 11                       21.0 14 1 4 0   0     0   2   10 11                 21
2049028 2049028 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2019   grade_6 35 0 2 0   0     0   2   24 15                       39.0 35 0 2 0   0     0   2   24 15                 39
2039878 2039878 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2019   grade_6 132 3 9 0   2     1   4   71 80                       151.0 132 3 9 0   2     1   4   71 80                 151
2039943 2039943 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No Middle 06 08 2019   grade_6 139 3 11 1   23     1   5   96 87                       183.0 139 3 11 1   23     1   5   96 87                 183
2039946 2039946 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No Middle 06 08 2019   grade_6 124 4 9 0   27     0   7   95 76                       171.0 124 4 9 0   27     0   7   95 76                 171
2039949 2039949 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2019   grade_6 59 3 17 1   53     0   0   73 60                       133.0 59 3 17 1   53     0   0   73 60                 133
2040253 2040253 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly Middle School   Regular School No Middle 05 08 2019   grade_6 283 8 53 0   12     0   7   185 178                       363.0 283 8 53 0   12     0   7   185 178                 363
2041138 2041138 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No Elementary 03 06 2019   grade_6 94 1 0 0   5     0   0   48 52                       100.0 94 1 0 0   5     0   0   48 52                 100
2041853 2041853 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No Middle 06 08 2019   grade_6 221 11 26 1   4     0   10   137 136                       273.0 221 11 26 1   4     0   10   137 136                 273
2042540 2042540 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2019   grade_6 89 1 1 0   2     1   0   40 54                       94.0 89 1 1 0   2     1   0   40 54                 94
2042578 2042578 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No Middle 06 08 2019   grade_6 175 3 19 3   3     0   1   87 117                       204.0 175 3 19 3   3     0   1   87 117                 204
2042743 2042743 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Caleb Dustin Hunking School   Regular School No Elementary KG 08 2019   grade_6 115 10 29 0   4     0   3   83 78                       161.0 115 10 29 0   4     0   3   83 78                 161
2042751 2042751 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No Middle 05 08 2019   grade_6 72 5 47 1   4     1   6   72 64                       136.0 72 5 47 1   4     1   6   72 64                 136
2042770 2042770 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_6 4 0 3 0   0     0   1   7 *                       8.0 4 0 3 0   0     0   1   7                   8
2042787 2042787 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2019   grade_6 118 5 30 0   2     0   1   83 73                       156.0 118 5 30 0   2     0   1   83 73                 156
2042792 2042792 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 04 08 2019   grade_6 127 13 103 1   7     0   3   126 128                       254.0 127 13 103 1   7     0   3   126 128                 254
2043029 2043029 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich Middle School   Regular School No Middle 06 08 2019   grade_6 113 0 5 0   3     0   3   59 65                       124.0 113 0 5 0   3     0   3   59 65                 124
2043064 2043064 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Middle 03 08 2019   grade_6 6 0 67 0   1     0   0   32 42                       74.0 6 0 67 0   1     0   0   32 42                 74
2043068 2043068 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2019   grade_6 3 1 162 0   0     0   1   87 80                       167.0 3 1 162 0   0     0   1   87 80                 167
2043085 2043085 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2019   grade_6 4 0 108 0   0     0   1   53 60                       113.0 4 0 108 0   0     0   1   53 60                 113
2043089 2043089 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2019   grade_6 13 5 132 0   1     0   0   73 77                       151.0 13 5 132 0   1     0   0   73 77                 151
2043102 2043102 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2019   grade_6 1 0 106 0   0     0   0   57 50                       107.0 1 0 106 0   0     0   0   57 50                 107
2043121 2043121 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2019   grade_6 6 0 73 0   1     0   1   37 44                       81.0 6 0 73 0   1     0   1   37 44                 81
2043124 2043124 MA Essex   school 2506660 149   Lawrence 250666002758 1490085 Spark Academy   Regular School No Middle 06 08 2019   grade_6 4 2 141 0   3     0   2   91 61                       152.0 4 2 141 0   3     0   2   91 61                 152
2043127 2043127 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No Middle 06 08 2019   grade_6 2 0 69 0   0     0   1   34 38                       72.0 2 0 69 0   0     0   1   34 38                 72
2043136 2043136 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2019   grade_6 14 4 104 0   8     0   2   69 63                       132.0 14 4 104 0   8     0   2   69 63                 132
2043146 2043146 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2019   grade_6 2 0 11 0   0     0   1   11 3                       14.0 2 0 11 0   0     0   1   11 3                 14
2043651 2043651 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No Middle 06 08 2019   grade_6 39 48 322 0   33     0   7   232 217                       449.0 39 48 322 0   33     0   7   232 217                 449
2043654 2043654 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No Middle 06 08 2019   grade_6 63 55 348 1   49     0   13   263 266                       529.0 63 55 348 1   49     0   13   263 266                 529
2043657 2043657 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Pickering Middle   Regular School No Middle 06 08 2019   grade_6 74 24 110 1   24     0   15   128 120                       248.0 74 24 110 1   24     0   15   128 120                 248
2043675 2043675 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No High 06 12 2019   grade_6 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2043694 2043694 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield Middle School   Regular School No Middle 05 08 2019   grade_6 141 2 8 0   14     0   2   89 78                       167.0 141 2 8 0   14     0   2   89 78                 167
2043776 2043776 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Village School   Regular School No Middle 04 06 2019   grade_6 196 5 13 0   3     0   7   121 103                       224.0 196 5 13 0   3     0   7   121 103                 224

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