| Title: | Accessible Collegiate Athletics Data from the City University of New York (CUNY) |
|---|---|
| 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. |
| Authors: | Christian Martinez [aut, cre] (GitHub: martinezc1, ORCID: <https://orcid.org/0009-0005-6026-6454>) |
| Maintainer: | Christian Martinez <[email protected]> |
| License: | MIT + file LICENSE |
| Version: | 0.1.0 |
| Built: | 2026-10-18 18:21:36 UTC |
| Source: | https://github.com/cran/CUNYsports |
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.
column_catalogcolumn_catalog
A data frame with one row per documented database column.
CUNY Sports Analytics Initiative
Returns metadata and descriptive information for the columns in a table available in the CUNY Sports database.
cuny_columns_info(x)cuny_columns_info(x)
x |
A character string specifying the name of a table in the CUNY Sports database. |
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.
A tibble containing one row per column in the requested table and metadata describing each column.
cuny_columns_info("basketball_all_seasons_team_final")cuny_columns_info("basketball_all_seasons_team_final")
Opens a connection to the SQLite database included with CUNYsports.
cuny_db()cuny_db()
A DBI database connection.
Searches the CUNY Sports table catalog for tables matching a keyword.
cuny_find_tables(x)cuny_find_tables(x)
x |
A character string containing a keyword to search for. |
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.
A tibble containing catalog entries for tables matching the search term.
cuny_find_tables("player") cuny_find_tables("game") cuny_find_tables("scoring")cuny_find_tables("player") cuny_find_tables("game") cuny_find_tables("scoring")
Retrieves a complete table from the SQLite database included with the CUNYsports package and returns it as an R data frame.
cuny_pull_table(x)cuny_pull_table(x)
x |
A character string specifying the name of the table to retrieve. |
Use [cuny_table_names()] to view the tables currently available in the CUNY Sports database.
A data frame containing the requested table.
cuny_pull_table("basketball_all_seasons_team_final")cuny_pull_table("basketball_all_seasons_team_final")
Returns metadata and descriptive information for a table available in the CUNY Sports database.
cuny_table_info(x)cuny_table_info(x)
x |
A character string specifying the name of a table in the CUNY Sports database. |
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.
A tibble containing metadata and descriptive information about the requested table.
cuny_table_info("basketball_all_seasons_team_final")cuny_table_info("basketball_all_seasons_team_final")
Returns the names of all tables available in the SQLite database included with the CUNYsports package.
cuny_table_names()cuny_table_names()
This function provides a quick way to explore the tables available in the CUNY Sports database without directly connecting to the underlying SQLite database.
A tibble with one row per database table and a single column, 'table_name', containing the name of each available table.
cuny_table_names()cuny_table_names()
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.
table_catalogtable_catalog
A data frame with one row per database table.
CUNY Sports Analytics Initiative