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

4,041 rows where station_code = "UK008V" 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
9608818 9608818 20260404014528_F8krG UK008V 2026-04-05T12:11:50.783Z 2026-04-06T12:20:40.663Z
9598522 9598522 20260330005639_VGsUG UK008V 2026-03-31T12:10:47.966Z 2026-04-06T12:36:44.047Z
9598483 9598483 20260330003648_k493L UK008V 2026-03-31T12:10:42.052Z 2026-04-06T12:36:34.460Z
9598431 9598431 20260330001206_oZSH0 UK008V 2026-03-31T12:10:35.882Z 2026-04-06T12:36:32.354Z
9598389 9598389 20260329234417_AgkAb UK008V 2026-03-31T12:10:31.222Z 2026-04-06T12:36:28.674Z
9595523 9595523 20260330043144_wwqH4 UK008V 2026-03-31T12:01:38.418Z 2026-04-06T12:30:07.590Z
9595509 9595509 20260330042529_8HX0E UK008V 2026-03-31T12:01:36.396Z 2026-04-06T12:30:06.792Z
9594888 9594888 20260329005455_pQtfB UK008V 2026-03-30T12:10:31.831Z 2026-04-06T12:40:19.621Z
9594841 9594841 20260329004326_13a1j UK008V 2026-03-30T12:10:25.042Z 2026-04-06T12:40:17.773Z
9594753 9594753 20260329002024_glHNp UK008V 2026-03-30T12:10:16.718Z 2026-04-06T12:40:15.059Z
9592143 9592143 20260328005627_PtNhR UK008V 2026-03-29T12:07:12.946Z 2026-04-05T12:35:38.542Z
9592096 9592096 20260328003256_8dQXq UK008V 2026-03-29T12:07:10.199Z 2026-04-05T12:35:35.277Z
9591931 9591931 20260327231421_dpKI7 UK008V 2026-03-29T12:06:59.956Z 2026-04-05T12:35:21.353Z
9589980 9589980 20260328042557_LybRl UK008V 2026-03-29T12:01:48.360Z 2026-04-06T12:37:39.961Z
9589774 9589774 20260328040838_drdWD UK008V 2026-03-29T12:01:37.589Z 2026-04-06T12:37:33.171Z
9589753 9589753 20260328040521_c2MCt UK008V 2026-03-29T12:01:36.869Z 2026-04-06T12:37:32.722Z
9589548 9589548 20260328034548_v3o6J UK008V 2026-03-29T12:01:25.335Z 2026-04-06T12:37:27.451Z
9589408 9589408 20260328032804_L72Mn UK008V 2026-03-29T12:01:12.452Z 2026-04-06T12:37:22.697Z
9589152 9589152 20260328023734_OZmpZ UK008V 2026-03-29T12:00:47.450Z 2026-04-06T12:37:03.634Z
9589054 9589054 20260328021921_OTnDO UK008V 2026-03-29T12:00:41.225Z 2026-04-06T12:37:00.868Z
9588974 9588974 20260328020912_LvPVH UK008V 2026-03-29T12:00:36.244Z 2026-04-06T12:36:58.638Z
9588849 9588849 20260328013746_dwrOv UK008V 2026-03-29T12:00:23.076Z 2026-04-06T12:36:54.208Z
9588805 9588805 20260328012057_naDiR UK008V 2026-03-29T12:00:17.321Z 2026-04-06T12:36:52.106Z
9584528 9584528 20260325202956_SjQdj UK008V 2026-03-27T12:15:35.314Z 2026-04-03T12:39:18.843Z
9560570 9560570 20260321214144_rsIny UK008V 2026-03-23T12:11:53.301Z 2026-03-29T12:21:01.464Z
9560473 9560473 20260321213018_yiETv UK008V 2026-03-23T12:11:48.642Z 2026-03-29T12:21:00.636Z
9560132 9560132 20260321203354_Wf1Cn UK008V 2026-03-23T12:11:38.752Z 2026-03-29T12:20:58.138Z
9559833 9559833 20260321195745_7jKq8 UK008V 2026-03-23T12:11:31.706Z 2026-03-29T12:20:56.026Z
9555446 9555446 20260322045624_1jO2C UK008V 2026-03-23T12:03:26.165Z 2026-03-30T12:28:26.623Z
9555378 9555378 20260322044706_WGEn4 UK008V 2026-03-23T12:03:23.132Z 2026-03-30T12:28:25.747Z
9554823 9554823 20260322033815_P7lfG UK008V 2026-03-23T12:02:52.384Z 2026-03-30T12:28:09.375Z
9554792 9554792 20260322033455_L3FIy UK008V 2026-03-23T12:02:51.131Z 2026-03-30T12:28:08.968Z
9554480 9554480 20260322031255_IFGQv UK008V 2026-03-23T12:02:34.738Z 2026-03-30T12:28:04.587Z
9553199 9553199 20260322012356_ZKK0y UK008V 2026-03-23T12:01:18.971Z 2026-03-30T12:27:36.325Z
9552892 9552892 20260322005112_2Glao UK008V 2026-03-23T12:00:58.642Z 2026-03-30T12:27:31.842Z
9549134 9549134 20260319234912_zGaBY UK008V 2026-03-22T12:16:49.354Z 2026-03-28T12:33:21.534Z
9543733 9543733 20260321045838_THfYa UK008V 2026-03-22T12:04:35.232Z 2026-03-29T12:19:10.641Z
9543657 9543657 20260321043807_gOAY5 UK008V 2026-03-22T12:04:21.889Z 2026-03-29T12:19:09.832Z
9543595 9543595 20260321042503_QgH7F UK008V 2026-03-22T12:04:14.400Z 2026-03-29T12:19:09.215Z
9543537 9543537 20260321041851_caUve UK008V 2026-03-22T12:04:07.135Z 2026-03-29T12:19:08.787Z
9543502 9543502 20260321040509_e901H UK008V 2026-03-22T12:04:00.263Z 2026-03-29T12:19:08.356Z
9543491 9543491 20260321040442_yWsgU UK008V 2026-03-22T12:03:58.929Z 2026-03-29T12:19:08.297Z
9543456 9543456 20260321035857_5hzu6 UK008V 2026-03-22T12:03:52.774Z 2026-03-29T12:19:07.848Z
9542800 9542800 20260321012321_ELDEj UK008V 2026-03-22T12:01:40.032Z 2026-03-29T12:18:58.491Z
9541753 9541753 20260319213602_RrwxM UK008V 2026-03-21T12:29:19.716Z 2026-03-27T12:42:41.318Z
9541694 9541694 20260319212747_ohBii UK008V 2026-03-21T12:29:16.874Z 2026-03-27T12:42:40.881Z
9534920 9534920 20260320043952_7S3vx UK008V 2026-03-21T12:09:10.594Z 2026-03-28T12:34:23.512Z
9534543 9534543 20260320035746_IRIPk UK008V 2026-03-21T12:08:13.478Z 2026-03-28T12:34:19.150Z
9534258 9534258 20260320033853_bnSjm UK008V 2026-03-21T12:07:35.038Z 2026-03-28T12:34:16.733Z
9534212 9534212 20260320033646_QbBhR UK008V 2026-03-21T12:07:28.028Z 2026-03-28T12:34:16.122Z
9534021 9534021 20260320031730_WqnKb UK008V 2026-03-21T12:06:55.371Z 2026-03-28T12:34:03.769Z
9533851 9533851 20260320030621_5xFvV UK008V 2026-03-21T12:06:29.276Z 2026-03-28T12:34:01.599Z
9533740 9533740 20260320025357_3ecKh UK008V 2026-03-21T12:06:08.881Z 2026-03-28T12:33:59.956Z
9533615 9533615 20260320024603_H79z2 UK008V 2026-03-21T12:05:53.147Z 2026-03-28T12:33:56.969Z
9533488 9533488 20260320023226_yuqcX UK008V 2026-03-21T12:05:30.400Z 2026-03-28T12:33:53.454Z
9533461 9533461 20260320023057_8ME9K UK008V 2026-03-21T12:05:27.622Z 2026-03-28T12:33:53.131Z
9533439 9533439 20260320023052_zWKQQ UK008V 2026-03-21T12:05:26.633Z 2026-03-28T12:33:53.070Z
9533410 9533410 20260320022903_N91Jg UK008V 2026-03-21T12:05:22.593Z 2026-03-28T12:33:52.866Z
9533328 9533328 20260320022427_19dRJ UK008V 2026-03-21T12:05:10.686Z 2026-03-28T12:33:52.019Z
9532851 9532851 20260320013335_0HpIw UK008V 2026-03-21T12:03:48.295Z 2026-03-28T12:33:45.110Z
9532792 9532792 20260320012705_CEYai UK008V 2026-03-21T12:03:39.487Z 2026-03-28T12:33:44.069Z
9532654 9532654 20260320011637_h4fSE UK008V 2026-03-21T12:03:20.908Z 2026-03-28T12:33:35.018Z
9532530 9532530 20260320010511_uVJRK UK008V 2026-03-21T12:03:00.741Z 2026-03-28T12:33:33.613Z
9532243 9532243 20260320004028_frwf3 UK008V 2026-03-21T12:02:09.580Z 2026-03-28T12:33:26.129Z
9532223 9532223 20260320004017_wUd17 UK008V 2026-03-21T12:02:07.472Z 2026-03-28T12:33:26.014Z
9532138 9532138 20260320002127_KWe9U UK008V 2026-03-21T12:01:47.962Z 2026-03-28T12:33:24.832Z
9531801 9531801 20260319234939_6KDd5 UK008V 2026-03-21T12:00:53.111Z 2026-03-28T12:33:21.666Z
9531654 9531654 20260319233358_ggoce UK008V 2026-03-21T12:00:25.746Z 2026-03-28T12:33:19.856Z
9531605 9531605 20260319232805_650yr UK008V 2026-03-21T12:00:21.270Z 2026-03-28T12:33:19.153Z
9530944 9530944 20260318220418_npAxd UK008V 2026-03-20T12:24:52.214Z 2026-03-26T12:39:16.660Z
9530565 9530565 20260318211124_DR3f7 UK008V 2026-03-20T12:24:29.890Z 2026-03-26T12:39:13.870Z
9530499 9530499 20260318210324_SDE4T UK008V 2026-03-20T12:24:26.915Z 2026-03-26T12:39:13.020Z
9530487 9530487 20260318210212_8ZvjD UK008V 2026-03-20T12:24:26.380Z 2026-03-26T12:39:12.947Z
9521395 9521395 20260319041123_7462E UK008V 2026-03-20T12:07:56.494Z 2026-03-27T12:40:54.423Z
9520739 9520739 20260319033413_C6Ekm UK008V 2026-03-20T12:06:53.593Z 2026-03-27T12:40:46.798Z
9520691 9520691 20260319033158_JwEQ1 UK008V 2026-03-20T12:06:48.662Z 2026-03-27T12:40:46.330Z
9520354 9520354 20260319031202_tRjwR UK008V 2026-03-20T12:06:16.091Z 2026-03-27T12:40:42.263Z
9520146 9520146 20260319025628_U4srn UK008V 2026-03-20T12:05:50.121Z 2026-03-27T12:40:39.633Z
9520047 9520047 20260319024928_YRtHD UK008V 2026-03-20T12:05:35.400Z 2026-03-27T12:40:38.238Z
9519924 9519924 20260319024326_ScdVs UK008V 2026-03-20T12:05:23.119Z 2026-03-27T12:40:37.041Z
9519536 9519536 20260319021555_9A85N UK008V 2026-03-20T12:04:36.910Z 2026-03-27T12:40:32.210Z
9518313 9518313 20260319004820_Ovtl5 UK008V 2026-03-20T12:02:17.265Z 2026-03-27T12:40:08.299Z
9518219 9518219 20260319004330_nFSfs UK008V 2026-03-20T12:02:09.261Z 2026-03-27T12:40:07.684Z
9518093 9518093 20260319002714_z33X6 UK008V 2026-03-20T12:01:52.097Z 2026-03-27T12:40:06.199Z
9518081 9518081 20260319002647_eEnch UK008V 2026-03-20T12:01:51.616Z 2026-03-27T12:40:06.161Z
9517957 9517957 20260319001541_TdKRL UK008V 2026-03-20T12:01:37.020Z 2026-03-27T12:40:04.989Z
9517762 9517762 20260319000054_bmLcu UK008V 2026-03-20T12:01:13.295Z 2026-03-27T12:40:03.069Z
9517203 9517203 20260317225412_RjDcw UK008V 2026-03-19T12:27:19.266Z 2026-03-25T12:43:09.322Z
9516171 9516171 20260317200815_eqvNW UK008V 2026-03-19T12:25:43.748Z 2026-03-25T12:42:50.399Z
9510258 9510258 20260318024025_6Q8aE UK008V 2026-03-19T12:07:13.568Z 2026-03-26T12:37:11.053Z
9509417 9509417 20260318014758_SldUc UK008V 2026-03-19T12:05:16.723Z 2026-03-26T12:37:05.353Z
9508684 9508684 20260318010801_YsaIz UK008V 2026-03-19T12:03:38.731Z 2026-03-26T12:37:00.198Z
9508629 9508629 20260318010711_lrL3K UK008V 2026-03-19T12:03:32.793Z 2026-03-26T12:36:59.876Z
9508400 9508400 20260318005108_ruBVY UK008V 2026-03-19T12:03:00.249Z 2026-03-26T12:36:58.225Z
9508298 9508298 20260318004302_OaZ3a UK008V 2026-03-19T12:02:50.613Z 2026-03-26T12:36:57.645Z
9507964 9507964 20260317235817_YPkJ4 UK008V 2026-03-19T12:01:48.055Z 2026-03-26T12:36:54.735Z
9507738 9507738 20260317233806_SxHUL UK008V 2026-03-19T12:01:07.036Z 2026-03-26T12:36:52.982Z
9500907 9500907 20260315200011_ABobZ UK008V 2026-03-17T12:24:09.914Z 2026-03-23T12:22:42.265Z
9500846 9500846 20260315194505_3zOu9 UK008V 2026-03-17T12:23:59.221Z 2026-03-23T12:22:41.942Z
9493388 9493388 20260315232109_ZKIet UK008V 2026-03-17T12:00:39.962Z 2026-03-24T12:40:39.315Z

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