enrollments

Data source: Big Local News · About: Big Local

575 rows where grade = "grade_6", state = "MA" and year = 2015 sorted by county

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 575 ✖

grade ✖

  • grade_6 · 575 ✖
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
735970 735970 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No 2 06 07 2015   grade_6 275 28 35 3   5     2   15   209 154                       363 275 28 35 3   5     2   15   209 154                 363
736976 736976 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No 2 05 08 2015   grade_6 156 3 5 1   5     0   12   101 81                       182 156 3 5 1   5     0   12   101 81                 182
738150 738150 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No 2 05 06 2015   grade_6 242 10 8 4   6     0   20   141 149                       290 242 10 8 4   6     0   20   141 149                 290
739730 739730 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No 1 03 06 2015   grade_6 125 5 5 8   4     0   2   67 82                       149 125 5 5 8   4     0   2   67 82                 149
741042 741042 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No 1 PK 08 2015   grade_6 9 0 3 0   0     0   3   9 6                       15 9 0 3 0   0     0   3   9 6                 15
741396 741396 MA Barnstable   school 2510470 261   Sandwich 251047001672 2610005 Henry T Wing   Regular School No 1 PK 06 2015   grade_6 62 1 0 0   5     0   0   39 29                       68 62 1 0 0   5     0   0   39 29                 68
741403 741403 MA Barnstable   school 2510470 261   Sandwich 251047002534 2610010 Forestdale   Regular School No 1 KG 06 2015   grade_6 83 1 1 1   1     0   0   44 43                       87 83 1 1 1   1     0   0   44 43                 87
741410 741410 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No 1 KG 06 2015   grade_6 75 0 1 2   2     0   1   40 41                       81 75 0 1 2   2     0   1   40 41                 81
743518 743518 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes 2 06 08 2015   grade_6 72 0 5 0   1     0   2   30 50                       80 72 0 5 0   1     0   2   30 50                 80
744198 744198 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No 2 06 07 2015   grade_6 163 17 19 9   4     0   14   123 103                       226 163 17 19 9   4     0   14   123 103                 226
744259 744259 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No 2 06 08 2015   grade_6 152 3 8 0   3     0   3   72 97                       169 152 3 8 0   3     0   3   72 97                 169
744507 744507 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No 2 05 07 2015   grade_6 117 7 5 1   0     0   5   60 75                       135 117 7 5 1   0     0   5   60 75                 135
737606 737606 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No 1 KG 08 2015   grade_6 17 0 1 0   0     0   0   7 11                       18 17 0 1 0   0     0   0   7 11                 18
738210 738210 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   grade_6 6 0 0 0   0     0   0   1 5                       6 6 0 0 0   0     0   0   1 5                 6
738519 738519 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No 1 PK 06 2015   grade_6 6 0 0 0   0     0   0   4 2                       6 6 0 0 0   0     0   0   4 2                 6
738886 738886 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No 1 PK 06 2015   grade_6 34 0 0 0   1     0   2   14 23                       37 34 0 0 0   1     0   2   14 23                 37
739033 739033 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No 1 PK 06 2015   grade_6 54 0 3 0   1     0   0   25 33                       58 54 0 3 0   1     0   0   25 33                 58
739061 739061 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No 4 06 12 2015   grade_6 44 1 4 0   9     0   1   31 28                       59 44 1 4 0   9     0   1   31 28                 59
740433 740433 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 J S Sullivan   Regular School No 1 KG 07 2015   grade_6 27 0 0 0   0     0   4   17 14                       31 27 0 0 0   0     0   4   17 14                 31
740441 740441 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 Greylock   Regular School No 1 KG 07 2015   grade_6 20 1 2 0   1     0   1   15 10                       25 20 1 2 0   1     0   1   15 10                 25
740450 740450 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No 1 PK 07 2015   grade_6 38 2 2 0   0     1   3   23 23                       46 38 2 2 0   0     1   3   23 23                 46
740942 740942 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 John T Reid Middle   Regular School No 2 06 08 2015   grade_6 123 19 26 0   0     0   13   87 94                       181 123 19 26 0   0     0   13   87 94                 181
740945 740945 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Theodore Herberg Middle   Regular School No 2 06 08 2015   grade_6 155 21 23 1   6     0   7   114 99                       213 155 21 23 1   6     0   7   114 99                 213
741275 741275 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No 1 PK 08 2015   grade_6 8 1 1 0   0     0   0   1 9                       10 8 1 1 0   0     0   0   1 9                 10
742949 742949 MA Berkshire   school 2513020 341   Williamstown 251302002146 3410010 Williamstown Elementary   Regular School No 1 PK 06 2015   grade_6 48 1 6 0   3     0   7   37 28                       65 48 1 6 0   3     0   7   37 28                 65
743440 743440 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes 4 06 12 2015   grade_6 51 17 1 0   0     0   3   39 33                       72 51 17 1 0   0     0   3   39 33                 72
743984 743984 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2015   grade_6 90 5 0 0   1     0   0   56 40                       96 90 5 0 0   1     0   0   56 40                 96
744074 744074 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No 2 05 08 2015   grade_6 78 1 7 0   3     2   3   46 48                       94 78 1 7 0   3     2   3   46 48                 94
744170 744170 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No 2 06 08 2015   grade_6 135 1 4 1   2     0   5   75 73                       148 135 1 4 1   2     0   5   75 73                 148
744274 744274 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No 1 PK 06 2015   grade_6 16 1 0 0   0     0   1   11 7                       18 16 1 0 0   0     0   1   11 7                 18
744801 744801 MA Berkshire   school 2511040 765   Southern Berkshire 251104000428 7650035 Undermountain   Regular School No 1 PK 06 2015   grade_6 38 2 3 0   0     0   5   25 23                       48 38 2 3 0   0     0   5   25 23                 48
735680 735680 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No 2 05 08 2015   grade_6 113 1 1 0   1     0   0   55 61                       116 113 1 1 0   1     0   0   55 61                 116
735897 735897 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No 2 05 08 2015   grade_6 141 5 13 0   5     0   4   83 85                       168 141 5 13 0   5     0   4   83 85                 168
735901 735901 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No 2 05 08 2015   grade_6 96 8 17 0   7     2   10   80 60                       140 96 8 17 0   7     2   10   80 60                 140
735905 735905 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No 2 05 08 2015   grade_6 82 10 34 0   10     0   7   66 77                       143 82 10 34 0   10     0   7   66 77                 143
736071 736071 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No 2 05 08 2015   grade_6 83 0 2 0   0     0   2   39 48                       87 83 0 2 0   0     0   2   39 48                 87
737728 737728 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth Middle   Regular School No 2 06 08 2015   grade_6 293 7 6 1   9     0   4   151 169                       320 293 7 6 1   9     0   4   151 169                 320
737924 737924 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No 2 06 08 2015   grade_6 253 17 11 1   8     0   9   146 153                       299 253 17 11 1   8     0   9   146 153                 299
738025 738025 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Hastings Middle   Regular School No 2 06 08 2015   grade_6 124 2 8 2   5     0   2   77 66                       143 124 2 8 2   5     0   2   77 66                 143
738065 738065 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No 1 PK 06 2015   grade_6 40 7 16 0   6     0   5   31 43                       74 40 7 16 0   6     0   5   31 43                 74
738073 738073 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No 1 PK 08 2015   grade_6 29 2 21 0   3     0   4   32 27                       59 29 2 21 0   3     0   4   32 27                 59
738105 738105 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No 2 06 08 2015   grade_6 115 8 48 0   15     0   6   88 104                       192 115 8 48 0   15     0   6   88 104                 192
738108 738108 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No 2 06 08 2015   grade_6 112 13 30 0   6     1   13   98 77                       175 112 13 30 0   6     1   13   98 77                 175
738111 738111 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No 2 06 08 2015   grade_6 166 10 44 0   7     0   7   116 118                       234 166 10 44 0   7     0   7   116 118                 234
738118 738118 MA Bristol   school 2504830 95   Fall River 250483002696 950326 Stone Therapeutic Day Middle School   Regular School No 2 06 08 2015   grade_6 2 2 4 0   0     0   1   8 *                       9 2 2 4 0   0     0   1   8                   9
739617 739617 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Harold L Qualters Middle   Regular School No 2 06 08 2015   grade_6 325 15 8 0   19     0   12   193 186                       379 325 15 8 0   19     0   12   193 186                 379
740266 740266 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No 2 06 08 2015   grade_6 128 48 95 2   4     2   24   159 144                       303 128 48 95 2   4     2   24   159 144                 303
740269 740269 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No 2 06 08 2015   grade_6 191 27 96 4   2     2   10   183 149                       332 191 27 96 4   2     2   10   183 149                 332
740272 740272 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No 2 06 08 2015   grade_6 109 31 105 1   0     0   17   124 139                       263 109 31 105 1   0     0   17   124 139                 263
740285 740285 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No 4 06 12 2015   grade_6 * * * *   *     *   *   1 1                       2                         1 1                 2
740564 740564 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No 2 06 08 2015   grade_6 309 7 11 0   18     0   12   193 164                       357 309 7 11 0   18     0   12   193 164                 357
740666 740666 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton Middle   Regular School No 2 06 08 2015   grade_6 196 1 3 0   4     1   3   113 95                       208 196 1 3 0   4     1   3   113 95                 208
741506 741506 MA Bristol   school 2510590 265   Seekonk 251059001700 2650405 Dr. Kevin M. Hurley Middle School   Regular School No 2 06 08 2015   grade_6 156 1 7 0   6     0   1   86 85                       171 156 1 7 0   6     0   1   86 85                 171
741604 741604 MA Bristol   school 2510860 273   Somerset 251086002537 2730305 Somerset Middle School   Regular School No 2 06 08 2015   grade_6 191 1 4 0   3     1   4   114 90                       204 191 1 4 0   3     1   4   114 90                 204
742196 742196 MA Bristol   school 2511460 292   Swansea 251146001894 2920305 Joseph Case Jr High   Regular School No 2 06 08 2015   grade_6 151 2 4 0   3     0   6   87 79                       166 151 2 4 0   3     0   6   87 79                 166
742235 742235 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Joseph H Martin   Regular School No 2 05 07 2015   grade_6 162 37 29 0   4     0   7   111 128                       239 162 37 29 0   4     0   7   111 128                 239
742243 742243 MA Bristol   school 2511520 293   Taunton 251152002416 2930305 John F Parker Middle   Regular School No 2 05 07 2015   grade_6 91 20 35 0   1     0   4   77 74                       151 91 20 35 0   1     0   4   77 74                 151
742246 742246 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Benjamin Friedman Middle   Regular School No 2 05 07 2015   grade_6 192 16 24 1   2     0   10   138 107                       245 192 16 24 1   2     0   10   138 107                 245
742792 742792 MA Bristol   school 2512780 331   Westport 251278002094 3310305 Westport Middle   Regular School No 2 06 08 2015   grade_6 124 1 2 3   1     0   3   80 54                       134 124 1 2 3   1     0   3   80 54                 134
743872 743872 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 09 2015   grade_6 86 3 4 0   4     0   3   49 51                       100 86 3 4 0   4     0   3   49 51                 100
743893 743893 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes 4 05 12 2015   grade_6 36 11 35 0   2     0   6   44 46                       90 36 11 35 0   2     0   6   44 46                 90
744124 744124 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Raynham Middle School   Regular School No 2 05 08 2015   grade_6 172 5 6 0   4     0   7   92 102                       194 172 5 6 0   4     0   7   92 102                 194
744216 744216 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No 2 05 08 2015   grade_6 108 1 4 0   1     0   2   64 52                       116 108 1 4 0   1     0   2   64 52                 116
744220 744220 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dorothy L Beckwith   Regular School No 2 05 08 2015   grade_6 132 2 6 0   0     0   6   83 63                       146 132 2 6 0   0     0   6   83 63                 146
744287 744287 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville Middle School   Regular School No 2 06 08 2015   grade_6 242 0 4 0   2     0   4   133 119                       252 242 0 4 0   2     0   4   133 119                 252
745172 745172 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes 2 06 06 2015   grade_6 60 17 21 1   0     0   4   58 45                       103 60 17 21 1   0     0   4   58 45                 103
737938 737938 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No 1 PK 08 2015   grade_6 34 1 2 2   0     0   0   17 22                       39 34 1 2 2   0     0   0   17 22                 39
740736 740736 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No 1 PK 08 2015   grade_6 40 3 8 1   1     0   3   28 28                       56 40 3 8 1   1     0   3   28 28                 56
742285 742285 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No 1 PK 08 2015   grade_6 26 1 6 1   1     0   3   17 21                       38 26 1 6 1   1     0   3   17 21                 38
743720 743720 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2015   grade_6 12 1 1 0   2     0   1   11 6                       17 12 1 1 0   2     0   1   11 6                 17
744909 744909 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No 1 PK 08 2015   grade_6 16 2 1 1   0     0   0   9 11                       20 16 2 1 1   0     0   0   9 11                 20
735727 735727 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No 2 05 08 2015   grade_6 150 4 11 0   1     0   9   95 80                       175 150 4 11 0   1     0   9   95 80                 175
735792 735792 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No 2 06 08 2015   grade_6 150 1 9 0   24     0   6   90 100                       190 150 1 9 0   24     0   6   90 100                 190
735795 735795 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No 2 06 08 2015   grade_6 138 2 8 1   30     0   3   92 90                       182 138 2 8 1   30     0   3   92 90                 182
735798 735798 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No 2 06 08 2015   grade_6 104 7 5 0   38     0   4   67 91                       158 104 7 5 0   38     0   4   67 91                 158
736112 736112 MA Essex   school 2502640 30   Beverly 250264000165 300305 Briscoe Middle   Regular School No 2 06 08 2015   grade_6 268 9 30 0   7     0   8   170 152                       322 268 9 30 0   7     0   8   170 152                 322
736990 736990 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No 1 03 06 2015   grade_6 102 1 2 0   7     1   1   56 58                       114 102 1 2 0   7     1   1   56 58                 114
737701 737701 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No 2 06 08 2015   grade_6 247 4 18 0   6     0   7   140 142                       282 247 4 18 0   6     0   7   140 142                 282
738380 738380 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No 2 06 08 2015   grade_6 113 0 0 0   2     0   1   62 54                       116 113 0 0 0   2     0   1   62 54                 116
738418 738418 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No 2 06 08 2015   grade_6 161 0 20 2   0     2   3   88 100                       188 161 0 20 2   0     2   3   88 100                 188
738589 738589 MA Essex   school 2505970 128   Haverhill 250597000848 1280035 Caleb Dustin Hunking   Regular School No 2 06 08 2015   grade_6 110 6 20 0   3     0   0   71 68                       139 110 6 20 0   3     0   0   71 68                 139
738594 738594 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No 2 05 08 2015   grade_6 88 2 46 0   2     0   0   70 68                       138 88 2 46 0   2     0   0   70 68                 138
738603 738603 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No 4 02 12 2015   grade_6 * * * *   *     *   *   1 1                       2                         1 1                 2
738619 738619 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No 2 05 08 2015   grade_6 97 1 29 0   1     0   0   74 54                       128 97 1 29 0   1     0   0   74 54                 128
738628 738628 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 KG 08 2015   grade_6 140 8 62 1   1     0   2   108 106                       214 140 8 62 1   1     0   2   108 106                 214
738864 738864 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich Middle School   Regular School No 2 06 08 2015   grade_6 153 1 6 0   4     0   5   90 79                       169 153 1 6 0   4     0   5   90 79                 169
738907 738907 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No 1 03 08 2015   grade_6 1 1 88 0   3     0   0   53 40                       93 1 1 88 0   3     0   0   53 40                 93
738912 738912 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No 2 05 08 2015   grade_6 0 3 135 0   0     0   0   76 62                       138 0 3 135 0   0     0   0   76 62                 138
738929 738929 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No 2 05 08 2015   grade_6 4 1 108 0   4     0   1   61 57                       118 4 1 108 0   4     0   1   61 57                 118
738933 738933 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No 2 05 08 2015   grade_6 12 1 94 0   1     0   1   60 49                       109 12 1 94 0   1     0   1   60 49                 109
738947 738947 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No 2 06 08 2015   grade_6 1 1 102 0   1     0   0   52 53                       105 1 1 102 0   1     0   0   52 53                 105
738966 738966 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No 1 KG 08 2015   grade_6 5 0 77 0   4     0   1   51 36                       87 5 0 77 0   4     0   1   51 36                 87
738970 738970 MA Essex   school 2506660 149   Lawrence 250666002758 1490085 Spark Academy   Regular School No 2 05 07 2015   grade_6 12 1 133 0   6     0   0   64 88                       152 12 1 133 0   6     0   0   64 88                 152
738972 738972 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No 2 06 08 2015   grade_6 0 1 99 0   0     0   0   55 45                       100 0 1 99 0   0     0   0   55 45                 100
738976 738976 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No 2 05 08 2015   grade_6 17 2 107 0   7     0   1   74 60                       134 17 2 107 0   7     0   1   74 60                 134
739014 739014 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2015   grade_6 1 0 19 0   0     0   0   16 4                       20 1 0 19 0   0     0   0   16 4                 20
739482 739482 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No 1 01 06 2015   grade_6 3 1 3 0   0     0   0   5 2                       7 3 1 3 0   0     0   0   5 2                 7
739508 739508 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No 2 06 08 2015   grade_6 36 39 213 0   27     0   12   182 145                       327 36 39 213 0   27     0   12   182 145                 327
739511 739511 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No 2 06 08 2015   grade_6 66 43 242 1   46     0   12   225 185                       410 66 43 242 1   46     0   12   225 185                 410
739514 739514 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Pickering Middle   Regular School No 2 06 08 2015   grade_6 97 13 69 1   21     0   9   113 97                       210 97 13 69 1   21     0   9   113 97                 210

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