Data source: Big Local News · About: Big Local

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

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
2230203 MA Suffolk   school   35   Boston   350652               2018   pre_kindergarten * * * *   *     *   *   * *                       0.0                                             0
736169 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Lee Academy   Regular School No 1 PK 01 2015   pre_kindergarten 4 32 12 1   8     1   0   31 27                       58 4 32 12 1   8     1   0   31 27                 58
736172 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Baldwin Early Learning Center   Regular School No 1 PK 01 2015   pre_kindergarten 17 12 20 0   14     0   6   44 25                       69 17 12 20 0   14     0   6   44 25                 69
736184 MA Suffolk   school 2502790 35   Boston 250279002514 350006 ELC - West Zone   Regular School No 1 PK 01 2015   pre_kindergarten 7 5 11 0   2     0   1   16 10                       26 7 5 11 0   2     0   1   16 10                 26
736192 MA Suffolk   school 2502790 35   Boston 250279001118 350009 East Boston Early Childhood Center   Regular School No 1 PK 01 2015   pre_kindergarten 19 4 47 0   1     0   3   42 32                       74 19 4 47 0   1     0   3   42 32                 74
736195 MA Suffolk   school 2502790 35   Boston 250279001126 350010 Haynes Early Education Center   Regular School No 1 PK 01 2015   pre_kindergarten 1 22 19 0   1     0   0   28 15                       43 1 22 19 0   1     0   0   28 15                 43
737737 MA Norfolk   school 2504050 73   Dedham 250405000460 730005 Early Childhood Center   Regular School No 1 PK 01 2015   pre_kindergarten 77 6 14 1   4     0   7   62 47                       109 77 6 14 1   4     0   7   62 47                 109
737775 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No 1 PK 01 2015   pre_kindergarten 64 0 2 0   0     0   1   31 36                       67 64 0 2 0   0     0   1   31 36                 67
738374 MA Essex   school 2505220 105   Georgetown 250522000766 1050005 Perley Elementary   Regular School No 1 PK 01 2015   pre_kindergarten 83 0 2 0   4     0   1   44 46                       90 83 0 2 0   4     0   1   44 46                 90
738428 MA Worcester   school 2505370 110   Grafton 250537000788 1100005 South Grafton Elementary   Regular School No 1 PK 01 2015   pre_kindergarten 36 0 3 0   11     0   5   26 29                       55 36 0 3 0   11     0   5   26 29                 55
738431 MA Worcester   school 2505370 110   Grafton 250537000787 1100025 North Grafton Elementary   Regular School No 1 PK 01 2015   pre_kindergarten 44 0 3 0   4     0   1   32 20                       52 44 0 3 0   4     0   1   32 20                 52
739366 MA Hampden   school 2507050 161   Ludlow 250705002663 1610010 East Street Elementary School   Regular School No 1 PK 01 2015   pre_kindergarten 51 0 6 0   1     0   3   37 24                       61 51 0 6 0   1     0   3   37 24                 61
739758 MA Norfolk   school 2507530 175   Medfield 250753000114 1750003 Memorial School   Regular School No 1 PK 01 2015   pre_kindergarten 56 0 1 0   1     0   1   32 27                       59 56 0 1 0   1     0   1   32 27                 59
739819 MA Norfolk   school 2507590 177   Medway 250759001185 1770013 John D Mc Govern Elementary   Regular School No 1 PK 01 2015   pre_kindergarten 42 0 1 0   1     0   0   33 11                       44 42 0 1 0   1     0   0   33 11                 44
740604 MA Worcester   school 2508940 214   Northbridge 250894002682 2140005 Northbridge Elementary   Regular School No 1 PK 01 2015   pre_kindergarten 89 0 3 0   1     0   5   55 43                       98 89 0 3 0   1     0   5   55 43                 98
741696 MA Worcester   school 2510980 276   Southborough 251098001761 2760008 Mary E Finn School   Regular School No 1 PK 01 2015   pre_kindergarten 24 0 4 0   8     0   4   26 14                       40 24 0 4 0   8     0   4   26 14                 40
741725 MA Hampshire   school 2510920 278   South Hadley 251092001753 2780015 Plains Elementary   Regular School No 1 PK 01 2015   pre_kindergarten 52 0 6 0   1     0   6   36 29                       65 52 0 6 0   1     0   6   36 29                 65
741809 MA Hampden   school 2511130 281   Springfield 251113001817 2810060 Margaret C Ells   Regular School No 1 PK 01 2015   pre_kindergarten 27 34 62 0   2     0   6   73 58                       131 27 34 62 0   2     0   6   73 58                 131
742786 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No 1 PK 01 2015   pre_kindergarten 70 0 1 0   0     0   2   41 32                       73 70 0 1 0   0     0   2   41 32                 73
744239 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000590 6580010 Mason Road School   Regular School No 1 PK 01 2015   pre_kindergarten 40 2 1 0   0     0   1   24 20                       44 40 2 1 0   0     0   1   24 20                 44
744242 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000585 6580020 Charlton Elementary   Regular School No 1 PK 01 2015   pre_kindergarten 54 2 4 0   2     0   0   35 27                       62 54 2 4 0   2     0   0   35 27                 62
744350 MA Franklin   school 2505270 674   Gill-Montague 250527002816 6740015 Hillcrest Elementary School   Regular School No 1 PK 01 2015   pre_kindergarten 34 1 6 0   0     0   5   21 25                       46 34 1 6 0   0     0   5   21 25                 46
744397 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001598 6800025 Mile Tree Elementary   Regular School No 1 PK 01 2015   pre_kindergarten 32 1 4 0   2     0   3   23 19                       42 32 1 4 0   2     0   3   23 19                 42
744741 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No 1 PK 01 2015   pre_kindergarten 66 0 7 0   0     0   2   33 42                       75 66 0 7 0   0     0   2   33 42                 75
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
933038 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Lee Academy   Regular School No 1 PK 01 2016   pre_kindergarten 7 26 14 2   11     0   1   31 30                       61 7 26 14 2   11     0   1   31 30                 61
933041 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Baldwin Early Learning Center   Regular School No 1 PK 01 2016   pre_kindergarten 16 5 22 0   21     0   4   48 20                       68 16 5 22 0   21     0   4   48 20                 68
933053 MA Suffolk   school 2502790 35   Boston 250279002514 350006 ELC - West Zone   Regular School No 1 PK 01 2016   pre_kindergarten 4 6 10 0   1     0   3   17 7                       24 4 6 10 0   1     0   3   17 7                 24
933061 MA Suffolk   school 2502790 35   Boston 250279001118 350009 East Boston Early Childhood Center   Regular School No 1 PK 01 2016   pre_kindergarten 21 2 34 0   1     0   1   38 21                       59 21 2 34 0   1     0   1   38 21                 59
933064 MA Suffolk   school 2502790 35   Boston 250279001126 350010 Haynes Early Education Center   Regular School No 1 PK 01 2016   pre_kindergarten 1 28 18 0   1     0   2   27 23                       50 1 28 18 0   1     0   2   27 23                 50
933087 MA Suffolk   school 2502790 35   Boston 250279002839 350014 Pauline Agassiz Shaw Elementary School   Regular School No 1 PK 01 2016   pre_kindergarten 0 29 15 0   1     0   3   22 26                       48 0 29 15 0   1     0   3   22 26                 48
934632 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No 1 PK 01 2016   pre_kindergarten 46 1 1 0   0     0   0   26 22                       48 46 1 1 0   0     0   0   26 22                 48
935209 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No 1 PK 01 2016   pre_kindergarten 59 3 6 0   0     0   3   39 32                       71 59 3 6 0   0     0   3   39 32                 71
935280 MA Worcester   school 2505370 110   Grafton 250537000788 1100005 South Grafton Elementary   Regular School No 1 PK 01 2016   pre_kindergarten 38 0 5 0   13     0   1   30 27                       57 38 0 5 0   13     0   1   30 27                 57
935283 MA Worcester   school 2505370 110   Grafton 250537000787 1100025 North Grafton Elementary   Regular School No 1 PK 01 2016   pre_kindergarten 43 0 4 2   12     0   4   35 30                       65 43 0 4 2   12     0   4   35 30                 65
935553 MA Hampden   school 2506270 137   Holyoke 250627001178 1370003 Joseph Metcalf School   Regular School No 1 PK 01 2016   pre_kindergarten 44 7 92 0   2     1   0   88 58                       146 44 7 92 0   2     1   0   88 58                 146
936213 MA Hampden   school 2507050 161   Ludlow 250705002663 1610010 East Street Elementary School   Regular School No 1 PK 01 2016   pre_kindergarten 52 1 8 0   0     0   2   36 27                       63 52 1 8 0   0     0   2   36 27                 63
936602 MA Norfolk   school 2507530 175   Medfield 250753000114 1750003 Memorial School   Regular School No 1 PK 01 2016   pre_kindergarten 54 0 0 0   2     0   1   27 30                       57 54 0 0 0   2     0   1   27 30                 57
936664 MA Norfolk   school 2507590 177   Medway 250759001185 1770013 John D Mc Govern Elementary   Regular School No 1 PK 01 2016   pre_kindergarten 35 0 1 0   3     0   0   26 13                       39 35 0 1 0   3     0   0   26 13                 39
937434 MA Worcester   school 2508940 214   Northbridge 250894002682 2140005 Northbridge Elementary   Regular School No 1 PK 01 2016   pre_kindergarten 83 0 12 0   1     0   4   59 41                       100 83 0 12 0   1     0   4   59 41                 100
938499 MA Worcester   school 2510980 276   Southborough 251098001761 2760008 Mary E Finn School   Regular School No 1 PK 01 2016   pre_kindergarten 26 0 4 0   6     0   4   18 22                       40 26 0 4 0   6     0   4   18 22                 40
938529 MA Hampshire   school 2510920 278   South Hadley 251092001753 2780015 Plains Elementary   Regular School No 1 PK 01 2016   pre_kindergarten 51 1 8 0   1     0   0   35 26                       61 51 1 8 0   1     0   0   35 26                 61
938615 MA Hampden   school 2511130 281   Springfield 251113001817 2810060 Margaret C Ells   Regular School No 1 PK 01 2016   pre_kindergarten 28 35 55 0   0     0   6   68 56                       124 28 35 55 0   0     0   6   68 56                 124
941066 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000590 6580010 Mason Road School   Regular School No 1 PK 01 2016   pre_kindergarten 29 1 2 0   0     0   1   18 15                       33 29 1 2 0   0     0   1   18 15                 33
941069 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000585 6580020 Charlton Elementary   Regular School No 1 PK 01 2016   pre_kindergarten 65 3 4 0   0     0   2   50 24                       74 65 3 4 0   0     0   2   50 24                 74
941176 MA Franklin   school 2505270 674   Gill-Montague 250527002816 6740015 Hillcrest Elementary School   Regular School No 1 PK 01 2016   pre_kindergarten 21 0 9 0   0     1   3   16 18                       34 21 0 9 0   0     1   3   16 18                 34
941223 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001598 6800025 Mile Tree Elementary   Regular School No 1 PK 01 2016   pre_kindergarten 33 1 3 0   2     0   3   22 20                       42 33 1 3 0   2     0   3   22 20                 42
941566 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No 1 PK 01 2016   pre_kindergarten 72 0 5 0   0     0   0   45 32                       77 72 0 5 0   0     0   0   45 32                 77
1122558 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Baldwin Early Learning Center   Regular School No Elementary PK 01 2017   pre_kindergarten 19 9 22 0   27     0   5   47 35                       82 19 9 22 0   27     0   5   47 35                 82
1122572 MA Suffolk   school 2502790 35   Boston 250279002514 350006 ELC - West Zone   Regular School No Elementary PK 01 2017   pre_kindergarten 6 9 21 0   8     0   2   29 17                       46 6 9 21 0   8     0   2   29 17                 46
1122582 MA Suffolk   school 2502790 35   Boston 250279001118 350009 East Boston Early Childhood Center   Regular School No Elementary PK 01 2017   pre_kindergarten 20 1 28 0   1     0   1   30 21                       51 20 1 28 0   1     0   1   30 21                 51
1122586 MA Suffolk   school 2502790 35   Boston 250279001126 350010 Haynes Early Education Center   Regular School No Elementary PK 01 2017   pre_kindergarten 3 24 20 0   0     0   0   21 26                       47 3 24 20 0   0     0   0   21 26                 47
1124076 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Shurtleff Early Childhood   Regular School No Elementary PK 01 2017   pre_kindergarten 16 18 228 0   2     0   5   140 129                       269 16 18 228 0   2     0   5   140 129                 269
1124411 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No Elementary PK 01 2017   pre_kindergarten 46 0 2 0   1     0   3   29 23                       52 46 0 2 0   1     0   3   29 23                 52
1125103 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No Elementary PK 01 2017   pre_kindergarten 61 3 12 0   0     0   4   45 35                       80 61 3 12 0   0     0   4   45 35                 80
1125201 MA Worcester   school 2505370 110   Grafton 250537000788 1100005 South Grafton Elementary   Regular School No Elementary PK 01 2017   pre_kindergarten 44 1 1 0   14     0   2   38 24                       62 44 1 1 0   14     0   2   38 24                 62
1125205 MA Worcester   school 2505370 110   Grafton 250537000787 1100025 North Grafton Elementary   Regular School No Elementary PK 01 2017   pre_kindergarten 39 0 2 0   18     0   4   37 26                       63 39 0 2 0   18     0   4   37 26                 63
1126311 MA Hampden   school 2507050 161   Ludlow 250705002663 1610010 East Street Elementary School   Regular School No Elementary PK 01 2017   pre_kindergarten 63 0 8 1   0     0   2   39 35                       74 63 0 8 1   0     0   2   39 35                 74
1126777 MA Norfolk   school 2507530 175   Medfield 250753000114 1750003 Memorial School   Regular School No Elementary PK 01 2017   pre_kindergarten 53 1 1 1   3     0   1   30 30                       60 53 1 1 1   3     0   1   30 30                 60
1126851 MA Norfolk   school 2507590 177   Medway 250759001185 1770013 John D Mc Govern Elementary   Regular School No Elementary PK 01 2017   pre_kindergarten 31 0 1 0   3     0   1   21 15                       36 31 0 1 0   3     0   1   21 15                 36
1127763 MA Worcester   school 2508940 214   Northbridge 250894002682 2140005 Northbridge Elementary   Regular School No Elementary PK 01 2017   pre_kindergarten 64 0 9 0   1     0   3   50 27                       77 64 0 9 0   1     0   3   50 27                 77
1127946 MA Worcester   school 2509270 226   Oxford 250927001479 2260010 Alfred M Chaffee   Regular School No Elementary PK 01 2017   pre_kindergarten 55 0 6 1   1     0   0   35 28                       63 55 0 6 1   1     0   0   35 28                 63
1129032 MA Worcester   school 2510980 276   Southborough 251098001761 2760008 Mary E Finn School   Regular School No Elementary PK 01 2017   pre_kindergarten 38 1 1 0   3     0   0   21 22                       43 38 1 1 0   3     0   0   21 22                 43
1129070 MA Hampshire   school 2510920 278   South Hadley 251092001753 2780015 Plains Elementary   Regular School No Elementary PK 01 2017   pre_kindergarten 48 2 11 1   3     0   1   34 32                       66 48 2 11 1   3     0   1   34 32                 66
1129169 MA Hampden   school 2511130 281   Springfield 251113001817 2810060 Margaret C Ells   Regular School No Elementary PK 01 2017   pre_kindergarten 25 37 62 1   1     0   3   70 59                       129 25 37 62 1   1     0   3   70 59                 129
1132051 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000590 6580010 Mason Road School   Regular School No Elementary PK 01 2017   pre_kindergarten 30 2 11 1   0     0   0   17 27                       44 30 2 11 1   0     0   0   17 27                 44
1132055 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000585 6580020 Charlton Elementary   Regular School No Elementary PK 01 2017   pre_kindergarten 49 0 10 0   1     0   6   38 28                       66 49 0 10 0   1     0   6   38 28                 66
1132183 MA Franklin   school 2505270 674   Gill-Montague 250527002816 6740015 Hillcrest Elementary School   Regular School No Elementary PK 01 2017   pre_kindergarten 29 0 9 0   0     0   0   20 18                       38 29 0 9 0   0     0   0   20 18                 38
1132239 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001598 6800025 Mile Tree Elementary   Regular School No Elementary PK 01 2017   pre_kindergarten 34 1 4 0   1     0   0   19 21                       40 34 1 4 0   1     0   0   19 21                 40
1132638 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No Elementary PK 01 2017   pre_kindergarten 58 0 6 0   0     0   1   38 27                       65 58 0 6 0   0     0   1   38 27                 65
1365272 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Baldwin Early Learning Center   Regular School No Elementary PK 01 2020   pre_kindergarten 31 4 17 0   25     0   3   46 34 *                     80.0 31 4 17 0   25     0   3   46 34                 80
1365284 MA Suffolk   school 2502790 35   Boston 250279002514 350006 ELC - West Zone   Regular School No Elementary PK 01 2020   pre_kindergarten 8 11 22 0   4     0   1   20 26 *                     46.0 8 11 22 0   4     0   1   20 26                 46
1365292 MA Suffolk   school 2502790 35   Boston 250279001118 350009 East Boston Early Childhood Center   Regular School No Elementary PK 01 2020   pre_kindergarten 26 7 49 1   2     0   3   45 43 *                     88.0 26 7 49 1   2     0   3   45 43                 88
1365295 MA Suffolk   school 2502790 35   Boston 250279001126 350010 Haynes Early Education Center   Regular School No Elementary PK 01 2020   pre_kindergarten 2 27 24 1   2     0   2   35 23 *                     58.0 2 27 24 1   2     0   2   35 23                 58
1365688 MA Suffolk   school 2502790 35   Boston 250279000303 350266 Dr. William Henderson Lower   Regular School No Elementary PK 01 2020   pre_kindergarten 27 20 12 0   7     0   9   33 42 *                     75.0 27 20 12 0   7     0   9   33 42                 75
1366570 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Shurtleff Early Childhood   Regular School No Elementary PK 01 2020   pre_kindergarten 27 18 239 0   0     0   6   151 139 *                     290.0 27 18 239 0   0     0   6   151 139                 290
1366857 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No Elementary PK 01 2020   pre_kindergarten 54 1 3 0   1     0   0   24 35 *                     59.0 54 1 3 0   1     0   0   24 35                 59
1367447 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No Elementary PK 01 2020   pre_kindergarten 46 4 17 0   4     0   4   40 35 *                     75.0 46 4 17 0   4     0   4   40 35                 75
1367515 MA Worcester   school 2505370 110   Grafton 250537000788 1100005 South Grafton Elementary   Regular School No Elementary PK 01 2020   pre_kindergarten 47 3 6 0   14     0   0   40 30 *                     70.0 47 3 6 0   14     0   0   40 30                 70
1367518 MA Worcester   school 2505370 110   Grafton 250537000787 1100025 North Grafton Elementary   Regular School No Elementary PK 01 2020   pre_kindergarten 32 0 2 0   12     0   1   27 20 *                     47.0 32 0 2 0   12     0   1   27 20                 47
1367603 MA Plymouth   school 2505790 122   Hanover 250579000827 1220004 Cedar Elementary   Regular School No Elementary PK 01 2020   pre_kindergarten 75 1 1 0   3     0   0   42 38 *                     80.0 75 1 1 0   3     0   0   42 38                 80
1368428 MA Hampden   school 2507050 161   Ludlow 250705002663 1610010 East Street Elementary School   Regular School No Elementary PK 01 2020   pre_kindergarten 70 0 10 0   2     0   6   49 39 *                     88.0 70 0 10 0   2     0   6   49 39                 88
1368828 MA Norfolk   school 2507530 175   Medfield 250753000114 1750003 Memorial School   Regular School No Elementary PK 01 2020   pre_kindergarten 47 1 2 0   0     0   0   29 21 *                     50.0 47 1 2 0   0     0   0   29 21                 50
1368885 MA Norfolk   school 2507590 177   Medway 250759001185 1770013 John D Mc Govern Elementary   Regular School No Elementary PK 01 2020   pre_kindergarten 32 1 5 0   0     0   2   27 13 *                     40.0 32 1 5 0   0     0   2   27 13                 40
1369658 MA Worcester   school 2508940 214   Northbridge 250894002682 2140005 Northbridge Elementary   Regular School No Elementary PK 01 2020   pre_kindergarten 67 0 3 0   0     0   7   44 33 *                     77.0 67 0 3 0   0     0   7   44 33                 77
1369813 MA Worcester   school 2509270 226   Oxford 250927001479 2260010 Alfred M Chaffee   Regular School No Elementary PK 01 2020   pre_kindergarten 34 1 7 0   1     0   3   26 20 *                     46.0 34 1 7 0   1     0   3   26 20                 46
1370726 MA Worcester   school 2510980 276   Southborough 251098001761 2760008 Mary E Finn School   Regular School No Elementary PK 01 2020   pre_kindergarten 43 3 2 1   33     0   0   49 33 *                     82.0 43 3 2 1   33     0   0   49 33                 82
1370740 MA Worcester   school 2511010 277   Southbridge 251101001764 2770010 Eastford Road   Regular School No Elementary PK 01 2020   pre_kindergarten 22 0 43 0   1     0   2   45 23 *                     68.0 22 0 43 0   1     0   2   45 23                 68
1370757 MA Hampshire   school 2510920 278   South Hadley 251092001753 2780015 Plains Elementary   Regular School No Elementary PK 01 2020   pre_kindergarten 57 1 11 0   2     0   2   41 32 *                     73.0 57 1 11 0   2     0   2   41 32                 73
1373296 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000590 6580010 Mason Road School   Regular School No Elementary PK 01 2020   pre_kindergarten 44 0 8 1   0     0   4   36 21 *                     57.0 44 0 8 1   0     0   4   36 21                 57
1373299 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000585 6580020 Charlton Elementary   Regular School No Elementary PK 01 2020   pre_kindergarten 59 0 4 0   1     0   1   36 29 *                     65.0 59 0 4 0   1     0   1   36 29                 65
1373407 MA Franklin   school 2505270 674   Gill-Montague 250527002816 6740015 Hillcrest Elementary School   Regular School No Elementary PK 01 2020   pre_kindergarten 27 0 9 0   0     0   2   24 14 *                     38.0 27 0 9 0   0     0   2   24 14                 38
1373458 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001598 6800025 Mile Tree Elementary   Regular School No Elementary PK 01 2020   pre_kindergarten 51 1 5 0   2     0   3   37 25 *                     62.0 51 1 5 0   2     0   3   37 25                 62
1672494 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Boston - Baldwin Early Learning Center   Regular School No Elementary PK 01 2021   pre_kindergarten 20 4 21 1   20     0   10   37 39 *                     76.0 20 4 21 1   20     0   10   37 39                 76
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
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
1672922 MA Suffolk   school 2502790 35   Boston 250279000303 350266 Boston - Dr. William Henderson Lower   Regular School No Elementary PK 01 2021   pre_kindergarten 18 22 14 0   8     2   4   38 30 *                     68.0 18 22 14 0   8     2   4   38 30                 68
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
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

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