home / sfi

search_index

Data license: ODbL · Data source: State Ethics Commission

0 rows where category = 1

This data as json

0 records

CREATE TABLE "search_index" (
   [type] TEXT,
   [key] TEXT,
   [title] TEXT,
   [timestamp] TEXT,
   [category] INTEGER REFERENCES [categories]([id]),
   [is_public] INTEGER NOT NULL DEFAULT '0',
   [search_1] TEXT,
   [search_2] TEXT,
   [search_3] TEXT,
   PRIMARY KEY ([type], [key])
);
CREATE INDEX [idx_search_index_is_public]
    ON [search_index] ([is_public]);
CREATE INDEX [idx_search_index_category]
    ON [search_index] ([category]);
CREATE INDEX [idx_search_index_timestamp]
    ON [search_index] ([timestamp]);
Powered by Datasette · Queries took 6.896ms · Data license: ODbL · Data source: State Ethics Commission