This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33060 | 33060 | 1918-03-02 | 2 | b-c | The Central Government in Beijing and the problem of local administration. | China | http://trove.nla.gov.au/newspaper/page/24097200 | 24097200 | |
33065 | 33065 | 1918-03-02 | 3 | b-c | Peace talks between the south and the north in China and the obstacles. | China | http://trove.nla.gov.au/newspaper/page/24097199 | 24097199 | |
33070 | 33070 | 1918-03-02 | 6 | b-c | A public notice issued by the Chinese Ministry of Internal Affairs to consolidate the traditional etiquette. | China | http://trove.nla.gov.au/newspaper/page/24097204 | 24097204 | |
33072 | 33072 | 1918-03-02 | 7 | b-c | Australia news/ An Australian passenger liner disappears on its way to New Guinea. Sydney post office loses four more parcels. Water mines found in the New Zealand waters. Federal government issues the sixth wartime bonds. A women thief is punished in Sydney even she is pregnant. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097203 | 24097203 |
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]);