{
  "_id": "6abda79699f7aa8c6aa509e3",
  "Package": "foosball3",
  "Title": "An App to Manage and Organise Foosball Tournaments",
  "Version": "0.0.0.9023",
  "Authors@R": "c(person(\"Pepijn\", \"de Vries\", role = c(\"aut\", \"cre\", \"dtc\"),\nemail = \"pepijn.devries@outlook.com\",\ncomment = c(ORCID = \"0000-0002-7961-6646\")))",
  "Author": "Pepijn de Vries [aut, cre, dtc] (0000-0002-7961-6646)",
  "Description": "A relational SQLite database used to manage foosball\ntournaments. This package provides a features and a graphical\nuser interface to easily access the database. It also allows to\nvisualise (historical) data and account player history. It can\nbe used to facilitate a live tournament.",
  "License": "GPL (>= 3)",
  "Encoding": "UTF-8",
  "Roxygen": "list(markdown = TRUE)",
  "URL": "https://github.com/pepijn-devries/foosball3,\nhttps://pepijn-devries.github.io/foosball3/",
  "BugReports": "https://github.com/pepijn-devries/foosball3/issues",
  "Collate": "'create.R' 'dependencies.R' 'export.R' 'suggests.R'\n'foosball3.R' 'generate.R' 'import.R' 'meta.R'",
  "Config/roxygen2/version": "8.1.0",
  "Config/pak/sysreqs": "cmake make libicu-dev libuv1-dev zlib1g-dev",
  "Repository": "https://pepijn-devries.r-universe.dev",
  "Date/Publication": "2026-09-30 21:10:55 UTC",
  "RemoteUrl": "https://github.com/pepijn-devries/foosball3",
  "RemoteRef": "main",
  "RemoteSha": "1be9c00a5492b703676e4d408c938d00872fb8aa",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-10-01 00:17:59 UTC",
    "User": "root"
  },
  "Maintainer": "Pepijn de Vries <pepijn.devries@outlook.com>",
  "_user": "pepijn-devries",
  "_type": "src",
  "_file": "foosball3_0.0.0.9023.tar.gz",
  "_fileid": "https://r2.ropensci.org/a1dd570818cd3eb9682a5cd5dabdfa95a286e1c11ab9da3ed9add3d3f57e22f7",
  "_filesize": 625144,
  "_sha256": "a1dd570818cd3eb9682a5cd5dabdfa95a286e1c11ab9da3ed9add3d3f57e22f7",
  "_expires": "2027-01-09T00:21:40.000Z",
  "_created": "2026-10-01T00:17:59.000Z",
  "_published": "2026-10-01T00:21:42.641Z",
  "_jobs": [
    {
      "job": 110157892228,
      "time": 145,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11133083651"
    },
    {
      "job": 110157892149,
      "time": 175,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11133048828"
    },
    {
      "job": 110157892170,
      "time": 107,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "11133363281"
    },
    {
      "job": 110157892175,
      "time": 86,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11133621636"
    },
    {
      "job": 110156860090,
      "time": 223,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11133795988"
    },
    {
      "job": 110157892158,
      "time": 139,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "11134005288"
    },
    {
      "job": 110157892221,
      "time": 103,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11132983747"
    },
    {
      "job": 110157892196,
      "time": 95,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "11134050016"
    },
    {
      "job": 110157892350,
      "time": 106,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11133068682"
    }
  ],
  "_host": "GitHub-Actions",
  "_buildurl": "https://github.com/r-universe/pepijn-devries/actions/runs/36795145677",
  "_status": "success",
  "_upstream": "https://github.com/pepijn-devries/foosball3",
  "_commit": {
    "id": "1be9c00a5492b703676e4d408c938d00872fb8aa",
    "author": "Pepijn de Vries <pepijn-devries@users.noreply.github.com>",
    "committer": "GitHub <noreply@github.com>",
    "message": "Merge pull request #19 from pepijn-devries/work-in-progress\n\nImplemented initial crude person stat visualisation",
    "time": 1790802655
  },
  "_maintainer": {
    "name": "Pepijn de Vries",
    "email": "pepijn.devries@outlook.com",
    "login": "pepijn-devries",
    "linkedin": "in/pepijn-de-vries-2509b664",
    "orcid": "0000-0002-7961-6646",
    "description": "",
    "uuid": 13707449
  },
  "_distro": "resolute",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 4.1.0",
      "role": "Depends"
    },
    {
      "package": "blob",
      "role": "Imports"
    },
    {
      "package": "dbplyr",
      "role": "Imports"
    },
    {
      "package": "dplyr",
      "role": "Imports"
    },
    {
      "package": "methods",
      "role": "Imports"
    },
    {
      "package": "rlang",
      "role": "Imports"
    },
    {
      "package": "RSQLite",
      "role": "Imports"
    },
    {
      "package": "shiny",
      "role": "Imports"
    },
    {
      "package": "stringr",
      "role": "Imports"
    },
    {
      "package": "tidyr",
      "role": "Imports"
    },
    {
      "package": "base64enc",
      "role": "Suggests"
    },
    {
      "package": "bsicons",
      "role": "Suggests"
    },
    {
      "package": "bslib",
      "role": "Suggests"
    },
    {
      "package": "DiagrammeR",
      "role": "Suggests"
    },
    {
      "package": "DiagrammeRsvg",
      "role": "Suggests"
    },
    {
      "package": "dm",
      "role": "Suggests"
    },
    {
      "package": "DT",
      "role": "Suggests"
    },
    {
      "package": "ggplot2",
      "role": "Suggests"
    },
    {
      "package": "ggiraph",
      "role": "Suggests"
    },
    {
      "package": "imager",
      "role": "Suggests"
    },
    {
      "package": "jsonlite",
      "role": "Suggests"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "lubridate",
      "role": "Suggests"
    },
    {
      "package": "mirai",
      "role": "Suggests"
    },
    {
      "package": "promises",
      "role": "Suggests"
    },
    {
      "package": "shinybusy",
      "role": "Suggests"
    },
    {
      "package": "shinyjs",
      "role": "Suggests"
    },
    {
      "package": "shinyvalidate",
      "role": "Suggests"
    },
    {
      "package": "shinyWidgets",
      "role": "Suggests"
    }
  ],
  "_owner": "pepijn-devries",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2026-34",
      "n": 6
    },
    {
      "week": "2026-35",
      "n": 4
    },
    {
      "week": "2026-36",
      "n": 13
    },
    {
      "week": "2026-37",
      "n": 10
    },
    {
      "week": "2026-38",
      "n": 1
    },
    {
      "week": "2026-40",
      "n": 3
    }
  ],
  "_tags": [],
  "_stars": 0,
  "_contributors": [
    {
      "user": "pepijn-devries",
      "count": 73,
      "uuid": 13707449
    }
  ],
  "_userbio": {
    "uuid": 13707449,
    "type": "user",
    "name": "Pepijn de Vries",
    "followers": 25
  },
  "_downloads": {
    "count": 0,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/foosball3"
  },
  "_devurl": "https://github.com/pepijn-devries/foosball3",
  "_pkgdown": "https://pepijn-devries.github.io/foosball3/",
  "_searchresults": 2,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/foosball3.html",
    "extra/manual.pdf",
    "extra/readme.html",
    "extra/readme.md"
  ],
  "_cranurl": false,
  "_exports": [
    "foosball3",
    "foosball3_create_db",
    "foosball3_export_db",
    "foosball3_generate_matches",
    "foosball3_import_db",
    "foosball3_install_suggests",
    "foosball3_list_suggests",
    "foosball3_meta_data",
    "foosball3_suggests_ok"
  ],
  "_help": [
    {
      "page": "foosball3",
      "title": "Start the Foosball App",
      "topics": [
        "foosball3"
      ]
    },
    {
      "page": "foosball3_create_db",
      "title": "Create a New Foosball Database",
      "topics": [
        "foosball3_create_db"
      ]
    },
    {
      "page": "foosball3_export_db",
      "title": "Export an Foosball SQLite Database to csv Format",
      "topics": [
        "foosball3_export_db"
      ]
    },
    {
      "page": "foosball3_generate_matches",
      "title": "Generate Matches for a Tournament Phase",
      "topics": [
        "foosball3_generate_matches"
      ]
    },
    {
      "page": "foosball3_import_db",
      "title": "Import Foosball Tournament Data from a File",
      "topics": [
        "foosball3_import_db"
      ]
    },
    {
      "page": "foosball3_install_suggests",
      "title": "Install Packages Suggested by 'foosball3'",
      "topics": [
        "foosball3_install_suggests"
      ]
    },
    {
      "page": "foosball3_list_suggests",
      "title": "List Packages Suggested by the 'foosball3' Package",
      "topics": [
        "foosball3_list_suggests"
      ]
    },
    {
      "page": "foosball3_meta_data",
      "title": "Get Meta Data for Tables in the Foosball Database Scheme",
      "topics": [
        "foosball3_meta_data"
      ]
    },
    {
      "page": "foosball3_suggests_ok",
      "title": "Check if All Suggested Packages Are Available",
      "topics": [
        "foosball3_suggests_ok"
      ]
    }
  ],
  "_pkglogo": "https://github.com/pepijn-devries/foosball3/raw/main/man/figures/logo.svg",
  "_readme": "https://github.com/pepijn-devries/foosball3/raw/main/README.md",
  "_rundeps": [
    "base64enc",
    "bit",
    "bit64",
    "blob",
    "bslib",
    "cachem",
    "cli",
    "commonmark",
    "cpp11",
    "DBI",
    "dbplyr",
    "digest",
    "dplyr",
    "fastmap",
    "fontawesome",
    "fs",
    "generics",
    "glue",
    "htmltools",
    "httpuv",
    "jquerylib",
    "jsonlite",
    "later",
    "lifecycle",
    "magrittr",
    "memoise",
    "mime",
    "otel",
    "pillar",
    "pkgconfig",
    "promises",
    "purrr",
    "R6",
    "rappdirs",
    "Rcpp",
    "rlang",
    "RSQLite",
    "sass",
    "shiny",
    "sourcetools",
    "stringi",
    "stringr",
    "tibble",
    "tidyr",
    "tidyselect",
    "utf8",
    "vctrs",
    "withr",
    "xtable"
  ],
  "_score": 2.4771212547196626,
  "_indexed": true,
  "_nocasepkg": "foosball3",
  "_universes": [
    "pepijn-devries"
  ],
  "_previous": "0.0.0.9022",
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.0.0.9023",
      "date": "2026-10-01T00:20:21.000Z",
      "distro": "resolute",
      "commit": "1be9c00a5492b703676e4d408c938d00872fb8aa",
      "fileid": "https://r2.ropensci.org/327b19f42f89a1a4360d12b8e1def11703098ada1949b95c6a58f8e36f9386f3",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/pepijn-devries/actions/runs/36795145677"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.0.0.9023",
      "date": "2026-10-01T00:20:43.000Z",
      "distro": "resolute",
      "commit": "1be9c00a5492b703676e4d408c938d00872fb8aa",
      "fileid": "https://r2.ropensci.org/b97977d9ef484bdef703a519129d776fe8731243f6ce75342aacaec83c168ee0",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/pepijn-devries/actions/runs/36795145677"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.0.0.9023",
      "date": "2026-10-01T00:19:44.000Z",
      "commit": "1be9c00a5492b703676e4d408c938d00872fb8aa",
      "fileid": "https://r2.ropensci.org/580099af12f09a0eb0e06871e67015459c396a8698a58026e362ebb7ad268f7b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/pepijn-devries/actions/runs/36795145677"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.0.0.9023",
      "date": "2026-10-01T00:19:30.000Z",
      "commit": "1be9c00a5492b703676e4d408c938d00872fb8aa",
      "fileid": "https://r2.ropensci.org/20d0c8d08818879e495b8630524cec4f6af27ed34039d77bbf64d7e7e2cbe665",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/pepijn-devries/actions/runs/36795145677"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.0.0.9023",
      "date": "2026-10-01T00:20:37.000Z",
      "commit": "1be9c00a5492b703676e4d408c938d00872fb8aa",
      "fileid": "https://r2.ropensci.org/e097edd14792a73b3da3cc61b2425b7436d2804cc1dfef328408572a33e2b077",
      "status": "success",
      "buildurl": "https://github.com/r-universe/pepijn-devries/actions/runs/36795145677"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.0.0.9023",
      "date": "2026-10-01T00:19:25.000Z",
      "commit": "1be9c00a5492b703676e4d408c938d00872fb8aa",
      "fileid": "https://r2.ropensci.org/087744f9d57e0327566bd1ee7e9e8fb483e869d50ff01b6b94723f4209f9dbc6",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/pepijn-devries/actions/runs/36795145677"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.0.0.9023",
      "date": "2026-10-01T00:19:20.000Z",
      "commit": "1be9c00a5492b703676e4d408c938d00872fb8aa",
      "fileid": "https://r2.ropensci.org/bac5180f4928e2b225f70c64147b2cff42ffea6aa0a5e94474709f098687769a",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/pepijn-devries/actions/runs/36795145677"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.0.0.9023",
      "date": "2026-10-01T00:19:31.000Z",
      "commit": "1be9c00a5492b703676e4d408c938d00872fb8aa",
      "fileid": "https://r2.ropensci.org/26d1b2cd8504badad96e492b5ba8dccec1fb92870514e8f1d2d330ae933c0e3c",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/pepijn-devries/actions/runs/36795145677"
    }
  ]
}