This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
10747 | 10747 | 1902-05-31 | 2 | d | Tap water to be built in Beijing; dinner party at the American embassy; selection of imperial scholars; Japanese soldiers in Beijing; army school to be established in Beijing; Cabinet tries to re-organise its offices. | China | http://trove.nla.gov.au/newspaper/page/24100444 | 24100444 | |
10748 | 10748 | 1902-05-31 | 2 | d | Beijing will have a new library soon. | China | http://trove.nla.gov.au/newspaper/page/24100444 | 24100444 | |
10749 | 10749 | 1902-05-31 | 2 | d | Empress Dowager reads newspaper every day. | China | http://trove.nla.gov.au/newspaper/page/24100444 | 24100444 | |
10772 | 10772 | 1902-05-31 | 3 | d | The size of cards of Chinese officials. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100443 | 24100443 | |
10773 | 10773 | 1902-05-31 | 3 | d | Sweet spring found in New South Wales in these dry days and explanation of an expert. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100443 | 24100443 | |
10774 | 10774 | 1902-05-31 | 3 | d | Another trial on the case between Li Bu and the Tung Wah News. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100443 | 24100443 | |
10775 | 10775 | 1902-05-31 | 3 | d | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100443 | 24100443 |
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]);