Data source: Big Local News · About: Big Local

6,747 rows where grade = "kindergarten" and state = "MA" sorted by native_hawaiian_pacific_islander_int descending

View and edit SQL

year

grade

  • kindergarten · 6,747
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
1122370 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 South Elementary   Regular School No Elementary KG 03 2017   kindergarten 63 1 1 0   1     8   0   40 34                       74 63 1 1 0   1     8   0   40 34                 74
741069 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Clifford H Marshall Elementary   Regular School No 1 KG 04 2015   kindergarten 35 8 10 0   53     6   2   57 57                       114 35 8 10 0   53     6   2   57 57                 114
1122375 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No Elementary KG 03 2017   kindergarten 74 2 4 0   0     5   2   47 40                       87 74 2 4 0   0     5   2   47 40                 87
1676880 MA Worcester   school 2508880 213   Northborough 250888001438 2130014 Northborough - Marguerite E Peaslee   Regular School No Elementary KG 05 2021   kindergarten 25 1 1 1   2     5   2   17 20 *                     37.0 25 1 1 1   2     5   2   17 20                 37
2234723 MA Norfolk   school 2509060 220   Norwood 250906001557 2200075 Norwood: George F. Willett   Regular School No Elementary PK KG 2018   kindergarten 168 24 35 0   42     5   6   140 140                       280.0 168 24 35 0   42     5   6   140 140                 280
744370 MA Essex   school 2505670 675   Hamilton-Wenham 250567000818 6750010 Cutler School   Regular School No 1 KG 05 2015   kindergarten 36 0 1 0   0     3   1   20 21                       41 36 0 1 0   0     3   1   20 21                 41
935342 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No 1 PK 06 2016   kindergarten 26 0 6 0   0     3   3   24 14                       38 26 0 6 0   0     3   3   24 14                 38
1369775 MA Norfolk   school 2509060 220   Norwood 250906001557 2200075 George F. Willett   Regular School No Elementary PK KG 2020   kindergarten 166 18 40 0   35     3   6   137 131 *                     268.0 166 18 40 0   35     3   6   137 131                 268
1674639 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 Franklin - J F Kennedy Memorial   Regular School No Elementary KG 05 2021   kindergarten 44 0 1 0   4     3   0   30 22 *                     52.0 44 0 1 0   4     3   0   30 22                 52
1676014 MA Plymouth   school 2507350 171   Marshfield 250735001137 1710015 Marshfield - Daniel Webster   Regular School No Elementary PK 05 2021   kindergarten 39 0 1 0   0     3   1   21 23 *                     44.0 39 0 1 0   0     3   1   21 23                 44
2044849 MA Norfolk   school 2509060 220   Norwood 250906001557 2200075 George F. Willett   Regular School No Elementary PK KG 2019   kindergarten 167 27 23 1   39     3   4   146 118                       264.0 167 27 23 1   39     3   4   146 118                 264
737090 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No 1 KG 08 2015   kindergarten 17 68 12 1   2     2   7   56 53                       109 17 68 12 1   2     2   7   56 53                 109
737134 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No 1 KG 05 2015   kindergarten 23 58 13 1   1     2   11   58 51                       109 23 58 13 1   1     2   11   58 51                 109
737419 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Dean S Luce   Regular School No 1 KG 05 2015   kindergarten 57 7 6 0   14     2   2   45 43                       88 57 7 6 0   14     2   2   45 43                 88
743978 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000023 6030020 Plunkett Elementary   Regular School No 1 KG 05 2015   kindergarten 74 4 3 0   0     2   0   50 33                       83 74 4 3 0   0     2   0   50 33                 83
932682 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No 1 KG 05 2016   kindergarten 48 0 1 0   15     2   2   30 38                       68 48 0 1 0   15     2   2   30 38                 68
933829 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No 1 PK 04 2016   kindergarten 67 2 7 1   1     2   6   48 38                       86 67 2 7 1   1     2   6   48 38                 86
936212 MA Hampden   school 2507050 161   Ludlow 250705002663 1610010 East Street Elementary School   Regular School No 1 PK 01 2016   kindergarten 112 1 21 1   1     2   5   72 71                       143 112 1 21 1   1     2   5   72 71                 143
938210 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No 1 PK 02 2016   kindergarten 187 2 7 0   5     2   0   96 107                       203 187 2 7 0   5     2   0   96 107                 203
939892 MA Middlesex   school 2513200 347   Woburn 251320002189 3470065 Mary D Altavesta   Regular School No 1 KG 05 2016   kindergarten 24 5 10 0   7     2   1   24 25                       49 24 5 10 0   7     2   1   24 25                 49
1125291 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No Elementary PK 06 2017   kindergarten 21 2 1 1   0     2   1   15 13                       28 21 2 1 1   0     2   1   15 13                 28
1126561 MA Middlesex   school 2507170 165   Malden 250717001351 1650027 Forestdale   Regular School No Elementary KG 08 2017   kindergarten 27 10 9 0   7     2   4   29 30                       59 27 10 9 0   7     2   4   29 30                 59
1127481 MA Middlesex   school 2508610 207   Newton 250861001377 2070100 Peirce   Regular School No Elementary KG 05 2017   kindergarten 16 0 6 0   6     2   8   19 19                       38 16 0 6 0   6     2   8   19 19                 38
1366168 MA Plymouth   school 2503090 44   Brockton 250309000401 440017 John F Kennedy   Regular School No Elementary KG 05 2020   kindergarten 17 55 5 0   2     2   4   45 40 *                     85.0 17 55 5 0   2     2   4   45 40                 85
1367417 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No Elementary KG 05 2020   kindergarten 52 4 3 0   2     2   0   32 31 *                     63.0 52 4 3 0   2     2   0   32 31                 63
1368212 MA Middlesex   school 2506900 157   Lincoln 250690001009 1570006 Hanscom Primary   Regular School No Elementary PK 03 2020   kindergarten 36 2 11 0   0     2   8   28 31 *                     59.0 36 2 11 0   0     2   8   28 31                 59
1370725 MA Worcester   school 2510980 276   Southborough 251098001761 2760008 Mary E Finn School   Regular School No Elementary PK 01 2020   kindergarten 95 4 9 1   24     2   5   84 56 *                     140.0 95 4 9 1   24     2   5   84 56                 140
1372785 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2020   kindergarten 1 50 35 1   0     2   3   48 44 *                     92.0 1 50 35 1   0     2   3   48 44                 92
1672887 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Boston - Orchard Gardens   Regular School No Elementary PK 08 2021   kindergarten 2 24 26 0   2     2   0   29 27 *                     56.0 2 24 26 0   2     2   0   29 27                 56
1677022 MA Norfolk   school 2509060 220   Norwood 250906001557 2200075 Norwood - George F. Willett   Regular School No Elementary PK KG 2021   kindergarten 166 17 33 0   39     2   8   122 143 *                     265.0 166 17 33 0   39     2   8   122 143                 265
1679797 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District) - Brooke Charter School   Regular School Yes Other KG 12 2021   kindergarten 9 77 87 0   3     2   7   88 97 *                     185.0 9 77 87 0   3     2   7   88 97                 185
2040839 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2019   kindergarten 2 35 21 1   2     2   2   31 34                       65.0 2 35 21 1   2     2   2   31 34                 65
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
2045267 MA Norfolk   school 2509930 244   Randolph 250993001592 2440015 Margaret L Donovan   Regular School No Elementary KG 05 2019   kindergarten 12 42 8 1   15     2   2   43 39                       82.0 12 42 8 1   15     2   2   43 39                 82
2047621 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2019   kindergarten 10 14 93 0   2     2   1   52 70                       122.0 10 14 93 0   2     2   1   52 70                 122
2048521 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001598 6800025 Mile Tree Elementary   Regular School No Elementary PK 01 2019   kindergarten 118 3 14 0   4     2   6   75 72                       147.0 118 3 14 0   4     2   6   75 72                 147
2229176 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 Bellingham: South Elementary   Regular School No Elementary KG 03 2018   kindergarten 60 3 6 0   1     2   3   36 39                       75.0 60 3 6 0   1     2   3   36 39                 75
2229181 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Bellingham: Stall Brook   Regular School No Elementary KG 03 2018   kindergarten 71 2 3 0   1     2   2   45 36                       81.0 71 2 3 0   1     2   2   45 36                 81
2231868 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Franklin: Jefferson Elementary   Regular School No Elementary KG 05 2018   kindergarten 47 2 2 0   6     2   0   37 22                       59.0 47 2 2 0   6     2   0   37 22                 59
2235119 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Quincy: Lincoln-Hancock Community School   Regular School No Elementary KG 04 2018   kindergarten 38 21 9 0   50     2   8   53 75                       128.0 38 21 9 0   50     2   8   53 75                 128
2236629 MA Middlesex   school 2511910 305   Wakefield 251191001943 3050015 Wakefield: Woodville School   Regular School No Elementary KG 04 2018   kindergarten 101 3 5 1   7     2   6   59 66                       125.0 101 3 5 1   7     2   6   59 66                 125
2237799 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Worcester: Tatnuck   Regular School No Elementary PK 06 2018   kindergarten 28 8 20 0   3     2   1   35 27                       62.0 28 8 20 0   3     2   1   35 27                 62
735812 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No 1 KG 05 2015   kindergarten 67 2 9 1   8     1   9   50 47                       97 67 2 9 1   8     1   9   50 47                 97
735837 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No 1 KG 05 2015   kindergarten 54 3 4 0   13     1   6   43 38                       81 54 3 4 0   13     1   6   43 38                 81
735978 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No 1 KG 02 2015   kindergarten 134 12 8 0   25     1   6   95 91                       186 134 12 8 0   25     1   6   95 91                 186
736219 MA Suffolk   school 2502790 35   Boston 250279002806 350015 Higginson   Regular School No 1 PK 02 2015   kindergarten 0 20 17 1   0     1   3   28 14                       42 0 20 17 1   0     1   3   28 14                 42
736282 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No 1 PK 07 2015   kindergarten 15 18 11 0   0     1   1   25 21                       46 15 18 11 0   0     1   1   25 21                 46
736330 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No 1 PK 08 2015   kindergarten 10 16 12 0   2     1   1   21 21                       42 10 16 12 0   2     1   1   21 21                 42
736347 MA Suffolk   school 2502790 35   Boston 250279000247 350135 Henry Grew   Regular School No 1 KG 05 2015   kindergarten 7 16 26 0   1     1   4   30 25                       55 7 16 26 0   1     1   4   30 25                 55
736353 MA Suffolk   school 2502790 35   Boston 250279002569 350138 O W Holmes   Regular School No 1 PK 05 2015   kindergarten 0 36 8 0   2     1   1   20 28                       48 0 36 8 0   2     1   1   20 28                 48
736367 MA Suffolk   school 2502790 35   Boston 250279000254 350146 James Condon Elementary   Regular School No 1 PK 05 2015   kindergarten 28 30 23 0   10     1   3   51 44                       95 28 30 23 0   10     1   3   51 44                 95
736419 MA Suffolk   school 2502790 35   Boston 250279000270 350180 John Winthrop   Regular School No 1 PK 05 2015   kindergarten 2 27 28 0   2     1   1   33 28                       61 2 27 28 0   2     1   1   33 28                 61
736453 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Joseph P Manning   Regular School No 1 PK 05 2015   kindergarten 13 4 3 0   0     1   1   14 8                       22 13 4 3 0   0     1   1   14 8                 22
736622 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Samuel W Mason   Regular School No 1 PK 05 2015   kindergarten 2 17 14 0   0     1   2   23 13                       36 2 17 14 0   0     1   2   23 13                 36
736629 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No 1 PK 08 2015   kindergarten 1 9 29 0   1     1   0   19 22                       41 1 9 29 0   1     1   0   19 22                 41
737059 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No 1 KG 05 2015   kindergarten 19 84 24 2   0     1   10   72 68                       140 19 84 24 2   0     1   10   72 68                 140
737078 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brookfield   Regular School No 1 KG 05 2015   kindergarten 24 65 11 0   2     1   8   62 49                       111 24 65 11 0   2     1   8   62 49                 111
737458 MA Middlesex   school 2503510 56   Chelmsford 250351001300 560005 Center Elementary School   Regular School No 1 KG 04 2015   kindergarten 54 2 5 0   10     1   0   26 46                       72 54 2 5 0   10     1   0   26 46                 72
737709 MA Bristol   school 2504020 72   Dartmouth 250402002698 720005 Andrew B. Cushman School   Regular School No 1 PK KG 2015   kindergarten 60 1 1 1   0     1   7   36 35                       71 60 1 1 1   0     1   7   36 35                 71
737788 MA Norfolk   school 2504260 78   Dover 250426000573 780005 Chickering   Regular School No 1 KG 05 2015   kindergarten 37 1 2 0   5     1   5   30 21                       51 37 1 2 0   5     1   5   30 21                 51
737845 MA Plymouth   school 2504440 83   East Bridgewater 250444000596 830005 Central   Regular School No 1 PK 02 2015   kindergarten 126 4 2 1   0     1   8   77 65                       142 126 4 2 1   0     1   8   77 65                 142
737909 MA Bristol   school 2504620 88   Easton 250462000980 880003 Center School   Regular School No 1 PK 02 2015   kindergarten 79 6 0 0   2     1   1   51 38                       89 79 6 0 0   2     1   1   51 38                 89
737965 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No 1 KG 08 2015   kindergarten 30 11 40 1   7     1   2   48 44                       92 30 11 40 1   7     1   2   48 44                 92
737998 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No 1 KG 08 2015   kindergarten 19 15 55 0   0     1   2   49 43                       92 19 15 55 0   0     1   2   49 43                 92
738325 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No 1 KG 05 2015   kindergarten 56 0 1 0   5     1   0   36 27                       63 56 0 1 0   5     1   0   36 27                 63
738400 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No 1 KG 05 2015   kindergarten 33 0 0 0   1     1   0   15 20                       35 33 0 0 0   1     1   0   15 20                 35
738491 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No 1 PK 06 2015   kindergarten 24 1 4 0   0     1   0   17 13                       30 24 1 4 0   0     1   0   17 13                 30
738796 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Center   Regular School No 1 KG 01 2015   kindergarten 173 2 7 1   25     1   7   116 100                       216 173 2 7 1   25     1   7   116 100                 216
739380 MA Worcester   school 2507080 162   Lunenburg 250708001957 1620010 Lunenburg Primary School   Regular School No 1 PK 03 2015   kindergarten 97 0 6 0   0     1   7   49 62                       111 97 0 6 0   0     1   7   49 62                 111
739460 MA Essex   school 2507110 163   Lynn 250711001075 1630060 Ingalls   Regular School No 1 KG 05 2015   kindergarten 7 13 74 0   7     1   5   49 58                       107 7 13 74 0   7     1   5   49 58                 107
739943 MA Worcester   school 2507860 185   Milford 250786001238 1850010 Memorial   Regular School No 1 KG 02 2015   kindergarten 94 5 40 4   6     1   11   94 67                       161 94 5 40 4   6     1   11   94 67                 161
740024 MA Hampden   school 2508040 191   Monson 250804002589 1910025 Quarry Hill Community School   Regular School No 1 PK 04 2015   kindergarten 60 0 2 0   1     1   0   30 34                       64 60 0 2 0   1     1   0   30 34                 64
740062 MA Middlesex   school 2508340 198   Natick 250834001291 1980005 Bennett-Hemenway   Regular School No 1 KG 04 2015   kindergarten 91 0 3 0   16     1   10   65 56                       121 91 0 3 0   16     1   10   65 56                 121
740124 MA Norfolk   school 2508370 199   Needham 250837000306 1990050 Newman Elementary   Regular School No 1 PK 05 2015   kindergarten 75 4 2 0   11     1   4   44 53                       97 75 4 2 0   11     1   4   44 53                 97
741074 MA Norfolk   school 2509870 243   Quincy 250987001573 2430060 Merrymount   Regular School No 1 KG 05 2015   kindergarten 38 5 0 0   16     1   0   35 25                       60 38 5 0 0   16     1   0   35 25                 60
741086 MA Norfolk   school 2509870 243   Quincy 250987001567 2430075 Francis W Parker   Regular School No 1 KG 05 2015   kindergarten 12 1 1 0   30     1   0   28 17                       45 12 1 1 0   30     1   0   28 17                 45
741105 MA Norfolk   school 2509870 243   Quincy 250987002492 2430110 Wollaston School   Regular School No 1 KG 05 2015   kindergarten 20 2 2 0   27     1   0   19 33                       52 20 2 2 0   27     1   0   19 33                 52
741143 MA Norfolk   school 2509930 244   Randolph 250993002596 2440018 J F Kennedy Elementary   Regular School No 1 PK 05 2015   kindergarten 11 36 9 0   5     1   2   41 23                       64 11 36 9 0   5     1   2   41 23                 64
741211 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No 1 KG 05 2015   kindergarten 40 5 31 0   7     1   2   40 46                       86 40 5 31 0   7     1   2   40 46                 86
741418 MA Essex   school 2510500 262   Saugus 251050001680 2620040 Lynnhurst   Regular School No 1 KG 05 2015   kindergarten 26 1 5 0   3     1   0   16 20                       36 26 1 5 0   3     1   0   16 20                 36
741424 MA Essex   school 2510500 262   Saugus 251050001682 2620050 Oaklandvale   Regular School No 1 KG 05 2015   kindergarten 20 2 2 0   0     1   1   9 17                       26 20 2 2 0   0     1   1   9 17                 26
741877 MA Hampden   school 2511130 281   Springfield 251113001820 2810125 Mary A. Dryden Veterans Memorial School   Regular School No 1 PK 05 2015   kindergarten 13 10 23 0   4     1   1   28 24                       52 13 10 23 0   4     1   1   28 24                 52
742060 MA Norfolk   school 2511250 285   Stoughton 251125001858 2850010 Helen Hansen Elementary   Regular School No 1 KG 05 2015   kindergarten 25 9 5 0   3     1   3   23 23                       46 25 9 5 0   3     1   3   23 23                 46
742073 MA Norfolk   school 2511250 285   Stoughton 251125001863 2850015 South Elementary   Regular School No 1 KG 05 2015   kindergarten 21 11 3 0   1     1   4   18 23                       41 21 11 3 0   1     1   4   18 23                 41
742114 MA Middlesex   school 2511340 288   Sudbury 251134001407 2880015 Israel Loring School   Regular School No 1 KG 05 2015   kindergarten 36 0 3 1   7     1   4   31 21                       52 36 0 3 1   7     1   4   31 21                 52
742144 MA Worcester   school 2511400 290   Sutton 251140001661 2900003 Sutton Early Learning   Regular School No 1 PK 02 2015   kindergarten 89 1 3 0   2     1   3   49 50                       99 89 1 3 0   2     1   3   49 50                 99
742224 MA Bristol   school 2511520 293   Taunton 251152001907 2930027 Elizabeth Pole   Regular School No 1 KG 04 2015   kindergarten 71 16 16 0   3     1   5   58 54                       112 71 16 16 0   3     1   5   58 54                 112
742237 MA Bristol   school 2511520 293   Taunton 251152001908 2930057 H H Galligan   Regular School No 1 KG 04 2015   kindergarten 24 10 12 0   0     1   5   30 22                       52 24 10 12 0   0     1   5   30 22                 52
742278 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No 1 PK 08 2015   kindergarten 23 1 8 1   1     1   2   21 16                       37 23 1 8 1   1     1   2   21 16                 37
742545 MA Worcester   school 2512240 316   Webster 251224002018 3160015 Park Avenue Elementary   Regular School No 1 PK 02 2015   kindergarten 108 6 32 1   0     1   6   81 73                       154 108 6 32 1   0     1   6   81 73                 154
743024 MA Suffolk   school 2513170 346   Winthrop 251317001665 3460015 William P. Gorman/Fort Banks Elementary   Regular School No 1 PK 03 2015   kindergarten 126 4 18 0   0     1   3   88 64                       152 126 4 18 0   0     1   3   88 64                 152
743410 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes 1 KG 05 2015   kindergarten 11 2 19 3   0     1   3   20 19                       39 11 2 19 3   0     1   3   20 19                 39
743485 MA Barnstable   school 2500081 427   Barnstable Community Horace Mann Charter Public (District) 250008101844 4270010 Barnstable Community Horace Mann Charter Public School   Regular School Yes 1 KG 03 2015   kindergarten 48 7 14 1   3     1   1   39 36                       75 48 7 14 1   3     1   1   39 36                 75
744053 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202736 6160002 Page Hilltop Elementary School   Regular School No 1 PK 05 2015   kindergarten 61 3 9 0   2     1   2   44 34                       78 61 3 9 0   2     1   2   44 34                 78
744522 MA Franklin   school 2507990 717   Mohawk Trail 250799000424 7170005 Buckland-Shelburne Regional   Regular School No 1 PK 06 2015   kindergarten 31 0 1 0   0     1   4   25 12                       37 31 0 1 0   0     1   4   25 12                 37
744865 MA Essex   school 2511740 773   Triton 251174001669 7730015 Salisbury Elementary   Regular School No 1 PK 06 2015   kindergarten 51 1 1 0   1     1   2   34 23                       57 51 1 1 0   1     1   2   34 23                 57
745007 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000200 7800030 John H Duval   Regular School No 1 KG 05 2015   kindergarten 58 2 3 0   0     1   3   34 33                       67 58 2 3 0   0     1   3   34 33                 67
932700 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No 1 KG 05 2016   kindergarten 60 5 5 0   13     1   1   40 45                       85 60 5 5 0   13     1   1   40 45                 85
932733 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No 1 KG 02 2016   kindergarten 128 2 24 1   25     1   9   97 93                       190 128 2 24 1   25     1   9   97 93                 190
932746 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No 1 KG 04 2016   kindergarten 49 3 16 0   2     1   9   44 36                       80 49 3 16 0   2     1   9   44 36                 80

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