Article Index

6 rows where column = "e" and date = "1923-12-01"

Filter results

This data as json, CSV (advanced)

Suggested facets: page, source, page_url, trove_id, date (date)

Link rowid ▼ date page column title description source page_url trove_id
40748 40748 1923-12-01 3 e   Bank robbery in Indiana, United States of America. America http://trove.nla.gov.au/newspaper/page/24094631 24094631
40749 40749 1923-12-01 3 e   Another earthquake hits Tokyo. America http://trove.nla.gov.au/newspaper/page/24094631 24094631
40750 40750 1923-12-01 3 e   Six Spanish people try to blow up Spanish and Italian consulates in Philadelphia, America. America http://trove.nla.gov.au/newspaper/page/24094631 24094631
40760 40760 1923-12-01 7 e   Chinese Chamber of Commerce organises a fundraising concert/ party in the city Town Hall for Sydney hospital and those who are involved include Ye Tonggui and his wife, Zhang Maokuan, Zhu Hechou, Liu Guangfu, and Ma Zanfen. Tung Wah http://trove.nla.gov.au/newspaper/page/24094635 24094635
40763 40763 1923-12-01 8 e   Gold price in Hong Kong. Tung Wah http://trove.nla.gov.au/newspaper/page/24094638 24094638
40764 40764 1923-12-01 8 e   Liner timetable. Tung Wah http://trove.nla.gov.au/newspaper/page/24094638 24094638

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]);