Data source: Big Local News · About: Big Local

6,747 rows where grade = "kindergarten" and state = "MA" sorted by total 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
1366552 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Byam School   Regular School No Elementary KG 04 2020   kindergarten 76 1 7 0   12     0   3   54 45 *                     99.0 76 1 7 0   12     0   3   54 45                 99
1368120 MA Worcester   school 2506780 153   Leominster 250678002637 1530010 Frances Drake School   Regular School No Elementary KG 05 2020   kindergarten 36 10 44 0   5     0   4   53 46 *                     99.0 36 10 44 0   5     0   4   53 46                 99
1370267 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2020   kindergarten 34 2 53 0   7     0   3   59 40 *                     99.0 34 2 53 0   7     0   3   59 40                 99
1371268 MA Bristol   school 2511520 293   Taunton 251152002697 2930015 Mulcahey Elementary School   Regular School No Elementary PK 04 2020   kindergarten 52 19 22 0   1     0   5   50 49 *                     99.0 52 19 22 0   1     0   5   50 49                 99
1371771 MA Middlesex   school 2512660 326   Westford 251266002078 3260015 Nabnasset   Regular School No Elementary KG 02 2020   kindergarten 79 1 0 0   16     0   3   50 49 *                     99.0 79 1 0 0   16     0   3   50 49                 99
1679074 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Westport - Alice A Macomber   Regular School No Elementary PK 02 2021   kindergarten 91 1 6 0   0     0   1   47 52 *                     99.0 91 1 6 0   0     0   1   47 52                 99
2041392 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No Elementary KG 08 2019   kindergarten 44 4 4 0   38     0   9   52 47                       99.0 44 4 4 0   38     0   9   52 47                 99
2043361 MA Middlesex   school 2507020 160   Lowell 250702000067 1600002 Dr Gertrude Bailey   Regular School No Elementary PK 04 2019   kindergarten 24 8 19 0   45     0   3   51 48                       99.0 24 8 19 0   45     0   3   51 48                 99
2043427 MA Middlesex   school 2507020 160   Lowell 250702001048 1600050 John J Shaughnessy   Regular School No Elementary PK 04 2019   kindergarten 27 7 39 0   25     0   1   45 54                       99.0 27 7 39 0   25     0   1   45 54                 99
2044020 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No Elementary PK 08 2019   kindergarten 50 4 37 0   5     0   3   48 51                       99.0 50 4 37 0   5     0   3   48 51                 99
2046225 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No Elementary PK 06 2019   kindergarten 90 1 3 0   1     0   4   53 46                       99.0 90 1 3 0   1     0   4   53 46                 99
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
2048146 MA Worcester   school 2502160 615   Athol-Royalston 250216000080 6150020 Athol Community Elementary School   Regular School No Elementary PK 04 2019   kindergarten 82 3 10 0   1     0   3   46 53                       99.0 82 3 10 0   1     0   3   46 53                 99
2235052 MA Plymouth   school 2509720 239   Plymouth 250972001547 2390046 Plymouth: South Elementary   Regular School No Elementary KG 05 2018   kindergarten 87 0 6 0   0     0   6   55 44                       99.0 87 0 6 0   0     0   6   55 44                 99
2237108 MA Middlesex   school 2512660 326   Westford 251266001740 3260055 Westford: Rita E. Miller Elementary School   Regular School No Elementary KG 02 2018   kindergarten 58 1 4 0   33     0   3   49 50                       99.0 58 1 4 0   33     0   3   49 50                 99
2239939 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell (District): Collegiate Charter School of Lowell   Regular School Yes Elementary KG 07 2018   kindergarten 13 18 32 0   32     0   4   55 44                       99.0 13 18 32 0   32     0   4   55 44                 99
738575 MA Essex   school 2505970 128   Haverhill 250597000851 1280020 Crowell   Regular School No 1 KG KG 2015   kindergarten 57 2 38 0   1     0   1   50 49                       99 57 2 38 0   1     0   1   50 49                 99
739240 MA Middlesex   school 2507020 160   Lowell 250702000477 1600010 Joseph McAvinnue   Regular School No 1 PK 04 2015   kindergarten 33 4 45 0   14     0   3   53 46                       99 33 4 45 0   14     0   3   53 46                 99
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
744192 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No 1 KG 03 2015   kindergarten 79 4 3 2   1     0   10   51 48                       99 79 4 3 2   1     0   10   51 48                 99
932762 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Hill-Roberts Elementary School   Regular School No 1 KG 04 2016   kindergarten 75 5 5 1   5     0   8   56 43                       99 75 5 5 1   5     0   8   56 43                 99
934631 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No 1 PK 01 2016   kindergarten 90 1 5 0   2     0   1   54 45                       99 90 1 5 0   2     0   1   54 45                 99
935736 MA Essex   school 2506660 149   Lawrence 250666002651 1490001 Rollins Early Childhood Center   Regular School No 1 PK KG 2016   kindergarten 6 0 92 0   1     0   0   54 45                       99 6 0 92 0   1     0   0   54 45                 99
936227 MA Worcester   school 2507080 162   Lunenburg 250708001957 1620010 Lunenburg Primary School   Regular School No 1 PK 03 2016   kindergarten 86 1 6 0   4     0   2   55 44                       99 86 1 6 0   4     0   2   55 44                 99
936308 MA Essex   school 2507110 163   Lynn 250711001075 1630060 Ingalls   Regular School No 1 KG 05 2016   kindergarten 11 7 54 0   16     0   11   41 58                       99 11 7 54 0   16     0   11   41 58                 99
936414 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No 1 KG 08 2016   kindergarten 27 24 19 1   20     0   8   50 49                       99 27 24 19 1   20     0   8   50 49                 99
937034 MA Bristol   school 2508430 201   New Bedford 250843001323 2010075 Ellen R Hathaway   Regular School No 1 KG 05 2016   kindergarten 27 11 55 1   2     0   3   54 45                       99 27 11 55 1   2     0   3   54 45                 99
939214 MA Middlesex   school 2512000 308   Waltham 251200001973 3080005 William F. Stanley Elementary School   Regular School No 1 PK 05 2016   kindergarten 28 10 49 0   7     0   5   60 39                       99 28 10 49 0   7     0   5   60 39                 99
1125769 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No Elementary KG 04 2017   kindergarten 1 1 96 0   0     0   1   51 48                       99 1 1 96 0   0     0   1   51 48                 99
1366149 MA Plymouth   school 2503090 44   Brockton 250309002649 440002 Mary E. Baker School   Regular School No Elementary KG 05 2020   kindergarten 29 48 16 0   2     1   2   54 44 *                     98.0 29 48 16 0   2     1   2   54 44                 98
1366856 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No Elementary PK 01 2020   kindergarten 86 1 9 0   0     0   2   49 49 *                     98.0 86 1 9 0   0     0   2   49 49                 98
1369713 MA Bristol   school 2509000 218   Norton 250900001449 2180015 J C Solmonese   Regular School No Elementary PK 03 2020   kindergarten 91 0 3 0   0     0   4   47 51 *                     98.0 91 0 3 0   0     0   4   47 51                 98
1371234 MA Bristol   school 2511460 292   Swansea 251146001892 2920015 Gardner   Regular School No Elementary KG 02 2020   kindergarten 94 1 1 1   0     0   1   52 46 *                     98.0 94 1 1 1   0     0   1   52 46                 98
1372124 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2020   kindergarten 26 13 45 0   8     0   6   59 39 *                     98.0 26 13 45 0   8     0   6   59 39                 98
1372318 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Roosevelt   Regular School No Elementary PK 06 2020   kindergarten 32 22 31 1   4     0   8   54 44 *                     98.0 32 22 31 1   4     0   8   54 44                 98
1673417 MA Plymouth   school 2503090 44   Brockton 250309000396 440045 Brockton - Hancock   Regular School No Elementary KG 05 2021   kindergarten 26 50 15 0   3     0   4   48 50 *                     98.0 26 50 15 0   3     0   4   48 50                 98
1673753 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver - Carver Elementary School   Regular School No Elementary PK 05 2021   kindergarten 94 2 1 0   1     0   0   52 46 *                     98.0 94 2 1 0   1     0   0   52 46                 98
1676251 MA Essex   school 2507830 184   Middleton 250783002588 1840003 Middleton - Fuller Meadow   Regular School No Elementary KG 02 2021   kindergarten 80 1 7 2   6     0   2   55 43 *                     98.0 80 1 7 2   6     0   2   55 43                 98
1677287 MA Plymouth   school 2509720 239   Plymouth 250972001542 2390012 Plymouth - Indian Brook   Regular School No Elementary KG 05 2021   kindergarten 88 0 5 0   0     0   5   48 50 *                     98.0 88 0 5 0   0     0   5   48 50                 98
1678604 MA Middlesex   school 2511760 301   Tyngsborough 251176001714 3010020 Tyngsborough - Tyngsborough Elementary   Regular School No Elementary PK 05 2021   kindergarten 72 3 6 0   13     0   4   49 49 *                     98.0 72 3 6 0   13     0   4   49 49                 98
1680524 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002427 6500005 Dighton-Rehoboth - Dighton Elementary   Regular School No Elementary PK 04 2021   kindergarten 81 3 8 0   1     0   5   51 47 *                     98.0 81 3 8 0   1     0   5   51 47                 98
2041216 MA Plymouth   school 2503090 44   Brockton 250309002649 440002 Mary E. Baker School   Regular School No Elementary KG 05 2019   kindergarten 28 50 11 0   3     0   6   50 48                       98.0 28 50 11 0   3     0   6   50 48                 98
2043054 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No Elementary KG 04 2019   kindergarten 5 0 93 0   0     0   0   54 44                       98.0 5 0 93 0   0     0   0   54 44                 98
2047051 MA Middlesex   school 2513050 342   Wilmington 251305000802 3420005 Boutwell   Regular School No Elementary PK KG 2019   kindergarten 84 1 2 0   6     0   5   52 46                       98.0 84 1 2 0   6     0   5   52 46                 98
2231952 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Georgetown: Penn Brook   Regular School No Elementary KG 06 2018   kindergarten 93 1 1 0   2     0   1   52 46                       98.0 93 1 1 0   2     0   1   52 46                 98
2237781 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Worcester: Roosevelt   Regular School No Elementary PK 06 2018   kindergarten 38 14 33 0   7     1   5   50 48                       98.0 38 14 33 0   7     1   5   50 48                 98
737099 MA Plymouth   school 2503090 44   Brockton 250309000396 440045 Hancock   Regular School No 1 KG 05 2015   kindergarten 43 36 10 0   3     0   6   45 53                       98 43 36 10 0   3     0   6   45 53                 98
738915 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Robert Frost   Regular School No 1 KG 04 2015   kindergarten 18 1 78 0   1     0   0   42 56                       98 18 1 78 0   1     0   0   42 56                 98
739043 MA Worcester   school 2506720 151   Leicester 250672000974 1510010 Leicester Primary School   Regular School No 1 PK 02 2015   kindergarten 85 3 4 2   3     0   1   50 48                       98 85 3 4 2   3     0   1   50 48                 98
739262 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No 1 PK 04 2015   kindergarten 12 6 31 0   46     0   3   44 54                       98 12 6 31 0   46     0   3   44 54                 98
739587 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No 1 KG 08 2015   kindergarten 39 18 24 0   14     0   3   52 46                       98 39 18 24 0   14     0   3   52 46                 98
740082 MA Middlesex   school 2508340 198   Natick 250834001301 1980043 Memorial   Regular School No 1 KG 04 2015   kindergarten 91 0 1 0   1     0   5   57 41                       98 91 0 1 0   1     0   5   57 41                 98
740660 MA Bristol   school 2509000 218   Norton 250900001449 2180015 J C Solmonese   Regular School No 1 KG 03 2015   kindergarten 88 2 2 1   2     0   3   50 48                       98 88 2 2 1   2     0   3   50 48                 98
741234 MA Suffolk   school 2510050 248   Revere 251005001633 2480035 William McKinley   Regular School No 1 KG 05 2015   kindergarten 33 2 59 0   3     0   1   44 54                       98 33 2 59 0   3     0   1   44 54                 98
743685 MA Middlesex   school 2500065 456   Lowell Community Charter Public (District) 250006501585 4560050 Lowell Community Charter Public School   Regular School Yes 1 PK 07 2015   kindergarten 5 26 45 0   19     0   3   56 42                       98 5 26 45 0   19     0   3   56 42                 98
933848 MA Essex   school 2502880 38   Boxford 250288000357 380005 Harry Lee Cole   Regular School No 1 PK 02 2016   kindergarten 88 0 5 1   3     0   1   50 48                       98 88 0 5 1   3     0   1   50 48                 98
934884 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No 1 PK 05 2016   kindergarten 66 5 13 0   5     0   9   53 45                       98 66 5 13 0   5     0   9   53 45                 98
935892 MA Worcester   school 2506720 151   Leicester 250672000974 1510010 Leicester Primary School   Regular School No 1 PK 02 2016   kindergarten 82 8 3 0   5     0   0   64 34                       98 82 8 3 0   5     0   0   64 34                 98
936969 MA Norfolk   school 2508370 199   Needham 250837000306 1990050 Newman Elementary   Regular School No 1 PK 05 2016   kindergarten 72 3 4 0   11     0   8   50 48                       98 72 3 4 0   11     0   8   50 48                 98
938658 MA Hampden   school 2511130 281   Springfield 251113001810 2810100 Indian Orchard Elementary   Regular School No 1 PK 05 2016   kindergarten 15 17 63 0   0     0   3   43 55                       98 15 17 63 0   0     0   3   43 55                 98
938747 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 German Gerena Community School   Regular School No 1 PK 05 2016   kindergarten 3 17 75 0   2     0   1   48 50                       98 3 17 75 0   2     0   1   48 50                 98
941102 MA Bristol   school 2505070 665   Freetown-Lakeville 250507002735 6650001 Freetown Elementary School   Regular School No 1 PK 03 2016   kindergarten 92 2 3 0   1     0   0   48 50                       98 92 2 3 0   1     0   0   48 50                 98
1124128 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Belcher   Regular School No Elementary KG 02 2017   kindergarten 52 9 31 0   0     0   6   46 52                       98 52 9 31 0   0     0   6   46 52                 98
1124721 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No Elementary KG 05 2017   kindergarten 49 5 34 0   2     0   8   55 43                       98 49 5 34 0   2     0   8   55 43                 98
1126551 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2017   kindergarten 29 22 23 0   22     0   2   45 53                       98 29 22 23 0   22     0   2   45 53                 98
1130750 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary PK 06 2017   kindergarten 10 8 73 0   6     0   1   45 53                       98 10 8 73 0   6     0   1   45 53                 98
1132359 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No Elementary PK 04 2017   kindergarten 82 5 6 0   0     0   5   46 52                       98 82 5 6 0   0     0   5   46 52                 98
1366195 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No Elementary KG 05 2020   kindergarten 8 63 15 0   9     0   2   57 40 *                     97.0 8 63 15 0   9     0   2   57 40                 97
1367970 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No Elementary KG 04 2020   kindergarten 2 0 95 0   0     0   0   50 42 5                     97.0 2 0 95 0   0     0   0   50 42 5               97
1368085 MA Worcester   school 2506720 151   Leicester 250672000971 1510005 Leicester Elementary   Regular School No Elementary KG 04 2020   kindergarten 74 7 9 0   5     0   2   48 49 *                     97.0 74 7 9 0   5     0   2   48 49                 97
1368672 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Salemwood   Regular School No Elementary KG 08 2020   kindergarten 28 18 41 0   10     0   0   51 46 *                     97.0 28 18 41 0   10     0   0   51 46                 97
1369289 MA Bristol   school 2508430 201   New Bedford 250843001320 2010123 Casimir Pulaski   Regular School No Elementary PK 05 2020   kindergarten 72 1 14 0   1     0   9   50 47 *                     97.0 72 1 14 0   1     0   9   50 47                 97
1371551 MA Middlesex   school 2512180 314   Watertown 251218002001 3140020 Hosmer   Regular School No Elementary PK 05 2020   kindergarten 67 8 5 0   4     1   12   55 42 *                     97.0 67 8 5 0   4     1   12   55 42                 97
1673382 MA Plymouth   school 2503090 44   Brockton 250309002649 440002 Brockton - Mary E. Baker School   Regular School No Elementary KG 05 2021   kindergarten 18 60 14 0   0     1   4   50 47 *                     97.0 18 60 14 0   0     1   4   50 47                 97
1674106 MA Middlesex   school 2504320 79   Dracut 250432000583 790020 Dracut - Joseph A Campbell Elementary   Regular School No Elementary PK 05 2021   kindergarten 75 8 10 0   3     0   1   48 49 *                     97.0 75 8 10 0   3     0   1   48 49                 97
1675876 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Malden - Beebe   Regular School No Elementary KG 08 2021   kindergarten 39 7 5 0   43     0   3   46 51 *                     97.0 39 7 5 0   43     0   3   46 51                 97
1677305 MA Plymouth   school 2509720 239   Plymouth 250972001547 2390046 Plymouth - South Elementary   Regular School No Elementary KG 05 2021   kindergarten 82 3 7 0   1     0   4   50 47 *                     97.0 82 3 7 0   1     0   4   50 47                 97
2040071 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary PK 02 2019   kindergarten 81 1 11 0   2     0   2   53 44                       97.0 81 1 11 0   2     0   2   53 44                 97
2043588 MA Essex   school 2507110 163   Lynn 250711001070 1630045 E J Harrington   Regular School No Elementary PK 05 2019   kindergarten 12 10 64 0   7     0   4   52 45                       97.0 12 10 64 0   7     0   4   52 45                 97
2043863 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2019   kindergarten 60 3 15 3   1     0   15   52 45                       97.0 60 3 15 3   1     0   15   52 45                 97
2044238 MA Norfolk   school 2508370 199   Needham 250837001306 1990005 Broadmeadow   Regular School No Elementary KG 05 2019   kindergarten 66 3 5 0   15     0   8   47 50                       97.0 66 3 5 0   15     0   8   47 50                 97
2045131 MA Plymouth   school 2509720 239   Plymouth 250972001547 2390046 South Elementary   Regular School No Elementary KG 05 2019   kindergarten 81 5 4 0   1     0   6   46 51                       97.0 81 5 4 0   1     0   6   46 51                 97
2046753 MA Worcester   school 2512600 321   Westborough 251260002058 3210025 Elsie A Hastings Elementary   Regular School No Elementary PK 03 2019   kindergarten 39 3 10 1   42     0   2   48 49                       97.0 39 3 10 1   42     0   2   48 49                 97
2048592 MA Worcester   school 2507680 710   Mendon-Upton 250768001277 7100001 Memorial School   Regular School No Elementary PK 04 2019   kindergarten 83 0 7 0   4     0   3   45 52                       97.0 83 0 7 0   4     0   3   45 52                 97
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
2231453 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Everett: Madeline English School   Regular School No Elementary KG 08 2018   kindergarten 23 10 56 0   4     0   4   56 41                       97.0 23 10 56 0   4     0   4   56 41                 97
2232201 MA Essex   school 2505970 128   Haverhill 250597000851 1280020 Haverhill: Crowell   Regular School No Elementary KG KG 2018   kindergarten 40 3 50 1   2     0   1   50 47                       97.0 40 3 50 1   2     0   1   50 47                 97
2233030 MA Middlesex   school 2507020 160   Lowell 250702001045 1600040 Lowell: Peter W Reilly   Regular School No Elementary KG 04 2018   kindergarten 44 2 38 0   9     0   4   50 47                       97.0 44 2 38 0   9     0   4   50 47                 97
2233871 MA Norfolk   school 2507980 189   Milton 250798001259 1890005 Milton: Collicot   Regular School No Elementary PK 05 2018   kindergarten 83 1 3 0   9     0   1   55 42                       97.0 83 1 3 0   9     0   1   55 42                 97
2234146 MA Bristol   school 2508430 201   New Bedford 250843001320 2010123 New Bedford: Casimir Pulaski   Regular School No Elementary PK 05 2018   kindergarten 71 7 14 0   1     0   4   55 42                       97.0 71 7 14 0   1     0   4   55 42                 97
2234515 MA Bristol   school 2508730 212   North Attleborough 250873001404 2120013 North Attleborough: Joseph W Martin Jr Elementary   Regular School No Elementary KG 05 2018   kindergarten 79 2 2 1   7     0   6   51 46                       97.0 79 2 2 1   7     0   6   51 46                 97
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
738139 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No 1 KG 04 2015   kindergarten 77 6 8 1   2     0   3   53 44                       97 77 6 8 1   2     0   3   53 44                 97
739230 MA Middlesex   school 2507020 160   Lowell 250702000067 1600002 Dr Gertrude Bailey   Regular School No 1 PK 04 2015   kindergarten 38 3 23 0   29     0   4   53 44                       97 38 3 23 0   29     0   4   53 44                 97
739442 MA Essex   school 2507110 163   Lynn 250711001070 1630045 E J Harrington   Regular School No 1 PK 05 2015   kindergarten 7 13 70 0   5     0   2   42 55                       97 7 13 70 0   5     0   2   42 55                 97
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
745003 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000199 7800025 Maquan Elementary   Regular School No 1 PK 02 2015   kindergarten 91 0 3 0   1     0   2   53 44                       97 91 0 3 0   1     0   2   53 44                 97
932957 MA Essex   school 2502640 30   Beverly 250264000168 300015 Cove Elementary   Regular School No 1 KG 05 2016   kindergarten 80 0 9 0   0     0   8   55 42                       97 80 0 9 0   0     0   8   55 42                 97
933932 MA Plymouth   school 2503090 44   Brockton 250309002649 440002 Mary E. Baker School   Regular School No 1 KG 05 2016   kindergarten 31 43 12 0   6     0   5   45 52                       97 31 43 12 0   6     0   5   45 52                 97
933980 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No 1 KG 05 2016   kindergarten 25 41 13 1   14     0   3   53 44                       97 25 41 13 1   14     0   3   53 44                 97

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