This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
12093 | 12093 | 1903-08-08 | 2 | a | First part of an article claiming that it is not the Russian who conquered the Manchuria. It is the Manchu dynasty is responsible for the demise of Manchuria. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800269 | 26800269 | |
12098 | 12098 | 1903-08-08 | 2 | c | A 'bride' in Dongguan county, Guangdong, turns out to be a thief. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800269 | 26800269 | |
12105 | 12105 | 1903-08-08 | 3 | a | Mr Morgan is the richest man in the world. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800268 | 26800268 | |
12110 | 12110 | 1903-08-08 | 3 | b | Report on a monthly meeting of the Sydney Chinese Empire Reform Association. Speakers include Liu Ruxing, Xian Junhao, Tang Caizhi. The Association's past work and future plan. List of members of the China Education Society in Shanghai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800268 | 26800268 | |
12112 | 12112 | 1903-08-08 | 3 | c | Three Chinese detained for gambling on Sussex Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800268 | 26800268 | |
12115 | 12115 | 1903-08-08 | 3 | c | Price of gold in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800268 | 26800268 | |
12116 | 12116 | 1903-08-08 | 3 | c | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800268 | 26800268 | |
12117 | 12117 | 1903-08-08 | 3 | c | Mail from China awaits collection. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800268 | 26800268 | |
12118 | 12118 | 1903-08-08 | 3 | c | Notice of annual meeting for shareholders from the Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800268 | 26800268 |
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]);