enrollments

Data source: Big Local News · About: Big Local

6,880 rows where grade = "grade_1" and state = "MA" sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_1 · 6,880 ✖
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
2230204 2230204 MA Suffolk   school   35   Boston   350652               2018   grade_1 * * * *   *     *   *   * *                       0.0                                             0
739412 739412 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No 1 KG 05 2015   grade_1 14 13 86 0   17     0   2   73 59                       132 14 13 86 0   17     0   2   73 59                 132
936260 936260 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No 1 KG 05 2016   grade_1 3 10 59 0   15     0   8   49 46                       95 3 10 59 0   15     0   8   49 46                 95
1126368 1126368 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary KG 05 2017   grade_1 7 2 47 0   15     0   2   40 33                       73 7 2 47 0   15     0   2   40 33                 73
1368485 1368485 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary PK 05 2020   grade_1 9 0 52 1   14     0   0   36 40 *                     76.0 9 0 52 1   14     0   0   36 40                 76
2043556 2043556 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary KG 05 2019   grade_1 6 7 49 0   12     0   1   30 45                       75.0 6 7 49 0   12     0   1   30 45                 75
740307 740307 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No 1 KG 05 2015   grade_1 54 1 2 0   9     0   1   35 32                       67 54 1 2 0   9     0   1   35 32                 67
937143 937143 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No 1 KG 05 2016   grade_1 48 1 5 0   13     0   7   30 44                       74 48 1 5 0   13     0   7   30 44                 74
1127419 1127419 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2017   grade_1 52 4 2 0   7     0   1   30 36                       66 52 4 2 0   7     0   1   30 36                 66
1369371 1369371 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2020   grade_1 63 3 2 0   9     0   9   44 42 *                     86.0 63 3 2 0   9     0   9   44 42                 86
2044444 2044444 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2019   grade_1 51 4 5 0   8     0   5   38 35                       73.0 51 4 5 0   8     0   5   38 35                 73
741212 741212 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No 1 KG 05 2015   grade_1 73 1 41 1   3     0   3   66 56                       122 73 1 41 1   3     0   3   66 56                 122
938040 938040 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No 1 KG 05 2016   grade_1 40 5 43 0   7     1   4   46 54                       100 40 5 43 0   7     1   4   46 54                 100
1128481 1128481 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2017   grade_1 56 3 43 0   9     0   3   57 57                       114 56 3 43 0   9     0   3   57 57                 114
1370268 1370268 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2020   grade_1 61 2 61 0   7     0   3   66 68 *                     134.0 61 2 61 0   7     0   3   66 68                 134
2045341 2045341 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2019   grade_1 59 7 64 0   4     0   4   74 64                       138.0 59 7 64 0   4     0   4   74 64                 138
735871 735871 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No 1 KG 04 2015   grade_1 50 0 17 0   4     0   7   36 42                       78 50 0 17 0   4     0   7   36 42                 78
932747 932747 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No 1 KG 04 2016   grade_1 58 0 27 0   3     0   3   44 47                       91 58 0 27 0   3     0   3   44 47                 91
1122204 1122204 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2017   grade_1 50 5 27 1   2     1   11   51 46                       97 50 5 27 1   2     1   11   51 46                 97
1364995 1364995 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2020   grade_1 48 4 13 0   2     0   3   31 39 *                     70.0 48 4 13 0   2     0   3   31 39                 70
2040022 2040022 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2019   grade_1 54 4 7 0   1     0   2   37 31                       68.0 54 4 7 0   1     0   2   37 31                 68
738205 738205 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   grade_1 10 0 0 0   0     0   0   5 5                       10 10 0 0 0   0     0   0   5 5                 10
935059 935059 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2016   grade_1 7 0 0 0   0     0   0   2 5                       7 7 0 0 0   0     0   0   2 5                 7
1124921 1124921 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   grade_1 7 0 0 0   0     0   0   3 4                       7 7 0 0 0   0     0   0   3 4                 7
1367292 1367292 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2020   grade_1 9 0 0 0   0     0   0   5 4 *                     9.0 9 0 0 0   0     0   0   5 4                 9
2042363 2042363 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_1 6 0 0 0   0     0   0   4 2                       6.0 6 0 0 0   0     0   0   4 2                 6
1679924 1679924 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_1 26 65 7 1   4     0   13   55 61 *                     116.0 26 65 7 1   4     0   13   55 61                 116
2238159 2238159 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_1 25 52 34 0   5     0   0   52 64                       116.0 25 52 34 0   5     0   0   52 64                 116
743603 743603 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_1 15 79 26 0   4     0   1   57 68                       125 15 79 26 0   4     0   1   57 68                 125
940426 940426 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_1 27 61 17 0   3     0   8   62 54                       116 27 61 17 0   3     0   8   62 54                 116
1131327 1131327 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_1 31 55 20 0   2     0   5   54 59                       113 31 55 20 0   2     0   5   54 59                 113
1372660 1372660 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_1 18 61 31 3   2     0   5   54 66 *                     120.0 18 61 31 3   2     0   5   54 66                 120
2047731 2047731 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_1 16 55 30 1   5     0   7   40 74                       114.0 16 55 30 1   5     0   7   40 74                 114
1672012 1672012 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Abington - Beaver Brook Elementary   Regular School No Elementary KG 02 2021   grade_1 127 8 26 1   4     0   2   79 88 *                     168.0 127 8 26 1   4     0   2   79 88                 168
2228760 2228760 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Abington: Beaver Brook Elementary   Regular School No Elementary KG 02 2018   grade_1 132 5 17 0   1     0   0   82 73                       155.0 132 5 17 0   1     0   0   82 73                 155
742678 742678 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No 1 KG 05 2015   grade_1 27 4 5 0   0     0   1   21 16                       37 27 4 5 0   0     0   1   21 16                 37
939484 939484 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No 1 KG 05 2016   grade_1 20 0 6 0   3     0   1   17 13                       30 20 0 6 0   3     0   1   17 13                 30
1130212 1130212 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No Elementary KG 05 2017   grade_1 25 2 6 0   5     0   0   20 18                       38 25 2 6 0   5     0   0   20 18                 38
1371727 1371727 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No Elementary KG 04 2020   grade_1 19 1 13 0   5     0   1   22 17 *                     39.0 19 1 13 0   5     0   1   22 17                 39
2046801 2046801 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No Elementary KG 04 2019   grade_1 28 1 14 0   3     0   1   28 19                       47.0 28 1 14 0   3     0   1   28 19                 47
739406 739406 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No 1 KG 05 2015   grade_1 24 8 17 1   3     0   5   26 32                       58 24 8 17 1   3     0   5   26 32                 58
936254 936254 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No 1 KG 05 2016   grade_1 18 4 13 1   1     0   1   20 18                       38 18 4 13 1   1     0   1   20 18                 38
1126361 1126361 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2017   grade_1 16 6 10 0   3     0   6   20 21                       41 16 6 10 0   3     0   6   20 21                 41
1368478 1368478 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2020   grade_1 19 3 19 0   6     0   5   21 31 *                     52.0 19 3 19 0   6     0   5   21 31                 52
2043550 2043550 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2019   grade_1 10 2 24 1   4     0   4   23 22                       45.0 10 2 24 1   4     0   4   23 22                 45
739264 739264 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No 1 PK 04 2015   grade_1 19 3 26 0   43     0   3   52 42                       94 19 3 26 0   43     0   3   52 42                 94
740210 740210 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No 1 KG 05 2015   grade_1 82 11 53 0   1     0   7   81 73                       154 82 11 53 0   1     0   7   81 73                 154
741229 741229 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No 1 PK 05 2015   grade_1 51 7 52 0   4     0   1   54 61                       115 51 7 52 0   4     0   1   54 61                 115
936111 936111 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No 1 PK 04 2016   grade_1 9 6 33 0   46     0   2   48 48                       96 9 6 33 0   46     0   2   48 48                 96
937048 937048 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No 1 KG 05 2016   grade_1 68 19 32 0   0     0   10   68 61                       129 68 19 32 0   0     0   10   68 61                 129
938057 938057 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No 1 PK 05 2016   grade_1 39 4 44 0   3     0   0   42 48                       90 39 4 44 0   3     0   0   42 48                 90
1126187 1126187 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2017   grade_1 12 8 29 1   31     0   3   49 35                       84 12 8 29 1   31     0   3   49 35                 84
1127306 1127306 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2017   grade_1 71 7 37 1   1     0   8   60 65                       125 71 7 37 1   1     0   8   60 65                 125
1128501 1128501 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2017   grade_1 47 7 45 0   1     0   0   57 43                       100 47 7 45 0   1     0   0   57 43                 100
1368315 1368315 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2020   grade_1 10 2 33 0   44     0   4   47 46 *                     93.0 10 2 33 0   44     0   4   47 46                 93
1369271 1369271 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2020   grade_1 52 11 48 0   0     0   6   67 50 *                     117.0 52 11 48 0   0     0   6   67 50                 117
1370285 1370285 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2020   grade_1 35 2 49 0   4     0   2   55 37 *                     92.0 35 2 49 0   4     0   2   55 37                 92
2043398 2043398 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2019   grade_1 13 1 23 0   48     0   6   52 39                       91.0 13 1 23 0   48     0   6   52 39                 91
2044344 2044344 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2019   grade_1 60 18 45 0   1     1   4   72 57                       129.0 60 18 45 0   1     1   4   72 57                 129
2045358 2045358 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2019   grade_1 28 1 63 0   4     0   1   45 52                       97.0 28 1 63 0   4     0   1   45 52                 97
742878 742878 MA Norfolk   school 2512840 336   Weymouth 251284002103 3360005 Academy Avenue   Regular School No 1 KG 04 2015   grade_1 64 4 10 0   5     0   2   46 39                       85 64 4 10 0   5     0   2   46 39                 85
939683 939683 MA Norfolk   school 2512840 336   Weymouth 251284002103 3360005 Academy Avenue   Regular School No 1 KG 04 2016   grade_1 45 3 6 0   4     0   3   27 34                       61 45 3 6 0   4     0   3   27 34                 61
1130456 1130456 MA Norfolk   school 2512840 336   Weymouth 251284002103 3360005 Academy Avenue   Regular School No Elementary KG 04 2017   grade_1 44 4 1 0   1     0   3   29 24                       53 44 4 1 0   1     0   3   29 24                 53
1371911 1371911 MA Norfolk   school 2512840 336   Weymouth 251284002103 3360005 Academy Avenue   Regular School No Elementary KG 04 2020   grade_1 38 0 10 0   8     1   3   29 31 *                     60.0 38 0 10 0   8     1   3   29 31                 60
2046986 2046986 MA Norfolk   school 2512840 336   Weymouth 251284002103 3360005 Academy Avenue   Regular School No Elementary KG 04 2019   grade_1 42 2 5 0   3     0   6   29 29                       58.0 42 2 5 0   3     0   6   29 29                 58
1680246 1680246 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Acton-Boxborough - Blanchard Memorial School   Regular School No Elementary KG 06 2021   grade_1 27 5 4 0   14     0   5   26 29 *                     55.0 27 5 4 0   14     0   5   26 29                 55
1680267 1680267 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 Acton-Boxborough - C.T. Douglas Elementary School   Regular School No Elementary KG 06 2021   grade_1 30 2 4 0   15     0   5   28 28 *                     56.0 30 2 4 0   15     0   5   28 28                 56
1680281 1680281 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Acton-Boxborough - Luther Conant School   Regular School No Elementary KG 06 2021   grade_1 17 1 8 0   29     0   2   33 24 *                     57.0 17 1 8 0   29     0   2   33 24                 57
1680260 1680260 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 Acton-Boxborough - McCarthy-Towne School   Regular School No Elementary KG 06 2021   grade_1 39 1 6 0   7     0   2   28 27 *                     55.0 39 1 6 0   7     0   2   28 27                 55
1680253 1680253 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Acton-Boxborough - Merriam School   Regular School No Elementary KG 06 2021   grade_1 44 1 2 0   7     0   4   29 29 *                     58.0 44 1 2 0   7     0   4   29 29                 58
1680274 1680274 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Acton-Boxborough - Paul P Gates Elementary School   Regular School No Elementary KG 06 2021   grade_1 12 1 2 0   20     0   5   19 21 *                     40.0 12 1 2 0   20     0   5   19 21                 40
2238524 2238524 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Acton-Boxborough: Blanchard Memorial School   Regular School No Elementary KG 06 2018   grade_1 39 0 2 0   17     0   1   29 30                       59.0 39 0 2 0   17     0   1   29 30                 59
2238548 2238548 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 Acton-Boxborough: C.T. Douglas Elementary School   Regular School No Elementary KG 06 2018   grade_1 33 0 2 0   7     0   2   17 27                       44.0 33 0 2 0   7     0   2   17 27                 44
2238564 2238564 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Acton-Boxborough: Luther Conant School   Regular School No Elementary KG 06 2018   grade_1 19 2 3 0   29     0   3   25 31                       56.0 19 2 3 0   29     0   3   25 31                 56
2238540 2238540 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 Acton-Boxborough: McCarthy-Towne School   Regular School No Elementary KG 06 2018   grade_1 49 1 4 0   5     0   5   34 30                       64.0 49 1 4 0   5     0   5   34 30                 64
2238532 2238532 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Acton-Boxborough: Merriam School   Regular School No Elementary KG 06 2018   grade_1 46 1 5 0   6     0   5   26 37                       63.0 46 1 5 0   6     0   5   26 37                 63
2238556 2238556 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Acton-Boxborough: Paul P Gates Elementary School   Regular School No Elementary KG 06 2018   grade_1 19 0 7 0   29     0   2   31 26                       57.0 19 0 7 0   29     0   2   31 26                 57
1672025 1672025 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet - Acushnet Elementary School   Regular School No Elementary PK 04 2021   grade_1 75 1 3 0   1     0   3   47 36 *                     83.0 75 1 3 0   1     0   3   47 36                 83
735675 735675 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No 1 PK 04 2015   grade_1 101 0 0 0   0     0   0   58 43                       101 101 0 0 0   0     0   0   58 43                 101
932553 932553 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No 1 PK 04 2016   grade_1 97 0 4 0   0     0   0   43 58                       101 97 0 4 0   0     0   0   43 58                 101
1121967 1121967 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   grade_1 88 0 4 0   0     0   7   55 44                       99 88 0 4 0   0     0   7   55 44                 99
1364801 1364801 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2020   grade_1 118 1 2 0   2     0   4   62 65 *                     127.0 118 1 2 0   2     0   4   62 65                 127
2039827 2039827 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2019   grade_1 95 3 4 0   1     0   2   55 50                       105.0 95 3 4 0   1     0   2   55 50                 105
2228775 2228775 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet: Acushnet Elementary School   Regular School No Elementary PK 04 2018   grade_1 72 0 5 1   0     0   3   39 42                       81.0 72 0 5 1   0     0   3   39 42                 81
2238581 2238581 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000023 6030020 Adams-Cheshire: Hoosac Valley Elementary School   Regular School No Elementary PK 03 2018   grade_1 74 3 1 0   0     0   1   47 32                       79.0 74 3 1 0   0     0   1   47 32                 79
1368458 1368458 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_1 * * * *   *     *   *   * * *                     0.0                                             0
1672040 1672040 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Agawam - Benjamin J Phelps   Regular School No Elementary KG 04 2021   grade_1 60 1 5 0   3     0   1   37 33 *                     70.0 60 1 5 0   3     0   1   37 33                 70
1672035 1672035 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Agawam - Clifford M Granger   Regular School No Elementary KG 04 2021   grade_1 42 1 9 0   4     0   1   25 32 *                     57.0 42 1 9 0   4     0   1   25 32                 57
1672050 1672050 MA Hampden   school 2501800 5   Agawam 250180000030 50030 Agawam - James Clark School   Regular School No Elementary KG 04 2021   grade_1 35 0 5 0   6     0   3   22 27 *                     49.0 35 0 5 0   6     0   3   22 27                 49
1672045 1672045 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Agawam - Robinson Park   Regular School No Elementary KG 04 2021   grade_1 58 1 13 0   2     0   7   37 44 *                     81.0 58 1 13 0   2     0   7   37 44                 81
2228794 2228794 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Agawam: Benjamin J Phelps   Regular School No Elementary KG 04 2018   grade_1 81 1 6 0   3     0   1   41 51                       92.0 81 1 6 0   3     0   1   41 51                 92
2228788 2228788 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Agawam: Clifford M Granger   Regular School No Elementary KG 04 2018   grade_1 60 1 2 0   0     1   0   28 36                       64.0 60 1 2 0   0     1   0   28 36                 64
2228806 2228806 MA Hampden   school 2501800 5   Agawam 250180000030 50030 Agawam: James Clark School   Regular School No Elementary KG 04 2018   grade_1 54 2 8 0   2     0   2   43 25                       68.0 54 2 8 0   2     0   2   43 25                 68
2228800 2228800 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Agawam: Robinson Park   Regular School No Elementary KG 04 2018   grade_1 63 5 7 0   1     0   4   41 39                       80.0 63 5 7 0   1     0   4   41 39                 80
741638 741638 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No 1 PK 08 2015   grade_1 27 4 39 0   7     0   1   36 42                       78 27 4 39 0   7     0   1   36 42                 78
938441 938441 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No 1 PK 08 2016   grade_1 31 3 38 0   13     0   5   49 41                       90 31 3 38 0   13     0   5   49 41                 90
1128967 1128967 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2017   grade_1 37 6 38 0   4     0   5   48 42                       90 37 6 38 0   4     0   5   48 42                 90
1370668 1370668 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2020   grade_1 39 2 34 0   4     0   4   35 48 *                     83.0 39 2 34 0   4     0   4   35 48                 83
2045744 2045744 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2019   grade_1 39 6 36 0   8     0   3   48 44                       92.0 39 6 36 0   8     0   3   48 44                 92
737641 737641 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Alcott   Regular School No 1 PK 05 2015   grade_1 57 6 5 0   5     0   2   34 41                       75 57 6 5 0   5     0   2   34 41                 75

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