enrollments

Data source: Big Local News · About: Big Local

572 rows where grade = "grade_6", state = "MA" and year = 2020 sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 572 ✖

grade ✖

  • grade_6 · 572 ✖
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
1368744 1368744 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2020   grade_6 120 12 215 1   14     0   9   204 167 *                     371.0 120 12 215 1   14     0   9   204 167                 371
1367296 1367296 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2020   grade_6 14 0 0 0   0     0   0   9 5 *                     14.0 14 0 0 0   0     0   0   9 5                 14
1372665 1372665 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_6 13 78 22 0   4     0   3   56 64 *                     120.0 13 78 22 0   4     0   3   56 64                 120
1371953 1371953 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No Middle 05 08 2020   grade_6 323 24 58 1   33     0   24   236 227 *                     463.0 323 24 58 1   33     0   24   236 227                 463
1364791 1364791 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2020   grade_6 137 6 20 2   4     0   3   92 80 *                     172.0 137 6 20 2   4     0   3   92 80                 172
1372469 1372469 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_6 6 46 22 0   0     0   1   46 29 *                     75.0 6 46 22 0   0     0   1   46 29                 75
1368463 1368463 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_6 * * * *   *     *   *   * * *                     0.0                                             0
1372560 1372560 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_6 77 4 10 0   6     0   7   48 56 *                     104.0 77 4 10 0   6     0   7   48 56                 104
1364806 1364806 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2020   grade_6 97 1 2 0   1     0   0   57 44 *                     101.0 97 1 2 0   1     0   0   57 44                 101
1370673 1370673 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2020   grade_6 24 2 15 0   4     0   1   24 22 *                     46.0 24 2 15 0   4     0   1   24 22                 46
1367980 1367980 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Middle 03 08 2020   grade_6 3 1 87 0   2     0   0   46 47 *                     93.0 3 1 87 0   2     0   0   46 47                 93
1370884 1370884 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2020   grade_6 5 6 27 0   0     0   0   17 21 *                     38.0 5 6 27 0   0     0   0   17 21                 38
1372449 1372449 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_6 28 15 51 0   0     0   2   40 56 *                     96.0 28 15 51 0   0     0   2   40 56                 96
1364851 1364851 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2020   grade_6 128 4 18 0   2     0   10   96 66 *                     162.0 128 4 18 0   2     0   10   96 66                 162
1366394 1366394 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2020   grade_6 12 4 20 0   2     0   4   22 20 *                     42.0 12 4 20 0   2     0   4   22 20                 42
1364919 1364919 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No Middle 06 08 2020   grade_6 120 10 12 0   39     0   3   94 90 *                     184.0 120 10 12 0   39     0   3   94 90                 184
1371975 1371975 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No Elementary PK 06 2020   grade_6 16 0 0 0   1     0   0   9 8 *                     17.0 16 0 0 0   1     0   0   9 8                 17
1367429 1367429 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No Middle 06 08 2020   grade_6 113 4 7 0   5     0   1   66 64 *                     130.0 113 4 7 0   5     0   1   66 64                 130
1374234 1374234 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Secondary 06 11 2020   grade_6 57 15 40 0   3     1   2   59 59 *                     118.0 57 15 40 0   3     1   2   59 59                 118
1367984 1367984 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2020   grade_6 4 0 140 1   0     0   0   69 75 *                     145.0 4 0 140 1   0     0   0   69 75                 145
1370654 1370654 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No Elementary PK 08 2020   grade_6 11 7 29 0   1     0   2   29 21 *                     50.0 11 7 29 0   1     0   2   29 21                 50
1367267 1367267 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No Middle 05 08 2020   grade_6 52 16 94 0   7     0   14   97 86 *                     183.0 52 16 94 0   7     0   14   97 86                 183
1370257 1370257 MA Middlesex   school 2509990 246   Reading 250999001605 2460305 Arthur W Coolidge Middle   Regular School No Middle 06 08 2020   grade_6 128 2 0 0   2     0   3   75 60 *                     135.0 128 2 0 0   2     0   3   75 60                 135
1366235 1366235 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No Middle 06 08 2020   grade_6 55 100 30 3   10     0   5   117 86 *                     203.0 55 100 30 3   10     0   5   117 86                 203
1364987 1364987 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No Middle 06 08 2020   grade_6 150 4 32 4   30     0   9   118 111 *                     229.0 150 4 32 4   30     0   9   118 111                 229
1373086 1373086 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No Middle 05 08 2020   grade_6 93 0 11 0   1     0   3   63 45 *                     108.0 93 0 11 0   1     0   3   63 45                 108
1370166 1370166 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No Middle 06 08 2020   grade_6 60 7 9 0   100     1   3   90 90 *                     180.0 60 7 9 0   100     1   3   90 90                 180
1372918 1372918 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2020   grade_6 91 2 15 0   2     0   0   51 59 *                     110.0 91 2 15 0   2     0   0   51 59                 110
1365049 1365049 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No Middle 06 08 2020   grade_6 176 7 17 0   7     0   9   92 124 *                     216.0 176 7 17 0   7     0   9   92 124                 216
1373107 1373107 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2020   grade_6 102 8 22 0   4     0   4   72 68 *                     140.0 102 8 22 0   4     0   4   72 68                 140
1368382 1368382 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 B.F. Butler Middle School   Regular School No Middle 05 08 2020   grade_6 30 7 52 0   45     0   13   72 75 *                     147.0 30 7 52 0   45     0   13   72 75                 147
1365094 1365094 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No Middle 06 07 2020   grade_6 242 24 78 4   8     1   18   202 173 *                     375.0 242 24 78 4   8     1   18   202 173                 375
1368378 1368378 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No Elementary PK 08 2020   grade_6 10 1 22 0   19     0   4   26 30 *                     56.0 10 1 22 0   19     0   4   26 30                 56
1374189 1374189 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes High 06 12 2020   grade_6 36 32 5 0   0     1   5   40 39 *                     79.0 36 32 5 0   0     1   5   40 39                 79
1370014 1370014 MA Norfolk   school 2509690 238   Plainville 250969001538 2380005 Beatrice H Wood Elementary   Regular School No Middle 04 06 2020   grade_6 90 2 15 1   4     0   3   55 60 *                     115.0 90 2 15 1   4     0   3   55 60                 115
1368641 1368641 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2020   grade_6 28 15 13 0   32     0   2   38 52 *                     90.0 28 15 13 0   32     0   2   38 52                 90
1366668 1366668 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No Middle 06 08 2020   grade_6 136 10 141 0   5     0   9   169 132 *                     301.0 136 10 141 0   5     0   9   169 132                 301
1365142 1365142 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial School   Regular School No Middle 04 07 2020   grade_6 158 6 11 0   3     0   7   78 107 *                     185.0 158 6 11 0   3     0   7   78 107                 185
1372131 1372131 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2020   grade_6 13 9 25 0   3     0   3   28 25 *                     53.0 13 9 25 0   3     0   3   28 25                 53
1370478 1370478 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Belmonte Saugus Middle   Regular School No Middle 06 08 2020   grade_6 157 18 43 1   6     1   7   115 118 *                     233.0 157 18 43 1   6     1   7   115 118                 233
1372519 1372519 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2020   grade_6 0 36 2 0   0     0   0   19 19 *                     38.0 0 36 2 0   0     0   0   19 19                 38
1372691 1372691 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_6 33 1 4 0   10     0   4   30 22 *                     52.0 33 1 4 0   10     0   4   30 22                 52
1371296 1371296 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Benjamin Friedman Middle   Regular School No Middle 05 07 2020   grade_6 204 27 16 0   2     0   11   137 123 *                     260.0 204 27 16 0   2     0   11   137 123                 260
1365190 1365190 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2020   grade_6 107 0 1 0   0     0   6   59 55 *                     114.0 107 0 1 0   0     0   6   59 55                 114
1372482 1372482 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_6 50 9 9 0   1     0   3   39 33 *                     72.0 50 9 9 0   1     0   3   39 33                 72
1373768 1373768 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Bernardston Elementary   Regular School No Elementary PK 06 2020   grade_6 18 0 0 0   0     0   0   8 10 *                     18.0 18 0 0 0   0     0   0   8 10                 18
1365220 1365220 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly Middle School   Regular School No Middle 05 08 2020   grade_6 295 13 58 0   8     1   17   205 187 *                     392.0 295 13 58 0   8     1   17   205 187                 392
1369461 1369461 MA Middlesex   school 2508610 207   Newton 250861000307 2070305 Bigelow Middle   Regular School No Middle 06 08 2020   grade_6 110 6 11 0   27     0   8   72 89 *                     162.0 110 6 11 0   27     0   8   72 89                 162
1366979 1366979 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 Birchland Park   Regular School No Middle 06 08 2020   grade_6 165 6 10 0   19     0   9   99 110 *                     209.0 165 6 10 0   19     0   9   99 110                 209
1371447 1371447 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Bird Middle   Regular School No Middle 06 08 2020   grade_6 129 7 7 0   2     0   3   75 73 *                     148.0 129 7 7 0   2     0   3   75 73                 148
1372987 1372987 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No Elementary KG 06 2020   grade_6 29 1 2 0   19     0   1   18 34 *                     52.0 29 1 2 0   19     0   1   18 34                 52
1371784 1371784 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No Middle 06 08 2020   grade_6 101 3 7 1   48     0   7   80 87 *                     167.0 101 3 7 1   48     0   7   80 87                 167
1372695 1372695 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes High 05 12 2020   grade_6 44 30 21 0   5     0   2   51 51 *                     102.0 44 30 21 0   5     0   2   51 51                 102
1372460 1372460 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_6 2 25 32 0   0     0   4   27 36 *                     63.0 2 25 32 0   0     0   4   27 36                 63
1372489 1372489 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_6 6 65 23 0   1     1   3   54 45 *                     99.0 6 65 23 0   1     1   3   54 45                 99
1372840 1372840 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2020   grade_6 1 51 19 0   1     0   5   34 43 *                     77.0 1 51 19 0   1     0   5   34 43                 77
1365304 1365304 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2020   grade_6 18 12 12 0   5     0   1   23 25 *                     48.0 18 12 12 0   5     0   1   23 25                 48
1366064 1366064 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 06 08 2020   grade_6 149 5 8 4   4     0   4   80 94 *                     174.0 149 5 8 4   4     0   4   80 94                 174
1369513 1369513 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No Elementary PK 06 2020   grade_6 27 4 3 0   0     0   0   18 16 *                     34.0 27 4 3 0   0     0   0   18 16                 34
1368586 1368586 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No Middle 06 08 2020   grade_6 36 48 359 1   54     0   19   260 257 *                     517.0 36 48 359 1   54     0   19   260 257                 517
1372503 1372503 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 08 2020   grade_6 0 22 12 0   0     0   0   15 19 *                     34.0 0 22 12 0   0     0   0   15 19                 34
1366141 1366141 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No Elementary PK 06 2020   grade_6 37 3 1 0   0     0   1   16 26 *                     42.0 37 3 1 0   0     0   1   16 26                 42
1370169 1370169 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Broad Meadows Middle   Regular School No Middle 06 08 2020   grade_6 64 13 8 0   19     0   3   50 57 *                     107.0 64 13 8 0   19     0   3   50 57                 107
1367623 1367623 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No High 06 12 2020   grade_6 79 1 3 0   5     0   7   39 55 *                     95.0 79 1 3 0   5     0   7   39 55                 95
1372540 1372540 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_6 6 99 64 0   5     0   2   80 96 *                     176.0 6 99 64 0   5     0   2   80 96                 176
1366262 1366262 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2020   grade_6 34 0 1 0   0     0   2   16 21 *                     37.0 34 0 1 0   0     0   2   16 21                 37
1369915 1369915 MA Plymouth   school 2509420 231   Pembroke 250942001508 2310003 Bryantville Elementary   Regular School No Elementary KG 06 2020   grade_6 68 0 0 0   0     0   2   27 43 *                     70.0 68 0 0 0   0     0   2   27 43                 70
1373601 1373601 MA Franklin   school 2507990 717   Mohawk Trail 250799000424 7170005 Buckland-Shelburne Regional   Regular School No Elementary PK 06 2020   grade_6 31 0 1 0   0     0   1   16 17 *                     33.0 31 0 1 0   0     0   1   16 17                 33
1371155 1371155 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No Elementary PK 06 2020   grade_6 119 2 8 1   2     0   3   81 54 *                     135.0 119 2 8 1   2     0   3   81 54                 135
1372152 1372152 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No Elementary KG 06 2020   grade_6 12 12 15 0   1     0   3   21 22 *                     43.0 12 12 15 0   1     0   3   21 22                 43
1373008 1373008 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No Elementary KG 06 2020   grade_6 42 1 6 1   18     0   2   36 34 *                     70.0 42 1 6 1   18     0   2   36 34                 70
1367660 1367660 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Caleb Dustin Hunking School   Regular School No Elementary KG 08 2020   grade_6 114 12 43 1   3     0   1   90 84 *                     174.0 114 12 43 1   3     0   1   90 84                 174
1366467 1366467 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge Street Upper School   Regular School No Middle 06 08 2020   grade_6 43 27 17 1   7     0   11   62 44 *                     106.0 43 27 17 1   7     0   11   62 44                 106
1367379 1367379 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No Middle 06 08 2020   grade_6 150 12 40 0   2     0   11   114 101 *                     215.0 150 12 40 0   2     0   11   114 101                 215
1372160 1372160 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No Elementary PK 06 2020   grade_6 5 8 30 0   4     0   2   29 20 *                     49.0 5 8 30 0   4     0   2   29 20                 49
1372577 1372577 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_6 71 1 4 0   2     0   3   42 39 *                     81.0 71 1 4 0   2     0   3   42 39                 81
1366518 1366518 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No Elementary PK 08 2020   grade_6 60 0 2 0   9     0   6   40 37 *                     77.0 60 0 2 0   9     0   6   40 37                 77
1366528 1366528 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No High 06 12 2020   grade_6 111 4 2 1   1     0   3   57 65 *                     122.0 111 4 2 1   1     0   3   57 65                 122
1370172 1370172 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No Middle 06 08 2020   grade_6 94 8 6 0   105     2   4   111 108 *                     219.0 94 8 6 0   105     2   4   111 108                 219
1374008 1374008 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No Middle 06 08 2020   grade_6 96 3 5 0   4     0   5   58 55 *                     113.0 96 3 5 0   4     0   5   58 55                 113
1372167 1372167 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No Elementary KG 06 2020   grade_6 13 6 38 0   6     0   1   35 29 *                     64.0 13 6 38 0   6     0   1   35 29                 64
1372175 1372175 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2020   grade_6 11 3 59 0   0     0   1   34 40 *                     74.0 11 3 59 0   0     0   1   34 40                 74
1369464 1369464 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Charles E Brown Middle   Regular School No Middle 06 08 2020   grade_6 181 3 11 1   58     0   9   138 125 *                     263.0 181 3 11 1   58     0   9   138 125                 263
1372431 1372431 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Charles E Roderick   Regular School No Middle 04 06 2020   grade_6 132 3 7 1   3     0   6   87 65 *                     152.0 132 3 7 1   3     0   6   87 65                 152
1369083 1369083 MA Norfolk   school 2507980 189   Milton 250798001257 1890410 Charles S Pierce Middle   Regular School No Middle 06 08 2020   grade_6 243 45 19 0   23     0   21   182 169 *                     351.0 243 45 19 0   23     0   21   182 169                 351
1373309 1373309 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Charlton Middle School   Regular School No Middle 05 08 2020   grade_6 164 1 13 1   3     0   3   94 91 *                     185.0 164 1 13 1   3     0   3   94 91                 185
1371022 1371022 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Academy   Regular School No Middle 06 08 2020   grade_6 3 9 95 0   1     0   0   67 41 *                     108.0 3 9 95 0   1     0   0   67 41                 108
1371028 1371028 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No Middle 06 08 2020   grade_6 12 25 65 0   4     0   3   58 51 *                     109.0 12 25 65 0   4     0   3   58 51                 109
1365120 1365120 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Chestnut Hill Community School   Regular School No Middle 04 06 2020   grade_6 158 2 6 1   2     0   3   82 90 *                     172.0 158 2 6 1   2     0   3   82 90                 172
1374012 1374012 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No Middle 05 08 2020   grade_6 82 1 6 0   0     0   2   51 40 *                     91.0 82 1 6 0   0     0   2   51 40                 91
1372506 1372506 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_6 67 9 56 0   11     0   2   74 71 *                     145.0 67 9 56 0   11     0   2   74 71                 145
1372183 1372183 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2020   grade_6 13 6 31 0   2     0   2   25 29 *                     54.0 13 6 31 0   2     0   2   25 29                 54
1365890 1365890 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No Middle 06 08 2020   grade_6 8 21 97 0   11     1   2   72 68 *                     140.0 8 21 97 0   11     1   2   72 68                 140
1366595 1366595 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2020   grade_6 11 6 171 1   1     1   2   99 94 *                     193.0 11 6 171 1   1     1   2   99 94                 193
1372191 1372191 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary PK 06 2020   grade_6 5 8 5 0   1     0   0   11 8 *                     19.0 5 8 5 0   1     0   0   11 8                 19
1366688 1366688 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2020   grade_6 33 0 0 0   0     0   1   14 20 *                     34.0 33 0 0 0   0     0   1   14 20                 34
1366698 1366698 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Middle 05 08 2020   grade_6 121 5 32 0   2     0   5   91 74 *                     165.0 121 5 32 0   2     0   5   91 74                 165
1372606 1372606 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_6 0 16 4 0   0     0   0   12 8 *                     20.0 0 16 4 0   0     0   0   12 8                 20
1366713 1366713 MA Norfolk   school 2503780 65   Cohasset 250378002910 650305 Cohasset Middle School   Regular School No Middle 06 08 2020   grade_6 128 4 1 0   1     0   0   67 67 *                     134.0 128 4 1 0   1     0   0   67 67                 134
1366558 1366558 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Col Moses Parker School   Regular School No Middle 05 08 2020   grade_6 129 9 12 2   27     0   7   123 63 *                     186.0 129 9 12 2   27     0   7   123 63                 186

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