This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
23026 | 23026 | 1910-06-25 | 6 | a | Preparation for establishment of specialty university in Beijing. | China | http://trove.nla.gov.au/newspaper/page/26802678 | 26802678 | |
23027 | 23027 | 1910-06-25 | 6 | a | Board of Revenue reviews report of foreign debt. | China | http://trove.nla.gov.au/newspaper/page/26802678 | 26802678 | |
23028 | 23028 | 1910-06-25 | 6 | a | Overseas Chinese consuls are required to spy on revolutionary rebellion. | China | http://trove.nla.gov.au/newspaper/page/26802678 | 26802678 | |
23029 | 23029 | 1910-06-25 | 6 | a | Japanese purchase land in south Manchuria for railway construction. | China | http://trove.nla.gov.au/newspaper/page/26802678 | 26802678 | |
23030 | 23030 | 1910-06-25 | 6 | a | Central authority responds to the railway construction in Hunan province. | China | http://trove.nla.gov.au/newspaper/page/26802678 | 26802678 | |
23031 | 23031 | 1910-06-25 | 6 | a-b | Guangdong news/ Luo Mubao's confession on the murder of Liu Shiji. Rich natural resources in Dongsha island. Feud and clan fighting in Dongguan county. Foreigners in Guangzhou want to know who is Liang Cheng. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802678 | 26802678 | |
23032 | 23032 | 1910-06-25 | 6 | b | The sick China (sickness of Lu Chuanlin, Ting Jie, Liang Dunyan and Zhang Renjun). | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802678 | 26802678 |
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]);