enrollments

Data source: Big Local News · About: Big Local

975 rows where grade = "grade_2", state = "MA" and year = 2019 sorted by ccd_school_low_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 975 ✖

grade ✖

  • grade_2 · 975 ✖
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
2040148 2040148 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Swift River Elementary   Regular School No Elementary 01 03 2019   grade_2 138 2 7 0   1     0   9   79 78                       157.0 138 2 7 0   1     0   9   79 78                 157
2040819 2040819 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_2 3 1 3 0   0     0   1   7 1                       8.0 3 1 3 0   0     0   1   7 1                 8
2041166 2041166 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No Elementary 01 05 2019   grade_2 52 2 5 0   20     0   2   43 38                       81.0 52 2 5 0   20     0   2   43 38                 81
2041643 2041643 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No Elementary 01 04 2019   grade_2 9 8 114 0   0     0   0   70 61                       131.0 9 8 114 0   0     0   0   70 61                 131
2041647 2041647 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No Elementary 01 04 2019   grade_2 16 10 119 1   0     0   1   73 74                       147.0 16 10 119 1   0     0   1   73 74                 147
2041651 2041651 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 05 2019   grade_2 3 5 101 0   0     0   1   55 55                       110.0 3 5 101 0   0     0   1   55 55                 110
2041656 2041656 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2019   grade_2 4 7 137 0   1     0   0   87 62                       149.0 4 7 137 0   1     0   0   87 62                 149
2041864 2041864 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No Elementary 01 05 2019   grade_2 79 1 6 0   2     0   9   57 40                       97.0 79 1 6 0   2     0   9   57 40                 97
2041891 2041891 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No Elementary 01 05 2019   grade_2 28 9 26 1   0     0   6   32 38                       70.0 28 9 26 1   0     0   6   32 38                 70
2041896 2041896 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Greenlodge   Regular School No Elementary 01 05 2019   grade_2 38 1 4 0   1     0   1   31 14                       45.0 38 1 4 0   1     0   1   31 14                 45
2041901 2041901 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Oakdale   Regular School No Elementary 01 05 2019   grade_2 43 2 10 0   2     0   2   38 21                       59.0 43 2 10 0   2     0   2   38 21                 59
2041906 2041906 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No Elementary 01 05 2019   grade_2 20 3 7 0   0     0   3   18 15                       33.0 20 3 7 0   0     0   3   18 15                 33
2042733 2042733 MA Essex   school 2505970 128   Haverhill 250597000296 1280026 Golden Hill   Regular School No Elementary 01 04 2019   grade_2 48 6 71 0   3     0   4   66 66                       132.0 48 6 71 0   3     0   4   66 66                 132
2042766 2042766 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_2 * * * *   *     *   *   2 *                       2.0                         2                   2
2043050 2043050 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 South Lawrence East Elementary School   Regular School No Elementary 01 05 2019   grade_2 7 0 149 0   3     0   0   88 71                       159.0 7 0 149 0   3     0   0   88 71                 159
2043081 2043081 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No Elementary 01 04 2019   grade_2 4 2 104 0   1     0   1   57 55                       112.0 4 2 104 0   1     0   1   57 55                 112
2043093 2043093 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No Elementary 01 05 2019   grade_2 4 0 91 0   0     0   0   42 53                       95.0 4 0 91 0   0     0   0   42 53                 95
2043098 2043098 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2019   grade_2 1 1 107 0   1     0   0   56 54                       110.0 1 1 107 0   1     0   0   56 54                 110
2043111 2043111 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2019   grade_2 1 1 49 0   0     0   1   28 24                       52.0 1 1 49 0   0     0   1   28 24                 52
2043595 2043595 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No Elementary 01 05 2019   grade_2 10 8 68 0   5     0   5   42 54                       96.0 10 8 68 0   5     0   5   42 54                 96
2043647 2043647 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Tracy   Regular School No Elementary 01 05 2019   grade_2 10 7 66 0   6     0   5   53 41                       94.0 10 7 66 0   6     0   5   53 41                 94
2043772 2043772 MA Essex   school 2507260 168   Marblehead 250726001122 1680010 L H Coffin   Regular School No Elementary 01 03 2019   grade_2 67 2 10 0   2     0   2   45 38                       83.0 67 2 10 0   2     0   2   45 38                 83
2044055 2044055 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2019   grade_2 96 1 1 0   2     0   3   49 54                       103.0 96 1 1 0   2     0   3   49 54                 103
2044060 2044060 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No Elementary 01 05 2019   grade_2 112 4 0 0   1     0   2   62 57                       119.0 112 4 0 0   1     0   2   62 57                 119
2044629 2044629 MA Essex   school 2508700 211   North Andover 250870001393 2110001 Atkinson   Regular School No Elementary 01 05 2019   grade_2 46 4 15 0   8     0   2   38 37                       75.0 46 4 15 0   8     0   2   38 37                 75
2044636 2044636 MA Essex   school 2508700 211   North Andover 250870001395 2110010 Franklin   Regular School No Elementary 01 05 2019   grade_2 50 0 7 0   15     0   4   45 31                       76.0 50 0 7 0   15     0   4   45 31                 76
2044641 2044641 MA Essex   school 2508700 211   North Andover 250870001396 2110015 Kittredge   Regular School No Elementary 01 05 2019   grade_2 37 2 4 0   2     1   3   27 22                       49.0 37 2 4 0   2     1   3   27 22                 49
2044646 2044646 MA Essex   school 2508700 211   North Andover 250870000767 2110018 Annie L Sargent School   Regular School No Elementary 01 05 2019   grade_2 65 1 6 0   12     0   3   53 34                       87.0 65 1 6 0   12     0   3   53 34                 87
2044651 2044651 MA Essex   school 2508700 211   North Andover 250870001399 2110020 Thomson   Regular School No Elementary 01 05 2019   grade_2 38 3 10 0   5     0   3   25 34                       59.0 38 3 10 0   5     0   3   25 34                 59
2044824 2044824 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No Elementary 01 05 2019   grade_2 30 9 23 0   3     0   1   34 32                       66.0 30 9 23 0   3     0   1   34 32                 66
2044829 2044829 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Cornelius M Callahan   Regular School No Elementary 01 05 2019   grade_2 30 9 4 0   3     0   5   28 23                       51.0 30 9 4 0   3     0   5   28 23                 51
2044834 2044834 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 F A Cleveland   Regular School No Elementary 01 05 2019   grade_2 47 5 3 0   8     0   1   42 22                       64.0 47 5 3 0   8     0   1   42 22                 64
2044839 2044839 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 John P Oldham   Regular School No Elementary 01 05 2019   grade_2 26 8 3 0   5     0   0   20 22                       42.0 26 8 3 0   5     0   0   20 22                 42
2044844 2044844 MA Norfolk   school 2509060 220   Norwood 250906001461 2200025 Charles J Prescott   Regular School No Elementary 01 05 2019   grade_2 27 0 4 0   26     0   2   30 29                       59.0 27 0 4 0   26     0   2   30 29                 59
2045662 2045662 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2019   grade_2 67 5 11 1   111     0   6   111 90                       201.0 67 5 11 1   111     0   6   111 90                 201
2045849 2045849 MA Hampden   school 2511130 281   Springfield 251113002723 2810005 Springfield Public Day Elementary School   Regular School No Elementary 01 05 2019   grade_2 0 5 7 0   0     0   0   10 2                       12.0 0 5 7 0   0     0   0   10 2                 12
2046781 2046781 MA Plymouth   school 2512420 323   West Bridgewater 251242002037 3230003 Rose L Macdonald   Regular School No Elementary 01 03 2019   grade_2 76 4 4 1   1     0   4   43 47                       90.0 76 4 4 1   1     0   4   43 47                 90
2046923 2046923 MA Hampden   school 2512510 332   West Springfield 251251002047 3320025 Memorial   Regular School No Elementary 01 05 2019   grade_2 19 1 15 0   5     0   1   21 20                       41.0 19 1 15 0   5     0   1   21 20                 41
2046928 2046928 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 Mittineague   Regular School No Elementary 01 05 2019   grade_2 31 2 8 0   0     0   1   20 22                       42.0 31 2 8 0   0     0   1   20 22                 42
2047055 2047055 MA Middlesex   school 2513050 342   Wilmington 251305002159 3420020 Woburn Street   Regular School No Elementary 01 03 2019   grade_2 108 2 3 1   4     0   5   65 58                       123.0 108 2 3 1   4     0   5   65 58                 123
2047058 2047058 MA Middlesex   school 2513050 342   Wilmington 251305002153 3420025 Shawsheen Elementary   Regular School No Elementary 01 03 2019   grade_2 91 0 8 0   11     0   3   54 59                       113.0 91 0 8 0   11     0   3   54 59                 113
2040875 2040875 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Middle 02 08 2019   grade_2 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2040922 2040922 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2019   grade_2 17 26 15 0   7     0   6   41 30                       71.0 17 26 15 0   7     0   6   41 30                 71
2041928 2041928 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas Elementary School   Regular School No Elementary 02 05 2019   grade_2 83 0 2 0   0     0   4   50 39                       89.0 83 0 2 0   0     0   4   50 39                 89
2042514 2042514 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No Elementary 02 04 2019   grade_2 124 2 39 0   3     0   11   83 96                       179.0 124 2 39 0   3     0   11   83 96                 179
2042592 2042592 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No Elementary 02 06 2019   grade_2 81 1 5 1   7     0   4   44 55                       99.0 81 1 5 1   7     0   4   44 55                 99
2042597 2042597 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No Elementary 02 06 2019   grade_2 95 0 9 0   23     0   8   81 54                       135.0 95 0 9 0   23     0   8   81 54                 135
2042962 2042962 MA Middlesex   school 2506330 139   Hopkinton 250633000919 1390010 Elmwood   Regular School No Elementary 02 03 2019   grade_2 207 1 11 1   58     0   3   143 138                       281.0 207 1 11 1   58     0   3   143 138                 281
2043450 2043450 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 02 08 2019   grade_2 * * * *   *     *   *   1 *                       1.0                         1                   1
2043513 2043513 MA Hampden   school 2507050 161   Ludlow 250705002665 1610020 Chapin Street Elementary School   Regular School No Elementary 02 03 2019   grade_2 140 4 20 0   0     0   1   96 69                       165.0 140 4 20 0   0     0   1   96 69                 165
2043903 2043903 MA Norfolk   school 2507530 175   Medfield 250753001159 1750007 Ralph Wheelock School   Regular School No Elementary 02 03 2019   grade_2 173 1 14 0   6     0   8   116 86                       202.0 173 1 14 0   6     0   8   116 86                 202
2043958 2043958 MA Norfolk   school 2507590 177   Medway 250759001015 1770015 Burke/Memorial Elementary School   Regular School No Elementary 02 04 2019   grade_2 142 4 6 0   4     0   2   74 84                       158.0 142 4 6 0   4     0   2   74 84                 158
2044727 2044727 MA Worcester   school 2508940 214   Northbridge 250894001447 2140001 W Edward Balmer   Regular School No Elementary 02 04 2019   grade_2 121 0 14 1   4     0   9   79 70                       149.0 121 0 14 1   4     0   9   79 70                 149
2044882 2044882 MA Worcester   school 2509270 226   Oxford 250927001481 2260005 Clara Barton   Regular School No Elementary 02 04 2019   grade_2 113 4 14 0   0     0   8   74 65                       139.0 113 4 14 0   0     0   8   74 65                 139
2045806 2045806 MA Worcester   school 2510980 276   Southborough 251098001827 2760050 Albert S. Woodward Memorial School   Regular School No Elementary 02 03 2019   grade_2 86 1 2 1   23     0   11   61 63                       124.0 86 1 2 1   23     0   11   61 63                 124
2045811 2045811 MA Worcester   school 2511010 277   Southbridge 251101001763 2770005 Charlton Street   Regular School No Elementary 02 05 2019   grade_2 23 1 42 0   0     0   0   29 37                       66.0 23 1 42 0   0     0   0   29 37                 66
2045818 2045818 MA Worcester   school 2511010 277   Southbridge 251101001770 2770020 West Street   Regular School No Elementary 02 05 2019   grade_2 32 1 66 0   0     0   0   53 46                       99.0 32 1 66 0   0     0   0   53 46                 99
2045836 2045836 MA Hampshire   school 2510920 278   South Hadley 251092002406 2780020 Mosier   Regular School No Elementary 02 04 2019   grade_2 120 3 24 0   3     0   5   76 79                       155.0 120 3 24 0   3     0   5   76 79                 155
2048124 2048124 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002367 6100005 Westminster Elementary   Regular School No Elementary 02 05 2019   grade_2 76 1 10 0   0     0   3   49 41                       90.0 76 1 10 0   0     0   3   49 41                 90
2048238 2048238 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001755 6250050 Laliberte Elementary School   Regular School No Elementary 02 04 2019   grade_2 148 15 3 0   5     0   5   86 90                       176.0 148 15 3 0   5     0   5   86 90                 176
2048354 2048354 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000588 6580005 Dudley Elementary   Regular School No Elementary 02 04 2019   grade_2 87 3 10 0   1     0   2   56 47                       103.0 87 3 10 0   1     0   2   56 47                 103
2048363 2048363 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436002518 6580030 Heritage School   Regular School No Elementary 02 04 2019   grade_2 136 2 10 0   0     0   7   85 70                       155.0 136 2 10 0   0     0   7   85 70                 155
2048473 2048473 MA Franklin   school 2505270 674   Gill-Montague 250527002385 6740050 Sheffield Elementary School   Regular School No Elementary 02 05 2019   grade_2 34 0 6 0   0     1   8   29 20                       49.0 34 0 6 0   0     1   8   29 20                 49
2048525 2048525 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001464 6800050 Stony Hill School   Regular School No Elementary 02 03 2019   grade_2 141 6 9 0   6     0   6   83 85                       168.0 141 6 9 0   6     0   6   83 85                 168
2048693 2048693 MA Worcester   school 2508280 720   Narragansett 250828001283 7200005 Baldwinville Elementary   Regular School No Elementary 02 04 2019   grade_2 85 1 2 0   1     0   2   46 45                       91.0 85 1 2 0   1     0   2   46 45                 91
2048872 2048872 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2019   grade_2 18 1 1 0   0     0   0   8 12                       20.0 18 1 1 0   0     0   0   8 12                 20
2039815 2039815 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2019   grade_2 133 5 19 1   2     0   0   85 75                       160.0 133 5 19 1   2     0   0   85 75                 160
2039838 2039838 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2019   grade_2 60 2 3 0   0     1   1   30 37                       67.0 60 2 3 0   0     1   1   30 37                 67
2039843 2039843 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2019   grade_2 77 1 5 0   1     0   1   38 47                       85.0 77 1 5 0   1     0   1   38 47                 85
2039848 2039848 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2019   grade_2 64 3 7 0   1     0   3   38 40                       78.0 64 3 7 0   1     0   3   38 40                 78
2039853 2039853 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2019   grade_2 51 2 6 0   2     0   2   37 26                       63.0 51 2 6 0   2     0   2   37 26                 63
2039900 2039900 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2019   grade_2 19 6 11 0   8     0   3   19 28                       47.0 19 6 11 0   8     0   3   19 28                 47
2039907 2039907 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2019   grade_2 27 6 11 0   8     0   1   24 29                       53.0 27 6 11 0   8     0   1   24 29                 53
2039914 2039914 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2019   grade_2 66 1 5 0   9     0   7   54 34                       88.0 66 1 5 0   9     0   7   54 34                 88
2039920 2039920 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No Elementary KG 05 2019   grade_2 50 4 4 0   19     0   6   36 47                       83.0 50 4 4 0   19     0   6   36 47                 83
2039927 2039927 MA Essex   school 2501950 9   Andover 250195000048 90010 Henry C Sanborn Elementary   Regular School No Elementary KG 05 2019   grade_2 33 3 7 0   17     0   2   30 32                       62.0 33 3 7 0   17     0   2   30 32                 62
2039933 2039933 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No Elementary KG 05 2019   grade_2 73 0 1 0   8     0   0   46 36                       82.0 73 0 1 0   8     0   0   46 36                 82
2039939 2039939 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2019   grade_2 75 2 6 0   19     0   1   49 54                       103.0 75 2 6 0   19     0   1   49 54                 103
2039959 2039959 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2019   grade_2 54 4 2 0   14     0   1   44 31                       75.0 54 4 2 0   14     0   1   44 31                 75
2039965 2039965 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2019   grade_2 69 2 3 0   16     0   4   52 42                       94.0 69 2 3 0   16     0   4   52 42                 94
2039971 2039971 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2019   grade_2 67 1 2 0   19     0   1   49 41                       90.0 67 1 2 0   19     0   1   49 41                 90
2039977 2039977 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2019   grade_2 62 1 7 0   16     0   0   48 38                       86.0 62 1 7 0   16     0   0   48 38                 86
2039984 2039984 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2019   grade_2 31 1 0 0   9     0   1   26 16                       42.0 31 1 0 0   9     0   1   26 16                 42
2039990 2039990 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2019   grade_2 60 6 12 1   14     0   0   40 53                       93.0 60 6 12 1   14     0   0   40 53                 93
2039996 2039996 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2019   grade_2 41 2 4 0   23     0   1   41 30                       71.0 41 2 4 0   23     0   1   41 30                 71
2040010 2040010 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2019   grade_2 149 3 30 0   37     0   11   113 117                       230.0 149 3 30 0   37     0   11   113 117                 230
2040023 2040023 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2019   grade_2 47 7 13 0   1     0   4   32 40                       72.0 47 7 13 0   1     0   4   32 40                 72
2040029 2040029 MA Bristol   school 2502190 16   Attleboro 250219000098 160035 Thomas Willett Elementary School   Regular School No Elementary KG 04 2019   grade_2 44 3 14 0   2     0   8   32 39                       71.0 44 3 14 0   2     0   8   32 39                 71
2040034 2040034 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No Elementary KG 04 2019   grade_2 58 5 15 0   5     0   8   43 48                       91.0 58 5 15 0   5     0   8   43 48                 91
2040039 2040039 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Hill-Roberts Elementary School   Regular School No Elementary KG 04 2019   grade_2 54 12 15 0   4     0   10   55 40                       95.0 54 12 15 0   4     0   10   55 40                 95
2040044 2040044 MA Bristol   school 2502190 16   Attleboro 250219001294 160050 Peter Thacher Elementary School   Regular School No Elementary KG 04 2019   grade_2 57 8 14 0   4     0   11   46 48                       94.0 57 8 14 0   4     0   11   46 48                 94
2040069 2040069 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No Elementary KG 02 2019   grade_2 99 1 7 0   2     0   4   56 57                       113.0 99 1 7 0   2     0   4   56 57                 113
2040104 2040104 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2019   grade_2 48 3 6 0   3     0   4   36 28                       64.0 48 3 6 0   3     0   4   36 28                 64
2040108 2040108 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2019   grade_2 35 5 7 0   2     0   3   29 23                       52.0 35 5 7 0   2     0   3   29 23                 52
2040112 2040112 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No Elementary KG 03 2019   grade_2 26 16 27 0   1     0   7   33 44                       77.0 26 16 27 0   1     0   7   33 44                 77
2040116 2040116 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No Elementary KG 03 2019   grade_2 93 5 4 0   1     0   6   53 56                       109.0 93 5 4 0   1     0   6   53 56                 109
2040130 2040130 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary KG 02 2019   grade_2 126 13 9 0   34     0   15   100 97                       197.0 126 13 9 0   34     0   15   100 97                 197
2040160 2040160 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 Joseph F DiPietro Elementary School   Regular School No Elementary KG 03 2019   grade_2 81 0 3 0   2     0   0   44 42                       86.0 81 0 3 0   2     0   0   44 42                 86
2040164 2040164 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No Elementary KG 03 2019   grade_2 71 2 5 0   0     4   2   47 37                       84.0 71 2 5 0   0     4   2   47 37                 84
2040182 2040182 MA Middlesex   school 2502490 26   Belmont 250249000148 260005 Winn Brook   Regular School No Elementary KG 04 2019   grade_2 55 0 2 0   30     0   8   53 42                       95.0 55 0 2 0   30     0   8   53 42                 95

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