This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47901 | 47901 | 1929-03-16 | 8 | a | Nanjing and Wuhan once again go different ways. | China | http://trove.nla.gov.au/newspaper/page/24099152 | 24099152 | |
47902 | 47902 | 1929-03-16 | 8 | a | Chinese people in Shanghai are following European life style. | China | http://trove.nla.gov.au/newspaper/page/24099152 | 24099152 | |
47903 | 47903 | 1929-03-16 | 8 | a | More chaos in Mexico. | America | http://trove.nla.gov.au/newspaper/page/24099152 | 24099152 | |
47904 | 47904 | 1929-03-16 | 8 | a | Queen's Hotel in Hong Kong on fire. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099152 | 24099152 | |
47905 | 47905 | 1929-03-16 | 8 | a | America helps Mexican authority to pacify the chaos. | Britain | http://trove.nla.gov.au/newspaper/page/24099152 | 24099152 | |
47906 | 47906 | 1929-03-16 | 8 | b | Australia news/ Earthquake in New Zealand. Arrest in Sydney for illegal wine. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099152 | 24099152 | |
47907 | 47907 | 1929-03-16 | 8 | c | Garden for hire in Bankstown, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099152 | 24099152 | |
47908 | 47908 | 1929-03-16 | 8 | c | Notice by Guo Jianying to resign from the position of executive member of the Chinese Chamber of Commerce in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099152 | 24099152 | |
47909 | 47909 | 1929-03-16 | 8 | d | Notice jointly issued by the Chinese Chamber of Commerce in Sydney and the Chinese-Foreign Famine Relief Committee in Shanghai calls for donations to the famine victims in north China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099152 | 24099152 |
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]);