enrollments

Data source: Big Local News · About: Big Local

894 rows where grade = "grade_5", state = "MA" and year = 2017 sorted by native_american_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 894 ✖

grade ✖

  • grade_5 · 894 ✖
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
1122674 1122674 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No Elementary PK 06 2017   grade_5 * * * *   *     *   *   3 1                       *                         3 1                  
1123667 1123667 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative School No Other 05 12 2017   grade_5 * * * *   *     *   *   1 1                       *                         1 1                  
1125191 1125191 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_5 * * * *   *     *   *   * *                       *                                              
1125265 1125265 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_5 * * * *   *     *   *   * *                       *                                              
1126250 1126250 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Elementary 02 07 2017   grade_5 * * * *   *     *   *   2 *                       *                         2                    
1126351 1126351 MA Essex   school 2507110 163   Lynn 250711002801 1630004 Early Childhood Center   Regular School No Elementary PK 05 2017   grade_5 * * * *   *     *   *   1 1                       *                         1 1                  
1128753 1128753 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No Elementary PK 05 2017   grade_5 * * * *   *     *   *   1 2                       *                         1 2                  
1130461 1130461 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Maria Weston Chapman Middle School   Regular School No Middle 05 08 2017   grade_5 * * * *   *     *   *   1 2                       *                         1 2                  
1132594 1132594 MA Franklin   school 2509600 750   Pioneer Valley 250960002613 7500007 Pearl E Rhodes Elementary   Regular School No Elementary PK 06 2017   grade_5 * * * *   *     *   *   1 2                       *                         1 2                  
1121954 1121954 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Middle 05 06 2017   grade_5 169 1 7 0   3     0   0   97 83                       180 169 1 7 0   3     0   0   97 83                 180
1121972 1121972 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2017   grade_5 103 1 0 0   0     0   1   58 47                       105 103 1 0 0   0     0   1   58 47                 105
1122003 1122003 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No Middle 05 08 2017   grade_5 243 8 16 0   12     0   11   162 128                       290 243 8 16 0   12     0   11   162 128                 290
1122030 1122030 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2017   grade_5 150 3 14 0   3     1   2   79 94                       173 150 3 14 0   3     1   2   79 94                 173
1122051 1122051 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2017   grade_5 29 3 15 0   4     0   9   26 34                       60 29 3 15 0   4     0   9   26 34                 60
1122059 1122059 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2017   grade_5 28 11 14 0   3     0   3   29 30                       59 28 11 14 0   3     0   3   29 30                 59
1122075 1122075 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2017   grade_5 93 4 10 0   6     0   5   57 61                       118 93 4 10 0   6     0   5   57 61                 118
1122082 1122082 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No Elementary KG 05 2017   grade_5 62 4 8 0   29     0   4   58 49                       107 62 4 8 0   29     0   4   58 49                 107
1122098 1122098 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No Elementary KG 05 2017   grade_5 66 0 4 0   19     0   0   40 49                       89 66 0 4 0   19     0   0   40 49                 89
1122105 1122105 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2017   grade_5 89 5 7 0   13     0   5   68 51                       119 89 5 7 0   13     0   5   68 51                 119
1122129 1122129 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2017   grade_5 62 1 2 0   8     0   3   30 46                       76 62 1 2 0   8     0   3   30 46                 76
1122136 1122136 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2017   grade_5 60 1 4 0   10     0   7   41 41                       82 60 1 4 0   10     0   7   41 41                 82
1122143 1122143 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2017   grade_5 64 1 2 0   8     0   2   43 34                       77 64 1 2 0   8     0   2   43 34                 77
1122150 1122150 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2017   grade_5 47 4 7 0   13     1   4   36 40                       76 47 4 7 0   13     1   4   36 40                 76
1122159 1122159 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2017   grade_5 31 1 6 0   4     0   3   24 21                       45 31 1 6 0   4     0   3   24 21                 45
1122166 1122166 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2017   grade_5 30 2 6 0   9     0   4   24 27                       51 30 2 6 0   9     0   4   24 27                 51
1122173 1122173 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2017   grade_5 47 1 4 0   10     0   2   26 38                       64 47 1 4 0   10     0   2   26 38                 64
1122235 1122235 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2017   grade_5 112 5 25 0   9     0   13   85 79                       164 112 5 25 0   9     0   13   85 79                 164
1122245 1122245 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No Middle 05 08 2017   grade_5 100 6 29 0   6     0   9   78 72                       150 100 6 29 0   6     0   9   78 72                 150
1122269 1122269 MA Worcester   school 2502220 17   Auburn 250222002846 170030 Swanson Road Intermediate School   Regular School No Elementary 03 05 2017   grade_5 149 3 13 0   7     0   5   96 81                       177 149 3 13 0   7     0   5   96 81                 177
1122320 1122320 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable United Elementary School   Regular School No Elementary 04 05 2017   grade_5 301 30 51 0   9     0   15   226 180                       406 301 30 51 0   9     0   15   226 180                 406
1122337 1122337 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Lt Job Lane School   Regular School No Elementary 03 05 2017   grade_5 120 12 11 0   26     0   13   100 82                       182 120 12 11 0   26     0   13   100 82                 182
1122353 1122353 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Chestnut Hill Community School   Regular School No Elementary 04 06 2017   grade_5 167 4 13 0   2     0   5   81 110                       191 167 4 13 0   2     0   5   81 110                 191
1122437 1122437 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2017   grade_5 85 1 2 0   0     0   0   43 45                       88 85 1 2 0   0     0   0   43 45                 88
1122448 1122448 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No Elementary PK 05 2017   grade_5 30 0 1 0   1     0   4   24 12                       36 30 0 1 0   1     0   4   24 12                 36
1122457 1122457 MA Essex   school 2502640 30   Beverly 250264000167 300010 Centerville Elementary   Regular School No Elementary KG 05 2017   grade_5 32 5 12 0   0     0   2   29 22                       51 32 5 12 0   0     0   2   29 22                 51
1122464 1122464 MA Essex   school 2502640 30   Beverly 250264000168 300015 Cove Elementary   Regular School No Elementary KG 05 2017   grade_5 44 1 6 0   2     0   3   28 28                       56 44 1 6 0   2     0   3   28 28                 56
1122471 1122471 MA Essex   school 2502640 30   Beverly 250264000169 300033 Hannah Elementary   Regular School No Elementary KG 05 2017   grade_5 47 2 12 0   2     0   1   34 30                       64 47 2 12 0   2     0   1   34 30                 64
1122478 1122478 MA Essex   school 2502640 30   Beverly 250264000173 300040 North Beverly Elementary   Regular School No Elementary KG 05 2017   grade_5 63 2 4 0   2     0   2   39 34                       73 63 2 4 0   2     0   2   39 34                 73
1122485 1122485 MA Essex   school 2502640 30   Beverly 250264000175 300055 Ayers/Ryal Side School   Regular School No Elementary KG 05 2017   grade_5 61 4 10 0   3     0   1   39 40                       79 61 4 10 0   3     0   1   39 40                 79
1122501 1122501 MA Middlesex   school 2502670 31   Billerica 250267000186 310005 Thomas Ditson   Regular School No Elementary KG 05 2017   grade_5 65 3 5 0   7     0   2   41 41                       82 65 3 5 0   7     0   2   41 41                 82
1122508 1122508 MA Middlesex   school 2502670 31   Billerica 250267000179 310007 Frederick J Dutile   Regular School No Elementary KG 05 2017   grade_5 53 1 4 0   1     0   1   35 25                       60 53 1 4 0   1     0   1   35 25                 60
1122515 1122515 MA Middlesex   school 2502670 31   Billerica 250267000181 310012 John F Kennedy   Regular School No Elementary KG 05 2017   grade_5 56 1 2 0   2     0   1   35 27                       62 56 1 2 0   2     0   1   35 27                 62
1122522 1122522 MA Middlesex   school 2502670 31   Billerica 250267000184 310015 Parker   Regular School No Elementary KG 05 2017   grade_5 52 1 4 0   9     0   1   38 29                       67 52 1 4 0   9     0   1   38 29                 67
1122536 1122536 MA Middlesex   school 2502670 31   Billerica 250267000178 310030 Eugene C Vining   Regular School No Elementary KG 05 2017   grade_5 25 1 1 0   1     1   1   13 17                       30 25 1 1 0   1     1   1   13 17                 30
1122566 1122566 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No Elementary KG 08 2017   grade_5 5 2 5 0   2     0   2   11 5                       16 5 2 5 0   2     0   2   11 5                 16
1122606 1122606 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No Elementary PK 08 2017   grade_5 5 27 34 0   8     0   5   41 38                       79 5 27 34 0   8     0   5   41 38                 79
1122627 1122627 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2017   grade_5 16 18 50 0   3     0   3   42 48                       90 16 18 50 0   3     0   3   42 48                 90
1122650 1122650 MA Suffolk   school 2502790 35   Boston 250279000214 350052 Charles Sumner   Regular School No Elementary PK 05 2017   grade_5 2 7 35 0   1     0   0   21 24                       45 2 7 35 0   1     0   0   21 24                 45
1122658 1122658 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Charles H Taylor   Regular School No Elementary PK 05 2017   grade_5 1 53 13 0   1     0   2   36 34                       70 1 53 13 0   1     0   2   36 34                 70
1122666 1122666 MA Suffolk   school 2502790 35   Boston 250279000218 350062 Curtis Guild   Regular School No Elementary PK 05 2017   grade_5 4 0 34 0   0     0   0   25 13                       38 4 0 34 0   0     0   0   25 13                 38
1122683 1122683 MA Suffolk   school 2502790 35   Boston 250279000220 350072 David A Ellis   Regular School No Elementary PK 05 2017   grade_5 2 13 29 0   0     0   0   28 16                       44 2 13 29 0   0     0   0   28 16                 44
1122699 1122699 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2017   grade_5 10 15 19 0   1     0   3   22 26                       48 10 15 19 0   1     0   3   22 26                 48
1122710 1122710 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2017   grade_5 4 3 61 0   0     0   1   31 38                       69 4 3 61 0   0     0   1   31 38                 69
1122721 1122721 MA Suffolk   school 2502790 35   Boston 250279000227 350088 Edward Everett   Regular School No Elementary PK 05 2017   grade_5 2 17 16 0   7     0   2   27 17                       44 2 17 16 0   7     0   2   27 17                 44
1122729 1122729 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No Elementary PK 08 2017   grade_5 21 9 10 0   3     0   1   21 23                       44 21 9 10 0   3     0   1   21 23                 44
1122740 1122740 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No Elementary PK 05 2017   grade_5 4 9 9 0   0     0   1   11 12                       23 4 9 9 0   0     0   1   11 12                 23
1122748 1122748 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No Elementary PK 08 2017   grade_5 11 15 17 0   1     0   0   16 28                       44 11 15 17 0   1     0   0   16 28                 44
1122759 1122759 MA Suffolk   school 2502790 35   Boston 250279000241 350122 George H Conley   Regular School No Elementary PK 05 2017   grade_5 0 17 11 0   1     0   1   18 12                       30 0 17 11 0   1     0   1   18 12                 30
1122767 1122767 MA Suffolk   school 2502790 35   Boston 250279000247 350135 Henry Grew   Regular School No Elementary PK 05 2017   grade_5 1 16 8 0   1     0   2   16 12                       28 1 16 8 0   1     0   2   16 12                 28
1122775 1122775 MA Suffolk   school 2502790 35   Boston 250279002569 350138 O W Holmes   Regular School No Elementary PK 05 2017   grade_5 1 29 13 0   1     0   2   27 19                       46 1 29 13 0   1     0   2   27 19                 46
1122783 1122783 MA Suffolk   school 2502790 35   Boston 250279000249 350141 Hugh Roe O'Donnell   Regular School No Elementary PK 05 2017   grade_5 0 1 45 0   2     0   0   25 23                       48 0 1 45 0   2     0   0   25 23                 48
1122791 1122791 MA Suffolk   school 2502790 35   Boston 250279000254 350146 James Condon Elementary   Regular School No Elementary PK 07 2017   grade_5 26 39 51 0   7     0   4   71 56                       127 26 39 51 0   7     0   4   71 56                 127
1122800 1122800 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No Elementary KG 08 2017   grade_5 4 23 60 0   2     0   2   50 41                       91 4 23 60 0   2     0   2   50 41                 91
1122811 1122811 MA Suffolk   school 2502790 35   Boston 250279000255 350154 James J Chittick   Regular School No Elementary PK 05 2017   grade_5 0 15 7 0   0     0   1   14 9                       23 0 15 7 0   0     0   1   14 9                 23
1122819 1122819 MA Suffolk   school 2502790 35   Boston 250279000257 350156 James Otis   Regular School No Elementary PK 05 2017   grade_5 4 0 41 0   1     0   0   20 26                       46 4 0 41 0   1     0   0   20 26                 46
1122827 1122827 MA Suffolk   school 2502790 35   Boston 250279000265 350166 John F Kennedy   Regular School No Elementary PK 05 2017   grade_5 0 11 40 0   0     0   2   30 23                       53 0 11 40 0   0     0   2   30 23                 53
1122835 1122835 MA Suffolk   school 2502790 35   Boston 250279000268 350167 UP Academy Holland   Regular School No Elementary PK 05 2017   grade_5 0 40 54 0   2     0   10   58 48                       106 0 40 54 0   2     0   10   58 48                 106
1122843 1122843 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No Elementary PK 05 2017   grade_5 1 8 10 0   0     0   0   7 12                       19 1 8 10 0   0     0   0   7 12                 19
1122855 1122855 MA Suffolk   school 2502790 35   Boston 250279000270 350180 John Winthrop   Regular School No Elementary PK 05 2017   grade_5 0 24 8 0   0     1   3   15 21                       36 0 24 8 0   0     1   3   15 21                 36
1122863 1122863 MA Suffolk   school 2502790 35   Boston 250279000275 350181 Joseph P Tynan   Regular School No Elementary PK 05 2017   grade_5 3 15 4 0   1     0   3   17 9                       26 3 15 4 0   1     0   3   17 9                 26
1122871 1122871 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2017   grade_5 8 0 21 0   0     0   2   15 16                       31 8 0 21 0   0     0   2   15 16                 31
1122882 1122882 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No Elementary PK 08 2017   grade_5 4 37 13 0   7     0   5   38 28                       66 4 37 13 0   7     0   5   38 28                 66
1122893 1122893 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Joseph P Manning   Regular School No Elementary PK 05 2017   grade_5 8 4 8 0   1     0   3   14 10                       24 8 4 8 0   1     0   3   14 10                 24
1122901 1122901 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2017   grade_5 24 2 11 0   1     0   1   24 15                       39 24 2 11 0   1     0   1   24 15                 39
1122912 1122912 MA Suffolk   school 2502790 35   Boston 250279000244 350200 Harvard-Kent   Regular School No Elementary PK 05 2017   grade_5 3 14 32 0   15     0   2   32 34                       66 3 14 32 0   15     0   2   32 34                 66
1122920 1122920 MA Suffolk   school 2502790 35   Boston 250279000283 350215 Manassah E Bradley   Regular School No Elementary PK 05 2017   grade_5 6 3 26 0   2     0   0   18 19                       37 6 3 26 0   2     0   0   18 19                 37
1122936 1122936 MA Suffolk   school 2502790 35   Boston 250279000289 350227 Mather   Regular School No Elementary PK 05 2017   grade_5 5 35 24 0   22     0   5   39 52                       91 5 35 24 0   22     0   5   39 52                 91
1122944 1122944 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2017   grade_5 2 17 27 0   0     0   0   20 26                       46 2 17 27 0   0     0   0   20 26                 46
1122954 1122954 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No Elementary KG 05 2017   grade_5 2 21 14 0   0     0   3   20 20                       40 2 21 14 0   0     0   3   20 20                 40
1122962 1122962 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No Elementary PK 05 2017   grade_5 3 8 7 0   2     0   2   9 13                       22 3 8 7 0   2     0   2   9 13                 22
1122970 1122970 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No Elementary PK 08 2017   grade_5 22 18 30 0   45     0   4   58 61                       119 22 18 30 0   45     0   4   58 61                 119
1122981 1122981 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No Elementary PK 05 2017   grade_5 2 19 18 0   1     0   0   16 24                       40 2 19 18 0   1     0   0   16 24                 40
1122989 1122989 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2017   grade_5 12 6 4 0   1     0   0   12 11                       23 12 6 4 0   1     0   0   12 11                 23
1123007 1123007 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Elementary 03 08 2017   grade_5 28 21 54 0   2     0   3   59 49                       108 28 21 54 0   2     0   3   59 49                 108
1123018 1123018 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No Elementary PK 08 2017   grade_5 23 6 24 0   0     0   3   29 27                       56 23 6 24 0   0     0   3   29 27                 56
1123029 1123029 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Patrick J Kennedy   Regular School No Elementary PK 05 2017   grade_5 2 0 20 0   1     0   0   11 12                       23 2 0 20 0   1     0   0   11 12                 23
1123042 1123042 MA Suffolk   school 2502790 35   Boston 250279000304 350268 Paul A Dever   Regular School No Elementary PK 05 2017   grade_5 2 9 44 0   2     0   1   27 31                       58 2 9 44 0   2     0   1   27 31                 58
1123058 1123058 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Josiah Quincy   Regular School No Elementary PK 05 2017   grade_5 9 25 23 0   74     0   5   66 70                       136 9 25 23 0   74     0   5   66 70                 136
1123066 1123066 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Roger Clap   Regular School No Elementary PK 05 2017   grade_5 5 5 11 0   0     0   0   12 9                       21 5 5 11 0   0     0   0   12 9                 21
1123074 1123074 MA Suffolk   school 2502790 35   Boston 250279000321 350302 Samuel Adams   Regular School No Elementary PK 05 2017   grade_5 4 1 23 0   0     0   0   15 13                       28 4 1 23 0   0     0   0   15 13                 28
1123082 1123082 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Samuel W Mason   Regular School No Elementary PK 05 2017   grade_5 0 14 7 0   0     0   2   10 13                       23 0 14 7 0   0     0   2   10 13                 23
1123090 1123090 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2017   grade_5 1 13 30 0   0     0   1   27 18                       45 1 13 30 0   0     0   1   27 18                 45
1123101 1123101 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No Elementary PK 08 2017   grade_5 5 7 30 0   2     0   2   26 20                       46 5 7 30 0   2     0   2   26 20                 46
1123112 1123112 MA Suffolk   school 2502790 35   Boston 250279000332 350328 Thomas J Kenny   Regular School No Elementary PK 05 2017   grade_5 0 27 13 0   4     0   3   18 29                       47 0 27 13 0   4     0   3   18 29                 47
1123120 1123120 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2017   grade_5 30 12 23 0   4     0   2   32 39                       71 30 12 23 0   4     0   2   32 39                 71
1123131 1123131 MA Suffolk   school 2502790 35   Boston 250279000338 350360 William Ellery Channing   Regular School No Elementary PK 05 2017   grade_5 3 12 9 0   0     0   2   7 19                       26 3 12 9 0   0     0   2   7 19                 26
1123136 1123136 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_5 2 4 10 0   0     0   0   12 4                       16 2 4 10 0   0     0   0   12 4                 16
1123151 1123151 MA Suffolk   school 2502790 35   Boston 250279000337 350366 William E Russell   Regular School No Elementary PK 05 2017   grade_5 0 7 19 0   3     0   2   14 17                       31 0 7 19 0   3     0   2   14 17                 31
1123159 1123159 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2017   grade_5 0 26 17 0   0     0   4   23 24                       47 0 26 17 0   0     0   4   23 24                 47
1123170 1123170 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Winship Elementary   Regular School No Elementary PK 05 2017   grade_5 5 6 12 0   2     0   2   16 11                       27 5 6 12 0   2     0   2   16 11                 27

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