Data source: Big Local News · About: Big Local

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

View and edit SQL

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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
1675312 MA Essex   school 2506660 149   Lawrence 250666002919 1490615 Lawrence - RISE Academy   Alternative School No Secondary 09 11 2021   grade_9 0 0 8 0   0     0   0   7 * *                     8.0 0 0 8 0   0     0   0   7                   8
1675313 MA Essex   school 2506660 149   Lawrence 250666002919 1490615 Lawrence - RISE Academy   Alternative School No Secondary 09 11 2021   grade_10 0 1 10 0   0     0   0   8 * *                     11.0 0 1 10 0   0     0   0   8                   11
1675314 MA Essex   school 2506660 149   Lawrence 250666002919 1490615 Lawrence - RISE Academy   Alternative School No Secondary 09 11 2021   grade_11 * * * *   *     *   *   2 * *                     2.0                         2                   2
1678339 MA Hampden   school 2511130 281   Springfield 251113002884 2810700 Springfield - Springfield International Academy at Sci-Tech   Regular School No Secondary 09 11 2021   grade_9 1 0 9 0   0     0   0   6 4 *                     10.0 1 0 9 0   0     0   0   6 4                 10
1678340 MA Hampden   school 2511130 281   Springfield 251113002884 2810700 Springfield - Springfield International Academy at Sci-Tech   Regular School No Secondary 09 11 2021   grade_10 0 4 31 0   0     0   0   27 8 *                     35.0 0 4 31 0   0     0   0   27 8                 35
1678341 MA Hampden   school 2511130 281   Springfield 251113002884 2810700 Springfield - Springfield International Academy at Sci-Tech   Regular School No Secondary 09 11 2021   grade_11 0 0 18 0   1     0   0   16 3 *                     19.0 0 0 18 0   1     0   0   16 3                 19
1681474 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School (District) - Argosy Collegiate Charter School   Regular School Yes Secondary 06 11 2021   grade_6 47 14 32 1   5     0   9   56 52 *                     108.0 47 14 32 1   5     0   9   56 52                 108
1681475 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School (District) - Argosy Collegiate Charter School   Regular School Yes Secondary 06 11 2021   grade_7 49 15 40 0   3     0   2   53 56 *                     109.0 49 15 40 0   3     0   2   53 56                 109
1681476 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School (District) - Argosy Collegiate Charter School   Regular School Yes Secondary 06 11 2021   grade_8 69 10 24 0   1     0   5   58 51 *                     109.0 69 10 24 0   1     0   5   58 51                 109
1681477 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School (District) - Argosy Collegiate Charter School   Regular School Yes Secondary 06 11 2021   grade_9 34 10 14 1   1     0   5   42 23 *                     65.0 34 10 14 1   1     0   5   42 23                 65
1681478 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School (District) - Argosy Collegiate Charter School   Regular School Yes Secondary 06 11 2021   grade_10 49 11 18 1   2     0   4   53 32 *                     85.0 49 11 18 1   2     0   4   53 32                 85
1681479 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School (District) - Argosy Collegiate Charter School   Regular School Yes Secondary 06 11 2021   grade_11 39 10 10 0   0     0   5   32 32 *                     64.0 39 10 10 0   0     0   5   32 32                 64
1681480 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School (District) - Argosy Collegiate Charter School   Regular School Yes Secondary 06 11 2021   grade_12 15 7 7 0   1     0   1   15 16 *                     31.0 15 7 7 0   1     0   1   15 16                 31
1681505 MA Hampden   school 2500588 3516   Hampden Charter School of Science West (District) 250058802888 35160305 Hampden Charter School of Science West (District) - Hampden Charter School of Science West   Regular School Yes Secondary 06 11 2021   grade_6 23 10 20 0   0     0   1   30 24 *                     54.0 23 10 20 0   0     0   1   30 24                 54
1681506 MA Hampden   school 2500588 3516   Hampden Charter School of Science West (District) 250058802888 35160305 Hampden Charter School of Science West (District) - Hampden Charter School of Science West   Regular School Yes Secondary 06 11 2021   grade_7 30 15 25 0   1     0   0   34 37 *                     71.0 30 15 25 0   1     0   0   34 37                 71
1681507 MA Hampden   school 2500588 3516   Hampden Charter School of Science West (District) 250058802888 35160305 Hampden Charter School of Science West (District) - Hampden Charter School of Science West   Regular School Yes Secondary 06 11 2021   grade_8 34 11 22 0   0     0   1   37 31 *                     68.0 34 11 22 0   0     0   1   37 31                 68
1681508 MA Hampden   school 2500588 3516   Hampden Charter School of Science West (District) 250058802888 35160305 Hampden Charter School of Science West (District) - Hampden Charter School of Science West   Regular School Yes Secondary 06 11 2021   grade_9 33 8 16 0   1     0   1   37 22 *                     59.0 33 8 16 0   1     0   1   37 22                 59
1681509 MA Hampden   school 2500588 3516   Hampden Charter School of Science West (District) 250058802888 35160305 Hampden Charter School of Science West (District) - Hampden Charter School of Science West   Regular School Yes Secondary 06 11 2021   grade_10 17 5 18 0   1     0   0   19 22 *                     41.0 17 5 18 0   1     0   0   19 22                 41
1681510 MA Hampden   school 2500588 3516   Hampden Charter School of Science West (District) 250058802888 35160305 Hampden Charter School of Science West (District) - Hampden Charter School of Science West   Regular School Yes Secondary 06 11 2021   grade_11 11 5 8 0   1     0   2   12 15 *                     27.0 11 5 8 0   1     0   2   12 15                 27
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
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
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 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 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 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
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
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
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
1673394 MA Plymouth   school 2503090 44   Brockton 250309002792 440008 Brockton - Barrett Russell Early Childhood Center   Regular School No Prekindergarten PK PK 2021   kindergarten 0 5 2 0   0     0   0   4 3 *                     7.0 0 5 2 0   0     0   0   4 3                 7
1673395 MA Plymouth   school 2503090 44   Brockton 250309002792 440008 Brockton - Barrett Russell Early Childhood Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 38 74 23 0   1     1   8   95 50 *                     145.0 38 74 23 0   1     1   8   95 50                 145
1673496 MA Norfolk   school 2503150 46   Brookline 250315002776 460001 Brookline - Brookline Early Education Program at Beacon   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 11 1 0 0   9     0   5   14 12 *                     26.0 11 1 0 0   9     0   5   14 12                 26
1673497 MA Norfolk   school 2503150 46   Brookline 250315002793 460002 Brookline - Brookline Early Education Program at Putterham   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 14 0 8 0   4     0   2   13 15 *                     28.0 14 0 8 0   4     0   2   13 15                 28
1673498 MA Norfolk   school 2503150 46   Brookline 250315002904 460003 Brookline - Brookline Early Education Program at Clark Road   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 17 1 2 0   5     0   6   18 13 *                     31.0 17 1 2 0   5     0   6   18 13                 31
1673574 MA Norfolk   school 2503150 46   Brookline 250315002027 460060 Brookline - The Lynch Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 9 6 5 0   8     0   2   18 12 *                     30.0 9 6 5 0   8     0   2   18 12                 30
1673716 MA Norfolk   school 2503300 50   Canton 250330002635 500010 Canton - Rodman Early Childhood Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 14 3 2 0   4     0   1   18 6 *                     24.0 14 3 2 0   4     0   1   18 6                 24
1673767 MA Middlesex   school 2503510 56   Chelmsford 250351002640 560001 Chelmsford - Community Education Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 38 8 12 0   13     0   5   53 23 *                     76.0 38 8 12 0   13     0   5   53 23                 76
1673841 MA Hampden   school 2503660 61   Chicopee 250366002571 610001 Chicopee - Szetela Early Childhood Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 44 6 60 0   3     0   8   86 35 *                     121.0 44 6 60 0   3     0   8   86 35                 121
1674256 MA Middlesex   school 2504770 93   Everett 250477002900 930001 Everett - Webster Extension   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 30 25 66 1   18     0   2   80 62 *                     142.0 30 25 66 1   18     0   2   80 62                 142
1674257 MA Middlesex   school 2504770 93   Everett 250477002804 930003 Everett - Adams School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 28 15 55 0   8     1   1   61 47 *                     108.0 28 15 55 0   8     1   1   61 47                 108
1674558 MA Middlesex   school 2504980 100   Framingham 250498002820 1000001 Framingham - Juniper Hill School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 104 13 58 0   15     1   4   123 72 *                     195.0 104 13 58 0   15     1   4   123 72                 195
1674626 MA Norfolk   school 2505010 101   Franklin 250501000986 1010003 Franklin - Franklin Early Childhood Development Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 58 1 1 0   7     0   6   50 23 *                     73.0 58 1 1 0   7     0   6   50 23                 73
1674696 MA Essex   school 2505220 105   Georgetown 250522000766 1050005 Georgetown - Perley Elementary   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 16 0 0 0   0     0   1   13 * *                     17.0 16 0 0 0   0     0   1   13                   17
1674722 MA Essex   school 2505280 107   Gloucester 250528002574 1070025 Gloucester - Gloucester PreSchool   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 54 1 7 0   1     0   3   39 27 *                     66.0 54 1 7 0   1     0   3   39 27                 66
1674800 MA Franklin   school 2505490 114   Greenfield 250549002128 1140005 Greenfield - The Academy of Early Learning at North Parish   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 40 2 10 0   0     0   2   31 23 *                     54.0 40 2 10 0   0     0   2   31 23                 54
1674920 MA Essex   school 2505970 128   Haverhill 250597000056 1280045 Haverhill - Moody   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 92 21 66 0   2     0   1   120 62 *                     182.0 92 21 66 0   2     0   1   120 62                 182
1675110 MA Worcester   school 2506300 138   Hopedale 250630002041 1380003 Hopedale - Park Street School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 59 2 6 0   1     0   12   43 37 *                     80.0 59 2 6 0   1     0   12   43 37                 80
1675124 MA Middlesex   school 2506330 139   Hopkinton 250633002043 1390003 Hopkinton - Hopkinton Pre-School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 46 0 5 0   19     0   5   48 27 *                     75.0 46 0 5 0   19     0   5   48 27                 75
1675330 MA Worcester   school 2506720 151   Leicester 250672002911 1510001 Leicester - Leicester Integrated Preschool   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 23 1 7 0   0     0   2   14 19 *                     33.0 23 1 7 0   0     0   2   14 19                 33
1675358 MA Worcester   school 2506780 153   Leominster 250678000064 1530003 Leominster - Bennett   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 18 6 25 0   0     0   2   31 20 *                     51.0 18 6 25 0   0     0   2   31 20                 51
1675359 MA Worcester   school 2506780 153   Leominster 250678001947 1530005 Leominster - Lincoln School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 8 3 11 0   0     0   2   14 10 *                     24.0 8 3 11 0   0     0   2   14 10                 24
1675410 MA Middlesex   school 2506840 155   Lexington 250684002829 1550001 Lexington - Lexington Children's Place   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 27 2 1 1   22     0   4   36 21 *                     57.0 27 2 1 1   22     0   4   36 21                 57
1675520 MA Middlesex   school 2507020 160   Lowell 250702002891 1600001 Lowell - Cardinal O'Connell Early Learning Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 18 4 23 0   23     0   2   46 24 *                     70.0 18 4 23 0   23     0   2   46 24                 70
1675857 MA Essex   school 2507140 164   Lynnfield 250714002617 1640005 Lynnfield - Lynnfield Preschool   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 19 1 2 0   2     0   3   12 15 *                     27.0 19 1 2 0   2     0   3   12 15                 27
1675912 MA Middlesex   school 2507170 165   Malden 250717002046 1650049 Malden - Malden Early Learning Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 72 37 14 0   82     0   12   136 81 *                     217.0 72 37 14 0   82     0   12   136 81                 217
1675927 MA Bristol   school 2507230 167   Mansfield 250723001004 1670003 Mansfield - Roland Green School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 69 3 10 1   3     0   5   54 37 *                     91.0 69 3 10 1   3     0   5   54 37                 91
1675969 MA Middlesex   school 2507320 170   Marlborough 250732001368 1700006 Marlborough - Early Childhood Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 80 11 48 0   12     0   6   96 61 *                     157.0 80 11 48 0   12     0   6   96 61                 157
1676265 MA Worcester   school 2507860 185   Milford 250786001650 1850075 Milford - Shining Star Early Childhood Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 65 1 24 0   1     0   1   63 29 *                     92.0 65 1 24 0   1     0   1   63 29                 92
1676685 MA Middlesex   school 2508610 207   Newton 250861001657 2070108 Newton - Newton Early Childhood Program   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 67 3 8 0   34     0   13   81 44 *                     125.0 67 3 8 0   34     0   13   81 44                 125
1676860 MA Bristol   school 2508730 212   North Attleborough 250873001409 2120020 North Attleborough - North Attleborough Early Learning Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 93 6 11 0   25     0   6   91 50 *                     141.0 93 6 11 0   25     0   6   91 50                 141
1677268 MA Plymouth   school 2509720 239   Plymouth 250972000318 2390003 Plymouth - Plymouth Early Childhood Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 119 1 16 1   2     0   3   88 54 *                     142.0 119 1 16 1   2     0   3   88 54                 142
1677348 MA Norfolk   school 2509870 243   Quincy 250987002807 2430005 Quincy - Amelio Della Chiesa Early Childhood Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 50 14 16 0   58     0   11   95 54 *                     149.0 50 14 16 0   58     0   11   95 54                 149
1677474 MA Middlesex   school 2509990 246   Reading 250999002751 2460001 Reading - RISE PreSchool   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 79 4 4 0   6     0   4   66 31 *                     97.0 79 4 4 0   6     0   4   66 31                 97
1677797 MA Norfolk   school 2510620 266   Sharon 251062002872 2660001 Sharon - Sharon Early Childhood Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 16 0 1 0   12     0   2   17 14 *                     31.0 16 0 1 0   12     0   2   17 14                 31
1677853 MA Worcester   school 2510770 271   Shrewsbury 251077001559 2710040 Shrewsbury - Parker Road Preschool   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 47 10 11 0   32     0   10   76 34 *                     110.0 47 10 11 0   32     0   10   76 34                 110
1678374 MA Norfolk   school 2511250 285   Stoughton 251125001860 2850012 Stoughton - Edwin A Jones Early Childhood Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 27 20 8 0   4     1   5   37 28 *                     65.0 27 20 8 0   4     1   5   37 28                 65
1678510 MA Bristol   school 2511520 293   Taunton 251152000133 2930005 Taunton - Edward F. Leddy Preschool   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 88 25 23 0   1     0   11   87 61 *                     148.0 88 25 23 0   1     0   11   87 61                 148
1678636 MA Middlesex   school 2511910 305   Wakefield 251191002826 3050001 Wakefield - Early Childhood Center at the Doyle School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 52 4 4 0   5     0   3   45 23 *                     68.0 52 4 4 0   5     0   3   45 23                 68
1678673 MA Norfolk   school 2511970 307   Walpole 251197002620 3070002 Walpole - Daniel Feeney Preschool Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 51 2 6 0   2     0   1   36 26 *                     62.0 51 2 6 0   2     0   1   36 26                 62
1678863 MA Norfolk   school 2512270 317   Wellesley 251227002893 3170001 Wellesley - Preschool at Wellesley Schools   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 43 1 4 0   11     0   5   40 24 *                     64.0 43 1 4 0   11     0   5   40 24                 64
1678971 MA Hampden   school 2512630 325   Westfield 251263002452 3250003 Westfield - Fort Meadow Early Childhood Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 74 5 29 0   3     0   7   68 50 *                     118.0 74 5 29 0   3     0   7   68 50                 118
1679089 MA Hampden   school 2512510 332   West Springfield 251251002757 3320001 West Springfield - Cowing Early Childhood   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 37 3 30 0   8     0   4   61 21 *                     82.0 37 3 30 0   8     0   4   61 21                 82
1679156 MA Norfolk   school 2512810 335   Westwood 251281002115 3350050 Westwood - Westwood Integrated Preschool   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 32 1 3 0   2     0   0   25 13 *                     38.0 32 1 3 0   2     0   0   25 13                 38
1679164 MA Norfolk   school 2512840 336   Weymouth 251284000371 3360003 Weymouth - Johnson Early Childhood Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 80 6 5 0   16     0   13   78 42 *                     120.0 80 6 5 0   16     0   13   78 42                 120
1679257 MA Worcester   school 2513080 343   Winchendon 251308002648 3430010 Winchendon - Winchendon PreSchool Program   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 51 1 2 0   0     0   2   32 24 *                     56.0 51 1 2 0   0     0   2   32 24                 56
1679385 MA Worcester   school 2513230 348   Worcester 251323002684 3480002 Worcester - Head Start   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 155 106 22 9   14     0   13   157 162 *                     319.0 155 106 22 9   14     0   13   157 162                 319
1680244 MA Middlesex   school 2501710 600   Acton-Boxborough 250171002867 6000001 Acton-Boxborough - Carol Huebner Early Childhood Program   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 33 5 5 0   26     0   4   44 29 *                     73.0 33 5 5 0   26     0   4   44 29                 73
1680644 MA Middlesex   school 2505500 673   Groton-Dunstable 250550002611 6730001 Groton-Dunstable - Boutwell School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 32 0 3 0   1     0   1   20 17 *                     37.0 32 0 3 0   1     0   1   20 17                 37
1681205 MA Worcester   school 2511880 775   Wachusett 251188002730 7750001 Wachusett - Early Childhood Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 71 2 13 0   5     0   2   58 35 *                     93.0 71 2 13 0   5     0   2   58 35                 93
1681290 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002902 7800001 Whitman-Hanson - The Pre-School Academy at Whitman Hanson   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 68 3 4 0   3     0   2   55 25 *                     80.0 68 3 4 0   3     0   2   55 25                 80
1673014 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston - William McKinley   Regular School No Other KG 12 2021   grade_2 * * * *   *     *   *   4 1 *                     5.0                         4 1                 5
1673015 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston - William McKinley   Regular School No Other KG 12 2021   grade_3 0 3 5 0   0     0   1   8 1 *                     9.0 0 3 5 0   0     0   1   8 1                 9
1673016 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston - William McKinley   Regular School No Other KG 12 2021   grade_4 3 4 5 0   1     0   0   12 1 *                     13.0 3 4 5 0   1     0   0   12 1                 13
1673017 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston - William McKinley   Regular School No Other KG 12 2021   grade_5 0 6 8 1   0     0   0   13 2 *                     15.0 0 6 8 1   0     0   0   13 2                 15
1673018 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston - William McKinley   Regular School No Other KG 12 2021   grade_7 5 9 8 0   0     0   0   16 6 *                     22.0 5 9 8 0   0     0   0   16 6                 22

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