enrollments

Data source: Big Local News · About: Big Local

70,226 rows where state = "MA" sorted by ccd_school_lvl

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
735922 735922 MA Worcester   school 2502220 17   Auburn 250222000104 170015 Pakachoag   Regular School No 1 03 05 2015   grade_4 76 2 4 0   2     0   1   47 38                       85 76 2 4 0   2     0   1   47 38                 85
735923 735923 MA Worcester   school 2502220 17   Auburn 250222000104 170015 Pakachoag   Regular School No 1 03 05 2015   grade_5 80 1 6 0   4     0   5   46 50                       96 80 1 6 0   4     0   5   46 50                 96
735924 735924 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Mary D Stone   Regular School No 1 KG 02 2015   kindergarten 71 0 5 1   3     0   1   43 38                       81 71 0 5 1   3     0   1   43 38                 81
735925 735925 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Mary D Stone   Regular School No 1 KG 02 2015   grade_1 68 2 4 0   4     0   2   34 46                       80 68 2 4 0   4     0   2   34 46                 80
735926 735926 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Mary D Stone   Regular School No 1 KG 02 2015   grade_2 79 0 9 0   5     0   3   45 51                       96 79 0 9 0   5     0   3   45 51                 96
735936 735936 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No 1 PK 06 2015   kindergarten 34 6 3 0   0     0   0   18 25                       43 34 6 3 0   0     0   0   18 25                 43
735937 735937 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No 1 PK 06 2015   pre_kindergarten 13 1 3 0   1     0   1   12 7                       19 13 1 3 0   1     0   1   12 7                 19
735938 735938 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No 1 PK 06 2015   grade_1 31 10 1 2   4     0   5   27 26                       53 31 10 1 2   4     0   5   27 26                 53
735939 735939 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No 1 PK 06 2015   grade_2 39 11 2 0   3     0   5   27 33                       60 39 11 2 0   3     0   5   27 33                 60
735940 735940 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No 1 PK 06 2015   grade_3 34 17 1 2   2     0   2   28 30                       58 34 17 1 2   2     0   2   28 30                 58
735941 735941 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No 1 PK 06 2015   grade_4 33 17 5 0   1     0   2   30 28                       58 33 17 5 0   1     0   2   30 28                 58
735942 735942 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No 1 PK 06 2015   grade_5 41 11 3 0   3     0   5   36 27                       63 41 11 3 0   3     0   5   36 27                 63
735943 735943 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No 1 PK 06 2015   grade_6 33 18 2 1   3     0   2   32 27                       59 33 18 2 1   3     0   2   32 27                 59
735951 735951 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No 1 KG 03 2015   kindergarten 49 4 3 0   0     0   3   34 25                       59 49 4 3 0   0     0   3   34 25                 59
735952 735952 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No 1 KG 03 2015   grade_1 58 2 5 0   1     0   2   36 32                       68 58 2 5 0   1     0   2   36 32                 68
735953 735953 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No 1 KG 03 2015   grade_2 54 1 6 0   2     0   3   32 34                       66 54 1 6 0   2     0   3   32 34                 66
735954 735954 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No 1 KG 03 2015   grade_3 67 1 3 0   1     0   2   40 34                       74 67 1 3 0   1     0   2   40 34                 74
735955 735955 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No 1 PK 03 2015   kindergarten 69 7 8 0   0     0   1   42 43                       85 69 7 8 0   0     0   1   42 43                 85
735956 735956 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No 1 PK 03 2015   pre_kindergarten 59 16 10 1   2     0   5   65 28                       93 59 16 10 1   2     0   5   65 28                 93
735957 735957 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No 1 PK 03 2015   grade_1 74 2 9 1   2     0   0   50 38                       88 74 2 9 1   2     0   0   50 38                 88
735958 735958 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No 1 PK 03 2015   grade_2 72 2 9 0   0     0   5   44 44                       88 72 2 9 0   0     0   5   44 44                 88
735959 735959 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No 1 PK 03 2015   grade_3 55 7 6 0   2     0   3   39 34                       73 55 7 6 0   2     0   3   39 34                 73
735960 735960 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No 1 KG 03 2015   kindergarten 32 11 19 1   3     0   15   46 35                       81 32 11 19 1   3     0   15   46 35                 81
735961 735961 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No 1 KG 03 2015   grade_1 43 13 20 0   6     1   9   57 35                       92 43 13 20 0   6     1   9   57 35                 92
735962 735962 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No 1 KG 03 2015   grade_2 54 17 14 1   1     1   6   42 52                       94 54 17 14 1   1     1   6   42 52                 94
735963 735963 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No 1 KG 03 2015   grade_3 35 16 26 0   2     0   9   56 32                       88 35 16 26 0   2     0   9   56 32                 88
735964 735964 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No 1 KG 03 2015   kindergarten 83 2 3 2   1     0   3   43 51                       94 83 2 3 2   1     0   3   43 51                 94
735965 735965 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No 1 KG 03 2015   grade_1 69 18 7 0   3     1   6   46 58                       104 69 18 7 0   3     1   6   46 58                 104
735966 735966 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No 1 KG 03 2015   grade_2 118 6 5 0   2     0   4   76 59                       135 118 6 5 0   2     0   4   76 59                 135
735967 735967 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No 1 KG 03 2015   grade_3 103 3 4 0   3     0   4   60 57                       117 103 3 4 0   3     0   4   60 57                 117
735978 735978 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No 1 KG 02 2015   kindergarten 134 12 8 0   25     1   6   95 91                       186 134 12 8 0   25     1   6   95 91                 186
735979 735979 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No 1 KG 02 2015   grade_1 143 14 6 0   32     0   7   102 100                       202 143 14 6 0   32     0   7   102 100                 202
735980 735980 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No 1 KG 02 2015   grade_2 138 11 8 0   21     0   1   97 82                       179 138 11 8 0   21     0   1   97 82                 179
735981 735981 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Lt Job Lane School   Regular School No 1 03 05 2015   grade_3 113 12 10 0   20     0   9   92 72                       164 113 12 10 0   20     0   9   92 72                 164
735982 735982 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Lt Job Lane School   Regular School No 1 03 05 2015   grade_4 121 11 12 0   26     0   4   89 85                       174 121 11 12 0   26     0   4   89 85                 174
735983 735983 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Lt Job Lane School   Regular School No 1 03 05 2015   grade_5 143 10 7 0   35     0   7   105 97                       202 143 10 7 0   35     0   7   105 97                 202
735992 735992 MA Hampshire   school 2502430 24   Belchertown 250243000136 240005 Cold Spring   Regular School No 1 PK KG 2015   kindergarten 117 2 10 0   1     0   6   76 60                       136 117 2 10 0   1     0   6   76 60                 136
735993 735993 MA Hampshire   school 2502430 24   Belchertown 250243000136 240005 Cold Spring   Regular School No 1 PK KG 2015   pre_kindergarten 26 1 0 0   2     0   0   22 7                       29 26 1 0 0   2     0   0   22 7                 29
735997 735997 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Swift River Elementary   Regular School No 1 01 03 2015   grade_1 161 0 5 0   2     0   3   84 87                       171 161 0 5 0   2     0   3   84 87                 171
735998 735998 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Swift River Elementary   Regular School No 1 01 03 2015   grade_2 158 5 3 0   4     1   1   98 74                       172 158 5 3 0   4     1   1   98 74                 172
735999 735999 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Swift River Elementary   Regular School No 1 01 03 2015   grade_3 163 1 11 0   1     0   1   77 100                       177 163 1 11 0   1     0   1   77 100                 177
736006 736006 MA Norfolk   school 2502460 25   Bellingham 250246000670 250003 Bellingham Early Childhood Center   Regular School No 1 PK PK 2015   pre_kindergarten 93 0 0 0   0     0   0   51 42                       93 93 0 0 0   0     0   0   51 42                 93
736007 736007 MA Norfolk   school 2502460 25   Bellingham 250246000140 250009 Clara Macy Elementary   Regular School No 1 KG 04 2015   kindergarten 37 0 1 0   1     0   2   16 25                       41 37 0 1 0   1     0   2   16 25                 41
736008 736008 MA Norfolk   school 2502460 25   Bellingham 250246000140 250009 Clara Macy Elementary   Regular School No 1 KG 04 2015   grade_1 55 0 2 0   2     0   3   29 33                       62 55 0 2 0   2     0   3   29 33                 62
736009 736009 MA Norfolk   school 2502460 25   Bellingham 250246000140 250009 Clara Macy Elementary   Regular School No 1 KG 04 2015   grade_2 38 0 0 0   3     0   0   23 18                       41 38 0 0 0   3     0   0   23 18                 41
736010 736010 MA Norfolk   school 2502460 25   Bellingham 250246000140 250009 Clara Macy Elementary   Regular School No 1 KG 04 2015   grade_3 39 1 5 0   1     0   1   21 26                       47 39 1 5 0   1     0   1   21 26                 47
736011 736011 MA Norfolk   school 2502460 25   Bellingham 250246000140 250009 Clara Macy Elementary   Regular School No 1 KG 04 2015   grade_4 36 0 1 0   4     0   1   20 22                       42 36 0 1 0   4     0   1   20 22                 42
736012 736012 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 South Elementary   Regular School No 1 KG 04 2015   kindergarten 78 1 1 0   2     0   1   38 45                       83 78 1 1 0   2     0   1   38 45                 83
736013 736013 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 South Elementary   Regular School No 1 KG 04 2015   grade_1 70 3 0 0   1     0   0   35 39                       74 70 3 0 0   1     0   0   35 39                 74
736014 736014 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 South Elementary   Regular School No 1 KG 04 2015   grade_2 82 0 2 0   5     0   0   40 49                       89 82 0 2 0   5     0   0   40 49                 89
736015 736015 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 South Elementary   Regular School No 1 KG 04 2015   grade_3 79 1 2 0   7     0   1   49 41                       90 79 1 2 0   7     0   1   49 41                 90
736016 736016 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 South Elementary   Regular School No 1 KG 04 2015   grade_4 93 1 4 0   2     0   0   47 53                       100 93 1 4 0   2     0   0   47 53                 100
736017 736017 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No 1 KG 04 2015   kindergarten 52 3 1 0   2     0   1   30 29                       59 52 3 1 0   2     0   1   30 29                 59
736018 736018 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No 1 KG 04 2015   grade_1 46 1 3 0   3     0   2   23 32                       55 46 1 3 0   3     0   2   23 32                 55
736019 736019 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No 1 KG 04 2015   grade_2 39 1 4 0   5     0   1   24 26                       50 39 1 4 0   5     0   1   24 26                 50
736020 736020 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No 1 KG 04 2015   grade_3 47 0 3 0   1     0   1   28 24                       52 47 0 3 0   1     0   1   28 24                 52
736021 736021 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No 1 KG 04 2015   grade_4 33 3 2 0   1     0   0   23 16                       39 33 3 2 0   1     0   0   23 16                 39
736035 736035 MA Middlesex   school 2502490 26   Belmont 250249000148 260005 Winn Brook   Regular School No 1 KG 04 2015   kindergarten 63 1 4 0   24     0   3   53 42                       95 63 1 4 0   24     0   3   53 42                 95
736036 736036 MA Middlesex   school 2502490 26   Belmont 250249000148 260005 Winn Brook   Regular School No 1 KG 04 2015   grade_1 53 1 3 1   28     0   9   46 49                       95 53 1 3 1   28     0   9   46 49                 95
736037 736037 MA Middlesex   school 2502490 26   Belmont 250249000148 260005 Winn Brook   Regular School No 1 KG 04 2015   grade_2 55 3 2 0   29     0   6   46 49                       95 55 3 2 0   29     0   6   46 49                 95
736038 736038 MA Middlesex   school 2502490 26   Belmont 250249000148 260005 Winn Brook   Regular School No 1 KG 04 2015   grade_3 65 0 3 1   20     0   4   42 51                       93 65 0 3 1   20     0   4   42 51                 93
736039 736039 MA Middlesex   school 2502490 26   Belmont 250249000148 260005 Winn Brook   Regular School No 1 KG 04 2015   grade_4 64 2 3 0   14     0   4   45 42                       87 64 2 3 0   14     0   4   45 42                 87
736040 736040 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Mary Lee Burbank   Regular School No 1 KG 04 2015   kindergarten 54 0 2 0   11     0   4   34 37                       71 54 0 2 0   11     0   4   34 37                 71
736041 736041 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Mary Lee Burbank   Regular School No 1 KG 04 2015   grade_1 41 0 0 0   19     0   8   36 32                       68 41 0 0 0   19     0   8   36 32                 68
736042 736042 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Mary Lee Burbank   Regular School No 1 KG 04 2015   grade_2 48 1 6 0   12     1   2   36 34                       70 48 1 6 0   12     1   2   36 34                 70
736043 736043 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Mary Lee Burbank   Regular School No 1 KG 04 2015   grade_3 45 2 8 0   9     0   7   33 38                       71 45 2 8 0   9     0   7   33 38                 71
736044 736044 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Mary Lee Burbank   Regular School No 1 KG 04 2015   grade_4 47 1 2 0   15     0   6   40 31                       71 47 1 2 0   15     0   6   40 31                 71
736045 736045 MA Middlesex   school 2502490 26   Belmont 250249000144 260015 Daniel Butler   Regular School No 1 KG 04 2015   kindergarten 44 3 3 1   15     0   6   44 28                       72 44 3 3 1   15     0   6   44 28                 72
736046 736046 MA Middlesex   school 2502490 26   Belmont 250249000144 260015 Daniel Butler   Regular School No 1 KG 04 2015   grade_1 42 2 7 1   13     0   2   31 36                       67 42 2 7 1   13     0   2   31 36                 67
736047 736047 MA Middlesex   school 2502490 26   Belmont 250249000144 260015 Daniel Butler   Regular School No 1 KG 04 2015   grade_2 39 3 3 0   16     0   5   35 31                       66 39 3 3 0   16     0   5   35 31                 66
736048 736048 MA Middlesex   school 2502490 26   Belmont 250249000144 260015 Daniel Butler   Regular School No 1 KG 04 2015   grade_3 34 1 4 0   18     0   5   36 26                       62 34 1 4 0   18     0   5   36 26                 62
736049 736049 MA Middlesex   school 2502490 26   Belmont 250249000144 260015 Daniel Butler   Regular School No 1 KG 04 2015   grade_4 43 8 2 0   17     0   4   41 33                       74 43 8 2 0   17     0   4   41 33                 74
736050 736050 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No 1 PK 04 2015   kindergarten 89 3 0 0   13     0   10   63 52                       115 89 3 0 0   13     0   10   63 52                 115
736051 736051 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No 1 PK 04 2015   pre_kindergarten 47 0 2 1   9     0   4   38 25                       63 47 0 2 1   9     0   4   38 25                 63
736052 736052 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No 1 PK 04 2015   grade_1 72 2 3 0   23     0   11   64 47                       111 72 2 3 0   23     0   11   64 47                 111
736053 736053 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No 1 PK 04 2015   grade_2 73 3 3 0   14     0   8   56 45                       101 73 3 3 0   14     0   8   56 45                 101
736054 736054 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No 1 PK 04 2015   grade_3 94 4 8 0   9     0   6   69 52                       121 94 4 8 0   9     0   6   69 52                 121
736055 736055 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No 1 PK 04 2015   grade_4 76 3 0 0   9     1   5   37 57                       94 76 3 0 0   9     1   5   37 57                 94
736064 736064 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No 1 PK 04 2015   kindergarten 75 0 1 0   0     0   2   44 34                       78 75 0 1 0   0     0   2   44 34                 78
736065 736065 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No 1 PK 04 2015   pre_kindergarten 64 0 2 0   0     0   1   34 33                       67 64 0 2 0   0     0   1   34 33                 67
736066 736066 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No 1 PK 04 2015   grade_1 94 0 0 0   0     0   1   50 45                       95 94 0 0 0   0     0   1   50 45                 95
736067 736067 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No 1 PK 04 2015   grade_2 76 0 1 0   0     0   1   40 38                       78 76 0 1 0   0     0   1   40 38                 78
736068 736068 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No 1 PK 04 2015   grade_3 76 1 2 0   0     0   0   39 40                       79 76 1 2 0   0     0   0   39 40                 79
736069 736069 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No 1 PK 04 2015   grade_4 86 1 0 0   0     0   2   47 42                       89 86 1 0 0   0     0   2   47 42                 89
736074 736074 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No 1 PK 05 2015   kindergarten 18 0 2 0   0     0   0   14 6                       20 18 0 2 0   0     0   0   14 6                 20
736075 736075 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No 1 PK 05 2015   pre_kindergarten 17 1 2 0   0     0   2   16 6                       22 17 1 2 0   0     0   2   16 6                 22
736076 736076 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No 1 PK 05 2015   grade_1 23 0 2 0   1     0   0   15 11                       26 23 0 2 0   1     0   0   15 11                 26
736077 736077 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No 1 PK 05 2015   grade_2 25 0 1 0   0     0   1   13 14                       27 25 0 1 0   0     0   1   13 14                 27
736078 736078 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No 1 PK 05 2015   grade_3 31 0 0 0   2     0   3   23 13                       36 31 0 0 0   2     0   3   23 13                 36
736079 736079 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No 1 PK 05 2015   grade_4 25 0 1 0   0     0   0   15 11                       26 25 0 1 0   0     0   0   15 11                 26
736080 736080 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No 1 PK 05 2015   grade_5 28 0 0 0   0     0   1   19 10                       29 28 0 0 0   0     0   1   19 10                 29
736081 736081 MA Essex   school 2502640 30   Beverly 250264000167 300010 Centerville Elementary   Regular School No 1 KG 05 2015   kindergarten 38 0 3 0   1     0   3   18 27                       45 38 0 3 0   1     0   3   18 27                 45
736082 736082 MA Essex   school 2502640 30   Beverly 250264000167 300010 Centerville Elementary   Regular School No 1 KG 05 2015   grade_1 49 3 9 0   2     0   1   31 33                       64 49 3 9 0   2     0   1   31 33                 64
736083 736083 MA Essex   school 2502640 30   Beverly 250264000167 300010 Centerville Elementary   Regular School No 1 KG 05 2015   grade_2 47 5 7 0   1     0   2   34 28                       62 47 5 7 0   1     0   2   34 28                 62
736084 736084 MA Essex   school 2502640 30   Beverly 250264000167 300010 Centerville Elementary   Regular School No 1 KG 05 2015   grade_3 34 3 9 0   0     0   2   30 18                       48 34 3 9 0   0     0   2   30 18                 48
736085 736085 MA Essex   school 2502640 30   Beverly 250264000167 300010 Centerville Elementary   Regular School No 1 KG 05 2015   grade_4 58 1 7 0   0     0   2   43 25                       68 58 1 7 0   0     0   2   43 25                 68
736086 736086 MA Essex   school 2502640 30   Beverly 250264000167 300010 Centerville Elementary   Regular School No 1 KG 05 2015   grade_5 43 3 6 0   1     0   1   30 24                       54 43 3 6 0   1     0   1   30 24                 54
736087 736087 MA Essex   school 2502640 30   Beverly 250264000168 300015 Cove Elementary   Regular School No 1 PK 05 2015   kindergarten 90 5 8 0   1     0   2   53 53                       106 90 5 8 0   1     0   2   53 53                 106
736088 736088 MA Essex   school 2502640 30   Beverly 250264000168 300015 Cove Elementary   Regular School No 1 PK 05 2015   pre_kindergarten 72 4 11 0   1     0   6   54 40                       94 72 4 11 0   1     0   6   54 40                 94
736089 736089 MA Essex   school 2502640 30   Beverly 250264000168 300015 Cove Elementary   Regular School No 1 PK 05 2015   grade_1 59 2 14 0   0     0   7   45 37                       82 59 2 14 0   0     0   7   45 37                 82

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