Data source: Big Local News · About: Big Local

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

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
1364784 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington Early Education Program   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 68 9 7 0   4     0   0   43 45 *                     88.0 68 9 7 0   4     0   0   43 45                 88
1672008 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington - Abington Early Education Program   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 44 4 2 0   1     0   0   28 23 *                     51.0 44 4 2 0   1     0   0   28 23                 51
2039810 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington Early Education Program   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 71 9 9 0   1     0   0   45 45                       90.0 71 9 9 0   1     0   0   45 45                 90
2228754 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington: Abington Early Education Program   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 70 9 1 0   4     0   0   45 39                       84.0 70 9 1 0   4     0   0   45 39                 84
735659 MA Plymouth   school 2501650 1   Abington 250165002727 10002 Center Elementary School   Regular School No 1 PK KG 2015   pre_kindergarten 71 1 1 0   3     0   0   48 28                       76 71 1 1 0   3     0   0   48 28                 76
932537 MA Plymouth   school 2501650 1   Abington 250165002727 10002 Center Elementary School   Regular School No 1 PK KG 2016   pre_kindergarten 63 2 5 0   1     0   1   41 31                       72 63 2 5 0   1     0   1   41 31                 72
1121947 MA Plymouth   school 2501650 1   Abington 250165002727 10002 Center Elementary School   Regular School No Elementary PK KG 2017   pre_kindergarten 57 3 5 0   4     0   0   37 32                       69 57 3 5 0   4     0   0   37 32                 69
735674 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No 1 PK 04 2015   pre_kindergarten 48 0 1 0   0     0   2   27 24                       51 48 0 1 0   0     0   2   27 24                 51
932552 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No 1 PK 04 2016   pre_kindergarten 45 0 2 0   0     0   1   29 19                       48 45 0 2 0   0     0   1   29 19                 48
1121966 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   pre_kindergarten 43 2 2 0   1     0   2   25 25                       50 43 2 2 0   1     0   2   25 25                 50
1364800 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten 39 1 4 0   0     0   2   28 18 *                     46.0 39 1 4 0   0     0   2   28 18                 46
1672024 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet - Acushnet Elementary School   Regular School No Elementary PK 04 2021   pre_kindergarten 25 1 1 0   0     0   1   16 12 *                     28.0 25 1 1 0   0     0   1   16 12                 28
2039825 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten 44 0 1 0   0     0   1   22 24                       46.0 44 0 1 0   0     0   1   22 24                 46
2228774 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet: Acushnet Elementary School   Regular School No Elementary PK 04 2018   pre_kindergarten 48 0 2 0   0     0   1   30 21                       51.0 48 0 2 0   0     0   1   30 21                 51
735683 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam Early Childhood Center   Regular School No 1 PK PK 2015   pre_kindergarten 154 2 7 0   2     0   0   105 60                       165 154 2 7 0   2     0   0   105 60                 165
932561 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam Early Childhood Center   Regular School No 1 PK PK 2016   pre_kindergarten 145 7 10 0   3     0   3   95 73                       168 145 7 10 0   3     0   3   95 73                 168
1121977 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam Early Childhood Center   Regular School No Elementary PK PK 2017   pre_kindergarten 108 7 19 0   13     0   4   87 64                       151 108 7 19 0   13     0   4   87 64                 151
1364809 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 114 6 18 0   15     0   7   93 67 *                     160.0 114 6 18 0   15     0   7   93 67                 160
1672033 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam - Agawam Early Childhood Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 77 3 16 0   7     0   3   59 47 *                     106.0 77 3 16 0   7     0   3   59 47                 106
2039835 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 131 3 12 0   13     0   3   79 83                       162.0 131 3 12 0   13     0   3   79 83                 162
2228785 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam: Agawam Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 121 3 22 0   14     0   3   88 75                       163.0 121 3 22 0   14     0   3   88 75                 163
735715 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No 1 PK 04 2015   pre_kindergarten 22 4 3 0   0     0   0   14 15                       29 22 4 3 0   0     0   0   14 15                 29
932593 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No 1 PK 04 2016   pre_kindergarten 25 1 2 0   1     0   1   18 12                       30 25 1 2 0   1     0   1   18 12                 30
1122017 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2017   pre_kindergarten 21 0 4 0   0     0   1   16 10                       26 21 0 4 0   0     0   1   16 10                 26
1364839 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten 32 0 1 0   0     0   0   18 15 *                     33.0 32 0 1 0   0     0   0   18 15                 33
1672063 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury - Amesbury Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten 13 0 1 0   0     0   0   10 4 *                     14.0 13 0 1 0   0     0   0   10 4                 14
2039865 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2019   pre_kindergarten 27 0 1 0   0     0   0   16 12                       28.0 27 0 1 0   0     0   0   16 12                 28
2228823 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury: Amesbury Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten 23 0 1 0   0     1   0   14 11                       25.0 23 0 1 0   0     1   0   14 11                 25
735721 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No 1 PK 04 2015   pre_kindergarten 34 0 2 0   0     0   0   24 12                       36 34 0 2 0   0     0   0   24 12                 36
932599 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No 1 PK 04 2016   pre_kindergarten 34 3 3 0   0     0   0   22 18                       40 34 3 3 0   0     0   0   22 18                 40
1122024 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2017   pre_kindergarten 20 1 3 0   0     0   1   19 6                       25 20 1 3 0   0     0   1   19 6                 25
1364845 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten 23 0 3 0   0     0   0   16 10 *                     26.0 23 0 3 0   0     0   0   16 10                 26
1672069 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Amesbury - Charles C Cashman Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten 11 0 0 0   0     0   0   7 4 *                     11.0 11 0 0 0   0     0   0   7 4                 11
2039871 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2019   pre_kindergarten 23 0 2 0   0     0   1   11 15                       26.0 23 0 2 0   0     0   1   11 15                 26
2228830 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Amesbury: Charles C Cashman Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten 26 0 2 0   0     0   0   17 11                       28.0 26 0 2 0   0     0   0   17 11                 28
735736 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No 1 PK 06 2015   pre_kindergarten 29 8 7 0   16     0   1   35 26                       61 29 8 7 0   16     0   1   35 26                 61
932616 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No 1 PK 06 2016   pre_kindergarten 35 3 9 0   13     0   4   35 29                       64 35 3 9 0   13     0   4   35 29                 64
1122046 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten 29 3 13 0   13     0   8   35 31                       66 29 3 13 0   13     0   8   35 31                 66
1364864 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten 26 4 15 0   5     0   3   37 15 *                     53.0 26 4 15 0   5     0   3   37 15                 53
1672087 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst - Crocker Farm Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten 14 3 10 0   4     0   1   23 9 *                     32.0 14 3 10 0   4     0   1   23 9                 32
2039890 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten 18 7 9 0   11     0   3   29 19                       48.0 18 7 9 0   11     0   3   29 19                 48
2228852 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst: Crocker Farm Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten 23 5 15 0   14     0   8   36 29                       65.0 23 5 15 0   14     0   8   36 29                 65
735770 MA Essex   school 2501950 9   Andover 250195002366 90005 Shawsheen School   Regular School No 1 PK 02 2015   pre_kindergarten 35 3 4 0   13     0   5   36 24                       60 35 3 4 0   13     0   5   36 24                 60
932649 MA Essex   school 2501950 9   Andover 250195002366 90005 Shawsheen School   Regular School No 1 PK PK 2016   pre_kindergarten 44 2 2 1   16     0   3   40 28                       68 44 2 2 1   16     0   3   40 28                 68
1122084 MA Essex   school 2501950 9   Andover 250195002366 90005 Shawsheen School   Regular School No Elementary PK PK 2017   pre_kindergarten 48 2 2 1   20     0   0   39 34                       73 48 2 2 1   20     0   0   39 34                 73
1364897 MA Essex   school 2501950 9   Andover 250195002366 90005 Shawsheen School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 44 0 10 0   20     0   7   59 22 *                     81.0 44 0 10 0   20     0   7   59 22                 81
1672120 MA Essex   school 2501950 9   Andover 250195002366 90005 Andover - Shawsheen School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 36 0 5 0   9     0   4   34 20 *                     54.0 36 0 5 0   9     0   4   34 20                 54
2039924 MA Essex   school 2501950 9   Andover 250195002366 90005 Shawsheen School   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 36 1 3 0   23     0   3   48 18                       66.0 36 1 3 0   23     0   3   48 18                 66
2228890 MA Essex   school 2501950 9   Andover 250195002366 90005 Andover: Shawsheen School   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 47 2 7 0   27     0   2   61 24                       85.0 47 2 7 0   27     0   2   61 24                 85
735786 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No 1 PK 05 2015   pre_kindergarten * * * *   *     *   *   1 2                       3                         1 2                 3
735830 MA Middlesex   school 2501980 10   Arlington 250198001681 100038 Menotomy Preschool   Regular School No 1 PK PK 2015   pre_kindergarten 35 5 2 0   13     0   2   36 21                       57 35 5 2 0   13     0   2   36 21                 57
932706 MA Middlesex   school 2501980 10   Arlington 250198001681 100038 Menotomy Preschool   Regular School No 1 PK PK 2016   pre_kindergarten 41 1 2 0   11     0   1   29 27                       56 41 1 2 0   11     0   1   29 27                 56
1122152 MA Middlesex   school 2501980 10   Arlington 250198001681 100038 Menotomy Preschool   Regular School No Elementary PK PK 2017   pre_kindergarten 55 0 4 0   9     0   2   44 26                       70 55 0 4 0   9     0   2   44 26                 70
1364954 MA Middlesex   school 2501980 10   Arlington 250198001681 100038 Menotomy Preschool   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 51 4 3 0   20     0   11   56 33 *                     89.0 51 4 3 0   20     0   11   56 33                 89
1672177 MA Middlesex   school 2501980 10   Arlington 250198001681 100038 Arlington - Menotomy Preschool   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 38 4 5 0   14     0   4   35 30 *                     65.0 38 4 5 0   14     0   4   35 30                 65
2039981 MA Middlesex   school 2501980 10   Arlington 250198001681 100038 Menotomy Preschool   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 52 5 8 0   23     0   8   65 31                       96.0 52 5 8 0   23     0   8   65 31                 96
2228958 MA Middlesex   school 2501980 10   Arlington 250198001681 100038 Arlington: Menotomy Preschool   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 48 4 8 0   18     0   7   58 27                       85.0 48 4 8 0   18     0   7   58 27                 85
735856 MA Middlesex   school 2502100 14   Ashland 250210002455 140005 William Pittaway Elementary   Regular School No 1 PK PK 2015   pre_kindergarten 93 0 13 0   15     0   2   61 62                       123 93 0 13 0   15     0   2   61 62                 123
932732 MA Middlesex   school 2502100 14   Ashland 250210002455 140005 William Pittaway Elementary   Regular School No 1 PK PK 2016   pre_kindergarten 93 1 11 0   20     0   7   60 72                       132 93 1 11 0   20     0   7   60 72                 132
1122184 MA Middlesex   school 2502100 14   Ashland 250210002455 140005 William Pittaway Elementary   Regular School No Elementary PK PK 2017   pre_kindergarten 96 2 5 0   23     0   5   68 63                       131 96 2 5 0   23     0   5   68 63                 131
1364980 MA Middlesex   school 2502100 14   Ashland 250210002455 140005 William Pittaway Elementary   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 61 5 5 0   22     0   0   58 35 *                     93.0 61 5 5 0   22     0   0   58 35                 93
1672203 MA Middlesex   school 2502100 14   Ashland 250210002455 140005 Ashland - William Pittaway Elementary   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 32 2 3 0   12     0   1   34 16 *                     50.0 32 2 3 0   12     0   1   34 16                 50
2040007 MA Middlesex   school 2502100 14   Ashland 250210002455 140005 William Pittaway Elementary   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 74 9 0 1   30     0   2   68 48                       116.0 74 9 0 1   30     0   2   68 48                 116
2228990 MA Middlesex   school 2502100 14   Ashland 250210002455 140005 Ashland: William Pittaway Elementary   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 95 3 0 1   28     0   0   72 55                       127.0 95 3 0 1   28     0   0   72 55                 127
735875 MA Bristol   school 2502190 16   Attleboro 250219001610 160008 Early Learning Center   Regular School No 1 PK PK 2015   pre_kindergarten 137 3 23 0   12     0   19   121 73                       194 137 3 23 0   12     0   19   121 73                 194
932751 MA Bristol   school 2502190 16   Attleboro 250219001610 160008 Early Learning Center   Regular School No 1 PK PK 2016   pre_kindergarten 133 2 20 0   12     0   16   108 75                       183 133 2 20 0   12     0   16   108 75                 183
1122209 MA Bristol   school 2502190 16   Attleboro 250219001610 160008 Early Learning Center   Regular School No Elementary PK PK 2017   pre_kindergarten 142 7 20 0   7     0   11   115 72                       187 142 7 20 0   7     0   11   115 72                 187
1364999 MA Bristol   school 2502190 16   Attleboro 250219001610 160008 Early Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 132 8 31 0   8     0   5   105 79 *                     184.0 132 8 31 0   8     0   5   105 79                 184
1672222 MA Bristol   school 2502190 16   Attleboro 250219001610 160008 Attleboro - Early Learning Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 73 8 12 0   5     0   6   66 38 *                     104.0 73 8 12 0   5     0   6   66 38                 104
2040026 MA Bristol   school 2502190 16   Attleboro 250219001610 160008 Early Learning Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 133 9 19 0   7     0   11   107 72                       179.0 133 9 19 0   7     0   11   107 72                 179
2229015 MA Bristol   school 2502190 16   Attleboro 250219001610 160008 Attleboro: Early Learning Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 134 10 20 0   7     0   13   110 74                       184.0 134 10 20 0   7     0   13   110 74                 184
1365043 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary PK 02 2020   pre_kindergarten 40 0 4 0   2     0   2   28 20 *                     48.0 40 0 4 0   2     0   2   28 20                 48
2040070 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary PK 02 2019   pre_kindergarten 32 0 5 1   1     0   1   27 13                       40.0 32 0 5 1   1     0   1   27 13                 40
2229069 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Auburn: Pakachoag School   Regular School No Elementary PK 02 2018   pre_kindergarten 29 1 7 0   2     0   2   23 18                       41.0 29 1 7 0   2     0   2   23 18                 41
735930 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No 3 09 12 2015   pre_kindergarten 40 1 2 0   4     0   3   28 22                       50 40 1 2 0   4     0   3   28 22                 50
932804 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No 3 09 12 2016   pre_kindergarten 50 3 3 0   6     0   6   38 30                       68 50 3 3 0   6     0   6   38 30                 68
1122275 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No High 09 12 2017   pre_kindergarten 72 2 5 0   6     0   3   45 43                       88 72 2 5 0   6     0   3   45 43                 88
1365052 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No High 09 12 2020   pre_kindergarten 52 1 3 0   1     0   2   27 32 *                     59.0 52 1 3 0   1     0   2   27 32                 59
1672275 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn - Auburn Senior High   Regular School No High 09 12 2021   pre_kindergarten 51 6 3 0   6     0   0   39 27 *                     66.0 51 6 3 0   6     0   0   39 27                 66
2040080 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No High 09 12 2019   pre_kindergarten 52 1 5 0   1     0   5   27 37                       64.0 52 1 5 0   1     0   5   27 37                 64
2229081 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn: Auburn Senior High   Regular School No High 09 12 2018   pre_kindergarten 57 1 4 0   3     0   3   32 36                       68.0 57 1 4 0   3     0   3   32 36                 68
735937 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No 1 PK 06 2015   pre_kindergarten 13 1 3 0   1     0   1   12 7                       19 13 1 3 0   1     0   1   12 7                 19
932811 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No 1 PK 06 2016   pre_kindergarten 10 1 5 0   1     0   3   9 11                       20 10 1 5 0   1     0   3   9 11                 20
1122282 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2017   pre_kindergarten 12 1 3 0   1     0   0   11 6                       17 12 1 3 0   1     0   0   11 6                 17
1365058 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2020   pre_kindergarten 6 9 3 0   1     0   3   11 11 *                     22.0 6 9 3 0   1     0   3   11 11                 22
1672282 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Avon - Ralph D Butler   Regular School No Elementary PK 06 2021   pre_kindergarten 1 4 2 0   1     0   3   4 7 *                     11.0 1 4 2 0   1     0   3   4 7                 11
2040086 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2019   pre_kindergarten 8 5 2 0   2     0   0   9 8                       17.0 8 5 2 0   2     0   0   9 8                 17
2229088 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Avon: Ralph D Butler   Regular School No Elementary PK 06 2018   pre_kindergarten 15 2 1 0   1     0   0   11 8                       19.0 15 2 1 0   1     0   0   11 8                 19
932825 MA Barnstable   school 2502310 20   Barnstable 250231002851 200001 Enoch Cobb Early Learning Center   Regular School No 1 PK PK 2016   pre_kindergarten 77 7 11 0   1     0   6   68 34                       102 77 7 11 0   1     0   6   68 34                 102
1122297 MA Barnstable   school 2502310 20   Barnstable 250231002851 200001 Enoch Cobb Early Learning Center   Regular School No Elementary PK PK 2017   pre_kindergarten 92 7 14 0   3     0   10   69 57                       126 92 7 14 0   3     0   10   69 57                 126
1365071 MA Barnstable   school 2502310 20   Barnstable 250231002851 200001 Enoch Cobb Early Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 94 9 29 0   3     0   26   99 62 *                     161.0 94 9 29 0   3     0   26   99 62                 161
1672295 MA Barnstable   school 2502310 20   Barnstable 250231002851 200001 Barnstable - Enoch Cobb Early Learning Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 75 7 18 0   6     0   18   85 39 *                     124.0 75 7 18 0   6     0   18   85 39                 124
2040101 MA Barnstable   school 2502310 20   Barnstable 250231002851 200001 Enoch Cobb Early Learning Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 78 15 30 1   1     0   21   88 58                       146.0 78 15 30 1   1     0   21   88 58                 146
2229103 MA Barnstable   school 2502310 20   Barnstable 250231002851 200001 Barnstable: Enoch Cobb Early Learning Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 85 11 26 2   1     0   10   75 60                       135.0 85 11 26 2   1     0   10   75 60                 135
735956 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No 1 PK 03 2015   pre_kindergarten 59 16 10 1   2     0   5   65 28                       93 59 16 10 1   2     0   5   65 28                 93
1365103 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary PK 02 2020   pre_kindergarten 27 3 0 0   13     0   2   30 15 *                     45.0 27 3 0 0   13     0   2   30 15                 45
1672327 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Bedford - Lt Elezer Davis   Regular School No Elementary PK 02 2021   pre_kindergarten 16 3 2 0   5     0   2   23 5 *                     28.0 16 3 2 0   5     0   2   23 5                 28
735987 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No 3 09 12 2015   pre_kindergarten 20 2 5 0   3     0   2   15 17                       32 20 2 5 0   3     0   2   15 17                 32
932861 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No 3 09 12 2016   pre_kindergarten 23 3 0 0   2     0   0   15 13                       28 23 3 0 0   2     0   0   15 13                 28
1122343 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No High 09 12 2017   pre_kindergarten 13 5 0 0   11     0   1   21 9                       30 13 5 0 0   11     0   1   21 9                 30

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