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]
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
- 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)
- Learn who your competition is.
- Understand the range of products your competitors produce/offer/sell.
- Understand the range of products that you or your competitors DON’T SELL (products sitting on shelf).
- Understand how much and when your customers sell.
- 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.
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.