search_index

2,501,052 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: timestamp (date)

Next page

CREATE TABLE [search_index] (
   [type] TEXT,
   [key] TEXT,
   [program] TEXT,
   [timestamp] TEXT,
   [fiscal_year] TEXT,
   [amount] FLOAT,
   [payer] TEXT,
   [is_aggregated] INTEGER NOT NULL DEFAULT 0,
   [search_1] TEXT,
   [city] TEXT,
   [province] TEXT,
   [country] TEXT,
   [recipient] TEXT,
   [recipient_type] TEXT,
   [description] TEXT,
   [award_type] TEXT,
   [source_url] TEXT,
   PRIMARY KEY ([type], [key])
);
CREATE INDEX [idx_search_index_type]
    ON [search_index] ([type]);
CREATE INDEX [idx_search_index_program]
    ON [search_index] ([program]);
CREATE INDEX [idx_search_index_payer]
    ON [search_index] ([payer]);
CREATE INDEX [idx_search_index_award_type]
    ON [search_index] ([award_type]);
CREATE INDEX [idx_search_index_recipient]
    ON [search_index] ([recipient]);
CREATE INDEX [idx_search_index_is_aggregated]
    ON [search_index] ([is_aggregated]);
CREATE INDEX [idx_search_index_province]
    ON [search_index] ([province]);
CREATE INDEX [idx_search_index_country]
    ON [search_index] ([country]);