This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33079 | 33079 | 1918-03-09 | 2 | a-c | Editorial by Tung Wah Times on the changes of political situation in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097208 | 24097208 | |
33090 | 33090 | 1918-03-09 | 6 | a-b | An article written by Cai Yuankai of New Castle, New South Wales, says China should promote civilised marriage. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097212 | 24097212 | |
33092 | 33092 | 1918-03-09 | 6 | c-d | Miscellaneous/ A wise woman in Belgium. A British writer and his stories. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097212 | 24097212 | |
33093 | 33093 | 1918-03-09 | 7 | a | A notice from Tung Wah Times on the increase of subscription fees. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097211 | 24097211 | |
33094 | 33094 | 1918-03-09 | 7 | b-c | Australia news/ Sydney Post Office loses parcels and the investigation. Heavy rain in Melbourne. New South Wales government and its income of horse racing and other gambling. Names listed for donations to the Chinese Chamber of Commerce in Melbourne. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097211 | 24097211 | |
33096 | 33096 | 1918-03-09 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097211 | 24097211 |
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]);