{
  "_id": "6a60732114e95619b75d9c64",
  "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-07-22 07:34:10 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/0c09334e60a7ea0ec12ba47d746f8cec8325fc366c28cf8d06799afa0328e59e",
  "_filesize": 636100,
  "_sha256": "0c09334e60a7ea0ec12ba47d746f8cec8325fc366c28cf8d06799afa0328e59e",
  "_expires": "2026-10-30T07:37:03.000Z",
  "_created": "2026-07-22T07:34:10.000Z",
  "_published": "2026-07-22T07:37:05.303Z",
  "_jobs": [
    {
      "job": 88860546457,
      "time": 123,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "8521788292"
    },
    {
      "job": 88860546462,
      "time": 121,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "8521787564"
    },
    {
      "job": 88860546417,
      "time": 124,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "8521788308"
    },
    {
      "job": 88860546431,
      "time": 73,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "8521767978"
    },
    {
      "job": 88860017407,
      "time": 165,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "8521738826"
    },
    {
      "job": 88860546395,
      "time": 107,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "8521781688"
    },
    {
      "job": 88860546461,
      "time": 74,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "8521769213"
    },
    {
      "job": 88860546447,
      "time": 77,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "8521770435"
    },
    {
      "job": 88860546438,
      "time": 85,
      "config": "windows-release",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "8521772604"
    }
  ],
  "_host": "GitHub-Actions",
  "_buildurl": "https://github.com/r-universe/winvector/actions/runs/29900499656",
  "_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": "resolute",
  "_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": 1655,
    "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.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/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": 7.835609474484323,
  "_indexed": true,
  "_nocasepkg": "rqdatatable",
  "_universes": [
    "winvector",
    "johnmount"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.3.3",
      "date": "2026-07-22T07:36:11.000Z",
      "distro": "resolute",
      "commit": "66838f888aad1373012428bc68eb306de8d8917d",
      "fileid": "https://r2.ropensci.org/662860135689a9232d2881cfd06d25ed7247517de6f878da5c7ef09a28e27598",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/winvector/actions/runs/29900499656"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "1.3.3",
      "date": "2026-07-22T07:36:10.000Z",
      "distro": "resolute",
      "commit": "66838f888aad1373012428bc68eb306de8d8917d",
      "fileid": "https://r2.ropensci.org/564d18eec98829a92dc563f1e1e3111840cad6c43de8a540f5ca33dd211dfd5b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/winvector/actions/runs/29900499656"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.3.3",
      "date": "2026-07-22T07:36:06.000Z",
      "commit": "66838f888aad1373012428bc68eb306de8d8917d",
      "fileid": "https://r2.ropensci.org/e53fb133d288a4dbe1c0b7d93cac7da6a90d722921c3b6353823312cd393ede5",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/winvector/actions/runs/29900499656"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "1.3.3",
      "date": "2026-07-22T07:35:26.000Z",
      "commit": "66838f888aad1373012428bc68eb306de8d8917d",
      "fileid": "https://r2.ropensci.org/3541e94240874f385c59c7fe5f8573a38c7c5752efc5f7b54306adcfafb6a18c",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/winvector/actions/runs/29900499656"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "1.3.3",
      "date": "2026-07-22T07:36:10.000Z",
      "commit": "66838f888aad1373012428bc68eb306de8d8917d",
      "fileid": "https://r2.ropensci.org/b285c144176ba7d5cd0780fca83de49bffee53ffc93128d447fd51ae7b86b7ee",
      "status": "success",
      "buildurl": "https://github.com/r-universe/winvector/actions/runs/29900499656"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.3.3",
      "date": "2026-07-22T07:35:19.000Z",
      "commit": "66838f888aad1373012428bc68eb306de8d8917d",
      "fileid": "https://r2.ropensci.org/a61a55a48e4abb29db2938d71ed7081c89ee33cf805df2c289a4a33b6c97cbd3",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/winvector/actions/runs/29900499656"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "1.3.3",
      "date": "2026-07-22T07:35:23.000Z",
      "commit": "66838f888aad1373012428bc68eb306de8d8917d",
      "fileid": "https://r2.ropensci.org/69e7e069e21b2eed19814da3ee3deb3a01f9f0de39ea872f47441a5d44f92b85",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/winvector/actions/runs/29900499656"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "1.3.3",
      "date": "2026-07-22T07:35:26.000Z",
      "commit": "66838f888aad1373012428bc68eb306de8d8917d",
      "fileid": "https://r2.ropensci.org/ad01e5438b7e8abfdad3d6b7fcb530d6deb7aacd00f8d744a163392b22b96dd3",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/winvector/actions/runs/29900499656"
    }
  ]
}