## 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 Berlin Kurfurstendamm | | | 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 Berlin Kurfurstendamm | | | 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 Banana City | | | 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 Hotel Citywest | | | 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 Hotel Hannover | | | 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 | 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 | 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 | | | | | 1 | 1234 | 46521 | 62194 | confirm_finished | 2020-02-17 09:00:00 UTC | 2020-02-17 16:00:00 UTC | rental | 113 | 23 | | Mulhouse Basel Airport | Mulhouse Basel Airport | France | France | | | Erika Musterfrau | Lukas Becker | 130.97 | CPMR | BMW Série 1 or similar | Sixt | | | | false | 12 | domestic | 2020-02-04 10:21:08 UTC | Muster GmbH | | 9898069026 | | | | | 1 | 1234 | 47411 | 63346 | confirm_finished | 2020-02-19 09:00:00 UTC | 2020-02-19 14:00:00 UTC | rental | 141 | 29 | | Paderborn-Lippstadt Airport | Dortmund Airport | Germany | Germany | | | Paul Maier | Lukas Becker | 103.86 | IWMR | VW Passat Variant or similar | Sixt | | | | false | 11 | domestic | 2020-02-07 09:42:43 UTC | Muster GmbH | | 9898193863 | | | | | 1 | 1234 | 49550 | 66151 | confirm_finished | 2020-03-01 20:00:00 UTC | 2020-03-02 20:00:00 UTC | rental | 195 | 41 | | Chicago O'Hare Airport | Chicago O'Hare Airport | United States | United States | | | Paul Maier | Marc Hoffmann | 100.64 | IFAR | Chevrolet Equinox or similar | Sixt | | | | false | 13 | domestic | 2020-02-17 13:13:31 UTC | Muster GmbH | | 9898562615 | | | | | 1 | 1234 | 58081 | 76404 | confirm_finished | 2020-06-08 08:00:00 UTC | 2020-06-08 20:00:00 UTC | rental | 129 | 27 | | Frankfurt Airport | Frankfurt Airport | Germany | Germany | | | Erika Musterfrau | Philipp Schmidt | 80.1 | ECMR | VW Polo or similar | Sixt | | | | false | 10 | domestic | 2020-05-28 10:37:49 UTC | Muster GmbH | | 9900261855 | | | | | 1 | 1234 | 67731 | 88212 | confirm_finished | 2020-09-01 10:00:00 UTC | 2020-09-01 19:00:00 UTC | rental | 168 | 35 | outward | Düsseldorf Airport (DUS), Flughafenstraße, Düsseldorf, Deutschland | Düsseldorf Airport (DUS), Flughafenstraße, Düsseldorf, Deutschland | Germany | Germany | | | Fritz Schneider | Simone Koch | 103.76 | | | SIXT | | | | true | 3 | domestic | 2020-08-28 11:25:45 UTC | Muster GmbH | | 9902183322 | | | | | 1 | 1234 | 71185 | 92497 | confirm_finished | 2020-09-29 12:00:00 UTC | 2020-10-01 13:00:00 UTC | rental | 234 | 49 | | Krakow Airport | Krakow Airport | Poland | Poland | | | Lukas Schröder | Gregor Richter | 154.84 | CLAR | VW Golf Aut. or similar | Sixt | | | | false | 7 | domestic | 2020-09-21 14:37:54 UTC | Muster GmbH | | 9902766413 | | | | | 1 | 1234 | 76179 | 98609 | confirm_finished | 2020-10-28 08:00:00 UTC | 2020-10-28 17:00:00 UTC | rental | 216 | 45 | | Munster/Osnabruck Airport | Dusseldorf Airport | Germany | Germany | | | Lena Müller | Christian Wagner | 247.33 | LDAR | Audi A6 45/50 Aut. or similar | Sixt | | | | false | 1 | domestic | 2020-10-26 14:04:07 UTC | Muster GmbH | | 9905746804 | | | | | 1 | 1234 | 76297 | 98751 | confirm_finished | 2020-11-05 10:00:00 UTC | 2020-11-05 17:00:00 UTC | rental | 201 | 42 | | Dusseldorf Airport | Dusseldorf Airport | Germany | Germany | | | Erika Musterfrau | Marc Hoffmann | 80.09 | CDMR | Seat Leon or similar | Sixt | | | | false | 8 | domestic | 2020-10-27 13:13:40 UTC | Muster GmbH | | 9905765533 | | | | | 1 | 1234 | 42357 | 56746 | confirm_finished | 2020-01-16 16:54:00 UTC | 2020-01-16 19:11:00 UTC | train | 189 | 8 | outward | Stuttgart Hauptbahnhof | München Hauptbahnhof | Germany | Germany | | | Erika Musterfrau | Michael Lukas | 37.7 | 2 | 2. Klasse Flexpreis | DeutscheBahn | | | | false | 0 | domestic | 2020-01-16 09:20:39 UTC | Muster GmbH | | VGK6HM | | | | | 1 | 1234 | 45817 | 61278 | confirm_finished | 2020-01-31 17:14:00 UTC | 2020-01-31 19:27:00 UTC | train | 189 | 8 | outward | Stuttgart Hauptbahnhof | München Hauptbahnhof | Germany | Germany | | | Paul Maier | Michael Lukas | 58.8 | 2 | 2. Klasse Flexpreis | DeutscheBahn | | | | false | 0 | domestic | 2020-01-31 11:11:59 UTC | Muster GmbH | | PAP3EM | | | | | 1 | 1234 | 41304 | 55349 | confirm_finished | 2020-02-04 13:18:00 UTC | 2020-02-04 15:25:00 UTC | train | 219 | 9 | outward | München Hauptbahnhof | Würzburg Hauptbahnhof / Busbahnhof | Germany | Germany | | | Erika Musterfrau | Philipp Schmidt | 33.7 | 2 | 2. Klasse Flexpreis | DeutscheBahn | | | | false | 24 | domestic | 2020-01-10 15:39:13 UTC | Muster GmbH | | Y9MBNA | | | | | 1 | 1234 | 51832 | 69144 | confirm_finished | 2020-02-28 06:00:00 UTC | 2020-02-28 09:38:00 UTC | train | 363 | 15 | outward | Nürnberg Hauptbahnhof / ZOB | Düsseldorf Hauptbahnhof / ZOB | Germany | Germany | | | Max Mustermann | Stefan Weigert | 121.8 | 2 | 2. Klasse Flexpreis | DeutscheBahn | | | | false | 0 | domestic | 2020-02-27 08:59:40 UTC | Muster GmbH | | 9P76NW | | | | | 1 | 1234 | 59544 | 78087 | confirm_finished | 2020-06-28 18:57:00 UTC | 2020-06-28 22:36:00 UTC | train | 363 | 15 | outward | Nürnberg Hauptbahnhof / ZOB | Düsseldorf Hauptbahnhof / ZOB | Germany | Germany | | | Fritz Schneider | Stefan Weigert | 106.65 | 1 | 1. Klasse Flexpreis | DeutscheBahn | | | | false | 11 | domestic | 2020-06-16 11:20:29 UTC | Muster GmbH | | 9VFZCU | | | | | 1 | 1234 | 59952 | 78585 | confirm_finished | 2020-06-30 13:33:00 UTC | 2020-06-30 18:07:00 UTC | train | 454 | 19 | outward | Köln Messe/Deutz | München Hauptbahnhof | Germany | Germany | | | Lena Müller | Julia Hofmann | 113.8 | 1 | 1. Klasse Flexpreis | DeutscheBahn | | | | false | 10 | domestic | 2020-06-19 15:52:27 UTC | Muster GmbH | | GTM813 | | | | | 1 | 1234 | 64256 | 83926 | confirm_finished | 2020-08-02 19:47:00 UTC | 2020-08-02 22:04:00 UTC | train | 189 | 8 | outward | München Hauptbahnhof | Stuttgart Hauptbahnhof | Germany | Germany | | | Fritz Schneider | Michael Lukas | 30.95 | 2 | 2. Klasse Flexpreis | DeutscheBahn | | | | false | 1 | domestic | 2020-07-31 13:08:59 UTC | Muster GmbH | | 6T3B2D | | | | | 1 | 1234 | 64132 | 83779 | confirm_finished | 2020-08-03 06:45:00 UTC | 2020-08-03 09:37:00 UTC | train | 198 | 8 | outward | München Hauptbahnhof | Böblingen | Germany | Germany | | | Erika Musterfrau | Marco Klein | 46.75 | 1 | 1. Klasse Flexpreis | DeutscheBahn | | | | false | 3 | domestic | 2020-07-30 15:36:34 UTC | Muster GmbH | | QSA6DN | | | | | 1 | 1234 | 64354 | 84038 | confirm_finished | 2020-08-03 16:34:00 UTC | 2020-08-03 18:42:00 UTC | train | 219 | 9 | outward | Würzburg Hauptbahnhof / Busbahnhof | München Hauptbahnhof | Germany | Germany | | | Erika Musterfrau | Marco Klein | 55.85 | 1 | 1. Klasse Flexpreis | DeutscheBahn | | | | false | 0 | domestic | 2020-08-03 07:44:58 UTC | Muster GmbH | | LB3BE7 | | | | | 1 | 1234 | 64500 | 84203 | confirm_finished | 2020-08-03 17:28:00 UTC | 2020-08-03 20:58:00 UTC | train | 417 | 17 | outward | Würzburg Hauptbahnhof / Busbahnhof | Hamburg Hauptbahnhof / ZOB | Germany | Germany | | | Fritz Schneider | Stefan Weigert | 127.65 | 1 | 1. Klasse Super Sparpreis | DeutscheBahn | | | | false | 0 | domestic | 2020-08-03 14:56:31 UTC | Muster GmbH | | ZED1V9 | | | | | 1 | 1234 | 64999 | 84838 | confirm_finished | 2020-08-11 08:44:00 UTC | 2020-08-11 08:57:00 UTC | train | 13 | 1 | outward | Zürich Flughafen | Winterthur | Switzerland | Switzerland | | | Lukas Schröder | Philipp Schmidt | 8.16 | 2 | 2. Klasse, ZVV Single Ticket (flexi) | CFF | | | | false | 3 | domestic | 2020-08-07 08:18:09 UTC | Muster GmbH | | 796086640 | | | | | 1 | 1234 | 64999 | 84837 | confirm_finished | 2020-08-11 15:54:00 UTC | 2020-08-11 16:06:00 UTC | train | 13 | 1 | inbound | Winterthur | Zürich Flughafen | Switzerland | Switzerland | | | Lukas Schröder | Philipp Schmidt | 8.16 | 2 | 2. Klasse, ZVV Single Ticket (flexi) | CFF | | | | false | 3 | domestic | 2020-08-07 08:18:10 UTC | Muster GmbH | | 796086641 | | | | ## CarbonFootprint_Parameter | 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.7 | 0 | | Plane | 988 | 4864 | | Fernbus| 0 | 0 | | Rental | 427 | 2050 | | Gesamt:| 1769.7 | 12568 |