Document

CO2

organization_ID accounting_invoice_profile_ID booking_id booking_item_id status travel_start_date travel_end_date kind linear_distance in km co2_in_kg direction dep_name arr_name origin_country destination_country cost_center_names reference_code creator name passenger name ticket_price travel_class fare_name supplier airline dep_iata arr_iata booked_by_support booked_days_in_advance locality booked_at invoice_profile_name aggregators_name order_number cost_center_allocations_ID reference_code purpose_of_trip
1 1234 40768 54618 confirm_finished 2020-01-14 00:00:00 UTC 2020-01-13 00:00:00 UTC hotel 0 24.74 Berlin Berlin Germany Germany Max Mustermann Michael Lukas 140 5 Sofitel Berlin Kurfurstendamm Sofitel false 4 domestic 2020-01-08 16:40:05 UTC Muster GmbH 21282005
1 1234 40766 54616 confirm_finished 2020-01-14 00:00:00 UTC 2020-01-13 00:00:00 UTC hotel 0 24.74 Berlin Berlin Germany Germany Max Mustermann Stefan Weigert 140 5 Sofitel Berlin Kurfurstendamm Sofitel false 4 domestic 2020-01-08 16:34:50 UTC Muster GmbH 21282003
1 1234 40323 54037 confirm_finished 2020-01-16 00:00:00 UTC 2020-01-15 00:00:00 UTC hotel 0 24.74 Winterthur Winterthur Switzerland Switzerland Max Mustermann Philipp Schmidt 177.51 4 Hotel Banana City Hotel false 7 domestic 2020-01-07 12:46:23 UTC Muster GmbH 21280547
1 1234 40551 54344 confirm_finished 2020-01-17 00:00:00 UTC 2020-01-16 00:00:00 UTC hotel 0 24.74 Dublin 22 Dublin 22 Ireland Ireland Service Admin Lisa Fischer 91.94 3 Kingswood Hotel Citywest Kingswood false 7 domestic 2020-01-08 09:53:34 UTC Muster GmbH 21281371
1 1234 41743 55914 confirm_finished 2020-01-17 00:00:00 UTC 2020-01-16 00:00:00 UTC hotel 0 24.74 Hannover Hannover Germany Germany Erika Musterfrau Nico Weber 121.5 4 Dormero Hotel Hannover Dormero false 1 domestic 2020-01-14 08:25:52 UTC Muster GmbH 21285664
1 1234 49572 66180 confirm_finished 2020-02-19 15:05:00 UTC 2020-02-19 16:15:00 UTC plane 438 81 outward Köln (CGN) München (MUC) Germany Germany Lena Müller Julia Hofmann 354.99 Eco Eco, Smart Flex EW Eurowings CGN MUC false 1 domestic 2020-02-17 13:51:45 UTC Muster GmbH GBLDVP
1 1234 49624 66252 confirm_finished 2020-02-19 21:15:00 UTC 2020-02-19 22:10:00 UTC plane 300 55 inbound Frankfurt am Main (FRA) München (MUC) Germany Germany Max Mustermann Nico Weber 358.67 Eco Eco, Flex LH Lufthansa FRA MUC false 1 domestic 2020-02-17 14:47:19 UTC Muster GmbH Q839XY
1 1234 48631 64946 confirm_finished 2020-02-21 07:50:00 UTC 2020-02-21 08:45:00 UTC plane 260 48 outward München (MUC) Zürich (ZRH) Germany Switzerland Paul Maier Julia Hofmann 474.06 Eco Eco, Flex LH Lufthansa MUC ZRH false 8 europe 2020-02-12 16:55:09 UTC Muster GmbH 4PMJAY
1 1234 48631 64946 confirm_finished 2020-02-21 07:50:00 UTC 2020-02-21 08:45:00 UTC plane 260 48 outward München (MUC) Zürich (ZRH) Germany Switzerland Paul Maier Lisa Fischer 474.06 Eco Eco, Flex LH Lufthansa MUC ZRH false 8 europe 2020-02-12 16:55:09 UTC Muster GmbH 4PMJAY
1 1234 48631 64946 confirm_finished 2020-02-21 07:50:00 UTC 2020-02-21 08:45:00 UTC plane 260 48 outward München (MUC) Zürich (ZRH) Germany Switzerland Paul Maier Christian Wagner 474.06 Eco Eco, Flex LH Lufthansa MUC ZRH false 8 europe 2020-02-12 16:55:09 UTC Muster GmbH 4PMJAY
1 1234 48631 64946 confirm_finished 2020-02-21 07:50:00 UTC 2020-02-21 08:45:00 UTC plane 260 48 outward München (MUC) Zürich (ZRH) Germany Switzerland Paul Maier Viktoria Schulz 474.06 Eco Eco, Flex LH Lufthansa MUC ZRH false 8 europe 2020-02-12 16:55:09 UTC Muster GmbH 4PMJAY
1 1234 50711 67695 confirm_finished 2020-02-21 15:30:00 UTC 2020-02-21 16:25:00 UTC plane 260 48 inbound Zürich (ZRH) München (MUC) Switzerland Germany Erika Musterfrau Julia Hofmann 447.52 LH Lufthansa ZRH MUC true 0 europe 2020-02-21 13:18:16 UTC Muster GmbH QJZUXY
1 1234 50711 67695 confirm_finished 2020-02-21 15:30:00 UTC 2020-02-21 16:25:00 UTC plane 260 48 inbound Zürich (ZRH) München (MUC) Switzerland Germany Erika Musterfrau Lisa Fischer 447.52 LH Lufthansa ZRH MUC true 0 europe 2020-02-21 13:18:16 UTC Muster GmbH QJZUXY
1 1234 50711 67695 confirm_finished 2020-02-21 15:30:00 UTC 2020-02-21 16:25:00 UTC plane 260 48 inbound Zürich (ZRH) München (MUC) Switzerland Germany Erika Musterfrau Christian Wagner 447.52 LH Lufthansa ZRH MUC true 0 europe 2020-02-21 13:18:16 UTC Muster GmbH QJZUXY
1 1234 50515 67441 confirm_finished 2020-02-21 20:15:00 UTC 2020-02-21 21:10:00 UTC plane 260 48 inbound Zürich (ZRH) München (MUC) Switzerland Germany Erika Musterfrau Viktoria Schulz 2 LH Lufthansa ZRH MUC true 1 europe 2020-02-20 16:56:37 UTC Muster GmbH Q43KWY
1 1234 48816 65197 confirm_finished 2020-02-25 06:50:00 UTC 2020-02-25 08:25:00 UTC plane 682 156 outward München-Flughafen, Deutschland Paris Charles de Gaulle Airport (CDG), Roissy-en-France, Frankreich Germany Poland Paul Maier Marc Hoffmann 621.84 LH Lufthansa MUC CDG true 11 europe 2020-02-13 11:59:14 UTC Muster GmbH Q2WRXY
1 1234 48816 65197 confirm_finished 2020-02-25 06:50:00 UTC 2020-02-25 08:25:00 UTC plane 682 156 outward München-Flughafen, Deutschland Paris Charles de Gaulle Airport (CDG), Roissy-en-France, Frankreich Germany Poland Paul Maier Lisa Fischer 621.84 LH Lufthansa MUC CDG true 11 europe 2020-02-13 11:59:14 UTC Muster GmbH Q2WRXY
1 1234 48816 65197 confirm_finished 2020-02-25 06:50:00 UTC 2020-02-25 08:25:00 UTC plane 682 156 outward München-Flughafen, Deutschland Paris Charles de Gaulle Airport (CDG), Roissy-en-France, Frankreich Germany Poland Paul Maier Christian Wagner 621.84 LH Lufthansa MUC CDG true 11 europe 2020-02-13 11:59:14 UTC Muster GmbH Q2WRXY
1 1234 41248 55280 confirm_finished 2020-01-20 08:00:00 UTC 2020-01-20 18:00:00 UTC rental 264 55 Berlin Tegel Airport Berlin Tegel Airport Germany Germany Erika Musterfrau Philipp Schmidt 93.47 CCMR MINI 3-Türer or similar Sixt false 9 domestic 2020-01-10 14:06:31 UTC Muster GmbH 9897058066
1 1234 41315 55362 confirm_finished 2020-02-04 15:00:00 UTC 2020-02-07 20:00:00 UTC rental 145 30 Wurzburg Central Station Wurzburg Central Station Germany Germany Erika Musterfrau Philipp Schmidt 300.54 ECMR VW Polo or similar Sixt false 24 domestic 2020-01-10 16:09:57 UTC Muster GmbH 9897063723
1 1234 45227 60508 confirm_finished 2020-02-10 07:00:00 UTC 2020-02-11 19:00:00 UTC rental 244 51 Munich Laim Train Station Munich Laim Train Station Germany Germany Paul Maier Lukas Becker 207.73 IWMR VW Passat Variant or similar Sixt false 11 domestic 2020-01-29 09:58:05 UTC Muster GmbH 9897850426
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...

CarbonFootprint_Parameter

CO2 Emissions: Methodology & Bibliography by Squake
Aggregator Methodology
(rental) Car ACRISS
Bus Squake
Hotel HCMI
Accommodation (Airbnb) Squake
Plane TIM
Train Squake

Zusammenfassung

Kind co2_in_kg linear_distance
Train 231 5654
Hotel 123.69999999999999 0
Plane 988 4864
Fernbus 0 0
Rental 427 2050
Gesamt: 1769.7 12568