enrollments

Data source: Big Local News · About: Big Local

500 rows where grade = "grade_7", state = "MA" and year = 2020 sorted by county 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
1365050 1365050 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No Middle 06 08 2020   grade_7 154 4 26 0   9     0   9   104 98 *                     202.0 154 4 26 0   9     0   9   104 98                 202
1366699 1366699 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Middle 05 08 2020   grade_7 92 7 36 0   1     1   3   83 57 *                     140.0 92 7 36 0   1     1   3   83 57                 140
1366864 1366864 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No Middle 06 08 2020   grade_7 96 1 4 0   2     0   2   47 58 *                     105.0 96 1 4 0   2     0   2   47 58                 105
1367258 1367258 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Middle School   Regular School No Middle 05 08 2020   grade_7 43 7 83 0   14     0   13   79 81 *                     160.0 43 7 83 0   14     0   13   79 81                 160
1367268 1367268 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No Middle 05 08 2020   grade_7 31 9 92 0   4     1   12   77 72 *                     149.0 31 9 92 0   4     1   12   77 72                 149
1367278 1367278 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No Elementary PK 08 2020   grade_7 18 3 38 0   4     0   10   33 40 *                     73.0 18 3 38 0   4     0   10   33 40                 73
1367451 1367451 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No Middle 05 07 2020   grade_7 126 3 47 0   5     0   19   104 96 *                     200.0 126 3 47 0   5     0   19   104 96                 200
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
1367624 1367624 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No High 06 12 2020   grade_7 64 3 5 0   6     0   2   42 38 *                     80.0 64 3 5 0   6     0   2   42 38                 80
1367873 1367873 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No High 07 12 2020   grade_7 70 3 10 0   0     0   2   44 41 *                     85.0 70 3 10 0   0     0   2   44 41                 85
1368092 1368092 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No Middle 05 08 2020   grade_7 83 7 13 0   3     0   5   62 49 *                     111.0 83 7 13 0   3     0   5   62 49                 111
1368140 1368140 MA Worcester   school 2506780 153   Leominster 250678000742 1530045 Samoset School   Regular School No Middle 06 08 2020   grade_7 90 9 59 1   4     1   5   78 90 *                     169.0 90 9 59 1   4     1   5   78 90                 169
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
1368450 1368450 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg Middle School   Regular School No Middle 06 08 2020   grade_7 102 2 16 0   0     1   3   64 60 *                     124.0 102 2 16 0   0     1   3   64 60                 124
1368464 1368464 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_7 * * * *   *     *   *   * * *                     0.0                                             0
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
1369037 1369037 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No High 07 12 2020   grade_7 118 5 14 0   9     0   11   88 69 *                     157.0 118 5 14 0   9     0   11   88 69                 157
1369652 1369652 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Robert E. Melican Middle School   Regular School No Middle 06 08 2020   grade_7 133 2 17 0   23     3   6   85 99 *                     184.0 133 2 17 0   23     3   6   85 99                 184
1369662 1369662 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge Middle   Regular School No Middle 05 08 2020   grade_7 120 2 18 0   2     0   12   70 84 *                     154.0 120 2 18 0   2     0   12   70 84                 154
1369676 1369676 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield High   Regular School No High 07 12 2020   grade_7 35 0 2 0   0     0   1   22 16 *                     38.0 35 0 2 0   0     0   1   22 16                 38
1369821 1369821 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford Middle   Regular School No Middle 05 07 2020   grade_7 112 2 23 0   2     0   9   77 71 *                     148.0 112 2 23 0   2     0   9   77 71                 148
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1372812 1372812 MA Worcester   school 2500073 474   Sizer School: A North Central Charter Essential (District) 250007301750 4740505 Sizer School: A North Central Charter Essential School   Regular School Yes High 07 12 2020   grade_7 50 2 13 0   1     0   1   40 27 *                     67.0 50 2 13 0   1     0   1   40 27                 67
1372880 1372880 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter School   Regular School Yes Elementary KG 08 2020   grade_7 1 34 33 0   0     0   2   34 36 *                     70.0 1 34 33 0   0     0   2   34 36                 70
1373065 1373065 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Overlook Middle School   Regular School No Middle 06 08 2020   grade_7 175 1 7 0   1     0   6   97 93 *                     190.0 175 1 7 0   1     0   6   97 93                 190
1373087 1373087 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No Middle 05 08 2020   grade_7 93 0 12 1   3     0   4   66 47 *                     113.0 93 0 12 1   3     0   4   66 47                 113
1373144 1373144 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Tahanto Regional High   Regular School No High 06 12 2020   grade_7 69 5 1 0   3     0   3   34 47 *                     81.0 69 5 1 0   3     0   3   34 47                 81
1373164 1373164 MA Worcester   school 2502715 622   Blackstone-Millville 250271501082 6220405 Frederick W. Hartnett Middle School   Regular School No Middle 06 08 2020   grade_7 127 0 15 0   2     0   4   63 85 *                     148.0 127 0 15 0   2     0   4   63 85                 148
1373306 1373306 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley Middle School   Regular School No Middle 05 08 2020   grade_7 113 2 8 1   1     0   1   62 64 *                     126.0 113 2 8 1   1     0   1   62 64                 126
1373310 1373310 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Charlton Middle School   Regular School No Middle 05 08 2020   grade_7 145 2 16 0   2     1   3   94 75 *                     169.0 145 2 16 0   2     1   3   94 75                 169
1373538 1373538 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Miscoe Hill School   Regular School No Middle 05 08 2020   grade_7 181 0 11 0   6     0   7   107 98 *                     205.0 181 0 11 0   6     0   7   107 98                 205
1373639 1373639 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No Middle 06 08 2020   grade_7 106 2 9 0   0     1   4   65 57 *                     122.0 106 2 9 0   0     1   4   65 57                 122
1373668 1373668 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No Elementary PK 08 2020   grade_7 78 0 6 0   7     0   1   47 45 *                     92.0 78 0 6 0   7     0   1   47 45                 92
1373671 1373671 MA Worcester   school 2508310 725   Nashoba 250831000947 7250305 Luther Burbank Middle School   Regular School No Middle 06 08 2020   grade_7 65 1 8 0   1     0   2   37 40 *                     77.0 65 1 8 0   1     0   2   37 40                 77
1373674 1373674 MA Worcester   school 2508310 725   Nashoba 250831001868 7250310 Hale   Regular School No Middle 06 08 2020   grade_7 77 1 7 1   11     0   1   58 40 *                     98.0 77 1 7 1   11     0   1   58 40                 98
1373819 1373819 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin Regional Middle School   Regular School No Middle 07 08 2020   grade_7 156 5 11 0   2     0   3   85 92 *                     177.0 156 5 11 0   2     0   3   85 92                 177
1373894 1373894 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2020   grade_7 90 3 12 1   1     0   5   55 57 *                     112.0 90 3 12 1   1     0   5   55 57                 112
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
1373991 1373991 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Paxton Center   Regular School No Elementary KG 08 2020   grade_7 54 3 2 0   4     0   1   36 28 *                     64.0 54 3 2 0   4     0   1   36 28                 64
1374000 1374000 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No Elementary KG 08 2020   grade_7 42 0 0 0   3     0   1   24 22 *                     46.0 42 0 0 0   3     0   1   24 22                 46
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
1374009 1374009 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No Middle 06 08 2020   grade_7 112 2 6 0   4     0   3   65 62 *                     127.0 112 2 6 0   4     0   3   65 62                 127
1374013 1374013 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No Middle 05 08 2020   grade_7 64 1 9 0   3     0   1   38 40 *                     78.0 64 1 9 0   3     0   1   38 40                 78
1374036 1374036 MA Worcester   school 2512100 778   Quaboag Regional 251210002794 7780305 Quaboag Regional Middle Innovation School   Regular School No Middle 07 08 2020   grade_7 73 1 3 0   0     0   4   41 40 *                     81.0 73 1 3 0   0     0   4   41 40                 81
1365281 1365281 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No Elementary KG 08 2020   grade_7 2 3 8 0   1     0   1   12 3 *                     15.0 2 3 8 0   1     0   1   12 3                 15
1365305 1365305 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2020   grade_7 4 11 14 1   0     0   0   14 16 *                     30.0 4 11 14 1   0     0   0   14 16                 30
1365315 1365315 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No Elementary PK 08 2020   grade_7 1 17 17 0   3     0   0   20 18 *                     38.0 1 17 17 0   3     0   0   20 18                 38
1365339 1365339 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2020   grade_7 3 20 64 0   1     0   3   42 49 *                     91.0 3 20 64 0   1     0   3   42 49                 91
1365386 1365386 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No High 06 12 2020   grade_7 2 49 26 0   3     2   2   41 43 *                     84.0 2 49 26 0   3     2   2   41 43                 84
1365400 1365400 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2020   grade_7 1 15 21 0   0     1   3   18 23 *                     41.0 1 15 21 0   0     1   3   18 23                 41
1365410 1365410 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2020   grade_7 6 1 97 0   1     0   0   55 50 *                     105.0 6 1 97 0   1     0   0   55 50                 105
1365427 1365427 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No Elementary PK 08 2020   grade_7 15 8 14 0   5     0   1   23 20 *                     43.0 15 8 14 0   5     0   1   23 20                 43
1365444 1365444 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No Elementary PK 08 2020   grade_7 1 19 21 0   1     0   2   24 20 *                     44.0 1 19 21 0   1     0   2   24 20                 44
1365482 1365482 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Condon K-8   Regular School No Elementary PK 08 2020   grade_7 20 28 32 0   2     0   1   42 41 *                     83.0 20 28 32 0   2     0   1   42 41                 83
1365491 1365491 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No Elementary KG 08 2020   grade_7 4 14 55 0   0     0   2   35 40 *                     75.0 4 14 55 0   0     0   2   35 40                 75
1365529 1365529 MA Suffolk   school 2502790 35   Boston 250279000269 350179 John W McCormack   Regular School No Middle 06 08 2020   grade_7 8 36 61 1   3     0   2   48 63 *                     111.0 8 36 61 1   3     0   2   48 63                 111
1365553 1365553 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2020   grade_7 0 1 19 0   0     0   0   13 7 *                     20.0 0 1 19 0   0     0   0   13 7                 20
1365563 1365563 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No Elementary PK 08 2020   grade_7 1 32 21 0   4     0   6   31 33 *                     64.0 1 32 21 0   4     0   6   31 33                 64
1365580 1365580 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2020   grade_7 10 1 11 0   2     0   1   12 13 *                     25.0 10 1 11 0   2     0   1   12 13                 25
1365611 1365611 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2020   grade_7 1 10 27 0   1     0   0   10 29 *                     39.0 1 10 27 0   1     0   0   10 29                 39
1365635 1365635 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No Elementary PK 08 2020   grade_7 3 19 32 0   24     0   3   47 34 *                     81.0 3 19 32 0   24     0   3   47 34                 81
1365652 1365652 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2020   grade_7 6 5 5 0   2     0   2   9 11 *                     20.0 6 5 5 0   2     0   2   9 11                 20
1365662 1365662 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2020   grade_7 1 43 42 0   0     1   0   39 48 *                     87.0 1 43 42 0   0     1   0   39 48                 87
1365668 1365668 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Middle 03 08 2020   grade_7 6 25 41 0   0     0   3   41 34 *                     75.0 6 25 41 0   0     0   3   41 34                 75
1365678 1365678 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No Elementary PK 08 2020   grade_7 4 6 18 0   0     0   2   14 16 *                     30.0 4 6 18 0   0     0   2   14 16                 30
1365740 1365740 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2020   grade_7 2 9 17 0   0     0   0   17 11 *                     28.0 2 9 17 0   0     0   0   17 11                 28
1365750 1365750 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No Elementary PK 08 2020   grade_7 6 8 20 0   2     0   2   22 16 *                     38.0 6 8 20 0   2     0   2   22 16                 38
1365767 1365767 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2020   grade_7 12 5 10 0   0     0   5   13 19 *                     32.0 12 5 10 0   0     0   5   13 19                 32
1365781 1365781 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other KG 12 2020   grade_7 2 14 12 0   1     0   0   21 8 *                     29.0 2 14 12 0   1     0   0   21 8                 29
1365803 1365803 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2020   grade_7 1 15 9 0   1     2   0   20 8 *                     28.0 1 15 9 0   1     2   0   20 8                 28
1365820 1365820 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No Elementary PK 08 2020   grade_7 6 11 38 0   4     0   3   33 29 *                     62.0 6 11 38 0   4     0   3   33 29                 62
1365830 1365830 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2020   grade_7 3 28 17 0   0     0   5   26 27 *                     53.0 3 28 17 0   0     0   5   26 27                 53
1365836 1365836 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Middle 03 08 2020   grade_7 2 22 20 0   0     0   1   31 14 *                     45.0 2 22 20 0   0     0   1   31 14                 45
1365846 1365846 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2020   grade_7 2 52 38 0   0     0   2   55 39 *                     94.0 2 52 38 0   0     0   2   55 39                 94
1365856 1365856 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2020   grade_7 0 19 23 0   0     0   0   22 20 *                     42.0 0 19 23 0   0     0   0   22 20                 42
1365866 1365866 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2020   grade_7 3 3 11 0   0     0   1   9 9 *                     18.0 3 3 11 0   0     0   1   9 9                 18
1365869 1365869 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Lilla G. Frederick Middle School   Regular School No Middle 06 08 2020   grade_7 2 57 70 0   13     1   6   87 62 *                     149.0 2 57 70 0   13     1   6   87 62                 149
1365883 1365883 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2020   grade_7 11 24 23 2   3     0   0   30 33 *                     63.0 11 24 23 2   3     0   0   30 33                 63
1365891 1365891 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No Middle 06 08 2020   grade_7 15 21 91 0   2     0   0   66 63 *                     129.0 15 21 91 0   2     0   0   66 63                 129
1365894 1365894 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Washington Irving Middle   Regular School No Middle 06 08 2020   grade_7 4 37 43 0   0     0   2   41 45 *                     86.0 4 37 43 0   0     0   2   41 45                 86
1365897 1365897 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No Middle 06 08 2020   grade_7 1 43 58 0   2     0   0   55 49 *                     104.0 1 43 58 0   2     0   0   55 49                 104
1365948 1365948 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative School No High 07 12 2020   grade_7 2 19 16 0   0     0   0   18 19 *                     37.0 2 19 16 0   0     0   0   18 19                 37
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
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
1365987 1365987 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No High 06 12 2020   grade_7 2 14 21 0   38     0   2   39 38 *                     77.0 2 14 21 0   38     0   2   39 38                 77

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