Data source: Big Local News · About: Big Local

70,226 rows where state = "MA" sorted by free_and_reduced_int

View and edit SQL

grade

year

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
735658 MA Plymouth   school 2501650 1   Abington 250165002727 10002 Center Elementary School   Regular School No 1 PK KG 2015   kindergarten 138 2 3 2   3     0   0   80 68                       148 138 2 3 2   3     0   0   80 68                 148
735659 MA Plymouth   school 2501650 1   Abington 250165002727 10002 Center Elementary School   Regular School No 1 PK KG 2015   pre_kindergarten 71 1 1 0   3     0   0   48 28                       76 71 1 1 0   3     0   0   48 28                 76
735660 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No 1 01 04 2015   grade_1 117 3 7 1   3     0   0   72 59                       131 117 3 7 1   3     0   0   72 59                 131
735661 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No 1 01 04 2015   grade_2 133 1 5 1   3     0   0   78 65                       143 133 1 5 1   3     0   0   78 65                 143
735662 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No 1 01 04 2015   grade_3 168 0 5 0   1     0   0   90 84                       174 168 0 5 0   1     0   0   90 84                 174
735663 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No 1 01 04 2015   grade_4 162 6 0 1   3     0   0   81 91                       172 162 6 0 1   3     0   0   81 91                 172
735664 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No 2 05 06 2015   grade_5 146 1 6 0   3     0   0   84 72                       156 146 1 6 0   3     0   0   84 72                 156
735665 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No 2 05 06 2015   grade_6 158 7 6 1   2     0   0   94 80                       174 158 7 6 1   2     0   0   94 80                 174
735666 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Frolio Middle School   Regular School No 2 07 08 2015   grade_7 146 2 4 0   2     0   2   77 79                       156 146 2 4 0   2     0   2   77 79                 156
735667 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Frolio Middle School   Regular School No 2 07 08 2015   grade_8 131 6 7 0   4     1   0   74 75                       149 131 6 7 0   4     1   0   74 75                 149
735668 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2015   grade_9 113 1 15 0   0     0   2   61 70                       131 113 1 15 0   0     0   2   61 70                 131
735669 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2015   grade_10 82 3 10 0   0     0   1   46 50                       96 82 3 10 0   0     0   1   46 50                 96
735670 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2015   grade_11 105 6 2 0   2     0   2   59 58                       117 105 6 2 0   2     0   2   59 58                 117
735671 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2015   grade_12 117 1 8 0   2     0   0   57 71                       128 117 1 8 0   2     0   0   57 71                 128
735672 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2015   SP * * * *   *     *   *                             5                                             5
735673 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No 1 PK 04 2015   kindergarten 92 0 4 0   0     0   0   45 51                       96 92 0 4 0   0     0   0   45 51                 96
735674 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No 1 PK 04 2015   pre_kindergarten 48 0 1 0   0     0   2   27 24                       51 48 0 1 0   0     0   2   27 24                 51
735675 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No 1 PK 04 2015   grade_1 101 0 0 0   0     0   0   58 43                       101 101 0 0 0   0     0   0   58 43                 101
735676 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No 1 PK 04 2015   grade_2 85 0 2 0   0     0   0   50 37                       87 85 0 2 0   0     0   0   50 37                 87
735677 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No 1 PK 04 2015   grade_3 103 1 1 0   0     0   0   58 47                       105 103 1 1 0   0     0   0   58 47                 105
735678 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No 1 PK 04 2015   grade_4 113 0 0 0   0     0   0   59 54                       113 113 0 0 0   0     0   0   59 54                 113
735679 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No 2 05 08 2015   grade_5 76 0 2 0   0     0   0   40 38                       78 76 0 2 0   0     0   0   40 38                 78
735680 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No 2 05 08 2015   grade_6 113 1 1 0   1     0   0   55 61                       116 113 1 1 0   1     0   0   55 61                 116
735681 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No 2 05 08 2015   grade_7 108 1 1 0   1     0   0   55 56                       111 108 1 1 0   1     0   0   55 56                 111
735682 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No 2 05 08 2015   grade_8 114 0 0 0   1     0   0   55 60                       115 114 0 0 0   1     0   0   55 60                 115
735683 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam Early Childhood Center   Regular School No 1 PK PK 2015   pre_kindergarten 154 2 7 0   2     0   0   105 60                       165 154 2 7 0   2     0   0   105 60                 165
735684 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No 1 KG 04 2015   kindergarten 44 0 7 0   2     0   1   32 22                       54 44 0 7 0   2     0   1   32 22                 54
735685 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No 1 KG 04 2015   grade_1 44 0 7 0   1     0   3   25 30                       55 44 0 7 0   1     0   3   25 30                 55
735686 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No 1 KG 04 2015   grade_2 61 0 0 0   1     1   1   29 35                       64 61 0 0 0   1     1   1   29 35                 64
735687 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No 1 KG 04 2015   grade_3 60 1 2 0   2     0   1   38 28                       66 60 1 2 0   2     0   1   38 28                 66
735688 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No 1 KG 04 2015   grade_4 53 2 8 0   1     0   0   32 32                       64 53 2 8 0   1     0   0   32 32                 64
735689 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No 1 KG 04 2015   kindergarten 75 0 0 0   1     0   0   48 28                       76 75 0 0 0   1     0   0   48 28                 76
735690 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No 1 KG 04 2015   grade_1 81 0 6 0   3     0   4   46 48                       94 81 0 6 0   3     0   4   46 48                 94
735691 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No 1 KG 04 2015   grade_2 64 3 6 0   2     0   4   36 43                       79 64 3 6 0   2     0   4   36 43                 79
735692 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No 1 KG 04 2015   grade_3 64 4 2 0   5     0   1   35 41                       76 64 4 2 0   5     0   1   35 41                 76
735693 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No 1 KG 04 2015   grade_4 68 1 6 0   5     0   1   41 40                       81 68 1 6 0   5     0   1   41 40                 81
735694 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No 1 KG 04 2015   kindergarten 55 3 8 0   3     0   2   38 33                       71 55 3 8 0   3     0   2   38 33                 71
735695 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No 1 KG 04 2015   grade_1 60 0 8 0   3     0   2   32 41                       73 60 0 8 0   3     0   2   32 41                 73
735696 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No 1 KG 04 2015   grade_2 75 2 3 0   0     0   1   42 39                       81 75 2 3 0   0     0   1   42 39                 81
735697 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No 1 KG 04 2015   grade_3 73 3 5 0   4     0   6   54 37                       91 73 3 5 0   4     0   6   54 37                 91
735698 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No 1 KG 04 2015   grade_4 68 1 6 0   4     0   3   41 41                       82 68 1 6 0   4     0   3   41 41                 82
735699 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No 1 KG 04 2015   kindergarten 44 4 3 0   1     0   0   26 26                       52 44 4 3 0   1     0   0   26 26                 52
735700 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No 1 KG 04 2015   grade_1 63 1 4 0   3     0   2   36 37                       73 63 1 4 0   3     0   2   36 37                 73
735701 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No 1 KG 04 2015   grade_2 53 1 6 0   2     0   0   29 33                       62 53 1 6 0   2     0   0   29 33                 62
735702 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No 1 KG 04 2015   grade_3 53 0 5 0   2     0   1   32 29                       61 53 0 5 0   2     0   1   32 29                 61
735703 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No 1 KG 04 2015   grade_4 69 3 4 0   5     0   3   46 38                       84 69 3 4 0   5     0   3   46 38                 84
735704 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No 2 05 08 2015   grade_5 226 4 18 0   8     0   10   120 146                       266 226 4 18 0   8     0   10   120 146                 266
735705 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No 2 05 08 2015   grade_6 278 3 21 0   3     0   11   146 170                       316 278 3 21 0   3     0   11   146 170                 316
735706 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No 2 05 08 2015   grade_7 * * * *   *     *   *   2 1                       3                         2 1                 3
735707 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No 2 05 08 2015   grade_8 * * * *   *     *   *   2 3                       5                         2 3                 5
735708 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam Junior High   Regular School No 2 07 08 2015   grade_7 276 3 12 0   5     0   4   153 147                       300 276 3 12 0   5     0   4   153 147                 300
735709 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam Junior High   Regular School No 2 07 08 2015   grade_8 280 5 21 0   6     0   5   161 156                       317 280 5 21 0   6     0   5   161 156                 317
735710 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No 3 09 12 2015   grade_9 281 6 15 0   7     1   7   172 145                       317 281 6 15 0   7     1   7   172 145                 317
735711 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No 3 09 12 2015   grade_10 303 3 18 1   10     0   4   171 168                       339 303 3 18 1   10     0   4   171 168                 339
735712 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No 3 09 12 2015   grade_11 288 7 19 1   6     1   7   171 158                       329 288 7 19 1   6     1   7   171 158                 329
735713 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No 3 09 12 2015   grade_12 267 6 8 2   7     2   3   153 142                       295 267 6 8 2   7     2   3   153 142                 295
735714 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No 1 PK 04 2015   kindergarten 53 24 2 1   0     0   7   45 42                       87 53 24 2 1   0     0   7   45 42                 87
735715 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No 1 PK 04 2015   pre_kindergarten 22 4 3 0   0     0   0   14 15                       29 22 4 3 0   0     0   0   14 15                 29
735716 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No 1 PK 04 2015   grade_1 73 4 4 0   0     0   2   44 39                       83 73 4 4 0   0     0   2   44 39                 83
735717 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No 1 PK 04 2015   grade_2 71 0 1 0   1     0   1   39 35                       74 71 0 1 0   1     0   1   39 35                 74
735718 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No 1 PK 04 2015   grade_3 76 2 6 0   0     0   2   35 51                       86 76 2 6 0   0     0   2   35 51                 86
735719 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No 1 PK 04 2015   grade_4 64 4 3 0   0     0   3   42 32                       74 64 4 3 0   0     0   3   42 32                 74
735720 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No 1 PK 04 2015   kindergarten 67 4 5 1   3     0   3   45 38                       83 67 4 5 1   3     0   3   45 38                 83
735721 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No 1 PK 04 2015   pre_kindergarten 34 0 2 0   0     0   0   24 12                       36 34 0 2 0   0     0   0   24 12                 36
735722 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No 1 PK 04 2015   grade_1 76 4 9 0   1     0   3   50 43                       93 76 4 9 0   1     0   3   50 43                 93
735723 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No 1 PK 04 2015   grade_2 76 2 9 0   1     1   4   44 49                       93 76 2 9 0   1     1   4   44 49                 93
735724 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No 1 PK 04 2015   grade_3 89 3 7 0   5     1   1   53 53                       106 89 3 7 0   5     1   1   53 53                 106
735725 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No 1 PK 04 2015   grade_4 82 2 3 0   0     0   4   44 47                       91 82 2 3 0   0     0   4   44 47                 91
735726 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No 2 05 08 2015   grade_5 166 1 3 0   3     0   4   96 81                       177 166 1 3 0   3     0   4   96 81                 177
735727 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No 2 05 08 2015   grade_6 150 4 11 0   1     0   9   95 80                       175 150 4 11 0   1     0   9   95 80                 175
735728 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No 2 05 08 2015   grade_7 174 4 7 0   2     0   5   94 98                       192 174 4 7 0   2     0   5   94 98                 192
735729 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No 2 05 08 2015   grade_8 159 6 8 0   0     0   7   105 75                       180 159 6 8 0   0     0   7   105 75                 180
735730 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No 3 09 12 2015   grade_9 147 0 8 0   1     0   4   91 69                       160 147 0 8 0   1     0   4   91 69                 160
735731 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No 3 09 12 2015   grade_10 146 2 6 0   0     0   0   80 74                       154 146 2 6 0   0     0   0   80 74                 154
735732 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No 3 09 12 2015   grade_11 149 1 9 0   2     0   7   86 82                       168 149 1 9 0   2     0   7   86 82                 168
735733 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No 3 09 12 2015   grade_12 128 0 4 0   2     0   2   73 63                       136 128 0 4 0   2     0   2   73 63                 136
735734 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No 3 09 12 2015   SP * * * *   *     *   *                             3                                             3
735735 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No 1 PK 06 2015   kindergarten 18 0 12 0   7     0   3   19 21                       40 18 0 12 0   7     0   3   19 21                 40
735736 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No 1 PK 06 2015   pre_kindergarten 29 8 7 0   16     0   1   35 26                       61 29 8 7 0   16     0   1   35 26                 61
735737 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No 1 PK 06 2015   grade_1 18 4 17 0   10     0   6   33 22                       55 18 4 17 0   10     0   6   33 22                 55
735738 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No 1 PK 06 2015   grade_2 13 7 11 0   8     0   4   24 19                       43 13 7 11 0   8     0   4   24 19                 43
735739 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No 1 PK 06 2015   grade_3 30 4 16 0   2     0   8   24 36                       60 30 4 16 0   2     0   8   24 36                 60
735740 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No 1 PK 06 2015   grade_4 25 7 12 0   7     0   3   27 27                       54 25 7 12 0   7     0   3   27 27                 54
735741 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No 1 PK 06 2015   grade_5 27 2 6 0   11     0   1   23 24                       47 27 2 6 0   11     0   1   23 24                 47
735742 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No 1 PK 06 2015   grade_6 32 6 12 0   5     1   6   33 29                       62 32 6 12 0   5     1   6   33 29                 62
735743 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No 1 KG 06 2015   kindergarten 22 1 11 0   6     0   3   22 21                       43 22 1 11 0   6     0   3   22 21                 43
735744 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No 1 KG 06 2015   grade_1 22 2 10 1   6     0   2   18 25                       43 22 2 10 1   6     0   2   18 25                 43
735745 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No 1 KG 06 2015   grade_2 30 8 13 1   10     0   3   39 26                       65 30 8 13 1   10     0   3   39 26                 65
735746 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No 1 KG 06 2015   grade_3 23 7 19 0   5     0   4   29 29                       58 23 7 19 0   5     0   4   29 29                 58
735747 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No 1 KG 06 2015   grade_4 21 4 9 0   7     0   4   25 20                       45 21 4 9 0   7     0   4   25 20                 45
735748 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No 1 KG 06 2015   grade_5 36 3 11 1   6     1   2   25 35                       60 36 3 11 1   6     1   2   25 35                 60
735749 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No 1 KG 06 2015   grade_6 27 3 10 0   8     0   4   18 34                       52 27 3 10 0   8     0   4   18 34                 52
735750 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No 1 KG 06 2015   kindergarten 25 5 11 0   11     0   5   29 28                       57 25 5 11 0   11     0   5   29 28                 57
735751 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No 1 KG 06 2015   grade_1 26 1 10 0   7     0   7   27 24                       51 26 1 10 0   7     0   7   27 24                 51
735752 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No 1 KG 06 2015   grade_2 33 6 6 0   11     0   8   33 31                       64 33 6 6 0   11     0   8   33 31                 64
735753 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No 1 KG 06 2015   grade_3 24 5 12 0   4     0   4   25 24                       49 24 5 12 0   4     0   4   25 24                 49
735754 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No 1 KG 06 2015   grade_4 30 6 7 0   6     0   6   29 26                       55 30 6 7 0   6     0   6   29 26                 55
735755 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No 1 KG 06 2015   grade_5 39 7 11 0   6     0   3   35 31                       66 39 7 11 0   6     0   3   35 31                 66
735756 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No 1 KG 06 2015   grade_6 34 7 14 0   8     0   7   34 36                       70 34 7 14 0   8     0   7   34 36                 70
735757 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No 1 KG 05 2015   kindergarten 49 5 4 1   2     0   4   29 36                       65 49 5 4 1   2     0   4   29 36                 65

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