<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Where's The Weed At</title>
    <description>The latest articles on DEV Community by Where's The Weed At (@wtwaadmin).</description>
    <link>https://dev.to/wtwaadmin</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4256543%2F707dfccc-67f1-4830-bb11-f495d0877b0a.png</url>
      <title>DEV Community: Where's The Weed At</title>
      <link>https://dev.to/wtwaadmin</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/wtwaadmin"/>
    <language>en</language>
    <item>
      <title>Building a Canada-wide licensed cannabis store dataset from official provincial registries</title>
      <dc:creator>Where's The Weed At</dc:creator>
      <pubDate>Sat, 21 Nov 2026 01:36:36 +0000</pubDate>
      <link>https://dev.to/wtwaadmin/building-a-canada-wide-licensed-cannabis-store-dataset-from-official-provincial-registries-11cf</link>
      <guid>https://dev.to/wtwaadmin/building-a-canada-wide-licensed-cannabis-store-dataset-from-official-provincial-registries-11cf</guid>
      <description>&lt;p&gt;&lt;em&gt;By Where's The Weed At&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;Canada has no single national list of licensed cannabis retailers. Retail is a provincial and territorial matter, so there are 13 registries, each with its own format, update schedule and definition of a "store". We compiled them into one open dataset of aggregate counts. This post covers how, and what surprised us.&lt;/p&gt;

&lt;p&gt;The result, as of 2026-11-20: &lt;strong&gt;4,030 licensed, open stores across 13 provinces and territories and 1,027 cities&lt;/strong&gt;. The live version with methodology is at &lt;a href="https://wherestheweedat.ca/stats" rel="noopener noreferrer"&gt;wherestheweedat.ca/stats&lt;/a&gt;.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Code and CSVs: &lt;a href="https://github.com/wtwaadmin/canada-cannabis-registry-stats" rel="noopener noreferrer"&gt;GitHub&lt;/a&gt;
&lt;/li&gt;
&lt;li&gt;Citable archive: &lt;a href="https://doi.org/10.5281/zenodo.24409274" rel="noopener noreferrer"&gt;Zenodo, DOI 10.5281/zenodo.24409274&lt;/a&gt;
&lt;/li&gt;
&lt;li&gt;Notebook-friendly copy: &lt;a href="https://www.kaggle.com/datasets/wherestheweedat/canada-licensed-cannabis-store-counts-2026" rel="noopener noreferrer"&gt;Kaggle&lt;/a&gt;
&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Sources: thirteen registries, five shapes
&lt;/h2&gt;

&lt;p&gt;Every row in &lt;code&gt;stores-by-province.csv&lt;/code&gt; carries its &lt;code&gt;source_registry&lt;/code&gt;, &lt;code&gt;source_url&lt;/code&gt; and &lt;code&gt;registry_retrieved_on&lt;/code&gt;, so you can check us against the original. In practice the sources came in a handful of shapes:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Queryable web services.&lt;/strong&gt; Ontario's AGCO publishes cannabis retail store authorizations through an ArcGIS feature service, the friendliest source to read.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Spreadsheets.&lt;/strong&gt; British Columbia's LCRB publishes a downloadable XLSX of cannabis retail stores.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Searchable lists and tables.&lt;/strong&gt; Alberta (AGLC licensee search), Saskatchewan (SLGA), Manitoba (LGCA store list plus the Liquor &amp;amp; Lotteries retailer list).&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Store locators.&lt;/strong&gt; The government-run retailers in Quebec (SQDC), Nova Scotia (NSLC), Newfoundland and Labrador, plus New Brunswick and PEI.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Short web pages.&lt;/strong&gt; Yukon, the Northwest Territories and Nunavut list a handful of stores on a plain page.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Retrieval dates in the CSV range from 2026-10-23 to 2026-11-16, because we refresh each source on its own schedule. A count is only as fresh as its &lt;code&gt;registry_retrieved_on&lt;/code&gt;, and we say so in the data rather than hiding it.&lt;/p&gt;

&lt;h2&gt;
  
  
  Normalizing
&lt;/h2&gt;

&lt;p&gt;The hard part was not scraping; it was agreeing on what to count.&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;
&lt;strong&gt;One definition of a store.&lt;/strong&gt; We count a store when it is listed as open and is not marked closed or removed. Test records and stores that asked to be unlisted are excluded.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Different meanings of "store".&lt;/strong&gt; Quebec's figure (114) counts government-run SQDC branches. New Brunswick (44), Nova Scotia (84), PEI (5) and the territories mix government-run and private stores, as each registry lists them. A province-to-province comparison is therefore a comparison of registries, not a perfect like-for-like.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;City names.&lt;/strong&gt; Registries can spell the same municipality in several ways. We merge spelling variants into one &lt;code&gt;city&lt;/code&gt; per province. The city file has 1,027 rows with no duplicates inside a province.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Edge states.&lt;/strong&gt; Nine stores in British Columbia are marked "licensed, not yet open" by their registry. We include them in the published total and say so in the README, because hiding a judgement call is worse than documenting it.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Privacy by design.&lt;/strong&gt; The published files contain counts only: no store names, addresses, licence numbers, coordinates or licence-holder names.&lt;/li&gt;
&lt;/ol&gt;

&lt;h2&gt;
  
  
  What the numbers say
&lt;/h2&gt;

&lt;p&gt;By province: Ontario 1,867, Alberta 807, British Columbia 563, Manitoba 258, Saskatchewan 208, Quebec 114, Nova Scotia 84, Newfoundland and Labrador 64, New Brunswick 44, Northwest Territories 7, Yukon 6, PEI 5, Nunavut 3. Ontario alone is 1,867 of 4,030 stores.&lt;/p&gt;

&lt;p&gt;By city, the biggest are Toronto (359), Calgary (201), Edmonton (189), Winnipeg (148), Ottawa (116), Vancouver (87), Mississauga (67) and Hamilton (64). But the long tail is the real story: of 1,027 cities, &lt;strong&gt;608 have exactly one store&lt;/strong&gt;, 777 have two or fewer, and only 55 have ten or more. The median city has a single store.&lt;/p&gt;

&lt;h2&gt;
  
  
  A note on per-capita
&lt;/h2&gt;

&lt;p&gt;Per-capita counts are the obvious next question, and we deliberately did not bake them in. A store count per 100,000 people depends on which population estimate and year you use, and on whether you count residents or the people who actually shop there (tourist towns distort it badly). Instead the CSVs hold the raw counts with a clean province code (and city names) so you can join your preferred Statistics Canada population table in one line of pandas:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="k"&gt;import&lt;/span&gt; &lt;span class="n"&gt;pandas&lt;/span&gt; &lt;span class="k"&gt;as&lt;/span&gt; &lt;span class="n"&gt;pd&lt;/span&gt;
&lt;span class="n"&gt;stores&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;pd&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;read_csv&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="s2"&gt;"data/stores-by-province.csv"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="n"&gt;pop&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;pd&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;read_csv&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="s2"&gt;"population_by_province.csv"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;  &lt;span class="c1"&gt;# your own StatCan extract, with a 'code' column&lt;/span&gt;
&lt;span class="n"&gt;df&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;stores&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;merge&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;pop&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;on&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="s2"&gt;"code"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="n"&gt;df&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="s2"&gt;"per_100k"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;df&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="s2"&gt;"licensed_stores_open"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt; &lt;span class="o"&gt;/&lt;/span&gt; &lt;span class="n"&gt;df&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="s2"&gt;"population"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt; &lt;span class="o"&gt;*&lt;/span&gt; &lt;span class="mi"&gt;100_000&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  What we learned
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Publish the retrieval date per source.&lt;/strong&gt; Registries move at different speeds. One global "as of" date overstates freshness.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Document the definition, not just the number.&lt;/strong&gt; The Quebec and New Brunswick caveats matter more than any chart.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Aggregates are often enough.&lt;/strong&gt; Counts answer most research and journalism questions without republishing records whose terms we haven't confirmed. The registries keep their own terms, so we claim a licence only on our compilation (CC BY 4.0), not on their data.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Keep the pipeline boring.&lt;/strong&gt; Every refresh reads the registry, diffs against the previous record, and flags changes for a human check before they go live.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Use it
&lt;/h2&gt;

&lt;p&gt;The CSVs are CC BY 4.0. Cite as: &lt;em&gt;Where's The Weed At (2026). Canadian Licensed Cannabis Store Counts by Province and City (from official registries), version 2026-11-20.&lt;/em&gt; Corrections welcome at &lt;a href="mailto:hello@wherestheweedat.ca"&gt;hello@wherestheweedat.ca&lt;/a&gt;. No endorsement by any regulator or government is implied.&lt;/p&gt;

</description>
      <category>opendata</category>
      <category>dataset</category>
      <category>canada</category>
      <category>webdev</category>
    </item>
  </channel>
</rss>
