This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
41865 | 41865 | 1924-07-26 | 6 | a | Tung Wah Times comments on Tang Jiyao's proposal for united provincial government. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100805 | 24100805 | |
41868 | 41868 | 1924-07-26 | 7 | a | Telegrams from the Tung Wah Hospital in Hong Kong and commercial chamber in Guangdong to the Chinese Chamber of Commerce in New South Wales call for donations to the flood victims in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100804 | 24100804 |
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]);