This data as json, CSV (advanced)
Suggested facets: column, title, source
date (date) 7 ✖
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
16269 | 16269 | 1906-09-29 | History of the Chinese Business Protection Association (bao shang hui) in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801092 | 26801092 | |||
21672 | 21672 | 1909-09-18 | c | A public notice from the Salvation Army in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802325 | 26802325 | ||
24314 | 24314 | 1911-02-11 | No issue published on this day | No issue published on this day. | |||||
31164 | 31164 | 1916-04-22 | b-c | American government dispatches troops to suppress rebellions in Mexico. | America | http://trove.nla.gov.au/newspaper/page/24095233 | 24095233 | ||
31581 | 31581 | 1916-09-16 | c | Further report on the negotiation progress between China and Japan. | America | http://trove.nla.gov.au/newspaper/page/24095404 | 24095404 | ||
31682 | 31682 | 1916-10-28 | d-e | Feng Guozhang suggests to finalise the constitution as soon as possible. | China | http://trove.nla.gov.au/newspaper/page/24095451 | 24095451 | ||
43812 | 43812 | 1925-09-12 | c | A coal mine near Pyongyang, Korea, explodes and the casualties. | Japan | http://trove.nla.gov.au/newspaper/page/24101271 | 24101271 |
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]);