enrollments

Data source: Big Local News · About: Big Local

11,264 rows where state = "MA" and year = 2017 sorted by ccd_school_lvl

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 11,164 ✖
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
1122090 1122090 MA Essex   school 2501950 9   Andover 250195000048 90010 Henry C Sanborn Elementary   Regular School No Elementary KG 05 2017   grade_4 43 0 3 0   22     0   0   30 38                       68 43 0 3 0   22     0   0   30 38                 68
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
1122092 1122092 MA Essex   school 2501950 9   Andover 250195000048 90010 Henry C Sanborn Elementary   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122093 1122093 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No Elementary KG 05 2017   kindergarten 62 0 1 0   6     0   1   42 28                       70 62 0 1 0   6     0   1   42 28                 70
1122094 1122094 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No Elementary KG 05 2017   grade_1 66 0 7 1   15     0   2   42 49                       91 66 0 7 1   15     0   2   42 49                 91
1122095 1122095 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No Elementary KG 05 2017   grade_2 50 0 2 0   16     0   0   41 27                       68 50 0 2 0   16     0   0   41 27                 68
1122096 1122096 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No Elementary KG 05 2017   grade_3 69 0 5 0   16     0   0   42 48                       90 69 0 5 0   16     0   0   42 48                 90
1122097 1122097 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No Elementary KG 05 2017   grade_4 60 0 5 0   19     1   0   44 41                       85 60 0 5 0   19     1   0   44 41                 85
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
1122099 1122099 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122100 1122100 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2017   kindergarten 70 3 5 0   16     0   2   49 47                       96 70 3 5 0   16     0   2   49 47                 96
1122101 1122101 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2017   grade_1 75 1 7 0   16     0   0   49 50                       99 75 1 7 0   16     0   0   49 50                 99
1122102 1122102 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2017   grade_2 82 1 5 0   15     0   4   50 57                       107 82 1 5 0   15     0   4   50 57                 107
1122103 1122103 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2017   grade_3 71 7 10 0   14     0   1   45 58                       103 71 7 10 0   14     0   1   45 58                 103
1122104 1122104 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2017   grade_4 74 2 9 1   19     0   7   68 44                       112 74 2 9 1   19     0   7   68 44                 112
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
1122106 1122106 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122124 1122124 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2017   kindergarten 51 3 2 0   13     0   0   39 30                       69 51 3 2 0   13     0   0   39 30                 69
1122125 1122125 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2017   grade_1 49 1 1 0   16     2   4   33 40                       73 49 1 1 0   16     2   4   33 40                 73
1122126 1122126 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2017   grade_2 49 3 1 0   10     0   6   40 29                       69 49 3 1 0   10     0   6   40 29                 69
1122127 1122127 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2017   grade_3 54 3 3 0   7     0   3   36 34                       70 54 3 3 0   7     0   3   36 34                 70
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
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
1122130 1122130 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122131 1122131 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2017   kindergarten 67 2 2 0   17     0   1   50 39                       89 67 2 2 0   17     0   1   50 39                 89
1122132 1122132 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2017   grade_1 58 0 3 0   4     0   5   35 35                       70 58 0 3 0   4     0   5   35 35                 70
1122133 1122133 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2017   grade_2 68 1 8 0   7     1   8   48 45                       93 68 1 8 0   7     1   8   48 45                 93
1122134 1122134 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2017   grade_3 64 2 4 0   4     0   5   38 41                       79 64 2 4 0   4     0   5   38 41                 79
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
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
1122137 1122137 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122138 1122138 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2017   kindergarten 65 0 2 0   19     0   1   47 40                       87 65 0 2 0   19     0   1   47 40                 87
1122139 1122139 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2017   grade_1 59 1 3 0   5     0   2   37 33                       70 59 1 3 0   5     0   2   37 33                 70
1122140 1122140 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2017   grade_2 61 1 4 0   8     0   5   37 42                       79 61 1 4 0   8     0   5   37 42                 79
1122141 1122141 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2017   grade_3 61 2 6 0   6     0   4   38 41                       79 61 2 6 0   6     0   4   38 41                 79
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
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
1122144 1122144 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122145 1122145 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2017   kindergarten 67 1 9 0   18     0   0   53 42                       95 67 1 9 0   18     0   0   53 42                 95
1122146 1122146 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2017   grade_1 59 4 3 0   11     1   1   39 40                       79 59 4 3 0   11     1   1   39 40                 79
1122147 1122147 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2017   grade_2 47 4 6 1   14     0   4   46 30                       76 47 4 6 1   14     0   4   46 30                 76
1122148 1122148 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2017   grade_3 46 6 4 0   6     0   2   32 32                       64 46 6 4 0   6     0   2   32 32                 64
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
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
1122151 1122151 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122152 1122152 MA Middlesex   school 2501980 10   Arlington 250198001681 100038 Menotomy Preschool   Regular School No Elementary PK PK 2017   pre_kindergarten 55 0 4 0   9     0   2   44 26                       70 55 0 4 0   9     0   2   44 26                 70
1122153 1122153 MA Middlesex   school 2501980 10   Arlington 250198001681 100038 Menotomy Preschool   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122154 1122154 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2017   kindergarten 37 1 2 0   8     0   0   28 20                       48 37 1 2 0   8     0   0   28 20                 48
1122155 1122155 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2017   grade_1 35 3 1 0   7     0   1   18 29                       47 35 3 1 0   7     0   1   18 29                 47
1122156 1122156 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2017   grade_2 27 3 6 0   7     0   1   19 25                       44 27 3 6 0   7     0   1   19 25                 44
1122157 1122157 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2017   grade_3 38 1 4 0   2     0   0   29 16                       45 38 1 4 0   2     0   0   29 16                 45
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
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
1122160 1122160 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122161 1122161 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2017   kindergarten 55 7 13 1   19     0   0   44 51                       95 55 7 13 1   19     0   0   44 51                 95
1122162 1122162 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2017   grade_1 48 5 7 0   10     0   6   42 34                       76 48 5 7 0   10     0   6   42 34                 76
1122163 1122163 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2017   grade_2 55 4 6 1   13     1   6   46 40                       86 55 4 6 1   13     1   6   46 40                 86
1122164 1122164 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2017   grade_3 45 3 13 0   12     0   3   40 36                       76 45 3 13 0   12     0   3   40 36                 76
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
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
1122167 1122167 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122168 1122168 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2017   kindergarten 39 3 3 0   23     0   0   41 27                       68 39 3 3 0   23     0   0   41 27                 68
1122169 1122169 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2017   grade_1 45 3 7 0   14     0   5   33 41                       74 45 3 7 0   14     0   5   33 41                 74
1122170 1122170 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2017   grade_2 44 0 4 0   8     0   2   31 27                       58 44 0 4 0   8     0   2   31 27                 58
1122171 1122171 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2017   grade_3 48 3 3 0   7     0   4   34 31                       65 48 3 3 0   7     0   4   34 31                 65
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
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
1122174 1122174 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122184 1122184 MA Middlesex   school 2502100 14   Ashland 250210002455 140005 William Pittaway Elementary   Regular School No Elementary PK PK 2017   pre_kindergarten 96 2 5 0   23     0   5   68 63                       131 96 2 5 0   23     0   5   68 63                 131
1122185 1122185 MA Middlesex   school 2502100 14   Ashland 250210002455 140005 William Pittaway Elementary   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122186 1122186 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2017   kindergarten 144 2 26 0   31     0   10   111 102                       213 144 2 26 0   31     0   10   111 102                 213
1122187 1122187 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2017   grade_1 125 4 25 0   24     1   8   93 94                       187 125 4 25 0   24     1   8   93 94                 187
1122188 1122188 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2017   grade_2 159 5 15 4   32     0   4   104 115                       219 159 5 15 4   32     0   4   104 115                 219
1122189 1122189 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122190 1122190 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 David Mindess   Regular School No Elementary 03 05 2017   grade_3 153 3 20 5   25     0   8   110 104                       214 153 3 20 5   25     0   8   110 104                 214
1122191 1122191 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 David Mindess   Regular School No Elementary 03 05 2017   grade_4 144 6 18 0   34     0   6   103 105                       208 144 6 18 0   34     0   6   103 105                 208
1122192 1122192 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 David Mindess   Regular School No Elementary 03 05 2017   grade_5 140 4 21 1   25     0   7   101 97                       198 140 4 21 1   25     0   7   101 97                 198
1122193 1122193 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 David Mindess   Regular School No Elementary 03 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122203 1122203 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2017   kindergarten 35 7 26 0   0     0   5   38 35                       73 35 7 26 0   0     0   5   38 35                 73
1122204 1122204 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2017   grade_1 50 5 27 1   2     1   11   51 46                       97 50 5 27 1   2     1   11   51 46                 97
1122205 1122205 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2017   grade_2 61 1 28 0   2     0   2   47 47                       94 61 1 28 0   2     0   2   47 47                 94
1122206 1122206 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2017   grade_3 48 1 19 0   4     0   8   41 39                       80 48 1 19 0   4     0   8   41 39                 80
1122207 1122207 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2017   grade_4 67 3 23 0   0     0   4   55 42                       97 67 3 23 0   0     0   4   55 42                 97
1122208 1122208 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122209 1122209 MA Bristol   school 2502190 16   Attleboro 250219001610 160008 Early Learning Center   Regular School No Elementary PK PK 2017   pre_kindergarten 142 7 20 0   7     0   11   115 72                       187 142 7 20 0   7     0   11   115 72                 187
1122210 1122210 MA Bristol   school 2502190 16   Attleboro 250219001610 160008 Early Learning Center   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122211 1122211 MA Bristol   school 2502190 16   Attleboro 250219000098 160035 Thomas Willett Elementary School   Regular School No Elementary KG 04 2017   kindergarten 54 4 12 0   10     0   11   44 47                       91 54 4 12 0   10     0   11   44 47                 91
1122212 1122212 MA Bristol   school 2502190 16   Attleboro 250219000098 160035 Thomas Willett Elementary School   Regular School No Elementary KG 04 2017   grade_1 60 10 5 0   12     0   6   50 43                       93 60 10 5 0   12     0   6   50 43                 93
1122213 1122213 MA Bristol   school 2502190 16   Attleboro 250219000098 160035 Thomas Willett Elementary School   Regular School No Elementary KG 04 2017   grade_2 62 4 9 0   4     0   11   47 43                       90 62 4 9 0   4     0   11   47 43                 90
1122214 1122214 MA Bristol   school 2502190 16   Attleboro 250219000098 160035 Thomas Willett Elementary School   Regular School No Elementary KG 04 2017   grade_3 64 7 7 0   7     0   10   46 49                       95 64 7 7 0   7     0   10   46 49                 95
1122215 1122215 MA Bristol   school 2502190 16   Attleboro 250219000098 160035 Thomas Willett Elementary School   Regular School No Elementary KG 04 2017   grade_4 52 3 11 0   9     0   5   48 32                       80 52 3 11 0   9     0   5   48 32                 80
1122216 1122216 MA Bristol   school 2502190 16   Attleboro 250219000098 160035 Thomas Willett Elementary School   Regular School No Elementary KG 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122217 1122217 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No Elementary KG 04 2017   kindergarten 66 2 14 0   2     0   8   37 55                       92 66 2 14 0   2     0   8   37 55                 92
1122218 1122218 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No Elementary KG 04 2017   grade_1 70 2 11 0   5     0   4   58 34                       92 70 2 11 0   5     0   4   58 34                 92
1122219 1122219 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No Elementary KG 04 2017   grade_2 63 4 6 0   0     0   8   34 47                       81 63 4 6 0   0     0   8   34 47                 81
1122220 1122220 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No Elementary KG 04 2017   grade_3 66 5 11 0   11     0   4   46 51                       97 66 5 11 0   11     0   4   46 51                 97
1122221 1122221 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No Elementary KG 04 2017   grade_4 48 6 14 0   10     0   3   34 47                       81 48 6 14 0   10     0   3   34 47                 81
1122222 1122222 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No Elementary KG 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122223 1122223 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Hill-Roberts Elementary School   Regular School No Elementary KG 04 2017   kindergarten 50 13 15 1   4     0   11   56 38                       94 50 13 15 1   4     0   11   56 38                 94
1122224 1122224 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Hill-Roberts Elementary School   Regular School No Elementary KG 04 2017   grade_1 70 2 9 1   6     0   8   51 45                       96 70 2 9 1   6     0   8   51 45                 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]);