Data source: Big Local News · About: Big Local

396 rows where grade = "grade_10", state = "MA" and year = 2017 sorted by hispanic_int

View and edit SQL

year

  • 2017 · 396

grade

  • grade_10 · 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
1122041 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2017   grade_10 * * * *   *     *   *   1 1                       *                         1 1                  
1122640 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No High 07 12 2017   grade_10 * * * *   *     *   *   3 2                       *                         3 2                  
1125196 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_10 * * * *   *     *   *   * *                       *                                              
1125270 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_10 * * * *   *     *   *   * *                       *                                              
1125401 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill Alternative School   Regular School No High 07 12 2017   grade_10 * * * *   *     *   *   3 2                       *                         3 2                  
1125427 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_10 * * * *   *     *   *   3 1                       *                         3 1                  
1126841 MA Middlesex   school 2507560 176   Medford 250756002393 1760510 Curtis-Tufts   Regular School No High 09 12 2017   grade_10 * * * *   *     *   *   2 2                       *                         2 2                  
1128686 MA Essex   school 2510380 258   Salem 251038002774 2580515 Salem Prep High School   Regular School No High 08 12 2017   grade_10 * * * *   *     *   *   1 *                       *                         1                    
1129421 MA Hampden   school 2511130 281   Springfield 251113002734 2810560 Liberty Preparatory Academy   Regular School No High 09 12 2017   grade_10 * * * *   *     *   *   3 *                       *                         3                    
1129803 MA Worcester   school 2511850 304   Uxbridge 251185002862 3040515 Gateway to College   Alternative School No High 09 12 2017   grade_10 * * * *   *     *   *   2 3                       *                         2 3                  
1130587 MA Worcester   school 2513080 343   Winchendon 251308002843 3430405 Murdock Academy for Success   Alternative School No Other 06 12 2017   grade_10 * * * *   *     *   *   2 3                       *                         2 3                  
1131926 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No Other 05 12 2017   grade_10 * * * *   *     *   *   2 *                       *                         2                    
1124030 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No Other 06 12 2017   grade_10 97 1 0 0   0     0   2   52 48                       100 97 1 0 0   0     0   2   52 48                 100
1124505 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No High 07 12 2017   grade_10 141 4 0 0   0     0   1   69 76                       146 141 4 0 0   0     0   1   69 76                 146
1128704 MA Barnstable   school 2510470 261   Sandwich 251047001673 2610505 Sandwich High   Regular School No High 09 12 2017   grade_10 171 1 0 1   2     0   0   89 86                       175 171 1 0 1   2     0   0   89 86                 175
1128792 MA Plymouth   school 2510560 264   Scituate 251056001693 2640505 Scituate High School   Regular School No High 09 12 2017   grade_10 201 8 0 0   3     0   1   102 111                       213 201 8 0 0   3     0   1   102 111                 213
1129984 MA Plymouth   school 2512060 310   Wareham 251206002105 3100315 Wareham Cooperative Alternative School   Regular School No High 09 12 2017   grade_10 8 1 0 1   0     0   2   6 6                       12 8 1 0 1   0     0   2   6 6                 12
1131667 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_10 13 1 0 0   4     0   2   10 10                       20 13 1 0 0   4     0   2   10 10                 20
1132311 MA Essex   school 2500067 698   Manchester Essex Regional 250006701109 6980510 Manchester Essex Regional High School   Regular School No High 09 12 2017   grade_10 101 0 0 0   0     0   2   41 62                       103 101 0 0 0   0     0   2   41 62                 103
1132617 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley Regional   Regular School No High 07 12 2017   grade_10 60 1 0 1   1     0   2   32 33                       65 60 1 0 1   1     0   2   32 33                 65
1133058 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_10 137 0 0 0   0     0   2   79 60                       139 137 0 0 0   0     0   2   79 60                 139
1123671 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative School No Other 05 12 2017   grade_10 7 3 1 0   0     0   0   7 4                       11 7 3 1 0   0     0   0   7 4                 11
1123709 MA Plymouth   school 2503090 44   Brockton 250309002752 440520 Edison Academy   Regular School No High 09 12 2017   grade_10 5 4 1 0   0     0   0   5 5                       10 5 4 1 0   0     0   0   5 5                 10
1124248 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No Other 06 12 2017   grade_10 107 5 1 0   2     0   1   62 54                       116 107 5 1 0   2     0   1   62 54                 116
1125342 MA Plymouth   school 2505790 122   Hanover 250579000829 1220505 Hanover High   Regular School No High 09 12 2017   grade_10 212 2 1 0   4     0   0   126 92                       219 212 2 1 0   4     0   0   126 92                 219
1125374 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No High 07 12 2017   grade_10 25 0 1 0   2     0   0   13 15                       28 25 0 1 0   2     0   0   13 15                 28
1127107 MA Hampden   school 2508040 191   Monson 250804001269 1910505 Monson High School   Regular School No High 09 12 2017   grade_10 68 0 1 0   1     0   3   37 36                       73 68 0 1 0   1     0   3   37 36                 73
1128087 MA Plymouth   school 2509420 231   Pembroke 250942001824 2310505 Pembroke High School   Regular School No High 09 12 2017   grade_10 243 3 1 0   1     0   1   123 126                       249 243 3 1 0   1     0   1   123 126                 249
1128608 MA Essex   school 2510200 252   Rockport 251020002597 2520510 Rockport High   Regular School No High 09 12 2017   grade_10 78 0 1 0   1     0   1   41 40                       81 78 0 1 0   1     0   1   41 40                 81
1131459 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_10 6 0 1 0   0     0   0   3 4                       7 6 0 1 0   0     0   0   3 4                 7
1131512 MA Middlesex   school 2500038 478   Francis W. Parker Charter Essential (District) 250003800581 4780505 Francis W. Parker Charter Essential School   Regular School Yes High 07 12 2017   grade_10 60 0 1 0   1     0   2   32 32                       64 60 0 1 0   1     0   2   32 32                 64
1131551 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public School   Regular School Yes Other 05 12 2017   grade_10 67 1 1 0   6     0   0   40 35                       75 67 1 1 0   6     0   0   40 35                 75
1131869 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Tahanto Regional High   Regular School No Other 06 12 2017   grade_10 72 1 1 0   0     0   3   30 47                       77 72 1 1 0   0     0   3   30 47                 77
1132541 MA Plymouth   school 2509150 740   Old Rochester 250915001472 7400505 Old Rochester Regional High   Regular School No High 09 12 2017   grade_10 177 3 1 0   7     0   3   89 102                       191 177 3 1 0   7     0   3   89 102                 191
1122392 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Keough Memorial Academy   Alternative School No High 07 12 2017   grade_10 7 0 2 0   0     0   1   6 3                       10 7 0 2 0   0     0   1   6 3                 10
1123657 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Frederick Douglass Academy   Regular School No High 07 12 2017   grade_10 0 6 2 0   0     0   0   7 1                       8 0 6 2 0   0     0   0   7 1                 8
1124660 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2017   grade_10 6 2 2 0   0     0   1   9 2                       11 6 2 2 0   0     0   1   9 2                 11
1125117 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative School No High 09 12 2017   grade_10 17 2 2 0   0     0   1   10 12                       22 17 2 2 0   0     0   1   10 12                 22
1125241 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No High 07 12 2017   grade_10 46 0 2 0   2     0   1   31 20                       51 46 0 2 0   2     0   1   31 20                 51
1125641 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No High 07 12 2017   grade_10 76 0 2 4   0     0   2   40 44                       84 76 0 2 4   0     0   2   40 44                 84
1125708 MA Plymouth   school 2506420 142   Hull 250642000930 1420505 Hull High   Regular School No High 09 12 2017   grade_10 75 0 2 0   0     0   2   43 36                       79 75 0 2 0   0     0   2   43 36                 79
1125926 MA Worcester   school 2506720 151   Leicester 250672000972 1510505 Leicester High   Regular School No High 09 12 2017   grade_10 93 6 2 0   2     1   1   55 50                       105 93 6 2 0   2     1   1   55 50                 105
1126106 MA Middlesex   school 2506960 158   Littleton 250696001012 1580505 Littleton High School   Regular School No High 09 12 2017   grade_10 99 0 2 0   8     1   4   53 61                       114 99 0 2 0   8     1   4   53 61                 114
1126343 MA Worcester   school 2507080 162   Lunenburg 250708001058 1620505 Lunenburg High   Regular School No High 09 12 2017   grade_10 100 1 2 1   9     1   0   57 57                       114 100 1 2 1   9     1   0   57 57                 114
1127050 MA Norfolk   school 2507920 187   Millis 250792001255 1870505 Millis High School   Regular School No High 09 12 2017   grade_10 85 3 2 1   1     0   1   39 54                       93 85 3 2 1   1     0   1   39 54                 93
1127842 MA Bristol   school 2509000 218   Norton 250900001451 2180505 Norton High   Regular School No High 09 12 2017   grade_10 174 4 2 0   4     0   3   98 89                       187 174 4 2 0   4     0   3   98 89                 187
1127950 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Project C.O.F.F.E.E.   Special Education School No Other 05 12 2017   grade_10 7 0 2 0   0     0   0   7 *                       9 7 0 2 0   0     0   0   7                   9
1128680 MA Essex   school 2510380 258   Salem 251038002864 2580510 New Liberty Innovation School   Regular School No High 09 12 2017   grade_10 4 1 2 0   0     0   0   5 2                       7 4 1 2 0   0     0   0   5 2                 7
1129586 MA Worcester   school 2511400 290   Sutton 251140001414 2900510 Sutton High School   Regular School No High 09 12 2017   grade_10 101 0 2 0   1     0   4   45 63                       108 101 0 2 0   1     0   4   45 63                 108
1129641 MA Bristol   school 2511460 292   Swansea 251146001893 2920505 Joseph Case High   Regular School No High 09 12 2017   grade_10 120 3 2 0   2     0   1   65 63                       128 120 3 2 0   2     0   1   65 63                 128
1129708 MA Bristol   school 2511520 293   Taunton 251152002778 2930525 Taunton Alternative High School   Alternative School No High 08 12 2017   grade_10 12 2 2 0   0     0   0   10 6                       16 12 2 2 0   0     0   0   10 6                 16
1130198 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No High 07 12 2017   grade_10 98 3 2 0   1     0   2   46 60                       106 98 3 2 0   1     0   2   46 60                 106
1131226 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes Other 06 12 2017   grade_10 86 4 2 1   22     0   11   55 71                       126 86 4 2 1   22     0   11   55 71                 126
1131794 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000069 6100505 Oakmont Regional High School   Regular School No High 09 12 2017   grade_10 151 0 2 0   2     0   4   74 85                       159 151 0 2 0   2     0   4   74 85                 159
1132379 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No High 07 12 2017   grade_10 92 2 2 0   1     0   3   51 49                       100 92 2 2 0   1     0   3   51 49                 100
1132419 MA Franklin   school 2507990 717   Mohawk Trail 250799001265 7170505 Mohawk Trail Regional High   Regular School No High 07 12 2017   grade_10 59 0 2 0   0     0   6   34 33                       67 59 0 2 0   0     0   6   34 33                 67
1132443 MA Worcester   school 2508280 720   Narragansett 250828001285 7200505 Narragansett Regional High   Regular School No High 09 12 2017   grade_10 91 0 2 0   1     0   1   52 43                       95 91 0 2 0   1     0   1   52 43                 95
1122255 MA Bristol   school 2502190 16   Attleboro 250219002831 160515 Attleboro Community Academy   Alternative School No High 09 12 2017   grade_10 11 0 3 0   0     0   0   5 9                       14 11 0 3 0   0     0   0   5 9                 14
1122293 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2017   grade_10 21 21 3 0   2     0   2   25 24                       49 21 21 3 0   2     0   2   25 24                 49
1123286 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Community Academy   Regular School No High 09 12 2017   grade_10 1 8 3 0   0     0   1   10 *                       13 1 8 3 0   0     0   1   10                   13
1124424 MA Worcester   school 2504230 77   Douglas 250423000570 770505 Douglas High School   Regular School No High 09 12 2017   grade_10 95 0 3 0   0     0   1   52 47                       99 95 0 3 0   0     0   1   52 47                 99
1125908 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No High 07 12 2017   grade_10 52 0 3 0   4     0   3   34 28                       62 52 0 3 0   4     0   3   34 28                 62
1126745 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No High 09 12 2017   grade_10 79 4 3 10   2     0   7   60 45                       105 79 4 3 10   2     0   7   60 45                 105
1126791 MA Norfolk   school 2507530 175   Medfield 250753001157 1750505 Medfield Senior High   Regular School No High 09 12 2017   grade_10 174 3 3 0   12     1   3   102 94                       196 174 3 3 0   12     1   3   102 94                 196
1127788 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield High   Regular School No High 07 12 2017   grade_10 39 0 3 0   0     0   2   21 23                       44 39 0 3 0   0     0   2   21 23                 44
1128388 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No High 09 12 2017   grade_10 118 10 3 1   166     0   5   155 148                       303 118 10 3 1   166     0   5   155 148                 303
1129734 MA Middlesex   school 2511580 295   Tewksbury 251158001926 2950505 Tewksbury Memorial High   Regular School No High 09 12 2017   grade_10 218 6 3 0   7     0   1   125 110                       235 218 6 3 0   7     0   1   125 110                 235
1129799 MA Worcester   school 2511850 304   Uxbridge 251185001938 3040505 Uxbridge High   Regular School No High 09 12 2017   grade_10 112 3 3 0   1     1   4   69 55                       124 112 3 3 0   1     1   4   69 55                 124
1130356 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport Junior/Senior High School   Regular School No High 07 12 2017   grade_10 89 1 3 0   3     0   3   52 47                       99 89 1 3 0   3     0   3   52 47                 99
1131137 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public School   Regular School Yes High 07 12 2017   grade_10 32 0 3 0   0     0   3   18 20                       38 32 0 3 0   0     0   3   18 20                 38
1131350 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2017   grade_10 24 31 3 0   8     0   2   38 30                       68 24 31 3 0   8     0   2   38 30                 68
1131604 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public School   Regular School Yes Other KG 12 2017   grade_10 35 17 3 0   1     0   3   27 32                       59 35 17 3 0   1     0   3   27 32                 59
1131761 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No Other 06 12 2017   grade_10 80 7 3 1   3     0   0   43 51                       94 80 7 3 1   3     0   0   43 51                 94
1132042 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000574 6550505 Dover-Sherborn Regional High   Regular School No High 09 12 2017   grade_10 130 4 3 0   15     0   2   81 73                       154 130 4 3 0   15     0   2   81 73                 154
1132114 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000746 6650505 Apponequet Regional High   Regular School No High 09 12 2017   grade_10 173 4 3 1   1     0   7   91 98                       189 173 4 3 1   1     0   7   91 98                 189
1132146 MA Hampshire   school 2505160 672   Gateway 250516000758 6720505 Gateway Regional High   Regular School No High 09 12 2017   grade_10 56 0 3 0   0     0   0   34 25                       59 56 0 3 0   0     0   0   34 25                 59
1132170 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000807 6730505 Groton Dunstable Regional   Regular School No High 09 12 2017   grade_10 179 4 3 0   13     0   4   104 99                       203 179 4 3 0   13     0   4   104 99                 203
1132265 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire Regional High   Regular School No High 07 12 2017   grade_10 90 0 3 0   0     0   2   53 42                       95 90 0 3 0   0     0   2   53 42                 95
1132279 MA Norfolk   school 2506510 690   King Philip 250651000940 6900505 King Philip Regional High   Regular School No High 09 12 2017   grade_10 301 6 3 0   6     0   2   181 137                       318 301 6 3 0   6     0   2   181 137                 318
1132372 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No High 08 12 2017   grade_10 91 8 3 0   3     0   5   64 46                       110 91 8 3 0   3     0   5   64 46                 110
1133103 MA Bristol   school 2503070 910   Bristol County Agricultural 250307000382 9100705 Bristol County Agricultural High   Career and Technical School No High 09 12 2017   grade_10 112 0 3 0   0     0   4   25 94                       119 112 0 3 0   0     0   4   25 94                 119
1124954 MA Norfolk   school 2504950 99   Foxborough 250495000708 990505 Foxborough High   Regular School No High 09 12 2017   grade_10 184 9 4 0   7     0   1   115 90                       205 184 9 4 0   7     0   1   115 90                 205
1125135 MA Essex   school 2505220 105   Georgetown 250522000764 1050505 Georgetown High School   Regular School No High 09 12 2017   grade_10 92 0 4 0   1     0   1   43 55                       98 92 0 4 0   1     0   1   43 55                 98
1125358 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No Other 06 12 2017   grade_10 85 3 4 0   10     0   1   52 51                       103 85 3 4 0   10     0   1   52 51                 103
1125994 MA Worcester   school 2506780 153   Leominster 250678002779 1530515 Leominster Center for Excellence   Regular School No High 09 12 2017   grade_10 8 2 4 0   0     0   1   5 10                       15 8 2 4 0   0     0   1   5 10                 15
1127819 MA Middlesex   school 2508820 217   North Reading 250882001422 2170505 North Reading High   Regular School No High 09 12 2017   grade_10 177 0 4 0   5     0   3   90 99                       189 177 0 4 0   5     0   3   90 99                 189
1127867 MA Plymouth   school 2509030 219   Norwell 250903001455 2190505 Norwell High   Regular School No High 09 12 2017   grade_10 160 0 4 0   4     0   3   82 89                       171 160 0 4 0   4     0   3   82 89                 171
1128816 MA Bristol   school 2510590 265   Seekonk 251059001699 2650505 Seekonk High   Regular School No High 09 12 2017   grade_10 136 4 4 0   6     0   5   68 87                       155 136 4 4 0   6     0   5   68 87                 155
1129430 MA Hampden   school 2511130 281   Springfield 251113002743 2810575 Gateway to College at Holyoke Community College   Regular School No High 09 12 2017   grade_10 3 3 4 0   0     0   0   6 4                       10 3 3 4 0   0     0   0   6 4                 10
1130180 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston Junior/Senior High   Regular School No Other 06 12 2017   grade_10 52 1 4 0   2     0   1   26 34                       60 52 1 4 0   2     0   1   26 34                 60
1132227 MA Essex   school 2505670 675   Hamilton-Wenham 250567000820 6750505 Hamilton-Wenham Regional High   Regular School No High 09 12 2017   grade_10 136 0 4 0   7     0   3   79 71                       150 136 0 4 0   7     0   3   79 71                 150
1132716 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Mt Everett Regional   Regular School No High 07 12 2017   grade_10 38 0 4 0   0     0   6   22 26                       48 38 0 4 0   0     0   6   22 26                 48
1133043 MA Berkshire   school 2508950 851   Northern Berkshire Regional Vocational Technical 250895002282 8510605 Charles McCann Vocational Technical   Career and Technical School No High 09 12 2017   grade_10 114 1 4 0   0     0   1   83 37                       120 114 1 4 0   0     0   1   83 37                 120
1133093 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 2017   grade_10 147 15 4 0   1     0   8   111 64                       175 147 15 4 0   1     0   8   111 64                 175
1133108 MA Norfolk   school 2508650 915   Norfolk County Agricultural 250865001386 9150705 Norfolk County Agricultural   Career and Technical School No High 09 12 2017   grade_10 135 2 4 1   1     0   3   38 108                       146 135 2 4 1   1     0   3   38 108                 146
1122387 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No High 08 12 2017   grade_10 131 1 5 0   4     0   1   81 61                       142 131 1 5 0   4     0   1   81 61                 142
1123393 MA Suffolk   school 2502790 35   Boston 250279002676 350651 Dorchester Academy   Regular School No High 09 12 2017   grade_10 3 10 5 0   0     0   0   6 12                       18 3 10 5 0   0     0   0   6 12                 18
1124488 MA Plymouth   school 2504410 82   Duxbury 250441000594 820505 Duxbury High   Regular School No High 09 12 2017   grade_10 235 1 5 0   7     0   3   127 124                       251 235 1 5 0   7     0   3   127 124                 251
1124915 MA Worcester   school 2504890 97   Fitchburg 250489002110 970510 Goodrich Academy   Regular School No High 09 12 2017   grade_10 10 2 5 0   1     0   1   10 9                       19 10 2 5 0   1     0   1   10 9                 19
1125491 MA Plymouth   school 2506090 131   Hingham 250609000872 1310505 Hingham High   Regular School No High 09 12 2017   grade_10 268 4 5 0   3     0   4   141 143                       284 268 4 5 0   3     0   4   141 143                 284

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