Data source: Big Local News · About: Big Local

33,145 rows where grade = "grade_8" and state = "NY" sorted by district_state_id descending

View and edit SQL

year

grade

  • grade_8 · 33,145
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
759288 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2015   grade_8 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
759307 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2015   grade_8 0.0 0.0 0.0               0.0   0.0 0.0             0     0   0 0 0 0               0   0 0         0   0   0
759326 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No 3.0 09 12 2015   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
759345 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No 2.0 06 08 2015   grade_8 115.0 0.0 0.0   1.0     0.0     1.0   55.0 62.0             51     22   117 115 0 0   1     0     1   55 62         51   22   117
956048 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_8 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
956067 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_8 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
956086 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2017   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
956105 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 102.0 2.0 2.0                   54.0 52.0             42     17   106 102 2 2                   54 52         42   17   106
1045918 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2016   grade_8 0.0 0.0 0.0               0.0   0.0 0.0             0     0   0 0 0 0               0   0 0         0   0   0
1045937 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2016   grade_8 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
1045956 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1045975 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_8 99.0 2.0 1.0         1.0         61.0 42.0             40     20   103 99 2 1         1         61 42         40   20   103
1447293 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_8 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1447312 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_8 0.0   0.0   0.0           0.0   0.0 0.0             0     0   0 0   0   0           0   0 0         0   0   0
1447331 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2021   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1447350 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_8 114.0   1.0         0.0     2.0   58.0 59.0             51     21   117 114   1         0     2   58 59         51   21   117
1537277 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_8 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1537296 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_8 0.0   0.0   0.0           0.0   0.0 0.0             0     0   0 0   0   0           0   0 0         0   0   0
1537315 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2020   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1537334 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_8 98.0   1.0         0.0     3.0   49.0 53.0             *     *   102 98   1         0     3   49 53                 102
2063388 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_8 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
2063407 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2063426 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2018   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2063445 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 88.0 1.0 1.0               0.0   50.0 40.0             40     21   90 88 1 1               0   50 40         40   21   90
2153106 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_8 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
2153125 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_8 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
2153144 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2019   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2153163 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 100.0 0.0 1.0               0.0   52.0 49.0             38     24   101 100 0 1               0   52 49         38   24   101
759193 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 BAILEY AVENUE SCHOOL public Regular School No 1.0 PK 02 2015   grade_8 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
759212 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003260 91200010003 ARTHUR P MOMOT ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2015   grade_8 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
759231 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003261 91200010004 OAK STREET SCHOOL public Regular School No 1.0 03 05 2015   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
759250 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003262 91200010005 STAFFORD MIDDLE SCHOOL public Regular School No 2.0 06 08 2015   grade_8 102.0 10.0 1.0         6.0         62.0 57.0             *     *   119 102 10 1         6         62 57                 119
759269 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003263 91200010006 PLATTSBURGH SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2015   grade_8 1.0 2.0 0.0   0.0     0.0     0.0   1.0 2.0             *     *   3 1 2 0   0     0     0   1 2                 3
955953 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 BAILEY AVENUE SCHOOL public Regular School No Elementary PK 02 2017   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
955972 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003260 91200010003 ARTHUR P MOMOT ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_8 0.0 0.0 0.0         0.0         0.0 0.0     0       0     0   0 0 0 0         0         0 0     0   0   0   0
955991 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003261 91200010004 OAK STREET SCHOOL public Regular School No Elementary 03 05 2017   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
956010 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003262 91200010005 STAFFORD MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 114.0 9.0 2.0   0.0     2.0     0.0   64.0 63.0     *       *     24   127 114 9 2   0     2     0   64 63             24   127
956029 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003263 91200010006 PLATTSBURGH SENIOR HIGH SCHOOL public Regular School No High 09 12 2017   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1045823 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 BAILEY AVENUE SCHOOL public Regular School No 1.0 PK 02 2016   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1045842 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003260 91200010003 ARTHUR P MOMOT ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2016   grade_8 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
1045861 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003261 91200010004 OAK STREET SCHOOL public Regular School No 1.0 03 06 2016   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1045880 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003262 91200010005 STAFFORD MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_8 101.0 12.0 0.0   0.0     0.0         57.0 56.0             60     *   113 101 12 0   0     0         57 56         60       113
1045899 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003263 91200010006 PLATTSBURGH SENIOR HIGH SCHOOL public Regular School No 3.0 08 12 2016   grade_8 5.0 0.0 0.0   0.0     0.0     0.0   4.0 1.0             *     *   5 5 0 0   0     0     0   4 1                 5
1447198 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 THOMAS E GLASGOW ELEMENTARY public Regular School No Elementary PK 02 2021   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1447217 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003260 91200010003 ARTHUR P MOMOT ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1447236 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003261 91200010004 OAK STREET SCHOOL public Regular School No Elementary 03 05 2021   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1447255 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003262 91200010005 STAFFORD MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_8 127.0 9.0 1.0   1.0     2.0     1.0   75.0 66.0             62     37   141 127 9 1   1     2     1   75 66         62   37   141
1447274 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003263 91200010006 PLATTSBURGH SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1537182 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 BAILEY AVENUE SCHOOL public Regular School No Elementary PK 02 2020   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1537201 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003260 91200010003 ARTHUR P MOMOT ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1537220 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003261 91200010004 OAK STREET SCHOOL public Regular School No Elementary 03 05 2020   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1537239 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003262 91200010005 STAFFORD MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_8 121.0 9.0 3.0   0.0     3.0     0.0   74.0 62.0     *       73     *   136 121 9 3   0     3     0   74 62         73       136
1537258 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003263 91200010006 PLATTSBURGH SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2063293 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 BAILEY AVENUE SCHOOL public Regular School No Elementary PK 02 2018   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2063312 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003260 91200010003 ARTHUR P MOMOT ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2063331 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003261 91200010004 OAK STREET SCHOOL public Regular School No Elementary 03 05 2018   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2063350 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003262 91200010005 STAFFORD MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 128.0 11.0 4.0   1.0     10.0     0.0   72.0 82.0     *       77     32   154 128 11 4   1     10     0   72 82         77   32   154
2063369 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003263 91200010006 PLATTSBURGH SENIOR HIGH SCHOOL public Regular School No High 09 12 2018   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2153011 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 BAILEY AVENUE SCHOOL public Regular School No Elementary PK 02 2019   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2153030 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003260 91200010003 ARTHUR P MOMOT ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2153049 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003261 91200010004 OAK STREET SCHOOL public Regular School No Elementary 03 05 2019   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2153068 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003262 91200010005 STAFFORD MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 115.0 12.0 2.0   1.0     5.0     2.0   71.0 66.0     *       73     32   137 115 12 2   1     5     2   71 66         73   32   137
2153087 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003263 91200010006 PLATTSBURGH SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
759155 NY Clinton   school 3622830 91101060000   PERU 362283003208 91101060004 PERU ELEMENTARY SCHOOL public Regular School No 1.0 KG 06 2015   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
759174 NY Clinton   school 3622830 91101060000   PERU 362283003209 91101060005 PERU JR/SR HIGH SCHOOL public Regular School No 3.0 07 12 2015   grade_8 149.0 7.0 1.0   0.0     1.0     2.0   81.0 79.0             74     20   160 149 7 1   0     1     2   81 79         74   20   160
955915 NY Clinton   school 3622830 91101060000   PERU 362283003208 91101060004 PERU ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2017   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
955934 NY Clinton   school 3622830 91101060000   PERU 362283003209 91101060005 PERU JR/SR HIGH SCHOOL public Regular School No High 07 12 2017   grade_8 144.0 2.0     0.0     3.0     1.0   73.0 77.0     *       74     23   150 144 2     0     3     1   73 77         74   23   150
1045785 NY Clinton   school 3622830 91101060000   PERU 362283003208 91101060004 PERU ELEMENTARY SCHOOL public Regular School No 1.0 KG 06 2016   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1045804 NY Clinton   school 3622830 91101060000   PERU 362283003209 91101060005 PERU JR/SR HIGH SCHOOL public Regular School No 3.0 07 12 2016   grade_8 138.0 1.0 1.0   0.0     2.0     0.0   69.0 73.0             63     23   142 138 1 1   0     2     0   69 73         63   23   142
1447141 NY Clinton   school 3622830 91101060000   PERU 362283003208 91101060004 PERU ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1447160 NY Clinton   school 3622830 91101060000   PERU 362283003209 91101060005 PERU HIGH SCHOOL public Regular School No High 09 12 2021   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1447179 NY Clinton   school 3622830 91101060000   PERU 362283006690 91101060008 PERU MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_8 126.0 4.0 2.0   0.0     2.0     9.0   80.0 63.0     *       68     28   143 126 4 2   0     2     9   80 63         68   28   143
1537125 NY Clinton   school 3622830 91101060000   PERU 362283003208 91101060004 PERU ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1537144 NY Clinton   school 3622830 91101060000   PERU 362283003209 91101060005 PERU HIGH SCHOOL public Regular School No High 09 12 2020   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1537163 NY Clinton   school 3622830 91101060000   PERU 362283006690 91101060008 PERU MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_8 138.0 1.0 0.0   1.0     0.0     6.0   73.0 73.0     *       67     27   146 138 1 0   1     0     6   73 73         67   27   146
2063255 NY Clinton   school 3622830 91101060000   PERU 362283003208 91101060004 PERU ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2063274 NY Clinton   school 3622830 91101060000   PERU 362283003209 91101060005 PERU JR/SR HIGH SCHOOL public Regular School No High 07 12 2018   grade_8 135.0 4.0 0.0   0.0     0.0     2.0   66.0 75.0     *       62     24   141 135 4 0   0     0     2   66 75         62   24   141
2152973 NY Clinton   school 3622830 91101060000   PERU 362283003208 91101060004 PERU ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2152992 NY Clinton   school 3622830 91101060000   PERU 362283003209 91101060005 PERU JR/SR HIGH SCHOOL public Regular School No High 06 12 2019   grade_8 136.0 2.0 2.0   3.0     3.0     1.0   71.0 76.0     *       72     36   147 136 2 2   3     3     1   71 76         72   36   147
759117 NY Clinton   school 3621260 90901040000   NORTHRN ADIRONDACK 362126004489 90901040001 NORTHERN ADIRONDACK ELEMENTARY SCH public Regular School No 1.0 KG 05 2015   grade_8 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
759136 NY Clinton   school 3621260 90901040000   NORTHRN ADIRONDACK 362126003024 90901040002 NORTHERN ADIRONDACK MID/HIGH SCH public Regular School No 4.0 06 12 2015   grade_8 63.0 0.0     0.0     1.0     1.0   33.0 32.0             31     15   65 63 0     0     1     1   33 32         31   15   65
955877 NY Clinton   school 3621260 90901040000   NORTHRN ADIRONDACK 362126004489 90901040001 NORTHERN ADIRONDACK ELEMENTARY SCH public Regular School No Elementary PK 06 2017   grade_8 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
955896 NY Clinton   school 3621260 90901040000   NORTHRN ADIRONDACK 362126003024 90901040002 NORTHERN ADIRONDACK MID/HIGH SCH public Regular School No Other 06 12 2017   grade_8 63.0 0.0     0.0     0.0     0.0   32.0 31.0             29     7   63 63 0     0     0     0   32 31         29   7   63
1045747 NY Clinton   school 3621260 90901040000   NORTHRN ADIRONDACK 362126004489 90901040001 NORTHERN ADIRONDACK ELEMENTARY SCH public Regular School No 4.0 KG 12 2016   grade_8 0.0   0.0   0.0     0.0         0.0 0.0             0     0   0 0   0   0     0         0 0         0   0   0
1045766 NY Clinton   school 3621260 90901040000   NORTHRN ADIRONDACK 362126003024 90901040002 NORTHERN ADIRONDACK MID/HIGH SCH public Regular School No 4.0 KG 12 2016   grade_8 85.0 1.0 0.0   0.0     0.0     1.0   44.0 43.0             42     18   87 85 1 0   0     0     1   44 43         42   18   87
1447103 NY Clinton   school 3621260 90901040000   NORTHRN ADIRONDACK 362126004489 90901040001 NORTHERN ADIRONDACK ELEMENTARY SCH public Regular School No Elementary KG 05 2021   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1447122 NY Clinton   school 3621260 90901040000   NORTHRN ADIRONDACK 362126003024 90901040002 NORTHERN ADIRONDACK MID/HIGH SCH public Regular School No High 06 12 2021   grade_8 48.0 0.0 0.0                   29.0 19.0             20     8   48 48 0 0                   29 19         20   8   48
1537087 NY Clinton   school 3621260 90901040000   NORTHRN ADIRONDACK 362126004489 90901040001 NORTHERN ADIRONDACK ELEMENTARY SCH public Regular School No Elementary PK 05 2020   grade_8 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
1537106 NY Clinton   school 3621260 90901040000   NORTHRN ADIRONDACK 362126003024 90901040002 NORTHERN ADIRONDACK MID/HIGH SCH public Regular School No High 06 12 2020   grade_8 61.0 0.0 1.0   0.0               30.0 32.0             26     10   62 61 0 1   0               30 32         26   10   62
2063217 NY Clinton   school 3621260 90901040000   NORTHRN ADIRONDACK 362126004489 90901040001 NORTHERN ADIRONDACK ELEMENTARY SCH public Regular School No Elementary PK 05 2018   grade_8 0.0   0.0   0.0     0.0         0.0 0.0             0     0   0 0   0   0     0         0 0         0   0   0
2063236 NY Clinton   school 3621260 90901040000   NORTHRN ADIRONDACK 362126003024 90901040002 NORTHERN ADIRONDACK MID/HIGH SCH public Regular School No Other PK 12 2018   grade_8 49.0 0.0 0.0   0.0     0.0     0.0   23.0 26.0             23     11   49 49 0 0   0     0     0   23 26         23   11   49
2152935 NY Clinton   school 3621260 90901040000   NORTHRN ADIRONDACK 362126004489 90901040001 NORTHERN ADIRONDACK ELEMENTARY SCH public Regular School No Elementary PK 05 2019   grade_8 0.0   0.0   0.0     0.0         0.0 0.0             0     0   0 0   0   0     0         0 0         0   0   0
2152954 NY Clinton   school 3621260 90901040000   NORTHRN ADIRONDACK 362126003024 90901040002 NORTHERN ADIRONDACK MID/HIGH SCH public Regular School No High 06 12 2019   grade_8 66.0 1.0 0.0         0.0     0.0   34.0 33.0             44     16   67 66 1 0         0     0   34 33         44   16   67
759079 NY Clinton   school 3607170 90601020000   CHAZY 360717000506 90601020001 CHAZY CENTRAL RURAL ELEMENTARY SCH public Regular School No 1.0 KG 07 2015   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
759098 NY Clinton   school 3607170 90601020000   CHAZY 360717000507 90601020002 CHAZY CENTRAL RURAL JUNIOR-SENIOR HS public Regular School No 3.0 07 12 2015   grade_8 40.0 0.0           0.0         30.0 10.0             13     10   40 40 0           0         30 10         13   10   40
955839 NY Clinton   school 3607170 90601020000   CHAZY 360717000506 90601020001 CHAZY CENTRAL RURAL ELEMENTARY SCH public Regular School No Elementary KG 06 2017   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
955858 NY Clinton   school 3607170 90601020000   CHAZY 360717000507 90601020002 CHAZY CENTRAL RURAL JUNIOR-SENIOR HS public Regular School No High 07 12 2017   grade_8 34.0 0.0 1.0         0.0         16.0 19.0             10     7   35 34 0 1         0         16 19         10   7   35
1045709 NY Clinton   school 3607170 90601020000   CHAZY 360717000506 90601020001 CHAZY CENTRAL RURAL ELEMENTARY SCH public Regular School No 1.0 KG 08 2016   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1045728 NY Clinton   school 3607170 90601020000   CHAZY 360717000507 90601020002 CHAZY CENTRAL RURAL JUNIOR-SENIOR HS public Regular School No 3.0 07 12 2016   grade_8 39.0 0.0 0.0                   23.0 16.0             14     *   39 39 0 0                   23 16         14       39
1447065 NY Clinton   school 3607170 90601020000   CHAZY 360717000506 90601020001 CHAZY CENTRAL RURAL ELEMENTARY SCH public Regular School No Elementary KG 06 2021   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0

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