This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40683 | 40683 | 1923-11-17 | 6 | b-c | A letter from Chinese Consul-General in Melbourne Wei Zijing to the Chinese Chamber of Commerce in New South Wales regarding the Chinese football team, their match arrangement in Australia, and their dispute with white agent. And a letter from the Chinese football team to Wei Zijing, consul-general in Melbourne. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094620 | 24094620 | |
40692 | 40692 | 1923-11-17 | 7 | b-c | Second part of a report on the wars in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094619 | 24094619 |
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]);