{
  "_id": "6a498d7b6d67900babdfadfe",
  "Package": "rqdatatable",
  "Type": "Package",
  "Title": "'rquery' for 'data.table'",
  "Version": "1.3.3",
  "Date": "2023-08-19",
  "Authors@R": "c(\nperson(\"John\", \"Mount\", email = \"jmount@win-vector.com\", role = c(\"aut\", \"cre\")),\nperson(family = \"Win-Vector LLC\", role = c(\"cph\"))\n)",
  "Maintainer": "John Mount <jmount@win-vector.com>",
  "Description": "Implements the 'rquery' piped Codd-style query algebra\nusing 'data.table'.  This allows for a high-speed in memory\nimplementation of Codd-style data manipulation tools.",
  "URL": "https://github.com/WinVector/rqdatatable/,\nhttps://winvector.github.io/rqdatatable/",
  "BugReports": "https://github.com/WinVector/rqdatatable/issues",
  "License": "GPL-2 | GPL-3",
  "Encoding": "UTF-8",
  "ByteCompile": "true",
  "VignetteBuilder": "knitr",
  "RoxygenNote": "7.2.3",
  "Repository": "https://winvector.r-universe.dev",
  "Date/Publication": "2023-08-20 05:22:36 UTC",
  "RemoteUrl": "https://github.com/winvector/rqdatatable",
  "RemoteRef": "HEAD",
  "RemoteSha": "66838f888aad1373012428bc68eb306de8d8917d",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-06-22 09:46:37 UTC",
    "User": "root"
  },
  "Author": "John Mount [aut, cre],\nWin-Vector LLC [cph]",
  "_user": "winvector",
  "_type": "src",
  "_file": "rqdatatable_1.3.3.tar.gz",
  "_fileid": "https://r2.ropensci.org/589a25d9a3f274370344794237ed150bd8c7171ce020359d0271b188d5b8f9de",
  "_filesize": 635373,
  "_sha256": "589a25d9a3f274370344794237ed150bd8c7171ce020359d0271b188d5b8f9de",
  "_expires": "2026-10-12T22:47:21.000Z",
  "_created": "2026-06-22T09:46:37.000Z",
  "_published": "2026-07-04T22:47:23.499Z",
  "_jobs": [
    {
      "job": 85173306200,
      "time": 120,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7788746904"
    },
    {
      "job": 85173306116,
      "time": 112,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7788744412"
    },
    {
      "job": 85173306227,
      "time": 81,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7788947930"
    },
    {
      "job": 85173306098,
      "time": 110,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7788932363"
    },
    {
      "job": 85173305930,
      "time": 661,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7788702545"
    },
    {
      "job": 85173306036,
      "time": 106,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7788741542"
    },
    {
      "job": 85173306125,
      "time": 84,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7788733771"
    },
    {
      "job": 85173306195,
      "time": 75,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7788732123"
    },
    {
      "job": 85173306076,
      "time": 74,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7788730254"
    }
  ],
  "_host": "GitHub-Actions",
  "_buildurl": "https://github.com/r-universe/winvector/actions/runs/27943402726",
  "_status": "success",
  "_upstream": "https://github.com/winvector/rqdatatable",
  "_commit": {
    "id": "66838f888aad1373012428bc68eb306de8d8917d",
    "author": "John Mount <jmount@win-vector.com>",
    "committer": "John Mount <jmount@win-vector.com>",
    "message": "finish checks\n",
    "time": 1692508956
  },
  "_maintainer": {
    "name": "John Mount",
    "email": "jmount@win-vector.com",
    "login": "johnmount",
    "description": "",
    "uuid": 4275344
  },
  "_distro": "noble",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 3.4.0",
      "role": "Depends"
    },
    {
      "package": "wrapr",
      "version": ">= 2.0.9",
      "role": "Depends"
    },
    {
      "package": "rquery",
      "version": ">= 1.4.9",
      "role": "Depends"
    },
    {
      "package": "data.table",
      "version": ">= 1.12.2",
      "role": "Imports"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "DBI",
      "role": "Suggests"
    },
    {
      "package": "RSQLite",
      "role": "Suggests"
    },
    {
      "package": "parallel",
      "role": "Suggests"
    },
    {
      "package": "tinytest",
      "role": "Suggests"
    }
  ],
  "_owner": "winvector",
  "_selfowned": true,
  "_usedby": 2,
  "_updates": [],
  "_tags": [],
  "_stars": 38,
  "_contributors": [
    {
      "user": "johnmount",
      "count": 406,
      "uuid": 4275344
    }
  ],
  "_userbio": {
    "uuid": 1242554,
    "type": "organization",
    "name": "Win Vector LLC",
    "followers": 53,
    "description": "Expert data science training and consulting."
  },
  "_downloads": {
    "count": 3607,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/rqdatatable"
  },
  "_devurl": "https://github.com/winvector/rqdatatable",
  "_pkgdown": "https://winvector.github.io/rqdatatable/",
  "_searchresults": 121,
  "_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/rqdatatable.html",
    "manual.pdf"
  ],
  "_homeurl": "https://github.com/winvector/rqdatatable",
  "_realowner": "winvector",
  "_cranurl": true,
  "_releases": [
    {
      "version": "0.1.0",
      "date": "2018-06-19"
    },
    {
      "version": "0.1.1",
      "date": "2018-06-27"
    },
    {
      "version": "0.1.2",
      "date": "2018-07-09"
    },
    {
      "version": "0.1.3",
      "date": "2018-07-29"
    },
    {
      "version": "0.1.4",
      "date": "2018-08-18"
    },
    {
      "version": "1.0.0",
      "date": "2018-09-10"
    },
    {
      "version": "1.1.1",
      "date": "2018-09-20"
    },
    {
      "version": "1.1.2",
      "date": "2018-12-17"
    },
    {
      "version": "1.1.3",
      "date": "2019-02-17"
    },
    {
      "version": "1.1.4",
      "date": "2019-02-25"
    },
    {
      "version": "1.1.5",
      "date": "2019-04-25"
    },
    {
      "version": "1.1.6",
      "date": "2019-05-14"
    },
    {
      "version": "1.1.7",
      "date": "2019-05-15"
    },
    {
      "version": "1.1.8",
      "date": "2019-06-01"
    },
    {
      "version": "1.1.9",
      "date": "2019-07-04"
    },
    {
      "version": "1.2.0",
      "date": "2019-08-19"
    },
    {
      "version": "1.2.2",
      "date": "2019-09-14"
    },
    {
      "version": "1.2.3",
      "date": "2019-10-24"
    },
    {
      "version": "1.2.4",
      "date": "2019-11-12"
    },
    {
      "version": "1.2.5",
      "date": "2020-01-12"
    },
    {
      "version": "1.2.6",
      "date": "2020-01-29"
    },
    {
      "version": "1.2.7",
      "date": "2020-02-11"
    },
    {
      "version": "1.2.8",
      "date": "2020-08-12"
    },
    {
      "version": "1.2.9",
      "date": "2020-10-17"
    },
    {
      "version": "1.3.0",
      "date": "2021-06-12"
    },
    {
      "version": "1.3.1",
      "date": "2022-01-22"
    },
    {
      "version": "1.3.2",
      "date": "2023-08-14"
    },
    {
      "version": "1.3.3",
      "date": "2023-08-21"
    }
  ],
  "_exports": [
    "as.data.table",
    "ex_data_table",
    "ex_data_table_parallel",
    "ex_data_table_step",
    "layout_to_blocks_data_table",
    "layout_to_rowrecs_data_table",
    "make_dt_lookup_by_column",
    "rbindlist_data_table",
    "rq_df_funciton_node",
    "rq_df_grouped_funciton_node",
    "set_rqdatatable_as_executor"
  ],
  "_help": [
    {
      "page": "rqdatatable-package",
      "title": "'rqdatatable': Relational Query Generator for Data Manipulation Implemented by data.table",
      "topics": [
        "rqdatatable-package",
        "rqdatatable"
      ]
    },
    {
      "page": "ex_data_table",
      "title": "Execute an 'rquery' pipeline with 'data.table' sources.",
      "topics": [
        "ex_data_table"
      ]
    },
    {
      "page": "ex_data_table_parallel",
      "title": "Execute an 'rquery' pipeline with 'data.table' in parallel.",
      "topics": [
        "ex_data_table_parallel"
      ]
    },
    {
      "page": "ex_data_table_step.default",
      "title": "default non-impementation.",
      "topics": [
        "ex_data_table_step.default"
      ]
    },
    {
      "page": "ex_data_table_step.relop_drop_columns",
      "title": "Implement drop columns.",
      "topics": [
        "ex_data_table_step.relop_drop_columns"
      ]
    },
    {
      "page": "ex_data_table_step.relop_extend",
      "title": "Implement extend/assign operator.",
      "topics": [
        "ex_data_table_step.relop_extend"
      ]
    },
    {
      "page": "ex_data_table_step.relop_natural_join",
      "title": "Natural join.",
      "topics": [
        "ex_data_table_step.relop_natural_join"
      ]
    },
    {
      "page": "ex_data_table_step.relop_non_sql",
      "title": "Direct non-sql (function) node, not implemented for 'data.table' case.",
      "topics": [
        "ex_data_table_step.relop_non_sql"
      ]
    },
    {
      "page": "ex_data_table_step.relop_null_replace",
      "title": "Replace NAs.",
      "topics": [
        "ex_data_table_step.relop_null_replace"
      ]
    },
    {
      "page": "ex_data_table_step.relop_order_expr",
      "title": "Order rows by expression.",
      "topics": [
        "ex_data_table_step.relop_order_expr"
      ]
    },
    {
      "page": "ex_data_table_step.relop_orderby",
      "title": "Reorder rows.",
      "topics": [
        "ex_data_table_step.relop_orderby"
      ]
    },
    {
      "page": "ex_data_table_step.relop_project",
      "title": "Implement projection operator.",
      "topics": [
        "ex_data_table_step.relop_project"
      ]
    },
    {
      "page": "ex_data_table_step.relop_rename_columns",
      "title": "Rename columns.",
      "topics": [
        "ex_data_table_step.relop_rename_columns"
      ]
    },
    {
      "page": "ex_data_table_step.relop_select_columns",
      "title": "Implement drop columns.",
      "topics": [
        "ex_data_table_step.relop_select_columns"
      ]
    },
    {
      "page": "ex_data_table_step.relop_select_rows",
      "title": "Select rows by condition.",
      "topics": [
        "ex_data_table_step.relop_select_rows"
      ]
    },
    {
      "page": "ex_data_table_step.relop_set_indicator",
      "title": "Implement set_indicatoroperator.",
      "topics": [
        "ex_data_table_step.relop_set_indicator"
      ]
    },
    {
      "page": "ex_data_table_step.relop_sql",
      "title": "Direct sql node.",
      "topics": [
        "ex_data_table_step.relop_sql"
      ]
    },
    {
      "page": "ex_data_table_step.relop_table_source",
      "title": "Build a data source description.",
      "topics": [
        "ex_data_table_step.relop_table_source"
      ]
    },
    {
      "page": "ex_data_table_step.relop_theta_join",
      "title": "Theta join (database implementation).",
      "topics": [
        "ex_data_table_step.relop_theta_join"
      ]
    },
    {
      "page": "ex_data_table_step.relop_unionall",
      "title": "Bind tables together by rows.",
      "topics": [
        "ex_data_table_step.relop_unionall"
      ]
    },
    {
      "page": "make_dt_lookup_by_column",
      "title": "Lookup by column function factory.",
      "topics": [
        "make_dt_lookup_by_column"
      ]
    },
    {
      "page": "rq_df_funciton_node",
      "title": "Helper to build data.table capable non-sql nodes.",
      "topics": [
        "rq_df_funciton_node"
      ]
    },
    {
      "page": "rq_df_grouped_funciton_node",
      "title": "Helper to build data.table capable non-sql nodes.",
      "topics": [
        "rq_df_grouped_funciton_node"
      ]
    },
    {
      "page": "set_rqdatatable_as_executor",
      "title": "Set rqdatatable package as default rquery executor",
      "topics": [
        "set_rqdatatable_as_executor"
      ]
    }
  ],
  "_readme": "https://github.com/winvector/rqdatatable/raw/HEAD/README.md",
  "_rundeps": [
    "data.table",
    "rquery",
    "wrapr"
  ],
  "_vignettes": [
    {
      "source": "GroupedSampling.Rmd",
      "filename": "GroupedSampling.html",
      "title": "Grouped Sampling",
      "author": "John Mount",
      "engine": "knitr::rmarkdown",
      "headings": [],
      "created": "2018-06-14 15:28:20",
      "modified": "2018-06-14 17:01:00",
      "commits": 3
    },
    {
      "source": "logisticexample.Rmd",
      "filename": "logisticexample.html",
      "title": "Logistic Example",
      "author": "John Mount",
      "engine": "knitr::rmarkdown",
      "headings": [],
      "created": "2018-05-30 00:52:09",
      "modified": "2022-01-22 16:18:50",
      "commits": 8
    },
    {
      "source": "R_mapping.Rmd",
      "filename": "R_mapping.html",
      "title": "R mapping",
      "author": "John Mount",
      "engine": "knitr::rmarkdown",
      "headings": [],
      "created": "2019-06-22 18:55:09",
      "modified": "2019-06-23 22:23:16",
      "commits": 4
    }
  ],
  "_score": 8.173957618690949,
  "_indexed": true,
  "_nocasepkg": "rqdatatable",
  "_universes": [
    "winvector",
    "johnmount"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.3.3",
      "date": "2026-06-22T09:48:40.000Z",
      "distro": "noble",
      "commit": "66838f888aad1373012428bc68eb306de8d8917d",
      "fileid": "https://r2.ropensci.org/7de2c84521e5206340eb727ab6ae1a64df9c3220999ce72c90c7f33aa0623e82",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/winvector/actions/runs/27943402726"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "1.3.3",
      "date": "2026-06-22T09:48:35.000Z",
      "distro": "noble",
      "commit": "66838f888aad1373012428bc68eb306de8d8917d",
      "fileid": "https://r2.ropensci.org/f0c4eb322f9383523980863dd2bf7b162c657904e338400118478a5a320abeb6",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/winvector/actions/runs/27943402726"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.3.3",
      "date": "2026-06-22T09:57:54.000Z",
      "commit": "66838f888aad1373012428bc68eb306de8d8917d",
      "fileid": "https://r2.ropensci.org/15a27de129bd26a3c600f385fbdd6218639e5e80cb5e5f56a59591e75045d610",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/winvector/actions/runs/27943402726"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "1.3.3",
      "date": "2026-06-22T09:57:08.000Z",
      "commit": "66838f888aad1373012428bc68eb306de8d8917d",
      "fileid": "https://r2.ropensci.org/624499e1ccfc97e8fdcf42e5b0e62a4e50f9f6feebce8b4bf779688665d0c5d2",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/winvector/actions/runs/27943402726"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "1.3.3",
      "date": "2026-06-22T09:48:42.000Z",
      "commit": "66838f888aad1373012428bc68eb306de8d8917d",
      "fileid": "https://r2.ropensci.org/4b5d27f4d47b845fa1aa7bdfc4f56874f60afbcf1a640c868534c907327e92a8",
      "status": "success",
      "buildurl": "https://github.com/r-universe/winvector/actions/runs/27943402726"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.3.3",
      "date": "2026-06-22T09:47:59.000Z",
      "commit": "66838f888aad1373012428bc68eb306de8d8917d",
      "fileid": "https://r2.ropensci.org/fb03b8e975b4bd354b4591c788e706a37d9a2b55e57932076db1c3945253f9f4",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/winvector/actions/runs/27943402726"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "1.3.3",
      "date": "2026-06-22T09:47:52.000Z",
      "commit": "66838f888aad1373012428bc68eb306de8d8917d",
      "fileid": "https://r2.ropensci.org/e922162d38cc8d79dfcc2cdfeaffd85a73f73f5cb791c1987ec88e6a9cb7d02d",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/winvector/actions/runs/27943402726"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "1.3.3",
      "date": "2026-06-22T09:47:49.000Z",
      "commit": "66838f888aad1373012428bc68eb306de8d8917d",
      "fileid": "https://r2.ropensci.org/b832172ea852453e3bcaebc7b9f2a2627504f94f02e221df4a7cccca6f374e2e",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/winvector/actions/runs/27943402726"
    }
  ]
}