Data source: Big Local News · About: Big Local

6,747 rows where grade = "kindergarten" and state = "MA" sorted by ccd_school_low_grade 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
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
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
735658 MA Plymouth   school 2501650 1   Abington 250165002727 10002 Center Elementary School   Regular School No 1 PK KG 2015   kindergarten 138 2 3 2   3     0   0   80 68                       148 138 2 3 2   3     0   0   80 68                 148
735673 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No 1 PK 04 2015   kindergarten 92 0 4 0   0     0   0   45 51                       96 92 0 4 0   0     0   0   45 51                 96
735714 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No 1 PK 04 2015   kindergarten 53 24 2 1   0     0   7   45 42                       87 53 24 2 1   0     0   7   45 42                 87
735720 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No 1 PK 04 2015   kindergarten 67 4 5 1   3     0   3   45 38                       83 67 4 5 1   3     0   3   45 38                 83
735735 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No 1 PK 06 2015   kindergarten 18 0 12 0   7     0   3   19 21                       40 18 0 12 0   7     0   3   19 21                 40
735769 MA Essex   school 2501950 9   Andover 250195002366 90005 Shawsheen School   Regular School No 1 PK 02 2015   kindergarten 52 3 1 0   8     0   6   41 29                       70 52 3 1 0   8     0   6   41 29                 70
735785 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No 1 PK 05 2015   kindergarten 54 2 2 0   9     0   2   33 36                       69 54 2 2 0   9     0   2   33 36                 69
735936 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No 1 PK 06 2015   kindergarten 34 6 3 0   0     0   0   18 25                       43 34 6 3 0   0     0   0   18 25                 43
735955 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No 1 PK 03 2015   kindergarten 69 7 8 0   0     0   1   42 43                       85 69 7 8 0   0     0   1   42 43                 85
735992 MA Hampshire   school 2502430 24   Belchertown 250243000136 240005 Cold Spring   Regular School No 1 PK KG 2015   kindergarten 117 2 10 0   1     0   6   76 60                       136 117 2 10 0   1     0   6   76 60                 136
736050 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No 1 PK 04 2015   kindergarten 89 3 0 0   13     0   10   63 52                       115 89 3 0 0   13     0   10   63 52                 115
736064 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No 1 PK 04 2015   kindergarten 75 0 1 0   0     0   2   44 34                       78 75 0 1 0   0     0   2   44 34                 78
736074 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No 1 PK 05 2015   kindergarten 18 0 2 0   0     0   0   14 6                       20 18 0 2 0   0     0   0   14 6                 20
736087 MA Essex   school 2502640 30   Beverly 250264000168 300015 Cove Elementary   Regular School No 1 PK 05 2015   kindergarten 90 5 8 0   1     0   2   53 53                       106 90 5 8 0   1     0   2   53 53                 106
736168 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Lee Academy   Regular School No 1 PK 01 2015   kindergarten 1 45 24 1   4     0   3   40 38                       78 1 45 24 1   4     0   3   40 38                 78
736171 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Baldwin Early Learning Center   Regular School No 1 PK 01 2015   kindergarten 14 5 18 0   7     0   1   31 14                       45 14 5 18 0   7     0   1   31 14                 45
736183 MA Suffolk   school 2502790 35   Boston 250279002514 350006 ELC - West Zone   Regular School No 1 PK 01 2015   kindergarten 0 9 24 0   4     0   1   17 21                       38 0 9 24 0   4     0   1   17 21                 38
736186 MA Suffolk   school 2502790 35   Boston 250279001115 350008 Dr. Catherine Ellison-Rosa Parks Early Ed School   Regular School No 1 PK 03 2015   kindergarten 0 25 12 0   0     0   1   23 15                       38 0 25 12 0   0     0   1   23 15                 38
736191 MA Suffolk   school 2502790 35   Boston 250279001118 350009 East Boston Early Childhood Center   Regular School No 1 PK 01 2015   kindergarten 9 2 44 0   3     0   0   32 26                       58 9 2 44 0   3     0   0   32 26                 58
736194 MA Suffolk   school 2502790 35   Boston 250279001126 350010 Haynes Early Education Center   Regular School No 1 PK 01 2015   kindergarten 1 37 24 0   2     0   1   34 31                       65 1 37 24 0   2     0   1   34 31                 65
736197 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No 1 PK 08 2015   kindergarten 12 4 7 1   0     0   0   11 13                       24 12 4 7 1   0     0   0   11 13                 24
736207 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No 1 PK 08 2015   kindergarten 6 28 31 0   12     0   2   52 27                       79 6 28 31 0   12     0   2   52 27                 79
736217 MA Suffolk   school 2502790 35   Boston 250279002839 350014 Pauline Agassiz Shaw Elementary School   Regular School No 1 PK KG 2015   kindergarten 0 36 15 0   1     0   2   37 17                       54 0 36 15 0   1     0   2   37 17                 54
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
736223 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No 1 PK 08 2015   kindergarten 25 6 44 0   3     0   2   32 48                       80 25 6 44 0   3     0   2   32 48                 80
736233 MA Suffolk   school 2502790 35   Boston 250279000198 350021 Beethoven   Regular School No 1 PK 03 2015   kindergarten 39 25 23 0   2     0   4   47 46                       93 39 25 23 0   2     0   4   47 46                 93
736243 MA Suffolk   school 2502790 35   Boston 250279000214 350052 Charles Sumner   Regular School No 1 PK 05 2015   kindergarten 21 16 51 0   4     0   4   58 38                       96 21 16 51 0   4     0   4   58 38                 96
736250 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Charles H Taylor   Regular School No 1 PK 05 2015   kindergarten 0 85 17 0   2     0   6   51 59                       110 0 85 17 0   2     0   6   51 59                 110
736257 MA Suffolk   school 2502790 35   Boston 250279000218 350062 Curtis Guild   Regular School No 1 PK 05 2015   kindergarten 10 0 39 0   3     0   0   32 20                       52 10 0 39 0   3     0   0   32 20                 52
736264 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No 1 PK 04 2015   kindergarten 4 0 7 0   0     0   3   8 6                       14 4 0 7 0   0     0   3   8 6                 14
736270 MA Suffolk   school 2502790 35   Boston 250279000220 350072 David A Ellis   Regular School No 1 PK 05 2015   kindergarten 3 31 50 0   1     0   3   41 47                       88 3 31 50 0   1     0   3   41 47                 88
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
736300 MA Suffolk   school 2502790 35   Boston 250279000227 350088 Edward Everett   Regular School No 1 PK 05 2015   kindergarten 2 17 8 0   8     0   2   22 15                       37 2 17 8 0   8     0   2   22 15                 37
736313 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No 1 PK 08 2015   kindergarten 46 4 12 0   5     0   7   44 30                       74 46 4 12 0   5     0   7   44 30                 74
736323 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No 1 PK 05 2015   kindergarten 17 2 14 0   0     0   5   14 24                       38 17 2 14 0   0     0   5   14 24                 38
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
736340 MA Suffolk   school 2502790 35   Boston 250279000241 350122 George H Conley   Regular School No 1 PK 05 2015   kindergarten 4 6 8 0   1     0   0   9 10                       19 4 6 8 0   1     0   0   9 10                 19
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
736360 MA Suffolk   school 2502790 35   Boston 250279000249 350141 Hugh Roe O'Donnell   Regular School No 1 PK 05 2015   kindergarten 2 1 38 0   1     0   1   21 22                       43 2 1 38 0   1     0   1   21 22                 43
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
736381 MA Suffolk   school 2502790 35   Boston 250279000255 350154 James J Chittick   Regular School No 1 PK 05 2015   kindergarten 1 26 8 0   0     0   2   19 18                       37 1 26 8 0   0     0   2   19 18                 37
736388 MA Suffolk   school 2502790 35   Boston 250279000257 350156 James Otis   Regular School No 1 PK 05 2015   kindergarten 13 4 37 0   2     0   1   28 29                       57 13 4 37 0   2     0   1   28 29                 57
736395 MA Suffolk   school 2502790 35   Boston 250279000265 350166 John F Kennedy   Regular School No 1 PK 05 2015   kindergarten 6 11 42 0   1     0   1   17 44                       61 6 11 42 0   1     0   1   17 44                 61
736402 MA Suffolk   school 2502790 35   Boston 250279000268 350167 UP Academy Holland   Regular School No 1 PK 05 2015   kindergarten 2 57 48 0   4     0   1   62 50                       112 2 57 48 0   4     0   1   62 50                 112
736409 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No 1 PK 05 2015   kindergarten 11 11 7 0   0     0   2   20 11                       31 11 11 7 0   0     0   2   20 11                 31
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
736426 MA Suffolk   school 2502790 35   Boston 250279000275 350181 Joseph P Tynan   Regular School No 1 PK 05 2015   kindergarten 11 16 14 0   7     0   5   29 24                       53 11 16 14 0   7     0   5   29 24                 53
736433 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No 1 PK 08 2015   kindergarten 10 1 29 1   0     0   2   26 17                       43 10 1 29 1   0     0   2   26 17                 43
736443 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No 1 PK 08 2015   kindergarten 2 30 12 0   6     0   3   27 26                       53 2 30 12 0   6     0   3   27 26                 53
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
736460 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No 1 PK 08 2015   kindergarten 30 1 5 0   6     0   4   22 24                       46 30 1 5 0   6     0   4   22 24                 46
736470 MA Suffolk   school 2502790 35   Boston 250279000244 350200 Harvard-Kent   Regular School No 1 PK 05 2015   kindergarten 11 15 24 1   21     0   4   41 35                       76 11 15 24 1   21     0   4   41 35                 76
736477 MA Suffolk   school 2502790 35   Boston 250279000283 350215 Manassah E Bradley   Regular School No 1 PK 05 2015   kindergarten 11 0 24 0   0     0   2   16 21                       37 11 0 24 0   0     0   2   16 21                 37
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
736491 MA Suffolk   school 2502790 35   Boston 250279000289 350227 Mather   Regular School No 1 PK 05 2015   kindergarten 7 29 10 0   35     0   8   47 42                       89 7 29 10 0   35     0   8   47 42                 89
736498 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No 1 PK 08 2015   kindergarten 1 35 38 0   1     0   2   39 38                       77 1 35 38 0   1     0   2   39 38                 77
736514 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No 1 PK 05 2015   kindergarten 14 4 4 0   1     0   1   13 11                       24 14 4 4 0   1     0   1   13 11                 24
736521 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No 1 PK 08 2015   kindergarten 10 13 13 1   22     0   3   32 30                       62 10 13 13 1   22     0   3   32 30                 62
736531 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No 1 PK 05 2015   kindergarten 2 9 6 0   1     0   2   5 15                       20 2 9 6 0   1     0   2   5 15                 20
736538 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No 1 PK 08 2015   kindergarten 14 6 5 0   2     0   1   17 11                       28 14 6 5 0   2     0   1   17 11                 28
736548 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No 1 PK 08 2015   kindergarten 3 35 38 0   1     0   0   33 44                       77 3 35 38 0   1     0   0   33 44                 77
736564 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No 1 PK 08 2015   kindergarten 27 1 14 0   0     0   0   24 18                       42 27 1 14 0   0     0   0   24 18                 42
736574 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Patrick J Kennedy   Regular School No 1 PK 05 2015   kindergarten 1 2 38 0   1     0   0   18 24                       42 1 2 38 0   1     0   0   18 24                 42
736581 MA Suffolk   school 2502790 35   Boston 250279000303 350266 Dr. William Henderson Lower   Regular School No 1 PK 04 2015   kindergarten 16 13 13 0   4     0   0   20 26                       46 16 13 13 0   4     0   0   20 26                 46
736587 MA Suffolk   school 2502790 35   Boston 250279000304 350268 Paul A Dever   Regular School No 1 PK 05 2015   kindergarten 2 13 35 0   8     0   2   20 40                       60 2 13 35 0   8     0   2   20 40                 60
736594 MA Suffolk   school 2502790 35   Boston 250279000308 350278 Phineas Bates   Regular School No 1 PK 05 2015   kindergarten 9 11 11 0   2     0   1   20 14                       34 9 11 11 0   2     0   1   20 14                 34
736601 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Josiah Quincy   Regular School No 1 PK 05 2015   kindergarten 15 21 14 0   62     0   2   48 66                       114 15 21 14 0   62     0   2   48 66                 114
736608 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Roger Clap   Regular School No 1 PK 05 2015   kindergarten 16 15 3 1   3     0   1   24 15                       39 16 15 3 1   3     0   1   24 15                 39
736615 MA Suffolk   school 2502790 35   Boston 250279000321 350302 Samuel Adams   Regular School No 1 PK 05 2015   kindergarten 12 1 42 0   1     0   0   30 26                       56 12 1 42 0   1     0   0   30 26                 56
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
736639 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No 1 PK 08 2015   kindergarten 5 3 28 0   2     0   1   17 22                       39 5 3 28 0   2     0   1   17 22                 39
736649 MA Suffolk   school 2502790 35   Boston 250279000332 350328 Thomas J Kenny   Regular School No 1 PK 05 2015   kindergarten 9 9 7 0   15     0   3   16 27                       43 9 9 7 0   15     0   3   16 27                 43
736656 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No 1 PK 08 2015   kindergarten 45 6 11 0   2     0   5   33 36                       69 45 6 11 0   2     0   5   33 36                 69
736666 MA Suffolk   school 2502790 35   Boston 250279000338 350360 William Ellery Channing   Regular School No 1 PK 05 2015   kindergarten 4 17 8 1   0     0   1   18 13                       31 4 17 8 1   0     0   1   18 13                 31
736685 MA Suffolk   school 2502790 35   Boston 250279000337 350366 William E Russell   Regular School No 1 PK 05 2015   kindergarten 1 13 37 1   5     0   1   30 28                       58 1 13 37 1   5     0   1   30 28                 58
736692 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No 1 PK 06 2015   kindergarten 6 41 16 0   0     0   2   38 27                       65 6 41 16 0   0     0   2   38 27                 65
736700 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Winship Elementary   Regular School No 1 PK 05 2015   kindergarten 17 7 20 0   4     0   4   23 29                       52 17 7 20 0   4     0   4   23 29                 52
736707 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No 1 PK 08 2015   kindergarten 13 8 17 0   10     0   1   26 23                       49 13 8 17 0   10     0   1   26 23                 49
736717 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No 1 PK 08 2015   kindergarten 0 45 20 0   1     0   4   41 29                       70 0 45 20 0   1     0   4   41 29                 70
736727 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No 1 PK 08 2015   kindergarten 3 42 19 1   2     0   3   34 36                       70 3 42 19 1   2     0   3   34 36                 70
736743 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   kindergarten 0 18 22 0   0     0   3   27 16                       43 0 18 22 0   0     0   3   27 16                 43
736753 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No 1 PK 08 2015   kindergarten 11 7 6 0   0     0   2   12 14                       26 11 7 6 0   0     0   2   12 14                 26
736766 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No 1 PK 05 2015   kindergarten 1 17 53 0   0     0   1   37 35                       72 1 17 53 0   0     0   1   37 35                 72
736940 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No 1 PK 08 2015   kindergarten 2 4 44 0   0     0   1   25 26                       51 2 4 44 0   0     0   1   25 26                 51
736950 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2015   kindergarten 0 3 3 0   0     0   0   4 2                       6 0 3 3 0   0     0   0   4 2                 6
736964 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No 1 PK 04 2015   kindergarten 84 4 4 1   1     0   2   63 33                       96 84 4 4 1   1     0   2   63 33                 96
736983 MA Essex   school 2502880 38   Boxford 250288000357 380005 Harry Lee Cole   Regular School No 1 PK 02 2015   kindergarten 73 0 2 0   3     0   3   48 33                       81 73 0 2 0   3     0   3   48 33                 81
736991 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No 1 PK 05 2015   kindergarten 29 1 1 0   4     0   1   15 21                       36 29 1 1 0   4     0   1   15 21                 36
737044 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No 1 PK 02 2015   kindergarten 67 0 7 0   1     0   2   34 43                       77 67 0 7 0   1     0   2   34 43                 77
737051 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No 1 PK 06 2015   kindergarten 34 2 0 0   0     0   0   19 17                       36 34 2 0 0   0     0   0   19 17                 36
737105 MA Plymouth   school 2503090 44   Brockton 250309000221 440050 Gilmore School Early Childhood Center   Regular School No 1 PK KG 2015   kindergarten 20 34 19 1   0     0   9   52 31                       83 20 34 19 1   0     0   9   52 31                 83
737177 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No 1 PK 06 2015   kindergarten 36 0 4 0   0     0   2   22 20                       42 36 0 4 0   0     0   2   22 20                 42
737205 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No 1 PK 08 2015   kindergarten 43 2 4 0   6     0   13   36 32                       68 43 2 4 0   6     0   13   36 32                 68
737215 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Heath   Regular School No 1 PK 08 2015   kindergarten 38 2 3 0   12     0   10   30 35                       65 38 2 3 0   12     0   10   30 35                 65
737252 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No 1 PK 08 2015   kindergarten 37 5 10 0   8     0   3   33 30                       63 37 5 10 0   8     0   3   33 30                 63
737302 MA Middlesex   school 2503270 49   Cambridge 250327000435 490005 Maria L. Baldwin   Regular School No 1 PK 05 2015   kindergarten 34 12 7 0   5     0   9   37 30                       67 34 12 7 0   5     0   9   37 30                 67

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