{ "_id": "6a13e9ebacfb0bcc41d2ddcc", "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-05-25 06:16:44 UTC", "User": "root" }, "Author": "Garrick Aden-Buie [aut, cre] (ORCID:\n)", "Maintainer": "Garrick Aden-Buie ", "MD5sum": "bc63035edc824795366ca1119a2c7572", "_user": "gadenbuie", "_type": "src", "_file": "starwarsdb_0.1.3.9000.tar.gz", "_fileid": "9e2500fa777fef63c5748949d29cfe613d5431c7e550cc72a7946330bce6427a", "_filesize": 208077, "_sha256": "9e2500fa777fef63c5748949d29cfe613d5431c7e550cc72a7946330bce6427a", "_created": "2026-05-25T06:16:44.000Z", "_published": "2026-05-25T06:19:23.677Z", "_distro": "noble", "_jobs": [ { "job": 77665748559, "time": 131, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7192737735" }, { "job": 77665748562, "time": 127, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7192737144" }, { "job": 77665748574, "time": 104, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7192735775" }, { "job": 77665748608, "time": 70, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7192727673" }, { "job": 77665458420, "time": 174, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7192712526" }, { "job": 77665748570, "time": 105, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7192732869" }, { "job": 77665748615, "time": 96, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7192731856" }, { "job": 77665748585, "time": 74, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7192727077" }, { "job": 77665748580, "time": 70, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7192726496" } ], "_buildurl": "https://github.com/r-universe/gadenbuie/actions/runs/26386296804", "_status": "success", "_host": "GitHub-Actions", "_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" }, "_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", "description": "Software engineer for Shiny at @posit-pbc" }, "_downloads": { "count": 683, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/starwarsdb" }, "_devurl": "https://github.com/gadenbuie/starwarsdb", "_pkgdown": "https://pkg.garrickadenbuie.com/starwarsdb/", "_searchresults": 34, "_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/readme.html", "extra/readme.md", "extra/starwarsdb.html", "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.810232517995084, "_indexed": true, "_nocasepkg": "starwarsdb", "_universes": [ "gadenbuie" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.1.3.9000", "date": "2026-05-25T06:18:51.000Z", "distro": "noble", "commit": "cd5e823ccbf88302b786bb4c6d21d42c198b715b", "fileid": "e094b01278c9fa73822e4c9cabf6362141f695bb2a8beccaff1619d4f1d1808e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/gadenbuie/actions/runs/26386296804" }, { "r": "4.6.0", "os": "linux", "version": "0.1.3.9000", "date": "2026-05-25T06:18:51.000Z", "distro": "noble", "commit": "cd5e823ccbf88302b786bb4c6d21d42c198b715b", "fileid": "7c2fe1c92b67495f7d24651e8c53fdf6051d87089e33791793cbf840b0dd32e5", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/gadenbuie/actions/runs/26386296804" }, { "r": "4.5.3", "os": "mac", "version": "0.1.3.9000", "date": "2026-05-25T06:18:45.000Z", "commit": "cd5e823ccbf88302b786bb4c6d21d42c198b715b", "fileid": "48298d6cdb66654e0520014b242223a0194863393dbdfd6c871b5935483f454b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/gadenbuie/actions/runs/26386296804" }, { "r": "4.6.0", "os": "mac", "version": "0.1.3.9000", "date": "2026-05-25T06:18:06.000Z", "commit": "cd5e823ccbf88302b786bb4c6d21d42c198b715b", "fileid": "43eb71532c676aead2c7e38787e32fcd60eb6035c650aa65b5ea6206113cf49a", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/gadenbuie/actions/runs/26386296804" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.3.9000", "date": "2026-05-25T06:18:43.000Z", "commit": "cd5e823ccbf88302b786bb4c6d21d42c198b715b", "fileid": "980d8c6b7aee13612460fd58538ea290725f38fff5bf4436361a03d6b6bb9173", "status": "success", "buildurl": "https://github.com/r-universe/gadenbuie/actions/runs/26386296804" }, { "r": "4.7.0", "os": "win", "version": "0.1.3.9000", "date": "2026-05-25T06:18:14.000Z", "commit": "cd5e823ccbf88302b786bb4c6d21d42c198b715b", "fileid": "ba3c0c02dd4803d9c1be96be31101c6d2f3cab56c64469330320e6ee78dfa9d2", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/gadenbuie/actions/runs/26386296804" }, { "r": "4.5.3", "os": "win", "version": "0.1.3.9000", "date": "2026-05-25T06:17:51.000Z", "commit": "cd5e823ccbf88302b786bb4c6d21d42c198b715b", "fileid": "e7bcf20b9d9554f3696a6c02951ab6ecbe57a0048bfcfb52564dbd569a9b874f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/gadenbuie/actions/runs/26386296804" }, { "r": "4.6.0", "os": "win", "version": "0.1.3.9000", "date": "2026-05-25T06:17:52.000Z", "commit": "cd5e823ccbf88302b786bb4c6d21d42c198b715b", "fileid": "c5cd781c8315c61f4e7f10aa35a91e005eb842646659384b2fb69dc724d18b28", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/gadenbuie/actions/runs/26386296804" } ] }