enrollments

Data source: Big Local News · About: Big Local

70,226 rows where state = "MA" sorted by multiracial descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
735727 735727 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No 2 05 08 2015   grade_6 150 4 11 0   1     0   9   95 80                       175 150 4 11 0   1     0   9   95 80                 175
735806 735806 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No 1 KG 05 2015   kindergarten 46 3 1 0   9     0   9   35 33                       68 46 3 1 0   9     0   9   35 33                 68
735812 735812 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No 1 KG 05 2015   kindergarten 67 2 9 1   8     1   9   50 47                       97 67 2 9 1   8     1   9   50 47                 97
735886 735886 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Hill-Roberts Elementary School   Regular School No 1 KG 04 2015   kindergarten 67 4 10 0   2     0   9   48 44                       92 67 4 10 0   2     0   9   48 44                 92
735888 735888 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Hill-Roberts Elementary School   Regular School No 1 KG 04 2015   grade_2 86 5 14 0   2     0   9   60 56                       116 86 5 14 0   2     0   9   60 56                 116
735892 735892 MA Bristol   school 2502190 16   Attleboro 250219001294 160050 Peter Thacher Elementary School   Regular School No 1 KG 04 2015   grade_1 60 6 8 0   6     0   9   41 48                       89 60 6 8 0   6     0   9   41 48                 89
735961 735961 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No 1 KG 03 2015   grade_1 43 13 20 0   6     1   9   57 35                       92 43 13 20 0   6     1   9   57 35                 92
735963 735963 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No 1 KG 03 2015   grade_3 35 16 26 0   2     0   9   56 32                       88 35 16 26 0   2     0   9   56 32                 88
735981 735981 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Lt Job Lane School   Regular School No 1 03 05 2015   grade_3 113 12 10 0   20     0   9   92 72                       164 113 12 10 0   20     0   9   92 72                 164
736036 736036 MA Middlesex   school 2502490 26   Belmont 250249000148 260005 Winn Brook   Regular School No 1 KG 04 2015   grade_1 53 1 3 1   28     0   9   46 49                       95 53 1 3 1   28     0   9   46 49                 95
736059 736059 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No 2 05 08 2015   grade_8 204 16 12 0   51     0   9   134 158                       292 204 16 12 0   51     0   9   134 158                 292
736120 736120 MA Middlesex   school 2502670 31   Billerica 250267000186 310005 Thomas Ditson   Regular School No 1 KG 05 2015   kindergarten 69 2 4 0   8     0   9   44 48                       92 69 2 4 0   8     0   9   44 48                 92
736445 736445 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No 1 PK 08 2015   grade_1 2 23 19 0   5     0   9   33 25                       58 2 23 19 0   5     0   9   33 25                 58
736561 736561 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No 1 03 08 2015   grade_6 21 25 49 0   11     0   9   68 47                       115 21 25 49 0   11     0   9   68 47                 115
737062 737062 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No 1 KG 05 2015   grade_3 14 75 23 1   1     0   9   57 66                       123 14 75 23 1   1     0   9   57 66                 123
737069 737069 MA Plymouth   school 2503090 44   Brockton 250309002649 440002 Mary E. Baker School   Regular School No 1 KG 05 2015   grade_4 38 51 17 2   3     0   9   65 55                       120 38 51 17 2   3     0   9   65 55                 120
737070 737070 MA Plymouth   school 2503090 44   Brockton 250309002649 440002 Mary E. Baker School   Regular School No 1 KG 05 2015   grade_5 40 53 18 0   2     0   9   74 48                       122 40 53 18 0   2     0   9   74 48                 122
737079 737079 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brookfield   Regular School No 1 KG 05 2015   grade_1 39 67 11 0   1     0   9   67 60                       127 39 67 11 0   1     0   9   67 60                 127
737105 737105 MA Plymouth   school 2503090 44   Brockton 250309000221 440050 Gilmore School Early Childhood Center   Regular School No 1 PK KG 2015   kindergarten 20 34 19 1   0     0   9   52 31                       83 20 34 19 1   0     0   9   52 31                 83
737120 737120 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No 1 KG 08 2015   grade_1 16 83 17 0   2     0   9   64 63                       127 16 83 17 0   2     0   9   64 63                 127
737150 737150 MA Plymouth   school 2503090 44   Brockton 250309000404 440410 North Middle School   Regular School No 2 06 08 2015   grade_7 18 133 19 1   2     1   9   106 77                       183 18 133 19 1   2     1   9   106 77                 183
737153 737153 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No 2 06 08 2015   grade_7 32 99 32 0   7     0   9   94 85                       179 32 99 32 0   7     0   9   94 85                 179
737190 737190 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No 1 KG 08 2015   grade_3 38 4 12 0   25     0   9   51 37                       88 38 4 12 0   25     0   9   51 37                 88
737197 737197 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Edward Devotion   Regular School No 1 KG 08 2015   grade_1 62 3 12 0   14     0   9   46 54                       100 62 3 12 0   14     0   9   46 54                 100
737210 737210 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No 1 PK 08 2015   grade_4 40 6 3 0   13     0   9   43 28                       71 40 6 3 0   13     0   9   43 28                 71
737243 737243 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No 1 KG 08 2015   kindergarten 53 2 9 0   35     0   9   59 49                       108 53 2 9 0   35     0   9   59 49                 108
737249 737249 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No 1 KG 08 2015   grade_6 41 10 11 0   11     0   9   44 38                       82 41 10 11 0   11     0   9   44 38                 82
737255 737255 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No 1 PK 08 2015   grade_2 41 1 4 0   12     0   9   35 32                       67 41 1 4 0   12     0   9   35 32                 67
737294 737294 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Marshall Simonds Middle   Regular School No 2 06 08 2015   grade_7 219 14 14 3   37     0   9   162 134                       296 219 14 14 3   37     0   9   162 134                 296
737300 737300 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington High   Regular School No 3 09 12 2015   grade_11 186 18 3 0   25     0   9   125 116                       241 186 18 3 0   25     0   9   125 116                 241
737301 737301 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington High   Regular School No 3 09 12 2015   grade_12 187 9 9 0   39     1   9   127 127                       254 187 9 9 0   39     1   9   127 127                 254
737302 737302 MA Middlesex   school 2503270 49   Cambridge 250327000435 490005 Maria L. Baldwin   Regular School No 1 PK 05 2015   kindergarten 34 12 7 0   5     0   9   37 30                       67 34 12 7 0   5     0   9   37 30                 67
737359 737359 MA Middlesex   school 2503270 49   Cambridge 250327000446 490045 Morse   Regular School No 1 PK 05 2015   grade_4 6 16 8 0   3     0   9   23 19                       42 6 16 8 0   3     0   9   23 19                 42
737404 737404 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No 3 09 12 2015   grade_12 163 145 49 3   54     0   9   205 218                       423 163 145 49 3   54     0   9   205 218                 423
737436 737436 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No 1 PK 08 2015   grade_3 55 0 3 0   3     0   9   38 32                       70 55 0 3 0   3     0   9   38 32                 70
737587 737587 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Fairview Middle   Regular School No 2 06 08 2015   grade_6 125 5 60 1   11     0   9   104 107                       211 125 5 60 1   11     0   9   104 107                 211
737596 737596 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee Comprehensive High School   Regular School No 3 09 12 2015   grade_10 247 9 86 1   12     4   9   212 156                       368 247 9 86 1   12     4   9   212 156                 368
737598 737598 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee Comprehensive High School   Regular School No 3 09 12 2015   grade_12 231 8 67 0   11     3   9   184 145                       329 231 8 67 0   11     3   9   184 145                 329
737736 737736 MA Norfolk   school 2504050 73   Dedham 250405000460 730005 Early Childhood Center   Regular School No 1 PK 01 2015   kindergarten 144 7 27 1   6     0   9   99 95                       194 144 7 27 1   6     0   9   99 95                 194
737759 737759 MA Norfolk   school 2504050 73   Dedham 250405000551 730305 Dedham Middle School   Regular School No 2 06 08 2015   grade_6 178 14 24 1   4     0   9   119 111                       230 178 14 24 1   4     0   9   119 111                 230
737924 737924 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No 2 06 08 2015   grade_6 253 17 11 1   8     0   9   146 153                       299 253 17 11 1   8     0   9   146 153                 299
738040 738040 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No 1 KG 05 2015   grade_1 60 9 36 0   1     0   9   56 59                       115 60 9 36 0   1     0   9   56 59                 115
738044 738044 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No 1 KG 05 2015   grade_5 47 7 19 1   1     0   9   46 38                       84 47 7 19 1   1     0   9   46 38                 84
738060 738060 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No 1 PK 06 2015   grade_1 32 8 15 0   4     0   9   35 33                       68 32 8 15 0   4     0   9   35 33                 68
738068 738068 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No 1 PK 08 2015   grade_1 35 6 12 1   1     0   9   35 29                       64 35 6 12 1   1     0   9   35 29                 64
738079 738079 MA Bristol   school 2504830 95   Fall River 250483000684 950065 William S Greene   Regular School No 1 PK 05 2015   kindergarten 83 5 16 0   7     0   9   65 55                       120 83 5 16 0   7     0   9   65 55                 120
738081 738081 MA Bristol   school 2504830 95   Fall River 250483000684 950065 William S Greene   Regular School No 1 PK 05 2015   grade_1 67 9 24 0   6     0   9   58 57                       115 67 9 24 0   6     0   9   58 57                 115
738083 738083 MA Bristol   school 2504830 95   Fall River 250483000684 950065 William S Greene   Regular School No 1 PK 05 2015   grade_3 79 8 19 0   11     0   9   71 55                       126 79 8 19 0   11     0   9   71 55                 126
738088 738088 MA Bristol   school 2504830 95   Fall River 250483000679 950130 Spencer Borden   Regular School No 1 PK 05 2015   grade_1 67 3 7 0   5     0   9   52 39                       91 67 3 7 0   5     0   9   52 39                 91
738126 738126 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No 3 09 12 2015   grade_12 308 44 69 2   25     0   9   215 242                       457 308 44 69 2   25     0   9   215 242                 457
738177 738177 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No 1 PK 04 2015   grade_3 37 7 54 0   12     0   9   61 58                       119 37 7 54 0   12     0   9   61 58                 119
738237 738237 MA Middlesex   school 2504980 100   Framingham 250498002820 1000001 Juniper Hill School   Regular School No 1 PK PK 2015   pre_kindergarten 87 12 34 0   11     0   9   93 60                       153 87 12 34 0   11     0   9   93 60                 153
738294 738294 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No 2 06 08 2015   grade_7 113 9 75 0   18     1   9   118 107                       225 113 9 75 0   18     1   9   118 107                 225
738296 738296 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham High School   Regular School No 3 09 12 2015   grade_9 338 30 87 1   34     0   9   241 258                       499 338 30 87 1   34     0   9   241 258                 499
738347 738347 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No 3 09 12 2015   grade_10 359 7 12 1   16     0   9   181 223                       404 359 7 12 1   16     0   9   181 223                 404
738361 738361 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No 2 06 08 2015   grade_6 140 2 22 0   2     0   9   89 86                       175 140 2 22 0   2     0   9   89 86                 175
738362 738362 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No 2 06 08 2015   grade_7 164 10 26 0   4     0   9   108 105                       213 164 10 26 0   4     0   9   108 105                 213
738364 738364 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No 3 09 12 2015   grade_9 124 5 17 0   2     0   9   78 79                       157 124 5 17 0   2     0   9   78 79                 157
738442 738442 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No 1 02 06 2015   grade_6 79 1 4 0   21     0   9   60 54                       114 79 1 4 0   21     0   9   60 54                 114
738662 738662 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No 2 06 08 2015   grade_7 303 1 14 0   8     0   9   176 159                       335 303 1 14 0   8     0   9   176 159                 335
738664 738664 MA Plymouth   school 2506090 131   Hingham 250609000872 1310505 Hingham High   Regular School No 3 09 12 2015   grade_9 304 4 8 0   12     0   9   169 168                       337 304 4 8 0   12     0   9   169 168                 337
738695 738695 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No 1 PK 02 2015   kindergarten 152 2 10 0   21     0   9   98 96                       194 152 2 10 0   21     0   9   98 96                 194
738773 738773 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke High   Regular School No 3 09 12 2015   grade_9 96 14 280 0   6     0   9   224 181                       405 96 14 280 0   6     0   9   224 181                 405
739095 739095 MA Worcester   school 2506780 153   Leominster 250678000990 1530040 Priest Street   Regular School No 1 KG KG 2015   kindergarten 75 9 54 0   6     0   9   82 71                       153 75 9 54 0   6     0   9   82 71                 153
739128 739128 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Bowman   Regular School No 1 KG 05 2015   grade_1 47 8 2 0   17     0   9   52 31                       83 47 8 2 0   17     0   9   52 31                 83
739129 739129 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Bowman   Regular School No 1 KG 05 2015   grade_2 48 8 1 1   43     0   9   55 55                       110 48 8 1 1   43     0   9   55 55                 110
739133 739133 MA Middlesex   school 2506840 155   Lexington 250684001000 1550010 Joseph Estabrook   Regular School No 1 KG 05 2015   kindergarten 33 3 2 0   18     0   9   24 41                       65 33 3 2 0   18     0   9   24 41                 65
739141 739141 MA Middlesex   school 2506840 155   Lexington 250684000996 1550015 Fiske   Regular School No 1 KG 05 2015   grade_2 53 4 2 0   16     0   9   49 35                       84 53 4 2 0   16     0   9   49 35                 84
739143 739143 MA Middlesex   school 2506840 155   Lexington 250684000996 1550015 Fiske   Regular School No 1 KG 05 2015   grade_4 60 1 1 0   26     0   9   46 51                       97 60 1 1 0   26     0   9   46 51                 97
739152 739152 MA Middlesex   school 2506840 155   Lexington 250684000473 1550035 Maria Hastings   Regular School No 1 KG 05 2015   grade_1 26 1 1 0   29     0   9   41 25                       66 26 1 1 0   29     0   9   41 25                 66
739510 739510 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No 2 06 08 2015   grade_8 42 46 225 0   25     0   9   199 148                       347 42 46 225 0   25     0   9   199 148                 347
739512 739512 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No 2 06 08 2015   grade_7 78 38 233 0   49     0   9   214 193                       407 78 38 233 0   49     0   9   214 193                 407
739514 739514 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Pickering Middle   Regular School No 2 06 08 2015   grade_6 97 13 69 1   21     0   9   113 97                       210 97 13 69 1   21     0   9   113 97                 210
739519 739519 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Classical High   Regular School No 3 09 12 2015   grade_11 122 65 170 2   42     0   9   216 194                       410 122 65 170 2   42     0   9   216 194                 410
739525 739525 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No 3 09 12 2015   grade_12 82 44 153 1   35     0   9   147 177                       324 82 44 153 1   35     0   9   147 177                 324
739596 739596 MA Middlesex   school 2507170 165   Malden 250717002046 1650049 Malden Early Learning Center   Regular School No 1 PK PK 2015   pre_kindergarten 138 57 18 0   93     2   9   175 142                       317 138 57 18 0   93     2   9   175 142                 317
739619 739619 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Harold L Qualters Middle   Regular School No 2 06 08 2015   grade_8 319 9 11 0   11     0   9   178 181                       359 319 9 11 0   11     0   9   178 181                 359
739642 739642 MA Essex   school 2507260 168   Marblehead 250726001789 1680300 Marblehead Veterans Middle School   Regular School No 2 07 08 2015   grade_7 210 8 15 0   4     0   9   124 122                       246 210 8 15 0   4     0   9   124 122                 246
739721 739721 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No 1 PK 02 2015   kindergarten 74 2 11 9   1     0   9   52 54                       106 74 2 11 9   1     0   9   52 54                 106
739724 739724 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No 1 PK 02 2015   grade_2 97 3 3 8   3     0   9   59 64                       123 97 3 3 8   3     0   9   59 64                 123
739752 739752 MA Middlesex   school 2507500 174   Maynard 250750001153 1740505 Maynard High   Regular School No 3 08 12 2015   grade_8 79 3 12 0   4     0   9   55 52                       107 79 3 12 0   4     0   9   55 52                 107
739806 739806 MA Middlesex   school 2507560 176   Medford 250756001176 1760505 Medford High   Regular School No 3 09 12 2015   grade_9 197 63 39 0   35     0   9   163 180                       343 197 63 39 0   35     0   9   163 180                 343
739808 739808 MA Middlesex   school 2507560 176   Medford 250756001176 1760505 Medford High   Regular School No 3 09 12 2015   grade_11 144 47 29 1   27     0   9   117 140                       257 144 47 29 1   27     0   9   117 140                 257
739945 739945 MA Worcester   school 2507860 185   Milford 250786001238 1850010 Memorial   Regular School No 1 KG 02 2015   grade_2 84 3 50 5   5     0   9   87 69                       156 84 3 50 5   5     0   9   87 69                 156
739961 739961 MA Worcester   school 2507890 186   Millbury 250789001248 1860017 Elmwood Street   Regular School No 1 PK 03 2015   kindergarten 111 5 6 0   4     0   9   73 62                       135 111 5 6 0   4     0   9   73 62                 135
740010 740010 MA Norfolk   school 2507980 189   Milton 250798001263 1890020 Tucker   Regular School No 1 KG 05 2015   grade_1 23 22 9 0   5     0   9   41 27                       68 23 22 9 0   5     0   9   41 27                 68
740016 740016 MA Norfolk   school 2507980 189   Milton 250798001257 1890410 Charles S Pierce Middle   Regular School No 2 06 08 2015   grade_7 192 47 22 1   17     1   9   153 136                       289 192 47 22 1   17     1   9   153 136                 289
740021 740021 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton High   Regular School No 3 09 12 2015   grade_11 151 51 9 0   11     1   9   106 126                       232 151 51 9 0   11     1   9   106 126                 232
740091 740091 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Wilson Middle   Regular School No 2 05 08 2015   grade_5 189 5 7 1   9     0   9   116 104                       220 189 5 7 1   9     0   9   116 104                 220
740125 740125 MA Norfolk   school 2508370 199   Needham 250837000306 1990050 Newman Elementary   Regular School No 1 PK 05 2015   pre_kindergarten 58 2 3 0   10     0   9   55 27                       82 58 2 3 0   10     0   9   55 27                 82
740165 740165 MA Bristol   school 2508430 201   New Bedford 250843001341 2010045 Sgt Wm H Carney Academy   Regular School No 1 PK 05 2015   kindergarten 41 26 38 0   0     0   9   69 45                       114 41 26 38 0   0     0   9   69 45                 114
740169 740169 MA Bristol   school 2508430 201   New Bedford 250843001341 2010045 Sgt Wm H Carney Academy   Regular School No 1 PK 05 2015   grade_3 51 18 34 0   1     0   9   57 56                       113 51 18 34 0   1     0   9   57 56                 113
740171 740171 MA Bristol   school 2508430 201   New Bedford 250843001341 2010045 Sgt Wm H Carney Academy   Regular School No 1 PK 05 2015   grade_5 33 19 31 1   2     1   9   55 41                       96 33 19 31 1   2     1   9   55 41                 96
740200 740200 MA Bristol   school 2508430 201   New Bedford 250843001327 2010078 Hayden/McFadden   Regular School No 1 PK 05 2015   grade_3 43 11 40 1   0     0   9   49 55                       104 43 11 40 1   0     0   9   49 55                 104
740232 740232 MA Bristol   school 2508430 201   New Bedford 250843001320 2010123 Casimir Pulaski   Regular School No 1 PK 05 2015   grade_2 66 3 16 0   0     0   9   53 41                       94 66 3 16 0   0     0   9   53 41                 94
740274 740274 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No 2 06 08 2015   grade_8 88 25 93 0   0     3   9   122 96                       218 88 25 93 0   0     3   9   122 96                 218
740358 740358 MA Middlesex   school 2508610 207   Newton 250861001371 2070080 Mason-Rice   Regular School No 1 KG 05 2015   grade_4 52 1 3 0   7     0   9   35 37                       72 52 1 3 0   7     0   9   35 37                 72
740371 740371 MA Middlesex   school 2508610 207   Newton 250861001373 2070105 Memorial Spaulding   Regular School No 1 KG 05 2015   grade_5 39 5 3 0   15     0   9   33 38                       71 39 5 3 0   15     0   9   33 38                 71
740395 740395 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No 1 KG 05 2015   grade_4 41 0 0 1   8     0   9   28 31                       59 41 0 0 1   8     0   9   28 31                 59
740401 740401 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Charles E Brown Middle   Regular School No 2 06 08 2015   grade_7 152 13 16 1   51     0   9   123 119                       242 152 13 16 1   51     0   9   123 119                 242

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