This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
52937 | 52937 | 1933-06-03 | 3 | a | Resistance to Japanese invasion in north China. | China | http://trove.nla.gov.au/newspaper/page/24091243 | 24091243 | |
52938 | 52938 | 1933-06-03 | 3 | b | Chinese General Ma Zhanshan talks in Berlin. | Germany | http://trove.nla.gov.au/newspaper/page/24091243 | 24091243 | |
52939 | 52939 | 1933-06-03 | 3 | b | Japanese ambassador in China prepares an advisory report on the Chinese affairs. | Japan | http://trove.nla.gov.au/newspaper/page/24091243 | 24091243 | |
52940 | 52940 | 1933-06-03 | 3 | d | Chen Cheng commits suicide after being defeated. | China | http://trove.nla.gov.au/newspaper/page/24091243 | 24091243 | |
52941 | 52941 | 1933-06-03 | 3 | d | Russia to build its embassy in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24091243 | 24091243 | |
52942 | 52942 | 1933-06-03 | 3 | e | Dutch authority guard against Japanese immigration to New Guinea | Other... | http://trove.nla.gov.au/newspaper/page/24091243 | 24091243 | |
52943 | 52943 | 1933-06-03 | 3 | e | Gu Weijun to go to visit America. | China | http://trove.nla.gov.au/newspaper/page/24091243 | 24091243 | |
52944 | 52944 | 1933-06-03 | 3 | e | Communists arrested in Seoul. | Japan | http://trove.nla.gov.au/newspaper/page/24091243 | 24091243 |
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]);