Data source: Big Local News · About: Big Local

9,541 rows where state = "MA" and year = 2015 sorted by ccd_school_lvl descending

View and edit SQL

grade

year

  • 2015 · 9,541
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
736277 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No 4 06 10 2015   grade_6 2 29 18 0   0     0   0   27 22                       49 2 29 18 0   0     0   0   27 22                 49
736278 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No 4 06 10 2015   grade_7 1 42 14 0   0     0   5   30 32                       62 1 42 14 0   0     0   5   30 32                 62
736279 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No 4 06 10 2015   grade_8 1 43 24 0   0     0   2   33 37                       70 1 43 24 0   0     0   2   33 37                 70
736280 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No 4 06 10 2015   grade_9 3 46 12 1   1     0   3   39 27                       66 3 46 12 1   1     0   3   39 27                 66
736281 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No 4 06 10 2015   grade_10 0 17 5 1   0     0   3   14 12                       26 0 17 5 1   0     0   3   14 12                 26
736673 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   grade_1 * * * *   *     *   *   2 3                       5                         2 3                 5
736674 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   grade_2 3 6 2 0   0     0   1   11 1                       12 3 6 2 0   0     0   1   11 1                 12
736675 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   grade_3 1 5 6 0   0     0   0   10 2                       12 1 5 6 0   0     0   0   10 2                 12
736676 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   grade_5 3 12 14 0   0     0   3   27 5                       32 3 12 14 0   0     0   3   27 5                 32
736677 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   grade_6 2 14 11 0   0     0   1   22 6                       28 2 14 11 0   0     0   1   22 6                 28
736678 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   grade_7 3 11 13 0   0     0   0   24 3                       27 3 11 13 0   0     0   0   24 3                 27
736679 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   grade_8 3 14 12 0   0     0   0   17 12                       29 3 14 12 0   0     0   0   17 12                 29
736680 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   grade_9 3 27 11 0   1     0   1   32 11                       43 3 27 11 0   1     0   1   32 11                 43
736681 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   grade_10 7 19 23 0   1     0   4   29 25                       54 7 19 23 0   1     0   4   29 25                 54
736682 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   grade_11 3 37 17 1   1     0   0   41 18                       59 3 37 17 1   1     0   0   41 18                 59
736683 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   grade_12 5 20 5 1   0     0   1   20 12                       32 5 20 5 1   0     0   1   20 12                 32
736684 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   SP 6 18 4 0   0     0   2                             30 6 18 4 0   0     0   2                       30
736775 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No 4 05 11 2015   grade_5 24 11 3 0   5     0   0   21 22                       43 24 11 3 0   5     0   0   21 22                 43
736776 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No 4 05 11 2015   grade_6 18 24 14 0   9     0   1   35 31                       66 18 24 14 0   9     0   1   35 31                 66
736777 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No 4 05 11 2015   grade_7 7 37 8 0   3     0   3   27 31                       58 7 37 8 0   3     0   3   27 31                 58
736778 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No 4 05 11 2015   grade_8 7 37 16 2   5     1   1   42 27                       69 7 37 16 2   5     1   1   42 27                 69
736779 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No 4 05 11 2015   grade_9 7 49 11 0   2     0   2   43 28                       71 7 49 11 0   2     0   2   43 28                 71
736780 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No 4 05 11 2015   grade_10 4 17 0 1   0     0   0   14 8                       22 4 17 0 1   0     0   0   14 8                 22
736781 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No 4 05 11 2015   grade_11 4 18 7 2   1     0   0   14 18                       32 4 18 7 2   1     0   0   14 18                 32
736866 MA Suffolk   school 2502790 35   Boston 250279002753 350549 Margarita Muniz Academy   Regular School No 4 09 11 2015   grade_9 1 3 79 0   0     0   1   34 50                       84 1 3 79 0   0     0   1   34 50                 84
736867 MA Suffolk   school 2502790 35   Boston 250279002753 350549 Margarita Muniz Academy   Regular School No 4 09 11 2015   grade_10 0 6 64 0   0     0   2   27 45                       72 0 6 64 0   0     0   2   27 45                 72
736868 MA Suffolk   school 2502790 35   Boston 250279002753 350549 Margarita Muniz Academy   Regular School No 4 09 11 2015   grade_11 2 5 64 1   1     0   0   33 40                       73 2 5 64 1   1     0   0   33 40                 73
736880 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No 4 06 12 2015   grade_6 12 17 18 0   77     1   6   75 56                       131 12 17 18 0   77     1   6   75 56                 131
736881 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No 4 06 12 2015   grade_7 3 13 18 0   34     0   0   37 31                       68 3 13 18 0   34     0   0   37 31                 68
736882 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No 4 06 12 2015   grade_8 2 14 12 0   43     0   1   42 30                       72 2 14 12 0   43     0   1   42 30                 72
736883 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No 4 06 12 2015   grade_9 2 12 11 0   19     0   1   23 22                       45 2 12 11 0   19     0   1   23 22                 45
736884 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No 4 06 12 2015   grade_10 4 17 12 0   21     0   2   35 21                       56 4 17 12 0   21     0   2   35 21                 56
736885 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No 4 06 12 2015   grade_11 3 12 6 0   31     0   0   29 23                       52 3 12 6 0   31     0   0   29 23                 52
736886 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No 4 06 12 2015   grade_12 2 16 10 0   28     0   2   33 25                       58 2 16 10 0   28     0   2   33 25                 58
736887 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No 4 06 12 2015   SP 3 6 6 0   0     0   0                             15 3 6 6 0   0     0   0                       15
736922 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No 4 06 12 2015   grade_6 2 72 39 1   8     0   1   62 61                       123 2 72 39 1   8     0   1   62 61                 123
736923 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No 4 06 12 2015   grade_7 3 94 27 1   7     0   2   75 59                       134 3 94 27 1   7     0   2   75 59                 134
736924 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No 4 06 12 2015   grade_8 4 97 27 1   9     0   2   74 66                       140 4 97 27 1   9     0   2   74 66                 140
736925 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No 4 06 12 2015   grade_9 7 113 39 1   5     1   2   97 71                       168 7 113 39 1   5     1   2   97 71                 168
736926 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No 4 06 12 2015   grade_10 9 112 25 0   3     0   4   85 68                       153 9 112 25 0   3     0   4   85 68                 153
736927 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No 4 06 12 2015   grade_11 4 102 20 2   6     0   4   81 57                       138 4 102 20 2   6     0   4   81 57                 138
736928 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No 4 06 12 2015   grade_12 2 101 16 1   5     1   2   61 67                       128 2 101 16 1   5     1   2   61 67                 128
736929 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No 4 06 12 2015   SP * * * *   *     *   *                             1                                             1
736950 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2015   kindergarten 0 3 3 0   0     0   0   4 2                       6 0 3 3 0   0     0   0   4 2                 6
736951 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2015   pre_kindergarten 2 6 3 0   1     0   0   9 3                       12 2 6 3 0   1     0   0   9 3                 12
736952 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2015   grade_1 1 2 1 0   2     0   0   5 1                       6 1 2 1 0   2     0   0   5 1                 6
736953 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2015   grade_2 3 4 2 0   0     0   0   6 3                       9 3 4 2 0   0     0   0   6 3                 9
736954 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2015   grade_3 * * * *   *     *   *   2 1                       3                         2 1                 3
736955 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2015   grade_4 0 3 4 0   0     0   0   3 4                       7 0 3 4 0   0     0   0   3 4                 7
736956 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2015   grade_5 1 2 3 0   1     0   0   4 3                       7 1 2 3 0   1     0   0   4 3                 7
736957 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2015   grade_6 * * * *   *     *   *   1 3                       4                         1 3                 4
736958 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2015   grade_7 0 5 5 0   1     0   0   5 6                       11 0 5 5 0   1     0   0   5 6                 11
736959 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2015   grade_8 1 2 3 0   1     0   0   2 5                       7 1 2 3 0   1     0   0   2 5                 7
736960 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2015   grade_9 2 0 3 0   0     0   1   3 3                       6 2 0 3 0   0     0   1   3 3                 6
736961 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2015   grade_10 1 2 2 0   2     0   1   5 3                       8 1 2 2 0   2     0   1   5 3                 8
736962 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2015   grade_12 1 5 4 0   1     0   0   4 7                       11 1 5 4 0   1     0   0   4 7                 11
736963 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2015   SP 0 3 4 0   2     0   0                             9 0 3 4 0   2     0   0                       9
737140 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative Education School No 4 04 12 2015   grade_7 * * * *   *     *   *   3 1                       4                         3 1                 4
737141 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative Education School No 4 04 12 2015   grade_8 * * * *   *     *   *   3 1                       4                         3 1                 4
737142 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative Education School No 4 04 12 2015   grade_9 7 3 5 0   0     0   0   10 5                       15 7 3 5 0   0     0   0   10 5                 15
737143 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative Education School No 4 04 12 2015   grade_10 3 3 0 0   0     0   0   5 1                       6 3 3 0 0   0     0   0   5 1                 6
737144 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative Education School No 4 04 12 2015   grade_11 5 4 1 0   0     0   2   8 4                       12 5 4 1 0   0     0   2   8 4                 12
737145 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative Education School No 4 04 12 2015   grade_12 5 3 1 0   0     0   0   4 5                       9 5 3 1 0   0     0   0   4 5                 9
737449 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No 4 06 12 2015   grade_6 158 0 0 0   0     1   0   81 78                       159 158 0 0 0   0     1   0   81 78                 159
737450 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No 4 06 12 2015   grade_7 128 1 0 0   0     0   0   67 62                       129 128 1 0 0   0     0   0   67 62                 129
737451 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No 4 06 12 2015   grade_8 119 2 0 0   0     0   1   67 55                       122 119 2 0 0   0     0   1   67 55                 122
737452 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No 4 06 12 2015   grade_9 120 2 2 1   0     1   1   61 66                       127 120 2 2 1   0     1   1   61 66                 127
737453 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No 4 06 12 2015   grade_10 108 4 3 0   0     0   2   65 52                       117 108 4 3 0   0     0   2   65 52                 117
737454 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No 4 06 12 2015   grade_11 102 3 0 0   0     0   1   50 56                       106 102 3 0 0   0     0   1   50 56                 106
737455 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No 4 06 12 2015   grade_12 88 3 0 0   0     0   0   34 57                       91 88 3 0 0   0     0   0   34 57                 91
737456 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No 4 06 12 2015   SP 6 0 0 0   0     0   0                             6 6 0 0 0   0     0   0                       6
737548 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative Education School No 4 06 12 2015   grade_7 2 0 4 0   0     0   0   5 1                       6 2 0 4 0   0     0   0   5 1                 6
737549 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative Education School No 4 06 12 2015   grade_8 4 0 8 0   0     0   0   9 3                       12 4 0 8 0   0     0   0   9 3                 12
737550 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative Education School No 4 06 12 2015   grade_9 14 0 13 0   0     0   0   17 10                       27 14 0 13 0   0     0   0   17 10                 27
737551 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative Education School No 4 06 12 2015   grade_10 4 3 18 0   0     0   3   21 7                       28 4 3 18 0   0     0   3   21 7                 28
737552 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative Education School No 4 06 12 2015   grade_11 6 0 11 0   0     0   1   10 8                       18 6 0 11 0   0     0   1   10 8                 18
737553 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative Education School No 4 06 12 2015   grade_12 6 1 4 0   0     0   0   9 2                       11 6 1 4 0   0     0   0   9 2                 11
737632 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No 4 06 12 2015   grade_6 136 6 1 0   5     0   0   75 73                       148 136 6 1 0   5     0   0   75 73                 148
737633 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No 4 06 12 2015   grade_7 117 7 3 0   6     0   0   62 71                       133 117 7 3 0   6     0   0   62 71                 133
737634 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No 4 06 12 2015   grade_8 126 4 1 0   2     0   0   61 72                       133 126 4 1 0   2     0   0   61 72                 133
737635 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No 4 06 12 2015   grade_9 91 5 1 1   1     0   0   60 39                       99 91 5 1 1   1     0   0   60 39                 99
737636 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No 4 06 12 2015   grade_10 92 3 0 0   0     0   0   46 49                       95 92 3 0 0   0     0   0   46 49                 95
737637 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No 4 06 12 2015   grade_11 105 4 0 0   2     0   1   59 53                       112 105 4 0 0   2     0   1   59 53                 112
737638 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No 4 06 12 2015   grade_12 79 5 1 0   0     0   0   39 46                       85 79 5 1 0   0     0   0   39 46                 85
737983 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No 4 01 12 2015   grade_2 * * * *   *     *   *   2 1                       3                         2 1                 3
737984 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No 4 01 12 2015   grade_7 * * * *   *     *   *   2 1                       3                         2 1                 3
737985 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No 4 01 12 2015   grade_8 2 1 3 0   0     0   1   6 1                       7 2 1 3 0   0     0   1   6 1                 7
737986 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No 4 01 12 2015   grade_9 2 1 4 0   0     0   0   5 2                       7 2 1 4 0   0     0   0   5 2                 7
737987 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No 4 01 12 2015   grade_10 2 4 4 0   0     0   0   8 2                       10 2 4 4 0   0     0   0   8 2                 10
737988 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No 4 01 12 2015   grade_12 * * * *   *     *   *   3 1                       4                         3 1                 4
738547 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2015   grade_6 80 3 3 0   11     0   2   53 46                       99 80 3 3 0   11     0   2   53 46                 99
738548 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2015   grade_7 78 1 4 0   9     0   2   45 49                       94 78 1 4 0   9     0   2   45 49                 94
738549 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2015   grade_8 83 4 3 0   12     0   1   56 47                       103 83 4 3 0   12     0   1   56 47                 103
738550 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2015   grade_9 84 2 1 0   12     0   3   56 46                       102 84 2 1 0   12     0   3   56 46                 102
738551 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2015   grade_10 89 0 1 0   12     0   1   54 49                       103 89 0 1 0   12     0   1   54 49                 103
738552 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2015   grade_11 92 0 1 0   6     0   0   54 45                       99 92 0 1 0   6     0   0   54 45                 99
738553 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2015   grade_12 96 0 1 0   8     1   4   47 63                       110 96 0 1 0   8     1   4   47 63                 110
738584 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill Alternative School   Regular School No 4 06 12 2015   grade_7 3 1 2 0   0     0   0   3 3                       6 3 1 2 0   0     0   0   3 3                 6
738585 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill Alternative School   Regular School No 4 06 12 2015   grade_8 5 2 2 0   0     0   0   8 1                       9 5 2 2 0   0     0   0   8 1                 9
738586 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill Alternative School   Regular School No 4 06 12 2015   grade_10 6 0 2 0   0     0   0   7 1                       8 6 0 2 0   0     0   0   7 1                 8

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