Data source: Big Local News · About: Big Local

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

View and edit SQL

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
1373821 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin Regional High School   Regular School No High 09 12 2020   grade_9 144 2 7 0   1     0   3   75 82 *                     157.0 144 2 7 0   1     0   3   75 82                 157
1373822 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin Regional High School   Regular School No High 09 12 2020   grade_10 150 1 7 0   1     0   5   77 87 *                     164.0 150 1 7 0   1     0   5   77 87                 164
1373823 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin Regional High School   Regular School No High 09 12 2020   grade_11 138 1 6 0   1     0   3   71 78 *                     149.0 138 1 6 0   1     0   3   71 78                 149
1373824 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin Regional High School   Regular School No High 09 12 2020   grade_12 134 2 4 0   3     0   4   67 80 *                     147.0 134 2 4 0   3     0   4   67 80                 147
1373825 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin Regional High School   Regular School No High 09 12 2020   sped_beyond_grade_12 * * * *   *     *   *   2 2 *                     4.0                         2 2                 4
1373819 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin Regional Middle School   Regular School No Middle 07 08 2020   grade_7 156 5 11 0   2     0   3   85 92 *                     177.0 156 5 11 0   2     0   3   85 92                 177
1373820 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin Regional Middle School   Regular School No Middle 07 08 2020   grade_8 174 0 8 1   4     0   2   91 98 *                     189.0 174 0 8 1   4     0   2   91 98                 189
1373789 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary PK 06 2020   kindergarten 26 0 3 0   0     0   1   17 13 *                     30.0 26 0 3 0   0     0   1   17 13                 30
1373790 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten 23 0 4 0   0     0   1   16 12 *                     28.0 23 0 4 0   0     0   1   16 12                 28
1373791 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary PK 06 2020   grade_1 21 0 0 0   0     0   0   13 8 *                     21.0 21 0 0 0   0     0   0   13 8                 21
1373792 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary PK 06 2020   grade_2 23 0 1 1   0     0   0   16 9 *                     25.0 23 0 1 1   0     0   0   16 9                 25
1373793 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary PK 06 2020   grade_3 15 0 4 0   0     0   0   11 8 *                     19.0 15 0 4 0   0     0   0   11 8                 19
1373794 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary PK 06 2020   grade_4 21 0 4 0   0     0   0   16 9 *                     25.0 21 0 4 0   0     0   0   16 9                 25
1373795 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary PK 06 2020   grade_5 19 0 3 1   0     0   0   10 13 *                     23.0 19 0 3 1   0     0   0   10 13                 23
1373796 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary PK 06 2020   grade_6 28 0 4 0   0     0   0   21 11 *                     32.0 28 0 4 0   0     0   0   21 11                 32
1373797 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2020   kindergarten 43 0 1 0   0     0   1   22 23 *                     45.0 43 0 1 0   0     0   1   22 23                 45
1373798 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2020   grade_1 33 0 4 0   0     0   2   23 16 *                     39.0 33 0 4 0   0     0   2   23 16                 39
1373799 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2020   grade_2 44 0 3 0   2     0   0   27 22 *                     49.0 44 0 3 0   2     0   0   27 22                 49
1373800 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2020   grade_3 42 1 0 0   1     0   0   23 21 *                     44.0 42 1 0 0   1     0   0   23 21                 44
1373801 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2020   grade_4 39 0 1 0   0     0   0   21 19 *                     40.0 39 0 1 0   0     0   0   21 19                 40
1373802 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2020   grade_5 40 0 2 0   1     0   0   18 25 *                     43.0 40 0 2 0   1     0   0   18 25                 43
1373803 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2020   grade_6 46 0 3 0   0     0   0   19 30 *                     49.0 46 0 3 0   0     0   0   19 30                 49
1373804 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No Elementary KG 01 2020   kindergarten 23 1 1 0   0     0   0   14 11 *                     25.0 23 1 1 0   0     0   0   14 11                 25
1373805 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No Elementary KG 01 2020   grade_1 18 0 2 0   0     0   1   9 12 *                     21.0 18 0 2 0   0     0   1   9 12                 21
1373806 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2020   grade_2 35 0 4 0   0     0   1   22 18 *                     40.0 35 0 4 0   0     0   1   22 18                 40
1373807 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2020   grade_3 22 1 1 0   0     0   0   10 14 *                     24.0 22 1 1 0   0     0   0   10 14                 24
1373808 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2020   grade_4 19 0 3 0   0     0   1   6 17 *                     23.0 19 0 3 0   0     0   1   6 17                 23
1373809 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2020   grade_5 31 0 1 0   0     0   0   9 23 *                     32.0 31 0 1 0   0     0   0   9 23                 32
1373810 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2020   grade_6 27 0 3 0   0     0   0   16 14 *                     30.0 27 0 3 0   0     0   0   16 14                 30
1373811 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary PK 06 2020   kindergarten 64 0 5 0   0     0   3   43 29 *                     72.0 64 0 5 0   0     0   3   43 29                 72
1373812 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary PK 06 2020   pre_kindergarten 39 1 2 0   0     0   0   27 15 *                     42.0 39 1 2 0   0     0   0   27 15                 42
1373813 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary PK 06 2020   grade_1 46 1 1 0   1     1   1   28 23 *                     51.0 46 1 1 0   1     1   1   28 23                 51
1373814 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary PK 06 2020   grade_2 44 2 5 0   0     0   0   27 24 *                     51.0 44 2 5 0   0     0   0   27 24                 51
1373815 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary PK 06 2020   grade_3 43 0 1 0   0     0   2   23 23 *                     46.0 43 0 1 0   0     0   2   23 23                 46
1373816 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary PK 06 2020   grade_4 48 1 2 0   1     0   3   27 28 *                     55.0 48 1 2 0   1     0   3   27 28                 55
1373817 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary PK 06 2020   grade_5 67 1 2 0   1     0   2   39 34 *                     73.0 67 1 2 0   1     0   2   39 34                 73
1373818 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary PK 06 2020   grade_6 57 0 5 0   1     1   0   37 27 *                     64.0 57 0 5 0   1     1   0   37 27                 64
1373892 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2020   grade_5 75 1 10 0   2     0   1   46 43 *                     89.0 75 1 10 0   2     0   1   46 43                 89
1373893 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2020   grade_6 87 4 16 0   2     0   5   61 53 *                     114.0 87 4 16 0   2     0   5   61 53                 114
1373894 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2020   grade_7 90 3 12 1   1     0   5   55 57 *                     112.0 90 3 12 1   1     0   5   55 57                 112
1373895 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2020   grade_8 95 4 17 0   2     0   5   74 49 *                     123.0 95 4 17 0   2     0   5   74 49                 123
1373879 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2020   kindergarten 23 1 1 0   0     0   1   9 17 *                     26.0 23 1 1 0   0     0   1   9 17                 26
1373880 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten 65 2 9 0   0     0   4   41 39 *                     80.0 65 2 9 0   0     0   4   41 39                 80
1373881 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2020   grade_1 17 0 2 0   0     0   0   11 8 *                     19.0 17 0 2 0   0     0   0   11 8                 19
1373882 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2020   grade_2 22 0 1 0   0     0   0   12 11 *                     23.0 22 0 1 0   0     0   0   12 11                 23
1373883 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2020   grade_3 20 0 2 0   0     0   1   11 12 *                     23.0 20 0 2 0   0     0   1   11 12                 23
1373884 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2020   grade_4 20 1 2 0   0     0   1   16 8 *                     24.0 20 1 2 0   0     0   1   16 8                 24
1373885 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2020   grade_5 14 0 1 0   0     0   2   8 9 *                     17.0 14 0 1 0   0     0   2   8 9                 17
1373886 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2020   grade_6 25 0 1 0   0     0   2   13 15 *                     28.0 25 0 1 0   0     0   2   13 15                 28
1373896 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No High 09 12 2020   grade_9 57 2 12 0   2     0   2   35 40 *                     75.0 57 2 12 0   2     0   2   35 40                 75
1373897 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No High 09 12 2020   grade_10 52 2 7 0   1     0   1   39 24 *                     63.0 52 2 7 0   1     0   1   39 24                 63
1373898 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No High 09 12 2020   grade_11 53 2 6 1   2     0   0   30 34 *                     64.0 53 2 6 1   2     0   0   30 34                 64
1373899 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No High 09 12 2020   grade_12 44 3 8 1   2     0   1   34 25 *                     59.0 44 3 8 1   2     0   1   34 25                 59
1373887 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Wire Village School   Regular School No Elementary KG 04 2020   kindergarten 70 1 12 0   1     0   6   54 36 *                     90.0 70 1 12 0   1     0   6   54 36                 90
1373888 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Wire Village School   Regular School No Elementary KG 04 2020   grade_1 62 1 10 0   0     0   2   35 40 *                     75.0 62 1 10 0   0     0   2   35 40                 75
1373889 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Wire Village School   Regular School No Elementary KG 04 2020   grade_2 69 4 18 0   0     0   6   55 41 *                     97.0 69 4 18 0   0     0   6   55 41                 97
1373890 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Wire Village School   Regular School No Elementary KG 04 2020   grade_3 81 5 21 0   0     0   2   62 47 *                     109.0 81 5 21 0   0     0   2   62 47                 109
1373891 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Wire Village School   Regular School No Elementary KG 04 2020   grade_4 53 0 14 0   0     0   3   32 38 *                     70.0 53 0 14 0   0     0   3   32 38                 70
1373873 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2020   grade_7 112 1 4 0   1     0   2   57 63 *                     120.0 112 1 4 0   1     0   2   57 63                 120
1373874 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2020   grade_8 102 0 8 0   1     0   3   60 54 *                     114.0 102 0 8 0   1     0   3   60 54                 114
1373875 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2020   grade_9 91 2 2 0   2     0   2   47 52 *                     99.0 91 2 2 0   2     0   2   47 52                 99
1373876 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2020   grade_10 113 4 2 1   0     0   1   55 66 *                     121.0 113 4 2 1   0     0   1   55 66                 121
1373877 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2020   grade_11 96 2 6 1   1     0   1   56 51 *                     107.0 96 2 6 1   1     0   1   56 51                 107
1373878 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2020   grade_12 110 1 1 0   1     0   0   62 51 *                     113.0 110 1 1 0   1     0   0   62 51                 113
1373865 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2020   kindergarten 84 2 3 0   0     0   3   53 39 *                     92.0 84 2 3 0   0     0   3   53 39                 92
1373866 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2020   pre_kindergarten 48 0 1 1   1     0   0   27 24 *                     51.0 48 0 1 1   1     0   0   27 24                 51
1373867 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2020   grade_1 96 3 8 1   0     0   3   53 58 *                     111.0 96 3 8 1   0     0   3   53 58                 111
1373868 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2020   grade_2 76 2 6 1   2     0   1   52 36 *                     88.0 76 2 6 1   2     0   1   52 36                 88
1373869 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No Elementary 03 06 2020   grade_3 95 2 6 0   1     0   4   54 54 *                     108.0 95 2 6 0   1     0   4   54 54                 108
1373870 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No Elementary 03 06 2020   grade_4 107 2 3 0   0     0   0   56 56 *                     112.0 107 2 3 0   0     0   0   56 56                 112
1373871 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No Elementary 03 06 2020   grade_5 111 1 7 1   1     0   6   70 57 *                     127.0 111 1 7 1   1     0   6   70 57                 127
1373872 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No Elementary 03 06 2020   grade_6 104 6 6 0   1     0   4   56 65 *                     121.0 104 6 6 0   1     0   4   56 65                 121
1373198 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2020   kindergarten 21 0 0 0   0     0   0   14 7 *                     21.0 21 0 0 0   0     0   0   14 7                 21
1373199 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten 14 0 0 0   0     0   0   10 4 *                     14.0 14 0 0 0   0     0   0   10 4                 14
1373200 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2020   grade_1 13 0 0 0   0     0   0   7 6 *                     13.0 13 0 0 0   0     0   0   7 6                 13
1373201 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2020   grade_2 17 1 0 0   0     0   0   11 7 *                     18.0 17 1 0 0   0     0   0   11 7                 18
1373202 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2020   grade_3 17 0 0 1   0     0   0   9 9 *                     18.0 17 0 0 1   0     0   0   9 9                 18
1373203 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2020   grade_4 15 0 1 0   0     0   0   9 7 *                     16.0 15 0 1 0   0     0   0   9 7                 16
1373204 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2020   grade_5 14 0 1 1   0     0   0   8 8 *                     16.0 14 0 1 1   0     0   0   8 8                 16
1372468 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2020   grade_5 6 43 16 0   1     0   0   31 35 *                     66.0 6 43 16 0   1     0   0   31 35                 66
1372469 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2020   grade_6 6 46 22 0   0     0   1   46 29 *                     75.0 6 46 22 0   0     0   1   46 29                 75
1372470 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2020   grade_7 8 43 22 0   0     0   1   37 37 *                     74.0 8 43 22 0   0     0   1   37 37                 74
1372471 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2020   grade_8 5 43 25 0   1     0   1   33 42 *                     75.0 5 43 25 0   1     0   1   33 42                 75
1372472 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2020   grade_9 3 41 22 0   0     0   4   39 31 *                     70.0 3 41 22 0   0     0   4   39 31                 70
1372473 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2020   grade_10 9 41 19 0   2     0   0   35 36 *                     71.0 9 41 19 0   2     0   0   35 36                 71
1372474 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2020   grade_11 3 39 13 0   1     0   0   26 30 *                     56.0 3 39 13 0   1     0   0   26 30                 56
1372475 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2020   grade_12 4 22 12 0   1     0   1   20 20 *                     40.0 4 22 12 0   1     0   1   20 20                 40
1372512 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2020   kindergarten 2 40 3 0   0     0   1   25 21 *                     46.0 2 40 3 0   0     0   1   25 21                 46
1372513 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2020   pre_kindergarten 1 17 1 0   1     0   3   5 18 *                     23.0 1 17 1 0   1     0   3   5 18                 23
1372514 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2020   grade_1 2 32 7 0   0     1   3   19 26 *                     45.0 2 32 7 0   0     1   3   19 26                 45
1372515 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2020   grade_2 1 44 4 0   0     0   2   23 28 *                     51.0 1 44 4 0   0     0   2   23 28                 51
1372516 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2020   grade_3 1 38 6 0   0     0   3   23 25 *                     48.0 1 38 6 0   0     0   3   23 25                 48
1372517 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2020   grade_4 1 36 3 1   2     1   1   26 19 *                     45.0 1 36 3 1   2     1   1   26 19                 45
1372518 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2020   grade_5 0 34 6 0   0     0   0   19 21 *                     40.0 0 34 6 0   0     0   0   19 21                 40
1372519 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2020   grade_6 0 36 2 0   0     0   0   19 19 *                     38.0 0 36 2 0   0     0   0   19 19                 38
1372577 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2020   grade_6 71 1 4 0   2     0   3   42 39 *                     81.0 71 1 4 0   2     0   3   42 39                 81
1372578 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2020   grade_7 71 1 3 1   3     0   2   36 45 *                     81.0 71 1 3 1   3     0   2   36 45                 81
1372579 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2020   grade_8 62 3 5 0   1     0   6   38 39 *                     77.0 62 3 5 0   1     0   6   38 39                 77
1372580 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes High 05 12 2020   grade_5 69 6 9 0   8     0   8   59 41 *                     100.0 69 6 9 0   8     0   8   59 41                 100
1372581 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes High 05 12 2020   grade_6 75 3 10 1   7     0   4   45 55 *                     100.0 75 3 10 1   7     0   4   45 55                 100

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