home / combat-reptile_dump_2023-06-27

Menu
  • Sign in with GitHub

participants

4 rows where gid = "00a5796b-b647-4c04-b19d-8f4047f0a7c1"

This data as json, CSV (advanced)

Suggested facets: won

Link rowid ▼ gid sid name won
216627 216627 00a5796b-b647-4c04-b19d-8f4047f0a7c1 gs_jW7JvCwG7By6dgJp4phMfvKF Combat Reptile 1
216628 216628 00a5796b-b647-4c04-b19d-8f4047f0a7c1 gs_SqBWfQKrCggSDSJxR4dfDp3W moustache 🥸 0
216629 216629 00a5796b-b647-4c04-b19d-8f4047f0a7c1 gs_wT9Q8DBDTMTCJ7Vkx8QxDMYY One 0
216630 216630 00a5796b-b647-4c04-b19d-8f4047f0a7c1 gs_PqXKXJ8VSh9Tg4b6QycdkdxQ soma-noob v3[bg] 0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE participants (
          gid TEXT NOT NULL REFERENCES games(gid),
          sid TEXT NOT NULL,
          name TEXT NOT NULL,
          won INTEGER NOT NULL
        );
CREATE INDEX index_gid ON participants(gid);
CREATE INDEX index_name ON participants(name);
Powered by Datasette · Queries took 7.867ms