issues: 777707544

This data as json

id node_id number title user state locked assignee milestone comments created_at updated_at closed_at author_association pull_request body repo type active_lock_reason performed_via_github_app
777707544 MDU6SXNzdWU3Nzc3MDc1NDQ= 219 reset_counts() method and command 9599 closed 0     4 2021-01-03T20:08:28Z 2021-01-03T20:59:37Z 2021-01-03T20:59:37Z OWNER  

Thought: maybe there should be a .reset_counts() method too, for if the table gets out of date with the triggers.

One way that could happen is if a table is dropped and recreated - the counts in the _counts table would likely no longer match the number of rows in that table.

_Originally posted by @simonw in https://github.com/simonw/sqlite-utils/issues/215#issuecomment-753545757_

140912432 issue    

Links from other tables