enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 486 ✖

grade ✖

  • grade_7 · 486 ✖
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
1365095 1365095 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No Middle 06 07 2020   grade_7 274 28 53 0   9     2   15   190 191 *                     381.0 274 28 53 0   9     2   15   190 191                 381
1365110 1365110 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 John Glenn Middle   Regular School No Middle 06 08 2020   grade_7 145 11 13 1   40     0   0   120 90 *                     210.0 145 11 13 1   40     0   0   120 90                 210
1365124 1365124 MA Hampshire   school 2502430 24   Belchertown 250243001873 240025 Jabish Middle School   Regular School No Middle 07 08 2020   grade_7 162 7 5 0   4     1   5   101 83 *                     184.0 162 7 5 0   4     1   5   101 83                 184
1365143 1365143 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial School   Regular School No Middle 04 07 2020   grade_7 149 1 6 0   9     0   0   78 87 *                     165.0 149 1 6 0   9     0   0   78 87                 165
1365177 1365177 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No Middle 05 08 2020   grade_7 228 13 17 0   74     0   27   184 175 *                     359.0 228 13 17 0   74     0   27   184 175                 359
1365191 1365191 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2020   grade_7 91 0 4 0   0     0   2   48 49 *                     97.0 91 0 4 0   0     0   2   48 49                 97
1365221 1365221 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly Middle School   Regular School No Middle 05 08 2020   grade_7 280 9 55 0   12     0   7   189 174 *                     363.0 280 9 55 0   12     0   7   189 174                 363
1365255 1365255 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Marshall Middle School   Regular School No Middle 05 07 2020   grade_7 155 16 17 1   12     0   5   104 102 *                     206.0 155 16 17 1   12     0   5   104 102                 206
1365258 1365258 MA Middlesex   school 2502670 31   Billerica 250267000182 310310 Locke Middle   Regular School No Middle 05 07 2020   grade_7 147 7 10 0   17     0   7   90 98 *                     188.0 147 7 10 0   17     0   7   90 98                 188
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
1365994 1365994 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No High 07 12 2020   grade_7 29 49 59 0   34     1   3   93 82 *                     175.0 29 49 59 0   34     1   3   93 82                 175
1366018 1366018 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No Elementary PK 08 2020   grade_7 7 1 142 1   1     0   1   75 78 *                     153.0 7 1 142 1   1     0   1   75 78                 153
1366021 1366021 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No High 06 12 2020   grade_7 7 67 35 0   2     0   5   58 58 *                     116.0 7 67 35 0   2     0   5   58 58                 116
1366040 1366040 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No Elementary PK 08 2020   grade_7 2 0 23 0   0     0   0   12 13 *                     25.0 2 0 23 0   0     0   0   12 13                 25
1366048 1366048 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other 01 12 2020   grade_7 0 3 5 0   0     0   0   6 2 *                     8.0 0 3 5 0   0     0   0   6 2                 8
1366065 1366065 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 06 08 2020   grade_7 140 3 12 3   2     0   6   94 72 *                     166.0 140 3 12 3   2     0   6   94 72                 166
1366117 1366117 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 East Middle School   Regular School No Middle 06 08 2020   grade_7 147 28 18 0   64     0   1   133 125 *                     258.0 147 28 18 0   64     0   1   133 125                 258
1366120 1366120 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 South Middle School   Regular School No Middle 06 08 2020   grade_7 181 9 8 0   53     0   1   122 130 *                     252.0 181 9 8 0   53     0   1   122 130                 252
1366181 1366181 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2020   grade_7 16 84 19 1   2     0   7   65 64 *                     129.0 16 84 19 1   2     0   7   65 64                 129
1366219 1366219 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 02 12 2020   grade_7 * * * *   *     *   *   3 1 *                     4.0                         3 1                 4
1366226 1366226 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 East Middle School   Regular School No Middle 06 08 2020   grade_7 24 199 33 2   3     0   11   139 133 *                     272.0 24 199 33 2   3     0   11   139 133                 272
1366230 1366230 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No Middle 06 08 2020   grade_7 25 136 30 0   0     0   7   108 90 *                     198.0 25 136 30 0   0     0   7   108 90                 198
1366233 1366233 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No Middle 06 08 2020   grade_7 53 154 23 2   8     0   7   137 110 *                     247.0 53 154 23 2   8     0   7   137 110                 247
1366236 1366236 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No Middle 06 08 2020   grade_7 64 117 25 2   7     2   4   96 125 *                     221.0 64 117 25 2   7     2   4   96 125                 221
1366239 1366239 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No Middle 06 08 2020   grade_7 50 122 77 1   8     0   14   142 130 *                     272.0 50 122 77 1   8     0   14   142 130                 272
1366273 1366273 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No Elementary KG 08 2020   grade_7 57 4 11 0   17     0   6   51 44 *                     95.0 57 4 11 0   17     0   6   51 44                 95
1366283 1366283 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Coolidge Corner School   Regular School No Elementary PK 08 2020   grade_7 52 7 18 0   9     0   7   50 43 *                     93.0 52 7 18 0   9     0   7   50 43                 93
1366292 1366292 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No Elementary KG 08 2020   grade_7 35 2 11 0   8     0   10   28 38 *                     66.0 35 2 11 0   8     0   10   28 38                 66
1366302 1366302 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Heath   Regular School No Elementary PK 08 2020   grade_7 39 2 7 0   9     0   5   23 39 *                     62.0 39 2 7 0   9     0   5   23 39                 62
1366311 1366311 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Lawrence   Regular School No Elementary KG 08 2020   grade_7 37 4 4 0   22     0   5   42 30 *                     72.0 37 4 4 0   22     0   5   42 30                 72
1366320 1366320 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No Elementary KG 08 2020   grade_7 48 9 8 0   8     0   5   29 49 *                     78.0 48 9 8 0   8     0   5   29 49                 78
1366329 1366329 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No Elementary KG 08 2020   grade_7 52 3 6 0   12     0   6   38 41 *                     79.0 52 3 6 0   12     0   6   38 41                 79
1366339 1366339 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No Elementary PK 08 2020   grade_7 48 3 6 0   7     0   9   33 40 *                     73.0 48 3 6 0   7     0   9   33 40                 73
1366372 1366372 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Marshall Simonds Middle   Regular School No Middle 06 08 2020   grade_7 166 17 17 0   58     0   14   129 143 *                     272.0 166 17 17 0   58     0   14   129 143                 272
1366395 1366395 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2020   grade_7 17 0 22 0   0     0   5   22 22 *                     44.0 17 0 22 0   0     0   5   22 22                 44
1366468 1366468 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge Street Upper School   Regular School No Middle 06 08 2020   grade_7 45 19 15 1   10     0   9   57 42 *                     99.0 45 19 15 1   10     0   9   57 42                 99
1366471 1366471 MA Middlesex   school 2503270 49   Cambridge 250327002768 490310 Putnam Avenue Upper School   Regular School No Middle 06 08 2020   grade_7 29 33 14 0   14     1   7   39 59 *                     98.0 29 33 14 0   14     1   7   39 59                 98
1366474 1366474 MA Middlesex   school 2503270 49   Cambridge 250327002746 490315 Rindge Avenue Upper School   Regular School No Middle 06 08 2020   grade_7 37 34 6 0   8     0   10   48 47 *                     95.0 37 34 6 0   8     0   10   48 47                 95
1366477 1366477 MA Middlesex   school 2503270 49   Cambridge 250327002756 490320 Vassal Lane Upper School   Regular School No Middle 06 08 2020   grade_7 44 27 3 0   18     0   8   51 48 *                     100.0 44 27 3 0   18     0   8   51 48                 100
1366504 1366504 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Wm H Galvin Middle   Regular School No Middle 06 08 2020   grade_7 171 32 8 0   28     0   12   113 138 *                     251.0 171 32 8 0   28     0   12   113 138                 251
1366519 1366519 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No Elementary PK 08 2020   grade_7 49 0 1 0   6     0   8   36 28 *                     64.0 49 0 1 0   6     0   8   36 28                 64
1366529 1366529 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No High 06 12 2020   grade_7 116 0 5 1   0     1   0   69 54 *                     123.0 116 0 5 1   0     1   0   69 54                 123
1366559 1366559 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Col Moses Parker School   Regular School No Middle 05 08 2020   grade_7 130 4 13 2   26     0   4   107 72 *                     179.0 130 4 13 2   26     0   4   107 72                 179
1366563 1366563 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No Middle 05 08 2020   grade_7 130 6 14 0   20     0   11   109 72 *                     181.0 130 6 14 0   20     0   11   109 72                 181
1366592 1366592 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2020   grade_7 7 8 112 0   0     0   2   58 71 *                     129.0 7 8 112 0   0     0   2   58 71                 129
1366596 1366596 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2020   grade_7 10 6 147 1   2     0   2   96 72 *                     168.0 10 6 147 1   2     0   2   96 72                 168
1366600 1366600 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No Middle 05 08 2020   grade_7 4 2 140 0   0     0   1   76 71 *                     147.0 4 2 140 0   0     0   1   76 71                 147
1366632 1366632 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No High 07 12 2020   grade_7 * * * *   *     *   *   4 1 *                     5.0                         4 1                 5
1366669 1366669 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No Middle 06 08 2020   grade_7 139 8 114 0   4     0   14   148 131 *                     279.0 139 8 114 0   4     0   14   148 131                 279
1366672 1366672 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Dupont Middle   Regular School No Middle 06 08 2020   grade_7 119 10 124 1   9     0   8   155 116 *                     271.0 119 10 124 1   9     0   8   155 116                 271
1366689 1366689 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2020   grade_7 20 0 0 0   0     0   2   12 10 *                     22.0 20 0 0 0   0     0   2   12 10                 22
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
1366714 1366714 MA Norfolk   school 2503780 65   Cohasset 250378002910 650305 Cohasset Middle School   Regular School No Middle 06 08 2020   grade_7 108 3 0 0   1     0   4   70 46 *                     116.0 108 3 0 0   1     0   4   70 46                 116
1366742 1366742 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No Middle 06 08 2020   grade_7 176 11 11 1   26     0   11   123 113 *                     236.0 176 11 11 1   26     0   11   123 113                 236
1366784 1366784 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No Middle 06 08 2020   grade_7 215 10 27 1   4     0   8   135 130 *                     265.0 215 10 27 1   4     0   8   135 130                 265
1366812 1366812 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth Middle   Regular School No Middle 06 08 2020   grade_7 274 3 11 0   2     1   16   173 134 *                     307.0 274 3 11 0   2     1   16   173 134                 307
1366841 1366841 MA Norfolk   school 2504050 73   Dedham 250405000551 730305 Dedham Middle School   Regular School No Middle 06 08 2020   grade_7 173 21 45 1   5     0   13   137 121 *                     258.0 173 21 45 1   5     0   13   137 121                 258
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
1366903 1366903 MA Middlesex   school 2504320 79   Dracut 250432001625 790410 Justus C. Richardson Middle School   Regular School No Middle 06 08 2020   grade_7 241 22 49 0   20     0   3   175 160 *                     335.0 241 22 49 0   20     0   3   175 160                 335
1366917 1366917 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury Middle   Regular School No Middle 06 08 2020   grade_7 241 0 6 1   3     0   7   114 144 *                     258.0 241 0 6 1   3     0   7   114 144                 258

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