offices

Table actions Table actions

4 rows where legislator_id = "C001108"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: phone

id ▼ legislator_id address suite city state zip latitude longitude fax phone building hours
C001108-danville C001108 141 N. 3rd Street Suite 5 Danville KY 40422 37.64698 -84.77261879999999   859-439-5844    
C001108-madisonville C001108 67 North Main St.   Madisonville KY 42431 37.3296043 -87.498937   270-487-9509   Call to schedule appointment
C001108-paducah C001108 300 S. 3rd St.   Paducah KY 42003 37.0851283 -88.595174   270-408-1865    
C001108-tompkinsville C001108 200 N. Main St. Suite F Tompkinsville KY 42167 36.7006713 -85.6929017   270-487-9509    

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