Data source: Big Local News · About: Big Local

386 rows where grade = "grade_9", state = "MA" and year = 2015 sorted by white

View and edit SQL

year

  • 2015 · 386

grade

  • grade_9 · 386
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
736239 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No 3 07 12 2015   grade_9 * * * *   *     *   *   1 2                       3                         1 2                 3
737827 MA Middlesex   school 2504320 79   Dracut 250432002800 790515 Parker Avenue School   Alternative Education School No 3 09 12 2015   grade_9 * * * *   *     *   *   * *                       2                                             2
738606 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No 4 02 12 2015   grade_9 * * * *   *     *   *   2 1                       3                         2 1                 3
742014 MA Hampden   school 2511130 281   Springfield 251113002734 2810560 Liberty Preparatory Academy   Regular School No 3 09 12 2015   grade_9 * * * *   *     *   *   3 2                       5                         3 2                 5
742025 MA Hampden   school 2511130 281   Springfield 251113002809 2810580 Gateway to College at Springfield Technical Community College   Alternative Education School No 3 09 12 2015   grade_9 * * * *   *     *   *   1 3                       4                         1 3                 4
742481 MA Plymouth   school 2512060 310   Wareham 251206002668 3100310 West Academy   Regular School No 3 07 12 2015   grade_9 * * * *   *     *   *   3                         3                         3                   3
736849 MA Suffolk   school 2502790 35   Boston 250279000837 350543 Greater Egleston Community High School   Regular School No 3 09 12 2015   grade_9 0 2 5 0   0     0   0   4 3                       7 0 2 5 0   0     0   0   4 3                 7
739017 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2015   grade_9 0 1 19 0   0     0   0   18 2                       20 0 1 19 0   0     0   0   18 2                 20
743546 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes 4 PK 12 2015   grade_9 0 40 9 0   0     0   0   31 18                       49 0 40 9 0   0     0   0   31 18                 49
745169 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 2015   grade_9 0 18 56 0   0     0   0   36 38                       74 0 18 56 0   0     0   0   36 38                 74
736799 MA Suffolk   school 2502790 35   Boston 250279002015 350507 Boston International High School   Regular School No 3 09 12 2015   grade_9 1 56 111 0   5     0   2   94 81                       175 1 56 111 0   5     0   2   94 81                 175
736866 MA Suffolk   school 2502790 35   Boston 250279002753 350549 Margarita Muniz Academy   Regular School No 4 09 11 2015   grade_9 1 3 79 0   0     0   1   34 50                       84 1 3 79 0   0     0   1   34 50                 84
739005 MA Essex   school 2506660 149   Lawrence 250666002628 1490536 High School Learning Center   Regular School No 3 09 12 2015   grade_9 1 0 15 0   0     0   0   8 8                       16 1 0 15 0   0     0   0   8 8                 16
739340 MA Middlesex   school 2507020 160   Lowell 250702002732 1600320 Leblanc Therapeutic Day School   Regular School No 3 08 12 2015   grade_9 1 2 3 0   0     0   0   5 *                       6 1 2 3 0   0     0   0   5                   6
743532 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge   Regular School Yes 4 06 12 2015   grade_9 1 46 14 1   0     1   3   34 32                       66 1 46 14 1   0     1   3   34 32                 66
736869 MA Suffolk   school 2502790 35   Boston 250279001692 350558 Boston Community Leadership Academy   Regular School No 3 09 12 2015   grade_9 10 44 62 1   5     0   4   62 64                       126 10 44 62 1   5     0   4   62 64                 126
737173 MA Plymouth   school 2503090 44   Brockton 250309002752 440520 Edison Academy   Regular School No 3 09 12 2015   grade_9 10 27 11 0   0     0   0   24 24                       48 10 27 11 0   0     0   0   24 24                 48
738979 MA Essex   school 2506660 149   Lawrence 250666002627 1490530 Business Management & Finance High School   Regular School No 3 09 12 2015   grade_9 10 3 133 0   1     0   0   101 46                       147 10 3 133 0   1     0   0   101 46                 147
743502 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes 4 05 12 2015   grade_9 10 28 69 0   2     0   3   61 51                       112 10 28 69 0   2     0   3   61 51                 112
739731 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No 3 09 12 2015   grade_9 100 4 4 4   1     0   6   54 65                       119 100 4 4 4   1     0   6   54 65                 119
744510 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No 3 08 12 2015   grade_9 100 14 9 1   4     0   7   71 64                       135 100 14 9 1   4     0   7   71 64                 135
738194 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg High   Regular School No 3 09 12 2015   grade_9 101 19 146 0   20     1   11   150 148                       298 101 19 146 0   20     1   11   150 148                 298
744457 MA Essex   school 2500067 698   Manchester Essex Regional 250006701109 6980510 Manchester Essex Regional High School   Regular School No 3 09 12 2015   grade_9 101 0 0 0   0     0   0   49 52                       101 101 0 0 0   0     0   0   49 52                 101
739390 MA Worcester   school 2507080 162   Lunenburg 250708001058 1620505 Lunenburg High   Regular School No 3 08 12 2015   grade_9 102 1 3 0   1     0   1   50 58                       108 102 1 3 0   1     0   1   50 58                 108
741132 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No 3 09 12 2015   grade_9 102 7 14 1   162     0   2   151 137                       288 102 7 14 1   162     0   2   151 137                 288
742489 MA Plymouth   school 2512060 310   Wareham 251206001991 3100505 Wareham Senior High   Regular School No 3 09 12 2015   grade_9 102 12 15 2   2     0   21   78 76                       154 102 12 15 2   2     0   21   78 76                 154
744105 MA Worcester   school 2502715 622   Blackstone-Millville 250271500192 6220505 Blackstone Millville RHS   Regular School No 3 09 12 2015   grade_9 102 1 7 1   1     0   2   62 52                       114 102 1 7 1   1     0   2   62 52                 114
739971 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No 3 07 12 2015   grade_9 103 1 3 2   1     0   1   53 58                       111 103 1 3 2   1     0   1   53 58                 111
739986 MA Norfolk   school 2507920 187   Millis 250792001255 1870505 Millis High School   Regular School No 3 09 12 2015   grade_9 104 2 4 2   3     0   2   61 56                       117 104 2 4 2   3     0   2   61 56                 117
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
741382 MA Essex   school 2510380 258   Salem 251038001664 2580505 Salem High   Regular School No 3 09 12 2015   grade_9 105 20 108 1   8     0   12   133 121                       254 105 20 108 1   8     0   12   133 121                 254
742780 MA Middlesex   school 2512750 330   Weston 251275002087 3300505 Weston High   Regular School No 3 09 12 2015   grade_9 105 11 6 0   18     0   9   83 66                       149 105 11 6 0   18     0   9   83 66                 149
739050 MA Worcester   school 2506720 151   Leicester 250672000972 1510505 Leicester High   Regular School No 3 09 12 2015   grade_9 106 3 6 0   1     0   0   59 57                       116 106 3 6 0   1     0   0   59 57                 116
736026 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No 3 09 12 2015   grade_9 108 4 5 1   2     0   1   64 57                       121 108 4 5 1   2     0   1   64 57                 121
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
744416 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire Regional High   Regular School No 3 07 12 2015   grade_9 108 1 4 0   0     0   2   48 67                       115 108 1 4 0   0     0   2   48 67                 115
737762 MA Norfolk   school 2504050 73   Dedham 250405000548 730505 Dedham High   Regular School No 3 09 12 2015   grade_9 109 16 26 0   10     0   4   78 87                       165 109 16 26 0   10     0   4   78 87                 165
736909 MA Suffolk   school 2502790 35   Boston 250279002674 350655 Lyon Upper 9-12   Regular School No 3 09 12 2015   grade_9 11 12 7 0   0     0   1   20 11                       31 11 12 7 0   0     0   1   20 11                 31
744077 MA Berkshire   school 2502530 618   Berkshire Hills 250253000154 6180505 Monument Mt Regional High   Regular School No 3 09 12 2015   grade_9 110 0 8 0   4     0   3   63 62                       125 110 0 8 0   4     0   3   63 62                 125
735668 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2015   grade_9 113 1 15 0   0     0   2   61 70                       131 113 1 15 0   0     0   2   61 70                 131
741445 MA Essex   school 2510500 262   Saugus 251050001684 2620505 Saugus High   Regular School No 3 09 12 2015   grade_9 113 3 19 1   10     1   2   68 81                       149 113 3 19 1   10     1   2   68 81                 149
738867 MA Essex   school 2506480 144   Ipswich 250648000935 1440505 Ipswich High   Regular School No 3 09 12 2015   grade_9 114 1 4 0   3     0   2   68 56                       124 114 1 4 0   3     0   2   68 56                 124
744765 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar Regional   Regular School No 3 07 12 2015   grade_9 114 1 7 0   2     0   5   64 65                       129 114 1 7 0   2     0   5   64 65                 129
744173 MA Berkshire   school 2503390 635   Central Berkshire 250339000467 6350505 Wahconah Regional High   Regular School No 3 09 12 2015   grade_9 115 2 3 0   1     0   4   57 68                       125 115 2 3 0   1     0   4   57 68                 125
745085 MA Berkshire   school 2508950 851   Northern Berkshire Regional Vocational Technical 250895002282 8510605 Charles McCann Vocational Technical   Vocational Education School No 3 09 12 2015   grade_9 115 1 2 1   0     0   3   75 47                       122 115 1 2 1   0     0   3   75 47                 122
741734 MA Hampshire   school 2510920 278   South Hadley 251092001754 2780505 South Hadley High   Regular School No 3 09 12 2015   grade_9 117 3 9 0   1     1   6   78 59                       137 117 3 9 0   1     1   6   78 59                 137
745077 MA Middlesex   school 2507985 830   Minuteman Regional Vocational Technical 250798501264 8300605 Minuteman Regional High   Vocational Education School No 3 09 12 2015   grade_9 117 11 14 0   4     0   2   104 44                       148 117 11 14 0   4     0   2   104 44                 148
737452 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No 4 06 12 2015   grade_9 120 2 2 1   0     1   1   61 66                       127 120 2 2 1   0     1   1   61 66                 127
742327 MA Worcester   school 2511850 304   Uxbridge 251185001938 3040505 Uxbridge High   Regular School No 3 09 12 2015   grade_9 120 1 3 0   3     0   1   62 66                       128 120 1 3 0   3     0   1   62 66                 128
742199 MA Bristol   school 2511460 292   Swansea 251146001893 2920505 Joseph Case High   Regular School No 3 09 12 2015   grade_9 121 2 3 0   1     0   3   70 60                       130 121 2 3 0   1     0   3   70 60                 130
745135 MA Bristol   school 2503070 910   Bristol County Agricultural 250307000382 9100705 Bristol County Agricultural High   Vocational Education School No 3 09 12 2015   grade_9 122 0 2 0   0     0   2   38 88                       126 122 0 2 0   0     0   2   38 88                 126
744827 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick-Tolland Regional High   Regular School No 3 09 12 2015   grade_9 123 1 2 0   2     0   3   65 66                       131 123 1 2 0   2     0   3   65 66                 131
738364 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No 3 09 12 2015   grade_9 124 5 17 0   2     0   9   78 79                       157 124 5 17 0   2     0   9   78 79                 157
745139 MA Norfolk   school 2508650 915   Norfolk County Agricultural 250865001386 9150705 Norfolk County Agricultural   Vocational Education School No 3 09 12 2015   grade_9 124 4 8 0   3     0   5   54 90                       144 124 4 8 0   3     0   5   54 90                 144
741509 MA Bristol   school 2510590 265   Seekonk 251059001699 2650505 Seekonk High   Regular School No 3 09 12 2015   grade_9 125 1 4 0   2     0   1   59 74                       133 125 1 4 0   2     0   1   59 74                 133
742517 MA Middlesex   school 2512180 314   Watertown 251218002005 3140505 Watertown High   Regular School No 3 09 12 2015   grade_9 126 3 17 2   9     0   3   75 85                       160 126 3 17 2   9     0   3   75 85                 160
744386 MA Essex   school 2505670 675   Hamilton-Wenham 250567000820 6750505 Hamilton-Wenham Regional High   Regular School No 3 09 12 2015   grade_9 127 0 3 0   6     0   4   76 64                       140 127 0 3 0   6     0   4   76 64                 140
744861 MA Worcester   school 2511490 770   Tantasqua 251149001901 7700605 Tantasqua Regional Vocational   Vocational Education School No 3 09 12 2015   grade_9 127 2 9 0   0     0   2   85 55                       140 127 2 9 0   0     0   2   85 55                 140
745043 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Region Vocational Technical   Vocational Education School No 3 09 12 2015   grade_9 128 4 18 0   1     0   11   100 62                       162 128 4 18 0   1     0   11   100 62                 162
745052 MA Franklin   school 2505020 818   Franklin County Regional Vocational Technical 250502000744 8180605 Franklin County Technical   Vocational Education School No 3 09 12 2015   grade_9 128 1 4 0   1     0   2   96 40                       136 128 1 4 0   1     0   2   96 40                 136
736803 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No 3 09 12 2015   grade_9 13 115 110 1   33     0   5   168 109                       277 13 115 110 1   33     0   5   168 109                 277
736860 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative Education School No 3 09 12 2015   grade_9 13 41 43 1   2     0   2   36 66                       102 13 41 43 1   2     0   2   36 66                 102
738369 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative Education School No 3 09 12 2015   grade_9 13 0 0 0   1     0   0   9 5                       14 13 0 0 0   1     0   0   9 5                 14
738992 MA Essex   school 2506660 149   Lawrence 250666002618 1490533 Math, Science & Technology High School   Regular School No 3 09 12 2015   grade_9 13 2 137 0   8     0   1   118 43                       161 13 2 137 0   8     0   1   118 43                 161
745166 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 4 07 10 2015   grade_9 13 33 2 0   13     0   3   33 31                       64 13 33 2 0   13     0   3   33 31                 64
742055 MA Middlesex   school 2511220 284   Stoneham 251122002295 2840505 Stoneham High   Regular School No 3 09 12 2015   grade_9 130 3 8 1   7     0   6   60 95                       155 130 3 8 1   7     0   6   60 95                 155
742179 MA Essex   school 2511430 291   Swampscott 251143001887 2910505 Swampscott High   Regular School No 3 09 12 2015   grade_9 131 7 18 0   4     2   1   81 82                       163 131 7 18 0   4     2   1   81 82                 163
741304 MA Plymouth   school 2510170 251   Rockland 251017001643 2510505 Rockland Senior High   Regular School No 3 09 12 2015   grade_9 132 7 7 0   2     0   9   83 74                       157 132 7 7 0   2     0   9   83 74                 157
739606 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No 3 09 12 2015   grade_9 133 97 138 2   117     0   15   274 228                       502 133 97 138 2   117     0   15   274 228                 502
735866 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No 3 09 12 2015   grade_9 138 3 9 1   17     0   6   91 83                       174 138 3 9 1   17     0   6   91 83                 174
737590 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee High   Regular School No 3 09 12 2015   grade_9 139 6 83 0   11     1   4   112 132                       244 139 6 83 0   11     1   4   112 132                 244
744461 MA Dukes   school 2507380 700   Martha's Vineyard 250738001145 7000505 Martha's Vineyard Regional High   Regular School No 3 09 12 2015   grade_9 139 5 13 4   4     0   13   92 86                       178 139 5 13 4   4     0   13   92 86                 178
736894 MA Suffolk   school 2502790 35   Boston 250279001898 350579 Urban Science Academy   Regular School No 3 09 12 2015   grade_9 14 63 55 0   1     0   3   82 54                       136 14 63 55 0   1     0   3   82 54                 136
736930 MA Suffolk   school 2502790 35   Boston 250279002729 350658 West Roxbury Academy   Regular School No 3 09 12 2015   grade_9 14 62 58 1   2     0   4   75 66                       141 14 62 58 1   2     0   4   75 66                 141
737550 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative Education School No 4 06 12 2015   grade_9 14 0 13 0   0     0   0   17 10                       27 14 0 13 0   0     0   0   17 10                 27
743845 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes 4 KG 12 2015   grade_9 14 49 20 0   6     0   2   43 48                       91 14 49 20 0   6     0   2   43 48                 91
744771 MA Worcester   school 2509900 755   Ralph C Mahar 250990002707 7550525 The Gateway to College   Regular School No 3 09 12 2015   grade_9 14 0 2 0   0     1   0   6 11                       17 14 0 2 0   0     1   0   6 11                 17
739102 MA Worcester   school 2506780 153   Leominster 250678000987 1530505 Leominster High School   Regular School No 3 09 12 2015   grade_9 140 16 33 0   4     0   3   95 101                       196 140 16 33 0   4     0   3   95 101                 196
738028 MA Bristol   school 2504800 94   Fairhaven 250480000642 940505 Fairhaven High   Regular School No 3 09 12 2015   grade_9 141 1 14 0   2     0   4   84 78                       162 141 1 14 0   2     0   4   84 78                 162
739556 MA Essex   school 2507140 164   Lynnfield 250714001090 1640505 Lynnfield High   Regular School No 3 09 12 2015   grade_9 141 3 6 0   4     0   2   72 84                       156 141 3 6 0   4     0   2   72 84                 156
745097 MA Bristol   school 2509140 855   Old Colony Regional Vocational Technical 250914001471 8550605 Old Colony Regional Vocational Technical   Vocational Education School No 3 09 12 2015   grade_9 141 1 0 0   2     0   0   91 53                       144 141 1 0 0   2     0   0   91 53                 144
740610 MA Worcester   school 2508940 214   Northbridge 250894001445 2140505 Northbridge High   Regular School No 3 09 12 2015   grade_9 142 0 22 0   3     0   3   88 82                       170 142 0 22 0   3     0   3   88 82                 170
744489 MA Worcester   school 2507680 710   Mendon-Upton 250768001202 7100510 Nipmuc Regional High   Regular School No 3 09 12 2015   grade_9 142 0 3 0   4     0   4   77 76                       153 142 0 3 0   4     0   4   77 76                 153
742724 MA Hampden   school 2512630 325   Westfield 251263002074 3250605 Westfield Vocational Technical High   Vocational Education School No 3 09 12 2015   grade_9 143 4 2 0   0     0   0   83 66                       149 143 4 2 0   0     0   0   83 66                 149
743389 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester Technical High   Vocational Education School No 3 09 12 2015   grade_9 144 45 145 0   24     0   12   165 205                       370 144 45 145 0   24     0   12   165 205                 370
740952 MA Berkshire   school 2509630 236   Pittsfield 250963001534 2360510 Taconic High   Regular School No 3 09 12 2015   grade_9 145 18 15 0   2     0   13   91 102                       193 145 18 15 0   2     0   13   91 102                 193
735931 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No 3 09 12 2015   grade_9 146 5 12 0   5     0   3   73 98                       171 146 5 12 0   5     0   3   73 98                 171
740948 MA Berkshire   school 2509630 236   Pittsfield 250963001526 2360505 Pittsfield High   Regular School No 3 09 12 2015   grade_9 146 32 24 0   4     0   15   120 101                       221 146 32 24 0   4     0   15   120 101                 221
735730 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No 3 09 12 2015   grade_9 147 0 8 0   1     0   4   91 69                       160 147 0 8 0   1     0   4   91 69                 160
744231 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000574 6550505 Dover-Sherborn Regional High   Regular School No 3 09 12 2015   grade_9 149 4 5 0   13     0   5   77 99                       176 149 4 5 0   13     0   5   77 99                 176
737169 MA Plymouth   school 2503090 44   Brockton 250309002652 440515 Brockton Champion High School   Regular School No 3 08 12 2015   grade_9 15 22 20 1   1     0   6   42 23                       65 15 22 20 1   1     0   6   42 23                 65
743993 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No 3 09 12 2015   grade_9 150 15 32 0   24     0   23   139 105                       244 150 15 32 0   24     0   23   139 105                 244
745101 MA Hampden   school 2509310 860   Pathfinder Regional Vocational Technical 250931002285 8600605 Pathfinder Vocational Technical   Vocational Education School No 3 09 12 2015   grade_9 153 1 12 1   2     0   7   103 73                       176 153 1 12 1   2     0   7   103 73                 176
740690 MA Plymouth   school 2509030 219   Norwell 250903001455 2190505 Norwell High   Regular School No 3 09 12 2015   grade_9 156 0 5 0   1     0   2   85 79                       164 156 0 5 0   1     0   2   85 79                 164
737855 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No 3 07 12 2015   grade_9 157 9 3 0   0     2   2   82 91                       173 157 9 3 0   0     2   2   82 91                 173
744201 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No 3 08 12 2015   grade_9 157 15 20 1   8     0   10   113 98                       211 157 15 20 1   8     0   10   113 98                 211
740019 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton High   Regular School No 3 09 12 2015   grade_9 158 65 8 0   17     3   10   129 132                       261 158 65 8 0   17     3   10   129 132                 261
742541 MA Middlesex   school 2512210 315   Wayland 251221002010 3150505 Wayland High School   Regular School No 3 09 12 2015   grade_9 158 10 6 0   34     1   9   115 103                       218 158 10 6 0   34     1   9   115 103                 218
745035 MA Norfolk   school 2502740 806   Blue Hills Regional Vocational Technical 250274000193 8060605 Blue Hills Regional Vocational Technical   Vocational Education School No 3 09 12 2015   grade_9 158 41 22 2   1     0   13   120 117                       237 158 41 22 2   1     0   13   120 117                 237
735988 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No 3 09 12 2015   grade_9 159 20 11 0   30     0   10   99 131                       230 159 20 11 0   30     0   10   99 131                 230

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