glam-datasets
2 rows where "file_created" is on date 2016-08-16 and publisher = "Queensland State Archives"
This data as json, CSV (advanced)
| Link | rowid ▼ | dataset_title | publisher | author | dataset_issued | dataset_modified | dataset_description | source | info_url | start_date | end_date | file_title | download_url | format | file_description | file_created | file_modified | file_size | licence |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 407 | 407 | Army Reservist payments 1909 to 1920 | Queensland State Archives | web@archives.qld.gov.au | 2016-08-16T23:27:57.390724 | 2022-06-27T23:51:42.832649 | This index was compiled from the [Register of Payments made to Army Reservists](https://www.archives… | data.qld.gov.au | https://data.qld.gov.au/dataset/696f4c13-a846-4cf7-8765-a1fdc471f77c | Army Reservist payments 1909 to 1920 | https://www.data.qld.gov.au/dataset/696f4c13-a846-4cf7-8765-a1fdc471f77c/resource/5e8042ce-bfe1-4430-801d-dddeaa61bbd5/download/index-to-army-reservists-1909-1920.csv | CSV | This open data file alphabetically lists the names of army reservists who received payments from the… | 2016-08-16T23:29:26.628723 | 2022-04-22T01:06:47.520126 | 338636.0 | Creative Commons Attribution 4.0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [glam-datasets] (
[dataset_title] TEXT,
[publisher] TEXT,
[author] TEXT,
[dataset_issued] TEXT,
[dataset_modified] TEXT,
[dataset_description] TEXT,
[source] TEXT,
[info_url] TEXT,
[start_date] TEXT,
[end_date] TEXT,
[file_title] TEXT,
[download_url] TEXT,
[format] TEXT,
[file_description] TEXT,
[file_created] TEXT,
[file_modified] TEXT,
[file_size] TEXT,
[licence] TEXT
);
CREATE INDEX [idx_glam-datasets_source_publisher_format_licence]
ON [glam-datasets] ([source], [publisher], [format], [licence]);