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 |
|---|---|---|---|---|---|---|---|---|---|
| 35069 | 35069 | 1919-11-22 | 2 | a-b | An article selected from a Hong Kong newspaper on the reorganisation of the military government in Guangdong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24097944 | 24097944 | |
| 35070 | 35070 | 1919-11-22 | 2-3 | b-e | Articles debate with the Republic News (min guo bao) on the birthday celebration for Confucius, the boycott to Japanese goods and other issues. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097944 | 24097944 | |
| 35071 | 35071 | 1919-11-22 | 3 | c-d | Celebrations in Guangzhou on the birthday of Confucius. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097943 | 24097943 | |
| 35072 | 35072 | 1919-11-22 | 6 | a | Japan's policy in Korea. | America | http://trove.nla.gov.au/newspaper/page/24097948 | 24097948 | |
| 35073 | 35073 | 1919-11-22 | 6 | a | Epidemic in Turkey. | America | http://trove.nla.gov.au/newspaper/page/24097948 | 24097948 | |
| 35074 | 35074 | 1919-11-22 | 6 | a | Proposal in America to lend loans to the Chinese government. | America | http://trove.nla.gov.au/newspaper/page/24097948 | 24097948 | |
| 35075 | 35075 | 1919-11-22 | 6 | a | American senators have different opinion with President Wilson on the Shandong issues. | America | http://trove.nla.gov.au/newspaper/page/24097948 | 24097948 | |
| 35076 | 35076 | 1919-11-22 | 6 | b | A proposal to organise the World Union. | America | http://trove.nla.gov.au/newspaper/page/24097948 | 24097948 | |
| 35077 | 35077 | 1919-11-22 | 6 | c | Boycott to Japanese goods in Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097948 | 24097948 | |
| 35078 | 35078 | 1919-11-22 | 6 | c | A notice issued by the Wing On Company on the boycott to Japanese goods and its business operations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097948 | 24097948 | |
| 35079 | 35079 | 1919-11-22 | 7 | a-c | Australia news/ A Japanese businessmen delivers speech in New Castle against Chinese, and rebuffed by Guo Shun. Sailors in Sydney are preparing for another strike. Many British women immigrate to Australia. A Chinese man Zhang Fanzhai comes to Australia by Japanese liner. Two open letters respectively issued by the Sydney Chinese Youth Patriotic Association and the Chinese community in Tamworth, New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097947 | 24097947 | |
| 35080 | 35080 | 1919-11-22 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097947 | 24097947 | |
| 35081 | 35081 | 1919-11-22 | 8 | a-b | Advertisement for the Hanyang China Iron Tools Company Ltd. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097950 | 24097950 |
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]);