This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
39032 | 39032 | 1922-11-18 | 7 | a | Report on the money supply in Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24094191 | 24094191 | |
39033 | 39033 | 1922-11-18 | 7 | a | Australia exports wool to Germany. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094191 | 24094191 | |
39034 | 39034 | 1922-11-18 | 7 | a | Import and export of Australia in 1921. | Australia | http://trove.nla.gov.au/newspaper/page/24094191 | 24094191 | |
39035 | 39035 | 1922-11-18 | 7 | a-b | Sydney police seize smuggled opium from a shop in Paddington, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094191 | 24094191 | |
39036 | 39036 | 1922-11-18 | 7 | b | Peking (Beijing) Cafe in Melbourne on fire and the damages. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094191 | 24094191 | |
39037 | 39037 | 1922-11-18 | 7 | b | A Chinese market gardener in Sydney hides his money in kerosene tank. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094191 | 24094191 | |
39038 | 39038 | 1922-11-18 | 7 | b | Tung Wah Times farewells to Zhao Yu and Wu Jinze. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094191 | 24094191 | |
39039 | 39039 | 1922-11-18 | 7 | c | News in brief/ Zhao Hengti urges Li Yuanhong to draft the state constitution. Hanyang ammunition factory provides weapons to Sa Zhenbing. Wu Peifu tries to wipe out Zhang Wensheng. Du Xigui dispatches gunboats to Fujian. Wu Jinglian, Cao Rui and Li Yuanhong. | Other... | http://trove.nla.gov.au/newspaper/page/24094191 | 24094191 | |
39040 | 39040 | 1922-11-18 | 7 | d | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094191 | 24094191 |
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]);