enrollments

Data source: Big Local News · About: Big Local

9,541 rows where state = "MA" and year = 2015 sorted by black descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2015 · 9,541 ✖
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
737124 737124 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No 1 KG 08 2015   grade_5 9 99 14 0   3     1   6   65 67                       132 9 99 14 0   3     1   6   65 67                 132
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
738009 738009 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No 3 09 12 2015   grade_11 163 99 149 2   30     0   6   236 213                       449 163 99 149 2   30     0   6   236 213                 449
739607 739607 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No 3 09 12 2015   grade_10 123 98 94 1   102     1   22   223 218                       441 123 98 94 1   102     1   22   223 218                 441
745154 745154 MA Suffolk   school 2500548 3504   City on a Hill Charter Public School Dudley Square (District) 250054802781 35040505 City on a Hill Charter Public School Dudley Square   Regular School Yes 4 09 10 2015   grade_9 3 98 30 0   3     0   3   64 73                       137 3 98 30 0   3     0   3   64 73                 137
736856 736856 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No 3 07 12 2015   grade_9 90 97 68 1   73     1   6   144 192                       336 90 97 68 1   73     1   6   144 192                 336
736924 736924 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No 4 06 12 2015   grade_8 4 97 27 1   9     0   2   74 66                       140 4 97 27 1   9     0   2   74 66                 140
737122 737122 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No 1 KG 08 2015   grade_3 8 97 11 1   1     0   4   67 55                       122 8 97 11 1   1     0   4   67 55                 122
737152 737152 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No 2 06 08 2015   grade_6 47 97 23 0   11     0   11   106 83                       189 47 97 23 0   11     0   11   106 83                 189
737162 737162 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No 2 06 08 2015   grade_7 58 97 54 1   5     0   6   108 113                       221 58 97 54 1   5     0   6   108 113                 221
739606 739606 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No 3 09 12 2015   grade_9 133 97 138 2   117     0   15   274 228                       502 133 97 138 2   117     0   15   274 228                 502
737146 737146 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 East Middle School   Regular School No 2 06 08 2015   grade_6 19 96 18 0   1     1   7   77 65                       142 19 96 18 0   1     1   7   77 65                 142
737156 737156 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No 2 06 08 2015   grade_7 69 95 32 1   8     2   8   113 102                       215 69 95 32 1   8     2   8   113 102                 215
739609 739609 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No 3 09 12 2015   grade_12 148 95 97 2   114     2   16   246 228                       474 148 95 97 2   114     2   16   246 228                 474
736923 736923 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No 4 06 12 2015   grade_7 3 94 27 1   7     0   2   75 59                       134 3 94 27 1   7     0   2   75 59                 134
736806 736806 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No 3 09 12 2015   grade_12 9 93 74 1   42     0   1   118 102                       220 9 93 74 1   42     0   1   118 102                 220
740276 740276 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2015   grade_10 297 93 274 3   5     3   32   369 338                       707 297 93 274 3   5     3   32   369 338                 707
741996 741996 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No 3 09 12 2015   grade_11 73 93 212 0   26     0   16   210 210                       420 73 93 212 0   26     0   16   210 210                 420
743479 743479 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter School   Regular School Yes 3 09 12 2015   grade_12 16 93 48 1   3     1   4   73 93                       166 16 93 48 1   3     1   4   73 93                 166
741165 741165 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph High   Regular School No 3 09 12 2015   grade_9 25 92 14 1   36     1   10   97 82                       179 25 92 14 1   36     1   10   97 82                 179
745112 745112 MA Bristol   school 2511020 872   Southeastern Regional Vocational Technical 251102002290 8720605 Southeastern Regional Vocational Technical   Vocational Education School No 3 09 12 2015   grade_11 175 92 39 0   1     0   6   168 145                       313 175 92 39 0   1     0   6   168 145                 313
736893 736893 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No 3 07 12 2015   grade_12 31 91 57 0   57     1   1   111 127                       238 31 91 57 0   57     1   1   111 127                 238
737123 737123 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No 1 KG 08 2015   grade_4 9 91 17 1   4     0   6   69 59                       128 9 91 17 1   4     0   6   69 59                 128
736817 736817 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Jeremiah E Burke High   Regular School No 3 09 12 2015   grade_9 4 90 38 0   2     0   1   85 50                       135 4 90 38 0   2     0   1   85 50                 135
743790 743790 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston   Regular School Yes 2 06 08 2015   grade_8 13 90 53 0   5     0   3   80 84                       164 13 90 53 0   5     0   3   80 84                 164
743819 743819 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes 2 05 08 2015   grade_8 2 90 60 0   0     0   4   75 81                       156 2 90 60 0   0     0   4   75 81                 156
735869 735869 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No 3 09 12 2015   grade_12 142 9 8 0   4     0   5   80 88                       168 142 9 8 0   4     0   5   80 88                 168
735898 735898 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No 2 05 08 2015   grade_7 134 9 11 0   8     0   4   94 72                       166 134 9 11 0   8     0   4   94 72                 166
736056 736056 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No 2 05 08 2015   grade_5 240 9 14 0   54     0   22   165 174                       339 240 9 14 0   54     0   22   165 174                 339
736112 736112 MA Essex   school 2502640 30   Beverly 250264000165 300305 Briscoe Middle   Regular School No 2 06 08 2015   grade_6 268 9 30 0   7     0   8   170 152                       322 268 9 30 0   7     0   8   170 152                 322
736118 736118 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly High   Regular School No 3 09 12 2015   grade_12 281 9 26 0   7     0   2   135 190                       325 281 9 26 0   7     0   2   135 190                 325
736183 736183 MA Suffolk   school 2502790 35   Boston 250279002514 350006 ELC - West Zone   Regular School No 1 PK 01 2015   kindergarten 0 9 24 0   4     0   1   17 21                       38 0 9 24 0   4     0   1   17 21                 38
736317 736317 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No 1 PK 08 2015   grade_3 23 9 5 0   1     0   1   17 22                       39 23 9 5 0   1     0   1   17 22                 39
736325 736325 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No 1 PK 05 2015   grade_1 9 9 20 0   0     0   3   17 24                       41 9 9 20 0   0     0   3   17 24                 41
736326 736326 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No 1 PK 05 2015   grade_2 17 9 14 0   0     0   3   23 20                       43 17 9 14 0   0     0   3   23 20                 43
736345 736345 MA Suffolk   school 2502790 35   Boston 250279000241 350122 George H Conley   Regular School No 1 PK 05 2015   grade_4 2 9 7 0   2     0   2   12 10                       22 2 9 7 0   2     0   2   12 10                 22
736414 736414 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No 1 PK 05 2015   grade_4 5 9 7 1   0     0   1   15 8                       23 5 9 7 1   0     0   1   15 8                 23
736415 736415 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No 1 PK 05 2015   grade_5 6 9 5 0   1     0   2   13 10                       23 6 9 5 0   1     0   2   13 10                 23
736513 736513 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No 1 KG 05 2015   grade_5 5 9 6 0   2     0   1   16 7                       23 5 9 6 0   2     0   1   16 7                 23
736523 736523 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No 1 PK 08 2015   grade_1 22 9 15 0   20     0   1   38 29                       67 22 9 15 0   20     0   1   38 29                 67
736531 736531 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No 1 PK 05 2015   kindergarten 2 9 6 0   1     0   2   5 15                       20 2 9 6 0   1     0   2   5 15                 20
736534 736534 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No 1 PK 05 2015   grade_2 0 9 11 0   0     0   2   10 12                       22 0 9 11 0   0     0   2   10 12                 22
736584 736584 MA Suffolk   school 2502790 35   Boston 250279000303 350266 Dr. William Henderson Lower   Regular School No 1 PK 04 2015   grade_2 24 9 14 0   2     0   0   29 20                       49 24 9 14 0   2     0   0   29 20                 49
736586 736586 MA Suffolk   school 2502790 35   Boston 250279000303 350266 Dr. William Henderson Lower   Regular School No 1 PK 04 2015   grade_4 7 9 5 0   2     0   0   14 9                       23 7 9 5 0   2     0   0   14 9                 23
736629 736629 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No 1 PK 08 2015   kindergarten 1 9 29 0   1     1   0   19 22                       41 1 9 29 0   1     1   0   19 22                 41
736644 736644 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No 1 PK 08 2015   grade_4 8 9 24 0   3     1   1   25 21                       46 8 9 24 0   3     1   1   25 21                 46
736649 736649 MA Suffolk   school 2502790 35   Boston 250279000332 350328 Thomas J Kenny   Regular School No 1 PK 05 2015   kindergarten 9 9 7 0   15     0   3   16 27                       43 9 9 7 0   15     0   3   16 27                 43
736689 736689 MA Suffolk   school 2502790 35   Boston 250279000337 350366 William E Russell   Regular School No 1 PK 05 2015   grade_3 1 9 26 0   5     0   4   22 23                       45 1 9 26 0   5     0   4   22 23                 45
736690 736690 MA Suffolk   school 2502790 35   Boston 250279000337 350366 William E Russell   Regular School No 1 PK 05 2015   grade_4 2 9 25 0   3     0   1   19 21                       40 2 9 25 0   3     0   1   19 21                 40
736911 736911 MA Suffolk   school 2502790 35   Boston 250279002674 350655 Lyon Upper 9-12   Regular School No 3 09 12 2015   grade_11 13 9 11 0   1     0   2   20 16                       36 13 9 11 0   1     0   2   20 16                 36
736912 736912 MA Suffolk   school 2502790 35   Boston 250279002674 350655 Lyon Upper 9-12   Regular School No 3 09 12 2015   grade_12 9 9 9 0   3     0   2   20 12                       32 9 9 9 0   3     0   2   20 12                 32
737004 737004 MA Norfolk   school 2502940 40   Braintree 250294002789 400009 Monatiquot Kindergarten Center   Regular School No 1 KG KG 2015   kindergarten 215 9 21 1   39     0   4   151 138                       289 215 9 21 1   39     0   4   151 138                 289
737030 737030 MA Norfolk   school 2502940 40   Braintree 250294000363 400050 Donald Ross   Regular School No 1 01 05 2015   grade_4 39 9 6 1   4     0   0   28 31                       59 39 9 6 1   4     0   0   28 31                 59
737038 737038 MA Norfolk   school 2502940 40   Braintree 250294000361 400505 Braintree High   Regular School No 3 09 12 2015   pre_kindergarten 81 9 1 1   11     0   3   61 45                       106 81 9 1 1   11     0   3   61 45                 106
737130 737130 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 B B Russell Alternative School   Regular School No 3 07 12 2015   grade_9 2 9 1 0   0     0   0   8 4                       12 2 9 1 0   0     0   0   8 4                 12
737191 737191 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No 1 KG 08 2015   grade_4 37 9 2 0   19     0   8   40 35                       75 37 9 2 0   19     0   8   40 35                 75
737236 737236 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No 1 KG 08 2015   grade_2 42 9 10 1   16     0   2   37 43                       80 42 9 10 1   16     0   2   37 43                 80
737237 737237 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No 1 KG 08 2015   grade_3 29 9 13 0   11     0   2   28 36                       64 29 9 13 0   11     0   2   28 36                 64
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
737308 737308 MA Middlesex   school 2503270 49   Cambridge 250327000435 490005 Maria L. Baldwin   Regular School No 1 PK 05 2015   grade_5 16 9 2 0   9     0   6   27 15                       42 16 9 2 0   9     0   6   27 15                 42
737321 737321 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridgeport   Regular School No 1 PK 05 2015   grade_1 25 9 1 0   4     0   4   22 21                       43 25 9 1 0   4     0   4   22 21                 43
737324 737324 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridgeport   Regular School No 1 PK 05 2015   grade_4 20 9 4 0   4     0   1   17 21                       38 20 9 4 0   4     0   1   17 21                 38
737327 737327 MA Middlesex   school 2503270 49   Cambridge 250327000441 490020 Haggerty   Regular School No 1 PK 05 2015   pre_kindergarten 14 9 2 0   2     0   1   13 15                       28 14 9 2 0   2     0   1   13 15                 28
737330 737330 MA Middlesex   school 2503270 49   Cambridge 250327000441 490020 Haggerty   Regular School No 1 PK 05 2015   grade_3 16 9 1 0   5     0   4   17 18                       35 16 9 1 0   5     0   4   17 18                 35
737337 737337 MA Middlesex   school 2503270 49   Cambridge 250327000443 490030 Martin Luther King Jr.   Regular School No 1 PK 05 2015   grade_3 10 9 3 0   8     0   2   12 20                       32 10 9 3 0   8     0   2   12 20                 32
737346 737346 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative Education School No 1 PK 05 2015   grade_5 19 9 9 1   3     0   2   29 14                       43 19 9 9 1   3     0   2   29 14                 43
737354 737354 MA Middlesex   school 2503270 49   Cambridge 250327000446 490045 Morse   Regular School No 1 PK 05 2015   kindergarten 17 9 5 0   11     0   7   27 22                       49 17 9 5 0   11     0   7   27 22                 49
737365 737365 MA Middlesex   school 2503270 49   Cambridge 250327000447 490050 Peabody   Regular School No 1 PK 05 2015   grade_3 19 9 4 0   6     0   7   22 23                       45 19 9 4 0   6     0   7   22 23                 45
737368 737368 MA Middlesex   school 2503270 49   Cambridge 250327000442 490065 John M Tobin   Regular School No 1 PK 05 2015   kindergarten 9 9 5 0   8     0   7   13 25                       38 9 9 5 0   8     0   7   13 25                 38
737387 737387 MA Middlesex   school 2503270 49   Cambridge 250327001518 490090 Fletcher/Maynard Academy   Regular School No 1 PK 05 2015   grade_4 7 9 9 0   3     1   1   15 15                       30 7 9 9 0   3     1   1   15 15                 30
737411 737411 MA Norfolk   school 2503300 50   Canton 250330000455 500012 Lt Peter M Hansen   Regular School No 1 KG 05 2015   grade_4 59 9 1 0   7     0   2   34 44                       78 59 9 1 0   7     0   2   34 44                 78
737485 737485 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No 2 05 08 2015   grade_8 185 9 5 0   17     0   4   123 97                       220 185 9 5 0   17     0   4   123 97                 220
737497 737497 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No 1 01 04 2015   grade_2 10 9 122 2   4     0   2   80 69                       149 10 9 122 2   4     0   2   80 69                 149
737499 737499 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No 1 01 04 2015   grade_4 8 9 88 2   3     0   3   57 56                       113 8 9 88 2   3     0   3   57 56                 113
737508 737508 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No 2 05 08 2015   grade_5 8 9 118 1   4     0   3   80 63                       143 8 9 118 1   4     0   3   80 63                 143
737533 737533 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Belcher   Regular School No 1 KG 02 2015   grade_1 64 9 30 0   0     0   1   60 44                       104 64 9 30 0   0     0   1   60 44                 104
737585 737585 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No 2 06 08 2015   grade_7 155 9 131 0   2     0   5   156 146                       302 155 9 131 0   2     0   5   156 146                 302
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
737616 737616 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No 2 04 08 2015   grade_6 101 9 27 0   2     0   3   72 70                       142 101 9 27 0   2     0   3   72 70                 142
737734 737734 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth High   Regular School No 3 09 12 2015   grade_12 229 9 4 1   9     1   1   124 130                       254 229 9 4 1   9     1   1   124 130                 254
737742 737742 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No 1 01 05 2015   grade_4 39 9 12 0   1     0   5   30 36                       66 39 9 12 0   1     0   5   30 36                 66
737808 737808 MA Middlesex   school 2504320 79   Dracut 250432000578 790035 Brookside Elementary   Regular School No 1 KG 05 2015   grade_1 62 9 4 0   2     0   0   37 40                       77 62 9 4 0   2     0   0   37 40                 77
737811 737811 MA Middlesex   school 2504320 79   Dracut 250432000578 790035 Brookside Elementary   Regular School No 1 KG 05 2015   grade_4 53 9 9 0   6     0   0   45 32                       77 53 9 9 0   6     0   0   45 32                 77
737821 737821 MA Middlesex   school 2504320 79   Dracut 250432001625 790410 Justus C. Richardson Middle School   Regular School No 2 06 08 2015   grade_8 261 9 26 0   17     0   6   172 147                       319 261 9 26 0   17     0   6   172 147                 319
737823 737823 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut Senior High   Regular School No 3 09 12 2015   grade_10 156 9 10 0   11     1   4   97 94                       191 156 9 10 0   11     1   4   97 94                 191
737825 737825 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut Senior High   Regular School No 3 09 12 2015   grade_12 204 9 9 0   9     0   2   117 116                       233 204 9 9 0   9     0   2   117 116                 233
737855 737855 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No 3 07 12 2015   grade_9 157 9 3 0   0     2   2   82 91                       173 157 9 3 0   0     2   2   82 91                 173
737952 737952 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No 1 KG 08 2015   grade_2 16 9 46 1   5     0   1   39 39                       78 16 9 46 1   5     0   1   39 39                 78
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
738041 738041 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No 1 KG 05 2015   grade_2 63 9 32 0   6     0   17   63 64                       127 63 9 32 0   6     0   17   63 64                 127
738042 738042 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No 1 KG 05 2015   grade_3 60 9 20 0   4     0   11   54 50                       104 60 9 20 0   4     0   11   54 50                 104
738045 738045 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Mary Fonseca Elementary School   Regular School No 1 KG 05 2015   kindergarten 61 9 40 0   7     0   17   59 75                       134 61 9 40 0   7     0   17   59 75                 134
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
738242 738242 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No 1 KG 05 2015   grade_3 30 9 48 0   2     0   4   54 39                       93 30 9 48 0   2     0   4   54 39                 93
738277 738277 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No 1 KG 05 2015   grade_2 57 9 29 0   2     0   8   52 53                       105 57 9 29 0   2     0   8   52 53                 105
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
738591 738591 MA Essex   school 2505970 128   Haverhill 250597000848 1280035 Caleb Dustin Hunking   Regular School No 2 06 08 2015   grade_8 109 9 17 0   2     1   0   64 74                       138 109 9 17 0   2     1   0   64 74                 138
738629 738629 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 KG 08 2015   grade_7 131 9 81 1   5     0   1   111 117                       228 131 9 81 1   5     0   1   111 117                 228
739074 739074 MA Worcester   school 2506780 153   Leominster 250678000981 1530007 Fall Brook   Regular School No 1 KG 05 2015   grade_3 63 9 41 0   0     0   3   63 53                       116 63 9 41 0   0     0   3   63 53                 116
739090 739090 MA Worcester   school 2506780 153   Leominster 250678000988 1530030 Northwest   Regular School No 1 KG 05 2015   grade_1 83 9 44 0   1     0   6   82 61                       143 83 9 44 0   1     0   6   82 61                 143

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