enrollments

Data source: Big Local News · About: Big Local

70,226 rows where state = "MA"

✎ 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
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
737486 737486 MA Middlesex   school 2503510 56   Chelmsford 250351000475 560505 Chelmsford High   Regular School No 3 09 12 2015   grade_9 316 5 7 0   44     0   7   178 201                       379 316 5 7 0   44     0   7   178 201                 379
737487 737487 MA Middlesex   school 2503510 56   Chelmsford 250351000475 560505 Chelmsford High   Regular School No 3 09 12 2015   grade_10 298 10 16 0   33     0   5   183 179                       362 298 10 16 0   33     0   5   183 179                 362
737488 737488 MA Middlesex   school 2503510 56   Chelmsford 250351000475 560505 Chelmsford High   Regular School No 3 09 12 2015   grade_11 363 3 8 0   45     1   3   202 221                       423 363 3 8 0   45     1   3   202 221                 423
737489 737489 MA Middlesex   school 2503510 56   Chelmsford 250351000475 560505 Chelmsford High   Regular School No 3 09 12 2015   grade_12 359 7 12 1   32     0   2   198 215                       413 359 7 12 1   32     0   2   198 215                 413
737490 737490 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Shurtleff Early Childhood   Regular School No 1 PK KG 2015   kindergarten 66 36 498 0   6     0   11   327 290                       617 66 36 498 0   6     0   11   327 290                 617
737491 737491 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Shurtleff Early Childhood   Regular School No 1 PK KG 2015   pre_kindergarten 24 13 215 1   2     0   1   138 118                       256 24 13 215 1   2     0   1   138 118                 256
737492 737492 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No 1 01 04 2015   grade_1 15 10 127 0   2     0   2   79 77                       156 15 10 127 0   2     0   2   79 77                 156
737493 737493 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No 1 01 04 2015   grade_2 17 13 122 0   1     0   1   76 78                       154 17 13 122 0   1     0   1   76 78                 154
737494 737494 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No 1 01 04 2015   grade_3 23 11 109 0   1     0   1   72 73                       145 23 11 109 0   1     0   1   72 73                 145
737495 737495 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No 1 01 04 2015   grade_4 10 11 92 0   1     0   1   63 52                       115 10 11 92 0   1     0   1   63 52                 115
737496 737496 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No 1 01 04 2015   grade_1 18 11 156 1   2     0   2   98 92                       190 18 11 156 1   2     0   2   98 92                 190
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
737498 737498 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No 1 01 04 2015   grade_3 7 5 98 1   0     0   0   62 49                       111 7 5 98 1   0     0   0   62 49                 111
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
737500 737500 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No 1 01 04 2015   grade_1 10 6 149 0   1     0   2   79 89                       168 10 6 149 0   1     0   2   79 89                 168
737501 737501 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No 1 01 04 2015   grade_2 7 1 124 0   1     0   1   65 69                       134 7 1 124 0   1     0   1   65 69                 134
737502 737502 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No 1 01 04 2015   grade_3 5 1 137 0   2     0   0   81 64                       145 5 1 137 0   2     0   0   81 64                 145
737503 737503 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No 1 01 04 2015   grade_4 12 5 124 0   2     0   0   75 68                       143 12 5 124 0   2     0   0   75 68                 143
737504 737504 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No 1 01 04 2015   grade_1 10 8 129 0   4     0   2   85 68                       153 10 8 129 0   4     0   2   85 68                 153
737505 737505 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No 1 01 04 2015   grade_2 14 10 117 0   0     0   3   68 76                       144 14 10 117 0   0     0   3   68 76                 144
737506 737506 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No 1 01 04 2015   grade_3 15 13 138 0   2     0   0   92 76                       168 15 13 138 0   2     0   0   92 76                 168
737507 737507 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No 1 01 04 2015   grade_4 13 7 122 1   5     0   0   75 73                       148 13 7 122 1   5     0   0   75 73                 148
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
737509 737509 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No 2 05 08 2015   grade_6 9 11 98 0   2     0   1   72 49                       121 9 11 98 0   2     0   1   72 49                 121
737510 737510 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No 2 05 08 2015   grade_7 6 10 106 0   3     0   0   61 64                       125 6 10 106 0   3     0   0   61 64                 125
737511 737511 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No 2 05 08 2015   grade_8 18 13 97 0   3     0   1   58 74                       132 18 13 97 0   3     0   1   58 74                 132
737512 737512 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No 2 05 08 2015   grade_5 1 2 124 0   2     0   1   71 59                       130 1 2 124 0   2     0   1   71 59                 130
737513 737513 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No 2 05 08 2015   grade_6 13 4 116 0   5     0   2   75 65                       140 13 4 116 0   5     0   2   75 65                 140
737514 737514 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No 2 05 08 2015   grade_7 9 3 119 0   3     0   3   64 73                       137 9 3 119 0   3     0   3   64 73                 137
737515 737515 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No 2 05 08 2015   grade_8 9 4 126 0   1     0   1   75 66                       141 9 4 126 0   1     0   1   75 66                 141
737516 737516 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No 2 05 08 2015   grade_5 8 6 93 0   5     0   0   54 58                       112 8 6 93 0   5     0   0   54 58                 112
737517 737517 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No 2 05 08 2015   grade_6 5 13 99 0   5     0   0   65 57                       122 5 13 99 0   5     0   0   65 57                 122
737518 737518 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No 2 05 08 2015   grade_7 10 19 122 1   2     0   0   83 71                       154 10 19 122 1   2     0   0   83 71                 154
737519 737519 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No 2 05 08 2015   grade_8 9 15 130 0   3     0   0   88 69                       157 9 15 130 0   3     0   0   88 69                 157
737520 737520 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No 3 09 12 2015   grade_9 28 39 510 0   12     0   3   324 268                       592 28 39 510 0   12     0   3   324 268                 592
737521 737521 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No 3 09 12 2015   grade_10 27 26 278 0   13     0   2   157 189                       346 27 26 278 0   13     0   2   157 189                 346
737522 737522 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No 3 09 12 2015   grade_11 20 25 259 2   5     0   1   162 150                       312 20 25 259 2   5     0   1   162 150                 312
737523 737523 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No 3 09 12 2015   grade_12 28 27 206 2   9     0   1   151 122                       273 28 27 206 2   9     0   1   151 122                 273
737524 737524 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No 3 09 12 2015   SP * * * *   *     *   *                             4                                             4
737525 737525 MA Hampden   school 2503660 61   Chicopee 250366002571 610001 Szetela Early Childhood Center   Regular School No 1 PK PK 2015   pre_kindergarten 196 3 49 0   4     0   2   140 114                       254 196 3 49 0   4     0   2   140 114                 254
737526 737526 MA Hampden   school 2503660 61   Chicopee 250366000489 610003 Barry   Regular School No 1 KG 05 2015   kindergarten 47 3 15 0   3     0   2   41 29                       70 47 3 15 0   3     0   2   41 29                 70
737527 737527 MA Hampden   school 2503660 61   Chicopee 250366000489 610003 Barry   Regular School No 1 KG 05 2015   grade_1 44 0 16 0   5     1   2   33 35                       68 44 0 16 0   5     1   2   33 35                 68
737528 737528 MA Hampden   school 2503660 61   Chicopee 250366000489 610003 Barry   Regular School No 1 KG 05 2015   grade_2 47 0 17 0   3     0   6   40 33                       73 47 0 17 0   3     0   6   40 33                 73
737529 737529 MA Hampden   school 2503660 61   Chicopee 250366000489 610003 Barry   Regular School No 1 KG 05 2015   grade_3 47 1 25 1   0     0   4   44 34                       78 47 1 25 1   0     0   4   44 34                 78
737530 737530 MA Hampden   school 2503660 61   Chicopee 250366000489 610003 Barry   Regular School No 1 KG 05 2015   grade_4 58 2 17 0   1     0   0   41 37                       78 58 2 17 0   1     0   0   41 37                 78
737531 737531 MA Hampden   school 2503660 61   Chicopee 250366000489 610003 Barry   Regular School No 1 KG 05 2015   grade_5 58 1 21 0   0     0   6   40 46                       86 58 1 21 0   0     0   6   40 46                 86
737532 737532 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Belcher   Regular School No 1 KG 02 2015   kindergarten 51 6 37 0   1     0   1   52 44                       96 51 6 37 0   1     0   1   52 44                 96
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
737534 737534 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Belcher   Regular School No 1 KG 02 2015   grade_2 56 8 49 1   2     0   1   50 67                       117 56 8 49 1   2     0   1   50 67                 117
737535 737535 MA Hampden   school 2503660 61   Chicopee 250366000492 610015 Bowe   Regular School No 1 PK 05 2015   kindergarten 23 4 47 0   0     0   0   43 31                       74 23 4 47 0   0     0   0   43 31                 74
737536 737536 MA Hampden   school 2503660 61   Chicopee 250366000492 610015 Bowe   Regular School No 1 PK 05 2015   pre_kindergarten 11 1 14 0   0     1   1   15 13                       28 11 1 14 0   0     1   1   15 13                 28
737537 737537 MA Hampden   school 2503660 61   Chicopee 250366000492 610015 Bowe   Regular School No 1 PK 05 2015   grade_1 31 1 43 0   0     0   3   41 37                       78 31 1 43 0   0     0   3   41 37                 78
737538 737538 MA Hampden   school 2503660 61   Chicopee 250366000492 610015 Bowe   Regular School No 1 PK 05 2015   grade_2 20 2 46 0   2     0   5   42 33                       75 20 2 46 0   2     0   5   42 33                 75
737539 737539 MA Hampden   school 2503660 61   Chicopee 250366000492 610015 Bowe   Regular School No 1 PK 05 2015   grade_3 28 3 29 0   0     0   1   33 28                       61 28 3 29 0   0     0   1   33 28                 61
737540 737540 MA Hampden   school 2503660 61   Chicopee 250366000492 610015 Bowe   Regular School No 1 PK 05 2015   grade_4 19 2 42 0   0     0   2   35 30                       65 19 2 42 0   0     0   2   35 30                 65
737541 737541 MA Hampden   school 2503660 61   Chicopee 250366000492 610015 Bowe   Regular School No 1 PK 05 2015   grade_5 21 3 28 0   1     0   5   33 25                       58 21 3 28 0   1     0   5   33 25                 58
737542 737542 MA Hampden   school 2503660 61   Chicopee 250366000493 610020 Bowie   Regular School No 1 KG 05 2015   kindergarten 42 3 13 0   0     0   2   30 30                       60 42 3 13 0   0     0   2   30 30                 60
737543 737543 MA Hampden   school 2503660 61   Chicopee 250366000493 610020 Bowie   Regular School No 1 KG 05 2015   grade_1 52 3 11 0   1     0   4   36 35                       71 52 3 11 0   1     0   4   36 35                 71
737544 737544 MA Hampden   school 2503660 61   Chicopee 250366000493 610020 Bowie   Regular School No 1 KG 05 2015   grade_2 50 4 11 0   1     0   2   33 35                       68 50 4 11 0   1     0   2   33 35                 68
737545 737545 MA Hampden   school 2503660 61   Chicopee 250366000493 610020 Bowie   Regular School No 1 KG 05 2015   grade_3 38 2 16 0   0     0   4   29 31                       60 38 2 16 0   0     0   4   29 31                 60
737546 737546 MA Hampden   school 2503660 61   Chicopee 250366000493 610020 Bowie   Regular School No 1 KG 05 2015   grade_4 42 2 15 0   0     0   3   25 37                       62 42 2 15 0   0     0   3   25 37                 62
737547 737547 MA Hampden   school 2503660 61   Chicopee 250366000493 610020 Bowie   Regular School No 1 KG 05 2015   grade_5 46 4 7 0   0     0   0   33 24                       57 46 4 7 0   0     0   0   33 24                 57
737548 737548 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative Education School No 4 06 12 2015   grade_7 2 0 4 0   0     0   0   5 1                       6 2 0 4 0   0     0   0   5 1                 6
737549 737549 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative Education School No 4 06 12 2015   grade_8 4 0 8 0   0     0   0   9 3                       12 4 0 8 0   0     0   0   9 3                 12
737550 737550 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative Education School No 4 06 12 2015   grade_9 14 0 13 0   0     0   0   17 10                       27 14 0 13 0   0     0   0   17 10                 27
737551 737551 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative Education School No 4 06 12 2015   grade_10 4 3 18 0   0     0   3   21 7                       28 4 3 18 0   0     0   3   21 7                 28
737552 737552 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative Education School No 4 06 12 2015   grade_11 6 0 11 0   0     0   1   10 8                       18 6 0 11 0   0     0   1   10 8                 18
737553 737553 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative Education School No 4 06 12 2015   grade_12 6 1 4 0   0     0   0   9 2                       11 6 1 4 0   0     0   0   9 2                 11
737554 737554 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No 1 KG 05 2015   kindergarten 18 0 6 0   1     0   1   12 14                       26 18 0 6 0   1     0   1   12 14                 26
737555 737555 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No 1 KG 05 2015   grade_1 17 1 5 0   0     0   0   12 11                       23 17 1 5 0   0     0   0   12 11                 23
737556 737556 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No 1 KG 05 2015   grade_2 19 0 2 0   1     0   1   15 8                       23 19 0 2 0   1     0   1   15 8                 23
737557 737557 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No 1 KG 05 2015   grade_3 62 5 27 0   3     0   6   55 48                       103 62 5 27 0   3     0   6   55 48                 103
737558 737558 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No 1 KG 05 2015   grade_4 71 6 29 0   1     0   5   67 45                       112 71 6 29 0   1     0   5   67 45                 112
737559 737559 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No 1 KG 05 2015   grade_5 64 4 42 0   1     0   1   65 47                       112 64 4 42 0   1     0   1   65 47                 112
737560 737560 MA Hampden   school 2503660 61   Chicopee 250366000501 610040 Lambert-Lavoie   Regular School No 1 KG 05 2015   kindergarten 41 0 14 0   1     0   2   25 33                       58 41 0 14 0   1     0   2   25 33                 58
737561 737561 MA Hampden   school 2503660 61   Chicopee 250366000501 610040 Lambert-Lavoie   Regular School No 1 KG 05 2015   grade_1 32 2 10 0   0     0   0   22 22                       44 32 2 10 0   0     0   0   22 22                 44
737562 737562 MA Hampden   school 2503660 61   Chicopee 250366000501 610040 Lambert-Lavoie   Regular School No 1 KG 05 2015   grade_2 29 5 12 0   2     0   3   30 21                       51 29 5 12 0   2     0   3   30 21                 51
737563 737563 MA Hampden   school 2503660 61   Chicopee 250366000501 610040 Lambert-Lavoie   Regular School No 1 KG 05 2015   grade_3 31 0 9 0   2     0   1   22 21                       43 31 0 9 0   2     0   1   22 21                 43
737564 737564 MA Hampden   school 2503660 61   Chicopee 250366000501 610040 Lambert-Lavoie   Regular School No 1 KG 05 2015   grade_4 25 3 13 0   2     0   2   23 22                       45 25 3 13 0   2     0   2   23 22                 45
737565 737565 MA Hampden   school 2503660 61   Chicopee 250366000501 610040 Lambert-Lavoie   Regular School No 1 KG 05 2015   grade_5 41 0 11 0   2     0   2   26 30                       56 41 0 11 0   2     0   2   26 30                 56
737566 737566 MA Hampden   school 2503660 61   Chicopee 250366002463 610050 Selser   Regular School No 1 KG 05 2015   kindergarten 35 1 34 0   1     0   3   44 30                       74 35 1 34 0   1     0   3   44 30                 74
737567 737567 MA Hampden   school 2503660 61   Chicopee 250366002463 610050 Selser   Regular School No 1 KG 05 2015   grade_1 31 0 42 1   1     0   0   43 32                       75 31 0 42 1   1     0   0   43 32                 75
737568 737568 MA Hampden   school 2503660 61   Chicopee 250366002463 610050 Selser   Regular School No 1 KG 05 2015   grade_2 48 0 23 0   1     0   1   29 44                       73 48 0 23 0   1     0   1   29 44                 73
737569 737569 MA Hampden   school 2503660 61   Chicopee 250366002463 610050 Selser   Regular School No 1 KG 05 2015   grade_3 37 0 29 1   3     0   2   30 42                       72 37 0 29 1   3     0   2   30 42                 72
737570 737570 MA Hampden   school 2503660 61   Chicopee 250366002463 610050 Selser   Regular School No 1 KG 05 2015   grade_4 29 2 33 0   0     0   5   41 28                       69 29 2 33 0   0     0   5   41 28                 69
737571 737571 MA Hampden   school 2503660 61   Chicopee 250366002463 610050 Selser   Regular School No 1 KG 05 2015   grade_5 27 2 26 0   3     0   2   30 30                       60 27 2 26 0   3     0   2   30 30                 60
737572 737572 MA Hampden   school 2503660 61   Chicopee 250366000504 610065 Streiber Memorial School   Regular School No 1 KG 05 2015   kindergarten 32 1 14 0   1     0   3   25 26                       51 32 1 14 0   1     0   3   25 26                 51
737573 737573 MA Hampden   school 2503660 61   Chicopee 250366000504 610065 Streiber Memorial School   Regular School No 1 KG 05 2015   grade_1 31 0 18 0   2     0   2   28 25                       53 31 0 18 0   2     0   2   28 25                 53
737574 737574 MA Hampden   school 2503660 61   Chicopee 250366000504 610065 Streiber Memorial School   Regular School No 1 KG 05 2015   grade_2 37 2 13 0   1     0   2   30 25                       55 37 2 13 0   1     0   2   30 25                 55
737575 737575 MA Hampden   school 2503660 61   Chicopee 250366000504 610065 Streiber Memorial School   Regular School No 1 KG 05 2015   grade_3 30 3 7 0   1     0   1   22 20                       42 30 3 7 0   1     0   1   22 20                 42
737576 737576 MA Hampden   school 2503660 61   Chicopee 250366000504 610065 Streiber Memorial School   Regular School No 1 KG 05 2015   grade_4 37 0 6 0   1     0   1   23 22                       45 37 0 6 0   1     0   1   23 22                 45
737577 737577 MA Hampden   school 2503660 61   Chicopee 250366000504 610065 Streiber Memorial School   Regular School No 1 KG 05 2015   grade_5 34 1 8 0   1     0   2   24 22                       46 34 1 8 0   1     0   2   24 22                 46
737578 737578 MA Hampden   school 2503660 61   Chicopee 250366000500 610090 Gen John J Stefanik   Regular School No 1 KG 05 2015   kindergarten 15 4 48 0   1     0   2   36 34                       70 15 4 48 0   1     0   2   36 34                 70
737579 737579 MA Hampden   school 2503660 61   Chicopee 250366000500 610090 Gen John J Stefanik   Regular School No 1 KG 05 2015   grade_1 10 2 66 0   0     0   1   49 30                       79 10 2 66 0   0     0   1   49 30                 79
737580 737580 MA Hampden   school 2503660 61   Chicopee 250366000500 610090 Gen John J Stefanik   Regular School No 1 KG 05 2015   grade_2 14 5 57 0   0     0   1   42 35                       77 14 5 57 0   0     0   1   42 35                 77
737581 737581 MA Hampden   school 2503660 61   Chicopee 250366000500 610090 Gen John J Stefanik   Regular School No 1 KG 05 2015   grade_3 11 4 43 0   0     0   3   32 29                       61 11 4 43 0   0     0   3   32 29                 61
737582 737582 MA Hampden   school 2503660 61   Chicopee 250366000500 610090 Gen John J Stefanik   Regular School No 1 KG 05 2015   grade_4 9 4 51 0   1     0   2   29 38                       67 9 4 51 0   1     0   2   29 38                 67
737583 737583 MA Hampden   school 2503660 61   Chicopee 250366000500 610090 Gen John J Stefanik   Regular School No 1 KG 05 2015   grade_5 10 4 47 0   1     0   1   33 30                       63 10 4 47 0   1     0   1   33 30                 63
737584 737584 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No 2 06 08 2015   grade_6 178 12 118 1   7     0   8   169 155                       324 178 12 118 1   7     0   8   169 155                 324

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