Data source: Big Local News · About: Big Local

536 rows where grade = "pre_kindergarten", state = "MA" and year = 2020 sorted by total

View and edit SQL

year

  • 2020 · 536

grade

  • pre_kindergarten · 536
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
1368457 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   pre_kindergarten * * * *   *     *   *   * * *                     0.0                                             0
1374307 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   pre_kindergarten * * * *   *     *   *   * * *                     0.0                                             0
1366728 MA Middlesex   school 2503840 67   Concord 250384000525 670020 Thoreau   Regular School No Elementary PK 05 2020   pre_kindergarten 6 0 3 0   0     0   1   6 4 *                     10.0 6 0 3 0   0     0   1   6 4                 10
1368565 MA Essex   school 2507110 163   Lynn 250711001066 1630090 Capt William G Shoemaker   Regular School No Elementary PK 05 2020   pre_kindergarten 3 2 4 0   1     0   0   9 1 *                     10.0 3 2 4 0   1     0   0   9 1                 10
1369786 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No Elementary PK 08 2020   pre_kindergarten 7 0 2 0   1     0   0   5 5 *                     10.0 7 0 2 0   1     0   0   5 5                 10
1370487 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 10 0 0 0   0     0   0   2 8 *                     10.0 10 0 0 0   0     0   0   2 8                 10
1372980 MA Middlesex   school 2501710 600   Acton-Boxborough 250171002867 6000001 Carol Huebner Early Childhood Program   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 42 5 13 0   33     0   9   55 47 *                     102.0 42 5 13 0   33     0   9   55 47                 102
1366375 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington High   Regular School No High 09 12 2020   pre_kindergarten 56 8 8 0   30     0   1   61 42 *                     103.0 56 8 8 0   30     0   1   61 42                 103
1369868 MA Essex   school 2509360 229   Peabody 250936001821 2290016 John E. McCarthy   Regular School No Elementary PK 05 2020   pre_kindergarten 87 3 10 0   2     0   1   64 39 *                     103.0 87 3 10 0   2     0   1   64 39                 103
1365332 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2020   pre_kindergarten 52 17 24 0   6     0   6   71 34 *                     105.0 52 17 24 0   6     0   6   71 34                 105
1367779 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No Elementary PK 02 2020   pre_kindergarten 85 2 1 1   12     0   4   68 37 *                     105.0 85 2 1 1   12     0   4   68 37                 105
1370226 MA Middlesex   school 2509990 246   Reading 250999002751 2460001 RISE PreSchool   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 91 1 4 0   4     0   5   67 38 *                     105.0 91 1 4 0   4     0   5   67 38                 105
1370979 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 German Gerena Community School   Regular School No Elementary PK 05 2020   pre_kindergarten 7 22 72 3   0     0   3   53 54 *                     107.0 7 22 72 3   0     0   3   53 54                 107
1365193 MA Essex   school 2502640 30   Beverly 250264002854 300002 McKeown School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 84 8 9 1   3     0   3   63 45 *                     108.0 84 8 9 1   3     0   3   63 45                 108
1366765 MA Essex   school 2503990 71   Danvers 250399000536 710030 Riverside   Regular School No Elementary PK 05 2020   pre_kindergarten 94 4 8 0   1     0   1   59 49 *                     108.0 94 4 8 0   1     0   1   59 49                 108
1368275 MA Middlesex   school 2507020 160   Lowell 250702002891 1600001 Cardinal O'Connell Early Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 30 5 43 0   26     0   5   71 38 *                     109.0 30 5 43 0   26     0   5   71 38                 109
1369714 MA Bristol   school 2509000 218   Norton 250900001449 2180015 J C Solmonese   Regular School No Elementary PK 03 2020   pre_kindergarten 99 1 1 1   3     0   4   65 44 *                     109.0 99 1 1 1   3     0   4   65 44                 109
1373834 MA Plymouth   school 2510830 760   Silver Lake 251083001722 7600505 Silver Lake Regional High   Regular School No High 09 12 2020   pre_kindergarten 109 0 0 0   0     0   0   57 52 *                     109.0 109 0 0 0   0     0   0   57 52                 109
1374042 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002902 7800001 The Pre-School Academy at Whitman Hanson   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 91 3 5 0   3     0   7   67 42 *                     109.0 91 3 5 0   3     0   7   67 42                 109
1365566 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Joseph P Manning   Regular School No Elementary PK 05 2020   pre_kindergarten 7 2 1 0   0     0   1   7 4 *                     11.0 7 2 1 0   0     0   1   7 4                 11
1373744 MA Essex   school 2509450 745   Pentucket 250945000408 7450015 Dr John C Page School   Regular School No Elementary PK 06 2020   pre_kindergarten 10 0 1 0   0     0   0   7 4 *                     11.0 10 0 1 0   0     0   0   7 4                 11
1367392 MA Norfolk   school 2505010 101   Franklin 250501000986 1010003 Franklin Early Childhood Development Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 87 2 1 0   10     6   5   67 44 *                     111.0 87 2 1 0   10     6   5   67 44                 111
1368686 MA Bristol   school 2507230 167   Mansfield 250723001004 1670003 Roland Green School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 87 2 8 0   9     0   5   61 50 *                     111.0 87 2 8 0   9     0   5   61 50                 111
1366122 MA Norfolk   school 2502940 40   Braintree 250294000361 400505 Braintree High   Regular School No High 09 12 2020   pre_kindergarten 55 4 1 0   50     0   3   60 53 *                     113.0 55 4 1 0   50     0   3   60 53                 113
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
1366924 MA Plymouth   school 2504440 83   East Bridgewater 250444000596 830005 Central   Regular School No Elementary PK 02 2020   pre_kindergarten 99 4 5 0   3     0   3   56 58 *                     114.0 99 4 5 0   3     0   3   56 58                 114
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
1367487 MA Essex   school 2505280 107   Gloucester 250528002574 1070025 Gloucester PreSchool   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 97 2 6 0   5     0   6   71 45 *                     116.0 97 2 6 0   5     0   6   71 45                 116
1372834 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2020   pre_kindergarten 0 78 34 1   0     0   3   52 64 *                     116.0 0 78 34 1   0     0   3   52 64                 116
1371552 MA Middlesex   school 2512180 314   Watertown 251218002001 3140020 Hosmer   Regular School No Elementary PK 05 2020   pre_kindergarten 82 4 16 0   11     0   5   67 51 *                     118.0 82 4 16 0   11     0   5   67 51                 118
1365413 MA Suffolk   school 2502790 35   Boston 250279000227 350088 Edward Everett   Regular School No Elementary PK 05 2020   pre_kindergarten 0 1 6 0   3     0   2   7 5 *                     12.0 0 1 6 0   3     0   2   7 5                 12
1366995 MA Bristol   school 2504620 88   Easton 250462002381 880020 Moreau Hall   Regular School No Elementary PK 02 2020   pre_kindergarten 10 0 0 0   2     0   0   7 5 *                     12.0 10 0 0 0   2     0   0   7 5                 12
1373500 MA Essex   school 2500067 698   Manchester Essex Regional 250006701110 6980010 Manchester Memorial Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten 11 0 0 0   1     0   0   6 6 *                     12.0 11 0 0 0   1     0   0   6 6                 12
1367807 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No Elementary PK 04 2020   pre_kindergarten 9 4 100 0   1     0   6   69 51 *                     120.0 9 4 100 0   1     0   6   69 51                 120
1367550 MA Franklin   school 2505490 114   Greenfield 250549002128 1140005 The Academy of Early Learning at North Parish   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 93 2 20 0   1     0   5   69 52 *                     121.0 93 2 20 0   1     0   5   69 52                 121
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
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
1369561 MA Essex   school 2508700 211   North Andover 250870002883 2110005 Anne Bradstreet Early Childhood Center   Regular School No Elementary PK KG 2020   pre_kindergarten 67 1 26 1   25     0   5   67 58 *                     125.0 67 1 26 1   25     0   5   67 58                 125
1370839 MA Hampden   school 2511130 281   Springfield 251113000341 2810055 Rebecca M Johnson   Regular School No Elementary PK 05 2020   pre_kindergarten 14 29 82 0   0     0   1   73 53 *                     126.0 14 29 82 0   0     0   1   73 53                 126
1367028 MA Middlesex   school 2504770 93   Everett 250477002804 930003 Adams School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 26 23 67 0   10     0   1   65 62 *                     127.0 26 23 67 0   10     0   1   65 62                 127
1371679 MA Worcester   school 2512600 321   Westborough 251260002058 3210025 Elsie A Hastings Elementary   Regular School No Elementary PK 03 2020   pre_kindergarten 28 1 15 2   79     0   3   70 58 *                     128.0 28 1 15 2   79     0   3   70 58                 128
1366819 MA Norfolk   school 2504050 73   Dedham 250405000460 730005 Early Childhood Center   Regular School No Elementary PK KG 2020   pre_kindergarten 96 8 12 0   2     0   11   70 59 *                     129.0 96 8 12 0   2     0   11   70 59                 129
1365522 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No Elementary PK 05 2020   pre_kindergarten 6 3 4 0   0     0   0   12 1 *                     13.0 6 3 4 0   0     0   0   12 1                 13
1367895 MA Middlesex   school 2506390 141   Hudson 250639000924 1410007 Mulready Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten 11 0 1 0   1     0   0   9 4 *                     13.0 11 0 1 0   1     0   0   9 4                 13
1369086 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton High   Regular School No High 09 12 2020   pre_kindergarten 10 1 1 0   1     0   0   3 10 *                     13.0 10 1 1 0   1     0   0   3 10                 13
1372169 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2020   pre_kindergarten 9 1 2 0   1     0   0   7 6 *                     13.0 9 1 2 0   1     0   0   7 6                 13
1373206 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Becket Washington School   Regular School No Elementary PK 05 2020   pre_kindergarten 11 0 1 0   0     0   1   8 5 *                     13.0 11 0 1 0   0     0   1   8 5                 13
1373572 MA Berkshire   school 2508160 715   Mount Greylock 250816002887 7150005 Lanesborough Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten 11 0 0 0   0     0   2   5 8 *                     13.0 11 0 0 0   0     0   2   5 8                 13
1367961 MA Essex   school 2506660 149   Lawrence 250666002651 1490001 Rollins Early Childhood Center   Regular School No Elementary PK KG 2020   pre_kindergarten 5 1 124 0   0     0   0   76 54 *                     130.0 5 1 124 0   0     0   0   76 54                 130
1369162 MA Middlesex   school 2508340 198   Natick 250834001303 1980505 Natick High   Regular School No High 09 12 2020   pre_kindergarten 81 1 12 0   34     0   8   83 53 *                     136.0 81 1 12 0   34     0   8   83 53                 136
1365604 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2020   pre_kindergarten 1 1 10 0   2     0   0   10 4 *                     14.0 1 1 10 0   2     0   0   10 4                 14
1366512 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No Elementary PK 08 2020   pre_kindergarten 8 0 0 0   3     1   2   11 3 *                     14.0 8 0 0 0   3     1   2   11 3                 14
1371545 MA Middlesex   school 2512180 314   Watertown 251218001998 3140015 Cunniff   Regular School No Elementary PK 05 2020   pre_kindergarten 9 0 1 0   3     0   1   3 11 *                     14.0 9 0 1 0   3     0   1   3 11                 14
1371559 MA Middlesex   school 2512180 314   Watertown 251218002002 3140025 James Russell Lowell   Regular School No Elementary PK 05 2020   pre_kindergarten 11 0 2 0   1     0   0   8 6 *                     14.0 11 0 2 0   1     0   0   8 6                 14
1372064 MA Suffolk   school 2513170 346   Winthrop 251317002180 3460505 Winthrop High School   Regular School No High 09 12 2020   pre_kindergarten 14 0 0 0   0     0   0   4 10 *                     14.0 14 0 0 0   0     0   0   4 10                 14
1373199 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten 14 0 0 0   0     0   0   10 4 *                     14.0 14 0 0 0   0     0   0   10 4                 14
1371385 MA Middlesex   school 2511910 305   Wakefield 251191002826 3050001 Early Childhood Center at the Doyle School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 115 2 10 0   4     0   9   88 52 *                     140.0 115 2 10 0   4     0   9   88 52                 140
1366799 MA Bristol   school 2504020 72   Dartmouth 250402000542 720030 George H Potter   Regular School No Elementary PK 05 2020   pre_kindergarten 15 0 0 0   0     0   0   11 4 *                     15.0 15 0 0 0   0     0   0   11 4                 15
1367169 MA Bristol   school 2504830 95   Fall River 250483000679 950130 Spencer Borden   Regular School No Elementary PK 05 2020   pre_kindergarten 8 0 4 0   0     0   3   8 7 *                     15.0 8 0 4 0   0     0   3   8 7                 15
1367906 MA Middlesex   school 2506390 141   Hudson 250639000922 1410030 C A Farley   Regular School No Elementary PK 04 2020   pre_kindergarten 10 1 2 0   2     0   0   10 5 *                     15.0 10 1 2 0   2     0   0   10 5                 15
1368856 MA Middlesex   school 2507560 176   Medford 250756002057 1760140 Christopher Columbus   Regular School No Elementary PK 05 2020   pre_kindergarten 6 4 2 0   3     0   0   7 8 *                     15.0 6 4 2 0   3     0   0   7 8                 15
1368863 MA Middlesex   school 2507560 176   Medford 250756002062 1760150 Milton Fuller Roberts   Regular School No Elementary PK 05 2020   pre_kindergarten 9 1 1 0   2     0   2   9 6 *                     15.0 9 1 1 0   2     0   2   9 6                 15
1369958 MA Berkshire   school 2509630 236   Pittsfield 250963001522 2360045 Robert T. Capeless Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 9 2 2 1   0     0   1   13 2 *                     15.0 9 2 2 1   0     0   1   13 2                 15
1372029 MA Middlesex   school 2513110 344   Winchester 251311002172 3440025 Vinson-Owen Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten 11 0 1 0   0     0   3   5 10 *                     15.0 11 0 1 0   0     0   3   5 10                 15
1372418 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2020   pre_kindergarten 12 0 2 1   0     0   0   11 4 *                     15.0 12 0 2 1   0     0   0   11 4                 15
1373595 MA Franklin   school 2507990 717   Mohawk Trail 250799000424 7170005 Buckland-Shelburne Regional   Regular School No Elementary PK 06 2020   pre_kindergarten 13 0 0 0   0     0   2   7 8 *                     15.0 13 0 0 0   0     0   2   7 8                 15
1373171 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Mitchell Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten 108 7 9 0   9     0   18   101 50 *                     151.0 108 7 9 0   9     0   18   101 50                 151
1370772 MA Hampden   school 2511130 281   Springfield 251113002853 2810001 Early Childhood Education Center   Regular School No Elementary PK KG 2020   pre_kindergarten 20 23 100 1   5     0   4   89 64 *                     153.0 20 23 100 1   5     0   4   89 64                 153
1369613 MA Bristol   school 2508730 212   North Attleborough 250873001409 2120020 North Attleborough Early Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 113 5 9 0   25     0   7   96 63 *                     159.0 113 5 9 0   25     0   7   96 63                 159
1373957 MA Worcester   school 2511880 775   Wachusett 251188002730 7750001 Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 134 2 12 0   7     0   4   95 64 *                     159.0 134 2 12 0   7     0   4   95 64                 159
1366332 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No Elementary PK 08 2020   pre_kindergarten 6 0 2 0   4     0   4   8 8 *                     16.0 6 0 2 0   4     0   4   8 8                 16
1366701 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton Senior High   Regular School No High 09 12 2020   pre_kindergarten 10 1 4 0   0     0   1   9 7 *                     16.0 10 1 4 0   0     0   1   9 7                 16
1366745 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No Elementary PK 06 2020   pre_kindergarten 15 0 1 0   0     0   0   12 4 *                     16.0 15 0 1 0   0     0   0   12 4                 16
1373130 MA Worcester   school 2502580 620   Berlin-Boylston 250258002901 6200005 Berlin Memorial School   Regular School No Elementary PK 05 2020   pre_kindergarten 13 0 1 0   1     0   1   8 8 *                     16.0 13 0 1 0   1     0   1   8 8                 16
1373358 MA Hampshire   school 2505160 672   Gateway 250516000757 6720059 Chester Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten 15 0 1 0   0     0   0   7 9 *                     16.0 15 0 1 0   0     0   0   7 9                 16
1373552 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400469 7120001 Chatham Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten 13 1 1 0   1     0   0   9 7 *                     16.0 13 1 1 0   1     0   0   9 7                 16
1373580 MA Berkshire   school 2508160 715   Mount Greylock 250816002899 7150010 Williamstown Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten 10 1 2 0   1     0   2   9 7 *                     16.0 10 1 2 0   1     0   2   9 7                 16
1364809 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 114 6 18 0   15     0   7   93 67 *                     160.0 114 6 18 0   15     0   7   93 67                 160
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
1366536 MA Middlesex   school 2503510 56   Chelmsford 250351002640 560001 Community Education Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 95 8 15 1   39     0   8   104 62 *                     166.0 95 8 15 1   39     0   8   104 62                 166
1366265 MA Norfolk   school 2503150 46   Brookline 250315002904 460003 Brookline Early Education Program at Clark Road   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 8 1 2 0   5     0   1   9 8 *                     17.0 8 1 2 0   5     0   1   9 8                 17
1367617 MA Worcester   school 2505880 125   Harvard 250588000839 1250005 Hildreth Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 11 0 3 0   2     0   1   11 6 *                     17.0 11 0 3 0   2     0   1   11 6                 17
1367631 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten 17 0 0 0   0     0   0   10 7 *                     17.0 17 0 0 0   0     0   0   10 7                 17
1368849 MA Middlesex   school 2507560 176   Medford 250756002049 1760130 Brooks School   Regular School No Elementary PK 05 2020   pre_kindergarten 9 5 1 1   0     0   1   11 6 *                     17.0 9 5 1 1   0     0   1   11 6                 17
1370325 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2020   pre_kindergarten 15 0 0 0   0     0   2   11 6 *                     17.0 15 0 0 0   0     0   2   11 6                 17
1370610 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten 15 0 1 0   0     0   1   7 10 *                     17.0 15 0 1 0   0     0   1   7 10                 17
1370648 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No Elementary PK 08 2020   pre_kindergarten 3 3 8 0   2     0   1   9 8 *                     17.0 3 3 8 0   2     0   1   9 8                 17
1373846 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 New Marlborough Central   Regular School No Elementary PK 04 2020   pre_kindergarten 11 0 3 1   0     0   2   12 5 *                     17.0 11 0 3 1   0     0   2   12 5                 17
1371720 MA Hampden   school 2512630 325   Westfield 251263002452 3250003 Fort Meadow Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 121 3 37 0   3     0   7   90 81 *                     171.0 121 3 37 0   3     0   7   90 81                 171
1371308 MA Middlesex   school 2511580 295   Tewksbury 251158001922 2950001 L F Dewing   Regular School No Elementary PK 02 2020   pre_kindergarten 133 8 10 0   15     1   6   103 70 *                     173.0 133 8 10 0   15     1   6   103 70                 173
1368727 MA Middlesex   school 2507320 170   Marlborough 250732001368 1700006 Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 78 15 60 0   17     1   4   100 75 *                     175.0 78 15 60 0   17     1   4   100 75                 175
1365447 MA Suffolk   school 2502790 35   Boston 250279000241 350122 George H Conley   Regular School No Elementary PK 05 2020   pre_kindergarten 10 5 3 0   0     0   0   10 8 *                     18.0 10 5 3 0   0     0   0   10 8                 18
1366987 MA Bristol   school 2504620 88   Easton 250462000980 880003 Center School   Regular School No Elementary PK 02 2020   pre_kindergarten 13 1 2 0   2     0   0   12 6 *                     18.0 13 1 2 0   2     0   0   12 6                 18
1368070 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten 15 0 2 0   1     0   0   9 9 *                     18.0 15 0 2 0   1     0   0   9 9                 18
1369965 MA Berkshire   school 2509630 236   Pittsfield 250963001524 2360055 Morningside Community School   Regular School No Elementary PK 05 2020   pre_kindergarten 7 5 5 0   0     0   1   9 9 *                     18.0 7 5 5 0   0     0   1   9 9                 18
1369991 MA Berkshire   school 2509630 236   Pittsfield 250963001535 2360105 Silvio O Conte Community   Regular School No Elementary PK 05 2020   pre_kindergarten 10 1 5 0   0     0   2   9 9 *                     18.0 10 1 5 0   0     0   2   9 9                 18
1370667 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2020   pre_kindergarten 12 0 2 0   3     0   1   7 11 *                     18.0 12 0 2 0   3     0   1   7 11                 18
1370686 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 West Somerville Neighborhood   Regular School No Elementary PK 08 2020   pre_kindergarten 7 2 4 0   1     0   4   10 8 *                     18.0 7 2 4 0   1     0   4   10 8                 18
1373603 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Colrain Central   Regular School No Elementary PK 06 2020   pre_kindergarten 18 0 0 0   0     0   0   10 8 *                     18.0 18 0 0 0   0     0   0   10 8                 18
1373770 MA Franklin   school 2509600 750   Pioneer Valley 250960002614 7500008 Northfield Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten 17 0 0 0   0     0   1   10 8 *                     18.0 17 0 0 0   0     0   1   10 8                 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]);