Weather Astronomy -Dataset

Dataset of weather astronomy of particular location(country)

@kaggle.kamalesh1997_weather_astronomy_dataset

Table List

1 table(29.63 KB)

Countryastronomy

@kaggle.kamalesh1997_weather_astronomy_dataset.countryastronomy

29.63 KB
238 rows
17 columns

unnamed_0 Unnamed: 0	name Name	region Region	country Country	lat Lat	lon Lon	tz_id Tz Id	localtime_epoch Localtime Epoch	localtime Localtime	sunrise Sunrise	sunset Sunset	moonrise Moonrise	moonset Moonset	moon_phase Moon Phase	moon_illumination Moon Illumination	is_moon_up Is Moon Up	is_sun_up Is Sun Up
	Kabul	Kabol	Afghanistan	34.52	69.18	Asia/Kabul	1675950896	Thu Feb 09 2023 18:24:00 GMT+0000 (Coordinated Universal Time)	06:45 AM	05:31 PM	08:52 PM	08:44 AM	Waning Gibbous	91	1
1	Lappoby-Aland	Aland	Finland	60.32	20.98	Europe/Mariehamn	1675950897	Thu Feb 09 2023 15:54:00 GMT+0000 (Coordinated Universal Time)	08:32 AM	05:09 PM	09:42 PM	09:43 AM	Waning Gibbous	91	1
2	Tirana	Tirane	Albania	41.33	19.82	Europe/Tirane	1675950898	Thu Feb 09 2023 14:54:00 GMT+0000 (Coordinated Universal Time)	06:44 AM	05:07 PM	08:47 PM	08:37 AM	Waning Gibbous	91	1
3	Algiers	Alger	Algeria	36.76	3.05	Africa/Algiers	1675950738	Thu Feb 09 2023 14:52:00 GMT+0000 (Coordinated Universal Time)	07:43 AM	06:21 PM	09:57 PM	09:44 AM	Waning Gibbous	91	1
4	Afao	American Samoa	United States of America	-14.34	-170.8	Pacific/Pago_Pago	1675950739	Thu Feb 09 2023 02:52:00 GMT+0000 (Coordinated Universal Time)	06:18 AM	06:56 PM	09:49 PM	09:30 AM	Waning Gibbous	91		1
5	Andorra La Vella	Andorra la Vella	Andorra	42.5	1.52	Europe/Andorra	1675950740	Thu Feb 09 2023 14:52:00 GMT+0000 (Coordinated Universal Time)	07:59 AM	06:17 PM	10:03 PM	09:52 AM	Waning Gibbous	91	1
6	Luanda	Cuanza Norte	Angola	-8.84	13.23	Africa/Luanda	1675950740	Thu Feb 09 2023 14:52:00 GMT+0000 (Coordinated Universal Time)	06:08 AM	06:34 PM	09:15 PM	08:51 AM	Waning Gibbous	91	1
7	The Valley	nan	Anguilla	18.22	-63.05	America/Anguilla	1675950741	Thu Feb 09 2023 09:52:00 GMT+0000 (Coordinated Universal Time)	06:42 AM	06:10 PM	09:30 PM	09:09 AM	Waning Gibbous	91
8	Saint John	Saint John	Antigua and Barbuda	17.12	-61.85	America/Antigua	1675950900	Thu Feb 09 2023 09:55:00 GMT+0000 (Coordinated Universal Time)	06:36 AM	06:07 PM	09:25 PM	09:04 AM	Waning Gibbous	91
9	Buenos Aires	Distrito Federal	Argentina	-34.59	-58.67	America/Argentina/Buenos_Aires	1675950901	Thu Feb 09 2023 10:55:00 GMT+0000 (Coordinated Universal Time)	06:23 AM	07:54 PM	10:07 PM	09:44 AM	Waning Gibbous	91


CREATE TABLE countryastronomy (
  "unnamed_0" BIGINT,
  "name" VARCHAR,
  "region" VARCHAR,
  "country" VARCHAR,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "tz_id" VARCHAR,
  "localtime_epoch" BIGINT,
  "localtime" TIMESTAMP,
  "sunrise" VARCHAR,
  "sunset" VARCHAR,
  "moonrise" VARCHAR,
  "moonset" VARCHAR,
  "moon_phase" VARCHAR,
  "moon_illumination" BIGINT,
  "is_moon_up" BIGINT,
  "is_sun_up" BIGINT
);