View table: AllMatches

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 74 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 Azure Ray 0 2 2 2023-10-16 2:00:00 AM 3 Lyrical Trent Weppas 2485802
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 Nouns Esports 0 2 2 2023-10-15 11:00:00 PM 3 MLPDotA johnxfire Weppas 2485790
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