enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
736894 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
736899 736899 MA Suffolk   school 2502790 35   Boston 250279001902 350581 Community Academy of Science and Health   Regular School No 3 09 12 2015   grade_9 3 75 22 0   1     0   1   62 40                       102 3 75 22 0   1     0   1   62 40                 102
736904 736904 MA Suffolk   school 2502790 35   Boston 250279002676 350651 Dorchester Academy   Regular School No 3 09 12 2015   grade_9 3 55 27 0   2     0   2   52 37                       89 3 55 27 0   2     0   2   52 37                 89
736909 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
736960 736960 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2015   grade_9 2 0 3 0   0     0   1   3 3                       6 2 0 3 0   0     0   1   3 3                 6
736979 736979 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No 3 09 12 2015   grade_9 98 1 3 0   1     0   6   55 54                       109 98 1 3 0   1     0   6   55 54                 109
737130 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
737142 737142 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative Education School No 4 04 12 2015   grade_9 7 3 5 0   0     0   0   10 5                       15 7 3 5 0   0     0   0   10 5                 15
737173 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
737264 737264 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No 3 09 12 2015   grade_9 288 37 50 0   70     0   49   259 235                       494 288 37 50 0   70     0   49   259 235                 494
737428 737428 MA Norfolk   school 2503300 50   Canton 250330000451 500505 Canton High   Regular School No 3 09 12 2015   grade_9 180 25 10 0   24     1   7   130 117                       247 180 25 10 0   24     1   7   130 117                 247
737486 737486 MA Middlesex   school 2503510 56   Chelmsford 250351000475 560505 Chelmsford High   Regular School No 3 09 12 2015   grade_9 316 5 7 0   44     0   7   178 201                       379 316 5 7 0   44     0   7   178 201                 379
737520 737520 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No 3 09 12 2015   grade_9 28 39 510 0   12     0   3   324 268                       592 28 39 510 0   12     0   3   324 268                 592
737550 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
737590 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
737704 737704 MA Essex   school 2503990 71   Danvers 250399000529 710505 Danvers High   Regular School No 3 09 12 2015   grade_9 209 7 10 0   3     1   4   120 114                       234 209 7 10 0   3     1   4   120 114                 234
737731 737731 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth High   Regular School No 3 09 12 2015   grade_9 228 5 2 0   11     0   4   127 123                       250 228 5 2 0   11     0   4   127 123                 250
737762 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
737784 737784 MA Worcester   school 2504230 77   Douglas 250423000570 770505 Douglas High School   Regular School No 3 09 12 2015   grade_9 99 0 2 0   0     0   0   52 49                       101 99 0 2 0   0     0   0   52 49                 101
737822 737822 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut Senior High   Regular School No 3 09 12 2015   grade_9 170 6 12 0   7     0   3   87 111                       198 170 6 12 0   7     0   3   87 111                 198
737841 737841 MA Plymouth   school 2504410 82   Duxbury 250441000594 820505 Duxbury High   Regular School No 3 09 12 2015   grade_9 290 0 3 0   0     0   2   148 147                       295 290 0 3 0   0     0   2   148 147                 295
737855 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
737886 737886 MA Hampshire   school 2504590 86   Easthampton 250459000612 860505 Easthampton High   Regular School No 3 09 12 2015   grade_9 87 5 8 0   6     0   0   52 54                       106 87 5 8 0   6     0   0   52 54                 106
737904 737904 MA Hampden   school 2504500 87   East Longmeadow 250450000603 870505 East Longmeadow High   Regular School No 3 09 12 2015   grade_9 190 7 6 0   8     0   1   100 112                       212 190 7 6 0   8     0   1   100 112                 212
737986 737986 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No 4 01 12 2015   grade_9 2 1 4 0   0     0   0   5 2                       7 2 1 4 0   0     0   0   5 2                 7
738028 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
738114 738114 MA Bristol   school 2504830 95   Fall River 250483002660 950325 Resiliency Preparatory School   Regular School No 3 09 12 2015   grade_9 40 10 14 0   1     0   3   46 22                       68 40 10 14 0   1     0   3   46 22                 68
738194 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
738199 738199 MA Worcester   school 2504890 97   Fitchburg 250489002110 970510 Goodrich Academy   Regular School No 3 09 12 2015   grade_9 5 0 2 0   0     0   0   5 2                       7 5 0 2 0   0     0   0   5 2                 7
738233 738233 MA Norfolk   school 2504950 99   Foxborough 250495000708 990505 Foxborough High   Regular School No 3 09 12 2015   grade_9 171 14 2 0   3     1   0   104 87                       191 171 14 2 0   3     1   0   104 87                 191
738364 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
738369 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
738383 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
738421 738421 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester High   Regular School No 3 09 12 2015   grade_9 205 2 22 0   3     5   4   118 123                       241 205 2 22 0   3     5   4   118 123                 241
738445 738445 MA Worcester   school 2505370 110   Grafton 250537000786 1100505 Grafton High School   Regular School No 3 09 12 2015   grade_9 185 0 6 0   17     0   4   99 113                       212 185 0 6 0   17     0   4   99 113                 212
738460 738460 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No 3 07 12 2015   grade_9 58 0 3 0   2     0   0   25 38                       63 58 0 3 0   2     0   0   25 38                 63
738486 738486 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield High   Regular School No 3 08 12 2015   grade_9 68 1 20 0   2     0   1   42 50                       92 68 1 20 0   2     0   1   42 50                 92
738501 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
738535 738535 MA Plymouth   school 2505790 122   Hanover 250579000829 1220505 Hanover High   Regular School No 3 09 12 2015   grade_9 185 1 2 0   2     0   1   102 89                       191 185 1 2 0   2     0   1   102 89                 191
738550 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 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
738631 738631 MA Essex   school 2505970 128   Haverhill 250597000856 1280505 Haverhill High   Regular School No 3 09 12 2015   grade_9 314 10 110 0   6     0   3   234 209                       443 314 10 110 0   6     0   3   234 209                 443
738664 738664 MA Plymouth   school 2506090 131   Hingham 250609000872 1310505 Hingham High   Regular School No 3 09 12 2015   grade_9 304 4 8 0   12     0   9   169 168                       337 304 4 8 0   12     0   9   169 168                 337
738679 738679 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Jr Sr High   Regular School No 3 07 12 2015   grade_9 36 23 7 0   3     0   6   42 33                       75 36 23 7 0   3     0   6   42 33                 75
738702 738702 MA Middlesex   school 2506240 136   Holliston 250624000894 1360505 Holliston High   Regular School No 3 09 12 2015   grade_9 178 2 2 0   8     0   5   96 99                       195 178 2 2 0   8     0   5   96 99                 195
738773 738773 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke High   Regular School No 3 09 12 2015   grade_9 96 14 280 0   6     0   9   224 181                       405 96 14 280 0   6     0   9   224 181                 405
738777 738777 MA Hampden   school 2506270 137   Holyoke 250627000913 1370605 Wm J Dean Vocational Technical High   Vocational Education School No 3 09 12 2015   grade_9 5 0 116 0   1     0   0   66 56                       122 5 0 116 0   1     0   0   66 56                 122
738791 738791 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No 3 07 12 2015   grade_9 89 0 0 0   1     0   0   44 46                       90 89 0 0 0   1     0   0   44 46                 90
738846 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
738867 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
738979 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
738983 738983 MA Essex   school 2506660 149   Lawrence 250666002636 1490531 Health & Human Services High School   Regular School No 3 09 12 2015   grade_9 5 2 151 0   3     0   0   53 108                       161 5 2 151 0   3     0   0   53 108                 161
738987 738987 MA Essex   school 2506660 149   Lawrence 250666002633 1490532 Humanities & Leadership Development High School   Regular School No 3 09 12 2015   grade_9 5 3 164 0   3     0   0   99 76                       175 5 3 164 0   3     0   0   99 76                 175
738992 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
738996 738996 MA Essex   school 2506660 149   Lawrence 250666002631 1490534 International High School   Regular School No 3 09 12 2015   grade_9 2 1 124 0   0     0   0   69 58                       127 2 1 124 0   0     0   0   69 58                 127
739000 739000 MA Essex   school 2506660 149   Lawrence 250666002616 1490535 Performing & Fine Arts High School   Regular School No 3 09 12 2015   grade_9 6 3 114 0   0     0   0   44 79                       123 6 3 114 0   0     0   0   44 79                 123
739005 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
739017 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
739022 739022 MA Essex   school 2506660 149   Lawrence 250666002749 1490540 Phoenix Academy Lawrence   Alternative Education School No 3 09 12 2015   grade_9 4 4 86 0   2     0   0   53 43                       96 4 4 86 0   2     0   0   53 43                 96
739036 739036 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No 3 07 12 2015   grade_9 50 0 3 0   0     0   1   28 26                       54 50 0 3 0   0     0   1   28 26                 54
739050 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
739064 739064 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No 4 06 12 2015   grade_9 56 0 3 0   4     0   1   33 31                       64 56 0 3 0   4     0   1   33 31                 64
739102 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
739197 739197 MA Middlesex   school 2506960 158   Littleton 250696001012 1580505 Littleton High School   Regular School No 3 09 12 2015   grade_9 93 3 2 0   3     1   3   52 53                       105 93 3 2 0   3     1   3   52 53                 105
739226 739226 MA Hampden   school 2506990 159   Longmeadow 250699001020 1590505 Longmeadow High   Regular School No 3 09 12 2015   grade_9 198 10 8 0   20     0   2   122 116                       238 198 10 8 0   20     0   2   122 116                 238
739340 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
739390 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
739522 739522 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No 3 09 12 2015   grade_9 93 52 313 0   25     0   23   293 213                       506 93 52 313 0   25     0   23   293 213                 506
739529 739529 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No 3 07 12 2015   grade_9 6 6 17 0   4     0   2   18 17                       35 6 6 17 0   4     0   2   18 17                 35
739556 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
739644 739644 MA Essex   school 2507260 168   Marblehead 250726001124 1680505 Marblehead High   Regular School No 3 09 12 2015   grade_9 216 17 15 0   1     0   2   111 140                       251 216 17 15 0   1     0   2   111 140                 251
739677 739677 MA Middlesex   school 2507320 170   Marlborough 250732001133 1700505 Marlborough High   Regular School No 3 09 12 2015   grade_9 161 12 106 0   16     0   2   148 149                       297 161 12 106 0   16     0   2   148 149                 297
739753 739753 MA Middlesex   school 2507500 174   Maynard 250750001153 1740505 Maynard High   Regular School No 3 08 12 2015   grade_9 71 6 11 0   4     0   3   37 58                       95 71 6 11 0   4     0   3   37 58                 95
739767 739767 MA Norfolk   school 2507530 175   Medfield 250753001157 1750505 Medfield Senior High   Regular School No 3 09 12 2015   grade_9 206 1 2 0   9     1   7   103 123                       226 206 1 2 0   9     1   7   103 123                 226
739806 739806 MA Middlesex   school 2507560 176   Medford 250756001176 1760505 Medford High   Regular School No 3 09 12 2015   grade_9 197 63 39 0   35     0   9   163 180                       343 197 63 39 0   35     0   9   163 180                 343
739814 739814 MA Middlesex   school 2507560 176   Medford 250756001174 1760605 Medford Vocational Technical High   Vocational Education School No 3 09 12 2015   grade_9 37 4 3 0   1     0   4   24 25                       49 37 4 3 0   1     0   4   24 25                 49
739866 739866 MA Middlesex   school 2507620 178   Melrose 250762001193 1780505 Melrose High   Regular School No 3 09 12 2015   grade_9 183 23 13 0   6     0   8   111 122                       233 183 23 13 0   6     0   8   111 122                 233
739930 739930 MA Plymouth   school 2507770 182   Middleborough 250777001227 1820505 Middleborough High   Regular School No 3 09 12 2015   grade_9 177 4 5 0   0     0   5   95 96                       191 177 4 5 0   0     0   5   95 96                 191
740019 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
740057 740057 MA Nantucket   school 2508250 197   Nantucket 250825001282 1970505 Nantucket High   Regular School No 3 09 12 2015   grade_9 83 18 30 0   2     0   3   75 61                       136 83 18 30 0   2     0   3   75 61                 136
740096 740096 MA Middlesex   school 2508340 198   Natick 250834001303 1980505 Natick High   Regular School No 3 09 12 2015   grade_9 334 13 13 0   21     1   14   199 197                       396 334 13 13 0   21     1   14   199 197                 396
740134 740134 MA Norfolk   school 2508370 199   Needham 250837001315 1990505 Needham High   Regular School No 3 09 12 2015   grade_9 331 14 21 0   25     1   5   205 192                       397 331 14 21 0   25     1   5   205 192                 397
740281 740281 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No 3 07 12 2015   grade_9 7 0 3 0   0     0   0   9 1                       10 7 0 3 0   0     0   0   9 1                 10
740288 740288 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No 4 06 12 2015   grade_9 6 6 9 0   0     0   4   22 3                       25 6 6 9 0   0     0   4   22 3                 25
740301 740301 MA Essex   school 2508580 204   Newburyport 250858001354 2040505 Newburyport High   Regular School No 3 09 12 2015   grade_9 177 2 8 0   1     0   7   94 101                       195 177 2 8 0   1     0   7   94 101                 195
740409 740409 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No 3 09 12 2015   grade_9 368 25 44 0   81     2   19   275 264                       539 368 25 44 0   81     2   19   275 264                 539
740414 740414 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No 3 09 12 2015   grade_9 299 16 24 0   87     0   18   212 232                       444 299 16 24 0   87     0   18   212 232                 444
740453 740453 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No 3 08 12 2015   grade_9 65 2 5 0   0     0   6   37 41                       78 65 2 5 0   0     0   6   37 41                 78
740485 740485 MA Hampshire   school 2508850 210   Northampton 250885001432 2100505 Northampton High   Regular School No 3 09 12 2015   grade_9 180 6 29 0   13     0   6   105 129                       234 180 6 29 0   13     0   6   105 129                 234
740610 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
740625 740625 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield High   Regular School No 3 07 12 2015   grade_9 24 2 2 0   0     0   1   15 14                       29 24 2 2 0   0     0   1   15 14                 29
740651 740651 MA Middlesex   school 2508820 217   North Reading 250882001422 2170505 North Reading High   Regular School No 3 09 12 2015   grade_9 206 1 7 0   9     2   1   103 123                       226 206 1 7 0   9     2   1   103 123                 226
740669 740669 MA Bristol   school 2509000 218   Norton 250900001451 2180505 Norton High   Regular School No 3 09 12 2015   grade_9 186 4 2 0   3     0   0   99 96                       195 186 4 2 0   3     0   0   99 96                 195
740690 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
740724 740724 MA Norfolk   school 2509060 220   Norwood 250906001466 2200505 Norwood High   Regular School No 3 09 12 2015   grade_9 185 26 18 0   8     0   5   119 123                       242 185 26 18 0   8     0   5   119 123                 242
740782 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
740843 740843 MA Essex   school 2509360 229   Peabody 250936001504 2290510 Peabody Veterans Memorial High   Regular School No 3 09 12 2015   grade_9 278 16 70 0   10     0   10   189 195                       384 278 16 70 0   10     0   10   189 195                 384
740878 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
740948 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
740952 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

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