This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
18564 | 18564 | 1907-12-07 | 2 | a-b | Third part of the article on political order written by Okuma Shigenobu, former Japanese prime minister and founder of the Constitutional Party. | Japan | http://trove.nla.gov.au/newspaper/page/26801564 | 26801564 | |
18569 | 18569 | 1907-12-07 | 3 | a-b | Guangdong news. Police training institution to be built in Guangzhou. Guangdong military authorities raises medical funds for Chinese army students in Japan. An army high school to be built in Guangzhou. Magistrate of Qiongshan county reports harassment of foreign missionaries to local security. Report on the financial deficit of Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801563 | 26801563 | |
18583 | 18583 | 1907-12-07 | 6 | a-b | First part of a petition submitted by Xiong Fanyu and other gentry on the establishment of parliament. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801568 | 26801568 | |
18600 | 18600 | 1907-12-07 | 8 | a-b | Second and final part of a report on the small kingdom, Han, in northern Manchuria. The report is translated from a Japanese magazine. | Japan | http://trove.nla.gov.au/newspaper/page/26801570 | 26801570 |
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]);