{ "_id": "6a1ada171d7bb097a09e7d43", "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-05-30 09:12:43 UTC", "User": "root" }, "Author": "Brancen Gregory [cre, aut],\nRyan Gentzler [aut],\nAndrew Bell [aut],\nAnthony Flores [aut],\nElizabeth Spencer [ctb]", "Maintainer": "Brancen Gregory ", "MD5sum": "b5b92911b16d0908be80f6ffa520cbb4", "_user": "openjusticeok", "_type": "src", "_file": "ojodb_2.11.1.tar.gz", "_fileid": "029bc495026d652c96a14888d0716e5c0c83efa77fc5923737201386fd119b77", "_filesize": 6220520, "_sha256": "029bc495026d652c96a14888d0716e5c0c83efa77fc5923737201386fd119b77", "_created": "2026-05-30T09:12:43.000Z", "_published": "2026-05-30T12:37:43.513Z", "_distro": "noble", "_jobs": [ { "job": 78638886261, "time": 185, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "NOTE", "artifact": "7307131028" }, { "job": 78638886257, "time": 185, "config": "linux-release-x86_64", "r": "4.6.0", "check": "NOTE", "artifact": "7307130952" }, { "job": 78638886270, "time": 97, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "NOTE", "artifact": "7308220012" }, { "job": 78638886271, "time": 118, "config": "macos-release-arm64", "r": "4.6.0", "check": "NOTE", "artifact": "7308221296" }, { "job": 78638596782, "time": 249, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7307090539" }, { "job": 78638886254, "time": 159, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7307128350" }, { "job": 78638886335, "time": 116, "config": "windows-devel", "r": "4.7.0", "check": "NOTE", "artifact": "7307125437" }, { "job": 78638886347, "time": 97, "config": "windows-oldrel", "r": "4.5.3", "check": "NOTE", "artifact": "7307124009" }, { "job": 78638886324, "time": 109, "config": "windows-release", "r": "4.6.0", "check": "NOTE", "artifact": "7307122377" } ], "_buildurl": "https://github.com/r-universe/openjusticeok/actions/runs/26560587139", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/openjusticeok/ojodb", "_commit": { "id": "3334765296ef5f054849b14db264463a7272441e", "author": "Brancen Gregory ", "committer": "GitHub ", "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 }, "_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": [ { "week": "2025-27", "n": 1 } ], "_tags": [], "_topics": [ "courts", "justice", "oklahoma", "open-data" ], "_stars": 8, "_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" }, "_downloads": { "count": 0, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/ojodb" }, "_devurl": "https://github.com/openjusticeok/ojodb", "_searchresults": 63, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/NEWS.html", "extra/NEWS.txt", "extra/ojodb.html", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_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.78161178249315, "_indexed": true, "_nocasepkg": "ojodb", "_universes": [ "openjusticeok", "brancengregory" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "2.11.1", "date": "2026-05-30T09:19:33.000Z", "distro": "noble", "commit": "3334765296ef5f054849b14db264463a7272441e", "fileid": "5c2b5a6cdda47aa4faee200815817e082644c9c984f2c5904e27ee21bb01a737", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/openjusticeok/actions/runs/26560587139" }, { "r": "4.6.0", "os": "linux", "version": "2.11.1", "date": "2026-05-30T09:19:32.000Z", "distro": "noble", "commit": "3334765296ef5f054849b14db264463a7272441e", "fileid": "91becfc3c9ef6f2b10aca9e6229ef4cdf8f63a5545c95b0df46d52e2d459945a", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/openjusticeok/actions/runs/26560587139" }, { "r": "4.5.3", "os": "mac", "version": "2.11.1", "date": "2026-05-30T12:36:46.000Z", "commit": "3334765296ef5f054849b14db264463a7272441e", "fileid": "2c88d133885141e966b40d478ce9fe7e39afa1f45d3239a4d07b731e8a71b057", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/openjusticeok/actions/runs/26560587139" }, { "r": "4.6.0", "os": "mac", "version": "2.11.1", "date": "2026-05-30T12:36:55.000Z", "commit": "3334765296ef5f054849b14db264463a7272441e", "fileid": "b3a26208b97903f16b1f93bf119df065c863d39c04b6b90f3cd7b0a1e7b2c681", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/openjusticeok/actions/runs/26560587139" }, { "r": "4.6.0", "os": "wasm", "version": "2.11.1", "date": "2026-05-30T09:19:38.000Z", "commit": "3334765296ef5f054849b14db264463a7272441e", "fileid": "f829315e2435614bd77dac899831875152385ea4b8073c263cb5614a6112ff3c", "status": "success", "buildurl": "https://github.com/r-universe/openjusticeok/actions/runs/26560587139" }, { "r": "4.7.0", "os": "win", "version": "2.11.1", "date": "2026-05-30T09:18:27.000Z", "commit": "3334765296ef5f054849b14db264463a7272441e", "fileid": "8328bf5c9f778d8ca64771a311f7e0466653704eab3e6286557ab62bf3138c52", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/openjusticeok/actions/runs/26560587139" }, { "r": "4.5.3", "os": "win", "version": "2.11.1", "date": "2026-05-30T09:18:14.000Z", "commit": "3334765296ef5f054849b14db264463a7272441e", "fileid": "475014e654213fdef7d6b2e02172e5ba50c21e69c3f17fbf10e7b7e79cb2a74b", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/openjusticeok/actions/runs/26560587139" }, { "r": "4.6.0", "os": "win", "version": "2.11.1", "date": "2026-05-30T09:17:53.000Z", "commit": "3334765296ef5f054849b14db264463a7272441e", "fileid": "4841f7afde31b69d7fac73cbbc8381d9c13640bd4baf410fa9c0895ba8e7b161", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/openjusticeok/actions/runs/26560587139" } ] }