| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
1 |  |  | ||||||||
2 | ||||||||||
3 | ||||||||||
4 | ||||||||||
5 | ||||||||||
6 | Europe continues to finance Russia’s war in Ukraine with lucrative fossil fuel trades | |||||||||
7 | https://www.investigate-europe.eu/en/2023/europe-continues-to-finance-russias-war-in-ukraine-with-lucrative-fossil-fuel-trades/ | |||||||||
8 | Reporting: Chris Matthews (Investigate Europe), Thodoris Chondrogiannos, Sotiris Sideris, Konstantina Maltepioti (Reporters United) | |||||||||
9 | Data: Sotiris Sideris, Konstantina Maltepioti (Reporters United) and Chris Matthews (Investigate Europe) | |||||||||
10 | ||||||||||
11 | Columns | Description | ||||||||
12 | id | Unique id of each shipment | ||||||||
13 | departure_date_utc | Date and time of shipment's departure | ||||||||
14 | departure_country | Country of departure | ||||||||
15 | departure_port_name | Port name of departure | ||||||||
16 | departure_port_area | Area of departure port | ||||||||
17 | departure_berth_name | Berth name of departure | ||||||||
18 | arrival_date_utc | Date and time of shipment's arrival | ||||||||
19 | arrival_country | Country of arrival | ||||||||
20 | arrival_port_name | Port name of arrival | ||||||||
21 | arrival_berth_name | Berth name of arrival | ||||||||
22 | arrival_berth_owner | Owner of the arrival berth | ||||||||
23 | destination_country | Destination country | ||||||||
24 | destination_region | Destination region | ||||||||
25 | destination_names | Names of destinations | ||||||||
26 | commodity_name | Commodity exported | ||||||||
27 | commodity_group | Group of the commodity exported | ||||||||
28 | ship_name | Name of the ship | ||||||||
29 | ship_flag_equasis | Flag under which the ship is sailing | ||||||||
30 | ship_insurer | Insurance company of the shipment | ||||||||
31 | ship_insurer_country | Registration country of the ship insurer | ||||||||
32 | ship_IMO_equasis | IMO identification number of the ship | ||||||||
33 | ship_MMSI_equasis | MMSI identification number of the ship | ||||||||
34 | ship_type_equasis | Type of the ship | ||||||||
35 | ship_DWT_equasis | Deadweight tonnage of the ship | ||||||||
36 | ship_manager_equasis | Managing company of the ship | ||||||||
37 | ship_manager_IMO_equasis | IMO identification number of the managing company | ||||||||
38 | ship_manager_country_equasis | Registration country of managing company | ||||||||
39 | ship_manager_address_equasis | Registered address of the managing company | ||||||||
40 | ship_manager_date_equasis | Date of effect | ||||||||
41 | registered_owner_equasis | Registered owner | ||||||||
42 | registered_owner_IMO_equasis | IMO identification number of the registered owner | ||||||||
43 | registered_owner_country_equasis | Registration country of the registered owner | ||||||||
44 | registered_owner_address_equasis | Registered address of the registered owner | ||||||||
45 | registered_owner_date_equasis | Date of effect | ||||||||
46 | ship_year_build_equasis | Year the ship was built | ||||||||
47 | ship_call_sign_equasis | Ship's special call sign that is assigned to it when it receives it's Ship Radio Licence | ||||||||
48 | ||||||||||
49 | ||||||||||
50 | Notes on the dataset: Data on shipments is provided by the Centre for Research on Energy and Clean Air (CREA) [https://www.russiafossiltracker.com/en] primarily retrieved from Marine Traffic [https://www.marinetraffic.com] and the vessel tracker API & ship AIS database Datalastic [https://datalastic.com/]. The main information of each ship, such as its name, IMO identification number, type and year of construction, the flag under which it travels, the management company (Ship/Commercial Manager), registered owner and safety management company (ISM Manager) were scrape by Reporters United and Investigate Europe from the vessel tracking service MarineTraffic and the shipping database Equasis [https://www.equasis.org/]. The tracking period of the voyages reported in this dataset is set between 24 February 2022 and 05 January 2023. The ownership of a ship occurs from the 'ship_manager_equasis' column, not 'the registered_owner_equasis'. Accordingly, the country of the ship owner occurs from the 'ship_manager_country_equasis'. The reason for doing this is that it is very rare for the registered owner of a ship to correspond to the actual owner or manager of the ships. Historically, the shipping industry has been applying the “single ship company rule”: Each ship is managed or operated by a parent company as part of its fleet; but this same ship is registered in the name of a separate company (almost always registered in an off-shore haven) whose only asset is this one particular ship. This is done to reduce as much as possible liabilities for the parent company. Shipments in our analysis are categorised as either oil, gas or coal. Where this is not specified in CREA's dataset relating to the commodity, we have excluded such trades in our analysis. However, given the difficulty in accessing granular information on certain shipments, CREA's data also includes commodities listed as oil products and oil/chemical products under its categorisation as well as crude oil and other types. At present, no additional detail on the specifics of these shipments is provided by CREA. The amount of the fuels transported in a shipment is based on the cargo capacity (deadweight tonnage or DWT) of the ships as listed on Equasis and not on calculations or assumptions. If you find any errors in our data sets, please let us know at reporters@reportersunited.gr / mail@investigate-europe.eu A detailed methodology used for this analysis is here [LINK]. | |||||||||
51 | ||||||||||
52 | ||||||||||
53 | ||||||||||
54 | ||||||||||
55 | ||||||||||