Dataset: Advent Of Code 2015-2023 Public Stats

About this Dataset

Advent Of Code 2015-2023 Public Stats

I wanted to gather all of the Advent of Code public data in one place to create some nice visualizations. Perhaps there are other fans of AoC out there who will find this useful.

Also, check out my Advent of Code puzzle solving website: https://aoc-puzzle-solver.streamlit.app/

Tables

Completions

@kaggle.michaeltezak_advent_of_code_public_stats.completions

10.77 KB
225 rows
5 columns


CREATE TABLE completions (
  "year" BIGINT,
  "day" BIGINT,
  "title" VARCHAR,
  "gold" BIGINT,
  "silver" BIGINT
);

Leaderboard

@kaggle.michaeltezak_advent_of_code_public_stats.leaderboard

481.21 KB
45000 rows
6 columns


CREATE TABLE leaderboard (
  "timestamp" TIMESTAMP,
  "part" BIGINT,
  "points" BIGINT,
  "user_name" VARCHAR,
  "supporter" BOOLEAN,
  "sponsor" BOOLEAN
);