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 |
|---|---|---|---|---|---|---|---|---|---|
| 44918 | 44918 | 1926-07-10 | 2 | c-d | Editorial by Tung Wah Times on the hope to solve the strike in Hong Kong and Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101624 | 24101624 | |
| 44919 | 44919 | 1926-07-10 | 2 | e-f | Zhang Zuolin and Wu Peifu to meet and have a talk. | China | http://trove.nla.gov.au/newspaper/page/24101624 | 24101624 | |
| 44920 | 44920 | 1926-07-10 | 2 | f | Zhang Zongchang on the current situation in China. | China | http://trove.nla.gov.au/newspaper/page/24101624 | 24101624 | |
| 44921 | 44921 | 1926-07-10 | 3 | d | Foreign newspaper reports the international conference on the Chinese tariff. | China | http://trove.nla.gov.au/newspaper/page/24101623 | 24101623 | |
| 44922 | 44922 | 1926-07-10 | 3 | d | Zhao Hengti and the Hunan affairs. | China | http://trove.nla.gov.au/newspaper/page/24101623 | 24101623 | |
| 44923 | 44923 | 1926-07-10 | 3 | e | Defence in Fujian and Jiangxi province. | China | http://trove.nla.gov.au/newspaper/page/24101623 | 24101623 | |
| 44924 | 44924 | 1926-07-10 | 3 | f | Troops in Henan province suppress bandits. | China | http://trove.nla.gov.au/newspaper/page/24101623 | 24101623 | |
| 44925 | 44925 | 1926-07-10 | 5 | a | Italian government and the economic development. | Other... | http://trove.nla.gov.au/newspaper/page/24101625 | 24101625 | |
| 44926 | 44926 | 1926-07-10 | 5 | a | Talks between Hong Kong and Guangzhou authorities to end the strike. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24101625 | 24101625 | |
| 44927 | 44927 | 1926-07-10 | 5 | a | The constitution of Mongolia after its independence. | China | http://trove.nla.gov.au/newspaper/page/24101625 | 24101625 | |
| 44928 | 44928 | 1926-07-10 | 6 | a-b | Ninth part of Kang Youwei's speech on the Chinese moral tradition, compiled by disciples Deng Yi and Zhang Pengyi. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101628 | 24101628 | |
| 44929 | 44929 | 1926-07-10 | 6 | b-c | Daughter of Prince Su, of the deposed Qing dynasty, Miss Kawashima, and her stories of homosexuality and others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101628 | 24101628 | |
| 44930 | 44930 | 1926-07-10 | 6 | c | American comments on the current situation in China. | America | http://trove.nla.gov.au/newspaper/page/24101622 | 24101622 | |
| 44931 | 44931 | 1926-07-10 | 6 | d | Chinese communist activists are deported from Hungary. | America | http://trove.nla.gov.au/newspaper/page/24101628 | 24101628 | |
| 44932 | 44932 | 1926-07-10 | 7 | a-b | Australia news/ A very conservative priest and his speech in Goulburn, New South Wales. Prisoners in Brisbane are on strike. Two young men are punished in Sydney for frivolous behaviour. The dance party of the League of Nations Union in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101627 | 24101627 | |
| 44933 | 44933 | 1926-07-10 | 7 | b | The anti-Chinese sentiment in New Zealand. Flu and the casualties in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24101627 | 24101627 | |
| 44934 | 44934 | 1926-07-10 | 7 | b | Floods in Europe. | Germany | http://trove.nla.gov.au/newspaper/page/24101627 | 24101627 | |
| 44935 | 44935 | 1926-07-10 | 7 | c | British delegate issues declaration on the international tariff conference. | China | http://trove.nla.gov.au/newspaper/page/24101627 | 24101627 | |
| 44936 | 44936 | 1926-07-10 | 7 | c | American consul and his attitude towards the Guangzhou government. | China | http://trove.nla.gov.au/newspaper/page/24101627 | 24101627 | |
| 44937 | 44937 | 1926-07-10 | 7 | c | Earthquake in Sumatra. | Britain | http://trove.nla.gov.au/newspaper/page/24101627 | 24101627 | |
| 44938 | 44938 | 1926-07-10 | 7 | c | Class strike in a Chinese school in Singapore and the report. | Singapore | http://trove.nla.gov.au/newspaper/page/24101627 | 24101627 | |
| 44939 | 44939 | 1926-07-10 | 8 | a-d | Guangdong news/ Guangzhou government provides assistance to the Hunan provincial authority. Military police in Guangzhou seize smuggled goods. Floods in Dongjiang area. Hails in Huaaxian county. Bandits in Zengcheng county. Civil corps in Huaaxian county fight the bandits. Chen Duxiu arrives Guangzhou secretly. | China | http://trove.nla.gov.au/newspaper/page/24101630 | 24101630 |
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]);