Retrieve one Statistical Abstract table as tidy observations

Downloads the table's chapter workbook from the KNBS website (cached locally), extracts the table by its curated recipe, verifies the layout anchors and pinned reference values, and returns one row per cell of the printed table.

Usage

knbs_abstract_table(table, cache = knbs_option("cache"), refresh = FALSE)

Arguments

table

A table id from knbs_abstract_tables() (for example "2.2"), or enough of a table title to identify one unambiguously.

cache

Whether to use the local cache.

refresh

Whether to re-download the workbook and re-extract.

Value

A knbs_abstract_table tibble. knbs_metadata() returns its provenance, including the workbook file and its SHA-256; knbs_cite() cites it.

Details

period is the integer year. status carries the source's own year flags, "provisional" (*) or "revised" (+), and is NA for final years. Sectioned tables (the production accounts, the income accounts) carry their section as an extra column named for what it is — industry or account. A row the source prints without figures (such as "Less: Subsidies" in the production accounts) is kept with NA values, because that is what the source shows.

Tables that print totals beside their parts (GDP by activity, expenditure on GDP, capital formation) carry a parent column naming the row each item is a component of: industries have "All industries" (or "All industries at basic prices") as their parent, sub-industries have their industry, and headline totals and memo items have NA. Summing rows that share a parent never double counts; summing the whole table does. For level and share tables the parts are checked to add up to their parent in every year, within rounding. Imports enter GDP with a negative sign, and the metadata says so. The accounts tables (2.1, 2.8, 2.9) are linked by accounting identities rather than parts and totals, and have no parent column.

County tables (construction by county, school enrolment, registered births and deaths) carry geo_code, each row's census frame code, so they join knbs_geographies(), the census tables and anything passed through knbs_county_code(); their total row is "00". Such a table is refused if its rows no longer account for the 47 counties exactly once. Tables that print a unit per row (production of selected commodities) carry it in a unit column. The sheets' footnotes and source lines are in knbs_metadata()'s notes.

The extraction is deliberately strict: if the workbook's layout, sections or pinned reference values no longer match what was verified at curation time, the function stops with knbs_error_schema_changed or knbs_error_validation_failed rather than guessing — wrong tidy data would be worse than an honest error.

See also

knbs_abstract_tables()

Examples

if (FALSE) { # interactive()
gdp <- knbs_abstract_table("2.2")
expenditure <- knbs_abstract_table("expenditure on the gross domestic")
}