enrollments

Data source: Big Local News · About: Big Local

6,679 rows where grade = "grade_4" and state = "MA" sorted by ccd_school_high_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_4 · 6,679 ✖
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
2230207 2230207 MA Suffolk   school   35   Boston   350652               2018   grade_4 * * * *   *     *   *   * *                       0.0                                             0
735663 735663 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No 1 01 04 2015   grade_4 162 6 0 1   3     0   0   81 91                       172 162 6 0 1   3     0   0   81 91                 172
735678 735678 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No 1 PK 04 2015   grade_4 113 0 0 0   0     0   0   59 54                       113 113 0 0 0   0     0   0   59 54                 113
735688 735688 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No 1 KG 04 2015   grade_4 53 2 8 0   1     0   0   32 32                       64 53 2 8 0   1     0   0   32 32                 64
735693 735693 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No 1 KG 04 2015   grade_4 68 1 6 0   5     0   1   41 40                       81 68 1 6 0   5     0   1   41 40                 81
735698 735698 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No 1 KG 04 2015   grade_4 68 1 6 0   4     0   3   41 41                       82 68 1 6 0   4     0   3   41 41                 82
735703 735703 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No 1 KG 04 2015   grade_4 69 3 4 0   5     0   3   46 38                       84 69 3 4 0   5     0   3   46 38                 84
735719 735719 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No 1 PK 04 2015   grade_4 64 4 3 0   0     0   3   42 32                       74 64 4 3 0   0     0   3   42 32                 74
735725 735725 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No 1 PK 04 2015   grade_4 82 2 3 0   0     0   4   44 47                       91 82 2 3 0   0     0   4   44 47                 91
735874 735874 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No 1 KG 04 2015   grade_4 52 0 21 1   1     0   4   37 42                       79 52 0 21 1   1     0   4   37 42                 79
735880 735880 MA Bristol   school 2502190 16   Attleboro 250219000098 160035 Thomas Willett Elementary School   Regular School No 1 KG 04 2015   grade_4 44 3 8 0   3     0   5   34 29                       63 44 3 8 0   3     0   5   34 29                 63
735885 735885 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No 1 KG 04 2015   grade_4 63 6 10 0   4     0   4   49 38                       87 63 6 10 0   4     0   4   49 38                 87
735890 735890 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Hill-Roberts Elementary School   Regular School No 1 KG 04 2015   grade_4 61 4 5 0   4     0   8   41 41                       82 61 4 5 0   4     0   8   41 41                 82
735895 735895 MA Bristol   school 2502190 16   Attleboro 250219001294 160050 Peter Thacher Elementary School   Regular School No 1 KG 04 2015   grade_4 51 6 17 0   3     0   8   54 31                       85 51 6 17 0   3     0   8   54 31                 85
736011 736011 MA Norfolk   school 2502460 25   Bellingham 250246000140 250009 Clara Macy Elementary   Regular School No 1 KG 04 2015   grade_4 36 0 1 0   4     0   1   20 22                       42 36 0 1 0   4     0   1   20 22                 42
736016 736016 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 South Elementary   Regular School No 1 KG 04 2015   grade_4 93 1 4 0   2     0   0   47 53                       100 93 1 4 0   2     0   0   47 53                 100
736021 736021 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No 1 KG 04 2015   grade_4 33 3 2 0   1     0   0   23 16                       39 33 3 2 0   1     0   0   23 16                 39
736039 736039 MA Middlesex   school 2502490 26   Belmont 250249000148 260005 Winn Brook   Regular School No 1 KG 04 2015   grade_4 64 2 3 0   14     0   4   45 42                       87 64 2 3 0   14     0   4   45 42                 87
736044 736044 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Mary Lee Burbank   Regular School No 1 KG 04 2015   grade_4 47 1 2 0   15     0   6   40 31                       71 47 1 2 0   15     0   6   40 31                 71
736049 736049 MA Middlesex   school 2502490 26   Belmont 250249000144 260015 Daniel Butler   Regular School No 1 KG 04 2015   grade_4 43 8 2 0   17     0   4   41 33                       74 43 8 2 0   17     0   4   41 33                 74
736055 736055 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No 1 PK 04 2015   grade_4 76 3 0 0   9     1   5   37 57                       94 76 3 0 0   9     1   5   37 57                 94
736069 736069 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No 1 PK 04 2015   grade_4 86 1 0 0   0     0   2   47 42                       89 86 1 0 0   0     0   2   47 42                 89
736269 736269 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No 1 PK 04 2015   grade_4 0 0 6 0   0     0   0   2 4                       6 0 0 6 0   0     0   0   2 4                 6
736586 736586 MA Suffolk   school 2502790 35   Boston 250279000303 350266 Dr. William Henderson Lower   Regular School No 1 PK 04 2015   grade_4 7 9 5 0   2     0   0   14 9                       23 7 9 5 0   2     0   0   14 9                 23
736969 736969 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No 1 PK 04 2015   grade_4 70 0 2 0   2     0   5   37 42                       79 70 0 2 0   2     0   5   37 42                 79
736974 736974 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Peebles Elementary School   Regular School No 1 KG 04 2015   grade_4 83 1 1 0   4     0   4   42 51                       93 83 1 1 0   4     0   4   42 51                 93
737462 737462 MA Middlesex   school 2503510 56   Chelmsford 250351001300 560005 Center Elementary School   Regular School No 1 KG 04 2015   grade_4 71 0 1 0   12     0   3   37 50                       87 71 0 1 0   12     0   3   37 50                 87
737467 737467 MA Middlesex   school 2503510 56   Chelmsford 250351000480 560015 South Row   Regular School No 1 KG 04 2015   grade_4 61 0 1 0   15     0   2   38 41                       79 61 0 1 0   15     0   2   38 41                 79
737472 737472 MA Middlesex   school 2503510 56   Chelmsford 250351000474 560025 Charles D Harrington   Regular School No 1 KG 04 2015   grade_4 83 3 3 0   18     0   2   54 55                       109 83 3 3 0   18     0   2   54 55                 109
737477 737477 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Byam School   Regular School No 1 KG 04 2015   grade_4 82 2 5 0   12     0   3   54 50                       104 82 2 5 0   12     0   3   54 50                 104
737495 737495 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No 1 01 04 2015   grade_4 10 11 92 0   1     0   1   63 52                       115 10 11 92 0   1     0   1   63 52                 115
737499 737499 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No 1 01 04 2015   grade_4 8 9 88 2   3     0   3   57 56                       113 8 9 88 2   3     0   3   57 56                 113
737503 737503 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No 1 01 04 2015   grade_4 12 5 124 0   2     0   0   75 68                       143 12 5 124 0   2     0   0   75 68                 143
737507 737507 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No 1 01 04 2015   grade_4 13 7 122 1   5     0   0   75 73                       148 13 7 122 1   5     0   0   75 73                 148
737870 737870 MA Hampshire   school 2504590 86   Easthampton 250459000611 860005 Center School   Regular School No 1 KG 04 2015   grade_4 17 0 3 0   2     0   0   11 11                       22 17 0 3 0   2     0   0   11 11                 22
737876 737876 MA Hampshire   school 2504590 86   Easthampton 250459000613 860010 Maple   Regular School No 1 PK 04 2015   grade_4 33 1 3 0   0     0   0   20 17                       37 33 1 3 0   0     0   0   20 17                 37
737881 737881 MA Hampshire   school 2504590 86   Easthampton 250459002466 860020 Neil A Pepin   Regular School No 1 KG 04 2015   grade_4 39 1 3 0   1     0   0   23 21                       44 39 1 3 0   1     0   0   23 21                 44
737964 737964 MA Middlesex   school 2504770 93   Everett 250477002118 930015 Webster School   Regular School No 1 PK 04 2015   grade_4 7 3 7 0   3     0   0   10 10                       20 7 3 7 0   3     0   0   10 10                 20
738132 738132 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No 1 PK 04 2015   grade_4 41 6 2 0   1     0   1   23 28                       51 41 6 2 0   1     0   1   23 28                 51
738138 738138 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No 1 PK 04 2015   grade_4 55 5 5 1   0     0   3   29 40                       69 55 5 5 1   0     0   3   29 40                 69
738143 738143 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No 1 KG 04 2015   grade_4 101 4 3 0   0     0   5   58 55                       113 101 4 3 0   0     0   5   58 55                 113
738148 738148 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No 1 KG 04 2015   grade_4 70 0 7 0   3     1   4   43 42                       85 70 0 7 0   3     1   4   43 42                 85
738163 738163 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No 1 PK 04 2015   grade_4 31 6 51 0   4     0   8   50 50                       100 31 6 51 0   4     0   8   50 50                 100
738168 738168 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No 1 KG 04 2015   grade_4 54 7 63 0   7     0   8   79 60                       139 54 7 63 0   7     0   8   79 60                 139
738178 738178 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No 1 PK 04 2015   grade_4 42 5 69 0   8     0   5   59 70                       129 42 5 69 0   8     0   5   59 70                 129
738218 738218 MA Norfolk   school 2504950 99   Foxborough 250495000710 990015 Mabelle M Burrell   Regular School No 1 PK 04 2015   grade_4 49 1 2 0   0     0   4   34 22                       56 49 1 2 0   0     0   4   34 22                 56
738223 738223 MA Norfolk   school 2504950 99   Foxborough 250495000724 990020 Vincent M Igo Elementary   Regular School No 1 KG 04 2015   grade_4 59 2 1 2   2     0   0   31 35                       66 59 2 1 2   2     0   0   31 35                 66
738228 738228 MA Norfolk   school 2504950 99   Foxborough 250495000864 990050 Charles Taylor Elementary   Regular School No 1 KG 04 2015   grade_4 59 0 0 0   1     0   0   21 39                       60 59 0 0 0   1     0   0   21 39                 60
738525 738525 MA Plymouth   school 2505790 122   Hanover 250579000827 1220004 Cedar Elementary   Regular School No 1 PK 04 2015   grade_4 63 0 0 0   2     0   0   33 32                       65 63 0 0 0   2     0   0   33 32                 65
738530 738530 MA Plymouth   school 2505790 122   Hanover 250579000832 1220015 Sylvester   Regular School No 1 03 04 2015   grade_4 99 0 2 0   2     0   0   54 49                       103 99 0 2 0   2     0   0   54 49                 103
738580 738580 MA Essex   school 2505970 128   Haverhill 250597000296 1280026 Golden Hill   Regular School No 1 KG 04 2015   grade_4 56 1 36 0   3     0   2   49 49                       98 56 1 36 0   3     0   2   49 49                 98
738601 738601 MA Essex   school 2505970 128   Haverhill 250597001169 1280054 Pentucket Lake Elementary   Regular School No 1 KG 04 2015   grade_4 80 3 31 0   2     1   0   54 63                       117 80 3 31 0   2     1   0   54 63                 117
738614 738614 MA Essex   school 2505970 128   Haverhill 250597000866 1280075 Tilton   Regular School No 1 KG 04 2015   grade_4 36 3 56 1   3     2   1   54 48                       102 36 3 56 1   3     2   1   54 48                 102
738815 738815 MA Middlesex   school 2506390 141   Hudson 250639000924 1410007 Mulready Elementary   Regular School No 1 PK 04 2015   grade_4 57 1 2 0   0     0   1   32 29                       61 57 1 2 0   0     0   1   32 29                 61
738820 738820 MA Middlesex   school 2506390 141   Hudson 250639000925 1410015 Forest Avenue Elementary   Regular School No 1 KG 04 2015   grade_4 53 1 5 0   2     0   2   38 25                       63 53 1 5 0   2     0   2   38 25                 63
738826 738826 MA Middlesex   school 2506390 141   Hudson 250639000922 1410030 C A Farley   Regular School No 1 PK 04 2015   grade_4 87 3 3 0   1     0   4   48 50                       98 87 3 3 0   1     0   4   48 50                 98
738895 738895 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 South Lawrence East Elementary School   Regular School No 1 01 04 2015   grade_4 8 2 130 0   3     0   1   68 76                       144 8 2 130 0   3     0   1   68 76                 144
738901 738901 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No 1 PK 04 2015   grade_4 1 2 123 0   0     0   0   67 59                       126 1 2 123 0   0     0   0   67 59                 126
738919 738919 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Robert Frost   Regular School No 1 KG 04 2015   grade_4 4 3 104 0   2     0   1   71 43                       114 4 3 104 0   2     0   1   71 43                 114
738927 738927 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No 1 01 04 2015   grade_4 4 7 132 0   1     0   1   72 73                       145 4 7 132 0   1     0   1   72 73                 145
738954 738954 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Edward F. Parthum   Regular School No 1 KG 04 2015   grade_4 8 1 130 0   0     0   0   74 65                       139 8 1 130 0   0     0   0   74 65                 139
739235 739235 MA Middlesex   school 2507020 160   Lowell 250702000067 1600002 Dr Gertrude Bailey   Regular School No 1 PK 04 2015   grade_4 33 4 20 0   31     0   6   48 46                       94 33 4 20 0   31     0   6   48 46                 94
739245 739245 MA Middlesex   school 2507020 160   Lowell 250702000477 1600010 Joseph McAvinnue   Regular School No 1 PK 04 2015   grade_4 15 5 50 0   10     0   2   49 33                       82 15 5 50 0   10     0   2   49 33                 82
739251 739251 MA Middlesex   school 2507020 160   Lowell 250702001033 1600015 Greenhalge   Regular School No 1 PK 04 2015   grade_4 22 20 27 0   16     0   1   51 35                       86 22 20 27 0   16     0   1   51 35                 86
739267 739267 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No 1 PK 04 2015   grade_4 8 2 31 0   32     0   4   35 42                       77 8 2 31 0   32     0   4   35 42                 77
739273 739273 MA Middlesex   school 2507020 160   Lowell 250702000068 1600027 Moody Elementary   Regular School No 1 PK 04 2015   grade_4 24 3 8 0   12     0   0   30 17                       47 24 3 8 0   12     0   0   30 17                 47
739279 739279 MA Middlesex   school 2507020 160   Lowell 250702001029 1600030 Charles W Morey   Regular School No 1 PK 04 2015   grade_4 14 3 14 0   59     0   1   44 47                       91 14 3 14 0   59     0   1   44 47                 91
739285 739285 MA Middlesex   school 2507020 160   Lowell 250702001044 1600036 Pawtucketville Memorial   Regular School No 1 PK 04 2015   grade_4 34 10 27 0   14     0   5   56 34                       90 34 10 27 0   14     0   5   56 34                 90
739290 739290 MA Middlesex   school 2507020 160   Lowell 250702001045 1600040 Peter W Reilly   Regular School No 1 KG 04 2015   grade_4 49 3 48 0   10     0   1   61 50                       111 49 3 48 0   10     0   1   61 50                 111
739296 739296 MA Middlesex   school 2507020 160   Lowell 250702001048 1600050 John J Shaughnessy   Regular School No 1 PK 04 2015   grade_4 30 4 26 0   24     0   2   53 33                       86 30 4 26 0   24     0   2   53 33                 86
739302 739302 MA Middlesex   school 2507020 160   Lowell 250702001051 1600055 Washington   Regular School No 1 PK 04 2015   grade_4 10 4 6 0   10     0   4   16 18                       34 10 4 6 0   10     0   4   16 18                 34
739308 739308 MA Middlesex   school 2507020 160   Lowell 250702000088 1600075 S Christa McAuliffe Elementary   Regular School No 1 PK 04 2015   grade_4 31 3 36 0   6     0   3   43 36                       79 31 3 36 0   6     0   3   43 36                 79
739314 739314 MA Middlesex   school 2507020 160   Lowell 250702000092 1600080 Charlotte M Murkland Elementary   Regular School No 1 PK 04 2015   grade_4 8 5 28 0   48     0   7   53 43                       96 8 5 28 0   48     0   7   53 43                 96
739546 739546 MA Essex   school 2507140 164   Lynnfield 250714001089 1640010 Huckleberry Hill   Regular School No 1 KG 04 2015   grade_4 57 2 7 0   4     0   3   43 30                       73 57 2 7 0   4     0   3   43 30                 73
739551 739551 MA Essex   school 2507140 164   Lynnfield 250714001093 1640020 Summer Street   Regular School No 1 KG 04 2015   grade_4 78 2 2 0   4     0   0   55 31                       86 78 2 2 0   4     0   0   55 31                 86
739662 739662 MA Middlesex   school 2507320 170   Marlborough 250732001130 1700008 Francis J Kane   Regular School No 1 KG 04 2015   grade_4 59 2 42 0   6     0   5   65 49                       114 59 2 42 0   6     0   5   65 49                 114
739667 739667 MA Middlesex   school 2507320 170   Marlborough 250732001135 1700025 Richer   Regular School No 1 KG 04 2015   grade_4 52 4 69 0   3     0   4   64 68                       132 52 4 69 0   3     0   4   64 68                 132
739672 739672 MA Middlesex   school 2507320 170   Marlborough 250732001631 1700030 Charles Jaworek School   Regular School No 1 KG 04 2015   grade_4 73 5 61 0   7     0   1   79 68                       147 73 5 61 0   7     0   1   79 68                 147
739823 739823 MA Norfolk   school 2507590 177   Medway 250759001015 1770015 Burke/Memorial Elementary School   Regular School No 1 02 04 2015   grade_4 154 1 5 1   4     0   2   76 91                       167 154 1 5 1   4     0   2   76 91                 167
739951 739951 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No 1 03 04 2015   grade_4 230 13 79 4   7     0   12   172 173                       345 230 13 79 4   7     0   12   172 173                 345
739981 739981 MA Norfolk   school 2507920 187   Millis 250792001252 1870005 Clyde F Brown   Regular School No 1 PK 04 2015   grade_4 100 1 7 0   3     0   3   60 54                       114 100 1 7 0   3     0   3   60 54                 114
740029 740029 MA Hampden   school 2508040 191   Monson 250804002589 1910025 Quarry Hill Community School   Regular School No 1 PK 04 2015   grade_4 59 0 1 0   0     0   0   27 33                       60 59 0 1 0   0     0   0   27 33                 60
740066 740066 MA Middlesex   school 2508340 198   Natick 250834001291 1980005 Bennett-Hemenway   Regular School No 1 KG 04 2015   grade_4 89 2 2 0   9     0   3   58 47                       105 89 2 2 0   9     0   3   58 47                 105
740071 740071 MA Middlesex   school 2508340 198   Natick 250834001292 1980010 Brown   Regular School No 1 KG 04 2015   grade_4 59 0 7 0   23     0   5   38 56                       94 59 0 7 0   23     0   5   38 56                 94
740076 740076 MA Middlesex   school 2508340 198   Natick 250834001298 1980031 Johnson   Regular School No 1 KG 04 2015   grade_4 33 0 1 0   3     0   0   18 19                       37 33 0 1 0   3     0   0   18 19                 37
740081 740081 MA Middlesex   school 2508340 198   Natick 250834001299 1980035 Lilja Elementary   Regular School No 1 KG 04 2015   grade_4 64 4 5 0   2     0   6   41 40                       81 64 4 5 0   2     0   6   41 40                 81
740086 740086 MA Middlesex   school 2508340 198   Natick 250834001301 1980043 Memorial   Regular School No 1 KG 04 2015   grade_4 68 0 0 0   7     0   3   34 44                       78 68 0 0 0   7     0   3   34 44                 78
740532 740532 MA Bristol   school 2508730 212   North Attleborough 250873001400 2120005 Allen Avenue   Regular School No 1 KG 04 2015   grade_4 38 1 0 0   4     0   3   28 18                       46 38 1 0 0   4     0   3   28 18                 46
740602 740602 MA Worcester   school 2508940 214   Northbridge 250894001447 2140001 W Edward Balmer   Regular School No 1 02 04 2015   grade_4 171 0 12 0   1     0   9   113 80                       193 171 0 12 0   1     0   9   113 80                 193
740755 740755 MA Worcester   school 2509270 226   Oxford 250927001481 2260005 Clara Barton   Regular School No 1 03 04 2015   grade_4 124 1 19 0   3     0   1   76 72                       148 124 1 19 0   3     0   1   76 72                 148
740777 740777 MA Hampden   school 2509300 227   Palmer 250930002594 2270008 Old Mill Pond   Regular School No 1 PK 04 2015   grade_4 107 2 10 0   0     0   9   78 50                       128 107 2 10 0   0     0   9   78 50                 128
741006 741006 MA Plymouth   school 2509720 239   Plymouth 250972001547 2390046 South Elementary   Regular School No 1 PK 04 2015   grade_4 127 2 3 1   0     1   4   77 61                       138 127 2 3 1   0     1   4   77 61                 138
741062 741062 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Lincoln-Hancock Community School   Regular School No 1 KG 04 2015   grade_4 46 7 9 0   20     0   2   40 44                       84 46 7 9 0   20     0   2   40 44                 84
741073 741073 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Clifford H Marshall Elementary   Regular School No 1 KG 04 2015   grade_4 47 11 8 0   38     0   5   62 47                       109 47 11 8 0   38     0   5   62 47                 109
741289 741289 MA Plymouth   school 2510170 251   Rockland 251017001640 2510020 Memorial Park   Regular School No 1 01 04 2015   grade_4 40 2 3 0   1     0   0   26 20                       46 40 2 3 0   1     0   0   26 20                 46
741293 741293 MA Plymouth   school 2510170 251   Rockland 251017001641 2510025 R Stewart Esten   Regular School No 1 01 04 2015   grade_4 71 7 2 0   1     0   3   45 39                       84 71 7 2 0   1     0   3   45 39                 84
741298 741298 MA Plymouth   school 2510170 251   Rockland 251017001708 2510060 Jefferson Elementary School   Regular School No 1 KG 04 2015   grade_4 26 2 4 0   1     0   1   19 15                       34 26 2 4 0   1     0   1   19 15                 34
741552 741552 MA Worcester   school 2510770 271   Shrewsbury 251077001713 2710015 Calvin Coolidge   Regular School No 1 KG 04 2015   grade_4 42 5 8 0   30     0   3   46 42                       88 42 5 8 0   30     0   3   46 42                 88
741556 741556 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No 1 01 04 2015   grade_4 104 5 10 1   71     0   6   107 90                       197 104 5 10 1   71     0   6   107 90                 197
741561 741561 MA Worcester   school 2510770 271   Shrewsbury 251077001719 2710025 Walter J Paton   Regular School No 1 KG 04 2015   grade_4 79 0 3 0   9     0   3   49 45                       94 79 0 3 0   9     0   3   49 45                 94

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