enrollments

Data source: Big Local News · About: Big Local

970 rows where grade = "kindergarten", state = "MA" and year = 2017 sorted by black descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 970 ✖

grade ✖

  • kindergarten · 970 ✖
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
1122734 1122734 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No Elementary PK 05 2017   kindergarten 18 9 12 0   0     0   2   26 15                       41 18 9 12 0   0     0   2   26 15                 41
1122837 1122837 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No Elementary PK 05 2017   kindergarten 8 9 7 0   0     0   1   13 12                       25 8 9 7 0   0     0   1   13 12                 25
1122857 1122857 MA Suffolk   school 2502790 35   Boston 250279000275 350181 Joseph P Tynan   Regular School No Elementary PK 05 2017   kindergarten 7 9 13 0   2     0   4   20 15                       35 7 9 13 0   2     0   4   20 15                 35
1123044 1123044 MA Suffolk   school 2502790 35   Boston 250279000308 350278 Phineas Bates   Regular School No Elementary PK 05 2017   kindergarten 11 9 14 0   2     0   3   24 15                       39 11 9 14 0   2     0   3   24 15                 39
1123914 1123914 MA Middlesex   school 2503270 49   Cambridge 250327000446 490045 Morse   Regular School No Elementary PK 05 2017   kindergarten 26 9 3 0   10     0   3   30 21                       51 26 9 3 0   10     0   3   30 21                 51
1123930 1123930 MA Middlesex   school 2503270 49   Cambridge 250327000442 490065 John M Tobin   Regular School No Elementary PK 05 2017   kindergarten 15 9 2 0   8     0   5   25 14                       39 15 9 2 0   8     0   5   25 14                 39
1124128 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
1124451 1124451 MA Middlesex   school 2504320 79   Dracut 250432000578 790035 Brookside Elementary   Regular School No Elementary KG 05 2017   kindergarten 64 9 6 0   5     0   0   40 44                       84 64 9 6 0   5     0   0   40 44                 84
1124628 1124628 MA Middlesex   school 2504770 93   Everett 250477002118 930015 Webster School   Regular School No Elementary PK 04 2017   kindergarten 30 9 29 0   3     0   0   45 26                       71 30 9 29 0   3     0   0   45 26                 71
1124985 1124985 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2017   kindergarten 19 9 81 0   0     0   5   52 62                       114 19 9 81 0   0     0   5   52 62                 114
1126069 1126069 MA Middlesex   school 2506900 157   Lincoln 250690001009 1570006 Hanscom Primary   Regular School No Elementary PK 03 2017   kindergarten 40 9 15 0   3     0   3   41 29                       70 40 9 15 0   3     0   3   41 29                 70
1126152 1126152 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Rogers STEM Academy   Regular School No Elementary PK 05 2017   kindergarten 19 9 34 0   21     0   8   41 50                       91 19 9 34 0   21     0   8   41 50                 91
1126819 1126819 MA Middlesex   school 2507560 176   Medford 250756002062 1760150 Milton Fuller Roberts   Regular School No Elementary PK 05 2017   kindergarten 59 9 7 0   6     0   3   46 38                       84 59 9 7 0   6     0   3   46 38                 84
1128106 1128106 MA Berkshire   school 2509630 236   Pittsfield 250963001519 2360035 Egremont   Regular School No Elementary KG 05 2017   kindergarten 53 9 3 0   1     0   4   33 37                       70 53 9 3 0   1     0   4   33 37                 70
1128943 1128943 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No Elementary PK 08 2017   kindergarten 10 9 22 0   2     0   0   25 18                       43 10 9 22 0   2     0   0   25 18                 43
1129146 1129146 MA Hampden   school 2511130 281   Springfield 251113001838 2810045 William N. DeBerry   Regular School No Elementary KG 05 2017   kindergarten 3 9 35 0   0     0   1   21 27                       48 3 9 35 0   0     0   1   21 27                 48
1129168 1129168 MA Hampden   school 2511130 281   Springfield 251113001817 2810060 Margaret C Ells   Regular School No Elementary PK 01 2017   kindergarten 6 9 23 0   0     0   1   25 14                       39 6 9 23 0   0     0   1   25 14                 39
1129490 1129490 MA Norfolk   school 2511250 285   Stoughton 251125001863 2850015 South Elementary   Regular School No Elementary KG 05 2017   kindergarten 19 9 3 0   2     0   0   19 14                       33 19 9 3 0   2     0   0   19 14                 33
1130767 1130767 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No Elementary PK 06 2017   kindergarten 10 9 26 0   11     0   1   29 28                       57 10 9 26 0   11     0   1   29 28                 57
1130776 1130776 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No Elementary KG 06 2017   kindergarten 6 9 49 0   1     0   1   33 33                       66 6 9 49 0   1     0   1   33 33                 66
1130845 1130845 MA Worcester   school 2513230 348   Worcester 251323002217 3480110 Gates Lane   Regular School No Elementary PK 06 2017   kindergarten 19 9 30 1   4     0   6   45 24                       69 19 9 30 1   4     0   6   45 24                 69
1130880 1130880 MA Worcester   school 2513230 348   Worcester 251323002226 3480145 Lake View   Regular School No Elementary KG 06 2017   kindergarten 26 9 9 0   7     0   2   29 24                       53 26 9 9 0   7     0   2   29 24                 53
1131527 1131527 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2017   kindergarten 1 82 54 0   1     0   4   63 79                       142 1 82 54 0   1     0   4   63 79                 142
1122742 1122742 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No Elementary PK 08 2017   kindergarten 17 8 12 0   2     0   1   21 19                       40 17 8 12 0   2     0   1   21 19                 40
1122964 1122964 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No Elementary PK 08 2017   kindergarten 11 8 7 1   33     0   4   36 28                       64 11 8 7 1   33     0   4   36 28                 64
1123114 1123114 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2017   kindergarten 36 8 15 0   2     0   7   40 28                       68 36 8 15 0   2     0   7   40 28                 68
1123855 1123855 MA Middlesex   school 2503270 49   Cambridge 250327000435 490005 Maria L. Baldwin   Regular School No Elementary PK 05 2017   kindergarten 38 8 8 0   5     0   5   33 31                       64 38 8 8 0   5     0   5   33 31                 64
1123922 1123922 MA Middlesex   school 2503270 49   Cambridge 250327000447 490050 Peabody   Regular School No Elementary PK 05 2017   kindergarten 30 8 0 0   8     0   3   28 21                       49 30 8 0 0   8     0   3   28 21                 49
1124635 1124635 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No Elementary KG 08 2017   kindergarten 15 8 54 0   8     0   0   39 46                       85 15 8 54 0   8     0   0   39 46                 85
1124728 1124728 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Mary Fonseca Elementary School   Regular School No Elementary KG 05 2017   kindergarten 47 8 52 0   4     0   18   76 53                       129 47 8 52 0   4     0   18   76 53                 129
1124735 1124735 MA Bristol   school 2504830 95   Fall River 250483002656 950013 Letourneau Elementary School   Regular School No Elementary PK 05 2017   kindergarten 38 8 29 0   2     0   10   41 46                       87 38 8 29 0   2     0   10   41 46                 87
1124837 1124837 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No Elementary PK 04 2017   kindergarten 35 8 3 1   0     0   6   27 26                       53 35 8 3 1   0     0   6   27 26                 53
1124885 1124885 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No Elementary PK 04 2017   kindergarten 31 8 67 1   9     0   8   67 57                       124 31 8 67 1   9     0   8   67 57                 124
1124960 1124960 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No Elementary KG 02 2017   kindergarten 53 8 2 0   12     0   6   47 34                       81 53 8 2 0   12     0   6   47 34                 81
1125957 1125957 MA Worcester   school 2506780 153   Leominster 250678002637 1530010 Frances Drake School   Regular School No Elementary KG 05 2017   kindergarten 37 8 33 0   3     0   7   48 40                       88 37 8 33 0   3     0   7   48 40                 88
1126206 1126206 MA Middlesex   school 2507020 160   Lowell 250702001044 1600036 Pawtucketville Memorial   Regular School No Elementary PK 04 2017   kindergarten 33 8 26 0   21     0   5   50 43                       93 33 8 26 0   21     0   5   50 43                 93
1126388 1126388 MA Essex   school 2507110 163   Lynn 250711001068 1630035 Cobbet Elementary   Regular School No Elementary KG 05 2017   kindergarten 8 8 85 0   7     0   3   53 58                       111 8 8 85 0   7     0   3   53 58                 111
1126460 1126460 MA Essex   school 2507110 163   Lynn 250711001066 1630090 Capt William G Shoemaker   Regular School No Elementary PK 05 2017   kindergarten 17 8 15 0   6     0   8   37 17                       54 17 8 15 0   6     0   8   37 17                 54
1126657 1126657 MA Middlesex   school 2507320 170   Marlborough 250732001130 1700008 Francis J Kane   Regular School No Elementary KG 04 2017   kindergarten 66 8 35 0   3     0   2   58 56                       114 66 8 35 0   3     0   2   58 56                 114
1126925 1126925 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No Elementary PK 08 2017   kindergarten 63 8 34 0   5     0   0   56 54                       110 63 8 34 0   5     0   0   56 54                 110
1127328 1127328 MA Bristol   school 2508430 201   New Bedford 250843001320 2010123 Casimir Pulaski   Regular School No Elementary PK 05 2017   kindergarten 70 8 14 0   3     0   2   54 43                       97 70 8 14 0   3     0   2   54 43                 97
1128151 1128151 MA Berkshire   school 2509630 236   Pittsfield 250963001535 2360105 Silvio O Conte Community   Regular School No Elementary PK 05 2017   kindergarten 31 8 14 0   0     0   10   25 38                       63 31 8 14 0   0     0   10   25 38                 63
1128636 1128636 MA Essex   school 2510380 258   Salem 251038002559 2580025 Nathaniel Bowditch   Regular School No Elementary KG 08 2017   kindergarten 10 8 19 0   3     0   2   22 20                       42 10 8 19 0   3     0   2   22 20                 42
1129153 1129153 MA Hampden   school 2511130 281   Springfield 251113001807 2810050 Hiram L Dorman   Regular School No Elementary KG 05 2017   kindergarten 8 8 24 0   2     0   1   20 23                       43 8 8 24 0   2     0   1   20 23                 43
1129241 1129241 MA Hampden   school 2511130 281   Springfield 251113001815 2810120 Lincoln   Regular School No Elementary KG 05 2017   kindergarten 4 8 57 0   0     0   2   37 34                       71 4 8 57 0   0     0   2   37 34                 71
1129653 1129653 MA Bristol   school 2511520 293   Taunton 251152001565 2930008 Joseph C Chamberlain   Regular School No Elementary KG 04 2017   kindergarten 66 8 1 0   2     0   6   45 38                       83 66 8 1 0   2     0   6   45 38                 83
1129904 1129904 MA Middlesex   school 2512000 308   Waltham 251200001967 3080032 Douglas MacArthur Elementary School   Regular School No Elementary KG 05 2017   kindergarten 41 8 14 0   9     0   7   43 36                       79 41 8 14 0   9     0   7   43 36                 79
1129919 1129919 MA Middlesex   school 2512000 308   Waltham 251200001978 3080050 Thomas R Plympton Elementary School   Regular School No Elementary KG 05 2017   kindergarten 23 8 29 0   5     0   5   41 29                       70 23 8 29 0   5     0   5   41 29                 70
1130750 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
1130854 1130854 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Grafton Street   Regular School No Elementary PK 06 2017   kindergarten 14 8 30 0   6     0   1   29 30                       59 14 8 30 0   6     0   1   29 30                 59
1130905 1130905 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No Elementary PK 06 2017   kindergarten 19 8 17 0   4     0   4   29 23                       52 19 8 17 0   4     0   4   29 23                 52
1130991 1130991 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No Elementary KG 06 2017   kindergarten 12 8 43 0   1     0   5   35 34                       69 12 8 43 0   1     0   5   35 34                 69
1123614 1123614 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2017   kindergarten 20 76 14 0   1     0   6   59 58                       117 20 76 14 0   1     0   6   59 58                 117
1122062 1122062 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2017   kindergarten 25 7 11 0   6     0   1   23 27                       50 25 7 11 0   6     0   1   23 27                 50
1122161 1122161 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2017   kindergarten 55 7 13 1   19     0   0   44 51                       95 55 7 13 1   19     0   0   44 51                 95
1122203 1122203 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2017   kindergarten 35 7 26 0   0     0   5   38 35                       73 35 7 26 0   0     0   5   38 35                 73
1122581 1122581 MA Suffolk   school 2502790 35   Boston 250279001118 350009 East Boston Early Childhood Center   Regular School No Elementary PK 01 2017   kindergarten 13 7 42 0   1     0   2   37 28                       65 13 7 42 0   1     0   2   37 28                 65
1122975 1122975 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No Elementary PK 05 2017   kindergarten 4 7 10 0   1     0   1   10 13                       23 4 7 10 0   1     0   1   10 13                 23
1123817 1123817 MA Middlesex   school 2503240 48   Burlington 250324000427 480007 Fox Hill   Regular School No Elementary KG 05 2017   kindergarten 52 7 3 0   16     0   2   41 39                       80 52 7 3 0   16     0   2   41 39                 80
1123882 1123882 MA Middlesex   school 2503270 49   Cambridge 250327000441 490020 Haggerty   Regular School No Elementary PK 05 2017   kindergarten 26 7 3 0   8     0   7   24 27                       51 26 7 3 0   8     0   7   24 27                 51
1124182 1124182 MA Hampden   school 2503660 61   Chicopee 250366000500 610090 Gen John J Stefanik   Regular School No Elementary KG 05 2017   kindergarten 22 7 39 0   0     0   0   38 30                       68 22 7 39 0   0     0   0   38 30                 68
1124992 1124992 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No Elementary KG 05 2017   kindergarten 50 7 4 0   3     0   6   38 32                       70 50 7 4 0   3     0   6   38 32                 70
1125378 1125378 MA Essex   school 2505970 128   Haverhill 250597002769 1280005 Bartlett Kindergarten Center   Regular School No Elementary KG KG 2017   kindergarten 55 7 87 0   1     0   1   88 63                       151 55 7 87 0   1     0   1   88 63                 151
1126360 1126360 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2017   kindergarten 7 7 9 0   4     0   4   13 18                       31 7 7 9 0   4     0   4   13 18                 31
1126403 1126403 MA Essex   school 2507110 163   Lynn 250711001070 1630045 E J Harrington   Regular School No Elementary PK 05 2017   kindergarten 11 7 63 0   5     0   1   58 29                       87 11 7 63 0   5     0   1   58 29                 87
1126424 1126424 MA Essex   school 2507110 163   Lynn 250711001075 1630060 Ingalls   Regular School No Elementary KG 05 2017   kindergarten 11 7 77 1   11     0   2   56 53                       109 11 7 77 1   11     0   2   56 53                 109
1126600 1126600 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No Elementary KG 02 2017   kindergarten 184 7 14 0   16     0   11   116 116                       232 184 7 14 0   16     0   11   116 116                 232
1126877 1126877 MA Middlesex   school 2507620 178   Melrose 250762001192 1780020 Lincoln   Regular School No Elementary KG 05 2017   kindergarten 43 7 11 0   13     0   3   36 41                       77 43 7 11 0   13     0   3   36 41                 77
1128663 1128663 MA Essex   school 2510380 258   Salem 251038001668 2580070 Witchcraft Heights   Regular School No Elementary KG 05 2017   kindergarten 35 7 25 0   2     0   4   37 36                       73 35 7 25 0   2     0   4   37 36                 73
1129270 1129270 MA Hampden   school 2511130 281   Springfield 251113001829 2810155 Mary M Walsh   Regular School No Elementary KG 05 2017   kindergarten 9 7 31 0   1     0   3   27 24                       51 9 7 31 0   1     0   3   27 24                 51
1129474 1129474 MA Norfolk   school 2511250 285   Stoughton 251125001858 2850010 Helen Hansen Elementary   Regular School No Elementary KG 05 2017   kindergarten 26 7 4 0   1     0   1   19 20                       39 26 7 4 0   1     0   1   19 20                 39
1129677 1129677 MA Bristol   school 2511520 293   Taunton 251152001909 2930035 Hopewell   Regular School No Elementary KG 04 2017   kindergarten 41 7 7 1   0     0   3   27 32                       59 41 7 7 1   0     0   3   27 32                 59
1129712 1129712 MA Middlesex   school 2511580 295   Tewksbury 251158001922 2950001 L F Dewing   Regular School No Elementary PK 02 2017   kindergarten 128 7 8 0   5     1   0   75 74                       149 128 7 8 0   5     1   0   75 74                 149
1130810 1130810 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No Elementary PK 06 2017   kindergarten 13 7 40 0   2     0   1   37 26                       63 13 7 40 0   2     0   1   37 26                 63
1130897 1130897 MA Worcester   school 2513230 348   Worcester 251323002231 3480175 May Street   Regular School No Elementary KG 06 2017   kindergarten 16 7 12 0   7     0   7   20 29                       49 16 7 12 0   7     0   7   20 29                 49
1130922 1130922 MA Worcester   school 2513230 348   Worcester 251323002236 3480200 Nelson Place   Regular School No Elementary KG 06 2017   kindergarten 37 7 15 0   4     0   4   37 30                       67 37 7 15 0   4     0   4   37 30                 67
1131101 1131101 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 07 2017   kindergarten 7 7 23 0   0     0   1   16 22                       38 7 7 23 0   0     0   1   16 22                 38
1122922 1122922 MA Suffolk   school 2502790 35   Boston 250279000290 350226 Mattahunt   Regular School No Elementary PK 05 2017   kindergarten 3 68 34 0   1     0   2   49 59                       108 3 68 34 0   1     0   2   49 59                 108
1123634 1123634 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Huntington   Regular School No Elementary KG 05 2017   kindergarten 5 61 7 1   0     0   1   36 39                       75 5 61 7 1   0     0   1   36 39                 75
1122054 1122054 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2017   kindergarten 19 6 12 0   5     0   0   16 26                       42 19 6 12 0   5     0   0   16 26                 42
1122281 1122281 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2017   kindergarten 29 6 4 0   2     0   5   27 19                       46 29 6 4 0   2     0   5   27 19                 46
1122496 1122496 MA Middlesex   school 2502670 31   Billerica 250267000186 310005 Thomas Ditson   Regular School No Elementary KG 05 2017   kindergarten 76 6 5 0   5     0   2   46 48                       94 76 6 5 0   5     0   2   46 48                 94
1122517 1122517 MA Middlesex   school 2502670 31   Billerica 250267000184 310015 Parker   Regular School No Elementary KG 05 2017   kindergarten 58 6 9 0   7     0   3   49 34                       83 58 6 9 0   7     0   3   49 34                 83
1122693 1122693 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2017   kindergarten 16 6 14 0   0     0   2   19 19                       38 16 6 14 0   0     0   2   19 19                 38
1122895 1122895 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2017   kindergarten 24 6 9 0   2     0   2   27 16                       43 24 6 9 0   2     0   2   27 16                 43
1122956 1122956 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No Elementary PK 05 2017   kindergarten 12 6 6 0   1     0   2   19 8                       27 12 6 6 0   1     0   2   19 8                 27
1123788 1123788 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No Elementary KG 08 2017   kindergarten 51 6 8 0   20     0   11   52 44                       96 51 6 8 0   20     0   11   52 44                 96
1124048 1124048 MA Middlesex   school 2503510 56   Chelmsford 250351000474 560025 Charles D Harrington   Regular School No Elementary KG 04 2017   kindergarten 61 6 6 0   14     0   5   47 45                       92 61 6 6 0   14     0   5   47 45                 92
1124217 1124217 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton Elementary   Regular School No Elementary PK 03 2017   kindergarten 94 6 34 0   2     0   3   66 73                       139 94 6 34 0   2     0   3   66 73                 139
1124713 1124713 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No Elementary PK 05 2017   kindergarten 63 6 31 0   2     0   8   53 57                       110 63 6 31 0   2     0   8   53 57                 110
1124743 1124743 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No Elementary PK 08 2017   kindergarten 35 6 19 0   0     0   11   42 29                       71 35 6 19 0   0     0   11   42 29                 71
1124765 1124765 MA Bristol   school 2504830 95   Fall River 250483000684 950065 William S Greene   Regular School No Elementary PK 05 2017   kindergarten 57 6 38 0   8     0   9   56 62                       118 57 6 38 0   8     0   9   56 62                 118
1124874 1124874 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No Elementary KG 04 2017   kindergarten 46 6 59 0   5     0   10   74 52                       126 46 6 59 0   5     0   10   74 52                 126
1125013 1125013 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2017   kindergarten 45 6 23 1   0     0   2   36 41                       77 45 6 23 1   0     0   2   36 41                 77
1125067 1125067 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No Elementary KG 05 2017   kindergarten 51 6 1 1   5     1   0   35 30                       65 51 6 1 1   5     1   0   35 30                 65
1125387 1125387 MA Essex   school 2505970 128   Haverhill 250597000851 1280020 Crowell   Regular School No Elementary KG KG 2017   kindergarten 53 6 85 1   1     0   4   80 70                       150 53 6 85 1   1     0   4   80 70                 150
1125720 1125720 MA Essex   school 2506480 144   Ipswich 250648000939 1440015 Winthrop   Regular School No Elementary PK 05 2017   kindergarten 33 6 3 1   0     0   5   26 22                       48 33 6 3 1   0     0   5   26 22                 48
1126213 1126213 MA Middlesex   school 2507020 160   Lowell 250702001045 1600040 Peter W Reilly   Regular School No Elementary KG 04 2017   kindergarten 46 6 33 0   9     0   2   38 58                       96 46 6 33 0   9     0   2   38 58                 96
1127054 1127054 MA Norfolk   school 2507980 189   Milton 250798001259 1890005 Collicot   Regular School No Elementary PK 05 2017   kindergarten 90 6 5 0   12     0   5   64 54                       118 90 6 5 0   12     0   5   64 54                 118
1127069 1127069 MA Norfolk   school 2507980 189   Milton 250798001261 1890010 Glover   Regular School No Elementary KG 05 2017   kindergarten 70 6 0 0   4     0   7   43 44                       87 70 6 0 0   4     0   7   43 44                 87

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