enrollments

Data source: Big Local News · About: Big Local

9,536 rows where state = "MA" and year = 2021 sorted by ccd_school_low_grade descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 9,536 ✖
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
1675697 1675697 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   kindergarten * * * *   *     *   *   * * *                     0.0                                             0
1675698 1675698 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   pre_kindergarten * * * *   *     *   *   * * *                     0.0                                             0
1675699 1675699 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_1 * * * *   *     *   *   * * *                     0.0                                             0
1675700 1675700 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_2 * * * *   *     *   *   * * *                     0.0                                             0
1675701 1675701 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_3 * * * *   *     *   *   * * *                     0.0                                             0
1675702 1675702 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_4 * * * *   *     *   *   * * *                     0.0                                             0
1675703 1675703 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_5 * * * *   *     *   *   * * *                     0.0                                             0
1675704 1675704 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_6 * * * *   *     *   *   * * *                     0.0                                             0
1675705 1675705 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_7 * * * *   *     *   *   * * *                     0.0                                             0
1675706 1675706 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
1675707 1675707 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_9 * * * *   *     *   *   * * *                     0.0                                             0
1675708 1675708 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_10 * * * *   *     *   *   * * *                     0.0                                             0
1675709 1675709 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_11 * * * *   *     *   *   * * *                     0.0                                             0
1675710 1675710 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_12 * * * *   *     *   *   * * *                     0.0                                             0
1675711 1675711 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   sped_beyond_grade_12 * * * *   *     *   *   * * *                     4.0                                             4
1678338 1678338 MA Hampden   school 2511130 281   Springfield 251113002875 2810675 Springfield - Springfield Vocational Academy   Special Education School No Ungraded UG UG 2021   sped_beyond_grade_12 13 27 82 0   5     0   0   86 41 *                     127.0 13 27 82 0   5     0   0   86 41                 127
1672008 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
1672023 1672023 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet - Acushnet Elementary School   Regular School No Elementary PK 04 2021   kindergarten 71 0 11 0   0     0   4   48 38 *                     86.0 71 0 11 0   0     0   4   48 38                 86
1672024 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
1672025 1672025 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet - Acushnet Elementary School   Regular School No Elementary PK 04 2021   grade_1 75 1 3 0   1     0   3   47 36 *                     83.0 75 1 3 0   1     0   3   47 36                 83
1672026 1672026 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet - Acushnet Elementary School   Regular School No Elementary PK 04 2021   grade_2 107 1 2 0   2     0   5   62 55 *                     117.0 107 1 2 0   2     0   5   62 55                 117
1672027 1672027 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet - Acushnet Elementary School   Regular School No Elementary PK 04 2021   grade_3 85 3 3 0   1     0   3   48 47 *                     95.0 85 3 3 0   1     0   3   48 47                 95
1672028 1672028 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet - Acushnet Elementary School   Regular School No Elementary PK 04 2021   grade_4 70 1 4 1   0     0   4   43 37 *                     80.0 70 1 4 1   0     0   4   43 37                 80
1672033 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
1672062 1672062 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury - Amesbury Elementary   Regular School No Elementary PK 04 2021   kindergarten 58 0 5 0   1     0   3   39 28 *                     67.0 58 0 5 0   1     0   3   39 28                 67
1672063 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
1672064 1672064 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury - Amesbury Elementary   Regular School No Elementary PK 04 2021   grade_1 50 1 2 0   0     0   1   33 21 *                     54.0 50 1 2 0   0     0   1   33 21                 54
1672065 1672065 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury - Amesbury Elementary   Regular School No Elementary PK 04 2021   grade_2 56 1 6 0   1     0   4   35 33 *                     68.0 56 1 6 0   1     0   4   35 33                 68
1672066 1672066 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury - Amesbury Elementary   Regular School No Elementary PK 04 2021   grade_3 38 0 5 0   0     0   4   27 20 *                     47.0 38 0 5 0   0     0   4   27 20                 47
1672067 1672067 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury - Amesbury Elementary   Regular School No Elementary PK 04 2021   grade_4 57 6 7 0   2     0   3   50 25 *                     75.0 57 6 7 0   2     0   3   50 25                 75
1672068 1672068 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Amesbury - Charles C Cashman Elementary   Regular School No Elementary PK 04 2021   kindergarten 54 1 8 1   0     0   3   32 35 *                     67.0 54 1 8 1   0     0   3   32 35                 67
1672069 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
1672070 1672070 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Amesbury - Charles C Cashman Elementary   Regular School No Elementary PK 04 2021   grade_1 52 2 12 0   0     0   2   28 40 *                     68.0 52 2 12 0   0     0   2   28 40                 68
1672071 1672071 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Amesbury - Charles C Cashman Elementary   Regular School No Elementary PK 04 2021   grade_2 42 1 4 0   0     1   0   29 19 *                     48.0 42 1 4 0   0     1   0   29 19                 48
1672072 1672072 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Amesbury - Charles C Cashman Elementary   Regular School No Elementary PK 04 2021   grade_3 58 2 14 0   1     0   3   42 36 *                     78.0 58 2 14 0   1     0   3   42 36                 78
1672073 1672073 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Amesbury - Charles C Cashman Elementary   Regular School No Elementary PK 04 2021   grade_4 56 0 9 0   0     0   2   33 34 *                     67.0 56 0 9 0   0     0   2   33 34                 67
1672086 1672086 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst - Crocker Farm Elementary   Regular School No Elementary PK 06 2021   kindergarten 23 7 6 0   7     1   4   22 25 *                     48.0 23 7 6 0   7     1   4   22 25                 48
1672087 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
1672088 1672088 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst - Crocker Farm Elementary   Regular School No Elementary PK 06 2021   grade_1 19 3 2 0   5     0   2   13 17 *                     31.0 19 3 2 0   5     0   2   13 17                 31
1672089 1672089 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst - Crocker Farm Elementary   Regular School No Elementary PK 06 2021   grade_2 28 5 12 0   4     0   5   24 30 *                     54.0 28 5 12 0   4     0   5   24 30                 54
1672090 1672090 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst - Crocker Farm Elementary   Regular School No Elementary PK 06 2021   grade_3 19 4 8 2   6     0   2   19 21 *                     41.0 19 4 8 2   6     0   2   19 21                 41
1672091 1672091 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst - Crocker Farm Elementary   Regular School No Elementary PK 06 2021   grade_4 20 4 7 0   6     0   6   27 16 *                     43.0 20 4 7 0   6     0   6   27 16                 43
1672092 1672092 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst - Crocker Farm Elementary   Regular School No Elementary PK 06 2021   grade_5 30 7 10 0   9     0   0   29 27 *                     56.0 30 7 10 0   9     0   0   29 27                 56
1672093 1672093 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst - Crocker Farm Elementary   Regular School No Elementary PK 06 2021   grade_6 26 1 15 0   6     0   2   26 24 *                     50.0 26 1 15 0   6     0   2   26 24                 50
1672120 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
1672177 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
1672203 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
1672222 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
1672266 1672266 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Auburn - Pakachoag School   Regular School No Elementary PK 02 2021   kindergarten 59 2 7 0   4     0   3   39 36 *                     75.0 59 2 7 0   4     0   3   39 36                 75
1672267 1672267 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Auburn - Pakachoag School   Regular School No Elementary PK 02 2021   grade_1 78 0 7 0   2     0   2   40 49 *                     89.0 78 0 7 0   2     0   2   40 49                 89
1672268 1672268 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Auburn - Pakachoag School   Regular School No Elementary PK 02 2021   grade_2 85 3 11 0   3     0   2   58 46 *                     104.0 85 3 11 0   3     0   2   58 46                 104
1672281 1672281 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Avon - Ralph D Butler   Regular School No Elementary PK 06 2021   kindergarten 18 11 9 0   1     0   3   22 20 *                     42.0 18 11 9 0   1     0   3   22 20                 42
1672282 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
1672283 1672283 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Avon - Ralph D Butler   Regular School No Elementary PK 06 2021   grade_1 27 9 5 0   2     0   3   21 25 *                     46.0 27 9 5 0   2     0   3   21 25                 46
1672284 1672284 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Avon - Ralph D Butler   Regular School No Elementary PK 06 2021   grade_2 27 10 8 0   1     0   6   24 28 *                     52.0 27 10 8 0   1     0   6   24 28                 52
1672285 1672285 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Avon - Ralph D Butler   Regular School No Elementary PK 06 2021   grade_3 26 15 7 0   2     0   4   30 24 *                     54.0 26 15 7 0   2     0   4   30 24                 54
1672286 1672286 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Avon - Ralph D Butler   Regular School No Elementary PK 06 2021   grade_4 23 13 8 0   3     0   3   24 26 *                     50.0 23 13 8 0   3     0   3   24 26                 50
1672287 1672287 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Avon - Ralph D Butler   Regular School No Elementary PK 06 2021   grade_5 34 15 6 0   4     0   3   31 31 *                     62.0 34 15 6 0   4     0   3   31 31                 62
1672288 1672288 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Avon - Ralph D Butler   Regular School No Elementary PK 06 2021   grade_6 29 19 6 0   1     0   0   26 29 *                     55.0 29 19 6 0   1     0   0   26 29                 55
1672295 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
1672326 1672326 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Bedford - Lt Elezer Davis   Regular School No Elementary PK 02 2021   kindergarten 80 6 14 0   44     0   16   86 74 *                     160.0 80 6 14 0   44     0   16   86 74                 160
1672327 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
1672328 1672328 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Bedford - Lt Elezer Davis   Regular School No Elementary PK 02 2021   grade_1 109 11 12 0   41     0   10   102 81 *                     183.0 109 11 12 0   41     0   10   102 81                 183
1672329 1672329 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Bedford - Lt Elezer Davis   Regular School No Elementary PK 02 2021   grade_2 109 12 10 0   54     0   16   115 86 *                     201.0 109 12 10 0   54     0   16   115 86                 201
1672340 1672340 MA Hampshire   school 2502430 24   Belchertown 250243000136 240005 Belchertown - Cold Spring   Regular School No Elementary PK KG 2021   kindergarten 119 0 18 0   0     0   4   78 63 *                     141.0 119 0 18 0   0     0   4   78 63                 141
1672341 1672341 MA Hampshire   school 2502430 24   Belchertown 250243000136 240005 Belchertown - Cold Spring   Regular School No Elementary PK KG 2021   pre_kindergarten 26 2 3 0   0     0   4   18 17 *                     35.0 26 2 3 0   0     0   4   18 17                 35
1672354 1672354 MA Norfolk   school 2502460 25   Bellingham 250246000670 250003 Bellingham - Bellingham Early Childhood Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 48 2 5 0   2     0   0   26 31 *                     57.0 48 2 5 0   2     0   0   26 31                 57
1672391 1672391 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Belmont - Roger E Wellington   Regular School No Elementary PK 04 2021   kindergarten 44 4 2 0   14     0   8   32 40 *                     72.0 44 4 2 0   14     0   8   32 40                 72
1672392 1672392 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Belmont - Roger E Wellington   Regular School No Elementary PK 04 2021   pre_kindergarten 32 3 3 0   5     0   5   22 26 *                     48.0 32 3 3 0   5     0   5   22 26                 48
1672393 1672393 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Belmont - Roger E Wellington   Regular School No Elementary PK 04 2021   grade_1 73 4 0 0   19     0   13   57 52 *                     109.0 73 4 0 0   19     0   13   57 52                 109
1672394 1672394 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Belmont - Roger E Wellington   Regular School No Elementary PK 04 2021   grade_2 69 7 1 0   14     0   11   43 59 *                     102.0 69 7 1 0   14     0   11   43 59                 102
1672395 1672395 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Belmont - Roger E Wellington   Regular School No Elementary PK 04 2021   grade_3 82 4 3 0   17     0   8   57 57 *                     114.0 82 4 3 0   17     0   8   57 57                 114
1672396 1672396 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Belmont - Roger E Wellington   Regular School No Elementary PK 04 2021   grade_4 78 1 0 0   23     0   15   62 55 *                     117.0 78 1 0 0   23     0   15   62 55                 117
1672405 1672405 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley - Berkley Community School   Regular School No Elementary PK 04 2021   kindergarten 66 2 4 0   0     0   5   39 38 *                     77.0 66 2 4 0   0     0   5   39 38                 77
1672406 1672406 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley - Berkley Community School   Regular School No Elementary PK 04 2021   pre_kindergarten 36 1 1 0   1     0   2   27 14 *                     41.0 36 1 1 0   1     0   2   27 14                 41
1672407 1672407 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley - Berkley Community School   Regular School No Elementary PK 04 2021   grade_1 86 0 1 1   0     0   7   50 45 *                     95.0 86 0 1 1   0     0   7   50 45                 95
1672408 1672408 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley - Berkley Community School   Regular School No Elementary PK 04 2021   grade_2 79 1 2 0   2     1   1   43 43 *                     86.0 79 1 2 0   2     1   1   43 43                 86
1672409 1672409 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley - Berkley Community School   Regular School No Elementary PK 04 2021   grade_3 69 1 1 0   0     0   4   36 39 *                     75.0 69 1 1 0   0     0   4   36 39                 75
1672410 1672410 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley - Berkley Community School   Regular School No Elementary PK 04 2021   grade_4 95 0 2 0   1     0   3   57 44 *                     101.0 95 0 2 0   1     0   3   57 44                 101
1672415 1672415 MA Essex   school 2502640 30   Beverly 250264002854 300002 Beverly - McKeown School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 55 4 12 0   7     0   4   51 31 *                     82.0 55 4 12 0   7     0   4   51 31                 82
1672488 1672488 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Boston - Lee Academy   Regular School No Elementary PK 03 2021   kindergarten 2 18 15 0   7     0   4   26 20 *                     46.0 2 18 15 0   7     0   4   26 20                 46
1672489 1672489 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Boston - Lee Academy   Regular School No Elementary PK 03 2021   pre_kindergarten 6 18 19 0   2     0   2   23 24 *                     47.0 6 18 19 0   2     0   2   23 24                 47
1672490 1672490 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Boston - Lee Academy   Regular School No Elementary PK 03 2021   grade_1 2 19 8 0   3     0   1   15 18 *                     33.0 2 19 8 0   3     0   1   15 18                 33
1672491 1672491 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Boston - Lee Academy   Regular School No Elementary PK 03 2021   grade_2 1 19 7 0   1     0   4   15 17 *                     32.0 1 19 7 0   1     0   4   15 17                 32
1672492 1672492 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Boston - Lee Academy   Regular School No Elementary PK 03 2021   grade_3 1 14 17 0   1     0   1   17 17 *                     34.0 1 14 17 0   1     0   1   17 17                 34
1672493 1672493 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Boston - Baldwin Early Learning Center   Regular School No Elementary PK 01 2021   kindergarten 5 5 15 0   12     0   5   22 20 *                     42.0 5 5 15 0   12     0   5   22 20                 42
1672494 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
1672495 1672495 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Boston - Baldwin Early Learning Center   Regular School No Elementary PK 01 2021   grade_1 10 10 6 0   2     0   1   18 11 *                     29.0 10 10 6 0   2     0   1   18 11                 29
1672505 1672505 MA Suffolk   school 2502790 35   Boston 250279002514 350006 Boston - ELC - West Zone   Regular School No Elementary PK 01 2021   kindergarten 3 10 11 0   1     0   1   12 14 *                     26.0 3 10 11 0   1     0   1   12 14                 26
1672506 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
1672507 1672507 MA Suffolk   school 2502790 35   Boston 250279002514 350006 Boston - ELC - West Zone   Regular School No Elementary PK 01 2021   grade_1 4 11 13 0   2     0   3   21 12 *                     33.0 4 11 13 0   2     0   3   21 12                 33
1672508 1672508 MA Suffolk   school 2502790 35   Boston 250279001115 350008 Boston - Dr. Catherine Ellison-Rosa Parks Early Ed School   Regular School No Elementary PK 03 2021   kindergarten 0 12 11 0   2     0   2   12 15 *                     27.0 0 12 11 0   2     0   2   12 15                 27
1672509 1672509 MA Suffolk   school 2502790 35   Boston 250279001115 350008 Boston - Dr. Catherine Ellison-Rosa Parks Early Ed School   Regular School No Elementary PK 03 2021   pre_kindergarten 4 25 17 0   0     0   0   20 26 *                     46.0 4 25 17 0   0     0   0   20 26                 46
1672510 1672510 MA Suffolk   school 2502790 35   Boston 250279001115 350008 Boston - Dr. Catherine Ellison-Rosa Parks Early Ed School   Regular School No Elementary PK 03 2021   grade_1 2 19 12 0   0     0   0   16 17 *                     33.0 2 19 12 0   0     0   0   16 17                 33
1672511 1672511 MA Suffolk   school 2502790 35   Boston 250279001115 350008 Boston - Dr. Catherine Ellison-Rosa Parks Early Ed School   Regular School No Elementary PK 03 2021   grade_2 0 17 15 0   0     0   1   20 13 *                     33.0 0 17 15 0   0     0   1   20 13                 33
1672512 1672512 MA Suffolk   school 2502790 35   Boston 250279001115 350008 Boston - Dr. Catherine Ellison-Rosa Parks Early Ed School   Regular School No Elementary PK 03 2021   grade_3 2 20 12 1   0     0   0   22 13 *                     35.0 2 20 12 1   0     0   0   22 13                 35
1672513 1672513 MA Suffolk   school 2502790 35   Boston 250279001118 350009 Boston - East Boston Early Childhood Center   Regular School No Elementary PK 01 2021   kindergarten 11 5 36 0   1     0   3   23 33 *                     56.0 11 5 36 0   1     0   3   23 33                 56
1672514 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
1672515 1672515 MA Suffolk   school 2502790 35   Boston 250279001118 350009 Boston - East Boston Early Childhood Center   Regular School No Elementary PK 01 2021   grade_1 12 2 44 0   1     1   0   32 28 *                     60.0 12 2 44 0   1     1   0   32 28                 60
1672516 1672516 MA Suffolk   school 2502790 35   Boston 250279001126 350010 Boston - Haynes Early Education Center   Regular School No Elementary PK 01 2021   kindergarten 1 24 30 0   1     0   6   31 31 *                     62.0 1 24 30 0   1     0   6   31 31                 62

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