This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30998 | 30998 | 1916-03-04 | 3 | a-b | Origin of restoring imperial system and Yuan Shikai's conspiracy for an emperor ( continued) | China | http://trove.nla.gov.au/newspaper/page/24095178 | 24095178 | |
31009 | 31009 | 1916-03-04 | 7 | a-b | Australia news/Sydney starts to construct its internal railways. A German shop in Sydney is bombed. Statistics show that crimes in New South Wales increase this year. Infantile paralysis is spreading in New Zealand resulting in schools closing. Government does not regulate the closing time of public bars in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24095182 | 24095182 | |
31012 | 31012 | 1916-03-04 | 8 | a-b | Chinese central government attempts to recruit high-level and influential personnel in Shanghai in order to cope with current difficult situation. | China |
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]);