This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24521 | 24521 | 1911-05-13 | 6 | a | Donations needed for Nanqiang Association | Nanqiang Association in Guangzhou entreats donations in Sydney. | Other... | http://trove.nla.gov.au/newspaper/page/24091774 | 24091774 |
24522 | 24522 | 1911-05-13 | 6 | a | Thanks to Chinese doctor | Tang Liangnan is appreciated for his Chinese medicine techniques. | Australia | http://trove.nla.gov.au/newspaper/page/24091774 | 24091774 |
24523 | 24523 | 1911-05-13 | 6 | a-b | Petition leaders to Beijing for meeting ofrescuing the state. | The Comrade Association requests its petition leaders come to Beijing for meeting on rescuing the country as threats of foreign invades arise. | China | http://trove.nla.gov.au/newspaper/page/24091774 | 24091774 |
24524 | 24524 | 1911-05-13 | 6 | b | Coronation ceremony of British Emperor | statistics of the army and money spent in the coronation ceremony. | Other... | http://trove.nla.gov.au/newspaper/page/24091774 | 24091774 |
24525 | 24525 | 1911-05-13 | 6 | b | New cabinet set up in China | The new cabinet was set up in China on May 9th with Qing Di as the premier. | China | http://trove.nla.gov.au/newspaper/page/24091774 | 24091774 |
24526 | 24526 | 1911-05-13 | 6 | b | Riot in Hangzhou | Riot occurred in Hangzhou on the rising price of rice. | China | http://trove.nla.gov.au/newspaper/page/24091774 | 24091774 |
24527 | 24527 | 1911-05-13 | 6 | b | War may happen between China and Japan | War may result from trade disagreements between China and Japan. | Russia | http://trove.nla.gov.au/newspaper/page/24091774 | 24091774 |
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]);