{
  "_id": "6ad50ed34a34890ab4938397",
  "Package": "CUNYsports",
  "Type": "Package",
  "Title": "Accessible Collegiate Athletics Data from the City University of\nNew York (CUNY)",
  "Version": "0.1.0",
  "Authors@R": "person(\"Christian\", \"Martinez\",\nemail = \"c.martinez0@outlook.com\",\nrole = c(\"aut\", \"cre\"),\ncomment = c(\nGitHub = \"martinezc1\",\nORCID = \"0009-0005-6026-6454\"))",
  "Description": "Provides access to collegiate athletics data from the City\nUniversity of New York (CUNY), the largest urban public\nuniversity system in the United States. Includes tools for\ndiscovering and retrieving sports data from an included SQLite\ndatabase. The data covers individual CUNY schools, players,\ngames, seasons, and other aspects of CUNY athletics, providing\naccessible datasets for teaching, student learning, and sports\nanalytics.",
  "License": "MIT + file LICENSE",
  "Encoding": "UTF-8",
  "LazyData": "true",
  "VignetteBuilder": "knitr",
  "URL": "https://nyc-open-data-lab.github.io/CUNYsports/,\nhttps://github.com/nyc-open-data-lab/CUNYsports",
  "BugReports": "https://github.com/nyc-open-data-lab/CUNYsports/issues",
  "Config/roxygen2/version": "8.1.0",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-10-18 18:21:33 UTC",
    "User": "root"
  },
  "Author": "Christian Martinez [aut, cre] (GitHub: martinezc1, ORCID:\n<https://orcid.org/0009-0005-6026-6454>)",
  "Maintainer": "Christian Martinez <c.martinez0@outlook.com>",
  "Repository": "https://cran.r-universe.dev",
  "Date/Publication": "2026-10-18 14:43:07 UTC",
  "RemoteUrl": "https://github.com/cran/CUNYsports",
  "RemoteRef": "HEAD",
  "RemoteSha": "8cc0b8cec572692af5df0841bfe68a2d5e28cfaf",
  "_user": "cran",
  "_type": "src",
  "_file": "CUNYsports_0.1.0.tar.gz",
  "_fileid": "https://r2.ropensci.org/d9a5cb081bd6c77d74f2e49585ff3d67f5f5387ce0ca221394f2bf293d345f2e",
  "_filesize": 5290046,
  "_sha256": "d9a5cb081bd6c77d74f2e49585ff3d67f5f5387ce0ca221394f2bf293d345f2e",
  "_expires": "2027-01-26T18:24:17.000Z",
  "_created": "2026-10-18T18:21:33.000Z",
  "_published": "2026-10-18T18:24:19.761Z",
  "_buildurl": "https://github.com/r-universe/cran/actions/runs/39153581504",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_jobs": [
    {
      "job": 117752752515,
      "time": 103,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "12146351670"
    },
    {
      "job": 117752752887,
      "time": 112,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12146257073"
    },
    {
      "job": 117752120734,
      "time": 167,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12146480883"
    },
    {
      "job": 117752752547,
      "time": 122,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "12146321813"
    },
    {
      "job": 117752752503,
      "time": 77,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "12146282021"
    },
    {
      "job": 117752752555,
      "time": 84,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12146520808"
    }
  ],
  "_upstream": "https://github.com/cran/CUNYsports",
  "_commit": {
    "id": "8cc0b8cec572692af5df0841bfe68a2d5e28cfaf",
    "author": "Christian Martinez <c.martinez0@outlook.com>",
    "committer": "cran-robot <csardi.gabor+cran@gmail.com>",
    "message": "version 0.1.0\n",
    "time": 1792334587
  },
  "_maintainer": {
    "name": "Christian Martinez",
    "email": "c.martinez0@outlook.com",
    "login": "martinezc1",
    "linkedin": "in/christian-a-martinez",
    "orcid": "0009-0005-6026-6454",
    "description": "Building open-source tools, reproducible research, and better ways to teach with data | Founder, NYC Open Data Lab",
    "uuid": 213213537
  },
  "_distro": "resolute",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 4.1.0",
      "role": "Depends"
    },
    {
      "package": "DBI",
      "role": "Imports"
    },
    {
      "package": "dplyr",
      "role": "Imports"
    },
    {
      "package": "RSQLite",
      "role": "Imports"
    },
    {
      "package": "stringr",
      "role": "Imports"
    },
    {
      "package": "rlang",
      "role": "Imports"
    },
    {
      "package": "tibble",
      "role": "Imports"
    },
    {
      "package": "ggplot2",
      "role": "Suggests"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "dbplyr",
      "role": "Suggests"
    }
  ],
  "_owner": "cran",
  "_selfowned": false,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2026-42",
      "n": 1
    }
  ],
  "_tags": [
    {
      "name": "0.1.0",
      "date": "2026-10-18"
    }
  ],
  "_stars": 0,
  "_contributors": [
    {
      "user": "martinezc1",
      "count": 1,
      "uuid": 213213537
    }
  ],
  "_userbio": {
    "uuid": 6899542,
    "type": "organization",
    "name": "cran",
    "followers": 634,
    "description": "Unofficial read-only mirror of all CRAN R packages"
  },
  "_downloads": {
    "count": 0,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/CUNYsports"
  },
  "_devurl": "https://github.com/nyc-open-data-lab/cunysports",
  "_pkgdown": "https://nyc-open-data-lab.github.io/CUNYsports/",
  "_searchresults": 0,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/CUNYsports.html",
    "extra/manual.pdf",
    "extra/readme.html",
    "extra/readme.md",
    "LICENSE"
  ],
  "_cranurl": false,
  "_releases": [
    {
      "version": "0.1.0",
      "date": "2026-10-18"
    }
  ],
  "_exports": [
    "cuny_columns_info",
    "cuny_db",
    "cuny_find_tables",
    "cuny_pull_table",
    "cuny_table_info",
    "cuny_table_names"
  ],
  "_datasets": [
    {
      "name": "column_catalog",
      "title": "CUNY Sports Column Catalog",
      "object": "column_catalog",
      "class": [
        "tbl_df",
        "tbl",
        "data.frame"
      ],
      "fields": [
        "table_name",
        "column_name",
        "suggested_name",
        "data_type",
        "description",
        "example",
        "key_type",
        "notes"
      ],
      "rows": 602,
      "table": true,
      "tojson": true
    },
    {
      "name": "table_catalog",
      "title": "CUNY Sports Table Catalog",
      "object": "table_catalog",
      "class": [
        "tbl_df",
        "tbl",
        "data.frame"
      ],
      "fields": [
        "table_name",
        "display_name",
        "description",
        "grain",
        "season_coverage",
        "source",
        "primary_key_candidate",
        "foreign_keys_needed",
        "likely_uses",
        "cleaning_priority",
        "notes"
      ],
      "rows": 23,
      "table": true,
      "tojson": true
    }
  ],
  "_help": [
    {
      "page": "column_catalog",
      "title": "CUNY Sports Column Catalog",
      "topics": [
        "column_catalog"
      ]
    },
    {
      "page": "cuny_columns_info",
      "title": "View Column Information for a CUNY Sports Table",
      "topics": [
        "cuny_columns_info"
      ]
    },
    {
      "page": "cuny_db",
      "title": "Connect to the CUNY Sports Database",
      "topics": [
        "cuny_db"
      ]
    },
    {
      "page": "cuny_find_tables",
      "title": "Search Available CUNY Sports Tables",
      "topics": [
        "cuny_find_tables"
      ]
    },
    {
      "page": "cuny_pull_table",
      "title": "Pull a Table from the CUNY Sports Database",
      "topics": [
        "cuny_pull_table"
      ]
    },
    {
      "page": "cuny_table_info",
      "title": "View Information About a CUNY Sports Table",
      "topics": [
        "cuny_table_info"
      ]
    },
    {
      "page": "cuny_table_names",
      "title": "List Available CUNY Sports Database Tables",
      "topics": [
        "cuny_table_names"
      ]
    },
    {
      "page": "table_catalog",
      "title": "CUNY Sports Table Catalog",
      "topics": [
        "table_catalog"
      ]
    }
  ],
  "_readme": "https://github.com/cran/CUNYsports/raw/HEAD/README.md",
  "_rundeps": [
    "bit",
    "bit64",
    "blob",
    "cachem",
    "cli",
    "cpp11",
    "DBI",
    "dplyr",
    "fastmap",
    "generics",
    "glue",
    "lifecycle",
    "magrittr",
    "memoise",
    "pillar",
    "pkgconfig",
    "R6",
    "rlang",
    "RSQLite",
    "stringi",
    "stringr",
    "tibble",
    "tidyselect",
    "utf8",
    "vctrs",
    "withr"
  ],
  "_vignettes": [
    {
      "source": "getting-started-CUNYsports.Rmd",
      "filename": "getting-started-CUNYsports.html",
      "title": "Getting Started with CUNYsports",
      "author": "Christian Martinez",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Introduction",
        "Discovering Available Data",
        "The cuny_table_names() function",
        "The cuny_find_tables() function",
        "Understanding a Table",
        "The cuny_table_info() function",
        "The cuny_columns_info() function",
        "Retrieving Data",
        "Putting the Workflow Together",
        "Real World Example",
        "Mini Analysis",
        "Direct Database Access",
        "Rule of Thumb",
        "Summary",
        "How to Cite"
      ],
      "created": "2026-10-18 14:43:07",
      "modified": "2026-10-18 14:43:07",
      "commits": 1
    }
  ],
  "_score": 2.6989700043360187,
  "_indexed": false,
  "_nocasepkg": "cunysports",
  "_universes": [
    "cran",
    "martinezc1",
    "nyc-open-data-lab"
  ],
  "_indexurl": "https://nyc-open-data-lab.r-universe.dev/CUNYsports",
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.1.0",
      "date": "2026-10-18T18:23:23.000Z",
      "distro": "resolute",
      "commit": "8cc0b8cec572692af5df0841bfe68a2d5e28cfaf",
      "fileid": "https://r2.ropensci.org/8a635f7b015ca8510c9f75b9ce86d15e26abbe1efe51ad6d92469a82c07c46ee",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/39153581504"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.1.0",
      "date": "2026-10-18T18:23:26.000Z",
      "distro": "resolute",
      "commit": "8cc0b8cec572692af5df0841bfe68a2d5e28cfaf",
      "fileid": "https://r2.ropensci.org/b8ffd3cbdd49f4a06f3ada021ff168b66cb807d82fd7de812fe4bda8e7eab6f4",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/39153581504"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.1.0",
      "date": "2026-10-18T18:23:47.000Z",
      "commit": "8cc0b8cec572692af5df0841bfe68a2d5e28cfaf",
      "fileid": "https://r2.ropensci.org/87d2b2247377d88043f881b2377e65d1213cad7572c962c5f3bd86ee64f9851a",
      "status": "success",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/39153581504"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.1.0",
      "date": "2026-10-18T18:22:45.000Z",
      "commit": "8cc0b8cec572692af5df0841bfe68a2d5e28cfaf",
      "fileid": "https://r2.ropensci.org/204ed3c068f08ada328335119ee3721dd5fb36ec3fcb0a36c1c9a7ea8b17bfe2",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/39153581504"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.1.0",
      "date": "2026-10-18T18:22:50.000Z",
      "commit": "8cc0b8cec572692af5df0841bfe68a2d5e28cfaf",
      "fileid": "https://r2.ropensci.org/d0be3ced83a12a7058c9e6d5e7bf6307dcbf8d886ea00f2b80e12b8ff8c11db3",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/39153581504"
    }
  ]
}