enrollments

Data source: Big Local News · About: Big Local

9,565 rows where state = "MA" and year = 2019 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 9,465 ✖
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
2042431 2042431 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No Elementary KG 05 2019   grade_5 75 6 6 0   2     0   5   56 38                       94.0 75 6 6 0   2     0   5   56 38                 94
2042432 2042432 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Mary E Stapleton Elementary   Regular School No Elementary KG 05 2019   kindergarten 26 2 15 0   2     0   3   27 21                       48.0 26 2 15 0   2     0   3   27 21                 48
2042433 2042433 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Mary E Stapleton Elementary   Regular School No Elementary KG 05 2019   grade_1 43 6 4 0   3     0   1   29 28                       57.0 43 6 4 0   3     0   1   29 28                 57
2042434 2042434 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Mary E Stapleton Elementary   Regular School No Elementary KG 05 2019   grade_2 25 1 14 0   2     0   3   28 17                       45.0 25 1 14 0   2     0   3   28 17                 45
2042435 2042435 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Mary E Stapleton Elementary   Regular School No Elementary KG 05 2019   grade_3 40 6 11 0   2     0   4   37 26                       63.0 40 6 11 0   2     0   4   37 26                 63
2042436 2042436 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Mary E Stapleton Elementary   Regular School No Elementary KG 05 2019   grade_4 27 8 11 0   3     0   4   30 23                       53.0 27 8 11 0   3     0   4   30 23                 53
2042437 2042437 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Mary E Stapleton Elementary   Regular School No Elementary KG 05 2019   grade_5 50 3 13 0   0     0   4   38 32                       70.0 50 3 13 0   0     0   4   38 32                 70
2042438 2042438 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No Elementary KG 05 2019   kindergarten 36 6 31 0   1     0   4   41 37                       78.0 36 6 31 0   1     0   4   41 37                 78
2042439 2042439 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No Elementary KG 05 2019   grade_1 36 11 22 0   2     1   7   39 40                       79.0 36 11 22 0   2     1   7   39 40                 79
2042440 2042440 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No Elementary KG 05 2019   grade_2 38 14 28 0   0     0   3   36 47                       83.0 38 14 28 0   0     0   3   36 47                 83
2042441 2042441 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No Elementary KG 05 2019   grade_3 28 5 37 0   2     0   7   39 40                       79.0 28 5 37 0   2     0   7   39 40                 79
2042442 2042442 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No Elementary KG 05 2019   grade_4 38 17 32 0   1     0   6   50 44                       94.0 38 17 32 0   1     0   6   50 44                 94
2042443 2042443 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No Elementary KG 05 2019   grade_5 61 16 26 0   3     1   8   64 51                       115.0 61 16 26 0   3     1   8   64 51                 115
2042444 2042444 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2019   kindergarten 53 15 13 0   0     0   5   41 45                       86.0 53 15 13 0   0     0   5   41 45                 86
2042445 2042445 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2019   grade_1 48 11 18 0   1     0   1   47 32                       79.0 48 11 18 0   1     0   1   47 32                 79
2042446 2042446 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2019   grade_2 59 8 21 1   0     0   1   43 47                       90.0 59 8 21 1   0     0   1   43 47                 90
2042447 2042447 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2019   grade_3 58 6 19 0   0     0   3   40 46                       86.0 58 6 19 0   0     0   3   40 46                 86
2042448 2042448 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2019   grade_4 72 6 15 0   0     0   1   54 40                       94.0 72 6 15 0   0     0   1   54 40                 94
2042449 2042449 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2019   grade_5 74 8 20 0   0     0   2   41 63                       104.0 74 8 20 0   0     0   2   41 63                 104
2042450 2042450 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No Middle 06 08 2019   grade_6 151 18 40 0   7     0   5   106 115                       221.0 151 18 40 0   7     0   5   106 115                 221
2042451 2042451 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No Middle 06 08 2019   grade_7 121 13 36 0   7     0   9   101 85                       186.0 121 13 36 0   7     0   9   101 85                 186
2042452 2042452 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No Middle 06 08 2019   grade_8 123 12 27 0   5     0   7   84 90                       174.0 123 12 27 0   5     0   7   84 90                 174
2042453 2042453 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Fuller Middle   Regular School No Middle 06 08 2019   grade_6 62 18 69 0   1     0   4   89 65                       154.0 62 18 69 0   1     0   4   89 65                 154
2042454 2042454 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Fuller Middle   Regular School No Middle 06 08 2019   grade_7 113 19 74 0   4     1   5   114 102                       216.0 113 19 74 0   4     1   5   114 102                 216
2042455 2042455 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Fuller Middle   Regular School No Middle 06 08 2019   grade_8 70 22 65 0   6     1   12   92 84                       176.0 70 22 65 0   6     1   12   92 84                 176
2042456 2042456 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No Middle 06 08 2019   grade_6 135 8 73 0   10     0   16   112 129                       242.0 135 8 73 0   10     0   16   112 129                 242
2042457 2042457 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No Middle 06 08 2019   grade_7 146 8 82 0   9     0   4   130 119                       249.0 146 8 82 0   9     0   4   130 119                 249
2042458 2042458 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No Middle 06 08 2019   grade_8 138 14 72 0   13     0   5   134 108                       242.0 138 14 72 0   13     0   5   134 108                 242
2042459 2042459 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham High School   Regular School No High 09 12 2019   grade_9 337 50 156 2   35     1   21   300 302                       602.0 337 50 156 2   35     1   21   300 302                 602
2042460 2042460 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham High School   Regular School No High 09 12 2019   grade_10 345 47 128 0   31     0   23   287 287                       574.0 345 47 128 0   31     0   23   287 287                 574
2042461 2042461 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham High School   Regular School No High 09 12 2019   grade_11 338 35 131 0   28     1   22   282 273                       555.0 338 35 131 0   28     1   22   282 273                 555
2042462 2042462 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham High School   Regular School No High 09 12 2019   grade_12 301 49 126 0   38     0   26   283 257                       540.0 301 49 126 0   38     0   26   283 257                 540
2042463 2042463 MA Norfolk   school 2505010 101   Franklin 250501000986 1010003 Franklin Early Childhood Development Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 83 1 4 1   2     11   5   61 46                       107.0 83 1 4 1   2     11   5   61 46                 107
2042464 2042464 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Jefferson Elementary   Regular School No Elementary KG 05 2019   kindergarten 49 0 2 0   3     1   1   26 30                       56.0 49 0 2 0   3     1   1   26 30                 56
2042465 2042465 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Jefferson Elementary   Regular School No Elementary KG 05 2019   grade_1 46 0 5 0   8     1   1   37 24                       61.0 46 0 5 0   8     1   1   37 24                 61
2042466 2042466 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Jefferson Elementary   Regular School No Elementary KG 05 2019   grade_2 39 0 2 0   0     1   2   27 17                       44.0 39 0 2 0   0     1   2   27 17                 44
2042467 2042467 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Jefferson Elementary   Regular School No Elementary KG 05 2019   grade_3 47 1 3 0   4     1   1   30 27                       57.0 47 1 3 0   4     1   1   30 27                 57
2042468 2042468 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Jefferson Elementary   Regular School No Elementary KG 05 2019   grade_4 57 0 3 0   8     0   1   38 31                       69.0 57 0 3 0   8     0   1   38 31                 69
2042469 2042469 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Jefferson Elementary   Regular School No Elementary KG 05 2019   grade_5 53 2 0 0   7     0   0   33 29                       62.0 53 2 0 0   7     0   0   33 29                 62
2042470 2042470 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No Elementary KG 05 2019   kindergarten 46 2 2 0   1     0   0   28 23                       51.0 46 2 2 0   1     0   0   28 23                 51
2042471 2042471 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No Elementary KG 05 2019   grade_1 47 1 4 0   2     0   0   27 27                       54.0 47 1 4 0   2     0   0   27 27                 54
2042472 2042472 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No Elementary KG 05 2019   grade_2 59 1 1 0   0     1   4   34 32                       66.0 59 1 1 0   0     1   4   34 32                 66
2042473 2042473 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No Elementary KG 05 2019   grade_3 71 3 1 0   4     1   0   44 36                       80.0 71 3 1 0   4     1   0   44 36                 80
2042474 2042474 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No Elementary KG 05 2019   grade_4 54 0 1 0   3     0   1   27 32                       59.0 54 0 1 0   3     0   1   27 32                 59
2042475 2042475 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No Elementary KG 05 2019   grade_5 74 1 0 0   2     0   0   40 37                       77.0 74 1 0 0   2     0   0   40 37                 77
2042476 2042476 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No Elementary KG 05 2019   kindergarten 45 1 1 0   1     2   0   25 25                       50.0 45 1 1 0   1     2   0   25 25                 50
2042477 2042477 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No Elementary KG 05 2019   grade_1 62 0 3 0   3     0   0   41 27                       68.0 62 0 3 0   3     0   0   41 27                 68
2042478 2042478 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No Elementary KG 05 2019   grade_2 55 0 4 1   2     3   2   35 32                       67.0 55 0 4 1   2     3   2   35 32                 67
2042479 2042479 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No Elementary KG 05 2019   grade_3 55 0 1 0   7     1   1   34 31                       65.0 55 0 1 0   7     1   1   34 31                 65
2042480 2042480 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No Elementary KG 05 2019   grade_4 51 0 3 0   4     0   2   30 30                       60.0 51 0 3 0   4     0   2   30 30                 60
2042481 2042481 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No Elementary KG 05 2019   grade_5 50 1 1 0   1     1   1   28 27                       55.0 50 1 1 0   1     1   1   28 27                 55
2042482 2042482 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Oak Street Elementary   Regular School No Elementary KG 05 2019   kindergarten 41 0 4 0   4     0   5   26 28                       54.0 41 0 4 0   4     0   5   26 28                 54
2042483 2042483 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Oak Street Elementary   Regular School No Elementary KG 05 2019   grade_1 57 2 2 0   4     0   0   29 36                       65.0 57 2 2 0   4     0   0   29 36                 65
2042484 2042484 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Oak Street Elementary   Regular School No Elementary KG 05 2019   grade_2 59 0 3 0   4     0   2   36 32                       68.0 59 0 3 0   4     0   2   36 32                 68
2042485 2042485 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Oak Street Elementary   Regular School No Elementary KG 05 2019   grade_3 41 0 1 0   2     0   1   28 17                       45.0 41 0 1 0   2     0   1   28 17                 45
2042486 2042486 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Oak Street Elementary   Regular School No Elementary KG 05 2019   grade_4 53 1 1 0   2     0   0   26 31                       57.0 53 1 1 0   2     0   0   26 31                 57
2042487 2042487 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Oak Street Elementary   Regular School No Elementary KG 05 2019   grade_5 65 2 3 0   6     1   3   43 37                       80.0 65 2 3 0   6     1   3   43 37                 80
2042488 2042488 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No Elementary KG 05 2019   kindergarten 43 3 6 0   1     0   0   29 24                       53.0 43 3 6 0   1     0   0   29 24                 53
2042489 2042489 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No Elementary KG 05 2019   grade_1 37 4 3 0   3     1   3   23 28                       51.0 37 4 3 0   3     1   3   23 28                 51
2042490 2042490 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No Elementary KG 05 2019   grade_2 47 8 2 0   5     1   0   32 31                       63.0 47 8 2 0   5     1   0   32 31                 63
2042491 2042491 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No Elementary KG 05 2019   grade_3 39 4 6 0   4     1   1   24 31                       55.0 39 4 6 0   4     1   1   24 31                 55
2042492 2042492 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No Elementary KG 05 2019   grade_4 54 1 4 0   5     1   0   35 30                       65.0 54 1 4 0   5     1   0   35 30                 65
2042493 2042493 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No Elementary KG 05 2019   grade_5 47 1 3 1   0     0   0   29 23                       52.0 47 1 3 1   0     0   0   29 23                 52
2042494 2042494 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No Elementary KG 05 2019   kindergarten 44 1 3 0   1     1   0   21 29                       50.0 44 1 3 0   1     1   0   21 29                 50
2042495 2042495 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No Elementary KG 05 2019   grade_1 23 1 1 0   1     0   2   13 15                       28.0 23 1 1 0   1     0   2   13 15                 28
2042496 2042496 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No Elementary KG 05 2019   grade_2 38 0 2 0   1     0   0   22 19                       41.0 38 0 2 0   1     0   0   22 19                 41
2042497 2042497 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No Elementary KG 05 2019   grade_3 34 0 1 0   0     0   1   17 19                       36.0 34 0 1 0   0     0   1   17 19                 36
2042498 2042498 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No Elementary KG 05 2019   grade_4 38 0 0 0   0     1   0   21 18                       39.0 38 0 0 0   0     1   0   21 18                 39
2042499 2042499 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No Elementary KG 05 2019   grade_5 40 3 3 0   3     0   1   24 26                       50.0 40 3 3 0   3     0   1   24 26                 50
2042500 2042500 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No Middle 06 08 2019   grade_6 111 2 4 1   4     0   0   70 52                       122.0 111 2 4 1   4     0   0   70 52                 122
2042501 2042501 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No Middle 06 08 2019   grade_7 109 3 5 0   6     1   3   62 65                       127.0 109 3 5 0   6     1   3   62 65                 127
2042502 2042502 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No Middle 06 08 2019   grade_8 145 0 4 0   6     1   2   92 65                       158.0 145 0 4 0   6     1   2   92 65                 158
2042503 2042503 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No Middle 06 08 2019   grade_6 101 5 5 0   8     0   2   68 53                       121.0 101 5 5 0   8     0   2   68 53                 121
2042504 2042504 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No Middle 06 08 2019   grade_7 137 4 2 0   7     1   4   78 77                       155.0 137 4 2 0   7     1   4   78 77                 155
2042505 2042505 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No Middle 06 08 2019   grade_8 119 3 6 0   9     0   1   62 76                       138.0 119 3 6 0   9     0   1   62 76                 138
2042506 2042506 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Horace Mann   Regular School No Middle 06 08 2019   grade_6 139 2 8 0   13     0   2   98 66                       164.0 139 2 8 0   13     0   2   98 66                 164
2042507 2042507 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Horace Mann   Regular School No Middle 06 08 2019   grade_7 132 2 4 0   8     0   3   76 73                       149.0 132 2 4 0   8     0   3   76 73                 149
2042508 2042508 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Horace Mann   Regular School No Middle 06 08 2019   grade_8 133 0 5 0   11     0   6   66 89                       155.0 133 0 5 0   11     0   6   66 89                 155
2042509 2042509 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2019   grade_9 383 6 15 0   33     2   6   221 224                       445.0 383 6 15 0   33     2   6   221 224                 445
2042510 2042510 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2019   grade_10 373 10 10 2   33     0   10   226 212                       438.0 373 10 10 2   33     0   10   226 212                 438
2042511 2042511 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2019   grade_11 383 6 11 0   20     3   14   215 222                       437.0 383 6 11 0   20     3   14   215 222                 437
2042512 2042512 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2019   grade_12 366 10 11 1   26     2   8   208 215                       424.0 366 10 11 1   26     2   8   208 215                 424
2042513 2042513 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             5.0                                             5
2042514 2042514 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No Elementary 02 04 2019   grade_2 124 2 39 0   3     0   11   83 96                       179.0 124 2 39 0   3     0   11   83 96                 179
2042515 2042515 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No Elementary 02 04 2019   grade_3 110 9 44 0   6     0   14   89 94                       183.0 110 9 44 0   6     0   14   89 94                 183
2042516 2042516 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No Elementary 02 04 2019   grade_4 127 2 34 1   0     0   28   113 79                       192.0 127 2 34 1   0     0   28   113 79                 192
2042517 2042517 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No Elementary PK 01 2019   pre_kindergarten 54 5 12 0   0     0   4   41 34                       75.0 54 5 12 0   0     0   4   41 34                 75
2042518 2042518 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No Elementary PK 01 2019   kindergarten 115 3 39 0   0     0   16   102 71                       173.0 115 3 39 0   0     0   16   102 71                 173
2042519 2042519 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No Elementary PK 01 2019   grade_1 121 7 45 0   7     0   10   97 93                       190.0 121 7 45 0   7     0   10   97 93                 190
2042520 2042520 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No Middle 05 07 2019   grade_5 128 2 35 0   4     0   14   102 81                       183.0 128 2 35 0   4     0   14   102 81                 183
2042521 2042521 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No Middle 05 07 2019   grade_6 131 3 48 0   5     0   19   107 99                       206.0 131 3 48 0   5     0   19   107 99                 206
2042522 2042522 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No Middle 05 07 2019   grade_7 127 8 36 0   1     0   17   93 96                       189.0 127 8 36 0   1     0   17   93 96                 189
2042523 2042523 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No High 08 12 2019   grade_8 94 1 34 0   6     0   15   72 78                       150.0 94 1 34 0   6     0   15   72 78                 150
2042524 2042524 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No High 08 12 2019   grade_9 87 7 31 1   3     0   8   82 55                       137.0 87 7 31 1   3     0   8   82 55                 137
2042525 2042525 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No High 08 12 2019   grade_10 104 3 21 0   6     0   8   68 73                       142.0 104 3 21 0   6     0   8   68 73                 142
2042526 2042526 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No High 08 12 2019   grade_11 83 6 26 1   3     0   2   62 59                       121.0 83 6 26 1   3     0   2   62 59                 121
2042527 2042527 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No High 08 12 2019   grade_12 78 0 18 0   4     0   3   49 54                       103.0 78 0 18 0   4     0   3   49 54                 103
2042528 2042528 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No High 08 12 2019   sped_beyond_grade_12 6 0 1 0   0     0   0                             7.0 6 0 1 0   0     0   0                       7
2042529 2042529 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative School No High 09 12 2019   grade_9 7 1 1 0   0     0   1   6 4                       10.0 7 1 1 0   0     0   1   6 4                 10
2042530 2042530 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative School No High 09 12 2019   grade_10 16 0 4 1   0     0   1   17 4                       22.0 16 0 4 1   0     0   1   17 4                 22

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