Economic Falkland Islands

Time Period of the Dataset [?]: January 01, 2018-November 24, 2023 ... More This

@kaggle.willianoliveiragibin_economic_falkland_islands

Table List

4 tables(42.47 KB)

Airports Fk New

Heath Indi Flk New

Nutrition Land Inform Sy Indi Flk New

Sogeh Aggregiondata Allyears New

Airports Fk New

@kaggle.willianoliveiragibin_economic_falkland_islands.airports_fk_new

16.22 KB
999 rows
19 columns

id Id	ident Ident	type Type	name Name	latitude_deg Latitude Deg	longitude_deg Longitude Deg	continent Continent	country_name Country Name	iso_country Iso Country	region_name Region Name	iso_region Iso Region	local_region Local Region	municipality Municipality	scheduled_service Scheduled Service	last_updated Last Updated	score Score	elevation_ft Elevation Ft	wikipedia_link Wikipedia Link	keywords Keywords
2512	EGYP	medium_airport	Mount Pleasant Airport	-5.182.279.968.261.710	-58.447.200.775.146.400	SA	Falkland Islands	FK	(unassigned)	FK-U-A	U-A	Mount Pleasant	1	2008-08-24T11:33:48+00:00	750	244	https://en.wikipedia.org/wiki/RAF_Mount_Pleasant	RAF Mount Pleasant
6087	SFAL	medium_airport	Port Stanley Airport	-51.685.699.462.891	-57.777.599.334.717	SA	Falkland Islands	FK	(unassigned)	FK-U-A	U-A	Stanley	1	2016-01-09T10:46:55+00:00	550	75	https://en.wikipedia.org/wiki/Port_Stanley_Airport	550
322398	FK-0017	small_airport	Chartres Airport	-51.719.307	-60.062.361	SA	Falkland Islands	FK	(unassigned)	FK-U-A	U-A	Chartres	0	2017-03-14T14:00:47+00:00	50	1	nan	nan
41530	FK-0005	small_airport	Goose Green Airfield	-51.819.282	-58.980.893	SA	Falkland Islands	FK	(unassigned)	FK-U-A	U-A	Goose Green	0	2017-03-15T15:09:26+00:00	50	65	nan	nan
322500	FK-0033	small_airport	Port Howard Airstrip	-51.613.225	-59.516.675	SA	Falkland Islands	FK	(unassigned)	FK-U-A	U-A	Port Howard	0	2017-03-27T10:34:28+00:00	50	10	nan	nan
41528	FK-0003	small_airport	Sea Lion Lodge Airstrip	-52.428.215	-59.077.744	SA	Falkland Islands	FK	(unassigned)	FK-U-A	U-A	Sea Lion Island	0	2017-03-27T10:43:20+00:00	50	elevation_ft	nan	nan
322421	FK-0029	small_airport	Beaver Island Airport	-5.184.025	-6.123.365	SA	Falkland Islands	FK	(unassigned)	FK-U-A	U-A	Beaver Island	0	2017-03-15T14:57:37+00:00	50	244	nan	nan
322419	FK-0027	small_airport	Bleaker Island Airport	-52.181.403	-58.858.788	SA	Falkland Islands	FK	(unassigned)	FK-U-A	U-A	Bleaker Island	0	2017-03-15T14:43:05+00:00	50	75	nan	nan
43041	FK-0011	small_airport	Carcass Island Landing Strip	-51.263.671.875	-60.592.079.162.597.600	SA	Falkland Islands	FK	(unassigned)	FK-U-A	U-A	Carcass Island	0	2009-01-14T19:49:04+00:00	50	1	nan	nan
322405	FK-0024	small_airport	Douglas Station Airport	-51.459.942	-58.612.131	SA	Falkland Islands	FK	(unassigned)	FK-U-A	U-A	Douglas	0	2017-03-14T14:44:55+00:00	50	65	nan	nan


CREATE TABLE airports_fk_new (
  "id" DOUBLE,
  "ident" VARCHAR,
  "type" VARCHAR,
  "name" VARCHAR,
  "latitude_deg" VARCHAR,
  "longitude_deg" VARCHAR,
  "continent" VARCHAR,
  "country_name" VARCHAR,
  "iso_country" VARCHAR,
  "region_name" VARCHAR,
  "iso_region" VARCHAR,
  "local_region" VARCHAR,
  "municipality" VARCHAR,
  "scheduled_service" VARCHAR,
  "last_updated" VARCHAR,
  "score" VARCHAR,
  "elevation_ft" VARCHAR,
  "wikipedia_link" VARCHAR,
  "keywords" VARCHAR
);