enrollments

Data source: Big Local News · About: Big Local

954 rows where grade = "grade_4", state = "MA" and year = 2019 sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 954 ✖

grade ✖

  • grade_4 · 954 ✖
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
2043559 2043559 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary KG 05 2019   grade_4 2 6 56 0   15     0   6   43 42                       85.0 2 6 56 0   15     0   6   43 42                 85
2044447 2044447 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2019   grade_4 57 3 6 0   16     0   7   32 57                       89.0 57 3 6 0   16     0   7   32 57                 89
2048221 2048221 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No Elementary 03 05 2019   grade_4 76 1 6 0   0     0   7   50 40                       90.0 76 1 6 0   0     0   7   50 40                 90
2045344 2045344 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2019   grade_4 52 4 61 0   6     1   1   62 63                       125.0 52 4 61 0   6     1   1   62 63                 125
2040025 2040025 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2019   grade_4 56 2 17 0   3     0   1   40 39                       79.0 56 2 17 0   3     0   1   40 39                 79
2046839 2046839 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No Elementary 03 05 2019   grade_4 95 1 1 0   26     0   6   64 65                       129.0 95 1 1 0   26     0   6   64 65                 129
2042366 2042366 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_4 * * * *   *     *   *   1 2                       3.0                         1 2                 3
2047734 2047734 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_4 23 65 19 0   3     0   6   64 52                       116.0 23 65 19 0   3     0   6   64 52                 116
2046804 2046804 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No Elementary KG 04 2019   grade_4 19 1 5 0   5     0   1   13 18                       31.0 19 1 5 0   5     0   1   13 18                 31
2043553 2043553 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2019   grade_4 15 7 18 1   2     0   1   24 20                       44.0 15 7 18 1   2     0   1   24 20                 44
2043401 2043401 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2019   grade_4 11 5 36 0   45     0   3   51 49                       100.0 11 5 36 0   45     0   3   51 49                 100
2044347 2044347 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2019   grade_4 51 8 39 1   0     0   9   57 51                       108.0 51 8 39 1   0     0   9   57 51                 108
2045361 2045361 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2019   grade_4 29 6 48 0   2     0   0   39 46                       85.0 29 6 48 0   2     0   0   39 46                 85
2046989 2046989 MA Norfolk   school 2512840 336   Weymouth 251284002103 3360005 Academy Avenue   Regular School No Elementary KG 04 2019   grade_4 44 2 6 0   3     0   1   27 29                       56.0 44 2 6 0   3     0   1   27 29                 56
2039830 2039830 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2019   grade_4 95 0 7 0   0     0   2   48 56                       104.0 95 0 7 0   0     0   2   48 56                 104
2045747 2045747 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2019   grade_4 27 6 38 0   12     0   5   47 41                       88.0 27 6 38 0   12     0   5   47 41                 88
2041795 2041795 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Alcott   Regular School No Elementary PK 05 2019   grade_4 49 5 5 0   7     0   6   34 38                       72.0 49 5 5 0   7     0   6   34 38                 72
2041980 2041980 MA Plymouth   school 2504410 82   Duxbury 250441000968 820004 Alden School   Regular School No Elementary 03 05 2019   grade_4 167 0 4 0   3     0   18   100 92                       192.0 167 0 4 0   3     0   18   100 92                 192
2043062 2043062 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Middle 03 08 2019   grade_4 4 1 81 0   1     0   0   37 50                       87.0 4 1 81 0   1     0   0   37 50                 87
2045957 2045957 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2019   grade_4 10 13 21 0   0     0   2   21 25                       46.0 10 13 21 0   0     0   2   21 25                 46
2044320 2044320 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 Alfred J Gomes   Regular School No Elementary KG 05 2019   grade_4 11 17 61 2   0     0   3   58 36                       94.0 11 17 61 2   0     0   3   58 36                 94
2046031 2046031 MA Hampden   school 2511130 281   Springfield 251113001792 2810175 Alice B Beal Elementary   Regular School No Elementary KG 05 2019   grade_4 4 6 23 0   7     0   0   24 16                       40.0 4 6 23 0   7     0   0   24 16                 40
2045304 2045304 MA Middlesex   school 2509990 246   Reading 250999001604 2460002 Alice M Barrows   Regular School No Elementary KG 05 2019   grade_4 59 1 0 0   1     0   0   27 34                       61.0 59 1 0 0   1     0   0   27 34                 61
2045023 2045023 MA Berkshire   school 2509630 236   Pittsfield 250963001516 2360010 Allendale   Regular School No Elementary KG 05 2019   grade_4 33 7 8 0   2     0   6   27 29                       56.0 33 7 8 0   2     0   6   27 29                 56
2047520 2047520 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_4 9 7 34 0   0     0   0   25 25                       50.0 9 7 34 0   0     0   0   25 25                 50
2047119 2047119 MA Middlesex   school 2513110 344   Winchester 251311002164 3440045 Ambrose Elementary   Regular School No Elementary KG 05 2019   grade_4 69 0 2 0   2     0   3   43 33                       76.0 69 0 2 0   2     0   3   43 33                 76
2039870 2039870 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2019   grade_4 71 1 7 0   2     0   7   48 40                       88.0 71 1 7 0   2     0   7   48 40                 88
2041462 2041462 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2019   grade_4 11 2 22 0   1     0   6   22 20                       42.0 11 2 22 0   1     0   6   22 20                 42
2044666 2044666 MA Bristol   school 2508730 212   North Attleborough 250873001401 2120007 Amvet Boulevard   Regular School No Elementary KG 05 2019   grade_4 46 5 4 0   12     0   4   33 38                       71.0 46 5 4 0   12     0   4   33 38                 71
2047047 2047047 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No Elementary PK 06 2019   grade_4 17 0 3 0   0     0   0   9 11                       20.0 17 0 3 0   0     0   0   9 11                 20
2044648 2044648 MA Essex   school 2508700 211   North Andover 250870000767 2110018 Annie L Sargent School   Regular School No Elementary 01 05 2019   grade_4 83 2 5 1   6     0   3   56 44                       100.0 83 2 5 1   6     0   3   56 44                 100
2041174 2041174 MA Norfolk   school 2502940 40   Braintree 250294000360 400033 Archie T Morrison   Regular School No Elementary KG 05 2019   grade_4 45 9 6 0   10     0   1   35 36                       71.0 45 9 6 0   10     0   1   35 36                 71
2045728 2045728 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No Elementary PK 08 2019   grade_4 4 9 22 0   2     0   2   18 21                       39.0 4 9 22 0   2     0   2   18 21                 39
2046025 2046025 MA Hampden   school 2511130 281   Springfield 251113001795 2810165 Arthur T Talmadge   Regular School No Elementary KG 05 2019   grade_4 9 10 20 0   0     0   0   23 16                       39.0 9 10 20 0   0     0   0   23 16                 39
2047133 2047133 MA Suffolk   school 2513170 346   Winthrop 251317001841 3460020 Arthur T. Cummings Elementary School   Regular School No Elementary 03 05 2019   grade_4 115 4 25 0   0     0   4   90 58                       148.0 115 4 25 0   0     0   4   90 58                 148
2048765 2048765 MA Middlesex   school 2508790 735   North Middlesex 250879001412 7350010 Ashby Elementary   Regular School No Elementary KG 04 2019   grade_4 36 0 2 0   0     0   0   20 18                       38.0 36 0 2 0   0     0   0   20 18                 38
2045196 2045196 MA Norfolk   school 2509870 243   Quincy 250987001560 2430040 Atherton Hough   Regular School No Elementary KG 05 2019   grade_4 33 2 5 0   3     0   1   27 17                       44.0 33 2 5 0   3     0   1   27 17                 44
2048150 2048150 MA Worcester   school 2502160 615   Athol-Royalston 250216000080 6150020 Athol Community Elementary School   Regular School No Elementary PK 04 2019   grade_4 76 0 7 0   3     0   5   55 36                       91.0 76 0 7 0   3     0   5   55 36                 91
2044631 2044631 MA Essex   school 2508700 211   North Andover 250870001393 2110001 Atkinson   Regular School No Elementary 01 05 2019   grade_4 44 5 17 0   5     0   3   36 38                       74.0 44 5 17 0   5     0   3   36 38                 74
2047988 2047988 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2019   grade_4 91 5 7 0   2     0   5   46 64                       110.0 91 5 7 0   2     0   5   46 64                 110
2041893 2041893 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No Elementary 01 05 2019   grade_4 29 7 14 1   3     0   2   28 28                       56.0 29 7 14 1   3     0   2   28 28                 56
2040251 2040251 MA Essex   school 2502640 30   Beverly 250264000175 300055 Ayers/Ryal Side School   Regular School No Elementary KG 04 2019   grade_4 69 3 13 0   7     0   1   53 40                       93.0 69 3 13 0   7     0   1   53 40                 93
2044826 2044826 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No Elementary 01 05 2019   grade_4 27 8 25 0   1     0   1   27 35                       62.0 27 8 25 0   1     0   1   27 35                 62
2048695 2048695 MA Worcester   school 2508280 720   Narragansett 250828001283 7200005 Baldwinville Elementary   Regular School No Elementary 02 04 2019   grade_4 85 1 6 0   0     1   7   48 52                       100.0 85 1 6 0   0     1   7   48 52                 100
2039916 2039916 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2019   grade_4 79 4 6 0   12     0   5   54 52                       106.0 79 4 6 0   12     0   5   54 52                 106
2042424 2042424 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2019   grade_4 36 4 79 0   1     0   2   50 72                       122.0 36 4 79 0   1     0   2   50 72                 122
2040118 2040118 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable United Elementary School   Regular School No Elementary 04 05 2019   grade_4 288 32 62 2   7     0   23   218 196                       414.0 288 32 62 2   7     0   23   218 196                 414
2041685 2041685 MA Hampden   school 2503660 61   Chicopee 250366000489 610003 Barry   Regular School No Elementary KG 05 2019   grade_4 43 3 22 0   4     0   1   41 32                       73.0 43 3 22 0   4     0   1   41 32                 73
2043461 2043461 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No Elementary PK 08 2019   grade_4 7 3 20 0   18     0   0   21 27                       48.0 7 3 20 0   18     0   0   21 27                 48
2045467 2045467 MA Essex   school 2510380 258   Salem 251038001653 2580003 Bates   Regular School No Elementary KG 05 2019   grade_4 31 5 25 0   4     0   3   35 33                       68.0 31 5 25 0   4     0   3   35 33                 68
2045351 2045351 MA Suffolk   school 2510050 248   Revere 251005001962 2480013 Beachmont Veterans Memorial School   Regular School No Elementary PK 05 2019   grade_4 20 0 20 0   1     0   2   23 20                       43.0 20 0 20 0   1     0   2   23 20                 43
2045086 2045086 MA Norfolk   school 2509690 238   Plainville 250969001538 2380005 Beatrice H Wood Elementary   Regular School No Middle 04 06 2019   grade_4 68 5 6 0   3     0   2   44 40                       84.0 68 5 6 0   3     0   2   44 40                 84
2048271 2048271 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Becket Washington School   Regular School No Elementary PK 05 2019   grade_4 19 0 2 0   0     0   1   13 9                       22.0 19 0 2 0   0     0   1   13 9                 22
2043705 2043705 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2019   grade_4 33 22 13 0   29     0   5   52 50                       102.0 33 22 13 0   29     0   5   52 50                 102
2045179 2045179 MA Norfolk   school 2509870 243   Quincy 250987000772 2430020 Beechwood Knoll Elementary   Regular School No Elementary KG 05 2019   grade_4 32 1 0 0   16     0   0   22 27                       49.0 32 1 0 0   16     0   0   22 27                 49
2042551 2042551 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No Elementary KG 05 2019   grade_4 42 0 9 1   3     0   1   32 24                       56.0 42 0 9 1   3     0   1   32 24                 56
2040166 2040166 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial School   Regular School No Middle 04 07 2019   grade_4 154 5 6 0   3     0   4   78 94                       172.0 154 5 6 0   3     0   4   78 94                 172
2047202 2047202 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2019   grade_4 18 11 33 0   5     0   7   36 38                       74.0 18 11 33 0   5     0   7   36 38                 74
2047589 2047589 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_4 0 40 8 0   0     0   0   23 25                       48.0 0 40 8 0   0     0   0   23 25                 48
2047760 2047760 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_4 32 3 0 0   14     0   2   19 32                       51.0 32 3 0 0   14     0   2   19 32                 51
2045721 2045721 MA Middlesex   school 2510890 274   Somerville 251089001732 2740015 Benjamin G Brown   Regular School No Elementary KG 05 2019   grade_4 23 1 3 0   4     0   5   14 22                       36.0 23 1 3 0   4     0   5   14 22                 36
2039845 2039845 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2019   grade_4 66 4 2 0   1     0   2   51 24                       75.0 66 4 2 0   1     0   2   51 24                 75
2044204 2044204 MA Middlesex   school 2508340 198   Natick 250834001291 1980005 Bennett-Hemenway   Regular School No Elementary KG 04 2019   grade_4 87 2 4 1   18     1   6   67 52                       119.0 87 2 4 1   18     1   6   67 52                 119
2049323 2049323 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes Elementary KG 05 2019   grade_4 13 7 34 0   3     0   0   26 31                       57.0 13 7 34 0   3     0   0   26 31                 57
2040214 2040214 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No Elementary PK 04 2019   grade_4 80 0 1 0   0     0   4   41 44                       85.0 80 0 1 0   0     0   4   41 44                 85
2040224 2040224 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No Elementary PK 05 2019   grade_4 22 0 0 0   0     0   0   16 6                       22.0 22 0 0 0   0     0   0   16 6                 22
2048826 2048826 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Bernardston Elementary   Regular School No Elementary PK 06 2019   grade_4 20 0 0 0   0     0   3   10 13                       23.0 20 0 0 0   0     0   3   10 13                 23
2048488 2048488 MA Essex   school 2505670 675   Hamilton-Wenham 250567001459 6750007 Bessie Buker Elementary   Regular School No Elementary KG 05 2019   grade_4 36 0 3 0   1     0   1   24 17                       41.0 36 0 3 0   1     0   1   24 17                 41
2044399 2044399 MA Bristol   school 2508430 201   New Bedford 250843001319 2010140 Betsey B Winslow   Regular School No Elementary KG 05 2019   grade_4 36 7 13 0   1     0   4   29 32                       61.0 36 7 13 0   1     0   4   29 32                 61
2045310 2045310 MA Middlesex   school 2509990 246   Reading 250999001606 2460005 Birch Meadow   Regular School No Elementary KG 05 2019   grade_4 57 1 1 0   2     0   2   35 28                       63.0 57 1 1 0   2     0   2   35 28                 63
2040920 2040920 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No Elementary PK 05 2019   grade_4 1 21 50 0   0     0   2   40 34                       74.0 1 21 50 0   0     0   2   40 34                 74
2048057 2048057 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No Elementary KG 06 2019   grade_4 35 1 2 0   20     0   1   35 24                       59.0 35 1 2 0   20     0   1   35 24                 59
2043334 2043334 MA Hampden   school 2506990 159   Longmeadow 250699001016 1590005 Blueberry Hill   Regular School No Elementary KG 05 2019   grade_4 52 1 2 0   6     0   3   33 31                       64.0 52 1 2 0   6     0   3   33 31                 64
2047910 2047910 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_4 2 86 26 0   0     0   2   58 58                       116.0 2 86 26 0   0     0   2   58 58                 116
2040345 2040345 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2019   grade_4 11 8 7 0   0     0   0   11 15                       26.0 11 8 7 0   0     0   0   11 15                 26
2041116 2041116 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No Elementary PK 04 2019   grade_4 75 1 7 1   0     0   3   49 38                       87.0 75 1 7 1   0     0   3   49 38                 87
2041694 2041694 MA Hampden   school 2503660 61   Chicopee 250366000492 610015 Bowe   Regular School No Elementary KG 05 2019   grade_4 23 5 43 0   1     0   5   38 39                       77.0 23 5 43 0   1     0   5   38 39                 77
2044453 2044453 MA Middlesex   school 2508610 207   Newton 250861001358 2070015 Bowen   Regular School No Elementary KG 05 2019   grade_4 36 3 2 0   11     0   3   26 29                       55.0 36 3 2 0   11     0   3   26 29                 55
2041700 2041700 MA Hampden   school 2503660 61   Chicopee 250366000493 610020 Bowie   Regular School No Elementary KG 05 2019   grade_4 34 5 13 0   0     0   1   26 27                       53.0 34 5 13 0   0     0   1   26 27                 53
2043260 2043260 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Bowman   Regular School No Elementary KG 05 2019   grade_4 43 5 2 0   35     0   14   52 47                       99.0 43 5 2 0   35     0   14   52 47                 99
2046507 2046507 MA Norfolk   school 2511970 307   Walpole 251197002563 3070010 Boyden   Regular School No Elementary KG 05 2019   grade_4 39 6 1 0   3     0   1   23 27                       50.0 39 6 1 0   3     0   1   23 27                 50
2041144 2041144 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No Elementary PK 05 2019   grade_4 37 1 2 0   2     0   1   17 26                       43.0 37 1 2 0   2     0   1   17 26                 43
2039967 2039967 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2019   grade_4 69 2 8 0   8     1   9   53 44                       97.0 69 2 8 0   8     1   9   53 44                 97
2042730 2042730 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Bradford Elementary   Regular School No Elementary KG 04 2019   grade_4 50 4 28 0   1     0   1   50 34                       84.0 50 4 28 0   1     0   1   50 34                 84
2044584 2044584 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No Elementary PK 06 2019   grade_4 32 1 3 0   0     0   1   19 18                       37.0 32 1 3 0   0     0   1   19 18                 37
2043565 2043565 MA Essex   school 2507110 163   Lynn 250711001064 1630020 Brickett Elementary   Regular School No Elementary KG 05 2019   grade_4 8 8 35 1   3     0   4   35 24                       59.0 8 8 35 1   3     0   4   35 24                 59
2043254 2043254 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Bridge   Regular School No Elementary KG 05 2019   grade_4 44 7 5 0   48     0   0   55 49                       104.0 44 7 5 0   48     0   0   55 49                 104
2047574 2047574 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 07 2019   grade_4 0 23 15 0   0     0   3   22 19                       41.0 0 23 15 0   0     0   3   22 19                 41
2044599 2044599 MA Hampshire   school 2508850 210   Northampton 250885001425 2100005 Bridge Street   Regular School No Elementary PK 05 2019   grade_4 28 1 3 1   1     0   3   25 12                       37.0 28 1 3 1   1     0   3   25 12                 37
2048135 2048135 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002368 6100025 Briggs Elementary   Regular School No Elementary PK 05 2019   grade_4 76 1 11 0   2     0   2   41 51                       92.0 76 1 11 0   2     0   2   41 51                 92
2045884 2045884 MA Hampden   school 2511130 281   Springfield 251113001796 2810025 Brightwood   Regular School No Elementary PK 05 2019   grade_4 2 8 40 0   0     0   0   25 25                       50.0 2 8 40 0   0     0   0   25 25                 50
2041206 2041206 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No Elementary PK 06 2019   grade_4 40 1 1 0   0     0   0   21 21                       42.0 40 1 1 0   0     0   0   21 21                 42
2044242 2044242 MA Norfolk   school 2508370 199   Needham 250837001306 1990005 Broadmeadow   Regular School No Elementary KG 05 2019   grade_4 72 1 4 0   7     0   4   40 48                       88.0 72 1 4 0   7     0   4   40 48                 88
2047613 2047613 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 11 2019   grade_4 14 93 67 1   4     0   4   85 98                       183.0 14 93 67 1   4     0   4   85 98                 183
2041233 2041233 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brookfield   Regular School No Elementary KG 05 2019   grade_4 22 64 13 0   3     1   6   55 54                       109.0 22 64 13 0   3     1   6   55 54                 109
2041330 2041330 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2019   grade_4 38 0 1 0   0     0   2   19 22                       41.0 38 0 1 0   0     0   2   19 22                 41
2043924 2043924 MA Middlesex   school 2507560 176   Medford 250756002049 1760130 Brooks School   Regular School No Elementary PK 05 2019   grade_4 54 7 2 0   6     0   5   35 39                       74.0 54 7 2 0   6     0   5   35 39                 74
2041963 2041963 MA Middlesex   school 2504320 79   Dracut 250432000578 790035 Brookside Elementary   Regular School No Elementary KG 05 2019   grade_4 53 8 6 0   2     0   1   43 27                       70.0 53 8 6 0   2     0   1   43 27                 70
2042406 2042406 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2019   grade_4 24 4 47 0   4     0   0   45 34                       79.0 24 4 47 0   4     0   0   45 34                 79
2044209 2044209 MA Middlesex   school 2508340 198   Natick 250834001292 1980010 Brown   Regular School No Elementary KG 04 2019   grade_4 64 0 9 1   17     0   6   47 50                       97.0 64 0 9 1   17     0   6   47 50                 97

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