This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47920 | 47920 | 1929-03-23 | 3 | e | The Sun Company in Shanghai has new General Manager. | China | http://trove.nla.gov.au/newspaper/page/24099153 | 24099153 | |
47921 | 47921 | 1929-03-23 | 3 | e | Notice issued by the Overseas Chinese Commission of the Nationalist government in Nanjing collecting sample producers among the overseas Chinese communities. And specified explanation of the Chinese Chamber of Commerce in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099153 | 24099153 |
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]);