Data source: Big Local News · About: Big Local

396 rows where grade = "grade_10", state = "MA" and year = 2019 sorted by district

View and edit SQL

year

  • 2019 · 396

grade

  • grade_10 · 396
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
2047740 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 2019   grade_10 16 47 26 0   6     0   1   39 57                       96.0 16 47 26 0   6     0   1   39 57                 96
2039821 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2019   grade_10 127 6 13 0   2     0   1   79 70                       149.0 127 6 13 0   2     0   1   79 70                 149
2047546 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2019   grade_10 3 47 19 0   1     0   0   36 34                       70.0 3 47 19 0   1     0   0   36 34                 70
2048098 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2019   grade_10 243 8 11 1   143     0   23   223 206                       429.0 243 8 11 1   143     0   23   223 206                 429
2048113 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley High School   Regular School No High 08 12 2019   grade_10 44 3 0 0   3     0   0   27 23                       50.0 44 3 0 0   3     0   0   27 23                 50
2047637 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2019   grade_10 95 1 10 0   43     0   5   80 74                       154.0 95 1 10 0   43     0   5   80 74                 154
2039861 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2019   grade_10 259 4 20 0   1     0   8   139 153                       292.0 259 4 20 0   1     0   8   139 153                 292
2039882 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2019   grade_10 118 4 12 0   2     0   9   75 70                       145.0 118 4 12 0   2     0   9   75 70                 145
2039887 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2019   grade_10 9 0 0 0   0     0   1   7 3                       10.0 9 0 0 0   0     0   1   7 3                 10
2048120 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No High 09 12 2019   grade_10 121 17 42 0   24     0   27   104 127                       231.0 121 17 42 0   24     0   27   104 127                 231
2039953 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No High 09 12 2019   grade_10 324 9 21 0   96     0   10   209 250                       460.0 324 9 21 0   96     0   10   209 250                 460
2049313 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Middle 06 10 2019   grade_10 16 7 7 0   1     0   2   16 17                       33.0 16 7 7 0   1     0   2   16 17                 33
2040004 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2019   grade_10 258 12 24 0   36     0   14   170 173                       344.0 258 12 24 0   36     0   14   170 173                 344
2048141 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000069 6100505 Oakmont Regional High School   Regular School No High 09 12 2019   grade_10 163 0 5 0   4     0   2   79 95                       174.0 163 0 5 0   4     0   2   79 95                 174
2040018 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No High 09 12 2019   grade_10 151 4 25 0   21     0   9   102 108                       210.0 151 4 25 0   21     0   9   102 108                 210
2049147 MA Middlesex   school 2502110 801   Assabet Valley Regional Vocational Technical 250211002257 8010605 Assabet Valley Vocational High School   Career and Technical School No High 09 12 2019   grade_10 236 2 43 0   1     0   6   173 114                       288.0 236 2 43 0   1     0   6   173 114                 288
2048163 MA Worcester   school 2502160 615   Athol-Royalston 250216000074 6150505 Athol High   Regular School No High 09 12 2019   grade_10 75 1 9 0   0     0   5   47 43                       90.0 75 1 9 0   0     0   5   47 43                 90
2047994 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2019   grade_10 65 4 12 0   3     0   1   48 37                       85.0 65 4 12 0   3     0   1   48 37                 85
2040060 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No High 09 12 2019   grade_10 295 30 72 1   25     2   27   239 213                       452.0 295 30 72 1   25     2   27   239 213                 452
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
2040082 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No High 09 12 2019   grade_10 158 3 9 1   8     0   5   83 101                       184.0 158 3 9 1   8     0   5   83 101                 184
2040097 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2019   grade_10 16 21 3 0   1     0   1   28 14                       42.0 16 21 3 0   1     0   1   28 14                 42
2048185 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202738 6160505 Ayer Shirley Regional High School   Regular School No High 09 12 2019   grade_10 61 4 12 2   2     0   14   41 54                       95.0 61 4 12 2   2     0   14   41 54                 95
2040124 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2019   grade_10 254 31 58 1   3     3   12   189 173                       362.0 254 31 58 1   3     3   12   189 173                 362
2049269 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes High 06 12 2019   grade_10 3 19 52 0   1     0   1   37 39                       76.0 3 19 52 0   1     0   1   37 39                 76
2040139 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No High 09 12 2019   grade_10 121 11 22 0   22     0   12   99 89                       188.0 121 11 22 0   22     0   12   99 89                 188
2040153 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No High 09 12 2019   grade_10 157 5 3 1   3     0   5   85 89                       174.0 157 5 3 1   3     0   5   85 89                 174
2040172 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No High 08 12 2019   grade_10 132 6 4 0   5     0   5   89 63                       152.0 132 6 4 0   5     0   5   89 63                 152
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
2040206 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont High   Regular School No High 09 12 2019   grade_10 224 10 10 1   64     0   21   170 160                       330.0 224 10 10 1   64     0   21   170 160                 330
2047559 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes High 06 12 2019   grade_10 33 8 3 0   0     0   1   22 23                       45.0 33 8 3 0   0     0   1   22 23                 45
2048199 MA Berkshire   school 2502530 618   Berkshire Hills 250253000154 6180505 Monument Mt Regional High   Regular School No High 09 12 2019   grade_10 102 4 10 0   3     2   6   66 61                       127.0 102 4 10 0   3     2   6   66 61                 127
2048207 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Tahanto Regional High   Regular School No High 06 12 2019   grade_10 66 2 5 0   3     0   4   40 40                       80.0 66 2 5 0   3     0   4   40 40                 80
2040257 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly High   Regular School No High 09 12 2019   grade_10 247 11 49 0   8     0   10   170 155                       325.0 247 11 49 0   8     0   10   170 155                 325
2040305 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica Memorial High School   Regular School No High 09 12 2019   grade_10 190 14 11 0   22     0   4   115 126                       241.0 190 14 11 0   22     0   4   115 126                 241
2049151 MA Worcester   school 2502710 805   Blackstone Valley Regional Vocational Technical 250271000191 8050605 Blackstone Valley   Career and Technical School No High 09 12 2019   grade_10 279 1 17 0   6     0   8   162 149                       311.0 279 1 17 0   6     0   8   162 149                 311
2048227 MA Worcester   school 2502715 622   Blackstone-Millville 250271500192 6220505 Blackstone Millville RHS   Regular School No High 09 12 2019   grade_10 88 2 9 0   3     0   1   59 44                       103.0 88 2 9 0   3     0   1   59 44                 103
2049155 MA Norfolk   school 2502740 806   Blue Hills Regional Vocational Technical 250274000193 8060605 Blue Hills Regional Vocational Technical   Career and Technical School No High 09 12 2019   grade_10 125 50 24 1   5     0   9   117 97                       214.0 125 50 24 1   5     0   9   117 97                 214
2040389 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No High 07 12 2019   grade_10 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2040432 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No High 06 12 2019   grade_10 0 41 11 0   0     0   4   31 25                       56.0 0 41 11 0   0     0   4   31 25                 56
2040827 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_10 3 26 21 0   1     0   0   36 15                       51.0 3 26 21 0   1     0   0   36 15                 51
2040930 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2019   grade_10 6 33 19 1   2     0   1   38 24                       62.0 6 33 19 1   2     0   1   38 24                 62
2040944 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Brighton High   Regular School No High 09 12 2019   grade_10 3 55 60 0   4     1   1   83 41                       124.0 3 55 60 0   4     1   1   83 41                 124
2040949 MA Suffolk   school 2502790 35   Boston 250279002015 350507 Boston International High School   Regular School No High 09 12 2019   grade_10 3 26 55 0   10     0   0   53 41                       94.0 3 26 55 0   10     0   0   53 41                 94
2040953 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No High 09 12 2019   grade_10 9 56 83 0   23     0   2   103 70                       173.0 9 56 83 0   23     0   2   103 70                 173
2040958 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Community Academy   Regular School No High 09 12 2019   grade_10 1 7 3 0   0     0   1   9 3                       12.0 1 7 3 0   0     0   1   9 3                 12
2040962 MA Suffolk   school 2502790 35   Boston 250279002016 350522 Excel High School   Regular School No High 09 12 2019   grade_10 8 48 50 0   26     0   3   89 46                       135.0 8 48 50 0   26     0   3   89 46                 135
2040966 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Jeremiah E Burke High   Regular School No High 09 12 2019   grade_10 1 67 21 0   0     2   2   52 41                       93.0 1 67 21 0   0     2   2   52 41                 93
2040970 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No High 09 12 2019   grade_10 30 11 221 0   6     0   4   164 108                       272.0 30 11 221 0   6     0   4   164 108                 272
2040975 MA Suffolk   school 2502790 35   Boston 250279000327 350535 The English High   Regular School No High 09 12 2019   grade_10 0 36 60 1   0     0   2   58 41                       99.0 0 36 60 1   0     0   2   58 41                 99
2040979 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Career and Technical School No High 09 12 2019   grade_10 3 98 164 0   4     0   3   175 97                       272.0 3 98 164 0   4     0   3   175 97                 272
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
2041000 MA Suffolk   school 2502790 35   Boston 250279000837 350543 Greater Egleston Community High School   Regular School No High 09 12 2019   grade_10 0 6 11 1   1     0   1   9 11                       20.0 0 6 11 1   1     0   1   9 11                 20
2041006 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No High 07 12 2019   grade_10 98 72 98 1   84     1   8   156 206                       362.0 98 72 98 1   84     1   8   156 206                 362
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
2041016 MA Suffolk   school 2502790 35   Boston 250279002753 350549 Margarita Muniz Academy   Regular School No High 09 12 2019   grade_10 0 1 72 0   0     0   1   38 36                       74.0 0 1 72 0   0     0   1   38 36                 74
2041020 MA Suffolk   school 2502790 35   Boston 250279001692 350558 Boston Community Leadership Academy   Regular School No High 09 12 2019   grade_10 6 38 69 0   2     0   0   52 63                       115.0 6 38 69 0   2     0   0   52 63                 115
2041027 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2019   grade_10 198 30 48 1   138     2   14   197 234                       431.0 198 30 48 1   138     2   14   197 234                 431
2041034 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No High 06 12 2019   grade_10 2 15 15 0   29     0   1   35 27                       62.0 2 15 15 0   29     0   1   35 27                 62
2041041 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No High 07 12 2019   grade_10 34 132 130 0   55     1   6   160 198                       358.0 34 132 130 0   55     1   6   160 198                 358
2041045 MA Suffolk   school 2502790 35   Boston 250279001898 350579 Urban Science Academy   Regular School No High 09 12 2019   grade_10 5 35 32 0   1     0   1   49 25                       74.0 5 35 32 0   1     0   1   49 25                 74
2041050 MA Suffolk   school 2502790 35   Boston 250279001902 350581 Community Academy of Science and Health   Regular School No High 09 12 2019   grade_10 1 55 25 0   0     0   0   44 37                       81.0 1 55 25 0   0     0   0   44 37                 81
2041055 MA Suffolk   school 2502790 35   Boston 250279002674 350655 Lyon Upper 9-12   Regular School No High 09 12 2019   grade_10 12 6 13 0   1     0   3   18 17                       35.0 12 6 13 0   1     0   3   18 17                 35
2041072 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No High 06 12 2019   grade_10 4 94 35 1   5     0   4   64 79                       143.0 4 94 35 1   5     0   4   64 79                 143
2041077 MA Suffolk   school 2502790 35   Boston 250279002729 350658 West Roxbury Academy   Regular School No High 09 12 2019   grade_10 6 37 36 0   1     1   0   50 31                       81.0 6 37 36 0   1     1   0   50 31                 81
2041082 MA Suffolk   school 2502790 35   Boston 250279000217 350690 Snowden International School at Copley   Regular School No High 09 12 2019   grade_10 11 42 55 1   8     0   6   57 66                       123.0 11 42 55 1   8     0   6   57 66                 123
2041103 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2019   grade_10 * * * *   *     *   *   1 2                       3.0                         1 2                 3
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
2047770 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes High 05 12 2019   grade_10 35 29 18 1   1     0   1   37 48                       85.0 35 29 18 1   1     0   1   37 48                 85
2047593 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter School   Regular School Yes High 09 12 2019   grade_10 4 34 31 0   1     0   0   31 39                       70.0 4 34 31 0   1     0   0   31 39                 70
2047537 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School   Regular School Yes High 06 12 2019   grade_10 9 43 28 0   3     0   3   47 39                       86.0 9 43 28 0   3     0   3   47 39                 86
2047566 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes High 06 12 2019   grade_10 2 55 27 0   1     0   0   39 46                       85.0 2 55 27 0   1     0   0   39 46                 85
2041127 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No High 09 12 2019   grade_10 98 1 7 0   2     0   4   49 63                       112.0 98 1 7 0   2     0   4   49 63                 112
2041190 MA Norfolk   school 2502940 40   Braintree 250294000361 400505 Braintree High   Regular School No High 09 12 2019   grade_10 305 25 18 0   76     0   6   215 215                       430.0 305 25 18 0   76     0   6   215 215                 430
2048255 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303000380 6250505 Bridgewater-Raynham Regional   Regular School No High 09 12 2019   grade_10 309 22 1 0   7     0   20   166 193                       359.0 309 22 1 0   7     0   20   166 193                 359
2049254 MA Bristol   school 2503070 910   Bristol County Agricultural 250307000382 9100705 Bristol County Agricultural High   Career and Technical School No High 09 12 2019   grade_10 97 3 9 0   0     0   6   38 76                       115.0 97 3 9 0   0     0   6   38 76                 115
2049159 MA Bristol   school 2503080 810   Bristol-Plymouth Regional Vocational Technical 250308002262 8100605 Bristol-Plymouth Vocational Technical   Career and Technical School No High 09 12 2019   grade_10 293 12 26 1   3     0   5   189 151                       340.0 293 12 26 1   3     0   5   189 151                 340
2041277 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Frederick Douglass Academy   Regular School No Secondary 07 11 2019   grade_10 * * * *   *     *   *   3 *                       4.0                         3                   4
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
2041312 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2019   grade_10 197 601 130 3   22     4   38   541 454                       995.0 197 601 130 3   22     4   38   541 454                 995
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
2041322 MA Plymouth   school 2503090 44   Brockton 250309002752 440520 Edison Academy   Regular School No High 09 12 2019   grade_10 4 16 9 0   0     1   1   21 10                       31.0 4 16 9 0   0     1   1   21 10                 31
2047619 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 11 2019   grade_10 2 36 21 0   1     0   0   29 31                       60.0 2 36 21 0   1     0   0   29 31                 60
2041413 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2019   grade_10 287 40 73 0   100     1   41   261 279                       542.0 287 40 73 0   100     1   41   261 279                 542
2041447 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington High   Regular School No Other 09 12 2019   grade_10 177 13 11 1   25     0   10   128 109                       237.0 177 13 11 1   25     0   10   128 109                 237
2041550 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2019   grade_10 188 136 74 2   54     2   37   256 237                       493.0 188 136 74 2   54     2   37   256 237                 493
2041577 MA Norfolk   school 2503300 50   Canton 250330000451 500505 Canton High   Regular School No High 09 12 2019   grade_10 164 31 13 0   34     0   12   117 137                       254.0 164 31 13 0   34     0   12   117 137                 254
2049163 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Region Vocational Technical   Career and Technical School No High 09 12 2019   grade_10 108 15 17 1   0     1   4   100 46                       146.0 108 15 17 1   0     1   4   100 46                 146
2041602 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No High 06 12 2019   grade_10 104 1 0 0   0     1   2   54 54                       108.0 104 1 0 0   0     1   2   54 54                 108
2048290 MA Berkshire   school 2503390 635   Central Berkshire 250339000467 6350505 Wahconah Regional High   Regular School No High 09 12 2019   grade_10 126 0 5 1   2     0   3   65 72                       137.0 126 0 5 1   2     0   3   65 72                 137
2041636 MA Middlesex   school 2503510 56   Chelmsford 250351000475 560505 Chelmsford High   Regular School No High 09 12 2019   grade_10 288 13 11 0   46     0   10   193 175                       368.0 288 13 11 0   46     0   10   193 175                 368
2041672 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No High 09 12 2019   grade_10 15 26 300 0   7     0   1   206 143                       349.0 15 26 300 0   7     0   1   206 143                 349
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
2041745 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee High   Regular School No High 09 12 2019   grade_10 122 19 113 0   7     0   3   128 135                       264.0 122 19 113 0   7     0   3   128 135                 264
2041749 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee Comprehensive High School   Regular School No High 09 12 2019   grade_10 218 7 83 2   12     0   9   185 146                       331.0 218 7 83 2   12     0   9   185 146                 331
2047668 MA Suffolk   school 2500026 437   City on a Hill Charter Public School Circuit Street (District) 250002600530 4370505 City on a Hill Charter Public School Circuit Street   Regular School Yes High 09 12 2019   grade_10 1 49 26 0   0     0   0   44 32                       76.0 1 49 26 0   0     0   0   44 32                 76
2049282 MA Suffolk   school 2500548 3504   City on a Hill Charter Public School Dudley Square (District) 250054802781 35040505 City on a Hill Charter Public School Dudley Square   Regular School Yes High 09 12 2019   grade_10 0 36 14 0   2     0   1   25 28                       53.0 0 36 14 0   2     0   1   25 28                 53

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