home / openregs

Explore: Docket Detail

Docket information with document and comment counts.

Custom SQL query (hide)

SELECT 'held count = floor; holdings ~41.5% of upstream, biased low for mass-comment dockets — see /explore/comments-coverage.html' AS coverage_note, d.*, (SELECT COUNT(*) FROM comments WHERE docket_id = d.id) AS comment_count, (SELECT COUNT(*) FROM documents WHERE docket_id = d.id) AS doc_count FROM dockets d WHERE d.id = :docket_id

Query parameters

Edit SQL

0 results

Powered by Datasette · Queries took 0.303ms · Privacy