Category Archives: Cannabis Analyst Report

i502 Compliance Violations by License

Published / by bde / Leave a Comment

Because Biotrack is stupid and their database tables suck, this table doesn’t display the actual name of the Licensee that had the violation. Until I figure out a better way, here’s a nifty URL that you can use and just cut and paste the license number and add to the end of the URL to see who committed the violation.

https://502data.com/license/[paste license number here]

For example, https://502data.com/license/414841

[TODO: add links to table for license name lookup and WAC code and case # linkage]

Powered by Socrata

i502 Competitive Analysis and Intelligence Briefs

Published / by bde / 2 Comments on i502 Competitive Analysis and Intelligence Briefs

As I transition my i502 data mining project from my laptop to the cloud, I’m working on a conceptual framework for offering competitive briefs, reports, charts, and drill-down maps on i502 Producers, Processors, and Retailers. This will include insight, commentary, and a sizeable chunk of data factoids about your closest competitors.

Here are some of my initial thoughts:

  • For Producer/Processors
    • Production/Processing
      • Products made
      • Products sold
      • Products destroyed
      • Products failed testing
    • Heat maps with layers for:
      • Retailers by location
      • Products by retailer
      • Wholesale Sales by product type, product, temporal (daily, weekly, monthly, yearly)
      • Retailer markups
        • By retailer
        • By product type
        • By Product SKU
  • For Retailers
    • Wholesale cost
      • By product type
      • By product
      • By producer/processor
      • By region/geography
    • Retail Sales
      • By product type (flower, oil, edibles)
      • By SKU (e.g. Skord Nightmare Cookies Live Resin)
      • By Producer/Processor
    • Top 10 Producer/processor sales drill down
    • Top 10 closest retailers (region/geography)
    • Top 10 closest retailers (aggregate sales)

Goals:

  1. Learn who your competition is.
  2. Understand the range of products your competitors produce/offer/sell.
  3. Understand the range of products that you or your competitors DON’T SELL (products sitting on shelf).
  4. Understand how much and when your customers sell.
  5. Understand where and to whom your competitors sell. ]

That’s all I can think of off the top of my head for now. Will update/edit post as I iterate and refine this conceptual framework.

If you made it this far, thanks for taking the time to read through this post. As a reward, here’s a pic of some Chem Dawg I grew back in the MMJ days.

BDE -∞+

December i502 Report

Published / by bde / Leave a Comment

Hi guys. I’m working on a detailed analyst report on the i502 traceability data from December 2016.

Until I have it ready to publish, here are a few teaser factoids:

  • Largest concentrate wholesale sale: GreenRush sold 4000 grams of GreenRush Gold Standard Concentrate (Marijuana extract for inhalation) to Clutch Cannabis (in a processor to processor wholesale deal) for $48000 or $12/g.
  • Total concentrates sold (wholesale) to date: 8,688,860 grams
  • Total concentrate wholesale sales to date: $92,958,449
  • Average wholesale price per unit: $8.97

Much more to come. Tables, charts, commentary, analysis.

-BDE