This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46653 | 46653 | 1928-01-14 | 2 | b | Editorial by Tung Wah Times on the Communist disasters in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098664 | 24098664 | |
46671 | 46671 | 1928-01-14 | 5 | f | Advertisement for Reo Motors Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098665 | 24098665 | |
46673 | 46673 | 1928-01-14 | 7 | a | The sign of Red Cross in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098667 | 24098667 | |
46674 | 46674 | 1928-01-14 | 7 | a | Australia news/ British woman is deported from Sydney because she comes from China. Western visitor on the Communist disaster in China. Chinese businessman Lei Peng exports Australian dry fruits into China. Grain supply to the British troops in China. The Webster's Company in Brisbane on blaze. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098667 | 24098667 |
JSON shape: default, array, newline-delimited
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]);