This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40301 | 40301 | 1923-08-25 | 7 | a-c | Miscellaneous report on the Chinese football team (their tour and matches in Australia). Chinese figures involved are Zhou Yuanji, Ye Tonggui, Huang Zhu, Yu Rong, Huang Laiwang, Liu Guangfu, Zhu Songqing, Chen Yaoyuan, Peng Lichuan, Li Rufu, Liang Aiyun, and others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094523 | 24094523 |
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]);