Data source: Big Local News · About: Big Local

964 rows where grade = "kindergarten", state = "MA" and year = 2016 sorted by district_state_id

View and edit SQL

year

  • 2016 · 964

grade

  • kindergarten · 964
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
932536 MA Plymouth   school 2501650 1   Abington 250165002727 10002 Center Elementary School   Regular School No 1 PK KG 2016   kindergarten 98 2 7 0   1     0   2   50 60                       110 98 2 7 0   1     0   2   50 60                 110
932682 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No 1 KG 05 2016   kindergarten 48 0 1 0   15     2   2   30 38                       68 48 0 1 0   15     2   2   30 38                 68
932688 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No 1 KG 05 2016   kindergarten 58 0 3 0   4     0   6   36 35                       71 58 0 3 0   4     0   6   36 35                 71
932694 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No 1 KG 05 2016   kindergarten 59 0 3 0   4     0   2   34 34                       68 59 0 3 0   4     0   2   34 34                 68
932700 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No 1 KG 05 2016   kindergarten 60 5 5 0   13     1   1   40 45                       85 60 5 5 0   13     1   1   40 45                 85
932707 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No 1 KG 05 2016   kindergarten 33 4 0 0   4     0   1   15 27                       42 33 4 0 0   4     0   1   15 27                 42
932713 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No 1 KG 05 2016   kindergarten 53 3 5 0   12     0   9   45 37                       82 53 3 5 0   12     0   9   45 37                 82
932719 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No 1 KG 05 2016   kindergarten 41 2 7 0   12     0   5   28 39                       67 41 2 7 0   12     0   5   28 39                 67
935091 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No 1 KG 01 2016   kindergarten 46 4 13 0   11     0   5   41 38                       79 46 4 13 0   11     0   5   41 38                 79
935093 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No 1 KG 05 2016   kindergarten 24 5 35 0   6     0   1   30 41                       71 24 5 35 0   6     0   1   30 41                 71
935099 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No 1 KG 05 2016   kindergarten 47 7 4 0   11     0   2   35 36                       71 47 7 4 0   11     0   2   35 36                 71
935105 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No 1 KG 05 2016   kindergarten 57 3 12 0   9     0   7   49 39                       88 57 3 12 0   9     0   7   49 39                 88
935111 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No 1 KG 05 2016   kindergarten 20 3 91 0   0     0   4   67 51                       118 20 3 91 0   0     0   4   67 51                 118
935117 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No 1 KG 05 2016   kindergarten 69 3 5 0   3     0   2   46 36                       82 69 3 5 0   3     0   2   46 36                 82
935123 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Mary E Stapleton Elementary   Regular School No 1 KG 05 2016   kindergarten 42 3 7 0   1     0   2   34 21                       55 42 3 7 0   1     0   2   34 21                 55
935129 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No 1 KG 05 2016   kindergarten 33 8 30 0   3     0   10   36 48                       84 33 8 30 0   3     0   10   36 48                 84
935135 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No 1 KG 05 2016   kindergarten 60 8 24 0   0     0   2   44 50                       94 60 8 24 0   0     0   2   44 50                 94
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
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
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
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
935279 MA Worcester   school 2505370 110   Grafton 250537000788 1100005 South Grafton Elementary   Regular School No 1 PK 01 2016   kindergarten 91 2 3 0   21     0   2   59 60                       119 91 2 3 0   21     0   2   59 60                 119
935282 MA Worcester   school 2505370 110   Grafton 250537000787 1100025 North Grafton Elementary   Regular School No 1 PK 01 2016   kindergarten 84 0 4 0   13     1   10   58 54                       112 84 0 4 0   13     1   10   58 54                 112
935304 MA Hampshire   school 2505400 111   Granby 250540000791 1110010 West Street   Regular School No 1 PK 03 2016   kindergarten 40 0 2 1   1     0   0   26 18                       44 40 0 2 1   1     0   0   26 18                 44
935316 MA Franklin   school 2505490 114   Greenfield 250549002577 1140010 Federal Street School   Regular School No 1 KG 04 2016   kindergarten 35 0 11 0   0     0   7   27 26                       53 35 0 11 0   0     0   7   27 26                 53
935321 MA Franklin   school 2505490 114   Greenfield 250549000798 1140025 Discovery School at Four Corners   Regular School No 1 KG 04 2016   kindergarten 44 0 5 0   0     0   0   28 21                       49 44 0 5 0   0     0   0   28 21                 49
935327 MA Franklin   school 2505490 114   Greenfield 250549002578 1140035 Newton School   Regular School No 1 KG 04 2016   kindergarten 30 0 17 0   1     0   4   27 25                       52 30 0 17 0   1     0   4   27 25                 52
935342 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No 1 PK 06 2016   kindergarten 26 0 6 0   0     3   3   24 14                       38 26 0 6 0   0     3   3   24 14                 38
935356 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No 1 KG 06 2016   kindergarten 78 0 0 0   0     0   1   39 40                       79 78 0 0 0   0     0   1   39 40                 79
935363 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No 1 PK 06 2016   kindergarten 7 0 0 0   0     0   0   5 2                       7 7 0 0 0   0     0   0   5 2                 7
935370 MA Plymouth   school 2505790 122   Hanover 250579000827 1220004 Cedar Elementary   Regular School No 1 PK 04 2016   kindergarten 70 2 1 0   1     0   0   39 35                       74 70 2 1 0   1     0   0   39 35                 74
935376 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Center Elementary   Regular School No 1 KG 02 2016   kindergarten 100 0 2 0   1     0   1   42 62                       104 100 0 2 0   1     0   1   42 62                 104
935390 MA Worcester   school 2505880 125   Harvard 250588000839 1250005 Hildreth Elementary School   Regular School No 1 PK 05 2016   kindergarten 54 2 0 0   6     0   1   31 32                       63 54 2 0 0   6     0   1   31 32                 63
935404 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No 1 PK 06 2016   kindergarten 17 0 2 0   0     0   0   9 10                       19 17 0 2 0   0     0   0   9 10                 19
935418 MA Essex   school 2505970 128   Haverhill 250597002769 1280005 Bartlett Kindergarten Center   Regular School No 1 KG KG 2016   kindergarten 85 3 48 0   0     0   1   68 69                       137 85 3 48 0   0     0   1   68 69                 137
935419 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Bradford Elementary   Regular School No 1 KG 05 2016   kindergarten 33 0 8 0   1     0   1   26 17                       43 33 0 8 0   1     0   1   26 17                 43
935425 MA Essex   school 2505970 128   Haverhill 250597000851 1280020 Crowell   Regular School No 1 KG KG 2016   kindergarten 84 3 43 1   0     0   2   69 64                       133 84 3 43 1   0     0   2   69 64                 133
935430 MA Essex   school 2505970 128   Haverhill 250597000854 1280027 Greenleaf   Regular School No 1 KG 02 2016   kindergarten 64 0 14 0   3     0   2   49 34                       83 64 0 14 0   3     0   2   49 34                 83
935446 MA Essex   school 2505970 128   Haverhill 250597001169 1280054 Pentucket Lake Elementary   Regular School No 1 KG 04 2016   kindergarten 45 0 13 1   1     0   1   29 32                       61 45 0 13 1   1     0   1   29 32                 61
935462 MA Essex   school 2505970 128   Haverhill 250597000867 1280080 Walnut Square   Regular School No 1 KG 02 2016   kindergarten 56 0 3 0   0     0   2   34 27                       61 56 0 3 0   0     0   2   34 27                 61
935482 MA Plymouth   school 2506090 131   Hingham 250609002671 1310005 East Elementary School   Regular School No 1 PK 05 2016   kindergarten 68 2 2 0   0     0   2   43 31                       74 68 2 2 0   0     0   2   43 31                 74
935489 MA Plymouth   school 2506090 131   Hingham 250609000876 1310010 Wm L Foster Elementary   Regular School No 1 KG 05 2016   kindergarten 66 1 4 0   2     0   3   40 36                       76 66 1 4 0   2     0   3   40 36                 76
935495 MA Plymouth   school 2506090 131   Hingham 250609000873 1310019 Plymouth River   Regular School No 1 KG 05 2016   kindergarten 65 2 0 0   3     0   2   32 40                       72 65 2 0 0   3     0   2   32 40                 72
935501 MA Plymouth   school 2506090 131   Hingham 250609000874 1310020 South Elementary   Regular School No 1 KG 05 2016   kindergarten 75 0 1 0   0     0   4   38 42                       80 75 0 1 0   0     0   4   38 42                 80
935515 MA Norfolk   school 2506150 133   Holbrook 250615000880 1330018 John F Kennedy   Regular School No 1 PK 03 2016   kindergarten 70 15 8 0   3     1   14   62 49                       111 70 15 8 0   3     1   14   62 49                 111
935529 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No 1 PK 06 2016   kindergarten 21 1 1 0   0     0   1   17 7                       24 21 1 1 0   0     0   1   17 7                 24
935540 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No 1 PK 02 2016   kindergarten 170 2 11 1   13     0   6   113 90                       203 170 2 11 1   13     0   6   113 90                 203
935552 MA Hampden   school 2506270 137   Holyoke 250627001178 1370003 Joseph Metcalf School   Regular School No 1 PK 01 2016   kindergarten 16 4 16 0   1     0   3   14 26                       40 16 4 16 0   1     0   3   14 26                 40
935555 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No 1 KG 08 2016   kindergarten 13 2 16 0   2     0   1   20 14                       34 13 2 16 0   2     0   1   20 14                 34
935564 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No 1 PK 08 2016   kindergarten 3 3 44 0   0     0   1   29 22                       51 3 3 44 0   0     0   1   29 22                 51
935579 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No 1 KG 08 2016   kindergarten 4 0 70 0   0     0   1   42 33                       75 4 0 70 0   0     0   1   42 33                 75
935588 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No 1 PK 08 2016   kindergarten 7 1 42 0   0     0   1   34 17                       51 7 1 42 0   0     0   1   34 17                 51
935598 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No 1 KG 08 2016   kindergarten 10 1 45 0   1     0   2   32 27                       59 10 1 45 0   1     0   2   32 27                 59
935607 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No 1 PK 08 2016   kindergarten 9 1 30 0   0     0   1   25 16                       41 9 1 30 0   0     0   1   25 16                 41
935617 MA Hampden   school 2506270 137   Holyoke 250627002795 1370070 H.B. Lawrence School   Regular School No 1 KG 03 2016   kindergarten 1 4 84 0   0     0   1   44 46                       90 1 4 84 0   0     0   1   44 46                 90
935631 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No 1 KG 06 2016   kindergarten 62 1 3 0   0     0   6   34 38                       72 62 1 3 0   0     0   6   34 38                 72
935645 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Center   Regular School No 1 KG 01 2016   kindergarten 163 0 5 0   29     0   10   102 105                       207 163 0 5 0   29     0   10   102 105                 207
932733 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No 1 KG 02 2016   kindergarten 128 2 24 1   25     1   9   97 93                       190 128 2 24 1   25     1   9   97 93                 190
935659 MA Middlesex   school 2506390 141   Hudson 250639000924 1410007 Mulready Elementary   Regular School No 1 PK 04 2016   kindergarten 39 1 2 0   2     0   1   16 29                       45 39 1 2 0   2     0   1   16 29                 45
935665 MA Middlesex   school 2506390 141   Hudson 250639000925 1410015 Forest Avenue Elementary   Regular School No 1 KG 04 2016   kindergarten 59 1 5 0   0     0   5   41 29                       70 59 1 5 0   0     0   5   41 29                 70
935670 MA Middlesex   school 2506390 141   Hudson 250639000922 1410030 C A Farley   Regular School No 1 PK 04 2016   kindergarten 60 1 15 0   4     0   2   31 51                       82 60 1 15 0   4     0   2   31 51                 82
935685 MA Plymouth   school 2506420 142   Hull 250642000932 1420015 Lillian M Jacobs   Regular School No 1 PK 05 2016   kindergarten 49 1 3 0   1     0   1   28 27                       55 49 1 3 0   1     0   1   28 27                 55
935699 MA Essex   school 2506480 144   Ipswich 250648000936 1440007 Paul F Doyon Memorial   Regular School No 1 PK 05 2016   kindergarten 58 0 3 0   1     0   4   33 33                       66 58 0 3 0   1     0   4   33 33                 66
935706 MA Essex   school 2506480 144   Ipswich 250648000939 1440015 Winthrop   Regular School No 1 PK 05 2016   kindergarten 50 4 8 0   0     0   1   33 30                       63 50 4 8 0   0     0   1   33 30                 63
935721 MA Plymouth   school 2506540 145   Kingston 250654000943 1450005 Kingston Elementary   Regular School No 1 KG 02 2016   kindergarten 157 1 3 0   0     0   1   84 78                       162 157 1 3 0   0     0   1   84 78                 162
935728 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No 1 PK 06 2016   kindergarten 22 1 0 0   0     0   0   11 12                       23 22 1 0 0   0     0   0   11 12                 23
935736 MA Essex   school 2506660 149   Lawrence 250666002651 1490001 Rollins Early Childhood Center   Regular School No 1 PK KG 2016   kindergarten 6 0 92 0   1     0   0   54 45                       99 6 0 92 0   1     0   0   54 45                 99
935738 MA Essex   school 2506660 149   Lawrence 250666000471 1490002 Lawlor Early Childhood Center   Regular School No 1 KG KG 2016   kindergarten 10 3 136 0   0     1   1   65 86                       151 10 3 136 0   0     1   1   65 86                 151
935739 MA Essex   school 2506660 149   Lawrence 250666000730 1490003 John Breen School   Regular School No 1 PK KG 2016   kindergarten 6 2 111 0   2     0   0   72 49                       121 6 2 111 0   2     0   0   72 49                 121
935746 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No 1 KG 04 2016   kindergarten 1 1 103 0   0     0   0   58 47                       105 1 1 103 0   0     0   0   58 47                 105
935751 MA Essex   school 2506660 149   Lawrence 250666002815 1490011 Lawrence Family Public Academy   Regular School No 1 PK KG 2016   kindergarten 5 3 131 0   2     0   0   69 72                       141 5 3 131 0   2     0   0   69 72                 141
935763 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Robert Frost   Regular School No 1 KG 04 2016   kindergarten 9 2 74 0   4     0   1   47 43                       90 9 2 74 0   4     0   1   47 43                 90
935768 MA Essex   school 2506660 149   Lawrence 250666000958 1490020 James F Hennessey   Regular School No 1 PK 02 2016   kindergarten 6 0 80 0   2     0   1   51 38                       89 6 0 80 0   2     0   1   51 38                 89
935784 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No 1 KG 05 2016   kindergarten 3 1 80 0   0     0   0   49 35                       84 3 1 80 0   0     0   0   49 35                 84
935798 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Edward F. Parthum   Regular School No 1 KG 04 2016   kindergarten 5 1 60 0   1     0   1   36 32                       68 5 1 60 0   1     0   1   36 32                 68
935808 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No 1 KG 08 2016   kindergarten 1 1 54 0   3     0   2   32 29                       61 1 1 54 0   3     0   2   32 29                 61
935875 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No 1 PK 06 2016   kindergarten 47 0 5 0   1     0   2   30 25                       55 47 0 5 0   1     0   2   30 25                 55
935892 MA Worcester   school 2506720 151   Leicester 250672000974 1510010 Leicester Primary School   Regular School No 1 PK 02 2016   kindergarten 82 8 3 0   5     0   0   64 34                       98 82 8 3 0   5     0   0   64 34                 98
935903 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Morris   Regular School No 1 PK 05 2016   kindergarten 40 0 4 0   1     0   4   22 27                       49 40 0 4 0   1     0   4   22 27                 49
935919 MA Worcester   school 2506780 153   Leominster 250678000981 1530007 Fall Brook   Regular School No 1 KG 05 2016   kindergarten 28 3 36 0   3     0   4   37 37                       74 28 3 36 0   3     0   4   37 37                 74
935925 MA Worcester   school 2506780 153   Leominster 250678002637 1530010 Frances Drake School   Regular School No 1 KG 05 2016   kindergarten 37 11 45 0   4     0   5   55 47                       102 37 11 45 0   4     0   5   55 47                 102
935931 MA Worcester   school 2506780 153   Leominster 250678000985 1530025 Johnny Appleseed   Regular School No 1 KG 05 2016   kindergarten 41 7 24 0   4     0   5   39 42                       81 41 7 24 0   4     0   5   39 42                 81
935937 MA Worcester   school 2506780 153   Leominster 250678000988 1530030 Northwest   Regular School No 1 KG 05 2016   kindergarten 27 0 15 0   0     0   2   24 20                       44 27 0 15 0   0     0   2   24 20                 44
935943 MA Worcester   school 2506780 153   Leominster 250678000990 1530040 Priest Street   Regular School No 1 KG KG 2016   kindergarten 57 4 53 0   1     0   7   64 58                       122 57 4 53 0   1     0   7   64 58                 122
935958 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No 1 PK 06 2016   kindergarten 11 0 0 0   1     0   1   6 7                       13 11 0 0 0   1     0   1   6 7                 13
935967 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Bridge   Regular School No 1 KG 05 2016   kindergarten 43 5 5 1   31     0   2   43 44                       87 43 5 5 1   31     0   2   43 44                 87
935973 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Bowman   Regular School No 1 KG 05 2016   kindergarten 42 1 2 0   19     0   8   36 36                       72 42 1 2 0   19     0   8   36 36                 72
935979 MA Middlesex   school 2506840 155   Lexington 250684001000 1550010 Joseph Estabrook   Regular School No 1 KG 05 2016   kindergarten 28 3 1 0   40     0   5   40 37                       77 28 3 1 0   40     0   5   40 37                 77
935985 MA Middlesex   school 2506840 155   Lexington 250684000996 1550015 Fiske   Regular School No 1 KG 05 2016   kindergarten 58 1 2 0   22     0   5   47 41                       88 58 1 2 0   22     0   5   47 41                 88
935991 MA Middlesex   school 2506840 155   Lexington 250684000998 1550030 Harrington   Regular School No 1 KG 05 2016   kindergarten 29 3 0 0   30     0   7   37 32                       69 29 3 0 0   30     0   7   37 32                 69
935997 MA Middlesex   school 2506840 155   Lexington 250684000473 1550035 Maria Hastings   Regular School No 1 KG 05 2016   kindergarten 33 3 2 0   12     0   5   27 28                       55 33 3 2 0   12     0   5   27 28                 55

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