Name: UFO Sightings
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

UFO Sightings

The National UFO Research Center (NUFORC) collects and serves over 100,000 reports of UFO sightings.
This dataset contains the report content itself including the time, location duration, and other attributes in both the raw form as it is recorded on the NUFORC site as well as a refined, standardized form that also contains lat/lon coordinates.

Reports

The raw reports are line-delimited JSON documents that contain the report information exactly as it appears on the NUFORC site.
This is the starting point for the "cleaner" version of the dataset.
There are quite a few inconsistencies in this dataset in terms of formatting, errors, etc.

The CSV reports have cleaned state and city names, standardized dates and lat/lon values of the cities in which the sightings occurred.
It's easier to work with but has some opinions.

Past versions were significantly larger insofar as they were much less filtered. Recent updates to the NUFORC site to include images, as well as the usefulness of including geocoding data in the dataset, led to trading volume for quality in the hopes that this serves as a more dynamic dataset with wider possibilities.

Tables

Ufo Data Nuforc

@kaggle.joebeachcapital_ufo_sightings.ufo_data_nuforc

139.71 kB
1,317 rows
13 columns

CREATE TABLE ufo_data_nuforc (
  "posted" TIMESTAMP,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "shape" VARCHAR,
  "duration" VARCHAR,
  "summary" VARCHAR,
  "images" VARCHAR,
  "img_link" VARCHAR,
  "lat" DOUBLE,
  "lng" DOUBLE,
  "population" BIGINT
);