enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 11,164 ✖
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
1125803 1125803 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No Elementary 01 04 2017   grade_3 2 2 131 0   2     0   2   77 62                       139 2 2 131 0   2     0   2   77 62                 139
1125804 1125804 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No Elementary 01 04 2017   grade_4 5 0 113 0   0     0   0   56 62                       118 5 0 113 0   0     0   0   56 62                 118
1125805 1125805 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No Elementary 01 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125823 1125823 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2017   grade_1 7 2 87 0   0     0   0   43 53                       96 7 2 87 0   0     0   0   43 53                 96
1125824 1125824 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2017   grade_2 6 0 95 0   1     0   1   62 41                       103 6 0 95 0   1     0   1   62 41                 103
1125825 1125825 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2017   grade_3 2 3 88 0   1     0   0   43 51                       94 2 3 88 0   1     0   0   43 51                 94
1125826 1125826 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2017   grade_4 3 0 99 0   0     0   2   56 48                       104 3 0 99 0   0     0   2   56 48                 104
1125827 1125827 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2017   grade_5 7 1 95 0   0     0   0   54 49                       103 7 1 95 0   0     0   0   54 49                 103
1125828 1125828 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125839 1125839 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2017   grade_1 3 0 71 0   0     1   1   44 32                       76 3 0 71 0   0     1   1   44 32                 76
1125840 1125840 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2017   grade_2 1 0 75 0   0     0   0   45 31                       76 1 0 75 0   0     0   0   45 31                 76
1125841 1125841 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2017   grade_3 1 0 79 0   0     0   0   38 42                       80 1 0 79 0   0     0   0   38 42                 80
1125842 1125842 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2017   grade_4 0 0 76 0   0     0   2   38 40                       78 0 0 76 0   0     0   2   38 40                 78
1125843 1125843 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2017   grade_5 1 1 51 0   0     0   0   26 27                       53 1 1 51 0   0     0   0   26 27                 53
1125844 1125844 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125878 1125878 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_1 1 0 7 0   0     0   0   5 3                       8 1 0 7 0   0     0   0   5 3                 8
1125879 1125879 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_2 1 0 9 0   0     0   0   6 4                       10 1 0 9 0   0     0   0   6 4                 10
1125880 1125880 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_3 1 0 7 0   0     0   0   7 1                       8 1 0 7 0   0     0   0   7 1                 8
1125881 1125881 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_4 1 0 11 0   0     0   1   12 1                       13 1 0 11 0   0     0   1   12 1                 13
1125882 1125882 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_5 2 0 9 0   0     0   0   9 2                       11 2 0 9 0   0     0   0   9 2                 11
1125883 1125883 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_6 2 0 13 0   0     0   0   13 2                       15 2 0 13 0   0     0   0   13 2                 15
1125884 1125884 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_7 2 1 10 0   0     0   0   11 2                       13 2 1 10 0   0     0   0   11 2                 13
1125885 1125885 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_8 1 0 17 0   1     0   0   15 4                       19 1 0 17 0   1     0   0   15 4                 19
1125886 1125886 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_9 4 0 11 0   0     0   0   11 4                       15 4 0 11 0   0     0   0   11 4                 15
1125887 1125887 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_10 2 0 10 0   0     0   0   9 3                       12 2 0 10 0   0     0   0   9 3                 12
1125888 1125888 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_11 0 1 16 0   0     0   0   15 2                       17 0 1 16 0   0     0   0   15 2                 17
1125889 1125889 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_12 1 1 14 0   0     0   0   13 3                       16 1 1 14 0   0     0   0   13 3                 16
1125890 1125890 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   sped_beyond_grade_12 3 1 15 0   0     0   0                             19 3 1 15 0   0     0   0                       19
1126374 1126374 MA Essex   school 2507110 163   Lynn 250711001064 1630020 Brickett Elementary   Regular School No Elementary 01 05 2017   grade_1 8 3 25 1   2     0   3   21 21                       42 8 3 25 1   2     0   3   21 21                 42
1126375 1126375 MA Essex   school 2507110 163   Lynn 250711001064 1630020 Brickett Elementary   Regular School No Elementary 01 05 2017   grade_2 11 10 35 0   7     0   4   38 29                       67 11 10 35 0   7     0   4   38 29                 67
1126376 1126376 MA Essex   school 2507110 163   Lynn 250711001064 1630020 Brickett Elementary   Regular School No Elementary 01 05 2017   grade_3 12 6 37 0   7     0   2   33 31                       64 12 6 37 0   7     0   2   33 31                 64
1126377 1126377 MA Essex   school 2507110 163   Lynn 250711001064 1630020 Brickett Elementary   Regular School No Elementary 01 05 2017   grade_4 5 5 31 0   14     0   1   20 36                       56 5 5 31 0   14     0   1   20 36                 56
1126378 1126378 MA Essex   school 2507110 163   Lynn 250711001064 1630020 Brickett Elementary   Regular School No Elementary 01 05 2017   grade_5 10 6 27 0   4     0   6   32 21                       53 10 6 27 0   4     0   6   32 21                 53
1126379 1126379 MA Essex   school 2507110 163   Lynn 250711001064 1630020 Brickett Elementary   Regular School No Elementary 01 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1126411 1126411 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No Elementary 01 05 2017   grade_1 7 3 96 1   8     0   3   65 53                       118 7 3 96 1   8     0   3   65 53                 118
1126412 1126412 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No Elementary 01 05 2017   grade_2 8 4 60 0   9     0   2   49 34                       83 8 4 60 0   9     0   2   49 34                 83
1126413 1126413 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No Elementary 01 05 2017   grade_3 5 13 73 0   7     0   2   44 56                       100 5 13 73 0   7     0   2   44 56                 100
1126414 1126414 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No Elementary 01 05 2017   grade_4 6 11 88 0   7     0   3   58 57                       115 6 11 88 0   7     0   3   58 57                 115
1126415 1126415 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No Elementary 01 05 2017   grade_5 3 4 76 0   7     0   2   44 48                       92 3 4 76 0   7     0   2   44 48                 92
1126416 1126416 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No Elementary 01 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1126475 1126475 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Tracy   Regular School No Elementary 01 05 2017   grade_1 3 9 63 0   9     0   2   39 47                       86 3 9 63 0   9     0   2   39 47                 86
1126476 1126476 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Tracy   Regular School No Elementary 01 05 2017   grade_2 9 11 62 0   2     0   8   42 50                       92 9 11 62 0   2     0   8   42 50                 92
1126477 1126477 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Tracy   Regular School No Elementary 01 05 2017   grade_3 9 8 59 0   7     0   2   42 43                       85 9 8 59 0   7     0   2   42 43                 85
1126478 1126478 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Tracy   Regular School No Elementary 01 05 2017   grade_4 5 8 73 0   5     0   3   48 46                       94 5 8 73 0   5     0   3   48 46                 94
1126479 1126479 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Tracy   Regular School No Elementary 01 05 2017   grade_5 4 6 49 0   3     0   5   38 29                       67 4 6 49 0   3     0   5   38 29                 67
1126480 1126480 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Tracy   Regular School No Elementary 01 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1126963 1126963 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2017   grade_1 90 4 4 0   0     0   5   60 43                       103 90 4 4 0   0     0   5   60 43                 103
1126964 1126964 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2017   grade_2 85 1 1 0   2     1   10   64 36                       100 85 1 1 0   2     1   10   64 36                 100
1126965 1126965 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2017   grade_3 100 2 4 0   0     0   15   54 67                       121 100 2 4 0   0     0   15   54 67                 121
1126966 1126966 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2017   grade_4 111 2 9 1   1     0   6   66 64                       130 111 2 9 1   1     0   6   66 64                 130
1126967 1126967 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2017   grade_5 108 1 6 2   3     0   4   66 58                       124 108 1 6 2   3     0   4   66 58                 124
1126968 1126968 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1126969 1126969 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No Elementary 01 05 2017   grade_1 93 2 1 0   0     0   5   51 50                       101 93 2 1 0   0     0   5   51 50                 101
1126970 1126970 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No Elementary 01 05 2017   grade_2 103 3 2 1   0     0   1   44 66                       110 103 3 2 1   0     0   1   44 66                 110
1126971 1126971 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No Elementary 01 05 2017   grade_3 112 3 4 0   1     0   5   69 56                       125 112 3 4 0   1     0   5   69 56                 125
1126972 1126972 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No Elementary 01 05 2017   grade_4 111 6 3 2   1     0   2   63 62                       125 111 6 3 2   1     0   2   63 62                 125
1126973 1126973 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No Elementary 01 05 2017   grade_5 109 3 2 2   2     0   7   72 53                       125 109 3 2 2   2     0   7   72 53                 125
1126974 1126974 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No Elementary 01 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1127871 1127871 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No Elementary 01 05 2017   grade_1 32 12 13 0   2     0   2   29 32                       61 32 12 13 0   2     0   2   29 32                 61
1127872 1127872 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No Elementary 01 05 2017   grade_2 29 3 22 0   1     0   3   27 31                       58 29 3 22 0   1     0   3   27 31                 58
1127873 1127873 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No Elementary 01 05 2017   grade_3 34 8 16 0   1     0   1   37 23                       60 34 8 16 0   1     0   1   37 23                 60
1127874 1127874 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No Elementary 01 05 2017   grade_4 34 5 16 0   4     0   2   30 31                       61 34 5 16 0   4     0   2   30 31                 61
1127875 1127875 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No Elementary 01 05 2017   grade_5 28 3 11 0   2     0   1   21 24                       45 28 3 11 0   2     0   1   21 24                 45
1127876 1127876 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No Elementary 01 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1127877 1127877 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Cornelius M Callahan   Regular School No Elementary 01 05 2017   grade_1 31 2 1 0   2     0   1   16 21                       37 31 2 1 0   2     0   1   16 21                 37
1127878 1127878 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Cornelius M Callahan   Regular School No Elementary 01 05 2017   grade_2 32 4 1 0   0     0   1   21 17                       38 32 4 1 0   0     0   1   21 17                 38
1127879 1127879 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Cornelius M Callahan   Regular School No Elementary 01 05 2017   grade_3 20 2 6 0   3     0   3   15 19                       34 20 2 6 0   3     0   3   15 19                 34
1127880 1127880 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Cornelius M Callahan   Regular School No Elementary 01 05 2017   grade_4 35 5 2 0   3     0   1   25 21                       46 35 5 2 0   3     0   1   25 21                 46
1127881 1127881 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Cornelius M Callahan   Regular School No Elementary 01 05 2017   grade_5 33 6 6 0   2     0   0   20 27                       47 33 6 6 0   2     0   0   20 27                 47
1127882 1127882 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Cornelius M Callahan   Regular School No Elementary 01 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1127883 1127883 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 F A Cleveland   Regular School No Elementary 01 05 2017   grade_1 58 3 3 0   9     0   3   38 38                       76 58 3 3 0   9     0   3   38 38                 76
1127884 1127884 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 F A Cleveland   Regular School No Elementary 01 05 2017   grade_2 52 2 6 0   7     0   1   41 27                       68 52 2 6 0   7     0   1   41 27                 68
1127885 1127885 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 F A Cleveland   Regular School No Elementary 01 05 2017   grade_3 44 8 2 0   5     0   0   26 33                       59 44 8 2 0   5     0   0   26 33                 59
1127886 1127886 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 F A Cleveland   Regular School No Elementary 01 05 2017   grade_4 51 5 4 0   9     1   1   29 42                       71 51 5 4 0   9     1   1   29 42                 71
1127887 1127887 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 F A Cleveland   Regular School No Elementary 01 05 2017   grade_5 49 4 5 0   7     0   1   36 30                       66 49 4 5 0   7     0   1   36 30                 66
1127888 1127888 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 F A Cleveland   Regular School No Elementary 01 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1127889 1127889 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 John P Oldham   Regular School No Elementary 01 05 2017   grade_1 37 6 4 0   6     0   0   23 30                       53 37 6 4 0   6     0   0   23 30                 53
1127890 1127890 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 John P Oldham   Regular School No Elementary 01 05 2017   grade_2 35 5 4 0   4     0   0   22 26                       48 35 5 4 0   4     0   0   22 26                 48
1127891 1127891 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 John P Oldham   Regular School No Elementary 01 05 2017   grade_3 39 6 6 0   2     0   1   28 26                       54 39 6 6 0   2     0   1   28 26                 54
1127892 1127892 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 John P Oldham   Regular School No Elementary 01 05 2017   grade_4 27 4 1 0   2     0   1   18 17                       35 27 4 1 0   2     0   1   18 17                 35
1127893 1127893 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 John P Oldham   Regular School No Elementary 01 05 2017   grade_5 28 7 4 0   4     1   0   27 17                       44 28 7 4 0   4     1   0   27 17                 44
1127894 1127894 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 John P Oldham   Regular School No Elementary 01 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128573 1128573 MA Plymouth   school 2510170 251   Rockland 251017001641 2510025 R Stewart Esten   Regular School No Elementary 01 04 2017   grade_1 49 10 10 0   1     0   5   44 31                       75 49 10 10 0   1     0   5   44 31                 75
1128574 1128574 MA Plymouth   school 2510170 251   Rockland 251017001641 2510025 R Stewart Esten   Regular School No Elementary 01 04 2017   grade_2 52 6 8 0   0     0   2   36 32                       68 52 6 8 0   0     0   2   36 32                 68
1128575 1128575 MA Plymouth   school 2510170 251   Rockland 251017001641 2510025 R Stewart Esten   Regular School No Elementary 01 04 2017   grade_3 67 4 17 0   2     0   2   48 44                       92 67 4 17 0   2     0   2   48 44                 92
1128576 1128576 MA Plymouth   school 2510170 251   Rockland 251017001641 2510025 R Stewart Esten   Regular School No Elementary 01 04 2017   grade_4 54 3 11 0   1     0   0   40 29                       69 54 3 11 0   1     0   0   40 29                 69
1128577 1128577 MA Plymouth   school 2510170 251   Rockland 251017001641 2510025 R Stewart Esten   Regular School No Elementary 01 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128868 1128868 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2017   grade_1 56 2 10 0   61     0   5   70 64                       134 56 2 10 0   61     0   5   70 64                 134
1128869 1128869 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2017   grade_2 65 5 13 2   95     0   10   98 92                       190 65 5 13 2   95     0   10   98 92                 190
1128870 1128870 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2017   grade_3 96 1 11 1   93     0   7   100 109                       209 96 1 11 1   93     0   7   100 109                 209
1128871 1128871 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2017   grade_4 73 3 22 0   85     0   6   94 95                       189 73 3 22 0   85     0   6   94 95                 189
1128872 1128872 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1129045 1129045 MA Worcester   school 2511010 277   Southbridge 251101001763 2770005 Charlton Street   Regular School No Elementary 01 05 2017   grade_1 25 1 37 0   1     0   4   38 30                       68 25 1 37 0   1     0   4   38 30                 68
1129046 1129046 MA Worcester   school 2511010 277   Southbridge 251101001763 2770005 Charlton Street   Regular School No Elementary 01 05 2017   grade_2 36 3 42 1   1     0   1   48 36                       84 36 3 42 1   1     0   1   48 36                 84
1129047 1129047 MA Worcester   school 2511010 277   Southbridge 251101001763 2770005 Charlton Street   Regular School No Elementary 01 05 2017   grade_3 32 4 42 0   3     0   7   39 49                       88 32 4 42 0   3     0   7   39 49                 88
1129048 1129048 MA Worcester   school 2511010 277   Southbridge 251101001763 2770005 Charlton Street   Regular School No Elementary 01 05 2017   grade_4 49 3 41 0   1     0   2   49 47                       96 49 3 41 0   1     0   2   49 47                 96
1129049 1129049 MA Worcester   school 2511010 277   Southbridge 251101001763 2770005 Charlton Street   Regular School No Elementary 01 05 2017   grade_5 48 2 34 0   0     0   1   46 39                       85 48 2 34 0   0     0   1   46 39                 85
1129050 1129050 MA Worcester   school 2511010 277   Southbridge 251101001763 2770005 Charlton Street   Regular School No Elementary 01 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1129054 1129054 MA Worcester   school 2511010 277   Southbridge 251101001770 2770020 West Street   Regular School No Elementary 01 05 2017   grade_1 39 3 41 0   3     0   1   41 46                       87 39 3 41 0   3     0   1   41 46                 87
1129055 1129055 MA Worcester   school 2511010 277   Southbridge 251101001770 2770020 West Street   Regular School No Elementary 01 05 2017   grade_2 47 1 55 0   2     0   2   58 49                       107 47 1 55 0   2     0   2   58 49                 107

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