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 |
---|---|---|---|---|---|---|---|---|---|
51145 | 51145 | 1932-02-06 | 2 | a | First part of an essay on the war between China and Japan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090686 | 24090686 | |
51148 | 51148 | 1932-02-06 | 3 | a | Japanese government proposes to set up new administrative regions in Manchuria. | Japan | http://trove.nla.gov.au/newspaper/page/24090685 | 24090685 | |
51149 | 51149 | 1932-02-06 | 3 | a | Truce agreement between Tibet and Xikang province in China. | China | http://trove.nla.gov.au/newspaper/page/24090685 | 24090685 | |
51155 | 51155 | 1932-02-06 | 5 | a | American government closely watching Japanese in Shanghai. | America | http://trove.nla.gov.au/newspaper/page/24090689 | 24090689 | |
51156 | 51156 | 1932-02-06 | 5 | a | American parliamentarians suggest to break off economic relations with Japan. | America | http://trove.nla.gov.au/newspaper/page/24090689 | 24090689 | |
51157 | 51157 | 1932-02-06 | 5 | a | Associations in Shanghai request American government to uphold justice. | China | http://trove.nla.gov.au/newspaper/page/24090689 | 24090689 | |
51164 | 51164 | 1932-02-06 | 6 | a | A notice issued by the Dongguan gong yi tang in Sydney on the transfer of remains of deceased fellows back to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090692 | 24090692 | |
51169 | 51169 | 1932-02-06 | 7 | a | The fall of Heilongjiang province under Japanese invasion and the resistance of Chinese people. | China | http://trove.nla.gov.au/newspaper/page/24090691 | 24090691 | |
51171 | 51171 | 1932-02-06 | 8 | a | Japanese troops invade Shanghai and their fierce battles with the 19th Route Army in the north suburbs. Chinese government to declare war with Japan. Atrocities of Japanese army in Shanghai. Japanese warship fire Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24090694 | 24090694 |
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]);