🦈 Shark Attacks - New Caledonia
Supercharged and highly contextualized data of shark attacks in New Caledonia
@kaggle.adriensales_shark_attack_nouvelle_caldonie
Supercharged and highly contextualized data of shark attacks in New Caledonia
@kaggle.adriensales_shark_attack_nouvelle_caldonie
CREATE TABLE conservation_status (
"id" VARCHAR,
"id_long" VARCHAR,
"cat" VARCHAR,
"desc" VARCHAR
);
CREATE TABLE shark_attacks_ncl (
"case_number" VARCHAR,
"date" TIMESTAMP,
"moon_phase_rate" DOUBLE,
"moon_phase" VARCHAR,
"year_month" TIMESTAMP,
"year" BIGINT,
"month" VARCHAR,
"dow" VARCHAR,
"season" VARCHAR,
"type" VARCHAR,
"country" VARCHAR,
"country_code_iso_3166_1" VARCHAR,
"commune_nom" VARCHAR,
"coast" VARCHAR,
"location" VARCHAR,
"details_plage" VARCHAR,
"code_cog" DOUBLE,
"province" VARCHAR,
"geo_point" VARCHAR,
"activity" VARCHAR,
"name" VARCHAR,
"sex" VARCHAR,
"age" DOUBLE,
"injury" VARCHAR,
"is_fatal" VARCHAR,
"time" VARCHAR,
"day_part" VARCHAR,
"species" VARCHAR,
"species_1" VARCHAR,
"species_2" VARCHAR,
"skark_size_centimeters" DOUBLE,
"source" VARCHAR,
"www_sharkattack_file" VARCHAR,
"www_nc1" VARCHAR,
"sharkattack_id" DOUBLE
);
CREATE TABLE sharks (
"id" VARCHAR,
"description" VARCHAR,
"scientific_name" VARCHAR,
"conservation_status" VARCHAR
);
CREATE TABLE lunar_phases (
"id" VARCHAR,
"phase" VARCHAR,
"www_phase" VARCHAR,
"illuminated_portion_northern" VARCHAR,
"illuminated_portion_south" VARCHAR,
"visibility" VARCHAR,
"average_moonrise_time" VARCHAR,
"culmination" VARCHAR,
"average_moonset_time" VARCHAR,
"www_illustration_north_png" VARCHAR,
"www_illustration_south_png" VARCHAR,
"www_photo_jpg" VARCHAR
);
Anyone who has the link will be able to view this.