enrollments

Data source: Big Local News · About: Big Local

889 rows where grade = "grade_5", state = "MA" and year = 2021 sorted by asian_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 889 ✖

grade ✖

  • grade_5 · 889 ✖
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
1673282 1673282 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston - Horace Mann School for the Deaf   Special Education School No Other 01 12 2021   grade_5 * * * *   *     *   *   2 2 *                     4.0                         2 2                 4
1673451 1673451 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton - Huntington Therapeutic Day School   Alternative School No Other 02 12 2021   grade_5 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1674755 1674755 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_5 * * * *   *     *   *   * * *                     1.0                                             1
1675612 1675612 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell - Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2021   grade_5 * * * *   *     *   *   1 * *                     2.0                         1                   2
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
1677633 1677633 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe - Rowe Elementary   Regular School No Elementary PK 06 2021   grade_5 * * * *   *     *   *   1 4 *                     5.0                         1 4                 5
1677742 1677742 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Savoy - Emma L Miller Elementary School   Regular School No Elementary PK 06 2021   grade_5 * * * *   *     *   *   3 2 *                     5.0                         3 2                 5
1678251 1678251 MA Hampden   school 2511130 281   Springfield 251113002898 2810215 Springfield - Springfield International Academy at Johnson   Regular School No Elementary 03 05 2021   grade_5 * * * *   *     *   *   2 2 *                     4.0                         2 2                 4
1672411 1672411 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley - Berkley Middle School   Regular School No Middle 05 08 2021   grade_5 86 0 3 0   0     0   4   35 58 *                     93.0 86 0 3 0   0     0   4   35 58                 93
1672501 1672501 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Boston - Lyon K-8   Regular School No Elementary KG 08 2021   grade_5 8 2 0 0   0     0   4   8 6 *                     14.0 8 2 0 0   0     0   4   8 6                 14
1672525 1672525 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston - Boston Teachers Union School   Regular School No Elementary PK 08 2021   grade_5 7 6 9 0   0     0   2   13 11 *                     24.0 7 6 9 0   0     0   2   13 11                 24
1672578 1672578 MA Suffolk   school 2502790 35   Boston 250279000214 350052 Boston - Charles Sumner   Regular School No Elementary PK 05 2021   grade_5 10 18 43 0   0     0   1   34 38 *                     72.0 10 18 43 0   0     0   1   34 38                 72
1672585 1672585 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Boston - Charles H Taylor   Regular School No Elementary PK 05 2021   grade_5 0 42 12 1   0     0   3   22 36 *                     58.0 0 42 12 1   0     0   3   22 36                 58
1672592 1672592 MA Suffolk   school 2502790 35   Boston 250279000218 350062 Boston - Curtis Guild   Regular School No Elementary PK 06 2021   grade_5 5 1 26 0   0     0   0   18 14 *                     32.0 5 1 26 0   0     0   0   18 14                 32
1672600 1672600 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Boston - Dante Alighieri Montessori School   Regular School No Elementary PK 06 2021   grade_5 2 0 2 0   0     0   2   2 4 *                     6.0 2 0 2 0   0     0   2   2 4                 6
1672608 1672608 MA Suffolk   school 2502790 35   Boston 250279000220 350072 Boston - David A Ellis   Regular School No Elementary PK 05 2021   grade_5 0 16 37 0   0     0   1   24 30 *                     54.0 0 16 37 0   0     0   1   24 30                 54
1672632 1672632 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Boston - Donald Mckay   Regular School No Elementary PK 08 2021   grade_5 4 1 64 0   0     0   3   38 34 *                     72.0 4 1 64 0   0     0   3   38 34                 72
1672660 1672660 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Boston - Ellis Mendell   Regular School No Elementary PK 05 2021   grade_5 14 7 14 0   0     0   5   23 16 *                     40.0 14 7 14 0   0     0   5   23 16                 40
1672685 1672685 MA Suffolk   school 2502790 35   Boston 250279000247 350135 Boston - Henry Grew   Regular School No Elementary PK 05 2021   grade_5 3 10 17 0   0     0   0   14 16 *                     30.0 3 10 17 0   0     0   0   14 16                 30
1672716 1672716 MA Suffolk   school 2502790 35   Boston 250279000259 350153 Boston - James W Hennigan   Regular School No Elementary KG 08 2021   grade_5 0 23 42 0   0     0   1   35 31 *                     66.0 0 23 42 0   0     0   1   35 31                 66
1672726 1672726 MA Suffolk   school 2502790 35   Boston 250279000255 350154 Boston - James J Chittick   Regular School No Elementary PK 05 2021   grade_5 1 24 8 0   0     0   0   22 11 *                     33.0 1 24 8 0   0     0   0   22 11                 33
1672755 1672755 MA Suffolk   school 2502790 35   Boston 250279000264 350172 Boston - John D Philbrick   Regular School No Elementary PK 05 2021   grade_5 3 9 6 0   0     0   0   12 6 *                     18.0 3 9 6 0   0     0   0   12 6                 18
1672765 1672765 MA Suffolk   school 2502790 35   Boston 250279000270 350180 Boston - John Winthrop   Regular School No Elementary PK 05 2021   grade_5 0 14 6 0   0     0   2   6 16 *                     22.0 0 14 6 0   0     0   2   6 16                 22
1672780 1672780 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Boston - Joseph J Hurley   Regular School No Elementary PK 08 2021   grade_5 9 1 24 0   0     0   1   21 14 *                     35.0 9 1 24 0   0     0   1   21 14                 35
1672800 1672800 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Boston - Joseph P Manning   Regular School No Elementary PK 06 2021   grade_5 7 5 7 0   0     0   1   11 9 *                     20.0 7 5 7 0   0     0   1   11 9                 20
1672841 1672841 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Boston - Maurice J Tobin   Regular School No Elementary PK 08 2021   grade_5 1 14 27 1   0     0   0   20 23 *                     43.0 1 14 27 1   0     0   0   20 23                 43
1672851 1672851 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Boston - Michael J Perkins   Regular School No Elementary PK 06 2021   grade_5 4 10 9 0   0     0   1   10 14 *                     24.0 4 10 9 0   0     0   1   10 14                 24
1672909 1672909 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Boston - Lyndon   Regular School No Elementary PK 08 2021   grade_5 54 5 18 0   0     0   4   43 38 *                     81.0 54 5 18 0   0     0   4   43 38                 81
1672959 1672959 MA Suffolk   school 2502790 35   Boston 250279000321 350302 Boston - Samuel Adams   Regular School No Elementary PK 06 2021   grade_5 5 1 19 0   0     0   0   10 15 *                     25.0 5 1 19 0   0     0   0   10 15                 25
1672967 1672967 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Boston - Samuel W Mason   Regular School No Elementary PK 05 2021   grade_5 1 17 9 1   0     0   1   18 11 *                     29.0 1 17 9 1   0     0   1   18 11                 29
1672974 1672974 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Boston - Sarah Greenwood   Regular School No Elementary PK 08 2021   grade_5 1 10 28 0   0     0   1   18 22 *                     40.0 1 10 28 0   0     0   1   18 22                 40
1673012 1673012 MA Suffolk   school 2502790 35   Boston 250279000338 350360 Boston - William Ellery Channing   Regular School No Elementary PK 06 2021   grade_5 2 9 8 0   0     0   1   12 8 *                     20.0 2 9 8 0   0     0   1   12 8                 20
1673017 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
1673038 1673038 MA Suffolk   school 2502790 35   Boston 250279000343 350370 Boston - William Monroe Trotter   Regular School No Elementary PK 08 2021   grade_5 0 20 22 0   0     0   1   19 24 *                     43.0 0 20 22 0   0     0   1   19 24                 43
1673065 1673065 MA Suffolk   school 2502790 35   Boston 250279002669 350376 Boston - King K-8   Regular School No Elementary PK 08 2021   grade_5 2 20 16 1   0     0   3   23 19 *                     42.0 2 20 16 1   0     0   3   23 19                 42
1673071 1673071 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston - Higginson/Lewis K-8   Regular School No Middle 03 08 2021   grade_5 0 9 14 0   0     0   0   10 13 *                     23.0 0 9 14 0   0     0   0   10 13                 23
1673114 1673114 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Boston - Blackstone   Regular School No Elementary PK 05 2021   grade_5 3 14 51 0   0     0   1   38 31 *                     69.0 3 14 51 0   0     0   1   38 31                 69
1673274 1673274 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Boston - Rafael Hernandez   Regular School No Elementary PK 08 2021   grade_5 2 2 34 0   0     0   1   22 17 *                     39.0 2 2 34 0   0     0   1   22 17                 39
1673366 1673366 MA Barnstable   school 2502970 41   Brewster 250297000841 410010 Brewster - Eddy Elementary   Regular School No Elementary 03 05 2021   grade_5 64 3 5 0   0     0   4   40 36 *                     76.0 64 3 5 0   0     0   4   40 36                 76
1673393 1673393 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Brockton - Manthala George Jr. School   Regular School No Elementary KG 05 2021   grade_5 14 40 65 0   0     0   5   56 68 *                     124.0 14 40 65 0   0     0   5   56 68                 124
1673401 1673401 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brockton - Brookfield   Regular School No Elementary KG 05 2021   grade_5 29 61 6 0   0     0   1   48 49 *                     97.0 29 61 6 0   0     0   1   48 49                 97
1673413 1673413 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton - Edgar B Davis   Regular School No Elementary KG 08 2021   grade_5 11 73 15 0   0     0   7   45 61 *                     106.0 11 73 15 0   0     0   7   45 61                 106
1673428 1673428 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Brockton - Gilmore Elementary School   Regular School No Elementary KG 05 2021   grade_5 0 58 21 0   0     0   4   37 46 *                     83.0 0 58 21 0   0     0   4   37 46                 83
1673494 1673494 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield - Brookfield Elementary   Regular School No Elementary PK 06 2021   grade_5 40 0 1 0   0     0   0   19 22 *                     41.0 40 0 1 0   0     0   0   19 22                 41
1673759 1673759 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver - Carver Elementary School   Regular School No Elementary PK 05 2021   grade_5 104 4 3 0   0     0   1   70 42 *                     112.0 104 4 3 0   0     0   1   70 42                 112
1673815 1673815 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 Chelsea - George F. Kelly Elementary   Regular School No Elementary 01 06 2021   grade_5 2 1 27 0   0     0   0   14 16 *                     30.0 2 1 27 0   0     0   0   14 16                 30
1673821 1673821 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Chelsea - Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2021   grade_5 9 6 99 0   0     0   2   57 59 *                     116.0 9 6 99 0   0     0   2   57 59                 116
1673825 1673825 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Chelsea - Clark Avenue School   Regular School No Middle 05 08 2021   grade_5 10 5 159 0   0     0   2   95 81 *                     176.0 10 5 159 0   0     0   2   95 81                 176
1673829 1673829 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Chelsea - Joseph A. Browne School   Regular School No Middle 05 08 2021   grade_5 8 6 83 0   0     0   3   51 49 *                     100.0 8 6 83 0   0     0   3   51 49                 100
1673871 1673871 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Chicopee - Litwin   Regular School No Elementary KG 05 2021   grade_5 58 6 28 0   0     0   2   53 41 *                     94.0 58 6 28 0   0     0   2   53 41                 94
1673883 1673883 MA Hampden   school 2503660 61   Chicopee 250366002463 610050 Chicopee - Fairview Elementary   Regular School No Elementary KG 05 2021   grade_5 19 4 34 0   0     0   4   29 32 *                     61.0 19 4 34 0   0     0   4   29 32                 61
1673895 1673895 MA Hampden   school 2503660 61   Chicopee 250366000500 610090 Chicopee - Gen John J Stefanik   Regular School No Elementary KG 05 2021   grade_5 17 5 54 0   0     0   1   36 41 *                     77.0 17 5 54 0   0     0   1   36 41                 77
1673915 1673915 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg - Clarksburg Elementary   Regular School No Elementary KG 08 2021   grade_5 20 0 1 0   0     0   1   8 14 *                     22.0 20 0 1 0   0     0   1   8 14                 22
1673978 1673978 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway - Conway Grammar   Regular School No Elementary PK 06 2021   grade_5 19 0 0 0   0     0   1   8 12 *                     20.0 19 0 0 0   0     0   1   8 12                 20
1674033 1674033 MA Bristol   school 2504020 72   Dartmouth 250402000542 720030 Dartmouth - George H Potter   Regular School No Elementary PK 05 2021   grade_5 57 0 2 0   0     0   3   40 22 *                     62.0 57 0 2 0   0     0   3   40 22                 62
1674063 1674063 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Dedham - Oakdale   Regular School No Elementary 01 05 2021   grade_5 35 3 7 0   0     0   4   17 32 *                     49.0 35 3 7 0   0     0   4   17 32                 49
1674068 1674068 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Dedham - Riverdale   Regular School No Elementary 01 05 2021   grade_5 25 3 2 0   0     0   2   13 19 *                     32.0 25 3 2 0   0     0   2   13 19                 32
1674083 1674083 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield - Deerfield Elementary   Regular School No Elementary PK 06 2021   grade_5 34 0 2 0   0     0   2   15 23 *                     38.0 34 0 2 0   0     0   2   15 23                 38
1674141 1674141 MA Plymouth   school 2504410 82   Duxbury 250441000968 820004 Duxbury - Alden School   Regular School No Elementary 03 05 2021   grade_5 201 2 8 0   0     0   6   108 109 *                     217.0 201 2 8 0   0     0   6   108 109                 217
1674244 1674244 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown - Edgartown Elementary   Regular School No Elementary PK 08 2021   grade_5 27 1 5 0   0     0   3   15 21 *                     36.0 27 1 5 0   0     0   3   15 21                 36
1674254 1674254 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving - Erving Elementary   Regular School No Elementary PK 06 2021   grade_5 19 0 1 0   0     0   1   12 9 *                     21.0 19 0 1 0   0     0   1   12 9                 21
1674293 1674293 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett - Devens School   Regular School No Other KG 12 2021   grade_5 1 2 2 0   0     0   1   5 1 *                     6.0 1 2 2 0   0     0   1   5 1                 6
1674329 1674329 MA Bristol   school 2504800 94   Fairhaven 250480000640 940010 Fairhaven - East Fairhaven   Regular School No Elementary PK 05 2021   grade_5 57 4 4 1   0     0   2   37 31 *                     68.0 57 4 4 1   0     0   2   37 31                 68
1674388 1674388 MA Bristol   school 2504830 95   Fall River 250483000666 950045 Fall River - John J Doran   Regular School No Elementary PK 08 2021   grade_5 25 7 17 0   0     0   6   30 25 *                     55.0 25 7 17 0   0     0   6   30 25                 55
1674411 1674411 MA Bristol   school 2504830 95   Fall River 250483000665 950140 Fall River - James Tansey   Regular School No Elementary KG 05 2021   grade_5 40 1 3 0   0     0   4   26 22 *                     48.0 40 1 3 0   0     0   4   26 22                 48
1674429 1674429 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River - Stone PK-12 School   Regular School No Other 01 12 2021   grade_5 6 0 0 0   0     0   1   6 1 *                     7.0 6 0 0 0   0     0   1   6 1                 7
1674529 1674529 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida - Abbott Memorial   Regular School No Elementary PK 08 2021   grade_5 6 0 0 0   0     0   0   4 2 *                     6.0 6 0 0 0   0     0   0   4 2                 6
1674588 1674588 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Framingham - Barbieri Elementary   Regular School No Elementary KG 05 2021   grade_5 19 3 77 0   0     0   5   53 50 *                     104.0 19 3 77 0   0     0   5   53 50                 104
1674612 1674612 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Framingham - Woodrow Wilson   Regular School No Elementary KG 05 2021   grade_5 40 7 43 0   0     0   2   40 52 *                     92.0 40 7 43 0   0     0   2   40 52                 92
1674662 1674662 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Franklin - Davis Thayer   Regular School No Elementary KG 05 2021   grade_5 33 0 1 0   0     0   0   16 18 *                     34.0 33 0 1 0   0     0   0   16 18                 34
1674715 1674715 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Gloucester - Beeman Memorial   Regular School No Elementary KG 05 2021   grade_5 36 1 11 0   0     0   1   25 24 *                     49.0 36 1 11 0   0     0   1   25 24                 49
1674721 1674721 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 Gloucester - East Gloucester Elementary   Regular School No Elementary KG 05 2021   grade_5 38 0 3 0   0     0   3   24 20 *                     44.0 38 0 3 0   0     0   3   24 20                 44
1674728 1674728 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Gloucester - Plum Cove School   Regular School No Elementary KG 05 2021   grade_5 30 0 2 0   0     0   1   17 16 *                     33.0 30 0 2 0   0     0   1   17 16                 33
1674734 1674734 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Gloucester - Veterans Memorial   Regular School No Elementary KG 05 2021   grade_5 19 1 14 1   0     1   2   20 18 *                     38.0 19 1 14 1   0     1   2   20 18                 38
1674740 1674740 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 Gloucester - West Parish   Regular School No Elementary KG 05 2021   grade_5 48 1 6 0   0     0   4   31 28 *                     59.0 48 1 6 0   0     0   4   31 28                 59
1674843 1674843 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax - Halifax Elementary   Regular School No Elementary KG 06 2021   grade_5 73 1 4 0   0     0   2   41 39 *                     80.0 73 1 4 0   0     0   2   41 39                 80
1674851 1674851 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock - Hancock Elementary   Regular School No Elementary PK 06 2021   grade_5 6 0 0 0   0     0   0   4 2 *                     6.0 6 0 0 0   0     0   0   4 2                 6
1674935 1674935 MA Essex   school 2505970 128   Haverhill 250597000299 1280067 Haverhill - Silver Hill Elementary School   Regular School No Elementary KG 05 2021   grade_5 63 5 49 0   0     0   1   60 58 *                     118.0 63 5 49 0   0     0   1   60 58                 118
1674945 1674945 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 Haverhill - John G Whittier   Regular School No Middle 05 08 2021   grade_5 68 3 38 2   0     0   2   52 61 *                     113.0 68 3 38 2   0     0   2   52 61                 113
1674949 1674949 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Haverhill - Consentino Middle School   Regular School No Middle 05 08 2021   grade_5 9 0 27 0   0     0   2   21 17 *                     38.0 9 0 27 0   0     0   2   21 17                 38
1674954 1674954 MA Essex   school 2505970 128   Haverhill 250597002906 1280105 Haverhill - Tilton Upper Middle School   Regular School No Middle 04 06 2021   grade_5 36 4 53 0   0     0   0   43 50 *                     93.0 36 4 53 0   0     0   0   43 50                 93
1675040 1675040 MA Hampden   school 2506270 137   Holyoke 250627001178 1370003 Holyoke - Joseph Metcalf School   Regular School No Elementary PK 06 2021   grade_5 11 1 21 0   0     0   1   12 22 *                     34.0 11 1 21 0   0     0   1   12 22                 34
1675048 1675048 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Holyoke - Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2021   grade_5 13 1 14 0   0     0   1   12 17 *                     29.0 13 1 14 0   0     0   1   12 17                 29
1675059 1675059 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 Holyoke - William R. Peck School   Regular School No Middle 04 08 2021   grade_5 2 1 38 0   0     0   0   23 18 *                     41.0 2 1 38 0   0     0   0   23 18                 41
1675076 1675076 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 Holyoke - E N White Elementary   Regular School No Elementary PK 05 2021   grade_5 5 0 43 0   0     0   2   33 17 *                     50.0 5 0 43 0   0     0   2   33 17                 50
1675093 1675093 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Holyoke - Maurice A Donahue Elementary   Regular School No Elementary PK 08 2021   grade_5 7 3 36 0   0     0   1   32 15 *                     47.0 7 3 36 0   0     0   1   32 15                 47
1675116 1675116 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Hopedale - Memorial   Regular School No Elementary KG 06 2021   grade_5 63 2 8 0   0     0   5   38 40 *                     78.0 63 2 8 0   0     0   5   38 40                 78
1675183 1675183 MA Essex   school 2506480 144   Ipswich 250648000936 1440007 Ipswich - Paul F Doyon Memorial   Regular School No Elementary KG 05 2021   grade_5 53 0 5 0   0     0   1   30 29 *                     59.0 53 0 5 0   0     0   1   30 29                 59
1675203 1675203 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston - Kingston Intermediate   Regular School No Elementary 03 06 2021   grade_5 156 0 5 1   0     0   0   89 73 *                     162.0 156 0 5 1   0     0   0   89 73                 162
1675214 1675214 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 Lawrence - South Lawrence East Elementary School   Regular School No Elementary 01 05 2021   grade_5 3 2 143 0   0     0   0   80 68 *                     148.0 3 2 143 0   0     0   0   80 68                 148
1675228 1675228 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Lawrence - Arlington Middle School   Regular School No Middle 05 08 2021   grade_5 4 2 120 0   0     0   0   74 51 *                     126.0 4 2 120 0   0     0   0   74 51                 126
1675257 1675257 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Lawrence - Francis M Leahy   Regular School No Elementary 01 05 2021   grade_5 6 1 94 0   0     0   0   49 52 *                     101.0 6 1 94 0   0     0   0   49 52                 101
1675262 1675262 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Lawrence - Oliver Partnership School   Regular School No Elementary 01 05 2021   grade_5 2 0 86 0   0     0   0   46 42 *                     88.0 2 0 86 0   0     0   0   46 42                 88
1675275 1675275 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 Lawrence - John K Tarbox   Regular School No Elementary 01 05 2021   grade_5 0 0 63 0   0     0   0   40 23 *                     63.0 0 0 63 0   0     0   0   40 23                 63
1675281 1675281 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Lawrence - Emily G Wetherbee   Regular School No Elementary KG 08 2021   grade_5 1 0 70 0   0     0   2   32 41 *                     73.0 1 0 70 0   0     0   2   32 41                 73
1675321 1675321 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee - Lee Elementary   Regular School No Elementary PK 06 2021   grade_5 45 0 2 0   0     0   1   31 17 *                     48.0 45 0 2 0   0     0   1   31 17                 48
1675408 1675408 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett - Leverett Elementary   Regular School No Elementary PK 06 2021   grade_5 14 0 0 0   0     0   1   9 6 *                     15.0 14 0 0 0   0     0   1   9 6                 15
1675794 1675794 MA Essex   school 2507110 163   Lynn 250711001081 1630075 Lynn - Lynn Woods   Regular School No Elementary KG 05 2021   grade_5 15 2 12 1   0     0   2   17 15 *                     32.0 15 2 12 1   0     0   2   17 15                 32
1675946 1675946 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Marblehead - Village School   Regular School No Elementary 03 06 2021   grade_5 155 5 17 0   0     0   13   101 89 *                     190.0 155 5 17 0   0     0   13   101 89                 190
1676007 1676007 MA Plymouth   school 2507350 171   Marshfield 250735000760 1710005 Marshfield - Eames Way School   Regular School No Elementary KG 05 2021   grade_5 36 0 0 0   0     0   1   21 16 *                     37.0 36 0 0 0   0     0   1   21 16                 37

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