enrollments

Data source: Big Local News · About: Big Local

11,284 rows where state = "MA" and year = 2018 sorted by native_american 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
2233552 2233552 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Mashpee: Kenneth Coombs School   Regular School No Elementary PK 02 2018   kindergarten 86 3 6 9   3     0   15   73 49                       122.0 86 3 6 9   3     0   15   73 49                 122
2233560 2233560 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Mashpee: Quashnet School   Regular School No Elementary 03 06 2018   grade_3 84 2 8 9   1     0   12   54 62                       116.0 84 2 8 9   1     0   12   54 62                 116
2233562 2233562 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Mashpee: Quashnet School   Regular School No Elementary 03 06 2018   grade_5 105 3 3 9   4     0   11   65 70                       135.0 105 3 3 9   4     0   11   65 70                 135
2233554 2233554 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Mashpee: Kenneth Coombs School   Regular School No Elementary PK 02 2018   grade_1 68 5 6 8   2     1   11   47 54                       101.0 68 5 6 8   2     1   11   47 54                 101
2233555 2233555 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Mashpee: Kenneth Coombs School   Regular School No Elementary PK 02 2018   grade_2 84 6 9 8   1     0   11   60 59                       119.0 84 6 9 8   1     0   11   60 59                 119
2233561 2233561 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Mashpee: Quashnet School   Regular School No Elementary 03 06 2018   grade_4 103 6 3 8   2     0   10   65 67                       132.0 103 6 3 8   2     0   10   65 67                 132
2233565 2233565 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee: Mashpee High   Regular School No High 09 12 2018   grade_9 99 7 7 8   5     0   3   64 65                       129.0 99 7 7 8   5     0   3   64 65                 129
2233825 2233825 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Milford: Woodland   Regular School No Elementary 03 05 2018   grade_4 185 9 93 8   9     0   11   164 151                       315.0 185 9 93 8   9     0   11   164 151                 315
2233828 2233828 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Milford: Stacy Middle   Regular School No Middle 06 08 2018   grade_6 212 7 80 8   9     0   10   180 146                       326.0 212 7 80 8   9     0   10   180 146                 326
2233833 2233833 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford: Milford High   Regular School No High 09 12 2018   grade_10 201 6 63 8   5     0   8   139 152                       291.0 201 6 63 8   5     0   8   139 152                 291
2235358 2235358 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere: Revere High   Regular School No High 09 12 2018   grade_9 184 19 363 8   30     0   10   320 294                       614.0 184 19 363 8   30     0   10   320 294                 614
2231669 2231669 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Falmouth: Teaticket   Regular School No Elementary PK 04 2018   grade_4 32 3 2 7   0     0   4   27 21                       48.0 32 3 2 7   0     0   4   27 21                 48
2233563 2233563 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Mashpee: Quashnet School   Regular School No Elementary 03 06 2018   grade_6 82 3 3 7   1     0   6   59 43                       102.0 82 3 3 7   1     0   6   59 43                 102
2233824 2233824 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Milford: Woodland   Regular School No Elementary 03 05 2018   grade_3 198 13 82 7   5     1   18   178 146                       324.0 198 13 82 7   5     1   18   178 146                 324
2233834 2233834 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford: Milford High   Regular School No High 09 12 2018   grade_11 176 7 76 7   9     0   4   142 137                       279.0 176 7 76 7   9     0   4   142 137                 279
2238827 2238827 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 Dennis-Yarmouth: N H Wixon Innovation School   Regular School No Elementary 04 05 2018   grade_4 170 29 43 7   3     0   18   136 134                       270.0 170 29 43 7   3     0   18   136 134                 270
2230514 2230514 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton: Brockton High   Regular School No High 09 12 2018   grade_10 167 642 144 6   27     2   34   556 466                       1022.0 167 642 144 6   27     2   34   556 466                 1022
2233303 2233303 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Lynn: Thurgood Marshall Mid   Regular School No Middle 06 08 2018   grade_8 53 40 291 6   35     0   15   227 213                       440.0 53 40 291 6   35     0   15   227 213                 440
2233558 2233558 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee: Mashpee Middle School   Regular School No Middle 07 08 2018   grade_8 105 4 4 6   3     1   7   71 59                       130.0 105 4 4 6   3     1   7   71 59                 130
2233832 2233832 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford: Milford High   Regular School No High 09 12 2018   grade_9 181 11 77 6   5     0   11   149 142                       291.0 181 11 77 6   5     0   11   149 142                 291
2238828 2238828 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 Dennis-Yarmouth: N H Wixon Innovation School   Regular School No Elementary 04 05 2018   grade_5 194 21 30 6   7     0   13   136 135                       271.0 194 21 30 6   7     0   13   136 135                 271
2238834 2238834 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth: Dennis-Yarmouth Regional High   Regular School No High 08 12 2018   grade_8 154 26 29 6   4     0   11   113 117                       230.0 154 26 29 6   4     0   11   113 117                 230
2238835 2238835 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth: Dennis-Yarmouth Regional High   Regular School No High 08 12 2018   grade_9 132 16 19 6   4     1   11   109 80                       189.0 132 16 19 6   4     1   11   109 80                 189
2239809 2239809 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Regional Vocational Technical: Cape Cod Region Vocational Technical   Career and Technical School No High 09 12 2018   grade_11 97 7 16 6   2     1   9   87 51                       138.0 97 7 16 6   2     1   9   87 51                 138
2228996 2228996 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 Ashland: David Mindess   Regular School No Elementary 03 05 2018   grade_3 155 6 16 5   32     0   6   110 110                       220.0 155 6 16 5   32     0   6   110 110                 220
2228997 2228997 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 Ashland: David Mindess   Regular School No Elementary 03 05 2018   grade_4 147 1 22 5   26     0   10   107 104                       211.0 147 1 22 5   26     0   10   107 104                 211
2233566 2233566 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee: Mashpee High   Regular School No High 09 12 2018   grade_10 89 6 4 5   1     0   7   61 51                       112.0 89 6 4 5   1     0   7   61 51                 112
2235680 2235680 MA Worcester   school 2510770 271   Shrewsbury 251077002496 2710005 Shrewsbury: Beal School   Regular School No Elementary KG 01 2018   kindergarten 108 11 22 5   95     0   13   128 126                       254.0 108 11 22 5   95     0   13   128 126                 254
2237938 2237938 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter (District): Excel Academy Charter School   Regular School Yes Middle 05 11 2018   grade_7 26 13 122 5   3     2   0   80 91                       171.0 26 13 122 5   3     2   0   80 91                 171
2238823 2238823 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Dennis-Yarmouth: Station Avenue Elementary   Regular School No Elementary KG 03 2018   grade_1 70 10 6 5   2     1   6   61 39                       100.0 70 10 6 5   2     1   6   61 39                 100
2238830 2238830 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Dennis-Yarmouth: Mattacheese Middle School   Regular School No Middle 05 08 2018   grade_6 150 18 34 5   4     0   14   107 118                       225.0 150 18 34 5   4     0   14   107 118                 225
2238831 2238831 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Dennis-Yarmouth: Mattacheese Middle School   Regular School No Middle 05 08 2018   grade_7 156 22 18 5   5     0   11   115 102                       217.0 156 22 18 5   5     0   11   115 102                 217
2239832 2239832 MA Bristol   school 2508440 825   Greater New Bedford Regional Vocational Technical 250844002266 8250605 Greater New Bedford Regional Vocational Technical: Gr New Bedford Vocational Technical   Career and Technical School No High 09 12 2018   grade_9 335 40 147 5   4     0   26   273 284                       557.0 335 40 147 5   4     0   26   273 284                 557
2229134 2229134 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable: Barnstable High   Regular School No High 08 12 2018   grade_11 277 32 39 4   12     4   15   187 196                       383.0 277 32 39 4   12     4   15   187 196                 383
2230290 2230290 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Bourne: Peebles Elementary School   Regular School No Elementary KG 04 2018   grade_4 73 1 4 4   2     0   4   42 46                       88.0 73 1 4 4   2     0   4   42 46                 88
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
2230414 2230414 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Brockton: Manthala George Jr. School   Regular School No Elementary KG 05 2018   grade_5 25 73 58 4   2     0   11   91 82                       173.0 25 73 58 4   2     0   11   91 82                 173
2230516 2230516 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton: Brockton High   Regular School No High 09 12 2018   grade_12 150 635 102 4   30     2   27   476 474                       950.0 150 635 102 4   30     2   27   476 474                 950
2232459 2232459 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale: Hopedale Jr Sr High   Regular School No High 07 12 2018   grade_11 72 1 2 4   0     0   2   39 42                       81.0 72 1 2 4   0     0   2   39 42                 81
2233307 2233307 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Lynn: Breed Middle School   Regular School No Middle 06 08 2018   grade_8 65 40 256 4   52     0   12   223 206                       429.0 65 40 256 4   52     0   12   223 206                 429
2233795 2233795 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 Middleborough: John T. Nichols Middle   Regular School No Middle 06 08 2018   grade_6 219 7 8 4   7     0   11   140 116                       256.0 219 7 8 4   7     0   11   140 116                 256
2233796 2233796 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 Middleborough: John T. Nichols Middle   Regular School No Middle 06 08 2018   grade_7 215 6 12 4   6     0   10   114 139                       253.0 215 6 12 4   6     0   10   114 139                 253
2233800 2233800 MA Plymouth   school 2507770 182   Middleborough 250777001227 1820505 Middleborough: Middleborough High   Regular School No High 09 12 2018   grade_10 155 2 7 4   0     0   5   87 86                       173.0 155 2 7 4   0     0   5   87 86                 173
2233829 2233829 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Milford: Stacy Middle   Regular School No Middle 06 08 2018   grade_7 223 10 97 4   12     0   9   178 177                       355.0 223 10 97 4   12     0   9   178 177                 355
2233835 2233835 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford: Milford High   Regular School No High 09 12 2018   grade_12 184 9 71 4   11     1   2   129 153                       282.0 184 9 71 4   11     1   2   129 153                 282
2234193 2234193 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 New Bedford: Keith Middle School   Regular School No Middle 06 08 2018   grade_8 106 49 95 4   3     0   20   149 128                       277.0 106 49 95 4   3     0   20   149 128                 277
2234203 2234203 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford: New Bedford High   Regular School No High 09 12 2018   grade_9 172 81 227 4   5     2   26   284 233                       517.0 172 81 227 4   5     2   26   284 233                 517
2234204 2234204 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford: New Bedford High   Regular School No High 09 12 2018   grade_10 179 90 285 4   5     1   22   325 261                       586.0 179 90 285 4   5     1   22   325 261                 586
2235522 2235522 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich: Sandwich STEM Academy   Regular School No Middle 07 08 2018   grade_7 221 1 1 4   6     0   1   120 114                       234.0 221 1 1 4   6     0   1   120 114                 234
2236785 2236785 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 Wareham: John William Decas   Regular School No Elementary KG 02 2018   kindergarten 160 15 17 4   2     0   24   119 103                       222.0 160 15 17 4   2     0   24   119 103                 222
2236787 2236787 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 Wareham: John William Decas   Regular School No Elementary KG 02 2018   grade_2 139 9 16 4   1     0   27   105 91                       196.0 139 9 16 4   1     0   27   105 91                 196
2236803 2236803 MA Plymouth   school 2512060 310   Wareham 251206001991 3100505 Wareham: Wareham Senior High   Regular School No High 09 12 2018   grade_9 88 9 11 4   1     0   13   66 60                       126.0 88 9 11 4   1     0   13   66 60                 126
2238820 2238820 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Dennis-Yarmouth: Marguerite E Small Elementary   Regular School No Elementary PK 03 2018   grade_3 34 2 9 4   0     0   7   31 25                       56.0 34 2 9 4   0     0   7   31 25                 56
2238837 2238837 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth: Dennis-Yarmouth Regional High   Regular School No High 08 12 2018   grade_11 141 24 23 4   8     0   9   98 111                       209.0 141 24 23 4   8     0   9   98 111                 209
2239148 2239148 MA Dukes   school 2507380 700   Martha's Vineyard 250738001145 7000505 Martha's Vineyard: Martha's Vineyard Regional High   Regular School No High 09 12 2018   grade_11 116 5 26 4   1     1   2   89 66                       155.0 116 5 26 4   1     1   2   89 66                 155
2239149 2239149 MA Dukes   school 2507380 700   Martha's Vineyard 250738001145 7000505 Martha's Vineyard: Martha's Vineyard Regional High   Regular School No High 09 12 2018   grade_12 114 5 6 4   3     0   10   68 74                       142.0 114 5 6 4   3     0   10   68 74                 142
2239842 2239842 MA Middlesex   school 2511060 829   South Middlesex Regional Vocational Technical 251106002291 8290605 South Middlesex Regional Vocational Technical: Joseph P Keefe Technical High School   Career and Technical School No High 09 12 2018   grade_9 102 9 78 4   0     0   5   120 78                       198.0 102 9 78 4   0     0   5   120 78                 198
2229125 2229125 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable: Barnstable United Elementary School   Regular School No Elementary 04 05 2018   grade_4 311 22 63 3   8     1   16   227 197                       424.0 311 22 63 3   8     1   16   227 197                 424
2229135 2229135 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable: Barnstable High   Regular School No High 08 12 2018   grade_12 250 29 36 3   13     2   12   169 176                       345.0 250 29 36 3   13     2   12   169 176                 345
2230144 2230144 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston: Boston Latin Academy   Regular School No High 07 12 2018   grade_11 68 64 75 3   69     0   6   119 166                       285.0 68 64 75 3   69     0   6   119 166                 285
2230295 2230295 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne: Bourne Middle School   Regular School No Middle 05 08 2018   grade_8 176 5 3 3   6     0   0   93 100                       193.0 176 5 3 3   6     0   0   93 100                 193
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
2230513 2230513 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton: Brockton High   Regular School No High 09 12 2018   grade_9 218 689 157 3   23     3   50   630 513                       1143.0 218 689 157 3   23     3   50   630 513                 1143
2230786 2230786 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge: Cambridge Rindge and Latin   Regular School No High 09 12 2018   grade_10 195 134 63 3   54     1   36   245 241                       486.0 195 134 63 3   54     1   36   245 241                 486
2231417 2231417 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown: Edgartown Elementary   Regular School No Elementary PK 08 2018   grade_3 30 1 14 3   0     0   2   20 30                       50.0 30 1 14 3   0     0   2   20 30                 50
2231442 2231442 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Everett: Sumner G. Whittier School   Regular School No Elementary KG 08 2018   grade_7 6 8 29 3   3     0   2   27 24                       51.0 6 8 29 3   3     0   2   27 24                 51
2231659 2231659 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 Falmouth: East Falmouth Elementary   Regular School No Elementary KG 04 2018   grade_1 36 2 3 3   0     0   4   28 20                       48.0 36 2 3 3   0     0   4   28 20                 48
2231662 2231662 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 Falmouth: East Falmouth Elementary   Regular School No Elementary KG 04 2018   grade_4 52 1 2 3   0     0   4   36 26                       62.0 52 1 2 3   0     0   4   36 26                 62
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
2231687 2231687 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Falmouth: Lawrence   Regular School No Middle 07 08 2018   grade_8 229 16 14 3   6     0   19   160 127                       287.0 229 16 14 3   6     0   19   160 127                 287
2231689 2231689 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth: Falmouth High   Regular School No High 09 12 2018   grade_9 188 9 6 3   6     0   19   105 126                       231.0 188 9 6 3   6     0   19   105 126                 231
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
2231772 2231772 MA Norfolk   school 2504950 99   Foxborough 250495000864 990050 Foxborough: Charles Taylor Elementary   Regular School No Elementary KG 04 2018   grade_2 36 1 1 3   3     0   1   28 17                       45.0 36 1 1 3   3     0   1   28 17                 45
2232003 2232003 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 Gloucester: West Parish   Regular School No Elementary KG 05 2018   grade_5 49 1 1 3   1     0   0   21 34                       55.0 49 1 1 3   1     0   0   21 34                 55
2233541 2233541 MA Plymouth   school 2507350 171   Marshfield 250735001139 1710025 Marshfield: Martinson Elementary   Regular School No Elementary PK 05 2018   grade_5 70 0 2 3   2     0   2   32 47                       79.0 70 0 2 3   2     0   2   32 47                 79
2233605 2233605 MA Norfolk   school 2507530 175   Medfield 250753001159 1750007 Medfield: Ralph Wheelock School   Regular School No Elementary 02 03 2018   grade_3 156 2 14 3   5     0   3   109 74                       183.0 156 2 14 3   5     0   3   109 74                 183
2234206 2234206 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford: New Bedford High   Regular School No High 09 12 2018   grade_12 118 51 152 3   8     1   16   172 177                       349.0 118 51 152 3   8     1   16   172 177                 349
2234363 2234363 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton: Newton North High   Regular School No High 09 12 2018   grade_9 313 39 43 3   72     1   32   254 249                       503.0 313 39 43 3   72     1   32   254 249                 503
2234365 2234365 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton: Newton North High   Regular School No High 09 12 2018   grade_11 362 21 54 3   80     0   24   270 273                       544.0 362 21 54 3   80     0   24   270 273                 544
2234653 2234653 MA Bristol   school 2509000 218   Norton 250900001449 2180015 Norton: J C Solmonese   Regular School No Elementary PK 03 2018   grade_3 90 1 2 3   1     0   4   47 54                       101.0 90 1 2 3   1     0   4   47 54                 101
2235208 2235208 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 Quincy: North Quincy High   Regular School No High 09 12 2018   grade_9 105 11 12 3   157     0   3   154 137                       291.0 105 11 12 3   157     0   3   154 137                 291
2235525 2235525 MA Barnstable   school 2510470 261   Sandwich 251047001673 2610505 Sandwich: Sandwich High   Regular School No High 09 12 2018   grade_9 146 0 2 3   5     1   0   68 89                       157.0 146 0 2 3   5     1   0   68 89                 157
2236563 2236563 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury: Tisbury Elementary   Regular School No Elementary PK 08 2018   grade_8 24 0 9 3   1     0   5   20 22                       42.0 24 0 9 3   1     0   5   20 22                 42
2236837 2236837 MA Middlesex   school 2512180 314   Watertown 251218002005 3140505 Watertown: Watertown High   Regular School No High 09 12 2018   grade_10 114 6 21 3   8     0   8   80 80                       160.0 114 6 21 3   8     0   8   80 80                 160
2237542 2237542 MA Middlesex   school 2513200 347   Woburn 251320002189 3470065 Woburn: Mary D Altavesta   Regular School No Elementary KG 05 2018   grade_3 18 5 6 3   11     0   2   26 19                       45.0 18 5 6 3   11     0   2   26 19                 45
2237547 2237547 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 Woburn: John F Kennedy Middle School   Regular School No Middle 06 08 2018   grade_7 112 10 10 3   10     0   2   68 79                       147.0 112 10 10 3   10     0   2   68 79                 147
2237939 2237939 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter (District): Excel Academy Charter School   Regular School Yes Middle 05 11 2018   grade_8 14 9 143 3   3     0   0   81 91                       172.0 14 9 143 3   3     0   0   81 91                 172
2238437 2238437 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public (District): South Shore Charter Public School   Regular School Yes Other KG 12 2018   grade_9 47 20 1 3   4     0   3   37 41                       78.0 47 20 1 3   4     0   3   37 41                 78
2238444 2238444 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public (District): Sturgis Charter Public School   Regular School Yes High 09 12 2018   grade_11 160 5 11 3   9     0   10   78 120                       198.0 160 5 11 3   9     0   10   78 120                 198
2238818 2238818 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Dennis-Yarmouth: Marguerite E Small Elementary   Regular School No Elementary PK 03 2018   grade_1 31 5 7 3   0     1   5   35 17                       52.0 31 5 7 3   0     1   5   35 17                 52
2238819 2238819 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Dennis-Yarmouth: Marguerite E Small Elementary   Regular School No Elementary PK 03 2018   grade_2 34 4 11 3   1     0   6   29 30                       59.0 34 4 11 3   1     0   6   29 30                 59
2239146 2239146 MA Dukes   school 2507380 700   Martha's Vineyard 250738001145 7000505 Martha's Vineyard: Martha's Vineyard Regional High   Regular School No High 09 12 2018   grade_9 120 8 29 3   3     1   7   82 89                       171.0 120 8 29 3   3     1   7   82 89                 171
2239648 2239648 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 Up-Island Regional: West Tisbury Elementary   Regular School No Elementary PK 08 2018   grade_8 35 1 2 3   1     0   2   31 13                       44.0 35 1 2 3   1     0   2   31 13                 44
2239775 2239775 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman-Hanson: Whitman Middle   Regular School No Middle 06 08 2018   grade_7 162 9 10 3   3     1   7   112 83                       195.0 162 9 10 3   3     1   7   112 83                 195
2239812 2239812 MA Essex   school 2500554 817   Essex North Shore Agricultural and Technical School District 250055402833 8170505 Essex North Shore Agricultural and Technical School District: Essex Technical High School   Career and Technical School No High 09 12 2018   grade_9 297 4 38 3   7     0   15   140 223                       364.0 297 4 38 3   7     0   15   140 223                 364
2239822 2239822 MA Bristol   school 2505485 821   Greater Fall River Regional Vocational Technical 250548502269 8210605 Greater Fall River Regional Vocational Technical: Diman Regional Vocational Technical High   Career and Technical School No High 09 12 2018   grade_9 279 16 38 3   8     0   31   200 175                       375.0 279 16 38 3   8     0   31   200 175                 375
2239834 2239834 MA Bristol   school 2508440 825   Greater New Bedford Regional Vocational Technical 250844002266 8250605 Greater New Bedford Regional Vocational Technical: Gr New Bedford Vocational Technical   Career and Technical School No High 09 12 2018   grade_11 349 40 111 3   6     0   17   257 269                       526.0 349 40 111 3   6     0   17   257 269                 526
2228759 2228759 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Abington: Beaver Brook Elementary   Regular School No Elementary KG 02 2018   kindergarten 113 6 13 2   3     0   0   67 70                       137.0 113 6 13 2   3     0   0   67 70                 137
2228851 2228851 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst: Crocker Farm Elementary   Regular School No Elementary PK 06 2018   kindergarten 16 2 5 2   6     0   5   16 19                       36.0 16 2 5 2   6     0   5   16 19                 36
2228914 2228914 MA Essex   school 2501950 9   Andover 250195002510 90305 Andover: Doherty Middle   Regular School No Middle 06 08 2018   grade_7 162 1 5 2   27     0   5   97 105                       202.0 162 1 5 2   27     0   5   97 105                 202

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