Data source: Big Local News · About: Big Local

387 rows where grade = "grade_9", state = "MA" and year = 2021 sorted by hispanic

View and edit SQL

year

  • 2021 · 387

grade

  • grade_9 · 387
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
1672372 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Bellingham - Keough Memorial Academy   Alternative School No High 08 12 2021   grade_9 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1672568 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Boston - Carter School   Regular School No High 07 12 2021   grade_9 * * * *   *     *   *   2 2 *                     4.0                         2 2                 4
1673149 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Boston - Community Academy   Regular School No High 09 12 2021   grade_9 * * * *   *     *   *   3 1 *                     4.0                         3 1                 4
1673484 MA Plymouth   school 2503090 44   Brockton 250309002752 440520 Brockton - Edison Academy   Regular School No High 09 12 2021   grade_9 * * * *   *     *   *   1 2 *                     3.0                         1 2                 3
1674519 MA Worcester   school 2504890 97   Fitchburg 250489002110 970510 Fitchburg - Goodrich Academy   Regular School No High 09 12 2021   grade_9 * * * *   *     *   *   4 1 *                     5.0                         4 1                 5
1674759 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_9 * * * *   *     *   *   * * *                     0.0                                             0
1674960 MA Essex   school 2505970 128   Haverhill 250597002907 1280515 Haverhill - Crowell   Regular School No High 09 12 2021   grade_9 * * * *   *     *   *   2 * *                     3.0                         2                   3
1675668 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Lowell - Dr. Janice Adie Day School   Special Education School No Other PK 12 2021   grade_9 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
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
1679267 MA Worcester   school 2513080 343   Winchendon 251308002843 3430405 Winchendon - Murdock Academy for Success   Alternative School No High 09 12 2021   grade_9 * * * *   *     *   *   2 2 *                     4.0                         2 2                 4
1680453 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Bridgewater-Raynham - Therapeutic Day School   Special Education School No High 07 12 2021   grade_9 * * * *   *     *   *   2 * *                     4.0                         2                   4
1674892 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Hatfield - Smith Academy   Regular School No High 07 12 2021   grade_9 21 1 0 0   0     0   0   12 9 *                     22.0 21 1 0 0   0     0   0   12 9                 22
1675174 MA Plymouth   school 2506420 142   Hull 250642000930 1420505 Hull - Hull High   Regular School No High 09 12 2021   grade_9 56 1 0 0   1     0   1   28 31 *                     59.0 56 1 0 0   1     0   1   28 31                 59
1680229 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter (District) - Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2021   grade_9 19 4 0 0   3     0   5   12 19 *                     31.0 19 4 0 0   3     0   5   12 19                 31
1681429 MA Norfolk   school 2508650 915   Norfolk County Agricultural 250865001386 9150705 Norfolk County Agricultural - Norfolk County Agricultural   Career and Technical School No High 09 12 2021   grade_9 147 1 0 1   0     0   9   37 121 *                     158.0 147 1 0 1   0     0   9   37 121                 158
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
1674297 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett - Devens School   Regular School No Other KG 12 2021   grade_9 2 2 1 0   0     0   1   4 2 *                     6.0 2 2 1 0   0     0   1   4 2                 6
1677176 MA Plymouth   school 2509420 231   Pembroke 250942001824 2310505 Pembroke - Pembroke High School   Regular School No High 09 12 2021   grade_9 188 1 1 0   2     0   2   110 84 *                     194.0 188 1 1 0   2     0   2   110 84                 194
1677700 MA Barnstable   school 2510470 261   Sandwich 251047001673 2610505 Sandwich - Sandwich High   Regular School No High 09 12 2021   grade_9 144 0 1 0   2     0   3   71 78 *                     150.0 144 0 1 0   2     0   3   71 78                 150
1679741 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public (District) - Four Rivers Charter Public School   Regular School Yes High 07 12 2021   grade_9 31 1 1 0   0     0   2   17 18 *                     35.0 31 1 1 0   0     0   2   17 18                 35
1680779 MA Essex   school 2500067 698   Manchester Essex Regional 250006701109 6980510 Manchester Essex Regional - Manchester Essex Regional High School   Regular School No High 09 12 2021   grade_9 93 0 1 0   1     0   1   51 45 *                     96.0 93 0 1 0   1     0   1   51 45                 96
1681036 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley - Pioneer Valley Regional   Regular School No High 07 12 2021   grade_9 36 1 1 0   0     0   2   24 16 *                     40.0 36 1 1 0   0     0   2   24 16                 40
1681109 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Southern Berkshire - Mt Everett Regional   Regular School No High 06 12 2021   grade_9 32 0 1 0   0     0   2   13 22 *                     35.0 32 0 1 0   0     0   2   13 22                 35
1681389 MA Bristol   school 2509140 855   Old Colony Regional Vocational Technical 250914001471 8550605 Old Colony Regional Vocational Technical - Old Colony Regional Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 140 1 1 0   2     0   6   94 56 *                     150.0 140 1 1 0   2     0   6   94 56                 150
1672350 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown - Belchertown High   Regular School No High 09 12 2021   grade_9 154 4 10 0   2     1   3   69 104 *                     174.0 154 4 10 0   2     1   3   69 104                 174
1674194 MA Hampshire   school 2504590 86   Easthampton 250459000612 860505 Easthampton - Easthampton High   Regular School No High 09 12 2021   grade_9 77 2 10 0   5     0   3   41 56 *                     97.0 77 2 10 0   5     0   3   41 56                 97
1675194 MA Essex   school 2506480 144   Ipswich 250648000935 1440505 Ipswich - Ipswich High   Regular School No High 09 12 2021   grade_9 116 2 10 1   2     0   3   70 63 *                     134.0 116 2 10 1   2     0   3   70 63                 134
1675308 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence - School for Exceptional Studies   Regular School No Other KG 12 2021   grade_9 1 0 10 0   0     0   0   9 2 *                     11.0 1 0 10 0   0     0   0   9 2                 11
1676143 MA Norfolk   school 2507590 177   Medway 250759001184 1770505 Medway - Medway High   Regular School No High 09 12 2021   grade_9 120 5 10 2   4     0   2   69 74 *                     143.0 120 5 10 2   4     0   2   69 74                 143
1679826 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter (District) - Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2021   grade_9 105 0 10 0   20     0   11   80 65 *                     146.0 105 0 10 0   20     0   11   80 65                 146
1680409 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Berlin-Boylston - Tahanto Regional High   Regular School No High 06 12 2021   grade_9 66 1 10 0   7     0   1   45 40 *                     85.0 66 1 10 0   7     0   1   45 40                 85
1680931 MA Worcester   school 2508310 725   Nashoba 250831001289 7250505 Nashoba - Nashoba Regional   Regular School No High 09 12 2021   grade_9 190 2 10 0   13     0   8   113 110 *                     223.0 190 2 10 0   13     0   8   113 110                 223
1681405 MA Plymouth   school 2510930 873   South Shore Regional Vocational Technical 251093001756 8730605 South Shore Regional Vocational Technical - So Shore Vocational Technical High   Career and Technical School No High 09 12 2021   grade_9 154 4 10 0   0     0   0   103 65 *                     168.0 154 4 10 0   0     0   0   103 65                 168
1676272 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford - Milford High   Regular School No High 09 12 2021   grade_9 180 8 103 6   5     0   7   177 132 *                     309.0 180 8 103 6   5     0   7   177 132                 309
1680127 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter (District) - Roxbury Preparatory Charter School   Regular School Yes High 05 12 2021   grade_9 1 124 103 1   4     1   4   137 100 *                     238.0 1 124 103 1   4     1   4   137 100                 238
1673233 MA Suffolk   school 2502790 35   Boston 250279000205 350575 Boston - O'Bryant School Math/Science   Regular School No High 07 12 2021   grade_9 32 114 104 1   65     1   6   136 187 *                     323.0 32 114 104 1   65     1   6   136 187                 323
1673902 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee - Chicopee High   Regular School No High 09 12 2021   grade_9 87 4 104 0   8     0   8   98 113 *                     211.0 87 4 104 0   8     0   8   98 113                 211
1678001 MA Worcester   school 2511010 277   Southbridge 251101002868 2770515 Southbridge - Southbridge High School   Regular School No High 09 12 2021   grade_9 57 5 104 1   3     0   1   100 71 *                     171.0 57 5 104 1   3     0   1   100 71                 171
1674212 MA Hampden   school 2504500 87   East Longmeadow 250450000603 870505 East Longmeadow - East Longmeadow High   Regular School No High 09 12 2021   grade_9 171 7 11 0   9     0   5   98 105 *                     203.0 171 7 11 0   9     0   5   98 105                 203
1674992 MA Plymouth   school 2506090 131   Hingham 250609000872 1310505 Hingham - Hingham High   Regular School No High 09 12 2021   grade_9 272 7 11 0   5     0   11   161 144 *                     306.0 272 7 11 0   5     0   11   161 144                 306
1676911 MA Worcester   school 2508940 214   Northbridge 250894001445 2140505 Northbridge - Northbridge High   Regular School No High 09 12 2021   grade_9 110 3 11 0   1     0   9   65 69 *                     134.0 110 3 11 0   1     0   9   65 69                 134
1677568 MA Suffolk   school 2510050 248   Revere 251005001659 2480520 Revere - Seacoast School   Regular School No High 09 12 2021   grade_9 8 1 11 0   0     0   1   15 5 *                     21.0 8 1 11 0   0     0   1   15 5                 21
1678574 MA Middlesex   school 2511580 295   Tewksbury 251158001926 2950505 Tewksbury - Tewksbury Memorial High   Regular School No High 09 12 2021   grade_9 153 10 11 0   13     0   4   98 93 *                     191.0 153 10 11 0   13     0   4   98 93                 191
1679854 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge (District) - Community Charter School of Cambridge   Regular School Yes High 06 12 2021   grade_9 3 37 11 0   2     0   2   20 35 *                     55.0 3 37 11 0   2     0   2   20 35                 55
1680017 MA Middlesex   school 2500033 458   Lowell Middlesex Academy Charter (District) 250003300555 4580505 Lowell Middlesex Academy Charter (District) - Lowell Middlesex Academy Charter School   Regular School Yes High 09 12 2021   grade_9 11 0 11 0   0     0   1   8 15 *                     23.0 11 0 11 0   0     0   1   8 15                 23
1680374 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202738 6160505 Ayer Shirley School District - Ayer Shirley Regional High School   Regular School No High 09 12 2021   grade_9 75 2 11 1   5     2   3   54 45 *                     99.0 75 2 11 1   5     2   3   54 45                 99
1680790 MA Essex   school 2507410 705   Masconomet 250741001146 7050505 Masconomet - Masconomet Regional High School   Regular School No High 09 12 2021   grade_9 236 2 11 0   11     0   5   119 146 *                     265.0 236 2 11 0   11     0   5   119 146                 265
1680830 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional School District - Monomoy Regional High School   Regular School No High 08 12 2021   grade_9 88 8 11 0   1     0   4   57 55 *                     112.0 88 8 11 0   1     0   4   57 55                 112
1681151 MA Worcester   school 2511490 770   Tantasqua 251149001900 7700505 Tantasqua - Tantasqua Regional Sr High   Regular School No High 09 12 2021   grade_9 150 3 11 1   1     0   4   81 89 *                     170.0 150 3 11 1   1     0   4   81 89                 170
1681344 MA Franklin   school 2505020 818   Franklin County Regional Vocational Technical 250502000744 8180605 Franklin County Regional Vocational Technical - Franklin County Technical   Career and Technical School No High 09 12 2021   grade_9 152 1 11 1   0     4   2   89 82 *                     171.0 152 1 11 1   0     4   2   89 82                 171
1673906 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee - Chicopee Comprehensive High School   Regular School No High 09 12 2021   grade_9 179 8 110 0   6     0   17   177 143 *                     320.0 179 8 110 0   6     0   17   177 143                 320
1681515 MA Essex   school 2500590 3518   Phoenix Academy Public Charter High School Lawrence (District) 250059002886 35180505 Phoenix Academy Public Charter High School Lawrence (District) - Phoenix Academy Public Charter High School Lawrence   Regular School Yes High 09 12 2021   grade_9 8 0 112 0   0     0   0   77 42 *                     120.0 8 0 112 0   0     0   0   77 42                 120
1673738 MA Norfolk   school 2503300 50   Canton 250330000451 500505 Canton - Canton High   Regular School No High 09 12 2021   grade_9 133 33 12 0   24     0   11   99 113 *                     213.0 133 33 12 0   24     0   11   99 113                 213
1676301 MA Norfolk   school 2507920 187   Millis 250792001255 1870505 Millis - Millis High School   Regular School No High 09 12 2021   grade_9 71 2 12 0   5     0   6   51 45 *                     96.0 71 2 12 0   5     0   6   51 45                 96
1677436 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 Quincy - North Quincy High   Regular School No High 09 12 2021   grade_9 145 7 12 2   167     2   18   192 161 *                     353.0 145 7 12 2   167     2   18   192 161                 353
1679160 MA Norfolk   school 2512810 335   Westwood 251281002100 3350505 Westwood - Westwood High   Regular School No High 09 12 2021   grade_9 181 7 12 0   33     0   10   126 116 *                     243.0 181 7 12 0   33     0   10   126 116                 243
1679310 MA Middlesex   school 2513110 344   Winchester 251311002174 3440505 Winchester - Winchester High School   Regular School No High 09 12 2021   grade_9 251 6 12 2   57     0   16   158 185 *                     344.0 251 6 12 2   57     0   16   158 185                 344
1680331 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000069 6100505 Ashburnham-Westminster - Oakmont Regional High School   Regular School No High 09 12 2021   grade_9 146 4 12 1   2     0   1   90 76 *                     166.0 146 4 12 1   2     0   1   90 76                 166
1680585 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset - Nauset Regional High   Regular School No High 09 12 2021   grade_9 162 9 12 0   5     0   4   85 107 *                     192.0 162 9 12 0   5     0   4   85 107                 192
1681471 MA Hampden   school 2500555 3508   Phoenix Academy Public Charter High School Springfield (District) 250055502821 35080505 Phoenix Academy Public Charter High School Springfield (District) - Phoenix Academy Public Charter High School Springfield   Regular School Yes High 09 12 2021   grade_9 6 19 120 1   0     1   2   85 64 *                     149.0 6 19 120 1   0     1   2   85 64                 149
1675997 MA Middlesex   school 2507320 170   Marlborough 250732001133 1700505 Marlborough - Marlborough High   Regular School No High 09 12 2021   grade_9 68 7 121 0   2     0   9   113 94 *                     207.0 68 7 121 0   2     0   9   113 94                 207
1679656 MA Worcester   school 2513230 348   Worcester 251323002200 3480503 Worcester - Burncoat Senior High   Regular School No High 09 12 2021   grade_9 104 66 126 1   12     0   11   164 156 *                     320.0 104 66 126 1   12     0   11   164 156                 320
1675922 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden - Malden High   Regular School No High 09 12 2021   grade_9 110 81 127 0   103     0   13   228 205 *                     434.0 110 81 127 0   103     0   13   228 205                 434
1673020 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston - William McKinley   Regular School No Other KG 12 2021   grade_9 1 10 13 0   0     0   2   21 5 *                     26.0 1 10 13 0   0     0   2   21 5                 26
1674473 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth - Falmouth High   Regular School No High 09 12 2021   grade_9 158 15 13 0   2     0   11   102 97 *                     199.0 158 15 13 0   2     0   11   102 97                 199
1674782 MA Worcester   school 2505370 110   Grafton 250537000786 1100505 Grafton - Grafton High School   Regular School No High 09 12 2021   grade_9 163 7 13 2   22     1   5   101 112 *                     213.0 163 7 13 2   22     1   5   101 112                 213
1675340 MA Worcester   school 2506720 151   Leicester 250672000972 1510505 Leicester - Leicester High   Regular School No High 09 12 2021   grade_9 81 6 13 0   8     0   4   66 46 *                     112.0 81 6 13 0   8     0   4   66 46                 112
1678326 MA Hampden   school 2511130 281   Springfield 251113002724 2810570 Springfield - Springfield High School   Regular School No High 09 12 2021   grade_9 6 4 13 0   0     0   0   16 7 *                     23.0 6 4 13 0   0     0   0   16 7                 23
1680079 MA Worcester   school 2500073 474   Sizer School: A North Central Charter Essential (District) 250007301750 4740505 Sizer School: A North Central Charter Essential (District) - Sizer School: A North Central Charter Essential School   Regular School Yes High 07 12 2021   grade_9 46 7 13 1   1     0   1   39 30 *                     69.0 46 7 13 1   1     0   1   39 30                 69
1681453 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell (District) - Collegiate Charter School of Lowell   Regular School Yes Other KG 09 2021   grade_9 6 4 13 0   5     0   1   14 15 *                     29.0 6 4 13 0   5     0   1   14 15                 29
1681356 MA Bristol   school 2508440 825   Greater New Bedford Regional Vocational Technical 250844002266 8250605 Greater New Bedford Regional Vocational Technical - Gr New Bedford Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 349 43 131 4   7     1   32   306 261 *                     567.0 349 43 131 4   7     1   32   306 261                 567
1677679 MA Essex   school 2510380 258   Salem 251038001664 2580505 Salem - Salem High   Regular School No High 09 12 2021   grade_9 77 19 133 0   7     0   12   140 108 *                     248.0 77 19 133 0   7     0   12   140 108                 248
1675399 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Leominster - Center For Technical Education Innovation   Career and Technical School No High 09 12 2021   grade_9 118 25 135 0   13     0   7   172 126 *                     298.0 118 25 135 0   13     0   7   172 126                 298
1680196 MA Essex   school 2500090 493   Phoenix Charter Academy (District) 250009002112 4930505 Phoenix Charter Academy (District) - Phoenix Charter Academy   Regular School Yes High 09 12 2021   grade_9 8 16 135 3   0     0   0   80 82 *                     162.0 8 16 135 3   0     0   0   80 82                 162
1679661 MA Worcester   school 2513230 348   Worcester 251323002209 3480512 Worcester - Doherty Memorial High   Regular School No High 09 12 2021   grade_9 119 42 139 1   20     0   14   192 143 *                     335.0 119 42 139 1   20     0   14   192 143                 335
1672276 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn - Auburn Senior High   Regular School No High 09 12 2021   grade_9 136 3 14 0   9     0   6   84 84 *                     168.0 136 3 14 0   9     0   6   84 84                 168
1674443 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Fall River - Resiliency Preparatory Academy   Alternative School No High 07 12 2021   grade_9 10 6 14 0   0     0   3   22 11 *                     33.0 10 6 14 0   0     0   3   22 11                 33
1675030 MA Middlesex   school 2506240 136   Holliston 250624000894 1360505 Holliston - Holliston High   Regular School No High 09 12 2021   grade_9 159 1 14 1   16     0   3   94 100 *                     194.0 159 1 14 1   16     0   3   94 100                 194
1677066 MA Worcester   school 2509270 226   Oxford 250927001482 2260505 Oxford - Oxford High   Regular School No High 08 12 2021   grade_9 88 0 14 0   3     0   5   57 53 *                     110.0 88 0 14 0   3     0   5   57 53                 110
1680091 MA Hampshire   school 2500044 479   Pioneer Valley Performing Arts Charter Public (District) 250004400816 4790505 Pioneer Valley Performing Arts Charter Public (District) - Pioneer Valley Performing Arts Charter Public School   Regular School Yes High 07 12 2021   grade_9 40 7 14 0   0     0   7   27 41 *                     68.0 40 7 14 0   0     0   7   27 41                 68
1680751 MA Norfolk   school 2506510 690   King Philip 250651000940 6900505 King Philip - King Philip Regional High   Regular School No High 09 12 2021   grade_9 273 6 14 1   12     0   0   158 148 *                     306.0 273 6 14 1   12     0   0   158 148                 306
1681315 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman-Hanson - Whitman Hanson Regional   Regular School No High 09 12 2021   grade_9 206 10 14 0   3     0   7   126 114 *                     240.0 206 10 14 0   3     0   7   126 114                 240
1681477 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School (District) - Argosy Collegiate Charter School   Regular School Yes Secondary 06 11 2021   grade_9 34 10 14 1   1     0   5   42 23 *                     65.0 34 10 14 1   1     0   5   42 23                 65
1677959 MA Middlesex   school 2510890 274   Somerville 251089001745 2740505 Somerville - Somerville High   Regular School No High 09 12 2021   grade_9 125 38 140 0   23     0   6   172 159 *                     332.0 125 38 140 0   23     0   6   172 159                 332
1679676 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester - Worcester Technical High   Career and Technical School No High 09 12 2021   grade_9 101 80 148 0   29     0   11   160 209 *                     369.0 101 80 148 0   29     0   11   160 209                 369
1679720 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter (District) - Excel Academy Charter School   Regular School Yes High 05 12 2021   grade_9 16 10 148 1   4     1   1   96 85 *                     181.0 16 10 148 1   4     1   1   96 85                 181
1674437 MA Bristol   school 2504830 95   Fall River 250483000649 950505 Fall River - B M C Durfee High   Regular School No High 09 12 2021   grade_9 250 57 149 0   31     0   38   279 246 *                     525.0 250 57 149 0   31     0   38   279 246                 525
1672368 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham - Bellingham High School   Regular School No High 08 12 2021   grade_9 122 3 15 0   8     0   6   88 66 *                     154.0 122 3 15 0   8     0   6   88 66                 154
1673608 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington - Burlington High   Regular School No High 09 12 2021   grade_9 133 14 15 3   35     0   5   105 100 *                     205.0 133 14 15 3   35     0   5   105 100                 205
1676287 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury - Millbury Junior/Senior High   Regular School No High 07 12 2021   grade_9 88 3 15 0   5     0   8   62 57 *                     119.0 88 3 15 0   5     0   8   62 57                 119
1677819 MA Norfolk   school 2510620 266   Sharon 251062001705 2660505 Sharon - Sharon High   Regular School No High 09 12 2021   grade_9 155 14 15 1   78     0   14   150 127 *                     277.0 155 14 15 1   78     0   14   150 127                 277
1678364 MA Middlesex   school 2511220 284   Stoneham 251122002295 2840505 Stoneham - Stoneham High   Regular School No High 09 12 2021   grade_9 112 5 15 0   10     0   6   69 79 *                     148.0 112 5 15 0   10     0   6   69 79                 148
1678791 MA Plymouth   school 2512060 310   Wareham 251206001991 3100505 Wareham - Wareham Senior High   Regular School No High 08 12 2021   grade_9 78 11 15 4   0     0   23   67 64 *                     131.0 78 11 15 4   0     0   23   67 64                 131
1681088 MA Bristol   school 2500541 763   Somerset Berkley Regional School District 250054102728 7630505 Somerset Berkley Regional School District - Somerset Berkley Regional High School   Regular School No High 09 12 2021   grade_9 236 2 15 0   0     0   4   123 134 *                     257.0 236 2 15 0   0     0   4   123 134                 257
1681417 MA Barnstable   school 2511800 879   Upper Cape Cod Regional Vocational Technical 251180002296 8790605 Upper Cape Cod Regional Vocational Technical - Upper Cape Cod Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 164 4 15 2   1     0   18   112 92 *                     204.0 164 4 15 2   1     0   18   112 92                 204
1673174 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Boston - Madison Park High   Career and Technical School No High 09 12 2021   grade_9 5 123 157 1   7     0   7   174 126 *                     300.0 5 123 157 1   7     0   7   174 126                 300
1672018 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington - Abington High   Regular School No High 09 12 2021   grade_9 122 5 16 0   3     0   0   88 58 *                     146.0 122 5 16 0   3     0   0   88 58                 146
1672078 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury - Amesbury High   Regular School No High 09 12 2021   grade_9 105 6 16 0   1     0   4   61 71 *                     132.0 105 6 16 0   1     0   4   61 71                 132
1673237 MA Suffolk   school 2502790 35   Boston 250279001902 350581 Boston - Community Academy of Science and Health   Regular School No High 09 12 2021   grade_9 2 36 16 0   8     0   3   37 28 *                     65.0 2 36 16 0   8     0   3   37 28                 65
1674043 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth - Dartmouth High   Regular School No High 09 12 2021   grade_9 220 8 16 0   0     0   16   129 131 *                     260.0 220 8 16 0   0     0   16   129 131                 260

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