This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
43711 | 43711 | 1925-08-29 | 3 | a | American ambassador in Beijing and his attitude towards the May 30 massacre in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24101257 | 24101257 | |
43712 | 43712 | 1925-08-29 | 3 | b | American secretary of state proposes an international conference in China on the tariff and extraterritoriality issues. | America | http://trove.nla.gov.au/newspaper/page/24101257 | 24101257 | |
43713 | 43713 | 1925-08-29 | 3 | b | Electricity supply to factories are cut in Shanghai. But Wing On Department Store and the Wing On textile factory continue their operation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101257 | 24101257 | |
43714 | 43714 | 1925-08-29 | 3 | b-c | Tang Shaoyi and Zhang Binglin oppose to the proposal for a national conference in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24101257 | 24101257 | |
43715 | 43715 | 1925-08-29 | 3 | c | A circular telegram issued by military and police officers in Hubei on the current situations there. | China | http://trove.nla.gov.au/newspaper/page/24101257 | 24101257 | |
43716 | 43716 | 1925-08-29 | 3 | c | Tung Wah Times reminds readers to pay their subscription fee. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101257 | 24101257 | |
43717 | 43717 | 1925-08-29 | 3 | d | A notice issued by the Chinese Chamber of Commerce in Sydney calls for donations to the unemployed workers in Shanghai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101257 | 24101257 |
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]);