This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
18184 | 18184 | 1907-09-28 | 3 | a-b | Guangdong news. Guangdong authority to increase tariff levy. A case of superstition and the disasters that followed. Guangdong students in Germany have excellent performance. A survey and the report on opium smoking in Guangzhou. Nearly 3,000 opium addicts in Guangzhou register to quit smoking. Two restaurants destroy all smoking paraphernalia and advise customers not to smoking. New governor Zhang Renjun and his entourage. Report on the military medical school in Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801483 | 26801483 | |
18185 | 18185 | 1907-09-28 | 3 | b | British navy to build more warships in Portsmouth. | Britain | http://trove.nla.gov.au/newspaper/page/26801483 | 26801483 | |
18186 | 18186 | 1907-09-28 | 3 | b | Germany is building torpedo boat. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801483 | 26801483 | |
18187 | 18187 | 1907-09-28 | 3 | b | Japanese warship explodes during a military exercise. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801483 | 26801483 | |
18188 | 18188 | 1907-09-28 | 3 | c | A Japanese liner sank near Zhenjiang, China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801483 | 26801483 | |
18189 | 18189 | 1907-09-28 | 3 | c | Britain and Russia reach an agreement over India and Afghanistan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801483 | 26801483 | |
18190 | 18190 | 1907-09-28 | 3 | c | Russian authority plans military infrastructure in the Far East. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801483 | 26801483 | |
18191 | 18191 | 1907-09-28 | 3 | c | A Japanese spy is captured by Russian authority in Hunchun. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801483 | 26801483 | |
18192 | 18192 | 1907-09-28 | 3 | c | Japan awards imperial titles to its heroes and the medal-confering ceremony in Tokyo. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801483 | 26801483 | |
18193 | 18193 | 1907-09-28 | 3 | c-d | News from Europe. Chinese students in Britain have a summer meeting. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801483 | 26801483 | |
18194 | 18194 | 1907-09-28 | 3 | d | Tung Wah column. On the boundary between Manchurian and Han peoples and the proposal to abolish it. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801483 | 26801483 |
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]);