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 |
|---|---|---|---|---|---|---|---|---|---|
| 17407 | 17407 | 1907-05-11 | 2 | c | Usual phenomenon in the Chinese officialdom. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801324 | 26801324 | |
| 17408 | 17408 | 1907-05-11 | 2 | c | Statistics of national debt of France, Britain, Russia, Italy, Austria, America, Hungary, Germany and Belgium. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801324 | 26801324 | |
| 17417 | 17417 | 1907-05-11 | 3 | c | On his way home, King Edward VII of Britain meets French president. | Australia | http://trove.nla.gov.au/newspaper/page/26801323 | 26801323 | |
| 17418 | 17418 | 1907-05-11 | 3 | c | Japan and Russia reach a trade agreement. | Australia | http://trove.nla.gov.au/newspaper/page/26801323 | 26801323 | |
| 17419 | 17419 | 1907-05-11 | 3 | c | Germany to set up bank in Teheran, capital of Persia. | Australia | http://trove.nla.gov.au/newspaper/page/26801323 | 26801323 | |
| 17420 | 17420 | 1907-05-11 | 3 | c | Japanese envoy talks with French authority in Paris on their trade interest in the Far East. | Australia | http://trove.nla.gov.au/newspaper/page/26801323 | 26801323 | |
| 17421 | 17421 | 1907-05-11 | 3 | c | Wang Kemin, Chinese student supervisor in Tokyo, has clashes with students and is to resign. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801323 | 26801323 | |
| 17422 | 17422 | 1907-05-11 | 3 | c | A letter from Guangdong suggests boycotting American goods again in order to seek fair treatment of Chinese labourers in America. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801323 | 26801323 | |
| 17436 | 17436 | 1907-05-11 | 7 | c | New York has the biggest library in the world. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801327 | 26801327 | |
| 17437 | 17437 | 1907-05-11 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fees. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801327 | 26801327 | |
| 17438 | 17438 | 1907-05-11 | 7 | c | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801327 | 26801327 | |
| 17440 | 17440 | 1907-05-11 | 8 | c | Sun Yujun writes to Governor Duan Fang from his prison on the constitutional reform in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801330 | 26801330 | |
| 17441 | 17441 | 1907-05-11 | 8 | c | Thief pays his debt of gratitude. Social life in Japan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801330 | 26801330 |
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]);