Data source: Big Local News · About: Big Local

2,758 rows where grade = "grade_10" and state = "MA" sorted by ccd_school_type

View and edit SQL

year

grade

  • grade_10 · 2,758
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
2230213 MA Suffolk   school   35   Boston   350652               2018   grade_10 * * * *   *     *   *   * *                       0.0                                             0
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
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
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
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
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
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
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
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
737828 MA Middlesex   school 2504320 79   Dracut 250432002800 790515 Parker Avenue School   Alternative Education School No 3 09 12 2015   grade_10 * * * *   *     *   *   * *                       1                                             1
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
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
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
742026 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_10 0 4 6 0   0     0   0   1 9                       10 0 4 6 0   0     0   0   1 9                 10
742255 MA Bristol   school 2511520 293   Taunton 251152002778 2930525 Taunton Alternative High School   Alternative Education School No 3 08 12 2015   grade_10 12 1 3 0   0     0   0   10 6                       16 12 1 3 0   0     0   0   10 6                 16
932789 MA Bristol   school 2502190 16   Attleboro 250219002831 160515 Attleboro Community Academy   Alternative Education School No 3 09 12 2016   grade_10 * * * *   *     *   *   1 4                       5                         1 4                 5
932901 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Paul J. Primavera Jr./Sr. High School   Alternative Education School No 3 07 12 2016   grade_10 7 0 0 0   0     0   0   4 3                       7 7 0 0 0   0     0   0   4 3                 7
933703 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative Education School No 3 09 12 2016   grade_10 3 33 41 0   4     0   3   45 39                       84 3 33 41 0   4     0   3   45 39                 84
933707 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Another Course To College   Alternative Education School No 3 09 12 2016   grade_10 4 30 20 0   5     1   2   32 30                       62 4 30 20 0   5     1   2   32 30                 62
933711 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative Education School No 3 09 12 2016   grade_10 1 53 20 1   0     0   1   47 29                       76 1 53 20 1   0     0   1   47 29                 76
933725 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative Education School No 3 09 12 2016   grade_10 16 40 40 0   3     0   2   35 66                       101 16 40 40 0   3     0   2   35 66                 101
933826 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston Collaborative High School   Alternative Education School No 3 08 12 2016   grade_10 5 18 14 1   1     0   0   16 23                       39 5 18 14 1   1     0   0   16 23                 39
934004 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative Education School No 4 04 12 2016   grade_10 6 4 1 0   0     0   0   6 5                       11 6 4 1 0   0     0   0   6 5                 11
934411 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative Education School No 4 06 12 2016   grade_10 9 1 22 0   0     0   2   21 13                       34 9 1 22 0   0     0   2   21 13                 34
935221 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative Education School No 3 09 12 2016   grade_10 21 0 1 0   1     0   1   12 12                       24 21 0 1 0   1     0   1   12 12                 24
935872 MA Essex   school 2506660 149   Lawrence 250666002749 1490540 Phoenix Academy Lawrence   Alternative Education School No 3 09 12 2016   grade_10 3 1 22 0   0     0   0   13 13                       26 3 1 22 0   0     0   0   13 13                 26
938487 MA Middlesex   school 2510890 274   Somerville 251089002499 2740510 Full Circle High School   Alternative Education School No 3 09 12 2016   grade_10 8 1 4 0   0     0   1   9 5                       14 8 1 4 0   0     0   1   9 5                 14
938838 MA Hampden   school 2511130 281   Springfield 251113002809 2810580 Gateway to College at Springfield Technical Community College   Alternative Education School No 3 09 12 2016   grade_10 0 4 6 0   0     0   0   3 7                       10 0 4 6 0   0     0   0   3 7                 10
939064 MA Bristol   school 2511520 293   Taunton 251152002778 2930525 Taunton Alternative High School   Alternative Education School No 3 08 12 2016   grade_10 13 2 0 0   0     0   2   13 4                       17 13 2 0 0   0     0   2   13 4                 17
939788 MA Worcester   school 2513080 343   Winchendon 251308002843 3430405 Murdock Academy for Success   Alternative Education School No 4 06 12 2016   grade_10 9 0 2 0   0     0   1   10 2                       12 9 0 2 0   0     0   1   10 2                 12
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
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
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
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
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
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
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
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
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
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
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
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
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
1129708 MA Bristol   school 2511520 293   Taunton 251152002778 2930525 Taunton Alternative High School   Alternative School No High 08 12 2017   grade_10 12 2 2 0   0     0   0   10 6                       16 12 2 2 0   0     0   0   10 6                 16
1129803 MA Worcester   school 2511850 304   Uxbridge 251185002862 3040515 Gateway to College   Alternative School No High 09 12 2017   grade_10 * * * *   *     *   *   2 3                       *                         2 3                  
1130587 MA Worcester   school 2513080 343   Winchendon 251308002843 3430405 Murdock Academy for Success   Alternative School No Other 06 12 2017   grade_10 * * * *   *     *   *   2 3                       *                         2 3                  
1365151 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Keough Memorial Academy   Alternative School No High 08 12 2020   grade_10 5 0 1 0   0     0   0   3 3 *                     6.0 5 0 1 0   0     0   0   3 3                 6
1365941 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative School No High 09 12 2020   grade_10 2 31 58 1   5     0   3   49 51 *                     100.0 2 31 58 1   5     0   3   49 51                 100
1365945 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Another Course To College   Alternative School No High 09 12 2020   grade_10 2 35 20 0   1     0   0   28 30 *                     58.0 2 35 20 0   1     0   0   28 30                 58
1365951 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative School No High 07 12 2020   grade_10 1 48 39 1   0     0   2   44 47 *                     91.0 1 48 39 1   0     0   2   44 47                 91
1365965 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative School No High 09 12 2020   grade_10 15 63 46 0   4     0   5   46 87 *                     133.0 15 63 46 0   4     0   5   46 87                 133
1366054 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston Collaborative High School   Alternative School No High 09 12 2020   grade_10 2 2 9 0   1     0   1   11 4 *                     15.0 2 2 9 0   1     0   1   11 4                 15
1366222 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 02 12 2020   grade_10 1 4 5 0   0     0   0   5 5 *                     10.0 1 4 5 0   0     0   0   5 5                 10
1366247 MA Plymouth   school 2503090 44   Brockton 250309002652 440515 Brockton Champion High School   Alternative School No High 09 12 2020   grade_10 4 10 7 0   0     1   1   17 6 *                     23.0 4 10 7 0   0     1   1   17 6                 23
1366607 MA Suffolk   school 2503540 57   Chelsea 250354002890 570515 Chelsea Opportunity Academy   Alternative School No High 09 12 2020   grade_10 0 0 27 0   0     0   1   19 9 *                     28.0 0 0 27 0   0     0   1   19 9                 28
1366635 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No High 07 12 2020   grade_10 1 1 11 0   0     0   0   9 4 *                     13.0 1 1 11 0   0     0   0   9 4                 13
1367210 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Resiliency Preparatory Academy   Alternative School No High 07 12 2020   grade_10 13 7 15 1   0     0   2   17 21 *                     38.0 13 7 15 1   0     0   2   17 21                 38
1367458 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative School No High 09 12 2020   grade_10 9 1 0 0   0     0   0   6 4 *                     10.0 9 1 0 0   0     0   0   6 4                 10
1370714 MA Middlesex   school 2510890 274   Somerville 251089002499 2740510 Full Circle High School   Alternative School No High 09 12 2020   grade_10 2 0 8 0   0     0   0   9 1 *                     10.0 2 0 8 0   0     0   0   9 1                 10
1370754 MA Worcester   school 2511010 277   Southbridge 251101002896 2770525 Southbridge Academy   Alternative School No High 09 12 2020   grade_10 9 0 7 0   0     0   1   12 5 *                     17.0 9 0 7 0   0     0   1   12 5                 17
1371073 MA Hampden   school 2511130 281   Springfield 251113002809 2810580 Gateway to College at Springfield Technical Community College   Alternative School No High 09 12 2020   grade_10 4 0 1 0   0     0   1   2 4 *                     6.0 4 0 1 0   0     0   1   2 4                 6
1371304 MA Bristol   school 2511520 293   Taunton 251152002778 2930525 Taunton Alternative High School   Alternative School No High 10 12 2020   grade_10 3 1 2 0   0     0   0   4 2 *                     6.0 3 1 2 0   0     0   0   4 2                 6
1371382 MA Worcester   school 2511850 304   Uxbridge 251185002862 3040515 Gateway to College   Alternative School No High 10 12 2020   grade_10 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1372008 MA Worcester   school 2513080 343   Winchendon 251308002843 3430405 Murdock Academy for Success   Alternative School No High 09 12 2020   grade_10 6 0 0 0   0     0   1   3 4 *                     7.0 6 0 0 0   0     0   1   3 4                 7
1672260 MA Bristol   school 2502190 16   Attleboro 250219002831 160515 Attleboro - Attleboro Community Academy   Alternative School No High 09 12 2021   grade_10 * * * *   *     *   *   3 2 *                     5.0                         3 2                 5
1672373 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Bellingham - Keough Memorial Academy   Alternative School No High 08 12 2021   grade_10 * * * *   *     *   *   2 2 *                     4.0                         2 2                 4
1673180 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Boston - Fenway High School   Alternative School No High 09 12 2021   grade_10 8 31 55 0   1     0   1   48 48 *                     96.0 8 31 55 0   1     0   1   48 48                 96
1673184 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Boston - Another Course To College   Alternative School No High 09 12 2021   grade_10 4 29 25 0   1     0   1   40 20 *                     60.0 4 29 25 0   1     0   1   40 20                 60
1673190 MA Suffolk   school 2502790 35   Boston 250279000704 350542 Boston - New Mission High School   Alternative School No High 07 12 2021   grade_10 0 45 53 0   4     0   1   49 54 *                     103.0 0 45 53 0   4     0   1   49 54                 103
1673203 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston - Boston Arts Academy   Alternative School No High 09 12 2021   grade_10 10 57 59 0   2     0   7   43 91 *                     135.0 10 57 59 0   2     0   7   43 91                 135
1673289 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston - Boston Collaborative High School   Alternative School No High 09 12 2021   grade_10 2 4 6 0   1     0   0   10 3 *                     13.0 2 4 6 0   1     0   0   10 3                 13
1673455 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton - Huntington Therapeutic Day School   Alternative School No Other 02 12 2021   grade_10 1 3 2 0   0     0   2   5 3 *                     8.0 1 3 2 0   0     0   2   5 3                 8
1673480 MA Plymouth   school 2503090 44   Brockton 250309002652 440515 Brockton - Brockton Champion High School   Alternative School No High 09 12 2021   grade_10 4 17 6 0   0     1   2   19 11 *                     30.0 4 17 6 0   0     1   2   19 11                 30
1673838 MA Suffolk   school 2503540 57   Chelsea 250354002890 570515 Chelsea - Chelsea Opportunity Academy   Alternative School No High 09 12 2021   grade_10 0 0 8 0   0     0   0   3 5 *                     8.0 0 0 8 0   0     0   0   3 5                 8
1673864 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee - Chicopee Academy   Alternative School No High 07 12 2021   grade_10 8 1 8 0   0     0   0   13 4 *                     17.0 8 1 8 0   0     0   0   13 4                 17
1674444 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Fall River - Resiliency Preparatory Academy   Alternative School No High 07 12 2021   grade_10 26 7 15 0   0     0   3   34 17 *                     51.0 26 7 15 0   0     0   3   34 17                 51
1674693 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner - Gardner Academy for Learning and Technology   Alternative School No High 09 12 2021   grade_10 24 1 5 0   0     0   1   16 15 *                     31.0 24 1 5 0   0     0   1   16 15                 31
1675313 MA Essex   school 2506660 149   Lawrence 250666002919 1490615 Lawrence - RISE Academy   Alternative School No Secondary 09 11 2021   grade_10 0 1 10 0   0     0   0   8 * *                     11.0 0 1 10 0   0     0   0   8                   11
1677965 MA Middlesex   school 2510890 274   Somerville 251089002499 2740510 Somerville - Full Circle High School   Alternative School No High 09 12 2021   grade_10 4 1 6 0   1     0   0   9 3 *                     12.0 4 1 6 0   1     0   0   9 3                 12
1678009 MA Worcester   school 2511010 277   Southbridge 251101002896 2770525 Southbridge - Southbridge Academy   Alternative School No High 07 12 2021   grade_10 1 0 3 0   0     0   2   5 1 *                     6.0 1 0 3 0   0     0   2   5 1                 6
1678633 MA Worcester   school 2511850 304   Uxbridge 251185002862 3040515 Uxbridge - Gateway to College   Alternative School No High 10 12 2021   grade_10 * * * *   *     *   *   3 2 *                     5.0                         3 2                 5
1679268 MA Worcester   school 2513080 343   Winchendon 251308002843 3430405 Winchendon - Murdock Academy for Success   Alternative School No High 09 12 2021   grade_10 7 0 0 0   0     0   1   5 3 *                     8.0 7 0 0 0   0     0   1   5 3                 8
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
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
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
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
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
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
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
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
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
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
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
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
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
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
2045830 MA Worcester   school 2511010 277   Southbridge 251101002896 2770525 Southbridge Academy   Alternative School No High 08 12 2019   grade_10 5 0 3 0   0     0   0   5 3                       8.0 5 0 3 0   0     0   0   5 3                 8
2046149 MA Hampden   school 2511130 281   Springfield 251113002809 2810580 Gateway to College at Springfield Technical Community College   Alternative School No High 09 12 2019   grade_10 1 3 8 0   0     0   0   4 8                       12.0 1 3 8 0   0     0   0   4 8                 12
2046380 MA Bristol   school 2511520 293   Taunton 251152002778 2930525 Taunton Alternative High School   Alternative School No High 10 12 2019   grade_10 5 1 0 0   0     0   0   5 1                       6.0 5 1 0 0   0     0   0   5 1                 6
2047082 MA Worcester   school 2513080 343   Winchendon 251308002843 3430405 Murdock Academy for Success   Alternative School No High 09 12 2019   grade_10 6 0 0 0   0     0   1   5 2                       7.0 6 0 0 0   0     0   1   5 2                 7

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