This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40402 | 40402 | 1923-09-15 | 7 | a | Australia donates to the earthquake victims in Japan. | Australia | http://trove.nla.gov.au/newspaper/page/24094547 | 24094547 | |
40403 | 40403 | 1923-09-15 | 7 | a | A policeman in New South Wales shoots dead his colleague. | Australia | http://trove.nla.gov.au/newspaper/page/24094547 | 24094547 | |
40404 | 40404 | 1923-09-15 | 7 | a | A Sydney man commits incest and is punished. | Australia | http://trove.nla.gov.au/newspaper/page/24094547 | 24094547 | |
40405 | 40405 | 1923-09-15 | 7 | a | Chinese football team has match in Brisbane, Queensland. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094547 | 24094547 | |
40406 | 40406 | 1923-09-15 | 7 | a-b | A lifesaving ship is stranded near San Francisco. | America | http://trove.nla.gov.au/newspaper/page/24094547 | 24094547 | |
40407 | 40407 | 1923-09-15 | 7 | b | Another earthquake hits Tokyo. | Japan | http://trove.nla.gov.au/newspaper/page/24094547 | 24094547 | |
40408 | 40408 | 1923-09-15 | 7 | b | Li Yuanhong arrives Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24094547 | 24094547 | |
40409 | 40409 | 1923-09-15 | 7 | b | Shen Hongying leads his army to fight troops from the north. | China | http://trove.nla.gov.au/newspaper/page/24094547 | 24094547 | |
40410 | 40410 | 1923-09-15 | 7 | b | Gong yi tang (The Dong Guan Goon Yee Tong) in Sydney calls for donations to the flood victims in their home county. Contact details are: Lee Sang & Co, Hay and Harbour Streets, Sydney; Yuen Tiy Tong Kee, 54 Campbell Street, Sydney; Chung Lung, 120 Gloucester Street, Sydney; and King Young, 51 Dixon Street, Sydney. Names listed for donations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094547 | 24094547 | |
40411 | 40411 | 1923-09-15 | 7 | c | Message by Kuang Shide suggests Chinese compatriots to travel with Victoria, a passenger liner of the China-Australia Steamship Line. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094547 | 24094547 | |
40412 | 40412 | 1923-09-15 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094547 | 24094547 |
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]);