CM6(Shipley Airedale Road)

City of Bradford Metropolitan District Council

@ukgov.cm6shipley_airedale_road12

Table List

1 table(608.36 KB)

Table 1

@ukgov.cm6shipley_airedale_road12.table_1

608.36 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
Mon Jan 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)									1
Mon Jan 01 2018 00:15:00 GMT+0000 (Coordinated Universal Time)									2
Mon Jan 01 2018 00:30:00 GMT+0000 (Coordinated Universal Time)									3
Mon Jan 01 2018 00:45:00 GMT+0000 (Coordinated Universal Time)									4
Mon Jan 01 2018 01:00:00 GMT+0000 (Coordinated Universal Time)									5
Mon Jan 01 2018 01:15:00 GMT+0000 (Coordinated Universal Time)									6
Mon Jan 01 2018 01:30:00 GMT+0000 (Coordinated Universal Time)									7
Mon Jan 01 2018 01:45:00 GMT+0000 (Coordinated Universal Time)									8
Mon Jan 01 2018 02:00:00 GMT+0000 (Coordinated Universal Time)									9
Mon Jan 01 2018 02: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
);