As checked 14 Nov 2026
How fresh DOT Intel's trucking records are
This page lists the source URL, the schedule, and the last-updated mechanism that are written in this repository on 14 Nov 2026. A portal update time is the upstream file's time. It is not the time DOT Intel last loaded that file. Live success times sit in Supabase and are marked for the owner where this repository cannot see them.
Carrier identity and docket history
- Source
- https://datahub.transportation.gov/resource/6eyk-hxee.json — public view name “Carrier - All With History”. Loaded by census_ingest.ingest_carrier_history_delta. Open the dataset
- Refresh cadence in this repository
- In this repository: Monday–Saturday at 04:15 UTC, active carriers only (census-daily-carrier-history). Sunday at 04:15 UTC, an 8-day lookback that includes inactive carriers (census-weekly-carrier-history-full).
- Last-updated mechanism
- After out_status = ok, run_carrier_history_delta_and_stamp calls try_stamp_data_source_refresh('fmcsa_census'). The fmcsa_census row expects a refresh inside 7 days. That expectation is wider than the weekday job.
- Upstream portal time, read 14 Nov 2026
- Portal rowsUpdatedAt read on 14 Nov 2026: 2026-11-14T13:18:09Z. That is the portal's time, not DOT Intel's last successful load.
- Owner confirmation needed
- Owner confirmation needed: the latest successful run is in Supabase cron.job_run_details and data_source_status. This repository does not contain that live timestamp.
Company census, fleet, cargo, MCS-150 fields, and safety rating on the carrier row
- Source
- https://data.transportation.gov/resource/az4n-8mr2.json — public view name “Company Census File”. Loaded by census_ingest.ingest_company_census. Open the dataset
- Refresh cadence in this repository
- In this repository: Monday–Saturday at 04:45 UTC, active carriers, unless the function reports no change (census-daily-company-census). Sunday at 04:45 UTC, a full pull (census-weekly-company-census-full).
- Last-updated mechanism
- run_company_census_and_stamp stamps fmcsa_census when the status is ok or skipped_no_change. No function in this repository requests https://data.transportation.gov/resource/kjg3-diqy.json. An older comment said MCS-150 fields refresh monthly from that view. The live company-census function selects those fields from az4n-8mr2.
- Upstream portal time, read 14 Nov 2026
- Portal rowsUpdatedAt read on 14 Nov 2026: Company Census File 2026-11-14T11:52:30Z. SMS Input - Motor Carrier Census Information (kjg3-diqy) 2026-11-13T07:13:44Z. Neither time is DOT Intel's last load.
- Owner confirmation needed
- Owner confirmation needed: confirm no job outside this repository still downloads kjg3-diqy, and confirm the latest fmcsa_census stamp.
Authority grants
- Source
- Scheduled pull: https://data.transportation.gov/resource/yu5v-wbh6.json — public view name “Motus AuthHist - All With History”, filtered to reason GRANTED, via census_ingest.ingest_authority_grants('motus_authhist'). The same function can read legacy AuthHist at https://data.transportation.gov/resource/9mw4-x3tu.json, and the scheduled command does not pass that source. Open the dataset
- Refresh cadence in this repository
- In this repository: every day at 05:00 UTC (authority-grants-daily), then census_ingest.apply_authority_grants().
- Last-updated mechanism
- run_authority_grants_and_stamp stamps fmcsa_census only when rows fetched and dots upserted are both greater than zero. A zero-write run does not advance freshness.
- Upstream portal time, read 14 Nov 2026
- Portal rowsUpdatedAt read on 14 Nov 2026: Motus AuthHist 2026-11-14T10:11:03Z. Legacy AuthHist 2026-11-14T13:07:56Z.
- Owner confirmation needed
- Owner confirmation needed: the latest successful authority-grants-daily run is not in this repository.
Current insurance filings
- Source
- Every day the insurance job reads two Socrata views. Motus: https://data.transportation.gov/resource/c5y8-a4uz.json (“Motus Insur - All With History”), through census_ingest.ingest_motus_insurance(). Legacy fallback: https://data.transportation.gov/resource/ypjt-5ydn.json (“Insur - All With History”), through census_ingest.ingest_insurance_current_staging(), which refresh_insurance_current() still calls. A Motus liability candidate replaces the legacy row for that USDOT. A USDOT with no Motus liability candidate keeps the legacy row. Open the dataset
- Refresh cadence in this repository
- In this repository: every day at 04:50 UTC (insurance-current-daily) runs census_ingest.run_motus_insurance_pipeline_and_stamp(): ingest, then refresh current, then append history.
- Last-updated mechanism
- A successful ingest, refresh, or history append stamps motus_insurance. The seeded expectation is 1 day. The publish writes policy_expiration_date as null on both the Motus and legacy legs. The selected Motus fields are USDOT, docket, insurer name, policy number, form code, type code, coverage amount, and effective date.
- Upstream portal time, read 14 Nov 2026
- Portal rowsUpdatedAt read on 14 Nov 2026: Motus Insur 2026-11-14T10:09:38Z. Insur - All With History 2026-11-14T13:14:29Z.
- Owner confirmation needed
- Owner confirmation needed: the last success visible in this repository is the 4 Oct 2026 insurance-current-daily run recorded in docs/troubleshooting/postgrest-ingest-lock-2026-10-04.md (finished 05:47:09 UTC). That is not proof of the latest run. The live command in that note also called repair_insurer_mapping(); the repository schedule as of 20261027 does not. Confirm which command is live.
Insurance filing history
- Source
- New rows appended each night come from the Motus pull above, tagged source_file motus:c5y8-a4uz, via census_ingest.append_motus_insurance_history(). Cancellation reason is left null because that Motus select has no cancellation fields. The historical InsHist file https://data.transportation.gov/resource/6sqe-dvqs.json is not in the scheduled command. Migration 20260902 records that file as frozen after its 14 May 2026 refresh, and the loaded extract as 12 Apr 2026. Open the dataset
- Refresh cadence in this repository
- The Motus history append is the third step of the 04:50 UTC insurance job. This repository does not schedule a reload of 6sqe-dvqs.
- Last-updated mechanism
- A successful append can stamp motus_insurance. It does not create a separate history freshness key.
- Upstream portal time, read 14 Nov 2026
- Portal rowsUpdatedAt read on 14 Nov 2026 for InsHist 6sqe-dvqs: 2026-11-14T13:16:36Z. That portal time conflicts with the repository's May 2026 freeze note. It is not a DOT Intel load time.
- Owner confirmation needed
- Owner confirmation needed: confirm whether any job outside this repository reloaded 6sqe-dvqs after the freeze note, and the latest successful history append.
Safety, CSA, inspections, violations, and crashes
- Source
- Scheduled pulls in this repository: SMS AB PassProperty https://data.transportation.gov/resource/4y6x-dmck.json (csa-daily-basic, 04:00 UTC), SMS Input - Crash https://data.transportation.gov/resource/4wxs-vbns.json (csa-daily-crashes, 04:05 UTC), and SMS Input - Inspection https://data.transportation.gov/resource/rbkj-cgst.json (csa-daily-inspections, 04:10 UTC). csa-daily-postprocess at 04:30 UTC rebuilds summaries from those pulls. It is not a new FMCSA download. Open the dataset
- Refresh cadence in this repository
- Those four job names are scheduled daily in supabase/migrations/20260526_sub_arc_3b_v2_split_orchestrator.sql. Migration 202611140001 keeps the same clocks and points the commands at csa_ingest.run_sms_delta_and_stamp and csa_ingest.run_postprocess_and_stamp. The csa_sms freshness row expects a refresh inside 30 days plus a 12-hour grace, which is a wider window than the daily schedule.
- Last-updated mechanism
- A delta records last_failure and increments failure_count when the upstream file is below its floor, :updated_at is missing, the call errors, or zero rows come back while the publication is more than an hour ahead of the watermark. A quiet day with zero new rows, while the watermark already matches the publication, is not a failure. The 04:30 UTC postprocess rebuilds percentiles and csa.carrier_safety_summary when BASIC data moved or the summary is past that cadence plus grace. It stamps csa_sms only after that rebuild, and only when the summary has at least 100,000 rows and each watermark is within an hour of its publication. Migration 20261026 backfilled last_successful_refresh once from max(csa.carrier_safety_summary.refreshed_at). That backfill is not a later success. Vehicle Inspection File fx4q-ay7w and Vehicle Inspections and Violations 876r-jsdb are fetched by backfill functions that unschedule themselves when they finish. They are not standing daily jobs in the migrations reviewed.
- Upstream portal time, read 14 Nov 2026
- Portal rowsUpdatedAt read on 14 Nov 2026: 4y6x-dmck 2026-11-13T07:05:17Z, 4wxs-vbns 2026-11-13T07:03:59Z, rbkj-cgst 2026-11-13T11:00:50Z, fx4q-ay7w 2026-11-14T18:01:23Z, 876r-jsdb 2026-11-14T13:56:17Z.
- Owner confirmation needed
- Owner confirmation needed: this repository does not contain cron.job_run_details. Applying 202611140001, then running the basic, crashes, and inspections wrappers before run_postprocess_and_stamp, is still a production step. Until that runs, the live csa_sms row can remain the 2026-05-19 summary backfill. Confirm the four job names are the live cron rows, and that the fx4q-ay7w and 876r-jsdb backfills are not still scheduled.
Prospect search index, including the stored renewal estimate
- Source
- Not an FMCSA download. public.refresh_prospect_index() rebuilds the index from the carrier, insurance, and safety tables already loaded.
- Refresh cadence in this repository
- In this repository: every day at 06:30 UTC (prospect-index-daily-refresh).
- Last-updated mechanism
- refresh_prospect_index_and_stamp counts prospect_index and stamps prospect_index. The seeded expectation is 1 day. The renewal arithmetic is on the methodology page.
- Owner confirmation needed
- Owner confirmation needed: the latest successful prospect-index stamp is not in this repository.
Jobs that do not refresh these records
A daily 07:00 UTC census freshness check reports health and is left unstamped on purpose. A 05:20 UTC market snapshot is derived from current insurance and gates itself to one observation a month. Vercel cron paths in vercel.json — warmup, content ingest, agency mirror, content classify, deletion purge, mission runs, and the weekly appendix check — are application jobs, not FMCSA downloads.
The renewal-window formula that reads the current filing is on the methodology page.