# emojis

name: england
url:
  https://github.githubassets.com/images/icons/emoji/unicode/1f3f4-e0067-e0062-e0065-e006e-e0067-e007f.png?v8


name: scotland
url:
  https://github.githubassets.com/images/icons/emoji/unicode/1f3f4-e0067-e0062-e0073-e0063-e0074-e007f.png?v8


name: wales
url:
  https://github.githubassets.com/images/icons/emoji/unicode/1f3f4-e0067-e0062-e0077-e006c-e0073-e007f.png?v8


# workflows

filename: deploy-branch-preview.yml
name: Deploy a Datasette branch preview to Vercel
on:
  {"workflow_dispatch": {"inputs": {"branch": {"description": "Branch to deploy", "required": true, "type": "string"}}}}


# jobs

name: test
runs-on: ${{ matrix.os }}
strategy:
  {"matrix": {"python-version": ["3.7", "3.8", "3.9", "3.10", "3.11", "3.12"], "os": ["ubuntu-latest", "windows-latest", "macos-latest"]}}


name: test
runs-on: ${{ matrix.os }}
strategy:
  {"matrix": {"python-version": ["3.7", "3.8", "3.9", "3.10", "3.11", "3.12"], "numpy": [0, 1], "os": ["ubuntu-latest", "macos-latest", "windows-latest"]}}


# steps

uses: actions/setup-python@v4
name: Set up Python ${{ matrix.python-version }}
with:
  {"python-version": "${{ matrix.python-version }}", "cache": "pip", "cache-dependency-path": "setup.py"}


uses: actions/cache@v2
name: Configure pip caching
with:
  {"path": "~/.cache/pip", "key": "${{ runner.os }}-pip-${{ hashFiles('**/setup.py') }}", "restore-keys": "${{ runner.os }}-pip-\n"}


uses: actions/cache@v2
name: Configure pip caching
with:
  {"path": "~/.cache/pip", "key": "${{ runner.os }}-publish-pip-${{ hashFiles('**/setup.py') }}", "restore-keys": "${{ runner.os }}-publish-pip-\n"}


name: Install Python dependencies
run:
  python -m pip install --upgrade pip
  pip install sqlite-utils>=3.1
  sqlite-utils --version
  pip install -e .
  pip install datasette
  pip install bs4


name: Fetch previous copy of database
if: !contains(github.event.head_commit.message, 'REFRESH_DB')
run:
  # So we can keep track of when we first saw each dependent repo
  wget https://github-to-sqlite.dogsheep.net/github.db


name: Fetch releases, commits, issues, contributors
run:
  sqlite-utils github.db "select full_name from repos where owner = 53015001 union select 'simonw/datasette' as full_name union select 'simonw/sqlite-utils' as full_name" \
    --csv --no-headers | while read repo;
      do github-to-sqlite releases \
              github.db $(echo $repo | tr -d '\r');
          sleep 10;
          github-to-sqlite commits \
              github.db $(echo $repo | tr -d '\r');
          sleep 10;
          github-to-sqlite tags \
              github.db $(echo $repo | tr -d '\r');
          sleep 10;
          github-to-sqlite contributors \
              github.db $(echo $repo | tr -d '\r');
          sleep 10;
          github-to-sqlite issues \
              github.db $(echo $repo | tr -d '\r');
          sleep 10;
          github-to-sqlite pull-requests \
              github.db $(echo $repo | tr -d '\r');
          sleep 10;
          github-to-sqlite issue-comments \
              github.db $(echo $repo | tr -d '\r');
          sleep 10;
          github-to-sqlite stargazers \
              github.db $(echo $repo | tr -d '\r');
          sleep 10;
          github-to-sqlite workflows \
              github.db $(echo $repo | tr -d '\r');
          sleep 10;
      done;
  # Scrape dependents
  github-to-sqlite scrape-dependents github.db simonw/datasette simonw/sqlite-utils -v
  sqlite-utils tables --counts github.db
  # Delete email addresses from raw_authors
  sqlite-utils github.db "update raw_authors set email = ''"
  # Fetch emojis
  github-to-sqlite emojis github.db --fetch
  # Rebuild FTS tables
  sqlite-utils rebuild-fts github.db
  # Populate _analyze_tables_ table
  sqlite-utils analyze-tables github.db --save


uses: google-github-actions/setup-gcloud@v0
name: Set up Cloud Run
with:
  {"version": "318.0.0", "service_account_email": "${{ secrets.GCP_SA_EMAIL }}", "service_account_key": "${{ secrets.GCP_SA_KEY }}"}


name: Deploy to Cloud Run
run:
  gcloud config set run/region us-central1
  gcloud config set project datasette-222320
  datasette publish cloudrun github.db \
      -m demo-metadata.json \
      --service github-to-sqlite \
      --install=datasette-search-all>=0.3 \
      --install=datasette-render-markdown>=1.1.2 \
      --install=datasette-pretty-json>=0.2.2 \
      --install=datasette-json-html \
      --install=datasette-vega \
      --install=datasette-render-images \
      --install=datasette-graphql \
      --install=datasette-atom


name: Commit and push if README changed
run:
  git diff
  git config --global user.email "readme-bot@example.com"
  git config --global user.name "README-bot"
  git diff --quiet || (git add README.md && git commit -m "Updated README")
  git push


uses: actions/setup-python@v4
name: Set up Python ${{ matrix.python-version }}
with:
  {"python-version": "${{ matrix.python-version }}", "cache": "pip", "cache-dependency-path": "pyproject.toml"}


name: Deploy the preview
env: {"VERCEL_TOKEN": "${{ secrets.BRANCH_PREVIEW_VERCEL_TOKEN }}"}
run:
  export BRANCH="${{ github.event.inputs.branch }}"
  wget https://latest.datasette.io/fixtures.db
  datasette publish vercel fixtures.db \
    --branch $BRANCH \
    --project "datasette-preview-$BRANCH" \
    --token $VERCEL_TOKEN \
    --scope datasette \
    --about "Preview of $BRANCH" \
    --about_url "https://github.com/simonw/datasette/tree/$BRANCH"


name: Install Python dependencies
run:
  python -m pip install --upgrade pip
  python -m pip install -e .[test]
  python -m pip install -e .[docs]
  python -m pip install sphinx-to-sqlite==0.1a1


name: Build fixtures.db and other files needed to deploy the demo
run:
  python tests/fixtures.py \
    fixtures.db \
    fixtures-config.json \
    fixtures-metadata.json \
    plugins \
    --extra-db-filename extra_database.db


name: Build docs.db
if: ${{ github.ref == 'refs/heads/main' }}
run:
  cd docs
  DISABLE_SPHINX_INLINE_TABS=1 sphinx-build -b xml . _build
  sphinx-to-sqlite ../docs.db _build
  cd ..


name: Set up the alternate-route demo
run:
  echo '
  from datasette import hookimpl

  @hookimpl
  def startup(datasette):
      db = datasette.get_database("fixtures2")
      db.route = "alternative-route"
  ' > plugins/alternative_route.py
  cp fixtures.db fixtures2.db


name: And the counters writable canned query demo
run:
  cat > plugins/counters.py <<EOF
  from datasette import hookimpl
  @hookimpl
  def startup(datasette):
      db = datasette.add_memory_database("counters")
      async def inner():
          await db.execute_write("create table if not exists counters (name text primary key, value integer)")
          await db.execute_write("insert or ignore into counters (name, value) values ('counter_a', 0)")
          await db.execute_write("insert or ignore into counters (name, value) values ('counter_b', 0)")
          await db.execute_write("insert or ignore into counters (name, value) values ('counter_c', 0)")
      return inner
  @hookimpl
  def canned_queries(database):
      if database == "counters":
          queries = {}
          for name in ("counter_a", "counter_b", "counter_c"):
              queries["increment_{}".format(name)] = {
                  "sql": "update counters set value = value + 1 where name = '{}'".format(name),
                  "on_success_message_sql": "select 'Counter {name} incremented to ' || value from counters where name = '{name}'".format(name=name),
                  "write": True,
              }
              queries["decrement_{}".format(name)] = {
                  "sql": "update counters set value = value - 1 where name = '{}'".format(name),
                  "on_success_message_sql": "select 'Counter {name} decremented to ' || value from counters where name = '{name}'".format(name=name),
                  "write": True,
              }
          return queries
  EOF


name: Deploy to Cloud Run
env: {"LATEST_DATASETTE_SECRET": "${{ secrets.LATEST_DATASETTE_SECRET }}"}
run:
  gcloud config set run/region us-central1
  gcloud config set project datasette-222320
  export SUFFIX="-${GITHUB_REF#refs/heads/}"
  export SUFFIX=${SUFFIX#-main}
  # Replace 1.0 with one-dot-zero in SUFFIX
  export SUFFIX=${SUFFIX//1.0/one-dot-zero}
  datasette publish cloudrun fixtures.db fixtures2.db extra_database.db \
      -m fixtures-metadata.json \
      --plugins-dir=plugins \
      --branch=$GITHUB_SHA \
      --version-note=$GITHUB_SHA \
      --extra-options="--setting template_debug 1 --setting trace_debug 1 --crossdb" \
      --install 'datasette-ephemeral-tables>=0.2.2' \
      --service "datasette-latest$SUFFIX" \
      --secret $LATEST_DATASETTE_SECRET


name: Deploy to docs as well (only for main)
if: ${{ github.ref == 'refs/heads/main' }}
run:
  # Deploy docs.db to a different service
  datasette publish cloudrun docs.db \
      --branch=$GITHUB_SHA \
      --version-note=$GITHUB_SHA \
      --extra-options="--setting template_debug 1" \
      --service=datasette-docs-latest


uses: actions/cache@v2
name: Configure npm caching
with:
  {"path": "~/.npm", "key": "${{ runner.OS }}-npm-${{ hashFiles('**/package-lock.json') }}", "restore-keys": "${{ runner.OS }}-npm-\n"}


name: Deploy stable-docs.datasette.io to Cloud Run
run:
  gcloud config set run/region us-central1
  gcloud config set project datasette-222320
  datasette publish cloudrun docs.db \
      --service=datasette-docs-stable


name: Build and push to Docker Hub
env: {"DOCKER_USER": "${{ secrets.DOCKER_USER }}", "DOCKER_PASS": "${{ secrets.DOCKER_PASS }}"}
run:
  sleep 60 # Give PyPI time to make the new release available
  docker login -u $DOCKER_USER -p $DOCKER_PASS
  export REPO=datasetteproject/datasette
  docker build -f Dockerfile \
    -t $REPO:${GITHUB_REF#refs/tags/} \
    --build-arg VERSION=${GITHUB_REF#refs/tags/} .
  docker tag $REPO:${GITHUB_REF#refs/tags/} $REPO:latest
  docker push $REPO:${GITHUB_REF#refs/tags/}
  docker push $REPO:latest


name: Build and push to Docker Hub
run:
  docker login -u $DOCKER_USER -p $DOCKER_PASS
  export REPO=datasetteproject/datasette
  docker build -f Dockerfile \
    -t $REPO:${VERSION_TAG} \
    --build-arg VERSION=${VERSION_TAG} .
  docker push $REPO:${VERSION_TAG}

env:
  {"DOCKER_USER": "${{ secrets.DOCKER_USER }}", "DOCKER_PASS": "${{ secrets.DOCKER_PASS }}", "VERSION_TAG": "${{ github.event.inputs.version_tag }}"}


name: Check spelling
run:
  codespell README.md --ignore-words docs/codespell-ignore-words.txt
  codespell docs/*.rst --ignore-words docs/codespell-ignore-words.txt
  codespell datasette -S datasette/static --ignore-words docs/codespell-ignore-words.txt


name: Install Python dependencies
run:
  python -m pip install --upgrade pip
  python -m pip install -e .[test]
  python -m pip install pytest-cov


name: Run tests
run:
  ls -lah
  cat .coveragerc
  pytest --cov=datasette --cov-config=.coveragerc --cov-report xml:coverage.xml --cov-report term
  ls -lah


name: Run tests
run:
  pytest -n auto -m "not serial"
  pytest -m "serial"
  # And the test that exceeds a localhost HTTPS server
  tests/test_datasette_https_server.sh


name: Check spelling
run:
  codespell docs/*.rst --ignore-words docs/codespell-ignore-words.txt
  codespell sqlite_utils --ignore-words docs/codespell-ignore-words.txt


# _analyze_tables_

table: users
column: login
most_common:
  [["fineheard", 2], ["0nebody", 1], ["0ndrec", 1], ["0ihsan", 1], ["0ax-christin", 1], ["0asa", 1], ["0987031613dow", 1], ["03b8", 1], ["00mjk", 1], ["0-vortex", 1]]

least_common:
  [["zxyao145", 1], ["zxygithub", 1], ["zy528", 1], ["zyuanlim", 1], ["zz", 1], ["zz0x", 1], ["zzeleznick", 1], ["zzkt", 1], ["zzl0", 1], ["zzlgreat", 1]]


table: users
column: html_url
most_common:
  [["https://github.com/fineheard", 2], ["https://github.com/0nebody", 1], ["https://github.com/0ndrec", 1], ["https://github.com/0ihsan", 1], ["https://github.com/0ax-christin", 1], ["https://github.com/0asa", 1], ["https://github.com/0987031613dow", 1], ["https://github.com/03b8", 1], ["https://github.com/00mjk", 1], ["https://github.com/0-vortex", 1]]

least_common:
  [["https://github.com/zxyao145", 1], ["https://github.com/zxygithub", 1], ["https://github.com/zy528", 1], ["https://github.com/zyuanlim", 1], ["https://github.com/zz", 1], ["https://github.com/zz0x", 1], ["https://github.com/zzeleznick", 1], ["https://github.com/zzkt", 1], ["https://github.com/zzl0", 1], ["https://github.com/zzlgreat", 1]]


table: repos
column: name
most_common:
  [["til", 32], ["cloud-data-quality", 31], ["datasette", 20], ["covid19-dashboard", 18], ["mycode", 15], ["cloudgoat", 11], ["omspy", 10], ["devops_aula07", 9], ["calishot", 8], ["TIL", 7]]

least_common:
  [["yumyum", 1], ["z1007816", 1], ["zakuchess", 1], ["zctaimpacts", 1], ["zero-dte", 1], ["zero-server", 1], ["zeusops-attendance-analysis", 1], ["zeusops-attendance-bot", 1], ["zhaobai", 1], ["zoned-receiving", 1]]


table: repos
column: owner
most_common:
  [[9599, 203], [139249755, 19], [25778, 17], [15178711, 15], [53015001, 14], [44060760, 14], [28694175, 12], [1223, 12], [39538958, 9], [5802411, 9]]

least_common:
  [[142547358, 1], [142557804, 1], [143516111, 1], [144593877, 1], [146742088, 1], [146979929, 1], [149611026, 1], [149615953, 1], [149787387, 1], [150859625, 1]]


table: repos
column: description
most_common:
  [["None", 496], ["Data Quality Engine for BigQuery", 31], ["A site that displays up to date COVID-19 stats, powered by fastpages.", 19], ["This is your first repo", 12], ["Improved Order Management System for stock trading", 10], ["An open source multi-tool for exploring and publishing data", 9], ["Today I Learned", 8], ["CloudGoat is Rhino Security Labs' \"Vulnerable by Design\" AWS deployment tool", 8], ["Save data from Pinboard to a SQLite database.", 6], ["A tool for exploring and publishing data", 5]]

least_common:
  [["自托管 Webfont 字体生成接口", 1], ["論文をChatGPTに要約させて毎日Slackに配信させるツール", 1], ["🌍 Import geographic and spatial data from files into a SpatiaLite DB", 1], ["🎓  coding exercises from leetcode, hackerrank, codesignal etc.", 1], ["👨‍⚕️ health stats from my apple watch", 1], ["📝 Today I Learned", 1], ["📦  course materials, demos, and hands-outs for all the courses I have taken till...", 1], ["📦 data crawler", 1], ["📰 Today I Learned", 1], ["📻 my notes on various topics", 1]]


table: repos
column: updated_at
most_common:
  [["2021-11-24T19:31:59Z", 3], ["2022-12-10T00:06:05Z", 2], ["2022-11-21T08:21:35Z", 2], ["2022-10-31T13:47:34Z", 2], ["2022-09-01T10:42:32Z", 2], ["2022-07-18T23:51:45Z", 2], ["2022-07-06T18:40:32Z", 2], ["2022-02-28T23:42:41Z", 2], ["2021-09-11T10:57:40Z", 2], ["2020-10-31T14:01:13Z", 2]]

least_common:
  [["2023-12-06T19:59:35Z", 1], ["2023-12-06T21:25:00Z", 1], ["2023-12-06T23:46:13Z", 1], ["2023-12-07T08:28:39Z", 1], ["2023-12-07T14:52:39Z", 1], ["2023-12-08T14:15:58Z", 1], ["2023-12-08T15:51:08Z", 1], ["2023-12-08T18:14:08Z", 1], ["2023-12-08T19:32:30Z", 1], ["2023-12-08T20:50:19Z", 1]]


table: repos
column: pushed_at
most_common:
  [["2019-11-08T13:36:41Z", 6], ["2022-08-18T07:41:34Z", 2], ["2022-04-23T21:22:30Z", 2], ["2022-03-02T00:48:14Z", 2], ["2022-02-28T23:42:38Z", 2], ["2021-11-10T08:58:09Z", 2], ["2021-09-26T22:32:21Z", 2], ["2021-09-11T10:57:37Z", 2], ["2020-10-31T13:33:52Z", 2], ["2019-11-09T20:10:09Z", 2]]

least_common:
  [["2023-12-08T15:18:55Z", 1], ["2023-12-08T16:18:44Z", 1], ["2023-12-08T16:20:58Z", 1], ["2023-12-08T18:13:09Z", 1], ["2023-12-08T18:49:57Z", 1], ["2023-12-08T19:58:09Z", 1], ["2023-12-08T20:52:49Z", 1], ["2023-12-08T20:53:33Z", 1], ["2023-12-09T01:16:01Z", 1], ["2023-12-09T01:16:43Z", 1]]


table: repos
column: homepage
most_common:
  [["None", 926], ["", 321], ["https://covid19dashboards.com", 19], ["https://datasette.io", 8], ["https://lawsql.com", 5], ["http://datasette.readthedocs.io/", 5], ["https://til.simonwillison.net/", 4], ["https://junior.guru", 4], ["https://lawdata.xyz", 3], ["https://docs.datasette.io", 3]]

least_common:
  [["https://www.youtube.com/watch?v=lhM357qSGXA", 1], ["https://yumyum-tau.vercel.app/", 1], ["https://zakuchess.com", 1], ["https://zctaimpacts.abrie.dev", 1], ["links-mads-hartmann-com.vercel.app", 1], ["my-database-project-git-main.testberg.vercel.app", 1], ["pocket-data-datasette-kasperzutterman.vercel.app", 1], ["scratch-gamma.vercel.app", 1], ["unabandaql-ng-git-master.jazzido.vercel.app", 1], ["vumc-resident-map.vercel.app", 1]]


table: repos
column: size
most_common: [[8, 42], [0, 36], [3, 35], [11, 31], [9, 29], [7, 27], [4, 27], [5, 25], [10, 24], [12, 19]]
least_common:
  [[841675, 1], [1124434, 1], [1215453, 1], [1216794, 1], [1289400, 1], [2206999, 1], [3264862, 1], [3875967, 1], [5200284, 1], [5204108, 1]]


table: repos
column: stargazers_count
most_common: [[0, 1063], [1, 156], [2, 65], [3, 42], [4, 21], [7, 17], [6, 16], [5, 16], [8, 7], [12, 6]]
least_common:
  [[364, 1], [388, 1], [410, 1], [682, 1], [1057, 1], [1062, 1], [1260, 1], [1365, 1], [1445, 1], [8524, 1]]


table: repos
column: language
most_common:
  [["Python", 890], ["None", 172], ["Jupyter Notebook", 117], ["HTML", 87], ["Shell", 62], ["JavaScript", 50], ["Makefile", 36], ["TypeScript", 12], ["Dockerfile", 12], ["CSS", 12]]

least_common:
  [["Clojure", 1], ["Elixir", 1], ["Hy", 1], ["Nix", 1], ["PLpgSQL", 1], ["PowerShell", 1], ["PureBasic", 1], ["Ruby", 1], ["Vim script", 1], ["WebAssembly", 1]]


table: repos
column: license
most_common:
  [["None", 761], ["apache-2.0", 345], ["mit", 239], ["bsd-3-clause", 39], ["gpl-3.0", 38], ["other", 33], ["agpl-3.0", 11], ["unlicense", 9], ["wtfpl", 6], ["cc-by-4.0", 6]]

least_common:
  [["gpl-2.0", 1], ["isc", 1], ["lgpl-2.1", 1], ["mpl-2.0", 1], ["bsd-3-clause-clear", 2], ["eupl-1.2", 2], ["bsd-2-clause", 3], ["cc0-1.0", 4], ["cc-by-4.0", 6], ["wtfpl", 6]]


table: repos
column: topics
most_common:
  [["[]", 1175], ["[\"datasette\", \"datasette-io\", \"datasette-plugin\"]", 29], ["[\"datasette\"]", 11], ["[\"sqlite\", \"sqlite-extension\"]", 10], ["[\"datasette\", \"datasette-plugin\"]", 8], ["[\"git-scraping\"]", 5], ["[\"lexibank1\"]", 3], ["[\"datasette-io\", \"datasette-plugin\"]", 3], ["[\"datasette\", \"datasette-io\", \"datasette-plugin\", \"plugin\"]", 3], ["[\"api\", \"legal\", \"pydantic\", \"sqlite\"]", 2]]

least_common:
  [["[\"resident-advisor\", \"club-nights\"]", 1], ["[\"sandbox\"]", 1], ["[\"scotrail\"]", 1], ["[\"sqlite\", \"datasette-io\", \"datasette-tool\"]", 1], ["[\"sqlite\", \"myfitnesspal\", \"datasette\", \"dogsheep\", \"datasette-io\", \"datasette-t...", 1], ["[\"things-i-learned\", \"til\"]", 1], ["[\"til\", \"today-i-learned\", \"todayilearned\"]", 1], ["[\"wip-do-not-use\"]", 1], ["[\"wookieepedia\"]", 1], ["[\"xtce\", \"yaml-configuration\"]", 1]]


table: repos
column: default_branch
most_common:
  [["main", 960], ["master", 524], ["develop", 8], ["trunk", 2], ["dev", 2], ["new_sql", 1], ["mainline", 1], ["latest", 1], ["hjmain", 1], ["Main", 1]]

least_common:
  [["Main", 1], ["hjmain", 1], ["latest", 1], ["mainline", 1], ["new_sql", 1], ["test", 1], ["dev", 2], ["trunk", 2], ["develop", 8], ["master", 524]]


table: repos
column: permissions
most_common:
  [["{\"admin\": false, \"maintain\": false, \"push\": false, \"triage\": false, \"pull\": true...", 898], ["{\"admin\": false, \"push\": false, \"pull\": true}", 365], ["{\"admin\": true, \"maintain\": true, \"push\": true, \"triage\": true, \"pull\": true}", 128], ["{\"admin\": true, \"push\": true, \"pull\": true}", 108], ["{\"admin\": false, \"maintain\": false, \"push\": false, \"triage\": true, \"pull\": true}", 2], ["{\"admin\": false, \"push\": true, \"pull\": true}", 1]]


table: repos
column: organization
most_common:
  [["None", 1235], [139249755, 19], [53015001, 14], [44060760, 14], [84364688, 7], [38107867, 7], [42605656, 6], [11290934, 6], [116695412, 5], [89875467, 5]]

least_common:
  [[123046521, 1], [126232143, 1], [128680267, 1], [132527556, 1], [135807080, 1], [141156403, 1], [142547358, 1], [143516111, 1], [146979929, 1], [149787387, 1]]


table: repos
column: network_count
most_common: [[0, 1164], [1, 116], [2, 39], [48, 31], [3, 18], [4, 14], [5, 13], [11, 11], [6, 9], [7, 6]]
least_common:
  [[449, 1], [452, 1], [460, 1], [461, 1], [463, 1], [487, 1], [511, 1], [518, 1], [540, 1], [615, 1]]


table: repos
column: parent
most_common:
  [["None", 1372], ["{\"id\": 349504954, \"node_id\": \"MDEwOlJlcG9zaXRvcnkzNDk1MDQ5NTQ=\", \"name\": \"cloud-...", 29], ["{\"id\": 415345233, \"node_id\": \"R_kgDOGMGqUQ\", \"name\": \"omspy\", \"full_name\": \"uber...", 8], ["{\"id\": 280696796, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyODA2OTY3OTY=\", \"name\": \"calish...", 5], ["{\"id\": 220291151, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyMjAyOTExNTE=\", \"name\": \"pinboa...", 5], ["{\"id\": 408509890, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDg1MDk4OTA=\", \"name\": \"htmls-...", 4], ["{\"id\": 194628275, \"node_id\": \"MDEwOlJlcG9zaXRvcnkxOTQ2MjgyNzU=\", \"name\": \"junior...", 3], ["{\"id\": 246929362, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyNDY5MjkzNjI=\", \"name\": \"covid1...", 2], ["{\"id\": 220697897, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyMjA2OTc4OTc=\", \"name\": \"lastfm...", 2], ["{\"id\": 107914493, \"node_id\": \"MDEwOlJlcG9zaXRvcnkxMDc5MTQ0OTM=\", \"name\": \"datase...", 2]]

least_common:
  [["{\"id\": 426357499, \"node_id\": \"R_kgDOGWmy-w\", \"name\": \"covid19-dashboard\", \"full_...", 1], ["{\"id\": 445218858, \"node_id\": \"R_kgDOGomAKg\", \"name\": \"starred-repos\", \"full_name...", 1], ["{\"id\": 456560389, \"node_id\": \"R_kgDOGzaPBQ\", \"name\": \"coros-to-sqlite\", \"full_na...", 1], ["{\"id\": 459821110, \"node_id\": \"R_kgDOG2hQNg\", \"name\": \"google-drive-to-sqlite\", \"...", 1], ["{\"id\": 464677284, \"node_id\": \"R_kgDOG7JppA\", \"name\": \"calishot\", \"full_name\": \"K...", 1], ["{\"id\": 466635830, \"node_id\": \"R_kgDOG9BMNg\", \"name\": \"covid19-dashboard\", \"full_...", 1], ["{\"id\": 485162981, \"node_id\": \"R_kgDOHOr_5Q\", \"name\": \"cloud-data-quality\", \"full...", 1], ["{\"id\": 579841533, \"node_id\": \"R_kgDOIo-t_Q\", \"name\": \"slothful-myles\", \"full_nam...", 1], ["{\"id\": 581302435, \"node_id\": \"R_kgDOIqX4ow\", \"name\": \"mastodon-to-sqlite\", \"full...", 1], ["{\"id\": 583468610, \"node_id\": \"R_kgDOIscGQg\", \"name\": \"cloud-data-quality\", \"full...", 1]]


table: repos
column: source
most_common:
  [["None", 1372], ["{\"id\": 349504954, \"node_id\": \"MDEwOlJlcG9zaXRvcnkzNDk1MDQ5NTQ=\", \"name\": \"cloud-...", 31], ["{\"id\": 415345233, \"node_id\": \"R_kgDOGMGqUQ\", \"name\": \"omspy\", \"full_name\": \"uber...", 8], ["{\"id\": 280696796, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyODA2OTY3OTY=\", \"name\": \"calish...", 5], ["{\"id\": 220291151, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyMjAyOTExNTE=\", \"name\": \"pinboa...", 5], ["{\"id\": 408509890, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDg1MDk4OTA=\", \"name\": \"htmls-...", 4], ["{\"id\": 194628275, \"node_id\": \"MDEwOlJlcG9zaXRvcnkxOTQ2MjgyNzU=\", \"name\": \"junior...", 3], ["{\"id\": 246929362, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyNDY5MjkzNjI=\", \"name\": \"covid1...", 2], ["{\"id\": 220697897, \"node_id\": \"MDEwOlJlcG9zaXRvcnkyMjA2OTc4OTc=\", \"name\": \"lastfm...", 2], ["{\"id\": 107914493, \"node_id\": \"MDEwOlJlcG9zaXRvcnkxMDc5MTQ0OTM=\", \"name\": \"datase...", 2]]

least_common:
  [["{\"id\": 399308604, \"node_id\": \"MDEwOlJlcG9zaXRvcnkzOTkzMDg2MDQ=\", \"name\": \"datase...", 1], ["{\"id\": 403239260, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDMyMzkyNjA=\", \"name\": \"pulse-...", 1], ["{\"id\": 409650041, \"node_id\": \"R_kgDOGGrDeQ\", \"name\": \"LOSH-krawler\", \"full_name\"...", 1], ["{\"id\": 415345233, \"node_id\": \"R_kgDOGMGqUQ\", \"name\": \"omspy\", \"full_name\": \"uber...", 1], ["{\"id\": 445218858, \"node_id\": \"R_kgDOGomAKg\", \"name\": \"starred-repos\", \"full_name...", 1], ["{\"id\": 456560389, \"node_id\": \"R_kgDOGzaPBQ\", \"name\": \"coros-to-sqlite\", \"full_na...", 1], ["{\"id\": 459821110, \"node_id\": \"R_kgDOG2hQNg\", \"name\": \"google-drive-to-sqlite\", \"...", 1], ["{\"id\": 464677284, \"node_id\": \"R_kgDOG7JppA\", \"name\": \"calishot\", \"full_name\": \"K...", 1], ["{\"id\": 579841533, \"node_id\": \"R_kgDOIo-t_Q\", \"name\": \"slothful-myles\", \"full_nam...", 1], ["{\"id\": 581302435, \"node_id\": \"R_kgDOIqX4ow\", \"name\": \"mastodon-to-sqlite\", \"full...", 1]]


table: repos
column: template_repository
most_common:
  [["None", 1447], ["{\"id\": 566008212, \"node_id\": \"R_kgDOIbyZlA\", \"name\": \"warehouse-etl\", \"full_name...", 4], ["{\"id\": 400878073, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=\", \"name\": \"datase...", 4], ["{\"id\": 400878073, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=\", \"name\": \"datase...", 3], ["{\"id\": 383002759, \"node_id\": \"MDEwOlJlcG9zaXRvcnkzODMwMDI3NTk=\", \"name\": \"templa...", 3], ["{\"id\": 424823623, \"node_id\": \"R_kgDOGVJLRw\", \"name\": \"glam-workbench-template\", ...", 2], ["{\"id\": 400878073, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=\", \"name\": \"datase...", 2], ["{\"id\": 400878073, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=\", \"name\": \"datase...", 2], ["{\"id\": 400878073, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=\", \"name\": \"datase...", 2], ["{\"id\": 400878073, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=\", \"name\": \"datase...", 2]]

least_common:
  [["{\"id\": 404397410, \"node_id\": \"MDEwOlJlcG9zaXRvcnk0MDQzOTc0MTA=\", \"name\": \"python...", 1], ["{\"id\": 441965081, \"node_id\": \"R_kgDOGlfaGQ\", \"name\": \"first-datasette-app-umd\", ...", 1], ["{\"id\": 461673887, \"node_id\": \"R_kgDOG4SVnw\", \"name\": \"spatial-data-cooking-show\"...", 1], ["{\"id\": 461673887, \"node_id\": \"R_kgDOG4SVnw\", \"name\": \"spatial-data-cooking-show\"...", 1], ["{\"id\": 461673887, \"node_id\": \"R_kgDOG4SVnw\", \"name\": \"spatial-data-cooking-show\"...", 1], ["{\"id\": 461673887, \"node_id\": \"R_kgDOG4SVnw\", \"name\": \"spatial-data-cooking-show\"...", 1], ["{\"id\": 515375569, \"node_id\": \"R_kgDOHrgB0Q\", \"name\": \"cloud-data-quality\", \"full...", 1], ["{\"id\": 521799111, \"node_id\": \"R_kgDOHxoFxw\", \"name\": \"redbean-template\", \"full_n...", 1], ["{\"id\": 614348767, \"node_id\": \"R_kgDOJJ433w\", \"name\": \"ci-full-template\", \"full_n...", 1], ["{\"id\": 698759090, \"node_id\": \"R_kgDOKaY3sg\", \"name\": \"IDS-Week5_MiniProject_us26...", 1]]


table: repos
column: security_and_analysis
most_common:
  [["None", 1435], ["{\"secret_scanning\": {\"status\": \"disabled\"}, \"secret_scanning_push_protection\": {...", 28], ["{\"secret_scanning\": {\"status\": \"disabled\"}, \"secret_scanning_push_protection\": {...", 16], ["{\"secret_scanning\": {\"status\": \"disabled\"}, \"secret_scanning_push_protection\": {...", 14], ["{\"secret_scanning\": {\"status\": \"disabled\"}, \"secret_scanning_push_protection\": {...", 9]]


table: licenses
column: url
most_common:
  [["https://api.github.com/licenses/gpl-2.0", 1], ["https://api.github.com/licenses/eupl-1.2", 1], ["https://api.github.com/licenses/cc0-1.0", 1], ["https://api.github.com/licenses/cc-by-4.0", 1], ["https://api.github.com/licenses/bsd-3-clause-clear", 1], ["https://api.github.com/licenses/bsd-3-clause", 1], ["https://api.github.com/licenses/bsd-2-clause", 1], ["https://api.github.com/licenses/apache-2.0", 1], ["https://api.github.com/licenses/agpl-3.0", 1], ["None", 1]]

least_common:
  [["https://api.github.com/licenses/cc0-1.0", 1], ["https://api.github.com/licenses/eupl-1.2", 1], ["https://api.github.com/licenses/gpl-2.0", 1], ["https://api.github.com/licenses/gpl-3.0", 1], ["https://api.github.com/licenses/isc", 1], ["https://api.github.com/licenses/lgpl-2.1", 1], ["https://api.github.com/licenses/mit", 1], ["https://api.github.com/licenses/mpl-2.0", 1], ["https://api.github.com/licenses/unlicense", 1], ["https://api.github.com/licenses/wtfpl", 1]]


table: licenses_fts_docsize
column: sz
most_common:
  [["b'\\x06'", 5], ["b'\\x07'", 3], ["b'\\x05'", 3], ["b'\\x02'", 3], ["b'\\x04'", 1], ["b'\\x01'", 1], ["b'\\n'", 1]]


table: repos_fts_docsize
column: sz
most_common:
  [["b'\\x02\\x00'", 191], ["b'\\x01\\x00'", 166], ["b'\\x03\\x00'", 106], ["b'\\x03\\x08'", 58], ["b'\\x03\\x05'", 46], ["b'\\x03\\x07'", 42], ["b'\\x02\\x06'", 42], ["b'\\x02\\x07'", 36], ["b'\\x03\\t'", 34], ["b'\\x01\\x07'", 34]]

least_common:
  [["b'\\x05 '", 1], ["b'\\x055'", 1], ["b'\\x06!'", 1], ["b'\\x06\\x00'", 1], ["b'\\x06\\x07'", 1], ["b'\\x06\\x08'", 1], ["b'\\x06\\x0c'", 1], ["b'\\x06\\x11'", 1], ["b'\\x07\\x00'", 1], ["b'\\x07\\x0f'", 1]]


table: users_fts_docsize
column: sz
most_common:
  [["b'\\x01\\x01'", 10658], ["b'\\x02\\x02'", 711], ["b'\\x03\\x03'", 72], ["b'\\x04\\x04'", 8], ["b'\\x05\\x05'", 3], ["b'\\x06\\x06'", 1]]


table: raw_authors
column: name
most_common:
  [["Thomas Sibley", 2], ["Simon Willison", 2], ["Robert Gieseke", 2], ["Abdussamet Koçak", 2], ["Alex Garcia", 1], ["Adrien Di Pasquale", 1], ["Adam Wolf", 1], ["Adam Simpson", 1], ["Adam Jonas", 1], ["Abdus", 1]]

least_common:
  [["dependabot[bot]", 1], ["fcatus", 1], ["gerrymanoim", 1], ["joelondon", 1], ["louispotok", 1], ["lsb", 1], ["mkorosec", 1], ["rhoboro", 1], ["vincent d warmerdam", 1], ["カシオ　金城　大関", 1]]


table: commits
column: message
most_common:
  [["Fixed typo", 12], ["Applied Black", 11], ["Typo fix", 9], ["Updated README", 8], ["Release 0.2", 8], ["Typo", 6], ["Release 0.4", 4], ["Release 0.3", 4], ["Fixed typo in release notes", 4], ["Changelog badge", 4]]

least_common:
  [["view-instance permission for debug URLs, closes #833", 1], ["where= and where_args= parameters to search() and search_sql()\n\nCloses #441", 1], ["white-space: pre-wrap for table SQL, closes #505", 1], ["will, not may - refs #468", 1], ["word-break: break-word;", 1], ["word-wrap: anywhere on links in cells, refs #1805", 1], ["workflow_dispatch", 1], ["x button for clearing filters, refs #1016", 1], ["xfail documentation unit tests for view classes, refs #299\n\nMore documentation u...", 1], ["© 2017-2021", 1]]


table: commits
column: author_date
most_common:
  [["2022-12-15T17:34:07Z", 2], ["2022-03-15T15:36:35Z", 2], ["2021-07-30T00:44:16Z", 2], ["2017-10-24T02:36:44Z", 1], ["2017-10-24T02:25:48Z", 1], ["2017-10-24T02:00:37Z", 1], ["2017-10-23T16:02:40Z", 1], ["2017-10-23T15:28:00Z", 1], ["2017-10-23T00:41:19Z", 1], ["2017-10-23T00:39:03Z", 1]]

least_common:
  [["2023-11-04T00:49:50Z", 1], ["2023-11-04T00:54:37Z", 1], ["2023-11-04T00:58:31Z", 1], ["2023-11-04T00:59:09Z", 1], ["2023-11-04T01:03:42Z", 1], ["2023-11-04T03:55:19Z", 1], ["2023-12-06T18:49:21Z", 1], ["2023-12-08T05:05:27Z", 1], ["2023-12-08T05:22:27Z", 1], ["2023-12-08T05:31:03Z", 1]]


table: commits
column: committer_date
most_common:
  [["2018-05-16T15:27:24Z", 23], ["2022-12-17T21:47:55Z", 18], ["2020-10-27T19:39:55Z", 11], ["2018-04-09T05:10:22Z", 9], ["2020-06-01T01:16:42Z", 8], ["2022-12-31T18:52:37Z", 6], ["2022-01-06T06:24:53Z", 6], ["2020-11-06T18:30:41Z", 6], ["2019-07-03T03:23:05Z", 5], ["2018-05-14T03:04:23Z", 5]]

least_common:
  [["2023-11-04T00:51:46Z", 1], ["2023-11-04T00:56:34Z", 1], ["2023-11-04T00:58:31Z", 1], ["2023-11-04T00:59:09Z", 1], ["2023-11-04T01:03:42Z", 1], ["2023-11-04T03:55:19Z", 1], ["2023-12-06T18:49:21Z", 1], ["2023-12-08T05:05:27Z", 1], ["2023-12-08T05:22:27Z", 1], ["2023-12-08T05:31:03Z", 1]]


table: commits
column: raw_author
most_common:
  [["13ae486343ea6454a93114c6f558ffea2f2c6874", 3433], ["2946d096d0cdefdc017559e6b57e87658736e843", 229], ["5df307d91b1167b0aa175853783d760add239497", 53], ["cd9d55c7c0a7cc0ee69155676fd5e9fc6e1b884b", 20], ["2edd38cb3801aa07f709f083eba7cbe4f16e0978", 17], ["f0031cc286d7f7a2dc1ac63c2100b9870639429c", 8], ["aa206886100eb0f7f5e54172b068d9dd45885448", 7], ["2035bd0fdcffb9aa3b95f21a684665482bd8c80f", 7], ["90786fb02407ad60f10210c0592ee711a9a36fae", 6], ["106fe7fbf8b80a01038e265a137b3b703422db48", 5]]

least_common:
  [["e7784035c9ce3ef64d906c543907d5025673d054", 1], ["eab1e8f71bd05f2ff2163f024127cc28876dd05d", 1], ["f25304fb12f6d6fab36f551427610ed8e96f0c2f", 1], ["f2f4d10a554519ea00fb44a5f6377123c59e1f22", 1], ["f333c00958a658720cd93e305aac71711b88e52b", 1], ["f3dfe1c3cf166dd0b9b8860a25045107a068c5df", 1], ["f85fb7898f36734a83fd9c8a2c2e96c751920c35", 1], ["f98e0e8fe6ee48ca1f752bb408eecbbd294f9ceb", 1], ["f98fc3edb6941a80a1bf0347a12972fd457ea2fb", 1], ["fcf3b31d4679bb2112170ec4dda53dede33a16b3", 1]]


table: commits
column: raw_committer
most_common:
  [["13ae486343ea6454a93114c6f558ffea2f2c6874", 2778], ["cd792325681cbad9f663f2879d8b69f1edbb678f", 878], ["2946d096d0cdefdc017559e6b57e87658736e843", 247], ["f0031cc286d7f7a2dc1ac63c2100b9870639429c", 8], ["2035bd0fdcffb9aa3b95f21a684665482bd8c80f", 6], ["cd9d55c7c0a7cc0ee69155676fd5e9fc6e1b884b", 5]]


table: commits
column: repo
most_common:
  [[107914493, 2391], [140912432, 962], [207052882, 176], [206156866, 132], [197431109, 61], [256834907, 41], [205429375, 36], [197882382, 30], [213286752, 22], [303218369, 19]]

least_common:
  [[209590345, 1], [206649770, 6], [611552758, 9], [206202864, 10], [214746582, 13], [248903544, 13], [303218369, 19], [213286752, 22], [197882382, 30], [205429375, 36]]


table: commits
column: author
most_common:
  [[9599, 3662], [49699333, 53], [45057, 20], [27856297, 17], ["None", 8], [15178711, 7], [21148, 7], [198537, 6], [25778, 6], [2657547, 5]]

least_common:
  [[17075617, 1], [22578954, 1], [28597217, 1], [29426418, 1], [32467826, 1], [32605365, 1], [37802088, 1], [56323389, 1], [72577720, 1], [99098079, 1]]


table: commits_fts_docsize
column: sz
most_common:
  [["b'\\x07'", 497], ["b'\\x08'", 474], ["b'\\x06'", 433], ["b'\\t'", 392], ["b'\\x05'", 312], ["b'\\n'", 242], ["b'\\x04'", 228], ["b'\\x03'", 197], ["b'\\x0b'", 154], ["b'\\x0c'", 108]]

least_common:
  [["b'\\x81&'", 1], ["b'\\x812'", 1], ["b'\\x819'", 1], ["b'\\x81>'", 1], ["b'\\x81?'", 1], ["b'\\x81['", 1], ["b'\\x81\\\\'", 1], ["b'\\x81j'", 1], ["b'\\x81t'", 1], ["b'\\x82\\x14'", 1]]


table: milestones
column: title
most_common:
  [["1.0", 2], ["3.29", 1], ["3.21", 1], ["3.0", 1], ["2.20", 1], ["2.19", 1], ["0.51", 1], ["0.28", 1], ["0.23.1", 1], [" Datasette 1.0a2", 1]]

least_common:
  [["Datasette 0.62", 1], ["Datasette 1.0", 1], ["Datasette 1.0a-next", 1], ["Datasette 1.0a0", 1], ["Datasette 1.0a1", 1], ["Datasette 1.0a3", 1], ["Datasette Next", 1], ["Foreign key edition", 1], ["Ship first public release", 1], ["v1 stretch goals", 1]]


table: milestones
column: description
most_common:
  [["", 21], ["None", 1], ["Just addressable content, a full JSON API and pages that don’t look terrible.", 1], ["Issues planned for the next 1.0 alpha release.", 1], ["First version where you can browse via foreign key relationships.", 1], ["Bugfix release for 0.23. Shipped: https://pypi.org/project/datasette/0.23.1/", 1], ["Big new features in this release are ASGI support, new plugin hooks for ASGI and...", 1], ["Ability to fully customize the HTML templates used to display datasette data.", 1], ["A new visual design, plugin hooks for adding navigation options, better handling...", 1], ["0.15 is already pretty stable - a few small fixes and I'm going to ship 1.0.", 1]]

least_common:
  [["Big new features in this release are ASGI support, new plugin hooks for ASGI and...", 1], ["Bugfix release for 0.23. Shipped: https://pypi.org/project/datasette/0.23.1/", 1], ["First version where you can browse via foreign key relationships.", 1], ["Issues planned for the next 1.0 alpha release.", 1], ["Just addressable content, a full JSON API and pages that don’t look terrible.", 1], ["The first Datasette 1.0 alpha release.", 1], ["The new Datasette Write API.", 1], ["Writeable canned queries, authentication and permissions. [Changelog](https://da...", 1], ["https://github.com/simonw/datasette/issues/519 - stable JSON API, documented tem...", 1], ["https://simonwillison.net/2019/May/19/datasette-0-28/", 1]]


table: milestones
column: updated_at
most_common:
  [["2023-11-06T04:06:12Z", 2], ["2020-03-25T04:19:33Z", 1], ["2019-07-08T03:36:57Z", 1], ["2019-07-07T20:31:25Z", 1], ["2019-05-25T01:28:06Z", 1], ["2019-05-19T22:24:03Z", 1], ["2018-06-21T15:47:49Z", 1], ["2017-12-10T03:12:22Z", 1], ["2017-12-10T02:05:05Z", 1], ["2017-11-30T16:49:38Z", 1]]

least_common:
  [["2022-01-11T18:41:13Z", 1], ["2022-01-13T22:22:24Z", 1], ["2022-01-14T01:59:55Z", 1], ["2022-10-18T18:26:45Z", 1], ["2022-11-14T06:01:19Z", 1], ["2022-11-29T20:11:39Z", 1], ["2022-12-02T01:24:26Z", 1], ["2022-12-20T20:01:13Z", 1], ["2023-05-08T21:04:38Z", 1], ["2023-08-09T20:06:09Z", 1]]


table: milestones
column: due_on
most_common:
  [["None", 32], ["2019-07-07T07:00:00Z", 1], ["2019-05-19T07:00:00Z", 1], ["2017-11-13T08:00:00Z", 1]]


table: milestones
column: closed_at
most_common:
  [["None", 5], ["2020-03-25T04:07:02Z", 1], ["2019-07-08T03:36:57Z", 1], ["2019-05-25T01:28:06Z", 1], ["2019-05-19T22:24:03Z", 1], ["2018-06-21T15:47:15Z", 1], ["2017-12-10T02:05:05Z", 1], ["2017-11-30T16:49:38Z", 1], ["2017-11-14T08:27:33Z", 1], ["2017-11-14T08:24:21Z", 1]]

least_common:
  [["2022-01-10T19:25:44Z", 1], ["2022-01-11T18:41:13Z", 1], ["2022-01-13T22:22:24Z", 1], ["2022-01-14T01:44:41Z", 1], ["2022-08-14T18:03:28Z", 1], ["2022-10-18T18:26:45Z", 1], ["2022-11-29T20:11:39Z", 1], ["2022-12-02T01:24:26Z", 1], ["2022-12-20T20:01:13Z", 1], ["2023-08-09T20:06:09Z", 1]]


table: milestones_fts_docsize
column: sz
most_common:
  [["b'\\x03\\x00'", 13], ["b'\\x02\\x00'", 7], ["b'\\x03\\x0e'", 1], ["b'\\x03\\x0c'", 1], ["b'\\x03\\x07'", 1], ["b'\\x03\\x05'", 1], ["b'\\x03\\n'", 1], ["b'\\x02\\x1c'", 1], ["b'\\x02\\x12'", 1], ["b'\\x02\\t'", 1]]

least_common:
  [["b'\\x03$'", 1], ["b'\\x03\\n'", 1], ["b'\\x03\\x0c'", 1], ["b'\\x03\\x0e'", 1], ["b'\\x03\\x11'", 1], ["b'\\x03\\x1a'", 1], ["b'\\x04\\t'", 1], ["b'\\x04\\x0e'", 1], ["b'\\x05\\x00'", 1], ["b'\\x06\\x00'", 1]]


table: contributors
column: repo_id
most_common:
  [[107914493, 74], [140912432, 35], [207052882, 5], [206156866, 4], [214746582, 3], [205429375, 3], [303218369, 2], [256834907, 2], [213286752, 2], [197431109, 1]]

least_common:
  [[197431109, 1], [197882382, 1], [206202864, 1], [206649770, 1], [209590345, 1], [248903544, 1], [611552758, 1], [213286752, 2], [256834907, 2], [303218369, 2]]


table: contributors
column: user_id
most_common:
  [[9599, 16], [41546558, 2], [15178711, 2], [536941, 2], [244656, 2], [78035, 2], [50527, 2], [49260, 2], [25778, 2], [21148, 2]]

least_common:
  [[27856297, 1], [28597217, 1], [29426418, 1], [32467826, 1], [32605365, 1], [37802088, 1], [49699333, 1], [56323389, 1], [72577720, 1], [99098079, 1]]


table: issues
column: number
most_common: [[2, 16], [1, 16], [6, 14], [5, 14], [4, 14], [3, 14], [8, 13], [7, 13], [10, 12], [9, 12]]
least_common:
  [[2204, 1], [2205, 1], [2206, 1], [2207, 1], [2208, 1], [2209, 1], [2211, 1], [2212, 1], [2213, 1], [2214, 1]]


table: issues
column: title
most_common:
  [["Bump the python-packages group with 1 update", 5], ["Bump the python-packages group with 3 updates", 3], ["Support for generated columns", 2], ["Magic parameters for canned queries", 2], ["Drop support for Python 3.6", 2], ["Configure sphinx.ext.extlinks for issues", 2], ["Bump the python-packages group with 2 updates", 2], ["Bump sphinx, furo, blacken-docs dependencies", 2], ["Add paths for homebrew on Apple silicon", 2], ["Add SpatiaLite helpers to CLI", 2]]

least_common:
  [["utils.parse_metadata() should be a documented internal function", 1], ["v0.54 500 error from sql query in custom template; code worked in v0.53; found a...", 1], ["validating the sql", 1], ["view_name = \"query\" for the query page", 1], ["when hashed urls are turned on, the _memory db has improperly long-lived cache e...", 1], ["word-wrap: anywhere resulting in weird display", 1], ["xml.etree.ElementTree.Parse Error - mismatched tag", 1], ["xml.etree.ElementTree.ParseError: not well-formed (invalid token)", 1], ["{\"$file\": ...} mechanism is broken", 1], ["{{ csrftoken() }} doesn't work with datasette.render_template()", 1]]


table: issues
column: user
most_common:
  [[9599, 2071], [49699333, 87], [536941, 34], [45057, 26], [27856297, 22], [25778, 22], [15178711, 20], [82988, 18], [192568, 16], [3243482, 14]]

least_common:
  [[69208826, 1], [76450761, 1], [80409402, 1], [83080728, 1], [87192257, 1], [91880982, 1], [102635518, 1], [111973926, 1], [123451970, 1], [130708713, 1]]


table: issues
column: milestone
most_common:
  [["None", 2420], [3268330, 117], [6026070, 53], [2857392, 49], [5512395, 39], [5533512, 25], [8755003, 24], [7571612, 24], [8658075, 23], [4305096, 22]]

least_common:
  [[9374594, 1], [5896742, 3], [4348046, 4], [5324096, 4], [5607421, 4], [2859414, 5], [7867486, 6], [3439337, 7], [5225818, 7], [6079500, 7]]


table: issues
column: updated_at
most_common:
  [["2019-05-29T21:39:12Z", 7], ["2022-03-19T04:04:49Z", 5], ["2022-02-05T00:04:26Z", 5], ["2021-06-17T18:12:32Z", 5], ["2018-07-24T04:53:20Z", 5], ["2022-01-13T22:21:29Z", 4], ["2021-06-17T18:14:24Z", 4], ["2021-06-17T18:12:31Z", 4], ["2020-10-23T19:44:06Z", 4], ["2020-09-30T20:36:12Z", 4]]

least_common:
  [["2023-12-04T05:26:29Z", 1], ["2023-12-06T15:05:46Z", 1], ["2023-12-06T19:44:04Z", 1], ["2023-12-07T07:36:34Z", 1], ["2023-12-08T05:07:54Z", 1], ["2023-12-08T05:10:31Z", 1], ["2023-12-08T05:17:20Z", 1], ["2023-12-08T05:22:39Z", 1], ["2023-12-08T13:46:24Z", 1], ["2023-12-08T14:50:15Z", 1]]


table: issues
column: closed_at
most_common:
  [["None", 784], ["2020-10-29T22:01:39Z", 3], ["2019-06-30T23:50:55Z", 2], ["2019-05-01T23:01:57Z", 2], ["2019-02-24T04:02:20Z", 2], ["2018-08-05T00:14:57Z", 2], ["2018-07-26T05:16:00Z", 2], ["2018-05-22T19:35:22Z", 2], ["2018-05-04T18:05:04Z", 2], ["2018-04-13T18:18:59Z", 2]]

least_common:
  [["2023-11-04T00:40:30Z", 1], ["2023-11-04T00:46:30Z", 1], ["2023-11-04T00:49:50Z", 1], ["2023-11-04T00:49:51Z", 1], ["2023-11-04T00:58:02Z", 1], ["2023-11-08T13:19:01Z", 1], ["2023-12-06T18:49:32Z", 1], ["2023-12-08T05:05:27Z", 1], ["2023-12-08T05:07:54Z", 1], ["2023-12-08T05:22:39Z", 1]]


table: issues
column: author_association
most_common:
  [["OWNER", 1862], ["CONTRIBUTOR", 487], ["NONE", 416], ["MEMBER", 209], ["FIRST_TIME_CONTRIBUTOR", 68], ["FIRST_TIMER", 2]]


table: issues
column: pull_request
most_common:
  [["None", 2436], ["dogsheep/dogsheep-photos/pulls/38", 1], ["dogsheep/dogsheep-photos/pulls/37", 1], ["dogsheep/dogsheep-photos/pulls/36", 1], ["dogsheep/dogsheep-photos/pulls/31", 1], ["dogsheep/dogsheep-photos/pulls/30", 1], ["dogsheep/dogsheep-photos/pulls/29", 1], ["dogsheep/dogsheep-beta/pulls/35", 1], ["dogsheep/apple-notes-to-sqlite/pulls/14", 1], ["dogsheep/apple-notes-to-sqlite/pulls/13", 1]]

least_common:
  [["simonw/sqlite-utils/pulls/604", 1], ["simonw/sqlite-utils/pulls/64", 1], ["simonw/sqlite-utils/pulls/65", 1], ["simonw/sqlite-utils/pulls/67", 1], ["simonw/sqlite-utils/pulls/72", 1], ["simonw/sqlite-utils/pulls/75", 1], ["simonw/sqlite-utils/pulls/78", 1], ["simonw/sqlite-utils/pulls/80", 1], ["simonw/sqlite-utils/pulls/9", 1], ["simonw/sqlite-utils/pulls/96", 1]]


table: issues
column: body
most_common:
  [["", 99], ["None", 13], ["- #2109 ", 3], ["https://twitter.com/yschimke/status/930606210855854080", 2], ["Split from #1040, refs #1036.", 2], ["Refs #744", 2], ["\r\n\r\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation ...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1]]

least_common:
  [["ujson is already a dependency of Sanic, and should be quite a bit faster.", 1], ["uvicorn-0.8 relies on websockets-0.7  which lacks python-3.8 compatiblity", 1], ["v0.54 500 error in sql query template; code worked in v0.53; found a workaround\r...", 1], ["vegaEmbed is a LOT of code (it bundles d3)\r\n\r\nInspired by this tweet: https://tw...", 1], ["view-source:https://calands.datasettes.com/calands/CPAD_2020a_SuperUnits.geojson...", 1], ["was looking to add some custom templates to my use of datasette and saw this sma...", 1], ["would it be possible to:\r\n- remove uvicorn mandatory dependancy ?\r\n- eventually ...", 1], ["…are escaped aps unicode for lists, tuples, dicts\r\n\r\nFix of #257 ", 1], ["👋  trying to upgrade the formula to use the latest release, but runs into some r...", 1], ["👋 thank you for an incredibly useful project! \r\n\r\nI have noticed that my deploye...", 1]]


table: issues
column: repo
most_common:
  [[107914493, 2098], [140912432, 604], [207052882, 79], [206156866, 73], [256834907, 40], [197431109, 38], [197882382, 24], [303218369, 16], [205429375, 15], [611552758, 14]]

least_common:
  [[206202864, 2], [209590345, 2], [248903544, 6], [214746582, 8], [213286752, 12], [206649770, 13], [611552758, 14], [205429375, 15], [303218369, 16], [197882382, 24]]


table: issues
column: reactions
most_common:
  [["None", 2], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/4/re...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/3/re...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/2/re...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/14/r...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/13/r...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/12/r...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/11/r...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/10/r...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/apple-notes-to-sqlite/issues/1/re...", 1]]

least_common:
  [["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/issues/90/reactions\", ...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/issues/91/reactions\", ...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/issues/92/reactions\", ...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/issues/93/reactions\", ...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/issues/94/reactions\", ...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/issues/95/reactions\", ...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/issues/96/reactions\", ...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/issues/97/reactions\", ...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/issues/98/reactions\", ...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/issues/99/reactions\", ...", 1]]


table: issues_fts_idx
column: term
most_common:
  [["b''", 4], ["b'0tho'", 3], ["b'0ready'", 3], ["b'0nota'", 3], ["b'0inserte'", 3], ["b'0forb'", 3], ["b'0databased'", 3], ["b'0comb'", 3], ["b'0a0'", 3], ["b'010'", 3]]

least_common:
  [["b'0whol'", 1], ["b'0withe'", 1], ["b'0worka'", 1], ["b'0worko'", 1], ["b'0worl'", 1], ["b'0www2'", 1], ["b'0wy'", 1], ["b'0yas'", 1], ["b'0your'", 1], ["b'0yours'", 1]]


table: issues_fts_docsize
column: sz
most_common:
  [["b'\\x07\\x00'", 19], ["b'\\x06\\x00'", 16], ["b'\\x05\\x00'", 15], ["b'\\x04\\x00'", 14], ["b'\\x08\\x02'", 13], ["b'\\x07\\x02'", 13], ["b'\\t\\x00'", 13], ["b'\\x05\\x02'", 11], ["b'\\x04\\x02'", 10], ["b'\\x03\\x00'", 9]]

least_common:
  [["b'\\x14\\x81M'", 1], ["b'\\x14\\x81e'", 1], ["b'\\x14\\x82\\x11'", 1], ["b'\\x14o'", 1], ["b'\\x14z'", 1], ["b'\\x15\\x84='", 1], ["b'\\x15g'", 1], ["b'\\x15h'", 1], ["b'\\x16\\x06'", 1], ["b'\\x196'", 1]]


table: releases
column: tag_name
most_common:
  [["0.2", 8], ["0.3", 7], ["0.1", 7], ["0.4", 6], ["0.7", 4], ["0.5", 4], ["0.3.1", 4], ["0.1a", 4], ["0.12", 3], ["0.10", 3]]

least_common:
  [["3.35.1", 1], ["3.35.2", 1], ["3.4", 1], ["3.4.1", 1], ["3.5", 1], ["3.6", 1], ["3.7", 1], ["3.8", 1], ["3.9", 1], ["3.9.1", 1]]


table: releases
column: target_commitish
most_common:
  [["main", 184], ["master", 157], ["0.64.x", 5], ["0.63.x", 3], ["0.60.x", 2], ["1.0a.x", 1], ["0.56.x", 1], ["0.54.x", 1], ["0.52.x", 1]]


table: releases
column: name
most_common:
  [["0.2", 8], ["0.3", 7], ["0.4", 6], ["0.1", 6], ["0.7", 4], ["0.5", 4], ["0.3.1", 4], ["0.3.2", 3], ["0.1a", 3], ["0.10", 3]]

least_common:
  [["Datasette 0.29", 1], ["Datasette 0.31", 1], ["Datasette 0.32", 1], ["Datasette 0.33", 1], ["Datasette 0.34", 1], ["Datasette 0.35", 1], ["Datasette 0.36", 1], ["Datasette 0.37", 1], ["Datasette 0.37.1", 1], ["Initial release", 1]]


table: releases
column: body
most_common:
  [["", 8], ["- Fix for a crashing bug caused by viewing the table page for a named in-memory ...", 2], ["* Added `github-to-sqlite repos` command, #3 ", 1], ["* Added `followers-ids` and `friends-ids` subcommands", 1], ["* Added `--since_id` and `--since` to `user-timeline` command, refs #20\r\n* `--si...", 1], ["* Added --since option, closes #3 ", 1], ["*  favorites command now populates `favorited_by` table - #14 \r\n*  favorites `--...", 1], ["### Plugins and internals\r\n\r\n-   New plugin hook: [filters_from_request(request,...", 1], ["# 0.13 (2017-11-24)\r\n\r\n  - Search now applies to current filters.\r\n    \r\n    Com...", 1], ["  - Better mechanism for handling errors; 404s for missing table/database\r\n    \r...", 1]]

least_common:
  [["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-2", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-2-1", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-2-2", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-3", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-7", 1], ["https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-7-1", 1], ["https://sqlite-utils.readthedocs.io/en/stable/changelog.html#v1-10", 1], ["https://sqlite-utils.readthedocs.io/en/stable/changelog.html#v1-11", 1], ["https://sqlite-utils.readthedocs.io/en/stable/changelog.html#v1-8", 1], ["https://sqlite-utils.readthedocs.io/en/stable/changelog.html#v1-9", 1]]


table: releases
column: repo
most_common:
  [[107914493, 133], [140912432, 112], [206156866, 28], [207052882, 22], [197431109, 20], [197882382, 9], [205429375, 7], [256834907, 5], [248903544, 5], [213286752, 5]]

least_common:
  [[209590345, 1], [611552758, 1], [206202864, 2], [213286752, 5], [248903544, 5], [256834907, 5], [303218369, 5], [205429375, 7], [197882382, 9], [197431109, 20]]


table: releases
column: reactions
most_common:
  [["None", 322], ["{\"url\": \"https://api.github.com/repos/simonw/datasette/releases/47507174/reactio...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/datasette/releases/45182156/reactio...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/datasette/releases/44292523/reactio...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/datasette/releases/44155601/reactio...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/datasette/releases/124182616/reacti...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/datasette/releases/118245443/reacti...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/datasette/releases/115813784/reacti...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/datasette/releases/101136455/reacti...", 1], ["{\"url\": \"https://api.github.com/repos/dogsheep/twitter-to-sqlite/releases/500036...", 1]]

least_common:
  [["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/113203288/rea...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/117703394/rea...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/44511190/reac...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/44904928/reac...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/47636109/reac...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/48389722/reac...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/53350811/reac...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/59656694/reac...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/65833874/reac...", 1], ["{\"url\": \"https://api.github.com/repos/simonw/sqlite-utils/releases/75560168/reac...", 1]]


table: releases_fts_docsize
column: sz
most_common:
  [["b'\\x02\\x0b'", 17], ["b'\\x02\\x00'", 8], ["b'\\x03\\x12'", 7], ["b'\\x03\\x0c'", 7], ["b'\\x03\\x0b'", 6], ["b'\\x02\\x15'", 4], ["b'\\x02\\x11'", 4], ["b'\\x02\\n'", 4], ["b'\\x02('", 4], ["b'\\x02&'", 4]]

least_common:
  [["b'\\n\\x83\\x04'", 1], ["b'\\t\\x81\\x03'", 1], ["b'\\t\\x81{'", 1], ["b'\\x04\\x82\\x16'", 1], ["b'\\x05\\x81\\x7f'", 1], ["b'\\x05\\x82Z'", 1], ["b'\\x05\\x88J'", 1], ["b'\\x06\\x84\\x06'", 1], ["b'\\x07\"'", 1], ["b'\\x08\\x83.'", 1]]


table: labels
column: name
most_common:
  [["enhancement", 14], ["bug", 12], ["documentation", 10], ["research", 4], ["invalid", 3], ["help wanted", 3], ["ci", 3], ["plugins", 2], ["duplicate", 2], ["design", 2]]

least_common:
  [["release", 1], ["search", 1], ["security", 1], ["small", 1], ["support", 1], ["templates", 1], ["tests", 1], ["tracking-issue", 1], ["usability", 1], ["windows", 1]]


table: labels
column: color
most_common:
  [["a2eeef", 13], ["d73a4a", 11], ["0075ca", 8], ["ffffff", 2], ["e4e669", 2], ["008672", 2], ["0EE038", 1], ["083993", 1], ["0366d6", 1], ["006b75", 1]]

least_common:
  [["e6e6e6", 1], ["e8be84", 1], ["ecc7fc", 1], ["ee0701", 1], ["f759cf", 1], ["fc79af", 1], ["fc8b0a", 1], ["fcbabb", 1], ["fcd0c4", 1], ["fcecc4", 1]]


table: labels
column: description
most_common:
  [["", 49], ["None", 14], ["New feature or request", 13], ["Something isn't working", 11], ["Improvements or additions to documentation", 8], ["This doesn't seem right", 2], ["Extra attention is needed", 2], ["Minor bugs (not high priority)", 1], ["Further information is requested", 1], ["Awaiting something else to happen first", 1]]

least_common:
  [["Awaiting something else to happen first", 1], ["Further information is requested", 1], ["Minor bugs (not high priority)", 1], ["Pull requests that update a dependency file", 1], ["The official Docker image, plus other things related to running Datasette on Doc...", 1], ["This issue or pull request already exists", 1], ["This will not be worked on", 1], ["Extra attention is needed", 2], ["This doesn't seem right", 2], ["Improvements or additions to documentation", 8]]


table: issues_labels
column: labels_id
most_common:
  [[727708732, 274], [729585263, 233], [993377884, 224], [750789605, 202], [727708734, 195], [754269786, 191], [947261894, 138], [1970143153, 113], [1379448359, 101], [2374328705, 95]]

least_common:
  [[2418058309, 1], [2459412274, 1], [3609901844, 1], [3750508178, 1], [3867322234, 1], [4795091971, 1], [5243620954, 1], [5243620957, 1], [5857663447, 1], [5974977752, 1]]


table: issues_labels
column: issues_id
most_common:
  [[775666296, 7], [647103735, 6], [323658641, 6], [1122557010, 5], [726094754, 5], [725184645, 5], [652961907, 5], [582526961, 5], [573755726, 5], [317714268, 4]]

least_common:
  [[1903932086, 1], [1926729132, 1], [1940346034, 1], [1949756141, 1], [1959278971, 1], [1976986318, 1], [1978022687, 1], [1978023780, 1], [1983600865, 1], [1988525411, 1]]


table: labels_fts_docsize
column: sz
most_common:
  [["b'\\x01\\x00'", 49], ["b'\\x01\\x04'", 25], ["b'\\x02\\x00'", 11], ["b'\\x01\\x05'", 11], ["b'\\x03\\x00'", 2], ["b'\\x02\\x04'", 2], ["b'\\x01\\x07'", 2], ["b'\\x01\\x06'", 2], ["b'\\x04\\x00'", 1], ["b'\\x01\\r'", 1]]


table: issue_comments
column: issue_url
most_common:
  [["https://api.github.com/repos/simonw/datasette/issues/782", 55], ["https://api.github.com/repos/simonw/datasette/issues/1293", 51], ["https://api.github.com/repos/simonw/datasette/issues/1999", 49], ["https://api.github.com/repos/simonw/datasette/issues/1893", 48], ["https://api.github.com/repos/simonw/datasette/issues/1439", 48], ["https://api.github.com/repos/simonw/datasette/issues/983", 47], ["https://api.github.com/repos/simonw/datasette/issues/1518", 45], ["https://api.github.com/repos/simonw/datasette/issues/1249", 45], ["https://api.github.com/repos/simonw/datasette/issues/272", 42], ["https://api.github.com/repos/simonw/datasette/issues/699", 40]]

least_common:
  [["https://api.github.com/repos/simonw/sqlite-utils/issues/599", 1], ["https://api.github.com/repos/simonw/sqlite-utils/issues/6", 1], ["https://api.github.com/repos/simonw/sqlite-utils/issues/603", 1], ["https://api.github.com/repos/simonw/sqlite-utils/issues/605", 1], ["https://api.github.com/repos/simonw/sqlite-utils/issues/63", 1], ["https://api.github.com/repos/simonw/sqlite-utils/issues/68", 1], ["https://api.github.com/repos/simonw/sqlite-utils/issues/75", 1], ["https://api.github.com/repos/simonw/sqlite-utils/issues/83", 1], ["https://api.github.com/repos/simonw/sqlite-utils/issues/85", 1], ["https://api.github.com/repos/simonw/sqlite-utils/issues/91", 1]]


table: issue_comments
column: user
most_common:
  [[9599, 8883], [22429695, 240], [536941, 82], [25778, 74], [45057, 39], [49699333, 36], [82988, 35], [3243482, 26], [15178711, 25], [95570, 24]]

least_common:
  [[49702524, 1], [60892516, 1], [63653929, 1], [76450761, 1], [76528036, 1], [80409402, 1], [89400147, 1], [95520595, 1], [102771161, 1], [123451970, 1]]


table: issue_comments
column: created_at
most_common:
  [["2021-01-04T19:52:40Z", 2], ["2017-10-23T15:28:11Z", 1], ["2017-10-23T02:28:31Z", 1], ["2017-10-23T02:18:36Z", 1], ["2017-10-23T02:16:33Z", 1], ["2017-10-23T02:15:41Z", 1], ["2017-10-23T01:35:17Z", 1], ["2017-10-23T01:20:30Z", 1], ["2017-10-23T01:15:24Z", 1], ["2017-10-23T01:09:05Z", 1]]

least_common:
  [["2023-12-06T18:36:51Z", 1], ["2023-12-06T19:43:55Z", 1], ["2023-12-06T19:48:26Z", 1], ["2023-12-06T19:49:10Z", 1], ["2023-12-07T01:17:05Z", 1], ["2023-12-07T07:36:33Z", 1], ["2023-12-08T05:07:54Z", 1], ["2023-12-08T05:09:55Z", 1], ["2023-12-08T05:16:44Z", 1], ["2023-12-08T14:50:13Z", 1]]


table: issue_comments
column: updated_at
most_common:
  [["2021-01-04T19:52:40Z", 2], ["2017-10-23T19:23:29Z", 1], ["2017-10-23T15:28:11Z", 1], ["2017-10-23T02:29:05Z", 1], ["2017-10-23T02:18:36Z", 1], ["2017-10-23T02:16:33Z", 1], ["2017-10-23T02:15:41Z", 1], ["2017-10-23T01:35:17Z", 1], ["2017-10-23T01:20:30Z", 1], ["2017-10-23T01:15:24Z", 1]]

least_common:
  [["2023-12-06T18:36:51Z", 1], ["2023-12-06T19:43:55Z", 1], ["2023-12-06T19:49:29Z", 1], ["2023-12-07T01:17:05Z", 1], ["2023-12-07T07:36:33Z", 1], ["2023-12-08T05:05:03Z", 1], ["2023-12-08T05:07:54Z", 1], ["2023-12-08T05:10:31Z", 1], ["2023-12-08T05:17:20Z", 1], ["2023-12-08T14:50:13Z", 1]]


table: issue_comments
column: body
most_common:
  [["Thanks!", 32], ["That fixed it.", 6], ["Thanks for this!", 6], ["Tracking ticket: #1023", 5], ["Needs documentation.", 5], ["@dependabot recreate", 5], ["Thanks for spotting this!", 4], ["Documentation: https://sqlite-utils.datasette.io/en/latest/cli.html#returning-al...", 3], ["Blocked on #37", 3], ["@dependabot rebase", 3]]

least_common:
  [["you should have a look at Roda written in ruby . ", 1], ["|   addr | opcode        |   p1 |   p2 |   p3 | p4                    |   p5 | c...", 1], ["❤️ thanks!", 1], ["🎉   Thanks so much @simonw  ! 🎉 ", 1], ["👋  could I help somehow for this to be merged? As Big Sur is going to be more us...", 1], ["👋 Any update on getting this merged?\r\n\r\nAlternatively, is there a work around fo...", 1], ["👋 I'd be interested in building this out in Q1 or Q2 of 2020 if nobody has tackl...", 1], ["👍 I'd like this too! ", 1], ["🤯 this is beautiful. Thanks @simonw !", 1], ["🤷‍♂️ @stonebig's suggestion would be the best I got too, *if* you want to suppor...", 1]]


table: issue_comments
column: reactions
most_common:
  [["{\"total_count\": 0, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 10125], ["{\"total_count\": 1, \"+1\": 1, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 214], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 41], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 1, \"confused\": 0, \"he...", 37], ["{\"total_count\": 2, \"+1\": 2, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 20], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 13], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 10], ["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 1, \"hooray\": 0, \"confused\": 0, \"he...", 7], ["{\"total_count\": 3, \"+1\": 3, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 6], ["{\"total_count\": 2, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 3]]

least_common:
  [["{\"total_count\": 1, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 1, \"he...", 1], ["{\"total_count\": 15, \"+1\": 7, \"-1\": 0, \"laugh\": 1, \"hooray\": 1, \"confused\": 0, \"h...", 1], ["{\"total_count\": 2, \"+1\": 0, \"-1\": 0, \"laugh\": 1, \"hooray\": 0, \"confused\": 0, \"he...", 1], ["{\"total_count\": 2, \"+1\": 1, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 1], ["{\"total_count\": 2, \"+1\": 1, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 1], ["{\"total_count\": 3, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 3, \"confused\": 0, \"he...", 1], ["{\"total_count\": 4, \"+1\": 4, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 1], ["{\"total_count\": 5, \"+1\": 2, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 1], ["{\"total_count\": 5, \"+1\": 5, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 1], ["{\"total_count\": 3, \"+1\": 0, \"-1\": 0, \"laugh\": 0, \"hooray\": 0, \"confused\": 0, \"he...", 2]]


table: issue_comments
column: issue
most_common:
  [[627794879, 55], [849978964, 51], [1551694938, 49], [1450363982, 48], [973139047, 48], [712260429, 47], [1058072543, 45], [824064069, 45], [324188953, 42], [582526961, 40]]

least_common:
  [[1907281675, 1], [1919296686, 1], [1949756141, 1], [1976986318, 1], [1983600865, 1], [1988525411, 1], [1994857251, 1], [2007893839, 1], [2028698018, 1], [2029908157, 1]]


table: issue_comments
column: performed_via_github_app
most_common:
  [["None", 10490], ["{\"id\": 254, \"slug\": \"codecov\", \"node_id\": \"MDM6QXBwMjU0\", \"owner\": {\"login\": \"co...", 4], ["{\"id\": 29110, \"slug\": \"dependabot\", \"node_id\": \"MDM6QXBwMjkxMTA=\", \"owner\": {\"lo...", 1]]


table: issue_comments_fts_idx
column: term
most_common:
  [["b'0a0'", 6], ["b''", 6], ["b'0tho'", 5], ["b'0thea'", 5], ["b'0simonwi'", 5], ["b'0httpt'", 5], ["b'0haven'", 4], ["b'0forb'", 4], ["b'0comb'", 4], ["b'0andr'", 4]]

least_common:
  [["b'0\\xe1'", 1], ["b'0wel'", 1], ["b'0wherea'", 1], ["b'0whiche'", 1], ["b'0withoutr'", 1], ["b'0wouldn'", 1], ["b'0writem'", 1], ["b'0writer'", 1], ["b'0youg'", 1], ["b'0yours'", 1]]


table: issue_comments_fts_idx
column: pgno
most_common: [[24, 6], [22, 6], [20, 6], [16, 6], [14, 6], [12, 6], [10, 6], [8, 6], [6, 6], [2, 6]]
least_common:
  [[880, 1], [886, 1], [888, 1], [890, 1], [892, 1], [894, 1], [896, 1], [898, 1], [900, 1], [902, 1]]


table: issue_comments_fts_docsize
column: sz
most_common:
  [["b'\\x0f'", 231], ["b'\\x12'", 219], ["b'\\x10'", 210], ["b'\\x0e'", 210], ["b'\\r'", 196], ["b'\\x0c'", 192], ["b'\\x16'", 191], ["b'\\x13'", 185], ["b'\\x15'", 171], ["b'\\x0b'", 169]]

least_common:
  [["b'\\x8b\"'", 1], ["b'\\x8b5'", 1], ["b'\\x8bh'", 1], ["b'\\x8c '", 1], ["b'\\x8c\\x05'", 1], ["b'\\x8fK'", 1], ["b'\\x927'", 1], ["b'\\x92}'", 1], ["b'\\x9f\\\\'", 1], ["b'\\xb3.'", 1]]


table: dependents
column: dependent
most_common:
  [[112050382, 2], [107914493, 2], [99911706, 2], [79072630, 2], [51720846, 2], [51665750, 2], [49612682, 2], [24275324, 2], [18156953, 2], [5832996, 2]]

least_common:
  [[722215565, 1], [723559658, 1], [724100681, 1], [724695324, 1], [725878842, 1], [725881885, 1], [726528070, 1], [726877442, 1], [727238894, 1], [728033291, 1]]


table: stars
column: user
most_common:
  [[100658940, 10], [366688, 10], [178424, 10], [41546558, 9], [948118, 9], [7476523, 8], [161718, 8], [128885, 8], [46511, 8], [14772, 8]]

least_common:
  [[143604953, 1], [143672081, 1], [143690517, 1], [143695131, 1], [144463414, 1], [144660340, 1], [144876494, 1], [145830562, 1], [147007989, 1], [152381511, 1]]


table: stars
column: repo
most_common:
  [[107914493, 8732], [140912432, 1398], [206156866, 407], [207052882, 348], [197431109, 179], [197882382, 178], [256834907, 167], [611552758, 155], [214746582, 119], [213286752, 99]]

least_common:
  [[206202864, 6], [209590345, 22], [303218369, 35], [248903544, 45], [205429375, 55], [206649770, 90], [213286752, 99], [214746582, 119], [611552758, 155], [256834907, 167]]


table: stars
column: starred_at
most_common:
  [["2022-08-01T04:42:31Z", 2], ["2019-07-10T11:27:06Z", 2], ["2017-11-14T13:01:37Z", 2], ["2017-11-14T05:14:41Z", 2], ["2017-11-14T00:23:15Z", 1], ["2017-11-14T00:17:38Z", 1], ["2017-11-14T00:16:53Z", 1], ["2017-11-14T00:10:35Z", 1], ["2017-11-13T22:01:43Z", 1], ["2017-11-13T21:59:52Z", 1]]

least_common:
  [["2023-12-08T02:32:29Z", 1], ["2023-12-08T05:36:19Z", 1], ["2023-12-08T12:34:45Z", 1], ["2023-12-08T14:54:21Z", 1], ["2023-12-08T15:23:02Z", 1], ["2023-12-08T15:51:08Z", 1], ["2023-12-08T17:01:59Z", 1], ["2023-12-08T19:08:09Z", 1], ["2023-12-08T19:32:30Z", 1], ["2023-12-08T20:50:19Z", 1]]


table: tags
column: repo
most_common:
  [[107914493, 141], [140912432, 124], [206156866, 29], [207052882, 23], [197431109, 20], [197882382, 9], [205429375, 7], [256834907, 5], [248903544, 5], [213286752, 5]]

least_common:
  [[209590345, 1], [611552758, 1], [206649770, 2], [206202864, 3], [213286752, 5], [248903544, 5], [256834907, 5], [303218369, 5], [205429375, 7], [197882382, 9]]


table: tags
column: name
most_common:
  [["0.2", 10], ["0.1", 10], ["0.3", 8], ["0.4", 7], ["0.7", 5], ["0.5", 5], ["0.3.1", 5], ["0.1a", 5], ["0.6", 4], ["0.10", 4]]

least_common:
  [["3.35.2", 1], ["3.36", 1], ["3.4", 1], ["3.4.1", 1], ["3.5", 1], ["3.6", 1], ["3.7", 1], ["3.8", 1], ["3.9", 1], ["3.9.1", 1]]


table: emojis
column: url
most_common:
  [["https://github.githubassets.com/images/icons/emoji/unicode/1f4a9.png?v8", 3], ["https://github.githubassets.com/images/icons/emoji/unicode/1f44a.png?v8", 3], ["https://github.githubassets.com/images/icons/emoji/unicode/1f34a.png?v8", 3], ["https://github.githubassets.com/images/icons/emoji/unicode/1f42c.png?v8", 2], ["https://github.githubassets.com/images/icons/emoji/unicode/1f41d.png?v8", 2], ["https://github.githubassets.com/images/icons/emoji/unicode/1f3ee.png?v8", 2], ["https://github.githubassets.com/images/icons/emoji/unicode/1f3c3.png?v8", 2], ["https://github.githubassets.com/images/icons/emoji/unicode/1f314.png?v8", 2], ["https://github.githubassets.com/images/icons/emoji/unicode/1f1ec-1f1e7.png?v8", 2], ["https://github.githubassets.com/images/icons/emoji/unicode/1f1ea-1f1fa.png?v8", 2]]

least_common:
  [["https://github.githubassets.com/images/icons/emoji/unicode/2b06.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/2b07.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/2b1b.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/2b1c.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/2b50.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/2b55.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/3030.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/303d.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/3297.png?v8", 1], ["https://github.githubassets.com/images/icons/emoji/unicode/3299.png?v8", 1]]


table: emojis
column: image
most_common:
  [["b'Not Found\\n'", 83], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00@\\x00\\x00\\x00@\\x08\\x06\\x00\\x00\\...", 3], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00@\\x00\\x00\\x00@\\x08\\x06\\x00\\x00\\...", 3], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00@\\x00\\x00\\x00@\\x08\\x06\\x00\\x00\\...", 3], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00@\\x00\\x00\\x00@\\x08\\x06\\x00\\x00\\...", 2], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00@\\x00\\x00\\x00@\\x08\\x06\\x00\\x00\\...", 2], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00@\\x00\\x00\\x00@\\x08\\x06\\x00\\x00\\...", 2], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00@\\x00\\x00\\x00@\\x08\\x04\\x00\\x00\\...", 2], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00@\\x00\\x00\\x00@\\x08\\x03\\x00\\x00\\...", 2], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00@\\x00\\x00\\x00@\\x08\\x03\\x00\\x00\\...", 2]]

least_common:
  [["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00@\\x00\\x00\\x00@\\x08\\x06\\x00\\x00\\...", 1], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00K\\x00\\x00\\x00K\\x08\\x03\\x00\\x00\\...", 1], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00P\\x00\\x00\\x00P\\x08\\x03\\x00\\x00\\...", 1], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00P\\x00\\x00\\x00P\\x08\\x03\\x00\\x00\\...", 1], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00P\\x00\\x00\\x00P\\x08\\x03\\x00\\x00\\...", 1], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00\\x80\\x00\\x00\\x00\\x80\\x08\\x06\\x0...", 1], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x00\\x80\\x00\\x00\\x00\\x80\\x08\\x06\\x0...", 1], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x03 \\x00\\x00\\x01\\xe0\\x01\\x03\\x00\\x...", 1], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x03\\xe8\\x00\\x00\\x02X\\x08\\x03\\x00\\x...", 1], ["b'\\x89PNG\\r\\n\\x1a\\n\\x00\\x00\\x00\\rIHDR\\x00\\x00\\x04\\xb0\\x00\\x00\\x03 \\x08\\x02\\x00\\x...", 1]]


table: workflows
column: filename
most_common:
  [["test.yml", 12], ["publish.yml", 11], ["test-coverage.yml", 2], ["spellcheck.yml", 2], ["documentation-links.yml", 2], ["mirror-master-and-main.yml", 1], ["deploy-latest.yml", 1], ["deploy-demo.yml", 1], ["deploy-branch-preview.yml", 1], ["codeql-analysis.yml", 1]]

least_common:
  [["deploy-demo.yml", 1], ["deploy-latest.yml", 1], ["mirror-master-and-main.yml", 1], ["prettier.yml", 1], ["push_docker_tag.yml", 1], ["readme-toc.yaml", 1], ["readme-toc.yml", 1], ["test-pyodide.yml", 1], ["tmate-mac.yml", 1], ["tmate.yml", 1]]


table: workflows
column: name
most_common:
  [["Test", 11], ["Publish Python Package", 11], ["Update README table of contents", 2], ["Read the Docs Pull Request Preview", 2], ["Check spelling in documentation", 2], ["Calculate test coverage", 2], ["Deploy a Datasette branch preview to Vercel", 1], ["CodeQL", 1], ["Check JavaScript for conformance with Prettier", 1], ["Build and deploy demo", 1]]

least_common:
  [["Check JavaScript for conformance with Prettier", 1], ["CodeQL", 1], ["Deploy a Datasette branch preview to Vercel", 1], ["Deploy latest.datasette.io", 1], ["Mirror \"master\" and \"main\" branches", 1], ["Push specific Docker tag", 1], ["Python package", 1], ["Test in Pyodide with shot-scraper", 1], ["tmate session", 1], ["tmate session mac", 1]]


table: workflows
column: on
most_common:
  [["{\"release\": {\"types\": [\"created\"]}}", 11], ["[\"push\"]", 8], ["[\"push\", \"pull_request\"]", 6], ["{\"workflow_dispatch\": null}", 2], ["{\"push\": {\"branches\": [\"main\"]}, \"pull_request\": {\"branches\": [\"main\"]}}", 2], ["{\"pull_request_target\": {\"types\": [\"opened\"]}}", 2], ["{\"push\": {\"branches\": [\"main\"]}, \"schedule\": [{\"cron\": \"0 4 * * 5\"}]}", 1], ["{\"push\": {\"branches\": [\"main\", \"master\"], \"paths\": [\"README.md\"]}}", 1], ["{\"push\": {\"branches\": [\"main\", \"1.0-dev\"]}}", 1], ["{\"push\": null, \"pull_request\": null, \"workflow_dispatch\": null}", 1]]

least_common:
  [["{\"push\": null, \"pull_request\": null, \"workflow_dispatch\": null}", 1], ["{\"push\": {\"branches\": [\"main\", \"1.0-dev\"]}}", 1], ["{\"push\": {\"branches\": [\"main\", \"master\"], \"paths\": [\"README.md\"]}}", 1], ["{\"push\": {\"branches\": [\"main\"]}, \"schedule\": [{\"cron\": \"0 4 * * 5\"}]}", 1], ["{\"push\": {\"branches\": [\"master\", \"main\"]}}", 1], ["{\"push\": {\"branches\": [\"master\"]}, \"pull_request\": {\"branches\": [\"master\"]}}", 1], ["{\"workflow_dispatch\": null, \"push\": {\"branches\": [\"main\"], \"paths\": [\"README.md\"...", 1], ["{\"workflow_dispatch\": null, \"push\": {\"branches\": [\"main\"]}, \"schedule\": [{\"cron\"...", 1], ["{\"workflow_dispatch\": {\"inputs\": {\"branch\": {\"description\": \"Branch to deploy\", ...", 1], ["{\"workflow_dispatch\": {\"inputs\": {\"version_tag\": {\"description\": \"Tag to build a...", 1]]


table: workflows
column: repo
most_common:
  [[107914493, 13], [140912432, 6], [207052882, 4], [206156866, 3], [303218369, 2], [248903544, 2], [213286752, 2], [205429375, 2], [197882382, 2], [197431109, 2]]

least_common:
  [[256834907, 1], [197431109, 2], [197882382, 2], [205429375, 2], [213286752, 2], [248903544, 2], [303218369, 2], [611552758, 2], [206156866, 3], [207052882, 4]]


table: jobs
column: workflow
most_common:
  [[20982, 4], [20975, 2], [20973, 2], [20971, 2], [20969, 2], [20967, 2], [20964, 2], [20961, 2], [20958, 2], [20956, 2]]

least_common:
  [[20985, 1], [20986, 1], [20987, 1], [20988, 1], [20989, 1], [20990, 1], [20991, 1], [20993, 1], [20994, 1], [20995, 1]]


table: jobs
column: name
most_common:
  [["test", 25], ["deploy", 12], ["build", 5], ["spellcheck", 2], ["documentation-links", 2], ["deploy_docker", 2], ["mirror", 1], ["deploy_static_docs", 1], ["deploy-branch-preview", 1], ["Analyze", 1]]

least_common:
  [["Analyze", 1], ["deploy-branch-preview", 1], ["deploy_static_docs", 1], ["mirror", 1], ["prettier", 1], ["scheduled", 1], ["deploy_docker", 2], ["documentation-links", 2], ["spellcheck", 2], ["build", 5]]


table: jobs
column: repo
most_common:
  [[107914493, 16], [140912432, 7], [207052882, 5], [206156866, 4], [303218369, 3], [248903544, 3], [213286752, 3], [205429375, 3], [197882382, 3], [197431109, 3]]

least_common:
  [[256834907, 1], [197431109, 3], [197882382, 3], [205429375, 3], [213286752, 3], [248903544, 3], [303218369, 3], [611552758, 3], [206156866, 4], [207052882, 5]]


table: jobs
column: strategy
most_common:
  [["None", 30], ["{\"matrix\": {\"python-version\": [3.6, 3.7, 3.8, 3.9]}}", 10], ["{\"matrix\": {\"python-version\": [\"3.7\", \"3.8\", \"3.9\", \"3.10\", \"3.11\"]}}", 6], ["{\"matrix\": {\"python-version\": [\"3.8\", \"3.9\", \"3.10\", \"3.11\"]}}", 3], ["{\"matrix\": {\"python-version\": [3.7, 3.8]}}", 1], ["{\"matrix\": {\"python-version\": [\"3.8\", \"3.9\", \"3.10\", \"3.11\", \"3.12\"]}}", 1], ["{\"matrix\": {\"python-version\": [\"3.7\", \"3.8\", \"3.9\", \"3.10\", \"3.11\", \"3.12\"], \"os...", 1], ["{\"matrix\": {\"python-version\": [\"3.7\", \"3.8\", \"3.9\", \"3.10\", \"3.11\", \"3.12\"], \"nu...", 1], ["{\"fail-fast\": false, \"matrix\": {\"language\": [\"python\"]}}", 1]]


table: steps
column: job
most_common:
  [[27879, 14], [27859, 12], [27837, 11], [27870, 10], [27878, 7], [27864, 7], [27868, 6], [27831, 5], [27830, 5], [27829, 5]]

least_common:
  [[27860, 1], [27874, 1], [26772, 2], [27865, 2], [27866, 2], [27871, 2], [27872, 2], [27840, 3], [27856, 3], [27867, 4]]


table: steps
column: repo
most_common:
  [[107914493, 73], [140912432, 42], [207052882, 29], [206156866, 18], [303218369, 15], [248903544, 15], [197882382, 15], [197431109, 15], [611552758, 13], [205429375, 12]]

least_common:
  [[256834907, 5], [205429375, 12], [213286752, 12], [611552758, 13], [197431109, 15], [197882382, 15], [248903544, 15], [303218369, 15], [206156866, 18], [207052882, 29]]


table: steps
column: uses
most_common:
  [["None", 122], ["actions/checkout@v2", 32], ["actions/cache@v2", 24], ["actions/setup-python@v2", 22], ["actions/setup-python@v4", 18], ["actions/checkout@v3", 18], ["actions/cache@v3", 7], ["google-github-actions/setup-gcloud@v0", 3], ["actions/setup-python@v1", 2], ["actions/cache@v1", 2]]

least_common:
  [["actions/checkout@v4", 1], ["actions/setup-python@v3", 1], ["actions/upload-artifact@v2", 1], ["github/codeql-action/analyze@v1", 1], ["github/codeql-action/autobuild@v1", 1], ["github/codeql-action/init@v1", 1], ["codecov/codecov-action@v1", 2], ["mxschmitt/action-tmate@v3", 2], ["readthedocs/actions/preview@v1", 2], ["zofrex/mirror-branch@ea152f124954fa4eb26eea3fe0dbe313a3a08d94", 2]]


table: steps
column: name
most_common:
  [["None", 47], ["Install dependencies", 39], ["Configure pip caching", 31], ["Run tests", 25], ["Set up Python ${{ matrix.python-version }}", 24], ["Set up Python", 17], ["Publish", 11], ["Check out repo", 5], ["Install Python dependencies", 4], ["Set up Cloud Run", 3]]

least_common:
  [["Perform CodeQL Analysis", 1], ["Run prettier", 1], ["Run test", 1], ["Set up Python 3.10", 1], ["Set up Python 3.11", 1], ["Set up the alternate-route demo", 1], ["Test DATASETTE_LOAD_PLUGINS", 1], ["Test with pytest", 1], ["run flake8 if Python 3.8 or higher", 1], ["run mypy", 1]]


table: steps
column: with
most_common:
  [["None", 176], ["{\"path\": \"~/.cache/pip\", \"key\": \"${{ runner.os }}-pip-${{ hashFiles('**/setup.py...", 22], ["{\"python-version\": \"${{ matrix.python-version }}\"}", 16], ["{\"path\": \"~/.cache/pip\", \"key\": \"${{ runner.os }}-publish-pip-${{ hashFiles('**/...", 9], ["{\"python-version\": \"3.9\"}", 7], ["{\"python-version\": \"${{ matrix.python-version }}\", \"cache\": \"pip\", \"cache-depend...", 4], ["{\"version\": \"318.0.0\", \"service_account_email\": \"${{ secrets.GCP_SA_EMAIL }}\", \"...", 3], ["{\"python-version\": 3.9}", 3], ["{\"python-version\": \"3.11\"}", 3], ["{\"python-version\": \"${{ matrix.python-version }}\", \"cache\": \"pip\", \"cache-depend...", 2]]

least_common:
  [["{\"project-slug\": \"datasette\"}", 1], ["{\"project-slug\": \"sqlite-utils\"}", 1], ["{\"python-version\": \"${{ matrix.python-version }}\", \"allow-prereleases\": true}", 1], ["{\"python-version\": \"3.10\", \"cache\": \"pip\", \"cache-dependency-path\": \"**/setup.py...", 1], ["{\"python-version\": \"3.11\", \"cache\": \"pip\", \"cache-dependency-path\": \"**/setup.py...", 1], ["{\"python-version\": \"3.11\", \"cache\": \"pip\", \"cache-dependency-path\": \"pyproject.t...", 1], ["{\"python-version\": \"3.12\"}", 1], ["{\"python-version\": \"3.8\"}", 1], ["{\"target-branch\": \"main\", \"force\": false}", 1], ["{\"target-branch\": \"master\", \"force\": false}", 1]]


table: steps
column: run
most_common:
  [["None", 142], ["pytest\n", 19], ["pip install -e '.[test]'\n", 16], ["python setup.py sdist bdist_wheel\ntwine upload dist/*\n", 9], ["pip install setuptools wheel twine\n", 9], ["pip install '.[test]'\n", 4], ["pytest -v\n", 3], ["pip install -e '.[docs]'\n", 3], ["git diff\ngit config --global user.email \"readme-bot@example.com\"\ngit config --gl...", 2], ["cd docs\nDISABLE_SPHINX_INLINE_TABS=1 sphinx-build -b xml . _build\nsphinx-to-sqli...", 2]]

least_common:
  [["pip install sqlean.py sqlite-dump", 1], ["pytest -n auto -m \"not serial\"\npytest -m \"serial\"\n", 1], ["pytest -n auto -m \"not serial\"\npytest -m \"serial\"\n# And the test that exceeds a ...", 1], ["python -m pip install --upgrade pip\npip install -e .[test]\n", 1], ["python -m pip install --upgrade pip\npip install sqlite-utils>=3.1\nsqlite-utils -...", 1], ["python -m pip install --upgrade pip\npython -m pip install -e .[test]\npython -m p...", 1], ["python -m pip install -e .[docs]\npython -m pip install sphinx-to-sqlite==0.1a1\n", 1], ["python tests/fixtures.py \\\n  fixtures.db \\\n  fixtures-config.json \\\n  fixtures-m...", 1], ["sleep 60 # Give PyPI time to make the new release available\ndocker login -u $DOC...", 1], ["sqlite-utils github.db \"select full_name from repos where owner = 53015001 union...", 1]]


table: steps
column: env
most_common:
  [["None", 248], ["{\"TWINE_USERNAME\": \"__token__\", \"TWINE_PASSWORD\": \"${{ secrets.PYPI_TOKEN }}\"}", 11], ["{\"VERCEL_TOKEN\": \"${{ secrets.BRANCH_PREVIEW_VERCEL_TOKEN }}\"}", 1], ["{\"LATEST_DATASETTE_SECRET\": \"${{ secrets.LATEST_DATASETTE_SECRET }}\"}", 1], ["{\"GITHUB_ACCESS_TOKEN\": \"${{ secrets.GH_TOKEN }}\"}", 1], ["{\"DOCKER_USER\": \"${{ secrets.DOCKER_USER }}\", \"DOCKER_PASS\": \"${{ secrets.DOCKER...", 1], ["{\"DOCKER_USER\": \"${{ secrets.DOCKER_USER }}\", \"DOCKER_PASS\": \"${{ secrets.DOCKER...", 1]]


table: steps
column: if
most_common:
  [["None", 249], ["matrix.python-version != '3.8'", 3], ["${{ github.ref == 'refs/heads/main' }}", 3], ["matrix.python-version != '3.7'", 2], ["matrix.os == 'ubuntu-latest'", 2], ["matrix.python-version >= 3.8", 1], ["matrix.os == 'macos-latest' && matrix.python-version == '3.10'", 1], ["matrix.numpy == 1", 1], ["${{ github.event_name == 'pull_request' }}", 1], ["!contains(github.event.head_commit.message, 'REFRESH_DB')", 1]]


table: pull_requests
column: number
most_common: [[8, 4], [5, 4], [67, 3], [65, 3], [15, 3], [13, 3], [6, 3], [7, 2], [4, 2], [1, 2]]
least_common:
  [[2182, 1], [2183, 1], [2185, 1], [2190, 1], [2191, 1], [2192, 1], [2200, 1], [2202, 1], [2206, 1], [2209, 1]]


table: pull_requests
column: title
most_common:
  [["Bump the python-packages group with 1 update", 5], ["Bump the python-packages group with 3 updates", 3], ["Use Read the Docs action v1", 2], ["Update deploying.rst", 2], ["Update README.md", 2], ["Test against Python 3.12 preview", 2], ["Bump the python-packages group with 2 updates", 2], ["Bump sphinx, furo, blacken-docs dependencies", 2], ["Add paths for homebrew on Apple silicon", 2], [" Don't duplicate simple primary keys in the link column", 1]]

least_common:
  [["test commit", 1], ["test_insert_upsert_all_empty_list", 1], ["tiny typo in customization docs", 1], ["twitter-to-sqlite import command, refs #4", 1], ["upsert new rows with constraints, fixes #514", 1], ["use inspect data for hash and file size", 1], ["use jsonify_if_need for sql updates", 1], ["use poetry for packages, asdf for versioning, and gh actions for ci", 1], ["use single quotes for string literals, fixes #2001", 1], ["use universal command", 1]]


table: pull_requests
column: user
most_common:
  [[9599, 206], [49699333, 87], [27856297, 21], [45057, 19], [15178711, 9], [536941, 8], [25778, 8], [3243482, 7], [2657547, 6], [198537, 5]]

least_common:
  [[39452697, 1], [52261150, 1], [56323389, 1], [72577720, 1], [87192257, 1], [91880982, 1], [99098079, 1], [102635518, 1], [111973926, 1], [130708713, 1]]


table: pull_requests
column: body
most_common:
  [["", 54], ["None", 10], ["Refs #744", 2], ["\r\n\r\nRefs #90 ", 1], ["\r\n\r\nDeletes all rows in the table (if it exists) before inserting new rows.\r\nSQL...", 1], ["\r\n\r\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation ...", 1], ["\r\n\r\n<!-- readthedocs-preview sqlite-utils start -->\r\n----\n:books: Documentation ...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1], ["\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n----\n:books: Documentation pre...", 1]]

least_common:
  [["sqlite foreign keys can be compound, but that is not as well supported by datase...", 1], ["still testing, hope it works!\r\n\r\n<!-- readthedocs-preview datasette start -->\r\n-...", 1], ["the `--connection` parameter has become positional", 1], ["the library deal with Postgres type jsonb as dictionary, add dict type as a TEXT...", 1], ["this changes the SQL validation to allow for lines that are commented out\r\n\r\nmy ...", 1], ["this var `app` isn't actually used? unless init it does some side-effect outside...", 1], ["tiny tweak to make this easier to visually parse—I think it matches your style i...", 1], ["to keep the data write from failing if it came across an error during processing...", 1], ["was looking to add some custom templates to my use of datasette and saw this sma...", 1], ["…are escaped aps unicode for lists, tuples, dicts\r\n\r\nFix of #257 ", 1]]


table: pull_requests
column: updated_at
most_common:
  [["2020-05-27T20:21:56Z", 3], ["2017-11-21T20:55:05Z", 1], ["2017-11-19T20:30:24Z", 1], ["2017-11-18T03:15:57Z", 1], ["2017-11-17T15:16:34Z", 1], ["2017-11-17T15:12:29Z", 1], ["2017-11-17T03:50:52Z", 1], ["2017-11-15T03:08:04Z", 1], ["2017-11-15T02:03:01Z", 1], ["2017-11-14T02:24:54Z", 1]]

least_common:
  [["2023-10-14T17:49:03Z", 1], ["2023-10-24T13:40:29Z", 1], ["2023-11-04T00:34:33Z", 1], ["2023-11-04T00:46:55Z", 1], ["2023-11-04T00:49:50Z", 1], ["2023-11-04T00:58:03Z", 1], ["2023-11-08T13:19:03Z", 1], ["2023-11-15T15:31:12Z", 1], ["2023-12-08T05:17:20Z", 1], ["2023-12-08T13:46:24Z", 1]]


table: pull_requests
column: closed_at
most_common:
  [["None", 93], ["2023-08-07T16:20:20Z", 2], ["2017-11-18T03:15:50Z", 1], ["2017-11-18T00:53:43Z", 1], ["2017-11-17T14:22:56Z", 1], ["2017-11-17T13:29:22Z", 1], ["2017-11-17T03:50:52Z", 1], ["2017-11-15T03:08:04Z", 1], ["2017-11-15T02:03:01Z", 1], ["2017-11-13T22:16:55Z", 1]]

least_common:
  [["2023-10-12T16:16:38Z", 1], ["2023-10-12T16:20:51Z", 1], ["2023-10-13T00:00:27Z", 1], ["2023-10-24T13:40:26Z", 1], ["2023-11-04T00:31:49Z", 1], ["2023-11-04T00:40:30Z", 1], ["2023-11-04T00:49:50Z", 1], ["2023-11-04T00:58:02Z", 1], ["2023-11-08T13:19:01Z", 1], ["2023-12-08T05:05:27Z", 1]]


table: pull_requests
column: merged_at
most_common:
  [["None", 200], ["2017-11-21T20:55:05Z", 1], ["2017-11-18T03:15:50Z", 1], ["2017-11-18T00:53:43Z", 1], ["2017-11-17T14:22:56Z", 1], ["2017-11-17T13:29:22Z", 1], ["2017-11-17T03:50:52Z", 1], ["2017-11-15T03:08:04Z", 1], ["2017-11-15T02:03:01Z", 1], ["2017-11-13T22:16:55Z", 1]]

least_common:
  [["2023-09-13T21:06:25Z", 1], ["2023-09-20T22:10:55Z", 1], ["2023-09-20T22:11:24Z", 1], ["2023-10-12T16:16:38Z", 1], ["2023-10-12T16:20:51Z", 1], ["2023-10-13T00:00:27Z", 1], ["2023-11-04T00:31:49Z", 1], ["2023-11-04T00:40:30Z", 1], ["2023-11-04T00:49:50Z", 1], ["2023-12-08T05:05:27Z", 1]]


table: pull_requests
column: merge_commit_sha
most_common:
  [["None", 1], ["03cc697b6b3d0983618c29ee75b45b5e0ac91139", 1], ["03b35d70e281ea48bd9b8058738ed87b13cea2de", 1], ["02f5c4d69d7b4baebde015c56e5bc62923f33314", 1], ["0276c5609da34bfb660f65212e1a367e637979d7", 1], ["025b4024b1b43ea034b7fd331c30740165ff75f2", 1], ["022cdd97a9ddab1a152e23e1e1c42e78c1ed0fa9", 1], ["01369176b0a8943ab45292ffc6f9c929b80a00e8", 1], ["013496862f4d4b441ab61255242b838b24287607", 1], ["00e59ec461dc0150772b999c7cc15fcb9b507d58", 1]]

least_common:
  [["f92d823766872a6fd7e76c5249a6b2de1ab0f447", 1], ["f96e55bce55d26c4d5b198edc536e1b8e9bbea43", 1], ["f99a23652910b03ac4669bbbb35a9b484451aabb", 1], ["fb3abeceb2785a582d2c120c7c1bf7dc3cd1de05", 1], ["fb57d4474cb1fdaef260e244b1b6f470f1992e40", 1], ["fc2d316f9e22593d48036e9d81fe972bb5973016", 1], ["fc3660cfad7668dbce6ead12766e048fc1f78b11", 1], ["fcfcae21e67cc15090942b1d2a47b5f016279337", 1], ["fda4dad23a0494890267fbe8baf179e2b56ee914", 1], ["ffff3a4c5398a9f40b61d59736f386444da19289", 1]]


table: pull_requests
column: milestone
most_common:
  [["None", 573], [6026070, 6], [3268330, 4], [8711695, 3], [6346396, 3], [5512395, 3], [5471110, 3], [7558727, 2], [5971510, 2], [4471010, 2]]

least_common:
  [[5234079, 1], [5533512, 1], [5897911, 1], [6055094, 1], [9700784, 1], [4471010, 2], [5971510, 2], [7558727, 2], [8355157, 2], [8711695, 3]]


table: pull_requests
column: base
most_common:
  [["f09d611782a8372cfb002792dfa727325afb4db6", 7], ["1b697539f5b53cec3fe13c0f4ada13ba655c88c7", 6], ["e54e544427f1cc3ea8189f0e95f54046301a8645", 5], ["0b4a28691468b5c758df74fa1d72a823813c96bf", 5], ["6ed7908580fa2ba9297c3225d85c56f8b08b9937", 4], ["5890a20c374fb0812d88c9b0ef26a838bfa06c76", 4], ["527cec66b0403e689c8fb71fc8b381a1d7a46516", 4], ["452a587e236ef642cbc6ae345b58767ea8420cb5", 4], ["11b352b4d52fd02a422776edebb14f12e4994d3b", 4], ["08181823990a71ffa5a1b57b37259198eaa43e06", 4]]

least_common:
  [["f825e2012109247fa246e2b938f8174069e574f1", 1], ["f8277d0fb9c05a88a9ff01d996e31d55f0f0a645", 1], ["fa8eb0bf1b113ab17ede9cd107b7c3bd5cde39c3", 1], ["faea5093b865031f650da7da6539430f732f511a", 1], ["fb988ace7c7e2bee5ac142a0eab22431d0675a77", 1], ["fcf43589eb6a1f1d0432772a639fd35711c48e0c", 1], ["fcfcae21e67cc15090942b1d2a47b5f016279337", 1], ["fd083e37ec53e7e625111168d324a572344a3b19", 1], ["fe5b6ea95a973534fe8a44907c0ea2449aae7602", 1], ["fff89772b4404995400e33fe1d269050717ff4cf", 1]]


table: pull_requests
column: repo
most_common:
  [[107914493, 436], [140912432, 110], [206156866, 13], [207052882, 11], [256834907, 7], [197882382, 7], [214746582, 6], [206649770, 5], [303218369, 4], [205429375, 3]]

least_common:
  [[197431109, 1], [213286752, 1], [248903544, 2], [611552758, 2], [205429375, 3], [303218369, 4], [206649770, 5], [214746582, 6], [197882382, 7], [256834907, 7]]


table: pull_requests_fts_docsize
column: sz
most_common:
  [["b'\\x07\\x00'", 13], ["b'\\x08\\x02'", 11], ["b'\\x07\\x02'", 11], ["b'\\x06\\x00'", 11], ["b'\\x04\\x00'", 11], ["b'\\x05\\x02'", 10], ["b'\\x04\\x02'", 10], ["b'\\x06\\x02'", 8], ["b'\\x05\\x00'", 8], ["b'\\x03\\x00'", 6]]

least_common:
  [["b'\\x11\\x89.'", 1], ["b'\\x11\\x896'", 1], ["b'\\x11\\x89<'", 1], ["b'\\x11\\x89`'", 1], ["b'\\x11\\x89s'", 1], ["b'\\x11\\x8a\\r'", 1], ["b'\\x11\\x8a\\x1e'", 1], ["b'\\x11\\x8ax'", 1], ["b'\\x14z'", 1], ["b'\\x15g'", 1]]


table: labels_pull_requests
column: labels_id
most_common:
  [[1970143153, 109], [993377884, 11], [754269786, 7], [1379448359, 6], [993222446, 6], [727708734, 6], [2374328705, 5], [1405404904, 5], [750789605, 4], [754730474, 3]]

least_common:
  [[947465681, 1], [1382668283, 1], [1918831023, 1], [2157112227, 1], [2175284252, 1], [2459412274, 1], [3645705798, 1], [3799780031, 1], [4251477726, 1], [4860121561, 1]]


table: labels_pull_requests
column: pull_requests_id
most_common:
  [[971057476, 3], [853484980, 2], [817257851, 2], [804924636, 2], [700944644, 2], [513106026, 2], [511005542, 2], [481616704, 2], [431478724, 2], [296735320, 2]]

least_common:
  [[1492599485, 1], [1497165426, 1], [1507097949, 1], [1510415840, 1], [1515716751, 1], [1522166951, 1], [1542299634, 1], [1562664755, 1], [1571053445, 1], [1592615419, 1]]


table: _analyze_tables_
column: table
most_common:
  [["repos", 57], ["pull_requests", 23], ["issues", 23], ["milestones", 15], ["releases", 14], ["assets", 14], ["issue_comments", 12], ["steps", 10], ["users", 9], ["commits", 9]]

least_common:
  [["commits_fts", 1], ["issue_comments_fts", 1], ["licenses_fts", 1], ["repos_fts_config", 2], ["repos_fts_data", 2], ["repos_fts_docsize", 2], ["users_fts", 2], ["users_fts_config", 2], ["users_fts_data", 2], ["users_fts_docsize", 2]]


table: _analyze_tables_
column: column
most_common:
  [["id", 33], ["name", 17], ["repo", 11], ["term", 10], ["sz", 10], ["segid", 10], ["pgno", 10], ["node_id", 10], ["k", 10], ["block", 10]]

least_common:
  [["uploader", 1], ["use_squash_pr_title_as_default", 1], ["user_id", 1], ["uses", 1], ["visibility", 1], ["watchers", 1], ["watchers_count", 1], ["web_commit_signoff_required", 1], ["with", 1], ["workflow", 1]]


table: _analyze_tables_
column: total_rows
least_common: [[28, 2], [47, 2], [50, 2], [53, 2], [154, 2], [190, 2], [464, 2], [725, 2], [3359, 2], [12035, 3]]
most_common:
  [[1502, 61], [1, 43], [3044, 27], [608, 27], [35, 19], [355, 18], [10495, 15], [11453, 13], [3922, 12], [106, 11]]


table: _analyze_tables_
column: num_null
most_common: [[0, 279], [1, 5], [1420, 4], [1265, 4], [608, 2], [496, 2], [14, 2], [13, 2], [10, 2], [8, 2]]
least_common:
  [[1235, 1], [1294, 1], [1374, 1], [1389, 1], [1411, 1], [1435, 1], [1447, 1], [2420, 1], [3023, 1], [10490, 1]]


table: _analyze_tables_
column: num_distinct
most_common: [[1, 73], [2, 24], [17, 10], [3, 10], [608, 7], [6, 7], [1502, 6], [355, 6], [16, 6], [0, 5]]
least_common:
  [[1877, 1], [2113, 1], [2137, 1], [2198, 1], [2935, 1], [3042, 1], [3793, 1], [3919, 1], [10368, 1], [12031, 1]]


table: _analyze_tables_
column: most_common
most_common:
  [["None", 84], ["[[\"None\", 1502]]", 12], ["[[4, 1]]", 10], ["[[\"version\", 1]]", 10], ["[[\"fineheard\", 2], [\"0nebody\", 1], [\"0ndrec\", 1], [\"0ihsan\", 1], [\"0ax-christin\"...", 4], ["[[2, 1]]", 3], ["[[1, 1]]", 3], ["[[0, 1063], [1, 156], [2, 65], [3, 42], [4, 21], [7, 17], [6, 16], [5, 16], [8, ...", 3], ["[[\"b''\", 1]]", 3], ["[[\"\", 21], [\"None\", 1], [\"Just addressable content, a full JSON API and pages th...", 2]]

least_common:
  [["[[9599, 203], [139249755, 19], [25778, 17], [15178711, 15], [53015001, 14], [440...", 1], ["[[9599, 206], [49699333, 87], [27856297, 21], [45057, 19], [15178711, 9], [53694...", 1], ["[[9599, 2071], [49699333, 87], [536941, 34], [45057, 26], [27856297, 22], [25778...", 1], ["[[9599, 3025], [19864447, 878], [\"None\", 8], [21148, 6], [45057, 5]]", 1], ["[[9599, 355]]", 1], ["[[9599, 35]]", 1], ["[[9599, 3662], [49699333, 53], [45057, 20], [27856297, 17], [\"None\", 8], [151787...", 1], ["[[9599, 8883], [22429695, 240], [536941, 82], [25778, 74], [45057, 39], [4969933...", 1], ["[[971057476, 3], [853484980, 2], [817257851, 2], [804924636, 2], [700944644, 2],...", 1], ["[[null, 1]]", 1]]


table: _analyze_tables_
column: least_common
most_common:
  [["None", 209], ["[[\"zxyao145\", 1], [\"zxygithub\", 1], [\"zy528\", 1], [\"zyuanlim\", 1], [\"zz\", 1], [\"...", 4], ["[[364, 1], [388, 1], [410, 1], [682, 1], [1057, 1], [1062, 1], [1260, 1], [1365,...", 3], ["[[\"sqlite foreign keys can be compound, but that is not as well supported by dat...", 2], ["[[\"release\", 1], [\"search\", 1], [\"security\", 1], [\"small\", 1], [\"support\", 1], [...", 2], ["[[\"https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-2\", 1], [\"htt...", 2], ["[[\"Datasette 0.62\", 1], [\"Datasette 1.0\", 1], [\"Datasette 1.0a-next\", 1], [\"Data...", 2], ["[[\"Datasette 0.29\", 1], [\"Datasette 0.31\", 1], [\"Datasette 0.32\", 1], [\"Datasett...", 2], ["[[\"Big new features in this release are ASGI support, new plugin hooks for ASGI ...", 2], ["[[\"Awaiting something else to happen first\", 1], [\"Further information is reques...", 2]]

least_common:
  [["[[39452697, 1], [52261150, 1], [56323389, 1], [72577720, 1], [87192257, 1], [918...", 1], ["[[449, 1], [452, 1], [460, 1], [461, 1], [463, 1], [487, 1], [511, 1], [518, 1],...", 1], ["[[49702524, 1], [60892516, 1], [63653929, 1], [76450761, 1], [76528036, 1], [804...", 1], ["[[5234079, 1], [5533512, 1], [5897911, 1], [6055094, 1], [9700784, 1], [4471010,...", 1], ["[[69208826, 1], [76450761, 1], [80409402, 1], [83080728, 1], [87192257, 1], [918...", 1], ["[[722215565, 1], [723559658, 1], [724100681, 1], [724695324, 1], [725878842, 1],...", 1], ["[[841675, 1], [1124434, 1], [1215453, 1], [1216794, 1], [1289400, 1], [2206999, ...", 1], ["[[880, 1], [886, 1], [888, 1], [890, 1], [892, 1], [894, 1], [896, 1], [898, 1],...", 1], ["[[9374594, 1], [5896742, 3], [4348046, 4], [5324096, 4], [5607421, 4], [2859414,...", 1], ["[[947465681, 1], [1382668283, 1], [1918831023, 1], [2157112227, 1], [2175284252,...", 1]]


