enrollments

Data source: Big Local News · About: Big Local

972 rows where grade = "grade_2", state = "MA" and year = 2020 sorted by ccd_school_low_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 972 ✖

grade ✖

  • grade_2 · 972 ✖
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
1365122 1365122 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Swift River Elementary   Regular School No Elementary 01 03 2020   grade_2 148 0 12 0   3     0   5   81 87 *                     168.0 148 0 12 0   3     0   5   81 87                 168
1366044 1366044 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other 01 12 2020   grade_2 2 5 2 0   0     0   0   6 3 *                     9.0 2 5 2 0   0     0   0   6 3                 9
1366100 1366100 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No Elementary 01 05 2020   grade_2 40 4 4 0   19     1   3   42 29 *                     71.0 40 4 4 0   19     1   3   42 29                 71
1366573 1366573 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No Elementary 01 04 2020   grade_2 6 10 108 0   0     0   7   66 65 *                     131.0 6 10 108 0   0     0   7   66 65                 131
1366577 1366577 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No Elementary 01 04 2020   grade_2 20 7 122 0   0     0   1   74 76 *                     150.0 20 7 122 0   0     0   1   74 76                 150
1366581 1366581 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 06 2020   grade_2 4 5 96 0   0     0   0   47 58 *                     105.0 4 5 96 0   0     0   0   47 58                 105
1366587 1366587 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2020   grade_2 12 7 124 0   0     0   2   66 79 *                     145.0 12 7 124 0   0     0   2   66 79                 145
1366794 1366794 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No Elementary 01 05 2020   grade_2 68 1 1 0   1     0   7   40 38 *                     78.0 68 1 1 0   1     0   7   40 38                 78
1366821 1366821 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No Elementary 01 05 2020   grade_2 33 4 15 0   1     1   1   28 27 *                     55.0 33 4 15 0   1     1   1   28 27                 55
1366826 1366826 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Greenlodge   Regular School No Elementary 01 05 2020   grade_2 40 2 4 0   0     0   2   28 20 *                     48.0 40 2 4 0   0     0   2   28 20                 48
1366831 1366831 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Oakdale   Regular School No Elementary 01 05 2020   grade_2 37 5 5 0   1     0   4   23 29 *                     52.0 37 5 5 0   1     0   4   23 29                 52
1366836 1366836 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No Elementary 01 05 2020   grade_2 22 2 5 0   1     0   1   21 10 *                     31.0 22 2 5 0   1     0   1   21 10                 31
1367196 1367196 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2020   grade_2 * * * *   *     *   *   3 1 *                     4.0                         3 1                 4
1367966 1367966 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 South Lawrence East Elementary School   Regular School No Elementary 01 05 2020   grade_2 5 3 129 0   2     0   0   68 71 *                     139.0 5 3 129 0   2     0   0   68 71                 139
1367997 1367997 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No Elementary 01 04 2020   grade_2 3 3 133 0   1     0   0   68 72 *                     140.0 3 3 133 0   1     0   0   68 72                 140
1368009 1368009 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No Elementary 01 05 2020   grade_2 1 2 84 0   0     0   0   42 45 *                     87.0 1 2 84 0   0     0   0   42 45                 87
1368014 1368014 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2020   grade_2 3 1 83 0   0     0   0   41 46 *                     87.0 3 1 83 0   0     0   0   41 46                 87
1368027 1368027 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2020   grade_2 1 0 54 0   0     0   0   33 22 *                     55.0 1 0 54 0   0     0   0   33 22                 55
1368524 1368524 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No Elementary 01 05 2020   grade_2 3 9 80 0   9     0   4   51 54 *                     105.0 3 9 80 0   9     0   4   51 54                 105
1368554 1368554 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary 01 05 2020   grade_2 1 0 5 0   0     0   0   6 * *                     6.0 1 0 5 0   0     0   0   6                   6
1368579 1368579 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Tracy   Regular School No Elementary 01 05 2020   grade_2 6 8 72 0   7     0   0   45 48 *                     93.0 6 8 72 0   7     0   0   45 48                 93
1368702 1368702 MA Essex   school 2507260 168   Marblehead 250726001122 1680010 L H Coffin   Regular School No Elementary 01 02 2020   grade_2 97 2 9 0   0     0   4   63 49 *                     112.0 97 2 9 0   0     0   4   63 49                 112
1368984 1368984 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2020   grade_2 94 3 3 3   1     0   5   62 47 *                     109.0 94 3 3 3   1     0   5   62 47                 109
1368989 1368989 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No Elementary 01 05 2020   grade_2 113 3 4 0   0     0   7   58 69 *                     127.0 113 3 4 0   0     0   7   58 69                 127
1369095 1369095 MA Hampden   school 2508040 191   Monson 250804002903 1910030 Granite Valley School   Regular School No Elementary 01 06 2020   grade_2 52 1 7 0   1     0   1   30 32 *                     62.0 52 1 7 0   1     0   1   30 32                 62
1369556 1369556 MA Essex   school 2508700 211   North Andover 250870001393 2110001 Atkinson   Regular School No Elementary 01 05 2020   grade_2 31 3 22 0   7     0   2   31 34 *                     65.0 31 3 22 0   7     0   2   31 34                 65
1369563 1369563 MA Essex   school 2508700 211   North Andover 250870001395 2110010 Franklin   Regular School No Elementary 01 05 2020   grade_2 53 5 5 0   6     0   3   44 28 *                     72.0 53 5 5 0   6     0   3   44 28                 72
1369568 1369568 MA Essex   school 2508700 211   North Andover 250870001396 2110015 Kittredge   Regular School No Elementary 01 05 2020   grade_2 39 1 4 0   1     0   4   24 25 *                     49.0 39 1 4 0   1     0   4   24 25                 49
1369573 1369573 MA Essex   school 2508700 211   North Andover 250870000767 2110018 Annie L Sargent School   Regular School No Elementary 01 05 2020   grade_2 70 2 7 0   12     0   3   50 44 *                     94.0 70 2 7 0   12     0   3   50 44                 94
1369578 1369578 MA Essex   school 2508700 211   North Andover 250870001399 2110020 Thomson   Regular School No Elementary 01 05 2020   grade_2 43 1 6 0   1     0   0   27 24 *                     51.0 43 1 6 0   1     0   0   27 24                 51
1369750 1369750 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No Elementary 01 05 2020   grade_2 32 5 26 0   4     1   2   36 34 *                     70.0 32 5 26 0   4     1   2   36 34                 70
1369755 1369755 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Cornelius M Callahan   Regular School No Elementary 01 05 2020   grade_2 33 6 1 0   6     0   1   23 24 *                     47.0 33 6 1 0   6     0   1   23 24                 47
1369760 1369760 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 F A Cleveland   Regular School No Elementary 01 05 2020   grade_2 35 3 9 0   5     1   4   31 26 *                     57.0 35 3 9 0   5     1   4   31 26                 57
1369765 1369765 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 John P Oldham   Regular School No Elementary 01 05 2020   grade_2 35 13 5 0   3     0   1   31 26 *                     57.0 35 13 5 0   3     0   1   31 26                 57
1370587 1370587 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2020   grade_2 57 11 18 4   77     0   13   102 78 *                     180.0 57 11 18 4   77     0   13   102 78                 180
1370774 1370774 MA Hampden   school 2511130 281   Springfield 251113002723 2810005 Springfield Public Day Elementary School   Regular School No Elementary 01 05 2020   grade_2 0 3 5 0   0     0   0   7 1 *                     8.0 0 3 5 0   0     0   0   7 1                 8
1371707 1371707 MA Plymouth   school 2512420 323   West Bridgewater 251242002037 3230003 Rose L Macdonald   Regular School No Elementary 01 03 2020   grade_2 78 2 4 0   1     0   5   49 41 *                     90.0 78 2 4 0   1     0   5   49 41                 90
1371844 1371844 MA Hampden   school 2512510 332   West Springfield 251251002044 3320010 John R Fausey   Regular School No Elementary 01 05 2020   grade_2 56 2 12 0   5     0   1   31 45 *                     76.0 56 2 12 0   5     0   1   31 45                 76
1371849 1371849 MA Hampden   school 2512510 332   West Springfield 251251002047 3320025 Memorial   Regular School No Elementary 01 05 2020   grade_2 20 1 9 0   0     0   1   13 18 *                     31.0 20 1 9 0   0     0   1   13 18                 31
1371854 1371854 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 Mittineague   Regular School No Elementary 01 05 2020   grade_2 25 2 6 0   1     0   1   14 21 *                     35.0 25 2 6 0   1     0   1   14 21                 35
1371981 1371981 MA Middlesex   school 2513050 342   Wilmington 251305002159 3420020 Woburn Street   Regular School No Elementary 01 03 2020   grade_2 126 4 5 0   6     0   7   68 80 *                     148.0 126 4 5 0   6     0   7   68 80                 148
1371984 1371984 MA Middlesex   school 2513050 342   Wilmington 251305002153 3420025 Shawsheen Elementary   Regular School No Elementary 01 03 2020   grade_2 99 1 7 0   6     0   5   55 63 *                     118.0 99 1 7 0   6     0   5   55 63                 118
1373778 1373778 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No Elementary 01 06 2020   grade_2 12 0 0 0   0     0   0   7 5 *                     12.0 12 0 0 0   0     0   0   7 5                 12
1365878 1365878 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2020   grade_2 29 15 13 0   12     0   2   35 36 *                     71.0 29 15 13 0   12     0   2   35 36                 71
1366859 1366859 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas Elementary School   Regular School No Elementary 02 05 2020   grade_2 68 0 5 0   0     0   6   39 40 *                     79.0 68 0 5 0   0     0   6   39 40                 79
1367443 1367443 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No Elementary 02 04 2020   grade_2 108 4 53 0   4     0   11   92 88 *                     180.0 108 4 53 0   4     0   11   92 88                 180
1367520 1367520 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No Elementary 02 06 2020   grade_2 87 4 4 0   10     0   5   55 55 *                     110.0 87 4 4 0   10     0   5   55 55                 110
1367525 1367525 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No Elementary 02 06 2020   grade_2 98 0 4 0   24     0   3   73 56 *                     129.0 98 0 4 0   24     0   3   73 56                 129
1367605 1367605 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Center Elementary   Regular School No Elementary 02 04 2020   grade_2 158 0 8 0   1     0   2   90 79 *                     169.0 158 0 8 0   1     0   2   90 79                 169
1367682 1367682 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_2 * * * *   *     *   *   1 * *                     1.0                         1                   1
1367882 1367882 MA Middlesex   school 2506330 139   Hopkinton 250633000919 1390010 Elmwood   Regular School No Elementary 02 03 2020   grade_2 149 2 12 0   76     0   15   127 127 *                     254.0 149 2 12 0   76     0   15   127 127                 254
1368430 1368430 MA Hampden   school 2507050 161   Ludlow 250705002665 1610020 Chapin Street Elementary School   Regular School No Elementary 02 03 2020   grade_2 129 1 25 0   1     0   7   81 82 *                     163.0 129 1 25 0   1     0   7   81 82                 163
1368832 1368832 MA Norfolk   school 2507530 175   Medfield 250753001159 1750007 Ralph Wheelock School   Regular School No Elementary 02 03 2020   grade_2 165 4 5 0   4     0   9   81 106 *                     187.0 165 4 5 0   4     0   9   81 106                 187
1368887 1368887 MA Norfolk   school 2507590 177   Medway 250759001015 1770015 Burke/Memorial Elementary School   Regular School No Elementary 02 04 2020   grade_2 141 2 6 1   2     0   2   73 81 *                     154.0 141 2 6 1   2     0   2   73 81                 154
1369654 1369654 MA Worcester   school 2508940 214   Northbridge 250894001447 2140001 W Edward Balmer   Regular School No Elementary 02 04 2020   grade_2 118 0 15 0   0     0   4   79 58 *                     137.0 118 0 15 0   0     0   4   79 58                 137
1369809 1369809 MA Worcester   school 2509270 226   Oxford 250927001481 2260005 Clara Barton   Regular School No Elementary 02 04 2020   grade_2 86 2 12 0   0     0   3   52 51 *                     103.0 86 2 12 0   0     0   3   52 51                 103
1370730 1370730 MA Worcester   school 2510980 276   Southborough 251098001827 2760050 Albert S. Woodward Memorial School   Regular School No Elementary 02 03 2020   grade_2 90 0 7 0   33     0   8   67 71 *                     138.0 90 0 7 0   33     0   8   67 71                 138
1370742 1370742 MA Worcester   school 2511010 277   Southbridge 251101001770 2770020 West Street   Regular School No Elementary 02 05 2020   grade_2 25 3 53 0   0     0   1   41 41 *                     82.0 25 3 53 0   0     0   1   41 41                 82
1370759 1370759 MA Hampshire   school 2510920 278   South Hadley 251092002406 2780020 Mosier   Regular School No Elementary 02 04 2020   grade_2 104 2 28 0   2     0   2   67 71 *                     138.0 104 2 28 0   2     0   2   67 71                 138
1373051 1373051 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002367 6100005 Westminster Elementary   Regular School No Elementary 02 05 2020   grade_2 70 1 6 0   1     0   1   37 42 *                     79.0 70 1 6 0   1     0   1   37 42                 79
1373177 1373177 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001755 6250050 Laliberte Elementary School   Regular School No Elementary 02 04 2020   grade_2 148 9 1 0   3     0   6   88 79 *                     167.0 148 9 1 0   3     0   6   88 79                 167
1373292 1373292 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000588 6580005 Dudley Elementary   Regular School No Elementary 02 04 2020   grade_2 102 3 17 0   1     0   4   62 65 *                     127.0 102 3 17 0   1     0   4   62 65                 127
1373301 1373301 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436002518 6580030 Heritage School   Regular School No Elementary 02 04 2020   grade_2 117 2 13 0   0     0   7   75 64 *                     139.0 117 2 13 0   0     0   7   75 64                 139
1373409 1373409 MA Franklin   school 2505270 674   Gill-Montague 250527002385 6740050 Sheffield Elementary School   Regular School No Elementary 02 05 2020   grade_2 47 0 10 0   0     0   2   34 25 *                     59.0 47 0 10 0   0     0   2   34 25                 59
1373462 1373462 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001464 6800050 Stony Hill School   Regular School No Elementary 02 03 2020   grade_2 133 4 10 0   3     0   3   70 83 *                     153.0 133 4 10 0   3     0   3   70 83                 153
1373806 1373806 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2020   grade_2 35 0 4 0   0     0   1   22 18 *                     40.0 35 0 4 0   0     0   1   22 18                 40
1364789 1364789 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2020   grade_2 119 10 10 2   3     0   1   68 77 *                     145.0 119 10 10 2   3     0   1   68 77                 145
1364812 1364812 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2020   grade_2 28 1 6 0   3     0   0   20 18 *                     38.0 28 1 6 0   3     0   0   20 18                 38
1364817 1364817 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2020   grade_2 56 0 6 0   2     0   5   39 30 *                     69.0 56 0 6 0   2     0   5   39 30                 69
1364822 1364822 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2020   grade_2 53 3 8 0   3     0   1   33 35 *                     68.0 53 3 8 0   3     0   1   33 35                 68
1364827 1364827 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2020   grade_2 47 2 6 0   2     0   2   28 31 *                     59.0 47 2 6 0   2     0   2   28 31                 59
1364873 1364873 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2020   grade_2 13 2 8 0   5     0   3   14 17 *                     31.0 13 2 8 0   5     0   3   14 17                 31
1364880 1364880 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2020   grade_2 30 9 11 0   11     0   3   30 34 *                     64.0 30 9 11 0   11     0   3   30 34                 64
1364887 1364887 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2020   grade_2 84 2 2 0   7     0   2   51 46 *                     97.0 84 2 2 0   7     0   2   51 46                 97
1364893 1364893 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No Elementary KG 05 2020   grade_2 40 4 7 0   30     0   3   57 27 *                     84.0 40 4 7 0   30     0   3   57 27                 84
1364900 1364900 MA Essex   school 2501950 9   Andover 250195000048 90010 Henry C Sanborn Elementary   Regular School No Elementary KG 05 2020   grade_2 36 2 4 0   11     0   1   23 31 *                     54.0 36 2 4 0   11     0   1   23 31                 54
1364906 1364906 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No Elementary KG 05 2020   grade_2 55 1 2 0   17     0   3   40 38 *                     78.0 55 1 2 0   17     0   3   40 38                 78
1364912 1364912 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2020   grade_2 61 2 5 0   18     0   0   44 42 *                     86.0 61 2 5 0   18     0   0   44 42                 86
1364932 1364932 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2020   grade_2 40 4 0 0   16     0   7   39 28 *                     67.0 40 4 0 0   16     0   7   39 28                 67
1364938 1364938 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2020   grade_2 62 1 1 0   9     0   9   43 39 *                     82.0 62 1 1 0   9     0   9   43 39                 82
1364944 1364944 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2020   grade_2 60 1 3 0   7     0   4   41 34 *                     75.0 60 1 3 0   7     0   4   41 34                 75
1364950 1364950 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2020   grade_2 49 3 5 0   12     0   10   33 46 *                     79.0 49 3 5 0   12     0   10   33 46                 79
1364957 1364957 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2020   grade_2 43 4 4 0   7     0   7   34 31 *                     65.0 43 4 4 0   7     0   7   34 31                 65
1364963 1364963 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2020   grade_2 50 1 8 0   9     0   4   32 39 *                     72.0 50 1 8 0   9     0   4   32 39                 72
1364969 1364969 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2020   grade_2 57 1 3 0   7     0   9   36 41 *                     77.0 57 1 3 0   7     0   9   36 41                 77
1364983 1364983 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2020   grade_2 118 7 27 0   43     0   9   103 101 *                     204.0 118 7 27 0   43     0   9   103 101                 204
1364996 1364996 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2020   grade_2 57 5 7 0   1     0   1   35 36 *                     71.0 57 5 7 0   1     0   1   35 36                 71
1365002 1365002 MA Bristol   school 2502190 16   Attleboro 250219000098 160035 Thomas Willett Elementary School   Regular School No Elementary KG 04 2020   grade_2 42 6 8 0   4     0   8   41 27 *                     68.0 42 6 8 0   4     0   8   41 27                 68
1365007 1365007 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No Elementary KG 04 2020   grade_2 57 3 21 0   4     0   7   44 48 *                     92.0 57 3 21 0   4     0   7   44 48                 92
1365012 1365012 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Hill-Roberts Elementary School   Regular School No Elementary KG 04 2020   grade_2 57 2 11 1   3     0   4   35 43 *                     78.0 57 2 11 1   3     0   4   35 43                 78
1365017 1365017 MA Bristol   school 2502190 16   Attleboro 250219001294 160050 Peter Thacher Elementary School   Regular School No Elementary KG 04 2020   grade_2 57 14 9 1   10     0   7   51 47 *                     98.0 57 14 9 1   10     0   7   51 47                 98
1365041 1365041 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No Elementary KG 02 2020   grade_2 78 2 12 0   3     0   1   52 44 *                     96.0 78 2 12 0   3     0   1   52 44                 96
1365074 1365074 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2020   grade_2 47 2 6 0   0     0   7   36 26 *                     62.0 47 2 6 0   0     0   7   36 26                 62
1365078 1365078 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2020   grade_2 42 4 6 0   1     0   7   34 26 *                     60.0 42 4 6 0   1     0   7   34 26                 60
1365082 1365082 MA Barnstable   school 2502310 20   Barnstable 250231002908 200012 Barnstable Community Innovation School   Regular School No Elementary KG 03 2020   grade_2 44 11 25 1   1     0   2   42 42 *                     84.0 44 11 25 1   1     0   2   42 42                 84
1365086 1365086 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No Elementary KG 03 2020   grade_2 29 11 28 0   3     0   13   35 49 *                     84.0 29 11 28 0   3     0   13   35 49                 84
1365090 1365090 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No Elementary KG 03 2020   grade_2 89 2 14 0   0     0   10   59 56 *                     115.0 89 2 14 0   0     0   10   59 56                 115
1365134 1365134 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 Joseph F DiPietro Elementary School   Regular School No Elementary KG 03 2020   grade_2 62 2 13 0   3     2   2   43 41 *                     84.0 62 2 13 0   3     2   2   43 41                 84
1365138 1365138 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No Elementary KG 03 2020   grade_2 58 1 3 0   1     2   4   38 31 *                     69.0 58 1 3 0   1     2   4   38 31                 69
1365156 1365156 MA Middlesex   school 2502490 26   Belmont 250249000148 260005 Winn Brook   Regular School No Elementary KG 04 2020   grade_2 61 3 3 0   20     0   9   54 42 *                     96.0 61 3 3 0   20     0   9   54 42                 96

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