{
  "_id": "6a12d0f3acfb0bcc41d224f6",
  "Package": "afscdata",
  "Title": "An R Package for Extraction of AFSC Fishery Data",
  "Version": "1.0.0",
  "Authors@R": "c(person(given = \"Benjamin\",\nfamily = \"Williams\",\nemail = \"ben.williams@noaa.gov\",\nrole = c(\"aut\", \"cre\")),\nperson(given = \"Jane\",\nfamily = \"Sullivan\",\nemail = \"jane.sullivan@noaa.gov\",\nrole = \"ctb\"),\nperson(given = \"Steve\",\nfamily = \"Barbeaux\",\nrole = \"ctb\"),\nperson(given = \"Pete\",\nfamily = \"Hulson\",\nrole = \"ctb\"),\nperson(given = \"Jim\",\nfamily = \"Ianelli\",\nrole = \"ctb\"),\nperson(given = \"Matt\",\nfamily = \"Callahan\",\nrole = \"ctb\"),\nperson(given = \"Meaghan\",\nfamily = \"Bryan\",\nrole = \"ctb\"),\nperson(given = \"Kalei\",\nfamily = \"Shotwell\",\nrole = \"ctb\"),\nperson(given = \"Margaret\",\nfamily = \"Siple\",\nrole = \"ctb\"))",
  "Maintainer": "The package maintainer <ben.williams@noaa.gov>",
  "Description": "This package provides a folder structure and SQL queries\nfor accessing the AKFIN and AFSC databases in support of\nfishery stock assessments. Additionally, archived data are\nheld/provided to maintain consistency across\nassessments/assessment authors.",
  "License": "MIT + file LICENSE",
  "Encoding": "UTF-8",
  "Roxygen": "list(markdown = TRUE)",
  "RoxygenNote": "7.3.3",
  "URL": "https://afsc-assessments.github.io/afscdata",
  "LazyData": "true",
  "Config/testthat/edition": "3",
  "VignetteBuilder": "knitr",
  "Config/pak/sysreqs": "make libicu-dev libsecret-1-dev unixodbc-dev",
  "Repository": "https://jimianelli.r-universe.dev",
  "Date/Publication": "2026-04-22 22:32:07 UTC",
  "RemoteUrl": "https://github.com/afsc-assessments/afscdata",
  "RemoteRef": "HEAD",
  "RemoteSha": "96ed9cea60f38f65a27553a2b14483e2c6ce3180",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-05-24 10:17:06 UTC",
    "User": "root"
  },
  "Author": "Benjamin Williams [aut, cre],\nJane Sullivan [ctb],\nSteve Barbeaux [ctb],\nPete Hulson [ctb],\nJim Ianelli [ctb],\nMatt Callahan [ctb],\nMeaghan Bryan [ctb],\nKalei Shotwell [ctb],\nMargaret Siple [ctb]",
  "MD5sum": "4bee2fc4966199ea02380d4c8179cc56",
  "_user": "jimianelli",
  "_type": "src",
  "_file": "afscdata_1.0.0.tar.gz",
  "_fileid": "be06b1c3365bbbc465fea8e55c94834c50464f085b856de57c068edd9e4784ad",
  "_filesize": 286767,
  "_sha256": "be06b1c3365bbbc465fea8e55c94834c50464f085b856de57c068edd9e4784ad",
  "_created": "2026-05-24T10:17:06.000Z",
  "_published": "2026-05-24T10:20:35.530Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 77589773503,
      "time": 139,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "NOTE",
      "artifact": "7184333180"
    },
    {
      "job": 77589773487,
      "time": 126,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "NOTE",
      "artifact": "7184332150"
    },
    {
      "job": 77589773505,
      "time": 94,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "NOTE",
      "artifact": "7184329368"
    },
    {
      "job": 77589773492,
      "time": 77,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "NOTE",
      "artifact": "7184327799"
    },
    {
      "job": 77589512299,
      "time": 255,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7184320221"
    },
    {
      "job": 77589773454,
      "time": 117,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7184331329"
    },
    {
      "job": 77589773539,
      "time": 112,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "NOTE",
      "artifact": "7184331180"
    },
    {
      "job": 77589773553,
      "time": 104,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "NOTE",
      "artifact": "7184330327"
    },
    {
      "job": 77589773547,
      "time": 76,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "NOTE",
      "artifact": "7184327794"
    }
  ],
  "_buildurl": "https://github.com/r-universe/jimianelli/actions/runs/26358481638",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/afsc-assessments/afscdata",
  "_commit": {
    "id": "96ed9cea60f38f65a27553a2b14483e2c6ce3180",
    "author": "Ben Williams <ben.williams@noaa.gov>",
    "committer": "Ben Williams <ben.williams@noaa.gov>",
    "message": "norpac\n",
    "time": 1776897127
  },
  "_maintainer": {
    "name": "The package maintainer",
    "email": "ben.williams@noaa.gov",
    "login": "benwilliams-noaa",
    "description": "Research Fisheries Biologist at NOAA's ABL",
    "uuid": 64659151
  },
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 3.5.0",
      "role": "Depends"
    },
    {
      "package": "DBI",
      "role": "Imports"
    },
    {
      "package": "getPass",
      "role": "Imports"
    },
    {
      "package": "here",
      "role": "Imports"
    },
    {
      "package": "keyring",
      "role": "Imports"
    },
    {
      "package": "magrittr",
      "role": "Imports"
    },
    {
      "package": "odbc",
      "role": "Imports"
    },
    {
      "package": "utils",
      "role": "Imports"
    },
    {
      "package": "vroom",
      "role": "Imports"
    },
    {
      "package": "stringi",
      "role": "Imports"
    },
    {
      "package": "tidytable",
      "role": "Imports"
    },
    {
      "package": "dplyr",
      "role": "Imports"
    },
    {
      "package": "lubridate",
      "role": "Imports"
    },
    {
      "package": "stats",
      "role": "Imports"
    },
    {
      "package": "stringr",
      "role": "Imports"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 3.0.0",
      "role": "Suggests"
    },
    {
      "package": "tibble",
      "role": "Suggests"
    }
  ],
  "_owner": "afsc-assessments",
  "_selfowned": false,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2025-50",
      "n": 3
    },
    {
      "week": "2026-11",
      "n": 5
    },
    {
      "week": "2026-14",
      "n": 10
    },
    {
      "week": "2026-15",
      "n": 2
    },
    {
      "week": "2026-17",
      "n": 4
    }
  ],
  "_tags": [
    {
      "name": "v1.0.0",
      "date": "2026-04-03"
    }
  ],
  "_stars": 2,
  "_contributors": [
    {
      "user": "benwilliams-noaa",
      "count": 248,
      "uuid": 64659151
    },
    {
      "user": "mkapur-noaa",
      "count": 43,
      "uuid": 39382798
    },
    {
      "user": "janesullivan-noaa",
      "count": 6,
      "uuid": 68303089
    },
    {
      "user": "pete-hulson",
      "count": 2,
      "uuid": 5578975
    }
  ],
  "_userbio": {
    "uuid": 2715618,
    "type": "user",
    "name": "Jim Ianelli"
  },
  "_downloads": {
    "count": 0,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/afscdata"
  },
  "_devurl": "https://github.com/afsc-assessments/afscdata",
  "_pkgdown": "https://afsc-assessments.github.io/afscdata",
  "_searchresults": 25,
  "_rbuild": "4.6.0",
  "_assets": [
    "extra/afscdata.html",
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/readme.html",
    "extra/readme.md",
    "manual.pdf"
  ],
  "_cranurl": false,
  "_exports": [
    "%>%",
    "accepted_model",
    "bsai_amak",
    "bsai_atf",
    "bsai_fhs",
    "bsai_nrs",
    "bsai_octopus",
    "bsai_orox",
    "catch_to_ss3",
    "collapse_filters",
    "connect",
    "disconnect",
    "gap_check_bio",
    "goa_amak",
    "goa_atf",
    "goa_dusk",
    "goa_fhs",
    "goa_nork",
    "goa_octopus",
    "goa_pop",
    "goa_rebs",
    "goa_shal_flats",
    "goa_thornyhead",
    "q_bts_agecomp",
    "q_bts_biomass",
    "q_bts_gap_agecomp",
    "q_bts_gap_length",
    "q_bts_gap_sizecomp",
    "q_bts_gap_specimen",
    "q_bts_length",
    "q_bts_sizecomp",
    "q_bts_specimen",
    "q_catch",
    "q_catch_foreign",
    "q_date",
    "q_fish_obs",
    "q_fish_ticket",
    "q_fsh_length",
    "q_fsh_specimen",
    "q_gap_biomass",
    "q_lls_length",
    "q_lls_rpn",
    "q_lls_rpn_length",
    "q_lls_sable_specimen",
    "q_nontarget",
    "q_psc",
    "q_specs",
    "setup_folders",
    "sharks",
    "sql_filter",
    "sql_read",
    "sql_run"
  ],
  "_datasets": [
    {
      "name": "bsai_amak_catch_1977_1990",
      "title": "BSAI Atka mackerel historical catch",
      "object": "bsai_amak_catch_1977_1990",
      "class": [
        "spec_tbl_df",
        "tbl_df",
        "tbl",
        "data.frame"
      ],
      "fields": [
        "year",
        "catch"
      ],
      "rows": 14,
      "table": true,
      "tojson": true
    },
    {
      "name": "bsai_fhs_catch_1964_1994",
      "title": "BSAI flathead sole historical catch data 1964-1994",
      "object": "bsai_fhs_catch_1964_1994",
      "class": [
        "data.frame"
      ],
      "fields": [
        "year",
        "catch"
      ],
      "rows": 31,
      "table": true,
      "tojson": true
    },
    {
      "name": "fmp_key",
      "title": "Sablefish fmp area key by location",
      "object": "fmp_key",
      "class": [
        "data.frame"
      ],
      "fields": [
        "loc",
        "FMP_SUBAREA"
      ],
      "rows": 923,
      "table": true,
      "tojson": true
    },
    {
      "name": "goa_atf_catch_1961_1990",
      "title": "GOA arrowtooth flounder historical catch data",
      "object": "goa_atf_catch_1961_1990",
      "class": [
        "data.frame"
      ],
      "fields": [
        "Year",
        "Catch"
      ],
      "rows": 30,
      "table": true,
      "tojson": true
    },
    {
      "name": "goa_dusk_catch_1977_1990",
      "title": "GOA dusky rockfish historical catch data",
      "object": "goa_dusk_catch_1977_1990",
      "class": [
        "data.frame"
      ],
      "fields": [
        "year",
        "catch"
      ],
      "rows": 14,
      "table": true,
      "tojson": true
    },
    {
      "name": "goa_fhs_catch_1978_1990",
      "title": "GOA flathead sole historical catch",
      "object": "goa_fhs_catch_1978_1990",
      "class": [
        "data.frame"
      ],
      "fields": [
        "year",
        "catch"
      ],
      "rows": 13,
      "table": true,
      "tojson": true
    },
    {
      "name": "goa_nork_catch_1961_1992",
      "title": "GOA northern rockfish historical catch data",
      "object": "goa_nork_catch_1961_1992",
      "class": [
        "data.frame"
      ],
      "fields": [
        "Year",
        "Catch"
      ],
      "rows": 32,
      "table": true,
      "tojson": true
    },
    {
      "name": "goa_pcod_catch_1977_1990",
      "title": "GOA Pacific cod historical catch",
      "object": "goa_pcod_catch_1977_1990",
      "class": [
        "data.frame"
      ],
      "fields": [
        "tons",
        "gear",
        "year",
        "season"
      ],
      "rows": 280,
      "table": true,
      "tojson": true
    },
    {
      "name": "goa_pcod_larval_indices",
      "title": "GOA Pacific cod historical larval index data",
      "object": "goa_pcod_larval_indices",
      "class": [
        "data.frame"
      ],
      "fields": [
        "year",
        "seas",
        "index",
        "obs",
        "se_log"
      ],
      "rows": 92,
      "table": true,
      "tojson": true
    },
    {
      "name": "goa_pop_catch_1960_1990",
      "title": "GOA POP historical catch data",
      "object": "goa_pop_catch_1960_1990",
      "class": [
        "data.frame"
      ],
      "fields": [
        "year",
        "catch"
      ],
      "rows": 30,
      "table": true,
      "tojson": true
    },
    {
      "name": "goa_pop_fixed_fish_length_comp",
      "title": "GOA POP historical fishery length comp data",
      "object": "goa_pop_fixed_fish_length_comp",
      "class": [
        "tbl_df",
        "tbl",
        "data.frame"
      ],
      "fields": [
        "Length",
        "value",
        "year",
        "hauls_sampled"
      ],
      "rows": 765,
      "table": true,
      "tojson": true
    },
    {
      "name": "goa_rebs_catch_1977_2004",
      "title": "GOA rougheye/blackspotted rockfish historical catch data",
      "object": "goa_rebs_catch_1977_2004",
      "class": [
        "data.frame"
      ],
      "fields": [
        "year",
        "catch"
      ],
      "rows": 28,
      "table": true,
      "tojson": true
    },
    {
      "name": "saa_pop_60",
      "title": "GOA POP historical size at age parameters data",
      "object": "saa_pop_60",
      "class": [
        "data.frame"
      ],
      "fields": [
        "linf",
        "k",
        "t0",
        "a",
        "b"
      ],
      "rows": 1,
      "table": true,
      "tojson": true
    },
    {
      "name": "sabl_fixed_abundance",
      "title": "Sablefish historical abundance data",
      "object": "sabl_fixed_abundance",
      "class": [
        "data.frame"
      ],
      "fields": [
        "year",
        "value",
        "variable",
        "gear",
        "fleet"
      ],
      "rows": 119,
      "table": true,
      "tojson": true
    },
    {
      "name": "sabl_fixed_comps",
      "title": "Sablefish age and length comp data",
      "object": "sabl_fixed_comps",
      "class": [
        "data.frame"
      ],
      "fields": [
        "year",
        "fleet",
        "type",
        "gear",
        "age",
        "length",
        "comp",
        "sex"
      ],
      "rows": 2010,
      "table": true,
      "tojson": true
    },
    {
      "name": "sabl_new_areas",
      "title": "Sablefish defining areas for age samples",
      "object": "sabl_new_areas",
      "class": [
        "data.frame"
      ],
      "fields": [
        "NMFS_AREA",
        "AREA_NAME"
      ],
      "rows": 15,
      "table": true,
      "tojson": true
    },
    {
      "name": "sabl_vessel_lengths",
      "title": "vessel lengths",
      "object": "sabl_vessel_lengths",
      "class": [
        "spec_tbl_df",
        "tbl_df",
        "tbl",
        "data.frame"
      ],
      "fields": [
        "VESSEL_CODE",
        "LENGTH"
      ],
      "rows": 7558,
      "table": true,
      "tojson": true
    },
    {
      "name": "sabl_waa",
      "title": "Sablefish fixed weights at age",
      "object": "sabl_waa",
      "class": [
        "data.frame"
      ],
      "fields": [
        "waa",
        "sex",
        "timeblock"
      ],
      "rows": 120,
      "table": true,
      "tojson": true
    }
  ],
  "_help": [
    {
      "page": "accepted_model",
      "title": "copy the previous SSC accepted model as the new \"base\" model",
      "topics": [
        "accepted_model"
      ]
    },
    {
      "page": "bsai_amak",
      "title": "raw data query for the BSAI Atka mackerel assessment",
      "topics": [
        "bsai_amak"
      ]
    },
    {
      "page": "bsai_amak_catch_1977_1990",
      "title": "BSAI Atka mackerel historical catch",
      "topics": [
        "bsai_amak_catch_1977_1990"
      ]
    },
    {
      "page": "bsai_atf",
      "title": "raw data query for BSAI arrowtooth flounder",
      "topics": [
        "bsai_atf"
      ]
    },
    {
      "page": "bsai_fhs",
      "title": "raw data query for BSAI flathead sole",
      "topics": [
        "bsai_fhs"
      ]
    },
    {
      "page": "bsai_fhs_catch_1964_1994",
      "title": "BSAI flathead sole historical catch data 1964-1994",
      "topics": [
        "bsai_fhs_catch_1964_1994"
      ]
    },
    {
      "page": "bsai_nrs",
      "title": "raw data query for BSAI northern rocksole",
      "topics": [
        "bsai_nrs"
      ]
    },
    {
      "page": "bsai_octopus",
      "title": "raw data query for BSAI octopus",
      "topics": [
        "bsai_octopus"
      ]
    },
    {
      "page": "bsai_orox",
      "title": "raw data query for BSAI other rockfish",
      "topics": [
        "bsai_orox"
      ]
    },
    {
      "page": "catch_to_ss3",
      "title": "Reformat Catch to SS3 structure currently only handles a single fleet, values in t",
      "topics": [
        "catch_to_ss3"
      ]
    },
    {
      "page": "collapse_filters",
      "title": "utility function for sql queries",
      "topics": [
        "collapse_filters"
      ]
    },
    {
      "page": "connect",
      "title": "utility function to connect to server",
      "topics": [
        "connect"
      ]
    },
    {
      "page": "disconnect",
      "title": "utility function to disconnect from server",
      "topics": [
        "disconnect"
      ]
    },
    {
      "page": "fmp_key",
      "title": "Sablefish fmp area key by location",
      "topics": [
        "fmp_key"
      ]
    },
    {
      "page": "gap_check_bio",
      "title": "compare GAP updated survey biomass to (now) retired design-based biomass estimates",
      "topics": [
        "gap_check_bio"
      ]
    },
    {
      "page": "goa_amak",
      "title": "raw data query for the GOA Atka mackerel assessment",
      "topics": [
        "goa_amak"
      ]
    },
    {
      "page": "goa_atf",
      "title": "raw data query for GOA arrowtooth founder",
      "topics": [
        "goa_atf"
      ]
    },
    {
      "page": "goa_atf_catch_1961_1990",
      "title": "GOA arrowtooth flounder historical catch data",
      "topics": [
        "goa_atf_catch_1961_1990"
      ]
    },
    {
      "page": "goa_dusk",
      "title": "raw data query for GOA dusky rockfish",
      "topics": [
        "goa_dusk"
      ]
    },
    {
      "page": "goa_dusk_catch_1977_1990",
      "title": "GOA dusky rockfish historical catch data",
      "topics": [
        "goa_dusk_catch_1977_1990"
      ]
    },
    {
      "page": "goa_fhs",
      "title": "raw data query for GOA flathead sole",
      "topics": [
        "goa_fhs"
      ]
    },
    {
      "page": "goa_fhs_catch_1978_1990",
      "title": "GOA flathead sole historical catch",
      "topics": [
        "goa_fhs_catch_1978_1990"
      ]
    },
    {
      "page": "goa_nork",
      "title": "raw data query for GOA northern rockfish",
      "topics": [
        "goa_nork"
      ]
    },
    {
      "page": "goa_nork_catch_1961_1992",
      "title": "GOA northern rockfish historical catch data",
      "topics": [
        "goa_nork_catch_1961_1992"
      ]
    },
    {
      "page": "goa_octopus",
      "title": "raw data query for GOA octopus",
      "topics": [
        "goa_octopus"
      ]
    },
    {
      "page": "goa_pcod_catch_1977_1990",
      "title": "GOA Pacific cod historical catch",
      "topics": [
        "goa_pcod_catch_1977_1990"
      ]
    },
    {
      "page": "goa_pcod_larval_indices",
      "title": "GOA Pacific cod historical larval index data",
      "topics": [
        "goa_pcod_larval_indices"
      ]
    },
    {
      "page": "goa_pop",
      "title": "raw data query for GOA POP",
      "topics": [
        "goa_pop"
      ]
    },
    {
      "page": "goa_pop_catch_1960_1990",
      "title": "GOA POP historical catch data",
      "topics": [
        "goa_pop_catch_1960_1990"
      ]
    },
    {
      "page": "goa_pop_fixed_fish_length_comp",
      "title": "GOA POP historical fishery length comp data",
      "topics": [
        "goa_pop_fixed_fish_length_comp"
      ]
    },
    {
      "page": "goa_rebs",
      "title": "raw data query for GOA rougheye/blackspotted rockfish",
      "topics": [
        "goa_rebs"
      ]
    },
    {
      "page": "goa_rebs_catch_1977_2004",
      "title": "GOA rougheye/blackspotted rockfish historical catch data",
      "topics": [
        "goa_rebs_catch_1977_2004"
      ]
    },
    {
      "page": "goa_shal_flats",
      "title": "raw data query for GOA shallow-water flatfish",
      "topics": [
        "goa_shal_flats"
      ]
    },
    {
      "page": "goa_thornyhead",
      "title": "raw data query for GOA thorynhead rockfish",
      "topics": [
        "goa_thornyhead"
      ]
    },
    {
      "page": "q_bts_agecomp",
      "title": "query bottom trawl survey agecomps",
      "topics": [
        "q_bts_agecomp"
      ]
    },
    {
      "page": "q_bts_biomass",
      "title": "query bottom trawl survey biomass",
      "topics": [
        "q_bts_biomass"
      ]
    },
    {
      "page": "q_bts_gap_agecomp",
      "title": "query GAP bottom trawl survey agecomps",
      "topics": [
        "q_bts_gap_agecomp"
      ]
    },
    {
      "page": "q_bts_gap_length",
      "title": "query bottom trawl survey length data from GAP on the AKFIN server",
      "topics": [
        "q_bts_gap_length"
      ]
    },
    {
      "page": "q_bts_gap_sizecomp",
      "title": "query GAP bottom trawl survey sizecomps",
      "topics": [
        "q_bts_gap_sizecomp"
      ]
    },
    {
      "page": "q_bts_gap_specimen",
      "title": "query GAP bottom trawl survey specimen data from the AKFIN server",
      "topics": [
        "q_bts_gap_specimen"
      ]
    },
    {
      "page": "q_bts_length",
      "title": "query bottom trawl survey length data from the AFSC server",
      "topics": [
        "q_bts_length"
      ]
    },
    {
      "page": "q_bts_sizecomp",
      "title": "query bottom trawl survey sizecomps",
      "topics": [
        "q_bts_sizecomp"
      ]
    },
    {
      "page": "q_bts_specimen",
      "title": "query bottom trawl survey specimen data from the AFSC server",
      "topics": [
        "q_bts_specimen"
      ]
    },
    {
      "page": "q_catch",
      "title": "query fishery catch data from AKFIN server",
      "topics": [
        "q_catch"
      ]
    },
    {
      "page": "q_catch_foreign",
      "title": "query foreign catch data from the AKFIN server",
      "topics": [
        "q_catch_foreign"
      ]
    },
    {
      "page": "q_date",
      "title": "utility function for date of data query",
      "topics": [
        "q_date"
      ]
    },
    {
      "page": "q_fish_obs",
      "title": "fishery observer data query",
      "topics": [
        "q_fish_obs"
      ]
    },
    {
      "page": "q_fish_ticket",
      "title": "query fish ticket data",
      "topics": [
        "q_fish_ticket"
      ]
    },
    {
      "page": "q_fsh_length",
      "title": "query fishery length data from the AKFIN server",
      "topics": [
        "q_fsh_length"
      ]
    },
    {
      "page": "q_fsh_specimen",
      "title": "query fishery specimen data from the AKFIN server",
      "topics": [
        "q_fsh_specimen"
      ]
    },
    {
      "page": "q_gap_biomass",
      "title": "query GAP products bottom trawl survey biomass note: pay attention to the 'design_year' column, particularly for region or depth queries as there may be data duplicates",
      "topics": [
        "q_gap_biomass"
      ]
    },
    {
      "page": "q_lls_length",
      "title": "query nmfs longline survey raw length frequencies at the depth stratum and station level",
      "topics": [
        "q_lls_length"
      ]
    },
    {
      "page": "q_lls_rpn",
      "title": "query nfms longline survey relative population numbers or weights",
      "topics": [
        "q_lls_rpn"
      ]
    },
    {
      "page": "q_lls_rpn_length",
      "title": "query nfms longline survey rpn-weighted length frequencies",
      "topics": [
        "q_lls_rpn_length"
      ]
    },
    {
      "page": "q_lls_sable_specimen",
      "title": "query nmfs longine survey specimen data (age, length, weight, sex, maturity). only available for sablefish!",
      "topics": [
        "q_lls_sable_specimen"
      ]
    },
    {
      "page": "q_nontarget",
      "title": "query non-target species catch estimate",
      "topics": [
        "q_nontarget"
      ]
    },
    {
      "page": "q_psc",
      "title": "query prohibited species catch (psc) estimate",
      "topics": [
        "q_psc"
      ]
    },
    {
      "page": "q_specs",
      "title": "Query specs",
      "topics": [
        "q_specs"
      ]
    },
    {
      "page": "saa_pop_60",
      "title": "GOA POP historical size at age parameters data",
      "topics": [
        "saa_pop_60"
      ]
    },
    {
      "page": "sabl_fixed_abundance",
      "title": "Sablefish historical abundance data",
      "topics": [
        "sabl_fixed_abundance"
      ]
    },
    {
      "page": "sabl_fixed_comps",
      "title": "Sablefish age and length comp data",
      "topics": [
        "sabl_fixed_comps"
      ]
    },
    {
      "page": "sabl_new_areas",
      "title": "Sablefish defining areas for age samples",
      "topics": [
        "sabl_new_areas"
      ]
    },
    {
      "page": "sabl_vessel_lengths",
      "title": "vessel lengths",
      "topics": [
        "sabl_vessel_lengths"
      ]
    },
    {
      "page": "sabl_waa",
      "title": "Sablefish fixed weights at age",
      "topics": [
        "sabl_waa"
      ]
    },
    {
      "page": "setup_folders",
      "title": "Setup folder structure",
      "topics": [
        "setup_folders"
      ]
    },
    {
      "page": "sharks",
      "title": "raw data query for GOA/BSAI sharks",
      "topics": [
        "sharks"
      ]
    },
    {
      "page": "sql_filter",
      "title": "utility function to filter sql files",
      "topics": [
        "sql_filter"
      ]
    },
    {
      "page": "sql_read",
      "title": "utility function to read sql file",
      "topics": [
        "sql_read"
      ]
    },
    {
      "page": "sql_run",
      "title": "utility function to run sql query",
      "topics": [
        "sql_run"
      ]
    }
  ],
  "_readme": "https://github.com/afsc-assessments/afscdata/raw/HEAD/README.md",
  "_rundeps": [
    "askpass",
    "bit",
    "bit64",
    "blob",
    "cli",
    "cpp11",
    "crayon",
    "data.table",
    "DBI",
    "dplyr",
    "filelock",
    "generics",
    "getPass",
    "glue",
    "here",
    "hms",
    "keyring",
    "lifecycle",
    "lubridate",
    "magrittr",
    "odbc",
    "pillar",
    "pkgconfig",
    "prettyunits",
    "progress",
    "R6",
    "Rcpp",
    "rlang",
    "rprojroot",
    "rstudioapi",
    "stringi",
    "stringr",
    "sys",
    "tibble",
    "tidyselect",
    "tidytable",
    "timechange",
    "tzdb",
    "utf8",
    "vctrs",
    "vroom",
    "withr",
    "yaml"
  ],
  "_vignettes": [
    {
      "source": "development.Rmd",
      "filename": "development.html",
      "title": "Development",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Primary goals",
        "Collaboration",
        "Coding style",
        "Suggested norms - General",
        "Organization",
        "Projects",
        "Example folder structure",
        "Scripts",
        "Structure guide",
        "Style guide",
        "Naming conventions",
        "Object names",
        "Dates",
        "Spacing",
        "Writing functions",
        "Function components",
        "Suggested norms - Specific",
        "Framework",
        "Code framework",
        "Teams framework"
      ],
      "created": "2026-04-03 17:41:53",
      "modified": "2026-04-03 17:41:53",
      "commits": 1
    },
    {
      "source": "gap_check.Rmd",
      "filename": "gap_check.html",
      "title": "gap_check",
      "engine": "knitr::rmarkdown",
      "headings": [],
      "created": "2026-04-03 17:41:53",
      "modified": "2026-04-03 17:41:53",
      "commits": 1
    },
    {
      "source": "getting-started.Rmd",
      "filename": "getting-started.html",
      "title": "Getting started",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Additional functionality",
        "Example script"
      ],
      "created": "2026-04-03 17:41:53",
      "modified": "2026-04-03 17:41:53",
      "commits": 1
    }
  ],
  "_score": 5.051152522447381,
  "_indexed": false,
  "_nocasepkg": "afscdata",
  "_universes": [
    "jimianelli"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.0.0",
      "date": "2026-05-24T10:20:00.000Z",
      "distro": "noble",
      "commit": "96ed9cea60f38f65a27553a2b14483e2c6ce3180",
      "fileid": "2570424d627f0cb903b7198b4c7b07b28f68cc9757797020278e9b306f3ca493",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/jimianelli/actions/runs/26358481638"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "1.0.0",
      "date": "2026-05-24T10:19:54.000Z",
      "distro": "noble",
      "commit": "96ed9cea60f38f65a27553a2b14483e2c6ce3180",
      "fileid": "d7ef45afd5900a69ac902782b103a55ae076066c605da6c7ea247ec2a392abb9",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/jimianelli/actions/runs/26358481638"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.0.0",
      "date": "2026-05-24T10:19:23.000Z",
      "commit": "96ed9cea60f38f65a27553a2b14483e2c6ce3180",
      "fileid": "6553d3f85f61ae3ce78406d0aaf114b12d5bc42a0108375ce6e282b2da33a5ff",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/jimianelli/actions/runs/26358481638"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "1.0.0",
      "date": "2026-05-24T10:19:09.000Z",
      "commit": "96ed9cea60f38f65a27553a2b14483e2c6ce3180",
      "fileid": "effd0e328f8036a4148e7d1ee5061a83370dda5c23ca149e0b8b64a7f5bd8a61",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/jimianelli/actions/runs/26358481638"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "1.0.0",
      "date": "2026-05-24T10:19:58.000Z",
      "commit": "96ed9cea60f38f65a27553a2b14483e2c6ce3180",
      "fileid": "0ef7c0ea810b4bcdd60971c15c09a63e34bfee131b7c38db2ffa2a80306c2f59",
      "status": "success",
      "buildurl": "https://github.com/r-universe/jimianelli/actions/runs/26358481638"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.0.0",
      "date": "2026-05-24T10:19:27.000Z",
      "commit": "96ed9cea60f38f65a27553a2b14483e2c6ce3180",
      "fileid": "f5f54cfb19aba829e330b88fb6ca8f96fca0cba630ad827118719d36f9fb5785",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/jimianelli/actions/runs/26358481638"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "1.0.0",
      "date": "2026-05-24T10:19:29.000Z",
      "commit": "96ed9cea60f38f65a27553a2b14483e2c6ce3180",
      "fileid": "864232d313210cb8a5e852e96c25341fa435e302b0e5c0cb2e92ce81f98994cd",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/jimianelli/actions/runs/26358481638"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "1.0.0",
      "date": "2026-05-24T10:18:59.000Z",
      "commit": "96ed9cea60f38f65a27553a2b14483e2c6ce3180",
      "fileid": "d85d36ea7fd9459d26f4d8b9a7a354eb6378191afaecb5e048e78874b880f879",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/jimianelli/actions/runs/26358481638"
    }
  ]
}