Data source: Big Local News · About: Big Local

493 rows where grade = "grade_8", state = "MA" and year = 2019 sorted by female

View and edit SQL

year

  • 2019 · 493

grade

  • grade_8 · 493
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
2041275 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Frederick Douglass Academy   Regular School No Secondary 07 11 2019   grade_8 0 1 3 1   0     0   1   4 *                       6.0 0 1 3 1   0     0   1   4                   6
2042772 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_8 * * * *   *     *   *   2 *                       2.0                         2                   2
2043455 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 02 08 2019   grade_8 * * * *   *     *   *   5 *                       5.0                         5                   5
2045782 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 07 08 2019   grade_8 3 1 4 0   0     0   0   5 *                       8.0 3 1 4 0   0     0   0   5                   8
2041289 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 03 12 2019   grade_8 * * * *   *     *   *   4 1                       5.0                         4 1                 5
2042370 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_8 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2043676 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No High 06 12 2019   grade_8 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2045173 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2019   grade_8 4 1 2 0   0     0   0   6 1                       7.0 4 1 2 0   0     0   0   6 1                 7
2045508 MA Essex   school 2510380 258   Salem 251038002774 2580515 Salem Prep High School   Regular School No High 08 12 2019   grade_8 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2040597 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2019   grade_8 0 0 16 0   0     0   0   6 10                       16.0 0 0 16 0   0     0   0   6 10                 16
2040874 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2019   grade_8 0 16 10 0   0     0   0   16 10                       26.0 0 16 10 0   0     0   0   16 10                 26
2040901 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2019   grade_8 0 22 11 0   0     0   0   23 10                       33.0 0 22 11 0   0     0   0   23 10                 33
2040079 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No Middle 06 08 2019   grade_8 182 4 24 0   7     0   4   121 100                       221.0 182 4 24 0   7     0   4   121 100                 221
2042329 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Middle School   Regular School No Middle 05 08 2019   grade_8 56 15 107 0   13     0   9   100 100                       200.0 56 15 107 0   13     0   9   100 100                 200
2048886 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin Regional Middle School   Regular School No Middle 07 08 2019   grade_8 164 0 6 0   1     0   5   76 100                       176.0 164 0 6 0   1     0   5   76 100                 176
2042052 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 Birchland Park   Regular School No Middle 06 08 2019   grade_8 188 12 19 0   10     0   4   132 101                       233.0 188 12 19 0   10     0   4   132 101                 233
2043659 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Pickering Middle   Regular School No Middle 06 08 2019   grade_8 69 19 81 2   22     0   12   104 101                       205.0 69 19 81 2   22     0   12   104 101                 205
2041125 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 05 08 2019   grade_8 159 1 3 1   5     0   8   75 102                       177.0 159 1 3 1   5     0   8   75 102                 177
2041634 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No Middle 05 08 2019   grade_8 152 6 6 0   29     0   7   98 102                       200.0 152 6 6 0   29     0   7   98 102                 200
2044796 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton Middle   Regular School No Middle 06 08 2019   grade_8 177 3 6 0   3     0   5   92 102                       194.0 177 3 6 0   3     0   5   92 102                 194
2046578 MA Middlesex   school 2512000 308   Waltham 251200001977 3080415 John W. McDevitt Middle School   Regular School No Middle 06 08 2019   grade_8 81 19 93 0   6     0   5   102 102                       204.0 81 19 93 0   6     0   5   102 102                 204
2041039 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No High 07 12 2019   grade_8 22 52 64 0   32     0   4   71 103                       174.0 22 52 64 0   32     0   4   71 103                 174
2044622 MA Hampshire   school 2508850 210   Northampton 250885001430 2100410 John F Kennedy Middle School   Regular School No Middle 06 08 2019   grade_8 150 5 47 1   5     0   12   117 103                       220.0 150 5 47 1   5     0   12   117 103                 220
2045555 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Belmonte Saugus Middle   Regular School No Middle 06 08 2019   grade_8 140 14 42 1   7     1   6   108 103                       211.0 140 14 42 1   7     1   6   108 103                 211
2046079 MA Hampden   school 2511130 281   Springfield 251113002600 2810325 Forest Park Middle   Regular School No Middle 06 08 2019   grade_8 10 34 154 1   21     0   3   120 103                       223.0 10 34 154 1   21     0   3   120 103                 223
2048139 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Overlook Middle School   Regular School No Middle 06 08 2019   grade_8 188 0 7 0   1     0   4   97 103                       200.0 188 0 7 0   1     0   4   97 103                 200
2048529 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002141 6800310 Wilbraham Middle   Regular School No Middle 06 08 2019   grade_8 182 5 11 2   6     0   4   107 103                       210.0 182 5 11 2   6     0   4   107 103                 210
2039945 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No Middle 06 08 2019   grade_8 162 1 6 2   26     0   4   97 104                       201.0 162 1 6 2   26     0   4   97 104                 201
2042003 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No High 07 12 2019   grade_8 181 5 2 1   3     0   3   91 104                       195.0 181 5 2 1   3     0   3   91 104                 195
2042865 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Robert H. Adams Middle School   Regular School No Middle 06 08 2019   grade_8 171 3 18 2   20     0   5   115 104                       219.0 171 3 18 2   20     0   5   115 104                 219
2045248 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No Middle 06 08 2019   grade_8 106 8 7 0   92     0   5   113 105                       218.0 106 8 7 0   92     0   5   113 105                 218
2041912 MA Norfolk   school 2504050 73   Dedham 250405000551 730305 Dedham Middle School   Regular School No Middle 06 08 2019   grade_8 139 16 31 1   6     0   5   92 106                       198.0 139 16 31 1   6     0   5   92 106                 198
2042794 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 04 08 2019   grade_8 97 4 101 0   5     1   2   104 106                       210.0 97 4 101 0   5     1   2   104 106                 210
2045145 MA Plymouth   school 2509720 239   Plymouth 250972001380 2390305 Plymouth South Middle   Regular School No Middle 06 08 2019   grade_8 210 1 9 2   2     0   8   126 106                       232.0 210 1 9 2   2     0   8   126 106                 232
2044777 MA Middlesex   school 2508820 217   North Reading 250882002592 2170305 North Reading Middle   Regular School No Middle 06 08 2019   grade_8 174 0 9 1   7     0   7   91 107                       198.0 174 0 9 1   7     0   7   91 107                 198
2048600 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Miscoe Hill School   Regular School No Middle 05 08 2019   grade_8 184 0 7 0   6     0   3   93 107                       200.0 184 0 7 0   6     0   3   93 107                 200
2042390 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No Middle 05 08 2019   grade_8 171 8 11 2   3     0   5   92 108                       200.0 171 8 11 2   3     0   5   92 108                 200
2042458 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No Middle 06 08 2019   grade_8 138 14 72 0   13     0   5   134 108                       242.0 138 14 72 0   13     0   5   134 108                 242
2041743 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Dupont Middle   Regular School No Middle 06 08 2019   grade_8 116 13 100 0   7     0   8   135 109                       244.0 116 13 100 0   7     0   8   135 109                 244
2040811 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2019   grade_8 6 5 13 0   2     0   1   16 11                       27.0 6 5 13 0   2     0   1   16 11                 27
2040847 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2019   grade_8 2 15 7 0   0     0   1   14 11                       25.0 2 15 7 0   0     0   1   14 11                 25
2046096 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Balliet Middle School   Regular School No Middle 06 08 2019   grade_8 0 3 17 0   0     0   2   11 11                       22.0 0 3 17 0   0     0   2   11 11                 22
2040299 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Marshall Middle School   Regular School No Middle 06 08 2019   grade_8 181 9 10 0   12     1   4   107 110                       217.0 181 9 10 0   12     1   4   107 110                 217
2043519 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Paul R Baird Middle   Regular School No Middle 06 08 2019   grade_8 184 2 16 2   2     0   2   98 110                       208.0 184 2 16 2   2     0   2   98 110                 208
2044232 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Wilson Middle   Regular School No Middle 05 08 2019   grade_8 167 11 14 0   14     0   15   111 110                       221.0 167 11 14 0   14     0   15   111 110                 221
2046666 MA Middlesex   school 2512210 315   Wayland 251221002502 3150305 Wayland Middle School   Regular School No Middle 06 08 2019   grade_8 135 12 9 0   38     0   16   100 110                       210.0 135 12 9 0   38     0   16   100 110                 210
2046862 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Stony Brook School   Regular School No Middle 06 08 2019   grade_8 175 0 1 0   74     0   4   144 110                       254.0 175 0 1 0   74     0   4   144 110                 254
2041988 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury Middle   Regular School No Middle 06 08 2019   grade_8 234 0 6 0   2     0   9   140 111                       251.0 234 0 6 0   2     0   9   140 111                 251
2041304 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No Middle 06 08 2019   grade_8 43 117 37 0   7     0   10   102 112                       214.0 43 117 37 0   7     0   10   102 112                 214
2042994 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson High   Regular School No High 08 12 2019   grade_8 179 4 22 0   2     0   8   103 112                       215.0 179 4 22 0   2     0   8   103 112                 215
2048316 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2019   grade_8 171 23 20 4   5     0   11   122 112                       234.0 171 23 20 4   5     0   11   122 112                 234
2041740 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No Middle 06 08 2019   grade_8 129 10 101 0   2     0   9   138 113                       251.0 129 10 101 0   2     0   9   138 113                 251
2045498 MA Essex   school 2510380 258   Salem 251038002404 2580305 Collins Middle   Regular School No Middle 06 08 2019   grade_8 111 18 88 1   7     0   7   119 113                       232.0 111 18 88 1   7     0   7   119 113                 232
2045522 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich STEM Academy   Regular School No Middle 07 08 2019   grade_8 211 2 2 3   6     0   1   112 113                       225.0 211 2 2 3   6     0   1   112 113                 225
2046085 MA Hampden   school 2511130 281   Springfield 251113002602 2810330 M Marcus Kiley Middle   Regular School No Middle 06 08 2019   grade_8 23 50 162 0   5     0   1   128 113                       241.0 23 50 162 0   5     0   1   128 113                 241
2043907 MA Norfolk   school 2507530 175   Medfield 250753001156 1750305 Thomas Blake Middle   Regular School No Middle 06 08 2019   grade_8 190 3 4 1   11     0   8   103 114                       217.0 190 3 4 1   11     0   8   103 114                 217
2045006 MA Plymouth   school 2509420 231   Pembroke 250942001823 2310305 Pembroke Community Middle School   Regular School No Middle 07 08 2019   grade_8 235 3 1 0   4     0   0   129 114                       243.0 235 3 1 0   4     0   0   129 114                 243
2046483 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Galvin Middle School   Regular School No Middle 05 08 2019   grade_8 213 10 15 0   7     1   5   137 114                       251.0 213 10 15 0   7     1   5   137 114                 251
2048409 MA Plymouth   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville Middle School   Regular School No Middle 06 08 2019   grade_8 238 3 3 0   2     0   2   132 116                       248.0 238 3 3 0   2     0   2   132 116                 248
2045594 MA Plymouth   school 2510560 264   Scituate 251056001690 2640305 Gates Middle School   Regular School No Middle 06 08 2019   grade_8 206 3 3 0   3     0   2   99 118                       217.0 206 3 3 0   3     0   2   99 118                 217
2040784 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2019   grade_8 0 6 18 0   0     0   1   13 12                       25.0 0 6 18 0   0     0   1   13 12                 25
2040794 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No Elementary PK 08 2019   grade_8 6 6 23 0   1     0   0   24 12                       36.0 6 6 23 0   1     0   0   24 12                 36
2040881 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Middle 02 08 2019   grade_8 1 12 10 0   0     0   1   12 12                       24.0 1 12 10 0   0     0   1   12 12                 24
2046412 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No Elementary PK 08 2019   grade_8 19 2 10 0   0     0   1   20 12                       32.0 19 2 10 0   0     0   1   20 12                 32
2047781 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2019   grade_8 27 0 1 0   0     0   2   18 12                       30.0 27 0 1 0   0     0   2   18 12                 30
2041187 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 South Middle School   Regular School No Middle 06 08 2019   grade_8 174 5 9 1   37     0   3   109 120                       229.0 174 5 9 1   37     0   3   109 120                 229
2041310 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No Middle 06 08 2019   grade_8 51 93 72 1   7     0   9   113 120                       233.0 51 93 72 1   7     0   9   113 120                 233
2048249 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002659 6250320 Bridgewater Middle School   Regular School No Middle 07 08 2019   grade_8 224 10 3 1   4     0   7   129 120                       249.0 224 10 3 1   4     0   7   129 120                 249
2049081 MA Worcester   school 2511880 775   Wachusett 251188000888 7750305 Mountview Middle   Regular School No Middle 06 08 2019   grade_8 224 9 10 0   13     0   5   139 122                       261.0 224 9 10 0   13     0   5   139 122                 261
2041184 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 East Middle School   Regular School No Middle 06 08 2019   grade_8 170 24 12 1   36     1   5   125 123                       249.0 170 24 12 1   36     1   5   125 123                 249
2041575 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Wm H Galvin Middle   Regular School No Middle 06 08 2019   grade_8 172 20 8 0   22     1   12   112 123                       235.0 172 20 8 0   22     1   12   112 123                 235
2044539 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Charles E Brown Middle   Regular School No Middle 06 08 2019   grade_8 153 5 14 0   48     0   19   116 123                       239.0 153 5 14 0   48     0   19   116 123                 239
2047066 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No Middle 06 08 2019   grade_8 213 4 11 0   10     0   10   125 123                       248.0 213 4 11 0   10     0   10   125 123                 248
2044542 MA Middlesex   school 2508610 207   Newton 250861000314 2070315 F A Day Middle   Regular School No Middle 06 08 2019   grade_8 198 18 16 2   42     0   25   177 124                       301.0 198 18 16 2   42     0   25   177 124                 301
2048905 MA Plymouth   school 2510830 760   Silver Lake 251083001721 7600405 Silver Lake Regional Middle School   Regular School No Middle 07 08 2019   grade_8 253 3 4 1   2     0   1   140 124                       264.0 253 3 4 1   2     0   1   140 124                 264
2041813 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No Middle 06 08 2019   grade_8 207 13 9 1   12     0   13   129 125                       255.0 207 13 9 1   12     0   13   129 125                 255
2042267 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No Middle 06 08 2019   grade_8 144 23 51 0   7     0   17   117 125                       242.0 144 23 51 0   7     0   17   117 125                 242
2043783 MA Essex   school 2507260 168   Marblehead 250726001789 1680300 Marblehead Veterans Middle School   Regular School No Middle 07 08 2019   grade_8 207 11 12 0   4     0   2   111 125                       236.0 207 11 12 0   4     0   2   111 125                 236
2041443 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Marshall Simonds Middle   Regular School No Middle 06 08 2019   grade_8 192 15 19 0   29     0   12   141 126                       267.0 192 15 19 0   29     0   12   141 126                 267
2044852 MA Norfolk   school 2509060 220   Norwood 250906001468 2200305 Dr. Philip O. Coakley Middle School   Regular School No Middle 06 08 2019   grade_8 167 36 36 0   12     0   7   132 126                       258.0 167 36 36 0   12     0   7   132 126                 258
2049370 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 2019   grade_8 163 16 31 2   8     0   11   105 126                       231.0 163 16 31 2   8     0   11   105 126                 231
2044003 MA Middlesex   school 2507620 178   Melrose 250762002557 1780305 Melrose Middle   Regular School No Middle 06 08 2019   grade_8 204 15 9 0   14     0   11   126 127                       253.0 204 15 9 0   14     0   11   126 127                 253
2044545 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Oak Hill Middle   Regular School No Middle 06 08 2019   grade_8 133 9 13 0   59     0   17   104 127                       231.0 133 9 13 0   59     0   17   104 127                 231
2046397 MA Middlesex   school 2511580 295   Tewksbury 251158000366 2950305 John W. Wynn Middle   Regular School No Middle 07 08 2019   grade_8 244 9 9 1   7     0   4   146 128                       274.0 244 9 9 1   7     0   4   146 128                 274
2041883 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth Middle   Regular School No Middle 06 08 2019   grade_8 275 7 10 0   0     0   20   183 129                       312.0 275 7 10 0   0     0   20   183 129                 312
2041094 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No Elementary PK 08 2019   grade_8 0 0 22 0   0     0   0   9 13                       22.0 0 0 22 0   0     0   0   9 13                 22
2044409 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No Middle 06 08 2019   grade_8 102 38 107 1   0     0   18   136 130                       266.0 102 38 107 1   0     0   18   136 130                 266
2046761 MA Worcester   school 2512600 321   Westborough 251260002604 3210305 Sarah W Gibbons Middle   Regular School No Middle 07 08 2019   grade_8 164 2 18 0   81     0   13   147 131                       278.0 164 2 18 0   81     0   13   147 131                 278
2047933 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2019   grade_8 4 153 91 0   1     1   0   119 131                       250.0 4 153 91 0   1     1   0   119 131                 250
2046218 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 O'Donnell Middle School   Regular School No Middle 06 08 2019   grade_8 136 60 28 1   21     0   13   127 132                       259.0 136 60 28 1   21     0   13   127 132                 259
2046979 MA Norfolk   school 2512810 335   Westwood 251281002097 3350305 E W Thurston Middle   Regular School No Middle 06 08 2019   grade_8 204 11 10 0   19     0   11   121 134                       255.0 204 11 10 0   19     0   11   121 134                 255
2044068 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 John T. Nichols Middle   Regular School No Middle 06 08 2019   grade_8 218 6 10 5   6     0   12   118 139                       257.0 218 6 10 5   6     0   12   118 139                 257
2040471 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No Elementary PK 08 2019   grade_8 12 1 11 0   5     0   1   16 14                       30.0 12 1 11 0   5     0   1   16 14                 30
2042603 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton Middle   Regular School No Middle 07 08 2019   grade_8 214 7 8 0   30     0   6   125 140                       265.0 214 7 8 0   30     0   6   125 140                 265
2041855 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No Middle 06 08 2019   grade_8 238 6 20 0   7     0   9   139 141                       280.0 238 6 20 0   7     0   9   139 141                 280
2041973 MA Middlesex   school 2504320 79   Dracut 250432001625 790410 Justus C. Richardson Middle School   Regular School No Middle 06 08 2019   grade_8 229 14 28 1   22     0   5   157 142                       299.0 229 14 28 1   22     0   5   157 142                 299
2043288 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No Middle 06 08 2019   grade_8 139 12 12 0   138     0   11   170 142                       312.0 139 12 12 0   138     0   11   170 142                 312
2043816 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2019   grade_8 117 13 174 0   8     0   8   178 142                       320.0 117 13 174 0   8     0   8   178 142                 320
2045148 MA Plymouth   school 2509720 239   Plymouth 250972002531 2390405 Plymouth Commun Intermediate   Regular School No Middle 06 08 2019   grade_8 287 10 17 3   8     0   11   193 142                       336.0 287 10 17 3   8     0   11   193 142                 336
2046940 MA Hampden   school 2512510 332   West Springfield 251251001243 3320305 West Springfield Middle   Regular School No Middle 06 08 2019   grade_8 209 12 67 1   27     0   5   179 142                       321.0 209 12 67 1   27     0   5   179 142                 321

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