participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,340 rows where station_code = "SK0005" 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 |
|---|---|---|---|---|---|
| 9610794 | 9610794 | 20260404215458_v7qZi | SK0005 | 2026-04-06T12:11:23.929Z | 2026-04-06T12:16:14.662Z |
| 9608252 | 9608252 | 20260403212328_AjK3U | SK0005 | 2026-04-05T12:09:49.734Z | 2026-04-06T12:20:01.879Z |
| 9608096 | 9608096 | 20260403191504_SpmE2 | SK0005 | 2026-04-05T12:08:27.173Z | 2026-04-06T12:19:36.749Z |
| 9580051 | 9580051 | 20260324235331_zOuOe | SK0005 | 2026-03-26T12:14:56.138Z | 2026-04-02T12:37:40.019Z |
| 9579889 | 9579889 | 20260324231227_x9S0D | SK0005 | 2026-03-26T12:14:37.859Z | 2026-04-02T12:37:33.741Z |
| 9579869 | 9579869 | 20260324231143_pKxqD | SK0005 | 2026-03-26T12:14:36.575Z | 2026-04-02T12:37:33.305Z |
| 9579585 | 9579585 | 20260324214503_4w3Ve | SK0005 | 2026-03-26T12:14:01.990Z | 2026-04-02T12:37:16.875Z |
| 9576148 | 9576148 | 20260325012624_O2IQc | SK0005 | 2026-03-26T12:01:26.442Z | 2026-04-03T12:35:46.326Z |
| 9571530 | 9571530 | 20260324024515_D0IFx | SK0005 | 2026-03-25T12:01:48.683Z | 2026-04-02T12:34:30.602Z |
| 9570742 | 9570742 | 20260322223646_zt2FO | SK0005 | 2026-03-24T12:23:41.953Z | 2026-03-30T12:30:48.522Z |
| 9570084 | 9570084 | 20260322190816_R9mkE | SK0005 | 2026-03-24T12:22:33.561Z | 2026-03-30T12:30:27.507Z |
| 9541768 | 9541768 | 20260319213827_tGbfD | SK0005 | 2026-03-21T12:29:20.431Z | 2026-03-27T12:42:41.404Z |
| 9541574 | 9541574 | 20260319210514_XOPu8 | SK0005 | 2026-03-21T12:29:11.281Z | 2026-03-27T12:42:38.901Z |
| 9533971 | 9533971 | 20260320031158_T5Vi2 | SK0005 | 2026-03-21T12:06:47.110Z | 2026-03-28T12:34:02.902Z |
| 9531276 | 9531276 | 20260318225058_O3es3 | SK0005 | 2026-03-20T12:25:03.825Z | 2026-03-26T12:39:18.489Z |
| 9530287 | 9530287 | 20260318203422_8YAqA | SK0005 | 2026-03-20T12:24:16.403Z | 2026-03-26T12:39:10.981Z |
| 9520880 | 9520880 | 20260319034318_FBShu | SK0005 | 2026-03-20T12:07:10.739Z | 2026-03-27T12:40:48.537Z |
| 9520176 | 9520176 | 20260319025949_QwUBu | SK0005 | 2026-03-20T12:05:53.528Z | 2026-03-27T12:40:40.084Z |
| 9519587 | 9519587 | 20260319021910_sUdxZ | SK0005 | 2026-03-20T12:04:40.953Z | 2026-03-27T12:40:32.734Z |
| 9519464 | 9519464 | 20260319021103_ysdZs | SK0005 | 2026-03-20T12:04:30.708Z | 2026-03-27T12:40:31.440Z |
| 9518891 | 9518891 | 20260319013156_evKtH | SK0005 | 2026-03-20T12:03:33.183Z | 2026-03-27T12:40:16.140Z |
| 9518783 | 9518783 | 20260319012452_3FnM3 | SK0005 | 2026-03-20T12:03:19.910Z | 2026-03-27T12:40:13.764Z |
| 9501345 | 9501345 | 20260315220154_3IGbc | SK0005 | 2026-03-17T12:24:51.314Z | 2026-03-23T12:22:44.018Z |
| 9500921 | 9500921 | 20260315200313_GWM3J | SK0005 | 2026-03-17T12:24:10.543Z | 2026-03-23T12:22:42.295Z |
| 9492024 | 9492024 | 20260314182555_zeuoc | SK0005 | 2026-03-16T12:27:52.379Z | 2026-03-22T12:42:49.169Z |
| 9483114 | 9483114 | 20260313204820_wMgxD | SK0005 | 2026-03-15T12:25:53.945Z | 2026-03-21T12:50:20.717Z |
| 9476582 | 9476582 | 20260314031720_UmWzB | SK0005 | 2026-03-15T12:06:23.712Z | 2026-03-22T12:41:57.948Z |
| 9476558 | 9476558 | 20260314031523_W7B0h | SK0005 | 2026-03-15T12:06:18.240Z | 2026-03-22T12:41:57.674Z |
| 9476371 | 9476371 | 20260314025945_5gMPg | SK0005 | 2026-03-15T12:05:46.180Z | 2026-03-22T12:41:56.287Z |
| 9476272 | 9476272 | 20260314025046_seem9 | SK0005 | 2026-03-15T12:05:28.103Z | 2026-03-22T12:41:55.474Z |
| 9475558 | 9475558 | 20260314014032_h3Jzq | SK0005 | 2026-03-15T12:03:27.133Z | 2026-03-22T12:41:42.785Z |
| 9475493 | 9475493 | 20260314013203_2kGV1 | SK0005 | 2026-03-15T12:03:16.288Z | 2026-03-22T12:41:40.499Z |
| 9475476 | 9475476 | 20260314013117_T1GtN | SK0005 | 2026-03-15T12:03:14.268Z | 2026-03-22T12:41:39.690Z |
| 9475421 | 9475421 | 20260314012642_s2WEz | SK0005 | 2026-03-15T12:03:07.486Z | 2026-03-22T12:41:38.245Z |
| 9474228 | 9474228 | 20260312214251_kKRYZ | SK0005 | 2026-03-14T12:22:20.583Z | 2026-03-20T12:37:16.839Z |
| 9474182 | 9474182 | 20260312212254_0Haf4 | SK0005 | 2026-03-14T12:22:16.177Z | 2026-03-20T12:37:16.587Z |
| 9474153 | 9474153 | 20260312210852_fHd5q | SK0005 | 2026-03-14T12:22:12.057Z | 2026-03-20T12:37:16.395Z |
| 9474106 | 9474106 | 20260312204421_2ZckS | SK0005 | 2026-03-14T12:22:00.736Z | 2026-03-20T12:37:15.981Z |
| 9469918 | 9469918 | 20260313040322_QznAO | SK0005 | 2026-03-14T12:05:57.665Z | 2026-03-21T12:49:04.218Z |
| 9469720 | 9469720 | 20260313033302_EIlXx | SK0005 | 2026-03-14T12:05:18.093Z | 2026-03-21T12:49:01.327Z |
| 9469345 | 9469345 | 20260313023129_CruRz | SK0005 | 2026-03-14T12:03:56.267Z | 2026-03-21T12:48:37.805Z |
| 9468899 | 9468899 | 20260313010948_M2Jpv | SK0005 | 2026-03-14T12:02:12.992Z | 2026-03-21T12:48:31.053Z |
| 9467658 | 9467658 | 20260311222941_MGQSh | SK0005 | 2026-03-13T12:19:39.485Z | 2026-03-19T12:45:54.068Z |
| 9467213 | 9467213 | 20260311205136_8tGL8 | SK0005 | 2026-03-13T12:18:45.104Z | 2026-03-19T12:45:50.443Z |
| 9467130 | 9467130 | 20260311201510_a0Ika | SK0005 | 2026-03-13T12:18:27.428Z | 2026-03-19T12:45:48.607Z |
| 9464186 | 9464186 | 20260312035225_CBbqC | SK0005 | 2026-03-13T12:06:32.877Z | 2026-03-20T12:36:32.350Z |
| 9464105 | 9464105 | 20260312033351_JFwcE | SK0005 | 2026-03-13T12:06:16.483Z | 2026-03-20T12:36:30.344Z |
| 9463806 | 9463806 | 20260312024603_Hu5dO | SK0005 | 2026-03-13T12:05:17.443Z | 2026-03-20T12:36:24.966Z |
| 9463688 | 9463688 | 20260312022738_glWsq | SK0005 | 2026-03-13T12:04:52.539Z | 2026-03-20T12:36:24.046Z |
| 9463664 | 9463664 | 20260312022327_VgJkp | SK0005 | 2026-03-13T12:04:50.013Z | 2026-03-20T12:36:23.860Z |
| 9463390 | 9463390 | 20260312014301_0v24n | SK0005 | 2026-03-13T12:04:00.230Z | 2026-03-20T12:36:22.240Z |
| 9463360 | 9463360 | 20260312013829_uhI8T | SK0005 | 2026-03-13T12:03:55.982Z | 2026-03-20T12:36:22.104Z |
| 9463330 | 9463330 | 20260312013228_H6UqV | SK0005 | 2026-03-13T12:03:51.744Z | 2026-03-20T12:36:21.946Z |
| 9463285 | 9463285 | 20260312012519_D4DFu | SK0005 | 2026-03-13T12:03:43.696Z | 2026-03-20T12:36:21.665Z |
| 9463226 | 9463226 | 20260312011830_s0ULe | SK0005 | 2026-03-13T12:03:31.761Z | 2026-03-20T12:36:21.370Z |
| 9462828 | 9462828 | 20260312001948_uCAUW | SK0005 | 2026-03-13T12:02:15.468Z | 2026-03-20T12:36:18.270Z |
| 9460764 | 9460764 | 20260310221424_Uef6n | SK0005 | 2026-03-12T12:15:04.390Z | 2026-03-18T12:40:19.109Z |
| 9457488 | 9457488 | 20260311040227_PSpD2 | SK0005 | 2026-03-12T12:03:54.724Z | 2026-03-19T12:44:44.915Z |
| 9457485 | 9457485 | 20260311040212_OLJUB | SK0005 | 2026-03-12T12:03:54.417Z | 2026-03-19T12:44:44.867Z |
| 9457041 | 9457041 | 20260311021928_DIyOQ | SK0005 | 2026-03-12T12:02:39.835Z | 2026-03-19T12:44:25.069Z |
| 9457023 | 9457023 | 20260311021445_qAbK8 | SK0005 | 2026-03-12T12:02:36.438Z | 2026-03-19T12:44:24.834Z |
| 9456788 | 9456788 | 20260311010048_vqiUu | SK0005 | 2026-03-12T12:01:48.153Z | 2026-03-19T12:44:21.986Z |
| 9456429 | 9456429 | 20260310231940_Lc2pj | SK0005 | 2026-03-12T12:00:39.490Z | 2026-03-19T12:44:17.022Z |
| 9450878 | 9450878 | 20260309234119_eGNM9 | SK0005 | 2026-03-11T12:01:00.996Z | 2026-03-18T12:38:37.301Z |
| 9450842 | 9450842 | 20260309232930_SscxC | SK0005 | 2026-03-11T12:00:52.677Z | 2026-03-18T12:38:36.668Z |
| 9450416 | 9450416 | 20260308212140_Gxbhn | SK0005 | 2026-03-10T12:19:36.517Z | 2026-03-16T12:44:42.210Z |
| 9447036 | 9447036 | 20260309041122_SfmX9 | SK0005 | 2026-03-10T12:04:57.239Z | 2026-03-17T12:41:46.704Z |
| 9446976 | 9446976 | 20260309035425_Zc53I | SK0005 | 2026-03-10T12:04:41.882Z | 2026-03-17T12:41:45.754Z |
| 9446942 | 9446942 | 20260309033723_t9K24 | SK0005 | 2026-03-10T12:04:31.803Z | 2026-03-17T12:41:45.069Z |
| 9446723 | 9446723 | 20260309024421_MiuF2 | SK0005 | 2026-03-10T12:03:35.032Z | 2026-03-17T12:41:41.735Z |
| 9446623 | 9446623 | 20260309022337_84DnO | SK0005 | 2026-03-10T12:03:10.501Z | 2026-03-17T12:41:40.357Z |
| 9446185 | 9446185 | 20260309002049_bxAyX | SK0005 | 2026-03-10T12:01:22.818Z | 2026-03-17T12:41:34.431Z |
| 9445872 | 9445872 | 20260307222041_eBc6h | SK0005 | 2026-03-09T12:21:04.058Z | 2026-03-15T12:42:15.141Z |
| 9445646 | 9445646 | 20260307205609_nMWrA | SK0005 | 2026-03-09T12:20:12.185Z | 2026-03-15T12:42:12.532Z |
| 9445615 | 9445615 | 20260307205036_KFCdh | SK0005 | 2026-03-09T12:20:03.734Z | 2026-03-15T12:42:12.027Z |
| 9445589 | 9445589 | 20260307204447_yJFpV | SK0005 | 2026-03-09T12:19:57.433Z | 2026-03-15T12:42:11.635Z |
| 9445362 | 9445362 | 20260307184100_fHL5j | SK0005 | 2026-03-09T12:18:40.476Z | 2026-03-15T12:42:06.850Z |
| 9442326 | 9442326 | 20260308030214_FyCjE | SK0005 | 2026-03-09T12:03:31.566Z | 2026-03-16T12:43:49.725Z |
| 9442046 | 9442046 | 20260308010637_E73tX | SK0005 | 2026-03-09T12:02:22.980Z | 2026-03-16T12:43:35.957Z |
| 9441701 | 9441701 | 20260307231406_5s1Pf | SK0005 | 2026-03-09T12:00:47.585Z | 2026-03-16T12:43:29.616Z |
| 9441639 | 9441639 | 20260307230245_0KVVU | SK0005 | 2026-03-09T12:00:32.140Z | 2026-03-16T12:43:28.836Z |
| 9441094 | 9441094 | 20260306194655_G1AAs | SK0005 | 2026-03-08T12:20:22.777Z | 2026-03-14T12:40:43.787Z |
| 9440997 | 9440997 | 20260306185254_nAz25 | SK0005 | 2026-03-08T12:20:04.807Z | 2026-03-14T12:40:41.374Z |
| 9436734 | 9436734 | 20260306233707_pbFl9 | SK0005 | 2026-03-08T12:01:02.212Z | 2026-03-15T12:40:57.075Z |
| 9436717 | 9436717 | 20260306233220_U2U6f | SK0005 | 2026-03-08T12:00:57.804Z | 2026-03-15T12:40:56.939Z |
| 9436668 | 9436668 | 20260306231654_SzLiz | SK0005 | 2026-03-08T12:00:42.640Z | 2026-03-15T12:40:56.141Z |
| 9436467 | 9436467 | 20260305221948_GpYS1 | SK0005 | 2026-03-07T14:26:03.539Z | 2026-03-13T12:36:00.267Z |
| 9436456 | 9436456 | 20260305221519_ZiSlo | SK0005 | 2026-03-07T14:26:01.405Z | 2026-03-13T12:36:00.072Z |
| 9436443 | 9436443 | 20260305220905_03tDV | SK0005 | 2026-03-07T14:25:56.533Z | 2026-03-13T12:35:59.947Z |
| 9436420 | 9436420 | 20260305213445_b2hVG | SK0005 | 2026-03-07T14:25:49.737Z | 2026-03-13T12:35:59.613Z |
| 9436141 | 9436141 | 20260305192213_NghoB | SK0005 | 2026-03-07T14:24:38.767Z | 2026-03-13T12:35:41.183Z |
| 9436084 | 9436084 | 20260305190453_cElgj | SK0005 | 2026-03-07T14:24:25.369Z | 2026-03-13T12:35:40.525Z |
| 9436050 | 9436050 | 20260305184855_IH8WR | SK0005 | 2026-03-07T14:24:16.422Z | 2026-03-13T12:35:40.035Z |
| 9431467 | 9431467 | 20260305234806_XJr2J | SK0005 | 2026-03-07T14:00:46.142Z | 2026-03-14T12:39:13.118Z |
| 9431449 | 9431449 | 20260305234223_pCxBH | SK0005 | 2026-03-07T14:00:41.062Z | 2026-03-14T12:39:12.937Z |
| 9415134 | 9415134 | 20260228201721_tFbeW | SK0005 | 2026-03-02T14:07:26.935Z | 2026-03-08T12:43:02.911Z |
| 9415067 | 9415067 | 20260228194708_1Hexv | SK0005 | 2026-03-02T14:07:16.383Z | 2026-03-08T12:43:00.095Z |
| 9412558 | 9412558 | 20260301041010_3ueB3 | SK0005 | 2026-03-02T14:01:39.473Z | 2026-03-09T12:39:43.046Z |
| 9412537 | 9412537 | 20260301040504_nlnNm | SK0005 | 2026-03-02T14:01:36.478Z | 2026-03-09T12:39:42.243Z |
| 9409710 | 9409710 | 20260228042621_5R6yV | SK0005 | 2026-03-01T14:02:04.727Z | 2026-03-08T12:41:28.376Z |
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);