This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31181 | 31181 | 1916-04-29 | 7 | a-b | Australia news/ Four Chinese gardeners (Li Hong, Zhou Wenhao, You Su and Charlie Li) in Sydney are injured by bandits and the report. The ANZAC Day parade in Sydney. More paper notes issued by the Commonwealth government. Many people visit the Royal Easter Show in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095247 | 24095247 | |
31182 | 31182 | 1916-04-29 | 7 | c | News about China/ A Chinese cruiser collides with an army ship in the East Sea. The new Chinese cabinet in Beijing under Duan Qirui (Sun Baoqi, Liu Guanxiong and Wang Shizhen). | China | http://trove.nla.gov.au/newspaper/page/24095247 | 24095247 | |
31183 | 31183 | 1916-04-29 | 7 | c | More report on the World War I (arms smuggling in Ireland. Chaos in Ireland. Population in Russia and its components). | Other... | http://trove.nla.gov.au/newspaper/page/24095247 | 24095247 | |
31184 | 31184 | 1916-04-29 | 7 | d | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095247 | 24095247 | |
31185 | 31185 | 1916-04-29 | 7 | d | Wing On Fruit Shop in Sydney offers a reward to the capture of Li Kunquan, an illegal arrival in Sydney, and Li's photograph attached. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095247 | 24095247 |
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]);