enrollments

Data source: Big Local News · About: Big Local

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

✎ 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                  
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
1123740 1123740 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Edward Devotion   Regular School No Elementary KG 08 2017   grade_4 59 4 21 0   8     0   8   52 48                       100 59 4 21 0   8     0   8   52 48                 100
1123995 1123995 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Dean S Luce   Regular School No Elementary KG 05 2017   grade_4 65 11 6 0   11     0   7   44 56                       100 65 11 6 0   11     0   7   44 56                 100
1124441 1124441 MA Middlesex   school 2504320 79   Dracut 250432000583 790020 Joseph A Campbell Elementary   Regular School No Elementary PK 05 2017   grade_4 89 3 7 0   1     0   0   52 48                       100 89 3 7 0   1     0   0   52 48                 100
1127066 1127066 MA Norfolk   school 2507980 189   Milton 250798002485 1890007 Cunningham School   Regular School No Elementary KG 05 2017   grade_4 78 11 6 0   3     0   2   60 40                       100 78 11 6 0   3     0   2   60 40                 100
1128824 1128824 MA Norfolk   school 2510620 266   Sharon 251062001702 2660005 Cottage Street   Regular School No Elementary KG 05 2017   grade_4 61 5 4 0   26     0   4   51 49                       100 61 5 4 0   26     0   4   51 49                 100
1128919 1128919 MA Bristol   school 2510860 273   Somerset 251086002536 2730008 North Elementary   Regular School No Elementary KG 05 2017   grade_4 88 3 7 0   2     0   0   54 46                       100 88 3 7 0   2     0   0   54 46                 100
1131617 1131617 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 11 2017   grade_4 80 3 11 0   0     0   6   48 52                       100 80 3 11 0   0     0   6   48 52                 100
1122935 1122935 MA Suffolk   school 2502790 35   Boston 250279000289 350227 Mather   Regular School No Elementary PK 05 2017   grade_4 4 41 27 0   23     0   6   57 44                       101 4 41 27 0   23     0   6   57 44                 101
1125961 1125961 MA Worcester   school 2506780 153   Leominster 250678002637 1530010 Frances Drake School   Regular School No Elementary KG 05 2017   grade_4 45 3 44 0   6     0   3   50 51                       101 45 3 44 0   6     0   3   50 51                 101
1130030 1130030 MA Middlesex   school 2512210 315   Wayland 251221002007 3150005 Claypit Hill School   Regular School No Elementary KG 05 2017   grade_4 76 7 1 0   10     1   6   40 61                       101 76 7 1 0   10     1   6   40 61                 101
1123638 1123638 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Huntington   Regular School No Elementary KG 05 2017   grade_4 4 83 12 1   1     0   1   53 49                       102 4 83 12 1   1     0   1   53 49                 102
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
1132162 1132162 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000808 6730010 Florence Roche School   Regular School No Elementary KG 04 2017   grade_4 87 2 3 0   5     0   5   44 58                       102 87 2 3 0   5     0   5   44 58                 102
1124087 1124087 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No Elementary 01 04 2017   grade_4 7 5 85 2   3     0   1   52 51                       103 7 5 85 2   3     0   1   52 51                 103
1132733 1132733 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No Elementary 03 06 2017   grade_4 95 1 3 0   1     0   3   50 53                       103 95 1 3 0   1     0   3   50 53                 103
1124639 1124639 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No Elementary KG 08 2017   grade_4 43 17 40 1   3     0   0   56 48                       104 43 17 40 1   3     0   0   56 48                 104
1125826 1125826 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2017   grade_4 3 0 99 0   0     0   2   56 48                       104 3 0 99 0   0     0   2   56 48                 104
1128315 1128315 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Clifford H Marshall Elementary   Regular School No Elementary KG 04 2017   grade_4 44 10 12 0   33     0   5   50 54                       104 44 10 12 0   33     0   5   50 54                 104
1128980 1128980 MA Middlesex   school 2510890 274   Somerville 251089001736 2740111 E Somerville Community   Regular School No Elementary KG 08 2017   grade_4 23 5 72 0   4     0   0   47 57                       104 23 5 72 0   4     0   0   47 57                 104
1129198 1129198 MA Hampden   school 2511130 281   Springfield 251113001804 2810080 Frederick Harris   Regular School No Elementary PK 05 2017   grade_4 19 20 60 0   4     0   1   56 48                       104 19 20 60 0   4     0   1   56 48                 104
1129556 1129556 MA Middlesex   school 2511340 288   Sudbury 251134001877 2880030 Peter Noyes   Regular School No Elementary PK 05 2017   grade_4 72 5 8 0   12     0   7   47 57                       104 72 5 8 0   12     0   7   47 57                 104
1129669 1129669 MA Bristol   school 2511520 293   Taunton 251152002697 2930015 Mulcahey Elementary School   Regular School No Elementary KG 04 2017   grade_4 62 16 19 0   0     1   6   59 45                       104 62 16 19 0   0     1   6   59 45                 104
1122227 1122227 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Hill-Roberts Elementary School   Regular School No Elementary KG 04 2017   grade_4 77 5 14 0   2     0   7   52 53                       105 77 5 14 0   2     0   7   52 53                 105
1123604 1123604 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brookfield   Regular School No Elementary KG 05 2017   grade_4 30 61 8 1   4     1   1   56 50                       106 30 61 8 1   4     1   1   56 50                 106
1123730 1123730 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No Elementary KG 08 2017   grade_4 64 3 8 0   26     0   5   54 52                       106 64 3 8 0   26     0   5   54 52                 106
1126400 1126400 MA Essex   school 2507110 163   Lynn 250711001087 1630040 Wm P Connery   Regular School No Elementary PK 05 2017   grade_4 5 6 75 0   18     0   2   54 52                       106 5 6 75 0   18     0   2   54 52                 106
1127216 1127216 MA Norfolk   school 2508370 199   Needham 250837000306 1990050 Newman Elementary   Regular School No Elementary PK 05 2017   grade_4 80 5 7 0   9     0   5   64 42                       106 80 5 7 0   9     0   5   64 42                 106
1130579 1130579 MA Worcester   school 2513080 343   Winchendon 251308000804 3430050 Toy Town Elementary   Regular School No Elementary 03 05 2017   grade_4 87 4 7 0   5     1   2   57 49                       106 87 4 7 0   5     1   2   57 49                 106
1122500 1122500 MA Middlesex   school 2502670 31   Billerica 250267000186 310005 Thomas Ditson   Regular School No Elementary KG 05 2017   grade_4 81 4 5 0   12     0   5   52 55                       107 81 4 5 0   12     0   5   52 55                 107
1122999 1122999 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2017   grade_4 3 54 48 0   1     1   0   53 54                       107 3 54 48 0   1     1   0   53 54                 107
1124668 1124668 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No Elementary KG 08 2017   grade_4 31 12 58 1   2     0   3   54 53                       107 31 12 58 1   2     0   3   54 53                 107
1124848 1124848 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No Elementary KG 04 2017   grade_4 82 4 10 0   3     0   8   56 51                       107 82 4 10 0   3     0   8   56 51                 107
1125017 1125017 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2017   grade_4 79 8 19 0   0     0   1   55 52                       107 79 8 19 0   0     0   1   55 52                 107
1125683 1125683 MA Middlesex   school 2506390 141   Hudson 250639000922 1410030 C A Farley   Regular School No Elementary PK 04 2017   grade_4 82 3 15 0   3     0   4   53 54                       107 82 3 15 0   3     0   4   53 54                 107
1126018 1126018 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Bridge   Regular School No Elementary KG 05 2017   grade_4 55 3 3 0   44     1   1   51 56                       107 55 3 3 0   44     1   1   51 56                 107
1127187 1127187 MA Norfolk   school 2508370 199   Needham 250837001306 1990005 Broadmeadow   Regular School No Elementary KG 05 2017   grade_4 87 1 5 0   6     0   8   51 56                       107 87 1 5 0   6     0   8   51 56                 107
1123664 1123664 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No Elementary KG 05 2017   grade_4 32 53 14 0   3     0   7   58 51                       109 32 53 14 0   3     0   7   58 51                 109
1127552 1127552 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Freeman-Kennedy School   Regular School No Elementary 03 06 2017   grade_4 90 1 7 0   6     0   5   52 57                       109 90 1 7 0   6     0   5   52 57                 109
1123528 1123528 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No Elementary 01 05 2017   grade_4 78 3 6 0   23     0   0   58 52                       110 78 3 6 0   23     0   0   58 52                 110
1126392 1126392 MA Essex   school 2507110 163   Lynn 250711001068 1630035 Cobbet Elementary   Regular School No Elementary KG 05 2017   grade_4 6 15 77 0   10     0   2   58 52                       110 6 15 77 0   10     0   2   58 52                 110
1132940 1132940 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000190 7800010 Louise A Conley   Regular School No Elementary KG 05 2017   grade_4 97 2 6 0   1     0   4   40 70                       110 97 2 6 0   1     0   4   40 70                 110
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
1124678 1124678 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2017   grade_4 21 23 60 0   5     0   2   56 55                       111 21 23 60 0   5     0   2   56 55                 111
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
1122074 1122074 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2017   grade_4 86 3 8 1   8     0   6   59 53                       112 86 3 8 1   8     0   6   59 53                 112
1122104 1122104 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2017   grade_4 74 2 9 1   19     0   7   68 44                       112 74 2 9 1   19     0   7   68 44                 112
1123006 1123006 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Elementary 03 08 2017   grade_4 26 23 48 1   8     0   6   52 60                       112 26 23 48 1   8     0   6   52 60                 112
1123588 1123588 MA Plymouth   school 2503090 44   Brockton 250309002649 440002 Mary E. Baker School   Regular School No Elementary KG 05 2017   grade_4 39 54 15 0   2     0   2   58 54                       112 39 54 15 0   2     0   2   58 54                 112
1123628 1123628 MA Plymouth   school 2503090 44   Brockton 250309000396 440045 Hancock   Regular School No Elementary KG 05 2017   grade_4 35 59 10 1   3     0   4   60 52                       112 35 59 10 1   3     0   4   60 52                 112
1124058 1124058 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Byam School   Regular School No Elementary KG 04 2017   grade_4 91 0 6 0   14     0   1   68 44                       112 91 0 6 0   14     0   1   68 44                 112
1127125 1127125 MA Nantucket   school 2508250 197   Nantucket 250825001278 1970005 Nantucket Elementary   Regular School No Elementary PK 05 2017   grade_4 52 12 42 0   3     0   3   61 51                       112 52 12 42 0   3     0   3   61 51                 112
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
1131344 1131344 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2017   grade_4 47 39 2 0   15     0   9   49 63                       112 47 39 2 0   15     0   9   49 63                 112
1125913 1125913 MA Worcester   school 2506720 151   Leicester 250672000971 1510005 Leicester Memorial Elementary   Regular School No Elementary 03 05 2017   grade_4 88 5 12 0   3     0   5   65 48                       113 88 5 12 0   3     0   5   65 48                 113
1126667 1126667 MA Middlesex   school 2507320 170   Marlborough 250732001135 1700025 Richer   Regular School No Elementary KG 04 2017   grade_4 45 5 57 0   2     0   4   52 61                       113 45 5 57 0   2     0   4   52 61                 113
1125968 1125968 MA Worcester   school 2506780 153   Leominster 250678000985 1530025 Johnny Appleseed   Regular School No Elementary KG 05 2017   grade_4 62 16 27 0   5     0   4   62 52                       114 62 16 27 0   5     0   4   62 52                 114
1125975 1125975 MA Worcester   school 2506780 153   Leominster 250678000988 1530030 Northwest   Regular School No Elementary KG 05 2017   grade_4 57 9 44 0   2     0   3   54 61                       115 57 9 44 0   2     0   3   54 61                 115
1126025 1126025 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Bowman   Regular School No Elementary KG 05 2017   grade_4 56 8 2 0   40     0   9   57 58                       115 56 8 2 0   40     0   9   57 58                 115
1126414 1126414 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No Elementary 01 05 2017   grade_4 6 11 88 0   7     0   3   58 57                       115 6 11 88 0   7     0   3   58 57                 115
1129773 1129773 MA Middlesex   school 2511760 301   Tyngsborough 251176001714 3010020 Tyngsborough Elementary   Regular School No Elementary PK 05 2017   grade_4 92 5 7 0   10     0   1   59 56                       115 92 5 7 0   10     0   1   59 56                 115
1130290 1130290 MA Middlesex   school 2512660 326   Westford 251266001737 3260045 John A. Crisafulli Elementary School   Regular School No Elementary 03 05 2017   grade_4 71 3 2 0   32     0   7   60 55                       115 71 3 2 0   32     0   7   60 55                 115
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
1126217 1126217 MA Middlesex   school 2507020 160   Lowell 250702001045 1600040 Peter W Reilly   Regular School No Elementary KG 04 2017   grade_4 47 8 47 0   10     0   4   52 64                       116 47 8 47 0   10     0   4   52 64                 116
1126545 1126545 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2017   grade_4 40 16 13 0   44     0   3   60 56                       116 40 16 13 0   44     0   3   60 56                 116
1126575 1126575 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No Elementary KG 08 2017   grade_4 41 22 19 0   28     0   6   60 56                       116 41 22 19 0   28     0   6   60 56                 116
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
1123611 1123611 MA Plymouth   school 2503090 44   Brockton 250309000401 440017 John F Kennedy   Regular School No Elementary KG 05 2017   grade_4 30 60 14 0   4     0   9   57 60                       117 30 60 14 0   4     0   9   57 60                 117
1126428 1126428 MA Essex   school 2507110 163   Lynn 250711001075 1630060 Ingalls   Regular School No Elementary KG 05 2017   grade_4 2 17 84 0   11     0   3   54 63                       117 2 17 84 0   11     0   3   54 63                 117
1128504 1128504 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2017   grade_4 54 3 52 0   6     0   2   62 55                       117 54 3 52 0   6     0   2   62 55                 117
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
1124878 1124878 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No Elementary KG 04 2017   grade_4 48 4 51 0   4     0   11   55 63                       118 48 4 51 0   4     0   11   55 63                 118
1125804 1125804 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No Elementary 01 04 2017   grade_4 5 0 113 0   0     0   0   56 62                       118 5 0 113 0   0     0   0   56 62                 118
1126765 1126765 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Fowler School   Regular School No Elementary 04 07 2017   grade_4 95 3 18 0   1     0   1   70 48                       118 95 3 18 0   1     0   1   70 48                 118
1129224 1129224 MA Hampden   school 2511130 281   Springfield 251113001810 2810100 Indian Orchard Elementary   Regular School No Elementary PK 05 2017   grade_4 21 19 77 0   0     0   1   66 52                       118 21 19 77 0   0     0   1   66 52                 118
1129657 1129657 MA Bristol   school 2511520 293   Taunton 251152001565 2930008 Joseph C Chamberlain   Regular School No Elementary KG 04 2017   grade_4 97 7 6 0   2     0   6   65 53                       118 97 7 6 0   2     0   6   65 53                 118
1130272 1130272 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No Elementary 03 05 2017   grade_4 97 0 0 3   15     0   3   65 53                       118 97 0 0 3   15     0   3   65 53                 118
1122418 1122418 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No Elementary PK 04 2017   grade_4 80 6 4 0   17     0   12   69 50                       119 80 6 4 0   17     0   12   69 50                 119
1124158 1124158 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No Elementary KG 05 2017   grade_4 64 6 46 0   1     0   2   51 68                       119 64 6 46 0   1     0   2   51 68                 119
1125432 1125432 MA Essex   school 2505970 128   Haverhill 250597000866 1280075 Tilton   Regular School No Elementary 01 04 2017   grade_4 68 7 40 0   2     0   2   55 64                       119 68 7 40 0   2     0   2   55 64                 119
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
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
1131330 1131330 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2017   grade_4 20 63 34 0   2     0   0   57 62                       119 20 63 34 0   2     0   0   57 62                 119
1122626 1122626 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2017   grade_4 19 24 69 0   3     0   5   59 61                       120 19 24 69 0   3     0   5   59 61                 120
1124649 1124649 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No Elementary KG 08 2017   grade_4 36 25 52 0   5     0   2   62 58                       120 36 25 52 0   5     0   2   62 58                 120
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
1129663 1129663 MA Bristol   school 2511520 293   Taunton 251152001065 2930010 East Taunton Elementary   Regular School No Elementary KG 04 2017   grade_4 93 13 10 1   2     0   1   57 63                       120 93 13 10 1   2     0   1   57 63                 120
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
1130560 1130560 MA Middlesex   school 2513050 342   Wilmington 251305001576 3420080 West Intermediate   Regular School No Elementary 04 05 2017   grade_4 96 2 12 0   8     0   2   56 64                       120 96 2 12 0   8     0   2   56 64                 120
1130944 1130944 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Quinsigamond   Regular School No Elementary PK 06 2017   grade_4 39 25 41 0   11     0   4   61 59                       120 39 25 41 0   11     0   4   61 59                 120

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);