Data source: Big Local News · About: Big Local

3,669 rows where grade = "pre_kindergarten" and state = "MA" sorted by school_state_id descending

View and edit SQL

year

grade

  • pre_kindergarten · 3,669
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
745157 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes 1 PK 06 2015   pre_kindergarten 0 33 21 0   0     0   4   35 23                       58 0 33 21 0   0     0   4   35 23                 58
941980 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes 1 PK 07 2016   pre_kindergarten 50 2 2 0   0     0   0   23 31                       54 50 2 2 0   0     0   0   23 31                 54
1133137 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2017   pre_kindergarten 2 28 20 0   0     0   2   28 24                       52 2 28 20 0   0     0   2   28 24                 52
1374211 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2020   pre_kindergarten 0 32 26 0   0     0   2   25 35 *                     60.0 0 32 26 0   0     0   2   25 35                 60
1681456 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester (District) - UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2021   pre_kindergarten 3 29 21 0   0     0   1   27 27 *                     54.0 3 29 21 0   0     0   1   27 27                 54
2049285 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2019   pre_kindergarten 1 28 25 1   0     1   0   22 34                       56.0 1 28 25 1   0     1   0   22 34                 56
2239954 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester (District): UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2018   pre_kindergarten 2 25 29 0   2     0   1   32 27                       59.0 2 25 29 0   2     0   1   32 27                 59
2049140 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman Hanson Regional   Regular School No High 09 12 2019   pre_kindergarten 91 4 4 0   0     0   5   59 45                       104.0 91 4 4 0   0     0   5   59 45                 104
745004 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000199 7800025 Maquan Elementary   Regular School No 1 PK 02 2015   pre_kindergarten 95 3 5 1   0     0   0   61 43                       104 95 3 5 1   0     0   0   61 43                 104
941825 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000199 7800025 Maquan Elementary   Regular School No 1 PK 02 2016   pre_kindergarten 95 2 3 2   3     0   3   74 34                       108 95 2 3 2   3     0   3   74 34                 108
1132944 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000199 7800025 Maquan Elementary   Regular School No Elementary PK 02 2017   pre_kindergarten 99 2 6 0   1     0   5   72 41                       113 99 2 6 0   1     0   5   72 41                 113
2239759 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000199 7800025 Whitman-Hanson: Maquan Elementary   Regular School No Elementary PK 02 2018   pre_kindergarten 95 3 7 0   0     0   7   61 51                       112.0 95 3 7 0   0     0   7   61 51                 112
1374042 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002902 7800001 The Pre-School Academy at Whitman Hanson   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 91 3 5 0   3     0   7   67 42 *                     109.0 91 3 5 0   3     0   7   67 42                 109
1681290 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002902 7800001 Whitman-Hanson - The Pre-School Academy at Whitman Hanson   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 68 3 4 0   3     0   2   55 25 *                     80.0 68 3 4 0   3     0   2   55 25                 80
744984 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 West Brookfield Elementary   Regular School No 1 PK 06 2015   pre_kindergarten 20 0 2 0   0     0   0   10 12                       22 20 0 2 0   0     0   0   10 12                 22
941805 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 West Brookfield Elementary   Regular School No 1 PK 06 2016   pre_kindergarten 23 0 2 0   0     0   0   15 10                       25 23 0 2 0   0     0   0   15 10                 25
1132920 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 West Brookfield Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten 21 0 5 0   0     0   0   16 10                       26 21 0 5 0   0     0   0   16 10                 26
1374029 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 West Brookfield Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten 17 0 3 0   0     0   0   9 11 *                     20.0 17 0 3 0   0     0   0   9 11                 20
1681277 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 Quaboag Regional - West Brookfield Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten 10 0 2 0   0     0   2   8 6 *                     14.0 10 0 2 0   0     0   2   8 6                 14
2049102 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 West Brookfield Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten 22 0 2 0   0     0   0   13 11                       24.0 22 0 2 0   0     0   0   13 11                 24
2239735 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 Quaboag Regional: West Brookfield Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten 22 0 5 0   0     0   0   16 11                       27.0 22 0 5 0   0     0   0   16 11                 27
744976 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Warren Elementary   Regular School No 1 PK 06 2015   pre_kindergarten 25 1 1 0   0     0   1   14 14                       28 25 1 1 0   0     0   1   14 14                 28
941797 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Warren Elementary   Regular School No 1 PK 06 2016   pre_kindergarten 27 0 0 0   0     0   3   21 9                       30 27 0 0 0   0     0   3   21 9                 30
1132911 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Warren Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten 36 0 0 0   0     0   0   16 20                       36 36 0 0 0   0     0   0   16 20                 36
1374021 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Warren Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten 21 0 2 0   0     0   2   14 11 *                     25.0 21 0 2 0   0     0   2   14 11                 25
1681269 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Quaboag Regional - Warren Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten 22 0 1 0   0     0   0   15 8 *                     23.0 22 0 1 0   0     0   0   15 8                 23
2049094 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Warren Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten 31 0 2 0   0     0   3   21 15                       36.0 31 0 2 0   0     0   3   21 15                 36
2239726 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Quaboag Regional: Warren Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten 33 0 1 0   0     0   2   18 18                       36.0 33 0 1 0   0     0   2   18 18                 36
744912 MA Worcester   school 2511880 775   Wachusett 251188002730 7750001 Early Childhood Center   Regular School No 1 PK PK 2015   pre_kindergarten 120 4 13 0   5     1   5   94 54                       148 120 4 13 0   5     1   5   94 54                 148
941733 MA Worcester   school 2511880 775   Wachusett 251188002730 7750001 Early Childhood Center   Regular School No 1 PK PK 2016   pre_kindergarten 117 3 7 0   2     1   4   80 54                       134 117 3 7 0   2     1   4   80 54                 134
1132835 MA Worcester   school 2511880 775   Wachusett 251188002730 7750001 Early Childhood Center   Regular School No Elementary PK PK 2017   pre_kindergarten 126 2 10 1   7     1   3   83 67                       150 126 2 10 1   7     1   3   83 67                 150
1373957 MA Worcester   school 2511880 775   Wachusett 251188002730 7750001 Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 134 2 12 0   7     0   4   95 64 *                     159.0 134 2 12 0   7     0   4   95 64                 159
1681205 MA Worcester   school 2511880 775   Wachusett 251188002730 7750001 Wachusett - Early Childhood Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 71 2 13 0   5     0   2   58 35 *                     93.0 71 2 13 0   5     0   2   58 35                 93
2049031 MA Worcester   school 2511880 775   Wachusett 251188002730 7750001 Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 128 5 13 0   4     0   4   94 60                       154.0 128 5 13 0   4     0   4   94 60                 154
2239650 MA Worcester   school 2511880 775   Wachusett 251188002730 7750001 Wachusett: Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 134 3 12 0   8     1   4   94 68                       162.0 134 3 12 0   8     1   4   94 68                 162
744903 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No 1 PK 08 2015   pre_kindergarten 6 0 0 0   0     0   0   4 2                       6 6 0 0 0   0     0   0   4 2                 6
941724 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No 1 PK 08 2016   pre_kindergarten 8 0 0 0   0     0   0   5 3                       8 8 0 0 0   0     0   0   5 3                 8
1132825 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2017   pre_kindergarten 7 0 1 0   0     0   1   5 4                       9 7 0 1 0   0     0   1   5 4                 9
1373948 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2020   pre_kindergarten 5 0 2 1   0     0   0   4 4 *                     8.0 5 0 2 1   0     0   0   4 4                 8
1681196 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 Up-Island Regional - West Tisbury Elementary   Regular School No Elementary PK 08 2021   pre_kindergarten 6 0 2 0   0     0   0   5 3 *                     8.0 6 0 2 0   0     0   0   5 3                 8
2049021 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2019   pre_kindergarten 4 0 1 1   0     0   1   3 4                       7.0 4 0 1 1   0     0   1   3 4                 7
2239640 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 Up-Island Regional: West Tisbury Elementary   Regular School No Elementary PK 08 2018   pre_kindergarten 3 0 1 1   0     0   1   4 2                       6.0 3 0 1 1   0     0   1   4 2                 6
744882 MA Essex   school 2511740 773   Triton 251174001651 7730025 Pine Grove   Regular School No 1 PK 06 2015   pre_kindergarten 33 0 0 0   0     0   1   20 14                       34 33 0 0 0   0     0   1   20 14                 34
941703 MA Essex   school 2511740 773   Triton 251174001651 7730025 Pine Grove   Regular School No 1 PK 06 2016   pre_kindergarten 37 0 0 0   0     0   3   22 18                       40 37 0 0 0   0     0   3   22 18                 40
1132801 MA Essex   school 2511740 773   Triton 251174001651 7730025 Pine Grove   Regular School No Elementary PK 06 2017   pre_kindergarten 20 0 0 0   0     0   1   12 9                       21 20 0 0 0   0     0   1   12 9                 21
1373928 MA Essex   school 2511740 773   Triton 251174001651 7730025 Pine Grove   Regular School No Elementary PK 06 2020   pre_kindergarten 26 0 0 0   2     0   0   13 15 *                     28.0 26 0 0 0   2     0   0   13 15                 28
1681176 MA Essex   school 2511740 773   Triton 251174001651 7730025 Triton - Pine Grove   Regular School No Elementary PK 06 2021   pre_kindergarten 31 0 0 0   1     0   1   19 14 *                     33.0 31 0 0 0   1     0   1   19 14                 33
2049001 MA Essex   school 2511740 773   Triton 251174001651 7730025 Pine Grove   Regular School No Elementary PK 06 2019   pre_kindergarten 27 0 0 0   1     0   0   14 14                       28.0 27 0 0 0   1     0   0   14 14                 28
2239616 MA Essex   school 2511740 773   Triton 251174001651 7730025 Triton: Pine Grove   Regular School No Elementary PK 06 2018   pre_kindergarten 35 0 0 0   1     0   0   17 19                       36.0 35 0 0 0   1     0   0   17 19                 36
744874 MA Essex   school 2511740 773   Triton 251174001348 7730020 Newbury Elementary   Regular School No 1 PK 06 2015   pre_kindergarten 32 0 1 0   1     0   1   20 15                       35 32 0 1 0   1     0   1   20 15                 35
941695 MA Essex   school 2511740 773   Triton 251174001348 7730020 Newbury Elementary   Regular School No 1 PK 06 2016   pre_kindergarten 43 0 4 0   0     0   1   24 24                       48 43 0 4 0   0     0   1   24 24                 48
1132792 MA Essex   school 2511740 773   Triton 251174001348 7730020 Newbury Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten 22 0 0 0   1     0   0   10 13                       23 22 0 0 0   1     0   0   10 13                 23
1373920 MA Essex   school 2511740 773   Triton 251174001348 7730020 Newbury Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten 39 2 0 0   1     0   1   21 22 *                     43.0 39 2 0 0   1     0   1   21 22                 43
1681168 MA Essex   school 2511740 773   Triton 251174001348 7730020 Triton - Newbury Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten 25 1 1 0   0     0   0   15 12 *                     27.0 25 1 1 0   0     0   0   15 12                 27
2048993 MA Essex   school 2511740 773   Triton 251174001348 7730020 Newbury Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten 38 1 1 0   1     0   2   19 24                       43.0 38 1 1 0   1     0   2   19 24                 43
2239607 MA Essex   school 2511740 773   Triton 251174001348 7730020 Triton: Newbury Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten 48 0 3 0   0     0   0   26 25                       51.0 48 0 3 0   0     0   0   26 25                 51
744866 MA Essex   school 2511740 773   Triton 251174001669 7730015 Salisbury Elementary   Regular School No 1 PK 06 2015   pre_kindergarten 58 0 1 0   1     0   3   28 35                       63 58 0 1 0   1     0   3   28 35                 63
941687 MA Essex   school 2511740 773   Triton 251174001669 7730015 Salisbury Elementary   Regular School No 1 PK 06 2016   pre_kindergarten 48 0 7 0   1     1   2   24 35                       59 48 0 7 0   1     1   2   24 35                 59
1132783 MA Essex   school 2511740 773   Triton 251174001669 7730015 Salisbury Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten 25 5 0 0   1     1   1   12 21                       33 25 5 0 0   1     1   1   12 21                 33
1373912 MA Essex   school 2511740 773   Triton 251174001669 7730015 Salisbury Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten 38 1 4 0   3     0   1   23 24 *                     47.0 38 1 4 0   3     0   1   23 24                 47
1681160 MA Essex   school 2511740 773   Triton 251174001669 7730015 Triton - Salisbury Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten 26 0 0 0   0     0   0   13 13 *                     26.0 26 0 0 0   0     0   0   13 13                 26
2048985 MA Essex   school 2511740 773   Triton 251174001669 7730015 Salisbury Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten 44 2 3 0   1     0   0   24 26                       50.0 44 2 3 0   1     0   0   24 26                 50
2239598 MA Essex   school 2511740 773   Triton 251174001669 7730015 Triton: Salisbury Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten 50 2 3 0   0     0   0   28 27                       55.0 50 2 3 0   0     0   0   28 27                 55
744840 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000202408 7670010 Lake Street   Regular School No 1 PK 01 2015   pre_kindergarten 89 0 6 0   0     0   3   48 50                       98 89 0 6 0   0     0   3   48 50                 98
941654 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No 1 PK 06 2016   pre_kindergarten 79 1 8 0   0     0   4   53 39                       92 79 1 8 0   0     0   4   53 39                 92
1132745 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten 40 1 3 0   0     0   2   24 22                       46 40 1 3 0   0     0   2   24 22                 46
1373880 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten 65 2 9 0   0     0   4   41 39 *                     80.0 65 2 9 0   0     0   4   41 39                 80
1681128 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 Spencer-E Brookfield - East Brookfield Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten 35 1 4 0   0     0   7   31 16 *                     47.0 35 1 4 0   0     0   7   31 16                 47
2048952 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten 65 3 14 0   0     0   3   46 39                       85.0 65 3 14 0   0     0   3   46 39                 85
2239560 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 Spencer-E Brookfield: East Brookfield Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten 55 2 5 0   0     0   3   38 27                       65.0 55 2 5 0   0     0   3   38 27                 65
744809 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland Elementary   Regular School No 1 PK 04 2015   pre_kindergarten 44 0 3 0   0     0   1   24 24                       48 44 0 3 0   0     0   1   24 24                 48
941634 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No 1 PK 02 2016   pre_kindergarten 44 0 6 0   0     0   1   25 26                       51 44 0 6 0   0     0   1   25 26                 51
1132721 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2017   pre_kindergarten 52 0 9 0   0     0   1   34 28                       62 52 0 9 0   0     0   1   34 28                 62
1373866 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2020   pre_kindergarten 48 0 1 1   1     0   0   27 24 *                     51.0 48 0 1 1   1     0   0   27 24                 51
1681114 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Southwick-Tolland-Granville Regional School District - Woodland School   Regular School No Elementary PK 02 2021   pre_kindergarten 24 0 0 1   1     0   2   15 13 *                     28.0 24 0 0 1   1     0   2   15 13                 28
2048937 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2019   pre_kindergarten 40 0 3 0   0     0   1   26 18                       44.0 40 0 3 0   0     0   1   26 18                 44
2239543 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Southwick-Tolland-Granville Regional School District: Woodland School   Regular School No Elementary PK 02 2018   pre_kindergarten 49 0 5 0   0     0   2   30 26                       56.0 49 0 5 0   0     0   2   30 26                 56
744795 MA Berkshire   school 2511040 765   Southern Berkshire 251104000428 7650035 Undermountain   Regular School No 1 PK 06 2015   pre_kindergarten 11 0 2 0   0     0   0   10 3                       13 11 0 2 0   0     0   0   10 3                 13
941620 MA Berkshire   school 2511040 765   Southern Berkshire 251104000428 7650035 Undermountain   Regular School No 1 PK 06 2016   pre_kindergarten 26 0 4 0   0     0   0   19 11                       30 26 0 4 0   0     0   0   19 11                 30
1132705 MA Berkshire   school 2511040 765   Southern Berkshire 251104000428 7650035 Undermountain   Regular School No Elementary PK 06 2017   pre_kindergarten 30 0 2 0   0     0   1   23 10                       33 30 0 2 0   0     0   1   23 10                 33
1373852 MA Berkshire   school 2511040 765   Southern Berkshire 251104000428 7650035 Undermountain   Regular School No Elementary PK 05 2020   pre_kindergarten 27 0 6 0   0     0   1   14 20 *                     34.0 27 0 6 0   0     0   1   14 20                 34
1681100 MA Berkshire   school 2511040 765   Southern Berkshire 251104000428 7650035 Southern Berkshire - Undermountain   Regular School No Elementary PK 05 2021   pre_kindergarten 22 0 8 0   0     0   1   12 19 *                     31.0 22 0 8 0   0     0   1   12 19                 31
2048923 MA Berkshire   school 2511040 765   Southern Berkshire 251104000428 7650035 Undermountain   Regular School No Elementary PK 06 2019   pre_kindergarten 25 0 1 0   0     0   2   11 17                       28.0 25 0 1 0   0     0   2   11 17                 28
2239527 MA Berkshire   school 2511040 765   Southern Berkshire 251104000428 7650035 Southern Berkshire: Undermountain   Regular School No Elementary PK 06 2018   pre_kindergarten 19 0 3 0   0     0   0   13 9                       22.0 19 0 3 0   0     0   0   13 9                 22
744787 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 New Marlborough Central   Regular School No 1 PK 04 2015   pre_kindergarten 9 0 0 0   0     0   0   5 4                       9 9 0 0 0   0     0   0   5 4                 9
941612 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 New Marlborough Central   Regular School No 1 PK 04 2016   pre_kindergarten 19 0 0 0   0     0   0   11 8                       19 19 0 0 0   0     0   0   11 8                 19
1132695 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 New Marlborough Central   Regular School No Elementary PK 04 2017   pre_kindergarten 9 0 0 1   0     0   1   4 7                       11 9 0 0 1   0     0   1   4 7                 11
1373846 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 New Marlborough Central   Regular School No Elementary PK 04 2020   pre_kindergarten 11 0 3 1   0     0   2   12 5 *                     17.0 11 0 3 1   0     0   2   12 5                 17
1681094 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 Southern Berkshire - New Marlborough Central   Regular School No Elementary PK 04 2021   pre_kindergarten 7 0 0 0   0     0   0   5 2 *                     7.0 7 0 0 0   0     0   0   5 2                 7
2048916 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 New Marlborough Central   Regular School No Elementary PK 04 2019   pre_kindergarten 9 0 1 0   0     0   1   5 6                       11.0 9 0 1 0   0     0   1   5 6                 11
2239520 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 Southern Berkshire: New Marlborough Central   Regular School No Elementary PK 04 2018   pre_kindergarten 14 0 0 0   0     0   0   10 4                       14.0 14 0 0 0   0     0   0   10 4                 14
744776 MA Plymouth   school 2510830 760   Silver Lake 251083001722 7600505 Silver Lake Regional High   Regular School No 3 09 12 2015   pre_kindergarten 74 1 0 0   0     0   0   38 37                       75 74 1 0 0   0     0   0   38 37                 75
941602 MA Plymouth   school 2510830 760   Silver Lake 251083001722 7600505 Silver Lake Regional High   Regular School No 3 09 12 2016   pre_kindergarten 77 1 0 0   0     0   0   49 29                       78 77 1 0 0   0     0   0   49 29                 78
1132683 MA Plymouth   school 2510830 760   Silver Lake 251083001722 7600505 Silver Lake Regional High   Regular School No High 09 12 2017   pre_kindergarten 84 0 0 0   0     0   0   52 32                       84 84 0 0 0   0     0   0   52 32                 84
1373834 MA Plymouth   school 2510830 760   Silver Lake 251083001722 7600505 Silver Lake Regional High   Regular School No High 09 12 2020   pre_kindergarten 109 0 0 0   0     0   0   57 52 *                     109.0 109 0 0 0   0     0   0   57 52                 109
1681082 MA Plymouth   school 2510830 760   Silver Lake 251083001722 7600505 Silver Lake - Silver Lake Regional High   Regular School No High 09 12 2021   pre_kindergarten 98 1 0 0   0     0   0   57 42 *                     99.0 98 1 0 0   0     0   0   57 42                 99
2048906 MA Plymouth   school 2510830 760   Silver Lake 251083001722 7600505 Silver Lake Regional High   Regular School No High 09 12 2019   pre_kindergarten 111 0 0 0   0     0   0   65 46                       111.0 111 0 0 0   0     0   0   65 46                 111
2239508 MA Plymouth   school 2510830 760   Silver Lake 251083001722 7600505 Silver Lake: Silver Lake Regional High   Regular School No High 09 12 2018   pre_kindergarten 98 0 0 0   0     0   0   61 37                       98.0 98 0 0 0   0     0   0   61 37                 98
1373812 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary PK 06 2020   pre_kindergarten 39 1 2 0   0     0   0   27 15 *                     42.0 39 1 2 0   0     0   0   27 15                 42
1681060 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Quabbin - Ruggles Lane   Regular School No Elementary PK 06 2021   pre_kindergarten 32 0 2 0   1     0   1   24 12 *                     36.0 32 0 2 0   1     0   1   24 12                 36

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