{"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":259071,"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":true,"cache_age_s":38,"freshness":{"generated_at":"2026-10-25T12:00:08.896Z","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":5},{"key":"commodity_prices","status":"ok","rows":876,"refresh_age_days":0,"record_age_days":5},{"key":"sanctions","status":"ok","rows":19743,"refresh_age_days":0,"record_age_days":null},{"key":"vessel_positions","status":"ok","rows":258940,"refresh_age_days":0,"record_age_days":0},{"key":"vessel_loitering","status":"ok","rows":230340,"refresh_age_days":0,"record_age_days":3},{"key":"ais_dark_events","status":"ok","rows":2540,"refresh_age_days":0,"record_age_days":11},{"key":"port_visits","status":"ok","rows":801650,"refresh_age_days":0,"record_age_days":8},{"key":"pi_insurance","status":"ok","rows":4957,"refresh_age_days":0,"record_age_days":null},{"key":"uscg_vessels","status":"ok","rows":13589,"refresh_age_days":66,"record_age_days":null},{"key":"cii_ratings","status":"ok","rows":61343,"refresh_age_days":0,"record_age_days":null},{"key":"vessel_history","status":"ok","rows":10290,"refresh_age_days":0,"record_age_days":null},{"key":"vessel_emissions","status":"ok","rows":89711,"refresh_age_days":177,"record_age_days":663},{"key":"oil_trade_flows","status":"lagging","rows":23001,"refresh_age_days":22,"record_age_days":267,"reason":"pipeline is healthy but the newest record is 267d old — upstream source has not published"},{"key":"world_ports","status":"ok","rows":2951,"refresh_age_days":24,"record_age_days":null},{"key":"port_sites","status":"ok","rows":2951,"refresh_age_days":24,"record_age_days":null},{"key":"port_calls","status":"ok","rows":1948,"refresh_age_days":0,"record_age_days":0},{"key":"apcis_inspections","status":"stale","rows":143,"refresh_age_days":16,"record_age_days":null,"reason":"job last completed 16d 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":16,"record_age_days":null,"reason":"job last completed 16d ago, expected within 8d — the weekly Tue 04:30 UTC job is not delivering"},{"key":"chokepoint_traffic","status":"stale","rows":33,"refresh_age_days":169,"record_age_days":178,"reason":"last refreshed 169d ago (expected within 40d) and newest record is 178d 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"}]}}