FUELLING WAR MASTER DATASET (24/02-31/08/2022)

	A	C
1
2
3
4
5
6	#FuellingWar: European ships bolster Russian fossil fuel trade despite looming EU sanctions
7	https://www.investigate-europe.eu/en/2022/european-ships-bolster-russian-fossil-fuel-trade-despite-looming-eu-sanctions/
8	Reporting: Chris Matthews (Investigate Europe) and Sotiris Sideris, Nikolas Leontopoulos, Thodoris Chondrogiannos, Konstantina Maltepioti (Reporters United)
9	Data: Sotiris Sideris, Konstantina Maltepioti (Reporters United) and Chris Matthews (Investigate Europe)
10
11
12	Columns	Description
13	id	Unique id of each shipment
14	departure_date_utc	Date and time of shipment's departure
15	departure_country	Country of departure
16	departure_port_name	Port name of departure
17	arrival_date_utc	Date and time of shipment's arrival
18	arrival_port_name	Port name of arrival
19	destination_country	Destination country
20	destination_region	Destination region
21	ship_name_equasis	Name of the ship
22	ship_IMO_equasis	IMO identification number of the ship
23	ship_manager_equasis	Managing company of the ship
24	ship_manager_IMO_equasis	IMO identification number of the managing company
25	ship_manager_country_equasis	Registration country of managing company
26	ship_type_equasis	Type of the ship
27	ship_DWT_equasis	Deadweight tonnage of the ship
28	commodity	Commodity exported
29	commodity_group	Group of the commodity exported
30	ship_manager_address_equasis	Registered address of the managing company
31	ship_manager_date_equasis	Date of effect
32	registered_owner_equasis	Registered owner
33	registered_owner_IMO_equasis	IMO identification number of the registered owner
34	registered_owner_country_equasis	Registration country of the registered owner
35	registered_owner_address_equasis	Registered address of the registered owner
36	ISM_manager_equasis	ISM manager
37	ISM_manager_IMO_equasis	IMO identification number of the ISM manager
38	ISM_manager_country_equasis	Registration country of the ISM manager
39	ISM_manager_address_equasis	Registered address of the ISM manager
40	ship_insurer	Insurance company of the shipment
41	ship_insurer_country	Registration country of the ship insurer
42	ship_insurer_region	Region of the ship insurer
43	arrival_berth_name	id of the shipment's arrival point
44	ship_flag_equasis	Flag under which the ship is sailing
45	ship_year_build_equasis	Year the ship was built
46	ship_call_sign_equasis	Ship's special call sign that is assigned to it when it receives it's Ship Radio Licence
47
48
49	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 and 31 August 2022. The ownership of a ship occurs from the 'ship_manager_equasis' column, neither the 'registered_owner' nor '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].
50
51