enrollments

Data source: Big Local News · About: Big Local

396 rows where grade = "grade_9", state = "MA" and year = 2019 sorted by native_american_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 396 ✖

grade ✖

  • grade_9 · 396 ✖
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int ▼ native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2040388 2040388 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No High 07 12 2019   grade_9 * * * *   *     *   *   2 2                       4.0                         2 2                 4
2041276 2041276 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Frederick Douglass Academy   Regular School No Secondary 07 11 2019   grade_9 * * * *   *     *   *   4 *                       4.0                         4                   4
2041676 2041676 MA Suffolk   school 2503540 57   Chelsea 250354002890 570515 Chelsea Opportunity Academy   Alternative School No High 09 12 2019   grade_9 * * * *   *     *   *   1 4                       5.0                         1 4                 5
2042773 2042773 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_9 * * * *   *     *   *   2 *                       2.0                         2                   2
2043474 2043474 MA Middlesex   school 2507020 160   Lowell 250702002732 1600320 Leblanc Therapeutic Day School   Regular School No High 09 12 2019   grade_9 * * * *   *     *   *   2 2                       4.0                         2 2                 4
2043952 2043952 MA Middlesex   school 2507560 176   Medford 250756002393 1760510 Curtis-Tufts   Regular School No High 09 12 2019   grade_9 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2044888 2044888 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Project C.O.F.F.E.E.   Special Education School No High 09 12 2019   grade_9 * * * *   *     *   *   2 *                       2.0                         2                   2
2046137 2046137 MA Hampden   school 2511130 281   Springfield 251113002734 2810560 Liberty Preparatory Academy   Regular School No High 09 12 2019   grade_9 * * * *   *     *   *   2 *                       3.0                         2                   3
2046144 2046144 MA Hampden   school 2511130 281   Springfield 251113002743 2810575 Gateway to College at Holyoke Community College   Regular School No High 09 12 2019   grade_9 * * * *   *     *   *   * 1                       1.0                           1                 1
2048251 2048251 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No High 06 12 2019   grade_9 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2039820 2039820 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2019   grade_9 134 8 12 0   4     0   1   82 77                       159.0 134 8 12 0   4     0   1   82 77                 159
2039881 2039881 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2019   grade_9 119 2 6 0   2     0   5   68 66                       134.0 119 2 6 0   2     0   5   68 66                 134
2039886 2039886 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2019   grade_9 9 0 2 0   0     0   1   8 4                       12.0 9 0 2 0   0     0   1   8 4                 12
2040003 2040003 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2019   grade_9 270 15 18 0   39     0   22   175 189                       364.0 270 15 18 0   39     0   22   175 189                 364
2040081 2040081 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No High 09 12 2019   grade_9 141 4 14 0   6     0   8   77 96                       173.0 141 4 14 0   6     0   8   77 96                 173
2040096 2040096 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2019   grade_9 22 24 3 0   3     0   4   33 23                       56.0 22 24 3 0   3     0   4   33 23                 56
2040138 2040138 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No High 09 12 2019   grade_9 160 18 16 0   39     0   9   117 125                       242.0 160 18 16 0   39     0   9   117 125                 242
2040152 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
2040171 2040171 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No High 08 12 2019   grade_9 126 4 3 0   3     0   5   65 76                       141.0 126 4 3 0   3     0   5   65 76                 141
2040176 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
2040205 2040205 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont High   Regular School No High 09 12 2019   grade_9 235 11 17 0   58     0   23   170 174                       344.0 235 11 17 0   58     0   23   170 174                 344
2040256 2040256 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly High   Regular School No High 09 12 2019   grade_9 283 14 42 0   8     0   12   198 161                       359.0 283 14 42 0   8     0   12   198 161                 359
2040431 2040431 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No High 06 12 2019   grade_9 2 51 24 0   2     1   2   41 41                       82.0 2 51 24 0   2     1   2   41 41                 82
2040826 2040826 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_9 1 25 25 0   2     0   3   44 12                       56.0 1 25 25 0   2     0   3   44 12                 56
2040948 2040948 MA Suffolk   school 2502790 35   Boston 250279002015 350507 Boston International High School   Regular School No High 09 12 2019   grade_9 2 45 78 0   8     0   0   76 57                       133.0 2 45 78 0   8     0   0   76 57                 133
2040952 2040952 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No High 09 12 2019   grade_9 12 54 175 0   7     0   4   128 124                       252.0 12 54 175 0   7     0   4   128 124                 252
2040957 2040957 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Community Academy   Regular School No High 09 12 2019   grade_9 0 7 4 0   0     0   0   6 5                       11.0 0 7 4 0   0     0   0   6 5                 11
2040961 2040961 MA Suffolk   school 2502790 35   Boston 250279002016 350522 Excel High School   Regular School No High 09 12 2019   grade_9 11 56 41 0   17     0   3   73 55                       128.0 11 56 41 0   17     0   3   73 55                 128
2040965 2040965 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Jeremiah E Burke High   Regular School No High 09 12 2019   grade_9 5 44 32 0   1     0   1   50 33                       83.0 5 44 32 0   1     0   1   50 33                 83
2040969 2040969 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No High 09 12 2019   grade_9 29 19 229 0   8     0   7   167 125                       292.0 29 19 229 0   8     0   7   167 125                 292
2040988 2040988 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Another Course To College   Alternative School No High 09 12 2019   grade_9 4 32 25 0   1     0   0   31 31                       62.0 4 32 25 0   1     0   0   31 31                 62
2040999 2040999 MA Suffolk   school 2502790 35   Boston 250279000837 350543 Greater Egleston Community High School   Regular School No High 09 12 2019   grade_9 0 6 6 0   0     0   0   7 5                       12.0 0 6 6 0   0     0   0   7 5                 12
2041005 2041005 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No High 07 12 2019   grade_9 76 70 83 0   57     0   12   126 172                       298.0 76 70 83 0   57     0   12   126 172                 298
2041009 2041009 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative School No High 09 12 2019   grade_9 16 53 36 0   3     0   6   38 76                       114.0 16 53 36 0   3     0   6   38 76                 114
2041015 2041015 MA Suffolk   school 2502790 35   Boston 250279002753 350549 Margarita Muniz Academy   Regular School No High 09 12 2019   grade_9 0 6 78 0   0     0   1   42 43                       85.0 0 6 78 0   0     0   1   42 43                 85
2041019 2041019 MA Suffolk   school 2502790 35   Boston 250279001692 350558 Boston Community Leadership Academy   Regular School No High 09 12 2019   grade_9 3 50 75 0   1     0   3   78 54                       132.0 3 50 75 0   1     0   3   78 54                 132
2041026 2041026 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2019   grade_9 166 34 53 0   129     0   25   175 232                       407.0 166 34 53 0   129     0   25   175 232                 407
2041054 2041054 MA Suffolk   school 2502790 35   Boston 250279002674 350655 Lyon Upper 9-12   Regular School No High 09 12 2019   grade_9 10 5 13 0   2     0   0   21 9                       30.0 10 5 13 0   2     0   0   21 9                 30
2041071 2041071 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No High 06 12 2019   grade_9 1 77 42 0   1     0   6   83 44                       127.0 1 77 42 0   1     0   6   83 44                 127
2041081 2041081 MA Suffolk   school 2502790 35   Boston 250279000217 350690 Snowden International School at Copley   Regular School No High 09 12 2019   grade_9 10 62 78 0   8     0   2   86 74                       160.0 10 62 78 0   8     0   2   86 74                 160
2041102 2041102 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2019   grade_9 1 2 3 0   1     0   0   4 3                       7.0 1 2 3 0   1     0   0   4 3                 7
2041189 2041189 MA Norfolk   school 2502940 40   Braintree 250294000361 400505 Braintree High   Regular School No High 09 12 2019   grade_9 294 13 19 0   79     2   7   205 209                       414.0 294 13 19 0   79     2   7   205 209                 414
2041290 2041290 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 03 12 2019   grade_9 1 4 2 0   0     0   2   6 3                       9.0 1 4 2 0   0     0   2   6 3                 9
2041316 2041316 MA Plymouth   school 2503090 44   Brockton 250309002652 440515 Brockton Champion High School   Alternative School No High 09 12 2019   grade_9 10 10 17 0   0     0   2   26 13                       39.0 10 10 17 0   0     0   2   26 13                 39
2041321 2041321 MA Plymouth   school 2503090 44   Brockton 250309002752 440520 Edison Academy   Regular School No High 09 12 2019   grade_9 0 28 4 0   0     1   0   21 12                       33.0 0 28 4 0   0     1   0   21 12                 33
2041412 2041412 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2019   grade_9 326 29 65 0   75     1   58   296 255                       554.0 326 29 65 0   75     1   58   296 255                 554
2041576 2041576 MA Norfolk   school 2503300 50   Canton 250330000451 500505 Canton High   Regular School No High 09 12 2019   grade_9 169 28 18 0   28     0   5   112 136                       248.0 169 28 18 0   28     0   5   112 136                 248
2041601 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
2041635 2041635 MA Middlesex   school 2503510 56   Chelmsford 250351000475 560505 Chelmsford High   Regular School No High 09 12 2019   grade_9 260 11 15 0   64     1   5   170 186                       356.0 260 11 15 0   64     1   5   170 186                 356
2041704 2041704 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No High 07 12 2019   grade_9 7 1 25 0   0     0   0   18 15                       33.0 7 1 25 0   0     0   0   18 15                 33
2041744 2041744 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee High   Regular School No High 09 12 2019   grade_9 142 13 124 0   4     0   5   145 143                       288.0 142 13 124 0   4     0   5   145 143                 288
2041748 2041748 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee Comprehensive High School   Regular School No High 09 12 2019   grade_9 191 5 72 0   6     0   6   152 128                       280.0 191 5 72 0   6     0   6   152 128                 280
2041772 2041772 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton Senior High   Regular School No High 09 12 2019   grade_9 60 3 32 0   2     0   3   51 49                       100.0 60 3 32 0   2     0   3   51 49                 100
2041884 2041884 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth High   Regular School No High 09 12 2019   grade_9 242 5 11 0   1     0   22   136 145                       281.0 242 5 11 0   1     0   22   136 145                 281
2041913 2041913 MA Norfolk   school 2504050 73   Dedham 250405000548 730505 Dedham High   Regular School No High 09 12 2019   grade_9 124 9 31 0   2     0   4   95 75                       170.0 124 9 31 0   2     0   4   95 75                 170
2041935 2041935 MA Worcester   school 2504230 77   Douglas 250423000570 770505 Douglas High School   Regular School No High 09 12 2019   grade_9 86 1 3 0   2     1   2   51 44                       95.0 86 1 3 0   2     1   2   51 44                 95
2041974 2041974 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut Senior High   Regular School No High 09 12 2019   grade_9 165 27 18 0   19     0   6   120 115                       235.0 165 27 18 0   19     0   6   120 115                 235
2042035 2042035 MA Hampshire   school 2504590 86   Easthampton 250459000612 860505 Easthampton High   Regular School No High 09 12 2019   grade_9 94 1 16 0   4     0   3   56 61                       118.0 94 1 16 0   4     0   3   56 61                 118
2042053 2042053 MA Hampden   school 2504500 87   East Longmeadow 250450000603 870505 East Longmeadow High   Regular School No High 09 12 2019   grade_9 174 7 17 0   15     0   1   107 107                       214.0 174 7 17 0   15     0   1   107 107                 214
2042139 2042139 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2019   grade_9 2 0 4 0   0     0   1   6 1                       7.0 2 0 4 0   0     0   1   6 1                 7
2042182 2042182 MA Bristol   school 2504800 94   Fairhaven 250480000642 940505 Fairhaven High   Regular School No High 09 12 2019   grade_9 160 5 8 0   3     0   3   92 87                       179.0 160 5 8 0   3     0   3   92 87                 179
2042272 2042272 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2019   grade_9 1 4 3 0   0     0   1   7 2                       9.0 1 4 3 0   0     0   1   7 2                 9
2042351 2042351 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg High   Regular School No High 09 12 2019   grade_9 77 13 144 0   16     0   23   152 121                       273.0 77 13 144 0   16     0   23   152 121                 273
2042356 2042356 MA Worcester   school 2504890 97   Fitchburg 250489002110 970510 Goodrich Academy   Regular School No High 09 12 2019   grade_9 5 1 5 0   0     0   0   5 6                       11.0 5 1 5 0   0     0   0   5 6                 11
2042509 2042509 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2019   grade_9 383 6 15 0   33     2   6   221 224                       445.0 383 6 15 0   33     2   6   221 224                 445
2042529 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
2042543 2042543 MA Essex   school 2505220 105   Georgetown 250522000764 1050505 Georgetown High School   Regular School No High 09 12 2019   grade_9 90 1 4 0   2     0   0   50 47                       97.0 90 1 4 0   2     0   0   50 47                 97
2042581 2042581 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester High   Regular School No High 09 12 2019   grade_9 193 5 32 0   2     2   4   131 107                       238.0 193 5 32 0   2     2   4   131 107                 238
2042604 2042604 MA Worcester   school 2505370 110   Grafton 250537000786 1100505 Grafton High School   Regular School No High 09 12 2019   grade_9 194 4 9 0   27     0   8   118 124                       242.0 194 4 9 0   27     0   8   118 124                 242
2042619 2042619 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No High 07 12 2019   grade_9 58 1 5 0   0     0   0   36 28                       64.0 58 1 5 0   0     0   0   36 28                 64
2042690 2042690 MA Plymouth   school 2505790 122   Hanover 250579000829 1220505 Hanover High   Regular School No High 09 12 2019   grade_9 186 1 2 0   5     0   0   105 89                       194.0 186 1 2 0   5     0   0   105 89                 194
2042705 2042705 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No High 06 12 2019   grade_9 75 1 7 0   17     0   3   44 59                       103.0 75 1 7 0   17     0   3   44 59                 103
2042719 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
2042746 2042746 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill Alternative School   Regular School No High 07 12 2019   grade_9 4 0 4 0   0     0   0   7 1                       8.0 4 0 4 0   0     0   0   7 1                 8
2042795 2042795 MA Essex   school 2505970 128   Haverhill 250597000856 1280505 Haverhill High   Regular School No High 09 12 2019   grade_9 270 27 184 0   7     0   6   251 243                       494.0 270 27 184 0   7     0   6   251 243                 494
2042828 2042828 MA Plymouth   school 2506090 131   Hingham 250609000872 1310505 Hingham High   Regular School No High 09 12 2019   grade_9 300 8 12 0   8     0   12   179 161                       340.0 300 8 12 0   8     0   12   179 161                 340
2042843 2042843 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Middle High School   Regular School No High 06 12 2019   grade_9 33 21 11 0   7     0   6   37 41                       78.0 33 21 11 0   7     0   6   37 41                 78
2042866 2042866 MA Middlesex   school 2506240 136   Holliston 250624000894 1360505 Holliston High   Regular School No High 09 12 2019   grade_9 181 3 8 0   21     0   5   100 118                       218.0 181 3 8 0   21     0   5   100 118                 218
2042955 2042955 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No High 07 12 2019   grade_9 73 1 6 0   0     0   1   41 40                       81.0 73 1 6 0   0     0   1   41 40                 81
2042995 2042995 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson High   Regular School No High 08 12 2019   grade_9 128 9 18 0   0     1   5   69 92                       161.0 128 9 18 0   0     1   5   69 92                 161
2043009 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
2043032 2043032 MA Essex   school 2506480 144   Ipswich 250648000935 1440505 Ipswich High   Regular School No High 09 12 2019   grade_9 127 2 5 0   1     0   8   64 79                       143.0 127 2 5 0   1     0   8   64 79                 143
2043130 2043130 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2019   grade_9 32 14 912 0   9     0   2   543 420                       969.0 32 14 912 0   9     0   2   543 420                 969
2043139 2043139 MA Essex   school 2506660 149   Lawrence 250666002628 1490536 High School Learning Center   Regular School No High 09 12 2019   grade_9 0 0 7 0   0     0   0   6 1                       7.0 0 0 7 0   0     0   0   6 1                 7
2043148 2043148 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2019   grade_9 1 1 13 0   0     0   0   11 4                       15.0 1 1 13 0   0     0   0   11 4                 15
2043163 2043163 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No High 07 12 2019   grade_9 60 0 4 0   1     0   3   42 26                       68.0 60 0 4 0   1     0   3   42 26                 68
2043178 2043178 MA Worcester   school 2506720 151   Leicester 250672000972 1510505 Leicester High   Regular School No High 09 12 2019   grade_9 113 6 11 0   3     0   3   65 71                       136.0 113 6 11 0   3     0   3   65 71                 136
2043192 2043192 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No High 06 12 2019   grade_9 56 2 2 0   3     0   1   21 43                       64.0 56 2 2 0   3     0   1   21 43                 64
2043233 2043233 MA Worcester   school 2506780 153   Leominster 250678002779 1530515 Leominster Center for Excellence   Regular School No High 09 12 2019   grade_9 7 1 5 0   0     0   2   6 9                       15.0 7 1 5 0   0     0   2   6 9                 15
2043237 2043237 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Center For Technical Education Innovation   Career and Technical School No High 09 12 2019   grade_9 104 20 95 0   9     0   7   167 68                       235.0 104 20 95 0   9     0   7   167 68                 235
2043292 2043292 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No High 09 12 2019   grade_9 286 31 19 0   229     0   33   297 301                       598.0 286 31 19 0   229     0   33   297 301                 598
2043326 2043326 MA Middlesex   school 2506960 158   Littleton 250696001012 1580505 Littleton High School   Regular School No High 09 12 2019   grade_9 91 1 1 0   9     0   3   50 55                       105.0 91 1 1 0   9     0   3   50 55                 105
2043355 2043355 MA Hampden   school 2506990 159   Longmeadow 250699001020 1590505 Longmeadow High   Regular School No High 09 12 2019   grade_9 211 7 11 0   12     0   8   130 119                       249.0 211 7 11 0   12     0   8   130 119                 249
2043493 2043493 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2019   grade_9 221 104 233 0   236     0   30   411 413                       824.0 221 104 233 0   236     0   30   411 413                 824
2043498 2043498 MA Middlesex   school 2507020 160   Lowell 250702002860 1600515 The Career Academy   Regular School No High 09 12 2019   grade_9 6 2 8 0   2     0   0   14 4                       18.0 6 2 8 0   2     0   0   14 4                 18
2043520 2043520 MA Hampden   school 2507050 161   Ludlow 250705001056 1610505 Ludlow Senior High   Regular School No High 09 12 2019   grade_9 214 8 24 0   2     0   8   134 121                       256.0 214 8 24 0   2     0   8   134 121                 256
2043670 2043670 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No High 06 12 2019   grade_9 6 0 14 0   1     0   0   17 4                       21.0 6 0 14 0   1     0   0   17 4                 21
2043697 2043697 MA Essex   school 2507140 164   Lynnfield 250714001090 1640505 Lynnfield High   Regular School No High 09 12 2019   grade_9 132 2 2 0   6     0   0   61 81                       142.0 132 2 2 0   6     0   0   61 81                 142
2043762 2043762 MA Bristol   school 2507230 167   Mansfield 250723001114 1670505 Mansfield High   Regular School No High 09 12 2019   grade_9 229 10 10 0   14     0   11   141 133                       274.0 229 10 10 0   14     0   11   141 133                 274
2043784 2043784 MA Essex   school 2507260 168   Marblehead 250726001124 1680505 Marblehead High   Regular School No High 09 12 2019   grade_9 231 6 15 0   0     0   6   127 131                       258.0 231 6 15 0   0     0   6   127 131                 258

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