Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_7 · 33,045
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
1447083 NY Clinton   school 3607170 90601020000   CHAZY 360717000507 90601020002 CHAZY CENTRAL RURAL JUNIOR-SENIOR HS public Regular School No High 07 12 2021   grade_7 34.0 3.0 0.0         0.0         17.0 20.0             19     9   37 34 3 0         0         17 20         19   9   37
1537048 NY Clinton   school 3607170 90601020000   CHAZY 360717000506 90601020001 CHAZY CENTRAL RURAL ELEMENTARY SCH public Regular School No Elementary KG 06 2020   grade_7 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
1537067 NY Clinton   school 3607170 90601020000   CHAZY 360717000507 90601020002 CHAZY CENTRAL RURAL JUNIOR-SENIOR HS public Regular School No High 07 12 2020   grade_7 36.0 2.0 1.0         0.0         14.0 25.0             12     8   39 36 2 1         0         14 25         12   8   39
2063178 NY Clinton   school 3607170 90601020000   CHAZY 360717000506 90601020001 CHAZY CENTRAL RURAL ELEMENTARY SCH public Regular School No Elementary KG 06 2018   grade_7 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
2063197 NY Clinton   school 3607170 90601020000   CHAZY 360717000507 90601020002 CHAZY CENTRAL RURAL JUNIOR-SENIOR HS public Regular School No High 07 12 2018   grade_7 24.0 0.0 0.0         1.0         12.0 13.0             8     *   25 24 0 0         1         12 13         8       25
2152896 NY Clinton   school 3607170 90601020000   CHAZY 360717000506 90601020001 CHAZY CENTRAL RURAL ELEMENTARY SCH public Regular School No Elementary KG 06 2019   grade_7 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
2152915 NY Clinton   school 3607170 90601020000   CHAZY 360717000507 90601020002 CHAZY CENTRAL RURAL JUNIOR-SENIOR HS public Regular School No High 07 12 2019   grade_7 34.0 1.0 1.0         1.0         12.0 25.0             15     11   37 34 1 1         1         12 25         15   11   37
759002 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003019 90501040002 NORTHEASTERN CLINTON SR HIGH SCHOOL public Regular School No 3.0 09 12 2015   grade_7 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
759021 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003021 90501040003 ROUSES POINT ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2015   grade_7 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
759040 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003020 90501040006 MOOERS ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2015   grade_7 0.0   0.0                   0.0 0.0             0     0   0 0   0                   0 0         0   0   0
759059 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003018 90501040007 NORTHEASTERN CLINTON MIDDLE SCHOOL public Regular School No 2.0 06 09 2015   grade_7 97.0 1.0 2.0   1.0     0.0     0.0   57.0 44.0             49     *   101 97 1 2   1     0     0   57 44         49       101
955762 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003019 90501040002 NORTHEASTERN CLINTON SR HIGH SCHOOL public Regular School No High 09 12 2017   grade_7 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
955781 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003021 90501040003 ROUSES POINT ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_7 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
955800 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003020 90501040006 MOOERS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_7 0.0   0.0         0.0         0.0 0.0             0     0   0 0   0         0         0 0         0   0   0
955819 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003018 90501040007 NORTHEASTERN CLINTON MIDDLE SCHOOL public Regular School No Other 06 09 2017   grade_7 86.0   3.0               3.0   52.0 40.0             49     17   92 86   3               3   52 40         49   17   92
1045632 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003019 90501040002 NORTHEASTERN CLINTON SR HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_7 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
1045651 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003021 90501040003 ROUSES POINT ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2016   grade_7 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
1045670 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003020 90501040006 MOOERS ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2016   grade_7 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
1045689 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003018 90501040007 NORTHEASTERN CLINTON MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_7 87.0 1.0 2.0   0.0           2.0   49.0 43.0             45     17   92 87 1 2   0           2   49 43         45   17   92
1446988 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003019 90501040002 NORTHEASTERN CLINTON SR HIGH SCHOOL public Regular School No Other PK 12 2021   grade_7 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
1447007 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003021 90501040003 ROUSES POINT ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_7 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
1447026 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003020 90501040006 MOOERS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_7 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
1447045 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003018 90501040007 NORTHEASTERN CLINTON MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 89.0 0.0 0.0   0.0     1.0     0.0   40.0 50.0             *     21   90 89 0 0   0     1     0   40 50             21   90
1536972 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003019 90501040002 NORTHEASTERN CLINTON SR HIGH SCHOOL public Regular School No Other PK 12 2020   grade_7 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
1536991 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003021 90501040003 ROUSES POINT ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_7 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
1537010 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003020 90501040006 MOOERS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_7 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
1537029 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003018 90501040007 NORTHEASTERN CLINTON MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 89.0   1.0   0.0     0.0     1.0   44.0 47.0             52     16   91 89   1   0     0     1   44 47         52   16   91
2063102 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003019 90501040002 NORTHEASTERN CLINTON SR HIGH SCHOOL public Regular School No High 09 12 2018   grade_7 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
2063121 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003021 90501040003 ROUSES POINT ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_7 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
2063140 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003020 90501040006 MOOERS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_7 0.0   0.0   0.0               0.0 0.0             0     0   0 0   0   0               0 0         0   0   0
2063159 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003018 90501040007 NORTHEASTERN CLINTON MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_7 83.0   0.0         0.0     0.0   36.0 47.0     *       43     16   83 83   0         0     0   36 47         43   16   83
2152820 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003019 90501040002 NORTHEASTERN CLINTON SR HIGH SCHOOL public Regular School No Other PK 12 2019   grade_7 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
2152839 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003021 90501040003 ROUSES POINT ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_7 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
2152858 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003020 90501040006 MOOERS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_7 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
2152877 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003018 90501040007 NORTHEASTERN CLINTON MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 73.0   3.0   0.0     2.0     0.0   32.0 46.0             *     *   78 73   3   0     2     0   32 46                 78
758926 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429000184 90301060001 BEEKMANTOWN ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2015   grade_7 0.0 0.0 0.0   0.0               0.0 0.0             0     0   0 0 0 0   0               0 0         0   0   0
758945 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429000186 90301060003 CUMBERLAND HEAD ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2015   grade_7 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
758964 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429003247 90301060005 BEEKMANTOWN MIDDLE SCHOOL public Regular School No 2.0 06 08 2015   grade_7 154.0 2.0 2.0   1.0     0.0         76.0 83.0             82     35   159 154 2 2   1     0         76 83         82   35   159
758983 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429000185 90301060006 BEEKMANTOWN HIGH SCHOOL public Regular School No 3.0 09 12 2015   grade_7 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
955686 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429000184 90301060001 BEEKMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_7 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
955705 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429000186 90301060003 CUMBERLAND HEAD ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_7 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
955724 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429003247 90301060005 BEEKMANTOWN MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 127.0 2.0 3.0         2.0         78.0 56.0             70     19   134 127 2 3         2         78 56         70   19   134
955743 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429000185 90301060006 BEEKMANTOWN HIGH SCHOOL public Regular School No High 09 12 2017   grade_7 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
1045556 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429000184 90301060001 BEEKMANTOWN ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2016   grade_7 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
1045575 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429000186 90301060003 CUMBERLAND HEAD ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2016   grade_7 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
1045594 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429003247 90301060005 BEEKMANTOWN MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_7 113.0 3.0 2.0   0.0     1.0         61.0 58.0             72     22   119 113 3 2   0     1         61 58         72   22   119
1045613 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429000185 90301060006 BEEKMANTOWN HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_7 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
1446912 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429000184 90301060001 BEEKMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_7 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
1446931 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429000186 90301060003 CUMBERLAND HEAD ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_7 0.0 0.0 0.0         0.0         0.0 0.0     *       0     0   0 0 0 0         0         0 0         0   0   0
1446950 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429003247 90301060005 BEEKMANTOWN MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 144.0 1.0 7.0   1.0     0.0         95.0 58.0     *       79     32   153 144 1 7   1     0         95 58         79   32   153
1446969 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429000185 90301060006 BEEKMANTOWN HIGH SCHOOL public Regular School No High 09 12 2021   grade_7 0.0 0.0 0.0         0.0         0.0 0.0     *       0     0   0 0 0 0         0         0 0         0   0   0
1536896 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429000184 90301060001 BEEKMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_7 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
1536915 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429000186 90301060003 CUMBERLAND HEAD ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_7 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
1536934 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429003247 90301060005 BEEKMANTOWN MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 136.0 2.0 4.0   2.0     2.0         72.0 74.0     *       76     33   146 136 2 4   2     2         72 74         76   33   146
1536953 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429000185 90301060006 BEEKMANTOWN HIGH SCHOOL public Regular School No High 09 12 2020   grade_7 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
2063026 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429000184 90301060001 BEEKMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_7 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
2063045 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429000186 90301060003 CUMBERLAND HEAD ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_7 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
2063064 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429003247 90301060005 BEEKMANTOWN MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_7 124.0 2.0 0.0         0.0         58.0 68.0     *       64     19   126 124 2 0         0         58 68         64   19   126
2063083 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429000185 90301060006 BEEKMANTOWN HIGH SCHOOL public Regular School No High 09 12 2018   grade_7 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
2152744 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429000184 90301060001 BEEKMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_7 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
2152763 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429000186 90301060003 CUMBERLAND HEAD ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_7 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
2152782 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429003247 90301060005 BEEKMANTOWN MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 128.0 3.0 6.0   0.0     0.0         73.0 64.0     *       67     20   137 128 3 6   0     0         73 64         67   20   137
2152801 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429000185 90301060006 BEEKMANTOWN HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 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
758850 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001397 90201040001 KEESVILLE PRIMARY SCHOOL public Regular School No 1.0 KG 06 2015   grade_7 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
758869 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001396 90201040002 AUSABLE VALLEY HIGH SCHOOL public Regular School No 3.0 09 12 2015   grade_7 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
758888 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No 1.0 KG 06 2015   grade_7 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
758907 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617004948 90201040005 AUSABLE VALLEY MIDDLE SCHOOL public Regular School No 2.0 07 08 2015   grade_7 73.0 3.0 2.0   1.0     1.0         43.0 37.0             *     19   80 73 3 2   1     1         43 37             19   80
955610 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001397 90201040001 KEESEVILLE PRIMARY SCHOOL public Regular School No Elementary KG 06 2017   grade_7 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
955629 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001396 90201040002 AUSABLE VALLEY HIGH SCHOOL public Regular School No High 09 12 2017   grade_7 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
955648 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2017   grade_7 0.0 0.0                     0.0 0.0             0     0   0 0 0                     0 0         0   0   0
955667 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617004948 90201040005 AUSABLE VALLEY MIDDLE SCHOOL public Regular School No Middle 07 08 2017   grade_7 87.0 3.0 0.0         0.0         54.0 36.0             52     13   90 87 3 0         0         54 36         52   13   90
1045480 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001397 90201040001 KEESEVILLE PRIMARY SCHOOL public Regular School No 1.0 KG 06 2016   grade_7 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
1045499 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001396 90201040002 AUSABLE VALLEY HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_7 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
1045518 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No 1.0 KG 06 2016   grade_7 0.0 0.0                     0.0 0.0             0     0   0 0 0                     0 0         0   0   0
1045537 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617004948 90201040005 AUSABLE VALLEY MIDDLE SCHOOL public Regular School No 2.0 07 08 2016   grade_7 94.0 1.0 1.0   0.0     1.0     0.0   52.0 45.0             50     8   97 94 1 1   0     1     0   52 45         50   8   97
1446836 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001397 90201040001 KEESEVILLE PRIMARY SCHOOL public Regular School No Elementary PK 06 2021   grade_7 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
1446855 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001396 90201040002 AUSABLE VALLEY HIGH SCHOOL public Regular School No High 09 12 2021   grade_7 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
1446874 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_7 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
1446893 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617004948 90201040005 AUSABLE VALLEY MIDDLE SCHOOL public Regular School No Middle 07 08 2021   grade_7 89.0 0.0                 1.0   41.0 49.0             60     *   90 89 0                 1   41 49         60       90
1536820 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001397 90201040001 KEESEVILLE PRIMARY SCHOOL public Regular School No Elementary PK 06 2020   grade_7 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
1536839 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001396 90201040002 AUSABLE VALLEY HIGH SCHOOL public Regular School No High 09 12 2020   grade_7 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
1536858 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_7 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
1536877 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617004948 90201040005 AUSABLE VALLEY MIDDLE SCHOOL public Regular School No Middle 07 08 2020   grade_7 73.0 3.0 0.0                   34.0 42.0             *     17   76 73 3 0                   34 42             17   76
2062950 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001397 90201040001 KEESEVILLE PRIMARY SCHOOL public Regular School No Elementary KG 06 2018   grade_7 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
2062969 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001396 90201040002 AUSABLE VALLEY HIGH SCHOOL public Regular School No High 09 12 2018   grade_7 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
2062988 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   grade_7 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
2063007 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617004948 90201040005 AUSABLE VALLEY MIDDLE SCHOOL public Regular School No Middle 07 08 2018   grade_7 78.0 4.0 1.0                   35.0 48.0             40     11   83 78 4 1                   35 48         40   11   83
2152668 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001397 90201040001 KEESEVILLE PRIMARY SCHOOL public Regular School No Elementary PK 06 2019   grade_7 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
2152687 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001396 90201040002 AUSABLE VALLEY HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 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
2152706 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_7 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
2152725 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617004948 90201040005 AUSABLE VALLEY MIDDLE SCHOOL public Regular School No Middle 07 08 2019   grade_7 82.0 4.0 2.0                   37.0 51.0             53     16   88 82 4 2                   37 51         53   16   88
758793 NY Chenango   school 3626700 82001040000   SHERBURNE EARLVL 362670001984 82001040002 SHERBURNE-EARLVILLE ELEMENTARY SCH public Regular School No 1.0 PK 05 2015   grade_7 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
758812 NY Chenango   school 3626700 82001040000   SHERBURNE EARLVL 362670003644 82001040003 SHERBURNE-EARLVILLE MIDDLE SCHOOL public Regular School No 2.0 06 08 2015   grade_7 87.0 1.0 1.0   0.0     2.0     0.0   42.0 49.0             68     25   91 87 1 1   0     2     0   42 49         68   25   91
758831 NY Chenango   school 3626700 82001040000   SHERBURNE EARLVL 362670003645 82001040004 SHERBURNE-EARLVILLE SENIOR HIGH SCH public Regular School No 3.0 09 12 2015   grade_7 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
955553 NY Chenango   school 3626700 82001040000   SHERBURNE EARLVL 362670001984 82001040002 SHERBURNE-EARLVILLE ELEMENTARY SCH public Regular School No Elementary PK 05 2017   grade_7 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
955572 NY Chenango   school 3626700 82001040000   SHERBURNE EARLVL 362670003644 82001040003 SHERBURNE-EARLVILLE MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 119.0 2.0 0.0         0.0         74.0 47.0             68     33   121 119 2 0         0         74 47         68   33   121
955591 NY Chenango   school 3626700 82001040000   SHERBURNE EARLVL 362670003645 82001040004 SHERBURNE-EARLVILLE SENIOR HIGH SCH public Regular School No High 09 12 2017   grade_7 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
1045423 NY Chenango   school 3626700 82001040000   SHERBURNE EARLVL 362670001984 82001040002 SHERBURNE-EARLVILLE ELEMENTARY SCH public Regular School No 1.0 PK 05 2016   grade_7 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
1045442 NY Chenango   school 3626700 82001040000   SHERBURNE EARLVL 362670003644 82001040003 SHERBURNE-EARLVILLE MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_7 88.0 0.0 0.0   1.0     1.0     1.0   40.0 51.0             53     *   91 88 0 0   1     1     1   40 51         53       91
1045461 NY Chenango   school 3626700 82001040000   SHERBURNE EARLVL 362670003645 82001040004 SHERBURNE-EARLVILLE SENIOR HIGH SCH public Regular School No 3.0 09 12 2016   grade_7 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]);