enrollments

Data source: Big Local News · About: Big Local

957 rows where grade = "grade_4", state = "MA" and year = 2017 sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 957 ✖

grade ✖

  • grade_4 · 957 ✖
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
1126371 1126371 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary KG 05 2017   grade_4 3 5 51 1   16     0   4   41 39                       80 3 5 51 1   16     0   4   41 39                 80
1127422 1127422 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2017   grade_4 51 3 4 0   8     0   4   30 40                       70 51 3 4 0   8     0   4   30 40                 70
1131886 1131886 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No Elementary 03 05 2017   grade_4 84 1 4 0   1     0   3   37 56                       93 84 1 4 0   1     0   3   37 56                 93
1128484 1128484 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2017   grade_4 55 4 54 0   7     0   2   65 57                       122 55 4 54 0   7     0   2   65 57                 122
1122207 1122207 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2017   grade_4 67 3 23 0   0     0   4   55 42                       97 67 3 23 0   0     0   4   55 42                 97
1130272 1130272 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No Elementary 03 05 2017   grade_4 97 0 0 3   15     0   3   65 53                       118 97 0 0 3   15     0   3   65 53                 118
1124924 1124924 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   grade_4 13 0 0 0   0     0   0   5 8                       13 13 0 0 0   0     0   0   5 8                 13
1131330 1131330 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 2017   grade_4 20 63 34 0   2     0   0   57 62                       119 20 63 34 0   2     0   0   57 62                 119
1130215 1130215 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No Elementary KG 05 2017   grade_4 33 2 6 0   1     0   1   15 28                       43 33 2 6 0   1     0   1   15 28                 43
1126364 1126364 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2017   grade_4 13 8 19 0   2     0   3   19 26                       45 13 8 19 0   2     0   3   19 26                 45
1126190 1126190 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2017   grade_4 13 2 26 0   41     0   8   51 39                       90 13 2 26 0   41     0   8   51 39                 90
1127309 1127309 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2017   grade_4 52 13 58 0   1     0   14   72 66                       138 52 13 58 0   1     0   14   72 66                 138
1128504 1128504 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2017   grade_4 54 3 52 0   6     0   2   62 55                       117 54 3 52 0   6     0   2   62 55                 117
1130459 1130459 MA Norfolk   school 2512840 336   Weymouth 251284002103 3360005 Academy Avenue   Regular School No Elementary KG 04 2017   grade_4 42 2 10 0   8     0   1   37 26                       63 42 2 10 0   8     0   1   37 26                 63
1121970 1121970 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   grade_4 94 0 2 0   0     0   0   57 39                       96 94 0 2 0   0     0   0   57 39                 96
1128970 1128970 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2017   grade_4 33 4 35 0   6     0   2   46 34                       80 33 4 35 0   6     0   2   46 34                 80
1124257 1124257 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Alcott   Regular School No Elementary PK 05 2017   grade_4 61 4 6 0   6     0   6   43 40                       83 61 4 6 0   6     0   6   43 40                 83
1124475 1124475 MA Plymouth   school 2504410 82   Duxbury 250441000968 820004 Alden School   Regular School No Elementary 03 05 2017   grade_4 226 0 5 1   3     0   7   111 131                       242 226 0 5 1   3     0   7   111 131                 242
1125779 1125779 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Elementary 03 08 2017   grade_4 7 0 67 0   1     0   0   35 40                       75 7 0 67 0   1     0   0   35 40                 75
1129213 1129213 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2017   grade_4 12 5 21 0   0     0   1   12 27                       39 12 5 21 0   0     0   1   12 27                 39
1127279 1127279 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 Alfred J Gomes   Regular School No Elementary PK 05 2017   grade_4 16 5 48 1   0     0   5   43 32                       75 16 5 48 1   0     0   5   43 32                 75
1129296 1129296 MA Hampden   school 2511130 281   Springfield 251113001792 2810175 Alice B Beal Elementary   Regular School No Elementary KG 05 2017   grade_4 17 4 22 0   1     0   1   19 26                       45 17 4 22 0   1     0   1   19 26                 45
1128436 1128436 MA Middlesex   school 2509990 246   Reading 250999001604 2460002 Alice M Barrows   Regular School No Elementary KG 05 2017   grade_4 50 0 3 0   1     0   1   26 29                       55 50 0 3 0   1     0   1   26 29                 55
1128103 1128103 MA Berkshire   school 2509630 236   Pittsfield 250963001516 2360010 Allendale   Regular School No Elementary KG 05 2017   grade_4 34 6 6 1   0     0   2   26 23                       49 34 6 6 1   0     0   2   26 23                 49
1131105 1131105 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 07 2017   grade_4 10 9 19 0   0     0   4   18 24                       42 10 9 19 0   0     0   4   18 24                 42
1130629 1130629 MA Middlesex   school 2513110 344   Winchester 251311002164 3440045 Ambrose Elementary   Regular School No Elementary KG 05 2017   grade_4 76 0 2 0   3     0   3   39 45                       84 76 0 2 0   3     0   3   39 45                 84
1122021 1122021 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2017   grade_4 67 1 1 1   1     0   1   38 34                       72 67 1 1 1   1     0   1   38 34                 72
1123868 1123868 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2017   grade_4 19 0 20 0   0     0   3   21 21                       42 19 0 20 0   0     0   3   21 21                 42
1127683 1127683 MA Bristol   school 2508730 212   North Attleborough 250873001401 2120007 Amvet Boulevard   Regular School No Elementary KG 05 2017   grade_4 65 2 2 0   2     0   1   32 40                       72 65 2 2 0   2     0   1   32 40                 72
1130530 1130530 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No Elementary PK 06 2017   grade_4 19 1 0 0   0     0   0   9 11                       20 19 1 0 0   0     0   0   9 11                 20
1127660 1127660 MA Essex   school 2508700 211   North Andover 250870000767 2110018 Annie L Sargent School   Regular School No Elementary KG 05 2017   grade_4 75 2 2 2   5     0   6   48 44                       92 75 2 2 2   5     0   6   48 44                 92
1123535 1123535 MA Norfolk   school 2502940 40   Braintree 250294000360 400033 Archie T Morrison   Regular School No Elementary KG 05 2017   grade_4 51 13 6 0   10     0   1   48 33                       81 51 13 6 0   10     0   1   48 33                 81
1128948 1128948 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No Elementary PK 08 2017   grade_4 8 6 29 0   4     0   2   25 24                       49 8 6 29 0   4     0   2   25 24                 49
1129289 1129289 MA Hampden   school 2511130 281   Springfield 251113001795 2810165 Arthur T Talmadge   Regular School No Elementary KG 05 2017   grade_4 2 9 23 0   3     0   1   13 25                       38 2 9 23 0   3     0   1   13 25                 38
1130647 1130647 MA Suffolk   school 2513170 346   Winthrop 251317001841 3460020 Arthur T. Cummings Elementary School   Regular School No Elementary 03 05 2017   grade_4 120 2 21 0   1     0   1   67 78                       145 120 2 21 0   1     0   1   67 78                 145
1132513 1132513 MA Middlesex   school 2508790 735   North Middlesex 250879001412 7350010 Ashby Elementary   Regular School No Elementary KG 04 2017   grade_4 51 0 0 0   0     0   0   30 21                       51 51 0 0 0   0     0   0   30 21                 51
1128308 1128308 MA Norfolk   school 2509870 243   Quincy 250987001560 2430040 Atherton Hough   Regular School No Elementary KG 05 2017   grade_4 31 2 2 0   3     0   1   22 17                       39 31 2 2 0   3     0   1   22 17                 39
1131803 1131803 MA Worcester   school 2502160 615   Athol-Royalston 250216000080 6150020 Athol Community Elementary School   Regular School No Elementary PK 04 2017   grade_4 78 0 11 1   1     0   4   47 48                       95 78 0 11 1   1     0   4   47 48                 95
1127639 1127639 MA Essex   school 2508700 211   North Andover 250870001393 2110001 Atkinson   Regular School No Elementary PK 05 2017   grade_4 50 8 10 0   11     0   2   45 36                       81 50 8 10 0   11     0   2   45 36                 81
1131617 1131617 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 11 2017   grade_4 80 3 11 0   0     0   6   48 52                       100 80 3 11 0   0     0   6   48 52                 100
1124371 1124371 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No Elementary 01 05 2017   grade_4 40 8 17 1   2     0   4   39 33                       72 40 8 17 1   2     0   4   39 33                 72
1122484 1122484 MA Essex   school 2502640 30   Beverly 250264000175 300055 Ayers/Ryal Side School   Regular School No Elementary KG 05 2017   grade_4 55 1 15 0   7     0   0   44 34                       78 55 1 15 0   7     0   0   44 34                 78
1127874 1127874 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No Elementary 01 05 2017   grade_4 34 5 16 0   4     0   2   30 31                       61 34 5 16 0   4     0   2   30 31                 61
1132432 1132432 MA Worcester   school 2508280 720   Narragansett 250828001283 7200005 Baldwinville Elementary   Regular School No Elementary 02 04 2017   grade_4 67 1 3 0   0     1   3   43 32                       75 67 1 3 0   0     1   3   43 32                 75
1122074 1122074 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2017   grade_4 86 3 8 1   8     0   6   59 53                       112 86 3 8 1   8     0   6   59 53                 112
1124989 1124989 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2017   grade_4 44 5 69 0   0     0   6   54 70                       124 44 5 69 0   0     0   6   54 70                 124
1122319 1122319 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable United Elementary School   Regular School No Elementary 04 05 2017   grade_4 343 27 49 0   9     3   15   217 229                       446 343 27 49 0   9     3   15   217 229                 446
1124125 1124125 MA Hampden   school 2503660 61   Chicopee 250366000489 610003 Barry   Regular School No Elementary KG 05 2017   grade_4 47 1 18 0   4     0   3   41 32                       73 47 1 18 0   4     0   3   41 32                 73
1126259 1126259 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No Elementary PK 08 2017   grade_4 13 5 19 0   16     0   1   31 23                       54 13 5 19 0   16     0   1   31 23                 54
1128626 1128626 MA Essex   school 2510380 258   Salem 251038001653 2580003 Bates   Regular School No Elementary KG 05 2017   grade_4 29 5 10 0   1     0   3   27 21                       48 29 5 10 0   1     0   3   27 21                 48
1128492 1128492 MA Suffolk   school 2510050 248   Revere 251005001962 2480013 Beachmont Veterans Memorial School   Regular School No Elementary PK 05 2017   grade_4 28 4 23 0   1     0   1   29 28                       57 28 4 23 0   1     0   1   29 28                 57
1128177 1128177 MA Norfolk   school 2509690 238   Plainville 250969001538 2380005 Beatrice H Wood Elementary   Regular School No Elementary 04 06 2017   grade_4 83 2 7 1   5     0   1   53 46                       99 83 2 7 1   5     0   1   53 46                 99
1121952 1121952 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No Elementary 01 04 2017   grade_4 130 2 7 1   2     0   1   73 70                       143 130 2 7 1   2     0   1   73 70                 143
1131947 1131947 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Becket Washington School   Regular School No Elementary PK 05 2017   grade_4 15 0 0 0   0     0   0   9 6                       15 15 0 0 0   0     0   0   9 6                 15
1126545 1126545 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2017   grade_4 40 16 13 0   44     0   3   60 56                       116 40 16 13 0   44     0   3   60 56                 116
1128288 1128288 MA Norfolk   school 2509870 243   Quincy 250987000772 2430020 Beechwood Knoll Elementary   Regular School No Elementary KG 05 2017   grade_4 31 0 0 0   26     0   1   23 35                       58 31 0 0 0   26     0   1   23 35                 58
1125143 1125143 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No Elementary KG 05 2017   grade_4 49 0 8 0   2     0   0   20 39                       59 49 0 8 0   2     0   0   20 39                 59
1122380 1122380 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial School   Regular School No Elementary 04 07 2017   grade_4 149 1 7 1   12     0   1   82 89                       171 149 1 7 1   12     0   1   82 89                 171
1130738 1130738 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2017   grade_4 16 8 35 0   4     0   2   29 36                       65 16 8 35 0   4     0   2   29 36                 65
1131178 1131178 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2017   grade_4 1 50 7 0   3     0   0   35 26                       61 1 50 7 0   3     0   0   35 26                 61
1131358 1131358 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 2017   grade_4 37 0 0 0   13     0   0   20 30                       50 37 0 0 0   13     0   0   20 30                 50
1128940 1128940 MA Middlesex   school 2510890 274   Somerville 251089001732 2740015 Benjamin G Brown   Regular School No Elementary KG 05 2017   grade_4 32 0 6 0   6     0   1   21 24                       45 32 0 6 0   6     0   1   21 24                 45
1121989 1121989 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2017   grade_4 60 4 6 0   1     0   3   33 41                       74 60 4 6 0   1     0   3   33 41                 74
1127141 1127141 MA Middlesex   school 2508340 198   Natick 250834001291 1980005 Bennett-Hemenway   Regular School No Elementary KG 04 2017   grade_4 96 4 2 0   10     0   11   63 60                       123 96 4 2 0   10     0   11   63 60                 123
1133175 1133175 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes Elementary KG 05 2017   grade_4 9 6 15 0   2     0   2   18 16                       34 9 6 15 0   2     0   2   18 16                 34
1122435 1122435 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No Elementary PK 04 2017   grade_4 91 0 1 0   1     0   2   48 47                       95 91 0 1 0   1     0   2   48 47                 95
1122447 1122447 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No Elementary PK 05 2017   grade_4 27 0 1 0   0     0   1   14 15                       29 27 0 1 0   0     0   1   14 15                 29
1132586 1132586 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Bernardston Elementary   Regular School No Elementary PK 06 2017   grade_4 19 0 0 0   0     0   2   11 10                       21 19 0 0 0   0     0   2   11 10                 21
1132204 1132204 MA Essex   school 2505670 675   Hamilton-Wenham 250567001459 6750007 Bessie Buker Elementary   Regular School No Elementary KG 05 2017   grade_4 36 0 0 0   2     0   1   21 18                       39 36 0 0 0   2     0   1   21 18                 39
1127369 1127369 MA Bristol   school 2508430 201   New Bedford 250843001319 2010140 Betsey B Winslow   Regular School No Elementary KG 05 2017   grade_4 34 2 9 0   5     0   8   25 33                       58 34 2 9 0   5     0   8   25 33                 58
1128443 1128443 MA Middlesex   school 2509990 246   Reading 250999001606 2460005 Birch Meadow   Regular School No Elementary KG 05 2017   grade_4 52 0 0 0   1     0   4   31 26                       57 52 0 0 0   1     0   4   31 26                 57
1123244 1123244 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No Elementary PK 05 2017   grade_4 1 21 76 0   0     0   1   44 55                       99 1 21 76 0   0     0   1   44 55                 99
1131690 1131690 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No Elementary KG 06 2017   grade_4 33 3 3 2   20     0   2   31 32                       63 33 3 3 2   20     0   2   31 32                 63
1126114 1126114 MA Hampden   school 2506990 159   Longmeadow 250699001016 1590005 Blueberry Hill   Regular School No Elementary KG 05 2017   grade_4 51 1 1 0   11     1   2   30 37                       67 51 1 1 0   11     1   2   30 37                 67
1131532 1131532 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2017   grade_4 0 79 35 0   1     0   0   55 60                       115 0 79 35 0   1     0   0   55 60                 115
1122594 1122594 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2017   grade_4 8 8 17 0   0     0   1   18 16                       34 8 8 17 0   0     0   1   18 16                 34
1123466 1123466 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No Elementary PK 04 2017   grade_4 67 1 3 0   1     0   2   41 33                       74 67 1 3 0   1     0   2   41 33                 74
1124137 1124137 MA Hampden   school 2503660 61   Chicopee 250366000492 610015 Bowe   Regular School No Elementary PK 05 2017   grade_4 26 6 40 1   1     0   3   41 36                       77 26 6 40 1   1     0   3   41 36                 77
1127429 1127429 MA Middlesex   school 2508610 207   Newton 250861001358 2070015 Bowen   Regular School No Elementary KG 05 2017   grade_4 41 6 3 0   14     0   4   41 27                       68 41 6 3 0   14     0   4   41 27                 68
1124144 1124144 MA Hampden   school 2503660 61   Chicopee 250366000493 610020 Bowie   Regular School No Elementary KG 05 2017   grade_4 52 1 12 0   1     0   2   32 36                       68 52 1 12 0   1     0   2   32 36                 68
1126025 1126025 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Bowman   Regular School No Elementary KG 05 2017   grade_4 56 8 2 0   40     0   9   57 58                       115 56 8 2 0   40     0   9   57 58                 115
1129864 1129864 MA Norfolk   school 2511970 307   Walpole 251197002563 3070010 Boyden   Regular School No Elementary KG 05 2017   grade_4 55 5 4 0   3     0   1   31 37                       68 55 5 4 0   3     0   1   31 37                 68
1123499 1123499 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No Elementary PK 05 2017   grade_4 46 2 1 0   4     0   2   25 30                       55 46 2 1 0   4     0   2   25 30                 55
1122135 1122135 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2017   grade_4 50 1 1 0   7     0   4   36 27                       63 50 1 1 0   7     0   4   36 27                 63
1125384 1125384 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Bradford Elementary   Regular School No Elementary KG 05 2017   grade_4 112 6 24 0   5     0   1   73 75                       148 112 6 24 0   5     0   1   73 75                 148
1127584 1127584 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No Elementary PK 07 2017   grade_4 35 2 3 0   0     0   3   17 26                       43 35 2 3 0   0     0   3   17 26                 43
1126377 1126377 MA Essex   school 2507110 163   Lynn 250711001064 1630020 Brickett Elementary   Regular School No Elementary 01 05 2017   grade_4 5 5 31 0   14     0   1   20 36                       56 5 5 31 0   14     0   1   20 36                 56
1126018 1126018 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Bridge   Regular School No Elementary KG 05 2017   grade_4 55 3 3 0   44     1   1   51 56                       107 55 3 3 0   44     1   1   51 56                 107
1131162 1131162 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 05 2017   grade_4 0 21 13 0   0     0   5   17 22                       39 0 21 13 0   0     0   5   17 22                 39
1127600 1127600 MA Hampshire   school 2508850 210   Northampton 250885001425 2100005 Bridge Street   Regular School No Elementary PK 05 2017   grade_4 26 1 4 0   4     0   4   16 23                       39 26 1 4 0   4     0   4   16 23                 39
1131786 1131786 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002368 6100025 Briggs Elementary   Regular School No Elementary PK 05 2017   grade_4 82 0 3 0   1     0   3   45 44                       89 82 0 3 0   1     0   3   45 44                 89
1129128 1129128 MA Hampden   school 2511130 281   Springfield 251113001796 2810025 Brightwood   Regular School No Elementary KG 05 2017   grade_4 1 8 47 0   0     0   0   31 25                       56 1 8 47 0   0     0   0   31 25                 56
1123573 1123573 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No Elementary PK 06 2017   grade_4 30 1 0 0   1     0   0   16 16                       32 30 1 0 0   1     0   0   16 16                 32
1127187 1127187 MA Norfolk   school 2508370 199   Needham 250837001306 1990005 Broadmeadow   Regular School No Elementary KG 05 2017   grade_4 87 1 5 0   6     0   8   51 56                       107 87 1 5 0   6     0   8   51 56                 107
1131204 1131204 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 09 2017   grade_4 13 95 73 2   4     0   4   102 89                       191 13 95 73 2   4     0   4   102 89                 191
1123604 1123604 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brookfield   Regular School No Elementary KG 05 2017   grade_4 30 61 8 1   4     1   1   56 50                       106 30 61 8 1   4     1   1   56 50                 106
1123718 1123718 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_4 33 0 1 0   0     0   5   19 20                       39 33 0 1 0   0     0   5   19 20                 39
1126808 1126808 MA Middlesex   school 2507560 176   Medford 250756002049 1760130 Brooks School   Regular School No Elementary PK 05 2017   grade_4 53 7 3 0   1     0   3   42 25                       67 53 7 3 0   1     0   3   42 25                 67
1124455 1124455 MA Middlesex   school 2504320 79   Dracut 250432000578 790035 Brookside Elementary   Regular School No Elementary KG 05 2017   grade_4 63 9 8 0   4     0   1   46 39                       85 63 9 8 0   4     0   1   46 39                 85
1124968 1124968 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2017   grade_4 33 7 47 0   4     0   3   45 49                       94 33 7 47 0   4     0   3   45 49                 94

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