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

Shapes Country1

@kaggle.hassansv_ufo_sightings_since_1906.shapes_country1

6.27 KB
30 rows
7 columns

shapes Shapes	australia AUSTRALIA	canada CANADA	denmark DENMARK	united_kingdom UNITED KINGDOM	usa USA	grand_total Grand Total
Grand Total	538	3000	105	1905	65114	70662
light	119	655	20	361	13473	14628
triangle	43	268	9	169	6549	7038
circle	62	284	10	243	6118	6717
fireball	34	218	9	117	5148	5526
unknown	25	207	8	92	4567	4899
other	40	241	9	133	4466	4889
sphere	15	205	7	158	4347	4732
disk	50	198	6	102	4121	4477
oval	30	130	7	86	3032	3285


CREATE TABLE shapes_country1 (
  "shapes" VARCHAR,
  "australia" DOUBLE,
  "canada" DOUBLE,
  "denmark" DOUBLE,
  "united_kingdom" DOUBLE,
  "usa" BIGINT,
  "grand_total" BIGINT
);