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

6,534 rows where station_code = "UK00B5" 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
9272354 9272354 20260128014339_tAXgY UK00B5 2026-01-29T14:26:30.933Z 2026-01-29T14:30:25.335Z
9272321 9272321 20260128013441_hkPqF UK00B5 2026-01-29T14:26:25.492Z 2026-01-29T14:30:25.329Z
9252075 9252075 20260123005151_bIOzL UK00B5 2026-01-24T14:14:17.516Z 2026-01-29T14:52:27.290Z
9251967 9251967 20260123000805_h3WUd UK00B5 2026-01-24T14:13:50.291Z 2026-01-29T14:52:19.141Z
9251890 9251890 20260122234637_rScD4 UK00B5 2026-01-24T14:13:31.357Z 2026-01-29T14:52:15.657Z
9251870 9251870 20260122233659_Ia29L UK00B5 2026-01-24T14:13:26.976Z 2026-01-29T14:52:14.266Z
9251842 9251842 20260122232053_vsgS2 UK00B5 2026-01-24T14:13:21.580Z 2026-01-29T14:52:12.524Z
9251817 9251817 20260122231543_2tngU UK00B5 2026-01-24T14:13:19.570Z 2026-01-29T14:52:11.618Z
9251788 9251788 20260122225621_1TX3N UK00B5 2026-01-24T14:13:14.039Z 2026-01-29T14:52:10.156Z
9251752 9251752 20260122222526_2ohqP UK00B5 2026-01-24T14:13:06.695Z 2026-01-29T14:52:07.818Z
9251705 9251705 20260122220923_2qxCh UK00B5 2026-01-24T14:12:58.199Z 2026-01-29T14:52:01.532Z
9243048 9243048 20260121033556_2kLCg UK00B5 2026-01-22T14:20:23.808Z 2026-01-29T15:04:44.783Z
9242907 9242907 20260121031311_y2qfB UK00B5 2026-01-22T14:19:43.382Z 2026-01-29T15:04:29.088Z
9242884 9242884 20260121030753_24OuR UK00B5 2026-01-22T14:19:38.994Z 2026-01-29T15:04:26.720Z
9242853 9242853 20260121025900_1CLpm UK00B5 2026-01-22T14:19:32.645Z 2026-01-29T15:04:24.196Z
9242846 9242846 20260121025826_3aAAJ UK00B5 2026-01-22T14:19:32.084Z 2026-01-29T15:04:24.103Z
9242422 9242422 20260121014828_locte UK00B5 2026-01-22T14:17:48.888Z 2026-01-29T15:03:58.052Z
9242046 9242046 20260121001255_ZUadN UK00B5 2026-01-22T14:15:59.479Z 2026-01-29T15:03:27.300Z
9237690 9237690 20260120055029_3LoTH UK00B5 2026-01-21T14:27:19.257Z 2026-01-28T15:01:36.428Z
9237600 9237600 20260120054155_ZFecp UK00B5 2026-01-21T14:27:06.073Z 2026-01-28T15:01:32.570Z
9237580 9237580 20260120053931_ElL4d UK00B5 2026-01-21T14:27:03.786Z 2026-01-28T15:01:31.871Z
9237559 9237559 20260120053547_e3FBP UK00B5 2026-01-21T14:27:00.595Z 2026-01-28T15:01:31.150Z
9236461 9236461 20260120032209_XyUch UK00B5 2026-01-21T14:22:53.712Z 2026-01-28T15:00:01.893Z
9222817 9222817 20260117205814_22s9s UK00B5 2026-01-19T14:16:21.651Z 2026-01-26T15:01:22.215Z
9218943 9218943 20260117063916_vAWyx UK00B5 2026-01-18T14:14:19.195Z 2026-01-25T14:58:56.242Z
9218873 9218873 20260117061520_YWbOI UK00B5 2026-01-18T14:14:02.660Z 2026-01-25T14:58:54.292Z
9218733 9218733 20260117053156_uNg2s UK00B5 2026-01-18T14:13:27.906Z 2026-01-25T14:58:37.245Z
9218695 9218695 20260117051855_XN5HH UK00B5 2026-01-18T14:13:14.858Z 2026-01-25T14:58:35.787Z
9218547 9218547 20260117043309_2xUYs UK00B5 2026-01-18T14:12:36.137Z 2026-01-25T14:58:29.777Z
9218534 9218534 20260117042758_tm04r UK00B5 2026-01-18T14:12:33.120Z 2026-01-25T14:58:29.152Z
9218392 9218392 20260117033421_OKsM3 UK00B5 2026-01-18T14:11:54.394Z 2026-01-25T14:58:24.263Z
9214513 9214513 20260116064707_HTbG0 UK00B5 2026-01-17T14:21:49.637Z 2026-01-24T15:13:45.741Z
9214374 9214374 20260116062325_3YQjR UK00B5 2026-01-17T14:21:14.479Z 2026-01-24T15:13:31.936Z
9214334 9214334 20260116061853_VORCZ UK00B5 2026-01-17T14:21:07.820Z 2026-01-24T15:13:30.600Z
9213879 9213879 20260116045654_mWcik UK00B5 2026-01-17T14:18:56.949Z 2026-01-24T15:12:50.237Z
9203573 9203573 20260114051802_0TMnt UK00B5 2026-01-15T14:24:53.110Z 2026-01-22T15:10:10.062Z
9203186 9203186 20260114044138_3awGK UK00B5 2026-01-15T14:23:34.109Z 2026-01-22T15:10:03.331Z
9203115 9203115 20260114043302_Q3w0C UK00B5 2026-01-15T14:23:20.256Z 2026-01-22T15:10:01.766Z
9202904 9202904 20260114041728_PLNbK UK00B5 2026-01-15T14:22:44.941Z 2026-01-22T15:09:59.018Z
9202266 9202266 20260114032505_09XhB UK00B5 2026-01-15T14:20:49.406Z 2026-01-22T15:09:15.309Z
9202086 9202086 20260114031525_Ig0Nc UK00B5 2026-01-15T14:20:24.372Z 2026-01-22T15:09:13.273Z
9201816 9201816 20260114025714_a3G2o UK00B5 2026-01-15T14:19:47.812Z 2026-01-22T15:09:10.118Z
9201583 9201583 20260114023406_o63f8 UK00B5 2026-01-15T14:19:08.424Z 2026-01-22T15:09:06.395Z
9201242 9201242 20260114015951_cEsLQ UK00B5 2026-01-15T14:18:03.797Z 2026-01-22T15:09:00.333Z
9201172 9201172 20260114015048_TVtjh UK00B5 2026-01-15T14:17:42.427Z 2026-01-22T15:08:58.942Z
9201157 9201157 20260114014945_T61hH UK00B5 2026-01-15T14:17:40.647Z 2026-01-22T15:08:58.674Z
9201051 9201051 20260114013752_2sDTK UK00B5 2026-01-15T14:17:21.270Z 2026-01-22T15:08:56.063Z
9200910 9200910 20260114012006_ATXUq UK00B5 2026-01-15T14:16:51.216Z 2026-01-22T15:08:36.360Z
9200545 9200545 20260114002242_ms33p UK00B5 2026-01-15T14:15:29.961Z 2026-01-22T15:08:18.020Z
9200378 9200378 20260113235432_TlTbb UK00B5 2026-01-15T14:14:53.218Z 2026-01-22T15:08:14.865Z
9200317 9200317 20260113234200_ckRZO UK00B5 2026-01-15T14:14:43.270Z 2026-01-22T15:08:13.760Z
9194794 9194794 20260112224157_p7gFC UK00B5 2026-01-14T14:10:42.226Z 2026-01-21T15:04:21.111Z
9194618 9194618 20260112213430_m5hAD UK00B5 2026-01-14T14:10:01.064Z 2026-01-21T15:04:19.265Z
9194218 9194218 20260112185652_TiHo1 UK00B5 2026-01-14T14:08:05.168Z 2026-01-21T15:03:40.976Z
9180662 9180662 20260110212316_3PHzJ UK00B5 2026-01-12T14:07:54.865Z 2026-01-19T15:16:26.421Z
9180647 9180647 20260110212040_Nnhzh UK00B5 2026-01-12T14:07:50.922Z 2026-01-19T15:16:25.977Z
9180564 9180564 20260110205330_kCcbV UK00B5 2026-01-12T14:07:31.114Z 2026-01-19T15:16:22.540Z
9180503 9180503 20260110204212_CCnWo UK00B5 2026-01-12T14:07:21.432Z 2026-01-19T15:16:20.479Z
9176920 9176920 20260110063958_Ow2eh UK00B5 2026-01-11T14:10:20.887Z 2026-01-18T15:09:07.543Z
9176910 9176910 20260110063909_ND3Up UK00B5 2026-01-11T14:10:19.633Z 2026-01-18T15:09:07.191Z
9176872 9176872 20260110063346_vdr2K UK00B5 2026-01-11T14:10:13.487Z 2026-01-18T15:09:05.653Z
9176727 9176727 20260110061306_6J4EN UK00B5 2026-01-11T14:09:49.509Z 2026-01-18T15:08:51.940Z
9174751 9174751 20260109221648_jiirJ UK00B5 2026-01-11T14:04:16.389Z 2026-01-18T15:07:09.301Z
9174720 9174720 20260109215803_ZZsWK UK00B5 2026-01-11T14:04:09.320Z 2026-01-18T15:07:07.516Z
9174690 9174690 20260109214308_hyDhy UK00B5 2026-01-11T14:04:03.435Z 2026-01-18T15:06:58.158Z
9174436 9174436 20260109185117_jz38f UK00B5 2026-01-11T14:03:11.440Z 2026-01-18T15:06:45.827Z
9174404 9174404 20260109175442_WBgui UK00B5 2026-01-11T14:03:01.747Z 2026-01-18T15:06:43.744Z
9159127 9159127 20260106014915_aTAhD UK00B5 2026-01-07T14:08:22.587Z 2026-01-13T15:08:09.216Z
9158968 9158968 20260106010521_fHDpn UK00B5 2026-01-07T14:07:48.758Z 2026-01-13T15:07:52.976Z
9158947 9158947 20260106010300_sJPIe UK00B5 2026-01-07T14:07:45.008Z 2026-01-13T15:07:52.064Z
9158834 9158834 20260106003648_vXD5b UK00B5 2026-01-07T14:07:23.658Z 2026-01-13T15:07:47.743Z
9158566 9158566 20260105231820_rgyVV UK00B5 2026-01-07T14:06:32.156Z 2026-01-13T15:07:29.745Z
9158548 9158548 20260105230915_ucb2N UK00B5 2026-01-07T14:06:29.122Z 2026-01-13T15:07:29.037Z
9158496 9158496 20260105224320_GGsmN UK00B5 2026-01-07T14:06:16.643Z 2026-01-13T15:07:24.814Z
9158438 9158438 20260105222853_KRgNi UK00B5 2026-01-07T14:06:05.820Z 2026-01-13T15:07:22.186Z
9158363 9158363 20260105220050_RfPxm UK00B5 2026-01-07T14:05:49.821Z 2026-01-13T15:07:19.269Z
9158201 9158201 20260105205812_E3Anb UK00B5 2026-01-07T14:05:16.645Z 2026-01-13T15:07:03.448Z
9157966 9157966 20260105193445_HZyx2 UK00B5 2026-01-07T14:04:21.479Z 2026-01-13T15:06:48.014Z
9157927 9157927 20260105192454_b1B3p UK00B5 2026-01-07T14:04:10.212Z 2026-01-13T15:06:45.622Z
9157852 9157852 20260105190007_cuOIl UK00B5 2026-01-07T14:03:50.253Z 2026-01-13T15:06:34.270Z
9157790 9157790 20260105184816_ETz1e UK00B5 2026-01-07T14:03:34.503Z 2026-01-13T15:06:29.218Z
9156110 9156110 20260104064800_d3ZjB UK00B5 2026-01-06T14:38:35.093Z 2026-01-12T15:11:38.440Z
9155925 9155925 20260104063129_1Pg9t UK00B5 2026-01-06T14:38:11.683Z 2026-01-12T15:11:32.266Z
9155911 9155911 20260104063038_qw6KQ UK00B5 2026-01-06T14:38:11.206Z 2026-01-12T15:11:31.882Z
9155903 9155903 20260104063011_oIk2w UK00B5 2026-01-06T14:38:10.269Z 2026-01-12T15:11:31.621Z
9155684 9155684 20260104061543_Sh0wU UK00B5 2026-01-06T14:37:54.114Z 2026-01-12T15:11:24.096Z
9155672 9155672 20260104061304_5VE3T UK00B5 2026-01-06T14:37:53.260Z 2026-01-12T15:11:23.673Z
9155553 9155553 20260104060402_E6BG7 UK00B5 2026-01-06T14:37:31.698Z 2026-01-12T15:11:06.964Z
9155320 9155320 20260104054948_hRVQj UK00B5 2026-01-06T14:37:13.810Z 2026-01-12T15:10:56.709Z
9155221 9155221 20260104054501_pOiIx UK00B5 2026-01-06T14:36:59.600Z 2026-01-12T15:10:54.195Z
9155071 9155071 20260104053432_ZTUc1 UK00B5 2026-01-06T14:36:45.915Z 2026-01-12T15:10:48.008Z
9155051 9155051 20260104053246_3hi9P UK00B5 2026-01-06T14:36:43.234Z 2026-01-12T15:10:47.140Z
9155006 9155006 20260104052859_MrPU9 UK00B5 2026-01-06T14:36:29.811Z 2026-01-12T15:10:39.531Z
9154981 9154981 20260104052826_3X2G9 UK00B5 2026-01-06T14:36:27.397Z 2026-01-12T15:10:28.776Z
9154969 9154969 20260104052648_SIShe UK00B5 2026-01-06T14:36:26.180Z 2026-01-12T15:10:28.063Z
9154890 9154890 20260104052201_SVF2g UK00B5 2026-01-06T14:36:20.344Z 2026-01-12T15:10:25.522Z
9154824 9154824 20260104051619_OONVH UK00B5 2026-01-06T14:36:13.983Z 2026-01-12T15:10:20.931Z
9154658 9154658 20260104050639_ogEEQ UK00B5 2026-01-06T14:35:50.061Z 2026-01-12T15:10:13.806Z
9154488 9154488 20260104045932_GGUBN UK00B5 2026-01-06T14:35:37.343Z 2026-01-12T15:10:03.952Z
9154449 9154449 20260104045725_EOB6e UK00B5 2026-01-06T14:35:35.289Z 2026-01-12T15:09:58.987Z

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