enrollments

Data source: Big Local News · About: Big Local

6,679 rows where grade = "grade_4" and state = "MA" sorted by black

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_4 · 6,579 ✖
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
738510 738510 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No 1 KG 06 2015   grade_4 87 0 0 0   0     1   0   53 35                       88 87 0 0 0   0     1   0   53 35                 88
738525 738525 MA Plymouth   school 2505790 122   Hanover 250579000827 1220004 Cedar Elementary   Regular School No 1 PK 04 2015   grade_4 63 0 0 0   2     0   0   33 32                       65 63 0 0 0   2     0   0   33 32                 65
738530 738530 MA Plymouth   school 2505790 122   Hanover 250579000832 1220015 Sylvester   Regular School No 1 03 04 2015   grade_4 99 0 2 0   2     0   0   54 49                       103 99 0 2 0   2     0   0   54 49                 103
738559 738559 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No 1 PK 06 2015   grade_4 31 0 4 0   0     0   0   19 16                       35 31 0 4 0   0     0   0   19 16                 35
738626 738626 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 KG 08 2015   grade_4 13 0 19 0   0     0   0   11 21                       32 13 0 19 0   0     0   0   11 21                 32
738641 738641 MA Plymouth   school 2506090 131   Hingham 250609002671 1310005 East Elementary School   Regular School No 1 PK 05 2015   grade_4 89 0 0 0   5     0   2   52 44                       96 89 0 0 0   5     0   2   52 44                 96
738653 738653 MA Plymouth   school 2506090 131   Hingham 250609000873 1310019 Plymouth River   Regular School No 1 KG 05 2015   grade_4 68 0 4 0   4     0   2   40 38                       78 68 0 4 0   4     0   2   40 38                 78
738746 738746 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No 1 KG 08 2015   grade_4 8 0 39 0   0     0   1   19 29                       48 8 0 39 0   0     0   1   19 29                 48
738786 738786 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No 1 KG 06 2015   grade_4 77 0 2 0   7     1   3   53 37                       90 77 0 2 0   7     1   3   53 37                 90
738841 738841 MA Plymouth   school 2506420 142   Hull 250642000932 1420015 Lillian M Jacobs   Regular School No 1 PK 05 2015   grade_4 68 0 0 0   0     0   0   41 27                       68 68 0 0 0   0     0   0   41 27                 68
738862 738862 MA Essex   school 2506480 144   Ipswich 250648000939 1440015 Winthrop   Regular School No 1 PK 05 2015   grade_4 55 0 5 0   1     0   8   37 32                       69 55 0 5 0   1     0   8   37 32                 69
738884 738884 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No 1 PK 06 2015   grade_4 18 0 0 0   0     0   1   9 10                       19 18 0 0 0   0     0   1   9 10                 19
738945 738945 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No 1 01 05 2015   grade_4 3 0 95 0   0     0   0   57 41                       98 3 0 95 0   0     0   0   57 41                 98
738958 738958 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No 1 01 05 2015   grade_4 1 0 58 0   0     0   0   30 29                       59 1 0 58 0   0     0   0   30 29                 59
739012 739012 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2015   grade_4 3 0 12 0   0     0   0   14 1                       15 3 0 12 0   0     0   0   14 1                 15
739059 739059 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Morris   Regular School No 1 PK 05 2015   grade_4 52 0 2 0   0     0   0   29 25                       54 52 0 2 0   0     0   0   29 25                 54
739117 739117 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No 1 PK 06 2015   grade_4 14 0 0 0   2     0   1   10 7                       17 14 0 0 0   2     0   1   10 7                 17
739205 739205 MA Hampden   school 2506990 159   Longmeadow 250699001016 1590005 Blueberry Hill   Regular School No 1 KG 05 2015   grade_4 67 0 5 0   10     0   1   51 32                       83 67 0 5 0   10     0   1   51 32                 83
739212 739212 MA Hampden   school 2506990 159   Longmeadow 250699001017 1590010 Center   Regular School No 1 PK 05 2015   grade_4 55 0 2 0   0     0   0   33 24                       57 55 0 2 0   0     0   0   33 24                 57
739686 739686 MA Plymouth   school 2507350 171   Marshfield 250735000760 1710005 Eames Way School   Regular School No 1 KG 05 2015   grade_4 46 0 0 0   0     0   0   22 24                       46 46 0 0 0   0     0   0   22 24                 46
739692 739692 MA Plymouth   school 2507350 171   Marshfield 250735001144 1710010 South River   Regular School No 1 KG 05 2015   grade_4 64 0 0 0   1     0   1   35 31                       66 64 0 0 0   1     0   1   35 31                 66
739699 739699 MA Plymouth   school 2507350 171   Marshfield 250735001137 1710015 Daniel Webster   Regular School No 1 PK 05 2015   grade_4 55 0 2 0   0     0   1   36 22                       58 55 0 2 0   0     0   1   36 22                 58
739705 739705 MA Plymouth   school 2507350 171   Marshfield 250735001140 1710020 Gov Edward Winslow   Regular School No 1 KG 05 2015   grade_4 77 0 2 0   0     0   1   40 40                       80 77 0 2 0   0     0   1   40 40                 80
739837 739837 MA Middlesex   school 2507620 178   Melrose 250762001190 1780017 Herbert Clark Hoover   Regular School No 1 KG 05 2015   grade_4 38 0 2 0   0     0   2   25 17                       42 38 0 2 0   0     0   2   25 17                 42
740029 740029 MA Hampden   school 2508040 191   Monson 250804002589 1910025 Quarry Hill Community School   Regular School No 1 PK 04 2015   grade_4 59 0 1 0   0     0   0   27 33                       60 59 0 1 0   0     0   0   27 33                 60
740044 740044 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No 1 PK 06 2015   grade_4 14 0 0 0   0     0   0   9 5                       14 14 0 0 0   0     0   0   9 5                 14
740071 740071 MA Middlesex   school 2508340 198   Natick 250834001292 1980010 Brown   Regular School No 1 KG 04 2015   grade_4 59 0 7 0   23     0   5   38 56                       94 59 0 7 0   23     0   5   38 56                 94
740076 740076 MA Middlesex   school 2508340 198   Natick 250834001298 1980031 Johnson   Regular School No 1 KG 04 2015   grade_4 33 0 1 0   3     0   0   18 19                       37 33 0 1 0   3     0   0   18 19                 37
740086 740086 MA Middlesex   school 2508340 198   Natick 250834001301 1980043 Memorial   Regular School No 1 KG 04 2015   grade_4 68 0 0 0   7     0   3   34 44                       78 68 0 0 0   7     0   3   34 44                 78
740110 740110 MA Norfolk   school 2508370 199   Needham 250837001314 1990020 John Eliot   Regular School No 1 KG 05 2015   grade_4 46 0 7 0   9     0   5   34 33                       67 46 0 7 0   9     0   5   34 33                 67
740296 740296 MA Essex   school 2508580 204   Newburyport 250858002624 2040030 Edward G. Molin Elementary School   Regular School No 2 04 05 2015   grade_4 177 0 3 0   2     0   3   93 92                       185 177 0 3 0   2     0   3   93 92                 185
740334 740334 MA Middlesex   school 2508610 207   Newton 250861001362 2070040 Countryside   Regular School No 1 KG 05 2015   grade_4 54 0 5 0   19     0   10   42 46                       88 54 0 5 0   19     0   10   42 46                 88
740395 740395 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No 1 KG 05 2015   grade_4 41 0 0 1   8     0   9   28 31                       59 41 0 0 1   8     0   9   28 31                 59
740439 740439 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 Greylock   Regular School No 1 KG 07 2015   grade_4 29 0 2 0   0     0   1   17 15                       32 29 0 2 0   0     0   1   17 15                 32
740474 740474 MA Hampshire   school 2508850 210   Northampton 250885001431 2100025 Leeds   Regular School No 1 KG 05 2015   grade_4 47 0 11 0   0     0   5   30 33                       63 47 0 11 0   0     0   5   30 33                 63
740480 740480 MA Hampshire   school 2508850 210   Northampton 250885001433 2100029 R. K. Finn Ryan Road   Regular School No 1 KG 05 2015   grade_4 31 0 11 0   0     0   1   24 19                       43 31 0 11 0   0     0   1   24 19                 43
740507 740507 MA Essex   school 2508700 211   North Andover 250870001396 2110015 Kittredge   Regular School No 1 KG 05 2015   grade_4 47 0 1 0   3     0   1   27 25                       52 47 0 1 0   3     0   1   27 25                 52
740513 740513 MA Essex   school 2508700 211   North Andover 250870000767 2110018 Annie L Sargent School   Regular School No 1 KG 05 2015   grade_4 78 0 1 1   2     0   2   48 36                       84 78 0 1 1   2     0   2   48 36                 84
740549 740549 MA Bristol   school 2508730 212   North Attleborough 250873001404 2120013 Joseph W Martin Jr Elementary   Regular School No 1 KG 05 2015   grade_4 90 0 1 0   5     0   2   54 44                       98 90 0 1 0   5     0   2   54 44                 98
740555 740555 MA Bristol   school 2508730 212   North Attleborough 250873001408 2120015 Roosevelt Avenue   Regular School No 1 KG 05 2015   grade_4 43 0 1 0   3     0   0   29 18                       47 43 0 1 0   3     0   0   29 18                 47
740588 740588 MA Worcester   school 2508880 213   Northborough 250888001436 2130015 Fannie E Proctor   Regular School No 1 KG 05 2015   grade_4 45 0 6 0   5     0   4   33 27                       60 45 0 6 0   5     0   4   33 27                 60
740602 740602 MA Worcester   school 2508940 214   Northbridge 250894001447 2140001 W Edward Balmer   Regular School No 1 02 04 2015   grade_4 171 0 12 0   1     0   9   113 80                       193 171 0 12 0   1     0   9   113 80                 193
740646 740646 MA Middlesex   school 2508820 217   North Reading 250882001419 2170010 J Turner Hood   Regular School No 1 PK 05 2015   grade_4 59 0 4 0   5     0   0   29 39                       68 59 0 4 0   5     0   0   29 39                 68
740685 740685 MA Plymouth   school 2509030 219   Norwell 250903001458 2190020 William G Vinal   Regular School No 1 PK 05 2015   grade_4 98 0 0 0   2     0   1   46 55                       101 98 0 0 0   2     0   1   46 55                 101
740791 740791 MA Essex   school 2509360 229   Peabody 250936001501 2290005 Captain Samuel Brown   Regular School No 1 KG 05 2015   grade_4 47 0 10 0   2     0   5   32 32                       64 47 0 10 0   2     0   5   32 32                 64
740851 740851 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham Elementary   Regular School No 1 KG 06 2015   grade_4 14 0 1 0   1     0   1   11 6                       17 14 0 1 0   1     0   1   11 6                 17
740865 740865 MA Plymouth   school 2509420 231   Pembroke 250942001509 2310010 Hobomock Elementary   Regular School No 1 KG 06 2015   grade_4 82 0 0 0   1     0   0   45 38                       83 82 0 0 0   1     0   0   45 38                 83
740887 740887 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No 1 KG 06 2015   grade_4 16 0 0 0   0     0   1   9 8                       17 16 0 0 0   0     0   1   9 8                 17
740907 740907 MA Berkshire   school 2509630 236   Pittsfield 250963001522 2360045 Robert T. Capeless Elementary School   Regular School No 1 PK 05 2015   grade_4 32 0 1 1   0     0   0   16 18                       34 32 0 1 1   0     0   0   16 18                 34
740927 740927 MA Berkshire   school 2509630 236   Pittsfield 250963002489 2360090 Stearns   Regular School No 1 KG 05 2015   grade_4 35 0 1 0   0     1   3   20 20                       40 35 0 1 0   0     1   3   20 20                 40
740956 740956 MA Norfolk   school 2509690 238   Plainville 250969001538 2380005 Beatrice H Wood Elementary   Regular School No 2 04 06 2015   grade_4 89 0 4 0   2     0   4   57 42                       99 89 0 4 0   2     0   4   57 42                 99
740969 740969 MA Plymouth   school 2509720 239   Plymouth 250972001539 2390005 Cold Spring   Regular School No 1 KG 05 2015   grade_4 25 0 6 0   0     0   4   20 15                       35 25 0 6 0   0     0   4   20 15                 35
740987 740987 MA Plymouth   school 2509720 239   Plymouth 250972001542 2390012 Indian Brook   Regular School No 1 KG 05 2015   grade_4 98 0 2 0   1     0   4   58 47                       105 98 0 2 0   1     0   4   58 47                 105
740993 740993 MA Plymouth   school 2509720 239   Plymouth 250972001543 2390015 Manomet Elementary   Regular School No 1 KG 05 2015   grade_4 54 0 0 0   3     0   2   32 27                       59 54 0 0 0   3     0   2   32 27                 59
741032 741032 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Dennett Elementary   Regular School No 1 KG 06 2015   grade_4 31 0 0 0   0     0   0   10 21                       31 31 0 0 0   0     0   0   10 21                 31
741050 741050 MA Norfolk   school 2509870 243   Quincy 250987000772 2430020 Beechwood Knoll Elementary   Regular School No 1 KG 05 2015   grade_4 37 0 1 0   20     0   2   31 29                       60 37 0 1 0   20     0   2   31 29                 60
741056 741056 MA Norfolk   school 2509870 243   Quincy 250987001568 2430025 Charles A Bernazzani Elementary   Regular School No 1 KG 05 2015   grade_4 29 0 3 0   16     0   4   26 26                       52 29 0 3 0   16     0   4   26 26                 52
741175 741175 MA Middlesex   school 2509990 246   Reading 250999001604 2460002 Alice M Barrows   Regular School No 1 KG 05 2015   grade_4 59 0 2 0   2     0   0   28 35                       63 59 0 2 0   2     0   0   28 35                 63
741181 741181 MA Middlesex   school 2509990 246   Reading 250999001606 2460005 Birch Meadow   Regular School No 1 KG 05 2015   grade_4 64 0 0 0   0     0   1   34 31                       65 64 0 0 0   0     0   1   34 31                 65
741273 741273 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No 1 PK 08 2015   grade_4 12 0 0 0   0     0   1   6 7                       13 12 0 0 0   0     0   1   6 7                 13
741314 741314 MA Essex   school 2510200 252   Rockport 251020002533 2520005 Rockport Elementary   Regular School No 1 PK 05 2015   grade_4 63 0 2 0   0     0   1   26 40                       66 63 0 2 0   0     0   1   26 40                 66
741401 741401 MA Barnstable   school 2510470 261   Sandwich 251047002534 2610010 Forestdale   Regular School No 1 KG 06 2015   grade_4 76 0 1 2   0     0   0   34 45                       79 76 0 1 2   0     0   0   34 45                 79
741408 741408 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No 1 KG 06 2015   grade_4 83 0 0 1   1     0   1   46 40                       86 83 0 0 1   1     0   1   46 40                 86
741422 741422 MA Essex   school 2510500 262   Saugus 251050001680 2620040 Lynnhurst   Regular School No 1 KG 05 2015   grade_4 43 0 4 0   2     0   0   24 25                       49 43 0 4 0   2     0   0   24 25                 49
741468 741468 MA Plymouth   school 2510560 264   Scituate 251056001691 2640010 Hatherly Elementary   Regular School No 1 KG 06 2015   grade_4 33 0 1 0   2     0   1   16 21                       37 33 0 1 0   2     0   1   16 21                 37
741475 741475 MA Plymouth   school 2510560 264   Scituate 251056002068 2640015 Jenkins Elementary School   Regular School No 1 KG 06 2015   grade_4 92 0 1 0   2     0   0   44 51                       95 92 0 1 0   2     0   0   44 51                 95
741561 741561 MA Worcester   school 2510770 271   Shrewsbury 251077001719 2710025 Walter J Paton   Regular School No 1 KG 04 2015   grade_4 79 0 3 0   9     0   3   49 45                       94 79 0 3 0   9     0   3   49 45                 94
741582 741582 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No 1 PK 06 2015   grade_4 12 0 0 0   0     0   2   7 7                       14 12 0 0 0   0     0   2   7 7                 14
741613 741613 MA Middlesex   school 2510890 274   Somerville 251089001732 2740015 Benjamin G Brown   Regular School No 1 KG 06 2015   grade_4 24 0 8 0   2     0   1   17 18                       35 24 0 8 0   2     0   1   17 18                 35
742039 742039 MA Middlesex   school 2511220 284   Stoneham 251122001851 2840005 Colonial Park   Regular School No 1 PK 04 2015   grade_4 40 0 0 0   0     1   1   24 18                       42 40 0 0 0   0     1   1   24 18                 42
742045 742045 MA Middlesex   school 2511220 284   Stoneham 251122001855 2840025 Robin Hood   Regular School No 1 PK 04 2015   grade_4 40 0 2 0   4     0   1   25 22                       47 40 0 2 0   4     0   1   25 22                 47
742050 742050 MA Middlesex   school 2511220 284   Stoneham 251122001856 2840030 South   Regular School No 1 KG 04 2015   grade_4 60 0 5 0   4     0   7   33 43                       76 60 0 5 0   4     0   7   33 43                 76
742105 742105 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No 1 PK 06 2015   grade_4 107 0 6 0   1     0   11   64 61                       125 107 0 6 0   1     0   11   64 61                 125
742141 742141 MA Franklin   school 2511370 289   Sunderland 251137001878 2890005 Sunderland Elementary   Regular School No 1 PK 06 2015   grade_4 25 0 5 0   4     0   0   14 20                       34 25 0 5 0   4     0   0   14 20                 34
742162 742162 MA Essex   school 2511430 291   Swampscott 251143001883 2910005 Clarke   Regular School No 1 KG 04 2015   grade_4 33 0 8 0   2     0   2   17 28                       45 33 0 8 0   2     0   2   17 28                 45
742173 742173 MA Essex   school 2511430 291   Swampscott 251143001886 2910020 Stanley   Regular School No 1 KG 04 2015   grade_4 52 0 5 1   1     0   2   36 25                       61 52 0 5 1   1     0   2   36 25                 61
742288 742288 MA Essex   school 2511670 298   Topsfield 251167001928 2980005 Proctor Elementary   Regular School No 2 04 06 2015   grade_4 79 0 5 0   0     0   2   43 43                       86 79 0 5 0   0     0   2   43 43                 86
742301 742301 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No 1 PK 06 2015   grade_4 14 0 1 0   1     0   1   7 10                       17 14 0 1 0   1     0   1   7 10                 17
742338 742338 MA Middlesex   school 2511910 305   Wakefield 251191001941 3050005 Dolbeare   Regular School No 1 KG 04 2015   grade_4 69 0 4 0   1     0   3   44 33                       77 69 0 4 0   1     0   3   44 33                 77
742352 742352 MA Middlesex   school 2511910 305   Wakefield 251191001948 3050040 Walton   Regular School No 1 01 04 2015   grade_4 34 0 3 0   0     0   2   23 16                       39 34 0 3 0   0     0   2   23 16                 39
742367 742367 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales Elementary   Regular School No 1 PK 06 2015   grade_4 21 0 0 0   0     0   1   8 14                       22 21 0 0 0   0     0   1   8 14                 22
742537 742537 MA Middlesex   school 2512210 315   Wayland 251221000153 3150020 Loker School   Regular School No 1 KG 04 2015   grade_4 30 0 0 0   10     0   3   22 21                       43 30 0 0 0   10     0   3   22 21                 43
742564 742564 MA Norfolk   school 2512270 317   Wellesley 251227002025 3170005 Katharine Lee Bates   Regular School No 1 KG 05 2015   grade_4 56 0 2 0   6     0   4   41 27                       68 56 0 2 0   6     0   4   41 27                 68
742571 742571 MA Norfolk   school 2512270 317   Wellesley 251227002024 3170015 Joseph E Fiske   Regular School No 1 PK 05 2015   grade_4 42 0 6 0   7     0   4   33 26                       59 42 0 6 0   7     0   4   33 26                 59
742577 742577 MA Norfolk   school 2512270 317   Wellesley 251227002023 3170020 John D Hardy   Regular School No 1 KG 05 2015   grade_4 38 0 1 0   13     0   1   23 30                       53 38 0 1 0   13     0   1   23 30                 53
742681 742681 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No 1 KG 05 2015   grade_4 29 0 5 0   3     0   0   16 21                       37 29 0 5 0   3     0   0   16 21                 37
742693 742693 MA Hampden   school 2512630 325   Westfield 251263002605 3250033 Munger Hill   Regular School No 1 KG 05 2015   grade_4 57 0 2 0   1     0   7   31 36                       67 57 0 2 0   1     0   7   31 36                 67
742705 742705 MA Hampden   school 2512630 325   Westfield 251263002071 3250040 Southampton Road   Regular School No 1 KG 05 2015   grade_4 59 0 3 0   2     0   2   31 35                       66 59 0 3 0   2     0   2   31 35                 66
742711 742711 MA Hampden   school 2512630 325   Westfield 251263002066 3250055 Juniper Park   Regular School No 1 KG 05 2015   grade_4 39 0 7 0   1     0   1   30 18                       48 39 0 7 0   1     0   1   30 18                 48
742729 742729 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No 1 03 05 2015   grade_4 126 0 0 0   27     0   5   89 69                       158 126 0 0 0   27     0   5   89 69                 158
742762 742762 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton Elementary School   Regular School No 1 PK 06 2015   grade_4 15 0 1 0   0     0   0   6 10                       16 15 0 1 0   0     0   0   6 10                 16
742816 742816 MA Hampden   school 2512510 332   West Springfield 251251002047 3320025 Memorial   Regular School No 1 01 05 2015   grade_4 28 0 13 1   0     0   0   23 19                       42 28 0 13 1   0     0   0   23 19                 42
742821 742821 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 Mittineague   Regular School No 1 01 05 2015   grade_4 16 0 8 0   0     0   0   13 11                       24 16 0 8 0   0     0   0   13 11                 24
742826 742826 MA Hampden   school 2512510 332   West Springfield 251251002050 3320040 Tatham   Regular School No 1 01 05 2015   grade_4 40 0 3 0   1     0   1   25 20                       45 40 0 3 0   1     0   1   25 20                 45
742842 742842 MA Norfolk   school 2512810 335   Westwood 251281000794 3350010 Deerfield School   Regular School No 1 KG 05 2015   grade_4 35 0 0 0   3     0   3   28 13                       41 35 0 0 0   3     0   3   28 13                 41
742848 742848 MA Norfolk   school 2512810 335   Westwood 251281002096 3350012 Downey   Regular School No 1 KG 05 2015   grade_4 34 0 0 0   5     0   4   23 20                       43 34 0 0 0   5     0   4   23 20                 43
742854 742854 MA Norfolk   school 2512810 335   Westwood 251281002099 3350015 Paul Hanlon   Regular School No 1 KG 05 2015   grade_4 39 0 1 0   1     0   2   22 21                       43 39 0 1 0   1     0   2   22 21                 43
742860 742860 MA Norfolk   school 2512810 335   Westwood 251281002098 3350017 Martha Jones   Regular School No 1 KG 05 2015   grade_4 46 0 4 0   5     0   1   24 32                       56 46 0 4 0   5     0   1   24 32                 56
742931 742931 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No 1 PK 06 2015   grade_4 17 0 0 0   0     0   0   12 5                       17 17 0 0 0   0     0   0   12 5                 17
742939 742939 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Williamsburg Schools   Regular School No 1 PK 06 2015   grade_4 27 0 0 0   0     0   0   18 9                       27 27 0 0 0   0     0   0   18 9                 27

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