enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 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
2229128 2229128 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable: Barnstable Intermediate School   Regular School No Middle 06 07 2018   grade_6 263 30 58 0   9     0   18   206 172                       378.0 263 30 58 0   9     0   18   206 172                 378
2230293 2230293 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne: Bourne Middle School   Regular School No Middle 05 08 2018   grade_6 156 2 10 1   1     0   3   86 87                       173.0 156 2 10 1   1     0   3   86 87                 173
2231684 2231684 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Falmouth: Morse Pond School   Regular School No Middle 05 06 2018   grade_6 221 20 17 2   2     1   15   139 139                       278.0 221 20 17 2   2     1   15   139 139                 278
2233563 2233563 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Mashpee: Quashnet School   Regular School No Elementary 03 06 2018   grade_6 82 3 3 7   1     0   6   59 43                       102.0 82 3 3 7   1     0   6   59 43                 102
2235099 2235099 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown: Provincetown Schools   Regular School No Elementary PK 08 2018   grade_6 5 3 1 0   0     0   1   6 4                       10.0 5 3 1 0   0     0   1   6 4                 10
2235520 2235520 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Sandwich: Oak Ridge   Regular School No Elementary 03 06 2018   grade_6 216 0 4 0   2     0   1   102 121                       223.0 216 0 4 0   2     0   1   102 121                 223
2238069 2238069 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter (District): Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2018   grade_6 70 1 3 0   1     0   5   40 40                       80.0 70 1 3 0   1     0   5   40 40                 80
2238830 2238830 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Dennis-Yarmouth: Mattacheese Middle School   Regular School No Middle 05 08 2018   grade_6 150 18 34 5   4     0   14   107 118                       225.0 150 18 34 5   4     0   14   107 118                 225
2238908 2238908 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset: Nauset Regional Middle   Regular School No Middle 06 08 2018   grade_6 152 8 13 0   5     0   7   88 97                       185.0 152 8 13 0   5     0   7   88 97                 185
2239198 2239198 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional School District: Monomoy Regional Middle School   Regular School No Middle 05 07 2018   grade_6 100 12 13 1   1     1   4   68 64                       132.0 100 12 13 1   1     1   4   68 64                 132
2231028 2231028 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg: Clarksburg Elementary   Regular School No Elementary KG 08 2018   grade_6 18 0 0 0   0     0   2   10 10                       20.0 18 0 0 0   0     0   2   10 10                 20
2231754 2231754 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida: Abbott Memorial   Regular School No Elementary PK 08 2018   grade_6 8 0 0 0   0     0   0   2 6                       8.0 8 0 0 0   0     0   0   2 6                 8
2232133 2232133 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock: Hancock Elementary   Regular School No Elementary PK 06 2018   grade_6 10 0 0 0   0     0   0   8 2                       10.0 10 0 0 0   0     0   0   8 2                 10
2232570 2232570 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough: Lanesborough Elementary   Regular School No Elementary PK 06 2018   grade_6 31 0 0 0   0     0   1   13 19                       32.0 31 0 0 0   0     0   1   13 19                 32
2232719 2232719 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee: Lee Elementary   Regular School No Elementary PK 06 2018   grade_6 44 1 3 0   2     0   1   28 23                       51.0 44 1 3 0   2     0   1   28 23                 51
2232754 2232754 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox: Lenox Memorial High   Regular School No High 06 12 2018   grade_6 52 0 6 0   4     0   1   37 26                       63.0 52 0 6 0   4     0   1   37 26                 63
2234390 2234390 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 North Adams: Colegrove Park Elementary   Regular School No Elementary PK 06 2018   grade_6 48 2 0 0   0     0   1   27 24                       51.0 48 2 0 0   0     0   1   27 24                 51
2234399 2234399 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 North Adams: Greylock   Regular School No Elementary PK 06 2018   grade_6 35 2 2 0   2     0   0   22 19                       41.0 35 2 2 0   2     0   0   22 19                 41
2234408 2234408 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 North Adams: Brayton   Regular School No Elementary PK 06 2018   grade_6 20 2 1 0   0     0   4   11 16                       27.0 20 2 1 0   0     0   4   11 16                 27
2234981 2234981 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 Pittsfield: John T Reid Middle   Regular School No Middle 06 08 2018   grade_6 117 23 17 1   2     0   18   88 90                       178.0 117 23 17 1   2     0   18   88 90                 178
2234985 2234985 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Pittsfield: Theodore Herberg Middle   Regular School No Middle 06 08 2018   grade_6 156 27 24 0   3     0   12   113 109                       222.0 156 27 24 0   3     0   12   113 109                 222
2235375 2235375 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond: Richmond Consolidated   Regular School No Elementary PK 08 2018   grade_6 21 0 2 0   0     0   1   13 11                       24.0 21 0 2 0   0     0   1   13 11                 24
2237369 2237369 MA Berkshire   school 2513020 341   Williamstown 251302002146 3410010 Williamstown: Williamstown Elementary   Regular School No Elementary PK 06 2018   grade_6 61 1 4 0   0     0   7   25 48                       73.0 61 1 4 0   0     0   7   25 48                 73
2237968 2237968 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public (District): Berkshire Arts and Technology Charter Public School   Regular School Yes High 06 12 2018   grade_6 39 8 7 0   3     0   3   36 24                       60.0 39 8 7 0   3     0   3   36 24                 60
2238587 2238587 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Adams-Cheshire: Hoosac Valley Middle School   Regular School No Middle 04 07 2018   grade_6 87 2 2 1   0     0   0   43 49                       92.0 87 2 2 1   0     0   0   43 49                 92
2238687 2238687 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Berkshire Hills: Monument Valley Regional Middle School   Regular School No Middle 05 08 2018   grade_6 58 2 3 0   6     0   6   43 32                       75.0 58 2 3 0   6     0   6   43 32                 75
2238795 2238795 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Central Berkshire: Nessacus Regional Middle School   Regular School No Middle 06 08 2018   grade_6 121 0 3 0   1     0   5   69 61                       130.0 121 0 3 0   1     0   5   69 61                 130
2238924 2238924 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Reg: Farmington River Elementary   Regular School No Elementary PK 06 2018   grade_6 11 0 0 0   0     0   1   7 5                       12.0 11 0 0 0   0     0   1   7 5                 12
2239533 2239533 MA Berkshire   school 2511040 765   Southern Berkshire 251104000428 7650035 Southern Berkshire: Undermountain   Regular School No Elementary PK 06 2018   grade_6 42 0 1 0   0     0   2   17 28                       45.0 42 0 1 0   0     0   2   17 28                 45
2228781 2228781 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet: Albert F Ford Middle School   Regular School No Middle 05 08 2018   grade_6 109 2 2 0   0     0   1   62 52                       114.0 109 2 2 0   0     0   1   62 52                 114
2229042 2229042 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Attleboro: Robert J. Coelho Middle School   Regular School No Middle 05 08 2018   grade_6 121 5 22 0   8     0   11   82 85                       167.0 121 5 22 0   8     0   11   82 85                 167
2229047 2229047 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Attleboro: Cyril K. Brennan Middle School   Regular School No Middle 05 08 2018   grade_6 93 5 29 1   9     0   7   69 75                       144.0 93 5 29 1   9     0   7   69 75                 144
2229052 2229052 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Attleboro: Wamsutta Middle School   Regular School No Middle 05 08 2018   grade_6 104 6 27 0   7     0   11   80 75                       155.0 104 6 27 0   7     0   11   80 75                 155
2229246 2229246 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley: Berkley Middle School   Regular School No Middle 05 08 2018   grade_6 86 1 3 0   0     0   1   46 45                       91.0 86 1 3 0   0     0   1   46 45                 91
2231173 2231173 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth: Dartmouth Middle   Regular School No Middle 06 08 2018   grade_6 282 4 14 0   0     0   19   176 143                       319.0 282 4 14 0   0     0   19   176 143                 319
2231404 2231404 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton: Easton Middle School   Regular School No Middle 06 08 2018   grade_6 250 9 11 0   10     0   6   149 137                       286.0 250 9 11 0   10     0   6   149 137                 286
2231522 2231522 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Fairhaven: Hastings Middle   Regular School No Middle 06 08 2018   grade_6 137 3 8 0   5     0   5   89 69                       158.0 137 3 8 0   5     0   5   89 69                 158
2231569 2231569 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Fall River: Henry Lord Community School   Regular School No Elementary PK 08 2018   grade_6 22 8 25 0   2     0   5   35 27                       62.0 22 8 25 0   2     0   5   35 27                 62
2231580 2231580 MA Bristol   school 2504830 95   Fall River 250483000666 950045 Fall River: John J Doran   Regular School No Elementary PK 08 2018   grade_6 28 4 6 1   2     0   6   24 23                       47.0 28 4 6 1   2     0   6   24 23                 47
2231613 2231613 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Fall River: Talbot Innovation School   Regular School No Middle 06 08 2018   grade_6 69 10 51 0   6     0   16   92 60                       152.0 69 10 51 0   6     0   16   92 60                 152
2231617 2231617 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Fall River: Morton Middle   Regular School No Middle 06 08 2018   grade_6 102 15 45 0   11     0   14   107 80                       187.0 102 15 45 0   11     0   14   107 80                 187
2231621 2231621 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Fall River: Matthew J Kuss Middle   Regular School No Middle 06 08 2018   grade_6 150 25 48 0   15     0   18   123 133                       256.0 150 25 48 0   15     0   18   123 133                 256
2231643 2231643 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   grade_6 * * * *   *     *   *   * *                       0.0                                             0
2233429 2233429 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Mansfield: Harold L Qualters Middle   Regular School No Middle 06 08 2018   grade_6 242 13 14 0   25     0   8   156 146                       302.0 242 13 14 0   25     0   8   156 146                 302
2234191 2234191 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 New Bedford: Keith Middle School   Regular School No Middle 06 08 2018   grade_6 138 53 112 1   5     1   19   168 161                       329.0 138 53 112 1   5     1   19   168 161                 329
2234195 2234195 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 New Bedford: Normandin Middle School   Regular School No Middle 06 08 2018   grade_6 242 25 144 2   7     0   20   228 212                       440.0 242 25 144 2   7     0   20   228 212                 440
2234199 2234199 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 New Bedford: Roosevelt Middle School   Regular School No Middle 06 08 2018   grade_6 112 50 109 1   1     1   12   145 141                       286.0 112 50 109 1   1     1   12   145 141                 286
2234538 2234538 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough: North Attleborough Middle   Regular School No Middle 06 08 2018   grade_6 308 9 17 0   20     0   15   176 193                       369.0 308 9 17 0   20     0   15   176 193                 369
2234658 2234658 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton: Norton Middle   Regular School No Middle 06 08 2018   grade_6 152 3 11 1   5     0   12   83 101                       184.0 152 3 11 1   5     0   12   83 101                 184
2235631 2235631 MA Bristol   school 2510590 265   Seekonk 251059001700 2650405 Seekonk: Dr. Kevin M. Hurley Middle School   Regular School No Middle 06 08 2018   grade_6 138 2 7 0   6     0   3   81 75                       156.0 138 2 7 0   6     0   3   81 75                 156
2235750 2235750 MA Bristol   school 2510860 273   Somerset 251086002537 2730305 Somerset: Somerset Middle School   Regular School No Middle 06 08 2018   grade_6 199 1 8 0   0     0   2   113 97                       210.0 199 1 8 0   0     0   2   113 97                 210
2236453 2236453 MA Bristol   school 2511460 292   Swansea 251146001894 2920305 Swansea: Joseph Case Jr High   Regular School No Middle 06 08 2018   grade_6 184 2 5 0   1     0   1   103 90                       193.0 184 2 5 0   1     0   1   103 90                 193
2236501 2236501 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Taunton: Joseph H Martin   Regular School No Middle 05 07 2018   grade_6 159 30 21 1   2     0   13   124 102                       226.0 159 30 21 1   2     0   13   124 102                 226
2236511 2236511 MA Bristol   school 2511520 293   Taunton 251152002416 2930305 Taunton: John F Parker Middle   Regular School No Middle 05 07 2018   grade_6 85 46 31 1   2     0   14   90 89                       179.0 85 46 31 1   2     0   14   90 89                 179
2236515 2236515 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Taunton: Benjamin Friedman Middle   Regular School No Middle 05 07 2018   grade_6 191 22 24 0   3     2   14   127 129                       256.0 191 22 24 0   3     2   14   127 129                 256
2237166 2237166 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport: Westport Elementary   Regular School No Elementary 03 06 2018   grade_6 138 0 8 0   0     0   7   79 74                       153.0 138 0 8 0   0     0   7   79 74                 153
2237932 2237932 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School (District): Alma del Mar Charter School   Regular School Yes Elementary KG 08 2018   grade_6 19 6 18 0   0     0   3   21 25                       46.0 19 6 18 0   0     0   3   21 25                 46
2238453 2238453 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District): Atlantis Charter School   Regular School Yes Other KG 12 2018   grade_6 87 5 14 0   2     0   2   53 57                       110.0 87 5 14 0   2     0   2   53 57                 110
2238486 2238486 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public (District): Global Learning Charter Public School   Regular School Yes High 05 12 2018   grade_6 35 11 39 1   0     0   2   44 44                       88.0 35 11 39 1   0     0   2   44 44                 88
2238744 2238744 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002657 6250300 Bridgewater-Raynham: Williams Intermediate School   Regular School No Middle 04 06 2018   grade_6 215 16 0 0   1     0   16   146 102                       248.0 215 16 0 0   1     0   16   146 102                 248
2238747 2238747 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Bridgewater-Raynham: Raynham Middle School   Regular School No Middle 05 08 2018   grade_6 114 5 4 0   6     0   3   63 69                       132.0 114 5 4 0   6     0   3   63 69                 132
2238853 2238853 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton-Rehoboth: Dighton Middle School   Regular School No Middle 05 08 2018   grade_6 98 2 4 0   2     0   4   60 50                       110.0 98 2 4 0   2     0   4   60 50                 110
2238858 2238858 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dighton-Rehoboth: Dorothy L Beckwith   Regular School No Middle 05 08 2018   grade_6 139 0 6 0   3     0   6   82 72                       154.0 139 0 6 0   3     0   6   82 72                 154
2238940 2238940 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville: Freetown-Lakeville Middle School   Regular School No Middle 06 08 2018   grade_6 251 2 6 1   0     0   4   125 139                       264.0 251 2 6 1   0     0   4   125 139                 264
2239981 2239981 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School (District): Argosy Collegiate Charter School   Regular School Yes Middle 06 09 2018   grade_6 64 11 21 0   2     0   5   55 48                       103.0 64 11 21 0   2     0   5   55 48                 103
2231420 2231420 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown: Edgartown Elementary   Regular School No Elementary PK 08 2018   grade_6 30 2 4 0   0     0   1   17 20                       37.0 30 2 4 0   0     0   1   17 20                 37
2232021 2232021 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_6 * * * *   *     *   *   * *                       0.0                                             0
2234742 2234742 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs: Oak Bluffs Elementary   Regular School No Elementary PK 08 2018   grade_6 33 2 9 2   1     0   2   19 30                       49.0 33 2 9 2   1     0   2   19 30                 49
2236561 2236561 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury: Tisbury Elementary   Regular School No Elementary PK 08 2018   grade_6 16 3 8 2   1     0   7   19 18                       37.0 16 3 8 2   1     0   7   19 18                 37
2238288 2238288 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter (District): Martha's Vineyard Charter School   Regular School Yes Other KG 12 2018   grade_6 18 1 1 0   0     0   0   9 11                       20.0 18 1 1 0   0     0   0   9 11                 20
2239646 2239646 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 Up-Island Regional: West Tisbury Elementary   Regular School No Elementary PK 08 2018   grade_6 37 0 0 0   0     0   5   26 16                       42.0 37 0 0 0   0     0   5   26 16                 42
2228837 2228837 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury: Amesbury Middle   Regular School No Middle 05 08 2018   grade_6 145 4 14 0   0     1   3   77 90                       167.0 145 4 14 0   0     1   3   77 90                 167
2228913 2228913 MA Essex   school 2501950 9   Andover 250195002510 90305 Andover: Doherty Middle   Regular School No Middle 06 08 2018   grade_6 142 4 15 0   18     0   6   82 103                       185.0 142 4 15 0   18     0   6   82 103                 185
2228917 2228917 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover: Andover West Middle   Regular School No Middle 06 08 2018   grade_6 126 7 10 1   28     0   4   96 80                       176.0 126 7 10 1   28     0   4   96 80                 176
2228921 2228921 MA Essex   school 2501950 9   Andover 250195001678 90350 Andover: Wood Hill Middle School   Regular School No Middle 06 08 2018   grade_6 77 4 13 1   44     0   4   79 64                       143.0 77 4 13 1   44     0   4   79 64                 143
2229295 2229295 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly: Briscoe Middle   Regular School No Middle 06 08 2018   grade_6 242 11 48 0   9     0   8   166 152                       318.0 242 11 48 0   9     0   8   166 152                 318
2230310 2230310 MA Essex   school 2502880 38   Boxford 250288000358 380013 Boxford: Spofford Pond   Regular School No Elementary 03 06 2018   grade_6 98 0 3 0   4     0   1   42 64                       106.0 98 0 3 0   4     0   1   42 64                 106
2231140 2231140 MA Essex   school 2503990 71   Danvers 250399002517 710305 Danvers: Holten Richmond Middle School   Regular School No Middle 06 08 2018   grade_6 231 5 19 1   10     0   7   136 137                       273.0 231 5 19 1   10     0   7   136 137                 273
2231958 2231958 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Georgetown: Penn Brook   Regular School No Elementary KG 06 2018   grade_6 95 2 2 0   0     0   0   53 46                       99.0 95 2 2 0   0     0   0   53 46                 99
2232005 2232005 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Gloucester: Ralph B O'Maley Middle   Regular School No Middle 06 08 2018   grade_6 197 6 13 0   4     1   7   120 108                       228.0 197 6 13 0   4     1   7   120 108                 228
2232216 2232216 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Haverhill: Caleb Dustin Hunking School   Regular School No Elementary KG 08 2018   grade_6 151 9 33 0   3     1   2   105 94                       199.0 151 9 33 0   3     1   2   105 94                 199
2232228 2232228 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Haverhill: Dr Paul Nettle   Regular School No Middle 05 08 2018   grade_6 62 5 56 0   4     1   1   63 66                       129.0 62 5 56 0   4     1   1   63 66                 129
2232257 2232257 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 Haverhill: John G Whittier   Regular School No Middle 05 08 2018   grade_6 83 6 32 1   3     0   1   69 57                       126.0 83 6 32 1   3     0   1   69 57                 126
2232264 2232264 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Haverhill: Consentino Middle School   Regular School No Middle 03 08 2018   grade_6 114 11 89 1   2     0   1   115 103                       218.0 114 11 89 1   2     0   1   115 103                 218
2232545 2232545 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich: Ipswich Middle School   Regular School No Middle 06 08 2018   grade_6 125 2 9 0   2     0   3   68 73                       141.0 125 2 9 0   2     0   3   68 73                 141
2232598 2232598 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Lawrence: Alexander B Bruce   Regular School No Middle 03 08 2018   grade_6 4 1 73 0   2     0   0   39 41                       80.0 4 1 73 0   2     0   0   39 41                 80
2232603 2232603 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Lawrence: Arlington Middle School   Regular School No Middle 05 08 2018   grade_6 2 1 146 0   0     0   0   74 75                       149.0 2 1 146 0   0     0   0   74 75                 149
2232624 2232624 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Lawrence: Guilmette Middle School   Regular School No Middle 05 08 2018   grade_6 2 4 111 0   1     0   0   56 62                       118.0 2 4 111 0   1     0   0   56 62                 118
2232629 2232629 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Lawrence: Parthum Middle School   Regular School No Middle 05 08 2018   grade_6 7 0 115 0   0     0   2   55 69                       124.0 7 0 115 0   0     0   2   55 69                 124
2232646 2232646 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 Lawrence: UP Academy Oliver Middle School   Regular School No Middle 06 08 2018   grade_6 7 1 103 0   0     0   0   58 53                       111.0 7 1 103 0   0     0   0   58 53                 111
2232668 2232668 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Lawrence: Emily G Wetherbee   Regular School No Elementary KG 08 2018   grade_6 0 1 71 0   2     0   0   35 39                       74.0 0 1 71 0   2     0   0   35 39                 74
2232672 2232672 MA Essex   school 2506660 149   Lawrence 250666002758 1490085 Lawrence: Spark Academy   Regular School No Middle 06 08 2018   grade_6 5 3 146 0   3     0   0   77 80                       157.0 5 3 146 0   3     0   0   77 80                 157
2232676 2232676 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 Lawrence: UP Academy Leonard Middle School   Regular School No Middle 06 08 2018   grade_6 0 1 77 0   0     0   0   47 31                       78.0 0 1 77 0   0     0   0   47 31                 78
2232686 2232686 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Lawrence: Frost Middle School   Regular School No Middle 05 08 2018   grade_6 13 3 100 0   7     0   0   61 62                       123.0 13 3 100 0   7     0   0   61 62                 123
2232699 2232699 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence: School for Exceptional Studies   Regular School No Other 01 12 2018   grade_6 2 0 9 0   0     0   0   9 2                       11.0 2 0 9 0   0     0   0   9 2                 11
2233301 2233301 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Lynn: Thurgood Marshall Mid   Regular School No Middle 06 08 2018   grade_6 45 45 317 0   33     0   15   230 225                       455.0 45 45 317 0   33     0   15   230 225                 455
2233305 2233305 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Lynn: Breed Middle School   Regular School No Middle 06 08 2018   grade_6 49 45 316 0   41     0   19   265 205                       470.0 49 45 316 0   41     0   19   265 205                 470
2233309 2233309 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Lynn: Pickering Middle   Regular School No Middle 06 08 2018   grade_6 68 10 106 1   18     0   14   117 100                       217.0 68 10 106 1   18     0   14   117 100                 217
2233331 2233331 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn: Lynn Vocational Technical Institute   Career and Technical School No High 06 12 2018   grade_6 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2233353 2233353 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield: Lynnfield Middle School   Regular School No Middle 05 08 2018   grade_6 153 3 8 0   7     0   4   89 86                       175.0 153 3 8 0   7     0   4   89 86                 175

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