This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26839 | 26839 | 1912-10-05 | 7 | a | Details aobut China's borrowing loans from Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24092403 | 24092403 | |
26840 | 26840 | 1912-10-05 | 7 | a | Japan feels sad over breakup of its loan treaty with China. | Japan | http://trove.nla.gov.au/newspaper/page/24092403 | 24092403 | |
26841 | 26841 | 1912-10-05 | 7 | b | German colony Samoa again intends to recruit Chinese labourers. | Other... | http://trove.nla.gov.au/newspaper/page/24092403 | 24092403 | |
26842 | 26842 | 1912-10-05 | 7 | b-c | Australian news/ China's consul general's telegram about China's national day. Celebration of Confucian birthday in Australia. Chinese rejects preist's claim of Chinese smoke house inducing white Australian woman into the smoke house. Sydney Chinese garden is robbed again. More than 100 names listed for their donations to saving China. | Other... | http://trove.nla.gov.au/newspaper/page/24092403 | 24092403 |
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]);