Subway Surfers
It includes both gamewide category leaderboards and level-specific category lead
@kaggle.willianoliveiragibin_subway_surfers
Subsurf New
@kaggle.willianoliveiragibin_subway_surfers.subsurf_new
- 212.92 KB
- 2827 rows
- 24 columns
run_idRun Id | player_idPlayer Id | placePlace | speedrun_timeSpeedrun Time | is_verifiedIs Verified | verify_dateVerify Date | submitted_dateSubmitted Date | examiner_idExaminer Id | timing_typeTiming Type | platform_idPlatform Id | platform_namePlatform Name | platform_released_yearPlatform Released Year | is_level_catIs Level Cat | level_idLevel Id | level_nameLevel Name | level_rulesLevel Rules | game_idGame Id | category_idCategory Id | cat_nameCat Name | cat_rulesCat Rules | player_namePlayer Name | player_countryPlayer Country | player_pronounsPlayer Pronouns | player_signup_datePlayer Signup Date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| y6qr8wjz | j9pw2o7x | 1 | 13.6 | true | Fri Oct 13 2023 12:48:34 GMT+0000 (Coordinated Universal Time) | Fri Oct 13 2023 09:38:52 GMT+0000 (Coordinated Universal Time) | pj0o1g4j | realtime | lq60nl94 | Android | 2008 | subsurf | zd3l938d | Coins | ###### **Coin Rules:** * **Collect the required amount of coins** as fast as possible. * **Time begins** upon the first frame of "Tap to Play" disappearing; or, the first frame of the "Play Again" screen fading. **Time ends** upon the first visible frame of the desired coin amount being achieved. … | qianxun | cn | nan | Sat Jun 17 2023 12:14:18 GMT+0000 (Coordinated Universal Time) | ||||
| z1k2qw7y | jok401e8 | 2 | 13.967 | true | Sat Nov 11 2023 01:38:07 GMT+0000 (Coordinated Universal Time) | Fri Nov 10 2023 22:57:38 GMT+0000 (Coordinated Universal Time) | 48g7zm18 | realtime | o7e25xew | Web | 10000 | subsurf | zd3l938d | Coins | ###### **Coin Rules:** * **Collect the required amount of coins** as fast as possible. * **Time begins** upon the first frame of "Tap to Play" disappearing; or, the first frame of the "Play Again" screen fading. **Time ends** upon the first visible frame of the desired coin amount being achieved. … | DongDing | es | nan | Sat Jul 08 2023 00:21:47 GMT+0000 (Coordinated Universal Time) | ||||
| ywn47e9y | j060qn3j | 3 | 14.267 | true | Sat Sep 30 2023 14:29:08 GMT+0000 (Coordinated Universal Time) | Sat Sep 30 2023 12:07:02 GMT+0000 (Coordinated Universal Time) | 48g7zm18 | realtime | lq60nl94 | Android | 2008 | subsurf | zd3l938d | Coins | ###### **Coin Rules:** * **Collect the required amount of coins** as fast as possible. * **Time begins** upon the first frame of "Tap to Play" disappearing; or, the first frame of the "Play Again" screen fading. **Time ends** upon the first visible frame of the desired coin amount being achieved. … | LiYueee | cn | She/Her | Tue May 16 2023 04:28:21 GMT+0000 (Coordinated Universal Time) | ||||
| z1qn08jy | jmzp11zx | 4 | 14.3 | true | Sun Mar 19 2023 14:39:00 GMT+0000 (Coordinated Universal Time) | Thu Mar 09 2023 14:20:27 GMT+0000 (Coordinated Universal Time) | pj0o1g4j | realtime | lq60nl94 | Android | 2008 | subsurf | zd3l938d | Coins | ###### **Coin Rules:** * **Collect the required amount of coins** as fast as possible. * **Time begins** upon the first frame of "Tap to Play" disappearing; or, the first frame of the "Play Again" screen fading. **Time ends** upon the first visible frame of the desired coin amount being achieved. … | Mustafa_gundogan | tr | nan | Sun Aug 28 2022 20:57:34 GMT+0000 (Coordinated Universal Time) | ||||
| zqeln48z | x7w645v8 | 5 | 14.367 | true | Sat Apr 15 2023 20:31:48 GMT+0000 (Coordinated Universal Time) | Sat Apr 15 2023 15:19:52 GMT+0000 (Coordinated Universal Time) | pj0o1g4j | realtime | lq60nl94 | Android | 2008 | subsurf | zd3l938d | Coins | ###### **Coin Rules:** * **Collect the required amount of coins** as fast as possible. * **Time begins** upon the first frame of "Tap to Play" disappearing; or, the first frame of the "Play Again" screen fading. **Time ends** upon the first visible frame of the desired coin amount being achieved. … | Omerfatih | tr | He/Him | Sun May 15 2022 13:14:08 GMT+0000 (Coordinated Universal Time) | ||||
| zx7kg68y | 8w9y69qj | 6 | 14.533 | true | Sun May 08 2022 15:28:52 GMT+0000 (Coordinated Universal Time) | Fri Apr 22 2022 04:33:11 GMT+0000 (Coordinated Universal Time) | 1xyy9oyx | realtime | lq60nl94 | Android | 2008 | subsurf | zd3l938d | Coins | ###### **Coin Rules:** * **Collect the required amount of coins** as fast as possible. * **Time begins** upon the first frame of "Tap to Play" disappearing; or, the first frame of the "Play Again" screen fading. **Time ends** upon the first visible frame of the desired coin amount being achieved. … | L0rdN4tsu_ | br | He/Him | Fri Mar 11 2022 02:41:48 GMT+0000 (Coordinated Universal Time) | ||||
| zpdnlw8z | j4vo1gwj | 7 | 14.542 | true | Sat Aug 06 2022 20:35:04 GMT+0000 (Coordinated Universal Time) | Fri Jul 29 2022 18:02:39 GMT+0000 (Coordinated Universal Time) | kj9p77x4 | realtime | lq60nl94 | Android | 2008 | subsurf | zd3l938d | Coins | ###### **Coin Rules:** * **Collect the required amount of coins** as fast as possible. * **Time begins** upon the first frame of "Tap to Play" disappearing; or, the first frame of the "Play Again" screen fading. **Time ends** upon the first visible frame of the desired coin amount being achieved. … | zer0o | br | He/Him | Wed Jun 22 2022 18:14:18 GMT+0000 (Coordinated Universal Time) | ||||
| z1pg779z | jmlnyyo8 | 8 | 14.567 | true | Sun Jun 05 2022 23:50:08 GMT+0000 (Coordinated Universal Time) | Sun Jun 05 2022 22:52:06 GMT+0000 (Coordinated Universal Time) | jpo3rvk8 | realtime | lq60nl94 | Android | 2008 | subsurf | zd3l938d | Coins | ###### **Coin Rules:** * **Collect the required amount of coins** as fast as possible. * **Time begins** upon the first frame of "Tap to Play" disappearing; or, the first frame of the "Play Again" screen fading. **Time ends** upon the first visible frame of the desired coin amount being achieved. … | Qeze | br | He/Him | Mon Jan 31 2022 21:13:49 GMT+0000 (Coordinated Universal Time) | ||||
| z0lj0v9z | xk1o7e7j | 8 | 14.567 | true | Sat Sep 24 2022 08:23:40 GMT+0000 (Coordinated Universal Time) | Fri Sep 23 2022 18:18:06 GMT+0000 (Coordinated Universal Time) | 8r72pyqj | realtime | lq60nl94 | Android | 2008 | subsurf | zd3l938d | Coins | ###### **Coin Rules:** * **Collect the required amount of coins** as fast as possible. * **Time begins** upon the first frame of "Tap to Play" disappearing; or, the first frame of the "Play Again" screen fading. **Time ends** upon the first visible frame of the desired coin amount being achieved. … | DouglasMdM | nan | nan | Sun Aug 21 2022 15:33:41 GMT+0000 (Coordinated Universal Time) | ||||
| y6xlxe1y | xymgz9yx | 10 | 14.617 | true | Wed Aug 10 2022 21:28:14 GMT+0000 (Coordinated Universal Time) | Wed Aug 10 2022 01:17:03 GMT+0000 (Coordinated Universal Time) | kj9p77x4 | realtime | lq60nl94 | Android | 2008 | subsurf | zd3l938d | Coins | ###### **Coin Rules:** * **Collect the required amount of coins** as fast as possible. * **Time begins** upon the first frame of "Tap to Play" disappearing; or, the first frame of the "Play Again" screen fading. **Time ends** upon the first visible frame of the desired coin amount being achieved. … | tiagoromine | br | He/Him | Wed Jul 06 2022 20:06:24 GMT+0000 (Coordinated Universal Time) |
CREATE TABLE subsurf_new (
"run_id" VARCHAR,
"player_id" VARCHAR,
"place" BIGINT,
"speedrun_time" VARCHAR,
"is_verified" BOOLEAN,
"verify_date" TIMESTAMP,
"submitted_date" TIMESTAMP,
"examiner_id" VARCHAR,
"timing_type" VARCHAR,
"platform_id" VARCHAR,
"platform_name" VARCHAR,
"platform_released_year" BIGINT,
"is_level_cat" BOOLEAN,
"level_id" VARCHAR,
"level_name" VARCHAR,
"level_rules" VARCHAR,
"game_id" VARCHAR,
"category_id" VARCHAR,
"cat_name" VARCHAR,
"cat_rules" VARCHAR,
"player_name" VARCHAR,
"player_country" VARCHAR,
"player_pronouns" VARCHAR,
"player_signup_date" TIMESTAMP
);