enrollments

Data source: Big Local News · About: Big Local

954 rows where grade = "grade_4", state = "MA" and year = 2019 sorted by multiracial

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 954 ✖

grade ✖

  • grade_4 · 954 ✖
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
2041285 2041285 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 03 12 2019   grade_4 * * * *   *     *   *   1 2                       3.0                         1 2                 3
2042366 2042366 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_4 * * * *   *     *   *   1 2                       3.0                         1 2                 3
2042673 2042673 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2019   grade_4 * * * *   *     *   *   3 2                       5.0                         3 2                 5
2044414 2044414 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No Other 04 12 2019   grade_4 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2039855 2039855 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2019   grade_4 46 5 5 0   3     0   0   34 25                       59.0 46 5 5 0   3     0   0   34 25                 59
2039935 2039935 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No Elementary KG 05 2019   grade_4 49 1 3 0   15     0   0   38 30                       68.0 49 1 3 0   15     0   0   38 30                 68
2040091 2040091 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2019   grade_4 30 20 7 0   1     0   0   29 29                       58.0 30 20 7 0   1     0   0   29 29                 58
2040224 2040224 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No Elementary PK 05 2019   grade_4 22 0 0 0   0     0   0   16 6                       22.0 22 0 0 0   0     0   0   16 6                 22
2040246 2040246 MA Essex   school 2502640 30   Beverly 250264000173 300040 North Beverly Elementary   Regular School No Elementary KG 04 2019   grade_4 46 2 10 1   0     0   0   30 29                       59.0 46 2 10 1   0     0   0   30 29                 59
2040345 2040345 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2019   grade_4 11 8 7 0   0     0   0   11 15                       26.0 11 8 7 0   0     0   0   11 15                 26
2040412 2040412 MA Suffolk   school 2502790 35   Boston 250279000218 350062 Curtis Guild   Regular School No Elementary PK 05 2019   grade_4 7 0 41 0   0     0   0   26 22                       48.0 7 0 41 0   0     0   0   26 22                 48
2040419 2040419 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No Elementary PK 06 2019   grade_4 4 0 8 0   0     0   0   7 5                       12.0 4 0 8 0   0     0   0   7 5                 12
2040440 2040440 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2019   grade_4 16 12 17 1   0     0   0   26 20                       46.0 16 12 17 1   0     0   0   26 20                 46
2040450 2040450 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2019   grade_4 6 1 84 0   0     0   0   46 45                       91.0 6 1 84 0   0     0   0   46 45                 91
2040460 2040460 MA Suffolk   school 2502790 35   Boston 250279000227 350088 Edward Everett   Regular School No Elementary PK 05 2019   grade_4 0 19 16 0   5     0   0   19 21                       40.0 0 19 16 0   5     0   0   19 21                 40
2040508 2040508 MA Suffolk   school 2502790 35   Boston 250279002569 350138 O W Holmes   Regular School No Elementary PK 05 2019   grade_4 2 38 16 0   4     0   0   34 26                       60.0 2 38 16 0   4     0   0   34 26                 60
2040531 2040531 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No Elementary KG 08 2019   grade_4 1 26 39 0   3     1   0   32 38                       70.0 1 26 39 0   3     1   0   32 38                 70
2040548 2040548 MA Suffolk   school 2502790 35   Boston 250279000257 350156 James Otis   Regular School No Elementary PK 05 2019   grade_4 15 2 43 0   3     0   0   37 26                       63.0 15 2 43 0   3     0   0   37 26                 63
2040685 2040685 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No Elementary PK 05 2019   grade_4 1 10 10 0   3     0   0   10 14                       24.0 1 10 10 0   3     0   0   10 14                 24
2040718 2040718 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No Elementary PK 08 2019   grade_4 33 6 16 0   2     0   0   31 26                       57.0 33 6 16 0   2     0   0   31 26                 57
2040728 2040728 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Patrick J Kennedy   Regular School No Elementary PK 05 2019   grade_4 1 4 48 0   3     0   0   35 21                       56.0 1 4 48 0   3     0   0   35 21                 56
2040759 2040759 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Roger Clap   Regular School No Elementary PK 05 2019   grade_4 4 14 7 0   2     0   0   11 16                       27.0 4 14 7 0   2     0   0   11 16                 27
2040780 2040780 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2019   grade_4 0 7 27 0   0     0   0   17 17                       34.0 0 7 27 0   0     0   0   17 17                 34
2040836 2040836 MA Suffolk   school 2502790 35   Boston 250279000337 350366 William E Russell   Regular School No Elementary PK 05 2019   grade_4 0 12 31 0   6     0   0   24 25                       49.0 0 12 31 0   6     0   0   24 25                 49
2040924 2040924 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2019   grade_4 17 13 11 0   6     0   0   23 24                       47.0 17 13 11 0   6     0   0   23 24                 47
2041063 2041063 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No Elementary PK 08 2019   grade_4 3 0 62 0   1     0   0   31 35                       66.0 3 0 62 0   1     0   0   31 35                 66
2041099 2041099 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2019   grade_4 0 4 4 0   0     0   0   6 2                       8.0 0 4 4 0   0     0   0   6 2                 8
2041163 2041163 MA Norfolk   school 2502940 40   Braintree 250294000367 400020 Mary E Flaherty School   Regular School No Elementary KG 05 2019   grade_4 42 4 6 0   18     0   0   31 39                       70.0 42 4 6 0   18     0   0   31 39                 70
2041206 2041206 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No Elementary PK 06 2019   grade_4 40 1 1 0   0     0   0   21 21                       42.0 40 1 1 0   0     0   0   21 21                 42
2041596 2041596 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver Elementary School   Regular School No Elementary PK 05 2019   grade_4 111 4 1 1   1     0   0   52 66                       118.0 111 4 1 1   1     0   0   52 66                 118
2041645 2041645 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No Elementary 01 04 2019   grade_4 16 4 104 1   3     0   0   73 55                       128.0 16 4 104 1   3     0   0   73 55                 128
2041756 2041756 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2019   grade_4 16 0 0 0   0     0   0   10 6                       16.0 16 0 0 0   0     0   0   10 6                 16
2041819 2041819 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No Elementary PK 06 2019   grade_4 15 0 2 0   0     0   0   10 7                       17.0 15 0 2 0   0     0   0   10 7                 17
2041826 2041826 MA Essex   school 2503990 71   Danvers 250399000532 710010 Highlands   Regular School No Elementary KG 05 2019   grade_4 58 1 6 0   1     0   0   32 34                       66.0 58 1 6 0   1     0   0   32 34                 66
2041839 2041839 MA Essex   school 2503990 71   Danvers 250399000536 710030 Riverside   Regular School No Elementary PK 05 2019   grade_4 47 2 3 0   2     0   0   33 21                       54.0 47 2 3 0   2     0   0   33 21                 54
2041908 2041908 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No Elementary 01 05 2019   grade_4 21 3 10 0   1     0   0   16 19                       35.0 21 3 10 0   1     0   0   16 19                 35
2042025 2042025 MA Hampshire   school 2504590 86   Easthampton 250459000613 860010 Maple   Regular School No Elementary PK 04 2019   grade_4 41 1 2 0   0     0   0   25 19                       44.0 41 1 2 0   0     0   0   25 19                 44
2042115 2042115 MA Middlesex   school 2504770 93   Everett 250477002118 930015 Webster School   Regular School No Elementary PK 05 2019   grade_4 16 2 20 0   4     0   0   26 16                       42.0 16 2 20 0   4     0   0   26 16                 42
2042121 2042121 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No Elementary KG 08 2019   grade_4 21 8 41 0   3     0   0   37 36                       73.0 21 8 41 0   3     0   0   37 36                 73
2042406 2042406 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2019   grade_4 24 4 47 0   4     0   0   45 34                       79.0 24 4 47 0   4     0   0   45 34                 79
2042412 2042412 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2019   grade_4 46 4 9 0   12     0   0   29 42                       71.0 46 4 9 0   12     0   0   29 42                 71
2042486 2042486 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Oak Street Elementary   Regular School No Elementary KG 05 2019   grade_4 53 1 1 0   2     0   0   26 31                       57.0 53 1 1 0   2     0   0   26 31                 57
2042492 2042492 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No Elementary KG 05 2019   grade_4 54 1 4 0   5     1   0   35 30                       65.0 54 1 4 0   5     1   0   35 30                 65
2042498 2042498 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No Elementary KG 05 2019   grade_4 38 0 0 0   0     1   0   21 18                       39.0 38 0 0 0   0     1   0   21 18                 39
2042564 2042564 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No Elementary KG 05 2019   grade_4 30 1 1 0   0     0   0   16 16                       32.0 30 1 1 0   0     0   0   16 16                 32
2042570 2042570 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No Elementary KG 05 2019   grade_4 24 1 5 0   0     0   0   11 19                       30.0 24 1 5 0   0     0   0   11 19                 30
2042576 2042576 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 West Parish   Regular School No Elementary KG 05 2019   grade_4 51 1 5 0   2     0   0   31 28                       59.0 51 1 5 0   2     0   0   31 28                 59
2042633 2042633 MA Franklin   school 2505490 114   Greenfield 250549000798 1140025 Discovery School at Four Corners   Regular School No Elementary KG 04 2019   grade_4 36 0 5 0   1     0   0   16 26                       42.0 36 0 5 0   1     0   0   16 26                 42
2042653 2042653 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No Elementary PK 06 2019   grade_4 23 3 1 0   1     1   0   13 16                       29.0 23 3 1 0   1     1   0   13 16                 29
2042680 2042680 MA Plymouth   school 2505790 122   Hanover 250579000827 1220004 Cedar Elementary   Regular School No Elementary PK 04 2019   grade_4 74 2 1 0   1     0   0   40 38                       78.0 74 2 1 0   1     0   0   40 38                 78
2042714 2042714 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2019   grade_4 33 0 3 0   0     0   0   21 15                       36.0 33 0 3 0   0     0   0   21 15                 36
2042768 2042768 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_4 1 0 4 1   0     0   0   5 *                       6.0 1 0 4 1   0     0   0   5                   6
2042811 2042811 MA Plymouth   school 2506090 131   Hingham 250609000876 1310010 Wm L Foster Elementary   Regular School No Elementary KG 05 2019   grade_4 58 1 3 0   0     0   0   31 31                       62.0 58 1 3 0   0     0   0   31 31                 62
2042853 2042853 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No Elementary PK 06 2019   grade_4 27 0 4 0   0     0   0   15 16                       31.0 27 0 4 0   0     0   0   15 16                 31
2042876 2042876 MA Hampden   school 2506270 137   Holyoke 250627001178 1370003 Joseph Metcalf School   Regular School No Elementary PK 04 2019   grade_4 6 1 22 0   0     0   0   11 18                       29.0 6 1 22 0   0     0   0   11 18                 29
2042892 2042892 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No Elementary PK 04 2019   grade_4 0 2 42 0   1     0   0   27 18                       45.0 0 2 42 0   1     0   0   27 18                 45
2042918 2042918 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No Elementary KG 08 2019   grade_4 6 2 46 0   1     0   0   29 26                       55.0 6 2 46 0   1     0   0   29 26                 55
2042928 2042928 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No Elementary PK 08 2019   grade_4 5 0 43 0   0     0   0   31 17                       48.0 5 0 43 0   0     0   0   31 17                 48
2042990 2042990 MA Middlesex   school 2506390 141   Hudson 250639000922 1410030 C A Farley   Regular School No Elementary PK 04 2019   grade_4 65 3 11 0   3     0   0   45 37                       82.0 65 3 11 0   3     0   0   45 37                 82
2043019 2043019 MA Essex   school 2506480 144   Ipswich 250648000936 1440007 Paul F Doyon Memorial   Regular School No Elementary PK 05 2019   grade_4 59 0 2 0   4     0   0   36 29                       65.0 59 0 2 0   4     0   0   36 29                 65
2043058 2043058 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No Elementary KG 04 2019   grade_4 1 1 132 0   0     0   0   75 59                       134.0 1 1 132 0   0     0   0   75 59                 134
2043062 2043062 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Middle 03 08 2019   grade_4 4 1 81 0   1     0   0   37 50                       87.0 4 1 81 0   1     0   0   37 50                 87
2043083 2043083 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No Elementary 01 04 2019   grade_4 8 6 127 0   0     0   0   71 70                       141.0 8 6 127 0   0     0   0   71 70                 141
2043095 2043095 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No Elementary 01 05 2019   grade_4 3 0 96 0   0     0   0   54 45                       99.0 3 0 96 0   0     0   0   54 45                 99
2043100 2043100 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2019   grade_4 6 0 90 0   1     0   0   56 41                       97.0 6 0 90 0   1     0   0   56 41                 97
2043109 2043109 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Edward F. Parthum   Regular School No Elementary PK 04 2019   grade_4 5 0 135 0   1     0   0   63 78                       141.0 5 0 135 0   1     0   0   63 78                 141
2043113 2043113 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2019   grade_4 1 0 57 0   0     0   0   30 28                       58.0 1 0 57 0   0     0   0   30 28                 58
2043119 2043119 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2019   grade_4 6 0 57 0   1     0   0   32 32                       64.0 6 0 57 0   1     0   0   32 32                 64
2043144 2043144 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2019   grade_4 1 0 13 0   0     0   0   10 4                       14.0 1 0 13 0   0     0   0   10 4                 14
2043246 2043246 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No Elementary PK 06 2019   grade_4 21 0 0 0   0     0   0   15 6                       21.0 21 0 0 0   0     0   0   15 6                 21
2043254 2043254 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Bridge   Regular School No Elementary KG 05 2019   grade_4 44 7 5 0   48     0   0   55 49                       104.0 44 7 5 0   48     0   0   55 49                 104
2043461 2043461 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No Elementary PK 08 2019   grade_4 7 3 20 0   18     0   0   21 27                       48.0 7 3 20 0   18     0   0   21 27                 48
2043585 2043585 MA Essex   school 2507110 163   Lynn 250711001087 1630040 Wm P Connery   Regular School No Elementary PK 05 2019   grade_4 9 5 70 0   15     0   0   54 45                       99.0 9 5 70 0   15     0   0   54 45                 99
2043625 2043625 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary KG 05 2019   grade_4 2 0 8 0   0     0   0   9 1                       10.0 2 0 8 0   0     0   0   9 1                 10
2043999 2043999 MA Middlesex   school 2507620 178   Melrose 250762001198 1780050 Winthrop   Regular School No Elementary KG 05 2019   grade_4 54 0 4 0   3     0   0   31 30                       61.0 54 0 4 0   3     0   0   31 30                 61
2044079 2044079 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Howe-Manning   Regular School No Elementary 03 06 2019   grade_4 83 0 2 0   4     0   0   43 46                       89.0 83 0 2 0   4     0   0   43 46                 89
2044183 2044183 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No Elementary PK 06 2019   grade_4 17 0 0 0   0     0   0   8 9                       17.0 17 0 0 0   0     0   0   8 9                 17
2044314 2044314 MA Bristol   school 2508430 201   New Bedford 250843001332 2010050 John B Devalles   Regular School No Elementary KG 05 2019   grade_4 25 9 30 0   1     0   0   34 31                       65.0 25 9 30 0   1     0   0   34 31                 65
2044880 2044880 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans Elementary   Regular School No Elementary KG 05 2019   grade_4 30 0 0 0   0     0   0   22 8                       30.0 30 0 0 0   0     0   0   22 8                 30
2044966 2044966 MA Essex   school 2509360 229   Peabody 250936001505 2290045 West Memorial   Regular School No Elementary PK 05 2019   grade_4 28 1 3 0   0     0   0   20 12                       32.0 28 1 3 0   0     0   0   20 12                 32
2044994 2044994 MA Plymouth   school 2509420 231   Pembroke 250942001509 2310010 Hobomock Elementary   Regular School No Elementary KG 06 2019   grade_4 51 0 0 0   0     0   0   32 19                       51.0 51 0 0 0   0     0   0   32 19                 51
2045016 2045016 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No Elementary KG 06 2019   grade_4 18 0 0 0   0     0   0   8 10                       18.0 18 0 0 0   0     0   0   8 10                 18
2045161 2045161 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Dennett Elementary   Regular School No Elementary KG 06 2019   grade_4 22 0 0 0   0     0   0   11 11                       22.0 22 0 0 0   0     0   0   11 11                 22
2045179 2045179 MA Norfolk   school 2509870 243   Quincy 250987000772 2430020 Beechwood Knoll Elementary   Regular School No Elementary KG 05 2019   grade_4 32 1 0 0   16     0   0   22 27                       49.0 32 1 0 0   16     0   0   22 27                 49
2045304 2045304 MA Middlesex   school 2509990 246   Reading 250999001604 2460002 Alice M Barrows   Regular School No Elementary KG 05 2019   grade_4 59 1 0 0   1     0   0   27 34                       61.0 59 1 0 0   1     0   0   27 34                 61
2045361 2045361 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2019   grade_4 29 6 48 0   2     0   0   39 46                       85.0 29 6 48 0   2     0   0   39 46                 85
2045380 2045380 MA Suffolk   school 2510050 248   Revere 251005001975 2480056 Garfield Elementary School   Regular School No Elementary PK 05 2019   grade_4 19 3 67 1   8     0   0   49 49                       98.0 19 3 67 1   8     0   0   49 49                 98
2045424 2045424 MA Plymouth   school 2510170 251   Rockland 251017001641 2510025 R Stewart Esten   Regular School No Elementary KG 04 2019   grade_4 54 9 11 0   0     0   0   42 32                       74.0 54 9 11 0   0     0   0   42 32                 74
2045445 2045445 MA Essex   school 2510200 252   Rockport 251020002533 2520005 Rockport Elementary   Regular School No Elementary PK 05 2019   grade_4 60 0 0 0   3     0   0   28 35                       63.0 60 0 0 0   3     0   0   28 35                 63
2045459 2045459 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No Elementary PK 06 2019   grade_4 10 0 0 0   0     0   0   6 4                       10.0 10 0 0 0   0     0   0   6 4                 10
2045531 2045531 MA Essex   school 2510500 262   Saugus 251050001680 2620040 Lynnhurst   Regular School No Elementary KG 05 2019   grade_4 25 2 15 0   2     1   0   20 25                       45.0 25 2 15 0   2     1   0   20 25                 45
2045565 2045565 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No Elementary PK 05 2019   grade_4 10 0 0 0   0     0   0   5 5                       10.0 10 0 0 0   0     0   0   5 5                 10
2045850 2045850 MA Hampden   school 2511130 281   Springfield 251113002723 2810005 Springfield Public Day Elementary School   Regular School No Elementary 01 05 2019   grade_4 4 1 17 0   0     0   0   19 3                       22.0 4 1 17 0   0     0   0   19 3                 22
2045884 2045884 MA Hampden   school 2511130 281   Springfield 251113001796 2810025 Brightwood   Regular School No Elementary PK 05 2019   grade_4 2 8 40 0   0     0   0   25 25                       50.0 2 8 40 0   0     0   0   25 25                 50
2045909 2045909 MA Hampden   school 2511130 281   Springfield 251113001807 2810050 Hiram L Dorman   Regular School No Elementary KG 05 2019   grade_4 2 11 39 0   0     0   0   24 28                       52.0 2 11 39 0   0     0   0   24 28                 52
2045974 2045974 MA Hampden   school 2511130 281   Springfield 251113001813 2810110 Kensington International School   Regular School No Elementary PK 05 2019   grade_4 1 7 32 0   0     0   0   14 26                       40.0 1 7 32 0   0     0   0   14 26                 40
2045980 2045980 MA Hampden   school 2511130 281   Springfield 251113001814 2810115 Liberty   Regular School No Elementary KG 05 2019   grade_4 4 6 34 0   1     0   0   23 22                       45.0 4 6 34 0   1     0   0   23 22                 45
2046019 2046019 MA Hampden   school 2511130 281   Springfield 251113001830 2810160 Sumner Avenue   Regular School No Elementary PK 05 2019   grade_4 5 15 54 0   2     0   0   40 36                       76.0 5 15 54 0   2     0   0   40 36                 76
2046025 2046025 MA Hampden   school 2511130 281   Springfield 251113001795 2810165 Arthur T Talmadge   Regular School No Elementary KG 05 2019   grade_4 9 10 20 0   0     0   0   23 16                       39.0 9 10 20 0   0     0   0   23 16                 39
2046031 2046031 MA Hampden   school 2511130 281   Springfield 251113001792 2810175 Alice B Beal Elementary   Regular School No Elementary KG 05 2019   grade_4 4 6 23 0   7     0   0   24 16                       40.0 4 6 23 0   7     0   0   24 16                 40

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