enrollments

Data source: Big Local News · About: Big Local

976 rows where grade = "grade_2", state = "MA" and year = 2018 sorted by ccd_school_low_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 976 ✖

grade ✖

  • grade_2 · 976 ✖
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
2230205 2230205 MA Suffolk   school   35   Boston   350652               2018   grade_2 * * * *   *     *   *   * *                       0.0                                             0
2229163 2229163 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Belchertown: Swift River Elementary   Regular School No Elementary 01 03 2018   grade_2 138 4 4 2   3     0   5   82 74                       156.0 138 4 4 2   3     0   5   82 74                 156
2230344 2230344 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Braintree: Liberty   Regular School No Elementary 01 05 2018   grade_2 56 1 1 0   25     0   3   42 44                       86.0 56 1 1 0   25     0   3   42 44                 86
2230895 2230895 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 Chelsea: William A Berkowitz Elementary   Regular School No Elementary 01 04 2018   grade_2 6 8 103 0   1     0   1   65 54                       119.0 6 8 103 0   1     0   1   65 54                 119
2230900 2230900 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Chelsea: Edgar A Hooks Elementary   Regular School No Elementary 01 04 2018   grade_2 13 8 127 0   1     0   4   89 64                       153.0 13 8 127 0   1     0   4   89 64                 153
2230905 2230905 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 Chelsea: George F. Kelly Elementary   Regular School No Elementary 01 04 2018   grade_2 9 3 107 0   0     0   1   57 63                       120.0 9 3 107 0   0     0   1   57 63                 120
2230910 2230910 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Chelsea: Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2018   grade_2 15 4 118 0   0     0   2   66 73                       139.0 15 4 118 0   0     0   2   66 73                 139
2231153 2231153 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Dartmouth: Joseph Demello   Regular School No Elementary 01 05 2018   grade_2 62 0 2 0   0     0   3   31 36                       67.0 62 0 2 0   0     0   3   31 36                 67
2231186 2231186 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Dedham: Avery   Regular School No Elementary 01 05 2018   grade_2 24 6 13 0   1     0   4   21 27                       48.0 24 6 13 0   1     0   4   21 27                 48
2231192 2231192 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Dedham: Greenlodge   Regular School No Elementary 01 05 2018   grade_2 30 3 3 0   1     0   0   19 18                       37.0 30 3 3 0   1     0   0   19 18                 37
2231198 2231198 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Dedham: Oakdale   Regular School No Elementary 01 05 2018   grade_2 37 4 6 0   1     0   7   21 34                       55.0 37 4 6 0   1     0   7   21 34                 55
2231204 2231204 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Dedham: Riverdale   Regular School No Elementary 01 05 2018   grade_2 26 3 3 0   1     0   1   18 16                       34.0 26 3 3 0   1     0   1   18 16                 34
2231493 2231493 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Everett: Parlin School   Regular School No Elementary 01 08 2018   grade_2 5 12 50 0   2     0   1   34 36                       70.0 5 12 50 0   2     0   1   34 36                 70
2232204 2232204 MA Essex   school 2505970 128   Haverhill 250597000296 1280026 Haverhill: Golden Hill   Regular School No Elementary 01 04 2018   grade_2 63 1 56 0   0     0   2   59 63                       122.0 63 1 56 0   0     0   2   59 63                 122
2232581 2232581 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 Lawrence: South Lawrence East Elementary School   Regular School No Elementary 01 05 2018   grade_2 7 2 147 0   2     0   1   86 73                       159.0 7 2 147 0   2     0   1   86 73                 159
2232619 2232619 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Lawrence: Gerard A. Guilmette   Regular School No Elementary 01 04 2018   grade_2 3 3 122 0   2     0   0   75 55                       130.0 3 3 122 0   2     0   0   75 55                 130
2232641 2232641 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Lawrence: Oliver Partnership School   Regular School No Elementary 01 05 2018   grade_2 4 0 77 0   0     0   0   36 45                       81.0 4 0 77 0   0     0   0   36 45                 81
2232657 2232657 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 Lawrence: John K Tarbox   Regular School No Elementary 01 05 2018   grade_2 2 0 66 0   0     0   1   39 30                       69.0 2 0 66 0   0     0   1   39 30                 69
2232695 2232695 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence: School for Exceptional Studies   Regular School No Other 01 12 2018   grade_2 1 0 5 0   0     0   0   5 1                       6.0 1 0 5 0   0     0   0   5 1                 6
2233235 2233235 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Lynn: Robert L Ford   Regular School No Elementary 01 05 2018   grade_2 7 6 94 1   9     0   2   61 58                       119.0 7 6 94 1   9     0   2   61 58                 119
2233296 2233296 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Lynn: Tracy   Regular School No Elementary 01 05 2018   grade_2 4 9 63 0   7     0   1   37 47                       84.0 4 9 63 0   7     0   1   37 47                 84
2233781 2233781 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Middleborough: Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2018   grade_2 85 3 3 0   0     0   5   55 41                       96.0 85 3 3 0   0     0   5   55 41                 96
2233787 2233787 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Middleborough: Mary K. Goode Elementary School   Regular School No Elementary 01 05 2018   grade_2 102 3 2 0   0     0   3   58 52                       110.0 102 3 2 0   0     0   3   58 52                 110
2234693 2234693 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Norwood: Balch   Regular School No Elementary 01 05 2018   grade_2 28 8 12 0   2     0   3   25 28                       53.0 28 8 12 0   2     0   3   25 28                 53
2234699 2234699 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Norwood: Cornelius M Callahan   Regular School No Elementary 01 05 2018   grade_2 30 3 1 0   3     0   2   19 20                       39.0 30 3 1 0   3     0   2   19 20                 39
2234705 2234705 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 Norwood: F A Cleveland   Regular School No Elementary 01 05 2018   grade_2 55 5 4 0   5     1   4   37 37                       74.0 55 5 4 0   5     1   4   37 37                 74
2234711 2234711 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 Norwood: John P Oldham   Regular School No Elementary 01 05 2018   grade_2 38 7 3 0   5     0   0   23 30                       53.0 38 7 3 0   5     0   0   23 30                 53
2235019 2235019 MA Plymouth   school 2509720 239   Plymouth 250972001541 2390010 Plymouth: Hedge   Regular School No Elementary 01 05 2018   grade_2 21 0 1 0   2     0   4   13 15                       28.0 21 0 1 0   2     0   4   13 15                 28
2235690 2235690 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Shrewsbury: Floral Street School   Regular School No Elementary 01 04 2018   grade_2 73 7 17 0   108     0   7   110 102                       212.0 73 7 17 0   108     0   7   110 102                 212
2236642 2236642 MA Middlesex   school 2511910 305   Wakefield 251191001948 3050040 Wakefield: Walton   Regular School No Elementary 01 04 2018   grade_2 39 3 2 0   1     0   1   28 18                       46.0 39 3 2 0   1     0   1   28 18                 46
2237000 2237000 MA Plymouth   school 2512420 323   West Bridgewater 251242002037 3230003 West Bridgewater: Rose L Macdonald   Regular School No Elementary 01 03 2018   grade_2 75 5 0 0   0     0   5   44 41                       85.0 75 5 0 0   0     0   5   44 41                 85
2237187 2237187 MA Hampden   school 2512510 332   West Springfield 251251002044 3320010 West Springfield: John R Fausey   Regular School No Elementary 01 05 2018   grade_2 67 2 8 0   2     0   7   40 46                       86.0 67 2 8 0   2     0   7   40 46                 86
2237193 2237193 MA Hampden   school 2512510 332   West Springfield 251251002047 3320025 West Springfield: Memorial   Regular School No Elementary 01 05 2018   grade_2 22 3 16 0   2     0   2   22 23                       45.0 22 3 16 0   2     0   2   22 23                 45
2237199 2237199 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 West Springfield: Mittineague   Regular School No Elementary 01 05 2018   grade_2 24 1 4 0   1     0   2   15 17                       32.0 24 1 4 0   1     0   2   15 17                 32
2237378 2237378 MA Middlesex   school 2513050 342   Wilmington 251305002159 3420020 Wilmington: Woburn Street   Regular School No Elementary 01 03 2018   grade_2 124 2 5 0   11     0   5   69 78                       147.0 124 2 5 0   11     0   5   69 78                 147
2237382 2237382 MA Middlesex   school 2513050 342   Wilmington 251305002153 3420025 Wilmington: Shawsheen Elementary   Regular School No Elementary 01 03 2018   grade_2 107 3 5 0   5     0   3   62 61                       123.0 107 3 5 0   5     0   3   62 61                 123
2230051 2230051 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston: Dr. William Henderson Upper   Regular School No Other 02 12 2018   grade_2 24 7 8 0   3     0   2   20 24                       44.0 24 7 8 0   3     0   2   20 24                 44
2231231 2231231 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas: Douglas Elementary School   Regular School No Elementary 02 05 2018   grade_2 94 0 5 0   1     0   2   50 52                       102.0 94 0 5 0   1     0   2   50 52                 102
2231927 2231927 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Gardner: Elm Street School   Regular School No Elementary 02 04 2018   grade_2 116 9 38 0   4     0   15   81 101                       182.0 116 9 38 0   4     0   15   81 101                 182
2232037 2232037 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 Grafton: North Street Elementary School   Regular School No Elementary 02 06 2018   grade_2 81 0 5 0   11     1   10   54 54                       108.0 81 0 5 0   11     1   10   54 54                 108
2232043 2232043 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Grafton: Millbury Street Elementary School   Regular School No Elementary 02 06 2018   grade_2 92 2 1 0   23     0   2   64 56                       120.0 92 2 1 0   23     0   2   64 56                 120
2232467 2232467 MA Middlesex   school 2506330 139   Hopkinton 250633000919 1390010 Hopkinton: Elmwood   Regular School No Elementary 02 03 2018   grade_2 171 1 6 1   46     0   13   119 119                       238.0 171 1 6 1   46     0   13   119 119                 238
2233137 2233137 MA Hampden   school 2507050 161   Ludlow 250705002665 1610020 Ludlow: Chapin Street Elementary School   Regular School No Elementary 02 03 2018   grade_2 126 1 25 1   1     0   8   74 88                       162.0 126 1 25 1   1     0   8   74 88                 162
2233443 2233443 MA Essex   school 2507260 168   Marblehead 250726001122 1680010 Marblehead: L H Coffin   Regular School No Elementary 02 03 2018   grade_2 62 0 4 0   2     1   4   40 33                       73.0 62 0 4 0   2     1   4   40 33                 73
2233604 2233604 MA Norfolk   school 2507530 175   Medfield 250753001159 1750007 Medfield: Ralph Wheelock School   Regular School No Elementary 02 03 2018   grade_2 170 5 5 0   9     0   6   95 100                       195.0 170 5 5 0   9     0   6   95 100                 195
2233671 2233671 MA Norfolk   school 2507590 177   Medway 250759001015 1770015 Medway: Burke/Memorial Elementary School   Regular School No Elementary 02 04 2018   grade_2 157 5 2 0   2     0   2   89 79                       168.0 157 5 2 0   2     0   2   89 79                 168
2234579 2234579 MA Worcester   school 2508940 214   Northbridge 250894001447 2140001 Northbridge: W Edward Balmer   Regular School No Elementary 02 04 2018   grade_2 131 1 16 0   0     0   8   66 90                       156.0 131 1 16 0   0     0   8   66 90                 156
2234763 2234763 MA Worcester   school 2509270 226   Oxford 250927001481 2260005 Oxford: Clara Barton   Regular School No Elementary 02 04 2018   grade_2 100 3 14 0   1     0   8   66 60                       126.0 100 3 14 0   1     0   8   66 60                 126
2235858 2235858 MA Worcester   school 2510980 276   Southborough 251098001827 2760050 Southborough: Albert S. Woodward Memorial School   Regular School No Elementary 02 03 2018   grade_2 93 3 9 0   25     1   7   78 60                       138.0 93 3 9 0   25     1   7   78 60                 138
2235865 2235865 MA Worcester   school 2511010 277   Southbridge 251101001763 2770005 Southbridge: Charlton Street   Regular School No Elementary 02 05 2018   grade_2 25 2 36 0   1     0   3   37 30                       67.0 25 2 36 0   1     0   3   37 30                 67
2235874 2235874 MA Worcester   school 2511010 277   Southbridge 251101001770 2770020 Southbridge: West Street   Regular School No Elementary 02 05 2018   grade_2 37 0 40 0   3     0   1   40 41                       81.0 37 0 40 0   3     0   1   40 41                 81
2235892 2235892 MA Hampshire   school 2510920 278   South Hadley 251092002406 2780020 South Hadley: Mosier   Regular School No Elementary 02 04 2018   grade_2 115 1 18 0   2     0   2   78 60                       138.0 115 1 18 0   2     0   2   78 60                 138
2238604 2238604 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002367 6100005 Ashburnham-Westminster: Westminster Elementary   Regular School No Elementary 02 05 2018   grade_2 94 1 1 0   0     0   1   52 45                       97.0 94 1 1 0   0     0   1   52 45                 97
2238738 2238738 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001755 6250050 Bridgewater-Raynham: Laliberte Elementary School   Regular School No Elementary 02 04 2018   grade_2 141 11 0 0   4     0   3   83 76                       159.0 141 11 0 0   4     0   3   83 76                 159
2238877 2238877 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000588 6580005 Dudley-Charlton Reg: Dudley Elementary   Regular School No Elementary 02 04 2018   grade_2 103 5 16 0   0     0   3   64 63                       127.0 103 5 16 0   0     0   3   64 63                 127
2238889 2238889 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436002518 6580030 Dudley-Charlton Reg: Heritage School   Regular School No Elementary 02 04 2018   grade_2 130 1 13 0   4     0   2   91 59                       150.0 130 1 13 0   4     0   2   91 59                 150
2239017 2239017 MA Franklin   school 2505270 674   Gill-Montague 250527002385 6740050 Gill-Montague: Sheffield Elementary School   Regular School No Elementary 02 05 2018   grade_2 43 0 8 0   0     0   4   24 31                       55.0 43 0 8 0   0     0   4   24 31                 55
2239077 2239077 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001464 6800050 Hampden-Wilbraham: Stony Hill School   Regular School No Elementary 02 03 2018   grade_2 120 2 12 0   0     0   8   79 63                       142.0 120 2 12 0   0     0   8   79 63                 142
2239255 2239255 MA Worcester   school 2508280 720   Narragansett 250828001283 7200005 Narragansett: Baldwinville Elementary   Regular School No Elementary 02 04 2018   grade_2 78 1 8 0   0     0   1   52 36                       88.0 78 1 8 0   0     0   1   52 36                 88
2239465 2239465 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Quabbin: Oakham Center   Regular School No Elementary 02 06 2018   grade_2 19 0 2 0   0     0   1   6 16                       22.0 19 0 2 0   0     0   1   6 16                 22
2232017 2232017 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_2 * * * *   *     *   *   * *                       0.0                                             0
2231639 2231639 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   grade_2 * * * *   *     *   *   * *                       0.0                                             0
2237223 2237223 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_2 * * * *   *     *   *   * *                       0.0                                             0
2228761 2228761 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Abington: Beaver Brook Elementary   Regular School No Elementary KG 02 2018   grade_2 113 4 8 0   5     1   1   59 73                       132.0 113 4 8 0   5     1   1   59 73                 132
2228789 2228789 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Agawam: Clifford M Granger   Regular School No Elementary KG 04 2018   grade_2 32 1 8 0   0     0   3   23 21                       44.0 32 1 8 0   0     0   3   23 21                 44
2228795 2228795 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Agawam: Benjamin J Phelps   Regular School No Elementary KG 04 2018   grade_2 63 0 1 0   1     0   0   38 27                       65.0 63 0 1 0   1     0   0   38 27                 65
2228801 2228801 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Agawam: Robinson Park   Regular School No Elementary KG 04 2018   grade_2 66 2 5 0   3     0   2   40 38                       78.0 66 2 5 0   3     0   2   40 38                 78
2228807 2228807 MA Hampden   school 2501800 5   Agawam 250180000030 50030 Agawam: James Clark School   Regular School No Elementary KG 04 2018   grade_2 57 2 7 0   2     0   3   35 36                       71.0 57 2 7 0   2     0   3   35 36                 71
2228862 2228862 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Amherst: Fort River Elementary   Regular School No Elementary KG 06 2018   grade_2 21 4 8 0   12     0   1   24 22                       46.0 21 4 8 0   12     0   1   24 22                 46
2228870 2228870 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Amherst: Wildwood Elementary   Regular School No Elementary KG 06 2018   grade_2 29 9 14 0   6     0   0   31 27                       58.0 29 9 14 0   6     0   0   31 27                 58
2228878 2228878 MA Essex   school 2501950 9   Andover 250195000047 90003 Andover: Bancroft Elementary   Regular School No Elementary KG 05 2018   grade_2 73 2 5 0   9     0   5   52 42                       94.0 73 2 5 0   9     0   5   52 42                 94
2228885 2228885 MA Essex   school 2501950 9   Andover 250195001676 90004 Andover: High Plain Elementary   Regular School No Elementary KG 05 2018   grade_2 45 2 4 0   25     0   2   45 33                       78.0 45 2 4 0   25     0   2   45 33                 78
2228894 2228894 MA Essex   school 2501950 9   Andover 250195000048 90010 Andover: Henry C Sanborn Elementary   Regular School No Elementary KG 05 2018   grade_2 46 0 1 0   22     0   1   35 35                       70.0 46 0 1 0   22     0   1   35 35                 70
2228901 2228901 MA Essex   school 2501950 9   Andover 250195000050 90020 Andover: South Elementary   Regular School No Elementary KG 05 2018   grade_2 67 2 6 1   15     0   2   41 52                       93.0 67 2 6 1   15     0   2   41 52                 93
2228908 2228908 MA Essex   school 2501950 9   Andover 250195000051 90025 Andover: West Elementary   Regular School No Elementary KG 05 2018   grade_2 72 1 7 0   17     0   0   47 50                       97.0 72 1 7 0   17     0   0   47 50                 97
2228932 2228932 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 Arlington: John A Bishop   Regular School No Elementary KG 05 2018   grade_2 49 0 0 0   15     2   4   32 38                       70.0 49 0 0 0   15     2   4   32 38                 70
2228939 2228939 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Arlington: Brackett   Regular School No Elementary KG 05 2018   grade_2 57 0 3 0   4     0   4   33 35                       68.0 57 0 3 0   4     0   4   33 35                 68
2228946 2228946 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Arlington: Cyrus E Dallin   Regular School No Elementary KG 05 2018   grade_2 61 1 2 0   8     0   2   36 38                       74.0 61 1 2 0   8     0   2   36 38                 74
2228953 2228953 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Arlington: Hardy   Regular School No Elementary KG 05 2018   grade_2 52 4 4 0   13     1   3   42 35                       77.0 52 4 4 0   13     1   3   42 35                 77
2228962 2228962 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Arlington: Peirce   Regular School No Elementary KG 05 2018   grade_2 35 2 2 0   6     0   1   19 27                       46.0 35 2 2 0   6     0   1   19 27                 46
2228969 2228969 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Arlington: Thompson   Regular School No Elementary KG 05 2018   grade_2 53 4 6 0   10     0   6   42 37                       79.0 53 4 6 0   10     0   6   42 37                 79
2228976 2228976 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 Arlington: M Norcross Stratton   Regular School No Elementary KG 05 2018   grade_2 47 3 5 0   12     0   5   33 39                       72.0 47 3 5 0   12     0   5   33 39                 72
2228994 2228994 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Ashland: Henry E Warren Elementary   Regular School No Elementary KG 02 2018   grade_2 123 3 24 0   31     1   7   92 97                       189.0 123 3 24 0   31     1   7   92 97                 189
2229011 2229011 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 Attleboro: A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2018   grade_2 61 3 13 1   5     1   9   51 42                       93.0 61 3 13 1   5     1   9   51 42                 93
2229019 2229019 MA Bristol   school 2502190 16   Attleboro 250219000098 160035 Attleboro: Thomas Willett Elementary School   Regular School No Elementary KG 04 2018   grade_2 57 11 9 0   3     0   5   42 43                       85.0 57 11 9 0   3     0   5   42 43                 85
2229025 2229025 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Attleboro: Hyman Fine Elementary School   Regular School No Elementary KG 04 2018   grade_2 72 4 15 0   6     0   5   63 39                       102.0 72 4 15 0   6     0   5   63 39                 102
2229031 2229031 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Attleboro: Hill-Roberts Elementary School   Regular School No Elementary KG 04 2018   grade_2 69 4 9 1   6     0   8   52 45                       97.0 69 4 9 1   6     0   8   52 45                 97
2229037 2229037 MA Bristol   school 2502190 16   Attleboro 250219001294 160050 Attleboro: Peter Thacher Elementary School   Regular School No Elementary KG 04 2018   grade_2 44 4 8 1   8     0   11   39 37                       76.0 44 4 8 1   8     0   11   39 37                 76
2229066 2229066 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Auburn: Bryn Mawr   Regular School No Elementary KG 02 2018   grade_2 75 1 14 0   1     0   3   48 46                       94.0 75 1 14 0   1     0   3   48 46                 94
2229107 2229107 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 Barnstable: West Barnstable Elementary   Regular School No Elementary KG 03 2018   grade_2 57 2 5 0   1     0   1   41 25                       66.0 57 2 5 0   1     0   1   41 25                 66
2229112 2229112 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Barnstable: Centerville Elementary   Regular School No Elementary KG 03 2018   grade_2 59 2 5 0   0     0   2   36 32                       68.0 59 2 5 0   0     0   2   36 32                 68
2229117 2229117 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Barnstable: Hyannis West Elementary   Regular School No Elementary KG 03 2018   grade_2 29 17 36 1   3     0   4   50 40                       90.0 29 17 36 1   3     0   4   50 40                 90
2229122 2229122 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 Barnstable: West Villages Elementary School   Regular School No Elementary KG 03 2018   grade_2 82 3 6 0   0     0   4   55 40                       95.0 82 3 6 0   0     0   4   55 40                 95
2229139 2229139 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Bedford: Lt Elezer Davis   Regular School No Elementary KG 02 2018   grade_2 123 12 14 0   36     0   16   98 103                       201.0 123 12 14 0   36     0   16   98 103                 201
2229178 2229178 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 Bellingham: South Elementary   Regular School No Elementary KG 03 2018   grade_2 77 1 4 0   1     0   0   45 38                       83.0 77 1 4 0   1     0   0   45 38                 83
2229183 2229183 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Bellingham: Stall Brook   Regular School No Elementary KG 03 2018   grade_2 64 0 2 0   2     0   2   37 33                       70.0 64 0 2 0   2     0   2   37 33                 70
2229205 2229205 MA Middlesex   school 2502490 26   Belmont 250249000148 260005 Belmont: Winn Brook   Regular School No Elementary KG 04 2018   grade_2 57 4 4 0   23     0   8   49 47                       96.0 57 4 4 0   23     0   8   49 47                 96
2229211 2229211 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Belmont: Mary Lee Burbank   Regular School No Elementary KG 04 2018   grade_2 40 4 4 0   13     0   6   30 37                       67.0 40 4 4 0   13     0   6   30 37                 67
2229217 2229217 MA Middlesex   school 2502490 26   Belmont 250249000144 260015 Belmont: Daniel Butler   Regular School No Elementary KG 04 2018   grade_2 36 3 3 2   21     0   6   36 35                       71.0 36 3 3 2   21     0   6   36 35                 71
2229262 2229262 MA Essex   school 2502640 30   Beverly 250264000167 300010 Beverly: Centerville Elementary   Regular School No Elementary KG 05 2018   grade_2 41 0 12 0   0     0   3   28 28                       56.0 41 0 12 0   0     0   3   28 28                 56

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