This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30426 | 30426 | 1915-09-04 | 3 | a-b | International Newspaper Conference is held in Panama city, and Li Xingling is elected as a director of the board of International Newspaper Conference. | Other... | http://trove.nla.gov.au/newspaper/page/24094970 | 24094970 | |
30427 | 30427 | 1915-09-04 | 3 | b-c | Guangdong government is to promote industries in Guangdong and issues regulations of setting up industries in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24094970 | 24094970 | |
30428 | 30428 | 1915-09-04 | 3 | c | British newspaper reports that Yuan Shikai is to restore imperial system in China and China is going to have a big change. | Britain | http://trove.nla.gov.au/newspaper/page/24094970 | 24094970 | |
30429 | 30429 | 1915-09-04 | 3 | c | British troops and Turkish troops are fighting in Da Dun Ni Nao Shi (ppp) strait, and both sides suffer heavy loss. | Britain | http://trove.nla.gov.au/newspaper/page/24094970 | 24094970 | |
30430 | 30430 | 1915-09-04 | 3 | c | Different reports from Russia, Germany, Austria on battle situation in east Europe between the above three countries. | Other... | http://trove.nla.gov.au/newspaper/page/24094970 | 24094970 | |
30431 | 30431 | 1915-09-04 | 3 | c | Russian and German navies fight at Li Jia (ppp) strait, and German navy suffers heavy loss, | Other... | http://trove.nla.gov.au/newspaper/page/24094970 | 24094970 |
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]);