enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • pre_kindergarten · 3,569 ✖
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
1370813 1370813 MA Hampden   school 2511130 281   Springfield 251113001801 2810030 Elias Brookings   Regular School No Elementary PK 05 2020   pre_kindergarten 0 9 35 0   1     0   1   26 20 *                     46.0 0 9 35 0   1     0   1   26 20                 46
1372568 1372568 MA Essex   school 2500535 431   Community Day Charter Public School - R. Kingman Webster (District) 250053502719 4310205 Community Day Charter Public School - R. Kingman Webster   Regular School Yes Elementary PK 08 2020   pre_kindergarten 0 0 41 0   0     0   0   29 12 *                     41.0 0 0 41 0   0     0   0   29 12                 41
1372600 1372600 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2020   pre_kindergarten 0 19 2 0   0     0   0   14 7 *                     21.0 0 19 2 0   0     0   0   14 7                 21
1372624 1372624 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2020   pre_kindergarten 0 0 21 0   0     0   0   8 13 *                     21.0 0 0 21 0   0     0   0   8 13                 21
1372725 1372725 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2020   pre_kindergarten 0 0 81 0   1     0   0   34 48 *                     82.0 0 0 81 0   1     0   0   34 48                 82
1372786 1372786 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2020   pre_kindergarten 0 24 26 0   0     0   1   21 30 *                     51.0 0 24 26 0   0     0   1   21 30                 51
1372834 1372834 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2020   pre_kindergarten 0 78 34 1   0     0   3   52 64 *                     116.0 0 78 34 1   0     0   3   52 64                 116
1374211 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
1672540 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
1672545 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
1672580 1672580 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Boston - Charles H Taylor   Regular School No Elementary PK 05 2021   pre_kindergarten 0 14 4 0   0     0   0   11 7 *                     18.0 0 14 4 0   0     0   0   11 7                 18
1672743 1672743 MA Suffolk   school 2502790 35   Boston 250279000268 350167 Boston - UP Academy Holland   Regular School No Elementary PK 05 2021   pre_kindergarten 0 18 35 0   2     0   1   24 32 *                     56.0 0 18 35 0   2     0   1   24 32                 56
1672760 1672760 MA Suffolk   school 2502790 35   Boston 250279000270 350180 Boston - John Winthrop   Regular School No Elementary PK 05 2021   pre_kindergarten 0 14 11 0   1     0   1   13 14 *                     27.0 0 14 11 0   1     0   1   13 14                 27
1672829 1672829 MA Suffolk   school 2502790 35   Boston 250279000289 350227 Boston - Mather   Regular School No Elementary PK 05 2021   pre_kindergarten 0 9 4 0   15     0   1   11 18 *                     29.0 0 9 4 0   15     0   1   11 18                 29
1672871 1672871 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Boston - Nathan Hale   Regular School No Elementary PK 06 2021   pre_kindergarten 0 10 6 0   0     0   3   12 7 *                     19.0 0 10 6 0   0     0   3   12 7                 19
1673086 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
1675221 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
1675713 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
1675752 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
1679788 1679788 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway (District) - Community Day Charter Public School - Gateway   Regular School Yes Elementary PK 08 2021   pre_kindergarten 0 1 32 1   0     0   0   21 13 *                     34.0 0 1 32 1   0     0   0   21 13                 34
1679863 1679863 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public (District) - Codman Academy Charter Public School   Regular School Yes Other PK 12 2021   pre_kindergarten 0 15 5 0   0     0   0   13 7 *                     20.0 0 15 5 0   0     0   0   13 7                 20
1679989 1679989 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter (District) - Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2021   pre_kindergarten 0 0 63 0   0     0   0   24 39 *                     63.0 0 0 63 0   0     0   0   24 39                 63
1680051 1680051 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School (District) - MATCH Charter Public School   Regular School Yes Other PK 12 2021   pre_kindergarten 0 26 26 0   0     0   1   23 30 *                     53.0 0 26 26 0   0     0   1   23 30                 53
2040400 2040400 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Charles H Taylor   Regular School No Elementary PK 05 2019   pre_kindergarten 0 13 3 0   0     0   1   10 7                       17.0 0 13 3 0   0     0   1   10 7                 17
2040421 2040421 MA Suffolk   school 2502790 35   Boston 250279000220 350072 David A Ellis   Regular School No Elementary PK 05 2019   pre_kindergarten 0 19 27 0   0     0   1   22 25                       47.0 0 19 27 0   0     0   1   22 25                 47
2040503 2040503 MA Suffolk   school 2502790 35   Boston 250279002569 350138 O W Holmes   Regular School No Elementary PK 05 2019   pre_kindergarten 0 14 8 0   1     0   2   15 10                       25.0 0 14 8 0   1     0   2   15 10                 25
2040574 2040574 MA Suffolk   school 2502790 35   Boston 250279000270 350180 John Winthrop   Regular School No Elementary PK 05 2019   pre_kindergarten 0 21 12 1   0     0   1   16 19                       35.0 0 21 12 1   0     0   1   16 19                 35
2040865 2040865 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2019   pre_kindergarten 0 32 23 0   0     0   1   35 21                       56.0 0 32 23 0   0     0   1   35 21                 56
2043059 2043059 MA Essex   school 2506660 149   Lawrence 250666002815 1490011 Lawrence Family Public Academy   Regular School No Elementary PK KG 2019   pre_kindergarten 0 0 54 0   0     0   0   26 27                       54.0 0 0 54 0   0     0   0   26 27                 54
2043076 2043076 MA Essex   school 2506660 149   Lawrence 250666000958 1490020 James F Hennessey   Regular School No Elementary PK 02 2019   pre_kindergarten 0 0 87 0   0     0   0   58 29                       87.0 0 0 87 0   0     0   0   58 29                 87
2047584 2047584 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2019   pre_kindergarten 0 21 3 0   0     0   0   11 13                       24.0 0 21 3 0   0     0   0   11 13                 24
2047695 2047695 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2019   pre_kindergarten 0 0 20 0   0     0   0   7 13                       20.0 0 0 20 0   0     0   0   7 13                 20
2229427 2229427 MA Suffolk   school 2502790 35   Boston 250279002806 350015 Boston: Higginson   Regular School No Elementary PK 02 2018   pre_kindergarten 0 11 20 0   0     0   0   14 17                       31.0 0 11 20 0   0     0   0   14 17                 31
2229467 2229467 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Boston: Charles H Taylor   Regular School No Elementary PK 05 2018   pre_kindergarten 0 16 4 0   0     0   1   12 9                       21.0 0 16 4 0   0     0   1   12 9                 21
2229583 2229583 MA Suffolk   school 2502790 35   Boston 250279002569 350138 Boston: O W Holmes   Regular School No Elementary PK 05 2018   pre_kindergarten 0 13 8 0   2     0   2   11 14                       25.0 0 13 8 0   2     0   2   11 14                 25
2229664 2229664 MA Suffolk   school 2502790 35   Boston 250279000270 350180 Boston: John Winthrop   Regular School No Elementary PK 05 2018   pre_kindergarten 0 15 14 0   1     0   0   12 18                       30.0 0 15 14 0   1     0   0   12 18                 30
2229988 2229988 MA Suffolk   school 2502790 35   Boston 250279002669 350376 Boston: King K-8   Regular School No Elementary PK 08 2018   pre_kindergarten 0 39 18 0   0     0   2   32 27                       59.0 0 39 18 0   0     0   2   32 27                 59
2230018 2230018 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Boston: Young Achievers   Alternative School No Elementary PK 08 2018   pre_kindergarten 0 23 16 1   0     0   4   21 23                       44.0 0 23 16 1   0     0   4   21 23                 44
2237919 2237919 MA Suffolk   school 2500543 407   Dudley Street Neighborhood Charter School (District) 250054302763 4070405 Dudley Street Neighborhood Charter School (District): Dudley Street Neighborhood Charter School   Regular School Yes Elementary PK 05 2018   pre_kindergarten 0 26 13 0   0     0   0   25 14                       39.0 0 26 13 0   0     0   0   25 14                 39
2238002 2238002 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public (District): Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2018   pre_kindergarten 0 19 2 0   0     0   1   9 13                       22.0 0 19 2 0   0     0   1   9 13                 22
2238096 2238096 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public (District): Codman Academy Charter Public School   Regular School Yes Other PK 12 2018   pre_kindergarten 0 10 10 0   0     0   0   12 8                       20.0 0 10 10 0   0     0   0   12 8                 20
2238122 2238122 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect (District): Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2018   pre_kindergarten 0 0 44 0   0     0   0   21 23                       44.0 0 0 44 0   0     0   0   21 23                 44
2238300 2238300 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School (District): MATCH Charter Public School   Regular School Yes Other PK 12 2018   pre_kindergarten 0 32 20 0   1     0   0   26 27                       53.0 0 32 20 0   1     0   0   26 27                 53
736195 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
736218 736218 MA Suffolk   school 2502790 35   Boston 250279002839 350014 Pauline Agassiz Shaw Elementary School   Regular School No 1 PK KG 2015   pre_kindergarten 1 37 11 0   2     0   1   31 21                       52 1 37 11 0   2     0   1   31 21                 52
736220 736220 MA Suffolk   school 2502790 35   Boston 250279002806 350015 Higginson   Regular School No 1 PK 02 2015   pre_kindergarten 1 12 14 0   1     1   0   15 14                       29 1 12 14 0   1     1   0   15 14                 29
736271 736271 MA Suffolk   school 2502790 35   Boston 250279000220 350072 David A Ellis   Regular School No 1 PK 05 2015   pre_kindergarten 1 11 36 0   0     0   0   16 32                       48 1 11 36 0   0     0   0   16 32                 48
736354 736354 MA Suffolk   school 2502790 35   Boston 250279002569 350138 O W Holmes   Regular School No 1 PK 05 2015   pre_kindergarten 1 18 10 0   4     0   2   16 19                       35 1 18 10 0   4     0   2   16 19                 35
736361 736361 MA Suffolk   school 2502790 35   Boston 250279000249 350141 Hugh Roe O'Donnell   Regular School No 1 PK 05 2015   pre_kindergarten 1 0 19 0   0     0   0   10 10                       20 1 0 19 0   0     0   0   10 10                 20
736549 736549 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No 1 PK 08 2015   pre_kindergarten 1 32 14 0   2     0   2   30 21                       51 1 32 14 0   2     0   2   30 21                 51
736588 736588 MA Suffolk   school 2502790 35   Boston 250279000304 350268 Paul A Dever   Regular School No 1 PK 05 2015   pre_kindergarten 1 11 23 0   5     0   0   21 19                       40 1 11 23 0   5     0   0   21 19                 40
736686 736686 MA Suffolk   school 2502790 35   Boston 250279000337 350366 William E Russell   Regular School No 1 PK 05 2015   pre_kindergarten 1 25 23 0   10     1   1   35 26                       61 1 25 23 0   10     1   1   35 26                 61
739436 739436 MA Essex   school 2507110 163   Lynn 250711001087 1630040 Wm P Connery   Regular School No 1 PK 05 2015   pre_kindergarten 1 1 16 0   9     0   0   16 11                       27 1 1 16 0   9     0   0   16 11                 27
741617 741617 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No 1 PK 08 2015   pre_kindergarten 1 3 10 0   2     0   1   6 11                       17 1 3 10 0   2     0   1   6 11                 17
741777 741777 MA Hampden   school 2511130 281   Springfield 251113001801 2810030 Elias Brookings   Regular School No 1 PK 05 2015   pre_kindergarten 1 10 26 0   0     0   1   21 17                       38 1 10 26 0   0     0   1   21 17                 38
743459 743459 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes 1 PK 03 2015   pre_kindergarten 1 20 17 0   1     0   0   19 20                       39 1 20 17 0   1     0   0   19 20                 39
743792 743792 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes 1 PK 06 2015   pre_kindergarten 1 68 44 0   0     0   6   59 60                       119 1 68 44 0   0     0   6   59 60                 119
933064 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
933221 933221 MA Suffolk   school 2502790 35   Boston 250279002569 350138 O W Holmes   Regular School No 1 PK 05 2016   pre_kindergarten 1 17 6 2   3     1   2   20 12                       32 1 17 6 2   3     1   2   20 12                 32
933228 933228 MA Suffolk   school 2502790 35   Boston 250279000249 350141 Hugh Roe O'Donnell   Regular School No 1 PK 05 2016   pre_kindergarten 1 0 21 0   0     0   0   11 11                       22 1 0 21 0   0     0   0   11 11                 22
933368 933368 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No 1 PK 08 2016   pre_kindergarten 1 3 5 0   0     1   0   5 5                       10 1 3 5 0   0     1   0   5 5                 10
933418 933418 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No 1 PK 08 2016   pre_kindergarten 1 28 21 0   3     0   2   34 21                       55 1 28 21 0   3     0   2   34 21                 55
933444 933444 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Patrick J Kennedy   Regular School No 1 PK 05 2016   pre_kindergarten 1 2 22 0   1     0   0   11 15                       26 1 2 22 0   1     0   0   11 15                 26
933508 933508 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No 1 PK 08 2016   pre_kindergarten 1 0 11 0   0     0   1   6 7                       13 1 0 11 0   0     0   1   6 7                 13
933535 933535 MA Suffolk   school 2502790 35   Boston 250279000338 350360 William Ellery Channing   Regular School No 1 PK 05 2016   pre_kindergarten 1 14 11 0   1     0   1   15 13                       28 1 14 11 0   1     0   1   15 13                 28
933586 933586 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No 1 PK 08 2016   pre_kindergarten 1 34 25 0   0     0   1   32 29                       61 1 34 25 0   0     0   1   32 29                 61
933613 933613 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2016   pre_kindergarten 1 15 18 0   0     0   0   13 21                       34 1 15 18 0   0     0   0   13 21                 34
935752 935752 MA Essex   school 2506660 149   Lawrence 250666002815 1490011 Lawrence Family Public Academy   Regular School No 1 PK KG 2016   pre_kindergarten 1 2 48 0   0     0   0   24 27                       51 1 2 48 0   0     0   0   24 27                 51
940223 940223 MA Suffolk   school 2500543 407   Dudley Street Neighborhood Charter School (District) 250054302763 4070405 Dudley Street Neighborhood Charter School   Regular School Yes 1 PK 04 2016   pre_kindergarten 1 19 18 1   0     0   0   14 25                       39 1 19 18 1   0     0   0   14 25                 39
940299 940299 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway   Regular School Yes 1 PK 04 2016   pre_kindergarten 1 0 41 0   0     0   0   13 29                       42 1 0 41 0   0     0   0   13 29                 42
940334 940334 MA Essex   school 2500535 431   Community Day Charter Public School - R. Kingman Webster (District) 250053502719 4310205 Community Day Charter Public School - R. Kingman Webster   Regular School Yes 1 PK 04 2016   pre_kindergarten 1 1 40 0   0     0   0   23 19                       42 1 1 40 0   0     0   0   23 19                 42
940621 940621 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes 1 PK 06 2016   pre_kindergarten 1 89 53 0   0     0   4   64 83                       147 1 89 53 0   0     0   4   64 83                 147
1122617 1122617 MA Suffolk   school 2502790 35   Boston 250279002806 350015 Higginson   Regular School No Elementary PK 02 2017   pre_kindergarten 1 8 18 0   0     0   1   18 10                       28 1 8 18 0   0     0   1   18 10                 28
1122678 1122678 MA Suffolk   school 2502790 35   Boston 250279000220 350072 David A Ellis   Regular School No Elementary PK 05 2017   pre_kindergarten 1 14 28 0   0     0   0   19 24                       43 1 14 28 0   0     0   0   19 24                 43
1122705 1122705 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2017   pre_kindergarten 1 0 18 0   0     0   0   9 10                       19 1 0 18 0   0     0   0   9 10                 19
1122762 1122762 MA Suffolk   school 2502790 35   Boston 250279000247 350135 Henry Grew   Regular School No Elementary PK 05 2017   pre_kindergarten 1 7 11 0   0     0   1   13 7                       20 1 7 11 0   0     0   1   13 7                 20
1122770 1122770 MA Suffolk   school 2502790 35   Boston 250279002569 350138 O W Holmes   Regular School No Elementary PK 05 2017   pre_kindergarten 1 15 5 0   2     0   1   9 15                       24 1 15 5 0   2     0   1   9 15                 24
1122838 1122838 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No Elementary PK 05 2017   pre_kindergarten 1 5 6 0   1     0   0   7 6                       13 1 5 6 0   1     0   0   7 6                 13
1122976 1122976 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No Elementary PK 05 2017   pre_kindergarten 1 14 5 0   0     0   0   10 10                       20 1 14 5 0   0     0   0   10 10                 20
1122995 1122995 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2017   pre_kindergarten 1 23 21 0   0     0   1   36 10                       46 1 23 21 0   0     0   1   36 10                 46
1123037 1123037 MA Suffolk   school 2502790 35   Boston 250279000304 350268 Paul A Dever   Regular School No Elementary PK 05 2017   pre_kindergarten 1 8 22 0   2     0   2   21 14                       35 1 8 22 0   2     0   2   21 14                 35
1123077 1123077 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Samuel W Mason   Regular School No Elementary PK 05 2017   pre_kindergarten 1 11 11 0   1     0   2   12 14                       26 1 11 11 0   1     0   2   12 14                 26
1123184 1123184 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2017   pre_kindergarten 1 35 17 0   0     0   3   34 22                       56 1 35 17 0   0     0   3   34 22                 56
1123443 1123443 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   pre_kindergarten 1 3 1 0   1     0   0   3 3                       6 1 3 1 0   1     0   0   3 3                 6
1125556 1125556 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No Elementary PK 08 2017   pre_kindergarten 1 1 36 0   0     0   0   21 17                       38 1 1 36 0   0     0   0   21 17                 38
1126396 1126396 MA Essex   school 2507110 163   Lynn 250711001087 1630040 Wm P Connery   Regular School No Elementary PK 05 2017   pre_kindergarten 1 1 22 0   3     0   2   13 16                       29 1 1 22 0   3     0   2   13 16                 29
1130768 1130768 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No Elementary PK 06 2017   pre_kindergarten 1 4 17 0   4     0   0   14 12                       26 1 4 17 0   4     0   0   14 12                 26
1131158 1131158 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 05 2017   pre_kindergarten 1 23 12 2   1     0   0   17 22                       39 1 23 12 2   1     0   0   17 22                 39
1131174 1131174 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2017   pre_kindergarten 1 18 1 0   1     0   2   13 10                       23 1 18 1 0   1     0   2   13 10                 23
1131291 1131291 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2017   pre_kindergarten 1 0 42 0   0     0   0   21 22                       43 1 0 42 0   0     0   0   21 22                 43
1131420 1131420 MA Middlesex   school 2500065 456   Lowell Community Charter Public (District) 250006501585 4560050 Lowell Community Charter Public School   Regular School Yes Elementary PK 08 2017   pre_kindergarten 1 12 15 0   10     0   2   20 20                       40 1 12 15 0   10     0   2   20 20                 40
1365379 1365379 MA Suffolk   school 2502790 35   Boston 250279000220 350072 David A Ellis   Regular School No Elementary PK 05 2020   pre_kindergarten 1 19 30 0   0     0   0   25 25 *                     50.0 1 19 30 0   0     0   0   25 25                 50
1365461 1365461 MA Suffolk   school 2502790 35   Boston 250279002569 350138 O W Holmes   Regular School No Elementary PK 05 2020   pre_kindergarten 1 19 5 0   2     0   0   18 9 *                     27.0 1 19 5 0   2     0   0   18 9                 27
1365532 1365532 MA Suffolk   school 2502790 35   Boston 250279000270 350180 John Winthrop   Regular School No Elementary PK 05 2020   pre_kindergarten 1 20 18 0   0     0   0   21 18 *                     39.0 1 20 18 0   0     0   0   21 18                 39
1365604 1365604 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2020   pre_kindergarten 1 1 10 0   2     0   0   10 4 *                     14.0 1 1 10 0   2     0   0   10 4                 14
1365614 1365614 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No Elementary PK 05 2020   pre_kindergarten 1 3 2 0   0     0   1   4 3 *                     7.0 1 3 2 0   0     0   1   4 3                 7
1365681 1365681 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Patrick J Kennedy   Regular School No Elementary PK 05 2020   pre_kindergarten 1 2 24 0   0     0   1   13 15 *                     28.0 1 2 24 0   0     0   1   13 15                 28
1365796 1365796 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2020   pre_kindergarten 1 28 10 1   0     0   1   26 15 *                     41.0 1 28 10 1   0     0   1   26 15                 41
1365823 1365823 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2020   pre_kindergarten 1 38 25 0   1     0   1   32 34 *                     66.0 1 38 25 0   1     0   1   32 34                 66
1365839 1365839 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2020   pre_kindergarten 1 30 6 0   1     0   3   18 23 *                     41.0 1 30 6 0   1     0   3   18 23                 41

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