enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
735660 735660 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No 1 01 04 2015   grade_1 117 3 7 1   3     0   0   72 59                       131 117 3 7 1   3     0   0   72 59                 131
932538 932538 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No 1 01 04 2016   grade_1 151 4 6 0   1     0   3   88 77                       165 151 4 6 0   1     0   3   88 77                 165
1121949 1121949 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No Elementary 01 04 2017   grade_1 109 1 10 1   3     1   0   52 73                       125 109 1 10 1   3     1   0   52 73                 125
1364788 1364788 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2020   grade_1 130 9 9 3   5     0   1   80 77 *                     157.0 130 9 9 3   5     0   1   80 77                 157
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
2039814 2039814 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2019   grade_1 119 7 9 3   3     0   1   66 76                       142.0 119 7 9 3   3     0   1   66 76                 142
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
735807 735807 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No 1 KG 05 2015   grade_1 60 3 2 0   6     0   1   35 37                       72 60 3 2 0   6     0   1   35 37                 72
735813 735813 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No 1 KG 05 2015   grade_1 65 2 7 0   4     0   5   41 42                       83 65 2 7 0   4     0   5   41 42                 83
735819 735819 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No 1 KG 05 2015   grade_1 59 2 7 0   6     0   4   38 40                       78 59 2 7 0   6     0   4   38 40                 78
735825 735825 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No 1 KG 05 2015   grade_1 47 6 3 0   11     0   2   34 35                       69 47 6 3 0   11     0   2   34 35                 69
735832 735832 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No 1 KG 05 2015   grade_1 37 0 5 0   2     0   0   27 17                       44 37 0 5 0   2     0   0   27 17                 44
735838 735838 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No 1 KG 05 2015   grade_1 44 2 8 0   9     0   5   33 35                       68 44 2 8 0   9     0   5   33 35                 68
735844 735844 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No 1 KG 05 2015   grade_1 49 1 1 0   11     0   6   37 31                       68 49 1 1 0   11     0   6   37 31                 68
932683 932683 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No 1 KG 05 2016   grade_1 52 2 1 0   10     0   9   43 31                       74 52 2 1 0   10     0   9   43 31                 74
932689 932689 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No 1 KG 05 2016   grade_1 65 1 9 0   8     1   9   46 47                       93 65 1 9 0   8     1   9   46 47                 93
932695 932695 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No 1 KG 05 2016   grade_1 66 1 2 0   9     0   4   38 44                       82 66 1 2 0   9     0   4   38 44                 82
932701 932701 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No 1 KG 05 2016   grade_1 52 1 5 1   18     0   4   49 32                       81 52 1 5 1   18     0   4   49 32                 81
932708 932708 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No 1 KG 05 2016   grade_1 27 1 7 0   6     0   1   19 23                       42 27 1 7 0   6     0   1   19 23                 42
932714 932714 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No 1 KG 05 2016   grade_1 56 3 5 0   10     1   6   41 40                       81 56 3 5 0   10     1   6   41 40                 81
932720 932720 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No 1 KG 05 2016   grade_1 47 1 7 0   10     0   2   38 29                       67 47 1 7 0   10     0   2   38 29                 67
1122125 1122125 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2017   grade_1 49 1 1 0   16     2   4   33 40                       73 49 1 1 0   16     2   4   33 40                 73
1122132 1122132 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2017   grade_1 58 0 3 0   4     0   5   35 35                       70 58 0 3 0   4     0   5   35 35                 70
1122139 1122139 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2017   grade_1 59 1 3 0   5     0   2   37 33                       70 59 1 3 0   5     0   2   37 33                 70
1122146 1122146 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2017   grade_1 59 4 3 0   11     1   1   39 40                       79 59 4 3 0   11     1   1   39 40                 79
1122155 1122155 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2017   grade_1 35 3 1 0   7     0   1   18 29                       47 35 3 1 0   7     0   1   18 29                 47
1122162 1122162 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2017   grade_1 48 5 7 0   10     0   6   42 34                       76 48 5 7 0   10     0   6   42 34                 76
1122169 1122169 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2017   grade_1 45 3 7 0   14     0   5   33 41                       74 45 3 7 0   14     0   5   33 41                 74
1364931 1364931 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2020   grade_1 61 1 7 0   14     0   10   50 43 *                     93.0 61 1 7 0   14     0   10   50 43                 93
1364937 1364937 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2020   grade_1 82 0 4 0   7     0   13   59 47 *                     106.0 82 0 4 0   7     0   13   59 47                 106
1364943 1364943 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2020   grade_1 59 3 5 0   11     0   9   45 42 *                     87.0 59 3 5 0   11     0   9   45 42                 87
1364949 1364949 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2020   grade_1 54 2 2 0   11     0   6   41 34 *                     75.0 54 2 2 0   11     0   6   41 34                 75
1364956 1364956 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2020   grade_1 30 3 8 0   13     0   3   25 32 *                     57.0 30 3 8 0   13     0   3   25 32                 57
1364962 1364962 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2020   grade_1 55 4 9 0   12     0   12   51 41 *                     92.0 55 4 9 0   12     0   12   51 41                 92
1364968 1364968 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2020   grade_1 48 2 4 0   22     0   8   47 37 *                     84.0 48 2 4 0   22     0   8   47 37                 84
1672154 1672154 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 Arlington - John A Bishop   Regular School No Elementary KG 05 2021   grade_1 41 2 3 0   6     0   12   29 35 *                     64.0 41 2 3 0   6     0   12   29 35                 64
1672160 1672160 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Arlington - Brackett   Regular School No Elementary KG 05 2021   grade_1 51 1 4 0   12     0   8   42 34 *                     76.0 51 1 4 0   12     0   8   42 34                 76
1672166 1672166 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Arlington - Cyrus E Dallin   Regular School No Elementary KG 05 2021   grade_1 42 0 3 0   10     0   8   25 38 *                     63.0 42 0 3 0   10     0   8   25 38                 63
1672172 1672172 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Arlington - Hardy   Regular School No Elementary KG 05 2021   grade_1 44 0 3 0   12     0   8   36 31 *                     67.0 44 0 3 0   12     0   8   36 31                 67
1672179 1672179 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Arlington - Peirce   Regular School No Elementary KG 05 2021   grade_1 37 3 2 0   8     0   3   26 27 *                     53.0 37 3 2 0   8     0   3   26 27                 53
1672185 1672185 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Arlington - Thompson   Regular School No Elementary KG 05 2021   grade_1 51 2 4 0   12     0   9   36 42 *                     78.0 51 2 4 0   12     0   9   36 42                 78
1672191 1672191 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 Arlington - M Norcross Stratton   Regular School No Elementary KG 05 2021   grade_1 41 3 10 0   15     0   14   40 43 *                     83.0 41 3 10 0   15     0   14   40 43                 83
2039958 2039958 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2019   grade_1 41 4 0 0   14     0   8   40 27                       67.0 41 4 0 0   14     0   8   40 27                 67
2039964 2039964 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2019   grade_1 61 0 1 0   9     0   9   42 38                       80.0 61 0 1 0   9     0   9   42 38                 80
2039970 2039970 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2019   grade_1 57 0 3 0   7     0   5   41 31                       72.0 57 0 3 0   7     0   5   41 31                 72
2039976 2039976 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2019   grade_1 51 4 4 0   12     0   8   36 43                       79.0 51 4 4 0   12     0   8   36 43                 79
2039983 2039983 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2019   grade_1 43 4 6 0   8     0   7   34 34                       68.0 43 4 6 0   8     0   7   34 34                 68
2039989 2039989 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2019   grade_1 50 1 10 0   11     0   6   35 43                       78.0 50 1 10 0   11     0   6   35 43                 78
2039995 2039995 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2019   grade_1 56 1 3 0   6     0   10   36 40                       76.0 56 1 3 0   6     0   10   36 40                 76
2228931 2228931 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 Arlington: John A Bishop   Regular School No Elementary KG 05 2018   grade_1 55 2 3 0   16     0   1   46 31                       77.0 55 2 3 0   16     0   1   46 31                 77
2228938 2228938 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Arlington: Brackett   Regular School No Elementary KG 05 2018   grade_1 67 2 3 0   17     0   2   51 40                       91.0 67 2 3 0   17     0   2   51 40                 91
2228945 2228945 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Arlington: Cyrus E Dallin   Regular School No Elementary KG 05 2018   grade_1 67 0 1 0   21     0   1   49 41                       90.0 67 0 1 0   21     0   1   49 41                 90
2228952 2228952 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Arlington: Hardy   Regular School No Elementary KG 05 2018   grade_1 64 1 9 0   16     0   0   49 41                       90.0 64 1 9 0   16     0   0   49 41                 90
2228961 2228961 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Arlington: Peirce   Regular School No Elementary KG 05 2018   grade_1 37 1 2 0   10     0   0   29 21                       50.0 37 1 2 0   10     0   0   29 21                 50
2228968 2228968 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Arlington: Thompson   Regular School No Elementary KG 05 2018   grade_1 55 7 13 1   12     0   0   40 48                       88.0 55 7 13 1   12     0   0   40 48                 88
2228975 2228975 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 Arlington: M Norcross Stratton   Regular School No Elementary KG 05 2018   grade_1 39 3 4 0   22     0   1   40 29                       69.0 39 3 4 0   22     0   1   40 29                 69
738240 738240 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No 1 KG 05 2015   grade_1 34 8 51 0   10     0   0   51 52                       103 34 8 51 0   10     0   0   51 52                 103
738246 738246 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No 1 KG 05 2015   grade_1 64 5 12 0   13     0   3   44 53                       97 64 5 12 0   13     0   3   44 53                 97
738252 738252 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No 1 KG 05 2015   grade_1 67 3 8 0   10     0   5   48 45                       93 67 3 8 0   10     0   5   48 45                 93
738258 738258 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No 1 KG 05 2015   grade_1 30 3 82 0   2     0   3   60 60                       120 30 3 82 0   2     0   3   60 60                 120
738264 738264 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No 1 KG 05 2015   grade_1 77 4 10 0   4     0   5   62 38                       100 77 4 10 0   4     0   5   62 38                 100
738270 738270 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Mary E Stapleton Elementary   Regular School No 1 KG 05 2015   grade_1 55 4 6 0   1     0   4   36 34                       70 55 4 6 0   1     0   4   36 34                 70
738276 738276 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No 1 KG 05 2015   grade_1 64 12 23 0   2     1   6   60 48                       108 64 12 23 0   2     1   6   60 48                 108
738282 738282 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No 1 KG 05 2015   grade_1 54 12 22 0   3     0   3   44 50                       94 54 12 22 0   3     0   3   44 50                 94
935092 935092 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No 1 KG 01 2016   grade_1 41 5 13 0   7     0   7   44 29                       73 41 5 13 0   7     0   7   44 29                 73
935094 935094 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No 1 KG 05 2016   grade_1 24 3 35 0   4     0   1   38 29                       67 24 3 35 0   4     0   1   38 29                 67
935100 935100 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No 1 KG 05 2016   grade_1 43 3 9 0   13     0   1   29 40                       69 43 3 9 0   13     0   1   29 40                 69
935106 935106 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No 1 KG 05 2016   grade_1 75 7 15 0   8     0   3   60 48                       108 75 7 15 0   8     0   3   60 48                 108
935112 935112 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No 1 KG 05 2016   grade_1 29 2 81 0   1     0   2   45 70                       115 29 2 81 0   1     0   2   45 70                 115
935118 935118 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No 1 KG 05 2016   grade_1 61 4 4 0   4     0   2   36 39                       75 61 4 4 0   4     0   2   36 39                 75
935124 935124 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Mary E Stapleton Elementary   Regular School No 1 KG 05 2016   grade_1 38 11 10 0   2     0   3   36 28                       64 38 11 10 0   2     0   3   36 28                 64
935130 935130 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No 1 KG 05 2016   grade_1 44 9 23 0   2     0   6   34 50                       84 44 9 23 0   2     0   6   34 50                 84
935136 935136 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No 1 KG 05 2016   grade_1 73 11 22 0   0     0   2   52 56                       108 73 11 22 0   0     0   2   52 56                 108
1124961 1124961 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No Elementary KG 02 2017   grade_1 51 3 19 0   9     0   8   48 42                       90 51 3 19 0   9     0   8   48 42                 90
1124965 1124965 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2017   grade_1 26 6 40 0   3     0   1   34 42                       76 26 6 40 0   3     0   1   34 42                 76
1124972 1124972 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2017   grade_1 50 7 4 0   9     0   2   37 35                       72 50 7 4 0   9     0   2   37 35                 72
1124979 1124979 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2017   grade_1 65 2 16 0   8     0   7   50 48                       98 65 2 16 0   8     0   7   50 48                 98
1124986 1124986 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2017   grade_1 18 4 92 0   0     0   5   61 58                       119 18 4 92 0   0     0   5   61 58                 119
1124993 1124993 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No Elementary KG 05 2017   grade_1 68 4 7 0   3     0   2   42 42                       84 68 4 7 0   3     0   2   42 42                 84
1125000 1125000 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Mary E Stapleton Elementary   Regular School No Elementary KG 05 2017   grade_1 39 3 9 0   1     0   2   35 19                       54 39 3 9 0   1     0   2   35 19                 54
1125007 1125007 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No Elementary KG 05 2017   grade_1 35 5 31 0   4     0   9   40 44                       84 35 5 31 0   4     0   9   40 44                 84
1125014 1125014 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2017   grade_1 65 7 24 0   0     0   2   48 50                       98 65 7 24 0   0     0   2   48 50                 98
1367326 1367326 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No Elementary KG 05 2020   grade_1 46 3 11 0   10     0   7   37 40 *                     77.0 46 3 11 0   10     0   7   37 40                 77
1367332 1367332 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2020   grade_1 26 6 42 1   6     0   6   43 44 *                     87.0 26 6 42 1   6     0   6   43 44                 87
1367338 1367338 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2020   grade_1 57 10 21 0   3     0   5   48 48 *                     96.0 57 10 21 0   3     0   5   48 48                 96
1367344 1367344 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2020   grade_1 59 4 12 0   10     0   12   52 45 *                     97.0 59 4 12 0   10     0   12   52 45                 97
1367350 1367350 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2020   grade_1 15 4 97 0   0     0   6   51 71 *                     122.0 15 4 97 0   0     0   6   51 71                 122
1367356 1367356 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No Elementary KG 05 2020   grade_1 68 6 12 0   1     0   4   52 39 *                     91.0 68 6 12 0   1     0   4   52 39                 91
1367362 1367362 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Mary E Stapleton Elementary   Regular School No Elementary KG 05 2020   grade_1 31 3 21 0   4     0   6   38 27 *                     65.0 31 3 21 0   4     0   6   38 27                 65
1367368 1367368 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No Elementary KG 05 2020   grade_1 37 9 34 0   1     0   5   44 42 *                     86.0 37 9 34 0   1     0   5   44 42                 86
1367374 1367374 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2020   grade_1 53 16 19 1   0     0   2   47 44 *                     91.0 53 16 19 1   0     0   2   47 44                 91
1674560 1674560 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 Framingham - King Elementary School   Regular School No Elementary KG 05 2021   grade_1 34 2 6 0   8     0   4   31 23 *                     54.0 34 2 6 0   8     0   4   31 23                 54
1674566 1674566 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Framingham - Brophy   Regular School No Elementary KG 05 2021   grade_1 21 4 43 0   1     0   3   37 35 *                     72.0 21 4 43 0   1     0   3   37 35                 72
1674572 1674572 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Framingham - Charlotte A Dunning   Regular School No Elementary KG 05 2021   grade_1 36 3 16 0   5     0   6   33 33 *                     66.0 36 3 16 0   5     0   6   33 33                 66
1674578 1674578 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Framingham - Hemenway   Regular School No Elementary KG 05 2021   grade_1 44 5 22 0   13     0   5   41 48 *                     89.0 44 5 22 0   13     0   5   41 48                 89
1674584 1674584 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Framingham - Barbieri Elementary   Regular School No Elementary KG 05 2021   grade_1 16 0 91 0   2     0   6   50 65 *                     115.0 16 0 91 0   2     0   6   50 65                 115
1674590 1674590 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Framingham - Potter Road   Regular School No Elementary KG 05 2021   grade_1 33 5 42 0   3     0   5   36 52 *                     88.0 33 5 42 0   3     0   5   36 52                 88
1674596 1674596 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Framingham - Mary E Stapleton Elementary   Regular School No Elementary KG 05 2021   grade_1 11 6 25 0   4     0   2   27 21 *                     48.0 11 6 25 0   4     0   2   27 21                 48
1674602 1674602 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Framingham - Miriam F McCarthy School   Regular School No Elementary KG 05 2021   grade_1 19 9 25 0   2     0   11   28 38 *                     66.0 19 9 25 0   2     0   11   28 38                 66
1674608 1674608 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Framingham - Woodrow Wilson   Regular School No Elementary KG 05 2021   grade_1 17 2 39 0   0     0   3   35 26 *                     61.0 17 2 39 0   0     0   3   35 26                 61

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