With the official name Quispamsis, what is the census ranking?
create table table_171236_1 (census_ranking varchar, official_name varchar, PRIMARY KEY (census_ranking))
select census_ranking from table_171236_1 where official_name = "quispamsis"