enrollments

Data source: Big Local News · About: Big Local

878 rows where grade = "grade_5", state = "MA" and year = 2019 sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 878 ✖

grade ✖

  • grade_5 · 878 ✖
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
2043813 2043813 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2019   grade_5 152 12 210 1   15     0   12   219 183                       402.0 152 12 210 1   15     0   12   219 183                 402
2043560 2043560 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary KG 05 2019   grade_5 6 13 78 0   15     0   1   57 56                       113.0 6 13 78 0   15     0   1   57 56                 113
2044448 2044448 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2019   grade_5 56 2 1 0   13     0   2   37 37                       74.0 56 2 1 0   13     0   2   37 37                 74
2048222 2048222 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No Elementary 03 05 2019   grade_5 86 3 9 0   2     0   5   50 55                       105.0 86 3 9 0   2     0   5   50 55                 105
2045345 2045345 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2019   grade_5 70 2 57 0   3     0   1   68 64                       133.0 70 2 57 0   3     0   1   68 64                 133
2046840 2046840 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No Elementary 03 05 2019   grade_5 84 0 2 1   28     0   2   47 70                       117.0 84 0 2 1   28     0   2   47 70                 117
2042367 2042367 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_5 10 0 0 0   0     0   0   6 4                       10.0 10 0 0 0   0     0   0   6 4                 10
2047735 2047735 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 2019   grade_5 14 78 22 0   4     0   0   52 66                       118.0 14 78 22 0   4     0   0   52 66                 118
2047027 2047027 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No Middle 05 06 2019   grade_5 319 30 50 1   33     0   21   240 214                       454.0 319 30 50 1   33     0   21   240 214                 454
2039816 2039816 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2019   grade_5 134 4 14 2   4     0   1   85 74                       159.0 134 4 14 2   4     0   1   85 74                 159
2043554 2043554 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2019   grade_5 17 6 17 1   3     0   2   24 22                       46.0 17 6 17 1   3     0   2   24 22                 46
2044348 2044348 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2019   grade_5 67 10 33 0   1     0   4   60 55                       115.0 67 10 33 0   1     0   4   60 55                 115
2045362 2045362 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2019   grade_5 41 7 55 0   4     0   2   53 56                       109.0 41 7 55 0   4     0   2   53 56                 109
2047541 2047541 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 2019   grade_5 8 49 14 0   0     0   1   46 26                       72.0 8 49 14 0   0     0   1   46 26                 72
2039831 2039831 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2019   grade_5 97 1 3 0   1     0   0   60 42                       102.0 97 1 3 0   1     0   0   60 42                 102
2045748 2045748 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2019   grade_5 26 2 15 0   4     0   1   24 24                       48.0 26 2 15 0   4     0   1   24 24                 48
2041796 2041796 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Alcott   Regular School No Elementary PK 05 2019   grade_5 55 10 7 0   5     0   3   38 42                       80.0 55 10 7 0   5     0   3   38 42                 80
2041981 2041981 MA Plymouth   school 2504410 82   Duxbury 250441000968 820004 Alden School   Regular School No Elementary 03 05 2019   grade_5 215 1 7 0   2     0   4   125 104                       229.0 215 1 7 0   2     0   4   125 104                 229
2043063 2043063 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Middle 03 08 2019   grade_5 2 1 91 0   2     0   0   47 49                       96.0 2 1 91 0   2     0   0   47 49                 96
2045958 2045958 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2019   grade_5 6 7 27 0   0     0   0   19 21                       40.0 6 7 27 0   0     0   0   19 21                 40
2044321 2044321 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 Alfred J Gomes   Regular School No Elementary KG 05 2019   grade_5 8 16 51 0   1     0   2   40 38                       78.0 8 16 51 0   1     0   2   40 38                 78
2046032 2046032 MA Hampden   school 2511130 281   Springfield 251113001792 2810175 Alice B Beal Elementary   Regular School No Elementary KG 05 2019   grade_5 9 4 26 0   3     0   1   29 14                       43.0 9 4 26 0   3     0   1   29 14                 43
2045305 2045305 MA Middlesex   school 2509990 246   Reading 250999001604 2460002 Alice M Barrows   Regular School No Elementary KG 05 2019   grade_5 51 1 0 0   5     0   1   33 25                       58.0 51 1 0 0   5     0   1   33 25                 58
2045024 2045024 MA Berkshire   school 2509630 236   Pittsfield 250963001516 2360010 Allendale   Regular School No Elementary KG 05 2019   grade_5 25 6 10 0   0     0   3   20 24                       44.0 25 6 10 0   0     0   3   20 24                 44
2047521 2047521 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 08 2019   grade_5 16 7 27 0   0     0   0   17 33                       50.0 16 7 27 0   0     0   0   17 33                 50
2047120 2047120 MA Middlesex   school 2513110 344   Winchester 251311002164 3440045 Ambrose Elementary   Regular School No Elementary KG 05 2019   grade_5 70 0 2 0   1     0   2   41 34                       75.0 70 0 2 0   1     0   2   41 34                 75
2039877 2039877 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2019   grade_5 133 4 15 0   2     0   8   94 68                       162.0 133 4 15 0   2     0   8   94 68                 162
2041463 2041463 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2019   grade_5 13 4 19 0   2     0   5   24 19                       43.0 13 4 19 0   2     0   5   24 19                 43
2044667 2044667 MA Bristol   school 2508730 212   North Attleborough 250873001401 2120007 Amvet Boulevard   Regular School No Elementary KG 05 2019   grade_5 54 3 7 2   4     0   2   31 41                       72.0 54 3 7 2   4     0   2   31 41                 72
2047048 2047048 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No Elementary PK 06 2019   grade_5 19 0 0 0   1     0   0   11 9                       20.0 19 0 0 0   1     0   0   11 9                 20
2044649 2044649 MA Essex   school 2508700 211   North Andover 250870000767 2110018 Annie L Sargent School   Regular School No Elementary 01 05 2019   grade_5 74 1 7 0   8     0   4   40 54                       94.0 74 1 7 0   8     0   4   40 54                 94
2041175 2041175 MA Norfolk   school 2502940 40   Braintree 250294000360 400033 Archie T Morrison   Regular School No Elementary KG 05 2019   grade_5 75 8 4 0   18     1   1   52 55                       107.0 75 8 4 0   18     1   1   52 55                 107
2043067 2043067 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2019   grade_5 4 0 133 1   0     0   0   65 72                       138.0 4 0 133 1   0     0   0   65 72                 138
2045729 2045729 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No Elementary PK 08 2019   grade_5 13 7 22 0   1     0   3   26 20                       46.0 13 7 22 0   1     0   3   26 20                 46
2042336 2042336 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No Middle 05 08 2019   grade_5 53 20 88 0   8     0   15   95 89                       184.0 53 20 88 0   8     0   15   95 89                 184
2046026 2046026 MA Hampden   school 2511130 281   Springfield 251113001795 2810165 Arthur T Talmadge   Regular School No Elementary KG 05 2019   grade_5 8 13 21 0   0     0   0   20 22                       42.0 8 13 21 0   0     0   0   20 22                 42
2047134 2047134 MA Suffolk   school 2513170 346   Winthrop 251317001841 3460020 Arthur T. Cummings Elementary School   Regular School No Elementary 03 05 2019   grade_5 128 3 30 1   1     0   3   87 79                       166.0 128 3 30 1   1     0   3   87 79                 166
2045197 2045197 MA Norfolk   school 2509870 243   Quincy 250987001560 2430040 Atherton Hough   Regular School No Elementary KG 05 2019   grade_5 35 2 4 0   2     0   2   24 21                       45.0 35 2 4 0   2     0   2   24 21                 45
2048158 2048158 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No Middle 05 08 2019   grade_5 89 0 10 0   0     0   2   61 40                       101.0 89 0 10 0   0     0   2   61 40                 101
2044632 2044632 MA Essex   school 2508700 211   North Andover 250870001393 2110001 Atkinson   Regular School No Elementary 01 05 2019   grade_5 41 7 15 1   9     0   4   37 40                       77.0 41 7 15 1   9     0   4   37 40                 77
2047989 2047989 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2019   grade_5 93 2 13 0   2     0   0   49 61                       110.0 93 2 13 0   2     0   0   49 61                 110
2041894 2041894 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No Elementary 01 05 2019   grade_5 39 5 16 0   1     0   5   35 31                       66.0 39 5 16 0   1     0   5   35 31                 66
2043466 2043466 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 B.F. Butler Middle School   Regular School No Middle 05 08 2019   grade_5 33 6 54 0   46     0   14   79 74                       153.0 33 6 54 0   46     0   14   79 74                 153
2044827 2044827 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No Elementary 01 05 2019   grade_5 32 4 14 0   2     0   2   29 25                       54.0 32 4 14 0   2     0   2   29 25                 54
2039917 2039917 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2019   grade_5 80 4 11 0   8     0   7   54 56                       110.0 80 4 11 0   8     0   7   54 56                 110
2042425 2042425 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2019   grade_5 25 3 63 1   2     0   1   48 47                       95.0 25 3 63 1   2     0   1   48 47                 95
2040119 2040119 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable United Elementary School   Regular School No Elementary 04 05 2019   grade_5 279 24 65 4   8     1   15   209 187                       396.0 279 24 65 4   8     1   15   209 187                 396
2041686 2041686 MA Hampden   school 2503660 61   Chicopee 250366000489 610003 Barry   Regular School No Elementary KG 05 2019   grade_5 49 4 23 0   3     1   2   48 34                       82.0 49 4 23 0   3     1   2   48 34                 82
2043462 2043462 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No Elementary PK 08 2019   grade_5 10 2 17 0   19     0   4   26 26                       52.0 10 2 17 0   19     0   4   26 26                 52
2045468 2045468 MA Essex   school 2510380 258   Salem 251038001653 2580003 Bates   Regular School No Elementary KG 05 2019   grade_5 25 8 30 0   0     0   4   31 36                       67.0 25 8 30 0   0     0   4   31 36                 67
2045352 2045352 MA Suffolk   school 2510050 248   Revere 251005001962 2480013 Beachmont Veterans Memorial School   Regular School No Elementary PK 05 2019   grade_5 18 3 26 0   3     0   0   25 25                       50.0 18 3 26 0   3     0   0   25 25                 50
2045087 2045087 MA Norfolk   school 2509690 238   Plainville 250969001538 2380005 Beatrice H Wood Elementary   Regular School No Middle 04 06 2019   grade_5 84 2 11 1   5     0   4   52 55                       107.0 84 2 11 1   5     0   4   52 55                 107
2048272 2048272 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Becket Washington School   Regular School No Elementary PK 05 2019   grade_5 21 0 0 0   0     0   0   11 10                       21.0 21 0 0 0   0     0   0   11 10                 21
2043706 2043706 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2019   grade_5 27 14 14 0   33     0   3   43 48                       91.0 27 14 14 0   33     0   3   43 48                 91
2045180 2045180 MA Norfolk   school 2509870 243   Quincy 250987000772 2430020 Beechwood Knoll Elementary   Regular School No Elementary KG 05 2019   grade_5 18 0 1 0   24     0   1   29 15                       44.0 18 0 1 0   24     0   1   29 15                 44
2042552 2042552 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No Elementary KG 05 2019   grade_5 40 1 8 1   2     0   1   30 23                       53.0 40 1 8 1   2     0   1   30 23                 53
2040167 2040167 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial School   Regular School No Middle 04 07 2019   grade_5 161 5 14 0   3     0   7   81 109                       190.0 161 5 14 0   3     0   7   81 109                 190
2047203 2047203 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2019   grade_5 15 9 32 1   3     0   4   37 27                       64.0 15 9 32 1   3     0   4   37 27                 64
2047590 2047590 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2019   grade_5 0 38 3 0   0     0   0   22 19                       41.0 0 38 3 0   0     0   0   22 19                 41
2047761 2047761 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 2019   grade_5 35 0 3 0   10     0   4   30 22                       52.0 35 0 3 0   10     0   4   30 22                 52
2046371 2046371 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Benjamin Friedman Middle   Regular School No Middle 05 07 2019   grade_5 206 25 19 0   1     0   9   136 124                       260.0 206 25 19 0   1     0   9   136 124                 260
2045722 2045722 MA Middlesex   school 2510890 274   Somerville 251089001732 2740015 Benjamin G Brown   Regular School No Elementary KG 05 2019   grade_5 24 1 4 1   3     0   3   19 17                       36.0 24 1 4 1   3     0   3   19 17                 36
2049324 2049324 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes Elementary KG 05 2019   grade_5 11 6 20 0   0     0   2   20 19                       39.0 11 6 20 0   0     0   2   20 19                 39
2040215 2040215 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2019   grade_5 106 0 1 0   0     0   7   57 57                       114.0 106 0 1 0   0     0   7   57 57                 114
2040225 2040225 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No Elementary PK 05 2019   grade_5 26 0 2 0   1     0   0   18 11                       29.0 26 0 2 0   1     0   0   18 11                 29
2048827 2048827 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Bernardston Elementary   Regular School No Elementary PK 06 2019   grade_5 17 0 0 0   0     0   0   7 10                       17.0 17 0 0 0   0     0   0   7 10                 17
2048489 2048489 MA Essex   school 2505670 675   Hamilton-Wenham 250567001459 6750007 Bessie Buker Elementary   Regular School No Elementary KG 05 2019   grade_5 40 0 2 0   0     0   0   20 22                       42.0 40 0 2 0   0     0   0   20 22                 42
2044400 2044400 MA Bristol   school 2508430 201   New Bedford 250843001319 2010140 Betsey B Winslow   Regular School No Elementary KG 05 2019   grade_5 23 3 5 0   2     0   5   19 19                       38.0 23 3 5 0   2     0   5   19 19                 38
2040252 2040252 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly Middle School   Regular School No Middle 05 08 2019   grade_5 301 10 57 0   7     0   17   207 185                       392.0 301 10 57 0   7     0   17   207 185                 392
2045311 2045311 MA Middlesex   school 2509990 246   Reading 250999001606 2460005 Birch Meadow   Regular School No Elementary KG 05 2019   grade_5 63 0 0 0   1     0   2   37 29                       66.0 63 0 0 0   1     0   2   37 29                 66
2040921 2040921 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No Elementary PK 05 2019   grade_5 4 17 60 0   2     0   2   41 44                       85.0 4 17 60 0   2     0   2   41 44                 85
2048058 2048058 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No Elementary KG 06 2019   grade_5 30 1 2 0   18     0   1   17 35                       52.0 30 1 2 0   18     0   1   17 35                 52
2043335 2043335 MA Hampden   school 2506990 159   Longmeadow 250699001016 1590005 Blueberry Hill   Regular School No Elementary KG 05 2019   grade_5 64 0 4 0   21     2   3   41 53                       94.0 64 0 4 0   21     2   3   41 53                 94
2047765 2047765 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes High 05 12 2019   grade_5 41 28 18 0   5     0   2   47 47                       94.0 41 28 18 0   5     0   2   47 47                 94
2047911 2047911 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2019   grade_5 2 64 26 0   1     0   6   44 55                       99.0 2 64 26 0   1     0   6   44 55                 99
2040346 2040346 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2019   grade_5 12 13 10 0   0     0   1   20 16                       36.0 12 13 10 0   0     0   1   20 16                 36
2041122 2041122 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 05 08 2019   grade_5 150 2 7 4   4     0   5   81 91                       172.0 150 2 7 4   4     0   5   81 91                 172
2041695 2041695 MA Hampden   school 2503660 61   Chicopee 250366000492 610015 Bowe   Regular School No Elementary KG 05 2019   grade_5 27 5 52 0   1     0   4   41 48                       89.0 27 5 52 0   1     0   4   41 48                 89
2044454 2044454 MA Middlesex   school 2508610 207   Newton 250861001358 2070015 Bowen   Regular School No Elementary KG 05 2019   grade_5 57 7 2 0   27     0   2   52 43                       95.0 57 7 2 0   27     0   2   52 43                 95
2041701 2041701 MA Hampden   school 2503660 61   Chicopee 250366000493 610020 Bowie   Regular School No Elementary KG 05 2019   grade_5 46 2 18 0   1     0   4   37 34                       71.0 46 2 18 0   1     0   4   37 34                 71
2043261 2043261 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Bowman   Regular School No Elementary KG 05 2019   grade_5 54 9 2 0   35     0   8   60 48                       108.0 54 9 2 0   35     0   8   60 48                 108
2046508 2046508 MA Norfolk   school 2511970 307   Walpole 251197002563 3070010 Boyden   Regular School No Elementary KG 05 2019   grade_5 52 4 1 0   1     0   1   31 28                       59.0 52 4 1 0   1     0   1   31 28                 59
2041145 2041145 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No Elementary PK 05 2019   grade_5 45 1 2 0   3     0   2   25 28                       53.0 45 1 2 0   3     0   2   25 28                 53
2039968 2039968 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2019   grade_5 63 2 4 0   5     0   7   42 39                       81.0 63 2 4 0   5     0   7   42 39                 81
2044585 2044585 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No Elementary PK 06 2019   grade_5 29 3 3 0   0     0   0   16 19                       35.0 29 3 3 0   0     0   0   16 19                 35
2043566 2043566 MA Essex   school 2507110 163   Lynn 250711001064 1630020 Brickett Elementary   Regular School No Elementary KG 05 2019   grade_5 10 3 35 0   6     0   1   31 24                       55.0 10 3 35 0   6     0   1   31 24                 55
2043255 2043255 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Bridge   Regular School No Elementary KG 05 2019   grade_5 55 5 2 0   42     0   3   57 50                       107.0 55 5 2 0   42     0   3   57 50                 107
2047575 2047575 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 07 2019   grade_5 0 26 13 0   1     0   0   17 23                       40.0 0 26 13 0   1     0   0   17 23                 40
2044600 2044600 MA Hampshire   school 2508850 210   Northampton 250885001425 2100005 Bridge Street   Regular School No Elementary PK 05 2019   grade_5 17 0 9 0   1     0   3   20 10                       30.0 17 0 9 0   1     0   3   20 10                 30
2048136 2048136 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002368 6100025 Briggs Elementary   Regular School No Elementary PK 05 2019   grade_5 79 0 7 0   0     0   4   43 47                       90.0 79 0 7 0   0     0   4   43 47                 90
2045885 2045885 MA Hampden   school 2511130 281   Springfield 251113001796 2810025 Brightwood   Regular School No Elementary PK 05 2019   grade_5 1 6 47 0   0     0   0   26 28                       54.0 1 6 47 0   0     0   0   26 28                 54
2041207 2041207 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No Elementary PK 06 2019   grade_5 39 3 1 0   0     0   0   17 26                       43.0 39 3 1 0   0     0   0   17 26                 43
2044243 2044243 MA Norfolk   school 2508370 199   Needham 250837001306 1990005 Broadmeadow   Regular School No Elementary KG 05 2019   grade_5 92 1 6 0   6     0   2   49 58                       107.0 92 1 6 0   6     0   2   49 58                 107
2047614 2047614 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 11 2019   grade_5 5 102 67 0   5     0   2   87 94                       181.0 5 102 67 0   5     0   2   87 94                 181
2041234 2041234 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brookfield   Regular School No Elementary KG 05 2019   grade_5 30 67 17 0   1     0   4   68 51                       119.0 30 67 17 0   1     0   4   68 51                 119
2041331 2041331 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2019   grade_5 32 0 2 0   0     0   2   14 22                       36.0 32 0 2 0   0     0   2   14 22                 36
2043925 2043925 MA Middlesex   school 2507560 176   Medford 250756002049 1760130 Brooks School   Regular School No Elementary PK 05 2019   grade_5 52 8 7 0   2     0   7   38 38                       76.0 52 8 7 0   2     0   7   38 38                 76
2041964 2041964 MA Middlesex   school 2504320 79   Dracut 250432000578 790035 Brookside Elementary   Regular School No Elementary KG 05 2019   grade_5 57 11 6 0   5     0   0   44 35                       79.0 57 11 6 0   5     0   0   44 35                 79
2042407 2042407 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2019   grade_5 34 8 55 0   6     0   2   56 49                       105.0 34 8 55 0   6     0   2   56 49                 105
2044988 2044988 MA Plymouth   school 2509420 231   Pembroke 250942001508 2310003 Bryantville Elementary   Regular School No Elementary KG 06 2019   grade_5 65 0 0 0   0     0   3   29 39                       68.0 65 0 0 0   0     0   3   29 39                 68

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