home

uap_deploy

Custom SQL query

Queries

  • High credibility cases

Tables

access_tokens

token_id, token_secret, email, name, note, granted_at, expires_at, revoked, last_used_at

0 rows

event_links

id, event_id_1, event_id_2, distance_km, days_apart, link_type, source_1, source_2, notes, created_at

21,017 rows

events

id, canonical_id, datetime_utc, datetime_original, datetime_confidence, city, state, country, latitude, longitude, geo_confidence, shape, duration_seconds, witness_count, witness_type, description, credibility_score, anomaly_score, scoring_version, scoring_updated_at, created_at, updated_at, content_hash, location_type, altitude_km, orbit_inclination, celestial_body, ra_degrees, dec_degrees, obs_anti_gravity, obs_sudden_accel, obs_hypersonic, obs_low_observ, obs_trans_medium, observable_count, elizondo_tier, source_name

373,221 rows

evidence

id, event_id, report_id, evidence_type, description, source_url, file_path, confidence, created_at

208 rows

reports

id, event_id, source_id, original_id, raw_file, access_date, ingestion_script

456,190 rows

sources

id, name, tier, license, base_url, description, created_at

66 rows

Powered by Datasette · Queries took 13.041ms