This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
37861 | 37861 | 1921-11-12 | 8 | a | Fiction/ A sad woman, part IX (final section). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093757 | 24093757 | |
37862 | 37862 | 1921-11-12 | 8 | b-c | Guangdong news/ Guangzhou municipal government borrows foreign loans for infrastructure development. Pork peddlers are robbed near Guangzhou. Temple levy in Gaoyao county causes some protest. Troops occupy temple. Memorial ceremony in the Confucian temple in Panyu and Nanhai. Big fire in the western part of Guangzhou. Portuguese army are still preparing for battle with Chinese troops. Guangzhou government opposes the negotiation between Beijing government and Portuguese ambassador. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093757 | 24093757 | |
37863 | 37863 | 1921-11-12 | 8 | c | Chinese Speech Society in Sydney (hua qiao yan shuo hui) to gather and the topic will be 'Washington Conference and China'. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093757 | 24093757 | |
37864 | 37864 | 1921-11-12 | 8 | d | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093757 | 24093757 |
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]);