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.