enrollments

Data source: Big Local News · About: Big Local

6,218 rows where grade = "grade_5" and state = "MA" sorted by school_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_5 · 6,218 ✖
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
735664 735664 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No 2 05 06 2015   grade_5 146 1 6 0   3     0   0   84 72                       156 146 1 6 0   3     0   0   84 72                 156
932542 932542 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No 2 05 06 2016   grade_5 157 8 3 0   2     0   3   83 90                       173 157 8 3 0   2     0   3   83 90                 173
1121954 1121954 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Middle 05 06 2017   grade_5 169 1 7 0   3     0   0   97 83                       180 169 1 7 0   3     0   0   97 83                 180
1364790 1364790 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2020   grade_5 138 5 16 0   5     0   3   96 71 *                     167.0 138 5 16 0   5     0   3   96 71                 167
1672014 1672014 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington - Abington Middle School   Regular School No Middle 05 08 2021   grade_5 109 7 15 0   5     0   4   58 82 *                     140.0 109 7 15 0   5     0   4   58 82                 140
2039816 2039816 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2019   grade_5 134 4 14 2   4     0   1   85 74                       159.0 134 4 14 2   4     0   1   85 74                 159
2228763 2228763 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington: Abington Middle School   Regular School No Middle 05 08 2018   grade_5 138 1 8 1   3     0   3   80 74                       154.0 138 1 8 1   3     0   3   80 74                 154
735679 735679 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No 2 05 08 2015   grade_5 76 0 2 0   0     0   0   40 38                       78 76 0 2 0   0     0   0   40 38                 78
932557 932557 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No 2 05 08 2016   grade_5 115 0 1 0   0     0   0   62 54                       116 115 0 1 0   0     0   0   62 54                 116
1121972 1121972 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2017   grade_5 103 1 0 0   0     0   1   58 47                       105 103 1 0 0   0     0   1   58 47                 105
1364805 1364805 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2020   grade_5 97 0 8 0   1     0   4   49 61 *                     110.0 97 0 8 0   1     0   4   49 61                 110
1672029 1672029 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet - Albert F Ford Middle School   Regular School No Middle 05 08 2021   grade_5 96 0 3 0   1     0   8   57 51 *                     108.0 96 0 3 0   1     0   8   57 51                 108
2039831 2039831 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2019   grade_5 97 1 3 0   1     0   0   60 42                       102.0 97 1 3 0   1     0   0   60 42                 102
2228780 2228780 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet: Albert F Ford Middle School   Regular School No Middle 05 08 2018   grade_5 100 1 2 0   0     0   0   59 44                       103.0 100 1 2 0   0     0   0   59 44                 103
735704 735704 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No 2 05 08 2015   grade_5 226 4 18 0   8     0   10   120 146                       266 226 4 18 0   8     0   10   120 146                 266
932582 932582 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No 2 04 08 2016   grade_5 254 7 24 0   14     0   7   160 146                       306 254 7 24 0   14     0   7   160 146                 306
1122003 1122003 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No Middle 05 08 2017   grade_5 243 8 16 0   12     0   11   162 128                       290 243 8 16 0   12     0   11   162 128                 290
1364830 1364830 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No Middle 05 08 2020   grade_5 213 11 33 0   10     0   7   164 110 *                     274.0 213 11 33 0   10     0   7   164 110                 274
1672054 1672054 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Agawam - Roberta G. Doering School   Regular School No Middle 05 08 2021   grade_5 215 3 24 0   6     0   6   132 122 *                     254.0 215 3 24 0   6     0   6   132 122                 254
2039856 2039856 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No Middle 05 07 2019   grade_5 252 3 35 0   13     0   13   145 171                       316.0 252 3 35 0   13     0   13   145 171                 316
2228811 2228811 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Agawam: Roberta G. Doering School   Regular School No Middle 05 08 2018   grade_5 237 10 14 0   5     0   5   131 140                       271.0 237 10 14 0   5     0   5   131 140                 271
735726 735726 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No 2 05 08 2015   grade_5 166 1 3 0   3     0   4   96 81                       177 166 1 3 0   3     0   4   96 81                 177
932604 932604 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No 2 05 08 2016   grade_5 149 1 8 0   0     0   8   85 81                       166 149 1 8 0   0     0   8   85 81                 166
1122030 1122030 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2017   grade_5 150 3 14 0   3     1   2   79 94                       173 150 3 14 0   3     1   2   79 94                 173
1364850 1364850 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2020   grade_5 150 1 16 1   5     0   8   96 85 *                     181.0 150 1 16 1   5     0   8   96 85                 181
1672074 1672074 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury - Amesbury Middle   Regular School No Middle 05 08 2021   grade_5 129 3 15 1   2     0   7   81 76 *                     157.0 129 3 15 1   2     0   7   81 76                 157
2039877 2039877 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2019   grade_5 133 4 15 0   2     0   8   94 68                       162.0 133 4 15 0   2     0   8   94 68                 162
2228836 2228836 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury: Amesbury Middle   Regular School No Middle 05 08 2018   grade_5 145 1 13 1   2     1   4   81 86                       167.0 145 1 13 1   2     1   4   81 86                 167
735741 735741 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No 1 PK 06 2015   grade_5 27 2 6 0   11     0   1   23 24                       47 27 2 6 0   11     0   1   23 24                 47
932621 932621 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No 1 PK 06 2016   grade_5 27 6 11 0   9     0   2   30 25                       55 27 6 11 0   9     0   2   30 25                 55
1122051 1122051 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2017   grade_5 29 3 15 0   4     0   9   26 34                       60 29 3 15 0   4     0   9   26 34                 60
1364869 1364869 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2020   grade_5 26 2 16 0   7     0   3   28 26 *                     54.0 26 2 16 0   7     0   3   28 26                 54
1672092 1672092 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst - Crocker Farm Elementary   Regular School No Elementary PK 06 2021   grade_5 30 7 10 0   9     0   0   29 27 *                     56.0 30 7 10 0   9     0   0   29 27                 56
2039896 2039896 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2019   grade_5 26 3 21 0   6     0   6   36 26                       62.0 26 3 21 0   6     0   6   36 26                 62
2228857 2228857 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst: Crocker Farm Elementary   Regular School No Elementary PK 06 2018   grade_5 15 7 8 0   7     0   2   19 20                       39.0 15 7 8 0   7     0   2   19 20                 39
735748 735748 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No 1 KG 06 2015   grade_5 36 3 11 1   6     1   2   25 35                       60 36 3 11 1   6     1   2   25 35                 60
932628 932628 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No 1 KG 06 2016   grade_5 20 3 8 0   6     0   3   23 17                       40 20 3 8 0   6     0   3   23 17                 40
1122059 1122059 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2017   grade_5 28 11 14 0   3     0   3   29 30                       59 28 11 14 0   3     0   3   29 30                 59
1364876 1364876 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2020   grade_5 21 2 10 0   7     0   2   21 21 *                     42.0 21 2 10 0   7     0   2   21 21                 42
1672099 1672099 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Amherst - Fort River Elementary   Regular School No Elementary KG 06 2021   grade_5 24 2 9 0   8     1   1   24 21 *                     45.0 24 2 9 0   8     1   1   24 21                 45
2039903 2039903 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2019   grade_5 25 6 10 0   4     0   2   18 29                       47.0 25 6 10 0   4     0   2   18 29                 47
2228865 2228865 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Amherst: Fort River Elementary   Regular School No Elementary KG 06 2018   grade_5 36 7 17 0   8     0   5   45 28                       73.0 36 7 17 0   8     0   5   45 28                 73
735755 735755 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No 1 KG 06 2015   grade_5 39 7 11 0   6     0   3   35 31                       66 39 7 11 0   6     0   3   35 31                 66
932635 932635 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No 1 KG 06 2016   grade_5 28 6 9 0   9     0   6   28 30                       58 28 6 9 0   9     0   6   28 30                 58
1122067 1122067 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2017   grade_5 26 6 15 1   4     0   5   29 28                       57 26 6 15 1   4     0   5   29 28                 57
1364883 1364883 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2020   grade_5 27 4 9 0   5     0   5   33 17 *                     50.0 27 4 9 0   5     0   5   33 17                 50
1672106 1672106 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Amherst - Wildwood Elementary   Regular School No Elementary KG 06 2021   grade_5 31 9 12 0   5     0   3   30 30 *                     60.0 31 9 12 0   5     0   3   30 30                 60
2039910 2039910 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2019   grade_5 35 4 11 0   9     0   7   33 33                       66.0 35 4 11 0   9     0   7   33 33                 66
2228873 2228873 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Amherst: Wildwood Elementary   Regular School No Elementary KG 06 2018   grade_5 30 6 12 0   12     0   10   41 29                       70.0 30 6 12 0   12     0   10   41 29                 70
735762 735762 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No 1 KG 05 2015   grade_5 57 1 2 1   6     0   3   43 27                       70 57 1 2 1   6     0   3   43 27                 70
932642 932642 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No 1 KG 05 2016   grade_5 104 0 3 1   15     0   4   65 62                       127 104 0 3 1   15     0   4   65 62                 127
1122075 1122075 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2017   grade_5 93 4 10 0   6     0   5   57 61                       118 93 4 10 0   6     0   5   57 61                 118
1364890 1364890 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2020   grade_5 76 3 7 0   12     0   5   53 50 *                     103.0 76 3 7 0   12     0   5   53 50                 103
1672113 1672113 MA Essex   school 2501950 9   Andover 250195000047 90003 Andover - Bancroft Elementary   Regular School No Elementary KG 05 2021   grade_5 74 2 9 0   8     0   6   56 43 *                     99.0 74 2 9 0   8     0   6   56 43                 99
2039917 2039917 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2019   grade_5 80 4 11 0   8     0   7   54 56                       110.0 80 4 11 0   8     0   7   54 56                 110
2228881 2228881 MA Essex   school 2501950 9   Andover 250195000047 90003 Andover: Bancroft Elementary   Regular School No Elementary KG 05 2018   grade_5 88 3 8 1   10     0   5   58 57                       115.0 88 3 8 1   10     0   5   58 57                 115
735768 735768 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No 1 KG 05 2015   grade_5 65 1 12 1   27     0   4   55 55                       110 65 1 12 1   27     0   4   55 55                 110
932648 932648 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No 1 KG 05 2016   grade_5 63 3 9 0   23     0   3   45 56                       101 63 3 9 0   23     0   3   45 56                 101
1122082 1122082 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No Elementary KG 05 2017   grade_5 62 4 8 0   29     0   4   58 49                       107 62 4 8 0   29     0   4   58 49                 107
1364896 1364896 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No Elementary KG 05 2020   grade_5 47 3 11 0   29     0   6   52 44 *                     96.0 47 3 11 0   29     0   6   52 44                 96
1672119 1672119 MA Essex   school 2501950 9   Andover 250195001676 90004 Andover - High Plain Elementary   Regular School No Elementary KG 05 2021   grade_5 48 5 7 0   28     0   3   50 41 *                     91.0 48 5 7 0   28     0   3   50 41                 91
2039923 2039923 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No Elementary KG 05 2019   grade_5 61 3 7 0   34     1   5   51 60                       111.0 61 3 7 0   34     1   5   51 60                 111
2228888 2228888 MA Essex   school 2501950 9   Andover 250195001676 90004 Andover: High Plain Elementary   Regular School No Elementary KG 05 2018   grade_5 48 2 9 0   37     0   0   61 35                       96.0 48 2 9 0   37     0   0   61 35                 96
735778 735778 MA Essex   school 2501950 9   Andover 250195000048 90010 Henry C Sanborn Elementary   Regular School No 1 KG 05 2015   grade_5 47 1 4 0   13     0   1   33 33                       66 47 1 4 0   13     0   1   33 33                 66
932655 932655 MA Essex   school 2501950 9   Andover 250195000048 90010 Henry C Sanborn Elementary   Regular School No 1 KG 05 2016   grade_5 45 0 2 0   23     0   3   33 40                       73 45 0 2 0   23     0   3   33 40                 73
1122091 1122091 MA Essex   school 2501950 9   Andover 250195000048 90010 Henry C Sanborn Elementary   Regular School No Elementary KG 05 2017   grade_5 43 3 5 2   17     0   2   42 30                       72 43 3 5 2   17     0   2   42 30                 72
1364903 1364903 MA Essex   school 2501950 9   Andover 250195000048 90010 Henry C Sanborn Elementary   Regular School No Elementary KG 05 2020   grade_5 46 4 5 0   18     0   1   38 36 *                     74.0 46 4 5 0   18     0   1   38 36                 74
1672126 1672126 MA Essex   school 2501950 9   Andover 250195000048 90010 Andover - Henry C Sanborn Elementary   Regular School No Elementary KG 05 2021   grade_5 51 1 1 0   17     0   2   36 36 *                     72.0 51 1 1 0   17     0   2   36 36                 72
2039930 2039930 MA Essex   school 2501950 9   Andover 250195000048 90010 Henry C Sanborn Elementary   Regular School No Elementary KG 05 2019   grade_5 48 2 2 0   13     0   2   47 20                       67.0 48 2 2 0   13     0   2   47 20                 67
2228897 2228897 MA Essex   school 2501950 9   Andover 250195000048 90010 Andover: Henry C Sanborn Elementary   Regular School No Elementary KG 05 2018   grade_5 46 1 4 0   22     0   0   33 40                       73.0 46 1 4 0   22     0   0   33 40                 73
735784 735784 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No 1 KG 05 2015   grade_5 78 0 3 0   22     0   3   56 50                       106 78 0 3 0   22     0   3   56 50                 106
932661 932661 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No 1 KG 05 2016   grade_5 69 0 3 1   18     0   2   46 47                       93 69 0 3 1   18     0   2   46 47                 93
1122098 1122098 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No Elementary KG 05 2017   grade_5 66 0 4 0   19     0   0   40 49                       89 66 0 4 0   19     0   0   40 49                 89
1364909 1364909 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No Elementary KG 05 2020   grade_5 50 1 4 0   18     0   0   41 32 *                     73.0 50 1 4 0   18     0   0   41 32                 73
1672132 1672132 MA Essex   school 2501950 9   Andover 250195000050 90020 Andover - South Elementary   Regular School No Elementary KG 05 2021   grade_5 66 1 5 1   15     0   2   38 52 *                     90.0 66 1 5 1   15     0   2   38 52                 90
2039936 2039936 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No Elementary KG 05 2019   grade_5 69 0 1 0   17     0   0   37 50                       87.0 69 0 1 0   17     0   0   37 50                 87
2228904 2228904 MA Essex   school 2501950 9   Andover 250195000050 90020 Andover: South Elementary   Regular School No Elementary KG 05 2018   grade_5 63 0 3 0   20     1   0   45 42                       87.0 63 0 3 0   20     1   0   45 42                 87
735791 735791 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No 1 PK 05 2015   grade_5 103 3 8 0   21     0   2   65 72                       137 103 3 8 0   21     0   2   65 72                 137
932667 932667 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No 1 KG 05 2016   grade_5 105 2 5 0   14     0   6   66 66                       132 105 2 5 0   14     0   6   66 66                 132
1122105 1122105 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2017   grade_5 89 5 7 0   13     0   5   68 51                       119 89 5 7 0   13     0   5   68 51                 119
1364915 1364915 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2020   grade_5 85 1 10 0   15     0   5   56 60 *                     116.0 85 1 10 0   15     0   5   56 60                 116
1672138 1672138 MA Essex   school 2501950 9   Andover 250195000051 90025 Andover - West Elementary   Regular School No Elementary KG 05 2021   grade_5 74 2 7 0   22     0   1   52 54 *                     106.0 74 2 7 0   22     0   1   52 54                 106
2039942 2039942 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2019   grade_5 66 7 11 0   19     0   1   43 61                       104.0 66 7 11 0   19     0   1   43 61                 104
2228911 2228911 MA Essex   school 2501950 9   Andover 250195000051 90025 Andover: West Elementary   Regular School No Elementary KG 05 2018   grade_5 77 2 7 1   19     0   7   68 45                       113.0 77 2 7 1   19     0   7   68 45                 113
735811 735811 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No 1 KG 05 2015   grade_5 49 3 1 0   6     0   0   28 31                       59 49 3 1 0   6     0   0   28 31                 59
932687 932687 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No 1 KG 05 2016   grade_5 57 4 2 0   5     0   0   33 35                       68 57 4 2 0   5     0   0   33 35                 68
1122129 1122129 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2017   grade_5 62 1 2 0   8     0   3   30 46                       76 62 1 2 0   8     0   3   30 46                 76
1364935 1364935 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2020   grade_5 51 2 1 0   10     0   5   41 28 *                     69.0 51 2 1 0   10     0   5   41 28                 69
1672158 1672158 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 Arlington - John A Bishop   Regular School No Elementary KG 05 2021   grade_5 42 0 1 0   14     2   6   31 34 *                     65.0 42 0 1 0   14     2   6   31 34                 65
2039962 2039962 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2019   grade_5 54 3 3 0   7     0   4   35 36                       71.0 54 3 3 0   7     0   4   35 36                 71
2228935 2228935 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 Arlington: John A Bishop   Regular School No Elementary KG 05 2018   grade_5 44 5 4 0   8     1   3   32 33                       65.0 44 5 4 0   8     1   3   32 33                 65
735817 735817 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No 1 KG 05 2015   grade_5 50 0 5 0   7     0   7   32 37                       69 50 0 5 0   7     0   7   32 37                 69
932693 932693 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No 1 KG 05 2016   grade_5 70 1 7 0   5     0   8   45 46                       91 70 1 7 0   5     0   8   45 46                 91
1122136 1122136 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2017   grade_5 60 1 4 0   10     0   7   41 41                       82 60 1 4 0   10     0   7   41 41                 82
1364941 1364941 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2020   grade_5 71 2 8 0   9     1   9   55 45 *                     100.0 71 2 8 0   9     1   9   55 45                 100
1672164 1672164 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Arlington - Brackett   Regular School No Elementary KG 05 2021   grade_5 53 0 3 0   4     0   4   30 34 *                     64.0 53 0 3 0   4     0   4   30 34                 64
2039968 2039968 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2019   grade_5 63 2 4 0   5     0   7   42 39                       81.0 63 2 4 0   5     0   7   42 39                 81
2228942 2228942 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Arlington: Brackett   Regular School No Elementary KG 05 2018   grade_5 52 1 4 0   9     0   4   38 32                       70.0 52 1 4 0   9     0   4   38 32                 70
735823 735823 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No 1 KG 05 2015   grade_5 59 2 1 0   8     0   3   30 43                       73 59 2 1 0   8     0   3   30 43                 73
932699 932699 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No 1 KG 05 2016   grade_5 77 3 7 0   5     0   4   40 56                       96 77 3 7 0   5     0   4   40 56                 96

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