enrollments

Data source: Big Local News · About: Big Local

973 rows where grade = "grade_1", state = "MA" and year = 2021 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 973 ✖

grade ✖

  • grade_1 · 973 ✖
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
1672012 1672012 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Abington - Beaver Brook Elementary   Regular School No Elementary KG 02 2021   grade_1 127 8 26 1   4     0   2   79 88 *                     168.0 127 8 26 1   4     0   2   79 88                 168
1672154 1672154 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 Arlington - John A Bishop   Regular School No Elementary KG 05 2021   grade_1 41 2 3 0   6     0   12   29 35 *                     64.0 41 2 3 0   6     0   12   29 35                 64
1672160 1672160 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Arlington - Brackett   Regular School No Elementary KG 05 2021   grade_1 51 1 4 0   12     0   8   42 34 *                     76.0 51 1 4 0   12     0   8   42 34                 76
1672166 1672166 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Arlington - Cyrus E Dallin   Regular School No Elementary KG 05 2021   grade_1 42 0 3 0   10     0   8   25 38 *                     63.0 42 0 3 0   10     0   8   25 38                 63
1672172 1672172 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Arlington - Hardy   Regular School No Elementary KG 05 2021   grade_1 44 0 3 0   12     0   8   36 31 *                     67.0 44 0 3 0   12     0   8   36 31                 67
1672179 1672179 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Arlington - Peirce   Regular School No Elementary KG 05 2021   grade_1 37 3 2 0   8     0   3   26 27 *                     53.0 37 3 2 0   8     0   3   26 27                 53
1672185 1672185 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Arlington - Thompson   Regular School No Elementary KG 05 2021   grade_1 51 2 4 0   12     0   9   36 42 *                     78.0 51 2 4 0   12     0   9   36 42                 78
1672191 1672191 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 Arlington - M Norcross Stratton   Regular School No Elementary KG 05 2021   grade_1 41 3 10 0   15     0   14   40 43 *                     83.0 41 3 10 0   15     0   14   40 43                 83
1674560 1674560 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 Framingham - King Elementary School   Regular School No Elementary KG 05 2021   grade_1 34 2 6 0   8     0   4   31 23 *                     54.0 34 2 6 0   8     0   4   31 23                 54
1674566 1674566 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Framingham - Brophy   Regular School No Elementary KG 05 2021   grade_1 21 4 43 0   1     0   3   37 35 *                     72.0 21 4 43 0   1     0   3   37 35                 72
1674572 1674572 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Framingham - Charlotte A Dunning   Regular School No Elementary KG 05 2021   grade_1 36 3 16 0   5     0   6   33 33 *                     66.0 36 3 16 0   5     0   6   33 33                 66
1674578 1674578 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Framingham - Hemenway   Regular School No Elementary KG 05 2021   grade_1 44 5 22 0   13     0   5   41 48 *                     89.0 44 5 22 0   13     0   5   41 48                 89
1674584 1674584 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Framingham - Barbieri Elementary   Regular School No Elementary KG 05 2021   grade_1 16 0 91 0   2     0   6   50 65 *                     115.0 16 0 91 0   2     0   6   50 65                 115
1674590 1674590 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Framingham - Potter Road   Regular School No Elementary KG 05 2021   grade_1 33 5 42 0   3     0   5   36 52 *                     88.0 33 5 42 0   3     0   5   36 52                 88
1674596 1674596 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Framingham - Mary E Stapleton Elementary   Regular School No Elementary KG 05 2021   grade_1 11 6 25 0   4     0   2   27 21 *                     48.0 11 6 25 0   4     0   2   27 21                 48
1674602 1674602 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Framingham - Miriam F McCarthy School   Regular School No Elementary KG 05 2021   grade_1 19 9 25 0   2     0   11   28 38 *                     66.0 19 9 25 0   2     0   11   28 38                 66
1674608 1674608 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Framingham - Woodrow Wilson   Regular School No Elementary KG 05 2021   grade_1 17 2 39 0   0     0   3   35 26 *                     61.0 17 2 39 0   0     0   3   35 26                 61
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
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
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
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
1674751 1674751 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_1 * * * *   *     *   *   * * *                     0.0                                             0
1674766 1674766 MA Worcester   school 2505370 110   Grafton 250537000788 1100005 Grafton - South Grafton Elementary   Regular School No Elementary PK 01 2021   grade_1 100 4 9 1   22     0   2   75 63 *                     138.0 100 4 9 1   22     0   2   75 63                 138
1674769 1674769 MA Worcester   school 2505370 110   Grafton 250537000787 1100025 Grafton - North Grafton Elementary   Regular School No Elementary PK 01 2021   grade_1 91 2 4 0   9     0   3   42 67 *                     109.0 91 2 4 0   9     0   3   42 67                 109
1674788 1674788 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 Granby - East Meadow   Regular School No Elementary PK 06 2021   grade_1 45 0 8 0   0     0   1   27 27 *                     54.0 45 0 8 0   0     0   1   27 27                 54
1674802 1674802 MA Franklin   school 2505490 114   Greenfield 250549002577 1140010 Greenfield - Federal Street School   Regular School No Elementary KG 04 2021   grade_1 23 0 8 0   0     0   0   17 14 *                     31.0 23 0 8 0   0     0   0   17 14                 31
1674807 1674807 MA Franklin   school 2505490 114   Greenfield 250549000798 1140025 Greenfield - Discovery School at Four Corners   Regular School No Elementary KG 04 2021   grade_1 43 0 4 0   0     0   1   30 18 *                     48.0 43 0 4 0   0     0   1   30 18                 48
1674812 1674812 MA Franklin   school 2505490 114   Greenfield 250549002578 1140035 Greenfield - Newton School   Regular School No Elementary KG 04 2021   grade_1 40 2 18 0   0     0   2   27 35 *                     62.0 40 2 18 0   0     0   2   27 35                 62
1674826 1674826 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley - Hadley Elementary   Regular School No Elementary PK 06 2021   grade_1 23 0 3 0   0     0   2   18 10 *                     28.0 23 0 3 0   0     0   2   18 10                 28
1674839 1674839 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax - Halifax Elementary   Regular School No Elementary KG 06 2021   grade_1 54 1 3 0   0     0   2   36 24 *                     60.0 54 1 3 0   0     0   2   36 24                 60
1674847 1674847 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock - Hancock Elementary   Regular School No Elementary PK 06 2021   grade_1 9 0 0 0   0     0   0   3 6 *                     9.0 9 0 0 0   0     0   0   3 6                 9
1674855 1674855 MA Plymouth   school 2505790 122   Hanover 250579000827 1220004 Hanover - Cedar Elementary   Regular School No Elementary PK 01 2021   grade_1 201 3 3 0   3     0   1   105 106 *                     211.0 201 3 3 0   3     0   1   105 106                 211
1674870 1674870 MA Worcester   school 2505880 125   Harvard 250588000839 1250005 Harvard - Hildreth Elementary School   Regular School No Elementary PK 05 2021   grade_1 42 2 3 0   10     0   4   29 32 *                     61.0 42 2 3 0   10     0   4   29 32                 61
1674884 1674884 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield - Hatfield Elementary   Regular School No Elementary PK 06 2021   grade_1 25 0 1 0   1     0   2   13 16 *                     29.0 25 0 1 0   1     0   2   13 16                 29
1674897 1674897 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Haverhill - Bradford Elementary   Regular School No Elementary KG 04 2021   grade_1 46 5 51 0   2     0   3   59 48 *                     107.0 46 5 51 0   2     0   3   59 48                 107
1674902 1674902 MA Essex   school 2505970 128   Haverhill 250597000296 1280026 Haverhill - Golden Hill   Regular School No Elementary KG 04 2021   grade_1 46 7 32 0   0     0   1   47 38 *                     86.0 46 7 32 0   0     0   1   47 38                 86
1674907 1674907 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Haverhill - Caleb Dustin Hunking School   Regular School No Elementary KG 08 2021   grade_1 60 4 24 0   2     0   2   42 50 *                     92.0 60 4 24 0   2     0   2   42 50                 92
1674926 1674926 MA Essex   school 2505970 128   Haverhill 250597001169 1280054 Haverhill - Pentucket Lake Elementary   Regular School No Elementary KG 04 2021   grade_1 33 8 40 0   0     0   0   48 33 *                     81.0 33 8 40 0   0     0   0   48 33                 81
1674931 1674931 MA Essex   school 2505970 128   Haverhill 250597000299 1280067 Haverhill - Silver Hill Elementary School   Regular School No Elementary KG 05 2021   grade_1 34 7 34 1   7     0   1   39 45 *                     84.0 34 7 34 1   7     0   1   39 45                 84
1674939 1674939 MA Essex   school 2505970 128   Haverhill 250597000866 1280075 Haverhill - Tilton   Regular School No Elementary KG 03 2021   grade_1 38 5 39 0   1     0   3   38 48 *                     86.0 38 5 39 0   1     0   3   38 48                 86
1674943 1674943 MA Essex   school 2505970 128   Haverhill 250597000867 1280080 Haverhill - Walnut Square   Regular School No Elementary KG 02 2021   grade_1 25 2 20 0   0     0   1   19 29 *                     48.0 25 2 20 0   0     0   1   19 29                 48
1674966 1674966 MA Plymouth   school 2506090 131   Hingham 250609002671 1310005 Hingham - East Elementary School   Regular School No Elementary PK 05 2021   grade_1 47 0 1 0   1     0   2   25 26 *                     51.0 47 0 1 0   1     0   2   25 26                 51
1674972 1674972 MA Plymouth   school 2506090 131   Hingham 250609000876 1310010 Hingham - Wm L Foster Elementary   Regular School No Elementary KG 05 2021   grade_1 63 1 0 0   1     0   7   45 27 *                     72.0 63 1 0 0   1     0   7   45 27                 72
1674978 1674978 MA Plymouth   school 2506090 131   Hingham 250609000873 1310019 Hingham - Plymouth River   Regular School No Elementary KG 05 2021   grade_1 53 3 2 0   1     0   1   24 36 *                     60.0 53 3 2 0   1     0   1   24 36                 60
1674984 1674984 MA Plymouth   school 2506090 131   Hingham 250609000874 1310020 Hingham - South Elementary   Regular School No Elementary KG 05 2021   grade_1 67 0 2 0   1     0   1   30 41 *                     71.0 67 0 2 0   1     0   1   30 41                 71
1674999 1674999 MA Norfolk   school 2506150 133   Holbrook 250615000880 1330018 Holbrook - John F Kennedy   Regular School No Elementary PK 05 2021   grade_1 63 19 15 1   3     0   9   57 53 *                     110.0 63 19 15 1   3     0   9   57 53                 110
1675014 1675014 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland - Holland Elementary   Regular School No Elementary PK 06 2021   grade_1 15 0 2 0   1     0   0   9 9 *                     18.0 15 0 2 0   1     0   0   9 9                 18
1675025 1675025 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Holliston - Placentino Elementary   Regular School No Elementary PK 02 2021   grade_1 154 3 5 0   26     0   4   91 101 *                     192.0 154 3 5 0   26     0   4   91 101                 192
1675036 1675036 MA Hampden   school 2506270 137   Holyoke 250627001178 1370003 Holyoke - Joseph Metcalf School   Regular School No Elementary PK 06 2021   grade_1 9 1 31 0   0     0   1   21 21 *                     42.0 9 1 31 0   0     0   1   21 21                 42
1675044 1675044 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Holyoke - Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2021   grade_1 13 0 26 0   1     0   0   22 18 *                     40.0 13 0 26 0   1     0   0   22 18                 40
1675054 1675054 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Holyoke - Morgan Full Service Community School   Regular School No Elementary PK 04 2021   grade_1 0 5 44 0   0     0   0   24 25 *                     49.0 0 5 44 0   0     0   0   24 25                 49
1675065 1675065 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Holyoke - Kelly Elementary   Regular School No Elementary PK 08 2021   grade_1 1 2 55 0   0     0   0   29 29 *                     58.0 1 2 55 0   0     0   0   29 29                 58
1675072 1675072 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 Holyoke - E N White Elementary   Regular School No Elementary PK 05 2021   grade_1 17 5 44 0   0     0   2   34 34 *                     68.0 17 5 44 0   0     0   2   34 34                 68
1675079 1675079 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Holyoke - Lt Clayre Sullivan Elementary   Regular School No Elementary PK 08 2021   grade_1 2 0 41 0   0     0   2   28 17 *                     45.0 2 0 41 0   0     0   2   28 17                 45
1675089 1675089 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Holyoke - Maurice A Donahue Elementary   Regular School No Elementary PK 08 2021   grade_1 3 2 39 0   0     1   1   29 17 *                     46.0 3 2 39 0   0     1   1   29 17                 46
1675097 1675097 MA Hampden   school 2506270 137   Holyoke 250627002795 1370070 Holyoke - H.B. Lawrence School   Regular School No Elementary KG 03 2021   grade_1 5 2 42 0   1     0   2   25 27 *                     52.0 5 2 42 0   1     0   2   25 27                 52
1675112 1675112 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Hopedale - Memorial   Regular School No Elementary KG 06 2021   grade_1 54 1 9 0   2     0   5   35 36 *                     71.0 54 1 9 0   2     0   5   35 36                 71
1675126 1675126 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Hopkinton - Marathon Elementary School   Regular School No Elementary KG 01 2021   grade_1 159 1 14 0   89     0   15   145 133 *                     278.0 159 1 14 0   89     0   15   145 133                 278
1672205 1672205 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Ashland - Henry E Warren Elementary   Regular School No Elementary KG 02 2021   grade_1 105 4 20 0   46     0   5   103 77 *                     180.0 105 4 20 0   46     0   5   103 77                 180
1675141 1675141 MA Middlesex   school 2506390 141   Hudson 250639000924 1410007 Hudson - Mulready Elementary   Regular School No Elementary PK 04 2021   grade_1 34 3 5 0   0     0   0   18 24 *                     42.0 34 3 5 0   0     0   0   18 24                 42
1675146 1675146 MA Middlesex   school 2506390 141   Hudson 250639000925 1410015 Hudson - Forest Avenue Elementary   Regular School No Elementary KG 04 2021   grade_1 50 4 10 1   0     0   0   29 36 *                     65.0 50 4 10 1   0     0   0   29 36                 65
1675152 1675152 MA Middlesex   school 2506390 141   Hudson 250639000922 1410030 Hudson - C A Farley   Regular School No Elementary PK 04 2021   grade_1 59 2 13 0   0     0   3   42 35 *                     77.0 59 2 13 0   0     0   3   42 35                 77
1675166 1675166 MA Plymouth   school 2506420 142   Hull 250642000932 1420015 Hull - Lillian M Jacobs   Regular School No Elementary PK 05 2021   grade_1 49 2 2 0   0     0   1   26 28 *                     54.0 49 2 2 0   0     0   1   26 28                 54
1675179 1675179 MA Essex   school 2506480 144   Ipswich 250648000936 1440007 Ipswich - Paul F Doyon Memorial   Regular School No Elementary KG 05 2021   grade_1 39 0 7 0   0     0   1   25 22 *                     47.0 39 0 7 0   0     0   1   25 22                 47
1675186 1675186 MA Essex   school 2506480 144   Ipswich 250648000939 1440015 Ipswich - Winthrop   Regular School No Elementary PK 05 2021   grade_1 44 1 3 0   0     0   2   24 26 *                     50.0 44 1 3 0   0     0   2   24 26                 50
1675199 1675199 MA Plymouth   school 2506540 145   Kingston 250654000943 1450005 Kingston - Kingston Elementary   Regular School No Elementary KG 02 2021   grade_1 143 1 3 0   2     0   0   73 76 *                     149.0 143 1 3 0   2     0   0   73 76                 149
1675210 1675210 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 Lawrence - South Lawrence East Elementary School   Regular School No Elementary 01 05 2021   grade_1 4 4 117 0   6     0   1   64 67 *                     132.0 4 4 117 0   6     0   1   64 67                 132
1675216 1675216 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Lawrence - Community Day Arlington   Regular School No Elementary KG 04 2021   grade_1 3 1 115 0   0     0   0   60 55 *                     119.0 3 1 115 0   0     0   0   60 55                 119
1675233 1675233 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Lawrence - Robert Frost   Regular School No Elementary KG 04 2021   grade_1 7 2 96 0   5     0   1   58 53 *                     111.0 7 2 96 0   5     0   1   58 53                 111
1675239 1675239 MA Essex   school 2506660 149   Lawrence 250666000958 1490020 Lawrence - James F Hennessey   Regular School No Elementary PK 02 2021   grade_1 2 0 72 0   1     0   0   36 39 *                     75.0 2 0 72 0   1     0   0   36 39                 75
1675241 1675241 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Lawrence - Gerard A. Guilmette   Regular School No Elementary 01 04 2021   grade_1 3 0 87 0   1     0   0   47 44 *                     91.0 3 0 87 0   1     0   0   47 44                 91
1675253 1675253 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Lawrence - Francis M Leahy   Regular School No Elementary 01 05 2021   grade_1 3 1 71 0   0     0   0   40 35 *                     75.0 3 1 71 0   0     0   0   40 35                 75
1675258 1675258 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Lawrence - Oliver Partnership School   Regular School No Elementary 01 05 2021   grade_1 2 0 84 0   0     0   0   41 45 *                     86.0 2 0 84 0   0     0   0   41 45                 86
1675267 1675267 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Lawrence - Edward F. Parthum   Regular School No Elementary KG 04 2021   grade_1 4 5 137 0   0     0   1   82 63 *                     147.0 4 5 137 0   0     0   1   82 63                 147
1675271 1675271 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 Lawrence - John K Tarbox   Regular School No Elementary 01 05 2021   grade_1 1 0 50 0   0     0   0   29 22 *                     51.0 1 0 50 0   0     0   0   29 22                 51
1675277 1675277 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Lawrence - Emily G Wetherbee   Regular School No Elementary KG 08 2021   grade_1 4 1 54 0   1     0   1   26 34 *                     61.0 4 1 54 0   1     0   1   26 34                 61
1675317 1675317 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee - Lee Elementary   Regular School No Elementary PK 06 2021   grade_1 42 0 2 0   0     0   1   26 19 *                     45.0 42 0 2 0   0     0   1   26 19                 45
1675332 1675332 MA Worcester   school 2506720 151   Leicester 250672000971 1510005 Leicester - Leicester Elementary   Regular School No Elementary KG 04 2021   grade_1 70 7 12 0   5     0   3   52 45 *                     97.0 70 7 12 0   5     0   3   52 45                 97
1675346 1675346 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Lenox - Morris   Regular School No Elementary PK 05 2021   grade_1 31 0 5 0   6     0   5   23 24 *                     47.0 31 0 5 0   6     0   5   23 24                 47
1675361 1675361 MA Worcester   school 2506780 153   Leominster 250678000981 1530007 Leominster - Fall Brook   Regular School No Elementary KG 05 2021   grade_1 54 8 28 0   5     0   4   57 42 *                     99.0 54 8 28 0   5     0   4   57 42                 99
1675367 1675367 MA Worcester   school 2506780 153   Leominster 250678002637 1530010 Leominster - Frances Drake School   Regular School No Elementary KG 05 2021   grade_1 32 8 40 0   4     0   5   39 50 *                     89.0 32 8 40 0   4     0   5   39 50                 89
1675373 1675373 MA Worcester   school 2506780 153   Leominster 250678000985 1530025 Leominster - Johnny Appleseed   Regular School No Elementary KG 05 2021   grade_1 49 17 43 0   4     0   7   60 60 *                     120.0 49 17 43 0   4     0   7   60 60                 120
1675379 1675379 MA Worcester   school 2506780 153   Leominster 250678000988 1530030 Leominster - Northwest   Regular School No Elementary KG 05 2021   grade_1 46 13 49 0   3     0   5   55 61 *                     116.0 46 13 49 0   3     0   5   55 61                 116
1675404 1675404 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett - Leverett Elementary   Regular School No Elementary PK 06 2021   grade_1 12 0 2 0   0     0   0   6 8 *                     14.0 12 0 2 0   0     0   0   6 8                 14
1675412 1675412 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Lexington - Bridge   Regular School No Elementary KG 05 2021   grade_1 18 3 7 0   20     0   9   28 29 *                     57.0 18 3 7 0   20     0   9   28 29                 57
1675418 1675418 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Lexington - Bowman   Regular School No Elementary KG 05 2021   grade_1 26 4 3 0   33     0   5   35 36 *                     71.0 26 4 3 0   33     0   5   35 36                 71
1675424 1675424 MA Middlesex   school 2506840 155   Lexington 250684001000 1550010 Lexington - Joseph Estabrook   Regular School No Elementary KG 05 2021   grade_1 25 2 6 0   39     0   7   42 37 *                     79.0 25 2 6 0   39     0   7   42 37                 79
1675430 1675430 MA Middlesex   school 2506840 155   Lexington 250684000996 1550015 Lexington - Fiske   Regular School No Elementary KG 05 2021   grade_1 22 0 3 0   26     0   7   31 27 *                     58.0 22 0 3 0   26     0   7   31 27                 58
1675436 1675436 MA Middlesex   school 2506840 155   Lexington 250684000998 1550030 Lexington - Harrington   Regular School No Elementary KG 05 2021   grade_1 26 2 4 0   30     0   5   35 32 *                     67.0 26 2 4 0   30     0   5   35 32                 67
1675442 1675442 MA Middlesex   school 2506840 155   Lexington 250684000473 1550035 Lexington - Maria Hastings   Regular School No Elementary KG 05 2021   grade_1 25 1 3 0   39     0   8   40 36 *                     76.0 25 1 3 0   39     0   8   40 36                 76
1675459 1675459 MA Middlesex   school 2506900 157   Lincoln 250690001009 1570006 Lincoln - Hanscom Primary   Regular School No Elementary PK 03 2021   grade_1 32 2 19 0   1     3   11   34 34 *                     68.0 32 2 19 0   1     3   11   34 34                 68

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