Examples

select *
from mwa.obs_data_file
where "count" < 24

Definition

Provides details of data files for each observation.

Column Name	Data Type	Description
obs_id	BIGINT	Observation ID
filetype	INTEGER	Data file type
filetypedescription	VARCHAR	Data file type description
count	BIGINT	Count of all files of this type
size	BIGINT	Size of all files of this type in bytes
archived_count	BIGINT	Count of archived files of this type
archived_size	BIGINT	Size of archived files of this type in bytes (excluding deleted files)
deleted_count	BIGINT	Count of deleted files of this type
deleted_size	BIGINT	Size of deleted files of this type in bytes
modtime	TIMESTAMP	Last modification date time (AWST)

note that the column named `count` is a reserved word in ADQL, so it must appear in quotes.