enrollments

Data source: Big Local News · About: Big Local

6,218 rows where grade = "grade_5" and state = "MA" sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_5 · 6,218 ✖
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
2230208 2230208 MA Suffolk   school   35   Boston   350652               2018   grade_5 * * * *   *     *   *   * *                       0.0                                             0
739673 739673 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No 2 05 08 2015   grade_5 188 11 131 0   10     0   17   190 167                       357 188 11 131 0   10     0   17   190 167                 357
936517 936517 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No 2 05 08 2016   grade_5 180 12 162 0   17     0   10   202 179                       381 180 12 162 0   17     0   10   202 179                 381
1126675 1126675 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2017   grade_5 162 9 156 0   19     0   18   168 196                       364 162 9 156 0   19     0   18   168 196                 364
1368743 1368743 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2020   grade_5 158 13 215 0   8     0   19   198 215 *                     413.0 158 13 215 0   8     0   19   198 215                 413
2043813 2043813 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2019   grade_5 152 12 210 1   15     0   12   219 183                       402.0 152 12 210 1   15     0   12   219 183                 402
739416 739416 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No 1 KG 05 2015   grade_5 7 2 38 1   15     0   0   33 30                       63 7 2 38 1   15     0   0   33 30                 63
936264 936264 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No 1 KG 05 2016   grade_5 4 3 45 0   17     0   0   41 28                       69 4 3 45 0   17     0   0   41 28                 69
1126372 1126372 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary KG 05 2017   grade_5 1 5 43 0   13     0   1   31 32                       63 1 5 43 0   13     0   1   31 32                 63
1368489 1368489 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary PK 05 2020   grade_5 3 5 55 0   14     0   4   41 40 *                     81.0 3 5 55 0   14     0   4   41 40                 81
2043560 2043560 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary KG 05 2019   grade_5 6 13 78 0   15     0   1   57 56                       113.0 6 13 78 0   15     0   1   57 56                 113
740311 740311 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No 1 KG 05 2015   grade_5 33 7 7 0   10     0   7   36 28                       64 33 7 7 0   10     0   7   36 28                 64
937147 937147 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No 1 KG 05 2016   grade_5 51 4 5 0   12     0   2   36 38                       74 51 4 5 0   12     0   2   36 38                 74
1127423 1127423 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2017   grade_5 32 2 5 0   12     0   6   31 26                       57 32 2 5 0   12     0   6   31 26                 57
1369375 1369375 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2020   grade_5 61 3 7 0   18     0   8   40 57 *                     97.0 61 3 7 0   18     0   8   40 57                 97
2044448 2044448 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2019   grade_5 56 2 1 0   13     0   2   37 37                       74.0 56 2 1 0   13     0   2   37 37                 74
744101 744101 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No 2 04 05 2015   grade_5 99 1 5 0   1     0   3   49 60                       109 99 1 5 0   1     0   3   49 60                 109
940935 940935 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No 1 03 05 2016   grade_5 87 2 5 0   0     0   4   45 53                       98 87 2 5 0   0     0   4   45 53                 98
1131887 1131887 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No Elementary 03 05 2017   grade_5 79 3 4 1   0     0   4   49 42                       91 79 3 4 1   0     0   4   49 42                 91
1373162 1373162 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No Elementary 03 05 2020   grade_5 66 1 8 0   0     0   8   45 38 *                     83.0 66 1 8 0   0     0   8   45 38                 83
2048222 2048222 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No Elementary 03 05 2019   grade_5 86 3 9 0   2     0   5   50 55                       105.0 86 3 9 0   2     0   5   50 55                 105
741216 741216 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No 1 KG 05 2015   grade_5 66 3 32 0   8     0   4   52 61                       113 66 3 32 0   8     0   4   52 61                 113
938044 938044 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No 1 KG 05 2016   grade_5 81 4 44 1   9     0   1   69 71                       140 81 4 44 1   9     0   1   69 71                 140
1128485 1128485 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2017   grade_5 67 3 49 0   5     0   4   63 65                       128 67 3 49 0   5     0   4   63 65                 128
1370272 1370272 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2020   grade_5 52 3 49 0   6     1   3   60 54 *                     114.0 52 3 49 0   6     1   3   60 54                 114
2045345 2045345 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2019   grade_5 70 2 57 0   3     0   1   68 64                       133.0 70 2 57 0   3     0   1   68 64                 133
738078 738078 MA Bristol   school 2504830 95   Fall River 250483000276 950055 ACESE   Alternative Education School No 1 03 05 2015   grade_5 1 3 2 0   0     0   1   7 *                       7 1 3 2 0   0     0   1   7                   7
742730 742730 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No 1 03 05 2015   grade_5 90 3 1 1   21     0   2   59 59                       118 90 3 1 1   21     0   2   59 59                 118
939536 939536 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No 1 03 05 2016   grade_5 122 0 0 0   30     0   5   89 68                       157 122 0 0 0   30     0   5   89 68                 157
1130273 1130273 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No Elementary 03 05 2017   grade_5 100 1 0 3   16     0   3   58 65                       123 100 1 0 3   16     0   3   58 65                 123
1371766 1371766 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No Elementary 03 05 2020   grade_5 99 1 1 0   27     0   6   65 69 *                     134.0 99 1 1 0   27     0   6   65 69                 134
2046840 2046840 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No Elementary 03 05 2019   grade_5 84 0 2 1   28     0   2   47 70                       117.0 84 0 2 1   28     0   2   47 70                 117
738209 738209 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   grade_5 11 0 0 0   0     0   0   7 4                       11 11 0 0 0   0     0   0   7 4                 11
935063 935063 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2016   grade_5 * * * *   *     *   *   2 1                       3                         2 1                 3
1124925 1124925 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   grade_5 8 0 0 0   0     1   0   3 6                       9 8 0 0 0   0     1   0   3 6                 9
1367295 1367295 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2020   grade_5 * * * *   *     *   *   1 3 *                     4.0                         1 3                 4
2042367 2042367 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_5 10 0 0 0   0     0   0   6 4                       10.0 10 0 0 0   0     0   0   6 4                 10
1679928 1679928 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public (District) - Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2021   grade_5 28 61 18 0   2     0   6   59 56 *                     115.0 28 61 18 0   2     0   6   59 56                 115
2238163 2238163 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public (District): Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2018   grade_5 20 62 34 0   2     0   0   57 61                       118.0 20 62 34 0   2     0   0   57 61                 118
743607 743607 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 2015   grade_5 29 65 27 0   7     0   0   61 67                       128 29 65 27 0   7     0   0   61 67                 128
940430 940430 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_5 30 57 30 0   3     0   6   64 62                       126 30 57 30 0   3     0   6   64 62                 126
1131331 1131331 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_5 30 61 19 0   5     1   2   57 61                       118 30 61 19 0   5     1   2   57 61                 118
1372664 1372664 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 2020   grade_5 22 67 18 0   3     0   6   61 55 *                     116.0 22 67 18 0   3     0   6   61 55                 116
2047735 2047735 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2019   grade_5 14 78 22 0   4     0   0   52 66                       118.0 14 78 22 0   4     0   0   52 66                 118
742919 742919 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No 2 05 06 2015   grade_5 389 36 30 0   18     1   22   262 234                       496 389 36 30 0   18     1   22   262 234                 496
939725 939725 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No 2 05 06 2016   grade_5 378 25 36 2   17     1   15   245 229                       474 378 25 36 2   17     1   15   245 229                 474
1130508 1130508 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No Middle 05 06 2017   grade_5 360 30 52 2   24     1   12   235 246                       481 360 30 52 2   24     1   12   235 246                 481
1371952 1371952 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No Middle 05 08 2020   grade_5 293 37 48 1   24     1   18   193 229 *                     422.0 293 37 48 1   24     1   18   193 229                 422
2047027 2047027 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No Middle 05 06 2019   grade_5 319 30 50 1   33     0   21   240 214                       454.0 319 30 50 1   33     0   21   240 214                 454
1672014 1672014 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington - Abington Middle School   Regular School No Middle 05 08 2021   grade_5 109 7 15 0   5     0   4   58 82 *                     140.0 109 7 15 0   5     0   4   58 82                 140
1364790 1364790 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2020   grade_5 138 5 16 0   5     0   3   96 71 *                     167.0 138 5 16 0   5     0   3   96 71                 167
2039816 2039816 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2019   grade_5 134 4 14 2   4     0   1   85 74                       159.0 134 4 14 2   4     0   1   85 74                 159
2228763 2228763 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington: Abington Middle School   Regular School No Middle 05 08 2018   grade_5 138 1 8 1   3     0   3   80 74                       154.0 138 1 8 1   3     0   3   80 74                 154
742682 742682 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No 1 KG 05 2015   grade_5 32 0 9 0   0     0   0   22 19                       41 32 0 9 0   0     0   0   22 19                 41
939488 939488 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No 1 KG 05 2016   grade_5 32 0 7 0   3     0   0   20 22                       42 32 0 7 0   3     0   0   20 22                 42
1130216 1130216 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No Elementary KG 05 2017   grade_5 23 0 9 0   1     0   1   12 22                       34 23 0 9 0   1     0   1   12 22                 34
739410 739410 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No 1 KG 05 2015   grade_5 21 4 6 0   1     0   3   16 19                       35 21 4 6 0   1     0   3   16 19                 35
936258 936258 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No 1 KG 05 2016   grade_5 14 2 18 0   0     0   2   19 17                       36 14 2 18 0   0     0   2   19 17                 36
1126365 1126365 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2017   grade_5 17 5 15 0   1     0   3   21 20                       41 17 5 15 0   1     0   3   21 20                 41
1368482 1368482 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2020   grade_5 12 6 19 1   2     0   1   22 19 *                     41.0 12 6 19 1   2     0   1   22 19                 41
2043554 2043554 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2019   grade_5 17 6 17 1   3     0   2   24 22                       46.0 17 6 17 1   3     0   2   24 22                 46
740214 740214 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No 1 KG 05 2015   grade_5 60 10 30 0   1     0   2   52 51                       103 60 10 30 0   1     0   2   52 51                 103
741233 741233 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No 1 PK 05 2015   grade_5 39 8 45 0   4     0   3   55 44                       99 39 8 45 0   4     0   3   55 44                 99
937052 937052 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No 1 KG 05 2016   grade_5 55 9 22 1   1     0   12   50 50                       100 55 9 22 1   1     0   12   50 50                 100
938061 938061 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No 1 PK 05 2016   grade_5 40 6 40 0   1     0   2   37 52                       89 40 6 40 0   1     0   2   37 52                 89
1127310 1127310 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2017   grade_5 72 12 35 1   1     0   6   76 51                       127 72 12 35 1   1     0   6   76 51                 127
1128505 1128505 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2017   grade_5 43 7 35 0   3     0   2   50 40                       90 43 7 35 0   3     0   2   50 40                 90
1369275 1369275 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2020   grade_5 50 11 40 1   0     0   8   56 54 *                     110.0 50 11 40 1   0     0   8   56 54                 110
1370289 1370289 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2020   grade_5 27 5 46 0   3     0   0   42 39 *                     81.0 27 5 46 0   3     0   0   42 39                 81
2044348 2044348 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2019   grade_5 67 10 33 0   1     0   4   60 55                       115.0 67 10 33 0   1     0   4   60 55                 115
2045362 2045362 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2019   grade_5 41 7 55 0   4     0   2   53 56                       109.0 41 7 55 0   4     0   2   53 56                 109
1679731 1679731 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public (District) - Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2021   grade_5 0 34 18 0   0     1   0   28 25 *                     53.0 0 34 18 0   0     1   0   28 25                 53
2237952 2237952 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public (District): Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2018   grade_5 9 46 23 0   1     0   1   38 42                       80.0 9 46 23 0   1     0   1   38 42                 80
743426 743426 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes 4 05 12 2015   grade_5 16 41 19 0   0     0   1   38 39                       77 16 41 19 0   0     0   1   38 39                 77
940247 940247 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes 4 05 12 2016   grade_5 4 39 24 0   0     0   7   35 39                       74 4 39 24 0   0     0   7   35 39                 74
1131125 1131125 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes Other 05 12 2017   grade_5 5 41 32 0   1     0   0   35 44                       79 5 41 32 0   1     0   0   35 44                 79
1372468 1372468 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2020   grade_5 6 43 16 0   1     0   0   31 35 *                     66.0 6 43 16 0   1     0   0   31 35                 66
2047541 2047541 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2019   grade_5 8 49 14 0   0     0   1   46 26                       72.0 8 49 14 0   0     0   1   46 26                 72
1680250 1680250 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Acton-Boxborough - Blanchard Memorial School   Regular School No Elementary KG 06 2021   grade_5 34 2 2 0   23     0   3   36 28 *                     64.0 34 2 2 0   23     0   3   36 28                 64
1680271 1680271 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 Acton-Boxborough - C.T. Douglas Elementary School   Regular School No Elementary KG 06 2021   grade_5 45 3 2 0   12     0   4   31 35 *                     66.0 45 3 2 0   12     0   4   31 35                 66
1680285 1680285 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Acton-Boxborough - Luther Conant School   Regular School No Elementary KG 06 2021   grade_5 13 1 4 0   28     0   1   28 19 *                     47.0 13 1 4 0   28     0   1   28 19                 47
1680264 1680264 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 Acton-Boxborough - McCarthy-Towne School   Regular School No Elementary KG 06 2021   grade_5 49 2 3 0   14     0   3   31 40 *                     71.0 49 2 3 0   14     0   3   31 40                 71
1680257 1680257 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Acton-Boxborough - Merriam School   Regular School No Elementary KG 06 2021   grade_5 50 1 4 0   11     0   5   40 31 *                     71.0 50 1 4 0   11     0   5   40 31                 71
1680278 1680278 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Acton-Boxborough - Paul P Gates Elementary School   Regular School No Elementary KG 06 2021   grade_5 12 4 3 0   52     0   0   42 29 *                     71.0 12 4 3 0   52     0   0   42 29                 71
2238528 2238528 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Acton-Boxborough: Blanchard Memorial School   Regular School No Elementary KG 06 2018   grade_5 35 3 2 2   25     0   2   36 33                       69.0 35 3 2 2   25     0   2   36 33                 69
2238552 2238552 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 Acton-Boxborough: C.T. Douglas Elementary School   Regular School No Elementary KG 06 2018   grade_5 46 0 2 0   15     1   5   39 30                       69.0 46 0 2 0   15     1   5   39 30                 69
2238568 2238568 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Acton-Boxborough: Luther Conant School   Regular School No Elementary KG 06 2018   grade_5 18 2 7 0   63     1   2   40 53                       93.0 18 2 7 0   63     1   2   40 53                 93
2238544 2238544 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 Acton-Boxborough: McCarthy-Towne School   Regular School No Elementary KG 06 2018   grade_5 50 1 9 0   7     0   3   34 36                       70.0 50 1 9 0   7     0   3   34 36                 70
2238536 2238536 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Acton-Boxborough: Merriam School   Regular School No Elementary KG 06 2018   grade_5 52 3 6 0   10     0   1   35 37                       72.0 52 3 6 0   10     0   1   35 37                 72
2238560 2238560 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Acton-Boxborough: Paul P Gates Elementary School   Regular School No Elementary KG 06 2018   grade_5 20 2 0 1   22     0   2   22 25                       47.0 20 2 0 1   22     0   2   22 25                 47
1672029 1672029 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet - Albert F Ford Middle School   Regular School No Middle 05 08 2021   grade_5 96 0 3 0   1     0   8   57 51 *                     108.0 96 0 3 0   1     0   8   57 51                 108
2228780 2228780 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet: Albert F Ford Middle School   Regular School No Middle 05 08 2018   grade_5 100 1 2 0   0     0   0   59 44                       103.0 100 1 2 0   0     0   0   59 44                 103
2238586 2238586 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Adams-Cheshire: Hoosac Valley Middle School   Regular School No Middle 04 07 2018   grade_5 95 6 5 0   0     0   0   56 50                       106.0 95 6 5 0   0     0   0   56 50                 106
1368462 1368462 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_5 * * * *   *     *   *   * * *                     0.0                                             0
1672054 1672054 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Agawam - Roberta G. Doering School   Regular School No Middle 05 08 2021   grade_5 215 3 24 0   6     0   6   132 122 *                     254.0 215 3 24 0   6     0   6   132 122                 254
2228811 2228811 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Agawam: Roberta G. Doering School   Regular School No Middle 05 08 2018   grade_5 237 10 14 0   5     0   5   131 140                       271.0 237 10 14 0   5     0   5   131 140                 271
735679 735679 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No 2 05 08 2015   grade_5 76 0 2 0   0     0   0   40 38                       78 76 0 2 0   0     0   0   40 38                 78
932557 932557 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No 2 05 08 2016   grade_5 115 0 1 0   0     0   0   62 54                       116 115 0 1 0   0     0   0   62 54                 116
1121972 1121972 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2017   grade_5 103 1 0 0   0     0   1   58 47                       105 103 1 0 0   0     0   1   58 47                 105
1364805 1364805 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2020   grade_5 97 0 8 0   1     0   4   49 61 *                     110.0 97 0 8 0   1     0   4   49 61                 110

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