Skip to content

Bug: Number of orgs changes a little oddly in idx_monthly_reports_site table #334

@vevetron

Description

@vevetron

Describe the bug
When I run the following query, 3 agencies disappear from the published reports between March and April. One I understand, I don't understand why the other two disappear.

[{
"organization_itp_id": "264",
"organization_name": "City of Rio Vista",
"count": "1"
}, {
"organization_itp_id": "329",
"organization_name": "Susanville Indian Rancheria",
"count": "1"
}, {
"organization_itp_id": "289",
"organization_name": "San Luis Obispo Regional Transit Authority",
"count": "1"
}, {

SELECT
  idx.`organization_itp_id`,
  idx.`organization_name`, 
  -- publish_date
  count(*) as count
FROM `mart_gtfs_quality.idx_monthly_reports_site` AS idx
-- select idx.`publish_date` FROM `mart_gtfs_quality.idx_monthly_reports_site` AS idx order by publish_date DESC limit 1
-- where publish_date in ()
where publish_date in ("2025-03-01T00:00:00", "2025-04-01T00:00:00")

group by organization_itp_id, organization_name
order by count ASC;

I want to check again in a few days.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions