This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28676 | 28676 | 1914-04-04 | 8 | a-b | First part of proposal and regulations on the establishment of ping zheng yuan in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24093068 | 24093068 | |
28677 | 28677 | 1914-04-04 | 8 | b-c | Bandits and Sun Yatsen's followers are making trouble in Henan and Hubei provinces. | China | http://trove.nla.gov.au/newspaper/page/24093068 | 24093068 | |
28678 | 28678 | 1914-04-04 | 8 | c | Guangdong news/ All political parties and associations are required to register. Another bandit chieftain Zhang Yahua is executed in Zengcheng county. Hooligans in Xiangshan county are punished for school harassment. Kang Youwei's properties that were once confiscated are now returned to him. | China | http://trove.nla.gov.au/newspaper/page/24093068 | 24093068 |
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]);