enrollments

Data source: Big Local News · About: Big Local

982 rows where grade = "grade_2", state = "MA" and year = 2017 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 982 ✖

grade ✖

  • grade_2 · 982 ✖
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
1121950 1121950 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No Elementary 01 04 2017   grade_2 147 3 11 0   3     0   0   89 75                       164 147 3 11 0   3     0   0   89 75                 164
1122126 1122126 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2017   grade_2 49 3 1 0   10     0   6   40 29                       69 49 3 1 0   10     0   6   40 29                 69
1122133 1122133 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2017   grade_2 68 1 8 0   7     1   8   48 45                       93 68 1 8 0   7     1   8   48 45                 93
1122140 1122140 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2017   grade_2 61 1 4 0   8     0   5   37 42                       79 61 1 4 0   8     0   5   37 42                 79
1122147 1122147 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2017   grade_2 47 4 6 1   14     0   4   46 30                       76 47 4 6 1   14     0   4   46 30                 76
1122156 1122156 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2017   grade_2 27 3 6 0   7     0   1   19 25                       44 27 3 6 0   7     0   1   19 25                 44
1122163 1122163 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2017   grade_2 55 4 6 1   13     1   6   46 40                       86 55 4 6 1   13     1   6   46 40                 86
1122170 1122170 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2017   grade_2 44 0 4 0   8     0   2   31 27                       58 44 0 4 0   8     0   2   31 27                 58
1124962 1124962 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No Elementary KG 02 2017   grade_2 49 5 13 0   7     0   5   47 32                       79 49 5 13 0   7     0   5   47 32                 79
1124966 1124966 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2017   grade_2 25 4 49 0   4     0   1   42 41                       83 25 4 49 0   4     0   1   42 41                 83
1124973 1124973 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2017   grade_2 46 4 9 0   13     0   0   30 42                       72 46 4 9 0   13     0   0   30 42                 72
1124980 1124980 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2017   grade_2 73 7 11 0   7     0   3   57 44                       101 73 7 11 0   7     0   3   57 44                 101
1124987 1124987 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2017   grade_2 30 3 81 0   1     0   2   47 70                       117 30 3 81 0   1     0   2   47 70                 117
1124994 1124994 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No Elementary KG 05 2017   grade_2 66 5 4 0   4     0   2   38 43                       81 66 5 4 0   4     0   2   38 43                 81
1125001 1125001 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Mary E Stapleton Elementary   Regular School No Elementary KG 05 2017   grade_2 30 9 11 0   2     0   3   27 28                       55 30 9 11 0   2     0   3   27 28                 55
1125008 1125008 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No Elementary KG 05 2017   grade_2 42 13 27 0   2     0   4   41 47                       88 42 13 27 0   2     0   4   41 47                 88
1125015 1125015 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2017   grade_2 72 9 21 0   0     0   1   52 51                       103 72 9 21 0   0     0   1   52 51                 103
1125041 1125041 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Jefferson Elementary   Regular School No Elementary KG 05 2017   grade_2 53 1 1 0   7     0   1   37 26                       63 53 1 1 0   7     0   1   37 26                 63
1125048 1125048 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No Elementary KG 05 2017   grade_2 47 0 0 0   3     0   1   24 27                       51 47 0 0 0   3     0   1   24 27                 51
1125055 1125055 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No Elementary KG 05 2017   grade_2 46 0 3 0   4     0   2   26 29                       55 46 0 3 0   4     0   2   26 29                 55
1125062 1125062 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Oak Street Elementary   Regular School No Elementary KG 05 2017   grade_2 53 1 2 0   1     0   0   27 30                       57 53 1 2 0   1     0   0   27 30                 57
1125069 1125069 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No Elementary KG 05 2017   grade_2 54 0 2 0   4     1   0   33 28                       61 54 0 2 0   4     1   0   33 28                 61
1125076 1125076 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No Elementary KG 05 2017   grade_2 40 0 0 0   0     0   0   22 18                       40 40 0 0 0   0     0   0   22 18                 40
1125098 1125098 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No Elementary 02 04 2017   grade_2 129 6 30 1   0     0   24   103 87                       190 129 6 30 1   0     0   24   103 87                 190
1125125 1125125 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2017   grade_2 83 2 2 0   1     0   1   48 41                       89 83 2 2 0   1     0   1   48 41                 89
1125141 1125141 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No Elementary KG 05 2017   grade_2 47 0 9 1   2     0   1   36 24                       60 47 0 9 1   2     0   1   36 24                 60
1125148 1125148 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No Elementary KG 05 2017   grade_2 33 0 4 0   0     0   2   26 13                       39 33 0 4 0   0     0   2   26 13                 39
1125157 1125157 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No Elementary KG 05 2017   grade_2 34 0 0 0   0     0   0   17 17                       34 34 0 0 0   0     0   0   17 17                 34
1125164 1125164 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No Elementary KG 05 2017   grade_2 24 0 4 0   0     0   0   12 16                       28 24 0 4 0   0     0   0   12 16                 28
1125171 1125171 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 West Parish   Regular School No Elementary KG 05 2017   grade_2 49 0 6 0   2     0   0   29 28                       57 49 0 6 0   2     0   0   29 28                 57
1125188 1125188 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_2 * * * *   *     *   *   * *                       *                                              
1125208 1125208 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No Elementary 02 06 2017   grade_2 112 0 8 0   9     0   6   68 67                       135 112 0 8 0   9     0   6   68 67                 135
1125214 1125214 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No Elementary 02 06 2017   grade_2 90 1 11 0   26     0   1   68 61                       129 90 1 11 0   26     0   1   68 61                 129
1125235 1125235 MA Hampshire   school 2505400 111   Granby 250540000791 1110010 West Street   Regular School No Elementary PK 03 2017   grade_2 40 0 1 1   0     0   2   15 29                       44 40 0 1 1   0     0   2   15 29                 44
1125249 1125249 MA Franklin   school 2505490 114   Greenfield 250549002577 1140010 Federal Street School   Regular School No Elementary KG 04 2017   grade_2 29 2 7 0   1     0   2   17 24                       41 29 2 7 0   1     0   2   17 24                 41
1125255 1125255 MA Franklin   school 2505490 114   Greenfield 250549000798 1140025 Discovery School at Four Corners   Regular School No Elementary KG 04 2017   grade_2 39 0 6 0   0     0   0   18 27                       45 39 0 6 0   0     0   0   18 27                 45
1125262 1125262 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_2 * * * *   *     *   *   * *                       *                                              
1125276 1125276 MA Franklin   school 2505490 114   Greenfield 250549002578 1140035 Newton School   Regular School No Elementary KG 04 2017   grade_2 26 3 8 0   0     0   3   17 23                       40 26 3 8 0   0     0   3   17 23                 40
1125294 1125294 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No Elementary PK 06 2017   grade_2 23 1 1 0   0     1   0   10 16                       26 23 1 1 0   0     1   0   10 16                 26
1125309 1125309 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No Elementary KG 06 2017   grade_2 72 1 2 1   0     0   3   42 37                       79 72 1 2 1   0     0   3   42 37                 79
1125317 1125317 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2017   grade_2 * * * *   *     *   *   2 1                       *                         2 1                  
1125325 1125325 MA Plymouth   school 2505790 122   Hanover 250579000827 1220004 Cedar Elementary   Regular School No Elementary PK 04 2017   grade_2 66 1 1 0   1     0   0   35 34                       69 66 1 1 0   1     0   0   35 34                 69
1125331 1125331 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Center Elementary   Regular School No Elementary KG 02 2017   grade_2 114 0 1 0   2     0   2   60 59                       119 114 0 1 0   2     0   2   60 59                 119
1125349 1125349 MA Worcester   school 2505880 125   Harvard 250588000839 1250005 Hildreth Elementary School   Regular School No Elementary PK 05 2017   grade_2 52 1 3 0   6     0   0   35 27                       62 52 1 3 0   6     0   0   35 27                 62
1125365 1125365 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2017   grade_2 30 0 3 0   0     0   0   19 14                       33 30 0 3 0   0     0   0   19 14                 33
1125382 1125382 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Bradford Elementary   Regular School No Elementary KG 05 2017   grade_2 48 1 8 0   1     0   1   32 27                       59 48 1 8 0   1     0   1   32 27                 59
1125391 1125391 MA Essex   school 2505970 128   Haverhill 250597000296 1280026 Golden Hill   Regular School No Elementary KG 04 2017   grade_2 73 4 62 0   4     0   6   70 79                       149 73 4 62 0   4     0   6   70 79                 149
1125397 1125397 MA Essex   school 2505970 128   Haverhill 250597000854 1280027 Greenleaf   Regular School No Elementary KG 02 2017   grade_2 56 2 25 0   1     0   3   42 45                       87 56 2 25 0   1     0   3   42 45                 87
1125418 1125418 MA Essex   school 2505970 128   Haverhill 250597001169 1280054 Pentucket Lake Elementary   Regular School No Elementary KG 04 2017   grade_2 43 5 38 0   1     0   2   52 37                       89 43 5 38 0   1     0   2   52 37                 89
1125422 1125422 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_2 * * * *   *     *   *   4 1                       *                         4 1                  
1125430 1125430 MA Essex   school 2505970 128   Haverhill 250597000866 1280075 Tilton   Regular School No Elementary 01 04 2017   grade_2 50 2 84 2   0     0   2   86 54                       140 50 2 84 2   0     0   2   86 54                 140
1125436 1125436 MA Essex   school 2505970 128   Haverhill 250597000867 1280080 Walnut Square   Regular School No Elementary KG 02 2017   grade_2 38 0 7 0   1     0   1   30 17                       47 38 0 7 0   1     0   1   30 17                 47
1125444 1125444 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_2 17 2 26 0   0     0   2   25 22                       47 17 2 26 0   0     0   2   25 22                 47
1125460 1125460 MA Plymouth   school 2506090 131   Hingham 250609002671 1310005 East Elementary School   Regular School No Elementary PK 05 2017   grade_2 71 1 1 0   0     0   1   41 33                       74 71 1 1 0   0     0   1   41 33                 74
1125467 1125467 MA Plymouth   school 2506090 131   Hingham 250609000876 1310010 Wm L Foster Elementary   Regular School No Elementary KG 05 2017   grade_2 52 1 2 0   0     0   1   27 29                       56 52 1 2 0   0     0   1   27 29                 56
1125474 1125474 MA Plymouth   school 2506090 131   Hingham 250609000873 1310019 Plymouth River   Regular School No Elementary KG 05 2017   grade_2 71 3 5 0   1     0   2   36 46                       82 71 3 5 0   1     0   2   36 46                 82
1125481 1125481 MA Plymouth   school 2506090 131   Hingham 250609000874 1310020 South Elementary   Regular School No Elementary KG 05 2017   grade_2 76 3 1 0   2     0   2   33 51                       84 76 3 1 0   2     0   2   33 51                 84
1125498 1125498 MA Norfolk   school 2506150 133   Holbrook 250615000880 1330018 John F Kennedy   Regular School No Elementary PK 03 2017   grade_2 52 15 14 0   2     0   4   46 41                       87 52 15 14 0   2     0   4   46 41                 87
1125515 1125515 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No Elementary PK 06 2017   grade_2 26 0 3 0   0     0   0   16 13                       29 26 0 3 0   0     0   0   16 13                 29
1125528 1125528 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No Elementary PK 02 2017   grade_2 174 3 9 0   24     0   9   106 113                       219 174 3 9 0   24     0   9   106 113                 219
1125542 1125542 MA Hampden   school 2506270 137   Holyoke 250627001178 1370003 Joseph Metcalf School   Regular School No Elementary PK 02 2017   grade_2 10 1 22 0   0     0   0   13 20                       33 10 1 22 0   0     0   0   13 20                 33
1125547 1125547 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2017   grade_2 17 0 32 0   2     0   1   25 27                       52 17 0 32 0   2     0   1   25 27                 52
1125558 1125558 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No Elementary PK 08 2017   grade_2 1 2 38 0   1     0   0   26 16                       42 1 2 38 0   1     0   0   26 16                 42
1125574 1125574 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No Elementary KG 08 2017   grade_2 3 2 55 0   0     0   1   35 26                       61 3 2 55 0   0     0   1   35 26                 61
1125585 1125585 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No Elementary PK 08 2017   grade_2 6 3 41 0   0     0   0   25 25                       50 6 3 41 0   0     0   0   25 25                 50
1125595 1125595 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No Elementary KG 08 2017   grade_2 8 2 41 0   1     0   0   25 27                       52 8 2 41 0   1     0   0   25 27                 52
1125606 1125606 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No Elementary PK 08 2017   grade_2 5 2 45 0   0     0   2   35 19                       54 5 2 45 0   0     0   2   35 19                 54
1125616 1125616 MA Hampden   school 2506270 137   Holyoke 250627002795 1370070 H.B. Lawrence School   Regular School No Elementary KG 03 2017   grade_2 6 0 60 0   1     1   1   41 28                       69 6 0 60 0   1     1   1   41 28                 69
1125632 1125632 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No Elementary KG 06 2017   grade_2 61 1 4 0   0     0   2   37 31                       68 61 1 4 0   0     0   2   37 31                 68
1125650 1125650 MA Middlesex   school 2506330 139   Hopkinton 250633000919 1390010 Elmwood   Regular School No Elementary 02 03 2017   grade_2 195 2 7 1   36     1   8   136 114                       250 195 2 7 1   36     1   8   136 114                 250
1122188 1122188 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2017   grade_2 159 5 15 4   32     0   4   104 115                       219 159 5 15 4   32     0   4   104 115                 219
1125668 1125668 MA Middlesex   school 2506390 141   Hudson 250639000924 1410007 Mulready Elementary   Regular School No Elementary PK 04 2017   grade_2 33 2 3 0   1     0   2   19 22                       41 33 2 3 0   1     0   2   19 22                 41
1125674 1125674 MA Middlesex   school 2506390 141   Hudson 250639000925 1410015 Forest Avenue Elementary   Regular School No Elementary KG 04 2017   grade_2 58 1 7 0   1     0   1   33 35                       68 58 1 7 0   1     0   1   33 35                 68
1125681 1125681 MA Middlesex   school 2506390 141   Hudson 250639000922 1410030 C A Farley   Regular School No Elementary PK 04 2017   grade_2 64 0 8 0   3     0   0   40 35                       75 64 0 8 0   3     0   0   40 35                 75
1125698 1125698 MA Plymouth   school 2506420 142   Hull 250642000932 1420015 Lillian M Jacobs   Regular School No Elementary PK 05 2017   grade_2 59 1 0 0   1     0   1   34 28                       62 59 1 0 0   1     0   1   34 28                 62
1125715 1125715 MA Essex   school 2506480 144   Ipswich 250648000936 1440007 Paul F Doyon Memorial   Regular School No Elementary PK 05 2017   grade_2 53 0 2 0   4     0   0   32 27                       59 53 0 2 0   4     0   0   32 27                 59
1125723 1125723 MA Essex   school 2506480 144   Ipswich 250648000939 1440015 Winthrop   Regular School No Elementary PK 05 2017   grade_2 43 1 4 0   0     0   4   23 29                       52 43 1 4 0   0     0   4   23 29                 52
1125739 1125739 MA Plymouth   school 2506540 145   Kingston 250654000943 1450005 Kingston Elementary   Regular School No Elementary KG 02 2017   grade_2 133 2 3 1   0     0   0   67 72                       139 133 2 3 1   0     0   0   67 72                 139
1125749 1125749 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No Elementary PK 06 2017   grade_2 18 1 2 0   0     0   0   6 15                       21 18 1 2 0   0     0   0   6 15                 21
1125764 1125764 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 South Lawrence East Elementary School   Regular School No Elementary KG 05 2017   grade_2 7 1 123 0   6     0   0   81 56                       137 7 1 123 0   6     0   0   81 56                 137
1125771 1125771 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No Elementary KG 04 2017   grade_2 1 0 118 0   0     0   0   57 62                       119 1 0 118 0   0     0   0   57 62                 119
1125792 1125792 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Robert Frost   Regular School No Elementary KG 04 2017   grade_2 14 2 113 0   2     0   1   61 71                       132 14 2 113 0   2     0   1   61 71                 132
1125799 1125799 MA Essex   school 2506660 149   Lawrence 250666000958 1490020 James F Hennessey   Regular School No Elementary PK 02 2017   grade_2 4 2 88 0   2     0   0   47 49                       96 4 2 88 0   2     0   0   47 49                 96
1125802 1125802 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No Elementary 01 04 2017   grade_2 6 4 124 0   0     0   1   67 68                       135 6 4 124 0   0     0   1   67 68                 135
1125818 1125818 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No Elementary KG 05 2017   grade_2 2 2 90 0   0     0   0   50 44                       94 2 2 90 0   0     0   0   50 44                 94
1125824 1125824 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2017   grade_2 6 0 95 0   1     0   1   62 41                       103 6 0 95 0   1     0   1   62 41                 103
1125835 1125835 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Edward F. Parthum   Regular School No Elementary KG 04 2017   grade_2 12 2 112 0   2     0   0   59 69                       128 12 2 112 0   2     0   0   59 69                 128
1125840 1125840 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2017   grade_2 1 0 75 0   0     0   0   45 31                       76 1 0 75 0   0     0   0   45 31                 76
1125847 1125847 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2017   grade_2 4 0 62 0   1     0   0   27 40                       67 4 0 62 0   1     0   0   27 40                 67
1125879 1125879 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_2 1 0 9 0   0     0   0   6 4                       10 1 0 9 0   0     0   0   6 4                 10
1125899 1125899 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No Elementary PK 06 2017   grade_2 37 0 8 0   2     0   0   32 15                       47 37 0 8 0   2     0   0   32 15                 47
1125919 1125919 MA Worcester   school 2506720 151   Leicester 250672000974 1510010 Leicester Primary School   Regular School No Elementary PK 02 2017   grade_2 79 5 7 2   3     0   1   47 50                       97 79 5 7 2   3     0   1   47 50                 97
1125933 1125933 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Morris   Regular School No Elementary PK 05 2017   grade_2 35 0 3 0   3     0   0   25 16                       41 35 0 3 0   3     0   0   25 16                 41
1125952 1125952 MA Worcester   school 2506780 153   Leominster 250678000981 1530007 Fall Brook   Regular School No Elementary KG 05 2017   grade_2 68 6 53 0   2     0   6   67 68                       135 68 6 53 0   2     0   6   67 68                 135
1125959 1125959 MA Worcester   school 2506780 153   Leominster 250678002637 1530010 Frances Drake School   Regular School No Elementary KG 05 2017   grade_2 34 5 32 0   3     0   6   43 37                       80 34 5 32 0   3     0   6   43 37                 80
1125966 1125966 MA Worcester   school 2506780 153   Leominster 250678000985 1530025 Johnny Appleseed   Regular School No Elementary KG 05 2017   grade_2 82 8 36 1   6     0   6   63 76                       139 82 8 36 1   6     0   6   63 76                 139
1125973 1125973 MA Worcester   school 2506780 153   Leominster 250678000988 1530030 Northwest   Regular School No Elementary KG 05 2017   grade_2 66 3 46 0   4     0   10   58 71                       129 66 3 46 0   4     0   10   58 71                 129
1126006 1126006 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No Elementary PK 06 2017   grade_2 22 1 0 0   1     0   0   18 6                       24 22 1 0 0   1     0   0   18 6                 24
1126016 1126016 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Bridge   Regular School No Elementary KG 05 2017   grade_2 47 7 3 0   42     0   0   54 45                       99 47 7 3 0   42     0   0   54 45                 99
1126023 1126023 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Bowman   Regular School No Elementary KG 05 2017   grade_2 45 3 2 0   32     0   13   49 46                       95 45 3 2 0   32     0   13   49 46                 95

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