This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
41838 | 41838 | 1924-07-19 | 6 | a-b | Chinese Consulate General in Melbourne writes to the Chinese Chamber of Commerce in New South Wales on the proposed national industrial conference that to be held in Beijing. And the Proposal for the national conference. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100797 | 24100797 | |
41839 | 41839 | 1924-07-19 | 6 | b-c | A letter from Lu Rongting to Shen Hongying's officers and soldiers. | China | http://trove.nla.gov.au/newspaper/page/24100797 | 24100797 | |
41840 | 41840 | 1924-07-19 | 6 | c-d | A man in Hong Kong comes back to life after dead for two years. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100797 | 24100797 | |
41841 | 41841 | 1924-07-19 | 6 | d-e | Chinese typewriter invented in Shanghai. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100797 | 24100797 |
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]);