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 |
---|---|---|---|---|---|---|---|---|---|
48155 | 48155 | 1929-06-01 | 3 | a | The Communist bandits in the south of Jiangxi province. | China | http://trove.nla.gov.au/newspaper/page/24099231 | 24099231 | |
48156 | 48156 | 1929-06-01 | 3 | a | Plan for improvement of the railway lines in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24099231 | 24099231 | |
48163 | 48163 | 1929-06-01 | 5 | a | Hong Kong news/ Hong Kong and Guangdong authorities jointly wipe out the Communist bandits from Hainan island. Prince of Britain arrives Hong Kong. Sale of housemaids in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099233 | 24099233 | |
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 |
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]);