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 |
---|---|---|---|---|---|---|---|---|---|
18185 | 18185 | 1907-09-28 | 3 | b | British navy to build more warships in Portsmouth. | Britain | http://trove.nla.gov.au/newspaper/page/26801483 | 26801483 | |
18186 | 18186 | 1907-09-28 | 3 | b | Germany is building torpedo boat. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801483 | 26801483 | |
18187 | 18187 | 1907-09-28 | 3 | b | Japanese warship explodes during a military exercise. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801483 | 26801483 | |
18196 | 18196 | 1907-09-28 | 6 | b | Beijing politics. Disputes between Empress Dowager and Emperor Guangxu. Yuan Shikai in Beijing meets with the Empress. Emperor Guangxu is ill. Proposal for the candidates of new cabinet. Fang Zengxiang might be reappointed. Zhang Zhidong is on the way to Beijing. Qin Chunxuan is now in Hangzhou. Zhang Renjun on the way to Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801488 | 26801488 | |
18202 | 18202 | 1907-09-28 | 7 | b | Census and population in the state of Victoria. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801487 | 26801487 | |
18203 | 18203 | 1907-09-28 | 7 | b | New Zealand has new law to restrict Asian laundry. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801487 | 26801487 | |
18204 | 18204 | 1907-09-28 | 7 | b | Farewell to Liu Ruxing who is going to visit China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801487 | 26801487 | |
18205 | 18205 | 1907-09-28 | 7 | b | A letter from Clan Prosperity Society (zhen wu zong she) in Dongguan to other Dongguan fellows in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801487 | 26801487 |
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]);