participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,421 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 |
---|---|---|---|---|---|
5604486 | 5604486 | 20241124232735_gRBry | FR0014 | 2024-11-26T14:17:11.073Z | 2024-11-26T14:18:45.032Z |
5604348 | 5604348 | 20241124223047_owA9n | FR0014 | 2024-11-26T14:17:00.250Z | 2024-11-26T14:18:44.989Z |
5591769 | 5591769 | 20241123005130_5byAW | FR0014 | 2024-11-24T14:20:16.620Z | 2024-11-26T14:23:30.126Z |
5591546 | 5591546 | 20241122234834_3N70C | FR0014 | 2024-11-24T14:20:00.486Z | 2024-11-26T14:23:25.211Z |
5591210 | 5591210 | 20241122215816_BQwFI | FR0014 | 2024-11-24T14:19:35.828Z | 2024-11-26T14:23:17.848Z |
5590510 | 5590510 | 20241122192842_SWm31 | FR0014 | 2024-11-24T14:18:37.314Z | 2024-11-26T14:23:08.079Z |
5579649 | 5579649 | 20241121230514_ygJV6 | FR0014 | 2024-11-23T14:18:40.030Z | 2024-11-26T14:25:00.203Z |
5574363 | 5574363 | 20241122053759_Li44p | FR0014 | 2024-11-23T14:03:06.769Z | 2024-11-26T14:22:20.980Z |
5574288 | 5574288 | 20241122053216_1yRXJ | FR0014 | 2024-11-23T14:02:58.633Z | 2024-11-26T14:22:19.943Z |
5574056 | 5574056 | 20241122050854_5kSwr | FR0014 | 2024-11-23T14:02:18.640Z | 2024-11-26T14:22:15.202Z |
5570229 | 5570229 | 20241120190706_y1YJH | FR0014 | 2024-11-22T14:15:02.751Z | 2024-11-26T14:26:15.298Z |
5564784 | 5564784 | 20241120032634_gENz7 | FR0014 | 2024-11-21T14:18:03.307Z | 2024-11-26T14:27:51.462Z |
5558077 | 5558077 | 20241120053451_NROXl | FR0014 | 2024-11-21T14:02:27.784Z | 2024-11-26T14:25:43.757Z |
5541307 | 5541307 | 20241114000903_3WDmE | FR0014 | 2024-11-15T14:07:25.071Z | 2024-11-22T14:24:17.995Z |
5532145 | 5532145 | 20241112044133_I1sd1 | FR0014 | 2024-11-13T14:16:21.999Z | 2024-11-20T14:26:20.269Z |
5528702 | 5528702 | 20241111222216_5ZdLE | FR0014 | 2024-11-13T14:11:18.524Z | 2024-11-20T14:25:34.046Z |
5527831 | 5527831 | 20241111184052_OFbXG | FR0014 | 2024-11-13T14:09:23.212Z | 2024-11-20T14:25:21.810Z |
5482701 | 5482701 | 20241104230440_3wYld | FR0014 | 2024-11-06T14:13:40.178Z | 2024-11-13T14:27:35.045Z |
5482346 | 5482346 | 20241104215506_ogowZ | FR0014 | 2024-11-06T14:13:04.080Z | 2024-11-13T14:27:34.395Z |
5481846 | 5481846 | 20241104195910_329LD | FR0014 | 2024-11-06T14:11:41.275Z | 2024-11-13T14:27:33.325Z |
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 |
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);