enrollments

Data source: Big Local News · About: Big Local

975 rows where grade = "grade_2", state = "MA" and year = 2019 sorted by asian_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 975 ✖

grade ✖

  • grade_2 · 975 ✖
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
2040875 2040875 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Middle 02 08 2019   grade_2 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2042766 2042766 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_2 * * * *   *     *   *   2 *                       2.0                         2                   2
2043450 2043450 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 02 08 2019   grade_2 * * * *   *     *   *   1 *                       1.0                         1                   1
2048832 2048832 MA Franklin   school 2509600 750   Pioneer Valley 250960002613 7500007 Pearl E Rhodes Elementary   Regular School No Elementary PK 04 2019   grade_2 * * * *   *     *   *   2 3                       5.0                         2 3                 5
2039828 2039828 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2019   grade_2 71 1 4 1   0     0   3   40 40                       80.0 71 1 4 1   0     0   3   40 40                 80
2039838 2039838 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2019   grade_2 60 2 3 0   0     1   1   30 37                       67.0 60 2 3 0   0     1   1   30 37                 67
2040164 2040164 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No Elementary KG 03 2019   grade_2 71 2 5 0   0     4   2   47 37                       84.0 71 2 5 0   0     4   2   47 37                 84
2040212 2040212 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No Elementary PK 04 2019   grade_2 88 0 1 0   0     0   2   51 40                       91.0 88 0 1 0   0     0   2   51 40                 91
2040239 2040239 MA Essex   school 2502640 30   Beverly 250264000169 300033 Hannah Elementary   Regular School No Elementary KG 04 2019   grade_2 45 1 11 0   0     0   8   31 34                       65.0 45 1 11 0   0     0   8   31 34                 65
2040332 2040332 MA Suffolk   school 2502790 35   Boston 250279001115 350008 Dr. Catherine Ellison-Rosa Parks Early Ed School   Regular School No Elementary PK 03 2019   grade_2 1 16 18 0   0     0   1   22 14                       36.0 1 16 18 0   0     0   1   22 14                 36
2040363 2040363 MA Suffolk   school 2502790 35   Boston 250279002839 350014 Pauline Agassiz Shaw Elementary School   Regular School No Elementary PK 03 2019   grade_2 0 28 10 0   0     0   2   18 22                       40.0 0 28 10 0   0     0   2   18 22                 40
2040376 2040376 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2019   grade_2 34 13 35 0   0     0   5   38 49                       87.0 34 13 35 0   0     0   5   38 49                 87
2040396 2040396 MA Suffolk   school 2502790 35   Boston 250279000214 350052 Charles Sumner   Regular School No Elementary PK 05 2019   grade_2 13 14 49 0   0     0   10   48 38                       86.0 13 14 49 0   0     0   10   48 38                 86
2040410 2040410 MA Suffolk   school 2502790 35   Boston 250279000218 350062 Curtis Guild   Regular School No Elementary PK 05 2019   grade_2 6 1 24 0   0     0   1   21 11                       32.0 6 1 24 0   0     0   1   21 11                 32
2040417 2040417 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No Elementary PK 06 2019   grade_2 6 0 7 0   0     0   0   6 7                       13.0 6 0 7 0   0     0   0   6 7                 13
2040424 2040424 MA Suffolk   school 2502790 35   Boston 250279000220 350072 David A Ellis   Regular School No Elementary PK 05 2019   grade_2 0 36 35 0   0     0   1   32 40                       72.0 0 36 35 0   0     0   1   32 40                 72
2040438 2040438 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2019   grade_2 11 11 15 0   0     0   3   21 19                       40.0 11 11 15 0   0     0   3   21 19                 40
2040475 2040475 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No Elementary PK 05 2019   grade_2 16 12 11 0   0     0   3   27 15                       42.0 16 12 11 0   0     0   3   27 15                 42
2040492 2040492 MA Suffolk   school 2502790 35   Boston 250279000241 350122 George H Conley   Regular School No Elementary PK 05 2019   grade_2 6 9 10 0   0     0   0   16 9                       25.0 6 9 10 0   0     0   0   16 9                 25
2040506 2040506 MA Suffolk   school 2502790 35   Boston 250279002569 350138 O W Holmes   Regular School No Elementary PK 05 2019   grade_2 0 28 19 0   0     0   2   27 22                       49.0 0 28 19 0   0     0   2   27 22                 49
2040567 2040567 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No Elementary PK 05 2019   grade_2 7 10 6 0   0     0   0   9 14                       23.0 7 10 6 0   0     0   0   9 14                 23
2040577 2040577 MA Suffolk   school 2502790 35   Boston 250279000270 350180 John Winthrop   Regular School No Elementary PK 05 2019   grade_2 2 33 17 0   0     1   2   21 34                       55.0 2 33 17 0   0     1   2   21 34                 55
2040635 2040635 MA Suffolk   school 2502790 35   Boston 250279000283 350215 Manassah E Bradley   Regular School No Elementary PK 05 2019   grade_2 17 4 21 0   0     0   0   26 16                       42.0 17 4 21 0   0     0   0   26 16                 42
2040649 2040649 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2019   grade_2 0 16 41 0   0     0   1   27 31                       58.0 0 16 41 0   0     0   1   27 31                 58
2040690 2040690 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2019   grade_2 17 6 3 0   0     0   0   13 13                       26.0 17 6 3 0   0     0   0   13 13                 26
2040757 2040757 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Roger Clap   Regular School No Elementary PK 05 2019   grade_2 3 12 5 0   0     0   0   7 13                       20.0 3 12 5 0   0     0   0   7 13                 20
2040771 2040771 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Samuel W Mason   Regular School No Elementary PK 05 2019   grade_2 3 14 16 0   0     0   4   19 18                       37.0 3 14 16 0   0     0   4   19 18                 37
2040778 2040778 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2019   grade_2 0 6 38 0   0     0   2   19 27                       46.0 0 6 38 0   0     0   2   19 27                 46
2040788 2040788 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No Elementary PK 08 2019   grade_2 4 4 31 0   0     0   1   16 24                       40.0 4 4 31 0   0     0   1   16 24                 40
2040819 2040819 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_2 3 1 3 0   0     0   1   7 1                       8.0 3 1 3 0   0     0   1   7 1                 8
2040841 2040841 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2019   grade_2 0 40 20 1   0     0   3   29 35                       64.0 0 40 20 1   0     0   3   29 35                 64
2040868 2040868 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2019   grade_2 2 31 20 1   0     0   1   27 28                       55.0 2 31 20 1   0     0   1   27 28                 55
2040885 2040885 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2019   grade_2 2 27 9 0   0     0   3   16 25                       41.0 2 27 9 0   0     0   3   16 25                 41
2040895 2040895 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2019   grade_2 0 27 32 0   0     0   1   29 31                       60.0 0 27 32 0   0     0   1   29 31                 60
2040905 2040905 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2019   grade_2 17 7 9 0   0     0   0   17 16                       33.0 17 7 9 0   0     0   0   17 16                 33
2041097 2041097 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2019   grade_2 3 1 2 0   0     0   0   5 1                       6.0 3 1 2 0   0     0   0   5 1                 6
2041114 2041114 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No Elementary PK 04 2019   grade_2 63 0 2 2   0     0   1   31 37                       68.0 63 0 2 2   0     0   1   31 37                 68
2041197 2041197 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No Elementary PK 02 2019   grade_2 68 3 5 0   0     0   5   40 41                       81.0 68 3 5 0   0     0   5   40 41                 81
2041212 2041212 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No Elementary PK 05 2019   grade_2 10 78 21 0   0     0   12   69 52                       121.0 10 78 21 0   0     0   12   69 52                 121
2041218 2041218 MA Plymouth   school 2503090 44   Brockton 250309002649 440002 Mary E. Baker School   Regular School No Elementary KG 05 2019   grade_2 45 68 21 0   0     0   7   77 64                       141.0 45 68 21 0   0     0   7   77 64                 141
2041258 2041258 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Gilmore Elementary School   Regular School No Elementary KG 05 2019   grade_2 5 78 11 1   0     0   4   49 50                       99.0 5 78 11 1   0     0   4   49 50                 99
2041328 2041328 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2019   grade_2 35 0 3 0   0     0   1   23 16                       39.0 35 0 3 0   0     0   1   23 16                 39
2041460 2041460 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2019   grade_2 19 4 17 0   0     0   3   18 25                       43.0 19 4 17 0   0     0   3   18 25                 43
2041594 2041594 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver Elementary School   Regular School No Elementary PK 05 2019   grade_2 131 2 1 0   0     0   2   64 72                       136.0 131 2 1 0   0     0   2   64 72                 136
2041643 2041643 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No Elementary 01 04 2019   grade_2 9 8 114 0   0     0   0   70 61                       131.0 9 8 114 0   0     0   0   70 61                 131
2041647 2041647 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No Elementary 01 04 2019   grade_2 16 10 119 1   0     0   1   73 74                       147.0 16 10 119 1   0     0   1   73 74                 147
2041651 2041651 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 05 2019   grade_2 3 5 101 0   0     0   1   55 55                       110.0 3 5 101 0   0     0   1   55 55                 110
2041683 2041683 MA Hampden   school 2503660 61   Chicopee 250366000489 610003 Barry   Regular School No Elementary KG 05 2019   grade_2 49 2 22 0   0     0   1   48 26                       74.0 49 2 22 0   0     0   1   48 26                 74
2041698 2041698 MA Hampden   school 2503660 61   Chicopee 250366000493 610020 Bowie   Regular School No Elementary KG 05 2019   grade_2 39 3 10 0   0     0   0   26 26                       52.0 39 3 10 0   0     0   0   26 26                 52
2041710 2041710 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No Elementary KG 05 2019   grade_2 22 1 6 0   0     0   0   15 14                       29.0 22 1 6 0   0     0   0   15 14                 29
2041734 2041734 MA Hampden   school 2503660 61   Chicopee 250366000500 610090 Gen John J Stefanik   Regular School No Elementary KG 05 2019   grade_2 20 8 35 0   0     0   0   35 28                       63.0 20 8 35 0   0     0   0   35 28                 63
2041754 2041754 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2019   grade_2 14 0 0 0   0     0   0   7 7                       14.0 14 0 0 0   0     0   0   7 7                 14
2041817 2041817 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No Elementary PK 06 2019   grade_2 13 0 2 0   0     0   0   10 5                       15.0 13 0 2 0   0     0   0   10 5                 15
2041830 2041830 MA Essex   school 2503990 71   Danvers 250399000531 710015 Great Oak   Regular School No Elementary KG 05 2019   grade_2 49 1 3 0   0     0   4   26 31                       57.0 49 1 3 0   0     0   4   26 31                 57
2041871 2041871 MA Bristol   school 2504020 72   Dartmouth 250402000542 720030 George H Potter   Regular School No Elementary PK 05 2019   grade_2 59 0 3 0   0     0   1   31 32                       63.0 59 0 3 0   0     0   1   31 32                 63
2041891 2041891 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No Elementary 01 05 2019   grade_2 28 9 26 1   0     0   6   32 38                       70.0 28 9 26 1   0     0   6   32 38                 70
2041906 2041906 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No Elementary 01 05 2019   grade_2 20 3 7 0   0     0   3   18 15                       33.0 20 3 7 0   0     0   3   18 15                 33
2041928 2041928 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas Elementary School   Regular School No Elementary 02 05 2019   grade_2 83 0 2 0   0     0   4   50 39                       89.0 83 0 2 0   0     0   4   50 39                 89
2042017 2042017 MA Hampshire   school 2504590 86   Easthampton 250459000611 860005 Center School   Regular School No Elementary KG 04 2019   grade_2 32 0 3 0   0     0   3   19 19                       38.0 32 0 3 0   0     0   3   19 19                 38
2042084 2042084 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No Elementary PK 08 2019   grade_2 29 0 9 1   0     0   2   19 22                       41.0 29 0 9 1   0     0   2   19 22                 41
2042094 2042094 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No Elementary PK 06 2019   grade_2 9 0 0 0   0     0   3   8 4                       12.0 9 0 0 0   0     0   3   8 4                 12
2042168 2042168 MA Bristol   school 2504800 94   Fairhaven 250480000640 940010 East Fairhaven   Regular School No Elementary PK 05 2019   grade_2 61 0 4 1   0     0   2   31 37                       68.0 61 0 4 1   0     0   2   31 37                 68
2042217 2042217 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No Elementary PK 08 2019   grade_2 43 9 26 0   0     0   8   43 43                       86.0 43 9 26 0   0     0   8   43 43                 86
2042227 2042227 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No Elementary PK 08 2019   grade_2 23 4 19 0   0     0   5   24 27                       51.0 23 4 19 0   0     0   5   24 27                 51
2042249 2042249 MA Bristol   school 2504830 95   Fall River 250483000665 950140 James Tansey   Regular School No Elementary KG 05 2019   grade_2 48 1 3 0   0     0   4   23 33                       56.0 48 1 3 0   0     0   4   23 33                 56
2042286 2042286 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No Elementary KG 04 2019   grade_2 33 2 2 3   0     0   4   26 18                       44.0 33 2 2 3   0     0   4   26 18                 44
2042292 2042292 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No Elementary PK 04 2019   grade_2 33 8 3 1   0     0   8   26 27                       53.0 33 8 3 1   0     0   8   26 27                 53
2042364 2042364 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_2 8 0 0 0   0     0   0   3 5                       8.0 8 0 0 0   0     0   0   3 5                 8
2042384 2042384 MA Norfolk   school 2504950 99   Foxborough 250495000864 990050 Charles Taylor Elementary   Regular School No Elementary KG 04 2019   grade_2 44 2 4 0   0     1   2   28 25                       53.0 44 2 4 0   0     1   2   28 25                 53
2042422 2042422 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2019   grade_2 19 7 74 0   0     0   4   46 58                       104.0 19 7 74 0   0     0   4   46 58                 104
2042440 2042440 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No Elementary KG 05 2019   grade_2 38 14 28 0   0     0   3   36 47                       83.0 38 14 28 0   0     0   3   36 47                 83
2042446 2042446 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2019   grade_2 59 8 21 1   0     0   1   43 47                       90.0 59 8 21 1   0     0   1   43 47                 90
2042466 2042466 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Jefferson Elementary   Regular School No Elementary KG 05 2019   grade_2 39 0 2 0   0     1   2   27 17                       44.0 39 0 2 0   0     1   2   27 17                 44
2042472 2042472 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No Elementary KG 05 2019   grade_2 59 1 1 0   0     1   4   34 32                       66.0 59 1 1 0   0     1   4   34 32                 66
2042536 2042536 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2019   grade_2 85 0 2 0   0     0   3   44 46                       90.0 85 0 2 0   0     0   3   44 46                 90
2042549 2042549 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No Elementary KG 05 2019   grade_2 52 0 7 0   0     0   1   31 29                       60.0 52 0 7 0   0     0   1   31 29                 60
2042555 2042555 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No Elementary KG 05 2019   grade_2 22 0 1 0   0     0   1   12 12                       24.0 22 0 1 0   0     0   1   12 12                 24
2042626 2042626 MA Franklin   school 2505490 114   Greenfield 250549002577 1140010 Federal Street School   Regular School No Elementary KG 04 2019   grade_2 42 1 9 0   0     0   3   28 27                       55.0 42 1 9 0   0     0   3   28 27                 55
2042631 2042631 MA Franklin   school 2505490 114   Greenfield 250549000798 1140025 Discovery School at Four Corners   Regular School No Elementary KG 04 2019   grade_2 41 1 6 0   0     0   0   28 20                       48.0 41 1 6 0   0     0   0   28 20                 48
2042636 2042636 MA Franklin   school 2505490 114   Greenfield 250549002578 1140035 Newton School   Regular School No Elementary KG 04 2019   grade_2 22 4 15 0   0     0   1   25 17                       42.0 22 4 15 0   0     0   1   25 17                 42
2042665 2042665 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No Elementary KG 06 2019   grade_2 92 2 4 0   0     0   1   50 49                       99.0 92 2 4 0   0     0   1   50 49                 99
2042712 2042712 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2019   grade_2 29 0 2 0   0     0   1   18 13                       32.0 29 0 2 0   0     0   1   18 13                 32
2042725 2042725 MA Essex   school 2505970 128   Haverhill 250597002769 1280005 Consentino Annex at Bartlett School   Regular School No Elementary KG 02 2019   grade_2 8 0 27 0   0     0   5   22 18                       40.0 8 0 27 0   0     0   5   22 18                 40
2042728 2042728 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Bradford Elementary   Regular School No Elementary KG 04 2019   grade_2 44 4 8 0   0     0   1   26 31                       57.0 44 4 8 0   0     0   1   26 31                 57
2042739 2042739 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Caleb Dustin Hunking School   Regular School No Elementary KG 08 2019   grade_2 39 2 23 0   0     0   3   39 28                       67.0 39 2 23 0   0     0   3   39 28                 67
2042756 2042756 MA Essex   school 2505970 128   Haverhill 250597001169 1280054 Pentucket Lake Elementary   Regular School No Elementary KG 04 2019   grade_2 26 7 43 2   0     0   2   39 41                       80.0 26 7 43 2   0     0   2   39 41                 80
2042780 2042780 MA Essex   school 2505970 128   Haverhill 250597000866 1280075 Tilton   Regular School No Elementary KG 04 2019   grade_2 36 4 69 0   0     0   0   64 45                       109.0 36 4 69 0   0     0   0   64 45                 109
2042803 2042803 MA Plymouth   school 2506090 131   Hingham 250609002671 1310005 East Elementary School   Regular School No Elementary PK 05 2019   grade_2 71 2 1 0   0     0   0   36 38                       74.0 71 2 1 0   0     0   0   36 38                 74
2042874 2042874 MA Hampden   school 2506270 137   Holyoke 250627001178 1370003 Joseph Metcalf School   Regular School No Elementary PK 04 2019   grade_2 15 3 23 0   0     0   1   17 25                       42.0 15 3 23 0   0     0   1   17 25                 42
2042890 2042890 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No Elementary PK 04 2019   grade_2 1 0 44 0   0     0   2   18 29                       47.0 1 0 44 0   0     0   2   18 29                 47
2042901 2042901 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No Elementary PK 08 2019   grade_2 2 1 55 0   0     0   0   32 26                       58.0 2 1 55 0   0     0   0   32 26                 58
2042910 2042910 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No Elementary PK 05 2019   grade_2 10 0 51 0   0     0   0   32 29                       61.0 10 0 51 0   0     0   0   32 29                 61
2042935 2042935 MA Hampden   school 2506270 137   Holyoke 250627002795 1370070 H.B. Lawrence School   Regular School No Elementary KG 03 2019   grade_2 3 6 58 0   0     0   0   34 33                       67.0 3 6 58 0   0     0   0   34 33                 67
2042948 2042948 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No Elementary KG 06 2019   grade_2 63 0 6 0   0     0   6   46 29                       75.0 63 0 6 0   0     0   6   46 29                 75
2042977 2042977 MA Middlesex   school 2506390 141   Hudson 250639000924 1410007 Mulready Elementary   Regular School No Elementary PK 04 2019   grade_2 36 0 7 0   0     0   3   16 30                       46.0 36 0 7 0   0     0   3   16 30                 46
2043025 2043025 MA Essex   school 2506480 144   Ipswich 250648000939 1440015 Winthrop   Regular School No Elementary PK 05 2019   grade_2 46 0 3 0   0     0   6   29 26                       55.0 46 0 3 0   0     0   6   29 26                 55
2043039 2043039 MA Plymouth   school 2506540 145   Kingston 250654000943 1450005 Kingston Elementary   Regular School No Elementary KG 02 2019   grade_2 139 1 1 0   0     0   1   74 68                       142.0 139 1 1 0   0     0   1   74 68                 142
2043056 2043056 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No Elementary KG 04 2019   grade_2 1 2 122 0   0     0   2   61 66                       127.0 1 2 122 0   0     0   2   61 66                 127
2043079 2043079 MA Essex   school 2506660 149   Lawrence 250666000958 1490020 James F Hennessey   Regular School No Elementary PK 02 2019   grade_2 2 2 75 0   0     0   1   43 37                       80.0 2 2 75 0   0     0   1   43 37                 80
2043093 2043093 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No Elementary 01 05 2019   grade_2 4 0 91 0   0     0   0   42 53                       95.0 4 0 91 0   0     0   0   42 53                 95

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