Cost Of Different Technologies (Farmer & Lafond (2016), 2023b)
@owid.farmer_lafond_2016
@owid.farmer_lafond_2016
CREATE TABLE owid_farmer_lafond_2016_1 (
"year" INTEGER,
"acrylic_fiber" FLOAT,
"acrylonitrile" FLOAT,
"aluminum" FLOAT,
"ammonia" FLOAT,
"aniline" FLOAT,
"automotive_us" FLOAT,
"beer_japan" FLOAT,
"benzene" FLOAT,
"bisphenol_a" FLOAT,
"caprolactam" FLOAT,
"carbon_black" FLOAT,
"carbon_disulfide" FLOAT,
"ccgt_power" FLOAT,
"concentrating_solar" FLOAT,
"corn_us" FLOAT,
"crude_oil" FLOAT,
"cyclohexane" FLOAT,
"dna_sequencing" FLOAT,
"dram" FLOAT,
"electric_range" INTEGER,
"ethanol_brazil" FLOAT,
"ethanolamine" FLOAT,
"ethylene" FLOAT,
"formaldehyde" FLOAT,
"free_standing_gas_range" FLOAT,
"geothermal_electricity" FLOAT,
"hard_disk_drive" FLOAT,
"hydrofluoric_acid" FLOAT,
"isopropyl_alcohol" FLOAT,
"laser_diode" INTEGER,
"low_density_polyethylene" FLOAT,
"magnesium" FLOAT,
"maleic_anhydride" FLOAT,
"methanol" FLOAT,
"milk_us" FLOAT,
"monochrome_television" FLOAT,
"motor_gasoline" FLOAT,
"neoprene_rubber" FLOAT,
"nuclear_electricity" FLOAT,
"onshore_gas_pipeline" FLOAT,
"paraxylene" FLOAT,
"pentaerythritol" FLOAT,
"phenol" FLOAT,
"photovoltaics" FLOAT,
"phthalic_anhydride" FLOAT,
"polyester_fiber" FLOAT,
"polyethylene_hd" FLOAT,
"polyethylene_ld" FLOAT,
"polypropylene" FLOAT,
"polystyrene" FLOAT,
"polyvinylchloride" FLOAT,
"primary_aluminum" FLOAT,
"primary_magnesium" FLOAT,
"refined_cane_sugar" FLOAT,
"sodium" FLOAT,
"sodium_chlorate" FLOAT,
"sodium_hydrosulfite" FLOAT,
"sorbitol" FLOAT,
"styrene" FLOAT,
"titanium_sponge" FLOAT,
"titanium_dioxide" FLOAT,
"transistor" FLOAT,
"urea" FLOAT,
"vinyl_acetate" FLOAT,
"vinyl_chloride" FLOAT,
"wind_turbine_denmark" INTEGER
);
CREATE TABLE owid_farmer_lafond_2016_2 (
"year" INTEGER,
"acrylic_fiber" FLOAT,
"acrylonitrile" FLOAT,
"aluminum" FLOAT,
"ammonia" FLOAT,
"aniline" FLOAT,
"automotive_us" FLOAT,
"beer_japan" FLOAT,
"benzene" FLOAT,
"bisphenol_a" FLOAT,
"caprolactam" FLOAT,
"carbon_black" FLOAT,
"carbon_disulfide" FLOAT,
"ccgt_power" FLOAT,
"concentrating_solar" FLOAT,
"corn_us" FLOAT,
"crude_oil" FLOAT,
"cyclohexane" FLOAT,
"dna_sequencing" FLOAT,
"dram" FLOAT,
"electric_range" INTEGER,
"ethanol_brazil" FLOAT,
"ethanolamine" FLOAT,
"ethylene" FLOAT,
"formaldehyde" FLOAT,
"free_standing_gas_range" FLOAT,
"geothermal_electricity" FLOAT,
"hard_disk_drive" FLOAT,
"hydrofluoric_acid" FLOAT,
"isopropyl_alcohol" FLOAT,
"laser_diode" INTEGER,
"low_density_polyethylene" FLOAT,
"magnesium" FLOAT,
"maleic_anhydride" FLOAT,
"methanol" FLOAT,
"milk_us" FLOAT,
"monochrome_television" FLOAT,
"motor_gasoline" FLOAT,
"neoprene_rubber" FLOAT,
"nuclear_electricity" FLOAT,
"onshore_gas_pipeline" FLOAT,
"paraxylene" FLOAT,
"pentaerythritol" FLOAT,
"phenol" FLOAT,
"photovoltaics" FLOAT,
"phthalic_anhydride" FLOAT,
"polyester_fiber" FLOAT,
"polyethylene_hd" FLOAT,
"polyethylene_ld" FLOAT,
"polypropylene" FLOAT,
"polystyrene" FLOAT,
"polyvinylchloride" FLOAT,
"primary_aluminum" FLOAT,
"primary_magnesium" FLOAT,
"refined_cane_sugar" FLOAT,
"sodium" FLOAT,
"sodium_chlorate" FLOAT,
"sodium_hydrosulfite" FLOAT,
"sorbitol" FLOAT,
"styrene" FLOAT,
"titanium_sponge" FLOAT,
"titanium_dioxide" FLOAT,
"transistor" FLOAT,
"urea" FLOAT,
"vinyl_acetate" FLOAT,
"vinyl_chloride" FLOAT,
"wind_turbine_denmark" INTEGER
);
Anyone who has the link will be able to view this.