Who are the local hosts for the United States in years earlier than 2007?
CREATE TABLE "references" (
  "year" real,
  "conference" text,
  "city" text,
  "country" text,
  "local_host_s" text
);
SELECT "local_host_s" FROM "references" WHERE "country"='united states' AND "year"<2007;