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 |
---|---|---|---|---|---|---|---|---|---|
11974 | 11974 | 1903-06-27 | 2 | c | Two returned students from Japan went to meet the Magistrate about pigtail-cutting. | China | http://trove.nla.gov.au/newspaper/page/26800248 | 26800248 | |
11975 | 11975 | 1903-06-27 | 2 | c | Phone line from Dagu to Beijing. | China | http://trove.nla.gov.au/newspaper/page/26800248 | 26800248 | |
11976 | 11976 | 1903-06-27 | 2 | c | Chinese authority talks with foreign governments over the Gulangyu Island, outside of Fuzhou. | China | http://trove.nla.gov.au/newspaper/page/26800248 | 26800248 | |
11977 | 11977 | 1903-06-27 | 2 | c | British foreign secretary talks about China in parliament; Russian troops in Lushun; China's trade talks with Japan and America; George Morrison's report on Manchuria problems; Germany watches Russian minister's visit to Japan. | Other... | http://trove.nla.gov.au/newspaper/page/26800248 | 26800248 | |
11983 | 11983 | 1903-06-27 | 3 | c | Chinese Si Ji, who returned from China with his family, was refused entry. He appealed successfully appealed the decision. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800247 | 26800247 | |
11984 | 11984 | 1903-06-27 | 3 | c | Russian ambassador to Washington talks to American government about Russia's motives in Manchuria; talks between Russia and China on the Manchuria issue. | China | http://trove.nla.gov.au/newspaper/page/26800247 | 26800247 | |
11985 | 11985 | 1903-06-27 | 3 | c | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800247 | 26800247 | |
11986 | 11986 | 1903-06-27 | 3 | c | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800247 | 26800247 |
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]);