ppgu

Custom SQL query

Tables

misses

id, http_status, checked_at

6,239 rows

person_curation

petition_id, mark, updated_at

87 rows

person_name_override

petition_id, name, updated_at

75 rows

petition_person

petition_id, name, dob, birthplace, unit, rank, callsign, dod, place_of_death, awards, name_ok, dob_ok, model, extracted_at

2,089 rows

petitions

id, number, url, title, author, date_published, date_published_iso, body_text, status, collection_status, votes_required, votes_current, response_text, signatory_count, raw_html_path, http_status, first_seen, last_seen

2,089 rows

service_jobs

job, running, started_at, force, finished_at, ok

1 row

signatories

petition_id, name, signed_date

62,670 rows

sweep

k, v

4 rows

vote_history

petition_id, ts, votes, status

2,091 rows