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

1,604 rows where station_code = "BE0016" 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
9272067 9272067 20260127233326_ShAc0 BE0016 2026-01-29T14:25:26.916Z 2026-01-29T14:30:25.273Z
9260526 9260526 20260125050532_w3fjt BE0016 2026-01-26T14:22:07.115Z 2026-01-29T14:44:20.085Z
9260502 9260502 20260125045402_wObrt BE0016 2026-01-26T14:22:00.860Z 2026-01-29T14:44:18.697Z
9260409 9260409 20260125041643_B9Rwu BE0016 2026-01-26T14:21:36.290Z 2026-01-29T14:44:11.020Z
9260392 9260392 20260125041336_BrA0G BE0016 2026-01-26T14:21:33.420Z 2026-01-29T14:44:10.223Z
9260152 9260152 20260125024628_6Vng0 BE0016 2026-01-26T14:20:26.599Z 2026-01-29T14:43:51.395Z
9260111 9260111 20260125023752_hQYXr BE0016 2026-01-26T14:20:18.760Z 2026-01-29T14:43:49.208Z
9260023 9260023 20260125020755_h3wCk BE0016 2026-01-26T14:19:48.876Z 2026-01-29T14:43:42.032Z
9259924 9259924 20260125011244_CCELy BE0016 2026-01-26T14:19:18.118Z 2026-01-29T14:43:35.441Z
9259916 9259916 20260125011016_Wt32h BE0016 2026-01-26T14:19:16.639Z 2026-01-29T14:43:35.004Z
9259853 9259853 20260125004730_rPsZV BE0016 2026-01-26T14:18:54.521Z 2026-01-29T14:43:25.564Z
9259845 9259845 20260125004500_zGz5U BE0016 2026-01-26T14:18:53.600Z 2026-01-29T14:43:25.246Z
9259753 9259753 20260124235820_Yf5FK BE0016 2026-01-26T14:18:28.623Z 2026-01-29T14:43:17.458Z
9259721 9259721 20260124234147_6HvnS BE0016 2026-01-26T14:18:16.242Z 2026-01-29T14:43:15.204Z
9259652 9259652 20260124225806_KgRHK BE0016 2026-01-26T14:17:58.355Z 2026-01-29T14:43:11.206Z
9259649 9259649 20260124225236_zsS2k BE0016 2026-01-26T14:17:57.767Z 2026-01-29T14:43:11.056Z
9259644 9259644 20260124225156_EVETe BE0016 2026-01-26T14:17:52.850Z 2026-01-29T14:43:10.856Z
9259591 9259591 20260124215206_ljDha BE0016 2026-01-26T14:17:32.610Z 2026-01-29T14:43:07.772Z
9259575 9259575 20260124214127_HNHHn BE0016 2026-01-26T14:17:29.907Z 2026-01-29T14:43:06.997Z
9259127 9259127 20260124190157_370jY BE0016 2026-01-26T14:15:52.057Z 2026-01-29T14:42:37.977Z
9256165 9256165 20260124060541_uK3i3 BE0016 2026-01-25T14:16:05.510Z 2026-01-29T14:48:26.923Z
9256156 9256156 20260124060417_gFAzm BE0016 2026-01-25T14:16:03.896Z 2026-01-29T14:48:26.370Z
9256141 9256141 20260124060301_YzK37 BE0016 2026-01-25T14:16:01.851Z 2026-01-29T14:48:25.451Z
9256025 9256025 20260124054513_up2ud BE0016 2026-01-25T14:15:35.847Z 2026-01-29T14:48:18.897Z
9255894 9255894 20260124051413_bEiov BE0016 2026-01-25T14:15:04.435Z 2026-01-29T14:48:04.088Z
9255620 9255620 20260124042134_9G5u1 BE0016 2026-01-25T14:14:07.319Z 2026-01-29T14:47:42.940Z
9255562 9255562 20260124041246_45PQl BE0016 2026-01-25T14:13:57.947Z 2026-01-29T14:47:40.334Z
9255404 9255404 20260124032114_VCPI2 BE0016 2026-01-25T14:13:15.231Z 2026-01-29T14:47:28.651Z
9255386 9255386 20260124031643_r5noW BE0016 2026-01-25T14:13:09.836Z 2026-01-29T14:47:27.381Z
9255370 9255370 20260124030810_SNcGx BE0016 2026-01-25T14:13:06.745Z 2026-01-29T14:47:26.433Z
9254817 9254817 20260123213743_n0thV BE0016 2026-01-25T14:10:50.586Z 2026-01-29T14:46:43.991Z
9254695 9254695 20260123204553_r3944 BE0016 2026-01-25T14:10:23.615Z 2026-01-29T14:46:36.238Z
9254646 9254646 20260123203717_plL7E BE0016 2026-01-25T14:10:09.235Z 2026-01-29T14:46:33.628Z
9254476 9254476 20260123193359_gEsFv BE0016 2026-01-25T14:09:24.458Z 2026-01-29T14:46:25.744Z
9252672 9252672 20260123051118_M3neP BE0016 2026-01-24T14:16:38.910Z 2026-01-29T14:53:15.166Z
9252568 9252568 20260123041445_OBqSt BE0016 2026-01-24T14:16:13.276Z 2026-01-29T14:53:08.942Z
9252450 9252450 20260123031458_c8y5A BE0016 2026-01-24T14:15:39.897Z 2026-01-29T14:52:54.936Z
9252376 9252376 20260123023902_Dq3zV BE0016 2026-01-24T14:15:17.780Z 2026-01-29T14:52:47.538Z
9252228 9252228 20260123015231_11aYq BE0016 2026-01-24T14:14:47.977Z 2026-01-29T14:52:40.806Z
9252099 9252099 20260123010124_jPn4f BE0016 2026-01-24T14:14:21.596Z 2026-01-29T14:52:33.124Z
9252030 9252030 20260123004108_qR2ej BE0016 2026-01-24T14:14:08.601Z 2026-01-29T14:52:25.338Z
9251951 9251951 20260123000628_34cjO BE0016 2026-01-24T14:13:48.741Z 2026-01-29T14:52:18.544Z
9249684 9249684 20260122062927_ZuDX3 BE0016 2026-01-23T14:15:54.237Z 2026-01-29T14:58:49.451Z
9249679 9249679 20260122061921_t2GID BE0016 2026-01-23T14:15:53.288Z 2026-01-29T14:58:49.218Z
9249575 9249575 20260122055312_W0InN BE0016 2026-01-23T14:15:44.154Z 2026-01-29T14:58:45.344Z
9249564 9249564 20260122054944_0FHkk BE0016 2026-01-23T14:15:43.091Z 2026-01-29T14:58:44.940Z
9249546 9249546 20260122054508_idxM5 BE0016 2026-01-23T14:15:41.132Z 2026-01-29T14:58:44.000Z
9249423 9249423 20260122051503_Mi2RW BE0016 2026-01-23T14:15:21.235Z 2026-01-29T14:58:30.110Z
9249149 9249149 20260122034749_MGuEO BE0016 2026-01-23T14:14:40.260Z 2026-01-29T14:58:14.387Z
9249081 9249081 20260122033018_G5hP3 BE0016 2026-01-23T14:14:33.185Z 2026-01-29T14:58:11.983Z
9248337 9248337 20260121230159_aeBVA BE0016 2026-01-23T14:12:32.188Z 2026-01-29T14:57:14.268Z
9248324 9248324 20260121225429_Yznmk BE0016 2026-01-23T14:12:30.806Z 2026-01-29T14:57:13.870Z
9248260 9248260 20260121223656_6YP35 BE0016 2026-01-23T14:12:21.085Z 2026-01-29T14:57:10.613Z
9235119 9235119 20260120003125_2UCqX BE0016 2026-01-21T14:17:39.679Z 2026-01-28T14:58:31.506Z
9234317 9234317 20260119204420_QSOqZ BE0016 2026-01-21T14:13:36.948Z 2026-01-28T14:57:28.780Z
9223490 9223490 20260118005738_6GsIb BE0016 2026-01-19T14:19:33.203Z 2026-01-26T15:02:10.751Z
9222846 9222846 20260117210439_NGur1 BE0016 2026-01-19T14:16:29.384Z 2026-01-26T15:01:23.122Z
9160265 9160265 20260106051734_s2PCN BE0016 2026-01-07T14:12:02.891Z 2026-01-13T15:09:17.230Z
9160012 9160012 20260106043026_ThrPe BE0016 2026-01-07T14:11:05.318Z 2026-01-13T15:08:56.494Z
9159719 9159719 20260106033312_iGCYT BE0016 2026-01-07T14:10:14.707Z 2026-01-13T15:08:38.558Z
9155930 9155930 20260104063136_zqgX6 BE0016 2026-01-06T14:38:12.488Z 2026-01-12T15:11:32.509Z
9155827 9155827 20260104062501_0yMcY BE0016 2026-01-06T14:38:03.907Z 2026-01-12T15:11:29.248Z
9155668 9155668 20260104061129_bDDuD BE0016 2026-01-06T14:37:53.112Z 2026-01-12T15:11:23.608Z
9155217 9155217 20260104054436_I2F93 BE0016 2026-01-06T14:36:59.357Z 2026-01-12T15:10:54.081Z
9155149 9155149 20260104053816_aTBpg BE0016 2026-01-06T14:36:51.910Z 2026-01-12T15:10:50.774Z
9155095 9155095 20260104053523_rOQ2r BE0016 2026-01-06T14:36:48.442Z 2026-01-12T15:10:49.105Z
9155086 9155086 20260104053506_No2aa BE0016 2026-01-06T14:36:47.677Z 2026-01-12T15:10:48.802Z
9154771 9154771 20260104051338_UUvZa BE0016 2026-01-06T14:36:10.294Z 2026-01-12T15:10:19.278Z
9154667 9154667 20260104050703_a2iLC BE0016 2026-01-06T14:35:50.745Z 2026-01-12T15:10:14.240Z
9154266 9154266 20260104045012_2Owzh BE0016 2026-01-06T14:35:14.620Z 2026-01-12T15:09:43.677Z
9154107 9154107 20260104043728_T4etG BE0016 2026-01-06T14:34:47.267Z 2026-01-12T15:09:36.698Z
9154036 9154036 20260104043200_CgJYU BE0016 2026-01-06T14:34:41.194Z 2026-01-12T15:09:33.375Z
9153444 9153444 20260104035556_aIL7B BE0016 2026-01-06T14:33:22.236Z 2026-01-12T15:08:46.677Z
9150761 9150761 20260105032523_5NhBw BE0016 2026-01-06T14:11:18.292Z 2026-01-13T15:13:59.830Z
9150759 9150759 20260105032432_KxMo7 BE0016 2026-01-06T14:11:17.744Z 2026-01-13T15:13:59.604Z
9150371 9150371 20260105020056_nRHWP BE0016 2026-01-06T14:09:46.684Z 2026-01-13T15:13:21.711Z
9150358 9150358 20260105015638_slLtn BE0016 2026-01-06T14:09:44.047Z 2026-01-13T15:13:20.669Z
9150340 9150340 20260105015240_GelPb BE0016 2026-01-06T14:09:38.317Z 2026-01-13T15:13:19.163Z
9150338 9150338 20260105015239_Xf0ys BE0016 2026-01-06T14:09:37.574Z 2026-01-13T15:13:17.533Z
9150330 9150330 20260105015205_kCcyo BE0016 2026-01-06T14:09:35.295Z 2026-01-13T15:13:16.913Z
9150198 9150198 20260105012816_5o013 BE0016 2026-01-06T14:09:01.612Z 2026-01-13T15:13:10.419Z
9148939 9148939 20260104181022_kmW9H BE0016 2026-01-06T14:03:10.342Z 2026-01-13T15:11:28.118Z
9148914 9148914 20260104180609_FeESD BE0016 2026-01-06T14:03:00.709Z 2026-01-13T15:11:26.573Z
9146324 9146324 20260104034517_A6vQB BE0016 2026-01-05T14:22:06.506Z 2026-01-12T15:08:25.741Z
9146319 9146319 20260104034505_WpFnY BE0016 2026-01-05T14:22:05.918Z 2026-01-12T15:08:25.605Z
9146213 9146213 20260104034011_n6fJ2 BE0016 2026-01-05T14:21:53.211Z 2026-01-12T15:08:22.872Z
9145924 9145924 20260104033111_gLZcc BE0016 2026-01-05T14:21:26.023Z 2026-01-12T15:08:15.964Z
9145831 9145831 20260104032900_HEfDN BE0016 2026-01-05T14:21:20.648Z 2026-01-12T15:08:09.161Z
9144448 9144448 20260104024428_sZOOQ BE0016 2026-01-05T14:19:10.182Z 2026-01-12T15:07:07.875Z
9144430 9144430 20260104024419_pBP57 BE0016 2026-01-05T14:19:05.681Z 2026-01-12T15:07:07.397Z
9143786 9143786 20260104022243_X9Bg5 BE0016 2026-01-05T14:18:05.692Z 2026-01-12T15:06:33.392Z
9130804 9130804 20260103042011_upnEi BE0016 2026-01-04T14:11:43.190Z 2026-01-10T14:59:43.969Z
9129575 9129575 20260102231957_Tyyh7 BE0016 2026-01-04T14:04:52.537Z 2026-01-10T14:57:54.393Z
9127228 9127228 20260102030853_T003u BE0016 2026-01-03T14:09:15.222Z 2026-01-09T14:49:33.784Z
9127218 9127218 20260102030722_c9njk BE0016 2026-01-03T14:09:12.657Z 2026-01-09T14:49:33.478Z
9127144 9127144 20260102024714_8krQs BE0016 2026-01-03T14:08:44.272Z 2026-01-09T14:49:30.043Z
9126060 9126060 20251230184442_MuQBv BE0016 2026-01-02T15:08:15.922Z 2026-01-07T15:13:12.024Z
9126037 9126037 20251230182339_5A4ke BE0016 2026-01-02T15:07:54.606Z 2026-01-07T15:12:54.721Z
9123336 9123336 20251230231737_pHYPV BE0016 2026-01-02T14:24:36.600Z 2026-01-08T15:05:25.617Z
9123273 9123273 20251230222649_eN9Cs BE0016 2026-01-02T14:23:10.167Z 2026-01-08T15:05:09.877Z

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