enrollments

Data source: Big Local News · About: Big Local

956 rows where grade = "grade_4", state = "MA" and year = 2021 sorted by ccd_school_low_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 956 ✖

grade ✖

  • grade_4 · 956 ✖
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
1673281 1673281 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston - Horace Mann School for the Deaf   Special Education School No Other 01 12 2021   grade_4 * * * *   *     *   *   4 1 *                     5.0                         4 1                 5
1673336 1673336 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Braintree - Liberty   Regular School No Elementary 01 05 2021   grade_4 47 2 3 0   18     0   2   37 35 *                     72.0 47 2 3 0   18     0   2   37 35                 72
1673806 1673806 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 Chelsea - William A Berkowitz Elementary   Regular School No Elementary 01 04 2021   grade_4 6 8 112 0   0     0   0   69 57 *                     126.0 6 8 112 0   0     0   0   69 57                 126
1673810 1673810 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Chelsea - Edgar A Hooks Elementary   Regular School No Elementary 01 04 2021   grade_4 16 7 117 2   0     0   0   71 71 *                     142.0 16 7 117 2   0     0   0   71 71                 142
1673814 1673814 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 Chelsea - George F. Kelly Elementary   Regular School No Elementary 01 06 2021   grade_4 2 6 90 0   0     0   0   47 51 *                     98.0 2 6 90 0   0     0   0   47 51                 98
1673820 1673820 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Chelsea - Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2021   grade_4 6 4 126 0   0     0   1   81 56 *                     137.0 6 4 126 0   0     0   1   81 56                 137
1674025 1674025 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Dartmouth - Joseph Demello   Regular School No Elementary 01 05 2021   grade_4 74 2 6 0   1     0   9   54 38 *                     92.0 74 2 6 0   1     0   9   54 38                 92
1674052 1674052 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Dedham - Avery   Regular School No Elementary 01 05 2021   grade_4 26 11 21 0   1     0   4   28 35 *                     63.0 26 11 21 0   1     0   4   28 35                 63
1674057 1674057 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Dedham - Greenlodge   Regular School No Elementary 01 05 2021   grade_4 32 2 4 0   0     0   1   28 11 *                     39.0 32 2 4 0   0     0   1   28 11                 39
1674062 1674062 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Dedham - Oakdale   Regular School No Elementary 01 05 2021   grade_4 38 0 9 0   2     0   2   33 18 *                     51.0 38 0 9 0   2     0   2   33 18                 51
1674067 1674067 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Dedham - Riverdale   Regular School No Elementary 01 05 2021   grade_4 20 2 9 0   0     0   3   18 16 *                     34.0 20 2 9 0   0     0   3   18 16                 34
1674428 1674428 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River - Stone PK-12 School   Regular School No Other 01 12 2021   grade_4 * * * *   *     *   *   1 2 *                     3.0                         1 2                 3
1675213 1675213 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 Lawrence - South Lawrence East Elementary School   Regular School No Elementary 01 05 2021   grade_4 6 0 132 0   3     0   0   82 59 *                     141.0 6 0 132 0   3     0   0   82 59                 141
1675244 1675244 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Lawrence - Gerard A. Guilmette   Regular School No Elementary 01 04 2021   grade_4 1 1 117 0   1     0   1   60 61 *                     121.0 1 1 117 0   1     0   1   60 61                 121
1675256 1675256 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Lawrence - Francis M Leahy   Regular School No Elementary 01 05 2021   grade_4 1 0 91 0   0     0   0   46 46 *                     92.0 1 0 91 0   0     0   0   46 46                 92
1675261 1675261 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Lawrence - Oliver Partnership School   Regular School No Elementary 01 05 2021   grade_4 1 1 102 0   1     0   0   54 51 *                     105.0 1 1 102 0   1     0   0   54 51                 105
1675274 1675274 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 Lawrence - John K Tarbox   Regular School No Elementary 01 05 2021   grade_4 1 1 52 0   0     0   1   28 27 *                     55.0 1 1 52 0   0     0   1   28 27                 55
1675768 1675768 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Lynn - Robert L Ford   Regular School No Elementary 01 05 2021   grade_4 8 9 70 0   3     0   2   41 51 *                     92.0 8 9 70 0   3     0   2   41 51                 92
1675798 1675798 MA Essex   school 2507110 163   Lynn 250711002527 1630080 Lynn - William R Fallon   Regular School No Elementary 01 05 2021   grade_4 1 3 5 0   0     0   0   8 * *                     9.0 1 3 5 0   0     0   0   8                   9
1675822 1675822 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Lynn - Tracy   Regular School No Elementary 01 05 2021   grade_4 9 4 65 0   5     0   3   48 38 *                     86.0 9 4 65 0   5     0   3   48 38                 86
1676234 1676234 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Middleborough - Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2021   grade_4 86 1 3 0   2     0   9   47 54 *                     101.0 86 1 3 0   2     0   9   47 54                 101
1676239 1676239 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Middleborough - Mary K. Goode Elementary School   Regular School No Elementary 01 05 2021   grade_4 108 1 0 0   3     0   5   61 56 *                     117.0 108 1 0 0   3     0   5   61 56                 117
1676344 1676344 MA Hampden   school 2508040 191   Monson 250804002903 1910030 Monson - Granite Valley School   Regular School No Elementary 01 06 2021   grade_4 60 0 5 0   0     0   2   40 27 *                     67.0 60 0 5 0   0     0   2   40 27                 67
1676805 1676805 MA Essex   school 2508700 211   North Andover 250870001393 2110001 North Andover - Atkinson   Regular School No Elementary 01 05 2021   grade_4 41 3 11 0   6     0   2   35 28 *                     63.0 41 3 11 0   6     0   2   35 28                 63
1676812 1676812 MA Essex   school 2508700 211   North Andover 250870001395 2110010 North Andover - Franklin   Regular School No Elementary 01 05 2021   grade_4 53 0 7 0   15     0   4   45 34 *                     79.0 53 0 7 0   15     0   4   45 34                 79
1676817 1676817 MA Essex   school 2508700 211   North Andover 250870001396 2110015 North Andover - Kittredge   Regular School No Elementary 01 05 2021   grade_4 35 2 6 0   2     1   2   26 22 *                     48.0 35 2 6 0   2     1   2   26 22                 48
1676822 1676822 MA Essex   school 2508700 211   North Andover 250870000767 2110018 North Andover - Annie L Sargent School   Regular School No Elementary 01 05 2021   grade_4 65 2 8 0   10     0   3   55 33 *                     88.0 65 2 8 0   10     0   3   55 33                 88
1676827 1676827 MA Essex   school 2508700 211   North Andover 250870001399 2110020 North Andover - Thomson   Regular School No Elementary 01 05 2021   grade_4 36 3 10 0   7     0   3   22 37 *                     59.0 36 3 10 0   7     0   3   22 37                 59
1676999 1676999 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Norwood - Balch   Regular School No Elementary 01 05 2021   grade_4 29 11 27 0   2     0   1   36 34 *                     70.0 29 11 27 0   2     0   1   36 34                 70
1677004 1677004 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Norwood - Cornelius M Callahan   Regular School No Elementary 01 05 2021   grade_4 29 6 5 0   3     0   4   25 22 *                     47.0 29 6 5 0   3     0   4   25 22                 47
1677009 1677009 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 Norwood - F A Cleveland   Regular School No Elementary 01 05 2021   grade_4 44 5 8 0   5     0   0   37 25 *                     62.0 44 5 8 0   5     0   0   37 25                 62
1677014 1677014 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 Norwood - John P Oldham   Regular School No Elementary 01 05 2021   grade_4 25 6 7 0   2     0   2   21 21 *                     42.0 25 6 7 0   2     0   2   21 21                 42
1677196 1677196 MA Berkshire   school 2509630 236   Pittsfield 250963002914 2360030 Pittsfield - Crosby Educational Academy   Special Education School No Elementary 01 05 2021   grade_4 3 2 0 0   0     0   1   3 3 *                     6.0 3 2 0 0   0     0   1   3 3                 6
1677840 1677840 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Shrewsbury - Floral Street School   Regular School No Elementary 01 04 2021   grade_4 66 5 19 1   115     0   7   119 94 *                     213.0 66 5 19 1   115     0   7   119 94                 213
1678032 1678032 MA Hampden   school 2511130 281   Springfield 251113002723 2810005 Springfield - Springfield Public Day Elementary School   Regular School No Elementary 01 05 2021   grade_4 1 6 9 0   0     0   0   14 2 *                     16.0 1 6 9 0   0     0   0   14 2                 16
1679100 1679100 MA Hampden   school 2512510 332   West Springfield 251251002044 3320010 West Springfield - John R Fausey   Regular School No Elementary 01 05 2021   grade_4 58 0 15 0   3     0   4   40 40 *                     80.0 58 0 15 0   3     0   4   40 40                 80
1679105 1679105 MA Hampden   school 2512510 332   West Springfield 251251002047 3320025 West Springfield - Memorial   Regular School No Elementary 01 05 2021   grade_4 21 3 15 0   4     0   0   26 17 *                     43.0 21 3 15 0   4     0   0   26 17                 43
1679110 1679110 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 West Springfield - Mittineague   Regular School No Elementary 01 05 2021   grade_4 24 0 10 0   0     0   1   17 18 *                     35.0 24 0 10 0   0     0   1   17 18                 35
1673117 1673117 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston - Dr. William Henderson Upper   Regular School No Other 02 12 2021   grade_4 12 27 15 1   9     0   4   38 30 *                     68.0 12 27 15 1   9     0   4   38 30                 68
1673450 1673450 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton - Huntington Therapeutic Day School   Alternative School No Other 02 12 2021   grade_4 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1674090 1674090 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas - Douglas Elementary School   Regular School No Elementary 02 05 2021   grade_4 85 0 4 0   0     0   6   52 43 *                     95.0 85 0 4 0   0     0   6   52 43                 95
1674679 1674679 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Gardner - Elm Street School   Regular School No Elementary 02 04 2021   grade_4 93 1 33 0   3     0   10   63 77 *                     140.0 93 1 33 0   3     0   10   63 77                 140
1674772 1674772 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 Grafton - North Street Elementary School   Regular School No Elementary 02 06 2021   grade_4 82 1 7 1   7     0   4   47 55 *                     102.0 82 1 7 1   7     0   4   47 55                 102
1674777 1674777 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Grafton - Millbury Street Elementary School   Regular School No Elementary 02 06 2021   grade_4 94 2 10 0   22     0   8   81 55 *                     136.0 94 2 10 0   22     0   8   81 55                 136
1674858 1674858 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Hanover - Center Elementary   Regular School No Elementary 02 04 2021   grade_4 198 1 5 0   3     0   2   111 98 *                     209.0 198 1 5 0   3     0   2   111 98                 209
1676138 1676138 MA Norfolk   school 2507590 177   Medway 250759001015 1770015 Medway - Burke/Memorial Elementary School   Regular School No Elementary 02 04 2021   grade_4 126 5 11 0   4     0   3   69 80 *                     149.0 126 5 11 0   4     0   3   69 80                 149
1676903 1676903 MA Worcester   school 2508940 214   Northbridge 250894001447 2140001 Northbridge - W Edward Balmer   Regular School No Elementary 02 04 2021   grade_4 123 0 11 1   4     0   9   74 74 *                     148.0 123 0 11 1   4     0   9   74 74                 148
1677058 1677058 MA Worcester   school 2509270 226   Oxford 250927001481 2260005 Oxford - Clara Barton   Regular School No Elementary 02 04 2021   grade_4 116 6 12 0   0     0   7   76 65 *                     141.0 116 6 12 0   0     0   7   76 65                 141
1677996 1677996 MA Worcester   school 2511010 277   Southbridge 251101001770 2770020 Southbridge - West Street   Regular School No Elementary 02 05 2021   grade_4 27 0 54 0   0     0   0   40 41 *                     81.0 27 0 54 0   0     0   0   40 41                 81
1678017 1678017 MA Hampshire   school 2510920 278   South Hadley 251092002406 2780020 South Hadley - Mosier   Regular School No Elementary 02 04 2021   grade_4 113 2 20 0   2     0   6   67 76 *                     143.0 113 2 20 0   2     0   6   67 76                 143
1680317 1680317 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002367 6100005 Ashburnham-Westminster - Westminster Elementary   Regular School No Elementary 02 05 2021   grade_4 77 1 9 0   0     0   2   47 42 *                     89.0 77 1 9 0   0     0   2   47 42                 89
1680442 1680442 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001755 6250050 Bridgewater-Raynham - Laliberte Elementary School   Regular School No Elementary 02 04 2021   grade_4 148 21 5 0   4     0   7   90 95 *                     185.0 148 21 5 0   4     0   7   90 95                 185
1680559 1680559 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000588 6580005 Dudley-Charlton Reg - Dudley Elementary   Regular School No Elementary 02 04 2021   grade_4 94 3 9 0   1     0   1   54 54 *                     108.0 94 3 9 0   1     0   1   54 54                 108
1680568 1680568 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436002518 6580030 Dudley-Charlton Reg - Heritage School   Regular School No Elementary 02 04 2021   grade_4 121 1 7 0   0     0   7   71 65 *                     136.0 121 1 7 0   0     0   7   71 65                 136
1680676 1680676 MA Franklin   school 2505270 674   Gill-Montague 250527002385 6740050 Gill-Montague - Sheffield Elementary School   Regular School No Elementary 02 05 2021   grade_4 31 0 8 0   0     1   6   25 20 *                     46.0 31 0 8 0   0     1   6   25 20                 46
1680952 1680952 MA Middlesex   school 2508790 735   North Middlesex 250879002686 7350002 North Middlesex - Squannacook Early Childhood Center   Regular School No Elementary 02 04 2021   grade_4 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1681057 1681057 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Quabbin - Oakham Center   Regular School No Elementary 02 06 2021   grade_4 27 0 1 0   0     0   0   13 15 *                     28.0 27 0 1 0   0     0   0   13 15                 28
1672010 1672010 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Abington - Woodsdale Elementary School   Regular School No Elementary 03 04 2021   grade_4 129 7 20 2   2     1   1   83 79 *                     162.0 129 7 20 2   2     1   1   83 79                 162
1672208 1672208 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 Ashland - David Mindess   Regular School No Elementary 03 05 2021   grade_4 141 4 35 0   32     0   10   108 114 *                     222.0 141 4 35 0   32     0   10   108 114                 222
1672270 1672270 MA Worcester   school 2502220 17   Auburn 250222002846 170030 Auburn - Swanson Road Intermediate School   Regular School No Elementary 03 05 2021   grade_4 166 6 14 0   11     0   9   105 101 *                     206.0 166 6 14 0   11     0   9   105 101                 206
1672331 1672331 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Bedford - Lt Job Lane School   Regular School No Elementary 03 05 2021   grade_4 117 15 13 0   33     0   13   93 98 *                     191.0 117 15 13 0   33     0   13   93 98                 191
1672898 1672898 MA Suffolk   school 2502790 35   Boston 250279000339 350258 Boston - William H Ohrenberger   Regular School No Middle 03 08 2021   grade_4 32 18 28 0   6     0   5   47 42 *                     89.0 32 18 28 0   6     0   5   47 42                 89
1673070 1673070 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston - Higginson/Lewis K-8   Regular School No Middle 03 08 2021   grade_4 0 11 20 0   0     0   2   19 14 *                     33.0 0 11 20 0   0     0   2   19 14                 33
1673298 1673298 MA Barnstable   school 2502820 36   Bourne 250282002909 360030 Bourne - Bourne Intermediate School   Regular School No Elementary 03 05 2021   grade_4 115 3 4 1   2     0   3   59 69 *                     128.0 115 3 4 1   2     0   3   59 69                 128
1673313 1673313 MA Essex   school 2502880 38   Boxford 250288000358 380013 Boxford - Spofford Pond   Regular School No Elementary 03 06 2021   grade_4 83 0 2 0   5     0   9   51 48 *                     99.0 83 0 2 0   5     0   9   51 48                 99
1673365 1673365 MA Barnstable   school 2502970 41   Brewster 250297000841 410010 Brewster - Eddy Elementary   Regular School No Elementary 03 05 2021   grade_4 68 4 4 0   0     0   4   38 42 *                     80.0 68 4 4 0   0     0   4   38 42                 80
1673935 1673935 MA Norfolk   school 2503780 65   Cohasset 250378000519 650005 Cohasset - Deer Hill   Regular School No Elementary 03 05 2021   grade_4 105 2 1 0   2     0   4   60 54 *                     114.0 105 2 1 0   2     0   4   60 54                 114
1674140 1674140 MA Plymouth   school 2504410 82   Duxbury 250441000968 820004 Duxbury - Alden School   Regular School No Elementary 03 05 2021   grade_4 183 0 4 0   2     0   6   96 99 *                     195.0 183 0 4 0   2     0   6   96 99                 195
1674158 1674158 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 East Bridgewater - Gordon W. Mitchell School   Regular School No Elementary 03 06 2021   grade_4 134 3 3 1   1     0   7   78 71 *                     149.0 134 3 3 1   1     0   7   78 71                 149
1674200 1674200 MA Hampden   school 2504500 87   East Longmeadow 250450000604 870010 East Longmeadow - Mapleshade   Regular School No Elementary 03 05 2021   grade_4 55 2 12 0   5     0   2   53 23 *                     76.0 55 2 12 0   5     0   2   53 23                 76
1674207 1674207 MA Hampden   school 2504500 87   East Longmeadow 250450000606 870015 East Longmeadow - Mountain View   Regular School No Elementary 03 05 2021   grade_4 71 1 7 0   6     0   6   47 44 *                     91.0 71 1 7 0   6     0   6   47 44                 91
1674228 1674228 MA Bristol   school 2504620 88   Easton 250462000983 880025 Easton - Richardson Olmsted School   Regular School No Elementary 03 05 2021   grade_4 190 17 27 4   6     1   3   120 128 *                     248.0 190 17 27 4   6     1   3   120 128                 248
1675021 1675021 MA Middlesex   school 2506240 136   Holliston 250624001302 1360007 Holliston - Miller School   Regular School No Elementary 03 05 2021   grade_4 181 2 9 2   21     1   8   116 108 *                     224.0 181 2 9 2   21     1   8   116 108                 224
1675202 1675202 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston - Kingston Intermediate   Regular School No Elementary 03 06 2021   grade_4 136 1 2 0   0     0   1   73 67 *                     140.0 136 1 2 0   0     0   1   73 67                 140
1675223 1675223 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Lawrence - Alexander B Bruce   Regular School No Middle 03 08 2021   grade_4 1 2 61 0   0     0   1   38 27 *                     65.0 1 2 61 0   0     0   1   38 27                 65
1675482 1675482 MA Middlesex   school 2506960 158   Littleton 250696001013 1580015 Littleton - Russell St Elementary   Regular School No Elementary 03 05 2021   grade_4 98 1 2 0   9     0   2   56 56 *                     112.0 98 1 2 0   9     0   2   56 56                 112
1675611 1675611 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell - Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2021   grade_4 * * * *   *     *   *   3 * *                     3.0                         3                   3
1675688 1675688 MA Worcester   school 2507080 162   Lunenburg 250708002871 1620025 Lunenburg - Turkey Hill Elementary School   Regular School No Elementary 03 05 2021   grade_4 93 5 7 0   3     0   3   55 56 *                     111.0 93 5 7 0   3     0   3   55 56                 111
1675932 1675932 MA Bristol   school 2507230 167   Mansfield 250723001365 1670014 Mansfield - Jordan/Jackson Elementary   Regular School No Elementary 03 05 2021   grade_4 183 15 11 0   22     0   12   118 125 *                     243.0 183 15 11 0   22     0   12   118 125                 243
1675945 1675945 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Marblehead - Village School   Regular School No Elementary 03 06 2021   grade_4 173 4 15 0   4     0   4   108 92 *                     200.0 173 4 15 0   4     0   4   108 92                 200
1676048 1676048 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Mashpee - Quashnet School   Regular School No Elementary 03 06 2021   grade_4 62 7 7 9   1     0   11   44 53 *                     97.0 62 7 7 9   1     0   11   44 53                 97
1676256 1676256 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Middleton - Howe-Manning   Regular School No Elementary 03 06 2021   grade_4 71 1 5 0   3     0   3   35 48 *                     83.0 71 1 5 0   3     0   3   35 48                 83
1676267 1676267 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Milford - Woodland   Regular School No Elementary 03 05 2021   grade_4 198 14 96 3   3     1   9   164 160 *                     324.0 198 14 96 3   3     1   9   164 160                 324
1676370 1676370 MA Nantucket   school 2508250 197   Nantucket 250825002880 1970020 Nantucket - Nantucket Intermediate School   Regular School No Elementary 03 05 2021   grade_4 40 3 38 0   1     0   6   43 45 *                     88.0 40 3 38 0   1     0   6   43 45                 88
1676732 1676732 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Norfolk - Freeman-Kennedy School   Regular School No Elementary 03 06 2021   grade_4 124 0 3 0   6     0   6   73 66 *                     139.0 124 0 3 0   6     0   6   73 66                 139
1677043 1677043 MA Franklin   school 2509180 223   Orange 250918001475 2230010 Orange - Dexter Park   Regular School No Elementary 03 06 2021   grade_4 56 3 8 0   0     0   4   42 29 *                     71.0 56 3 8 0   0     0   4   42 29                 71
1677695 1677695 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Sandwich - Oak Ridge   Regular School No Elementary 03 06 2021   grade_4 143 4 11 1   4     0   4   83 84 *                     167.0 143 4 11 1   4     0   4   83 84                 167
1678250 1678250 MA Hampden   school 2511130 281   Springfield 251113002898 2810215 Springfield - Springfield International Academy at Johnson   Regular School No Elementary 03 05 2021   grade_4 0 4 7 0   0     0   0   5 6 *                     11.0 0 4 7 0   0     0   0   5 6                 11
1678456 1678456 MA Worcester   school 2511400 290   Sutton 251140001879 2900005 Sutton - Sutton Elementary   Regular School No Elementary 03 05 2021   grade_4 74 1 0 0   1     0   2   35 43 *                     78.0 74 1 0 0   1     0   2   35 43                 78
1678490 1678490 MA Bristol   school 2511460 292   Swansea 251146001890 2920006 Swansea - Elizabeth S Brown   Regular School No Elementary 03 05 2021   grade_4 88 0 1 0   1     0   0   49 41 *                     90.0 88 0 1 0   1     0   0   49 41                 90
1678500 1678500 MA Bristol   school 2511460 292   Swansea 251146001895 2920020 Swansea - Joseph G Luther   Regular School No Elementary 03 05 2021   grade_4 67 1 1 0   0     0   2   38 33 *                     71.0 67 1 1 0   0     0   2   38 33                 71
1678567 1678567 MA Middlesex   school 2511580 295   Tewksbury 251158001923 2950020 Tewksbury - North Street   Regular School No Elementary 03 04 2021   grade_4 117 9 16 0   3     1   1   72 75 *                     147.0 117 9 16 0   3     1   1   72 75                 147
1678571 1678571 MA Middlesex   school 2511580 295   Tewksbury 251158001924 2950025 Tewksbury - Louise Davy Trahan   Regular School No Elementary 03 04 2021   grade_4 108 2 10 0   7     0   1   61 67 *                     128.0 108 2 10 0   7     0   1   61 67                 128
1678782 1678782 MA Plymouth   school 2512060 310   Wareham 251206001989 3100017 Wareham - Minot Forest   Regular School No Elementary 03 04 2021   grade_4 85 10 16 2   2     0   19   52 82 *                     134.0 85 10 16 2   2     0   19   52 82                 134
1679016 1679016 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Westford - Abbot Elementary   Regular School No Elementary 03 05 2021   grade_4 66 0 2 0   24     0   3   48 47 *                     95.0 66 0 2 0   24     0   3   48 47                 95
1679019 1679019 MA Middlesex   school 2512660 326   Westford 251266000166 3260007 Westford - Day Elementary   Regular School No Elementary 03 05 2021   grade_4 45 0 3 0   38     0   6   44 48 *                     92.0 45 0 3 0   38     0   6   44 48                 92
1679030 1679030 MA Middlesex   school 2512660 326   Westford 251266001737 3260045 Westford - John A. Crisafulli Elementary School   Regular School No Elementary 03 05 2021   grade_4 80 1 2 0   32     0   5   55 65 *                     120.0 80 1 2 0   32     0   5   55 65                 120
1679079 1679079 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport - Westport Elementary   Regular School No Elementary 03 06 2021   grade_4 97 0 6 0   0     0   5   61 47 *                     108.0 97 0 6 0   0     0   5   61 47                 108
1679262 1679262 MA Worcester   school 2513080 343   Winchendon 251308000804 3430050 Winchendon - Toy Town Elementary   Regular School No Elementary 03 05 2021   grade_4 96 0 8 0   0     1   4   68 41 *                     109.0 96 0 8 0   0     1   4   68 41                 109
1679319 1679319 MA Suffolk   school 2513170 346   Winthrop 251317001841 3460020 Winthrop - Arthur T. Cummings Elementary School   Regular School No Elementary 03 05 2021   grade_4 117 3 27 0   0     0   2   75 74 *                     149.0 117 3 27 0   0     0   2   75 74                 149

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