enrollments

Data source: Big Local News · About: Big Local

878 rows where grade = "grade_5", state = "MA" and year = 2019 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 878 ✖

grade ✖

  • grade_5 · 878 ✖
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
2039816 2039816 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2019   grade_5 134 4 14 2   4     0   1   85 74                       159.0 134 4 14 2   4     0   1   85 74                 159
2039962 2039962 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2019   grade_5 54 3 3 0   7     0   4   35 36                       71.0 54 3 3 0   7     0   4   35 36                 71
2039968 2039968 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2019   grade_5 63 2 4 0   5     0   7   42 39                       81.0 63 2 4 0   5     0   7   42 39                 81
2039974 2039974 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2019   grade_5 67 4 7 0   6     0   4   43 45                       88.0 67 4 7 0   6     0   4   43 45                 88
2039980 2039980 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2019   grade_5 42 7 4 0   6     0   4   32 31                       63.0 42 7 4 0   6     0   4   32 31                 63
2039987 2039987 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2019   grade_5 42 1 5 0   1     0   0   31 18                       49.0 42 1 5 0   1     0   0   31 18                 49
2039993 2039993 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2019   grade_5 42 4 13 0   12     0   4   38 37                       75.0 42 4 13 0   12     0   4   38 37                 75
2039999 2039999 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2019   grade_5 46 2 2 0   6     0   6   32 30                       62.0 46 2 2 0   6     0   6   32 30                 62
2042407 2042407 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2019   grade_5 34 8 55 0   6     0   2   56 49                       105.0 34 8 55 0   6     0   2   56 49                 105
2042413 2042413 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2019   grade_5 66 3 10 0   14     0   2   50 45                       95.0 66 3 10 0   14     0   2   50 45                 95
2042419 2042419 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2019   grade_5 72 3 9 0   8     0   5   46 51                       97.0 72 3 9 0   8     0   5   46 51                 97
2042425 2042425 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2019   grade_5 25 3 63 1   2     0   1   48 47                       95.0 25 3 63 1   2     0   1   48 47                 95
2042431 2042431 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No Elementary KG 05 2019   grade_5 75 6 6 0   2     0   5   56 38                       94.0 75 6 6 0   2     0   5   56 38                 94
2042437 2042437 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Mary E Stapleton Elementary   Regular School No Elementary KG 05 2019   grade_5 50 3 13 0   0     0   4   38 32                       70.0 50 3 13 0   0     0   4   38 32                 70
2042443 2042443 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No Elementary KG 05 2019   grade_5 61 16 26 0   3     1   8   64 51                       115.0 61 16 26 0   3     1   8   64 51                 115
2042449 2042449 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2019   grade_5 74 8 20 0   0     0   2   41 63                       104.0 74 8 20 0   0     0   2   41 63                 104
2042469 2042469 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Jefferson Elementary   Regular School No Elementary KG 05 2019   grade_5 53 2 0 0   7     0   0   33 29                       62.0 53 2 0 0   7     0   0   33 29                 62
2042475 2042475 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No Elementary KG 05 2019   grade_5 74 1 0 0   2     0   0   40 37                       77.0 74 1 0 0   2     0   0   40 37                 77
2042481 2042481 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No Elementary KG 05 2019   grade_5 50 1 1 0   1     1   1   28 27                       55.0 50 1 1 0   1     1   1   28 27                 55
2042487 2042487 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Oak Street Elementary   Regular School No Elementary KG 05 2019   grade_5 65 2 3 0   6     1   3   43 37                       80.0 65 2 3 0   6     1   3   43 37                 80
2042493 2042493 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No Elementary KG 05 2019   grade_5 47 1 3 1   0     0   0   29 23                       52.0 47 1 3 1   0     0   0   29 23                 52
2042499 2042499 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No Elementary KG 05 2019   grade_5 40 3 3 0   3     0   1   24 26                       50.0 40 3 3 0   3     0   1   24 26                 50
2042520 2042520 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No Middle 05 07 2019   grade_5 128 2 35 0   4     0   14   102 81                       183.0 128 2 35 0   4     0   14   102 81                 183
2042539 2042539 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2019   grade_5 115 1 1 0   0     1   2   61 59                       120.0 115 1 1 0   0     1   2   61 59                 120
2042552 2042552 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No Elementary KG 05 2019   grade_5 40 1 8 1   2     0   1   30 23                       53.0 40 1 8 1   2     0   1   30 23                 53
2042558 2042558 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No Elementary KG 05 2019   grade_5 37 0 3 0   0     0   3   19 24                       43.0 37 0 3 0   0     0   3   19 24                 43
2042565 2042565 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No Elementary KG 05 2019   grade_5 35 0 1 0   0     0   0   23 13                       36.0 35 0 1 0   0     0   0   23 13                 36
2042571 2042571 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No Elementary KG 05 2019   grade_5 33 1 9 0   0     0   0   19 24                       43.0 33 1 9 0   0     0   0   19 24                 43
2042577 2042577 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 West Parish   Regular School No Elementary KG 05 2019   grade_5 41 0 2 0   1     1   3   26 22                       48.0 41 0 2 0   1     1   3   26 22                 48
2042595 2042595 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No Elementary 02 06 2019   grade_5 83 2 7 1   6     0   4   64 39                       103.0 83 2 7 1   6     0   4   64 39                 103
2042600 2042600 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No Elementary 02 06 2019   grade_5 108 2 10 0   21     0   0   69 72                       141.0 108 2 10 0   21     0   0   69 72                 141
2042615 2042615 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 East Meadow   Regular School No Elementary PK 06 2019   grade_5 39 0 4 0   1     0   1   28 17                       45.0 39 0 4 0   1     0   1   28 17                 45
2042639 2042639 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No Middle 05 07 2019   grade_5 109 4 23 0   0     0   10   69 77                       146.0 109 4 23 0   0     0   10   69 77                 146
2042654 2042654 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No Elementary PK 06 2019   grade_5 37 1 6 0   2     1   2   22 27                       49.0 37 1 6 0   2     1   2   22 27                 49
2042668 2042668 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No Elementary KG 06 2019   grade_5 76 1 2 1   1     0   2   41 42                       83.0 76 1 2 1   1     0   2   41 42                 83
2042686 2042686 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No Middle 05 08 2019   grade_5 169 1 6 0   4     0   0   102 78                       180.0 169 1 6 0   4     0   0   102 78                 180
2042701 2042701 MA Worcester   school 2505880 125   Harvard 250588000839 1250005 Hildreth Elementary School   Regular School No Elementary PK 05 2019   grade_5 74 1 2 0   5     0   6   34 54                       88.0 74 1 2 0   5     0   6   34 54                 88
2042715 2042715 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2019   grade_5 32 1 3 0   0     0   0   18 18                       36.0 32 1 3 0   0     0   0   18 18                 36
2042742 2042742 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Caleb Dustin Hunking School   Regular School No Elementary KG 08 2019   grade_5 104 11 39 1   3     0   1   87 72                       159.0 104 11 39 1   3     0   1   87 72                 159
2042750 2042750 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No Middle 05 08 2019   grade_5 56 7 65 0   2     0   2   74 58                       132.0 56 7 65 0   2     0   2   74 58                 132
2042764 2042764 MA Essex   school 2505970 128   Haverhill 250597000299 1280067 Silver Hill Elementary School   Regular School No Elementary KG 05 2019   grade_5 50 3 19 0   1     0   1   34 40                       74.0 50 3 19 0   1     0   1   34 40                 74
2042769 2042769 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_5 * * * *   *     *   *   5 *                       5.0                         5                   5
2042786 2042786 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2019   grade_5 52 6 59 0   4     1   3   60 65                       125.0 52 6 59 0   4     1   3   60 65                 125
2042791 2042791 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 04 08 2019   grade_5 58 5 111 0   6     0   5   102 83                       185.0 58 5 111 0   6     0   5   102 83                 185
2042806 2042806 MA Plymouth   school 2506090 131   Hingham 250609002671 1310005 East Elementary School   Regular School No Elementary PK 05 2019   grade_5 84 1 2 0   3     0   1   54 37                       91.0 84 1 2 0   3     0   1   54 37                 91
2042812 2042812 MA Plymouth   school 2506090 131   Hingham 250609000876 1310010 Wm L Foster Elementary   Regular School No Elementary KG 05 2019   grade_5 80 0 2 0   5     0   2   46 43                       89.0 80 0 2 0   5     0   2   46 43                 89
2042818 2042818 MA Plymouth   school 2506090 131   Hingham 250609000873 1310019 Plymouth River   Regular School No Elementary KG 05 2019   grade_5 83 0 4 0   1     0   3   43 48                       91.0 83 0 4 0   1     0   3   43 48                 91
2042824 2042824 MA Plymouth   school 2506090 131   Hingham 250609000874 1310020 South Elementary   Regular School No Elementary KG 05 2019   grade_5 84 1 2 0   4     0   2   56 37                       93.0 84 1 2 0   4     0   2   56 37                 93
2042839 2042839 MA Norfolk   school 2506150 133   Holbrook 250615000880 1330018 John F Kennedy   Regular School No Elementary PK 05 2019   grade_5 55 14 19 0   4     0   13   53 52                       105.0 55 14 19 0   4     0   13   53 52                 105
2042854 2042854 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No Elementary PK 06 2019   grade_5 24 0 1 0   1     0   0   14 12                       26.0 24 0 1 0   1     0   0   14 12                 26
2042858 2042858 MA Middlesex   school 2506240 136   Holliston 250624001302 1360007 Miller School   Regular School No Elementary 03 05 2019   grade_5 187 3 17 0   16     0   7   116 114                       230.0 187 3 17 0   16     0   7   116 114                 230
2042883 2042883 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2019   grade_5 11 0 26 0   1     0   3   25 16                       41.0 11 0 26 0   1     0   3   25 16                 41
2042894 2042894 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Middle 04 08 2019   grade_5 6 0 45 0   0     0   0   27 24                       51.0 6 0 45 0   0     0   0   27 24                 51
2042913 2042913 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No Elementary PK 05 2019   grade_5 5 2 39 0   1     0   1   27 21                       48.0 5 2 39 0   1     0   1   27 21                 48
2042919 2042919 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No Elementary KG 08 2019   grade_5 6 1 60 0   1     0   2   42 28                       70.0 6 1 60 0   1     0   2   42 28                 70
2042929 2042929 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No Elementary PK 08 2019   grade_5 8 2 45 0   0     0   0   27 28                       55.0 8 2 45 0   0     0   0   27 28                 55
2042937 2042937 MA Hampden   school 2506270 137   Holyoke 250627002895 1370075 Veritas Prep Holyoke   Regular School No Middle 05 05 2019   grade_5 3 8 127 0   0     0   1   79 60                       139.0 3 8 127 0   0     0   1   79 60                 139
2042951 2042951 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No Elementary KG 06 2019   grade_5 71 0 7 0   1     1   2   44 38                       82.0 71 0 7 0   1     1   2   44 38                 82
2042965 2042965 MA Middlesex   school 2506330 139   Hopkinton 250633001180 1390015 Hopkins Elementary School   Regular School No Elementary 04 05 2019   grade_5 195 2 15 1   48     0   16   147 130                       277.0 195 2 15 1   48     0   16   147 130                 277
2040013 2040013 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 David Mindess   Regular School No Elementary 03 05 2019   grade_5 149 2 28 5   25     0   9   110 108                       218.0 149 2 28 5   25     0   9   110 108                 218
2042991 2042991 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 David J. Quinn Middle School   Regular School No Middle 05 07 2019   grade_5 182 3 25 0   3     0   6   104 115                       219.0 182 3 25 0   3     0   6   104 115                 219
2043005 2043005 MA Plymouth   school 2506420 142   Hull 250642000932 1420015 Lillian M Jacobs   Regular School No Elementary PK 05 2019   grade_5 62 1 0 0   0     0   1   39 25                       64.0 62 1 0 0   0     0   1   39 25                 64
2043020 2043020 MA Essex   school 2506480 144   Ipswich 250648000936 1440007 Paul F Doyon Memorial   Regular School No Elementary PK 05 2019   grade_5 61 0 3 0   0     0   2   37 29                       66.0 61 0 3 0   0     0   2   37 29                 66
2043028 2043028 MA Essex   school 2506480 144   Ipswich 250648000939 1440015 Winthrop   Regular School No Elementary PK 05 2019   grade_5 51 2 4 0   2     0   5   35 29                       64.0 51 2 4 0   2     0   5   35 29                 64
2043042 2043042 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston Intermediate   Regular School No Elementary 03 06 2019   grade_5 136 0 2 1   2     0   0   72 68                       141.0 136 0 2 1   2     0   0   72 68                 141
2043053 2043053 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 South Lawrence East Elementary School   Regular School No Elementary 01 05 2019   grade_5 11 1 141 0   3     0   1   77 80                       157.0 11 1 141 0   3     0   1   77 80                 157
2043063 2043063 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Middle 03 08 2019   grade_5 2 1 91 0   2     0   0   47 49                       96.0 2 1 91 0   2     0   0   47 49                 96
2043067 2043067 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2019   grade_5 4 0 133 1   0     0   0   65 72                       138.0 4 0 133 1   0     0   0   65 72                 138
2043084 2043084 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2019   grade_5 1 3 127 0   1     0   0   76 56                       132.0 1 3 127 0   1     0   0   76 56                 132
2043088 2043088 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2019   grade_5 5 1 142 0   1     0   1   75 75                       150.0 5 1 142 0   1     0   1   75 75                 150
2043096 2043096 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No Elementary 01 05 2019   grade_5 1 0 87 0   0     0   0   45 43                       88.0 1 0 87 0   0     0   0   45 43                 88
2043101 2043101 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2019   grade_5 2 0 101 0   1     0   0   50 53                       104.0 2 0 101 0   1     0   0   50 53                 104
2043114 2043114 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2019   grade_5 1 0 42 0   0     0   0   24 19                       43.0 1 0 42 0   0     0   0   24 19                 43
2043120 2043120 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2019   grade_5 4 0 67 0   0     0   0   31 40                       71.0 4 0 67 0   0     0   0   31 40                 71
2043135 2043135 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2019   grade_5 9 7 108 0   2     0   4   77 53                       130.0 9 7 108 0   2     0   4   77 53                 130
2043145 2043145 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2019   grade_5 0 0 8 0   0     0   0   7 1                       8.0 0 0 8 0   0     0   0   7 1                 8
2043159 2043159 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No Elementary PK 06 2019   grade_5 29 0 6 0   3     0   1   16 23                       39.0 29 0 6 0   3     0   1   16 23                 39
2043170 2043170 MA Worcester   school 2506720 151   Leicester 250672000971 1510005 Leicester Memorial Elementary   Regular School No Elementary 03 05 2019   grade_5 103 9 12 0   1     0   1   71 55                       126.0 103 9 12 0   1     0   1   71 55                 126
2043188 2043188 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Morris   Regular School No Elementary PK 05 2019   grade_5 48 0 2 0   2     0   2   30 24                       54.0 48 0 2 0   2     0   2   30 24                 54
2043203 2043203 MA Worcester   school 2506780 153   Leominster 250678000981 1530007 Fall Brook   Regular School No Elementary KG 05 2019   grade_5 55 4 34 1   4     0   2   54 45                       100.0 55 4 34 1   4     0   2   54 45                 100
2043209 2043209 MA Worcester   school 2506780 153   Leominster 250678002637 1530010 Frances Drake School   Regular School No Elementary KG 05 2019   grade_5 47 12 33 0   8     0   6   49 57                       106.0 47 12 33 0   8     0   6   49 57                 106
2043215 2043215 MA Worcester   school 2506780 153   Leominster 250678000985 1530025 Johnny Appleseed   Regular School No Elementary KG 05 2019   grade_5 49 16 42 1   5     0   4   64 53                       117.0 49 16 42 1   5     0   4   64 53                 117
2043221 2043221 MA Worcester   school 2506780 153   Leominster 250678000988 1530030 Northwest   Regular School No Elementary KG 05 2019   grade_5 78 11 52 0   3     0   5   79 70                       149.0 78 11 52 0   3     0   5   79 70                 149
2043247 2043247 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No Elementary PK 06 2019   grade_5 13 0 2 0   0     0   0   9 6                       15.0 13 0 2 0   0     0   0   9 6                 15
2043255 2043255 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Bridge   Regular School No Elementary KG 05 2019   grade_5 55 5 2 0   42     0   3   57 50                       107.0 55 5 2 0   42     0   3   57 50                 107
2043261 2043261 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Bowman   Regular School No Elementary KG 05 2019   grade_5 54 9 2 0   35     0   8   60 48                       108.0 54 9 2 0   35     0   8   60 48                 108
2043267 2043267 MA Middlesex   school 2506840 155   Lexington 250684001000 1550010 Joseph Estabrook   Regular School No Elementary KG 05 2019   grade_5 45 10 4 0   50     0   10   62 57                       119.0 45 10 4 0   50     0   10   62 57                 119
2043273 2043273 MA Middlesex   school 2506840 155   Lexington 250684000996 1550015 Fiske   Regular School No Elementary KG 05 2019   grade_5 47 0 2 0   30     0   11   38 52                       90.0 47 0 2 0   30     0   11   38 52                 90
2043279 2043279 MA Middlesex   school 2506840 155   Lexington 250684000998 1550030 Harrington   Regular School No Elementary KG 05 2019   grade_5 34 1 5 1   55     0   3   57 42                       99.0 34 1 5 1   55     0   3   57 42                 99
2043285 2043285 MA Middlesex   school 2506840 155   Lexington 250684000473 1550035 Maria Hastings   Regular School No Elementary KG 05 2019   grade_5 31 2 4 0   36     0   9   47 35                       82.0 31 2 4 0   36     0   9   47 35                 82
2043307 2043307 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No Elementary PK 08 2019   grade_5 44 5 4 0   5     0   2   25 35                       60.0 44 5 4 0   5     0   2   25 35                 60
2043312 2043312 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No Middle 04 08 2019   grade_5 45 6 14 0   1     0   5   34 37                       71.0 45 6 14 0   1     0   5   34 37                 71
2043322 2043322 MA Middlesex   school 2506960 158   Littleton 250696001013 1580015 Russell St Elementary   Regular School No Elementary 03 05 2019   grade_5 110 3 1 0   20     0   3   69 68                       137.0 110 3 1 0   20     0   3   69 68                 137
2043335 2043335 MA Hampden   school 2506990 159   Longmeadow 250699001016 1590005 Blueberry Hill   Regular School No Elementary KG 05 2019   grade_5 64 0 4 0   21     2   3   41 53                       94.0 64 0 4 0   21     2   3   41 53                 94
2043341 2043341 MA Hampden   school 2506990 159   Longmeadow 250699001017 1590010 Center   Regular School No Elementary KG 05 2019   grade_5 68 3 6 0   2     0   8   46 41                       87.0 68 3 6 0   2     0   8   46 41                 87
2043351 2043351 MA Hampden   school 2506990 159   Longmeadow 250699001022 1590025 Wolf Swamp Road   Regular School No Elementary PK 05 2019   grade_5 44 2 6 0   6     0   1   33 26                       59.0 44 2 6 0   6     0   1   33 26                 59
2040047 2040047 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2019   grade_5 111 16 14 2   11     0   14   87 81                       168.0 111 16 14 2   11     0   14   87 81                 168
2040051 2040051 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2019   grade_5 92 5 18 0   8     0   14   64 73                       137.0 92 5 18 0   8     0   14   64 73                 137
2040055 2040055 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No Middle 05 08 2019   grade_5 107 6 28 0   7     0   6   84 70                       154.0 107 6 28 0   7     0   6   84 70                 154
2043371 2043371 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Rogers STEM Academy   Regular School No Elementary KG 07 2019   grade_5 27 11 42 0   24     0   5   61 48                       109.0 27 11 42 0   24     0   5   61 48                 109

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