Article Index

3 rows where column = "a" and date = "1899-08-05"

Filter results

This data as json, CSV (advanced)

Suggested facets: date (date)

Link rowid ▼ date page column title description source page_url trove_id
3235 3235 1899-08-05 2 a   Imperial edicts on the appointment of officials.   http://trove.nla.gov.au/newspaper/page/24102489 24102489
3241 3241 1899-08-05 3 a   Explorers returning to Belgium; strikes in America followed by riots; Japan plans to help China to reorganise its troops and navy; France has new gunboats; new balloon; locally-produced clothing for sale; 350 children escape from a fire.   http://trove.nla.gov.au/newspaper/page/24102488 24102488
3258 3258 1899-08-05 4 a   Liner timetable to Asian ports.   http://trove.nla.gov.au/newspaper/page/24102491 24102491

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 
CREATE TABLE [article_index] (
   [date] TEXT,
   [page] TEXT,
   [column] TEXT,
   [title] TEXT,
   [description] TEXT,
   [source] TEXT,
   [page_url] TEXT,
   [trove_id] TEXT
);
CREATE INDEX [idx_article_index_date]
    ON [article_index] ([date]);