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 |
---|---|---|---|---|---|---|---|---|---|
46502 | 46502 | 1927-12-03 | 3 | b | Japanese ambassador to Beijing comments on the Chinese situation. | Japan | http://trove.nla.gov.au/newspaper/page/24098615 | 24098615 | |
46503 | 46503 | 1927-12-03 | 3 | b | New country might be built between Soviet Russia and Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24098615 | 24098615 | |
46504 | 46504 | 1927-12-03 | 3 | b | Why Yan Xishan's army are defeated (by Zhang Zuolin's troops). | China | http://trove.nla.gov.au/newspaper/page/24098615 | 24098615 | |
46514 | 46514 | 1927-12-03 | 5 | b | Prisoners in San Francisco on riots. | America | http://trove.nla.gov.au/newspaper/page/24098617 | 24098617 | |
46515 | 46515 | 1927-12-03 | 5 | b | Diplomatic relations between Britain and Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24098617 | 24098617 | |
46516 | 46516 | 1927-12-03 | 5 | b | Jiang Jieshi and Song Meiling to marry. | China | http://trove.nla.gov.au/newspaper/page/24098617 | 24098617 | |
46524 | 46524 | 1927-12-03 | 7 | b | Guangdong news/ (Song Dynasty national hero) Yue Fei's calligraphy is found in Xinhui county. Train derails in Ningyang. Garrison troops leave Guangzhou to attack Xinhui and Huaxian county. Mediation over the clash between civil corps (min tuan) and peasants' associations (nong min xie hui) in Huaaxian county. | China | http://trove.nla.gov.au/newspaper/page/24098619 | 24098619 |
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]);