enrollments

Data source: Big Local News · About: Big Local

986 rows where grade = "grade_1", state = "MA" and year = 2017 sorted by county

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 986 ✖

grade ✖

  • grade_1 · 986 ✖
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
1122300 1122300 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2017   grade_1 57 2 3 0   1     0   2   40 25                       65 57 2 3 0   1     0   2   40 25                 65
1122305 1122305 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2017   grade_1 55 5 6 0   0     0   3   37 32                       69 55 5 6 0   0     0   3   37 32                 69
1122310 1122310 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No Elementary KG 03 2017   grade_1 32 18 32 1   2     0   4   50 39                       89 32 18 32 1   2     0   4   50 39                 89
1122315 1122315 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No Elementary KG 03 2017   grade_1 91 2 5 0   0     0   4   57 45                       102 91 2 5 0   0     0   4   57 45                 102
1123463 1123463 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No Elementary PK 04 2017   grade_1 53 1 4 1   0     1   4   34 30                       64 53 1 4 1   0     1   4   34 30                 64
1123469 1123469 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Peebles Elementary School   Regular School No Elementary KG 04 2017   grade_1 67 3 7 1   1     1   2   42 40                       82 67 3 7 1   1     1   2   42 40                 82
1123561 1123561 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No Elementary PK 02 2017   grade_1 61 2 5 0   0     0   5   39 34                       73 61 2 5 0   0     0   5   39 34                 73
1124511 1124511 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No Elementary PK 05 2017   grade_1 24 1 3 0   0     0   1   13 16                       29 24 1 3 0   0     0   1   13 16                 29
1124832 1124832 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No Elementary PK 04 2017   grade_1 34 2 5 0   1     0   5   29 18                       47 34 2 5 0   1     0   5   29 18                 47
1124839 1124839 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No Elementary PK 04 2017   grade_1 47 6 5 0   0     0   1   22 37                       59 47 6 5 0   0     0   1   22 37                 59
1124845 1124845 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No Elementary KG 04 2017   grade_1 72 0 3 0   2     0   7   44 40                       84 72 0 3 0   2     0   7   44 40                 84
1124851 1124851 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No Elementary KG 04 2017   grade_1 53 2 3 0   1     0   4   25 38                       63 53 2 3 0   1     0   4   25 38                 63
1126733 1126733 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2017   grade_1 80 6 10 8   3     0   9   60 56                       116 80 6 10 8   3     0   9   60 56                 116
1127935 1127935 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans Elementary   Regular School No Elementary KG 05 2017   grade_1 27 0 3 0   1     0   1   13 19                       32 27 0 3 0   1     0   1   13 19                 32
1128273 1128273 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2017   grade_1 6 2 3 0   0     0   3   8 6                       14 6 2 3 0   0     0   3   8 6                 14
1128692 1128692 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No Elementary PK 02 2017   grade_1 199 3 8 0   5     1   0   107 109                       216 199 3 8 0   5     1   0   107 109                 216
1129761 1129761 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2017   grade_1 8 1 2 0   0     0   3   7 7                       14 8 1 2 0   0     0   3   7 7                 14
1130134 1130134 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No Elementary PK 05 2017   grade_1 13 1 1 0   0     0   3   7 11                       18 13 1 1 0   0     0   3   7 11                 18
1131196 1131196 MA Barnstable   school 2500081 427   Barnstable Community Horace Mann Charter Public (District) 250008101844 4270010 Barnstable Community Horace Mann Charter Public School   Regular School Yes Elementary KG 03 2017   grade_1 27 25 14 0   3     0   5   38 36                       74 27 25 14 0   3     0   5   38 36                 74
1131981 1131981 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Ezra H Baker Innovation School   Regular School No Elementary PK 03 2017   grade_1 63 8 8 1   2     0   9   51 40                       91 63 8 8 1   2     0   9   51 40                 91
1131987 1131987 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Marguerite E Small Elementary   Regular School No Elementary PK 03 2017   grade_1 36 5 9 3   1     0   9   35 28                       63 36 5 9 3   1     0   9   35 28                 63
1131992 1131992 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No Elementary KG 03 2017   grade_1 86 3 8 0   3     0   9   55 54                       109 86 3 8 0   3     0   9   55 54                 109
1132354 1132354 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400469 7120001 Chatham Elementary School   Regular School No Elementary PK 04 2017   grade_1 37 1 3 0   1     0   0   19 23                       42 37 1 3 0   1     0   0   19 23                 42
1132361 1132361 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No Elementary PK 04 2017   grade_1 74 6 5 1   2     0   7   58 37                       95 74 6 5 1   2     0   7   58 37                 95
1124208 1124208 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2017   grade_1 17 0 0 0   0     0   1   4 14                       18 17 0 0 0   0     0   1   4 14                 18
1124921 1124921 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   grade_1 7 0 0 0   0     0   0   3 4                       7 7 0 0 0   0     0   0   3 4                 7
1125316 1125316 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2017   grade_1 * * * *   *     *   *   3 1                       *                         3 1                  
1125748 1125748 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No Elementary PK 06 2017   grade_1 19 1 0 0   0     0   0   6 14                       20 19 1 0 0   0     0   0   6 14                 20
1125898 1125898 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No Elementary PK 06 2017   grade_1 48 0 4 0   0     0   1   29 24                       53 48 0 4 0   0     0   1   29 24                 53
1125932 1125932 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Morris   Regular School No Elementary PK 05 2017   grade_1 43 1 2 0   3     0   3   23 29                       52 43 1 2 0   3     0   3   23 29                 52
1127562 1127562 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 Colegrove Park Elementary   Regular School No Elementary KG 07 2017   grade_1 34 4 3 0   0     0   4   25 20                       45 34 4 3 0   0     0   4   25 20                 45
1127571 1127571 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 Greylock   Regular School No Elementary KG 07 2017   grade_1 30 1 3 0   0     0   1   19 16                       35 30 1 3 0   0     0   1   19 16                 35
1127581 1127581 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No Elementary PK 07 2017   grade_1 22 2 2 0   0     0   1   12 15                       27 22 2 2 0   0     0   1   12 15                 27
1128100 1128100 MA Berkshire   school 2509630 236   Pittsfield 250963001516 2360010 Allendale   Regular School No Elementary KG 05 2017   grade_1 25 3 5 0   1     0   6   16 24                       40 25 3 5 0   1     0   6   16 24                 40
1128107 1128107 MA Berkshire   school 2509630 236   Pittsfield 250963001519 2360035 Egremont   Regular School No Elementary KG 05 2017   grade_1 51 2 8 0   1     0   2   33 31                       64 51 2 8 0   1     0   2   33 31                 64
1128115 1128115 MA Berkshire   school 2509630 236   Pittsfield 250963001522 2360045 Robert T. Capeless Elementary School   Regular School No Elementary PK 05 2017   grade_1 22 0 3 0   0     0   3   13 15                       28 22 0 3 0   0     0   3   13 15                 28
1128123 1128123 MA Berkshire   school 2509630 236   Pittsfield 250963001524 2360055 Morningside Community School   Regular School No Elementary PK 05 2017   grade_1 31 6 15 0   0     1   4   27 30                       57 31 6 15 0   0     1   4   27 30                 57
1128131 1128131 MA Berkshire   school 2509630 236   Pittsfield 250963001528 2360065 Crosby   Regular School No Elementary PK 05 2017   grade_1 31 6 10 1   0     0   4   36 16                       52 31 6 10 1   0     0   4   36 16                 52
1128138 1128138 MA Berkshire   school 2509630 236   Pittsfield 250963002489 2360090 Stearns   Regular School No Elementary KG 05 2017   grade_1 32 3 5 0   0     0   2   28 14                       42 32 3 5 0   0     0   2   28 14                 42
1128145 1128145 MA Berkshire   school 2509630 236   Pittsfield 250963001536 2360100 Williams   Regular School No Elementary KG 05 2017   grade_1 42 2 0 0   2     0   2   29 19                       48 42 2 0 0   2     0   2   29 19                 48
1128153 1128153 MA Berkshire   school 2509630 236   Pittsfield 250963001535 2360105 Silvio O Conte Community   Regular School No Elementary PK 05 2017   grade_1 20 11 14 0   0     0   10   29 26                       55 20 11 14 0   0     0   10   29 26                 55
1128549 1128549 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2017   grade_1 15 2 2 0   0     0   0   10 9                       19 15 2 2 0   0     0   0   10 9                 19
1128749 1128749 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No Elementary PK 05 2017   grade_1 * * * *   *     *   *   2 1                       *                         2 1                  
1130536 1130536 MA Berkshire   school 2513020 341   Williamstown 251302002146 3410010 Williamstown Elementary   Regular School No Elementary PK 06 2017   grade_1 67 0 2 0   2     0   3   46 28                       74 67 0 2 0   2     0   3   46 28                 74
1131744 1131744 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000018 6030004 Cheshire Elementary   Regular School No Elementary PK 05 2017   grade_1 27 0 0 0   1     0   0   14 14                       28 27 0 0 0   1     0   0   14 14                 28
1131751 1131751 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000023 6030020 Plunkett Elementary   Regular School No Elementary KG 05 2017   grade_1 57 2 2 0   0     0   5   28 38                       66 57 2 2 0   0     0   5   28 38                 66
1131850 1131850 MA Berkshire   school 2502530 618   Berkshire Hills 250253001999 6180035 Muddy Brook Regional Elementary School   Regular School No Elementary PK 04 2017   grade_1 47 1 10 0   3     0   9   38 32                       70 47 1 10 0   3     0   9   38 32                 70
1131944 1131944 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Becket Washington School   Regular School No Elementary PK 05 2017   grade_1 15 0 0 0   0     0   0   8 7                       15 15 0 0 0   0     0   0   8 7                 15
1131952 1131952 MA Berkshire   school 2503390 635   Central Berkshire 250339000462 6350025 Craneville   Regular School No Elementary PK 05 2017   grade_1 51 0 2 0   0     0   3   28 28                       56 51 0 2 0   0     0   3   28 28                 56
1131960 1131960 MA Berkshire   school 2503390 635   Central Berkshire 250339000465 6350035 Kittredge   Regular School No Elementary PK 05 2017   grade_1 15 1 0 0   0     0   1   10 7                       17 15 1 0 0   0     0   1   10 7                 17
1132088 1132088 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2017   grade_1 12 0 0 0   0     0   0   7 5                       12 12 0 0 0   0     0   0   7 5                 12
1132696 1132696 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 New Marlborough Central   Regular School No Elementary PK 04 2017   grade_1 9 0 0 0   0     0   1   4 6                       10 9 0 0 0   0     0   1   4 6                 10
1132702 1132702 MA Berkshire   school 2511040 765   Southern Berkshire 251104001778 7650030 South Egremont   Regular School No Elementary KG 01 2017   grade_1 6 0 1 0   0     0   0   5 *                       7 6 0 1 0   0     0   0   5                   7
1132706 1132706 MA Berkshire   school 2511040 765   Southern Berkshire 251104000428 7650035 Undermountain   Regular School No Elementary PK 06 2017   grade_1 27 0 7 0   0     0   1   19 16                       35 27 0 7 0   0     0   1   19 16                 35
1121967 1121967 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   grade_1 88 0 4 0   0     0   7   55 44                       99 88 0 4 0   0     0   7   55 44                 99
1122204 1122204 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2017   grade_1 50 5 27 1   2     1   11   51 46                       97 50 5 27 1   2     1   11   51 46                 97
1122212 1122212 MA Bristol   school 2502190 16   Attleboro 250219000098 160035 Thomas Willett Elementary School   Regular School No Elementary KG 04 2017   grade_1 60 10 5 0   12     0   6   50 43                       93 60 10 5 0   12     0   6   50 43                 93
1122218 1122218 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No Elementary KG 04 2017   grade_1 70 2 11 0   5     0   4   58 34                       92 70 2 11 0   5     0   4   58 34                 92
1122224 1122224 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Hill-Roberts Elementary School   Regular School No Elementary KG 04 2017   grade_1 70 2 9 1   6     0   8   51 45                       96 70 2 9 1   6     0   8   51 45                 96
1122230 1122230 MA Bristol   school 2502190 16   Attleboro 250219001294 160050 Peter Thacher Elementary School   Regular School No Elementary KG 04 2017   grade_1 46 3 5 0   6     0   11   36 35                       71 46 3 5 0   6     0   11   36 35                 71
1122432 1122432 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No Elementary PK 04 2017   grade_1 89 0 2 0   0     0   4   41 54                       95 89 0 2 0   0     0   4   41 54                 95
1124336 1124336 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No Elementary 01 05 2017   grade_1 61 0 4 0   0     0   3   31 37                       68 61 0 4 0   0     0   3   31 37                 68
1124343 1124343 MA Bristol   school 2504020 72   Dartmouth 250402000542 720030 George H Potter   Regular School No Elementary KG 05 2017   grade_1 66 2 3 0   0     0   5   48 28                       76 66 2 3 0   0     0   5   48 28                 76
1124350 1124350 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 James M. Quinn School   Regular School No Elementary KG 05 2017   grade_1 82 1 3 0   3     0   8   53 44                       97 82 1 3 0   3     0   8   53 44                 97
1124570 1124570 MA Bristol   school 2504620 88   Easton 250462000980 880003 Center School   Regular School No Elementary PK 02 2017   grade_1 69 8 0 0   3     0   1   42 39                       81 69 8 0 0   3     0   1   42 39                 81
1124575 1124575 MA Bristol   school 2504620 88   Easton 250462000624 880015 Parkview Elementary   Regular School No Elementary PK 02 2017   grade_1 82 3 5 0   1     0   8   56 43                       99 82 3 5 0   1     0   8   56 43                 99
1124580 1124580 MA Bristol   school 2504620 88   Easton 250462002381 880020 Moreau Hall   Regular School No Elementary PK 02 2017   grade_1 56 1 2 1   2     0   2   34 30                       64 56 1 2 1   2     0   2   34 30                 64
1124691 1124691 MA Bristol   school 2504800 94   Fairhaven 250480000640 940010 East Fairhaven   Regular School No Elementary PK 05 2017   grade_1 53 3 6 0   0     0   2   35 29                       64 53 3 6 0   0     0   2   35 29                 64
1124698 1124698 MA Bristol   school 2504800 94   Fairhaven 250480000645 940030 Leroy Wood   Regular School No Elementary KG 05 2017   grade_1 80 1 6 0   1     0   7   53 42                       95 80 1 6 0   1     0   7   53 42                 95
1124715 1124715 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No Elementary PK 05 2017   grade_1 68 6 16 0   6     0   8   59 45                       104 68 6 16 0   6     0   8   59 45                 104
1124722 1124722 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No Elementary KG 05 2017   grade_1 65 7 39 1   8     0   14   76 58                       134 65 7 39 1   8     0   14   76 58                 134
1124729 1124729 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Mary Fonseca Elementary School   Regular School No Elementary KG 05 2017   grade_1 45 12 44 0   6     0   9   57 59                       116 45 12 44 0   6     0   9   57 59                 116
1124737 1124737 MA Bristol   school 2504830 95   Fall River 250483002656 950013 Letourneau Elementary School   Regular School No Elementary PK 05 2017   grade_1 58 7 31 0   1     0   5   40 62                       102 58 7 31 0   1     0   5   40 62                 102
1124745 1124745 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No Elementary PK 08 2017   grade_1 31 7 20 0   6     1   3   36 32                       68 31 7 20 0   6     1   3   36 32                 68
1124756 1124756 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No Elementary PK 08 2017   grade_1 31 3 18 0   0     0   6   36 22                       58 31 3 18 0   0     0   6   36 22                 58
1124767 1124767 MA Bristol   school 2504830 95   Fall River 250483000684 950065 William S Greene   Regular School No Elementary PK 05 2017   grade_1 62 6 27 0   6     0   11   59 53                       112 62 6 27 0   6     0   11   59 53                 112
1124774 1124774 MA Bristol   school 2504830 95   Fall River 250483000679 950130 Spencer Borden   Regular School No Elementary KG 05 2017   grade_1 62 4 16 0   1     0   6   52 37                       89 62 4 16 0   1     0   6   52 37                 89
1124781 1124781 MA Bristol   school 2504830 95   Fall River 250483000665 950140 James Tansey   Regular School No Elementary KG 05 2017   grade_1 37 1 4 0   0     0   4   23 23                       46 37 1 4 0   0     0   4   23 23                 46
1124788 1124788 MA Bristol   school 2504830 95   Fall River 250483000677 950145 Samuel Watson   Regular School No Elementary KG 05 2017   grade_1 23 8 13 1   0     0   4   18 31                       49 23 8 13 1   0     0   4   18 31                 49
1126601 1126601 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No Elementary KG 02 2017   grade_1 182 4 21 0   24     0   14   143 102                       245 182 4 21 0   24     0   14   143 102                 245
1127230 1127230 MA Bristol   school 2508430 201   New Bedford 250843001321 2010010 Charles S Ashley   Regular School No Elementary KG 05 2017   grade_1 41 3 10 0   0     0   1   29 26                       55 41 3 10 0   0     0   1   29 26                 55
1127238 1127238 MA Bristol   school 2508430 201   New Bedford 250843001322 2010015 Elizabeth Carter Brooks   Regular School No Elementary PK 05 2017   grade_1 17 3 9 1   1     0   5   22 14                       36 17 3 9 1   1     0   5   22 14                 36
1127246 1127246 MA Bristol   school 2508430 201   New Bedford 250843001324 2010020 Elwyn G Campbell   Regular School No Elementary PK 05 2017   grade_1 20 1 9 1   2     0   3   16 20                       36 20 1 9 1   2     0   3   16 20                 36
1127253 1127253 MA Bristol   school 2508430 201   New Bedford 250843001329 2010040 James B Congdon   Regular School No Elementary KG 05 2017   grade_1 26 9 26 1   0     0   5   33 34                       67 26 9 26 1   0     0   5   33 34                 67
1127261 1127261 MA Bristol   school 2508430 201   New Bedford 250843001341 2010045 Sgt Wm H Carney Academy   Regular School No Elementary PK 05 2017   grade_1 53 20 41 0   0     0   16   84 46                       130 53 20 41 0   0     0   16   84 46                 130
1127268 1127268 MA Bristol   school 2508430 201   New Bedford 250843001332 2010050 John B Devalles   Regular School No Elementary KG 05 2017   grade_1 23 6 28 0   0     0   2   34 25                       59 23 6 28 0   0     0   2   34 25                 59
1127276 1127276 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 Alfred J Gomes   Regular School No Elementary PK 05 2017   grade_1 17 12 65 0   0     0   2   52 44                       96 17 12 65 0   0     0   2   52 44                 96
1127284 1127284 MA Bristol   school 2508430 201   New Bedford 250843001333 2010070 John Hannigan   Regular School No Elementary PK 05 2017   grade_1 21 12 29 0   0     0   2   35 29                       64 21 12 29 0   0     0   2   35 29                 64
1127291 1127291 MA Bristol   school 2508430 201   New Bedford 250843001323 2010075 Ellen R Hathaway   Regular School No Elementary KG 05 2017   grade_1 12 4 26 1   2     0   4   30 19                       49 12 4 26 1   2     0   4   30 19                 49
1127299 1127299 MA Bristol   school 2508430 201   New Bedford 250843001327 2010078 Hayden/McFadden   Regular School No Elementary PK 05 2017   grade_1 28 10 54 0   0     0   8   42 58                       100 28 10 54 0   0     0   8   42 58                 100
1127306 1127306 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2017   grade_1 71 7 37 1   1     0   8   60 65                       125 71 7 37 1   1     0   8   60 65                 125
1127314 1127314 MA Bristol   school 2508430 201   New Bedford 250843001335 2010105 Carlos Pacheco   Regular School No Elementary PK 05 2017   grade_1 16 7 33 1   2     0   1   32 28                       60 16 7 33 1   2     0   1   32 28                 60
1127322 1127322 MA Bristol   school 2508430 201   New Bedford 250843001331 2010115 John Avery Parker   Regular School No Elementary PK 05 2017   grade_1 22 8 17 1   0     0   4   29 23                       52 22 8 17 1   0     0   4   29 23                 52
1127330 1127330 MA Bristol   school 2508430 201   New Bedford 250843001320 2010123 Casimir Pulaski   Regular School No Elementary PK 05 2017   grade_1 69 2 16 1   0     0   7   54 41                       95 69 2 16 1   0     0   7   54 41                 95
1127338 1127338 MA Bristol   school 2508430 201   New Bedford 250843002802 2010124 Renaissance Community School for the Arts   Regular School No Elementary PK 05 2017   grade_1 11 7 23 0   0     0   2   16 27                       43 11 7 23 0   0     0   2   16 27                 43
1127345 1127345 MA Bristol   school 2508430 201   New Bedford 250843001342 2010125 Thomas R Rodman   Regular School No Elementary KG 05 2017   grade_1 15 0 11 0   0     0   1   14 13                       27 15 0 11 0   0     0   1   14 13                 27
1127352 1127352 MA Bristol   school 2508430 201   New Bedford 250843001330 2010130 Jireh Swift   Regular School No Elementary KG 05 2017   grade_1 31 2 5 0   2     0   1   23 18                       41 31 2 5 0   2     0   1   23 18                 41
1127359 1127359 MA Bristol   school 2508430 201   New Bedford 250843001343 2010135 William H Taylor   Regular School No Elementary KG 05 2017   grade_1 33 1 6 0   0     0   4   24 20                       44 33 1 6 0   0     0   4   24 20                 44
1127366 1127366 MA Bristol   school 2508430 201   New Bedford 250843001319 2010140 Betsey B Winslow   Regular School No Elementary KG 05 2017   grade_1 29 2 12 1   1     0   3   23 25                       48 29 2 12 1   1     0   3   23 25                 48
1127680 1127680 MA Bristol   school 2508730 212   North Attleborough 250873001401 2120007 Amvet Boulevard   Regular School No Elementary KG 05 2017   grade_1 52 1 2 0   8     0   1   38 26                       64 52 1 2 0   8     0   1   38 26                 64

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