enrollments

Data source: Big Local News · About: Big Local

976 rows where grade = "grade_2", state = "MA" and year = 2018 sorted by asian_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 976 ✖

grade ✖

  • grade_2 · 976 ✖
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
2230205 2230205 MA Suffolk   school   35   Boston   350652               2018   grade_2 * * * *   *     *   *   * *                       0.0                                             0
2230264 2230264 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston: Horace Mann School for the Deaf   Special Education School No Other PK 12 2018   grade_2 * * * *   *     *   *   2 3                       5.0                         2 3                 5
2231639 2231639 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   grade_2 * * * *   *     *   *   * *                       0.0                                             0
2232017 2232017 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_2 * * * *   *     *   *   * *                       0.0                                             0
2232130 2232130 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock: Hancock Elementary   Regular School No Elementary PK 06 2018   grade_2 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2235437 2235437 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe: Rowe Elementary   Regular School No Elementary PK 06 2018   grade_2 * * * *   *     *   *   1 3                       4.0                         1 3                 4
2237223 2237223 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_2 * * * *   *     *   *   * *                       0.0                                             0
2228776 2228776 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet: Acushnet Elementary School   Regular School No Elementary PK 04 2018   grade_2 89 0 4 0   0     0   6   53 46                       99.0 89 0 4 0   0     0   6   53 46                 99
2228789 2228789 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Agawam: Clifford M Granger   Regular School No Elementary KG 04 2018   grade_2 32 1 8 0   0     0   3   23 21                       44.0 32 1 8 0   0     0   3   23 21                 44
2228825 2228825 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury: Amesbury Elementary   Regular School No Elementary PK 04 2018   grade_2 62 2 4 1   0     0   4   30 43                       73.0 62 2 4 1   0     0   4   30 43                 73
2229112 2229112 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Barnstable: Centerville Elementary   Regular School No Elementary KG 03 2018   grade_2 59 2 5 0   0     0   2   36 32                       68.0 59 2 5 0   0     0   2   36 32                 68
2229122 2229122 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 Barnstable: West Villages Elementary School   Regular School No Elementary KG 03 2018   grade_2 82 3 6 0   0     0   4   55 40                       95.0 82 3 6 0   0     0   4   55 40                 95
2229241 2229241 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley: Berkley Community School   Regular School No Elementary PK 04 2018   grade_2 88 0 2 0   0     0   3   39 54                       93.0 88 0 2 0   0     0   3   39 54                 93
2229253 2229253 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin: Berlin Memorial   Regular School No Elementary PK 05 2018   grade_2 27 0 2 0   0     0   2   18 13                       31.0 27 0 2 0   0     0   2   18 13                 31
2229262 2229262 MA Essex   school 2502640 30   Beverly 250264000167 300010 Beverly: Centerville Elementary   Regular School No Elementary KG 05 2018   grade_2 41 0 12 0   0     0   3   28 28                       56.0 41 0 12 0   0     0   3   28 28                 56
2229372 2229372 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Boston: Lyon K-8   Regular School No Elementary KG 08 2018   grade_2 9 1 1 0   0     0   3   6 8                       14.0 9 1 1 0   0     0   3   6 8                 14
2229387 2229387 MA Suffolk   school 2502790 35   Boston 250279001115 350008 Boston: Dr. Catherine Ellison-Rosa Parks Early Ed School   Regular School No Elementary PK 03 2018   grade_2 0 18 20 0   0     0   0   17 21                       38.0 0 18 20 0   0     0   0   17 21                 38
2229401 2229401 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston: Boston Teachers Union School   Regular School No Elementary PK 08 2018   grade_2 7 2 7 0   0     0   3   8 11                       19.0 7 2 7 0   0     0   3   8 11                 19
2229477 2229477 MA Suffolk   school 2502790 35   Boston 250279000218 350062 Boston: Curtis Guild   Regular School No Elementary PK 05 2018   grade_2 9 1 31 0   0     0   0   20 21                       41.0 9 1 31 0   0     0   0   20 21                 41
2229485 2229485 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Boston: Dante Alighieri Montessori School   Regular School No Elementary PK 05 2018   grade_2 5 0 5 0   0     0   2   6 6                       12.0 5 0 5 0   0     0   2   6 6                 12
2229493 2229493 MA Suffolk   school 2502790 35   Boston 250279000220 350072 Boston: David A Ellis   Regular School No Elementary PK 05 2018   grade_2 1 26 39 1   0     0   1   34 34                       68.0 1 26 39 1   0     0   1   34 34                 68
2229509 2229509 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Boston: Dennis C Haley   Regular School No Elementary PK 08 2018   grade_2 12 16 12 0   0     0   5   25 20                       45.0 12 16 12 0   0     0   5   25 20                 45
2229520 2229520 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Boston: Donald Mckay   Regular School No Elementary PK 08 2018   grade_2 7 1 78 0   0     0   3   40 49                       89.0 7 1 78 0   0     0   3   40 49                 89
2229550 2229550 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Boston: Ellis Mendell   Regular School No Elementary PK 05 2018   grade_2 16 7 13 1   0     0   4   23 18                       41.0 16 7 13 1   0     0   4   23 18                 41
2229577 2229577 MA Suffolk   school 2502790 35   Boston 250279000247 350135 Boston: Henry Grew   Regular School No Elementary PK 05 2018   grade_2 5 11 16 0   0     0   1   13 20                       33.0 5 11 16 0   0     0   1   13 20                 33
2229593 2229593 MA Suffolk   school 2502790 35   Boston 250279000249 350141 Boston: Hugh Roe O'Donnell   Regular School No Elementary PK 05 2018   grade_2 1 2 35 0   0     0   0   18 20                       38.0 1 2 35 0   0     0   0   18 20                 38
2229654 2229654 MA Suffolk   school 2502790 35   Boston 250279000264 350172 Boston: John D Philbrick   Regular School No Elementary PK 05 2018   grade_2 4 13 5 0   0     0   0   13 9                       22.0 4 13 5 0   0     0   0   13 9                 22
2229682 2229682 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Boston: Joseph J Hurley   Regular School No Elementary PK 08 2018   grade_2 10 5 33 0   0     0   1   28 21                       49.0 10 5 33 0   0     0   1   28 21                 49
2229693 2229693 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Boston: Joseph Lee   Regular School No Elementary PK 08 2018   grade_2 5 34 13 0   0     0   1   32 21                       53.0 5 34 13 0   0     0   1   32 21                 53
2229747 2229747 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Boston: Maurice J Tobin   Regular School No Elementary PK 08 2018   grade_2 1 19 36 1   0     0   2   31 28                       59.0 1 19 36 1   0     0   2   31 28                 59
2229757 2229757 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Boston: Michael J Perkins   Regular School No Elementary KG 05 2018   grade_2 5 18 10 0   0     0   2   14 21                       35.0 5 18 10 0   0     0   2   14 21                 35
2229820 2229820 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Boston: Lyndon   Regular School No Elementary PK 08 2018   grade_2 46 3 16 0   0     0   3   39 29                       68.0 46 3 16 0   0     0   3   39 29                 68
2229875 2229875 MA Suffolk   school 2502790 35   Boston 250279000321 350302 Boston: Samuel Adams   Regular School No Elementary PK 05 2018   grade_2 7 1 39 1   0     0   0   22 26                       48.0 7 1 39 1   0     0   0   22 26                 48
2229883 2229883 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Boston: Samuel W Mason   Regular School No Elementary PK 05 2018   grade_2 2 20 14 1   0     0   1   18 20                       38.0 2 20 14 1   0     0   1   18 20                 38
2229891 2229891 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Boston: Sarah Greenwood   Regular School No Elementary PK 08 2018   grade_2 0 14 39 0   0     0   2   26 29                       55.0 0 14 39 0   0     0   2   26 29                 55
2229990 2229990 MA Suffolk   school 2502790 35   Boston 250279002669 350376 Boston: King K-8   Regular School No Elementary PK 08 2018   grade_2 2 33 15 0   0     1   3   28 26                       54.0 2 33 15 0   0     1   3   28 26                 54
2230009 2230009 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Boston: Mildred Avenue K-8   Regular School No Elementary PK 08 2018   grade_2 0 35 9 0   0     0   0   20 24                       44.0 0 35 9 0   0     0   0   20 24                 44
2230020 2230020 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Boston: Young Achievers   Alternative School No Elementary PK 08 2018   grade_2 2 25 32 0   0     0   1   31 29                       60.0 2 25 32 0   0     0   1   31 29                 60
2230031 2230031 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Boston: Mission Hill School   Regular School No Elementary PK 08 2018   grade_2 9 3 9 0   0     1   0   14 8                       22.0 9 3 9 0   0     1   0   14 8                 22
2230254 2230254 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Boston: Rafael Hernandez   Regular School No Elementary PK 08 2018   grade_2 2 3 42 0   0     0   1   27 21                       48.0 2 3 42 0   0     0   1   27 21                 48
2230282 2230282 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bourne: Bournedale Elementary School   Regular School No Elementary PK 04 2018   grade_2 57 3 4 1   0     1   4   35 35                       70.0 57 3 4 1   0     1   4   35 35                 70
2230380 2230380 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Brewster: Stony Brook Elementary   Regular School No Elementary PK 02 2018   grade_2 60 2 5 0   0     0   5   37 35                       72.0 60 2 5 0   0     0   5   37 35                 72
2230397 2230397 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Brockton: Dr W Arnone Community School   Regular School No Elementary KG 05 2018   grade_2 21 78 11 3   0     0   9   75 47                       122.0 21 78 11 3   0     0   9   75 47                 122
2230420 2230420 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brockton: Brookfield   Regular School No Elementary KG 05 2018   grade_2 38 62 5 0   0     0   4   57 52                       109.0 38 62 5 0   0     0   4   57 52                 109
2230434 2230434 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton: Edgar B Davis   Regular School No Elementary KG 08 2018   grade_2 20 73 31 0   0     0   10   67 67                       134.0 20 73 31 0   0     0   10   67 67                 134
2230451 2230451 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Brockton: Gilmore Elementary School   Regular School No Elementary KG 05 2018   grade_2 7 65 17 0   0     0   5   41 53                       94.0 7 65 17 0   0     0   5   41 53                 94
2230530 2230530 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield: Brookfield Elementary   Regular School No Elementary PK 06 2018   grade_2 40 0 2 0   0     0   0   19 23                       42.0 40 0 2 0   0     0   0   19 23                 42
2230905 2230905 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 Chelsea: George F. Kelly Elementary   Regular School No Elementary 01 04 2018   grade_2 9 3 107 0   0     0   1   57 63                       120.0 9 3 107 0   0     0   1   57 63                 120
2230910 2230910 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Chelsea: Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2018   grade_2 15 4 118 0   0     0   2   66 73                       139.0 15 4 118 0   0     0   2   66 73                 139
2230945 2230945 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Chicopee: Belcher   Regular School No Elementary KG 02 2018   grade_2 45 7 22 0   0     0   2   40 36                       76.0 45 7 22 0   0     0   2   40 36                 76
2230971 2230971 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Chicopee: Litwin   Regular School No Elementary KG 05 2018   grade_2 19 1 5 0   0     0   1   14 12                       26.0 19 1 5 0   0     0   1   14 12                 26
2230978 2230978 MA Hampden   school 2503660 61   Chicopee 250366000501 610040 Chicopee: Lambert-Lavoie   Regular School No Elementary KG 05 2018   grade_2 42 1 14 0   0     0   0   30 27                       57.0 42 1 14 0   0     0   0   30 27                 57
2230992 2230992 MA Hampden   school 2503660 61   Chicopee 250366000504 610065 Chicopee: Streiber Memorial School   Regular School No Elementary KG 05 2018   grade_2 32 3 8 0   0     0   0   23 20                       43.0 32 3 8 0   0     0   0   23 20                 43
2230999 2230999 MA Hampden   school 2503660 61   Chicopee 250366000500 610090 Chicopee: Gen John J Stefanik   Regular School No Elementary KG 05 2018   grade_2 13 8 51 0   0     0   0   32 40                       72.0 13 8 51 0   0     0   0   32 40                 72
2231024 2231024 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg: Clarksburg Elementary   Regular School No Elementary KG 08 2018   grade_2 19 0 1 0   0     0   1   6 15                       21.0 19 0 1 0   0     0   1   6 15                 21
2231098 2231098 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway: Conway Grammar   Regular School No Elementary PK 06 2018   grade_2 19 0 0 0   0     0   1   9 11                       20.0 19 0 0 0   0     0   1   9 11                 20
2231153 2231153 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Dartmouth: Joseph Demello   Regular School No Elementary 01 05 2018   grade_2 62 0 2 0   0     0   3   31 36                       67.0 62 0 2 0   0     0   3   31 36                 67
2231161 2231161 MA Bristol   school 2504020 72   Dartmouth 250402000542 720030 Dartmouth: George H Potter   Regular School No Elementary PK 05 2018   grade_2 69 2 2 0   0     0   4   50 27                       77.0 69 2 2 0   0     0   4   50 27                 77
2231221 2231221 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield: Deerfield Elementary   Regular School No Elementary PK 06 2018   grade_2 34 0 2 0   0     0   2   12 26                       38.0 34 0 2 0   0     0   2   12 26                 38
2231336 2231336 MA Hampshire   school 2504590 86   Easthampton 250459000611 860005 Easthampton: Center School   Regular School No Elementary KG 04 2018   grade_2 31 0 7 0   0     0   2   25 15                       40.0 31 0 7 0   0     0   2   25 15                 40
2231349 2231349 MA Hampshire   school 2504590 86   Easthampton 250459002466 860020 Easthampton: Neil A Pepin   Regular School No Elementary KG 04 2018   grade_2 33 0 5 0   0     0   3   27 14                       41.0 33 0 5 0   0     0   3   27 14                 41
2231416 2231416 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown: Edgartown Elementary   Regular School No Elementary PK 08 2018   grade_2 26 1 4 0   0     0   3   13 21                       34.0 26 1 4 0   0     0   3   13 21                 34
2231427 2231427 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving: Erving Elementary   Regular School No Elementary PK 06 2018   grade_2 18 0 1 0   0     0   1   11 9                       20.0 18 0 1 0   0     0   1   11 9                 20
2231484 2231484 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Everett: Lafayette School   Regular School No Elementary KG 08 2018   grade_2 35 29 58 1   0     0   3   69 57                       126.0 35 29 58 1   0     0   3   69 57                 126
2231509 2231509 MA Bristol   school 2504800 94   Fairhaven 250480000640 940010 Fairhaven: East Fairhaven   Regular School No Elementary PK 05 2018   grade_2 54 3 5 1   0     0   2   37 28                       65.0 54 3 5 1   0     0   2   37 28                 65
2231576 2231576 MA Bristol   school 2504830 95   Fall River 250483000666 950045 Fall River: John J Doran   Regular School No Elementary PK 08 2018   grade_2 25 3 21 0   0     0   5   36 18                       54.0 25 3 21 0   0     0   5   36 18                 54
2231601 2231601 MA Bristol   school 2504830 95   Fall River 250483000665 950140 Fall River: James Tansey   Regular School No Elementary KG 05 2018   grade_2 43 3 4 0   0     0   4   27 27                       54.0 43 3 4 0   0     0   4   27 27                 54
2231608 2231608 MA Bristol   school 2504830 95   Fall River 250483000677 950145 Fall River: Samuel Watson   Regular School No Elementary KG 05 2018   grade_2 24 8 9 1   0     0   4   22 24                       46.0 24 8 9 1   0     0   4   22 24                 46
2231667 2231667 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Falmouth: Teaticket   Regular School No Elementary PK 04 2018   grade_2 43 6 5 0   0     0   0   21 33                       54.0 43 6 5 0   0     0   0   21 33                 54
2231679 2231679 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 Falmouth: North Falmouth Elementary   Regular School No Elementary KG 04 2018   grade_2 51 1 5 0   0     0   4   23 38                       61.0 51 1 5 0   0     0   4   23 38                 61
2231750 2231750 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida: Abbott Memorial   Regular School No Elementary PK 08 2018   grade_2 8 0 0 0   0     0   0   4 4                       8.0 8 0 0 0   0     0   0   4 4                 8
2231816 2231816 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Framingham: Barbieri Elementary   Regular School No Elementary KG 05 2018   grade_2 17 4 85 0   0     0   5   56 55                       111.0 17 4 85 0   0     0   5   56 55                 111
2231905 2231905 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Franklin: Davis Thayer   Regular School No Elementary KG 05 2018   grade_2 33 0 0 0   0     0   0   18 15                       33.0 33 0 0 0   0     0   0   18 15                 33
2231970 2231970 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Gloucester: Beeman Memorial   Regular School No Elementary KG 05 2018   grade_2 45 2 9 0   0     0   1   29 28                       57.0 45 2 9 0   0     0   1   29 28                 57
2231977 2231977 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 Gloucester: East Gloucester Elementary   Regular School No Elementary KG 05 2018   grade_2 36 0 4 0   0     0   3   22 21                       43.0 36 0 4 0   0     0   3   22 21                 43
2231986 2231986 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Gloucester: Plum Cove School   Regular School No Elementary KG 05 2018   grade_2 30 1 2 0   0     0   1   18 16                       34.0 30 1 2 0   0     0   1   18 16                 34
2231993 2231993 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Gloucester: Veterans Memorial   Regular School No Elementary KG 05 2018   grade_2 23 0 11 0   0     0   2   18 18                       36.0 23 0 11 0   0     0   2   18 18                 36
2232000 2232000 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 Gloucester: West Parish   Regular School No Elementary KG 05 2018   grade_2 54 0 5 0   0     0   6   33 32                       65.0 54 0 5 0   0     0   6   33 32                 65
2232078 2232078 MA Franklin   school 2505490 114   Greenfield 250549002577 1140010 Greenfield: Federal Street School   Regular School No Elementary KG 04 2018   grade_2 26 2 10 0   0     0   6   23 21                       44.0 26 2 10 0   0     0   6   23 21                 44
2232084 2232084 MA Franklin   school 2505490 114   Greenfield 250549000798 1140025 Greenfield: Discovery School at Four Corners   Regular School No Elementary KG 04 2018   grade_2 42 0 5 0   0     0   0   27 20                       47.0 42 0 5 0   0     0   0   27 20                 47
2232107 2232107 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley: Hadley Elementary   Regular School No Elementary PK 06 2018   grade_2 24 0 5 0   0     1   2   18 14                       32.0 24 0 5 0   0     1   2   18 14                 32
2232122 2232122 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax: Halifax Elementary   Regular School No Elementary KG 06 2018   grade_2 73 1 0 0   0     0   2   39 37                       76.0 73 1 0 0   0     0   2   39 37                 76
2232193 2232193 MA Essex   school 2505970 128   Haverhill 250597002769 1280005 Haverhill: Consentino Annex at Bartlett School   Regular School No Elementary KG 02 2018   grade_2 25 0 10 0   0     0   0   20 15                       35.0 25 0 10 0   0     0   0   20 15                 35
2232204 2232204 MA Essex   school 2505970 128   Haverhill 250597000296 1280026 Haverhill: Golden Hill   Regular School No Elementary 01 04 2018   grade_2 63 1 56 0   0     0   2   59 63                       122.0 63 1 56 0   0     0   2   59 63                 122
2232248 2232248 MA Essex   school 2505970 128   Haverhill 250597000866 1280075 Haverhill: Tilton   Regular School No Elementary KG 04 2018   grade_2 59 3 67 1   0     0   4   60 74                       134.0 59 3 67 1   0     0   4   60 74                 134
2232254 2232254 MA Essex   school 2505970 128   Haverhill 250597000867 1280080 Haverhill: Walnut Square   Regular School No Elementary KG 02 2018   grade_2 42 0 8 0   0     0   1   21 30                       51.0 42 0 8 0   0     0   1   21 30                 51
2232363 2232363 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Holyoke: Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2018   grade_2 11 1 17 0   0     0   2   17 14                       31.0 11 1 17 0   0     0   2   17 14                 31
2232391 2232391 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Holyoke: Kelly Elementary   Regular School No Elementary PK 08 2018   grade_2 2 0 72 0   0     0   1   40 35                       75.0 2 0 72 0   0     0   1   40 35                 75
2232402 2232402 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 Holyoke: E N White Elementary   Regular School No Elementary PK 08 2018   grade_2 13 1 46 0   0     0   2   39 23                       62.0 13 1 46 0   0     0   2   39 23                 62
2232423 2232423 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Holyoke: Maurice A Donahue Elementary   Regular School No Elementary PK 08 2018   grade_2 9 2 36 0   0     0   1   31 17                       48.0 9 2 36 0   0     0   1   31 17                 48
2232433 2232433 MA Hampden   school 2506270 137   Holyoke 250627002795 1370070 Holyoke: H.B. Lawrence School   Regular School No Elementary KG 03 2018   grade_2 1 3 67 0   0     0   1   39 33                       72.0 1 3 67 0   0     0   1   39 33                 72
2232449 2232449 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Hopedale: Memorial   Regular School No Elementary KG 06 2018   grade_2 63 1 3 0   0     0   5   36 36                       72.0 63 1 3 0   0     0   5   36 36                 72
2232491 2232491 MA Middlesex   school 2506390 141   Hudson 250639000925 1410015 Hudson: Forest Avenue Elementary   Regular School No Elementary KG 04 2018   grade_2 63 1 7 0   0     0   5   42 34                       76.0 63 1 7 0   0     0   5   42 34                 76
2232556 2232556 MA Plymouth   school 2506540 145   Kingston 250654000943 1450005 Kingston: Kingston Elementary   Regular School No Elementary KG 02 2018   grade_2 161 0 4 1   0     0   0   88 78                       166.0 161 0 4 1   0     0   0   88 78                 166
2232566 2232566 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough: Lanesborough Elementary   Regular School No Elementary PK 06 2018   grade_2 18 1 0 0   0     0   0   6 13                       19.0 18 1 0 0   0     0   0   6 13                 19
2232588 2232588 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Lawrence: Community Day Arlington   Regular School No Elementary KG 04 2018   grade_2 3 3 120 0   0     0   0   67 59                       126.0 3 3 120 0   0     0   0   67 59                 126
2232635 2232635 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Lawrence: Francis M Leahy   Regular School No Elementary KG 05 2018   grade_2 5 1 94 0   0     0   0   55 45                       100.0 5 1 94 0   0     0   0   55 45                 100
2232641 2232641 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Lawrence: Oliver Partnership School   Regular School No Elementary 01 05 2018   grade_2 4 0 77 0   0     0   0   36 45                       81.0 4 0 77 0   0     0   0   36 45                 81
2232657 2232657 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 Lawrence: John K Tarbox   Regular School No Elementary 01 05 2018   grade_2 2 0 66 0   0     0   1   39 30                       69.0 2 0 66 0   0     0   1   39 30                 69
2232695 2232695 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence: School for Exceptional Studies   Regular School No Other 01 12 2018   grade_2 1 0 5 0   0     0   0   5 1                       6.0 1 0 5 0   0     0   0   5 1                 6

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