This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46995 | 46995 | 1928-05-05 | 2 | c | Italy seeks to control the South America. | Other... | http://trove.nla.gov.au/newspaper/page/24098794 | 24098794 | |
47002 | 47002 | 1928-05-05 | 3 | c | Foreign Investment Bureau (zhao shang ju) initiates reform under the control of the Ministry of Transportation of the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24098793 | 24098793 | |
47016 | 47016 | 1928-05-05 | 7 | c | Australia news/ People arrested in Sydney for the forging bank notes. A gardener finds gold coins while ploughing his farm. A young girl is detained for theft. Advertisement for Assurance Homes of Australia Ltd. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098797 | 24098797 |
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]);