3 ms·

Histogram of JiaT75's GitHub activity by time of day

4 points by croemer 3y ago

croemer 3y ago
These are the times (in UTC) at which JiaT75 interacted with the Github API. JiaT75 is the Github user behind the xz backdoor. These timestamps are more reliable than Git timestamps as they cannot be tampered with, they are recorded server side by Github. Time count -----|----- 03:00 1 09:00 3 10:00 15 11:00 29 12:00 293 13:00 298 14:00 217 15:00 200 16:00 188 17:00 79 18:00 18 20:00 4 You can read more about Clickhouse and the Github activity dump here: https://til.simonwillison.net/clickhouse/github-explorer https://til.simonwillison.net/clickhouse/github-explorer
- bediger4000 3y ago
  So what am I to make of this? If JiaT75 works 8 to 5pm local, they're in -0500 timezone, or Eastern Standard Time. Conveniently, Fort George G. Meade is in EST.
  - croemer 3y ago
    The range of times is quite narrow, most activity between 12-16 UTC. That would make it 7am-11am EST, working only mornings?
    - bediger4000 3y ago
      That's a good point, stand ups are almost always in the morning.
- dhx 3y ago
  For both JiaT75 and hansjans162 combined, the days of weeks they were active is the following (per a selection of timezones): tz mon tue wed thu fri sat sun AE_Asia/Dubai 166 232 266 275 273 107 7 AL_Europe/Tirane 167 238 261 275 273 105 7 AR_America/Argentina/Buenos_Aires 167 238 261 275 273 105 7 AT_Europe/Vienna 167 238 261 275 273 105 7 AU_Australia/Perth 121 233 246 245 322 139 20 AU_Australia/Sydney 50 212 196 286 312 200 70 BA_Europe/Belgrade 167 238 261 275 273 105 7 CA_America/Toronto 167 238 261 275 273 106 6 CA_America/Vancouver 167 238 261 275 273 106 6 CH_Europe/Zurich 167 238 261 275 273 105 7 CL_America/Santiago 167 238 261 275 273 105 7 CN_Asia/Shanghai 121 233 246 245 322 139 20 DE_Europe/Berlin 167 238 261 275 273 105 7 DK_Europe/Berlin 167 238 261 275 273 105 7 EE_Europe/Tallinn 167 238 260 276 273 105 7 EG_Africa/Cairo 167 238 260 276 273 105 7 ES_Europe/Madrid 167 238 261 275 273 105 7 FI_Europe/Helsinki 167 238 260 276 273 105 7 FR_Europe/Paris 167 238 261 275 273 105 7 GB_Europe/London 167 238 261 275 273 105 7 GR_Europe/Athens 167 238 260 276 273 105 7 HR_Europe/Belgrade 167 238 261 275 273 105 7 HU_Europe/Budapest 167 238 261 275 273 105 7 ID_Asia/Jakarta 150 237 243 280 278 129 9 IE_Europe/Dublin 167 238 261 275 273 105 7 IL_Asia/Jerusalem 167 238 260 276 273 105 7 IN_Asia/Kolkata 165 232 263 276 269 114 7 IR_Asia/Tehran 166 236 263 274 273 107 7 IS_Africa/Abidjan 167 238 261 275 273 105 7 IT_Europe/Rome 167 238 261 275 273 105 7 JP_Asia/Tokyo 95 230 231 258 304 176 32 KH_Asia/Bangkok 150 237 243 280 278 129 9 KR_Asia/Seoul 95 230 231 258 304 176 32 LA_Asia/Bangkok 150 237 243 280 278 129 9 LT_Europe/Vilnius 167 238 260 276 273 105 7 LV_Europe/Riga 167 238 260 276 273 105 7 MY_Asia/Singapore 121 233 246 245 322 139 20 NL_Europe/Brussels 167 238 261 275 273 105 7 NO_Europe/Berlin 167 238 261 275 273 105 7 NZ_Pacific/Auckland 6 169 236 264 283 278 90 RS_Europe/Belgrade 167 238 261 275 273 105 7 RU_Asia/Vladivostok 67 227 217 260 309 203 43 RU_Europe/Moscow 166 239 260 274 275 105 7 SA_Asia/Riyadh 166 239 260 274 275 105 7 SE_Europe/Berlin 167 238 261 275 273 105 7 SG_Asia/Singapore 121 233 246 245 322 139 20 SI_Europe/Belgrade 167 238 261 275 273 105 7 TH_Asia/Bangkok 150 237 243 280 278 129 9 TR_Europe/Istanbul 166 239 260 274 275 105 7 TW_Asia/Taipei 121 233 246 245 322 139 20 US_Pacific/Guam 67 227 217 260 309 203 43 US_Pacific/Honolulu 167 238 261 275 276 103 6 US_US/Central 167 238 261 275 273 106 6 US_US/Eastern 167 238 261 275 273 106 6 US_US/Mountain 167 238 261 275 273 106 6 US_US/Pacific 167 238 261 275 273 106 6 VN_Asia/Ho_Chi_Minh 150 237 243 280 278 129 9 ZA_Africa/Johannesburg 167 238 260 276 273 105 7
  - 3y ago
croemer 3y ago
Here's hansjans162's Github activity: https://play.clickhouse.com/play?user=play#U0VMRUNUCiAgY3JlYXRlZF9hdCwKICBhY3Rvcl9sb2dpbiwKICByZXBvX25hbWUsCiAgZXZlbnRfdHlwZSwKICB0aXRsZQpGUk9NCiAgZ2l0aHViX2V2ZW50cwpXSEVSRQogIGFjdG9yX2xvZ2luID0gJ2hhbnNqYW5zMTYyJwpPUkRFUiBCWQogIGNyZWF0ZWRfYXQgREVTQwo= https://play.clickhouse.com/play?user=play#U0VMRUNUCiAgY3JlY... Here as histogram: https://play.clickhouse.com/play?user=play#U0VMRUNUCiBmb3JtYXREYXRlVGltZSh0b1N0YXJ0T2ZIb3VyKGNyZWF0ZWRfYXQpLCAnJUg6JWknKSBBUyBob3VyX3N0YXJ0LAogYWN0b3JfbG9naW4sCiBDT1VOVCgqKSBBUyBldmVudF9jb3VudApGUk9NCiBnaXRodWJfZXZlbnRzCldIRVJFCiBhY3Rvcl9sb2dpbiA9ICdoYW5zamFuczE2MicKR1JPVVAgQlkKIGhvdXJfc3RhcnQsCiBhY3Rvcl9sb2dpbgpPUkRFUiBCWQogaG91cl9zdGFydCBBU0M= https://play.clickhouse.com/play?user=play#U0VMRUNUCiBmb3JtY... It's noticeably different, shifted a few hours.

4 points by croemer 3y ago

These are the times (in UTC) at which JiaT75 interacted with the Github API. JiaT75 is the Github user behind the xz backdoor. These timestamps are more reliable than Git timestamps as they cannot be tampered with, they are recorded server side by Github. Time count -----|----- 03:00 1 09:00 3 10:00 15 11:00 29 12:00 293 13:00 298 14:00 217 15:00 200 16:00 188 17:00 79 18:00 18 20:00 4 You can read more about Clickhouse and the Github activity dump here: https://til.simonwillison.net/clickhouse/github-explorer https://til.simonwillison.net/clickhouse/github-explorer

bediger4000 3y ago
So what am I to make of this? If JiaT75 works 8 to 5pm local, they're in -0500 timezone, or Eastern Standard Time. Conveniently, Fort George G. Meade is in EST.
- croemer 3y ago
  The range of times is quite narrow, most activity between 12-16 UTC. That would make it 7am-11am EST, working only mornings?
  - bediger4000 3y ago
    That's a good point, stand ups are almost always in the morning.
dhx 3y ago
For both JiaT75 and hansjans162 combined, the days of weeks they were active is the following (per a selection of timezones): tz mon tue wed thu fri sat sun AE_Asia/Dubai 166 232 266 275 273 107 7 AL_Europe/Tirane 167 238 261 275 273 105 7 AR_America/Argentina/Buenos_Aires 167 238 261 275 273 105 7 AT_Europe/Vienna 167 238 261 275 273 105 7 AU_Australia/Perth 121 233 246 245 322 139 20 AU_Australia/Sydney 50 212 196 286 312 200 70 BA_Europe/Belgrade 167 238 261 275 273 105 7 CA_America/Toronto 167 238 261 275 273 106 6 CA_America/Vancouver 167 238 261 275 273 106 6 CH_Europe/Zurich 167 238 261 275 273 105 7 CL_America/Santiago 167 238 261 275 273 105 7 CN_Asia/Shanghai 121 233 246 245 322 139 20 DE_Europe/Berlin 167 238 261 275 273 105 7 DK_Europe/Berlin 167 238 261 275 273 105 7 EE_Europe/Tallinn 167 238 260 276 273 105 7 EG_Africa/Cairo 167 238 260 276 273 105 7 ES_Europe/Madrid 167 238 261 275 273 105 7 FI_Europe/Helsinki 167 238 260 276 273 105 7 FR_Europe/Paris 167 238 261 275 273 105 7 GB_Europe/London 167 238 261 275 273 105 7 GR_Europe/Athens 167 238 260 276 273 105 7 HR_Europe/Belgrade 167 238 261 275 273 105 7 HU_Europe/Budapest 167 238 261 275 273 105 7 ID_Asia/Jakarta 150 237 243 280 278 129 9 IE_Europe/Dublin 167 238 261 275 273 105 7 IL_Asia/Jerusalem 167 238 260 276 273 105 7 IN_Asia/Kolkata 165 232 263 276 269 114 7 IR_Asia/Tehran 166 236 263 274 273 107 7 IS_Africa/Abidjan 167 238 261 275 273 105 7 IT_Europe/Rome 167 238 261 275 273 105 7 JP_Asia/Tokyo 95 230 231 258 304 176 32 KH_Asia/Bangkok 150 237 243 280 278 129 9 KR_Asia/Seoul 95 230 231 258 304 176 32 LA_Asia/Bangkok 150 237 243 280 278 129 9 LT_Europe/Vilnius 167 238 260 276 273 105 7 LV_Europe/Riga 167 238 260 276 273 105 7 MY_Asia/Singapore 121 233 246 245 322 139 20 NL_Europe/Brussels 167 238 261 275 273 105 7 NO_Europe/Berlin 167 238 261 275 273 105 7 NZ_Pacific/Auckland 6 169 236 264 283 278 90 RS_Europe/Belgrade 167 238 261 275 273 105 7 RU_Asia/Vladivostok 67 227 217 260 309 203 43 RU_Europe/Moscow 166 239 260 274 275 105 7 SA_Asia/Riyadh 166 239 260 274 275 105 7 SE_Europe/Berlin 167 238 261 275 273 105 7 SG_Asia/Singapore 121 233 246 245 322 139 20 SI_Europe/Belgrade 167 238 261 275 273 105 7 TH_Asia/Bangkok 150 237 243 280 278 129 9 TR_Europe/Istanbul 166 239 260 274 275 105 7 TW_Asia/Taipei 121 233 246 245 322 139 20 US_Pacific/Guam 67 227 217 260 309 203 43 US_Pacific/Honolulu 167 238 261 275 276 103 6 US_US/Central 167 238 261 275 273 106 6 US_US/Eastern 167 238 261 275 273 106 6 US_US/Mountain 167 238 261 275 273 106 6 US_US/Pacific 167 238 261 275 273 106 6 VN_Asia/Ho_Chi_Minh 150 237 243 280 278 129 9 ZA_Africa/Johannesburg 167 238 260 276 273 105 7
- 3y ago

croemer 3y ago

Here's hansjans162's Github activity: https://play.clickhouse.com/play?user=play#U0VMRUNUCiAgY3JlYXRlZF9hdCwKICBhY3Rvcl9sb2dpbiwKICByZXBvX25hbWUsCiAgZXZlbnRfdHlwZSwKICB0aXRsZQpGUk9NCiAgZ2l0aHViX2V2ZW50cwpXSEVSRQogIGFjdG9yX2xvZ2luID0gJ2hhbnNqYW5zMTYyJwpPUkRFUiBCWQogIGNyZWF0ZWRfYXQgREVTQwo= https://play.clickhouse.com/play?user=play#U0VMRUNUCiAgY3JlY... Here as histogram: https://play.clickhouse.com/play?user=play#U0VMRUNUCiBmb3JtYXREYXRlVGltZSh0b1N0YXJ0T2ZIb3VyKGNyZWF0ZWRfYXQpLCAnJUg6JWknKSBBUyBob3VyX3N0YXJ0LAogYWN0b3JfbG9naW4sCiBDT1VOVCgqKSBBUyBldmVudF9jb3VudApGUk9NCiBnaXRodWJfZXZlbnRzCldIRVJFCiBhY3Rvcl9sb2dpbiA9ICdoYW5zamFuczE2MicKR1JPVVAgQlkKIGhvdXJfc3RhcnQsCiBhY3Rvcl9sb2dpbgpPUkRFUiBCWQogaG91cl9zdGFydCBBU0M= https://play.clickhouse.com/play?user=play#U0VMRUNUCiBmb3JtY... It's noticeably different, shifted a few hours.