This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34466 | 34466 | 1919-05-10 | 2 | d | Chinese delegation and their speech at the Paris peace conference. | China | http://trove.nla.gov.au/newspaper/page/24097710 | 24097710 | |
34467 | 34467 | 1919-05-10 | 2 | e-f | Correspondence between Zhu Qiqin and Tang Shaoyi on the peace talks in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24097710 | 24097710 | |
34468 | 34468 | 1919-05-10 | 2 | f | Sun Yatsen in Shanghai has a new plan for industrial development. | China | http://trove.nla.gov.au/newspaper/page/24097710 | 24097710 | |
34469 | 34469 | 1919-05-10 | 3 | a | Zhang Shaozeng on the peace talks between the south and the north. | China | http://trove.nla.gov.au/newspaper/page/24097709 | 24097709 | |
34471 | 34471 | 1919-05-10 | 3 | c-d | News about Siberia. | China | http://trove.nla.gov.au/newspaper/page/24097709 | 24097709 | |
34475 | 34475 | 1919-05-10 | 6 | c | Different social responses to the government's order to destroy all opium. | China | http://trove.nla.gov.au/newspaper/page/24097714 | 24097714 | |
34480 | 34480 | 1919-05-10 | 8 | a-c | China news/ Russia encourage independence movement in Mongolia. The Wing On Company in Shanghai has new development plan (with theatre and playgrounds). Guangxi army attack Hunan. Casualties of the epidemic in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24097716 | 24097716 | |
34481 | 34481 | 1919-05-10 | 8 | c-d | Guangdong news/ The power of the military government. Li Chun is working hard for peace. Charity institutions in Guangdong and their work to help famine victims. Rice price going down in Guangzhou. Preparation for railway construction from Guangzhou to Macao. | China | http://trove.nla.gov.au/newspaper/page/24097716 | 24097716 |
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]);