This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40264 | 40264 | 1923-08-18 | 7 | a-c | Miscellaneous report on the visit and matches of Chinese football team in Sydney. Coordinators include Liu Guangfu, Zhou Yuanji, Zhu Hechou and Chen Yaoyuan. Comments written by Zhou Jialing on the match in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094515 | 24094515 |
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]);