This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
44899 | 44899 | 1926-07-03 | 5 | a | Chinese Premier Yan Huiqing resigns and his successor Du Xigui. | China | http://trove.nla.gov.au/newspaper/page/24101617 | 24101617 | |
44900 | 44900 | 1926-07-03 | 5 | a | The Malay government helps to build naval port of Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24101617 | 24101617 | |
44901 | 44901 | 1926-07-03 | 5 | a | News on the mediation over the strike in Guangzhou and Hong Kong. | China | http://trove.nla.gov.au/newspaper/page/24101617 | 24101617 | |
44902 | 44902 | 1926-07-03 | 5 | a | Singaporean authority seize smuggled opium. | Singapore | http://trove.nla.gov.au/newspaper/page/24101617 | 24101617 | |
44903 | 44903 | 1926-07-03 | 5 | a | Epidemic in Thailand. | Singapore | http://trove.nla.gov.au/newspaper/page/24101617 | 24101617 | |
44904 | 44904 | 1926-07-03 | 5 | a | Fire in a Japanese university. | Japan | http://trove.nla.gov.au/newspaper/page/24101617 | 24101617 | |
44905 | 44905 | 1926-07-03 | 5 | b | Russian help the Chinese Nationalist army. | Japan | http://trove.nla.gov.au/newspaper/page/24101617 | 24101617 | |
44906 | 44906 | 1926-07-03 | 5 | b | Another strike in Japanese textile factory in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24101617 | 24101617 | |
44907 | 44907 | 1926-07-03 | 5 | b | Strikers in Guangzhou demand compensation and their union. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24101617 | 24101617 | |
44908 | 44908 | 1926-07-03 | 5 | b | Floods in Mexico. | America | http://trove.nla.gov.au/newspaper/page/24101617 | 24101617 | |
44909 | 44909 | 1926-07-03 | 5 | b | Talks of representatives of the Hong Kong and the Guangzhou governments on the strike. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24101617 | 24101617 | |
44910 | 44910 | 1926-07-03 | 5 | b | Shanghai newspaper reports the murder of Canadian woman in Sichuan. | China | http://trove.nla.gov.au/newspaper/page/24101617 | 24101617 | |
44911 | 44911 | 1926-07-03 | 5 | c | The anti-Chinese movement in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24101617 | 24101617 |
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]);