Data source: Big Local News · About: Big Local

3,669 rows where grade = "pre_kindergarten" and state = "MA" sorted by black descending

View and edit SQL

year

grade

  • pre_kindergarten · 3,669
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
737038 MA Norfolk   school 2502940 40   Braintree 250294000361 400505 Braintree High   Regular School No 3 09 12 2015   pre_kindergarten 81 9 1 1   11     0   3   61 45                       106 81 9 1 1   11     0   3   61 45                 106
737327 MA Middlesex   school 2503270 49   Cambridge 250327000441 490020 Haggerty   Regular School No 1 PK 05 2015   pre_kindergarten 14 9 2 0   2     0   1   13 15                       28 14 9 2 0   2     0   1   13 15                 28
739281 MA Middlesex   school 2507020 160   Lowell 250702001044 1600036 Pawtucketville Memorial   Regular School No 1 PK 04 2015   pre_kindergarten 12 9 15 0   7     0   2   28 17                       45 12 9 15 0   7     0   2   28 17                 45
739443 MA Essex   school 2507110 163   Lynn 250711001070 1630045 E J Harrington   Regular School No 1 PK 05 2015   pre_kindergarten 15 9 49 1   9     0   4   45 42                       87 15 9 49 1   9     0   4   45 42                 87
739832 MA Middlesex   school 2507620 178   Melrose 250762001800 1780003 Early Childhood Center   Regular School No 1 PK PK 2015   pre_kindergarten 272 9 4 0   11     0   17   170 143                       313 272 9 4 0   11     0   17   170 143                 313
741093 MA Norfolk   school 2509870 243   Quincy 250987001582 2430090 Snug Harbor Community School   Regular School No 1 PK 05 2015   pre_kindergarten 55 9 5 0   44     0   6   72 47                       119 55 9 5 0   44     0   6   72 47                 119
741751 MA Hampden   school 2511130 281   Springfield 251113001833 2810015 Thomas M Balliet   Regular School No 1 PK 05 2015   pre_kindergarten 6 9 26 1   1     0   0   24 19                       43 6 9 26 1   1     0   0   24 19                 43
743065 MA Middlesex   school 2513200 347   Woburn 251320002191 3470043 Shamrock   Regular School No 1 PK 05 2015   pre_kindergarten 72 9 14 0   22     0   7   79 45                       124 72 9 14 0   22     0   7   79 45                 124
743185 MA Worcester   school 2513230 348   Worcester 251323002211 3480095 Elm Park Community   Regular School No 1 PK 06 2015   pre_kindergarten 7 9 17 0   1     0   0   21 13                       34 7 9 17 0   1     0   0   21 13                 34
743224 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No 1 PK 06 2015   pre_kindergarten 5 9 25 0   2     0   6   20 27                       47 5 9 25 0   2     0   6   20 27                 47
933197 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No 1 PK 08 2016   pre_kindergarten 16 9 13 0   3     0   1   23 19                       42 16 9 13 0   3     0   1   23 19                 42
933384 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No 1 PK 05 2016   pre_kindergarten 10 9 6 0   1     0   2   21 7                       28 10 9 6 0   1     0   2   21 7                 28
933451 MA Suffolk   school 2502790 35   Boston 250279000303 350266 Dr. William Henderson Lower   Regular School No 1 PK 03 2016   pre_kindergarten 19 9 10 0   7     0   2   27 20                       47 19 9 10 0   7     0   2   27 20                 47
933491 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Samuel W Mason   Regular School No 1 PK 05 2016   pre_kindergarten 3 9 7 0   2     0   3   11 13                       24 3 9 7 0   2     0   3   11 13                 24
933576 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No 1 PK 08 2016   pre_kindergarten 4 9 9 0   8     0   1   11 20                       31 4 9 9 0   8     0   1   11 20                 31
938636 MA Hampden   school 2511130 281   Springfield 251113001804 2810080 Frederick Harris   Regular School No 1 PK 05 2016   pre_kindergarten 18 9 14 0   1     0   3   27 18                       45 18 9 14 0   1     0   3   27 18                 45
1122558 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Baldwin Early Learning Center   Regular School No Elementary PK 01 2017   pre_kindergarten 19 9 22 0   27     0   5   47 35                       82 19 9 22 0   27     0   5   47 35                 82
1122572 MA Suffolk   school 2502790 35   Boston 250279002514 350006 ELC - West Zone   Regular School No Elementary PK 01 2017   pre_kindergarten 6 9 21 0   8     0   2   29 17                       46 6 9 21 0   8     0   2   29 17                 46
1122645 MA Suffolk   school 2502790 35   Boston 250279000214 350052 Charles Sumner   Regular School No Elementary PK 05 2017   pre_kindergarten 17 9 24 0   0     0   4   27 27                       54 17 9 24 0   0     0   4   27 27                 54
1123875 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridgeport   Regular School No Elementary PK 05 2017   pre_kindergarten 28 9 4 0   6     0   6   32 21                       53 28 9 4 0   6     0   6   32 21                 53
1127329 MA Bristol   school 2508430 201   New Bedford 250843001320 2010123 Casimir Pulaski   Regular School No Elementary PK 05 2017   pre_kindergarten 93 9 18 0   3     0   4   74 53                       127 93 9 18 0   3     0   4   74 53                 127
1131899 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Mitchell Elementary School   Regular School No Elementary PK 03 2017   pre_kindergarten 111 9 1 0   2     1   3   73 54                       127 111 9 1 0   2     1   3   73 54                 127
1364784 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington Early Education Program   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 68 9 7 0   4     0   0   43 45 *                     88.0 68 9 7 0   4     0   0   43 45                 88
1365058 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2020   pre_kindergarten 6 9 3 0   1     0   3   11 11 *                     22.0 6 9 3 0   1     0   3   11 11                 22
1365071 MA Barnstable   school 2502310 20   Barnstable 250231002851 200001 Enoch Cobb Early Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 94 9 29 0   3     0   26   99 62 *                     161.0 94 9 29 0   3     0   26   99 62                 161
1366341 MA Norfolk   school 2503150 46   Brookline 250315002027 460060 The Lynch Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 22 9 5 0   11     0   10   33 24 *                     57.0 22 9 5 0   11     0   10   33 24                 57
1366398 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridgeport   Regular School No Elementary PK 05 2020   pre_kindergarten 25 9 6 0   8     0   6   29 23 *                     54.0 25 9 6 0   8     0   6   29 23                 54
1368112 MA Worcester   school 2506780 153   Leominster 250678000064 1530003 Bennett   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 56 9 35 0   2     0   11   59 54 *                     113.0 56 9 35 0   2     0   11   59 54                 113
1369776 MA Norfolk   school 2509060 220   Norwood 250906001557 2200075 George F. Willett   Regular School No Elementary PK KG 2020   pre_kindergarten 85 9 8 0   17     3   0   74 48 *                     122.0 85 9 8 0   17     3   0   74 48                 122
1370602 MA Worcester   school 2510770 271   Shrewsbury 251077001559 2710040 Parker Road Preschool   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 104 9 11 2   97     0   7   131 99 *                     230.0 104 9 11 2   97     0   7   131 99                 230
1370813 MA Hampden   school 2511130 281   Springfield 251113001801 2810030 Elias Brookings   Regular School No Elementary PK 05 2020   pre_kindergarten 0 9 35 0   1     0   1   26 20 *                     46.0 0 9 35 0   1     0   1   26 20                 46
1370865 MA Hampden   school 2511130 281   Springfield 251113001804 2810080 Frederick Harris   Regular School No Elementary PK 05 2020   pre_kindergarten 17 9 30 1   6     0   1   29 35 *                     64.0 17 9 30 1   6     0   1   29 35                 64
1371129 MA Norfolk   school 2511250 285   Stoughton 251125001866 2850020 Richard L. Wilkins Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 15 9 4 1   0     1   0   16 14 *                     30.0 15 9 4 1   0     1   0   16 14                 30
1371476 MA Middlesex   school 2512000 308   Waltham 251200001974 3080040 Northeast Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 37 9 13 0   10     0   4   41 32 *                     73.0 37 9 13 0   10     0   4   41 32                 73
1371835 MA Hampden   school 2512510 332   West Springfield 251251002757 3320001 Cowing Early Childhood   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 59 9 40 0   13     0   3   71 53 *                     124.0 59 9 40 0   13     0   3   71 53                 124
1372095 MA Middlesex   school 2513200 347   Woburn 251320002191 3470043 Shamrock   Regular School No Elementary PK 05 2020   pre_kindergarten 77 9 13 0   13     0   3   61 54 *                     115.0 77 9 13 0   13     0   3   61 54                 115
1672829 MA Suffolk   school 2502790 35   Boston 250279000289 350227 Boston - Mather   Regular School No Elementary PK 05 2021   pre_kindergarten 0 9 4 0   15     0   1   11 18 *                     29.0 0 9 4 0   15     0   1   11 18                 29
1674107 MA Middlesex   school 2504320 79   Dracut 250432000583 790020 Dracut - Joseph A Campbell Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten 19 9 5 0   7     0   0   24 16 *                     40.0 19 9 5 0   7     0   0   24 16                 40
1676148 MA Middlesex   school 2507620 178   Melrose 250762001800 1780003 Melrose - Early Childhood Center   Regular School No Elementary PK KG 2021   pre_kindergarten 87 9 6 2   6     0   8   66 52 *                     118.0 87 9 6 2   6     0   8   66 52                 118
1678035 MA Hampden   school 2511130 281   Springfield 251113001794 2810010 Springfield - Edward P. Boland School   Regular School No Elementary PK 05 2021   pre_kindergarten 12 9 122 0   0     0   4   85 62 *                     147.0 12 9 122 0   0     0   4   85 62                 147
1679776 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public (District) - Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2021   pre_kindergarten 1 9 5 0   2     0   2   11 8 *                     19.0 1 9 5 0   2     0   2   11 8                 19
2039810 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington Early Education Program   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 71 9 9 0   1     0   0   45 45                       90.0 71 9 9 0   1     0   0   45 45                 90
2040007 MA Middlesex   school 2502100 14   Ashland 250210002455 140005 William Pittaway Elementary   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 74 9 0 1   30     0   2   68 48                       116.0 74 9 0 1   30     0   2   68 48                 116
2040026 MA Bristol   school 2502190 16   Attleboro 250219001610 160008 Early Learning Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 133 9 19 0   7     0   11   107 72                       179.0 133 9 19 0   7     0   11   107 72                 179
2040226 MA Essex   school 2502640 30   Beverly 250264002854 300002 McKeown School   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 96 9 10 1   5     0   2   78 45                       123.0 96 9 10 1   5     0   2   78 45                 123
2041467 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridgeport   Regular School No Elementary PK 05 2019   pre_kindergarten 24 9 5 0   6     0   7   26 25                       51.0 24 9 5 0   6     0   7   26 25                 51
2041502 MA Middlesex   school 2503270 49   Cambridge 250327000446 490045 Morse   Regular School No Elementary PK 05 2019   pre_kindergarten 15 9 6 0   12     0   3   24 21                       45.0 15 9 6 0   12     0   3   24 21                 45
2041946 MA Middlesex   school 2504320 79   Dracut 250432000583 790020 Joseph A Campbell Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten 41 9 3 0   4     0   0   39 18                       57.0 41 9 3 0   4     0   0   39 18                 57
2043946 MA Middlesex   school 2507560 176   Medford 250756001176 1760505 Medford High   Regular School No High 09 12 2019   pre_kindergarten 29 9 5 1   12     0   3   40 19                       59.0 29 9 5 1   12     0   3   40 19                 59
2044509 MA Middlesex   school 2508610 207   Newton 250861001657 2070108 Newton Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 120 9 12 0   55     0   16   126 86                       212.0 120 9 12 0   55     0   16   126 86                 212
2045677 MA Worcester   school 2510770 271   Shrewsbury 251077001559 2710040 Parker Road Preschool   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 109 9 11 1   106     0   6   126 116                       242.0 109 9 11 1   106     0   6   126 116                 242
2046909 MA Hampden   school 2512510 332   West Springfield 251251002757 3320001 Cowing Early Childhood   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 58 9 28 0   18     0   3   74 42                       116.0 58 9 28 0   18     0   3   74 42                 116
2048303 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Marguerite E Small Elementary   Regular School No Elementary PK 03 2019   pre_kindergarten 40 9 9 3   0     0   0   39 22                       61.0 40 9 9 3   0     0   0   39 22                 61
2228754 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington: Abington Early Education Program   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 70 9 1 0   4     0   0   45 39                       84.0 70 9 1 0   4     0   0   45 39                 84
2229354 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica: Billerica Memorial High School   Regular School No High 09 12 2018   pre_kindergarten 98 9 12 0   20     0   5   85 59                       144.0 98 9 12 0   20     0   5   85 59                 144
2229447 MA Suffolk   school 2502790 35   Boston 250279000198 350021 Boston: Beethoven   Regular School No Elementary PK 03 2018   pre_kindergarten 20 9 10 0   3     0   2   20 24                       44.0 20 9 10 0   3     0   2   20 24                 44
2229507 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Boston: Dennis C Haley   Regular School No Elementary PK 08 2018   pre_kindergarten 12 9 6 0   0     0   0   16 11                       27.0 12 9 6 0   0     0   0   16 11                 27
2229710 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Boston: Joyce Kilmer   Regular School No Elementary PK 08 2018   pre_kindergarten 24 9 6 0   0     0   5   27 17                       44.0 24 9 6 0   0     0   5   27 17                 44
2230790 MA Norfolk   school 2503300 50   Canton 250330002635 500010 Canton: Rodman Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 56 9 9 0   8     0   6   56 32                       88.0 56 9 9 0   8     0   6   56 32                 88
2231254 MA Middlesex   school 2504320 79   Dracut 250432000583 790020 Dracut: Joseph A Campbell Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten 41 9 1 0   4     0   1   36 20                       56.0 41 9 1 0   4     0   1   36 20                 56
2234724 MA Norfolk   school 2509060 220   Norwood 250906001557 2200075 Norwood: George F. Willett   Regular School No Elementary PK KG 2018   pre_kindergarten 75 9 9 0   14     1   1   61 48                       109.0 75 9 9 0   14     1   1   61 48                 109
2235093 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown: Provincetown Schools   Regular School No Elementary PK 08 2018   pre_kindergarten 7 9 1 0   0     0   1   10 8                       18.0 7 9 1 0   0     0   1   10 8                 18
2235160 MA Norfolk   school 2509870 243   Quincy 250987001582 2430090 Quincy: Snug Harbor Community School   Regular School No Elementary PK 05 2018   pre_kindergarten 60 9 12 0   61     0   7   78 71                       149.0 60 9 12 0   61     0   7   78 71                 149
2235921 MA Hampden   school 2511130 281   Springfield 251113001833 2810015 Springfield: Thomas M Balliet   Regular School No Elementary PK 05 2018   pre_kindergarten 7 9 30 0   1     0   5   33 19                       52.0 7 9 30 0   1     0   5   33 19                 52
2235951 MA Hampden   school 2511130 281   Springfield 251113001801 2810030 Springfield: Elias Brookings   Regular School No Elementary PK 05 2018   pre_kindergarten 3 9 38 0   0     0   2   22 30                       52.0 3 9 38 0   0     0   2   22 30                 52
2236068 MA Hampden   school 2511130 281   Springfield 251113001820 2810125 Springfield: Mary A. Dryden Veterans Memorial School   Regular School No Elementary PK 05 2018   pre_kindergarten 19 9 18 0   7     0   3   33 23                       56.0 19 9 18 0   7     0   3   33 23                 56
2236315 MA Norfolk   school 2511250 285   Stoughton 251125001866 2850020 Stoughton: West Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten 9 9 7 0   2     0   0   9 18                       27.0 9 9 7 0   2     0   0   9 18                 27
2237175 MA Hampden   school 2512510 332   West Springfield 251251002757 3320001 West Springfield: Cowing Early Childhood   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 71 9 24 0   13     0   5   74 48                       122.0 71 9 24 0   13     0   5   74 48                 122
2237281 MA Norfolk   school 2512840 336   Weymouth 251284000371 3360003 Weymouth: Johnson Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 135 9 13 1   26     0   9   109 84                       193.0 135 9 13 1   26     0   9   109 84                 193
2237562 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Worcester: Belmont Street Community   Regular School No Elementary PK 06 2018   pre_kindergarten 14 9 18 0   5     0   3   23 26                       49.0 14 9 18 0   5     0   3   23 26                 49
2237782 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Worcester: Roosevelt   Regular School No Elementary PK 06 2018   pre_kindergarten 29 9 18 0   5     0   6   29 38                       67.0 29 9 18 0   5     0   6   29 38                 67
940621 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes 1 PK 06 2016   pre_kindergarten 1 89 53 0   0     0   4   64 83                       147 1 89 53 0   0     0   4   64 83                 147
737106 MA Plymouth   school 2503090 44   Brockton 250309000221 440050 Gilmore School Early Childhood Center   Regular School No 1 PK KG 2015   pre_kindergarten 95 87 39 1   7     0   17   158 88                       246 95 87 39 1   7     0   17   158 88                 246
1372123 MA Worcester   school 2513230 348   Worcester 251323002684 3480002 Head Start   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 253 86 23 3   13     0   15   191 202 *                     393.0 253 86 23 3   13     0   15   191 202                 393
1131528 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2017   pre_kindergarten 7 85 42 1   0     0   5   72 68                       140 7 85 42 1   0     0   5   72 68                 140
735736 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No 1 PK 06 2015   pre_kindergarten 29 8 7 0   16     0   1   35 26                       61 29 8 7 0   16     0   1   35 26                 61
736427 MA Suffolk   school 2502790 35   Boston 250279000275 350181 Joseph P Tynan   Regular School No 1 PK 05 2015   pre_kindergarten 16 8 14 0   2     0   1   28 13                       41 16 8 14 0   2     0   1   28 13                 41
736522 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No 1 PK 08 2015   pre_kindergarten 13 8 4 0   11     0   0   25 11                       36 13 8 4 0   11     0   0   25 11                 36
736609 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Roger Clap   Regular School No 1 PK 05 2015   pre_kindergarten 5 8 4 0   4     0   0   13 8                       21 5 8 4 0   4     0   0   13 8                 21
736708 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No 1 PK 08 2015   pre_kindergarten 5 8 12 0   2     0   0   7 20                       27 5 8 12 0   2     0   0   7 20                 27
737334 MA Middlesex   school 2503270 49   Cambridge 250327000443 490030 Martin Luther King Jr.   Regular School No 1 PK 05 2015   pre_kindergarten 10 8 5 0   11     0   5   17 22                       39 10 8 5 0   11     0   5   17 22                 39
738708 MA Hampden   school 2506270 137   Holyoke 250627001178 1370003 Joseph Metcalf School   Regular School No 1 PK KG 2015   pre_kindergarten 56 8 128 0   3     0   6   122 79                       201 56 8 128 0   3     0   6   122 79                 201
739188 MA Middlesex   school 2506960 158   Littleton 250696001014 1580005 Shaker Lane Elementary   Regular School No 1 PK 02 2015   pre_kindergarten 49 8 3 2   4     1   0   32 35                       67 49 8 3 2   4     1   0   32 35                 67
739423 MA Essex   school 2507110 163   Lynn 250711001077 1630030 Julia F Callahan   Regular School No 1 PK 05 2015   pre_kindergarten 11 8 18 0   2     0   2   22 19                       41 11 8 18 0   2     0   2   22 19                 41
740166 MA Bristol   school 2508430 201   New Bedford 250843001341 2010045 Sgt Wm H Carney Academy   Regular School No 1 PK 05 2015   pre_kindergarten 38 8 12 1   0     0   6   41 24                       65 38 8 12 1   0     0   6   41 24                 65
740237 MA Bristol   school 2508430 201   New Bedford 250843002802 2010124 Renaissance Community School for the Arts   Regular School No 1 PK 03 2015   pre_kindergarten 6 8 16 0   0     0   2   16 16                       32 6 8 16 0   0     0   2   16 16                 32
743201 MA Worcester   school 2513230 348   Worcester 251323002217 3480110 Gates Lane   Regular School No 1 PK 06 2015   pre_kindergarten 21 8 21 0   7     0   6   43 20                       63 21 8 21 0   7     0   6   43 20                 63
933154 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No 1 PK 08 2016   pre_kindergarten 14 8 7 0   0     0   2   16 15                       31 14 8 7 0   0     0   2   16 15                 31
933623 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No 1 PK 08 2016   pre_kindergarten 13 8 7 0   1     0   1   12 18                       30 13 8 7 0   1     0   1   12 18                 30
934163 MA Middlesex   school 2503270 49   Cambridge 250327000435 490005 Maria L. Baldwin   Regular School No 1 PK 05 2016   pre_kindergarten 31 8 5 0   8     0   2   26 28                       54 31 8 5 0   8     0   2   26 28                 54
934215 MA Middlesex   school 2503270 49   Cambridge 250327000446 490045 Morse   Regular School No 1 PK 05 2016   pre_kindergarten 21 8 4 0   13     0   3   25 24                       49 21 8 4 0   13     0   3   25 24                 49
935441 MA Essex   school 2505970 128   Haverhill 250597000056 1280045 Moody   Regular School No 1 PK PK 2016   pre_kindergarten 138 8 47 1   3     0   2   130 69                       199 138 8 47 1   3     0   2   130 69                 199
936501 MA Middlesex   school 2507320 170   Marlborough 250732001368 1700006 Early Childhood Center   Regular School No 1 PK PK 2016   pre_kindergarten 73 8 27 0   18     0   5   74 57                       131 73 8 27 0   18     0   5   74 57                 131
936677 MA Middlesex   school 2507620 178   Melrose 250762001800 1780003 Early Childhood Center   Regular School No 1 PK PK 2016   pre_kindergarten 244 8 7 0   13     0   21   150 143                       293 244 8 7 0   13     0   21   150 143                 293
937010 MA Bristol   school 2508430 201   New Bedford 250843001341 2010045 Sgt Wm H Carney Academy   Regular School No 1 PK 05 2016   pre_kindergarten 35 8 17 1   0     0   6   42 25                       67 35 8 17 1   0     0   6   42 25                 67
937023 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 Alfred J Gomes   Regular School No 1 PK 05 2016   pre_kindergarten 41 8 59 0   0     0   7   72 43                       115 41 8 59 0   0     0   7   72 43                 115
937041 MA Bristol   school 2508430 201   New Bedford 250843001327 2010078 Hayden/McFadden   Regular School No 1 PK 05 2016   pre_kindergarten 22 8 32 0   1     0   1   36 28                       64 22 8 32 0   1     0   1   36 28                 64
937208 MA Middlesex   school 2508610 207   Newton 250861001657 2070108 Newton Early Childhood Center   Regular School No 1 PK PK 2016   pre_kindergarten 108 8 19 1   37     0   15   120 68                       188 108 8 19 1   37     0   15   120 68                 188
937326 MA Essex   school 2508700 211   North Andover 250870001393 2110001 Atkinson   Regular School No 1 PK 05 2016   pre_kindergarten 87 8 9 1   21     0   3   76 53                       129 87 8 9 1   21     0   3   76 53                 129
937922 MA Norfolk   school 2509870 243   Quincy 250987001582 2430090 Snug Harbor Community School   Regular School No 1 PK 05 2016   pre_kindergarten 56 8 3 0   47     0   8   74 48                       122 56 8 3 0   47     0   8   74 48                 122

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