enrollments

Data source: Big Local News · About: Big Local

500 rows where grade = "grade_7", state = "MA" and year = 2020 sorted by female_int 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
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
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
1369896 1369896 MA Essex   school 2509360 229   Peabody 250936001495 2290305 J Henry Higgins Middle   Regular School No Middle 06 08 2020   grade_7 363 20 79 0   3     0   12   247 230 *                     477.0 363 20 79 0   3     0   12   247 230                 477
1370595 1370595 MA Worcester   school 2510770 271   Shrewsbury 251077001825 2710030 Oak Middle School   Regular School No Middle 07 08 2020   grade_7 242 14 50 1   154     0   19   251 229 *                     480.0 242 14 50 1   154     0   19   251 229                 480
1365980 1365980 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2020   grade_7 187 29 50 0   128     0   23   191 226 *                     417.0 187 29 50 0   128     0   23   191 226                 417
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
1371915 1371915 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Maria Weston Chapman Middle School   Regular School No Middle 06 08 2020   grade_7 310 37 53 1   22     0   18   219 222 *                     441.0 310 37 53 1   22     0   18   219 222                 441
1369621 1369621 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No Middle 06 08 2020   grade_7 329 11 22 0   16     2   16   175 221 *                     396.0 329 11 22 0   16     2   16   175 221                 396
1368584 1368584 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No Middle 06 08 2020   grade_7 39 38 341 0   36     0   6   240 220 *                     460.0 39 38 341 0   36     0   6   240 220                 460
1371657 1371657 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley Middle   Regular School No Middle 06 08 2020   grade_7 258 20 12 0   65     0   27   168 213 *                     382.0 258 20 12 0   65     0   27   168 213                 382
1364974 1364974 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No Middle 07 08 2020   grade_7 321 15 33 1   53     1   31   247 207 *                     455.0 321 15 33 1   53     1   31   247 207                 455
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
1373023 1373023 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Raymond J Grey Junior High   Regular School No Middle 07 08 2020   grade_7 203 13 27 2   151     2   14   208 204 *                     412.0 203 13 27 2   151     2   14   208 204                 412
1369332 1369332 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No Middle 06 08 2020   grade_7 174 44 162 3   2     0   27   212 200 *                     412.0 174 44 162 3   2     0   27   212 200                 412
1371753 1371753 MA Hampden   school 2512630 325   Westfield 251263001570 3250310 Westfield Middle School   Regular School No Middle 07 08 2020   grade_7 286 5 73 0   9     0   10   188 195 *                     383.0 286 5 73 0   9     0   10   188 195                 383
1365095 1365095 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No Middle 06 07 2020   grade_7 274 28 53 0   9     2   15   190 191 *                     381.0 274 28 53 0   9     2   15   190 191                 381
1368745 1368745 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2020   grade_7 157 13 198 0   7     0   9   197 187 *                     384.0 157 13 198 0   7     0   9   197 187                 384
1371182 1371182 MA Middlesex   school 2511340 288   Sudbury 251134001872 2880305 Ephraim Curtis Middle   Regular School No Middle 06 08 2020   grade_7 260 12 18 0   31     1   22   158 186 *                     344.0 260 12 18 0   31     1   22   158 186                 344
1370073 1370073 MA Plymouth   school 2509720 239   Plymouth 250972002531 2390405 Plymouth Commun Intermediate   Regular School No Middle 06 08 2020   grade_7 311 12 26 0   4     1   11   181 184 *                     365.0 311 12 26 0   4     1   11   181 184                 365
1369583 1369583 MA Essex   school 2508700 211   North Andover 250870001398 2110305 North Andover Middle   Regular School No Middle 06 08 2020   grade_7 268 12 42 2   28     0   13   182 183 *                     365.0 268 12 42 2   28     0   13   182 183                 365
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
1368785 1368785 MA Plymouth   school 2507350 171   Marshfield 250735001143 1710310 Furnace Brook Middle   Regular School No Middle 06 08 2020   grade_7 309 2 9 2   3     0   10   158 177 *                     335.0 309 2 9 2   3     0   10   158 177                 335
1365177 1365177 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No Middle 05 08 2020   grade_7 228 13 17 0   74     0   27   184 175 *                     359.0 228 13 17 0   74     0   27   184 175                 359
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
1372048 1372048 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No Middle 06 08 2020   grade_7 238 3 12 1   64     0   31   175 174 *                     349.0 238 3 12 1   64     0   31   175 174                 349
1371686 1371686 MA Worcester   school 2512600 321   Westborough 251260002604 3210305 Sarah W Gibbons Middle   Regular School No Middle 07 08 2020   grade_7 175 2 26 0   118     0   9   157 173 *                     330.0 175 2 26 0   118     0   9   157 173                 330
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
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
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
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
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
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
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
1366903 1366903 MA Middlesex   school 2504320 79   Dracut 250432001625 790410 Justus C. Richardson Middle School   Regular School No Middle 06 08 2020   grade_7 241 22 49 0   20     0   3   175 160 *                     335.0 241 22 49 0   20     0   3   175 160                 335
1367887 1367887 MA Middlesex   school 2506330 139   Hopkinton 250633000468 1390305 Hopkinton Middle School   Regular School No Middle 06 08 2020   grade_7 216 1 15 0   73     0   11   157 159 *                     316.0 216 1 15 0   73     0   11   157 159                 316
1368203 1368203 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No Middle 06 08 2020   grade_7 140 10 16 0   127     0   11   145 159 *                     304.0 140 10 16 0   127     0   11   145 159                 304
1367002 1367002 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No Middle 06 08 2020   grade_7 246 28 17 0   7     0   9   150 157 *                     307.0 246 28 17 0   7     0   9   150 157                 307
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
1373187 1373187 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002659 6250320 Bridgewater Middle School   Regular School No Middle 07 08 2020   grade_7 249 17 6 1   4     1   23   144 157 *                     301.0 249 17 6 1   4     1   23   144 157                 301
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
1369335 1369335 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No Middle 06 08 2020   grade_7 117 48 139 0   0     1   20   170 155 *                     325.0 117 48 139 0   0     1   20   170 155                 325
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
1369329 1369329 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No Middle 06 08 2020   grade_7 120 46 139 1   6     0   26   187 151 *                     338.0 120 46 139 1   6     0   26   187 151                 338
1367194 1367194 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No Middle 06 08 2020   grade_7 148 16 63 0   11     0   22   112 148 *                     260.0 148 16 63 0   11     0   22   112 148                 260
1366917 1366917 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury Middle   Regular School No Middle 06 08 2020   grade_7 241 0 6 1   3     0   7   114 144 *                     258.0 241 0 6 1   3     0   7   114 144                 258
1368143 1368143 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Sky View Middle School   Regular School No Middle 06 08 2020   grade_7 128 25 111 0   9     0   12   141 144 *                     285.0 128 25 111 0   9     0   12   141 144                 285
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
1366372 1366372 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Marshall Simonds Middle   Regular School No Middle 06 08 2020   grade_7 166 17 17 0   58     0   14   129 143 *                     272.0 166 17 17 0   58     0   14   129 143                 272
1371864 1371864 MA Hampden   school 2512510 332   West Springfield 251251001243 3320305 West Springfield Middle   Regular School No Middle 06 08 2020   grade_7 191 14 58 0   29     1   10   164 139 *                     303.0 191 14 58 0   29     1   10   164 139                 303
1373900 1373900 MA Worcester   school 2511490 770   Tantasqua 251149001899 7700405 Tantasqua Regional Jr High   Regular School No Middle 07 08 2020   grade_7 261 3 16 1   1     1   10   154 139 *                     293.0 261 3 16 1   1     1   10   154 139                 293
1366504 1366504 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Wm H Galvin Middle   Regular School No Middle 06 08 2020   grade_7 171 32 8 0   28     0   12   113 138 *                     251.0 171 32 8 0   28     0   12   113 138                 251
1364832 1364832 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam Junior High   Regular School No Middle 07 08 2020   grade_7 231 11 18 0   4     0   6   133 137 *                     270.0 231 11 18 0   4     0   6   133 137                 270
1371991 1371991 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No Middle 06 08 2020   grade_7 227 4 13 0   13     0   5   125 137 *                     262.0 227 4 13 0   13     0   5   125 137                 262
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
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
1366812 1366812 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth Middle   Regular School No Middle 06 08 2020   grade_7 274 3 11 0   2     1   16   173 134 *                     307.0 274 3 11 0   2     1   16   173 134                 307
1369778 1369778 MA Norfolk   school 2509060 220   Norwood 250906001468 2200305 Dr. Philip O. Coakley Middle School   Regular School No Middle 06 08 2020   grade_7 169 28 34 0   17     1   6   121 134 *                     255.0 169 28 34 0   17     1   6   121 134                 255
1371297 1371297 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Benjamin Friedman Middle   Regular School No Middle 05 07 2020   grade_7 191 32 31 1   2     0   13   136 134 *                     270.0 191 32 31 1   2     0   13   136 134                 270
1366226 1366226 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 East Middle School   Regular School No Middle 06 08 2020   grade_7 24 199 33 2   3     0   11   139 133 *                     272.0 24 199 33 2   3     0   11   139 133                 272
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
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
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
1366239 1366239 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No Middle 06 08 2020   grade_7 50 122 77 1   8     0   14   142 130 *                     272.0 50 122 77 1   8     0   14   142 130                 272
1366784 1366784 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No Middle 06 08 2020   grade_7 215 10 27 1   4     0   8   135 130 *                     265.0 215 10 27 1   4     0   8   135 130                 265
1368996 1368996 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 John T. Nichols Middle   Regular School No Middle 06 08 2020   grade_7 233 11 7 3   0     0   7   131 130 *                     261.0 233 11 7 3   0     0   7   131 130                 261
1371504 1371504 MA Middlesex   school 2512000 308   Waltham 251200001977 3080415 John W. McDevitt Middle School   Regular School No Middle 06 08 2020   grade_7 75 22 139 0   13     0   3   122 130 *                     252.0 75 22 139 0   13     0   3   122 130                 252
1371592 1371592 MA Middlesex   school 2512210 315   Wayland 251221002502 3150305 Wayland Middle School   Regular School No Middle 06 08 2020   grade_7 163 14 10 0   43     0   11   112 129 *                     241.0 163 14 10 0   43     0   11   112 129                 241
1373832 1373832 MA Plymouth   school 2510830 760   Silver Lake 251083001721 7600405 Silver Lake Regional Middle School   Regular School No Middle 07 08 2020   grade_7 242 4 10 1   1     0   4   133 129 *                     262.0 242 4 10 1   1     0   4   133 129                 262
1373524 1373524 MA Essex   school 2507410 705   Masconomet 250741001097 7050405 Masconomet Regional Middle School   Regular School No Middle 07 08 2020   grade_7 254 2 4 0   5     0   0   137 128 *                     265.0 254 2 4 0   5     0   0   137 128                 265
1371320 1371320 MA Middlesex   school 2511580 295   Tewksbury 251158000366 2950305 John W. Wynn Middle   Regular School No Middle 07 08 2020   grade_7 220 14 11 0   13     0   1   132 127 *                     259.0 220 14 11 0   13     0   1   132 127                 259
1366117 1366117 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 East Middle School   Regular School No Middle 06 08 2020   grade_7 147 28 18 0   64     0   1   133 125 *                     258.0 147 28 18 0   64     0   1   133 125                 258
1366236 1366236 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No Middle 06 08 2020   grade_7 64 117 25 2   7     2   4   96 125 *                     221.0 64 117 25 2   7     2   4   96 125                 221
1369548 1369548 MA Hampshire   school 2508850 210   Northampton 250885001430 2100410 John F Kennedy Middle School   Regular School No Middle 06 08 2020   grade_7 149 10 35 0   9     0   11   88 125 *                     214.0 149 10 35 0   9     0   11   88 125                 214
1373253 1373253 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No Middle 06 07 2020   grade_7 158 22 36 6   6     0   10   113 125 *                     238.0 158 22 36 6   6     0   10   113 125                 238
1367237 1367237 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No Middle 07 08 2020   grade_7 205 15 14 1   13     0   18   142 124 *                     266.0 205 15 14 1   13     0   18   142 124                 266
1367386 1367386 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No Middle 06 08 2020   grade_7 132 10 69 1   9     0   16   114 123 *                     237.0 132 10 69 1   9     0   16   114 123                 237
1368931 1368931 MA Middlesex   school 2507620 178   Melrose 250762002557 1780305 Melrose Middle   Regular School No Middle 06 08 2020   grade_7 216 16 12 0   15     0   14   150 123 *                     273.0 216 16 12 0   15     0   14   150 123                 273
1366841 1366841 MA Norfolk   school 2504050 73   Dedham 250405000551 730305 Dedham Middle School   Regular School No Middle 06 08 2020   grade_7 173 21 45 1   5     0   13   137 121 *                     258.0 173 21 45 1   5     0   13   137 121                 258
1368694 1368694 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Harold L Qualters Middle   Regular School No Middle 06 08 2020   grade_7 218 12 19 1   13     0   4   146 121 *                     267.0 218 12 19 1   13     0   4   146 121                 267
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
1367530 1367530 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton Middle   Regular School No Middle 07 08 2020   grade_7 214 3 17 0   26     0   10   150 120 *                     270.0 214 3 17 0   26     0   10   150 120                 270
1370313 1370313 MA Suffolk   school 2510050 248   Revere 251005002113 2480305 Susan B. Anthony Middle School   Regular School No Middle 06 08 2020   grade_7 62 5 137 0   5     0   2   92 119 *                     211.0 62 5 137 0   5     0   2   92 119                 211
1371003 1371003 MA Hampden   school 2511130 281   Springfield 251113002600 2810325 Forest Park Middle   Regular School No Middle 06 08 2020   grade_7 31 44 153 0   13     0   5   127 119 *                     246.0 31 44 153 0   13     0   5   127 119                 246
1367191 1367191 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No Middle 06 08 2020   grade_7 127 19 46 1   6     1   16   99 117 *                     216.0 127 19 46 1   6     1   16   99 117                 216
1374061 1374061 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman Middle   Regular School No Middle 06 08 2020   grade_7 162 16 16 0   3     0   8   88 117 *                     205.0 162 16 16 0   3     0   8   88 117                 205
1366672 1366672 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Dupont Middle   Regular School No Middle 06 08 2020   grade_7 119 10 124 1   9     0   8   155 116 *                     271.0 119 10 124 1   9     0   8   155 116                 271
1367507 1367507 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No Middle 06 08 2020   grade_7 173 2 21 3   1     0   2   86 116 *                     202.0 173 2 21 3   1     0   2   86 116                 202
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
1372860 1372860 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2020   grade_7 0 134 98 0   1     0   1   119 115 *                     234.0 0 134 98 0   1     0   1   119 115                 234
1366742 1366742 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No Middle 06 08 2020   grade_7 176 11 11 1   26     0   11   123 113 *                     236.0 176 11 11 1   26     0   11   123 113                 236
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
1367380 1367380 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No Middle 06 08 2020   grade_7 144 14 35 0   8     0   4   93 112 *                     205.0 144 14 35 0   8     0   4   93 112                 205
1370070 1370070 MA Plymouth   school 2509720 239   Plymouth 250972001380 2390305 Plymouth South Middle   Regular School No Middle 06 08 2020   grade_7 212 3 8 0   2     0   5   118 112 *                     230.0 212 3 8 0   2     0   5   118 112                 230
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
1371286 1371286 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Joseph H Martin   Regular School No Middle 05 07 2020   grade_7 153 44 27 1   2     1   7   123 112 *                     235.0 153 44 27 1   2     1   7   123 112                 235
1368590 1368590 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Pickering Middle   Regular School No Middle 06 08 2020   grade_7 65 24 107 1   22     0   14   122 111 *                     233.0 65 24 107 1   22     0   14   122 111                 233
1366233 1366233 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No Middle 06 08 2020   grade_7 53 154 23 2   8     0   7   137 110 *                     247.0 53 154 23 2   8     0   7   137 110                 247
1367783 1367783 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Robert H. Adams Middle School   Regular School No Middle 06 08 2020   grade_7 199 0 15 0   14     0   7   125 110 *                     235.0 199 0 15 0   14     0   7   125 110                 235
1370447 1370447 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich STEM Academy   Regular School No Middle 07 08 2020   grade_7 205 4 3 1   3     0   3   109 110 *                     219.0 205 4 3 1   3     0   3   109 110                 219
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

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