enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 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
932844 932844 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No 2 06 07 2016   grade_6 290 34 27 2   8     0   16   190 187                       377 290 34 27 2   8     0   16   190 187                 377
933841 933841 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No 2 05 08 2016   grade_6 172 4 1 2   6     0   2   90 97                       187 172 4 1 2   6     0   2   90 97                 187
935004 935004 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No 2 05 06 2016   grade_6 239 13 16 3   6     0   19   160 136                       296 239 13 16 3   6     0   19   160 136                 296
936574 936574 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No 1 03 06 2016   grade_6 109 5 4 8   2     0   3   72 59                       131 109 5 4 8   2     0   3   72 59                 131
937871 937871 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No 1 PK 08 2016   grade_6 4 2 3 0   0     0   0   4 5                       9 4 2 3 0   0     0   0   4 5                 9
938217 938217 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No 1 03 06 2016   grade_6 212 3 2 2   5     0   1   122 103                       225 212 3 2 2   5     0   1   122 103                 225
939111 939111 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No 1 PK 06 2016   grade_6 8 1 0 0   0     0   0   6 3                       9 8 1 0 0   0     0   0   6 3                 9
940339 940339 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes 2 06 08 2016   grade_6 70 1 4 0   0     0   5   32 48                       80 70 1 4 0   0     0   5   32 48                 80
941024 941024 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No 2 06 07 2016   grade_6 163 28 27 5   3     0   11   119 118                       237 163 28 27 5   3     0   11   119 118                 237
941086 941086 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No 2 06 08 2016   grade_6 152 3 6 0   2     1   5   94 75                       169 152 3 6 0   2     1   5   94 75                 169
941331 941331 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No 2 05 07 2016   grade_6 113 2 10 2   3     1   7   71 67                       138 113 2 10 2   3     1   7   71 67                 138
934466 934466 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No 1 KG 08 2016   grade_6 16 0 1 0   1     0   1   10 9                       19 16 0 1 0   1     0   1   10 9                 19
935064 935064 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2016   grade_6 9 0 0 0   0     0   0   5 4                       9 9 0 0 0   0     0   0   5 4                 9
935369 935369 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No 1 PK 06 2016   grade_6 * * * *   *     *   *   2 2                       4                         2 2                 4
935735 935735 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No 1 PK 06 2016   grade_6 29 0 0 0   0     0   0   12 17                       29 29 0 0 0   0     0   0   12 17                 29
935882 935882 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No 1 PK 06 2016   grade_6 37 0 4 0   1     0   2   24 20                       44 37 0 4 0   1     0   2   24 20                 44
935910 935910 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No 4 06 12 2016   grade_6 60 0 3 0   0     0   1   17 47                       64 60 0 3 0   0     0   1   17 47                 64
937268 937268 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 Colegrove Park Elementary   Regular School No 1 KG 07 2016   grade_6 25 0 0 0   0     0   1   12 14                       26 25 0 0 0   0     0   1   12 14                 26
937276 937276 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 Greylock   Regular School No 1 KG 07 2016   grade_6 32 0 2 0   0     0   4   15 23                       38 32 0 2 0   0     0   4   15 23                 38
937285 937285 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No 1 PK 07 2016   grade_6 20 1 0 0   0     0   2   12 11                       23 20 1 0 0   0     0   2   12 11                 23
937770 937770 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 John T Reid Middle   Regular School No 2 06 08 2016   grade_6 137 18 25 1   0     0   20   93 108                       201 137 18 25 1   0     0   20   93 108                 201
937773 937773 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Theodore Herberg Middle   Regular School No 2 06 08 2016   grade_6 158 20 18 0   2     0   13   98 113                       211 158 20 18 0   2     0   13   98 113                 211
938102 938102 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No 1 PK 08 2016   grade_6 20 0 1 0   0     0   0   7 14                       21 20 0 1 0   0     0   0   7 14                 21
939754 939754 MA Berkshire   school 2513020 341   Williamstown 251302002146 3410010 Williamstown Elementary   Regular School No 1 PK 06 2016   grade_6 45 1 1 0   3     0   5   30 25                       55 45 1 1 0   3     0   5   30 25                 55
940261 940261 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 2016   grade_6 58 8 6 1   0     0   1   38 36                       74 58 8 6 1   0     0   1   38 36                 74
940817 940817 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2016   grade_6 98 5 1 0   1     0   0   54 51                       105 98 5 1 0   1     0   0   54 51                 105
940908 940908 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No 2 05 08 2016   grade_6 86 1 9 1   1     0   2   35 65                       100 86 1 9 1   1     0   2   35 65                 100
940997 940997 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No 2 06 08 2016   grade_6 114 2 3 0   1     0   5   69 56                       125 114 2 3 0   1     0   5   69 56                 125
941101 941101 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No 1 PK 06 2016   grade_6 16 0 0 0   0     0   1   7 10                       17 16 0 0 0   0     0   1   7 10                 17
941626 941626 MA Berkshire   school 2511040 765   Southern Berkshire 251104000428 7650035 Undermountain   Regular School No 1 PK 06 2016   grade_6 49 1 1 1   0     0   2   31 23                       54 49 1 1 1   0     0   2   31 23                 54
932558 932558 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No 2 05 08 2016   grade_6 75 0 3 0   0     0   0   41 37                       78 75 0 3 0   0     0   0   41 37                 78
932773 932773 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No 2 05 08 2016   grade_6 157 7 20 0   5     0   7   102 94                       196 157 7 20 0   5     0   7   102 94                 196
932777 932777 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No 2 05 08 2016   grade_6 92 5 19 0   4     0   8   69 59                       128 92 5 19 0   4     0   8   69 59                 128
932781 932781 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No 2 05 08 2016   grade_6 87 5 25 0   10     1   5   73 60                       133 87 5 25 0   10     1   5   73 60                 133
932940 932940 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No 2 05 08 2016   grade_6 94 1 1 0   2     0   2   50 50                       100 94 1 1 0   2     0   2   50 50                 100
934587 934587 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth Middle   Regular School No 2 06 08 2016   grade_6 287 4 8 0   1     0   19   160 159                       319 287 4 8 0   1     0   19   160 159                 319
934777 934777 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No 2 06 08 2016   grade_6 239 13 12 1   9     0   13   141 146                       287 239 13 12 1   9     0   13   141 146                 287
934877 934877 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Hastings Middle   Regular School No 2 06 08 2016   grade_6 129 1 7 0   4     0   3   74 70                       144 129 1 7 0   4     0   3   74 70                 144
934917 934917 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No 1 PK 07 2016   grade_6 34 1 24 0   5     0   6   34 36                       70 34 1 24 0   5     0   6   34 36                 70
934926 934926 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No 1 PK 08 2016   grade_6 35 2 15 0   0     0   2   29 25                       54 35 2 15 0   0     0   2   29 25                 54
934955 934955 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No 2 06 08 2016   grade_6 85 14 45 0   11     0   14   88 81                       169 85 14 45 0   11     0   14   88 81                 169
934958 934958 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No 2 06 08 2016   grade_6 118 11 46 0   7     1   10   113 80                       193 118 11 46 0   7     1   10   113 80                 193
934961 934961 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No 2 06 08 2016   grade_6 157 15 51 2   9     0   16   112 138                       250 157 15 51 2   9     0   16   112 138                 250
934971 934971 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No 1 01 08 2016   grade_6 2 4 1 0   0     0   1   7 1                       8 2 4 1 0   0     0   1   7 1                 8
936462 936462 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Harold L Qualters Middle   Regular School No 2 06 08 2016   grade_6 272 8 11 0   18     0   14   166 157                       323 272 8 11 0   18     0   14   166 157                 323
937104 937104 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No 2 06 08 2016   grade_6 132 43 94 2   4     0   21   169 127                       296 132 43 94 2   4     0   21   169 127                 296
937107 937107 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No 2 06 08 2016   grade_6 221 41 133 0   4     0   17   229 187                       416 221 41 133 0   4     0   17   229 187                 416
937110 937110 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No 2 06 08 2016   grade_6 102 37 112 0   2     1   13   133 134                       267 102 37 112 0   2     1   13   133 134                 267
937394 937394 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No 2 06 08 2016   grade_6 317 5 15 2   22     1   8   190 180                       370 317 5 15 2   22     1   8   190 180                 370
937495 937495 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton Middle   Regular School No 2 06 08 2016   grade_6 181 4 5 1   1     0   6   97 101                       198 181 4 5 1   1     0   6   97 101                 198
938311 938311 MA Bristol   school 2510590 265   Seekonk 251059001700 2650405 Dr. Kevin M. Hurley Middle School   Regular School No 2 06 08 2016   grade_6 146 2 9 0   5     0   5   85 82                       167 146 2 9 0   5     0   5   85 82                 167
938407 938407 MA Bristol   school 2510860 273   Somerset 251086002537 2730305 Somerset Middle School   Regular School No 2 06 08 2016   grade_6 185 0 8 0   0     1   2   101 95                       196 185 0 8 0   0     1   2   101 95                 196
939005 939005 MA Bristol   school 2511460 292   Swansea 251146001894 2920305 Joseph Case Jr High   Regular School No 2 06 08 2016   grade_6 167 0 4 0   0     0   0   92 79                       171 167 0 4 0   0     0   0   92 79                 171
939044 939044 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Joseph H Martin   Regular School No 2 05 07 2016   grade_6 191 30 33 0   8     0   10   133 139                       272 191 30 33 0   8     0   10   133 139                 272
939052 939052 MA Bristol   school 2511520 293   Taunton 251152002416 2930305 John F Parker Middle   Regular School No 2 05 07 2016   grade_6 84 17 27 0   4     0   10   70 72                       142 84 17 27 0   4     0   10   70 72                 142
939055 939055 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Benjamin Friedman Middle   Regular School No 2 05 07 2016   grade_6 225 21 32 1   3     0   8   139 151                       290 225 21 32 1   3     0   8   139 151                 290
939598 939598 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport Elementary   Regular School No 1 03 06 2016   grade_6 116 0 4 0   2     0   5   70 57                       127 116 0 4 0   2     0   5   70 57                 127
940234 940234 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes 1 KG 06 2016   grade_6 15 7 13 1   2     0   2   18 22                       40 15 7 13 1   2     0   2   18 22                 40
940702 940702 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 10 2016   grade_6 85 4 7 0   2     0   2   49 51                       100 85 4 7 0   2     0   2   49 51                 100
940724 940724 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes 4 05 12 2016   grade_6 45 12 21 0   2     0   6   46 40                       86 45 12 21 0   2     0   6   46 40                 86
940958 940958 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Raynham Middle School   Regular School No 2 05 08 2016   grade_6 168 1 5 0   1     0   10   99 86                       185 168 1 5 0   1     0   10   99 86                 185
941042 941042 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No 2 05 08 2016   grade_6 78 1 2 0   1     0   1   46 37                       83 78 1 2 0   1     0   1   46 37                 83
941046 941046 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dorothy L Beckwith   Regular School No 2 05 08 2016   grade_6 139 2 7 0   1     0   0   75 74                       149 139 2 7 0   1     0   0   75 74                 149
941113 941113 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville Middle School   Regular School No 2 06 08 2016   grade_6 212 5 9 2   2     1   5   117 119                       236 212 5 9 2   2     1   5   117 119                 236
941999 941999 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes 2 06 07 2016   grade_6 75 5 14 1   1     1   5   52 50                       102 75 5 14 1   1     1   5   52 50                 102
934790 934790 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No 1 PK 08 2016   grade_6 26 0 4 0   0     0   0   21 9                       30 26 0 4 0   0     0   0   21 9                 30
935278 935278 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No 2 05 06 2016   grade_6 * * * *   *     *   *   * *                       1                                             1
937564 937564 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No 1 PK 08 2016   grade_6 18 4 4 0   0     2   0   21 7                       28 18 4 4 0   0     2   0   21 7                 28
939093 939093 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No 1 PK 08 2016   grade_6 23 0 7 2   0     0   3   19 16                       35 23 0 7 2   0     0   3   19 16                 35
940549 940549 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2016   grade_6 4 2 1 0   0     0   1   2 6                       8 4 2 1 0   0     0   1   2 6                 8
941730 941730 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No 1 PK 08 2016   grade_6 41 2 1 2   1     0   2   36 13                       49 41 2 1 2   1     0   2   36 13                 49
932605 932605 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No 2 05 08 2016   grade_6 160 0 10 0   2     0   6   96 82                       178 160 0 10 0   2     0   6   96 82                 178
932668 932668 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No 2 06 08 2016   grade_6 135 1 8 1   22     0   5   103 69                       172 135 1 8 1   22     0   5   103 69                 172
932671 932671 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No 2 06 08 2016   grade_6 120 4 10 0   26     0   4   73 91                       164 120 4 10 0   26     0   4   73 91                 164
932674 932674 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No 2 06 08 2016   grade_6 85 2 13 0   38     0   3   74 67                       141 85 2 13 0   38     0   3   74 67                 141
932981 932981 MA Essex   school 2502640 30   Beverly 250264000165 300305 Briscoe Middle   Regular School No 2 06 08 2016   grade_6 281 13 30 0   9     0   12   201 144                       345 281 13 30 0   9     0   12   201 144                 345
933855 933855 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No 1 03 06 2016   grade_6 100 1 1 0   5     0   2   55 54                       109 100 1 1 0   5     0   2   55 54                 109
934560 934560 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No 2 06 08 2016   grade_6 230 6 17 1   7     0   7   139 129                       268 230 6 17 1   7     0   7   139 129                 268
935231 935231 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No 1 KG 06 2016   grade_6 6 0 0 0   0     0   0   4 2                       6 6 0 0 0   0     0   0   4 2                 6
935269 935269 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No 2 06 08 2016   grade_6 202 2 19 0   2     0   5   118 112                       230 202 2 19 0   2     0   5   118 112                 230
935438 935438 MA Essex   school 2505970 128   Haverhill 250597000848 1280035 Caleb Dustin Hunking   Regular School No 2 06 08 2016   grade_6 104 6 18 0   1     1   1   61 70                       131 104 6 18 0   1     1   1   61 70                 131
935443 935443 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No 2 05 08 2016   grade_6 74 8 39 0   2     0   1   59 65                       124 74 8 39 0   2     0   1   59 65                 124
935466 935466 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No 2 05 08 2016   grade_6 98 6 32 0   3     1   1   71 70                       141 98 6 32 0   3     1   1   71 70                 141
935474 935474 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 01 08 2016   grade_6 105 5 93 0   4     0   1   100 108                       208 105 5 93 0   4     0   1   100 108                 208
935713 935713 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich Middle School   Regular School No 2 06 08 2016   grade_6 148 1 4 0   1     0   10   74 90                       164 148 1 4 0   1     0   10   74 90                 164
935756 935756 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No 1 03 08 2016   grade_6 4 2 72 0   0     0   0   42 36                       78 4 2 72 0   0     0   0   42 36                 78
935760 935760 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No 2 05 08 2016   grade_6 3 4 141 0   0     0   0   70 78                       148 3 4 141 0   0     0   0   70 78                 148
935777 935777 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No 2 05 08 2016   grade_6 1 2 134 0   2     0   0   67 72                       139 1 2 134 0   2     0   0   67 72                 139
935781 935781 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No 2 05 08 2016   grade_6 12 6 133 0   0     0   1   85 67                       152 12 6 133 0   0     0   1   85 67                 152
935795 935795 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No 2 06 08 2016   grade_6 2 2 115 0   0     0   0   68 51                       119 2 2 115 0   0     0   0   68 51                 119
935814 935814 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No 1 KG 08 2016   grade_6 7 0 70 0   3     0   0   39 41                       80 7 0 70 0   3     0   0   39 41                 80
935817 935817 MA Essex   school 2506660 149   Lawrence 250666002758 1490085 Spark Academy   Regular School No 2 06 08 2016   grade_6 4 3 136 0   2     0   0   64 81                       145 4 3 136 0   2     0   0   64 81                 145
935820 935820 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No 2 06 08 2016   grade_6 5 1 99 0   0     0   0   52 53                       105 5 1 99 0   0     0   0   52 53                 105
935825 935825 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No 2 05 08 2016   grade_6 15 4 102 0   4     0   1   63 63                       126 15 4 102 0   4     0   1   63 63                 126
935863 935863 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2016   grade_6 2 1 14 0   0     0   0   14 3                       17 2 1 14 0   0     0   0   14 3                 17
936331 936331 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No 1 KG 06 2016   grade_6 5 2 3 0   0     0   0   9 1                       10 5 2 3 0   0     0   0   9 1                 10
936356 936356 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No 2 06 08 2016   grade_6 52 37 259 5   37     0   15   213 192                       405 52 37 259 5   37     0   15   213 192                 405
936359 936359 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No 2 06 08 2016   grade_6 67 46 254 5   59     0   17   225 223                       448 67 46 254 5   59     0   17   225 223                 448
936362 936362 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Pickering Middle   Regular School No 2 06 08 2016   grade_6 87 15 77 2   16     0   14   107 104                       211 87 15 77 2   16     0   14   107 104                 211
936398 936398 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield Middle School   Regular School No 2 05 08 2016   grade_6 164 1 4 0   5     0   3   82 95                       177 164 1 4 0   5     0   3   82 95                 177

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