{ "_id": "6a4a2e633fcf58d53bc18ecc", "Package": "starwarsdb", "Title": "Relational Data from the 'Star Wars' API for Learning and\nTeaching", "Version": "0.1.3.9000", "Authors@R": "person(\"Garrick\", \"Aden-Buie\", , \"garrick@adenbuie.com\", role = c(\"aut\", \"cre\"),\ncomment = c(ORCID = \"0000-0002-7111-0077\"))", "Description": "Provides data about the 'Star Wars' movie franchise in a\nset of relational tables or as a complete 'DuckDB' database.\nAll data was collected from the open source 'Star Wars' API.", "License": "MIT + file LICENSE", "URL": "https://github.com/gadenbuie/starwarsdb,\nhttps://pkg.garrickadenbuie.com/starwarsdb/", "BugReports": "https://github.com/gadenbuie/starwarsdb/issues", "Config/Needs/website": "any::DiagrammeR, any::DiagrammeRsvg,\ngadenbuie/grkgdown", "Encoding": "UTF-8", "LazyData": "true", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.3.2", "Config/pak/sysreqs": "xz-utils", "Repository": "https://gadenbuie.r-universe.dev", "Date/Publication": "2025-08-27 12:11:39 UTC", "RemoteUrl": "https://github.com/gadenbuie/starwarsdb", "RemoteRef": "main", "RemoteSha": "cd5e823ccbf88302b786bb4c6d21d42c198b715b", "NeedsCompilation": "no", "Packaged": { "Date": "2026-07-05 10:11:13 UTC", "User": "root" }, "Author": "Garrick Aden-Buie [aut, cre] (ORCID:\n)", "Maintainer": "Garrick Aden-Buie ", "_user": "gadenbuie", "_type": "src", "_file": "starwarsdb_0.1.3.9000.tar.gz", "_fileid": "https://r2.ropensci.org/d2d26a8c6288e67c15531a1a5612abd50dcc6b994f60467e1775944746f0a2b2", "_filesize": 212013, "_sha256": "d2d26a8c6288e67c15531a1a5612abd50dcc6b994f60467e1775944746f0a2b2", "_expires": "2026-10-13T10:13:54.000Z", "_created": "2026-07-05T10:11:13.000Z", "_published": "2026-07-05T10:13:55.771Z", "_jobs": [ { "job": 85213685412, "time": 121, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "8090755427" }, { "job": 85213685355, "time": 123, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "8090755605" }, { "job": 85213685388, "time": 75, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "8090749860" }, { "job": 85213685387, "time": 86, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "8090751171" }, { "job": 85213490440, "time": 172, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "8090741026" }, { "job": 85213685344, "time": 119, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "8090755093" }, { "job": 85213685373, "time": 80, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "8090750614" }, { "job": 85213685343, "time": 76, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "8090750014" }, { "job": 85213685451, "time": 70, "config": "windows-release", "r": "4.6.1", "check": "OK", "artifact": "8090749246" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/gadenbuie/actions/runs/28737219782", "_status": "success", "_upstream": "https://github.com/gadenbuie/starwarsdb", "_commit": { "id": "cd5e823ccbf88302b786bb4c6d21d42c198b715b", "author": "Garrick Aden-Buie ", "committer": "Garrick Aden-Buie ", "message": "Increment version number to 0.1.3.9000\n", "time": 1756296699 }, "_maintainer": { "name": "Garrick Aden-Buie", "email": "garrick@adenbuie.com", "login": "gadenbuie", "mastodon": "@grrrck@fosstodon.org", "bluesky": "@grrrck.xyz", "description": "Software engineer for Shiny at @posit-pbc", "uuid": 5420529, "orcid": "0000-0002-7111-0077" }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 2.10", "role": "Depends" }, { "package": "DBI", "role": "Imports" }, { "package": "duckdb", "role": "Imports" }, { "package": "magrittr", "role": "Imports" }, { "package": "tibble", "role": "Imports" }, { "package": "dbplyr", "role": "Suggests" }, { "package": "dm", "role": "Suggests" }, { "package": "dplyr", "role": "Suggests" }, { "package": "testthat", "role": "Suggests" } ], "_owner": "gadenbuie", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2025-35", "n": 2 } ], "_tags": [ { "name": "v0.1.3", "date": "2025-08-27" } ], "_topics": [ "dplyr", "duckdb-database", "learning", "relational-database", "sql", "star-wars-data", "teaching" ], "_stars": 38, "_contributors": [ { "user": "gadenbuie", "count": 46, "uuid": 5420529 } ], "_userbio": { "uuid": 5420529, "type": "user", "name": "Garrick Aden-Buie", "followers": 1194, "description": "Software engineer for Shiny at @posit-pbc" }, "_downloads": { "count": 602, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/starwarsdb" }, "_devurl": "https://github.com/gadenbuie/starwarsdb", "_pkgdown": "https://pkg.garrickadenbuie.com/starwarsdb/", "_searchresults": 40, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "extra/starwarsdb.html", "LICENSE", "manual.pdf" ], "_homeurl": "https://github.com/gadenbuie/starwarsdb", "_realowner": "gadenbuie", "_cranurl": true, "_releases": [ { "version": "0.1.1", "date": "2020-10-28" }, { "version": "0.1.2", "date": "2020-11-03" }, { "version": "0.1.3", "date": "2025-08-23" } ], "_exports": [ "%>%", "starwars_connect", "starwars_db", "starwars_disconnect", "starwars_dm", "starwars_dm_configure" ], "_datasets": [ { "name": "films", "title": "Films", "object": "films", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "title", "episode_id", "opening_crawl", "director", "producer", "release_date" ], "rows": 6, "table": true, "tojson": true }, { "name": "films_people", "title": "People in Films", "object": "films_people", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "title", "character" ], "rows": 162, "table": true, "tojson": true }, { "name": "films_planets", "title": "Planets in Films", "object": "films_planets", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "title", "planet" ], "rows": 33, "table": true, "tojson": true }, { "name": "films_vehicles", "title": "Vehicles in Films", "object": "films_vehicles", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "title", "vehicle" ], "rows": 104, "table": true, "tojson": true }, { "name": "people", "title": "People", "object": "people", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "name", "height", "mass", "hair_color", "skin_color", "eye_color", "birth_year", "gender", "homeworld", "species", "sex" ], "rows": 82, "table": true, "tojson": true }, { "name": "pilots", "title": "Pilots", "object": "pilots", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "pilot", "vehicle" ], "rows": 43, "table": true, "tojson": true }, { "name": "planets", "title": "Planets", "object": "planets", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "name", "rotation_period", "orbital_period", "diameter", "climate", "gravity", "terrain", "surface_water", "population" ], "rows": 59, "table": true, "tojson": true }, { "name": "schema", "title": "Star Wars Data Schema", "object": "schema", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "endpoint", "endpoint_title", "endpoint_description", "properties" ], "rows": 5, "table": false, "tojson": true }, { "name": "species", "title": "Species", "object": "species", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "name", "classification", "designation", "average_height", "skin_colors", "hair_colors", "eye_colors", "average_lifespan", "homeworld", "language" ], "rows": 37, "table": true, "tojson": true }, { "name": "vehicles", "title": "Starships or Vehicles", "object": "vehicles", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "name", "type", "class", "model", "manufacturer", "cost_in_credits", "length", "max_atmosphering_speed", "crew", "passengers", "cargo_capacity", "consumables", "hyperdrive_rating", "MGLT" ], "rows": 75, "table": true, "tojson": true } ], "_help": [ { "page": "films", "title": "Films", "topics": [ "films" ] }, { "page": "films_people", "title": "People in Films", "topics": [ "films_people" ] }, { "page": "films_planets", "title": "Planets in Films", "topics": [ "films_planets" ] }, { "page": "films_vehicles", "title": "Vehicles in Films", "topics": [ "films_vehicles" ] }, { "page": "people", "title": "People", "topics": [ "people" ] }, { "page": "pilots", "title": "Pilots", "topics": [ "pilots" ] }, { "page": "planets", "title": "Planets", "topics": [ "planets" ] }, { "page": "schema", "title": "Star Wars Data Schema", "topics": [ "schema" ] }, { "page": "species", "title": "Species", "topics": [ "species" ] }, { "page": "starwars_db", "title": "Connect to the Star Wars Database", "topics": [ "starwars_connect", "starwars_db", "starwars_disconnect" ] }, { "page": "starwars_dm", "title": "Create a Star Wars Data Model Object", "topics": [ "starwars_dm", "starwars_dm_configure" ] }, { "page": "vehicles", "title": "Starships or Vehicles", "topics": [ "vehicles" ] } ], "_readme": "https://github.com/gadenbuie/starwarsdb/raw/main/README.md", "_rundeps": [ "cli", "DBI", "duckdb", "glue", "lifecycle", "magrittr", "pillar", "pkgconfig", "rlang", "tibble", "utf8", "vctrs" ], "_score": 4.880813592280791, "_indexed": true, "_nocasepkg": "starwarsdb", "_universes": [ "gadenbuie" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.1.3.9000", "date": "2026-07-05T10:13:11.000Z", "distro": "resolute", "commit": "cd5e823ccbf88302b786bb4c6d21d42c198b715b", "fileid": "https://r2.ropensci.org/2ff10019641f1d4a8347d6a9b6b30d7927e713fa75bf42df10009e1090c10514", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/gadenbuie/actions/runs/28737219782" }, { "r": "4.6.1", "os": "linux", "version": "0.1.3.9000", "date": "2026-07-05T10:13:14.000Z", "distro": "resolute", "commit": "cd5e823ccbf88302b786bb4c6d21d42c198b715b", "fileid": "https://r2.ropensci.org/9bbef6320a074d2d14fafa9a882336a32afae1ba40ba716d9298b4ca0e357a74", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/gadenbuie/actions/runs/28737219782" }, { "r": "4.5.3", "os": "mac", "version": "0.1.3.9000", "date": "2026-07-05T10:12:31.000Z", "commit": "cd5e823ccbf88302b786bb4c6d21d42c198b715b", "fileid": "https://r2.ropensci.org/bc63ecc1058e33d5bca32de232b334bbb09b225a0ffa4e7550465c8e5d8814d2", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/gadenbuie/actions/runs/28737219782" }, { "r": "4.6.1", "os": "mac", "version": "0.1.3.9000", "date": "2026-07-05T10:12:41.000Z", "commit": "cd5e823ccbf88302b786bb4c6d21d42c198b715b", "fileid": "https://r2.ropensci.org/13c604b6249826b7177167e33f30101aae175ba5c0ed93368b98444ce0f02faf", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/gadenbuie/actions/runs/28737219782" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.3.9000", "date": "2026-07-05T10:13:25.000Z", "commit": "cd5e823ccbf88302b786bb4c6d21d42c198b715b", "fileid": "https://r2.ropensci.org/0c149c87bf68d944aa9c786bd4226084d242589e16ca3604381e0270ad6405c7", "status": "success", "buildurl": "https://github.com/r-universe/gadenbuie/actions/runs/28737219782" }, { "r": "4.7.0", "os": "win", "version": "0.1.3.9000", "date": "2026-07-05T10:12:26.000Z", "commit": "cd5e823ccbf88302b786bb4c6d21d42c198b715b", "fileid": "https://r2.ropensci.org/a42f01f075b16c334100ae719a8b99b48c753d656f9bb1644a66af8881429f2c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/gadenbuie/actions/runs/28737219782" }, { "r": "4.5.3", "os": "win", "version": "0.1.3.9000", "date": "2026-07-05T10:12:21.000Z", "commit": "cd5e823ccbf88302b786bb4c6d21d42c198b715b", "fileid": "https://r2.ropensci.org/cf6f7f530f6d76c4b22539dd1a41fe34961abf2a3f5423b95001e9839d8ab802", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/gadenbuie/actions/runs/28737219782" }, { "r": "4.6.1", "os": "win", "version": "0.1.3.9000", "date": "2026-07-05T10:12:16.000Z", "commit": "cd5e823ccbf88302b786bb4c6d21d42c198b715b", "fileid": "https://r2.ropensci.org/50b7b4def952bfdaea3324f31dc37bbc836eba1de6e3f1f7e999b299764808ba", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/gadenbuie/actions/runs/28737219782" } ] }