observatory inspect FILE --json

Definition

Prints row counts for non-sensitive tables. Add --include-sensitive to include every published table.

Inspect the file you just produced

observatory inspect out/observatory.sqlite --json
observatory inspect out/observatory.sqlite --json --include-sensitive

The first command gives counts for non-sensitive tables. The second includes every published table, so choose it when you need to check the presence of object or person data. Use the path printed by your run if it differs from this example.

Interpret an absent count

A table missing from the default inspection may be hidden by the visibility rule; it is not necessarily empty. Inspecting counts also does not establish that a measure is complete: read the run warnings and the relevant table's meaning before interpreting a zero, a missing value or a small population. The result-file reference explains where to find the schema.