Vibrio Vulnificus Abundance In Ala Wai Canal
Exploring Temporal, Spatial and Environmental Influences
@kaggle.thedevastator_vibrio_vulnificus_abundance_in_ala_wai_canal
Exploring Temporal, Spatial and Environmental Influences
@kaggle.thedevastator_vibrio_vulnificus_abundance_in_ala_wai_canal
CREATE TABLE nigro_2008_2009_ala_wai_canal_vibrio_vulnificus_and_en_1e06fa15 (
"date_yyymmdd" BIGINT,
"local_time_hst" VARCHAR,
"site" BIGINT,
"site_type" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"nominal_season" VARCHAR,
"rainfall_valley_cm" DOUBLE,
"rainfall_coast_cm" DOUBLE,
"monthly_avg_rainfall_valley_cm_per_d" DOUBLE,
"monthly_avg_rainfall_coast_cm_per_d" DOUBLE,
"streamflow_manoapalolo_cubic_m_per_s" DOUBLE,
"tide_mllw_m" DOUBLE,
"temperature_deg_celsius" DOUBLE,
"salinity_ppt" BIGINT,
"nitrate_nitrite_m" DOUBLE,
"nitrate_m" DOUBLE,
"nitrite_m" DOUBLE,
"ammonia_m" DOUBLE,
"phosphate_m" DOUBLE,
"silica_m" DOUBLE,
"particulate_carbon_m" DOUBLE,
"particulate_nitrogen_m" DOUBLE,
"chlorophyll_g_per_l" DOUBLE,
"bacteria_cells_per_ml" DOUBLE,
"dna_yield_ng_per_l_of_sample" DOUBLE,
"vvha_gene_copies_per_ml" BIGINT,
"vcgc_gene_copies_per_ml" DOUBLE,
"tcbs_total_colonies_per_ml" DOUBLE,
"tcbs_green_colonies_per_ml" DOUBLE,
"tcbs_yellow_colonies_per_ml" DOUBLE,
"cav_mauve_colonies_per_ml" DOUBLE,
"cav_blue_colonies_per_ml" DOUBLE
);
Anyone who has the link will be able to view this.