This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
44254 | 44254 | 1925-12-12 | 7 | a-b | New South Wales authority to ban the sales of some foreign products and the response of Chinese Chamber of Commerce in Sydney, represented by Ye Tonggui, Liu Guangfu, Zhu Songqing and Ma Zanfen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101386 | 24101386 |
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]);