Data Explorer

SELECT p.name              AS project,
       c.name              AS county,
       p.technology        AS tech,
       p.capacity_mw       AS mw,
       p.jurisdiction,
       p.status,
       count(DISTINCT f.org_id) AS opposing_orgs,
       count(f.filing_id)       AS filings
FROM   projects p
JOIN   counties c ON c.fips = p.county_fips
LEFT   JOIN dockets d  ON d.project_id = p.project_id
LEFT   JOIN filings f  ON f.docket_id = d.docket_id
JOIN   organizations o ON o.org_id = f.org_id
       AND o.tier IN ('front','local')
WHERE  p.technology IN ('solar', 'storage', 'solar+storage')
  AND  p.decision_date > date '2024-06-01'
GROUP  BY 1, 2, 3, 4, 5, 6
ORDER  BY filings DESC
LIMIT  50;