enrollments

Data source: Big Local News · About: Big Local

956 rows where grade = "grade_4", state = "MA" and year = 2016 sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 956 ✖

grade ✖

  • grade_4 · 956 ✖
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
936263 936263 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No 1 KG 05 2016   grade_4 3 4 51 0   12     0   1   30 41                       71 3 4 51 0   12     0   1   30 41                 71
937146 937146 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No 1 KG 05 2016   grade_4 33 3 4 0   12     0   7   29 30                       59 33 3 4 0   12     0   7   29 30                 59
940934 940934 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No 1 03 05 2016   grade_4 75 2 5 1   0     0   4   46 41                       87 75 2 5 1   0     0   4   46 41                 87
938043 938043 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No 1 KG 05 2016   grade_4 70 3 41 0   6     0   4   59 65                       124 70 3 41 0   6     0   4   59 65                 124
932750 932750 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No 1 KG 04 2016   grade_4 59 1 29 1   4     0   7   51 50                       101 59 1 29 1   4     0   7   51 50                 101
939535 939535 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No 1 03 05 2016   grade_4 99 1 0 0   15     0   3   54 64                       118 99 1 0 0   15     0   3   54 64                 118
935062 935062 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2016   grade_4 8 0 0 0   0     1   0   3 6                       9 8 0 0 0   0     1   0   3 6                 9
940429 940429 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2016   grade_4 31 60 22 0   5     1   3   59 63                       122 31 60 22 0   5     1   3   59 63                 122
939487 939487 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No 1 KG 05 2016   grade_4 22 0 6 0   1     0   1   11 19                       30 22 0 6 0   1     0   1   11 19                 30
936257 936257 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No 1 KG 05 2016   grade_4 17 5 22 0   0     0   4   24 24                       48 17 5 22 0   0     0   4   24 24                 48
936114 936114 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No 1 PK 04 2016   grade_4 14 8 32 0   55     0   5   56 58                       114 14 8 32 0   55     0   5   56 58                 114
937051 937051 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No 1 KG 05 2016   grade_4 75 15 35 1   2     0   3   68 63                       131 75 15 35 1   2     0   3   68 63                 131
938060 938060 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No 1 PK 05 2016   grade_4 43 6 34 0   4     0   2   50 39                       89 43 6 34 0   4     0   2   50 39                 89
939686 939686 MA Norfolk   school 2512840 336   Weymouth 251284002103 3360005 Academy Avenue   Regular School No 1 KG 04 2016   grade_4 57 2 6 0   5     0   0   31 39                       70 57 2 6 0   5     0   0   31 39                 70
932556 932556 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No 1 PK 04 2016   grade_4 103 1 0 0   0     0   0   57 47                       104 103 1 0 0   0     0   0   57 47                 104
938444 938444 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No 1 PK 08 2016   grade_4 18 4 31 0   10     0   3   36 30                       66 18 4 31 0   10     0   3   36 30                 66
934503 934503 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Alcott   Regular School No 1 PK 05 2016   grade_4 47 6 8 1   4     0   7   30 43                       73 47 6 8 1   4     0   7   30 43                 73
934686 934686 MA Plymouth   school 2504410 82   Duxbury 250441000968 820004 Alden School   Regular School No 1 03 05 2016   grade_4 215 1 3 0   5     0   12   116 120                       236 215 1 3 0   5     0   12   116 120                 236
935754 935754 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No 1 03 08 2016   grade_4 2 3 79 0   2     0   0   41 45                       86 2 3 79 0   2     0   0   41 45                 86
938653 938653 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No 1 PK 08 2016   grade_4 11 15 14 0   0     0   2   18 24                       42 11 15 14 0   0     0   2   18 24                 42
937027 937027 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 Alfred J Gomes   Regular School No 1 PK 05 2016   grade_4 17 10 46 0   0     0   2   37 38                       75 17 10 46 0   0     0   2   37 38                 75
938725 938725 MA Hampden   school 2511130 281   Springfield 251113001792 2810175 Alice B Beal Elementary   Regular School No 1 KG 05 2016   grade_4 7 2 19 0   4     0   0   15 17                       32 7 2 19 0   4     0   0   15 17                 32
938003 938003 MA Middlesex   school 2509990 246   Reading 250999001604 2460002 Alice M Barrows   Regular School No 1 KG 05 2016   grade_4 57 1 0 1   4     0   3   30 36                       66 57 1 0 1   4     0   3   30 36                 66
937722 937722 MA Berkshire   school 2509630 236   Pittsfield 250963001516 2360010 Allendale   Regular School No 1 KG 05 2016   grade_4 39 1 4 0   0     0   4   29 19                       48 39 1 4 0   0     0   4   29 19                 48
940232 940232 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes 1 KG 06 2016   grade_4 18 6 14 1   0     0   3   19 23                       42 18 6 14 1   0     0   3   19 23                 42
939824 939824 MA Middlesex   school 2513110 344   Winchester 251311002164 3440045 Ambrose Elementary   Regular School No 1 KG 05 2016   grade_4 73 0 0 0   4     0   3   36 44                       80 73 0 0 0   4     0   3   36 44                 80
932597 932597 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No 1 PK 04 2016   grade_4 71 1 7 0   0     0   2   34 47                       81 71 1 7 0   0     0   2   34 47                 81
934174 934174 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No 1 PK 08 2016   grade_4 15 0 19 0   1     1   2   13 25                       38 15 0 19 0   1     1   2   13 25                 38
937367 937367 MA Bristol   school 2508730 212   North Attleborough 250873001401 2120007 Amvet Boulevard   Regular School No 1 KG 05 2016   grade_4 67 0 2 0   5     0   2   37 39                       76 67 0 2 0   5     0   2   37 39                 76
939744 939744 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No 1 PK 06 2016   grade_4 27 0 0 0   0     0   0   15 12                       27 27 0 0 0   0     0   0   15 12                 27
937348 937348 MA Essex   school 2508700 211   North Andover 250870000767 2110018 Annie L Sargent School   Regular School No 1 KG 05 2016   grade_4 78 3 4 1   5     0   1   59 33                       92 78 3 4 1   5     0   1   59 33                 92
933891 933891 MA Norfolk   school 2502940 40   Braintree 250294000360 400033 Archie T Morrison   Regular School No 1 KG 05 2016   grade_4 45 2 4 0   12     0   0   29 34                       63 45 2 4 0   12     0   0   29 34                 63
938424 938424 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No 1 PK 08 2016   grade_4 20 5 23 0   3     0   1   21 31                       52 20 5 23 0   3     0   1   21 31                 52
938719 938719 MA Hampden   school 2511130 281   Springfield 251113001795 2810165 Arthur T Talmadge   Regular School No 1 KG 05 2016   grade_4 11 17 23 0   0     0   1   35 17                       52 11 17 23 0   0     0   1   35 17                 52
939838 939838 MA Suffolk   school 2513170 346   Winthrop 251317001841 3460020 Arthur T. Cummings Elementary School   Regular School No 2 04 07 2016   grade_4 129 1 24 0   2     0   3   90 69                       159 129 1 24 0   2     0   3   90 69                 159
941459 941459 MA Middlesex   school 2508790 735   North Middlesex 250879001412 7350010 Ashby Elementary   Regular School No 1 KG 04 2016   grade_4 36 1 0 0   0     0   1   18 20                       38 36 1 0 0   0     0   1   18 20                 38
937896 937896 MA Norfolk   school 2509870 243   Quincy 250987001560 2430040 Atherton Hough   Regular School No 1 KG 05 2016   grade_4 37 1 4 0   2     0   4   26 22                       48 37 1 4 0   2     0   4   26 22                 48
937330 937330 MA Essex   school 2508700 211   North Andover 250870001393 2110001 Atkinson   Regular School No 1 PK 05 2016   grade_4 40 6 11 0   7     0   1   28 37                       65 40 6 11 0   7     0   1   28 37                 65
940700 940700 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 10 2016   grade_4 82 4 10 0   2     0   1   46 53                       99 82 4 10 0   2     0   1   46 53                 99
934599 934599 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No 1 01 05 2016   grade_4 32 3 13 0   3     0   2   28 25                       53 32 3 13 0   3     0   2   28 25                 53
932979 932979 MA Essex   school 2502640 30   Beverly 250264000175 300055 Ayers/Ryal Side School   Regular School No 1 KG 05 2016   grade_4 61 2 8 0   2     0   1   38 36                       74 61 2 8 0   2     0   1   38 36                 74
937526 937526 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No 1 01 05 2016   grade_4 31 3 11 0   2     0   2   24 25                       49 31 3 11 0   2     0   2   24 25                 49
941390 941390 MA Worcester   school 2508280 720   Narragansett 250828001283 7200005 Baldwinville Elementary   Regular School No 1 02 04 2016   grade_4 82 0 1 0   0     0   2   43 42                       85 82 0 1 0   0     0   2   43 42                 85
932641 932641 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No 1 KG 05 2016   grade_4 85 4 8 0   6     0   4   49 58                       107 85 4 8 0   6     0   4   49 58                 107
935115 935115 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No 1 KG 05 2016   grade_4 25 0 83 0   0     0   1   54 55                       109 25 0 83 0   0     0   1   54 55                 109
932842 932842 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable United Elementary School   Regular School No 2 04 05 2016   grade_4 307 27 52 0   9     0   18   227 186                       413 307 27 52 0   9     0   18   227 186                 413
934390 934390 MA Hampden   school 2503660 61   Chicopee 250366000489 610003 Barry   Regular School No 1 KG 05 2016   grade_4 42 1 25 0   0     0   3   42 29                       71 42 1 25 0   0     0   3   42 29                 71
936173 936173 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No 1 PK 08 2016   grade_4 9 5 23 0   22     0   4   30 33                       63 9 5 23 0   22     0   4   30 33                 63
938161 938161 MA Essex   school 2510380 258   Salem 251038001653 2580003 Bates   Regular School No 1 KG 05 2016   grade_4 29 3 15 0   0     0   1   20 28                       48 29 3 15 0   0     0   1   20 28                 48
938050 938050 MA Suffolk   school 2510050 248   Revere 251005001962 2480013 Beachmont Veterans Memorial School   Regular School No 1 PK 05 2016   grade_4 20 4 29 0   1     0   0   31 23                       54 20 4 29 0   1     0   0   31 23                 54
937784 937784 MA Norfolk   school 2509690 238   Plainville 250969001538 2380005 Beatrice H Wood Elementary   Regular School No 2 04 06 2016   grade_4 99 1 6 1   7     0   1   52 63                       115 99 1 6 1   7     0   1   52 63                 115
932541 932541 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No 1 01 04 2016   grade_4 169 4 8 0   0     0   2   98 85                       183 169 4 8 0   0     0   2   98 85                 183
940981 940981 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Becket Washington School   Regular School No 1 PK 05 2016   grade_4 16 0 0 0   0     0   1   7 10                       17 16 0 0 0   0     0   1   7 10                 17
936409 936409 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No 1 KG 08 2016   grade_4 30 14 8 0   39     1   1   47 46                       93 30 14 8 0   39     1   1   47 46                 93
937879 937879 MA Norfolk   school 2509870 243   Quincy 250987000772 2430020 Beechwood Knoll Elementary   Regular School No 1 KG 05 2016   grade_4 39 0 1 0   23     0   1   25 39                       64 39 0 1 0   23     0   1   25 39                 64
935242 935242 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No 1 KG 05 2016   grade_4 41 1 7 0   4     0   3   33 23                       56 41 1 7 0   4     0   3   33 23                 56
932890 932890 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial School   Regular School No 2 04 07 2016   grade_4 164 1 7 0   9     0   4   96 89                       185 164 1 7 0   9     0   4   96 89                 185
939914 939914 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No 1 PK 06 2016   grade_4 10 19 39 2   12     0   3   35 50                       85 10 19 39 2   12     0   3   35 50                 85
940291 940291 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes 1 KG 06 2016   grade_4 3 40 5 1   0     0   1   16 34                       50 3 40 5 1   0     0   1   16 34                 50
940455 940455 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes 1 KG 08 2016   grade_4 39 1 2 1   8     0   1   23 29                       52 39 1 2 1   8     0   1   23 29                 52
938416 938416 MA Middlesex   school 2510890 274   Somerville 251089001732 2740015 Benjamin G Brown   Regular School No 1 KG 06 2016   grade_4 30 1 3 0   2     0   2   23 15                       38 30 1 3 0   2     0   2   23 15                 38
932571 932571 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No 1 KG 04 2016   grade_4 56 4 2 0   3     0   1   34 32                       66 56 4 2 0   3     0   1   34 32                 66
936911 936911 MA Middlesex   school 2508340 198   Natick 250834001291 1980005 Bennett-Hemenway   Regular School No 1 KG 04 2016   grade_4 110 2 1 0   9     0   6   67 61                       128 110 2 1 0   9     0   6   67 61                 128
942007 942007 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes 1 KG 05 2016   grade_4 7 3 24 0   1     0   1   17 19                       36 7 3 24 0   1     0   1   17 19                 36
932938 932938 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No 1 PK 04 2016   grade_4 80 1 1 0   0     0   0   40 42                       82 80 1 1 0   0     0   0   40 42                 82
932948 932948 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No 1 PK 05 2016   grade_4 32 0 2 0   2     0   3   26 13                       39 32 0 2 0   2     0   3   26 13                 39
941519 941519 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Bernardston Elementary   Regular School No 1 PK 06 2016   grade_4 25 0 0 0   0     0   1   15 11                       26 25 0 0 0   0     0   1   15 11                 26
941194 941194 MA Essex   school 2505670 675   Hamilton-Wenham 250567001459 6750007 Bessie Buker Elementary   Regular School No 1 KG 05 2016   grade_4 35 0 3 0   2     0   0   18 22                       40 35 0 3 0   2     0   0   18 22                 40
937102 937102 MA Bristol   school 2508430 201   New Bedford 250843001319 2010140 Betsey B Winslow   Regular School No 1 KG 05 2016   grade_4 27 5 2 0   1     0   4   15 24                       39 27 5 2 0   1     0   4   15 24                 39
938009 938009 MA Middlesex   school 2509990 246   Reading 250999001606 2460005 Birch Meadow   Regular School No 1 KG 05 2016   grade_4 64 2 4 0   1     0   2   37 36                       73 64 2 4 0   1     0   2   37 36                 73
933640 933640 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No 1 PK 05 2016   grade_4 1 15 64 0   0     0   1   36 45                       81 1 15 64 0   0     0   1   36 45                 81
940759 940759 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No 1 PK 06 2016   grade_4 38 2 2 0   26     0   3   42 29                       71 38 2 2 0   26     0   3   42 29                 71
936051 936051 MA Hampden   school 2506990 159   Longmeadow 250699001016 1590005 Blueberry Hill   Regular School No 1 KG 05 2016   grade_4 50 2 1 0   15     0   4   32 40                       72 50 2 1 0   15     0   4   32 40                 72
940625 940625 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes 1 PK 06 2016   grade_4 3 79 38 0   0     0   3   56 67                       123 3 79 38 0   0     0   3   56 67                 123
933071 933071 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No 1 PK 08 2016   grade_4 10 7 14 1   1     0   0   8 25                       33 10 7 14 1   1     0   0   8 25                 33
933834 933834 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No 1 PK 04 2016   grade_4 65 0 3 1   0     0   2   40 31                       71 65 0 3 1   0     0   2   40 31                 71
934400 934400 MA Hampden   school 2503660 61   Chicopee 250366000492 610015 Bowe   Regular School No 1 PK 05 2016   grade_4 23 4 32 0   0     0   2   27 34                       61 23 4 32 0   0     0   2   27 34                 61
937152 937152 MA Middlesex   school 2508610 207   Newton 250861001358 2070015 Bowen   Regular School No 1 KG 05 2016   grade_4 34 2 4 0   25     0   6   33 38                       71 34 2 4 0   25     0   6   33 38                 71
934406 934406 MA Hampden   school 2503660 61   Chicopee 250366000493 610020 Bowie   Regular School No 1 KG 05 2016   grade_4 41 2 12 0   0     0   4   27 32                       59 41 2 12 0   0     0   4   27 32                 59
935977 935977 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Bowman   Regular School No 1 KG 05 2016   grade_4 49 4 4 0   40     0   7   52 52                       104 49 4 4 0   40     0   7   52 52                 104
939189 939189 MA Norfolk   school 2511970 307   Walpole 251197002563 3070010 Boyden   Regular School No 1 KG 05 2016   grade_4 68 8 5 1   5     0   0   47 40                       87 68 8 5 1   5     0   0   47 40                 87
933861 933861 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No 1 PK 05 2016   grade_4 48 2 2 0   1     0   0   27 26                       53 48 2 2 0   1     0   0   27 26                 53
932692 932692 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No 1 KG 05 2016   grade_4 62 1 4 0   9     0   7   43 40                       83 62 1 4 0   9     0   7   43 40                 83
935423 935423 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Bradford Elementary   Regular School No 1 KG 05 2016   grade_4 127 10 20 0   2     0   2   81 80                       161 127 10 20 0   2     0   2   81 80                 161
937283 937283 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No 1 PK 07 2016   grade_4 24 1 2 0   1     0   4   16 16                       32 24 1 2 0   1     0   4   16 16                 32
936268 936268 MA Essex   school 2507110 163   Lynn 250711001064 1630020 Brickett Elementary   Regular School No 1 01 05 2016   grade_4 9 7 29 0   4     0   9   35 23                       58 9 7 29 0   4     0   9   35 23                 58
935971 935971 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Bridge   Regular School No 1 KG 05 2016   grade_4 40 5 4 0   35     0   7   46 45                       91 40 5 4 0   35     0   7   46 45                 91
940280 940280 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes 1 PK 04 2016   grade_4 0 23 9 0   1     0   1   14 20                       34 0 23 9 0   1     0   1   14 20                 34
937298 937298 MA Hampshire   school 2508850 210   Northampton 250885001425 2100005 Bridge Street   Regular School No 1 PK 05 2016   grade_4 27 1 5 1   2     0   0   20 16                       36 27 1 5 1   2     0   0   20 16                 36
940843 940843 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002368 6100025 Briggs Elementary   Regular School No 1 PK 05 2016   grade_4 66 1 2 0   0     0   0   39 30                       69 66 1 2 0   0     0   0   39 30                 69
938580 938580 MA Hampden   school 2511130 281   Springfield 251113001796 2810025 Brightwood   Regular School No 1 KG 05 2016   grade_4 0 9 51 0   0     0   1   31 30                       61 0 9 51 0   0     0   1   31 30                 61
933923 933923 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No 1 PK 06 2016   grade_4 42 0 0 0   2     0   0   18 26                       44 42 0 0 0   2     0   0   18 26                 44
936949 936949 MA Norfolk   school 2508370 199   Needham 250837001306 1990005 Broadmeadow   Regular School No 1 KG 05 2016   grade_4 67 1 6 0   11     0   6   51 40                       91 67 1 6 0   11     0   6   51 40                 91
940523 940523 MA Suffolk   school 2500539 457   Brooke Charter School East Boston (District) 250053902720 4570205 Brooke Charter School East Boston   Regular School Yes 1 KG 08 2016   grade_4 11 15 29 0   3     0   2   22 38                       60 11 15 29 0   3     0   2   22 38                 60
940410 940410 MA Suffolk   school 2500528 443   Brooke Charter School Mattapan (District) 250052802711 4430205 Brooke Charter School Mattapan   Regular School Yes 1 KG 08 2016   grade_4 0 45 19 0   0     0   0   32 32                       64 0 45 19 0   0     0   0   32 32                 64
940312 940312 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School Roslindale   Regular School Yes 1 KG 08 2016   grade_4 0 40 17 0   0     0   0   32 25                       57 0 40 17 0   0     0   0   32 25                 57
933949 933949 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brookfield   Regular School No 1 KG 05 2016   grade_4 36 51 15 0   1     0   2   57 48                       105 36 51 15 0   1     0   2   57 48                 105
934042 934042 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No 1 PK 06 2016   grade_4 40 0 1 0   0     0   1   25 17                       42 40 0 1 0   0     0   1   25 17                 42
936627 936627 MA Middlesex   school 2507560 176   Medford 250756002049 1760130 Brooks School   Regular School No 1 PK 05 2016   grade_4 65 10 4 0   3     0   5   44 43                       87 65 10 4 0   3     0   5   44 43                 87
934669 934669 MA Middlesex   school 2504320 79   Dracut 250432000578 790035 Brookside Elementary   Regular School No 1 KG 05 2016   grade_4 59 7 4 1   6     0   0   33 44                       77 59 7 4 1   6     0   0   33 44                 77

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