View table: AllMatches

From TwogPedia

Table structure:

  1. p1 - Page
  2. p2 - Page
  3. p1score - Integer
  4. p2score - Integer
  5. winner - Integer
  6. date - Datetime
  7. bestof - Integer
  8. stage - String
  9. casters - List of Page, delimiter: ,
  10. observers - List of Page, delimiter: ,
  11. api_id - String
  12. tiebreak - Boolean
  13. twitch - String
  14. youtube - String

This table has 72 rows altogether.

Recreate data.

Page p1 p2 p1score p2score winner date bestof stage casters observers api id tiebreak twitch youtube
Sigma Dota Challenge (edit) HellRaisers Level Up Esports 3 0 1 2022-08-24 11:00:00 AM 5 cedica
Sigma Dota Challenge (edit) HellRaisers Dota2/Surim Prasad 2 0 1 2022-08-23 9:00:00 AM 3 cedica
Sigma Dota Challenge (edit) Level Up Esports Dota2/Team Serbia 2 1 1 2022-08-23 11:00:00 AM 3 cedica
The International 2023 - Group Stage (edit) 9Pandas Entity 1 1 3 2023-10-12 9:00:00 PM 2 Group A Moxxi • Wagamama Glem 2484990
The International 2023 - Group Stage (edit) 9Pandas Team SMG 2 0 1 2023-10-13 1:00:00 AM 2 Group A Nomad • TeaGuvnor PTP 2485047
The International 2023 - Group Stage (edit) Azure Ray Thunder Awaken 2 0 1 2023-10-13 1:00:00 AM 2 Group B Ares • Danog skrff 2485044
The International 2023 - Group Stage (edit) BetBoom Team 9Pandas 1 2 2 2023-10-15 8:00:00 PM 3 BreakyCPK • KheZu Weppas 2485752
The International 2023 - Group Stage (edit) BetBoom Team Azure Ray 2 0 1 2023-10-13 9:00:00 PM 2 Group B T-Panda • Fear skrff 2485252
The International 2023 - Group Stage (edit) Entity Team SMG 1 1 3 2023-10-13 7:00:00 PM 2 Group A BreakyCPK • KheZu Glem 2485244
The International 2023 - Group Stage (edit) Evil Geniuses 9Pandas 1 1 3 2023-10-13 9:00:00 PM 2 Group A Ares • Danog Weppas 2485253
The International 2023 - Group Stage (edit) Evil Geniuses Entity 0 2 2 2023-10-12 5:00:00 PM 2 Group A Lyrical • Trent skrff 2484933
The International 2023 - Group Stage (edit) Evil Geniuses Team SMG 1 1 3 2023-10-12 11:00:00 PM 2 Group A Ares • Danog skrff 2485003
The International 2023 - Group Stage (edit) Evil Geniuses Team SMG 2 0 1 2023-10-13 9:00:00 PM 2 Group A Ares • Danog Weppas 2485269 Yes
The International 2023 - Group Stage (edit) Gaimin Gladiators beastcoast 2 0 1 2023-10-13 9:00:00 PM 2 Group C BreakyCPK • KheZu Glem 2485262
The International 2023 - Group Stage (edit) Gaimin Gladiators Nouns Esports 1 1 3 2023-10-13 1:00:00 AM 2 Group C MLPDotA • johnxfire PTP 2485055
The International 2023 - Group Stage (edit) Gaimin Gladiators Talon 1 2 2 2023-10-15 2:00:00 AM 3 Bkop • Lacoste Weppas 2485546
The International 2023 - Group Stage (edit) Vivo Keyd Stars PSG Quest 1 1 3 2023-10-12 9:00:00 PM 2 Group D MLPDotA • johnxfire 2484993
The International 2023 - Group Stage (edit) Vivo Keyd Stars Talon 0 2 2 2023-10-13 5:00:00 PM 2 Group D Moxxi • Wagamama PTP 2485190
The International 2023 - Group Stage (edit) Vivo Keyd Stars TSM 1 1 3 2023-10-13 7:00:00 PM 2 Group D Moxxi • Wagamama PTP 2485226
The International 2023 - Group Stage (edit) Vivo Keyd Stars Tundra Esports 1 1 3 2023-10-13 11:00:00 PM 2 Group D MLPDotA • johnxfire 2485041
The International 2023 - Group Stage (edit) LGD Gaming beastcoast 2 0 1 2023-10-13 5:00:00 PM 2 Group C Bkop • Lacoste Eosin 2485188
The International 2023 - Group Stage (edit) LGD Gaming Gaimin Gladiators 2 0 1 2023-10-12 5:00:00 PM 2 Group C BreakyCPK • KheZu Eosin 2484935
The International 2023 - Group Stage (edit) LGD Gaming Vivo Keyd Stars 2 0 1 2023-10-15 5:00:00 PM 3 Moxxi • Wagamama Weppas 2485717
The International 2023 - Group Stage (edit) LGD Gaming Nouns Esports 2 0 1 2023-10-12 9:00:00 PM 2 Group C BreakyCPK • KheZu Eosin 2484989
The International 2023 - Group Stage (edit) LGD Gaming Virtus.pro 1 1 3 2023-10-13 7:00:00 PM 2 Group C Bkop • Lacoste Eosin 2485224
The International 2023 - Group Stage (edit) Nouns Esports beastcoast 1 1 3 2023-10-12 7:00:00 PM 2 Group C BreakyCPK • KheZu Eosin 2484960
The International 2023 - Group Stage (edit) Shopify Rebellion Azure Ray 1 1 3 2023-10-13 7:00:00 PM 2 Group B T-Panda • Fear skrff 2485227
The International 2023 - Group Stage (edit) Shopify Rebellion BetBoom Team 0 2 2 2023-10-13 5:00:00 PM 2 Group B T-Panda • Fear skrff 2485189
The International 2023 - Group Stage (edit) Shopify Rebellion Team Liquid 0 2 2 2023-10-13 1:00:00 AM 2 Group B Lyrical • Trent skrff 2485051
The International 2023 - Group Stage (edit) Talon PSG Quest 2 0 1 2023-10-13 9:00:00 PM 2 Group D Moxxi • Wagamama PTP 2485249
The International 2023 - Group Stage (edit) Team Liquid Azure Ray 1 1 3 2023-10-12 7:00:00 PM 2 Group B Lyrical • Trent skrff 2484957
The International 2023 - Group Stage (edit) Team Liquid BetBoom Team 2 0 1 2023-10-12 9:00:00 PM 2 Group B Ares • Danog skrff 2484984
The International 2023 - Group Stage (edit) Team Liquid Evil Geniuses 2 0 1 2023-10-14 11:00:00 PM 3 Bkop • Lacoste Weppas 2485531
The International 2023 - Group Stage (edit) Team Liquid Thunder Awaken 2 0 1 2023-10-13 7:00:00 PM 2 Group B Nomad • TeaGuvnor Weppas 2485230
The International 2023 - Group Stage (edit) Team Spirit 9Pandas 2 0 1 2023-10-12 5:00:00 PM 2 Group A Moxxi • Wagamama Glem 2484936
The International 2023 - Group Stage (edit) Team Spirit Entity 2 0 1 2023-10-12 11:00:00 PM 2 Group A Nomad • TeaGuvnor PTP 2485004
The International 2023 - Group Stage (edit) Team Spirit Evil Geniuses 2 0 1 2023-10-13 5:00:00 PM 2 Group A Nomad • TeaGuvnor Weppas 2485191
The International 2023 - Group Stage (edit) Team Spirit Shopify Rebellion 2 0 1 2023-10-14 5:00:00 PM 3 Nomad • TeaGuvnor Weppas 2485437
The International 2023 - Group Stage (edit) Team Spirit Team SMG 2 0 1 2023-10-12 7:00:00 PM 2 Group A Moxxi • Wagamama Glem 2484965
The International 2023 - Group Stage (edit) Thunder Awaken BetBoom Team 0 2 2 2023-10-12 5:00:00 PM 2 Group B Nomad • TeaGuvnor 2484934
The International 2023 - Group Stage (edit) Thunder Awaken Shopify Rebellion 1 1 3 2023-10-12 7:00:00 PM 2 Group B Nomad • TeaGuvnor PTP 2484967
The International 2023 - Group Stage (edit) TSM PSG Quest 1 1 3 2023-10-14 1:00:00 AM 2 Group D T-Panda • Fear 2485048
The International 2023 - Group Stage (edit) TSM Talon 2 0 1 2023-10-13 11:00:00 PM 2 Group D T-Panda • Fear 2485007
The International 2023 - Group Stage (edit) TSM Tundra Esports 0 2 2 2023-10-12 5:00:00 PM 2 Group D Bkop • Lacoste Weppas 2484932
The International 2023 - Group Stage (edit) TSM Virtus.pro 0 2 2 2023-10-14 8:00:00 PM 3 T-Panda • Fear Weppas 2485514
The International 2023 - Group Stage (edit) Tundra Esports PSG Quest 2 0 1 2023-10-13 5:00:00 PM 2 Group D Lyrical • Trent Glem 2485187
The International 2023 - Group Stage (edit) Tundra Esports Talon 2 0 1 2023-10-12 7:00:00 PM 2 Group D Bkop • Lacoste Weppas 2484961
The International 2023 - Group Stage (edit) Virtus.pro beastcoast 1 1 3 2023-10-12 11:00:00 PM 2 Group C Lyrical • Trent skrff 2485009
The International 2023 - Group Stage (edit) Virtus.pro Gaimin Gladiators 0 2 2 2023-10-12 9:00:00 PM 2 Group C Bkop • Lacoste Weppas 2484991
The International 2023 - Group Stage (edit) Virtus.pro Nouns Esports 1 1 3 2023-10-13 9:00:00 PM 2 Group C MLPDotA • johnxfire Eosin 2485250
The International 2023 - Main Event (edit) 9Pandas Gaimin Gladiators 0 2 2 2023-10-22 2:00:00 AM 3 ODPixel • Fogged Weppas • PTP 2487261 dota2ti dota2
The International 2023 - Main Event (edit) Azure Ray BetBoom Team 2 1 1 2023-10-28 8:00:00 PM 3 Lyrical • Trent • Gunnar Weppas • PTP 2488911 dota2ti dota2
The International 2023 - Main Event (edit) BetBoom Team Virtus.pro 2 0 1 2023-10-27 8:00:00 PM 3 Lyrical • Trent Weppas • PTP 2488697 dota2ti dota2
The International 2023 - Main Event (edit) Evil Geniuses Gaimin Gladiators 0 2 2 2023-10-21 8:00:00 PM 3 Cap • SVG Weppas • PTP 2487231 dota2ti dota2
The International 2023 - Main Event (edit) Gaimin Gladiators Azure Ray 2 0 1 2023-10-29 1:00:00 AM 3 SUNSfan • syndereN Weppas • PTP 2488934 dota2ti dota2
The International 2023 - Main Event (edit) Vivo Keyd Stars BetBoom Team 0 2 2 2023-10-22 5:00:00 PM 3 Lyrical • Trent Weppas • PTP 2487533 dota2ti dota2
The International 2023 - Main Event (edit) LGD Gaming 9Pandas 2 0 1 2023-10-20 11:00:00 PM 3 SUNSfan • syndereN Weppas • PTP 2486944 dota2ti dota2
The International 2023 - Main Event (edit) LGD Gaming Azure Ray 2 0 1 2023-10-28 2:00:00 AM 3 ODPixel • Fogged Weppas • PTP 2488726 dota2ti dota2
The International 2023 - Main Event (edit) LGD Gaming Gaimin Gladiators 0 2 2 2023-10-29 4:00:00 PM 3 ODPixel • Fogged Weppas • PTP 2489065 dota2ti dota2
The International 2023 - Main Event (edit) Nouns Esports Azure Ray 0 2 2 2023-10-21 2:00:00 AM 3 ODPixel • Fogged Weppas • PTP 2486955 dota2ti dota2
The International 2023 - Main Event (edit) Nouns Esports Gaimin Gladiators 0 2 2 2023-10-27 5:00:00 PM 3 Cap • SVG Weppas • PTP 2488677 dota2ti dota2
The International 2023 - Main Event (edit) Nouns Esports TSM 2 0 1 2023-10-21 11:00:00 PM 3 SUNSfan • syndereN Weppas • PTP 2487245 dota2ti dota2
The International 2023 - Main Event (edit) Shopify Rebellion TSM 0 2 2 2023-10-21 5:00:00 PM 3 Lyrical • Trent Weppas • PTP 2487181 dota2ti dota2
The International 2023 - Main Event (edit) Talon BetBoom Team 1 2 2 2023-10-22 11:00:00 PM 3 Lyrical • syndereN Weppas • PTP 2487635 dota2ti dota2
The International 2023 - Main Event (edit) Team Liquid Gaimin Gladiators 1 2 2 2023-10-28 5:00:00 PM 3 Cap • SVG Weppas • PTP 2488873 dota2ti dota2
The International 2023 - Main Event (edit) Team Liquid Talon 2 0 1 2023-10-20 8:00:00 PM 3 Cap • SVG Weppas • PTP 2486924 dota2ti dota2
The International 2023 - Main Event (edit) Team Spirit Gaimin Gladiators 3 0 1 2023-10-29 8:00:00 PM 5 Cap • SVG Weppas • PTP 2489098 dota2ti dota2
The International 2023 - Main Event (edit) Team Spirit LGD Gaming 2 0 1 2023-10-28 11:00:00 PM 3 ODPixel • Fogged Weppas • PTP 2488926 dota2ti dota2
The International 2023 - Main Event (edit) Team Spirit Team Liquid 2 1 1 2023-10-27 11:00:00 PM 3 SUNSfan • syndereN Weppas • PTP 2488714 dota2ti dota2
The International 2023 - Main Event (edit) Team Spirit Virtus.pro 2 1 1 2023-10-20 5:00:00 PM 3 Lyrical • Trent Weppas • PTP 2486868 dota2ti dota2
The International 2023 - Main Event (edit) Tundra Esports Entity 0 2 2 2023-10-22 8:00:00 PM 3 Cap • SVG Weppas • PTP 2487603 dota2ti dota2
The International 2023 - Main Event (edit) Virtus.pro Entity 2 0 1 2023-10-23 2:00:00 AM 3 ODPixel • Fogged Weppas • PTP 2487671 dota2ti dota2