{
  "_id": "6ae45cb58d250e7ad09f1647",
  "Package": "contoso",
  "Type": "Package",
  "Title": "Dataset of the 'Contoso' Company",
  "Version": "2.4.0",
  "Authors@R": "c(\nperson(\n\"Alejandro\", \"Hagan\",\nemail = \"alejandro.hagan@outlook.com\",\nrole = c(\"aut\", \"cre\")\n)\n)",
  "Description": "A collection of synthetic datasets simulating sales\ntransactions from a fictional company. The dataset includes\nvarious related tables that contain essential business and\noperational data, useful for analyzing sales performance and\nother business insights. Key tables included in the package\nare: - \"sales\": Contains data on individual sales transactions,\nincluding order details, pricing, quantities, and customer\ninformation. - \"customer\": Stores customer-specific details\nsuch as demographics, geographic location, occupation, and\nbirthday. - \"store\": Provides information about stores,\nincluding location, size, status, and operational dates. -\n\"orders\": Contains details about customer orders, including\norder and delivery dates, store, and customer data. -\n\"product\": Contains data on products, including attributes such\nas product name, category, price, cost, and weight. -\n\"calendar\": A time-based table that includes date-related\nattributes like year, month, quarter, day, and working day\nindicators. The package also includes 1,127 fictional internal\nbusiness reports (weekly sales flashes, monthly reviews,\nregional reviews, pricing committee minutes, annual operating\nplans and industry notes) written about the trading from 2016\nto 2025 in the larger cloud dataset, with a glossary of the\nterms they use, for building and testing document search and\nfinancial planning and analysis workflows with large language\nmodels. This dataset is ideal for practicing data analysis,\nperforming time-series analysis, creating reports, or\nsimulating business intelligence scenarios.",
  "License": "MIT + file LICENSE",
  "Encoding": "UTF-8",
  "LazyData": "true",
  "URL": "https://codeberg.org/usrbinr/contoso",
  "Config/testthat/edition": "3",
  "BugReports": "https://codeberg.org/usrbinr/contoso/issues",
  "Config/roxygen2/version": "8.0.0",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-10-30 08:54:46 UTC",
    "User": "root"
  },
  "Author": "Alejandro Hagan [aut, cre]",
  "Maintainer": "Alejandro Hagan <alejandro.hagan@outlook.com>",
  "Repository": "https://cran.r-universe.dev",
  "Date/Publication": "2026-10-30 07:17:22 UTC",
  "RemoteUrl": "https://github.com/cran/contoso",
  "RemoteRef": "HEAD",
  "RemoteSha": "bdbb3ecfd434881da0c4e0d369f7e30fd06dae45",
  "_user": "cran",
  "_type": "src",
  "_file": "contoso_2.4.0.tar.gz",
  "_fileid": "https://r2.ropensci.org/1b1f15e24efe4bc199b334b1990a87913faddf278453d5804d6b5b690d0484e1",
  "_filesize": 1790258,
  "_sha256": "1b1f15e24efe4bc199b334b1990a87913faddf278453d5804d6b5b690d0484e1",
  "_expires": "2027-02-07T09:00:35.000Z",
  "_created": "2026-10-30T08:54:46.000Z",
  "_published": "2026-10-30T09:00:37.491Z",
  "_upstream": "https://github.com/cran/contoso",
  "_status": "success",
  "_maintainer": {
    "name": "Alejandro Hagan",
    "email": "alejandro.hagan@outlook.com",
    "login": "usrbinr",
    "description": "",
    "uuid": 87534364
  },
  "_jobs": [
    {
      "job": 123976080242,
      "time": 137,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "12964862981"
    },
    {
      "job": 123976080217,
      "time": 136,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12966555088"
    },
    {
      "job": 123974971216,
      "time": 188,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12964948035"
    },
    {
      "job": 123976080167,
      "time": 118,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "12966420068"
    },
    {
      "job": 123976080205,
      "time": 72,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "12965177210"
    },
    {
      "job": 123976080108,
      "time": 228,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12966450300"
    }
  ],
  "_buildurl": "https://github.com/r-universe/cran/actions/runs/41029280749",
  "_commit": {
    "id": "bdbb3ecfd434881da0c4e0d369f7e30fd06dae45",
    "author": "Alejandro Hagan <alejandro.hagan@outlook.com>",
    "committer": "cran-robot <csardi.gabor+cran@gmail.com>",
    "message": "version 2.4.0\n",
    "time": 1793344642
  },
  "_distro": "resolute",
  "_host": "GitHub-Actions",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 4.1.0",
      "role": "Depends"
    },
    {
      "package": "DBI",
      "role": "Imports"
    },
    {
      "package": "dplyr",
      "role": "Imports"
    },
    {
      "package": "cli",
      "role": "Imports"
    },
    {
      "package": "duckdb",
      "version": ">= 1.4.0",
      "role": "Imports"
    },
    {
      "package": "purrr",
      "role": "Imports"
    },
    {
      "package": "tibble",
      "role": "Imports"
    },
    {
      "package": "yaml12",
      "role": "Imports"
    },
    {
      "package": "testthat",
      "version": ">= 3.0.0",
      "role": "Suggests"
    },
    {
      "package": "withr",
      "role": "Suggests"
    },
    {
      "package": "dbplyr",
      "role": "Suggests"
    },
    {
      "package": "yaml",
      "role": "Suggests"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "quarto",
      "role": "Suggests"
    }
  ],
  "_owner": "cran",
  "_selfowned": false,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2025-46",
      "n": 1
    },
    {
      "week": "2025-47",
      "n": 1
    },
    {
      "week": "2025-48",
      "n": 1
    },
    {
      "week": "2025-51",
      "n": 1
    },
    {
      "week": "2026-06",
      "n": 1
    },
    {
      "week": "2026-09",
      "n": 1
    },
    {
      "week": "2026-44",
      "n": 1
    }
  ],
  "_tags": [
    {
      "name": "1.1.1",
      "date": "2025-11-12"
    },
    {
      "name": "1.2.0",
      "date": "2025-11-22"
    },
    {
      "name": "1.2.1",
      "date": "2025-11-24"
    },
    {
      "name": "1.2.2",
      "date": "2025-12-19"
    },
    {
      "name": "2.0.0",
      "date": "2026-02-04"
    },
    {
      "name": "2.1.0",
      "date": "2026-03-01"
    },
    {
      "name": "2.4.0",
      "date": "2026-10-30"
    }
  ],
  "_stars": 0,
  "_contributors": [
    {
      "user": "usrbinr",
      "count": 7,
      "uuid": 87534364
    }
  ],
  "_userbio": {
    "uuid": 6899542,
    "type": "organization",
    "name": "cran",
    "followers": 634,
    "description": "Unofficial read-only mirror of all CRAN R packages"
  },
  "_downloads": {
    "count": 249,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/contoso"
  },
  "_devurl": "https://codeberg.org/usrbinr/contoso",
  "_searchresults": 9,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/contoso.html",
    "extra/manual.pdf",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "LICENSE"
  ],
  "_homeurl": "https://codeberg.org/usrbinr/contoso",
  "_realowner": "usrbinr",
  "_cranurl": false,
  "_releases": [
    {
      "version": "1.1.1",
      "date": "2025-11-12"
    },
    {
      "version": "1.2.0",
      "date": "2025-11-22"
    },
    {
      "version": "1.2.1",
      "date": "2025-11-24"
    },
    {
      "version": "1.2.2",
      "date": "2025-12-19"
    },
    {
      "version": "2.0.0",
      "date": "2026-02-04"
    },
    {
      "version": "2.1.0",
      "date": "2026-03-01"
    },
    {
      "version": "2.4.0",
      "date": "2026-10-30"
    }
  ],
  "_exports": [
    "create_contoso_duckdb",
    "export_reports",
    "launch_ui",
    "read_reports"
  ],
  "_datasets": [
    {
      "name": "calendar",
      "title": "Calendar Dimension Data from the Contoso Dataset",
      "object": "calendar",
      "class": [
        "spec_tbl_df",
        "tbl_df",
        "tbl",
        "data.frame"
      ],
      "fields": [
        "date",
        "date_key",
        "year",
        "year_quarter",
        "year_quarter_number",
        "quarter",
        "year_month",
        "year_month_short",
        "year_month_number",
        "month",
        "month_short",
        "month_number",
        "day_of_week",
        "day_of_week_short",
        "day_of_week_number",
        "working_day",
        "working_day_number"
      ],
      "rows": 1461,
      "table": true,
      "tojson": true
    },
    {
      "name": "customer",
      "title": "Customer Data from the Contoso Dataset",
      "object": "customer",
      "class": [
        "spec_tbl_df",
        "tbl_df",
        "tbl",
        "data.frame"
      ],
      "fields": [
        "customer_key",
        "geo_area_key",
        "start_date",
        "end_date",
        "continent",
        "gender",
        "title",
        "given_name",
        "middle_initial",
        "surname",
        "street_address",
        "city",
        "state",
        "state_full",
        "zip_code",
        "country",
        "country_full",
        "birthday",
        "age",
        "occupation",
        "company",
        "vehicle",
        "latitude",
        "longitude"
      ],
      "rows": 3165,
      "table": true,
      "tojson": true
    },
    {
      "name": "fx",
      "title": "Foreign Exchange Data from the Contoso Dataset",
      "object": "fx",
      "class": [
        "spec_tbl_df",
        "tbl_df",
        "tbl",
        "data.frame"
      ],
      "fields": [
        "date",
        "from_currency",
        "to_currency",
        "exchange"
      ],
      "rows": 36525,
      "table": true,
      "tojson": true
    },
    {
      "name": "orderrows",
      "title": "Order Rows Data from the Contoso Dataset",
      "object": "orderrows",
      "class": [
        "spec_tbl_df",
        "tbl_df",
        "tbl",
        "data.frame"
      ],
      "fields": [
        "order_key",
        "line_number",
        "product_key",
        "quantity",
        "unit_price",
        "net_price",
        "unit_cost"
      ],
      "rows": 7794,
      "table": true,
      "tojson": true
    },
    {
      "name": "orders",
      "title": "Order Data from the Contoso Dataset",
      "object": "orders",
      "class": [
        "spec_tbl_df",
        "tbl_df",
        "tbl",
        "data.frame"
      ],
      "fields": [
        "order_key",
        "customer_key",
        "store_key",
        "order_date",
        "delivery_date",
        "currency_code"
      ],
      "rows": 3242,
      "table": true,
      "tojson": true
    },
    {
      "name": "product",
      "title": "Product Data from the Contoso Dataset",
      "object": "product",
      "class": [
        "spec_tbl_df",
        "tbl_df",
        "tbl",
        "data.frame"
      ],
      "fields": [
        "product_key",
        "product_code",
        "product_name",
        "manufacturer",
        "brand",
        "color",
        "weight_unit",
        "weight",
        "cost",
        "price",
        "category_key",
        "category_name",
        "sub_category_key",
        "sub_category_name"
      ],
      "rows": 2517,
      "table": true,
      "tojson": true
    },
    {
      "name": "sales",
      "title": "Sales Data from the Contoso Dataset",
      "object": "sales",
      "class": [
        "tbl_df",
        "tbl",
        "data.frame"
      ],
      "fields": [
        "order_key",
        "line_number",
        "order_date",
        "delivery_date",
        "customer_key",
        "store_key",
        "product_key",
        "quantity",
        "unit_price",
        "net_price",
        "unit_cost",
        "currency_code",
        "exchange_rate",
        "gross_revenue",
        "net_revenue",
        "unit_discount",
        "discounts",
        "cogs",
        "gross_margin",
        "unit_margin"
      ],
      "rows": 7794,
      "table": true,
      "tojson": true
    },
    {
      "name": "store",
      "title": "Store Data from the Contoso Dataset",
      "object": "store",
      "class": [
        "spec_tbl_df",
        "tbl_df",
        "tbl",
        "data.frame"
      ],
      "fields": [
        "store_key",
        "store_code",
        "geo_area_key",
        "country_code",
        "country_name",
        "state",
        "open_date",
        "close_date",
        "description",
        "square_meters",
        "status"
      ],
      "rows": 74,
      "table": true,
      "tojson": true
    }
  ],
  "_help": [
    {
      "page": "calendar",
      "title": "Calendar Dimension Data from the Contoso Dataset",
      "topics": [
        "calendar"
      ]
    },
    {
      "page": "create_contoso_duckdb",
      "title": "Creates DuckDB database with Contoso datasets",
      "topics": [
        "create_contoso_duckdb"
      ]
    },
    {
      "page": "customer",
      "title": "Customer Data from the Contoso Dataset",
      "topics": [
        "customer"
      ]
    },
    {
      "page": "export_reports",
      "title": "Write the Contoso business reports to files",
      "topics": [
        "export_reports"
      ]
    },
    {
      "page": "fx",
      "title": "Foreign Exchange Data from the Contoso Dataset",
      "topics": [
        "fx"
      ]
    },
    {
      "page": "launch_ui",
      "title": "Launch the DuckDB UI in your browser",
      "topics": [
        "launch_ui"
      ]
    },
    {
      "page": "orderrows",
      "title": "Order Rows Data from the Contoso Dataset",
      "topics": [
        "orderrows"
      ]
    },
    {
      "page": "orders",
      "title": "Order Data from the Contoso Dataset",
      "topics": [
        "orders"
      ]
    },
    {
      "page": "product",
      "title": "Product Data from the Contoso Dataset",
      "topics": [
        "product"
      ]
    },
    {
      "page": "read_reports",
      "title": "Read the Contoso business reports",
      "topics": [
        "read_reports"
      ]
    },
    {
      "page": "sales",
      "title": "Sales Data from the Contoso Dataset",
      "topics": [
        "sales"
      ]
    },
    {
      "page": "store",
      "title": "Store Data from the Contoso Dataset",
      "topics": [
        "store"
      ]
    }
  ],
  "_pkglogo": "https://github.com/cran/contoso/raw/HEAD/man/figures/logo.png",
  "_readme": "https://github.com/cran/contoso/raw/HEAD/README.md",
  "_rundeps": [
    "cli",
    "DBI",
    "dplyr",
    "duckdb",
    "generics",
    "glue",
    "lifecycle",
    "magrittr",
    "pillar",
    "pkgconfig",
    "purrr",
    "R6",
    "rlang",
    "tibble",
    "tidyselect",
    "utf8",
    "vctrs",
    "withr",
    "yaml12"
  ],
  "_score": 2.5440680443502757,
  "_indexed": false,
  "_nocasepkg": "contoso",
  "_universes": [
    "cran"
  ],
  "_previous": "2.1.0",
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "2.4.0",
      "date": "2026-10-30T08:58:01.000Z",
      "distro": "resolute",
      "commit": "bdbb3ecfd434881da0c4e0d369f7e30fd06dae45",
      "fileid": "https://r2.ropensci.org/72e5d43a69e4c20d18b55ecd3d4999772f440a3817849bccf610ccbc86d7ce99",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/41029280749"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "2.4.0",
      "date": "2026-10-30T08:58:03.000Z",
      "distro": "resolute",
      "commit": "bdbb3ecfd434881da0c4e0d369f7e30fd06dae45",
      "fileid": "https://r2.ropensci.org/41c81e87b55fb79e5c3809df766a691bc109a66991d73a9dfc3d722bcc99b909",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/41029280749"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "2.4.0",
      "date": "2026-10-30T08:57:48.000Z",
      "commit": "bdbb3ecfd434881da0c4e0d369f7e30fd06dae45",
      "fileid": "https://r2.ropensci.org/4092beef8fea7b3999e1c0a9023d67dde87e6031ef48c2f65554760431a9ddd3",
      "status": "success",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/41029280749"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "2.4.0",
      "date": "2026-10-30T08:56:50.000Z",
      "commit": "bdbb3ecfd434881da0c4e0d369f7e30fd06dae45",
      "fileid": "https://r2.ropensci.org/6c396d57cb498b7b449d6038e5459f629e4cb48dd6e7d9cdbe6f11aafae12c7e",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/41029280749"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "2.4.0",
      "date": "2026-10-30T08:59:14.000Z",
      "commit": "bdbb3ecfd434881da0c4e0d369f7e30fd06dae45",
      "fileid": "https://r2.ropensci.org/cc4a35b1045ceb911f30cf7f5d6d27e94f9b09d2333268d25931e5cf13a614d6",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/41029280749"
    }
  ]
}