This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
49493 | 49493 | 1930-09-13 | 2 | c | Wang Jingwei and Yan Xishan on the Party affairs. Organisation of the Beijing government. Communist forces in Anhui. Wu Peifu is ill. Yan Mengyu and the Beijing University. Zhang Huizan in Nanxun. Lu Xingbang stages another counterattack. Battles along the Tianjin-Pukou railway. Zhu Hexiang on the Communist disasters. More report on the wars in China. | China | http://trove.nla.gov.au/newspaper/page/24099773 | 24099773 | |
49497 | 49497 | 1930-09-13 | 3 | c | Soviet Russia import Chinese tea. | China | http://trove.nla.gov.au/newspaper/page/24099772 | 24099772 | |
49498 | 49498 | 1930-09-13 | 3 | c | Japan in economic depression. | Japan | http://trove.nla.gov.au/newspaper/page/24099772 | 24099772 | |
49501 | 49501 | 1930-09-13 | 5 | c | Japanese archaeologists are digging ancient graves in south Manchuria. | Japan | http://trove.nla.gov.au/newspaper/page/24099774 | 24099774 | |
49504 | 49504 | 1930-09-13 | 8 | c | A notice issued by the Chinese Chamber of Commerce in Sydney on the payment of personal income tax before departure Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099779 | 24099779 | |
49505 | 49505 | 1930-09-13 | 8 | c | Floods in India. | Other... | http://trove.nla.gov.au/newspaper/page/24099779 | 24099779 | |
49506 | 49506 | 1930-09-13 | 8 | c | Hurricane in central America. | America | http://trove.nla.gov.au/newspaper/page/24099779 | 24099779 |
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]);