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 |
---|---|---|---|---|---|---|---|---|---|
54091 | 54091 | 1934-04-28 | 2 | b | China news/ Economic Committee of the central government in Nanjing passes resolutions to the loans from America, and Song Ziwen reports to the Committee the loans from America. Third part of the draft constitution of the Republic of China. Sun Dianying's troops are besieged. | China | http://trove.nla.gov.au/newspaper/page/24095994 | 24095994 | |
54094 | 54094 | 1934-04-28 | 3 | b | Xiao Focheng reports that Chinese immigrants are murdered in Thailand. | Other... | http://trove.nla.gov.au/newspaper/page/24095993 | 24095993 | |
54101 | 54101 | 1934-04-28 | 5 | b | Market of wheat flour in Guangzhou and Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24095997 | 24095997 | |
54102 | 54102 | 1934-04-28 | 5 | b | Hong Kong government issues new regulations for registration of immigrants. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24095997 | 24095997 |
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]);