Data source: Big Local News · About: Big Local

529 rows where grade = "pre_kindergarten", state = "MA" and year = 2019 sorted by total

View and edit SQL

year

  • 2019 · 529

grade

  • pre_kindergarten · 529
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
2040564 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No Elementary PK 05 2019   pre_kindergarten 4 2 3 0   0     0   1   7 3                       10.0 4 2 3 0   0     0   1   7 3                 10
2040608 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Joseph P Manning   Regular School No Elementary PK 05 2019   pre_kindergarten 3 1 4 0   1     0   1   3 7                       10.0 3 1 4 0   1     0   1   3 7                 10
2042695 MA Worcester   school 2505880 125   Harvard 250588000839 1250005 Hildreth Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten 6 0 0 0   3     0   1   5 5                       10.0 6 0 0 0   3     0   1   5 5                 10
2048803 MA Essex   school 2509450 745   Pentucket 250945000408 7450015 Dr John C Page School   Regular School No Elementary PK 06 2019   pre_kindergarten 10 0 0 0   0     0   0   7 3                       10.0 10 0 0 0   0     0   0   7 3                 10
2046686 MA Norfolk   school 2512270 317   Wellesley 251227002893 3170001 Preschool at Wellesley Schools   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 55 2 11 0   25     0   7   56 44                       100.0 55 2 11 0   25     0   7   56 44                 100
2043196 MA Worcester   school 2506780 153   Leominster 250678000064 1530003 Bennett   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 51 11 30 0   3     0   6   63 38                       101.0 51 11 30 0   3     0   6   63 38                 101
2045356 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2019   pre_kindergarten 66 0 34 0   1     0   0   61 40                       101.0 66 0 34 0   1     0   0   61 40                 101
2040373 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2019   pre_kindergarten 47 13 29 0   4     0   10   62 41                       103.0 47 13 29 0   4     0   10   62 41                 103
2043044 MA Essex   school 2506660 149   Lawrence 250666002651 1490001 Rollins Early Childhood Center   Regular School No Elementary PK KG 2019   pre_kindergarten 7 2 93 0   1     0   0   60 43                       103.0 7 2 93 0   1     0   0   60 43                 103
2043359 MA Middlesex   school 2507020 160   Lowell 250702002891 1600001 Cardinal O'Connell Early Learning Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 20 7 47 0   26     0   4   70 34                       104.0 20 7 47 0   26     0   4   70 34                 104
2043540 MA Essex   school 2507110 163   Lynn 250711002801 1630004 Early Childhood Center   Regular School No Elementary PK 05 2019   pre_kindergarten 16 20 54 1   12     0   1   77 27                       104.0 16 20 54 1   12     0   1   77 27                 104
2049140 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman Hanson Regional   Regular School No High 09 12 2019   pre_kindergarten 91 4 4 0   0     0   5   59 45                       104.0 91 4 4 0   0     0   5   59 45                 104
2044362 MA Bristol   school 2508430 201   New Bedford 250843001320 2010123 Casimir Pulaski   Regular School No Elementary PK 05 2019   pre_kindergarten 72 11 19 0   1     0   2   58 47                       105.0 72 11 19 0   1     0   2   58 47                 105
2044848 MA Norfolk   school 2509060 220   Norwood 250906001557 2200075 George F. Willett   Regular School No Elementary PK KG 2019   pre_kindergarten 73 8 5 0   15     4   0   63 42                       105.0 73 8 5 0   15     4   0   63 42                 105
2048052 MA Middlesex   school 2501710 600   Acton-Boxborough 250171002867 6000001 Carol Huebner Early Childhood Program   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 45 6 8 0   36     0   10   57 48                       105.0 45 6 8 0   36     0   10   57 48                 105
2041444 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington High   Regular School No Other 09 12 2019   pre_kindergarten 58 12 6 0   27     0   3   57 49                       106.0 58 12 6 0   27     0   3   57 49                 106
2042463 MA Norfolk   school 2505010 101   Franklin 250501000986 1010003 Franklin Early Childhood Development Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 83 1 4 1   2     11   5   61 46                       107.0 83 1 4 1   2     11   5   61 46                 107
2041797 MA Middlesex   school 2503840 67   Concord 250384000525 670020 Thoreau   Regular School No Elementary PK 05 2019   pre_kindergarten 8 0 2 0   1     0   0   8 3                       11.0 8 0 2 0   1     0   0   8 3                 11
2041868 MA Bristol   school 2504020 72   Dartmouth 250402000542 720030 George H Potter   Regular School No Elementary PK 05 2019   pre_kindergarten 10 0 0 0   0     0   1   7 4                       11.0 10 0 0 0   0     0   1   7 4                 11
2042066 MA Bristol   school 2504620 88   Easton 250462002381 880020 Moreau Hall   Regular School No Elementary PK 02 2019   pre_kindergarten 11 0 0 0   0     0   0   3 8                       11.0 11 0 0 0   0     0   0   3 8                 11
2048916 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 New Marlborough Central   Regular School No Elementary PK 04 2019   pre_kindergarten 9 0 1 0   0     0   1   5 6                       11.0 9 0 1 0   0     0   1   5 6                 11
2046053 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 German Gerena Community School   Regular School No Elementary PK 05 2019   pre_kindergarten 7 15 80 1   1     0   6   43 67                       110.0 7 15 80 1   1     0   6   43 67                 110
2048906 MA Plymouth   school 2510830 760   Silver Lake 251083001722 7600505 Silver Lake Regional High   Regular School No High 09 12 2019   pre_kindergarten 111 0 0 0   0     0   0   65 46                       111.0 111 0 0 0   0     0   0   65 46                 111
2043752 MA Bristol   school 2507230 167   Mansfield 250723001004 1670003 Roland Green School   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 87 3 9 0   11     0   4   69 45                       114.0 87 3 9 0   11     0   4   69 45                 114
2042289 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No Elementary PK 04 2019   pre_kindergarten 87 3 16 0   4     0   5   73 42                       115.0 87 3 16 0   4     0   5   73 42                 115
2045299 MA Middlesex   school 2509990 246   Reading 250999002751 2460001 RISE PreSchool   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 98 2 3 1   9     0   2   71 44                       115.0 98 2 3 1   9     0   2   71 44                 115
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
2046844 MA Middlesex   school 2512660 326   Westford 251266001572 3260013 Millennium Elementary   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 59 2 3 1   42     0   9   67 49                       116.0 59 2 3 1   42     0   9   67 49                 116
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
2047905 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2019   pre_kindergarten 5 68 37 0   0     0   6   54 62                       116.0 5 68 37 0   0     0   6   54 62                 116
2044940 MA Essex   school 2509360 229   Peabody 250936001821 2290016 John E. McCarthy   Regular School No Elementary PK 05 2019   pre_kindergarten 99 3 14 0   0     0   3   71 48                       119.0 99 3 14 0   0     0   3   71 48                 119
2042974 MA Middlesex   school 2506390 141   Hudson 250639000924 1410007 Mulready Elementary   Regular School No Elementary PK 04 2019   pre_kindergarten 9 2 0 0   1     0   0   7 5                       12.0 9 2 0 0   1     0   0   7 5                 12
2043926 MA Middlesex   school 2507560 176   Medford 250756002057 1760140 Christopher Columbus   Regular School No Elementary PK 05 2019   pre_kindergarten 5 4 0 1   1     0   1   10 2                       12.0 5 4 0 1   1     0   1   10 2                 12
2044858 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No Elementary PK 08 2019   pre_kindergarten 6 0 3 0   2     0   1   6 6                       12.0 6 0 3 0   2     0   1   6 6                 12
2047241 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2019   pre_kindergarten 6 0 5 0   1     0   0   5 7                       12.0 6 0 5 0   1     0   0   5 7                 12
2048421 MA Hampden   school 2505160 672   Gateway 250516000757 6720059 Chester Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten 11 0 1 0   0     0   0   5 7                       12.0 11 0 1 0   0     0   0   5 7                 12
2048641 MA Berkshire   school 2508160 715   Mount Greylock 250816002899 7150010 Williamstown Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten 7 0 2 0   0     0   3   8 4                       12.0 7 0 2 0   0     0   3   8 4                 12
2045911 MA Hampden   school 2511130 281   Springfield 251113000341 2810055 Rebecca M Johnson   Regular School No Elementary PK 05 2019   pre_kindergarten 9 28 80 0   0     0   3   66 54                       120.0 9 28 80 0   0     0   3   66 54                 120
2042623 MA Franklin   school 2505490 114   Greenfield 250549002128 1140005 The Academy of Early Learning at North Parish   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 104 2 11 0   1     0   3   64 57                       121.0 104 2 11 0   1     0   3   64 57                 121
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
2041188 MA Norfolk   school 2502940 40   Braintree 250294000361 400505 Braintree High   Regular School No High 09 12 2019   pre_kindergarten 72 5 3 1   38     0   4   73 50                       123.0 72 5 3 1   38     0   4   73 50                 123
2042559 MA Essex   school 2505280 107   Gloucester 250528002574 1070025 Gloucester PreSchool   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 103 5 6 0   2     0   7   71 52                       123.0 103 5 6 0   2     0   7   71 52                 123
2047167 MA Middlesex   school 2513200 347   Woburn 251320002191 3470043 Shamrock   Regular School No Elementary PK 05 2019   pre_kindergarten 81 14 13 0   13     0   2   70 53                       123.0 81 14 13 0   13     0   2   70 53                 123
2045221 MA Norfolk   school 2509870 243   Quincy 250987001582 2430090 Snug Harbor Community School   Regular School No Elementary PK 05 2019   pre_kindergarten 52 4 8 1   50     0   11   69 57                       126.0 52 4 8 1   50     0   11   69 57                 126
2046752 MA Worcester   school 2512600 321   Westborough 251260002058 3210025 Elsie A Hastings Elementary   Regular School No Elementary PK 03 2019   pre_kindergarten 33 3 11 1   78     0   1   73 54                       127.0 33 3 11 1   78     0   1   73 54                 127
2044633 MA Essex   school 2508700 211   North Andover 250870002883 2110005 Anne Bradstreet Early Childhood Center   Regular School No Elementary PK KG 2019   pre_kindergarten 72 4 24 0   24     0   4   71 57                       128.0 72 4 24 0   24     0   4   71 57                 128
2040646 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2019   pre_kindergarten 1 4 7 0   1     0   0   6 7                       13.0 1 4 7 0   1     0   0   6 7                 13
2047042 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No Elementary PK 06 2019   pre_kindergarten 12 0 1 0   0     0   0   6 7                       13.0 12 0 1 0   0     0   0   6 7                 13
2047265 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No Elementary PK 06 2019   pre_kindergarten 6 4 1 0   2     0   0   10 3                       13.0 6 4 1 0   2     0   0   10 3                 13
2041994 MA Plymouth   school 2504440 83   East Bridgewater 250444000596 830005 Central   Regular School No Elementary PK 02 2019   pre_kindergarten 115 4 6 1   1     0   4   57 74                       131.0 115 4 6 1   1     0   4   57 74                 131
2044233 MA Middlesex   school 2508340 198   Natick 250834001303 1980505 Natick High   Regular School No High 09 12 2019   pre_kindergarten 84 4 7 0   34     0   3   71 61                       132.0 84 4 7 0   34     0   3   71 61                 132
2044686 MA Bristol   school 2508730 212   North Attleborough 250873001409 2120020 North Attleborough Early Learning Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 96 5 8 0   19     0   6   88 46                       134.0 96 5 8 0   19     0   6   88 46                 134
2048231 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Mitchell Elementary School   Regular School No Elementary PK 03 2019   pre_kindergarten 111 7 3 0   7     0   7   79 56                       135.0 111 7 3 0   7     0   7   79 56                 135
2041581 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No Elementary PK 08 2019   pre_kindergarten 11 0 1 0   0     0   2   8 6                       14.0 11 0 1 0   0     0   2   8 6                 14
2042165 MA Bristol   school 2504800 94   Fairhaven 250480000640 940010 East Fairhaven   Regular School No Elementary PK 05 2019   pre_kindergarten 12 0 2 0   0     0   0   7 7                       14.0 12 0 2 0   0     0   0   7 7                 14
2043153 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten 14 0 0 0   0     0   0   8 6                       14.0 14 0 0 0   0     0   0   8 6                 14
2043933 MA Middlesex   school 2507560 176   Medford 250756002062 1760150 Milton Fuller Roberts   Regular School No Elementary PK 05 2019   pre_kindergarten 10 0 1 0   3     0   0   6 8                       14.0 10 0 1 0   3     0   0   6 8                 14
2044158 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton High   Regular School No High 09 12 2019   pre_kindergarten 10 1 0 0   3     0   0   11 3                       14.0 10 1 0 0   3     0   0   11 3                 14
2045454 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten 12 0 1 0   0     0   1   9 5                       14.0 12 0 1 0   0     0   1   9 5                 14
2046631 MA Middlesex   school 2512180 314   Watertown 251218002002 3140025 James Russell Lowell   Regular School No Elementary PK 05 2019   pre_kindergarten 13 0 1 0   0     0   0   9 5                       14.0 13 0 1 0   0     0   0   9 5                 14
2046737 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten 13 0 0 0   0     0   1   10 4                       14.0 13 0 0 0   0     0   1   10 4                 14
2048510 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000822 6800005 Green Meadows Elementary   Regular School No Elementary PK 08 2019   pre_kindergarten 13 1 0 0   0     0   0   9 5                       14.0 13 1 0 0   0     0   0   9 5                 14
2048664 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Colrain Central   Regular School No Elementary PK 06 2019   pre_kindergarten 14 0 0 0   0     0   0   9 5                       14.0 14 0 0 0   0     0   0   9 5                 14
2046459 MA Middlesex   school 2511910 305   Wakefield 251191002826 3050001 Early Childhood Center at the Doyle School   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 109 3 15 0   8     2   5   85 57                       142.0 109 3 15 0   8     2   5   85 57                 142
2040101 MA Barnstable   school 2502310 20   Barnstable 250231002851 200001 Enoch Cobb Early Learning Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 78 15 30 1   1     0   21   88 58                       146.0 78 15 30 1   1     0   21   88 58                 146
2040754 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Roger Clap   Regular School No Elementary PK 05 2019   pre_kindergarten 3 2 6 0   4     0   0   5 10                       15.0 3 2 6 0   4     0   0   5 10                 15
2042008 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten 12 2 0 0   0     0   1   7 8                       15.0 12 2 0 0   0     0   1   7 8                 15
2046617 MA Middlesex   school 2512180 314   Watertown 251218001998 3140015 Cunniff   Regular School No Elementary PK 05 2019   pre_kindergarten 13 0 1 0   1     0   0   8 7                       15.0 13 0 1 0   1     0   0   8 7                 15
2048259 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten 15 0 0 0   0     0   0   6 9                       15.0 15 0 0 0   0     0   0   6 9                 15
2048633 MA Berkshire   school 2508160 715   Mount Greylock 250816002887 7150005 Lanesborough Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten 14 0 0 0   0     0   1   9 6                       15.0 14 0 0 0   0     0   1   9 6                 15
2041606 MA Middlesex   school 2503510 56   Chelmsford 250351002640 560001 Community Education Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 93 2 9 1   39     0   7   92 59                       151.0 93 2 9 1   39     0   7   92 59                 151
2049031 MA Worcester   school 2511880 775   Wachusett 251188002730 7750001 Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 128 5 13 0   4     0   4   94 60                       154.0 128 5 13 0   4     0   4   94 60                 154
2045094 MA Plymouth   school 2509720 239   Plymouth 250972000318 2390003 Plymouth Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 135 2 6 0   1     0   11   94 61                       155.0 135 2 6 0   1     0   11   94 61                 155
2045848 MA Hampden   school 2511130 281   Springfield 251113002853 2810001 Early Childhood Education Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 15 26 103 2   4     0   5   105 50                       155.0 15 26 103 2   4     0   5   105 50                 155
2045918 MA Hampden   school 2511130 281   Springfield 251113001817 2810060 Margaret C Ells   Regular School No Elementary PK 01 2019   pre_kindergarten 24 35 85 3   4     0   4   86 69                       155.0 24 35 85 3   4     0   4   86 69                 155
2041401 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No Elementary PK 08 2019   pre_kindergarten 7 0 2 0   4     0   3   8 8                       16.0 7 0 2 0   4     0   3   8 8                 16
2041814 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No Elementary PK 06 2019   pre_kindergarten 16 0 0 0   0     0   0   11 5                       16.0 16 0 0 0   0     0   0   11 5                 16
2048821 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Bernardston Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten 15 0 1 0   0     0   0   9 7                       16.0 15 0 1 0   0     0   0   9 7                 16
2044088 MA Worcester   school 2507860 185   Milford 250786001650 1850075 Shining Star Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 121 2 33 0   4     0   1   87 73                       161.0 121 2 33 0   4     0   1   87 73                 161
2039835 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 131 3 12 0   13     0   3   79 83                       162.0 131 3 12 0   13     0   3   79 83                 162
2040086 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2019   pre_kindergarten 8 5 2 0   2     0   0   9 8                       17.0 8 5 2 0   2     0   0   9 8                 17
2040400 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Charles H Taylor   Regular School No Elementary PK 05 2019   pre_kindergarten 0 13 3 0   0     0   1   10 7                       17.0 0 13 3 0   0     0   1   10 7                 17
2041354 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No Elementary PK 08 2019   pre_kindergarten 11 0 0 0   2     0   4   8 9                       17.0 11 0 0 0   2     0   4   8 9                 17
2042361 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   pre_kindergarten 17 0 0 0   0     0   0   9 8                       17.0 17 0 0 0   0     0   0   9 8                 17
2043241 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten 15 0 0 0   0     0   2   7 10                       17.0 15 0 0 0   0     0   2   7 10                 17
2045723 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No Elementary PK 08 2019   pre_kindergarten 2 3 8 0   2     0   2   5 12                       17.0 2 3 8 0   2     0   2   5 12                 17
2046488 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten 15 2 0 0   0     0   0   12 5                       17.0 15 2 0 0   0     0   0   12 5                 17
2047490 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2019   pre_kindergarten 13 0 1 2   0     0   1   10 7                       17.0 13 0 1 2   0     0   1   10 7                 17
2048834 MA Franklin   school 2509600 750   Pioneer Valley 250960002614 7500008 Northfield Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten 17 0 0 0   0     0   0   9 8                       17.0 17 0 0 0   0     0   0   9 8                 17
2046383 MA Middlesex   school 2511580 295   Tewksbury 251158001922 2950001 L F Dewing   Regular School No Elementary PK 02 2019   pre_kindergarten 139 7 8 0   13     0   6   91 82                       173.0 139 7 8 0   13     0   6   91 82                 173
2043797 MA Middlesex   school 2507320 170   Marlborough 250732001368 1700006 Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 91 12 42 0   20     3   7   95 80                       175.0 91 12 42 0   20     3   7   95 80                 175
2045174 MA Norfolk   school 2509870 243   Quincy 250987002807 2430005 Amelio Della Chiesa Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 51 15 11 3   88     1   8   107 70                       177.0 51 15 11 3   88     1   8   107 70                 177
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
2040489 MA Suffolk   school 2502790 35   Boston 250279000241 350122 George H Conley   Regular School No Elementary PK 05 2019   pre_kindergarten 7 6 4 0   0     1   0   9 9                       18.0 7 6 4 0   0     1   0   9 9                 18
2043014 MA Essex   school 2506480 144   Ipswich 250648000936 1440007 Paul F Doyon Memorial   Regular School No Elementary PK 05 2019   pre_kindergarten 16 0 2 0   0     0   0   5 13                       18.0 16 0 2 0   0     0   0   5 13                 18
2043912 MA Middlesex   school 2507560 176   Medford 250756001634 1760068 John J McGlynn Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten 7 3 4 0   4     0   0   11 7                       18.0 7 3 4 0   4     0   0   11 7                 18
2045064 MA Berkshire   school 2509630 236   Pittsfield 250963001535 2360105 Silvio O Conte Community   Regular School No Elementary PK 05 2019   pre_kindergarten 8 2 5 0   0     0   3   12 6                       18.0 8 2 5 0   0     0   3   12 6                 18
2045164 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2019   pre_kindergarten 9 5 3 0   0     0   1   9 9                       18.0 9 5 3 0   0     0   1   9 9                 18
2045685 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten 18 0 0 0   0     0   0   8 10                       18.0 18 0 0 0   0     0   0   8 10                 18
2045742 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2019   pre_kindergarten 13 0 2 0   3     0   0   11 7                       18.0 13 0 2 0   3     0   0   11 7                 18

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