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 |
|---|---|---|---|---|---|---|---|---|---|
| 34598 | 34598 | 1919-06-21 | 2 | a-c | Lessons and results of the World War I (scientific, ideological and political fields) | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097760 | 24097760 | |
| 34599 | 34599 | 1919-06-21 | 2 | c-d | Tung Wah Times comments on the peace talks in China between the south and the north. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097760 | 24097760 | |
| 34600 | 34600 | 1919-06-21 | 2 | d-f | Second part of the report written by American journalist that reveals Japan's conspiracy in China. | America | http://trove.nla.gov.au/newspaper/page/24097760 | 24097760 | |
| 34601 | 34601 | 1919-06-21 | 2 | f | Beijing people hold a protest gathering in the Central Park. | China | http://trove.nla.gov.au/newspaper/page/24097760 | 24097760 | |
| 34602 | 34602 | 1919-06-21 | 2-3 | f-b | Beijing students and their demonstration on May Fourth and the detailed report (Cao Rulin's residence is on fire, Cai Yuanpei's speech, Fu Zengxiang and Yuan Guanlan, and other details). | China | http://trove.nla.gov.au/newspaper/page/24097760 | 24097760 | |
| 34603 | 34603 | 1919-06-21 | 3 | b-c | A protest gathering in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24097759 | 24097759 | |
| 34604 | 34604 | 1919-06-21 | 3 | c-d | Name of Chinese students arrested in Tokyo by Japanese police. | Japan | http://trove.nla.gov.au/newspaper/page/24097759 | 24097759 | |
| 34605 | 34605 | 1919-06-21 | 3 | d-f | Miscellaneous/ Strike in France. New Turkey. China boycotts Japanese goods. Reconsideration proposed for the Shandong issues. Strike in Canada. America also demands compensation from Germany. American authority lifts ban on gold export. Soldiers on riots in Canada. German's proposals for the peace treaty. | Other... | http://trove.nla.gov.au/newspaper/page/24097759 | 24097759 | |
| 34606 | 34606 | 1919-06-21 | 6 | a-b | Report on the peace talks in China between the south and the north. | China | http://trove.nla.gov.au/newspaper/page/24097764 | 24097764 | |
| 34607 | 34607 | 1919-06-21 | 6 | b | A circular telegram issued by Liang Qichao for self-defence. | China | http://trove.nla.gov.au/newspaper/page/24097764 | 24097764 | |
| 34608 | 34608 | 1919-06-21 | 7 | a-b | Australia news/ Post parcels are stolen in Sydney. More unemployment in New Castle due to the sailors' strike. Epidemic in Sydney. Federal government and its deficit. A shop on fire in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097763 | 24097763 | |
| 34609 | 34609 | 1919-06-21 | 7 | b | British newspaper reports the crisis in China. | Britain | http://trove.nla.gov.au/newspaper/page/24097763 | 24097763 | |
| 34610 | 34610 | 1919-06-21 | 7 | b | American army doctor reports the bravery of Chinese soldiers. | America | http://trove.nla.gov.au/newspaper/page/24097763 | 24097763 | |
| 34611 | 34611 | 1919-06-21 | 7 | b | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097763 | 24097763 | |
| 34612 | 34612 | 1919-06-21 | 8 | a | The New South Wales Chinese Chamber of Commerce lists donations to the famine victims in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097765 | 24097765 | |
| 34613 | 34613 | 1919-06-21 | 8 | a-b | Chinese communities in Brisbane donate to the Australian Chinese Association against Discrimination (hua qiao wei chi jin li hui). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097765 | 24097765 | |
| 34614 | 34614 | 1919-06-21 | 8 | b-c | Beijing news/ Dagu shipyard is mortgaged for loans from Japan. Chinese foreign ministry repeats the ban on opium. Xia Tonghe is under investigation. Protest movement in Shandong province. China, America and Britain to joint organise a commercial chamber. Cao Rulin and Zhang Zongxiang after the students demonstration in Beijing (later May Fourth Movement). | China | http://trove.nla.gov.au/newspaper/page/24097765 | 24097765 | |
| 34615 | 34615 | 1919-06-21 | 8 | c-d | Guangdong news/ Wang Tingjiang reports the Shandong problem. Lu Rongting sends another envoy to meet Xu Shichang. Bandits in Gaoyao county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097765 | 24097765 |
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]);