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

>10,000 rows count all where station_code = "UK0026" 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
8681070 8681070 20251203021807_5Lly7 UK0026 2025-12-04T14:13:41.121Z 2025-12-05T14:21:14.925Z
8681059 8681059 20251203021736_DInSK UK0026 2025-12-04T14:13:40.044Z 2025-12-05T14:21:14.529Z
8680951 8680951 20251203020219_53LnG UK0026 2025-12-04T14:13:26.218Z 2025-12-05T14:21:08.588Z
8680940 8680940 20251203015657_DF24l UK0026 2025-12-04T14:13:24.855Z 2025-12-05T14:21:08.199Z
8680936 8680936 20251203015657_QOfq3 UK0026 2025-12-04T14:13:24.511Z 2025-12-05T14:21:08.021Z
8680887 8680887 20251203014050_mNq2f UK0026 2025-12-04T14:13:11.159Z 2025-12-05T14:21:05.803Z
8680876 8680876 20251203013928_j4kvY UK0026 2025-12-04T14:13:10.242Z 2025-12-05T14:21:05.447Z
8680774 8680774 20251203011602_GoNP1 UK0026 2025-12-04T14:12:53.868Z 2025-12-05T14:21:00.465Z
8680765 8680765 20251203011451_1OJwl UK0026 2025-12-04T14:12:52.827Z 2025-12-05T14:21:00.073Z
8680745 8680745 20251203011148_L2P8s UK0026 2025-12-04T14:12:50.775Z 2025-12-05T14:20:58.940Z
8680689 8680689 20251203010216_C2gAC UK0026 2025-12-04T14:12:39.408Z 2025-12-05T14:20:52.473Z
8680629 8680629 20251203004851_A90BK UK0026 2025-12-04T14:12:30.125Z 2025-12-05T14:20:50.007Z
8680587 8680587 20251203004347_DDPEB UK0026 2025-12-04T14:12:25.325Z 2025-12-05T14:20:45.755Z
8680395 8680395 20251202234629_yb0TF UK0026 2025-12-04T14:11:55.531Z 2025-12-05T14:20:37.105Z
8676152 8676152 20251202053907_eBwmt UK0026 2025-12-03T14:24:47.195Z 2025-12-05T14:28:49.702Z
8675929 8675929 20251202052326_oKegH UK0026 2025-12-03T14:24:31.448Z 2025-12-05T14:28:44.454Z
8675905 8675905 20251202052254_3tSqW UK0026 2025-12-03T14:24:29.605Z 2025-12-05T14:28:43.853Z
8675791 8675791 20251202051504_78mUh UK0026 2025-12-03T14:24:15.546Z 2025-12-05T14:28:40.731Z
8675714 8675714 20251202051108_eMwMj UK0026 2025-12-03T14:24:12.386Z 2025-12-05T14:28:39.510Z
8675601 8675601 20251202050128_S5DXD UK0026 2025-12-03T14:23:55.363Z 2025-12-05T14:28:36.806Z
8674586 8674586 20251202025343_e4am2 UK0026 2025-12-03T14:22:05.429Z 2025-12-05T14:27:57.023Z
8674577 8674577 20251202025327_ZZFYq UK0026 2025-12-03T14:22:03.910Z 2025-12-05T14:27:56.776Z
8674562 8674562 20251202024908_eeU75 UK0026 2025-12-03T14:22:01.233Z 2025-12-05T14:27:56.000Z
8674548 8674548 20251202024512_fhLMW UK0026 2025-12-03T14:21:50.301Z 2025-12-05T14:27:55.339Z
8674519 8674519 20251202024058_7TYTd UK0026 2025-12-03T14:21:43.942Z 2025-12-05T14:27:52.212Z
8663293 8663293 20251130202824_7NHHK UK0026 2025-12-02T14:17:56.733Z 2025-12-05T14:34:04.153Z
8663057 8663057 20251130200100_KmeTX UK0026 2025-12-02T14:17:21.757Z 2025-12-05T14:33:55.825Z
8662780 8662780 20251130193156_HvqrT UK0026 2025-12-02T14:16:34.419Z 2025-12-05T14:33:47.836Z
8662677 8662677 20251130192008_umyNp UK0026 2025-12-02T14:16:17.618Z 2025-12-05T14:33:43.289Z
8662545 8662545 20251130190909_wyxPg UK0026 2025-12-02T14:15:52.167Z 2025-12-05T14:33:28.564Z
8658606 8658606 20251126054031_Ugu2B UK0026 2025-12-01T15:05:02.646Z 2025-12-04T15:11:35.872Z
8658400 8658400 20251125205813_BB8vD UK0026 2025-12-01T15:01:25.233Z 2025-12-04T15:07:03.141Z
8658379 8658379 20251125182427_8ZZbt UK0026 2025-12-01T15:00:54.468Z 2025-12-04T15:06:42.745Z
8657601 8657601 20251130055400_eC54a UK0026 2025-12-01T14:34:34.575Z 2025-12-05T14:45:34.054Z
8657249 8657249 20251130053727_kpfIq UK0026 2025-12-01T14:34:02.523Z 2025-12-05T14:45:27.597Z
8657151 8657151 20251130053213_2LOvZ UK0026 2025-12-01T14:33:56.519Z 2025-12-05T14:45:26.144Z
8657144 8657144 20251130053152_kQ8fR UK0026 2025-12-01T14:33:56.150Z 2025-12-05T14:45:25.996Z
8657119 8657119 20251130053130_23gBX UK0026 2025-12-01T14:33:55.316Z 2025-12-05T14:45:25.755Z
8656265 8656265 20251130044551_bJ6Hi UK0026 2025-12-01T14:28:14.787Z 2025-12-05T14:44:49.489Z
8656128 8656128 20251130043928_fnf9t UK0026 2025-12-01T14:28:05.579Z 2025-12-05T14:44:46.434Z
8655660 8655660 20251130041056_A22B0 UK0026 2025-12-01T14:27:20.554Z 2025-12-05T14:44:36.780Z
8655338 8655338 20251130035540_EkKSV UK0026 2025-12-01T14:26:48.128Z 2025-12-05T14:44:32.289Z
8655247 8655247 20251130035034_aUEw7 UK0026 2025-12-01T14:26:41.544Z 2025-12-05T14:44:30.324Z
8654796 8654796 20251130033318_7YSAb UK0026 2025-12-01T14:26:03.065Z 2025-12-05T14:44:24.022Z
8654726 8654726 20251130032834_U4y3Q UK0026 2025-12-01T14:25:49.371Z 2025-12-05T14:44:22.248Z
8654586 8654586 20251130032105_vb2YR UK0026 2025-12-01T14:25:36.007Z 2025-12-05T14:44:12.580Z
8654510 8654510 20251130031904_hLvpE UK0026 2025-12-01T14:25:32.341Z 2025-12-05T14:44:08.054Z
8654499 8654499 20251130031836_sVpm5 UK0026 2025-12-01T14:25:30.379Z 2025-12-05T14:44:07.058Z
8654419 8654419 20251130031503_lq7ve UK0026 2025-12-01T14:25:23.867Z 2025-12-05T14:43:55.521Z
8654334 8654334 20251130031127_IA0Ix UK0026 2025-12-01T14:25:09.987Z 2025-12-05T14:43:53.999Z
8653892 8653892 20251130024701_4mrQP UK0026 2025-12-01T14:24:26.908Z 2025-12-05T14:43:42.426Z
8652406 8652406 20251130010711_bedfD UK0026 2025-12-01T14:21:21.402Z 2025-12-05T14:42:43.934Z
8652327 8652327 20251130010316_tv79o UK0026 2025-12-01T14:21:16.452Z 2025-12-05T14:42:42.895Z
8652272 8652272 20251130010134_3CP8U UK0026 2025-12-01T14:21:05.850Z 2025-12-05T14:42:41.458Z
8651656 8651656 20251130000854_C6I2K UK0026 2025-12-01T14:19:39.238Z 2025-12-05T14:42:02.975Z
8650625 8650625 20251129205240_QZns6 UK0026 2025-12-01T14:16:44.735Z 2025-12-05T14:41:12.445Z
8650537 8650537 20251129203713_Bkzi4 UK0026 2025-12-01T14:16:25.031Z 2025-12-05T14:41:10.028Z
8650521 8650521 20251129203440_RhhFv UK0026 2025-12-01T14:16:23.035Z 2025-12-05T14:41:09.592Z
8650371 8650371 20251129200221_FLPPZ UK0026 2025-12-01T14:15:55.474Z 2025-12-05T14:41:05.147Z
8650298 8650298 20251129195116_IedoS UK0026 2025-12-01T14:15:45.193Z 2025-12-05T14:41:03.067Z
8650287 8650287 20251129194901_FEUoC UK0026 2025-12-01T14:15:43.324Z 2025-12-05T14:41:02.615Z
8650247 8650247 20251129194618_NyuHp UK0026 2025-12-01T14:15:34.402Z 2025-12-05T14:41:01.532Z
8650060 8650060 20251129191503_8gPBm UK0026 2025-12-01T14:14:57.682Z 2025-12-05T14:40:54.342Z
8650052 8650052 20251129191404_ZEhKc UK0026 2025-12-01T14:14:52.195Z 2025-12-05T14:40:54.005Z
8649402 8649402 20251129172205_yVzl0 UK0026 2025-12-01T14:12:26.716Z 2025-12-05T14:40:07.207Z
8644826 8644826 20251128200235_Lb7Jz UK0026 2025-11-30T14:22:45.687Z 2025-12-05T14:50:27.624Z
8644429 8644429 20251128192643_ZUm40 UK0026 2025-11-30T14:21:59.454Z 2025-12-05T14:50:22.121Z
8644416 8644416 20251128192600_c2O36 UK0026 2025-11-30T14:21:58.677Z 2025-12-05T14:50:21.961Z
8644096 8644096 20251128185701_Bu8Tb UK0026 2025-11-30T14:21:19.940Z 2025-12-05T14:50:16.138Z
8643908 8643908 20251128183817_7Ic3A UK0026 2025-11-30T14:20:48.306Z 2025-12-05T14:50:02.764Z
8643891 8643891 20251128183640_34YfI UK0026 2025-11-30T14:20:47.398Z 2025-12-05T14:49:59.047Z
8643779 8643779 20251128182634_qC23R UK0026 2025-11-30T14:20:40.709Z 2025-12-05T14:49:46.676Z
8643674 8643674 20251128181310_SXmF6 UK0026 2025-11-30T14:20:32.801Z 2025-12-05T14:49:34.818Z
8643367 8643367 20251128174620_0eRz1 UK0026 2025-11-30T14:19:56.906Z 2025-12-05T14:49:16.496Z
8637513 8637513 20251128054633_enWIe UK0026 2025-11-29T14:27:31.699Z 2025-12-05T14:59:56.883Z
8637403 8637403 20251128053735_HF3h2 UK0026 2025-11-29T14:27:12.637Z 2025-12-05T14:59:50.979Z
8637206 8637206 20251128051506_Kidcd UK0026 2025-11-29T14:26:58.285Z 2025-12-05T14:59:38.865Z
8637148 8637148 20251128050858_TWCEY UK0026 2025-11-29T14:26:53.955Z 2025-12-05T14:59:37.906Z
8637140 8637140 20251128050704_3ReWx UK0026 2025-11-29T14:26:53.015Z 2025-12-05T14:59:37.743Z
8637134 8637134 20251128050522_FwEXb UK0026 2025-11-29T14:26:52.860Z 2025-12-05T14:59:37.724Z
8637017 8637017 20251128045019_jXGYC UK0026 2025-11-29T14:26:33.493Z 2025-12-05T14:59:36.090Z
8636930 8636930 20251128043907_ZOhdW UK0026 2025-11-29T14:26:21.349Z 2025-12-05T14:59:32.118Z
8635279 8635279 20251128015948_9wRCT UK0026 2025-11-29T14:22:59.970Z 2025-12-05T14:58:33.489Z
8634739 8634739 20251128011553_y04r4 UK0026 2025-11-29T14:22:00.657Z 2025-12-05T14:58:24.377Z
8634734 8634734 20251128011544_VsXPQ UK0026 2025-11-29T14:21:59.966Z 2025-12-05T14:58:24.268Z
8633889 8633889 20251128000201_AtoRb UK0026 2025-11-29T14:20:28.974Z 2025-12-05T14:58:13.770Z
8633496 8633496 20251127232517_cqkD4 UK0026 2025-11-29T14:19:48.207Z 2025-12-05T14:57:43.763Z
8632928 8632928 20251127222013_MIFk2 UK0026 2025-11-29T14:18:35.348Z 2025-12-05T14:56:49.574Z
8632834 8632834 20251127220405_oh5gz UK0026 2025-11-29T14:18:27.525Z 2025-12-05T14:56:45.295Z
8632822 8632822 20251127220113_mUBbl UK0026 2025-11-29T14:18:26.627Z 2025-12-05T14:56:44.563Z
8632690 8632690 20251127213931_6Efm7 UK0026 2025-11-29T14:18:01.386Z 2025-12-05T14:56:32.884Z
8632612 8632612 20251127212539_4P3Zm UK0026 2025-11-29T14:17:51.634Z 2025-12-05T14:56:27.463Z
8625379 8625379 20251125210940_NA0Hm UK0026 2025-11-28T14:31:53.682Z 2025-12-04T15:07:11.904Z
8616796 8616796 20251126062950_Bgx8G UK0026 2025-11-27T14:31:50.233Z 2025-12-04T15:11:43.474Z
8616718 8616718 20251126061844_XC3JH UK0026 2025-11-27T14:31:45.203Z 2025-12-04T15:11:42.279Z
8616344 8616344 20251126055211_mBUc1 UK0026 2025-11-27T14:31:05.273Z 2025-12-04T15:11:38.054Z
8616227 8616227 20251126054723_1ozdI UK0026 2025-11-27T14:30:57.979Z 2025-12-04T15:11:37.107Z
8616118 8616118 20251126054108_CwNno UK0026 2025-11-27T14:30:33.174Z 2025-12-04T15:11:36.008Z
8615625 8615625 20251126051140_EpC0o UK0026 2025-11-27T14:30:03.188Z 2025-12-04T15:11:30.912Z
8615592 8615592 20251126051050_CVmjT UK0026 2025-11-27T14:29:49.118Z 2025-12-04T15:11:30.570Z

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