enrollments

Data source: Big Local News · About: Big Local

954 rows where grade = "grade_4", state = "MA" and year = 2019 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 954 ✖

grade ✖

  • grade_4 · 954 ✖
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
2039812 2039812 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Elementary 03 04 2019   grade_4 143 3 13 0   4     0   2   93 72                       165.0 143 3 13 0   4     0   2   93 72                 165
2039961 2039961 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2019   grade_4 51 3 2 0   11     0   5   42 30                       72.0 51 3 2 0   11     0   5   42 30                 72
2039967 2039967 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2019   grade_4 69 2 8 0   8     1   9   53 44                       97.0 69 2 8 0   8     1   9   53 44                 97
2039973 2039973 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2019   grade_4 61 1 4 0   9     0   5   40 40                       80.0 61 1 4 0   9     0   5   40 40                 80
2039979 2039979 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2019   grade_4 45 5 4 1   11     0   3   40 29                       69.0 45 5 4 1   11     0   3   40 29                 69
2039986 2039986 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2019   grade_4 25 4 5 0   5     0   4   18 25                       43.0 25 4 5 0   5     0   4   18 25                 43
2039992 2039992 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2019   grade_4 52 5 5 1   14     0   7   44 40                       84.0 52 5 5 1   14     0   7   44 40                 84
2039998 2039998 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2019   grade_4 48 2 4 0   6     0   3   31 32                       63.0 48 2 4 0   6     0   3   31 32                 63
2042401 2042401 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No Elementary KG 04 2019   grade_4 41 2 10 0   3     0   4   35 25                       60.0 41 2 10 0   3     0   4   35 25                 60
2042406 2042406 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2019   grade_4 24 4 47 0   4     0   0   45 34                       79.0 24 4 47 0   4     0   0   45 34                 79
2042412 2042412 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2019   grade_4 46 4 9 0   12     0   0   29 42                       71.0 46 4 9 0   12     0   0   29 42                 71
2042418 2042418 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2019   grade_4 70 5 6 0   10     0   3   54 40                       94.0 70 5 6 0   10     0   3   54 40                 94
2042424 2042424 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2019   grade_4 36 4 79 0   1     0   2   50 72                       122.0 36 4 79 0   1     0   2   50 72                 122
2042430 2042430 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No Elementary KG 05 2019   grade_4 65 7 7 0   4     0   3   39 47                       86.0 65 7 7 0   4     0   3   39 47                 86
2042436 2042436 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Mary E Stapleton Elementary   Regular School No Elementary KG 05 2019   grade_4 27 8 11 0   3     0   4   30 23                       53.0 27 8 11 0   3     0   4   30 23                 53
2042442 2042442 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No Elementary KG 05 2019   grade_4 38 17 32 0   1     0   6   50 44                       94.0 38 17 32 0   1     0   6   50 44                 94
2042448 2042448 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2019   grade_4 72 6 15 0   0     0   1   54 40                       94.0 72 6 15 0   0     0   1   54 40                 94
2042468 2042468 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Jefferson Elementary   Regular School No Elementary KG 05 2019   grade_4 57 0 3 0   8     0   1   38 31                       69.0 57 0 3 0   8     0   1   38 31                 69
2042474 2042474 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No Elementary KG 05 2019   grade_4 54 0 1 0   3     0   1   27 32                       59.0 54 0 1 0   3     0   1   27 32                 59
2042480 2042480 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No Elementary KG 05 2019   grade_4 51 0 3 0   4     0   2   30 30                       60.0 51 0 3 0   4     0   2   30 30                 60
2042486 2042486 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Oak Street Elementary   Regular School No Elementary KG 05 2019   grade_4 53 1 1 0   2     0   0   26 31                       57.0 53 1 1 0   2     0   0   26 31                 57
2042492 2042492 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No Elementary KG 05 2019   grade_4 54 1 4 0   5     1   0   35 30                       65.0 54 1 4 0   5     1   0   35 30                 65
2042498 2042498 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No Elementary KG 05 2019   grade_4 38 0 0 0   0     1   0   21 18                       39.0 38 0 0 0   0     1   0   21 18                 39
2042516 2042516 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No Elementary 02 04 2019   grade_4 127 2 34 1   0     0   28   113 79                       192.0 127 2 34 1   0     0   28   113 79                 192
2042538 2042538 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2019   grade_4 80 2 2 0   1     0   2   48 39                       87.0 80 2 2 0   1     0   2   48 39                 87
2042551 2042551 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No Elementary KG 05 2019   grade_4 42 0 9 1   3     0   1   32 24                       56.0 42 0 9 1   3     0   1   32 24                 56
2042557 2042557 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No Elementary KG 05 2019   grade_4 32 0 6 0   0     0   2   26 14                       40.0 32 0 6 0   0     0   2   26 14                 40
2042564 2042564 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No Elementary KG 05 2019   grade_4 30 1 1 0   0     0   0   16 16                       32.0 30 1 1 0   0     0   0   16 16                 32
2042570 2042570 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No Elementary KG 05 2019   grade_4 24 1 5 0   0     0   0   11 19                       30.0 24 1 5 0   0     0   0   11 19                 30
2042576 2042576 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 West Parish   Regular School No Elementary KG 05 2019   grade_4 51 1 5 0   2     0   0   31 28                       59.0 51 1 5 0   2     0   0   31 28                 59
2042594 2042594 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No Elementary 02 06 2019   grade_4 113 0 8 0   11     0   6   71 67                       138.0 113 0 8 0   11     0   6   71 67                 138
2042599 2042599 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No Elementary 02 06 2019   grade_4 102 1 10 0   26     0   1   71 69                       140.0 102 1 10 0   26     0   1   71 69                 140
2042614 2042614 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 East Meadow   Regular School No Elementary PK 06 2019   grade_4 40 0 3 0   0     0   1   14 30                       44.0 40 0 3 0   0     0   1   14 30                 44
2042628 2042628 MA Franklin   school 2505490 114   Greenfield 250549002577 1140010 Federal Street School   Regular School No Elementary KG 04 2019   grade_4 29 2 13 0   1     0   2   24 23                       47.0 29 2 13 0   1     0   2   24 23                 47
2042633 2042633 MA Franklin   school 2505490 114   Greenfield 250549000798 1140025 Discovery School at Four Corners   Regular School No Elementary KG 04 2019   grade_4 36 0 5 0   1     0   0   16 26                       42.0 36 0 5 0   1     0   0   16 26                 42
2042638 2042638 MA Franklin   school 2505490 114   Greenfield 250549002578 1140035 Newton School   Regular School No Elementary KG 04 2019   grade_4 30 2 16 0   0     0   3   26 25                       51.0 30 2 16 0   0     0   3   26 25                 51
2042653 2042653 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No Elementary PK 06 2019   grade_4 23 3 1 0   1     1   0   13 16                       29.0 23 3 1 0   1     1   0   13 16                 29
2042667 2042667 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No Elementary KG 06 2019   grade_4 74 1 5 1   0     0   4   46 39                       85.0 74 1 5 1   0     0   4   46 39                 85
2042673 2042673 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2019   grade_4 * * * *   *     *   *   3 2                       5.0                         3 2                 5
2042680 2042680 MA Plymouth   school 2505790 122   Hanover 250579000827 1220004 Cedar Elementary   Regular School No Elementary PK 04 2019   grade_4 74 2 1 0   1     0   0   40 38                       78.0 74 2 1 0   1     0   0   40 38                 78
2042685 2042685 MA Plymouth   school 2505790 122   Hanover 250579000832 1220015 Sylvester   Regular School No Elementary 03 04 2019   grade_4 117 1 2 0   2     0   4   64 62                       126.0 117 1 2 0   2     0   4   64 62                 126
2042700 2042700 MA Worcester   school 2505880 125   Harvard 250588000839 1250005 Hildreth Elementary School   Regular School No Elementary PK 05 2019   grade_4 59 1 2 0   8     0   3   39 34                       73.0 59 1 2 0   8     0   3   39 34                 73
2042714 2042714 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2019   grade_4 33 0 3 0   0     0   0   21 15                       36.0 33 0 3 0   0     0   0   21 15                 36
2042730 2042730 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Bradford Elementary   Regular School No Elementary KG 04 2019   grade_4 50 4 28 0   1     0   1   50 34                       84.0 50 4 28 0   1     0   1   50 34                 84
2042735 2042735 MA Essex   school 2505970 128   Haverhill 250597000296 1280026 Golden Hill   Regular School No Elementary 01 04 2019   grade_4 59 5 58 0   4     0   6   64 68                       132.0 59 5 58 0   4     0   6   64 68                 132
2042741 2042741 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Caleb Dustin Hunking School   Regular School No Elementary KG 08 2019   grade_4 58 2 24 0   1     0   4   44 45                       89.0 58 2 24 0   1     0   4   44 45                 89
2042758 2042758 MA Essex   school 2505970 128   Haverhill 250597001169 1280054 Pentucket Lake Elementary   Regular School No Elementary KG 04 2019   grade_4 71 5 41 1   2     0   2   68 54                       122.0 71 5 41 1   2     0   2   68 54                 122
2042763 2042763 MA Essex   school 2505970 128   Haverhill 250597000299 1280067 Silver Hill Elementary School   Regular School No Elementary KG 05 2019   grade_4 82 3 50 0   1     0   8   78 66                       144.0 82 3 50 0   1     0   8   78 66                 144
2042768 2042768 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_4 1 0 4 1   0     0   0   5 *                       6.0 1 0 4 1   0     0   0   5                   6
2042782 2042782 MA Essex   school 2505970 128   Haverhill 250597000866 1280075 Tilton   Regular School No Elementary KG 04 2019   grade_4 13 1 27 0   0     0   1   22 20                       42.0 13 1 27 0   0     0   1   22 20                 42
2042790 2042790 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 04 08 2019   grade_4 28 3 52 1   3     0   3   47 43                       90.0 28 3 52 1   3     0   3   47 43                 90
2042805 2042805 MA Plymouth   school 2506090 131   Hingham 250609002671 1310005 East Elementary School   Regular School No Elementary PK 05 2019   grade_4 67 2 1 0   0     0   1   41 30                       71.0 67 2 1 0   0     0   1   41 30                 71
2042811 2042811 MA Plymouth   school 2506090 131   Hingham 250609000876 1310010 Wm L Foster Elementary   Regular School No Elementary KG 05 2019   grade_4 58 1 3 0   0     0   0   31 31                       62.0 58 1 3 0   0     0   0   31 31                 62
2042817 2042817 MA Plymouth   school 2506090 131   Hingham 250609000873 1310019 Plymouth River   Regular School No Elementary KG 05 2019   grade_4 67 3 7 0   1     0   2   38 42                       80.0 67 3 7 0   1     0   2   38 42                 80
2042823 2042823 MA Plymouth   school 2506090 131   Hingham 250609000874 1310020 South Elementary   Regular School No Elementary KG 05 2019   grade_4 79 4 0 0   2     0   4   39 50                       89.0 79 4 0 0   2     0   4   39 50                 89
2042838 2042838 MA Norfolk   school 2506150 133   Holbrook 250615000880 1330018 John F Kennedy   Regular School No Elementary PK 05 2019   grade_4 54 16 12 0   3     0   5   52 38                       90.0 54 16 12 0   3     0   5   52 38                 90
2042853 2042853 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No Elementary PK 06 2019   grade_4 27 0 4 0   0     0   0   15 16                       31.0 27 0 4 0   0     0   0   15 16                 31
2042857 2042857 MA Middlesex   school 2506240 136   Holliston 250624001302 1360007 Miller School   Regular School No Elementary 03 05 2019   grade_4 171 4 9 0   29     0   10   108 115                       223.0 171 4 9 0   29     0   10   108 115                 223
2042876 2042876 MA Hampden   school 2506270 137   Holyoke 250627001178 1370003 Joseph Metcalf School   Regular School No Elementary PK 04 2019   grade_4 6 1 22 0   0     0   0   11 18                       29.0 6 1 22 0   0     0   0   11 18                 29
2042882 2042882 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2019   grade_4 14 0 29 0   2     0   2   24 23                       47.0 14 0 29 0   2     0   2   24 23                 47
2042892 2042892 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No Elementary PK 04 2019   grade_4 0 2 42 0   1     0   0   27 18                       45.0 0 2 42 0   1     0   0   27 18                 45
2042893 2042893 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Middle 04 08 2019   grade_4 6 2 52 0   1     0   1   36 26                       62.0 6 2 52 0   1     0   1   36 26                 62
2042903 2042903 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No Elementary PK 08 2019   grade_4 3 3 50 0   0     0   1   33 24                       57.0 3 3 50 0   0     0   1   33 24                 57
2042912 2042912 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No Elementary PK 05 2019   grade_4 6 2 40 0   0     0   1   23 26                       49.0 6 2 40 0   0     0   1   23 26                 49
2042918 2042918 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No Elementary KG 08 2019   grade_4 6 2 46 0   1     0   0   29 26                       55.0 6 2 46 0   1     0   0   29 26                 55
2042928 2042928 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No Elementary PK 08 2019   grade_4 5 0 43 0   0     0   0   31 17                       48.0 5 0 43 0   0     0   0   31 17                 48
2042950 2042950 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No Elementary KG 06 2019   grade_4 62 0 5 0   0     0   2   34 35                       69.0 62 0 5 0   0     0   2   34 35                 69
2042964 2042964 MA Middlesex   school 2506330 139   Hopkinton 250633001180 1390015 Hopkins Elementary School   Regular School No Elementary 04 05 2019   grade_4 201 1 7 1   51     1   12   144 130                       274.0 201 1 7 1   51     1   12   144 130                 274
2040012 2040012 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 David Mindess   Regular School No Elementary 03 05 2019   grade_4 152 6 20 5   32     0   4   106 113                       219.0 152 6 20 5   32     0   4   106 113                 219
2042979 2042979 MA Middlesex   school 2506390 141   Hudson 250639000924 1410007 Mulready Elementary   Regular School No Elementary PK 04 2019   grade_4 32 2 7 0   1     0   1   18 25                       43.0 32 2 7 0   1     0   1   18 25                 43
2042984 2042984 MA Middlesex   school 2506390 141   Hudson 250639000925 1410015 Forest Avenue Elementary   Regular School No Elementary KG 04 2019   grade_4 57 1 7 0   1     0   1   29 38                       67.0 57 1 7 0   1     0   1   29 38                 67
2042990 2042990 MA Middlesex   school 2506390 141   Hudson 250639000922 1410030 C A Farley   Regular School No Elementary PK 04 2019   grade_4 65 3 11 0   3     0   0   45 37                       82.0 65 3 11 0   3     0   0   45 37                 82
2043004 2043004 MA Plymouth   school 2506420 142   Hull 250642000932 1420015 Lillian M Jacobs   Regular School No Elementary PK 05 2019   grade_4 63 0 0 0   2     0   1   33 33                       66.0 63 0 0 0   2     0   1   33 33                 66
2043019 2043019 MA Essex   school 2506480 144   Ipswich 250648000936 1440007 Paul F Doyon Memorial   Regular School No Elementary PK 05 2019   grade_4 59 0 2 0   4     0   0   36 29                       65.0 59 0 2 0   4     0   0   36 29                 65
2043027 2043027 MA Essex   school 2506480 144   Ipswich 250648000939 1440015 Winthrop   Regular School No Elementary PK 05 2019   grade_4 42 2 4 0   1     0   5   23 31                       54.0 42 2 4 0   1     0   5   23 31                 54
2043041 2043041 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston Intermediate   Regular School No Elementary 03 06 2019   grade_4 131 3 4 1   0     0   1   71 69                       140.0 131 3 4 1   0     0   1   71 69                 140
2043052 2043052 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 South Lawrence East Elementary School   Regular School No Elementary 01 05 2019   grade_4 4 1 130 0   4     0   1   83 57                       140.0 4 1 130 0   4     0   1   83 57                 140
2043058 2043058 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No Elementary KG 04 2019   grade_4 1 1 132 0   0     0   0   75 59                       134.0 1 1 132 0   0     0   0   75 59                 134
2043062 2043062 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Middle 03 08 2019   grade_4 4 1 81 0   1     0   0   37 50                       87.0 4 1 81 0   1     0   0   37 50                 87
2043075 2043075 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Robert Frost   Regular School No Elementary KG 04 2019   grade_4 12 1 110 0   4     0   1   60 68                       128.0 12 1 110 0   4     0   1   60 68                 128
2043083 2043083 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No Elementary 01 04 2019   grade_4 8 6 127 0   0     0   0   71 70                       141.0 8 6 127 0   0     0   0   71 70                 141
2043095 2043095 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No Elementary 01 05 2019   grade_4 3 0 96 0   0     0   0   54 45                       99.0 3 0 96 0   0     0   0   54 45                 99
2043100 2043100 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2019   grade_4 6 0 90 0   1     0   0   56 41                       97.0 6 0 90 0   1     0   0   56 41                 97
2043109 2043109 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Edward F. Parthum   Regular School No Elementary PK 04 2019   grade_4 5 0 135 0   1     0   0   63 78                       141.0 5 0 135 0   1     0   0   63 78                 141
2043113 2043113 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2019   grade_4 1 0 57 0   0     0   0   30 28                       58.0 1 0 57 0   0     0   0   30 28                 58
2043119 2043119 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2019   grade_4 6 0 57 0   1     0   0   32 32                       64.0 6 0 57 0   1     0   0   32 32                 64
2043144 2043144 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2019   grade_4 1 0 13 0   0     0   0   10 4                       14.0 1 0 13 0   0     0   0   10 4                 14
2043158 2043158 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No Elementary PK 06 2019   grade_4 36 1 8 0   2     0   2   33 16                       49.0 36 1 8 0   2     0   2   33 16                 49
2043169 2043169 MA Worcester   school 2506720 151   Leicester 250672000971 1510005 Leicester Memorial Elementary   Regular School No Elementary 03 05 2019   grade_4 86 5 8 2   3     0   3   56 51                       107.0 86 5 8 2   3     0   3   56 51                 107
2043187 2043187 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Morris   Regular School No Elementary PK 05 2019   grade_4 40 0 4 0   2     0   1   26 21                       47.0 40 0 4 0   2     0   1   26 21                 47
2043202 2043202 MA Worcester   school 2506780 153   Leominster 250678000981 1530007 Fall Brook   Regular School No Elementary KG 05 2019   grade_4 65 7 36 0   1     0   5   59 55                       114.0 65 7 36 0   1     0   5   59 55                 114
2043208 2043208 MA Worcester   school 2506780 153   Leominster 250678002637 1530010 Frances Drake School   Regular School No Elementary KG 05 2019   grade_4 46 6 44 0   2     0   7   52 53                       105.0 46 6 44 0   2     0   7   52 53                 105
2043214 2043214 MA Worcester   school 2506780 153   Leominster 250678000985 1530025 Johnny Appleseed   Regular School No Elementary KG 05 2019   grade_4 74 14 42 0   6     0   6   66 76                       142.0 74 14 42 0   6     0   6   66 76                 142
2043220 2043220 MA Worcester   school 2506780 153   Leominster 250678000988 1530030 Northwest   Regular School No Elementary KG 05 2019   grade_4 56 3 50 0   3     0   13   55 70                       125.0 56 3 50 0   3     0   13   55 70                 125
2043246 2043246 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No Elementary PK 06 2019   grade_4 21 0 0 0   0     0   0   15 6                       21.0 21 0 0 0   0     0   0   15 6                 21
2043254 2043254 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Bridge   Regular School No Elementary KG 05 2019   grade_4 44 7 5 0   48     0   0   55 49                       104.0 44 7 5 0   48     0   0   55 49                 104
2043260 2043260 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Bowman   Regular School No Elementary KG 05 2019   grade_4 43 5 2 0   35     0   14   52 47                       99.0 43 5 2 0   35     0   14   52 47                 99
2043266 2043266 MA Middlesex   school 2506840 155   Lexington 250684001000 1550010 Joseph Estabrook   Regular School No Elementary KG 05 2019   grade_4 42 5 4 0   37     0   10   52 46                       98.0 42 5 4 0   37     0   10   52 46                 98
2043272 2043272 MA Middlesex   school 2506840 155   Lexington 250684000996 1550015 Fiske   Regular School No Elementary KG 05 2019   grade_4 54 6 7 0   33     0   6   56 50                       106.0 54 6 7 0   33     0   6   56 50                 106
2043278 2043278 MA Middlesex   school 2506840 155   Lexington 250684000998 1550030 Harrington   Regular School No Elementary KG 05 2019   grade_4 40 0 2 1   26     0   5   38 36                       74.0 40 0 2 1   26     0   5   38 36                 74

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