{
  "_id": "6a1c71411d7bb097a0a31a8b",
  "Package": "duckspending",
  "Title": "Access to USAspending Data in a DuckLake",
  "Version": "0.1.0",
  "Authors@R": "person(\"Grant Witness\", role = c(\"aut\", \"cre\"),\nemail = \"info@grant-witness.us\")",
  "Description": "Provides a connection to USAspending data in a DuckLake,\nallowing users to perform bulk analyses difficult to achieve\nwith the USAspending API.",
  "License": "MIT + file LICENSE",
  "Encoding": "UTF-8",
  "Roxygen": "list(markdown = TRUE)",
  "RoxygenNote": "8.0.0",
  "VignetteBuilder": "knitr",
  "Config/testthat/edition": "3",
  "URL": "https://usaspending.grant-witness.us/r-package/",
  "Contact": "info@grant-witness.us",
  "Config/pak/sysreqs": "xz-utils",
  "Repository": "https://noamross.r-universe.dev",
  "Date/Publication": "2026-05-20 00:13:56 UTC",
  "RemoteUrl": "https://usaspending.grant-witness.us/r-package/duckspending",
  "RemoteRef": "HEAD",
  "RemoteSha": "fd2dfb428242dad1aa9cd63c77217afcfa4a9269",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-05-31 17:31:02 UTC",
    "User": "root"
  },
  "Author": "Grant Witness [aut, cre]",
  "Maintainer": "Grant Witness <info@grant-witness.us>",
  "MD5sum": "2e7c668698181b89dea146bf8737730d",
  "_user": "noamross",
  "_type": "src",
  "_file": "duckspending_0.1.0.tar.gz",
  "_fileid": "a5e676566367aafa1622c63b0ba8049cf1e62ccf61c6ea3772bf1899c967e4c4",
  "_filesize": 184590,
  "_sha256": "a5e676566367aafa1622c63b0ba8049cf1e62ccf61c6ea3772bf1899c967e4c4",
  "_created": "2026-05-31T17:31:02.000Z",
  "_published": "2026-05-31T17:34:57.744Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 78744004286,
      "time": 182,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "ERROR",
      "artifact": "7318699313"
    },
    {
      "job": 78744004298,
      "time": 177,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "ERROR",
      "artifact": "7318698776"
    },
    {
      "job": 78744004301,
      "time": 112,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "ERROR",
      "artifact": "7318691374"
    },
    {
      "job": 78744004310,
      "time": 170,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "ERROR",
      "artifact": "7318697906"
    },
    {
      "job": 78743723636,
      "time": 262,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7318678220"
    },
    {
      "job": 78744004293,
      "time": 118,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7318692167"
    },
    {
      "job": 78744004302,
      "time": 171,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "ERROR",
      "artifact": "7318697904"
    },
    {
      "job": 78744004311,
      "time": 148,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "ERROR",
      "artifact": "7318695340"
    },
    {
      "job": 78744004303,
      "time": 190,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "ERROR",
      "artifact": "7318700128"
    }
  ],
  "_buildurl": "https://github.com/r-universe/noamross/actions/runs/26719424230",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://usaspending.grant-witness.us/r-package/duckspending",
  "_commit": {
    "id": "fd2dfb428242dad1aa9cd63c77217afcfa4a9269",
    "author": "Grant Witness <info@grant-witness.us>",
    "committer": "Grant Witness <info@grant-witness.us>",
    "message": "Release 2026-05-20\n",
    "time": 1779236036
  },
  "_maintainer": {
    "name": "Grant Witness",
    "email": "info@grant-witness.us"
  },
  "_registered": true,
  "_dependencies": [
    {
      "package": "cli",
      "role": "Imports"
    },
    {
      "package": "DBI",
      "role": "Imports"
    },
    {
      "package": "duckdb",
      "role": "Imports"
    },
    {
      "package": "lifecycle",
      "role": "Imports"
    },
    {
      "package": "methods",
      "role": "Imports"
    },
    {
      "package": "rlang",
      "role": "Imports"
    },
    {
      "package": "tibble",
      "role": "Imports"
    },
    {
      "package": "utils",
      "role": "Imports"
    },
    {
      "package": "vctrs",
      "role": "Imports"
    },
    {
      "package": "connections",
      "role": "Suggests"
    },
    {
      "package": "dbplyr",
      "role": "Suggests"
    },
    {
      "package": "dplyr",
      "role": "Suggests"
    },
    {
      "package": "jsonlite",
      "role": "Suggests"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "labelled",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "rscontract",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 3.0.0",
      "role": "Suggests"
    },
    {
      "package": "withr",
      "role": "Suggests"
    },
    {
      "package": "pkgdown",
      "role": "Suggests"
    },
    {
      "package": "rprojroot",
      "role": "Suggests"
    }
  ],
  "_owner": "usaspending-r-package",
  "_selfowned": false,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2026-20",
      "n": 7
    },
    {
      "week": "2026-21",
      "n": 3
    }
  ],
  "_tags": [],
  "_userbio": {
    "uuid": 571752,
    "type": "user",
    "name": "Noam Ross",
    "description": "Computational Disease Ecologist, Executive Director of @ropensci, consulting in forecasting, One Health, #RStats + open-source science"
  },
  "_downloads": {
    "count": 0,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/duckspending"
  },
  "_searchresults": 0,
  "_rbuild": "4.6.0",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/duckspending.html",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "manual.pdf"
  ],
  "_cranurl": false,
  "_exports": [
    "duckspending_agencies",
    "duckspending_assistance_transactions",
    "duckspending_attach",
    "duckspending_attached",
    "duckspending_clear_cache",
    "duckspending_connection",
    "duckspending_describe",
    "duckspending_descriptions",
    "duckspending_detach",
    "duckspending_label",
    "duckspending_label_default",
    "duckspending_latest",
    "duckspending_procurement_transactions",
    "duckspending_recipients",
    "duckspending_snapshots",
    "duckspending_subawards",
    "duckspending_tbl",
    "duckspending_view"
  ],
  "_help": [
    {
      "page": "connection_view.duckspending_connection",
      "title": "IDE Connections pane integration for a duckspending connection",
      "topics": [
        "connection_view.duckspending_connection"
      ]
    },
    {
      "page": "duckspending_attach",
      "title": "Attach an additional snapshot to an open connection",
      "topics": [
        "duckspending_attach"
      ]
    },
    {
      "page": "duckspending_attached",
      "title": "Currently-attached snapshots on a connection",
      "topics": [
        "duckspending_attached"
      ]
    },
    {
      "page": "duckspending_clear_cache",
      "title": "Clear the on-disk HTTP cache for a duckspending connection",
      "topics": [
        "duckspending_clear_cache"
      ]
    },
    {
      "page": "duckspending_connection",
      "title": "Connect to the USAspending DuckLake archive",
      "topics": [
        "duckspending_connection"
      ]
    },
    {
      "page": "duckspending_describe",
      "title": "Describe snapshots, tables, and columns visible on a connection",
      "topics": [
        "duckspending_describe"
      ]
    },
    {
      "page": "duckspending_descriptions",
      "title": "Fetch and parse a descriptions JSON file for a USAspending DuckLake",
      "topics": [
        "duckspending_descriptions"
      ]
    },
    {
      "page": "duckspending_detach",
      "title": "Detach a snapshot from an open connection",
      "topics": [
        "duckspending_detach"
      ]
    },
    {
      "page": "duckspending_label",
      "title": "Apply column descriptions as labels to a data frame",
      "topics": [
        "duckspending_label"
      ]
    },
    {
      "page": "duckspending_label_default",
      "title": "Resolve whether labels should be applied by default",
      "topics": [
        "duckspending_label_default"
      ]
    },
    {
      "page": "duckspending_latest",
      "title": "The newest available snapshot date.",
      "topics": [
        "duckspending_latest"
      ]
    },
    {
      "page": "duckspending_snapshots",
      "title": "List available USAspending snapshots",
      "topics": [
        "duckspending_snapshots"
      ]
    },
    {
      "page": "duckspending_table_helpers",
      "title": "Convenience accessors for the most-used USAspending tables",
      "topics": [
        "duckspending_agencies",
        "duckspending_assistance_transactions",
        "duckspending_procurement_transactions",
        "duckspending_recipients",
        "duckspending_subawards",
        "duckspending_table_helpers"
      ]
    },
    {
      "page": "duckspending_tables",
      "title": "Tables published in the USAspending DuckLake archive",
      "topics": [
        "duckspending_tables"
      ]
    },
    {
      "page": "duckspending_tbl",
      "title": "Lazy table accessor for a USAspending DuckLake snapshot",
      "topics": [
        "duckspending_tbl"
      ]
    },
    {
      "page": "duckspending_view",
      "title": "Open the IDE Connections pane for a duckspending connection",
      "topics": [
        "duckspending_view"
      ]
    }
  ],
  "_rundeps": [
    "cli",
    "DBI",
    "duckdb",
    "glue",
    "lifecycle",
    "magrittr",
    "pillar",
    "pkgconfig",
    "rlang",
    "tibble",
    "utf8",
    "vctrs"
  ],
  "_vignettes": [
    {
      "source": "getting-started.Rmd",
      "filename": "getting-started.html",
      "title": "Getting started with duckspending",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Install",
        "Connect",
        "First query",
        "Filter on the partition columns",
        "When to use collect()",
        "Inspect tables and columns",
        "Disconnect",
        "Where to next"
      ],
      "created": "2026-05-16 22:00:00",
      "modified": "2026-05-20 00:13:56",
      "commits": 3
    },
    {
      "source": "cross-snapshot.Rmd",
      "filename": "cross-snapshot.html",
      "title": "Querying across snapshots",
      "engine": "knitr::rmarkdown",
      "headings": [
        "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"
      ],
      "created": "2026-05-16 22:00:00",
      "modified": "2026-05-16 22:00:00",
      "commits": 1
    },
    {
      "source": "sql-escape-hatch.Rmd",
      "filename": "sql-escape-hatch.html",
      "title": "Raw SQL escape hatch",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Basic usage",
        "Schema-qualified queries across snapshots",
        "Quoting digit-leading identifiers",
        "Parameterised values",
        "When to stay in dplyr"
      ],
      "created": "2026-05-16 22:00:00",
      "modified": "2026-05-16 22:00:00",
      "commits": 1
    }
  ],
  "_score": 2.778151250383644,
  "_indexed": false,
  "_nocasepkg": "duckspending",
  "_universes": [
    "noamross"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.1.0",
      "date": "2026-05-31T17:33:48.000Z",
      "distro": "noble",
      "commit": "fd2dfb428242dad1aa9cd63c77217afcfa4a9269",
      "fileid": "899ca34277af49c5116f6e7bb27ae5eea20ece7fadd7d8c6dd56b8eb6b7403bb",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/noamross/actions/runs/26719424230"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "0.1.0",
      "date": "2026-05-31T17:33:45.000Z",
      "distro": "noble",
      "commit": "fd2dfb428242dad1aa9cd63c77217afcfa4a9269",
      "fileid": "0b707d3948c3c5880772adc562dd5981aff08ed7142613b18d14fcd28a26f06a",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/noamross/actions/runs/26719424230"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.1.0",
      "date": "2026-05-31T17:32:53.000Z",
      "commit": "fd2dfb428242dad1aa9cd63c77217afcfa4a9269",
      "fileid": "d7ad64888b6896bbb626c6c0dfc3dd3c9409db4c9aa28a0d4e43c81966de8566",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/noamross/actions/runs/26719424230"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "0.1.0",
      "date": "2026-05-31T17:32:55.000Z",
      "commit": "fd2dfb428242dad1aa9cd63c77217afcfa4a9269",
      "fileid": "ba7e2fe5e7d6e7b65b68c51c81eff9a666935df004dd70a137bddcae4e4323dd",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/noamross/actions/runs/26719424230"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.1.0",
      "date": "2026-05-31T17:33:33.000Z",
      "commit": "fd2dfb428242dad1aa9cd63c77217afcfa4a9269",
      "fileid": "5515132d25d4ac45969e8297e50f08c02b54c8a7d95f2c027e655d7e23955298",
      "status": "success",
      "buildurl": "https://github.com/r-universe/noamross/actions/runs/26719424230"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.1.0",
      "date": "2026-05-31T17:32:48.000Z",
      "commit": "fd2dfb428242dad1aa9cd63c77217afcfa4a9269",
      "fileid": "51b5da1179701e20f33d62ada7ab825c5bdbfdd0c4eb0069d70fbde8aabe9519",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/noamross/actions/runs/26719424230"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.1.0",
      "date": "2026-05-31T17:32:40.000Z",
      "commit": "fd2dfb428242dad1aa9cd63c77217afcfa4a9269",
      "fileid": "0557e412b648621221af591bf29c0f6d729c1cd785d897c8e3aaa3b8b9a12a4f",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/noamross/actions/runs/26719424230"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "0.1.0",
      "date": "2026-05-31T17:33:17.000Z",
      "commit": "fd2dfb428242dad1aa9cd63c77217afcfa4a9269",
      "fileid": "8256eedfe898ea4cbcb4ff5bd66d560acb4a3e712b0389f6d156db7b0918c633",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/noamross/actions/runs/26719424230"
    }
  ]
}