home / combat-reptile_dump_2023-06-27

Menu
  • Sign in with GitHub

participants

8 rows where gid = "0099a603-42c1-4bd8-a423-b4a57f640661"

This data as json, CSV (advanced)

Suggested facets: won

Link rowid ▼ gid sid name won
254410 254410 0099a603-42c1-4bd8-a423-b4a57f640661 gs_yyfGdwXPQ3MfKk7XH8XFcvG7 $n4k3 g4diuk4 0
254411 254411 0099a603-42c1-4bd8-a423-b4a57f640661 gs_GJJ33c3Fjb3fKKc4xc6dvDPC Thunderous Soldier 0
254412 254412 0099a603-42c1-4bd8-a423-b4a57f640661 gs_4kdSwf6wrkm3Wt3BqVf9pWK8 Reimagined Chainsaw 0
254413 254413 0099a603-42c1-4bd8-a423-b4a57f640661 gs_pCg3SCj7mYwHTKBRCWp8PSSD Megaton Collective 0
254414 254414 0099a603-42c1-4bd8-a423-b4a57f640661 gs_kxpyfDJBKvQGdKGXShcJ68j8 MajesticPurple 0
254415 254415 0099a603-42c1-4bd8-a423-b4a57f640661 gs_3kgvrg73f3WkBP7j8QVGkSjX Combat Reptile 1
254416 254416 0099a603-42c1-4bd8-a423-b4a57f640661 gs_JjpvmBxDKQhSHdpkYbMvDvjB Boundless Scuttlecoil 0
254417 254417 0099a603-42c1-4bd8-a423-b4a57f640661 gs_WcK66w6g4FjYfFb4XTtpkmbT Badly Coded Snake II 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 4.293ms