home / gmn_data_store / participating_station

Menu
  • Dashboards

participating_station

Each row represents a station recording a meteor sighting.

Data license: CC BY 4.0 license · Data source: Global Meteor Network

5,266 rows where station_code = "UK00BF" sorted by created_at descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: created_at (date), updated_at (date)

Link rowid meteor_unique_trajectory_identifier station_code created_at ▲ updated_at
8686099 8686099 20251203183345_iExE3 UK00BF 2025-12-05T14:11:02.007Z 2025-12-06T14:21:29.431Z
8685946 8685946 20251203174920_YoNHk UK00BF 2025-12-05T14:10:33.669Z 2025-12-06T14:21:22.832Z
8678905 8678905 20251202180835_lCOTf UK00BF 2025-12-04T14:08:30.237Z 2025-12-06T14:25:38.065Z
8678889 8678889 20251202180044_AHaYO UK00BF 2025-12-04T14:08:25.123Z 2025-12-06T14:25:34.161Z
8677015 8677015 20251202064010_12j3o UK00BF 2025-12-03T14:26:11.642Z 2025-12-06T14:35:32.944Z
8676747 8676747 20251202062030_g0RX2 UK00BF 2025-12-03T14:25:32.283Z 2025-12-06T14:35:28.070Z
8676602 8676602 20251202060704_2I4GT UK00BF 2025-12-03T14:25:21.153Z 2025-12-06T14:35:24.417Z
8676411 8676411 20251202055146_9QRie UK00BF 2025-12-03T14:25:11.576Z 2025-12-06T14:35:21.421Z
8676379 8676379 20251202054950_EwSxE UK00BF 2025-12-03T14:25:09.840Z 2025-12-06T14:35:20.875Z
8676308 8676308 20251202054523_MYtSy UK00BF 2025-12-03T14:25:01.699Z 2025-12-06T14:35:19.958Z
8676293 8676293 20251202054442_6oaPE UK00BF 2025-12-03T14:24:57.050Z 2025-12-06T14:35:19.637Z
8676007 8676007 20251202053053_619Iu UK00BF 2025-12-03T14:24:35.700Z 2025-12-06T14:35:06.422Z
8675987 8675987 20251202052834_5X6sK UK00BF 2025-12-03T14:24:34.937Z 2025-12-06T14:35:06.200Z
8675918 8675918 20251202052257_DArRJ UK00BF 2025-12-03T14:24:29.975Z 2025-12-06T14:35:04.714Z
8675856 8675856 20251202051854_2wpXN UK00BF 2025-12-03T14:24:26.186Z 2025-12-06T14:35:03.420Z
8675564 8675564 20251202045633_0g8Ha UK00BF 2025-12-03T14:23:51.596Z 2025-12-06T14:34:56.343Z
8675547 8675547 20251202045557_6jwAO UK00BF 2025-12-03T14:23:50.825Z 2025-12-06T14:34:56.024Z
8675537 8675537 20251202045507_Lbzry UK00BF 2025-12-03T14:23:50.385Z 2025-12-06T14:34:55.835Z
8675481 8675481 20251202044716_Hh7YH UK00BF 2025-12-03T14:23:45.917Z 2025-12-06T14:34:54.105Z
8675130 8675130 20251202040334_abF74 UK00BF 2025-12-03T14:23:05.569Z 2025-12-06T14:34:30.479Z
8675111 8675111 20251202040145_3N9aL UK00BF 2025-12-03T14:23:03.405Z 2025-12-06T14:34:29.709Z
8675016 8675016 20251202035228_JBv6E UK00BF 2025-12-03T14:22:50.748Z 2025-12-06T14:34:27.371Z
8674975 8674975 20251202034519_a42MO UK00BF 2025-12-03T14:22:47.350Z 2025-12-06T14:34:26.301Z
8674903 8674903 20251202033756_e25Cu UK00BF 2025-12-03T14:22:42.117Z 2025-12-06T14:34:22.589Z
8674877 8674877 20251202033543_3zk3u UK00BF 2025-12-03T14:22:39.988Z 2025-12-06T14:34:21.874Z
8674800 8674800 20251202032748_B3lMQ UK00BF 2025-12-03T14:22:26.282Z 2025-12-06T14:34:19.533Z
8674711 8674711 20251202031041_Wfl7t UK00BF 2025-12-03T14:22:13.958Z 2025-12-06T14:34:16.202Z
8674680 8674680 20251202030653_G3pzT UK00BF 2025-12-03T14:22:12.245Z 2025-12-06T14:34:15.401Z
8674672 8674672 20251202030531_8HzeW UK00BF 2025-12-03T14:22:11.992Z 2025-12-06T14:34:15.279Z
8674619 8674619 20251202025849_l3X15 UK00BF 2025-12-03T14:22:08.293Z 2025-12-06T14:34:13.989Z
8674466 8674466 20251202022852_8uqgC UK00BF 2025-12-03T14:21:40.483Z 2025-12-06T14:34:09.691Z
8668019 8668019 20251130054054_VuUr7 UK00BF 2025-12-02T14:41:30.504Z 2025-12-06T14:49:55.305Z
8662845 8662845 20251130193908_85Fw2 UK00BF 2025-12-02T14:16:50.709Z 2025-12-06T14:39:33.073Z
8661871 8661871 20251130172558_VZXTq UK00BF 2025-12-02T14:13:27.984Z 2025-12-06T14:38:40.106Z
8661786 8661786 20251130171132_gSbPV UK00BF 2025-12-02T14:13:01.941Z 2025-12-06T14:38:31.963Z
8658044 8658044 20251130063135_XXwRt UK00BF 2025-12-01T14:34:52.394Z 2025-12-06T14:50:25.709Z
8657579 8657579 20251130055308_K8OsG UK00BF 2025-12-01T14:34:33.566Z 2025-12-06T14:50:12.261Z
8657118 8657118 20251130053044_5H0CD UK00BF 2025-12-01T14:33:55.104Z 2025-12-06T14:49:44.919Z
8655492 8655492 20251130040424_VPfZ5 UK00BF 2025-12-01T14:27:00.024Z 2025-12-06T14:49:23.854Z
8655401 8655401 20251130040048_N1CRV UK00BF 2025-12-01T14:26:52.958Z 2025-12-06T14:49:13.841Z
8655267 8655267 20251130035130_ooMXG UK00BF 2025-12-01T14:26:42.378Z 2025-12-06T14:48:58.632Z
8655241 8655241 20251130035002_brxYT UK00BF 2025-12-01T14:26:41.013Z 2025-12-06T14:48:56.575Z
8655172 8655172 20251130034658_X93Rf UK00BF 2025-12-01T14:26:37.001Z 2025-12-06T14:48:52.757Z
8655134 8655134 20251130034519_6SDXW UK00BF 2025-12-01T14:26:24.863Z 2025-12-06T14:48:51.785Z
8654935 8654935 20251130033844_ZvoEJ UK00BF 2025-12-01T14:26:11.181Z 2025-12-06T14:48:50.166Z
8654152 8654152 20251130030122_P3pIF UK00BF 2025-12-01T14:24:54.891Z 2025-12-06T14:48:38.156Z
8653874 8653874 20251130024512_aP2Fx UK00BF 2025-12-01T14:24:24.380Z 2025-12-06T14:48:33.872Z
8653860 8653860 20251130024435_wGaoB UK00BF 2025-12-01T14:24:23.488Z 2025-12-06T14:48:33.757Z
8653785 8653785 20251130023949_qcdbb UK00BF 2025-12-01T14:24:13.877Z 2025-12-06T14:48:31.944Z
8653276 8653276 20251130020509_Ufqfg UK00BF 2025-12-01T14:23:08.573Z 2025-12-06T14:47:52.552Z
8652579 8652579 20251130012218_zuePk UK00BF 2025-12-01T14:21:43.899Z 2025-12-06T14:47:39.628Z
8652567 8652567 20251130012106_yu2iw UK00BF 2025-12-01T14:21:41.541Z 2025-12-06T14:47:39.456Z
8652466 8652466 20251130011101_L8Gal UK00BF 2025-12-01T14:21:27.852Z 2025-12-06T14:47:37.456Z
8652253 8652253 20251130005844_8DUzW UK00BF 2025-12-01T14:21:03.056Z 2025-12-06T14:47:32.913Z
8652098 8652098 20251130004730_XrnWE UK00BF 2025-12-01T14:20:42.804Z 2025-12-06T14:47:16.793Z
8652032 8652032 20251130004200_9NzqF UK00BF 2025-12-01T14:20:29.947Z 2025-12-06T14:47:00.482Z
8651939 8651939 20251130003522_jrk2G UK00BF 2025-12-01T14:20:17.825Z 2025-12-06T14:46:56.446Z
8645457 8645457 20251128221700_oFkqq UK00BF 2025-11-30T14:23:45.776Z 2025-12-06T14:54:58.480Z
8645349 8645349 20251128212247_Vre14 UK00BF 2025-11-30T14:23:35.821Z 2025-12-06T14:54:54.213Z
8645021 8645021 20251128202858_2TCgp UK00BF 2025-11-30T14:22:58.654Z 2025-12-06T14:54:50.059Z
8644833 8644833 20251128200248_Zmcc2 UK00BF 2025-11-30T14:22:46.157Z 2025-12-06T14:54:47.940Z
8644399 8644399 20251128192444_GknT0 UK00BF 2025-11-30T14:21:56.746Z 2025-12-06T14:54:41.715Z
8644266 8644266 20251128191241_iPARK UK00BF 2025-11-30T14:21:32.442Z 2025-12-06T14:54:40.074Z
8643555 8643555 20251128180612_lIx2p UK00BF 2025-11-30T14:20:12.788Z 2025-12-06T14:53:51.363Z
8643490 8643490 20251128180115_Qqu25 UK00BF 2025-11-30T14:20:05.321Z 2025-12-06T14:53:50.077Z
8642957 8642957 20251128170730_ihQ9r UK00BF 2025-11-30T14:19:03.293Z 2025-12-06T14:53:38.418Z
8637656 8637656 20251128060634_RIkq1 UK00BF 2025-11-29T14:27:40.124Z 2025-12-06T15:04:02.106Z
8637577 8637577 20251128055419_ZUwC9 UK00BF 2025-11-29T14:27:35.839Z 2025-12-06T15:04:01.412Z
8637520 8637520 20251128054710_01ZEk UK00BF 2025-11-29T14:27:32.287Z 2025-12-06T15:04:00.830Z
8637518 8637518 20251128054637_Ii0Ll UK00BF 2025-11-29T14:27:31.977Z 2025-12-06T15:04:00.803Z
8637509 8637509 20251128054606_PYuwC UK00BF 2025-11-29T14:27:31.433Z 2025-12-06T15:04:00.709Z
8637369 8637369 20251128053328_9wAT0 UK00BF 2025-11-29T14:27:07.114Z 2025-12-06T15:03:59.316Z
8637174 8637174 20251128051129_00Dml UK00BF 2025-11-29T14:26:55.762Z 2025-12-06T15:03:57.225Z
8637120 8637120 20251128050209_5cLQL UK00BF 2025-11-29T14:26:51.541Z 2025-12-06T15:03:56.631Z
8636962 8636962 20251128044128_d7OZb UK00BF 2025-11-29T14:26:23.797Z 2025-12-06T15:03:53.062Z
8636745 8636745 20251128042139_lu2Pf UK00BF 2025-11-29T14:26:08.531Z 2025-12-06T15:03:39.104Z
8636413 8636413 20251128034221_3F2Fu UK00BF 2025-11-29T14:25:28.195Z 2025-12-06T15:03:15.130Z
8635960 8635960 20251128030221_LNhpm UK00BF 2025-11-29T14:24:42.226Z 2025-12-06T15:02:54.597Z
8635916 8635916 20251128025857_JfMH4 UK00BF 2025-11-29T14:24:23.599Z 2025-12-06T15:02:53.975Z
8635783 8635783 20251128024729_D5u3X UK00BF 2025-11-29T14:24:09.397Z 2025-12-06T15:02:50.816Z
8635319 8635319 20251128020327_2w7Wq UK00BF 2025-11-29T14:23:03.233Z 2025-12-06T15:02:43.359Z
8635026 8635026 20251128013433_zPgvf UK00BF 2025-11-29T14:22:23.534Z 2025-12-06T15:02:39.830Z
8634094 8634094 20251128002107_s4t9h UK00BF 2025-11-29T14:20:42.313Z 2025-12-06T15:01:51.349Z
8633747 8633747 20251127235110_hco3n UK00BF 2025-11-29T14:20:10.663Z 2025-12-06T15:01:48.280Z
8633712 8633712 20251127234640_1MA2I UK00BF 2025-11-29T14:20:07.005Z 2025-12-06T15:01:48.023Z
8633681 8633681 20251127234527_rzeJH UK00BF 2025-11-29T14:20:05.733Z 2025-12-06T15:01:47.958Z
8633595 8633595 20251127233629_6uLBF UK00BF 2025-11-29T14:19:56.980Z 2025-12-06T15:01:46.005Z
8633473 8633473 20251127232056_jCpSJ UK00BF 2025-11-29T14:19:45.994Z 2025-12-06T15:01:44.221Z
8633292 8633292 20251127225900_WQh42 UK00BF 2025-11-29T14:19:22.092Z 2025-12-06T15:01:41.984Z
8632708 8632708 20251127213953_Xq32l UK00BF 2025-11-29T14:18:05.322Z 2025-12-06T15:01:32.555Z
8632372 8632372 20251127205641_1iHym UK00BF 2025-11-29T14:17:19.642Z 2025-11-30T14:35:13.453Z
8616599 8616599 20251126061358_ILlPr UK00BF 2025-11-27T14:31:22.177Z 2025-12-04T15:11:41.261Z
8616466 8616466 20251126060137_jRsdU UK00BF 2025-11-27T14:31:12.674Z 2025-12-04T15:11:39.731Z
8616431 8616431 20251126055957_0JbGr UK00BF 2025-11-27T14:31:11.429Z 2025-12-04T15:11:39.476Z
8616414 8616414 20251126055626_dP4Xn UK00BF 2025-11-27T14:31:10.051Z 2025-12-04T15:11:38.986Z
8616210 8616210 20251126054644_He20G UK00BF 2025-11-27T14:30:56.592Z 2025-12-04T15:11:36.960Z
8616057 8616057 20251126053426_fwCiL UK00BF 2025-11-27T14:30:23.856Z 2025-12-04T15:11:34.896Z
8615921 8615921 20251126052846_4Y8jW UK00BF 2025-11-27T14:30:17.195Z 2025-12-04T15:11:33.794Z
8615877 8615877 20251126052541_p5P4M UK00BF 2025-11-27T14:30:14.795Z 2025-12-04T15:11:33.282Z
8615767 8615767 20251126051812_mT2oy UK00BF 2025-11-27T14:30:09.674Z 2025-12-04T15:11:32.128Z

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE participating_station
(
    meteor_unique_trajectory_identifier text     NOT NULL,
    station_code                        text     NOT NULL,
    created_at                          datetime NOT NULL DEFAULT (
        strftime(
                '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc'
            )
        ),
    updated_at                          datetime NOT NULL DEFAULT (
        strftime(
                '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc'
            )
        ),
    FOREIGN KEY (meteor_unique_trajectory_identifier) REFERENCES meteor (unique_trajectory_identifier),
    FOREIGN KEY (station_code) REFERENCES station (code),
    UNIQUE (meteor_unique_trajectory_identifier, station_code) ON CONFLICT IGNORE
);
CREATE INDEX participating_station_station_code_covering_index ON participating_station (station_code, meteor_unique_trajectory_identifier);
CREATE INDEX participating_station_created_at_index ON participating_station (created_at);
CREATE INDEX participating_station_updated_at_index ON participating_station (updated_at);
Powered by Datasette · Queries took 1.2ms · Data license: CC BY 4.0 license · Data source: Global Meteor Network