This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34633 | 34633 | 1919-06-28 | 8 | a | Chinese Consul in Samoa Lin Baoheng reports from Apia about the celebration parade on the end of the World War I and the involvement of the Chinese communities there. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097774 | 24097774 | |
34634 | 34634 | 1919-06-28 | 8 | a-b | Beijing news/ Report on the peace talks between the south and the north. President Xu Shichang on the peace talks. | China | http://trove.nla.gov.au/newspaper/page/24097774 | 24097774 | |
34635 | 34635 | 1919-06-28 | 8 | b-c | Guangdong news/ Salary payment to the speaker of the provincial legislature assembly. Chaos in the provincial legislature assembly. Flood in Dongjiang area. New management authority to be organised for the Guangzhou-Hankou railway. Businessmen in Beijing and Shanghai organise to protect local products. Efforts in Zhaoqing to stabilise the rice market. Deng Muzhou, of the Wing On Company in Shanghai, writes and requests the provincial authority to suppress bandits because his uncle is kidnaped. | China | http://trove.nla.gov.au/newspaper/page/24097774 | 24097774 |
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]);