This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34877 | 34877 | 1919-09-13 | 2 | e-f | Three Chinese delegates to the Paris Peace Conference visit America and their talks there. | America | http://trove.nla.gov.au/newspaper/page/24097860 | 24097860 | |
34878 | 34878 | 1919-09-13 | 2 | f | Secret plan of The Allies to carve up China. | America | http://trove.nla.gov.au/newspaper/page/24097860 | 24097860 | |
34879 | 34879 | 1919-09-13 | 3 | a | Chinese community in San Diego writes to American senator on the Shandong issues. | America | http://trove.nla.gov.au/newspaper/page/24097859 | 24097859 | |
34882 | 34882 | 1919-09-13 | 3 | b | American universities seek to recruit some more Chinese students. | America | http://trove.nla.gov.au/newspaper/page/24097859 | 24097859 | |
34883 | 34883 | 1919-09-13 | 3 | b | American view on the boycott to Japanese goods in Shanghai. | America | http://trove.nla.gov.au/newspaper/page/24097859 | 24097859 | |
34888 | 34888 | 1919-09-13 | 3 | d | Japanese foreign secretary talks about Shandong issues in America. | America | http://trove.nla.gov.au/newspaper/page/24097859 | 24097859 |
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]);