This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
5100 | 5100 | 1900-04-28 | 3 | a | A boy disappeared on Sydney street. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102782 | 24102782 | |
5101 | 5101 | 1900-04-28 | 3 | a | An old man in Albury died while riding horse. | Australia | http://trove.nla.gov.au/newspaper/page/24102782 | 24102782 | |
5102 | 5102 | 1900-04-28 | 3 | a | Recent developments the Russia-France relations. | Other... | http://trove.nla.gov.au/newspaper/page/24102782 | 24102782 | |
5103 | 5103 | 1900-04-28 | 3 | a | Liu Huinan and his men caught pirates in South China Sea. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102782 | 24102782 | |
5104 | 5104 | 1900-04-28 | 3 | a | Reports on the war between Britain and Transvaal in South Africa | Other... | http://trove.nla.gov.au/newspaper/page/24102782 | 24102782 | |
5105 | 5105 | 1900-04-28 | 3 | b | Four poems written by Liu Kunyi, Governor of Jiangsu and Zhejiang, after meeting the Empress. | China | http://trove.nla.gov.au/newspaper/page/24102782 | 24102782 | |
5106 | 5106 | 1900-04-28 | 3 | b | Russian in Lusun, Dalian, Jinzhou and other areas of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24102782 | 24102782 | |
5107 | 5107 | 1900-04-28 | 3 | c | Residents in central Hubei report seeing a comet. | China | http://trove.nla.gov.au/newspaper/page/24102782 | 24102782 | |
5108 | 5108 | 1900-04-28 | 3 | c | Russia has shipped more ammunition for their troops in China. | Other... | http://trove.nla.gov.au/newspaper/page/24102782 | 24102782 | |
5109 | 5109 | 1900-04-28 | 3 | c | Arms sales in Macao. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102782 | 24102782 | |
5110 | 5110 | 1900-04-28 | 3 | c | Gentry and philanthropists in Shanghai send a petition to Li Hongzhang, governor of Guangdong, regarding the Jing Liansan affairs. | China | http://trove.nla.gov.au/newspaper/page/24102782 | 24102782 | |
5111 | 5111 | 1900-04-28 | 3 | c | Sailing disasters, New South Wales. | Australia | http://trove.nla.gov.au/newspaper/page/24102782 | 24102782 | |
5112 | 5112 | 1900-04-28 | 3 | c | Burglaries in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102782 | 24102782 | |
5113 | 5113 | 1900-04-28 | 3 | c | Two Chinese are returning to China with gold. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102782 | 24102782 |
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]);