Data source: Big Local News · About: Big Local

976 rows where grade = "grade_3", state = "MA" and year = 2018 sorted by total

View and edit SQL

year

  • 2018 · 976

grade

  • grade_3 · 976
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
2230206 MA Suffolk   school   35   Boston   350652               2018   grade_3 * * * *   *     *   *   * *                       0.0                                             0
2231640 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   grade_3 * * * *   *     *   *   * *                       0.0                                             0
2232018 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_3 * * * *   *     *   *   * *                       0.0                                             0
2237224 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_3 * * * *   *     *   *   * *                       0.0                                             0
2235438 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe: Rowe Elementary   Regular School No Elementary PK 06 2018   grade_3 9 0 1 0   0     0   0   6 4                       10.0 9 0 1 0   0     0   0   6 4                 10
2235573 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Savoy: Emma L Miller Elementary School   Regular School No Elementary PK 05 2018   grade_3 10 0 0 0   0     0   0   4 6                       10.0 10 0 0 0   0     0   0   4 6                 10
2239635 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Up-Island Regional: Chilmark Elementary   Regular School No Elementary KG 05 2018   grade_3 7 0 1 0   0     0   2   6 4                       10.0 7 0 1 0   0     0   2   6 4                 10
2230872 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Chelmsford: Byam School   Regular School No Elementary KG 04 2018   grade_3 78 0 5 1   8     0   8   52 48                       100.0 78 0 5 1   8     0   8   52 48                 100
2233243 MA Essex   school 2507110 163   Lynn 250711001074 1630055 Lynn: Hood   Regular School No Elementary KG 05 2018   grade_3 14 11 66 0   6     0   3   50 50                       100.0 14 11 66 0   6     0   3   50 50                 100
2233349 MA Essex   school 2507140 164   Lynnfield 250714001093 1640020 Lynnfield: Summer Street   Regular School No Elementary KG 04 2018   grade_3 84 1 6 0   5     0   4   59 41                       100.0 84 1 6 0   5     0   4   59 41                 100
2234081 MA Bristol   school 2508430 201   New Bedford 250843001341 2010045 New Bedford: Sgt Wm H Carney Academy   Regular School No Elementary PK 05 2018   grade_3 34 23 36 0   1     0   6   62 38                       100.0 34 23 36 0   1     0   6   62 38                 100
2234791 MA Hampden   school 2509300 227   Palmer 250930002594 2270008 Palmer: Old Mill Pond   Regular School No Elementary PK 05 2018   grade_3 73 3 18 0   3     0   3   52 48                       100.0 73 3 18 0   3     0   3   52 48                 100
2232833 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Lexington: Bridge   Regular School No Elementary KG 05 2018   grade_3 47 7 3 0   44     0   0   53 48                       101.0 47 7 3 0   44     0   0   53 48                 101
2233375 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Malden: Ferryway   Regular School No Elementary KG 08 2018   grade_3 29 21 31 0   15     0   5   45 56                       101.0 29 21 31 0   15     0   5   45 56                 101
2234653 MA Bristol   school 2509000 218   Norton 250900001449 2180015 Norton: J C Solmonese   Regular School No Elementary PK 03 2018   grade_3 90 1 2 3   1     0   4   47 54                       101.0 90 1 2 3   1     0   4   47 54                 101
2232728 MA Worcester   school 2506720 151   Leicester 250672000971 1510005 Leicester: Leicester Memorial Elementary   Regular School No Elementary 03 05 2018   grade_3 81 5 8 2   3     0   3   50 52                       102.0 81 5 8 2   3     0   3   50 52                 102
2233027 MA Middlesex   school 2507020 160   Lowell 250702001044 1600036 Lowell: Pawtucketville Memorial   Regular School No Elementary PK 04 2018   grade_3 34 10 27 0   26     0   5   55 47                       102.0 34 10 27 0   26     0   5   55 47                 102
2234481 MA Essex   school 2508700 211   North Andover 250870000767 2110018 North Andover: Annie L Sargent School   Regular School No Elementary KG 05 2018   grade_3 86 2 4 1   6     0   3   57 45                       102.0 86 2 4 1   6     0   3   57 45                 102
2237768 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Worcester: Quinsigamond   Regular School No Elementary PK 06 2018   grade_3 32 28 30 0   8     0   4   54 48                       102.0 32 28 30 0   8     0   4   54 48                 102
2238935 MA Bristol   school 2505070 665   Freetown-Lakeville 250507002739 6650002 Freetown-Lakeville: Assawompset Elementary School   Regular School No Elementary KG 03 2018   grade_3 96 3 0 0   1     0   2   64 38                       102.0 96 3 0 0   1     0   2   64 38                 102
2239703 MA Worcester   school 2511880 775   Wachusett 251188002131 7750060 Wachusett: Glenwood Elementary School   Regular School No Elementary 03 05 2018   grade_3 90 3 3 2   1     0   3   49 53                       102.0 90 3 3 2   1     0   3   49 53                 102
2232981 MA Middlesex   school 2507020 160   Lowell 250702000477 1600010 Lowell: Joseph McAvinnue   Regular School No Elementary PK 04 2018   grade_3 28 4 52 0   18     0   1   55 48                       103.0 28 4 52 0   18     0   1   55 48                 103
2233214 MA Essex   school 2507110 163   Lynn 250711001068 1630035 Lynn: Cobbet Elementary   Regular School No Elementary KG 05 2018   grade_3 2 8 87 0   5     0   1   51 52                       103.0 2 8 87 0   5     0   1   51 52                 103
2233858 MA Norfolk   school 2507920 187   Millis 250792001252 1870005 Millis: Clyde F Brown   Regular School No Elementary PK 04 2018   grade_3 89 1 7 0   1     0   5   51 52                       103.0 89 1 7 0   1     0   5   51 52                 103
2234150 MA Bristol   school 2508430 201   New Bedford 250843001320 2010123 New Bedford: Casimir Pulaski   Regular School No Elementary PK 05 2018   grade_3 68 9 16 0   0     0   10   50 53                       103.0 68 9 16 0   0     0   10   50 53                 103
2234299 MA Middlesex   school 2508610 207   Newton 250861001371 2070080 Newton: Mason-Rice   Regular School No Elementary KG 05 2018   grade_3 65 4 5 0   21     0   8   58 45                       103.0 65 4 5 0   21     0   8   58 45                 103
2236042 MA Hampden   school 2511130 281   Springfield 251113001810 2810100 Springfield: Indian Orchard Elementary   Regular School No Elementary PK 05 2018   grade_3 11 18 68 0   3     0   3   56 47                       103.0 11 18 68 0   3     0   3   56 47                 103
2236543 MA Middlesex   school 2511580 295   Tewksbury 251158001924 2950025 Tewksbury: Louise Davy Trahan   Regular School No Elementary 03 04 2018   grade_3 93 2 4 0   1     0   3   49 54                       103.0 93 2 4 0   1     0   3   49 54                 103
2230428 MA Plymouth   school 2503090 44   Brockton 250309000401 440017 Brockton: John F Kennedy   Regular School No Elementary KG 05 2018   grade_3 31 52 6 0   3     0   12   56 48                       104.0 31 52 6 0   3     0   12   56 48                 104
2237379 MA Middlesex   school 2513050 342   Wilmington 251305002159 3420020 Wilmington: Woburn Street   Regular School No Elementary 01 03 2018   grade_3 89 0 6 0   5     0   4   57 47                       104.0 89 0 6 0   5     0   4   57 47                 104
2239194 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Monomoy Regional School District: Harwich Elementary School   Regular School No Elementary PK 04 2018   grade_3 86 2 7 1   0     0   8   49 55                       104.0 86 2 7 1   0     0   8   49 55                 104
2228777 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet: Acushnet Elementary School   Regular School No Elementary PK 04 2018   grade_3 96 0 7 0   0     0   2   46 59                       105.0 96 0 7 0   0     0   2   46 59                 105
2230972 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Chicopee: Litwin   Regular School No Elementary KG 05 2018   grade_3 59 5 38 1   0     0   2   56 49                       105.0 59 5 38 1   0     0   2   56 49                 105
2232636 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Lawrence: Francis M Leahy   Regular School No Elementary KG 05 2018   grade_3 3 1 101 0   0     0   0   55 50                       105.0 3 1 101 0   0     0   0   55 50                 105
2233644 MA Middlesex   school 2507560 176   Medford 250756002062 1760150 Medford: Milton Fuller Roberts   Regular School No Elementary PK 05 2018   grade_3 68 14 10 0   10     0   3   56 49                       105.0 68 14 10 0   10     0   3   56 49                 105
2233782 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Middleborough: Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2018   grade_3 89 2 2 0   2     1   9   67 38                       105.0 89 2 2 0   2     1   9   67 38                 105
2238825 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Dennis-Yarmouth: Station Avenue Elementary   Regular School No Elementary KG 03 2018   grade_3 78 9 4 2   1     0   11   52 53                       105.0 78 9 4 2   1     0   11   52 53                 105
2238450 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District): Atlantis Charter School   Regular School Yes Other KG 12 2018   grade_3 89 5 5 0   2     0   5   47 59                       106.0 89 5 5 0   2     0   5   47 59                 106
2238583 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000023 6030020 Adams-Cheshire: Hoosac Valley Elementary School   Regular School No Elementary PK 03 2018   grade_3 92 5 3 0   1     1   4   54 52                       106.0 92 5 3 0   1     1   4   54 52                 106
2229470 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Boston: Charles H Taylor   Regular School No Elementary PK 05 2018   grade_3 0 90 11 1   1     0   4   56 51                       107.0 0 90 11 1   1     0   4   56 51                 107
2229740 MA Suffolk   school 2502790 35   Boston 250279000289 350227 Boston: Mather   Regular School No Elementary PK 05 2018   grade_3 5 43 16 0   35     0   8   59 48                       107.0 5 43 16 0   35     0   8   59 48                 107
2233250 MA Essex   school 2507110 163   Lynn 250711001075 1630060 Lynn: Ingalls   Regular School No Elementary KG 05 2018   grade_3 5 16 77 0   6     1   2   50 57                       107.0 5 16 77 0   6     1   2   50 57                 107
2235346 MA Suffolk   school 2510050 248   Revere 251005001975 2480056 Revere: Garfield Elementary School   Regular School No Elementary PK 05 2018   grade_3 20 4 71 0   12     0   0   52 55                       107.0 20 4 71 0   12     0   0   52 55                 107
2238849 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002428 6500010 Dighton-Rehoboth: Palmer River   Regular School No Elementary KG 04 2018   grade_3 93 2 5 0   2     0   5   49 58                       107.0 93 2 5 0   2     0   5   49 58                 107
2239284 MA Worcester   school 2508310 725   Nashoba 250831000362 7250020 Nashoba: Center School   Regular School No Elementary PK 05 2018   grade_3 93 2 2 0   7     0   3   53 54                       107.0 93 2 2 0   7     0   3   53 54                 107
2230605 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Brookline: Pierce   Regular School No Elementary KG 08 2018   grade_3 49 1 12 0   36     0   10   54 54                       108.0 49 1 12 0   36     0   10   54 54                 108
2236394 MA Worcester   school 2511400 290   Sutton 251140001879 2900005 Sutton: Sutton Elementary   Regular School No Elementary 03 05 2018   grade_3 96 1 2 0   3     0   6   57 51                       108.0 96 1 2 0   3     0   6   57 51                 108
2236587 MA Middlesex   school 2511760 301   Tyngsborough 251176001714 3010020 Tyngsborough: Tyngsborough Elementary   Regular School No Elementary PK 05 2018   grade_3 90 6 2 0   7     0   3   61 47                       108.0 90 6 2 0   7     0   3   61 47                 108
2230866 MA Middlesex   school 2503510 56   Chelmsford 250351000474 560025 Chelmsford: Charles D Harrington   Regular School No Elementary KG 04 2018   grade_3 74 5 7 0   20     0   3   62 47                       109.0 74 5 7 0   20     0   3   62 47                 109
2232972 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Lowell: Rogers STEM Academy   Regular School No Elementary PK 06 2018   grade_3 24 9 41 0   28     0   7   47 62                       109.0 24 9 41 0   28     0   7   47 62                 109
2237104 MA Middlesex   school 2512660 326   Westford 251266001737 3260045 Westford: John A. Crisafulli Elementary School   Regular School No Elementary 03 05 2018   grade_3 62 4 4 0   35     0   4   48 61                       109.0 62 4 4 0   35     0   4   48 61                 109
2238992 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000808 6730010 Groton-Dunstable: Florence Roche School   Regular School No Elementary KG 04 2018   grade_3 92 1 2 0   11     1   2   50 59                       109.0 92 1 2 0   11     1   2   50 59                 109
2239770 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Whitman-Hanson: Indian Head   Regular School No Elementary 03 05 2018   grade_3 99 0 6 0   2     0   2   59 50                       109.0 99 0 6 0   2     0   2   59 50                 109
2231428 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving: Erving Elementary   Regular School No Elementary PK 06 2018   grade_3 8 0 0 0   0     0   3   3 8                       11.0 8 0 0 0   0     0   3   3 8                 11
2238921 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Reg: Farmington River Elementary   Regular School No Elementary PK 06 2018   grade_3 11 0 0 0   0     0   0   6 5                       11.0 11 0 0 0   0     0   0   6 5                 11
2239434 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Pioneer Valley: Warwick Community School   Regular School No Elementary PK 06 2018   grade_3 9 0 1 0   0     0   1   5 6                       11.0 9 0 1 0   0     0   1   5 6                 11
2233395 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Malden: Linden   Regular School No Elementary KG 08 2018   grade_3 45 23 18 0   20     0   4   56 54                       110.0 45 23 18 0   20     0   4   56 54                 110
2233487 MA Middlesex   school 2507320 170   Marlborough 250732001135 1700025 Marlborough: Richer   Regular School No Elementary KG 04 2018   grade_3 35 6 62 0   1     0   6   55 55                       110.0 35 6 62 0   1     0   6   55 55                 110
2233788 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Middleborough: Mary K. Goode Elementary School   Regular School No Elementary 01 05 2018   grade_3 101 4 3 1   0     0   1   46 64                       110.0 101 4 3 1   0     0   1   46 64                 110
2237182 MA Hampden   school 2512510 332   West Springfield 251251001242 3320007 West Springfield: Philip G Coburn   Regular School No Elementary KG 05 2018   grade_3 72 3 18 0   14     0   3   55 55                       110.0 72 3 18 0   14     0   3   55 55                 110
2229602 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Boston: James Condon Elementary   Regular School No Elementary PK 08 2018   grade_3 28 33 31 0   15     0   4   56 55                       111.0 28 33 31 0   15     0   4   56 55                 111
2230477 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Brockton: Downey   Regular School No Elementary KG 05 2018   grade_3 15 67 19 0   1     1   8   55 56                       111.0 15 67 19 0   1     1   8   55 56                 111
2230543 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Brookline: Edith C Baker   Regular School No Elementary KG 08 2018   grade_3 54 6 8 0   38     0   5   57 54                       111.0 54 6 8 0   38     0   5   57 54                 111
2235331 MA Suffolk   school 2510050 248   Revere 251005001633 2480035 Revere: Staff Sargent James J. Hill Elementary School   Regular School No Elementary KG 05 2018   grade_3 29 2 75 0   3     0   2   51 60                       111.0 29 2 75 0   3     0   2   51 60                 111
2237383 MA Middlesex   school 2513050 342   Wilmington 251305002153 3420025 Wilmington: Shawsheen Elementary   Regular School No Elementary 01 03 2018   grade_3 90 2 9 0   5     0   5   56 55                       111.0 90 2 9 0   5     0   5   56 55                 111
2239348 MA Middlesex   school 2508790 735   North Middlesex 250879002281 7350035 North Middlesex: Varnum Brook   Regular School No Elementary KG 04 2018   grade_3 102 1 4 0   0     0   4   60 51                       111.0 102 1 4 0   0     0   4   60 51                 111
2231169 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 Dartmouth: James M. Quinn School   Regular School No Elementary KG 05 2018   grade_3 96 2 7 0   1     0   6   59 53                       112.0 96 2 7 0   1     0   6   59 53                 112
2231698 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Fitchburg: Crocker Elementary   Regular School No Elementary PK 04 2018   grade_3 44 4 53 0   2     1   8   57 55                       112.0 44 4 53 0   2     1   8   57 55                 112
2235055 MA Plymouth   school 2509720 239   Plymouth 250972001547 2390046 Plymouth: South Elementary   Regular School No Elementary KG 05 2018   grade_3 100 4 3 0   0     0   5   64 48                       112.0 100 4 3 0   0     0   5   64 48                 112
2236342 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Sturbridge: Burgess Elementary   Regular School No Elementary PK 06 2018   grade_3 100 0 3 2   3     0   4   64 48                       112.0 100 0 3 2   3     0   4   64 48                 112
2228909 MA Essex   school 2501950 9   Andover 250195000051 90025 Andover: West Elementary   Regular School No Elementary KG 05 2018   grade_3 87 1 5 0   16     0   4   53 60                       113.0 87 1 5 0   16     0   4   53 60                 113
2235048 MA Plymouth   school 2509720 239   Plymouth 250972001545 2390030 Plymouth: Nathaniel Morton Elementary   Regular School No Elementary KG 05 2018   grade_3 96 0 4 0   2     0   11   57 56                       113.0 96 0 4 0   2     0   11   57 56                 113
2234127 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 New Bedford: Abraham Lincoln   Regular School No Elementary KG 05 2018   grade_3 61 11 35 0   0     0   7   59 55                       114.0 61 11 35 0   0     0   7   59 55                 114
2234373 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Norfolk: Freeman-Kennedy School   Regular School No Elementary 03 06 2018   grade_3 103 0 7 0   3     0   1   66 48                       114.0 103 0 7 0   3     0   1   66 48                 114
2239547 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Southwick-Tolland-Granville Regional School District: Powder Mill School   Regular School No Elementary 03 06 2018   grade_3 100 1 7 1   0     0   5   61 53                       114.0 100 1 7 1   0     0   5   61 53                 114
2230445 MA Plymouth   school 2503090 44   Brockton 250309000396 440045 Brockton: Hancock   Regular School No Elementary KG 05 2018   grade_3 48 48 7 1   5     1   5   51 64                       115.0 48 48 7 1   5     1   5   51 64                 115
2230837 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver: Carver Elementary School   Regular School No Elementary PK 05 2018   grade_3 108 4 1 1   1     0   0   48 67                       115.0 108 4 1 1   1     0   0   48 67                 115
2230421 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brockton: Brookfield   Regular School No Elementary KG 05 2018   grade_3 24 71 13 0   2     1   5   62 54                       116.0 24 71 13 0   2     1   5   62 54                 116
2231588 MA Bristol   school 2504830 95   Fall River 250483000684 950065 Fall River: William S Greene   Regular School No Elementary PK 05 2018   grade_3 66 4 27 0   5     0   14   60 56                       116.0 66 4 27 0   5     0   14   60 56                 116
2233560 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Mashpee: Quashnet School   Regular School No Elementary 03 06 2018   grade_3 84 2 8 9   1     0   12   54 62                       116.0 84 2 8 9   1     0   12   54 62                 116
2229810 MA Suffolk   school 2502790 35   Boston 250279000339 350258 Boston: William H Ohrenberger   Regular School No Middle 03 08 2018   grade_3 38 32 40 0   6     0   1   57 60                       117.0 38 32 40 0   6     0   1   57 60                 117
2233157 MA Worcester   school 2507080 162   Lunenburg 250708002871 1620025 Lunenburg: Turkey Hill Elementary School   Regular School No Elementary 03 05 2018   grade_3 98 0 9 1   0     1   8   57 60                       117.0 98 0 9 1   0     1   8   57 60                 117
2238161 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public (District): Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2018   grade_3 26 62 18 0   3     0   8   63 54                       117.0 26 62 18 0   3     0   8   63 54                 117
2238364 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public (District): Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2018   grade_3 1 84 28 0   0     0   4   61 56                       117.0 1 84 28 0   0     0   4   61 56                 117
2229123 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 Barnstable: West Villages Elementary School   Regular School No Elementary KG 03 2018   grade_3 109 3 3 1   0     0   2   54 64                       118.0 109 3 3 1   0     0   2   54 64                 118
2229225 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Belmont: Roger E Wellington   Regular School No Elementary PK 04 2018   grade_3 93 3 1 0   14     0   7   61 57                       118.0 93 3 1 0   14     0   7   61 57                 118
2230435 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton: Edgar B Davis   Regular School No Elementary KG 08 2018   grade_3 16 74 18 1   1     2   6   54 64                       118.0 16 74 18 1   1     2   6   54 64                 118
2233958 MA Middlesex   school 2508340 198   Natick 250834001291 1980005 Natick: Bennett-Hemenway   Regular School No Elementary KG 04 2018   grade_3 87 2 4 0   18     1   6   67 51                       118.0 87 2 4 0   18     1   6   67 51                 118
2235135 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Quincy: Clifford H Marshall Elementary   Regular School No Elementary KG 04 2018   grade_3 32 14 15 0   48     7   2   54 64                       118.0 32 14 15 0   48     7   2   54 64                 118
2235983 MA Hampden   school 2511130 281   Springfield 251113000341 2810055 Springfield: Rebecca M Johnson   Regular School No Elementary PK 05 2018   grade_3 8 30 78 0   0     0   2   55 63                       118.0 8 30 78 0   0     0   2   55 63                 118
2236485 MA Bristol   school 2511520 293   Taunton 251152002697 2930015 Taunton: Mulcahey Elementary School   Regular School No Elementary KG 04 2018   grade_3 66 23 21 0   1     0   7   53 65                       118.0 66 23 21 0   1     0   7   53 65                 118
2231494 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Everett: Parlin School   Regular School No Elementary 01 08 2018   grade_3 21 16 77 0   2     0   3   62 57                       119.0 21 16 77 0   2     0   3   62 57                 119
2231542 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Fall River: Carlton M. Viveiros Elementary School   Regular School No Elementary KG 05 2018   grade_3 55 7 38 0   7     0   12   68 51                       119.0 55 7 38 0   7     0   12   68 51                 119
2231817 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Framingham: Barbieri Elementary   Regular School No Elementary KG 05 2018   grade_3 32 5 79 0   1     0   2   49 70                       119.0 32 5 79 0   1     0   2   49 70                 119
2229938 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston: William McKinley   Regular School No Other 01 12 2018   grade_3 0 9 3 0   0     0   0   10 2                       12.0 0 9 3 0   0     0   0   10 2                 12
2235096 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown: Provincetown Schools   Regular School No Elementary PK 08 2018   grade_3 7 3 1 0   0     0   1   4 8                       12.0 7 3 1 0   0     0   1   4 8                 12
2236579 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro: Truro Central   Regular School No Elementary PK 05 2018   grade_3 9 0 1 0   0     0   2   9 3                       12.0 9 0 1 0   0     0   2   9 3                 12
2231535 MA Bristol   school 2504830 95   Fall River 250483001780 950005 Fall River: North End Elementary   Regular School No Elementary PK 05 2018   grade_3 70 8 29 0   3     0   10   68 52                       120.0 70 8 29 0   3     0   10   68 52                 120
2232146 MA Plymouth   school 2505790 122   Hanover 250579000832 1220015 Hanover: Sylvester   Regular School No Elementary 03 04 2018   grade_3 113 1 1 0   2     0   3   61 59                       120.0 113 1 1 0   2     0   3   61 59                 120
2233033 MA Middlesex   school 2507020 160   Lowell 250702001045 1600040 Lowell: Peter W Reilly   Regular School No Elementary KG 04 2018   grade_3 55 6 43 0   11     0   5   73 47                       120.0 55 6 43 0   11     0   5   73 47                 120

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