Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2021 · 530

grade

  • pre_kindergarten · 530
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
1672008 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington - Abington Early Education Program   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 44 4 2 0   1     0   0   28 23 *                     51.0 44 4 2 0   1     0   0   28 23                 51
1672177 MA Middlesex   school 2501980 10   Arlington 250198001681 100038 Arlington - Menotomy Preschool   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 38 4 5 0   14     0   4   35 30 *                     65.0 38 4 5 0   14     0   4   35 30                 65
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
1675088 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Holyoke - Maurice A Donahue Elementary   Regular School No Elementary PK 08 2021   pre_kindergarten 6 1 24 0   0     0   1   18 14 *                     32.0 6 1 24 0   0     0   1   18 14                 32
1675110 MA Worcester   school 2506300 138   Hopedale 250630002041 1380003 Hopedale - Park Street School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 59 2 6 0   1     0   12   43 37 *                     80.0 59 2 6 0   1     0   12   43 37                 80
1675124 MA Middlesex   school 2506330 139   Hopkinton 250633002043 1390003 Hopkinton - Hopkinton Pre-School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 46 0 5 0   19     0   5   48 27 *                     75.0 46 0 5 0   19     0   5   48 27                 75
1672203 MA Middlesex   school 2502100 14   Ashland 250210002455 140005 Ashland - William Pittaway Elementary   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 32 2 3 0   12     0   1   34 16 *                     50.0 32 2 3 0   12     0   1   34 16                 50
1675140 MA Middlesex   school 2506390 141   Hudson 250639000924 1410007 Hudson - Mulready Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten 11 0 1 0   0     0   0   10 2 *                     12.0 11 0 1 0   0     0   0   10 2                 12
1675151 MA Middlesex   school 2506390 141   Hudson 250639000922 1410030 Hudson - C A Farley   Regular School No Elementary PK 04 2021   pre_kindergarten 10 0 3 0   0     0   1   10 4 *                     14.0 10 0 3 0   0     0   1   10 4                 14
1675165 MA Plymouth   school 2506420 142   Hull 250642000932 1420015 Hull - Lillian M Jacobs   Regular School No Elementary PK 05 2021   pre_kindergarten 28 0 3 0   0     0   0   22 9 *                     31.0 28 0 3 0   0     0   0   22 9                 31
1675185 MA Essex   school 2506480 144   Ipswich 250648000939 1440015 Ipswich - Winthrop   Regular School No Elementary PK 05 2021   pre_kindergarten 17 0 8 0   1     0   1   13 14 *                     27.0 17 0 8 0   1     0   1   13 14                 27
1675206 MA Essex   school 2506660 149   Lawrence 250666002651 1490001 Lawrence - Rollins Early Childhood Center   Regular School No Elementary PK KG 2021   pre_kindergarten 3 2 84 0   1     0   1   56 35 *                     91.0 3 2 84 0   1     0   1   56 35                 91
1675209 MA Essex   school 2506660 149   Lawrence 250666000730 1490003 Lawrence - John Breen School   Regular School No Elementary PK KG 2021   pre_kindergarten 6 3 106 0   1     0   0   63 53 *                     116.0 6 3 106 0   1     0   0   63 53                 116
1675221 MA Essex   school 2506660 149   Lawrence 250666002815 1490011 Lawrence - Lawrence Family Public Academy   Regular School No Elementary PK KG 2021   pre_kindergarten 0 2 32 0   1     0   0   19 16 *                     35.0 0 2 32 0   1     0   0   19 16                 35
1675238 MA Essex   school 2506660 149   Lawrence 250666000958 1490020 Lawrence - James F Hennessey   Regular School No Elementary PK 02 2021   pre_kindergarten 2 1 76 0   1     0   0   47 33 *                     80.0 2 1 76 0   1     0   0   47 33                 80
1675316 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee - Lee Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten 8 0 1 0   1     0   2   5 7 *                     12.0 8 0 1 0   1     0   2   5 7                 12
1675330 MA Worcester   school 2506720 151   Leicester 250672002911 1510001 Leicester - Leicester Integrated Preschool   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 23 1 7 0   0     0   2   14 19 *                     33.0 23 1 7 0   0     0   2   14 19                 33
1675345 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Lenox - Morris   Regular School No Elementary PK 05 2021   pre_kindergarten 14 0 1 0   0     0   0   12 3 *                     15.0 14 0 1 0   0     0   0   12 3                 15
1675358 MA Worcester   school 2506780 153   Leominster 250678000064 1530003 Leominster - Bennett   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 18 6 25 0   0     0   2   31 20 *                     51.0 18 6 25 0   0     0   2   31 20                 51
1675359 MA Worcester   school 2506780 153   Leominster 250678001947 1530005 Leominster - Lincoln School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 8 3 11 0   0     0   2   14 10 *                     24.0 8 3 11 0   0     0   2   14 10                 24
1675410 MA Middlesex   school 2506840 155   Lexington 250684002829 1550001 Lexington - Lexington Children's Place   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 27 2 1 1   22     0   4   36 21 *                     57.0 27 2 1 1   22     0   4   36 21                 57
1675458 MA Middlesex   school 2506900 157   Lincoln 250690001009 1570006 Lincoln - Hanscom Primary   Regular School No Elementary PK 03 2021   pre_kindergarten 33 3 11 0   0     2   6   33 22 *                     55.0 33 3 11 0   0     2   6   33 22                 55
1675463 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln - Lincoln School   Regular School No Elementary PK 08 2021   pre_kindergarten 9 0 1 0   7     0   3   10 10 *                     20.0 9 0 1 0   7     0   3   10 10                 20
1675478 MA Middlesex   school 2506960 158   Littleton 250696001014 1580005 Littleton - Shaker Lane Elementary   Regular School No Elementary PK 02 2021   pre_kindergarten 26 0 1 0   6     1   0   22 12 *                     34.0 26 0 1 0   6     1   0   22 12                 34
1675507 MA Hampden   school 2506990 159   Longmeadow 250699001022 1590025 Longmeadow - Wolf Swamp Road   Regular School No Elementary PK 05 2021   pre_kindergarten 43 0 2 0   9     0   5   32 27 *                     59.0 43 0 2 0   9     0   5   32 27                 59
1672222 MA Bristol   school 2502190 16   Attleboro 250219001610 160008 Attleboro - Early Learning Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 73 8 12 0   5     0   6   66 38 *                     104.0 73 8 12 0   5     0   6   66 38                 104
1675520 MA Middlesex   school 2507020 160   Lowell 250702002891 1600001 Lowell - Cardinal O'Connell Early Learning Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 18 4 23 0   23     0   2   46 24 *                     70.0 18 4 23 0   23     0   2   46 24                 70
1675522 MA Middlesex   school 2507020 160   Lowell 250702000067 1600002 Lowell - Dr Gertrude Bailey   Regular School No Elementary PK 04 2021   pre_kindergarten 5 2 3 0   9     0   1   9 11 *                     20.0 5 2 3 0   9     0   1   9 11                 20
1675537 MA Middlesex   school 2507020 160   Lowell 250702000477 1600010 Lowell - Joseph McAvinnue   Regular School No Elementary PK 04 2021   pre_kindergarten 6 4 6 0   7     0   0   10 13 *                     23.0 6 4 6 0   7     0   0   10 13                 23
1675543 MA Middlesex   school 2507020 160   Lowell 250702001033 1600015 Lowell - Greenhalge   Regular School No Elementary PK 04 2021   pre_kindergarten 9 2 13 0   7     0   2   20 13 *                     33.0 9 2 13 0   7     0   2   20 13                 33
1675549 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Lowell - Pyne Arts   Regular School No Elementary PK 08 2021   pre_kindergarten 5 5 5 0   3     0   1   11 8 *                     19.0 5 5 5 0   3     0   1   11 8                 19
1675559 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Lowell - Abraham Lincoln   Regular School No Elementary PK 04 2021   pre_kindergarten 1 4 5 0   13     0   4   16 11 *                     27.0 1 4 5 0   13     0   4   16 11                 27
1675570 MA Middlesex   school 2507020 160   Lowell 250702001029 1600030 Lowell - Charles W Morey   Regular School No Elementary PK 04 2021   pre_kindergarten 3 6 3 0   33     0   0   28 17 *                     45.0 3 6 3 0   33     0   0   28 17                 45
1675576 MA Middlesex   school 2507020 160   Lowell 250702001044 1600036 Lowell - Pawtucketville Memorial   Regular School No Elementary PK 04 2021   pre_kindergarten 9 2 6 0   8     0   2   17 10 *                     27.0 9 2 6 0   8     0   2   17 10                 27
1675582 MA Middlesex   school 2507020 160   Lowell 250702001045 1600040 Lowell - Peter W Reilly   Regular School No Elementary PK 04 2021   pre_kindergarten 14 2 8 0   3     0   1   17 11 *                     28.0 14 2 8 0   3     0   1   17 11                 28
1675588 MA Middlesex   school 2507020 160   Lowell 250702001048 1600050 Lowell - John J Shaughnessy   Regular School No Elementary PK 04 2021   pre_kindergarten 4 3 4 0   7     0   0   12 6 *                     18.0 4 3 4 0   7     0   0   12 6                 18
1675594 MA Middlesex   school 2507020 160   Lowell 250702001051 1600055 Lowell - Washington   Regular School No Elementary PK 04 2021   pre_kindergarten 5 0 6 0   11     0   1   15 8 *                     23.0 5 0 6 0   11     0   1   15 8                 23
1675600 MA Middlesex   school 2507020 160   Lowell 250702000088 1600075 Lowell - S Christa McAuliffe Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten 10 4 18 0   6     0   3   16 25 *                     41.0 10 4 18 0   6     0   3   16 25                 41
1675606 MA Middlesex   school 2507020 160   Lowell 250702000092 1600080 Lowell - Charlotte M Murkland Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten 10 3 12 0   14     0   1   22 18 *                     40.0 10 3 12 0   14     0   1   22 18                 40
1675617 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Lowell - Bartlett Community Partnership   Regular School No Elementary PK 08 2021   pre_kindergarten 5 5 6 0   21     0   1   13 25 *                     38.0 5 5 6 0   21     0   1   13 25                 38
1675670 MA Hampden   school 2507050 161   Ludlow 250705002663 1610010 Ludlow - East Street Elementary School   Regular School No Elementary PK 01 2021   pre_kindergarten 35 0 8 0   3     1   2   38 11 *                     49.0 35 0 8 0   3     1   2   38 11                 49
1675684 MA Worcester   school 2507080 162   Lunenburg 250708001957 1620010 Lunenburg - Lunenburg Primary School   Regular School No Elementary PK 02 2021   pre_kindergarten 25 0 5 0   1     0   2   21 12 *                     33.0 25 0 5 0   1     0   2   21 12                 33
1675698 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   pre_kindergarten * * * *   *     *   *   * * *                     0.0                                             0
1675713 MA Essex   school 2507110 163   Lynn 250711002658 1630005 Lynn - Washington Elementary School   Regular School No Elementary KG 05 2021   pre_kindergarten 0 4 10 0   2     0   0   11 5 *                     16.0 0 4 10 0   2     0   0   11 5                 16
1675726 MA Essex   school 2507110 163   Lynn 250711001062 1630016 Lynn - A Drewicz Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1675739 MA Essex   school 2507110 163   Lynn 250711001077 1630030 Lynn - Julia F Callahan   Regular School No Elementary PK 05 2021   pre_kindergarten 7 0 20 0   3     0   2   20 12 *                     32.0 7 0 20 0   3     0   2   20 12                 32
1675752 MA Essex   school 2507110 163   Lynn 250711001087 1630040 Lynn - Wm P Connery   Regular School No Elementary PK 05 2021   pre_kindergarten 0 0 9 0   0     0   0   6 3 *                     9.0 0 0 9 0   0     0   0   6 3                 9
1675759 MA Essex   school 2507110 163   Lynn 250711001070 1630045 Lynn - E J Harrington   Regular School No Elementary PK 05 2021   pre_kindergarten 4 10 21 0   2     0   2   21 18 *                     39.0 4 10 21 0   2     0   2   21 18                 39
1675771 MA Essex   school 2507110 163   Lynn 250711001074 1630055 Lynn - Hood   Regular School No Elementary PK 05 2021   pre_kindergarten 5 6 16 0   2     0   0   17 12 *                     29.0 5 6 16 0   2     0   0   17 12                 29
1675813 MA Essex   school 2507110 163   Lynn 250711001072 1630095 Lynn - Edward A Sisson   Regular School No Elementary PK 05 2021   pre_kindergarten 2 0 9 0   0     0   2   9 4 *                     13.0 2 0 9 0   0     0   2   9 4                 13
1675848 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn - Lynn Vocational Technical Institute   Career and Technical School No Other PK 12 2021   pre_kindergarten 4 0 28 0   0     0   2   21 13 *                     34.0 4 0 28 0   0     0   2   21 13                 34
1675857 MA Essex   school 2507140 164   Lynnfield 250714002617 1640005 Lynnfield - Lynnfield Preschool   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 19 1 2 0   2     0   3   12 15 *                     27.0 19 1 2 0   2     0   3   12 15                 27
1675912 MA Middlesex   school 2507170 165   Malden 250717002046 1650049 Malden - Malden Early Learning Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 72 37 14 0   82     0   12   136 81 *                     217.0 72 37 14 0   82     0   12   136 81                 217
1675927 MA Bristol   school 2507230 167   Mansfield 250723001004 1670003 Mansfield - Roland Green School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 69 3 10 1   3     0   5   54 37 *                     91.0 69 3 10 1   3     0   5   54 37                 91
1675949 MA Essex   school 2507260 168   Marblehead 250726001121 1680020 Marblehead - Glover   Regular School No Elementary PK 03 2021   pre_kindergarten 30 0 8 0   1     0   2   25 16 *                     41.0 30 0 8 0   1     0   2   25 16                 41
1675962 MA Plymouth   school 2507290 169   Marion 250729001127 1690005 Marion - Sippican   Regular School No Elementary PK 06 2021   pre_kindergarten 12 0 1 0   0     0   0   5 8 *                     13.0 12 0 1 0   0     0   0   5 8                 13
1672275 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn - Auburn Senior High   Regular School No High 09 12 2021   pre_kindergarten 51 6 3 0   6     0   0   39 27 *                     66.0 51 6 3 0   6     0   0   39 27                 66
1675969 MA Middlesex   school 2507320 170   Marlborough 250732001368 1700006 Marlborough - Early Childhood Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 80 11 48 0   12     0   6   96 61 *                     157.0 80 11 48 0   12     0   6   96 61                 157
1676015 MA Plymouth   school 2507350 171   Marshfield 250735001137 1710015 Marshfield - Daniel Webster   Regular School No Elementary PK 05 2021   pre_kindergarten 61 1 0 0   0     0   0   37 25 *                     62.0 61 1 0 0   0     0   0   37 25                 62
1676028 MA Plymouth   school 2507350 171   Marshfield 250735001139 1710025 Marshfield - Martinson Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten 34 1 0 0   1     0   0   20 16 *                     36.0 34 1 0 0   1     0   0   20 16                 36
1676042 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Mashpee - Kenneth Coombs School   Regular School No Elementary PK 02 2021   pre_kindergarten 44 2 3 2   0     0   3   21 33 *                     54.0 44 2 3 2   0     0   3   21 33                 54
1676056 MA Plymouth   school 2507470 173   Mattapoisett 250747001148 1730005 Mattapoisett - Center   Regular School No Elementary PK 03 2021   pre_kindergarten 20 0 1 0   0     0   0   13 8 *                     21.0 20 0 1 0   0     0   0   13 8                 21
1676064 MA Middlesex   school 2507500 174   Maynard 250750001152 1740010 Maynard - Green Meadow   Regular School No Elementary PK 03 2021   pre_kindergarten 24 0 3 1   4     0   2   20 14 *                     34.0 24 0 3 1   4     0   2   20 14                 34
1676079 MA Norfolk   school 2507530 175   Medfield 250753000114 1750003 Medfield - Memorial School   Regular School No Elementary PK 01 2021   pre_kindergarten 30 0 1 0   1     0   4   23 13 *                     36.0 30 0 1 0   1     0   4   23 13                 36
1676093 MA Middlesex   school 2507560 176   Medford 250756001634 1760068 Medford - John J McGlynn Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten 4 0 1 0   1     0   0   3 3 *                     6.0 4 0 1 0   1     0   0   3 3                 6
1676100 MA Middlesex   school 2507560 176   Medford 250756002049 1760130 Medford - Brooks School   Regular School No Elementary PK 05 2021   pre_kindergarten 20 8 6 0   6     0   2   22 20 *                     42.0 20 8 6 0   6     0   2   22 20                 42
1676107 MA Middlesex   school 2507560 176   Medford 250756002057 1760140 Medford - Christopher Columbus   Regular School No Elementary PK 05 2021   pre_kindergarten 4 1 1 0   0     0   1   4 3 *                     7.0 4 1 1 0   0     0   1   4 3                 7
1676114 MA Middlesex   school 2507560 176   Medford 250756002062 1760150 Medford - Milton Fuller Roberts   Regular School No Elementary PK 05 2021   pre_kindergarten 7 0 0 0   2     0   2   9 2 *                     11.0 7 0 0 0   2     0   2   9 2                 11
1676134 MA Norfolk   school 2507590 177   Medway 250759001185 1770013 Medway - John D Mc Govern Elementary   Regular School No Elementary PK 01 2021   pre_kindergarten 18 1 2 0   2     0   4   20 7 *                     27.0 18 1 2 0   2     0   4   20 7                 27
1676148 MA Middlesex   school 2507620 178   Melrose 250762001800 1780003 Melrose - Early Childhood Center   Regular School No Elementary PK KG 2021   pre_kindergarten 87 9 6 2   6     0   8   66 52 *                     118.0 87 9 6 2   6     0   8   66 52                 118
1672282 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Avon - Ralph D Butler   Regular School No Elementary PK 06 2021   pre_kindergarten 1 4 2 0   1     0   3   4 7 *                     11.0 1 4 2 0   1     0   3   4 7                 11
1676188 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Methuen - Marsh Grammar School   Regular School No Elementary PK 08 2021   pre_kindergarten 7 2 9 0   1     0   0   13 6 *                     19.0 7 2 9 0   1     0   0   13 6                 19
1676198 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Methuen - Comprehensive Grammar School   Regular School No Elementary PK 08 2021   pre_kindergarten 2 2 5 0   0     0   3   6 6 *                     12.0 2 2 5 0   0     0   3   6 6                 12
1676208 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Methuen - Tenney Grammar School   Regular School No Elementary PK 08 2021   pre_kindergarten 8 0 10 0   1     0   1   15 5 *                     20.0 8 0 10 0   1     0   1   15 5                 20
1676218 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Methuen - Donald P Timony Grammar   Regular School No Elementary PK 08 2021   pre_kindergarten 15 2 13 0   0     0   1   22 9 *                     31.0 15 2 13 0   0     0   1   22 9                 31

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