This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31085 | 31085 | 1916-04-01 | 3 | c-d | Japanese in Shandong province purchase copper and transport back to Japan. | China | http://trove.nla.gov.au/newspaper/page/24095210 | 24095210 | |
31101 | 31101 | 1916-04-01 | 8 | c-d | Guangdong news/ Long Jianzhang's family members return to Guangzhou. French consul in Guangzhou reports the current situation in Yunnan. Guangdong authority finds it impossible to cut military budget. Bandit chieftain in Shunde county is arrested. Government spies everywhere in Guangzhou, capital of Guangdong province. A ferry capsized in Doumen, of Xinhui county, and the tragedy. Government spy in Nanxiong county harasses local business and the report. | China | http://trove.nla.gov.au/newspaper/page/24095217 | 24095217 |
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]);