enrollments

Data source: Big Local News · About: Big Local

6,831 rows where grade = "grade_2" and state = "MA" sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_2 · 6,831 ✖
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
735661 735661 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No 1 01 04 2015   grade_2 133 1 5 1   3     0   0   78 65                       143 133 1 5 1   3     0   0   78 65                 143
932539 932539 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No 1 01 04 2016   grade_2 124 4 8 0   1     0   3   72 68                       140 124 4 8 0   1     0   3   72 68                 140
1121950 1121950 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No Elementary 01 04 2017   grade_2 147 3 11 0   3     0   0   89 75                       164 147 3 11 0   3     0   0   89 75                 164
1364789 1364789 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2020   grade_2 119 10 10 2   3     0   1   68 77 *                     145.0 119 10 10 2   3     0   1   68 77                 145
1672013 1672013 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Abington - Beaver Brook Elementary   Regular School No Elementary KG 02 2021   grade_2 128 8 13 4   5     0   3   85 76 *                     161.0 128 8 13 4   5     0   3   85 76                 161
2039815 2039815 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2019   grade_2 133 5 19 1   2     0   0   85 75                       160.0 133 5 19 1   2     0   0   85 75                 160
2228761 2228761 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Abington: Beaver Brook Elementary   Regular School No Elementary KG 02 2018   grade_2 113 4 8 0   5     1   1   59 73                       132.0 113 4 8 0   5     1   1   59 73                 132
735808 735808 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No 1 KG 05 2015   grade_2 46 5 4 0   10     0   3   32 36                       68 46 5 4 0   10     0   3   32 36                 68
735814 735814 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No 1 KG 05 2015   grade_2 54 1 1 0   7     0   5   41 27                       68 54 1 1 0   7     0   5   41 27                 68
735820 735820 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No 1 KG 05 2015   grade_2 48 4 3 0   9     1   1   39 27                       66 48 4 3 0   9     1   1   39 27                 66
735826 735826 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No 1 KG 05 2015   grade_2 44 3 5 0   12     0   4   41 27                       68 44 3 5 0   12     0   4   41 27                 68
735833 735833 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No 1 KG 05 2015   grade_2 33 1 4 0   4     0   2   18 26                       44 33 1 4 0   4     0   2   18 26                 44
735839 735839 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No 1 KG 05 2015   grade_2 55 3 6 1   12     1   4   45 37                       82 55 3 6 1   12     1   4   45 37                 82
735845 735845 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No 1 KG 05 2015   grade_2 47 0 6 0   11     0   5   32 37                       69 47 0 6 0   11     0   5   32 37                 69
932684 932684 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No 1 KG 05 2016   grade_2 58 3 2 0   6     0   3   35 37                       72 58 3 2 0   6     0   3   35 37                 72
932690 932690 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No 1 KG 05 2016   grade_2 65 2 5 0   4     0   5   41 40                       81 65 2 5 0   4     0   5   41 40                 81
932696 932696 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No 1 KG 05 2016   grade_2 59 2 6 0   6     0   4   39 38                       77 59 2 6 0   6     0   4   39 38                 77
932702 932702 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No 1 KG 05 2016   grade_2 47 6 3 0   8     0   3   32 35                       67 47 6 3 0   8     0   3   32 35                 67
932709 932709 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No 1 KG 05 2016   grade_2 36 2 6 0   0     0   0   29 15                       44 36 2 6 0   0     0   0   29 15                 44
932715 932715 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No 1 KG 05 2016   grade_2 48 2 9 0   11     0   3   37 36                       73 48 2 9 0   11     0   3   37 36                 73
932721 932721 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No 1 KG 05 2016   grade_2 50 1 0 0   10     0   4   31 34                       65 50 1 0 0   10     0   4   31 34                 65
1122126 1122126 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2017   grade_2 49 3 1 0   10     0   6   40 29                       69 49 3 1 0   10     0   6   40 29                 69
1122133 1122133 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2017   grade_2 68 1 8 0   7     1   8   48 45                       93 68 1 8 0   7     1   8   48 45                 93
1122140 1122140 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2017   grade_2 61 1 4 0   8     0   5   37 42                       79 61 1 4 0   8     0   5   37 42                 79
1122147 1122147 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2017   grade_2 47 4 6 1   14     0   4   46 30                       76 47 4 6 1   14     0   4   46 30                 76
1122156 1122156 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2017   grade_2 27 3 6 0   7     0   1   19 25                       44 27 3 6 0   7     0   1   19 25                 44
1122163 1122163 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2017   grade_2 55 4 6 1   13     1   6   46 40                       86 55 4 6 1   13     1   6   46 40                 86
1122170 1122170 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2017   grade_2 44 0 4 0   8     0   2   31 27                       58 44 0 4 0   8     0   2   31 27                 58
1364932 1364932 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2020   grade_2 40 4 0 0   16     0   7   39 28 *                     67.0 40 4 0 0   16     0   7   39 28                 67
1364938 1364938 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2020   grade_2 62 1 1 0   9     0   9   43 39 *                     82.0 62 1 1 0   9     0   9   43 39                 82
1364944 1364944 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2020   grade_2 60 1 3 0   7     0   4   41 34 *                     75.0 60 1 3 0   7     0   4   41 34                 75
1364950 1364950 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2020   grade_2 49 3 5 0   12     0   10   33 46 *                     79.0 49 3 5 0   12     0   10   33 46                 79
1364957 1364957 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2020   grade_2 43 4 4 0   7     0   7   34 31 *                     65.0 43 4 4 0   7     0   7   34 31                 65
1364963 1364963 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2020   grade_2 50 1 8 0   9     0   4   32 39 *                     72.0 50 1 8 0   9     0   4   32 39                 72
1364969 1364969 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2020   grade_2 57 1 3 0   7     0   9   36 41 *                     77.0 57 1 3 0   7     0   9   36 41                 77
1672155 1672155 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 Arlington - John A Bishop   Regular School No Elementary KG 05 2021   grade_2 52 1 4 0   11     0   7   41 34 *                     75.0 52 1 4 0   11     0   7   41 34                 75
1672161 1672161 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Arlington - Brackett   Regular School No Elementary KG 05 2021   grade_2 78 0 4 0   6     0   13   55 46 *                     101.0 78 0 4 0   6     0   13   55 46                 101
1672167 1672167 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Arlington - Cyrus E Dallin   Regular School No Elementary KG 05 2021   grade_2 54 3 4 0   11     0   7   39 40 *                     79.0 54 3 4 0   11     0   7   39 40                 79
1672173 1672173 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Arlington - Hardy   Regular School No Elementary KG 05 2021   grade_2 45 2 3 0   11     0   5   33 33 *                     66.0 45 2 3 0   11     0   5   33 33                 66
1672180 1672180 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Arlington - Peirce   Regular School No Elementary KG 05 2021   grade_2 26 4 8 0   13     0   3   25 29 *                     54.0 26 4 8 0   13     0   3   25 29                 54
1672186 1672186 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Arlington - Thompson   Regular School No Elementary KG 05 2021   grade_2 47 4 6 0   11     0   11   43 36 *                     79.0 47 4 6 0   11     0   11   43 36                 79
1672192 1672192 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 Arlington - M Norcross Stratton   Regular School No Elementary KG 05 2021   grade_2 45 2 5 0   20     0   7   44 34 *                     79.0 45 2 5 0   20     0   7   44 34                 79
2039959 2039959 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2019   grade_2 54 4 2 0   14     0   1   44 31                       75.0 54 4 2 0   14     0   1   44 31                 75
2039965 2039965 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2019   grade_2 69 2 3 0   16     0   4   52 42                       94.0 69 2 3 0   16     0   4   52 42                 94
2039971 2039971 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2019   grade_2 67 1 2 0   19     0   1   49 41                       90.0 67 1 2 0   19     0   1   49 41                 90
2039977 2039977 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2019   grade_2 62 1 7 0   16     0   0   48 38                       86.0 62 1 7 0   16     0   0   48 38                 86
2039984 2039984 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2019   grade_2 31 1 0 0   9     0   1   26 16                       42.0 31 1 0 0   9     0   1   26 16                 42
2039990 2039990 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2019   grade_2 60 6 12 1   14     0   0   40 53                       93.0 60 6 12 1   14     0   0   40 53                 93
2039996 2039996 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2019   grade_2 41 2 4 0   23     0   1   41 30                       71.0 41 2 4 0   23     0   1   41 30                 71
2228932 2228932 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 Arlington: John A Bishop   Regular School No Elementary KG 05 2018   grade_2 49 0 0 0   15     2   4   32 38                       70.0 49 0 0 0   15     2   4   32 38                 70
2228939 2228939 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Arlington: Brackett   Regular School No Elementary KG 05 2018   grade_2 57 0 3 0   4     0   4   33 35                       68.0 57 0 3 0   4     0   4   33 35                 68
2228946 2228946 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Arlington: Cyrus E Dallin   Regular School No Elementary KG 05 2018   grade_2 61 1 2 0   8     0   2   36 38                       74.0 61 1 2 0   8     0   2   36 38                 74
2228953 2228953 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Arlington: Hardy   Regular School No Elementary KG 05 2018   grade_2 52 4 4 0   13     1   3   42 35                       77.0 52 4 4 0   13     1   3   42 35                 77
2228962 2228962 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Arlington: Peirce   Regular School No Elementary KG 05 2018   grade_2 35 2 2 0   6     0   1   19 27                       46.0 35 2 2 0   6     0   1   19 27                 46
2228969 2228969 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Arlington: Thompson   Regular School No Elementary KG 05 2018   grade_2 53 4 6 0   10     0   6   42 37                       79.0 53 4 6 0   10     0   6   42 37                 79
2228976 2228976 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 Arlington: M Norcross Stratton   Regular School No Elementary KG 05 2018   grade_2 47 3 5 0   12     0   5   33 39                       72.0 47 3 5 0   12     0   5   33 39                 72
738241 738241 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No 1 KG 05 2015   grade_2 41 7 33 0   5     0   3   48 41                       89 41 7 33 0   5     0   3   48 41                 89
738247 738247 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No 1 KG 05 2015   grade_2 57 3 11 0   16     0   8   61 34                       95 57 3 11 0   16     0   8   61 34                 95
738253 738253 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No 1 KG 05 2015   grade_2 71 11 11 0   6     0   4   51 52                       103 71 11 11 0   6     0   4   51 52                 103
738259 738259 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No 1 KG 05 2015   grade_2 40 2 64 0   0     0   4   43 67                       110 40 2 64 0   0     0   4   43 67                 110
738265 738265 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No 1 KG 05 2015   grade_2 74 4 6 0   8     0   4   52 44                       96 74 4 6 0   8     0   4   52 44                 96
738271 738271 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Mary E Stapleton Elementary   Regular School No 1 KG 05 2015   grade_2 49 8 13 0   6     0   3   33 46                       79 49 8 13 0   6     0   3   33 46                 79
738277 738277 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No 1 KG 05 2015   grade_2 57 9 29 0   2     0   8   52 53                       105 57 9 29 0   2     0   8   52 53                 105
738283 738283 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No 1 KG 05 2015   grade_2 63 7 18 0   0     0   2   44 46                       90 63 7 18 0   0     0   2   44 46                 90
935095 935095 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No 1 KG 05 2016   grade_2 34 6 54 0   9     0   1   51 53                       104 34 6 54 0   9     0   1   51 53                 104
935101 935101 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No 1 KG 05 2016   grade_2 64 5 9 0   12     0   3   43 50                       93 64 5 9 0   12     0   3   43 50                 93
935107 935107 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No 1 KG 05 2016   grade_2 65 1 10 1   8     0   6   49 42                       91 65 1 10 1   8     0   6   49 42                 91
935113 935113 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No 1 KG 05 2016   grade_2 26 2 81 0   1     0   2   53 59                       112 26 2 81 0   1     0   2   53 59                 112
935119 935119 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No 1 KG 05 2016   grade_2 68 3 10 0   3     0   5   54 35                       89 68 3 10 0   3     0   5   54 35                 89
935125 935125 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Mary E Stapleton Elementary   Regular School No 1 KG 05 2016   grade_2 52 2 11 0   1     0   3   34 35                       69 52 2 11 0   1     0   3   34 35                 69
935131 935131 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No 1 KG 05 2016   grade_2 65 17 24 0   1     0   7   64 50                       114 65 17 24 0   1     0   7   64 50                 114
935137 935137 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No 1 KG 05 2016   grade_2 61 13 20 0   2     0   2   44 54                       98 61 13 20 0   2     0   2   44 54                 98
1124962 1124962 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No Elementary KG 02 2017   grade_2 49 5 13 0   7     0   5   47 32                       79 49 5 13 0   7     0   5   47 32                 79
1124966 1124966 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2017   grade_2 25 4 49 0   4     0   1   42 41                       83 25 4 49 0   4     0   1   42 41                 83
1124973 1124973 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2017   grade_2 46 4 9 0   13     0   0   30 42                       72 46 4 9 0   13     0   0   30 42                 72
1124980 1124980 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2017   grade_2 73 7 11 0   7     0   3   57 44                       101 73 7 11 0   7     0   3   57 44                 101
1124987 1124987 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2017   grade_2 30 3 81 0   1     0   2   47 70                       117 30 3 81 0   1     0   2   47 70                 117
1124994 1124994 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No Elementary KG 05 2017   grade_2 66 5 4 0   4     0   2   38 43                       81 66 5 4 0   4     0   2   38 43                 81
1125001 1125001 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Mary E Stapleton Elementary   Regular School No Elementary KG 05 2017   grade_2 30 9 11 0   2     0   3   27 28                       55 30 9 11 0   2     0   3   27 28                 55
1125008 1125008 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No Elementary KG 05 2017   grade_2 42 13 27 0   2     0   4   41 47                       88 42 13 27 0   2     0   4   41 47                 88
1125015 1125015 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2017   grade_2 72 9 21 0   0     0   1   52 51                       103 72 9 21 0   0     0   1   52 51                 103
1367327 1367327 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No Elementary KG 05 2020   grade_2 44 3 6 0   6     0   6   33 32 *                     65.0 44 3 6 0   6     0   6   33 32                 65
1367333 1367333 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2020   grade_2 16 5 41 0   1     0   2   33 32 *                     65.0 16 5 41 0   1     0   2   33 32                 65
1367339 1367339 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2020   grade_2 45 4 6 0   5     0   1   37 24 *                     61.0 45 4 6 0   5     0   1   37 24                 61
1367345 1367345 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2020   grade_2 47 12 16 0   5     0   9   44 45 *                     89.0 47 12 16 0   5     0   9   44 45                 89
1367351 1367351 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2020   grade_2 19 4 94 0   0     0   4   47 74 *                     121.0 19 4 94 0   0     0   4   47 74                 121
1367357 1367357 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No Elementary KG 05 2020   grade_2 57 10 11 0   3     0   6   39 48 *                     87.0 57 10 11 0   3     0   6   39 48                 87
1367363 1367363 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Mary E Stapleton Elementary   Regular School No Elementary KG 05 2020   grade_2 44 4 5 0   3     0   1   31 26 *                     57.0 44 4 5 0   3     0   1   31 26                 57
1367369 1367369 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No Elementary KG 05 2020   grade_2 34 10 22 0   3     1   8   41 37 *                     78.0 34 10 22 0   3     1   8   41 37                 78
1367375 1367375 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2020   grade_2 47 10 25 0   1     0   1   55 29 *                     84.0 47 10 25 0   1     0   1   55 29                 84
1674561 1674561 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 Framingham - King Elementary School   Regular School No Elementary KG 05 2021   grade_2 42 3 11 0   9     0   5   32 38 *                     70.0 42 3 11 0   9     0   5   32 38                 70
1674567 1674567 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Framingham - Brophy   Regular School No Elementary KG 05 2021   grade_2 29 6 40 1   5     0   6   41 46 *                     87.0 29 6 40 1   5     0   6   41 46                 87
1674573 1674573 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Framingham - Charlotte A Dunning   Regular School No Elementary KG 05 2021   grade_2 54 8 22 0   4     0   5   46 47 *                     93.0 54 8 22 0   4     0   5   46 47                 93
1674579 1674579 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Framingham - Hemenway   Regular School No Elementary KG 05 2021   grade_2 57 3 11 0   10     0   10   50 41 *                     91.0 57 3 11 0   10     0   10   50 41                 91
1674585 1674585 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Framingham - Barbieri Elementary   Regular School No Elementary KG 05 2021   grade_2 18 4 93 0   0     0   6   54 67 *                     121.0 18 4 93 0   0     0   6   54 67                 121
1674591 1674591 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Framingham - Potter Road   Regular School No Elementary KG 05 2021   grade_2 68 6 14 0   1     0   5   53 41 *                     94.0 68 6 14 0   1     0   5   53 41                 94
1674597 1674597 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Framingham - Mary E Stapleton Elementary   Regular School No Elementary KG 05 2021   grade_2 26 3 23 0   4     0   7   34 29 *                     63.0 26 3 23 0   4     0   7   34 29                 63
1674603 1674603 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Framingham - Miriam F McCarthy School   Regular School No Elementary KG 05 2021   grade_2 36 8 41 0   1     0   7   46 47 *                     93.0 36 8 41 0   1     0   7   46 47                 93
1674609 1674609 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Framingham - Woodrow Wilson   Regular School No Elementary KG 05 2021   grade_2 43 16 22 0   0     0   1   44 38 *                     82.0 43 16 22 0   0     0   1   44 38                 82
2042399 2042399 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No Elementary KG 04 2019   grade_2 45 6 2 0   8     0   5   38 28                       66.0 45 6 2 0   8     0   5   38 28                 66

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