This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28290 | 28290 | 1913-12-20 | 3 | a-b | Sixth part of the draft constitution of the Republic of China, proposed by Liang Qichao. | China | http://trove.nla.gov.au/newspaper/page/24092928 | 24092928 | |
28307 | 28307 | 1913-12-20 | 6 | a-b | Miscellaneous report on the Chinese politics and officialdom. | China | http://trove.nla.gov.au/newspaper/page/24092933 | 24092933 | |
28309 | 28309 | 1913-12-20 | 7 | a-b | Australia news/ Australia recognises the Republic of China. A female lawyer in Melbourne and her excellent performance in the court. An ox liver found in Manly beach, Sydney. Smallpox in Sydney and its victims. A Chinese jeweller in Sydney is cheated. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092932 | 24092932 | |
28315 | 28315 | 1913-12-20 | 8 | a-b | Different opinions in China on the national parliament (the Progressive Party, Liang Qichao, and others). | China | http://trove.nla.gov.au/newspaper/page/24092935 | 24092935 |
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]);