enrollments

Data source: Big Local News · About: Big Local

884 rows where grade = "grade_5", state = "MA" and year = 2020 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 884 ✖

grade ✖

  • grade_5 · 884 ✖
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
1364790 1364790 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2020   grade_5 138 5 16 0   5     0   3   96 71 *                     167.0 138 5 16 0   5     0   3   96 71                 167
1364935 1364935 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2020   grade_5 51 2 1 0   10     0   5   41 28 *                     69.0 51 2 1 0   10     0   5   41 28                 69
1364941 1364941 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2020   grade_5 71 2 8 0   9     1   9   55 45 *                     100.0 71 2 8 0   9     1   9   55 45                 100
1364947 1364947 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2020   grade_5 60 1 4 0   10     0   6   42 39 *                     81.0 60 1 4 0   10     0   6   42 39                 81
1364953 1364953 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2020   grade_5 46 5 4 1   11     0   2   39 30 *                     69.0 46 5 4 1   11     0   2   39 30                 69
1364960 1364960 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2020   grade_5 27 5 5 0   5     0   4   20 26 *                     46.0 27 5 5 0   5     0   4   20 26                 46
1364966 1364966 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2020   grade_5 48 4 5 1   16     0   6   41 39 *                     80.0 48 4 5 1   16     0   6   41 39                 80
1364972 1364972 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2020   grade_5 47 2 5 0   5     0   3   30 32 *                     62.0 47 2 5 0   5     0   3   30 32                 62
1367330 1367330 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No Elementary KG 05 2020   grade_5 43 4 20 0   2     0   4   40 33 *                     73.0 43 4 20 0   2     0   4   40 33                 73
1367336 1367336 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2020   grade_5 23 2 57 0   3     0   0   46 39 *                     85.0 23 2 57 0   3     0   0   46 39                 85
1367342 1367342 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2020   grade_5 46 4 11 0   11     0   0   31 41 *                     72.0 46 4 11 0   11     0   0   31 41                 72
1367348 1367348 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2020   grade_5 69 6 6 0   10     0   3   52 42 *                     94.0 69 6 6 0   10     0   3   52 42                 94
1367354 1367354 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2020   grade_5 34 4 72 0   1     0   2   47 66 *                     113.0 34 4 72 0   1     0   2   47 66                 113
1367360 1367360 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No Elementary KG 05 2020   grade_5 59 5 10 0   3     0   3   35 45 *                     80.0 59 5 10 0   3     0   3   35 45                 80
1367366 1367366 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Mary E Stapleton Elementary   Regular School No Elementary KG 05 2020   grade_5 28 7 12 0   3     0   5   33 22 *                     55.0 28 7 12 0   3     0   5   33 22                 55
1367372 1367372 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No Elementary KG 05 2020   grade_5 37 18 35 0   1     0   7   51 47 *                     98.0 37 18 35 0   1     0   7   51 47                 98
1367378 1367378 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2020   grade_5 75 6 20 0   0     0   1   59 43 *                     102.0 75 6 20 0   0     0   1   59 43                 102
1367398 1367398 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Jefferson Elementary   Regular School No Elementary KG 05 2020   grade_5 60 1 3 0   7     0   1   42 30 *                     72.0 60 1 3 0   7     0   1   42 30                 72
1367404 1367404 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No Elementary KG 05 2020   grade_5 52 0 0 0   3     0   1   28 28 *                     56.0 52 0 0 0   3     0   1   28 28                 56
1367410 1367410 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No Elementary KG 05 2020   grade_5 51 0 4 0   5     0   2   32 30 *                     62.0 51 0 4 0   5     0   2   32 30                 62
1367416 1367416 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Oak Street Elementary   Regular School No Elementary KG 05 2020   grade_5 53 1 1 0   1     0   0   26 30 *                     56.0 53 1 1 0   1     0   0   26 30                 56
1367422 1367422 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No Elementary KG 05 2020   grade_5 54 2 4 0   6     1   0   35 32 *                     67.0 54 2 4 0   6     1   0   35 32                 67
1367428 1367428 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No Elementary KG 05 2020   grade_5 34 0 0 0   0     2   0   20 16 *                     36.0 34 0 0 0   0     2   0   20 16                 36
1367449 1367449 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No Middle 05 07 2020   grade_5 126 4 39 1   2     0   28   117 83 *                     200.0 126 4 39 1   2     0   28   117 83                 200
1367467 1367467 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2020   grade_5 80 2 2 0   1     0   2   48 39 *                     87.0 80 2 2 0   1     0   2   48 39                 87
1367480 1367480 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No Elementary KG 05 2020   grade_5 42 0 10 1   2     0   1   31 25 *                     56.0 42 0 10 1   2     0   1   31 25                 56
1367486 1367486 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No Elementary KG 05 2020   grade_5 32 0 6 0   0     0   2   27 13 *                     40.0 32 0 6 0   0     0   2   27 13                 40
1367493 1367493 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No Elementary KG 05 2020   grade_5 27 1 1 0   0     0   0   14 15 *                     29.0 27 1 1 0   0     0   0   14 15                 29
1367499 1367499 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No Elementary KG 05 2020   grade_5 25 1 6 0   0     0   0   11 21 *                     32.0 25 1 6 0   0     0   0   11 21                 32
1367505 1367505 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 West Parish   Regular School No Elementary KG 05 2020   grade_5 51 0 5 0   2     0   0   31 27 *                     58.0 51 0 5 0   2     0   0   31 27                 58
1374312 1374312 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_5 * * * *   *     *   *   * * *                     0.0                                             0
1367523 1367523 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No Elementary 02 06 2020   grade_5 112 0 9 0   13     0   6   71 69 *                     140.0 112 0 9 0   13     0   6   71 69                 140
1367528 1367528 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No Elementary 02 06 2020   grade_5 105 1 12 0   29     0   1   79 69 *                     148.0 105 1 12 0   29     0   1   79 69                 148
1367542 1367542 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 East Meadow   Regular School No Elementary PK 06 2020   grade_5 39 0 2 0   0     0   1   14 28 *                     42.0 39 0 2 0   0     0   1   14 28                 42
1367566 1367566 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No Middle 05 07 2020   grade_5 85 5 30 0   1     0   5   59 67 *                     126.0 85 5 30 0   1     0   5   59 67                 126
1367580 1367580 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No Elementary PK 06 2020   grade_5 25 3 2 0   1     1   1   16 17 *                     33.0 25 3 2 0   1     1   1   16 17                 33
1367593 1367593 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No Elementary KG 06 2020   grade_5 71 1 5 1   0     0   4   47 35 *                     82.0 71 1 5 1   0     0   4   47 35                 82
1367600 1367600 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2020   grade_5 6 0 0 0   0     0   0   3 3 *                     6.0 6 0 0 0   0     0   0   3 3                 6
1367608 1367608 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No Middle 05 08 2020   grade_5 192 6 3 0   3     0   3   105 102 *                     207.0 192 6 3 0   3     0   3   105 102                 207
1367622 1367622 MA Worcester   school 2505880 125   Harvard 250588000839 1250005 Hildreth Elementary School   Regular School No Elementary PK 05 2020   grade_5 56 1 3 0   9     0   3   38 34 *                     72.0 56 1 3 0   9     0   3   38 34                 72
1367636 1367636 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2020   grade_5 34 0 3 0   0     0   0   20 17 *                     37.0 34 0 3 0   0     0   0   20 17                 37
1367659 1367659 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Caleb Dustin Hunking School   Regular School No Elementary KG 08 2020   grade_5 115 8 39 0   2     0   5   91 78 *                     169.0 115 8 39 0   2     0   5   91 78                 169
1367667 1367667 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No Middle 05 08 2020   grade_5 69 10 83 0   5     0   6   91 82 *                     173.0 69 10 83 0   5     0   6   91 82                 173
1367681 1367681 MA Essex   school 2505970 128   Haverhill 250597000299 1280067 Silver Hill Elementary School   Regular School No Elementary KG 05 2020   grade_5 74 4 53 0   1     0   8   73 67 *                     140.0 74 4 53 0   1     0   8   73 67                 140
1367685 1367685 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_5 * * * *   *     *   *   4 * *                     5.0                         4                   5
1367700 1367700 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2020   grade_5 59 2 36 1   1     0   2   58 43 *                     101.0 59 2 36 1   1     0   2   58 43                 101
1367704 1367704 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 05 08 2020   grade_5 33 5 58 1   4     0   2   56 47 *                     103.0 33 5 58 1   4     0   2   56 47                 103
1367709 1367709 MA Essex   school 2505970 128   Haverhill 250597002906 1280105 Tilton Upper Middle School   Regular School No Middle 04 06 2020   grade_5 10 1 19 0   3     0   1   21 13 *                     34.0 10 1 19 0   3     0   1   21 13                 34
1367725 1367725 MA Plymouth   school 2506090 131   Hingham 250609002671 1310005 East Elementary School   Regular School No Elementary PK 05 2020   grade_5 66 2 1 0   0     0   1   41 29 *                     70.0 66 2 1 0   0     0   1   41 29                 70
1367731 1367731 MA Plymouth   school 2506090 131   Hingham 250609000876 1310010 Wm L Foster Elementary   Regular School No Elementary KG 05 2020   grade_5 62 1 3 0   0     0   2   36 32 *                     68.0 62 1 3 0   0     0   2   36 32                 68
1367737 1367737 MA Plymouth   school 2506090 131   Hingham 250609000873 1310019 Plymouth River   Regular School No Elementary KG 05 2020   grade_5 68 2 8 0   1     0   2   38 43 *                     81.0 68 2 8 0   1     0   2   38 43                 81
1367743 1367743 MA Plymouth   school 2506090 131   Hingham 250609000874 1310020 South Elementary   Regular School No Elementary KG 05 2020   grade_5 77 4 0 0   2     0   4   39 48 *                     87.0 77 4 0 0   2     0   4   39 48                 87
1367758 1367758 MA Norfolk   school 2506150 133   Holbrook 250615000880 1330018 John F Kennedy   Regular School No Elementary PK 05 2020   grade_5 52 19 11 0   3     0   5   49 41 *                     90.0 52 19 11 0   3     0   5   49 41                 90
1367773 1367773 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No Elementary PK 06 2020   grade_5 28 0 4 0   0     0   0   16 16 *                     32.0 28 0 4 0   0     0   0   16 16                 32
1367777 1367777 MA Middlesex   school 2506240 136   Holliston 250624001302 1360007 Miller School   Regular School No Elementary 03 05 2020   grade_5 175 3 12 0   28     0   9   110 117 *                     227.0 175 3 12 0   28     0   9   110 117                 227
1367795 1367795 MA Hampden   school 2506270 137   Holyoke 250627001178 1370003 Joseph Metcalf School   Regular School No Elementary PK 05 2020   grade_5 6 1 23 0   0     0   0   9 21 *                     30.0 6 1 23 0   0     0   0   9 21                 30
1367802 1367802 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2020   grade_5 15 0 33 0   3     0   2   26 27 *                     53.0 15 0 33 0   3     0   2   26 27                 53
1367813 1367813 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Middle 04 08 2020   grade_5 4 1 51 0   1     0   0   30 27 *                     57.0 4 1 51 0   1     0   0   30 27                 57
1367831 1367831 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No Elementary PK 05 2020   grade_5 9 2 44 0   0     0   1   28 28 *                     56.0 9 2 44 0   0     0   1   28 28                 56
1367838 1367838 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No Elementary PK 08 2020   grade_5 8 2 45 0   1     0   0   30 26 *                     56.0 8 2 45 0   1     0   0   30 26                 56
1367848 1367848 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No Elementary PK 08 2020   grade_5 4 1 42 0   0     0   0   27 20 *                     47.0 4 1 42 0   0     0   0   27 20                 47
1367856 1367856 MA Hampden   school 2506270 137   Holyoke 250627002895 1370075 Veritas Prep Holyoke   Regular School No Middle 05 06 2020   grade_5 4 5 92 0   1     0   1   67 36 *                     103.0 4 5 92 0   1     0   1   67 36                 103
1367871 1367871 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No Elementary KG 06 2020   grade_5 66 0 5 0   1     0   1   35 38 *                     73.0 66 0 5 0   1     0   1   35 38                 73
1367885 1367885 MA Middlesex   school 2506330 139   Hopkinton 250633001180 1390015 Hopkins Elementary School   Regular School No Elementary 04 05 2020   grade_5 203 1 7 2   61     1   13   149 139 *                     288.0 203 1 7 2   61     1   13   149 139                 288
1364986 1364986 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 David Mindess   Regular School No Elementary 03 05 2020   grade_5 156 7 26 4   30     0   4   113 114 *                     227.0 156 7 26 4   30     0   4   113 114                 227
1367911 1367911 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 David J. Quinn Middle School   Regular School No Middle 05 07 2020   grade_5 161 8 31 0   5     0   2   99 108 *                     207.0 161 8 31 0   5     0   2   99 108                 207
1367925 1367925 MA Plymouth   school 2506420 142   Hull 250642000932 1420015 Lillian M Jacobs   Regular School No Elementary PK 05 2020   grade_5 61 0 0 0   2     0   1   32 32 *                     64.0 61 0 0 0   2     0   1   32 32                 64
1367938 1367938 MA Essex   school 2506480 144   Ipswich 250648000936 1440007 Paul F Doyon Memorial   Regular School No Elementary KG 05 2020   grade_5 59 0 2 0   4     0   0   36 29 *                     65.0 59 0 2 0   4     0   0   36 29                 65
1367945 1367945 MA Essex   school 2506480 144   Ipswich 250648000939 1440015 Winthrop   Regular School No Elementary PK 05 2020   grade_5 43 2 4 0   1     0   5   23 32 *                     55.0 43 2 4 0   1     0   5   23 32                 55
1367958 1367958 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston Intermediate   Regular School No Elementary 03 06 2020   grade_5 137 3 5 1   0     0   1   76 71 *                     147.0 137 3 5 1   0     0   1   76 71                 147
1367969 1367969 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 South Lawrence East Elementary School   Regular School No Elementary 01 05 2020   grade_5 4 1 131 0   3     0   0   84 54 *                     139.0 4 1 131 0   3     0   0   84 54                 139
1367979 1367979 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Middle 03 08 2020   grade_5 4 0 74 0   1     0   0   33 46 *                     79.0 4 0 74 0   1     0   0   33 46                 79
1367983 1367983 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2020   grade_5 1 1 128 0   0     0   0   74 56 *                     130.0 1 1 128 0   0     0   0   74 56                 130
1368000 1368000 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2020   grade_5 6 1 117 0   0     0   0   63 61 *                     124.0 6 1 117 0   0     0   0   63 61                 124
1368004 1368004 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2020   grade_5 7 0 130 0   1     0   0   64 74 *                     138.0 7 0 130 0   1     0   0   64 74                 138
1368012 1368012 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No Elementary 01 05 2020   grade_5 1 0 98 0   0     0   0   55 44 *                     99.0 1 0 98 0   0     0   0   55 44                 99
1368017 1368017 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2020   grade_5 3 0 84 0   1     0   0   50 37 *                     88.0 3 0 84 0   1     0   0   50 37                 88
1368030 1368030 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2020   grade_5 1 0 56 0   0     0   0   30 26 *                     57.0 1 0 56 0   0     0   0   30 26                 57
1368036 1368036 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2020   grade_5 6 0 58 0   1     0   0   31 34 *                     65.0 6 0 58 0   1     0   0   31 34                 65
1368051 1368051 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2020   grade_5 13 0 116 0   4     0   1   67 67 *                     134.0 13 0 116 0   4     0   1   67 67                 134
1368060 1368060 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other KG 12 2020   grade_5 0 0 11 0   0     0   0   6 5 *                     11.0 0 0 11 0   0     0   0   6 5                 11
1368075 1368075 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No Elementary PK 06 2020   grade_5 36 1 9 0   2     0   1   33 16 *                     49.0 36 1 9 0   2     0   1   33 16                 49
1368090 1368090 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No Middle 05 08 2020   grade_5 79 4 10 0   3     0   5   52 49 *                     101.0 79 4 10 0   3     0   5   52 49                 101
1368104 1368104 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Morris   Regular School No Elementary PK 05 2020   grade_5 39 0 3 0   1     0   1   20 24 *                     44.0 39 0 3 0   1     0   1   20 24                 44
1368119 1368119 MA Worcester   school 2506780 153   Leominster 250678000981 1530007 Fall Brook   Regular School No Elementary KG 05 2020   grade_5 62 7 37 0   1     0   5   61 51 *                     112.0 62 7 37 0   1     0   5   61 51                 112
1368125 1368125 MA Worcester   school 2506780 153   Leominster 250678002637 1530010 Frances Drake School   Regular School No Elementary KG 05 2020   grade_5 44 2 38 0   3     0   8   47 48 *                     95.0 44 2 38 0   3     0   8   47 48                 95
1368131 1368131 MA Worcester   school 2506780 153   Leominster 250678000985 1530025 Johnny Appleseed   Regular School No Elementary KG 05 2020   grade_5 73 12 42 0   6     0   5   64 74 *                     138.0 73 12 42 0   6     0   5   64 74                 138
1368137 1368137 MA Worcester   school 2506780 153   Leominster 250678000988 1530030 Northwest   Regular School No Elementary KG 05 2020   grade_5 50 8 60 0   3     0   13   52 82 *                     134.0 50 8 60 0   3     0   13   52 82                 134
1368163 1368163 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No Elementary PK 06 2020   grade_5 23 0 0 0   0     0   0   16 7 *                     23.0 23 0 0 0   0     0   0   16 7                 23
1368171 1368171 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Bridge   Regular School No Elementary KG 05 2020   grade_5 44 7 6 0   51     0   3   65 46 *                     111.0 44 7 6 0   51     0   3   65 46                 111
1368177 1368177 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Bowman   Regular School No Elementary KG 05 2020   grade_5 43 5 6 0   33     0   14   53 48 *                     101.0 43 5 6 0   33     0   14   53 48                 101
1368183 1368183 MA Middlesex   school 2506840 155   Lexington 250684001000 1550010 Joseph Estabrook   Regular School No Elementary KG 05 2020   grade_5 38 5 3 0   45     0   10   56 45 *                     101.0 38 5 3 0   45     0   10   56 45                 101
1368189 1368189 MA Middlesex   school 2506840 155   Lexington 250684000996 1550015 Fiske   Regular School No Elementary KG 05 2020   grade_5 52 6 7 0   33     0   8   56 50 *                     106.0 52 6 7 0   33     0   8   56 50                 106
1368195 1368195 MA Middlesex   school 2506840 155   Lexington 250684000998 1550030 Harrington   Regular School No Elementary KG 05 2020   grade_5 43 0 2 1   27     0   5   40 38 *                     78.0 43 0 2 1   27     0   5   40 38                 78
1368201 1368201 MA Middlesex   school 2506840 155   Lexington 250684000473 1550035 Maria Hastings   Regular School No Elementary KG 05 2020   grade_5 40 2 1 0   31     0   5   41 38 *                     79.0 40 2 1 0   31     0   5   41 38                 79
1368223 1368223 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No Elementary PK 08 2020   grade_5 38 8 8 0   0     0   4   29 29 *                     58.0 38 8 8 0   0     0   4   29 29                 58
1368228 1368228 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No Middle 04 08 2020   grade_5 31 4 17 0   0     2   9   31 32 *                     63.0 31 4 17 0   0     2   9   31 32                 63
1368238 1368238 MA Middlesex   school 2506960 158   Littleton 250696001013 1580015 Russell St Elementary   Regular School No Elementary 03 05 2020   grade_5 111 2 4 1   18     1   1   73 65 *                     138.0 111 2 4 1   18     1   1   73 65                 138
1368251 1368251 MA Hampden   school 2506990 159   Longmeadow 250699001016 1590005 Blueberry Hill   Regular School No Elementary KG 05 2020   grade_5 51 1 2 0   7     0   2   33 30 *                     63.0 51 1 2 0   7     0   2   33 30                 63
1368257 1368257 MA Hampden   school 2506990 159   Longmeadow 250699001017 1590010 Center   Regular School No Elementary KG 05 2020   grade_5 59 0 3 0   3     0   1   42 24 *                     66.0 59 0 3 0   3     0   1   42 24                 66

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