Article Index

5 rows where date = "1923-06-30" and page_url = "http://trove.nla.gov.au/newspaper/page/24094460"

Filter results

This data as json, CSV (advanced)

Suggested facets: page, column, date (date)

Link rowid ▼ date page column title description source page_url trove_id
40045 40045 1923-06-30 6 a-b   A public notice issued by the Chinese Chamber of Commerce in New South Wales on the sales of public properties in Guangzhou and China. Tung Wah http://trove.nla.gov.au/newspaper/page/24094460 24094460
40046 40046 1923-06-30 6 b   Japan starts negotiation with Soviet Russian authority over the previous treaties. Japan http://trove.nla.gov.au/newspaper/page/24094460 24094460
40047 40047 1923-06-30 6 b   Smallpox in Britain and the precautions. Britain http://trove.nla.gov.au/newspaper/page/24094460 24094460
40048 40048 1923-06-30 6 b   Chinese business communities protest against foreign intervention with Chinese internal politics. America http://trove.nla.gov.au/newspaper/page/24094460 24094460
40049 40049 1923-06-30 6-7 b-a   Fierce battle in Dongjiang (Boluo) area, Guangdong, between Guangdong and Guangxi armies. China http://trove.nla.gov.au/newspaper/page/24094460 24094460

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