This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
5853 | 5853 | 1900-08-15 | 3 | a | A prayer meeting in YMCA Hall on Pitt Street, Sydney, organised by Zhou Rongwei and presided over by Rev. Donald Portman. Attendants include Zhang Zhuoxiong, Zhou Rongwei, Fang Jinyi, Xie De. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102907 | 24102907 | |
5854 | 5854 | 1900-08-15 | 3 | a | Earthquake in New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102907 | 24102907 | |
5855 | 5855 | 1900-08-15 | 3 | a | A train accident in Melbourne killed 7 and injured 6. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102907 | 24102907 | |
5856 | 5856 | 1900-08-15 | 3 | a | Some foreigners are moving outside of Beijing; more clashes between Tianjin and Beijing; Liu Yuanting and his Black Flag army are on the way to Beijing; a town was burned to ashes in Liaoning province; secret telegrams from Beijing to Hankou; forged edicts from Beijing; Japan will block Russia's effort to carve up China; Chinese armymen's families stay with the fortifications in Dagu. | China | http://trove.nla.gov.au/newspaper/page/24102907 | 24102907 |
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]);