Data source: Big Local News · About: Big Local

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

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
1672989 MA Suffolk   school 2502790 35   Boston 250279000332 350328 Boston - Thomas J Kenny   Regular School No Elementary PK 06 2021   pre_kindergarten 14 8 3 0   2     0   0   17 10 *                     27.0 14 8 3 0   2     0   0   17 10                 27
1672997 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Boston - Warren-Prescott   Regular School No Elementary PK 08 2021   pre_kindergarten 36 3 6 0   2     0   1   34 14 *                     48.0 36 3 6 0   2     0   1   34 14                 48
1673026 MA Suffolk   school 2502790 35   Boston 250279000337 350366 Boston - William E Russell   Regular School No Elementary PK 05 2021   pre_kindergarten 3 20 22 0   4     2   1   27 25 *                     52.0 3 20 22 0   4     2   1   27 25                 52
1673007 MA Suffolk   school 2502790 35   Boston 250279000338 350360 Boston - William Ellery Channing   Regular School No Elementary PK 06 2021   pre_kindergarten 3 15 6 0   0     0   0   16 8 *                     24.0 3 15 6 0   0     0   0   16 8                 24
1673033 MA Suffolk   school 2502790 35   Boston 250279000343 350370 Boston - William Monroe Trotter   Regular School No Elementary PK 08 2021   pre_kindergarten 1 18 16 0   3     0   1   26 13 *                     39.0 1 18 16 0   3     0   1   26 13                 39
1673043 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Boston - Winship Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten 13 3 12 1   6     0   0   21 14 *                     35.0 13 3 12 1   6     0   0   21 14                 35
1672904 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Boston - Lyndon   Regular School No Elementary PK 08 2021   pre_kindergarten 45 2 9 0   4     0   4   29 35 *                     64.0 45 2 9 0   4     0   4   29 35                 64
1673086 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Boston - Young Achievers   Alternative School No Elementary PK 08 2021   pre_kindergarten 0 21 17 0   0     0   0   12 26 *                     38.0 0 21 17 0   0     0   0   12 26                 38
1673096 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Boston - Mission Hill School   Regular School No Elementary PK 08 2021   pre_kindergarten 15 8 5 0   1     0   2   16 15 *                     31.0 15 8 5 0   1     0   2   16 15                 31
1672509 MA Suffolk   school 2502790 35   Boston 250279001115 350008 Boston - Dr. Catherine Ellison-Rosa Parks Early Ed School   Regular School No Elementary PK 03 2021   pre_kindergarten 4 25 17 0   0     0   0   20 26 *                     46.0 4 25 17 0   0     0   0   20 26                 46
1672514 MA Suffolk   school 2502790 35   Boston 250279001118 350009 Boston - East Boston Early Childhood Center   Regular School No Elementary PK 01 2021   pre_kindergarten 24 4 38 1   2     0   2   38 33 *                     71.0 24 4 38 1   2     0   2   38 33                 71
1672517 MA Suffolk   school 2502790 35   Boston 250279001126 350010 Boston - Haynes Early Education Center   Regular School No Elementary PK 01 2021   pre_kindergarten 4 21 19 0   2     0   4   32 18 *                     50.0 4 21 19 0   2     0   4   32 18                 50
1672489 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Boston - Lee Academy   Regular School No Elementary PK 03 2021   pre_kindergarten 6 18 19 0   2     0   2   23 24 *                     47.0 6 18 19 0   2     0   2   23 24                 47
1672888 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Boston - Orchard Gardens   Regular School No Elementary PK 08 2021   pre_kindergarten 1 18 28 1   0     0   1   27 22 *                     49.0 1 18 28 1   0     0   1   27 22                 49
1673278 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston - Horace Mann School for the Deaf   Special Education School No Other 01 12 2021   pre_kindergarten * * * *   *     *   *   1 3 *                     4.0                         1 3                 4
1672506 MA Suffolk   school 2502790 35   Boston 250279002514 350006 Boston - ELC - West Zone   Regular School No Elementary PK 01 2021   pre_kindergarten 7 7 18 0   5     0   2   21 18 *                     39.0 7 7 18 0   5     0   2   21 18                 39
1672687 MA Suffolk   school 2502790 35   Boston 250279002569 350138 Boston - O W Holmes   Regular School No Elementary PK 05 2021   pre_kindergarten 2 7 11 0   2     0   0   16 6 *                     22.0 2 7 11 0   2     0   0   16 6                 22
1672555 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Boston - Curley K-8 School   Regular School No Elementary PK 08 2021   pre_kindergarten 37 13 23 0   1     0   12   44 42 *                     86.0 37 13 23 0   1     0   12   44 42                 86
1673060 MA Suffolk   school 2502790 35   Boston 250279002669 350376 Boston - King K-8   Regular School No Elementary PK 08 2021   pre_kindergarten 4 33 22 0   5     1   0   37 28 *                     65.0 4 33 22 0   5     1   0   37 28                 65
1673076 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Boston - Mildred Avenue K-8   Regular School No Elementary PK 08 2021   pre_kindergarten 3 22 8 1   0     0   3   21 16 *                     37.0 3 22 8 1   0     0   3   21 16                 37
1672520 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston - Boston Teachers Union School   Regular School No Elementary PK 08 2021   pre_kindergarten 12 2 12 0   0     0   1   14 13 *                     27.0 12 2 12 0   0     0   1   14 13                 27
1673050 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Boston - Edison K-8   Regular School No Elementary PK 08 2021   pre_kindergarten 1 1 14 0   2     0   1   9 10 *                     19.0 1 1 14 0   2     0   1   9 10                 19
1673248 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Boston - Mario Umana Academy   Regular School No Elementary PK 08 2021   pre_kindergarten 3 1 21 0   1     0   0   13 13 *                     26.0 3 1 21 0   1     0   0   13 13                 26
1672545 MA Suffolk   school 2502790 35   Boston 250279002806 350015 Boston - Higginson   Regular School No Elementary PK 02 2021   pre_kindergarten 0 15 14 0   1     0   0   16 14 *                     30.0 0 15 14 0   1     0   0   16 14                 30
1672595 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Boston - Dante Alighieri Montessori School   Regular School No Elementary PK 06 2021   pre_kindergarten 8 0 13 0   1     0   4   17 9 *                     26.0 8 0 13 0   1     0   4   17 9                 26
1672540 MA Suffolk   school 2502790 35   Boston 250279002839 350014 Boston - Pauline Agassiz Shaw Elementary School   Regular School No Elementary PK 03 2021   pre_kindergarten 0 21 9 0   1     0   0   15 16 *                     31.0 0 21 9 0   1     0   0   15 16                 31
1672549 MA Suffolk   school 2502790 35   Boston 250279002874 350016 Boston - Mattahunt Elementary School   Regular School No Elementary PK 04 2021   pre_kindergarten 2 49 17 0   0     0   1   41 28 *                     69.0 2 49 17 0   0     0   1   41 28                 69
1673294 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bourne - Bournedale Elementary School   Regular School No Elementary PK 02 2021   pre_kindergarten 32 2 2 0   1     0   2   20 19 *                     39.0 32 2 2 0   1     0   2   20 19                 39
1673309 MA Essex   school 2502880 38   Boxford 250288000357 380005 Boxford - Harry Lee Cole   Regular School No Elementary PK 02 2021   pre_kindergarten 24 0 2 0   1     0   0   15 12 *                     27.0 24 0 2 0   1     0   0   15 12                 27
1673355 MA Norfolk   school 2502940 40   Braintree 250294000361 400505 Braintree - Braintree High   Regular School No High 09 12 2021   pre_kindergarten 42 5 3 0   26     0   3   51 28 *                     79.0 42 5 3 0   26     0   3   51 28                 79
1673361 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Brewster - Stony Brook Elementary   Regular School No Elementary PK 02 2021   pre_kindergarten 13 1 3 0   0     0   1   9 9 *                     18.0 13 1 3 0   0     0   1   9 9                 18
1680434 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Bridgewater-Raynham - Mitchell Elementary School   Regular School No Elementary PK 03 2021   pre_kindergarten 62 6 8 0   6     0   11   63 30 *                     93.0 62 6 8 0   6     0   11   63 30                 93
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1680469 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Central Berkshire - Becket Washington School   Regular School No Elementary PK 05 2021   pre_kindergarten 12 0 0 0   0     0   1   8 5 *                     13.0 12 0 0 0   0     0   1   8 5                 13
1680482 MA Berkshire   school 2503390 635   Central Berkshire 250339000465 6350035 Central Berkshire - Kittredge   Regular School No Elementary PK 05 2021   pre_kindergarten 26 0 2 0   0     0   0   15 13 *                     28.0 26 0 2 0   0     0   0   15 13                 28
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
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
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
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
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
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
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
1680501 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Dennis-Yarmouth - Ezra H Baker Innovation School   Regular School No Elementary PK 03 2021   pre_kindergarten 23 1 2 2   3     0   1   20 12 *                     32.0 23 1 2 2   3     0   1   20 12                 32
1680506 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Dennis-Yarmouth - Marguerite E Small Elementary   Regular School No Elementary PK 03 2021   pre_kindergarten 34 6 3 0   1     0   1   23 22 *                     45.0 34 6 3 0   1     0   1   23 22                 45
1680525 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002427 6500005 Dighton-Rehoboth - Dighton Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten 8 1 0 0   1     0   0   6 4 *                     10.0 8 1 0 0   1     0   0   6 4                 10
1680531 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002428 6500010 Dighton-Rehoboth - Palmer River   Regular School No Elementary PK 04 2021   pre_kindergarten 24 0 3 0   0     0   1   14 14 *                     28.0 24 0 3 0   0     0   1   14 14                 28
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
1680564 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000585 6580020 Dudley-Charlton Reg - Charlton Elementary   Regular School No Elementary PK 01 2021   pre_kindergarten 39 0 2 0   0     0   1   18 24 *                     42.0 39 0 2 0   0     0   1   18 24                 42
1680561 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000590 6580010 Dudley-Charlton Reg - Mason Road School   Regular School No Elementary PK 01 2021   pre_kindergarten 26 0 2 0   1     0   2   18 13 *                     31.0 26 0 2 0   1     0   2   18 13                 31
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
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
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
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
1677033 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs - Oak Bluffs Elementary   Regular School No Elementary PK 08 2021   pre_kindergarten 5 0 2 0   0     0   0   6 1 *                     7.0 5 0 2 0   0     0   0   6 1                 7
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
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
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
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
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

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