uap_deploy
Queries
- High Credibility Cases
- All Geolocated Events
- Corroborated Cases
- Events by source
- Balanced random sample
- Graph nodes — all credibility >= 5 corroborated events
- Graph links — credibility >= 5 pairs
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
Many 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
362,123 rows
evidence
id, event_id, report_id, evidence_type, description, source_url, file_path, confidence, created_at
208 rows