izMeteors_camera_status_tbl

Data license: CC BY 4.0 license

status

shows whether there have been observations in the last 7 days

28 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: obs_id, cam_id, obs_lat, obs_lon, obs_height, status, updated_at, last_upload (date), created_at (date), updated_at (date)

CREATE TABLE "izMeteors_camera_status_tbl" (
"id" INTEGER,
  "obs_id" TEXT,
  "cam_id" INTEGER,
  "obs_lat" REAL,
  "obs_lon" REAL,
  "obs_height" REAL,
  "status" TEXT,
  "last_upload" TIMESTAMP,
  "created_at" TIMESTAMP,
  "updated_at" TIMESTAMP
);