enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_5 · 6,118 ✖
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
735829 735829 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No 1 KG 05 2015   grade_5 41 2 3 0   12     0   1   30 29                       59 41 2 3 0   12     0   1   30 29                 59
735836 735836 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No 1 KG 05 2015   grade_5 30 5 4 0   2     0   1   20 22                       42 30 5 4 0   2     0   1   20 22                 42
735842 735842 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No 1 KG 05 2015   grade_5 41 3 1 0   10     0   1   25 31                       56 41 3 1 0   10     0   1   25 31                 56
735848 735848 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No 1 KG 05 2015   grade_5 49 1 4 0   8     0   8   35 35                       70 49 1 4 0   8     0   8   35 35                 70
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
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
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
932705 932705 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No 1 KG 05 2016   grade_5 35 0 2 0   9     0   2   22 26                       48 35 0 2 0   9     0   2   22 26                 48
932712 932712 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No 1 KG 05 2016   grade_5 25 6 1 0   3     0   4   19 20                       39 25 6 1 0   3     0   4   19 20                 39
932718 932718 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No 1 KG 05 2016   grade_5 36 4 2 0   10     0   7   21 38                       59 36 4 2 0   10     0   7   21 38                 59
932724 932724 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No 1 KG 05 2016   grade_5 39 3 3 0   9     0   4   32 26                       58 39 3 3 0   9     0   4   32 26                 58
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
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
1122143 1122143 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2017   grade_5 64 1 2 0   8     0   2   43 34                       77 64 1 2 0   8     0   2   43 34                 77
1122150 1122150 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2017   grade_5 47 4 7 0   13     1   4   36 40                       76 47 4 7 0   13     1   4   36 40                 76
1122159 1122159 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2017   grade_5 31 1 6 0   4     0   3   24 21                       45 31 1 6 0   4     0   3   24 21                 45
1122166 1122166 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2017   grade_5 30 2 6 0   9     0   4   24 27                       51 30 2 6 0   9     0   4   24 27                 51
1122173 1122173 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2017   grade_5 47 1 4 0   10     0   2   26 38                       64 47 1 4 0   10     0   2   26 38                 64
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
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
1364947 1364947 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2020   grade_5 60 1 4 0   10     0   6   42 39 *                     81.0 60 1 4 0   10     0   6   42 39                 81
1364953 1364953 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2020   grade_5 46 5 4 1   11     0   2   39 30 *                     69.0 46 5 4 1   11     0   2   39 30                 69
1364960 1364960 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2020   grade_5 27 5 5 0   5     0   4   20 26 *                     46.0 27 5 5 0   5     0   4   20 26                 46
1364966 1364966 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2020   grade_5 48 4 5 1   16     0   6   41 39 *                     80.0 48 4 5 1   16     0   6   41 39                 80
1364972 1364972 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2020   grade_5 47 2 5 0   5     0   3   30 32 *                     62.0 47 2 5 0   5     0   3   30 32                 62
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
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
1672170 1672170 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Arlington - Cyrus E Dallin   Regular School No Elementary KG 05 2021   grade_5 59 1 2 0   6     0   2   35 35 *                     70.0 59 1 2 0   6     0   2   35 35                 70
1672176 1672176 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Arlington - Hardy   Regular School No Elementary KG 05 2021   grade_5 47 5 4 0   9     0   4   37 32 *                     69.0 47 5 4 0   9     0   4   37 32                 69
1672183 1672183 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Arlington - Peirce   Regular School No Elementary KG 05 2021   grade_5 30 2 2 0   5     0   1   14 26 *                     40.0 30 2 2 0   5     0   1   14 26                 40
1672189 1672189 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Arlington - Thompson   Regular School No Elementary KG 05 2021   grade_5 55 6 6 0   9     0   6   42 40 *                     82.0 55 6 6 0   9     0   6   42 40                 82
1672195 1672195 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 Arlington - M Norcross Stratton   Regular School No Elementary KG 05 2021   grade_5 46 4 5 0   10     0   6   34 37 *                     71.0 46 4 5 0   10     0   6   34 37                 71
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
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
2039974 2039974 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2019   grade_5 67 4 7 0   6     0   4   43 45                       88.0 67 4 7 0   6     0   4   43 45                 88
2039980 2039980 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2019   grade_5 42 7 4 0   6     0   4   32 31                       63.0 42 7 4 0   6     0   4   32 31                 63
2039987 2039987 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2019   grade_5 42 1 5 0   1     0   0   31 18                       49.0 42 1 5 0   1     0   0   31 18                 49
2039993 2039993 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2019   grade_5 42 4 13 0   12     0   4   38 37                       75.0 42 4 13 0   12     0   4   38 37                 75
2039999 2039999 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2019   grade_5 46 2 2 0   6     0   6   32 30                       62.0 46 2 2 0   6     0   6   32 30                 62
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

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