enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
735663 735663 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No 1 01 04 2015   grade_4 162 6 0 1   3     0   0   81 91                       172 162 6 0 1   3     0   0   81 91                 172
932541 932541 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No 1 01 04 2016   grade_4 169 4 8 0   0     0   2   98 85                       183 169 4 8 0   0     0   2   98 85                 183
1121952 1121952 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No Elementary 01 04 2017   grade_4 130 2 7 1   2     0   1   73 70                       143 130 2 7 1   2     0   1   73 70                 143
1364786 1364786 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Elementary 03 04 2020   grade_4 110 7 11 0   5     0   3   61 75 *                     136.0 110 7 11 0   5     0   3   61 75                 136
1672010 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
2039812 2039812 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Elementary 03 04 2019   grade_4 143 3 13 0   4     0   2   93 72                       165.0 143 3 13 0   4     0   2   93 72                 165
2228757 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
735810 735810 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No 1 KG 05 2015   grade_4 60 4 3 0   5     0   0   37 35                       72 60 4 3 0   5     0   0   37 35                 72
735816 735816 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No 1 KG 05 2015   grade_4 65 2 6 0   7     0   8   43 45                       88 65 2 6 0   7     0   8   43 45                 88
735822 735822 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No 1 KG 05 2015   grade_4 69 3 8 0   5     0   4   36 53                       89 69 3 8 0   5     0   4   36 53                 89
735828 735828 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No 1 KG 05 2015   grade_4 33 0 1 0   9     0   3   23 23                       46 33 0 1 0   9     0   3   23 23                 46
735835 735835 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No 1 KG 05 2015   grade_4 29 5 1 0   5     0   3   20 23                       43 29 5 1 0   5     0   3   20 23                 43
735841 735841 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No 1 KG 05 2015   grade_4 33 5 2 0   8     0   7   18 37                       55 33 5 2 0   8     0   7   18 37                 55
735847 735847 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No 1 KG 05 2015   grade_4 43 3 4 0   12     0   4   34 32                       66 43 3 4 0   12     0   4   34 32                 66
932686 932686 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No 1 KG 05 2016   grade_4 61 1 2 0   10     0   3   32 45                       77 61 1 2 0   10     0   3   32 45                 77
932692 932692 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No 1 KG 05 2016   grade_4 62 1 4 0   9     0   7   43 40                       83 62 1 4 0   9     0   7   43 40                 83
932698 932698 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No 1 KG 05 2016   grade_4 62 1 2 0   9     0   2   42 34                       76 62 1 2 0   9     0   2   42 34                 76
932704 932704 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No 1 KG 05 2016   grade_4 46 4 6 0   10     1   4   34 37                       71 46 4 6 0   10     1   4   34 37                 71
932711 932711 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No 1 KG 05 2016   grade_4 33 2 6 0   4     0   3   26 22                       48 33 2 6 0   4     0   3   26 22                 48
932717 932717 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No 1 KG 05 2016   grade_4 30 2 7 0   6     0   4   22 27                       49 30 2 7 0   6     0   4   22 27                 49
932723 932723 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No 1 KG 05 2016   grade_4 49 1 4 0   11     0   2   27 40                       67 49 1 4 0   11     0   2   27 40                 67
1122128 1122128 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2017   grade_4 45 7 4 0   8     1   3   32 36                       68 45 7 4 0   8     1   3   32 36                 68
1122135 1122135 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2017   grade_4 50 1 1 0   7     0   4   36 27                       63 50 1 1 0   7     0   4   36 27                 63
1122142 1122142 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2017   grade_4 53 3 4 0   12     1   1   40 34                       74 53 3 4 0   12     1   1   40 34                 74
1122149 1122149 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2017   grade_4 41 3 4 0   9     0   4   39 22                       61 41 3 4 0   9     0   4   39 22                 61
1122158 1122158 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2017   grade_4 33 2 4 0   6     0   2   19 28                       47 33 2 4 0   6     0   2   19 28                 47
1122165 1122165 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2017   grade_4 56 4 5 1   12     0   4   46 36                       82 56 4 5 1   12     0   4   46 36                 82
1122172 1122172 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2017   grade_4 48 0 4 0   10     0   5   32 35                       67 48 0 4 0   10     0   5   32 35                 67
1364934 1364934 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2020   grade_4 46 0 2 0   14     2   6   33 37 *                     70.0 46 0 2 0   14     2   6   33 37                 70
1364940 1364940 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2020   grade_4 55 0 3 0   5     0   4   31 36 *                     67.0 55 0 3 0   5     0   4   31 36                 67
1364946 1364946 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2020   grade_4 60 1 2 0   8     0   1   35 37 *                     72.0 60 1 2 0   8     0   1   35 37                 72
1364952 1364952 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2020   grade_4 51 4 4 0   11     0   5   44 31 *                     75.0 51 4 4 0   11     0   5   44 31                 75
1364959 1364959 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2020   grade_4 31 2 2 0   6     0   1   16 26 *                     42.0 31 2 2 0   6     0   1   16 26                 42
1364965 1364965 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2020   grade_4 60 6 6 0   12     0   6   48 42 *                     90.0 60 6 6 0   12     0   6   48 42                 90
1364971 1364971 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2020   grade_4 47 4 5 0   9     0   6   32 39 *                     71.0 47 4 5 0   9     0   6   32 39                 71
1672157 1672157 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 Arlington - John A Bishop   Regular School No Elementary KG 05 2021   grade_4 51 3 2 0   11     0   0   38 29 *                     67.0 51 3 2 0   11     0   0   38 29                 67
1672163 1672163 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Arlington - Brackett   Regular School No Elementary KG 05 2021   grade_4 60 3 7 0   14     0   4   49 39 *                     88.0 60 3 7 0   14     0   4   49 39                 88
1672169 1672169 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Arlington - Cyrus E Dallin   Regular School No Elementary KG 05 2021   grade_4 63 1 0 0   15     0   1   45 35 *                     80.0 63 1 0 0   15     0   1   45 35                 80
1672175 1672175 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Arlington - Hardy   Regular School No Elementary KG 05 2021   grade_4 56 0 7 0   13     0   2   41 37 *                     78.0 56 0 7 0   13     0   2   41 37                 78
1672182 1672182 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Arlington - Peirce   Regular School No Elementary KG 05 2021   grade_4 29 1 0 0   8     0   1   26 13 *                     39.0 29 1 0 0   8     0   1   26 13                 39
1672188 1672188 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Arlington - Thompson   Regular School No Elementary KG 05 2021   grade_4 55 5 14 1   14     0   1   38 52 *                     90.0 55 5 14 1   14     0   1   38 52                 90
1672194 1672194 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 Arlington - M Norcross Stratton   Regular School No Elementary KG 05 2021   grade_4 42 2 3 0   19     0   0   37 29 *                     66.0 42 2 3 0   19     0   0   37 29                 66
2039961 2039961 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2019   grade_4 51 3 2 0   11     0   5   42 30                       72.0 51 3 2 0   11     0   5   42 30                 72
2039967 2039967 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2019   grade_4 69 2 8 0   8     1   9   53 44                       97.0 69 2 8 0   8     1   9   53 44                 97
2039973 2039973 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2019   grade_4 61 1 4 0   9     0   5   40 40                       80.0 61 1 4 0   9     0   5   40 40                 80
2039979 2039979 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2019   grade_4 45 5 4 1   11     0   3   40 29                       69.0 45 5 4 1   11     0   3   40 29                 69
2039986 2039986 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2019   grade_4 25 4 5 0   5     0   4   18 25                       43.0 25 4 5 0   5     0   4   18 25                 43
2039992 2039992 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2019   grade_4 52 5 5 1   14     0   7   44 40                       84.0 52 5 5 1   14     0   7   44 40                 84
2039998 2039998 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2019   grade_4 48 2 4 0   6     0   3   31 32                       63.0 48 2 4 0   6     0   3   31 32                 63
2228934 2228934 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 Arlington: John A Bishop   Regular School No Elementary KG 05 2018   grade_4 57 3 4 0   6     0   3   37 36                       73.0 57 3 4 0   6     0   3   37 36                 73
2228941 2228941 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Arlington: Brackett   Regular School No Elementary KG 05 2018   grade_4 68 2 4 0   6     0   7   45 42                       87.0 68 2 4 0   6     0   7   45 42                 87
2228948 2228948 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Arlington: Cyrus E Dallin   Regular School No Elementary KG 05 2018   grade_4 68 2 7 0   6     0   4   44 43                       87.0 68 2 7 0   6     0   4   44 43                 87
2228955 2228955 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Arlington: Hardy   Regular School No Elementary KG 05 2018   grade_4 45 7 5 0   5     0   4   32 34                       66.0 45 7 5 0   5     0   4   32 34                 66
2228964 2228964 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Arlington: Peirce   Regular School No Elementary KG 05 2018   grade_4 39 1 6 0   3     0   0   32 17                       49.0 39 1 6 0   3     0   0   32 17                 49
2228971 2228971 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Arlington: Thompson   Regular School No Elementary KG 05 2018   grade_4 45 3 13 0   12     0   4   40 37                       77.0 45 3 13 0   12     0   4   40 37                 77
2228978 2228978 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 Arlington: M Norcross Stratton   Regular School No Elementary KG 05 2018   grade_4 45 3 1 0   7     0   4   32 28                       60.0 45 3 1 0   7     0   4   32 28                 60
738243 738243 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No 1 KG 05 2015   grade_4 17 3 51 0   7     0   4   35 47                       82 17 3 51 0   7     0   4   35 47                 82
738249 738249 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No 1 KG 05 2015   grade_4 46 5 4 0   17     0   3   44 31                       75 46 5 4 0   17     0   3   44 31                 75
738255 738255 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No 1 KG 05 2015   grade_4 73 3 5 0   6     0   2   43 46                       89 73 3 5 0   6     0   2   43 46                 89
738261 738261 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No 1 KG 05 2015   grade_4 28 6 72 0   1     0   2   53 56                       109 28 6 72 0   1     0   2   53 56                 109
738267 738267 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No 1 KG 05 2015   grade_4 73 1 5 0   1     0   4   40 44                       84 73 1 5 0   1     0   4   40 44                 84
738273 738273 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Mary E Stapleton Elementary   Regular School No 1 KG 05 2015   grade_4 50 7 8 0   4     0   4   47 26                       73 50 7 8 0   4     0   4   47 26                 73
738279 738279 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No 1 KG 05 2015   grade_4 60 16 17 0   3     0   5   64 37                       101 60 16 17 0   3     0   5   64 37                 101
738285 738285 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No 1 KG 05 2015   grade_4 68 7 14 0   0     0   2   46 45                       91 68 7 14 0   0     0   2   46 45                 91
935097 935097 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No 1 KG 05 2016   grade_4 29 9 52 0   2     0   4   53 43                       96 29 9 52 0   2     0   4   53 43                 96
935103 935103 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No 1 KG 05 2016   grade_4 64 4 7 0   9     0   4   53 35                       88 64 4 7 0   9     0   4   53 35                 88
935109 935109 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No 1 KG 05 2016   grade_4 77 0 5 0   7     0   3   47 45                       92 77 0 5 0   7     0   3   47 45                 92
935115 935115 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No 1 KG 05 2016   grade_4 25 0 83 0   0     0   1   54 55                       109 25 0 83 0   0     0   1   54 55                 109
935121 935121 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No 1 KG 05 2016   grade_4 73 1 5 0   4     0   3   47 39                       86 73 1 5 0   4     0   3   47 39                 86
935127 935127 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Mary E Stapleton Elementary   Regular School No 1 KG 05 2016   grade_4 55 3 17 0   5     0   6   44 42                       86 55 3 17 0   5     0   6   44 42                 86
935133 935133 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No 1 KG 05 2016   grade_4 62 12 26 0   2     0   6   57 51                       108 62 12 26 0   2     0   6   57 51                 108
935139 935139 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No 1 KG 05 2016   grade_4 57 9 10 0   2     0   3   44 37                       81 57 9 10 0   2     0   3   44 37                 81
1124968 1124968 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2017   grade_4 33 7 47 0   4     0   3   45 49                       94 33 7 47 0   4     0   3   45 49                 94
1124975 1124975 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2017   grade_4 52 2 13 0   13     0   7   51 36                       87 52 2 13 0   13     0   7   51 36                 87
1124982 1124982 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2017   grade_4 74 8 6 0   5     0   4   49 48                       97 74 8 6 0   5     0   4   49 48                 97
1124989 1124989 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2017   grade_4 44 5 69 0   0     0   6   54 70                       124 44 5 69 0   0     0   6   54 70                 124
1124996 1124996 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No Elementary KG 05 2017   grade_4 65 6 4 0   6     0   5   44 42                       86 65 6 4 0   6     0   5   44 42                 86
1125003 1125003 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Mary E Stapleton Elementary   Regular School No Elementary KG 05 2017   grade_4 56 4 16 0   6     0   2   42 42                       84 56 4 16 0   6     0   2   42 42                 84
1125010 1125010 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No Elementary KG 05 2017   grade_4 49 13 27 0   3     0   6   48 50                       98 49 13 27 0   3     0   6   48 50                 98
1125017 1125017 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2017   grade_4 79 8 19 0   0     0   1   55 52                       107 79 8 19 0   0     0   1   55 52                 107
1367329 1367329 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No Elementary KG 05 2020   grade_4 43 2 14 0   6     0   2   32 35 *                     67.0 43 2 14 0   6     0   2   32 35                 67
1367335 1367335 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2020   grade_4 21 8 48 0   3     0   2   36 46 *                     82.0 21 8 48 0   3     0   2   36 46                 82
1367341 1367341 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2020   grade_4 51 3 6 0   8     0   1   33 36 *                     69.0 51 3 6 0   8     0   1   33 36                 69
1367347 1367347 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2020   grade_4 61 4 12 0   8     0   8   43 50 *                     93.0 61 4 12 0   8     0   8   43 50                 93
1367353 1367353 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2020   grade_4 19 3 80 0   0     0   5   53 53 *                     107.0 19 3 80 0   0     0   5   53 53                 107
1367359 1367359 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No Elementary KG 05 2020   grade_4 66 4 10 0   5     0   2   44 43 *                     87.0 66 4 10 0   5     0   2   44 43                 87
1367365 1367365 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Mary E Stapleton Elementary   Regular School No Elementary KG 05 2020   grade_4 37 7 8 0   2     0   4   33 25 *                     58.0 37 7 8 0   2     0   4   33 25                 58
1367371 1367371 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No Elementary KG 05 2020   grade_4 29 7 38 0   1     0   7   38 44 *                     82.0 29 7 38 0   1     0   7   38 44                 82
1367377 1367377 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2020   grade_4 49 9 37 0   0     0   4   42 57 *                     99.0 49 9 37 0   0     0   4   42 57                 99
1674563 1674563 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 Framingham - King Elementary School   Regular School No Elementary KG 05 2021   grade_4 44 4 6 0   5     0   5   37 27 *                     64.0 44 4 6 0   5     0   5   37 27                 64
1674569 1674569 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Framingham - Brophy   Regular School No Elementary KG 05 2021   grade_4 21 2 39 0   1     0   2   31 34 *                     65.0 21 2 39 0   1     0   2   31 34                 65
1674575 1674575 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Framingham - Charlotte A Dunning   Regular School No Elementary KG 05 2021   grade_4 46 9 10 0   9     0   1   46 29 *                     75.0 46 9 10 0   9     0   1   46 29                 75
1674581 1674581 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Framingham - Hemenway   Regular School No Elementary KG 05 2021   grade_4 58 6 11 1   5     0   5   37 49 *                     86.0 58 6 11 1   5     0   5   37 49                 86
1674587 1674587 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Framingham - Barbieri Elementary   Regular School No Elementary KG 05 2021   grade_4 18 6 79 0   0     0   4   53 54 *                     107.0 18 6 79 0   0     0   4   53 54                 107
1674593 1674593 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Framingham - Potter Road   Regular School No Elementary KG 05 2021   grade_4 51 10 11 0   5     1   9   47 40 *                     87.0 51 10 11 0   5     1   9   47 40                 87
1674599 1674599 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Framingham - Mary E Stapleton Elementary   Regular School No Elementary KG 05 2021   grade_4 21 1 23 0   3     0   3   30 21 *                     51.0 21 1 23 0   3     0   3   30 21                 51
1674605 1674605 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Framingham - Miriam F McCarthy School   Regular School No Elementary KG 05 2021   grade_4 38 16 35 0   0     0   4   38 55 *                     93.0 38 16 35 0   0     0   4   38 55                 93
1674611 1674611 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Framingham - Woodrow Wilson   Regular School No Elementary KG 05 2021   grade_4 47 8 37 1   0     0   1   48 46 *                     94.0 47 8 37 1   0     0   1   48 46                 94
2042401 2042401 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No Elementary KG 04 2019   grade_4 41 2 10 0   3     0   4   35 25                       60.0 41 2 10 0   3     0   4   35 25                 60
2042406 2042406 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2019   grade_4 24 4 47 0   4     0   0   45 34                       79.0 24 4 47 0   4     0   0   45 34                 79

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