Data source: Big Local News · About: Big Local

401 rows where grade = "grade_10", state = "MA" and year = 2020 sorted by male

View and edit SQL

year

  • 2020 · 401

grade

  • grade_10 · 401
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
1368467 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_10 * * * *   *     *   *   * * *                     0.0                                             0
1374317 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_10 * * * *   *     *   *   * * *                     0.0                                             0
1366208 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Frederick Douglass Academy   Regular School No High 09 12 2020   grade_10 * * * *   *     *   *   1 2 *                     3.0                         1 2                 3
1367690 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_10 * * * *   *     *   *   1 * *                     1.0                         1                   1
1371069 MA Hampden   school 2511130 281   Springfield 251113002743 2810575 Gateway to College at Holyoke Community College   Regular School No High 10 12 2020   grade_10 * * * *   *     *   *   1 2 *                     3.0                         1 2                 3
1371382 MA Worcester   school 2511850 304   Uxbridge 251185002862 3040515 Gateway to College   Alternative School No High 10 12 2020   grade_10 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1364860 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2020   grade_10 11 0 1 0   0     0   1   10 3 *                     13.0 11 0 1 0   0     0   1   10 3                 13
1370222 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph High   Regular School No High 09 12 2020   grade_10 18 91 28 0   29     1   3   100 70 *                     170.0 18 91 28 0   29     1   3   100 70                 170
1364991 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No High 09 12 2020   grade_10 152 8 22 1   28     0   7   101 117 *                     218.0 152 8 22 1   28     0   7   101 117                 218
1370004 MA Berkshire   school 2509630 236   Pittsfield 250963001526 2360505 Pittsfield High   Regular School No High 09 12 2020   grade_10 137 21 17 0   4     0   10   101 88 *                     189.0 137 21 17 0   4     0   10   101 88                 189
1369551 MA Hampshire   school 2508850 210   Northampton 250885001432 2100505 Northampton High   Regular School No High 09 12 2020   grade_10 167 2 19 1   8     0   13   103 107 *                     210.0 167 2 19 1   8     0   13   103 107                 210
1371595 MA Middlesex   school 2512210 315   Wayland 251221002010 3150505 Wayland High School   Regular School No High 09 12 2020   grade_10 126 8 8 0   43     1   12   103 95 *                     198.0 126 8 8 0   43     1   12   103 95                 198
1373727 MA Plymouth   school 2509150 740   Old Rochester 250915001472 7400505 Old Rochester Regional High   Regular School No High 09 12 2020   grade_10 182 4 4 0   2     0   9   103 98 *                     201.0 182 4 4 0   2     0   9   103 98                 201
1367613 MA Plymouth   school 2505790 122   Hanover 250579000829 1220505 Hanover High   Regular School No High 09 12 2020   grade_10 184 1 2 0   4     0   0   104 87 *                     191.0 184 1 2 0   4     0   0   104 87                 191
1370009 MA Berkshire   school 2509630 236   Pittsfield 250963001534 2360510 Taconic High   Regular School No High 09 12 2020   grade_10 145 27 34 1   1     0   17   104 121 *                     225.0 145 27 34 1   1     0   17   104 121                 225
1374089 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_10 105 16 25 1   0     0   11   104 54 *                     158.0 105 16 25 1   0     0   11   104 54                 158
1368838 MA Norfolk   school 2507530 175   Medfield 250753001157 1750505 Medfield Senior High   Regular School No High 09 12 2020   grade_10 177 1 4 0   9     0   7   105 93 *                     198.0 177 1 4 0   9     0   7   105 93                 198
1373758 MA Essex   school 2509450 745   Pentucket 250945001513 7450505 Pentucket Regional Sr High   Regular School No High 09 12 2020   grade_10 174 0 9 0   5     0   3   105 86 *                     191.0 174 0 9 0   5     0   3   105 86                 191
1365909 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No High 09 12 2020   grade_10 3 63 115 1   15     0   2   106 93 *                     199.0 3 63 115 1   15     0   2   106 93                 199
1367240 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No High 09 12 2020   grade_10 165 9 13 2   6     0   16   106 104 *                     211.0 165 9 13 2   6     0   16   106 104                 211
1368438 MA Hampden   school 2507050 161   Ludlow 250705001056 1610505 Ludlow Senior High   Regular School No High 09 12 2020   grade_10 193 6 13 0   2     0   8   106 115 *                     222.0 193 6 13 0   2     0   8   106 115                 222
1366906 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut Senior High   Regular School No High 09 12 2020   grade_10 155 27 16 1   17     0   6   107 115 *                     222.0 155 27 16 1   17     0   6   107 115                 222
1367510 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester High   Regular School No High 09 12 2020   grade_10 174 4 24 0   2     0   4   107 101 *                     208.0 174 4 24 0   2     0   4   107 101                 208
1367320 MA Norfolk   school 2504950 99   Foxborough 250495000708 990505 Foxborough High   Regular School No High 09 12 2020   grade_10 159 12 18 2   7     0   2   108 92 *                     200.0 159 12 18 2   7     0   2   108 92                 200
1366983 MA Hampden   school 2504500 87   East Longmeadow 250450000603 870505 East Longmeadow High   Regular School No High 09 12 2020   grade_10 173 7 13 0   16     0   1   109 101 *                     210.0 173 7 13 0   16     0   1   109 101                 210
1366054 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston Collaborative High School   Alternative School No High 09 12 2020   grade_10 2 2 9 0   1     0   1   11 4 *                     15.0 2 2 9 0   1     0   1   11 4                 15
1368055 MA Essex   school 2506660 149   Lawrence 250666002628 1490536 High School Learning Center   Regular School No High 09 12 2020   grade_10 0 0 19 0   0     0   0   11 8 *                     19.0 0 0 19 0   0     0   0   11 8                 19
1373786 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley Regional   Regular School No High 07 12 2020   grade_10 26 0 0 0   0     0   1   11 16 *                     27.0 26 0 0 0   0     0   1   11 16                 27
1370427 MA Essex   school 2510380 258   Salem 251038001664 2580505 Salem High   Regular School No High 09 12 2020   grade_10 67 9 89 1   8     0   19   110 83 *                     193.0 67 9 89 1   8     0   19   110 83                 193
1364835 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2020   grade_10 197 6 15 1   5     0   10   112 121 *                     234.0 197 6 15 1   5     0   10   112 121                 234
1366920 MA Plymouth   school 2504410 82   Duxbury 250441000594 820505 Duxbury High   Regular School No High 09 12 2020   grade_10 211 0 3 1   4     0   10   112 117 *                     229.0 211 0 3 1   4     0   10   112 117                 229
1373321 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No High 09 12 2020   grade_10 194 9 7 0   3     1   7   112 108 *                     221.0 194 9 7 0   3     1   7   112 108                 221
1366507 MA Norfolk   school 2503300 50   Canton 250330000451 500505 Canton High   Regular School No High 09 12 2020   grade_10 170 27 19 0   31     0   8   113 142 *                     255.0 170 27 19 0   31     0   8   113 142                 255
1368999 MA Plymouth   school 2507770 182   Middleborough 250777001227 1820505 Middleborough High   Regular School No High 09 12 2020   grade_10 196 7 9 1   2     0   4   113 106 *                     219.0 196 7 9 1   2     0   4   113 106                 219
1366377 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington High   Regular School No High 09 12 2020   grade_10 139 19 24 1   31     0   10   114 110 *                     224.0 139 19 24 1   31     0   10   114 110                 224
1368154 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Center For Technical Education Innovation   Career and Technical School No High 09 12 2020   grade_10 81 18 59 0   10     0   4   114 58 *                     172.0 81 18 59 0   10     0   4   114 58                 172
1371411 MA Middlesex   school 2511910 305   Wakefield 251191001951 3050505 Wakefield Memorial High   Regular School No High 09 12 2020   grade_10 208 10 16 1   11     0   4   114 136 *                     250.0 208 10 16 1   11     0   4   114 136                 250
1371906 MA Norfolk   school 2512810 335   Westwood 251281002100 3350505 Westwood High   Regular School No High 09 12 2020   grade_10 195 10 9 0   36     0   5   114 141 *                     255.0 195 10 9 0   36     0   5   114 141                 255
1374134 MA Middlesex   school 2508320 852   Nashoba Valley Regional Vocational Technical 250832001290 8520605 Nashoba Valley Technical High School   Career and Technical School No High 09 12 2020   grade_10 159 5 10 1   3     0   7   114 71 *                     185.0 159 5 10 1   3     0   7   114 71                 185
1366787 MA Essex   school 2503990 71   Danvers 250399000529 710505 Danvers High   Regular School No High 09 12 2020   grade_10 168 5 18 0   6     0   7   115 89 *                     204.0 168 5 18 0   6     0   7   115 89                 204
1373047 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No High 09 12 2020   grade_10 150 19 33 0   21     1   15   116 123 *                     239.0 150 19 33 0   21     1   15   116 123                 239
1374158 MA Plymouth   school 2510930 873   South Shore Regional Vocational Technical 251093001756 8730605 So Shore Vocational Technical High   Career and Technical School No High 09 12 2020   grade_10 148 0 10 0   3     0   6   118 49 *                     167.0 148 0 10 0   3     0   6   118 49                 167
1365113 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No High 09 12 2020   grade_10 151 20 17 0   39     0   9   119 117 *                     236.0 151 20 17 0   39     0   9   119 117                 236
1368934 MA Middlesex   school 2507620 178   Melrose 250762001193 1780505 Melrose High   Regular School No High 09 12 2020   grade_10 195 14 7 0   12     0   14   119 123 *                     242.0 195 14 7 0   12     0   14   119 123                 242
1374170 MA Barnstable   school 2511800 879   Upper Cape Cod Regional Vocational Technical 251180002296 8790605 Upper Cape Cod Vocational Technical   Career and Technical School No High 09 12 2020   grade_10 156 7 5 2   4     0   12   119 67 *                     186.0 156 7 5 2   4     0   12   119 67                 186
1369679 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield High   Regular School No High 07 12 2020   grade_10 27 0 3 0   0     0   2   12 20 *                     32.0 27 0 3 0   0     0   2   12 20                 32
1370754 MA Worcester   school 2511010 277   Southbridge 251101002896 2770525 Southbridge Academy   Alternative School No High 09 12 2020   grade_10 9 0 7 0   0     0   1   12 5 *                     17.0 9 0 7 0   0     0   1   12 5                 17
1365961 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No High 07 12 2020   grade_10 71 70 76 1   55     0   10   120 163 *                     283.0 71 70 76 1   55     0   10   120 163                 283
1368146 MA Worcester   school 2506780 153   Leominster 250678000987 1530505 Leominster High School   Regular School No High 09 12 2020   grade_10 149 23 103 1   9     0   14   122 177 *                     299.0 149 23 103 1   9     0   14   122 177                 299
1367533 MA Worcester   school 2505370 110   Grafton 250537000786 1100505 Grafton High School   Regular School No High 09 12 2020   grade_10 195 4 11 0   30     0   8   123 125 *                     248.0 195 4 11 0   30     0   8   123 125                 248
1370521 MA Plymouth   school 2510560 264   Scituate 251056001693 2640505 Scituate High School   Regular School No High 09 12 2020   grade_10 240 12 1 0   5     0   3   125 135 *                     261.0 240 12 1 0   5     0   3   125 135                 261
1374081 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_10 135 45 31 0   4     0   14   125 104 *                     229.0 135 45 31 0   4     0   14   125 104                 229
1373677 MA Worcester   school 2508310 725   Nashoba 250831001289 7250505 Nashoba Regional   Regular School No High 09 12 2020   grade_10 239 6 12 0   4     2   5   126 142 *                     268.0 239 6 12 0   4     2   5   126 142                 268
1368272 MA Hampden   school 2506990 159   Longmeadow 250699001020 1590505 Longmeadow High   Regular School No High 09 12 2020   grade_10 205 6 11 0   16     0   9   129 118 *                     247.0 205 6 11 0   16     0   9   129 118                 247
1368716 MA Essex   school 2507260 168   Marblehead 250726001124 1680505 Marblehead High   Regular School No High 09 12 2020   grade_10 230 5 16 0   1     0   6   129 129 *                     258.0 230 5 16 0   1     0   6   129 129                 258
1368416 MA Middlesex   school 2507020 160   Lowell 250702002860 1600515 The Career Academy   Regular School No High 09 12 2020   grade_10 7 1 8 0   1     0   0   13 4 *                     17.0 7 1 8 0   1     0   0   13 4                 17
1370321 MA Suffolk   school 2510050 248   Revere 251005001659 2480520 Seacoast School   Regular School No High 09 12 2020   grade_10 6 1 10 0   0     0   0   13 4 *                     17.0 6 1 10 0   0     0   0   13 4                 17
1369781 MA Norfolk   school 2509060 220   Norwood 250906001466 2200505 Norwood High   Regular School No High 09 12 2020   grade_10 174 27 40 0   13     1   5   130 130 *                     260.0 174 27 40 0   13     1   5   130 130                 260
1374303 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2020   grade_10 242 29 52 2   3     1   28   130 227 *                     357.0 242 29 52 2   3     1   28   130 227                 357
1373313 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000591 6580505 Shepherd Hill Regional High   Regular School No High 09 12 2020   grade_10 223 3 27 0   3     0   5   132 129 *                     261.0 223 3 27 0   3     0   5   132 129                 261
1365997 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No High 07 12 2020   grade_10 41 102 90 1   66     1   4   133 172 *                     305.0 41 102 90 1   66     1   4   133 172                 305
1373468 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000824 6800505 Minnechaug Regional High   Regular School No High 09 12 2020   grade_10 232 9 23 2   10     0   7   133 150 *                     283.0 232 9 23 2   10     0   7   133 150                 283
1373527 MA Essex   school 2507410 705   Masconomet 250741001146 7050505 Masconomet Regional High School   Regular School No High 09 12 2020   grade_10 259 2 11 0   13     1   6   134 158 *                     292.0 259 2 11 0   13     1   6   134 158                 292
1373841 MA Bristol   school 2500541 763   Somerset Berkley Regional School District 250054102728 7630505 Somerset Berkley Regional High School   Regular School No High 09 12 2020   grade_10 241 2 12 1   1     1   1   135 124 *                     259.0 241 2 12 1   1     1   1   135 124                 259
1371145 MA Norfolk   school 2511250 285   Stoughton 251125001864 2850505 Stoughton High   Regular School No High 09 12 2020   grade_10 128 65 22 0   14     1   10   136 104 *                     240.0 128 65 22 0   14     1   10   136 104                 240
1367890 MA Middlesex   school 2506330 139   Hopkinton 250633000920 1390505 Hopkinton High   Regular School No High 09 12 2020   grade_10 226 2 5 1   46     0   9   137 152 *                     289.0 226 2 5 1   46     0   9   137 152                 289
1370080 MA Plymouth   school 2509720 239   Plymouth 250972000325 2390515 Plymouth South High   Regular School No High 09 12 2020   grade_10 239 3 9 0   1     0   8   137 123 *                     260.0 239 3 9 0   1     0   8   137 123                 260
1374077 MA Worcester   school 2502710 805   Blackstone Valley Regional Vocational Technical 250271000191 8050605 Blackstone Valley   Career and Technical School No High 09 12 2020   grade_10 274 7 17 0   8     0   1   137 170 *                     307.0 274 7 17 0   8     0   1   137 170                 307
1374118 MA Middlesex   school 2511060 829   South Middlesex Regional Vocational Technical 251106002291 8290605 Joseph P Keefe Technical High School   Career and Technical School No High 09 12 2020   grade_10 95 9 100 6   2     0   8   137 83 *                     220.0 95 9 100 6   2     0   8   137 83                 220
1369088 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton High   Regular School No High 09 12 2020   grade_10 191 45 16 2   13     1   9   138 139 *                     277.0 191 45 16 2   13     1   9   138 139                 277
1371454 MA Norfolk   school 2511970 307   Walpole 251197001964 3070505 Walpole High   Regular School No High 09 12 2020   grade_10 230 9 15 1   20     0   9   138 146 *                     284.0 230 9 15 1   20     0   9   138 146                 284
1368748 MA Middlesex   school 2507320 170   Marlborough 250732001133 1700505 Marlborough High   Regular School No High 09 12 2020   grade_10 93 9 147 0   3     0   4   139 117 *                     256.0 93 9 147 0   3     0   4   139 117                 256
1367286 MA Worcester   school 2504890 97   Fitchburg 250489002110 970510 Goodrich Academy   Regular School No High 09 12 2020   grade_10 9 1 13 0   0     0   0   14 9 *                     23.0 9 1 13 0   0     0   0   14 9                 23
1367641 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No High 07 12 2020   grade_10 35 0 0 0   2     0   3   14 26 *                     40.0 35 0 0 0   2     0   3   14 26                 40
1368604 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No High 06 12 2020   grade_10 5 2 15 0   1     0   0   14 9 *                     23.0 5 2 15 0   1     0   0   14 9                 23
1374271 MA Hampden   school 2500588 3516   Hampden Charter School of Science West (District) 250058802888 35160305 Hampden Charter School of Science West   Regular School Yes Middle 06 10 2020   grade_10 12 5 8 0   1     0   2   14 14 *                     28.0 12 5 8 0   1     0   2   14 14                 28
1368697 MA Bristol   school 2507230 167   Mansfield 250723001114 1670505 Mansfield High   Regular School No High 09 12 2020   grade_10 223 15 10 0   14     0   14   140 136 *                     276.0 223 15 10 0   14     0   14   140 136                 276
1373233 MA Middlesex   school 2503870 640   Concord-Carlisle 250387000527 6400505 Concord Carlisle High   Regular School No High 09 12 2020   grade_10 247 14 18 1   23     0   22   140 184 *                     325.0 247 14 18 1   23     0   22   140 184                 325
1369624 MA Bristol   school 2508730 212   North Attleborough 250873001405 2120505 North Attleboro High   Regular School No High 09 12 2020   grade_10 213 13 15 1   23     0   9   141 132 *                     274.0 213 13 15 1   23     0   9   141 132                 274
1366675 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee High   Regular School No High 09 12 2020   grade_10 139 16 126 0   3     0   2   143 143 *                     286.0 139 16 126 0   3     0   2   143 143                 286
1367005 MA Bristol   school 2504620 88   Easton 250462000623 880505 Oliver Ames High   Regular School No High 09 12 2020   grade_10 220 24 13 2   10     0   14   143 140 *                     283.0 220 24 13 2   10     0   14   143 140                 283
1366815 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth High   Regular School No High 09 12 2020   grade_10 247 6 11 0   0     0   21   144 141 *                     285.0 247 6 11 0   0     0   21   144 141                 285
1371049 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 High School Of Commerce   Regular School No High 09 12 2020   grade_10 20 60 214 0   3     1   4   144 158 *                     302.0 20 60 214 0   3     1   4   144 158                 302
1373836 MA Plymouth   school 2510830 760   Silver Lake 251083001722 7600505 Silver Lake Regional High   Regular School No High 09 12 2020   grade_10 253 2 10 0   3     0   2   146 124 *                     270.0 253 2 10 0   3     0   2   146 124                 270
1371689 MA Worcester   school 2512600 321   Westborough 251260002059 3210505 Westborough High   Regular School No High 09 12 2020   grade_10 168 2 26 0   91     0   15   147 155 *                     302.0 168 2 26 0   91     0   15   147 155                 302
1374068 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman Hanson Regional   Regular School No High 09 12 2020   grade_10 264 8 10 1   1     0   6   148 142 *                     290.0 264 8 10 1   1     0   6   148 142                 290
1370264 MA Middlesex   school 2509990 246   Reading 250999001611 2460505 Reading Memorial High   Regular School No High 09 12 2020   grade_10 262 5 5 0   17     0   5   149 144 *                     294.0 262 5 5 0   17     0   5   149 144                 294
1372966 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2020   grade_10 26 3 3 0   5     0   5   15 27 *                     42.0 26 3 3 0   5     0   5   15 27                 42
1366679 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee Comprehensive High School   Regular School No High 09 12 2020   grade_10 183 6 70 0   4     0   7   150 120 *                     270.0 183 6 70 0   4     0   7   150 120                 270
1368612 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No Other PK 12 2020   grade_10 37 18 193 3   18     0   7   152 123 *                     276.0 37 18 193 3   18     0   7   152 123                 276
1365262 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica Memorial High School   Regular School No High 08 12 2020   grade_10 236 22 12 1   27     0   5   154 149 *                     303.0 236 22 12 1   27     0   5   154 149                 303
1371053 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield High School of Science and Technology   Regular School No High 09 12 2020   grade_10 28 44 196 1   4     0   2   154 121 *                     275.0 28 44 196 1   4     0   2   154 121                 275
1372394 MA Worcester   school 2513230 348   Worcester 251323002200 3480503 Burncoat Senior High   Regular School No High 09 12 2020   grade_10 82 45 111 0   10     0   16   156 108 *                     264.0 82 45 111 0   10     0   16   156 108                 264
1367282 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg High   Regular School No High 09 12 2020   grade_10 78 18 138 0   18     0   25   157 120 *                     277.0 78 18 138 0   18     0   25   157 120                 277
1370569 MA Norfolk   school 2510620 266   Sharon 251062001705 2660505 Sharon High   Regular School No High 09 12 2020   grade_10 178 13 16 1   80     0   15   157 145 *                     303.0 178 13 16 1   80     0   15   157 145                 303
1371756 MA Hampden   school 2512630 325   Westfield 251263002073 3250505 Westfield High   Regular School No High 09 12 2020   grade_10 226 7 49 0   8     0   8   157 141 *                     298.0 226 7 49 0   8     0   8   157 141                 298
1370709 MA Middlesex   school 2510890 274   Somerville 251089001745 2740505 Somerville High   Regular School No High 09 12 2020   grade_10 94 39 158 0   17     1   10   158 161 *                     319.0 94 39 158 0   17     1   10   158 161                 319
1373690 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Algonquin Regional High   Regular School No High 09 12 2020   grade_10 262 4 16 1   39     1   11   159 175 *                     334.0 262 4 16 1   39     1   11   159 175                 334
1371035 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Conservatory of the Arts   Regular School No High 06 12 2020   grade_10 6 6 37 0   0     0   0   16 33 *                     49.0 6 6 37 0   0     0   0   16 33                 49
1371058 MA Hampden   school 2511130 281   Springfield 251113002742 2810550 Springfield Public Day High School   Regular School No High 09 12 2020   grade_10 3 2 16 0   0     0   0   16 5 *                     21.0 3 2 16 0   0     0   0   16 5                 21

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