Million Locations On English Wikipedia

Pages that contains geolocations on English Wikipedia

@kaggle.dataridders_million_locations_on_english_wikipedia

Table List

1 table(50.11 MB)

Locations On Wikipedia

@kaggle.dataridders_million_locations_on_english_wikipedia.locations_on_wikipedia

50.11 MB
1005979 rows
7 columns

id Id	location Location	lat Lat	lon Lon	globe Globe	article_length Article Length	full_url Full Url
303	Alabama	32.7794	-86.8287	earth	202090	https://en.wikipedia.org/wiki/Alabama
358	Algeria	28	2	earth	172802	https://en.wikipedia.org/wiki/Algeria
600	Andorra	42.5	1.51666667	earth	131582	https://en.wikipedia.org/wiki/Andorra
624	Alaska	64.0685	-152.2782	earth	165611	https://en.wikipedia.org/wiki/Alaska
698	Atlantic Ocean		-25	earth	109240	https://en.wikipedia.org/wiki/Atlantic_Ocean
701	Angola	-12.5	18.5	earth	150090	https://en.wikipedia.org/wiki/Angola
717	Alberta	54.99166667	-114.37666667	earth	140617	https://en.wikipedia.org/wiki/Alberta
737	Afghanistan	34.51666667	69.18333333	earth	287743	https://en.wikipedia.org/wiki/Afghanistan
738	Albania	41	20	earth	271935	https://en.wikipedia.org/wiki/Albania
746	Azerbaijan	40.3	47.7	earth	234711	https://en.wikipedia.org/wiki/Azerbaijan


CREATE TABLE locations_on_wikipedia (
  "id" BIGINT,
  "location" VARCHAR,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "globe" VARCHAR,
  "article_length" BIGINT,
  "full_url" VARCHAR
);