enrollments

Data source: Big Local News · About: Big Local

9,537 rows where state = "MA" and year = 2020 sorted by ccd_school_low_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 9,537 ✖
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
1365121 1365121 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Swift River Elementary   Regular School No Elementary 01 03 2020   grade_1 127 1 9 0   1     0   13   69 82 *                     151.0 127 1 9 0   1     0   13   69 82                 151
1365122 1365122 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Swift River Elementary   Regular School No Elementary 01 03 2020   grade_2 148 0 12 0   3     0   5   81 87 *                     168.0 148 0 12 0   3     0   5   81 87                 168
1365123 1365123 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Swift River Elementary   Regular School No Elementary 01 03 2020   grade_3 139 2 8 0   1     0   8   80 78 *                     158.0 139 2 8 0   1     0   8   80 78                 158
1366042 1366042 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other 01 12 2020   pre_kindergarten * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1366043 1366043 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other 01 12 2020   grade_1 * * * *   *     *   *   1 2 *                     3.0                         1 2                 3
1366044 1366044 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other 01 12 2020   grade_2 2 5 2 0   0     0   0   6 3 *                     9.0 2 5 2 0   0     0   0   6 3                 9
1366045 1366045 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other 01 12 2020   grade_3 * * * *   *     *   *   4 1 *                     5.0                         4 1                 5
1366046 1366046 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other 01 12 2020   grade_4 0 2 4 0   0     0   0   3 3 *                     6.0 0 2 4 0   0     0   0   3 3                 6
1366047 1366047 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other 01 12 2020   grade_5 0 4 4 0   0     0   0   6 2 *                     8.0 0 4 4 0   0     0   0   6 2                 8
1366048 1366048 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other 01 12 2020   grade_7 0 3 5 0   0     0   0   6 2 *                     8.0 0 3 5 0   0     0   0   6 2                 8
1366049 1366049 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other 01 12 2020   grade_9 0 3 3 0   0     0   0   2 4 *                     6.0 0 3 3 0   0     0   0   2 4                 6
1366050 1366050 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other 01 12 2020   grade_10 1 2 3 0   1     0   0   4 3 *                     7.0 1 2 3 0   1     0   0   4 3                 7
1366051 1366051 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other 01 12 2020   grade_11 * * * *   *     *   *   1 2 *                     3.0                         1 2                 3
1366052 1366052 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other 01 12 2020   grade_12 0 4 5 0   1     0   0   7 3 *                     10.0 0 4 5 0   1     0   0   7 3                 10
1366053 1366053 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other 01 12 2020   sped_beyond_grade_12 1 2 3 0   0     0   0   4 2 *                     6.0 1 2 3 0   0     0   0   4 2                 6
1366099 1366099 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No Elementary 01 05 2020   grade_1 44 1 6 0   26     0   2   40 39 *                     79.0 44 1 6 0   26     0   2   40 39                 79
1366100 1366100 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No Elementary 01 05 2020   grade_2 40 4 4 0   19     1   3   42 29 *                     71.0 40 4 4 0   19     1   3   42 29                 71
1366101 1366101 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No Elementary 01 05 2020   grade_3 50 2 3 0   17     0   2   39 35 *                     74.0 50 2 3 0   17     0   2   39 35                 74
1366102 1366102 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No Elementary 01 05 2020   grade_4 52 0 2 0   25     1   3   37 46 *                     83.0 52 0 2 0   25     1   3   37 46                 83
1366103 1366103 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No Elementary 01 05 2020   grade_5 58 2 4 0   28     0   2   46 48 *                     94.0 58 2 4 0   28     0   2   46 48                 94
1366572 1366572 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No Elementary 01 04 2020   grade_1 12 5 104 0   0     0   3   61 63 *                     124.0 12 5 104 0   0     0   3   61 63                 124
1366573 1366573 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No Elementary 01 04 2020   grade_2 6 10 108 0   0     0   7   66 65 *                     131.0 6 10 108 0   0     0   7   66 65                 131
1366574 1366574 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No Elementary 01 04 2020   grade_3 9 8 111 0   0     0   0   72 56 *                     128.0 9 8 111 0   0     0   0   72 56                 128
1366575 1366575 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No Elementary 01 04 2020   grade_4 8 4 101 0   0     0   3   60 56 *                     116.0 8 4 101 0   0     0   3   60 56                 116
1366576 1366576 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No Elementary 01 04 2020   grade_1 12 8 84 0   0     0   2   44 62 *                     106.0 12 8 84 0   0     0   2   44 62                 106
1366577 1366577 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No Elementary 01 04 2020   grade_2 20 7 122 0   0     0   1   74 76 *                     150.0 20 7 122 0   0     0   1   74 76                 150
1366578 1366578 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No Elementary 01 04 2020   grade_3 18 8 124 2   0     0   0   73 79 *                     152.0 18 8 124 2   0     0   0   73 79                 152
1366579 1366579 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No Elementary 01 04 2020   grade_4 13 4 115 0   0     0   5   78 59 *                     137.0 13 4 115 0   0     0   5   78 59                 137
1366580 1366580 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 06 2020   grade_1 6 5 95 0   0     0   0   52 54 *                     106.0 6 5 95 0   0     0   0   52 54                 106
1366581 1366581 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 06 2020   grade_2 4 5 96 0   0     0   0   47 58 *                     105.0 4 5 96 0   0     0   0   47 58                 105
1366582 1366582 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 06 2020   grade_3 2 6 94 0   1     0   0   49 54 *                     103.0 2 6 94 0   1     0   0   49 54                 103
1366583 1366583 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 06 2020   grade_4 10 6 104 0   1     0   0   52 69 *                     121.0 10 6 104 0   1     0   0   52 69                 121
1366584 1366584 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 06 2020   grade_5 1 0 38 0   0     0   1   17 23 *                     40.0 1 0 38 0   0     0   1   17 23                 40
1366585 1366585 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 06 2020   grade_6 0 0 32 0   0     0   0   11 21 *                     32.0 0 0 32 0   0     0   0   11 21                 32
1366586 1366586 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2020   grade_1 10 2 87 0   1     0   1   49 52 *                     101.0 10 2 87 0   1     0   1   49 52                 101
1366587 1366587 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2020   grade_2 12 7 124 0   0     0   2   66 79 *                     145.0 12 7 124 0   0     0   2   66 79                 145
1366588 1366588 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2020   grade_3 5 3 131 0   0     0   1   81 59 *                     140.0 5 3 131 0   0     0   1   81 59                 140
1366589 1366589 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2020   grade_4 12 4 124 0   0     0   2   73 69 *                     142.0 12 4 124 0   0     0   2   73 69                 142
1366793 1366793 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No Elementary 01 05 2020   grade_1 57 1 3 0   1     0   3   35 30 *                     65.0 57 1 3 0   1     0   3   35 30                 65
1366794 1366794 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No Elementary 01 05 2020   grade_2 68 1 1 0   1     0   7   40 38 *                     78.0 68 1 1 0   1     0   7   40 38                 78
1366795 1366795 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No Elementary 01 05 2020   grade_3 79 3 6 0   1     0   10   57 42 *                     99.0 79 3 6 0   1     0   10   57 42                 99
1366796 1366796 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No Elementary 01 05 2020   grade_4 67 0 5 0   1     0   4   37 40 *                     77.0 67 0 5 0   1     0   4   37 40                 77
1366797 1366797 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No Elementary 01 05 2020   grade_5 78 0 2 0   1     0   7   42 46 *                     88.0 78 0 2 0   1     0   7   42 46                 88
1366820 1366820 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No Elementary 01 05 2020   grade_1 29 4 17 0   1     0   2   26 27 *                     53.0 29 4 17 0   1     0   2   26 27                 53
1366821 1366821 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No Elementary 01 05 2020   grade_2 33 4 15 0   1     1   1   28 27 *                     55.0 33 4 15 0   1     1   1   28 27                 55
1366822 1366822 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No Elementary 01 05 2020   grade_3 28 10 24 0   1     0   5   28 40 *                     68.0 28 10 24 0   1     0   5   28 40                 68
1366823 1366823 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No Elementary 01 05 2020   grade_4 26 7 17 0   2     0   4   24 32 *                     56.0 26 7 17 0   2     0   4   24 32                 56
1366824 1366824 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No Elementary 01 05 2020   grade_5 29 7 14 1   4     0   2   26 31 *                     57.0 29 7 14 1   4     0   2   26 31                 57
1366825 1366825 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Greenlodge   Regular School No Elementary 01 05 2020   grade_1 44 0 7 0   0     0   4   27 28 *                     55.0 44 0 7 0   0     0   4   27 28                 55
1366826 1366826 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Greenlodge   Regular School No Elementary 01 05 2020   grade_2 40 2 4 0   0     0   2   28 20 *                     48.0 40 2 4 0   0     0   2   28 20                 48
1366827 1366827 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Greenlodge   Regular School No Elementary 01 05 2020   grade_3 40 1 5 0   0     0   1   32 15 *                     47.0 40 1 5 0   0     0   1   32 15                 47
1366828 1366828 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Greenlodge   Regular School No Elementary 01 05 2020   grade_4 31 3 4 0   1     0   0   20 19 *                     39.0 31 3 4 0   1     0   0   20 19                 39
1366829 1366829 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Greenlodge   Regular School No Elementary 01 05 2020   grade_5 51 4 2 0   1     0   3   36 25 *                     61.0 51 4 2 0   1     0   3   36 25                 61
1366830 1366830 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Oakdale   Regular School No Elementary 01 05 2020   grade_1 25 2 4 0   0     0   4   19 16 *                     35.0 25 2 4 0   0     0   4   19 16                 35
1366831 1366831 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Oakdale   Regular School No Elementary 01 05 2020   grade_2 37 5 5 0   1     0   4   23 29 *                     52.0 37 5 5 0   1     0   4   23 29                 52
1366832 1366832 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Oakdale   Regular School No Elementary 01 05 2020   grade_3 41 2 10 0   3     0   2   36 22 *                     58.0 41 2 10 0   3     0   2   36 22                 58
1366833 1366833 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Oakdale   Regular School No Elementary 01 05 2020   grade_4 35 4 6 0   0     0   5   19 31 *                     50.0 35 4 6 0   0     0   5   19 31                 50
1366834 1366834 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Oakdale   Regular School No Elementary 01 05 2020   grade_5 40 5 8 0   1     0   5   28 31 *                     59.0 40 5 8 0   1     0   5   28 31                 59
1366835 1366835 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No Elementary 01 05 2020   grade_1 37 1 5 0   7     0   3   24 29 *                     53.0 37 1 5 0   7     0   3   24 29                 53
1366836 1366836 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No Elementary 01 05 2020   grade_2 22 2 5 0   1     0   1   21 10 *                     31.0 22 2 5 0   1     0   1   21 10                 31
1366837 1366837 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No Elementary 01 05 2020   grade_3 20 3 8 0   0     0   3   18 16 *                     34.0 20 3 8 0   0     0   3   18 16                 34
1366838 1366838 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No Elementary 01 05 2020   grade_4 28 3 3 0   1     0   2   17 20 *                     37.0 28 3 3 0   1     0   2   17 20                 37
1366839 1366839 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No Elementary 01 05 2020   grade_5 20 3 10 0   1     0   0   15 19 *                     34.0 20 3 10 0   1     0   0   15 19                 34
1367196 1367196 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2020   grade_2 * * * *   *     *   *   3 1 *                     4.0                         3 1                 4
1367197 1367197 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2020   grade_3 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1367198 1367198 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2020   grade_7 2 2 5 0   0     0   2   9 2 *                     11.0 2 2 5 0   0     0   2   9 2                 11
1367199 1367199 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2020   grade_8 3 1 0 0   0     0   4   7 1 *                     8.0 3 1 0 0   0     0   4   7 1                 8
1367200 1367200 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2020   grade_9 4 0 2 0   0     0   0   4 2 *                     6.0 4 0 2 0   0     0   0   4 2                 6
1367201 1367201 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2020   grade_10 4 2 2 0   0     0   0   4 4 *                     8.0 4 2 2 0   0     0   0   4 4                 8
1367202 1367202 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2020   grade_11 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1367965 1367965 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 South Lawrence East Elementary School   Regular School No Elementary 01 05 2020   grade_1 5 6 131 0   6     0   1   75 74 *                     149.0 5 6 131 0   6     0   1   75 74                 149
1367966 1367966 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 South Lawrence East Elementary School   Regular School No Elementary 01 05 2020   grade_2 5 3 129 0   2     0   0   68 71 *                     139.0 5 3 129 0   2     0   0   68 71                 139
1367967 1367967 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 South Lawrence East Elementary School   Regular School No Elementary 01 05 2020   grade_3 6 1 137 0   3     0   0   84 63 *                     147.0 6 1 137 0   3     0   0   84 63                 147
1367968 1367968 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 South Lawrence East Elementary School   Regular School No Elementary 01 05 2020   grade_4 6 3 151 0   1     0   0   83 78 *                     161.0 6 3 151 0   1     0   0   83 78                 161
1367969 1367969 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 South Lawrence East Elementary School   Regular School No Elementary 01 05 2020   grade_5 4 1 131 0   3     0   0   84 54 *                     139.0 4 1 131 0   3     0   0   84 54                 139
1367996 1367996 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No Elementary 01 04 2020   grade_1 3 3 117 0   0     0   0   70 53 *                     123.0 3 3 117 0   0     0   0   70 53                 123
1367997 1367997 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No Elementary 01 04 2020   grade_2 3 3 133 0   1     0   0   68 72 *                     140.0 3 3 133 0   1     0   0   68 72                 140
1367998 1367998 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No Elementary 01 04 2020   grade_3 1 1 125 0   1     0   1   67 62 *                     129.0 1 1 125 0   1     0   1   67 62                 129
1367999 1367999 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No Elementary 01 04 2020   grade_4 3 4 115 0   2     0   1   68 57 *                     125.0 3 4 115 0   2     0   1   68 57                 125
1368008 1368008 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No Elementary 01 05 2020   grade_1 4 1 77 0   0     0   0   45 36 *                     82.0 4 1 77 0   0     0   0   45 36                 82
1368009 1368009 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No Elementary 01 05 2020   grade_2 1 2 84 0   0     0   0   42 45 *                     87.0 1 2 84 0   0     0   0   42 45                 87
1368010 1368010 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No Elementary 01 05 2020   grade_3 2 0 94 0   0     0   0   45 51 *                     96.0 2 0 94 0   0     0   0   45 51                 96
1368011 1368011 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No Elementary 01 05 2020   grade_4 4 1 92 0   0     0   1   49 49 *                     98.0 4 1 92 0   0     0   1   49 49                 98
1368012 1368012 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No Elementary 01 05 2020   grade_5 1 0 98 0   0     0   0   55 44 *                     99.0 1 0 98 0   0     0   0   55 44                 99
1368013 1368013 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2020   grade_1 2 0 100 0   1     0   0   60 43 *                     103.0 2 0 100 0   1     0   0   60 43                 103
1368014 1368014 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2020   grade_2 3 1 83 0   0     0   0   41 46 *                     87.0 3 1 83 0   0     0   0   41 46                 87
1368015 1368015 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2020   grade_3 0 1 104 0   1     0   0   56 50 *                     106.0 0 1 104 0   1     0   0   56 50                 106
1368016 1368016 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2020   grade_4 5 0 93 0   0     0   0   50 48 *                     98.0 5 0 93 0   0     0   0   50 48                 98
1368017 1368017 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2020   grade_5 3 0 84 0   1     0   0   50 37 *                     88.0 3 0 84 0   1     0   0   50 37                 88
1368026 1368026 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2020   grade_1 2 0 64 0   0     0   0   37 29 *                     66.0 2 0 64 0   0     0   0   37 29                 66
1368027 1368027 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2020   grade_2 1 0 54 0   0     0   0   33 22 *                     55.0 1 0 54 0   0     0   0   33 22                 55
1368028 1368028 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2020   grade_3 1 1 47 0   0     0   1   28 22 *                     50.0 1 1 47 0   0     0   1   28 22                 50
1368029 1368029 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2020   grade_4 2 0 71 0   0     0   0   45 28 *                     73.0 2 0 71 0   0     0   0   45 28                 73
1368030 1368030 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2020   grade_5 1 0 56 0   0     0   0   30 26 *                     57.0 1 0 56 0   0     0   0   30 26                 57
1368523 1368523 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No Elementary 01 05 2020   grade_1 8 8 72 0   6     0   3   51 46 *                     97.0 8 8 72 0   6     0   3   51 46                 97
1368524 1368524 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No Elementary 01 05 2020   grade_2 3 9 80 0   9     0   4   51 54 *                     105.0 3 9 80 0   9     0   4   51 54                 105
1368525 1368525 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No Elementary 01 05 2020   grade_3 9 8 73 0   4     0   2   45 51 *                     96.0 9 8 73 0   4     0   2   45 51                 96
1368526 1368526 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No Elementary 01 05 2020   grade_4 6 7 91 1   9     0   2   60 56 *                     116.0 6 7 91 1   9     0   2   60 56                 116
1368527 1368527 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No Elementary 01 05 2020   grade_5 3 9 62 0   7     0   2   44 39 *                     83.0 3 9 62 0   7     0   2   44 39                 83
1368553 1368553 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary 01 05 2020   grade_1 * * * *   *     *   *   2 * *                     3.0                         2                   3

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