enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1374253 1374253 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Secondary 06 11 2020   grade_7 4 98 4 0   0     0   1   47 60 *                     107.0 4 98 4 0   0     0   1   47 60                 107
1370219 1370219 MA Norfolk   school 2509930 244   Randolph 250993001392 2440410 Randolph Community Middle   Regular School No Middle 06 08 2020   grade_7 25 92 45 1   44     0   14   118 103 *                     221.0 25 92 45 1   44     0   14   118 103                 221
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
1365740 1365740 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2020   grade_7 2 9 17 0   0     0   0   17 11 *                     28.0 2 9 17 0   0     0   0   17 11                 28
1366120 1366120 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 South Middle School   Regular School No Middle 06 08 2020   grade_7 181 9 8 0   53     0   1   122 130 *                     252.0 181 9 8 0   53     0   1   122 130                 252
1366320 1366320 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No Elementary KG 08 2020   grade_7 48 9 8 0   8     0   5   29 49 *                     78.0 48 9 8 0   8     0   5   29 49                 78
1366931 1366931 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No High 07 12 2020   grade_7 151 9 1 1   0     1   6   100 69 *                     169.0 151 9 1 1   0     1   6   100 69                 169
1367268 1367268 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No Middle 05 08 2020   grade_7 31 9 92 0   4     1   12   77 72 *                     149.0 31 9 92 0   4     1   12   77 72                 149
1368140 1368140 MA Worcester   school 2506780 153   Leominster 250678000742 1530045 Samoset School   Regular School No Middle 06 08 2020   grade_7 90 9 59 1   4     1   5   78 90 *                     169.0 90 9 59 1   4     1   5   78 90                 169
1368870 1368870 MA Middlesex   school 2507560 176   Medford 250756001638 1760315 Madeleine Dugger Andrews   Regular School No Middle 06 08 2020   grade_7 98 9 11 1   11     0   12   82 60 *                     142.0 98 9 11 1   11     0   12   82 60                 142
1369160 1369160 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Wilson Middle   Regular School No Middle 05 08 2020   grade_7 185 9 13 0   15     0   17   126 113 *                     239.0 185 9 13 0   15     0   17   126 113                 239
1369465 1369465 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Charles E Brown Middle   Regular School No Middle 06 08 2020   grade_7 180 9 18 1   51     0   18   141 136 *                     277.0 180 9 18 1   51     0   18   141 136                 277
1369468 1369468 MA Middlesex   school 2508610 207   Newton 250861000314 2070315 F A Day Middle   Regular School No Middle 06 08 2020   grade_7 215 9 31 1   52     0   20   163 165 *                     328.0 215 9 31 1   52     0   20   163 165                 328
1371566 1371566 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown Middle   Regular School No Middle 06 08 2020   grade_7 148 9 19 2   19     0   8   114 91 *                     205.0 148 9 19 2   19     0   8   114 91                 205
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
1372963 1372963 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2020   grade_7 30 9 3 0   9     0   8   35 24 *                     59.0 30 9 3 0   9     0   8   35 24                 59
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
1374268 1374268 MA Hampden   school 2500588 3516   Hampden Charter School of Science West (District) 250058802888 35160305 Hampden Charter School of Science West   Regular School Yes Middle 06 10 2020   grade_7 36 9 21 0   0     0   1   33 34 *                     67.0 36 9 21 0   0     0   1   33 34                 67
1372679 1372679 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2020   grade_7 33 86 4 0   15     0   10   69 79 *                     148.0 33 86 4 0   15     0   10   69 79                 148
1366181 1366181 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2020   grade_7 16 84 19 1   2     0   7   65 64 *                     129.0 16 84 19 1   2     0   7   65 64                 129
1372541 1372541 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_7 8 82 81 1   2     0   8   93 89 *                     182.0 8 82 81 1   2     0   8   93 89                 182
1365427 1365427 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No Elementary PK 08 2020   grade_7 15 8 14 0   5     0   1   23 20 *                     43.0 15 8 14 0   5     0   1   23 20                 43
1365750 1365750 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No Elementary PK 08 2020   grade_7 6 8 20 0   2     0   2   22 16 *                     38.0 6 8 20 0   2     0   2   22 16                 38
1366592 1366592 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2020   grade_7 7 8 112 0   0     0   2   58 71 *                     129.0 7 8 112 0   0     0   2   58 71                 129
1366669 1366669 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No Middle 06 08 2020   grade_7 139 8 114 0   4     0   14   148 131 *                     279.0 139 8 114 0   4     0   14   148 131                 279
1368206 1368206 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No Middle 06 08 2020   grade_7 133 8 10 0   140     0   30   154 167 *                     321.0 133 8 10 0   140     0   30   154 167                 321
1368387 1368387 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 James S Daley Middle School   Regular School No Middle 05 08 2020   grade_7 41 8 34 0   76     0   7   96 70 *                     166.0 41 8 34 0   76     0   7   96 70                 166
1369022 1369022 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No Middle 06 08 2020   grade_7 201 8 110 13   5     0   14   187 164 *                     351.0 201 8 110 13   5     0   14   187 164                 351
1369198 1369198 MA Norfolk   school 2508370 199   Needham 250837001308 1990405 Pollard Middle   Regular School No Middle 07 08 2020   grade_7 363 8 30 0   35     0   23   226 233 *                     459.0 363 8 30 0   35     0   23   226 233                 459
1369471 1369471 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Oak Hill Middle   Regular School No Middle 06 08 2020   grade_7 110 8 10 0   61     0   13   115 87 *                     202.0 110 8 10 0   61     0   13   115 87                 202
1370310 1370310 MA Suffolk   school 2510050 248   Revere 251005001976 2480057 Garfield Middle School   Regular School No Middle 06 08 2020   grade_7 68 8 119 0   7     0   3   103 102 *                     205.0 68 8 119 0   7     0   3   103 102                 205
1370518 1370518 MA Plymouth   school 2510560 264   Scituate 251056001690 2640305 Gates Middle School   Regular School No Middle 06 08 2020   grade_7 210 8 5 0   1     0   2   116 110 *                     226.0 210 8 5 0   1     0   2   116 110                 226
1370566 1370566 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon Middle   Regular School No Middle 06 08 2020   grade_7 164 8 11 0   87     0   15   131 154 *                     285.0 164 8 11 0   87     0   15   131 154                 285
1370747 1370747 MA Worcester   school 2511010 277   Southbridge 251101002865 2770315 Southbridge Middle School   Regular School No Middle 06 08 2020   grade_7 56 8 83 0   4     0   2   83 70 *                     153.0 56 8 83 0   4     0   2   83 70                 153
1372454 1372454 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes High 05 12 2020   grade_7 24 8 140 0   0     1   1   88 86 *                     174.0 24 8 140 0   0     1   1   88 86                 174
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
1372867 1372867 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter School   Regular School Yes High 06 12 2020   grade_7 30 8 24 0   8     0   2   40 32 *                     72.0 30 8 24 0   8     0   2   40 32                 72
1373286 1373286 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000575 6550405 Dover-Sherborn Regional Middle School   Regular School No Middle 06 08 2020   grade_7 124 8 5 0   20     0   6   93 70 *                     163.0 124 8 5 0   20     0   6   93 70                 163
1372386 1372386 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Forest Grove Middle   Regular School No Middle 07 08 2020   grade_7 168 71 167 2   29     0   24   236 225 *                     461.0 168 71 167 2   29     0   24   236 225                 461
1364988 1364988 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No Middle 06 08 2020   grade_7 147 7 28 0   29     0   8   111 108 *                     219.0 147 7 28 0   29     0   8   111 108                 219
1365124 1365124 MA Hampshire   school 2502430 24   Belchertown 250243001873 240025 Jabish Middle School   Regular School No Middle 07 08 2020   grade_7 162 7 5 0   4     1   5   101 83 *                     184.0 162 7 5 0   4     1   5   101 83                 184
1365258 1365258 MA Middlesex   school 2502670 31   Billerica 250267000182 310310 Locke Middle   Regular School No Middle 05 07 2020   grade_7 147 7 10 0   17     0   7   90 98 *                     188.0 147 7 10 0   17     0   7   90 98                 188
1366283 1366283 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Coolidge Corner School   Regular School No Elementary PK 08 2020   grade_7 52 7 18 0   9     0   7   50 43 *                     93.0 52 7 18 0   9     0   7   50 43                 93
1366699 1366699 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Middle 05 08 2020   grade_7 92 7 36 0   1     1   3   83 57 *                     140.0 92 7 36 0   1     1   3   83 57                 140
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
1367258 1367258 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Middle School   Regular School No Middle 05 08 2020   grade_7 43 7 83 0   14     0   13   79 81 *                     160.0 43 7 83 0   14     0   13   79 81                 160
1368092 1368092 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No Middle 05 08 2020   grade_7 83 7 13 0   3     0   5   62 49 *                     111.0 83 7 13 0   3     0   5   62 49                 111
1368225 1368225 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No Elementary PK 08 2020   grade_7 29 7 3 0   3     0   6   25 23 *                     48.0 29 7 3 0   3     0   6   25 23                 48
1370479 1370479 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Belmonte Saugus Middle   Regular School No Middle 06 08 2020   grade_7 139 7 39 1   10     3   5   107 97 *                     204.0 139 7 39 1   10     3   5   107 97                 204
1371032 1371032 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Conservatory of the Arts   Regular School No High 06 12 2020   grade_7 5 7 38 0   0     0   2   14 38 *                     52.0 5 7 38 0   0     0   2   14 38                 52
1371361 1371361 MA Middlesex   school 2511760 301   Tyngsborough 251176001715 3010305 Tyngsborough Middle   Regular School No Middle 06 08 2020   grade_7 95 7 11 0   6     0   1   67 53 *                     120.0 95 7 11 0   6     0   1   67 53                 120
1371448 1371448 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Bird Middle   Regular School No Middle 06 08 2020   grade_7 100 7 11 0   5     0   3   61 65 *                     126.0 100 7 11 0   5     0   3   61 65                 126
1374006 1374006 MA Worcester   school 2511880 775   Wachusett 251188000888 7750305 Mountview Middle   Regular School No Middle 06 08 2020   grade_7 237 7 21 0   13     0   8   142 144 *                     286.0 237 7 21 0   13     0   8   142 144                 286
1366021 1366021 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No High 06 12 2020   grade_7 7 67 35 0   2     0   5   58 58 *                     116.0 7 67 35 0   2     0   5   58 58                 116
1372391 1372391 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No Middle 06 08 2020   grade_7 134 67 168 2   42     0   17   226 204 *                     430.0 134 67 168 2   42     0   17   226 204                 430
1372490 1372490 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes High 06 12 2020   grade_7 2 65 24 0   1     0   5   52 45 *                     97.0 2 65 24 0   1     0   5   52 45                 97
1372510 1372510 MA Suffolk   school 2500077 419   Helen Y. Davis Leadership Academy Charter Public (District) 250007702091 4190305 Helen Y. Davis Leadership Academy Charter Public School   Regular School Yes Middle 06 08 2020   grade_7 0 64 16 0   0     0   0   42 38 *                     80.0 0 64 16 0   0     0   0   42 38                 80
1371142 1371142 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 O'Donnell Middle School   Regular School No Middle 06 08 2020   grade_7 155 63 39 0   8     5   22   135 157 *                     292.0 155 63 39 0   8     5   22   135 157                 292
1372388 1372388 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No Middle 07 08 2020   grade_7 70 62 187 0   19     1   14   175 178 *                     353.0 70 62 187 0   19     1   14   175 178                 353
1372666 1372666 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2020   grade_7 21 61 32 0   1     0   0   56 59 *                     115.0 21 61 32 0   1     0   0   56 59                 115
1372831 1372831 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston   Regular School Yes Middle 06 08 2020   grade_7 3 61 77 0   0     1   3   79 66 *                     145.0 3 61 77 0   0     1   3   79 66                 145
1365678 1365678 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No Elementary PK 08 2020   grade_7 4 6 18 0   0     0   2   14 16 *                     30.0 4 6 18 0   0     0   2   14 16                 30
1366563 1366563 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No Middle 05 08 2020   grade_7 130 6 14 0   20     0   11   109 72 *                     181.0 130 6 14 0   20     0   11   109 72                 181
1366596 1366596 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2020   grade_7 10 6 147 1   2     0   2   96 72 *                     168.0 10 6 147 1   2     0   2   96 72                 168
1367610 1367610 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No Middle 05 08 2020   grade_7 193 6 7 0   6     0   3   99 116 *                     215.0 193 6 7 0   6     0   3   99 116                 215
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
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
1367859 1367859 MA Hampden   school 2506270 137   Holyoke 250627002897 1370320 Holyoke STEM Academy   Regular School No Middle 06 08 2020   grade_7 9 6 79 0   2     0   2   52 46 *                     98.0 9 6 79 0   2     0   2   52 46                 98
1367913 1367913 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 David J. Quinn Middle School   Regular School No Middle 05 07 2020   grade_7 159 6 25 0   2     0   11   105 98 *                     203.0 159 6 25 0   2     0   11   105 98                 203
1368230 1368230 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No Middle 04 08 2020   grade_7 26 6 7 0   1     0   4   19 25 *                     44.0 26 6 7 0   1     0   4   19 25                 44
1368311 1368311 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Pyne Arts   Regular School No Elementary PK 08 2020   grade_7 22 6 22 0   2     0   3   23 32 *                     55.0 22 6 22 0   2     0   3   23 32                 55
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
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
1370173 1370173 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No Middle 06 08 2020   grade_7 90 6 9 0   85     2   9   94 107 *                     201.0 90 6 9 0   85     2   9   94 107                 201
1370281 1370281 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Rumney Marsh Academy   Regular School No Middle 06 08 2020   grade_7 64 6 121 1   13     0   10   103 112 *                     215.0 64 6 121 1   13     0   10   103 112                 215
1371042 1371042 MA Hampden   school 2511130 281   Springfield 251113002855 2810485 Van Sickle Academy   Regular School No Middle 06 08 2020   grade_7 4 6 57 0   3     0   0   37 33 *                     70.0 4 6 57 0   3     0   0   37 33                 70
1371408 1371408 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Galvin Middle School   Regular School No Middle 05 08 2020   grade_7 218 6 22 1   7     0   11   134 131 *                     265.0 218 6 22 1   7     0   11   134 131                 265
1371451 1371451 MA Norfolk   school 2511970 307   Walpole 251197001965 3070310 Eleanor N Johnson Middle   Regular School No Middle 06 08 2020   grade_7 112 6 11 2   10     0   4   76 69 *                     145.0 112 6 11 2   10     0   4   76 69                 145
1371714 1371714 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No High 07 12 2020   grade_7 91 6 5 0   1     0   4   47 60 *                     107.0 91 6 5 0   1     0   4   47 60                 107
1371785 1371785 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No Middle 06 08 2020   grade_7 107 6 5 2   54     0   10   100 84 *                     184.0 107 6 5 2   54     0   10   100 84                 184
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
1373492 1373492 MA Norfolk   school 2506510 690   King Philip 250651000941 6900510 King Philip Middle School   Regular School No Middle 07 08 2020   grade_7 306 6 15 1   11     0   13   181 171 *                     352.0 306 6 15 1   11     0   13   181 171                 352
1373724 1373724 MA Plymouth   school 2509150 740   Old Rochester 250915001473 7400405 Old Rochester Regional Jr High   Regular School No Middle 07 08 2020   grade_7 186 6 5 0   4     0   13   118 96 *                     214.0 186 6 5 0   4     0   13   118 96                 214
1365869 1365869 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Lilla G. Frederick Middle School   Regular School No Middle 06 08 2020   grade_7 2 57 70 0   13     1   6   87 62 *                     149.0 2 57 70 0   13     1   6   87 62                 149
1372384 1372384 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Burncoat Middle School   Regular School No Middle 07 08 2020   grade_7 106 57 161 0   15     0   22   188 173 *                     361.0 106 57 161 0   15     0   22   188 173                 361
1371009 1371009 MA Hampden   school 2511130 281   Springfield 251113002602 2810330 M Marcus Kiley Middle   Regular School No Middle 06 08 2020   grade_7 22 56 160 0   3     0   4   145 100 *                     245.0 22 56 160 0   3     0   4   145 100                 245
1365958 1365958 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No High 07 12 2020   grade_7 93 53 81 1   44     0   14   120 166 *                     286.0 93 53 81 1   44     0   14   120 166                 286
1365846 1365846 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2020   grade_7 2 52 38 0   0     0   2   55 39 *                     94.0 2 52 38 0   0     0   2   55 39                 94
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
1369084 1369084 MA Norfolk   school 2507980 189   Milton 250798001257 1890410 Charles S Pierce Middle   Regular School No Middle 06 08 2020   grade_7 231 50 11 0   20     1   11   159 165 *                     324.0 231 50 11 0   20     1   11   159 165                 324
1370996 1370996 MA Hampden   school 2511130 281   Springfield 251113002599 2810320 John J Duggan Middle   Regular School No High 06 12 2020   grade_7 28 50 88 0   2     0   5   93 80 *                     173.0 28 50 88 0   2     0   5   93 80                 173
1372589 1372589 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge   Regular School Yes High 06 12 2020   grade_7 3 50 6 0   3     1   3   36 30 *                     66.0 3 50 6 0   3     1   3   36 30                 66
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
1365652 1365652 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2020   grade_7 6 5 5 0   2     0   2   9 11 *                     20.0 6 5 5 0   2     0   2   9 11                 20
1365767 1365767 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2020   grade_7 12 5 10 0   0     0   5   13 19 *                     32.0 12 5 10 0   0     0   5   13 19                 32
1367433 1367433 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No Middle 06 08 2020   grade_7 104 5 6 0   10     0   1   69 57 *                     126.0 104 5 6 0   10     0   1   69 57                 126
1367745 1367745 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No Middle 06 08 2020   grade_7 268 5 9 0   12     0   13   152 155 *                     307.0 268 5 9 0   12     0   13   152 155                 307
1368379 1368379 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No Elementary PK 08 2020   grade_7 10 5 23 0   16     0   1   30 25 *                     55.0 10 5 23 0   16     0   1   30 25                 55
1368435 1368435 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Paul R Baird Middle   Regular School No Middle 06 08 2020   grade_7 175 5 18 2   0     0   5   109 96 *                     205.0 175 5 18 2   0     0   5   109 96                 205
1368966 1368966 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Tenney Grammar School   Regular School No Elementary PK 08 2020   grade_7 55 5 99 0   7     0   7   98 75 *                     173.0 55 5 99 0   7     0   7   98 75                 173

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