json_unnest_longer.md
In jsontools: Working with JSON Vectors

json_unnest_longer with discog_json

{
  "type": "list",
  "attributes": {
    "names": {
      "type": "character",
      "attributes": {},
      "value": ["item"]
    },
    "row.names": {
      "type": "integer",
      "attributes": {},
      "value": [1, 2, 3]
    },
    "class": {
      "type": "character",
      "attributes": {},
      "value": ["tbl_df", "tbl", "data.frame"]
    }
  },
  "value": [
    {
      "type": "character",
      "attributes": {
        "class": {
          "type": "character",
          "attributes": {},
          "value": ["json2", "json", "vctrs_vctr", "character"]
        }
      },
      "value": ["{\"instance_id\":354823933,\"date_added\":\"2019-02-16T17:48:59-08:00\",\"basic_information\":{\"labels\":[{\"name\":\"Tobi Records (2)\",\"entity_type\":\"1\",\"catno\":\"TOB-013\",\"resource_url\":\"https://api.discogs.com/labels/633407\",\"id\":633407,\"entity_type_name\":\"Label\"}],\"year\":2015,\"master_url\":null,\"artists\":[{\"join\":\"\",\"name\":\"Mollot\",\"anv\":\"\",\"tracks\":\"\",\"role\":\"\",\"resource_url\":\"https://api.discogs.com/artists/4619796\",\"id\":4619796}],\"id\":7496378,\"thumb\":\"https://img.discogs.com/vEVegHrMNTsP6xG_K6OuFXz4h_U=/fit-in/150x150/filters:strip_icc():format(jpeg):mode_rgb():quality(40)/discogs-images/R-7496378-1442692247-1195.jpeg.jpg\",\"title\":\"Demo\",\"formats\":[{\"descriptions\":[\"Numbered\"],\"text\":\"Black\",\"name\":\"Cassette\",\"qty\":\"1\"}],\"cover_image\":\"https://img.discogs.com/EmbMh7vsElksjRgoXLFSuY1sjRQ=/fit-in/500x499/filters:strip_icc():format(jpeg):mode_rgb():quality(90)/discogs-images/R-7496378-1442692247-1195.jpeg.jpg\",\"resource_url\":\"https://api.discogs.com/releases/7496378\",\"master_id\":0},\"id\":7496378,\"rating\":0}", "{\"instance_id\":354092601,\"date_added\":\"2019-02-13T14:13:11-08:00\",\"basic_information\":{\"labels\":[{\"name\":\"La Vida Es Un Mus\",\"entity_type\":\"1\",\"catno\":\"Mus70\",\"resource_url\":\"https://api.discogs.com/labels/38322\",\"id\":38322,\"entity_type_name\":\"Label\"}],\"year\":2013,\"master_url\":\"https://api.discogs.com/masters/553057\",\"artists\":[{\"join\":\"\",\"name\":\"Una Bèstia Incontrolable\",\"anv\":\"\",\"tracks\":\"\",\"role\":\"\",\"resource_url\":\"https://api.discogs.com/artists/3192745\",\"id\":3192745}],\"id\":4490852,\"thumb\":\"https://img.discogs.com/nRZbcvVNygyNFKg5IjUd5YesF_c=/fit-in/150x150/filters:strip_icc():format(jpeg):mode_rgb():quality(40)/discogs-images/R-4490852-1419726473-4388.jpeg.jpg\",\"title\":\"Observant Com El Mon Es Destrueix\",\"formats\":[{\"descriptions\":[\"LP\"],\"name\":\"Vinyl\",\"qty\":\"1\"}],\"cover_image\":\"https://img.discogs.com/eBbQ9jaiHKFeSXLwBEbxq6nl8Wo=/fit-in/600x600/filters:strip_icc():format(jpeg):mode_rgb():quality(90)/discogs-images/R-4490852-1419726473-4388.jpeg.jpg\",\"resource_url\":\"https://api.discogs.com/releases/4490852\",\"master_id\":553057},\"id\":4490852,\"rating\":0}", "{\"instance_id\":354091476,\"date_added\":\"2019-02-13T14:07:23-08:00\",\"basic_information\":{\"labels\":[{\"name\":\"La Vida Es Un Mus\",\"entity_type\":\"1\",\"catno\":\"MUS118\",\"resource_url\":\"https://api.discogs.com/labels/38322\",\"id\":38322,\"entity_type_name\":\"Label\"}],\"year\":2017,\"master_url\":\"https://api.discogs.com/masters/1109943\",\"artists\":[{\"join\":\"\",\"name\":\"S.H.I.T. (3)\",\"anv\":\"\",\"tracks\":\"\",\"role\":\"\",\"resource_url\":\"https://api.discogs.com/artists/2769828\",\"id\":2769828}],\"id\":9827276,\"thumb\":\"https://img.discogs.com/x6GUri3hXAcfzF2wz5jQloomOoY=/fit-in/150x150/filters:strip_icc():format(jpeg):mode_rgb():quality(40)/discogs-images/R-9827276-1488380364-7942.jpeg.jpg\",\"title\":\"I\",\"formats\":[{\"descriptions\":[\"7\\\"\",\"45 RPM\",\"EP\"],\"name\":\"Vinyl\",\"qty\":\"1\"}],\"cover_image\":\"https://img.discogs.com/7aJPlo2phtFL-T2Kt6MTBc0uftY=/fit-in/600x600/filters:strip_icc():format(jpeg):mode_rgb():quality(90)/discogs-images/R-9827276-1488380364-7942.jpeg.jpg\",\"resource_url\":\"https://api.discogs.com/releases/9827276\",\"master_id\":1109943},\"id\":9827276,\"rating\":0}"]
    }
  ]
}

{
  "type": "list",
  "attributes": {
    "names": {
      "type": "character",
      "attributes": {},
      "value": ["artists", "component_id"]
    },
    "row.names": {
      "type": "integer",
      "attributes": {},
      "value": [1, 2, 3]
    },
    "class": {
      "type": "character",
      "attributes": {},
      "value": ["tbl_df", "tbl", "data.frame"]
    }
  },
  "value": [
    {
      "type": "character",
      "attributes": {
        "class": {
          "type": "character",
          "attributes": {},
          "value": ["json2", "json", "vctrs_vctr", "character"]
        }
      },
      "value": ["{\"join\":\"\",\"name\":\"Mollot\",\"anv\":\"\",\"tracks\":\"\",\"role\":\"\",\"resource_url\":\"https://api.discogs.com/artists/4619796\",\"id\":4619796}", "{\"join\":\"\",\"name\":\"Una Bèstia Incontrolable\",\"anv\":\"\",\"tracks\":\"\",\"role\":\"\",\"resource_url\":\"https://api.discogs.com/artists/3192745\",\"id\":3192745}", "{\"join\":\"\",\"name\":\"S.H.I.T. (3)\",\"anv\":\"\",\"tracks\":\"\",\"role\":\"\",\"resource_url\":\"https://api.discogs.com/artists/2769828\",\"id\":2769828}"]
    },
    {
      "type": "integer",
      "attributes": {},
      "value": [1, 2, 3]
    }
  ]
}