enrollments

Data source: Big Local News · About: Big Local

887 rows where grade = "grade_5", state = "MA" and year = 2016 sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 887 ✖

grade ✖

  • grade_5 · 887 ✖
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
936517 936517 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No 2 05 08 2016   grade_5 180 12 162 0   17     0   10   202 179                       381 180 12 162 0   17     0   10   202 179                 381
936264 936264 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No 1 KG 05 2016   grade_5 4 3 45 0   17     0   0   41 28                       69 4 3 45 0   17     0   0   41 28                 69
937147 937147 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No 1 KG 05 2016   grade_5 51 4 5 0   12     0   2   36 38                       74 51 4 5 0   12     0   2   36 38                 74
940935 940935 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No 1 03 05 2016   grade_5 87 2 5 0   0     0   4   45 53                       98 87 2 5 0   0     0   4   45 53                 98
938044 938044 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No 1 KG 05 2016   grade_5 81 4 44 1   9     0   1   69 71                       140 81 4 44 1   9     0   1   69 71                 140
939536 939536 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No 1 03 05 2016   grade_5 122 0 0 0   30     0   5   89 68                       157 122 0 0 0   30     0   5   89 68                 157
935063 935063 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2016   grade_5 * * * *   *     *   *   2 1                       3                         2 1                 3
940430 940430 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_5 30 57 30 0   3     0   6   64 62                       126 30 57 30 0   3     0   6   64 62                 126
939725 939725 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No 2 05 06 2016   grade_5 378 25 36 2   17     1   15   245 229                       474 378 25 36 2   17     1   15   245 229                 474
939488 939488 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No 1 KG 05 2016   grade_5 32 0 7 0   3     0   0   20 22                       42 32 0 7 0   3     0   0   20 22                 42
936258 936258 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No 1 KG 05 2016   grade_5 14 2 18 0   0     0   2   19 17                       36 14 2 18 0   0     0   2   19 17                 36
937052 937052 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No 1 KG 05 2016   grade_5 55 9 22 1   1     0   12   50 50                       100 55 9 22 1   1     0   12   50 50                 100
938061 938061 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No 1 PK 05 2016   grade_5 40 6 40 0   1     0   2   37 52                       89 40 6 40 0   1     0   2   37 52                 89
940247 940247 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_5 4 39 24 0   0     0   7   35 39                       74 4 39 24 0   0     0   7   35 39                 74
932557 932557 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No 2 05 08 2016   grade_5 115 0 1 0   0     0   0   62 54                       116 115 0 1 0   0     0   0   62 54                 116
938445 938445 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No 1 PK 08 2016   grade_5 25 3 29 0   9     0   0   36 30                       66 25 3 29 0   9     0   0   36 30                 66
934504 934504 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Alcott   Regular School No 1 PK 05 2016   grade_5 58 6 2 0   4     0   1   38 33                       71 58 6 2 0   4     0   1   38 33                 71
934687 934687 MA Plymouth   school 2504410 82   Duxbury 250441000968 820004 Alden School   Regular School No 1 03 05 2016   grade_5 230 0 3 0   2     0   9   137 107                       244 230 0 3 0   2     0   9   137 107                 244
935755 935755 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No 1 03 08 2016   grade_5 8 0 93 0   3     0   0   47 57                       104 8 0 93 0   3     0   0   47 57                 104
938654 938654 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No 1 PK 08 2016   grade_5 11 9 14 0   0     0   1   15 20                       35 11 9 14 0   0     0   1   15 20                 35
937028 937028 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 Alfred J Gomes   Regular School No 1 PK 05 2016   grade_5 21 20 51 1   0     0   3   40 56                       96 21 20 51 1   0     0   3   40 56                 96
938726 938726 MA Hampden   school 2511130 281   Springfield 251113001792 2810175 Alice B Beal Elementary   Regular School No 1 KG 05 2016   grade_5 9 9 22 0   2     0   1   22 21                       43 9 9 22 0   2     0   1   22 21                 43
938004 938004 MA Middlesex   school 2509990 246   Reading 250999001604 2460002 Alice M Barrows   Regular School No 1 KG 05 2016   grade_5 58 0 2 0   2     0   0   28 34                       62 58 0 2 0   2     0   0   28 34                 62
937723 937723 MA Berkshire   school 2509630 236   Pittsfield 250963001516 2360010 Allendale   Regular School No 1 KG 05 2016   grade_5 37 7 4 0   1     0   6   25 30                       55 37 7 4 0   1     0   6   25 30                 55
940233 940233 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_5 12 7 18 0   0     0   3   19 21                       40 12 7 18 0   0     0   3   19 21                 40
939825 939825 MA Middlesex   school 2513110 344   Winchester 251311002164 3440045 Ambrose Elementary   Regular School No 1 KG 05 2016   grade_5 84 0 2 0   1     0   3   49 41                       90 84 0 2 0   1     0   3   49 41                 90
932604 932604 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No 2 05 08 2016   grade_5 149 1 8 0   0     0   8   85 81                       166 149 1 8 0   0     0   8   85 81                 166
934175 934175 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No 1 PK 08 2016   grade_5 15 2 14 0   1     0   6   13 25                       38 15 2 14 0   1     0   6   13 25                 38
937368 937368 MA Bristol   school 2508730 212   North Attleborough 250873001401 2120007 Amvet Boulevard   Regular School No 1 KG 05 2016   grade_5 68 1 2 0   4     0   4   44 35                       79 68 1 2 0   4     0   4   44 35                 79
939745 939745 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No 1 PK 06 2016   grade_5 26 0 0 0   0     0   0   16 10                       26 26 0 0 0   0     0   0   16 10                 26
937349 937349 MA Essex   school 2508700 211   North Andover 250870000767 2110018 Annie L Sargent School   Regular School No 1 KG 05 2016   grade_5 77 0 1 1   2     0   4   41 44                       85 77 0 1 1   2     0   4   41 44                 85
933892 933892 MA Norfolk   school 2502940 40   Braintree 250294000360 400033 Archie T Morrison   Regular School No 1 KG 05 2016   grade_5 48 9 0 0   8     0   2   35 32                       67 48 9 0 0   8     0   2   35 32                 67
935759 935759 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No 2 05 08 2016   grade_5 3 2 121 0   0     0   0   64 62                       126 3 2 121 0   0     0   0   64 62                 126
938425 938425 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No 1 PK 08 2016   grade_5 16 6 13 0   7     0   2   23 21                       44 16 6 13 0   7     0   2   23 21                 44
935033 935033 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No 2 05 08 2016   grade_5 49 10 97 0   10     0   11   95 82                       177 49 10 97 0   10     0   11   95 82                 177
938720 938720 MA Hampden   school 2511130 281   Springfield 251113001795 2810165 Arthur T Talmadge   Regular School No 1 KG 05 2016   grade_5 8 13 20 0   0     0   0   24 17                       41 8 13 20 0   0     0   0   24 17                 41
939839 939839 MA Suffolk   school 2513170 346   Winthrop 251317001841 3460020 Arthur T. Cummings Elementary School   Regular School No 2 04 07 2016   grade_5 127 0 11 0   1     0   1   72 68                       140 127 0 11 0   1     0   1   72 68                 140
937897 937897 MA Norfolk   school 2509870 243   Quincy 250987001560 2430040 Atherton Hough   Regular School No 1 KG 05 2016   grade_5 47 2 3 1   5     0   2   29 31                       60 47 2 3 1   5     0   2   29 31                 60
940871 940871 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No 2 05 08 2016   grade_5 69 0 8 0   0     0   3   42 38                       80 69 0 8 0   0     0   3   42 38                 80
937331 937331 MA Essex   school 2508700 211   North Andover 250870001393 2110001 Atkinson   Regular School No 1 PK 05 2016   grade_5 37 4 17 0   6     0   0   37 27                       64 37 4 17 0   6     0   0   37 27                 64
940701 940701 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 10 2016   grade_5 81 5 7 0   4     0   3   53 47                       100 81 5 7 0   4     0   3   53 47                 100
934600 934600 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No 1 01 05 2016   grade_5 37 10 16 0   2     0   5   31 39                       70 37 10 16 0   2     0   5   31 39                 70
932980 932980 MA Essex   school 2502640 30   Beverly 250264000175 300055 Ayers/Ryal Side School   Regular School No 1 KG 05 2016   grade_5 69 2 7 0   3     0   3   40 44                       84 69 2 7 0   3     0   3   40 44                 84
936178 936178 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 B.F.Butler Middle School   Regular School No 2 05 08 2016   grade_5 40 8 34 0   34     0   6   70 52                       122 40 8 34 0   34     0   6   70 52                 122
937527 937527 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No 1 01 05 2016   grade_5 19 12 16 0   2     0   0   25 24                       49 19 12 16 0   2     0   0   25 24                 49
932642 932642 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No 1 KG 05 2016   grade_5 104 0 3 1   15     0   4   65 62                       127 104 0 3 1   15     0   4   65 62                 127
935116 935116 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No 1 KG 05 2016   grade_5 29 6 71 0   1     0   2   51 58                       109 29 6 71 0   1     0   2   51 58                 109
932843 932843 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable United Elementary School   Regular School No 2 04 05 2016   grade_5 279 22 34 2   5     1   24   176 191                       367 279 22 34 2   5     1   24   176 191                 367
934391 934391 MA Hampden   school 2503660 61   Chicopee 250366000489 610003 Barry   Regular School No 1 KG 05 2016   grade_5 57 3 19 0   1     0   0   42 38                       80 57 3 19 0   1     0   0   42 38                 80
936174 936174 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No 1 PK 08 2016   grade_5 10 6 23 0   16     0   2   23 34                       57 10 6 23 0   16     0   2   23 34                 57
938162 938162 MA Essex   school 2510380 258   Salem 251038001653 2580003 Bates   Regular School No 1 KG 05 2016   grade_5 24 4 15 0   0     0   0   25 18                       43 24 4 15 0   0     0   0   25 18                 43
938051 938051 MA Suffolk   school 2510050 248   Revere 251005001962 2480013 Beachmont Veterans Memorial School   Regular School No 1 PK 05 2016   grade_5 21 1 20 0   0     0   1   18 25                       43 21 1 20 0   0     0   1   18 25                 43
937785 937785 MA Norfolk   school 2509690 238   Plainville 250969001538 2380005 Beatrice H Wood Elementary   Regular School No 2 04 06 2016   grade_5 88 1 4 0   3     0   4   56 44                       100 88 1 4 0   3     0   4   56 44                 100
940982 940982 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Becket Washington School   Regular School No 1 PK 05 2016   grade_5 14 0 1 0   0     0   0   7 8                       15 14 0 1 0   0     0   0   7 8                 15
936410 936410 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No 1 KG 08 2016   grade_5 24 12 14 1   39     0   2   42 50                       92 24 12 14 1   39     0   2   42 50                 92
937880 937880 MA Norfolk   school 2509870 243   Quincy 250987000772 2430020 Beechwood Knoll Elementary   Regular School No 1 KG 05 2016   grade_5 35 0 1 0   20     0   2   30 28                       58 35 0 1 0   20     0   2   30 28                 58
935243 935243 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No 1 KG 05 2016   grade_5 39 1 4 0   1     0   8   33 20                       53 39 1 4 0   1     0   8   33 20                 53
932891 932891 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial School   Regular School No 2 04 07 2016   grade_5 153 3 7 0   7     0   1   81 90                       171 153 3 7 0   7     0   1   81 90                 171
939915 939915 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No 1 PK 06 2016   grade_5 9 17 40 0   6     0   2   32 42                       74 9 17 40 0   6     0   2   32 42                 74
940292 940292 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_5 0 26 9 1   1     0   2   19 20                       39 0 26 9 1   1     0   2   19 20                 39
940456 940456 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_5 33 0 3 0   10     0   5   28 23                       51 33 0 3 0   10     0   5   28 23                 51
939054 939054 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Benjamin Friedman Middle   Regular School No 2 05 07 2016   grade_5 183 21 29 2   1     1   16   132 121                       253 183 21 29 2   1     1   16   132 121                 253
938417 938417 MA Middlesex   school 2510890 274   Somerville 251089001732 2740015 Benjamin G Brown   Regular School No 1 KG 06 2016   grade_5 23 0 7 0   2     0   2   17 17                       34 23 0 7 0   2     0   2   17 17                 34
942008 942008 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes 1 KG 05 2016   grade_5 12 3 13 0   1     0   0   14 15                       29 12 3 13 0   1     0   0   14 15                 29
932939 932939 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No 2 05 08 2016   grade_5 88 1 0 0   0     0   2   45 46                       91 88 1 0 0   0     0   2   45 46                 91
932949 932949 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No 1 PK 05 2016   grade_5 24 0 1 0   0     0   0   14 11                       25 24 0 1 0   0     0   0   14 11                 25
941520 941520 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Bernardston Elementary   Regular School No 1 PK 06 2016   grade_5 19 0 0 0   0     0   6   13 12                       25 19 0 0 0   0     0   6   13 12                 25
941195 941195 MA Essex   school 2505670 675   Hamilton-Wenham 250567001459 6750007 Bessie Buker Elementary   Regular School No 1 KG 05 2016   grade_5 38 0 1 0   1     0   1   24 17                       41 38 0 1 0   1     0   1   24 17                 41
937103 937103 MA Bristol   school 2508430 201   New Bedford 250843001319 2010140 Betsey B Winslow   Regular School No 1 KG 05 2016   grade_5 32 3 5 0   2     0   0   15 27                       42 32 3 5 0   2     0   0   15 27                 42
938010 938010 MA Middlesex   school 2509990 246   Reading 250999001606 2460005 Birch Meadow   Regular School No 1 KG 05 2016   grade_5 66 0 0 0   1     0   1   36 32                       68 66 0 0 0   1     0   1   36 32                 68
933641 933641 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No 1 PK 05 2016   grade_5 3 6 61 0   1     0   0   34 37                       71 3 6 61 0   1     0   0   34 37                 71
940760 940760 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No 1 PK 06 2016   grade_5 41 3 2 0   20     0   0   34 32                       66 41 3 2 0   20     0   0   34 32                 66
936052 936052 MA Hampden   school 2506990 159   Longmeadow 250699001016 1590005 Blueberry Hill   Regular School No 1 KG 05 2016   grade_5 66 0 4 0   11     0   1   51 31                       82 66 0 4 0   11     0   1   51 31                 82
940460 940460 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes 4 05 12 2016   grade_5 50 24 23 0   1     0   2   59 41                       100 50 24 23 0   1     0   2   59 41                 100
940626 940626 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_5 0 68 18 0   0     0   1   48 39                       87 0 68 18 0   0     0   1   48 39                 87
933072 933072 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No 1 PK 08 2016   grade_5 5 11 11 0   0     0   0   16 11                       27 5 11 11 0   0     0   0   16 11                 27
933840 933840 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No 2 05 08 2016   grade_5 148 0 2 0   6     0   8   71 93                       164 148 0 2 0   6     0   8   71 93                 164
934401 934401 MA Hampden   school 2503660 61   Chicopee 250366000492 610015 Bowe   Regular School No 1 PK 05 2016   grade_5 20 3 38 0   0     0   3   38 26                       64 20 3 38 0   0     0   3   38 26                 64
937153 937153 MA Middlesex   school 2508610 207   Newton 250861001358 2070015 Bowen   Regular School No 1 KG 05 2016   grade_5 44 5 4 0   23     0   6   39 43                       82 44 5 4 0   23     0   6   39 43                 82
934407 934407 MA Hampden   school 2503660 61   Chicopee 250366000493 610020 Bowie   Regular School No 1 KG 05 2016   grade_5 42 1 14 0   0     0   2   25 34                       59 42 1 14 0   0     0   2   25 34                 59
935978 935978 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Bowman   Regular School No 1 KG 05 2016   grade_5 44 7 3 0   36     0   4   50 44                       94 44 7 3 0   36     0   4   50 44                 94
939190 939190 MA Norfolk   school 2511970 307   Walpole 251197002563 3070010 Boyden   Regular School No 1 KG 05 2016   grade_5 67 0 3 0   3     0   0   42 31                       73 67 0 3 0   3     0   0   42 31                 73
933862 933862 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No 1 PK 05 2016   grade_5 55 1 1 0   2     0   0   34 25                       59 55 1 1 0   2     0   0   34 25                 59
932693 932693 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No 1 KG 05 2016   grade_5 70 1 7 0   5     0   8   45 46                       91 70 1 7 0   5     0   8   45 46                 91
935424 935424 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Bradford Elementary   Regular School No 1 KG 05 2016   grade_5 109 7 25 0   3     0   2   79 67                       146 109 7 25 0   3     0   2   79 67                 146
937284 937284 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No 1 PK 07 2016   grade_5 38 1 1 0   1     0   2   19 24                       43 38 1 1 0   1     0   2   19 24                 43
936269 936269 MA Essex   school 2507110 163   Lynn 250711001064 1630020 Brickett Elementary   Regular School No 1 01 05 2016   grade_5 7 2 26 1   6     0   5   24 23                       47 7 2 26 1   6     0   5   24 23                 47
935972 935972 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Bridge   Regular School No 1 KG 05 2016   grade_5 47 8 2 0   45     0   1   50 53                       103 47 8 2 0   45     0   1   50 53                 103
937299 937299 MA Hampshire   school 2508850 210   Northampton 250885001425 2100005 Bridge Street   Regular School No 1 PK 05 2016   grade_5 24 1 11 0   3     0   0   21 18                       39 24 1 11 0   3     0   0   21 18                 39
940844 940844 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002368 6100025 Briggs Elementary   Regular School No 1 PK 05 2016   grade_5 89 0 2 0   0     0   3   44 50                       94 89 0 2 0   0     0   3   44 50                 94
938581 938581 MA Hampden   school 2511130 281   Springfield 251113001796 2810025 Brightwood   Regular School No 1 KG 05 2016   grade_5 0 8 33 0   0     0   0   10 31                       41 0 8 33 0   0     0   0   10 31                 41
933924 933924 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No 1 PK 06 2016   grade_5 29 0 0 0   0     0   0   14 15                       29 29 0 0 0   0     0   0   14 15                 29
936950 936950 MA Norfolk   school 2508370 199   Needham 250837001306 1990005 Broadmeadow   Regular School No 1 KG 05 2016   grade_5 71 3 3 0   7     0   8   46 46                       92 71 3 3 0   7     0   8   46 46                 92
940524 940524 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_5 11 18 29 0   1     0   1   33 27                       60 11 18 29 0   1     0   1   33 27                 60
940411 940411 MA Suffolk   school 2500528 443   Brooke Charter School Mattapan (District) 250052802711 4430205 Brooke Charter School Mattapan   Regular School Yes 1 KG 08 2016   grade_5 2 49 14 0   1     0   1   34 33                       67 2 49 14 0   1     0   1   34 33                 67
940313 940313 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School Roslindale   Regular School Yes 1 KG 08 2016   grade_5 2 41 16 0   1     0   4   32 32                       64 2 41 16 0   1     0   4   32 32                 64
933950 933950 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brookfield   Regular School No 1 KG 05 2016   grade_5 39 61 8 0   1     0   3   61 51                       112 39 61 8 0   1     0   3   61 51                 112
934043 934043 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No 1 PK 06 2016   grade_5 44 0 4 0   0     0   2   26 24                       50 44 0 4 0   0     0   2   26 24                 50
936628 936628 MA Middlesex   school 2507560 176   Medford 250756002049 1760130 Brooks School   Regular School No 1 PK 05 2016   grade_5 73 10 9 0   6     0   3   52 49                       101 73 10 9 0   6     0   3   52 49                 101
934670 934670 MA Middlesex   school 2504320 79   Dracut 250432000578 790035 Brookside Elementary   Regular School No 1 KG 05 2016   grade_5 55 6 8 0   10     0   0   47 32                       79 55 6 8 0   10     0   0   47 32                 79

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