enrollments

Data source: Big Local News · About: Big Local

970 rows where grade = "grade_2", state = "MA" and year = 2021 sorted by multiracial_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 970 ✖

grade ✖

  • grade_2 · 970 ✖
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
1673014 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
1673279 1673279 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston - Horace Mann School for the Deaf   Special Education School No Other 01 12 2021   grade_2 * * * *   *     *   *   1 2 *                     3.0                         1 2                 3
1674291 1674291 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett - Devens School   Regular School No Other KG 12 2021   grade_2 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1674752 1674752 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_2 * * * *   *     *   *   * * *                     1.0                                             1
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
1675796 1675796 MA Essex   school 2507110 163   Lynn 250711002527 1630080 Lynn - William R Fallon   Regular School No Elementary 01 05 2021   grade_2 * * * *   *     *   *   3 * *                     5.0                         3                   5
1677739 1677739 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Savoy - Emma L Miller Elementary School   Regular School No Elementary PK 06 2021   grade_2 * * * *   *     *   *   3 1 *                     4.0                         3 1                 4
1678030 1678030 MA Hampden   school 2511130 281   Springfield 251113002723 2810005 Springfield - Springfield Public Day Elementary School   Regular School No Elementary 01 05 2021   grade_2 * * * *   *     *   *   1 2 *                     3.0                         1 2                 3
1672036 1672036 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Agawam - Clifford M Granger   Regular School No Elementary KG 04 2021   grade_2 27 1 8 0   5     0   0   21 20 *                     41.0 27 1 8 0   5     0   0   21 20                 41
1672041 1672041 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Agawam - Benjamin J Phelps   Regular School No Elementary KG 04 2021   grade_2 60 1 2 0   2     0   0   39 26 *                     65.0 60 1 2 0   2     0   0   39 26                 65
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
1672438 1672438 MA Essex   school 2502640 30   Beverly 250264000175 300055 Beverly - Ayers/Ryal Side School   Regular School No Elementary KG 04 2021   grade_2 50 2 6 0   0     0   0   29 29 *                     58.0 50 2 6 0   0     0   0   29 29                 58
1672457 1672457 MA Middlesex   school 2502670 31   Billerica 250267000179 310007 Billerica - Frederick J Dutile   Regular School No Elementary KG 04 2021   grade_2 35 2 3 0   12     0   0   22 30 *                     52.0 35 2 3 0   12     0   0   22 30                 52
1672547 1672547 MA Suffolk   school 2502790 35   Boston 250279002806 350015 Boston - Higginson   Regular School No Elementary PK 02 2021   grade_2 0 18 21 0   0     0   0   22 17 *                     39.0 0 18 21 0   0     0   0   22 17                 39
1672589 1672589 MA Suffolk   school 2502790 35   Boston 250279000218 350062 Boston - Curtis Guild   Regular School No Elementary PK 06 2021   grade_2 8 0 28 0   1     0   0   22 15 *                     37.0 8 0 28 0   1     0   0   22 15                 37
1672605 1672605 MA Suffolk   school 2502790 35   Boston 250279000220 350072 Boston - David A Ellis   Regular School No Elementary PK 05 2021   grade_2 1 13 25 0   0     0   0   20 19 *                     39.0 1 13 25 0   0     0   0   20 19                 39
1672689 1672689 MA Suffolk   school 2502790 35   Boston 250279002569 350138 Boston - O W Holmes   Regular School No Elementary PK 05 2021   grade_2 3 25 20 0   1     0   0   25 24 *                     49.0 3 25 20 0   1     0   0   25 24                 49
1672696 1672696 MA Suffolk   school 2502790 35   Boston 250279000249 350141 Boston - Hugh Roe O'Donnell   Regular School No Elementary PK 06 2021   grade_2 6 0 34 0   0     0   0   18 22 *                     40.0 6 0 34 0   0     0   0   18 22                 40
1672730 1672730 MA Suffolk   school 2502790 35   Boston 250279000257 350156 Boston - James Otis   Regular School No Elementary PK 06 2021   grade_2 17 2 41 1   1     0   0   33 29 *                     62.0 17 2 41 1   1     0   0   33 29                 62
1672745 1672745 MA Suffolk   school 2502790 35   Boston 250279000268 350167 Boston - UP Academy Holland   Regular School No Elementary PK 05 2021   grade_2 1 61 53 2   3     0   0   54 66 *                     120.0 1 61 53 2   3     0   0   54 66                 120
1672848 1672848 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Boston - Michael J Perkins   Regular School No Elementary PK 06 2021   grade_2 2 10 10 0   2     0   0   7 17 *                     24.0 2 10 10 0   2     0   0   7 17                 24
1672873 1672873 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Boston - Nathan Hale   Regular School No Elementary PK 06 2021   grade_2 2 9 7 0   4     0   0   8 14 *                     22.0 2 9 7 0   4     0   0   8 14                 22
1672927 1672927 MA Suffolk   school 2502790 35   Boston 250279000304 350268 Boston - Paul A Dever   Regular School No Elementary PK 05 2021   grade_2 4 18 36 1   3     0   0   37 25 *                     62.0 4 18 36 1   3     0   0   37 25                 62
1672948 1672948 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Boston - Roger Clap   Regular School No Elementary PK 06 2021   grade_2 1 6 8 0   2     0   0   8 9 *                     17.0 1 6 8 0   2     0   0   8 9                 17
1672956 1672956 MA Suffolk   school 2502790 35   Boston 250279000321 350302 Boston - Samuel Adams   Regular School No Elementary PK 06 2021   grade_2 11 1 28 0   3     0   0   22 21 *                     43.0 11 1 28 0   3     0   0   22 21                 43
1672964 1672964 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Boston - Samuel W Mason   Regular School No Elementary PK 05 2021   grade_2 2 25 12 0   0     0   0   20 18 *                     39.0 2 25 12 0   0     0   0   20 18                 39
1673028 1673028 MA Suffolk   school 2502790 35   Boston 250279000337 350366 Boston - William E Russell   Regular School No Elementary PK 05 2021   grade_2 2 19 37 0   6     0   0   34 30 *                     64.0 2 19 37 0   6     0   0   34 30                 64
1673078 1673078 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Boston - Mildred Avenue K-8   Regular School No Elementary PK 08 2021   grade_2 1 27 11 0   1     0   0   20 20 *                     40.0 1 27 11 0   1     0   0   20 20                 40
1673250 1673250 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Boston - Mario Umana Academy   Regular School No Elementary PK 08 2021   grade_2 5 3 54 0   0     0   0   37 25 *                     62.0 5 3 54 0   0     0   0   37 25                 62
1673271 1673271 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Boston - Rafael Hernandez   Regular School No Elementary PK 08 2021   grade_2 3 2 42 0   0     0   0   25 22 *                     47.0 3 2 42 0   0     0   0   25 22                 47
1673324 1673324 MA Norfolk   school 2502940 40   Braintree 250294000365 400015 Braintree - Highlands   Regular School No Elementary KG 05 2021   grade_2 52 2 3 0   15     0   0   38 34 *                     72.0 52 2 3 0   15     0   0   38 34                 72
1673340 1673340 MA Norfolk   school 2502940 40   Braintree 250294000360 400033 Braintree - Archie T Morrison   Regular School No Elementary KG 05 2021   grade_2 54 8 4 0   18     0   0   35 49 *                     84.0 54 8 4 0   18     0   0   35 49                 84
1673345 1673345 MA Norfolk   school 2502940 40   Braintree 250294000363 400050 Braintree - Donald Ross   Regular School No Elementary KG 05 2021   grade_2 25 3 2 0   23     0   0   23 30 *                     53.0 25 3 2 0   23     0   0   23 30                 53
1673370 1673370 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield - Brimfield Elementary   Regular School No Elementary PK 06 2021   grade_2 25 0 1 0   0     0   0   16 10 *                     26.0 25 0 1 0   0     0   0   16 10                 26
1673437 1673437 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Brockton - Oscar F Raymond   Regular School No Elementary KG 05 2021   grade_2 8 89 18 0   0     0   0   61 54 *                     115.0 8 89 18 0   0     0   0   61 54                 115
1673491 1673491 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield - Brookfield Elementary   Regular School No Elementary PK 06 2021   grade_2 33 0 2 0   0     0   0   20 15 *                     35.0 33 0 2 0   0     0   0   20 15                 35
1673812 1673812 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 Chelsea - George F. Kelly Elementary   Regular School No Elementary 01 06 2021   grade_2 6 4 102 0   0     0   0   55 57 *                     112.0 6 4 102 0   0     0   0   55 57                 112
1673818 1673818 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Chelsea - Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2021   grade_2 11 3 113 0   1     0   0   61 67 *                     128.0 11 3 113 0   1     0   0   61 67                 128
1673859 1673859 MA Hampden   school 2503660 61   Chicopee 250366000493 610020 Chicopee - Bowie   Regular School No Elementary KG 05 2021   grade_2 28 2 8 0   3     0   0   19 22 *                     41.0 28 2 8 0   3     0   0   19 22                 41
1673868 1673868 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Chicopee - Litwin   Regular School No Elementary KG 05 2021   grade_2 16 0 3 0   0     0   0   5 14 *                     19.0 16 0 3 0   0     0   0   5 14                 19
1673912 1673912 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg - Clarksburg Elementary   Regular School No Elementary KG 08 2021   grade_2 18 0 2 0   0     0   0   10 10 *                     20.0 18 0 2 0   0     0   0   10 10                 20
1673940 1673940 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Cohasset - Joseph Osgood   Regular School No Elementary PK 02 2021   grade_2 97 4 1 0   1     0   0   47 56 *                     103.0 97 4 1 0   1     0   0   47 56                 103
1673975 1673975 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway - Conway Grammar   Regular School No Elementary PK 06 2021   grade_2 16 1 0 0   0     0   0   4 13 *                     17.0 16 1 0 0   0     0   0   4 13                 17
1674008 1674008 MA Essex   school 2503990 71   Danvers 250399000538 710045 Danvers - Willis E Thorpe   Regular School No Elementary PK 05 2021   grade_2 38 0 2 0   1     0   0   20 21 *                     41.0 38 0 2 0   1     0   0   20 21                 41
1674115 1674115 MA Middlesex   school 2504320 79   Dracut 250432000582 790030 Dracut - Greenmont Avenue   Regular School No Elementary KG 05 2021   grade_2 30 2 7 0   5     0   0   25 19 *                     44.0 30 2 7 0   5     0   0   25 19                 44
1674121 1674121 MA Middlesex   school 2504320 79   Dracut 250432000578 790035 Dracut - Brookside Elementary   Regular School No Elementary KG 05 2021   grade_2 58 7 12 0   6     0   0   40 43 *                     83.0 58 7 12 0   6     0   0   40 43                 83
1674182 1674182 MA Hampshire   school 2504590 86   Easthampton 250459000613 860010 Easthampton - Maple   Regular School No Elementary PK 04 2021   grade_2 37 0 3 0   1     0   0   22 19 *                     41.0 37 0 3 0   1     0   0   22 19                 41
1674187 1674187 MA Hampshire   school 2504590 86   Easthampton 250459002466 860020 Easthampton - Neil A Pepin   Regular School No Elementary KG 04 2021   grade_2 24 0 11 0   1     0   0   15 21 *                     36.0 24 0 11 0   1     0   0   15 21                 36
1674269 1674269 MA Middlesex   school 2504770 93   Everett 250477002118 930015 Everett - Webster School   Regular School No Elementary PK 05 2021   grade_2 20 10 33 0   2     0   0   29 36 *                     65.0 20 10 33 0   2     0   0   29 36                 65
1674284 1674284 MA Middlesex   school 2504770 93   Everett 250477002038 930028 Everett - George Keverian School   Regular School No Elementary KG 08 2021   grade_2 8 13 53 0   3     0   0   42 35 *                     77.0 8 13 53 0   3     0   0   42 35                 77
1674303 1674303 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Everett - Lafayette School   Regular School No Elementary KG 08 2021   grade_2 13 21 54 0   8     0   0   56 40 *                     96.0 13 21 54 0   8     0   0   56 40                 96
1674312 1674312 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Everett - Parlin School   Regular School No Elementary KG 08 2021   grade_2 9 14 79 0   3     0   0   44 61 *                     105.0 9 14 79 0   3     0   0   44 61                 105
1674526 1674526 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida - Abbott Memorial   Regular School No Elementary PK 08 2021   grade_2 8 0 0 0   0     0   0   4 4 *                     8.0 8 0 0 0   0     0   0   4 4                 8
1674635 1674635 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Franklin - Helen Keller Elementary   Regular School No Elementary KG 05 2021   grade_2 46 2 1 0   1     0   0   27 23 *                     50.0 46 2 1 0   1     0   0   27 23                 50
1674641 1674641 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 Franklin - J F Kennedy Memorial   Regular School No Elementary KG 05 2021   grade_2 48 0 2 0   2     2   0   28 26 *                     54.0 48 0 2 0   2     2   0   28 26                 54
1674653 1674653 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Franklin - Parmenter   Regular School No Elementary KG 05 2021   grade_2 42 2 7 0   2     0   0   27 26 *                     53.0 42 2 7 0   2     0   0   27 26                 53
1674659 1674659 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Franklin - Davis Thayer   Regular School No Elementary KG 05 2021   grade_2 38 0 2 0   2     2   0   21 23 *                     44.0 38 0 2 0   2     2   0   21 23                 44
1674718 1674718 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 Gloucester - East Gloucester Elementary   Regular School No Elementary KG 05 2021   grade_2 30 0 5 0   1     0   0   19 17 *                     36.0 30 0 5 0   1     0   0   19 17                 36
1674770 1674770 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 Grafton - North Street Elementary School   Regular School No Elementary 02 06 2021   grade_2 74 2 3 0   19     0   0   51 47 *                     98.0 74 2 3 0   19     0   0   51 47                 98
1674803 1674803 MA Franklin   school 2505490 114   Greenfield 250549002577 1140010 Greenfield - Federal Street School   Regular School No Elementary KG 04 2021   grade_2 29 1 10 0   3     0   0   19 24 *                     43.0 29 1 10 0   3     0   0   19 24                 43
1674808 1674808 MA Franklin   school 2505490 114   Greenfield 250549000798 1140025 Greenfield - Discovery School at Four Corners   Regular School No Elementary KG 04 2021   grade_2 29 0 2 1   2     0   0   14 20 *                     34.0 29 0 2 1   2     0   0   14 20                 34
1674827 1674827 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley - Hadley Elementary   Regular School No Elementary PK 06 2021   grade_2 28 1 4 0   2     0   0   16 19 *                     35.0 28 1 4 0   2     0   0   16 19                 35
1674848 1674848 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock - Hancock Elementary   Regular School No Elementary PK 06 2021   grade_2 6 1 0 0   0     0   0   4 3 *                     7.0 6 1 0 0   0     0   0   4 3                 7
1674885 1674885 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield - Hatfield Elementary   Regular School No Elementary PK 06 2021   grade_2 31 1 1 0   0     0   0   13 20 *                     33.0 31 1 1 0   0     0   0   13 20                 33
1674985 1674985 MA Plymouth   school 2506090 131   Hingham 250609000874 1310020 Hingham - South Elementary   Regular School No Elementary KG 05 2021   grade_2 79 1 2 0   5     0   0   46 41 *                     87.0 79 1 2 0   5     0   0   46 41                 87
1675015 1675015 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland - Holland Elementary   Regular School No Elementary PK 06 2021   grade_2 25 0 1 0   0     0   0   12 14 *                     26.0 25 0 1 0   0     0   0   12 14                 26
1675045 1675045 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Holyoke - Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2021   grade_2 9 0 18 0   0     0   0   14 13 *                     27.0 9 0 18 0   0     0   0   14 13                 27
1675055 1675055 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Holyoke - Morgan Full Service Community School   Regular School No Elementary PK 04 2021   grade_2 0 2 39 0   0     0   0   14 27 *                     41.0 0 2 39 0   0     0   0   14 27                 41
1675073 1675073 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 Holyoke - E N White Elementary   Regular School No Elementary PK 05 2021   grade_2 15 3 50 0   1     0   0   33 36 *                     69.0 15 3 50 0   1     0   0   33 36                 69
1675142 1675142 MA Middlesex   school 2506390 141   Hudson 250639000924 1410007 Hudson - Mulready Elementary   Regular School No Elementary PK 04 2021   grade_2 40 1 6 0   1     0   0   22 26 *                     48.0 40 1 6 0   1     0   0   22 26                 48
1675217 1675217 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Lawrence - Community Day Arlington   Regular School No Elementary KG 04 2021   grade_2 5 1 112 0   0     0   0   60 58 *                     118.0 5 1 112 0   0     0   0   60 58                 118
1675234 1675234 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Lawrence - Robert Frost   Regular School No Elementary KG 04 2021   grade_2 5 3 110 0   6     0   0   63 59 *                     124.0 5 3 110 0   6     0   0   63 59                 124
1675240 1675240 MA Essex   school 2506660 149   Lawrence 250666000958 1490020 Lawrence - James F Hennessey   Regular School No Elementary PK 02 2021   grade_2 7 2 68 0   1     0   0   39 38 *                     78.0 7 2 68 0   1     0   0   39 38                 78
1675242 1675242 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Lawrence - Gerard A. Guilmette   Regular School No Elementary 01 04 2021   grade_2 2 2 106 0   1     0   0   63 48 *                     111.0 2 2 106 0   1     0   0   63 48                 111
1675254 1675254 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Lawrence - Francis M Leahy   Regular School No Elementary 01 05 2021   grade_2 3 1 72 0   0     0   0   42 33 *                     76.0 3 1 72 0   0     0   0   42 33                 76
1675259 1675259 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Lawrence - Oliver Partnership School   Regular School No Elementary 01 05 2021   grade_2 1 0 87 0   1     0   0   49 40 *                     89.0 1 0 87 0   1     0   0   49 40                 89
1675268 1675268 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Lawrence - Edward F. Parthum   Regular School No Elementary KG 04 2021   grade_2 2 1 141 0   0     0   0   81 62 *                     144.0 2 1 141 0   0     0   0   81 62                 144
1675272 1675272 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 Lawrence - John K Tarbox   Regular School No Elementary 01 05 2021   grade_2 2 0 57 0   0     0   0   34 25 *                     59.0 2 0 57 0   0     0   0   34 25                 59
1675278 1675278 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Lawrence - Emily G Wetherbee   Regular School No Elementary KG 08 2021   grade_2 2 1 60 0   0     0   0   35 28 *                     63.0 2 1 60 0   0     0   0   35 28                 63
1675303 1675303 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence - School for Exceptional Studies   Regular School No Other KG 12 2021   grade_2 1 0 5 0   0     0   0   5 1 *                     6.0 1 0 5 0   0     0   0   5 1                 6
1675509 1675509 MA Hampden   school 2506990 159   Longmeadow 250699001022 1590025 Longmeadow - Wolf Swamp Road   Regular School No Elementary PK 05 2021   grade_2 54 3 6 0   2     0   0   34 31 *                     65.0 54 3 6 0   2     0   0   34 31                 65
1675619 1675619 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Lowell - Bartlett Community Partnership   Regular School No Elementary PK 08 2021   grade_2 6 2 11 0   27     0   0   21 25 *                     46.0 6 2 11 0   27     0   0   21 25                 46
1675728 1675728 MA Essex   school 2507110 163   Lynn 250711001062 1630016 Lynn - A Drewicz Elementary   Regular School No Elementary PK 05 2021   grade_2 7 0 52 0   11     0   0   34 36 *                     70.0 7 0 52 0   11     0   0   34 36                 70
1675878 1675878 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Malden - Beebe   Regular School No Elementary KG 08 2021   grade_2 45 10 21 0   41     0   0   58 59 *                     117.0 45 10 21 0   41     0   0   58 59                 117
1675990 1675990 MA Middlesex   school 2507320 170   Marlborough 250732001631 1700030 Marlborough - Charles Jaworek School   Regular School No Elementary KG 05 2021   grade_2 48 3 55 1   12     0   0   43 76 *                     119.0 48 3 55 1   12     0   0   43 76                 119
1676004 1676004 MA Plymouth   school 2507350 171   Marshfield 250735000760 1710005 Marshfield - Eames Way School   Regular School No Elementary KG 05 2021   grade_2 32 0 1 0   0     0   0   15 18 *                     33.0 32 0 1 0   0     0   0   15 18                 33
1676030 1676030 MA Plymouth   school 2507350 171   Marshfield 250735001139 1710025 Marshfield - Martinson Elementary   Regular School No Elementary PK 05 2021   grade_2 49 1 2 0   1     0   0   28 25 *                     53.0 49 1 2 0   1     0   0   28 25                 53
1676095 1676095 MA Middlesex   school 2507560 176   Medford 250756001634 1760068 Medford - John J McGlynn Elementary School   Regular School No Elementary PK 05 2021   grade_2 27 10 15 2   9     0   0   27 36 *                     63.0 27 10 15 2   9     0   0   27 36                 63
1676220 1676220 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Methuen - Donald P Timony Grammar   Regular School No Elementary PK 08 2021   grade_2 47 15 63 0   5     0   0   67 63 *                     130.0 47 15 63 0   5     0   0   67 63                 130
1676342 1676342 MA Hampden   school 2508040 191   Monson 250804002903 1910030 Monson - Granite Valley School   Regular School No Elementary 01 06 2021   grade_2 64 0 3 0   1     0   0   26 42 *                     68.0 64 0 3 0   1     0   0   26 42                 68
1676357 1676357 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Nahant - Johnson   Regular School No Elementary PK 06 2021   grade_2 14 0 0 0   0     0   0   11 3 *                     14.0 14 0 0 0   0     0   0   11 3                 14
1676492 1676492 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 New Bedford - Alfred J Gomes   Regular School No Elementary KG 05 2021   grade_2 13 8 58 1   1     0   0   35 46 *                     81.0 13 8 58 1   1     0   0   35 46                 81
1676815 1676815 MA Essex   school 2508700 211   North Andover 250870001396 2110015 North Andover - Kittredge   Regular School No Elementary 01 05 2021   grade_2 37 1 5 0   1     0   0   29 15 *                     44.0 37 1 5 0   1     0   0   29 15                 44
1676856 1676856 MA Bristol   school 2508730 212   North Attleborough 250873001408 2120015 North Attleborough - Roosevelt Avenue   Regular School No Elementary KG 05 2021   grade_2 28 3 0 0   0     0   0   12 19 *                     31.0 28 3 0 0   0     0   0   12 19                 31
1676876 1676876 MA Worcester   school 2508880 213   Northborough 250888001437 2130003 Northborough - Lincoln Street   Regular School No Elementary KG 05 2021   grade_2 35 0 0 0   4     1   0   21 19 *                     40.0 35 0 0 0   4     1   0   21 19                 40
1676918 1676918 MA Worcester   school 2508760 215   North Brookfield 250876001410 2150015 North Brookfield - North Brookfield Elementary   Regular School No Elementary PK 06 2021   grade_2 26 1 3 0   0     0   0   16 14 *                     30.0 26 1 3 0   0     0   0   16 14                 30
1676997 1676997 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Norwood - Balch   Regular School No Elementary 01 05 2021   grade_2 23 5 19 0   6     2   0   28 27 *                     55.0 23 5 19 0   6     2   0   28 27                 55
1677012 1677012 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 Norwood - John P Oldham   Regular School No Elementary 01 05 2021   grade_2 35 7 7 0   2     1   0   24 28 *                     52.0 35 7 7 0   2     1   0   24 28                 52
1677018 1677018 MA Norfolk   school 2509060 220   Norwood 250906001461 2200025 Norwood - Charles J Prescott   Regular School No Elementary KG 05 2021   grade_2 14 4 4 1   26     1   0   27 23 *                     50.0 14 4 4 1   26     1   0   27 23                 50
1677052 1677052 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans - Orleans Elementary   Regular School No Elementary KG 05 2021   grade_2 24 1 3 1   0     0   0   15 14 *                     29.0 24 1 3 1   0     0   0   15 14                 29

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