enrollments

Data source: Big Local News · About: Big Local

11,264 rows where state = "MA" and year = 2017 sorted by ccd_school_lvl

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 11,264 ✖
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
1121946 1121946 MA Plymouth   school 2501650 1   Abington 250165002727 10002 Center Elementary School   Regular School No Elementary PK KG 2017   kindergarten 115 5 12 0   2     0   0   73 61                       134 115 5 12 0   2     0   0   73 61                 134
1121947 1121947 MA Plymouth   school 2501650 1   Abington 250165002727 10002 Center Elementary School   Regular School No Elementary PK KG 2017   pre_kindergarten 57 3 5 0   4     0   0   37 32                       69 57 3 5 0   4     0   0   37 32                 69
1121948 1121948 MA Plymouth   school 2501650 1   Abington 250165002727 10002 Center Elementary School   Regular School No Elementary PK KG 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121949 1121949 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No Elementary 01 04 2017   grade_1 109 1 10 1   3     1   0   52 73                       125 109 1 10 1   3     1   0   52 73                 125
1121950 1121950 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No Elementary 01 04 2017   grade_2 147 3 11 0   3     0   0   89 75                       164 147 3 11 0   3     0   0   89 75                 164
1121951 1121951 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No Elementary 01 04 2017   grade_3 127 5 11 1   3     0   1   77 71                       148 127 5 11 1   3     0   1   77 71                 148
1121952 1121952 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No Elementary 01 04 2017   grade_4 130 2 7 1   2     0   1   73 70                       143 130 2 7 1   2     0   1   73 70                 143
1121953 1121953 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No Elementary 01 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121965 1121965 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   kindergarten 75 1 4 1   0     0   3   43 41                       84 75 1 4 1   0     0   3   43 41                 84
1121966 1121966 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   pre_kindergarten 43 2 2 0   1     0   2   25 25                       50 43 2 2 0   1     0   2   25 25                 50
1121967 1121967 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   grade_1 88 0 4 0   0     0   7   55 44                       99 88 0 4 0   0     0   7   55 44                 99
1121968 1121968 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   grade_2 92 1 6 0   0     0   3   44 58                       102 92 1 6 0   0     0   3   44 58                 102
1121969 1121969 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   grade_3 107 0 0 0   0     0   0   62 45                       107 107 0 0 0   0     0   0   62 45                 107
1121970 1121970 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   grade_4 94 0 2 0   0     0   0   57 39                       96 94 0 2 0   0     0   0   57 39                 96
1121971 1121971 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121977 1121977 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam Early Childhood Center   Regular School No Elementary PK PK 2017   pre_kindergarten 108 7 19 0   13     0   4   87 64                       151 108 7 19 0   13     0   4   87 64                 151
1121978 1121978 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam Early Childhood Center   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121979 1121979 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2017   kindergarten 56 1 2 0   0     1   0   28 32                       60 56 1 2 0   0     1   0   28 32                 60
1121980 1121980 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2017   grade_1 32 1 8 0   0     0   2   23 20                       43 32 1 8 0   0     0   2   23 20                 43
1121981 1121981 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2017   grade_2 53 0 11 0   1     0   1   39 27                       66 53 0 11 0   1     0   1   39 27                 66
1121982 1121982 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2017   grade_3 52 0 7 0   1     0   4   28 36                       64 52 0 7 0   1     0   4   28 36                 64
1121983 1121983 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2017   grade_4 56 2 0 0   1     0   1   29 31                       60 56 2 0 0   1     0   1   29 31                 60
1121984 1121984 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121985 1121985 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2017   kindergarten 85 0 3 0   2     0   1   38 53                       91 85 0 3 0   2     0   1   38 53                 91
1121986 1121986 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2017   grade_1 57 1 1 0   3     0   0   38 24                       62 57 1 1 0   3     0   0   38 24                 62
1121987 1121987 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2017   grade_2 66 3 2 0   1     0   0   51 21                       72 66 3 2 0   1     0   0   51 21                 72
1121988 1121988 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2017   grade_3 71 0 7 0   4     0   4   43 43                       86 71 0 7 0   4     0   4   43 43                 86
1121989 1121989 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2017   grade_4 60 4 6 0   1     0   3   33 41                       74 60 4 6 0   1     0   3   33 41                 74
1121990 1121990 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121991 1121991 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2017   kindergarten 66 2 6 0   1     0   3   45 33                       78 66 2 6 0   1     0   3   45 33                 78
1121992 1121992 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2017   grade_1 66 2 6 0   3     0   2   40 39                       79 66 2 6 0   3     0   2   40 39                 79
1121993 1121993 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2017   grade_2 46 1 6 0   4     0   4   37 24                       61 46 1 6 0   4     0   4   37 24                 61
1121994 1121994 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2017   grade_3 64 2 8 0   2     0   2   31 47                       78 64 2 8 0   2     0   2   31 47                 78
1121995 1121995 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2017   grade_4 71 3 4 0   1     0   2   42 39                       81 71 3 4 0   1     0   2   42 39                 81
1121996 1121996 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121997 1121997 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2017   kindergarten 53 2 8 0   2     0   2   43 24                       67 53 2 8 0   2     0   2   43 24                 67
1121998 1121998 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2017   grade_1 55 1 7 0   2     0   2   35 32                       67 55 1 7 0   2     0   2   35 32                 67
1121999 1121999 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2017   grade_2 50 4 5 0   1     0   1   31 30                       61 50 4 5 0   1     0   1   31 30                 61
1122000 1122000 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2017   grade_3 61 2 6 0   4     0   1   38 36                       74 61 2 6 0   4     0   1   38 36                 74
1122001 1122001 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2017   grade_4 52 1 5 0   2     0   0   28 32                       60 52 1 5 0   2     0   0   28 32                 60
1122002 1122002 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122016 1122016 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2017   kindergarten 40 10 4 0   0     0   2   31 25                       56 40 10 4 0   0     0   2   31 25                 56
1122017 1122017 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2017   pre_kindergarten 21 0 4 0   0     0   1   16 10                       26 21 0 4 0   0     0   1   16 10                 26
1122018 1122018 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2017   grade_1 60 2 5 1   0     0   4   32 40                       72 60 2 5 1   0     0   4   32 40                 72
1122019 1122019 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2017   grade_2 72 1 6 0   1     0   5   42 43                       85 72 1 6 0   1     0   5   42 43                 85
1122020 1122020 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2017   grade_3 67 2 4 0   0     0   4   44 33                       77 67 2 4 0   0     0   4   44 33                 77
1122021 1122021 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2017   grade_4 67 1 1 1   1     0   1   38 34                       72 67 1 1 1   1     0   1   38 34                 72
1122022 1122022 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122023 1122023 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2017   kindergarten 59 4 6 0   1     0   1   33 38                       71 59 4 6 0   1     0   1   33 38                 71
1122024 1122024 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2017   pre_kindergarten 20 1 3 0   0     0   1   19 6                       25 20 1 3 0   0     0   1   19 6                 25
1122025 1122025 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2017   grade_1 75 1 7 0   2     0   1   53 33                       86 75 1 7 0   2     0   1   53 33                 86
1122026 1122026 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2017   grade_2 77 2 4 1   3     0   2   48 41                       89 77 2 4 1   3     0   2   48 41                 89
1122027 1122027 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2017   grade_3 76 2 10 0   2     0   3   50 43                       93 76 2 10 0   2     0   3   50 43                 93
1122028 1122028 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2017   grade_4 78 0 10 1   1     1   3   42 52                       94 78 0 10 1   1     1   3   42 52                 94
1122029 1122029 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122045 1122045 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2017   kindergarten 15 3 8 0   6     0   2   17 17                       34 15 3 8 0   6     0   2   17 17                 34
1122046 1122046 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten 29 3 13 0   13     0   8   35 31                       66 29 3 13 0   13     0   8   35 31                 66
1122047 1122047 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2017   grade_1 21 5 8 0   9     0   0   22 21                       43 21 5 8 0   9     0   0   22 21                 43
1122048 1122048 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2017   grade_2 22 1 17 0   6     0   4   25 25                       50 22 1 17 0   6     0   4   25 25                 50
1122049 1122049 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2017   grade_3 20 2 20 0   10     0   6   34 24                       58 20 2 20 0   10     0   6   34 24                 58
1122050 1122050 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2017   grade_4 14 6 10 0   11     0   3   23 21                       44 14 6 10 0   11     0   3   23 21                 44
1122051 1122051 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2017   grade_5 29 3 15 0   4     0   9   26 34                       60 29 3 15 0   4     0   9   26 34                 60
1122052 1122052 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2017   grade_6 23 6 13 0   5     0   2   22 27                       49 23 6 13 0   5     0   2   22 27                 49
1122053 1122053 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122054 1122054 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2017   kindergarten 19 6 12 0   5     0   0   16 26                       42 19 6 12 0   5     0   0   16 26                 42
1122055 1122055 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2017   grade_1 19 3 8 0   10     0   1   21 20                       41 19 3 8 0   10     0   1   21 20                 41
1122056 1122056 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2017   grade_2 19 1 9 0   9     0   4   21 21                       42 19 1 9 0   9     0   4   21 21                 42
1122057 1122057 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2017   grade_3 20 4 10 0   6     0   2   12 30                       42 20 4 10 0   6     0   2   12 30                 42
1122058 1122058 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2017   grade_4 33 8 12 0   8     0   4   41 24                       65 33 8 12 0   8     0   4   41 24                 65
1122059 1122059 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2017   grade_5 28 11 14 0   3     0   3   29 30                       59 28 11 14 0   3     0   3   29 30                 59
1122060 1122060 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2017   grade_6 20 5 9 0   6     0   4   26 18                       44 20 5 9 0   6     0   4   26 18                 44
1122061 1122061 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122062 1122062 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2017   kindergarten 25 7 11 0   6     0   1   23 27                       50 25 7 11 0   6     0   1   23 27                 50
1122063 1122063 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2017   grade_1 28 8 13 0   8     0   0   31 26                       57 28 8 13 0   8     0   0   31 26                 57
1122064 1122064 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2017   grade_2 29 4 10 0   11     0   5   35 24                       59 29 4 10 0   11     0   5   35 24                 59
1122065 1122065 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2017   grade_3 31 3 11 0   6     0   6   31 26                       57 31 3 11 0   6     0   6   31 26                 57
1122066 1122066 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2017   grade_4 31 7 13 0   12     0   9   39 33                       72 31 7 13 0   12     0   9   39 33                 72
1122067 1122067 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2017   grade_5 26 6 15 1   4     0   5   29 28                       57 26 6 15 1   4     0   5   29 28                 57
1122068 1122068 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2017   grade_6 25 7 11 0   9     0   5   27 30                       57 25 7 11 0   9     0   5   27 30                 57
1122069 1122069 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122070 1122070 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2017   kindergarten 63 0 3 0   4     0   7   50 27                       77 63 0 3 0   4     0   7   50 27                 77
1122071 1122071 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2017   grade_1 76 2 3 0   8     0   4   51 42                       93 76 2 3 0   8     0   4   51 42                 93
1122072 1122072 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2017   grade_2 73 7 4 1   6     0   5   47 49                       96 73 7 4 1   6     0   5   47 49                 96
1122073 1122073 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2017   grade_3 74 3 7 0   7     0   6   43 54                       97 74 3 7 0   7     0   6   43 54                 97
1122074 1122074 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2017   grade_4 86 3 8 1   8     0   6   59 53                       112 86 3 8 1   8     0   6   59 53                 112
1122075 1122075 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2017   grade_5 93 4 10 0   6     0   5   57 61                       118 93 4 10 0   6     0   5   57 61                 118
1122076 1122076 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122077 1122077 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No Elementary KG 05 2017   kindergarten 41 2 3 0   13     0   5   29 35                       64 41 2 3 0   13     0   5   29 35                 64
1122078 1122078 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No Elementary KG 05 2017   grade_1 48 2 4 0   25     0   1   47 33                       80 48 2 4 0   25     0   1   47 33                 80
1122079 1122079 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No Elementary KG 05 2017   grade_2 42 1 7 0   21     0   2   41 32                       73 42 1 7 0   21     0   2   41 32                 73
1122080 1122080 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No Elementary KG 05 2017   grade_3 58 3 4 0   26     0   5   43 53                       96 58 3 4 0   26     0   5   43 53                 96
1122081 1122081 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No Elementary KG 05 2017   grade_4 49 2 8 0   36     0   0   58 37                       95 49 2 8 0   36     0   0   58 37                 95
1122082 1122082 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No Elementary KG 05 2017   grade_5 62 4 8 0   29     0   4   58 49                       107 62 4 8 0   29     0   4   58 49                 107
1122083 1122083 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122084 1122084 MA Essex   school 2501950 9   Andover 250195002366 90005 Shawsheen School   Regular School No Elementary PK PK 2017   pre_kindergarten 48 2 2 1   20     0   0   39 34                       73 48 2 2 1   20     0   0   39 34                 73
1122085 1122085 MA Essex   school 2501950 9   Andover 250195002366 90005 Shawsheen School   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122086 1122086 MA Essex   school 2501950 9   Andover 250195000048 90010 Henry C Sanborn Elementary   Regular School No Elementary KG 05 2017   kindergarten 27 1 2 0   16     0   2   28 20                       48 27 1 2 0   16     0   2   28 20                 48
1122087 1122087 MA Essex   school 2501950 9   Andover 250195000048 90010 Henry C Sanborn Elementary   Regular School No Elementary KG 05 2017   grade_1 41 0 1 0   19     0   1   31 31                       62 41 0 1 0   19     0   1   31 31                 62
1122088 1122088 MA Essex   school 2501950 9   Andover 250195000048 90010 Henry C Sanborn Elementary   Regular School No Elementary KG 05 2017   grade_2 42 2 3 0   20     0   1   36 32                       68 42 2 3 0   20     0   1   36 32                 68
1122089 1122089 MA Essex   school 2501950 9   Andover 250195000048 90010 Henry C Sanborn Elementary   Regular School No Elementary KG 05 2017   grade_3 44 0 3 1   13     0   2   42 21                       63 44 0 3 1   13     0   2   42 21                 63

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