enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ▼ ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2230202 2230202 MA Suffolk   school   35   Boston   350652               2018   kindergarten * * * *   *     *   *   * *                       0.0                                             0
2230203 2230203 MA Suffolk   school   35   Boston   350652               2018   pre_kindergarten * * * *   *     *   *   * *                       0.0                                             0
2230204 2230204 MA Suffolk   school   35   Boston   350652               2018   grade_1 * * * *   *     *   *   * *                       0.0                                             0
2230205 2230205 MA Suffolk   school   35   Boston   350652               2018   grade_2 * * * *   *     *   *   * *                       0.0                                             0
2230206 2230206 MA Suffolk   school   35   Boston   350652               2018   grade_3 * * * *   *     *   *   * *                       0.0                                             0
2230207 2230207 MA Suffolk   school   35   Boston   350652               2018   grade_4 * * * *   *     *   *   * *                       0.0                                             0
2230208 2230208 MA Suffolk   school   35   Boston   350652               2018   grade_5 * * * *   *     *   *   * *                       0.0                                             0
2230209 2230209 MA Suffolk   school   35   Boston   350652               2018   grade_6 * * * *   *     *   *   * *                       0.0                                             0
2230210 2230210 MA Suffolk   school   35   Boston   350652               2018   grade_7 * * * *   *     *   *   * *                       0.0                                             0
2230211 2230211 MA Suffolk   school   35   Boston   350652               2018   grade_8 * * * *   *     *   *   * *                       0.0                                             0
2230212 2230212 MA Suffolk   school   35   Boston   350652               2018   grade_9 * * * *   *     *   *   * *                       1.0                                             1
2230213 2230213 MA Suffolk   school   35   Boston   350652               2018   grade_10 * * * *   *     *   *   * *                       0.0                                             0
2230214 2230214 MA Suffolk   school   35   Boston   350652               2018   grade_11 * * * *   *     *   *   * *                       0.0                                             0
2230215 2230215 MA Suffolk   school   35   Boston   350652               2018   grade_12 * * * *   *     *   *   * *                       0.0                                             0
2230216 2230216 MA Suffolk   school   35   Boston   350652               2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
735912 735912 MA Bristol   school 2502190 16   Attleboro 250219002831 160515 Attleboro Community Academy   Alternative Education School No 3 09 12 2015   grade_10 * * * *   *     *   *   1 2                       3                         1 2                 3
735913 735913 MA Bristol   school 2502190 16   Attleboro 250219002831 160515 Attleboro Community Academy   Alternative Education School No 3 09 12 2015   grade_11 6 0 4 0   2     1   1   10 4                       14 6 0 4 0   2     1   1   10 4                 14
735914 735914 MA Bristol   school 2502190 16   Attleboro 250219002831 160515 Attleboro Community Academy   Alternative Education School No 3 09 12 2015   grade_12 17 1 10 0   1     0   2   15 16                       31 17 1 10 0   1     0   2   15 16                 31
736030 736030 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Primavera Junior/Senior High School   Alternative Education School No 3 07 12 2015   grade_8 5 0 1 0   0     0   0   4 2                       6 5 0 1 0   0     0   0   4 2                 6
736031 736031 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Primavera Junior/Senior High School   Alternative Education School No 3 07 12 2015   grade_9 8 0 0 0   0     0   0   5 3                       8 8 0 0 0   0     0   0   5 3                 8
736032 736032 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Primavera Junior/Senior High School   Alternative Education School No 3 07 12 2015   grade_10 7 0 0 0   0     0   0   5 2                       7 7 0 0 0   0     0   0   5 2                 7
736033 736033 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Primavera Junior/Senior High School   Alternative Education School No 3 07 12 2015   grade_11 * * * *   *     *   *   1 3                       4                         1 3                 4
736034 736034 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Primavera Junior/Senior High School   Alternative Education School No 3 07 12 2015   grade_12 5 0 1 0   0     0   0   4 2                       6 5 0 1 0   0     0   0   4 2                 6
736743 736743 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   kindergarten 0 18 22 0   0     0   3   27 16                       43 0 18 22 0   0     0   3   27 16                 43
736744 736744 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   pre_kindergarten 2 17 16 0   0     0   2   15 22                       37 2 17 16 0   0     0   2   15 22                 37
736745 736745 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   grade_1 1 31 26 0   0     0   0   24 34                       58 1 31 26 0   0     0   0   24 34                 58
736746 736746 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   grade_2 0 31 27 0   0     0   0   31 27                       58 0 31 27 0   0     0   0   31 27                 58
736747 736747 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   grade_3 1 28 28 0   0     0   1   29 29                       58 1 28 28 0   0     0   1   29 29                 58
736748 736748 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   grade_4 0 27 27 0   0     0   0   26 28                       54 0 27 27 0   0     0   0   26 28                 54
736749 736749 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   grade_5 1 20 24 1   0     0   0   26 20                       46 1 20 24 1   0     0   0   26 20                 46
736750 736750 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   grade_6 2 22 27 0   0     0   1   34 18                       52 2 22 27 0   0     0   1   34 18                 52
736751 736751 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   grade_7 0 33 15 0   0     0   0   33 15                       48 0 33 15 0   0     0   0   33 15                 48
736752 736752 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   grade_8 1 25 23 1   2     0   1   24 29                       53 1 25 23 1   2     0   1   24 29                 53
736837 736837 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative Education School No 3 09 12 2015   grade_9 5 30 40 0   3     0   3   41 40                       81 5 30 40 0   3     0   3   41 40                 81
736838 736838 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative Education School No 3 09 12 2015   grade_10 8 30 43 0   2     0   1   39 45                       84 8 30 43 0   2     0   1   39 45                 84
736839 736839 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative Education School No 3 09 12 2015   grade_11 7 32 38 1   4     0   2   44 40                       84 7 32 38 1   4     0   2   44 40                 84
736840 736840 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative Education School No 3 09 12 2015   grade_12 7 29 39 0   4     0   0   31 48                       79 7 29 39 0   4     0   0   31 48                 79
736841 736841 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Another Course To College   Alternative Education School No 3 09 12 2015   grade_9 4 32 19 0   4     1   2   33 29                       62 4 32 19 0   4     1   2   33 29                 62
736842 736842 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Another Course To College   Alternative Education School No 3 09 12 2015   grade_10 5 23 23 1   6     0   2   27 33                       60 5 23 23 1   6     0   2   27 33                 60
736843 736843 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Another Course To College   Alternative Education School No 3 09 12 2015   grade_11 5 25 24 0   4     0   1   21 38                       59 5 25 24 0   4     0   1   21 38                 59
736844 736844 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Another Course To College   Alternative Education School No 3 09 12 2015   grade_12 5 29 20 0   1     0   0   30 25                       55 5 29 20 0   1     0   0   30 25                 55
736845 736845 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative Education School No 3 09 12 2015   grade_9 3 49 19 1   0     0   1   47 26                       73 3 49 19 1   0     0   1   47 26                 73
736846 736846 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative Education School No 3 09 12 2015   grade_10 2 51 22 2   0     0   0   44 33                       77 2 51 22 2   0     0   0   44 33                 77
736847 736847 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative Education School No 3 09 12 2015   grade_11 3 44 32 1   2     0   1   35 48                       83 3 44 32 1   2     0   1   35 48                 83
736848 736848 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative Education School No 3 09 12 2015   grade_12 1 45 21 0   1     0   0   40 28                       68 1 45 21 0   1     0   0   40 28                 68
736860 736860 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative Education School No 3 09 12 2015   grade_9 13 41 43 1   2     0   2   36 66                       102 13 41 43 1   2     0   2   36 66                 102
736861 736861 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative Education School No 3 09 12 2015   grade_10 18 38 57 0   6     0   4   39 84                       123 18 38 57 0   6     0   4   39 84                 123
736862 736862 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative Education School No 3 09 12 2015   grade_11 18 43 51 1   5     0   1   46 73                       119 18 43 51 1   5     0   1   46 73                 119
736863 736863 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative Education School No 3 09 12 2015   grade_12 15 41 38 0   0     0   3   32 65                       97 15 41 38 0   0     0   3   32 65                 97
736864 736864 MA Suffolk   school 2502790 35   Boston 250279001511 350548 Boston Adult Academy   Alternative Education School No 3 11 12 2015   grade_11 1 30 23 0   4     0   0   34 24                       58 1 30 23 0   4     0   0   34 24                 58
736865 736865 MA Suffolk   school 2502790 35   Boston 250279001511 350548 Boston Adult Academy   Alternative Education School No 3 11 12 2015   grade_12 5 75 39 1   7     1   5   70 63                       133 5 75 39 1   7     1   5   70 63                 133
737140 737140 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative Education School No 4 04 12 2015   grade_7 * * * *   *     *   *   3 1                       4                         3 1                 4
737141 737141 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative Education School No 4 04 12 2015   grade_8 * * * *   *     *   *   3 1                       4                         3 1                 4
737142 737142 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative Education School No 4 04 12 2015   grade_9 7 3 5 0   0     0   0   10 5                       15 7 3 5 0   0     0   0   10 5                 15
737143 737143 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative Education School No 4 04 12 2015   grade_10 3 3 0 0   0     0   0   5 1                       6 3 3 0 0   0     0   0   5 1                 6
737144 737144 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative Education School No 4 04 12 2015   grade_11 5 4 1 0   0     0   2   8 4                       12 5 4 1 0   0     0   2   8 4                 12
737145 737145 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative Education School No 4 04 12 2015   grade_12 5 3 1 0   0     0   0   4 5                       9 5 3 1 0   0     0   0   4 5                 9
737340 737340 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative Education School No 1 PK 05 2015   kindergarten 32 12 7 0   2     0   8   32 29                       61 32 12 7 0   2     0   8   32 29                 61
737341 737341 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative Education School No 1 PK 05 2015   pre_kindergarten 13 4 4 1   6     0   1   15 14                       29 13 4 4 1   6     0   1   15 14                 29
737342 737342 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative Education School No 1 PK 05 2015   grade_1 25 7 7 0   5     0   3   25 22                       47 25 7 7 0   5     0   3   25 22                 47
737343 737343 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative Education School No 1 PK 05 2015   grade_2 29 4 6 0   7     0   5   30 21                       51 29 4 6 0   7     0   5   30 21                 51
737344 737344 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative Education School No 1 PK 05 2015   grade_3 23 8 8 0   0     0   7   24 22                       46 23 8 8 0   0     0   7   24 22                 46
737345 737345 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative Education School No 1 PK 05 2015   grade_4 20 10 5 0   2     0   2   20 19                       39 20 10 5 0   2     0   2   20 19                 39
737346 737346 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative Education School No 1 PK 05 2015   grade_5 19 9 9 1   3     0   2   29 14                       43 19 9 9 1   3     0   2   29 14                 43
737375 737375 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative Education School No 1 PK 05 2015   kindergarten 26 13 1 0   11     0   1   30 22                       52 26 13 1 0   11     0   1   30 22                 52
737376 737376 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative Education School No 1 PK 05 2015   pre_kindergarten 12 7 1 0   11     0   4   21 14                       35 12 7 1 0   11     0   4   21 14                 35
737377 737377 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative Education School No 1 PK 05 2015   grade_1 23 12 8 0   19     0   3   29 36                       65 23 12 8 0   19     0   3   29 36                 65
737378 737378 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative Education School No 1 PK 05 2015   grade_2 31 12 4 0   18     0   4   36 33                       69 31 12 4 0   18     0   4   36 33                 69
737379 737379 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative Education School No 1 PK 05 2015   grade_3 27 10 7 0   13     0   3   25 35                       60 27 10 7 0   13     0   3   25 35                 60
737380 737380 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative Education School No 1 PK 05 2015   grade_4 29 11 7 0   18     0   0   33 32                       65 29 11 7 0   18     0   0   33 32                 65
737381 737381 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative Education School No 1 PK 05 2015   grade_5 19 13 4 0   7     0   3   26 20                       46 19 13 4 0   7     0   3   26 20                 46
737548 737548 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative Education School No 4 06 12 2015   grade_7 2 0 4 0   0     0   0   5 1                       6 2 0 4 0   0     0   0   5 1                 6
737549 737549 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative Education School No 4 06 12 2015   grade_8 4 0 8 0   0     0   0   9 3                       12 4 0 8 0   0     0   0   9 3                 12
737550 737550 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative Education School No 4 06 12 2015   grade_9 14 0 13 0   0     0   0   17 10                       27 14 0 13 0   0     0   0   17 10                 27
737551 737551 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative Education School No 4 06 12 2015   grade_10 4 3 18 0   0     0   3   21 7                       28 4 3 18 0   0     0   3   21 7                 28
737552 737552 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative Education School No 4 06 12 2015   grade_11 6 0 11 0   0     0   1   10 8                       18 6 0 11 0   0     0   1   10 8                 18
737553 737553 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative Education School No 4 06 12 2015   grade_12 6 1 4 0   0     0   0   9 2                       11 6 1 4 0   0     0   0   9 2                 11
737827 737827 MA Middlesex   school 2504320 79   Dracut 250432002800 790515 Parker Avenue School   Alternative Education School No 3 09 12 2015   grade_9 * * * *   *     *   *   * *                       2                                             2
737828 737828 MA Middlesex   school 2504320 79   Dracut 250432002800 790515 Parker Avenue School   Alternative Education School No 3 09 12 2015   grade_10 * * * *   *     *   *   * *                       1                                             1
737829 737829 MA Middlesex   school 2504320 79   Dracut 250432002800 790515 Parker Avenue School   Alternative Education School No 3 09 12 2015   grade_11 * * * *   *     *   *   * *                       2                                             2
737830 737830 MA Middlesex   school 2504320 79   Dracut 250432002800 790515 Parker Avenue School   Alternative Education School No 3 09 12 2015   grade_12 * * * *   *     *   *   * *                       2                                             2
738076 738076 MA Bristol   school 2504830 95   Fall River 250483000276 950055 ACESE   Alternative Education School No 1 03 05 2015   grade_3 * * * *   *     *   *   1 *                       2                         1                   2
738077 738077 MA Bristol   school 2504830 95   Fall River 250483000276 950055 ACESE   Alternative Education School No 1 03 05 2015   grade_4 * * * *   *     *   *   4 *                       4                         4                   4
738078 738078 MA Bristol   school 2504830 95   Fall River 250483000276 950055 ACESE   Alternative Education School No 1 03 05 2015   grade_5 1 3 2 0   0     0   1   7 *                       7 1 3 2 0   0     0   1   7                   7
738369 738369 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative Education School No 3 09 12 2015   grade_9 13 0 0 0   1     0   0   9 5                       14 13 0 0 0   1     0   0   9 5                 14
738370 738370 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative Education School No 3 09 12 2015   grade_10 24 0 0 1   0     0   0   14 11                       25 24 0 0 1   0     0   0   14 11                 25
738371 738371 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative Education School No 3 09 12 2015   grade_11 22 0 1 0   0     0   0   11 12                       23 22 0 1 0   0     0   0   11 12                 23
738372 738372 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative Education School No 3 09 12 2015   grade_12 15 0 1 0   0     0   0   9 7                       16 15 0 1 0   0     0   0   9 7                 16
739022 739022 MA Essex   school 2506660 149   Lawrence 250666002749 1490540 Phoenix Academy Lawrence   Alternative Education School No 3 09 12 2015   grade_9 4 4 86 0   2     0   0   53 43                       96 4 4 86 0   2     0   0   53 43                 96
739023 739023 MA Essex   school 2506660 149   Lawrence 250666002749 1490540 Phoenix Academy Lawrence   Alternative Education School No 3 09 12 2015   grade_10 3 0 30 0   0     0   0   16 17                       33 3 0 30 0   0     0   0   16 17                 33
739024 739024 MA Essex   school 2506660 149   Lawrence 250666002749 1490540 Phoenix Academy Lawrence   Alternative Education School No 3 09 12 2015   grade_11 1 0 40 0   1     0   0   18 24                       42 1 0 40 0   1     0   0   18 24                 42
739025 739025 MA Essex   school 2506660 149   Lawrence 250666002749 1490540 Phoenix Academy Lawrence   Alternative Education School No 3 09 12 2015   grade_12 1 1 12 0   0     0   0   8 6                       14 1 1 12 0   0     0   0   8 6                 14
741675 741675 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative Education School No 2 06 08 2015   grade_6 * * * *   *     *   *   2 *                       2                         2                   2
741676 741676 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative Education School No 2 06 08 2015   grade_7 0 2 4 0   0     0   0   5 *                       6 0 2 4 0   0     0   0   5                   6
741677 741677 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative Education School No 2 06 08 2015   grade_8 5 2 3 0   2     0   0   8 *                       12 5 2 3 0   2     0   0   8                   12
741683 741683 MA Middlesex   school 2510890 274   Somerville 251089002499 2740510 Full Circle High School   Alternative Education School No 3 09 12 2015   grade_9 2 2 3 0   1     0   0   6 2                       8 2 2 3 0   1     0   0   6 2                 8
741684 741684 MA Middlesex   school 2510890 274   Somerville 251089002499 2740510 Full Circle High School   Alternative Education School No 3 09 12 2015   grade_10 7 2 7 0   0     0   0   11 5                       16 7 2 7 0   0     0   0   11 5                 16
741685 741685 MA Middlesex   school 2510890 274   Somerville 251089002499 2740510 Full Circle High School   Alternative Education School No 3 09 12 2015   grade_11 7 5 5 0   0     0   0   11 6                       17 7 5 5 0   0     0   0   11 6                 17
741686 741686 MA Middlesex   school 2510890 274   Somerville 251089002499 2740510 Full Circle High School   Alternative Education School No 3 09 12 2015   grade_12 5 4 5 0   0     0   0   7 7                       14 5 4 5 0   0     0   0   7 7                 14
742025 742025 MA Hampden   school 2511130 281   Springfield 251113002809 2810580 Gateway to College at Springfield Technical Community College   Alternative Education School No 3 09 12 2015   grade_9 * * * *   *     *   *   1 3                       4                         1 3                 4

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