This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 34875 | 34875 | 1919-09-13 | 2 | a-c | Third and final part of the editorial by Tung Wah Times expresses pessimism on the peace talks in China between the south and the north. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097860 | 24097860 | |
| 34876 | 34876 | 1919-09-13 | 2 | c-e | Second part of the article written by Liang Qichao on the failure of China's diplomatic policy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097860 | 24097860 | |
| 34877 | 34877 | 1919-09-13 | 2 | e-f | Three Chinese delegates to the Paris Peace Conference visit America and their talks there. | America | http://trove.nla.gov.au/newspaper/page/24097860 | 24097860 | |
| 34878 | 34878 | 1919-09-13 | 2 | f | Secret plan of The Allies to carve up China. | America | http://trove.nla.gov.au/newspaper/page/24097860 | 24097860 | |
| 34879 | 34879 | 1919-09-13 | 3 | a | Chinese community in San Diego writes to American senator on the Shandong issues. | America | http://trove.nla.gov.au/newspaper/page/24097859 | 24097859 | |
| 34880 | 34880 | 1919-09-13 | 3 | a | Japan's ambition for China and their diplomatic talks with other countries. | China | http://trove.nla.gov.au/newspaper/page/24097859 | 24097859 | |
| 34881 | 34881 | 1919-09-13 | 3 | b | A nation-wide conference of textile industry in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24097859 | 24097859 | |
| 34882 | 34882 | 1919-09-13 | 3 | b | American universities seek to recruit some more Chinese students. | America | http://trove.nla.gov.au/newspaper/page/24097859 | 24097859 | |
| 34883 | 34883 | 1919-09-13 | 3 | b | American view on the boycott to Japanese goods in Shanghai. | America | http://trove.nla.gov.au/newspaper/page/24097859 | 24097859 | |
| 34884 | 34884 | 1919-09-13 | 3 | c | Russia's plot in Mongolia and Tibet. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097859 | 24097859 | |
| 34885 | 34885 | 1919-09-13 | 3 | c | Boycott to Japanese goods in China and its effect on Shandong issues. | Britain | http://trove.nla.gov.au/newspaper/page/24097859 | 24097859 | |
| 34886 | 34886 | 1919-09-13 | 3 | d | Chinese government in deficit. | China | http://trove.nla.gov.au/newspaper/page/24097859 | 24097859 | |
| 34887 | 34887 | 1919-09-13 | 3 | d | An attempt to assassinate Japanese administrator in Korea. | Canada | http://trove.nla.gov.au/newspaper/page/24097859 | 24097859 | |
| 34888 | 34888 | 1919-09-13 | 3 | d | Japanese foreign secretary talks about Shandong issues in America. | America | http://trove.nla.gov.au/newspaper/page/24097859 | 24097859 | |
| 34889 | 34889 | 1919-09-13 | 3 | d | A train collision in Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24097859 | 24097859 | |
| 34890 | 34890 | 1919-09-13 | 6 | a | Poems by Fang Zubao, Shi Gong, Shou Zhen and Han Min. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097864 | 24097864 | |
| 34891 | 34891 | 1919-09-13 | 6 | b-c | First part of a report on the strike, labour movement and revolutionary chaos in Peru. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097864 | 24097864 | |
| 34892 | 34892 | 1919-09-13 | 7 | a-b | Australia news/ A proposal to stop Chinese business in New South Wales. Chinese community in Sydney actively donate to local hospitals and the report. A Chinese gardener dies in his home in local New South Wales. Prime Minister has returned to Melbourne. Weather changes in New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097863 | 24097863 | |
| 34893 | 34893 | 1919-09-13 | 7 | 7c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097863 | 24097863 | |
| 34894 | 34894 | 1919-09-13 | 8 | a | A public notice issued by Ordinary People to Save China Association in Xiangshan county, China, on the national shame. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097866 | 24097866 | |
| 34895 | 34895 | 1919-09-13 | 8 | a-b | Guangdong news/ Zhang Jinfang to keep the disaster relief offices. Progress of the disaster relief in Guangdong. Magistrate of Xinhui county tries to stop rice export. Local gentry in Heshan county complain looting by troops. Robbery in Qingyuan county in day time. A man in Guangzhou is punished for his concubine. | China | http://trove.nla.gov.au/newspaper/page/24097866 | 24097866 |
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]);