This data as json, CSV (advanced)
Suggested facets: source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
22787 | 22787 | 1910-05-14 | 2 | a-b | First part of an editorial on the opium smuggling by the Chinese community in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802623 | 26802623 | |
22795 | 22795 | 1910-05-14 | 3 | a-b | Guangdong news. Report on Dongsha island. A case of murder by bandits in Xinyi county. Japanese newspapers permitted to enter Guangzhou from Hong Kong. A survey on the sale of salt. Ministry of communications inquires into preparation for the Guangzhou-Macao railway. Guangdong purchases army horses from Mongolia and Manchuria. Fashionable dress is changing for freedom in Foshan. A clan school in Foshan and the modern education. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802622 | 26802622 | |
22806 | 22806 | 1910-05-14 | 6 | a-b | Chinese paintings in British museum and comments by an English newspaper. | Britain | http://trove.nla.gov.au/newspaper/page/26802627 | 26802627 | |
22816 | 22816 | 1910-05-14 | 7 | a-b | Mei Guangda's (Quong Tart) wife, Margaret Scarlett, shoots and seriously injures her friend. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802626 | 26802626 | |
22825 | 22825 | 1910-05-14 | 8 | a-b | First part of a report on the truth about Zhenhua company's fundraising and the sale of floating shares in America, report by Liang Chaojie. | America | http://trove.nla.gov.au/newspaper/page/26802631 | 26802631 |
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]);