Searches the CUNY Sports table catalog for tables matching a keyword.
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.
Examples
cuny_find_tables("player")
#> # A tibble: 12 × 11
#> table_name display_name description grain season_coverage source
#> <chr> <chr> <chr> <chr> <chr> <chr>
#> 1 dim_players Player Dime… Lookup tab… One … 2012-13 to pre… Deriv…
#> 2 dim_player_year Player Years Bridge tab… One … All player-sea… Deriv…
#> 3 basketball_all_seasons… All Seasons… Season-lev… One … All seasons re… Scrap…
#> 4 basketball_all_seasons… All Seasons… Season-lev… One … All seasons re… Scrap…
#> 5 basketball_all_seasons… All Seasons… Season-lev… One … All conference… Scrap…
#> 6 basketball_all_seasons… All Seasons… Season-lev… One … All conference… Scrap…
#> 7 basketball_all_seasons… All Seasons… Season-lev… One … All seasons re… Scrap…
#> 8 basketball_all_seasons… All Seasons… Season-lev… One … All seasons re… Scrap…
#> 9 basketball_all_seasons… All Seasons… Season-lev… One … All seasons re… Scrap…
#> 10 basketball_all_seasons… All Seasons… Season-lev… One … All seasons re… Scrap…
#> 11 basketball_game_high_i… Individual … Highest si… One … All seasons re… Scrap…
#> 12 basketball_all_cat_lea… All Categor… Player-sea… One … All seasons re… Scrap…
#> # ℹ 5 more variables: primary_key_candidate <chr>, foreign_keys_needed <chr>,
#> # likely_uses <chr>, cleaning_priority <chr>, notes <chr>
cuny_find_tables("game")
#> # A tibble: 16 × 11
#> table_name display_name description grain season_coverage source
#> <chr> <chr> <chr> <chr> <chr> <chr>
#> 1 dim_opponents Opponent Di… Lookup tab… One … 2012-13 to pre… Deriv…
#> 2 dim_games Game Dimens… Lookup tab… One … 2012-13 to pre… Deriv…
#> 3 basketball_all_seasons… All Seasons… Season-lev… One … All seasons re… Scrap…
#> 4 basketball_all_seasons… All Seasons… Season-lev… One … All conference… Scrap…
#> 5 basketball_all_seasons… All Seasons… Season-lev… One … All conference… Scrap…
#> 6 basketball_all_seasons… All Seasons… Season-lev… One … All seasons re… Scrap…
#> 7 basketball_all_seasons… All Seasons… Season-lev… One … All seasons re… Scrap…
#> 8 basketball_all_seasons… All Seasons… Season-lev… One … All seasons re… Scrap…
#> 9 basketball_game_by_gam… Game-by-Gam… Game-level… One … All game-level… Scrap…
#> 10 basketball_game_by_gam… Game-by-Gam… Game-level… One … All game-level… Scrap…
#> 11 basketball_game_by_gam… Game-by-Gam… Game-level… One … All game-level… Scrap…
#> 12 basketball_game_by_gam… Game-by-Gam… Season-lev… One … All seasons re… Scrap…
#> 13 basketball_game_by_gam… Game-by-Gam… Game-level… One … All game-level… Scrap…
#> 14 basketball_game_high_t… Team Game H… Highest si… One … All seasons re… Scrap…
#> 15 basketball_game_high_i… Individual … Highest si… One … All seasons re… Scrap…
#> 16 basketball_all_cat_lea… All Categor… Player-sea… One … All seasons re… Scrap…
#> # ℹ 5 more variables: primary_key_candidate <chr>, foreign_keys_needed <chr>,
#> # likely_uses <chr>, cleaning_priority <chr>, notes <chr>
cuny_find_tables("scoring")
#> # A tibble: 2 × 11
#> table_name display_name description grain season_coverage source
#> <chr> <chr> <chr> <chr> <chr> <chr>
#> 1 basketball_all_seasons_… All Seasons… Season-lev… One … All seasons re… Scrap…
#> 2 basketball_all_seasons_… All Seasons… Season-lev… One … All seasons re… Scrap…
#> # ℹ 5 more variables: primary_key_candidate <chr>, foreign_keys_needed <chr>,
#> # likely_uses <chr>, cleaning_priority <chr>, notes <chr>