enrollments

Data source: Big Local News · About: Big Local

983 rows where grade = "grade_2", state = "MA" and year = 2015 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 983 ✖

grade ✖

  • grade_2 · 983 ✖
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
735661 735661 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No 1 01 04 2015   grade_2 133 1 5 1   3     0   0   78 65                       143 133 1 5 1   3     0   0   78 65                 143
735808 735808 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No 1 KG 05 2015   grade_2 46 5 4 0   10     0   3   32 36                       68 46 5 4 0   10     0   3   32 36                 68
735814 735814 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No 1 KG 05 2015   grade_2 54 1 1 0   7     0   5   41 27                       68 54 1 1 0   7     0   5   41 27                 68
735820 735820 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No 1 KG 05 2015   grade_2 48 4 3 0   9     1   1   39 27                       66 48 4 3 0   9     1   1   39 27                 66
735826 735826 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No 1 KG 05 2015   grade_2 44 3 5 0   12     0   4   41 27                       68 44 3 5 0   12     0   4   41 27                 68
735833 735833 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No 1 KG 05 2015   grade_2 33 1 4 0   4     0   2   18 26                       44 33 1 4 0   4     0   2   18 26                 44
735839 735839 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No 1 KG 05 2015   grade_2 55 3 6 1   12     1   4   45 37                       82 55 3 6 1   12     1   4   45 37                 82
735845 735845 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No 1 KG 05 2015   grade_2 47 0 6 0   11     0   5   32 37                       69 47 0 6 0   11     0   5   32 37                 69
738241 738241 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No 1 KG 05 2015   grade_2 41 7 33 0   5     0   3   48 41                       89 41 7 33 0   5     0   3   48 41                 89
738247 738247 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No 1 KG 05 2015   grade_2 57 3 11 0   16     0   8   61 34                       95 57 3 11 0   16     0   8   61 34                 95
738253 738253 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No 1 KG 05 2015   grade_2 71 11 11 0   6     0   4   51 52                       103 71 11 11 0   6     0   4   51 52                 103
738259 738259 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No 1 KG 05 2015   grade_2 40 2 64 0   0     0   4   43 67                       110 40 2 64 0   0     0   4   43 67                 110
738265 738265 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No 1 KG 05 2015   grade_2 74 4 6 0   8     0   4   52 44                       96 74 4 6 0   8     0   4   52 44                 96
738271 738271 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Mary E Stapleton Elementary   Regular School No 1 KG 05 2015   grade_2 49 8 13 0   6     0   3   33 46                       79 49 8 13 0   6     0   3   33 46                 79
738277 738277 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No 1 KG 05 2015   grade_2 57 9 29 0   2     0   8   52 53                       105 57 9 29 0   2     0   8   52 53                 105
738283 738283 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No 1 KG 05 2015   grade_2 63 7 18 0   0     0   2   44 46                       90 63 7 18 0   0     0   2   44 46                 90
738303 738303 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Jefferson Elementary   Regular School No 1 KG 05 2015   grade_2 66 1 0 0   6     0   0   44 29                       73 66 1 0 0   6     0   0   44 29                 73
738309 738309 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No 1 KG 05 2015   grade_2 75 0 1 0   5     0   0   45 36                       81 75 0 1 0   5     0   0   45 36                 81
738315 738315 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No 1 KG 05 2015   grade_2 52 0 3 0   8     0   1   38 26                       64 52 0 3 0   8     0   1   38 26                 64
738321 738321 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Oak Street Elementary   Regular School No 1 KG 05 2015   grade_2 79 3 4 0   4     0   1   52 39                       91 79 3 4 0   4     0   1   52 39                 91
738327 738327 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No 1 KG 05 2015   grade_2 48 2 3 0   6     0   2   34 27                       61 48 2 3 0   6     0   2   34 27                 61
738333 738333 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No 1 KG 05 2015   grade_2 33 1 2 1   1     0   1   25 14                       39 33 1 2 1   1     0   1   25 14                 39
738355 738355 MA Worcester   school 2505130 103   Gardner 250513002470 1030015 Helen Mae Sauter Elementary   Regular School No 1 01 03 2015   grade_2 84 2 13 0   1     0   11   62 49                       111 84 2 13 0   1     0   11   62 49                 111
738360 738360 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No 1 PK 02 2015   grade_2 71 6 22 0   0     0   10   54 55                       109 71 6 22 0   0     0   10   54 55                 109
738376 738376 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No 1 02 05 2015   grade_2 89 1 1 0   2     1   0   44 50                       94 89 1 1 0   2     1   0   44 50                 94
738389 738389 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No 1 KG 05 2015   grade_2 44 1 4 0   2     0   1   17 35                       52 44 1 4 0   2     0   1   17 35                 52
738395 738395 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No 1 KG 05 2015   grade_2 36 0 1 0   0     0   0   18 19                       37 36 0 1 0   0     0   0   18 19                 37
738402 738402 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No 1 KG 05 2015   grade_2 33 1 0 2   0     0   1   20 17                       37 33 1 0 2   0     0   1   20 17                 37
738408 738408 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No 1 KG 05 2015   grade_2 25 0 3 0   0     0   0   18 10                       28 25 0 3 0   0     0   0   18 10                 28
738414 738414 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 West Parish   Regular School No 1 KG 05 2015   grade_2 43 0 0 1   1     0   0   16 29                       45 43 0 0 1   1     0   0   16 29                 45
738433 738433 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No 1 02 06 2015   grade_2 92 1 4 0   10     0   5   59 53                       112 92 1 4 0   10     0   5   59 53                 112
738438 738438 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No 1 02 06 2015   grade_2 121 2 11 0   16     0   8   83 75                       158 121 2 11 0   16     0   8   83 75                 158
738456 738456 MA Hampshire   school 2505400 111   Granby 250540000791 1110010 West Street   Regular School No 1 PK 03 2015   grade_2 49 0 4 0   1     0   0   33 21                       54 49 0 4 0   1     0   0   33 21                 54
738467 738467 MA Franklin   school 2505490 114   Greenfield 250549002577 1140010 Federal Street School   Regular School No 1 KG 03 2015   grade_2 46 1 2 0   0     0   0   23 26                       49 46 1 2 0   0     0   0   23 26                 49
738471 738471 MA Franklin   school 2505490 114   Greenfield 250549000798 1140025 Discovery School at Four Corners   Regular School No 1 KG 03 2015   grade_2 42 0 6 0   0     0   0   24 24                       48 42 0 6 0   0     0   0   24 24                 48
738479 738479 MA Franklin   school 2505490 114   Greenfield 250549002578 1140035 Newton School   Regular School No 1 KG 03 2015   grade_2 44 1 9 0   1     0   0   28 27                       55 44 1 9 0   1     0   0   28 27                 55
738494 738494 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No 1 PK 06 2015   grade_2 33 0 6 0   0     0   1   24 16                       40 33 0 6 0   0     0   1   24 16                 40
738508 738508 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No 1 KG 06 2015   grade_2 85 0 0 0   0     0   1   34 52                       86 85 0 0 0   0     0   1   34 52                 86
738516 738516 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No 1 PK 06 2015   grade_2 6 0 0 0   0     0   0   4 2                       6 6 0 0 0   0     0   0   4 2                 6
738523 738523 MA Plymouth   school 2505790 122   Hanover 250579000827 1220004 Cedar Elementary   Regular School No 1 PK 04 2015   grade_2 73 3 2 0   3     0   0   38 43                       81 73 3 2 0   3     0   0   38 43                 81
738528 738528 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Center Elementary   Regular School No 1 KG 02 2015   grade_2 101 0 4 0   0     0   3   47 61                       108 101 0 4 0   0     0   3   47 61                 108
738543 738543 MA Worcester   school 2505880 125   Harvard 250588000839 1250005 Hildreth Elementary School   Regular School No 1 PK 05 2015   grade_2 55 2 6 0   7     0   2   41 31                       72 55 2 6 0   7     0   2   41 31                 72
738557 738557 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No 1 PK 06 2015   grade_2 36 0 0 0   0     0   0   18 18                       36 36 0 0 0   0     0   0   18 18                 36
738571 738571 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Bradford Elementary   Regular School No 1 KG 05 2015   grade_2 58 0 6 0   3     0   1   36 32                       68 58 0 6 0   3     0   1   36 32                 68
738578 738578 MA Essex   school 2505970 128   Haverhill 250597000296 1280026 Golden Hill   Regular School No 1 KG 04 2015   grade_2 83 7 22 2   2     0   1   70 47                       117 83 7 22 2   2     0   1   70 47                 117
738583 738583 MA Essex   school 2505970 128   Haverhill 250597000854 1280027 Greenleaf   Regular School No 1 KG 02 2015   grade_2 60 8 8 0   3     1   0   44 36                       80 60 8 8 0   3     1   0   44 36                 80
738599 738599 MA Essex   school 2505970 128   Haverhill 250597001169 1280054 Pentucket Lake Elementary   Regular School No 1 KG 04 2015   grade_2 68 4 16 0   3     1   2   52 42                       94 68 4 16 0   3     1   2   52 42                 94
738612 738612 MA Essex   school 2505970 128   Haverhill 250597000866 1280075 Tilton   Regular School No 1 KG 04 2015   grade_2 85 6 33 0   2     0   2   62 66                       128 85 6 33 0   2     0   2   62 66                 128
738617 738617 MA Essex   school 2505970 128   Haverhill 250597000867 1280080 Walnut Square   Regular School No 1 KG 02 2015   grade_2 51 0 3 0   1     1   0   29 27                       56 51 0 3 0   1     1   0   29 27                 56
738624 738624 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 KG 08 2015   grade_2 32 2 5 1   1     0   0   25 16                       41 32 2 5 1   1     0   0   25 16                 41
738639 738639 MA Plymouth   school 2506090 131   Hingham 250609002671 1310005 East Elementary School   Regular School No 1 PK 05 2015   grade_2 77 0 1 0   3     0   2   44 39                       83 77 0 1 0   3     0   2   44 39                 83
738645 738645 MA Plymouth   school 2506090 131   Hingham 250609000876 1310010 Wm L Foster Elementary   Regular School No 1 KG 05 2015   grade_2 71 0 1 0   1     0   1   40 34                       74 71 0 1 0   1     0   1   40 34                 74
738651 738651 MA Plymouth   school 2506090 131   Hingham 250609000873 1310019 Plymouth River   Regular School No 1 KG 05 2015   grade_2 58 1 1 0   2     0   2   24 40                       64 58 1 1 0   2     0   2   24 40                 64
738657 738657 MA Plymouth   school 2506090 131   Hingham 250609000874 1310020 South Elementary   Regular School No 1 KG 05 2015   grade_2 76 0 3 0   3     0   7   45 44                       89 76 0 3 0   3     0   7   45 44                 89
738672 738672 MA Norfolk   school 2506150 133   Holbrook 250615000880 1330018 John F Kennedy   Regular School No 1 PK 03 2015   grade_2 45 11 9 0   3     0   8   30 46                       76 45 11 9 0   3     0   8   30 46                 76
738687 738687 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No 1 PK 06 2015   grade_2 27 0 0 0   0     0   0   11 16                       27 27 0 0 0   0     0   0   11 16                 27
738698 738698 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No 1 PK 02 2015   grade_2 183 0 12 0   7     0   8   109 101                       210 183 0 12 0   7     0   8   109 101                 210
738711 738711 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No 1 KG 08 2015   grade_2 10 1 28 0   1     0   0   28 12                       40 10 1 28 0   1     0   0   28 12                 40
738721 738721 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No 1 PK 08 2015   grade_2 2 2 29 0   0     0   1   19 15                       34 2 2 29 0   0     0   1   19 15                 34
738735 738735 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No 1 KG 08 2015   grade_2 2 0 69 0   0     0   1   37 35                       72 2 0 69 0   0     0   1   37 35                 72
738744 738744 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No 1 KG 08 2015   grade_2 5 0 37 0   0     0   0   21 21                       42 5 0 37 0   0     0   0   21 21                 42
738753 738753 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No 1 KG 08 2015   grade_2 13 3 40 0   1     0   0   30 27                       57 13 3 40 0   1     0   0   30 27                 57
738762 738762 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No 1 KG 08 2015   grade_2 9 6 44 0   1     0   0   30 30                       60 9 6 44 0   1     0   0   30 30                 60
738771 738771 MA Hampden   school 2506270 137   Holyoke 250627002795 1370070 H.B. Lawrence School   Regular School No 1 KG 03 2015   grade_2 7 1 61 0   0     0   0   36 33                       69 7 1 61 0   0     0   0   36 33                 69
738784 738784 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No 1 KG 06 2015   grade_2 73 0 6 0   2     0   2   51 32                       83 73 0 6 0   2     0   2   51 32                 83
738798 738798 MA Middlesex   school 2506330 139   Hopkinton 250633000919 1390010 Elmwood   Regular School No 1 02 03 2015   grade_2 194 2 8 0   30     0   7   122 119                       241 194 2 8 0   30     0   7   122 119                 241
735859 735859 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No 1 KG 02 2015   grade_2 146 4 16 0   28     0   5   95 104                       199 146 4 16 0   28     0   5   95 104                 199
738813 738813 MA Middlesex   school 2506390 141   Hudson 250639000924 1410007 Mulready Elementary   Regular School No 1 PK 04 2015   grade_2 45 1 7 0   0     0   4   27 30                       57 45 1 7 0   0     0   4   27 30                 57
738818 738818 MA Middlesex   school 2506390 141   Hudson 250639000925 1410015 Forest Avenue Elementary   Regular School No 1 KG 04 2015   grade_2 56 0 5 0   3     0   2   32 34                       66 56 0 5 0   3     0   2   32 34                 66
738824 738824 MA Middlesex   school 2506390 141   Hudson 250639000922 1410030 C A Farley   Regular School No 1 PK 04 2015   grade_2 86 3 12 0   3     0   4   56 52                       108 86 3 12 0   3     0   4   56 52                 108
738839 738839 MA Plymouth   school 2506420 142   Hull 250642000932 1420015 Lillian M Jacobs   Regular School No 1 PK 05 2015   grade_2 65 0 0 0   0     0   0   31 34                       65 65 0 0 0   0     0   0   31 34                 65
738853 738853 MA Essex   school 2506480 144   Ipswich 250648000936 1440007 Paul F Doyon Memorial   Regular School No 1 PK 05 2015   grade_2 55 0 4 0   3     0   0   25 37                       62 55 0 4 0   3     0   0   25 37                 62
738860 738860 MA Essex   school 2506480 144   Ipswich 250648000939 1440015 Winthrop   Regular School No 1 PK 05 2015   grade_2 59 0 1 0   2     0   1   32 31                       63 59 0 1 0   2     0   1   32 31                 63
738874 738874 MA Plymouth   school 2506540 145   Kingston 250654000943 1450005 Kingston Elementary   Regular School No 1 KG 02 2015   grade_2 136 3 5 0   0     0   2   79 67                       146 136 3 5 0   0     0   2   79 67                 146
738882 738882 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No 1 PK 06 2015   grade_2 25 0 0 0   0     0   3   14 14                       28 25 0 0 0   0     0   3   14 14                 28
738893 738893 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 South Lawrence East Elementary School   Regular School No 1 01 04 2015   grade_2 6 2 134 0   4     0   3   79 70                       149 6 2 134 0   4     0   3   79 70                 149
738899 738899 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No 1 PK 04 2015   grade_2 3 2 131 0   0     0   0   67 69                       136 3 2 131 0   0     0   0   67 69                 136
738917 738917 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Robert Frost   Regular School No 1 KG 04 2015   grade_2 19 2 105 0   5     0   5   76 60                       136 19 2 105 0   5     0   5   76 60                 136
738923 738923 MA Essex   school 2506660 149   Lawrence 250666000958 1490020 James F Hennessey   Regular School No 1 PK 02 2015   grade_2 7 1 75 0   0     0   0   40 43                       83 7 1 75 0   0     0   0   40 43                 83
738925 738925 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No 1 01 04 2015   grade_2 4 1 116 0   1     0   0   56 66                       122 4 1 116 0   1     0   0   56 66                 122
738938 738938 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No 1 KG 05 2015   grade_2 1 0 74 0   0     0   0   39 36                       75 1 0 74 0   0     0   0   39 36                 75
738943 738943 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No 1 01 05 2015   grade_2 2 1 92 0   1     0   1   58 39                       97 2 1 92 0   1     0   1   58 39                 97
738952 738952 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Edward F. Parthum   Regular School No 1 KG 04 2015   grade_2 19 1 121 0   1     0   2   67 77                       144 19 1 121 0   1     0   2   67 77                 144
738956 738956 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No 1 01 05 2015   grade_2 0 2 74 0   0     0   1   37 40                       77 0 2 74 0   0     0   1   37 40                 77
738962 738962 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No 1 KG 08 2015   grade_2 5 0 75 0   3     0   2   38 47                       85 5 0 75 0   3     0   2   38 47                 85
739010 739010 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2015   grade_2 5 1 11 0   0     0   0   15 2                       17 5 1 11 0   0     0   0   15 2                 17
739029 739029 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No 1 PK 06 2015   grade_2 34 0 3 0   0     0   2   12 27                       39 34 0 3 0   0     0   2   12 27                 39
739046 739046 MA Worcester   school 2506720 151   Leicester 250672000974 1510010 Leicester Primary School   Regular School No 1 PK 02 2015   grade_2 93 7 1 2   5     0   0   63 45                       108 93 7 1 2   5     0   0   63 45                 108
739057 739057 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Morris   Regular School No 1 PK 05 2015   grade_2 42 0 2 0   3     0   2   31 18                       49 42 0 2 0   3     0   2   31 18                 49
739073 739073 MA Worcester   school 2506780 153   Leominster 250678000981 1530007 Fall Brook   Regular School No 1 KG 05 2015   grade_2 78 3 38 0   3     0   3   57 68                       125 78 3 38 0   3     0   3   57 68                 125
739079 739079 MA Worcester   school 2506780 153   Leominster 250678002637 1530010 Southeast School   Regular School No 1 KG 05 2015   grade_2 25 5 37 0   6     0   4   37 40                       77 25 5 37 0   6     0   4   37 40                 77
739085 739085 MA Worcester   school 2506780 153   Leominster 250678000985 1530025 Johnny Appleseed   Regular School No 1 KG 05 2015   grade_2 74 14 32 0   1     0   3   73 51                       124 74 14 32 0   1     0   3   73 51                 124
739091 739091 MA Worcester   school 2506780 153   Leominster 250678000988 1530030 Northwest   Regular School No 1 KG 05 2015   grade_2 60 6 44 1   3     0   2   53 63                       116 60 6 44 1   3     0   2   53 63                 116
739115 739115 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No 1 PK 06 2015   grade_2 11 0 2 0   0     0   1   6 8                       14 11 0 2 0   0     0   1   6 8                 14
739123 739123 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Bridge   Regular School No 1 KG 05 2015   grade_2 49 4 3 0   39     1   1   51 46                       97 49 4 3 0   39     1   1   51 46                 97
739129 739129 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Bowman   Regular School No 1 KG 05 2015   grade_2 48 8 1 1   43     0   9   55 55                       110 48 8 1 1   43     0   9   55 55                 110
739135 739135 MA Middlesex   school 2506840 155   Lexington 250684001000 1550010 Joseph Estabrook   Regular School No 1 KG 05 2015   grade_2 33 2 3 0   33     0   6   30 47                       77 33 2 3 0   33     0   6   30 47                 77
739141 739141 MA Middlesex   school 2506840 155   Lexington 250684000996 1550015 Fiske   Regular School No 1 KG 05 2015   grade_2 53 4 2 0   16     0   9   49 35                       84 53 4 2 0   16     0   9   49 35                 84
739147 739147 MA Middlesex   school 2506840 155   Lexington 250684000998 1550030 Harrington   Regular School No 1 KG 05 2015   grade_2 33 1 1 0   31     0   3   29 40                       69 33 1 1 0   31     0   3   29 40                 69
739153 739153 MA Middlesex   school 2506840 155   Lexington 250684000473 1550035 Maria Hastings   Regular School No 1 KG 05 2015   grade_2 39 3 4 0   26     0   7   38 41                       79 39 3 4 0   26     0   7   38 41                 79

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