{
  "_id": "6a36391a3efcd9bda43f9859",
  "Package": "tidyjson",
  "Title": "Tidy Complex 'JSON'",
  "Version": "0.3.3.1",
  "Authors@R": "c(\nperson(\"Jeremy\", \"Stanley\", , \"jeremy.stanley@gmail.com\", role = \"aut\"),\nperson(\"Cole\", \"Arendt\", , \"cole@benetist.com\", role = c(\"aut\", \"cre\"))\n)",
  "Description": "Turn complex 'JSON' data into tidy data frames.",
  "License": "MIT + file LICENSE",
  "URL": "https://github.com/colearendt/tidyjson",
  "BugReports": "https://github.com/colearendt/tidyjson/issues",
  "VignetteBuilder": "knitr",
  "Config/testthat/edition": "3",
  "Encoding": "UTF-8",
  "LazyData": "true",
  "RoxygenNote": "7.3.3",
  "Config/pak/sysreqs": "libicu-dev",
  "Repository": "https://colearendt.r-universe.dev",
  "Date/Publication": "2026-01-21 13:09:37 UTC",
  "RemoteUrl": "https://github.com/colearendt/tidyjson",
  "RemoteRef": "HEAD",
  "RemoteSha": "cc31aa795f8cc48c5a2a085cfcdc65b05cd5ebc8",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-06-20 06:50:24 UTC",
    "User": "root"
  },
  "Author": "Jeremy Stanley [aut],\nCole Arendt [aut, cre]",
  "Maintainer": "Cole Arendt <cole@benetist.com>",
  "MD5sum": "411517e09f37fb4df3ece114a0e8fc0c",
  "_user": "colearendt",
  "_type": "src",
  "_file": "tidyjson_0.3.3.1.tar.gz",
  "_fileid": "94bcc9f64711ce7b275f0b14d161056e5346eb206ee6c311449708be4556a340",
  "_filesize": 3242695,
  "_sha256": "94bcc9f64711ce7b275f0b14d161056e5346eb206ee6c311449708be4556a340",
  "_created": "2026-06-20T06:50:24.000Z",
  "_published": "2026-06-20T06:54:18.581Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 82463216576,
      "time": 158,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7762983647"
    },
    {
      "job": 82463216574,
      "time": 202,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7762989225"
    },
    {
      "job": 82463216572,
      "time": 82,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7762974826"
    },
    {
      "job": 82463216568,
      "time": 92,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7762976062"
    },
    {
      "job": 82462992259,
      "time": 232,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7762965163"
    },
    {
      "job": 82463216561,
      "time": 121,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7762979128"
    },
    {
      "job": 82463216584,
      "time": 112,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7762978264"
    },
    {
      "job": 82463216585,
      "time": 91,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7762975897"
    },
    {
      "job": 82463216577,
      "time": 96,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7762976363"
    }
  ],
  "_buildurl": "https://github.com/r-universe/colearendt/actions/runs/27863301628",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/colearendt/tidyjson",
  "_commit": {
    "id": "cc31aa795f8cc48c5a2a085cfcdc65b05cd5ebc8",
    "author": "Cole Arendt <cole.arendt@outlook.com>",
    "committer": "GitHub <noreply@github.com>",
    "message": "Merge pull request #154 from colearendt/v0.3.3-rc\n\nV0.3.3 rc",
    "time": 1769000977
  },
  "_maintainer": {
    "name": "Cole Arendt",
    "email": "cole@benetist.com"
  },
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 3.1.0",
      "role": "Depends"
    },
    {
      "package": "assertthat",
      "role": "Imports"
    },
    {
      "package": "dplyr",
      "version": ">= 1.0.0",
      "role": "Imports"
    },
    {
      "package": "jsonlite",
      "role": "Imports"
    },
    {
      "package": "magrittr",
      "role": "Imports"
    },
    {
      "package": "purrr",
      "role": "Imports"
    },
    {
      "package": "rlang",
      "role": "Imports"
    },
    {
      "package": "tibble",
      "role": "Imports"
    },
    {
      "package": "tidyr",
      "version": ">= 1.0.0",
      "role": "Imports"
    },
    {
      "package": "covr",
      "role": "Suggests"
    },
    {
      "package": "forcats",
      "role": "Suggests"
    },
    {
      "package": "ggplot2",
      "role": "Suggests"
    },
    {
      "package": "igraph",
      "role": "Suggests"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "listviewer",
      "role": "Suggests"
    },
    {
      "package": "lubridate",
      "role": "Suggests"
    },
    {
      "package": "RColorBrewer",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "rprojroot",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 3.0.0",
      "role": "Suggests"
    },
    {
      "package": "vctrs",
      "role": "Suggests"
    },
    {
      "package": "viridis",
      "role": "Suggests"
    },
    {
      "package": "wordcloud",
      "role": "Suggests"
    }
  ],
  "_owner": "colearendt",
  "_selfowned": true,
  "_usedby": 2,
  "_updates": [
    {
      "week": "2025-48",
      "n": 1
    },
    {
      "week": "2026-04",
      "n": 1
    }
  ],
  "_tags": [
    {
      "name": "v0.3.3.1",
      "date": "2026-01-21"
    }
  ],
  "_stars": 192,
  "_contributors": [
    {
      "user": "colearendt",
      "count": 288,
      "uuid": 23075542
    },
    {
      "user": "vats-div",
      "count": 13,
      "uuid": 7179018
    },
    {
      "user": "adgaudio",
      "count": 10,
      "uuid": 860369
    },
    {
      "user": "hadley",
      "count": 9,
      "uuid": 4196
    },
    {
      "user": "shikokuchuo",
      "count": 4,
      "uuid": 53399081
    },
    {
      "user": "ramiromagno",
      "count": 3,
      "uuid": 19862384
    },
    {
      "user": "abresler",
      "count": 1,
      "uuid": 740564
    }
  ],
  "_userbio": {
    "uuid": 23075542,
    "type": "user",
    "name": "Cole Arendt",
    "followers": 213
  },
  "_downloads": {
    "count": 1605,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/tidyjson"
  },
  "_mentions": 1,
  "_devurl": "https://github.com/colearendt/tidyjson",
  "_searchresults": 630,
  "_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/tidyjson.html",
    "LICENSE",
    "manual.pdf"
  ],
  "_homeurl": "https://github.com/colearendt/tidyjson",
  "_realowner": "colearendt",
  "_cranurl": true,
  "_releases": [
    {
      "version": "0.2.1",
      "date": "2015-05-02"
    },
    {
      "version": "0.2.2",
      "date": "2017-04-21"
    },
    {
      "version": "0.2.4",
      "date": "2019-12-02"
    },
    {
      "version": "0.3.0",
      "date": "2020-05-28"
    },
    {
      "version": "0.3.1",
      "date": "2020-05-31"
    },
    {
      "version": "0.3.2",
      "date": "2023-01-07"
    },
    {
      "version": "0.3.3.1",
      "date": "2026-01-21"
    }
  ],
  "_exports": [
    "%>%",
    "append_values_logical",
    "append_values_number",
    "append_values_string",
    "as_data_frame",
    "as_data_frame.tbl_json",
    "as_tbl_json",
    "as_tibble",
    "as.tbl_json",
    "bind_rows",
    "enter_object",
    "filter",
    "gather_array",
    "gather_keys",
    "gather_object",
    "is_json_array",
    "is_json_logical",
    "is_json_null",
    "is_json_number",
    "is_json_object",
    "is_json_scalar",
    "is_json_string",
    "is.tbl_json",
    "jdouble",
    "jinteger",
    "jlogical",
    "jnumber",
    "json_complexity",
    "json_get",
    "json_get_column",
    "json_lengths",
    "json_schema",
    "json_structure",
    "json_types",
    "jstring",
    "read_json",
    "spread_all",
    "spread_values",
    "tbl_json"
  ],
  "_datasets": [
    {
      "name": "commits",
      "title": "Commit data for the dplyr repo from github API",
      "object": "commits",
      "class": [
        "character"
      ],
      "fields": [],
      "table": false,
      "tojson": true
    },
    {
      "name": "companies",
      "title": "Startup company information for 1,000 companies",
      "object": "companies",
      "class": [
        "character"
      ],
      "fields": [],
      "table": false,
      "tojson": true
    },
    {
      "name": "issues",
      "title": "Issue data for the dplyr repo from github API",
      "object": "issues",
      "class": [
        "character"
      ],
      "fields": [],
      "table": false,
      "tojson": true
    },
    {
      "name": "worldbank",
      "title": "Projects funded by the World Bank",
      "object": "worldbank",
      "class": [
        "character"
      ],
      "fields": [],
      "table": false,
      "tojson": true
    }
  ],
  "_help": [
    {
      "page": "sub-.tbl_json",
      "title": "Extract subsets of a tbl_json object (not replace)",
      "topics": [
        "[.tbl_json"
      ]
    },
    {
      "page": "allowed_json_types",
      "title": "Fundamental JSON types from http://json.org/, where I collapse 'true' and 'false' into 'logical'",
      "topics": [
        "allowed_json_types"
      ]
    },
    {
      "page": "append_values",
      "title": "Appends all JSON values with a specified type as a new column",
      "topics": [
        "append_values",
        "append_values_logical",
        "append_values_number",
        "append_values_string"
      ]
    },
    {
      "page": "as_tibble.tbl_json",
      "title": "Convert a tbl_json back to a tbl_df",
      "topics": [
        "as_data_frame.tbl_json",
        "as_tibble.tbl_json"
      ]
    },
    {
      "page": "as.character.tbl_json",
      "title": "Convert the JSON in an tbl_json object back to a JSON string",
      "topics": [
        "as.character.tbl_json"
      ]
    },
    {
      "page": "commits",
      "title": "Commit data for the dplyr repo from github API",
      "topics": [
        "commits"
      ]
    },
    {
      "page": "companies",
      "title": "Startup company information for 1,000 companies",
      "topics": [
        "companies"
      ]
    },
    {
      "page": "enter_object",
      "title": "Enter into a specific object and discard all other JSON data",
      "topics": [
        "enter_object"
      ]
    },
    {
      "page": "gather_array",
      "title": "Gather a JSON array into index-value pairs",
      "topics": [
        "gather_array"
      ]
    },
    {
      "page": "gather_object",
      "title": "Gather a JSON object into name-value pairs",
      "topics": [
        "gather_keys",
        "gather_object"
      ]
    },
    {
      "page": "is_json",
      "title": "Predicates to test for specific JSON types in 'tbl_json' objects",
      "topics": [
        "is_json",
        "is_json_array",
        "is_json_logical",
        "is_json_null",
        "is_json_number",
        "is_json_object",
        "is_json_scalar",
        "is_json_string"
      ]
    },
    {
      "page": "issues",
      "title": "Issue data for the dplyr repo from github API",
      "topics": [
        "issues"
      ]
    },
    {
      "page": "json_complexity",
      "title": "Compute the complexity (recursively unlisted length) of JSON data",
      "topics": [
        "json_complexity"
      ]
    },
    {
      "page": "json_functions",
      "title": "Navigates nested objects to get at names of a specific type, to be used as arguments to 'spread_values'",
      "topics": [
        "jdouble",
        "jinteger",
        "jlogical",
        "jnumber",
        "json_functions",
        "jstring"
      ]
    },
    {
      "page": "json_get",
      "title": "Get JSON from a tbl_json",
      "topics": [
        "json_get"
      ]
    },
    {
      "page": "json_get_column",
      "title": "Make the JSON data a persistent column",
      "topics": [
        "json_get_column"
      ]
    },
    {
      "page": "json_lengths",
      "title": "Compute the length of JSON data",
      "topics": [
        "json_lengths"
      ]
    },
    {
      "page": "json_schema",
      "title": "Create a schema for a JSON document or collection",
      "topics": [
        "json_schema"
      ]
    },
    {
      "page": "json_structure",
      "title": "Recursively structures arbitrary JSON data into a single data frame",
      "topics": [
        "json_structure"
      ]
    },
    {
      "page": "json_types",
      "title": "Add a column that tells the 'type' of the JSON data",
      "topics": [
        "json_types"
      ]
    },
    {
      "page": "print.tbl_json",
      "title": "Print a tbl_json object",
      "topics": [
        "print.tbl_json"
      ]
    },
    {
      "page": "rbind_tbl_json",
      "title": "Bind two tbl_json objects together and preserve JSON attribute",
      "topics": [
        "rbind_tbl_json"
      ]
    },
    {
      "page": "read_json",
      "title": "Reads JSON from an input uri (file, url, ...) and returns a 'tbl_json' object",
      "topics": [
        "read_json"
      ]
    },
    {
      "page": "spread_all",
      "title": "Spreads all scalar values of a JSON object into new columns",
      "topics": [
        "spread_all"
      ]
    },
    {
      "page": "spread_values",
      "title": "Spreads specific scalar values of a JSON object into new columns",
      "topics": [
        "spread_values"
      ]
    },
    {
      "page": "tbl_json",
      "title": "Combines structured JSON (as a data.frame) with remaining JSON",
      "topics": [
        "as.tbl_json",
        "as.tbl_json.character",
        "as.tbl_json.data.frame",
        "as.tbl_json.list",
        "as.tbl_json.tbl_json",
        "as_tbl_json",
        "is.tbl_json",
        "tbl_json"
      ]
    },
    {
      "page": "tidyjson",
      "title": "tidyjson",
      "topics": [
        "tidyjson"
      ]
    },
    {
      "page": "worldbank",
      "title": "Projects funded by the World Bank",
      "topics": [
        "worldbank"
      ]
    }
  ],
  "_readme": "https://github.com/colearendt/tidyjson/raw/HEAD/README.md",
  "_rundeps": [
    "assertthat",
    "cli",
    "cpp11",
    "dplyr",
    "generics",
    "glue",
    "jsonlite",
    "lifecycle",
    "magrittr",
    "pillar",
    "pkgconfig",
    "purrr",
    "R6",
    "rlang",
    "stringi",
    "stringr",
    "tibble",
    "tidyr",
    "tidyselect",
    "utf8",
    "vctrs",
    "withr"
  ],
  "_vignettes": [
    {
      "source": "introduction-to-tidyjson.Rmd",
      "filename": "introduction-to-tidyjson.html",
      "title": "Introduction to tidyjson",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Why use tidyjson?",
        "A simple example",
        "A more complex example",
        "Tidyjson functions",
        "Common patterns",
        "Spread selected",
        "Object structure",
        "Gather nested array",
        "Filter for a specific type",
        "Gather and append",
        "Getting started with JSON data",
        "Character vector",
        "Single array",
        "List",
        "Data frame",
        "File",
        "JSON included in the package"
      ],
      "created": "2015-04-21 14:26:14",
      "modified": "2023-01-12 16:37:16",
      "commits": 11
    },
    {
      "source": "visualizing-json.Rmd",
      "filename": "visualizing-json.html",
      "title": "Visualizing JSON schema",
      "engine": "knitr::rmarkdown",
      "headings": [
        "JSON Definition",
        "Load required libraries",
        "Companies Data",
        "Working with many companies",
        "Visualizing as Graphs",
        "Working with funding data"
      ],
      "created": "2016-08-26 15:41:22",
      "modified": "2020-04-19 03:19:02",
      "commits": 14
    }
  ],
  "_score": 10.14544931132929,
  "_indexed": true,
  "_nocasepkg": "tidyjson",
  "_universes": [
    "colearendt"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.3.3.1",
      "date": "2026-06-20T06:52:44.000Z",
      "distro": "noble",
      "commit": "cc31aa795f8cc48c5a2a085cfcdc65b05cd5ebc8",
      "fileid": "44e6ab871a2abb4003ea3876b7e390c87454ea0ed6300f666be33620b977092d",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/colearendt/actions/runs/27863301628"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "0.3.3.1",
      "date": "2026-06-20T06:53:26.000Z",
      "distro": "noble",
      "commit": "cc31aa795f8cc48c5a2a085cfcdc65b05cd5ebc8",
      "fileid": "a5aa07fe806ca444e77d8698d8b96fc003732a9a9d17f3a33d7afd8c6b0f4f08",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/colearendt/actions/runs/27863301628"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.3.3.1",
      "date": "2026-06-20T06:51:44.000Z",
      "commit": "cc31aa795f8cc48c5a2a085cfcdc65b05cd5ebc8",
      "fileid": "97889fa21fbcb0d6004210a0f8a70b8d93b373e375075f580dce2c1614614f2a",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/colearendt/actions/runs/27863301628"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "0.3.3.1",
      "date": "2026-06-20T06:51:54.000Z",
      "commit": "cc31aa795f8cc48c5a2a085cfcdc65b05cd5ebc8",
      "fileid": "c2405ca85a638e220276856deb61cec909b7c380eca366984c762cc4d22495c0",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/colearendt/actions/runs/27863301628"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.3.3.1",
      "date": "2026-06-20T06:52:40.000Z",
      "commit": "cc31aa795f8cc48c5a2a085cfcdc65b05cd5ebc8",
      "fileid": "ce8a3a01048d00da6847c7e63e1647db1b7b62f0e152fef7402e45afcae3bc57",
      "status": "success",
      "buildurl": "https://github.com/r-universe/colearendt/actions/runs/27863301628"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.3.3.1",
      "date": "2026-06-20T06:51:47.000Z",
      "commit": "cc31aa795f8cc48c5a2a085cfcdc65b05cd5ebc8",
      "fileid": "767cb7906e5717a9fdf3583ed0342cd1314f9b09b3d1f18078a8d607bf347da5",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/colearendt/actions/runs/27863301628"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.3.3.1",
      "date": "2026-06-20T06:51:32.000Z",
      "commit": "cc31aa795f8cc48c5a2a085cfcdc65b05cd5ebc8",
      "fileid": "a8452ff6bda38af46a389284b52037e3d344a044d4b4d14d1367478869367d56",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/colearendt/actions/runs/27863301628"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "0.3.3.1",
      "date": "2026-06-20T06:51:34.000Z",
      "commit": "cc31aa795f8cc48c5a2a085cfcdc65b05cd5ebc8",
      "fileid": "19d74f18f3e0fd3eabfe29a8ac98249e63eaa4977df081ed1746ce1090516da9",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/colearendt/actions/runs/27863301628"
    }
  ]
}