The Statistical Abstract publishes its chapter tables as Excel workbooks on
the KNBS website. This function lists the tables the package has curated:
each one has a hand-verified extraction recipe — sheet, layout anchors,
section labels, unit and pinned reference values — so that
knbs_abstract_table() can return it as clean tidy observations, or refuse
with a clear error if the workbook has changed.
Curated so far, from the 2025 edition: all fifteen tables of Chapter 2 (National Accounts) — the production accounts, GDP by activity at current and constant prices, expenditure on GDP, capital formation, national income and saving — and 33 tables from twelve more chapters: wage employment, insurance and savings, exports, crop sales and prices, forests and wildlife, electricity and fuel, producer prices and industrial production, construction, tourism, transport, education enrolment, and registered births and deaths. Six are county tables.
Examples
knbs_abstract_tables()
#> <knbs_catalogue>
#> Title: 2025 Statistical Abstract: curated tables
#> Rows: 48
#> Source: Kenya National Bureau of Statistics
#>
#> # A tibble: 48 × 6
#> table_id title chapter unit sheet workbook
#> <chr> <chr> <chr> <chr> <chr> <chr>
#> 1 2.1 Annual Production Accounts by Industry… Chapte… KSh … Tabl… NA-Stat…
#> 2 2.2 Gross Domestic Product by Activity, 20… Chapte… KSh … Tabl… NA-Stat…
#> 3 2.3 Contribution to Gross Domestic Product… Chapte… per … Tabl… NA-Stat…
#> 4 2.4 Gross Domestic Product by Activity, 20… Chapte… KSh … Tabl… NA-Stat…
#> 5 2.5 Growth of Gross Domestic Product by Ac… Chapte… per … Tabl… NA-Stat…
#> 6 2.6a Expenditure on the Gross Domestic Prod… Chapte… KSh … Tabl… NA-Stat…
#> 7 2.6b Expenditure on the Gross Domestic Prod… Chapte… per … Tabl… NA-Stat…
#> 8 2.6c Expenditure on the Gross Domestic Prod… Chapte… KSh … Tabl… NA-Stat…
#> 9 2.6d Growth in Expenditure on the Gross Dom… Chapte… per … Tabl… NA-Stat…
#> 10 2.7a Gross Fixed Capital Formation, 2015 - … Chapte… KSh … Tabl… NA-Stat…
#> # ℹ 38 more rows