This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
6725 | 6725 | 1900-12-26 | 3 | a | Provisions and payment to soldiers in different countries. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24103060 | 24103060 | |
6726 | 6726 | 1900-12-26 | 3 | a | Bandits in Fengtian (Shenyang), Russian in Liaoning province, the organisation and training of civil corps there, business in Yingkou, Russian administrators in Heilongjiang province, and the number of Chinese residents murdered by Russian in Manchuria. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24103060 | 24103060 | |
6727 | 6727 | 1900-12-26 | 3 | b | Battles between Chinese and foreign troops, the fall of Beijing. | China | http://trove.nla.gov.au/newspaper/page/24103060 | 24103060 | |
6728 | 6728 | 1900-12-26 | 3 | b | Tailors are now busy making imperial robes. | China | http://trove.nla.gov.au/newspaper/page/24103060 | 24103060 | |
6729 | 6729 | 1900-12-26 | 3 | c | New tax will be imposed in order to raise revenue for the imperial palace refurbishment. | Singapore | http://trove.nla.gov.au/newspaper/page/24103060 | 24103060 | |
6730 | 6730 | 1900-12-26 | 3 | c | Zhang Qujiang is keen to raise carrier pigeons, but they are useless when needed. | Other... | http://trove.nla.gov.au/newspaper/page/24103060 | 24103060 | |
6731 | 6731 | 1900-12-26 | 3 | d | Christmas celebrations in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24103060 | 24103060 | |
6732 | 6732 | 1900-12-26 | 3 | d | Progress of China's negotiation with foreign governments. | Australia | http://trove.nla.gov.au/newspaper/page/24103060 | 24103060 | |
6733 | 6733 | 1900-12-26 | 3 | d | Chinese ambassador to France talks about China's negotiation with foreign governments. | Other... | http://trove.nla.gov.au/newspaper/page/24103060 | 24103060 | |
6734 | 6734 | 1900-12-26 | 3 | d | Two young man in Maryborough, Victoria, were injured in a fight. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24103060 | 24103060 | |
6735 | 6735 | 1900-12-26 | 3 | d | Timetable of ocean liner. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24103060 | 24103060 |
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]);