events

7,754 rows where country = "fr"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime_confidence, geo_confidence, location_type, obs_anti_gravity, obs_hypersonic, obs_low_observ, obs_trans_medium, elizondo_tier, source_name, datetime_utc (date), datetime_original (date), scoring_updated_at (date), created_at (date), updated_at (date)

Next page

CREATE TABLE [events] (
   [id] TEXT PRIMARY KEY,
   [canonical_id] TEXT,
   [datetime_utc] TEXT,
   [datetime_original] TEXT,
   [datetime_confidence] TEXT,
   [city] TEXT,
   [state] TEXT,
   [country] TEXT,
   [latitude] FLOAT,
   [longitude] FLOAT,
   [geo_confidence] TEXT,
   [shape] TEXT,
   [duration_seconds] INTEGER,
   [witness_count] TEXT,
   [witness_type] TEXT,
   [description] TEXT,
   [credibility_score] FLOAT,
   [anomaly_score] TEXT,
   [scoring_version] TEXT,
   [scoring_updated_at] TEXT,
   [created_at] TEXT,
   [updated_at] TEXT
, content_hash TEXT, location_type TEXT DEFAULT 'surface', altitude_km REAL, orbit_inclination REAL, celestial_body TEXT DEFAULT 'earth', ra_degrees REAL, dec_degrees REAL, obs_anti_gravity BOOLEAN DEFAULT 0, obs_sudden_accel BOOLEAN DEFAULT 0, obs_hypersonic BOOLEAN DEFAULT 0, obs_low_observ BOOLEAN DEFAULT 0, obs_trans_medium BOOLEAN DEFAULT 0, observable_count INTEGER DEFAULT 0, elizondo_tier TEXT, source_name TEXT);
CREATE INDEX idx_events_content_hash ON events(content_hash);
CREATE INDEX idx_events_credibility ON events(credibility_score DESC);
CREATE INDEX idx_events_datetime ON events(datetime_utc);
CREATE INDEX idx_events_country ON events(country);
CREATE INDEX idx_events_shape ON events(shape);
CREATE INDEX idx_obs_trans_medium ON events(obs_trans_medium);
CREATE INDEX idx_obs_hypersonic ON events(obs_hypersonic);
CREATE INDEX idx_obs_anti_gravity ON events(obs_anti_gravity);
CREATE INDEX idx_obs_sudden_accel ON events(obs_sudden_accel);
CREATE INDEX idx_obs_low_observ ON events(obs_low_observ);
CREATE INDEX idx_observable_count ON events(observable_count);
CREATE INDEX idx_elizondo_tier ON events(elizondo_tier);