enrollments

Data source: Big Local News · About: Big Local

894 rows where grade = "grade_5", state = "MA" and year = 2017 sorted by asian_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 894 ✖

grade ✖

  • grade_5 · 894 ✖
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
1122674 1122674 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No Elementary PK 06 2017   grade_5 * * * *   *     *   *   3 1                       *                         3 1                  
1123667 1123667 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative School No Other 05 12 2017   grade_5 * * * *   *     *   *   1 1                       *                         1 1                  
1125191 1125191 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_5 * * * *   *     *   *   * *                       *                                              
1125265 1125265 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_5 * * * *   *     *   *   * *                       *                                              
1126250 1126250 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Elementary 02 07 2017   grade_5 * * * *   *     *   *   2 *                       *                         2                    
1126351 1126351 MA Essex   school 2507110 163   Lynn 250711002801 1630004 Early Childhood Center   Regular School No Elementary PK 05 2017   grade_5 * * * *   *     *   *   1 1                       *                         1 1                  
1128753 1128753 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No Elementary PK 05 2017   grade_5 * * * *   *     *   *   1 2                       *                         1 2                  
1130461 1130461 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Maria Weston Chapman Middle School   Regular School No Middle 05 08 2017   grade_5 * * * *   *     *   *   1 2                       *                         1 2                  
1132594 1132594 MA Franklin   school 2509600 750   Pioneer Valley 250960002613 7500007 Pearl E Rhodes Elementary   Regular School No Elementary PK 06 2017   grade_5 * * * *   *     *   *   1 2                       *                         1 2                  
1121972 1121972 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2017   grade_5 103 1 0 0   0     0   1   58 47                       105 103 1 0 0   0     0   1   58 47                 105
1122437 1122437 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2017   grade_5 85 1 2 0   0     0   0   43 45                       88 85 1 2 0   0     0   0   43 45                 88
1122457 1122457 MA Essex   school 2502640 30   Beverly 250264000167 300010 Centerville Elementary   Regular School No Elementary KG 05 2017   grade_5 32 5 12 0   0     0   2   29 22                       51 32 5 12 0   0     0   2   29 22                 51
1122666 1122666 MA Suffolk   school 2502790 35   Boston 250279000218 350062 Curtis Guild   Regular School No Elementary PK 05 2017   grade_5 4 0 34 0   0     0   0   25 13                       38 4 0 34 0   0     0   0   25 13                 38
1122683 1122683 MA Suffolk   school 2502790 35   Boston 250279000220 350072 David A Ellis   Regular School No Elementary PK 05 2017   grade_5 2 13 29 0   0     0   0   28 16                       44 2 13 29 0   0     0   0   28 16                 44
1122710 1122710 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2017   grade_5 4 3 61 0   0     0   1   31 38                       69 4 3 61 0   0     0   1   31 38                 69
1122740 1122740 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No Elementary PK 05 2017   grade_5 4 9 9 0   0     0   1   11 12                       23 4 9 9 0   0     0   1   11 12                 23
1122811 1122811 MA Suffolk   school 2502790 35   Boston 250279000255 350154 James J Chittick   Regular School No Elementary PK 05 2017   grade_5 0 15 7 0   0     0   1   14 9                       23 0 15 7 0   0     0   1   14 9                 23
1122827 1122827 MA Suffolk   school 2502790 35   Boston 250279000265 350166 John F Kennedy   Regular School No Elementary PK 05 2017   grade_5 0 11 40 0   0     0   2   30 23                       53 0 11 40 0   0     0   2   30 23                 53
1122843 1122843 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No Elementary PK 05 2017   grade_5 1 8 10 0   0     0   0   7 12                       19 1 8 10 0   0     0   0   7 12                 19
1122855 1122855 MA Suffolk   school 2502790 35   Boston 250279000270 350180 John Winthrop   Regular School No Elementary PK 05 2017   grade_5 0 24 8 0   0     1   3   15 21                       36 0 24 8 0   0     1   3   15 21                 36
1122871 1122871 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2017   grade_5 8 0 21 0   0     0   2   15 16                       31 8 0 21 0   0     0   2   15 16                 31
1122928 1122928 MA Suffolk   school 2502790 35   Boston 250279000290 350226 Mattahunt   Regular School No Elementary PK 05 2017   grade_5 0 43 8 1   0     0   4   23 33                       56 0 43 8 1   0     0   4   23 33                 56
1122944 1122944 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2017   grade_5 2 17 27 0   0     0   0   20 26                       46 2 17 27 0   0     0   0   20 26                 46
1122954 1122954 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No Elementary KG 05 2017   grade_5 2 21 14 0   0     0   3   20 20                       40 2 21 14 0   0     0   3   20 20                 40
1123018 1123018 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No Elementary PK 08 2017   grade_5 23 6 24 0   0     0   3   29 27                       56 23 6 24 0   0     0   3   29 27                 56
1123066 1123066 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Roger Clap   Regular School No Elementary PK 05 2017   grade_5 5 5 11 0   0     0   0   12 9                       21 5 5 11 0   0     0   0   12 9                 21
1123074 1123074 MA Suffolk   school 2502790 35   Boston 250279000321 350302 Samuel Adams   Regular School No Elementary PK 05 2017   grade_5 4 1 23 0   0     0   0   15 13                       28 4 1 23 0   0     0   0   15 13                 28
1123082 1123082 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Samuel W Mason   Regular School No Elementary PK 05 2017   grade_5 0 14 7 0   0     0   2   10 13                       23 0 14 7 0   0     0   2   10 13                 23
1123090 1123090 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2017   grade_5 1 13 30 0   0     0   1   27 18                       45 1 13 30 0   0     0   1   27 18                 45
1123131 1123131 MA Suffolk   school 2502790 35   Boston 250279000338 350360 William Ellery Channing   Regular School No Elementary PK 05 2017   grade_5 3 12 9 0   0     0   2   7 19                       26 3 12 9 0   0     0   2   7 19                 26
1123136 1123136 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_5 2 4 10 0   0     0   0   12 4                       16 2 4 10 0   0     0   0   12 4                 16
1123159 1123159 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2017   grade_5 0 26 17 0   0     0   4   23 24                       47 0 26 17 0   0     0   4   23 24                 47
1123198 1123198 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Elementary KG 08 2017   grade_5 0 23 13 0   0     0   3   22 17                       39 0 23 13 0   0     0   3   22 17                 39
1123208 1123208 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2017   grade_5 1 17 8 0   0     0   1   12 15                       27 1 17 8 0   0     0   1   12 15                 27
1123219 1123219 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_5 2 25 20 0   0     0   0   25 22                       47 2 25 20 0   0     0   0   25 22                 47
1123230 1123230 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2017   grade_5 1 7 10 0   0     0   1   9 10                       19 1 7 10 0   0     0   1   9 10                 19
1123245 1123245 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No Elementary PK 05 2017   grade_5 2 6 58 0   0     0   0   30 36                       66 2 6 58 0   0     0   0   30 36                 66
1123408 1123408 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No Elementary PK 08 2017   grade_5 4 4 63 0   0     0   1   40 32                       72 4 4 63 0   0     0   1   40 32                 72
1123437 1123437 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No Elementary PK 08 2017   grade_5 1 1 26 0   0     0   0   9 19                       28 1 1 26 0   0     0   0   9 19                 28
1123566 1123566 MA Barnstable   school 2502970 41   Brewster 250297000841 410010 Eddy Elementary   Regular School No Elementary 03 05 2017   grade_5 65 4 6 0   0     0   2   38 39                       77 65 4 6 0   0     0   2   38 39                 77
1123596 1123596 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Manthala George Jr. School   Regular School No Elementary KG 05 2017   grade_5 23 69 66 0   0     0   6   81 83                       164 23 69 66 0   0     0   6   81 83                 164
1123619 1123619 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2017   grade_5 23 73 19 0   0     1   9   67 58                       125 23 73 19 0   0     1   9   67 58                 125
1123639 1123639 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Huntington   Regular School No Elementary KG 05 2017   grade_5 6 75 13 0   0     0   2   51 45                       96 6 75 13 0   0     0   2   51 45                 96
1123719 1123719 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_5 40 0 1 0   0     0   1   24 18                       42 40 0 1 0   0     0   1   24 18                 42
1123904 1123904 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative School No Elementary PK 05 2017   grade_5 21 9 7 0   0     0   7   23 21                       44 21 9 7 0   0     0   7   23 21                 44
1124024 1124024 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver Elementary School   Regular School No Elementary PK 05 2017   grade_5 121 1 1 0   0     0   3   78 48                       126 121 1 1 0   0     0   3   78 48                 126
1124138 1124138 MA Hampden   school 2503660 61   Chicopee 250366000492 610015 Bowe   Regular School No Elementary PK 05 2017   grade_5 23 4 34 0   0     0   0   21 40                       61 23 4 34 0   0     0   0   21 40                 61
1124145 1124145 MA Hampden   school 2503660 61   Chicopee 250366000493 610020 Bowie   Regular School No Elementary KG 05 2017   grade_5 41 2 14 0   0     0   3   28 32                       60 41 2 14 0   0     0   3   28 32                 60
1124187 1124187 MA Hampden   school 2503660 61   Chicopee 250366000500 610090 Gen John J Stefanik   Regular School No Elementary KG 05 2017   grade_5 9 2 43 0   0     0   4   31 27                       58 9 2 43 0   0     0   4   31 27                 58
1124212 1124212 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2017   grade_5 18 0 0 0   0     0   0   10 8                       18 18 0 0 0   0     0   0   10 8                 18
1124285 1124285 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No Elementary PK 06 2017   grade_5 23 0 0 0   0     0   1   14 10                       24 23 0 0 0   0     0   1   14 10                 24
1124300 1124300 MA Essex   school 2503990 71   Danvers 250399000531 710015 Great Oak   Regular School No Elementary KG 05 2017   grade_5 45 2 4 0   0     0   1   23 29                       52 45 2 4 0   0     0   1   23 29                 52
1124347 1124347 MA Bristol   school 2504020 72   Dartmouth 250402000542 720030 George H Potter   Regular School No Elementary KG 05 2017   grade_5 67 3 3 0   0     0   4   41 36                       77 67 3 3 0   0     0   4   41 36                 77
1124354 1124354 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 James M. Quinn School   Regular School No Elementary KG 05 2017   grade_5 110 1 4 0   0     0   9   78 46                       124 110 1 4 0   0     0   9   78 46                 124
1124602 1124602 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No Elementary PK 08 2017   grade_5 31 3 7 0   0     0   1   17 25                       42 31 3 7 0   0     0   1   17 25                 42
1124613 1124613 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No Elementary PK 06 2017   grade_5 19 0 1 0   0     0   2   12 10                       22 19 0 1 0   0     0   2   12 10                 22
1124657 1124657 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2017   grade_5 1 2 3 0   0     0   0   5 1                       6 1 2 3 0   0     0   0   5 1                 6
1124679 1124679 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2017   grade_5 18 22 55 0   0     0   1   47 49                       96 18 22 55 0   0     0   1   47 49                 96
1124817 1124817 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No Elementary 02 08 2017   grade_5 3 0 1 0   0     0   2   6 *                       6 3 0 1 0   0     0   2   6                   6
1124925 1124925 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   grade_5 8 0 0 0   0     1   0   3 6                       9 8 0 0 0   0     1   0   3 6                 9
1124990 1124990 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2017   grade_5 25 0 77 0   0     0   1   51 52                       103 25 0 77 0   0     0   1   51 52                 103
1125128 1125128 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2017   grade_5 99 2 2 0   0     0   0   58 45                       103 99 2 2 0   0     0   0   58 45                 103
1125151 1125151 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No Elementary KG 05 2017   grade_5 39 0 2 0   0     0   3   23 21                       44 39 0 2 0   0     0   3   23 21                 44
1125160 1125160 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No Elementary KG 05 2017   grade_5 31 0 1 0   0     0   0   16 16                       32 31 0 1 0   0     0   0   16 16                 32
1125167 1125167 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No Elementary KG 05 2017   grade_5 38 1 1 0   0     0   0   19 21                       40 38 1 1 0   0     0   0   19 21                 40
1125174 1125174 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 West Parish   Regular School No Elementary KG 05 2017   grade_5 59 3 2 0   0     0   0   32 32                       64 59 3 2 0   0     0   0   32 32                 64
1125320 1125320 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2017   grade_5 8 0 0 0   0     0   0   5 3                       8 8 0 0 0   0     0   0   5 3                 8
1125368 1125368 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2017   grade_5 29 1 0 0   0     0   0   16 14                       30 29 1 0 0   0     0   0   16 14                 30
1125463 1125463 MA Plymouth   school 2506090 131   Hingham 250609002671 1310005 East Elementary School   Regular School No Elementary PK 05 2017   grade_5 85 0 1 0   0     0   3   48 41                       89 85 0 1 0   0     0   3   48 41                 89
1125518 1125518 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No Elementary PK 06 2017   grade_5 31 2 0 0   0     0   0   15 18                       33 31 2 0 0   0     0   0   15 18                 33
1125550 1125550 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2017   grade_5 19 0 29 0   0     0   0   25 23                       48 19 0 29 0   0     0   0   25 23                 48
1125561 1125561 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No Elementary PK 08 2017   grade_5 1 1 33 0   0     0   1   14 22                       36 1 1 33 0   0     0   1   14 22                 36
1125567 1125567 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Elementary 04 08 2017   grade_5 4 2 54 0   0     0   2   41 21                       62 4 2 54 0   0     0   2   41 21                 62
1125577 1125577 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No Elementary KG 08 2017   grade_5 1 1 56 0   0     0   0   32 26                       58 1 1 56 0   0     0   0   32 26                 58
1125588 1125588 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No Elementary PK 08 2017   grade_5 5 2 39 0   0     0   0   25 21                       46 5 2 39 0   0     0   0   25 21                 46
1125598 1125598 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No Elementary KG 08 2017   grade_5 15 6 41 0   0     0   0   30 32                       62 15 6 41 0   0     0   0   30 32                 62
1125701 1125701 MA Plymouth   school 2506420 142   Hull 250642000932 1420015 Lillian M Jacobs   Regular School No Elementary PK 05 2017   grade_5 59 2 0 0   0     0   0   30 31                       61 59 2 0 0   0     0   0   30 31                 61
1125752 1125752 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No Elementary PK 06 2017   grade_5 32 0 0 0   0     0   0   13 19                       32 32 0 0 0   0     0   0   13 19                 32
1125785 1125785 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2017   grade_5 2 1 124 0   0     0   0   66 61                       127 2 1 124 0   0     0   0   66 61                 127
1125811 1125811 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2017   grade_5 8 0 100 0   0     0   2   46 64                       110 8 0 100 0   0     0   2   46 64                 110
1125821 1125821 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No Elementary KG 05 2017   grade_5 1 1 61 0   0     0   0   34 29                       63 1 1 61 0   0     0   0   34 29                 63
1125827 1125827 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2017   grade_5 7 1 95 0   0     0   0   54 49                       103 7 1 95 0   0     0   0   54 49                 103
1125843 1125843 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2017   grade_5 1 1 51 0   0     0   0   26 27                       53 1 1 51 0   0     0   0   26 27                 53
1125882 1125882 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_5 2 0 9 0   0     0   0   9 2                       11 2 0 9 0   0     0   0   9 2                 11
1125955 1125955 MA Worcester   school 2506780 153   Leominster 250678000981 1530007 Fall Brook   Regular School No Elementary KG 05 2017   grade_5 66 8 49 0   0     0   3   63 63                       126 66 8 49 0   0     0   3   63 63                 126
1126009 1126009 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No Elementary PK 06 2017   grade_5 13 0 2 0   0     0   2   11 6                       17 13 0 2 0   0     0   2   11 6                 17
1126318 1126318 MA Hampden   school 2507050 161   Ludlow 250705001057 1610023 Veterans Park Elementary   Regular School No Elementary 04 05 2017   grade_5 154 4 16 0   0     0   6   99 81                       180 154 4 16 0   0     0   6   99 81                 180
1126450 1126450 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary KG 06 2017   grade_5 2 1 6 0   0     0   1   10 *                       10 2 1 6 0   0     0   1   10                   10
1126466 1126466 MA Essex   school 2507110 163   Lynn 250711001066 1630090 Capt William G Shoemaker   Regular School No Elementary PK 05 2017   grade_5 14 5 8 0   0     0   4   17 14                       31 14 5 8 0   0     0   4   17 14                 31
1126690 1126690 MA Plymouth   school 2507350 171   Marshfield 250735000760 1710005 Eames Way School   Regular School No Elementary KG 05 2017   grade_5 48 0 1 0   0     0   0   26 23                       49 48 0 1 0   0     0   0   26 23                 49
1126697 1126697 MA Plymouth   school 2507350 171   Marshfield 250735001144 1710010 South River   Regular School No Elementary KG 05 2017   grade_5 55 0 1 0   0     0   1   29 28                       57 55 0 1 0   0     0   1   29 28                 57
1126705 1126705 MA Plymouth   school 2507350 171   Marshfield 250735001137 1710015 Daniel Webster   Regular School No Elementary PK 05 2017   grade_5 35 0 1 0   0     0   1   20 17                       37 35 0 1 0   0     0   1   20 17                 37
1126712 1126712 MA Plymouth   school 2507350 171   Marshfield 250735001140 1710020 Gov Edward Winslow   Regular School No Elementary KG 05 2017   grade_5 67 0 1 0   0     0   3   31 40                       71 67 0 1 0   0     0   3   31 40                 71
1126903 1126903 MA Middlesex   school 2507620 178   Melrose 250762001198 1780050 Winthrop   Regular School No Elementary KG 05 2017   grade_5 55 5 1 0   0     0   0   35 26                       61 55 5 1 0   0     0   0   35 26                 61
1127117 1127117 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No Elementary PK 06 2017   grade_5 17 0 0 0   0     0   0   10 7                       17 17 0 0 0   0     0   0   10 7                 17
1127242 1127242 MA Bristol   school 2508430 201   New Bedford 250843001322 2010015 Elizabeth Carter Brooks   Regular School No Elementary PK 05 2017   grade_5 19 5 11 0   0     0   1   10 26                       36 19 5 11 0   0     0   1   10 26                 36
1127250 1127250 MA Bristol   school 2508430 201   New Bedford 250843001324 2010020 Elwyn G Campbell   Regular School No Elementary PK 05 2017   grade_5 13 2 20 0   0     0   0   19 16                       35 13 2 20 0   0     0   0   19 16                 35
1127257 1127257 MA Bristol   school 2508430 201   New Bedford 250843001329 2010040 James B Congdon   Regular School No Elementary KG 05 2017   grade_5 22 8 17 0   0     0   1   12 36                       48 22 8 17 0   0     0   1   12 36                 48
1127272 1127272 MA Bristol   school 2508430 201   New Bedford 250843001332 2010050 John B Devalles   Regular School No Elementary KG 05 2017   grade_5 22 4 15 0   0     0   1   20 22                       42 22 4 15 0   0     0   1   20 22                 42
1127280 1127280 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 Alfred J Gomes   Regular School No Elementary PK 05 2017   grade_5 16 11 42 0   0     0   2   32 39                       71 16 11 42 0   0     0   2   32 39                 71

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