UFO Sightings Since 1906

A Century of UFO Sightings: Trends, Patterns, and Anomalies

@kaggle.hassansv_ufo_sightings_since_1906

Table List

12 tables(6.57 MB)

Ufo Day

Ufo Sightings Scrubbed

Avg Shape Duration

Ufo Year

Shapes Country

Ufo Sightings Scrubbed

@kaggle.hassansv_ufo_sightings_since_1906.ufo_sightings_scrubbed

6.19 MB
80332 rows
14 columns

datetime Datetime	day Day	city City	state State	country Country	shape Shape	duration_seconds Duration (seconds)	duration_hours_min Duration (hours/min)	comments Comments	day_posted Day Posted	date_posted Date Posted	latitude Latitude	longitude Longitude	days_count Days Count
10/10/1949 20:30	Monday	san marcos	tx	us	cylinder	2700	45 minutes	This event took place in early fall around 1949-50. It occurred after a Boy Scout meeting in the Baptist Church. The Baptist Church sit	Tuesday	Tue Apr 27 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	29.8830556	-97.9411111	19923
10/10/1949 21:00	Monday	lackland afb	tx	nan	light	7200	1-2 hrs	1949 Lackland AFB&#44 TX. Lights racing across the sky & making 90 degree turns on a dime.	Friday	Fri Dec 16 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	29.38421	-98.581082	20521
10/10/1955 17:00	Monday	chester (uk/england)	nan	gb	circle	20	20 seconds	Green/Orange circular disc over Chester&#44 England	Monday	Mon Jan 21 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	53.2	-2.916667	19096
10/10/1956 21:00	Wednesday	edna	tx	us	circle	20	1/2 hour	My older brother and twin sister were leaving the only Edna theater at about 9 PM&#44...we had our bikes and I took a different route home	Saturday	Sat Jan 17 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	28.9783333	-96.6458333	17265
10/10/1960 20:00	Monday	kaneohe	hi	us	light	900	15 minutes	AS a Marine 1st Lt. flying an FJ4B fighter/attack aircraft on a solo night exercise&#44 I was at 50&#44000&#39 in a "clean" aircraft (no ordinan	Thursday	Thu Jan 22 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	21.4180556	-157.8036111	15809
10/10/1961 19:00	Tuesday	bristol	tn	us	sphere	300	5 minutes	My father is now 89 my brother 52 the girl with us now 51 myself 49 and the other fellow which worked with my father if he&#39s still livi	Friday	Fri Apr 27 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	36.595	-82.1888889	16635
10/10/1965 21:00	Sunday	penarth (uk/wales)	nan	gb	circle	180	about 3 mins	penarth uk circle 3mins stayed 30ft above me for 3 mins slowly moved of and then with the blink of the eye the speed was unreal	Tuesday	Tue Feb 14 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	51.434722	-3.18	14737
10/10/1965 23:45	Sunday	norwalk	ct	us	disk	1200	20 minutes	A bright orange color changing to reddish color disk/saucer was observed hovering above power transmission lines.	Saturday	Sat Oct 02 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	41.1175	-73.4083333	12410
10/10/1966 20:00	Monday	pell city	al	us	disk	180	3 minutes	Strobe Lighted disk shape object observed close&#44 at low speeds&#44 and low altitude in Oct 1966 in Pell City Alabama	Thursday	Thu Mar 19 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	33.5861111	-86.2861111	15501
10/10/1966 21:00	Monday	live oak	fl	us	disk	120	several minutes	Saucer zaps energy from powerline as my pregnant mother receives mental signals not to pass info	Wednesday	Wed May 11 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	30.2947222	-82.9841667	14093


CREATE TABLE ufo_sightings_scrubbed (
  "datetime" VARCHAR,
  "day" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR,
  "shape" VARCHAR,
  "duration_seconds" VARCHAR,
  "duration_hours_min" VARCHAR,
  "comments" VARCHAR,
  "day_posted" VARCHAR,
  "date_posted" TIMESTAMP,
  "latitude" VARCHAR,
  "longitude" DOUBLE,
  "days_count" BIGINT
);