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 |
---|---|---|---|---|---|---|---|---|---|
45172 | 45172 | 1926-09-25 | 5 | a | Transportation between Guangzhou and Hong Kong to be resumed. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24101721 | 24101721 | |
45173 | 45173 | 1926-09-25 | 5 | a | British merchants' ships enter Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24101721 | 24101721 | |
45174 | 45174 | 1926-09-25 | 5 | a | The China Inland Mission and its priests. | China | http://trove.nla.gov.au/newspaper/page/24101721 | 24101721 | |
45175 | 45175 | 1926-09-25 | 5 | a | An attempt to bomb the Japanese consulate in Shanghai fails. | China | http://trove.nla.gov.au/newspaper/page/24101721 | 24101721 | |
45176 | 45176 | 1926-09-25 | 5 | a | Wu Peifu and Sun Chuanfang prepare a counterattack. | China | http://trove.nla.gov.au/newspaper/page/24101721 | 24101721 | |
45181 | 45181 | 1926-09-25 | 6 | a | Preparation of the Sydney Chinese Chamber of Commerce for the birthday celebration of Confucius, procedure of the ceremony and guest speakers. Photograph of Guo Jianying (W. Gock Young), honorary organiser of the committee. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101724 | 24101724 | |
45183 | 45183 | 1926-09-25 | 7 | a | Australia news/ Police in Sydney raid Chinese gambling dens. Attention to the people who want to send parcels to China. Bank teller in Sydney pays customers wrong amount of money. A man in Sydney is punished for sexual harassment. Three illegal Chinese immigrants are detained in Tamworth, New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101723 | 24101723 |
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]);