DBPedia Classes

Hierarchical Taxonomy of Wikipedia article classes

@kaggle.danofer_dbpedia_classes

Table List

4 tables(256.31 MB)

Dbp Wiki Data

@kaggle.danofer_dbpedia_classes.dbp_wiki_data

124.18 MB
342781 rows
6 columns

text Text	l1 L1	l2 L2	l3 L3	wiki_name Wiki Name	word_count Word Count
The 1994 Mindoro earthquake occurred on November 15 at 03:15 local time near Mindoro, the Philippines. It had a moment magnitude of 7.1. It is associated with a 35 kilometer-long ground rupture, called the Aglubang River fault. Seventy eight people were reported dead, and 7,566 houses were damaged. …	Event	NaturalEvent	Earthquake	1994_Mindoro_earthquake	59
The 1917 Bali earthquake occurred at 06:50 local time on 21 January (23:11 on 20 January UTC). It had an estimated magnitude of 6.6 on the surface wave magnitude scale and had a maximum perceived intensity of IX (Violent) on the Mercalli intensity scale. It caused widespread damage across Bali, part…	Event	NaturalEvent	Earthquake	1917_Bali_earthquake	68
The 1941 Colima earthquake occurred on April 15 at 19:09 UTC (13:09 local time). The epicenter was located in the State of Michoacán, Mexico. The magnitude of this earthquake was put at Ms 7.7 or Mw 7.6. The intensities were MM X in Colima, MM VIII in Manzanillo, and MM V in Mexico City. 90 people w…	Event	NaturalEvent	Earthquake	1941_Colima_earthquake	194
The 1983 Coalinga earthquake occurred on May 2 at exactly 23:42 UTC in Coalinga, California. The earthquake measured 6.2 on the moment magnitude scale and had a maximum Mercalli intensity of VIII (Severe). The earthquake was caused by an unknown fault buried under the surface. The shock was felt fro…	Event	NaturalEvent	Earthquake	1983_Coalinga_earthquake	98
The 2013 Bushehr earthquake occurred with a moment magnitude of 6.3 on April 9 in Iran. The shock's epicenter was in the province of Bushehr, near the city of Khvormuj and the towns of Kaki and Shonbeh. At least 37 people were killed, mostly from the town of Shonbeh and villages of Shonbeh-Tasuj dis…	Event	NaturalEvent	Earthquake	2013_Bushehr_earthquake	61
The 1894 Istanbul earthquake occurred in the Çınarcık basin or Gulf of Izmit in the Sea of Marmara on 10 July at 12:24pm. The earthquake had an estimated magnitude of 7.0 on the surface wave magnitude scale. At least an estimated 1,349 people were killed in towns around the Gulf of Izmit such as Yal…	Event	NaturalEvent	Earthquake	1894_Istanbul_earthquake	76
The 2012 Yangzhou earthquake occurred in Jiangsu Province of the People's Republic of China at 20:11(UTC+8) in Yangzhou on July 20.	Event	NaturalEvent	Earthquake	2012_Yangzhou_earthquake	21
The 1998 Papua New Guinea earthquake took place on July 17 with a moment magnitude of 7.0 and a maximum Mercalli intensity of VIII (Severe). The event occurred on a reverse fault near the north coast region of Papua New Guinea, 25 kilometers (16 mi) from the coast near Aitape, and caused a large und…	Event	NaturalEvent	Earthquake	1998_Papua_New_Guinea_earthquake	69
The 1980 Oaxaca earthquake occurred on October 24, 1980. It killed 300 and measured 7.0 on the surface wave measurement scale. Leaving many injured, the quake left approximately 150,000 homeless and caused extensive damage, mainly in the Huajuapan de León region of the state of Oaxaca. It was felt t…	Event	NaturalEvent	Earthquake	1980_Oaxaca_earthquake	57
The 2003 Zhaosu earthquake, also known as the Syumbinskoe earthquake, occurred on December 1 at 01:38 UTC. The epicenter was located in the Almaty Region, Kazakhstan, near the Sino–Kazakh border. The earthquake had a magnitude of Mw 6.0 and had a maximum observed intensity of VII (Very strong) on th…	Event	NaturalEvent	Earthquake	2003_Zhaosu_earthquake	107


CREATE TABLE dbp_wiki_data (
  "text" VARCHAR,
  "l1" VARCHAR,
  "l2" VARCHAR,
  "l3" VARCHAR,
  "wiki_name" VARCHAR,
  "word_count" BIGINT
);