enrollments

Data source: Big Local News · About: Big Local

500 rows where grade = "grade_7", state = "MA" and year = 2020 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 400 ✖

grade ✖

  • grade_7 · 400 ✖
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
1372696 1372696 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes High 05 12 2020   grade_7 49 34 10 1   0     0   3   51 46 *                     97.0 49 34 10 1   0     0   3   51 46                 97
1372692 1372692 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2020   grade_7 35 2 0 0   15     0   0   22 30 *                     52.0 35 2 0 0   15     0   0   22 30                 52
1372679 1372679 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2020   grade_7 33 86 4 0   15     0   10   69 79 *                     148.0 33 86 4 0   15     0   10   69 79                 148
1372666 1372666 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2020   grade_7 21 61 32 0   1     0   0   56 59 *                     115.0 21 61 32 0   1     0   0   56 59                 115
1372654 1372654 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes Other PK 11 2020   grade_7 7 39 21 1   1     0   1   42 28 *                     70.0 7 39 21 1   1     0   1   42 28                 70
1372640 1372640 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2020   grade_7 23 32 60 0   7     0   9   66 65 *                     131.0 23 32 60 0   7     0   9   66 65                 131
1372631 1372631 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2020   grade_7 3 1 37 0   0     0   0   23 18 *                     41.0 3 1 37 0   0     0   0   23 18                 41
1372621 1372621 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2020   grade_7 0 18 14 0   0     0   1   16 17 *                     33.0 0 18 14 0   0     0   1   16 17                 33
1372607 1372607 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2020   grade_7 0 18 1 0   0     0   0   9 10 *                     19.0 0 18 1 0   0     0   0   9 10                 19
1372589 1372589 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge   Regular School Yes High 06 12 2020   grade_7 3 50 6 0   3     1   3   36 30 *                     66.0 3 50 6 0   3     1   3   36 30                 66
1372582 1372582 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes High 05 12 2020   grade_7 75 4 7 0   14     0   1   54 47 *                     101.0 75 4 7 0   14     0   1   54 47                 101
1372578 1372578 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2020   grade_7 71 1 3 1   3     0   2   36 45 *                     81.0 71 1 3 1   3     0   2   36 45                 81
1372575 1372575 MA Essex   school 2500535 431   Community Day Charter Public School - R. Kingman Webster (District) 250053502719 4310205 Community Day Charter Public School - R. Kingman Webster   Regular School Yes Elementary PK 08 2020   grade_7 1 0 34 0   1     0   0   16 20 *                     36.0 1 0 34 0   1     0   0   16 20                 36
1372561 1372561 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2020   grade_7 87 2 7 1   19     0   9   66 59 *                     125.0 87 2 7 1   19     0   9   66 59                 125
1372554 1372554 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2020   grade_7 9 19 84 0   8     0   4   66 58 *                     124.0 9 19 84 0   8     0   4   66 58                 124
1372541 1372541 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_7 8 82 81 1   2     0   8   93 89 *                     182.0 8 82 81 1   2     0   8   93 89                 182
1372532 1372532 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_7 0 0 38 0   0     0   0   20 18 *                     38.0 0 0 38 0   0     0   0   20 18                 38
1372510 1372510 MA Suffolk   school 2500077 419   Helen Y. Davis Leadership Academy Charter Public (District) 250007702091 4190305 Helen Y. Davis Leadership Academy Charter Public School   Regular School Yes Middle 06 08 2020   grade_7 0 64 16 0   0     0   0   42 38 *                     80.0 0 64 16 0   0     0   0   42 38                 80
1372507 1372507 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public School   Regular School Yes Middle 06 08 2020   grade_7 64 11 37 1   15     0   8   70 65 *                     136.0 64 11 37 1   15     0   8   70 65                 136
1372504 1372504 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 08 2020   grade_7 0 13 6 0   0     0   4   12 11 *                     23.0 0 13 6 0   0     0   4   12 11                 23
1372490 1372490 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes High 06 12 2020   grade_7 2 65 24 0   1     0   5   52 45 *                     97.0 2 65 24 0   1     0   5   52 45                 97
1372483 1372483 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes High 06 12 2020   grade_7 42 8 7 1   2     0   4   37 27 *                     64.0 42 8 7 1   2     0   4   37 27                 64
1372476 1372476 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public School   Regular School Yes High 07 12 2020   grade_7 35 0 1 0   0     0   2   16 22 *                     38.0 35 0 1 0   0     0   2   16 22                 38
1372470 1372470 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2020   grade_7 8 43 22 0   0     0   1   37 37 *                     74.0 8 43 22 0   0     0   1   37 37                 74
1372461 1372461 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School   Regular School Yes High 06 12 2020   grade_7 6 26 27 0   0     0   3   33 29 *                     62.0 6 26 27 0   0     0   3   33 29                 62
1372454 1372454 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes High 05 12 2020   grade_7 24 8 140 0   0     1   1   88 86 *                     174.0 24 8 140 0   0     1   1   88 86                 174
1372450 1372450 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 08 2020   grade_7 8 10 31 0   0     0   0   20 29 *                     49.0 8 10 31 0   0     0   0   20 29                 49
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
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
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
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
1372378 1372378 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No High 07 12 2020   grade_7 8 12 74 1   10     0   4   54 55 *                     109.0 8 12 74 1   10     0   4   54 55                 109
1372372 1372372 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 University Pk Campus School   Regular School No High 07 12 2020   grade_7 8 5 20 1   6     0   5   21 24 *                     45.0 8 5 20 1   6     0   5   21 24                 45
1372117 1372117 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Daniel L Joyce Middle School   Regular School No Middle 06 08 2020   grade_7 142 18 28 0   9     0   8   102 103 *                     205.0 142 18 28 0   9     0   8   102 103                 205
1372114 1372114 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No Middle 06 08 2020   grade_7 123 13 17 0   13     0   4   78 92 *                     170.0 123 13 17 0   13     0   4   78 92                 170
1372062 1372062 MA Suffolk   school 2513170 346   Winthrop 251317002179 3460305 Winthrop Middle School   Regular School No Middle 06 08 2020   grade_7 124 3 26 0   1     0   1   69 86 *                     155.0 124 3 26 0   1     0   1   69 86                 155
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
1372005 1372005 MA Worcester   school 2513080 343   Winchendon 251308002796 3430315 Murdock Middle School   Regular School No Middle 06 08 2020   grade_7 83 3 6 0   5     1   3   51 50 *                     101.0 83 3 6 0   5     1   3   51 50                 101
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
1371954 1371954 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No Middle 05 08 2020   grade_7 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
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
1371903 1371903 MA Norfolk   school 2512810 335   Westwood 251281002097 3350305 E W Thurston Middle   Regular School No Middle 06 08 2020   grade_7 181 5 9 0   28     0   5   131 97 *                     228.0 181 5 9 0   28     0   5   131 97                 228
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
1371829 1371829 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport Junior/Senior High School   Regular School No High 07 12 2020   grade_7 108 1 5 0   1     0   8   77 46 *                     123.0 108 1 5 0   1     0   8   77 46                 123
1371815 1371815 MA Middlesex   school 2512750 330   Weston 251275000793 3300305 Weston Middle   Regular School No Middle 06 08 2020   grade_7 110 16 13 0   28     0   13   100 80 *                     180.0 110 16 13 0   28     0   13   100 80                 180
1371788 1371788 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Stony Brook School   Regular School No Middle 06 08 2020   grade_7 141 2 6 0   46     0   7   107 95 *                     202.0 141 2 6 0   46     0   7   107 95                 202
1371785 1371785 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No Middle 06 08 2020   grade_7 107 6 5 2   54     0   10   100 84 *                     184.0 107 6 5 2   54     0   10   100 84                 184
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
1371714 1371714 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No High 07 12 2020   grade_7 91 6 5 0   1     0   4   47 60 *                     107.0 91 6 5 0   1     0   4   47 60                 107
1371700 1371700 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston Junior/Senior High   Regular School No High 06 12 2020   grade_7 57 1 12 0   1     0   5   30 46 *                     76.0 57 1 12 0   1     0   5   30 46                 76
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
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
1371606 1371606 MA Worcester   school 2512240 316   Webster 251224002849 3160315 Webster Middle School   Regular School No Middle 05 08 2020   grade_7 84 4 52 0   5     1   15   79 82 *                     161.0 84 4 52 0   5     1   15   79 82                 161
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
1371566 1371566 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown Middle   Regular School No Middle 06 08 2020   grade_7 148 9 19 2   19     0   8   114 91 *                     205.0 148 9 19 2   19     0   8   114 91                 205
1371533 1371533 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No Middle 05 07 2020   grade_7 123 10 7 2   1     0   14   84 73 *                     157.0 123 10 7 2   1     0   14   84 73                 157
1371518 1371518 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware Junior/Senior High School   Regular School No High 07 12 2020   grade_7 100 3 6 0   0     0   4   56 57 *                     113.0 100 3 6 0   0     0   4   56 57                 113
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
1371501 1371501 MA Middlesex   school 2512000 308   Waltham 251200001971 3080404 John F Kennedy Middle   Regular School No Middle 06 08 2020   grade_7 92 16 47 0   9     0   4   97 71 *                     168.0 92 16 47 0   9     0   4   97 71                 168
1371451 1371451 MA Norfolk   school 2511970 307   Walpole 251197001965 3070310 Eleanor N Johnson Middle   Regular School No Middle 06 08 2020   grade_7 112 6 11 2   10     0   4   76 69 *                     145.0 112 6 11 2   10     0   4   76 69                 145
1371448 1371448 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Bird Middle   Regular School No Middle 06 08 2020   grade_7 100 7 11 0   5     0   3   61 65 *                     126.0 100 7 11 0   5     0   3   61 65                 126
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
1371375 1371375 MA Worcester   school 2511850 304   Uxbridge 251185002892 3040405 Whitin Intermediate   Regular School No Middle 04 07 2020   grade_7 118 1 8 4   2     0   1   66 68 *                     134.0 118 1 8 4   2     0   1   66 68                 134
1371361 1371361 MA Middlesex   school 2511760 301   Tyngsborough 251176001715 3010305 Tyngsborough Middle   Regular School No Middle 06 08 2020   grade_7 95 7 11 0   6     0   1   67 53 *                     120.0 95 7 11 0   6     0   1   67 53                 120
1371335 1371335 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No Elementary PK 08 2020   grade_7 20 3 8 1   0     0   2   22 12 *                     34.0 20 3 8 1   0     0   2   22 12                 34
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
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
1371294 1371294 MA Bristol   school 2511520 293   Taunton 251152002416 2930305 John F Parker Middle   Regular School No Middle 05 07 2020   grade_7 93 31 29 0   2     1   7   81 82 *                     163.0 93 31 29 0   2     1   7   81 82                 163
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
1371245 1371245 MA Bristol   school 2511460 292   Swansea 251146001894 2920305 Joseph Case Jr High   Regular School No Middle 06 08 2020   grade_7 179 1 4 0   0     0   2   102 84 *                     186.0 179 1 4 0   0     0   2   102 84                 186
1371225 1371225 MA Essex   school 2511430 291   Swampscott 251143002562 2910305 Swampscott Middle   Regular School No Middle 05 08 2020   grade_7 157 3 16 2   2     0   8   106 82 *                     188.0 157 3 16 2   2     0   8   106 82                 188
1371200 1371200 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton Middle School   Regular School No Middle 06 08 2020   grade_7 111 1 3 0   1     0   6   59 63 *                     122.0 111 1 3 0   1     0   6   59 63                 122
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
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
1371103 1371103 MA Middlesex   school 2511220 284   Stoneham 251122001857 2840405 Stoneham Central Middle School   Regular School No Middle 05 08 2020   grade_7 132 4 24 0   9     0   5   78 96 *                     174.0 132 4 24 0   9     0   5   78 96                 174
1371042 1371042 MA Hampden   school 2511130 281   Springfield 251113002855 2810485 Van Sickle Academy   Regular School No Middle 06 08 2020   grade_7 4 6 57 0   3     0   0   37 33 *                     70.0 4 6 57 0   3     0   0   37 33                 70
1371039 1371039 MA Hampden   school 2511130 281   Springfield 251113002859 2810480 Rise Academy at Van Sickle   Regular School No Middle 06 08 2020   grade_7 6 19 77 0   0     0   4   63 43 *                     106.0 6 19 77 0   0     0   4   63 43                 106
1371032 1371032 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Conservatory of the Arts   Regular School No High 06 12 2020   grade_7 5 7 38 0   0     0   2   14 38 *                     52.0 5 7 38 0   0     0   2   14 38                 52
1371029 1371029 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No Middle 06 08 2020   grade_7 12 22 65 0   5     0   2   50 56 *                     106.0 12 22 65 0   5     0   2   50 56                 106
1371026 1371026 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Impact Prep at Chestnut   Regular School No Middle 06 08 2020   grade_7 5 18 113 0   0     0   1   79 58 *                     137.0 5 18 113 0   0     0   1   79 58                 137
1371023 1371023 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Academy   Regular School No Middle 06 08 2020   grade_7 5 11 115 0   1     0   0   73 59 *                     132.0 5 11 115 0   1     0   0   73 59                 132
1371020 1371020 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Balliet Middle School   Regular School No Middle 06 08 2020   grade_7 0 4 6 0   0     0   0   9 1 *                     10.0 0 4 6 0   0     0   0   9 1                 10
1371018 1371018 MA Hampden   school 2511130 281   Springfield 251113002733 2810355 South End Middle School   Regular School No Middle 06 08 2020   grade_7 2 10 71 0   0     0   0   38 45 *                     83.0 2 10 71 0   0     0   0   38 45                 83
1371015 1371015 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 STEM Middle Academy   Regular School No Middle 06 08 2020   grade_7 12 17 60 0   0     0   3   52 40 *                     92.0 12 17 60 0   0     0   3   52 40                 92
1371012 1371012 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield Public Day Middle School   Regular School No Middle 06 08 2020   grade_7 0 5 12 0   0     0   2   17 2 *                     19.0 0 5 12 0   0     0   2   17 2                 19
1371009 1371009 MA Hampden   school 2511130 281   Springfield 251113002602 2810330 M Marcus Kiley Middle   Regular School No Middle 06 08 2020   grade_7 22 56 160 0   3     0   4   145 100 *                     245.0 22 56 160 0   3     0   4   145 100                 245
1371006 1371006 MA Hampden   school 2511130 281   Springfield 251113002601 2810328 John F Kennedy Middle   Regular School No Middle 06 08 2020   grade_7 15 32 110 0   2     0   4   87 76 *                     163.0 15 32 110 0   2     0   4   87 76                 163
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
1370996 1370996 MA Hampden   school 2511130 281   Springfield 251113002599 2810320 John J Duggan Middle   Regular School No High 06 12 2020   grade_7 28 50 88 0   2     0   5   93 80 *                     173.0 28 50 88 0   2     0   5   93 80                 173
1370986 1370986 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No High 06 12 2020   grade_7 18 22 58 0   0     0   0   40 58 *                     98.0 18 22 58 0   0     0   0   40 58                 98
1370885 1370885 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2020   grade_7 9 2 17 0   0     0   1   10 19 *                     29.0 9 2 17 0   0     0   1   10 19                 29
1370764 1370764 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 Michael E. Smith Middle School   Regular School No Middle 05 08 2020   grade_7 120 1 25 0   2     0   2   62 88 *                     150.0 120 1 25 0   2     0   2   62 88                 150
1370747 1370747 MA Worcester   school 2511010 277   Southbridge 251101002865 2770315 Southbridge Middle School   Regular School No Middle 06 08 2020   grade_7 56 8 83 0   4     0   2   83 70 *                     153.0 56 8 83 0   4     0   2   83 70                 153
1370733 1370733 MA Worcester   school 2510980 276   Southborough 251098001221 2760305 P Brent Trottier   Regular School No Middle 06 08 2020   grade_7 99 1 10 0   17     0   7   68 66 *                     134.0 99 1 10 0   17     0   7   68 66                 134
1370706 1370706 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 06 08 2020   grade_7 * * * *   *     *   *   4 * *                     4.0                         4                   4
1370703 1370703 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Winter Hill Community   Regular School No Elementary PK 08 2020   grade_7 6 10 35 0   3     0   0   25 29 *                     54.0 6 10 35 0   3     0   0   25 29                 54
1370693 1370693 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 West Somerville Neighborhood   Regular School No Elementary PK 08 2020   grade_7 27 2 8 0   3     0   2   22 20 *                     42.0 27 2 8 0   3     0   2   22 20                 42
1370683 1370683 MA Middlesex   school 2510890 274   Somerville 251089001736 2740111 E Somerville Community   Regular School No Elementary KG 08 2020   grade_7 12 5 57 1   3     0   0   35 43 *                     78.0 12 5 57 1   3     0   0   35 43                 78
1370674 1370674 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2020   grade_7 38 3 19 1   3     0   1   29 36 *                     65.0 38 3 19 1   3     0   1   29 36                 65
1370664 1370664 MA Middlesex   school 2510890 274   Somerville 251089001738 2740083 John F Kennedy   Regular School No Elementary PK 08 2020   grade_7 35 3 8 0   3     0   1   27 23 *                     50.0 35 3 8 0   3     0   1   27 23                 50

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