enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american ▼ native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
736765 736765 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Lilla G. Frederick Middle School   Regular School No 2 06 08 2015   grade_8 3 104 105 0   3     1   5   126 95                       221 3 104 105 0   3     1   5   126 95                 221
736766 736766 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No 1 PK 05 2015   kindergarten 1 17 53 0   0     0   1   37 35                       72 1 17 53 0   0     0   1   37 35                 72
736767 736767 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No 1 PK 05 2015   pre_kindergarten 3 15 53 0   1     0   0   40 32                       72 3 15 53 0   1     0   0   40 32                 72
736768 736768 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No 1 PK 05 2015   grade_1 2 32 63 0   0     1   1   46 53                       99 2 32 63 0   0     1   1   46 53                 99
736769 736769 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No 1 PK 05 2015   grade_2 3 27 75 0   0     0   2   50 57                       107 3 27 75 0   0     0   2   50 57                 107
736770 736770 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No 1 PK 05 2015   grade_3 3 22 72 0   0     0   1   43 55                       98 3 22 72 0   0     0   1   43 55                 98
736771 736771 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No 1 PK 05 2015   grade_4 3 11 69 0   1     0   0   43 41                       84 3 11 69 0   1     0   0   43 41                 84
736772 736772 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No 1 PK 05 2015   grade_5 0 13 54 0   1     0   1   38 31                       69 0 13 54 0   1     0   1   38 31                 69
736774 736774 MA Suffolk   school 2502790 35   Boston 250279001615 350413 Boston Middle School Academy   Regular School No 2 07 08 2015   grade_8 0 5 2 0   0     0   0   5 *                       7 0 5 2 0   0     0   0   5                   7
736775 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 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 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
736779 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
736782 736782 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No 2 06 08 2015   grade_6 15 13 86 0   7     0   0   69 52                       121 15 13 86 0   7     0   0   69 52                 121
736783 736783 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No 2 06 08 2015   grade_7 7 20 83 0   17     0   0   66 61                       127 7 20 83 0   17     0   0   66 61                 127
736784 736784 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No 2 06 08 2015   grade_8 11 16 121 0   18     0   2   97 71                       168 11 16 121 0   18     0   2   97 71                 168
736786 736786 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Washington Irving Middle   Regular School No 2 06 08 2015   grade_7 3 55 43 0   0     0   4   63 42                       105 3 55 43 0   0     0   4   63 42                 105
736787 736787 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Washington Irving Middle   Regular School No 2 06 08 2015   grade_8 6 62 60 0   3     0   5   71 65                       136 6 62 60 0   3     0   5   71 65                 136
736788 736788 MA Suffolk   school 2502790 35   Boston 250279000345 350470 Wm B Rogers Middle   Regular School No 2 06 08 2015   grade_6 2 39 32 0   0     0   0   41 32                       73 2 39 32 0   0     0   0   41 32                 73
736789 736789 MA Suffolk   school 2502790 35   Boston 250279000345 350470 Wm B Rogers Middle   Regular School No 2 06 08 2015   grade_7 2 56 34 0   4     0   4   51 49                       100 2 56 34 0   4     0   4   51 49                 100
736791 736791 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No 2 06 08 2015   grade_6 2 44 94 0   2     0   3   76 69                       145 2 44 94 0   2     0   3   76 69                 145
736792 736792 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No 2 06 08 2015   grade_7 0 53 99 0   0     0   3   89 66                       155 0 53 99 0   0     0   3   89 66                 155
736793 736793 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No 2 06 08 2015   grade_8 3 72 110 0   0     1   0   74 112                       186 3 72 110 0   0     1   0   74 112                 186
736796 736796 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Brighton High   Regular School No 3 09 12 2015   grade_11 11 113 97 0   6     0   6   128 105                       233 11 113 97 0   6     0   6   128 105                 233
736798 736798 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Brighton High   Regular School No 3 09 12 2015   SP 1 5 8 0   0     0   0                             14 1 5 8 0   0     0   0                       14
736799 736799 MA Suffolk   school 2502790 35   Boston 250279002015 350507 Boston International High School   Regular School No 3 09 12 2015   grade_9 1 56 111 0   5     0   2   94 81                       175 1 56 111 0   5     0   2   94 81                 175
736800 736800 MA Suffolk   school 2502790 35   Boston 250279002015 350507 Boston International High School   Regular School No 3 09 12 2015   grade_10 1 53 22 0   4     0   2   40 42                       82 1 53 22 0   4     0   2   40 42                 82
736801 736801 MA Suffolk   school 2502790 35   Boston 250279002015 350507 Boston International High School   Regular School No 3 09 12 2015   grade_11 2 32 27 0   4     0   1   38 28                       66 2 32 27 0   4     0   1   38 28                 66
736802 736802 MA Suffolk   school 2502790 35   Boston 250279002015 350507 Boston International High School   Regular School No 3 09 12 2015   grade_12 1 23 33 0   1     0   0   27 31                       58 1 23 33 0   1     0   0   27 31                 58
736804 736804 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No 3 09 12 2015   grade_10 7 69 71 0   53     0   0   108 92                       200 7 69 71 0   53     0   0   108 92                 200
736807 736807 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No 3 09 12 2015   SP 10 19 8 0   4     0   0                             41 10 19 8 0   4     0   0                       41
736808 736808 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Community Academy   Regular School No 3 09 12 2015   grade_9 3 4 1 0   0     0   0   5 3                       8 3 4 1 0   0     0   0   5 3                 8
736809 736809 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Community Academy   Regular School No 3 09 12 2015   grade_10 2 8 4 0   0     0   0   9 5                       14 2 8 4 0   0     0   0   9 5                 14
736810 736810 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Community Academy   Regular School No 3 09 12 2015   grade_11 5 6 2 0   0     0   0   10 3                       13 5 6 2 0   0     0   0   10 3                 13
736811 736811 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Community Academy   Regular School No 3 09 12 2015   grade_12 11 13 3 0   0     0   0   22 5                       27 11 13 3 0   0     0   0   22 5                 27
736814 736814 MA Suffolk   school 2502790 35   Boston 250279002016 350522 Excel High School   Regular School No 3 09 12 2015   grade_11 23 65 40 0   34     0   4   105 61                       166 23 65 40 0   34     0   4   105 61                 166
736815 736815 MA Suffolk   school 2502790 35   Boston 250279002016 350522 Excel High School   Regular School No 3 09 12 2015   grade_12 10 51 24 0   52     0   4   82 59                       141 10 51 24 0   52     0   4   82 59                 141
736817 736817 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Jeremiah E Burke High   Regular School No 3 09 12 2015   grade_9 4 90 38 0   2     0   1   85 50                       135 4 90 38 0   2     0   1   85 50                 135
736820 736820 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Jeremiah E Burke High   Regular School No 3 09 12 2015   grade_12 3 120 23 0   2     0   1   73 76                       149 3 120 23 0   2     0   1   73 76                 149
736825 736825 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No 3 09 12 2015   grade_12 73 55 223 0   8     0   1   206 154                       360 73 55 223 0   8     0   1   206 154                 360
736829 736829 MA Suffolk   school 2502790 35   Boston 250279000327 350535 The English High   Regular School No 3 09 12 2015   grade_11 4 55 60 0   1     0   1   64 57                       121 4 55 60 0   1     0   1   64 57                 121
736832 736832 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Vocational Education School No 3 09 12 2015   grade_9 6 54 94 0   2     0   2   92 66                       158 6 54 94 0   2     0   2   92 66                 158
736835 736835 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Vocational Education School No 3 09 12 2015   grade_12 9 100 104 0   5     0   6   128 96                       224 9 100 104 0   5     0   6   128 96                 224
736836 736836 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Vocational Education School No 3 09 12 2015   SP 3 12 5 0   2     0   0                             22 3 12 5 0   2     0   0                       22
736837 736837 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative Education School No 3 09 12 2015   grade_9 5 30 40 0   3     0   3   41 40                       81 5 30 40 0   3     0   3   41 40                 81
736838 736838 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative Education School No 3 09 12 2015   grade_10 8 30 43 0   2     0   1   39 45                       84 8 30 43 0   2     0   1   39 45                 84
736840 736840 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative Education School No 3 09 12 2015   grade_12 7 29 39 0   4     0   0   31 48                       79 7 29 39 0   4     0   0   31 48                 79
736841 736841 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Another Course To College   Alternative Education School No 3 09 12 2015   grade_9 4 32 19 0   4     1   2   33 29                       62 4 32 19 0   4     1   2   33 29                 62
736843 736843 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Another Course To College   Alternative Education School No 3 09 12 2015   grade_11 5 25 24 0   4     0   1   21 38                       59 5 25 24 0   4     0   1   21 38                 59
736844 736844 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Another Course To College   Alternative Education School No 3 09 12 2015   grade_12 5 29 20 0   1     0   0   30 25                       55 5 29 20 0   1     0   0   30 25                 55
736848 736848 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative Education School No 3 09 12 2015   grade_12 1 45 21 0   1     0   0   40 28                       68 1 45 21 0   1     0   0   40 28                 68
736849 736849 MA Suffolk   school 2502790 35   Boston 250279000837 350543 Greater Egleston Community High School   Regular School No 3 09 12 2015   grade_9 0 2 5 0   0     0   0   4 3                       7 0 2 5 0   0     0   0   4 3                 7
736850 736850 MA Suffolk   school 2502790 35   Boston 250279000837 350543 Greater Egleston Community High School   Regular School No 3 09 12 2015   grade_10 5 16 21 0   0     0   0   19 23                       42 5 16 21 0   0     0   0   19 23                 42
736851 736851 MA Suffolk   school 2502790 35   Boston 250279000837 350543 Greater Egleston Community High School   Regular School No 3 09 12 2015   grade_11 3 11 22 0   1     0   1   18 20                       38 3 11 22 0   1     0   1   18 20                 38
736854 736854 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No 3 07 12 2015   grade_7 91 42 58 0   69     0   11   116 155                       271 91 42 58 0   69     0   11   116 155                 271
736861 736861 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative Education School No 3 09 12 2015   grade_10 18 38 57 0   6     0   4   39 84                       123 18 38 57 0   6     0   4   39 84                 123
736863 736863 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative Education School No 3 09 12 2015   grade_12 15 41 38 0   0     0   3   32 65                       97 15 41 38 0   0     0   3   32 65                 97
736864 736864 MA Suffolk   school 2502790 35   Boston 250279001511 350548 Boston Adult Academy   Alternative Education School No 3 11 12 2015   grade_11 1 30 23 0   4     0   0   34 24                       58 1 30 23 0   4     0   0   34 24                 58
736866 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 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
736870 736870 MA Suffolk   school 2502790 35   Boston 250279001692 350558 Boston Community Leadership Academy   Regular School No 3 09 12 2015   grade_10 10 59 75 0   5     0   2   68 83                       151 10 59 75 0   5     0   2   68 83                 151
736871 736871 MA Suffolk   school 2502790 35   Boston 250279001692 350558 Boston Community Leadership Academy   Regular School No 3 09 12 2015   grade_11 13 50 63 0   6     0   3   59 76                       135 13 50 63 0   6     0   3   59 76                 135
736873 736873 MA Suffolk   school 2502790 35   Boston 250279001692 350558 Boston Community Leadership Academy   Regular School No 3 09 12 2015   SP 2 3 2 0   0     0   0                             7 2 3 2 0   0     0   0                       7
736874 736874 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No 3 07 12 2015   grade_7 202 29 55 0   103     0   17   183 223                       406 202 29 55 0   103     0   17   183 223                 406
736875 736875 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No 3 07 12 2015   grade_8 218 28 40 0   111     0   15   180 232                       412 218 28 40 0   111     0   15   180 232                 412
736876 736876 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No 3 07 12 2015   grade_9 185 59 78 0   111     0   15   193 255                       448 185 59 78 0   111     0   15   193 255                 448
736877 736877 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No 3 07 12 2015   grade_10 189 35 44 0   113     1   13   186 209                       395 189 35 44 0   113     1   13   186 209                 395
736878 736878 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No 3 07 12 2015   grade_11 187 40 37 0   142     1   8   207 208                       415 187 40 37 0   142     1   8   207 208                 415
736879 736879 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No 3 07 12 2015   grade_12 177 30 34 0   110     0   12   167 196                       363 177 30 34 0   110     0   12   167 196                 363
736880 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 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 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 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 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 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 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 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
736890 736890 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No 3 07 12 2015   grade_9 30 112 98 0   72     0   11   154 169                       323 30 112 98 0   72     0   11   154 169                 323
736892 736892 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No 3 07 12 2015   grade_11 33 100 67 0   59     0   5   122 142                       264 33 100 67 0   59     0   5   122 142                 264
736893 736893 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No 3 07 12 2015   grade_12 31 91 57 0   57     1   1   111 127                       238 31 91 57 0   57     1   1   111 127                 238
736894 736894 MA Suffolk   school 2502790 35   Boston 250279001898 350579 Urban Science Academy   Regular School No 3 09 12 2015   grade_9 14 63 55 0   1     0   3   82 54                       136 14 63 55 0   1     0   3   82 54                 136
736895 736895 MA Suffolk   school 2502790 35   Boston 250279001898 350579 Urban Science Academy   Regular School No 3 09 12 2015   grade_10 10 57 28 0   0     0   2   59 38                       97 10 57 28 0   0     0   2   59 38                 97
736896 736896 MA Suffolk   school 2502790 35   Boston 250279001898 350579 Urban Science Academy   Regular School No 3 09 12 2015   grade_11 8 65 58 0   4     0   3   74 64                       138 8 65 58 0   4     0   3   74 64                 138
736898 736898 MA Suffolk   school 2502790 35   Boston 250279001898 350579 Urban Science Academy   Regular School No 3 09 12 2015   SP 1 7 0 0   1     0   0                             9 1 7 0 0   1     0   0                       9
736899 736899 MA Suffolk   school 2502790 35   Boston 250279001902 350581 Community Academy of Science and Health   Regular School No 3 09 12 2015   grade_9 3 75 22 0   1     0   1   62 40                       102 3 75 22 0   1     0   1   62 40                 102
736901 736901 MA Suffolk   school 2502790 35   Boston 250279001902 350581 Community Academy of Science and Health   Regular School No 3 09 12 2015   grade_11 2 84 16 0   1     0   1   55 49                       104 2 84 16 0   1     0   1   55 49                 104
736902 736902 MA Suffolk   school 2502790 35   Boston 250279001902 350581 Community Academy of Science and Health   Regular School No 3 09 12 2015   grade_12 2 51 10 0   2     0   2   34 33                       67 2 51 10 0   2     0   2   34 33                 67
736904 736904 MA Suffolk   school 2502790 35   Boston 250279002676 350651 Dorchester Academy   Regular School No 3 09 12 2015   grade_9 3 55 27 0   2     0   2   52 37                       89 3 55 27 0   2     0   2   52 37                 89
736908 736908 MA Suffolk   school 2502790 35   Boston 250279002676 350651 Dorchester Academy   Regular School No 3 09 12 2015   SP 1 7 1 0   0     0   1                             10 1 7 1 0   0     0   1                       10
736909 736909 MA Suffolk   school 2502790 35   Boston 250279002674 350655 Lyon Upper 9-12   Regular School No 3 09 12 2015   grade_9 11 12 7 0   0     0   1   20 11                       31 11 12 7 0   0     0   1   20 11                 31
736910 736910 MA Suffolk   school 2502790 35   Boston 250279002674 350655 Lyon Upper 9-12   Regular School No 3 09 12 2015   grade_10 13 8 14 0   0     0   0   19 16                       35 13 8 14 0   0     0   0   19 16                 35
736911 736911 MA Suffolk   school 2502790 35   Boston 250279002674 350655 Lyon Upper 9-12   Regular School No 3 09 12 2015   grade_11 13 9 11 0   1     0   2   20 16                       36 13 9 11 0   1     0   2   20 16                 36
736912 736912 MA Suffolk   school 2502790 35   Boston 250279002674 350655 Lyon Upper 9-12   Regular School No 3 09 12 2015   grade_12 9 9 9 0   3     0   2   20 12                       32 9 9 9 0   3     0   2   20 12                 32
736913 736913 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No 1 KG 08 2015   kindergarten 6 3 54 0   1     0   0   27 37                       64 6 3 54 0   1     0   0   27 37                 64
736914 736914 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No 1 KG 08 2015   grade_1 3 2 58 0   0     0   1   38 26                       64 3 2 58 0   0     0   1   38 26                 64
736915 736915 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No 1 KG 08 2015   grade_2 5 6 64 0   0     0   2   47 30                       77 5 6 64 0   0     0   2   47 30                 77
736916 736916 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No 1 KG 08 2015   grade_3 2 4 63 0   0     0   0   30 39                       69 2 4 63 0   0     0   0   30 39                 69
736917 736917 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No 1 KG 08 2015   grade_4 0 4 22 0   0     0   0   10 16                       26 0 4 22 0   0     0   0   10 16                 26
736918 736918 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No 1 KG 08 2015   grade_5 0 5 20 0   0     0   1   12 14                       26 0 5 20 0   0     0   1   12 14                 26
736919 736919 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No 1 KG 08 2015   grade_6 19 11 129 0   9     0   2   83 87                       170 19 11 129 0   9     0   2   83 87                 170

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