AMS Pasadena Precipitation Data

Department of Transportation

@usgov.dot_gov_ams_pasadena_precipitation_data

Table List

1 table(9.27 KB)

Table 1

@usgov.dot_gov_ams_pasadena_precipitation_data.table_1

9.27 KB
365 rows
8 columns

year Year	month Month	day Day	temperature_f_24_hrs_ending_at_observation_time_max Temperature (F) – 24 Hrs. Ending At Observation Time - Max	temperature_f_24_hrs_ending_at_observation_time_min Temperature (F) – 24 Hrs. Ending At Observation Time - Min	temperature_f_at_observation Temperature (F) – At Observation	precipitation_24_hours_amount_ending_at_observation_ti_ba0e4b73 Precipitation – 24 Hours Amount Ending At Observation Time – Rain, Melted Snow, Etc. (in)
2013	6	1	92	61	88
2013	6	2	88	64	78
2013	6	3	80	61	79	0.01
2013	6	4	80	61	79
2013	6	5	79	60	78
2013	6	6	79	58	78
2013	6	7	81	59	81
2013	6	8	81	61	77
2013	6	9	82	62	79
2013	6	10	80	61	76


CREATE TABLE table_1 (
  "preliminary" VARCHAR,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "temperature_f_24_hrs_ending_at_observation_time_max" BIGINT,
  "temperature_f_24_hrs_ending_at_observation_time_min" BIGINT,
  "temperature_f_at_observation" BIGINT,
  "precipitation_24_hours_amount_ending_at_observation_ti_ba0e4b73" DOUBLE
);