Scrabble Games: scrabble_games.csv

This table contains data behind the story How 'Qi' And 'Za' Changed Scrabble.

Header Definition
gameid A numerical game ID
tourneyid A numerical tournament ID
tie A binary variable indicating if the game ended in a tie
winnerid A numerical ID for the winning player
winnername The name of the winning player
winnerscore The score of the winning player
winneroldrating The winner’s rating before the game
winnernewrating The winner’s rating after the game
winnerpos The winner’s position in the tournament
loserid A numerical ID for the losing player
loserscore The score of the losing player
loseroldrating The loser’s rating before the game
losernewrating The loser’s rating after the game
loserpos The loser’s position in the tournament
round The round of the tournament in which the game took place
division The division of the tournament in which the game took place
date The date of the game
lexicon A binary variable indicating if the game’s lexicon was the main North American lexicon (False) or the international lexicon (True)

Source: cross-tables.com

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

1,542,642 rows

View and edit SQL

Suggested facets: date (date)

Link rowid ▼ gameid tourneyid tie winnerid winnername winnerscore winneroldrating winnernewrating winnerpos loserid losername loserscore loseroldrating losernewrating loserpos round division date lexicon
1 1 1 0 268 Harriette Lakernick 0 1568 1684 1 429 Patricia Barrett 0 1915 1872 3 1 1 1998-12-06 0
2 2 1 0 268 Harriette Lakernick 0 1568 1684 1 435 Chris Cree 0 1840 1798 6 2 1 1998-12-06 0
3 3 1 0 268 Harriette Lakernick 0 1568 1684 1 441 Caesar Jaramillo 0 1622 1606 10 3 1 1998-12-06 0
4 4 1 0 268 Harriette Lakernick 0 1568 1684 1 456 Mike Chitwood 0 1612 1600 9 4 1 1998-12-06 0
5 5 1 0 268 Harriette Lakernick 0 1568 1684 1 1334 Nancy Scott 0 1537 1590 4 6 1 1998-12-06 0
6 6 1 0 268 Harriette Lakernick 0 1568 1684 1 454 Mary Rhoades 0 1676 1647 8 8 1 1998-12-06 0
7 7 1 0 268 Harriette Lakernick 0 1568 1684 1 5766 Stephen Fierros 0 1647 1640 7 9 1 1998-12-06 0
8 8 1 0 268 Harriette Lakernick 0 1568 1684 1 442 Matt Dewaelsche 0 1739 1747 2 10 1 1998-12-06 0
9 9 1 0 429 Patricia Barrett 0 1915 1872 3 456 Mike Chitwood 0 1612 1600 9 3 1 1998-12-06 0
10 10 1 0 429 Patricia Barrett 0 1915 1872 3 1334 Nancy Scott 0 1537 1590 4 5 1 1998-12-06 0
11 11 1 0 429 Patricia Barrett 0 1915 1872 3 431 Sam Dick-Onuoha 0 1557 1650 5 6 1 1998-12-06 0
12 12 1 0 429 Patricia Barrett 0 1915 1872 3 435 Chris Cree 0 1840 1798 6 9 1 1998-12-06 0
13 13 1 0 429 Patricia Barrett 0 1915 1872 3 435 Chris Cree 0 1840 1798 6 10 1 1998-12-06 0
14 14 1 0 429 Patricia Barrett 0 1915 1872 3 431 Sam Dick-Onuoha 0 1557 1650 5 11 1 1998-12-06 0
15 15 1 0 431 Sam Dick-Onuoha 0 1557 1650 5 435 Chris Cree 0 1840 1798 6 3 1 1998-12-06 0
16 16 1 0 431 Sam Dick-Onuoha 0 1557 1650 5 454 Mary Rhoades 0 1676 1647 8 4 1 1998-12-06 0
17 17 1 0 431 Sam Dick-Onuoha 0 1557 1650 5 268 Harriette Lakernick 0 1568 1684 1 7 1 1998-12-06 0
18 18 1 0 431 Sam Dick-Onuoha 0 1557 1650 5 441 Caesar Jaramillo 0 1622 1606 10 8 1 1998-12-06 0
19 19 1 0 431 Sam Dick-Onuoha 0 1557 1650 5 456 Mike Chitwood 0 1612 1600 9 9 1 1998-12-06 0
20 20 1 0 431 Sam Dick-Onuoha 0 1557 1650 5 5766 Stephen Fierros 0 1647 1640 7 10 1 1998-12-06 0
21 21 1 0 435 Chris Cree 0 1840 1798 6 1334 Nancy Scott 0 1537 1590 4 1 1 1998-12-06 0
22 22 1 0 435 Chris Cree 0 1840 1798 6 441 Caesar Jaramillo 0 1622 1606 10 4 1 1998-12-06 0
23 23 1 0 435 Chris Cree 0 1840 1798 6 454 Mary Rhoades 0 1676 1647 8 5 1 1998-12-06 0
24 24 1 0 435 Chris Cree 0 1840 1798 6 5766 Stephen Fierros 0 1647 1640 7 7 1 1998-12-06 0
25 25 1 0 435 Chris Cree 0 1840 1798 6 454 Mary Rhoades 0 1676 1647 8 11 1 1998-12-06 0
26 26 1 0 440 John Dalton 0 1093 1071 5 5946 Mark Setty 0 922 776 17 2 3 1998-12-06 0
27 27 1 0 440 John Dalton 0 1093 1071 5 1712 Dave Rubin 0 883 873 11 3 3 1998-12-06 0
28 28 1 0 440 John Dalton 0 1093 1071 5 4412 Ivy Kaminsky 0 970 990 4 5 3 1998-12-06 0
29 29 1 0 440 John Dalton 0 1093 1071 5 3251 Roger Dimick 0 765 825 8 6 3 1998-12-06 0
30 30 1 0 440 John Dalton 0 1093 1071 5 452 Bruce Shuman 0 1002 1010 6 7 3 1998-12-06 0
31 31 1 0 440 John Dalton 0 1093 1071 5 2574 Waheed Thompson 0 1053 1036 10 11 3 1998-12-06 0
32 32 1 0 441 Caesar Jaramillo 0 1622 1606 10 429 Patricia Barrett 0 1915 1872 3 2 1 1998-12-06 0
33 33 1 0 441 Caesar Jaramillo 0 1622 1606 10 442 Matt Dewaelsche 0 1739 1747 2 6 1 1998-12-06 0
34 34 1 0 441 Caesar Jaramillo 0 1622 1606 10 1334 Nancy Scott 0 1537 1590 4 7 1 1998-12-06 0
35 35 1 0 441 Caesar Jaramillo 0 1622 1606 10 456 Mike Chitwood 0 1612 1600 9 11 1 1998-12-06 0
36 36 1 0 442 Matt Dewaelsche 0 1739 1747 2 431 Sam Dick-Onuoha 0 1557 1650 5 1 1 1998-12-06 0
37 37 1 0 442 Matt Dewaelsche 0 1739 1747 2 454 Mary Rhoades 0 1676 1647 8 2 1 1998-12-06 0
38 38 1 0 442 Matt Dewaelsche 0 1739 1747 2 429 Patricia Barrett 0 1915 1872 3 4 1 1998-12-06 0
39 39 1 0 442 Matt Dewaelsche 0 1739 1747 2 268 Harriette Lakernick 0 1568 1684 1 5 1 1998-12-06 0
40 40 1 0 442 Matt Dewaelsche 0 1739 1747 2 456 Mike Chitwood 0 1612 1600 9 7 1 1998-12-06 0
41 41 1 0 442 Matt Dewaelsche 0 1739 1747 2 435 Chris Cree 0 1840 1798 6 8 1 1998-12-06 0
42 42 1 0 442 Matt Dewaelsche 0 1739 1747 2 268 Harriette Lakernick 0 1568 1684 1 11 1 1998-12-06 0
43 43 1 0 444 Maureen Delgado 0 1536 1507 11 465 Carl Hickerson 0 1307 1282 17 2 2 1998-12-06 0
44 44 1 0 444 Maureen Delgado 0 1536 1507 11 2121 Cheryl Tyler 0 1496 1482 7 3 2 1998-12-06 0
45 45 1 0 444 Maureen Delgado 0 1536 1507 11 491 Mary Lou Thurman 0 1224 1216 20 5 2 1998-12-06 0
46 46 1 0 444 Maureen Delgado 0 1536 1507 11 1335 Charlotte Ferris 0 1411 1416 8 6 2 1998-12-06 0
47 47 1 0 444 Maureen Delgado 0 1536 1507 11 1461 T A Sanders 0 1436 1442 10 7 2 1998-12-06 0
48 48 1 0 444 Maureen Delgado 0 1536 1507 11 1315 Rhonda Roederer 0 1140 1225 12 10 2 1998-12-06 0
49 49 1 0 447 Robin Lewis 0 1459 1443 14 479 Ruth Sawyer 0 1449 1411 19 1 2 1998-12-06 0
50 50 1 0 447 Robin Lewis 0 1459 1443 14 3011 Scott Lucas 0 1407 1449 2 2 2 1998-12-06 0
51 51 1 0 447 Robin Lewis 0 1459 1443 14 444 Maureen Delgado 0 1536 1507 11 4 2 1998-12-06 0
52 52 1 0 447 Robin Lewis 0 1459 1443 14 1335 Charlotte Ferris 0 1411 1416 8 5 2 1998-12-06 0
53 53 1 0 447 Robin Lewis 0 1459 1443 14 1461 T A Sanders 0 1436 1442 10 6 2 1998-12-06 0
54 54 1 0 449 Judy Newhouse 0 1103 1095 3 2574 Waheed Thompson 0 1053 1036 10 1 3 1998-12-06 0
55 55 1 0 449 Judy Newhouse 0 1103 1095 3 5945 Sylvia Setty 0 0 633 16 2 3 1998-12-06 0
56 56 1 0 449 Judy Newhouse 0 1103 1095 3 482 Jane Tacker 0 960 958 9 3 3 1998-12-06 0
57 57 1 0 449 Judy Newhouse 0 1103 1095 3 1712 Dave Rubin 0 883 873 11 6 3 1998-12-06 0
58 58 1 0 449 Judy Newhouse 0 1103 1095 3 440 John Dalton 0 1093 1071 5 8 3 1998-12-06 0
59 59 1 0 449 Judy Newhouse 0 1103 1095 3 720 Andrea Salinas 0 683 697 12 9 3 1998-12-06 0
60 60 1 0 449 Judy Newhouse 0 1103 1095 3 452 Bruce Shuman 0 1002 1010 6 10 3 1998-12-06 0
61 61 1 0 452 Bruce Shuman 0 1002 1010 6 5944 Henry Moses 0 500 573 15 3 3 1998-12-06 0
62 62 1 0 452 Bruce Shuman 0 1002 1010 6 1712 Dave Rubin 0 883 873 11 4 3 1998-12-06 0
63 63 1 0 452 Bruce Shuman 0 1002 1010 6 482 Jane Tacker 0 960 958 9 5 3 1998-12-06 0
64 64 1 0 452 Bruce Shuman 0 1002 1010 6 2574 Waheed Thompson 0 1053 1036 10 8 3 1998-12-06 0
65 65 1 0 452 Bruce Shuman 0 1002 1010 6 5945 Sylvia Setty 0 0 633 16 9 3 1998-12-06 0
66 66 1 0 452 Bruce Shuman 0 1002 1010 6 5805 Lynne Murphy 0 855 936 7 11 3 1998-12-06 0
67 67 1 0 454 Mary Rhoades 0 1676 1647 8 456 Mike Chitwood 0 1612 1600 9 1 1 1998-12-06 0
68 68 1 0 454 Mary Rhoades 0 1676 1647 8 5766 Stephen Fierros 0 1647 1640 7 6 1 1998-12-06 0
69 69 1 0 454 Mary Rhoades 0 1676 1647 8 429 Patricia Barrett 0 1915 1872 3 7 1 1998-12-06 0
70 70 1 0 454 Mary Rhoades 0 1676 1647 8 441 Caesar Jaramillo 0 1622 1606 10 9 1 1998-12-06 0
71 71 1 0 455 Carole Miller 0 1401 1310 24 2223 Karen Slaton 0 1209 1188 23 10 2 1998-12-06 0
72 72 1 0 455 Carole Miller 0 1401 1310 24 2223 Karen Slaton 0 1209 1188 23 11 2 1998-12-06 0
73 73 1 0 456 Mike Chitwood 0 1612 1600 9 441 Caesar Jaramillo 0 1622 1606 10 5 1 1998-12-06 0
74 74 1 0 456 Mike Chitwood 0 1612 1600 9 435 Chris Cree 0 1840 1798 6 6 1 1998-12-06 0
75 75 1 0 456 Mike Chitwood 0 1612 1600 9 1334 Nancy Scott 0 1537 1590 4 8 1 1998-12-06 0
76 76 1 0 456 Mike Chitwood 0 1612 1600 9 441 Caesar Jaramillo 0 1622 1606 10 10 1 1998-12-06 0
77 77 1 0 458 Jan Asuquo 0 1254 1255 15 455 Carole Miller 0 1401 1310 24 4 2 1998-12-06 0
78 78 1 1 458 Jan Asuquo 0 1254 1255 15 2223 Karen Slaton 0 1209 1188 23 5 2 1998-12-06 0
79 79 1 1 458 Jan Asuquo 0 1254 1255 15 465 Carl Hickerson 0 1307 1282 17 6 2 1998-12-06 0
80 80 1 0 458 Jan Asuquo 0 1254 1255 15 491 Mary Lou Thurman 0 1224 1216 20 8 2 1998-12-06 0
81 81 1 0 458 Jan Asuquo 0 1254 1255 15 477 Beulah Cooper 0 1396 1322 22 9 2 1998-12-06 0
82 82 1 0 458 Jan Asuquo 0 1254 1255 15 491 Mary Lou Thurman 0 1224 1216 20 10 2 1998-12-06 0
83 83 1 0 462 Lee Brooks 0 1377 1346 18 458 Jan Asuquo 0 1254 1255 15 3 2 1998-12-06 0
84 84 1 0 462 Lee Brooks 0 1377 1346 18 477 Beulah Cooper 0 1396 1322 22 5 2 1998-12-06 0
85 85 1 0 462 Lee Brooks 0 1377 1346 18 4209 Priscilla Fournet 0 1251 1250 21 6 2 1998-12-06 0
86 86 1 0 462 Lee Brooks 0 1377 1346 18 4209 Priscilla Fournet 0 1251 1250 21 10 2 1998-12-06 0
87 87 1 0 465 Carl Hickerson 0 1307 1282 17 455 Carole Miller 0 1401 1310 24 5 2 1998-12-06 0
88 88 1 0 465 Carl Hickerson 0 1307 1282 17 2223 Karen Slaton 0 1209 1188 23 8 2 1998-12-06 0
89 89 1 0 465 Carl Hickerson 0 1307 1282 17 462 Lee Brooks 0 1377 1346 18 9 2 1998-12-06 0
90 90 1 0 465 Carl Hickerson 0 1307 1282 17 463 April McCarley 0 1185 1220 16 10 2 1998-12-06 0
91 91 1 0 477 Beulah Cooper 0 1396 1322 22 465 Carl Hickerson 0 1307 1282 17 3 2 1998-12-06 0
92 92 1 0 477 Beulah Cooper 0 1396 1322 22 455 Carole Miller 0 1401 1310 24 6 2 1998-12-06 0
93 93 1 0 477 Beulah Cooper 0 1396 1322 22 463 April McCarley 0 1185 1220 16 7 2 1998-12-06 0
94 94 1 0 479 Ruth Sawyer 0 1449 1411 19 455 Carole Miller 0 1401 1310 24 2 2 1998-12-06 0
95 95 1 0 479 Ruth Sawyer 0 1449 1411 19 486 Thelma Litton 0 1209 1250 13 3 2 1998-12-06 0
96 96 1 0 479 Ruth Sawyer 0 1449 1411 19 491 Mary Lou Thurman 0 1224 1216 20 7 2 1998-12-06 0
97 97 1 0 479 Ruth Sawyer 0 1449 1411 19 444 Maureen Delgado 0 1536 1507 11 8 2 1998-12-06 0
98 98 1 0 482 Jane Tacker 0 960 958 9 5946 Mark Setty 0 922 776 17 1 3 1998-12-06 0
99 99 1 0 482 Jane Tacker 0 960 958 9 4412 Ivy Kaminsky 0 970 990 4 2 3 1998-12-06 0
100 100 1 0 482 Jane Tacker 0 960 958 9 5805 Lynne Murphy 0 855 936 7 4 3 1998-12-06 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "scrabble-games/scrabble_games" (
"gameid" INTEGER,
  "tourneyid" INTEGER,
  "tie" INTEGER,
  "winnerid" INTEGER,
  "winnername" TEXT,
  "winnerscore" INTEGER,
  "winneroldrating" INTEGER,
  "winnernewrating" INTEGER,
  "winnerpos" INTEGER,
  "loserid" INTEGER,
  "losername" TEXT,
  "loserscore" INTEGER,
  "loseroldrating" INTEGER,
  "losernewrating" INTEGER,
  "loserpos" INTEGER,
  "round" INTEGER,
  "division" INTEGER,
  "date" TEXT,
  "lexicon" INTEGER
);
Powered by Datasette · Query took 4207.603ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub