wh_visits_daily_agg

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

421,928 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: admin, visit_date (date)

Next page

CREATE TABLE wh_visits_daily_agg (
    admin              TEXT NOT NULL,
    visit_date         TEXT NOT NULL,
    visitee_name_last  TEXT,
    visitee_name_first TEXT,
    n_visits           INTEGER NOT NULL,
    n_unique_visitors  INTEGER NOT NULL,             -- distinct visitor_name_hash
    n_tour_visits      INTEGER NOT NULL,
    total_people       INTEGER,
    PRIMARY KEY (admin, visit_date, visitee_name_last, visitee_name_first)
);
CREATE INDEX idx_wvda_date ON wh_visits_daily_agg(visit_date);
CREATE INDEX idx_wvda_visitee ON wh_visits_daily_agg(visitee_name_last, visitee_name_first);