{
  "_id": "6a12a444acfb0bcc41d12aab",
  "Package": "dtplyr",
  "Title": "Data Table Back-End for 'dplyr'",
  "Version": "1.3.3.9000",
  "Authors@R": "c(\nperson(\"Hadley\", \"Wickham\", , \"hadley@posit.co\", role = c(\"cre\", \"aut\")),\nperson(\"Maximilian\", \"Girlich\", role = \"aut\"),\nperson(\"Mark\", \"Fairbanks\", role = \"aut\"),\nperson(\"Ryan\", \"Dickerson\", role = \"aut\"),\nperson(\"Posit Software, PBC\", role = c(\"cph\", \"fnd\"))\n)",
  "Description": "Provides a data.table backend for 'dplyr'. The goal of\n'dtplyr' is to allow you to write 'dplyr' code that is\nautomatically translated to the equivalent, but usually much\nfaster, data.table code.",
  "License": "MIT + file LICENSE",
  "URL": "https://dtplyr.tidyverse.org, https://github.com/tidyverse/dtplyr",
  "BugReports": "https://github.com/tidyverse/dtplyr/issues",
  "VignetteBuilder": "knitr",
  "Config/Needs/website": "tidyverse/tidytemplate",
  "Config/testthat/edition": "3",
  "Encoding": "UTF-8",
  "Roxygen": "{library(tidyr); list(markdown = TRUE)}",
  "RoxygenNote": "7.3.3",
  "Repository": "https://tidyverse.r-universe.dev",
  "Date/Publication": "2026-02-11 13:32:47 UTC",
  "RemoteUrl": "https://github.com/tidyverse/dtplyr",
  "RemoteRef": "HEAD",
  "RemoteSha": "bffe46e664d62021e47251c158c9f02c4cd30400",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-05-24 06:50:26 UTC",
    "User": "root"
  },
  "Author": "Hadley Wickham [cre, aut],\nMaximilian Girlich [aut],\nMark Fairbanks [aut],\nRyan Dickerson [aut],\nPosit Software, PBC [cph, fnd]",
  "Maintainer": "Hadley Wickham <hadley@posit.co>",
  "MD5sum": "58f4e9dc2bfcf5e54ded8660017f1d32",
  "_user": "tidyverse",
  "_type": "src",
  "_file": "dtplyr_1.3.3.9000.tar.gz",
  "_fileid": "7b7c946c37ebefa7a60c5351ce2b13115ebd0596e16c9c20370cdb9344ba2777",
  "_filesize": 390158,
  "_sha256": "7b7c946c37ebefa7a60c5351ce2b13115ebd0596e16c9c20370cdb9344ba2777",
  "_created": "2026-05-24T06:50:26.000Z",
  "_published": "2026-05-24T07:09:56.593Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 77578453804,
      "time": 144,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7183025537"
    },
    {
      "job": 77578453811,
      "time": 137,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7183024833"
    },
    {
      "job": 77578453815,
      "time": 95,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7183130109"
    },
    {
      "job": 77578453826,
      "time": 113,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7183127574"
    },
    {
      "job": 77578270800,
      "time": 203,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7183009682"
    },
    {
      "job": 77578453797,
      "time": 101,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7183021218"
    },
    {
      "job": 77578453834,
      "time": 103,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7183021436"
    },
    {
      "job": 77578453803,
      "time": 108,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7183021922"
    },
    {
      "job": 77578453829,
      "time": 92,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7183020197"
    }
  ],
  "_buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354364592",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/tidyverse/dtplyr",
  "_commit": {
    "id": "bffe46e664d62021e47251c158c9f02c4cd30400",
    "author": "Hadley Wickham <h.wickham@gmail.com>",
    "committer": "Hadley Wickham <h.wickham@gmail.com>",
    "message": "Increment version number to 1.3.3.9000\n",
    "time": 1770816767
  },
  "_maintainer": {
    "name": "Hadley Wickham",
    "email": "hadley@posit.co",
    "login": "hadley",
    "bluesky": "@hadley.nz",
    "description": "Chief Scientist at @posit-pbc",
    "uuid": 4196
  },
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 4.0",
      "role": "Depends"
    },
    {
      "package": "cli",
      "version": ">= 3.4.0",
      "role": "Imports"
    },
    {
      "package": "data.table",
      "version": ">= 1.13.0",
      "role": "Imports"
    },
    {
      "package": "dplyr",
      "version": ">= 1.1.0",
      "role": "Imports"
    },
    {
      "package": "glue",
      "role": "Imports"
    },
    {
      "package": "lifecycle",
      "role": "Imports"
    },
    {
      "package": "rlang",
      "version": ">= 1.0.4",
      "role": "Imports"
    },
    {
      "package": "tibble",
      "role": "Imports"
    },
    {
      "package": "tidyselect",
      "version": ">= 1.2.0",
      "role": "Imports"
    },
    {
      "package": "vctrs",
      "version": ">= 0.4.1",
      "role": "Imports"
    },
    {
      "package": "bench",
      "role": "Suggests"
    },
    {
      "package": "covr",
      "role": "Suggests"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 3.1.2",
      "role": "Suggests"
    },
    {
      "package": "tidyr",
      "version": ">= 1.1.0",
      "role": "Suggests"
    },
    {
      "package": "waldo",
      "version": ">= 0.3.1",
      "role": "Suggests"
    }
  ],
  "_owner": "tidyverse",
  "_selfowned": true,
  "_usedby": 151,
  "_updates": [
    {
      "week": "2025-36",
      "n": 3
    },
    {
      "week": "2025-37",
      "n": 3
    },
    {
      "week": "2025-48",
      "n": 1
    },
    {
      "week": "2026-07",
      "n": 6
    }
  ],
  "_tags": [
    {
      "name": "v1.3.2",
      "date": "2025-09-09"
    },
    {
      "name": "v1.3.3",
      "date": "2026-02-10"
    }
  ],
  "_topics": [
    "datatable",
    "dplyr"
  ],
  "_stars": 675,
  "_contributors": [
    {
      "user": "hadley",
      "count": 1102,
      "uuid": 4196
    },
    {
      "user": "markfairbanks",
      "count": 317,
      "uuid": 28766000
    },
    {
      "user": "romainfrancois",
      "count": 261,
      "uuid": 2625526
    },
    {
      "user": "eutwt",
      "count": 46,
      "uuid": 11261404
    },
    {
      "user": "lionel-",
      "count": 26,
      "uuid": 4465050
    },
    {
      "user": "mgirlich",
      "count": 21,
      "uuid": 18258854
    },
    {
      "user": "christophsax",
      "count": 16,
      "uuid": 1390827
    },
    {
      "user": "krlmlr",
      "count": 9,
      "uuid": 1741643
    },
    {
      "user": "batpigandme",
      "count": 7,
      "uuid": 831732
    },
    {
      "user": "hannes",
      "count": 7,
      "uuid": 227792
    },
    {
      "user": "michaelchirico",
      "count": 6,
      "uuid": 7606389
    },
    {
      "user": "kevinushey",
      "count": 5,
      "uuid": 1976582
    },
    {
      "user": "jimhester",
      "count": 4,
      "uuid": 205275
    },
    {
      "user": "arunsrinivasan",
      "count": 3,
      "uuid": 3102045
    },
    {
      "user": "lindbrook",
      "count": 3,
      "uuid": 6076793
    },
    {
      "user": "davisvaughan",
      "count": 3,
      "uuid": 19150088
    },
    {
      "user": "uribo",
      "count": 2,
      "uuid": 228649
    },
    {
      "user": "smingerson",
      "count": 2,
      "uuid": 31328867
    },
    {
      "user": "ilarischeinin",
      "count": 2,
      "uuid": 2540173
    },
    {
      "user": "pimentel",
      "count": 2,
      "uuid": 530217
    },
    {
      "user": "earino",
      "count": 2,
      "uuid": 3258
    },
    {
      "user": "leondutoit",
      "count": 1,
      "uuid": 1214931
    },
    {
      "user": "hs3180",
      "count": 1,
      "uuid": 1643451
    },
    {
      "user": "xiaodaigh",
      "count": 1,
      "uuid": 4497189
    },
    {
      "user": "tmastny",
      "count": 1,
      "uuid": 20732748
    },
    {
      "user": "joshuasturm",
      "count": 1,
      "uuid": 22535419
    },
    {
      "user": "cosinequanon",
      "count": 1,
      "uuid": 1226424
    },
    {
      "user": "richpauloo",
      "count": 1,
      "uuid": 10336683
    },
    {
      "user": "psanker",
      "count": 1,
      "uuid": 868399
    },
    {
      "user": "jonthegeek",
      "count": 1,
      "uuid": 33983824
    },
    {
      "user": "jeroenjanssens",
      "count": 1,
      "uuid": 1368256
    },
    {
      "user": "jl5000",
      "count": 1,
      "uuid": 26303390
    },
    {
      "user": "eibanez",
      "count": 1,
      "uuid": 438494
    },
    {
      "user": "craigcitro",
      "count": 1,
      "uuid": 468559
    },
    {
      "user": "alyst",
      "count": 1,
      "uuid": 348591
    }
  ],
  "_userbio": {
    "uuid": 22032646,
    "type": "organization",
    "name": "tidyverse",
    "description": "The tidyverse is a collection of R packages that share common principles and are designed to work together seamlessly"
  },
  "_downloads": {
    "count": 422992,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/dtplyr"
  },
  "_devurl": "https://github.com/tidyverse/dtplyr",
  "_pkgdown": "https://dtplyr.tidyverse.org",
  "_searchresults": 2712,
  "_rbuild": "4.6.0",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/dtplyr.html",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "manual.pdf"
  ],
  "_homeurl": "https://github.com/tidyverse/dtplyr",
  "_realowner": "tidyverse",
  "_cranurl": true,
  "_releases": [
    {
      "version": "0.0.1",
      "date": "2016-06-27"
    },
    {
      "version": "0.0.2",
      "date": "2017-04-21"
    },
    {
      "version": "0.0.3",
      "date": "2019-02-25"
    },
    {
      "version": "1.0.0",
      "date": "2019-11-12"
    },
    {
      "version": "1.0.1",
      "date": "2020-01-23"
    },
    {
      "version": "1.1.0",
      "date": "2021-02-20"
    },
    {
      "version": "1.2.0",
      "date": "2021-12-05"
    },
    {
      "version": "1.2.1",
      "date": "2022-01-20"
    },
    {
      "version": "1.2.2",
      "date": "2022-08-20"
    },
    {
      "version": "1.3.0",
      "date": "2023-02-24"
    },
    {
      "version": "1.3.1",
      "date": "2023-03-22"
    },
    {
      "version": "1.3.2",
      "date": "2025-09-10"
    },
    {
      "version": "1.3.3",
      "date": "2026-02-16"
    }
  ],
  "_exports": [
    ".datatable.aware",
    "lazy_dt"
  ],
  "_help": [
    {
      "page": "arrange.dtplyr_step",
      "title": "Arrange rows by column values",
      "topics": [
        "arrange.dtplyr_step"
      ]
    },
    {
      "page": "collect.dtplyr_step",
      "title": "Force computation of a lazy data.table",
      "topics": [
        "as.data.frame.dtplyr_step",
        "as.data.table.dtplyr_step",
        "as_tibble.dtplyr_step",
        "collect.dtplyr_step",
        "compute.dtplyr_step"
      ]
    },
    {
      "page": "complete.dtplyr_step",
      "title": "Complete a data frame with missing combinations of data",
      "topics": [
        "complete.dtplyr_step"
      ]
    },
    {
      "page": "count.dtplyr_step",
      "title": "Count observations by group",
      "topics": [
        "count.dtplyr_step"
      ]
    },
    {
      "page": "distinct.dtplyr_step",
      "title": "Subset distinct/unique rows",
      "topics": [
        "distinct.dtplyr_step"
      ]
    },
    {
      "page": "drop_na.dtplyr_step",
      "title": "Drop rows containing missing values",
      "topics": [
        "drop_na.dtplyr_step"
      ]
    },
    {
      "page": "expand.dtplyr_step",
      "title": "Expand data frame to include all possible combinations of values.",
      "topics": [
        "expand.dtplyr_step"
      ]
    },
    {
      "page": "fill.dtplyr_step",
      "title": "Fill in missing values with previous or next value",
      "topics": [
        "fill.dtplyr_step"
      ]
    },
    {
      "page": "filter.dtplyr_step",
      "title": "Subset rows using column values",
      "topics": [
        "filter.dtplyr_step"
      ]
    },
    {
      "page": "group_by.dtplyr_step",
      "title": "Group and ungroup",
      "topics": [
        "group_by.dtplyr_step",
        "ungroup.dtplyr_step"
      ]
    },
    {
      "page": "group_modify.dtplyr_step",
      "title": "Apply a function to each group",
      "topics": [
        "group_map.dtplyr_step",
        "group_modify.dtplyr_step"
      ]
    },
    {
      "page": "head.dtplyr_step",
      "title": "Subset first or last rows",
      "topics": [
        "head.dtplyr_step",
        "tail.dtplyr_step"
      ]
    },
    {
      "page": "intersect.dtplyr_step",
      "title": "Set operations",
      "topics": [
        "intersect.dtplyr_step",
        "setdiff.dtplyr_step",
        "union.dtplyr_step",
        "union_all.dtplyr_step"
      ]
    },
    {
      "page": "lazy_dt",
      "title": "Create a \"lazy\" data.table for use with dplyr verbs",
      "topics": [
        "grouped_dt",
        "lazy_dt",
        "tbl_dt"
      ]
    },
    {
      "page": "left_join.dtplyr_step",
      "title": "Join data tables",
      "topics": [
        "left_join.dtplyr_step"
      ]
    },
    {
      "page": "mutate.dtplyr_step",
      "title": "Create and modify columns",
      "topics": [
        "mutate.dtplyr_step"
      ]
    },
    {
      "page": "nest.dtplyr_step",
      "title": "Nest",
      "topics": [
        "nest.dtplyr_step"
      ]
    },
    {
      "page": "pivot_longer.dtplyr_step",
      "title": "Pivot data from wide to long",
      "topics": [
        "pivot_longer.dtplyr_step"
      ]
    },
    {
      "page": "pivot_wider.dtplyr_step",
      "title": "Pivot data from long to wide",
      "topics": [
        "pivot_wider.dtplyr_step"
      ]
    },
    {
      "page": "reframe.dtplyr_step",
      "title": "Summarise each group to one row",
      "topics": [
        "reframe.dtplyr_step"
      ]
    },
    {
      "page": "relocate.dtplyr_step",
      "title": "Relocate variables using their names",
      "topics": [
        "relocate.dtplyr_step"
      ]
    },
    {
      "page": "rename.dtplyr_step",
      "title": "Rename columns using their names",
      "topics": [
        "rename.dtplyr_step",
        "rename_with.dtplyr_step"
      ]
    },
    {
      "page": "replace_na.dtplyr_step",
      "title": "Replace NAs with specified values",
      "topics": [
        "replace_na.dtplyr_step"
      ]
    },
    {
      "page": "select.dtplyr_step",
      "title": "Subset columns using their names",
      "topics": [
        "select.dtplyr_step"
      ]
    },
    {
      "page": "separate.dtplyr_step",
      "title": "Separate a character column into multiple columns with a regular expression or numeric locations",
      "topics": [
        "separate.dtplyr_step"
      ]
    },
    {
      "page": "slice.dtplyr_step",
      "title": "Subset rows using their positions",
      "topics": [
        "slice.dtplyr_step",
        "slice_head.dtplyr_step",
        "slice_max.dtplyr_step",
        "slice_min.dtplyr_step",
        "slice_tail.dtplyr_step"
      ]
    },
    {
      "page": "summarise.dtplyr_step",
      "title": "Summarise each group to one row",
      "topics": [
        "summarise.dtplyr_step"
      ]
    },
    {
      "page": "transmute.dtplyr_step",
      "title": "Create new columns, dropping old",
      "topics": [
        "transmute.dtplyr_step"
      ]
    },
    {
      "page": "unite.dtplyr_step",
      "title": "Unite multiple columns into one by pasting strings together.",
      "topics": [
        "unite.dtplyr_step"
      ]
    }
  ],
  "_pkglogo": "https://github.com/tidyverse/dtplyr/raw/HEAD/man/figures/logo.png",
  "_readme": "https://github.com/tidyverse/dtplyr/raw/HEAD/README.md",
  "_rundeps": [
    "cli",
    "data.table",
    "dplyr",
    "generics",
    "glue",
    "lifecycle",
    "magrittr",
    "pillar",
    "pkgconfig",
    "R6",
    "rlang",
    "tibble",
    "tidyselect",
    "utf8",
    "vctrs",
    "withr"
  ],
  "_vignettes": [
    {
      "source": "translation.Rmd",
      "filename": "translation.html",
      "title": "Translation",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Introduction",
        "The basics",
        "Simple verbs",
        "filter() and arrange()",
        "select(), summarise(), transmute()",
        "Other calls",
        "rename()",
        "distinct()",
        "Joins",
        "Set operations",
        "Grouping",
        "Combinations",
        "Copies",
        "Performance"
      ],
      "created": "2019-06-25 19:51:32",
      "modified": "2026-02-10 17:09:14",
      "commits": 26
    }
  ],
  "_score": 16.37753272643527,
  "_indexed": true,
  "_nocasepkg": "dtplyr",
  "_universes": [
    "tidyverse",
    "hadley"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.3.3.9000",
      "date": "2026-05-24T06:52:42.000Z",
      "distro": "noble",
      "commit": "bffe46e664d62021e47251c158c9f02c4cd30400",
      "fileid": "879229e1a5cea2d13841dd0e10c766e6b0a20e70f905ecbb61e3bc7459e9a596",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354364592"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "1.3.3.9000",
      "date": "2026-05-24T06:52:36.000Z",
      "distro": "noble",
      "commit": "bffe46e664d62021e47251c158c9f02c4cd30400",
      "fileid": "5c919932124745e1ab7c3599ba1b4151900b786153709162869c68ac1b702e9c",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354364592"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.3.3.9000",
      "date": "2026-05-24T07:09:18.000Z",
      "commit": "bffe46e664d62021e47251c158c9f02c4cd30400",
      "fileid": "c36eed978fd204a3050c84f6fac478191771a98f28eb2569c9631e09d8c6a2e5",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354364592"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "1.3.3.9000",
      "date": "2026-05-24T07:08:48.000Z",
      "commit": "bffe46e664d62021e47251c158c9f02c4cd30400",
      "fileid": "da603fd0d8b55ebddbc52f5199e17c505a1db51ae76807348c9e58b44607311d",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354364592"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "1.3.3.9000",
      "date": "2026-05-24T06:52:35.000Z",
      "commit": "bffe46e664d62021e47251c158c9f02c4cd30400",
      "fileid": "0f5b03d0a237ad329e946b81bd4a597b376b7c6ce4dc58c66420fff22913d787",
      "status": "success",
      "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354364592"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.3.3.9000",
      "date": "2026-05-24T06:51:49.000Z",
      "commit": "bffe46e664d62021e47251c158c9f02c4cd30400",
      "fileid": "05f3d8ab7c8a15582a3d0df55f8dc3729bbc0d26b2cf144c40417a3f27194cee",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354364592"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "1.3.3.9000",
      "date": "2026-05-24T06:51:55.000Z",
      "commit": "bffe46e664d62021e47251c158c9f02c4cd30400",
      "fileid": "5d7555516145eb925bb849e9242dc58612c227110ab1ac011b01e90b8806c724",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354364592"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "1.3.3.9000",
      "date": "2026-05-24T06:51:55.000Z",
      "commit": "bffe46e664d62021e47251c158c9f02c4cd30400",
      "fileid": "7b9268a6cc7a5c37e6aede89c8325f9af908cd3d477c34ddc894bff94e36d492",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354364592"
    }
  ]
}