Data source: Big Local News · About: Big Local

2,737 rows where grade = "grade_9" and state = "MA" sorted by total

View and edit SQL

year

grade

  • grade_9 · 2,737
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
1122639 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No High 07 12 2017   grade_9 * * * *   *     *   *   1 1                       *                         1 1                  
1123285 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Community Academy   Regular School No High 09 12 2017   grade_9 * * * *   *     *   *   2 *                       *                         2                    
1123330 MA Suffolk   school 2502790 35   Boston 250279000837 350543 Greater Egleston Community High School   Regular School No High 09 12 2017   grade_9 * * * *   *     *   *   1 1                       *                         1 1                  
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                  
1125195 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_9 * * * *   *     *   *   * *                       *                                              
1125269 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_9 * * * *   *     *   *   * *                       *                                              
1127949 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Project C.O.F.F.E.E.   Special Education School No Other 05 12 2017   grade_9 * * * *   *     *   *   3 *                       *                         3                    
1128679 MA Essex   school 2510380 258   Salem 251038002864 2580510 New Liberty Innovation School   Regular School No High 09 12 2017   grade_9 * * * *   *     *   *   1 1                       *                         1 1                  
1128685 MA Essex   school 2510380 258   Salem 251038002774 2580515 Salem Prep High School   Regular School No High 08 12 2017   grade_9 * * * *   *     *   *   1 *                       *                         1                    
1129420 MA Hampden   school 2511130 281   Springfield 251113002734 2810560 Liberty Preparatory Academy   Regular School No High 09 12 2017   grade_9 * * * *   *     *   *   2 *                       *                         2                    
1129429 MA Hampden   school 2511130 281   Springfield 251113002743 2810575 Gateway to College at Holyoke Community College   Regular School No High 09 12 2017   grade_9 * * * *   *     *   *   2 2                       *                         2 2                  
1129707 MA Bristol   school 2511520 293   Taunton 251152002778 2930525 Taunton Alternative High School   Alternative School No High 08 12 2017   grade_9 * * * *   *     *   *   2 1                       *                         2 1                  
1131458 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2017   grade_9 * * * *   *     *   *   1 2                       *                         1 2                  
1131925 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No Other 05 12 2017   grade_9 * * * *   *     *   *   1 *                       *                         1                    
1368466 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_9 * * * *   *     *   *   * * *                     0.0                                             0
1374316 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_9 * * * *   *     *   *   * * *                     0.0                                             0
1674759 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_9 * * * *   *     *   *   * * *                     0.0                                             0
1675707 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_9 * * * *   *     *   *   * * *                     0.0                                             0
2231646 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   grade_9 * * * *   *     *   *   * *                       0.0                                             0
2232024 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_9 * * * *   *     *   *   * *                       0.0                                             0
2237230 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_9 * * * *   *     *   *   * *                       0.0                                             0
936655 MA Middlesex   school 2507560 176   Medford 250756002393 1760510 Curtis-Tufts   Regular School No 3 09 12 2016   grade_9 * * * *   *     *   *   1 *                       1                         1                   1
939288 MA Plymouth   school 2512060 310   Wareham 251206002668 3100310 West Academy   Regular School No N N N 2016   grade_9 * * * *   *     *   *   * *                       1                                             1
2046144 MA Hampden   school 2511130 281   Springfield 251113002743 2810575 Gateway to College at Holyoke Community College   Regular School No High 09 12 2019   grade_9 * * * *   *     *   *   * 1                       1.0                           1                 1
2230212 MA Suffolk   school   35   Boston   350652               2018   grade_9 * * * *   *     *   *   * *                       1.0                                             1
2233662 MA Middlesex   school 2507560 176   Medford 250756002393 1760510 Medford: Curtis-Tufts   Regular School No High 09 12 2018   grade_9 * * * *   *     *   *   1 *                       1.0                         1                   1
2234772 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Oxford: Project C.O.F.F.E.E.   Special Education School No High 08 12 2018   grade_9 * * * *   *     *   *   1 *                       1.0                         1                   1
740281 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No 3 07 12 2015   grade_9 7 0 3 0   0     0   0   9 1                       10 7 0 3 0   0     0   0   9 1                 10
934837 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No 4 KG 12 2016   grade_9 2 3 5 0   0     0   0   7 3                       10 2 3 5 0   0     0   0   7 3                 10
935434 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill Alternative School   Regular School No 4 06 12 2016   grade_9 6 2 2 0   0     0   0   9 1                       10 6 2 2 0   0     0   0   9 1                 10
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
1123450 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   grade_9 0 3 5 0   1     0   1   7 3                       10 0 3 5 0   1     0   1   7 3                 10
1368149 MA Worcester   school 2506780 153   Leominster 250678002779 1530515 Leominster Center for Excellence   Regular School No High 09 12 2020   grade_9 9 0 1 0   0     0   0   3 6 *                     10.0 9 0 1 0   0     0   0   3 6                 10
1368415 MA Middlesex   school 2507020 160   Lowell 250702002860 1600515 The Career Academy   Regular School No High 09 12 2020   grade_9 1 0 5 0   3     0   1   7 3 *                     10.0 1 0 5 0   3     0   1   7 3                 10
1372753 MA Middlesex   school 2500033 458   Lowell Middlesex Academy Charter (District) 250003300555 4580505 Lowell Middlesex Academy Charter School   Regular School Yes High 09 12 2020   grade_9 4 0 4 0   1     0   1   5 5 *                     10.0 4 0 4 0   1     0   1   5 5                 10
1673454 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton - Huntington Therapeutic Day School   Alternative School No Other 02 12 2021   grade_9 3 4 2 0   0     0   1   8 2 *                     10.0 3 4 2 0   0     0   1   8 2                 10
1674917 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill - Greenleaf Academy   Regular School No High 06 12 2021   grade_9 2 0 8 0   0     0   0   9 1 *                     10.0 2 0 8 0   0     0   0   9 1                 10
1675395 MA Worcester   school 2506780 153   Leominster 250678002779 1530515 Leominster - Leominster Center for Excellence   Regular School No High 09 12 2021   grade_9 6 1 3 0   0     0   0   6 4 *                     10.0 6 1 3 0   0     0   0   6 4                 10
1678339 MA Hampden   school 2511130 281   Springfield 251113002884 2810700 Springfield - Springfield International Academy at Sci-Tech   Regular School No Secondary 09 11 2021   grade_9 1 0 9 0   0     0   0   6 4 *                     10.0 1 0 9 0   0     0   0   6 4                 10
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
2047851 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2019   grade_9 8 1 1 0   0     0   0   5 5                       10.0 8 1 1 0   0     0   0   5 5                 10
2236798 MA Plymouth   school 2512060 310   Wareham 251206002105 3100315 Wareham: Wareham Cooperative Alternative School   Regular School No High 09 12 2018   grade_9 7 2 0 0   0     0   1   5 5                       10.0 7 2 0 0   0     0   1   5 5                 10
742666 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No 3 07 12 2015   grade_9 90 2 1 0   3     1   3   40 60                       100 90 2 1 0   3     1   3   40 60                 100
744573 MA Worcester   school 2508280 720   Narragansett 250828001285 7200505 Narragansett Regional High   Regular School No 3 09 12 2015   grade_9 92 0 3 0   0     0   5   49 51                       100 92 0 3 0   0     0   5   49 51                 100
940820 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2016   grade_9 87 5 4 1   3     0   0   45 55                       100 87 5 4 1   3     0   0   45 55                 100
1123295 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Jeremiah E Burke High   Regular School No High 09 12 2017   grade_9 2 65 31 0   1     0   1   53 47                       100 2 65 31 0   1     0   1   53 47                 100
1127049 MA Norfolk   school 2507920 187   Millis 250792001255 1870505 Millis High School   Regular School No High 09 12 2017   grade_9 86 4 7 0   2     0   1   46 54                       100 86 4 7 0   2     0   1   46 54                 100
1371363 MA Middlesex   school 2511760 301   Tyngsborough 251176001934 3010505 Tyngsborough High School   Regular School No High 09 12 2020   grade_9 79 2 5 0   10     0   4   45 55 *                     100.0 79 2 5 0   10     0   4   45 55                 100
1673169 MA Suffolk   school 2502790 35   Boston 250279000327 350535 Boston - The English High   Regular School No High 09 12 2021   grade_9 5 44 43 1   1     0   6   54 46 *                     100.0 5 44 43 1   1     0   6   54 46                 100
1679975 MA Suffolk   school 2500054 452   Edward M. Kennedy Academy for Health Careers (Horace Mann Charter) (District) 250005401258 4520505 Edward M. Kennedy Academy for Health Careers (Horace Mann Charter) (District) - Edward M. Kennedy Academy for Health Careers (Horace Mann Charter School)   Regular School Yes High 09 12 2021   grade_9 5 39 47 0   2     0   7   38 62 *                     100.0 5 39 47 0   2     0   7   38 62                 100
1680353 MA Worcester   school 2502160 615   Athol-Royalston 250216000074 6150505 Athol-Royalston - Athol High   Regular School No High 09 12 2021   grade_9 71 4 22 0   1     0   2   49 51 *                     100.0 71 4 22 0   1     0   2   49 51                 100
2041772 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton Senior High   Regular School No High 09 12 2019   grade_9 60 3 32 0   2     0   3   51 49                       100.0 60 3 32 0   2     0   3   51 49                 100
2047453 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No High 07 12 2019   grade_9 6 12 74 0   7     0   1   48 52                       100.0 6 12 74 0   7     0   1   48 52                 100
2048416 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier Regional   Regular School No High 07 12 2019   grade_9 88 2 4 0   1     1   4   51 49                       100.0 88 2 4 0   1     1   4   51 49                 100
737784 MA Worcester   school 2504230 77   Douglas 250423000570 770505 Douglas High School   Regular School No 3 09 12 2015   grade_9 99 0 2 0   0     0   0   52 49                       101 99 0 2 0   0     0   0   52 49                 101
744457 MA Essex   school 2500067 698   Manchester Essex Regional 250006701109 6980510 Manchester Essex Regional High School   Regular School No 3 09 12 2015   grade_9 101 0 0 0   0     0   0   49 52                       101 101 0 0 0   0     0   0   49 52                 101
933702 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative Education School No 3 09 12 2016   grade_9 7 27 62 0   4     1   0   49 52                       101 7 27 62 0   4     1   0   49 52                 101
1123421 MA Suffolk   school 2502790 35   Boston 250279002729 350658 West Roxbury Academy   Regular School No High 09 12 2017   grade_9 7 53 38 0   0     0   3   56 45                       101 7 53 38 0   0     0   3   56 45                 101
1130068 MA Worcester   school 2512240 316   Webster 251224002012 3160505 Bartlett High School   Regular School No High 09 12 2017   grade_9 68 6 17 0   4     0   6   60 41                       101 68 6 17 0   4     0   6   60 41                 101
1131818 MA Worcester   school 2502160 615   Athol-Royalston 250216000074 6150505 Athol High   Regular School No High 09 12 2017   grade_9 87 4 6 0   2     0   2   54 47                       101 87 4 6 0   2     0   2   54 47                 101
1366531 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No High 06 12 2020   grade_9 98 0 0 2   1     0   0   41 60 *                     101.0 98 0 0 2   1     0   0   41 60                 101
1680738 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire - Hampshire Regional High   Regular School No High 07 12 2021   grade_9 95 0 2 0   1     0   3   51 50 *                     101.0 95 0 2 0   1     0   3   51 50                 101
2237012 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater: West Bridgewater Junior/Senior   Regular School No High 07 12 2018   grade_9 86 4 5 0   2     0   4   47 54                       101.0 86 4 5 0   2     0   4   47 54                 101
2238167 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public (District): Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2018   grade_9 16 47 29 1   6     0   2   44 57                       101.0 16 47 29 1   6     0   2   44 57                 101
2238724 MA Worcester   school 2502715 622   Blackstone-Millville 250271500192 6220505 Blackstone-Millville: Blackstone Millville RHS   Regular School No High 09 12 2018   grade_9 85 3 10 0   3     0   0   62 39                       101.0 85 3 10 0   3     0   0   62 39                 101
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
736899 MA Suffolk   school 2502790 35   Boston 250279001902 350581 Community Academy of Science and Health   Regular School No 3 09 12 2015   grade_9 3 75 22 0   1     0   1   62 40                       102 3 75 22 0   1     0   1   62 40                 102
738550 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2015   grade_9 84 2 1 0   12     0   3   56 46                       102 84 2 1 0   12     0   3   56 46                 102
741951 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No 4 06 12 2015   grade_9 36 19 37 0   2     0   8   54 48                       102 36 19 37 0   2     0   8   54 48                 102
744041 MA Worcester   school 2502160 615   Athol-Royalston 250216000074 6150505 Athol High   Regular School No 3 09 12 2015   grade_9 93 2 5 0   2     0   0   50 52                       102 93 2 5 0   2     0   0   50 52                 102
941242 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire Regional High   Regular School No 3 07 12 2016   grade_9 99 0 1 0   0     0   2   54 48                       102 99 0 1 0   0     0   2   54 48                 102
941993 MA Bristol   school 2500553 3507   City on a Hill Charter Public School New Bedford (District) 250055302814 35070505 City on a Hill Charter Public School New Bedford   Regular School Yes 4 09 10 2016   grade_9 35 16 46 0   1     0   4   52 50                       102 35 16 46 0   1     0   4   52 50                 102
1130197 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No High 07 12 2017   grade_9 88 7 2 0   1     0   4   49 53                       102 88 7 2 0   1     0   4   49 53                 102
1133154 MA Bristol   school 2500553 3507   City on a Hill Charter Public School New Bedford (District) 250055302814 35070505 City on a Hill Charter Public School New Bedford   Regular School Yes Other 09 11 2017   grade_9 32 10 56 0   0     0   4   46 56                       102 32 10 56 0   0     0   4   46 56                 102
1368094 MA Worcester   school 2506720 151   Leicester 250672000972 1510505 Leicester High   Regular School No High 09 12 2020   grade_9 80 7 10 0   2     0   3   41 61 *                     102.0 80 7 10 0   2     0   3   41 61                 102
1372668 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2020   grade_9 20 50 24 0   3     0   5   53 49 *                     102.0 20 50 24 0   3     0   5   53 49                 102
1373110 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202738 6160505 Ayer Shirley Regional High School   Regular School No High 09 12 2020   grade_9 83 5 11 2   0     0   1   47 55 *                     102.0 83 5 11 2   0     0   1   47 55                 102
1673154 MA Suffolk   school 2502790 35   Boston 250279002016 350522 Boston - Excel High School   Regular School No High 09 12 2021   grade_9 9 22 54 0   14     0   3   58 44 *                     102.0 9 22 54 0   14     0   3   58 44                 102
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
2230100 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Boston: Jeremiah E Burke High   Regular School No High 09 12 2018   grade_9 0 69 29 0   0     1   3   66 36                       102.0 0 69 29 0   0     1   3   66 36                 102
2230120 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Boston: Fenway High School   Alternative School No High 09 12 2018   grade_9 3 26 70 0   2     0   1   50 52                       102.0 3 26 70 0   2     0   1   50 52                 102
2234782 MA Worcester   school 2509270 226   Oxford 250927001482 2260505 Oxford: Oxford High   Regular School No High 08 12 2018   grade_9 80 3 11 0   5     0   3   52 50                       102.0 80 3 11 0   5     0   3   52 50                 102
941397 MA Worcester   school 2508280 720   Narragansett 250828001285 7200505 Narragansett Regional High   Regular School No 3 09 12 2016   grade_9 97 0 3 0   1     0   2   56 47                       103 97 0 3 0   1     0   2   56 47                 103
1129333 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No Other 06 12 2017   grade_9 24 31 41 0   4     0   3   56 47                       103 24 31 41 0   4     0   3   56 47                 103
1129585 MA Worcester   school 2511400 290   Sutton 251140001414 2900510 Sutton High School   Regular School No High 09 12 2017   grade_9 98 0 1 0   0     0   4   46 57                       103 98 0 1 0   0     0   4   46 57                 103
1133112 MA Hampden   school 2500547 3501   Paulo Freire Social Justice Charter School (District) 250054702782 35010505 Paulo Freire Social Justice Charter School   Regular School Yes High 09 12 2017   grade_9 6 6 91 0   0     0   0   43 60                       103 6 6 91 0   0     0   0   43 60                 103
1366067 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No High 09 12 2020   grade_9 96 0 1 1   2     0   3   43 60 *                     103.0 96 0 1 1   2     0   3   43 60                 103
1372681 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2020   grade_9 35 50 5 1   5     0   7   49 54 *                     103.0 35 50 5 1   5     0   7   49 54                 103
1373166 MA Worcester   school 2502715 622   Blackstone-Millville 250271500192 6220505 Blackstone Millville RHS   Regular School No High 09 12 2020   grade_9 91 5 5 0   0     0   2   58 45 *                     103.0 91 5 5 0   0     0   2   58 45                 103
1673944 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset - Cohasset High School   Regular School No High 09 12 2021   grade_9 94 3 1 0   3     0   2   52 51 *                     103.0 94 3 1 0   3     0   2   52 51                 103
2042705 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No High 06 12 2019   grade_9 75 1 7 0   17     0   3   44 59                       103.0 75 1 7 0   17     0   3   44 59                 103
2230192 MA Suffolk   school 2502790 35   Boston 250279001902 350581 Boston: Community Academy of Science and Health   Regular School No High 09 12 2018   grade_9 1 65 32 0   3     0   2   62 41                       103.0 1 65 32 0   3     0   2   62 41                 103
2236152 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 Springfield: The Springfield Renaissance School an Expeditionary Learning School   Regular School No High 06 12 2018   grade_9 15 27 58 0   1     1   1   56 47                       103.0 15 27 58 0   1     1   1   56 47                 103
743654 MA Suffolk   school 2500054 452   Edward M. Kennedy Academy for Health Careers (Horace Mann Charter) (District) 250005401258 4520505 Edward M. Kennedy Academy for Health Careers (Horace Mann Charter School)   Regular School Yes 3 09 12 2015   grade_9 3 39 52 1   5     0   4   37 67                       104 3 39 52 1   5     0   4   37 67                 104
1132120 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier Regional   Regular School No High 07 12 2017   grade_9 88 3 6 0   5     0   2   62 42                       104 88 3 6 0   5     0   2   62 42                 104
1365917 MA Suffolk   school 2502790 35   Boston 250279002016 350522 Excel High School   Regular School No High 09 12 2020   grade_9 9 30 47 0   16     1   1   67 37 *                     104.0 9 30 47 0   16     1   1   67 37                 104
1367570 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield High   Regular School No High 08 12 2020   grade_9 66 2 28 0   1     0   7   52 52 *                     104.0 66 2 28 0   1     0   7   52 52                 104
1373474 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire Regional High   Regular School No High 07 12 2020   grade_9 95 0 6 0   1     0   2   44 60 *                     104.0 95 0 6 0   1     0   2   44 60                 104
1681123 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick-Tolland-Granville Regional School District - Southwick Regional School   Regular School No High 07 12 2021   grade_9 93 0 7 0   1     0   3   53 51 *                     104.0 93 0 7 0   1     0   3   53 51                 104
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

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