{
   "error" : null,
   "extract" : {
      "advertiser" : "Democratic Congressional Campaign Comm",
      "agency" : "Great American Media",
      "checks" : null,
      "confidence" : "high",
      "contract_number" : "1211304",
      "cost_usd" : "0.0598",
      "data" : {
         "advertiser" : "Democratic Congressional Campaign Comm",
         "agency" : "Great American Media",
         "confidence" : "high",
         "contract_number" : "1211304",
         "cost_usd" : "0.0598",
         "document_type" : "contract",
         "end_date" : "2014-10-27",
         "estimate_number" : "2888",
         "gross_total" : 3575,
         "notes" : null,
         "order_number" : "07229127",
         "source" : "model:claude-sonnet-5",
         "spot_count" : 10,
         "start_date" : "2014-10-27",
         "station" : "KQCA",
         "tokens_in" : 17403,
         "tokens_out" : 509,
         "traffic_system" : null,
         "version" : null
      },
      "document_type" : "contract",
      "end_date" : "2014-10-27",
      "estimate_number" : "2888",
      "external_number" : null,
      "extracted_at" : "2026-09-25 08:38:41",
      "extracted_by" : "site",
      "file_id" : "bba751eb-8185-3b07-dba3-8a6fb76d260e",
      "gross_total" : "3575.00",
      "line_count" : null,
      "net_total" : null,
      "notes" : null,
      "order_number" : "07229127",
      "source" : "model:claude-sonnet-5",
      "spot_count" : 10,
      "spot_lengths" : null,
      "start_date" : "2014-10-27",
      "station" : "KQCA",
      "tokens_in" : 17403,
      "tokens_out" : 509,
      "version" : null
   },
   "file" : {
      "archived_at" : "2026-09-25 07:35:19",
      "archived_by" : "extract",
      "archived_sha1" : "1d01f818f857163c350ba638e2dbe21e9dfc48dd",
      "archived_size" : 4958729,
      "callsign" : "KQCA",
      "city" : "Raleigh",
      "create_ts" : "2014-11-07T12:21:54-05:00",
      "entity_id" : "10242",
      "fcc_url" : "https://publicfiles.fcc.gov/api/manager/download/c222ecff-b36b-2536-6fcc-8af684811d42/bba751eb-8185-3b07-dba3-8a6fb76d260e.pdf",
      "fetch_attempts" : 0,
      "fetch_last_at" : "2026-09-25 07:35:19",
      "fetch_last_error" : null,
      "file_extension" : "pdf",
      "file_id" : "bba751eb-8185-3b07-dba3-8a6fb76d260e",
      "file_manager_id" : "bba751eb-8185-3b07-dba3-8a6fb76d260e",
      "file_name" : "DCCC 102714-102714 1211304 CONTRACT NAB AMENDED",
      "file_size" : 4958729,
      "file_status" : "com_etl",
      "filer" : "DCCC",
      "filer_href" : "/tv/KQCA/",
      "filer_name" : "KQCA-TV",
      "first_seen_at" : "2026-09-24 10:42:48",
      "folder_id" : "c222ecff-b36b-2536-6fcc-8af684811d42",
      "folder_path" : "Political Files/2014/Federal/DCCC",
      "last_event" : "delete",
      "last_event_ts" : "2016-12-09T17:31:51-05:00",
      "last_seen_at" : "2026-09-24 10:42:48",
      "level" : "Federal",
      "licensee" : "Hearst Stations Inc.",
      "office" : null,
      "removed_ts" : "2016-12-09T17:31:51-05:00",
      "service" : "TV",
      "state" : "NC",
      "station_id" : 873,
      "year" : "2014"
   }
}