{
  "_id": "6ac77a18de46216d5edd088f",
  "Package": "ojodb",
  "Title": "Analyze Data from the Open Justice Oklahoma Database",
  "Version": "2.11.1",
  "Authors@R": "c(\nperson(\ngiven = \"Brancen\",\nfamily = \"Gregory\",\nemail = \"brancengregory@gmail.com\",\nrole = c(\"cre\", \"aut\")\n),\nperson(\ngiven = \"Ryan\",\nfamily = \"Gentzler\",\nemail = \"ryan.gentzler@gmail.com\",\nrole = \"aut\"\n),\nperson(\ngiven = \"Andrew\",\nfamily = \"Bell\",\nemail = \"abell@okpolicy.org\",\nrole = \"aut\"\n),\nperson(\ngiven = \"Anthony\",\nfamily = \"Flores\",\nemail = \"aflores@okpolicy.org\",\nrole = \"aut\"\n),\nperson(\ngiven = \"Elizabeth\",\nfamily = \"Spencer\",\nrole = \"ctb\"\n))",
  "Description": "{ojodb} provides convenient functions to query court data\nfrom the Open Justice Oklahoma database.",
  "Remotes": [
    "nx10/httpgd"
  ],
  "License": "GPL (>= 3)",
  "Encoding": "UTF-8",
  "RoxygenNote": "7.3.2",
  "VignetteBuilder": "knitr",
  "Config/testthat/edition": "3",
  "Config/testthat/parallel": "true",
  "URL": "https://github.com/openjusticeok/ojodb",
  "BugReports": "https://github.com/openjusticeok/ojodb/issues",
  "Roxygen": "list(markdown = TRUE)",
  "Config/pak/sysreqs": "libicu-dev libpq-dev",
  "Repository": "https://openjusticeok.r-universe.dev",
  "Date/Publication": "2025-07-01 19:58:46 UTC",
  "RemoteUrl": "https://github.com/openjusticeok/ojodb",
  "RemoteRef": "HEAD",
  "RemoteSha": "3334765296ef5f054849b14db264463a7272441e",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-10-08 10:15:04 UTC",
    "User": "root"
  },
  "Author": "Brancen Gregory [cre, aut],\nRyan Gentzler [aut],\nAndrew Bell [aut],\nAnthony Flores [aut],\nElizabeth Spencer [ctb]",
  "Maintainer": "Brancen Gregory <brancengregory@gmail.com>",
  "_user": "openjusticeok",
  "_type": "src",
  "_file": "ojodb_2.11.1.tar.gz",
  "_fileid": "https://r2.ropensci.org/45e4282b7a0de4f90b203e794d9d72f25d933f2105c4da1cd0881c31f7c90a9e",
  "_filesize": 6219696,
  "_sha256": "45e4282b7a0de4f90b203e794d9d72f25d933f2105c4da1cd0881c31f7c90a9e",
  "_expires": "2027-01-16T11:10:14.000Z",
  "_created": "2026-10-08T10:15:04.000Z",
  "_published": "2026-10-08T11:10:16.685Z",
  "_buildurl": "https://github.com/r-universe/openjusticeok/actions/runs/37761756793",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_jobs": [
    {
      "job": 113261325361,
      "time": 158,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "NOTE",
      "artifact": "11543360457"
    },
    {
      "job": 113261325483,
      "time": 205,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "NOTE",
      "artifact": "11542653478"
    },
    {
      "job": 113261325093,
      "time": 149,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "NOTE",
      "artifact": "11545971771"
    },
    {
      "job": 113261325117,
      "time": 146,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "NOTE",
      "artifact": "11545727398"
    },
    {
      "job": 113259794368,
      "time": 245,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11542089998"
    },
    {
      "job": 113261325052,
      "time": 125,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "11543275808"
    },
    {
      "job": 113261325108,
      "time": 128,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "NOTE",
      "artifact": "11543146076"
    },
    {
      "job": 113261325064,
      "time": 80,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "NOTE",
      "artifact": "11543151246"
    },
    {
      "job": 113261325114,
      "time": 101,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "NOTE",
      "artifact": "11542782401"
    }
  ],
  "_upstream": "https://github.com/openjusticeok/ojodb",
  "_commit": {
    "id": "3334765296ef5f054849b14db264463a7272441e",
    "author": "Brancen Gregory <brancengregory@gmail.com>",
    "committer": "GitHub <noreply@github.com>",
    "message": "Add remote for httpgd (#182)\n\n* Add remote for httpgd\n\n* Update wordlist",
    "time": 1751399926
  },
  "_maintainer": {
    "name": "Brancen Gregory",
    "email": "brancengregory@gmail.com",
    "login": "brancengregory",
    "twitter": "@brancengregory",
    "description": "",
    "uuid": 13408602
  },
  "_distro": "resolute",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 4.1.0",
      "role": "Depends"
    },
    {
      "package": "dplyr",
      "role": "Depends"
    },
    {
      "package": "cli",
      "role": "Imports"
    },
    {
      "package": "dbplyr",
      "role": "Imports"
    },
    {
      "package": "DBI",
      "role": "Imports"
    },
    {
      "package": "ggplot2",
      "role": "Imports"
    },
    {
      "package": "glue",
      "role": "Imports"
    },
    {
      "package": "lifecycle",
      "role": "Imports"
    },
    {
      "package": "lubridate",
      "role": "Imports"
    },
    {
      "package": "pool",
      "role": "Imports"
    },
    {
      "package": "purrr",
      "role": "Imports"
    },
    {
      "package": "rlang",
      "role": "Imports"
    },
    {
      "package": "RPostgres",
      "role": "Imports"
    },
    {
      "package": "stringi",
      "role": "Imports"
    },
    {
      "package": "stringr",
      "role": "Imports"
    },
    {
      "package": "tibble",
      "role": "Imports"
    },
    {
      "package": "tidyr",
      "role": "Imports"
    },
    {
      "package": "utils",
      "role": "Imports"
    },
    {
      "package": "withr",
      "role": "Imports"
    },
    {
      "package": "arrow",
      "role": "Suggests"
    },
    {
      "package": "attachment",
      "role": "Suggests"
    },
    {
      "package": "badger",
      "role": "Suggests"
    },
    {
      "package": "covr",
      "role": "Suggests"
    },
    {
      "package": "devtools",
      "role": "Suggests"
    },
    {
      "package": "duckdb",
      "role": "Suggests"
    },
    {
      "package": "fledge",
      "role": "Suggests"
    },
    {
      "package": "fs",
      "role": "Suggests"
    },
    {
      "package": "httpgd",
      "role": "Suggests"
    },
    {
      "package": "httr",
      "role": "Suggests"
    },
    {
      "package": "janitor",
      "role": "Suggests"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "languageserver",
      "role": "Suggests"
    },
    {
      "package": "lintr",
      "role": "Suggests"
    },
    {
      "package": "readr",
      "role": "Suggests"
    },
    {
      "package": "roxygen2",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "rvest",
      "role": "Suggests"
    },
    {
      "package": "styler",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 3.0.0",
      "role": "Suggests"
    },
    {
      "package": "tidycensus",
      "role": "Suggests"
    },
    {
      "package": "usethis",
      "role": "Suggests"
    },
    {
      "package": "xml2",
      "role": "Suggests"
    }
  ],
  "_owner": "openjusticeok",
  "_selfowned": true,
  "_usedby": 1,
  "_updates": [],
  "_tags": [],
  "_topics": [
    "courts",
    "justice",
    "oklahoma",
    "open-data"
  ],
  "_stars": 9,
  "_contributors": [
    {
      "user": "brancengregory",
      "count": 251,
      "uuid": 13408602
    },
    {
      "user": "rcgentzler",
      "count": 98,
      "uuid": 34402708
    },
    {
      "user": "andrewjbe",
      "count": 19,
      "uuid": 56839927
    },
    {
      "user": "anthonyokc",
      "count": 1,
      "uuid": 70184250
    },
    {
      "user": "espencer14",
      "count": 1,
      "uuid": 54410865
    }
  ],
  "_userbio": {
    "uuid": 60518990,
    "type": "organization",
    "name": "Oklahoma Policy Institute",
    "followers": 14
  },
  "_downloads": {
    "count": 0,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/ojodb"
  },
  "_devurl": "https://github.com/openjusticeok/ojodb",
  "_searchresults": 68,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/manual.pdf",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/ojodb.html",
    "extra/readme.html",
    "extra/readme.md"
  ],
  "_cranurl": false,
  "_exports": [
    "ojo_add_counts",
    "ojo_add_issues",
    "ojo_add_minutes",
    "ojo_add_party_details",
    "ojo_auth",
    "ojo_case_types",
    "ojo_check_ssl",
    "ojo_civ_cases",
    "ojo_collect",
    "ojo_color",
    "ojo_connect",
    "ojo_county_population",
    "ojo_crim_cases",
    "ojo_env",
    "ojo_eviction_cases",
    "ojo_fill",
    "ojo_fiscal_year",
    "ojo_list_schemas",
    "ojo_list_tables",
    "ojo_list_vars",
    "ojo_pal",
    "ojo_query",
    "ojo_search_minutes",
    "ojo_show_row",
    "ojo_tbl",
    "ojo_theme",
    "ojo_version"
  ],
  "_help": [
    {
      "page": "ojo_add_counts",
      "title": "Add counts to a tibble of cases",
      "topics": [
        "ojo_add_counts"
      ]
    },
    {
      "page": "ojo_add_issues",
      "title": "Add issues to civil cases",
      "topics": [
        "ojo_add_issues"
      ]
    },
    {
      "page": "ojo_add_minutes",
      "title": "Query minutes for a given case",
      "topics": [
        "ojo_add_minutes"
      ]
    },
    {
      "page": "ojo_add_party_details",
      "title": "Add party details to a parties query",
      "topics": [
        "ojo_add_party_details"
      ]
    },
    {
      "page": "ojo_auth",
      "title": "Create configuration for OJO database connection",
      "topics": [
        "ojo_auth"
      ]
    },
    {
      "page": "ojo_case_types",
      "title": "List the case types present in the OJO database",
      "topics": [
        "ojo_case_types"
      ]
    },
    {
      "page": "ojo_check_ssl",
      "title": "Check whether the database connection is using SSL properly",
      "topics": [
        "ojo_check_ssl"
      ]
    },
    {
      "page": "ojo_civ_cases",
      "title": "Query civil cases from the OJO database",
      "topics": [
        "ojo_civ_cases"
      ]
    },
    {
      "page": "ojo_collect",
      "title": "OJO Collect",
      "topics": [
        "ojo_collect"
      ]
    },
    {
      "page": "ojo_color",
      "title": "Add OJO styling to a ggplot",
      "topics": [
        "ojo_color"
      ]
    },
    {
      "page": "ojo_connect",
      "title": "OJO Connect",
      "topics": [
        "ojo_connect"
      ]
    },
    {
      "page": "ojo_county_population",
      "title": "Get population data by county for Oklahoma from the Census Bureau's American Community Survey",
      "topics": [
        "ojo_county_population"
      ]
    },
    {
      "page": "ojo_crim_cases",
      "title": "Query criminal cases from the OJO database",
      "topics": [
        "ojo_crim_cases"
      ]
    },
    {
      "page": "ojo_env",
      "title": "OJO Environment",
      "topics": [
        "ojo_env"
      ]
    },
    {
      "page": "ojo_eviction_cases",
      "title": "OJO Eviction Cases",
      "topics": [
        "ojo_eviction_cases"
      ]
    },
    {
      "page": "ojo_fill",
      "title": "Add OJO styling to a ggplot",
      "topics": [
        "ojo_fill"
      ]
    },
    {
      "page": "ojo_fiscal_year",
      "title": "Determine the Oklahoma state fiscal year that a Date falls in",
      "topics": [
        "ojo_fiscal_year"
      ]
    },
    {
      "page": "ojo_list_schemas",
      "title": "List all schemas on the OJO database",
      "topics": [
        "ojo_list_schemas"
      ]
    },
    {
      "page": "ojo_list_tables",
      "title": "List all tables on the OJO database",
      "topics": [
        "ojo_list_tables"
      ]
    },
    {
      "page": "ojo_list_vars",
      "title": "List all variables in a table on the ojodb database",
      "topics": [
        "ojo_list_vars"
      ]
    },
    {
      "page": "ojo_pal",
      "title": "Add OJO styling to a ggplot",
      "topics": [
        "ojo_pal"
      ]
    },
    {
      "page": "ojo_query",
      "title": "OJO Query",
      "topics": [
        "ojo_query"
      ]
    },
    {
      "page": "ojo_search_minutes",
      "title": "Query minutes for a given search term",
      "topics": [
        "ojo_search_minutes"
      ]
    },
    {
      "page": "ojo_show_row",
      "title": "Browse the source court record of a row",
      "topics": [
        "ojo_show_row"
      ]
    },
    {
      "page": "ojo_tbl",
      "title": "Identify a table from the OJO database",
      "topics": [
        "ojo_tbl"
      ]
    },
    {
      "page": "ojo_theme",
      "title": "Style a ggplot in the OJO style",
      "topics": [
        "ojo_theme"
      ]
    },
    {
      "page": "ojo_version",
      "title": "OJO Version",
      "topics": [
        "ojo_version"
      ]
    }
  ],
  "_pkglogo": "https://github.com/openjusticeok/ojodb/raw/HEAD/man/figures/logo.png",
  "_readme": "https://github.com/openjusticeok/ojodb/raw/HEAD/README.md",
  "_rundeps": [
    "bit",
    "bit64",
    "blob",
    "cli",
    "cpp11",
    "DBI",
    "dbplyr",
    "dplyr",
    "farver",
    "generics",
    "ggplot2",
    "glue",
    "gtable",
    "hms",
    "isoband",
    "labeling",
    "later",
    "lifecycle",
    "lubridate",
    "magrittr",
    "pillar",
    "pkgconfig",
    "pool",
    "purrr",
    "R6",
    "RColorBrewer",
    "Rcpp",
    "rlang",
    "RPostgres",
    "S7",
    "scales",
    "stringi",
    "stringr",
    "tibble",
    "tidyr",
    "tidyselect",
    "timechange",
    "utf8",
    "vctrs",
    "viridisLite",
    "withr"
  ],
  "_vignettes": [
    {
      "source": "vignette-connecting-to-ojo.Rmd",
      "filename": "vignette-connecting-to-ojo.html",
      "title": "Connecting to ojodb",
      "engine": "knitr::rmarkdown",
      "headings": [],
      "created": "2023-03-03 02:24:34",
      "modified": "2023-03-03 02:24:34",
      "commits": 1
    },
    {
      "source": "vignette-pulling-data.Rmd",
      "filename": "vignette-pulling-data.html",
      "title": "Pulling court data with ojodb",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Intro: The OJO database",
        "Research Question:",
        "Before you proceed:",
        "Step 1: Getting the lay of the land",
        "Step 2: Pulling our data -- ojo_crim_cases()",
        "Exploring the data we've pulled",
        "Charges vs. Cases?",
        "Did we get everything we asked for?",
        "Back to our research question",
        "Step 3: Wrangling, cleaning, and analyzing the data",
        "Searching for drug-related charges",
        "Summarizing drug charges within cases",
        "Step 4: Visualizing and exporting the data",
        "Step 5: Review and deliver"
      ],
      "created": "2023-03-03 02:24:34",
      "modified": "2025-03-26 01:54:50",
      "commits": 7
    }
  ],
  "_score": 5.865932668193186,
  "_indexed": true,
  "_nocasepkg": "ojodb",
  "_universes": [
    "openjusticeok",
    "brancengregory"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "2.11.1",
      "date": "2026-10-08T10:17:39.000Z",
      "distro": "resolute",
      "commit": "3334765296ef5f054849b14db264463a7272441e",
      "fileid": "https://r2.ropensci.org/19f969738230b57a2482d249c6f3ce34df761f6a9021843e879d57bfd1d5f64d",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/openjusticeok/actions/runs/37761756793"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "2.11.1",
      "date": "2026-10-08T10:18:14.000Z",
      "distro": "resolute",
      "commit": "3334765296ef5f054849b14db264463a7272441e",
      "fileid": "https://r2.ropensci.org/25ec8b0a4e840472cc0c042b771dab09d9ac77b0ffdfcf2d72de2adcce5e64d4",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/openjusticeok/actions/runs/37761756793"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "2.11.1",
      "date": "2026-10-08T11:05:47.000Z",
      "commit": "3334765296ef5f054849b14db264463a7272441e",
      "fileid": "https://r2.ropensci.org/7c094c2731eb0adf4b4e2fe4acc850b8329beeea65960a048e03bae0d51a9e62",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/openjusticeok/actions/runs/37761756793"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "2.11.1",
      "date": "2026-10-08T11:09:02.000Z",
      "commit": "3334765296ef5f054849b14db264463a7272441e",
      "fileid": "https://r2.ropensci.org/7c4a0a5b545d594f5fe68772d0e8c66a0550ea481ee350080130a344b3176b35",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/openjusticeok/actions/runs/37761756793"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "2.11.1",
      "date": "2026-10-08T10:17:29.000Z",
      "commit": "3334765296ef5f054849b14db264463a7272441e",
      "fileid": "https://r2.ropensci.org/aaf29a51bead95f11d29aa1e3c7c2e42734ef453831650be2c344aea12fd52ce",
      "status": "success",
      "buildurl": "https://github.com/r-universe/openjusticeok/actions/runs/37761756793"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "2.11.1",
      "date": "2026-10-08T10:16:49.000Z",
      "commit": "3334765296ef5f054849b14db264463a7272441e",
      "fileid": "https://r2.ropensci.org/d35d434092a2a920475db3a8e84eeab7236b4d487213750391f8a4d3d4d4e8e4",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/openjusticeok/actions/runs/37761756793"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "2.11.1",
      "date": "2026-10-08T10:16:16.000Z",
      "commit": "3334765296ef5f054849b14db264463a7272441e",
      "fileid": "https://r2.ropensci.org/135e44200aeccb022b52879e82409a3a0187956997de03ac79cc5e1b3af60ad2",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/openjusticeok/actions/runs/37761756793"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "2.11.1",
      "date": "2026-10-08T10:16:20.000Z",
      "commit": "3334765296ef5f054849b14db264463a7272441e",
      "fileid": "https://r2.ropensci.org/ae54f5b245bb9be645c70a43a23129b488109a18ea196736a045a86b7341ed50",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/openjusticeok/actions/runs/37761756793"
    }
  ]
}