This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33086 | 33086 | 1918-03-09 | 3 | b-c | Revolutionaries are trying to take over Anhui province and the detailed report. | China | http://trove.nla.gov.au/newspaper/page/24097207 | 24097207 | |
33091 | 33091 | 1918-03-09 | 6 | b-c | Miscellaneous report on the Chinese politics. | China | http://trove.nla.gov.au/newspaper/page/24097212 | 24097212 | |
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 |
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]);