offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
7 rows where legislator_id = "C001070" sorted by longitude descending
This data as json, copyable, CSV (advanced)
id | legislator_id | address | suite | city | state | zip | latitude | longitude ▲ | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
C001070-philadelphia | Robert Casey C001070 | 2000 Market St. | Suite 610 | Philadelphia | PA | 19103 | 39.9532694 | -75.1736461 | 215-405-9660 | 215-405-9669 | ||
C001070-allentown | Robert Casey C001070 | 840 Hamilton St. | Suite 301 | Allentown | PA | 18101 | 40.6010783 | -75.47499979999999 | 610-782-9470 | 610-782-9474 | ||
C001070-scranton | Robert Casey C001070 | 417 Lackawanna Ave. | Suite 303 | Scranton | PA | 18503 | 41.4073687 | -75.6654743 | 570-941-0930 | 570-941-0937 | ||
C001070-harrisburg | Robert Casey C001070 | 200 N. Third St. | Suite 14A | Harrisburg | PA | 17101 | 40.2619774 | -76.8829619 | 717-231-7540 | 717-231-7542 | ||
C001070-bellefonte | Robert Casey C001070 | 817 E. Bishop St. | Suite C | Bellefonte | PA | 16823 | 40.9138418 | -77.7641528 | 814-357-0314 | 814-357-0318 | ||
C001070-pittsburgh | Robert Casey C001070 | 310 Grant St. | Suite 2415 | Pittsburgh | PA | 15219 | 40.4376694 | -79.99749159999999 | 412-803-7370 | 412-803-7379 | Grant Building | |
C001070-erie | Robert Casey C001070 | 17 S. Park Row. | Suite B-150 | Erie | PA | 16501 | 42.1289745 | -80.08406889999999 | 814-874-5080 | 814-874-5084 |
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);