CM5(Thornton Road)

City of Bradford Metropolitan District Council

@ukgov.cm5thornton_road15

Table List

1 table(607.07 KB)

Table 1

@ukgov.cm5thornton_road15.table_1

607.07 KB
35040 rows
10 columns

date_time Date Time	rainfall_min Rainfall MIN	rainfall_max Rainfall MAX	rainfall_avg Rainfall AVG	rainfall_sum Rainfall SUM	rainfall_intensity_min Rainfall Intensity MIN	rainfall_intensity_max Rainfall Intensity MAX	rainfall_intensity_avg Rainfall Intensity AVG	rainfall_intensity_sum Rainfall Intensity SUM	fid FID
Tue Jan 02 2018 01:00:00 GMT+0000 (Coordinated Universal Time)									1
Tue Jan 02 2018 01:15:00 GMT+0000 (Coordinated Universal Time)									2
Tue Jan 02 2018 01:30:00 GMT+0000 (Coordinated Universal Time)									3
Tue Jan 02 2018 01:45:00 GMT+0000 (Coordinated Universal Time)									4
Tue Jan 02 2018 02:00:00 GMT+0000 (Coordinated Universal Time)									5
Tue Jan 02 2018 02:15:00 GMT+0000 (Coordinated Universal Time)									6
Tue Jan 02 2018 02:30:00 GMT+0000 (Coordinated Universal Time)									7
Tue Jan 02 2018 02:45:00 GMT+0000 (Coordinated Universal Time)									8
Tue Jan 02 2018 03:00:00 GMT+0000 (Coordinated Universal Time)									9
Tue Jan 02 2018 03:15:00 GMT+0000 (Coordinated Universal Time)									10


CREATE TABLE table_1 (
  "date_time" TIMESTAMP,
  "rainfall_min" DOUBLE,
  "rainfall_max" DOUBLE,
  "rainfall_avg" DOUBLE,
  "rainfall_sum" DOUBLE,
  "rainfall_intensity_min" DOUBLE,
  "rainfall_intensity_max" DOUBLE,
  "rainfall_intensity_avg" DOUBLE,
  "rainfall_intensity_sum" DOUBLE,
  "fid" BIGINT
);