Article Index

9 rows where date = "1924-03-29" and page_url = "http://trove.nla.gov.au/newspaper/page/24100663"

Filter results

This data as json, CSV (advanced)

Suggested facets: column, source, date (date)

Link rowid ▼ date page column title description source page_url trove_id
41330 41330 1924-03-29 3 a   An attempt to assassinate Governor Zhao Hengti in Hunan and the investigation. China http://trove.nla.gov.au/newspaper/page/24100663 24100663
41331 41331 1924-03-29 3 b   Support and opposition to the election of Chinese Deputy President in Beijing. China http://trove.nla.gov.au/newspaper/page/24100663 24100663
41332 41332 1924-03-29 3 b   The case of gold Franc will be heard by an international tribunal. China http://trove.nla.gov.au/newspaper/page/24100663 24100663
41333 41333 1924-03-29 3 b-c   American businessmen gather in New York and will help silk industry in China. America http://trove.nla.gov.au/newspaper/page/24100663 24100663
41334 41334 1924-03-29 3 c-d   Archaeologist in Gansu province, China, finds pottery and others belonging to the Yin and Shang dynasties. China http://trove.nla.gov.au/newspaper/page/24100663 24100663
41335 41335 1924-03-29 3 d   A Japanese submarine sinks after collision with a warship. China http://trove.nla.gov.au/newspaper/page/24100663 24100663
41336 41336 1924-03-29 3 d-e   China and Russia blame each other for the failure of treaty negotiation. Hong Kong http://trove.nla.gov.au/newspaper/page/24100663 24100663
41337 41337 1924-03-29 3 e   Irish army fire at British soldiers and the casualties. Britain http://trove.nla.gov.au/newspaper/page/24100663 24100663
41338 41338 1924-03-29 3 e   American consul in Guangzhou asks for protection on behalf of American businessmen there. America http://trove.nla.gov.au/newspaper/page/24100663 24100663

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