enrollments

Data source: Big Local News · About: Big Local

990 rows where grade = "grade_1", state = "MA" and year = 2015 sorted by white

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 990 ✖

grade ✖

  • grade_1 · 990 ✖
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
736673 736673 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   grade_1 * * * *   *     *   *   2 3                       5                         2 3                 5
737738 737738 MA Norfolk   school 2504050 73   Dedham 250405000460 730005 Early Childhood Center   Regular School No 1 PK 01 2015   grade_1 * * * *   *     *   *   2 1                       3                         2 1                 3
738515 738515 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No 1 PK 06 2015   grade_1 * * * *   *     *   *   1 4                       5                         1 4                 5
739009 739009 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2015   grade_1 * * * *   *     *   *   4 1                       5                         4 1                 5
739315 739315 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No 1 01 07 2015   grade_1 * * * *   *     *   *   2 *                       2                         2                   2
739478 739478 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No 1 01 06 2015   grade_1 * * * *   *     *   *   3 1                       4                         3 1                 4
741325 741325 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No 1 PK 06 2015   grade_1 * * * *   *     *   *   2 3                       5                         2 3                 5
744540 744540 MA Franklin   school 2507990 717   Mohawk Trail 250799000934 7170015 Heath Elementary   Regular School No 1 PK 06 2015   grade_1 * * * *   *     *   *   1 1                       2                         1 1                 2
744702 744702 MA Franklin   school 2509600 750   Pioneer Valley 250960002613 7500007 Pearl E Rhodes Elementary   Regular School No 1 PK 06 2015   grade_1 * * * *   *     *   *   1 4                       5                         1 4                 5
744716 744716 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No 1 PK 06 2015   grade_1 * * * *   *     *   *   2 1                       3                         2 1                 3
744793 744793 MA Berkshire   school 2511040 765   Southern Berkshire 251104001778 7650030 South Egremont   Regular School No 1 KG 01 2015   grade_1 * * * *   *     *   *   * 2                       5                           2                 5
736188 736188 MA Suffolk   school 2502790 35   Boston 250279001115 350008 Dr. Catherine Ellison-Rosa Parks Early Ed School   Regular School No 1 PK 03 2015   grade_1 0 15 16 1   3     0   0   21 14                       35 0 15 16 1   3     0   0   21 14                 35
736252 736252 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Charles H Taylor   Regular School No 1 PK 05 2015   grade_1 0 69 12 2   1     0   4   36 52                       88 0 69 12 2   1     0   4   36 52                 88
736272 736272 MA Suffolk   school 2502790 35   Boston 250279000220 350072 David A Ellis   Regular School No 1 PK 05 2015   grade_1 0 23 39 0   0     0   0   25 37                       62 0 23 39 0   0     0   0   25 37                 62
736500 736500 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No 1 PK 08 2015   grade_1 0 21 36 0   0     0   3   30 30                       60 0 21 36 0   0     0   3   30 30                 60
736719 736719 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No 1 PK 08 2015   grade_1 0 44 19 0   0     0   3   36 30                       66 0 44 19 0   0     0   3   36 30                 66
738720 738720 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No 1 PK 08 2015   grade_1 0 3 54 0   0     0   0   30 27                       57 0 3 54 0   0     0   0   30 27                 57
743407 743407 MA Suffolk   school 2500543 407   Dudley Street Neighborhood Charter School (District) 250054302763 4070405 Dudley Street Neighborhood Charter School   Regular School Yes 1 PK 03 2015   grade_1 0 31 12 1   0     0   0   21 23                       44 0 31 12 1   0     0   0   21 23                 44
743460 743460 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes 1 PK 03 2015   grade_1 0 23 13 0   1     0   1   19 19                       38 0 23 13 0   1     0   1   19 19                 38
743470 743470 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes 1 KG 06 2015   grade_1 0 39 8 1   0     0   0   20 28                       48 0 39 8 1   0     0   0   20 28                 48
743490 743490 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School Roslindale   Regular School Yes 1 KG 08 2015   grade_1 0 44 18 0   1     0   3   35 31                       66 0 44 18 0   1     0   3   35 31                 66
743542 743542 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes 4 PK 12 2015   grade_1 0 16 6 0   0     0   0   14 8                       22 0 16 6 0   0     0   0   14 8                 22
743562 743562 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes 1 PK 08 2015   grade_1 0 0 41 0   0     0   0   23 18                       41 0 0 41 0   0     0   0   23 18                 41
743877 743877 MA Hampden   school 2500089 492   Martin Luther King Jr. Charter School of Excellence (District) 250008902127 4920005 Martin Luther King Jr. Charter School of Excellence   Regular School Yes 1 KG 05 2015   grade_1 0 35 22 0   0     0   5   28 34                       62 0 35 22 0   0     0   5   28 34                 62
736170 736170 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Lee Academy   Regular School No 1 PK 01 2015   grade_1 1 50 16 0   2     0   7   36 40                       76 1 50 16 0   2     0   7   36 40                 76
736185 736185 MA Suffolk   school 2502790 35   Boston 250279002514 350006 ELC - West Zone   Regular School No 1 PK 01 2015   grade_1 1 18 13 0   0     0   1   19 14                       33 1 18 13 0   0     0   1   19 14                 33
736196 736196 MA Suffolk   school 2502790 35   Boston 250279001126 350010 Haynes Early Education Center   Regular School No 1 PK 01 2015   grade_1 1 36 26 1   2     0   4   31 39                       70 1 36 26 1   2     0   4   31 39                 70
736302 736302 MA Suffolk   school 2502790 35   Boston 250279000227 350088 Edward Everett   Regular School No 1 PK 05 2015   grade_1 1 16 13 0   13     0   1   17 27                       44 1 16 13 0   13     0   1   17 27                 44
736308 736308 MA Suffolk   school 2502790 35   Boston 250279000229 350094 Elihu Greenwood Leadership Academy   Regular School No 1 KG 05 2015   grade_1 1 37 19 0   4     0   1   26 36                       62 1 37 19 0   4     0   1   26 36                 62
736375 736375 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No 1 KG 06 2015   grade_1 1 25 46 0   2     0   0   38 36                       74 1 25 46 0   2     0   0   38 36                 74
736383 736383 MA Suffolk   school 2502790 35   Boston 250279000255 350154 James J Chittick   Regular School No 1 PK 05 2015   grade_1 1 34 10 0   0     0   2   26 21                       47 1 34 10 0   0     0   2   26 21                 47
736404 736404 MA Suffolk   school 2502790 35   Boston 250279000268 350167 UP Academy Holland   Regular School No 1 PK 05 2015   grade_1 1 66 51 1   4     0   18   79 62                       141 1 66 51 1   4     0   18   79 62                 141
736421 736421 MA Suffolk   school 2502790 35   Boston 250279000270 350180 John Winthrop   Regular School No 1 PK 05 2015   grade_1 1 33 24 0   1     0   2   34 27                       61 1 33 24 0   1     0   2   34 27                 61
736533 736533 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No 1 PK 05 2015   grade_1 1 14 7 0   0     0   2   15 9                       24 1 14 7 0   0     0   2   15 9                 24
736550 736550 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No 1 PK 08 2015   grade_1 1 30 49 0   2     0   1   42 41                       83 1 30 49 0   2     0   1   42 41                 83
736631 736631 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No 1 PK 08 2015   grade_1 1 11 34 0   0     0   0   25 21                       46 1 11 34 0   0     0   0   25 21                 46
736668 736668 MA Suffolk   school 2502790 35   Boston 250279000338 350360 William Ellery Channing   Regular School No 1 PK 05 2015   grade_1 1 25 12 0   0     0   3   24 17                       41 1 25 12 0   0     0   3   24 17                 41
736745 736745 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   grade_1 1 31 26 0   0     0   0   24 34                       58 1 31 26 0   0     0   0   24 34                 58
736952 736952 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2015   grade_1 1 2 1 0   2     0   0   5 1                       6 1 2 1 0   2     0   0   5 1                 6
741771 741771 MA Hampden   school 2511130 281   Springfield 251113001796 2810025 Brightwood   Regular School No 1 KG 05 2015   grade_1 1 11 62 0   0     0   0   34 40                       74 1 11 62 0   0     0   0   34 40                 74
743482 743482 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway   Regular School Yes 1 PK 03 2015   grade_1 1 1 38 0   0     0   0   26 14                       40 1 1 38 0   0     0   0   26 14                 40
743668 743668 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes 1 KG 08 2015   grade_1 1 0 81 0   0     0   0   46 36                       82 1 0 81 0   0     0   0   46 36                 82
736516 736516 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No 1 PK 05 2015   grade_1 10 5 6 0   0     0   2   9 14                       23 10 5 6 0   0     0   2   9 14                 23
736596 736596 MA Suffolk   school 2502790 35   Boston 250279000308 350278 Phineas Bates   Regular School No 1 PK 05 2015   grade_1 10 12 18 0   2     0   2   20 24                       44 10 12 18 0   2     0   2   20 24                 44
736603 736603 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Josiah Quincy   Regular School No 1 PK 05 2015   grade_1 10 23 23 0   66     0   5   66 61                       127 10 23 23 0   66     0   5   66 61                 127
737500 737500 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No 1 01 04 2015   grade_1 10 6 149 0   1     0   2   79 89                       168 10 6 149 0   1     0   2   79 89                 168
737504 737504 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No 1 01 04 2015   grade_1 10 8 129 0   4     0   2   85 68                       153 10 8 129 0   4     0   2   85 68                 153
737579 737579 MA Hampden   school 2503660 61   Chicopee 250366000500 610090 Gen John J Stefanik   Regular School No 1 KG 05 2015   grade_1 10 2 66 0   0     0   1   49 30                       79 10 2 66 0   0     0   1   49 30                 79
738205 738205 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   grade_1 10 0 0 0   0     0   0   5 5                       10 10 0 0 0   0     0   0   5 5                 10
738770 738770 MA Hampden   school 2506270 137   Holyoke 250627002795 1370070 H.B. Lawrence School   Regular School No 1 KG 03 2015   grade_1 10 3 58 0   0     0   2   40 33                       73 10 3 58 0   0     0   2   40 33                 73
739449 739449 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No 1 01 05 2015   grade_1 10 12 80 0   9     0   5   56 60                       116 10 12 80 0   9     0   5   56 60                 116
739503 739503 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Tracy   Regular School No 1 01 05 2015   grade_1 10 9 73 0   7     0   5   51 53                       104 10 9 73 0   7     0   5   51 53                 104
740217 740217 MA Bristol   school 2508430 201   New Bedford 250843001335 2010105 Carlos Pacheco   Regular School No 1 PK 05 2015   grade_1 10 9 39 0   0     1   3   34 28                       62 10 9 39 0   0     1   3   34 28                 62
740243 740243 MA Bristol   school 2508430 201   New Bedford 250843001342 2010125 Thomas R Rodman   Regular School No 1 PK 05 2015   grade_1 10 2 12 0   1     0   1   14 12                       26 10 2 12 0   1     0   1   14 12                 26
741145 741145 MA Norfolk   school 2509930 244   Randolph 250993002596 2440018 J F Kennedy Elementary   Regular School No 1 PK 05 2015   grade_1 10 42 12 0   8     0   1   39 34                       73 10 42 12 0   8     0   1   39 34                 73
741579 741579 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No 1 PK 06 2015   grade_1 10 0 0 0   0     0   2   2 10                       12 10 0 0 0   0     0   2   2 10                 12
741916 741916 MA Hampden   school 2511130 281   Springfield 251113001792 2810175 Alice B Beal Elementary   Regular School No 1 KG 05 2015   grade_1 10 5 17 0   2     0   2   19 17                       36 10 5 17 0   2     0   2   19 17                 36
743132 743132 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No 1 PK 06 2015   grade_1 10 6 24 1   6     0   0   34 13                       47 10 6 24 1   6     0   0   34 13                 47
743147 743147 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No 1 PK 06 2015   grade_1 10 3 50 0   3     0   3   39 30                       69 10 3 50 0   3     0   3   39 30                 69
743837 743837 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes 4 KG 12 2015   grade_1 10 52 16 0   6     1   3   41 47                       88 10 52 16 0   6     1   3   41 47                 88
742787 742787 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No 1 PK 01 2015   grade_1 100 0 1 0   0     0   8   57 52                       109 100 0 1 0   0     0   8   57 52                 109
735675 735675 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No 1 PK 04 2015   grade_1 101 0 0 0   0     0   0   58 43                       101 101 0 0 0   0     0   0   58 43                 101
739045 739045 MA Worcester   school 2506720 151   Leicester 250672000974 1510010 Leicester Primary School   Regular School No 1 PK 02 2015   grade_1 101 11 4 1   1     0   0   67 51                       118 101 11 4 1   1     0   0   67 51                 118
739745 739745 MA Middlesex   school 2507500 174   Maynard 250750001152 1740010 Green Meadow   Regular School No 1 PK 03 2015   grade_1 101 3 13 0   2     0   5   57 67                       124 101 3 13 0   2     0   5   57 67                 124
742305 742305 MA Middlesex   school 2511760 301   Tyngsborough 251176001714 3010020 Tyngsborough Elementary   Regular School No 1 PK 05 2015   grade_1 101 5 8 0   13     0   7   67 67                       134 101 5 8 0   13     0   7   67 67                 134
738823 738823 MA Middlesex   school 2506390 141   Hudson 250639000922 1410030 C A Farley   Regular School No 1 PK 04 2015   grade_1 102 0 6 0   3     0   2   58 55                       113 102 0 6 0   3     0   2   58 55                 113
739963 739963 MA Worcester   school 2507890 186   Millbury 250789001248 1860017 Elmwood Street   Regular School No 1 PK 03 2015   grade_1 102 0 14 0   3     0   7   61 65                       126 102 0 14 0   3     0   7   61 65                 126
739915 739915 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No 1 01 05 2015   grade_1 103 0 2 0   0     0   16   53 68                       121 103 0 2 0   0     0   16   53 68                 121
742957 742957 MA Middlesex   school 2513050 342   Wilmington 251305002153 3420025 Shawsheen Elementary   Regular School No 1 01 03 2015   grade_1 106 0 10 0   6     0   5   69 58                       127 106 0 10 0   6     0   5   69 58                 127
740661 740661 MA Bristol   school 2509000 218   Norton 250900001449 2180015 J C Solmonese   Regular School No 1 KG 03 2015   grade_1 107 1 2 0   2     0   1   60 53                       113 107 1 2 0   2     0   1   60 53                 113
739382 739382 MA Worcester   school 2507080 162   Lunenburg 250708001957 1620010 Lunenburg Primary School   Regular School No 1 PK 03 2015   grade_1 108 0 6 1   1     0   6   67 55                       122 108 0 6 1   1     0   6   67 55                 122
742210 742210 MA Bristol   school 2511520 293   Taunton 251152001565 2930008 Joseph C Chamberlain   Regular School No 1 KG 04 2015   grade_1 109 4 4 0   1     0   2   66 54                       120 109 4 4 0   1     0   2   66 54                 120
742260 742260 MA Middlesex   school 2511580 295   Tewksbury 251158001922 2950001 L F Dewing   Regular School No 1 PK 02 2015   grade_1 109 4 3 0   3     0   2   72 49                       121 109 4 3 0   3     0   2   72 49                 121
736173 736173 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Baldwin Early Learning Center   Regular School No 1 PK 01 2015   grade_1 11 7 12 0   5     0   2   20 17                       37 11 7 12 0   5     0   2   20 17                 37
736209 736209 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No 1 PK 08 2015   grade_1 11 23 35 0   13     0   0   45 37                       82 11 23 35 0   13     0   0   45 37                 82
736342 736342 MA Suffolk   school 2502790 35   Boston 250279000241 350122 George H Conley   Regular School No 1 PK 05 2015   grade_1 11 21 20 0   1     0   2   34 21                       55 11 21 20 0   1     0   2   34 21                 55
736411 736411 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No 1 PK 05 2015   grade_1 11 7 7 0   0     0   2   16 11                       27 11 7 7 0   0     0   2   16 11                 27
736755 736755 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No 1 PK 08 2015   grade_1 11 2 5 0   0     0   2   16 4                       20 11 2 5 0   0     0   2   16 4                 20
737335 737335 MA Middlesex   school 2503270 49   Cambridge 250327000443 490030 Martin Luther King Jr.   Regular School No 1 PK 05 2015   grade_1 11 10 7 0   10     0   8   19 27                       46 11 10 7 0   10     0   8   19 27                 46
737349 737349 MA Middlesex   school 2503270 49   Cambridge 250327000444 490040 Kennedy-Longfellow   Regular School No 1 PK 05 2015   grade_1 11 8 11 0   12     0   4   26 20                       46 11 8 11 0   12     0   4   26 20                 46
739467 739467 MA Essex   school 2507110 163   Lynn 250711001079 1630070 Lincoln-Thomson   Regular School No 1 KG 05 2015   grade_1 11 5 22 0   5     0   8   26 25                       51 11 5 22 0   5     0   8   26 25                 51
740191 740191 MA Bristol   school 2508430 201   New Bedford 250843001323 2010075 Ellen R Hathaway   Regular School No 1 KG 05 2015   grade_1 11 3 40 0   1     0   5   31 29                       60 11 3 40 0   1     0   5   31 29                 60
740204 740204 MA Bristol   school 2508430 201   New Bedford 250843001328 2010085 Horatio A Kempton   Regular School No 1 KG 05 2015   grade_1 11 1 4 0   0     0   1   11 6                       17 11 1 4 0   0     0   1   11 6                 17
741087 741087 MA Norfolk   school 2509870 243   Quincy 250987001567 2430075 Francis W Parker   Regular School No 1 KG 05 2015   grade_1 11 0 1 0   40     0   1   30 23                       53 11 0 1 0   40     0   1   30 23                 53
741138 741138 MA Norfolk   school 2509930 244   Randolph 250993001592 2440015 Margaret L Donovan   Regular School No 1 KG 05 2015   grade_1 11 27 13 0   22     0   1   32 42                       74 11 27 13 0   22     0   1   32 42                 74
741270 741270 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No 1 PK 08 2015   grade_1 11 0 1 0   0     0   0   3 9                       12 11 0 1 0   0     0   0   3 9                 12
741844 741844 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No 1 PK 08 2015   grade_1 11 9 22 0   0     0   1   21 22                       43 11 9 22 0   0     0   1   21 22                 43
741930 741930 MA Hampden   school 2511130 281   Springfield 251113001836 2810185 Washington   Regular School No 1 PK 05 2015   grade_1 11 15 55 0   10     0   4   54 41                       95 11 15 55 0   10     0   4   54 41                 95
742298 742298 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No 1 PK 06 2015   grade_1 11 1 2 0   0     0   1   8 7                       15 11 1 2 0   0     0   1   8 7                 15
742439 742439 MA Middlesex   school 2512000 308   Waltham 251200001969 3080065 Henry Whittemore Elementary School   Regular School No 1 KG 05 2015   grade_1 11 1 64 2   2     1   1   44 38                       82 11 1 64 2   2     1   1   44 38                 82
743124 743124 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No 1 KG 06 2015   grade_1 11 11 17 0   0     0   0   17 22                       39 11 11 17 0   0     0   0   17 22                 39
743715 743715 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2015   grade_1 11 0 0 0   0     0   2   2 11                       13 11 0 0 0   0     0   2   2 11                 13
744136 744136 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No 1 PK 06 2015   grade_1 11 0 1 0   0     0   0   2 10                       12 11 0 1 0   0     0   0   2 10                 12
744165 744165 MA Berkshire   school 2503390 635   Central Berkshire 250339000465 6350035 Kittredge   Regular School No 1 PK 05 2015   grade_1 11 0 2 0   0     0   0   6 7                       13 11 0 2 0   0     0   0   6 7                 13
744532 744532 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Colrain Central   Regular School No 1 PK 06 2015   grade_1 11 0 0 0   0     0   0   6 5                       11 11 0 0 0   0     0   0   6 5                 11
739947 739947 MA Worcester   school 2507860 185   Milford 250786001237 1850065 Brookside   Regular School No 1 KG 05 2015   grade_1 110 4 41 3   5     0   11   82 92                       174 110 4 41 3   5     0   11   82 92                 174
744211 744211 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002428 6500010 Palmer River   Regular School No 1 KG 04 2015   grade_1 111 3 4 0   2     0   3   62 61                       123 111 3 4 0   2     0   3   62 61                 123
737444 737444 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver Elementary School   Regular School No 1 PK 05 2015   grade_1 113 1 2 0   0     0   2   59 59                       118 113 1 2 0   0     0   2   59 59                 118
738375 738375 MA Essex   school 2505220 105   Georgetown 250522000766 1050005 Perley Elementary   Regular School No 1 PK 01 2015   grade_1 113 0 2 0   0     1   2   64 54                       118 113 0 2 0   0     1   2   64 54                 118
739920 739920 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No 1 01 05 2015   grade_1 115 3 3 0   1     0   6   67 61                       128 115 3 3 0   1     0   6   67 61                 128

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