Data source: Big Local News · About: Big Local

964 rows where grade = "kindergarten", state = "MA" and year = 2016 sorted by white_int

View and edit SQL

year

  • 2016 · 964

grade

  • kindergarten · 964
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
933811 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2016   kindergarten * * * *   *     *   *   1 3                       4                         1 3                 4
938149 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No 1 PK 06 2016   kindergarten * * * *   *     *   *   1 2                       3                         1 2                 3
941537 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No 1 PK 06 2016   kindergarten * * * *   *     *   *   2 2                       4                         2 2                 4
941717 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No 1 KG 05 2016   kindergarten * * * *   *     *   *   2 1                       3                         2 1                 3
933288 MA Suffolk   school 2502790 35   Boston 250279000270 350180 John Winthrop   Regular School No 1 PK 05 2016   kindergarten 0 34 20 0   4     0   2   26 34                       60 0 34 20 0   4     0   2   26 34                 60
933400 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No 1 PK 05 2016   kindergarten 0 14 6 0   0     0   1   8 13                       21 0 14 6 0   0     0   1   8 13                 21
933497 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No 1 PK 08 2016   kindergarten 0 9 32 0   0     0   2   21 22                       43 0 9 32 0   0     0   2   21 22                 43
933604 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No 1 PK 08 2016   kindergarten 0 33 9 0   1     0   1   17 27                       44 0 33 9 0   1     0   1   17 27                 44
940222 MA Suffolk   school 2500543 407   Dudley Street Neighborhood Charter School (District) 250054302763 4070405 Dudley Street Neighborhood Charter School   Regular School Yes 1 PK 04 2016   kindergarten 0 29 16 0   0     0   0   19 26                       45 0 29 16 0   0     0   0   19 26                 45
940275 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes 1 PK 04 2016   kindergarten 0 19 14 0   1     0   0   15 19                       34 0 19 14 0   1     0   0   15 19                 34
940333 MA Essex   school 2500535 431   Community Day Charter Public School - R. Kingman Webster (District) 250053502719 4310205 Community Day Charter Public School - R. Kingman Webster   Regular School Yes 1 PK 04 2016   kindergarten 0 0 41 0   1     0   0   24 18                       42 0 0 41 0   1     0   0   24 18                 42
940361 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes 4 PK 12 2016   kindergarten 0 17 5 0   0     0   0   10 12                       22 0 17 5 0   0     0   0   10 12                 22
940383 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 2016   kindergarten 0 1 49 0   0     0   0   25 25                       50 0 1 49 0   0     0   0   25 25                 50
940490 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes 1 PK 08 2016   kindergarten 0 0 80 0   0     0   0   36 44                       80 0 0 80 0   0     0   0   36 44                 80
940532 MA Essex   school 2500537 463   KIPP Academy Boston Charter School (District) 250053702716 4630205 KIPP Academy Boston Charter School   Regular School Yes 1 KG 08 2016   kindergarten 0 50 21 0   0     0   0   36 35                       71 0 50 21 0   0     0   0   36 35                 71
933055 MA Suffolk   school 2502790 35   Boston 250279001115 350008 Dr. Catherine Ellison-Rosa Parks Early Ed School   Regular School No 1 PK 03 2016   kindergarten 1 12 24 0   0     0   2   18 21                       39 1 12 24 0   0     0   2   18 21                 39
933063 MA Suffolk   school 2502790 35   Boston 250279001126 350010 Haynes Early Education Center   Regular School No 1 PK 01 2016   kindergarten 1 27 27 2   2     0   1   32 28                       60 1 27 27 2   2     0   1   32 28                 60
933089 MA Suffolk   school 2502790 35   Boston 250279002806 350015 Higginson   Regular School No 1 PK 02 2016   kindergarten 1 18 27 0   0     0   1   19 28                       47 1 18 27 0   0     0   1   19 28                 47
933119 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Charles H Taylor   Regular School No 1 PK 05 2016   kindergarten 1 48 11 0   0     0   3   38 25                       63 1 48 11 0   0     0   3   38 25                 63
933339 MA Suffolk   school 2502790 35   Boston 250279000244 350200 Harvard-Kent   Regular School No 1 PK 05 2016   kindergarten 1 16 20 0   15     0   3   33 22                       55 1 16 20 0   15     0   3   33 22                 55
933367 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No 1 PK 08 2016   kindergarten 1 22 32 0   0     0   3   30 28                       58 1 22 32 0   0     0   3   30 28                 58
933455 MA Suffolk   school 2502790 35   Boston 250279000304 350268 Paul A Dever   Regular School No 1 PK 05 2016   kindergarten 1 15 42 0   7     0   1   35 31                       66 1 15 42 0   7     0   1   35 31                 66
933552 MA Suffolk   school 2502790 35   Boston 250279000337 350366 William E Russell   Regular School No 1 PK 05 2016   kindergarten 1 22 26 0   9     1   1   31 29                       60 1 22 26 0   9     1   1   31 29                 60
933776 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No 1 KG 08 2016   kindergarten 1 4 62 0   2     0   0   27 42                       69 1 4 62 0   2     0   0   27 42                 69
935617 MA Hampden   school 2506270 137   Holyoke 250627002795 1370070 H.B. Lawrence School   Regular School No 1 KG 03 2016   kindergarten 1 4 84 0   0     0   1   44 46                       90 1 4 84 0   0     0   1   44 46                 90
935746 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No 1 KG 04 2016   kindergarten 1 1 103 0   0     0   0   58 47                       105 1 1 103 0   0     0   0   58 47                 105
935808 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No 1 KG 08 2016   kindergarten 1 1 54 0   3     0   2   32 29                       61 1 1 54 0   3     0   2   32 29                 61
936283 MA Essex   school 2507110 163   Lynn 250711001087 1630040 Wm P Connery   Regular School No 1 PK 05 2016   kindergarten 1 4 70 0   14     0   5   53 41                       94 1 4 70 0   14     0   5   53 41                 94
938576 MA Hampden   school 2511130 281   Springfield 251113001796 2810025 Brightwood   Regular School No 1 KG 05 2016   kindergarten 1 4 37 0   0     0   0   24 18                       42 1 4 37 0   0     0   0   24 18                 42
938595 MA Hampden   school 2511130 281   Springfield 251113001838 2810045 William N. DeBerry   Regular School No 1 KG 05 2016   kindergarten 1 9 40 0   0     0   0   25 25                       50 1 9 40 0   0     0   0   25 25                 50
933086 MA Suffolk   school 2502790 35   Boston 250279002839 350014 Pauline Agassiz Shaw Elementary School   Regular School No 1 PK 01 2016   kindergarten 2 35 6 0   3     0   1   30 17                       47 2 35 6 0   3     0   1   30 17                 47
933172 MA Suffolk   school 2502790 35   Boston 250279000227 350088 Edward Everett   Regular School No 1 PK 05 2016   kindergarten 2 22 8 0   8     0   0   21 19                       40 2 22 8 0   8     0   0   21 19                 40
933227 MA Suffolk   school 2502790 35   Boston 250279000249 350141 Hugh Roe O'Donnell   Regular School No 1 PK 05 2016   kindergarten 2 0 39 0   0     0   0   23 18                       41 2 0 39 0   0     0   0   23 18                 41
933242 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No 1 KG 07 2016   kindergarten 2 14 21 0   0     0   0   18 19                       37 2 14 21 0   0     0   0   18 19                 37
933264 MA Suffolk   school 2502790 35   Boston 250279000265 350166 John F Kennedy   Regular School No 1 PK 05 2016   kindergarten 2 12 43 0   0     0   2   29 30                       59 2 12 43 0   0     0   2   29 30                 59
933443 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Patrick J Kennedy   Regular School No 1 PK 05 2016   kindergarten 2 0 39 0   1     0   0   23 19                       42 2 0 39 0   1     0   0   23 19                 42
933585 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No 1 PK 08 2016   kindergarten 2 36 14 0   0     1   1   31 23                       54 2 36 14 0   0     1   1   31 23                 54
933801 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No 1 PK 08 2016   kindergarten 2 2 39 0   0     0   2   23 22                       45 2 2 39 0   0     0   2   23 22                 45
938569 MA Hampden   school 2511130 281   Springfield 251113000896 2810023 Milton Bradley School   Regular School No 1 PK 05 2016   kindergarten 2 19 66 0   1     0   2   46 44                       90 2 19 66 0   1     0   2   46 44                 90
938607 MA Hampden   school 2511130 281   Springfield 251113000341 2810055 Rebecca M Johnson   Regular School No 1 PK 05 2016   kindergarten 2 26 48 0   0     0   3   43 36                       79 2 26 48 0   0     0   3   43 36                 79
938677 MA Hampden   school 2511130 281   Springfield 251113001815 2810120 Lincoln   Regular School No 1 KG 05 2016   kindergarten 2 8 55 0   0     0   1   34 32                       66 2 8 55 0   0     0   1   34 32                 66
940620 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes 1 PK 06 2016   kindergarten 2 82 51 0   0     0   7   74 68                       142 2 82 51 0   0     0   7   74 68                 142
942001 MA Hampden   school 2500557 3510   Springfield Preparatory Charter School (District) 250055702842 35100205 Springfield Preparatory Charter School   Regular School Yes 1 KG 01 2016   kindergarten 2 6 43 0   2     0   1   25 29                       54 2 6 43 0   2     0   1   25 29                 54
933052 MA Suffolk   school 2502790 35   Boston 250279002514 350006 ELC - West Zone   Regular School No 1 PK 01 2016   kindergarten 3 10 18 0   0     0   3   20 14                       34 3 10 18 0   0     0   3   20 14                 34
933140 MA Suffolk   school 2502790 35   Boston 250279000220 350072 David A Ellis   Regular School No 1 PK 05 2016   kindergarten 3 31 45 1   1     0   3   38 46                       84 3 31 45 1   1     0   3   38 46                 84
933163 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No 1 KG 08 2016   kindergarten 3 0 57 0   1     0   1   31 31                       62 3 0 57 0   1     0   1   31 31                 62
933220 MA Suffolk   school 2502790 35   Boston 250279002569 350138 O W Holmes   Regular School No 1 PK 05 2016   kindergarten 3 32 15 0   2     0   7   35 24                       59 3 32 15 0   2     0   7   35 24                 59
933250 MA Suffolk   school 2502790 35   Boston 250279000255 350154 James J Chittick   Regular School No 1 PK 05 2016   kindergarten 3 27 16 0   1     0   0   29 18                       47 3 27 16 0   1     0   0   29 18                 47
933417 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No 1 PK 08 2016   kindergarten 3 48 28 0   1     0   2   45 37                       82 3 48 28 0   1     0   2   45 37                 82
933507 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No 1 PK 08 2016   kindergarten 3 2 21 0   2     0   4   14 18                       32 3 2 21 0   2     0   4   14 18                 32
933612 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2016   kindergarten 3 23 22 0   0     0   0   22 26                       48 3 23 22 0   0     0   0   22 26                 48
933974 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Huntington   Regular School No 1 KG 05 2016   kindergarten 3 41 3 0   0     0   4   24 27                       51 3 41 3 0   0     0   4   24 27                 51
935564 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No 1 PK 08 2016   kindergarten 3 3 44 0   0     0   1   29 22                       51 3 3 44 0   0     0   1   29 22                 51
935784 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No 1 KG 05 2016   kindergarten 3 1 80 0   0     0   0   49 35                       84 3 1 80 0   0     0   0   49 35                 84
936247 MA Essex   school 2507110 163   Lynn 250711002658 1630005 Washington Elementary School   Regular School No 1 KG 05 2016   kindergarten 3 7 54 1   8     0   0   35 38                       73 3 7 54 1   8     0   0   35 38                 73
938549 MA Hampden   school 2511130 281   Springfield 251113001794 2810010 Edward P. Boland School   Regular School No 1 PK 05 2016   kindergarten 3 9 70 0   3     0   1   52 34                       86 3 9 70 0   3     0   1   52 34                 86
938582 MA Hampden   school 2511130 281   Springfield 251113001801 2810030 Elias Brookings   Regular School No 1 PK 05 2016   kindergarten 3 17 28 0   1     0   1   20 30                       50 3 17 28 0   1     0   1   20 30                 50
938665 MA Hampden   school 2511130 281   Springfield 251113001813 2810110 Kensington International School   Regular School No 1 KG 05 2016   kindergarten 3 9 49 0   2     0   2   33 32                       65 3 9 49 0   2     0   2   33 32                 65
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
940298 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 04 2016   kindergarten 3 0 37 0   0     0   0   21 19                       40 3 0 37 0   0     0   0   21 19                 40
940373 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes 1 PK 08 2016   kindergarten 3 1 5 0   4     0   0   6 7                       13 3 1 5 0   4     0   0   6 7                 13
940707 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 2016   kindergarten 3 24 30 0   2     0   3   29 33                       62 3 24 30 0   2     0   3   29 33                 62
933037 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Lee Academy   Regular School No 1 PK 01 2016   kindergarten 4 39 15 1   6     1   0   33 33                       66 4 39 15 1   6     1   0   33 33                 66
933360 MA Suffolk   school 2502790 35   Boston 250279000289 350227 Mather   Regular School No 1 PK 05 2016   kindergarten 4 40 13 1   31     0   3   45 47                       92 4 40 13 1   31     0   3   45 47                 92
933534 MA Suffolk   school 2502790 35   Boston 250279000338 350360 William Ellery Channing   Regular School No 1 PK 05 2016   kindergarten 4 19 19 0   1     0   0   22 21                       43 4 19 19 0   1     0   0   22 21                 43
933559 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No 1 PK 07 2016   kindergarten 4 36 20 1   0     0   1   33 29                       62 4 36 20 1   0     0   1   33 29                 62
933635 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No 1 PK 05 2016   kindergarten 4 15 55 0   2     0   1   36 41                       77 4 15 55 0   2     0   1   36 41                 77
935579 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No 1 KG 08 2016   kindergarten 4 0 70 0   0     0   1   42 33                       75 4 0 70 0   0     0   1   42 33                 75
938690 MA Hampden   school 2511130 281   Springfield 251113001818 2810140 Mary M Lynch   Regular School No 1 KG 05 2016   kindergarten 4 6 31 0   0     0   1   22 20                       42 4 6 31 0   0     0   1   22 20                 42
939917 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No 1 KG 06 2016   kindergarten 4 4 6 0   2     0   2   11 7                       18 4 4 6 0   2     0   2   11 7                 18
940308 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School Roslindale   Regular School Yes 1 KG 08 2016   kindergarten 4 42 14 0   1     0   0   33 28                       61 4 42 14 0   1     0   0   33 28                 61
940561 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes 4 PK 12 2016   kindergarten 4 29 34 0   2     0   1   37 33                       70 4 29 34 0   2     0   1   37 33                 70
941979 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes 1 PK 07 2016   kindergarten 4 32 20 0   1     0   2   37 22                       59 4 32 20 0   1     0   2   37 22                 59
933133 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No 1 PK 05 2016   kindergarten 5 0 8 0   0     0   2   7 8                       15 5 0 8 0   0     0   2   7 8                 15
933312 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No 1 PK 08 2016   kindergarten 5 32 12 0   0     0   1   28 22                       50 5 32 12 0   0     0   1   28 22                 50
933353 MA Suffolk   school 2502790 35   Boston 250279000290 350226 Mattahunt   Regular School No 1 PK 05 2016   kindergarten 5 68 28 0   0     0   2   62 41                       103 5 68 28 0   0     0   2   62 41                 103
933490 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Samuel W Mason   Regular School No 1 PK 05 2016   kindergarten 5 18 6 1   0     0   0   13 17                       30 5 18 6 1   0     0   0   13 17                 30
934156 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington High   Regular School No 3 09 12 2016   kindergarten 5 1 0 0   0     0   0   5 1                       6 5 1 0 0   0     0   0   5 1                 6
935751 MA Essex   school 2506660 149   Lawrence 250666002815 1490011 Lawrence Family Public Academy   Regular School No 1 PK KG 2016   kindergarten 5 3 131 0   2     0   0   69 72                       141 5 3 131 0   2     0   0   69 72                 141
935798 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Edward F. Parthum   Regular School No 1 KG 04 2016   kindergarten 5 1 60 0   1     0   1   36 32                       68 5 1 60 0   1     0   1   36 32                 68
936290 MA Essex   school 2507110 163   Lynn 250711001070 1630045 E J Harrington   Regular School No 1 PK 05 2016   kindergarten 5 7 62 0   5     0   3   48 34                       82 5 7 62 0   5     0   3   48 34                 82
937985 MA Norfolk   school 2509930 244   Randolph 250993001593 2440040 Martin E Young Elementary   Regular School No 1 KG 05 2016   kindergarten 5 25 5 0   11     0   4   25 25                       50 5 25 5 0   11     0   4   25 25                 50
938617 MA Hampden   school 2511130 281   Springfield 251113001805 2810065 Glenwood   Regular School No 1 KG 05 2016   kindergarten 5 2 32 0   0     0   0   27 12                       39 5 2 32 0   0     0   0   27 12                 39
938741 MA Hampden   school 2511130 281   Springfield 251113001837 2810190 White Street   Regular School No 1 KG 05 2016   kindergarten 5 16 39 0   2     0   2   33 31                       64 5 16 39 0   2     0   2   33 31                 64
940287 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes 1 KG 06 2016   kindergarten 5 55 6 1   1     0   0   33 35                       68 5 55 6 1   1     0   0   33 35                 68
940481 MA Hampden   school 2500087 453   Holyoke Community Charter (District) 250008701997 4530005 Holyoke Community Charter School   Regular School Yes 1 KG 08 2016   kindergarten 5 2 70 0   1     0   0   34 44                       78 5 2 70 0   1     0   0   34 44                 78
933377 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No 1 KG 05 2016   kindergarten 6 12 14 0   0     0   2   18 16                       34 6 12 14 0   0     0   2   18 16                 34
933476 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Roger Clap   Regular School No 1 PK 05 2016   kindergarten 6 4 3 0   3     0   0   7 9                       16 6 4 3 0   3     0   0   7 9                 16
933517 MA Suffolk   school 2502790 35   Boston 250279000332 350328 Thomas J Kenny   Regular School No 1 PK 05 2016   kindergarten 6 13 3 0   3     0   0   17 8                       25 6 13 3 0   3     0   0   17 8                 25
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
935739 MA Essex   school 2506660 149   Lawrence 250666000730 1490003 John Breen School   Regular School No 1 PK KG 2016   kindergarten 6 2 111 0   2     0   0   72 49                       121 6 2 111 0   2     0   0   72 49                 121
935768 MA Essex   school 2506660 149   Lawrence 250666000958 1490020 James F Hennessey   Regular School No 1 PK 02 2016   kindergarten 6 0 80 0   2     0   1   51 38                       89 6 0 80 0   2     0   1   51 38                 89
936144 MA Middlesex   school 2507020 160   Lowell 250702001051 1600055 Washington   Regular School No 1 PK 04 2016   kindergarten 6 2 7 0   27     0   0   21 21                       42 6 2 7 0   27     0   0   21 21                 42
936277 MA Essex   school 2507110 163   Lynn 250711001068 1630035 Cobbet Elementary   Regular School No 1 KG 05 2016   kindergarten 6 11 77 0   7     0   2   59 44                       103 6 11 77 0   7     0   2   59 44                 103
937864 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No 1 PK 08 2016   kindergarten 6 2 2 0   0     0   3   8 5                       13 6 2 2 0   0     0   3   8 5                 13
937979 MA Norfolk   school 2509930 244   Randolph 250993001590 2440020 Elizabeth G Lyons Elementary   Regular School No 1 KG 05 2016   kindergarten 6 20 3 1   3     0   2   19 16                       35 6 20 3 1   3     0   2   19 16                 35
938556 MA Hampden   school 2511130 281   Springfield 251113001833 2810015 Thomas M Balliet   Regular School No 1 PK 05 2016   kindergarten 6 7 23 1   0     0   0   23 14                       37 6 7 23 1   0     0   0   23 14                 37
938589 MA Hampden   school 2511130 281   Springfield 251113001799 2810035 Daniel B Brunton   Regular School No 1 KG 05 2016   kindergarten 6 13 47 0   1     0   2   39 30                       69 6 13 47 0   1     0   2   39 30                 69
940032 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No 1 PK 06 2016   kindergarten 6 20 32 0   2     0   5   27 38                       65 6 20 32 0   2     0   5   27 38                 65
940047 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Lincoln Street   Regular School No 1 PK 06 2016   kindergarten 6 5 35 2   2     0   2   25 27                       52 6 5 35 2   2     0   2   25 27                 52

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