Research Task - June 2025 Monthly NTD Ridership Report Publish

[csuyat-dot]

Research Task

Check Complete Monthly Ridership (with adjustments and estimates) | FTA (dot.gov) for June2025 data.

Check mart_ntd.dim_monthly_ridership_with_adjustments in BQ for June2025 data. Use:

SELECT
DISTINCT period_year_month
FROM
cal-itp-data-infra.mart_ntd.dim_monthly_ridership_with_adjustments
WHERE primary_uza_name LIKE "%, CA%"
AND period_year = "2025"
LIMIT
1000

If new data is present, run the make ntd_monthly_export

• Relevant PR (if applicable):

• Question or Goal: overarching goal of this issue

• Data Required:

  • Currently have:
  • Need:

• Research Required:

• Metrics: what specific calculations are you looking to find?

• Expected Outputs / Findings: what do you hope to have created when this is complete?