enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
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
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
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
2048832 2048832 MA Franklin   school 2509600 750   Pioneer Valley 250960002613 7500007 Pearl E Rhodes Elementary   Regular School No Elementary PK 04 2019   grade_2 * * * *   *     *   *   2 3                       5.0                         2 3                 5
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
2040187 2040187 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Mary Lee Burbank   Regular School No Elementary KG 04 2019   grade_2 56 5 0 0   11     1   9   45 37                       82.0 56 5 0 0   11     1   9   45 37                 82
2041204 2041204 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No Elementary PK 06 2019   grade_2 36 0 0 0   2     0   0   17 21                       38.0 36 0 0 0   2     0   0   17 21                 38
2041512 2041512 MA Middlesex   school 2503270 49   Cambridge 250327000447 490050 Peabody   Regular School No Elementary PK 05 2019   grade_2 26 9 0 0   7     0   2   25 19                       44.0 26 9 0 0   7     0   2   25 19                 44
2041754 2041754 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2019   grade_2 14 0 0 0   0     0   0   7 7                       14.0 14 0 0 0   0     0   0   7 7                 14
2042011 2042011 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No Elementary PK 05 2019   grade_2 25 1 0 0   1     0   1   14 14                       28.0 25 1 0 0   1     0   1   14 14                 28
2042094 2042094 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No Elementary PK 06 2019   grade_2 9 0 0 0   0     0   3   8 4                       12.0 9 0 0 0   0     0   3   8 4                 12
2042364 2042364 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_2 8 0 0 0   0     0   0   3 5                       8.0 8 0 0 0   0     0   0   3 5                 8
2042821 2042821 MA Plymouth   school 2506090 131   Hingham 250609000874 1310020 South Elementary   Regular School No Elementary KG 05 2019   grade_2 68 1 0 0   3     0   7   33 46                       79.0 68 1 0 0   3     0   7   33 46                 79
2042851 2042851 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No Elementary PK 06 2019   grade_2 27 0 0 0   1     0   1   15 14                       29.0 27 0 0 0   1     0   1   15 14                 29
2043017 2043017 MA Essex   school 2506480 144   Ipswich 250648000936 1440007 Paul F Doyon Memorial   Regular School No Elementary PK 05 2019   grade_2 55 1 0 0   1     0   1   32 26                       58.0 55 1 0 0   1     0   1   32 26                 58
2043244 2043244 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No Elementary PK 06 2019   grade_2 15 0 0 0   0     0   3   12 6                       18.0 15 0 0 0   0     0   3   12 6                 18
2043319 2043319 MA Middlesex   school 2506960 158   Littleton 250696001014 1580005 Shaker Lane Elementary   Regular School No Elementary PK 02 2019   grade_2 100 0 0 0   13     0   3   60 56                       116.0 100 0 0 0   13     0   3   60 56                 116
2043824 2043824 MA Plymouth   school 2507350 171   Marshfield 250735000760 1710005 Eames Way School   Regular School No Elementary KG 05 2019   grade_2 40 0 0 0   0     0   0   26 14                       40.0 40 0 0 0   0     0   0   26 14                 40
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
2044181 2044181 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No Elementary PK 06 2019   grade_2 18 0 0 0   0     0   0   8 10                       18.0 18 0 0 0   0     0   0   8 10                 18
2044702 2044702 MA Worcester   school 2508880 213   Northborough 250888001437 2130003 Lincoln Street   Regular School No Elementary KG 05 2019   grade_2 33 0 0 0   3     1   3   20 20                       40.0 33 0 0 0   3     1   3   20 20                 40
2044759 2044759 MA Middlesex   school 2508820 217   North Reading 250882000505 2170003 E Ethel Little School   Regular School No Elementary PK 05 2019   grade_2 43 0 0 0   0     0   1   23 21                       44.0 43 0 0 0   0     0   1   23 21                 44
2044812 2044812 MA Plymouth   school 2509030 219   Norwell 250903001458 2190020 William G Vinal   Regular School No Elementary PK 05 2019   grade_2 74 0 0 0   1     1   3   42 37                       79.0 74 0 0 0   1     1   3   42 37                 79
2044924 2044924 MA Essex   school 2509360 229   Peabody 250936001496 2290007 John E Burke   Regular School No Elementary KG 05 2019   grade_2 28 0 0 0   2     0   2   11 21                       32.0 28 0 0 0   2     0   2   11 21                 32
2044985 2044985 MA Plymouth   school 2509420 231   Pembroke 250942001508 2310003 Bryantville Elementary   Regular School No Elementary KG 06 2019   grade_2 56 0 0 1   0     0   3   31 29                       60.0 56 0 0 1   0     0   3   31 29                 60
2044992 2044992 MA Plymouth   school 2509420 231   Pembroke 250942001509 2310010 Hobomock Elementary   Regular School No Elementary KG 06 2019   grade_2 53 1 0 0   0     0   1   28 27                       55.0 53 1 0 0   0     0   1   28 27                 55
2045000 2045000 MA Plymouth   school 2509420 231   Pembroke 250942001510 2310015 North Pembroke Elementary   Regular School No Elementary PK 06 2019   grade_2 56 0 0 1   2     0   1   31 29                       60.0 56 0 0 1   2     0   1   31 29                 60
2045159 2045159 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Dennett Elementary   Regular School No Elementary KG 06 2019   grade_2 26 0 0 0   0     0   1   16 11                       27.0 26 0 0 0   0     0   1   16 11                 27
2045236 2045236 MA Norfolk   school 2509870 243   Quincy 250987002492 2430110 Wollaston School   Regular School No Elementary KG 05 2019   grade_2 16 0 0 0   37     0   2   32 23                       55.0 16 0 0 0   37     0   2   32 23                 55
2045400 2045400 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2019   grade_2 17 0 0 0   0     0   0   10 7                       17.0 17 0 0 0   0     0   0   10 7                 17
2045443 2045443 MA Essex   school 2510200 252   Rockport 251020002533 2520005 Rockport Elementary   Regular School No Elementary PK 05 2019   grade_2 61 0 0 0   1     0   0   34 28                       62.0 61 0 0 0   1     0   0   34 28                 62
2045569 2045569 MA Plymouth   school 2510560 264   Scituate 251056001689 2640007 Cushing Elementary   Regular School No Elementary KG 05 2019   grade_2 54 0 0 0   1     0   0   28 27                       55.0 54 0 0 0   1     0   0   28 27                 55
2045581 2045581 MA Plymouth   school 2510560 264   Scituate 251056002068 2640015 Jenkins Elementary School   Regular School No Elementary KG 05 2019   grade_2 49 3 0 0   0     0   0   19 33                       52.0 49 3 0 0   0     0   0   19 33                 52
2045588 2045588 MA Plymouth   school 2510560 264   Scituate 251056002289 2640020 Wampatuck Elementary   Regular School No Elementary PK 05 2019   grade_2 56 1 0 0   0     0   1   29 29                       58.0 56 1 0 0   0     0   1   29 29                 58
2046491 2046491 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales Elementary   Regular School No Elementary PK 06 2019   grade_2 13 0 0 0   0     0   0   8 5                       13.0 13 0 0 0   0     0   0   8 5                 13
2046654 2046654 MA Middlesex   school 2512210 315   Wayland 251221002008 3150015 Happy Hollow School   Regular School No Elementary KG 05 2019   grade_2 51 4 0 0   5     0   2   36 26                       62.0 51 4 0 0   5     0   2   36 26                 62
2046689 2046689 MA Norfolk   school 2512270 317   Wellesley 251227002025 3170005 Katharine Lee Bates   Regular School No Elementary KG 05 2019   grade_2 45 3 0 0   4     0   6   33 25                       58.0 45 3 0 0   4     0   6   33 25                 58
2046713 2046713 MA Norfolk   school 2512270 317   Wellesley 251227002503 3170045 Schofield   Regular School No Elementary KG 05 2019   grade_2 40 1 0 1   11     0   4   30 27                       57.0 40 1 0 1   11     0   4   30 27                 57
2046972 2046972 MA Norfolk   school 2512810 335   Westwood 251281002101 3350025 William E Sheehan   Regular School No Elementary KG 05 2019   grade_2 42 0 0 0   1     0   3   25 21                       46.0 42 0 0 0   1     0   3   25 21                 46
2047004 2047004 MA Norfolk   school 2512840 336   Weymouth 251284002114 3360065 Lawrence W Pingree   Regular School No Elementary KG 04 2019   grade_2 30 4 0 0   1     0   0   17 18                       35.0 30 4 0 0   1     0   0   17 18                 35
2047037 2047037 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No Elementary PK 06 2019   grade_2 19 0 0 0   0     0   0   10 9                       19.0 19 0 0 0   0     0   0   10 9                 19
2047045 2047045 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No Elementary PK 06 2019   grade_2 16 1 0 0   0     0   0   6 11                       17.0 16 1 0 0   0     0   0   6 11                 17
2047117 2047117 MA Middlesex   school 2513110 344   Winchester 251311002164 3440045 Ambrose Elementary   Regular School No Elementary KG 05 2019   grade_2 60 0 0 0   2     0   2   32 32                       64.0 60 0 0 0   2     0   2   32 32                 64
2047144 2047144 MA Middlesex   school 2513200 347   Woburn 251320002184 3470005 Goodyear Elementary School   Regular School No Elementary KG 05 2019   grade_2 41 4 0 0   2     0   1   30 18                       48.0 41 4 0 0   2     0   1   30 18                 48
2047775 2047775 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2019   grade_2 15 0 0 0   1     0   5   12 9                       21.0 15 0 0 0   1     0   5   12 9                 21
2048153 2048153 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Royalston Community School   Regular School No Elementary KG 06 2019   grade_2 17 0 0 0   0     0   0   9 8                       17.0 17 0 0 0   0     0   0   9 8                 17
2048262 2048262 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2019   grade_2 18 0 0 1   0     0   0   9 10                       19.0 18 0 0 1   0     0   0   9 10                 19
2048269 2048269 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Becket Washington School   Regular School No Elementary PK 05 2019   grade_2 17 0 0 0   0     0   1   10 8                       18.0 17 0 0 0   0     0   1   10 8                 18
2048282 2048282 MA Berkshire   school 2503390 635   Central Berkshire 250339000465 6350035 Kittredge   Regular School No Elementary PK 05 2019   grade_2 28 0 0 0   0     0   1   11 18                       29.0 28 0 0 0   0     0   1   11 18                 29
2048390 2048390 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2019   grade_2 15 0 0 0   0     0   0   7 8                       15.0 15 0 0 0   0     0   0   7 8                 15
2048492 2048492 MA Essex   school 2505670 675   Hamilton-Wenham 250567000818 6750010 Cutler School   Regular School No Elementary KG 05 2019   grade_2 36 0 0 0   2     0   1   20 19                       39.0 36 0 0 0   2     0   1   20 19                 39
2048564 2048564 MA Essex   school 2500067 698   Manchester Essex Regional 250006701110 6980010 Manchester Memorial Elementary   Regular School No Elementary PK 05 2019   grade_2 54 2 0 0   0     0   0   26 30                       56.0 54 2 0 0   0     0   0   26 30                 56
2048636 2048636 MA Berkshire   school 2508160 715   Mount Greylock 250816002887 7150005 Lanesborough Elementary   Regular School No Elementary PK 06 2019   grade_2 33 1 0 0   0     0   0   17 17                       34.0 33 1 0 0   0     0   0   17 17                 34
2048690 2048690 MA Worcester   school 2508280 720   Narragansett 250828001287 7200003 Phillipston Memorial   Regular School No Elementary PK 04 2019   grade_2 16 1 0 0   0     0   1   13 5                       18.0 16 1 0 0   0     0   1   13 5                 18
2048724 2048724 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No Elementary PK 08 2019   grade_2 72 0 0 0   1     1   2   37 39                       76.0 72 0 0 0   1     1   2   37 39                 76
2048745 2048745 MA Franklin   school 2508530 728   New Salem-Wendell 250853001346 7280015 Swift River   Regular School No Elementary PK 06 2019   grade_2 17 0 0 0   0     0   1   9 9                       18.0 17 0 0 0   0     0   1   9 9                 18
2048806 2048806 MA Essex   school 2509450 745   Pentucket 250945000408 7450015 Dr John C Page School   Regular School No Elementary PK 06 2019   grade_2 46 0 0 0   1     0   0   19 28                       47.0 46 0 0 0   1     0   0   19 28                 47
2048824 2048824 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Bernardston Elementary   Regular School No Elementary PK 06 2019   grade_2 18 0 0 0   0     0   1   5 14                       19.0 18 0 0 0   0     0   1   5 14                 19
2048837 2048837 MA Franklin   school 2509600 750   Pioneer Valley 250960002614 7500008 Northfield Elementary   Regular School No Elementary PK 06 2019   grade_2 21 0 0 0   0     0   1   11 11                       22.0 21 0 0 0   0     0   1   11 11                 22
2048845 2048845 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No Elementary PK 06 2019   grade_2 9 0 0 0   0     0   0   7 2                       9.0 9 0 0 0   0     0   0   7 2                 9
2048919 2048919 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 New Marlborough Central   Regular School No Elementary PK 04 2019   grade_2 18 0 0 0   0     0   1   10 9                       19.0 18 0 0 0   0     0   1   10 9                 19
2049017 2049017 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No Elementary KG 05 2019   grade_2 8 0 0 0   0     0   2   4 6                       10.0 8 0 0 0   0     0   2   4 6                 10
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
2040212 2040212 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No Elementary PK 04 2019   grade_2 88 0 1 0   0     0   2   51 40                       91.0 88 0 1 0   0     0   2   51 40                 91
2040222 2040222 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No Elementary PK 05 2019   grade_2 25 0 1 0   1     0   1   17 11                       28.0 25 0 1 0   1     0   1   17 11                 28
2040275 2040275 MA Middlesex   school 2502670 31   Billerica 250267000181 310012 John F Kennedy   Regular School No Elementary KG 05 2019   grade_2 35 1 1 0   2     0   3   23 19                       42.0 35 1 1 0   2     0   3   23 19                 42
2041569 2041569 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Dean S Luce   Regular School No Elementary KG 05 2019   grade_2 59 10 1 0   10     0   4   43 41                       84.0 59 10 1 0   10     0   4   43 41                 84
2041594 2041594 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver Elementary School   Regular School No Elementary PK 05 2019   grade_2 131 2 1 0   0     0   2   64 72                       136.0 131 2 1 0   0     0   2   64 72                 136
2041807 2041807 MA Middlesex   school 2503840 67   Concord 250384000526 670030 Willard   Regular School No Elementary PK 05 2019   grade_2 54 1 1 0   6     0   4   35 31                       66.0 54 1 1 0   6     0   4   35 31                 66
2041849 2041849 MA Essex   school 2503990 71   Danvers 250399000538 710045 Willis E Thorpe   Regular School No Elementary KG 05 2019   grade_2 51 1 1 0   2     0   0   33 22                       55.0 51 1 1 0   2     0   0   33 22                 55
2041949 2041949 MA Middlesex   school 2504320 79   Dracut 250432000583 790020 Joseph A Campbell Elementary   Regular School No Elementary PK 05 2019   grade_2 64 3 1 0   3     0   2   34 39                       73.0 64 3 1 0   3     0   2   34 39                 73
2042374 2042374 MA Norfolk   school 2504950 99   Foxborough 250495000710 990015 Mabelle M Burrell   Regular School No Elementary PK 04 2019   grade_2 36 2 1 0   3     0   1   24 19                       43.0 36 2 1 0   3     0   1   24 19                 43
2042472 2042472 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No Elementary KG 05 2019   grade_2 59 1 1 0   0     1   4   34 32                       66.0 59 1 1 0   0     1   4   34 32                 66
2042555 2042555 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No Elementary KG 05 2019   grade_2 22 0 1 0   0     0   1   12 12                       24.0 22 0 1 0   0     0   1   12 12                 24
2042803 2042803 MA Plymouth   school 2506090 131   Hingham 250609002671 1310005 East Elementary School   Regular School No Elementary PK 05 2019   grade_2 71 2 1 0   0     0   0   36 38                       74.0 71 2 1 0   0     0   0   36 38                 74
2043039 2043039 MA Plymouth   school 2506540 145   Kingston 250654000943 1450005 Kingston Elementary   Regular School No Elementary KG 02 2019   grade_2 139 1 1 0   0     0   1   74 68                       142.0 139 1 1 0   0     0   1   74 68                 142
2043258 2043258 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Bowman   Regular School No Elementary KG 05 2019   grade_2 42 3 1 0   33     0   8   46 41                       87.0 42 3 1 0   33     0   8   46 41                 87
2043879 2043879 MA Plymouth   school 2507470 173   Mattapoisett 250747001148 1730005 Center   Regular School No Elementary PK 03 2019   grade_2 48 0 1 0   0     0   3   22 30                       52.0 48 0 1 0   0     0   3   22 30                 52
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
2044144 2044144 MA Norfolk   school 2507980 189   Milton 250798001261 1890010 Glover   Regular School No Elementary KG 05 2019   grade_2 74 6 1 0   4     0   8   48 45                       93.0 74 6 1 0   4     0   8   48 45                 93
2044562 2044562 MA Norfolk   school 2508640 208   Norfolk 250864000317 2080015 H Olive Day   Regular School No Elementary PK 02 2019   grade_2 118 1 1 0   5     0   6   70 61                       131.0 118 1 1 0   5     0   6   70 61                 131
2044582 2044582 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No Elementary PK 06 2019   grade_2 26 1 1 0   0     0   1   16 13                       29.0 26 1 1 0   0     0   1   16 13                 29
2044670 2044670 MA Bristol   school 2508730 212   North Attleborough 250873001402 2120010 Falls   Regular School No Elementary KG 05 2019   grade_2 27 2 1 0   4     0   0   19 15                       34.0 27 2 1 0   4     0   0   19 15                 34
2044964 2044964 MA Essex   school 2509360 229   Peabody 250936001505 2290045 West Memorial   Regular School No Elementary PK 05 2019   grade_2 34 2 1 0   0     0   3   20 20                       40.0 34 2 1 0   0     0   3   20 20                 40
2044978 2044978 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham Elementary   Regular School No Elementary KG 06 2019   grade_2 15 3 1 0   1     0   2   13 9                       22.0 15 3 1 0   1     0   2   13 9                 22
2045014 2045014 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No Elementary KG 06 2019   grade_2 17 0 1 0   0     0   2   5 15                       20.0 17 0 1 0   0     0   2   5 15                 20
2045177 2045177 MA Norfolk   school 2509870 243   Quincy 250987000772 2430020 Beechwood Knoll Elementary   Regular School No Elementary KG 05 2019   grade_2 34 2 1 0   22     1   3   29 34                       63.0 34 2 1 0   22     1   3   29 34                 63
2045205 2045205 MA Norfolk   school 2509870 243   Quincy 250987001573 2430060 Merrymount   Regular School No Elementary KG 05 2019   grade_2 31 6 1 1   16     2   0   33 24                       57.0 31 6 1 1   16     2   0   33 24                 57
2045308 2045308 MA Middlesex   school 2509990 246   Reading 250999001606 2460005 Birch Meadow   Regular School No Elementary KG 05 2019   grade_2 57 1 1 0   3     0   2   33 31                       64.0 57 1 1 0   3     0   2   33 31                 64
2045410 2045410 MA Plymouth   school 2510140 250   Rochester 251014001637 2500005 Rochester Memorial   Regular School No Elementary PK 06 2019   grade_2 56 1 1 0   0     0   0   29 29                       58.0 56 1 1 0   0     0   0   29 29                 58
2045457 2045457 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No Elementary PK 06 2019   grade_2 10 0 1 0   0     0   1   7 5                       12.0 10 0 1 0   0     0   1   7 5                 12
2045549 2045549 MA Essex   school 2510500 262   Saugus 251050001677 2620067 Douglas Waybright   Regular School No Elementary PK 05 2019   grade_2 20 0 1 0   2     0   0   12 11                       23.0 20 0 1 0   2     0   0   12 11                 23
2045563 2045563 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No Elementary PK 05 2019   grade_2 7 0 1 0   0     0   0   5 3                       8.0 7 0 1 0   0     0   0   5 3                 8
2045575 2045575 MA Plymouth   school 2510560 264   Scituate 251056001691 2640010 Hatherly Elementary   Regular School No Elementary KG 05 2019   grade_2 35 0 1 0   0     0   0   22 14                       36.0 35 0 1 0   0     0   0   22 14                 36
2045624 2045624 MA Norfolk   school 2510620 266   Sharon 251062001702 2660005 Cottage Street   Regular School No Elementary KG 05 2019   grade_2 50 2 1 0   33     0   5   43 48                       91.0 50 2 1 0   33     0   5   43 48                 91
2045650 2045650 MA Middlesex   school 2510710 269   Sherborn 251071001709 2690010 Pine Hill   Regular School No Elementary PK 05 2019   grade_2 57 0 1 0   6     0   4   36 32                       68.0 57 0 1 0   6     0   4   36 32                 68
2045688 2045688 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No Elementary PK 06 2019   grade_2 16 0 1 0   0     0   2   11 8                       19.0 16 0 1 0   0     0   2   11 8                 19
2045702 2045702 MA Bristol   school 2510860 273   Somerset 251086002536 2730008 North Elementary   Regular School No Elementary KG 05 2019   grade_2 81 1 1 0   0     0   3   35 51                       86.0 81 1 1 0   0     0   3   35 51                 86
2045719 2045719 MA Middlesex   school 2510890 274   Somerville 251089001732 2740015 Benjamin G Brown   Regular School No Elementary KG 05 2019   grade_2 32 0 1 0   5     0   3   16 25                       41.0 32 0 1 0   5     0   3   16 25                 41
2046246 2046246 MA Middlesex   school 2511340 288   Sudbury 251134000507 2880025 General John Nixon Elementary   Regular School No Elementary KG 05 2019   grade_2 33 3 1 0   4     0   3   28 16                       44.0 33 3 1 0   4     0   3   28 16                 44

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