enrollments

Data source: Big Local News · About: Big Local

391 rows where grade = "grade_9", state = "MA" and year = 2020 sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 391 ✖

grade ✖

  • grade_9 · 391 ✖
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
1372668 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
1364794 1364794 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2020   grade_9 125 7 20 0   6     0   2   75 85 *                     160.0 125 7 20 0   6     0   2   75 85                 160
1372472 1372472 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 2020   grade_9 3 41 22 0   0     0   4   39 31 *                     70.0 3 41 22 0   0     0   4   39 31                 70
1373025 1373025 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2020   grade_9 256 16 19 1   166     0   12   250 220 *                     470.0 256 16 19 1   166     0   12   250 220                 470
1368466 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
1372563 1372563 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 2020   grade_9 99 7 15 0   23     0   13   82 75 *                     157.0 99 7 15 0   23     0   13   82 75                 157
1364834 1364834 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2020   grade_9 247 4 28 0   10     0   8   160 137 *                     297.0 247 4 28 0   10     0   8   160 137                 297
1373689 1373689 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Algonquin Regional High   Regular School No High 09 12 2020   grade_9 234 4 20 3   42     2   16   159 162 *                     321.0 234 4 20 3   42     2   16   159 162                 321
1364854 1364854 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2020   grade_9 101 2 8 0   0     0   7   63 55 *                     118.0 101 2 8 0   0     0   7   63 55                 118
1364859 1364859 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2020   grade_9 7 0 1 0   0     0   0   4 4 *                     8.0 7 0 1 0   0     0   0   4 4                 8
1373046 1373046 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No High 09 12 2020   grade_9 104 20 35 0   23     0   23   110 95 *                     205.0 104 20 35 0   23     0   23   110 95                 205
1364925 1364925 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No High 09 12 2020   grade_9 321 8 27 3   84     0   12   208 247 *                     455.0 321 8 27 3   84     0   12   208 247                 455
1365944 1365944 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Another Course To College   Alternative School No High 09 12 2020   grade_9 5 30 26 0   1     0   0   42 20 *                     62.0 5 30 26 0   1     0   0   42 20                 62
1373346 1373346 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000746 6650505 Apponequet Regional High   Regular School No High 09 12 2020   grade_9 185 3 1 0   1     0   1   96 95 *                     191.0 185 3 1 0   1     0   1   96 95                 191
1374237 1374237 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Secondary 06 11 2020   grade_9 49 14 24 1   2     0   3   54 39 *                     93.0 49 14 24 1   2     0   3   54 39                 93
1364976 1364976 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2020   grade_9 272 17 20 0   36     0   23   162 205 *                     368.0 272 17 20 0   36     0   23   162 205                 368
1364990 1364990 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No High 09 12 2020   grade_9 121 4 22 2   29     0   2   89 91 *                     180.0 121 4 22 2   29     0   2   89 91                 180
1374072 1374072 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 2020   grade_9 221 10 63 1   0     0   5   182 115 3                     300.0 221 10 63 1   0     0   5   182 115 3               300
1373089 1373089 MA Worcester   school 2502160 615   Athol-Royalston 250216000074 6150505 Athol High   Regular School No High 09 12 2020   grade_9 66 0 6 0   1     0   2   47 28 *                     75.0 66 0 6 0   1     0   2   47 28                 75
1372921 1372921 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2020   grade_9 56 7 18 0   2     0   1   38 46 *                     84.0 56 7 18 0   2     0   1   38 46                 84
1365032 1365032 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No High 09 12 2020   grade_9 310 28 79 1   16     0   20   259 194 *                     454.0 310 28 79 1   16     0   20   259 194                 454
1365053 1365053 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No High 09 12 2020   grade_9 156 5 24 0   7     0   4   101 95 *                     196.0 156 5 24 0   7     0   4   101 95                 196
1365067 1365067 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2020   grade_9 17 21 7 0   1     0   4   28 22 *                     50.0 17 21 7 0   1     0   4   28 22                 50
1373110 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
1367203 1367203 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No High 09 12 2020   grade_9 296 56 162 1   28     0   38   296 284 *                     581.0 296 56 162 1   28     0   38   296 284                 581
1365097 1365097 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2020   grade_9 218 30 53 2   5     1   23   134 198 *                     332.0 218 30 53 2   5     1   23   134 198                 332
1371608 1371608 MA Worcester   school 2512240 316   Webster 251224002012 3160505 Bartlett High School   Regular School No High 09 12 2020   grade_9 56 12 35 0   2     0   3   42 66 *                     108.0 56 12 35 0   2     0   3   42 66                 108
1374161 1374161 MA Worcester   school 2511050 876   Southern Worcester County Regional Vocational Technical 251105001779 8760605 Bay Path Regional Vocational Technical High School   Career and Technical School No High 09 12 2020   grade_9 273 4 35 1   0     0   2   182 133 *                     315.0 273 4 35 1   0     0   2   182 133                 315
1374192 1374192 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes High 06 12 2020   grade_9 5 15 45 0   0     0   0   43 22 *                     65.0 5 15 45 0   0     0   0   43 22                 65
1365112 1365112 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No High 09 12 2020   grade_9 138 20 25 1   36     0   8   108 120 *                     228.0 138 20 25 1   36     0   8   108 120                 228
1365126 1365126 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No High 09 12 2020   grade_9 171 4 6 0   3     1   7   103 89 *                     192.0 171 4 6 0   3     1   7   103 89                 192
1365145 1365145 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No High 08 12 2020   grade_9 109 8 4 0   4     0   1   59 67 *                     126.0 109 8 4 0   4     0   1   59 67                 126
1365179 1365179 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont High   Regular School No High 09 12 2020   grade_9 210 13 11 0   66     0   18   159 159 *                     318.0 210 13 11 0   66     0   18   159 159                 318
1372485 1372485 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 2020   grade_9 35 6 5 0   3     0   3   28 23 *                     52.0 35 6 5 0   3     0   3   28 23                 52
1365223 1365223 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly High   Regular School No High 09 12 2020   grade_9 270 12 43 0   8     0   14   174 173 *                     347.0 270 12 43 0   8     0   14   174 173                 347
1365261 1365261 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica Memorial High School   Regular School No High 08 12 2020   grade_9 227 12 22 0   23     1   8   132 161 *                     293.0 227 12 22 0   23     1   8   132 161                 293
1373166 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
1374076 1374076 MA Worcester   school 2502710 805   Blackstone Valley Regional Vocational Technical 250271000191 8050605 Blackstone Valley   Career and Technical School No High 09 12 2020   grade_9 262 2 30 0   6     1   12   155 157 *                     313.0 262 2 30 0   6     1   12   155 157                 313
1374080 1374080 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 2020   grade_9 124 44 47 1   6     0   16   126 112 *                     238.0 124 44 47 1   6     0   16   126 112                 238
1365964 1365964 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative School No High 09 12 2020   grade_9 9 58 57 0   2     0   6   42 89 *                     132.0 9 58 57 0   2     0   6   42 89                 132
1372698 1372698 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes High 05 12 2020   grade_9 44 24 18 0   2     0   2   49 41 *                     90.0 44 24 18 0   2     0   2   49 41                 90
1365975 1365975 MA Suffolk   school 2502790 35   Boston 250279001692 350558 Boston Community Leadership Academy   Regular School No High 09 12 2020   grade_9 3 36 77 0   3     1   3   61 62 *                     123.0 3 36 77 0   3     1   3   61 62                 123
1372520 1372520 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 2020   grade_9 6 46 42 1   0     0   1   42 54 *                     96.0 6 46 42 1   0     0   1   42 54                 96
1372463 1372463 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 2020   grade_9 4 34 41 1   1     0   0   45 36 *                     81.0 4 34 41 1   1     0   0   45 36                 81
1365904 1365904 MA Suffolk   school 2502790 35   Boston 250279002015 350507 Boston International High School   Regular School No High 09 12 2020   grade_9 3 40 103 1   8     0   0   105 50 *                     155.0 3 40 103 1   8     0   0   105 50                 155
1365982 1365982 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2020   grade_9 191 41 65 0   130     2   23   211 239 *                     452.0 191 41 65 0   130     2   23   211 239                 452
1365960 1365960 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No High 07 12 2020   grade_9 100 75 83 1   72     1   11   135 207 *                     343.0 100 75 83 1   72     1   11   135 207                 343
1372492 1372492 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes High 06 12 2020   grade_9 0 66 18 0   0     0   3   45 42 *                     87.0 0 66 18 0   0     0   3   45 42                 87
1366067 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
1366123 1366123 MA Norfolk   school 2502940 40   Braintree 250294000361 400505 Braintree High   Regular School No High 09 12 2020   grade_9 292 24 21 0   73     1   11   198 223 *                     422.0 292 24 21 0   73     1   11   198 223                 422
1373193 1373193 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303000380 6250505 Bridgewater-Raynham Regional   Regular School No High 09 12 2020   grade_9 274 17 7 1   7     0   18   163 161 *                     324.0 274 17 7 1   7     0   18   163 161                 324
1365899 1365899 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Brighton High   Regular School No High 09 12 2020   grade_9 9 36 65 1   1     0   2   66 48 *                     114.0 9 36 65 1   1     0   2   66 48                 114
1374177 1374177 MA Bristol   school 2503070 910   Bristol County Agricultural 250307000382 9100705 Bristol County Agricultural High   Career and Technical School No High 09 12 2020   grade_9 116 0 4 0   2     0   1   30 93 *                     123.0 116 0 4 0   2     0   1   30 93                 123
1374084 1374084 MA Bristol   school 2503080 810   Bristol-Plymouth Regional Vocational Technical 250308002262 8100605 Bristol-Plymouth Vocational Technical   Career and Technical School No High 09 12 2020   grade_9 306 9 19 1   4     0   18   197 160 *                     357.0 306 9 19 1   4     0   18   197 160                 357
1366246 1366246 MA Plymouth   school 2503090 44   Brockton 250309002652 440515 Brockton Champion High School   Alternative School No High 09 12 2020   grade_9 5 7 4 0   0     0   2   8 10 *                     18.0 5 7 4 0   0     0   2   8 10                 18
1366241 1366241 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2020   grade_9 169 865 231 3   29     3   52   766 586 *                     1352.0 169 865 231 3   29     3   52   766 586                 1352
1367626 1367626 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No High 06 12 2020   grade_9 58 3 3 0   9     0   1   41 33 *                     74.0 58 3 3 0   9     0   1   41 33                 74
1372543 1372543 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_9 5 91 32 0   1     0   2   71 60 *                     131.0 5 91 32 0   1     0   2   71 60                 131
1366342 1366342 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2020   grade_9 281 48 54 0   81     0   57   253 268 0                     521.0 281 48 54 0   81     0   57   253 268 0               521
1366376 1366376 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington High   Regular School No High 09 12 2020   grade_9 149 15 15 1   30     0   11   114 107 *                     221.0 149 15 15 1   30     0   11   114 107                 221
1372393 1372393 MA Worcester   school 2513230 348   Worcester 251323002200 3480503 Burncoat Senior High   Regular School No High 09 12 2020   grade_9 106 55 156 0   8     0   14   165 174 *                     339.0 106 55 156 0   8     0   14   165 174                 339
1366479 1366479 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2020   grade_9 190 130 78 0   48     3   45   231 263 *                     494.0 190 130 78 0   48     3   45   231 263                 494
1366506 1366506 MA Norfolk   school 2503300 50   Canton 250330000451 500505 Canton High   Regular School No High 09 12 2020   grade_9 148 20 14 0   20     0   11   96 117 *                     213.0 148 20 14 0   20     0   11   96 117                 213
1374088 1374088 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 2020   grade_9 113 16 21 4   1     0   7   98 63 *                     162.0 113 16 21 4   1     0   7   98 63                 162
1366531 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
1368153 1368153 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Center For Technical Education Innovation   Career and Technical School No High 09 12 2020   grade_9 116 24 98 0   8     0   12   171 87 *                     258.0 116 24 98 0   8     0   12   171 87                 258
1374129 1374129 MA Berkshire   school 2508950 851   Northern Berkshire Regional Vocational Technical 250895002282 8510605 Charles McCann Vocational Technical   Career and Technical School No High 09 12 2020   grade_9 135 0 2 0   1     0   2   82 58 *                     140.0 135 0 2 0   1     0   2   82 58                 140
1365908 1365908 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No High 09 12 2020   grade_9 12 48 168 0   10     0   4   146 96 *                     242.0 12 48 168 0   10     0   4   146 96                 242
1366565 1366565 MA Middlesex   school 2503510 56   Chelmsford 250351000475 560505 Chelmsford High   Regular School No High 09 12 2020   grade_9 233 11 16 0   58     0   11   157 172 *                     329.0 233 11 16 0   58     0   11   157 172                 329
1366602 1366602 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No High 09 12 2020   grade_9 22 14 428 1   1     0   6   267 205 *                     472.0 22 14 428 1   1     0   6   267 205                 472
1366606 1366606 MA Suffolk   school 2503540 57   Chelsea 250354002890 570515 Chelsea Opportunity Academy   Alternative School No High 09 12 2020   grade_9 * * * *   *     *   *   2 2 *                     4.0                         2 2                 4
1366634 1366634 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No High 07 12 2020   grade_9 7 0 11 0   0     0   1   9 10 *                     19.0 7 0 11 0   0     0   1   9 10                 19
1366678 1366678 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee Comprehensive High School   Regular School No High 09 12 2020   grade_9 186 9 100 0   5     0   6   182 124 *                     306.0 186 9 100 0   5     0   6   182 124                 306
1366674 1366674 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee High   Regular School No High 09 12 2020   grade_9 86 17 111 0   5     0   11   116 114 *                     230.0 86 17 111 0   5     0   11   116 114                 230
1372595 1372595 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 2020   grade_9 0 40 25 0   0     0   1   41 25 *                     66.0 0 40 25 0   0     0   1   41 25                 66
1374206 1374206 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 2020   grade_9 2 25 14 0   0     0   0   28 13 *                     41.0 2 25 14 0   0     0   0   28 13                 41
1374226 1374226 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 High 09 12 2020   grade_9 12 4 23 0   1     0   8   24 24 *                     48.0 12 4 23 0   1     0   8   24 24                 48
1372380 1372380 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No High 07 12 2020   grade_9 5 7 75 0   8     0   0   51 44 *                     95.0 5 7 75 0   8     0   0   51 44                 95
1368592 1368592 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Classical High   Regular School No High 09 12 2020   grade_9 64 35 319 2   47     0   14   251 230 *                     481.0 64 35 319 2   47     0   14   251 230                 481
1366702 1366702 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton Senior High   Regular School No High 09 12 2020   grade_9 76 7 44 0   1     0   0   71 57 *                     128.0 76 7 44 0   1     0   0   71 57                 128
1372609 1372609 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2020   grade_9 0 34 6 0   0     0   0   22 18 *                     40.0 0 34 6 0   0     0   0   22 18                 40
1366716 1366716 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset High School   Regular School No High 09 12 2020   grade_9 107 4 1 0   4     0   1   59 58 *                     117.0 107 4 1 0   4     0   1   59 58                 117
1374205 1374205 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Other KG 09 2020   grade_9 9 6 11 0   16     0   1   24 19 *                     43.0 9 6 11 0   16     0   1   24 19                 43
1365913 1365913 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Community Academy   Regular School No High 09 12 2020   grade_9 * * * *   *     *   *   4 1 *                     5.0                         4 1                 5
1366001 1366001 MA Suffolk   school 2502790 35   Boston 250279001902 350581 Community Academy of Science and Health   Regular School No High 09 12 2020   grade_9 3 42 26 1   6     0   6   49 35 *                     84.0 3 42 26 1   6     0   6   49 35                 84
1372591 1372591 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge   Regular School Yes High 06 12 2020   grade_9 1 29 9 1   2     0   1   17 26 *                     43.0 1 29 9 1   2     0   1   17 26                 43
1373232 1373232 MA Middlesex   school 2503870 640   Concord-Carlisle 250387000527 6400505 Concord Carlisle High   Regular School No High 09 12 2020   grade_9 270 18 13 0   28     0   15   170 172 *                     344.0 270 18 13 0   28     0   15   170 172                 344
1371034 1371034 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Conservatory of the Arts   Regular School No High 06 12 2020   grade_9 4 9 39 0   0     0   2   12 42 *                     54.0 4 9 39 0   0     0   2   12 42                 54
1367716 1367716 MA Essex   school 2505970 128   Haverhill 250597002907 1280515 Crowell   Regular School No Secondary 09 11 2020   grade_9 5 0 9 0   0     0   0   9 5 *                     14.0 5 0 9 0   0     0   0   9 5                 14
1374316 1374316 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_9 * * * *   *     *   *   * * *                     0.0                                             0
1366786 1366786 MA Essex   school 2503990 71   Danvers 250399000529 710505 Danvers High   Regular School No High 09 12 2020   grade_9 177 4 18 0   7     0   5   105 105 *                     211.0 177 4 18 0   7     0   5   105 105                 211
1366814 1366814 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth High   Regular School No High 09 12 2020   grade_9 192 7 14 0   0     0   22   125 110 *                     235.0 192 7 14 0   0     0   22   125 110                 235
1373896 1373896 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No High 09 12 2020   grade_9 57 2 12 0   2     0   2   35 40 *                     75.0 57 2 12 0   2     0   2   35 40                 75
1365388 1365388 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No High 06 12 2020   grade_9 1 60 37 1   1     1   4   53 52 *                     105.0 1 60 37 1   1     1   4   53 52                 105
1366843 1366843 MA Norfolk   school 2504050 73   Dedham 250405000548 730505 Dedham High   Regular School No High 09 12 2020   grade_9 117 15 28 0   5     0   4   75 94 *                     169.0 117 15 28 0   5     0   4   75 94                 169
1373255 1373255 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2020   grade_9 127 22 23 3   5     0   7   102 85 *                     187.0 127 22 23 3   5     0   7   102 85                 187
1367067 1367067 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2020   grade_9 1 1 5 0   0     0   0   5 2 *                     7.0 1 1 5 0   0     0   0   5 2                 7
1373280 1373280 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000568 6500505 Dighton-Rehoboth Regional High School   Regular School No High 09 12 2020   grade_9 161 3 4 0   2     0   6   94 82 *                     176.0 161 3 4 0   2     0   6   94 82                 176
1374100 1374100 MA Bristol   school 2505485 821   Greater Fall River Regional Vocational Technical 250548502269 8210605 Diman Regional Vocational Technical High   Career and Technical School No High 09 12 2020   grade_9 276 12 53 3   10     0   18   214 158 *                     372.0 276 12 53 3   10     0   18   214 158                 372
1372398 1372398 MA Worcester   school 2513230 348   Worcester 251323002209 3480512 Doherty Memorial High   Regular School No High 09 12 2020   grade_9 126 58 148 2   19     0   21   211 163 *                     374.0 126 58 148 2   19     0   21   211 163                 374

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