{
  "_id": "6aad09873d719c1f840752ea",
  "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.git",
  "RemoteRef": "HEAD",
  "RemoteSha": "fd2dfb428242dad1aa9cd63c77217afcfa4a9269",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-09-18 09:46:54 UTC",
    "User": "root"
  },
  "Author": "Grant Witness [aut, cre]",
  "Maintainer": "Grant Witness <info@grant-witness.us>",
  "_user": "noamross",
  "_type": "src",
  "_file": "duckspending_0.1.0.tar.gz",
  "_fileid": "https://r2.ropensci.org/fabaf22e2745e81a961d463a4ccb93e9de5fa276b018b8233954c432f02eae48",
  "_filesize": 204541,
  "_sha256": "fabaf22e2745e81a961d463a4ccb93e9de5fa276b018b8233954c432f02eae48",
  "_expires": "2026-12-27T09:51:01.000Z",
  "_created": "2026-09-18T09:46:54.000Z",
  "_published": "2026-09-18T09:51:03.274Z",
  "_jobs": [
    {
      "job": 105556205956,
      "time": 171,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "ERROR",
      "artifact": "10540854475"
    },
    {
      "job": 105556206064,
      "time": 177,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "ERROR",
      "artifact": "10541765132"
    },
    {
      "job": 105556205794,
      "time": 143,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "ERROR",
      "artifact": "10541570755"
    },
    {
      "job": 105556205769,
      "time": 139,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "ERROR",
      "artifact": "10541004085"
    },
    {
      "job": 105555118442,
      "time": 235,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "10541128346"
    },
    {
      "job": 105556205881,
      "time": 125,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "10540744547"
    },
    {
      "job": 105556205894,
      "time": 139,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "ERROR",
      "artifact": "10540894375"
    },
    {
      "job": 105556206007,
      "time": 144,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "ERROR",
      "artifact": "10540879384"
    },
    {
      "job": 105556205983,
      "time": 133,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "ERROR",
      "artifact": "10541365987"
    }
  ],
  "_host": "GitHub-Actions",
  "_buildurl": "https://github.com/r-universe/noamross/actions/runs/35330981892",
  "_status": "success",
  "_upstream": "https://usaspending.grant-witness.us/r-package/duckspending.git",
  "_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"
  },
  "_distro": "resolute",
  "_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",
    "followers": 579,
    "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"
  },
  "_pkgdown": "https://usaspending.grant-witness.us/r-package/",
  "_searchresults": 0,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/duckspending.html",
    "extra/manual.pdf",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "LICENSE"
  ],
  "_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-09-18T09:49:15.000Z",
      "distro": "resolute",
      "commit": "fd2dfb428242dad1aa9cd63c77217afcfa4a9269",
      "fileid": "https://r2.ropensci.org/5fd1bbaf42f14d52869648207b0f5f55526027acd2e74a49c7764bd31e2cc98e",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/noamross/actions/runs/35330981892"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.1.0",
      "date": "2026-09-18T09:49:19.000Z",
      "distro": "resolute",
      "commit": "fd2dfb428242dad1aa9cd63c77217afcfa4a9269",
      "fileid": "https://r2.ropensci.org/e0b076ce749360ce217bdd885fb1700d841ec1d4f7442e7e28a6ba2a2edae769",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/noamross/actions/runs/35330981892"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.1.0",
      "date": "2026-09-18T09:49:52.000Z",
      "commit": "fd2dfb428242dad1aa9cd63c77217afcfa4a9269",
      "fileid": "https://r2.ropensci.org/8872f01cdba5bea1c20325e0edf3c4139264f402662bb17dea856a2a1d6b3667",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/noamross/actions/runs/35330981892"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.1.0",
      "date": "2026-09-18T09:49:11.000Z",
      "commit": "fd2dfb428242dad1aa9cd63c77217afcfa4a9269",
      "fileid": "https://r2.ropensci.org/a2a893ec696447f11a9c5b62a031166af8e3a0d42242bf64f480809e618c254f",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/noamross/actions/runs/35330981892"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.1.0",
      "date": "2026-09-18T09:49:22.000Z",
      "commit": "fd2dfb428242dad1aa9cd63c77217afcfa4a9269",
      "fileid": "https://r2.ropensci.org/810e50d1b9639073ca14607a4302ca8327140fae79acd54215dce2380517b5e5",
      "status": "success",
      "buildurl": "https://github.com/r-universe/noamross/actions/runs/35330981892"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.1.0",
      "date": "2026-09-18T09:48:12.000Z",
      "commit": "fd2dfb428242dad1aa9cd63c77217afcfa4a9269",
      "fileid": "https://r2.ropensci.org/e5fcebec4cf9d56a06e08906673313a262518988b4414eb011d429662a5a49d7",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/noamross/actions/runs/35330981892"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.1.0",
      "date": "2026-09-18T09:48:14.000Z",
      "commit": "fd2dfb428242dad1aa9cd63c77217afcfa4a9269",
      "fileid": "https://r2.ropensci.org/6c6830c9ac80e036f03523c7dc6aba076e0cd837ced38ba5fdc5c1767aca3b32",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/noamross/actions/runs/35330981892"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.1.0",
      "date": "2026-09-18T09:48:06.000Z",
      "commit": "fd2dfb428242dad1aa9cd63c77217afcfa4a9269",
      "fileid": "https://r2.ropensci.org/5b13280e079e7b45b7a9874a2d1d97ce50b278dde3a71d9137b565f4d45cc052",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/noamross/actions/runs/35330981892"
    }
  ]
}