enrollments

Data source: Big Local News · About: Big Local

392 rows where grade = "grade_9", state = "MA" and year = 2017 sorted by hispanic

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 392 ✖

grade ✖

  • grade_9 · 392 ✖
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
1122639 1122639 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No High 07 12 2017   grade_9 * * * *   *     *   *   1 1                       *                         1 1                  
1123285 1123285 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Community Academy   Regular School No High 09 12 2017   grade_9 * * * *   *     *   *   2 *                       *                         2                    
1123330 1123330 MA Suffolk   school 2502790 35   Boston 250279000837 350543 Greater Egleston Community High School   Regular School No High 09 12 2017   grade_9 * * * *   *     *   *   1 1                       *                         1 1                  
1123456 1123456 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston Collaborative High School   Alternative School No High 07 12 2017   grade_9 * * * *   *     *   *   2 2                       *                         2 2                  
1125195 1125195 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_9 * * * *   *     *   *   * *                       *                                              
1125269 1125269 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_9 * * * *   *     *   *   * *                       *                                              
1127949 1127949 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Project C.O.F.F.E.E.   Special Education School No Other 05 12 2017   grade_9 * * * *   *     *   *   3 *                       *                         3                    
1128679 1128679 MA Essex   school 2510380 258   Salem 251038002864 2580510 New Liberty Innovation School   Regular School No High 09 12 2017   grade_9 * * * *   *     *   *   1 1                       *                         1 1                  
1128685 1128685 MA Essex   school 2510380 258   Salem 251038002774 2580515 Salem Prep High School   Regular School No High 08 12 2017   grade_9 * * * *   *     *   *   1 *                       *                         1                    
1129420 1129420 MA Hampden   school 2511130 281   Springfield 251113002734 2810560 Liberty Preparatory Academy   Regular School No High 09 12 2017   grade_9 * * * *   *     *   *   2 *                       *                         2                    
1129429 1129429 MA Hampden   school 2511130 281   Springfield 251113002743 2810575 Gateway to College at Holyoke Community College   Regular School No High 09 12 2017   grade_9 * * * *   *     *   *   2 2                       *                         2 2                  
1129707 1129707 MA Bristol   school 2511520 293   Taunton 251152002778 2930525 Taunton Alternative High School   Alternative School No High 08 12 2017   grade_9 * * * *   *     *   *   2 1                       *                         2 1                  
1131458 1131458 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2017   grade_9 * * * *   *     *   *   1 2                       *                         1 2                  
1131925 1131925 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No Other 05 12 2017   grade_9 * * * *   *     *   *   1 *                       *                         1                    
1122040 1122040 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2017   grade_9 7 0 0 0   0     0   0   4 3                       7 7 0 0 0   0     0   0   4 3                 7
1123670 1123670 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative School No Other 05 12 2017   grade_9 3 3 0 0   0     0   0   5 1                       6 3 3 0 0   0     0   0   5 1                 6
1124029 1124029 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No Other 06 12 2017   grade_9 112 2 0 0   0     0   0   58 56                       114 112 2 0 0   0     0   0   58 56                 114
1127866 1127866 MA Plymouth   school 2509030 219   Norwell 250903001455 2190505 Norwell High   Regular School No High 09 12 2017   grade_9 174 2 0 0   6     1   3   87 99                       186 174 2 0 0   6     1   3   87 99                 186
1128086 1128086 MA Plymouth   school 2509420 231   Pembroke 250942001824 2310505 Pembroke High School   Regular School No High 09 12 2017   grade_9 199 2 0 0   4     1   1   99 108                       207 199 2 0 0   4     1   1   99 108                 207
1128791 1128791 MA Plymouth   school 2510560 264   Scituate 251056001693 2640505 Scituate High School   Regular School No High 09 12 2017   grade_9 206 10 0 0   4     0   6   117 109                       226 206 10 0 0   4     0   6   117 109                 226
1130586 1130586 MA Worcester   school 2513080 343   Winchendon 251308002843 3430405 Murdock Academy for Success   Alternative School No Other 06 12 2017   grade_9 6 0 0 0   0     0   1   5 2                       7 6 0 0 0   0     0   1   5 2                 7
1125707 1125707 MA Plymouth   school 2506420 142   Hull 250642000930 1420505 Hull High   Regular School No High 09 12 2017   grade_9 67 1 1 0   1     0   1   37 34                       71 67 1 1 0   1     0   1   37 34                 71
1125993 1125993 MA Worcester   school 2506780 153   Leominster 250678002779 1530515 Leominster Center for Excellence   Regular School No High 09 12 2017   grade_9 7 0 1 0   0     0   1   4 5                       9 7 0 1 0   0     0   1   4 5                 9
1126105 1126105 MA Middlesex   school 2506960 158   Littleton 250696001012 1580505 Littleton High School   Regular School No High 09 12 2017   grade_9 111 0 1 0   7     1   4   53 71                       124 111 0 1 0   7     1   4   53 71                 124
1126342 1126342 MA Worcester   school 2507080 162   Lunenburg 250708001058 1620505 Lunenburg High   Regular School No High 09 12 2017   grade_9 97 5 1 0   6     0   3   55 57                       112 97 5 1 0   6     0   3   55 57                 112
1126536 1126536 MA Essex   school 2507140 164   Lynnfield 250714001090 1640505 Lynnfield High   Regular School No High 09 12 2017   grade_9 130 7 1 0   5     0   3   73 73                       146 130 7 1 0   5     0   3   73 73                 146
1127106 1127106 MA Hampden   school 2508040 191   Monson 250804001269 1910505 Monson High School   Regular School No High 09 12 2017   grade_9 59 0 1 0   0     1   2   29 34                       63 59 0 1 0   0     1   2   29 34                 63
1127787 1127787 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield High   Regular School No High 07 12 2017   grade_9 37 0 1 0   2     0   1   18 23                       41 37 0 1 0   2     0   1   18 23                 41
1128607 1128607 MA Essex   school 2510200 252   Rockport 251020002597 2520510 Rockport High   Regular School No High 09 12 2017   grade_9 65 2 1 0   1     0   0   32 37                       69 65 2 1 0   1     0   0   32 37                 69
1129585 1129585 MA Worcester   school 2511400 290   Sutton 251140001414 2900510 Sutton High School   Regular School No High 09 12 2017   grade_9 98 0 1 0   0     0   4   46 57                       103 98 0 1 0   0     0   4   46 57                 103
1131666 1131666 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 2017   grade_9 9 1 1 0   2     0   1   2 12                       14 9 1 1 0   2     0   1   2 12                 14
1132081 1132081 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No High 09 12 2017   grade_9 185 13 1 1   8     0   11   100 119                       219 185 13 1 1   8     0   11   100 119                 219
1132169 1132169 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000807 6730505 Groton Dunstable Regional   Regular School No High 09 12 2017   grade_9 169 1 1 0   10     1   0   86 96                       182 169 1 1 0   10     1   0   86 96                 182
1132616 1132616 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley Regional   Regular School No High 07 12 2017   grade_9 43 0 1 0   0     0   0   13 31                       44 43 0 1 0   0     0   0   13 31                 44
1132684 1132684 MA Plymouth   school 2510830 760   Silver Lake 251083001722 7600505 Silver Lake Regional High   Regular School No High 09 12 2017   grade_9 300 10 1 0   4     1   3   172 147                       319 300 10 1 0   4     1   3   172 147                 319
1133057 1133057 MA Bristol   school 2509140 855   Old Colony Regional Vocational Technical 250914001471 8550605 Old Colony Regional Vocational Technical   Career and Technical School No High 09 12 2017   grade_9 141 4 1 0   2     0   3   104 47                       151 141 4 1 0   2     0   3   104 47                 151
1123392 1123392 MA Suffolk   school 2502790 35   Boston 250279002676 350651 Dorchester Academy   Regular School No High 09 12 2017   grade_9 0 29 10 0   0     0   1   23 17                       40 0 29 10 0   0     0   1   23 17                 40
1124469 1124469 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut Senior High   Regular School No High 09 12 2017   grade_9 174 20 10 0   11     0   5   116 104                       220 174 20 10 0   11     0   5   116 104                 220
1124563 1124563 MA Hampden   school 2504500 87   East Longmeadow 250450000603 870505 East Longmeadow High   Regular School No High 09 12 2017   grade_9 191 6 10 1   15     0   3   114 112                       226 191 6 10 1   15     0   3   114 112                 226
1125223 1125223 MA Worcester   school 2505370 110   Grafton 250537000786 1100505 Grafton High School   Regular School No High 09 12 2017   grade_9 180 2 10 0   24     0   5   117 104                       221 180 2 10 0   24     0   5   117 104                 221
1125925 1125925 MA Worcester   school 2506720 151   Leicester 250672000972 1510505 Leicester High   Regular School No High 09 12 2017   grade_9 103 5 10 1   3     1   4   68 59                       127 103 5 10 1   3     1   4   68 59                 127
1127395 1127395 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No Other 06 12 2017   grade_9 9 6 10 0   1     0   0   21 5                       26 9 6 10 0   1     0   0   21 5                 26
1129733 1129733 MA Middlesex   school 2511580 295   Tewksbury 251158001926 2950505 Tewksbury Memorial High   Regular School No High 09 12 2017   grade_9 218 3 10 0   10     1   1   142 101                       243 218 3 10 0   10     1   1   142 101                 243
1129837 1129837 MA Middlesex   school 2511910 305   Wakefield 251191001951 3050505 Wakefield Memorial High   Regular School No High 09 12 2017   grade_9 234 11 10 0   9     0   8   127 145                       272 234 11 10 0   9     0   8   127 145                 272
1130179 1130179 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston Junior/Senior High   Regular School No Other 06 12 2017   grade_9 51 1 10 0   0     0   3   35 30                       65 51 1 10 0   0     0   3   35 30                 65
1130591 1130591 MA Middlesex   school 2513080 343   Winchendon 251308002786 3430515 Murdock High School   Regular School No High 09 12 2017   grade_9 59 0 10 0   6     0   3   43 35                       78 59 0 10 0   6     0   3   43 35                 78
1133062 1133062 MA Hampden   school 2509310 860   Pathfinder Regional Vocational Technical 250931002285 8600605 Pathfinder Vocational Technical   Career and Technical School No High 09 12 2017   grade_9 157 3 10 0   2     0   5   106 71                       177 157 3 10 0   2     0   5   106 71                 177
1125998 1125998 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Center For Technical Education Innovation   Career and Technical School No High 09 12 2017   grade_9 136 27 100 0   5     2   10   162 118                       280 136 27 100 0   5     2   10   162 118                 280
1124202 1124202 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee Comprehensive High School   Regular School No High 09 12 2017   grade_9 222 7 101 0   6     0   7   179 164                       343 222 7 101 0   6     0   7   179 164                 343
1123270 1123270 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Brighton High   Regular School No High 09 12 2017   grade_9 13 84 102 0   4     0   0   137 66                       203 13 84 102 0   4     0   0   137 66                 203
1128674 1128674 MA Essex   school 2510380 258   Salem 251038001664 2580505 Salem High   Regular School No High 09 12 2017   grade_9 109 19 103 0   3     0   7   123 118                       241 109 19 103 0   3     0   7   123 118                 241
1124197 1124197 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee High   Regular School No High 09 12 2017   grade_9 121 7 105 0   2     0   1   128 108                       236 121 7 105 0   2     0   1   128 108                 236
1124708 1124708 MA Bristol   school 2504800 94   Fairhaven 250480000642 940505 Fairhaven High   Regular School No High 09 12 2017   grade_9 155 0 11 0   2     0   2   76 94                       170 155 0 11 0   2     0   2   76 94                 170
1124862 1124862 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No High 09 12 2017   grade_9 195 11 11 2   9     0   12   113 127                       240 195 11 11 2   9     0   12   113 127                 240
1125886 1125886 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_9 4 0 11 0   0     0   0   11 4                       15 4 0 11 0   0     0   0   11 4                 15
1126305 1126305 MA Middlesex   school 2507020 160   Lowell 250702002860 1600515 The Career Academy   Regular School No High 09 12 2017   grade_9 3 0 11 0   3     0   3   16 4                       20 3 0 11 0   3     0   3   16 4                 20
1126612 1126612 MA Bristol   school 2507230 167   Mansfield 250723001114 1670505 Mansfield High   Regular School No High 09 12 2017   grade_9 278 8 11 0   14     0   8   169 150                       319 278 8 11 0   14     0   8   169 150                 319
1127032 1127032 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No High 07 12 2017   grade_9 106 2 11 0   0     0   1   51 69                       120 106 2 11 0   0     0   1   51 69                 120
1131129 1131129 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes Other 05 12 2017   grade_9 5 45 11 0   1     0   2   35 29                       64 5 45 11 0   1     0   2   35 29                 64
1131274 1131274 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2017   grade_9 1 33 11 1   0     0   0   26 20                       46 1 33 11 1   0     0   0   26 20                 46
1131622 1131622 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 11 2017   grade_9 42 7 11 1   0     0   1   23 39                       62 42 7 11 1   0     0   1   23 39                 62
1131843 1131843 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202738 6160505 Ayer Shirley Regional High School   Regular School No High 09 12 2017   grade_9 80 9 11 1   3     0   4   55 53                       108 80 9 11 1   3     0   4   55 53                 108
1132032 1132032 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000568 6500505 Dighton-Rehoboth Regional High School   Regular School No High 09 12 2017   grade_9 172 2 11 0   5     0   1   103 88                       191 172 2 11 0   5     0   1   103 88                 191
1132689 1132689 MA Bristol   school 2500541 763   Somerset Berkley Regional School District 250054102728 7630505 Somerset Berkley Regional High School   Regular School No High 09 12 2017   grade_9 251 5 11 0   0     0   11   145 133                       278 251 5 11 0   0     0   11   145 133                 278
1132977 1132977 MA Worcester   school 2502710 805   Blackstone Valley Regional Vocational Technical 250271000191 8050605 Blackstone Valley   Career and Technical School No High 09 12 2017   grade_9 295 1 11 0   1     0   4   146 166                       312 295 1 11 0   1     0   4   146 166                 312
1133047 1133047 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 2017   grade_9 158 1 11 2   1     0   4   106 71                       177 158 1 11 2   1     0   4   106 71                 177
1126680 1126680 MA Middlesex   school 2507320 170   Marlborough 250732001133 1700505 Marlborough High   Regular School No High 09 12 2017   grade_9 108 8 116 1   12     0   3   121 127                       248 108 8 116 1   12     0   3   121 127                 248
1131065 1131065 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester Technical High   Career and Technical School No High 09 12 2017   grade_9 130 72 118 0   28     0   11   142 217                       359 130 72 118 0   28     0   11   142 217                 359
1124070 1124070 MA Middlesex   school 2503510 56   Chelmsford 250351000475 560505 Chelmsford High   Regular School No High 09 12 2017   grade_9 287 10 12 0   57     1   5   170 202                       372 287 10 12 0   57     1   5   170 202                 372
1125490 1125490 MA Plymouth   school 2506090 131   Hingham 250609000872 1310505 Hingham High   Regular School No High 09 12 2017   grade_9 284 0 12 0   9     0   10   166 149                       315 284 0 12 0   9     0   10   166 149                 315
1127771 1127771 MA Worcester   school 2508940 214   Northbridge 250894001445 2140505 Northbridge High   Regular School No High 09 12 2017   grade_9 123 0 12 0   1     0   5   79 62                       141 123 0 12 0   1     0   5   79 62                 141
1128387 1128387 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No High 09 12 2017   grade_9 85 6 12 0   167     0   2   132 140                       272 85 6 12 0   167     0   2   132 140                 272
1131430 1131430 MA Middlesex   school 2500033 458   Lowell Middlesex Academy Charter (District) 250003300555 4580505 Lowell Middlesex Academy Charter School   Regular School Yes High 09 12 2017   grade_9 8 0 12 0   5     0   1   15 11                       26 8 0 12 0   5     0   1   15 11                 26
1131518 1131518 MA Hampshire   school 2500044 479   Pioneer Valley Performing Arts Charter Public (District) 250004400816 4790505 Pioneer Valley Performing Arts Charter Public School   Regular School Yes High 07 12 2017   grade_9 44 7 12 0   3     0   3   23 46                       69 44 7 12 0   3     0   3   23 46                 69
1131652 1131652 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes Other 05 12 2017   grade_9 26 2 12 0   0     0   1   19 22                       41 26 2 12 0   0     0   1   19 22                 41
1131737 1131737 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2017   grade_9 270 9 12 1   138     0   18   224 224                       448 270 9 12 1   138     0   18   224 224                 448
1132531 1132531 MA Middlesex   school 2508790 735   North Middlesex 250879001415 7350505 North Middlesex Regional   Regular School No High 09 12 2017   grade_9 185 3 12 0   2     0   6   103 105                       208 185 3 12 0   2     0   6   103 105                 208
1133087 1133087 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 2017   grade_9 250 3 12 2   2     1   14   148 136                       284 250 3 12 2   2     1   14   148 136                 284
1133149 1133149 MA Middlesex   school 2500546 3506   Pioneer Charter School of Science II (PCSS-II) (District) 250054602780 35060505 Pioneer Charter School of Science II (PCSS-II)   Regular School Yes High 07 12 2017   grade_9 21 27 12 0   9     0   1   33 37                       70 21 27 12 0   9     0   1   33 37                 70
1126593 1126593 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No High 09 12 2017   grade_9 137 98 121 2   100     0   15   257 216                       473 137 98 121 2   100     0   15   257 216                 473
1125032 1125032 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham High School   Regular School No High 09 12 2017   grade_9 334 26 127 0   26     1   22   272 264                       536 334 26 127 0   26     1   22   272 264                 536
1130163 1130163 MA Worcester   school 2512600 321   Westborough 251260002059 3210505 Westborough High   Regular School No High 09 12 2017   grade_9 176 5 13 0   66     0   6   137 129                       266 176 5 13 0   66     0   6   137 129                 266
1124909 1124909 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg High   Regular School No High 09 12 2017   grade_9 92 18 132 0   16     0   22   156 124                       280 92 18 132 0   16     0   22   156 124                 280
1123310 1123310 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Career and Technical School No High 09 12 2017   grade_9 2 74 138 1   0     0   7   130 92                       222 2 74 138 1   0     0   7   130 92                 222
1122011 1122011 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2017   grade_9 272 3 14 0   6     0   4   151 148                       299 272 3 14 0   6     0   4   151 148                 299
1122386 1122386 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No High 08 12 2017   grade_9 123 2 14 1   6     0   3   68 81                       149 123 2 14 1   6     0   3   68 81                 149
1123704 1123704 MA Plymouth   school 2503090 44   Brockton 250309002652 440515 Brockton Champion High School   Regular School No High 09 12 2017   grade_9 12 19 14 0   0     0   2   28 19                       47 12 19 14 0   0     0   2   28 19                 47
1124591 1124591 MA Bristol   school 2504620 88   Easton 250462000623 880505 Oliver Ames High   Regular School No High 09 12 2017   grade_9 227 13 14 1   6     0   6   132 135                       267 227 13 14 1   6     0   6   132 135                 267
1125690 1125690 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson High   Regular School No High 08 12 2017   grade_9 176 4 14 0   2     0   1   95 102                       197 176 4 14 0   2     0   1   95 102                 197
1126909 1126909 MA Middlesex   school 2507620 178   Melrose 250762001193 1780505 Melrose High   Regular School No High 09 12 2017   grade_9 195 18 14 0   18     0   10   107 148                       255 195 18 14 0   18     0   10   107 148                 255
1130051 1130051 MA Middlesex   school 2512210 315   Wayland 251221002010 3150505 Wayland High School   Regular School No High 09 12 2017   grade_9 150 12 14 0   26     0   12   108 106                       214 150 12 14 0   26     0   12   108 106                 214
1131643 1131643 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science   Regular School Yes Other KG 12 2017   grade_9 18 19 14 0   12     0   1   39 25                       64 18 19 14 0   12     0   1   39 25                 64
1132257 1132257 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000824 6800505 Minnechaug Regional High   Regular School No High 09 12 2017   grade_9 238 7 14 0   14     0   11   144 140                       284 238 7 14 0   14     0   11   144 140                 284
1132286 1132286 MA Middlesex   school 2506930 695   Lincoln-Sudbury 250693001011 6950505 Lincoln-Sudbury Regional High   Regular School No High 09 12 2017   grade_9 298 15 14 1   20     0   21   208 161                       369 298 15 14 1   20     0   21   208 161                 369
1131114 1131114 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes Other 05 10 2017   grade_9 15 15 140 0   3     0   0   84 89                       173 15 15 140 0   3     0   0   84 89                 173
1123280 1123280 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No High 09 12 2017   grade_9 15 72 142 1   26     0   3   164 95                       259 15 72 142 1   26     0   3   164 95                 259
1131050 1131050 MA Worcester   school 2513230 348   Worcester 251323002209 3480512 Doherty Memorial High   Regular School No High 09 12 2017   grade_9 154 83 146 0   22     0   19   229 195                       424 154 83 146 0   22     0   19   229 195                 424
1126641 1126641 MA Essex   school 2507260 168   Marblehead 250726001124 1680505 Marblehead High   Regular School No High 09 12 2017   grade_9 217 8 15 0   6     0   9   125 130                       255 217 8 15 0   6     0   9   125 130                 255
1127720 1127720 MA Bristol   school 2508730 212   North Attleborough 250873001405 2120505 North Attleboro High   Regular School No High 09 12 2017   grade_9 233 7 15 1   21     1   6   137 147                       284 233 7 15 1   21     1   6   137 147                 284
1130636 1130636 MA Middlesex   school 2513110 344   Winchester 251311002174 3440505 Winchester High School   Regular School No High 09 12 2017   grade_9 246 9 15 1   72     0   16   169 190                       359 246 9 15 1   72     0   16   169 190                 359

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