Data source: Big Local News · About: Big Local

530 rows where grade = "pre_kindergarten", state = "MA" and year = 2021

View and edit SQL

year

  • 2021 · 430

grade

  • pre_kindergarten · 430
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
1673368 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield - Brimfield Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten 10 0 0 0   0     0   0   7 3 *                     10.0 10 0 0 0   0     0   0   7 3                 10
1673376 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Brockton - Dr W Arnone Community School   Regular School No Elementary PK 05 2021   pre_kindergarten 7 41 14 0   1     0   4   34 33 *                     67.0 7 41 14 0   1     0   4   34 33                 67
1673395 MA Plymouth   school 2503090 44   Brockton 250309002792 440008 Brockton - Barrett Russell Early Childhood Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 38 74 23 0   1     1   8   95 50 *                     145.0 38 74 23 0   1     1   8   95 50                 145
1673489 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield - Brookfield Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten 10 0 1 0   0     0   1   8 4 *                     12.0 10 0 1 0   0     0   1   8 4                 12
1673496 MA Norfolk   school 2503150 46   Brookline 250315002776 460001 Brookline - Brookline Early Education Program at Beacon   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 11 1 0 0   9     0   5   14 12 *                     26.0 11 1 0 0   9     0   5   14 12                 26
1673497 MA Norfolk   school 2503150 46   Brookline 250315002793 460002 Brookline - Brookline Early Education Program at Putterham   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 14 0 8 0   4     0   2   13 15 *                     28.0 14 0 8 0   4     0   2   13 15                 28
1673498 MA Norfolk   school 2503150 46   Brookline 250315002904 460003 Brookline - Brookline Early Education Program at Clark Road   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 17 1 2 0   5     0   6   18 13 *                     31.0 17 1 2 0   5     0   6   18 13                 31
1673509 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Brookline - Florida Ruffin Ridley School   Regular School No Elementary PK 08 2021   pre_kindergarten 7 1 1 0   8     0   2   9 10 *                     19.0 7 1 1 0   8     0   2   9 10                 19
1673528 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Brookline - Heath   Regular School No Elementary PK 08 2021   pre_kindergarten 8 0 1 0   0     0   1   6 4 *                     10.0 8 0 1 0   0     0   1   6 4                 10
1673565 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 Brookline - John D Runkle   Regular School No Elementary PK 08 2021   pre_kindergarten 4 0 0 0   3     0   2   5 4 *                     9.0 4 0 0 0   3     0   2   5 4                 9
1673574 MA Norfolk   school 2503150 46   Brookline 250315002027 460060 Brookline - The Lynch Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 9 6 5 0   8     0   2   18 12 *                     30.0 9 6 5 0   8     0   2   18 12                 30
1673607 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington - Burlington High   Regular School No High 09 12 2021   pre_kindergarten 29 6 6 0   29     0   3   45 28 *                     73.0 29 6 6 0   29     0   3   45 28                 73
1673613 MA Middlesex   school 2503270 49   Cambridge 250327000435 490005 Cambridge - Maria L. Baldwin   Regular School No Elementary PK 05 2021   pre_kindergarten 27 7 4 0   9     0   7   26 28 *                     54.0 27 7 4 0   9     0   7   26 28                 54
1673620 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Cambridge - Amigos School   Regular School No Elementary PK 08 2021   pre_kindergarten 12 0 10 0   2     0   3   17 10 *                     27.0 12 0 10 0   2     0   3   17 10                 27
1673630 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridge - Cambridgeport   Regular School No Elementary PK 05 2021   pre_kindergarten 14 2 0 0   5     0   1   9 13 *                     22.0 14 2 0 0   5     0   1   9 13                 22
1673637 MA Middlesex   school 2503270 49   Cambridge 250327000441 490020 Cambridge - Haggerty   Regular School No Elementary PK 05 2021   pre_kindergarten 11 5 0 0   5     0   0   10 11 *                     21.0 11 5 0 0   5     0   0   10 11                 21
1673644 MA Middlesex   school 2503270 49   Cambridge 250327000443 490030 Cambridge - Martin Luther King Jr.   Regular School No Elementary PK 05 2021   pre_kindergarten 5 3 1 0   10     0   5   12 12 *                     24.0 5 3 1 0   10     0   5   12 12                 24
1673651 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 Cambridge - King Open   Alternative School No Elementary PK 05 2021   pre_kindergarten 11 5 5 0   5     0   3   14 15 *                     29.0 11 5 5 0   5     0   3   14 15                 29
1673658 MA Middlesex   school 2503270 49   Cambridge 250327000444 490040 Cambridge - Kennedy-Longfellow   Regular School No Elementary PK 05 2021   pre_kindergarten 11 2 6 0   8     0   5   14 18 *                     32.0 11 2 6 0   8     0   5   14 18                 32
1673665 MA Middlesex   school 2503270 49   Cambridge 250327000446 490045 Cambridge - Morse   Regular School No Elementary PK 05 2021   pre_kindergarten 30 11 9 0   4     0   4   35 23 *                     58.0 30 11 9 0   4     0   4   35 23                 58
1673672 MA Middlesex   school 2503270 49   Cambridge 250327000447 490050 Cambridge - Peabody   Regular School No Elementary PK 05 2021   pre_kindergarten 23 7 1 0   6     0   3   22 18 *                     40.0 23 7 1 0   6     0   3   22 18                 40
1673679 MA Middlesex   school 2503270 49   Cambridge 250327000442 490065 Cambridge - John M Tobin   Regular School No Elementary PK 05 2021   pre_kindergarten 34 15 5 0   15     0   12   30 51 *                     81.0 34 15 5 0   15     0   12   30 51                 81
1673686 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Cambridge - Graham and Parks   Alternative School No Elementary PK 05 2021   pre_kindergarten 9 8 2 0   3     0   1   11 12 *                     23.0 9 8 2 0   3     0   1   11 12                 23
1673693 MA Middlesex   school 2503270 49   Cambridge 250327001518 490090 Cambridge - Fletcher/Maynard Academy   Regular School No Elementary PK 05 2021   pre_kindergarten 5 20 4 0   4     0   4   20 17 *                     37.0 5 20 4 0   4     0   4   20 17                 37
1673716 MA Norfolk   school 2503300 50   Canton 250330002635 500010 Canton - Rodman Early Childhood Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 14 3 2 0   4     0   1   18 6 *                     24.0 14 3 2 0   4     0   1   18 6                 24
1673744 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle - Carlisle School   Regular School No Elementary PK 08 2021   pre_kindergarten 5 0 1 0   2     0   1   6 3 *                     9.0 5 0 1 0   2     0   1   6 3                 9
1673754 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver - Carver Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten 34 0 1 0   0     0   0   20 15 *                     35.0 34 0 1 0   0     0   0   20 15                 35
1673767 MA Middlesex   school 2503510 56   Chelmsford 250351002640 560001 Chelmsford - Community Education Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 38 8 12 0   13     0   5   53 23 *                     76.0 38 8 12 0   13     0   5   53 23                 76
1673801 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Chelsea - Shurtleff Early Childhood   Regular School No Elementary PK 01 2021   pre_kindergarten 5 7 43 0   0     0   2   42 15 *                     57.0 5 7 43 0   0     0   2   42 15                 57
1673841 MA Hampden   school 2503660 61   Chicopee 250366002571 610001 Chicopee - Szetela Early Childhood Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 44 6 60 0   3     0   8   86 35 *                     121.0 44 6 60 0   3     0   8   86 35                 121
1673920 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton - Clinton Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten 18 1 11 0   0     0   0   24 6 *                     30.0 18 1 11 0   0     0   0   24 6                 30
1673929 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton - Clinton Senior High   Regular School No High 09 12 2021   pre_kindergarten 6 0 5 0   0     0   0   4 7 *                     11.0 6 0 5 0   0     0   0   4 7                 11
1673938 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Cohasset - Joseph Osgood   Regular School No Elementary PK 02 2021   pre_kindergarten 23 0 0 0   2     0   0   17 8 *                     25.0 23 0 0 0   2     0   0   17 8                 25
1673949 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Concord - Alcott   Regular School No Elementary PK 05 2021   pre_kindergarten 12 0 0 0   1     0   1   8 6 *                     14.0 12 0 0 0   1     0   1   8 6                 14
1673956 MA Middlesex   school 2503840 67   Concord 250384000525 670020 Concord - Thoreau   Regular School No Elementary PK 05 2021   pre_kindergarten 6 1 1 0   3     1   0   8 4 *                     12.0 6 1 1 0   3     1   0   8 4                 12
1673963 MA Middlesex   school 2503840 67   Concord 250384000526 670030 Concord - Willard   Regular School No Elementary PK 05 2021   pre_kindergarten 9 0 0 0   1     0   1   6 5 *                     11.0 9 0 0 0   1     0   1   6 5                 11
1673973 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway - Conway Grammar   Regular School No Elementary PK 06 2021   pre_kindergarten 6 0 0 0   0     0   1   5 2 *                     7.0 6 0 0 0   0     0   1   5 2                 7
1673993 MA Essex   school 2503990 71   Danvers 250399000536 710030 Danvers - Riverside   Regular School No Elementary PK 05 2021   pre_kindergarten 45 4 5 0   1     0   1   34 22 *                     56.0 45 4 5 0   1     0   1   34 22                 56
1674006 MA Essex   school 2503990 71   Danvers 250399000538 710045 Danvers - Willis E Thorpe   Regular School No Elementary PK 05 2021   pre_kindergarten 26 1 4 0   0     0   0   17 14 *                     31.0 26 1 4 0   0     0   0   17 14                 31
1674021 MA Bristol   school 2504020 72   Dartmouth 250402002698 720005 Dartmouth - Andrew B. Cushman School   Regular School No Elementary PK KG 2021   pre_kindergarten 54 1 8 0   0     0   3   33 33 *                     66.0 54 1 8 0   0     0   3   33 33                 66
1674028 MA Bristol   school 2504020 72   Dartmouth 250402000542 720030 Dartmouth - George H Potter   Regular School No Elementary PK 05 2021   pre_kindergarten 13 0 0 0   0     0   0   9 4 *                     13.0 13 0 0 0   0     0   0   9 4                 13
1674048 MA Norfolk   school 2504050 73   Dedham 250405000460 730005 Dedham - Early Childhood Center   Regular School No Elementary PK KG 2021   pre_kindergarten 58 1 6 0   3     0   4   40 32 *                     72.0 58 1 6 0   3     0   4   40 32                 72
1674078 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield - Deerfield Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten 6 0 0 0   0     0   2   6 2 *                     8.0 6 0 0 0   0     0   2   6 2                 8
1674086 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas - Douglas Primary School   Regular School No Elementary PK 01 2021   pre_kindergarten 28 1 1 0   0     0   1   18 13 *                     31.0 28 1 1 0   0     0   1   18 13                 31
1674100 MA Norfolk   school 2504260 78   Dover 250426000573 780005 Dover - Chickering   Regular School No Elementary PK 05 2021   pre_kindergarten 6 0 0 0   1     0   1   5 3 *                     8.0 6 0 0 0   1     0   1   5 3                 8
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
1674143 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Duxbury - Chandler Elementary   Regular School No Elementary PK 02 2021   pre_kindergarten 26 0 1 0   0     0   2   19 10 *                     29.0 26 0 1 0   0     0   2   19 10                 29
1674154 MA Plymouth   school 2504440 83   East Bridgewater 250444000596 830005 East Bridgewater - Central   Regular School No Elementary PK 02 2021   pre_kindergarten 66 3 0 1   0     0   1   40 31 *                     71.0 66 3 0 1   0     0   1   40 31                 71
1674168 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham - Eastham Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten 12 2 3 0   0     0   5   11 11 *                     22.0 12 2 3 0   0     0   5   11 11                 22
1674180 MA Hampshire   school 2504590 86   Easthampton 250459000613 860010 Easthampton - Maple   Regular School No Elementary PK 04 2021   pre_kindergarten 20 0 2 0   0     0   0   16 6 *                     22.0 20 0 2 0   0     0   0   16 6                 22
1674203 MA Hampden   school 2504500 87   East Longmeadow 250450000605 870013 East Longmeadow - Meadow Brook   Regular School No Elementary PK 02 2021   pre_kindergarten 5 1 3 0   2     0   1   6 6 *                     12.0 5 1 3 0   2     0   1   6 6                 12
1674220 MA Bristol   school 2504620 88   Easton 250462000624 880015 Easton - Parkview Elementary   Regular School No Elementary PK 02 2021   pre_kindergarten 27 4 7 0   5     0   3   33 13 *                     46.0 27 4 7 0   5     0   3   33 13                 46
1674224 MA Bristol   school 2504620 88   Easton 250462002381 880020 Easton - Moreau Hall   Regular School No Elementary PK 02 2021   pre_kindergarten 7 1 0 0   1     0   1   4 6 *                     10.0 7 1 0 0   1     0   1   4 6                 10
1674239 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown - Edgartown Elementary   Regular School No Elementary PK 08 2021   pre_kindergarten * * * *   *     *   *   3 2 *                     5.0                         3 2                 5
1674249 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving - Erving Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten 10 0 1 0   0     0   2   10 3 *                     13.0 10 0 1 0   0     0   2   10 3                 13
1674256 MA Middlesex   school 2504770 93   Everett 250477002900 930001 Everett - Webster Extension   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 30 25 66 1   18     0   2   80 62 *                     142.0 30 25 66 1   18     0   2   80 62                 142
1674257 MA Middlesex   school 2504770 93   Everett 250477002804 930003 Everett - Adams School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 28 15 55 0   8     1   1   61 47 *                     108.0 28 15 55 0   8     1   1   61 47                 108
1674324 MA Bristol   school 2504800 94   Fairhaven 250480000640 940010 Fairhaven - East Fairhaven   Regular School No Elementary PK 05 2021   pre_kindergarten 7 0 0 0   1     0   1   8 1 *                     9.0 7 0 0 0   1     0   1   8 1                 9
1674331 MA Bristol   school 2504800 94   Fairhaven 250480000645 940030 Fairhaven - Leroy Wood   Regular School No Elementary PK 05 2021   pre_kindergarten 10 0 1 0   0     0   0   8 3 *                     11.0 10 0 1 0   0     0   0   8 3                 11
1674346 MA Bristol   school 2504830 95   Fall River 250483001780 950005 Fall River - North End Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten 45 7 14 0   0     0   4   44 26 *                     70.0 45 7 14 0   0     0   4   44 26                 70
1674359 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Fall River - Mary Fonseca Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten 10 2 13 0   0     0   4   15 14 *                     29.0 10 2 13 0   0     0   4   15 14                 29
1674366 MA Bristol   school 2504830 95   Fall River 250483002656 950013 Fall River - Letourneau Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten 13 2 7 0   1     0   3   18 8 *                     26.0 13 2 7 0   1     0   3   18 8                 26
1674373 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Fall River - Henry Lord Community School   Regular School No Elementary PK 08 2021   pre_kindergarten 18 1 8 0   2     0   6   24 11 *                     35.0 18 1 8 0   2     0   6   24 11                 35
1674383 MA Bristol   school 2504830 95   Fall River 250483000666 950045 Fall River - John J Doran   Regular School No Elementary PK 08 2021   pre_kindergarten 12 1 3 0   1     0   0   10 7 *                     17.0 12 1 3 0   1     0   0   10 7                 17
1674393 MA Bristol   school 2504830 95   Fall River 250483000684 950065 Fall River - William S Greene   Regular School No Elementary PK 05 2021   pre_kindergarten 16 1 5 0   1     0   0   18 5 *                     23.0 16 1 5 0   1     0   0   18 5                 23
1674400 MA Bristol   school 2504830 95   Fall River 250483000679 950130 Fall River - Spencer Borden   Regular School No Elementary PK 05 2021   pre_kindergarten 11 2 6 0   0     0   4   13 10 *                     23.0 11 2 6 0   0     0   4   13 10                 23
1674448 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 Falmouth - East Falmouth Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten 52 3 9 1   0     0   0   44 21 *                     65.0 52 3 9 1   0     0   0   44 21                 65
1674454 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Falmouth - Teaticket   Regular School No Elementary PK 04 2021   pre_kindergarten 12 2 0 0   0     0   3   9 8 *                     17.0 12 2 0 0   0     0   3   9 8                 17
1674479 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Fitchburg - Crocker Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten 6 2 14 0   0     0   1   13 10 *                     23.0 6 2 14 0   0     0   1   13 10                 23
1674485 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Fitchburg - Reingold Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten 8 1 8 0   0     0   2   17 2 *                     19.0 8 1 8 0   0     0   2   17 2                 19
1674495 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 Fitchburg - South Street Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten 3 3 16 0   1     0   2   16 9 *                     25.0 3 3 16 0   1     0   2   16 9                 25
1674505 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 Fitchburg - McKay Arts Academy   Regular School No Elementary PK 08 2021   pre_kindergarten 6 2 10 0   0     0   1   14 5 *                     19.0 6 2 10 0   0     0   1   14 5                 19
1674514 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg - Fitchburg High   Regular School No High 09 12 2021   pre_kindergarten 5 0 8 0   0     0   2   9 6 *                     15.0 5 0 8 0   0     0   2   9 6                 15
1674534 MA Norfolk   school 2504950 99   Foxborough 250495000710 990015 Foxborough - Mabelle M Burrell   Regular School No Elementary PK 04 2021   pre_kindergarten 43 3 9 0   8     0   4   43 24 *                     67.0 43 3 9 0   8     0   4   43 24                 67
1674558 MA Middlesex   school 2504980 100   Framingham 250498002820 1000001 Framingham - Juniper Hill School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 104 13 58 0   15     1   4   123 72 *                     195.0 104 13 58 0   15     1   4   123 72                 195
1674626 MA Norfolk   school 2505010 101   Franklin 250501000986 1010003 Franklin - Franklin Early Childhood Development Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 58 1 1 0   7     0   6   50 23 *                     73.0 58 1 1 0   7     0   6   50 23                 73
1674681 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Gardner - Waterford Street   Regular School No Elementary PK 01 2021   pre_kindergarten 39 1 14 0   1     0   1   34 22 *                     56.0 39 1 14 0   1     0   1   34 22                 56
1674696 MA Essex   school 2505220 105   Georgetown 250522000766 1050005 Georgetown - Perley Elementary   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 16 0 0 0   0     0   1   13 * *                     17.0 16 0 0 0   0     0   1   13                   17
1674722 MA Essex   school 2505280 107   Gloucester 250528002574 1070025 Gloucester - Gloucester PreSchool   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 54 1 7 0   1     0   3   39 27 *                     66.0 54 1 7 0   1     0   3   39 27                 66
1674750 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   pre_kindergarten * * * *   *     *   *   * * *                     0.0                                             0
1674765 MA Worcester   school 2505370 110   Grafton 250537000788 1100005 Grafton - South Grafton Elementary   Regular School No Elementary PK 01 2021   pre_kindergarten 28 1 4 0   8     0   1   20 22 *                     42.0 28 1 4 0   8     0   1   20 22                 42
1674768 MA Worcester   school 2505370 110   Grafton 250537000787 1100025 Grafton - North Grafton Elementary   Regular School No Elementary PK 01 2021   pre_kindergarten 35 1 1 1   6     0   0   30 14 *                     44.0 35 1 1 1   6     0   0   30 14                 44
1674787 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 Granby - East Meadow   Regular School No Elementary PK 06 2021   pre_kindergarten 16 0 3 0   2     0   3   16 8 *                     24.0 16 0 3 0   2     0   3   16 8                 24
1674800 MA Franklin   school 2505490 114   Greenfield 250549002128 1140005 Greenfield - The Academy of Early Learning at North Parish   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 40 2 10 0   0     0   2   31 23 *                     54.0 40 2 10 0   0     0   2   31 23                 54
1674825 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley - Hadley Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten 15 0 3 0   0     0   0   8 10 *                     18.0 15 0 3 0   0     0   0   8 10                 18
1674846 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock - Hancock Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten * * * *   *     *   *   1 4 *                     5.0                         1 4                 5
1674854 MA Plymouth   school 2505790 122   Hanover 250579000827 1220004 Hanover - Cedar Elementary   Regular School No Elementary PK 01 2021   pre_kindergarten 50 1 0 0   1     0   0   31 21 *                     52.0 50 1 0 0   1     0   0   31 21                 52
1674869 MA Worcester   school 2505880 125   Harvard 250588000839 1250005 Harvard - Hildreth Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten 11 1 3 0   5     0   2   13 9 *                     22.0 11 1 3 0   5     0   2   13 9                 22
1674883 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield - Hatfield Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten 12 0 0 0   0     0   0   8 4 *                     12.0 12 0 0 0   0     0   0   8 4                 12
1674920 MA Essex   school 2505970 128   Haverhill 250597000056 1280045 Haverhill - Moody   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 92 21 66 0   2     0   1   120 62 *                     182.0 92 21 66 0   2     0   1   120 62                 182
1674965 MA Plymouth   school 2506090 131   Hingham 250609002671 1310005 Hingham - East Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten 23 1 3 0   0     0   0   17 10 *                     27.0 23 1 3 0   0     0   0   17 10                 27
1674998 MA Norfolk   school 2506150 133   Holbrook 250615000880 1330018 Holbrook - John F Kennedy   Regular School No Elementary PK 05 2021   pre_kindergarten 21 6 6 0   2     0   2   14 23 *                     37.0 21 6 6 0   2     0   2   14 23                 37
1675013 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland - Holland Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten 10 0 0 1   0     0   0   7 4 *                     11.0 10 0 0 1   0     0   0   7 4                 11
1675024 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Holliston - Placentino Elementary   Regular School No Elementary PK 02 2021   pre_kindergarten 46 1 2 0   10     1   1   38 23 *                     61.0 46 1 2 0   10     1   1   38 23                 61
1675035 MA Hampden   school 2506270 137   Holyoke 250627001178 1370003 Holyoke - Joseph Metcalf School   Regular School No Elementary PK 06 2021   pre_kindergarten 5 0 26 0   0     0   0   16 15 *                     31.0 5 0 26 0   0     0   0   16 15                 31
1675043 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Holyoke - Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2021   pre_kindergarten 10 1 12 0   2     0   0   10 15 *                     25.0 10 1 12 0   2     0   0   10 15                 25
1675053 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Holyoke - Morgan Full Service Community School   Regular School No Elementary PK 04 2021   pre_kindergarten 5 4 53 0   0     0   0   36 26 *                     62.0 5 4 53 0   0     0   0   36 26                 62
1675064 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Holyoke - Kelly Elementary   Regular School No Elementary PK 08 2021   pre_kindergarten 1 1 15 0   0     0   0   12 5 *                     17.0 1 1 15 0   0     0   0   12 5                 17
1675071 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 Holyoke - E N White Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten 24 2 46 0   1     0   3   46 30 *                     76.0 24 2 46 0   1     0   3   46 30                 76
1675078 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Holyoke - Lt Clayre Sullivan Elementary   Regular School No Elementary PK 08 2021   pre_kindergarten 4 0 18 0   1     0   0   12 11 *                     23.0 4 0 18 0   1     0   0   12 11                 23

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