Data source: Big Local News · About: Big Local

396 rows where grade = "grade_9", state = "MA" and year = 2019 sorted by female

View and edit SQL

year

  • 2019 · 396

grade

  • grade_9 · 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
2041276 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Frederick Douglass Academy   Regular School No Secondary 07 11 2019   grade_9 * * * *   *     *   *   4 *                       4.0                         4                   4
2042773 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_9 * * * *   *     *   *   2 *                       2.0                         2                   2
2044888 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Project C.O.F.F.E.E.   Special Education School No High 09 12 2019   grade_9 * * * *   *     *   *   2 *                       2.0                         2                   2
2046137 MA Hampden   school 2511130 281   Springfield 251113002734 2810560 Liberty Preparatory Academy   Regular School No High 09 12 2019   grade_9 * * * *   *     *   *   2 *                       3.0                         2                   3
2042139 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2019   grade_9 2 0 4 0   0     0   1   6 1                       7.0 2 0 4 0   0     0   1   6 1                 7
2042746 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill Alternative School   Regular School No High 07 12 2019   grade_9 4 0 4 0   0     0   0   7 1                       8.0 4 0 4 0   0     0   0   7 1                 8
2043139 MA Essex   school 2506660 149   Lawrence 250666002628 1490536 High School Learning Center   Regular School No High 09 12 2019   grade_9 0 0 7 0   0     0   0   6 1                       7.0 0 0 7 0   0     0   0   6 1                 7
2043952 MA Middlesex   school 2507560 176   Medford 250756002393 1760510 Curtis-Tufts   Regular School No High 09 12 2019   grade_9 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2045509 MA Essex   school 2510380 258   Salem 251038002774 2580515 Salem Prep High School   Regular School No High 08 12 2019   grade_9 3 0 3 0   0     0   0   5 1                       6.0 3 0 3 0   0     0   0   5 1                 6
2046144 MA Hampden   school 2511130 281   Springfield 251113002743 2810575 Gateway to College at Holyoke Community College   Regular School No High 09 12 2019   grade_9 * * * *   *     *   *   * 1                       1.0                           1                 1
2046157 MA Hampden   school 2511130 281   Springfield 251113002884 2810700 Springfield International Academy at Sci-Tech   Regular School No Secondary 09 10 2019   grade_9 1 0 16 0   2     0   0   18 1                       19.0 1 0 16 0   2     0   0   18 1                 19
2048251 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No High 06 12 2019   grade_9 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2042280 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Resiliency Preparatory Academy   Alternative School No High 07 12 2019   grade_9 11 4 7 1   0     0   1   14 10                       24.0 11 4 7 1   0     0   1   14 10                 24
2044819 MA Plymouth   school 2509030 219   Norwell 250903001455 2190505 Norwell High   Regular School No High 09 12 2019   grade_9 146 2 5 0   4     0   2   59 100                       159.0 146 2 5 0   4     0   2   59 100                 159
2046219 MA Norfolk   school 2511250 285   Stoughton 251125001864 2850505 Stoughton High   Regular School No High 09 12 2019   grade_9 128 62 20 0   13     1   14   137 101                       238.0 128 62 20 0   13     1   14   137 101                 238
2048317 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2019   grade_9 127 22 27 3   3     0   11   92 101                       193.0 127 22 27 3   3     0   11   92 101                 193
2048786 MA Plymouth   school 2509150 740   Old Rochester 250915001472 7400505 Old Rochester Regional High   Regular School No High 09 12 2019   grade_9 186 4 4 0   2     0   10   105 101                       206.0 186 4 4 0   2     0   10   105 101                 206
2049241 MA Norfolk   school 2511735 878   Tri-County Regional Vocational Technical 251173501931 8780605 Tri-County Regional Vocational Technical   Career and Technical School No High 09 12 2019   grade_9 238 3 17 1   4     2   10   174 101                       275.0 238 3 17 1   4     2   10   174 101                 275
2046302 MA Essex   school 2511430 291   Swampscott 251143001887 2910505 Swampscott High   Regular School No High 09 12 2019   grade_9 139 9 26 0   7     0   2   80 103                       183.0 139 9 26 0   7     0   2   80 103                 183
2044623 MA Hampshire   school 2508850 210   Northampton 250885001432 2100505 Northampton High   Regular School No High 09 12 2019   grade_9 166 3 20 1   7     0   14   106 105                       211.0 166 3 20 1   7     0   14   106 105                 211
2048342 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000568 6500505 Dighton-Rehoboth Regional High School   Regular School No High 09 12 2019   grade_9 181 3 13 1   1     0   3   97 105                       202.0 181 3 13 1   1     0   3   97 105                 202
2048382 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No High 09 12 2019   grade_9 185 9 7 0   3     1   8   106 106                       213.0 185 9 7 0   3     1   8   106 106                 213
2042053 MA Hampden   school 2504500 87   East Longmeadow 250450000603 870505 East Longmeadow High   Regular School No High 09 12 2019   grade_9 174 7 17 0   15     0   1   107 107                       214.0 174 7 17 0   15     0   1   107 107                 214
2042581 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester High   Regular School No High 09 12 2019   grade_9 193 5 32 0   2     2   4   131 107                       238.0 193 5 32 0   2     2   4   131 107                 238
2045077 MA Berkshire   school 2509630 236   Pittsfield 250963001526 2360505 Pittsfield High   Regular School No High 09 12 2019   grade_9 153 20 21 0   2     0   15   103 108                       211.0 153 20 21 0   2     0   15   103 108                 211
2047067 MA Middlesex   school 2513050 342   Wilmington 251305002158 3420505 Wilmington High   Regular School No High 09 12 2019   grade_9 175 3 14 0   9     0   7   100 108                       208.0 175 3 14 0   9     0   7   100 108                 208
2047934 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2019   grade_9 3 132 87 0   0     1   2   116 109                       225.0 3 132 87 0   0     1   2   116 109                 225
2049154 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_9 140 47 31 0   4     0   15   128 109                       237.0 140 47 31 0   4     0   15   128 109                 237
2044069 MA Plymouth   school 2507770 182   Middleborough 250777001227 1820505 Middleborough High   Regular School No High 09 12 2019   grade_9 200 8 11 2   2     0   4   116 111                       227.0 200 8 11 2   2     0   4   116 111                 227
2047466 MA Worcester   school 2513230 348   Worcester 251323002200 3480503 Burncoat Senior High   Regular School No High 09 12 2019   grade_9 91 43 124 1   11     0   20   178 112                       290.0 91 43 124 1   11     0   20   178 112                 290
2048779 MA Middlesex   school 2508790 735   North Middlesex 250879001415 7350505 North Middlesex Regional   Regular School No High 09 12 2019   grade_9 179 2 13 0   3     1   7   93 112                       205.0 179 2 13 0   3     1   7   93 112                 205
2048976 MA Worcester   school 2511490 770   Tantasqua 251149001900 7700505 Tantasqua Regional Sr High   Regular School No High 09 12 2019   grade_9 158 2 6 0   4     0   8   66 112                       178.0 158 2 6 0   4     0   8   66 112                 178
2041446 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington High   Regular School No Other 09 12 2019   grade_9 140 19 15 2   30     0   11   103 114                       217.0 140 19 15 2   30     0   11   103 114                 217
2041974 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut Senior High   Regular School No High 09 12 2019   grade_9 165 27 18 0   19     0   6   120 115                       235.0 165 27 18 0   19     0   6   120 115                 235
2043817 MA Middlesex   school 2507320 170   Marlborough 250732001133 1700505 Marlborough High   Regular School No High 09 12 2019   grade_9 93 13 136 0   4     0   8   138 116                       254.0 93 13 136 0   4     0   8   138 116                 254
2049257 MA Norfolk   school 2508650 915   Norfolk County Agricultural 250865001386 9150705 Norfolk County Agricultural   Career and Technical School No High 09 12 2019   grade_9 136 2 5 0   2     1   8   38 116                       154.0 136 2 5 0   2     1   8   38 116                 154
2042309 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No High 09 12 2019   grade_9 185 15 10 5   5     0   20   123 117                       240.0 185 15 10 5   5     0   20   123 117                 240
2045007 MA Plymouth   school 2509420 231   Pembroke 250942001824 2310505 Pembroke High School   Regular School No High 09 12 2019   grade_9 197 0 2 0   5     0   4   91 117                       208.0 197 0 2 0   5     0   4   91 117                 208
2041989 MA Plymouth   school 2504410 82   Duxbury 250441000594 820505 Duxbury High   Regular School No High 09 12 2019   grade_9 219 0 4 1   3     0   9   118 118                       236.0 219 0 4 1   3     0   9   118 118                 236
2042866 MA Middlesex   school 2506240 136   Holliston 250624000894 1360505 Holliston High   Regular School No High 09 12 2019   grade_9 181 3 8 0   21     0   5   100 118                       218.0 181 3 8 0   21     0   5   100 118                 218
2043355 MA Hampden   school 2506990 159   Longmeadow 250699001020 1590505 Longmeadow High   Regular School No High 09 12 2019   grade_9 211 7 11 0   12     0   8   130 119                       249.0 211 7 11 0   12     0   8   130 119                 249
2047980 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public School   Regular School Yes High 09 12 2019   grade_9 198 6 16 1   2     0   0   104 119                       223.0 198 6 16 1   2     0   0   104 119                 223
2048119 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No High 09 12 2019   grade_9 150 16 29 0   20     1   15   112 119                       231.0 150 16 29 0   20     1   15   112 119                 231
2049146 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_9 208 8 70 2   3     0   9   181 119                       300.0 208 8 70 2   3     0   9   181 119                 300
2040826 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_9 1 25 25 0   2     0   3   44 12                       56.0 1 25 25 0   2     0   3   44 12                 56
2041321 MA Plymouth   school 2503090 44   Brockton 250309002752 440520 Edison Academy   Regular School No High 09 12 2019   grade_9 0 28 4 0   0     1   0   21 12                       33.0 0 28 4 0   0     1   0   21 12                 33
2045393 MA Suffolk   school 2510050 248   Revere 251005001659 2480520 Seacoast School   Regular School No High 09 12 2019   grade_9 12 2 18 0   0     0   2   22 12                       34.0 12 2 18 0   0     0   2   22 12                 34
2040017 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No High 09 12 2019   grade_9 156 7 24 1   28     0   8   103 121                       224.0 156 7 24 1   28     0   8   103 121                 224
2042351 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg High   Regular School No High 09 12 2019   grade_9 77 13 144 0   16     0   23   152 121                       273.0 77 13 144 0   16     0   23   152 121                 273
2043520 MA Hampden   school 2507050 161   Ludlow 250705001056 1610505 Ludlow Senior High   Regular School No High 09 12 2019   grade_9 214 8 24 0   2     0   8   134 121                       256.0 214 8 24 0   2     0   8   134 121                 256
2045153 MA Plymouth   school 2509720 239   Plymouth 250972000325 2390515 Plymouth South High   Regular School No High 09 12 2019   grade_9 242 4 7 0   1     0   8   141 121                       262.0 242 4 7 0   1     0   8   141 121                 262
2043677 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No High 06 12 2019   grade_9 39 19 186 4   18     0   9   152 122                       275.0 39 19 186 4   18     0   9   152 122                 275
2040952 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No High 09 12 2019   grade_9 12 54 175 0   7     0   4   128 124                       252.0 12 54 175 0   7     0   4   128 124                 252
2042604 MA Worcester   school 2505370 110   Grafton 250537000786 1100505 Grafton High School   Regular School No High 09 12 2019   grade_9 194 4 9 0   27     0   8   118 124                       242.0 194 4 9 0   27     0   8   118 124                 242
2040138 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No High 09 12 2019   grade_9 160 18 16 0   39     0   9   117 125                       242.0 160 18 16 0   39     0   9   117 125                 242
2040969 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No High 09 12 2019   grade_9 29 19 229 0   8     0   7   167 125                       292.0 29 19 229 0   8     0   7   167 125                 292
2044004 MA Middlesex   school 2507620 178   Melrose 250762001193 1780505 Melrose High   Regular School No High 09 12 2019   grade_9 195 11 7 0   13     0   14   115 125                       240.0 195 11 7 0   13     0   14   115 125                 240
2045082 MA Berkshire   school 2509630 236   Pittsfield 250963001534 2360510 Taconic High   Regular School No High 09 12 2019   grade_9 160 22 32 1   1     0   18   109 125                       234.0 160 22 32 1   1     0   18   109 125                 234
2048907 MA Plymouth   school 2510830 760   Silver Lake 251083001722 7600505 Silver Lake Regional High   Regular School No High 09 12 2019   grade_9 256 3 7 0   3     0   1   144 126                       270.0 256 3 7 0   3     0   1   144 126                 270
2048911 MA Bristol   school 2500541 763   Somerset Berkley Regional School District 250054102728 7630505 Somerset Berkley Regional High School   Regular School No High 09 12 2019   grade_9 239 1 9 1   1     1   1   127 126                       253.0 239 1 9 1   1     1   1   127 126                 253
2041748 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee Comprehensive High School   Regular School No High 09 12 2019   grade_9 191 5 72 0   6     0   6   152 128                       280.0 191 5 72 0   6     0   6   152 128                 280
2046398 MA Middlesex   school 2511580 295   Tewksbury 251158001926 2950505 Tewksbury Memorial High   Regular School No High 09 12 2019   grade_9 203 4 9 0   9     0   1   98 128                       226.0 203 4 9 0   9     0   1   98 128                 226
2039860 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2019   grade_9 219 7 21 1   6     0   11   136 129                       265.0 219 7 21 1   6     0   11   136 129                 265
2041316 MA Plymouth   school 2503090 44   Brockton 250309002652 440515 Brockton Champion High School   Alternative School No High 09 12 2019   grade_9 10 10 17 0   0     0   2   26 13                       39.0 10 10 17 0   0     0   2   26 13                 39
2046133 MA Hampden   school 2511130 281   Springfield 251113002742 2810550 Springfield Public Day High School   Regular School No High 09 12 2019   grade_9 6 7 28 0   0     0   0   28 13                       41.0 6 7 28 0   0     0   0   28 13                 41
2044095 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No High 09 12 2019   grade_9 177 9 84 1   6     0   10   157 130                       287.0 177 9 84 1   6     0   10   157 130                 287
2043784 MA Essex   school 2507260 168   Marblehead 250726001124 1680505 Marblehead High   Regular School No High 09 12 2019   grade_9 231 6 15 0   0     0   6   127 131                       258.0 231 6 15 0   0     0   6   127 131                 258
2044696 MA Bristol   school 2508730 212   North Attleborough 250873001405 2120505 North Attleboro High   Regular School No High 09 12 2019   grade_9 208 12 16 1   23     0   10   137 131                       270.0 208 12 16 1   23     0   10   137 131                 270
2044853 MA Norfolk   school 2509060 220   Norwood 250906001466 2200505 Norwood High   Regular School No High 09 12 2019   grade_9 174 24 38 0   13     1   5   124 131                       255.0 174 24 38 0   13     1   5   124 131                 255
2049237 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 2019   grade_9 270 4 27 1   3     0   4   177 132                       309.0 270 4 27 1   3     0   4   177 132                 309
2043762 MA Bristol   school 2507230 167   Mansfield 250723001114 1670505 Mansfield High   Regular School No High 09 12 2019   grade_9 229 10 10 0   14     0   11   141 133                       274.0 229 10 10 0   14     0   11   141 133                 274
2045595 MA Plymouth   school 2510560 264   Scituate 251056001693 2640505 Scituate High School   Regular School No High 09 12 2019   grade_9 238 12 0 0   5     0   3   122 135                       258.0 238 12 0 0   5     0   3   122 135                 258
2041576 MA Norfolk   school 2503300 50   Canton 250330000451 500505 Canton High   Regular School No High 09 12 2019   grade_9 169 28 18 0   28     0   5   112 136                       248.0 169 28 18 0   28     0   5   112 136                 248
2044159 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton High   Regular School No High 09 12 2019   grade_9 185 40 17 2   15     2   10   134 137                       271.0 185 40 17 2   15     2   10   134 137                 271
2045262 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No High 09 12 2019   grade_9 118 12 5 1   178     1   11   189 137                       326.0 118 12 5 1   178     1   11   189 137                 326
2046484 MA Middlesex   school 2511910 305   Wakefield 251191001951 3050505 Wakefield Memorial High   Regular School No High 09 12 2019   grade_9 208 10 14 1   9     0   4   109 137                       246.0 208 10 14 1   9     0   4   109 137                 246
2049158 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_9 304 10 22 4   2     0   17   221 138                       359.0 304 10 22 4   2     0   17   221 138                 359
2049225 MA Middlesex   school 2510615 871   Shawsheen Valley Regional Vocational Technical 251061501701 8710605 Shawsheen Valley Vocational Technical High School   Career and Technical School No High 09 12 2019   grade_9 302 3 18 1   6     0   9   201 138                       339.0 302 3 18 1   6     0   9   201 138                 339
2046941 MA Hampden   school 2512510 332   West Springfield 251251002052 3320505 West Springfield High   Regular School No High 09 12 2019   grade_9 203 13 75 1   22     0   6   181 139                       320.0 203 13 75 1   22     0   6   181 139                 320
2048374 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000591 6580505 Shepherd Hill Regional High   Regular School No High 09 12 2019   grade_9 247 4 30 0   3     0   4   148 140                       288.0 247 4 30 0   3     0   4   148 140                 288
2042076 MA Bristol   school 2504620 88   Easton 250462000623 880505 Oliver Ames High   Regular School No High 09 12 2019   grade_9 224 21 13 2   10     0   12   141 141                       282.0 224 21 13 2   10     0   12   141 141                 282
2043947 MA Middlesex   school 2507560 176   Medford 250756001176 1760505 Medford High   Regular School No High 09 12 2019   grade_9 182 42 37 0   37     0   16   173 141                       314.0 182 42 37 0   37     0   16   173 141                 314
2046980 MA Norfolk   school 2512810 335   Westwood 251281002100 3350505 Westwood High   Regular School No High 09 12 2019   grade_9 199 10 8 0   36     0   4   116 141                       257.0 199 10 8 0   36     0   4   116 141                 257
2041744 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee High   Regular School No High 09 12 2019   grade_9 142 13 124 0   4     0   5   145 143                       288.0 142 13 124 0   4     0   5   145 143                 288
2045336 MA Middlesex   school 2509990 246   Reading 250999001611 2460505 Reading Memorial High   Regular School No High 09 12 2019   grade_9 261 6 4 0   17     0   5   150 143                       293.0 261 6 4 0   17     0   5   150 143                 293
2046128 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield High School of Science and Technology   Regular School No High 09 12 2019   grade_9 36 51 278 1   7     0   3   233 143                       376.0 36 51 278 1   7     0   3   233 143                 376
2049141 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman Hanson Regional   Regular School No High 09 12 2019   grade_9 265 8 9 1   1     0   6   147 143                       290.0 265 8 9 1   1     0   6   147 143                 290
2049213 MA Middlesex   school 2508960 853   Northeast Metropolitan Regional Vocational Technical 250896002283 8530605 Northeast Metro Regional Vocational   Career and Technical School No High 09 12 2019   grade_9 177 12 127 1   5     0   8   187 143                       330.0 177 12 127 1   5     0   8   187 143                 330
2040304 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica Memorial High School   Regular School No High 09 12 2019   grade_9 242 20 9 1   26     0   6   159 145                       304.0 242 20 9 1   26     0   6   159 145                 304
2041884 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth High   Regular School No High 09 12 2019   grade_9 242 5 11 0   1     0   22   136 145                       281.0 242 5 11 0   1     0   22   136 145                 281
2046527 MA Norfolk   school 2511970 307   Walpole 251197001964 3070505 Walpole High   Regular School No High 09 12 2019   grade_9 228 9 12 2   19     0   8   133 145                       278.0 228 9 12 2   19     0   8   133 145                 278
2045643 MA Norfolk   school 2510620 266   Sharon 251062001705 2660505 Sharon High   Regular School No High 09 12 2019   grade_9 185 10 19 1   80     0   13   162 146                       308.0 185 10 19 1   80     0   13   162 146                 308
2048737 MA Worcester   school 2508310 725   Nashoba 250831001289 7250505 Nashoba Regional   Regular School No High 09 12 2019   grade_9 241 6 9 0   4     2   4   120 146                       266.0 241 6 9 0   4     2   4   120 146                 266
2041704 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No High 07 12 2019   grade_9 7 1 25 0   0     0   0   18 15                       33.0 7 1 25 0   0     0   0   18 15                 33
2041671 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No High 09 12 2019   grade_9 13 14 337 1   6     0   0   221 150                       371.0 13 14 337 1   6     0   0   221 150                 371
2043858 MA Plymouth   school 2507350 171   Marshfield 250735001142 1710505 Marshfield High   Regular School No High 09 12 2019   grade_9 320 1 9 0   2     0   7   189 150                       339.0 320 1 9 0   2     0   7   189 150                 339
2046829 MA Hampden   school 2512630 325   Westfield 251263002073 3250505 Westfield High   Regular School No High 09 12 2019   grade_9 237 7 47 0   9     0   5   155 150                       305.0 237 7 47 0   9     0   5   155 150                 305
2042969 MA Middlesex   school 2506330 139   Hopkinton 250633000920 1390505 Hopkinton High   Regular School No High 09 12 2019   grade_9 220 2 3 1   47     0   9   131 151                       282.0 220 2 3 1   47     0   9   131 151                 282
2043229 MA Worcester   school 2506780 153   Leominster 250678000987 1530505 Leominster High School   Regular School No High 09 12 2019   grade_9 119 19 58 1   10     0   5   61 151                       212.0 119 19 58 1   10     0   5   61 151                 212
2047476 MA Worcester   school 2513230 348   Worcester 251323002239 3480515 North High   Regular School No High 09 12 2019   grade_9 71 56 211 0   23     0   8   215 154                       369.0 71 56 211 0   23     0   8   215 154                 369

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