←back to thread

41 points sv123 | 2 comments | | HN request time: 0s | source

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.

Show context
cactusplant7374 ◴[] No.43747178[source]
How did you get access to the data?
replies(1): >>43747474 #
sv123 ◴[] No.43747474[source]
Point of sale APIs.
replies(1): >>43747547 #
netsharc ◴[] 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 #
leehuffman ◴[] No.43747684[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 #
1. sv123 ◴[] No.43748168{3}[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 #
2. leehuffman ◴[] No.43754859[source]
My mistake! I remember that now. Thanks for clarifying.