enrollments

Data source: Big Local News · About: Big Local

9,565 rows where state = "MA" and year = 2019 sorted by ccd_school_type

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 9,565 ✖
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
2040064 2040064 MA Bristol   school 2502190 16   Attleboro 250219002831 160515 Attleboro Community Academy   Alternative School No High 10 12 2019   grade_10 4 1 2 0   0     0   0   5 2                       7.0 4 1 2 0   0     0   0   5 2                 7
2040065 2040065 MA Bristol   school 2502190 16   Attleboro 250219002831 160515 Attleboro Community Academy   Alternative School No High 10 12 2019   grade_11 12 2 3 0   0     0   1   11 7                       18.0 12 2 3 0   0     0   1   11 7                 18
2040066 2040066 MA Bristol   school 2502190 16   Attleboro 250219002831 160515 Attleboro Community Academy   Alternative School No High 10 12 2019   grade_12 21 5 7 0   0     0   0   19 14                       33.0 21 5 7 0   0     0   0   19 14                 33
2040175 2040175 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Keough Memorial Academy   Alternative School No High 08 12 2019   grade_8 6 0 0 0   0     0   0   1 4                       6.0 6 0 0 0   0     0   0   1 4                 6
2040176 2040176 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Keough Memorial Academy   Alternative School No High 08 12 2019   grade_9 6 0 0 0   0     0   0   4 2                       6.0 6 0 0 0   0     0   0   4 2                 6
2040177 2040177 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Keough Memorial Academy   Alternative School No High 08 12 2019   grade_10 5 0 1 0   0     0   0   1 5                       6.0 5 0 1 0   0     0   0   1 5                 6
2040178 2040178 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Keough Memorial Academy   Alternative School No High 08 12 2019   grade_11 6 0 1 0   0     0   1   4 3                       8.0 6 0 1 0   0     0   1   4 3                 8
2040179 2040179 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Keough Memorial Academy   Alternative School No High 08 12 2019   grade_12 8 0 1 0   0     0   0   5 3                       9.0 8 0 1 0   0     0   0   5 3                 9
2040892 2040892 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2019   pre_kindergarten 2 25 12 0   0     0   4   20 23                       43.0 2 25 12 0   0     0   4   20 23                 43
2040893 2040893 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2019   kindergarten 0 26 25 1   0     0   2   27 27                       54.0 0 26 25 1   0     0   2   27 27                 54
2040894 2040894 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2019   grade_1 0 22 38 0   0     0   0   35 25                       60.0 0 22 38 0   0     0   0   35 25                 60
2040895 2040895 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2019   grade_2 0 27 32 0   0     0   1   29 31                       60.0 0 27 32 0   0     0   1   29 31                 60
2040896 2040896 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2019   grade_3 2 23 28 0   0     0   1   30 24                       54.0 2 23 28 0   0     0   1   30 24                 54
2040897 2040897 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2019   grade_4 1 52 42 1   0     0   2   52 46                       98.0 1 52 42 1   0     0   2   52 46                 98
2040898 2040898 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2019   grade_5 1 49 29 0   0     0   2   44 37                       81.0 1 49 29 0   0     0   2   44 37                 81
2040899 2040899 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2019   grade_6 0 17 26 0   0     0   0   25 18                       43.0 0 17 26 0   0     0   0   25 18                 43
2040900 2040900 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2019   grade_7 0 24 18 0   0     0   1   24 19                       43.0 0 24 18 0   0     0   1   24 19                 43
2040901 2040901 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2019   grade_8 0 22 11 0   0     0   0   23 10                       33.0 0 22 11 0   0     0   0   23 10                 33
2040983 2040983 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative School No High 09 12 2019   grade_9 2 30 64 1   5     0   2   50 54                       104.0 2 30 64 1   5     0   2   50 54                 104
2040984 2040984 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative School No High 09 12 2019   grade_10 3 25 62 0   2     0   1   46 47                       93.0 3 25 62 0   2     0   1   46 47                 93
2040985 2040985 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative School No High 09 12 2019   grade_11 1 31 59 0   1     0   1   38 55                       93.0 1 31 59 0   1     0   1   38 55                 93
2040986 2040986 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative School No High 09 12 2019   grade_12 7 22 49 0   5     1   0   43 41                       84.0 7 22 49 0   5     1   0   43 41                 84
2040987 2040987 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             3.0                                             3
2040988 2040988 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Another Course To College   Alternative School No High 09 12 2019   grade_9 4 32 25 0   1     0   0   31 31                       62.0 4 32 25 0   1     0   0   31 31                 62
2040989 2040989 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Another Course To College   Alternative School No High 09 12 2019   grade_10 3 21 26 0   1     0   2   29 24                       53.0 3 21 26 0   1     0   2   29 24                 53
2040990 2040990 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Another Course To College   Alternative School No High 09 12 2019   grade_11 6 25 20 0   0     0   1   25 27                       52.0 6 25 20 0   0     0   1   25 27                 52
2040991 2040991 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Another Course To College   Alternative School No High 09 12 2019   grade_12 6 25 23 0   2     0   1   29 28                       57.0 6 25 23 0   2     0   1   29 28                 57
2040992 2040992 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative School No High 07 12 2019   grade_7 1 23 20 0   0     0   0   18 26                       44.0 1 23 20 0   0     0   0   18 26                 44
2040993 2040993 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative School No High 07 12 2019   grade_8 3 38 30 0   2     0   1   35 39                       74.0 3 38 30 0   2     0   1   35 39                 74
2040994 2040994 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative School No High 07 12 2019   grade_9 1 54 45 1   0     0   1   49 53                       102.0 1 54 45 1   0     0   1   49 53                 102
2040995 2040995 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative School No High 07 12 2019   grade_10 2 50 30 0   1     0   1   45 39                       84.0 2 50 30 0   1     0   1   45 39                 84
2040996 2040996 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative School No High 07 12 2019   grade_11 3 39 28 0   1     0   1   31 41                       72.0 3 39 28 0   1     0   1   31 41                 72
2040997 2040997 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative School No High 07 12 2019   grade_12 1 53 30 0   1     0   0   37 48                       85.0 1 53 30 0   1     0   0   37 48                 85
2040998 2040998 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative School No High 07 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             1.0                                             1
2041009 2041009 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative School No High 09 12 2019   grade_9 16 53 36 0   3     0   6   38 76                       114.0 16 53 36 0   3     0   6   38 76                 114
2041010 2041010 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative School No High 09 12 2019   grade_10 12 43 48 2   3     1   7   28 88                       116.0 12 43 48 2   3     1   7   28 88                 116
2041011 2041011 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative School No High 09 12 2019   grade_11 11 52 53 0   4     0   2   42 80                       122.0 11 52 53 0   4     0   2   42 80                 122
2041012 2041012 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative School No High 09 12 2019   grade_12 13 49 43 0   7     0   5   46 71                       117.0 13 49 43 0   7     0   5   46 71                 117
2041013 2041013 MA Suffolk   school 2502790 35   Boston 250279001511 350548 Boston Adult Academy   Alternative School No High 11 12 2019   grade_11 1 44 54 0   3     0   3   52 53                       105.0 1 44 54 0   3     0   3   52 53                 105
2041014 2041014 MA Suffolk   school 2502790 35   Boston 250279001511 350548 Boston Adult Academy   Alternative School No High 11 12 2019   grade_12 1 20 15 0   3     0   0   21 18                       39.0 1 20 15 0   3     0   0   21 18                 39
2041107 2041107 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston Collaborative High School   Alternative School No High 09 12 2019   grade_10 2 5 10 0   0     0   1   8 10                       18.0 2 5 10 0   0     0   1   8 10                 18
2041108 2041108 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston Collaborative High School   Alternative School No High 09 12 2019   grade_11 5 14 26 0   1     0   2   21 27                       48.0 5 14 26 0   1     0   2   21 27                 48
2041109 2041109 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston Collaborative High School   Alternative School No High 09 12 2019   grade_12 12 44 30 1   4     0   0   43 48                       91.0 12 44 30 1   4     0   0   43 48                 91
2041110 2041110 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston Collaborative High School   Alternative School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             1.0                                             1
2041285 2041285 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 03 12 2019   grade_4 * * * *   *     *   *   1 2                       3.0                         1 2                 3
2041286 2041286 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 03 12 2019   grade_5 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2041287 2041287 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 03 12 2019   grade_6 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2041288 2041288 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 03 12 2019   grade_7 4 2 0 0   0     0   1   5 2                       7.0 4 2 0 0   0     0   1   5 2                 7
2041289 2041289 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 03 12 2019   grade_8 * * * *   *     *   *   4 1                       5.0                         4 1                 5
2041290 2041290 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 03 12 2019   grade_9 1 4 2 0   0     0   2   6 3                       9.0 1 4 2 0   0     0   2   6 3                 9
2041291 2041291 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 03 12 2019   grade_10 2 1 4 0   0     0   1   7 1                       8.0 2 1 4 0   0     0   1   7 1                 8
2041292 2041292 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 03 12 2019   grade_11 2 6 0 0   0     0   0   6 2                       8.0 2 6 0 0   0     0   0   6 2                 8
2041293 2041293 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 03 12 2019   grade_12 7 2 0 0   0     0   1   7 3                       10.0 7 2 0 0   0     0   1   7 3                 10
2041316 2041316 MA Plymouth   school 2503090 44   Brockton 250309002652 440515 Brockton Champion High School   Alternative School No High 09 12 2019   grade_9 10 10 17 0   0     0   2   26 13                       39.0 10 10 17 0   0     0   2   26 13                 39
2041317 2041317 MA Plymouth   school 2503090 44   Brockton 250309002652 440515 Brockton Champion High School   Alternative School No High 09 12 2019   grade_10 9 11 12 0   0     0   2   18 16                       34.0 9 11 12 0   0     0   2   18 16                 34
2041318 2041318 MA Plymouth   school 2503090 44   Brockton 250309002652 440515 Brockton Champion High School   Alternative School No High 09 12 2019   grade_11 4 8 7 1   0     0   1   12 9                       21.0 4 8 7 1   0     0   1   12 9                 21
2041319 2041319 MA Plymouth   school 2503090 44   Brockton 250309002652 440515 Brockton Champion High School   Alternative School No High 09 12 2019   grade_12 5 3 3 0   1     0   2   7 7                       14.0 5 3 3 0   1     0   2   7 7                 14
2041320 2041320 MA Plymouth   school 2503090 44   Brockton 250309002652 440515 Brockton Champion High School   Alternative School No High 09 12 2019   sped_beyond_grade_12 11 14 4 0   0     0   1                             30.0 11 14 4 0   0     0   1                       30
2041488 2041488 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative School No Elementary PK 05 2019   pre_kindergarten 16 11 2 0   6     0   4   23 16                       39.0 16 11 2 0   6     0   4   23 16                 39
2041489 2041489 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative School No Elementary PK 05 2019   kindergarten 28 8 6 0   5     0   13   31 29                       60.0 28 8 6 0   5     0   13   31 29                 60
2041490 2041490 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative School No Elementary PK 05 2019   grade_1 26 12 7 1   10     0   4   31 29                       60.0 26 12 7 1   10     0   4   31 29                 60
2041491 2041491 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative School No Elementary PK 05 2019   grade_2 19 12 8 0   2     0   4   22 23                       45.0 19 12 8 0   2     0   4   22 23                 45
2041492 2041492 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative School No Elementary PK 05 2019   grade_3 30 5 8 0   7     0   4   24 30                       54.0 30 5 8 0   7     0   4   24 30                 54
2041493 2041493 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative School No Elementary PK 05 2019   grade_4 17 14 6 0   8     0   5   27 23                       50.0 17 14 6 0   8     0   5   27 23                 50
2041494 2041494 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative School No Elementary PK 05 2019   grade_5 21 8 13 1   5     0   3   29 22                       51.0 21 8 13 1   5     0   3   29 22                 51
2041523 2041523 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative School No Elementary PK 05 2019   pre_kindergarten 16 5 2 0   10     0   2   15 20                       35.0 16 5 2 0   10     0   2   15 20                 35
2041524 2041524 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative School No Elementary PK 05 2019   kindergarten 27 4 1 0   17     0   5   26 28                       54.0 27 4 1 0   17     0   5   26 28                 54
2041525 2041525 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative School No Elementary PK 05 2019   grade_1 28 8 5 0   11     0   3   25 30                       55.0 28 8 5 0   11     0   3   25 30                 55
2041526 2041526 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative School No Elementary PK 05 2019   grade_2 30 10 6 0   11     0   5   30 32                       62.0 30 10 6 0   11     0   5   30 32                 62
2041527 2041527 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative School No Elementary PK 05 2019   grade_3 27 12 7 0   9     0   3   35 23                       58.0 27 12 7 0   9     0   3   35 23                 58
2041528 2041528 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative School No Elementary PK 05 2019   grade_4 28 13 7 0   9     0   2   31 28                       59.0 28 13 7 0   9     0   2   31 28                 59
2041529 2041529 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative School No Elementary PK 05 2019   grade_5 19 19 5 0   12     0   1   24 32                       56.0 19 19 5 0   12     0   1   24 32                 56
2041676 2041676 MA Suffolk   school 2503540 57   Chelsea 250354002890 570515 Chelsea Opportunity Academy   Alternative School No High 09 12 2019   grade_9 * * * *   *     *   *   1 4                       5.0                         1 4                 5
2041677 2041677 MA Suffolk   school 2503540 57   Chelsea 250354002890 570515 Chelsea Opportunity Academy   Alternative School No High 09 12 2019   grade_10 1 0 20 0   0     0   0   16 5                       21.0 1 0 20 0   0     0   0   16 5                 21
2041678 2041678 MA Suffolk   school 2503540 57   Chelsea 250354002890 570515 Chelsea Opportunity Academy   Alternative School No High 09 12 2019   grade_11 0 1 19 0   0     0   0   13 7                       20.0 0 1 19 0   0     0   0   13 7                 20
2041679 2041679 MA Suffolk   school 2503540 57   Chelsea 250354002890 570515 Chelsea Opportunity Academy   Alternative School No High 09 12 2019   grade_12 0 0 6 0   0     0   0   5 1                       6.0 0 0 6 0   0     0   0   5 1                 6
2041702 2041702 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No High 07 12 2019   grade_7 * * * *   *     *   *   2 2                       4.0                         2 2                 4
2041703 2041703 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No High 07 12 2019   grade_8 4 0 11 0   0     0   1   7 9                       16.0 4 0 11 0   0     0   1   7 9                 16
2041704 2041704 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No High 07 12 2019   grade_9 7 1 25 0   0     0   0   18 15                       33.0 7 1 25 0   0     0   0   18 15                 33
2041705 2041705 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No High 07 12 2019   grade_10 5 1 13 0   0     0   1   15 5                       20.0 5 1 13 0   0     0   1   15 5                 20
2041706 2041706 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No High 07 12 2019   grade_12 2 0 7 0   0     0   1   7 3                       10.0 2 0 7 0   0     0   1   7 3                 10
2041707 2041707 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No High 07 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             1.0                                             1
2042278 2042278 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Resiliency Preparatory Academy   Alternative School No High 07 12 2019   grade_7 9 1 5 0   0     0   2   7 10                       17.0 9 1 5 0   0     0   2   7 10                 17
2042279 2042279 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Resiliency Preparatory Academy   Alternative School No High 07 12 2019   grade_8 13 2 4 0   0     0   2   12 9                       21.0 13 2 4 0   0     0   2   12 9                 21
2042280 2042280 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Resiliency Preparatory Academy   Alternative School No High 07 12 2019   grade_9 11 4 7 1   0     0   1   14 10                       24.0 11 4 7 1   0     0   1   14 10                 24
2042281 2042281 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Resiliency Preparatory Academy   Alternative School No High 07 12 2019   grade_10 23 5 14 0   0     0   3   22 23                       45.0 23 5 14 0   0     0   3   22 23                 45
2042282 2042282 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Resiliency Preparatory Academy   Alternative School No High 07 12 2019   grade_11 16 7 7 0   0     0   3   12 21                       33.0 16 7 7 0   0     0   3   12 21                 33
2042283 2042283 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Resiliency Preparatory Academy   Alternative School No High 07 12 2019   grade_12 26 7 17 1   0     0   0   25 26                       51.0 26 7 17 1   0     0   0   25 26                 51
2042529 2042529 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative School No High 09 12 2019   grade_9 7 1 1 0   0     0   1   6 4                       10.0 7 1 1 0   0     0   1   6 4                 10
2042530 2042530 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative School No High 09 12 2019   grade_10 16 0 4 1   0     0   1   17 4                       22.0 16 0 4 1   0     0   1   17 4                 22
2042531 2042531 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative School No High 09 12 2019   grade_11 14 2 1 0   0     1   3   11 10                       21.0 14 2 1 0   0     1   3   11 10                 21
2042532 2042532 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative School No High 09 12 2019   grade_12 6 0 1 0   0     0   0   4 2                       7.0 6 0 1 0   0     0   0   4 2                 7
2045781 2045781 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 07 08 2019   grade_7 0 2 4 0   0     0   0   6 *                       6.0 0 2 4 0   0     0   0   6                   6
2045782 2045782 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 07 08 2019   grade_8 3 1 4 0   0     0   0   5 *                       8.0 3 1 4 0   0     0   0   5                   8
2045788 2045788 MA Middlesex   school 2510890 274   Somerville 251089002499 2740510 Full Circle High School   Alternative School No High 09 12 2019   grade_9 1 0 6 0   0     0   0   5 2                       7.0 1 0 6 0   0     0   0   5 2                 7
2045789 2045789 MA Middlesex   school 2510890 274   Somerville 251089002499 2740510 Full Circle High School   Alternative School No High 09 12 2019   grade_10 4 4 6 0   0     0   0   9 5                       14.0 4 4 6 0   0     0   0   9 5                 14
2045790 2045790 MA Middlesex   school 2510890 274   Somerville 251089002499 2740510 Full Circle High School   Alternative School No High 09 12 2019   grade_11 5 4 9 0   0     0   0   13 5                       18.0 5 4 9 0   0     0   0   13 5                 18
2045791 2045791 MA Middlesex   school 2510890 274   Somerville 251089002499 2740510 Full Circle High School   Alternative School No High 09 12 2019   grade_12 2 1 3 0   1     0   0   4 3                       7.0 2 1 3 0   1     0   0   4 3                 7
2045792 2045792 MA Middlesex   school 2510890 274   Somerville 251089002499 2740510 Full Circle High School   Alternative School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             2.0                                             2
2045829 2045829 MA Worcester   school 2511010 277   Southbridge 251101002896 2770525 Southbridge Academy   Alternative School No High 08 12 2019   grade_8 * * * *   *     *   *   1 2                       3.0                         1 2                 3

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