enrollments

Data source: Big Local News · About: Big Local

979 rows where grade = "grade_1", state = "MA" and year = 2019 sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 979 ✖

grade ✖

  • grade_1 · 979 ✖
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
2043556 2043556 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary KG 05 2019   grade_1 6 7 49 0   12     0   1   30 45                       75.0 6 7 49 0   12     0   1   30 45                 75
2044444 2044444 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2019   grade_1 51 4 5 0   8     0   5   38 35                       73.0 51 4 5 0   8     0   5   38 35                 73
2045341 2045341 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2019   grade_1 59 7 64 0   4     0   4   74 64                       138.0 59 7 64 0   4     0   4   74 64                 138
2040022 2040022 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2019   grade_1 54 4 7 0   1     0   2   37 31                       68.0 54 4 7 0   1     0   2   37 31                 68
2042363 2042363 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_1 6 0 0 0   0     0   0   4 2                       6.0 6 0 0 0   0     0   0   4 2                 6
2047731 2047731 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_1 16 55 30 1   5     0   7   40 74                       114.0 16 55 30 1   5     0   7   40 74                 114
2046801 2046801 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No Elementary KG 04 2019   grade_1 28 1 14 0   3     0   1   28 19                       47.0 28 1 14 0   3     0   1   28 19                 47
2043550 2043550 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2019   grade_1 10 2 24 1   4     0   4   23 22                       45.0 10 2 24 1   4     0   4   23 22                 45
2043398 2043398 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2019   grade_1 13 1 23 0   48     0   6   52 39                       91.0 13 1 23 0   48     0   6   52 39                 91
2044344 2044344 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2019   grade_1 60 18 45 0   1     1   4   72 57                       129.0 60 18 45 0   1     1   4   72 57                 129
2045358 2045358 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2019   grade_1 28 1 63 0   4     0   1   45 52                       97.0 28 1 63 0   4     0   1   45 52                 97
2046986 2046986 MA Norfolk   school 2512840 336   Weymouth 251284002103 3360005 Academy Avenue   Regular School No Elementary KG 04 2019   grade_1 42 2 5 0   3     0   6   29 29                       58.0 42 2 5 0   3     0   6   29 29                 58
2039827 2039827 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2019   grade_1 95 3 4 0   1     0   2   55 50                       105.0 95 3 4 0   1     0   2   55 50                 105
2045744 2045744 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2019   grade_1 39 6 36 0   8     0   3   48 44                       92.0 39 6 36 0   8     0   3   48 44                 92
2041792 2041792 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Alcott   Regular School No Elementary PK 05 2019   grade_1 53 7 8 0   6     0   4   47 31                       78.0 53 7 8 0   6     0   4   47 31                 78
2045954 2045954 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2019   grade_1 11 11 19 0   0     0   2   23 20                       43.0 11 11 19 0   0     0   2   23 20                 43
2044317 2044317 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 Alfred J Gomes   Regular School No Elementary KG 05 2019   grade_1 15 9 63 1   0     0   3   46 45                       91.0 15 9 63 1   0     0   3   46 45                 91
2044887 2044887 MA Worcester   school 2509270 226   Oxford 250927001479 2260010 Alfred M Chaffee   Regular School No Elementary PK 01 2019   grade_1 85 2 9 0   1     0   3   51 49                       100.0 85 2 9 0   1     0   3   51 49                 100
2046897 2046897 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No Elementary PK 02 2019   grade_1 100 1 2 0   0     0   4   54 53                       107.0 100 1 2 0   0     0   4   54 53                 107
2046028 2046028 MA Hampden   school 2511130 281   Springfield 251113001792 2810175 Alice B Beal Elementary   Regular School No Elementary KG 05 2019   grade_1 4 7 21 0   3     0   0   11 24                       35.0 4 7 21 0   3     0   0   11 24                 35
2045301 2045301 MA Middlesex   school 2509990 246   Reading 250999001604 2460002 Alice M Barrows   Regular School No Elementary KG 05 2019   grade_1 60 1 1 0   4     0   1   38 29                       67.0 60 1 1 0   4     0   1   38 29                 67
2045020 2045020 MA Berkshire   school 2509630 236   Pittsfield 250963001516 2360010 Allendale   Regular School No Elementary KG 05 2019   grade_1 33 7 10 0   2     0   8   21 39                       60.0 33 7 10 0   2     0   8   21 39                 60
2047517 2047517 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_1 9 9 33 1   0     0   0   25 27                       52.0 9 9 33 1   0     0   0   25 27                 52
2047116 2047116 MA Middlesex   school 2513110 344   Winchester 251311002164 3440045 Ambrose Elementary   Regular School No Elementary KG 05 2019   grade_1 41 0 0 0   3     0   5   32 17                       49.0 41 0 0 0   3     0   5   32 17                 49
2039867 2039867 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2019   grade_1 59 0 7 0   0     0   5   42 29                       71.0 59 0 7 0   0     0   5   42 29                 71
2041459 2041459 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2019   grade_1 20 2 22 0   2     0   4   20 30                       50.0 20 2 22 0   2     0   4   20 30                 50
2044663 2044663 MA Bristol   school 2508730 212   North Attleborough 250873001401 2120007 Amvet Boulevard   Regular School No Elementary KG 05 2019   grade_1 51 4 0 1   10     0   3   34 35                       69.0 51 4 0 1   10     0   3   34 35                 69
2045091 2045091 MA Norfolk   school 2509690 238   Plainville 250969001537 2380010 Anna Ware Jackson   Regular School No Elementary PK 03 2019   grade_1 75 5 8 0   4     0   1   46 47                       93.0 75 5 8 0   4     0   1   46 47                 93
2047044 2047044 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No Elementary PK 06 2019   grade_1 14 0 2 0   1     0   0   8 9                       17.0 14 0 2 0   1     0   0   8 9                 17
2046749 2046749 MA Worcester   school 2512600 321   Westborough 251260002055 3210010 Annie E Fales   Regular School No Elementary KG 03 2019   grade_1 42 1 2 0   25     0   4   27 47                       74.0 42 1 2 0   25     0   4   27 47                 74
2044645 2044645 MA Essex   school 2508700 211   North Andover 250870000767 2110018 Annie L Sargent School   Regular School No Elementary 01 05 2019   grade_1 69 3 8 0   12     0   4   52 44                       96.0 69 3 8 0   12     0   4   52 44                 96
2041171 2041171 MA Norfolk   school 2502940 40   Braintree 250294000360 400033 Archie T Morrison   Regular School No Elementary KG 05 2019   grade_1 57 7 4 0   9     0   1   52 26                       78.0 57 7 4 0   9     0   1   52 26                 78
2045725 2045725 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No Elementary PK 08 2019   grade_1 23 10 25 0   4     0   0   32 30                       62.0 23 10 25 0   4     0   0   32 30                 62
2046022 2046022 MA Hampden   school 2511130 281   Springfield 251113001795 2810165 Arthur T Talmadge   Regular School No Elementary KG 05 2019   grade_1 6 9 27 0   0     0   1   28 15                       43.0 6 9 27 0   0     0   1   28 15                 43
2048762 2048762 MA Middlesex   school 2508790 735   North Middlesex 250879001412 7350010 Ashby Elementary   Regular School No Elementary KG 04 2019   grade_1 33 1 2 0   0     0   1   21 16                       37.0 33 1 2 0   0     0   1   21 16                 37
2048401 2048401 MA Plymouth   school 2505070 665   Freetown-Lakeville 250507002739 6650002 Assawompset Elementary School   Regular School No Elementary KG 03 2019   grade_1 98 3 2 0   0     0   3   62 44                       106.0 98 3 2 0   0     0   3   62 44                 106
2045193 2045193 MA Norfolk   school 2509870 243   Quincy 250987001560 2430040 Atherton Hough   Regular School No Elementary KG 05 2019   grade_1 19 2 1 0   14     0   2   23 15                       38.0 19 2 1 0   14     0   2   23 15                 38
2048147 2048147 MA Worcester   school 2502160 615   Athol-Royalston 250216000080 6150020 Athol Community Elementary School   Regular School No Elementary PK 04 2019   grade_1 96 1 10 0   3     0   5   57 58                       115.0 96 1 10 0   3     0   5   57 58                 115
2044628 2044628 MA Essex   school 2508700 211   North Andover 250870001393 2110001 Atkinson   Regular School No Elementary 01 05 2019   grade_1 36 3 19 1   6     0   2   32 35                       67.0 36 3 19 1   6     0   2   32 35                 67
2047985 2047985 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2019   grade_1 86 6 7 0   1     0   10   55 55                       110.0 86 6 7 0   1     0   10   55 55                 110
2041890 2041890 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No Elementary 01 05 2019   grade_1 35 3 16 1   1     0   2   28 30                       58.0 35 3 16 1   1     0   2   28 30                 58
2040248 2040248 MA Essex   school 2502640 30   Beverly 250264000175 300055 Ayers/Ryal Side School   Regular School No Elementary KG 04 2019   grade_1 69 2 5 0   6     0   3   39 46                       85.0 69 2 5 0   6     0   3   39 46                 85
2044823 2044823 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No Elementary 01 05 2019   grade_1 31 7 22 0   5     2   2   38 31                       69.0 31 7 22 0   5     2   2   38 31                 69
2040316 2040316 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Baldwin Early Learning Center   Regular School No Elementary PK 01 2019   grade_1 5 4 14 0   9     0   3   24 11                       35.0 5 4 14 0   9     0   3   24 11                 35
2039913 2039913 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2019   grade_1 82 2 2 0   9     0   1   48 48                       96.0 82 2 2 0   9     0   1   48 48                 96
2042421 2042421 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2019   grade_1 19 3 93 0   1     0   4   49 71                       120.0 19 3 93 0   1     0   4   49 71                 120
2047606 2047606 MA Barnstable   school 2500081 427   Barnstable Community Horace Mann Charter Public (District) 250008101844 4270010 Barnstable Community Horace Mann Charter Public School   Regular School Yes Elementary KG 03 2019   grade_1 43 11 24 1   1     0   2   45 37                       82.0 43 11 24 1   1     0   2   45 37                 82
2041682 2041682 MA Hampden   school 2503660 61   Chicopee 250366000489 610003 Barry   Regular School No Elementary KG 05 2019   grade_1 44 1 19 0   1     0   1   35 31                       66.0 44 1 19 0   1     0   1   35 31                 66
2043458 2043458 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No Elementary PK 08 2019   grade_1 6 4 17 0   21     0   1   29 20                       49.0 6 4 17 0   21     0   1   29 20                 49
2045464 2045464 MA Essex   school 2510380 258   Salem 251038001653 2580003 Bates   Regular School No Elementary KG 05 2019   grade_1 38 7 11 0   0     0   3   25 34                       59.0 38 7 11 0   0     0   3   25 34                 59
2045348 2045348 MA Suffolk   school 2510050 248   Revere 251005001962 2480013 Beachmont Veterans Memorial School   Regular School No Elementary PK 05 2019   grade_1 27 2 33 0   1     0   2   38 27                       65.0 27 2 33 0   1     0   2   38 27                 65
2045655 2045655 MA Worcester   school 2510770 271   Shrewsbury 251077002496 2710005 Beal School   Regular School No Elementary KG 01 2019   grade_1 29 5 6 1   27     0   5   46 27                       73.0 29 5 6 1   27     0   5   46 27                 73
2039814 2039814 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2019   grade_1 119 7 9 3   3     0   1   66 76                       142.0 119 7 9 3   3     0   1   66 76                 142
2048268 2048268 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Becket Washington School   Regular School No Elementary PK 05 2019   grade_1 14 0 0 0   0     0   0   10 4                       14.0 14 0 0 0   0     0   0   10 4                 14
2043702 2043702 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2019   grade_1 33 8 14 0   41     0   5   49 52                       101.0 33 8 14 0   41     0   5   49 52                 101
2045176 2045176 MA Norfolk   school 2509870 243   Quincy 250987000772 2430020 Beechwood Knoll Elementary   Regular School No Elementary KG 05 2019   grade_1 30 1 1 0   31     0   0   34 29                       63.0 30 1 1 0   31     0   0   34 29                 63
2042548 2042548 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No Elementary KG 05 2019   grade_1 35 0 9 0   0     0   3   22 25                       47.0 35 0 9 0   0     0   3   22 25                 47
2040385 2040385 MA Suffolk   school 2502790 35   Boston 250279000198 350021 Beethoven   Regular School No Elementary PK 02 2019   grade_1 28 27 28 0   1     0   3   35 52                       87.0 28 27 28 0   1     0   3   35 52                 87
2041688 2041688 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Belcher   Regular School No Elementary KG 02 2019   grade_1 47 9 38 0   1     0   2   52 45                       97.0 47 9 38 0   1     0   2   52 45                 97
2047199 2047199 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2019   grade_1 16 16 42 0   6     0   2   47 35                       82.0 16 16 42 0   6     0   2   47 35                 82
2047586 2047586 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_1 1 42 5 0   0     0   2   23 27                       50.0 1 42 5 0   0     0   2   23 27                 50
2047757 2047757 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_1 30 1 2 0   15     0   3   25 26                       51.0 30 1 2 0   15     0   3   25 26                 51
2045718 2045718 MA Middlesex   school 2510890 274   Somerville 251089001732 2740015 Benjamin G Brown   Regular School No Elementary KG 05 2019   grade_1 22 2 6 0   3     0   3   16 20                       36.0 22 2 6 0   3     0   3   16 20                 36
2039842 2039842 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2019   grade_1 57 1 4 0   2     0   6   42 28                       70.0 57 1 4 0   2     0   6   42 28                 70
2044201 2044201 MA Middlesex   school 2508340 198   Natick 250834001291 1980005 Bennett-Hemenway   Regular School No Elementary KG 04 2019   grade_1 90 2 2 1   14     0   1   60 50                       110.0 90 2 2 1   14     0   1   60 50                 110
2049320 2049320 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes Elementary KG 05 2019   grade_1 15 9 37 0   0     0   2   34 29                       63.0 15 9 37 0   0     0   2   34 29                 63
2040211 2040211 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No Elementary PK 04 2019   grade_1 73 1 1 0   0     0   3   39 39                       78.0 73 1 1 0   0     0   3   39 39                 78
2040221 2040221 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No Elementary PK 05 2019   grade_1 27 0 1 0   0     0   1   12 17                       29.0 27 0 1 0   0     0   1   12 17                 29
2048823 2048823 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Bernardston Elementary   Regular School No Elementary PK 06 2019   grade_1 19 0 0 0   0     0   0   10 9                       19.0 19 0 0 0   0     0   0   10 9                 19
2048485 2048485 MA Essex   school 2505670 675   Hamilton-Wenham 250567001459 6750007 Bessie Buker Elementary   Regular School No Elementary KG 05 2019   grade_1 31 0 5 0   3     0   1   26 14                       40.0 31 0 5 0   3     0   1   26 14                 40
2044396 2044396 MA Bristol   school 2508430 201   New Bedford 250843001319 2010140 Betsey B Winslow   Regular School No Elementary KG 05 2019   grade_1 32 4 6 0   1     0   1   24 20                       44.0 32 4 6 0   1     0   1   24 20                 44
2045307 2045307 MA Middlesex   school 2509990 246   Reading 250999001606 2460005 Birch Meadow   Regular School No Elementary KG 05 2019   grade_1 50 0 2 0   7     0   1   32 28                       60.0 50 0 2 0   7     0   1   32 28                 60
2040917 2040917 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No Elementary PK 05 2019   grade_1 4 29 45 0   1     0   1   43 37                       80.0 4 29 45 0   1     0   1   43 37                 80
2048054 2048054 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No Elementary KG 06 2019   grade_1 51 0 6 0   25     0   4   40 46                       86.0 51 0 6 0   25     0   4   40 46                 86
2043331 2043331 MA Hampden   school 2506990 159   Longmeadow 250699001016 1590005 Blueberry Hill   Regular School No Elementary KG 05 2019   grade_1 44 0 2 0   11     0   7   31 33                       64.0 44 0 2 0   11     0   7   31 33                 64
2047907 2047907 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_1 5 84 44 0   1     0   4   69 69                       138.0 5 84 44 0   1     0   4   69 69                 138
2040342 2040342 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2019   grade_1 14 3 5 0   0     0   0   13 9                       22.0 14 3 5 0   0     0   0   13 9                 22
2041113 2041113 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No Elementary PK 04 2019   grade_1 65 3 4 1   0     0   1   41 33                       74.0 65 3 4 1   0     0   1   41 33                 74
2041691 2041691 MA Hampden   school 2503660 61   Chicopee 250366000492 610015 Bowe   Regular School No Elementary KG 05 2019   grade_1 27 4 52 0   1     0   5   48 41                       89.0 27 4 52 0   1     0   5   48 41                 89
2044450 2044450 MA Middlesex   school 2508610 207   Newton 250861001358 2070015 Bowen   Regular School No Elementary KG 05 2019   grade_1 39 5 3 0   13     0   7   34 33                       67.0 39 5 3 0   13     0   7   34 33                 67
2041697 2041697 MA Hampden   school 2503660 61   Chicopee 250366000493 610020 Bowie   Regular School No Elementary KG 05 2019   grade_1 26 0 6 0   0     0   2   15 19                       34.0 26 0 6 0   0     0   2   15 19                 34
2043257 2043257 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Bowman   Regular School No Elementary KG 05 2019   grade_1 49 6 2 0   19     0   7   42 41                       83.0 49 6 2 0   19     0   7   42 41                 83
2046504 2046504 MA Norfolk   school 2511970 307   Walpole 251197002563 3070010 Boyden   Regular School No Elementary KG 05 2019   grade_1 48 6 1 1   4     0   1   26 35                       61.0 48 6 1 1   4     0   1   26 35                 61
2041141 2041141 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No Elementary PK 05 2019   grade_1 33 1 5 0   1     0   3   26 17                       43.0 33 1 5 0   1     0   3   26 17                 43
2039964 2039964 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2019   grade_1 61 0 1 0   9     0   9   42 38                       80.0 61 0 1 0   9     0   9   42 38                 80
2042727 2042727 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Bradford Elementary   Regular School No Elementary KG 04 2019   grade_1 43 2 16 0   2     0   2   36 29                       65.0 43 2 16 0   2     0   2   36 29                 65
2044581 2044581 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No Elementary PK 06 2019   grade_1 28 0 3 0   0     0   3   16 18                       34.0 28 0 3 0   0     0   3   16 18                 34
2043562 2043562 MA Essex   school 2507110 163   Lynn 250711001064 1630020 Brickett Elementary   Regular School No Elementary KG 05 2019   grade_1 7 4 37 0   7     0   2   20 37                       57.0 7 4 37 0   7     0   2   20 37                 57
2043251 2043251 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Bridge   Regular School No Elementary KG 05 2019   grade_1 34 2 6 0   31     0   4   32 45                       77.0 34 2 6 0   31     0   4   32 45                 77
2047571 2047571 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 07 2019   grade_1 0 25 14 0   1     0   0   21 19                       40.0 0 25 14 0   1     0   0   21 19                 40
2044596 2044596 MA Hampshire   school 2508850 210   Northampton 250885001425 2100005 Bridge Street   Regular School No Elementary PK 05 2019   grade_1 33 0 9 0   4     0   2   22 26                       48.0 33 0 9 0   4     0   2   22 26                 48
2048132 2048132 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002368 6100025 Briggs Elementary   Regular School No Elementary PK 05 2019   grade_1 65 1 1 0   0     0   5   34 38                       72.0 65 1 1 0   0     0   5   34 38                 72
2045881 2045881 MA Hampden   school 2511130 281   Springfield 251113001796 2810025 Brightwood   Regular School No Elementary PK 05 2019   grade_1 2 8 50 0   0     0   0   24 36                       60.0 2 8 50 0   0     0   0   24 36                 60
2041203 2041203 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No Elementary PK 06 2019   grade_1 35 0 0 0   0     0   0   17 18                       35.0 35 0 0 0   0     0   0   17 18                 35
2044239 2044239 MA Norfolk   school 2508370 199   Needham 250837001306 1990005 Broadmeadow   Regular School No Elementary KG 05 2019   grade_1 64 5 3 0   5     0   6   48 35                       83.0 64 5 3 0   5     0   6   48 35                 83
2047610 2047610 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 11 2019   grade_1 4 92 76 0   5     0   2   86 93                       179.0 4 92 76 0   5     0   2   86 93                 179
2041230 2041230 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brookfield   Regular School No Elementary KG 05 2019   grade_1 20 43 9 0   0     0   4   41 35                       76.0 20 43 9 0   0     0   4   41 35                 76
2041327 2041327 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2019   grade_1 35 0 5 0   0     0   2   22 20                       42.0 35 0 5 0   0     0   2   22 20                 42
2043921 2043921 MA Middlesex   school 2507560 176   Medford 250756002049 1760130 Brooks School   Regular School No Elementary PK 05 2019   grade_1 67 4 11 0   7     0   4   50 43                       93.0 67 4 11 0   7     0   4   50 43                 93
2044086 2044086 MA Worcester   school 2507860 185   Milford 250786001237 1850065 Brookside   Regular School No Elementary KG 02 2019   grade_1 96 8 44 1   0     0   7   87 69                       156.0 96 8 44 1   0     0   7   87 69                 156

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