Dataset: Ufo Sightings

About this Dataset

Ufo Sightings

Context

This data was scraped from the National UFO Reporting Center (http://www.nuforc.org/). Once scraped it was cleaned as well.

Content

Each entry has the date, the city (most are in the USA), state, shape of object, duration, date, and a summary. Some also include a "hoax" label in the description.

Acknowledgements

Huge thanks to Alex Heaton, Imran Manji, and Navya Sandadi.

Tables

Clean Ufo Data

@kaggle.thaddeussegura_ufo_sightings.clean_ufo_data

9.26 MB
120785 rows
9 columns


CREATE TABLE clean_ufo_data (
  "id" BIGINT,
  "occurred_date_time" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "shape" VARCHAR,
  "duration" VARCHAR,
  "summary" VARCHAR,
  "details_url" VARCHAR,
  "posted_date" TIMESTAMP
);