Data source: Big Local News · About: Big Local

960 rows where grade = "kindergarten", state = "MA" and year = 2019 sorted by hispanic

View and edit SQL

year

  • 2019 · 960

grade

  • kindergarten · 960
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
2041095 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2019   kindergarten * * * *   *     *   *   1 1                       2.0                         1 1                 2
2042671 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2019   kindergarten * * * *   *     *   *   3 1                       4.0                         3 1                 4
2043504 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Dr. Janice Adie Day School   Special Education School No Other PK 11 2019   kindergarten * * * *   *     *   *   3 2                       5.0                         3 2                 5
2045455 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No Elementary PK 06 2019   kindergarten * * * *   *     *   *   1 3                       4.0                         1 3                 4
2046932 MA Hampden   school 2512510 332   West Springfield 251251002050 3320040 Tatham   Regular School No Elementary KG 05 2019   kindergarten * * * *   *     *   *   2 2                       4.0                         2 2                 4
2048830 MA Franklin   school 2509600 750   Pioneer Valley 250960002613 7500007 Pearl E Rhodes Elementary   Regular School No Elementary PK 04 2019   kindergarten * * * *   *     *   *   2 3                       5.0                         2 3                 5
2040185 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Mary Lee Burbank   Regular School No Elementary KG 04 2019   kindergarten 56 4 0 0   16     0   6   42 40                       82.0 56 4 0 0   16     0   6   42 40                 82
2040190 MA Middlesex   school 2502490 26   Belmont 250249000144 260015 Daniel Butler   Regular School No Elementary KG 04 2019   kindergarten 42 1 0 0   14     0   9   34 32                       66.0 42 1 0 0   14     0   9   34 32                 66
2040220 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No Elementary PK 05 2019   kindergarten 20 0 0 0   0     0   2   11 11                       22.0 20 0 0 0   0     0   2   11 11                 22
2041153 MA Norfolk   school 2502940 40   Braintree 250294000365 400015 Highlands   Regular School No Elementary KG 05 2019   kindergarten 19 1 0 0   1     0   0   11 10                       21.0 19 1 0 0   1     0   0   11 10                 21
2041159 MA Norfolk   school 2502940 40   Braintree 250294000367 400020 Mary E Flaherty School   Regular School No Elementary KG 05 2019   kindergarten 16 0 0 0   10     0   0   16 10                       26.0 16 0 0 0   10     0   0   16 10                 26
2041176 MA Norfolk   school 2502940 40   Braintree 250294000363 400050 Donald Ross   Regular School No Elementary KG 05 2019   kindergarten 11 1 0 0   9     0   0   13 8                       21.0 11 1 0 0   9     0   0   13 8                 21
2041202 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No Elementary PK 06 2019   kindergarten 23 0 0 1   0     0   0   13 11                       24.0 23 0 0 1   0     0   0   13 11                 24
2041445 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington High   Regular School No Other 09 12 2019   kindergarten 13 1 0 0   0     0   0   12 2                       14.0 13 1 0 0   0     0   0   12 2                 14
2041752 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2019   kindergarten 18 0 0 0   0     0   0   10 8                       18.0 18 0 0 0   0     0   0   10 8                 18
2041815 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No Elementary PK 06 2019   kindergarten 13 1 0 0   0     0   0   3 11                       14.0 13 1 0 0   0     0   0   3 11                 14
2042362 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   kindergarten 10 0 0 0   0     0   0   5 5                       10.0 10 0 0 0   0     0   0   5 5                 10
2042534 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2019   kindergarten 103 0 0 0   1     0   5   55 54                       109.0 103 0 0 0   1     0   5   55 54                 109
2042560 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No Elementary KG 05 2019   kindergarten 34 0 0 0   0     0   1   18 17                       35.0 34 0 0 0   0     0   1   18 17                 35
2043000 MA Plymouth   school 2506420 142   Hull 250642000932 1420015 Lillian M Jacobs   Regular School No Elementary PK 05 2019   kindergarten 60 1 0 0   1     0   2   36 28                       64.0 60 1 0 0   1     0   2   36 28                 64
2043828 MA Plymouth   school 2507350 171   Marshfield 250735001144 1710010 South River   Regular School No Elementary KG 05 2019   kindergarten 30 0 0 0   0     0   2   12 20                       32.0 30 0 0 0   0     0   2   12 20                 32
2044516 MA Middlesex   school 2508610 207   Newton 250861001369 2070120 John Ward   Regular School No Elementary KG 05 2019   kindergarten 31 2 0 0   8     0   0   26 15                       41.0 31 2 0 0   8     0   0   26 15                 41
2044662 MA Bristol   school 2508730 212   North Attleborough 250873001401 2120007 Amvet Boulevard   Regular School No Elementary KG 05 2019   kindergarten 32 1 0 0   4     0   2   24 15                       39.0 32 1 0 0   4     0   2   24 15                 39
2044668 MA Bristol   school 2508730 212   North Attleborough 250873001402 2120010 Falls   Regular School No Elementary KG 05 2019   kindergarten 20 1 0 0   1     0   3   19 6                       25.0 20 1 0 0   1     0   3   19 6                 25
2044700 MA Worcester   school 2508880 213   Northborough 250888001437 2130003 Lincoln Street   Regular School No Elementary KG 05 2019   kindergarten 34 0 0 0   6     1   0   22 19                       41.0 34 0 0 0   6     1   0   22 19                 41
2044757 MA Middlesex   school 2508820 217   North Reading 250882000505 2170003 E Ethel Little School   Regular School No Elementary PK 05 2019   kindergarten 19 1 0 0   0     0   2   8 14                       22.0 19 1 0 0   0     0   2   8 14                 22
2044810 MA Plymouth   school 2509030 219   Norwell 250903001458 2190020 William G Vinal   Regular School No Elementary PK 05 2019   kindergarten 71 0 0 0   1     0   1   43 30                       73.0 71 0 0 0   1     0   1   43 30                 73
2044983 MA Plymouth   school 2509420 231   Pembroke 250942001508 2310003 Bryantville Elementary   Regular School No Elementary KG 06 2019   kindergarten 63 0 0 0   0     0   3   36 30                       66.0 63 0 0 0   0     0   3   36 30                 66
2044990 MA Plymouth   school 2509420 231   Pembroke 250942001509 2310010 Hobomock Elementary   Regular School No Elementary KG 06 2019   kindergarten 50 1 0 0   1     0   2   28 26                       54.0 50 1 0 0   1     0   2   28 26                 54
2044998 MA Plymouth   school 2509420 231   Pembroke 250942001510 2310015 North Pembroke Elementary   Regular School No Elementary PK 06 2019   kindergarten 74 0 0 0   0     0   3   35 42                       77.0 74 0 0 0   0     0   3   35 42                 77
2045032 MA Middlesex   school 2509630 236   Pittsfield 250963001522 2360045 Robert T. Capeless Elementary School   Regular School No Elementary PK 05 2019   kindergarten 26 1 0 0   0     0   0   15 12                       27.0 26 1 0 0   0     0   0   15 12                 27
2045157 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Dennett Elementary   Regular School No Elementary KG 06 2019   kindergarten 29 0 0 0   0     0   0   20 9                       29.0 29 0 0 0   0     0   0   20 9                 29
2045165 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2019   kindergarten 4 5 0 0   0     0   1   4 6                       10.0 4 5 0 0   0     0   1   4 6                 10
2045175 MA Norfolk   school 2509870 243   Quincy 250987000772 2430020 Beechwood Knoll Elementary   Regular School No Elementary KG 05 2019   kindergarten 16 0 0 0   30     0   0   26 20                       46.0 16 0 0 0   30     0   0   26 20                 46
2045228 MA Norfolk   school 2509870 243   Quincy 250987001583 2430095 Squantum   Regular School No Elementary KG 05 2019   kindergarten 40 2 0 0   20     0   1   32 31                       63.0 40 2 0 0   20     0   1   32 31                 63
2045234 MA Norfolk   school 2509870 243   Quincy 250987002492 2430110 Wollaston School   Regular School No Elementary KG 05 2019   kindergarten 18 0 0 0   37     0   1   29 27                       56.0 18 0 0 0   37     0   1   29 27                 56
2045547 MA Essex   school 2510500 262   Saugus 251050001677 2620067 Douglas Waybright   Regular School No Elementary PK 05 2019   kindergarten 16 0 0 0   1     0   2   15 4                       19.0 16 0 0 0   1     0   2   15 4                 19
2045573 MA Plymouth   school 2510560 264   Scituate 251056001691 2640010 Hatherly Elementary   Regular School No Elementary KG 05 2019   kindergarten 39 0 0 0   0     0   1   19 21                       40.0 39 0 0 0   0     0   1   19 21                 40
2045579 MA Plymouth   school 2510560 264   Scituate 251056002068 2640015 Jenkins Elementary School   Regular School No Elementary KG 05 2019   kindergarten 63 2 0 0   0     0   2   33 34                       67.0 63 2 0 0   0     0   2   33 34                 67
2045686 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No Elementary PK 06 2019   kindergarten 13 0 0 0   0     0   0   6 7                       13.0 13 0 0 0   0     0   0   6 7                 13
2045706 MA Bristol   school 2510860 273   Somerset 251086001727 2730015 South   Regular School No Elementary KG 05 2019   kindergarten 37 0 0 1   0     0   1   17 22                       39.0 37 0 0 1   0     0   1   17 22                 39
2046269 MA Worcester   school 2511400 290   Sutton 251140001661 2900003 Sutton Early Learning   Regular School No Elementary PK 02 2019   kindergarten 92 2 0 0   1     0   4   62 37                       99.0 92 2 0 0   1     0   4   62 37                 99
2046475 MA Middlesex   school 2511910 305   Wakefield 251191001948 3050040 Walton   Regular School No Elementary KG 04 2019   kindergarten 41 1 0 0   1     1   2   28 18                       46.0 41 1 0 0   1     1   2   28 18                 46
2046489 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales Elementary   Regular School No Elementary PK 06 2019   kindergarten 12 0 0 0   0     0   0   7 5                       12.0 12 0 0 0   0     0   0   7 5                 12
2046585 MA Hampshire   school 2512030 309   Ware 251203001982 3090020 Stanley M Koziol Elementary School   Regular School No Elementary PK 03 2019   kindergarten 84 0 0 0   0     0   0   38 46                       84.0 84 0 0 0   0     0   0   38 46                 84
2046738 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No Elementary PK 05 2019   kindergarten 14 1 0 0   0     0   2   7 10                       17.0 14 1 0 0   0     0   2   7 10                 17
2046869 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton Elementary School   Regular School No Elementary PK 06 2019   kindergarten 16 0 0 0   0     0   0   9 7                       16.0 16 0 0 0   0     0   0   9 7                 16
2046970 MA Norfolk   school 2512810 335   Westwood 251281002101 3350025 William E Sheehan   Regular School No Elementary KG 05 2019   kindergarten 45 1 0 0   3     0   5   27 27                       54.0 45 1 0 0   3     0   5   27 27                 54
2047035 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No Elementary PK 06 2019   kindergarten 17 0 0 0   0     0   0   9 8                       17.0 17 0 0 0   0     0   0   9 8                 17
2047043 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No Elementary PK 06 2019   kindergarten 18 0 0 0   0     0   0   12 6                       18.0 18 0 0 0   0     0   0   12 6                 18
2047089 MA Middlesex   school 2513110 344   Winchester 251311002165 3440005 Lincoln Elementary   Regular School No Elementary KG 05 2019   kindergarten 52 0 0 0   7     0   3   35 27                       62.0 52 0 0 0   7     0   3   35 27                 62
2047109 MA Middlesex   school 2513110 344   Winchester 251311002168 3440040 Muraco Elementary   Regular School No Elementary KG 05 2019   kindergarten 36 1 0 0   11     0   4   22 30                       52.0 36 1 0 0   11     0   4   22 30                 52
2047115 MA Middlesex   school 2513110 344   Winchester 251311002164 3440045 Ambrose Elementary   Regular School No Elementary KG 05 2019   kindergarten 45 0 0 0   6     0   3   29 25                       54.0 45 0 0 0   6     0   3   29 25                 54
2048074 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No Elementary KG 06 2019   kindergarten 29 2 0 0   5     0   5   24 17                       41.0 29 2 0 0   5     0   5   24 17                 41
2048260 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2019   kindergarten 13 0 0 0   0     0   0   8 5                       13.0 13 0 0 0   0     0   0   8 5                 13
2048388 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2019   kindergarten 15 0 0 0   0     0   0   8 7                       15.0 15 0 0 0   0     0   0   8 7                 15
2048422 MA Hampden   school 2505160 672   Gateway 250516000757 6720059 Chester Elementary   Regular School No Elementary PK 05 2019   kindergarten 20 0 0 0   0     0   0   13 7                       20.0 20 0 0 0   0     0   0   13 7                 20
2048490 MA Essex   school 2505670 675   Hamilton-Wenham 250567000818 6750010 Cutler School   Regular School No Elementary KG 05 2019   kindergarten 40 0 0 0   1     0   1   20 22                       42.0 40 0 0 0   1     0   1   20 22                 42
2048562 MA Essex   school 2500067 698   Manchester Essex Regional 250006701110 6980010 Manchester Memorial Elementary   Regular School No Elementary PK 05 2019   kindergarten 41 0 0 0   0     0   2   20 23                       43.0 41 0 0 0   0     0   2   20 23                 43
2048602 MA Worcester   school 2507680 710   Mendon-Upton 250768001200 7100179 Henry P Clough   Regular School No Elementary PK 04 2019   kindergarten 57 0 0 0   0     0   0   25 32                       57.0 57 0 0 0   0     0   0   25 32                 57
2048665 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Colrain Central   Regular School No Elementary PK 06 2019   kindergarten 12 0 0 0   0     0   0   5 7                       12.0 12 0 0 0   0     0   0   5 7                 12
2048673 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Sanderson Academy   Regular School No Elementary PK 06 2019   kindergarten 21 0 0 0   0     1   0   11 11                       22.0 21 0 0 0   0     1   0   11 11                 22
2048722 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No Elementary PK 08 2019   kindergarten 67 0 0 0   2     0   1   36 34                       70.0 67 0 0 0   2     0   1   36 34                 70
2048822 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Bernardston Elementary   Regular School No Elementary PK 06 2019   kindergarten 18 0 0 0   0     0   0   10 8                       18.0 18 0 0 0   0     0   0   10 8                 18
2048843 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No Elementary PK 06 2019   kindergarten 6 0 0 0   0     0   0   3 3                       6.0 6 0 0 0   0     0   0   3 3                 6
2049002 MA Essex   school 2511740 773   Triton 251174001651 7730025 Pine Grove   Regular School No Elementary PK 06 2019   kindergarten 47 0 0 0   0     0   0   22 25                       47.0 47 0 0 0   0     0   0   22 25                 47
2049015 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No Elementary KG 05 2019   kindergarten 10 0 0 0   0     0   0   5 5                       10.0 10 0 0 0   0     0   0   5 5                 10
2049032 MA Worcester   school 2511880 775   Wachusett 251188002693 7750005 Naquag Elementary School   Regular School No Elementary KG 02 2019   kindergarten 94 0 0 0   2     0   1   49 48                       97.0 94 0 0 0   2     0   1   49 48                 97
2040196 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No Elementary PK 04 2019   kindergarten 76 5 1 0   15     0   9   51 55                       106.0 76 5 1 0   15     0   9   51 55                 106
2040210 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No Elementary PK 04 2019   kindergarten 74 1 1 0   1     1   1   39 40                       79.0 74 1 1 0   1     1   1   39 40                 79
2040688 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2019   kindergarten 19 3 1 0   1     0   2   12 14                       26.0 19 3 1 0   1     0   2   12 14                 26
2041146 MA Norfolk   school 2502940 40   Braintree 250294002570 400005 Hollis   Regular School No Elementary KG 05 2019   kindergarten 35 0 1 0   11     0   0   31 16                       47.0 35 0 1 0   11     0   0   31 16                 47
2041170 MA Norfolk   school 2502940 40   Braintree 250294000360 400033 Archie T Morrison   Regular School No Elementary KG 05 2019   kindergarten 17 0 1 0   2     0   0   8 12                       20.0 17 0 1 0   2     0   0   8 12                 20
2041429 MA Middlesex   school 2503240 48   Burlington 250324000432 480020 Pine Glen Elementary   Regular School No Elementary KG 05 2019   kindergarten 48 1 1 0   7     0   3   33 27                       60.0 48 1 1 0   7     0   3   33 27                 60
2041524 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative School No Elementary PK 05 2019   kindergarten 27 4 1 0   17     0   5   26 28                       54.0 27 4 1 0   17     0   5   26 28                 54
2041561 MA Norfolk   school 2503300 50   Canton 250330000454 500017 John F Kennedy   Regular School No Elementary KG 05 2019   kindergarten 63 6 1 0   8     0   9   48 39                       87.0 63 6 1 0   8     0   9   48 39                 87
2041780 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Joseph Osgood   Regular School No Elementary PK 02 2019   kindergarten 95 3 1 0   1     0   1   47 54                       101.0 95 3 1 0   1     0   1   47 54                 101
2041983 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Chandler Elementary   Regular School No Elementary PK 02 2019   kindergarten 170 1 1 0   1     0   4   93 84                       177.0 170 1 1 0   1     0   4   93 84                 177
2042009 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No Elementary PK 05 2019   kindergarten 18 2 1 0   2     0   1   18 6                       24.0 18 2 1 0   2     0   1   18 6                 24
2042092 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No Elementary PK 06 2019   kindergarten 13 0 1 0   0     0   1   10 5                       15.0 13 0 1 0   0     0   1   10 5                 15
2042372 MA Norfolk   school 2504950 99   Foxborough 250495000710 990015 Mabelle M Burrell   Regular School No Elementary PK 04 2019   kindergarten 41 1 1 0   0     0   1   19 25                       44.0 41 1 1 0   0     0   1   19 25                 44
2042476 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No Elementary KG 05 2019   kindergarten 45 1 1 0   1     2   0   25 25                       50.0 45 1 1 0   1     2   0   25 25                 50
2042710 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2019   kindergarten 28 0 1 0   0     0   1   14 16                       30.0 28 0 1 0   0     0   1   14 16                 30
2042849 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No Elementary PK 06 2019   kindergarten 27 0 1 0   0     0   0   11 17                       28.0 27 0 1 0   0     0   0   11 17                 28
2043037 MA Plymouth   school 2506540 145   Kingston 250654000943 1450005 Kingston Elementary   Regular School No Elementary KG 02 2019   kindergarten 147 0 1 0   0     0   3   72 79                       151.0 147 0 1 0   0     0   3   72 79                 151
2043242 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No Elementary PK 06 2019   kindergarten 14 0 1 0   0     0   1   7 9                       16.0 14 0 1 0   0     0   1   7 9                 16
2043268 MA Middlesex   school 2506840 155   Lexington 250684000996 1550015 Fiske   Regular School No Elementary KG 05 2019   kindergarten 33 4 1 0   21     0   1   34 26                       60.0 33 4 1 0   21     0   1   34 26                 60
2043317 MA Middlesex   school 2506960 158   Littleton 250696001014 1580005 Shaker Lane Elementary   Regular School No Elementary PK 02 2019   kindergarten 102 1 1 0   13     1   2   69 51                       120.0 102 1 1 0   13     1   2   69 51                 120
2043778 MA Essex   school 2507260 168   Marblehead 250726001121 1680020 Glover   Regular School No Elementary PK 03 2019   kindergarten 61 1 1 0   1     0   5   38 31                       69.0 61 1 1 0   1     0   5   38 31                 69
2043790 MA Plymouth   school 2507290 169   Marion 250729001127 1690005 Sippican   Regular School No Elementary PK 06 2019   kindergarten 48 2 1 0   1     0   3   31 24                       55.0 48 2 1 0   1     0   3   31 24                 55
2043822 MA Plymouth   school 2507350 171   Marshfield 250735000760 1710005 Eames Way School   Regular School No Elementary KG 05 2019   kindergarten 34 0 1 0   0     0   0   17 18                       35.0 34 0 1 0   0     0   0   17 18                 35
2043983 MA Middlesex   school 2507620 178   Melrose 250762001191 1780025 Horace Mann   Regular School No Elementary KG 05 2019   kindergarten 40 0 1 0   1     0   4   20 26                       46.0 40 0 1 0   1     0   4   20 26                 46
2043995 MA Middlesex   school 2507620 178   Melrose 250762001198 1780050 Winthrop   Regular School No Elementary KG 05 2019   kindergarten 54 1 1 0   4     0   2   36 26                       62.0 54 1 1 0   4     0   2   36 26                 62
2044142 MA Norfolk   school 2507980 189   Milton 250798001261 1890010 Glover   Regular School No Elementary KG 05 2019   kindergarten 84 6 1 1   3     0   6   48 53                       101.0 84 6 1 1   3     0   6   48 53                 101
2044491 MA Middlesex   school 2508610 207   Newton 250861001371 2070080 Mason-Rice   Regular School No Elementary KG 05 2019   kindergarten 36 0 1 0   16     0   3   28 28                       56.0 36 0 1 0   16     0   3   28 28                 56
2044503 MA Middlesex   school 2508610 207   Newton 250861001373 2070105 Memorial Spaulding   Regular School No Elementary KG 05 2019   kindergarten 45 0 1 0   11     0   3   22 38                       60.0 45 0 1 0   11     0   3   22 38                 60
2044680 MA Bristol   school 2508730 212   North Attleborough 250873001408 2120015 Roosevelt Avenue   Regular School No Elementary KG 05 2019   kindergarten 41 1 1 1   5     0   0   18 31                       49.0 41 1 1 1   5     0   0   18 31                 49
2044769 MA Middlesex   school 2508820 217   North Reading 250882001419 2170010 J Turner Hood   Regular School No Elementary KG 05 2019   kindergarten 56 1 1 0   3     0   1   38 24                       62.0 56 1 1 0   3     0   1   38 24                 62
2044962 MA Essex   school 2509360 229   Peabody 250936001505 2290045 West Memorial   Regular School No Elementary PK 05 2019   kindergarten 40 0 1 0   1     0   0   22 20                       42.0 40 0 1 0   1     0   0   22 20                 42
2045012 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No Elementary KG 06 2019   kindergarten 21 0 1 0   0     0   0   11 11                       22.0 21 0 1 0   0     0   0   11 11                 22

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