{
  "_id": "6a49552cf6c47c441949c527",
  "Package": "sqldf",
  "Version": "0.4-13",
  "Date": "2026-06-27",
  "Title": "Manipulate R Data Frames Using SQL",
  "Authors@R": "person(given = \"G.\",\nfamily = \"Grothendieck\",\nrole = c(\"aut\", \"cre\"),\nemail = \"ggrothendieck@gmail.com\")",
  "Description": "The sqldf() function is typically passed a single argument\nwhich is an SQL select statement where the table names are\nordinary R data frame names.  sqldf() transparently sets up a\ndatabase, imports the data frames into that database, performs\nthe SQL select or other statement and returns the result using\na heuristic to determine which class to assign to each column\nof the returned data frame.  The sqldf() or read.csv.sql()\nfunctions can also be used to read filtered files into R even\nif the original files are larger than R itself can handle.\n'RSQLite', 'RH2', 'RMySQL' and 'RPostgreSQL' backends are\nsupported.",
  "ByteCompile": "true",
  "License": "GPL-2",
  "BugReports": "https://github.com/ggrothendieck/sqldf/issues",
  "URL": "https://github.com/ggrothendieck/sqldf",
  "NeedsCompilation": "no",
  "Repository": "https://ggrothendieck.r-universe.dev",
  "Date/Publication": "2026-06-28 16:00:21 UTC",
  "RemoteUrl": "https://github.com/ggrothendieck/sqldf",
  "RemoteRef": "HEAD",
  "RemoteSha": "462ae075559c994daa638a2c55589443aa95427a",
  "Packaged": {
    "Date": "2026-06-28 17:11:03 UTC",
    "User": "root"
  },
  "Author": "G. Grothendieck [aut, cre]",
  "Maintainer": "G. Grothendieck <ggrothendieck@gmail.com>",
  "_user": "ggrothendieck",
  "_type": "src",
  "_file": "sqldf_0.4-13.tar.gz",
  "_fileid": "https://r2.ropensci.org/b079157f64d0849369253eac505390d7e4d4e6fa69623d8bac55abd3dee9262a",
  "_filesize": 264031,
  "_sha256": "b079157f64d0849369253eac505390d7e4d4e6fa69623d8bac55abd3dee9262a",
  "_expires": "2026-10-12T18:47:06.000Z",
  "_created": "2026-06-28T17:11:03.000Z",
  "_published": "2026-07-04T18:47:08.288Z",
  "_jobs": [
    {
      "job": 85157707442,
      "time": 126,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7936827570"
    },
    {
      "job": 85157707310,
      "time": 129,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "7936827761"
    },
    {
      "job": 85157707449,
      "time": 127,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7936827596"
    },
    {
      "job": 85157707379,
      "time": 75,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "7936821296"
    },
    {
      "job": 85157707152,
      "time": 144,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "7936811268"
    },
    {
      "job": 85157707352,
      "time": 97,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7936824103"
    },
    {
      "job": 85157707282,
      "time": 72,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7936820980"
    },
    {
      "job": 85157707406,
      "time": 77,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7936821725"
    },
    {
      "job": 85157707349,
      "time": 81,
      "config": "windows-release",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "7936822075"
    }
  ],
  "_host": "GitHub-Actions",
  "_buildurl": "https://github.com/r-universe/ggrothendieck/actions/runs/28329714827",
  "_status": "success",
  "_upstream": "https://github.com/ggrothendieck/sqldf",
  "_commit": {
    "id": "462ae075559c994daa638a2c55589443aa95427a",
    "author": "ggrothendieck <ggrothendieck@gmail.com>",
    "committer": "GitHub <noreply@github.com>",
    "message": "Merge pull request #60 from michaelwexler/patch-1\n\nUpdate README.md with PostgreSQL link",
    "time": 1782662421
  },
  "_maintainer": {
    "name": "G. Grothendieck",
    "email": "ggrothendieck@gmail.com",
    "login": "ggrothendieck",
    "description": "",
    "uuid": 7840510
  },
  "_distro": "resolute",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 3.1.0",
      "role": "Depends"
    },
    {
      "package": "gsubfn",
      "version": ">= 0.6",
      "role": "Depends"
    },
    {
      "package": "proto",
      "role": "Depends"
    },
    {
      "package": "RSQLite",
      "role": "Depends"
    },
    {
      "package": "DBI",
      "role": "Imports"
    },
    {
      "package": "chron",
      "role": "Imports"
    },
    {
      "package": "RH2",
      "role": "Suggests"
    },
    {
      "package": "RMySQL",
      "role": "Suggests"
    },
    {
      "package": "RPostgreSQL",
      "role": "Suggests"
    },
    {
      "package": "svUnit",
      "role": "Suggests"
    },
    {
      "package": "tcltk",
      "role": "Suggests"
    },
    {
      "package": "MASS",
      "role": "Suggests"
    }
  ],
  "_owner": "ggrothendieck",
  "_selfowned": true,
  "_usedby": 48,
  "_updates": [
    {
      "week": "2025-37",
      "n": 1
    },
    {
      "week": "2026-05",
      "n": 1
    },
    {
      "week": "2026-26",
      "n": 3
    }
  ],
  "_tags": [],
  "_stars": 252,
  "_contributors": [
    {
      "user": "ggrothendieck",
      "count": 18,
      "uuid": 7840510
    },
    {
      "user": "ajdamico",
      "count": 1,
      "uuid": 216807
    },
    {
      "user": "darentsai",
      "count": 1,
      "uuid": 36108216
    },
    {
      "user": "eciardullo",
      "count": 1,
      "uuid": 64991969
    },
    {
      "user": "michaelwexler",
      "count": 1,
      "uuid": 1821391
    },
    {
      "user": "wibeasley",
      "count": 1,
      "uuid": 1372890
    }
  ],
  "_userbio": {
    "uuid": 7840510,
    "type": "user",
    "name": "ggrothendieck",
    "followers": 44
  },
  "_downloads": {
    "count": 19058,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sqldf"
  },
  "_mentions": 25,
  "_devurl": "https://github.com/ggrothendieck/sqldf",
  "_searchresults": 8032,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "extra/sqldf.html",
    "manual.pdf"
  ],
  "_homeurl": "https://github.com/ggrothendieck/sqldf",
  "_realowner": "ggrothendieck",
  "_cranurl": true,
  "_releases": [
    {
      "version": "0-1.0",
      "date": "2007-07-21"
    },
    {
      "version": "0-1.1",
      "date": "2007-07-29"
    },
    {
      "version": "0-1.2",
      "date": "2008-12-10"
    },
    {
      "version": "0-1.4",
      "date": "2008-12-11"
    },
    {
      "version": "0-1.5",
      "date": "2009-06-07"
    },
    {
      "version": "0-1.7",
      "date": "2009-09-24"
    },
    {
      "version": "0-2.0",
      "date": "2009-12-24"
    },
    {
      "version": "0-2.1",
      "date": "2009-12-28"
    },
    {
      "version": "0-3.2",
      "date": "2010-02-01"
    },
    {
      "version": "0-3.3",
      "date": "2010-02-07"
    },
    {
      "version": "0.3-4",
      "date": "2010-02-14"
    },
    {
      "version": "0.3-5",
      "date": "2010-06-05"
    },
    {
      "version": "0.4-0",
      "date": "2011-06-15"
    },
    {
      "version": "0.4-1",
      "date": "2011-06-29"
    },
    {
      "version": "0.4-1.2",
      "date": "2011-07-23"
    },
    {
      "version": "0.4-2",
      "date": "2011-08-09"
    },
    {
      "version": "0.4-3",
      "date": "2011-11-06"
    },
    {
      "version": "0.4-4",
      "date": "2011-11-15"
    },
    {
      "version": "0.4-5",
      "date": "2011-11-22"
    },
    {
      "version": "0.4-6",
      "date": "2011-12-11"
    },
    {
      "version": "0.4-6.1",
      "date": "2011-12-19"
    },
    {
      "version": "0.4-6.4",
      "date": "2012-03-28"
    },
    {
      "version": "0.4-7",
      "date": "2014-02-22"
    },
    {
      "version": "0.4-7.1",
      "date": "2014-03-15"
    },
    {
      "version": "0.4-9",
      "date": "2014-10-27"
    },
    {
      "version": "0.4-10",
      "date": "2014-11-06"
    },
    {
      "version": "0.4-11",
      "date": "2017-06-28"
    },
    {
      "version": "0.4-12",
      "date": "2026-01-30"
    }
  ],
  "_exports": [
    "read.csv.sql",
    "read.csv2.sql",
    "sqldf"
  ],
  "_help": [
    {
      "page": "sqldf-package",
      "title": "sqldf package overview",
      "topics": [
        "sqldf-package"
      ]
    },
    {
      "page": "read.csv.sql",
      "title": "Read File Filtered by SQL",
      "topics": [
        "read.csv.sql",
        "read.csv2.sql"
      ]
    },
    {
      "page": "sqldf",
      "title": "SQL select on data frames",
      "topics": [
        "sqldf"
      ]
    }
  ],
  "_readme": "https://github.com/ggrothendieck/sqldf/raw/HEAD/README.md",
  "_rundeps": [
    "bit",
    "bit64",
    "blob",
    "cachem",
    "chron",
    "cli",
    "cpp11",
    "DBI",
    "fastmap",
    "glue",
    "gsubfn",
    "lifecycle",
    "memoise",
    "pkgconfig",
    "proto",
    "rlang",
    "RSQLite",
    "vctrs"
  ],
  "_score": 13.619725318681384,
  "_indexed": true,
  "_nocasepkg": "sqldf",
  "_universes": [
    "ggrothendieck"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.4-13",
      "date": "2026-06-28T17:13:00.000Z",
      "distro": "resolute",
      "commit": "462ae075559c994daa638a2c55589443aa95427a",
      "fileid": "https://r2.ropensci.org/8f4a23fde87ff7e09021245c216b7d35902d22058cdac53a2e0eb84f0cb38544",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ggrothendieck/actions/runs/28329714827"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.4-13",
      "date": "2026-06-28T17:13:02.000Z",
      "distro": "resolute",
      "commit": "462ae075559c994daa638a2c55589443aa95427a",
      "fileid": "https://r2.ropensci.org/37ff85be9aa0e8978c4685d328f9e986c234f35895b353d2bbaa9047b676df64",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ggrothendieck/actions/runs/28329714827"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.4-13",
      "date": "2026-06-28T17:13:07.000Z",
      "commit": "462ae075559c994daa638a2c55589443aa95427a",
      "fileid": "https://r2.ropensci.org/7cb96a93cb799d7e11430ebd0896a255c81a4644854c67487ed16498f8d503d6",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ggrothendieck/actions/runs/28329714827"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.4-13",
      "date": "2026-06-28T17:12:18.000Z",
      "commit": "462ae075559c994daa638a2c55589443aa95427a",
      "fileid": "https://r2.ropensci.org/881f66322ed81183bb2601eb36d64a106ddcada18f41001463f6e11c173c03ea",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ggrothendieck/actions/runs/28329714827"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.4-13",
      "date": "2026-06-28T17:12:56.000Z",
      "commit": "462ae075559c994daa638a2c55589443aa95427a",
      "fileid": "https://r2.ropensci.org/4f7d038937ea0c6e95553ee4093b3410402ac8935303496b4efa974d6785d37c",
      "status": "success",
      "buildurl": "https://github.com/r-universe/ggrothendieck/actions/runs/28329714827"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.4-13",
      "date": "2026-06-28T17:12:06.000Z",
      "commit": "462ae075559c994daa638a2c55589443aa95427a",
      "fileid": "https://r2.ropensci.org/c7f82801fc16710812ca3436c0c9952e26aa68bafa63b2ab6dd844b5df2d144b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ggrothendieck/actions/runs/28329714827"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.4-13",
      "date": "2026-06-28T17:12:14.000Z",
      "commit": "462ae075559c994daa638a2c55589443aa95427a",
      "fileid": "https://r2.ropensci.org/52181629d2629d23211160018fd082464dd97827ecceabb8d670d2303a136699",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ggrothendieck/actions/runs/28329714827"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.4-13",
      "date": "2026-06-28T17:12:14.000Z",
      "commit": "462ae075559c994daa638a2c55589443aa95427a",
      "fileid": "https://r2.ropensci.org/80179f6b5df71a1df00e49c10b6b09ff9639b94ef929e9eb5d4cb8f58494e75e",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ggrothendieck/actions/runs/28329714827"
    }
  ]
}