enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
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 * * * *   *     *   *                             *                                              
1122356 1122356 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Swift River Elementary   Regular School No Elementary 01 03 2017   grade_1 137 5 6 1   3     0   4   84 72                       156 137 5 6 1   3     0   4   84 72                 156
1122357 1122357 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Swift River Elementary   Regular School No Elementary 01 03 2017   grade_2 138 3 12 1   1     0   6   83 78                       161 138 3 12 1   1     0   6   83 78                 161
1122358 1122358 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Swift River Elementary   Regular School No Elementary 01 03 2017   grade_3 169 2 7 1   2     0   3   94 90                       184 169 2 7 1   2     0   3   94 90                 184
1122359 1122359 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Swift River Elementary   Regular School No Elementary 01 03 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1123133 1123133 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_2 1 5 0 0   0     0   0   4 2                       6 1 5 0 0   0     0   0   4 2                 6
1123134 1123134 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_3 2 7 4 0   0     0   0   10 3                       13 2 7 4 0   0     0   0   10 3                 13
1123135 1123135 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_4 5 6 4 0   0     0   1   14 2                       16 5 6 4 0   0     0   1   14 2                 16
1123136 1123136 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_5 2 4 10 0   0     0   0   12 4                       16 2 4 10 0   0     0   0   12 4                 16
1123137 1123137 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_6 3 7 5 1   0     0   0   15 1                       16 3 7 5 1   0     0   0   15 1                 16
1123138 1123138 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_7 1 11 14 0   0     0   4   23 7                       30 1 11 14 0   0     0   4   23 7                 30
1123139 1123139 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_8 1 17 15 0   0     0   0   23 10                       33 1 17 15 0   0     0   0   23 10                 33
1123140 1123140 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_9 4 31 25 0   1     0   1   41 21                       62 4 31 25 0   1     0   1   41 21                 62
1123141 1123141 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_10 7 23 10 0   0     0   1   26 15                       41 7 23 10 0   0     0   1   26 15                 41
1123142 1123142 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_11 3 23 14 0   1     0   1   32 10                       42 3 23 14 0   1     0   1   32 10                 42
1123143 1123143 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_12 4 14 19 0   1     0   3   27 14                       41 4 14 19 0   1     0   3   27 14                 41
1123144 1123144 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   sped_beyond_grade_12 2 10 5 0   0     0   0                             17 2 10 5 0   0     0   0                       17
1123525 1123525 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No Elementary 01 05 2017   grade_1 58 0 3 0   21     0   3   39 46                       85 58 0 3 0   21     0   3   39 46                 85
1123526 1123526 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No Elementary 01 05 2017   grade_2 57 0 4 0   27     0   2   43 47                       90 57 0 4 0   27     0   2   43 47                 90
1123527 1123527 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No Elementary 01 05 2017   grade_3 54 2 6 0   24     1   1   45 43                       88 54 2 6 0   24     1   1   45 43                 88
1123528 1123528 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No Elementary 01 05 2017   grade_4 78 3 6 0   23     0   0   58 52                       110 78 3 6 0   23     0   0   58 52                 110
1123529 1123529 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No Elementary 01 05 2017   grade_5 55 2 4 0   14     0   0   29 46                       75 55 2 4 0   14     0   0   29 46                 75
1123530 1123530 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No Elementary 01 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124079 1124079 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No Elementary 01 04 2017   grade_1 7 6 104 0   0     0   0   65 52                       117 7 6 104 0   0     0   0   65 52                 117
1124080 1124080 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No Elementary 01 04 2017   grade_2 19 7 106 0   4     0   2   79 59                       138 19 7 106 0   4     0   2   79 59                 138
1124081 1124081 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No Elementary 01 04 2017   grade_3 13 10 125 0   1     1   0   78 72                       150 13 10 125 0   1     1   0   78 72                 150
1124082 1124082 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No Elementary 01 04 2017   grade_4 11 9 113 0   1     0   2   69 67                       136 11 9 113 0   1     0   2   69 67                 136
1124083 1124083 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No Elementary 01 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124084 1124084 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No Elementary 01 04 2017   grade_1 13 10 117 0   0     0   5   89 56                       145 13 10 117 0   0     0   5   89 56                 145
1124085 1124085 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No Elementary 01 04 2017   grade_2 19 15 162 0   1     0   3   107 93                       200 19 15 162 0   1     0   3   107 93                 200
1124086 1124086 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No Elementary 01 04 2017   grade_3 14 12 113 1   2     0   1   76 67                       143 14 12 113 1   2     0   1   76 67                 143
1124087 1124087 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No Elementary 01 04 2017   grade_4 7 5 85 2   3     0   1   52 51                       103 7 5 85 2   3     0   1   52 51                 103
1124088 1124088 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No Elementary 01 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124089 1124089 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 04 2017   grade_1 8 3 119 0   0     0   2   65 67                       132 8 3 119 0   0     0   2   65 67                 132
1124090 1124090 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 04 2017   grade_2 6 5 142 0   2     0   2   86 71                       157 6 5 142 0   2     0   2   86 71                 157
1124091 1124091 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 04 2017   grade_3 3 3 141 0   1     0   2   71 79                       150 3 3 141 0   1     0   2   71 79                 150
1124092 1124092 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 04 2017   grade_4 7 1 121 0   1     0   2   66 66                       132 7 1 121 0   1     0   2   66 66                 132
1124093 1124093 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124094 1124094 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2017   grade_1 10 5 97 0   0     0   2   58 56                       114 10 5 97 0   0     0   2   58 56                 114
1124095 1124095 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2017   grade_2 10 16 93 0   4     0   4   63 64                       127 10 16 93 0   4     0   4   63 64                 127
1124096 1124096 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2017   grade_3 8 5 158 0   2     0   3   104 72                       176 8 5 158 0   2     0   3   104 72                 176
1124097 1124097 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2017   grade_4 10 6 149 0   1     0   4   77 93                       170 10 6 149 0   1     0   4   77 93                 170
1124098 1124098 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124336 1124336 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No Elementary 01 05 2017   grade_1 61 0 4 0   0     0   3   31 37                       68 61 0 4 0   0     0   3   31 37                 68
1124337 1124337 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No Elementary 01 05 2017   grade_2 72 1 3 0   1     0   5   40 42                       82 72 1 3 0   1     0   5   40 42                 82
1124338 1124338 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No Elementary 01 05 2017   grade_3 71 1 7 0   0     0   1   37 43                       80 71 1 7 0   0     0   1   37 43                 80
1124339 1124339 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No Elementary 01 05 2017   grade_4 85 1 0 0   0     0   6   53 39                       92 85 1 0 0   0     0   6   53 39                 92
1124340 1124340 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No Elementary 01 05 2017   grade_5 89 0 2 0   1     0   5   48 49                       97 89 0 2 0   1     0   5   48 49                 97
1124341 1124341 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No Elementary 01 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124368 1124368 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No Elementary 01 05 2017   grade_1 28 6 14 0   1     0   5   27 27                       54 28 6 14 0   1     0   5   27 27                 54
1124369 1124369 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No Elementary 01 05 2017   grade_2 32 5 12 1   3     0   2   26 29                       55 32 5 12 1   3     0   2   26 29                 55
1124370 1124370 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No Elementary 01 05 2017   grade_3 42 6 17 0   2     0   5   38 34                       72 42 6 17 0   2     0   5   38 34                 72
1124371 1124371 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No Elementary 01 05 2017   grade_4 40 8 17 1   2     0   4   39 33                       72 40 8 17 1   2     0   4   39 33                 72
1124372 1124372 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No Elementary 01 05 2017   grade_5 32 4 14 0   3     0   2   31 24                       55 32 4 14 0   3     0   2   31 24                 55
1124373 1124373 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No Elementary 01 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124374 1124374 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Greenlodge   Regular School No Elementary 01 05 2017   grade_1 33 1 3 0   1     0   0   19 19                       38 33 1 3 0   1     0   0   19 19                 38
1124375 1124375 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Greenlodge   Regular School No Elementary 01 05 2017   grade_2 46 1 1 0   0     0   4   28 24                       52 46 1 1 0   0     0   4   28 24                 52
1124376 1124376 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Greenlodge   Regular School No Elementary 01 05 2017   grade_3 56 2 5 0   1     0   2   36 30                       66 56 2 5 0   1     0   2   36 30                 66
1124377 1124377 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Greenlodge   Regular School No Elementary 01 05 2017   grade_4 51 2 5 0   2     0   4   31 33                       64 51 2 5 0   2     0   4   31 33                 64
1124378 1124378 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Greenlodge   Regular School No Elementary 01 05 2017   grade_5 50 3 3 0   1     0   1   37 21                       58 50 3 3 0   1     0   1   37 21                 58
1124379 1124379 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Greenlodge   Regular School No Elementary 01 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124380 1124380 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Oakdale   Regular School No Elementary 01 05 2017   grade_1 36 3 5 0   1     0   7   20 32                       52 36 3 5 0   1     0   7   20 32                 52
1124381 1124381 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Oakdale   Regular School No Elementary 01 05 2017   grade_2 39 5 5 0   2     0   5   26 30                       56 39 5 5 0   2     0   5   26 30                 56
1124382 1124382 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Oakdale   Regular School No Elementary 01 05 2017   grade_3 40 2 4 0   0     0   1   32 15                       47 40 2 4 0   0     0   1   32 15                 47
1124383 1124383 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Oakdale   Regular School No Elementary 01 05 2017   grade_4 47 5 7 0   1     0   5   27 38                       65 47 5 7 0   1     0   5   27 38                 65
1124384 1124384 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Oakdale   Regular School No Elementary 01 05 2017   grade_5 39 4 5 0   1     0   3   22 30                       52 39 4 5 0   1     0   3   22 30                 52
1124385 1124385 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Oakdale   Regular School No Elementary 01 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124386 1124386 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No Elementary 01 05 2017   grade_1 25 3 4 0   1     0   1   17 17                       34 25 3 4 0   1     0   1   17 17                 34
1124387 1124387 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No Elementary 01 05 2017   grade_2 18 3 9 0   1     0   0   15 16                       31 18 3 9 0   1     0   0   15 16                 31
1124388 1124388 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No Elementary 01 05 2017   grade_3 29 2 1 0   0     0   3   17 18                       35 29 2 1 0   0     0   3   17 18                 35
1124389 1124389 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No Elementary 01 05 2017   grade_4 33 3 7 0   0     0   0   31 12                       43 33 3 7 0   0     0   0   31 12                 43
1124390 1124390 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No Elementary 01 05 2017   grade_5 31 1 5 0   2     0   1   25 15                       40 31 1 5 0   2     0   1   25 15                 40
1124391 1124391 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No Elementary 01 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125422 1125422 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_2 * * * *   *     *   *   4 1                       *                         4 1                  
1125423 1125423 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_4 * * * *   *     *   *   4 1                       *                         4 1                  
1125424 1125424 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_6 * * * *   *     *   *   4 1                       *                         4 1                  
1125425 1125425 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_7 * * * *   *     *   *   2 1                       *                         2 1                  
1125426 1125426 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_8 * * * *   *     *   *   2 3                       *                         2 3                  
1125427 1125427 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_10 * * * *   *     *   *   3 1                       *                         3 1                  
1125428 1125428 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   sped_beyond_grade_12 10 0 3 0   1     0   0                             14 10 0 3 0   1     0   0                       14
1125429 1125429 MA Essex   school 2505970 128   Haverhill 250597000866 1280075 Tilton   Regular School No Elementary 01 04 2017   grade_1 71 2 65 1   0     0   3   67 75                       142 71 2 65 1   0     0   3   67 75                 142
1125430 1125430 MA Essex   school 2505970 128   Haverhill 250597000866 1280075 Tilton   Regular School No Elementary 01 04 2017   grade_2 50 2 84 2   0     0   2   86 54                       140 50 2 84 2   0     0   2   86 54                 140
1125431 1125431 MA Essex   school 2505970 128   Haverhill 250597000866 1280075 Tilton   Regular School No Elementary 01 04 2017   grade_3 54 4 75 0   4     0   2   75 64                       139 54 4 75 0   4     0   2   75 64                 139
1125432 1125432 MA Essex   school 2505970 128   Haverhill 250597000866 1280075 Tilton   Regular School No Elementary 01 04 2017   grade_4 68 7 40 0   2     0   2   55 64                       119 68 7 40 0   2     0   2   55 64                 119
1125433 1125433 MA Essex   school 2505970 128   Haverhill 250597000866 1280075 Tilton   Regular School No Elementary 01 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125443 1125443 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_1 26 0 18 0   0     0   0   26 18                       44 26 0 18 0   0     0   0   26 18                 44
1125444 1125444 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_2 17 2 26 0   0     0   2   25 22                       47 17 2 26 0   0     0   2   25 22                 47
1125445 1125445 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_3 21 0 30 0   3     0   2   32 24                       56 21 0 30 0   3     0   2   32 24                 56
1125446 1125446 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_4 31 1 22 0   2     0   1   34 23                       57 31 1 22 0   2     0   1   34 23                 57
1125447 1125447 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_5 66 9 84 0   2     0   1   84 78                       162 66 9 84 0   2     0   1   84 78                 162
1125448 1125448 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_6 106 1 99 0   4     1   2   98 115                       213 106 1 99 0   4     1   2   98 115                 213
1125449 1125449 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_7 96 8 98 0   3     0   1   99 107                       206 96 8 98 0   3     0   1   99 107                 206
1125450 1125450 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_8 134 7 86 0   3     0   2   120 112                       232 134 7 86 0   3     0   2   120 112                 232
1125451 1125451 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125801 1125801 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No Elementary 01 04 2017   grade_1 3 2 119 1   3     0   0   64 64                       128 3 2 119 1   3     0   0   64 64                 128
1125802 1125802 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No Elementary 01 04 2017   grade_2 6 4 124 0   0     0   1   67 68                       135 6 4 124 0   0     0   1   67 68                 135

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