Name: 🦈 Shark Attacks - New Caledonia
Creator: Kaggle
License: http://opendatacommons.org/licenses/odbl/1.0/

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.58 kB
10 rows
4 columns

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

Lunar Phases

@kaggle.adriensales_shark_attack_nouvelle_caldonie.lunar_phases

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

Shark Attacks Ncl

@kaggle.adriensales_shark_attack_nouvelle_caldonie.shark_attacks_ncl

32.1 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.14 kB
12 rows
4 columns

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