This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34964 | 34964 | 1919-10-11 | 3 | b | Opening of the Guangdong provincial legislature assembly. | China | http://trove.nla.gov.au/newspaper/page/24097891 | 24097891 | |
34971 | 34971 | 1919-10-11 | 6 | b | Russian military authority in Lushun refuses Chinese ship to enter the Lushun River. | America | http://trove.nla.gov.au/newspaper/page/24097896 | 24097896 | |
34972 | 34972 | 1919-10-11 | 6 | b | Japanese ambassador to Washington and American President Wilson talk on the return of Shandong to China. | America | http://trove.nla.gov.au/newspaper/page/24097896 | 24097896 | |
34973 | 34973 | 1919-10-11 | 6 | b | Peace talks in China between the south and the north is halted again. | America | http://trove.nla.gov.au/newspaper/page/24097896 | 24097896 | |
34974 | 34974 | 1919-10-11 | 6 | b | American President Wilson is ill. | America | http://trove.nla.gov.au/newspaper/page/24097896 | 24097896 | |
34982 | 34982 | 1919-10-11 | 8 | b | Guangdong news/ The military government refuse to permit the construction of tram road in Guangzhou. Japanese consul in Guangzhou protests against the boycott to Japanese goods and his talks with local commercial chambers. Guangdong businessmen in Shanghai purchase and transport rice to their home town for disaster relief. Some women in Panyu county would rather die than return to their husbands' home. Bandits in Taishan county. Magistrate of Zengcheng county is removed for embezzlement. | China | http://trove.nla.gov.au/newspaper/page/24097898 | 24097898 |
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]);