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 |
---|---|---|---|---|---|---|---|---|---|
52996 | 52996 | 1933-06-24 | 2 | b | Editorial on Jiang Jieshi's compromise with Japanese. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091270 | 24091270 | |
53008 | 53008 | 1933-06-24 | 5 | a | Couplets in memory of Liang Shiyi. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091271 | 24091271 | |
53009 | 53009 | 1933-06-24 | 5 | e | Folk songs from Guangdong on the compromise with Japanese. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091271 | 24091271 | |
53010 | 53010 | 1933-06-24 | 5 | e | Chinese Society (zhonghua gonghui) in Melbourne farewells Chinese consuls Wu Qinxun and Jiang Jiedong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091271 | 24091271 | |
53011 | 53011 | 1933-06-24 | 5 | f | Chinese communities in Sydney and Melbourne donate to the war of resistance in China and names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091271 | 24091271 | |
53020 | 53020 | 1933-06-24 | 6 | d | Australia news/ Japanese fishermen murdered in Darwin. Police in Sydney raid shops. Cabinet factory in Perth on fire. Japanese steal marine products in north Australian water territories. Australian and New Zealand to have a joint exercise. Heavy fog in Sydney harbour. Chinese man robbed in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091274 | 24091274 | |
53021 | 53021 | 1933-06-24 | 6 | f | A census notice issued by the Commonwealth government of Australia on 30 June 1933. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091274 | 24091274 | |
53022 | 53022 | 1933-06-24 | 6 | a | Advertisement of the Bank of New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091274 | 24091274 |
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]);