Data source: Big Local News · About: Big Local

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

View and edit SQL

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
2230202 MA Suffolk   school   35   Boston   350652               2018   kindergarten * * * *   *     *   *   * *                       0.0                                             0
2230203 MA Suffolk   school   35   Boston   350652               2018   pre_kindergarten * * * *   *     *   *   * *                       0.0                                             0
2230204 MA Suffolk   school   35   Boston   350652               2018   grade_1 * * * *   *     *   *   * *                       0.0                                             0
2230205 MA Suffolk   school   35   Boston   350652               2018   grade_2 * * * *   *     *   *   * *                       0.0                                             0
2230206 MA Suffolk   school   35   Boston   350652               2018   grade_3 * * * *   *     *   *   * *                       0.0                                             0
2230207 MA Suffolk   school   35   Boston   350652               2018   grade_4 * * * *   *     *   *   * *                       0.0                                             0
2230208 MA Suffolk   school   35   Boston   350652               2018   grade_5 * * * *   *     *   *   * *                       0.0                                             0
2230209 MA Suffolk   school   35   Boston   350652               2018   grade_6 * * * *   *     *   *   * *                       0.0                                             0
2230210 MA Suffolk   school   35   Boston   350652               2018   grade_7 * * * *   *     *   *   * *                       0.0                                             0
2230211 MA Suffolk   school   35   Boston   350652               2018   grade_8 * * * *   *     *   *   * *                       0.0                                             0
2230212 MA Suffolk   school   35   Boston   350652               2018   grade_9 * * * *   *     *   *   * *                       1.0                                             1
2230213 MA Suffolk   school   35   Boston   350652               2018   grade_10 * * * *   *     *   *   * *                       0.0                                             0
2230214 MA Suffolk   school   35   Boston   350652               2018   grade_11 * * * *   *     *   *   * *                       0.0                                             0
2230215 MA Suffolk   school   35   Boston   350652               2018   grade_12 * * * *   *     *   *   * *                       0.0                                             0
2230216 MA Suffolk   school   35   Boston   350652               2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
736168 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Lee Academy   Regular School No 1 PK 01 2015   kindergarten 1 45 24 1   4     0   3   40 38                       78 1 45 24 1   4     0   3   40 38                 78
736169 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Lee Academy   Regular School No 1 PK 01 2015   pre_kindergarten 4 32 12 1   8     1   0   31 27                       58 4 32 12 1   8     1   0   31 27                 58
736170 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Lee Academy   Regular School No 1 PK 01 2015   grade_1 1 50 16 0   2     0   7   36 40                       76 1 50 16 0   2     0   7   36 40                 76
736171 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Baldwin Early Learning Center   Regular School No 1 PK 01 2015   kindergarten 14 5 18 0   7     0   1   31 14                       45 14 5 18 0   7     0   1   31 14                 45
736172 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Baldwin Early Learning Center   Regular School No 1 PK 01 2015   pre_kindergarten 17 12 20 0   14     0   6   44 25                       69 17 12 20 0   14     0   6   44 25                 69
736173 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Baldwin Early Learning Center   Regular School No 1 PK 01 2015   grade_1 11 7 12 0   5     0   2   20 17                       37 11 7 12 0   5     0   2   20 17                 37
736183 MA Suffolk   school 2502790 35   Boston 250279002514 350006 ELC - West Zone   Regular School No 1 PK 01 2015   kindergarten 0 9 24 0   4     0   1   17 21                       38 0 9 24 0   4     0   1   17 21                 38
736184 MA Suffolk   school 2502790 35   Boston 250279002514 350006 ELC - West Zone   Regular School No 1 PK 01 2015   pre_kindergarten 7 5 11 0   2     0   1   16 10                       26 7 5 11 0   2     0   1   16 10                 26
736185 MA Suffolk   school 2502790 35   Boston 250279002514 350006 ELC - West Zone   Regular School No 1 PK 01 2015   grade_1 1 18 13 0   0     0   1   19 14                       33 1 18 13 0   0     0   1   19 14                 33
736191 MA Suffolk   school 2502790 35   Boston 250279001118 350009 East Boston Early Childhood Center   Regular School No 1 PK 01 2015   kindergarten 9 2 44 0   3     0   0   32 26                       58 9 2 44 0   3     0   0   32 26                 58
736192 MA Suffolk   school 2502790 35   Boston 250279001118 350009 East Boston Early Childhood Center   Regular School No 1 PK 01 2015   pre_kindergarten 19 4 47 0   1     0   3   42 32                       74 19 4 47 0   1     0   3   42 32                 74
736193 MA Suffolk   school 2502790 35   Boston 250279001118 350009 East Boston Early Childhood Center   Regular School No 1 PK 01 2015   grade_1 8 4 28 0   1     0   0   23 18                       41 8 4 28 0   1     0   0   23 18                 41
736194 MA Suffolk   school 2502790 35   Boston 250279001126 350010 Haynes Early Education Center   Regular School No 1 PK 01 2015   kindergarten 1 37 24 0   2     0   1   34 31                       65 1 37 24 0   2     0   1   34 31                 65
736195 MA Suffolk   school 2502790 35   Boston 250279001126 350010 Haynes Early Education Center   Regular School No 1 PK 01 2015   pre_kindergarten 1 22 19 0   1     0   0   28 15                       43 1 22 19 0   1     0   0   28 15                 43
736196 MA Suffolk   school 2502790 35   Boston 250279001126 350010 Haynes Early Education Center   Regular School No 1 PK 01 2015   grade_1 1 36 26 1   2     0   4   31 39                       70 1 36 26 1   2     0   4   31 39                 70
737736 MA Norfolk   school 2504050 73   Dedham 250405000460 730005 Early Childhood Center   Regular School No 1 PK 01 2015   kindergarten 144 7 27 1   6     0   9   99 95                       194 144 7 27 1   6     0   9   99 95                 194
737737 MA Norfolk   school 2504050 73   Dedham 250405000460 730005 Early Childhood Center   Regular School No 1 PK 01 2015   pre_kindergarten 77 6 14 1   4     0   7   62 47                       109 77 6 14 1   4     0   7   62 47                 109
737738 MA Norfolk   school 2504050 73   Dedham 250405000460 730005 Early Childhood Center   Regular School No 1 PK 01 2015   grade_1 * * * *   *     *   *   2 1                       3                         2 1                 3
737774 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No 1 PK 01 2015   kindergarten 84 0 0 0   2     0   1   46 41                       87 84 0 0 0   2     0   1   46 41                 87
737775 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No 1 PK 01 2015   pre_kindergarten 64 0 2 0   0     0   1   31 36                       67 64 0 2 0   0     0   1   31 36                 67
737776 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No 1 PK 01 2015   grade_1 78 0 0 0   1     0   3   44 38                       82 78 0 0 0   1     0   3   44 38                 82
738373 MA Essex   school 2505220 105   Georgetown 250522000766 1050005 Perley Elementary   Regular School No 1 PK 01 2015   kindergarten 82 1 2 0   1     0   0   45 41                       86 82 1 2 0   1     0   0   45 41                 86
738374 MA Essex   school 2505220 105   Georgetown 250522000766 1050005 Perley Elementary   Regular School No 1 PK 01 2015   pre_kindergarten 83 0 2 0   4     0   1   44 46                       90 83 0 2 0   4     0   1   44 46                 90
738375 MA Essex   school 2505220 105   Georgetown 250522000766 1050005 Perley Elementary   Regular School No 1 PK 01 2015   grade_1 113 0 2 0   0     1   2   64 54                       118 113 0 2 0   0     1   2   64 54                 118
738427 MA Worcester   school 2505370 110   Grafton 250537000788 1100005 South Grafton Elementary   Regular School No 1 PK 01 2015   kindergarten 93 0 6 0   24     0   2   68 57                       125 93 0 6 0   24     0   2   68 57                 125
738428 MA Worcester   school 2505370 110   Grafton 250537000788 1100005 South Grafton Elementary   Regular School No 1 PK 01 2015   pre_kindergarten 36 0 3 0   11     0   5   26 29                       55 36 0 3 0   11     0   5   26 29                 55
738429 MA Worcester   school 2505370 110   Grafton 250537000788 1100005 South Grafton Elementary   Regular School No 1 PK 01 2015   grade_1 95 0 8 0   24     0   1   66 62                       128 95 0 8 0   24     0   1   66 62                 128
738430 MA Worcester   school 2505370 110   Grafton 250537000787 1100025 North Grafton Elementary   Regular School No 1 PK 01 2015   kindergarten 101 0 6 0   8     0   6   60 61                       121 101 0 6 0   8     0   6   60 61                 121
738431 MA Worcester   school 2505370 110   Grafton 250537000787 1100025 North Grafton Elementary   Regular School No 1 PK 01 2015   pre_kindergarten 44 0 3 0   4     0   1   32 20                       52 44 0 3 0   4     0   1   32 20                 52
738432 MA Worcester   school 2505370 110   Grafton 250537000787 1100025 North Grafton Elementary   Regular School No 1 PK 01 2015   grade_1 91 2 4 1   4     0   4   63 43                       106 91 2 4 1   4     0   4   63 43                 106
738568 MA Essex   school 2505970 128   Haverhill 250597002769 1280005 Bartlett Kindergarten Center   Regular School No 1 KG 01 2015   kindergarten 61 3 54 0   2     0   6   62 64                       126 61 3 54 0   2     0   6   62 64                 126
738796 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Center   Regular School No 1 KG 01 2015   kindergarten 173 2 7 1   25     1   7   116 100                       216 173 2 7 1   25     1   7   116 100                 216
738797 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Center   Regular School No 1 KG 01 2015   grade_1 175 2 10 0   25     0   15   110 117                       227 175 2 10 0   25     0   15   110 117                 227
739365 MA Hampden   school 2507050 161   Ludlow 250705002663 1610010 East Street Elementary School   Regular School No 1 PK 01 2015   kindergarten 127 2 17 2   1     0   7   71 85                       156 127 2 17 2   1     0   7   71 85                 156
739366 MA Hampden   school 2507050 161   Ludlow 250705002663 1610010 East Street Elementary School   Regular School No 1 PK 01 2015   pre_kindergarten 51 0 6 0   1     0   3   37 24                       61 51 0 6 0   1     0   3   37 24                 61
739367 MA Hampden   school 2507050 161   Ludlow 250705002663 1610010 East Street Elementary School   Regular School No 1 PK 01 2015   grade_1 158 2 27 0   0     0   5   95 97                       192 158 2 27 0   0     0   5   95 97                 192
739632 MA Essex   school 2507260 168   Marblehead 250726001120 1680015 Elbridge Gerry   Regular School No 1 KG 01 2015   kindergarten 51 2 6 0   3     0   6   35 33                       68 51 2 6 0   3     0   6   35 33                 68
739633 MA Essex   school 2507260 168   Marblehead 250726001120 1680015 Elbridge Gerry   Regular School No 1 KG 01 2015   grade_1 67 0 6 0   2     0   1   39 37                       76 67 0 6 0   2     0   1   39 37                 76
739757 MA Norfolk   school 2507530 175   Medfield 250753000114 1750003 Memorial School   Regular School No 1 PK 01 2015   kindergarten 129 0 9 2   8     0   0   86 62                       148 129 0 9 2   8     0   0   86 62                 148
739758 MA Norfolk   school 2507530 175   Medfield 250753000114 1750003 Memorial School   Regular School No 1 PK 01 2015   pre_kindergarten 56 0 1 0   1     0   1   32 27                       59 56 0 1 0   1     0   1   32 27                 59
739759 MA Norfolk   school 2507530 175   Medfield 250753000114 1750003 Memorial School   Regular School No 1 PK 01 2015   grade_1 149 1 11 0   7     0   2   82 88                       170 149 1 11 0   7     0   2   82 88                 170
739818 MA Norfolk   school 2507590 177   Medway 250759001185 1770013 John D Mc Govern Elementary   Regular School No 1 PK 01 2015   kindergarten 129 1 4 0   1     0   2   71 66                       137 129 1 4 0   1     0   2   71 66                 137
739819 MA Norfolk   school 2507590 177   Medway 250759001185 1770013 John D Mc Govern Elementary   Regular School No 1 PK 01 2015   pre_kindergarten 42 0 1 0   1     0   0   33 11                       44 42 0 1 0   1     0   0   33 11                 44
739820 MA Norfolk   school 2507590 177   Medway 250759001185 1770013 John D Mc Govern Elementary   Regular School No 1 PK 01 2015   grade_1 149 3 6 0   3     0   4   72 93                       165 149 3 6 0   3     0   4   72 93                 165
740603 MA Worcester   school 2508940 214   Northbridge 250894002682 2140005 Northbridge Elementary   Regular School No 1 PK 01 2015   kindergarten 162 1 13 0   1     0   11   88 100                       188 162 1 13 0   1     0   11   88 100                 188
740604 MA Worcester   school 2508940 214   Northbridge 250894002682 2140005 Northbridge Elementary   Regular School No 1 PK 01 2015   pre_kindergarten 89 0 3 0   1     0   5   55 43                       98 89 0 3 0   1     0   5   55 43                 98
740605 MA Worcester   school 2508940 214   Northbridge 250894002682 2140005 Northbridge Elementary   Regular School No 1 PK 01 2015   grade_1 175 2 17 0   1     0   6   110 91                       201 175 2 17 0   1     0   6   110 91                 201
741546 MA Worcester   school 2510770 271   Shrewsbury 251077002496 2710005 Beal School   Regular School No 1 KG 01 2015   kindergarten 115 5 21 1   71     0   12   114 111                       225 115 5 21 1   71     0   12   114 111                 225
741547 MA Worcester   school 2510770 271   Shrewsbury 251077002496 2710005 Beal School   Regular School No 1 KG 01 2015   grade_1 32 3 5 1   39     0   4   38 46                       84 32 3 5 1   39     0   4   38 46                 84
741695 MA Worcester   school 2510980 276   Southborough 251098001761 2760008 Mary E Finn School   Regular School No 1 PK 01 2015   kindergarten 87 2 5 0   18     0   7   64 55                       119 87 2 5 0   18     0   7   64 55                 119
741696 MA Worcester   school 2510980 276   Southborough 251098001761 2760008 Mary E Finn School   Regular School No 1 PK 01 2015   pre_kindergarten 24 0 4 0   8     0   4   26 14                       40 24 0 4 0   8     0   4   26 14                 40
741697 MA Worcester   school 2510980 276   Southborough 251098001761 2760008 Mary E Finn School   Regular School No 1 PK 01 2015   grade_1 71 2 13 0   17     0   4   54 53                       107 71 2 13 0   17     0   4   54 53                 107
741724 MA Hampshire   school 2510920 278   South Hadley 251092001753 2780015 Plains Elementary   Regular School No 1 PK 01 2015   kindergarten 107 0 20 1   0     0   9   67 70                       137 107 0 20 1   0     0   9   67 70                 137
741725 MA Hampshire   school 2510920 278   South Hadley 251092001753 2780015 Plains Elementary   Regular School No 1 PK 01 2015   pre_kindergarten 52 0 6 0   1     0   6   36 29                       65 52 0 6 0   1     0   6   36 29                 65
741726 MA Hampshire   school 2510920 278   South Hadley 251092001753 2780015 Plains Elementary   Regular School No 1 PK 01 2015   grade_1 91 0 12 0   2     0   7   68 44                       112 91 0 12 0   2     0   7   68 44                 112
741808 MA Hampden   school 2511130 281   Springfield 251113001817 2810060 Margaret C Ells   Regular School No 1 PK 01 2015   kindergarten 7 14 27 0   1     0   1   24 26                       50 7 14 27 0   1     0   1   24 26                 50
741809 MA Hampden   school 2511130 281   Springfield 251113001817 2810060 Margaret C Ells   Regular School No 1 PK 01 2015   pre_kindergarten 27 34 62 0   2     0   6   73 58                       131 27 34 62 0   2     0   6   73 58                 131
741810 MA Hampden   school 2511130 281   Springfield 251113001817 2810060 Margaret C Ells   Regular School No 1 PK 01 2015   grade_1 8 14 18 0   0     0   1   27 14                       41 8 14 18 0   0     0   1   27 14                 41
742785 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No 1 PK 01 2015   kindergarten 102 0 2 0   1     0   5   55 55                       110 102 0 2 0   1     0   5   55 55                 110
742786 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No 1 PK 01 2015   pre_kindergarten 70 0 1 0   0     0   2   41 32                       73 70 0 1 0   0     0   2   41 32                 73
742787 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No 1 PK 01 2015   grade_1 100 0 1 0   0     0   8   57 52                       109 100 0 1 0   0     0   8   57 52                 109
744002 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000397 6100010 Meetinghouse School   Regular School No 1 KG 01 2015   kindergarten 63 1 5 0   0     0   3   40 32                       72 63 1 5 0   0     0   3   40 32                 72
744003 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000397 6100010 Meetinghouse School   Regular School No 1 KG 01 2015   grade_1 74 1 5 0   0     0   5   47 38                       85 74 1 5 0   0     0   5   47 38                 85
744115 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002102 6250020 Merrill Elementary School   Regular School No 1 KG 01 2015   kindergarten 131 7 2 0   3     0   2   64 81                       145 131 7 2 0   3     0   2   64 81                 145
744116 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002102 6250020 Merrill Elementary School   Regular School No 1 KG 01 2015   grade_1 137 4 4 0   2     0   4   81 70                       151 137 4 4 0   2     0   4   81 70                 151
744238 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000590 6580010 Mason Road School   Regular School No 1 PK 01 2015   kindergarten 100 1 10 0   0     0   2   68 45                       113 100 1 10 0   0     0   2   68 45                 113
744239 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000590 6580010 Mason Road School   Regular School No 1 PK 01 2015   pre_kindergarten 40 2 1 0   0     0   1   24 20                       44 40 2 1 0   0     0   1   24 20                 44
744240 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000590 6580010 Mason Road School   Regular School No 1 PK 01 2015   grade_1 92 4 10 0   1     0   4   52 59                       111 92 4 10 0   1     0   4   52 59                 111
744241 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000585 6580020 Charlton Elementary   Regular School No 1 PK 01 2015   kindergarten 128 3 7 0   0     0   4   77 65                       142 128 3 7 0   0     0   4   77 65                 142
744242 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000585 6580020 Charlton Elementary   Regular School No 1 PK 01 2015   pre_kindergarten 54 2 4 0   2     0   0   35 27                       62 54 2 4 0   2     0   0   35 27                 62
744243 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000585 6580020 Charlton Elementary   Regular School No 1 PK 01 2015   grade_1 135 1 9 0   3     0   4   75 77                       152 135 1 9 0   3     0   4   75 77                 152
744349 MA Franklin   school 2505270 674   Gill-Montague 250527002816 6740015 Hillcrest Elementary School   Regular School No 1 PK 01 2015   kindergarten 38 1 9 0   0     0   6   35 19                       54 38 1 9 0   0     0   6   35 19                 54
744350 MA Franklin   school 2505270 674   Gill-Montague 250527002816 6740015 Hillcrest Elementary School   Regular School No 1 PK 01 2015   pre_kindergarten 34 1 6 0   0     0   5   21 25                       46 34 1 6 0   0     0   5   21 25                 46
744351 MA Franklin   school 2505270 674   Gill-Montague 250527002816 6740015 Hillcrest Elementary School   Regular School No 1 PK 01 2015   grade_1 38 3 11 0   0     1   7   35 25                       60 38 3 11 0   0     1   7   35 25                 60
744396 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001598 6800025 Mile Tree Elementary   Regular School No 1 PK 01 2015   kindergarten 109 1 10 0   3     0   8   69 62                       131 109 1 10 0   3     0   8   69 62                 131
744397 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001598 6800025 Mile Tree Elementary   Regular School No 1 PK 01 2015   pre_kindergarten 32 1 4 0   2     0   3   23 19                       42 32 1 4 0   2     0   3   23 19                 42
744398 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001598 6800025 Mile Tree Elementary   Regular School No 1 PK 01 2015   grade_1 129 2 7 0   2     0   4   74 70                       144 129 2 7 0   2     0   4   74 70                 144
744567 MA Worcester   school 2508280 720   Narragansett 250828001288 7200020 Templeton Center   Regular School No 1 KG 01 2015   kindergarten 77 0 2 0   0     0   1   41 39                       80 77 0 2 0   0     0   1   41 39                 80
744568 MA Worcester   school 2508280 720   Narragansett 250828001288 7200020 Templeton Center   Regular School No 1 KG 01 2015   grade_1 77 0 3 0   1     0   3   49 35                       84 77 0 3 0   1     0   3   49 35                 84
744740 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No 1 PK 01 2015   kindergarten 33 0 0 0   0     0   0   10 23                       33 33 0 0 0   0     0   0   10 23                 33
744741 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No 1 PK 01 2015   pre_kindergarten 66 0 7 0   0     0   2   33 42                       75 66 0 7 0   0     0   2   33 42                 75
744742 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No 1 PK 01 2015   grade_1 21 0 3 0   0     0   0   14 10                       24 21 0 3 0   0     0   0   14 10                 24
744792 MA Berkshire   school 2511040 765   Southern Berkshire 251104001778 7650030 South Egremont   Regular School No 1 KG 01 2015   kindergarten 8 0 0 0   0     0   0   * 6                       8 8 0 0 0   0     0   0     6                 8
744793 MA Berkshire   school 2511040 765   Southern Berkshire 251104001778 7650030 South Egremont   Regular School No 1 KG 01 2015   grade_1 * * * *   *     *   *   * 2                       5                           2                 5
744839 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000202408 7670010 Lake Street   Regular School No 1 PK 01 2015   kindergarten 99 1 8 0   1     0   1   62 48                       110 99 1 8 0   1     0   1   62 48                 110

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