This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31230 | 31230 | 1916-05-20 | 2 | a-c | Third and final part of the letter written by Kang Youwei advises Yuan Shikai to give up the throne. | China | http://trove.nla.gov.au/newspaper/page/24095268 | 24095268 | |
31241 | 31241 | 1916-05-20 | 6 | a-c | The history of autocratic monarchy in China and its decline. | China | http://trove.nla.gov.au/newspaper/page/24095271 | 24095271 | |
31243 | 31243 | 1916-05-20 | 7 | a-c | Australia news/ Gold price in Hong Kong and its influence upon overseas Chinese business. A bit department store in Sydney is burglarised. Chinese market gardener is extorted. American man in Sydney is charged with murder of Chinese businessman. Chinese man Huang Qiu, a native of Zengcheng county, is injured seriously by Xiao Ji, a native of Dongguan county, on Sussex Street, Sydney. A Chinese man is penalised by Sydney customs for carrying too much gold back to Hong Kong. | Australia | http://trove.nla.gov.au/newspaper/page/24095272 | 24095272 |
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]);