monthly_sales <- dbGetQuery(con, "
WITH base AS (
SELECT
sh.LicenseeId,
DATE_TRUNC('month', CAST(sh.SaleDate AS DATE)) AS Month,
CAST(sd.Quantity AS DOUBLE) * CAST(sd.UnitPrice AS DOUBLE) +
CAST(sd.SalesTax AS DOUBLE) + CAST(sd.OtherTax AS DOUBLE) AS Revenue
FROM sales_detail_all sd
JOIN sale_header_all sh ON sd.SaleHeaderId = sh.SaleHeaderId
WHERE DATE(CAST(sh.SaleDate AS DATE)) BETWEEN '2021-12-01' AND '2025-08-31'
AND CAST(sd.UnitPrice AS DOUBLE) < 200
),
grouped AS (
SELECT
Month,
LicenseeId,
SUM(Revenue) AS TotalRevenue
FROM base
GROUP BY Month, LicenseeId
),
licensee_counts AS (
SELECT
Month,
COUNT(DISTINCT LicenseeId) AS LicenseeCount
FROM grouped
GROUP BY Month
ORDER BY Month
)
SELECT * FROM licensee_counts
")State of the WA Auditor Office on Cannabis Traceability
How Washington’s Cannabis Market Found Its Balance Between Innovation and Saturation (2021–2025)
CCRS
State Auditor
Traceability
Using data to fact check WA State Auditor
Exploring how CCRS data addresses (or fails to address) concerns raised by the Washington State Auditor in an October 22, 2024. Check out the press release.
The data covers the entire CCRS program - Dec 2021 to present day.
The concerns in the press release were:
Lack of seed-to-sale traceability
Inflated or inconsistent reported sales
Lack of real-time tracking
Data integrity and accessibility for licensees
TECL demonstrates below how to use CCRS to track quality, outliers, non-conformers, and more to address total traceability. Everyone has concerns about regulated weed crossing the border, and tracking the above KPIs can point regulators to license holders to validate entries.
Due to the severity of the matter involving government cannabis regulators and the Office of the Washington State Auditor, we share our SQL queries to view the data in tables and graphs.
Number of Licensees (2021-2025)
Seed-to-Sale Visibility
Partial Traceability – Example Joins from Plant → Inventory → Sale
plant_to_sale <- dbGetQuery(con, "
SELECT
p.ExternalIdentifier AS PlantID,
i.InventoryId,
s.SaleDetailId,
p.HarvestDate,
i.CreatedDate AS InventoryDate,
s.CreatedDate AS SaleDate
FROM plant_all p
LEFT JOIN inventory_all i
ON p.ExternalIdentifier = i.ExternalIdentifier
LEFT JOIN sales_detail_all s
ON i.InventoryId = s.InventoryId
WHERE s.CreatedDate IS NOT NULL
LIMIT 50
")| PlantID | InventoryId | SaleDetailId | HarvestDate | InventoryDate | SaleDate |
|---|---|---|---|---|---|
| C1-1000391000128408 | 41452941 | 247770683 | NA | 2025-04-15 13:48:00 | 2025-04-16 10:27:00 |
| C1-10006110001825 | 41547633 | 253974616 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-06-01 00:55:00 |
| C1-109631000116381 | 41602204 | 247539824 | NA | 2025-04-22 12:32:00 | 2025-04-01 00:00:00 |
| C1-10006110001825 | 41547633 | 251797942 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-05-16 10:37:00 |
| C1-109631000116381 | 41602204 | 246103964 | NA | 2025-04-22 12:32:00 | 2025-04-01 08:13:00 |
| C1-10006110001825 | 41547633 | 251797854 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-05-16 10:39:00 |
| C1-109631000116381 | 41602204 | 245955925 | NA | 2025-04-22 12:32:00 | 2025-03-27 00:00:00 |
| C1-10006110001825 | 41547633 | 251797837 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-05-16 10:38:00 |
| C1-109631000116381 | 41602204 | 245955871 | NA | 2025-04-22 12:32:00 | 2025-03-27 00:00:00 |
| C1-10006110001825 | 41547633 | 251797818 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-05-16 10:39:00 |
| C1-109631000116381 | 41602204 | 245955747 | NA | 2025-04-22 12:32:00 | 2025-03-26 00:00:00 |
| C1-10006110001825 | 41547633 | 251797760 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-05-16 10:37:00 |
| C1-109631000116381 | 41602204 | 246556156 | NA | 2025-04-22 12:32:00 | 2025-03-28 00:00:00 |
| C1-10006110001825 | 41547633 | 251797736 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-05-16 10:39:00 |
| C1-10006110001825 | 41547633 | 251797707 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-05-16 10:39:00 |
| C1-10006110001825 | 41547633 | 251797685 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-05-16 10:39:00 |
| C1-10006110001825 | 41547633 | 253822668 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-05-30 20:01:00 |
| C1-10006110001825 | 41547633 | 253822551 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-05-30 01:12:00 |
| C1-10006110001825 | 41547633 | 253822448 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-05-31 19:37:00 |
| C1-10006110001825 | 41547633 | 254095361 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-04-09 00:00:00 |
| C1-10006110001825 | 41547633 | 254095359 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-04-09 00:00:00 |
| C1-10006110001825 | 41547633 | 254093982 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-04-10 00:00:00 |
| C1-10006110001825 | 41547633 | 254092983 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-04-09 00:00:00 |
| C1-10006110001825 | 41547633 | 254091524 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-04-10 00:00:00 |
| C1-10006110001825 | 41547633 | 254091380 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-04-10 00:00:00 |
| C1-10006110001825 | 41547633 | 254091195 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-04-10 00:00:00 |
| C1-10006110001825 | 41547633 | 248675839 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-04-30 20:25:00 |
| C1-10006110001825 | 41547633 | 250733045 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-04-08 00:00:00 |
| C1-10006110001825 | 41547633 | 250732564 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-04-07 00:00:00 |
| C1-10006110001825 | 41547633 | 250731712 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-04-07 00:00:00 |
| C1-10006110001825 | 41547633 | 254051418 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-04-10 00:00:00 |
| C1-10006110001825 | 41547633 | 254051233 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-04-10 00:00:00 |
| C1-10006110001825 | 41547633 | 254051231 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-04-10 00:00:00 |
| C1-10006110001825 | 41547633 | 254051156 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-04-10 00:00:00 |
| C1-10006110001825 | 41547633 | 254051140 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-04-10 00:00:00 |
| C1-10006110001825 | 41547633 | 254050540 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-04-10 00:00:00 |
| C1-10006110001825 | 41547633 | 254050140 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-04-09 00:00:00 |
| C1-10006110001825 | 41547633 | 254049763 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-04-09 00:00:00 |
| C1-10006110001825 | 41547633 | 255022652 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-06-12 09:15:00 |
| C1-10006110001825 | 41547633 | 255022481 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-06-12 10:38:00 |
| C1-10006110001825 | 41547633 | 255021888 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-06-10 16:55:00 |
| C1-10006110001825 | 41547633 | 253002220 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-05-29 21:53:00 |
| C1-10006110001825 | 41547633 | 248816724 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-04-06 00:00:00 |
| C1-10006110001825 | 41547633 | 248816492 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-04-06 00:00:00 |
| C1-10006110001825 | 41547633 | 248815918 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-04-04 00:00:00 |
| C1-10006110001825 | 41547633 | 248815565 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-04-04 00:00:00 |
| C1-10006110001825 | 41547633 | 248815191 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-04-04 00:00:00 |
| C1-10006110001825 | 41547633 | 248815167 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-04-04 00:00:00 |
| C1-10006110001825 | 41547633 | 248776894 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-04-05 00:00:00 |
| C1-10006110001825 | 41547633 | 250691996 | 2024-12-24 13:04:00 | 2025-04-16 09:56:00 | 2025-04-07 00:00:00 |
Sales Integrity
CCRS vs WA DOR Sales Comparison
ccrs_sales <- dbGetQuery(con, "
SELECT
strftime(TRY_CAST(h.CreatedDate AS TIMESTAMP), '%Y') AS Year,
ROUND(
SUM(
TRY_CAST(d.UnitPrice AS DOUBLE) *
TRY_CAST(d.Quantity AS DOUBLE)
), 2
) AS CCRS_Sales,
ROUND(
SUM(
(TRY_CAST(d.UnitPrice AS DOUBLE) * TRY_CAST(d.Quantity AS DOUBLE)) +
COALESCE(TRY_CAST(d.SalesTax AS DOUBLE), 0)
), 2
) AS CCRS_Sales_With_Tax
FROM sales_detail_all d
JOIN sale_header_all h
ON d.SaleHeaderId = h.SaleHeaderId
WHERE
TRY_CAST(h.CreatedDate AS TIMESTAMP) IS NOT NULL AND
TRY_CAST(d.UnitPrice AS DOUBLE) IS NOT NULL AND
TRY_CAST(d.Quantity AS DOUBLE) IS NOT NULL
GROUP BY Year
ORDER BY Year DESC
")| Year | CCRS Sales (No Tax) | With Tax | DOR Estimate | Difference |
|---|---|---|---|---|
| 2025 | $1,378,790,373 | $1,420,003,984 | $1,200,000,000 | $178,790,373 |
| 2024 | $104,581,905 | $105,226,987 | $1,100,000,000 | ($995,418,095) |
| 2023 | $13,866,789 | $14,701,872 | $900,000,000 | ($886,133,211) |
| 2022 | $59,233,915 | $59,838,860 | $1,300,000,000 | ($1,240,766,085) |
| 2021 | $5,421,162 | $5,902,238 |
Outlier Sales Transactions
outliers <- dbGetQuery(con, "
SELECT
d.SaleDetailId,
h.LicenseeId,
strftime(TRY_CAST(h.CreatedDate AS TIMESTAMP), '%Y') AS Year,
p.InventoryType,
TRY_CAST(d.UnitPrice AS DOUBLE) AS UnitPrice,
TRY_CAST(d.Quantity AS DOUBLE) AS Quantity,
TRY_CAST(d.UnitPrice AS DOUBLE) * TRY_CAST(d.Quantity AS DOUBLE) AS TotalPrice
FROM sales_detail_all d
JOIN sale_header_all h
ON d.SaleHeaderId = h.SaleHeaderId
LEFT JOIN inventory_all i
ON d.InventoryId = i.InventoryId
LEFT JOIN product_all p
ON i.ProductId = p.ProductId
WHERE
TRY_CAST(d.UnitPrice AS DOUBLE) * TRY_CAST(d.Quantity AS DOUBLE) > 10000
OR TRY_CAST(d.UnitPrice AS DOUBLE) > 1000
ORDER BY TotalPrice DESC
LIMIT 500
")| SaleDetailId | LicenseeId | Year | InventoryType | UnitPrice | Quantity | TotalPrice |
|---|---|---|---|---|---|---|
| 251892012 | 2417 | 2025 | NA | 1.55 | 100,000.00 | 155,000.00 |
| 251892012 | 2417 | 2025 | NA | 1.55 | 100,000.00 | 155,000.00 |
| 251892012 | 2417 | 2025 | NA | 1.55 | 100,000.00 | 155,000.00 |
| 255649262 | 3057 | 2025 | NA | 1.35 | 112,884.00 | 152,393.40 |
| 255649262 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.35 | 112,884.00 | 152,393.40 |
| 255649262 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.35 | 112,884.00 | 152,393.40 |
| 255649262 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.35 | 112,884.00 | 152,393.40 |
| 255649262 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.35 | 112,884.00 | 152,393.40 |
| 255649262 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.35 | 112,884.00 | 152,393.40 |
| 262125808 | 503 | 2025 | Plant | 24.26 | 5,000.00 | 121,300.00 |
| 263102943 | 2679 | 2025 | Plant | 24.26 | 5,000.00 | 121,300.00 |
| 262054904 | 387 | 2025 | Plant | 24.26 | 5,000.00 | 121,300.00 |
| 250070389 | 2985 | 2025 | NA | 0.13 | 736,770.00 | 95,780.10 |
| 250070389 | 2985 | 2025 | NA | 0.13 | 736,770.00 | 95,780.10 |
| 250070389 | 2985 | 2025 | NA | 0.13 | 736,770.00 | 95,780.10 |
| 250070389 | 2985 | 2025 | NA | 0.13 | 736,770.00 | 95,780.10 |
| 264625155 | 2472 | 2025 | NA | 0.02 | 4,747,067.00 | 94,941.34 |
| 250125386 | 2985 | 2025 | Flower Unlotted | 0.13 | 726,990.00 | 94,508.70 |
| 268142188 | 2381 | 2025 | Plant | 30.22 | 3,000.00 | 90,660.00 |
| 268141937 | 2508 | 2025 | Plant | 30.22 | 3,000.00 | 90,660.00 |
| 268142188 | 2381 | 2025 | Plant | 30.22 | 3,000.00 | 90,660.00 |
| 263314426 | 3149 | 2025 | Flower Lot | 0.09 | 971,685.00 | 87,451.65 |
| 264625158 | 2472 | 2025 | NA | 0.02 | 4,221,840.00 | 84,436.80 |
| 248041855 | 2998 | 2025 | Ethanol Concentrate | 2.00 | 40,000.00 | 80,000.00 |
| 248041855 | 2998 | 2025 | Ethanol Concentrate | 2.00 | 40,000.00 | 80,000.00 |
| 248041855 | 2998 | 2025 | Ethanol Concentrate | 2.00 | 40,000.00 | 80,000.00 |
| 248041855 | 2998 | 2025 | Ethanol Concentrate | 2.00 | 40,000.00 | 80,000.00 |
| 248041855 | 2998 | 2025 | Ethanol Concentrate | 2.00 | 40,000.00 | 80,000.00 |
| 248041855 | 2998 | 2025 | Ethanol Concentrate | 2.00 | 40,000.00 | 80,000.00 |
| 248058920 | 2751 | 2025 | Flower Lot | 0.60 | 131,715.00 | 79,029.00 |
| 248058920 | 2751 | 2025 | Flower Lot | 0.60 | 131,715.00 | 79,029.00 |
| 248058920 | 2751 | 2025 | Flower Lot | 0.60 | 131,715.00 | 79,029.00 |
| 248058920 | 2751 | 2025 | Flower Lot | 0.60 | 131,715.00 | 79,029.00 |
| 248058920 | 2751 | 2025 | Flower Lot | 0.60 | 131,715.00 | 79,029.00 |
| 248058920 | 2751 | 2025 | Flower Lot | 0.60 | 131,715.00 | 79,029.00 |
| 262178820 | 3136 | 2025 | Food Grade Solvent Concentrate | 1.35 | 56,438.00 | 76,191.30 |
| 264625156 | 2472 | 2025 | NA | 0.02 | 3,655,050.00 | 73,101.00 |
| 266284996 | 2998 | 2025 | Concentrate For Inhalation | 10.00 | 7,000.00 | 70,000.00 |
| 266284995 | 2998 | 2025 | Concentrate For Inhalation | 10.00 | 7,000.00 | 70,000.00 |
| 266284995 | 2998 | 2025 | Concentrate For Inhalation | 10.00 | 7,000.00 | 70,000.00 |
| 266284996 | 2998 | 2025 | Concentrate For Inhalation | 10.00 | 7,000.00 | 70,000.00 |
| 266284996 | 2998 | 2025 | Concentrate For Inhalation | 10.00 | 7,000.00 | 70,000.00 |
| 262027283 | 2417 | 2025 | Food Grade Solvent Concentrate | 1.55 | 45,000.00 | 69,750.00 |
| 262030205 | 2417 | 2025 | NA | 1.35 | 50,000.00 | 67,500.00 |
| 262031010 | 2417 | 2025 | NA | 1.35 | 50,000.00 | 67,500.00 |
| 262030369 | 2417 | 2025 | NA | 1.35 | 50,000.00 | 67,500.00 |
| 263046646 | 2417 | 2025 | NA | 1.35 | 50,000.00 | 67,500.00 |
| 262484723 | 1431 | 2025 | NA | 1.35 | 50,000.00 | 67,500.00 |
| 262030662 | 2417 | 2025 | NA | 1.35 | 49,000.00 | 66,150.00 |
| 262355219 | 3029 | 2025 | NA | 1.30 | 50,000.00 | 65,000.00 |
| 273948802 | 1541 | 2025 | Plant | 25.00 | 2,500.00 | 62,500.00 |
| 263295865 | 3111 | 2025 | Flower Unlotted | 0.15 | 415,859.00 | 62,378.85 |
| 251929745 | 262 | 2025 | NA | 1.00 | 62,167.00 | 62,167.00 |
| 251929745 | 262 | 2025 | NA | 1.00 | 62,167.00 | 62,167.00 |
| 251929745 | 262 | 2025 | NA | 1.00 | 62,167.00 | 62,167.00 |
| 166944393 | 2345 | 2024 | NA | 0.18 | 340,046.00 | 61,208.28 |
| 166944393 | 2345 | 2024 | NA | 0.18 | 340,046.00 | 61,208.28 |
| 166944393 | 2345 | 2024 | NA | 0.18 | 340,046.00 | 61,208.28 |
| 166944393 | 2345 | 2024 | NA | 0.18 | 340,046.00 | 61,208.28 |
| 166944393 | 2345 | 2024 | NA | 0.18 | 340,046.00 | 61,208.28 |
| 166944393 | 2345 | 2024 | NA | 0.18 | 340,046.00 | 61,208.28 |
| 263130854 | 3029 | 2025 | NA | 1.35 | 45,000.00 | 60,750.00 |
| 251976643 | 3029 | 2025 | NA | 1.50 | 40,000.00 | 60,000.00 |
| 266284997 | 2998 | 2025 | Concentrate For Inhalation | 10.00 | 6,000.00 | 60,000.00 |
| 266284997 | 2998 | 2025 | Concentrate For Inhalation | 10.00 | 6,000.00 | 60,000.00 |
| 266284997 | 2998 | 2025 | Concentrate For Inhalation | 10.00 | 6,000.00 | 60,000.00 |
| 266284997 | 2998 | 2025 | Concentrate For Inhalation | 10.00 | 6,000.00 | 60,000.00 |
| 251877474 | 3080 | 2025 | NA | 1.63 | 36,605.00 | 59,666.15 |
| 263168086 | 3111 | 2025 | Flower Unlotted | 0.15 | 391,348.00 | 58,702.20 |
| 286141134 | 3029 | 2025 | NA | 1.15 | 50,000.00 | 57,500.00 |
| 286141134 | 3029 | 2025 | NA | 1.15 | 50,000.00 | 57,500.00 |
| 251984733 | 1785 | 2025 | NA | 1.30 | 43,412.00 | 56,435.60 |
| 282864940 | 2597 | 2025 | Flower Unlotted | 0.02 | 2,782,883.80 | 55,657.68 |
| 250070390 | 2985 | 2025 | NA | 0.13 | 417,150.00 | 54,229.50 |
| 250070390 | 2985 | 2025 | NA | 0.13 | 417,150.00 | 54,229.50 |
| 250070390 | 2985 | 2025 | NA | 0.13 | 417,150.00 | 54,229.50 |
| 250070390 | 2985 | 2025 | NA | 0.13 | 417,150.00 | 54,229.50 |
| 250070390 | 2985 | 2025 | NA | 0.13 | 417,150.00 | 54,229.50 |
| 262030088 | 2417 | 2025 | NA | 1.35 | 40,000.00 | 54,000.00 |
| 262029708 | 2417 | 2025 | NA | 1.35 | 40,000.00 | 54,000.00 |
| 262115876 | 1356 | 2025 | NA | 0.88 | 60,410.00 | 53,160.80 |
| 262030811 | 2417 | 2025 | NA | 1.35 | 39,000.00 | 52,650.00 |
| 243327651 | 878 | 2025 | NA | 4.50 | 11,543.00 | 51,943.50 |
| 255922804 | 2998 | 2025 | Concentrate For Inhalation | 5.00 | 10,000.00 | 50,000.00 |
| 255922804 | 2998 | 2025 | Concentrate For Inhalation | 5.00 | 10,000.00 | 50,000.00 |
| 255922804 | 2998 | 2025 | Concentrate For Inhalation | 5.00 | 10,000.00 | 50,000.00 |
| 255922804 | 2998 | 2025 | Concentrate For Inhalation | 5.00 | 10,000.00 | 50,000.00 |
| 255922804 | 2998 | 2025 | Concentrate For Inhalation | 5.00 | 10,000.00 | 50,000.00 |
| 255922804 | 2998 | 2025 | Concentrate For Inhalation | 5.00 | 10,000.00 | 50,000.00 |
| 255922804 | 2998 | 2025 | Concentrate For Inhalation | 5.00 | 10,000.00 | 50,000.00 |
| 255922804 | 2998 | 2025 | Concentrate For Inhalation | 5.00 | 10,000.00 | 50,000.00 |
| 243293594 | 358 | 2025 | NA | 0.07 | 694,850.00 | 48,639.50 |
| 262115883 | 1356 | 2025 | Flower Unlotted | 0.88 | 55,180.00 | 48,558.40 |
| 262115883 | 1356 | 2025 | Flower Unlotted | 0.88 | 55,180.00 | 48,558.40 |
| 262115883 | 1356 | 2025 | Flower Unlotted | 0.88 | 55,180.00 | 48,558.40 |
| 262115883 | 1356 | 2025 | Flower Unlotted | 0.88 | 55,180.00 | 48,558.40 |
| 282864939 | 2534 | 2025 | Flower Unlotted | 0.02 | 2,405,609.80 | 48,112.20 |
| 287051815 | 2597 | 2025 | Flower Unlotted | 0.02 | 2,402,613.40 | 48,052.27 |
| 262339263 | 1887 | 2025 | NA | 12.00 | 4,000.00 | 48,000.00 |
| 262857535 | 3111 | 2025 | Flower Unlotted | 0.15 | 319,616.00 | 47,942.40 |
| 262255590 | 1785 | 2025 | NA | 1.35 | 35,263.00 | 47,605.05 |
| 250979653 | 2862 | 2025 | Flower Lot | 6.45 | 7,348.00 | 47,394.60 |
| 280060334 | 2597 | 2025 | Flower Unlotted | 0.02 | 2,325,524.20 | 46,510.48 |
| 287051043 | 2534 | 2025 | Flower Unlotted | 0.02 | 2,303,686.80 | 46,073.74 |
| 261776051 | 1431 | 2025 | NA | 1.35 | 34,000.00 | 45,900.00 |
| 241856598 | 358 | 2025 | NA | 0.07 | 655,540.00 | 45,887.80 |
| 273958774 | 2870 | 2025 | Flower Unlotted | 1.00 | 45,886.00 | 45,886.00 |
| 261875126 | 560 | 2025 | NA | 0.01 | 4,535,924.00 | 45,359.24 |
| 262430371 | 2949 | 2025 | Flower Unlotted | 0.01 | 4,535,923.00 | 45,359.23 |
| 243293593 | 358 | 2025 | NA | 0.07 | 628,640.00 | 44,004.80 |
| 243311488 | 2989 | 2025 | NA | 1.00 | 43,827.00 | 43,827.00 |
| 268137632 | 2447 | 2025 | Plant | 24.26 | 1,786.00 | 43,328.36 |
| 248577714 | 1947 | 2025 | NA | 2.00 | 21,635.00 | 43,270.00 |
| 243293591 | 358 | 2025 | NA | 0.07 | 617,220.00 | 43,205.40 |
| 262132955 | 2872 | 2025 | Other Material Unlotted | 0.03 | 1,413,502.00 | 42,405.06 |
| 250070388 | 2985 | 2025 | NA | 0.13 | 325,210.00 | 42,277.30 |
| 250070388 | 2985 | 2025 | NA | 0.13 | 325,210.00 | 42,277.30 |
| 250070388 | 2985 | 2025 | NA | 0.13 | 325,210.00 | 42,277.30 |
| 250070388 | 2985 | 2025 | NA | 0.13 | 325,210.00 | 42,277.30 |
| 262026761 | 1889 | 2025 | Flower Unlotted | 0.94 | 44,452.00 | 41,784.88 |
| 268137631 | 2447 | 2025 | Plant | 24.26 | 1,718.00 | 41,678.68 |
| 261875128 | 560 | 2025 | NA | 0.01 | 4,082,332.00 | 40,823.32 |
| 262435491 | 2933 | 2025 | Flower Unlotted | 0.01 | 4,082,332.00 | 40,823.32 |
| 262435349 | 2933 | 2025 | Flower Unlotted | 0.01 | 4,082,331.60 | 40,823.32 |
| 261888880 | 2865 | 2025 | Flower Unlotted | 0.01 | 4,082,331.60 | 40,823.32 |
| 264625160 | 2933 | 2025 | Flower Unlotted | 0.01 | 4,082,331.60 | 40,823.32 |
| 261888878 | 2865 | 2025 | Flower Unlotted | 0.01 | 4,082,331.60 | 40,823.32 |
| 261888878 | 2865 | 2025 | Flower Unlotted | 0.01 | 4,082,331.60 | 40,823.32 |
| 262435349 | 2933 | 2025 | Flower Unlotted | 0.01 | 4,082,331.60 | 40,823.32 |
| 262435364 | 2933 | 2025 | Flower Unlotted | 0.01 | 4,082,331.60 | 40,823.32 |
| 264625160 | 2933 | 2025 | Flower Unlotted | 0.01 | 4,082,331.60 | 40,823.32 |
| 262445106 | 2865 | 2025 | Flower Unlotted | 0.01 | 4,082,331.00 | 40,823.31 |
| 261888885 | 2865 | 2025 | NA | 0.01 | 4,082,331.00 | 40,823.31 |
| 262435458 | 2933 | 2025 | Flower Unlotted | 0.01 | 4,082,331.00 | 40,823.31 |
| 261888884 | 2865 | 2025 | Flower Unlotted | 0.01 | 4,082,331.00 | 40,823.31 |
| 262445106 | 2865 | 2025 | Flower Unlotted | 0.01 | 4,082,331.00 | 40,823.31 |
| 261815749 | 2933 | 2025 | Flower Unlotted | 0.01 | 4,082,331.00 | 40,823.31 |
| 262445106 | 2865 | 2025 | Flower Unlotted | 0.01 | 4,082,331.00 | 40,823.31 |
| 262445106 | 2865 | 2025 | Flower Unlotted | 0.01 | 4,082,331.00 | 40,823.31 |
| 262445106 | 2865 | 2025 | Flower Unlotted | 0.01 | 4,082,331.00 | 40,823.31 |
| 261875127 | 560 | 2025 | NA | 0.01 | 4,082,331.00 | 40,823.31 |
| 261888883 | 2865 | 2025 | NA | 0.01 | 4,082,331.00 | 40,823.31 |
| 261888885 | 2865 | 2025 | NA | 0.01 | 4,082,331.00 | 40,823.31 |
| 261888883 | 2865 | 2025 | NA | 0.01 | 4,082,331.00 | 40,823.31 |
| 261815750 | 2933 | 2025 | Flower Unlotted | 0.01 | 4,082,331.00 | 40,823.31 |
| 262435459 | 2933 | 2025 | Flower Unlotted | 0.01 | 4,082,331.00 | 40,823.31 |
| 261888885 | 2865 | 2025 | NA | 0.01 | 4,082,331.00 | 40,823.31 |
| 261888884 | 2865 | 2025 | Flower Unlotted | 0.01 | 4,082,331.00 | 40,823.31 |
| 262445106 | 2865 | 2025 | Flower Unlotted | 0.01 | 4,082,331.00 | 40,823.31 |
| 261815789 | 2933 | 2025 | Flower Unlotted | 0.01 | 4,082,331.00 | 40,823.31 |
| 261815750 | 2933 | 2025 | Flower Unlotted | 0.01 | 4,082,331.00 | 40,823.31 |
| 262445106 | 2865 | 2025 | Flower Unlotted | 0.01 | 4,082,331.00 | 40,823.31 |
| 261888883 | 2865 | 2025 | NA | 0.01 | 4,082,331.00 | 40,823.31 |
| 261888885 | 2865 | 2025 | NA | 0.01 | 4,082,331.00 | 40,823.31 |
| 262445106 | 2865 | 2025 | Flower Unlotted | 0.01 | 4,082,331.00 | 40,823.31 |
| 261888883 | 2865 | 2025 | NA | 0.01 | 4,082,331.00 | 40,823.31 |
| 261815789 | 2933 | 2025 | Flower Unlotted | 0.01 | 4,082,331.00 | 40,823.31 |
| 264625183 | 2933 | 2025 | Flower Unlotted | 0.01 | 4,082,330.00 | 40,823.30 |
| 263191963 | 2949 | 2025 | NA | 0.01 | 4,082,328.00 | 40,823.28 |
| 262984176 | 2933 | 2025 | Flower Unlotted | 0.01 | 4,082,328.00 | 40,823.28 |
| 262984176 | 2933 | 2025 | Flower Unlotted | 0.01 | 4,082,328.00 | 40,823.28 |
| 262984176 | 2933 | 2025 | Flower Unlotted | 0.01 | 4,082,328.00 | 40,823.28 |
| 262984176 | 2933 | 2025 | Flower Unlotted | 0.01 | 4,082,328.00 | 40,823.28 |
| 287081298 | 2597 | 2025 | Flower Unlotted | 0.02 | 2,039,958.20 | 40,799.16 |
| 273969050 | 2439 | 2025 | Plant | 25.00 | 1,610.00 | 40,250.00 |
| 255645401 | 2998 | 2025 | Concentrate For Inhalation | 5.00 | 8,000.00 | 40,000.00 |
| 252077642 | 2998 | 2025 | Concentrate For Inhalation | 5.00 | 8,000.00 | 40,000.00 |
| 263295868 | 3111 | 2025 | Flower Unlotted | 0.15 | 261,277.00 | 39,191.55 |
| 264625157 | 2472 | 2025 | NA | 0.02 | 1,940,140.00 | 38,802.80 |
| 255532485 | 2870 | 2025 | Flower Unlotted | 1.00 | 38,593.00 | 38,593.00 |
| 255532485 | 2870 | 2025 | Flower Unlotted | 1.00 | 38,593.00 | 38,593.00 |
| 255532485 | 2870 | 2025 | Flower Unlotted | 1.00 | 38,593.00 | 38,593.00 |
| 255532485 | 2870 | 2025 | Flower Unlotted | 1.00 | 38,593.00 | 38,593.00 |
| 261888879 | 2865 | 2025 | NA | 0.01 | 3,855,535.00 | 38,555.35 |
| 262016812 | 1618 | 2025 | Flower Unlotted | 1.21 | 31,780.00 | 38,453.80 |
| 271103646 | 2534 | 2025 | Flower Unlotted | 0.02 | 1,917,786.80 | 38,355.74 |
| 255650050 | 2930 | 2025 | NA | 1.35 | 28,070.00 | 37,894.50 |
| 255652966 | 1179 | 2025 | NA | 1.25 | 30,000.00 | 37,500.00 |
| 262848645 | 1179 | 2025 | NA | 1.25 | 30,000.00 | 37,500.00 |
| 263212592 | 1179 | 2025 | NA | 1.25 | 30,000.00 | 37,500.00 |
| 255652966 | 1179 | 2025 | NA | 1.25 | 30,000.00 | 37,500.00 |
| 247768736 | 1179 | 2025 | NA | 1.25 | 30,000.00 | 37,500.00 |
| 247768736 | 1179 | 2025 | NA | 1.25 | 30,000.00 | 37,500.00 |
| 263212592 | 1179 | 2025 | NA | 1.25 | 30,000.00 | 37,500.00 |
| 262848645 | 1179 | 2025 | NA | 1.25 | 30,000.00 | 37,500.00 |
| 262176706 | 266 | 2025 | NA | 1.23 | 30,000.00 | 36,900.00 |
| 243293592 | 358 | 2025 | NA | 0.07 | 524,820.00 | 36,737.40 |
| 262430370 | 2949 | 2025 | Flower Unlotted | 0.01 | 3,665,025.00 | 36,650.25 |
| 262430370 | 2949 | 2025 | Flower Unlotted | 0.01 | 3,665,025.00 | 36,650.25 |
| 253976057 | 2930 | 2025 | NA | 1.20 | 30,492.00 | 36,590.40 |
| 262115893 | 1356 | 2025 | NA | 1.16 | 31,326.00 | 36,338.16 |
| 262115893 | 1356 | 2025 | NA | 1.16 | 31,326.00 | 36,338.16 |
| 262115893 | 1356 | 2025 | NA | 1.16 | 31,326.00 | 36,338.16 |
| 262115893 | 1356 | 2025 | NA | 1.16 | 31,326.00 | 36,338.16 |
| 263327686 | 2447 | 2025 | Plant | 24.26 | 1,496.00 | 36,292.96 |
| 243293590 | 358 | 2025 | NA | 0.07 | 517,370.00 | 36,215.90 |
| 247203058 | 576 | 2025 | NA | 0.28 | 129,273.83 | 36,196.67 |
| 262237250 | 3149 | 2025 | Flower Unlotted | 0.09 | 401,347.00 | 36,121.23 |
| 246103855 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 246103855 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 248053757 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 248053757 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 246103855 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 246103855 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 248053757 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 246103855 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 246103855 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 248053757 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 246103855 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 248053757 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 246103855 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 246103855 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 248053757 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 246103855 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 248053757 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 246103855 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 246103855 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 248053757 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 246103855 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 246103855 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 246103855 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 246103855 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 246103855 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 248053757 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 246103855 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 248053757 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 262338340 | 1887 | 2025 | NA | 12.00 | 3,000.00 | 36,000.00 |
| 248053757 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 248053757 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 248053757 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 248041953 | 2998 | 2025 | NA | 6.00 | 6,000.00 | 36,000.00 |
| 248053757 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 248053757 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 246103855 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 262338340 | 1887 | 2025 | NA | 12.00 | 3,000.00 | 36,000.00 |
| 248053757 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 246103855 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 246103855 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 246103855 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 246103855 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 246103855 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 248041953 | 2998 | 2025 | NA | 6.00 | 6,000.00 | 36,000.00 |
| 248053757 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 246103855 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 248053757 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 248053757 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 256124701 | 2998 | 2025 | NA | 6.00 | 6,000.00 | 36,000.00 |
| 246103855 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 246103855 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 246103855 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 246103855 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 248053757 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 246103855 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 30,000.00 | 36,000.00 |
| 255025070 | 1946 | 2025 | NA | 0.35 | 102,854.00 | 35,998.90 |
| 255025070 | 1946 | 2025 | NA | 0.35 | 102,854.00 | 35,998.90 |
| 255025070 | 1946 | 2025 | NA | 0.35 | 102,854.00 | 35,998.90 |
| 255025070 | 1946 | 2025 | NA | 0.35 | 102,854.00 | 35,998.90 |
| 255025070 | 1946 | 2025 | NA | 0.35 | 102,854.00 | 35,998.90 |
| 247768162 | 3057 | 2025 | Food Grade Solvent Concentrate | 0.77 | 46,331.00 | 35,674.87 |
| 247768162 | 3057 | 2025 | Food Grade Solvent Concentrate | 0.77 | 46,331.00 | 35,674.87 |
| 247768162 | 3057 | 2025 | Food Grade Solvent Concentrate | 0.77 | 46,331.00 | 35,674.87 |
| 247768162 | 3057 | 2025 | Food Grade Solvent Concentrate | 0.77 | 46,331.00 | 35,674.87 |
| 247768162 | 3057 | 2025 | Food Grade Solvent Concentrate | 0.77 | 46,331.00 | 35,674.87 |
| 262126362 | 3064 | 2025 | NA | 1.15 | 31,000.00 | 35,650.00 |
| 256124699 | 2998 | 2025 | NA | 3.50 | 10,000.00 | 35,000.00 |
| 250848869 | 1279 | 2024 | Ethanol Concentrate | 1.75 | 20,000.00 | 35,000.00 |
| 250848869 | 1279 | 2024 | Ethanol Concentrate | 1.75 | 20,000.00 | 35,000.00 |
| 250848869 | 1279 | 2024 | Ethanol Concentrate | 1.75 | 20,000.00 | 35,000.00 |
| 250848869 | 1279 | 2024 | Ethanol Concentrate | 1.75 | 20,000.00 | 35,000.00 |
| 250848869 | 1279 | 2024 | Ethanol Concentrate | 1.75 | 20,000.00 | 35,000.00 |
| 250848869 | 1279 | 2024 | Ethanol Concentrate | 1.75 | 20,000.00 | 35,000.00 |
| 250848869 | 1279 | 2024 | Ethanol Concentrate | 1.75 | 20,000.00 | 35,000.00 |
| 250848869 | 1279 | 2024 | Ethanol Concentrate | 1.75 | 20,000.00 | 35,000.00 |
| 250848869 | 1279 | 2024 | Ethanol Concentrate | 1.75 | 20,000.00 | 35,000.00 |
| 250848869 | 1279 | 2024 | Ethanol Concentrate | 1.75 | 20,000.00 | 35,000.00 |
| 250848869 | 1279 | 2024 | Ethanol Concentrate | 1.75 | 20,000.00 | 35,000.00 |
| 250848869 | 1279 | 2024 | Ethanol Concentrate | 1.75 | 20,000.00 | 35,000.00 |
| 250848869 | 1279 | 2024 | Ethanol Concentrate | 1.75 | 20,000.00 | 35,000.00 |
| 250848869 | 1279 | 2024 | Ethanol Concentrate | 1.75 | 20,000.00 | 35,000.00 |
| 250848869 | 1279 | 2024 | Ethanol Concentrate | 1.75 | 20,000.00 | 35,000.00 |
| 250848869 | 1279 | 2024 | Ethanol Concentrate | 1.75 | 20,000.00 | 35,000.00 |
| 250848869 | 1279 | 2024 | Ethanol Concentrate | 1.75 | 20,000.00 | 35,000.00 |
| 250848869 | 1279 | 2024 | Ethanol Concentrate | 1.75 | 20,000.00 | 35,000.00 |
| 250848869 | 1279 | 2024 | Ethanol Concentrate | 1.75 | 20,000.00 | 35,000.00 |
| 250848869 | 1279 | 2024 | Ethanol Concentrate | 1.75 | 20,000.00 | 35,000.00 |
| 250848869 | 1279 | 2024 | Ethanol Concentrate | 1.75 | 20,000.00 | 35,000.00 |
| 250848869 | 1279 | 2024 | Ethanol Concentrate | 1.75 | 20,000.00 | 35,000.00 |
| 250848869 | 1279 | 2024 | Ethanol Concentrate | 1.75 | 20,000.00 | 35,000.00 |
| 250848869 | 1279 | 2024 | Ethanol Concentrate | 1.75 | 20,000.00 | 35,000.00 |
| 250848869 | 1279 | 2024 | Ethanol Concentrate | 1.75 | 20,000.00 | 35,000.00 |
| 250848869 | 1279 | 2024 | Ethanol Concentrate | 1.75 | 20,000.00 | 35,000.00 |
| 250848869 | 1279 | 2024 | Ethanol Concentrate | 1.75 | 20,000.00 | 35,000.00 |
| 250848869 | 1279 | 2024 | Ethanol Concentrate | 1.75 | 20,000.00 | 35,000.00 |
| 250848869 | 1279 | 2024 | Ethanol Concentrate | 1.75 | 20,000.00 | 35,000.00 |
| 250848869 | 1279 | 2024 | Ethanol Concentrate | 1.75 | 20,000.00 | 35,000.00 |
| 243293608 | 358 | 2025 | NA | 0.07 | 497,080.00 | 34,795.60 |
| 261874588 | 1947 | 2025 | NA | 2.00 | 17,330.00 | 34,660.00 |
| 255680395 | 249 | 2025 | Hydrocarbon Concentrate | 2.00 | 17,290.00 | 34,580.00 |
| 255680395 | 249 | 2025 | Hydrocarbon Concentrate | 2.00 | 17,290.00 | 34,580.00 |
| 255680395 | 249 | 2025 | Hydrocarbon Concentrate | 2.00 | 17,290.00 | 34,580.00 |
| 255680395 | 249 | 2025 | Hydrocarbon Concentrate | 2.00 | 17,290.00 | 34,580.00 |
| 286171735 | 1692 | 2025 | NA | 0.01 | 3,440,920.00 | 34,409.20 |
| 231744199 | 2862 | 2025 | NA | 2.81 | 12,205.00 | 34,296.05 |
| 263191961 | 2949 | 2025 | Flower Unlotted | 0.01 | 3,429,158.00 | 34,291.58 |
| 263191961 | 2949 | 2025 | Flower Unlotted | 0.01 | 3,429,158.00 | 34,291.58 |
| 287069222 | 2586 | 2025 | Other Material Lot | 0.75 | 45,400.00 | 34,050.00 |
| 287069222 | 2586 | 2025 | Other Material Lot | 0.75 | 45,400.00 | 34,050.00 |
| 287069222 | 2586 | 2025 | Other Material Lot | 0.75 | 45,400.00 | 34,050.00 |
| 287069222 | 2586 | 2025 | Other Material Lot | 0.75 | 45,400.00 | 34,050.00 |
| 287069222 | 2586 | 2025 | Other Material Lot | 0.75 | 45,400.00 | 34,050.00 |
| 262115887 | 1356 | 2025 | NA | 0.88 | 37,920.00 | 33,369.60 |
| 262115887 | 1356 | 2025 | NA | 0.88 | 37,920.00 | 33,369.60 |
| 251918469 | 1947 | 2025 | NA | 2.00 | 16,650.00 | 33,300.00 |
| 251983866 | 3029 | 2025 | NA | 1.35 | 24,000.00 | 32,400.00 |
| 251983866 | 3029 | 2025 | NA | 1.35 | 24,000.00 | 32,400.00 |
| 262241477 | 1519 | 2025 | NA | 0.75 | 43,186.00 | 32,389.50 |
| 261785508 | 2930 | 2025 | NA | 1.45 | 22,297.00 | 32,330.65 |
| 261989201 | 2239 | 2025 | Flower Unlotted | 0.11 | 292,567.07 | 32,182.38 |
| 251792084 | 3057 | 2025 | Food Grade Solvent Concentrate | 0.74 | 43,480.00 | 32,175.20 |
| 251792084 | 3057 | 2025 | Food Grade Solvent Concentrate | 0.74 | 43,480.00 | 32,175.20 |
| 251792084 | 3057 | 2025 | Food Grade Solvent Concentrate | 0.74 | 43,480.00 | 32,175.20 |
| 251792084 | 3057 | 2025 | Food Grade Solvent Concentrate | 0.74 | 43,480.00 | 32,175.20 |
| 251792084 | 3057 | 2025 | Food Grade Solvent Concentrate | 0.74 | 43,480.00 | 32,175.20 |
| 255959961 | 2930 | 2025 | NA | 1.50 | 21,441.00 | 32,161.50 |
| 255959961 | 2930 | 2025 | NA | 1.50 | 21,441.00 | 32,161.50 |
| 262026738 | 1889 | 2025 | NA | 0.94 | 34,019.00 | 31,977.86 |
| 262126326 | 3064 | 2025 | NA | 1.05 | 30,000.00 | 31,500.00 |
| 261785505 | 2930 | 2025 | Flower Lot | 1.45 | 21,713.00 | 31,483.85 |
| 262214781 | 358 | 2025 | NA | 0.04 | 786,600.00 | 31,464.00 |
| 274008501 | 262 | 2025 | Other Material Unlotted | 1.00 | 31,300.00 | 31,300.00 |
| 262176011 | 266 | 2025 | NA | 1.25 | 25,000.00 | 31,250.00 |
| 251984472 | 2489 | 2025 | Ethanol Concentrate | 1.35 | 23,000.00 | 31,050.00 |
| 248066529 | 2933 | 2025 | NA | 1.35 | 23,000.00 | 31,050.00 |
| 262027730 | 2417 | 2025 | Food Grade Solvent Concentrate | 1.55 | 20,000.00 | 31,000.00 |
| 262027623 | 2417 | 2025 | Food Grade Solvent Concentrate | 1.55 | 20,000.00 | 31,000.00 |
| 256164302 | 2865 | 2025 | Flower Unlotted | 0.01 | 3,098,943.20 | 30,989.43 |
| 251792121 | 2930 | 2025 | NA | 1.30 | 23,835.00 | 30,985.50 |
| 251792121 | 2930 | 2025 | NA | 1.30 | 23,835.00 | 30,985.50 |
| 251792121 | 2930 | 2025 | NA | 1.30 | 23,835.00 | 30,985.50 |
| 251792121 | 2930 | 2025 | NA | 1.30 | 23,835.00 | 30,985.50 |
| 251792121 | 2930 | 2025 | NA | 1.30 | 23,835.00 | 30,985.50 |
| 261926299 | 2490 | 2025 | Flower Unlotted | 1.21 | 25,575.00 | 30,945.75 |
| 261926299 | 2490 | 2025 | Flower Unlotted | 1.21 | 25,575.00 | 30,945.75 |
| 262240380 | 2313 | 2025 | NA | 0.80 | 38,500.00 | 30,800.00 |
| 262240380 | 2313 | 2025 | NA | 0.80 | 38,500.00 | 30,800.00 |
| 262240380 | 2313 | 2025 | NA | 0.80 | 38,500.00 | 30,800.00 |
| 262240380 | 2313 | 2025 | NA | 0.80 | 38,500.00 | 30,800.00 |
| 255485710 | 2930 | 2025 | NA | 1.40 | 21,991.00 | 30,787.40 |
| 255025071 | 1946 | 2025 | Flower Unlotted | 0.35 | 87,803.00 | 30,731.05 |
| 255025071 | 1946 | 2025 | Flower Unlotted | 0.35 | 87,803.00 | 30,731.05 |
| 255025071 | 1946 | 2025 | Flower Unlotted | 0.35 | 87,803.00 | 30,731.05 |
| 255025071 | 1946 | 2025 | Flower Unlotted | 0.35 | 87,803.00 | 30,731.05 |
| 261815797 | 2933 | 2025 | Flower Unlotted | 0.01 | 3,061,748.00 | 30,617.48 |
| 261989228 | 2405 | 2025 | Flower Unlotted | 1.00 | 30,545.00 | 30,545.00 |
| 251877473 | 3080 | 2025 | NA | 1.63 | 18,610.00 | 30,334.30 |
| 211232411 | 1742 | 2024 | NA | 1.85 | 16,327.20 | 30,205.32 |
| 255978835 | 3207 | 2025 | Plant | 0.83 | 36,287.00 | 30,118.21 |
| 255978835 | 3207 | 2025 | Plant | 0.83 | 36,287.00 | 30,118.21 |
| 255698520 | 2930 | 2025 | Flower Lot | 1.45 | 20,722.00 | 30,046.90 |
| 255698520 | 2930 | 2025 | Flower Lot | 1.45 | 20,722.00 | 30,046.90 |
| 255698520 | 2930 | 2025 | Flower Lot | 1.45 | 20,722.00 | 30,046.90 |
| 255959960 | 2930 | 2025 | NA | 1.50 | 20,003.00 | 30,004.50 |
| 255959960 | 2930 | 2025 | NA | 1.50 | 20,003.00 | 30,004.50 |
| 255008807 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 25,000.00 | 30,000.00 |
| 251991564 | 3064 | 2025 | NA | 1.25 | 24,000.00 | 30,000.00 |
| 251991554 | 3064 | 2025 | NA | 1.00 | 30,000.00 | 30,000.00 |
| 251991564 | 3064 | 2025 | NA | 1.25 | 24,000.00 | 30,000.00 |
| 255008807 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 25,000.00 | 30,000.00 |
| 255008807 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 25,000.00 | 30,000.00 |
| 255008807 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 25,000.00 | 30,000.00 |
| 255008807 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 25,000.00 | 30,000.00 |
| 255008807 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 25,000.00 | 30,000.00 |
| 255008807 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 25,000.00 | 30,000.00 |
| 251991559 | 3064 | 2025 | Concentrate For Inhalation | 1.25 | 24,000.00 | 30,000.00 |
| 251991564 | 3064 | 2025 | NA | 1.25 | 24,000.00 | 30,000.00 |
| 251991564 | 3064 | 2025 | NA | 1.25 | 24,000.00 | 30,000.00 |
| 255008807 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 25,000.00 | 30,000.00 |
| 255008807 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 25,000.00 | 30,000.00 |
| 261730132 | 3111 | 2025 | Hydrocarbon Concentrate | 3.00 | 10,000.00 | 30,000.00 |
| 255008807 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 25,000.00 | 30,000.00 |
| 255008807 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 25,000.00 | 30,000.00 |
| 255008807 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 25,000.00 | 30,000.00 |
| 255008807 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 25,000.00 | 30,000.00 |
| 251991564 | 3064 | 2025 | NA | 1.25 | 24,000.00 | 30,000.00 |
| 251991564 | 3064 | 2025 | NA | 1.25 | 24,000.00 | 30,000.00 |
| 251991564 | 3064 | 2025 | NA | 1.25 | 24,000.00 | 30,000.00 |
| 255008807 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 25,000.00 | 30,000.00 |
| 255008807 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 25,000.00 | 30,000.00 |
| 255008807 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 25,000.00 | 30,000.00 |
| 251991564 | 3064 | 2025 | NA | 1.25 | 24,000.00 | 30,000.00 |
| 261730132 | 3111 | 2025 | Hydrocarbon Concentrate | 3.00 | 10,000.00 | 30,000.00 |
| 255008807 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 25,000.00 | 30,000.00 |
| 255008807 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 25,000.00 | 30,000.00 |
| 255008807 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 25,000.00 | 30,000.00 |
| 255008807 | 3057 | 2025 | Food Grade Solvent Concentrate | 1.20 | 25,000.00 | 30,000.00 |
| 255698519 | 2930 | 2025 | NA | 1.45 | 20,526.00 | 29,762.70 |
| 255698519 | 2930 | 2025 | NA | 1.45 | 20,526.00 | 29,762.70 |
| 255698519 | 2930 | 2025 | NA | 1.45 | 20,526.00 | 29,762.70 |
| 251896300 | 1618 | 2025 | Flower Unlotted | 1.15 | 25,878.00 | 29,759.70 |
| 252030510 | 1261 | 2025 | NA | 1.00 | 29,700.00 | 29,700.00 |
| 252030510 | 1261 | 2025 | NA | 1.00 | 29,700.00 | 29,700.00 |
| 263077698 | 2870 | 2025 | Flower Unlotted | 1.00 | 29,547.00 | 29,547.00 |
| 255650052 | 2930 | 2025 | NA | 1.30 | 22,700.00 | 29,510.00 |
| 246096574 | 2710 | 2025 | Flower Lot | 6.50 | 4,540.00 | 29,510.00 |
| 261989221 | 2405 | 2025 | Flower Unlotted | 1.00 | 29,448.00 | 29,448.00 |
| 287050703 | 2933 | 2025 | NA | 1.50 | 19,544.70 | 29,317.05 |
| 243293601 | 358 | 2025 | NA | 0.07 | 418,480.00 | 29,293.60 |
| 255485711 | 2930 | 2025 | NA | 1.40 | 20,751.00 | 29,051.40 |
| 262081525 | 2511 | 2025 | NA | 1.00 | 28,984.55 | 28,984.55 |
| 251940587 | 1557 | 2025 | Hydrocarbon Concentrate | 3.59 | 8,000.00 | 28,720.00 |
| 251940587 | 1557 | 2025 | NA | 3.59 | 8,000.00 | 28,720.00 |
| 251940587 | 1557 | 2025 | Hydrocarbon Concentrate | 3.59 | 8,000.00 | 28,720.00 |
| 251929746 | 262 | 2025 | NA | 1.00 | 28,633.00 | 28,633.00 |
| 251882528 | 665 | 2025 | NA | 0.30 | 95,340.00 | 28,602.00 |
| 250313891 | 2748 | 2025 | Other Material Lot | 0.03 | 953,400.00 | 28,602.00 |
| 250313891 | 2748 | 2025 | Other Material Lot | 0.03 | 953,400.00 | 28,602.00 |
| 251882528 | 665 | 2025 | NA | 0.30 | 95,340.00 | 28,602.00 |
| 250313891 | 2748 | 2025 | Other Material Lot | 0.03 | 953,400.00 | 28,602.00 |
| 250313891 | 2748 | 2025 | Other Material Lot | 0.03 | 953,400.00 | 28,602.00 |
| 251882528 | 665 | 2025 | NA | 0.30 | 95,340.00 | 28,602.00 |
| 250313891 | 2748 | 2025 | Other Material Lot | 0.03 | 953,400.00 | 28,602.00 |
| 250313891 | 2748 | 2025 | Other Material Lot | 0.03 | 953,400.00 | 28,602.00 |
| 240192859 | 1742 | 2025 | NA | 1.80 | 15,803.80 | 28,446.84 |
| 251992394 | 2313 | 2025 | NA | 1.00 | 28,352.00 | 28,352.00 |
| 268167011 | 2313 | 2025 | NA | 0.80 | 35,221.00 | 28,176.80 |
| 268167011 | 2313 | 2025 | NA | 0.80 | 35,221.00 | 28,176.80 |
| 262240374 | 2313 | 2025 | NA | 0.87 | 32,343.00 | 28,138.41 |
| 252030511 | 1261 | 2025 | NA | 0.98 | 28,694.00 | 28,120.12 |
| 262115877 | 1356 | 2025 | NA | 0.88 | 31,885.00 | 28,058.80 |
| 262435158 | 2933 | 2025 | NA | 1.40 | 20,000.00 | 28,000.00 |
| 248641911 | 2933 | 2025 | NA | 1.40 | 20,000.00 | 28,000.00 |
| 248641911 | 2933 | 2025 | NA | 1.40 | 20,000.00 | 28,000.00 |
| 248641911 | 2933 | 2025 | NA | 1.40 | 20,000.00 | 28,000.00 |
| 248569807 | 2933 | 2025 | NA | 1.40 | 20,000.00 | 28,000.00 |
| 255265721 | 2998 | 2025 | NA | 3.50 | 8,000.00 | 28,000.00 |
| 248641911 | 2933 | 2025 | NA | 1.40 | 20,000.00 | 28,000.00 |
| 248569845 | 2933 | 2025 | NA | 1.40 | 20,000.00 | 28,000.00 |
| 254503399 | 3262 | 2025 | Flower Unlotted | 0.75 | 37,207.00 | 27,905.25 |
| 255698518 | 2930 | 2025 | NA | 1.45 | 19,205.00 | 27,847.25 |
| 255698518 | 2930 | 2025 | NA | 1.45 | 19,205.00 | 27,847.25 |
| 255698518 | 2930 | 2025 | NA | 1.45 | 19,205.00 | 27,847.25 |
| 261905493 | 1815 | 2025 | NA | 0.60 | 46,266.00 | 27,759.60 |
| 248569832 | 2933 | 2025 | NA | 1.45 | 19,000.00 | 27,550.00 |
| 28295077 | 1279 | 2022 | NA | 5.50 | 5,000.00 | 27,500.00 |
| 262214779 | 358 | 2025 | NA | 0.04 | 684,620.00 | 27,384.80 |
| 286173770 | 2862 | 2025 | Hydrocarbon Concentrate | 6.98 | 3,922.00 | 27,375.56 |
| 286173770 | 2862 | 2025 | Hydrocarbon Concentrate | 6.98 | 3,922.00 | 27,375.56 |
| 286173770 | 2862 | 2025 | Hydrocarbon Concentrate | 6.98 | 3,922.00 | 27,375.56 |
| 286173770 | 2862 | 2025 | Hydrocarbon Concentrate | 6.98 | 3,922.00 | 27,375.56 |
| 255865179 | 2949 | 2025 | Flower Unlotted | 0.01 | 2,735,618.00 | 27,356.18 |
| 255865179 | 2949 | 2025 | Flower Unlotted | 0.01 | 2,735,618.00 | 27,356.18 |
| 255865179 | 2949 | 2025 | Flower Unlotted | 0.01 | 2,735,618.00 | 27,356.18 |
| 255865179 | 2949 | 2025 | Flower Unlotted | 0.01 | 2,735,618.00 | 27,356.18 |
| 255865179 | 2949 | 2025 | Flower Unlotted | 0.01 | 2,735,618.00 | 27,356.18 |
| 255865179 | 2949 | 2025 | Flower Unlotted | 0.01 | 2,735,618.00 | 27,356.18 |
| 255865179 | 2949 | 2025 | Flower Unlotted | 0.01 | 2,735,618.00 | 27,356.18 |
| 255865179 | 2949 | 2025 | Flower Unlotted | 0.01 | 2,735,618.00 | 27,356.18 |
| 229816175 | 2652 | 2025 | NA | 1.88 | 14,514.88 | 27,287.97 |
| 287072198 | 2930 | 2025 | Flower Lot | 1.20 | 22,663.00 | 27,195.60 |
| 287072197 | 2930 | 2025 | NA | 1.20 | 22,645.00 | 27,174.00 |
| 262029505 | 2417 | 2025 | NA | 1.35 | 20,000.00 | 27,000.00 |
| 250908825 | 1279 | 2024 | NA | 9.00 | 3,000.00 | 27,000.00 |
| 250908825 | 1279 | 2024 | NA | 9.00 | 3,000.00 | 27,000.00 |
| 250908825 | 1279 | 2024 | NA | 9.00 | 3,000.00 | 27,000.00 |
| 250908825 | 1279 | 2024 | NA | 9.00 | 3,000.00 | 27,000.00 |
| 250908825 | 1279 | 2024 | NA | 9.00 | 3,000.00 | 27,000.00 |
| 287072196 | 2930 | 2025 | Flower Lot | 1.20 | 22,481.00 | 26,977.20 |
| 262430369 | 2949 | 2025 | Flower Unlotted | 0.01 | 2,684,905.00 | 26,849.05 |
| 262430369 | 2949 | 2025 | Flower Unlotted | 0.01 | 2,684,905.00 | 26,849.05 |
| 262324233 | 2862 | 2025 | NA | 1.32 | 20,327.00 | 26,831.64 |
| 251877112 | 2511 | 2025 | NA | 1.00 | 26,761.94 | 26,761.94 |
| 254502946 | 665 | 2025 | NA | 0.75 | 35,412.00 | 26,559.00 |
| 262214775 | 358 | 2025 | NA | 0.04 | 657,880.00 | 26,315.20 |
| 262237254 | 3149 | 2025 | Flower Unlotted | 0.09 | 292,185.00 | 26,296.65 |
| 268595476 | 2933 | 2025 | NA | 1.50 | 17,519.00 | 26,278.50 |
| 252013185 | 2883 | 2025 | NA | 1.65 | 15,890.00 | 26,218.50 |
| 252013185 | 2883 | 2025 | NA | 1.65 | 15,890.00 | 26,218.50 |
| 262179248 | 3136 | 2025 | Flower Unlotted | 0.50 | 52,163.12 | 26,081.56 |
| 262403154 | 3177 | 2025 | Flower Unlotted | 325.00 | 80.00 | 26,000.00 |
| 262435695 | 2933 | 2025 | NA | 1.30 | 20,000.00 | 26,000.00 |
| 262435695 | 2933 | 2025 | NA | 1.30 | 20,000.00 | 26,000.00 |
| 262435695 | 2933 | 2025 | NA | 1.30 | 20,000.00 | 26,000.00 |
| 262403154 | 3177 | 2025 | Flower Unlotted | 325.00 | 80.00 | 26,000.00 |
| 262435695 | 2933 | 2025 | NA | 1.30 | 20,000.00 | 26,000.00 |
| 263193722 | 249 | 2025 | Hydrocarbon Concentrate | 0.45 | 57,520.00 | 25,884.00 |
| 263193722 | 249 | 2025 | Hydrocarbon Concentrate | 0.45 | 57,520.00 | 25,884.00 |
| 262214782 | 358 | 2025 | NA | 0.04 | 645,240.00 | 25,809.60 |
| 261989202 | 2239 | 2025 | Flower Unlotted | 0.10 | 255,599.30 | 25,559.93 |
| 248066552 | 2933 | 2025 | NA | 1.50 | 17,000.00 | 25,500.00 |
| 248641897 | 2933 | 2025 | NA | 1.50 | 17,000.00 | 25,500.00 |
| 248641897 | 2933 | 2025 | NA | 1.50 | 17,000.00 | 25,500.00 |
| 248641897 | 2933 | 2025 | NA | 1.50 | 17,000.00 | 25,500.00 |
| 248066552 | 2933 | 2025 | NA | 1.50 | 17,000.00 | 25,500.00 |
| 248066552 | 2933 | 2025 | NA | 1.50 | 17,000.00 | 25,500.00 |
| 248066552 | 2933 | 2025 | NA | 1.50 | 17,000.00 | 25,500.00 |
| 248641897 | 2933 | 2025 | NA | 1.50 | 17,000.00 | 25,500.00 |
| 255650049 | 2930 | 2025 | Flower Lot | 1.35 | 18,864.00 | 25,466.40 |
| 261905492 | 1815 | 2025 | Ethanol Concentrate | 1.35 | 18,800.00 | 25,380.00 |
| 246334076 | 2930 | 2025 | NA | 1.20 | 21,145.00 | 25,374.00 |
| 246334076 | 2930 | 2025 | NA | 1.20 | 21,145.00 | 25,374.00 |
Real-Time Limitations
Inventory Creation to Sale Lag
inventory_lag <- dbGetQuery(con, "
SELECT
i.InventoryId,
i.CreatedDate AS InventoryDate,
MIN(h.SaleDate) AS FirstSaleDate,
DATEDIFF(
'day',
TRY_CAST(i.CreatedDate AS TIMESTAMP),
MIN(TRY_CAST(h.SaleDate AS TIMESTAMP))
) AS LagDays
FROM inventory_all i
JOIN sales_detail_all s ON i.InventoryId = s.InventoryId
JOIN sale_header_all h ON s.SaleHeaderId = h.SaleHeaderId
WHERE
TRY_CAST(i.CreatedDate AS TIMESTAMP) IS NOT NULL AND
TRY_CAST(h.SaleDate AS TIMESTAMP) IS NOT NULL
GROUP BY i.InventoryId, i.CreatedDate
")summary(inventory_lag$LagDays) Min. 1st Qu. Median Mean 3rd Qu. Max.
-1041.00 2.00 4.00 19.38 12.00 3027.00 Distribution of Lag Day
Licenses with Sale Date preceding Created Dates (Negative Lag Days)
# Query inventory lags with negative values
negative_lag <- dbGetQuery(con, "
SELECT
i.InventoryId,
l.LicenseNumber,
i.CreatedDate AS CreatedDate,
MIN(h.SaleDate) AS FirstSaleDate,
DATEDIFF(
'day',
TRY_CAST(i.CreatedDate AS TIMESTAMP),
MIN(TRY_CAST(h.SaleDate AS TIMESTAMP))
) AS LagDays
FROM inventory_all i
JOIN sales_detail_all s ON i.InventoryId = s.InventoryId
JOIN sale_header_all h ON s.SaleHeaderId = h.SaleHeaderId
JOIN licensee_all l ON i.LicenseeId = l.LicenseeId
WHERE
TRY_CAST(i.CreatedDate AS TIMESTAMP) IS NOT NULL AND
TRY_CAST(h.SaleDate AS TIMESTAMP) IS NOT NULL
GROUP BY
i.InventoryId, i.CreatedDate, l.LicenseNumber
HAVING LagDays < 0
ORDER BY LagDays ASC
LIMIT 40
")| InventoryId | LicenseNumber | CreatedDate | FirstSaleDate | LagDays |
|---|---|---|---|---|
| 46716768 | 416538 | 2025-02-16 00:00:00 | 2022-12-16 00:00:00 | -793 days |
| 46716768 | 416538 | 2025-02-16 00:00:00 | 2022-12-16 00:00:00 | -793 days |
| 48378359 | 416538 | 2025-10-20 00:00:00 | 2023-09-19 00:00:00 | -762 days |
| 48378360 | 416538 | 2025-10-20 00:00:00 | 2023-09-19 00:00:00 | -762 days |
| 48378357 | 416538 | 2025-10-20 00:00:00 | 2023-09-19 00:00:00 | -762 days |
| 48378360 | 416538 | 2025-10-20 00:00:00 | 2023-09-19 00:00:00 | -762 days |
| 48378361 | 416538 | 2025-10-20 00:00:00 | 2023-09-19 00:00:00 | -762 days |
| 48378357 | 416538 | 2025-10-20 00:00:00 | 2023-09-19 00:00:00 | -762 days |
| 48378358 | 416538 | 2025-10-20 00:00:00 | 2023-09-19 00:00:00 | -762 days |
| 48378359 | 416538 | 2025-10-20 00:00:00 | 2023-09-19 00:00:00 | -762 days |
| 48378358 | 416538 | 2025-10-20 00:00:00 | 2023-09-19 00:00:00 | -762 days |
| 48378361 | 416538 | 2025-10-20 00:00:00 | 2023-09-19 00:00:00 | -762 days |
| 48379267 | 416538 | 2025-10-14 00:00:00 | 2023-09-19 00:00:00 | -756 days |
| 48379258 | 416538 | 2025-10-14 00:00:00 | 2023-09-19 00:00:00 | -756 days |
| 48379265 | 416538 | 2025-10-14 00:00:00 | 2023-09-19 00:00:00 | -756 days |
| 48379264 | 416538 | 2025-10-14 00:00:00 | 2023-09-19 00:00:00 | -756 days |
| 48379268 | 416538 | 2025-10-14 00:00:00 | 2023-09-19 00:00:00 | -756 days |
| 48379258 | 416538 | 2025-10-14 00:00:00 | 2023-09-19 00:00:00 | -756 days |
| 48379260 | 416538 | 2025-10-14 00:00:00 | 2023-09-19 00:00:00 | -756 days |
| 48379254 | 416538 | 2025-10-14 00:00:00 | 2023-09-19 00:00:00 | -756 days |
| 48379261 | 416538 | 2025-10-14 00:00:00 | 2023-09-19 00:00:00 | -756 days |
| 48379255 | 416538 | 2025-10-14 00:00:00 | 2023-09-19 00:00:00 | -756 days |
| 48379262 | 416538 | 2025-10-14 00:00:00 | 2023-09-19 00:00:00 | -756 days |
| 48379266 | 416538 | 2025-10-14 00:00:00 | 2023-09-19 00:00:00 | -756 days |
| 48379264 | 416538 | 2025-10-14 00:00:00 | 2023-09-19 00:00:00 | -756 days |
| 48379253 | 416538 | 2025-10-14 00:00:00 | 2023-09-19 00:00:00 | -756 days |
| 48379265 | 416538 | 2025-10-14 00:00:00 | 2023-09-19 00:00:00 | -756 days |
| 48379254 | 416538 | 2025-10-14 00:00:00 | 2023-09-19 00:00:00 | -756 days |
| 48379261 | 416538 | 2025-10-14 00:00:00 | 2023-09-19 00:00:00 | -756 days |
| 48379255 | 416538 | 2025-10-14 00:00:00 | 2023-09-19 00:00:00 | -756 days |
| 48379256 | 416538 | 2025-10-14 00:00:00 | 2023-09-19 00:00:00 | -756 days |
| 48379256 | 416538 | 2025-10-14 00:00:00 | 2023-09-19 00:00:00 | -756 days |
| 48379262 | 416538 | 2025-10-14 00:00:00 | 2023-09-19 00:00:00 | -756 days |
| 48379253 | 416538 | 2025-10-14 00:00:00 | 2023-09-19 00:00:00 | -756 days |
| 48379263 | 416538 | 2025-10-14 00:00:00 | 2023-09-19 00:00:00 | -756 days |
| 48379257 | 416538 | 2025-10-14 00:00:00 | 2023-09-19 00:00:00 | -756 days |
| 48379267 | 416538 | 2025-10-14 00:00:00 | 2023-09-19 00:00:00 | -756 days |
| 48379268 | 416538 | 2025-10-14 00:00:00 | 2023-09-19 00:00:00 | -756 days |
| 48379266 | 416538 | 2025-10-14 00:00:00 | 2023-09-19 00:00:00 | -756 days |
| 48379259 | 416538 | 2025-10-14 00:00:00 | 2023-09-19 00:00:00 | -756 days |
The License Information can be added to the table using the above query and add “l.Name AS LicenseeName”.
Here, we protect that personal information. For additional information, contact us.
WSLCB CCRS Compliance
Let’s breakdown by license to see who frequently updates their records:
product_update_by_licensee <- dbGetQuery(con, "
SELECT
LicenseeId,
COUNT(*) AS TotalRecords,
SUM(CASE
WHEN TRY_CAST(UpdatedDate AS TIMESTAMP) > TRY_CAST(CreatedDate AS TIMESTAMP)
THEN 1 ELSE 0
END) AS UpdatedRecords,
ROUND(100.0 * SUM(CASE
WHEN TRY_CAST(UpdatedDate AS TIMESTAMP) > TRY_CAST(CreatedDate AS TIMESTAMP)
THEN 1 ELSE 0
END) / COUNT(*), 1) AS PctUpdated
FROM product_all
GROUP BY LicenseeId
ORDER BY PctUpdated DESC
LIMIT 100
")| LicenseeId | TotalRecords | UpdatedRecords | PctUpdated |
|---|---|---|---|
| 1339 | 2 | 2 | 100.0 |
| 1946 | 3 | 3 | 100.0 |
| 1413 | 2 | 2 | 100.0 |
| 1223 | 34 | 34 | 100.0 |
| 3115 | 1 | 1 | 100.0 |
| 410 | 5 | 5 | 100.0 |
| 2697 | 1 | 1 | 100.0 |
| 2408 | 8 | 8 | 100.0 |
| 1836 | 174 | 174 | 100.0 |
| 3130 | 22 | 22 | 100.0 |
| 2337 | 2 | 2 | 100.0 |
| 1135 | 52 | 52 | 100.0 |
| 2782 | 167 | 167 | 100.0 |
| 1520 | 2 | 2 | 100.0 |
| 1182 | 32 | 32 | 100.0 |
| 2479 | 162 | 162 | 100.0 |
| 2942 | 929 | 929 | 100.0 |
| 2505 | 20 | 20 | 100.0 |
| 1609 | 4 | 4 | 100.0 |
| 954 | 15 | 15 | 100.0 |
| 2570 | 147 | 147 | 100.0 |
| 2483 | 216 | 216 | 100.0 |
| 1804 | 10 | 10 | 100.0 |
| 2813 | 60 | 60 | 100.0 |
| 3190 | 2 | 2 | 100.0 |
| 2717 | 189 | 189 | 100.0 |
| 2198 | 6 | 6 | 100.0 |
| 1500 | 5 | 5 | 100.0 |
| 3049 | 20 | 20 | 100.0 |
| 2970 | 2 | 2 | 100.0 |
| 291 | 46 | 46 | 100.0 |
| 2670 | 42 | 42 | 100.0 |
| 765 | 2 | 2 | 100.0 |
| 3101 | 2 | 2 | 100.0 |
| 2650 | 15 | 15 | 100.0 |
| 2974 | 20 | 20 | 100.0 |
| 2547 | 1 | 1 | 100.0 |
| 2968 | 10 | 10 | 100.0 |
| 1469 | 7093 | 7086 | 99.9 |
| 1100 | 9570 | 9552 | 99.8 |
| 1431 | 609 | 608 | 99.8 |
| 1688 | 631 | 630 | 99.8 |
| 2474 | 194 | 193 | 99.5 |
| 285 | 179 | 178 | 99.4 |
| 1015 | 1748 | 1735 | 99.3 |
| 1296 | 1319 | 1309 | 99.2 |
| 2905 | 328 | 325 | 99.1 |
| 1511 | 311 | 308 | 99.0 |
| 2767 | 12956 | 12797 | 98.8 |
| 752 | 406 | 401 | 98.8 |
| 863 | 1031 | 1016 | 98.5 |
| 313 | 10214 | 10039 | 98.3 |
| 1046 | 31918 | 31315 | 98.1 |
| 429 | 348 | 341 | 98.0 |
| 3179 | 99 | 97 | 98.0 |
| 489 | 100 | 98 | 98.0 |
| 979 | 1628 | 1595 | 98.0 |
| 2932 | 691 | 675 | 97.7 |
| 2436 | 22605 | 22036 | 97.5 |
| 2587 | 689 | 672 | 97.5 |
| 2928 | 66140 | 64428 | 97.4 |
| 1011 | 27796 | 27050 | 97.3 |
| 2238 | 887 | 862 | 97.2 |
| 2920 | 102 | 99 | 97.1 |
| 2081 | 14742 | 14303 | 97.0 |
| 742 | 22538 | 21869 | 97.0 |
| 2265 | 11802 | 11428 | 96.8 |
| 1886 | 2857 | 2762 | 96.7 |
| 3057 | 30 | 29 | 96.7 |
| 2969 | 29 | 28 | 96.6 |
| 2918 | 137327 | 132643 | 96.6 |
| 35 | 11108 | 10726 | 96.6 |
| 2040 | 76617 | 73985 | 96.6 |
| 60 | 10755 | 10381 | 96.5 |
| 319 | 746 | 720 | 96.5 |
| 1036 | 42777 | 41176 | 96.3 |
| 3046 | 107 | 103 | 96.3 |
| 700 | 3371 | 3239 | 96.1 |
| 3074 | 39562 | 37960 | 96.0 |
| 2368 | 127305 | 122243 | 96.0 |
| 2031 | 119175 | 114438 | 96.0 |
| 2668 | 31027 | 29747 | 95.9 |
| 870 | 46816 | 44918 | 95.9 |
| 2229 | 46875 | 44937 | 95.9 |
| 2827 | 46693 | 44767 | 95.9 |
| 2166 | 20969 | 20090 | 95.8 |
| 787 | 47491 | 45520 | 95.8 |
| 485 | 567 | 543 | 95.8 |
| 1009 | 60215 | 57661 | 95.8 |
| 2385 | 25251 | 24168 | 95.7 |
| 766 | 14874 | 14229 | 95.7 |
| 2434 | 83512 | 79951 | 95.7 |
| 2875 | 253 | 242 | 95.7 |
| 2097 | 7557 | 7222 | 95.6 |
| 2102 | 77814 | 74373 | 95.6 |
| 705 | 9807 | 9372 | 95.6 |
| 2199 | 4698 | 4486 | 95.5 |
| 2207 | 57582 | 54978 | 95.5 |
| 947 | 83578 | 79832 | 95.5 |
| 3163 | 69902 | 66739 | 95.5 |
Let’s see how long after records are updated by licensees:
update_lag <- dbGetQuery(con, "
SELECT
LicenseeId,
AVG(DATEDIFF('day', TRY_CAST(CreatedDate AS TIMESTAMP), TRY_CAST(UpdatedDate AS TIMESTAMP))) AS AvgLagDays,
COUNT(*) AS TotalRecords
FROM product_all
WHERE
TRY_CAST(UpdatedDate AS TIMESTAMP) > TRY_CAST(CreatedDate AS TIMESTAMP)
GROUP BY LicenseeId
ORDER BY AvgLagDays DESC
LIMIT 100
")| LicenseeId | AvgLagDays | TotalRecords |
|---|---|---|
| 2154 | 5675.1951 | 3537 |
| 2298 | 5525.2110 | 815 |
| 1018 | 5142.7075 | 1928 |
| 15 | 4789.0679 | 3935 |
| 771 | 4675.8883 | 4307 |
| 51 | 4472.7608 | 882 |
| 3005 | 4455.2181 | 706 |
| 2043 | 4426.4087 | 2978 |
| 2097 | 4389.4060 | 7222 |
| 2183 | 4216.2095 | 7082 |
| 2781 | 3846.7809 | 2328 |
| 41 | 3840.7718 | 2393 |
| 1071 | 3745.7471 | 1898 |
| 2430 | 3652.1938 | 8389 |
| 2072 | 3584.3321 | 816 |
| 1876 | 3443.7011 | 6778 |
| 3038 | 3399.9158 | 5025 |
| 33 | 3258.3597 | 5590 |
| 50 | 2944.5524 | 7574 |
| 551 | 2700.0345 | 29 |
| 43 | 2653.3879 | 17399 |
| 2542 | 2557.6927 | 3131 |
| 25 | 2478.1553 | 7714 |
| 908 | 2468.6820 | 2267 |
| 938 | 2462.3603 | 3522 |
| 1345 | 2311.5263 | 38 |
| 2610 | 2304.1806 | 8224 |
| 2717 | 2018.1799 | 189 |
| 1740 | 1973.9060 | 2170 |
| 521 | 1912.0000 | 11 |
| 581 | 1811.4818 | 4379 |
| 1321 | 1807.8000 | 5936 |
| 2567 | 1649.3971 | 12438 |
| 1469 | 1552.9891 | 7086 |
| 2653 | 1541.6145 | 10332 |
| 1593 | 1521.2963 | 27 |
| 3235 | 1481.6059 | 2474 |
| 2843 | 1429.7143 | 21 |
| 1763 | 1330.6613 | 930 |
| 2005 | 1248.1170 | 23111 |
| 2436 | 1240.2310 | 22036 |
| 1011 | 1231.7270 | 27050 |
| 1672 | 1217.0000 | 1 |
| 750 | 1214.6667 | 3 |
| 429 | 1201.7889 | 341 |
| 1100 | 1160.0695 | 9552 |
| 2663 | 1113.4236 | 5229 |
| 798 | 1108.4482 | 5292 |
| 742 | 1107.8305 | 21869 |
| 1272 | 1104.1162 | 241 |
| 1869 | 1103.8789 | 2585 |
| 975 | 1098.7790 | 11064 |
| 2709 | 1091.0709 | 1015 |
| 1370 | 1085.5667 | 30 |
| 306 | 1084.9231 | 13 |
| 35 | 1083.4292 | 10726 |
| 1567 | 1081.3423 | 1776 |
| 1595 | 1072.3902 | 18049 |
| 542 | 1065.0000 | 1 |
| 1252 | 1063.1622 | 111 |
| 3246 | 1063.0541 | 26401 |
| 2489 | 1057.9610 | 1282 |
| 1879 | 1049.8940 | 151 |
| 778 | 1049.3183 | 864 |
| 1214 | 1040.9750 | 3840 |
| 864 | 1037.4026 | 2151 |
| 786 | 1032.0120 | 34621 |
| 1618 | 1031.2054 | 881 |
| 1167 | 1020.3487 | 6358 |
| 1941 | 1016.8434 | 83 |
| 1756 | 1016.0000 | 1 |
| 2736 | 1005.7639 | 3939 |
| 73 | 997.9564 | 39286 |
| 3196 | 986.5530 | 19371 |
| 1103 | 980.5741 | 31846 |
| 237 | 972.1513 | 152 |
| 565 | 971.0465 | 990 |
| 933 | 970.8799 | 19243 |
| 1078 | 969.3860 | 3326 |
| 1588 | 969.0552 | 725 |
| 2989 | 967.0000 | 1 |
| 1312 | 962.0588 | 17 |
| 2862 | 961.1944 | 1991 |
| 694 | 961.1544 | 3665 |
| 2668 | 960.9887 | 29747 |
| 2827 | 959.6082 | 44767 |
| 889 | 955.7655 | 435 |
| 787 | 951.8574 | 45520 |
| 2968 | 951.6000 | 10 |
| 3095 | 950.3965 | 913 |
| 870 | 949.7555 | 44918 |
| 1904 | 942.0579 | 328 |
| 2942 | 940.0151 | 929 |
| 3208 | 937.2630 | 289 |
| 719 | 934.9131 | 1921 |
| 115 | 932.6522 | 46 |
| 2997 | 929.2049 | 5906 |
| 2875 | 924.3719 | 242 |
| 1058 | 919.3138 | 4159 |
| 362 | 916.8666 | 802 |
Some of the tables above were only snippets of the full dataset.