enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1122255 1122255 MA Bristol   school 2502190 16   Attleboro 250219002831 160515 Attleboro Community Academy   Alternative School No High 09 12 2017   grade_10 11 0 3 0   0     0   0   5 9                       14 11 0 3 0   0     0   0   5 9                 14
1122256 1122256 MA Bristol   school 2502190 16   Attleboro 250219002831 160515 Attleboro Community Academy   Alternative School No High 09 12 2017   grade_11 26 1 3 1   0     0   4   19 16                       35 26 1 3 1   0     0   4   19 16                 35
1122257 1122257 MA Bristol   school 2502190 16   Attleboro 250219002831 160515 Attleboro Community Academy   Alternative School No High 09 12 2017   grade_12 11 0 1 0   1     0   1   10 4                       14 11 0 1 0   1     0   1   10 4                 14
1122258 1122258 MA Bristol   school 2502190 16   Attleboro 250219002831 160515 Attleboro Community Academy   Alternative School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122391 1122391 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Keough Memorial Academy   Alternative School No High 07 12 2017   grade_9 8 0 2 0   0     0   0   6 4                       10 8 0 2 0   0     0   0   6 4                 10
1122392 1122392 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Keough Memorial Academy   Alternative School No High 07 12 2017   grade_10 7 0 2 0   0     0   1   6 3                       10 7 0 2 0   0     0   1   6 3                 10
1122393 1122393 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Keough Memorial Academy   Alternative School No High 07 12 2017   grade_11 8 0 0 0   0     0   0   4 4                       8 8 0 0 0   0     0   0   4 4                 8
1122394 1122394 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Keough Memorial Academy   Alternative School No High 07 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1123213 1123213 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   kindergarten 1 25 33 0   0     0   1   30 30                       60 1 25 33 0   0     0   1   30 30                 60
1123214 1123214 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   pre_kindergarten 0 28 23 1   0     0   0   24 28                       52 0 28 23 1   0     0   0   24 28                 52
1123215 1123215 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_1 3 31 29 0   0     0   1   31 33                       64 3 31 29 0   0     0   1   31 33                 64
1123216 1123216 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_2 0 29 31 0   0     0   3   31 32                       63 0 29 31 0   0     0   3   31 32                 63
1123217 1123217 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_3 2 60 35 0   0     0   2   46 53                       99 2 60 35 0   0     0   2   46 53                 99
1123218 1123218 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_4 0 32 27 0   0     0   0   30 29                       59 0 32 27 0   0     0   0   30 29                 59
1123219 1123219 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_5 2 25 20 0   0     0   0   25 22                       47 2 25 20 0   0     0   0   25 22                 47
1123220 1123220 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_6 0 30 15 0   0     0   0   24 21                       45 0 30 15 0   0     0   0   24 21                 45
1123221 1123221 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_7 1 25 23 0   0     0   1   31 19                       50 1 25 23 0   0     0   1   31 19                 50
1123222 1123222 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_8 0 21 21 0   0     0   1   27 16                       43 0 21 21 0   0     0   1   27 16                 43
1123223 1123223 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1123315 1123315 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative School No High 09 12 2017   grade_9 3 34 66 0   2     0   2   48 59                       107 3 34 66 0   2     0   2   48 59                 107
1123316 1123316 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative School No High 09 12 2017   grade_10 7 26 56 0   6     1   0   47 49                       96 7 26 56 0   6     1   0   47 49                 96
1123317 1123317 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative School No High 09 12 2017   grade_11 3 31 36 0   3     0   3   41 35                       76 3 31 36 0   3     0   3   41 35                 76
1123318 1123318 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative School No High 09 12 2017   grade_12 6 31 41 0   2     0   1   34 47                       81 6 31 41 0   2     0   1   34 47                 81
1123319 1123319 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1123320 1123320 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Another Course To College   Alternative School No High 09 12 2017   grade_9 4 20 23 0   1     0   1   23 26                       49 4 20 23 0   1     0   1   23 26                 49
1123321 1123321 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Another Course To College   Alternative School No High 09 12 2017   grade_10 4 24 25 0   1     0   1   35 20                       55 4 24 25 0   1     0   1   35 20                 55
1123322 1123322 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Another Course To College   Alternative School No High 09 12 2017   grade_11 4 29 21 0   5     1   2   29 33                       62 4 29 21 0   5     1   2   29 33                 62
1123323 1123323 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Another Course To College   Alternative School No High 09 12 2017   grade_12 4 23 20 1   6     0   3   23 34                       57 4 23 20 1   6     0   3   23 34                 57
1123324 1123324 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Another Course To College   Alternative School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1123325 1123325 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative School No High 09 12 2017   grade_9 2 45 30 0   0     0   2   37 42                       79 2 45 30 0   0     0   2   37 42                 79
1123326 1123326 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative School No High 09 12 2017   grade_10 1 46 28 0   1     0   0   32 44                       76 1 46 28 0   1     0   0   32 44                 76
1123327 1123327 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative School No High 09 12 2017   grade_11 1 58 21 0   0     0   1   50 31                       81 1 58 21 0   0     0   1   50 31                 81
1123328 1123328 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative School No High 09 12 2017   grade_12 0 59 22 2   0     0   1   44 40                       84 0 59 22 2   0     0   1   44 40                 84
1123329 1123329 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1123342 1123342 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative School No High 09 12 2017   grade_9 10 58 56 0   4     0   4   47 85                       132 10 58 56 0   4     0   4   47 85                 132
1123343 1123343 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative School No High 09 12 2017   grade_10 15 51 47 0   7     0   5   49 76                       125 15 51 47 0   7     0   5   49 76                 125
1123344 1123344 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative School No High 09 12 2017   grade_11 17 40 32 0   3     0   2   35 59                       94 17 40 32 0   3     0   2   35 59                 94
1123345 1123345 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative School No High 09 12 2017   grade_12 14 32 41 0   6     0   3   31 65                       96 14 32 41 0   6     0   3   31 65                 96
1123346 1123346 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1123347 1123347 MA Suffolk   school 2502790 35   Boston 250279001511 350548 Boston Adult Academy   Alternative School No High 11 12 2017   grade_11 8 49 48 0   2     2   0   58 51                       109 8 49 48 0   2     2   0   58 51                 109
1123348 1123348 MA Suffolk   school 2502790 35   Boston 250279001511 350548 Boston Adult Academy   Alternative School No High 11 12 2017   grade_12 2 57 25 0   2     0   2   38 50                       88 2 57 25 0   2     0   2   38 50                 88
1123349 1123349 MA Suffolk   school 2502790 35   Boston 250279001511 350548 Boston Adult Academy   Alternative School No High 11 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1123455 1123455 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston Collaborative High School   Alternative School No High 07 12 2017   grade_8 0 2 5 0   0     0   0   5 2                       7 0 2 5 0   0     0   0   5 2                 7
1123456 1123456 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston Collaborative High School   Alternative School No High 07 12 2017   grade_9 * * * *   *     *   *   2 2                       *                         2 2                  
1123457 1123457 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston Collaborative High School   Alternative School No High 07 12 2017   grade_10 3 9 14 1   0     0   0   10 17                       27 3 9 14 1   0     0   0   10 17                 27
1123458 1123458 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston Collaborative High School   Alternative School No High 07 12 2017   grade_11 7 26 28 0   1     0   0   31 31                       62 7 26 28 0   1     0   0   31 31                 62
1123459 1123459 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston Collaborative High School   Alternative School No High 07 12 2017   grade_12 18 41 29 1   1     0   1   50 41                       91 18 41 29 1   1     0   1   50 41                 91
1123460 1123460 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston Collaborative High School   Alternative School No High 07 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1123667 1123667 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative School No Other 05 12 2017   grade_5 * * * *   *     *   *   1 1                       *                         1 1                  
1123668 1123668 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative School No Other 05 12 2017   grade_7 * * * *   *     *   *   4 1                       *                         4 1                  
1123669 1123669 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative School No Other 05 12 2017   grade_8 2 3 3 0   0     0   0   6 2                       8 2 3 3 0   0     0   0   6 2                 8
1123670 1123670 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative School No Other 05 12 2017   grade_9 3 3 0 0   0     0   0   5 1                       6 3 3 0 0   0     0   0   5 1                 6
1123671 1123671 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative School No Other 05 12 2017   grade_10 7 3 1 0   0     0   0   7 4                       11 7 3 1 0   0     0   0   7 4                 11
1123672 1123672 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative School No Other 05 12 2017   grade_11 4 2 1 0   0     0   0   4 3                       7 4 2 1 0   0     0   0   4 3                 7
1123673 1123673 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative School No Other 05 12 2017   grade_12 3 3 0 0   0     0   0   2 4                       6 3 3 0 0   0     0   0   2 4                 6
1123674 1123674 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative School No Other 05 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1123898 1123898 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative School No Elementary PK 05 2017   kindergarten 21 14 9 0   7     0   5   33 23                       56 21 14 9 0   7     0   5   33 23                 56
1123899 1123899 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative School No Elementary PK 05 2017   pre_kindergarten 10 7 5 0   5     0   3   14 16                       30 10 7 5 0   5     0   3   14 16                 30
1123900 1123900 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative School No Elementary PK 05 2017   grade_1 30 3 8 0   5     0   5   24 27                       51 30 3 8 0   5     0   5   24 27                 51
1123901 1123901 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative School No Elementary PK 05 2017   grade_2 20 16 6 0   2     0   6   26 24                       50 20 16 6 0   2     0   6   26 24                 50
1123902 1123902 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative School No Elementary PK 05 2017   grade_3 22 5 12 1   5     0   3   24 24                       48 22 5 12 1   5     0   3   24 24                 48
1123903 1123903 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative School No Elementary PK 05 2017   grade_4 25 5 7 0   5     0   4   27 19                       46 25 5 7 0   5     0   4   27 19                 46
1123904 1123904 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative School No Elementary PK 05 2017   grade_5 21 9 7 0   0     0   7   23 21                       44 21 9 7 0   0     0   7   23 21                 44
1123905 1123905 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative School No Elementary PK 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1123938 1123938 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative School No Elementary PK 05 2017   kindergarten 23 12 3 0   13     0   4   29 26                       55 23 12 3 0   13     0   4   29 26                 55
1123939 1123939 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative School No Elementary PK 05 2017   pre_kindergarten 24 3 0 0   6     0   2   18 17                       35 24 3 0 0   6     0   2   18 17                 35
1123940 1123940 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative School No Elementary PK 05 2017   grade_1 29 10 3 0   10     0   2   30 24                       54 29 10 3 0   10     0   2   30 24                 54
1123941 1123941 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative School No Elementary PK 05 2017   grade_2 31 12 4 0   14     0   2   37 26                       63 31 12 4 0   14     0   2   37 26                 63
1123942 1123942 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative School No Elementary PK 05 2017   grade_3 23 15 4 0   15     0   3   27 33                       60 23 15 4 0   15     0   3   27 33                 60
1123943 1123943 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative School No Elementary PK 05 2017   grade_4 38 12 4 0   17     0   4   38 37                       75 38 12 4 0   17     0   4   38 37                 75
1123944 1123944 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative School No Elementary PK 05 2017   grade_5 25 10 5 0   7     0   3   21 29                       50 25 10 5 0   7     0   3   21 29                 50
1123945 1123945 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative School No Elementary PK 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124147 1124147 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No Other 06 12 2017   grade_7 1 0 9 0   0     0   0   9 1                       10 1 0 9 0   0     0   0   9 1                 10
1124148 1124148 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No Other 06 12 2017   grade_8 4 1 8 0   0     0   0   9 4                       13 4 1 8 0   0     0   0   9 4                 13
1124149 1124149 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No Other 06 12 2017   grade_9 9 1 20 0   0     0   0   24 6                       30 9 1 20 0   0     0   0   24 6                 30
1124150 1124150 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No Other 06 12 2017   grade_10 5 0 13 0   0     0   2   14 6                       20 5 0 13 0   0     0   2   14 6                 20
1124151 1124151 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No Other 06 12 2017   grade_11 8 1 8 0   0     0   2   14 5                       19 8 1 8 0   0     0   2   14 5                 19
1124152 1124152 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No Other 06 12 2017   grade_12 2 1 8 0   0     0   1   9 3                       12 2 1 8 0   0     0   1   9 3                 12
1124153 1124153 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No Other 06 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125116 1125116 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative School No High 09 12 2017   grade_9 20 1 2 0   0     0   4   18 9                       27 20 1 2 0   0     0   4   18 9                 27
1125117 1125117 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative School No High 09 12 2017   grade_10 17 2 2 0   0     0   1   10 12                       22 17 2 2 0   0     0   1   10 12                 22
1125118 1125118 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative School No High 09 12 2017   grade_11 17 0 3 0   1     0   0   14 7                       21 17 0 3 0   1     0   0   14 7                 21
1125119 1125119 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative School No High 09 12 2017   grade_12 14 2 5 1   0     0   1   12 11                       23 14 2 5 1   0     0   1   12 11                 23
1125120 1125120 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125891 1125891 MA Essex   school 2506660 149   Lawrence 250666002749 1490540 Phoenix Academy Lawrence   Alternative School No High 09 12 2017   grade_9 3 1 56 0   1     0   0   39 22                       61 3 1 56 0   1     0   0   39 22                 61
1125892 1125892 MA Essex   school 2506660 149   Lawrence 250666002749 1490540 Phoenix Academy Lawrence   Alternative School No High 09 12 2017   grade_10 2 2 28 0   0     0   0   20 12                       32 2 2 28 0   0     0   0   20 12                 32
1125893 1125893 MA Essex   school 2506660 149   Lawrence 250666002749 1490540 Phoenix Academy Lawrence   Alternative School No High 09 12 2017   grade_11 1 1 23 0   0     0   0   13 12                       25 1 1 23 0   0     0   0   13 12                 25
1125894 1125894 MA Essex   school 2506660 149   Lawrence 250666002749 1490540 Phoenix Academy Lawrence   Alternative School No High 09 12 2017   grade_12 3 0 30 0   0     0   0   16 17                       33 3 0 30 0   0     0   0   16 17                 33
1125895 1125895 MA Essex   school 2506660 149   Lawrence 250666002749 1490540 Phoenix Academy Lawrence   Alternative School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1129008 1129008 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 06 08 2017   grade_6 * * * *   *     *   *   1 *                       *                         1                    
1129009 1129009 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 06 08 2017   grade_7 * * * *   *     *   *   3 *                       *                         3                    
1129010 1129010 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 06 08 2017   grade_8 2 3 6 0   0     0   0   7 *                       11 2 3 6 0   0     0   0   7                   11
1129011 1129011 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1129017 1129017 MA Middlesex   school 2510890 274   Somerville 251089002499 2740510 Full Circle High School   Alternative School No High 09 12 2017   grade_9 3 5 7 0   0     0   0   9 6                       15 3 5 7 0   0     0   0   9 6                 15
1129018 1129018 MA Middlesex   school 2510890 274   Somerville 251089002499 2740510 Full Circle High School   Alternative School No High 09 12 2017   grade_10 7 7 5 0   1     0   1   12 9                       21 7 7 5 0   1     0   1   12 9                 21
1129019 1129019 MA Middlesex   school 2510890 274   Somerville 251089002499 2740510 Full Circle High School   Alternative School No High 09 12 2017   grade_11 4 1 6 0   0     0   1   8 4                       12 4 1 6 0   0     0   1   8 4                 12
1129020 1129020 MA Middlesex   school 2510890 274   Somerville 251089002499 2740510 Full Circle High School   Alternative School No High 09 12 2017   grade_12 6 1 5 0   0     0   0   8 4                       12 6 1 5 0   0     0   0   8 4                 12
1129021 1129021 MA Middlesex   school 2510890 274   Somerville 251089002499 2740510 Full Circle High School   Alternative School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1129434 1129434 MA Hampden   school 2511130 281   Springfield 251113002809 2810580 Gateway to College at Springfield Technical Community College   Alternative School No High 09 12 2017   grade_9 3 0 3 0   0     0   0   3 3                       6 3 0 3 0   0     0   0   3 3                 6
1129435 1129435 MA Hampden   school 2511130 281   Springfield 251113002809 2810580 Gateway to College at Springfield Technical Community College   Alternative School No High 09 12 2017   grade_10 0 2 10 0   0     0   0   4 8                       12 0 2 10 0   0     0   0   4 8                 12

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