Most active commenters
  • sv123(5)

←back to thread

Show HN: Real-time 4/20 cannabis sales dashboard using Estuary and Tinybird

(420.headset.io)
41 points sv123 | 11 comments | 20 Apr 25 19:03 UTC | HN request time: 0.623s | source | bottom

Built this dashboard to visualize cannabis sales in real time across North America during 4/20. The data updates live from thousands of dispensary POS transactions as the day unfolds.

Under the hood, we’re using Estuary for data streaming and Tinybird to power super fast analytical queries. The charts are made in Tremor and the map is D3.

1. cactusplant7374 ◴[20 Apr 25 23:02 UTC] No.43747178[source]▶
How did you get access to the data?
replies(1): >>43747474 #
2. sv123 ◴[21 Apr 25 00:02 UTC] No.43747474[source]▶
Point of sale APIs.
replies(1): >>43747547 #
3. netsharc ◴[21 Apr 25 00:19 UTC] No.43747547[source]▶
Hello OP, do you work for sales? So much bluster in your site but so little substance in this answer.

Is there a law mandating realtime reporting, or something, or are there just limited number of POS providers and they all have realtime API(s)?

I bet the dashboard doesn't have Johnny from my street corner's transaction...

replies(2): >>43747684 #>>43748162 #
4. leehuffman ◴[21 Apr 25 00:53 UTC] No.43747684{3}[source]▶
> Is there a law mandating realtime reporting, or something

Not real time in WA, but all records are public and reported fairly consistently. See https://www.topshelfdata.com for an example of that.

> or are there just limited number of POS providers and they all have realtime API(s)?

This is Headset who is probably the largest retail POS provider (amongst other offerings on the producer/processor side and more) for legal marijuana sales. I'm assuming the data presented here is exclusively from their POS platform. I don't know of any public sources for real time sales data.

> I bet the dashboard doesn't have Johnny from my street corner's transaction...

Yes I'd also bet Johnny doesn't report his sales to a central database/platform.

replies(1): >>43748168 #
5. sv123 ◴[21 Apr 25 02:55 UTC] No.43748162{3}[source]▶
Not sure what more substance you need, we integrate with close to 30 different POS providers, that's it. There is no law mandating realtime reporting. Every transaction from thousands of retailers is represented... What more do you want to know?
replies(3): >>43748403 #>>43752920 #>>43758558 #
6. sv123 ◴[21 Apr 25 02:56 UTC] No.43748168{4}[source]▶
Headset isn't a POS, we integrate with essentially all of the POS providers. At the bottom of the page there is a list with sales represented.
replies(1): >>43754859 #
7. 01HNNWZ0MV43FF ◴[21 Apr 25 03:59 UTC] No.43748403{4}[source]▶
Can I buy everything from Johnny on the corner? He seems like a nice guy and not a snitch
8. cactusplant7374 ◴[21 Apr 25 15:17 UTC] No.43752920{4}[source]▶
Why would they give you access to that information?
replies(1): >>43753690 #
9. sv123 ◴[21 Apr 25 16:22 UTC] No.43753690{5}[source]▶
We provide tools to manage their inventory, better sales reporting than what most POSs provide, marketing tools, etc.
10. leehuffman ◴[21 Apr 25 18:20 UTC] No.43754859{5}[source]▶
My mistake! I remember that now. Thanks for clarifying.
11. netsharc ◴[22 Apr 25 02:26 UTC] No.43758558{4}[source]▶
This is a better answer. "Point of sale APIs" is as clear as "we get the data in JSON format", i.e. not answering the question at all.