{
  "_id": "6a0f64d7acfb0bcc41c5cea6",
  "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-05-21 10:13:01 UTC",
    "User": "root"
  },
  "Author": "Jeremy Stanley [aut],\nCole Arendt [aut, cre]",
  "Maintainer": "Cole Arendt <cole@benetist.com>",
  "MD5sum": "e3f41daf01305640134808b4e76d380c",
  "_user": "colearendt",
  "_type": "src",
  "_file": "tidyjson_0.3.3.1.tar.gz",
  "_fileid": "7d96daa67b599dc7248ce96ac810c460e4686f0241bc090f26bbf230d88af2b7",
  "_filesize": 3239959,
  "_sha256": "7d96daa67b599dc7248ce96ac810c460e4686f0241bc090f26bbf230d88af2b7",
  "_created": "2026-05-21T10:13:01.000Z",
  "_published": "2026-05-21T20:02:31.709Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 77257842608,
      "time": 163,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7133099360"
    },
    {
      "job": 77257842916,
      "time": 170,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7133101437"
    },
    {
      "job": 77257842725,
      "time": 261,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7133116235"
    },
    {
      "job": 77257842797,
      "time": 148,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7133088907"
    },
    {
      "job": 77257841956,
      "time": 253,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7133045582"
    },
    {
      "job": 77257841718,
      "time": 134,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7145934062"
    },
    {
      "job": 77257842718,
      "time": 112,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7133082762"
    },
    {
      "job": 77257842855,
      "time": 104,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7133080265"
    },
    {
      "job": 77257842811,
      "time": 106,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7133080754"
    }
  ],
  "_buildurl": "https://github.com/r-universe/colearendt/actions/runs/26219551010",
  "_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": 1,
  "_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"
  },
  "_downloads": {
    "count": 1621,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/tidyjson"
  },
  "_mentions": 1,
  "_devurl": "https://github.com/colearendt/tidyjson",
  "_searchresults": 611,
  "_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",
    "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": 9.835427954561908,
  "_indexed": true,
  "_nocasepkg": "tidyjson",
  "_universes": [
    "colearendt"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.3.3.1",
      "date": "2026-05-21T10:15:26.000Z",
      "distro": "noble",
      "commit": "cc31aa795f8cc48c5a2a085cfcdc65b05cd5ebc8",
      "fileid": "89381dce736a8b7bb6ab3ec658346008915b50d0532f1c857d9b97e074177093",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/colearendt/actions/runs/26219551010"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "0.3.3.1",
      "date": "2026-05-21T10:15:32.000Z",
      "distro": "noble",
      "commit": "cc31aa795f8cc48c5a2a085cfcdc65b05cd5ebc8",
      "fileid": "46262f081f980c0fa764c843f2c9d051b883d9c7efeac82d721eaf86c99c38b0",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/colearendt/actions/runs/26219551010"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.3.3.1",
      "date": "2026-05-21T10:16:18.000Z",
      "commit": "cc31aa795f8cc48c5a2a085cfcdc65b05cd5ebc8",
      "fileid": "6c84ebba3d11b69055641a060585ccf6a9a847d3538d9516b86fc5fb6e94ab38",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/colearendt/actions/runs/26219551010"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "0.3.3.1",
      "date": "2026-05-21T10:15:10.000Z",
      "commit": "cc31aa795f8cc48c5a2a085cfcdc65b05cd5ebc8",
      "fileid": "d7b58820804d3319df1e76d15cd2279493b8e297d5ae273e0cbca4ad767ffbb1",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/colearendt/actions/runs/26219551010"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.3.3.1",
      "date": "2026-05-21T20:02:16.000Z",
      "commit": "cc31aa795f8cc48c5a2a085cfcdc65b05cd5ebc8",
      "fileid": "6d720a6f9f3b183c0f4185c332631e75f63f74c1553ddc26bbcceab9484a0508",
      "status": "success",
      "buildurl": "https://github.com/r-universe/colearendt/actions/runs/26219551010"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.3.3.1",
      "date": "2026-05-21T10:14:27.000Z",
      "commit": "cc31aa795f8cc48c5a2a085cfcdc65b05cd5ebc8",
      "fileid": "b2bd00a27277e095c38fda877b13b9fe053d6744ea828be300dd7f919d2938f5",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/colearendt/actions/runs/26219551010"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.3.3.1",
      "date": "2026-05-21T10:14:21.000Z",
      "commit": "cc31aa795f8cc48c5a2a085cfcdc65b05cd5ebc8",
      "fileid": "14dd8b58889fa5ef7d8e5cc09bc3fd649d95f0ae051e5176fa6c2e3eef499e62",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/colearendt/actions/runs/26219551010"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "0.3.3.1",
      "date": "2026-05-21T10:14:22.000Z",
      "commit": "cc31aa795f8cc48c5a2a085cfcdc65b05cd5ebc8",
      "fileid": "3ed4484006649ab0176aebfb31532d128458820beff6ca54fe8c26c292ff9767",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/colearendt/actions/runs/26219551010"
    }
  ]
}