This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34528 | 34528 | 1919-05-31 | 2 | a-d | First part of an article written by Peng Lichuan on the epidemic around the world. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097734 | 24097734 | |
34533 | 34533 | 1919-05-31 | 3 | a | Chinese community in Thailand and their sufferings. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097733 | 24097733 | |
34541 | 34541 | 1919-05-31 | 7 | a-b | Australia news/ Federal government permits import of foreign teas. Passenger liner St Albans arrives Sydney for the first time after the World War I. Casualties of the epidemic in New South Wales. Heavy rains in Sydney. Shipyard workers in Sydney prepare for a strike. Theft in Sydney and a few cases. New road plan for the front of the general post office in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097737 | 24097737 | |
34542 | 34542 | 1919-05-31 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097737 | 24097737 | |
34543 | 34543 | 1919-05-31 | 8 | a | The New South Wales Chinese Chamber of Commerce calls for donations to the famine victims in Guangdong. Names listed for donations received. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097740 | 24097740 |
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]);