enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 11,264 ✖
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
1121946 1121946 MA Plymouth   school 2501650 1   Abington 250165002727 10002 Center Elementary School   Regular School No Elementary PK KG 2017   kindergarten 115 5 12 0   2     0   0   73 61                       134 115 5 12 0   2     0   0   73 61                 134
1121947 1121947 MA Plymouth   school 2501650 1   Abington 250165002727 10002 Center Elementary School   Regular School No Elementary PK KG 2017   pre_kindergarten 57 3 5 0   4     0   0   37 32                       69 57 3 5 0   4     0   0   37 32                 69
1121948 1121948 MA Plymouth   school 2501650 1   Abington 250165002727 10002 Center Elementary School   Regular School No Elementary PK KG 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121949 1121949 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No Elementary 01 04 2017   grade_1 109 1 10 1   3     1   0   52 73                       125 109 1 10 1   3     1   0   52 73                 125
1121950 1121950 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No Elementary 01 04 2017   grade_2 147 3 11 0   3     0   0   89 75                       164 147 3 11 0   3     0   0   89 75                 164
1121951 1121951 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No Elementary 01 04 2017   grade_3 127 5 11 1   3     0   1   77 71                       148 127 5 11 1   3     0   1   77 71                 148
1121952 1121952 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No Elementary 01 04 2017   grade_4 130 2 7 1   2     0   1   73 70                       143 130 2 7 1   2     0   1   73 70                 143
1121953 1121953 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No Elementary 01 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
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
1121955 1121955 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Middle 05 06 2017   grade_6 156 6 8 0   2     0   1   82 91                       173 156 6 8 0   2     0   1   82 91                 173
1121956 1121956 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Middle 05 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121957 1121957 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Frolio Middle School   Regular School No Middle 07 08 2017   grade_7 142 2 9 0   5     0   1   84 75                       159 142 2 9 0   5     0   1   84 75                 159
1121958 1121958 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Frolio Middle School   Regular School No Middle 07 08 2017   grade_8 151 6 11 0   1     0   0   91 78                       169 151 6 11 0   1     0   0   91 78                 169
1121959 1121959 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Frolio Middle School   Regular School No Middle 07 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121960 1121960 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2017   grade_9 106 3 8 1   4     0   2   55 69                       124 106 3 8 1   4     0   2   55 69                 124
1121961 1121961 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2017   grade_10 91 4 10 0   3     1   0   50 59                       109 91 4 10 0   3     1   0   50 59                 109
1121962 1121962 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2017   grade_11 105 1 15 0   0     0   2   59 64                       123 105 1 15 0   0     0   2   59 64                 123
1121963 1121963 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2017   grade_12 82 2 8 0   0     0   0   41 51                       92 82 2 8 0   0     0   0   41 51                 92
1121964 1121964 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121965 1121965 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   kindergarten 75 1 4 1   0     0   3   43 41                       84 75 1 4 1   0     0   3   43 41                 84
1121966 1121966 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   pre_kindergarten 43 2 2 0   1     0   2   25 25                       50 43 2 2 0   1     0   2   25 25                 50
1121967 1121967 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   grade_1 88 0 4 0   0     0   7   55 44                       99 88 0 4 0   0     0   7   55 44                 99
1121968 1121968 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   grade_2 92 1 6 0   0     0   3   44 58                       102 92 1 6 0   0     0   3   44 58                 102
1121969 1121969 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   grade_3 107 0 0 0   0     0   0   62 45                       107 107 0 0 0   0     0   0   62 45                 107
1121970 1121970 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   grade_4 94 0 2 0   0     0   0   57 39                       96 94 0 2 0   0     0   0   57 39                 96
1121971 1121971 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
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
1121973 1121973 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2017   grade_6 119 0 1 0   0     0   1   61 60                       121 119 0 1 0   0     0   1   61 60                 121
1121974 1121974 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2017   grade_7 73 0 3 0   0     0   1   42 35                       77 73 0 3 0   0     0   1   42 35                 77
1121975 1121975 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2017   grade_8 111 2 0 0   1     0   0   51 63                       114 111 2 0 0   1     0   0   51 63                 114
1121976 1121976 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121977 1121977 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam Early Childhood Center   Regular School No Elementary PK PK 2017   pre_kindergarten 108 7 19 0   13     0   4   87 64                       151 108 7 19 0   13     0   4   87 64                 151
1121978 1121978 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam Early Childhood Center   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121979 1121979 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2017   kindergarten 56 1 2 0   0     1   0   28 32                       60 56 1 2 0   0     1   0   28 32                 60
1121980 1121980 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2017   grade_1 32 1 8 0   0     0   2   23 20                       43 32 1 8 0   0     0   2   23 20                 43
1121981 1121981 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2017   grade_2 53 0 11 0   1     0   1   39 27                       66 53 0 11 0   1     0   1   39 27                 66
1121982 1121982 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2017   grade_3 52 0 7 0   1     0   4   28 36                       64 52 0 7 0   1     0   4   28 36                 64
1121983 1121983 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2017   grade_4 56 2 0 0   1     0   1   29 31                       60 56 2 0 0   1     0   1   29 31                 60
1121984 1121984 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121985 1121985 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2017   kindergarten 85 0 3 0   2     0   1   38 53                       91 85 0 3 0   2     0   1   38 53                 91
1121986 1121986 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2017   grade_1 57 1 1 0   3     0   0   38 24                       62 57 1 1 0   3     0   0   38 24                 62
1121987 1121987 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2017   grade_2 66 3 2 0   1     0   0   51 21                       72 66 3 2 0   1     0   0   51 21                 72
1121988 1121988 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2017   grade_3 71 0 7 0   4     0   4   43 43                       86 71 0 7 0   4     0   4   43 43                 86
1121989 1121989 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2017   grade_4 60 4 6 0   1     0   3   33 41                       74 60 4 6 0   1     0   3   33 41                 74
1121990 1121990 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121991 1121991 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2017   kindergarten 66 2 6 0   1     0   3   45 33                       78 66 2 6 0   1     0   3   45 33                 78
1121992 1121992 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2017   grade_1 66 2 6 0   3     0   2   40 39                       79 66 2 6 0   3     0   2   40 39                 79
1121993 1121993 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2017   grade_2 46 1 6 0   4     0   4   37 24                       61 46 1 6 0   4     0   4   37 24                 61
1121994 1121994 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2017   grade_3 64 2 8 0   2     0   2   31 47                       78 64 2 8 0   2     0   2   31 47                 78
1121995 1121995 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2017   grade_4 71 3 4 0   1     0   2   42 39                       81 71 3 4 0   1     0   2   42 39                 81
1121996 1121996 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121997 1121997 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2017   kindergarten 53 2 8 0   2     0   2   43 24                       67 53 2 8 0   2     0   2   43 24                 67
1121998 1121998 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2017   grade_1 55 1 7 0   2     0   2   35 32                       67 55 1 7 0   2     0   2   35 32                 67
1121999 1121999 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2017   grade_2 50 4 5 0   1     0   1   31 30                       61 50 4 5 0   1     0   1   31 30                 61
1122000 1122000 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2017   grade_3 61 2 6 0   4     0   1   38 36                       74 61 2 6 0   4     0   1   38 36                 74
1122001 1122001 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2017   grade_4 52 1 5 0   2     0   0   28 32                       60 52 1 5 0   2     0   0   28 32                 60
1122002 1122002 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
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
1122004 1122004 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No Middle 05 08 2017   grade_6 253 6 25 0   13     0   7   155 149                       304 253 6 25 0   13     0   7   155 149                 304
1122005 1122005 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No Middle 05 08 2017   grade_7 * * * *   *     *   *   2 1                       *                         2 1                  
1122006 1122006 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No Middle 05 08 2017   grade_8 * * * *   *     *   *   1 1                       *                         1 1                  
1122007 1122007 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No Middle 05 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122008 1122008 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam Junior High   Regular School No Middle 07 08 2017   grade_7 211 5 21 0   7     0   9   122 131                       253 211 5 21 0   7     0   9   122 131                 253
1122009 1122009 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam Junior High   Regular School No Middle 07 08 2017   grade_8 278 3 19 0   1     0   8   147 162                       309 278 3 19 0   1     0   8   147 162                 309
1122010 1122010 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam Junior High   Regular School No Middle 07 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122011 1122011 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2017   grade_9 272 3 14 0   6     0   4   151 148                       299 272 3 14 0   6     0   4   151 148                 299
1122012 1122012 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2017   grade_10 270 6 20 0   7     0   6   164 145                       309 270 6 20 0   7     0   6   164 145                 309
1122013 1122013 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2017   grade_11 257 5 16 0   6     1   8   159 134                       293 257 5 16 0   6     1   8   159 134                 293
1122014 1122014 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2017   grade_12 280 1 21 0   8     0   5   158 157                       315 280 1 21 0   8     0   5   158 157                 315
1122015 1122015 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2017   sped_beyond_grade_12 6 0 0 0   0     0   0                             6 6 0 0 0   0     0   0                       6
1122016 1122016 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2017   kindergarten 40 10 4 0   0     0   2   31 25                       56 40 10 4 0   0     0   2   31 25                 56
1122017 1122017 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2017   pre_kindergarten 21 0 4 0   0     0   1   16 10                       26 21 0 4 0   0     0   1   16 10                 26
1122018 1122018 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2017   grade_1 60 2 5 1   0     0   4   32 40                       72 60 2 5 1   0     0   4   32 40                 72
1122019 1122019 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2017   grade_2 72 1 6 0   1     0   5   42 43                       85 72 1 6 0   1     0   5   42 43                 85
1122020 1122020 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2017   grade_3 67 2 4 0   0     0   4   44 33                       77 67 2 4 0   0     0   4   44 33                 77
1122021 1122021 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2017   grade_4 67 1 1 1   1     0   1   38 34                       72 67 1 1 1   1     0   1   38 34                 72
1122022 1122022 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122023 1122023 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2017   kindergarten 59 4 6 0   1     0   1   33 38                       71 59 4 6 0   1     0   1   33 38                 71
1122024 1122024 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2017   pre_kindergarten 20 1 3 0   0     0   1   19 6                       25 20 1 3 0   0     0   1   19 6                 25
1122025 1122025 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2017   grade_1 75 1 7 0   2     0   1   53 33                       86 75 1 7 0   2     0   1   53 33                 86
1122026 1122026 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2017   grade_2 77 2 4 1   3     0   2   48 41                       89 77 2 4 1   3     0   2   48 41                 89
1122027 1122027 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2017   grade_3 76 2 10 0   2     0   3   50 43                       93 76 2 10 0   2     0   3   50 43                 93
1122028 1122028 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2017   grade_4 78 0 10 1   1     1   3   42 52                       94 78 0 10 1   1     1   3   42 52                 94
1122029 1122029 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
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
1122031 1122031 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2017   grade_6 138 1 10 1   0     0   8   81 77                       158 138 1 10 1   0     0   8   81 77                 158
1122032 1122032 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2017   grade_7 160 0 10 0   2     0   6   96 82                       178 160 0 10 0   2     0   6   96 82                 178
1122033 1122033 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2017   grade_8 142 4 11 1   2     0   10   91 79                       170 142 4 11 1   2     0   10   91 79                 170
1122034 1122034 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122035 1122035 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2017   grade_9 134 2 5 0   2     0   4   74 73                       147 134 2 5 0   2     0   4   74 73                 147
1122036 1122036 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2017   grade_10 119 3 8 0   2     0   6   77 61                       138 119 3 8 0   2     0   6   77 61                 138
1122037 1122037 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2017   grade_11 133 1 5 0   2     0   4   83 62                       145 133 1 5 0   2     0   4   83 62                 145
1122038 1122038 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2017   grade_12 152 2 7 0   1     0   1   83 80                       163 152 2 7 0   1     0   1   83 80                 163
1122039 1122039 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122040 1122040 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2017   grade_9 7 0 0 0   0     0   0   4 3                       7 7 0 0 0   0     0   0   4 3                 7
1122041 1122041 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2017   grade_10 * * * *   *     *   *   1 1                       *                         1 1                  
1122042 1122042 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2017   grade_11 8 0 1 0   0     0   2   8 3                       11 8 0 1 0   0     0   2   8 3                 11
1122043 1122043 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2017   grade_12 10 0 1 0   0     0   0   7 4                       11 10 0 1 0   0     0   0   7 4                 11
1122044 1122044 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122045 1122045 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2017   kindergarten 15 3 8 0   6     0   2   17 17                       34 15 3 8 0   6     0   2   17 17                 34

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