enrollments

Data source: Big Local News · About: Big Local

6,831 rows where grade = "grade_2" and state = "MA" sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_2 · 6,731 ✖
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
2042404 2042404 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2019   grade_2 19 6 30 0   1     0   2   27 31                       58.0 19 6 30 0   1     0   2   27 31                 58
2042410 2042410 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2019   grade_2 43 10 8 0   11     0   2   48 26                       74.0 43 10 8 0   11     0   2   48 26                 74
2042416 2042416 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2019   grade_2 61 6 13 1   8     1   2   45 47                       92.0 61 6 13 1   8     1   2   45 47                 92
2042422 2042422 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2019   grade_2 19 7 74 0   0     0   4   46 58                       104.0 19 7 74 0   0     0   4   46 58                 104
2042428 2042428 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No Elementary KG 05 2019   grade_2 57 11 5 0   6     1   8   46 42                       88.0 57 11 5 0   6     1   8   46 42                 88
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
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
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
2231790 2231790 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 Framingham: King Elementary School   Regular School No Elementary KG 03 2018   grade_2 47 3 16 0   7     0   7   41 39                       80.0 47 3 16 0   7     0   7   41 39                 80
2231795 2231795 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Framingham: Brophy   Regular School No Elementary KG 05 2018   grade_2 23 6 41 0   3     0   1   37 37                       74.0 23 6 41 0   3     0   1   37 37                 74
2231802 2231802 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Framingham: Charlotte A Dunning   Regular School No Elementary KG 05 2018   grade_2 52 8 5 0   7     0   2   38 36                       74.0 52 8 5 0   7     0   2   38 36                 74
2231809 2231809 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Framingham: Hemenway   Regular School No Elementary KG 05 2018   grade_2 64 3 16 0   8     0   8   49 50                       99.0 64 3 16 0   8     0   8   49 50                 99
2231816 2231816 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Framingham: Barbieri Elementary   Regular School No Elementary KG 05 2018   grade_2 17 4 85 0   0     0   5   56 55                       111.0 17 4 85 0   0     0   5   56 55                 111
2231823 2231823 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Framingham: Potter Road   Regular School No Elementary KG 05 2018   grade_2 67 6 7 0   7     0   2   42 47                       89.0 67 6 7 0   7     0   2   42 47                 89
2231830 2231830 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Framingham: Mary E Stapleton Elementary   Regular School No Elementary KG 05 2018   grade_2 39 7 8 0   2     0   2   33 25                       58.0 39 7 8 0   2     0   2   33 25                 58
2231837 2231837 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Framingham: Miriam F McCarthy School   Regular School No Elementary KG 05 2018   grade_2 34 6 34 0   3     0   6   40 43                       83.0 34 6 34 0   3     0   6   40 43                 83
2231844 2231844 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Framingham: Woodrow Wilson   Regular School No Elementary KG 05 2018   grade_2 57 6 27 0   1     0   3   50 44                       94.0 57 6 27 0   1     0   3   50 44                 94
738303 738303 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Jefferson Elementary   Regular School No 1 KG 05 2015   grade_2 66 1 0 0   6     0   0   44 29                       73 66 1 0 0   6     0   0   44 29                 73
738309 738309 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No 1 KG 05 2015   grade_2 75 0 1 0   5     0   0   45 36                       81 75 0 1 0   5     0   0   45 36                 81
738315 738315 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No 1 KG 05 2015   grade_2 52 0 3 0   8     0   1   38 26                       64 52 0 3 0   8     0   1   38 26                 64
738321 738321 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Oak Street Elementary   Regular School No 1 KG 05 2015   grade_2 79 3 4 0   4     0   1   52 39                       91 79 3 4 0   4     0   1   52 39                 91
738327 738327 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No 1 KG 05 2015   grade_2 48 2 3 0   6     0   2   34 27                       61 48 2 3 0   6     0   2   34 27                 61
738333 738333 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No 1 KG 05 2015   grade_2 33 1 2 1   1     0   1   25 14                       39 33 1 2 1   1     0   1   25 14                 39
935157 935157 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Jefferson Elementary   Regular School No 1 KG 05 2016   grade_2 48 1 0 0   10     1   0   30 30                       60 48 1 0 0   10     1   0   30 30                 60
935163 935163 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No 1 KG 05 2016   grade_2 69 1 0 0   2     1   0   39 34                       73 69 1 0 0   2     1   0   39 34                 73
935169 935169 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No 1 KG 05 2016   grade_2 48 1 0 0   1     0   1   29 22                       51 48 1 0 0   1     0   1   29 22                 51
935175 935175 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Oak Street Elementary   Regular School No 1 KG 05 2016   grade_2 63 1 1 0   5     0   3   35 38                       73 63 1 1 0   5     0   3   35 38                 73
935181 935181 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No 1 KG 05 2016   grade_2 46 0 3 1   3     0   0   31 22                       53 46 0 3 1   3     0   0   31 22                 53
935187 935187 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No 1 KG 05 2016   grade_2 34 2 1 0   0     0   0   19 18                       37 34 2 1 0   0     0   0   19 18                 37
1125041 1125041 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Jefferson Elementary   Regular School No Elementary KG 05 2017   grade_2 53 1 1 0   7     0   1   37 26                       63 53 1 1 0   7     0   1   37 26                 63
1125048 1125048 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No Elementary KG 05 2017   grade_2 47 0 0 0   3     0   1   24 27                       51 47 0 0 0   3     0   1   24 27                 51
1125055 1125055 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No Elementary KG 05 2017   grade_2 46 0 3 0   4     0   2   26 29                       55 46 0 3 0   4     0   2   26 29                 55
1125062 1125062 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Oak Street Elementary   Regular School No Elementary KG 05 2017   grade_2 53 1 2 0   1     0   0   27 30                       57 53 1 2 0   1     0   0   27 30                 57
1125069 1125069 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No Elementary KG 05 2017   grade_2 54 0 2 0   4     1   0   33 28                       61 54 0 2 0   4     1   0   33 28                 61
1125076 1125076 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No Elementary KG 05 2017   grade_2 40 0 0 0   0     0   0   22 18                       40 40 0 0 0   0     0   0   22 18                 40
1367395 1367395 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Jefferson Elementary   Regular School No Elementary KG 05 2020   grade_2 53 0 6 0   10     1   1   40 31 *                     71.0 53 0 6 0   10     1   1   40 31                 71
1367401 1367401 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No Elementary KG 05 2020   grade_2 46 1 4 0   2     0   0   26 27 *                     53.0 46 1 4 0   2     0   0   26 27                 53
1367407 1367407 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No Elementary KG 05 2020   grade_2 66 0 4 0   3     0   0   45 28 *                     73.0 66 0 4 0   3     0   0   45 28                 73
1367413 1367413 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Oak Street Elementary   Regular School No Elementary KG 05 2020   grade_2 58 3 3 0   4     0   0   29 39 *                     68.0 58 3 3 0   4     0   0   29 39                 68
1367419 1367419 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No Elementary KG 05 2020   grade_2 33 4 6 0   2     1   3   26 23 *                     49.0 33 4 6 0   2     1   3   26 23                 49
1367425 1367425 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No Elementary KG 05 2020   grade_2 19 0 1 0   0     0   3   11 12 *                     23.0 19 0 1 0   0     0   3   11 12                 23
1674629 1674629 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Franklin - Jefferson Elementary   Regular School No Elementary KG 05 2021   grade_2 52 2 3 0   2     1   1   32 29 *                     61.0 52 2 3 0   2     1   1   32 29                 61
1674635 1674635 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Franklin - Helen Keller Elementary   Regular School No Elementary KG 05 2021   grade_2 46 2 1 0   1     0   0   27 23 *                     50.0 46 2 1 0   1     0   0   27 23                 50
1674641 1674641 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 Franklin - J F Kennedy Memorial   Regular School No Elementary KG 05 2021   grade_2 48 0 2 0   2     2   0   28 26 *                     54.0 48 0 2 0   2     2   0   28 26                 54
1674647 1674647 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Franklin - Oak Street Elementary   Regular School No Elementary KG 05 2021   grade_2 50 0 5 0   5     0   6   31 35 *                     66.0 50 0 5 0   5     0   6   31 35                 66
1674653 1674653 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Franklin - Parmenter   Regular School No Elementary KG 05 2021   grade_2 42 2 7 0   2     0   0   27 26 *                     53.0 42 2 7 0   2     0   0   27 26                 53
1674659 1674659 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Franklin - Davis Thayer   Regular School No Elementary KG 05 2021   grade_2 38 0 2 0   2     2   0   21 23 *                     44.0 38 0 2 0   2     2   0   21 23                 44
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
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
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
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
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
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
2231870 2231870 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Franklin: Jefferson Elementary   Regular School No Elementary KG 05 2018   grade_2 45 1 2 0   4     1   1   27 27                       54.0 45 1 2 0   4     1   1   27 27                 54
2231877 2231877 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Franklin: Helen Keller Elementary   Regular School No Elementary KG 05 2018   grade_2 65 3 1 0   4     1   0   41 33                       74.0 65 3 1 0   4     1   0   41 33                 74
2231884 2231884 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 Franklin: J F Kennedy Memorial   Regular School No Elementary KG 05 2018   grade_2 54 0 1 0   6     1   1   34 29                       63.0 54 0 1 0   6     1   1   34 29                 63
2231891 2231891 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Franklin: Oak Street Elementary   Regular School No Elementary KG 05 2018   grade_2 39 0 1 0   3     0   1   28 16                       44.0 39 0 1 0   3     0   1   28 16                 44
2231898 2231898 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Franklin: Parmenter   Regular School No Elementary KG 05 2018   grade_2 37 2 3 0   4     1   1   20 28                       48.0 37 2 3 0   4     1   1   20 28                 48
2231905 2231905 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Franklin: Davis Thayer   Regular School No Elementary KG 05 2018   grade_2 33 0 0 0   0     0   0   18 15                       33.0 33 0 0 0   0     0   0   18 15                 33
738355 738355 MA Worcester   school 2505130 103   Gardner 250513002470 1030015 Helen Mae Sauter Elementary   Regular School No 1 01 03 2015   grade_2 84 2 13 0   1     0   11   62 49                       111 84 2 13 0   1     0   11   62 49                 111
738360 738360 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No 1 PK 02 2015   grade_2 71 6 22 0   0     0   10   54 55                       109 71 6 22 0   0     0   10   54 55                 109
935205 935205 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No 1 02 04 2016   grade_2 136 6 28 0   2     1   16   112 77                       189 136 6 28 0   2     1   16   112 77                 189
1125098 1125098 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No Elementary 02 04 2017   grade_2 129 6 30 1   0     0   24   103 87                       190 129 6 30 1   0     0   24   103 87                 190
1367443 1367443 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No Elementary 02 04 2020   grade_2 108 4 53 0   4     0   11   92 88 *                     180.0 108 4 53 0   4     0   11   92 88                 180
1674677 1674677 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Gardner - Elm Street School   Regular School No Elementary 02 04 2021   grade_2 89 3 37 0   0     0   16   87 58 *                     145.0 89 3 37 0   0     0   16   87 58                 145
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
2231927 2231927 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Gardner: Elm Street School   Regular School No Elementary 02 04 2018   grade_2 116 9 38 0   4     0   15   81 101                       182.0 116 9 38 0   4     0   15   81 101                 182
738376 738376 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No 1 02 05 2015   grade_2 89 1 1 0   2     1   0   44 50                       94 89 1 1 0   2     1   0   44 50                 94
935227 935227 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No 1 KG 06 2016   grade_2 197 2 3 0   3     2   2   105 104                       209 197 2 3 0   3     2   2   105 104                 209
1125125 1125125 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2017   grade_2 83 2 2 0   1     0   1   48 41                       89 83 2 2 0   1     0   1   48 41                 89
1367464 1367464 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2020   grade_2 100 0 2 0   2     0   2   54 52 *                     106.0 100 0 2 0   2     0   2   54 52                 106
1674699 1674699 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Georgetown - Penn Brook   Regular School No Elementary KG 06 2021   grade_2 98 0 1 0   0     0   5   50 54 *                     104.0 98 0 1 0   0     0   5   50 54                 104
2042536 2042536 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2019   grade_2 85 0 2 0   0     0   3   44 46                       90.0 85 0 2 0   0     0   3   44 46                 90
2231954 2231954 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Georgetown: Penn Brook   Regular School No Elementary KG 06 2018   grade_2 93 0 4 0   3     0   0   55 45                       100.0 93 0 4 0   3     0   0   55 45                 100
738389 738389 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No 1 KG 05 2015   grade_2 44 1 4 0   2     0   1   17 35                       52 44 1 4 0   2     0   1   17 35                 52
738395 738395 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No 1 KG 05 2015   grade_2 36 0 1 0   0     0   0   18 19                       37 36 0 1 0   0     0   0   18 19                 37
738402 738402 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No 1 KG 05 2015   grade_2 33 1 0 2   0     0   1   20 17                       37 33 1 0 2   0     0   1   20 17                 37
738408 738408 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No 1 KG 05 2015   grade_2 25 0 3 0   0     0   0   18 10                       28 25 0 3 0   0     0   0   18 10                 28
738414 738414 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 West Parish   Regular School No 1 KG 05 2015   grade_2 43 0 0 1   1     0   0   16 29                       45 43 0 0 1   1     0   0   16 29                 45
935240 935240 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No 1 KG 05 2016   grade_2 42 1 9 1   1     0   1   28 27                       55 42 1 9 1   1     0   1   28 27                 55
935246 935246 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No 1 KG 05 2016   grade_2 34 1 3 0   0     0   3   22 19                       41 34 1 3 0   0     0   3   22 19                 41
935253 935253 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No 1 KG 05 2016   grade_2 36 0 1 0   0     0   0   25 12                       37 36 0 1 0   0     0   0   25 12                 37
935259 935259 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No 1 KG 05 2016   grade_2 34 0 5 0   0     1   1   21 20                       41 34 0 5 0   0     1   1   21 20                 41
935265 935265 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 West Parish   Regular School No 1 KG 05 2016   grade_2 42 1 0 0   1     0   2   21 25                       46 42 1 0 0   1     0   2   21 25                 46
1125141 1125141 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No Elementary KG 05 2017   grade_2 47 0 9 1   2     0   1   36 24                       60 47 0 9 1   2     0   1   36 24                 60
1125148 1125148 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No Elementary KG 05 2017   grade_2 33 0 4 0   0     0   2   26 13                       39 33 0 4 0   0     0   2   26 13                 39
1125157 1125157 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No Elementary KG 05 2017   grade_2 34 0 0 0   0     0   0   17 17                       34 34 0 0 0   0     0   0   17 17                 34
1125164 1125164 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No Elementary KG 05 2017   grade_2 24 0 4 0   0     0   0   12 16                       28 24 0 4 0   0     0   0   12 16                 28
1125171 1125171 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 West Parish   Regular School No Elementary KG 05 2017   grade_2 49 0 6 0   2     0   0   29 28                       57 49 0 6 0   2     0   0   29 28                 57
1367477 1367477 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No Elementary KG 05 2020   grade_2 34 0 10 0   1     0   4   22 27 *                     49.0 34 0 10 0   1     0   4   22 27                 49
1367483 1367483 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No Elementary KG 05 2020   grade_2 22 0 2 0   0     0   0   11 13 *                     24.0 22 0 2 0   0     0   0   11 13                 24
1367490 1367490 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No Elementary KG 05 2020   grade_2 33 0 2 0   0     0   1   19 17 *                     36.0 33 0 2 0   0     0   1   19 17                 36
1367496 1367496 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No Elementary KG 05 2020   grade_2 19 3 4 0   1     2   1   12 18 *                     30.0 19 3 4 0   1     2   1   12 18                 30
1367502 1367502 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 West Parish   Regular School No Elementary KG 05 2020   grade_2 50 1 9 0   1     0   7   36 32 *                     68.0 50 1 9 0   1     0   7   36 32                 68
1674712 1674712 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Gloucester - Beeman Memorial   Regular School No Elementary KG 05 2021   grade_2 37 2 10 0   0     0   3   29 23 *                     52.0 37 2 10 0   0     0   3   29 23                 52
1674718 1674718 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 Gloucester - East Gloucester Elementary   Regular School No Elementary KG 05 2021   grade_2 30 0 5 0   1     0   0   19 17 *                     36.0 30 0 5 0   1     0   0   19 17                 36
1674725 1674725 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Gloucester - Plum Cove School   Regular School No Elementary KG 05 2021   grade_2 33 1 0 0   0     0   2   23 13 *                     36.0 33 1 0 0   0     0   2   23 13                 36
1674731 1674731 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Gloucester - Veterans Memorial   Regular School No Elementary KG 05 2021   grade_2 13 1 10 0   0     0   3   17 10 *                     27.0 13 1 10 0   0     0   3   17 10                 27
1674737 1674737 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 Gloucester - West Parish   Regular School No Elementary KG 05 2021   grade_2 43 0 4 0   0     0   4   22 29 *                     51.0 43 0 4 0   0     0   4   22 29                 51
2042549 2042549 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No Elementary KG 05 2019   grade_2 52 0 7 0   0     0   1   31 29                       60.0 52 0 7 0   0     0   1   31 29                 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]);