legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
15 rows where "end" is on date 2023-01-03 and state = "GA"
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, end (date)
Link | rowid ▼ | legislator_id | type | state | start | end | class | party | district | how | party_affiliations | url | caucus | address | phone | fax | contact_form | office | state_rank | rss_url | end-type |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41957 | 41957 | Sanford Bishop B000490 | rep | GA | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://bishop.house.gov | 2407 Rayburn House Office Building Washington DC 20515-1002 | 202-225-3631 | 2407 Rayburn House Office Building | http://bishop.house.gov/rss.xml | ||||||||
42601 | 42601 | Henry Johnson J000288 | rep | GA | 2021-01-03 | 2023-01-03 | Democrat | 4 | https://hankjohnson.house.gov | 2240 Rayburn House Office Building Washington DC 20515-1004 | 202-225-1605 | 2240 Rayburn House Office Building | http://hankjohnson.house.gov/rss.xml | ||||||||
43310 | 43310 | Austin Scott S001189 | rep | GA | 2021-01-03 | 2023-01-03 | Republican | 8 | https://austinscott.house.gov | 2417 Rayburn House Office Building Washington DC 20515-1008 | 202-225-6531 | 2417 Rayburn House Office Building | http://austinscott.house.gov/index.php?format=feed&type=rss | ||||||||
43320 | 43320 | David Scott S001157 | rep | GA | 2021-01-03 | 2023-01-03 | Democrat | 13 | https://davidscott.house.gov | 468 Cannon House Office Building Washington DC 20515-1013 | 202-225-2939 | 468 Cannon House Office Building | http://davidscott.house.gov/news/rss.aspx | ||||||||
43975 | 43975 | Earl Carter C001103 | rep | GA | 2021-01-03 | 2023-01-03 | Republican | 1 | https://buddycarter.house.gov | 2432 Rayburn House Office Building Washington DC 20515-1001 | 202-225-5831 | 2432 Rayburn House Office Building | |||||||||
43979 | 43979 | Jody Hice H001071 | rep | GA | 2021-01-03 | 2023-01-03 | Republican | 10 | https://hice.house.gov | 404 Cannon House Office Building Washington DC 20515-1010 | 202-225-4101 | 404 Cannon House Office Building | |||||||||
43983 | 43983 | Barry Loudermilk L000583 | rep | GA | 2021-01-03 | 2023-01-03 | Republican | 11 | https://loudermilk.house.gov | 2133 Rayburn House Office Building Washington DC 20515-1011 | 202-225-2931 | 2133 Rayburn House Office Building | |||||||||
43987 | 43987 | Rick Allen A000372 | rep | GA | 2021-01-03 | 2023-01-03 | Republican | 12 | https://allen.house.gov | 570 Cannon House Office Building Washington DC 20515-1012 | 202-225-2823 | 570 Cannon House Office Building | |||||||||
44159 | 44159 | A. Ferguson F000465 | rep | GA | 2021-01-03 | 2023-01-03 | Republican | 3 | https://ferguson.house.gov | 1032 Longworth House Office Building Washington DC 20515-1003 | 202-225-5901 | 1032 Longworth House Office Building | |||||||||
44303 | 44303 | Lucy McBath M001208 | rep | GA | 2021-01-03 | 2023-01-03 | Democrat | 6 | https://mcbath.house.gov | 1513 Longworth House Office Building Washington DC 20515-1006 | 202-225-4501 | 1513 Longworth House Office Building | |||||||||
44486 | 44486 | Nikema Williams W000788 | rep | GA | 2021-01-03 | 2023-01-03 | Democrat | 5 | https://nikemawilliams.house.gov | 1406 Longworth House Office Building Washington DC 20515-1005 | 202-225-3801 | 1406 Longworth House Office Building | |||||||||
44487 | 44487 | Carolyn Bourdeaux B001312 | rep | GA | 2021-01-03 | 2023-01-03 | Democrat | 7 | https://bourdeaux.house.gov | 1319 Longworth House Office Building Washington DC 20515-1007 | 202-225-4272 | 1319 Longworth House Office Building | |||||||||
44488 | 44488 | Andrew Clyde C001116 | rep | GA | 2021-01-03 | 2023-01-03 | Republican | 9 | https://clyde.house.gov | 521 Cannon House Office Building Washington DC 20515-1009 | 202-225-9893 | 521 Cannon House Office Building | |||||||||
44489 | 44489 | Marjorie Greene G000596 | rep | GA | 2021-01-03 | 2023-01-03 | Republican | 14 | https://greene.house.gov | 1023 Longworth House Office Building Washington DC 20515-1014 | 202-225-5211 | 1023 Longworth House Office Building | |||||||||
44534 | 44534 | Raphael Warnock W000790 | sen | GA | 2021-01-20 | 2023-01-03 | 3 | Democrat | special-election | https://www.warnock.senate.gov | 388 Russell Senate Office Building Washington DC 20510 | 202-224-3643 | https://www.warnock.senate.gov/contact/ | 388 Russell Senate Office Building | junior |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [legislator_terms] ( [legislator_id] TEXT REFERENCES [legislators]([id]), [type] TEXT, [state] TEXT, [start] TEXT, [end] TEXT, [class] INTEGER, [party] TEXT , [district] INTEGER, [how] TEXT, [party_affiliations] TEXT, [url] TEXT, [caucus] TEXT, [address] TEXT, [phone] TEXT, [fax] TEXT, [contact_form] TEXT, [office] TEXT, [state_rank] TEXT, [rss_url] TEXT, [end-type] TEXT);