enrollments

Data source: Big Local News · About: Big Local

6,880 rows where grade = "grade_1" and state = "MA" sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_1 · 6,780 ✖
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
2042398 2042398 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No Elementary KG 04 2019   grade_1 41 1 4 0   5     0   7   31 27                       58.0 41 1 4 0   5     0   7   31 27                 58
2042403 2042403 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2019   grade_1 21 5 34 0   3     0   2   32 33                       65.0 21 5 34 0   3     0   2   32 33                 65
2042409 2042409 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2019   grade_1 47 4 6 0   5     0   1   38 25                       63.0 47 4 6 0   5     0   1   38 25                 63
2042415 2042415 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2019   grade_1 48 10 13 0   7     0   8   40 46                       86.0 48 10 13 0   7     0   8   40 46                 86
2042421 2042421 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2019   grade_1 19 3 93 0   1     0   4   49 71                       120.0 19 3 93 0   1     0   4   49 71                 120
2042427 2042427 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No Elementary KG 05 2019   grade_1 58 11 8 0   3     0   6   39 47                       86.0 58 11 8 0   3     0   6   39 47                 86
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
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
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
2231789 2231789 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 Framingham: King Elementary School   Regular School No Elementary KG 03 2018   grade_1 50 8 1 0   11     0   5   42 33                       75.0 50 8 1 0   11     0   5   42 33                 75
2231794 2231794 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Framingham: Brophy   Regular School No Elementary KG 05 2018   grade_1 21 4 27 0   2     0   2   19 37                       56.0 21 4 27 0   2     0   2   19 37                 56
2231801 2231801 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Framingham: Charlotte A Dunning   Regular School No Elementary KG 05 2018   grade_1 40 8 8 0   10     0   2   45 23                       68.0 40 8 8 0   10     0   2   45 23                 68
2231808 2231808 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Framingham: Hemenway   Regular School No Elementary KG 05 2018   grade_1 66 4 13 1   9     0   2   45 50                       95.0 66 4 13 1   9     0   2   45 50                 95
2231815 2231815 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Framingham: Barbieri Elementary   Regular School No Elementary KG 05 2018   grade_1 19 7 80 0   0     0   5   53 58                       111.0 19 7 80 0   0     0   5   53 58                 111
2231822 2231822 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Framingham: Potter Road   Regular School No Elementary KG 05 2018   grade_1 57 8 5 0   6     0   8   43 41                       84.0 57 8 5 0   6     0   8   43 41                 84
2231829 2231829 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Framingham: Mary E Stapleton Elementary   Regular School No Elementary KG 05 2018   grade_1 31 1 11 0   2     0   2   28 19                       47.0 31 1 11 0   2     0   2   28 19                 47
2231836 2231836 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Framingham: Miriam F McCarthy School   Regular School No Elementary KG 05 2018   grade_1 43 13 30 0   0     1   3   38 52                       90.0 43 13 30 0   0     1   3   38 52                 90
2231843 2231843 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Framingham: Woodrow Wilson   Regular School No Elementary KG 05 2018   grade_1 49 6 22 1   0     0   2   39 41                       80.0 49 6 22 1   0     0   2   39 41                 80
738302 738302 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Jefferson Elementary   Regular School No 1 KG 05 2015   grade_1 45 2 0 0   8     1   0   27 29                       56 45 2 0 0   8     1   0   27 29                 56
738308 738308 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No 1 KG 05 2015   grade_1 65 1 0 0   2     1   0   37 32                       69 65 1 0 0   2     1   0   37 32                 69
738314 738314 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No 1 KG 05 2015   grade_1 53 1 1 0   0     0   1   32 24                       56 53 1 1 0   0     0   1   32 24                 56
738320 738320 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Oak Street Elementary   Regular School No 1 KG 05 2015   grade_1 60 1 2 0   5     0   3   35 36                       71 60 1 2 0   5     0   3   35 36                 71
738326 738326 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No 1 KG 05 2015   grade_1 46 0 3 1   6     0   0   33 23                       56 46 0 3 1   6     0   0   33 23                 56
738332 738332 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No 1 KG 05 2015   grade_1 37 1 1 0   0     0   0   20 19                       39 37 1 1 0   0     0   0   20 19                 39
935156 935156 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Jefferson Elementary   Regular School No 1 KG 05 2016   grade_1 55 2 2 0   6     0   1   39 27                       66 55 2 2 0   6     0   1   39 27                 66
935162 935162 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No 1 KG 05 2016   grade_1 47 0 0 0   3     0   1   22 29                       51 47 0 0 0   3     0   1   22 29                 51
935168 935168 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No 1 KG 05 2016   grade_1 44 0 2 0   4     0   2   24 28                       52 44 0 2 0   4     0   2   24 28                 52
935174 935174 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Oak Street Elementary   Regular School No 1 KG 05 2016   grade_1 56 0 3 0   1     0   0   28 32                       60 56 0 3 0   1     0   0   28 32                 60
935180 935180 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No 1 KG 05 2016   grade_1 55 0 1 0   3     1   0   34 26                       60 55 0 1 0   3     1   0   34 26                 60
935186 935186 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No 1 KG 05 2016   grade_1 41 0 0 0   0     0   0   21 20                       41 41 0 0 0   0     0   0   21 20                 41
1125040 1125040 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Jefferson Elementary   Regular School No Elementary KG 05 2017   grade_1 42 2 2 0   3     1   1   25 26                       51 42 2 2 0   3     1   1   25 26                 51
1125047 1125047 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No Elementary KG 05 2017   grade_1 67 3 1 0   4     1   0   43 33                       76 67 3 1 0   4     1   0   43 33                 76
1125054 1125054 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No Elementary KG 05 2017   grade_1 52 0 1 0   8     1   1   34 29                       63 52 0 1 0   8     1   1   34 29                 63
1125061 1125061 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Oak Street Elementary   Regular School No Elementary KG 05 2017   grade_1 42 0 3 0   3     0   1   30 19                       49 42 0 3 0   3     0   1   30 19                 49
1125068 1125068 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No Elementary KG 05 2017   grade_1 38 1 1 0   5     1   1   19 28                       47 38 1 1 0   5     1   1   19 28                 47
1125075 1125075 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No Elementary KG 05 2017   grade_1 32 0 0 0   0     0   0   17 15                       32 32 0 0 0   0     0   0   17 15                 32
1367394 1367394 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Jefferson Elementary   Regular School No Elementary KG 05 2020   grade_1 52 1 2 0   2     1   1   29 30 *                     59.0 52 1 2 0   2     1   1   29 30                 59
1367400 1367400 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No Elementary KG 05 2020   grade_1 44 2 2 0   1     0   0   27 22 *                     49.0 44 2 2 0   1     0   0   27 22                 49
1367406 1367406 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No Elementary KG 05 2020   grade_1 49 1 1 0   1     2   0   31 23 *                     54.0 49 1 1 0   1     2   0   31 23                 54
1367412 1367412 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Oak Street Elementary   Regular School No Elementary KG 05 2020   grade_1 48 0 4 0   2     0   5   30 29 *                     59.0 48 0 4 0   2     0   5   30 29                 59
1367418 1367418 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No Elementary KG 05 2020   grade_1 41 3 6 0   1     0   0   26 25 *                     51.0 41 3 6 0   1     0   0   26 25                 51
1367424 1367424 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No Elementary KG 05 2020   grade_1 43 2 3 0   3     2   0   23 30 *                     53.0 43 2 3 0   3     2   0   23 30                 53
1674628 1674628 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Franklin - Jefferson Elementary   Regular School No Elementary KG 05 2021   grade_1 33 0 1 0   2     0   1   24 13 *                     37.0 33 0 1 0   2     0   1   24 13                 37
1674634 1674634 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Franklin - Helen Keller Elementary   Regular School No Elementary KG 05 2021   grade_1 43 1 1 0   5     0   1   25 26 *                     51.0 43 1 1 0   5     0   1   25 26                 51
1674640 1674640 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 Franklin - J F Kennedy Memorial   Regular School No Elementary KG 05 2021   grade_1 30 1 0 0   2     0   1   15 19 *                     34.0 30 1 0 0   2     0   1   15 19                 34
1674646 1674646 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Franklin - Oak Street Elementary   Regular School No Elementary KG 05 2021   grade_1 50 3 2 0   1     1   3   31 29 *                     60.0 50 3 2 0   1     1   3   31 29                 60
1674652 1674652 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Franklin - Parmenter   Regular School No Elementary KG 05 2021   grade_1 47 1 3 0   3     1   0   29 26 *                     55.0 47 1 3 0   3     1   0   29 26                 55
1674658 1674658 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Franklin - Davis Thayer   Regular School No Elementary KG 05 2021   grade_1 34 0 5 0   0     0   2   18 23 *                     41.0 34 0 5 0   0     0   2   18 23                 41
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
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
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
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
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
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
2231869 2231869 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Franklin: Jefferson Elementary   Regular School No Elementary KG 05 2018   grade_1 35 0 1 0   0     1   1   22 16                       38.0 35 0 1 0   0     1   1   22 16                 38
2231876 2231876 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Franklin: Helen Keller Elementary   Regular School No Elementary KG 05 2018   grade_1 60 1 0 0   0     1   5   35 32                       67.0 60 1 0 0   0     1   5   35 32                 67
2231883 2231883 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 Franklin: J F Kennedy Memorial   Regular School No Elementary KG 05 2018   grade_1 50 0 4 1   2     3   2   31 31                       62.0 50 0 4 1   2     3   2   31 31                 62
2231890 2231890 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Franklin: Oak Street Elementary   Regular School No Elementary KG 05 2018   grade_1 52 0 3 0   3     0   3   33 28                       61.0 52 0 3 0   3     0   3   33 28                 61
2231897 2231897 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Franklin: Parmenter   Regular School No Elementary KG 05 2018   grade_1 50 6 1 0   5     1   1   35 29                       64.0 50 6 1 0   5     1   1   35 29                 64
2231904 2231904 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Franklin: Davis Thayer   Regular School No Elementary KG 05 2018   grade_1 41 0 1 0   2     0   0   22 22                       44.0 41 0 1 0   2     0   0   22 22                 44
738354 738354 MA Worcester   school 2505130 103   Gardner 250513002470 1030015 Helen Mae Sauter Elementary   Regular School No 1 01 03 2015   grade_1 73 1 9 0   2     1   6   52 40                       92 73 1 9 0   2     1   6   52 40                 92
738359 738359 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No 1 PK 02 2015   grade_1 73 6 23 0   0     0   6   63 45                       108 73 6 23 0   0     0   6   63 45                 108
935210 935210 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No 1 PK 01 2016   grade_1 137 7 26 1   0     0   26   106 91                       197 137 7 26 1   0     0   26   106 91                 197
1125104 1125104 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No Elementary PK 01 2017   grade_1 118 6 35 1   4     0   17   80 101                       181 118 6 35 1   4     0   17   80 101                 181
1367448 1367448 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No Elementary PK 01 2020   grade_1 102 3 38 0   0     0   17   96 64 *                     160.0 102 3 38 0   0     0   17   96 64                 160
1674682 1674682 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Gardner - Waterford Street   Regular School No Elementary PK 01 2021   grade_1 104 6 41 0   2     0   8   87 73 *                     161.0 104 6 41 0   2     0   8   87 73                 161
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
2231933 2231933 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Gardner: Waterford Street   Regular School No Elementary PK 01 2018   grade_1 129 4 37 0   1     0   12   84 99                       183.0 129 4 37 0   1     0   12   84 99                 183
738375 738375 MA Essex   school 2505220 105   Georgetown 250522000766 1050005 Perley Elementary   Regular School No 1 PK 01 2015   grade_1 113 0 2 0   0     1   2   64 54                       118 113 0 2 0   0     1   2   64 54                 118
935226 935226 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No 1 KG 06 2016   grade_1 87 2 3 0   1     0   0   50 43                       93 87 2 3 0   1     0   0   50 43                 93
1125124 1125124 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2017   grade_1 92 0 4 0   4     0   1   54 47                       101 92 0 4 0   4     0   1   54 47                 101
1367463 1367463 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2020   grade_1 106 0 0 0   0     0   5   56 55 *                     111.0 106 0 0 0   0     0   5   56 55                 111
1674698 1674698 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Georgetown - Penn Brook   Regular School No Elementary KG 06 2021   grade_1 98 0 4 0   1     0   2   47 58 *                     105.0 98 0 4 0   1     0   2   47 58                 105
2042535 2042535 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2019   grade_1 99 0 2 0   2     0   2   56 49                       105.0 99 0 2 0   2     0   2   56 49                 105
2231953 2231953 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Georgetown: Penn Brook   Regular School No Elementary KG 06 2018   grade_1 87 0 2 0   0     0   3   45 47                       92.0 87 0 2 0   0     0   3   45 47                 92
738388 738388 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No 1 KG 05 2015   grade_1 49 1 10 1   1     0   3   34 31                       65 49 1 10 1   1     0   3   34 31                 65
738394 738394 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No 1 KG 05 2015   grade_1 34 0 3 0   0     0   3   21 19                       40 34 0 3 0   0     0   3   21 19                 40
738401 738401 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No 1 KG 05 2015   grade_1 36 0 1 0   0     0   0   25 12                       37 36 0 1 0   0     0   0   25 12                 37
738407 738407 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No 1 KG 05 2015   grade_1 33 0 4 0   0     1   1   17 22                       39 33 0 4 0   0     1   1   17 22                 39
738413 738413 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 West Parish   Regular School No 1 KG 05 2015   grade_1 39 0 0 1   1     0   2   20 23                       43 39 0 0 1   1     0   2   20 23                 43
935239 935239 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No 1 KG 05 2016   grade_1 47 0 8 1   3     0   2   40 21                       61 47 0 8 1   3     0   2   40 21                 61
935245 935245 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No 1 KG 05 2016   grade_1 34 0 4 0   0     0   1   24 15                       39 34 0 4 0   0     0   1   24 15                 39
935252 935252 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No 1 KG 05 2016   grade_1 34 0 0 0   0     1   0   17 18                       35 34 0 0 0   0     1   0   17 18                 35
935258 935258 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No 1 KG 05 2016   grade_1 26 0 4 0   0     0   0   12 18                       30 26 0 4 0   0     0   0   12 18                 30
935264 935264 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 West Parish   Regular School No 1 KG 05 2016   grade_1 47 0 5 0   1     0   0   28 25                       53 47 0 5 0   1     0   0   28 25                 53
1125140 1125140 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No Elementary KG 05 2017   grade_1 45 2 8 0   0     0   2   29 28                       57 45 2 8 0   0     0   2   29 28                 57
1125147 1125147 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No Elementary KG 05 2017   grade_1 37 0 4 0   0     0   3   24 20                       44 37 0 4 0   0     0   3   24 20                 44
1125156 1125156 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No Elementary KG 05 2017   grade_1 31 1 2 0   1     0   2   20 17                       37 31 1 2 0   1     0   2   20 17                 37
1125163 1125163 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No Elementary KG 05 2017   grade_1 33 0 10 0   0     0   1   22 22                       44 33 0 10 0   0     0   1   22 22                 44
1125170 1125170 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 West Parish   Regular School No Elementary KG 05 2017   grade_1 53 0 4 0   1     0   5   29 34                       63 53 0 4 0   1     0   5   29 34                 63
1367476 1367476 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No Elementary KG 05 2020   grade_1 42 2 11 0   0     0   3   31 27 *                     58.0 42 2 11 0   0     0   3   31 27                 58
1367482 1367482 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No Elementary KG 05 2020   grade_1 29 0 4 0   1     0   0   18 16 *                     34.0 29 0 4 0   1     0   0   18 16                 34
1367489 1367489 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No Elementary KG 05 2020   grade_1 36 0 0 0   0     0   2   21 17 *                     38.0 36 0 0 0   0     0   2   21 17                 38
1367495 1367495 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No Elementary KG 05 2020   grade_1 15 1 7 0   1     0   3   18 9 *                     27.0 15 1 7 0   1     0   3   18 9                 27
1367501 1367501 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 West Parish   Regular School No Elementary KG 05 2020   grade_1 46 0 5 0   0     0   4   23 32 *                     55.0 46 0 5 0   0     0   4   23 32                 55
1674711 1674711 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Gloucester - Beeman Memorial   Regular School No Elementary KG 05 2021   grade_1 37 4 15 0   0     0   4   30 30 *                     60.0 37 4 15 0   0     0   4   30 30                 60
1674717 1674717 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 Gloucester - East Gloucester Elementary   Regular School No Elementary KG 05 2021   grade_1 18 0 4 0   1     0   3   10 16 *                     26.0 18 0 4 0   1     0   3   10 16                 26
1674724 1674724 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Gloucester - Plum Cove School   Regular School No Elementary KG 05 2021   grade_1 26 0 1 0   0     0   4   16 15 *                     31.0 26 0 1 0   0     0   4   16 15                 31
1674730 1674730 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Gloucester - Veterans Memorial   Regular School No Elementary KG 05 2021   grade_1 28 4 7 0   2     1   0   20 22 *                     42.0 28 4 7 0   2     1   0   20 22                 42
1674736 1674736 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 Gloucester - West Parish   Regular School No Elementary KG 05 2021   grade_1 52 1 4 0   1     0   2   36 24 *                     60.0 52 1 4 0   1     0   2   36 24                 60

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