This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
48168 | 48168 | 1929-06-01 | 8 | a | Rumour says Guangzhou is besieged. | China | http://trove.nla.gov.au/newspaper/page/24099238 | 24099238 | |
48169 | 48169 | 1929-06-01 | 8 | a | Nanjing government dispatches troops to suppress Feng Yuxiang. | China | http://trove.nla.gov.au/newspaper/page/24099238 | 24099238 | |
48170 | 48170 | 1929-06-01 | 8 | a | Guangxi troops suffer heavy casualties during their attack Guangdong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099238 | 24099238 | |
48171 | 48171 | 1929-06-01 | 8 | a | Japanese troops are withdrawing from Wuhan, Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24099238 | 24099238 | |
48172 | 48172 | 1929-06-01 | 8 | a | Han Fuqu in Shandong and Feng Yuxiang. | China | http://trove.nla.gov.au/newspaper/page/24099238 | 24099238 | |
48173 | 48173 | 1929-06-01 | 8 | b | Turkish parliament imposes new restrictions on foreign immigrants. | Britain | http://trove.nla.gov.au/newspaper/page/24099238 | 24099238 | |
48174 | 48174 | 1929-06-01 | 8 | b | Australia news/ Second part of the report on the fighting of the Chinese Chamber of Commerce for peanut import and their letter to the government authorities signed by Chairman Zhu Songqing. Customer is detained in a Sydney restaurant for using counterfeit bank notes. New Chinese Consul-General in Australia Song Faxiang assumes office. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099238 | 24099238 | |
48175 | 48175 | 1929-06-01 | 8 | e | A notice by the Sydney Chinese Presbyterian Church. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099238 | 24099238 |
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]);