{
  "_id": "6a5dc0379baadeef8ab5424a",
  "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-07-20 06:25:14 UTC",
    "User": "root"
  },
  "Author": "Jeremy Stanley [aut],\nCole Arendt [aut, cre]",
  "Maintainer": "Cole Arendt <cole@benetist.com>",
  "_user": "colearendt",
  "_type": "src",
  "_file": "tidyjson_0.3.3.1.tar.gz",
  "_fileid": "https://r2.ropensci.org/36a939dc8b43620a6de64caa1db3724856644e3db56bdbf2d272a942418a382e",
  "_filesize": 3241713,
  "_sha256": "36a939dc8b43620a6de64caa1db3724856644e3db56bdbf2d272a942418a382e",
  "_expires": "2026-10-28T06:29:10.000Z",
  "_created": "2026-07-20T06:25:14.000Z",
  "_published": "2026-07-20T06:29:11.832Z",
  "_jobs": [
    {
      "job": 88285722835,
      "time": 155,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "8452619804"
    },
    {
      "job": 88285722803,
      "time": 168,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "8452623803"
    },
    {
      "job": 88285722818,
      "time": 132,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "8452608622"
    },
    {
      "job": 88285722816,
      "time": 198,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "8452617996"
    },
    {
      "job": 88285091223,
      "time": 257,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "8452575713"
    },
    {
      "job": 88285722799,
      "time": 120,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "8452609976"
    },
    {
      "job": 88285722824,
      "time": 114,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "8452608874"
    },
    {
      "job": 88285722830,
      "time": 102,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "8452605188"
    },
    {
      "job": 88285722836,
      "time": 100,
      "config": "windows-release",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "8452604633"
    }
  ],
  "_host": "GitHub-Actions",
  "_buildurl": "https://github.com/r-universe/colearendt/actions/runs/29721418968",
  "_status": "success",
  "_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"
  },
  "_distro": "resolute",
  "_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": 1404,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/tidyjson"
  },
  "_mentions": 1,
  "_devurl": "https://github.com/colearendt/tidyjson",
  "_searchresults": 638,
  "_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/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.092821511649767,
  "_indexed": true,
  "_nocasepkg": "tidyjson",
  "_universes": [
    "colearendt"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.3.3.1",
      "date": "2026-07-20T06:27:41.000Z",
      "distro": "resolute",
      "commit": "cc31aa795f8cc48c5a2a085cfcdc65b05cd5ebc8",
      "fileid": "https://r2.ropensci.org/34fab5fb53ee61ab00c4cc3255d3c85e211569e2809d36480e77c830fef8c000",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/colearendt/actions/runs/29721418968"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.3.3.1",
      "date": "2026-07-20T06:27:44.000Z",
      "distro": "resolute",
      "commit": "cc31aa795f8cc48c5a2a085cfcdc65b05cd5ebc8",
      "fileid": "https://r2.ropensci.org/8d21f3487399c8426db8f4501f36c4e94bf0edcf1c8d0d87b6506d533194b959",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/colearendt/actions/runs/29721418968"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.3.3.1",
      "date": "2026-07-20T06:27:07.000Z",
      "commit": "cc31aa795f8cc48c5a2a085cfcdc65b05cd5ebc8",
      "fileid": "https://r2.ropensci.org/36e516754db9f2a7c87a9e375d213c4f3e43086422f96ea7298fcdeda5f1cda5",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/colearendt/actions/runs/29721418968"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.3.3.1",
      "date": "2026-07-20T06:27:28.000Z",
      "commit": "cc31aa795f8cc48c5a2a085cfcdc65b05cd5ebc8",
      "fileid": "https://r2.ropensci.org/e682d7831ef804226df7856b3a3ff656cd70d83acce680c3a087b8c2c098a743",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/colearendt/actions/runs/29721418968"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.3.3.1",
      "date": "2026-07-20T06:27:29.000Z",
      "commit": "cc31aa795f8cc48c5a2a085cfcdc65b05cd5ebc8",
      "fileid": "https://r2.ropensci.org/ac2473d7effbe54dd8ddd7650695e19d2f0d2ba8cf8d65733df49497def76923",
      "status": "success",
      "buildurl": "https://github.com/r-universe/colearendt/actions/runs/29721418968"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.3.3.1",
      "date": "2026-07-20T06:26:43.000Z",
      "commit": "cc31aa795f8cc48c5a2a085cfcdc65b05cd5ebc8",
      "fileid": "https://r2.ropensci.org/22b5ce2e3817fc4c1b961c47106b5cf068834623543256eba584f884ac442e36",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/colearendt/actions/runs/29721418968"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.3.3.1",
      "date": "2026-07-20T06:26:33.000Z",
      "commit": "cc31aa795f8cc48c5a2a085cfcdc65b05cd5ebc8",
      "fileid": "https://r2.ropensci.org/2fe3564f98146e33e9a83ec339b21f4c4ac7b63ecc9f333c7a914f027f8164c9",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/colearendt/actions/runs/29721418968"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.3.3.1",
      "date": "2026-07-20T06:26:28.000Z",
      "commit": "cc31aa795f8cc48c5a2a085cfcdc65b05cd5ebc8",
      "fileid": "https://r2.ropensci.org/83d4be23395643b8c17bf167234dd5126821887b68ab5342b327477efa8b69d4",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/colearendt/actions/runs/29721418968"
    }
  ]
}