participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
721 rows where station_code = "DK0008" 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 |
---|---|---|---|---|---|
5591855 | 5591855 | 20241123011147_GASOp | DK0008 | 2024-11-24T14:20:21.098Z | 2024-11-26T14:23:31.722Z |
5591655 | 5591655 | 20241123002136_2Nilf | DK0008 | 2024-11-24T14:20:08.230Z | 2024-11-26T14:23:27.617Z |
5583873 | 5583873 | 20241118221017_dZdz1 | DK0008 | 2024-11-23T14:25:06.692Z | 2024-11-26T14:28:14.711Z |
5577907 | 5577907 | 20241121181235_ds26R | DK0008 | 2024-11-23T14:16:14.230Z | 2024-11-26T14:24:42.114Z |
5577852 | 5577852 | 20241121180450_qxFbb | DK0008 | 2024-11-23T14:16:10.754Z | 2024-11-26T14:24:41.252Z |
5577501 | 5577501 | 20241121163318_gOPyq | DK0008 | 2024-11-23T14:15:20.388Z | 2024-11-26T14:24:35.605Z |
5573336 | 5573336 | 20241122041016_4AXMq | DK0008 | 2024-11-23T14:00:19.075Z | 2024-11-26T14:22:01.093Z |
5556673 | 5556673 | 20241119005959_SKvqN | DK0008 | 2024-11-20T14:11:11.786Z | 2024-11-26T14:28:15.616Z |
5556650 | 5556650 | 20241119004447_pQDAC | DK0008 | 2024-11-20T14:11:03.896Z | 2024-11-26T14:28:15.466Z |
5556614 | 5556614 | 20241119001032_odUQ0 | DK0008 | 2024-11-20T14:10:53.124Z | 2024-11-26T14:28:15.212Z |
5556501 | 5556501 | 20241118223834_Agm4p | DK0008 | 2024-11-20T14:10:37.880Z | 2024-11-26T14:28:14.777Z |
5466917 | 5466917 | 20241102192303_Sp7V1 | DK0008 | 2024-11-04T14:10:17.977Z | 2024-11-11T14:22:44.302Z |
5466239 | 5466239 | 20241102165601_agHy9 | DK0008 | 2024-11-04T14:08:24.553Z | 2024-11-11T14:22:40.008Z |
5463483 | 5463483 | 20241102034515_UvvCV | DK0008 | 2024-11-03T14:18:49.908Z | 2024-11-10T14:26:35.375Z |
5463479 | 5463479 | 20241102034416_RCuUO | DK0008 | 2024-11-03T14:18:49.759Z | 2024-11-10T14:26:35.365Z |
5463439 | 5463439 | 20241102033908_1wBhn | DK0008 | 2024-11-03T14:18:45.809Z | 2024-11-10T14:26:35.288Z |
5461951 | 5461951 | 20241101222151_CAaLI | DK0008 | 2024-11-03T14:16:48.803Z | 2024-11-10T14:26:31.080Z |
5454070 | 5454070 | 20241031033908_ntckW | DK0008 | 2024-11-02T12:22:50.047Z | 2024-11-08T14:23:20.291Z |
5453796 | 5453796 | 20241031030131_FNdRV | DK0008 | 2024-11-02T12:22:42.695Z | 2024-11-08T14:23:19.101Z |
5453464 | 5453464 | 20241031021431_NC2De | DK0008 | 2024-11-02T12:22:34.158Z | 2024-11-08T14:23:17.534Z |
5453426 | 5453426 | 20241031021117_Nxy8E | DK0008 | 2024-11-02T12:22:33.524Z | 2024-11-08T14:23:17.374Z |
5444158 | 5444158 | 20241031005317_QMGyJ | DK0008 | 2024-11-01T12:21:07.881Z | 2024-11-08T14:23:14.027Z |
5440638 | 5440638 | 20241030223921_zwDJg | DK0008 | 2024-11-01T12:15:41.211Z | 2024-11-08T14:23:10.141Z |
5439903 | 5439903 | 20241030204654_cqufs | DK0008 | 2024-11-01T12:14:36.882Z | 2024-11-08T14:23:06.001Z |
5418906 | 5418906 | 20241027222228_yGP3J | DK0008 | 2024-10-30T12:16:31.504Z | 2024-11-05T14:27:11.705Z |
5418833 | 5418833 | 20241027220425_wrjX6 | DK0008 | 2024-10-30T12:16:20.304Z | 2024-11-05T14:27:11.408Z |
5418723 | 5418723 | 20241027214348_eS4SJ | DK0008 | 2024-10-30T12:16:01.354Z | 2024-11-05T14:27:10.999Z |
5418044 | 5418044 | 20241027194353_BUf3T | DK0008 | 2024-10-30T12:14:49.276Z | 2024-11-05T14:27:08.924Z |
5417380 | 5417380 | 20241027182209_FiiBR | DK0008 | 2024-10-30T12:13:35.618Z | 2024-11-05T14:27:07.138Z |
5417328 | 5417328 | 20241027181552_2yOCW | DK0008 | 2024-10-30T12:13:31.661Z | 2024-11-05T14:27:06.973Z |
5417065 | 5417065 | 20241027174146_plv7E | DK0008 | 2024-10-30T12:12:51.313Z | 2024-11-05T14:27:06.326Z |
5416782 | 5416782 | 20241027165454_dzN85 | DK0008 | 2024-10-30T12:12:24.561Z | 2024-11-05T14:27:05.445Z |
5409010 | 5409010 | 20241027035428_6wSM3 | DK0008 | 2024-10-29T12:17:01.388Z | 2024-11-04T14:29:00.929Z |
5408136 | 5408136 | 20241027031137_rtoZK | DK0008 | 2024-10-29T12:16:11.385Z | 2024-11-04T14:28:58.917Z |
5407865 | 5407865 | 20241027025545_d863u | DK0008 | 2024-10-29T12:15:49.809Z | 2024-11-04T14:28:58.251Z |
5407809 | 5407809 | 20241027025320_hM1kC | DK0008 | 2024-10-29T12:15:43.786Z | 2024-11-04T14:28:58.168Z |
5407470 | 5407470 | 20241027023824_jL203 | DK0008 | 2024-10-29T12:15:25.960Z | 2024-11-04T14:28:57.639Z |
5407083 | 5407083 | 20241027022103_xhapZ | DK0008 | 2024-10-29T12:15:11.741Z | 2024-11-04T14:28:56.839Z |
5395568 | 5395568 | 20241025225436_2atNd | DK0008 | 2024-10-28T12:16:27.915Z | 2024-11-03T14:27:26.044Z |
5394763 | 5394763 | 20241025212207_ocANo | DK0008 | 2024-10-28T12:15:23.014Z | 2024-11-03T14:27:22.614Z |
5394355 | 5394355 | 20241025201942_v8hcb | DK0008 | 2024-10-28T12:14:27.849Z | 2024-11-03T14:27:21.003Z |
5387808 | 5387808 | 20241025032454_LI2GN | DK0008 | 2024-10-27T12:21:41.067Z | 2024-11-02T12:28:33.277Z |
5387714 | 5387714 | 20241025031058_S6V4A | DK0008 | 2024-10-27T12:21:37.295Z | 2024-11-02T12:28:33.156Z |
5387654 | 5387654 | 20241025030545_7jKZG | DK0008 | 2024-10-27T12:21:32.128Z | 2024-11-02T12:28:33.000Z |
5387483 | 5387483 | 20241025024433_RWEE9 | DK0008 | 2024-10-27T12:21:23.828Z | 2024-11-02T12:28:32.630Z |
5387267 | 5387267 | 20241025021752_jOVzg | DK0008 | 2024-10-27T12:21:06.474Z | 2024-11-02T12:28:32.329Z |
5387127 | 5387127 | 20241025020248_8oINY | DK0008 | 2024-10-27T12:20:55.018Z | 2024-11-02T12:28:32.137Z |
5387066 | 5387066 | 20241025015629_nHEEv | DK0008 | 2024-10-27T12:20:50.985Z | 2024-11-02T12:28:32.069Z |
5387045 | 5387045 | 20241025015525_YUBzA | DK0008 | 2024-10-27T12:20:49.670Z | 2024-11-02T12:28:32.039Z |
5386966 | 5386966 | 20241025014509_8KSlP | DK0008 | 2024-10-27T12:20:43.947Z | 2024-11-02T12:28:31.759Z |
5386913 | 5386913 | 20241025014039_SlPLH | DK0008 | 2024-10-27T12:20:39.668Z | 2024-11-02T12:28:31.694Z |
5386847 | 5386847 | 20241025013446_J9R4O | DK0008 | 2024-10-27T12:20:36.118Z | 2024-11-02T12:28:31.665Z |
5386239 | 5386239 | 20241025001704_SAUIY | DK0008 | 2024-10-27T12:19:56.162Z | 2024-11-02T12:28:30.870Z |
5386052 | 5386052 | 20241024235834_doja8 | DK0008 | 2024-10-27T12:19:47.917Z | 2024-11-02T12:28:30.643Z |
5385938 | 5385938 | 20241024234458_DyN7M | DK0008 | 2024-10-27T12:19:38.463Z | 2024-11-02T12:28:30.503Z |
5385915 | 5385915 | 20241024234323_TIK13 | DK0008 | 2024-10-27T12:19:36.478Z | 2024-11-02T12:28:30.472Z |
5385899 | 5385899 | 20241024234040_h6l9Q | DK0008 | 2024-10-27T12:19:35.369Z | 2024-11-02T12:28:30.450Z |
5385886 | 5385886 | 20241024233954_xOaUH | DK0008 | 2024-10-27T12:19:34.583Z | 2024-11-02T12:28:30.445Z |
5385778 | 5385778 | 20241024232910_jHCNp | DK0008 | 2024-10-27T12:19:22.761Z | 2024-11-02T12:28:30.165Z |
5385527 | 5385527 | 20241024225701_wwfS3 | DK0008 | 2024-10-27T12:19:03.207Z | 2024-11-02T12:28:29.897Z |
5385504 | 5385504 | 20241024225406_Z3XH2 | DK0008 | 2024-10-27T12:19:00.539Z | 2024-11-02T12:28:29.887Z |
5385448 | 5385448 | 20241024224648_TDoGw | DK0008 | 2024-10-27T12:18:56.600Z | 2024-11-02T12:28:29.838Z |
5385423 | 5385423 | 20241024224057_03APy | DK0008 | 2024-10-27T12:18:54.053Z | 2024-11-02T12:28:29.800Z |
5385206 | 5385206 | 20241024220718_0jMSD | DK0008 | 2024-10-27T12:18:34.149Z | 2024-11-02T12:28:29.276Z |
5385126 | 5385126 | 20241024215506_OL0l3 | DK0008 | 2024-10-27T12:18:26.439Z | 2024-11-02T12:28:29.163Z |
5385009 | 5385009 | 20241024213543_Hv5zh | DK0008 | 2024-10-27T12:18:11.940Z | 2024-11-02T12:28:28.918Z |
5384872 | 5384872 | 20241024211034_Ca12U | DK0008 | 2024-10-27T12:17:54.631Z | 2024-11-02T12:28:28.549Z |
5384865 | 5384865 | 20241024210708_vXHFb | DK0008 | 2024-10-27T12:17:52.960Z | 2024-11-02T12:28:28.541Z |
5365306 | 5365306 | 20241023232522_AlqNG | DK0008 | 2024-10-25T12:17:54.719Z | 2024-11-01T12:26:56.048Z |
5364541 | 5364541 | 20241023223659_TiwOz | DK0008 | 2024-10-25T12:17:24.169Z | 2024-11-01T12:26:55.191Z |
5364507 | 5364507 | 20241023223514_LPWxe | DK0008 | 2024-10-25T12:17:23.196Z | 2024-11-01T12:26:55.164Z |
5364417 | 5364417 | 20241023222658_i2sbN | DK0008 | 2024-10-25T12:17:20.219Z | 2024-11-01T12:26:55.046Z |
5362422 | 5362422 | 20241023193323_KOoYX | DK0008 | 2024-10-25T12:14:26.467Z | 2024-11-01T12:26:51.648Z |
5361565 | 5361565 | 20241023182634_eSfT4 | DK0008 | 2024-10-25T12:12:55.816Z | 2024-11-01T12:26:50.354Z |
5361221 | 5361221 | 20241023180118_Yi1HX | DK0008 | 2024-10-25T12:12:28.573Z | 2024-11-01T12:26:49.523Z |
5355043 | 5355043 | 20241023030657_om8MU | DK0008 | 2024-10-24T12:21:01.219Z | 2024-10-31T12:30:07.135Z |
5354994 | 5354994 | 20241023030319_C6iv3 | DK0008 | 2024-10-24T12:20:59.595Z | 2024-10-31T12:30:06.839Z |
5354930 | 5354930 | 20241023025702_OYCW2 | DK0008 | 2024-10-24T12:20:57.656Z | 2024-10-31T12:30:06.765Z |
5354738 | 5354738 | 20241023024317_Gh0D2 | DK0008 | 2024-10-24T12:20:48.190Z | 2024-10-31T12:30:06.289Z |
5354568 | 5354568 | 20241023023327_dxVv1 | DK0008 | 2024-10-24T12:20:41.279Z | 2024-10-31T12:30:05.982Z |
5354423 | 5354423 | 20241023022555_FG6jd | DK0008 | 2024-10-24T12:20:33.363Z | 2024-10-31T12:30:05.846Z |
5353851 | 5353851 | 20241023015158_MtxEC | DK0008 | 2024-10-24T12:19:58.199Z | 2024-10-31T12:30:04.922Z |
5353820 | 5353820 | 20241023015045_BM5TG | DK0008 | 2024-10-24T12:19:57.507Z | 2024-10-31T12:30:04.856Z |
5353559 | 5353559 | 20241023013105_AAyYB | DK0008 | 2024-10-24T12:19:46.548Z | 2024-10-31T12:30:04.365Z |
5353146 | 5353146 | 20241023011031_Qc302 | DK0008 | 2024-10-24T12:19:33.815Z | 2024-10-31T12:30:03.869Z |
5353139 | 5353139 | 20241023010945_eoNZg | DK0008 | 2024-10-24T12:19:33.554Z | 2024-10-31T12:30:03.862Z |
5353104 | 5353104 | 20241023010752_TseGF | DK0008 | 2024-10-24T12:19:32.442Z | 2024-10-31T12:30:03.822Z |
5352960 | 5352960 | 20241023005801_gAgbH | DK0008 | 2024-10-24T12:19:27.882Z | 2024-10-31T12:30:03.588Z |
5352889 | 5352889 | 20241023005448_HoYcq | DK0008 | 2024-10-24T12:19:22.791Z | 2024-10-31T12:30:03.467Z |
5352747 | 5352747 | 20241023004828_W725t | DK0008 | 2024-10-24T12:19:09.906Z | 2024-10-31T12:30:03.215Z |
5352232 | 5352232 | 20241023002009_LqD25 | DK0008 | 2024-10-24T12:18:33.366Z | 2024-10-31T12:30:02.345Z |
5352087 | 5352087 | 20241023001013_OYISp | DK0008 | 2024-10-24T12:18:19.893Z | 2024-10-31T12:30:01.881Z |
5352065 | 5352065 | 20241023000830_8BefS | DK0008 | 2024-10-24T12:18:18.282Z | 2024-10-31T12:30:01.737Z |
5351837 | 5351837 | 20241022235539_BTFy3 | DK0008 | 2024-10-24T12:18:03.990Z | 2024-10-31T12:30:01.004Z |
5351212 | 5351212 | 20241022230705_MByfW | DK0008 | 2024-10-24T12:17:20.535Z | 2024-10-31T12:29:59.613Z |
5351198 | 5351198 | 20241022230454_JAw6K | DK0008 | 2024-10-24T12:17:19.966Z | 2024-10-31T12:29:59.599Z |
5351153 | 5351153 | 20241022230138_xshhT | DK0008 | 2024-10-24T12:17:16.358Z | 2024-10-31T12:29:59.552Z |
5348176 | 5348176 | 20241022173650_jSZaW | DK0008 | 2024-10-24T12:10:28.121Z | 2024-10-31T12:29:51.732Z |
5321779 | 5321779 | 20241015033450_5Iubt | DK0008 | 2024-10-19T12:17:53.470Z | 2024-10-23T12:24:50.863Z |
5318635 | 5318635 | 20241017041828_qu5sh | DK0008 | 2024-10-18T12:04:10.788Z | 2024-10-25T12:24:36.496Z |
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);