enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 954 ✖

grade ✖

  • grade_4 · 954 ✖
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade ▼ year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2039812 2039812 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Elementary 03 04 2019   grade_4 143 3 13 0   4     0   2   93 72                       165.0 143 3 13 0   4     0   2   93 72                 165
2039830 2039830 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2019   grade_4 95 0 7 0   0     0   2   48 56                       104.0 95 0 7 0   0     0   2   48 56                 104
2039840 2039840 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2019   grade_4 52 0 11 0   1     0   1   38 27                       65.0 52 0 11 0   1     0   1   38 27                 65
2039845 2039845 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2019   grade_4 66 4 2 0   1     0   2   51 24                       75.0 66 4 2 0   1     0   2   51 24                 75
2039850 2039850 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2019   grade_4 44 2 7 0   5     0   3   33 28                       61.0 44 2 7 0   5     0   3   33 28                 61
2039855 2039855 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2019   grade_4 46 5 5 0   3     0   0   34 25                       59.0 46 5 5 0   3     0   0   34 25                 59
2039870 2039870 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2019   grade_4 71 1 7 0   2     0   7   48 40                       88.0 71 1 7 0   2     0   7   48 40                 88
2039876 2039876 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2019   grade_4 78 1 6 1   2     0   1   49 40                       89.0 78 1 6 1   2     0   1   49 40                 89
2040025 2040025 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2019   grade_4 56 2 17 0   3     0   1   40 39                       79.0 56 2 17 0   3     0   1   40 39                 79
2040031 2040031 MA Bristol   school 2502190 16   Attleboro 250219000098 160035 Thomas Willett Elementary School   Regular School No Elementary KG 04 2019   grade_4 64 8 16 0   3     0   10   53 48                       101.0 64 8 16 0   3     0   10   53 48                 101
2040036 2040036 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No Elementary KG 04 2019   grade_4 59 4 10 0   0     0   11   36 48                       84.0 59 4 10 0   0     0   11   36 48                 84
2040041 2040041 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Hill-Roberts Elementary School   Regular School No Elementary KG 04 2019   grade_4 61 4 10 0   5     0   2   48 34                       82.0 61 4 10 0   5     0   2   48 34                 82
2040046 2040046 MA Bristol   school 2502190 16   Attleboro 250219001294 160050 Peter Thacher Elementary School   Regular School No Elementary KG 04 2019   grade_4 47 7 14 0   3     0   8   44 35                       79.0 47 7 14 0   3     0   8   44 35                 79
2040184 2040184 MA Middlesex   school 2502490 26   Belmont 250249000148 260005 Winn Brook   Regular School No Elementary KG 04 2019   grade_4 61 0 3 0   24     0   6   51 43                       94.0 61 0 3 0   24     0   6   51 43                 94
2040189 2040189 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Mary Lee Burbank   Regular School No Elementary KG 04 2019   grade_4 61 3 3 0   19     0   7   45 48                       93.0 61 3 3 0   19     0   7   45 48                 93
2040194 2040194 MA Middlesex   school 2502490 26   Belmont 250249000144 260015 Daniel Butler   Regular School No Elementary KG 04 2019   grade_4 48 3 8 0   26     0   5   52 38                       90.0 48 3 8 0   26     0   5   52 38                 90
2040200 2040200 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No Elementary PK 04 2019   grade_4 98 2 0 0   14     0   6   63 57                       120.0 98 2 0 0   14     0   6   63 57                 120
2040214 2040214 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No Elementary PK 04 2019   grade_4 80 0 1 0   0     0   4   41 44                       85.0 80 0 1 0   0     0   4   41 44                 85
2040231 2040231 MA Essex   school 2502640 30   Beverly 250264000167 300010 Centerville Elementary   Regular School No Elementary KG 04 2019   grade_4 45 2 15 0   0     0   4   37 29                       66.0 45 2 15 0   0     0   4   37 29                 66
2040236 2040236 MA Essex   school 2502640 30   Beverly 250264000168 300015 Cove Elementary   Regular School No Elementary KG 04 2019   grade_4 61 3 8 0   0     0   2   34 40                       74.0 61 3 8 0   0     0   2   34 40                 74
2040241 2040241 MA Essex   school 2502640 30   Beverly 250264000169 300033 Hannah Elementary   Regular School No Elementary KG 04 2019   grade_4 64 0 11 0   2     0   4   38 43                       81.0 64 0 11 0   2     0   4   38 43                 81
2040246 2040246 MA Essex   school 2502640 30   Beverly 250264000173 300040 North Beverly Elementary   Regular School No Elementary KG 04 2019   grade_4 46 2 10 1   0     0   0   30 29                       59.0 46 2 10 1   0     0   0   30 29                 59
2040251 2040251 MA Essex   school 2502640 30   Beverly 250264000175 300055 Ayers/Ryal Side School   Regular School No Elementary KG 04 2019   grade_4 69 3 13 0   7     0   1   53 40                       93.0 69 3 13 0   7     0   1   53 40                 93
2041116 2041116 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No Elementary PK 04 2019   grade_4 75 1 7 1   0     0   3   49 38                       87.0 75 1 7 1   0     0   3   49 38                 87
2041121 2041121 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Peebles Elementary School   Regular School No Elementary KG 04 2019   grade_4 70 1 5 0   1     0   2   34 45                       79.0 70 1 5 0   1     0   2   34 45                 79
2041611 2041611 MA Middlesex   school 2503510 56   Chelmsford 250351001300 560005 Center Elementary School   Regular School No Elementary KG 04 2019   grade_4 60 4 8 0   13     1   3   34 55                       89.0 60 4 8 0   13     1   3   34 55                 89
2041616 2041616 MA Middlesex   school 2503510 56   Chelmsford 250351000480 560015 South Row   Regular School No Elementary KG 04 2019   grade_4 55 1 5 0   14     0   5   51 29                       80.0 55 1 5 0   14     0   5   51 29                 80
2041621 2041621 MA Middlesex   school 2503510 56   Chelmsford 250351000474 560025 Charles D Harrington   Regular School No Elementary KG 04 2019   grade_4 71 5 6 0   19     0   4   63 42                       105.0 71 5 6 0   19     0   4   63 42                 105
2041626 2041626 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Byam School   Regular School No Elementary KG 04 2019   grade_4 77 0 9 1   10     0   8   52 53                       105.0 77 0 9 1   10     0   8   52 53                 105
2041645 2041645 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No Elementary 01 04 2019   grade_4 16 4 104 1   3     0   0   73 55                       128.0 16 4 104 1   3     0   0   73 55                 128
2041649 2041649 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No Elementary 01 04 2019   grade_4 14 8 126 0   1     0   2   77 74                       151.0 14 8 126 0   1     0   2   77 74                 151
2041658 2041658 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2019   grade_4 11 15 117 0   2     0   4   74 75                       149.0 11 15 117 0   2     0   4   74 75                 149
2041766 2041766 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton Elementary   Regular School No Elementary PK 04 2019   grade_4 99 5 39 0   1     0   5   73 76                       149.0 99 5 39 0   1     0   5   73 76                 149
2042019 2042019 MA Hampshire   school 2504590 86   Easthampton 250459000611 860005 Center School   Regular School No Elementary KG 04 2019   grade_4 31 1 8 1   2     0   1   22 22                       44.0 31 1 8 1   2     0   1   22 22                 44
2042025 2042025 MA Hampshire   school 2504590 86   Easthampton 250459000613 860010 Maple   Regular School No Elementary PK 04 2019   grade_4 41 1 2 0   0     0   0   25 19                       44.0 41 1 2 0   0     0   0   25 19                 44
2042030 2042030 MA Hampshire   school 2504590 86   Easthampton 250459002466 860020 Neil A Pepin   Regular School No Elementary KG 04 2019   grade_4 27 1 9 0   2     0   3   18 24                       42.0 27 1 9 0   2     0   3   18 24                 42
2042288 2042288 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No Elementary KG 04 2019   grade_4 39 5 1 1   1     0   2   20 29                       49.0 39 5 1 1   1     0   2   20 29                 49
2042294 2042294 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No Elementary PK 04 2019   grade_4 44 2 2 0   1     0   4   34 19                       53.0 44 2 2 0   1     0   4   34 19                 53
2042299 2042299 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No Elementary KG 04 2019   grade_4 74 4 6 0   1     0   4   45 44                       89.0 74 4 6 0   1     0   4   45 44                 89
2042304 2042304 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No Elementary KG 04 2019   grade_4 71 2 3 0   2     0   4   37 45                       82.0 71 2 3 0   2     0   4   37 45                 82
2042319 2042319 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No Elementary PK 04 2019   grade_4 38 4 48 0   2     1   7   53 47                       100.0 38 4 48 0   2     1   7   53 47                 100
2042325 2042325 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No Elementary PK 04 2019   grade_4 42 10 61 0   3     0   12   58 70                       128.0 42 10 61 0   3     0   12   58 70                 128
2042335 2042335 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No Elementary PK 04 2019   grade_4 29 8 73 0   9     0   10   55 74                       129.0 29 8 73 0   9     0   10   55 74                 129
2042376 2042376 MA Norfolk   school 2504950 99   Foxborough 250495000710 990015 Mabelle M Burrell   Regular School No Elementary PK 04 2019   grade_4 33 1 2 0   3     0   1   22 18                       40.0 33 1 2 0   3     0   1   22 18                 40
2042381 2042381 MA Norfolk   school 2504950 99   Foxborough 250495000724 990020 Vincent M Igo Elementary   Regular School No Elementary KG 04 2019   grade_4 61 4 6 2   6     0   4   46 37                       83.0 61 4 6 2   6     0   4   46 37                 83
2042386 2042386 MA Norfolk   school 2504950 99   Foxborough 250495000864 990050 Charles Taylor Elementary   Regular School No Elementary KG 04 2019   grade_4 34 2 4 0   2     0   1   18 25                       43.0 34 2 4 0   2     0   1   18 25                 43
2042401 2042401 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No Elementary KG 04 2019   grade_4 41 2 10 0   3     0   4   35 25                       60.0 41 2 10 0   3     0   4   35 25                 60
2042516 2042516 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No Elementary 02 04 2019   grade_4 127 2 34 1   0     0   28   113 79                       192.0 127 2 34 1   0     0   28   113 79                 192
2042628 2042628 MA Franklin   school 2505490 114   Greenfield 250549002577 1140010 Federal Street School   Regular School No Elementary KG 04 2019   grade_4 29 2 13 0   1     0   2   24 23                       47.0 29 2 13 0   1     0   2   24 23                 47
2042633 2042633 MA Franklin   school 2505490 114   Greenfield 250549000798 1140025 Discovery School at Four Corners   Regular School No Elementary KG 04 2019   grade_4 36 0 5 0   1     0   0   16 26                       42.0 36 0 5 0   1     0   0   16 26                 42
2042638 2042638 MA Franklin   school 2505490 114   Greenfield 250549002578 1140035 Newton School   Regular School No Elementary KG 04 2019   grade_4 30 2 16 0   0     0   3   26 25                       51.0 30 2 16 0   0     0   3   26 25                 51
2042680 2042680 MA Plymouth   school 2505790 122   Hanover 250579000827 1220004 Cedar Elementary   Regular School No Elementary PK 04 2019   grade_4 74 2 1 0   1     0   0   40 38                       78.0 74 2 1 0   1     0   0   40 38                 78
2042685 2042685 MA Plymouth   school 2505790 122   Hanover 250579000832 1220015 Sylvester   Regular School No Elementary 03 04 2019   grade_4 117 1 2 0   2     0   4   64 62                       126.0 117 1 2 0   2     0   4   64 62                 126
2042730 2042730 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Bradford Elementary   Regular School No Elementary KG 04 2019   grade_4 50 4 28 0   1     0   1   50 34                       84.0 50 4 28 0   1     0   1   50 34                 84
2042735 2042735 MA Essex   school 2505970 128   Haverhill 250597000296 1280026 Golden Hill   Regular School No Elementary 01 04 2019   grade_4 59 5 58 0   4     0   6   64 68                       132.0 59 5 58 0   4     0   6   64 68                 132
2042758 2042758 MA Essex   school 2505970 128   Haverhill 250597001169 1280054 Pentucket Lake Elementary   Regular School No Elementary KG 04 2019   grade_4 71 5 41 1   2     0   2   68 54                       122.0 71 5 41 1   2     0   2   68 54                 122
2042782 2042782 MA Essex   school 2505970 128   Haverhill 250597000866 1280075 Tilton   Regular School No Elementary KG 04 2019   grade_4 13 1 27 0   0     0   1   22 20                       42.0 13 1 27 0   0     0   1   22 20                 42
2042876 2042876 MA Hampden   school 2506270 137   Holyoke 250627001178 1370003 Joseph Metcalf School   Regular School No Elementary PK 04 2019   grade_4 6 1 22 0   0     0   0   11 18                       29.0 6 1 22 0   0     0   0   11 18                 29
2042892 2042892 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No Elementary PK 04 2019   grade_4 0 2 42 0   1     0   0   27 18                       45.0 0 2 42 0   1     0   0   27 18                 45
2042979 2042979 MA Middlesex   school 2506390 141   Hudson 250639000924 1410007 Mulready Elementary   Regular School No Elementary PK 04 2019   grade_4 32 2 7 0   1     0   1   18 25                       43.0 32 2 7 0   1     0   1   18 25                 43
2042984 2042984 MA Middlesex   school 2506390 141   Hudson 250639000925 1410015 Forest Avenue Elementary   Regular School No Elementary KG 04 2019   grade_4 57 1 7 0   1     0   1   29 38                       67.0 57 1 7 0   1     0   1   29 38                 67
2042990 2042990 MA Middlesex   school 2506390 141   Hudson 250639000922 1410030 C A Farley   Regular School No Elementary PK 04 2019   grade_4 65 3 11 0   3     0   0   45 37                       82.0 65 3 11 0   3     0   0   45 37                 82
2043058 2043058 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No Elementary KG 04 2019   grade_4 1 1 132 0   0     0   0   75 59                       134.0 1 1 132 0   0     0   0   75 59                 134
2043075 2043075 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Robert Frost   Regular School No Elementary KG 04 2019   grade_4 12 1 110 0   4     0   1   60 68                       128.0 12 1 110 0   4     0   1   60 68                 128
2043083 2043083 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No Elementary 01 04 2019   grade_4 8 6 127 0   0     0   0   71 70                       141.0 8 6 127 0   0     0   0   71 70                 141
2043109 2043109 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Edward F. Parthum   Regular School No Elementary PK 04 2019   grade_4 5 0 135 0   1     0   0   63 78                       141.0 5 0 135 0   1     0   0   63 78                 141
2043365 2043365 MA Middlesex   school 2507020 160   Lowell 250702000067 1600002 Dr Gertrude Bailey   Regular School No Elementary PK 04 2019   grade_4 40 5 20 0   29     0   6   56 44                       100.0 40 5 20 0   29     0   6   56 44                 100
2043379 2043379 MA Middlesex   school 2507020 160   Lowell 250702000477 1600010 Joseph McAvinnue   Regular School No Elementary PK 04 2019   grade_4 23 5 50 0   19     0   1   46 52                       98.0 23 5 50 0   19     0   1   46 52                 98
2043385 2043385 MA Middlesex   school 2507020 160   Lowell 250702001033 1600015 Greenhalge   Regular School No Elementary PK 04 2019   grade_4 19 7 41 0   13     0   5   40 45                       85.0 19 7 41 0   13     0   5   40 45                 85
2043401 2043401 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2019   grade_4 11 5 36 0   45     0   3   51 49                       100.0 11 5 36 0   45     0   3   51 49                 100
2043413 2043413 MA Middlesex   school 2507020 160   Lowell 250702001029 1600030 Charles W Morey   Regular School No Elementary PK 04 2019   grade_4 20 5 13 0   59     0   3   49 51                       100.0 20 5 13 0   59     0   3   49 51                 100
2043419 2043419 MA Middlesex   school 2507020 160   Lowell 250702001044 1600036 Pawtucketville Memorial   Regular School No Elementary PK 04 2019   grade_4 38 9 27 0   27     0   5   60 46                       106.0 38 9 27 0   27     0   5   60 46                 106
2043431 2043431 MA Middlesex   school 2507020 160   Lowell 250702001048 1600050 John J Shaughnessy   Regular School No Elementary PK 04 2019   grade_4 29 7 29 0   27     0   4   44 52                       96.0 29 7 29 0   27     0   4   44 52                 96
2043437 2043437 MA Middlesex   school 2507020 160   Lowell 250702001051 1600055 Washington   Regular School No Elementary PK 04 2019   grade_4 7 2 11 0   16     0   4   20 20                       40.0 7 2 11 0   16     0   4   20 20                 40
2043443 2043443 MA Middlesex   school 2507020 160   Lowell 250702000088 1600075 S Christa McAuliffe Elementary   Regular School No Elementary PK 04 2019   grade_4 32 8 48 0   4     0   5   48 49                       97.0 32 8 48 0   4     0   5   48 49                 97
2043449 2043449 MA Middlesex   school 2507020 160   Lowell 250702000092 1600080 Charlotte M Murkland Elementary   Regular School No Elementary PK 04 2019   grade_4 15 2 33 0   45     0   6   60 41                       101.0 15 2 33 0   45     0   6   60 41                 101
2043687 2043687 MA Essex   school 2507140 164   Lynnfield 250714001089 1640010 Huckleberry Hill   Regular School No Elementary KG 04 2019   grade_4 65 0 10 0   7     0   2   37 47                       84.0 65 0 10 0   7     0   2   37 47                 84
2043692 2043692 MA Essex   school 2507140 164   Lynnfield 250714001093 1640020 Summer Street   Regular School No Elementary KG 04 2019   grade_4 85 1 6 0   5     0   2   56 43                       99.0 85 1 6 0   5     0   2   56 43                 99
2043802 2043802 MA Middlesex   school 2507320 170   Marlborough 250732001130 1700008 Francis J Kane   Regular School No Elementary KG 04 2019   grade_4 51 5 76 0   2     0   7   65 76                       141.0 51 5 76 0   2     0   7   65 76                 141
2043807 2043807 MA Middlesex   school 2507320 170   Marlborough 250732001135 1700025 Richer   Regular School No Elementary KG 04 2019   grade_4 40 4 60 0   0     0   6   56 54                       110.0 40 4 60 0   0     0   6   56 54                 110
2043812 2043812 MA Middlesex   school 2507320 170   Marlborough 250732001631 1700030 Charles Jaworek School   Regular School No Elementary KG 04 2019   grade_4 68 4 69 0   4     0   3   76 72                       148.0 68 4 69 0   4     0   3   76 72                 148
2043960 2043960 MA Norfolk   school 2507590 177   Medway 250759001015 1770015 Burke/Memorial Elementary School   Regular School No Elementary 02 04 2019   grade_4 149 1 7 0   2     0   7   81 85                       166.0 149 1 7 0   2     0   7   81 85                 166
2044120 2044120 MA Norfolk   school 2507920 187   Millis 250792001252 1870005 Clyde F Brown   Regular School No Elementary PK 04 2019   grade_4 91 1 5 0   1     0   5   50 53                       103.0 91 1 5 0   1     0   5   50 53                 103
2044168 2044168 MA Hampden   school 2508040 191   Monson 250804002589 1910025 Quarry Hill Community School   Regular School No Elementary PK 04 2019   grade_4 67 1 0 0   0     1   2   36 35                       71.0 67 1 0 0   0     1   2   36 35                 71
2044204 2044204 MA Middlesex   school 2508340 198   Natick 250834001291 1980005 Bennett-Hemenway   Regular School No Elementary KG 04 2019   grade_4 87 2 4 1   18     1   6   67 52                       119.0 87 2 4 1   18     1   6   67 52                 119
2044209 2044209 MA Middlesex   school 2508340 198   Natick 250834001292 1980010 Brown   Regular School No Elementary KG 04 2019   grade_4 64 0 9 1   17     0   6   47 50                       97.0 64 0 9 1   17     0   6   47 50                 97
2044214 2044214 MA Middlesex   school 2508340 198   Natick 250834001298 1980031 Johnson   Regular School No Elementary KG 04 2019   grade_4 35 0 1 0   1     0   2   25 14                       39.0 35 0 1 0   1     0   2   25 14                 39
2044219 2044219 MA Middlesex   school 2508340 198   Natick 250834001299 1980035 Lilja Elementary   Regular School No Elementary KG 04 2019   grade_4 68 2 6 0   8     0   6   42 48                       90.0 68 2 6 0   8     0   6   42 48                 90
2044224 2044224 MA Middlesex   school 2508340 198   Natick 250834001301 1980043 Memorial   Regular School No Elementary KG 04 2019   grade_4 88 0 5 0   2     0   5   56 44                       100.0 88 0 5 0   2     0   5   56 44                 100
2044729 2044729 MA Worcester   school 2508940 214   Northbridge 250894001447 2140001 W Edward Balmer   Regular School No Elementary 02 04 2019   grade_4 149 2 11 0   0     0   11   80 93                       173.0 149 2 11 0   0     0   11   80 93                 173
2044884 2044884 MA Worcester   school 2509270 226   Oxford 250927001481 2260005 Clara Barton   Regular School No Elementary 02 04 2019   grade_4 103 4 16 0   2     0   7   70 62                       132.0 103 4 16 0   2     0   7   70 62                 132
2045191 2045191 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Lincoln-Hancock Community School   Regular School No Elementary KG 04 2019   grade_4 37 9 14 1   31     0   1   61 32                       93.0 37 9 14 1   31     0   1   61 32                 93
2045202 2045202 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Clifford H Marshall Elementary   Regular School No Elementary KG 04 2019   grade_4 27 12 15 0   47     5   2   48 60                       108.0 27 12 15 0   47     5   2   48 60                 108
2045419 2045419 MA Plymouth   school 2510170 251   Rockland 251017001640 2510020 Memorial Park   Regular School No Elementary KG 04 2019   grade_4 39 1 9 0   1     0   4   33 21                       54.0 39 1 9 0   1     0   4   33 21                 54
2045424 2045424 MA Plymouth   school 2510170 251   Rockland 251017001641 2510025 R Stewart Esten   Regular School No Elementary KG 04 2019   grade_4 54 9 11 0   0     0   0   42 32                       74.0 54 9 11 0   0     0   0   42 32                 74
2045429 2045429 MA Plymouth   school 2510170 251   Rockland 251017001708 2510060 Jefferson Elementary School   Regular School No Elementary KG 04 2019   grade_4 45 0 3 0   1     0   3   16 36                       52.0 45 0 3 0   1     0   3   16 36                 52
2045660 2045660 MA Worcester   school 2510770 271   Shrewsbury 251077001713 2710015 Calvin Coolidge   Regular School No Elementary KG 04 2019   grade_4 46 1 15 0   28     0   5   43 52                       95.0 46 1 15 0   28     0   5   43 52                 95
2045664 2045664 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2019   grade_4 72 6 11 2   96     0   10   99 98                       197.0 72 6 11 2   96     0   10   99 98                 197
2045669 2045669 MA Worcester   school 2510770 271   Shrewsbury 251077001719 2710025 Walter J Paton   Regular School No Elementary KG 04 2019   grade_4 64 1 8 0   19     0   5   52 45                       97.0 64 1 8 0   19     0   5   52 45                 97
2045676 2045676 MA Worcester   school 2510770 271   Shrewsbury 251077001718 2710035 Spring Street   Regular School No Elementary KG 04 2019   grade_4 60 4 12 0   24     0   5   54 51                       105.0 60 4 12 0   24     0   5   54 51                 105

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