This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28714 | 28714 | 1914-04-18 | 2 | c | Chinese cabinet under the presidential government system. Appointments and removal of the Chinese officialdom recently. | China | http://trove.nla.gov.au/newspaper/page/24093078 | 24093078 | |
28724 | 28724 | 1914-04-18 | 3 | c | King of Britain to sleep on the bed formerly owned by Napoleon while visiting Paris. | Britain | http://trove.nla.gov.au/newspaper/page/24093077 | 24093077 | |
28725 | 28725 | 1914-04-18 | 3 | c | A Catholic father in Paris is shot to dead. | France | http://trove.nla.gov.au/newspaper/page/24093077 | 24093077 | |
28732 | 28732 | 1914-04-18 | 7 | c | Miscellaneous report on the Chinese politics and officialdom. | China | http://trove.nla.gov.au/newspaper/page/24093081 | 24093081 | |
28739 | 28739 | 1914-04-18 | 8 | c | Guangdong news/ Governor Li Kaishen and the new coins. Handwoven clothes unsalable in Guangzhou and Foshan. Military budget of Guangdong province. Chamber of commerce suggests to lift the ban on gambling and is ridiculed. Evil gentry Mr Yin in Dongguan county. Bandits in Songlong town, Gaoyao county. | China | http://trove.nla.gov.au/newspaper/page/24093084 | 24093084 |
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]);