Data source: Big Local News · About: Big Local

6,679 rows where grade = "grade_4" and state = "MA" sorted by school

View and edit SQL

year

grade

  • grade_4 · 6,679
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
2230207 MA Suffolk   school   35   Boston   350652               2018   grade_4 * * * *   *     *   *   * *                       0.0                                             0
739415 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No 1 KG 05 2015   grade_4 8 3 48 0   16     0   0   46 29                       75 8 3 48 0   16     0   0   46 29                 75
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
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
1368488 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary PK 05 2020   grade_4 5 3 57 0   14     0   2   45 36 *                     81.0 5 3 57 0   14     0   2   45 36                 81
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
740310 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No 1 KG 05 2015   grade_4 53 4 5 0   11     0   2   37 38                       75 53 4 5 0   11     0   2   37 38                 75
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
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
1369374 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2020   grade_4 63 1 5 0   10     0   3   37 45 *                     82.0 63 1 5 0   10     0   3   37 45                 82
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
744100 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No 2 04 05 2015   grade_4 85 2 5 0   0     0   5   44 53                       97 85 2 5 0   0     0   5   44 53                 97
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
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
1373161 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No Elementary 03 05 2020   grade_4 105 4 7 0   1     0   6   72 51 *                     123.0 105 4 7 0   1     0   6   72 51                 123
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
741215 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No 1 KG 05 2015   grade_4 83 4 43 1   10     0   0   70 71                       141 83 4 43 1   10     0   0   70 71                 141
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
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
1370271 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2020   grade_4 55 2 61 0   4     0   2   65 59 *                     124.0 55 2 61 0   4     0   2   65 59                 124
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
735874 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No 1 KG 04 2015   grade_4 52 0 21 1   1     0   4   37 42                       79 52 0 21 1   1     0   4   37 42                 79
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
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
1364998 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2020   grade_4 57 5 12 1   4     1   8   53 35 *                     88.0 57 5 12 1   4     1   8   53 35                 88
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
738077 MA Bristol   school 2504830 95   Fall River 250483000276 950055 ACESE   Alternative Education School No 1 03 05 2015   grade_4 * * * *   *     *   *   4 *                       4                         4                   4
742729 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No 1 03 05 2015   grade_4 126 0 0 0   27     0   5   89 69                       158 126 0 0 0   27     0   5   89 69                 158
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
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
1371765 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No Elementary 03 05 2020   grade_4 91 0 1 0   39     0   5   61 75 *                     136.0 91 0 1 0   39     0   5   61 75                 136
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
738208 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   grade_4 * * * *   *     *   *   2 2                       4                         2 2                 4
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
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
1367294 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2020   grade_4 8 0 0 0   0     0   0   4 4 *                     8.0 8 0 0 0   0     0   0   4 4                 8
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
1679927 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_4 21 57 34 0   3     0   2   48 69 *                     117.0 21 57 34 0   3     0   2   48 69                 117
2238162 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_4 14 81 23 0   4     0   0   53 69                       122.0 14 81 23 0   4     0   0   53 69                 122
743606 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_4 30 53 29 0   3     0   6   60 61                       121 30 53 29 0   3     0   6   60 61                 121
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
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
1372663 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_4 28 62 20 0   2     0   4   59 57 *                     116.0 28 62 20 0   2     0   4   59 57                 116
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
1672010 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Abington - Woodsdale Elementary School   Regular School No Elementary 03 04 2021   grade_4 129 7 20 2   2     1   1   83 79 *                     162.0 129 7 20 2   2     1   1   83 79                 162
2228757 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Abington: Woodsdale Elementary School   Regular School No Elementary 03 04 2018   grade_4 129 5 13 1   2     0   1   79 72                       151.0 129 5 13 1   2     0   1   79 72                 151
742681 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No 1 KG 05 2015   grade_4 29 0 5 0   3     0   0   16 21                       37 29 0 5 0   3     0   0   16 21                 37
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
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
1371730 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No Elementary KG 04 2020   grade_4 21 4 12 0   3     0   0   20 20 *                     40.0 21 4 12 0   3     0   0   20 20                 40
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
739409 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No 1 KG 05 2015   grade_4 13 2 18 0   0     0   4   20 17                       37 13 2 18 0   0     0   4   20 17                 37
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
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
1368481 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2020   grade_4 11 4 11 0   3     0   8   18 19 *                     37.0 11 4 11 0   3     0   8   18 19                 37
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
739267 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No 1 PK 04 2015   grade_4 8 2 31 0   32     0   4   35 42                       77 8 2 31 0   32     0   4   35 42                 77
740213 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No 1 KG 05 2015   grade_4 60 10 26 1   1     0   10   56 52                       108 60 10 26 1   1     0   10   56 52                 108
741232 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No 1 PK 05 2015   grade_4 42 6 37 0   1     0   4   41 49                       90 42 6 37 0   1     0   4   41 49                 90
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 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 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
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 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 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
1368318 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2020   grade_4 16 6 31 0   29     0   3   47 38 *                     85.0 16 6 31 0   29     0   3   47 38                 85
1369274 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2020   grade_4 69 14 42 0   2     0   4   63 68 *                     131.0 69 14 42 0   2     0   4   63 68                 131
1370288 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2020   grade_4 40 4 40 0   3     0   0   49 38 *                     87.0 40 4 40 0   3     0   0   49 38                 87
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 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 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
742881 MA Norfolk   school 2512840 336   Weymouth 251284002103 3360005 Academy Avenue   Regular School No 1 KG 04 2015   grade_4 51 2 6 0   4     1   0   26 38                       64 51 2 6 0   4     1   0   26 38                 64
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
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
1371914 MA Norfolk   school 2512840 336   Weymouth 251284002103 3360005 Academy Avenue   Regular School No Elementary KG 04 2020   grade_4 43 5 3 0   2     0   2   23 32 *                     55.0 43 5 3 0   2     0   2   23 32                 55
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
1680249 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Acton-Boxborough - Blanchard Memorial School   Regular School No Elementary KG 06 2021   grade_4 43 0 5 0   22     0   2   40 32 *                     72.0 43 0 5 0   22     0   2   40 32                 72
1680270 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 Acton-Boxborough - C.T. Douglas Elementary School   Regular School No Elementary KG 06 2021   grade_4 38 0 5 0   5     0   2   21 28 *                     50.0 38 0 5 0   5     0   2   21 28                 50
1680284 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Acton-Boxborough - Luther Conant School   Regular School No Elementary KG 06 2021   grade_4 19 3 5 0   44     0   2   31 42 *                     73.0 19 3 5 0   44     0   2   31 42                 73
1680263 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 Acton-Boxborough - McCarthy-Towne School   Regular School No Elementary KG 06 2021   grade_4 47 0 5 0   10     0   8   38 32 *                     70.0 47 0 5 0   10     0   8   38 32                 70
1680256 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Acton-Boxborough - Merriam School   Regular School No Elementary KG 06 2021   grade_4 51 4 4 0   6     0   5   31 39 *                     70.0 51 4 4 0   6     0   5   31 39                 70
1680277 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Acton-Boxborough - Paul P Gates Elementary School   Regular School No Elementary KG 06 2021   grade_4 22 0 7 0   38     0   2   34 35 *                     69.0 22 0 7 0   38     0   2   34 35                 69
2238527 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Acton-Boxborough: Blanchard Memorial School   Regular School No Elementary KG 06 2018   grade_4 31 0 2 0   17     0   0   18 32                       50.0 31 0 2 0   17     0   0   18 32                 50
2238551 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 Acton-Boxborough: C.T. Douglas Elementary School   Regular School No Elementary KG 06 2018   grade_4 43 0 4 1   22     0   3   34 39                       73.0 43 0 4 1   22     0   3   34 39                 73
2238567 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Acton-Boxborough: Luther Conant School   Regular School No Elementary KG 06 2018   grade_4 20 4 3 0   43     0   3   35 38                       73.0 20 4 3 0   43     0   3   35 38                 73
2238543 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 Acton-Boxborough: McCarthy-Towne School   Regular School No Elementary KG 06 2018   grade_4 54 3 6 0   5     0   5   37 36                       73.0 54 3 6 0   5     0   5   37 36                 73
2238535 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Acton-Boxborough: Merriam School   Regular School No Elementary KG 06 2018   grade_4 54 4 3 0   33     1   1   52 44                       96.0 54 4 3 0   33     1   1   52 44                 96
2238559 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Acton-Boxborough: Paul P Gates Elementary School   Regular School No Elementary KG 06 2018   grade_4 17 1 4 0   27     0   1   26 24                       50.0 17 1 4 0   27     0   1   26 24                 50
1672028 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet - Acushnet Elementary School   Regular School No Elementary PK 04 2021   grade_4 70 1 4 1   0     0   4   43 37 *                     80.0 70 1 4 1   0     0   4   43 37                 80
735678 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No 1 PK 04 2015   grade_4 113 0 0 0   0     0   0   59 54                       113 113 0 0 0   0     0   0   59 54                 113
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
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
1364804 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2020   grade_4 99 0 4 0   1     0   7   56 55 *                     111.0 99 0 4 0   1     0   7   56 55                 111
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
2228778 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet: Acushnet Elementary School   Regular School No Elementary PK 04 2018   grade_4 105 1 0 0   0     0   0   63 43                       106.0 105 1 0 0   0     0   0   63 43                 106
2238585 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Adams-Cheshire: Hoosac Valley Middle School   Regular School No Middle 04 07 2018   grade_4 100 4 4 0   0     0   3   61 50                       111.0 100 4 4 0   0     0   3   61 50                 111
1368461 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_4 * * * *   *     *   *   * * *                     0.0                                             0
1672043 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Agawam - Benjamin J Phelps   Regular School No Elementary KG 04 2021   grade_4 74 0 5 0   1     0   2   32 50 *                     82.0 74 0 5 0   1     0   2   32 50                 82
1672038 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Agawam - Clifford M Granger   Regular School No Elementary KG 04 2021   grade_4 57 2 4 0   0     1   1   30 35 *                     65.0 57 2 4 0   0     1   1   30 35                 65
1672053 MA Hampden   school 2501800 5   Agawam 250180000030 50030 Agawam - James Clark School   Regular School No Elementary KG 04 2021   grade_4 43 2 6 0   2     0   3   36 20 *                     56.0 43 2 6 0   2     0   3   36 20                 56

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