offices

Table actions

Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette

4 rows where legislator_id = "C001095"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ legislator_id address suite city state zip latitude longitude phone fax building hours
C001095-el_dorado Tom Cotton C001095 106 W. Main St. Suite 410 El Dorado AR 71730 33.2120448 -92.664046 870-864-8582 870-864-8571    
C001095-jonesboro Tom Cotton C001095 300 S. Church Suite 338 Jonesboro AR 72401 35.8404281 -90.70368549999999 870-933-6223 870-933-6596    
C001095-little_rock Tom Cotton C001095 1401 W. Capitol Ave. Suite 235 Little Rock AR 72201 34.7456872 -92.2865752 501-223-9081 501-223-9105    
C001095-springdale Tom Cotton C001095 1108 S. Old Missouri Rd. Suite B Springdale AR 72764 36.17457100000001 -94.1176151 479-751-0879 479-927-1092    

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);