Data source: Big Local News · About: Big Local

528 rows where grade = "pre_kindergarten", state = "MA" and year = 2018 sorted by total

View and edit SQL

year

  • 2018 · 528

grade

  • pre_kindergarten · 528
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
2230203 MA Suffolk   school   35   Boston   350652               2018   pre_kindergarten * * * *   *     *   *   * *                       0.0                                             0
2231637 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   pre_kindergarten * * * *   *     *   *   * *                       0.0                                             0
2232015 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   pre_kindergarten * * * *   *     *   *   * *                       0.0                                             0
2237221 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   pre_kindergarten * * * *   *     *   *   * *                       0.0                                             0
2231327 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham: Eastham Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten 6 1 1 0   1     0   1   7 3                       10.0 6 1 1 0   1     0   1   7 3                 10
2229436 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Boston: Curley K-8 School   Regular School No Elementary PK 08 2018   pre_kindergarten 35 13 40 1   4     0   7   66 34                       100.0 35 13 40 1   4     0   7   66 34                 100
2232355 MA Hampden   school 2506270 137   Holyoke 250627001178 1370003 Holyoke: Joseph Metcalf School   Regular School No Elementary PK 03 2018   pre_kindergarten 37 4 52 0   0     0   7   56 44                       100.0 37 4 52 0   0     0   7   56 44                 100
2233521 MA Plymouth   school 2507350 171   Marshfield 250735001137 1710015 Marshfield: Daniel Webster   Regular School No Elementary PK 05 2018   pre_kindergarten 97 0 1 0   2     0   0   52 48                       100.0 97 0 1 0   2     0   0   52 48                 100
2236896 MA Norfolk   school 2512270 317   Wellesley 251227002024 3170015 Wellesley: Joseph E Fiske   Regular School No Elementary PK 05 2018   pre_kindergarten 59 1 8 0   23     0   9   59 41                       100.0 59 1 8 0   23     0   9   59 41                 100
2231033 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton: Clinton Elementary   Regular School No Elementary PK 03 2018   pre_kindergarten 65 3 30 0   1     0   2   57 44                       101.0 65 3 30 0   1     0   2   57 44                 101
2236298 MA Norfolk   school 2511250 285   Stoughton 251125001860 2850012 Stoughton: Edwin A Jones Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 61 18 11 0   4     0   9   56 47                       103.0 61 18 11 0   4     0   9   56 47                 103
2231866 MA Norfolk   school 2505010 101   Franklin 250501000986 1010003 Franklin: Franklin Early Childhood Development Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 84 3 8 1   1     3   4   63 41                       104.0 84 3 8 1   1     3   4   63 41                 104
2236727 MA Middlesex   school 2512000 308   Waltham 251200001974 3080040 Waltham: Northeast Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten 50 14 17 0   22     0   2   65 40                       105.0 50 14 17 0   22     0   2   65 40                 105
2232341 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Holliston: Placentino Elementary   Regular School No Elementary PK 02 2018   pre_kindergarten 87 3 2 0   9     0   5   58 48                       106.0 87 3 2 0   9     0   5   58 48                 106
2231982 MA Essex   school 2505280 107   Gloucester 250528002574 1070025 Gloucester: Gloucester PreSchool   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 86 4 8 0   2     0   7   62 45                       107.0 86 4 8 0   2     0   7   62 45                 107
2233172 MA Essex   school 2507110 163   Lynn 250711002801 1630004 Lynn: Early Childhood Center   Regular School No Elementary PK 05 2018   pre_kindergarten 23 10 56 0   16     0   2   73 34                       107.0 23 10 56 0   16     0   2   73 34                 107
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
2229652 MA Suffolk   school 2502790 35   Boston 250279000264 350172 Boston: John D Philbrick   Regular School No Elementary PK 05 2018   pre_kindergarten 1 6 3 0   1     0   0   6 5                       11.0 1 6 3 0   1     0   0   6 5                 11
2232129 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock: Hancock Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten 10 1 0 0   0     0   0   7 4                       11.0 10 1 0 0   0     0   0   7 4                 11
2235570 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Savoy: Emma L Miller Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten 9 1 1 0   0     0   0   7 4                       11.0 9 1 1 0   0     0   0   7 4                 11
2237612 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Worcester: Chandler Magnet   Regular School No Elementary PK 06 2018   pre_kindergarten 4 0 6 0   1     0   0   4 7                       11.0 4 0 6 0   1     0   0   4 7                 11
2239123 MA Essex   school 2500067 698   Manchester Essex Regional 250006701110 6980010 Manchester Essex Regional: Manchester Memorial Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten 10 0 0 0   0     0   1   5 6                       11.0 10 0 0 0   0     0   1   5 6                 11
2229174 MA Norfolk   school 2502460 25   Bellingham 250246000670 250003 Bellingham: Bellingham Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 98 3 2 0   3     1   3   59 51                       110.0 98 3 2 0   3     1   3   59 51                 110
2237094 MA Middlesex   school 2512660 326   Westford 251266001572 3260013 Westford: Millennium Elementary   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 58 3 3 0   38     0   8   65 45                       110.0 58 3 3 0   38     0   8   65 45                 110
2238521 MA Middlesex   school 2501710 600   Acton-Boxborough 250171002867 6000001 Acton-Boxborough: Carol Huebner Early Childhood Program   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 44 8 6 0   48     0   5   64 47                       111.0 44 8 6 0   48     0   5   64 47                 111
2232573 MA Essex   school 2506660 149   Lawrence 250666002651 1490001 Lawrence: Rollins Early Childhood Center   Regular School No Elementary PK KG 2018   pre_kindergarten 5 1 106 0   0     0   0   69 43                       112.0 5 1 106 0   0     0   0   69 43                 112
2239759 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000199 7800025 Whitman-Hanson: Maquan Elementary   Regular School No Elementary PK 02 2018   pre_kindergarten 95 3 7 0   0     0   7   61 51                       112.0 95 3 7 0   0     0   7   61 51                 112
2229258 MA Essex   school 2502640 30   Beverly 250264002854 300002 Beverly: McKeown School   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 82 4 15 0   6     0   7   70 44                       114.0 82 4 15 0   6     0   7   70 44                 114
2236817 MA Middlesex   school 2512180 314   Watertown 251218002001 3140020 Watertown: Hosmer   Regular School No Elementary PK 05 2018   pre_kindergarten 74 3 16 0   12     1   9   72 43                       115.0 74 3 16 0   12     1   9   72 43                 115
2232074 MA Franklin   school 2505490 114   Greenfield 250549002128 1140005 Greenfield: The Academy of Early Learning at North Parish   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 96 2 14 0   2     0   3   61 56                       117.0 96 2 14 0   2     0   3   61 56                 117
2238361 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public (District): Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2018   pre_kindergarten 4 71 38 0   0     0   5   57 61                       118.0 4 71 38 0   0     0   5   57 61                 118
2237518 MA Middlesex   school 2513200 347   Woburn 251320002191 3470043 Woburn: Shamrock   Regular School No Elementary PK 05 2018   pre_kindergarten 83 13 7 1   12     0   3   65 54                       119.0 83 13 7 1   12     0   3   65 54                 119
2229702 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Boston: Joseph P Manning   Regular School No Elementary PK 05 2018   pre_kindergarten 7 1 3 0   0     0   1   2 10                       12.0 7 1 3 0   0     0   1   2 10                 12
2229865 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Boston: Roger Clap   Regular School No Elementary PK 05 2018   pre_kindergarten 4 1 5 0   1     0   1   7 5                       12.0 4 1 5 0   1     0   1   7 5                 12
2231159 MA Bristol   school 2504020 72   Dartmouth 250402000542 720030 Dartmouth: George H Potter   Regular School No Elementary PK 05 2018   pre_kindergarten 10 0 1 0   0     0   1   6 6                       12.0 10 0 1 0   0     0   1   6 6                 12
2231748 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida: Abbott Memorial   Regular School No Elementary PK 08 2018   pre_kindergarten 11 1 0 0   0     0   0   7 5                       12.0 11 1 0 0   0     0   0   7 5                 12
2233641 MA Middlesex   school 2507560 176   Medford 250756002062 1760150 Medford: Milton Fuller Roberts   Regular School No Elementary PK 05 2018   pre_kindergarten 8 0 2 0   2     0   0   8 4                       12.0 8 0 2 0   2     0   0   8 4                 12
2236948 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet: Wellfleet Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten 9 0 0 0   1     0   2   8 4                       12.0 9 0 0 0   1     0   2   8 4                 12
2234457 MA Essex   school 2508700 211   North Andover 250870001393 2110001 North Andover: Atkinson   Regular School No Elementary PK 05 2018   pre_kindergarten 68 3 22 0   23     0   4   71 49                       120.0 68 3 22 0   23     0   4   71 49                 120
2231950 MA Essex   school 2505220 105   Georgetown 250522000766 1050005 Georgetown: Perley Elementary   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 118 0 0 1   1     0   1   58 63                       121.0 118 0 0 1   1     0   1   58 63                 121
2234832 MA Essex   school 2509360 229   Peabody 250936001821 2290016 Peabody: John E. McCarthy   Regular School No Elementary PK 05 2018   pre_kindergarten 94 2 20 0   1     0   4   78 43                       121.0 94 2 20 0   1     0   4   78 43                 121
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
2236142 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 Springfield: German Gerena Community School   Regular School No Elementary PK 05 2018   pre_kindergarten 7 30 81 0   1     0   6   54 71                       125.0 7 30 81 0   1     0   6   54 71                 125
2234529 MA Bristol   school 2508730 212   North Attleborough 250873001409 2120020 North Attleborough: North Attleborough Early Learning Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 95 3 7 1   15     1   4   79 47                       126.0 95 3 7 1   15     1   4   79 47                 126
2236621 MA Middlesex   school 2511910 305   Wakefield 251191002826 3050001 Wakefield: Early Childhood Center at the Doyle School   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 100 0 12 0   8     1   5   67 59                       126.0 100 0 12 0   8     1   5   67 59                 126
2228990 MA Middlesex   school 2502100 14   Ashland 250210002455 140005 Ashland: William Pittaway Elementary   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 95 3 0 1   28     0   0   72 55                       127.0 95 3 0 1   28     0   0   72 55                 127
2238730 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Bridgewater-Raynham: Mitchell Elementary School   Regular School No Elementary PK 03 2018   pre_kindergarten 118 6 0 0   2     0   1   79 48                       127.0 118 6 0 0   2     0   1   79 48                 127
2231310 MA Plymouth   school 2504440 83   East Bridgewater 250444000596 830005 East Bridgewater: Central   Regular School No Elementary PK 02 2018   pre_kindergarten 112 3 7 0   0     0   7   58 71                       129.0 112 3 7 0   0     0   7   58 71                 129
2232483 MA Middlesex   school 2506390 141   Hudson 250639000924 1410007 Hudson: Mulready Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten 11 0 0 0   1     0   1   8 5                       13.0 11 0 0 0   1     0   1   8 5                 13
2232496 MA Middlesex   school 2506390 141   Hudson 250639000922 1410030 Hudson: C A Farley   Regular School No Elementary PK 04 2018   pre_kindergarten 8 1 3 0   1     0   0   6 7                       13.0 8 1 3 0   1     0   0   6 7                 13
2237354 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Williamsburg: Anne T. Dunphy School   Regular School No Elementary PK 06 2018   pre_kindergarten 13 0 0 0   0     0   0   8 5                       13.0 13 0 0 0   0     0   0   8 5                 13
2238764 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 Chesterfield-Goshen: New Hingham Regional Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten 13 0 0 0   0     0   0   8 5                       13.0 13 0 0 0   0     0   0   8 5                 13
2238957 MA Hampshire   school 2505160 672   Gateway 250516000757 6720059 Gateway: Chester Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten 13 0 0 0   0     0   0   9 4                       13.0 13 0 0 0   0     0   0   9 4                 13
2239224 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Mohawk Trail: Colrain Central   Regular School No Elementary PK 06 2018   pre_kindergarten 13 0 0 0   0     0   0   7 6                       13.0 13 0 0 0   0     0   0   7 6                 13
2233995 MA Middlesex   school 2508340 198   Natick 250834001303 1980505 Natick: Natick High   Regular School No High 09 12 2018   pre_kindergarten 89 4 6 0   31     0   0   71 59                       130.0 89 4 6 0   31     0   0   71 59                 130
2234147 MA Bristol   school 2508430 201   New Bedford 250843001320 2010123 New Bedford: Casimir Pulaski   Regular School No Elementary PK 05 2018   pre_kindergarten 95 7 21 0   3     0   5   77 54                       131.0 95 7 21 0   3     0   5   77 54                 131
2230849 MA Middlesex   school 2503510 56   Chelmsford 250351002640 560001 Chelmsford: Community Education Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 84 4 9 1   31     0   3   80 52                       132.0 84 4 9 1   31     0   3   80 52                 132
2229103 MA Barnstable   school 2502310 20   Barnstable 250231002851 200001 Barnstable: Enoch Cobb Early Learning Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 85 11 26 2   1     0   10   75 60                       135.0 85 11 26 2   1     0   10   75 60                 135
2230371 MA Norfolk   school 2502940 40   Braintree 250294000361 400505 Braintree: Braintree High   Regular School No High 09 12 2018   pre_kindergarten 96 6 5 1   25     0   2   89 46                       135.0 96 6 5 1   25     0   2   89 46                 135
2231096 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway: Conway Grammar   Regular School No Elementary PK 06 2018   pre_kindergarten 14 0 0 0   0     0   0   7 7                       14.0 14 0 0 0   0     0   0   7 7                 14
2232713 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee: Lee Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten 13 0 0 0   0     0   1   8 6                       14.0 13 0 0 0   0     0   1   8 6                 14
2232820 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett: Leverett Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten 13 0 0 0   0     0   1   7 7                       14.0 13 0 0 0   0     0   1   7 7                 14
2235435 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe: Rowe Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten 11 0 1 0   0     0   2   5 9                       14.0 11 0 1 0   0     0   2   5 9                 14
2236657 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales: Wales Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten 14 0 0 0   0     0   0   11 3                       14.0 14 0 0 0   0     0   0   11 3                 14
2237482 MA Suffolk   school 2513170 346   Winthrop 251317002180 3460505 Winthrop: Winthrop High School   Regular School No High 09 12 2018   pre_kindergarten 14 0 0 0   0     0   0   4 10                       14.0 14 0 0 0   0     0   0   4 10                 14
2237896 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 Worthington: R. H. Conwell   Regular School No Elementary PK 06 2018   pre_kindergarten 12 0 0 1   0     0   1   5 9                       14.0 12 0 0 1   0     0   1   5 9                 14
2238680 MA Berkshire   school 2502530 618   Berkshire Hills 250253001999 6180035 Berkshire Hills: Muddy Brook Regional Elementary School   Regular School No Elementary PK 04 2018   pre_kindergarten 10 0 2 0   0     0   2   8 6                       14.0 10 0 2 0   0     0   2   8 6                 14
2239063 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000822 6800005 Hampden-Wilbraham: Green Meadows Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten 14 0 0 0   0     0   0   8 6                       14.0 14 0 0 0   0     0   0   8 6                 14
2239422 MA Franklin   school 2509600 750   Pioneer Valley 250960002614 7500008 Pioneer Valley: Northfield Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten 13 0 1 0   0     0   0   11 3                       14.0 13 0 1 0   0     0   0   11 3                 14
2239520 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 Southern Berkshire: New Marlborough Central   Regular School No Elementary PK 04 2018   pre_kindergarten 14 0 0 0   0     0   0   10 4                       14.0 14 0 0 0   0     0   0   10 4                 14
2235009 MA Plymouth   school 2509720 239   Plymouth 250972000318 2390003 Plymouth: Plymouth Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 121 4 3 0   2     0   10   70 70                       140.0 121 4 3 0   2     0   10   70 70                 140
2235980 MA Hampden   school 2511130 281   Springfield 251113000341 2810055 Springfield: Rebecca M Johnson   Regular School No Elementary PK 05 2018   pre_kindergarten 12 32 95 0   0     0   3   79 63                       142.0 12 32 95 0   0     0   3   79 63                 142
2236966 MA Worcester   school 2512600 321   Westborough 251260002058 3210025 Westborough: Elsie A Hastings Elementary   Regular School No Elementary PK 03 2018   pre_kindergarten 40 3 11 0   88     0   1   80 63                       143.0 40 3 11 0   88     0   1   80 63                 143
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
2233822 MA Worcester   school 2507860 185   Milford 250786001650 1850075 Milford: Shining Star Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 107 1 27 1   7     0   1   79 65                       144.0 107 1 27 1   7     0   1   79 65                 144
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
2229251 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin: Berlin Memorial   Regular School No Elementary PK 05 2018   pre_kindergarten 12 0 2 0   1     0   0   8 7                       15.0 12 0 2 0   1     0   0   8 7                 15
2230613 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 Brookline: John D Runkle   Regular School No Elementary PK 08 2018   pre_kindergarten 4 0 2 0   6     0   3   8 7                       15.0 4 0 2 0   6     0   3   8 7                 15
2232389 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Holyoke: Kelly Elementary   Regular School No Elementary PK 08 2018   pre_kindergarten 2 0 13 0   0     0   0   7 8                       15.0 2 0 13 0   0     0   0   7 8                 15
2233905 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton: Milton High   Regular School No High 09 12 2018   pre_kindergarten 11 3 0 0   0     0   1   8 7                       15.0 11 3 0 0   0     0   1   8 7                 15
2235369 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond: Richmond Consolidated   Regular School No Elementary PK 08 2018   pre_kindergarten 13 0 1 0   0     0   1   6 9                       15.0 13 0 1 0   0     0   1   6 9                 15
2237126 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton: Westhampton Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten 15 0 0 0   0     0   0   10 5                       15.0 15 0 0 0   0     0   0   10 5                 15
2235988 MA Hampden   school 2511130 281   Springfield 251113001817 2810060 Springfield: Margaret C Ells   Regular School No Elementary PK 01 2018   pre_kindergarten 15 41 92 1   4     0   4   91 66                       157.0 15 41 92 1   4     0   4   91 66                 157
2230561 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Brookline: Michael Driscoll   Regular School No Elementary PK 08 2018   pre_kindergarten 11 0 1 0   3     0   1   9 7                       16.0 11 0 1 0   3     0   1   9 7                 16
2235418 MA Essex   school 2510200 252   Rockport 251020002533 2520005 Rockport: Rockport Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten 16 0 0 0   0     0   0   10 6                       16.0 16 0 0 0   0     0   0   10 6                 16
2235720 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury: Shutesbury Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten 16 0 0 0   0     0   0   8 8                       16.0 16 0 0 0   0     0   0   8 8                 16
2237345 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately: Whately Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten 13 0 0 0   1     0   2   10 6                       16.0 13 0 0 0   1     0   2   10 6                 16
2239385 MA Essex   school 2509450 745   Pentucket 250945000408 7450015 Pentucket: Dr John C Page School   Regular School No Elementary PK 06 2018   pre_kindergarten 16 0 0 0   0     0   0   11 5                       16.0 16 0 0 0   0     0   0   11 5                 16
2239407 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Pioneer Valley: Bernardston Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten 16 0 0 0   0     0   0   9 7                       16.0 16 0 0 0   0     0   0   9 7                 16
2239650 MA Worcester   school 2511880 775   Wachusett 251188002730 7750001 Wachusett: Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 134 3 12 0   8     1   4   94 68                       162.0 134 3 12 0   8     1   4   94 68                 162
2228785 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam: Agawam Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 121 3 22 0   14     0   3   88 75                       163.0 121 3 22 0   14     0   3   88 75                 163
2230625 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline: Brookline High   Regular School No High 09 12 2018   pre_kindergarten 8 1 2 0   4     0   2   8 9                       17.0 8 1 2 0   4     0   2   8 9                 17
2233617 MA Middlesex   school 2507560 176   Medford 250756001634 1760068 Medford: John J McGlynn Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten 11 1 0 0   3     0   2   8 9                       17.0 11 1 0 0   3     0   2   8 9                 17
2234974 MA Berkshire   school 2509630 236   Pittsfield 250963001535 2360105 Pittsfield: Silvio O Conte Community   Regular School No Elementary PK 05 2018   pre_kindergarten 10 1 6 0   0     0   0   6 11                       17.0 10 1 6 0   0     0   0   6 11                 17
2236576 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro: Truro Central   Regular School No Elementary PK 05 2018   pre_kindergarten 10 1 1 0   0     0   5   9 8                       17.0 10 1 1 0   0     0   5   9 8                 17
2238773 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Central Berkshire: Becket Washington School   Regular School No Elementary PK 05 2018   pre_kindergarten 16 0 0 0   0     0   1   6 11                       17.0 16 0 0 0   0     0   1   6 11                 17
2235906 MA Hampden   school 2511130 281   Springfield 251113002853 2810001 Springfield: Early Childhood Education Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 15 34 117 1   0     0   3   110 60                       170.0 15 34 117 1   0     0   3   110 60                 170
2233476 MA Middlesex   school 2507320 170   Marlborough 250732001368 1700006 Marlborough: Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 104 6 26 0   30     2   6   108 66                       174.0 104 6 26 0   30     2   6   108 66                 174
2229745 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Boston: Maurice J Tobin   Regular School No Elementary PK 08 2018   pre_kindergarten 2 8 4 0   1     0   3   13 5                       18.0 2 8 4 0   1     0   3   13 5                 18
2229782 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Boston: Nathan Hale   Regular School No Elementary PK 05 2018   pre_kindergarten 3 5 7 0   3     0   0   8 10                       18.0 3 5 7 0   3     0   0   8 10                 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]);