Data source: Big Local News · About: Big Local

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

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
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                  
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 * * * *   *     *   *   * *                       *                                              
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                  
1132401 MA Franklin   school 2507990 717   Mohawk Trail 250799000934 7170015 Heath Elementary   Regular School No Elementary PK 06 2017   kindergarten * * * *   *     *   *   2 3                       *                         2 3                  
1368456 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   kindergarten * * * *   *     *   *   * * *                     0.0                                             0
1374306 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   kindergarten * * * *   *     *   *   * * *                     0.0                                             0
1674749 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   kindergarten * * * *   *     *   *   * * *                     0.0                                             0
1675697 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   kindergarten * * * *   *     *   *   * * *                     0.0                                             0
2230202 MA Suffolk   school   35   Boston   350652               2018   kindergarten * * * *   *     *   *   * *                       0.0                                             0
2231636 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   kindergarten * * * *   *     *   *   * *                       0.0                                             0
2232014 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   kindergarten * * * *   *     *   *   * *                       0.0                                             0
2237220 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   kindergarten * * * *   *     *   *   * *                       0.0                                             0
2233064 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell: Laura Lee Therapeutic Day School   Regular School No Middle KG 08 2018   kindergarten * * * *   *     *   *   1 *                       1.0                         1                   1
737941 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No 1 PK 06 2015   kindergarten 6 0 0 0   0     0   4   4 6                       10 6 0 0 0   0     0   4   4 6                 10
744538 MA Franklin   school 2507990 717   Mohawk Trail 250799000934 7170015 Heath Elementary   Regular School No 1 PK 06 2015   kindergarten 10 0 0 0   0     0   0   7 3                       10 10 0 0 0   0     0   0   7 3                 10
744714 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No 1 PK 06 2015   kindergarten 10 0 0 0   0     0   0   5 5                       10 10 0 0 0   0     0   0   5 5                 10
1365274 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No Elementary KG 08 2020   kindergarten 3 3 3 0   1     0   0   4 6 *                     10.0 3 3 3 0   1     0   0   4 6                 10
1372417 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2020   kindergarten 8 0 0 1   0     0   1   4 6 *                     10.0 8 0 0 1   0     0   1   4 6                 10
1373845 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 New Marlborough Central   Regular School No Elementary PK 04 2020   kindergarten 9 0 1 0   0     0   0   4 6 *                     10.0 9 0 1 0   0     0   0   4 6                 10
1373850 MA Berkshire   school 2511040 765   Southern Berkshire 251104001778 7650030 South Egremont   Regular School No Elementary KG 01 2020   kindergarten 8 0 1 0   1     0   0   * 6 *                     10.0 8 0 1 0   1     0   0     6                 10
1679680 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 Worthington - R. H. Conwell   Regular School No Elementary PK 06 2021   kindergarten 9 0 1 0   0     0   0   7 3 *                     10.0 9 0 1 0   0     0   0   7 3                 10
1680872 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Mohawk Trail - Sanderson Academy   Regular School No Elementary PK 06 2021   kindergarten 10 0 0 0   0     0   0   3 7 *                     10.0 10 0 0 0   0     0   0   3 7                 10
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
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
2047491 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2019   kindergarten 8 0 1 0   0     0   1   5 5                       10.0 8 0 1 0   0     0   1   5 5                 10
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
2239430 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Pioneer Valley: Warwick Community School   Regular School No Elementary PK 06 2018   kindergarten 9 0 0 0   0     0   1   5 5                       10.0 9 0 0 0   0     0   1   5 5                 10
736106 MA Essex   school 2502640 30   Beverly 250264000175 300055 Ayers/Ryal Side School   Regular School No 1 KG 05 2015   kindergarten 74 4 14 0   5     0   3   58 42                       100 74 4 14 0   5     0   3   58 42                 100
736484 MA Suffolk   school 2502790 35   Boston 250279000290 350226 Mattahunt   Regular School No 1 PK 05 2015   kindergarten 3 66 27 1   0     0   3   50 50                       100 3 66 27 1   0     0   3   50 50                 100
739309 MA Middlesex   school 2507020 160   Lowell 250702000092 1600080 Charlotte M Murkland Elementary   Regular School No 1 PK 04 2015   kindergarten 13 2 24 0   59     0   2   61 39                       100 13 2 24 0   59     0   2   61 39                 100
741829 MA Hampden   school 2511130 281   Springfield 251113001804 2810080 Frederick Harris   Regular School No 1 PK 05 2015   kindergarten 17 12 68 0   1     0   2   50 50                       100 17 12 68 0   1     0   2   50 50                 100
743570 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2015   kindergarten 20 23 48 0   6     0   3   55 45                       100 20 23 48 0   6     0   3   55 45                 100
932757 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No 1 KG 04 2016   kindergarten 72 5 15 0   5     0   3   61 39                       100 72 5 15 0   5     0   3   61 39                 100
934817 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No 1 KG 08 2016   kindergarten 30 16 50 0   3     0   1   48 52                       100 30 16 50 0   3     0   1   48 52                 100
936082 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Rogers Early Learning Center   Regular School No 1 PK 03 2016   kindergarten 26 6 42 0   24     0   2   52 48                       100 26 6 42 0   24     0   2   52 48                 100
940210 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Delaney   Regular School No 1 PK 03 2016   kindergarten 89 1 3 0   2     1   4   45 55                       100 89 1 3 0   2     1   4   45 55                 100
940393 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2016   kindergarten 19 28 45 0   3     0   5   55 45                       100 19 28 45 0   3     0   5   55 45                 100
1122259 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No Elementary KG 02 2017   kindergarten 88 1 4 0   2     0   5   51 49                       100 88 1 4 0   2     0   5   51 49                 100
1124674 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2017   kindergarten 14 15 64 0   6     0   1   51 49                       100 14 15 64 0   6     0   1   51 49                 100
1125796 MA Essex   school 2506660 149   Lawrence 250666000958 1490020 James F Hennessey   Regular School No Elementary PK 02 2017   kindergarten 1 2 96 0   1     0   0   51 49                       100 1 2 96 0   1     0   0   51 49                 100
1129322 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 German Gerena Community School   Regular School No Elementary PK 05 2017   kindergarten 4 17 77 0   1     0   1   52 48                       100 4 17 77 0   1     0   1   52 48                 100
1130574 MA Worcester   school 2513080 343   Winchendon 251308002161 3430040 Memorial   Regular School No Elementary KG 02 2017   kindergarten 90 2 3 0   1     0   4   59 41                       100 90 2 3 0   1     0   4   59 41                 100
1131340 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2017   kindergarten 45 27 4 0   15     0   9   59 41                       100 45 27 4 0   15     0   9   59 41                 100
1133123 MA Middlesex   school 2500545 3503   Lowell Collegiate Charter School (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Elementary KG 06 2017   kindergarten 15 25 40 0   16     0   4   57 43                       100 15 25 40 0   16     0   4   57 43                 100
1365039 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No Elementary KG 02 2020   kindergarten 80 1 11 1   1     0   6   48 52 *                     100.0 80 1 11 1   1     0   6   48 52                 100
1367141 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No Elementary PK 08 2020   kindergarten 43 5 40 0   3     0   9   59 41 *                     100.0 43 5 40 0   3     0   9   59 41                 100
1369270 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2020   kindergarten 39 9 41 0   2     0   9   52 48 *                     100.0 39 9 41 0   2     0   9   52 48                 100
1370978 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 German Gerena Community School   Regular School No Elementary PK 05 2020   kindergarten 9 12 73 0   2     0   4   55 45 *                     100.0 9 12 73 0   2     0   4   55 45                 100
1372743 MA Middlesex   school 2500065 456   Lowell Community Charter Public (District) 250006501585 4560050 Lowell Community Charter Public School   Regular School Yes Elementary PK 08 2020   kindergarten 7 28 37 0   20     0   8   48 51 *                     100.0 7 28 37 0   20     0   8   48 51                 100
1673408 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton - Edgar B Davis   Regular School No Elementary KG 08 2021   kindergarten 9 72 12 0   0     0   7   46 54 *                     100.0 9 72 12 0   0     0   7   46 54                 100
1673429 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Brockton - Louis F Angelo Elementary   Regular School No Elementary KG 05 2021   kindergarten 17 42 31 0   2     0   8   57 43 *                     100.0 17 42 31 0   2     0   8   57 43                 100
1673937 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Cohasset - Joseph Osgood   Regular School No Elementary PK 02 2021   kindergarten 95 0 2 1   0     0   2   54 46 *                     100.0 95 0 2 1   0     0   2   54 46                 100
1674352 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Fall River - Carlton M. Viveiros Elementary School   Regular School No Elementary KG 05 2021   kindergarten 44 5 32 0   4     0   15   50 50 *                     100.0 44 5 32 0   4     0   15   50 50                 100
1674767 MA Worcester   school 2505370 110   Grafton 250537000787 1100025 Grafton - North Grafton Elementary   Regular School No Elementary PK 01 2021   kindergarten 77 4 6 0   13     0   0   57 43 *                     100.0 77 4 6 0   13     0   0   57 43                 100
1676187 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Methuen - Marsh Grammar School   Regular School No Elementary PK 08 2021   kindergarten 49 5 38 0   4     0   4   55 45 *                     100.0 49 5 38 0   4     0   4   55 45                 100
1677515 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 Revere - A. C. Whelan Elementary School   Regular School No Elementary KG 05 2021   kindergarten 39 2 55 1   3     0   0   54 46 *                     100.0 39 2 55 1   3     0   0   54 46                 100
1679707 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School (District) - Alma del Mar Charter School   Regular School Yes Elementary KG 08 2021   kindergarten 20 17 56 1   0     0   6   45 55 *                     100.0 20 17 56 1   0     0   6   45 55                 100
1680967 MA Middlesex   school 2508790 735   North Middlesex 250879002281 7350035 North Middlesex - Varnum Brook   Regular School No Elementary KG 04 2021   kindergarten 87 6 3 0   3     0   1   47 53 *                     100.0 87 6 3 0   3     0   1   47 53                 100
1681206 MA Worcester   school 2511880 775   Wachusett 251188002693 7750005 Wachusett - Naquag Elementary School   Regular School No Elementary KG 02 2021   kindergarten 86 0 6 0   3     0   5   51 49 *                     100.0 86 0 6 0   3     0   5   51 49                 100
2043738 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Salemwood   Regular School No Elementary KG 08 2019   kindergarten 23 20 42 0   14     0   1   46 54                       100.0 23 20 42 0   14     0   1   46 54                 100
2044200 MA Middlesex   school 2508340 198   Natick 250834001291 1980005 Bennett-Hemenway   Regular School No Elementary KG 04 2019   kindergarten 67 3 7 0   15     0   8   51 49                       100.0 67 3 7 0   15     0   8   51 49                 100
2044363 MA Bristol   school 2508430 201   New Bedford 250843001320 2010123 Casimir Pulaski   Regular School No Elementary PK 05 2019   kindergarten 66 5 21 1   3     0   4   55 45                       100.0 66 5 21 1   3     0   4   55 45                 100
2047392 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Roosevelt   Regular School No Elementary PK 06 2019   kindergarten 33 23 34 0   4     0   6   40 60                       100.0 33 23 34 0   4     0   6   40 60                 100
2049272 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Elementary KG 08 2019   kindergarten 17 19 32 0   27     0   5   45 55                       100.0 17 19 32 0   27     0   5   45 55                 100
2230947 MA Hampden   school 2503660 61   Chicopee 250366000492 610015 Chicopee: Bowe   Regular School No Elementary PK 05 2018   kindergarten 29 6 61 0   0     0   4   54 46                       100.0 29 6 61 0   0     0   4   54 46                 100
2231253 MA Middlesex   school 2504320 79   Dracut 250432000583 790020 Dracut: Joseph A Campbell Elementary   Regular School No Elementary PK 05 2018   kindergarten 89 1 4 0   2     0   4   57 43                       100.0 89 1 4 0   2     0   4   57 43                 100
2231546 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Fall River: Mary Fonseca Elementary School   Regular School No Elementary PK 05 2018   kindergarten 31 9 43 1   3     1   12   54 46                       100.0 31 9 43 1   3     1   12   54 46                 100
2231554 MA Bristol   school 2504830 95   Fall River 250483002656 950013 Fall River: Letourneau Elementary School   Regular School No Elementary PK 05 2018   kindergarten 48 4 34 0   2     0   12   53 47                       100.0 48 4 34 0   2     0   12   53 47                 100
2236482 MA Bristol   school 2511520 293   Taunton 251152002697 2930015 Taunton: Mulcahey Elementary School   Regular School No Elementary KG 04 2018   kindergarten 61 14 20 0   1     0   4   49 51                       100.0 61 14 20 0   1     0   4   49 51                 100
744640 MA Middlesex   school 2508790 735   North Middlesex 250879002281 7350035 Varnum Brook   Regular School No 1 KG 04 2015   kindergarten 93 0 3 0   1     0   4   58 43                       101 93 0 3 0   1     0   4   58 43                 101
935225 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No 1 KG 06 2016   kindergarten 95 0 2 0   4     0   0   56 45                       101 95 0 2 0   4     0   0   56 45                 101
937040 MA Bristol   school 2508430 201   New Bedford 250843001327 2010078 Hayden/McFadden   Regular School No 1 PK 05 2016   kindergarten 29 10 54 0   0     0   8   44 57                       101 29 10 54 0   0     0   8   44 57                 101
938635 MA Hampden   school 2511130 281   Springfield 251113001804 2810080 Frederick Harris   Regular School No 1 PK 05 2016   kindergarten 16 17 63 0   4     0   1   46 55                       101 16 17 63 0   4     0   1   46 55                 101
939777 MA Worcester   school 2513080 343   Winchendon 251308002161 3430040 Memorial   Regular School No 1 KG 02 2016   kindergarten 95 1 2 0   1     0   2   59 42                       101 95 1 2 0   1     0   2   59 42                 101
941464 MA Middlesex   school 2508790 735   North Middlesex 250879002281 7350035 Varnum Brook   Regular School No 1 KG 04 2016   kindergarten 87 3 7 1   0     0   3   58 43                       101 87 3 7 1   0     0   3   58 43                 101
1128933 MA Middlesex   school 2510890 274   Somerville 251089002561 2740005 Capuano Early Childhood Center   Regular School No Elementary PK KG 2017   kindergarten 26 4 59 0   7     0   5   63 38                       101 26 4 59 0   7     0   5   63 38                 101
1129665 MA Bristol   school 2511520 293   Taunton 251152002697 2930015 Mulcahey Elementary School   Regular School No Elementary KG 04 2017   kindergarten 63 18 15 0   1     0   4   54 47                       101 63 18 15 0   1     0   4   54 47                 101
1131991 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No Elementary KG 03 2017   kindergarten 72 10 5 6   1     1   6   57 44                       101 72 10 5 6   1     1   6   57 44                 101
1132101 MA Plymouth   school 2505070 665   Freetown-Lakeville 250507002739 6650002 Assawompset Elementary School   Regular School No Elementary KG 03 2017   kindergarten 96 0 0 1   1     0   3   53 48                       101 96 0 0 1   1     0   3   53 48                 101
1367079 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2020   kindergarten 17 12 66 0   5     0   1   43 58 *                     101.0 17 12 66 0   5     0   1   43 58                 101
1368617 MA Essex   school 2507140 164   Lynnfield 250714001089 1640010 Huckleberry Hill   Regular School No Elementary KG 04 2020   kindergarten 77 4 7 0   8     0   5   45 56 *                     101.0 77 4 7 0   8     0   5   45 56                 101
1368635 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2020   kindergarten 26 12 11 0   39     0   13   58 43 *                     101.0 26 12 11 0   39     0   13   58 43                 101
1368813 MA Middlesex   school 2507500 174   Maynard 250750001152 1740010 Green Meadow   Regular School No Elementary PK 03 2020   kindergarten 81 1 12 0   3     0   4   55 46 *                     101.0 81 1 12 0   3     0   4   55 46                 101
1369191 MA Norfolk   school 2508370 199   Needham 250837000306 1990050 Newman Elementary   Regular School No Elementary PK 05 2020   kindergarten 70 3 6 0   12     0   10   58 43 *                     101.0 70 3 6 0   12     0   10   58 43                 101
1371670 MA Worcester   school 2512600 321   Westborough 251260002056 3210005 J Harding Armstrong   Regular School No Elementary KG 03 2020   kindergarten 50 3 8 0   34     0   6   59 42 *                     101.0 50 3 8 0   34     0   6   59 42                 101
1673444 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Brockton - Downey   Regular School No Elementary KG 05 2021   kindergarten 16 64 16 0   0     0   5   52 49 *                     101.0 16 64 16 0   0     0   5   52 49                 101
1676848 MA Bristol   school 2508730 212   North Attleborough 250873001404 2120013 North Attleborough - Joseph W Martin Jr Elementary   Regular School No Elementary KG 05 2021   kindergarten 83 4 5 0   2     0   7   56 45 *                     101.0 83 4 5 0   2     0   7   56 45                 101
1677372 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Quincy - Clifford H Marshall Elementary   Regular School No Elementary KG 04 2021   kindergarten 26 8 13 1   48     0   5   50 51 *                     101.0 26 8 13 1   48     0   5   50 51                 101
1678642 MA Middlesex   school 2511910 305   Wakefield 251191001943 3050015 Wakefield - Woodville School   Regular School No Elementary KG 04 2021   kindergarten 76 3 11 0   7     0   4   48 53 *                     101.0 76 3 11 0   7     0   4   48 53                 101
2039963 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2019   kindergarten 77 0 4 0   7     0   13   54 47                       101.0 77 0 4 0   7     0   13   54 47                 101
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
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
2044263 MA Norfolk   school 2508370 199   Needham 250837000306 1990050 Newman Elementary   Regular School No Elementary PK 05 2019   kindergarten 84 1 4 0   6     0   6   53 48                       101.0 84 1 4 0   6     0   6   53 48                 101
2048128 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000397 6100010 Meetinghouse School   Regular School No Elementary KG 01 2019   kindergarten 93 0 5 0   1     0   2   53 48                       101.0 93 0 5 0   1     0   2   53 48                 101
2229458 MA Suffolk   school 2502790 35   Boston 250279000214 350052 Boston: Charles Sumner   Regular School No Elementary PK 05 2018   kindergarten 22 17 55 0   3     0   4   55 46                       101.0 22 17 55 0   3     0   4   55 46                 101
2230943 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Chicopee: Belcher   Regular School No Elementary KG 02 2018   kindergarten 49 8 40 0   2     0   2   56 45                       101.0 49 8 40 0   2     0   2   56 45                 101
2233372 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Malden: Ferryway   Regular School No Elementary KG 08 2018   kindergarten 25 18 27 0   28     0   3   52 49                       101.0 25 18 27 0   28     0   3   52 49                 101

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