This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26567 | 26567 | 1912-08-17 | 2 | b | President Yuan issues several orders. | Other... | http://trove.nla.gov.au/newspaper/page/24092344 | 24092344 | |
26568 | 26568 | 1912-08-17 | 2 | b | President Yuan plans to make vote regulations. | Other... | http://trove.nla.gov.au/newspaper/page/24092344 | 24092344 | |
26583 | 26583 | 1912-08-17 | 3 | b | Famous French writer kills her husband's lover in Shanghai. | France | http://trove.nla.gov.au/newspaper/page/24092343 | 24092343 | |
26584 | 26584 | 1912-08-17 | 3 | b | Different views on president's appointment of British journalist as political adviser. | China | http://trove.nla.gov.au/newspaper/page/24092343 | 24092343 | |
26585 | 26585 | 1912-08-17 | 3 | b | Italy and Turkey reopen their peace talk. | France | http://trove.nla.gov.au/newspaper/page/24092343 | 24092343 | |
26586 | 26586 | 1912-08-17 | 3 | b | Revolution spread to Turkey. | Other... | http://trove.nla.gov.au/newspaper/page/24092343 | 24092343 | |
26587 | 26587 | 1912-08-17 | 3 | b | Riots in Turkey result in more than 50 killed and 100 wounded. | Other... | http://trove.nla.gov.au/newspaper/page/24092343 | 24092343 | |
26592 | 26592 | 1912-08-17 | 6 | b | Second revolution said to start in Guangdong. | Other... | http://trove.nla.gov.au/newspaper/page/24092348 | 24092348 | |
26595 | 26595 | 1912-08-17 | 7 | b | Chinese consul general's notice on regulations on donations to save Chinese nation. | Other... | http://trove.nla.gov.au/newspaper/page/24092347 | 24092347 | |
26596 | 26596 | 1912-08-17 | 7 | b | Australian news/ Australian navy stronger due to more warships added. False application for Australian citzenship are to be prosecuted. Shop owner fined for cheating customers. Millionaire miser dies of hunger on street. Boy soldiers fined for not joining exercise. | Other... | http://trove.nla.gov.au/newspaper/page/24092347 | 24092347 | |
26603 | 26603 | 1912-08-17 | 8 | b | More than 15 names listed for their donations to saving Chinese nations. | Other... | http://trove.nla.gov.au/newspaper/page/24092350 | 24092350 | |
26604 | 26604 | 1912-08-17 | 8 | b | Praise German ship good service. | Other... | http://trove.nla.gov.au/newspaper/page/24092350 | 24092350 |
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]);