This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
51777 | 51777 | 1932-08-06 | 8 | a | Japanese troops stop to attack Rehe. | China | http://trove.nla.gov.au/newspaper/page/24090902 | 24090902 | |
51778 | 51778 | 1932-08-06 | 8 | a | Japanese control the postal service in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090902 | 24090902 | |
51779 | 51779 | 1932-08-06 | 8 | a | A Russian man is to be executed for assassination of French President. | France | http://trove.nla.gov.au/newspaper/page/24090902 | 24090902 | |
51780 | 51780 | 1932-08-06 | 8 | a | Martial law proclaimed in Washington. | America | http://trove.nla.gov.au/newspaper/page/24090902 | 24090902 | |
51781 | 51781 | 1932-08-06 | 8 | b | Hu Shi is elected member of the Preussische Akademie Der Wisseuschalteu. | Germany | http://trove.nla.gov.au/newspaper/page/24090902 | 24090902 | |
51782 | 51782 | 1932-08-06 | 8 | b | Tang Yulin is determined to guard Rehe. | China | http://trove.nla.gov.au/newspaper/page/24090902 | 24090902 | |
51783 | 51783 | 1932-08-06 | 8 | b | Chinese community in Singapore and a church chaos. | Singapore | http://trove.nla.gov.au/newspaper/page/24090902 | 24090902 | |
51784 | 51784 | 1932-08-06 | 8 | c | Floods in Guangdong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24090902 | 24090902 | |
51785 | 51785 | 1932-08-06 | 8 | c | Election in Germany and the chaos. | Germany | http://trove.nla.gov.au/newspaper/page/24090902 | 24090902 | |
51786 | 51786 | 1932-08-06 | 8 | c | Rumour says General Ma Zhanshan has been killed. | Japan | http://trove.nla.gov.au/newspaper/page/24090902 | 24090902 | |
51787 | 51787 | 1932-08-06 | 8 | d | Chinese government delays to repay the Boxer Indemnity. | China | http://trove.nla.gov.au/newspaper/page/24090902 | 24090902 | |
51788 | 51788 | 1932-08-06 | 8 | e | New Japanese consul to Sydney. | Japan | http://trove.nla.gov.au/newspaper/page/24090902 | 24090902 | |
51789 | 51789 | 1932-08-06 | 8 | e | Foreigners in Manchuria under the Japanese rule. | Britain | http://trove.nla.gov.au/newspaper/page/24090902 | 24090902 | |
51790 | 51790 | 1932-08-06 | 8 | e | Zhang Xueliang is ready to fight back Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24090902 | 24090902 | |
51791 | 51791 | 1932-08-06 | 8 | f | Australia news/ China man in Sydney hangs himself. Police in Sydney arrest the communists. Visitor talks about China in Sydney after his return from Hong Kong. Chinese man on trial in Sydney for the death of a white man. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090902 | 24090902 |
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]);