| Type: | Package |
| Title: | Accessible Collegiate Athletics Data from the City University of New York (CUNY) |
| Version: | 0.1.0 |
| Description: | Provides access to collegiate athletics data from the City University of New York (CUNY), the largest urban public university system in the United States. Includes tools for discovering and retrieving sports data from an included SQLite database. The data covers individual CUNY schools, players, games, seasons, and other aspects of CUNY athletics, providing accessible datasets for teaching, student learning, and sports analytics. |
| License: | MIT + file LICENSE |
| Encoding: | UTF-8 |
| LazyData: | true |
| Depends: | R (≥ 4.1.0) |
| Imports: | DBI, dplyr, RSQLite, stringr, rlang, tibble |
| Suggests: | ggplot2, knitr, rmarkdown, dbplyr |
| VignetteBuilder: | knitr |
| URL: | https://nyc-open-data-lab.github.io/CUNYsports/, https://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: | 2026-10-07 15:32:40 UTC; christianmartinez |
| Author: | Christian Martinez
 [aut, cre]
(GitHub: martinezc1) |
| Maintainer: | Christian Martinez <c.martinez0@outlook.com> |
| Repository: | CRAN |
| Date/Publication: | 2026-10-18 14:20:08 UTC |
CUNYsports: CUNY Athletics Data
Description
Tools for accessing and exploring collegiate athletics data from the City University of New York (CUNY).
Author(s)
Maintainer: Christian Martinez c.martinez0@outlook.com (ORCID) (GitHub: martinezc1)
Authors:
Christian Martinez c.martinez0@outlook.com (ORCID) (GitHub: martinezc1)
See Also
Useful links:
Report bugs at https://github.com/nyc-open-data-lab/CUNYsports/issues
CUNY Sports Column Catalog
Description
A catalog describing the columns contained in tables in the CUNY Sports database. The catalog provides information about column names, suggested names, data types, descriptions, example values, key types, and notes.
Usage
column_catalog
Format
A data frame with one row per documented database column.
Source
CUNY Sports Analytics Initiative
View Column Information for a CUNY Sports Table
Description
Returns metadata and descriptive information for the columns in a table available in the CUNY Sports database.
Usage
cuny_columns_info(x)
Arguments
x |
A character string specifying the name of a table in the CUNY Sports database. |
Details
Column information is retrieved from the 'column_catalog' dataset included with the CUNYsports package. The catalog includes column names, suggested names, data types, descriptions, example values, key information, and additional notes.
Use [cuny_table_names()] to view the tables currently available in the CUNY Sports database and [cuny_table_info()] to view information about a specific table.
Value
A tibble containing one row per column in the requested table and metadata describing each column.
Examples
cuny_columns_info("basketball_all_seasons_team_final")
Connect to the CUNY Sports Database
Description
Opens a connection to the SQLite database included with CUNYsports.
Usage
cuny_db()
Value
A DBI database connection.
Search Available CUNY Sports Tables
Description
Searches the CUNY Sports table catalog for tables matching a keyword.
Usage
cuny_find_tables(x)
Arguments
x |
A character string containing a keyword to search for. |
Details
The search is performed across table names, display names, descriptions, and likely uses, making it easier to discover relevant tables without knowing their exact names.
Use [cuny_table_info()] to view detailed information about a specific table and [cuny_pull_table()] to retrieve a table from the database.
Value
A tibble containing catalog entries for tables matching the search term.
Examples
cuny_find_tables("player")
cuny_find_tables("game")
cuny_find_tables("scoring")
Pull a Table from the CUNY Sports Database
Description
Retrieves a complete table from the SQLite database included with the CUNYsports package and returns it as an R data frame.
Usage
cuny_pull_table(x)
Arguments
x |
A character string specifying the name of the table to retrieve. |
Details
Use [cuny_table_names()] to view the tables currently available in the CUNY Sports database.
Value
A data frame containing the requested table.
Examples
cuny_pull_table("basketball_all_seasons_team_final")
View Information About a CUNY Sports Table
Description
Returns metadata and descriptive information for a table available in the CUNY Sports database.
Usage
cuny_table_info(x)
Arguments
x |
A character string specifying the name of a table in the CUNY Sports database. |
Details
Table information is retrieved from the 'table_catalog' dataset included with the CUNYsports package. Use [cuny_table_names()] to view the names of tables currently available in the database.
Value
A tibble containing metadata and descriptive information about the requested table.
Examples
cuny_table_info("basketball_all_seasons_team_final")
List Available CUNY Sports Database Tables
Description
Returns the names of all tables available in the SQLite database included with the CUNYsports package.
Usage
cuny_table_names()
Details
This function provides a quick way to explore the tables available in the CUNY Sports database without directly connecting to the underlying SQLite database.
Value
A tibble with one row per database table and a single column, 'table_name', containing the name of each available table.
Examples
cuny_table_names()
CUNY Sports Table Catalog
Description
A catalog describing the tables available in the CUNY Sports database. The catalog provides metadata about each table, including its contents, structure, coverage, source, potential uses, and relationships to other tables.
Usage
table_catalog
Format
A data frame with one row per database table.
Source
CUNY Sports Analytics Initiative