enrollments

Data source: Big Local News · About: Big Local

982 rows where grade = "grade_2", state = "MA" and year = 2017 sorted by county

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 982 ✖

grade ✖

  • grade_2 · 982 ✖
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
1122301 1122301 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2017   grade_2 55 5 2 0   0     0   5   37 30                       67 55 5 2 0   0     0   5   37 30                 67
1122306 1122306 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2017   grade_2 64 5 8 0   1     0   1   39 40                       79 64 5 8 0   1     0   1   39 40                 79
1122311 1122311 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No Elementary KG 03 2017   grade_2 37 16 23 0   3     0   11   50 40                       90 37 16 23 0   3     0   11   50 40                 90
1122316 1122316 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No Elementary KG 03 2017   grade_2 110 3 4 1   0     0   4   58 64                       122 110 3 4 1   0     0   4   58 64                 122
1123464 1123464 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No Elementary PK 04 2017   grade_2 79 1 7 1   0     0   3   54 37                       91 79 1 7 1   0     0   3   54 37                 91
1123470 1123470 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Peebles Elementary School   Regular School No Elementary KG 04 2017   grade_2 64 2 1 0   1     0   2   28 42                       70 64 2 1 0   1     0   2   28 42                 70
1123562 1123562 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No Elementary PK 02 2017   grade_2 64 2 7 0   2     0   4   36 43                       79 64 2 7 0   2     0   4   36 43                 79
1124512 1124512 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No Elementary PK 05 2017   grade_2 23 0 0 1   0     0   1   9 16                       25 23 0 0 1   0     0   1   9 16                 25
1124833 1124833 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No Elementary PK 04 2017   grade_2 48 5 3 1   1     0   1   24 35                       59 48 5 3 1   1     0   1   24 35                 59
1124840 1124840 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No Elementary PK 04 2017   grade_2 50 3 2 0   1     0   2   34 24                       58 50 3 2 0   1     0   2   34 24                 58
1124846 1124846 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No Elementary KG 04 2017   grade_2 81 6 5 1   2     0   3   52 46                       98 81 6 5 1   2     0   3   52 46                 98
1124852 1124852 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No Elementary KG 04 2017   grade_2 65 0 3 0   2     0   4   35 39                       74 65 0 3 0   2     0   4   35 39                 74
1126734 1126734 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2017   grade_2 67 1 7 9   1     0   10   44 51                       95 67 1 7 9   1     0   10   44 51                 95
1127936 1127936 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans Elementary   Regular School No Elementary KG 05 2017   grade_2 32 1 0 0   0     0   0   22 11                       33 32 1 0 0   0     0   0   22 11                 33
1128274 1128274 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2017   grade_2 9 2 0 0   0     0   1   5 7                       12 9 2 0 0   0     0   1   5 7                 12
1128693 1128693 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No Elementary PK 02 2017   grade_2 169 3 6 0   2     0   1   94 87                       181 169 3 6 0   2     0   1   94 87                 181
1129762 1129762 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2017   grade_2 9 0 0 0   0     0   2   9 2                       11 9 0 0 0   0     0   2   9 2                 11
1130135 1130135 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No Elementary PK 05 2017   grade_2 13 0 2 0   0     0   0   8 7                       15 13 0 2 0   0     0   0   8 7                 15
1131197 1131197 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_2 47 3 14 1   3     1   5   41 33                       74 47 3 14 1   3     1   5   41 33                 74
1131982 1131982 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Ezra H Baker Innovation School   Regular School No Elementary PK 03 2017   grade_2 70 6 8 1   2     0   8   49 46                       95 70 6 8 1   2     0   8   49 46                 95
1131988 1131988 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Marguerite E Small Elementary   Regular School No Elementary PK 03 2017   grade_2 31 2 10 4   0     0   6   30 23                       53 31 2 10 4   0     0   6   30 23                 53
1131993 1131993 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No Elementary KG 03 2017   grade_2 83 6 2 3   1     0   11   54 52                       106 83 6 2 3   1     0   11   54 52                 106
1132355 1132355 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400469 7120001 Chatham Elementary School   Regular School No Elementary PK 04 2017   grade_2 51 4 1 0   0     0   1   26 31                       57 51 4 1 0   0     0   1   26 31                 57
1132362 1132362 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No Elementary PK 04 2017   grade_2 85 2 7 1   0     0   8   49 54                       103 85 2 7 1   0     0   8   49 54                 103
1124209 1124209 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2017   grade_2 18 0 1 0   0     0   0   11 8                       19 18 0 1 0   0     0   0   11 8                 19
1124922 1124922 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   grade_2 * * * *   *     *   *   2 3                       *                         2 3                  
1125317 1125317 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2017   grade_2 * * * *   *     *   *   2 1                       *                         2 1                  
1125749 1125749 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No Elementary PK 06 2017   grade_2 18 1 2 0   0     0   0   6 15                       21 18 1 2 0   0     0   0   6 15                 21
1125899 1125899 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No Elementary PK 06 2017   grade_2 37 0 8 0   2     0   0   32 15                       47 37 0 8 0   2     0   0   32 15                 47
1125933 1125933 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Morris   Regular School No Elementary PK 05 2017   grade_2 35 0 3 0   3     0   0   25 16                       41 35 0 3 0   3     0   0   25 16                 41
1127563 1127563 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 Colegrove Park Elementary   Regular School No Elementary KG 07 2017   grade_2 28 1 4 0   0     0   3   20 16                       36 28 1 4 0   0     0   3   20 16                 36
1127572 1127572 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 Greylock   Regular School No Elementary KG 07 2017   grade_2 23 1 2 0   1     0   4   16 15                       31 23 1 2 0   1     0   4   16 15                 31
1127582 1127582 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No Elementary PK 07 2017   grade_2 28 1 2 0   0     0   1   19 13                       32 28 1 2 0   0     0   1   19 13                 32
1128101 1128101 MA Berkshire   school 2509630 236   Pittsfield 250963001516 2360010 Allendale   Regular School No Elementary KG 05 2017   grade_2 31 4 8 0   2     0   5   21 29                       50 31 4 8 0   2     0   5   21 29                 50
1128108 1128108 MA Berkshire   school 2509630 236   Pittsfield 250963001519 2360035 Egremont   Regular School No Elementary KG 05 2017   grade_2 62 4 7 0   0     0   8   41 40                       81 62 4 7 0   0     0   8   41 40                 81
1128116 1128116 MA Berkshire   school 2509630 236   Pittsfield 250963001522 2360045 Robert T. Capeless Elementary School   Regular School No Elementary PK 05 2017   grade_2 26 0 1 0   0     0   4   20 11                       31 26 0 1 0   0     0   4   20 11                 31
1128124 1128124 MA Berkshire   school 2509630 236   Pittsfield 250963001524 2360055 Morningside Community School   Regular School No Elementary PK 05 2017   grade_2 28 5 14 0   1     0   11   30 29                       59 28 5 14 0   1     0   11   30 29                 59
1128132 1128132 MA Berkshire   school 2509630 236   Pittsfield 250963001528 2360065 Crosby   Regular School No Elementary PK 05 2017   grade_2 37 7 12 0   0     0   10   33 33                       66 37 7 12 0   0     0   10   33 33                 66
1128139 1128139 MA Berkshire   school 2509630 236   Pittsfield 250963002489 2360090 Stearns   Regular School No Elementary KG 05 2017   grade_2 40 0 4 0   1     0   3   26 22                       48 40 0 4 0   1     0   3   26 22                 48
1128146 1128146 MA Berkshire   school 2509630 236   Pittsfield 250963001536 2360100 Williams   Regular School No Elementary KG 05 2017   grade_2 42 3 4 0   3     0   6   26 32                       58 42 3 4 0   3     0   6   26 32                 58
1128154 1128154 MA Berkshire   school 2509630 236   Pittsfield 250963001535 2360105 Silvio O Conte Community   Regular School No Elementary PK 05 2017   grade_2 25 14 16 2   0     0   11   41 27                       68 25 14 16 2   0     0   11   41 27                 68
1128550 1128550 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2017   grade_2 17 0 0 0   0     0   1   7 11                       18 17 0 0 0   0     0   1   7 11                 18
1128750 1128750 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No Elementary PK 05 2017   grade_2 9 0 0 0   0     0   0   3 6                       9 9 0 0 0   0     0   0   3 6                 9
1130537 1130537 MA Berkshire   school 2513020 341   Williamstown 251302002146 3410010 Williamstown Elementary   Regular School No Elementary PK 06 2017   grade_2 53 1 2 0   1     0   3   29 31                       60 53 1 2 0   1     0   3   29 31                 60
1131745 1131745 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000018 6030004 Cheshire Elementary   Regular School No Elementary PK 05 2017   grade_2 26 6 0 0   0     0   1   13 20                       33 26 6 0 0   0     0   1   13 20                 33
1131752 1131752 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000023 6030020 Plunkett Elementary   Regular School No Elementary KG 05 2017   grade_2 72 3 3 0   1     1   3   47 36                       83 72 3 3 0   1     1   3   47 36                 83
1131851 1131851 MA Berkshire   school 2502530 618   Berkshire Hills 250253001999 6180035 Muddy Brook Regional Elementary School   Regular School No Elementary PK 04 2017   grade_2 49 0 8 0   1     0   4   36 26                       62 49 0 8 0   1     0   4   36 26                 62
1131945 1131945 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Becket Washington School   Regular School No Elementary PK 05 2017   grade_2 18 0 0 0   0     0   1   12 7                       19 18 0 0 0   0     0   1   12 7                 19
1131953 1131953 MA Berkshire   school 2503390 635   Central Berkshire 250339000462 6350025 Craneville   Regular School No Elementary PK 05 2017   grade_2 50 0 1 0   3     0   3   39 18                       57 50 0 1 0   3     0   3   39 18                 57
1131961 1131961 MA Berkshire   school 2503390 635   Central Berkshire 250339000465 6350035 Kittredge   Regular School No Elementary PK 05 2017   grade_2 15 0 0 0   0     0   0   9 6                       15 15 0 0 0   0     0   0   9 6                 15
1132089 1132089 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2017   grade_2 13 0 0 0   0     0   0   8 5                       13 13 0 0 0   0     0   0   8 5                 13
1132697 1132697 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 New Marlborough Central   Regular School No Elementary PK 04 2017   grade_2 16 0 0 1   0     0   0   6 11                       17 16 0 0 1   0     0   0   6 11                 17
1132707 1132707 MA Berkshire   school 2511040 765   Southern Berkshire 251104000428 7650035 Undermountain   Regular School No Elementary PK 06 2017   grade_2 28 3 3 0   0     0   2   24 12                       36 28 3 3 0   0     0   2   24 12                 36
1121968 1121968 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   grade_2 92 1 6 0   0     0   3   44 58                       102 92 1 6 0   0     0   3   44 58                 102
1122205 1122205 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2017   grade_2 61 1 28 0   2     0   2   47 47                       94 61 1 28 0   2     0   2   47 47                 94
1122213 1122213 MA Bristol   school 2502190 16   Attleboro 250219000098 160035 Thomas Willett Elementary School   Regular School No Elementary KG 04 2017   grade_2 62 4 9 0   4     0   11   47 43                       90 62 4 9 0   4     0   11   47 43                 90
1122219 1122219 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No Elementary KG 04 2017   grade_2 63 4 6 0   0     0   8   34 47                       81 63 4 6 0   0     0   8   34 47                 81
1122225 1122225 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Hill-Roberts Elementary School   Regular School No Elementary KG 04 2017   grade_2 56 4 10 0   2     0   5   46 31                       77 56 4 10 0   2     0   5   46 31                 77
1122231 1122231 MA Bristol   school 2502190 16   Attleboro 250219001294 160050 Peter Thacher Elementary School   Regular School No Elementary KG 04 2017   grade_2 45 4 13 0   4     0   9   41 34                       75 45 4 13 0   4     0   9   41 34                 75
1122433 1122433 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No Elementary PK 04 2017   grade_2 86 0 1 0   0     0   3   48 42                       90 86 0 1 0   0     0   3   48 42                 90
1124337 1124337 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No Elementary 01 05 2017   grade_2 72 1 3 0   1     0   5   40 42                       82 72 1 3 0   1     0   5   40 42                 82
1124344 1124344 MA Bristol   school 2504020 72   Dartmouth 250402000542 720030 George H Potter   Regular School No Elementary KG 05 2017   grade_2 63 1 5 0   1     0   4   42 32                       74 63 1 5 0   1     0   4   42 32                 74
1124351 1124351 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 James M. Quinn School   Regular School No Elementary KG 05 2017   grade_2 85 1 6 0   1     0   7   54 46                       100 85 1 6 0   1     0   7   54 46                 100
1124571 1124571 MA Bristol   school 2504620 88   Easton 250462000980 880003 Center School   Regular School No Elementary PK 02 2017   grade_2 78 7 0 0   3     1   1   56 34                       90 78 7 0 0   3     1   1   56 34                 90
1124576 1124576 MA Bristol   school 2504620 88   Easton 250462000624 880015 Parkview Elementary   Regular School No Elementary PK 02 2017   grade_2 89 3 6 0   1     0   6   49 56                       105 89 3 6 0   1     0   6   49 56                 105
1124581 1124581 MA Bristol   school 2504620 88   Easton 250462002381 880020 Moreau Hall   Regular School No Elementary PK 02 2017   grade_2 65 9 4 0   2     0   0   38 42                       80 65 9 4 0   2     0   0   38 42                 80
1124692 1124692 MA Bristol   school 2504800 94   Fairhaven 250480000640 940010 East Fairhaven   Regular School No Elementary PK 05 2017   grade_2 60 2 4 1   2     0   3   38 34                       72 60 2 4 1   2     0   3   38 34                 72
1124699 1124699 MA Bristol   school 2504800 94   Fairhaven 250480000645 940030 Leroy Wood   Regular School No Elementary KG 05 2017   grade_2 75 2 5 0   1     0   7   42 48                       90 75 2 5 0   1     0   7   42 48                 90
1124716 1124716 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No Elementary PK 05 2017   grade_2 73 7 21 0   2     0   10   65 48                       113 73 7 21 0   2     0   10   65 48                 113
1124723 1124723 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No Elementary KG 05 2017   grade_2 61 9 32 0   7     0   15   71 53                       124 61 9 32 0   7     0   15   71 53                 124
1124730 1124730 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Mary Fonseca Elementary School   Regular School No Elementary KG 05 2017   grade_2 55 10 45 1   7     0   17   65 70                       135 55 10 45 1   7     0   17   65 70                 135
1124738 1124738 MA Bristol   school 2504830 95   Fall River 250483002656 950013 Letourneau Elementary School   Regular School No Elementary PK 05 2017   grade_2 46 6 37 0   1     0   7   52 45                       97 46 6 37 0   1     0   7   52 45                 97
1124746 1124746 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No Elementary PK 08 2017   grade_2 30 10 27 0   6     0   6   40 39                       79 30 10 27 0   6     0   6   40 39                 79
1124757 1124757 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No Elementary PK 08 2017   grade_2 29 7 11 0   1     0   8   26 30                       56 29 7 11 0   1     0   8   26 30                 56
1124768 1124768 MA Bristol   school 2504830 95   Fall River 250483000684 950065 William S Greene   Regular School No Elementary PK 05 2017   grade_2 70 4 24 0   6     0   12   57 59                       116 70 4 24 0   6     0   12   57 59                 116
1124775 1124775 MA Bristol   school 2504830 95   Fall River 250483000679 950130 Spencer Borden   Regular School No Elementary KG 05 2017   grade_2 54 6 17 0   4     0   7   50 38                       88 54 6 17 0   4     0   7   50 38                 88
1124782 1124782 MA Bristol   school 2504830 95   Fall River 250483000665 950140 James Tansey   Regular School No Elementary KG 05 2017   grade_2 41 0 1 0   1     0   8   29 22                       51 41 0 1 0   1     0   8   29 22                 51
1124789 1124789 MA Bristol   school 2504830 95   Fall River 250483000677 950145 Samuel Watson   Regular School No Elementary KG 05 2017   grade_2 27 5 10 1   1     0   8   28 24                       52 27 5 10 1   1     0   8   28 24                 52
1124814 1124814 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No Elementary 02 08 2017   grade_2 * * * *   *     *   *   1 *                       *                         1                    
1126602 1126602 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No Elementary KG 02 2017   grade_2 195 10 3 1   15     0   9   119 114                       233 195 10 3 1   15     0   9   119 114                 233
1127231 1127231 MA Bristol   school 2508430 201   New Bedford 250843001321 2010010 Charles S Ashley   Regular School No Elementary KG 05 2017   grade_2 32 2 15 1   0     0   0   27 23                       50 32 2 15 1   0     0   0   27 23                 50
1127239 1127239 MA Bristol   school 2508430 201   New Bedford 250843001322 2010015 Elizabeth Carter Brooks   Regular School No Elementary PK 05 2017   grade_2 25 3 13 0   1     0   2   23 21                       44 25 3 13 0   1     0   2   23 21                 44
1127247 1127247 MA Bristol   school 2508430 201   New Bedford 250843001324 2010020 Elwyn G Campbell   Regular School No Elementary PK 05 2017   grade_2 29 3 9 0   0     0   5   15 31                       46 29 3 9 0   0     0   5   15 31                 46
1127254 1127254 MA Bristol   school 2508430 201   New Bedford 250843001329 2010040 James B Congdon   Regular School No Elementary KG 05 2017   grade_2 24 5 29 1   0     1   8   34 34                       68 24 5 29 1   0     1   8   34 34                 68
1127262 1127262 MA Bristol   school 2508430 201   New Bedford 250843001341 2010045 Sgt Wm H Carney Academy   Regular School No Elementary PK 05 2017   grade_2 39 27 35 0   1     0   7   67 42                       109 39 27 35 0   1     0   7   67 42                 109
1127269 1127269 MA Bristol   school 2508430 201   New Bedford 250843001332 2010050 John B Devalles   Regular School No Elementary KG 05 2017   grade_2 25 6 26 0   1     0   0   30 28                       58 25 6 26 0   1     0   0   30 28                 58
1127277 1127277 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 Alfred J Gomes   Regular School No Elementary PK 05 2017   grade_2 20 10 65 1   0     0   2   53 45                       98 20 10 65 1   0     0   2   53 45                 98
1127285 1127285 MA Bristol   school 2508430 201   New Bedford 250843001333 2010070 John Hannigan   Regular School No Elementary PK 05 2017   grade_2 12 6 32 1   0     0   2   27 26                       53 12 6 32 1   0     0   2   27 26                 53
1127292 1127292 MA Bristol   school 2508430 201   New Bedford 250843001323 2010075 Ellen R Hathaway   Regular School No Elementary KG 05 2017   grade_2 12 7 32 0   0     0   2   26 27                       53 12 7 32 0   0     0   2   26 27                 53
1127300 1127300 MA Bristol   school 2508430 201   New Bedford 250843001327 2010078 Hayden/McFadden   Regular School No Elementary PK 05 2017   grade_2 21 12 54 1   0     0   5   43 50                       93 21 12 54 1   0     0   5   43 50                 93
1127307 1127307 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2017   grade_2 64 11 35 0   0     0   9   63 56                       119 64 11 35 0   0     0   9   63 56                 119
1127315 1127315 MA Bristol   school 2508430 201   New Bedford 250843001335 2010105 Carlos Pacheco   Regular School No Elementary PK 05 2017   grade_2 19 14 28 0   1     0   2   38 26                       64 19 14 28 0   1     0   2   38 26                 64
1127323 1127323 MA Bristol   school 2508430 201   New Bedford 250843001331 2010115 John Avery Parker   Regular School No Elementary PK 05 2017   grade_2 19 5 21 0   0     0   4   21 28                       49 19 5 21 0   0     0   4   21 28                 49
1127331 1127331 MA Bristol   school 2508430 201   New Bedford 250843001320 2010123 Casimir Pulaski   Regular School No Elementary PK 05 2017   grade_2 75 10 16 0   0     0   6   52 55                       107 75 10 16 0   0     0   6   52 55                 107
1127339 1127339 MA Bristol   school 2508430 201   New Bedford 250843002802 2010124 Renaissance Community School for the Arts   Regular School No Elementary PK 05 2017   grade_2 5 7 18 0   0     0   3   13 20                       33 5 7 18 0   0     0   3   13 20                 33
1127346 1127346 MA Bristol   school 2508430 201   New Bedford 250843001342 2010125 Thomas R Rodman   Regular School No Elementary KG 05 2017   grade_2 20 0 15 0   0     0   3   24 14                       38 20 0 15 0   0     0   3   24 14                 38
1127353 1127353 MA Bristol   school 2508430 201   New Bedford 250843001330 2010130 Jireh Swift   Regular School No Elementary KG 05 2017   grade_2 37 1 7 0   0     0   3   25 23                       48 37 1 7 0   0     0   3   25 23                 48
1127360 1127360 MA Bristol   school 2508430 201   New Bedford 250843001343 2010135 William H Taylor   Regular School No Elementary KG 05 2017   grade_2 30 4 9 0   0     0   4   14 33                       47 30 4 9 0   0     0   4   14 33                 47
1127367 1127367 MA Bristol   school 2508430 201   New Bedford 250843001319 2010140 Betsey B Winslow   Regular School No Elementary KG 05 2017   grade_2 42 7 10 0   1     0   6   32 34                       66 42 7 10 0   1     0   6   32 34                 66
1127681 1127681 MA Bristol   school 2508730 212   North Attleborough 250873001401 2120007 Amvet Boulevard   Regular School No Elementary KG 05 2017   grade_2 50 2 5 0   10     0   5   35 37                       72 50 2 5 0   10     0   5   35 37                 72

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