_enrichment_jobs

1 row

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: started_at (date), finished_at (date)

id ▼ status enrichment database_name table_name filter_querystring config started_at finished_at cancel_reason next_cursor row_count error_count done_count actor_id cost_100ths_cent
1 finished opencage election-2024 returning_officer_data   {"input": "{{ address }}", "json_column": "opencage_result", "api_key": "rNFla_4AFw3hwVkFVKoIOA"} 2024-11-20 23:23:49 2024-11-20 23:29:27   695 696 78 696 root 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE _enrichment_jobs (
    id integer primary key,
    status text, -- pending, running, cancelled, finished
    enrichment text, -- slug of enrichment
    database_name text,
    table_name text,
    filter_querystring text, -- querystring used to filter rows
    config text, -- JSON dictionary of config
    started_at text, -- ISO8601 when added
    finished_at text, -- ISO8601 when completed or cancelled
    cancel_reason text, -- null or reason for cancellation
    next_cursor text, -- next cursor to fetch
    row_count integer, -- number of rows to enrich at start
    error_count integer, -- number of rows with errors encountered
    done_count integer, -- number of rows processed
    actor_id text, -- optional ID of actor who created the job
    cost_100ths_cent integer -- cost of job so far in 1/100ths of a cent
);