offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
6 rows where legislator_id = "S001198"
This data as json, copyable, CSV (advanced)
id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
S001198-anchorage | Dan Sullivan S001198 | 510 L St. | Suite 750 | Anchorage | AK | 99501 | 61.2171561 | -149.9043364 | 907-271-5915 | 907-258-9305 | ||
S001198-fairbanks | Dan Sullivan S001198 | 101 12th Ave. | Suite 328 | Fairbanks | AK | 99701 | 64.8383052 | -147.7082477 | 907-456-0261 | 907-451-7290 | Federal Building | |
S001198-juneau | Dan Sullivan S001198 | 800 Glacier Ave. | Suite 101 | Juneau | AK | 99801 | 58.30033239999999 | -134.4205554 | 907-586-7277 | 907-586-7201 | ||
S001198-ketchikan | Dan Sullivan S001198 | 1900 First Ave. | Suite 225 | Ketchikan | AK | 99901 | 55.3492023 | -131.6673863 | 907-225-6880 | 907-225-0390 | ||
S001198-soldotna | Dan Sullivan S001198 | 44539 Sterling Highway | Suite 204 | Soldotna | AK | 99669 | 60.480503 | -151.0747996 | 907-262-4040 | 907-262-4224 | ||
S001198-wasilla | Dan Sullivan S001198 | 851 E. Westpoint Dr. | Suite 309 | Wasilla | AK | 99654 | 61.5826697 | -149.4286826 | 907-357-9956 | 907-357-9964 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [offices] ( [id] TEXT PRIMARY KEY, [legislator_id] TEXT REFERENCES [legislators]([id]), [address] TEXT, [suite] TEXT, [city] TEXT, [state] TEXT, [zip] TEXT, [latitude] FLOAT, [longitude] FLOAT, [phone] TEXT, [fax] TEXT, [building] TEXT , [hours] TEXT);