{
  "_id": "6a1d48171d7bb097a0a428a6",
  "Package": "sqldf",
  "Version": "0.4-12",
  "Date": "2026-01-29",
  "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-01-30 18:50:46 UTC",
  "RemoteUrl": "https://github.com/ggrothendieck/sqldf",
  "RemoteRef": "HEAD",
  "RemoteSha": "68a9562fe204a20aea3fc001ac364b5fa68ca94c",
  "Packaged": {
    "Date": "2026-06-01 08:48:55 UTC",
    "User": "root"
  },
  "Author": "G. Grothendieck [aut, cre]",
  "Maintainer": "G. Grothendieck <ggrothendieck@gmail.com>",
  "MD5sum": "2564d9b96c338d8b87dfeb33c040dd93",
  "_user": "ggrothendieck",
  "_type": "src",
  "_file": "sqldf_0.4-12.tar.gz",
  "_fileid": "bb4f81dc85de6629b93e7fc74ce5550364380645cbf573c3ba20c1ef185c2a94",
  "_filesize": 259070,
  "_sha256": "bb4f81dc85de6629b93e7fc74ce5550364380645cbf573c3ba20c1ef185c2a94",
  "_created": "2026-06-01T08:48:55.000Z",
  "_published": "2026-06-01T08:51:35.287Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 78817427632,
      "time": 118,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7327197952"
    },
    {
      "job": 78817427628,
      "time": 124,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7327199626"
    },
    {
      "job": 78817427622,
      "time": 115,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7327194660"
    },
    {
      "job": 78817427634,
      "time": 89,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7327187441"
    },
    {
      "job": 78816853945,
      "time": 207,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7327157382"
    },
    {
      "job": 78817427614,
      "time": 99,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7327191338"
    },
    {
      "job": 78817427675,
      "time": 81,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7327185409"
    },
    {
      "job": 78817427647,
      "time": 86,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7327187033"
    },
    {
      "job": 78817427677,
      "time": 90,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7327188243"
    }
  ],
  "_buildurl": "https://github.com/r-universe/ggrothendieck/actions/runs/26744613427",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/ggrothendieck/sqldf",
  "_commit": {
    "id": "68a9562fe204a20aea3fc001ac364b5fa68ca94c",
    "author": "G. Grothendieck <ggrothendieck@gmail.com>",
    "committer": "G. Grothendieck <ggrothendieck@gmail.com>",
    "message": "Version 0.4-12\n",
    "time": 1769799046
  },
  "_maintainer": {
    "name": "G. Grothendieck",
    "email": "ggrothendieck@gmail.com",
    "login": "ggrothendieck",
    "description": "",
    "uuid": 7840510
  },
  "_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
    }
  ],
  "_tags": [],
  "_stars": 252,
  "_contributors": [
    {
      "user": "ggrothendieck",
      "count": 15,
      "uuid": 7840510
    },
    {
      "user": "ajdamico",
      "count": 1,
      "uuid": 216807
    },
    {
      "user": "darentsai",
      "count": 1,
      "uuid": 36108216
    },
    {
      "user": "eciardullo",
      "count": 1,
      "uuid": 64991969
    },
    {
      "user": "wibeasley",
      "count": 1,
      "uuid": 1372890
    }
  ],
  "_userbio": {
    "uuid": 7840510,
    "type": "user",
    "name": "ggrothendieck"
  },
  "_downloads": {
    "count": 23161,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sqldf"
  },
  "_mentions": 25,
  "_devurl": "https://github.com/ggrothendieck/sqldf",
  "_searchresults": 9088,
  "_rbuild": "4.6.0",
  "_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.485048649142911,
  "_indexed": true,
  "_nocasepkg": "sqldf",
  "_universes": [
    "ggrothendieck"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.4-12",
      "date": "2026-06-01T08:50:51.000Z",
      "distro": "noble",
      "commit": "68a9562fe204a20aea3fc001ac364b5fa68ca94c",
      "fileid": "07bf37ddf281d7c9ba90c243b160c99a90f69538a4ab107748fb3a8032fb582b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ggrothendieck/actions/runs/26744613427"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "0.4-12",
      "date": "2026-06-01T08:50:57.000Z",
      "distro": "noble",
      "commit": "68a9562fe204a20aea3fc001ac364b5fa68ca94c",
      "fileid": "b1b713a8f7a7012577dea64497b46d5967f18e88b28c943e48e0802d9841eddc",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ggrothendieck/actions/runs/26744613427"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.4-12",
      "date": "2026-06-01T08:50:46.000Z",
      "commit": "68a9562fe204a20aea3fc001ac364b5fa68ca94c",
      "fileid": "01d5051b6e456d94822482bbe6a7940d8ba067ec9137765b3bac29c3100faf7e",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ggrothendieck/actions/runs/26744613427"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "0.4-12",
      "date": "2026-06-01T08:50:26.000Z",
      "commit": "68a9562fe204a20aea3fc001ac364b5fa68ca94c",
      "fileid": "dc11dea99245b475833767bb10e94b6d758bcf10b3deca0c587339855242e618",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ggrothendieck/actions/runs/26744613427"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.4-12",
      "date": "2026-06-01T08:50:56.000Z",
      "commit": "68a9562fe204a20aea3fc001ac364b5fa68ca94c",
      "fileid": "20fdca603fd05ef46b083514dfbc7373988cc79e7f4cdb71b23396b4600b9d93",
      "status": "success",
      "buildurl": "https://github.com/r-universe/ggrothendieck/actions/runs/26744613427"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.4-12",
      "date": "2026-06-01T08:50:12.000Z",
      "commit": "68a9562fe204a20aea3fc001ac364b5fa68ca94c",
      "fileid": "195e85d1f495ebdc199af790914fc55fc40e35335d18eb4a6f0fde835888513a",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ggrothendieck/actions/runs/26744613427"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.4-12",
      "date": "2026-06-01T08:50:19.000Z",
      "commit": "68a9562fe204a20aea3fc001ac364b5fa68ca94c",
      "fileid": "f81693a6a7a74896e4d8f1ce3f902c011178d3a8bb37390ff7ae233071ff697f",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ggrothendieck/actions/runs/26744613427"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "0.4-12",
      "date": "2026-06-01T08:50:22.000Z",
      "commit": "68a9562fe204a20aea3fc001ac364b5fa68ca94c",
      "fileid": "9b1870322436d32f4ae276840193f48d816724e5b06ba28b1151096d4f01d6a9",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ggrothendieck/actions/runs/26744613427"
    }
  ]
}