This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28736 | 28736 | 1914-04-18 | 8 | a-b | Third and final part of proposal and regulations on the establishment of ping zheng yuan in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24093084 | 24093084 | |
28737 | 28737 | 1914-04-18 | 8 | b | Ranks for local officials to be finalised in China. | China | http://trove.nla.gov.au/newspaper/page/24093084 | 24093084 | |
28738 | 28738 | 1914-04-18 | 8 | b | Liang Qichao's daughter is married in Beijing and the grand wedding ceremony. | China | http://trove.nla.gov.au/newspaper/page/24093084 | 24093084 | |
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]);