enrollments

Data source: Big Local News · About: Big Local

957 rows where grade = "grade_4", state = "MA" and year = 2017 sorted by white

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 957 ✖

grade ✖

  • grade_4 · 957 ✖
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
1124816 1124816 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No Elementary 02 08 2017   grade_4 * * * *   *     *   *   2 *                       *                         2                    
1125190 1125190 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_4 * * * *   *     *   *   * *                       *                                              
1125319 1125319 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2017   grade_4 * * * *   *     *   *   3 2                       *                         3 2                  
1125423 1125423 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_4 * * * *   *     *   *   4 1                       *                         4 1                  
1126249 1126249 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Elementary 02 07 2017   grade_4 * * * *   *     *   *   4 *                       *                         4                    
1126350 1126350 MA Essex   school 2507110 163   Lynn 250711002801 1630004 Early Childhood Center   Regular School No Elementary PK 05 2017   grade_4 * * * *   *     *   *   1 1                       *                         1 1                  
1126449 1126449 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary KG 06 2017   grade_4 * * * *   *     *   *   3 *                       *                         3                    
1128752 1128752 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No Elementary PK 05 2017   grade_4 * * * *   *     *   *   3 1                       *                         3 1                  
1131075 1131075 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2017   grade_4 * * * *   *     *   *   1 2                       *                         1 2                  
1132405 1132405 MA Franklin   school 2507990 717   Mohawk Trail 250799000934 7170015 Heath Elementary   Regular School No Elementary PK 06 2017   grade_4 * * * *   *     *   *   1 1                       *                         1 1                  
1122682 1122682 MA Suffolk   school 2502790 35   Boston 250279000220 350072 David A Ellis   Regular School No Elementary PK 05 2017   grade_4 0 20 40 0   0     0   0   27 33                       60 0 20 40 0   0     0   0   27 33                 60
1122826 1122826 MA Suffolk   school 2502790 35   Boston 250279000265 350166 John F Kennedy   Regular School No Elementary PK 05 2017   grade_4 0 12 55 0   0     0   0   41 26                       67 0 12 55 0   0     0   0   41 26                 67
1122854 1122854 MA Suffolk   school 2502790 35   Boston 250279000270 350180 John Winthrop   Regular School No Elementary PK 05 2017   grade_4 0 32 17 0   3     2   2   22 34                       56 0 32 17 0   3     2   2   22 34                 56
1122927 1122927 MA Suffolk   school 2502790 35   Boston 250279000290 350226 Mattahunt   Regular School No Elementary PK 05 2017   grade_4 0 64 21 0   0     0   0   41 44                       85 0 64 21 0   0     0   0   41 44                 85
1122980 1122980 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No Elementary PK 05 2017   grade_4 0 11 14 0   0     0   2   14 13                       27 0 11 14 0   0     0   2   14 13                 27
1123150 1123150 MA Suffolk   school 2502790 35   Boston 250279000337 350366 William E Russell   Regular School No Elementary PK 05 2017   grade_4 0 14 17 0   5     0   1   21 16                       37 0 14 17 0   5     0   1   21 16                 37
1123188 1123188 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2017   grade_4 0 32 16 0   0     0   2   25 25                       50 0 32 16 0   0     0   2   25 25                 50
1123218 1123218 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_4 0 32 27 0   0     0   0   30 29                       59 0 32 27 0   0     0   0   30 29                 59
1125842 1125842 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2017   grade_4 0 0 76 0   0     0   2   38 40                       78 0 0 76 0   0     0   2   38 40                 78
1129121 1129121 MA Hampden   school 2511130 281   Springfield 251113000896 2810023 Milton Bradley School   Regular School No Elementary PK 05 2017   grade_4 0 13 60 0   0     0   0   39 34                       73 0 13 60 0   0     0   0   39 34                 73
1129245 1129245 MA Hampden   school 2511130 281   Springfield 251113001815 2810120 Lincoln   Regular School No Elementary KG 05 2017   grade_4 0 11 61 0   0     0   1   45 28                       73 0 11 61 0   0     0   1   45 28                 73
1129327 1129327 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 German Gerena Community School   Regular School No Elementary PK 05 2017   grade_4 0 10 92 0   0     0   0   45 57                       102 0 10 92 0   0     0   0   45 57                 102
1131098 1131098 MA Suffolk   school 2500543 407   Dudley Street Neighborhood Charter School (District) 250054302763 4070405 Dudley Street Neighborhood Charter School   Regular School Yes Elementary PK 05 2017   grade_4 0 25 19 0   0     0   0   22 22                       44 0 25 19 0   0     0   0   22 22                 44
1131162 1131162 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 05 2017   grade_4 0 21 13 0   0     0   5   17 22                       39 0 21 13 0   0     0   5   17 22                 39
1131192 1131192 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway   Regular School Yes Elementary PK 05 2017   grade_4 0 0 40 0   0     0   0   22 18                       40 0 0 40 0   0     0   0   22 18                 40
1131269 1131269 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2017   grade_4 0 20 0 0   0     0   0   10 10                       20 0 20 0 0   0     0   0   10 10                 20
1131532 1131532 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2017   grade_4 0 79 35 0   1     0   0   55 60                       115 0 79 35 0   1     0   0   55 60                 115
1131630 1131630 MA Hampden   school 2500089 492   Martin Luther King Jr. Charter School of Excellence (District) 250008902127 4920005 Martin Luther King Jr. Charter School of Excellence   Regular School Yes Elementary KG 05 2017   grade_4 0 26 31 0   1     0   3   31 30                       61 0 26 31 0   1     0   3   31 30                 61
1122657 1122657 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Charles H Taylor   Regular School No Elementary PK 05 2017   grade_4 1 56 12 0   2     0   1   32 40                       72 1 56 12 0   2     0   1   32 40                 72
1122774 1122774 MA Suffolk   school 2502790 35   Boston 250279002569 350138 O W Holmes   Regular School No Elementary PK 05 2017   grade_4 1 37 13 0   2     0   4   32 25                       57 1 37 13 0   2     0   4   32 25                 57
1122782 1122782 MA Suffolk   school 2502790 35   Boston 250279000249 350141 Hugh Roe O'Donnell   Regular School No Elementary PK 05 2017   grade_4 1 0 37 0   0     0   1   17 22                       39 1 0 37 0   0     0   1   17 22                 39
1122943 1122943 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2017   grade_4 1 15 39 0   0     0   0   18 37                       55 1 15 39 0   0     0   0   18 37                 55
1123089 1123089 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2017   grade_4 1 13 32 0   0     0   1   21 26                       47 1 13 32 0   0     0   1   21 26                 47
1123130 1123130 MA Suffolk   school 2502790 35   Boston 250279000338 350360 William Ellery Channing   Regular School No Elementary PK 05 2017   grade_4 1 14 20 0   1     0   1   12 25                       37 1 14 20 0   1     0   1   12 25                 37
1123207 1123207 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2017   grade_4 1 11 10 0   0     0   0   15 7                       22 1 11 10 0   0     0   0   15 7                 22
1123244 1123244 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No Elementary PK 05 2017   grade_4 1 21 76 0   0     0   1   44 55                       99 1 21 76 0   0     0   1   44 55                 99
1125566 1125566 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Elementary 04 08 2017   grade_4 1 1 58 0   0     1   0   30 31                       61 1 1 58 0   0     1   0   30 31                 61
1125820 1125820 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No Elementary KG 05 2017   grade_4 1 2 59 0   0     0   0   35 27                       62 1 2 59 0   0     0   0   35 27                 62
1125881 1125881 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_4 1 0 11 0   0     0   1   12 1                       13 1 0 11 0   0     0   1   12 1                 13
1129128 1129128 MA Hampden   school 2511130 281   Springfield 251113001796 2810025 Brightwood   Regular School No Elementary KG 05 2017   grade_4 1 8 47 0   0     0   0   31 25                       56 1 8 47 0   0     0   0   31 25                 56
1129150 1129150 MA Hampden   school 2511130 281   Springfield 251113001838 2810045 William N. DeBerry   Regular School No Elementary KG 05 2017   grade_4 1 10 42 0   0     0   1   26 28                       54 1 10 42 0   0     0   1   26 28                 54
1129260 1129260 MA Hampden   school 2511130 281   Springfield 251113001818 2810140 Mary M Lynch   Regular School No Elementary KG 05 2017   grade_4 1 8 27 0   0     0   0   15 21                       36 1 8 27 0   0     0   0   15 21                 36
1131178 1131178 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2017   grade_4 1 50 7 0   3     0   0   35 26                       61 1 50 7 0   3     0   0   35 26                 61
1131235 1131235 MA Essex   school 2500535 431   Community Day Charter Public School - R. Kingman Webster (District) 250053502719 4310205 Community Day Charter Public School - R. Kingman Webster   Regular School Yes Elementary PK 05 2017   grade_4 1 0 37 0   1     0   0   18 21                       39 1 0 37 0   1     0   0   18 21                 39
1131403 1131403 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2017   grade_4 1 1 76 0   0     0   0   31 47                       78 1 1 76 0   0     0   0   31 47                 78
1122911 1122911 MA Suffolk   school 2502790 35   Boston 250279000244 350200 Harvard-Kent   Regular School No Elementary PK 05 2017   grade_4 10 19 35 0   28     0   2   54 40                       94 10 19 35 0   28     0   2   54 40                 94
1122961 1122961 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No Elementary PK 05 2017   grade_4 10 7 2 0   2     0   4   16 9                       25 10 7 2 0   2     0   4   16 9                 25
1123169 1123169 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Winship Elementary   Regular School No Elementary PK 05 2017   grade_4 10 9 15 0   2     1   1   20 18                       38 10 9 15 0   2     1   1   20 18                 38
1123935 1123935 MA Middlesex   school 2503270 49   Cambridge 250327000442 490065 John M Tobin   Regular School No Elementary PK 05 2017   grade_4 10 12 2 0   3     0   3   13 17                       30 10 12 2 0   3     0   3   13 17                 30
1124097 1124097 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2017   grade_4 10 6 149 0   1     0   4   77 93                       170 10 6 149 0   1     0   4   77 93                 170
1126157 1126157 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Rogers STEM Academy   Regular School No Elementary PK 05 2017   grade_4 10 14 48 0   21     0   1   49 45                       94 10 14 48 0   21     0   1   49 45                 94
1126231 1126231 MA Middlesex   school 2507020 160   Lowell 250702001051 1600055 Washington   Regular School No Elementary PK 04 2017   grade_4 10 3 10 0   23     0   3   23 26                       49 10 3 10 0   23     0   3   23 26                 49
1126408 1126408 MA Essex   school 2507110 163   Lynn 250711001070 1630045 E J Harrington   Regular School No Elementary PK 05 2017   grade_4 10 10 66 0   5     0   2   52 41                       93 10 10 66 0   5     0   2   52 41                 93
1126435 1126435 MA Essex   school 2507110 163   Lynn 250711001079 1630070 Lincoln-Thomson   Regular School No Elementary KG 05 2017   grade_4 10 6 33 0   2     0   0   17 34                       51 10 6 33 0   2     0   0   17 34                 51
1129002 1129002 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Winter Hill Community   Regular School No Elementary PK 08 2017   grade_4 10 4 23 0   3     0   0   19 21                       40 10 4 23 0   3     0   0   19 21                 40
1129098 1129098 MA Hampden   school 2511130 281   Springfield 251113001794 2810010 Edward P. Boland School   Regular School No Elementary PK 05 2017   grade_4 10 11 75 0   1     0   2   53 46                       99 10 11 75 0   1     0   2   53 46                 99
1129190 1129190 MA Hampden   school 2511130 281   Springfield 251113001803 2810075 Frank H Freedman   Regular School No Elementary KG 05 2017   grade_4 10 16 28 0   0     0   1   31 24                       55 10 16 28 0   0     0   1   31 24                 55
1129205 1129205 MA Hampden   school 2511130 281   Springfield 251113001808 2810085 Homer Street   Regular School No Elementary KG 05 2017   grade_4 10 19 50 0   0     0   0   39 40                       79 10 19 50 0   0     0   0   39 40                 79
1130746 1130746 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2017   grade_4 10 5 7 0   1     0   0   12 11                       23 10 5 7 0   1     0   0   12 11                 23
1130763 1130763 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No Elementary KG 06 2017   grade_4 10 4 12 0   3     0   1   16 14                       30 10 4 12 0   3     0   1   16 14                 30
1130772 1130772 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No Elementary PK 06 2017   grade_4 10 4 27 0   8     0   0   27 22                       49 10 4 27 0   8     0   0   27 22                 49
1131105 1131105 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 07 2017   grade_4 10 9 19 0   0     0   4   18 24                       42 10 9 19 0   0     0   4   18 24                 42
1132728 1132728 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302847 7660215 Granville Village School   Regular School No Elementary KG 06 2017   grade_4 10 0 0 0   0     0   0   6 4                       10 10 0 0 0   0     0   0   6 4                 10
1124416 1124416 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas Elementary School   Regular School No Elementary 02 05 2017   grade_4 100 1 3 0   3     0   4   50 61                       111 100 1 3 0   3     0   4   50 61                 111
1127969 1127969 MA Hampden   school 2509300 227   Palmer 250930002594 2270008 Old Mill Pond   Regular School No Elementary PK 05 2017   grade_4 101 4 12 0   2     0   5   55 69                       124 101 4 12 0   2     0   5   55 69                 124
1128228 1128228 MA Plymouth   school 2509720 239   Plymouth 250972001545 2390030 Nathaniel Morton Elementary   Regular School No Elementary KG 05 2017   grade_4 101 2 6 0   1     0   2   52 60                       112 101 2 6 0   1     0   2   52 60                 112
1126098 1126098 MA Middlesex   school 2506960 158   Littleton 250696001013 1580015 Russell St Elementary   Regular School No Elementary 03 05 2017   grade_4 102 1 5 0   7     1   4   63 57                       120 102 1 5 0   7     1   4   63 57                 120
1127999 1127999 MA Essex   school 2509360 229   Peabody 250936001503 2290010 Thomas Carroll   Regular School No Elementary KG 05 2017   grade_4 103 6 23 0   1     0   2   64 71                       135 103 6 23 0   1     0   2   64 71                 135
1129035 1129035 MA Worcester   school 2510980 276   Southborough 251098001760 2760020 Margaret A Neary   Regular School No Elementary 04 05 2017   grade_4 103 1 8 1   16     0   8   64 73                       137 103 1 8 1   16     0   8   64 73                 137
1129959 1129959 MA Hampshire   school 2512030 309   Ware 251203002538 3090305 Ware Middle School   Regular School No Elementary 04 06 2017   grade_4 103 2 7 0   0     0   7   63 56                       119 103 2 7 0   0     0   7   63 56                 119
1132956 1132956 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Indian Head   Regular School No Elementary 03 05 2017   grade_4 103 2 4 0   1     0   1   55 56                       111 103 2 4 0   1     0   1   55 56                 111
1128235 1128235 MA Plymouth   school 2509720 239   Plymouth 250972001547 2390046 South Elementary   Regular School No Elementary KG 04 2017   grade_4 104 2 3 1   1     0   5   52 64                       116 104 2 3 1   1     0   5   52 64                 116
1124353 1124353 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 James M. Quinn School   Regular School No Elementary KG 05 2017   grade_4 105 2 3 0   2     0   10   70 52                       122 105 2 3 0   2     0   10   70 52                 122
1126335 1126335 MA Worcester   school 2507080 162   Lunenburg 250708002871 1620025 Turkey Hill Elementary School   Regular School No Elementary 03 05 2017   grade_4 106 2 13 0   1     0   3   61 64                       125 106 2 13 0   1     0   3   61 64                 125
1126740 1126740 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2017   grade_4 106 3 2 8   3     0   12   65 69                       134 106 3 2 8   3     0   12   65 69                 134
1132048 1132048 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000588 6580005 Dudley Elementary   Regular School No Elementary 02 04 2017   grade_4 106 2 8 0   0     0   1   57 60                       117 106 2 8 0   0     0   1   57 60                 117
1129728 1129728 MA Middlesex   school 2511580 295   Tewksbury 251158001924 2950025 Louise Davy Trahan   Regular School No Elementary 03 04 2017   grade_4 108 2 3 0   7     0   2   56 66                       122 108 2 3 0   7     0   2   56 66                 122
1132364 1132364 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No Elementary PK 04 2017   grade_4 108 7 9 0   0     1   0   64 61                       125 108 7 9 0   0     1   0   64 61                 125
1129578 1129578 MA Worcester   school 2511400 290   Sutton 251140001879 2900005 Sutton Elementary   Regular School No Elementary 03 05 2017   grade_4 109 1 2 0   1     0   6   54 65                       119 109 1 2 0   1     0   6   54 65                 119
1130349 1130349 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport Elementary   Regular School No Elementary 03 06 2017   grade_4 109 0 4 0   1     0   6   70 50                       120 109 0 4 0   1     0   6   70 50                 120
1123951 1123951 MA Middlesex   school 2503270 49   Cambridge 250327001518 490090 Fletcher/Maynard Academy   Regular School No Elementary PK 05 2017   grade_4 11 18 5 1   1     0   2   24 14                       38 11 18 5 1   1     0   2   24 14                 38
1124082 1124082 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No Elementary 01 04 2017   grade_4 11 9 113 0   1     0   2   69 67                       136 11 9 113 0   1     0   2   69 67                 136
1124186 1124186 MA Hampden   school 2503660 61   Chicopee 250366000500 610090 Gen John J Stefanik   Regular School No Elementary KG 05 2017   grade_4 11 3 49 0   0     0   1   29 35                       64 11 3 49 0   0     0   1   29 35                 64
1124622 1124622 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No Elementary KG 08 2017   grade_4 11 7 50 0   5     0   1   36 38                       74 11 7 50 0   5     0   1   36 38                 74
1127325 1127325 MA Bristol   school 2508430 201   New Bedford 250843001331 2010115 John Avery Parker   Regular School No Elementary PK 05 2017   grade_4 11 8 23 0   0     1   1   25 19                       44 11 8 23 0   0     1   1   25 19                 44
1129143 1129143 MA Hampden   school 2511130 281   Springfield 251113001799 2810035 Daniel B Brunton   Regular School No Elementary KG 05 2017   grade_4 11 13 53 0   1     0   1   40 39                       79 11 13 53 0   1     0   1   40 39                 79
1130780 1130780 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No Elementary KG 06 2017   grade_4 11 10 46 0   8     0   4   35 44                       79 11 10 46 0   8     0   4   35 44                 79
1130798 1130798 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2017   grade_4 11 7 38 0   2     0   2   37 23                       60 11 7 38 0   2     0   2   37 23                 60
1125420 1125420 MA Essex   school 2505970 128   Haverhill 250597001169 1280054 Pentucket Lake Elementary   Regular School No Elementary KG 04 2017   grade_4 111 2 34 1   3     0   2   88 65                       153 111 2 34 1   3     0   2   88 65                 153
1126966 1126966 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2017   grade_4 111 2 9 1   1     0   6   66 64                       130 111 2 9 1   1     0   6   66 64                 130
1126972 1126972 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No Elementary 01 05 2017   grade_4 111 6 3 2   1     0   2   63 62                       125 111 6 3 2   1     0   2   63 62                 125
1127697 1127697 MA Bristol   school 2508730 212   North Attleborough 250873001404 2120013 Joseph W Martin Jr Elementary   Regular School No Elementary KG 05 2017   grade_4 111 4 4 0   11     1   5   58 78                       136 111 4 4 0   11     1   5   58 78                 136
1125334 1125334 MA Plymouth   school 2505790 122   Hanover 250579000832 1220015 Sylvester   Regular School No Elementary 03 04 2017   grade_4 112 0 6 0   1     0   3   59 63                       122 112 0 6 0   1     0   3   59 63                 122
1125384 1125384 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Bradford Elementary   Regular School No Elementary KG 05 2017   grade_4 112 6 24 0   5     0   1   73 75                       148 112 6 24 0   5     0   1   73 75                 148
1129722 1129722 MA Middlesex   school 2511580 295   Tewksbury 251158001923 2950020 North Street   Regular School No Elementary 03 04 2017   grade_4 112 9 2 0   5     0   2   74 56                       130 112 9 2 0   5     0   2   74 56                 130
1132889 1132889 MA Worcester   school 2511880 775   Wachusett 251188002131 7750060 Glenwood Elementary School   Regular School No Elementary 03 05 2017   grade_4 112 3 8 0   5     0   3   66 65                       131 112 3 8 0   5     0   3   66 65                 131
1129526 1129526 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No Elementary PK 06 2017   grade_4 113 1 5 0   0     0   4   71 52                       123 113 1 5 0   0     0   4   71 52                 123
1124223 1124223 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Elementary 04 08 2017   grade_4 116 10 35 0   2     0   3   97 69                       166 116 10 35 0   2     0   3   97 69                 166
1125216 1125216 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No Elementary 02 06 2017   grade_4 116 4 11 0   12     0   6   76 73                       149 116 4 11 0   12     0   6   76 73                 149
1127943 1127943 MA Worcester   school 2509270 226   Oxford 250927001481 2260005 Clara Barton   Regular School No Elementary 02 04 2017   grade_4 118 2 25 0   1     0   10   82 74                       156 118 2 25 0   1     0   10   82 74                 156

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