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 |
|---|---|---|---|---|---|---|---|---|---|
| 40822 | 40822 | 1923-12-22 | 3 | b | Leaders of Anfu faction are pardoned. | China | http://trove.nla.gov.au/newspaper/page/24094655 | 24094655 | |
| 40829 | 40829 | 1923-12-22 | 6 | b | English newspaper in Hong Kong reports that Sun Yatsen confiscates public property in Guangdong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24094660 | 24094660 | |
| 40834 | 40834 | 1923-12-22 | 7 | b | A building under construction in Melbourne collapses and some workers injured. | Australia | http://trove.nla.gov.au/newspaper/page/24094659 | 24094659 | |
| 40835 | 40835 | 1923-12-22 | 7 | b | Bush fire in Wagga Wagga, New South Wales. | Australia | http://trove.nla.gov.au/newspaper/page/24094659 | 24094659 | |
| 40836 | 40836 | 1923-12-22 | 7 | b | A baby boy found in the central railway station, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094659 | 24094659 | |
| 40837 | 40837 | 1923-12-22 | 7 | b | A baby is found dead in St Mary Church, Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24094659 | 24094659 | |
| 40838 | 40838 | 1923-12-22 | 7 | b | Anti-foreign emotion in Guangzhou. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24094659 | 24094659 | |
| 40839 | 40839 | 1923-12-22 | 7 | b | The war in Guangdong/ Headquarters of the Yunnan army moves to Shaoguan. Yunnan army force local businessmen to apply for gun license. Mo Guohua occupies Sanshui county. Zhu Zhuowen and Chen Yong'an. Survey on the war disaster in local Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094659 | 24094659 |
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]);