Skip to content

Instantly share code, notes, and snippets.

View derhuerst's full-sized avatar

Jannis R derhuerst

723 followers · 93 following
View GitHub Profile
@derhuerst
derhuerst / _.md
Created February 16, 2024 10:46
ICE 645 from Essen Hbf to Berlin Spandau

For a long time, there were <6 minutes of delay. In Berlin-Spandau, a delay happened because of a medical emergency.

@derhuerst
derhuerst / ice-572-2023-11-02T19:41:02+01:00-hafas.json
Last active November 4, 2023 01:18
ICE 572 from Mannheim Hbf to Berlin Hbf
{"public":true,"mode":"train","line":{"type":"line","id":"ice-572","name":"ICE 572"},"traveledDistance":166334,"distanceToPreviousStop":4124,"totalDistance":597863,"next":{"type":"station","id":"8010101","name":"Erfurt Hbf","location":{"type":"location","latitude":50.972551,"longitude":11.038499}},"scheduledNext":{"type":"station","id":"8010101","name":"Erfurt Hbf","location":{"type":"location","latitude":50.972551,"longitude":11.038499}},"previous":{"type":"station","id":"8000105","name":"Frankfurt(Main)Hbf","location":{"type":"location","latitude":50.107145,"longitude":8.663789}},"last":{"type":"station","id":"8098160","name":"Berlin Hbf (tief)","location":{"type":"location","latitude":52.525592,"longitude":13.369545}},"passed":[{"station":{"type":"station","id":"8000096","name":"Stuttgart Hbf","location":{"type":"location","latitude":48.784084,"longitude":9.181635}},"arrival":null,"arrivalDelay":null,"arrivalPlatform":"9","departure":"2023-11-02T17:24:39+01:00","departureDelay":99,"departurePlatform":"9","
@derhuerst
derhuerst / _.md
Created November 2, 2023 17:19
ICE 104 from Karlsruhe Hbf to Mannheim Hbf

We left with a delay of 6 minutes, and arrived with a delay of 9 minutes.

@derhuerst
derhuerst / _.md
Created November 2, 2023 16:04
TGV 9575 from Paris Est to Karlsruhe Hbf

There was no delay until Strasbourg; From there till Karlsruhe, there was a delay of 5-10 minutes.

@derhuerst
derhuerst / _.md
Created November 2, 2023 16:00
TGV Ouigo (OGV) 7652 from Bordeaux to Paris Montparnasse

there was no delay

@derhuerst
derhuerst / _.md
Created September 19, 2023 10:08
EC 171 from Berlin Hbf to Praha hl.n.

The was no delay.

@derhuerst
derhuerst / 01-tripsearch.http
Created September 3, 2023 11:22
DB Navigator v23.08.01 on iOS: HTTP requests
POST /bin/mgate.exe?checksum=91746988ad3df7292ecb95c35eb65875 HTTP/1.1
Host: reiseauskunft.bahn.de
Content-Type: application/json
Accept-Encoding: gzip, deflate, br
Cookie: AWSALB=UwdJtOV5ejYzrkWNGhXoqr9bBtrjNg4laLKECYpK4EqNrhbqCS2TQ1Ep/4phJrpoYim+m4EZBhcRyLr3GJdwTvAtH6iaTd1ifIK35Zyl22TEledn3mlBvZL5nfPE; AWSALBCORS=UwdJtOV5ejYzrkWNGhXoqr9bBtrjNg4laLKECYpK4EqNrhbqCS2TQ1Ep/4phJrpoYim+m4EZBhcRyLr3GJdwTvAtH6iaTd1ifIK35Zyl22TEledn3mlBvZL5nfPE; utag_main=v_id:0188b53b978a1219ed98086fb4d81506d003706500432$_sn:20$_se:3$_ss:0$_st:1693740651409$ses_id:1693738846547%3Bexp-session$_pn:1%3Bexp-session; request_consent_v=3; s_vi=[CS]v1|0B4B7D97B8374B8C-2FFCABEBD7E2A777[CE]; AMCV_5FA50A5953FB37E50A4C98BC%40AdobeOrg=-408604571%7CMCAID%7C0B4B7D97B8374B8C-2FFCABEBD7E2A887%7CMCIDTS%7C19537%7CMCMID%7C17007382676835350149043660885083312138%7CvVersion%7C4.6.0; optimizelyEndUserId=0A9887D8-3427-4557-862B-3697EC8CA833
Connection: keep-alive
Accept: */*
User-Agent: DB Navigator/23.08.01 (iPhone; iOS 16.6; Scale/2.00)
Accept-Language:
@derhuerst
derhuerst / from-hafas-1.json
Created July 26, 2023 22:30
ICE 500 from Bamberg to Berlin Hbf
{
"trip": {
"origin": {
"type": "stop",
"id": "8000261",
"name": "München Hbf",
"location": {
"type": "location",
"id": "8000261",
"latitude": 48.140364,
@derhuerst
derhuerst / ice-2923.ndjson
Created July 23, 2023 22:49
ICE 2923 from Büchen to Berlin Hbf
{"serviceLevel":"AVAILABLE_SERVICE","internet":"HIGH","latitude":53.451945333333335,"longitude":10.6620965,"tileY":383,"tileX":75,"series":"412","serverTime":1690102052404,"speed":149,"trainType":"ICE","tzn":"ICE9483","wagonClass":"FIRST","connectivity":{"currentState":"NO_INFO","nextState":null,"remainingTimeSeconds":null},"bapInstalled":true,"ok":true,"gpsOk":true,"clientTime":1690102052274}
{"serviceLevel":"AVAILABLE_SERVICE","internet":"HIGH","latitude":53.45029683333333,"longitude":10.664028833333333,"tileY":383,"tileX":75,"series":"412","serverTime":1690102057366,"speed":152,"trainType":"ICE","tzn":"ICE9483","wagonClass":"FIRST","connectivity":{"currentState":"NO_INFO","nextState":null,"remainingTimeSeconds":null},"bapInstalled":true,"ok":true,"gpsOk":true,"clientTime":1690102057275}
{"serviceLevel":"AVAILABLE_SERVICE","internet":"HIGH","latitude":53.448666833333334,"longitude":10.665933,"tileY":383,"tileX":76,"series":"412","serverTime":1690102062360,"speed":156,"trainType":"ICE","tzn":"ICE9483","wagon
@derhuerst
derhuerst / _.md
Created July 11, 2023 15:43
convert results of multiple pgbench invocations to CSV
  • slightly opinionated (column selection)
  • could be made more configurable, e.g. (let $BENCHMARK_TIME_SECONDS pick up from env var)
  • uses Miller (mlr)
  • uses qsv, a fork of xsv