This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29351 | 29351 | 1914-10-31 | 6 | a | Chinese Consulate-General in New Zealand reports that Chinese passenger Ye Zuoyi jumps into the sea on his way from Tahiti to New Zealand, and report by the captain. | New Zealand | http://trove.nla.gov.au/newspaper/page/24093308 | 24093308 | |
29352 | 29352 | 1914-10-31 | 6 | a-b | Beijing news/ Amount of bonds to be issued by the Chinese government. Chinese government discusses protection of overseas Chinese in Nanyang region. Chinese returned from overseas can travel free of charge. Chinese authority restricts divorce. Japanese government keeps Chinese revolutionaries under control. Japanese troops in Longkou, Shandong province, and their artillery. Japanese troops on their way to attack German in Jiaozhou. A warning issued by German governor in Qingdao. | China | http://trove.nla.gov.au/newspaper/page/24093308 | 24093308 | |
29353 | 29353 | 1914-10-31 | 6 | b-c | Xiangshan county in Guangdong has turned into a world of bandits. | China | http://trove.nla.gov.au/newspaper/page/24093308 | 24093308 | |
29354 | 29354 | 1914-10-31 | 6 | c | Miscellaneous report on the Chinese politics and officialdom. | China | http://trove.nla.gov.au/newspaper/page/24093308 | 24093308 |
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]);