participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,404 rows where station_code = "FR0014" 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 |
---|---|---|---|---|---|
5482701 | 5482701 | 20241104230440_3wYld | FR0014 | 2024-11-06T14:13:40.178Z | 2024-11-09T14:21:01.069Z |
5482346 | 5482346 | 20241104215506_ogowZ | FR0014 | 2024-11-06T14:13:04.080Z | 2024-11-09T14:20:58.433Z |
5481846 | 5481846 | 20241104195910_329LD | FR0014 | 2024-11-06T14:11:41.275Z | 2024-11-09T14:20:51.796Z |
5443662 | 5443662 | 20241031000105_N2S9A | FR0014 | 2024-11-01T12:20:45.176Z | 2024-11-08T14:23:11.952Z |
5443524 | 5443524 | 20241030233520_Euf70 | FR0014 | 2024-11-01T12:20:37.034Z | 2024-11-08T14:23:11.537Z |
5440953 | 5440953 | 20241030232834_Jh1mE | FR0014 | 2024-11-01T12:16:04.117Z | 2024-11-08T14:23:11.226Z |
5440561 | 5440561 | 20241030222702_FPTQK | FR0014 | 2024-11-01T12:15:37.038Z | 2024-11-08T14:23:09.909Z |
5440557 | 5440557 | 20241030222702_1Dfu5 | FR0014 | 2024-11-01T12:15:36.909Z | 2024-11-08T14:23:09.900Z |
5440494 | 5440494 | 20241030222003_vVS61 | FR0014 | 2024-11-01T12:15:33.259Z | 2024-11-08T14:23:09.598Z |
5440237 | 5440237 | 20241030214530_zFqew | FR0014 | 2024-11-01T12:15:03.788Z | 2024-11-08T14:23:08.108Z |
5439492 | 5439492 | 20241030195948_KiaP3 | FR0014 | 2024-11-01T12:13:53.763Z | 2024-11-08T14:23:03.552Z |
5439059 | 5439059 | 20241030185042_BeASZ | FR0014 | 2024-11-01T12:13:03.491Z | 2024-11-08T14:23:02.085Z |
5432739 | 5432739 | 20241029042923_wIcqN | FR0014 | 2024-10-31T12:21:33.244Z | 2024-11-06T14:27:28.586Z |
5432720 | 5432720 | 20241029042507_n2p77 | FR0014 | 2024-10-31T12:21:32.493Z | 2024-11-06T14:27:28.563Z |
5432636 | 5432636 | 20241029040624_2miWh | FR0014 | 2024-10-31T12:21:29.459Z | 2024-11-06T14:27:28.259Z |
5432571 | 5432571 | 20241029035357_7zHPy | FR0014 | 2024-10-31T12:21:27.347Z | 2024-11-06T14:27:27.941Z |
5432472 | 5432472 | 20241029033750_aREMc | FR0014 | 2024-10-31T12:21:23.809Z | 2024-11-06T14:27:27.585Z |
5432452 | 5432452 | 20241029033627_z9s2z | FR0014 | 2024-10-31T12:21:23.030Z | 2024-11-06T14:27:27.507Z |
5432358 | 5432358 | 20241029032058_VCZwU | FR0014 | 2024-10-31T12:21:19.217Z | 2024-11-06T14:27:26.748Z |
5432218 | 5432218 | 20241029025525_l1g9X | FR0014 | 2024-10-31T12:21:13.218Z | 2024-11-06T14:27:26.262Z |
5432113 | 5432113 | 20241029024352_Bcc8M | FR0014 | 2024-10-31T12:21:03.017Z | 2024-11-06T14:27:25.980Z |
5431846 | 5431846 | 20241029020525_NI3wv | FR0014 | 2024-10-31T12:20:43.879Z | 2024-11-06T14:27:25.080Z |
5408938 | 5408938 | 20241027035043_EEvAM | FR0014 | 2024-10-29T12:16:57.712Z | 2024-11-04T14:29:00.847Z |
5408454 | 5408454 | 20241027032750_OBiFX | FR0014 | 2024-10-29T12:16:31.339Z | 2024-11-04T14:28:59.509Z |
5393580 | 5393580 | 20241025181446_ND2Ib | FR0014 | 2024-10-28T12:12:48.663Z | 2024-11-03T14:27:16.412Z |
5387977 | 5387977 | 20241025034848_m2z7w | FR0014 | 2024-10-27T12:21:51.209Z | 2024-11-02T12:28:33.513Z |
5387618 | 5387618 | 20241025030230_jkzef | FR0014 | 2024-10-27T12:21:30.929Z | 2024-11-02T12:28:32.832Z |
5387140 | 5387140 | 20241025020602_RQ3Uj | FR0014 | 2024-10-27T12:20:55.593Z | 2024-11-02T12:28:32.154Z |
5386097 | 5386097 | 20241025000403_v900R | FR0014 | 2024-10-27T12:19:50.056Z | 2024-11-02T12:28:30.686Z |
5386064 | 5386064 | 20241024235937_0rFju | FR0014 | 2024-10-27T12:19:48.432Z | 2024-11-02T12:28:30.653Z |
5385703 | 5385703 | 20241024231956_375X3 | FR0014 | 2024-10-27T12:19:18.046Z | 2024-11-02T12:28:30.085Z |
5385586 | 5385586 | 20241024230334_xICmv | FR0014 | 2024-10-27T12:19:07.650Z | 2024-11-02T12:28:29.948Z |
5384994 | 5384994 | 20241024213331_SOIq3 | FR0014 | 2024-10-27T12:18:08.341Z | 2024-11-02T12:28:28.879Z |
5383641 | 5383641 | 20241024184144_ASHbs | FR0014 | 2024-10-27T12:15:55.203Z | 2024-11-02T12:28:26.105Z |
5377989 | 5377989 | 20241024052237_52Tyr | FR0014 | 2024-10-26T12:22:51.689Z | 2024-11-01T12:27:03.216Z |
5377454 | 5377454 | 20241024045147_3i9zj | FR0014 | 2024-10-26T12:22:37.423Z | 2024-11-01T12:27:02.446Z |
5377450 | 5377450 | 20241024045100_t3ZdS | FR0014 | 2024-10-26T12:22:37.393Z | 2024-11-01T12:27:02.442Z |
5377344 | 5377344 | 20241024044553_ZKQRI | FR0014 | 2024-10-26T12:22:34.626Z | 2024-11-01T12:27:02.384Z |
5376446 | 5376446 | 20241024035548_8MEn1 | FR0014 | 2024-10-26T12:22:02.569Z | 2024-11-01T12:27:01.560Z |
5376067 | 5376067 | 20241024033939_6Bi1O | FR0014 | 2024-10-26T12:21:49.078Z | 2024-11-01T12:27:01.350Z |
5375508 | 5375508 | 20241024031657_u7D5j | FR0014 | 2024-10-26T12:21:29.890Z | 2024-11-01T12:27:00.734Z |
5375203 | 5375203 | 20241024030206_bj1Tj | FR0014 | 2024-10-26T12:21:16.743Z | 2024-11-01T12:27:00.440Z |
5374774 | 5374774 | 20241024024305_u6Jsi | FR0014 | 2024-10-26T12:21:00.902Z | 2024-11-01T12:26:59.591Z |
5374540 | 5374540 | 20241024023325_vI7xE | FR0014 | 2024-10-26T12:20:52.616Z | 2024-11-01T12:26:59.461Z |
5374325 | 5374325 | 20241024022205_13aJ0 | FR0014 | 2024-10-26T12:20:45.250Z | 2024-11-01T12:26:58.845Z |
5374034 | 5374034 | 20241024020647_0C2uc | FR0014 | 2024-10-26T12:20:35.187Z | 2024-11-01T12:26:58.640Z |
5373921 | 5373921 | 20241024015954_DKOBn | FR0014 | 2024-10-26T12:20:30.780Z | 2024-11-01T12:26:58.558Z |
5373552 | 5373552 | 20241024014313_vMwV3 | FR0014 | 2024-10-26T12:20:16.608Z | 2024-11-01T12:26:58.324Z |
5373288 | 5373288 | 20241024013137_Uowto | FR0014 | 2024-10-26T12:20:03.811Z | 2024-11-01T12:26:58.210Z |
5373145 | 5373145 | 20241024012624_tzmpw | FR0014 | 2024-10-26T12:19:59.396Z | 2024-11-01T12:26:58.145Z |
5372857 | 5372857 | 20241024011157_Q2vn5 | FR0014 | 2024-10-26T12:19:46.262Z | 2024-11-01T12:26:58.005Z |
5372777 | 5372777 | 20241024010744_1PC6X | FR0014 | 2024-10-26T12:19:42.590Z | 2024-11-01T12:26:57.914Z |
5372750 | 5372750 | 20241024010605_iZ4vt | FR0014 | 2024-10-26T12:19:41.183Z | 2024-11-01T12:26:57.904Z |
5372522 | 5372522 | 20241024005243_IYyFl | FR0014 | 2024-10-26T12:19:28.543Z | 2024-11-01T12:26:57.502Z |
5372114 | 5372114 | 20241024003326_MmkDb | FR0014 | 2024-10-26T12:19:09.432Z | 2024-11-01T12:26:57.150Z |
5372021 | 5372021 | 20241024002753_CtqWg | FR0014 | 2024-10-26T12:19:04.136Z | 2024-11-01T12:26:57.064Z |
5371949 | 5371949 | 20241024002413_8awh4 | FR0014 | 2024-10-26T12:18:59.671Z | 2024-11-01T12:26:57.009Z |
5366791 | 5366791 | 20241023041042_S1gh0 | FR0014 | 2024-10-25T12:21:30.566Z | 2024-10-31T12:30:08.644Z |
5366498 | 5366498 | 20241023022132_FX0DD | FR0014 | 2024-10-25T12:21:10.071Z | 2024-10-31T12:30:05.675Z |
5366460 | 5366460 | 20241024002215_FxF8f | FR0014 | 2024-10-25T12:18:27.389Z | 2024-11-01T12:26:56.984Z |
5366343 | 5366343 | 20241024001633_KdiBW | FR0014 | 2024-10-25T12:18:23.663Z | 2024-11-01T12:26:56.878Z |
5365700 | 5365700 | 20241023234344_4Y53D | FR0014 | 2024-10-25T12:18:05.522Z | 2024-11-01T12:26:56.367Z |
5365628 | 5365628 | 20241023234122_rzkUT | FR0014 | 2024-10-25T12:18:03.341Z | 2024-11-01T12:26:56.294Z |
5365166 | 5365166 | 20241023231821_Dms5M | FR0014 | 2024-10-25T12:17:48.168Z | 2024-11-01T12:26:55.904Z |
5364883 | 5364883 | 20241023225929_LIueU | FR0014 | 2024-10-25T12:17:38.744Z | 2024-11-01T12:26:55.737Z |
5364612 | 5364612 | 20241023224204_yzoeH | FR0014 | 2024-10-25T12:17:26.190Z | 2024-11-01T12:26:55.240Z |
5364559 | 5364559 | 20241023223816_jSX4V | FR0014 | 2024-10-25T12:17:24.706Z | 2024-11-01T12:26:55.217Z |
5364383 | 5364383 | 20241023222427_7mnoX | FR0014 | 2024-10-25T12:17:19.063Z | 2024-11-01T12:26:55.029Z |
5363468 | 5363468 | 20241023210642_2P2Tp | FR0014 | 2024-10-25T12:16:14.269Z | 2024-11-01T12:26:53.312Z |
5363253 | 5363253 | 20241023203928_Og54b | FR0014 | 2024-10-25T12:15:46.233Z | 2024-11-01T12:26:53.001Z |
5363152 | 5363152 | 20241023203157_wMhRD | FR0014 | 2024-10-25T12:15:34.429Z | 2024-11-01T12:26:52.887Z |
5363079 | 5363079 | 20241023202412_n6vHY | FR0014 | 2024-10-25T12:15:27.850Z | 2024-11-01T12:26:52.821Z |
5362342 | 5362342 | 20241023192639_JsSjY | FR0014 | 2024-10-25T12:14:18.540Z | 2024-11-01T12:26:51.256Z |
5362288 | 5362288 | 20241023192220_d2KYO | FR0014 | 2024-10-25T12:14:11.922Z | 2024-11-01T12:26:51.183Z |
5356254 | 5356254 | 20241023052531_3xSMq | FR0014 | 2024-10-24T12:21:56.716Z | 2024-10-31T12:30:11.181Z |
5356198 | 5356198 | 20241023051445_tSFuJ | FR0014 | 2024-10-24T12:21:55.584Z | 2024-10-31T12:30:10.836Z |
5356156 | 5356156 | 20241023050841_p73tj | FR0014 | 2024-10-24T12:21:54.640Z | 2024-10-31T12:30:10.640Z |
5355943 | 5355943 | 20241023044320_FyMoC | FR0014 | 2024-10-24T12:21:43.837Z | 2024-10-31T12:30:09.304Z |
5355839 | 5355839 | 20241023042554_WVNc4 | FR0014 | 2024-10-24T12:21:38.925Z | 2024-10-31T12:30:09.039Z |
5355826 | 5355826 | 20241023042434_588xf | FR0014 | 2024-10-24T12:21:38.601Z | 2024-10-31T12:30:09.001Z |
5355724 | 5355724 | 20241023040533_DlCfo | FR0014 | 2024-10-24T12:21:33.514Z | 2024-10-31T12:30:08.583Z |
5355698 | 5355698 | 20241023040214_X7Ffk | FR0014 | 2024-10-24T12:21:32.127Z | 2024-10-31T12:30:08.519Z |
5355607 | 5355607 | 20241023035411_WZhrP | FR0014 | 2024-10-24T12:21:26.958Z | 2024-10-31T12:30:08.095Z |
5355504 | 5355504 | 20241023034620_GT14Q | FR0014 | 2024-10-24T12:21:23.977Z | 2024-10-31T12:30:07.894Z |
5355466 | 5355466 | 20241023034227_oPZLV | FR0014 | 2024-10-24T12:21:21.774Z | 2024-10-31T12:30:07.799Z |
5355459 | 5355459 | 20241023034116_q6Syi | FR0014 | 2024-10-24T12:21:21.409Z | 2024-10-31T12:30:07.703Z |
5355394 | 5355394 | 20241023033650_txi3e | FR0014 | 2024-10-24T12:21:17.634Z | 2024-10-31T12:30:07.579Z |
5355312 | 5355312 | 20241023032852_msb5w | FR0014 | 2024-10-24T12:21:14.215Z | 2024-10-31T12:30:07.516Z |
5355078 | 5355078 | 20241023031315_i9Qw9 | FR0014 | 2024-10-24T12:21:04.295Z | 2024-10-31T12:30:07.266Z |
5354661 | 5354661 | 20241023023838_v1HgG | FR0014 | 2024-10-24T12:20:45.944Z | 2024-10-31T12:30:06.223Z |
5354498 | 5354498 | 20241023022905_7EBPg | FR0014 | 2024-10-24T12:20:36.696Z | 2024-10-31T12:30:05.879Z |
5354367 | 5354367 | 20241023022259_mKhh8 | FR0014 | 2024-10-24T12:20:30.391Z | 2024-10-31T12:30:05.686Z |
5354341 | 5354341 | 20241023022102_CwDAh | FR0014 | 2024-10-24T12:20:28.400Z | 2024-10-31T12:30:05.653Z |
5354151 | 5354151 | 20241023020734_q1j23 | FR0014 | 2024-10-24T12:20:18.464Z | 2024-10-31T12:30:05.423Z |
5353834 | 5353834 | 20241023015109_zAMYR | FR0014 | 2024-10-24T12:19:57.931Z | 2024-10-31T12:30:04.901Z |
5353812 | 5353812 | 20241023014927_VGqnX | FR0014 | 2024-10-24T12:19:57.165Z | 2024-10-31T12:30:04.848Z |
5353692 | 5353692 | 20241023014101_JfOem | FR0014 | 2024-10-24T12:19:53.529Z | 2024-10-31T12:30:04.668Z |
5353567 | 5353567 | 20241023013109_0HcUd | FR0014 | 2024-10-24T12:19:46.612Z | 2024-10-31T12:30:04.370Z |
5352486 | 5352486 | 20241023003514_PcqwL | FR0014 | 2024-10-24T12:18:51.954Z | 2024-10-31T12:30:02.822Z |
5352338 | 5352338 | 20241023002645_Sa2bA | FR0014 | 2024-10-24T12:18:38.953Z | 2024-10-31T12:30:02.447Z |
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);