Data source: Big Local News · About: Big Local

392 rows where grade = "grade_9", state = "MA" and year = 2016 sorted by total

View and edit SQL

year

  • 2016 · 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
936655 MA Middlesex   school 2507560 176   Medford 250756002393 1760510 Curtis-Tufts   Regular School No 3 09 12 2016   grade_9 * * * *   *     *   *   1 *                       1                         1                   1
939288 MA Plymouth   school 2512060 310   Wareham 251206002668 3100310 West Academy   Regular School No N N N 2016   grade_9 * * * *   *     *   *   * *                       1                                             1
934837 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No 4 KG 12 2016   grade_9 2 3 5 0   0     0   0   7 3                       10 2 3 5 0   0     0   0   7 3                 10
935434 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill Alternative School   Regular School No 4 06 12 2016   grade_9 6 2 2 0   0     0   0   9 1                       10 6 2 2 0   0     0   0   9 1                 10
940820 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2016   grade_9 87 5 4 1   3     0   0   45 55                       100 87 5 4 1   3     0   0   45 55                 100
933702 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative Education School No 3 09 12 2016   grade_9 7 27 62 0   4     1   0   49 52                       101 7 27 62 0   4     1   0   49 52                 101
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
941993 MA Bristol   school 2500553 3507   City on a Hill Charter Public School New Bedford (District) 250055302814 35070505 City on a Hill Charter Public School New Bedford   Regular School Yes 4 09 10 2016   grade_9 35 16 46 0   1     0   4   52 50                       102 35 16 46 0   1     0   4   52 50                 102
941397 MA Worcester   school 2508280 720   Narragansett 250828001285 7200505 Narragansett Regional High   Regular School No 3 09 12 2016   grade_9 97 0 3 0   1     0   2   56 47                       103 97 0 3 0   1     0   2   56 47                 103
935400 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2016   grade_9 84 4 4 0   12     0   1   55 50                       105 84 4 4 0   12     0   1   55 50                 105
937611 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer High   Regular School No 3 08 12 2016   grade_9 88 3 7 0   5     0   2   45 60                       105 88 3 7 0   5     0   2   45 60                 105
939601 MA Bristol   school 2512780 331   Westport 251278002093 3310505 Westport Senior High School   Regular School No 3 08 12 2016   grade_9 95 1 3 0   3     0   4   55 51                       106 95 1 3 0   3     0   4   55 51                 106
934641 MA Worcester   school 2504230 77   Douglas 250423000570 770505 Douglas High School   Regular School No 3 09 12 2016   grade_9 104 0 2 0   0     0   1   56 51                       107 104 0 2 0   0     0   1   56 51                 107
936375 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No 3 07 12 2016   grade_9 5 5 92 1   1     0   3   66 41                       107 5 5 92 1   1     0   3   66 41                 107
934312 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No 4 06 12 2016   grade_9 105 1 0 0   0     0   2   60 48                       108 105 1 0 0   0     0   2   60 48                 108
940357 MA Suffolk   school 2500026 437   City on a Hill Charter Public School Circuit Street (District) 250002600530 4370505 City on a Hill Charter Public School Circuit Street   Regular School Yes 3 09 12 2016   grade_9 2 87 17 0   0     0   2   46 62                       108 2 87 17 0   0     0   2   46 62                 108
935899 MA Worcester   school 2506720 151   Leicester 250672000972 1510505 Leicester High   Regular School No 3 09 12 2016   grade_9 95 6 4 1   2     1   0   54 55                       109 95 6 4 1   2     1   0   54 55                 109
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
938486 MA Middlesex   school 2510890 274   Somerville 251089002499 2740510 Full Circle High School   Alternative Education School No 3 09 12 2016   grade_9 1 5 3 0   0     0   2   6 5                       11 1 5 3 0   0     0   2   6 5                 11
932546 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2016   grade_9 93 6 6 0   0     1   4   51 59                       110 93 6 6 0   0     1   4   51 59                 110
934480 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton Senior High   Regular School No 3 09 12 2016   grade_9 74 3 28 0   5     0   0   53 57                       110 74 3 28 0   5     0   0   53 57                 110
940346 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2016   grade_9 88 5 8 0   4     0   5   50 60                       110 88 5 8 0   4     0   5   50 60                 110
936817 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No 3 07 12 2016   grade_9 92 2 11 0   1     0   5   63 48                       111 92 2 11 0   1     0   5   63 48                 111
941282 MA Essex   school 2500067 698   Manchester Essex Regional 250006701109 6980510 Manchester Essex Regional High School   Regular School No 3 09 12 2016   grade_9 109 0 0 0   0     0   2   46 65                       111 109 0 0 0   0     0   2   46 65                 111
939472 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No 3 07 12 2016   grade_9 100 4 2 0   3     0   3   49 63                       112 100 4 2 0   3     0   3   49 63                 112
941905 MA Berkshire   school 2508950 851   Northern Berkshire Regional Vocational Technical 250895002282 8510605 Charles McCann Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 109 0 2 0   0     0   1   77 35                       112 109 0 2 0   0     0   1   77 35                 112
933844 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No 3 09 12 2016   grade_9 99 5 4 0   0     0   5   55 58                       113 99 5 4 0   0     0   5   55 58                 113
935625 MA Hampden   school 2506270 137   Holyoke 250627000913 1370605 Wm J Dean Vocational Technical High   Vocational Education School No 3 09 12 2016   grade_9 3 5 104 0   1     0   0   56 57                       113 3 5 104 0   1     0   0   56 57                 113
938964 MA Worcester   school 2511400 290   Sutton 251140001414 2900510 Sutton High School   Regular School No 3 09 12 2016   grade_9 106 0 2 0   1     0   4   50 63                       113 106 0 2 0   1     0   4   50 63                 113
936575 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No 3 09 12 2016   grade_9 86 4 4 10   2     0   8   66 48                       114 86 4 4 10   2     0   8   66 48                 114
940239 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes 2 05 09 2016   grade_9 12 18 79 2   4     0   0   56 59                       115 12 18 79 2   4     0   0   56 59                 115
941670 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No 3 09 12 2016   grade_9 101 1 7 0   1     0   5   61 54                       115 101 1 7 0   1     0   5   61 54                 115
936237 MA Worcester   school 2507080 162   Lunenburg 250708001058 1620505 Lunenburg High   Regular School No 3 08 12 2016   grade_9 101 1 5 1   8     1   0   58 59                       117 101 1 5 1   8     1   0   58 59                 117
941814 MA Worcester   school 2512100 778   Quaboag Regional 251210001994 7780505 Quaboag Regional High   Regular School No 3 09 12 2016   grade_9 107 1 7 0   0     0   2   63 54                       117 107 1 7 0   0     0   2   63 54                 117
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
933993 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 B B Russell Alternative School   Regular School No 4 06 12 2016   grade_9 3 9 0 0   0     0   0   9 3                       12 3 9 0 0   0     0   0   9 3                 12
935220 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative Education School No 3 09 12 2016   grade_9 11 0 0 0   0     0   1   2 10                       12 11 0 0 0   0     0   1   2 10                 12
941334 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No 3 08 12 2016   grade_9 100 11 3 0   2     0   4   66 54                       120 100 11 3 0   2     0   4   66 54                 120
933724 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative Education School No 3 09 12 2016   grade_9 14 49 45 0   8     0   5   47 74                       121 14 49 45 0   8     0   5   47 74                 121
939122 MA Middlesex   school 2511760 301   Tyngsborough 251176001934 3010505 Tyngsborough High School   Regular School No 3 09 12 2016   grade_9 103 1 7 0   5     0   5   62 59                       121 103 1 7 0   5     0   5   62 59                 121
941962 MA Hampden   school 2500547 3501   Paulo Freire Social Justice Charter School (District) 250054702782 35010505 Paulo Freire Social Justice Charter School   Regular School Yes 3 09 12 2016   grade_9 12 7 102 0   0     0   0   54 67                       121 12 7 102 0   0     0   0   54 67                 121
934024 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2016   grade_9 267 694 166 5   26     3   51   637 575                       1212 267 694 166 5   26     3   51   637 575                 1212
940939 MA Worcester   school 2502715 622   Blackstone-Millville 250271500192 6220505 Blackstone Millville RHS   Regular School No 3 09 12 2016   grade_9 109 2 7 0   2     0   2   60 62                       122 109 2 7 0   2     0   2   60 62                 122
933734 MA Suffolk   school 2502790 35   Boston 250279001692 350558 Boston Community Leadership Academy   Regular School No 3 09 12 2016   grade_9 3 46 64 1   6     0   3   59 64                       123 3 46 64 1   6     0   3   59 64                 123
935716 MA Essex   school 2506480 144   Ipswich 250648000935 1440505 Ipswich High   Regular School No 3 09 12 2016   grade_9 108 0 6 0   4     0   5   60 63                       123 108 0 6 0   4     0   5   60 63                 123
941591 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar Regional   Regular School No 3 07 12 2016   grade_9 103 2 11 2   1     0   4   60 63                       123 103 2 11 2   1     0   4   60 63                 123
933679 MA Suffolk   school 2502790 35   Boston 250279002016 350522 Excel High School   Regular School No 3 09 12 2016   grade_9 15 47 46 0   13     1   3   83 42                       125 15 47 46 0   13     1   3   83 42                 125
938538 MA Hampshire   school 2510920 278   South Hadley 251092001754 2780505 South Hadley High   Regular School No 3 09 12 2016   grade_9 115 3 4 0   3     0   0   63 62                       125 115 3 4 0   3     0   0   63 62                 125
940897 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202738 6160505 Ayer Shirley Regional High School   Regular School No 3 09 12 2016   grade_9 95 6 12 0   3     0   10   59 67                       126 95 6 12 0   3     0   10   59 67                 126
941954 MA Bristol   school 2503070 910   Bristol County Agricultural 250307000382 9100705 Bristol County Agricultural High   Vocational Education School No 3 09 12 2016   grade_9 118 0 3 1   0     0   4   25 101                       126 118 0 3 1   0     0   4   25 101                 126
941649 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No 3 07 12 2016   grade_9 115 4 6 0   1     0   1   62 65                       127 115 4 6 0   1     0   1   62 65                 127
941976 MA Suffolk   school 2500548 3504   City on a Hill Charter Public School Dudley Square (District) 250054802781 35040505 City on a Hill Charter Public School Dudley Square   Regular School Yes 4 09 11 2016   grade_9 2 103 21 0   2     0   0   61 67                       128 2 103 21 0   2     0   0   61 67                 128
934740 MA Hampshire   school 2504590 86   Easthampton 250459000612 860505 Easthampton High   Regular School No 3 09 12 2016   grade_9 103 3 19 0   2     0   2   69 60                       129 103 3 19 0   2     0   2   69 60                 129
940322 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes 4 05 12 2016   grade_9 5 38 80 0   3     0   4   63 67                       130 5 38 80 0   3     0   4   63 67                 130
939136 MA Worcester   school 2511850 304   Uxbridge 251185001938 3040505 Uxbridge High   Regular School No 3 09 12 2016   grade_9 119 3 3 0   0     1   5   70 61                       131 119 3 3 0   0     1   5   70 61                 131
940218 MA Hampshire   school 2508860 406   Northampton-Smith Vocational Agricultural 250886002314 4060705 Smith Vocational and Agricultural High   Vocational Education School No 3 09 12 2016   grade_9 105 4 18 0   2     0   2   69 62                       131 105 4 18 0   2     0   2   69 62                 131
933684 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Jeremiah E Burke High   Regular School No 3 09 12 2016   grade_9 4 84 41 0   1     0   2   75 57                       132 4 84 41 0   1     0   2   75 57                 132
941872 MA Franklin   school 2505020 818   Franklin County Regional Vocational Technical 250502000744 8180605 Franklin County Technical   Vocational Education School No 3 09 12 2016   grade_9 120 4 7 0   0     0   1   87 45                       132 120 4 7 0   0     0   1   87 45                 132
941897 MA Middlesex   school 2507985 830   Minuteman Regional Vocational Technical 250798501264 8300605 Minuteman Regional High   Vocational Education School No 3 09 12 2016   grade_9 103 6 12 0   7     0   5   88 45                       133 103 6 12 0   7     0   5   88 45                 133
941995 MA Hampden   school 2500555 3508   Phoenix Academy Public Charter High School Springfield (District) 250055502821 35080505 Phoenix Academy Public Charter High School Springfield   Regular School Yes 3 09 12 2016   grade_9 8 32 87 0   2     0   5   69 65                       134 8 32 87 0   2     0   5   69 65                 134
940329 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes 4 06 12 2016   grade_9 93 4 2 1   24     0   11   61 74                       135 93 4 2 1   24     0   11   61 74                 135
932895 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No 3 08 12 2016   grade_9 127 1 3 0   4     0   1   76 60                       136 127 1 3 0   4     0   1   76 60                 136
933792 MA Suffolk   school 2502790 35   Boston 250279002729 350658 West Roxbury Academy   Regular School No 3 09 12 2016   grade_9 12 57 63 0   0     1   3   75 61                       136 12 57 63 0   0     1   3   75 61                 136
939008 MA Bristol   school 2511460 292   Swansea 251146001893 2920505 Joseph Case High   Regular School No 3 09 12 2016   grade_9 126 4 3 0   2     0   1   70 66                       136 126 4 3 0   2     0   1   70 66                 136
940402 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2016   grade_9 33 49 41 0   8     0   5   63 73                       136 33 49 41 0   8     0   5   63 73                 136
940911 MA Berkshire   school 2502530 618   Berkshire Hills 250253000154 6180505 Monument Mt Regional High   Regular School No 3 09 12 2016   grade_9 120 5 6 0   1     0   4   67 69                       136 120 5 6 0   1     0   4   67 69                 136
933758 MA Suffolk   school 2502790 35   Boston 250279001898 350579 Urban Science Academy   Regular School No 3 09 12 2016   grade_9 9 67 54 0   1     0   7   91 47                       138 9 67 54 0   1     0   7   91 47                 138
939364 MA Worcester   school 2512240 316   Webster 251224002012 3160505 Bartlett High School   Regular School No 3 09 12 2016   grade_9 106 6 16 1   4     0   5   75 63                       138 106 6 16 1   4     0   5   75 63                 138
941917 MA Bristol   school 2509140 855   Old Colony Regional Vocational Technical 250914001471 8550605 Old Colony Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 138 0 0 0   0     0   2   82 58                       140 138 0 0 0   0     0   2   82 58                 140
939296 MA Plymouth   school 2512060 310   Wareham 251206001991 3100505 Wareham Senior High   Regular School No 3 09 12 2016   grade_9 101 8 10 0   3     0   19   79 62                       141 101 8 10 0   3     0   19   79 62                 141
941864 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Region Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 104 6 14 6   1     1   9   85 56                       141 104 6 14 6   1     1   9   85 56                 141
941682 MA Worcester   school 2511490 770   Tantasqua 251149001901 7700605 Tantasqua Regional Vocational   Vocational Education School No 3 09 12 2016   grade_9 127 0 11 0   1     0   3   85 57                       142 127 0 11 0   1     0   3   85 57                 142
939530 MA Hampden   school 2512630 325   Westfield 251263002074 3250605 Westfield Technical Academy   Vocational Education School No 3 09 12 2016   grade_9 118 4 12 1   3     0   5   90 53                       143 118 4 12 1   3     0   5   90 53                 143
942031 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No 4 KG 12 2016   grade_9 108 11 14 0   2     1   8   51 93                       144 108 11 14 0   2     1   8   51 93                 144
934709 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No 3 07 12 2016   grade_9 140 4 0 0   0     0   1   67 78                       145 140 4 0 0   0     0   1   67 78                 145
932608 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No 3 09 12 2016   grade_9 127 3 9 0   2     0   5   81 65                       146 127 3 9 0   2     0   5   81 65                 146
933797 MA Suffolk   school 2502790 35   Boston 250279000217 350690 Snowden International School at Copley   Regular School No 3 09 12 2016   grade_9 8 47 79 0   9     2   1   77 69                       146 8 47 79 0   9     2   1   77 69                 146
936903 MA Nantucket   school 2508250 197   Nantucket 250825001282 1970505 Nantucket High   Regular School No 3 09 12 2016   grade_9 91 16 32 0   1     0   6   87 59                       146 91 16 32 0   1     0   6   87 59                 146
941958 MA Norfolk   school 2508650 915   Norfolk County Agricultural 250865001386 9150705 Norfolk County Agricultural   Vocational Education School No 3 09 12 2016   grade_9 136 2 4 1   1     0   4   38 110                       148 136 2 4 1   1     0   4   38 110                 148
938131 MA Plymouth   school 2510170 251   Rockland 251017001643 2510505 Rockland Senior High   Regular School No 3 09 12 2016   grade_9 114 12 18 0   0     0   5   74 75                       149 114 12 18 0   0     0   5   74 75                 149
935828 MA Essex   school 2506660 149   Lawrence 250666002627 1490530 Business Management & Finance High School   Regular School No 3 09 12 2016   grade_9 1 0 14 0   0     0   0   14 1                       15 1 0 14 0   0     0   0   14 1                 15
941677 MA Worcester   school 2511490 770   Tantasqua 251149001900 7700505 Tantasqua Regional Sr High   Regular School No 3 09 12 2016   grade_9 135 1 7 1   1     1   4   76 74                       150 135 1 7 1   1     1   4   76 74                 150
941212 MA Essex   school 2505670 675   Hamilton-Wenham 250567000820 6750505 Hamilton-Wenham Regional High   Regular School No 3 09 12 2016   grade_9 138 0 4 0   6     0   3   77 74                       151 138 0 4 0   6     0   3   77 74                 151
941286 MA Dukes   school 2507380 700   Martha's Vineyard 250738001145 7000505 Martha's Vineyard Regional High   Regular School No 3 09 12 2016   grade_9 121 2 22 3   1     1   3   92 61                       153 121 2 22 3   1     1   3   92 61                 153
937440 MA Worcester   school 2508940 214   Northbridge 250894001445 2140505 Northbridge High   Regular School No 3 09 12 2016   grade_9 139 2 11 0   0     0   3   79 76                       155 139 2 11 0   0     0   3   79 76                 155
935215 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No 3 08 12 2016   grade_9 115 2 25 1   4     0   11   83 75                       158 115 2 25 1   4     0   11   83 75                 158
938314 MA Bristol   school 2510590 265   Seekonk 251059001699 2650505 Seekonk High   Regular School No 3 09 12 2016   grade_9 143 3 3 0   6     0   4   68 91                       159 143 3 3 0   6     0   4   68 91                 159
939843 MA Suffolk   school 2513170 346   Winthrop 251317002180 3460505 Winthrop Sr High   Regular School No 3 08 12 2016   grade_9 137 2 13 0   1     0   6   91 68                       159 137 2 13 0   1     0   6   91 68                 159
941058 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000574 6550505 Dover-Sherborn Regional High   Regular School No 3 09 12 2016   grade_9 134 5 3 0   15     0   2   84 75                       159 134 5 3 0   15     0   2   84 75                 159
941510 MA Essex   school 2509450 745   Pentucket 250945001513 7450505 Pentucket Regional Sr High   Regular School No 3 09 12 2016   grade_9 150 1 6 0   1     0   1   74 85                       159 150 1 6 0   1     0   1   74 85                 159
933666 MA Suffolk   school 2502790 35   Boston 250279002015 350507 Boston International High School   Regular School No 3 09 12 2016   grade_9 3 49 102 0   3     2   1   91 69                       160 3 49 102 0   3     2   1   91 69                 160
941313 MA Worcester   school 2507680 710   Mendon-Upton 250768001202 7100510 Nipmuc Regional High   Regular School No 3 09 12 2016   grade_9 149 2 5 0   1     0   4   72 89                       161 149 2 5 0   1     0   4   72 89                 161
934880 MA Bristol   school 2504800 94   Fairhaven 250480000642 940505 Fairhaven High   Regular School No 3 09 12 2016   grade_9 144 2 8 0   2     0   6   81 81                       162 144 2 8 0   2     0   6   81 81                 162
938524 MA Worcester   school 2511010 277   Southbridge 251101002755 2770415 Southbridge Middle/High School   Regular School No 4 06 12 2016   grade_9 81 1 79 0   1     0   0   96 66                       162 81 1 79 0   1     0   0   96 66                 162
940848 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000069 6100505 Oakmont Regional High School   Regular School No 3 09 12 2016   grade_9 155 0 3 0   2     0   3   77 86                       163 155 0 3 0   2     0   3   77 86                 163
941000 MA Berkshire   school 2503390 635   Central Berkshire 250339000467 6350505 Wahconah Regional High   Regular School No 3 09 12 2016   grade_9 149 2 6 0   3     0   4   79 85                       164 149 2 6 0   3     0   4   79 85                 164
941921 MA Hampden   school 2509310 860   Pathfinder Regional Vocational Technical 250931002285 8600605 Pathfinder Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 151 1 9 1   0     0   5   104 63                       167 151 1 9 1   0     0   5   104 63                 167
933788 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No 4 06 12 2016   grade_9 4 114 37 1   10     0   2   90 78                       168 4 114 37 1   10     0   2   90 78                 168
936401 MA Essex   school 2507140 164   Lynnfield 250714001090 1640505 Lynnfield High   Regular School No 3 09 12 2016   grade_9 148 0 10 0   6     0   5   93 76                       169 148 0 10 0   6     0   5   93 76                 169
933825 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston Collaborative High School   Alternative Education School No 3 08 12 2016   grade_9 1 9 6 1   0     0   0   8 9                       17 1 9 6 1   0     0   0   8 9                 17

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