Data source: Big Local News · About: Big Local

500 rows where grade = "grade_8", state = "MA" and year = 2020 sorted by female

View and edit SQL

year

  • 2020 · 500

grade

  • grade_8 · 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
1367688 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_8 * * * *   *     *   *   2 * *                     2.0                         2                   2
1368370 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2020   grade_8 * * * *   *     *   *   3 * *                     3.0                         3                   3
1368465 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
1370707 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 06 08 2020   grade_8 0 2 7 0   1     0   0   8 * *                     10.0 0 2 7 0   1     0   0   8                   10
1373190 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No High 07 12 2020   grade_8 * * * *   *     *   *   1 * *                     2.0                         1                   2
1374315 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
1365149 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Keough Memorial Academy   Alternative School No High 08 12 2020   grade_8 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1367199 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2020   grade_8 3 1 0 0   0     0   4   7 1 *                     8.0 3 1 0 0   0     0   4   7 1                 8
1368389 MA Middlesex   school 2507020 160   Lowell 250702002732 1600320 Leblanc Therapeutic Day School   Regular School No High 08 12 2020   grade_8 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1368426 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Dr. Janice Adie Day School   Special Education School No Other PK 12 2020   grade_8 * * * *   *     *   *   3 1 *                     4.0                         3 1                 4
1365401 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2020   grade_8 1 7 11 0   0     0   4   13 10 *                     23.0 1 7 11 0   0     0   4   13 10                 23
1370333 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2020   grade_8 18 0 3 0   0     0   1   12 10 *                     22.0 18 0 3 0   0     0   1   12 10                 22
1367318 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No Middle 05 08 2020   grade_8 168 16 15 0   4     1   5   108 100 *                     209.0 168 16 15 0   4     1   5   108 100                 209
1370314 MA Suffolk   school 2510050 248   Revere 251005002113 2480305 Susan B. Anthony Middle School   Regular School No Middle 06 08 2020   grade_8 62 4 130 0   6     0   1   103 100 *                     203.0 62 4 130 0   6     0   1   103 100                 203
1370480 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Belmonte Saugus Middle   Regular School No Middle 06 08 2020   grade_8 128 10 52 1   12     1   1   105 100 *                     205.0 128 10 52 1   12     1   1   105 100                 205
1366234 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No Middle 06 08 2020   grade_8 43 129 31 1   6     1   4   114 101 *                     215.0 43 129 31 1   6     1   4   114 101                 215
1373756 MA Essex   school 2509450 745   Pentucket 250945001512 7450405 Pentucket Regional Middle   Regular School No Middle 07 08 2020   grade_8 178 0 8 0   3     0   0   88 101 *                     189.0 178 0 8 0   3     0   0   88 101                 189
1369722 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton Middle   Regular School No Middle 06 08 2020   grade_8 165 3 10 1   5     0   9   91 102 *                     193.0 165 3 10 1   5     0   9   91 102                 193
1373319 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No Middle 06 08 2020   grade_8 160 6 15 0   4     0   7   90 102 *                     192.0 160 6 15 0   4     0   7   90 102                 192
1366118 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 East Middle School   Regular School No Middle 06 08 2020   grade_8 145 10 15 0   41     0   1   109 103 *                     212.0 145 10 15 0   41     0   1   109 103                 212
1367662 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Caleb Dustin Hunking School   Regular School No Elementary KG 08 2020   grade_8 153 11 40 0   5     1   4   111 103 *                     214.0 153 11 40 0   5     1   4   111 103                 214
1371593 MA Middlesex   school 2512210 315   Wayland 251221002502 3150305 Wayland Middle School   Regular School No Middle 06 08 2020   grade_8 143 12 7 1   36     0   12   108 103 *                     211.0 143 12 7 1   36     0   12   108 103                 211
1373725 MA Plymouth   school 2509150 740   Old Rochester 250915001473 7400405 Old Rochester Regional Jr High   Regular School No Middle 07 08 2020   grade_8 188 3 12 0   2     0   11   113 103 *                     216.0 188 3 12 0   2     0   11   113 103                 216
1364918 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No Middle 06 08 2020   grade_8 141 4 14 0   17     0   5   77 104 *                     181.0 141 4 14 0   17     0   5   77 104                 181
1365125 MA Hampshire   school 2502430 24   Belchertown 250243001873 240025 Jabish Middle School   Regular School No Middle 07 08 2020   grade_8 167 4 10 0   2     1   4   83 105 *                     188.0 167 4 10 0   2     1   4   83 105                 188
1366981 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 Birchland Park   Regular School No Middle 06 08 2020   grade_8 174 7 13 0   10     0   5   104 105 *                     209.0 174 7 13 0   10     0   5   104 105                 209
1364989 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No Middle 06 08 2020   grade_8 140 4 27 2   30     0   7   104 106 *                     210.0 140 4 27 2   30     0   7   104 106                 210
1370425 MA Essex   school 2510380 258   Salem 251038002404 2580305 Collins Middle   Regular School No Middle 06 08 2020   grade_8 84 19 103 0   8     0   10   118 106 *                     224.0 84 19 103 0   8     0   10   118 106                 224
1372861 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2020   grade_8 1 126 94 2   4     2   2   125 106 *                     231.0 1 126 94 2   4     2   2   125 106                 231
1373045 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst Regional Middle School   Regular School No Middle 07 08 2020   grade_8 119 20 44 1   10     0   18   106 106 *                     212.0 119 20 44 1   10     0   18   106 106                 212
1371789 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Stony Brook School   Regular School No Middle 06 08 2020   grade_8 145 3 0 0   54     0   7   102 107 *                     209.0 145 3 0 0   54     0   7   102 107                 209
1369161 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Wilson Middle   Regular School No Middle 05 08 2020   grade_8 192 6 7 0   13     0   14   124 108 *                     232.0 192 6 7 0   13     0   14   124 108                 232
1369653 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Robert E. Melican Middle School   Regular School No Middle 06 08 2020   grade_8 148 8 14 0   21     2   11   96 108 *                     204.0 148 8 14 0   21     2   11   96 108                 204
1370638 MA Bristol   school 2510860 273   Somerset 251086002537 2730305 Somerset Middle School   Regular School No Middle 06 08 2020   grade_8 205 1 10 0   0     0   2   110 108 *                     218.0 205 1 10 0   0     0   2   110 108                 218
1373466 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002141 6800310 Wilbraham Middle   Regular School No Middle 06 08 2020   grade_8 180 5 14 0   4     0   9   104 108 *                     212.0 180 5 14 0   4     0   9   104 108                 212
1373188 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002659 6250320 Bridgewater Middle School   Regular School No Middle 07 08 2020   grade_8 212 21 3 0   2     0   16   145 109 *                     254.0 212 21 3 0   2     0   16   145 109                 254
1373254 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2020   grade_8 140 17 35 5   4     0   16   108 109 *                     217.0 140 17 35 5   4     0   16   108 109                 217
1366041 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No Elementary PK 08 2020   grade_8 0 0 15 0   0     0   0   4 11 *                     15.0 0 0 15 0   0     0   0   4 11                 15
1366673 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Dupont Middle   Regular School No Middle 06 08 2020   grade_8 118 7 100 0   7     0   11   133 110 *                     243.0 118 7 100 0   7     0   11   133 110                 243
1370002 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Theodore Herberg Middle   Regular School No Middle 06 08 2020   grade_8 144 25 31 0   4     0   14   108 110 *                     218.0 144 25 31 0   4     0   14   108 110                 218
1371010 MA Hampden   school 2511130 281   Springfield 251113002602 2810330 M Marcus Kiley Middle   Regular School No Middle 06 08 2020   grade_8 19 48 160 0   7     0   4   128 110 *                     238.0 19 48 160 0   7     0   4   128 110                 238
1366564 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No Middle 05 08 2020   grade_8 165 12 11 0   33     1   5   116 111 *                     227.0 165 12 11 0   33     1   5   116 111                 227
1368405 MA Middlesex   school 2507020 160   Lowell 250702000086 1600345 Dr An Wang School   Regular School No Middle 05 08 2020   grade_8 57 18 82 0   33     0   10   89 111 *                     200.0 57 18 82 0   33     0   10   89 111                 200
1371004 MA Hampden   school 2511130 281   Springfield 251113002600 2810325 Forest Park Middle   Regular School No Middle 06 08 2020   grade_8 5 49 158 0   21     0   1   122 112 *                     234.0 5 49 158 0   21     0   1   122 112                 234
1370174 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No Middle 06 08 2020   grade_8 115 2 8 0   74     1   6   93 113 *                     206.0 115 2 8 0   74     1   6   93 113                 206
1367508 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No Middle 06 08 2020   grade_8 201 4 19 0   4     1   8   123 114 *                     237.0 201 4 19 0   4     1   8   123 114                 237
1366505 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Wm H Galvin Middle   Regular School No Middle 06 08 2020   grade_8 140 33 18 1   21     0   13   111 115 *                     226.0 140 33 18 1   21     0   13   111 115                 226
1367784 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Robert H. Adams Middle School   Regular School No Middle 06 08 2020   grade_8 189 2 17 1   17     0   2   112 116 *                     228.0 189 2 17 1   17     0   2   112 116                 228
1368714 MA Essex   school 2507260 168   Marblehead 250726001789 1680300 Marblehead Veterans Middle School   Regular School No Middle 07 08 2020   grade_8 188 10 18 2   2     0   8   112 116 *                     228.0 188 10 18 2   2     0   8   112 116                 228
1370071 MA Plymouth   school 2509720 239   Plymouth 250972001380 2390305 Plymouth South Middle   Regular School No Middle 06 08 2020   grade_8 236 3 5 1   1     0   11   140 117 *                     257.0 236 3 5 1   1     0   11   140 117                 257
1370519 MA Plymouth   school 2510560 264   Scituate 251056001690 2640305 Gates Middle School   Regular School No Middle 06 08 2020   grade_8 212 4 5 0   2     0   3   109 117 *                     226.0 212 4 5 0   2     0   3   109 117                 226
1366121 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 South Middle School   Regular School No Middle 06 08 2020   grade_8 169 14 10 0   34     0   0   108 118 *                     227.0 169 14 10 0   34     0   0   108 118                 227
1367914 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson High   Regular School No High 08 12 2020   grade_8 181 1 25 0   8     0   2   99 118 *                     217.0 181 1 25 0   8     0   2   99 118                 217
1369466 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Charles E Brown Middle   Regular School No Middle 06 08 2020   grade_8 149 10 12 0   56     0   11   120 118 *                     238.0 149 10 12 0   56     0   11   120 118                 238
1370448 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich STEM Academy   Regular School No Middle 07 08 2020   grade_8 221 1 3 0   2     0   2   110 118 *                     229.0 221 1 3 0   2     0   2   110 118                 229
1371904 MA Norfolk   school 2512810 335   Westwood 251281002097 3350305 E W Thurston Middle   Regular School No Middle 06 08 2020   grade_8 189 6 11 0   33     0   8   129 118 *                     247.0 189 6 11 0   33     0   8   129 118                 247
1365428 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No Elementary PK 08 2020   grade_8 9 2 12 0   3     0   1   15 12 *                     27.0 9 2 12 0   3     0   1   15 12                 27
1365581 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2020   grade_8 8 3 8 0   0     0   1   8 12 *                     20.0 8 3 8 0   0     0   1   8 12                 20
1365804 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2020   grade_8 0 10 12 0   0     0   5   15 12 *                     27.0 0 10 12 0   0     0   5   15 12                 27
1367208 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Resiliency Preparatory Academy   Alternative School No High 07 12 2020   grade_8 8 5 11 0   0     0   2   14 12 *                     26.0 8 5 11 0   0     0   2   14 12                 26
1372505 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 08 2020   grade_8 0 15 6 0   0     0   1   10 12 *                     22.0 0 15 6 0   0     0   1   10 12                 22
1372576 MA Essex   school 2500535 431   Community Day Charter Public School - R. Kingman Webster (District) 250053502719 4310205 Community Day Charter Public School - R. Kingman Webster   Regular School Yes Elementary PK 08 2020   grade_8 0 0 30 0   0     0   0   18 12 *                     30.0 0 0 30 0   0     0   0   18 12                 30
1372710 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2020   grade_8 17 2 4 0   0     0   4   15 12 *                     27.0 17 2 4 0   0     0   4   15 12                 27
1367195 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No Middle 06 08 2020   grade_8 138 24 40 0   13     0   11   106 120 *                     226.0 138 24 40 0   13     0   11   106 120                 226
1371505 MA Middlesex   school 2512000 308   Waltham 251200001977 3080415 John W. McDevitt Middle School   Regular School No Middle 06 08 2020   grade_8 92 19 109 0   7     0   4   111 120 *                     231.0 92 19 109 0   7     0   4   111 120                 231
1373833 MA Plymouth   school 2510830 760   Silver Lake 251083001721 7600405 Silver Lake Regional Middle School   Regular School No Middle 07 08 2020   grade_8 221 3 6 1   5     1   5   122 120 *                     242.0 221 3 6 1   5     1   5   122 120                 242
1366743 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No Middle 06 08 2020   grade_8 172 12 18 1   16     0   17   115 121 *                     236.0 172 12 18 1   16     0   17   115 121                 236
1371143 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 O'Donnell Middle School   Regular School No Middle 06 08 2020   grade_8 164 71 28 1   25     2   13   183 121 *                     304.0 164 71 28 1   25     2   13   183 121                 304
1367387 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No Middle 06 08 2020   grade_8 149 7 85 0   7     0   4   130 122 *                     252.0 149 7 85 0   7     0   4   130 122                 252
1366240 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No Middle 06 08 2020   grade_8 52 82 70 0   9     0   10   99 124 *                     223.0 52 82 70 0   9     0   10   99 124                 223
1371321 MA Middlesex   school 2511580 295   Tewksbury 251158000366 2950305 John W. Wynn Middle   Regular School No Middle 07 08 2020   grade_8 242 12 11 0   12     0   2   155 124 *                     279.0 242 12 11 0   12     0   2   155 124                 279
1371992 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No Middle 06 08 2020   grade_8 228 5 11 1   9     1   11   142 124 *                     266.0 228 5 11 1   9     1   11   142 124                 266
1366918 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury Middle   Regular School No Middle 06 08 2020   grade_8 223 2 5 0   6     0   12   123 125 *                     248.0 223 2 5 0   6     0   12   123 125                 248
1369779 MA Norfolk   school 2509060 220   Norwood 250906001468 2200305 Dr. Philip O. Coakley Middle School   Regular School No Middle 06 08 2020   grade_8 157 36 34 0   12     1   5   120 125 *                     245.0 157 36 34 0   12     1   5   120 125                 245
1371409 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Galvin Middle School   Regular School No Middle 05 08 2020   grade_8 205 9 23 2   7     0   7   128 125 *                     253.0 205 9 23 2   7     0   7   128 125                 253
1367238 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No Middle 07 08 2020   grade_8 204 19 16 1   2     0   14   130 126 *                     256.0 204 19 16 1   2     0   14   130 126                 256
1368997 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 John T. Nichols Middle   Regular School No Middle 06 08 2020   grade_8 229 5 8 5   6     0   10   137 126 *                     263.0 229 5 8 5   6     0   10   137 126                 263
1367384 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Fuller Middle   Regular School No Middle 06 08 2020   grade_8 107 17 113 0   7     1   5   123 127 *                     250.0 107 17 113 0   7     1   5   123 127                 250
1366373 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Marshall Simonds Middle   Regular School No Middle 06 08 2020   grade_8 177 13 15 1   41     0   7   126 128 *                     254.0 177 13 15 1   41     0   7   126 128                 254
1368610 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No Other PK 12 2020   grade_8 37 29 194 0   15     0   12   159 128 *                     287.0 37 29 194 0   15     0   12   159 128                 287
1367888 MA Middlesex   school 2506330 139   Hopkinton 250633000468 1390305 Hopkinton Middle School   Regular School No Middle 06 08 2020   grade_8 188 6 14 1   36     0   10   126 129 *                     255.0 188 6 14 1   36     0   10   126 129                 255
1365306 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2020   grade_8 0 8 14 0   0     0   1   10 13 *                     23.0 0 8 14 0   0     0   1   10 13                 23
1365653 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2020   grade_8 10 9 8 0   0     0   1   15 13 *                     28.0 10 9 8 0   0     0   1   15 13                 28
1364833 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam Junior High   Regular School No Middle 07 08 2020   grade_8 236 10 20 0   12     0   9   157 130 *                     287.0 236 10 20 0   12     0   9   157 130                 287
1367531 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton Middle   Regular School No Middle 07 08 2020   grade_8 201 5 16 2   28     2   6   130 130 *                     260.0 201 5 16 2   28     2   6   130 130                 260
1373345 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville Middle School   Regular School No Middle 06 09 2020   grade_8 252 1 4 1   0     0   4   130 132 *                     262.0 252 1 4 1   0     0   4   130 132                 262
1368786 MA Plymouth   school 2507350 171   Marshfield 250735001143 1710310 Furnace Brook Middle   Regular School No Middle 06 08 2020   grade_8 260 0 8 0   3     0   7   144 134 *                     278.0 260 0 8 0   3     0   7   144 134                 278
1370567 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon Middle   Regular School No Middle 06 08 2020   grade_8 169 12 15 1   80     0   13   156 134 *                     290.0 169 12 15 1   80     0   13   156 134                 290
1373901 MA Worcester   school 2511490 770   Tantasqua 251149001899 7700405 Tantasqua Regional Jr High   Regular School No Middle 07 08 2020   grade_8 262 4 20 0   1     0   7   160 134 *                     294.0 262 4 20 0   1     0   7   160 134                 294
1368932 MA Middlesex   school 2507620 178   Melrose 250762002557 1780305 Melrose Middle   Regular School No Middle 06 08 2020   grade_8 197 26 20 0   7     0   8   123 135 *                     258.0 197 26 20 0   7     0   8   123 135                 258
1366785 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No Middle 06 08 2020   grade_8 235 5 24 0   9     0   6   142 137 *                     279.0 235 5 24 0   9     0   6   142 137                 279
1367003 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No Middle 06 08 2020   grade_8 245 12 17 0   10     0   9   154 139 *                     293.0 245 12 17 0   10     0   9   154 139                 293
1365612 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2020   grade_8 0 9 21 0   3     0   0   19 14 *                     33.0 0 9 21 0   3     0   0   19 14                 33
1367639 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No High 07 12 2020   grade_8 29 1 0 0   0     0   0   16 14 *                     30.0 29 1 0 0   0     0   0   16 14                 30
1372779 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_8 18 1 1 0   0     0   1   7 14 *                     21.0 18 1 1 0   0     0   1   7 14                 21
1366670 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No Middle 06 08 2020   grade_8 134 6 109 0   8     0   17   134 140 *                     274.0 134 6 109 0   8     0   17   134 140                 274
1368144 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Sky View Middle School   Regular School No Middle 06 08 2020   grade_8 140 23 113 0   15     0   9   160 140 *                     300.0 140 23 113 0   15     0   9   160 140                 300
1369085 MA Norfolk   school 2507980 189   Milton 250798001257 1890410 Charles S Pierce Middle   Regular School No Middle 06 08 2020   grade_8 212 41 19 0   19     0   13   163 141 *                     304.0 212 41 19 0   19     0   13   163 141                 304
1365222 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly Middle School   Regular School No Middle 05 08 2020   grade_8 239 9 54 0   9     0   9   175 145 *                     320.0 239 9 54 0   9     0   9   175 145                 320
1374301 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2020   grade_8 156 19 37 0   7     0   18   91 146 *                     237.0 156 19 37 0   7     0   18   91 146                 237

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