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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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]);