enrollments

Data source: Big Local News · About: Big Local

499 rows where grade = "grade_7", state = "MA" and year = 2019 sorted by black

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 399 ✖

grade ✖

  • grade_7 · 399 ✖
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
2039858 2039858 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam Junior High   Regular School No Middle 07 08 2019   grade_7 241 10 18 0   13     0   9   165 126                       291.0 241 10 18 0   13     0   9   165 126                 291
2040001 2040001 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No Middle 07 08 2019   grade_7 329 10 29 0   52     2   19   205 236                       441.0 329 10 29 0   52     2   19   205 236                 441
2041661 2041661 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2019   grade_7 9 10 116 0   0     0   0   73 62                       135.0 9 10 116 0   0     0   0   73 62                 135
2042124 2042124 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No Elementary KG 08 2019   grade_7 41 10 50 2   7     1   2   57 56                       113.0 41 10 50 2   7     1   2   57 56                 113
2042793 2042793 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 04 08 2019   grade_7 109 10 95 1   3     0   1   124 95                       219.0 109 10 95 1   3     0   1   124 95                 219
2043782 2043782 MA Essex   school 2507260 168   Marblehead 250726001789 1680300 Marblehead Veterans Middle School   Regular School No Middle 07 08 2019   grade_7 189 10 20 2   2     0   7   117 113                       230.0 189 10 20 2   2     0   7   117 113                 230
2044694 2044694 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No Middle 06 08 2019   grade_7 302 10 18 0   19     0   15   175 189                       364.0 302 10 18 0   19     0   15   175 189                 364
2045554 2045554 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Belmonte Saugus Middle   Regular School No Middle 06 08 2019   grade_7 130 10 54 1   12     0   1   106 102                       208.0 130 10 54 1   12     0   1   106 102                 208
2046482 2046482 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Galvin Middle School   Regular School No Middle 05 08 2019   grade_7 204 10 21 2   8     1   7   127 126                       253.0 204 10 21 2   8     1   7   127 126                 253
2046939 2046939 MA Hampden   school 2512510 332   West Springfield 251251001243 3320305 West Springfield Middle   Regular School No Middle 06 08 2019   grade_7 199 10 57 0   20     0   7   145 148                       293.0 199 10 57 0   20     0   7   145 148                 293
2048095 2048095 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Raymond J Grey Junior High   Regular School No Middle 07 08 2019   grade_7 231 10 25 2   149     0   18   239 196                       435.0 231 10 25 2   149     0   18   239 196                 435
2049331 2049331 MA Hampden   school 2500586 3514   Libertas Academy Charter School (District) 250058602878 35140305 Libertas Academy Charter School   Regular School Yes Middle 06 07 2019   grade_7 2 10 77 0   0     0   2   55 36                       91.0 2 10 77 0   0     0   2   55 36                 91
2049326 2049326 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Middle 06 10 2019   grade_7 3 101 9 1   0     0   0   62 52                       114.0 3 101 9 1   0     0   0   62 52                 114
2040678 2040678 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No Elementary PK 08 2019   grade_7 4 11 29 0   21     0   4   35 34                       69.0 4 11 29 0   21     0   4   35 34                 69
2040721 2040721 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No Elementary PK 08 2019   grade_7 4 11 18 0   0     0   2   22 13                       35.0 4 11 18 0   0     0   2   22 13                 35
2041186 2041186 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 South Middle School   Regular School No Middle 06 08 2019   grade_7 165 11 11 0   36     0   0   104 119                       223.0 165 11 11 0   36     0   0   104 119                 223
2041442 2041442 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Marshall Simonds Middle   Regular School No Middle 06 08 2019   grade_7 180 11 15 1   40     0   4   121 130                       251.0 180 11 15 1   40     0   4   121 130                 251
2041633 2041633 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No Middle 05 08 2019   grade_7 165 11 12 0   32     1   5   117 109                       226.0 165 11 12 0   32     1   5   117 109                 226
2041812 2041812 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No Middle 06 08 2019   grade_7 173 11 16 1   16     0   17   111 123                       234.0 173 11 16 1   16     0   17   111 123                 234
2041911 2041911 MA Norfolk   school 2504050 73   Dedham 250405000551 730305 Dedham Middle School   Regular School No Middle 06 08 2019   grade_7 142 11 26 0   9     0   6   110 84                       194.0 142 11 26 0   9     0   6   110 84                 194
2043726 2043726 MA Middlesex   school 2507170 165   Malden 250717001351 1650027 Forestdale   Regular School No Elementary KG 08 2019   grade_7 25 11 15 0   6     0   3   39 21                       60.0 25 11 15 0   6     0   3   39 21                 60
2045244 2045244 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Broad Meadows Middle   Regular School No Middle 06 08 2019   grade_7 84 11 14 2   19     0   6   81 55                       136.0 84 11 14 2   19     0   6   81 55                 136
2045354 2045354 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Rumney Marsh Academy   Regular School No Middle 06 08 2019   grade_7 56 11 115 1   10     0   5   103 95                       198.0 56 11 115 1   10     0   5   103 95                 198
2046090 2046090 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 STEM Middle Academy   Regular School No Middle 06 08 2019   grade_7 13 11 68 0   4     0   2   54 44                       98.0 13 11 68 0   4     0   2   54 44                 98
2046098 2046098 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Academy   Regular School No Middle 06 08 2019   grade_7 3 11 85 0   0     0   2   52 49                       101.0 3 11 85 0   0     0   2   52 49                 101
2046114 2046114 MA Hampden   school 2511130 281   Springfield 251113002859 2810480 Rise Academy at Van Sickle   Regular School No Middle 06 08 2019   grade_7 11 11 69 0   0     0   1   48 44                       92.0 11 11 69 0   0     0   1   48 44                 92
2045293 2045293 MA Norfolk   school 2509930 244   Randolph 250993001392 2440410 Randolph Community Middle   Regular School No Middle 06 08 2019   grade_7 28 111 25 0   28     0   9   115 86                       201.0 28 111 25 0   28     0   9   115 86                 201
2041295 2041295 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 East Middle School   Regular School No Middle 06 08 2019   grade_7 31 113 19 0   2     0   4   88 81                       169.0 31 113 19 0   2     0   4   88 81                 169
2040846 2040846 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2019   grade_7 0 12 11 0   0     0   4   13 14                       27.0 0 12 11 0   0     0   4   13 14                 27
2040863 2040863 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No Elementary PK 08 2019   grade_7 11 12 38 0   4     0   1   39 27                       66.0 11 12 38 0   4     0   1   39 27                 66
2041742 2041742 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Dupont Middle   Regular School No Middle 06 08 2019   grade_7 123 12 94 0   5     0   10   137 107                       244.0 123 12 94 0   5     0   10   137 107                 244
2042338 2042338 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No Middle 05 08 2019   grade_7 35 12 92 0   7     0   10   87 69                       156.0 35 12 92 0   7     0   10   87 69                 156
2042744 2042744 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Caleb Dustin Hunking School   Regular School No Elementary KG 08 2019   grade_7 147 12 35 0   3     1   3   106 95                       201.0 147 12 35 0   3     1   3   106 95                 201
2044269 2044269 MA Norfolk   school 2508370 199   Needham 250837001308 1990405 Pollard Middle   Regular School No Middle 07 08 2019   grade_7 332 12 33 0   39     0   23   210 229                       439.0 332 12 33 0   39     0   23   210 229                 439
2045641 2045641 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon Middle   Regular School No Middle 06 08 2019   grade_7 170 12 14 1   82     0   12   160 131                       291.0 170 12 14 1   82     0   12   160 131                 291
2045960 2045960 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2019   grade_7 6 12 16 0   0     0   1   15 20                       35.0 6 12 16 0   0     0   1   15 20                 35
2047451 2047451 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No High 07 12 2019   grade_7 5 12 78 0   9     0   4   57 51                       108.0 5 12 78 0   9     0   4   57 51                 108
2048014 2048014 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science   Regular School Yes Other KG 12 2019   grade_7 28 12 14 3   2     0   0   29 30                       59.0 28 12 14 3   2     0   0   29 30                 59
2048022 2048022 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes High 05 12 2019   grade_7 35 12 40 1   0     0   2   45 45                       90.0 35 12 40 1   0     0   2   45 45                 90
2041303 2041303 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No Middle 06 08 2019   grade_7 46 127 35 1   6     1   5   113 108                       221.0 46 127 35 1   6     1   5   113 108                 221
2040135 2040135 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 John Glenn Middle   Regular School No Middle 06 08 2019   grade_7 114 13 10 0   27     0   14   98 80                       178.0 114 13 10 0   27     0   14   98 80                 178
2040443 2040443 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2019   grade_7 2 13 10 0   0     0   3   13 15                       28.0 2 13 10 0   0     0   3   13 15                 28
2040534 2040534 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No Elementary KG 08 2019   grade_7 1 13 36 0   1     0   1   24 28                       52.0 1 13 36 0   1     0   1   24 28                 52
2042451 2042451 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No Middle 06 08 2019   grade_7 121 13 36 0   7     0   9   101 85                       186.0 121 13 36 0   7     0   9   101 85                 186
2043468 2043468 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 B.F. Butler Middle School   Regular School No Middle 05 08 2019   grade_7 44 13 51 0   33     0   6   65 82                       147.0 44 13 51 0   33     0   6   65 82                 147
2043760 2043760 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Harold L Qualters Middle   Regular School No Middle 06 08 2019   grade_7 236 13 12 0   29     0   9   150 149                       299.0 236 13 12 0   29     0   9   150 149                 299
2044656 2044656 MA Essex   school 2508700 211   North Andover 250870001398 2110305 North Andover Middle   Regular School No Middle 06 08 2019   grade_7 284 13 35 2   26     0   6   182 184                       366.0 284 13 35 2   26     0   6   182 184                 366
2045432 2045432 MA Plymouth   school 2510170 251   Rockland 251017001642 2510305 John W Rogers Middle   Regular School No Middle 05 08 2019   grade_7 117 13 26 0   3     0   4   72 91                       163.0 117 13 26 0   3     0   4   72 91                 163
2045779 2045779 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Winter Hill Community   Regular School No Elementary PK 08 2019   grade_7 12 13 31 0   5     0   1   34 28                       62.0 12 13 31 0   5     0   1   34 28                 62
2046607 2046607 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No Middle 05 07 2019   grade_7 110 13 22 1   2     1   18   90 77                       167.0 110 13 22 1   2     1   18   90 77                 167
2046730 2046730 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley Middle   Regular School No Middle 06 08 2019   grade_7 272 13 32 1   46     0   15   184 195                       379.0 272 13 32 1   46     0   15   184 195                 379
2048626 2048626 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No Middle 05 07 2019   grade_7 98 13 13 1   1     1   7   70 64                       134.0 98 13 13 1   1     1   7   70 64                 134
2049310 2049310 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Middle 06 10 2019   grade_7 69 13 16 0   2     0   6   62 44                       106.0 69 13 16 0   2     0   6   62 44                 106
2041300 2041300 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No Middle 06 08 2019   grade_7 29 130 37 0   3     0   6   107 98                       205.0 29 130 37 0   3     0   6   107 98                 205
2047932 2047932 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2019   grade_7 1 134 95 1   4     1   2   134 104                       238.0 1 134 95 1   4     1   2   134 104                 238
2040203 2040203 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No Middle 05 08 2019   grade_7 245 14 24 1   52     0   24   174 186                       360.0 245 14 24 1   52     0   24   174 186                 360
2042263 2042263 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No Middle 06 08 2019   grade_7 106 14 49 0   10     0   16   111 84                       195.0 106 14 49 0   10     0   16   111 84                 195
2043224 2043224 MA Worcester   school 2506780 153   Leominster 250678000742 1530045 Samoset School   Regular School No Middle 06 08 2019   grade_7 85 14 71 0   4     0   3   93 84                       177.0 85 14 71 0   4     0   3   93 84                 177
2043287 2043287 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No Middle 06 08 2019   grade_7 123 14 16 0   120     0   23   144 152                       296.0 123 14 16 0   120     0   23   144 152                 296
2043487 2043487 MA Middlesex   school 2507020 160   Lowell 250702000086 1600345 Dr An Wang School   Regular School No Middle 05 08 2019   grade_7 64 14 72 0   32     0   7   84 105                       189.0 64 14 72 0   32     0   7   84 105                 189
2046258 2046258 MA Middlesex   school 2511340 288   Sudbury 251134001872 2880305 Ephraim Curtis Middle   Regular School No Middle 06 08 2019   grade_7 240 14 9 0   23     0   24   150 160                       310.0 240 14 9 0   23     0   24   150 160                 310
2046665 2046665 MA Middlesex   school 2512210 315   Wayland 251221002502 3150305 Wayland Middle School   Regular School No Middle 06 08 2019   grade_7 148 14 7 1   34     0   13   110 107                       217.0 148 14 7 1   34     0   13   110 107                 217
2047190 2047190 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Daniel L Joyce Middle School   Regular School No Middle 06 08 2019   grade_7 130 14 21 0   8     1   2   88 88                       176.0 130 14 21 0   8     1   2   88 88                 176
2041972 2041972 MA Middlesex   school 2504320 79   Dracut 250432001625 790410 Justus C. Richardson Middle School   Regular School No Middle 06 08 2019   grade_7 211 15 26 1   26     0   3   131 151                       282.0 211 15 26 1   26     0   3   131 151                 282
2042260 2042260 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No Middle 06 08 2019   grade_7 69 15 71 0   8     0   18   106 75                       181.0 69 15 71 0   8     0   18   106 75                 181
2043717 2043717 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2019   grade_7 20 15 38 0   16     0   8   48 49                       97.0 20 15 38 0   16     0   8   48 49                 97
2043941 2043941 MA Middlesex   school 2507560 176   Medford 250756001638 1760315 Madeleine Dugger Andrews   Regular School No Middle 06 08 2019   grade_7 124 15 10 0   9     0   8   89 77                       166.0 124 15 10 0   9     0   8   89 77                 166
2044541 2044541 MA Middlesex   school 2508610 207   Newton 250861000314 2070315 F A Day Middle   Regular School No Middle 06 08 2019   grade_7 227 15 42 0   49     0   17   185 165                       350.0 227 15 42 0   49     0   17   185 165                 350
2047679 2047679 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2019   grade_7 0 15 3 0   0     0   0   8 10                       18.0 0 15 3 0   0     0   0   8 10                 18
2047693 2047693 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2019   grade_7 0 15 11 0   0     0   0   8 18                       26.0 0 15 11 0   0     0   0   8 18                 26
2041538 2041538 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge Street Upper School   Regular School No Middle 06 08 2019   grade_7 30 16 14 0   1     0   8   40 29                       69.0 30 16 14 0   1     0   8   40 29                 69
2043290 2043290 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No Middle 06 08 2019   grade_7 123 16 13 0   100     0   26   130 148                       278.0 123 16 13 0   100     0   26   130 148                 278
2043483 2043483 MA Middlesex   school 2507020 160   Lowell 250702000073 1600340 James Sullivan Middle School   Regular School No Middle 06 08 2019   grade_7 54 16 71 0   26     0   5   96 76                       172.0 54 16 71 0   26     0   5   96 76                 172
2047577 2047577 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 07 2019   grade_7 0 16 7 0   0     0   1   12 12                       24.0 0 16 7 0   0     0   1   12 12                 24
2049369 2049369 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_7 111 16 27 0   5     0   22   89 92                       181.0 111 16 27 0   5     0   22   89 92                 181
2040094 2040094 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2019   grade_7 29 17 4 1   3     0   3   32 25                       57.0 29 17 4 1   3     0   3   32 25                 57
2042389 2042389 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No Middle 05 08 2019   grade_7 172 17 14 0   5     1   5   109 104                       214.0 172 17 14 0   5     1   5   109 104                 214
2043480 2043480 MA Middlesex   school 2507020 160   Lowell 250702001034 1600330 Henry J Robinson Middle   Regular School No Middle 05 08 2019   grade_7 37 17 78 0   27     0   7   77 89                       166.0 37 17 78 0   27     0   7   77 89                 166
2043735 2043735 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No Elementary KG 08 2019   grade_7 42 17 13 1   19     0   4   51 44                       96.0 42 17 13 1   19     0   4   51 44                 96
2044191 2044191 MA Nantucket   school 2508250 197   Nantucket 250825001281 1970010 Cyrus Peirce   Regular School No Middle 06 08 2019   grade_7 65 17 35 0   3     0   2   58 64                       122.0 65 17 35 0   3     0   2   58 64                 122
2046101 2046101 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Impact Prep at Chestnut   Regular School No Middle 06 08 2019   grade_7 7 17 92 0   0     0   0   55 61                       116.0 7 17 92 0   0     0   0   55 61                 116
2048248 2048248 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002659 6250320 Bridgewater Middle School   Regular School No Middle 07 08 2019   grade_7 211 17 0 0   3     0   15   141 105                       246.0 211 17 0 0   3     0   15   141 105                 246
2048315 2048315 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No Middle 06 07 2019   grade_7 138 17 35 5   5     0   15   101 114                       215.0 138 17 35 5   5     0   15   101 114                 215
2040358 2040358 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No Elementary PK 08 2019   grade_7 3 18 19 0   2     0   3   30 15                       45.0 3 18 19 0   2     0   3   30 15                 45
2040935 2040935 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No Middle 06 08 2019   grade_7 7 18 67 0   13     0   3   64 44                       108.0 7 18 67 0   13     0   3   64 44                 108
2042158 2042158 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2019   grade_7 12 18 80 0   3     0   0   53 60                       113.0 12 18 80 0   3     0   0   53 60                 113
2042307 2042307 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No Middle 07 08 2019   grade_7 212 18 17 2   3     0   14   131 135                       266.0 212 18 17 2   3     0   14   131 135                 266
2042841 2042841 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Middle High School   Regular School No High 06 12 2019   grade_7 64 18 15 0   5     0   8   62 48                       110.0 64 18 15 0   5     0   8   62 48                 110
2043708 2043708 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2019   grade_7 25 18 15 0   41     1   1   57 44                       101.0 25 18 15 0   41     1   1   57 44                 101
2044969 2044969 MA Essex   school 2509360 229   Peabody 250936001495 2290305 J Henry Higgins Middle   Regular School No Middle 06 08 2019   grade_7 371 18 67 0   8     0   7   240 231                       471.0 371 18 67 0   8     0   7   240 231                 471
2045497 2045497 MA Essex   school 2510380 258   Salem 251038002404 2580305 Collins Middle   Regular School No Middle 06 08 2019   grade_7 95 18 94 0   8     0   10   117 108                       225.0 95 18 94 0   8     0   10   117 108                 225
2049295 2049295 MA Essex   school 2500546 3506   Pioneer Charter School of Science II (PCSS-II) (District) 250054602780 35060505 Pioneer Charter School of Science II (PCSS-II)   Regular School Yes High 07 12 2019   grade_7 19 18 16 0   6     0   2   35 26                       61.0 19 18 16 0   6     0   2   35 26                 61
2042454 2042454 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Fuller Middle   Regular School No Middle 06 08 2019   grade_7 113 19 74 0   4     1   5   114 102                       216.0 113 19 74 0   4     1   5   114 102                 216
2046574 2046574 MA Middlesex   school 2512000 308   Waltham 251200001971 3080404 John F Kennedy Middle   Regular School No Middle 06 08 2019   grade_7 101 19 47 0   6     0   2   87 88                       175.0 101 19 47 0   6     0   2   87 88                 175
2049266 2049266 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes High 06 12 2019   grade_7 6 19 53 0   1     1   2   40 42                       82.0 6 19 53 0   1     1   2   40 42                 82
2039818 2039818 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2019   grade_7 170 2 12 0   3     0   0   104 83                       187.0 170 2 12 0   3     0   0   104 83                 187
2039833 2039833 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2019   grade_7 117 2 1 0   0     0   1   64 57                       121.0 117 2 1 0   0     0   1   64 57                 121
2040078 2040078 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No Middle 06 08 2019   grade_7 171 2 17 0   9     0   7   113 93                       206.0 171 2 17 0   9     0   7   113 93                 206
2040453 2040453 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2019   grade_7 8 2 90 0   0     0   1   50 51                       101.0 8 2 90 0   0     0   1   50 51                 101
2040623 2040623 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2019   grade_7 6 2 6 0   0     0   0   7 7                       14.0 6 2 6 0   0     0   0   7 7                 14

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