Radiological Monitoring Data
Food Standards Agency
@ukgov.radiological_monitoring_data
Food Standards Agency
@ukgov.radiological_monitoring_data
CREATE TABLE provisional_2016_bi_annual_aquatic_and_terrestrial_mon_9dafd233 (
"site" BIGINT,
"site_name" VARCHAR,
"station_name" VARCHAR,
"tramp_farm_name" VARCHAR,
"description" VARCHAR,
"date_collected" TIMESTAMP,
"laboratory_sample_number" BIGINT,
"analysis" VARCHAR,
"name" VARCHAR,
"result_unitsnotamendedfrom_mbqto_bq" VARCHAR,
"result_no_flag_unitsamendedforrife_allbq_s" DOUBLE,
"result_sfg" VARCHAR,
"rnf_2sg" DOUBLE,
"actual_error" DOUBLE,
"percentage_error" VARCHAR,
"unit" VARCHAR,
"errorcorrected" DOUBLE,
"ec_2sf" DOUBLE,
"lod" VARCHAR,
"resultstring" VARCHAR
);
CREATE TABLE provisional_2020_bi_annual_aquatic_and_terrestrial_mon_dc08a093 (
"sitename" VARCHAR,
"station" VARCHAR,
"trampfarmname" VARCHAR,
"description" VARCHAR,
"datereceived" TIMESTAMP,
"laboratorysamplenumber" VARCHAR,
"totalbeta" VARCHAR,
"obt" VARCHAR,
"h_3" VARCHAR,
"c_14" VARCHAR,
"c_14_n" VARCHAR,
"s_35" VARCHAR,
"sr_90" VARCHAR,
"tc_99" VARCHAR,
"i_125" VARCHAR,
"cs_137_cs_134" VARCHAR,
"pm_147" VARCHAR,
"po_210" VARCHAR,
"pb_210" VARCHAR,
"np_237" VARCHAR,
"pu_238" VARCHAR,
"pu_241" VARCHAR,
"am_241_chem" VARCHAR,
"cm_242" VARCHAR,
"pu_239_240" VARCHAR,
"cm_243_244" VARCHAR,
"k_40" VARCHAR,
"cr_51" VARCHAR,
"mn_54" VARCHAR,
"co_57" VARCHAR,
"co_58" VARCHAR,
"co_60" VARCHAR,
"zn_65" VARCHAR,
"se_75" VARCHAR,
"nb_95" VARCHAR,
"zr_95" VARCHAR,
"ru_103" VARCHAR,
"ru_106" VARCHAR,
"ag_110m" VARCHAR,
"sb_124" VARCHAR,
"sb_125" VARCHAR,
"i_131_aq" VARCHAR,
"cs_134" VARCHAR,
"cs_137" VARCHAR,
"ce_144" VARCHAR,
"eu_154" VARCHAR,
"eu_155" VARCHAR,
"am_241" VARCHAR
);
CREATE TABLE provisional_2021_bi_annual_aquatic_and_terrestrial_mon_2bc6b7e0 (
"sitename" VARCHAR,
"station" VARCHAR,
"trampfarmname" VARCHAR,
"description" VARCHAR,
"datereceived" TIMESTAMP,
"laboratorysamplenumber" VARCHAR,
"totalbeta" VARCHAR,
"obt" VARCHAR,
"h_3" VARCHAR,
"c_14" VARCHAR,
"c_14_n" VARCHAR,
"s_35" VARCHAR,
"sr_90" VARCHAR,
"tc_99" VARCHAR,
"cs_137_cs_134" VARCHAR,
"pm_147" VARCHAR,
"po_210" VARCHAR,
"pb_210" VARCHAR,
"np_237" VARCHAR,
"pu_238" VARCHAR,
"pu_241" VARCHAR,
"am_241_chem" VARCHAR,
"cm_242" VARCHAR,
"pu_239_240" VARCHAR,
"cm_243_244" VARCHAR,
"k_40" VARCHAR,
"cr_51" VARCHAR,
"mn_54" VARCHAR,
"co_57" VARCHAR,
"co_58" VARCHAR,
"co_60" VARCHAR,
"zn_65" VARCHAR,
"se_75" VARCHAR,
"nb_95" VARCHAR,
"zr_95" VARCHAR,
"ru_103" VARCHAR,
"ru_106" VARCHAR,
"ag_110m" VARCHAR,
"sb_124" VARCHAR,
"sb_125" VARCHAR,
"i_131_aq" VARCHAR,
"cs_134" VARCHAR,
"cs_137" VARCHAR,
"ce_144" VARCHAR,
"eu_154" VARCHAR,
"eu_155" VARCHAR,
"am_241" VARCHAR
);
CREATE TABLE provisional_2022_bi_annual_aquatic_and_terrestrial_mon_e40fc615 (
"sitename" VARCHAR,
"station" VARCHAR,
"trampfarmname" VARCHAR,
"description" VARCHAR,
"datereceived" TIMESTAMP,
"laboratorysamplenumber" VARCHAR,
"totalbeta" VARCHAR,
"obt" VARCHAR,
"h_3" VARCHAR,
"c_14" VARCHAR,
"c_14_n" VARCHAR,
"s_35" VARCHAR,
"sr_90" VARCHAR,
"tc_99" VARCHAR,
"cs_137_cs_134" VARCHAR,
"pm_147" VARCHAR,
"po_210" VARCHAR,
"pb_210" VARCHAR,
"np_237" VARCHAR,
"pu_238" VARCHAR,
"pu_241" VARCHAR,
"am_241_chem" VARCHAR,
"cm_242" VARCHAR,
"pu_239_240" VARCHAR,
"cm_243_244" VARCHAR,
"k_40" VARCHAR,
"cr_51" VARCHAR,
"mn_54" VARCHAR,
"co_57" VARCHAR,
"co_58" VARCHAR,
"co_60" VARCHAR,
"zn_65" VARCHAR,
"se_75" VARCHAR,
"nb_95" VARCHAR,
"zr_95" VARCHAR,
"ru_103" VARCHAR,
"ru_106" VARCHAR,
"ag_110m" VARCHAR,
"sb_124" VARCHAR,
"sb_125" VARCHAR,
"i_131_aq" VARCHAR,
"cs_134" VARCHAR,
"cs_137" VARCHAR,
"ce_144" VARCHAR,
"eu_154" VARCHAR,
"eu_155" VARCHAR,
"am_241" VARCHAR
);
CREATE TABLE provisional_2023_bi_annual_aquatic_and_terrestrial_mon_bf2cee58 (
"sitename" VARCHAR,
"station" VARCHAR,
"trampfarmname" VARCHAR,
"description" VARCHAR,
"datereceived" TIMESTAMP,
"laboratorysamplenumber" VARCHAR,
"totalbeta" VARCHAR,
"obt" VARCHAR,
"h_3" VARCHAR,
"c_14" VARCHAR,
"c_14_n" VARCHAR,
"s_35" VARCHAR,
"sr_90" VARCHAR,
"tc_99" VARCHAR,
"cs_137_cs_134" VARCHAR,
"pm_147" VARCHAR,
"po_210" VARCHAR,
"pb_210" VARCHAR,
"np_237" VARCHAR,
"pu_238" VARCHAR,
"pu_241" VARCHAR,
"am_241_chem" VARCHAR,
"cm_242" VARCHAR,
"pu_239_240" VARCHAR,
"cm_243_244" VARCHAR,
"k_40" VARCHAR,
"cr_51" VARCHAR,
"mn_54" VARCHAR,
"co_57" VARCHAR,
"co_58" VARCHAR,
"co_60" VARCHAR,
"zn_65" VARCHAR,
"se_75" VARCHAR,
"nb_95" VARCHAR,
"zr_95" VARCHAR,
"ru_103" VARCHAR,
"ru_106" VARCHAR,
"ag_110m" VARCHAR,
"sb_124" VARCHAR,
"sb_125" VARCHAR,
"i_131_aq" VARCHAR,
"cs_134" VARCHAR,
"cs_137" VARCHAR,
"ce_144" VARCHAR,
"eu_154" VARCHAR,
"eu_155" VARCHAR,
"am_241" VARCHAR
);
CREATE TABLE radiological_monitoring_data (
"site_name" VARCHAR,
"description" VARCHAR,
"tramp_farm_name" VARCHAR,
"description2" VARCHAR,
"date_collected" TIMESTAMP,
"laboratory_sample_number" BIGINT,
"ag_110m" VARCHAR,
"am_241" VARCHAR,
"am_241_chem" VARCHAR,
"c_14" VARCHAR,
"cm_242" VARCHAR,
"cm_243_244" VARCHAR,
"co_57" VARCHAR,
"co_58" VARCHAR,
"co_60" VARCHAR,
"cr_51" VARCHAR,
"cs_134" VARCHAR,
"cs_137" VARCHAR,
"eu_154" VARCHAR,
"eu_155" VARCHAR,
"i_131" VARCHAR,
"k_40" VARCHAR,
"mn_54" VARCHAR,
"nb_95" VARCHAR,
"pu_238" VARCHAR,
"pu_239_240" VARCHAR,
"ru_103" VARCHAR,
"ru_106" VARCHAR,
"sb_124" VARCHAR,
"sb_125" VARCHAR,
"se_75" VARCHAR,
"zn_65" VARCHAR,
"zr_95" VARCHAR,
"c_143" VARCHAR,
"c_14_n" VARCHAR,
"h_3" VARCHAR,
"obt" VARCHAR,
"pu_241" VARCHAR,
"tc_99" VARCHAR,
"total_beta" VARCHAR,
"i_129" VARCHAR,
"sr_90" VARCHAR,
"po_210" VARCHAR,
"pb_210" VARCHAR,
"np_237" VARCHAR,
"np_239" VARCHAR,
"pm_147" VARCHAR,
"th_228" VARCHAR,
"th_230" VARCHAR,
"th_232" VARCHAR,
"u_234" VARCHAR,
"u_235" VARCHAR,
"u_238" VARCHAR,
"cs_137_cs_134" VARCHAR,
"s_35" VARCHAR,
"i_125" VARCHAR,
"p_32" VARCHAR
);
Anyone who has the link will be able to view this.