Data source: Big Local News · About: Big Local

2,737 rows where grade = "grade_9" and state = "MA" sorted by hispanic_int

View and edit SQL

year

grade

  • grade_9 · 2,637
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
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
1366531 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No High 06 12 2020   grade_9 98 0 0 2   1     0   0   41 60 *                     101.0 98 0 0 2   1     0   0   41 60                 101
1373515 MA Essex   school 2500067 698   Manchester Essex Regional 250006701109 6980510 Manchester Essex Regional High School   Regular School No High 09 12 2020   grade_9 120 0 0 0   3     0   2   72 53 *                     125.0 120 0 0 0   3     0   2   72 53                 125
1374181 MA Norfolk   school 2508650 915   Norfolk County Agricultural 250865001386 9150705 Norfolk County Agricultural   Career and Technical School No High 09 12 2020   grade_9 134 1 0 0   1     1   7   40 104 *                     144.0 134 1 0 0   1     1   7   40 104                 144
1674892 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Hatfield - Smith Academy   Regular School No High 07 12 2021   grade_9 21 1 0 0   0     0   0   12 9 *                     22.0 21 1 0 0   0     0   0   12 9                 22
1675174 MA Plymouth   school 2506420 142   Hull 250642000930 1420505 Hull - Hull High   Regular School No High 09 12 2021   grade_9 56 1 0 0   1     0   1   28 31 *                     59.0 56 1 0 0   1     0   1   28 31                 59
1680229 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter (District) - Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2021   grade_9 19 4 0 0   3     0   5   12 19 *                     31.0 19 4 0 0   3     0   5   12 19                 31
1681429 MA Norfolk   school 2508650 915   Norfolk County Agricultural 250865001386 9150705 Norfolk County Agricultural - Norfolk County Agricultural   Career and Technical School No High 09 12 2021   grade_9 147 1 0 1   0     0   9   37 121 *                     158.0 147 1 0 1   0     0   9   37 121                 158
2040176 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Keough Memorial Academy   Alternative School No High 08 12 2019   grade_9 6 0 0 0   0     0   0   4 2                       6.0 6 0 0 0   0     0   0   4 2                 6
2042719 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No High 07 12 2019   grade_9 38 0 0 0   3     0   3   16 28                       44.0 38 0 0 0   3     0   3   16 28                 44
2043009 MA Plymouth   school 2506420 142   Hull 250642000930 1420505 Hull High   Regular School No High 09 12 2019   grade_9 53 1 0 0   2     0   2   33 25                       58.0 53 1 0 0   2     0   2   33 25                 58
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
2047081 MA Worcester   school 2513080 343   Winchendon 251308002843 3430405 Murdock Academy for Success   Alternative School No High 09 12 2019   grade_9 13 0 0 0   0     0   0   7 6                       13.0 13 0 0 0   0     0   0   7 6                 13
2048852 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley Regional   Regular School No High 07 12 2019   grade_9 32 0 0 0   0     0   1   15 18                       33.0 32 0 0 0   0     0   1   15 18                 33
2228846 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury: Amesbury Innovation High School   Regular School No High 09 12 2018   grade_9 8 0 0 0   0     0   1   5 4                       9.0 8 0 0 0   0     0   1   5 4                 9
2230197 MA Suffolk   school 2502790 35   Boston 250279002676 350651 Boston: Dorchester Academy   Regular School No High 09 12 2018   grade_9 0 7 0 0   0     0   0   6 1                       7.0 0 7 0 0   0     0   0   6 1                 7
2233923 MA Hampden   school 2508040 191   Monson 250804001269 1910505 Monson: Monson High School   Regular School No High 09 12 2018   grade_9 59 2 0 0   0     0   0   29 32                       61.0 59 2 0 0   0     0   0   29 32                 61
2236798 MA Plymouth   school 2512060 310   Wareham 251206002105 3100315 Wareham: Wareham Cooperative Alternative School   Regular School No High 09 12 2018   grade_9 7 2 0 0   0     0   1   5 5                       10.0 7 2 0 0   0     0   1   5 5                 10
2238758 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303000380 6250505 Bridgewater-Raynham: Bridgewater-Raynham Regional   Regular School No High 09 12 2018   grade_9 309 20 0 0   7     0   16   159 193                       352.0 309 20 0 0   7     0   16   159 193                 352
2239141 MA Essex   school 2500067 698   Manchester Essex Regional 250006701109 6980510 Manchester Essex Regional: Manchester Essex Regional High School   Regular School No High 09 12 2018   grade_9 129 0 0 0   2     0   0   59 72                       131.0 129 0 0 0   2     0   0   59 72                 131
2239817 MA Franklin   school 2505020 818   Franklin County Regional Vocational Technical 250502000744 8180605 Franklin County Regional Vocational Technical: Franklin County Technical   Career and Technical School No High 09 12 2018   grade_9 125 1 0 0   0     0   0   89 37                       126.0 125 1 0 0   0     0   0   89 37                 126
736808 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Community Academy   Regular School No 3 09 12 2015   grade_9 3 4 1 0   0     0   0   5 3                       8 3 4 1 0   0     0   0   5 3                 8
737130 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 B B Russell Alternative School   Regular School No 3 07 12 2015   grade_9 2 9 1 0   0     0   0   8 4                       12 2 9 1 0   0     0   0   8 4                 12
737635 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No 4 06 12 2015   grade_9 91 5 1 1   1     0   0   60 39                       99 91 5 1 1   1     0   0   60 39                 99
738383 MA Essex   school 2505220 105   Georgetown 250522000764 1050505 Georgetown High School   Regular School No 3 09 12 2015   grade_9 105 3 1 0   2     0   2   63 50                       113 105 3 1 0   2     0   2   63 50                 113
738501 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No 3 07 12 2015   grade_9 33 0 1 0   1     0   2   17 20                       37 33 0 1 0   1     0   2   17 20                 37
738550 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2015   grade_9 84 2 1 0   12     0   3   56 46                       102 84 2 1 0   12     0   3   56 46                 102
738564 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No 3 07 12 2015   grade_9 28 1 1 0   0     0   2   16 16                       32 28 1 1 0   0     0   2   16 16                 32
738846 MA Plymouth   school 2506420 142   Hull 250642000930 1420505 Hull High   Regular School No 3 09 12 2015   grade_9 63 1 1 0   0     0   1   34 32                       66 63 1 1 0   0     0   1   34 32                 66
740782 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer High   Regular School No 3 08 12 2015   grade_9 84 2 1 0   1     0   2   48 42                       90 84 2 1 0   1     0   2   48 42                 90
740878 MA Plymouth   school 2509420 231   Pembroke 250942001824 2310505 Pembroke High School   Regular School No 3 09 12 2015   grade_9 267 2 1 0   3     2   2   149 128                       277 267 2 1 0   3     2   2   149 128                 277
741413 MA Barnstable   school 2510470 261   Sandwich 251047001673 2610505 Sandwich High   Regular School No 3 09 12 2015   grade_9 170 1 1 1   3     0   0   91 85                       176 170 1 1 1   3     0   0   91 85                 176
741488 MA Plymouth   school 2510560 264   Scituate 251056001693 2640505 Scituate High School   Regular School No 3 09 12 2015   grade_9 210 5 1 0   2     0   3   94 127                       221 210 5 1 0   2     0   3   94 127                 221
742254 MA Bristol   school 2511520 293   Taunton 251152002778 2930525 Taunton Alternative High School   Alternative Education School No 3 08 12 2015   grade_9 2 3 1 0   0     0   1   6 1                       7 2 3 1 0   0     0   1   6 1                 7
742313 MA Middlesex   school 2511760 301   Tyngsborough 251176001934 3010505 Tyngsborough High School   Regular School No 3 09 12 2015   grade_9 108 3 1 0   7     0   2   66 55                       121 108 3 1 0   7     0   2   66 55                 121
742666 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No 3 07 12 2015   grade_9 90 2 1 0   3     1   3   40 60                       100 90 2 1 0   3     1   3   40 60                 100
742796 MA Bristol   school 2512780 331   Westport 251278002093 3310505 Westport High   Regular School No 3 08 12 2015   grade_9 68 1 1 0   0     0   1   39 32                       71 68 1 1 0   0     0   1   39 32                 71
743723 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2015   grade_9 6 1 1 0   1     0   0   6 3                       9 6 1 1 0   1     0   0   6 3                 9
743812 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public School   Regular School Yes 4 05 12 2015   grade_9 78 2 1 0   0     0   4   39 46                       85 78 2 1 0   0     0   4   39 46                 85
743858 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public School   Regular School Yes 4 KG 12 2015   grade_9 33 15 1 0   1     0   2   24 28                       52 33 15 1 0   1     0   2   24 28                 52
743987 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2015   grade_9 73 4 1 0   0     0   1   38 41                       79 73 4 1 0   0     0   1   38 41                 79
744657 MA Plymouth   school 2509150 740   Old Rochester 250915001472 7400505 Old Rochester Regional High   Regular School No 3 09 12 2015   grade_9 196 5 1 1   7     0   2   104 108                       212 196 5 1 1   7     0   2   104 108                 212
744891 MA Essex   school 2511740 773   Triton 251174001932 7730505 Triton Regional High School   Regular School No 3 09 12 2015   grade_9 183 0 1 0   6     0   0   88 102                       190 183 0 1 0   6     0   0   88 102                 190
932900 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Paul J. Primavera Jr./Sr. High School   Alternative Education School No 3 07 12 2016   grade_9 5 0 1 0   0     0   1   4 3                       7 5 0 1 0   0     0   1   4 3                 7
933107 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No 4 06 12 2016   grade_9 1 1 1 0   3     0   0   3 3                       6 1 1 1 0   3     0   0   3 3                 6
934494 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No 4 06 12 2016   grade_9 112 4 1 0   2     0   0   60 59                       119 112 4 1 0   2     0   0   60 59                 119
935234 MA Essex   school 2505220 105   Georgetown 250522000764 1050505 Georgetown High School   Regular School No 3 09 12 2016   grade_9 88 0 1 0   1     0   0   40 50                       90 88 0 1 0   1     0   0   40 50                 90
935311 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No 3 07 12 2016   grade_9 47 0 1 0   2     0   1   31 20                       51 47 0 1 0   2     0   1   31 20                 51
935385 MA Plymouth   school 2505790 122   Hanover 250579000829 1220505 Hanover High   Regular School No 3 09 12 2016   grade_9 208 2 1 0   4     0   0   123 92                       215 208 2 1 0   4     0   0   123 92                 215
935414 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No 3 07 12 2016   grade_9 27 0 1 0   2     0   0   13 17                       30 27 0 1 0   2     0   0   13 17                 30
935954 MA Worcester   school 2506780 153   Leominster 250678002779 1530515 Leominster Center for Excellence   Regular School No 3 09 12 2016   grade_9 4 1 1 0   0     0   1   3 4                       7 4 1 1 0   0     0   1   3 4                 7
936043 MA Middlesex   school 2506960 158   Littleton 250696001012 1580505 Littleton High School   Regular School No 3 09 12 2016   grade_9 99 0 1 0   4     1   4   50 59                       109 99 0 1 0   4     1   4   50 59                 109
936881 MA Hampden   school 2508040 191   Monson 250804001269 1910505 Monson High School   Regular School No 3 09 12 2016   grade_9 69 0 1 0   1     0   2   39 34                       73 69 0 1 0   1     0   2   39 34                 73
937706 MA Plymouth   school 2509420 231   Pembroke 250942001824 2310505 Pembroke High School   Regular School No 3 09 12 2016   grade_9 237 4 1 0   1     0   1   124 120                       244 237 4 1 0   1     0   1   124 120                 244
938145 MA Essex   school 2510200 252   Rockport 251020002597 2520510 Rockport High   Regular School No 3 09 12 2016   grade_9 75 0 1 0   1     0   1   41 37                       78 75 0 1 0   1     0   1   41 37                 78
940552 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2016   grade_9 5 0 1 0   0     0   0   3 3                       6 5 0 1 0   0     0   0   3 3                 6
940740 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes 4 KG 11 2016   grade_9 15 4 1 0   8     0   2   17 13                       30 15 4 1 0   8     0   2   17 13                 30
940919 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Tahanto Regional High   Regular School No 4 06 12 2016   grade_9 70 1 1 0   0     0   3   28 47                       75 70 1 1 0   0     0   3   28 47                 75
941242 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire Regional High   Regular School No 3 07 12 2016   grade_9 99 0 1 0   0     0   2   54 48                       102 99 0 1 0   0     0   2   54 48                 102
941547 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley Regional   Regular School No 3 07 12 2016   grade_9 59 1 1 1   1     0   2   35 30                       65 59 1 1 1   1     0   2   35 30                 65
941597 MA Worcester   school 2509900 755   Ralph C Mahar 250990002707 7550525 The Gateway to College   Regular School No 3 09 12 2016   grade_9 13 1 1 0   1     0   1   3 14                       17 13 1 1 0   1     0   1   3 14                 17
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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
1364859 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2020   grade_9 7 0 1 0   0     0   0   4 4 *                     8.0 7 0 1 0   0     0   0   4 4                 8
1366067 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No High 09 12 2020   grade_9 96 0 1 1   2     0   3   43 60 *                     103.0 96 0 1 1   2     0   3   43 60                 103
1366221 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 02 12 2020   grade_9 1 3 1 0   0     0   1   3 3 *                     6.0 1 3 1 0   0     0   1   3 3                 6
1366716 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset High School   Regular School No High 09 12 2020   grade_9 107 4 1 0   4     0   1   59 58 *                     117.0 107 4 1 0   4     0   1   59 58                 117
1367929 MA Plymouth   school 2506420 142   Hull 250642000930 1420505 Hull High   Regular School No High 09 12 2020   grade_9 60 0 1 0   0     0   0   40 21 *                     61.0 60 0 1 0   0     0   0   40 21                 61
1368149 MA Worcester   school 2506780 153   Leominster 250678002779 1530515 Leominster Center for Excellence   Regular School No High 09 12 2020   grade_9 9 0 1 0   0     0   0   3 6 *                     10.0 9 0 1 0   0     0   0   3 6                 10
1369102 MA Hampden   school 2508040 191   Monson 250804001269 1910505 Monson High School   Regular School No High 07 12 2020   grade_9 44 0 1 0   0     0   0   19 26 *                     45.0 44 0 1 0   0     0   0   19 26                 45
1369745 MA Plymouth   school 2509030 219   Norwell 250903001455 2190505 Norwell High   Regular School No High 09 12 2020   grade_9 152 0 1 0   3     0   3   69 90 *                     159.0 152 0 1 0   3     0   3   69 90                 159
1373040 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley High School   Regular School No High 08 12 2020   grade_9 54 2 1 1   1     0   0   31 28 *                     59.0 54 2 1 1   1     0   0   31 28                 59
1373346 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000746 6650505 Apponequet Regional High   Regular School No High 09 12 2020   grade_9 185 3 1 0   1     0   1   96 95 *                     191.0 185 3 1 0   1     0   1   96 95                 191
1373785 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley Regional   Regular School No High 07 12 2020   grade_9 47 0 1 0   1     0   3   25 27 *                     52.0 47 0 1 0   1     0   3   25 27                 52
1673944 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset - Cohasset High School   Regular School No High 09 12 2021   grade_9 94 3 1 0   3     0   2   52 51 *                     103.0 94 3 1 0   3     0   2   52 51                 103
1674297 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett - Devens School   Regular School No Other KG 12 2021   grade_9 2 2 1 0   0     0   1   4 2 *                     6.0 2 2 1 0   0     0   1   4 2                 6
1677176 MA Plymouth   school 2509420 231   Pembroke 250942001824 2310505 Pembroke - Pembroke High School   Regular School No High 09 12 2021   grade_9 188 1 1 0   2     0   2   110 84 *                     194.0 188 1 1 0   2     0   2   110 84                 194
1677700 MA Barnstable   school 2510470 261   Sandwich 251047001673 2610505 Sandwich - Sandwich High   Regular School No High 09 12 2021   grade_9 144 0 1 0   2     0   3   71 78 *                     150.0 144 0 1 0   2     0   3   71 78                 150
1679741 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public (District) - Four Rivers Charter Public School   Regular School Yes High 07 12 2021   grade_9 31 1 1 0   0     0   2   17 18 *                     35.0 31 1 1 0   0     0   2   17 18                 35
1680779 MA Essex   school 2500067 698   Manchester Essex Regional 250006701109 6980510 Manchester Essex Regional - Manchester Essex Regional High School   Regular School No High 09 12 2021   grade_9 93 0 1 0   1     0   1   51 45 *                     96.0 93 0 1 0   1     0   1   51 45                 96
1681036 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley - Pioneer Valley Regional   Regular School No High 07 12 2021   grade_9 36 1 1 0   0     0   2   24 16 *                     40.0 36 1 1 0   0     0   2   24 16                 40
1681109 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Southern Berkshire - Mt Everett Regional   Regular School No High 06 12 2021   grade_9 32 0 1 0   0     0   2   13 22 *                     35.0 32 0 1 0   0     0   2   13 22                 35
1681389 MA Bristol   school 2509140 855   Old Colony Regional Vocational Technical 250914001471 8550605 Old Colony Regional Vocational Technical - Old Colony Regional Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 140 1 1 0   2     0   6   94 56 *                     150.0 140 1 1 0   2     0   6   94 56                 150
2040152 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No High 09 12 2019   grade_9 155 1 1 0   2     1   5   78 87                       165.0 155 1 1 0   2     1   5   78 87                 165
2041601 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No High 06 12 2019   grade_9 75 2 1 0   1     0   0   42 37                       79.0 75 2 1 0   1     0   0   42 37                 79
2042529 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative School No High 09 12 2019   grade_9 7 1 1 0   0     0   1   6 4                       10.0 7 1 1 0   0     0   1   6 4                 10
2042658 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No High 07 12 2019   grade_9 29 1 1 1   2     1   1   18 18                       36.0 29 1 1 1   2     1   1   18 18                 36

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