enrollments

Data source: Big Local News · About: Big Local

572 rows where grade = "grade_6", state = "MA" and year = 2020 sorted by female

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 572 ✖

grade ✖

  • grade_6 · 572 ✖
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
1367686 1367686 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_6 * * * *   *     *   *   1 * *                     1.0                         1                   1
1368368 1368368 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2020   grade_6 * * * *   *     *   *   5 * *                     5.0                         5                   5
1368463 1368463 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_6 * * * *   *     *   *   * * *                     0.0                                             0
1370705 1370705 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 06 08 2020   grade_6 * * * *   *     *   *   1 * *                     1.0                         1                   1
1374313 1374313 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_6 * * * *   *     *   *   * * *                     0.0                                             0
1367064 1367064 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2020   grade_6 4 2 2 0   0     0   1   8 1 *                     9.0 4 2 2 0   0     0   1   8 1                 9
1368061 1368061 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other KG 12 2020   grade_6 0 0 9 0   0     0   0   8 1 *                     9.0 0 0 9 0   0     0   0   8 1                 9
1371011 1371011 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield Public Day Middle School   Regular School No Middle 06 08 2020   grade_6 1 4 9 0   0     0   0   13 1 *                     14.0 1 4 9 0   0     0   0   13 1                 14
1373454 1373454 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000822 6800005 Green Meadows Elementary   Regular School No Elementary PK 08 2020   grade_6 8 1 3 0   0     0   2   13 1 *                     14.0 8 1 3 0   0     0   2   13 1                 14
1365651 1365651 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2020   grade_6 13 6 5 0   0     0   0   14 10 *                     24.0 13 6 5 0   0     0   0   14 10                 24
1369944 1369944 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No Elementary KG 06 2020   grade_6 18 0 1 0   1     0   1   11 10 *                     21.0 18 0 1 0   1     0   1   11 10                 21
1370331 1370331 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2020   grade_6 11 0 2 0   0     0   1   4 10 *                     14.0 11 0 2 0   0     0   1   4 10                 14
1371801 1371801 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton Elementary School   Regular School No Elementary PK 06 2020   grade_6 16 0 0 0   0     0   0   6 10 *                     16.0 16 0 0 0   0     0   0   6 10                 16
1373768 1373768 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Bernardston Elementary   Regular School No Elementary PK 06 2020   grade_6 18 0 0 0   0     0   0   8 10 *                     18.0 18 0 0 0   0     0   0   8 10                 18
1373776 1373776 MA Franklin   school 2509600 750   Pioneer Valley 250960002614 7500008 Northfield Elementary   Regular School No Elementary PK 06 2020   grade_6 22 0 0 0   0     0   0   12 10 *                     22.0 22 0 0 0   0     0   0   12 10                 22
1370069 1370069 MA Plymouth   school 2509720 239   Plymouth 250972001380 2390305 Plymouth South Middle   Regular School No Middle 06 08 2020   grade_6 195 1 10 1   0     0   5   112 100 *                     212.0 195 1 10 1   0     0   5   112 100                 212
1367379 1367379 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No Middle 06 08 2020   grade_6 150 12 40 0   2     0   11   114 101 *                     215.0 150 12 40 0   2     0   11   114 101                 215
1368434 1368434 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Paul R Baird Middle   Regular School No Middle 06 08 2020   grade_6 158 4 38 2   0     0   6   107 101 *                     208.0 158 4 38 2   0     0   6   107 101                 208
1365109 1365109 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 John Glenn Middle   Regular School No Middle 06 08 2020   grade_6 136 14 5 0   39     0   8   100 102 *                     202.0 136 14 5 0   39     0   8   100 102                 202
1368706 1368706 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Village School   Regular School No Elementary 03 06 2020   grade_6 167 4 15 0   3     0   8   95 102 *                     197.0 167 4 15 0   3     0   8   95 102                 197
1370446 1370446 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No Elementary 03 06 2020   grade_6 187 4 3 2   5     0   2   101 102 *                     203.0 187 4 3 2   5     0   2   101 102                 203
1374060 1374060 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman Middle   Regular School No Middle 06 08 2020   grade_6 167 8 12 2   1     0   7   95 102 *                     197.0 167 8 12 2   1     0   7   95 102                 197
1371532 1371532 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No Middle 05 07 2020   grade_6 128 15 11 3   2     0   31   87 103 *                     190.0 128 15 11 3   2     0   31   87 103                 190
1369720 1369720 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton Middle   Regular School No Middle 06 08 2020   grade_6 182 5 4 0   7     0   9   103 104 *                     207.0 182 5 4 0   7     0   9   103 104                 207
1366916 1366916 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury Middle   Regular School No Middle 06 08 2020   grade_6 217 1 7 0   2     0   6   128 105 *                     233.0 217 1 7 0   2     0   6   128 105                 233
1367316 1367316 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No Middle 05 08 2020   grade_6 177 10 13 1   9     0   7   112 105 *                     217.0 177 10 13 1   9     0   7   112 105                 217
1369547 1369547 MA Hampshire   school 2508850 210   Northampton 250885001430 2100410 John F Kennedy Middle School   Regular School No Middle 06 08 2020   grade_6 141 7 36 0   4     0   19   101 105 *                     207.0 141 7 36 0   4     0   19   101 105                 207
1369777 1369777 MA Norfolk   school 2509060 220   Norwood 250906001468 2200305 Dr. Philip O. Coakley Middle School   Regular School No Middle 06 08 2020   grade_6 140 23 36 0   12     0   9   115 105 *                     220.0 140 23 36 0   12     0   9   115 105                 220
1367506 1367506 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No Middle 06 08 2020   grade_6 178 3 26 1   3     0   7   112 106 *                     218.0 178 3 26 1   3     0   7   112 106                 218
1371591 1371591 MA Middlesex   school 2512210 315   Wayland 251221002502 3150305 Wayland Middle School   Regular School No Middle 06 08 2020   grade_6 129 15 13 0   32     1   16   100 106 *                     206.0 129 15 13 0   32     1   16   100 106                 206
1365142 1365142 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial School   Regular School No Middle 04 07 2020   grade_6 158 6 11 0   3     0   7   78 107 *                     185.0 158 6 11 0   3     0   7   78 107                 185
1365254 1365254 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Marshall Middle School   Regular School No Middle 05 07 2020   grade_6 168 14 18 0   16     0   4   112 108 *                     220.0 168 14 18 0   16     0   4   112 108                 220
1370172 1370172 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No Middle 06 08 2020   grade_6 94 8 6 0   105     2   4   111 108 *                     219.0 94 8 6 0   105     2   4   111 108                 219
1371503 1371503 MA Middlesex   school 2512000 308   Waltham 251200001977 3080415 John W. McDevitt Middle School   Regular School No Middle 06 08 2020   grade_6 71 15 131 0   9     0   4   122 108 *                     230.0 71 15 131 0   9     0   4   122 108                 230
1367912 1367912 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 David J. Quinn Middle School   Regular School No Middle 05 07 2020   grade_6 172 3 31 0   3     0   5   105 109 *                     214.0 172 3 31 0   3     0   5   105 109                 214
1371285 1371285 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Joseph H Martin   Regular School No Middle 05 07 2020   grade_6 157 38 23 0   2     0   13   124 109 *                     233.0 157 38 23 0   2     0   13   124 109                 233
1371902 1371902 MA Norfolk   school 2512810 335   Westwood 251281002097 3350305 E W Thurston Middle   Regular School No Middle 06 08 2020   grade_6 164 5 17 1   25     0   11   114 109 *                     223.0 164 5 17 1   25     0   11   114 109                 223
1367774 1367774 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No Elementary PK 06 2020   grade_6 20 0 1 0   1     0   0   11 11 *                     22.0 20 0 1 0   1     0   0   11 11                 22
1372286 1372286 MA Worcester   school 2513230 348   Worcester 251323002233 3480185 Midland Street   Regular School No Elementary KG 06 2020   grade_6 14 4 4 0   3     0   3   17 11 *                     28.0 14 4 4 0   3     0   3   17 11                 28
1373796 1373796 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary PK 06 2020   grade_6 28 0 4 0   0     0   0   21 11 *                     32.0 28 0 4 0   0     0   0   21 11                 32
1366225 1366225 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 East Middle School   Regular School No Middle 06 08 2020   grade_6 27 142 47 1   3     0   11   121 110 *                     231.0 27 142 47 1   3     0   11   121 110                 231
1366232 1366232 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No Middle 06 08 2020   grade_6 42 135 32 1   8     0   15   123 110 *                     233.0 42 135 32 1   8     0   15   123 110                 233
1366979 1366979 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 Birchland Park   Regular School No Middle 06 08 2020   grade_6 165 6 10 0   19     0   9   99 110 *                     209.0 165 6 10 0   19     0   9   99 110                 209
1369159 1369159 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Wilson Middle   Regular School No Middle 05 08 2020   grade_6 181 13 7 1   21     0   6   119 110 *                     229.0 181 13 7 1   21     0   6   119 110                 229
1373464 1373464 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002141 6800310 Wilbraham Middle   Regular School No Middle 06 08 2020   grade_6 178 7 20 0   2     0   7   104 110 *                     214.0 178 7 20 0   2     0   7   104 110                 214
1364987 1364987 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No Middle 06 08 2020   grade_6 150 4 32 4   30     0   9   118 111 *                     229.0 150 4 32 4   30     0   9   118 111                 229
1373252 1373252 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No Middle 06 07 2020   grade_6 133 29 44 7   4     1   12   119 111 *                     230.0 133 29 44 7   4     1   12   119 111                 230
1373343 1373343 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville Middle School   Regular School No Middle 06 09 2020   grade_6 223 4 0 0   2     0   3   121 111 *                     232.0 223 4 0 0   2     0   3   121 111                 232
1368589 1368589 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Pickering Middle   Regular School No Middle 06 08 2020   grade_6 76 12 106 3   19     0   9   113 112 *                     225.0 76 12 106 3   19     0   9   113 112                 225
1368891 1368891 MA Norfolk   school 2507590 177   Medway 250759002483 1770305 Medway Middle   Regular School No Middle 05 08 2020   grade_6 157 4 11 0   7     1   6   74 112 *                     186.0 157 4 11 0   7     1   6   74 112                 186
1371787 1371787 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Stony Brook School   Regular School No Middle 06 08 2020   grade_6 121 1 8 1   56     0   4   79 112 *                     191.0 121 1 8 1   56     0   4   79 112                 191
1366741 1366741 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No Middle 06 08 2020   grade_6 175 15 21 0   17     0   13   128 113 *                     241.0 175 15 21 0   17     0   13   128 113                 241
1371008 1371008 MA Hampden   school 2511130 281   Springfield 251113002602 2810330 M Marcus Kiley Middle   Regular School No Middle 06 08 2020   grade_6 26 49 162 1   4     0   8   137 113 *                     250.0 26 49 162 1   4     0   8   137 113                 250
1366119 1366119 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 South Middle School   Regular School No Middle 06 08 2020   grade_6 145 6 4 2   52     0   3   98 114 *                     212.0 145 6 4 2   52     0   3   98 114                 212
1369470 1369470 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Oak Hill Middle   Regular School No Middle 06 08 2020   grade_6 137 18 10 0   65     0   10   126 114 *                     240.0 137 18 10 0   65     0   10   126 114                 240
1367782 1367782 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Robert H. Adams Middle School   Regular School No Middle 06 08 2020   grade_6 185 4 18 0   14     1   7   114 115 *                     229.0 185 4 18 0   14     1   7   114 115                 229
1370423 1370423 MA Essex   school 2510380 258   Salem 251038002404 2580305 Collins Middle   Regular School No Middle 06 08 2020   grade_6 101 17 96 0   8     0   10   117 115 *                     232.0 101 17 96 0   8     0   10   117 115                 232
1372859 1372859 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2020   grade_6 2 140 105 1   0     3   0   136 115 *                     251.0 2 140 105 1   0     3   0   136 115                 251
1369701 1369701 MA Middlesex   school 2508820 217   North Reading 250882002592 2170305 North Reading Middle   Regular School No Middle 06 08 2020   grade_6 162 1 13 0   14     0   6   80 116 *                     196.0 162 1 13 0   14     0   6   80 116                 196
1370636 1370636 MA Bristol   school 2510860 273   Somerset 251086002537 2730305 Somerset Middle School   Regular School No Middle 06 08 2020   grade_6 197 4 12 1   3     0   5   105 117 *                     222.0 197 4 12 1   3     0   5   105 117                 222
1370218 1370218 MA Norfolk   school 2509930 244   Randolph 250993001392 2440410 Randolph Community Middle   Regular School No Middle 06 08 2020   grade_6 35 118 40 0   39     1   6   121 118 *                     239.0 35 118 40 0   39     1   6   121 118                 239
1370478 1370478 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Belmonte Saugus Middle   Regular School No Middle 06 08 2020   grade_6 157 18 43 1   6     1   7   115 118 *                     233.0 157 18 43 1   6     1   7   115 118                 233
1367710 1367710 MA Essex   school 2505970 128   Haverhill 250597002906 1280105 Tilton Upper Middle School   Regular School No Middle 04 06 2020   grade_6 6 2 19 0   0     0   0   15 12 *                     27.0 6 2 19 0   0     0   0   15 12                 27
1369908 1369908 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham Elementary   Regular School No Elementary KG 06 2020   grade_6 18 1 1 0   1     0   1   10 12 *                     22.0 18 1 1 0   1     0   1   10 12                 22
1371191 1371191 MA Franklin   school 2511370 289   Sunderland 251137001878 2890005 Sunderland Elementary   Regular School No Elementary PK 06 2020   grade_6 24 2 5 0   0     0   3   22 12 *                     34.0 24 2 5 0   0     0   3   22 12                 34
1372138 1372138 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2020   grade_6 10 3 12 0   2     0   1   16 12 *                     28.0 10 3 12 0   2     0   1   16 12                 28
1372531 1372531 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway   Regular School Yes Elementary PK 08 2020   grade_6 0 1 34 0   0     0   0   23 12 *                     35.0 0 1 34 0   0     0   0   23 12                 35
1373405 1373405 MA Franklin   school 2505270 674   Gill-Montague 250527002382 6740005 Gill Elementary   Regular School No Elementary KG 06 2020   grade_6 26 0 0 0   0     0   1   15 12 *                     27.0 26 0 0 0   0     0   1   15 12                 27
1366783 1366783 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No Middle 06 08 2020   grade_6 225 5 27 0   7     0   8   152 120 *                     272.0 225 5 27 0   7     0   8   152 120                 272
1370312 1370312 MA Suffolk   school 2510050 248   Revere 251005002113 2480305 Susan B. Anthony Middle School   Regular School No Middle 06 08 2020   grade_6 62 11 129 0   3     0   2   86 121 *                     207.0 62 11 129 0   3     0   2   86 121                 207
1371296 1371296 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Benjamin Friedman Middle   Regular School No Middle 05 07 2020   grade_6 204 27 16 0   2     0   11   137 123 *                     260.0 204 27 16 0   2     0   11   137 123                 260
1365049 1365049 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No Middle 06 08 2020   grade_6 176 7 17 0   7     0   9   92 124 *                     216.0 176 7 17 0   7     0   9   92 124                 216
1369464 1369464 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Charles E Brown Middle   Regular School No Middle 06 08 2020   grade_6 181 3 11 1   58     0   9   138 125 *                     263.0 181 3 11 1   58     0   9   138 125                 263
1373182 1373182 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002657 6250300 Williams Intermediate School   Regular School No Middle 04 06 2020   grade_6 217 22 7 0   6     0   8   134 126 *                     260.0 217 22 7 0   6     0   8   134 126                 260
1374005 1374005 MA Worcester   school 2511880 775   Wachusett 251188000888 7750305 Mountview Middle   Regular School No Middle 06 08 2020   grade_6 215 12 16 0   8     0   7   132 126 *                     258.0 215 12 16 0   8     0   7   132 126                 258
1371141 1371141 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 O'Donnell Middle School   Regular School No Middle 06 08 2020   grade_6 144 56 40 0   19     0   11   142 128 *                     270.0 144 56 40 0   19     0   11   142 128                 270
1371317 1371317 MA Middlesex   school 2511580 295   Tewksbury 251158001426 2950023 John F. Ryan   Regular School No Middle 05 06 2020   grade_6 234 8 9 1   4     0   3   131 128 *                     259.0 234 8 9 1   4     0   3   131 128                 259
1371421 1371421 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales Elementary   Regular School No Elementary PK 06 2020   grade_6 23 0 0 0   1     0   1   12 13 *                     25.0 23 0 0 0   1     0   1   12 13                 25
1366371 1366371 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Marshall Simonds Middle   Regular School No Middle 06 08 2020   grade_6 179 15 13 0   33     0   4   114 130 *                     244.0 179 15 13 0   33     0   4   114 130                 244
1368995 1368995 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 John T. Nichols Middle   Regular School No Middle 06 08 2020   grade_6 226 5 9 1   1     0   17   129 130 *                     259.0 226 5 9 1   1     0   17   129 130                 259
1366671 1366671 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Dupont Middle   Regular School No Middle 06 08 2020   grade_6 132 17 123 0   4     0   7   152 131 *                     283.0 132 17 123 0   4     0   7   152 131                 283
1366238 1366238 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No Middle 06 08 2020   grade_6 51 110 82 2   10     0   11   134 132 *                     266.0 51 110 82 2   10     0   11   134 132                 266
1366668 1366668 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No Middle 06 08 2020   grade_6 136 10 141 0   5     0   9   169 132 *                     301.0 136 10 141 0   5     0   9   169 132                 301
1367236 1367236 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No Middle 05 06 2020   grade_6 217 9 15 11   4     0   24   148 132 *                     280.0 217 9 15 11   4     0   24   148 132                 280
1367193 1367193 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No Middle 06 08 2020   grade_6 145 18 57 0   13     0   23   122 134 *                     256.0 145 18 57 0   13     0   23   122 134                 256
1368693 1368693 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Harold L Qualters Middle   Regular School No Middle 06 08 2020   grade_6 231 9 20 0   16     0   7   149 134 *                     283.0 231 9 20 0   16     0   7   149 134                 283
1371407 1371407 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Galvin Middle School   Regular School No Middle 05 08 2020   grade_6 224 7 18 0   9     0   6   130 134 *                     264.0 224 7 18 0   9     0   6   130 134                 264
1367001 1367001 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No Middle 06 08 2020   grade_6 223 15 18 0   13     0   8   141 136 *                     277.0 223 15 18 0   13     0   8   141 136                 277
1368202 1368202 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No Middle 06 08 2020   grade_6 148 15 8 1   130     1   12   179 136 *                     315.0 148 15 8 1   130     1   12   179 136                 315
1371990 1371990 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No Middle 06 08 2020   grade_6 251 4 14 0   12     0   9   153 137 *                     290.0 251 4 14 0   12     0   9   153 137                 290
1368784 1368784 MA Plymouth   school 2507350 171   Marshfield 250735001143 1710310 Furnace Brook Middle   Regular School No Middle 06 08 2020   grade_6 266 3 13 0   5     1   3   152 139 *                     291.0 266 3 13 0   5     1   3   152 139                 291
1372243 1372243 MA Worcester   school 2513230 348   Worcester 251323002224 3480136 Heard Street   Regular School No Elementary KG 06 2020   grade_6 18 3 8 0   2     0   2   19 14 *                     33.0 18 3 8 0   2     0   2   19 14                 33
1372265 1372265 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Lincoln Street   Regular School No Elementary KG 06 2020   grade_6 3 3 9 0   2     0   0   3 14 *                     17.0 3 3 9 0   2     0   0   3 14                 17
1373810 1373810 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2020   grade_6 27 0 3 0   0     0   0   16 14 *                     30.0 27 0 3 0   0     0   0   16 14                 30
1367886 1367886 MA Middlesex   school 2506330 139   Hopkinton 250633000468 1390305 Hopkinton Middle School   Regular School No Middle 06 08 2020   grade_6 197 2 15 1   56     0   16   147 140 *                     287.0 197 2 15 1   56     0   16   147 140                 287
1370565 1370565 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon Middle   Regular School No Middle 06 08 2020   grade_6 148 14 17 0   99     0   19   156 141 *                     297.0 148 14 17 0   99     0   19   156 141                 297
1366116 1366116 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 East Middle School   Regular School No Middle 06 08 2020   grade_6 190 20 16 0   53     1   5   143 142 *                     285.0 190 20 16 0   53     1   5   143 142                 285
1369334 1369334 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No Middle 06 08 2020   grade_6 101 43 128 1   0     1   14   146 142 *                     288.0 101 43 128 1   0     1   14   146 142                 288
1371181 1371181 MA Middlesex   school 2511340 288   Sudbury 251134001872 2880305 Ephraim Curtis Middle   Regular School No Middle 06 08 2020   grade_6 222 14 9 0   34     1   16   154 142 *                     296.0 222 14 9 0   34     1   16   154 142                 296
1367385 1367385 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No Middle 06 08 2020   grade_6 148 10 92 0   16     0   10   131 145 *                     276.0 148 10 92 0   16     0   10   131 145                 276

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