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 |
---|---|---|---|---|---|---|---|---|---|
40880 | 40880 | 1924-01-05 | 2 | a | New Year's greetings from the Tung Wah Times to the Republic of China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100558 | 24100558 | |
40881 | 40881 | 1924-01-05 | 2 | a-b | Editorial by the Tung Wah Times and greetings to the Republic of China on the occasion of New Year. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100558 | 24100558 | |
40896 | 40896 | 1924-01-05 | 6 | a | Greeting message written by Yu Wenhou on the occasion of New Year. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100562 | 24100562 | |
40897 | 40897 | 1924-01-05 | 6 | a-b | Tung Wah Times editor on the situation change and battles in Dongjiang area, Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100562 | 24100562 | |
40906 | 40906 | 1924-01-05 | 7 | b | Two Chinese passengers of Taiyuan are isolated on arrival for smallpox. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100561 | 24100561 | |
40907 | 40907 | 1924-01-05 | 7 | b | Riots in Redfern, Sydney, on the New Year's eve. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100561 | 24100561 | |
40912 | 40912 | 1924-01-05 | 7 | e | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100561 | 24100561 | |
40913 | 40913 | 1924-01-05 | 8 | a-d | Guangdong news/ Guangdong in the conflict of different military forces. Yuan Dai and his troops occupy Xiangshan county once again. Magistrate of Yunfu county pleas for emergency help. Guangdong army return to Yangjiang county. Huang Dawei dispatches troops to suppress pirates. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100564 | 24100564 | |
40914 | 40914 | 1924-01-05 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100564 | 24100564 | |
40915 | 40915 | 1924-01-05 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100564 | 24100564 |
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]);