This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40586 | 40586 | 1923-10-20 | 8 | a | Melbourne Chinese communities donate to the building of Confucian temple. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094590 | 24094590 | |
40587 | 40587 | 1923-10-20 | 8 | a-d | Guangdong news/ Sun Yatsen to borrow loans from the Bank of China. Everything is liable for taxation in Guangzhou. Hong Kong authority issues new punishment regulation on weapon smuggling. Battles in Beijiang River area. Lu Chunrong declares independence. Guangdong army starts counterattack in Danshui county. A passenger ferry explodes in Dongjiang area. Battles in the southeast of Guangdong. New waves of pressgang in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094590 | 24094590 | |
40588 | 40588 | 1923-10-20 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094590 | 24094590 | |
40589 | 40589 | 1923-10-20 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094590 | 24094590 |
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]);