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 |
---|---|---|---|---|---|---|---|---|---|
52657 | 52657 | 1933-03-18 | 2 | b | Editorial on the Chinese strategies to fight Japanese invaders. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091156 | 24091156 | |
52666 | 52666 | 1933-03-18 | 5 | c | Maid in Sun Zhesheng's house. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091157 | 24091157 | |
52667 | 52667 | 1933-03-18 | 5 | e | A woman in Belgium buys insurance for her beautiful breasts. Wu Peifu's poems. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091157 | 24091157 | |
52668 | 52668 | 1933-03-18 | 5 | f | Chinese communities in Melbourne donate to the war of resistance in China and names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091157 | 24091157 | |
52679 | 52679 | 1933-03-18 | 6 | e | Australia news/ Federal government to reform the tax system. German warships come to visit Australia. The Chinese Society (zhong hua gong hui) sends telegram to the Chinese army in the Rehe front. Chinese man in Sydney arrested for smuggled opium. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091160 | 24091160 |
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]);