This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
39889 | 39889 | 1923-05-26 | 3 | b-c | Japanese police insult Chinese students and the inquiries in the Beijing parliament. | China | http://trove.nla.gov.au/newspaper/page/24094415 | 24094415 | |
39905 | 39905 | 1923-05-26 | 7 | b-c | A public notice issued by the Tung Wah Times about its dispute with Min Bao, organ of the Nationalist Party in Sydney, and involvement of Ye Bingnan, Li Ganquan, Yu Rong, Ma Shupei, Huang Yougong, and others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094419 | 24094419 |
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]);