This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
52713 | 52713 | 1933-04-01 | 2 | c | A recent talks by Song Ziwen. Yan Xishan to help Zhang Xueliang. Tianjin in crisis. People in Beijing donate to purchase warplanes. The 19th Route Army ready to go north. Japanese naval fleet gather in Shanghai, Nanjing and Wuhan. Nanjing has a cold winter. | China | http://trove.nla.gov.au/newspaper/page/24091172 | 24091172 | |
52733 | 52733 | 1933-04-01 | 6 | c | Japanese delegation arrives New York. | America | http://trove.nla.gov.au/newspaper/page/24091176 | 24091176 |
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]);