offices

Table actions

4 rows where legislator_id = "C001095"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ legislator_id address suite city state zip latitude longitude fax phone building hours
C001095-el_dorado Tom Cotton C001095 106 W. Main St. Suite 410 El Dorado AR 71730 33.2120448 -92.664046 870-864-8571 870-864-8582    
C001095-jonesboro Tom Cotton C001095 300 S. Church Suite 338 Jonesboro AR 72401 35.8404281 -90.70368549999999 870-933-6596 870-933-6223    
C001095-little_rock Tom Cotton C001095 1401 W. Capitol Ave. Suite 235 Little Rock AR 72201 34.7456872 -92.2865752 501-223-9105 501-223-9081    
C001095-rogers Tom Cotton C001095 3333 S. Pinnacle Hills Pkwy Suite 425 Rogers AR 72758 36.304661 -94.1866787 479-464-0648 479-751-0879    

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,
   [fax] TEXT,
   [phone] TEXT,
   [building] TEXT
, [hours] TEXT);