enrollments

Data source: Big Local News · About: Big Local

9,565 rows where state = "MA" and year = 2019 sorted by ccd_school_lvl

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 9,565 ✖
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
2039811 2039811 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Elementary 03 04 2019   grade_3 108 5 8 0   5     1   2   55 74                       129.0 108 5 8 0   5     1   2   55 74                 129
2039812 2039812 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Elementary 03 04 2019   grade_4 143 3 13 0   4     0   2   93 72                       165.0 143 3 13 0   4     0   2   93 72                 165
2039813 2039813 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2019   kindergarten 130 10 5 1   6     0   1   79 74                       153.0 130 10 5 1   6     0   1   79 74                 153
2039814 2039814 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2019   grade_1 119 7 9 3   3     0   1   66 76                       142.0 119 7 9 3   3     0   1   66 76                 142
2039815 2039815 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2019   grade_2 133 5 19 1   2     0   0   85 75                       160.0 133 5 19 1   2     0   0   85 75                 160
2039825 2039825 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten 44 0 1 0   0     0   1   22 24                       46.0 44 0 1 0   0     0   1   22 24                 46
2039826 2039826 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2019   kindergarten 113 0 2 0   1     0   5   60 61                       121.0 113 0 2 0   1     0   5   60 61                 121
2039827 2039827 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2019   grade_1 95 3 4 0   1     0   2   55 50                       105.0 95 3 4 0   1     0   2   55 50                 105
2039828 2039828 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2019   grade_2 71 1 4 1   0     0   3   40 40                       80.0 71 1 4 1   0     0   3   40 40                 80
2039829 2039829 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2019   grade_3 98 0 5 0   0     0   6   57 52                       109.0 98 0 5 0   0     0   6   57 52                 109
2039830 2039830 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2019   grade_4 95 0 7 0   0     0   2   48 56                       104.0 95 0 7 0   0     0   2   48 56                 104
2039836 2039836 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2019   kindergarten 27 1 8 0   3     0   0   22 17                       39.0 27 1 8 0   3     0   0   22 17                 39
2039837 2039837 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2019   grade_1 28 1 7 0   3     0   0   17 22                       39.0 28 1 7 0   3     0   0   17 22                 39
2039838 2039838 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2019   grade_2 60 2 3 0   0     1   1   30 37                       67.0 60 2 3 0   0     1   1   30 37                 67
2039839 2039839 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2019   grade_3 36 1 9 0   0     0   2   23 25                       48.0 36 1 9 0   0     0   2   23 25                 48
2039840 2039840 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2019   grade_4 52 0 11 0   1     0   1   38 27                       65.0 52 0 11 0   1     0   1   38 27                 65
2039841 2039841 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2019   kindergarten 52 0 3 0   2     0   1   36 22                       58.0 52 0 3 0   2     0   1   36 22                 58
2039842 2039842 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2019   grade_1 57 1 4 0   2     0   6   42 28                       70.0 57 1 4 0   2     0   6   42 28                 70
2039843 2039843 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2019   grade_2 77 1 5 0   1     0   1   38 47                       85.0 77 1 5 0   1     0   1   38 47                 85
2039844 2039844 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2019   grade_3 56 0 2 0   2     0   0   35 25                       60.0 56 0 2 0   2     0   0   35 25                 60
2039845 2039845 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2019   grade_4 66 4 2 0   1     0   2   51 24                       75.0 66 4 2 0   1     0   2   51 24                 75
2039846 2039846 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2019   kindergarten 60 2 8 0   3     0   4   37 40                       77.0 60 2 8 0   3     0   4   37 40                 77
2039847 2039847 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2019   grade_1 53 4 9 0   3     0   2   37 34                       71.0 53 4 9 0   3     0   2   37 34                 71
2039848 2039848 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2019   grade_2 64 3 7 0   1     0   3   38 40                       78.0 64 3 7 0   1     0   3   38 40                 78
2039849 2039849 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2019   grade_3 66 1 6 0   3     0   2   38 40                       78.0 66 1 6 0   3     0   2   38 40                 78
2039850 2039850 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2019   grade_4 44 2 7 0   5     0   3   33 28                       61.0 44 2 7 0   5     0   3   33 28                 61
2039851 2039851 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2019   kindergarten 56 0 4 0   4     0   2   33 33                       66.0 56 0 4 0   4     0   2   33 33                 66
2039852 2039852 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2019   grade_1 46 2 8 0   2     0   2   30 30                       60.0 46 2 8 0   2     0   2   30 30                 60
2039853 2039853 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2019   grade_2 51 2 6 0   2     0   2   37 26                       63.0 51 2 6 0   2     0   2   37 26                 63
2039854 2039854 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2019   grade_3 56 1 7 0   1     0   3   35 33                       68.0 56 1 7 0   1     0   3   35 33                 68
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
2039865 2039865 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2019   pre_kindergarten 27 0 1 0   0     0   0   16 12                       28.0 27 0 1 0   0     0   0   16 12                 28
2039866 2039866 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2019   kindergarten 47 0 3 0   0     1   2   25 28                       53.0 47 0 3 0   0     1   2   25 28                 53
2039867 2039867 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2019   grade_1 59 0 7 0   0     0   5   42 29                       71.0 59 0 7 0   0     0   5   42 29                 71
2039868 2039868 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2019   grade_2 53 2 5 0   1     0   3   39 25                       64.0 53 2 5 0   1     0   3   39 25                 64
2039869 2039869 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2019   grade_3 61 2 2 1   0     0   4   30 40                       70.0 61 2 2 1   0     0   4   30 40                 70
2039870 2039870 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2019   grade_4 71 1 7 0   2     0   7   48 40                       88.0 71 1 7 0   2     0   7   48 40                 88
2039871 2039871 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2019   pre_kindergarten 23 0 2 0   0     0   1   11 15                       26.0 23 0 2 0   0     0   1   11 15                 26
2039872 2039872 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2019   kindergarten 54 0 5 0   1     0   3   38 25                       63.0 54 0 5 0   1     0   3   38 25                 63
2039873 2039873 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2019   grade_1 62 2 8 0   1     0   2   38 37                       75.0 62 2 8 0   1     0   2   38 37                 75
2039874 2039874 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2019   grade_2 59 4 8 0   1     0   2   37 37                       74.0 59 4 8 0   1     0   2   37 37                 74
2039875 2039875 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2019   grade_3 82 2 10 0   2     0   1   59 38                       97.0 82 2 10 0   2     0   1   59 38                 97
2039876 2039876 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2019   grade_4 78 1 6 1   2     0   1   49 40                       89.0 78 1 6 1   2     0   1   49 40                 89
2039890 2039890 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten 18 7 9 0   11     0   3   29 19                       48.0 18 7 9 0   11     0   3   29 19                 48
2039891 2039891 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2019   kindergarten 32 3 15 0   6     0   7   32 31                       63.0 32 3 15 0   6     0   7   32 31                 63
2039892 2039892 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2019   grade_1 18 4 8 2   3     0   5   21 18                       40.0 18 4 8 2   3     0   5   21 18                 40
2039893 2039893 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2019   grade_2 19 3 9 0   5     0   7   23 20                       43.0 19 3 9 0   5     0   7   23 20                 43
2039894 2039894 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2019   grade_3 25 7 12 0   9     0   0   29 24                       53.0 25 7 12 0   9     0   0   29 24                 53
2039895 2039895 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2019   grade_4 22 4 17 0   7     0   3   28 25                       53.0 22 4 17 0   7     0   3   28 25                 53
2039896 2039896 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2019   grade_5 26 3 21 0   6     0   6   36 26                       62.0 26 3 21 0   6     0   6   36 26                 62
2039897 2039897 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2019   grade_6 13 6 7 0   4     0   2   17 15                       32.0 13 6 7 0   4     0   2   17 15                 32
2039898 2039898 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2019   kindergarten 20 1 7 0   5     0   5   25 13                       38.0 20 1 7 0   5     0   5   25 13                 38
2039899 2039899 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2019   grade_1 14 2 9 0   5     0   3   12 21                       33.0 14 2 9 0   5     0   3   12 21                 33
2039900 2039900 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2019   grade_2 19 6 11 0   8     0   3   19 28                       47.0 19 6 11 0   8     0   3   19 28                 47
2039901 2039901 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2019   grade_3 20 4 7 0   9     0   1   20 21                       41.0 20 4 7 0   9     0   1   20 21                 41
2039902 2039902 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2019   grade_4 20 1 10 0   8     0   3   21 21                       42.0 20 1 10 0   8     0   3   21 21                 42
2039903 2039903 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2019   grade_5 25 6 10 0   4     0   2   18 29                       47.0 25 6 10 0   4     0   2   18 29                 47
2039904 2039904 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2019   grade_6 35 3 14 0   9     0   6   43 24                       67.0 35 3 14 0   9     0   6   43 24                 67
2039905 2039905 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2019   kindergarten 23 8 14 1   8     0   5   29 30                       59.0 23 8 14 1   8     0   5   29 30                 59
2039906 2039906 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2019   grade_1 30 5 10 0   10     0   5   28 32                       60.0 30 5 10 0   10     0   5   28 32                 60
2039907 2039907 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2019   grade_2 27 6 11 0   8     0   1   24 29                       53.0 27 6 11 0   8     0   1   24 29                 53
2039908 2039908 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2019   grade_3 31 8 12 0   8     0   2   34 27                       61.0 31 8 12 0   8     0   2   34 27                 61
2039909 2039909 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2019   grade_4 30 4 8 0   8     0   6   35 21                       56.0 30 4 8 0   8     0   6   35 21                 56
2039910 2039910 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2019   grade_5 35 4 11 0   9     0   7   33 33                       66.0 35 4 11 0   9     0   7   33 33                 66
2039911 2039911 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2019   grade_6 30 3 10 0   13     0   11   39 28                       67.0 30 3 10 0   13     0   11   39 28                 67
2039912 2039912 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2019   kindergarten 62 0 9 0   6     0   9   41 45                       86.0 62 0 9 0   6     0   9   41 45                 86
2039913 2039913 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2019   grade_1 82 2 2 0   9     0   1   48 48                       96.0 82 2 2 0   9     0   1   48 48                 96
2039914 2039914 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2019   grade_2 66 1 5 0   9     0   7   54 34                       88.0 66 1 5 0   9     0   7   54 34                 88
2039915 2039915 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2019   grade_3 79 2 7 0   9     0   6   57 46                       103.0 79 2 7 0   9     0   6   57 46                 103
2039916 2039916 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2019   grade_4 79 4 6 0   12     0   5   54 52                       106.0 79 4 6 0   12     0   5   54 52                 106
2039917 2039917 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2019   grade_5 80 4 11 0   8     0   7   54 56                       110.0 80 4 11 0   8     0   7   54 56                 110
2039918 2039918 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No Elementary KG 05 2019   kindergarten 49 4 8 1   24     0   7   53 39                       93.0 49 4 8 1   24     0   7   53 39                 93
2039919 2039919 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No Elementary KG 05 2019   grade_1 40 3 6 0   21     0   3   46 27                       73.0 40 3 6 0   21     0   3   46 27                 73
2039920 2039920 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No Elementary KG 05 2019   grade_2 50 4 4 0   19     0   6   36 47                       83.0 50 4 4 0   19     0   6   36 47                 83
2039921 2039921 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No Elementary KG 05 2019   grade_3 49 3 6 0   27     0   4   48 41                       89.0 49 3 6 0   27     0   4   48 41                 89
2039922 2039922 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No Elementary KG 05 2019   grade_4 47 1 11 0   29     0   5   52 41                       93.0 47 1 11 0   29     0   5   52 41                 93
2039923 2039923 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No Elementary KG 05 2019   grade_5 61 3 7 0   34     1   5   51 60                       111.0 61 3 7 0   34     1   5   51 60                 111
2039925 2039925 MA Essex   school 2501950 9   Andover 250195000048 90010 Henry C Sanborn Elementary   Regular School No Elementary KG 05 2019   kindergarten 40 0 5 0   10     0   3   31 27                       58.0 40 0 5 0   10     0   3   31 27                 58
2039926 2039926 MA Essex   school 2501950 9   Andover 250195000048 90010 Henry C Sanborn Elementary   Regular School No Elementary KG 05 2019   grade_1 35 1 6 0   9     0   1   21 31                       52.0 35 1 6 0   9     0   1   21 31                 52
2039927 2039927 MA Essex   school 2501950 9   Andover 250195000048 90010 Henry C Sanborn Elementary   Regular School No Elementary KG 05 2019   grade_2 33 3 7 0   17     0   2   30 32                       62.0 33 3 7 0   17     0   2   30 32                 62
2039928 2039928 MA Essex   school 2501950 9   Andover 250195000048 90010 Henry C Sanborn Elementary   Regular School No Elementary KG 05 2019   grade_3 49 1 0 0   19     0   1   34 36                       70.0 49 1 0 0   19     0   1   34 36                 70
2039929 2039929 MA Essex   school 2501950 9   Andover 250195000048 90010 Henry C Sanborn Elementary   Regular School No Elementary KG 05 2019   grade_4 45 4 4 0   20     0   2   39 36                       75.0 45 4 4 0   20     0   2   39 36                 75
2039930 2039930 MA Essex   school 2501950 9   Andover 250195000048 90010 Henry C Sanborn Elementary   Regular School No Elementary KG 05 2019   grade_5 48 2 2 0   13     0   2   47 20                       67.0 48 2 2 0   13     0   2   47 20                 67
2039931 2039931 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No Elementary KG 05 2019   kindergarten 54 0 5 0   12     0   4   39 36                       75.0 54 0 5 0   12     0   4   39 36                 75
2039932 2039932 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No Elementary KG 05 2019   grade_1 56 1 1 1   13     0   2   39 35                       74.0 56 1 1 1   13     0   2   39 35                 74
2039933 2039933 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No Elementary KG 05 2019   grade_2 73 0 1 0   8     0   0   46 36                       82.0 73 0 1 0   8     0   0   46 36                 82
2039934 2039934 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No Elementary KG 05 2019   grade_3 69 2 6 1   15     0   2   43 52                       95.0 69 2 6 1   15     0   2   43 52                 95
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
2039936 2039936 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No Elementary KG 05 2019   grade_5 69 0 1 0   17     0   0   37 50                       87.0 69 0 1 0   17     0   0   37 50                 87
2039937 2039937 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2019   kindergarten 66 3 7 0   13     0   5   47 47                       94.0 66 3 7 0   13     0   5   47 47                 94
2039938 2039938 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2019   grade_1 63 2 5 0   17     0   0   46 41                       87.0 63 2 5 0   17     0   0   46 41                 87
2039939 2039939 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2019   grade_2 75 2 6 0   19     0   1   49 54                       103.0 75 2 6 0   19     0   1   49 54                 103
2039940 2039940 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2019   grade_3 69 1 7 0   20     0   1   46 52                       98.0 69 1 7 0   20     0   1   46 52                 98
2039941 2039941 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2019   grade_4 88 1 5 0   16     0   5   53 62                       115.0 88 1 5 0   16     0   5   53 62                 115
2039942 2039942 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2019   grade_5 66 7 11 0   19     0   1   43 61                       104.0 66 7 11 0   19     0   1   43 61                 104
2039957 2039957 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2019   kindergarten 61 3 5 0   14     0   9   50 42                       92.0 61 3 5 0   14     0   9   50 42                 92
2039958 2039958 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2019   grade_1 41 4 0 0   14     0   8   40 27                       67.0 41 4 0 0   14     0   8   40 27                 67
2039959 2039959 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2019   grade_2 54 4 2 0   14     0   1   44 31                       75.0 54 4 2 0   14     0   1   44 31                 75
2039960 2039960 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2019   grade_3 52 0 1 0   15     2   5   37 38                       75.0 52 0 1 0   15     2   5   37 38                 75
2039961 2039961 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2019   grade_4 51 3 2 0   11     0   5   42 30                       72.0 51 3 2 0   11     0   5   42 30                 72

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