house_cand_exp
24 rows where candidate = "Ransom, Kim" and expenditure_type = "Telephone"
This data as json, CSV (advanced)
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
10921 | 10921 | House District 44 | Ransom, Kim | Republican | 70.0 | 6/13/20 0:00 | Verizon | Acworth | GA | 30101 | Telephone | Cell Phone |
10931 | 10931 | House District 44 | Ransom, Kim | Republican | 70.0 | 7/13/20 0:00 | Verizon | Acworth | GA | 30101 | Telephone | Cell Phone |
10938 | 10938 | House District 44 | Ransom, Kim | Republican | 70.0 | 8/13/20 0:00 | Verizon | Acworth | GA | 30101 | Telephone | Cell Phone |
10957 | 10957 | House District 44 | Ransom, Kim | Republican | 70.0 | 9/12/20 0:00 | Verizon | Acworth | GA | 30101 | Telephone | Cell Phone |
10991 | 10991 | House District 44 | Ransom, Kim | Republican | 70.0 | 10/13/20 0:00 | Verizon | Acworth | GA | 30101 | Telephone | Cell Phone |
10992 | 10992 | House District 44 | Ransom, Kim | Republican | 70.0 | 10/14/19 0:00 | Verizon | Acworth | GA | 30101 | Telephone | Cell Phone |
11005 | 11005 | House District 44 | Ransom, Kim | Republican | 70.0 | 11/12/20 0:00 | Verizon | Acworth | GA | 30101 | Telephone | |
11007 | 11007 | House District 44 | Ransom, Kim | Republican | 70.0 | 11/13/19 0:00 | Verizon | Acworth | GA | 30101 | Telephone | Cell Phone |
11015 | 11015 | House District 44 | Ransom, Kim | Republican | 70.0 | 12/13/19 0:00 | Verizon | Acworth | GA | 30101 | Telephone | Cell Phone |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "house_cand_exp" ( "district" TEXT, "candidate" TEXT, "affiliation" TEXT, "expenditure_amount" REAL, "expenditure_date" TEXT, "recipient" TEXT, "city" TEXT, "state" TEXT, "zip" TEXT, "expenditure_type" TEXT, "explanation" TEXT );