participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,166 rows where station_code = "UK00DJ" sorted by created_at descending
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 |
|---|---|---|---|---|---|
| 9611801 | 9611801 | 20260405032728_a0Fuj | UK00DJ | 2026-04-06T12:16:02.160Z | 2026-04-06T12:16:14.865Z |
| 9611533 | 9611533 | 20260405023245_RDU6P | UK00DJ | 2026-04-06T12:15:00.521Z | 2026-04-06T12:16:14.817Z |
| 9611497 | 9611497 | 20260405021945_Zd9C8 | UK00DJ | 2026-04-06T12:14:49.341Z | 2026-04-06T12:16:14.811Z |
| 9611350 | 9611350 | 20260405013056_y8Lu7 | UK00DJ | 2026-04-06T12:14:04.054Z | 2026-04-06T12:16:14.782Z |
| 9611332 | 9611332 | 20260405012826_dBCbU | UK00DJ | 2026-04-06T12:14:02.162Z | 2026-04-06T12:16:14.780Z |
| 9611330 | 9611330 | 20260405012738_dw303 | UK00DJ | 2026-04-06T12:14:01.825Z | 2026-04-06T12:16:14.779Z |
| 9610966 | 9610966 | 20260404230700_Dnx3c | UK00DJ | 2026-04-06T12:12:22.589Z | 2026-04-06T12:16:14.701Z |
| 9610850 | 9610850 | 20260404222342_3fGFH | UK00DJ | 2026-04-06T12:11:37.001Z | 2026-04-06T12:16:14.675Z |
| 9609277 | 9609277 | 20260405040957_rJSM8 | UK00DJ | 2026-04-06T12:00:51.734Z | 2026-04-06T12:00:51.734Z |
| 9609211 | 9609211 | 20260405035933_L1KrQ | UK00DJ | 2026-04-06T12:00:43.470Z | 2026-04-06T12:00:43.470Z |
| 9609132 | 9609132 | 20260405034238_hHVKf | UK00DJ | 2026-04-06T12:00:23.541Z | 2026-04-06T12:00:23.541Z |
| 9609101 | 9609101 | 20260405033346_sQXrr | UK00DJ | 2026-04-06T12:00:14.627Z | 2026-04-06T12:00:14.627Z |
| 9608924 | 9608924 | 20260404023957_UJUll | UK00DJ | 2026-04-05T12:12:18.409Z | 2026-04-06T12:20:51.192Z |
| 9608783 | 9608783 | 20260404012433_cVLeB | UK00DJ | 2026-04-05T12:11:40.051Z | 2026-04-06T12:20:36.615Z |
| 9608562 | 9608562 | 20260403234031_LYSuz | UK00DJ | 2026-04-05T12:10:49.393Z | 2026-04-06T12:20:20.706Z |
| 9608467 | 9608467 | 20260403231210_EMbP6 | UK00DJ | 2026-04-05T12:10:29.652Z | 2026-04-06T12:20:14.276Z |
| 9608344 | 9608344 | 20260403220830_Xt6EJ | UK00DJ | 2026-04-05T12:10:08.354Z | 2026-04-06T12:20:06.876Z |
| 9608324 | 9608324 | 20260403214956_raCaa | UK00DJ | 2026-04-05T12:10:01.085Z | 2026-04-06T12:20:05.682Z |
| 9608279 | 9608279 | 20260403212957_rgtKo | UK00DJ | 2026-04-05T12:09:53.736Z | 2026-04-06T12:20:03.369Z |
| 9608207 | 9608207 | 20260403205438_xzqBw | UK00DJ | 2026-04-05T12:09:33.523Z | 2026-04-06T12:19:56.007Z |
| 9608117 | 9608117 | 20260403200033_gm1nF | UK00DJ | 2026-04-05T12:08:50.415Z | 2026-04-06T12:19:42.641Z |
| 9607170 | 9607170 | 20260404041228_H8u28 | UK00DJ | 2026-04-05T12:00:40.981Z | 2026-04-06T12:16:14.377Z |
| 9604943 | 9604943 | 20260402020940_nk3hp | UK00DJ | 2026-04-03T12:12:22.345Z | 2026-04-06T12:26:33.762Z |
| 9600429 | 9600429 | 20260330214935_5U0Hc | UK00DJ | 2026-04-01T12:10:44.674Z | 2026-04-06T12:33:25.256Z |
| 9595106 | 9595106 | 20260330022324_s3yjB | UK00DJ | 2026-03-31T12:00:29.662Z | 2026-04-06T12:29:40.746Z |
| 9595064 | 9595064 | 20260330021223_apR2X | UK00DJ | 2026-03-31T12:00:22.120Z | 2026-04-06T12:29:38.651Z |
| 9594936 | 9594936 | 20260329010620_UNRUE | UK00DJ | 2026-03-30T12:10:39.459Z | 2026-04-06T12:40:21.044Z |
| 9594877 | 9594877 | 20260329005422_cT1Ex | UK00DJ | 2026-03-30T12:10:30.936Z | 2026-04-06T12:40:19.342Z |
| 9594788 | 9594788 | 20260329003211_t9QnO | UK00DJ | 2026-03-30T12:10:19.639Z | 2026-04-06T12:40:16.067Z |
| 9594748 | 9594748 | 20260329001946_zm7Ht | UK00DJ | 2026-03-30T12:10:15.904Z | 2026-04-06T12:40:14.755Z |
| 9594542 | 9594542 | 20260328225605_tnYmu | UK00DJ | 2026-03-30T12:09:47.722Z | 2026-04-06T12:39:56.552Z |
| 9594452 | 9594452 | 20260328222513_bTYen | UK00DJ | 2026-03-30T12:09:34.741Z | 2026-04-06T12:39:52.709Z |
| 9594415 | 9594415 | 20260328221711_73How | UK00DJ | 2026-03-30T12:09:31.760Z | 2026-04-06T12:39:51.701Z |
| 9594331 | 9594331 | 20260328212912_Z6bqS | UK00DJ | 2026-03-30T12:09:18.582Z | 2026-04-06T12:39:48.021Z |
| 9594269 | 9594269 | 20260328205018_V9wpp | UK00DJ | 2026-03-30T12:09:09.944Z | 2026-04-06T12:39:45.548Z |
| 9594204 | 9594204 | 20260328200750_92LcM | UK00DJ | 2026-03-30T12:08:58.498Z | 2026-04-06T12:39:42.736Z |
| 9593005 | 9593005 | 20260329041500_sJCgG | UK00DJ | 2026-03-30T12:02:35.354Z | 2026-04-06T12:34:44.905Z |
| 9593003 | 9593003 | 20260329041500_1Dsiy | UK00DJ | 2026-03-30T12:02:34.954Z | 2026-04-06T12:34:44.753Z |
| 9592728 | 9592728 | 20260329030954_fr8QR | UK00DJ | 2026-03-30T12:01:46.314Z | 2026-04-06T12:34:25.199Z |
| 9592468 | 9592468 | 20260329021257_XI8SE | UK00DJ | 2026-03-30T12:01:02.514Z | 2026-04-06T12:34:11.344Z |
| 9592127 | 9592127 | 20260328005057_d6sQz | UK00DJ | 2026-03-29T12:07:12.434Z | 2026-04-05T12:35:38.180Z |
| 9592113 | 9592113 | 20260328003742_QnuKr | UK00DJ | 2026-03-29T12:07:11.028Z | 2026-04-05T12:35:37.169Z |
| 9592034 | 9592034 | 20260328000032_ZB01h | UK00DJ | 2026-03-29T12:07:07.074Z | 2026-04-05T12:35:24.762Z |
| 9591962 | 9591962 | 20260327232258_B8gHJ | UK00DJ | 2026-03-29T12:07:02.362Z | 2026-04-05T12:35:22.529Z |
| 9591941 | 9591941 | 20260327231700_YQPAv | UK00DJ | 2026-03-29T12:07:00.133Z | 2026-04-05T12:35:21.496Z |
| 9591919 | 9591919 | 20260327230400_q4ARq | UK00DJ | 2026-03-29T12:06:58.313Z | 2026-04-05T12:35:19.463Z |
| 9591899 | 9591899 | 20260327230010_qi34L | UK00DJ | 2026-03-29T12:06:54.429Z | 2026-04-05T12:35:18.932Z |
| 9591885 | 9591885 | 20260327225525_T3ii4 | UK00DJ | 2026-03-29T12:06:53.799Z | 2026-04-05T12:35:18.489Z |
| 9591846 | 9591846 | 20260327223230_JAu2Q | UK00DJ | 2026-03-29T12:06:50.911Z | 2026-04-05T12:35:16.624Z |
| 9591835 | 9591835 | 20260327222518_dBdZX | UK00DJ | 2026-03-29T12:06:50.263Z | 2026-04-05T12:35:16.259Z |
| 9591819 | 9591819 | 20260327221449_KsJaQ | UK00DJ | 2026-03-29T12:06:48.099Z | 2026-04-05T12:35:15.306Z |
| 9591817 | 9591817 | 20260327221227_QP2wX | UK00DJ | 2026-03-29T12:06:47.871Z | 2026-04-05T12:35:15.153Z |
| 9591815 | 9591815 | 20260327215957_UWPOY | UK00DJ | 2026-03-29T12:06:47.709Z | 2026-04-05T12:35:15.009Z |
| 9591804 | 9591804 | 20260327214649_nBCW7 | UK00DJ | 2026-03-29T12:06:46.516Z | 2026-04-05T12:35:14.456Z |
| 9589734 | 9589734 | 20260328040443_BfYR4 | UK00DJ | 2026-03-29T12:01:36.202Z | 2026-04-06T12:37:32.485Z |
| 9589630 | 9589630 | 20260328035226_xEXF5 | UK00DJ | 2026-03-29T12:01:30.165Z | 2026-04-06T12:37:29.371Z |
| 9589225 | 9589225 | 20260328025549_Q4vjD | UK00DJ | 2026-03-29T12:00:55.657Z | 2026-04-06T12:37:08.448Z |
| 9589189 | 9589189 | 20260328024238_j225W | UK00DJ | 2026-03-29T12:00:49.838Z | 2026-04-06T12:37:04.627Z |
| 9589175 | 9589175 | 20260328023959_lgWkm | UK00DJ | 2026-03-29T12:00:48.961Z | 2026-04-06T12:37:04.145Z |
| 9589040 | 9589040 | 20260328021716_FCK6v | UK00DJ | 2026-03-29T12:00:39.998Z | 2026-04-06T12:37:00.307Z |
| 9588923 | 9588923 | 20260328015442_nZ7mr | UK00DJ | 2026-03-29T12:00:29.822Z | 2026-04-06T12:36:56.507Z |
| 9588920 | 9588920 | 20260328015413_yyrKB | UK00DJ | 2026-03-29T12:00:29.350Z | 2026-04-06T12:36:56.312Z |
| 9588909 | 9588909 | 20260328015404_mhwyo | UK00DJ | 2026-03-29T12:00:28.481Z | 2026-04-06T12:36:56.099Z |
| 9588760 | 9588760 | 20260328010736_9p96y | UK00DJ | 2026-03-29T12:00:11.365Z | 2026-04-06T12:36:50.168Z |
| 9585296 | 9585296 | 20260326000823_fsed8 | UK00DJ | 2026-03-27T12:17:04.985Z | 2026-04-03T12:39:54.147Z |
| 9585060 | 9585060 | 20260325231816_SGErW | UK00DJ | 2026-03-27T12:16:37.693Z | 2026-04-03T12:39:48.194Z |
| 9585030 | 9585030 | 20260325230656_Ha3wx | UK00DJ | 2026-03-27T12:16:33.034Z | 2026-04-03T12:39:46.844Z |
| 9584858 | 9584858 | 20260325222740_XY5oG | UK00DJ | 2026-03-27T12:16:16.385Z | 2026-04-03T12:39:42.498Z |
| 9584840 | 9584840 | 20260325222710_BiNZi | UK00DJ | 2026-03-27T12:16:12.499Z | 2026-04-03T12:39:42.144Z |
| 9584787 | 9584787 | 20260325220638_hPweE | UK00DJ | 2026-03-27T12:16:06.816Z | 2026-04-03T12:39:40.985Z |
| 9584464 | 9584464 | 20260325195920_uiBeJ | UK00DJ | 2026-03-27T12:15:23.010Z | 2026-04-03T12:39:15.200Z |
| 9582161 | 9582161 | 20260326044244_kSlFq | UK00DJ | 2026-03-27T12:04:44.617Z | 2026-04-04T12:39:39.069Z |
| 9581922 | 9581922 | 20260326041151_AbPBX | UK00DJ | 2026-03-27T12:04:09.198Z | 2026-04-04T12:39:31.346Z |
| 9581592 | 9581592 | 20260326033246_5tDNt | UK00DJ | 2026-03-27T12:03:26.862Z | 2026-04-04T12:39:11.295Z |
| 9581504 | 9581504 | 20260326032000_wPrfj | UK00DJ | 2026-03-27T12:03:18.101Z | 2026-04-04T12:39:08.916Z |
| 9581388 | 9581388 | 20260326030327_kSU7g | UK00DJ | 2026-03-27T12:02:56.770Z | 2026-04-04T12:38:55.500Z |
| 9581382 | 9581382 | 20260326030234_WEh23 | UK00DJ | 2026-03-27T12:02:55.513Z | 2026-04-04T12:38:55.187Z |
| 9581324 | 9581324 | 20260326025331_9qpnc | UK00DJ | 2026-03-27T12:02:43.196Z | 2026-04-04T12:38:52.620Z |
| 9581284 | 9581284 | 20260326024618_UmUBn | UK00DJ | 2026-03-27T12:02:37.979Z | 2026-04-04T12:38:51.558Z |
| 9581196 | 9581196 | 20260326023416_zUB2z | UK00DJ | 2026-03-27T12:02:20.569Z | 2026-04-04T12:38:45.264Z |
| 9580892 | 9580892 | 20260326015029_RCJkZ | UK00DJ | 2026-03-27T12:01:38.573Z | 2026-04-04T12:38:32.731Z |
| 9580627 | 9580627 | 20260326011015_l9hHW | UK00DJ | 2026-03-27T12:00:58.935Z | 2026-04-04T12:38:18.662Z |
| 9580338 | 9580338 | 20260326003148_3cKHm | UK00DJ | 2026-03-27T12:00:12.429Z | 2026-04-04T12:38:06.438Z |
| 9570210 | 9570210 | 20260322195108_ku7r4 | UK00DJ | 2026-03-24T12:22:48.705Z | 2026-03-30T12:30:34.512Z |
| 9561176 | 9561176 | 20260321230618_15BJJ | UK00DJ | 2026-03-23T12:12:12.939Z | 2026-03-29T12:21:05.491Z |
| 9560684 | 9560684 | 20260321220124_066y3 | UK00DJ | 2026-03-23T12:12:01.016Z | 2026-03-29T12:21:02.138Z |
| 9560520 | 9560520 | 20260321213440_2aQRG | UK00DJ | 2026-03-23T12:11:50.243Z | 2026-03-29T12:21:00.935Z |
| 9560514 | 9560514 | 20260321213419_W3OBH | UK00DJ | 2026-03-23T12:11:50.123Z | 2026-03-29T12:21:00.897Z |
| 9560500 | 9560500 | 20260321213230_n7SJd | UK00DJ | 2026-03-23T12:11:49.218Z | 2026-03-29T12:21:00.789Z |
| 9560307 | 9560307 | 20260321210007_LcNga | UK00DJ | 2026-03-23T12:11:41.889Z | 2026-03-29T12:20:59.152Z |
| 9560194 | 9560194 | 20260321204556_Ng6di | UK00DJ | 2026-03-23T12:11:40.039Z | 2026-03-29T12:20:58.473Z |
| 9559727 | 9559727 | 20260321193404_ivPyn | UK00DJ | 2026-03-23T12:11:28.127Z | 2026-03-29T12:20:47.166Z |
| 9555125 | 9555125 | 20260322040629_QX4xy | UK00DJ | 2026-03-23T12:03:11.009Z | 2026-03-30T12:28:14.730Z |
| 9555064 | 9555064 | 20260322040141_eBwtf | UK00DJ | 2026-03-23T12:03:08.303Z | 2026-03-30T12:28:13.914Z |
| 9554867 | 9554867 | 20260322033956_YfreP | UK00DJ | 2026-03-23T12:02:53.726Z | 2026-03-30T12:28:10.569Z |
| 9554696 | 9554696 | 20260322032630_0ulIE | UK00DJ | 2026-03-23T12:02:46.482Z | 2026-03-30T12:28:07.315Z |
| 9554206 | 9554206 | 20260322024921_1P3Z5 | UK00DJ | 2026-03-23T12:02:20.041Z | 2026-03-30T12:28:00.358Z |
| 9554057 | 9554057 | 20260322023455_3R8JN | UK00DJ | 2026-03-23T12:02:11.364Z | 2026-03-30T12:27:57.513Z |
| 9553927 | 9553927 | 20260322022449_K6i2w | UK00DJ | 2026-03-23T12:02:00.305Z | 2026-03-30T12:27:55.206Z |
| 9553902 | 9553902 | 20260322022403_bt36V | UK00DJ | 2026-03-23T12:01:58.948Z | 2026-03-30T12:27:54.629Z |
Advanced export
JSON shape: default, array, newline-delimited
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);