Where was the county of rockingham?
CREATE TABLE "references" (
  "name" text,
  "county" text,
  "location" text,
  "built" text,
  "length_ft" real,
  "spans" text
);
SELECT "location" FROM "references" WHERE "county"='rockingham';