This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
33095 | 33095 | 1918-03-09 | 7 | c | China and Japan jointly dispatch troops to Siberia, and the report. | Britain | 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]);