enrollments

Data source: Big Local News · About: Big Local

11,284 rows where state = "MA" and year = 2018 sorted by multiracial descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 11,284 ✖
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
2228815 2228815 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam: Agawam Junior High   Regular School No Middle 07 08 2018   grade_8 216 6 24 0   7     0   9   129 133                       262.0 216 6 24 0   7     0   9   129 133                 262
2228817 2228817 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam: Agawam High   Regular School No High 09 12 2018   grade_9 282 5 21 0   1     0   9   159 159                       318.0 282 5 21 0   1     0   9   159 159                 318
2228838 2228838 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury: Amesbury Middle   Regular School No Middle 05 08 2018   grade_7 144 1 12 0   1     0   9   86 81                       167.0 144 1 12 0   1     0   9   86 81                 167
2228841 2228841 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury: Amesbury High   Regular School No High 09 12 2018   grade_9 124 5 15 1   2     0   9   82 74                       156.0 124 5 15 1   2     0   9   82 74                 156
2228858 2228858 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst: Crocker Farm Elementary   Regular School No Elementary PK 06 2018   grade_6 29 5 17 0   5     0   9   29 36                       65.0 29 5 17 0   5     0   9   29 36                 65
2228872 2228872 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Amherst: Wildwood Elementary   Regular School No Elementary KG 06 2018   grade_4 30 4 10 0   3     0   9   28 28                       56.0 30 4 10 0   3     0   9   28 28                 56
2228974 2228974 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 Arlington: M Norcross Stratton   Regular School No Elementary KG 05 2018   kindergarten 56 1 2 0   4     0   9   34 38                       72.0 56 1 2 0   4     0   9   34 38                 72
2229004 2229004 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland: Ashland High   Regular School No High 09 12 2018   grade_9 151 4 23 0   19     0   9   99 106                       206.0 151 4 23 0   19     0   9   99 106                 206
2229007 2229007 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland: Ashland High   Regular School No High 09 12 2018   grade_12 134 3 14 1   18     0   9   91 88                       179.0 134 3 14 1   18     0   9   91 88                 179
2229011 2229011 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 Attleboro: A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2018   grade_2 61 3 13 1   5     1   9   51 42                       93.0 61 3 13 1   5     1   9   51 42                 93
2229013 2229013 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 Attleboro: A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2018   grade_4 48 2 14 0   4     0   9   40 37                       77.0 48 2 14 0   4     0   9   40 37                 77
2229021 2229021 MA Bristol   school 2502190 16   Attleboro 250219000098 160035 Attleboro: Thomas Willett Elementary School   Regular School No Elementary KG 04 2018   grade_4 60 8 9 0   3     0   9   43 46                       89.0 60 8 9 0   3     0   9   43 46                 89
2229023 2229023 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Attleboro: Hyman Fine Elementary School   Regular School No Elementary KG 04 2018   kindergarten 64 4 11 0   6     0   9   44 50                       94.0 64 4 11 0   6     0   9   44 50                 94
2229026 2229026 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Attleboro: Hyman Fine Elementary School   Regular School No Elementary KG 04 2018   grade_3 62 3 10 0   0     0   9   36 48                       84.0 62 3 10 0   0     0   9   36 48                 84
2229036 2229036 MA Bristol   school 2502190 16   Attleboro 250219001294 160050 Attleboro: Peter Thacher Elementary School   Regular School No Elementary KG 04 2018   grade_1 55 5 11 0   6     0   9   43 43                       86.0 55 5 11 0   6     0   9   43 43                 86
2229046 2229046 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Attleboro: Cyril K. Brennan Middle School   Regular School No Middle 05 08 2018   grade_5 101 11 35 0   9     0   9   96 69                       165.0 101 11 35 0   9     0   9   96 69                 165
2229083 2229083 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn: Auburn Senior High   Regular School No High 09 12 2018   grade_10 145 2 18 1   9     0   9   91 93                       184.0 145 2 18 1   9     0   9   91 93                 184
2229120 2229120 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 Barnstable: West Villages Elementary School   Regular School No Elementary KG 03 2018   kindergarten 87 3 9 0   0     0   9   55 53                       108.0 87 3 9 0   0     0   9   55 53                 108
2229141 2229141 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Bedford: Lt Job Lane School   Regular School No Elementary 03 05 2018   grade_3 140 13 10 0   39     0   9   106 105                       211.0 140 13 10 0   39     0   9   106 105                 211
2229151 2229151 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford: Bedford High   Regular School No High 09 12 2018   grade_10 143 13 19 0   25     1   9   104 106                       210.0 143 13 19 0   25     1   9   104 106                 210
2229164 2229164 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Belchertown: Swift River Elementary   Regular School No Elementary 01 03 2018   grade_3 133 4 14 1   1     0   9   84 78                       162.0 133 4 14 1   1     0   9   84 78                 162
2229204 2229204 MA Middlesex   school 2502490 26   Belmont 250249000148 260005 Belmont: Winn Brook   Regular School No Elementary KG 04 2018   grade_1 58 0 2 0   27     0   9   53 43                       96.0 58 0 2 0   27     0   9   53 43                 96
2229215 2229215 MA Middlesex   school 2502490 26   Belmont 250249000144 260015 Belmont: Daniel Butler   Regular School No Elementary KG 04 2018   kindergarten 36 0 2 0   19     0   9   38 28                       66.0 36 0 2 0   19     0   9   38 28                 66
2229302 2229302 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly: Beverly High   Regular School No High 09 12 2018   grade_12 284 8 25 0   13     0   9   161 177                       339.0 284 8 25 0   13     0   9   161 177                 339
2230183 2230183 MA Suffolk   school 2502790 35   Boston 250279000205 350575 Boston: O'Bryant School Math/Science   Regular School No High 07 12 2018   grade_10 19 85 82 1   68     0   9   104 160                       264.0 19 85 82 1   68     0   9   104 160                 264
2230235 2230235 MA Suffolk   school 2502790 35   Boston 250279002725 350657 Boston: TechBoston Academy   Regular School No High 06 12 2018   grade_8 3 71 40 0   2     0   9   82 43                       125.0 3 71 40 0   2     0   9   82 43                 125
2230397 2230397 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Brockton: Dr W Arnone Community School   Regular School No Elementary KG 05 2018   grade_2 21 78 11 3   0     0   9   75 47                       122.0 21 78 11 3   0     0   9   75 47                 122
2230413 2230413 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Brockton: Manthala George Jr. School   Regular School No Elementary KG 05 2018   grade_4 16 56 66 4   1     0   9   80 72                       152.0 16 56 66 4   1     0   9   80 72                 152
2230503 2230503 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 Brockton: West Middle School   Regular School No Middle 06 08 2018   grade_8 46 104 29 1   8     1   9   107 91                       198.0 46 104 29 1   8     1   9   107 91                 198
2230510 2230510 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Brockton: Joseph F. Plouffe Academy   Regular School No Middle 06 08 2018   grade_7 56 88 71 1   8     0   9   116 117                       233.0 56 88 71 1   8     0   9   116 117                 233
2230536 2230536 MA Norfolk   school 2503150 46   Brookline 250315002776 460001 Brookline: Brookline Early Education Program at Beacon   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 30 2 3 0   16     0   9   27 33                       60.0 30 2 3 0   16     0   9   27 33                 60
2230546 2230546 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Brookline: Edith C Baker   Regular School No Elementary KG 08 2018   grade_6 35 4 12 0   25     0   9   54 31                       85.0 35 4 12 0   25     0   9   54 31                 85
2230550 2230550 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Brookline: Edward Devotion   Regular School No Elementary KG 08 2018   kindergarten 58 5 8 0   12     0   9   50 42                       92.0 58 5 8 0   12     0   9   50 42                 92
2230554 2230554 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Brookline: Edward Devotion   Regular School No Elementary KG 08 2018   grade_4 60 3 14 0   10     0   9   51 45                       96.0 60 3 14 0   10     0   9   51 45                 96
2230555 2230555 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Brookline: Edward Devotion   Regular School No Elementary KG 08 2018   grade_5 55 4 18 0   7     0   9   49 44                       93.0 55 4 18 0   7     0   9   49 44                 93
2230562 2230562 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Brookline: Michael Driscoll   Regular School No Elementary PK 08 2018   grade_1 39 4 5 0   5     0   9   33 29                       62.0 39 4 5 0   5     0   9   33 29                 62
2230563 2230563 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Brookline: Michael Driscoll   Regular School No Elementary PK 08 2018   grade_2 32 2 9 0   16     0   9   37 31                       68.0 32 2 9 0   16     0   9   37 31                 68
2230575 2230575 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Brookline: Heath   Regular School No Elementary PK 08 2018   grade_3 46 2 5 0   10     0   9   29 43                       72.0 46 2 5 0   10     0   9   29 43                 72
2230603 2230603 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Brookline: Pierce   Regular School No Elementary KG 08 2018   grade_1 47 4 8 0   23     0   9   48 43                       91.0 47 4 8 0   23     0   9   48 43                 91
2230619 2230619 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 Brookline: John D Runkle   Regular School No Elementary PK 08 2018   grade_6 38 2 8 0   8     0   9   36 29                       65.0 38 2 8 0   8     0   9   36 29                 65
2230665 2230665 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington: Burlington High   Regular School No High 09 12 2018   grade_9 174 12 7 1   26     0   9   118 111                       229.0 174 12 7 1   26     0   9   118 111                 229
2230667 2230667 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington: Burlington High   Regular School No High 09 12 2018   grade_11 183 9 14 1   35     0   9   112 139                       251.0 183 9 14 1   35     0   9   112 139                 251
2230771 2230771 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge: Cambridge Street Upper School   Regular School No Middle 06 08 2018   grade_8 21 31 21 1   7     1   9   44 47                       91.0 21 31 21 1   7     1   9   44 47                 91
2230796 2230796 MA Norfolk   school 2503300 50   Canton 250330000455 500012 Canton: Lt Peter M Hansen   Regular School No Elementary KG 05 2018   grade_4 63 10 1 0   6     0   9   48 41                       89.0 63 10 1 0   6     0   9   48 41                 89
2230880 2230880 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 Chelmsford: McCarthy Middle School   Regular School No Middle 05 08 2018   grade_5 133 5 12 0   22     0   9   107 74                       181.0 133 5 12 0   22     0   9   107 74                 181
2230885 2230885 MA Middlesex   school 2503510 56   Chelmsford 250351000475 560505 Chelmsford: Chelmsford High   Regular School No High 09 12 2018   grade_9 294 13 10 0   46     0   9   194 178                       372.0 294 13 10 0   46     0   9   194 178                 372
2231008 2231008 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Chicopee: Dupont Middle   Regular School No Middle 06 08 2018   grade_6 131 7 104 0   2     0   9   128 125                       253.0 131 7 104 0   2     0   9   128 125                 253
2231009 2231009 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Chicopee: Dupont Middle   Regular School No Middle 06 08 2018   grade_7 123 16 98 1   3     0   9   145 105                       250.0 123 16 98 1   3     0   9   145 105                 250
2231018 2231018 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee: Chicopee Comprehensive High School   Regular School No High 09 12 2018   grade_10 208 8 101 0   5     0   9   175 156                       331.0 208 8 101 0   5     0   9   175 156                 331
2231075 2231075 MA Middlesex   school 2503840 67   Concord 250384000525 670020 Concord: Thoreau   Regular School No Elementary PK 05 2018   kindergarten 56 0 6 0   5     0   9   41 35                       76.0 56 0 6 0   5     0   9   41 35                 76
2231141 2231141 MA Essex   school 2503990 71   Danvers 250399002517 710305 Danvers: Holten Richmond Middle School   Regular School No Middle 06 08 2018   grade_7 240 5 20 0   7     0   9   136 145                       281.0 240 5 20 0   7     0   9   136 145                 281
2231152 2231152 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Dartmouth: Joseph Demello   Regular School No Elementary 01 05 2018   grade_1 80 1 4 0   2     0   9   56 40                       96.0 80 1 4 0   2     0   9   56 40                 96
2231182 2231182 MA Norfolk   school 2504050 73   Dedham 250405000460 730005 Dedham: Early Childhood Center   Regular School No Elementary PK KG 2018   kindergarten 133 8 21 1   1     0   9   94 79                       173.0 133 8 21 1   1     0   9   94 79                 173
2231301 2231301 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury: Duxbury Middle   Regular School No Middle 06 08 2018   grade_7 234 0 5 0   2     0   9   141 109                       250.0 234 0 5 0   2     0   9   141 109                 250
2231311 2231311 MA Plymouth   school 2504440 83   East Bridgewater 250444000596 830005 East Bridgewater: Central   Regular School No Elementary PK 02 2018   grade_1 133 3 2 1   2     0   9   74 76                       150.0 133 3 2 1   2     0   9   74 76                 150
2231393 2231393 MA Bristol   school 2504620 88   Easton 250462000624 880015 Easton: Parkview Elementary   Regular School No Elementary PK 02 2018   grade_2 80 4 6 0   1     0   9   55 45                       100.0 80 4 6 0   1     0   9   55 45                 100
2231573 2231573 MA Bristol   school 2504830 95   Fall River 250483000666 950045 Fall River: John J Doran   Regular School No Elementary PK 08 2018   kindergarten 24 7 15 0   0     0   9   34 21                       55.0 24 7 15 0   0     0   9   34 21                 55
2231596 2231596 MA Bristol   school 2504830 95   Fall River 250483000679 950130 Fall River: Spencer Borden   Regular School No Elementary KG 05 2018   grade_4 71 3 25 0   8     0   9   72 44                       116.0 71 3 25 0   8     0   9   72 44                 116
2231609 2231609 MA Bristol   school 2504830 95   Fall River 250483000677 950145 Fall River: Samuel Watson   Regular School No Elementary KG 05 2018   grade_3 23 4 8 1   1     0   9   25 21                       46.0 23 4 8 1   1     0   9   25 21                 46
2231675 2231675 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Falmouth: Mullen-Hall   Regular School No Elementary KG 04 2018   grade_4 70 2 5 3   3     0   9   49 43                       92.0 70 2 5 3   3     0   9   49 43                 92
2231690 2231690 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth: Falmouth High   Regular School No High 09 12 2018   grade_10 185 12 9 1   6     0   9   106 115                       222.0 185 12 9 1   6     0   9   106 115                 222
2231691 2231691 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth: Falmouth High   Regular School No High 09 12 2018   grade_11 158 5 10 3   10     0   9   89 106                       195.0 158 5 10 3   10     0   9   89 106                 195
2231704 2231704 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Fitchburg: Reingold Elementary   Regular School No Elementary PK 04 2018   grade_2 39 8 63 0   3     0   9   60 62                       122.0 39 8 63 0   3     0   9   60 62                 122
2231706 2231706 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Fitchburg: Reingold Elementary   Regular School No Elementary PK 04 2018   grade_4 49 7 62 0   4     1   9   72 60                       132.0 49 7 62 0   4     1   9   72 60                 132
2231713 2231713 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 Fitchburg: South Street Elementary   Regular School No Elementary PK 04 2018   kindergarten 32 11 64 0   6     0   9   68 54                       122.0 32 11 64 0   6     0   9   68 54                 122
2231717 2231717 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 Fitchburg: South Street Elementary   Regular School No Elementary PK 04 2018   grade_3 30 8 81 0   9     0   9   62 75                       137.0 30 8 81 0   9     0   9   62 75                 137
2231731 2231731 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 Fitchburg: McKay Arts Academy   Regular School No Elementary PK 08 2018   grade_5 25 4 34 0   7     0   9   41 38                       79.0 25 4 34 0   7     0   9   41 38                 79
2231740 2231740 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg: Fitchburg High   Regular School No High 09 12 2018   grade_12 100 27 141 0   17     1   9   163 132                       295.0 100 27 141 0   17     1   9   163 132                 295
2231849 2231849 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Framingham: Cameron Middle School   Regular School No Middle 06 08 2018   grade_6 125 10 37 0   7     0   9   101 87                       188.0 125 10 37 0   7     0   9   101 87                 188
2231859 2231859 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Framingham: Walsh Middle   Regular School No Middle 06 08 2018   grade_8 133 12 82 0   21     0   9   134 123                       257.0 133 12 82 0   21     0   9   134 123                 257
2231922 2231922 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin: Franklin High   Regular School No High 09 12 2018   grade_9 386 9 10 2   36     0   9   231 221                       452.0 386 9 10 2   36     0   9   231 221                 452
2231940 2231940 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner: Gardner High   Regular School No High 08 12 2018   grade_9 128 9 21 0   2     0   9   93 76                       169.0 128 9 21 0   2     0   9   93 76                 169
2231943 2231943 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner: Gardner High   Regular School No High 08 12 2018   grade_12 90 2 12 0   1     0   9   56 58                       114.0 90 2 12 0   1     0   9   56 58                 114
2232050 2232050 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton: Grafton Middle   Regular School No Middle 07 08 2018   grade_8 215 3 9 0   31     0   9   135 132                       267.0 215 3 9 0   31     0   9   135 132                 267
2232307 2232307 MA Plymouth   school 2506090 131   Hingham 250609000872 1310505 Hingham: Hingham High   Regular School No High 09 12 2018   grade_10 282 2 12 0   9     0   9   165 149                       314.0 282 2 12 0   9     0   9   165 149                 314
2232311 2232311 MA Norfolk   school 2506150 133   Holbrook 250615000880 1330018 Holbrook: John F Kennedy   Regular School No Elementary PK 05 2018   kindergarten 53 16 10 0   7     0   9   50 45                       95.0 53 16 10 0   7     0   9   50 45                 95
2232317 2232317 MA Norfolk   school 2506150 133   Holbrook 250615000880 1330018 Holbrook: John F Kennedy   Regular School No Elementary PK 05 2018   grade_5 46 16 12 0   6     0   9   40 49                       89.0 46 16 12 0   6     0   9   40 49                 89
2232319 2232319 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook: Holbrook Middle High School   Regular School No High 06 12 2018   grade_6 65 18 12 0   3     0   9   56 51                       107.0 65 18 12 0   3     0   9   56 51                 107
2232320 2232320 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook: Holbrook Middle High School   Regular School No High 06 12 2018   grade_7 50 20 15 0   4     0   9   47 51                       98.0 50 20 15 0   4     0   9   47 51                 98
2232321 2232321 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook: Holbrook Middle High School   Regular School No High 06 12 2018   grade_8 67 20 10 0   7     0   9   57 56                       113.0 67 20 10 0   7     0   9   57 56                 113
2232336 2232336 MA Middlesex   school 2506240 136   Holliston 250624001302 1360007 Holliston: Miller School   Regular School No Elementary 03 05 2018   grade_3 172 4 9 0   27     0   9   107 114                       221.0 172 4 9 0   27     0   9   107 114                 221
2232464 2232464 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Hopkinton: Center   Regular School No Elementary KG 01 2018   kindergarten 141 1 6 0   45     0   9   97 105                       202.0 141 1 6 0   45     0   9   97 105                 202
2232471 2232471 MA Middlesex   school 2506330 139   Hopkinton 250633001180 1390015 Hopkinton: Hopkins Elementary School   Regular School No Elementary 04 05 2018   grade_5 212 2 7 0   48     0   9   140 138                       278.0 212 2 7 0   48     0   9   140 138                 278
2232546 2232546 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich: Ipswich Middle School   Regular School No Middle 06 08 2018   grade_7 115 1 8 0   2     0   9   71 64                       135.0 115 1 8 0   2     0   9   71 64                 135
2232767 2232767 MA Worcester   school 2506780 153   Leominster 250678000981 1530007 Leominster: Fall Brook   Regular School No Elementary KG 05 2018   grade_1 64 12 32 0   3     0   9   58 62                       120.0 64 12 32 0   3     0   9   58 62                 120
2232802 2232802 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Leominster: Sky View Middle School   Regular School No Middle 06 08 2018   grade_8 158 24 89 2   20     0   9   155 147                       302.0 158 24 89 2   20     0   9   155 147                 302
2232845 2232845 MA Middlesex   school 2506840 155   Lexington 250684001000 1550010 Lexington: Joseph Estabrook   Regular School No Elementary KG 05 2018   grade_1 35 5 5 0   31     0   9   36 49                       85.0 35 5 5 0   31     0   9   36 49                 85
2232848 2232848 MA Middlesex   school 2506840 155   Lexington 250684001000 1550010 Lexington: Joseph Estabrook   Regular School No Elementary KG 05 2018   grade_4 46 10 2 0   49     0   9   60 56                       116.0 46 10 2 0   49     0   9   60 56                 116
2232849 2232849 MA Middlesex   school 2506840 155   Lexington 250684001000 1550010 Lexington: Joseph Estabrook   Regular School No Elementary KG 05 2018   grade_5 34 2 5 0   52     0   9   44 58                       102.0 34 2 5 0   52     0   9   44 58                 102
2232855 2232855 MA Middlesex   school 2506840 155   Lexington 250684000996 1550015 Lexington: Fiske   Regular School No Elementary KG 05 2018   grade_4 50 0 3 0   31     0   9   44 49                       93.0 50 0 3 0   31     0   9   44 49                 93
2232859 2232859 MA Middlesex   school 2506840 155   Lexington 250684000998 1550030 Lexington: Harrington   Regular School No Elementary KG 05 2018   grade_1 40 6 3 0   31     0   9   42 47                       89.0 40 6 3 0   31     0   9   42 47                 89
2232870 2232870 MA Middlesex   school 2506840 155   Lexington 250684000473 1550035 Lexington: Maria Hastings   Regular School No Elementary KG 05 2018   grade_5 39 3 4 0   43     0   9   43 55                       98.0 39 3 4 0   43     0   9   43 55                 98
2233098 2233098 MA Middlesex   school 2507020 160   Lowell 250702001034 1600330 Lowell: Henry J Robinson Middle   Regular School No Middle 05 08 2018   grade_5 39 13 90 0   28     0   9   95 84                       179.0 39 13 90 0   28     0   9   95 84                 179
2233113 2233113 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Lowell: Kathryn P. Stoklosa Middle School   Regular School No Middle 05 08 2018   grade_5 19 11 45 0   76     0   9   86 74                       160.0 19 11 45 0   76     0   9   86 74                 160
2233297 2233297 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Lynn: Tracy   Regular School No Elementary 01 05 2018   grade_3 7 11 57 0   2     0   9   37 49                       86.0 7 11 57 0   2     0   9   37 49                 86
2233314 2233314 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Lynn: Classical High   Regular School No High 09 12 2018   grade_10 92 44 258 1   47     0   9   254 197                       451.0 92 44 258 1   47     0   9   254 197                 451
2233335 2233335 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn: Lynn Vocational Technical Institute   Career and Technical School No High 06 12 2018   grade_11 30 13 137 0   14     0   9   118 85                       203.0 30 13 137 0   14     0   9   118 85                 203
2233363 2233363 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Malden: Beebe   Regular School No Elementary KG 08 2018   grade_1 32 11 9 0   38     0   9   49 50                       99.0 32 11 9 0   38     0   9   49 50                 99
2233377 2233377 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Malden: Ferryway   Regular School No Elementary KG 08 2018   grade_5 33 24 37 0   21     0   9   66 58                       124.0 33 24 37 0   21     0   9   66 58                 124
2233425 2233425 MA Bristol   school 2507230 167   Mansfield 250723001365 1670014 Mansfield: Jordan/Jackson Elementary   Regular School No Elementary 03 05 2018   grade_3 201 12 4 0   17     0   9   128 115                       243.0 201 12 4 0   17     0   9   128 115                 243

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