Data source: Big Local News · About: Big Local

6,747 rows where grade = "kindergarten" and state = "MA" sorted by district_state_id

View and edit SQL

year

grade

  • kindergarten · 6,647
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
1674607 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Framingham - Woodrow Wilson   Regular School No Elementary KG 05 2021   kindergarten 9 5 51 0   1     0   3   41 28 *                     69.0 9 5 51 0   1     0   3   41 28                 69
2042397 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No Elementary KG 04 2019   kindergarten 43 2 6 0   9     0   6   33 33                       66.0 43 2 6 0   9     0   6   33 33                 66
2042402 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2019   kindergarten 32 5 33 0   7     0   3   37 43                       80.0 32 5 33 0   7     0   3   37 43                 80
2042408 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2019   kindergarten 52 11 13 0   5     0   5   44 42                       86.0 52 11 13 0   5     0   5   44 42                 86
2042414 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2019   kindergarten 63 3 14 0   11     0   12   56 47                       103.0 63 3 14 0   11     0   12   56 47                 103
2042420 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2019   kindergarten 17 5 93 0   0     0   6   53 68                       121.0 17 5 93 0   0     0   6   53 68                 121
2042426 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No Elementary KG 05 2019   kindergarten 67 6 9 0   1     0   4   48 39                       87.0 67 6 9 0   1     0   4   48 39                 87
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
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
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
2231788 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 Framingham: King Elementary School   Regular School No Elementary KG 03 2018   kindergarten 46 1 6 0   5     0   6   35 29                       64.0 46 1 6 0   5     0   6   35 29                 64
2231793 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Framingham: Brophy   Regular School No Elementary KG 05 2018   kindergarten 26 6 35 0   2     0   2   32 39                       71.0 26 6 35 0   2     0   2   32 39                 71
2231800 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Framingham: Charlotte A Dunning   Regular School No Elementary KG 05 2018   kindergarten 53 6 6 0   4     0   1   40 30                       70.0 53 6 6 0   4     0   1   40 30                 70
2231807 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Framingham: Hemenway   Regular School No Elementary KG 05 2018   kindergarten 54 9 10 0   7     0   8   43 45                       88.0 54 9 10 0   7     0   8   43 45                 88
2231814 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Framingham: Barbieri Elementary   Regular School No Elementary KG 05 2018   kindergarten 18 3 97 0   1     0   3   50 72                       122.0 18 3 97 0   1     0   3   50 72                 122
2231821 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Framingham: Potter Road   Regular School No Elementary KG 05 2018   kindergarten 51 8 6 0   3     0   6   38 36                       74.0 51 8 6 0   3     0   6   38 36                 74
2231828 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Framingham: Mary E Stapleton Elementary   Regular School No Elementary KG 05 2018   kindergarten 44 5 5 0   3     0   2   29 30                       59.0 44 5 5 0   3     0   2   29 30                 59
2231835 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Framingham: Miriam F McCarthy School   Regular School No Elementary KG 05 2018   kindergarten 42 8 22 0   6     1   7   45 41                       86.0 42 8 22 0   6     1   7   45 41                 86
2231842 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Framingham: Woodrow Wilson   Regular School No Elementary KG 05 2018   kindergarten 55 12 17 0   1     0   1   53 33                       86.0 55 12 17 0   1     0   1   53 33                 86
738301 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Jefferson Elementary   Regular School No 1 KG 05 2015   kindergarten 52 2 1 0   7     0   1   34 29                       63 52 2 1 0   7     0   1   34 29                 63
738307 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No 1 KG 05 2015   kindergarten 42 0 0 0   2     0   0   19 25                       44 42 0 0 0   2     0   0   19 25                 44
738313 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No 1 KG 05 2015   kindergarten 44 0 2 0   3     0   2   23 28                       51 44 0 2 0   3     0   2   23 28                 51
738319 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Oak Street Elementary   Regular School No 1 KG 05 2015   kindergarten 54 0 4 0   1     0   0   30 29                       59 54 0 4 0   1     0   0   30 29                 59
738325 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No 1 KG 05 2015   kindergarten 56 0 1 0   5     1   0   36 27                       63 56 0 1 0   5     1   0   36 27                 63
738331 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No 1 KG 05 2015   kindergarten 43 0 0 0   1     0   0   23 21                       44 43 0 0 0   1     0   0   23 21                 44
935155 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Jefferson Elementary   Regular School No 1 KG 05 2016   kindergarten 43 2 2 0   3     1   1   28 24                       52 43 2 2 0   3     1   1   28 24                 52
935161 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No 1 KG 05 2016   kindergarten 62 3 1 0   4     0   0   39 31                       70 62 3 1 0   4     0   0   39 31                 70
935167 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No 1 KG 05 2016   kindergarten 46 0 1 0   7     1   0   30 25                       55 46 0 1 0   7     1   0   30 25                 55
935173 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Oak Street Elementary   Regular School No 1 KG 05 2016   kindergarten 42 0 3 0   2     0   1   30 18                       48 42 0 3 0   2     0   1   30 18                 48
935179 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No 1 KG 05 2016   kindergarten 42 2 2 0   5     1   1   27 26                       53 42 2 2 0   5     1   1   27 26                 53
935185 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No 1 KG 05 2016   kindergarten 33 1 0 0   0     0   0   15 19                       34 33 1 0 0   0     0   0   15 19                 34
1125039 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Jefferson Elementary   Regular School No Elementary KG 05 2017   kindergarten 31 0 0 0   0     1   1   20 13                       33 31 0 0 0   0     1   1   20 13                 33
1125046 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No Elementary KG 05 2017   kindergarten 63 1 0 0   0     0   4   36 32                       68 63 1 0 0   0     0   4   36 32                 68
1125053 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No Elementary KG 05 2017   kindergarten 47 0 4 0   1     1   1   28 26                       54 47 0 4 0   1     1   1   28 26                 54
1125060 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Oak Street Elementary   Regular School No Elementary KG 05 2017   kindergarten 51 0 4 0   4     0   3   32 30                       62 51 0 4 0   4     0   3   32 30                 62
1125067 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No Elementary KG 05 2017   kindergarten 51 6 1 1   5     1   0   35 30                       65 51 6 1 1   5     1   0   35 30                 65
1125074 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No Elementary KG 05 2017   kindergarten 39 0 2 0   2     0   1   25 19                       44 39 0 2 0   2     0   1   25 19                 44
1367393 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Jefferson Elementary   Regular School No Elementary KG 05 2020   kindergarten 31 0 2 0   5     0   1   25 14 *                     39.0 31 0 2 0   5     0   1   25 14                 39
1367399 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No Elementary KG 05 2020   kindergarten 40 1 0 0   4     0   1   22 24 *                     46.0 40 1 0 0   4     0   1   22 24                 46
1367405 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No Elementary KG 05 2020   kindergarten 33 1 0 0   1     0   1   19 17 *                     36.0 33 1 0 0   1     0   1   19 17                 36
1367411 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Oak Street Elementary   Regular School No Elementary KG 05 2020   kindergarten 55 1 1 0   0     0   3   31 29 *                     60.0 55 1 1 0   0     0   3   31 29                 60
1367417 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No Elementary KG 05 2020   kindergarten 52 4 3 0   2     2   0   32 31 *                     63.0 52 4 3 0   2     2   0   32 31                 63
1367423 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No Elementary KG 05 2020   kindergarten 35 1 4 0   0     0   1   21 20 *                     41.0 35 1 4 0   0     0   1   21 20                 41
1674627 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Franklin - Jefferson Elementary   Regular School No Elementary KG 05 2021   kindergarten 43 3 2 0   3     1   0   29 23 *                     52.0 43 3 2 0   3     1   0   29 23                 52
1674633 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Franklin - Helen Keller Elementary   Regular School No Elementary KG 05 2021   kindergarten 32 1 0 0   1     0   1   18 17 *                     35.0 32 1 0 0   1     0   1   18 17                 35
1674639 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 Franklin - J F Kennedy Memorial   Regular School No Elementary KG 05 2021   kindergarten 44 0 1 0   4     3   0   30 22 *                     52.0 44 0 1 0   4     3   0   30 22                 52
1674645 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Franklin - Oak Street Elementary   Regular School No Elementary KG 05 2021   kindergarten 38 0 3 0   6     1   2   21 29 *                     50.0 38 0 3 0   6     1   2   21 29                 50
1674651 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Franklin - Parmenter   Regular School No Elementary KG 05 2021   kindergarten 38 1 5 0   0     0   2   22 24 *                     46.0 38 1 5 0   0     0   2   22 24                 46
1674657 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Franklin - Davis Thayer   Regular School No Elementary KG 05 2021   kindergarten 25 1 0 0   2     1   1   14 16 *                     30.0 25 1 0 0   2     1   1   14 16                 30
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
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
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
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
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
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
2231868 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Franklin: Jefferson Elementary   Regular School No Elementary KG 05 2018   kindergarten 47 2 2 0   6     2   0   37 22                       59.0 47 2 2 0   6     2   0   37 22                 59
2231875 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Franklin: Helen Keller Elementary   Regular School No Elementary KG 05 2018   kindergarten 45 1 3 0   1     0   0   24 26                       50.0 45 1 3 0   1     0   0   24 26                 50
2231882 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 Franklin: J F Kennedy Memorial   Regular School No Elementary KG 05 2018   kindergarten 61 0 2 0   2     1   0   39 27                       66.0 61 0 2 0   2     1   0   39 27                 66
2231889 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Franklin: Oak Street Elementary   Regular School No Elementary KG 05 2018   kindergarten 52 2 2 0   2     0   0   27 31                       58.0 52 2 2 0   2     0   0   27 31                 58
2231896 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Franklin: Parmenter   Regular School No Elementary KG 05 2018   kindergarten 35 3 2 0   2     1   3   22 24                       46.0 35 3 2 0   2     1   3   22 24                 46
2231903 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Franklin: Davis Thayer   Regular School No Elementary KG 05 2018   kindergarten 21 0 5 0   1     0   1   13 15                       28.0 21 0 5 0   1     0   1   13 15                 28
738357 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No 1 PK 02 2015   kindergarten 149 7 25 1   0     0   22   113 91                       204 149 7 25 1   0     0   22   113 91                 204
935208 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No 1 PK 01 2016   kindergarten 120 5 26 0   4     0   17   76 96                       172 120 5 26 0   4     0   17   76 96                 172
1125102 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No Elementary PK 01 2017   kindergarten 139 1 37 0   1     0   16   86 108                       194 139 1 37 0   1     0   16   86 108                 194
1367446 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No Elementary PK 01 2020   kindergarten 118 7 39 0   2     0   10   100 76 *                     176.0 118 7 39 0   2     0   10   100 76                 176
1674680 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Gardner - Waterford Street   Regular School No Elementary PK 01 2021   kindergarten 100 5 36 0   7     0   5   72 81 *                     153.0 100 5 36 0   7     0   5   72 81                 153
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
2231931 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Gardner: Waterford Street   Regular School No Elementary PK 01 2018   kindergarten 141 6 42 0   4     0   12   103 102                       205.0 141 6 42 0   4     0   12   103 102                 205
738373 MA Essex   school 2505220 105   Georgetown 250522000766 1050005 Perley Elementary   Regular School No 1 PK 01 2015   kindergarten 82 1 2 0   1     0   0   45 41                       86 82 1 2 0   1     0   0   45 41                 86
935225 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No 1 KG 06 2016   kindergarten 95 0 2 0   4     0   0   56 45                       101 95 0 2 0   4     0   0   56 45                 101
1125123 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2017   kindergarten 83 0 2 0   0     0   2   44 43                       87 83 0 2 0   0     0   2   44 43                 87
1367462 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2020   kindergarten 99 0 3 0   1     0   2   44 61 *                     105.0 99 0 3 0   1     0   2   44 61                 105
1674697 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Georgetown - Penn Brook   Regular School No Elementary KG 06 2021   kindergarten 77 0 1 0   1     0   4   40 43 *                     83.0 77 0 1 0   1     0   4   40 43                 83
2042534 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2019   kindergarten 103 0 0 0   1     0   5   55 54                       109.0 103 0 0 0   1     0   5   55 54                 109
2231952 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Georgetown: Penn Brook   Regular School No Elementary KG 06 2018   kindergarten 93 1 1 0   2     0   1   52 46                       98.0 93 1 1 0   2     0   1   52 46                 98
738387 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No 1 KG 05 2015   kindergarten 46 0 9 1   2     0   1   35 24                       59 46 0 9 1   2     0   1   35 24                 59
738393 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No 1 KG 05 2015   kindergarten 37 0 4 0   0     0   1   26 16                       42 37 0 4 0   0     0   1   26 16                 42
738400 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No 1 KG 05 2015   kindergarten 33 0 0 0   1     1   0   15 20                       35 33 0 0 0   1     1   0   15 20                 35
738406 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No 1 KG 05 2015   kindergarten 27 0 5 0   0     0   0   12 20                       32 27 0 5 0   0     0   0   12 20                 32
738412 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 West Parish   Regular School No 1 KG 05 2015   kindergarten 49 0 6 0   1     0   1   33 24                       57 49 0 6 0   1     0   1   33 24                 57
935238 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No 1 KG 05 2016   kindergarten 50 2 9 0   0     0   2   32 31                       63 50 2 9 0   0     0   2   32 31                 63
935244 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No 1 KG 05 2016   kindergarten 40 0 2 0   0     0   3   23 22                       45 40 0 2 0   0     0   3   23 22                 45
935251 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No 1 KG 05 2016   kindergarten 34 1 2 0   0     0   2   21 18                       39 34 1 2 0   0     0   2   21 18                 39
935257 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No 1 KG 05 2016   kindergarten 29 0 9 0   0     0   3   18 23                       41 29 0 9 0   0     0   3   18 23                 41
935263 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 West Parish   Regular School No 1 KG 05 2016   kindergarten 51 1 3 0   1     0   4   25 35                       60 51 1 3 0   1     0   4   25 35                 60
1125139 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No Elementary KG 05 2017   kindergarten 56 0 9 0   0     0   0   32 33                       65 56 0 9 0   0     0   0   32 33                 65
1125146 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No Elementary KG 05 2017   kindergarten 31 0 1 0   0     0   1   17 16                       33 31 0 1 0   0     0   1   17 16                 33
1125155 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No Elementary KG 05 2017   kindergarten 31 3 2 0   1     0   0   14 23                       37 31 3 2 0   1     0   0   14 23                 37
1125162 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No Elementary KG 05 2017   kindergarten 39 1 5 0   1     0   0   20 26                       46 39 1 5 0   1     0   0   20 26                 46
1125169 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 West Parish   Regular School No Elementary KG 05 2017   kindergarten 57 1 1 0   1     0   0   29 31                       60 57 1 1 0   1     0   0   29 31                 60
1367475 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No Elementary KG 05 2020   kindergarten 39 4 10 0   0     0   3   30 26 *                     56.0 39 4 10 0   0     0   3   30 26                 56
1367481 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No Elementary KG 05 2020   kindergarten 24 0 5 0   2     0   3   16 18 *                     34.0 24 0 5 0   2     0   3   16 18                 34
1367488 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No Elementary KG 05 2020   kindergarten 28 1 1 0   0     0   4   18 16 *                     34.0 28 1 1 0   0     0   4   18 16                 34
1367494 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No Elementary KG 05 2020   kindergarten 29 4 8 0   2     1   0   22 22 *                     44.0 29 4 8 0   2     1   0   22 22                 44
1367500 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 West Parish   Regular School No Elementary KG 05 2020   kindergarten 53 1 2 0   0     0   2   36 22 *                     58.0 53 1 2 0   0     0   2   36 22                 58
1674710 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Gloucester - Beeman Memorial   Regular School No Elementary KG 05 2021   kindergarten 36 2 11 0   3     0   1   27 26 *                     53.0 36 2 11 0   3     0   1   27 26                 53
1674716 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 Gloucester - East Gloucester Elementary   Regular School No Elementary KG 05 2021   kindergarten 31 0 2 0   1     0   1   18 17 *                     35.0 31 0 2 0   1     0   1   18 17                 35
1674723 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Gloucester - Plum Cove School   Regular School No Elementary KG 05 2021   kindergarten 33 1 1 0   0     0   4   24 15 *                     39.0 33 1 1 0   0     0   4   24 15                 39
1674729 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Gloucester - Veterans Memorial   Regular School No Elementary KG 05 2021   kindergarten 25 1 8 0   1     1   3   25 14 *                     39.0 25 1 8 0   1     1   3   25 14                 39
1674735 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 Gloucester - West Parish   Regular School No Elementary KG 05 2021   kindergarten 54 0 2 0   1     0   1   22 36 *                     58.0 54 0 2 0   1     0   1   22 36                 58

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