🦈 Shark Attacks - New Caledonia

Supercharged and highly contextualized data of shark attacks in New Caledonia

@kaggle.adriensales_shark_attack_nouvelle_caldonie

Table List

4 tables(52.23 KB)

Conservation Status

Shark Attacks Ncl

Sharks

Lunar Phases

Shark Attacks Ncl

@kaggle.adriensales_shark_attack_nouvelle_caldonie.shark_attacks_ncl

31.35 KB
69 rows
35 columns

case_number Case Number	date Date	moon_phase_rate Moon Phase Rate	moon_phase Moon Phase	year_month Year-month	year Year	month Month	dow Dow	season Season	type Type	country Country	country_code_iso_3166_1 Country Code ISO 3166–1	commune_nom Commune Nom	coast Coast	location Location	details_plage Details Plage	code_cog Code Cog	province Province	activity Activity	name Name	sex Sex	age Age	injury Injury	is_fatal Is Fatal	time Time	day_part Day Part	species Species	species_1 Species 1	species_2 Species 2	skark_size_centimeters Skark Size Centimeters	source Source	www_sharkattack_file Www Sharkattack File	www_nc1 Www Nc1	sharkattack_id Sharkattack Id
2025-01-11	Sat Jan 11 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	90	WAXING_GIBBOUS	Wed Jan 01 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	2025	January	Saturday	SUMMER	UNPROVOKED	NEW CALEDONIA	NCL	MARE	nan	au large de Maré entre Padawa et Necé	nan	98815	ILES	SPEARFISHING	nan	M	40	FOREARM	N	21:00	PM	nan	nan	nan		https://la1ere.francetvinfo.fr/nouvellecaledonie/un-pecheur-amateur-se-fait-attaquer-par-un-requin-a-l-ouest-de-mare-1553719.html	nan	https://la1ere.francetvinfo.fr/nouvellecaledonie/un-pecheur-amateur-se-fait-attaquer-par-un-requin-a-l-ouest-de-mare-1553719.html
2025-01-09	Thu Jan 09 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	75.82	WAXING_GIBBOUS	Wed Jan 01 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	2025	January	Thursday	SUMMER	UNPROVOKED	NEW CALEDONIA	NCL	NOUMEA	WEST	Nouville	nan	98818	SUD	FOILBOARDING	Charles Roger	M		BOARD	Y	14:00	PM	BULL_SHARK	BULL_SHARK	nan		https://la1ere.francetvinfo.fr/nouvellecaledonie/temoignage-j-ai-vu-le-requin-s-approcher-a-un-metre-sous-la-surface-raconte-le-caledonien-charge-par-un-squale-alors-qu-il-faisait-du-paddle-1552705.html	nan	nan
2025-01-02	Thu Jan 02 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	5.61	WAXING_CRESCENT	Wed Jan 01 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	2025	January	Thursday	SUMMER	UNPROVOKED	NEW CALEDONIA	NCL	KOUMAC	WEST	Ilot Kendek	nan	98812	NORD	SPEARFISHING	nan	M	40	FATAL	N	nan	nan	TIGER_SHARK	TIGER_SHARK	nan		https://la1ere.francetvinfo.fr/nouvellecaledonie/province-nord/koumac/un-requin-tigre-a-l-origine-de-l-attaque-mortelle-de-koumac-1552381.html	nan	nan
2023.05.28	Sun May 28 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	59.8	WANING_GIBBOUS	Mon May 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	2023	May	Sunday	WINTER	UNPROVOKED	NEW CALEDONIA	NCL	POUM	WEST	Ilot Tuany	ilot Tuany	98826	NORD	SPEARFISHING	nan	M	40	nan	Y	11:00	AM	nan	nan	nan		la1ere.francetvinfo.fr	nan	https://la1ere.francetvinfo.fr/nouvellecaledonie/province-nord/poum/poum-une-attaque-de-requin-mortelle-pres-d-un-ilot-1400110.html
2023.02.19	Sun Feb 19 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	1.5	WANING_CRESCENT	Wed Feb 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	2023	February	Sunday	SUMMER	UNPROVOKED	NEW CALEDONIA	NCL	NOUMEA	WEST	Plage de l'Anse-Vata	Plage du Château Royal de Nouméa	98818	SUD	SWIMMING	nan	M	59	LEG	Y	16:10	AM	BULL_SHARK	BULL_SHARK	nan	290	Les Nouvelles Caledoniennes, 02/19/2023	nan	https://la1ere.francetvinfo.fr/nouvellecaledonie/alerte-nouvelle-attaque-de-requin-a-la-plage-du-chateau-royal-1367866.html
2023.02.04	Sat Feb 04 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	99	WAXING_GIBBOUS	Wed Feb 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	2023	February	Saturday	SUMMER	UNPROVOKED	NEW CALEDONIA	NCL	NOUMEA	WEST	Plage de l'Anse-Vata	Anse Vata	98818	SUD	FOILBOARDING	nan	M		nan	N	18:30	LPM	nan	nan	nan		nan	nan	https://la1ere.francetvinfo.fr/nouvellecaledonie/province-sud/noumea/noumea-un-veliplanchiste-echappe-a-une-attaque-de-requin-1363582.html
2023.01.29	Sun Jan 29 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	60	WAXING_GIBBOUS	Sun Jan 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	2023	January	Sunday	WINTER	UNPROVOKED	NEW CALEDONIA	NCL	NOUMEA	WEST	Plage de l'Anse-Vata	Plage du Château Royal de Nouméa	98818	SUD	SWIMMING	nan	F	49	HAND, THIGH	N	10:30	AM	BULL_SHARK	BULL_SHARK	nan		Les Nouvelles Caledoniennes, 1/29/2023	nan	https://la1ere.francetvinfo.fr/nouvellecaledonie/province-sud/noumea/attaque-de-requin-a-noumea-la-victime-evasanee-en-australie-1362782.html
2021.05.25	Tue May 25 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	99	WAXING_GIBBOUS	Sat May 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	May	Tuesday	SUMMER	PROVOKED	NEW CALEDONIA	NCL	NOUMEA	WEST	Plage du CHS, Nouville	Plage du CHS, Nouville	98818	SUD	SPEARFISHING	nan	M		nan	Y	nan	nan	nan	nan	nan		F. Abbott & Ouest-France. 5/27/2021	http://sharkattackfile.net/spreadsheets/pdf_directory/2021.06.12-Butler.pdf	nan	6665
2021.04.24.a	Sat Apr 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	25	WAXING_CRESCENT	Thu Apr 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	April	Saturday	SUMMER	UNPROVOKED	NEW CALEDONIA	NCL	NOUMEA	WEST	Nouville	nan	98818	SUD	STANDUPPADDLE	Jean-Christophe Vivier	M	53	nan	Y	nan	nan	nan	nan	nan		K. McMurray, TrackingSharks.com	http://sharkattackfile.net/spreadsheets/pdf_directory/2021.04.29-Disney.pdf	nan	6653
2021.03.02	Tue Mar 02 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	85	WANING_GIBBOUS	Mon Mar 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	March	Tuesday	SUMMER	UNPROVOKED	NEW CALEDONIA	NCL	OUVEA	nan	Ouvéa	nan	98820	ILES	SPEARFISHING	nan	M	16	LEG	N	nan	PM	TIGER_SHARK	TIGER_SHARK	nan		Franceinfo, 3/2/2021	http://sharkattackfile.net/spreadsheets/pdf_directory/2021.03.20-May.pdf	nan	6638


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