enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1121950 1121950 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No Elementary 01 04 2017   grade_2 147 3 11 0   3     0   0   89 75                       164 147 3 11 0   3     0   0   89 75                 164
1122357 1122357 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Swift River Elementary   Regular School No Elementary 01 03 2017   grade_2 138 3 12 1   1     0   6   83 78                       161 138 3 12 1   1     0   6   83 78                 161
1123133 1123133 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_2 1 5 0 0   0     0   0   4 2                       6 1 5 0 0   0     0   0   4 2                 6
1123526 1123526 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No Elementary 01 05 2017   grade_2 57 0 4 0   27     0   2   43 47                       90 57 0 4 0   27     0   2   43 47                 90
1124080 1124080 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No Elementary 01 04 2017   grade_2 19 7 106 0   4     0   2   79 59                       138 19 7 106 0   4     0   2   79 59                 138
1124085 1124085 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No Elementary 01 04 2017   grade_2 19 15 162 0   1     0   3   107 93                       200 19 15 162 0   1     0   3   107 93                 200
1124090 1124090 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 04 2017   grade_2 6 5 142 0   2     0   2   86 71                       157 6 5 142 0   2     0   2   86 71                 157
1124095 1124095 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2017   grade_2 10 16 93 0   4     0   4   63 64                       127 10 16 93 0   4     0   4   63 64                 127
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
1124369 1124369 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No Elementary 01 05 2017   grade_2 32 5 12 1   3     0   2   26 29                       55 32 5 12 1   3     0   2   26 29                 55
1124375 1124375 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Greenlodge   Regular School No Elementary 01 05 2017   grade_2 46 1 1 0   0     0   4   28 24                       52 46 1 1 0   0     0   4   28 24                 52
1124381 1124381 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Oakdale   Regular School No Elementary 01 05 2017   grade_2 39 5 5 0   2     0   5   26 30                       56 39 5 5 0   2     0   5   26 30                 56
1124387 1124387 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No Elementary 01 05 2017   grade_2 18 3 9 0   1     0   0   15 16                       31 18 3 9 0   1     0   0   15 16                 31
1125422 1125422 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_2 * * * *   *     *   *   4 1                       *                         4 1                  
1125430 1125430 MA Essex   school 2505970 128   Haverhill 250597000866 1280075 Tilton   Regular School No Elementary 01 04 2017   grade_2 50 2 84 2   0     0   2   86 54                       140 50 2 84 2   0     0   2   86 54                 140
1125444 1125444 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_2 17 2 26 0   0     0   2   25 22                       47 17 2 26 0   0     0   2   25 22                 47
1125802 1125802 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No Elementary 01 04 2017   grade_2 6 4 124 0   0     0   1   67 68                       135 6 4 124 0   0     0   1   67 68                 135
1125824 1125824 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2017   grade_2 6 0 95 0   1     0   1   62 41                       103 6 0 95 0   1     0   1   62 41                 103
1125840 1125840 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2017   grade_2 1 0 75 0   0     0   0   45 31                       76 1 0 75 0   0     0   0   45 31                 76
1125879 1125879 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_2 1 0 9 0   0     0   0   6 4                       10 1 0 9 0   0     0   0   6 4                 10
1126375 1126375 MA Essex   school 2507110 163   Lynn 250711001064 1630020 Brickett Elementary   Regular School No Elementary 01 05 2017   grade_2 11 10 35 0   7     0   4   38 29                       67 11 10 35 0   7     0   4   38 29                 67
1126412 1126412 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No Elementary 01 05 2017   grade_2 8 4 60 0   9     0   2   49 34                       83 8 4 60 0   9     0   2   49 34                 83
1126476 1126476 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Tracy   Regular School No Elementary 01 05 2017   grade_2 9 11 62 0   2     0   8   42 50                       92 9 11 62 0   2     0   8   42 50                 92
1126964 1126964 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2017   grade_2 85 1 1 0   2     1   10   64 36                       100 85 1 1 0   2     1   10   64 36                 100
1126970 1126970 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No Elementary 01 05 2017   grade_2 103 3 2 1   0     0   1   44 66                       110 103 3 2 1   0     0   1   44 66                 110
1127872 1127872 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No Elementary 01 05 2017   grade_2 29 3 22 0   1     0   3   27 31                       58 29 3 22 0   1     0   3   27 31                 58
1127878 1127878 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Cornelius M Callahan   Regular School No Elementary 01 05 2017   grade_2 32 4 1 0   0     0   1   21 17                       38 32 4 1 0   0     0   1   21 17                 38
1127884 1127884 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 F A Cleveland   Regular School No Elementary 01 05 2017   grade_2 52 2 6 0   7     0   1   41 27                       68 52 2 6 0   7     0   1   41 27                 68
1127890 1127890 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 John P Oldham   Regular School No Elementary 01 05 2017   grade_2 35 5 4 0   4     0   0   22 26                       48 35 5 4 0   4     0   0   22 26                 48
1128574 1128574 MA Plymouth   school 2510170 251   Rockland 251017001641 2510025 R Stewart Esten   Regular School No Elementary 01 04 2017   grade_2 52 6 8 0   0     0   2   36 32                       68 52 6 8 0   0     0   2   36 32                 68
1128869 1128869 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2017   grade_2 65 5 13 2   95     0   10   98 92                       190 65 5 13 2   95     0   10   98 92                 190
1129046 1129046 MA Worcester   school 2511010 277   Southbridge 251101001763 2770005 Charlton Street   Regular School No Elementary 01 05 2017   grade_2 36 3 42 1   1     0   1   48 36                       84 36 3 42 1   1     0   1   48 36                 84
1129055 1129055 MA Worcester   school 2511010 277   Southbridge 251101001770 2770020 West Street   Regular School No Elementary 01 05 2017   grade_2 47 1 55 0   2     0   2   58 49                       107 47 1 55 0   2     0   2   58 49                 107
1129828 1129828 MA Middlesex   school 2511910 305   Wakefield 251191001948 3050040 Walton   Regular School No Elementary 01 04 2017   grade_2 41 0 2 0   2     0   3   25 23                       48 41 0 2 0   2     0   3   25 23                 48
1130185 1130185 MA Plymouth   school 2512420 323   West Bridgewater 251242002037 3230003 Rose L Macdonald   Regular School No Elementary 01 03 2017   grade_2 70 4 4 0   3     0   0   38 43                       81 70 4 4 0   3     0   0   38 43                 81
1130379 1130379 MA Hampden   school 2512510 332   West Springfield 251251002047 3320025 Memorial   Regular School No Elementary 01 05 2017   grade_2 26 3 13 0   6     0   2   25 25                       50 26 3 13 0   6     0   2   25 25                 50
1130385 1130385 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 Mittineague   Regular School No Elementary 01 05 2017   grade_2 21 2 7 0   0     0   0   12 18                       30 21 2 7 0   0     0   0   12 18                 30
1130391 1130391 MA Hampden   school 2512510 332   West Springfield 251251002050 3320040 Tatham   Regular School No Elementary 01 05 2017   grade_2 40 1 5 0   0     0   1   26 21                       47 40 1 5 0   0     0   1   26 21                 47
1130550 1130550 MA Middlesex   school 2513050 342   Wilmington 251305002159 3420020 Woburn Street   Regular School No Elementary 01 03 2017   grade_2 88 0 8 0   5     0   5   58 48                       106 88 0 8 0   5     0   5   58 48                 106
1130554 1130554 MA Middlesex   school 2513050 342   Wilmington 251305002153 3420025 Shawsheen Elementary   Regular School No Elementary 01 03 2017   grade_2 92 1 10 0   5     0   4   57 55                       112 92 1 10 0   5     0   4   57 55                 112
1124414 1124414 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas Elementary School   Regular School No Elementary 02 05 2017   grade_2 82 0 0 0   0     0   1   45 38                       83 82 0 0 0   0     0   1   45 38                 83
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                    
1125098 1125098 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No Elementary 02 04 2017   grade_2 129 6 30 1   0     0   24   103 87                       190 129 6 30 1   0     0   24   103 87                 190
1125208 1125208 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No Elementary 02 06 2017   grade_2 112 0 8 0   9     0   6   68 67                       135 112 0 8 0   9     0   6   68 67                 135
1125214 1125214 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No Elementary 02 06 2017   grade_2 90 1 11 0   26     0   1   68 61                       129 90 1 11 0   26     0   1   68 61                 129
1125650 1125650 MA Middlesex   school 2506330 139   Hopkinton 250633000919 1390010 Elmwood   Regular School No Elementary 02 03 2017   grade_2 195 2 7 1   36     1   8   136 114                       250 195 2 7 1   36     1   8   136 114                 250
1126247 1126247 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Elementary 02 07 2017   grade_2 * * * *   *     *   *   1 *                       *                         1                    
1126314 1126314 MA Hampden   school 2507050 161   Ludlow 250705002665 1610020 Chapin Street Elementary School   Regular School No Elementary 02 03 2017   grade_2 132 2 16 1   1     0   4   68 88                       156 132 2 16 1   1     0   4   68 88                 156
1126622 1126622 MA Essex   school 2507260 168   Marblehead 250726001122 1680010 L H Coffin   Regular School No Elementary 02 03 2017   grade_2 58 2 9 0   3     0   7   41 38                       79 58 2 9 0   3     0   7   41 38                 79
1126783 1126783 MA Norfolk   school 2507530 175   Medfield 250753001159 1750007 Ralph Wheelock School   Regular School No Elementary 02 03 2017   grade_2 148 2 14 3   5     0   2   102 72                       174 148 2 14 3   5     0   2   102 72                 174
1126854 1126854 MA Norfolk   school 2507590 177   Medway 250759001015 1770015 Burke/Memorial Elementary School   Regular School No Elementary 02 04 2017   grade_2 145 0 4 0   1     0   6   77 79                       156 145 0 4 0   1     0   6   77 79                 156
1127758 1127758 MA Worcester   school 2508940 214   Northbridge 250894001447 2140001 W Edward Balmer   Regular School No Elementary 02 04 2017   grade_2 146 1 14 0   0     0   10   78 93                       171 146 1 14 0   0     0   10   78 93                 171
1127941 1127941 MA Worcester   school 2509270 226   Oxford 250927001481 2260005 Clara Barton   Regular School No Elementary 02 04 2017   grade_2 111 4 10 0   0     0   8   66 67                       133 111 4 10 0   0     0   8   66 67                 133
1129038 1129038 MA Worcester   school 2510980 276   Southborough 251098001827 2760050 Albert S. Woodward Memorial School   Regular School No Elementary 02 03 2017   grade_2 87 1 5 0   25     0   9   65 62                       127 87 1 5 0   25     0   9   65 62                 127
1129073 1129073 MA Hampshire   school 2510920 278   South Hadley 251092002406 2780020 Mosier   Regular School No Elementary 02 04 2017   grade_2 115 2 25 1   2     0   3   74 74                       148 115 2 25 1   2     0   3   74 74                 148
1131773 1131773 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002367 6100005 Westminster Elementary   Regular School No Elementary 02 05 2017   grade_2 68 2 5 0   0     0   3   43 35                       78 68 2 5 0   0     0   3   43 35                 78
1131907 1131907 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001755 6250050 Laliberte Elementary School   Regular School No Elementary 02 04 2017   grade_2 141 8 2 0   4     0   4   71 88                       159 141 8 2 0   4     0   4   71 88                 159
1132046 1132046 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000588 6580005 Dudley Elementary   Regular School No Elementary 02 04 2017   grade_2 110 3 13 0   0     0   3   81 48                       129 110 3 13 0   0     0   3   81 48                 129
1132058 1132058 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436002518 6580030 Heritage School   Regular School No Elementary 02 04 2017   grade_2 132 3 13 0   0     0   6   83 71                       154 132 3 13 0   0     0   6   83 71                 154
1132186 1132186 MA Franklin   school 2505270 674   Gill-Montague 250527002385 6740050 Sheffield Elementary School   Regular School No Elementary 02 05 2017   grade_2 40 0 9 0   0     0   5   32 22                       54 40 0 9 0   0     0   5   32 22                 54
1132245 1132245 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001464 6800050 Stony Hill School   Regular School No Elementary 02 03 2017   grade_2 118 2 11 0   6     0   7   75 69                       144 118 2 11 0   6     0   7   75 69                 144
1132430 1132430 MA Worcester   school 2508280 720   Narragansett 250828001283 7200005 Baldwinville Elementary   Regular School No Elementary 02 04 2017   grade_2 89 0 5 0   0     0   6   49 51                       100 89 0 5 0   0     0   6   49 51                 100
1132641 1132641 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2017   grade_2 28 0 0 0   0     0   0   8 20                       28 28 0 0 0   0     0   0   8 20                 28
1125262 1125262 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_2 * * * *   *     *   *   * *                       *                                              
1125188 1125188 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_2 * * * *   *     *   *   * *                       *                                              
1121981 1121981 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2017   grade_2 53 0 11 0   1     0   1   39 27                       66 53 0 11 0   1     0   1   39 27                 66
1121987 1121987 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2017   grade_2 66 3 2 0   1     0   0   51 21                       72 66 3 2 0   1     0   0   51 21                 72
1121993 1121993 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2017   grade_2 46 1 6 0   4     0   4   37 24                       61 46 1 6 0   4     0   4   37 24                 61
1121999 1121999 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2017   grade_2 50 4 5 0   1     0   1   31 30                       61 50 4 5 0   1     0   1   31 30                 61
1122056 1122056 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2017   grade_2 19 1 9 0   9     0   4   21 21                       42 19 1 9 0   9     0   4   21 21                 42
1122064 1122064 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2017   grade_2 29 4 10 0   11     0   5   35 24                       59 29 4 10 0   11     0   5   35 24                 59
1122072 1122072 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2017   grade_2 73 7 4 1   6     0   5   47 49                       96 73 7 4 1   6     0   5   47 49                 96
1122079 1122079 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No Elementary KG 05 2017   grade_2 42 1 7 0   21     0   2   41 32                       73 42 1 7 0   21     0   2   41 32                 73
1122088 1122088 MA Essex   school 2501950 9   Andover 250195000048 90010 Henry C Sanborn Elementary   Regular School No Elementary KG 05 2017   grade_2 42 2 3 0   20     0   1   36 32                       68 42 2 3 0   20     0   1   36 32                 68
1122095 1122095 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No Elementary KG 05 2017   grade_2 50 0 2 0   16     0   0   41 27                       68 50 0 2 0   16     0   0   41 27                 68
1122102 1122102 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2017   grade_2 82 1 5 0   15     0   4   50 57                       107 82 1 5 0   15     0   4   50 57                 107
1122126 1122126 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2017   grade_2 49 3 1 0   10     0   6   40 29                       69 49 3 1 0   10     0   6   40 29                 69
1122133 1122133 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2017   grade_2 68 1 8 0   7     1   8   48 45                       93 68 1 8 0   7     1   8   48 45                 93
1122140 1122140 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2017   grade_2 61 1 4 0   8     0   5   37 42                       79 61 1 4 0   8     0   5   37 42                 79
1122147 1122147 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2017   grade_2 47 4 6 1   14     0   4   46 30                       76 47 4 6 1   14     0   4   46 30                 76
1122156 1122156 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2017   grade_2 27 3 6 0   7     0   1   19 25                       44 27 3 6 0   7     0   1   19 25                 44
1122163 1122163 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2017   grade_2 55 4 6 1   13     1   6   46 40                       86 55 4 6 1   13     1   6   46 40                 86
1122170 1122170 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2017   grade_2 44 0 4 0   8     0   2   31 27                       58 44 0 4 0   8     0   2   31 27                 58
1122188 1122188 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2017   grade_2 159 5 15 4   32     0   4   104 115                       219 159 5 15 4   32     0   4   104 115                 219
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
1122261 1122261 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No Elementary KG 02 2017   grade_2 67 2 11 0   6     0   2   45 43                       88 67 2 11 0   6     0   2   45 43                 88
1122265 1122265 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary KG 02 2017   grade_2 76 2 10 0   3     0   2   49 44                       93 76 2 10 0   3     0   2   49 44                 93
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
1122333 1122333 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary KG 02 2017   grade_2 137 14 10 0   35     0   10   103 103                       206 137 14 10 0   35     0   10   103 103                 206
1122372 1122372 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 South Elementary   Regular School No Elementary KG 03 2017   grade_2 89 0 2 0   2     0   1   47 47                       94 89 0 2 0   2     0   1   47 47                 94
1122377 1122377 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No Elementary KG 03 2017   grade_2 79 2 3 0   2     0   3   38 51                       89 79 2 3 0   2     0   3   38 51                 89
1122397 1122397 MA Middlesex   school 2502490 26   Belmont 250249000148 260005 Winn Brook   Regular School No Elementary KG 04 2017   grade_2 64 0 3 0   24     0   5   51 45                       96 64 0 3 0   24     0   5   51 45                 96
1122403 1122403 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Mary Lee Burbank   Regular School No Elementary KG 04 2017   grade_2 64 3 4 0   12     0   8   45 46                       91 64 3 4 0   12     0   8   45 46                 91

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