This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29843 | 29843 | 1915-04-03 | 2 | a-b | Comment: Advice to the Authorities in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094793 | 24094793 | |
29848 | 29848 | 1915-04-03 | 3 | a-b | The explanation of the Finance Ministry to all provinces in China on public loans. | China | http://trove.nla.gov.au/newspaper/page/24094792 | 24094792 | |
29865 | 29865 | 1915-04-03 | 6 | a-b | Mechanical explanation of submarines and their functions. | Other... | http://trove.nla.gov.au/newspaper/page/24094797 | 24094797 | |
29867 | 29867 | 1915-04-03 | 7 | a-b | Australia news/A package of paper currency is stolen in the train. Big water melons are to exihbited in Sydney. Agriculture Exihbition is opened in Sydney. Australia invents a new kind of machine gun. A good rain in New South Wales releases the draught there. | Australia | http://trove.nla.gov.au/newspaper/page/24094796 | 24094796 | |
29874 | 29874 | 1915-04-03 | 8 | a-b | Details of finding out a riot party organisation in Yunfu county, Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24094798 | 24094798 |
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]);