Data source: Big Local News · About: Big Local

970 rows where grade = "kindergarten", state = "MA" and year = 2017 sorted by male

View and edit SQL

year

  • 2017 · 970

grade

  • kindergarten · 970
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
1125185 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   kindergarten * * * *   *     *   *   * *                       *                                              
1125259 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   kindergarten * * * *   *     *   *   * *                       *                                              
1123194 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Elementary KG 08 2017   kindergarten * * * *   *     *   *   1 1                       *                         1 1                  
1125389 MA Essex   school 2505970 128   Haverhill 250597000296 1280026 Golden Hill   Regular School No Elementary KG 04 2017   kindergarten * * * *   *     *   *   1 3                       *                         1 3                  
1126445 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary KG 06 2017   kindergarten * * * *   *     *   *   1 *                       *                         1                    
1130371 MA Hampden   school 2512510 332   West Springfield 251251002044 3320010 John R Fausey   Regular School No Elementary KG 05 2017   kindergarten * * * *   *     *   *   1 1                       *                         1 1                  
1122887 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Joseph P Manning   Regular School No Elementary PK 05 2017   kindergarten 7 0 9 0   2     0   3   10 11                       21 7 0 9 0   2     0   3   10 11                 21
1122975 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No Elementary PK 05 2017   kindergarten 4 7 10 0   1     0   1   10 13                       23 4 7 10 0   1     0   1   10 13                 23
1122983 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2017   kindergarten 21 1 0 0   0     0   0   10 12                       22 21 1 0 0   0     0   0   10 12                 22
1123060 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Roger Clap   Regular School No Elementary PK 05 2017   kindergarten 6 10 3 0   1     0   0   10 10                       20 6 10 3 0   1     0   0   10 10                 20
1123224 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2017   kindergarten 12 5 6 0   0     0   0   10 13                       23 12 5 6 0   0     0   0   10 13                 23
1126003 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No Elementary PK 06 2017   kindergarten 12 0 0 0   0     0   3   10 5                       15 12 0 0 0   0     0   3   10 5                 15
1128547 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2017   kindergarten 17 0 0 0   0     0   0   10 7                       17 17 0 0 0   0     0   0   10 7                 17
1128898 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No Elementary PK 06 2017   kindergarten 15 0 1 0   0     0   2   10 8                       18 15 0 1 0   0     0   2   10 8                 18
1130132 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No Elementary PK 05 2017   kindergarten 14 1 2 0   0     0   1   10 8                       18 14 1 2 0   0     0   1   10 8                 18
1131373 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2017   kindergarten 14 0 0 0   1     0   5   10 10                       20 14 0 0 0   1     0   5   10 10                 20
1131942 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Becket Washington School   Regular School No Elementary PK 05 2017   kindergarten 14 0 0 0   0     0   1   10 5                       15 14 0 0 0   0     0   1   10 5                 15
1131958 MA Berkshire   school 2503390 635   Central Berkshire 250339000465 6350035 Kittredge   Regular School No Elementary PK 05 2017   kindergarten 28 0 0 0   0     0   1   10 19                       29 28 0 0 0   0     0   1   10 19                 29
1132407 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Sanderson Academy   Regular School No Elementary PK 06 2017   kindergarten 17 0 2 0   0     0   0   10 9                       19 17 0 2 0   0     0   0   10 9                 19
1124365 MA Norfolk   school 2504050 73   Dedham 250405000460 730005 Early Childhood Center   Regular School No Elementary PK KG 2017   kindergarten 125 12 32 1   3     0   14   100 87                       187 125 12 32 1   3     0   14   100 87                 187
1125525 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No Elementary PK 02 2017   kindergarten 172 1 9 0   15     0   11   104 104                       208 172 1 9 0   15     0   11   104 104                 208
1123518 MA Norfolk   school 2502940 40   Braintree 250294000367 400020 Mary E Flaherty School   Regular School No Elementary KG 05 2017   kindergarten 18 1 0 0   6     0   0   11 14                       25 18 1 0 0   6     0   0   11 14                 25
1123538 MA Norfolk   school 2502940 40   Braintree 250294000363 400050 Donald Ross   Regular School No Elementary KG 05 2017   kindergarten 14 2 0 0   4     0   0   11 9                       20 14 2 0 0   4     0   0   11 9                 20
1124279 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No Elementary PK 06 2017   kindergarten 15 0 2 0   0     0   0   11 6                       17 15 0 2 0   0     0   0   11 6                 17
1127351 MA Bristol   school 2508430 201   New Bedford 250843001330 2010130 Jireh Swift   Regular School No Elementary KG 05 2017   kindergarten 17 3 2 0   1     0   0   11 12                       23 17 3 2 0   1     0   0   11 12                 23
1127988 MA Essex   school 2509360 229   Peabody 250936001496 2290007 John E Burke   Regular School No Elementary KG 05 2017   kindergarten 33 0 1 0   2     0   2   11 27                       38 33 0 1 0   2     0   2   11 27                 38
1128113 MA Berkshire   school 2509630 236   Pittsfield 250963001522 2360045 Robert T. Capeless Elementary School   Regular School No Elementary PK 05 2017   kindergarten 26 1 4 0   0     0   3   11 23                       34 26 1 4 0   0     0   3   11 23                 34
1129842 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales Elementary   Regular School No Elementary PK 06 2017   kindergarten 18 0 1 0   0     0   0   11 8                       19 18 0 1 0   0     0   0   11 8                 19
1130246 MA Hampden   school 2512630 325   Westfield 251263002066 3250055 Russell Elementary School   Regular School No Elementary KG 05 2017   kindergarten 23 0 3 0   0     0   0   11 15                       26 23 0 3 0   0     0   0   11 15                 26
1130466 MA Norfolk   school 2512840 336   Weymouth 251284002565 3360050 Frederick C Murphy   Regular School No Elementary KG 04 2017   kindergarten 20 1 1 0   0     0   0   11 11                       22 20 1 1 0   0     0   0   11 11                 22
1130742 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2017   kindergarten 7 2 11 0   0     0   2   11 11                       22 7 2 11 0   0     0   2   11 11                 22
1131934 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2017   kindergarten 21 0 0 1   0     0   0   11 11                       22 21 0 0 1   0     0   0   11 11                 22
1132694 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 New Marlborough Central   Regular School No Elementary PK 04 2017   kindergarten 19 0 0 0   0     0   0   11 8                       19 19 0 0 0   0     0   0   11 8                 19
1133182 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2017   kindergarten 13 3 3 0   1     0   3   11 12                       23 13 3 3 0   1     0   3   11 12                 23
1122186 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2017   kindergarten 144 2 26 0   31     0   10   111 102                       213 144 2 26 0   31     0   10   111 102                 213
1125647 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Center   Regular School No Elementary KG 01 2017   kindergarten 186 1 4 1   30     0   2   111 113                       224 186 1 4 1   30     0   2   111 113                 224
1126600 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No Elementary KG 02 2017   kindergarten 184 7 14 0   16     0   11   116 116                       232 184 7 14 0   16     0   11   116 116                 232
1123598 MA Plymouth   school 2503090 44   Brockton 250309002792 440007 Barrett Russell School   Regular School No Elementary KG KG 2017   kindergarten 24 129 42 1   4     0   19   117 102                       219 24 129 42 1   4     0   19   117 102                 219
1126347 MA Essex   school 2507110 163   Lynn 250711002801 1630004 Early Childhood Center   Regular School No Elementary PK 05 2017   kindergarten 29 22 140 1   24     0   8   117 107                       224 29 22 140 1   24     0   8   117 107                 224
1131898 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Mitchell Elementary School   Regular School No Elementary PK 03 2017   kindergarten 189 15 4 0   5     0   6   117 102                       219 189 15 4 0   5     0   6   117 102                 219
1123511 MA Norfolk   school 2502940 40   Braintree 250294000365 400015 Highlands   Regular School No Elementary KG 05 2017   kindergarten 19 0 1 0   2     0   0   12 10                       22 19 0 1 0   2     0   0   12 10                 22
1127686 MA Bristol   school 2508730 212   North Attleborough 250873001402 2120010 Falls   Regular School No Elementary KG 05 2017   kindergarten 20 1 2 0   1     0   0   12 12                       24 20 1 2 0   1     0   0   12 12                 24
1132621 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary KG 06 2017   kindergarten 18 0 1 0   0     0   0   12 7                       19 18 0 1 0   0     0   0   12 7                 19
1130362 MA Hampden   school 2512510 332   West Springfield 251251002504 3320005 John Ashley   Regular School No Elementary KG KG 2017   kindergarten 169 6 40 0   5     0   6   121 105                       226 169 6 40 0   5     0   6   121 105                 226
1122589 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2017   kindergarten 12 3 5 0   1     0   0   13 8                       21 12 3 5 0   1     0   0   13 8                 21
1122837 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No Elementary PK 05 2017   kindergarten 8 9 7 0   0     0   1   13 12                       25 8 9 7 0   0     0   1   13 12                 25
1123531 MA Norfolk   school 2502940 40   Braintree 250294000360 400033 Archie T Morrison   Regular School No Elementary KG 05 2017   kindergarten 17 3 0 0   4     0   0   13 11                       24 17 3 0 0   4     0   0   13 11                 24
1124154 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No Elementary KG 05 2017   kindergarten 19 1 5 0   0     0   0   13 12                       25 19 1 5 0   0     0   0   13 12                 25
1124509 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No Elementary PK 05 2017   kindergarten 26 1 0 0   0     0   0   13 14                       27 26 1 0 0   0     0   0   13 14                 27
1126360 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2017   kindergarten 7 7 9 0   4     0   4   13 18                       31 7 7 9 0   4     0   4   13 18                 31
1128717 MA Essex   school 2510500 262   Saugus 251050001682 2620050 Oaklandvale   Regular School No Elementary KG 05 2017   kindergarten 22 1 3 0   3     0   0   13 16                       29 22 1 3 0   3     0   0   13 16                 29
1128873 MA Worcester   school 2510770 271   Shrewsbury 251077001719 2710025 Walter J Paton   Regular School No Elementary KG 04 2017   kindergarten 15 1 0 0   3     0   1   13 7                       20 15 1 0 0   3     0   1   13 7                 20
1131409 MA Essex   school 2500083 455   Hill View Montessori Charter Public (District) 250008301846 4550050 Hill View Montessori Charter Public School   Regular School Yes Elementary KG 08 2017   kindergarten 21 4 7 0   0     0   2   13 21                       34 21 4 7 0   0     0   2   13 21                 34
1123509 MA Norfolk   school 2502940 40   Braintree 250294002789 400009 Monatiquot Kindergarten Center   Regular School No Elementary KG KG 2017   kindergarten 185 13 12 1   44     0   7   134 128                       262 185 13 12 1   44     0   7   134 128                 262
1128859 MA Worcester   school 2510770 271   Shrewsbury 251077002496 2710005 Beal School   Regular School No Elementary KG 01 2017   kindergarten 95 2 13 0   128     0   11   137 112                       249 95 2 13 0   128     0   11   137 112                 249
1122442 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No Elementary PK 05 2017   kindergarten 26 1 0 0   1     0   0   14 14                       28 26 1 0 0   1     0   0   14 14                 28
1123164 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Winship Elementary   Regular School No Elementary PK 05 2017   kindergarten 7 5 12 0   5     0   0   14 15                       29 7 5 12 0   5     0   0   14 15                 29
1125155 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No Elementary KG 05 2017   kindergarten 31 3 2 0   1     0   0   14 23                       37 31 3 2 0   1     0   0   14 23                 37
1128033 MA Essex   school 2509360 229   Peabody 250936001505 2290045 West Memorial   Regular School No Elementary PK 05 2017   kindergarten 30 1 0 0   0     0   2   14 19                       33 30 1 0 0   0     0   2   14 19                 33
1131187 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway   Regular School Yes Elementary PK 05 2017   kindergarten 0 0 42 0   0     0   0   14 28                       42 0 0 42 0   0     0   0   14 28                 42
1131742 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000018 6030004 Cheshire Elementary   Regular School No Elementary PK 05 2017   kindergarten 28 0 0 0   0     0   0   14 14                       28 28 0 0 0   0     0   0   14 14                 28
1131877 MA Worcester   school 2502715 622   Blackstone-Millville 250271500185 6220010 Millville Elementary   Regular School No Elementary PK 05 2017   kindergarten 31 1 2 0   1     0   2   14 23                       37 31 1 2 0   1     0   2   14 23                 37
1132423 MA Worcester   school 2508280 720   Narragansett 250828001287 7200003 Phillipston Memorial   Regular School No Elementary PK 04 2017   kindergarten 19 1 0 1   0     0   1   14 8                       22 19 1 0 1   0     0   1   14 8                 22
1123494 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No Elementary PK 05 2017   kindergarten 23 0 1 2   2     0   3   15 16                       31 23 0 1 2   2     0   3   15 16                 31
1124310 MA Essex   school 2503990 71   Danvers 250399000534 710032 Ivan G Smith   Regular School No Elementary KG 05 2017   kindergarten 31 0 4 0   1     0   1   15 22                       37 31 0 4 0   1     0   1   15 22                 37
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
1125746 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No Elementary PK 06 2017   kindergarten 28 1 0 0   0     0   0   15 14                       29 28 1 0 0   0     0   0   15 14                 29
1127336 MA Bristol   school 2508430 201   New Bedford 250843002802 2010124 Renaissance Community School for the Arts   Regular School No Elementary PK 05 2017   kindergarten 6 4 28 0   0     0   1   15 24                       39 6 4 28 0   0     0   1   15 24                 39
1128050 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham Elementary   Regular School No Elementary KG 06 2017   kindergarten 17 2 1 0   0     0   1   15 6                       21 17 2 1 0   0     0   1   15 6                 21
1128338 MA Norfolk   school 2509870 243   Quincy 250987001582 2430090 Snug Harbor Community School   Regular School No Elementary PK 05 2017   kindergarten 17 6 2 0   20     0   3   15 33                       48 17 6 2 0   20     0   3   15 33                 48
1130421 MA Norfolk   school 2512810 335   Westwood 251281002099 3350015 Paul Hanlon   Regular School No Elementary KG 05 2017   kindergarten 20 1 2 0   4     0   3   15 15                       30 20 1 2 0   4     0   3   15 15                 30
1130704 MA Middlesex   school 2513200 347   Woburn 251320002194 3470060 Wyman   Regular School No Elementary KG 05 2017   kindergarten 19 1 3 0   5     0   1   15 14                       29 19 1 3 0   5     0   1   15 14                 29
1131157 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 05 2017   kindergarten 0 24 11 0   0     0   1   15 21                       36 0 24 11 0   0     0   1   15 21                 36
1132214 MA Essex   school 2505670 675   Hamilton-Wenham 250567000821 6750015 Winthrop School   Regular School No Elementary PK 05 2017   kindergarten 36 1 1 2   2     0   2   15 29                       44 36 1 1 2   2     0   2   15 29                 44
1132299 MA Essex   school 2500067 698   Manchester Essex Regional 250006700627 6980020 Essex Elementary   Regular School No Elementary KG 05 2017   kindergarten 28 0 1 0   0     0   0   15 14                       29 28 0 1 0   0     0   0   15 14                 29
1127901 MA Norfolk   school 2509060 220   Norwood 250906001557 2200075 George F. Willett   Regular School No Elementary PK KG 2017   kindergarten 163 26 42 1   49     0   8   154 135                       289 163 26 42 1   49     0   8   154 135                 289
1122054 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2017   kindergarten 19 6 12 0   5     0   0   16 26                       42 19 6 12 0   5     0   0   16 26                 42
1122571 MA Suffolk   school 2502790 35   Boston 250279002514 350006 ELC - West Zone   Regular School No Elementary PK 01 2017   kindergarten 9 10 15 1   1     0   1   16 21                       37 9 10 15 1   1     0   1   16 21                 37
1122753 MA Suffolk   school 2502790 35   Boston 250279000241 350122 George H Conley   Regular School No Elementary PK 05 2017   kindergarten 7 5 11 0   0     0   0   16 7                       23 7 5 11 0   0     0   0   16 7                 23
1122949 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No Elementary KG 05 2017   kindergarten 9 13 14 0   0     0   0   16 20                       36 9 13 14 0   0     0   0   16 20                 36
1123568 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No Elementary PK 06 2017   kindergarten 33 0 0 0   2     0   0   16 19                       35 33 0 0 0   2     0   0   16 19                 35
1123946 MA Middlesex   school 2503270 49   Cambridge 250327001518 490090 Fletcher/Maynard Academy   Regular School No Elementary PK 05 2017   kindergarten 12 19 4 0   5     0   1   16 25                       41 12 19 4 0   5     0   1   16 25                 41
1127290 MA Bristol   school 2508430 201   New Bedford 250843001323 2010075 Ellen R Hathaway   Regular School No Elementary KG 05 2017   kindergarten 9 6 18 1   0     0   1   16 19                       35 9 6 18 1   0     0   1   16 19                 35
1127579 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No Elementary PK 07 2017   kindergarten 25 0 2 0   0     0   2   16 13                       29 25 0 2 0   0     0   2   16 13                 29
1127618 MA Hampshire   school 2508850 210   Northampton 250885001433 2100029 R. K. Finn Ryan Road   Regular School No Elementary KG 05 2017   kindergarten 27 2 5 0   2     0   1   16 21                       37 27 2 5 0   2     0   1   16 21                 37
1127913 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No Elementary PK 08 2017   kindergarten 28 0 9 0   1     0   2   16 24                       40 28 0 9 0   1     0   2   16 24                 40
1128954 MA Middlesex   school 2510890 274   Somerville 251089001738 2740083 John F Kennedy   Regular School No Elementary PK 08 2017   kindergarten 35 2 4 0   3     0   3   16 31                       47 35 2 4 0   3     0   3   16 31                 47
1130088 MA Norfolk   school 2512270 317   Wellesley 251227002023 3170020 John D Hardy   Regular School No Elementary KG 05 2017   kindergarten 21 1 4 0   10     0   3   16 23                       39 21 1 4 0   10     0   3   16 23                 39
1130116 MA Norfolk   school 2512270 317   Wellesley 251227002021 3170050 Ernest F Upham   Regular School No Elementary KG 05 2017   kindergarten 28 1 3 0   6     0   0   16 22                       38 28 1 3 0   6     0   0   16 22                 38
1131101 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 07 2017   kindergarten 7 7 23 0   0     0   1   16 22                       38 7 7 23 0   0     0   1   16 22                 38
1131279 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2017   kindergarten 4 21 15 0   4     0   2   16 30                       46 4 21 15 0   4     0   2   16 30                 46
1132559 MA Essex   school 2509450 745   Pentucket 250945000408 7450015 Dr John C Page School   Regular School No Elementary PK 06 2017   kindergarten 40 0 1 0   1     0   0   16 26                       42 40 0 1 0   1     0   0   16 26                 42
1122045 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2017   kindergarten 15 3 8 0   6     0   2   17 17                       34 15 3 8 0   6     0   2   17 17                 34
1123502 MA Norfolk   school 2502940 40   Braintree 250294002570 400005 Hollis   Regular School No Elementary KG 05 2017   kindergarten 21 2 0 0   7     0   0   17 13                       30 21 2 0 0   7     0   0   17 13                 30
1124596 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No Elementary PK 08 2017   kindergarten 24 0 10 1   0     0   2   17 20                       37 24 0 10 1   0     0   2   17 20                 37
1125146 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No Elementary KG 05 2017   kindergarten 31 0 1 0   0     0   1   17 16                       33 31 0 1 0   0     0   1   17 16                 33
1125539 MA Hampden   school 2506270 137   Holyoke 250627001178 1370003 Joseph Metcalf School   Regular School No Elementary PK 02 2017   kindergarten 16 3 23 0   0     0   0   17 25                       42 16 3 23 0   0     0   0   17 25                 42
1125555 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No Elementary PK 08 2017   kindergarten 1 0 37 0   1     0   0   17 22                       39 1 0 37 0   1     0   0   17 22                 39
1127934 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans Elementary   Regular School No Elementary KG 05 2017   kindergarten 29 4 1 0   0     0   1   17 18                       35 29 4 1 0   0     0   1   17 18                 35
1128446 MA Middlesex   school 2509990 246   Reading 250999001609 2460010 Joshua Eaton   Regular School No Elementary KG 05 2017   kindergarten 27 0 1 1   4     0   4   17 20                       37 27 0 1 1   4     0   4   17 20                 37

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