Dockets for an Agency

Browse all dockets for a specific agency code (e.g., EPA, FDA, FWS, USDA) with comment counts.

Custom SQL query (hide) 

SELECT d.id, d.title, d.docket_type, d.last_modified, (SELECT COUNT(*) FROM comments c WHERE c.docket_id = d.id) AS comment_count, (SELECT COUNT(*) FROM documents doc WHERE doc.docket_id = d.id) AS document_count FROM dockets d WHERE d.agency_id = :agency_id ORDER BY d.last_modified DESC LIMIT 200

Query parameters

Edit SQL

0 results