Data source: Big Local News · About: Big Local

889 rows where grade = "grade_5", state = "MA" and year = 2021 sorted by county

View and edit SQL

year

  • 2021 · 889

grade

  • grade_5 · 889
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
1672317 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable - Barnstable United Elementary School   Regular School No Elementary 04 05 2021   grade_5 226 30 80 1   9     0   18   192 171 *                     364.0 226 30 80 1   9     0   18   192 171                 364
1673299 MA Barnstable   school 2502820 36   Bourne 250282002909 360030 Bourne - Bourne Intermediate School   Regular School No Elementary 03 05 2021   grade_5 126 5 15 1   2     0   6   69 86 *                     155.0 126 5 15 1   2     0   6   69 86                 155
1673366 MA Barnstable   school 2502970 41   Brewster 250297000841 410010 Brewster - Eddy Elementary   Regular School No Elementary 03 05 2021   grade_5 64 3 5 0   0     0   4   40 36 *                     76.0 64 3 5 0   0     0   4   40 36                 76
1674173 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham - Eastham Elementary   Regular School No Elementary PK 05 2021   grade_5 25 3 1 0   1     0   0   14 16 *                     30.0 25 3 1 0   1     0   0   14 16                 30
1674469 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Falmouth - Morse Pond School   Regular School No Middle 05 06 2021   grade_5 195 8 19 1   3     1   20   119 128 *                     247.0 195 8 19 1   3     1   20   119 128                 247
1676049 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Mashpee - Quashnet School   Regular School No Elementary 03 06 2021   grade_5 82 7 10 8   1     0   11   57 62 *                     119.0 82 7 10 8   1     0   11   57 62                 119
1677055 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans - Orleans Elementary   Regular School No Elementary KG 05 2021   grade_5 29 1 5 0   1     0   1   15 22 *                     37.0 29 1 5 0   1     0   1   15 22                 37
1677344 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown - Provincetown Schools   Regular School No Elementary PK 08 2021   grade_5 8 1 2 0   1     0   3   8 7 *                     15.0 8 1 2 0   1     0   3   8 7                 15
1677696 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Sandwich - Oak Ridge   Regular School No Elementary 03 06 2021   grade_5 173 2 8 0   7     2   0   99 93 *                     192.0 173 2 8 0   7     2   0   99 93                 192
1678603 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro - Truro Central   Regular School No Elementary PK 06 2021   grade_5 12 1 2 0   0     0   3   11 7 *                     18.0 12 1 2 0   0     0   3   11 7                 18
1678919 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet - Wellfleet Elementary   Regular School No Elementary KG 05 2021   grade_5 12 0 0 0   0     0   3   7 8 *                     15.0 12 0 0 0   0     0   3   7 8                 15
1680515 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 Dennis-Yarmouth - Nathaniel H. Wixon School   Regular School No Elementary 04 05 2021   grade_5 166 21 25 3   8     0   22   136 109 *                     245.0 166 21 25 3   8     0   22   136 109                 245
1680826 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional School District - Monomoy Regional Middle School   Regular School No Middle 05 07 2021   grade_5 116 11 13 1   5     0   7   88 65 *                     153.0 116 11 13 1   5     0   7   88 65                 153
1673915 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg - Clarksburg Elementary   Regular School No Elementary KG 08 2021   grade_5 20 0 1 0   0     0   1   8 14 *                     22.0 20 0 1 0   0     0   1   8 14                 22
1674529 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida - Abbott Memorial   Regular School No Elementary PK 08 2021   grade_5 6 0 0 0   0     0   0   4 2 *                     6.0 6 0 0 0   0     0   0   4 2                 6
1674851 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock - Hancock Elementary   Regular School No Elementary PK 06 2021   grade_5 6 0 0 0   0     0   0   4 2 *                     6.0 6 0 0 0   0     0   0   4 2                 6
1675321 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee - Lee Elementary   Regular School No Elementary PK 06 2021   grade_5 45 0 2 0   0     0   1   31 17 *                     48.0 45 0 2 0   0     0   1   31 17                 48
1675350 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Lenox - Morris   Regular School No Elementary PK 05 2021   grade_5 38 0 3 0   3     0   6   24 26 *                     50.0 38 0 3 0   3     0   6   24 26                 50
1676745 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 North Adams - Colegrove Park Elementary   Regular School No Elementary PK 06 2021   grade_5 31 1 4 0   0     0   1   24 13 *                     37.0 31 1 4 0   0     0   1   24 13                 37
1676753 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 North Adams - Greylock   Regular School No Elementary PK 06 2021   grade_5 23 0 2 0   0     0   1   9 17 *                     26.0 23 0 2 0   0     0   1   9 17                 26
1676761 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 North Adams - Brayton   Regular School No Elementary PK 06 2021   grade_5 22 3 2 0   0     0   2   14 15 *                     29.0 22 3 2 0   0     0   2   14 15                 29
1677193 MA Berkshire   school 2509630 236   Pittsfield 250963001516 2360010 Pittsfield - Allendale   Regular School No Elementary KG 05 2021   grade_5 23 5 4 0   1     0   4   15 22 *                     37.0 23 5 4 0   1     0   4   15 22                 37
1677202 MA Berkshire   school 2509630 236   Pittsfield 250963001519 2360035 Pittsfield - Egremont   Regular School No Elementary KG 05 2021   grade_5 44 2 18 0   1     0   4   36 33 *                     69.0 44 2 18 0   1     0   4   36 33                 69
1677208 MA Berkshire   school 2509630 236   Pittsfield 250963001522 2360045 Pittsfield - Robert T. Capeless Elementary School   Regular School No Elementary PK 05 2021   grade_5 19 1 1 0   0     0   3   11 13 *                     24.0 19 1 1 0   0     0   3   11 13                 24
1677215 MA Berkshire   school 2509630 236   Pittsfield 250963001524 2360055 Pittsfield - Morningside Community School   Regular School No Elementary PK 05 2021   grade_5 27 9 13 0   0     0   9   32 26 *                     58.0 27 9 13 0   0     0   9   32 26                 58
1677222 MA Berkshire   school 2509630 236   Pittsfield 250963001528 2360065 Pittsfield - Crosby   Regular School No Elementary PK 05 2021   grade_5 22 4 10 0   0     0   5   26 15 *                     41.0 22 4 10 0   0     0   5   26 15                 41
1677228 MA Berkshire   school 2509630 236   Pittsfield 250963002489 2360090 Pittsfield - Stearns   Regular School No Elementary KG 05 2021   grade_5 30 0 4 0   0     0   3   22 15 *                     37.0 30 0 4 0   0     0   3   22 15                 37
1677234 MA Berkshire   school 2509630 236   Pittsfield 250963001536 2360100 Pittsfield - Williams   Regular School No Elementary KG 05 2021   grade_5 36 3 4 0   2     0   2   25 22 *                     47.0 36 3 4 0   2     0   2   25 22                 47
1677241 MA Berkshire   school 2509630 236   Pittsfield 250963001535 2360105 Pittsfield - Silvio O Conte Community   Regular School No Elementary PK 05 2021   grade_5 10 11 10 0   0     0   6   19 18 *                     37.0 10 11 10 0   0     0   6   19 18                 37
1677578 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond - Richmond Consolidated   Regular School No Elementary PK 08 2021   grade_5 14 1 2 0   0     0   0   10 7 *                     17.0 14 1 2 0   0     0   0   10 7                 17
1677742 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Savoy - Emma L Miller Elementary School   Regular School No Elementary PK 06 2021   grade_5 * * * *   *     *   *   3 2 *                     5.0                         3 2                 5
1680300 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Regional - Hoosac Valley Middle School   Regular School No Middle 04 07 2021   grade_5 70 3 2 0   0     0   1   29 47 *                     76.0 70 3 2 0   0     0   1   29 47                 76
1680384 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Berkshire Hills - W.E.B. Du Bois Regional Middle School   Regular School No Middle 05 08 2021   grade_5 60 2 10 0   4     0   8   49 35 *                     84.0 60 2 10 0   4     0   8   49 35                 84
1680474 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Central Berkshire - Becket Washington School   Regular School No Elementary PK 05 2021   grade_5 16 0 0 0   0     0   0   7 9 *                     16.0 16 0 0 0   0     0   0   7 9                 16
1680480 MA Berkshire   school 2503390 635   Central Berkshire 250339000462 6350025 Central Berkshire - Craneville   Regular School No Elementary KG 05 2021   grade_5 58 0 3 0   0     0   1   31 31 *                     62.0 58 0 3 0   0     0   1   31 31                 62
1680487 MA Berkshire   school 2503390 635   Central Berkshire 250339000465 6350035 Central Berkshire - Kittredge   Regular School No Elementary PK 05 2021   grade_5 13 1 0 0   0     0   1   8 7 *                     15.0 13 1 0 0   0     0   1   8 7                 15
1680595 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Reg - Farmington River Elementary   Regular School No Elementary PK 06 2021   grade_5 10 0 0 0   0     0   0   4 6 *                     10.0 10 0 0 0   0     0   0   4 6                 10
1680840 MA Berkshire   school 2508160 715   Mount Greylock 250816002887 7150005 Mount Greylock - Lanesborough Elementary   Regular School No Elementary PK 06 2021   grade_5 21 1 0 0   0     0   1   8 15 *                     23.0 21 1 0 0   0     0   1   8 15                 23
1680848 MA Berkshire   school 2508160 715   Mount Greylock 250816002899 7150010 Mount Greylock - Williamstown Elementary   Regular School No Elementary PK 06 2021   grade_5 61 0 3 0   0     0   2   41 25 *                     66.0 61 0 3 0   0     0   2   41 25                 66
1681105 MA Berkshire   school 2511040 765   Southern Berkshire 251104000428 7650035 Southern Berkshire - Undermountain   Regular School No Elementary PK 05 2021   grade_5 36 0 6 0   0     0   2   22 22 *                     44.0 36 0 6 0   0     0   2   22 22                 44
1672029 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet - Albert F Ford Middle School   Regular School No Middle 05 08 2021   grade_5 96 0 3 0   1     0   8   57 51 *                     108.0 96 0 3 0   1     0   8   57 51                 108
1672243 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Attleboro - Robert J. Coelho Middle School   Regular School No Middle 05 08 2021   grade_5 96 11 17 0   9     1   13   87 60 *                     147.0 96 11 17 0   9     1   13   87 60                 147
1672247 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Attleboro - Cyril K. Brennan Middle School   Regular School No Middle 05 08 2021   grade_5 101 13 25 1   6     0   13   85 74 *                     159.0 101 13 25 1   6     0   13   85 74                 159
1672251 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Attleboro - Wamsutta Middle School   Regular School No Middle 05 08 2021   grade_5 91 8 26 0   11     0   14   76 74 *                     150.0 91 8 26 0   11     0   14   76 74                 150
1672411 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley - Berkley Middle School   Regular School No Middle 05 08 2021   grade_5 86 0 3 0   0     0   4   35 58 *                     93.0 86 0 3 0   0     0   4   35 58                 93
1674026 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Dartmouth - Joseph Demello   Regular School No Elementary 01 05 2021   grade_5 62 0 5 0   1     0   4   35 37 *                     72.0 62 0 5 0   1     0   4   35 37                 72
1674033 MA Bristol   school 2504020 72   Dartmouth 250402000542 720030 Dartmouth - George H Potter   Regular School No Elementary PK 05 2021   grade_5 57 0 2 0   0     0   3   40 22 *                     62.0 57 0 2 0   0     0   3   40 22                 62
1674039 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 Dartmouth - James M. Quinn School   Regular School No Elementary KG 05 2021   grade_5 82 2 5 0   3     0   10   58 44 *                     102.0 82 2 5 0   3     0   10   58 44                 102
1674229 MA Bristol   school 2504620 88   Easton 250462000983 880025 Easton - Richardson Olmsted School   Regular School No Elementary 03 05 2021   grade_5 213 19 16 2   6     0   15   150 121 *                     271.0 213 19 16 2   6     0   15   150 121                 271
1674329 MA Bristol   school 2504800 94   Fairhaven 250480000640 940010 Fairhaven - East Fairhaven   Regular School No Elementary PK 05 2021   grade_5 57 4 4 1   0     0   2   37 31 *                     68.0 57 4 4 1   0     0   2   37 31                 68
1674336 MA Bristol   school 2504800 94   Fairhaven 250480000645 940030 Fairhaven - Leroy Wood   Regular School No Elementary PK 05 2021   grade_5 64 2 4 0   1     0   3   37 37 *                     74.0 64 2 4 0   1     0   3   37 37                 74
1674351 MA Bristol   school 2504830 95   Fall River 250483001780 950005 Fall River - North End Elementary   Regular School No Elementary PK 05 2021   grade_5 80 7 31 0   3     0   10   68 63 *                     131.0 80 7 31 0   3     0   10   68 63                 131
1674357 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Fall River - Carlton M. Viveiros Elementary School   Regular School No Elementary KG 05 2021   grade_5 63 16 45 0   6     0   12   65 77 *                     142.0 63 16 45 0   6     0   12   65 77                 142
1674364 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Fall River - Mary Fonseca Elementary School   Regular School No Elementary PK 05 2021   grade_5 39 13 44 0   4     0   8   61 47 *                     108.0 39 13 44 0   4     0   8   61 47                 108
1674371 MA Bristol   school 2504830 95   Fall River 250483002656 950013 Fall River - Letourneau Elementary School   Regular School No Elementary PK 05 2021   grade_5 48 8 38 0   1     0   4   44 55 *                     99.0 48 8 38 0   1     0   4   44 55                 99
1674378 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Fall River - Henry Lord Community School   Regular School No Elementary PK 08 2021   grade_5 32 9 18 0   4     0   5   35 33 *                     68.0 32 9 18 0   4     0   5   35 33                 68
1674388 MA Bristol   school 2504830 95   Fall River 250483000666 950045 Fall River - John J Doran   Regular School No Elementary PK 08 2021   grade_5 25 7 17 0   0     0   6   30 25 *                     55.0 25 7 17 0   0     0   6   30 25                 55
1674398 MA Bristol   school 2504830 95   Fall River 250483000684 950065 Fall River - William S Greene   Regular School No Elementary PK 05 2021   grade_5 66 6 28 0   7     0   16   62 61 *                     123.0 66 6 28 0   7     0   16   62 61                 123
1674405 MA Bristol   school 2504830 95   Fall River 250483000679 950130 Fall River - Spencer Borden   Regular School No Elementary PK 05 2021   grade_5 51 6 21 0   2     0   4   49 35 *                     84.0 51 6 21 0   2     0   4   49 35                 84
1674411 MA Bristol   school 2504830 95   Fall River 250483000665 950140 Fall River - James Tansey   Regular School No Elementary KG 05 2021   grade_5 40 1 3 0   0     0   4   26 22 *                     48.0 40 1 3 0   0     0   4   26 22                 48
1674417 MA Bristol   school 2504830 95   Fall River 250483000677 950145 Fall River - Samuel Watson   Regular School No Elementary KG 05 2021   grade_5 17 6 9 0   1     0   4   18 19 *                     37.0 17 6 9 0   1     0   4   18 19                 37
1674429 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River - Stone PK-12 School   Regular School No Other 01 12 2021   grade_5 6 0 0 0   0     0   1   6 1 *                     7.0 6 0 0 0   0     0   1   6 1                 7
1675933 MA Bristol   school 2507230 167   Mansfield 250723001365 1670014 Mansfield - Jordan/Jackson Elementary   Regular School No Elementary 03 05 2021   grade_5 191 11 22 0   27     0   17   155 113 *                     268.0 191 11 22 0   27     0   17   155 113                 268
1676457 MA Bristol   school 2508430 201   New Bedford 250843001321 2010010 New Bedford - Charles S Ashley   Regular School No Elementary KG 05 2021   grade_5 20 3 12 0   0     0   1   19 17 *                     36.0 20 3 12 0   0     0   1   19 17                 36
1676463 MA Bristol   school 2508430 201   New Bedford 250843001322 2010015 New Bedford - Elizabeth Carter Brooks   Regular School No Elementary KG 05 2021   grade_5 11 2 9 0   0     0   5   19 8 *                     27.0 11 2 9 0   0     0   5   19 8                 27
1676470 MA Bristol   school 2508430 201   New Bedford 250843001324 2010020 New Bedford - Elwyn G Campbell   Regular School No Elementary PK 05 2021   grade_5 14 1 8 0   2     0   1   16 10 *                     26.0 14 1 8 0   2     0   1   16 10                 26
1676476 MA Bristol   school 2508430 201   New Bedford 250843001329 2010040 New Bedford - James B Congdon   Regular School No Elementary KG 05 2021   grade_5 21 9 16 0   0     0   3   23 26 *                     49.0 21 9 16 0   0     0   3   23 26                 49
1676483 MA Bristol   school 2508430 201   New Bedford 250843001341 2010045 New Bedford - Sgt Wm H Carney Academy   Regular School No Elementary PK 05 2021   grade_5 47 20 43 0   1     0   19   72 58 *                     130.0 47 20 43 0   1     0   19   72 58                 130
1676489 MA Bristol   school 2508430 201   New Bedford 250843001332 2010050 New Bedford - John B Devalles   Regular School No Elementary KG 05 2021   grade_5 15 11 31 0   0     0   2   34 25 *                     59.0 15 11 31 0   0     0   2   34 25                 59
1676495 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 New Bedford - Alfred J Gomes   Regular School No Elementary KG 05 2021   grade_5 16 12 54 1   0     0   2   41 44 *                     85.0 16 12 54 1   0     0   2   41 44                 85
1676502 MA Bristol   school 2508430 201   New Bedford 250843001333 2010070 New Bedford - Irwin M. Jacobs Elementary School   Regular School No Elementary PK 05 2021   grade_5 12 3 31 0   0     0   0   24 22 *                     46.0 12 3 31 0   0     0   0   24 22                 46
1676509 MA Bristol   school 2508430 201   New Bedford 250843001323 2010075 New Bedford - Ellen R Hathaway   Regular School No Elementary PK 05 2021   grade_5 9 5 20 0   0     1   2   22 15 *                     37.0 9 5 20 0   0     1   2   22 15                 37
1676516 MA Bristol   school 2508430 201   New Bedford 250843001327 2010078 New Bedford - Hayden/McFadden   Regular School No Elementary PK 05 2021   grade_5 20 10 63 0   0     0   2   45 50 *                     95.0 20 10 63 0   0     0   2   45 50                 95
1676522 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 New Bedford - Abraham Lincoln   Regular School No Elementary KG 05 2021   grade_5 63 9 29 0   1     0   4   52 54 *                     106.0 63 9 29 0   1     0   4   52 54                 106
1676529 MA Bristol   school 2508430 201   New Bedford 250843001335 2010105 New Bedford - Carlos Pacheco   Regular School No Elementary KG 05 2021   grade_5 30 14 33 2   0     0   2   45 36 *                     81.0 30 14 33 2   0     0   2   45 36                 81
1676536 MA Bristol   school 2508430 201   New Bedford 250843001331 2010115 New Bedford - John Avery Parker   Regular School No Elementary PK 05 2021   grade_5 12 6 8 1   0     0   4   17 14 *                     31.0 12 6 8 1   0     0   4   17 14                 31
1676543 MA Bristol   school 2508430 201   New Bedford 250843001320 2010123 New Bedford - Casimir Pulaski   Regular School No Elementary PK 05 2021   grade_5 63 5 11 0   1     0   6   55 31 *                     86.0 63 5 11 0   1     0   6   55 31                 86
1676550 MA Bristol   school 2508430 201   New Bedford 250843002802 2010124 New Bedford - Renaissance Community Innovation School   Regular School No Elementary PK 05 2021   grade_5 11 7 22 0   0     0   2   23 19 *                     42.0 11 7 22 0   0     0   2   23 19                 42
1676556 MA Bristol   school 2508430 201   New Bedford 250843001342 2010125 New Bedford - Thomas R Rodman   Regular School No Elementary KG 05 2021   grade_5 10 0 4 0   0     0   2   6 10 *                     16.0 10 0 4 0   0     0   2   6 10                 16
1676563 MA Bristol   school 2508430 201   New Bedford 250843001330 2010130 New Bedford - Jireh Swift   Regular School No Elementary PK 05 2021   grade_5 22 2 4 0   0     0   3   16 15 *                     31.0 22 2 4 0   0     0   3   16 15                 31
1676570 MA Bristol   school 2508430 201   New Bedford 250843001343 2010135 New Bedford - William H Taylor   Regular School No Elementary PK 05 2021   grade_5 20 1 4 0   0     0   4   14 15 *                     29.0 20 1 4 0   0     0   4   14 15                 29
1676576 MA Bristol   school 2508430 201   New Bedford 250843001319 2010140 New Bedford - Betsey B Winslow   Regular School No Elementary KG 05 2021   grade_5 16 0 5 1   1     0   2   15 10 *                     25.0 16 0 5 1   1     0   2   15 10                 25
1676590 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 New Bedford - Trinity Day Academy   Regular School No Other 04 12 2021   grade_5 4 1 7 0   0     0   0   10 2 *                     12.0 4 1 7 0   0     0   0   10 2                 12
1676841 MA Bristol   school 2508730 212   North Attleborough 250873001401 2120007 North Attleborough - Amvet Boulevard   Regular School No Elementary KG 05 2021   grade_5 63 5 2 0   12     0   3   46 39 *                     85.0 63 5 2 0   12     0   3   46 39                 85
1676847 MA Bristol   school 2508730 212   North Attleborough 250873001402 2120010 North Attleborough - Falls   Regular School No Elementary KG 05 2021   grade_5 40 1 1 0   1     0   2   25 20 *                     45.0 40 1 1 0   1     0   2   25 20                 45
1676853 MA Bristol   school 2508730 212   North Attleborough 250873001404 2120013 North Attleborough - Joseph W Martin Jr Elementary   Regular School No Elementary KG 05 2021   grade_5 87 4 7 0   6     0   8   63 49 *                     112.0 87 4 7 0   6     0   8   63 49                 112
1676859 MA Bristol   school 2508730 212   North Attleborough 250873001408 2120015 North Attleborough - Roosevelt Avenue   Regular School No Elementary KG 05 2021   grade_5 30 1 0 0   1     0   4   15 21 *                     36.0 30 1 0 0   1     0   4   15 21                 36
1676866 MA Bristol   school 2508730 212   North Attleborough 250873001199 2120030 North Attleborough - Community   Regular School No Elementary KG 05 2021   grade_5 34 9 2 0   3     0   4   27 25 *                     52.0 34 9 2 0   3     0   4   27 25                 52
1676966 MA Bristol   school 2509000 218   Norton 250900001209 2180060 Norton - Henri A. Yelle   Regular School No Elementary 04 05 2021   grade_5 152 1 6 0   3     1   9   93 79 *                     172.0 152 1 6 0   3     1   9   93 79                 172
1677782 MA Bristol   school 2510590 265   Seekonk 251059001695 2650007 Seekonk - George R Martin   Regular School No Elementary PK 05 2021   grade_5 60 4 7 0   2     0   4   34 43 *                     77.0 60 4 7 0   2     0   4   34 43                 77
1677789 MA Bristol   school 2510590 265   Seekonk 251059001696 2650015 Seekonk - Mildred Aitken School   Regular School No Elementary PK 05 2021   grade_5 61 2 3 0   2     0   4   36 36 *                     72.0 61 2 3 0   2     0   4   36 36                 72
1677873 MA Bristol   school 2510860 273   Somerset 251086001723 2730005 Somerset - Chace Street   Regular School No Elementary KG 05 2021   grade_5 52 0 4 0   1     0   2   31 28 *                     59.0 52 0 4 0   1     0   2   31 28                 59
1677880 MA Bristol   school 2510860 273   Somerset 251086002536 2730008 Somerset - North Elementary   Regular School No Elementary PK 05 2021   grade_5 60 0 3 0   0     0   2   38 27 *                     65.0 60 0 3 0   0     0   2   38 27                 65
1677886 MA Bristol   school 2510860 273   Somerset 251086001727 2730015 Somerset - South   Regular School No Elementary KG 05 2021   grade_5 32 0 2 0   0     0   2   17 19 *                     36.0 32 0 2 0   0     0   2   17 19                 36
1678491 MA Bristol   school 2511460 292   Swansea 251146001890 2920006 Swansea - Elizabeth S Brown   Regular School No Elementary 03 05 2021   grade_5 90 0 2 0   0     0   0   47 45 *                     92.0 90 0 2 0   0     0   0   47 45                 92
1678501 MA Bristol   school 2511460 292   Swansea 251146001895 2920020 Swansea - Joseph G Luther   Regular School No Elementary 03 05 2021   grade_5 47 1 3 0   1     0   0   25 27 *                     52.0 47 1 3 0   1     0   0   25 27                 52
1678537 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Taunton - Joseph H Martin   Regular School No Middle 05 07 2021   grade_5 124 40 32 0   3     0   11   100 110 *                     210.0 124 40 32 0   3     0   11   100 110                 210
1678545 MA Bristol   school 2511520 293   Taunton 251152002416 2930305 Taunton - John F Parker Middle   Regular School No Middle 05 07 2021   grade_5 84 38 25 0   0     0   15   83 79 *                     162.0 84 38 25 0   0     0   15   83 79                 162
1678548 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Taunton - Benjamin Friedman Middle   Regular School No Middle 05 07 2021   grade_5 167 33 20 0   2     0   18   136 104 *                     240.0 167 33 20 0   2     0   18   136 104                 240
1679080 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport - Westport Elementary   Regular School No Elementary 03 06 2021   grade_5 113 1 6 0   0     0   3   76 47 *                     123.0 113 1 6 0   0     0   3   76 47                 123

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