Package: duckspending 0.1.0

Grant Witness

duckspending: Access to USAspending Data in a DuckLake

Provides a connection to USAspending data in a DuckLake, allowing users to perform bulk analyses difficult to achieve with the USAspending API.

Authors:Grant Witness [aut, cre]

duckspending_0.1.0.tar.gz
duckspending_0.1.0.zip(r-4.7-any)duckspending_0.1.0.zip(r-4.6-any)duckspending_0.1.0.zip(r-4.5-any)
duckspending_0.1.0.tgz(r-4.6-any)duckspending_0.1.0.tgz(r-4.5-any)
duckspending_0.1.0.tar.gz(r-4.7-any)duckspending_0.1.0.tar.gz(r-4.6-any)
duckspending_0.1.0.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
duckspending/json (API)

# Install 'duckspending' in R:
install.packages('duckspending', repos = c('https://noamross.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://usaspending.grant-witness.us/r-package/duckspending

On CRAN:

Conda:

2.78 score 18 exports 12 dependencies

Last updated from:fd2dfb4282. Checks:7 ERROR, 2 OK. Indexed: no.

TargetResultTimeFilesSyslog
linux-devel-x86_64ERROR176
source / vignettesOK233
linux-release-x86_64ERROR186
macos-release-arm64ERROR129
macos-oldrel-arm64ERROR157
windows-devel-x86_64ERROR160
windows-release-x86_64ERROR149
windows-oldrel-x86_64ERROR167
wasm-releaseOK130

Exports:duckspending_agenciesduckspending_assistance_transactionsduckspending_attachduckspending_attachedduckspending_clear_cacheduckspending_connectionduckspending_describeduckspending_descriptionsduckspending_detachduckspending_labelduckspending_label_defaultduckspending_latestduckspending_procurement_transactionsduckspending_recipientsduckspending_snapshotsduckspending_subawardsduckspending_tblduckspending_view

Dependencies:cliDBIduckdbgluelifecyclemagrittrpillarpkgconfigrlangtibbleutf8vctrs

Getting started with duckspending
Install | Connect | First query | Filter on the partition columns | When to use collect() | Inspect tables and columns | Disconnect | Where to next
Rendered fromgetting-started.Rmdusingknitr::rmarkdown

Last update: 2026-05-20
Started: 2026-05-16

Querying across snapshots
Attaching multiple snapshots | Adding / removing snapshots at runtime | Cross-snapshot diff | Caveat: snapshots are not strictly additive | Worked examples: detecting specific kinds of revision | Backfills into a closed fiscal year | End-date revisions (no-cost extensions, early terminations) | Validating time-travel consistency | Disconnect
Rendered fromcross-snapshot.Rmdusingknitr::rmarkdown

Last update: 2026-05-16
Started: 2026-05-16

Raw SQL escape hatch
Basic usage | Schema-qualified queries across snapshots | Quoting digit-leading identifiers | Parameterised values | When to stay in dplyr
Rendered fromsql-escape-hatch.Rmdusingknitr::rmarkdown

Last update: 2026-05-16
Started: 2026-05-16