enrollments

Data source: Big Local News · About: Big Local

6,880 rows where grade = "grade_1" and state = "MA" sorted by asian

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_1 · 6,780 ✖
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
737717 737717 MA Bristol   school 2504020 72   Dartmouth 250402000542 720030 George H Potter   Regular School No 1 KG 05 2015   grade_1 55 0 3 0   0     0   3   24 37                       61 55 0 3 0   0     0   3   24 37                 61
737796 737796 MA Middlesex   school 2504320 79   Dracut 250432000583 790020 Joseph A Campbell Elementary   Regular School No 1 PK 05 2015   grade_1 90 1 1 0   0     0   1   57 36                       93 90 1 1 0   0     0   1   57 36                 93
737847 737847 MA Plymouth   school 2504440 83   East Bridgewater 250444000596 830005 Central   Regular School No 1 PK 02 2015   grade_1 149 5 3 0   0     0   6   90 73                       163 149 5 3 0   0     0   6   90 73                 163
737878 737878 MA Hampshire   school 2504590 86   Easthampton 250459002466 860020 Neil A Pepin   Regular School No 1 KG 04 2015   grade_1 29 0 2 0   0     0   2   17 16                       33 29 0 2 0   0     0   2   17 16                 33
737933 737933 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No 1 PK 08 2015   grade_1 29 0 10 1   0     0   2   17 25                       42 29 0 10 1   0     0   2   17 25                 42
737943 737943 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No 1 PK 06 2015   grade_1 14 0 0 0   0     0   2   10 6                       16 14 0 0 0   0     0   2   10 6                 16
738094 738094 MA Bristol   school 2504830 95   Fall River 250483000665 950140 James Tansey   Regular School No 1 KG 05 2015   grade_1 52 1 4 0   0     0   2   29 30                       59 52 1 4 0   0     0   2   29 30                 59
738145 738145 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No 1 KG 04 2015   grade_1 62 0 6 1   0     0   4   39 34                       73 62 0 6 1   0     0   4   39 34                 73
738205 738205 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   grade_1 10 0 0 0   0     0   0   5 5                       10 10 0 0 0   0     0   0   5 5                 10
738314 738314 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No 1 KG 05 2015   grade_1 53 1 1 0   0     0   1   32 24                       56 53 1 1 0   0     0   1   32 24                 56
738332 738332 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No 1 KG 05 2015   grade_1 37 1 1 0   0     0   0   20 19                       39 37 1 1 0   0     0   0   20 19                 39
738359 738359 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No 1 PK 02 2015   grade_1 73 6 23 0   0     0   6   63 45                       108 73 6 23 0   0     0   6   63 45                 108
738375 738375 MA Essex   school 2505220 105   Georgetown 250522000766 1050005 Perley Elementary   Regular School No 1 PK 01 2015   grade_1 113 0 2 0   0     1   2   64 54                       118 113 0 2 0   0     1   2   64 54                 118
738394 738394 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No 1 KG 05 2015   grade_1 34 0 3 0   0     0   3   21 19                       40 34 0 3 0   0     0   3   21 19                 40
738401 738401 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No 1 KG 05 2015   grade_1 36 0 1 0   0     0   0   25 12                       37 36 0 1 0   0     0   0   25 12                 37
738407 738407 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No 1 KG 05 2015   grade_1 33 0 4 0   0     1   1   17 22                       39 33 0 4 0   0     1   1   17 22                 39
738466 738466 MA Franklin   school 2505490 114   Greenfield 250549002577 1140010 Federal Street School   Regular School No 1 KG 03 2015   grade_1 57 0 1 0   0     0   0   32 26                       58 57 0 1 0   0     0   0   32 26                 58
738470 738470 MA Franklin   school 2505490 114   Greenfield 250549000798 1140025 Discovery School at Four Corners   Regular School No 1 KG 03 2015   grade_1 52 1 1 0   0     0   0   23 31                       54 52 1 1 0   0     0   0   23 31                 54
738478 738478 MA Franklin   school 2505490 114   Greenfield 250549002578 1140035 Newton School   Regular School No 1 KG 03 2015   grade_1 47 0 14 0   0     0   0   31 30                       61 47 0 14 0   0     0   0   31 30                 61
738507 738507 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No 1 KG 06 2015   grade_1 76 1 1 1   0     1   0   41 39                       80 76 1 1 1   0     1   0   41 39                 80
738527 738527 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Center Elementary   Regular School No 1 KG 02 2015   grade_1 99 0 2 0   0     0   0   51 50                       101 99 0 2 0   0     0   0   51 50                 101
738556 738556 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No 1 PK 06 2015   grade_1 34 0 2 0   0     0   0   17 19                       36 34 0 2 0   0     0   0   17 19                 36
738623 738623 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 KG 08 2015   grade_1 25 1 21 1   0     0   1   25 24                       49 25 1 21 1   0     0   1   25 24                 49
738638 738638 MA Plymouth   school 2506090 131   Hingham 250609002671 1310005 East Elementary School   Regular School No 1 PK 05 2015   grade_1 88 0 0 0   0     0   1   54 35                       89 88 0 0 0   0     0   1   54 35                 89
738720 738720 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No 1 PK 08 2015   grade_1 0 3 54 0   0     0   0   30 27                       57 0 3 54 0   0     0   0   30 27                 57
738743 738743 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No 1 KG 08 2015   grade_1 7 3 40 0   0     0   0   27 23                       50 7 3 40 0   0     0   0   27 23                 50
738752 738752 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No 1 KG 08 2015   grade_1 16 2 56 0   0     0   1   47 28                       75 16 2 56 0   0     0   1   47 28                 75
738770 738770 MA Hampden   school 2506270 137   Holyoke 250627002795 1370070 H.B. Lawrence School   Regular School No 1 KG 03 2015   grade_1 10 3 58 0   0     0   2   40 33                       73 10 3 58 0   0     0   2   40 33                 73
738783 738783 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No 1 KG 06 2015   grade_1 82 0 4 0   0     1   0   52 35                       87 82 0 4 0   0     1   0   52 35                 87
738812 738812 MA Middlesex   school 2506390 141   Hudson 250639000924 1410007 Mulready Elementary   Regular School No 1 PK 04 2015   grade_1 49 0 5 0   0     0   3   28 29                       57 49 0 5 0   0     0   3   28 29                 57
738838 738838 MA Plymouth   school 2506420 142   Hull 250642000932 1420015 Lillian M Jacobs   Regular School No 1 PK 05 2015   grade_1 73 1 0 0   0     0   0   44 30                       74 73 1 0 0   0     0   0   44 30                 74
738852 738852 MA Essex   school 2506480 144   Ipswich 250648000936 1440007 Paul F Doyon Memorial   Regular School No 1 PK 05 2015   grade_1 63 0 1 0   0     0   1   36 29                       65 63 0 1 0   0     0   1   36 29                 65
738898 738898 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No 1 PK 04 2015   grade_1 6 0 132 0   0     0   0   71 67                       138 6 0 132 0   0     0   0   71 67                 138
738937 738937 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No 1 KG 05 2015   grade_1 3 0 100 0   0     0   0   53 50                       103 3 0 100 0   0     0   0   53 50                 103
738951 738951 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Edward F. Parthum   Regular School No 1 KG 04 2015   grade_1 8 3 123 1   0     0   2   69 68                       137 8 3 123 1   0     0   2   69 68                 137
738955 738955 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No 1 01 05 2015   grade_1 2 0 71 0   0     0   0   36 37                       73 2 0 71 0   0     0   0   36 37                 73
739084 739084 MA Worcester   school 2506780 153   Leominster 250678000985 1530025 Johnny Appleseed   Regular School No 1 KG 05 2015   grade_1 55 12 36 0   0     0   4   54 53                       107 55 12 36 0   0     0   4   54 53                 107
739114 739114 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No 1 PK 06 2015   grade_1 13 0 2 0   0     0   0   9 6                       15 13 0 2 0   0     0   0   9 6                 15
739367 739367 MA Hampden   school 2507050 161   Ludlow 250705002663 1610010 East Street Elementary School   Regular School No 1 PK 01 2015   grade_1 158 2 27 0   0     0   5   95 97                       192 158 2 27 0   0     0   5   95 97                 192
739473 739473 MA Essex   school 2507110 163   Lynn 250711001081 1630075 Lynn Woods   Regular School No 1 KG 05 2015   grade_1 19 0 1 1   0     0   1   10 12                       22 19 0 1 1   0     0   1   10 12                 22
739683 739683 MA Plymouth   school 2507350 171   Marshfield 250735000760 1710005 Eames Way School   Regular School No 1 KG 05 2015   grade_1 32 0 0 0   0     0   1   23 10                       33 32 0 0 0   0     0   1   23 10                 33
739689 739689 MA Plymouth   school 2507350 171   Marshfield 250735001144 1710010 South River   Regular School No 1 KG 05 2015   grade_1 49 0 2 0   0     0   2   30 23                       53 49 0 2 0   0     0   2   30 23                 53
739915 739915 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No 1 01 05 2015   grade_1 103 0 2 0   0     0   16   53 68                       121 103 0 2 0   0     0   16   53 68                 121
740041 740041 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No 1 PK 06 2015   grade_1 12 0 0 0   0     0   0   6 6                       12 12 0 0 0   0     0   0   6 6                 12
740140 740140 MA Bristol   school 2508430 201   New Bedford 250843001321 2010010 Charles S Ashley   Regular School No 1 KG 05 2015   grade_1 40 2 14 0   0     0   1   33 24                       57 40 2 14 0   0     0   1   33 24                 57
740147 740147 MA Bristol   school 2508430 201   New Bedford 250843001322 2010015 Elizabeth Carter Brooks   Regular School No 1 PK 05 2015   grade_1 24 10 12 0   0     0   2   31 17                       48 24 10 12 0   0     0   2   31 17                 48
740160 740160 MA Bristol   school 2508430 201   New Bedford 250843001329 2010040 James B Congdon   Regular School No 1 KG 05 2015   grade_1 22 9 38 0   0     0   4   42 31                       73 22 9 38 0   0     0   4   42 31                 73
740173 740173 MA Bristol   school 2508430 201   New Bedford 250843001332 2010050 John B Devalles   Regular School No 1 KG 05 2015   grade_1 27 10 33 0   0     0   2   30 42                       72 27 10 33 0   0     0   2   30 42                 72
740180 740180 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 Alfred J Gomes   Regular School No 1 PK 05 2015   grade_1 23 6 47 1   0     0   4   42 39                       81 23 6 47 1   0     0   4   42 39                 81
740185 740185 MA Bristol   school 2508430 201   New Bedford 250843001333 2010070 John Hannigan   Regular School No 1 01 05 2015   grade_1 14 10 20 0   0     0   8   29 23                       52 14 10 20 0   0     0   8   29 23                 52
740198 740198 MA Bristol   school 2508430 201   New Bedford 250843001327 2010078 Hayden/McFadden   Regular School No 1 PK 05 2015   grade_1 38 13 53 1   0     0   11   62 54                       116 38 13 53 1   0     0   11   62 54                 116
740204 740204 MA Bristol   school 2508430 201   New Bedford 250843001328 2010085 Horatio A Kempton   Regular School No 1 KG 05 2015   grade_1 11 1 4 0   0     0   1   11 6                       17 11 1 4 0   0     0   1   11 6                 17
740217 740217 MA Bristol   school 2508430 201   New Bedford 250843001335 2010105 Carlos Pacheco   Regular School No 1 PK 05 2015   grade_1 10 9 39 0   0     1   3   34 28                       62 10 9 39 0   0     1   3   34 28                 62
740224 740224 MA Bristol   school 2508430 201   New Bedford 250843001331 2010115 John Avery Parker   Regular School No 1 PK 05 2015   grade_1 14 4 22 0   0     0   2   25 17                       42 14 4 22 0   0     0   2   25 17                 42
740238 740238 MA Bristol   school 2508430 201   New Bedford 250843002802 2010124 Renaissance Community School for the Arts   Regular School No 1 PK 03 2015   grade_1 4 12 23 0   0     0   1   22 18                       40 4 12 23 0   0     0   1   22 18                 40
740255 740255 MA Bristol   school 2508430 201   New Bedford 250843001343 2010135 William H Taylor   Regular School No 1 KG 05 2015   grade_1 19 2 7 0   0     0   4   14 18                       32 19 2 7 0   0     0   4   14 18                 32
740425 740425 MA Norfolk   school 2508640 208   Norfolk 250864000317 2080015 H Olive Day   Regular School No 1 PK 02 2015   grade_1 128 0 4 0   0     0   4   75 61                       136 128 0 4 0   0     0   4   75 61                 136
740428 740428 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 J S Sullivan   Regular School No 1 KG 07 2015   grade_1 28 3 2 0   0     0   1   16 18                       34 28 3 2 0   0     0   1   16 18                 34
740436 740436 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 Greylock   Regular School No 1 KG 07 2015   grade_1 31 0 2 0   0     0   3   19 17                       36 31 0 2 0   0     0   3   19 17                 36
740445 740445 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No 1 PK 07 2015   grade_1 46 1 3 0   0     1   5   31 25                       56 46 1 3 0   0     1   5   31 25                 56
740529 740529 MA Bristol   school 2508730 212   North Attleborough 250873001400 2120005 Allen Avenue   Regular School No 1 KG 04 2015   grade_1 27 0 4 1   0     0   0   15 17                       32 27 0 4 1   0     0   0   15 17                 32
740559 740559 MA Bristol   school 2508730 212   North Attleborough 250873001199 2120030 Community   Regular School No 1 KG 05 2015   grade_1 37 3 4 0   0     0   2   23 23                       46 37 3 4 0   0     0   2   23 23                 46
740617 740617 MA Worcester   school 2508760 215   North Brookfield 250876001410 2150015 North Brookfield Elementary   Regular School No 1 PK 06 2015   grade_1 45 0 4 0   0     0   4   34 19                       53 45 0 4 0   0     0   4   34 19                 53
740675 740675 MA Plymouth   school 2509030 219   Norwell 250903001454 2190005 Grace Farrar Cole   Regular School No 1 PK 05 2015   grade_1 65 0 0 1   0     0   4   38 32                       70 65 0 0 1   0     0   4   38 32                 70
740745 740745 MA Franklin   school 2509180 223   Orange 250918002593 2230015 Fisher Hill   Regular School No 1 PK 02 2015   grade_1 73 1 4 0   0     0   4   43 39                       82 73 1 4 0   0     0   4   43 39                 82
740795 740795 MA Essex   school 2509360 229   Peabody 250936001496 2290007 John E Burke   Regular School No 1 KG 05 2015   grade_1 45 0 2 0   0     0   1   25 23                       48 45 0 2 0   0     0   1   25 23                 48
740835 740835 MA Essex   school 2509360 229   Peabody 250936001505 2290045 West Memorial   Regular School No 1 PK 05 2015   grade_1 39 0 0 0   0     0   0   20 19                       39 39 0 0 0   0     0   0   20 19                 39
740855 740855 MA Plymouth   school 2509420 231   Pembroke 250942001508 2310003 Bryantville Elementary   Regular School No 1 KG 06 2015   grade_1 70 2 0 0   0     0   3   33 42                       75 70 2 0 0   0     0   3   33 42                 75
740862 740862 MA Plymouth   school 2509420 231   Pembroke 250942001509 2310010 Hobomock Elementary   Regular School No 1 KG 06 2015   grade_1 50 0 0 0   0     0   0   35 15                       50 50 0 0 0   0     0   0   35 15                 50
740870 740870 MA Plymouth   school 2509420 231   Pembroke 250942001510 2310015 North Pembroke Elementary   Regular School No 1 PK 06 2015   grade_1 75 0 1 0   0     0   1   35 42                       77 75 0 1 0   0     0   1   35 42                 77
740904 740904 MA Berkshire   school 2509630 236   Pittsfield 250963001522 2360045 Robert T. Capeless Elementary School   Regular School No 1 PK 05 2015   grade_1 31 0 1 0   0     0   5   19 18                       37 31 0 1 0   0     0   5   19 18                 37
740918 740918 MA Berkshire   school 2509630 236   Pittsfield 250963001528 2360065 Crosby   Regular School No 1 PK 05 2015   grade_1 26 6 5 0   0     0   8   28 17                       45 26 6 5 0   0     0   8   28 17                 45
740924 740924 MA Berkshire   school 2509630 236   Pittsfield 250963002489 2360090 Stearns   Regular School No 1 KG 05 2015   grade_1 34 1 4 0   0     0   1   25 15                       40 34 1 4 0   0     0   1   25 15                 40
740972 740972 MA Plymouth   school 2509720 239   Plymouth 250972001541 2390010 Hedge   Regular School No 1 KG 05 2015   grade_1 25 0 5 0   0     0   3   23 10                       33 25 0 5 0   0     0   3   23 10                 33
740984 740984 MA Plymouth   school 2509720 239   Plymouth 250972001542 2390012 Indian Brook   Regular School No 1 KG 05 2015   grade_1 96 0 2 0   0     0   1   45 54                       99 96 0 2 0   0     0   1   45 54                 99
740990 740990 MA Plymouth   school 2509720 239   Plymouth 250972001543 2390015 Manomet Elementary   Regular School No 1 KG 05 2015   grade_1 47 2 0 0   0     0   4   35 18                       53 47 2 0 0   0     0   4   35 18                 53
741029 741029 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Dennett Elementary   Regular School No 1 KG 06 2015   grade_1 28 0 0 0   0     0   1   12 17                       29 28 0 0 0   0     0   1   12 17                 29
741037 741037 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No 1 PK 08 2015   grade_1 13 0 0 0   0     0   2   7 8                       15 13 0 0 0   0     0   2   7 8                 15
741178 741178 MA Middlesex   school 2509990 246   Reading 250999001606 2460005 Birch Meadow   Regular School No 1 KG 05 2015   grade_1 63 0 1 0   0     0   0   36 28                       64 63 0 1 0   0     0   0   36 28                 64
741196 741196 MA Middlesex   school 2509990 246   Reading 250999001958 2460020 Wood End Elementary School   Regular School No 1 KG 05 2015   grade_1 41 0 1 0   0     0   1   19 24                       43 41 0 1 0   0     0   1   19 24                 43
741270 741270 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No 1 PK 08 2015   grade_1 11 0 1 0   0     0   0   3 9                       12 11 0 1 0   0     0   0   3 9                 12
741280 741280 MA Plymouth   school 2510140 250   Rochester 251014001637 2500005 Rochester Memorial   Regular School No 1 PK 06 2015   grade_1 49 0 0 0   0     0   5   23 31                       54 49 0 0 0   0     0   5   23 31                 54
741286 741286 MA Plymouth   school 2510170 251   Rockland 251017001640 2510020 Memorial Park   Regular School No 1 01 04 2015   grade_1 56 2 5 0   0     0   1   25 39                       64 56 2 5 0   0     0   1   25 39                 64
741405 741405 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No 1 KG 06 2015   grade_1 70 2 0 1   0     0   2   29 46                       75 70 2 0 1   0     0   2   29 46                 75
741437 741437 MA Essex   school 2510500 262   Saugus 251050001677 2620067 Douglas Waybright   Regular School No 1 KG 05 2015   grade_1 25 1 4 0   0     0   1   13 18                       31 25 1 4 0   0     0   1   13 18                 31
741452 741452 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No 1 PK 05 2015   grade_1 9 0 0 0   0     0   0   1 8                       9 9 0 0 0   0     0   0   1 8                 9
741472 741472 MA Plymouth   school 2510560 264   Scituate 251056002068 2640015 Jenkins Elementary School   Regular School No 1 KG 06 2015   grade_1 53 1 0 0   0     0   2   27 29                       56 53 1 0 0   0     0   2   27 29                 56
741579 741579 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No 1 PK 06 2015   grade_1 10 0 0 0   0     0   2   2 10                       12 10 0 0 0   0     0   2   2 10                 12
741587 741587 MA Bristol   school 2510860 273   Somerset 251086001723 2730005 Chace Street   Regular School No 1 PK 05 2015   grade_1 75 2 1 1   0     0   1   38 42                       80 75 2 1 1   0     0   1   38 42                 80
741593 741593 MA Bristol   school 2510860 273   Somerset 251086002536 2730008 North Elementary   Regular School No 1 KG 05 2015   grade_1 69 2 3 0   0     0   2   42 34                       76 69 2 3 0   0     0   2   42 34                 76
741758 741758 MA Hampden   school 2511130 281   Springfield 251113001826 2810020 Samuel Bowles   Regular School No 1 KG 05 2015   grade_1 4 12 50 0   0     0   1   44 23                       67 4 12 50 0   0     0   1   44 23                 67
741765 741765 MA Hampden   school 2511130 281   Springfield 251113000896 2810023 Milton Bradley School   Regular School No 1 PK 05 2015   grade_1 4 18 82 0   0     0   0   53 51                       104 4 18 82 0   0     0   0   53 51                 104
741771 741771 MA Hampden   school 2511130 281   Springfield 251113001796 2810025 Brightwood   Regular School No 1 KG 05 2015   grade_1 1 11 62 0   0     0   0   34 40                       74 1 11 62 0   0     0   0   34 40                 74
741778 741778 MA Hampden   school 2511130 281   Springfield 251113001801 2810030 Elias Brookings   Regular School No 1 PK 05 2015   grade_1 3 11 31 1   0     0   1   22 25                       47 3 11 31 1   0     0   1   22 25                 47
741790 741790 MA Hampden   school 2511130 281   Springfield 251113001838 2810045 William N. DeBerry   Regular School No 1 KG 05 2015   grade_1 3 13 42 0   0     0   0   34 24                       58 3 13 42 0   0     0   0   34 24                 58
741803 741803 MA Hampden   school 2511130 281   Springfield 251113000341 2810055 Rebecca M Johnson   Regular School No 1 PK 05 2015   grade_1 3 33 77 0   0     0   0   58 55                       113 3 33 77 0   0     0   0   58 55                 113
741810 741810 MA Hampden   school 2511130 281   Springfield 251113001817 2810060 Margaret C Ells   Regular School No 1 PK 01 2015   grade_1 8 14 18 0   0     0   1   27 14                       41 8 14 18 0   0     0   1   27 14                 41
741812 741812 MA Hampden   school 2511130 281   Springfield 251113001805 2810065 Glenwood   Regular School No 1 KG 05 2015   grade_1 3 7 38 0   0     0   2   27 23                       50 3 7 38 0   0     0   2   27 23                 50
741824 741824 MA Hampden   school 2511130 281   Springfield 251113001803 2810075 Frank H Freedman   Regular School No 1 KG 05 2015   grade_1 8 10 29 0   0     0   1   22 26                       48 8 10 29 0   0     0   1   22 26                 48
741844 741844 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No 1 PK 08 2015   grade_1 11 9 22 0   0     0   1   21 22                       43 11 9 22 0   0     0   1   21 22                 43

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