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 |
---|---|---|---|---|---|---|---|---|---|
37298 | 37298 | 1921-07-09 | 3 | a | Japanese newspapers on Sun Yatsen. | Japan | http://trove.nla.gov.au/newspaper/page/24093604 | 24093604 | |
37299 | 37299 | 1921-07-09 | 3 | a | A letter from Lu Yongxiang, military commander of Zhejiang province, to Guo Shun, chairman of the Chinese Chamber of Commerce in New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093604 | 24093604 | |
37305 | 37305 | 1921-07-09 | 6 | a | Poems by Lu Shubin in Shanghai and presented to Mr Guo Shun. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093609 | 24093609 | |
37308 | 37308 | 1921-07-09 | 7 | a | Four milk companies in Sydney amalgamated. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093608 | 24093608 | |
37309 | 37309 | 1921-07-09 | 7 | a | A woman in New South Wales shoots a man in order to stop the harassment. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093608 | 24093608 | |
37310 | 37310 | 1921-07-09 | 7 | a | Sydney customs officer seizes opium on board of Hwah Ping. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093608 | 24093608 | |
37311 | 37311 | 1921-07-09 | 7 | a | Strong wind and heavy rain in Sydney cause damages. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093608 | 24093608 | |
37312 | 37312 | 1921-07-09 | 7 | a | Japanese liner service to Australia and America. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093608 | 24093608 | |
37313 | 37313 | 1921-07-09 | 7 | a | New regulation in Melbourne and Sydney requires all traffic and passengers on the left side road, or penalty will apply. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093608 | 24093608 | |
37320 | 37320 | 1921-07-09 | 8 | a | A charnel house for deceased overseas Chinese in Xiangshan county, Guangdong, calls for donations or financial assistance. Names listed for donators in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093610 | 24093610 |
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]);