{"counts":{"oil_trade_flows":23001,"sanctions":19743,"sanctions_vessels":1568,"vessels":555,"oil_prices":10246,"vessel_emissions":89711,"emissions_unique_vessels":22543,"sanctioned_at_eu_ports":512,"commodity_prices":876,"lng_trade_flows":212,"lng_carriers":1214,"grain_trade_flows":1264,"bulk_carriers":10070,"ore_trade_flows":96,"coal_trade_flows":225,"ais_positions":258940,"chokepoint_traffic":33},"sources":{"eia_flows":18057,"eurostat_flows":1421,"ofac_sanctions":19471,"un_sanctions":272,"eu_mrv_emissions":89704},"db_path":"/var/www/ship.rootz.global/data/shipping.db","cached":false,"cache_age_s":0,"freshness":{"generated_at":"2026-10-24T12:00:08.893Z","summary":{"ok":15,"lagging":1,"stale":3,"empty":2},"legend":{"ok":"pipeline ran on schedule and the newest record is within the expected lag","_clock":"which signal the pipeline status came from: job:<name> = the puller reported completing (trusted, and immune to deduped writes that insert no rows); oldest <col> = a rolling refresh, measured by its oldest row; newest <col> = a row arrived recently","lagging":"our pipeline is healthy; the upstream source has not published anything newer","stale":"our pipeline has not delivered on schedule — treat this dataset with caution","empty":"we advertise this dataset but currently hold no rows for it","unknown":"this table carries no refresh timestamp, so we cannot verify it is current","missing":"table not present in this database"},"datasets":[{"key":"oil_prices","status":"ok","rows":10246,"refresh_age_days":0,"record_age_days":4},{"key":"commodity_prices","status":"ok","rows":876,"refresh_age_days":0,"record_age_days":4},{"key":"sanctions","status":"ok","rows":19743,"refresh_age_days":0,"record_age_days":null},{"key":"vessel_positions","status":"ok","rows":260680,"refresh_age_days":0,"record_age_days":0},{"key":"vessel_loitering","status":"ok","rows":229832,"refresh_age_days":0,"record_age_days":3},{"key":"ais_dark_events","status":"ok","rows":2536,"refresh_age_days":0,"record_age_days":10},{"key":"port_visits","status":"ok","rows":801650,"refresh_age_days":0,"record_age_days":7},{"key":"pi_insurance","status":"ok","rows":4927,"refresh_age_days":0,"record_age_days":null},{"key":"uscg_vessels","status":"ok","rows":13589,"refresh_age_days":65,"record_age_days":null},{"key":"cii_ratings","status":"ok","rows":61343,"refresh_age_days":6,"record_age_days":null},{"key":"vessel_history","status":"ok","rows":9892,"refresh_age_days":6,"record_age_days":null},{"key":"vessel_emissions","status":"ok","rows":89711,"refresh_age_days":176,"record_age_days":662},{"key":"oil_trade_flows","status":"lagging","rows":23001,"refresh_age_days":21,"record_age_days":266,"reason":"pipeline is healthy but the newest record is 266d old — upstream source has not published"},{"key":"world_ports","status":"ok","rows":2951,"refresh_age_days":23,"record_age_days":null},{"key":"port_sites","status":"ok","rows":2951,"refresh_age_days":23,"record_age_days":null},{"key":"port_calls","status":"ok","rows":1936,"refresh_age_days":0,"record_age_days":0},{"key":"apcis_inspections","status":"stale","rows":143,"refresh_age_days":15,"record_age_days":null,"reason":"job last completed 15d ago, expected within 8d — the weekly Tue 04:00 UTC job is not delivering"},{"key":"apcis_ship_detail","status":"stale","rows":128,"refresh_age_days":15,"record_age_days":null,"reason":"job last completed 15d ago, expected within 8d — the weekly Tue 04:30 UTC job is not delivering"},{"key":"chokepoint_traffic","status":"stale","rows":33,"refresh_age_days":168,"record_age_days":177,"reason":"last refreshed 168d ago (expected within 40d) and newest record is 177d old"},{"key":"psc_inspections","status":"empty","rows":0,"refresh_age_days":null,"record_age_days":null,"reason":"no rows — the weekly Sun 02:00 + monthly job produces nothing"},{"key":"cargo_manifests","status":"empty","rows":0,"refresh_age_days":null,"record_age_days":null,"reason":"no rows — the weekly Mon 06:00 UTC job produces nothing"}]}}