sources

This table contains all the sources for our datasets. The description column contains JSON encoded as text that contains useful additional fields like a longer descriptive text "additionalInfo".

Data license: CC-BY

1 row where datasetId = 2862 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt (date), updatedAt (date)

id ▲ name description createdAt updatedAt datasetId additionalInfo link dataPublishedBy
15596 Global Shark Attack File (GSAF) (2018) 
{
    "link": "https://docs.google.com/spreadsheets/d/1rH3O8JQ1v6tt7swPNbE5B5-AtVr9OtjhhmwpEuBQFbc/edit?usp=sharing",
    "retrievedDate": "01/08/2018",
    "additionalInfo": "The Global Shark Attack File (GSAF) keeps an incident log that is updated with each new shark attack. Four types of shark attack categories are included: provoked, unprovoked, boating incidents, and sea disasters. The GSAF defines provoked incidents as incidents in which \"the shark was speared, hooked, captured or in which a human drew 'first blood'\" versus unprovoked incidents where this behaviour did not occur. Boating incidents are defined as cases where \"a boat was bitten or rammed by a shark.\" Sea disasters are \"accidents that place people in the day-to-day business of sharks.\" \n\nShark attacks classified as \"Invalid\" or \"Questionable\" have been excluded from estimates.\n\nThe link above provides more details about the type, area, location, activity, whether the victim was a male or female, their age, description of the injury, time of the incident, shark species, and investigator/source for each observation. \n\nWhere a range of dates is provided for a particular incident, we have used the earliest year when plotting the data. For example, where the date is provided as \"Between 1918 and 1939\" we plot this as 1918. For years entered as \"Before xxxx\", we have simply input the previous year. The observations 'Portugal / India' for 1580, and 'Africa' for 1846 have been dropped due to their geographical inaccuracy.\n\nThe 'Global Shark Attack File'  figures reflect reported/recorded attacks or deaths only. For less recent years, these records could be incomplete.",
    "dataPublishedBy": "Global Shark Attack File",
    "dataPublisherSource": "Multiple sources including historical data. See 'Investigator or Source' column in link below for each observation."
}
 2018-08-02 11:44:56 2018-08-03 15:06:31 Shark attacks and fatalities - Global Shark Attack File (GSAF) (2018)  2862 The Global Shark Attack File (GSAF) keeps an incident log that is updated with each new shark attack. Four types of shark attack categories are included: provoked, unprovoked, boating incidents, and sea disasters. The GSAF defines provoked incidents as incidents in which "the shark was speared, hooked, captured or in which a human drew 'first blood'" versus unprovoked incidents where this behaviour did not occur. Boating incidents are defined as cases where "a boat was bitten or rammed by a shark." Sea disasters are "accidents that place people in the day-to-day business of sharks." Shark attacks classified as "Invalid" or "Questionable" have been excluded from estimates. The link above provides more details about the type, area, location, activity, whether the victim was a male or female, their age, description of the injury, time of the incident, shark species, and investigator/source for each observation. Where a range of dates is provided for a particular incident, we have used the earliest year when plotting the data. For example, where the date is provided as "Between 1918 and 1939" we plot this as 1918. For years entered as "Before xxxx", we have simply input the previous year. The observations 'Portugal / India' for 1580, and 'Africa' for 1846 have been dropped due to their geographical inaccuracy. The 'Global Shark Attack File' figures reflect reported/recorded attacks or deaths only. For less recent years, these records could be incomplete. https://docs.google.com/spreadsheets/d/1rH3O8JQ1v6tt7swPNbE5B5-AtVr9OtjhhmwpEuBQFbc/edit?usp=sharing Global Shark Attack File

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "sources" (
	"id" INTEGER PRIMARY KEY AUTOINCREMENT,
	"name" VARCHAR(512) NULL  ,
	"description" TEXT NOT NULL  ,
	"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
	"updatedAt" DATETIME NULL  ,
	"datasetId" INTEGER NULL, additionalInfo TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.additionalInfo')) VIRTUAL, link TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.link')) VIRTUAL, dataPublishedBy TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.dataPublishedBy')) VIRTUAL,
	FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE INDEX "sources_datasetId" ON "sources" ("datasetId");