Read the tables and columns from the following CalCOFI API
and display as an interactive table (as DT::datatable()):
cc_db_catalog(tables = NULL)DT::datatable() of tables and columns
# full catalog
cc_db_catalog()
#> Error in mutate(d, Table = purrr::pmap_chr(list(table_type, table, table_description), function(table_type, table, table_description, ...) { ifelse(is.na(table_description), as.character(htmltools::div(htmltools::span(style = "font-weight: 400;", htmltools::em(table_type), ":"), htmltools::strong(table))), as.character(htmltools::div(htmltools::span(style = "font-weight: 400;", htmltools::em(table_type), ":"), htmltools::strong(table), htmltools::div(style = "font-size: 0.75rem; font-weight: 400;", htmltools::HTML(markdown::mark(table_description)))))) }), Column = purrr::pmap_chr(list(column, column_type, column_description), function(column, column_type, column_description, ...) { ifelse(is.na(column_description), as.character(htmltools::div(htmltools::strong(column), htmltools::span(style = "font-weight: 400;", "(", htmltools::em(column_type), ")"))), as.character(htmltools::div(htmltools::strong(column), htmltools::span(style = "font-weight: 400;", "(", htmltools::em(column_type), ")"), htmltools::div(style = "font-size: 0.75rem; font-weight: 400;", htmltools::HTML(markdown::mark(column_description)))))) })): ℹ In argument: `Column = purrr::pmap_chr(...)`.
#> Caused by error in `purrr::pmap_chr()`:
#> ℹ In index: 200.
#> Caused by error in `file()`:
#> ! cannot open the connection
# only certain tables
cc_db_catalog(tables = c("larvae_counts","nets","tows","stations","cruises"))