event_links

22,180 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: days_apart, created_at (date)

Next page

CREATE TABLE event_links (
        id TEXT PRIMARY KEY,
        event_id_1 TEXT NOT NULL,
        event_id_2 TEXT NOT NULL,
        distance_km REAL,
        days_apart INTEGER,
        link_type TEXT DEFAULT 'spatial_temporal',
        source_1 TEXT,
        source_2 TEXT,
        notes TEXT,
        created_at TEXT
    );
CREATE INDEX idx_links_1 ON event_links(event_id_1);
CREATE INDEX idx_links_2 ON event_links(event_id_2);
CREATE INDEX idx_el_1 ON event_links(event_id_1);
CREATE INDEX idx_el_2 ON event_links(event_id_2);
CREATE INDEX idx_el_source1 ON event_links(source_1);
CREATE INDEX idx_el_source2 ON event_links(source_2);