This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26780 | 26780 | 1912-09-21 | 7 | a | China's consul general's letters about donations to saving Chinese nation. | Other... | http://trove.nla.gov.au/newspaper/page/24092387 | 24092387 | |
26781 | 26781 | 1912-09-21 | 7 | a-b | Australian news/ Survey shows just over half of the land developed in Australia. Two train drivers go to court for train accident. Sydney Chinese vegetable garden and house robbed. Raiway starts construction in West Australia. Sydney Chinese gambling house caught by police. | Other... | http://trove.nla.gov.au/newspaper/page/24092387 | 24092387 | |
26782 | 26782 | 1912-09-21 | 7 | b-c | Brief introduction of President's British adviser. | Other... | http://trove.nla.gov.au/newspaper/page/24092387 | 24092387 | |
26783 | 26783 | 1912-09-21 | 7 | c | More than 30 names listed for their donations to saving China. | Other... | http://trove.nla.gov.au/newspaper/page/24092387 | 24092387 |
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]);