enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1132536 1132536 MA Middlesex   school 2508790 735   North Middlesex 250879002705 7350515 Peter Fitzpatrick School   Regular School No Ungraded UG UG 2017   sped_beyond_grade_12 10 0 0 0   0     0   0                             10 10 0 0 0   0     0   0                       10
1122685 1122685 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No Other 06 12 2017   grade_6 1 29 27 0   0     0   1   35 23                       58 1 29 27 0   0     0   1   35 23                 58
1122686 1122686 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No Other 06 12 2017   grade_7 0 40 12 0   0     0   0   24 28                       52 0 40 12 0   0     0   0   24 28                 52
1122687 1122687 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No Other 06 12 2017   grade_8 1 33 17 0   0     0   2   28 25                       53 1 33 17 0   0     0   2   28 25                 53
1122688 1122688 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No Other 06 12 2017   grade_9 1 34 8 0   0     0   5   24 24                       48 1 34 8 0   0     0   5   24 24                 48
1122689 1122689 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No Other 06 12 2017   grade_10 0 28 11 0   0     0   0   20 19                       39 0 28 11 0   0     0   0   20 19                 39
1122690 1122690 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No Other 06 12 2017   grade_11 2 30 5 1   1     0   1   28 12                       40 2 30 5 1   1     0   1   28 12                 40
1122691 1122691 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No Other 06 12 2017   grade_12 0 14 2 1   0     0   2   11 8                       19 0 14 2 1   0     0   2   11 8                 19
1122692 1122692 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No Other 06 12 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
1123247 1123247 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 03 12 2017   grade_3 13 10 14 0   1     0   1   23 16                       39 13 10 14 0   1     0   1   23 16                 39
1123248 1123248 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 03 12 2017   grade_4 26 7 16 0   1     0   0   30 20                       50 26 7 16 0   1     0   0   30 20                 50
1123249 1123249 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 03 12 2017   grade_5 7 18 9 0   3     0   1   20 18                       38 7 18 9 0   3     0   1   20 18                 38
1123250 1123250 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 03 12 2017   grade_6 12 17 15 0   7     0   1   31 21                       52 12 17 15 0   7     0   1   31 21                 52
1123251 1123251 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 03 12 2017   grade_7 13 25 13 0   5     0   3   31 28                       59 13 25 13 0   5     0   3   31 28                 59
1123252 1123252 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 03 12 2017   grade_8 11 28 14 0   5     0   2   26 34                       60 11 28 14 0   5     0   2   26 34                 60
1123253 1123253 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 03 12 2017   grade_9 7 36 17 0   4     0   3   34 33                       67 7 36 17 0   4     0   3   34 33                 67
1123254 1123254 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 03 12 2017   grade_10 5 28 20 1   6     0   0   38 22                       60 5 28 20 1   6     0   0   38 22                 60
1123255 1123255 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 03 12 2017   grade_11 8 25 9 0   2     0   1   26 19                       45 8 25 9 0   2     0   1   26 19                 45
1123256 1123256 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 03 12 2017   grade_12 5 22 2 0   0     1   0   15 15                       30 5 22 2 0   0     1   0   15 15                 30
1123257 1123257 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 03 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1123367 1123367 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No Other 06 12 2017   grade_6 8 20 19 0   82     0   5   71 63                       134 8 20 19 0   82     0   5   71 63                 134
1123368 1123368 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No Other 06 12 2017   grade_7 0 12 17 1   40     0   1   38 33                       71 0 12 17 1   40     0   1   38 33                 71
1123369 1123369 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No Other 06 12 2017   grade_8 2 16 15 0   39     1   2   46 29                       75 2 16 15 0   39     1   2   46 29                 75
1123370 1123370 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No Other 06 12 2017   grade_9 3 16 18 0   26     0   0   33 30                       63 3 16 18 0   26     0   0   33 30                 63
1123371 1123371 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No Other 06 12 2017   grade_10 1 14 10 0   30     0   1   34 22                       56 1 14 10 0   30     0   1   34 22                 56
1123372 1123372 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No Other 06 12 2017   grade_11 4 11 10 0   18     0   1   22 22                       44 4 11 10 0   18     0   1   22 22                 44
1123373 1123373 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No Other 06 12 2017   grade_12 3 17 11 0   22     0   2   32 23                       55 3 17 11 0   22     0   2   32 23                 55
1123374 1123374 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No Other 06 12 2017   sped_beyond_grade_12 1 2 3 0   1     0   1                             8 1 2 3 0   1     0   1                       8
1123413 1123413 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No Other 06 12 2017   grade_6 4 69 47 0   8     1   4   84 49                       133 4 69 47 0   8     1   4   84 49                 133
1123414 1123414 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No Other 06 12 2017   grade_7 3 63 40 0   3     0   7   75 41                       116 3 63 40 0   3     0   7   75 41                 116
1123415 1123415 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No Other 06 12 2017   grade_8 3 89 37 1   3     0   4   65 72                       137 3 89 37 1   3     0   4   65 72                 137
1123416 1123416 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No Other 06 12 2017   grade_9 4 111 33 1   6     0   4   89 70                       159 4 111 33 1   6     0   4   89 70                 159
1123417 1123417 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No Other 06 12 2017   grade_10 5 114 31 1   9     0   2   90 72                       162 5 114 31 1   9     0   2   90 72                 162
1123418 1123418 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No Other 06 12 2017   grade_11 3 98 24 1   5     1   2   64 70                       134 3 98 24 1   5     1   2   64 70                 134
1123419 1123419 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No Other 06 12 2017   grade_12 6 96 23 0   3     0   2   71 59                       130 6 96 23 0   3     0   2   71 59                 130
1123420 1123420 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No Other 06 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1123442 1123442 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   kindergarten 2 4 2 0   0     0   0   6 2                       8 2 4 2 0   0     0   0   6 2                 8
1123443 1123443 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   pre_kindergarten 1 3 1 0   1     0   0   3 3                       6 1 3 1 0   1     0   0   3 3                 6
1123444 1123444 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   grade_1 * * * *   *     *   *   2 3                       *                         2 3                  
1123445 1123445 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   grade_2 0 5 3 0   0     0   1   7 2                       9 0 5 3 0   0     0   1   7 2                 9
1123446 1123446 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   grade_4 2 4 3 0   0     0   0   7 2                       9 2 4 3 0   0     0   0   7 2                 9
1123447 1123447 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   grade_6 0 3 3 0   0     0   0   2 4                       6 0 3 3 0   0     0   0   2 4                 6
1123448 1123448 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   grade_7 1 2 3 0   1     0   0   4 3                       7 1 2 3 0   1     0   0   4 3                 7
1123449 1123449 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   grade_8 * * * *   *     *   *   1 2                       *                         1 2                  
1123450 1123450 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   grade_9 0 3 5 0   1     0   1   7 3                       10 0 3 5 0   1     0   1   7 3                 10
1123451 1123451 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   grade_10 0 3 6 0   1     0   0   4 6                       10 0 3 6 0   1     0   0   4 6                 10
1123452 1123452 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   grade_11 1 1 3 0   0     0   1   3 3                       6 1 1 3 0   0     0   1   3 3                 6
1123453 1123453 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   grade_12 1 2 2 0   2     0   0   5 2                       7 1 2 2 0   2     0   0   5 2                 7
1123454 1123454 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1123667 1123667 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative School No Other 05 12 2017   grade_5 * * * *   *     *   *   1 1                       *                         1 1                  
1123668 1123668 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative School No Other 05 12 2017   grade_7 * * * *   *     *   *   4 1                       *                         4 1                  
1123669 1123669 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative School No Other 05 12 2017   grade_8 2 3 3 0   0     0   0   6 2                       8 2 3 3 0   0     0   0   6 2                 8
1123670 1123670 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative School No Other 05 12 2017   grade_9 3 3 0 0   0     0   0   5 1                       6 3 3 0 0   0     0   0   5 1                 6
1123671 1123671 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative School No Other 05 12 2017   grade_10 7 3 1 0   0     0   0   7 4                       11 7 3 1 0   0     0   0   7 4                 11
1123672 1123672 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative School No Other 05 12 2017   grade_11 4 2 1 0   0     0   0   4 3                       7 4 2 1 0   0     0   0   4 3                 7
1123673 1123673 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative School No Other 05 12 2017   grade_12 3 3 0 0   0     0   0   2 4                       6 3 3 0 0   0     0   0   2 4                 6
1123674 1123674 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative School No Other 05 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124026 1124026 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No Other 06 12 2017   grade_6 137 1 2 0   1     0   0   62 79                       141 137 1 2 0   1     0   0   62 79                 141
1124027 1124027 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No Other 06 12 2017   grade_7 109 2 4 0   1     0   0   70 46                       116 109 2 4 0   1     0   0   70 46                 116
1124028 1124028 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No Other 06 12 2017   grade_8 150 0 1 0   0     1   3   79 76                       155 150 0 1 0   0     1   3   79 76                 155
1124029 1124029 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No Other 06 12 2017   grade_9 112 2 0 0   0     0   0   58 56                       114 112 2 0 0   0     0   0   58 56                 114
1124030 1124030 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No Other 06 12 2017   grade_10 97 1 0 0   0     0   2   52 48                       100 97 1 0 0   0     0   2   52 48                 100
1124031 1124031 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No Other 06 12 2017   grade_11 93 2 1 1   0     0   5   46 56                       102 93 2 1 1   0     0   5   46 56                 102
1124032 1124032 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No Other 06 12 2017   grade_12 93 3 1 0   0     0   3   55 45                       100 93 3 1 0   0     0   3   55 45                 100
1124033 1124033 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No Other 06 12 2017   sped_beyond_grade_12 8 0 0 0   0     0   0                             8 8 0 0 0   0     0   0                       8
1124147 1124147 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No Other 06 12 2017   grade_7 1 0 9 0   0     0   0   9 1                       10 1 0 9 0   0     0   0   9 1                 10
1124148 1124148 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No Other 06 12 2017   grade_8 4 1 8 0   0     0   0   9 4                       13 4 1 8 0   0     0   0   9 4                 13
1124149 1124149 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No Other 06 12 2017   grade_9 9 1 20 0   0     0   0   24 6                       30 9 1 20 0   0     0   0   24 6                 30
1124150 1124150 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No Other 06 12 2017   grade_10 5 0 13 0   0     0   2   14 6                       20 5 0 13 0   0     0   2   14 6                 20
1124151 1124151 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No Other 06 12 2017   grade_11 8 1 8 0   0     0   2   14 5                       19 8 1 8 0   0     0   2   14 5                 19
1124152 1124152 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No Other 06 12 2017   grade_12 2 1 8 0   0     0   1   9 3                       12 2 1 8 0   0     0   1   9 3                 12
1124153 1124153 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No Other 06 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124244 1124244 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No Other 06 12 2017   grade_6 134 3 1 0   4     0   1   68 75                       143 134 3 1 0   4     0   1   68 75                 143
1124245 1124245 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No Other 06 12 2017   grade_7 114 4 3 2   3     0   2   64 64                       128 114 4 3 2   3     0   2   64 64                 128
1124246 1124246 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No Other 06 12 2017   grade_8 126 3 0 0   5     0   0   68 66                       134 126 3 0 0   5     0   0   68 66                 134
1124247 1124247 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No Other 06 12 2017   grade_9 112 4 4 0   7     0   0   61 66                       127 112 4 4 0   7     0   0   61 66                 127
1124248 1124248 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No Other 06 12 2017   grade_10 107 5 1 0   2     0   1   62 54                       116 107 5 1 0   2     0   1   62 54                 116
1124249 1124249 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No Other 06 12 2017   grade_11 89 5 1 1   1     0   0   58 39                       97 89 5 1 1   1     0   0   58 39                 97
1124250 1124250 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No Other 06 12 2017   grade_12 90 3 0 0   0     0   0   44 49                       93 90 3 0 0   0     0   0   44 49                 93
1124251 1124251 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No Other 06 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124655 1124655 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2017   grade_3 * * * *   *     *   *   4 1                       *                         4 1                  
1124656 1124656 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2017   grade_4 3 2 2 0   0     0   1   7 1                       8 3 2 2 0   0     0   1   7 1                 8
1124657 1124657 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2017   grade_5 1 2 3 0   0     0   0   5 1                       6 1 2 3 0   0     0   0   5 1                 6
1124658 1124658 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2017   grade_7 * * * *   *     *   *   2 2                       *                         2 2                  
1124659 1124659 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2017   grade_9 3 0 6 0   0     0   0   6 3                       9 3 0 6 0   0     0   0   6 3                 9
1124660 1124660 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2017   grade_10 6 2 2 0   0     0   1   9 2                       11 6 2 2 0   0     0   1   9 2                 11
1124661 1124661 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2017   grade_11 2 2 3 0   0     0   0   4 3                       7 2 2 3 0   0     0   0   4 3                 7
1124662 1124662 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2017   grade_12 * * * *   *     *   *   3 2                       *                         3 2                  

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