enrollments

Data source: Big Local News · About: Big Local

500 rows where grade = "grade_7", state = "MA" and year = 2020 sorted by county

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 500 ✖

grade ✖

  • grade_7 · 500 ✖
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
1365095 1365095 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No Middle 06 07 2020   grade_7 274 28 53 0   9     2   15   190 191 *                     381.0 274 28 53 0   9     2   15   190 191                 381
1366065 1366065 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 06 08 2020   grade_7 140 3 12 3   2     0   6   94 72 *                     166.0 140 3 12 3   2     0   6   94 72                 166
1367237 1367237 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No Middle 07 08 2020   grade_7 205 15 14 1   13     0   18   142 124 *                     266.0 205 15 14 1   13     0   18   142 124                 266
1368795 1368795 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2020   grade_7 107 6 5 8   5     0   16   71 76 *                     147.0 107 6 5 8   5     0   16   71 76                 147
1370098 1370098 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2020   grade_7 3 5 2 0   0     0   0   3 7 *                     10.0 3 5 2 0   0     0   0   3 7                 10
1370447 1370447 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich STEM Academy   Regular School No Middle 07 08 2020   grade_7 205 4 3 1   3     0   3   109 110 *                     219.0 205 4 3 1   3     0   3   109 110                 219
1372578 1372578 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2020   grade_7 71 1 3 1   3     0   2   36 45 *                     81.0 71 1 3 1   3     0   2   36 45                 81
1373253 1373253 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No Middle 06 07 2020   grade_7 158 22 36 6   6     0   10   113 125 *                     238.0 158 22 36 6   6     0   10   113 125                 238
1373318 1373318 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No Middle 06 08 2020   grade_7 175 9 13 1   3     0   2   98 105 *                     203.0 175 9 13 1   3     0   2   98 105                 203
1373565 1373565 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No Middle 05 07 2020   grade_7 147 13 16 0   2     1   4   101 82 *                     183.0 147 13 16 0   2     1   4   101 82                 183
1366689 1366689 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2020   grade_7 20 0 0 0   0     0   2   12 10 *                     22.0 20 0 0 0   0     0   2   12 10                 22
1367297 1367297 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2020   grade_7 13 1 0 0   0     0   0   9 5 *                     14.0 13 1 0 0   0     0   0   9 5                 14
1368077 1368077 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No High 07 12 2020   grade_7 42 0 5 0   3     0   3   19 34 *                     53.0 42 0 5 0   3     0   3   19 34                 53
1368106 1368106 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No High 06 12 2020   grade_7 50 0 6 0   2     0   4   34 28 *                     62.0 50 0 6 0   2     0   4   34 28                 62
1369514 1369514 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No High 07 12 2020   grade_7 103 2 8 0   1     1   10   60 65 *                     125.0 103 2 8 0   1     1   10   60 65                 125
1369998 1369998 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 John T Reid Middle   Regular School No Middle 06 08 2020   grade_7 118 27 17 1   0     0   13   80 96 *                     176.0 118 27 17 1   0     0   13   80 96                 176
1370001 1370001 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Theodore Herberg Middle   Regular School No Middle 06 08 2020   grade_7 136 30 28 0   2     0   15   103 108 *                     211.0 136 30 28 0   2     0   15   103 108                 211
1370332 1370332 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2020   grade_7 16 1 2 0   0     0   0   9 10 *                     19.0 16 1 2 0   0     0   0   9 10                 19
1372483 1372483 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes High 06 12 2020   grade_7 42 8 7 1   2     0   4   37 27 *                     64.0 42 8 7 1   2     0   4   37 27                 64
1373038 1373038 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Middle School   Regular School No Middle 04 07 2020   grade_7 84 5 2 0   1     0   2   48 46 *                     94.0 84 5 2 0   1     0   2   48 46                 94
1373122 1373122 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No Middle 05 08 2020   grade_7 77 3 10 0   2     0   5   56 41 *                     97.0 77 3 10 0   2     0   5   56 41                 97
1373226 1373226 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No Middle 06 08 2020   grade_7 115 1 7 0   0     0   5   74 54 *                     128.0 115 1 7 0   0     0   5   74 54                 128
1373587 1373587 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No High 07 12 2020   grade_7 81 3 3 0   0     0   4   50 41 *                     91.0 81 3 3 0   0     0   4   50 41                 91
1373859 1373859 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Mt Everett Regional   Regular School No High 06 12 2020   grade_7 45 1 3 1   0     0   4   27 27 *                     54.0 45 1 3 1   0     0   4   27 27                 54
1364807 1364807 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2020   grade_7 99 0 6 0   1     0   6   62 50 *                     112.0 99 0 6 0   1     0   6   62 50                 112
1365022 1365022 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2020   grade_7 124 12 23 0   5     0   11   97 78 *                     175.0 124 12 23 0   5     0   11   97 78                 175
1365026 1365026 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2020   grade_7 98 10 40 0   9     0   5   88 74 *                     162.0 98 10 40 0   9     0   5   88 74                 162
1365030 1365030 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No Middle 05 08 2020   grade_7 84 10 20 0   11     0   7   62 70 *                     132.0 84 10 20 0   11     0   7   62 70                 132
1365191 1365191 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2020   grade_7 91 0 4 0   0     0   2   48 49 *                     97.0 91 0 4 0   0     0   2   48 49                 97
1366812 1366812 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth Middle   Regular School No Middle 06 08 2020   grade_7 274 3 11 0   2     1   16   173 134 *                     307.0 274 3 11 0   2     1   16   173 134                 307
1367002 1367002 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No Middle 06 08 2020   grade_7 246 28 17 0   7     0   9   150 157 *                     307.0 246 28 17 0   7     0   9   150 157                 307
1367107 1367107 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Hastings Middle   Regular School No Middle 06 08 2020   grade_7 126 1 7 2   4     0   4   74 70 *                     144.0 126 1 7 2   4     0   4   74 70                 144
1367149 1367149 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No Elementary PK 08 2020   grade_7 27 7 38 0   5     0   8   38 47 *                     85.0 27 7 38 0   5     0   8   38 47                 85
1367159 1367159 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No Elementary PK 08 2020   grade_7 26 2 21 0   0     0   4   27 26 *                     53.0 26 2 21 0   0     0   4   27 26                 53
1367188 1367188 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No Middle 06 08 2020   grade_7 81 10 63 0   8     0   13   98 77 *                     175.0 81 10 63 0   8     0   13   98 77                 175
1367191 1367191 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No Middle 06 08 2020   grade_7 127 19 46 1   6     1   16   99 117 *                     216.0 127 19 46 1   6     1   16   99 117                 216
1367194 1367194 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No Middle 06 08 2020   grade_7 148 16 63 0   11     0   22   112 148 *                     260.0 148 16 63 0   11     0   22   112 148                 260
1367198 1367198 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2020   grade_7 2 2 5 0   0     0   2   9 2 *                     11.0 2 2 5 0   0     0   2   9 2                 11
1367207 1367207 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Resiliency Preparatory Academy   Alternative School No High 07 12 2020   grade_7 3 2 8 0   0     0   3   12 4 *                     16.0 3 2 8 0   0     0   3   12 4                 16
1368694 1368694 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Harold L Qualters Middle   Regular School No Middle 06 08 2020   grade_7 218 12 19 1   13     0   4   146 121 *                     267.0 218 12 19 1   13     0   4   146 121                 267
1369329 1369329 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No Middle 06 08 2020   grade_7 120 46 139 1   6     0   26   187 151 *                     338.0 120 46 139 1   6     0   26   187 151                 338
1369332 1369332 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No Middle 06 08 2020   grade_7 174 44 162 3   2     0   27   212 200 *                     412.0 174 44 162 3   2     0   27   212 200                 412
1369335 1369335 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No Middle 06 08 2020   grade_7 117 48 139 0   0     1   20   170 155 *                     325.0 117 48 139 0   0     1   20   170 155                 325
1369344 1369344 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No Other 04 12 2020   grade_7 3 2 4 0   0     0   0   6 3 *                     9.0 3 2 4 0   0     0   0   6 3                 9
1369621 1369621 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No Middle 06 08 2020   grade_7 329 11 22 0   16     2   16   175 221 *                     396.0 329 11 22 0   16     2   16   175 221                 396
1369721 1369721 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton Middle   Regular School No Middle 06 08 2020   grade_7 173 3 9 0   3     0   10   99 99 *                     198.0 173 3 9 0   3     0   10   99 99                 198
1370540 1370540 MA Bristol   school 2510590 265   Seekonk 251059001700 2650405 Dr. Kevin M. Hurley Middle School   Regular School No Middle 06 08 2020   grade_7 162 2 7 0   3     0   10   109 75 *                     184.0 162 2 7 0   3     0   10   109 75                 184
1370637 1370637 MA Bristol   school 2510860 273   Somerset 251086002537 2730305 Somerset Middle School   Regular School No Middle 06 08 2020   grade_7 185 4 15 1   0     0   5   110 100 *                     210.0 185 4 15 1   0     0   5   110 100                 210
1371245 1371245 MA Bristol   school 2511460 292   Swansea 251146001894 2920305 Joseph Case Jr High   Regular School No Middle 06 08 2020   grade_7 179 1 4 0   0     0   2   102 84 *                     186.0 179 1 4 0   0     0   2   102 84                 186
1371286 1371286 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Joseph H Martin   Regular School No Middle 05 07 2020   grade_7 153 44 27 1   2     1   7   123 112 *                     235.0 153 44 27 1   2     1   7   123 112                 235
1371294 1371294 MA Bristol   school 2511520 293   Taunton 251152002416 2930305 John F Parker Middle   Regular School No Middle 05 07 2020   grade_7 93 31 29 0   2     1   7   81 82 *                     163.0 93 31 29 0   2     1   7   81 82                 163
1371297 1371297 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Benjamin Friedman Middle   Regular School No Middle 05 07 2020   grade_7 191 32 31 1   2     0   13   136 134 *                     270.0 191 32 31 1   2     0   13   136 134                 270
1371829 1371829 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport Junior/Senior High School   Regular School No High 07 12 2020   grade_7 108 1 5 0   1     0   8   77 46 *                     123.0 108 1 5 0   1     0   8   77 46                 123
1372450 1372450 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 08 2020   grade_7 8 10 31 0   0     0   0   20 29 *                     49.0 8 10 31 0   0     0   0   20 29                 49
1372919 1372919 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2020   grade_7 83 3 17 0   0     0   7   48 62 *                     110.0 83 3 17 0   0     0   7   48 62                 110
1372950 1372950 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes High 05 12 2020   grade_7 35 9 40 1   1     0   3   42 47 *                     89.0 35 9 40 1   1     0   3   42 47                 89
1373185 1373185 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Raynham Middle School   Regular School No Middle 05 08 2020   grade_7 159 13 1 0   4     0   8   115 70 *                     185.0 159 13 1 0   4     0   8   115 70                 185
1373187 1373187 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002659 6250320 Bridgewater Middle School   Regular School No Middle 07 08 2020   grade_7 249 17 6 1   4     1   23   144 157 *                     301.0 249 17 6 1   4     1   23   144 157                 301
1373189 1373189 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No High 07 12 2020   grade_7 * * * *   *     *   *   1 * *                     1.0                         1                   1
1373273 1373273 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No Middle 05 08 2020   grade_7 84 1 7 0   0     0   5   47 50 *                     97.0 84 1 7 0   0     0   5   47 50                 97
1373277 1373277 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dorothy L Beckwith   Regular School No Middle 05 08 2020   grade_7 127 1 4 0   0     0   7   72 67 *                     139.0 127 1 4 0   0     0   7   72 67                 139
1373344 1373344 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville Middle School   Regular School No Middle 06 09 2020   grade_7 228 6 4 1   4     0   6   113 136 *                     249.0 228 6 4 1   4     0   6   113 136                 249
1374235 1374235 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Secondary 06 11 2020   grade_7 73 11 26 0   3     0   7   62 58 *                     120.0 73 11 26 0   3     0   7   62 58                 120
1367017 1367017 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No Elementary PK 08 2020   grade_7 25 1 7 2   1     0   2   20 18 *                     38.0 25 1 7 2   1     0   2   20 18                 38
1369793 1369793 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No Elementary PK 08 2020   grade_7 35 1 9 2   0     0   5   27 25 *                     52.0 35 1 9 2   0     0   5   27 25                 52
1371335 1371335 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No Elementary PK 08 2020   grade_7 20 3 8 1   0     0   2   22 12 *                     34.0 20 3 8 1   0     0   2   22 12                 34
1372778 1372778 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2020   grade_7 12 1 4 0   0     0   2   11 8 *                     19.0 12 1 4 0   0     0   2   11 8                 19
1373955 1373955 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2020   grade_7 38 0 1 0   0     0   1   24 16 *                     40.0 38 0 1 0   0     0   1   24 16                 40
1374314 1374314 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_7 * * * *   *     *   *   * * *                     0.0                                             0
1364852 1364852 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2020   grade_7 132 3 11 0   4     1   5   69 87 *                     156.0 132 3 11 0   4     1   5   69 87                 156
1364917 1364917 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No Middle 06 08 2020   grade_7 139 2 13 1   19     1   4   92 87 *                     179.0 139 2 13 1   19     1   4   92 87                 179
1364920 1364920 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No Middle 06 08 2020   grade_7 124 5 11 0   28     0   8   97 79 *                     176.0 124 5 11 0   28     0   8   97 79                 176
1364923 1364923 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2020   grade_7 61 3 13 1   53     0   2   73 60 *                     133.0 61 3 13 1   53     0   2   73 60                 133
1365221 1365221 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly Middle School   Regular School No Middle 05 08 2020   grade_7 280 9 55 0   12     0   7   189 174 *                     363.0 280 9 55 0   12     0   7   189 174                 363
1366784 1366784 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No Middle 06 08 2020   grade_7 215 10 27 1   4     0   8   135 130 *                     265.0 215 10 27 1   4     0   8   135 130                 265
1367469 1367469 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No Middle 07 08 2020   grade_7 84 0 1 0   2     1   0   41 47 *                     88.0 84 0 1 0   2     1   0   41 47                 88
1367507 1367507 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No Middle 06 08 2020   grade_7 173 2 21 3   1     0   2   86 116 *                     202.0 173 2 21 3   1     0   2   86 116                 202
1367661 1367661 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Caleb Dustin Hunking School   Regular School No Elementary KG 08 2020   grade_7 120 12 36 0   3     0   3   85 89 *                     174.0 120 12 36 0   3     0   3   85 89                 174
1367669 1367669 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No Middle 05 08 2020   grade_7 70 6 59 1   5     1   5   73 74 *                     147.0 70 6 59 1   5     1   5   73 74                 147
1367687 1367687 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_7 * * * *   *     *   *   2 * *                     2.0                         2                   2
1367702 1367702 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2020   grade_7 108 6 33 0   2     0   0   77 72 *                     149.0 108 6 33 0   2     0   0   77 72                 149
1367706 1367706 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 05 08 2020   grade_7 118 14 82 1   7     0   2   118 106 *                     224.0 118 14 82 1   7     0   2   118 106                 224
1367947 1367947 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich Middle School   Regular School No Middle 06 08 2020   grade_7 113 0 10 0   3     0   1   61 66 *                     127.0 113 0 10 0   3     0   1   61 66                 127
1367981 1367981 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Middle 03 08 2020   grade_7 4 0 78 0   1     0   0   40 43 *                     83.0 4 0 78 0   1     0   0   40 43                 83
1367985 1367985 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2020   grade_7 1 1 162 0   0     0   1   82 83 *                     165.0 1 1 162 0   0     0   1   82 83                 165
1368002 1368002 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2020   grade_7 5 2 114 0   0     0   2   61 62 *                     123.0 5 2 114 0   0     0   2   61 62                 123
1368006 1368006 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2020   grade_7 12 3 140 0   1     0   0   71 83 *                     156.0 12 3 140 0   1     0   0   71 83                 156
1368019 1368019 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2020   grade_7 2 0 106 0   0     0   1   58 51 *                     109.0 2 0 106 0   0     0   1   58 51                 109
1368038 1368038 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2020   grade_7 6 1 65 0   1     0   1   36 38 *                     74.0 6 1 65 0   1     0   1   36 38                 74
1368041 1368041 MA Essex   school 2506660 149   Lawrence 250666002758 1490085 Spark Academy   Regular School No Middle 06 08 2020   grade_7 3 3 147 0   2     0   3   90 68 *                     158.0 3 3 147 0   2     0   3   90 68                 158
1368044 1368044 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No Middle 06 08 2020   grade_7 2 0 80 0   0     0   1   42 40 *                     83.0 2 0 80 0   0     0   1   42 40                 83
1368053 1368053 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2020   grade_7 14 3 109 0   8     0   2   76 60 *                     136.0 14 3 109 0   8     0   2   76 60                 136
1368062 1368062 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other KG 12 2020   grade_7 2 0 13 0   0     0   1   14 2 *                     16.0 2 0 13 0   0     0   1   14 2                 16
1368584 1368584 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No Middle 06 08 2020   grade_7 39 38 341 0   36     0   6   240 220 *                     460.0 39 38 341 0   36     0   6   240 220                 460
1368587 1368587 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No Middle 06 08 2020   grade_7 62 51 348 1   43     0   13   255 263 *                     518.0 62 51 348 1   43     0   13   255 263                 518
1368590 1368590 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Pickering Middle   Regular School No Middle 06 08 2020   grade_7 65 24 107 1   22     0   14   122 111 *                     233.0 65 24 107 1   22     0   14   122 111                 233
1368601 1368601 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No High 06 12 2020   grade_7 3 0 4 0   0     0   2   8 1 *                     9.0 3 0 4 0   0     0   2   8 1                 9
1368609 1368609 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No Other PK 12 2020   grade_7 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1368629 1368629 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield Middle School   Regular School No Middle 05 08 2020   grade_7 135 2 8 0   14     0   2   88 73 *                     161.0 135 2 8 0   14     0   2   88 73                 161
1368713 1368713 MA Essex   school 2507260 168   Marblehead 250726001789 1680300 Marblehead Veterans Middle School   Regular School No Middle 07 08 2020   grade_7 233 6 14 0   2     0   5   139 121 *                     260.0 233 6 14 0   2     0   5   139 121                 260

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