This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34446 | 34446 | 1919-05-03 | 3 | b-c | Korean people and their independence movement. | China | http://trove.nla.gov.au/newspaper/page/24097701 | 24097701 | |
34458 | 34458 | 1919-05-03 | 7 | b-c | Journalist and branch leader of the Nationalist Party (Guomindang) is arrested in Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24097705 | 24097705 | |
34463 | 34463 | 1919-05-03 | 8 | b-c | Guangdong news/ Road construction in Guangzhou. Preparation for the opening of the second provincial legislature. Rice price continues going down. Many people donate to the famine victims in Guangdong. Rice market in Dongguan county. Bandits in Dongguan. Bandits in Yangshan county. | China | http://trove.nla.gov.au/newspaper/page/24097708 | 24097708 |
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]);