{
  "_id": "6a116203acfb0bcc41cee3ed",
  "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-05-23 08:10:08 UTC",
    "User": "root"
  },
  "Author": "John Mount [aut, cre],\nWin-Vector LLC [cph]",
  "MD5sum": "e0a35082a815e619918a33f365b21dca",
  "_user": "winvector",
  "_type": "src",
  "_file": "rqdatatable_1.3.3.tar.gz",
  "_fileid": "9f857da5d43ec3f5d80f5f174a38143798791b58212598af27f82737eb6c382a",
  "_filesize": 635350,
  "_sha256": "9f857da5d43ec3f5d80f5f174a38143798791b58212598af27f82737eb6c382a",
  "_created": "2026-05-23T08:10:08.000Z",
  "_published": "2026-05-23T08:14:59.851Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 77508437235,
      "time": 117,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7175546608"
    },
    {
      "job": 77508437231,
      "time": 98,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7175544692"
    },
    {
      "job": 77508437232,
      "time": 102,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7175545091"
    },
    {
      "job": 77508437237,
      "time": 136,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7175548037"
    },
    {
      "job": 77508292436,
      "time": 155,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7175535614"
    },
    {
      "job": 77508437230,
      "time": 97,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7175544733"
    },
    {
      "job": 77508437244,
      "time": 224,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7175556200"
    },
    {
      "job": 77508437240,
      "time": 258,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7175559943"
    },
    {
      "job": 77508437241,
      "time": 190,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7175553048"
    }
  ],
  "_buildurl": "https://github.com/r-universe/winvector/actions/runs/26327706559",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_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
  },
  "_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",
    "description": "Expert data science training and consulting."
  },
  "_downloads": {
    "count": 4207,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/rqdatatable"
  },
  "_devurl": "https://github.com/winvector/rqdatatable",
  "_pkgdown": "https://winvector.github.io/rqdatatable/",
  "_searchresults": 127,
  "_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.261802339029089,
  "_indexed": true,
  "_nocasepkg": "rqdatatable",
  "_universes": [
    "winvector",
    "johnmount"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.3.3",
      "date": "2026-05-23T08:12:04.000Z",
      "distro": "noble",
      "commit": "66838f888aad1373012428bc68eb306de8d8917d",
      "fileid": "2647a17d854c1b6c8b6399c86f0b602cd96b8ff87dbbb0897ff5381a385a354f",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/winvector/actions/runs/26327706559"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "1.3.3",
      "date": "2026-05-23T08:11:47.000Z",
      "distro": "noble",
      "commit": "66838f888aad1373012428bc68eb306de8d8917d",
      "fileid": "8134333b4139c2b6e7241faf1e3ae79f3ee1b7d2d7dd3d436c9e75ef11a937f3",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/winvector/actions/runs/26327706559"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.3.3",
      "date": "2026-05-23T08:11:54.000Z",
      "commit": "66838f888aad1373012428bc68eb306de8d8917d",
      "fileid": "35cfe479f70beb62cf920afccf8eed1faef674791c4e2eea9e63b0af35a89e96",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/winvector/actions/runs/26327706559"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "1.3.3",
      "date": "2026-05-23T08:12:24.000Z",
      "commit": "66838f888aad1373012428bc68eb306de8d8917d",
      "fileid": "f8524946a53270978a700f9861b191c7429c0a144e02d663dddeacfe1d5bbb1f",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/winvector/actions/runs/26327706559"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "1.3.3",
      "date": "2026-05-23T08:12:00.000Z",
      "commit": "66838f888aad1373012428bc68eb306de8d8917d",
      "fileid": "bb326549505c58553dff715f6768dcae800555420ccfc4e3e01777587a28730e",
      "status": "success",
      "buildurl": "https://github.com/r-universe/winvector/actions/runs/26327706559"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.3.3",
      "date": "2026-05-23T08:13:45.000Z",
      "commit": "66838f888aad1373012428bc68eb306de8d8917d",
      "fileid": "ab91a50db519545e31c379bfed8c6cd3a675b98865e7b867acef26e64586942a",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/winvector/actions/runs/26327706559"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "1.3.3",
      "date": "2026-05-23T08:14:25.000Z",
      "commit": "66838f888aad1373012428bc68eb306de8d8917d",
      "fileid": "64f0e94c565eb67b26017107658c1731399e4050a2af33a15e88da0b0657bedc",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/winvector/actions/runs/26327706559"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "1.3.3",
      "date": "2026-05-23T08:13:10.000Z",
      "commit": "66838f888aad1373012428bc68eb306de8d8917d",
      "fileid": "6f489ede008edc7479596f75936fb1191ef21281ee879a3e8c7c6b92bc6b6c1a",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/winvector/actions/runs/26327706559"
    }
  ]
}