title: Edit and Filter JSON List of Lists in R
body: <p>I am trying to display this dataset -> <a href="https://mtgjson.com/json/AllSets.json.zip" rel="nofollow noreferrer">https://mtgjson.com/json/AllSets.json.zip</a></p>
  
  <p>However I would like to flatten the data so that it isn't nested as a bunch of JSON data within a list, within a list, within a list. </p>
  
  <p>More specifically, I am trying to display the data as a dataframe, ranked in order of <code>$releaseDate</code> (one of the variables).</p>
  
  <p>Here is my attempt so far:</p>
  
  <pre><code>library(jsonlite)
  library(tidyjson)
  mtgdata &lt;- fromJSON("~/path/to/file.json")
  </code></pre>
  
  <p>The result of mtgdata presents this list of lists:</p>
  
  <pre><code>summary(mtgdata)
          Length Class  Mode
  UST       9     -none- list
  UNH      10     -none- list
  UGL      11     -none- list
  pWOS      8     -none- list
  pWOR      8     -none- list
  pWCQ      8     -none- list
  pSUS      8     -none- list
  pSUM     10     -none- list
  pREL      8     -none- list
  pPRO      8     -none- list
  pPRE      8     -none- list
  pPOD      7     -none- list
  pMPR      8     -none- list
  pMGD      8     -none- list
  pMEI      8     -none- list
  pLPA      8     -none- list
  pLGM      8     -none- list
  pJGP     10     -none- list
  pHHO     11     -none- list
  pWPN      8     -none- list
  pGTW      8     -none- list
  pGRU     10     -none- list
  pGPX      8     -none- list
  pFNM     10     -none- list
  pELP      8     -none- list
  pDRC      7     -none- list
  pCMP      8     -none- list
  pCEL      8     -none- list
  pARL      8     -none- list
  pALP     10     -none- list
  p2HG      8     -none- list
  p15A      8     -none- list
  PD3       9     -none- list
  PD2       9     -none- list
  H09       9     -none- list
  PTK      12     -none- list
  POR      12     -none- list
  PO2      13     -none- list
  PCA       7     -none- list
  PC2      10     -none- list
  HOP      10     -none- list
  VMA       9     -none- list
  MMA      10     -none- list
  MM3       8     -none- list
  MM2      11     -none- list
  MED       9     -none- list
  ME4       9     -none- list
  ME3       9     -none- list
  ME2       9     -none- list
  IMA       8     -none- list
  EMA       9     -none- list
  A25       8     -none- list
  MPS_AKH   8     -none- list
  MPS       9     -none- list
  EXP       9     -none- list
  E02       7     -none- list
  V17       8     -none- list
  V16       7     -none- list
  V15       9     -none- list
  V14       9     -none- list
  V13       9     -none- list
  V12      10     -none- list
  V11      10     -none- list
  V10       9     -none- list
  V09      10     -none- list
  DRB       9     -none- list
  EVG       9     -none- list
  DDT       7     -none- list
  DDS       7     -none- list
  DDR       7     -none- list
  DDQ       8     -none- list
  DDP      10     -none- list
  DDO      10     -none- list
  DDN      10     -none- list
  DDM      10     -none- list
  DDL      10     -none- list
  DDK      10     -none- list
  DDJ      10     -none- list
  DDI      10     -none- list
  DDH      10     -none- list
  DDG      10     -none- list
  DDF      10     -none- list
  DDE      10     -none- list
  DDD       9     -none- list
  DDC       9     -none- list
  DD3_JVC   9     -none- list
  DD3_GVL   9     -none- list
  DD3_EVG   9     -none- list
  DD3_DVD   9     -none- list
  DD2      11     -none- list
  CNS      11     -none- list
  CN2       9     -none- list
  CMD      11     -none- list
  CMA       7     -none- list
  CM1      10     -none- list
  C17       6     -none- list
  C16       8     -none- list
  C15      10     -none- list
  C14      10     -none- list
  C13      10     -none- list
  CEI       9     -none- list
  CED       9     -none- list
  E01       7     -none- list
  ARC       9     -none- list
  ZEN      12     -none- list
  XLN      12     -none- list
  WWK      12     -none- list
  WTH      13     -none- list
  W17       8     -none- list
  W16       8     -none- list
  VIS      13     -none- list
  VAN       8     -none- list
  USG      13     -none- list
  ULG      13     -none- list
  UDS      13     -none- list
  TSP      12     -none- list
  TSB      12     -none- list
  TPR      11     -none- list
  TOR      12     -none- list
  TMP      13     -none- list
  THS      12     -none- list
  STH      13     -none- list
  SOM      12     -none- list
  SOK      12     -none- list
  SOI      10     -none- list
  SHM      12     -none- list
  SCG      12     -none- list
  S99      11     -none- list
  S00      11     -none- list
  RTR      12     -none- list
  RQS       6     -none- list
  ROE      12     -none- list
  RIX      12     -none- list
  RAV      12     -none- list
  PLS      13     -none- list
  PLC      12     -none- list
  PCY      13     -none- list
  ORI      11     -none- list
  ONS      12     -none- list
  OGW      10     -none- list
  ODY      13     -none- list
  NPH      12     -none- list
  NMS      14     -none- list
  MRD      12     -none- list
  MOR      12     -none- list
  MMQ      13     -none- list
  MIR      13     -none- list
  MGB      10     -none- list
  MD1       9     -none- list
  MBS      12     -none- list
  M15      11     -none- list
  M14      11     -none- list
  M13      11     -none- list
  M12      11     -none- list
  M11      11     -none- list
  M10      11     -none- list
  LRW      12     -none- list
  LGN      12     -none- list
  LEG      12     -none- list
  LEB      11     -none- list
  LEA      11     -none- list
  KTK      12     -none- list
  KLD       9     -none- list
  JUD      12     -none- list
  JOU      12     -none- list
  ITP      11     -none- list
  ISD      12     -none- list
  INV      13     -none- list
  ICE      13     -none- list
  HOU       9     -none- list
  HML      12     -none- list
  GTC      12     -none- list
  GPT      12     -none- list
  FUT      12     -none- list
  FRF_UGIN 10     -none- list
  FRF      12     -none- list
  FEM      11     -none- list
  EXO      13     -none- list
  EVE      12     -none- list
  EMN       9     -none- list
  DTK      12     -none- list
  DST      12     -none- list
  DRK      12     -none- list
  DPA       9     -none- list
  DKM       9     -none- list
  DKA      12     -none- list
  DIS      12     -none- list
  DGM      12     -none- list
  CST      11     -none- list
  CSP      12     -none- list
  CP3       7     -none- list
  CP2       7     -none- list
  CP1       7     -none- list
  CON      13     -none- list
  CHR      11     -none- list
  CHK      12     -none- list
  BTD      10     -none- list
  BRB      10     -none- list
  BOK      12     -none- list
  BNG      12     -none- list
  BFZ      12     -none- list
  AVR      12     -none- list
  ATQ      11     -none- list
  ATH       9     -none- list
  ARN      11     -none- list
  ARB      12     -none- list
  APC      13     -none- list
  ALL      13     -none- list
  ALA      12     -none- list
  AKH       9     -none- list
  AER       9     -none- list
  9ED      12     -none- list
  8ED      12     -none- list
  7ED      12     -none- list
  6ED      12     -none- list
  5ED      12     -none- list
  5DN      12     -none- list
  4ED      12     -none- list
  3ED      12     -none- list
  2ED      11     -none- list
  10E      11     -none- list
  </code></pre>
  
  <p>Within each of these lists are variables that I am interested in analysing to filter and sort this data as though it were a flattened dataframe.</p>
  
  <p>When we inspect the list of variables within one of our lists (taking "mtgdata$UST" for example) we get this group of variables:</p>
  
  <pre><code>names(mtgdata$UST)
  [1] "name"        "code"        "releaseDate" "border"      "type"        
  "booster"     "mkm_name"   
  [8] "mkm_id"      "cards"
  </code></pre>
  
  <p>Running the same query on another list within mtgdata ("mtgdata$SOI") we get another group of variables, though they are mostly the same.</p>
  
  <p>As I have mentioned above, I am primarily interested in flattening this dataset and ranking by mtgdata$releaseDate - but as it stands, the "$releaseDate" is currently nested within the first group of lists ("$UST" etc.)       </p>
  
  <p>Your help with this or how I might better rephrase this question would be greatly appreciated.</p>