About this Dataset

🦈 Shark Attacks - New Caledonia

Within a very short period (a few weeks) of time we had to face dramatic shark attacks in New Caledonia:

In the mean time, I discovered that at the Réunion Island (who faced similar problems) had a dedicated website :

Finally, I discovered an amazingly detailed article A Spatial and Environmental Analysis of Shark Attacks on Reunion Island (1980-2017), from the University of La Réunion

That were the conditions for me to try to create a maintain some highly contextual datas, from 1886. up to today.

ℹ️ About the dataset

This dataset is an effort of mixing Global Shark Attack - World

This dataset is an effort for putting all publicly available data about shark attacks in New-Caledonia :

Within a very single place,
Enhanced with keys coming from data.gouv.nc for city codes
Enhanced with related datas like moon phasis, season,...
Enhanced with protection status of each shark species we have in New-Caledonia
Season, and other metadatas

Hopefully this effort will be useful.

📑 Related resources

Tables

Conservation Status

@kaggle.adriensales_shark_attack_nouvelle_caldonie.conservation_status

4.47 KB
10 rows
4 columns


CREATE TABLE conservation_status (
  "id" VARCHAR,
  "id_long" VARCHAR,
  "cat" VARCHAR,
  "desc" VARCHAR
);

Shark Attacks Ncl

@kaggle.adriensales_shark_attack_nouvelle_caldonie.shark_attacks_ncl

31.35 KB
69 rows
35 columns


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
);

Sharks

@kaggle.adriensales_shark_attack_nouvelle_caldonie.sharks

4.04 KB
12 rows
4 columns


CREATE TABLE sharks (
  "id" VARCHAR,
  "description" VARCHAR,
  "scientific_name" VARCHAR,
  "conservation_status" VARCHAR
);

Lunar Phases

@kaggle.adriensales_shark_attack_nouvelle_caldonie.lunar_phases

12.37 KB
8 rows
12 columns


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
);