enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
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
1123474 1123474 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 05 08 2017   grade_5 147 2 10 1   1     0   2   83 80                       163 147 2 10 1   1     0   2   83 80                 163
1123566 1123566 MA Barnstable   school 2502970 41   Brewster 250297000841 410010 Eddy Elementary   Regular School No Elementary 03 05 2017   grade_5 65 4 6 0   0     0   2   38 39                       77 65 4 6 0   0     0   2   38 39                 77
1124515 1124515 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No Elementary PK 05 2017   grade_5 24 3 0 0   1     0   0   14 14                       28 24 3 0 0   1     0   0   14 14                 28
1124856 1124856 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No Middle 05 06 2017   grade_5 216 20 16 2   3     1   15   138 135                       273 216 20 16 2   3     1   15   138 135                 273
1126741 1126741 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2017   grade_5 83 3 3 6   2     0   5   60 42                       102 83 3 3 6   2     0   5   60 42                 102
1127939 1127939 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans Elementary   Regular School No Elementary KG 05 2017   grade_5 32 0 0 0   2     0   1   19 16                       35 32 0 0 0   2     0   1   19 16                 35
1128277 1128277 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2017   grade_5 5 2 1 0   0     0   1   5 4                       9 5 2 1 0   0     0   1   5 4                 9
1128697 1128697 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No Elementary 03 06 2017   grade_5 231 0 4 0   2     0   1   108 130                       238 231 0 4 0   2     0   1   108 130                 238
1129765 1129765 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2017   grade_5 15 0 2 0   0     0   1   8 10                       18 15 0 2 0   0     0   1   8 10                 18
1130138 1130138 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No Elementary PK 05 2017   grade_5 9 0 0 0   0     0   1   5 5                       10 9 0 0 0   0     0   1   5 5                 10
1131997 1131997 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 N H Wixon Innovation School   Regular School No Elementary 04 05 2017   grade_5 170 18 30 6   5     0   13   113 129                       242 170 18 30 6   5     0   13   113 129                 242
1132366 1132366 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No Middle 05 07 2017   grade_5 117 9 15 1   1     1   5   74 75                       149 117 9 15 1   1     1   5   74 75                 149
1124212 1124212 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2017   grade_5 18 0 0 0   0     0   0   10 8                       18 18 0 0 0   0     0   0   10 8                 18
1124925 1124925 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   grade_5 8 0 0 0   0     1   0   3 6                       9 8 0 0 0   0     1   0   3 6                 9
1125320 1125320 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2017   grade_5 8 0 0 0   0     0   0   5 3                       8 8 0 0 0   0     0   0   5 3                 8
1125752 1125752 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No Elementary PK 06 2017   grade_5 32 0 0 0   0     0   0   13 19                       32 32 0 0 0   0     0   0   13 19                 32
1125902 1125902 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No Elementary PK 06 2017   grade_5 38 1 2 0   2     0   1   23 21                       44 38 1 2 0   2     0   1   23 21                 44
1125936 1125936 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Morris   Regular School No Elementary PK 05 2017   grade_5 52 0 5 0   4     0   0   36 25                       61 52 0 5 0   4     0   0   36 25                 61
1127566 1127566 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 Colegrove Park Elementary   Regular School No Elementary KG 07 2017   grade_5 48 3 0 0   0     0   1   24 28                       52 48 3 0 0   0     0   1   24 28                 52
1127575 1127575 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 Greylock   Regular School No Elementary KG 07 2017   grade_5 40 2 3 0   3     0   1   28 21                       49 40 2 3 0   3     0   1   28 21                 49
1127585 1127585 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No Elementary PK 07 2017   grade_5 24 1 3 0   1     0   4   16 17                       33 24 1 3 0   1     0   4   16 17                 33
1128104 1128104 MA Berkshire   school 2509630 236   Pittsfield 250963001516 2360010 Allendale   Regular School No Elementary KG 05 2017   grade_5 40 1 5 1   0     0   4   30 21                       51 40 1 5 1   0     0   4   30 21                 51
1128111 1128111 MA Berkshire   school 2509630 236   Pittsfield 250963001519 2360035 Egremont   Regular School No Elementary KG 05 2017   grade_5 72 7 6 0   3     0   5   48 45                       93 72 7 6 0   3     0   5   48 45                 93
1128119 1128119 MA Berkshire   school 2509630 236   Pittsfield 250963001522 2360045 Robert T. Capeless Elementary School   Regular School No Elementary PK 05 2017   grade_5 31 1 1 0   0     0   2   15 20                       35 31 1 1 0   0     0   2   15 20                 35
1128127 1128127 MA Berkshire   school 2509630 236   Pittsfield 250963001524 2360055 Morningside Community School   Regular School No Elementary PK 05 2017   grade_5 35 18 12 1   0     0   4   39 31                       70 35 18 12 1   0     0   4   39 31                 70
1128135 1128135 MA Berkshire   school 2509630 236   Pittsfield 250963001528 2360065 Crosby   Regular School No Elementary PK 05 2017   grade_5 38 9 7 0   3     0   5   33 29                       62 38 9 7 0   3     0   5   33 29                 62
1128142 1128142 MA Berkshire   school 2509630 236   Pittsfield 250963002489 2360090 Stearns   Regular School No Elementary KG 05 2017   grade_5 28 1 2 0   0     0   5   14 22                       36 28 1 2 0   0     0   5   14 22                 36
1128149 1128149 MA Berkshire   school 2509630 236   Pittsfield 250963001536 2360100 Williams   Regular School No Elementary KG 05 2017   grade_5 43 1 5 0   1     0   3   25 28                       53 43 1 5 0   1     0   3   25 28                 53
1128157 1128157 MA Berkshire   school 2509630 236   Pittsfield 250963001535 2360105 Silvio O Conte Community   Regular School No Elementary PK 05 2017   grade_5 9 16 9 1   0     0   4   16 23                       39 9 16 9 1   0     0   4   16 23                 39
1128553 1128553 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2017   grade_5 24 1 1 0   0     0   1   13 14                       27 24 1 1 0   0     0   1   13 14                 27
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                  
1130540 1130540 MA Berkshire   school 2513020 341   Williamstown 251302002146 3410010 Williamstown Elementary   Regular School No Elementary PK 06 2017   grade_5 59 2 4 0   0     0   6   27 44                       71 59 2 4 0   0     0   6   27 44                 71
1131748 1131748 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000018 6030004 Cheshire Elementary   Regular School No Elementary PK 05 2017   grade_5 32 2 0 0   0     0   0   13 21                       34 32 2 0 0   0     0   0   13 21                 34
1131755 1131755 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000023 6030020 Plunkett Elementary   Regular School No Elementary KG 05 2017   grade_5 68 1 1 1   0     0   1   38 34                       72 68 1 1 1   0     0   1   38 34                 72
1131855 1131855 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No Middle 05 08 2017   grade_5 55 2 4 0   5     0   5   41 30                       71 55 2 4 0   5     0   5   41 30                 71
1131948 1131948 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Becket Washington School   Regular School No Elementary PK 05 2017   grade_5 17 0 0 0   0     0   1   8 10                       18 17 0 0 0   0     0   1   8 10                 18
1131956 1131956 MA Berkshire   school 2503390 635   Central Berkshire 250339000462 6350025 Craneville   Regular School No Elementary PK 05 2017   grade_5 79 0 3 0   0     0   2   41 43                       84 79 0 3 0   0     0   2   41 43                 84
1131964 1131964 MA Berkshire   school 2503390 635   Central Berkshire 250339000465 6350035 Kittredge   Regular School No Elementary PK 05 2017   grade_5 19 0 0 0   1     0   1   14 7                       21 19 0 0 0   1     0   1   14 7                 21
1132092 1132092 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2017   grade_5 11 0 0 0   0     0   1   6 6                       12 11 0 0 0   0     0   1   6 6                 12
1132710 1132710 MA Berkshire   school 2511040 765   Southern Berkshire 251104000428 7650035 Undermountain   Regular School No Elementary PK 06 2017   grade_5 48 0 1 0   0     0   2   20 31                       51 48 0 1 0   0     0   2   20 31                 51
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
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
1122240 1122240 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2017   grade_5 91 4 30 1   11     0   8   69 76                       145 91 4 30 1   11     0   8   69 76                 145
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
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
1124340 1124340 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No Elementary 01 05 2017   grade_5 89 0 2 0   1     0   5   48 49                       97 89 0 2 0   1     0   5   48 49                 97
1124347 1124347 MA Bristol   school 2504020 72   Dartmouth 250402000542 720030 George H Potter   Regular School No Elementary KG 05 2017   grade_5 67 3 3 0   0     0   4   41 36                       77 67 3 3 0   0     0   4   41 36                 77
1124354 1124354 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 James M. Quinn School   Regular School No Elementary KG 05 2017   grade_5 110 1 4 0   0     0   9   78 46                       124 110 1 4 0   0     0   9   78 46                 124
1124585 1124585 MA Bristol   school 2504620 88   Easton 250462000983 880025 Richardson Olmsted School   Regular School No Elementary 03 05 2017   grade_5 249 11 10 0   10     0   4   151 133                       284 249 11 10 0   10     0   4   151 133                 284
1124695 1124695 MA Bristol   school 2504800 94   Fairhaven 250480000640 940010 East Fairhaven   Regular School No Elementary PK 05 2017   grade_5 62 1 1 0   2     0   1   37 30                       67 62 1 1 0   2     0   1   37 30                 67
1124702 1124702 MA Bristol   school 2504800 94   Fairhaven 250480000645 940030 Leroy Wood   Regular School No Elementary KG 05 2017   grade_5 78 1 5 0   4     0   4   52 40                       92 78 1 5 0   4     0   4   52 40                 92
1124719 1124719 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No Elementary PK 05 2017   grade_5 75 5 18 0   6     0   11   61 54                       115 75 5 18 0   6     0   11   61 54                 115
1124726 1124726 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No Elementary KG 05 2017   grade_5 52 10 22 0   1     0   9   48 46                       94 52 10 22 0   1     0   9   48 46                 94
1124733 1124733 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Mary Fonseca Elementary School   Regular School No Elementary KG 05 2017   grade_5 56 10 30 1   7     0   14   65 53                       118 56 10 30 1   7     0   14   65 53                 118
1124741 1124741 MA Bristol   school 2504830 95   Fall River 250483002656 950013 Letourneau Elementary School   Regular School No Elementary PK 05 2017   grade_5 38 5 36 0   3     0   2   47 37                       84 38 5 36 0   3     0   2   47 37                 84
1124749 1124749 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No Elementary PK 08 2017   grade_5 14 10 19 0   2     1   5   30 21                       51 14 10 19 0   2     1   5   30 21                 51
1124760 1124760 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No Elementary PK 08 2017   grade_5 35 6 12 1   3     0   7   32 32                       64 35 6 12 1   3     0   7   32 32                 64
1124771 1124771 MA Bristol   school 2504830 95   Fall River 250483000684 950065 William S Greene   Regular School No Elementary PK 05 2017   grade_5 84 11 26 0   9     0   11   82 59                       141 84 11 26 0   9     0   11   82 59                 141
1124778 1124778 MA Bristol   school 2504830 95   Fall River 250483000679 950130 Spencer Borden   Regular School No Elementary KG 05 2017   grade_5 48 7 8 0   5     0   6   43 31                       74 48 7 8 0   5     0   6   43 31                 74
1124785 1124785 MA Bristol   school 2504830 95   Fall River 250483000665 950140 James Tansey   Regular School No Elementary KG 05 2017   grade_5 33 0 7 0   1     0   2   17 26                       43 33 0 7 0   1     0   2   17 26                 43
1124792 1124792 MA Bristol   school 2504830 95   Fall River 250483000677 950145 Samuel Watson   Regular School No Elementary KG 05 2017   grade_5 21 5 12 0   1     0   6   19 26                       45 21 5 12 0   1     0   6   19 26                 45
1124817 1124817 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No Elementary 02 08 2017   grade_5 3 0 1 0   0     0   2   6 *                       6 3 0 1 0   0     0   2   6                   6
1126606 1126606 MA Bristol   school 2507230 167   Mansfield 250723001365 1670014 Jordan/Jackson Elementary   Regular School No Elementary 03 05 2017   grade_5 240 15 13 0   21     0   8   155 142                       297 240 15 13 0   21     0   8   155 142                 297
1127234 1127234 MA Bristol   school 2508430 201   New Bedford 250843001321 2010010 Charles S Ashley   Regular School No Elementary KG 05 2017   grade_5 52 1 15 0   1     0   3   37 35                       72 52 1 15 0   1     0   3   37 35                 72
1127242 1127242 MA Bristol   school 2508430 201   New Bedford 250843001322 2010015 Elizabeth Carter Brooks   Regular School No Elementary PK 05 2017   grade_5 19 5 11 0   0     0   1   10 26                       36 19 5 11 0   0     0   1   10 26                 36
1127250 1127250 MA Bristol   school 2508430 201   New Bedford 250843001324 2010020 Elwyn G Campbell   Regular School No Elementary PK 05 2017   grade_5 13 2 20 0   0     0   0   19 16                       35 13 2 20 0   0     0   0   19 16                 35
1127257 1127257 MA Bristol   school 2508430 201   New Bedford 250843001329 2010040 James B Congdon   Regular School No Elementary KG 05 2017   grade_5 22 8 17 0   0     0   1   12 36                       48 22 8 17 0   0     0   1   12 36                 48
1127265 1127265 MA Bristol   school 2508430 201   New Bedford 250843001341 2010045 Sgt Wm H Carney Academy   Regular School No Elementary PK 05 2017   grade_5 50 20 40 0   2     0   11   70 53                       123 50 20 40 0   2     0   11   70 53                 123
1127272 1127272 MA Bristol   school 2508430 201   New Bedford 250843001332 2010050 John B Devalles   Regular School No Elementary KG 05 2017   grade_5 22 4 15 0   0     0   1   20 22                       42 22 4 15 0   0     0   1   20 22                 42
1127280 1127280 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 Alfred J Gomes   Regular School No Elementary PK 05 2017   grade_5 16 11 42 0   0     0   2   32 39                       71 16 11 42 0   0     0   2   32 39                 71
1127288 1127288 MA Bristol   school 2508430 201   New Bedford 250843001333 2010070 John Hannigan   Regular School No Elementary PK 05 2017   grade_5 14 8 24 1   0     0   1   30 18                       48 14 8 24 1   0     0   1   30 18                 48
1127295 1127295 MA Bristol   school 2508430 201   New Bedford 250843001323 2010075 Ellen R Hathaway   Regular School No Elementary KG 05 2017   grade_5 10 7 22 0   0     1   2   22 20                       42 10 7 22 0   0     1   2   22 20                 42
1127303 1127303 MA Bristol   school 2508430 201   New Bedford 250843001327 2010078 Hayden/McFadden   Regular School No Elementary PK 05 2017   grade_5 29 5 41 1   1     0   6   46 37                       83 29 5 41 1   1     0   6   46 37                 83
1127310 1127310 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2017   grade_5 72 12 35 1   1     0   6   76 51                       127 72 12 35 1   1     0   6   76 51                 127
1127318 1127318 MA Bristol   school 2508430 201   New Bedford 250843001335 2010105 Carlos Pacheco   Regular School No Elementary PK 05 2017   grade_5 14 10 20 1   0     0   4   26 23                       49 14 10 20 1   0     0   4   26 23                 49
1127326 1127326 MA Bristol   school 2508430 201   New Bedford 250843001331 2010115 John Avery Parker   Regular School No Elementary PK 05 2017   grade_5 11 7 9 0   0     0   3   17 13                       30 11 7 9 0   0     0   3   17 13                 30
1127334 1127334 MA Bristol   school 2508430 201   New Bedford 250843001320 2010123 Casimir Pulaski   Regular School No Elementary PK 05 2017   grade_5 70 6 12 0   3     0   9   59 41                       100 70 6 12 0   3     0   9   59 41                 100
1127342 1127342 MA Bristol   school 2508430 201   New Bedford 250843002802 2010124 Renaissance Community School for the Arts   Regular School No Elementary PK 05 2017   grade_5 8 9 13 0   0     1   0   14 17                       31 8 9 13 0   0     1   0   14 17                 31
1127349 1127349 MA Bristol   school 2508430 201   New Bedford 250843001342 2010125 Thomas R Rodman   Regular School No Elementary KG 05 2017   grade_5 24 3 11 0   1     0   0   24 15                       39 24 3 11 0   1     0   0   24 15                 39
1127356 1127356 MA Bristol   school 2508430 201   New Bedford 250843001330 2010130 Jireh Swift   Regular School No Elementary KG 05 2017   grade_5 25 0 10 0   1     0   1   15 22                       37 25 0 10 0   1     0   1   15 22                 37
1127363 1127363 MA Bristol   school 2508430 201   New Bedford 250843001343 2010135 William H Taylor   Regular School No Elementary KG 05 2017   grade_5 23 2 6 0   0     0   0   17 14                       31 23 2 6 0   0     0   0   17 14                 31
1127370 1127370 MA Bristol   school 2508430 201   New Bedford 250843001319 2010140 Betsey B Winslow   Regular School No Elementary KG 05 2017   grade_5 19 2 2 0   0     0   3   10 16                       26 19 2 2 0   0     0   3   10 16                 26
1127684 1127684 MA Bristol   school 2508730 212   North Attleborough 250873001401 2120007 Amvet Boulevard   Regular School No Elementary KG 05 2017   grade_5 66 2 3 0   6     0   3   38 42                       80 66 2 3 0   6     0   3   38 42                 80
1127691 1127691 MA Bristol   school 2508730 212   North Attleborough 250873001402 2120010 Falls   Regular School No Elementary KG 05 2017   grade_5 41 0 1 0   2     0   2   20 26                       46 41 0 1 0   2     0   2   20 26                 46
1127698 1127698 MA Bristol   school 2508730 212   North Attleborough 250873001404 2120013 Joseph W Martin Jr Elementary   Regular School No Elementary KG 05 2017   grade_5 120 1 7 0   7     1   4   74 66                       140 120 1 7 0   7     1   4   74 66                 140
1127705 1127705 MA Bristol   school 2508730 212   North Attleborough 250873001408 2120015 Roosevelt Avenue   Regular School No Elementary KG 05 2017   grade_5 47 0 0 0   2     0   1   24 26                       50 47 0 0 0   2     0   1   24 26                 50
1127714 1127714 MA Bristol   school 2508730 212   North Attleborough 250873001199 2120030 Community   Regular School No Elementary KG 05 2017   grade_5 33 6 3 0   3     0   5   24 26                       50 33 6 3 0   3     0   5   24 26                 50
1127835 1127835 MA Bristol   school 2509000 218   Norton 250900001209 2180060 Henri A. Yelle   Regular School No Elementary 04 05 2017   grade_5 143 3 9 1   5     0   11   76 96                       172 143 3 9 1   5     0   11   76 96                 172
1128801 1128801 MA Bristol   school 2510590 265   Seekonk 251059001695 2650007 George R Martin   Regular School No Elementary KG 05 2017   grade_5 75 1 7 0   4     0   1   48 40                       88 75 1 7 0   4     0   1   48 40                 88
1128809 1128809 MA Bristol   school 2510590 265   Seekonk 251059001696 2650015 Mildred Aitken School   Regular School No Elementary PK 05 2017   grade_5 54 1 4 0   2     0   2   28 35                       63 54 1 4 0   2     0   2   28 35                 63
1128913 1128913 MA Bristol   school 2510860 273   Somerset 251086001723 2730005 Chace Street   Regular School No Elementary PK 05 2017   grade_5 61 0 1 0   0     0   0   30 32                       62 61 0 1 0   0     0   0   30 32                 62
1128920 1128920 MA Bristol   school 2510860 273   Somerset 251086002536 2730008 North Elementary   Regular School No Elementary KG 05 2017   grade_5 88 0 3 0   0     0   3   53 41                       94 88 0 3 0   0     0   3   53 41                 94
1128927 1128927 MA Bristol   school 2510860 273   Somerset 251086001727 2730015 South   Regular School No Elementary KG 05 2017   grade_5 40 0 3 0   0     0   1   24 20                       44 40 0 3 0   0     0   1   24 20                 44
1129621 1129621 MA Bristol   school 2511460 292   Swansea 251146001890 2920006 Elizabeth S Brown   Regular School No Elementary 03 05 2017   grade_5 107 0 2 0   0     0   0   56 53                       109 107 0 2 0   0     0   0   56 53                 109
1129634 1129634 MA Bristol   school 2511460 292   Swansea 251146001895 2920020 Joseph G Luther   Regular School No Elementary 03 05 2017   grade_5 67 1 3 0   1     0   1   42 31                       73 67 1 3 0   1     0   1   42 31                 73
1129683 1129683 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Joseph H Martin   Regular School No Middle 05 07 2017   grade_5 156 31 18 1   2     0   13   121 100                       221 156 31 18 1   2     0   13   121 100                 221
1129693 1129693 MA Bristol   school 2511520 293   Taunton 251152002416 2930305 John F Parker Middle   Regular School No Middle 05 07 2017   grade_5 88 36 26 1   2     0   16   87 82                       169 88 36 26 1   2     0   16   87 82                 169
1129697 1129697 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Benjamin Friedman Middle   Regular School No Middle 05 07 2017   grade_5 201 22 28 0   4     2   12   135 134                       269 201 22 28 0   4     2   12   135 134                 269
1130350 1130350 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport Elementary   Regular School No Elementary 03 06 2017   grade_5 133 0 8 0   0     0   6   76 71                       147 133 0 8 0   0     0   6   76 71                 147

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