enrollments

Data source: Big Local News · About: Big Local

575 rows where grade = "grade_6", state = "MA" and year = 2016 sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 575 ✖

grade ✖

  • grade_6 · 575 ✖
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
936518 936518 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No 2 05 08 2016   grade_6 138 12 122 0   4     0   12   161 127                       288 138 12 122 0   4     0   12   161 127                 288
935064 935064 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2016   grade_6 9 0 0 0   0     0   0   5 4                       9 9 0 0 0   0     0   0   5 4                 9
940431 940431 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2016   grade_6 26 63 28 0   7     0   0   57 67                       124 26 63 28 0   7     0   0   57 67                 124
939726 939726 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No 2 05 06 2016   grade_6 389 30 33 0   22     1   23   267 231                       498 389 30 33 0   22     1   23   267 231                 498
940248 940248 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 4 05 12 2016   grade_6 14 45 20 0   0     0   0   34 45                       79 14 45 20 0   0     0   0   34 45                 79
940326 940326 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes 4 06 12 2016   grade_6 95 2 9 0   28     0   6   65 75                       140 95 2 9 0   28     0   6   65 75                 140
932558 932558 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No 2 05 08 2016   grade_6 75 0 3 0   0     0   0   41 37                       78 75 0 3 0   0     0   0   41 37                 78
938446 938446 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No 1 PK 08 2016   grade_6 12 2 19 0   6     0   2   21 20                       41 12 2 19 0   6     0   2   21 20                 41
935756 935756 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No 1 03 08 2016   grade_6 4 2 72 0   0     0   0   42 36                       78 4 2 72 0   0     0   0   42 36                 78
938655 938655 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No 1 PK 08 2016   grade_6 6 10 15 0   0     0   2   15 18                       33 6 10 15 0   0     0   2   15 18                 33
940234 940234 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes 1 KG 06 2016   grade_6 15 7 13 1   2     0   2   18 22                       40 15 7 13 1   2     0   2   18 22                 40
932605 932605 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No 2 05 08 2016   grade_6 160 0 10 0   2     0   6   96 82                       178 160 0 10 0   2     0   6   96 82                 178
934176 934176 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No 1 PK 08 2016   grade_6 8 1 11 0   1     0   4   13 12                       25 8 1 11 0   1     0   4   13 12                 25
932671 932671 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No 2 06 08 2016   grade_6 120 4 10 0   26     0   4   73 91                       164 120 4 10 0   26     0   4   73 91                 164
939746 939746 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No 1 PK 06 2016   grade_6 20 0 1 0   0     0   0   6 15                       21 20 0 1 0   0     0   0   6 15                 21
935191 935191 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No 2 06 08 2016   grade_6 136 1 5 0   6     0   1   75 74                       149 136 1 5 0   6     0   1   75 74                 149
941999 941999 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes 2 06 07 2016   grade_6 75 5 14 1   1     1   5   52 50                       102 75 5 14 1   1     1   5   52 50                 102
935760 935760 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No 2 05 08 2016   grade_6 3 4 141 0   0     0   0   70 78                       148 3 4 141 0   0     0   0   70 78                 148
938426 938426 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No 1 PK 08 2016   grade_6 20 1 25 0   3     0   1   27 23                       50 20 1 25 0   3     0   1   27 23                 50
935034 935034 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No 2 05 08 2016   grade_6 40 4 55 0   7     0   11   71 46                       117 40 4 55 0   7     0   11   71 46                 117
939840 939840 MA Suffolk   school 2513170 346   Winthrop 251317001841 3460020 Arthur T. Cummings Elementary School   Regular School No 2 04 07 2016   grade_6 128 1 16 0   1     0   3   81 68                       149 128 1 16 0   1     0   3   81 68                 149
938029 938029 MA Middlesex   school 2509990 246   Reading 250999001605 2460305 Arthur W Coolidge Middle   Regular School No 2 06 08 2016   grade_6 138 4 1 0   9     0   1   87 66                       153 138 4 1 0   9     0   1   87 66                 153
934018 934018 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No 2 06 08 2016   grade_6 77 66 20 0   4     1   7   85 90                       175 77 66 20 0   4     1   7   85 90                 175
932739 932739 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No 2 06 08 2016   grade_6 147 7 22 0   26     0   5   96 111                       207 147 7 22 0   26     0   5   96 111                 207
940872 940872 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No 2 05 08 2016   grade_6 84 2 5 1   0     0   2   47 47                       94 84 2 5 1   0     0   2   47 47                 94
937940 937940 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No 2 06 08 2016   grade_6 71 1 0 0   79     1   9   81 80                       161 71 1 0 0   79     1   9   81 80                 161
940702 940702 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 10 2016   grade_6 85 4 7 0   2     0   2   49 51                       100 85 4 7 0   2     0   2   49 51                 100
932801 932801 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No 2 06 08 2016   grade_6 173 4 11 0   5     0   9   99 103                       202 173 4 11 0   5     0   9   99 103                 202
940894 940894 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No 2 06 08 2016   grade_6 97 5 10 1   2     1   7   53 70                       123 97 5 10 1   2     1   7   53 70                 123
936179 936179 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 B.F.Butler Middle School   Regular School No 2 05 08 2016   grade_6 48 11 33 0   33     0   11   65 71                       136 48 11 33 0   33     0   11   65 71                 136
938785 938785 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Balliet Middle School   Regular School No 2 06 08 2016   grade_6 * * * *   *     *   *   2 1                       3                         2 1                 3
932844 932844 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No 2 06 07 2016   grade_6 290 34 27 2   8     0   16   190 187                       377 290 34 27 2   8     0   16   190 187                 377
936175 936175 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No 1 PK 08 2016   grade_6 9 6 19 0   22     0   0   28 28                       56 9 6 19 0   22     0   0   28 28                 56
941966 941966 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes 2 06 09 2016   grade_6 6 24 51 0   1     0   0   42 40                       82 6 24 51 0   1     0   0   42 40                 82
937786 937786 MA Norfolk   school 2509690 238   Plainville 250969001538 2380005 Beatrice H Wood Elementary   Regular School No 2 04 06 2016   grade_6 87 3 7 0   5     0   4   62 44                       106 87 3 7 0   5     0   4   62 44                 106
936411 936411 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No 1 KG 08 2016   grade_6 25 17 13 0   38     0   2   41 54                       95 25 17 13 0   38     0   2   41 54                 95
934444 934444 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No 2 06 08 2016   grade_6 153 9 101 0   6     0   5   144 130                       274 153 9 101 0   6     0   5   144 130                 274
932892 932892 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial School   Regular School No 2 04 07 2016   grade_6 168 5 2 0   4     0   4   89 94                       183 168 5 2 0   4     0   4   89 94                 183
939916 939916 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No 1 PK 06 2016   grade_6 2 9 24 0   4     0   0   19 20                       39 2 9 24 0   4     0   0   19 20                 39
938249 938249 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Belmonte Saugus Middle   Regular School No 2 06 08 2016   grade_6 184 11 19 1   6     1   1   109 114                       223 184 11 19 1   6     1   1   109 114                 223
940293 940293 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes 1 KG 06 2016   grade_6 1 32 4 0   1     0   0   20 18                       38 1 32 4 0   1     0   0   20 18                 38
940457 940457 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes 1 KG 08 2016   grade_6 34 1 0 0   12     0   0   22 25                       47 34 1 0 0   12     0   0   22 25                 47
939055 939055 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Benjamin Friedman Middle   Regular School No 2 05 07 2016   grade_6 225 21 32 1   3     0   8   139 151                       290 225 21 32 1   3     0   8   139 151                 290
938418 938418 MA Middlesex   school 2510890 274   Somerville 251089001732 2740015 Benjamin G Brown   Regular School No 1 KG 06 2016   grade_6 19 0 7 0   4     0   2   15 17                       32 19 0 7 0   4     0   2   15 17                 32
932940 932940 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No 2 05 08 2016   grade_6 94 1 1 0   2     0   2   50 50                       100 94 1 1 0   2     0   2   50 50                 100
940261 940261 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes 4 06 12 2016   grade_6 58 8 6 1   0     0   1   38 36                       74 58 8 6 1   0     0   1   38 36                 74
941521 941521 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Bernardston Elementary   Regular School No 1 PK 06 2016   grade_6 23 0 0 0   0     0   1   13 11                       24 23 0 0 0   0     0   1   13 11                 24
937233 937233 MA Middlesex   school 2508610 207   Newton 250861000307 2070305 Bigelow Middle   Regular School No 2 06 08 2016   grade_6 118 8 13 2   26     0   12   84 95                       179 118 8 13 2   26     0   12   84 95                 179
934755 934755 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 Birchland Park   Regular School No 2 06 08 2016   grade_6 190 3 11 0   15     0   0   111 108                       219 190 3 11 0   15     0   0   111 108                 219
939203 939203 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Bird Middle   Regular School No 2 06 08 2016   grade_6 136 5 8 1   7     0   4   78 83                       161 136 5 8 1   7     0   4   78 83                 161
940761 940761 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No 1 PK 06 2016   grade_6 36 3 2 0   22     0   2   34 31                       65 36 3 2 0   22     0   2   34 31                 65
939553 939553 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No 2 06 08 2016   grade_6 141 1 1 2   55     1   1   108 94                       202 141 1 1 2   55     1   1   108 94                 202
940461 940461 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes 4 05 12 2016   grade_6 46 29 22 0   1     0   2   43 57                       100 46 29 22 0   1     0   2   43 57                 100
940240 940240 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 4 06 12 2016   grade_6 5 40 25 0   1     0   2   42 31                       73 5 40 25 0   1     0   2   42 31                 73
940268 940268 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes 4 06 12 2016   grade_6 1 39 15 0   1     0   1   33 24                       57 1 39 15 0   1     0   1   33 24                 57
940627 940627 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes 1 PK 06 2016   grade_6 1 50 33 0   3     0   1   43 45                       88 1 50 33 0   3     0   1   43 45                 88
933073 933073 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No 1 PK 08 2016   grade_6 11 11 24 0   2     0   5   30 23                       53 11 11 24 0   2     0   5   30 23                 53
933841 933841 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No 2 05 08 2016   grade_6 172 4 1 2   6     0   2   90 97                       187 172 4 1 2   6     0   2   90 97                 187
937285 937285 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No 1 PK 07 2016   grade_6 20 1 0 0   0     0   2   12 11                       23 20 1 0 0   0     0   2   12 11                 23
936359 936359 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No 2 06 08 2016   grade_6 67 46 254 5   59     0   17   225 223                       448 67 46 254 5   59     0   17   225 223                 448
933925 933925 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No 1 PK 06 2016   grade_6 39 0 0 0   0     0   0   17 22                       39 39 0 0 0   0     0   0   17 22                 39
932981 932981 MA Essex   school 2502640 30   Beverly 250264000165 300305 Briscoe Middle   Regular School No 2 06 08 2016   grade_6 281 13 30 0   9     0   12   201 144                       345 281 13 30 0   9     0   12   201 144                 345
937943 937943 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Broad Meadows Middle   Regular School No 2 06 08 2016   grade_6 80 6 7 0   18     0   3   69 45                       114 80 6 7 0   18     0   3   69 45                 114
935397 935397 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2016   grade_6 76 2 5 0   14     0   1   46 52                       98 76 2 5 0   14     0   1   46 52                 98
940525 940525 MA Suffolk   school 2500539 457   Brooke Charter School East Boston (District) 250053902720 4570205 Brooke Charter School East Boston   Regular School Yes 1 KG 08 2016   grade_6 4 10 29 2   2     0   2   28 21                       49 4 10 29 2   2     0   2   28 21                 49
940412 940412 MA Suffolk   school 2500528 443   Brooke Charter School Mattapan (District) 250052802711 4430205 Brooke Charter School Mattapan   Regular School Yes 1 KG 08 2016   grade_6 1 37 8 1   0     0   0   26 21                       47 1 37 8 1   0     0   0   26 21                 47
940314 940314 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School Roslindale   Regular School Yes 1 KG 08 2016   grade_6 2 33 14 0   0     0   4   26 27                       53 2 33 14 0   0     0   4   26 27                 53
934044 934044 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No 1 PK 06 2016   grade_6 44 0 1 0   0     0   2   25 22                       47 44 0 1 0   0     0   2   25 22                 47
937688 937688 MA Plymouth   school 2509420 231   Pembroke 250942001508 2310003 Bryantville Elementary   Regular School No 1 KG 06 2016   grade_6 82 0 0 0   1     0   1   39 45                       84 82 0 0 0   1     0   1   39 45                 84
941352 941352 MA Franklin   school 2507990 717   Mohawk Trail 250799000424 7170005 Buckland-Shelburne Regional   Regular School No 1 PK 06 2016   grade_6 28 0 1 0   0     0   0   11 18                       29 28 0 1 0   0     0   0   11 18                 29
938917 938917 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No 1 PK 06 2016   grade_6 119 1 10 0   5     0   10   77 68                       145 119 1 10 0   5     0   10   77 68                 145
939938 939938 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No 1 KG 06 2016   grade_6 3 1 18 0   1     0   1   13 11                       24 3 1 18 0   1     0   1   13 11                 24
940783 940783 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No 1 KG 06 2016   grade_6 48 0 1 0   12     0   13   43 31                       74 48 0 1 0   12     0   13   43 31                 74
935438 935438 MA Essex   school 2505970 128   Haverhill 250597000848 1280035 Caleb Dustin Hunking   Regular School No 2 06 08 2016   grade_6 104 6 18 0   1     1   1   61 70                       131 104 6 18 0   1     1   1   61 70                 131
934249 934249 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge Street Upper School   Regular School No 2 06 08 2016   grade_6 18 27 19 1   7     1   7   42 38                       80 18 27 19 1   7     1   7   42 38                 80
935141 935141 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No 2 06 08 2016   grade_6 118 13 34 1   4     0   6   91 85                       176 118 13 34 1   4     0   6   91 85                 176
939946 939946 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No 1 PK 06 2016   grade_6 7 6 18 0   15     0   2   17 31                       48 7 6 18 0   15     0   2   17 31                 48
940339 940339 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes 2 06 08 2016   grade_6 70 1 4 0   0     0   5   32 48                       80 70 1 4 0   0     0   5   32 48                 80
934299 934299 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No 1 PK 08 2016   grade_6 53 2 4 0   8     0   8   41 34                       75 53 2 4 0   8     0   8   41 34                 75
934309 934309 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No 4 06 12 2016   grade_6 108 2 4 0   1     0   0   69 46                       115 108 2 4 0   1     0   0   69 46                 115
937946 937946 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No 2 06 08 2016   grade_6 108 5 5 0   90     2   5   120 95                       215 108 5 5 0   90     2   5   120 95                 215
941784 941784 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No 2 06 08 2016   grade_6 105 1 4 0   0     0   5   65 50                       115 105 1 4 0   0     0   5   65 50                 115
939953 939953 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No 1 KG 06 2016   grade_6 3 10 36 0   1     0   0   25 25                       50 3 10 36 0   1     0   0   25 25                 50
939961 939961 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No 1 PK 06 2016   grade_6 5 0 68 0   3     0   0   37 39                       76 5 0 68 0   3     0   0   37 39                 76
937236 937236 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Charles E Brown Middle   Regular School No 2 06 08 2016   grade_6 168 13 21 0   66     0   16   160 124                       284 168 13 21 0   66     0   16   160 124                 284
940217 940217 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Charles E Roderick   Regular School No 2 04 06 2016   grade_6 150 3 4 0   1     0   3   95 66                       161 150 3 4 0   1     0   3   95 66                 161
936862 936862 MA Norfolk   school 2507980 189   Milton 250798001257 1890410 Charles S Pierce Middle   Regular School No 2 06 08 2016   grade_6 253 34 16 0   16     1   8   173 155                       328 253 34 16 0   16     1   8   173 155                 328
941079 941079 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Charlton Middle School   Regular School No 2 05 08 2016   grade_6 165 3 4 0   3     0   2   97 80                       177 165 3 4 0   3     0   2   97 80                 177
938788 938788 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Accelerated Middle School (North)   Regular School No 2 06 08 2016   grade_6 3 14 74 0   0     0   0   49 42                       91 3 14 74 0   0     0   0   49 42                 91
938791 938791 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Chestnut Accelerated Middle School (South)   Regular School No 2 06 08 2016   grade_6 3 10 96 0   1     0   0   60 50                       110 3 10 96 0   1     0   0   60 50                 110
938794 938794 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No 2 06 08 2016   grade_6 19 22 67 1   2     0   1   56 56                       112 19 22 67 1   2     0   1   56 56                 112
932870 932870 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Chestnut Hill Community School   Regular School No 2 04 06 2016   grade_6 173 2 5 0   2     1   4   96 91                       187 173 2 5 0   2     1   4   96 91                 187
941788 941788 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No 2 05 08 2016   grade_6 92 3 3 0   2     0   0   56 44                       100 92 3 3 0   2     0   0   56 44                 100
940281 940281 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public School   Regular School Yes 2 06 08 2016   grade_6 98 6 17 0   5     0   8   71 63                       134 98 6 17 0   5     0   8   71 63                 134
939969 939969 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No 1 PK 06 2016   grade_6 11 8 36 0   1     0   5   35 26                       61 11 8 36 0   1     0   5   35 26                 61
933651 933651 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No 2 06 08 2016   grade_6 10 14 79 0   10     0   2   62 53                       115 10 14 79 0   10     0   2   62 53                 115
934373 934373 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No 2 05 08 2016   grade_6 2 2 121 0   2     0   1   70 58                       128 2 2 121 0   2     0   1   70 58                 128
939977 939977 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No 1 PK 06 2016   grade_6 3 4 14 0   1     0   3   13 12                       25 3 4 14 0   1     0   3   13 12                 25
934466 934466 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No 1 KG 08 2016   grade_6 16 0 1 0   1     0   1   10 9                       19 16 0 1 0   1     0   1   10 9                 19
934476 934476 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No 2 04 08 2016   grade_6 83 6 26 0   1     0   4   63 57                       120 83 6 26 0   1     0   4   63 57                 120

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