participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,098 rows where station_code = "FR000R" 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 |
---|---|---|---|---|---|
5571613 | 5571613 | 20241121001643_ji1hf | FR000R | 2024-11-22T14:17:24.021Z | 2024-11-22T14:19:22.159Z |
5569955 | 5569955 | 20241120180746_pXCYZ | FR000R | 2024-11-22T14:14:40.022Z | 2024-11-22T14:19:21.836Z |
5558097 | 5558097 | 20241120053638_JWvvw | FR000R | 2024-11-21T14:02:30.530Z | 2024-11-22T14:19:21.178Z |
5558050 | 5558050 | 20241120053320_Rb87I | FR000R | 2024-11-21T14:02:23.071Z | 2024-11-22T14:19:21.169Z |
5557951 | 5557951 | 20241120052454_9L620 | FR000R | 2024-11-21T14:02:07.705Z | 2024-11-22T14:19:21.151Z |
5557941 | 5557941 | 20241120052424_4fnGf | FR000R | 2024-11-21T14:02:06.889Z | 2024-11-22T14:19:21.150Z |
5557442 | 5557442 | 20241120044541_ouK2a | FR000R | 2024-11-21T14:00:51.314Z | 2024-11-22T14:19:21.070Z |
5557276 | 5557276 | 20241120043316_aikaD | FR000R | 2024-11-21T14:00:20.547Z | 2024-11-22T14:19:21.045Z |
5478699 | 5478699 | 20241104051138_YLrQX | FR000R | 2024-11-05T14:18:42.950Z | 2024-11-12T14:28:16.578Z |
5478688 | 5478688 | 20241104050743_bueea | FR000R | 2024-11-05T14:18:41.851Z | 2024-11-12T14:28:16.562Z |
5478668 | 5478668 | 20241104045635_RdFor | FR000R | 2024-11-05T14:18:39.509Z | 2024-11-12T14:28:16.530Z |
5478442 | 5478442 | 20241104041316_XniVO | FR000R | 2024-11-05T14:18:22.957Z | 2024-11-12T14:28:15.407Z |
5478430 | 5478430 | 20241104040923_oAYwt | FR000R | 2024-11-05T14:18:21.903Z | 2024-11-12T14:28:15.281Z |
5478224 | 5478224 | 20241104033919_Zghge | FR000R | 2024-11-05T14:18:05.020Z | 2024-11-12T14:28:14.627Z |
5478210 | 5478210 | 20241104033629_Ysz2j | FR000R | 2024-11-05T14:18:03.971Z | 2024-11-12T14:28:14.559Z |
5478130 | 5478130 | 20241104032421_wswmQ | FR000R | 2024-11-05T14:17:58.323Z | 2024-11-12T14:28:14.415Z |
5478070 | 5478070 | 20241104031729_UFZPC | FR000R | 2024-11-05T14:17:51.282Z | 2024-11-12T14:28:14.138Z |
5478055 | 5478055 | 20241104031500_v8lGW | FR000R | 2024-11-05T14:17:48.281Z | 2024-11-12T14:28:13.978Z |
5478021 | 5478021 | 20241104030907_v61nd | FR000R | 2024-11-05T14:17:45.429Z | 2024-11-12T14:28:13.868Z |
5477891 | 5477891 | 20241104025124_r2JyJ | FR000R | 2024-11-05T14:17:34.860Z | 2024-11-12T14:28:13.149Z |
5477810 | 5477810 | 20241104023909_7f4RE | FR000R | 2024-11-05T14:17:26.586Z | 2024-11-12T14:28:13.021Z |
5477781 | 5477781 | 20241104023431_dAyYU | FR000R | 2024-11-05T14:17:24.458Z | 2024-11-12T14:28:12.876Z |
5477624 | 5477624 | 20241104021407_o6n7d | FR000R | 2024-11-05T14:17:09.831Z | 2024-11-12T14:28:12.166Z |
5477434 | 5477434 | 20241104015109_XeLqx | FR000R | 2024-11-05T14:16:53.139Z | 2024-11-12T14:28:11.742Z |
5477198 | 5477198 | 20241104011808_FtEDF | FR000R | 2024-11-05T14:16:30.737Z | 2024-11-12T14:28:09.995Z |
5477191 | 5477191 | 20241104011604_eVZZR | FR000R | 2024-11-05T14:16:30.057Z | 2024-11-12T14:28:09.961Z |
5476887 | 5476887 | 20241104003818_OsfM6 | FR000R | 2024-11-05T14:16:10.299Z | 2024-11-12T14:28:07.836Z |
5476867 | 5476867 | 20241104003632_WVrW3 | FR000R | 2024-11-05T14:16:08.749Z | 2024-11-12T14:28:07.768Z |
5476642 | 5476642 | 20241103235837_paD9a | FR000R | 2024-11-05T14:15:47.687Z | 2024-11-12T14:28:06.642Z |
5476540 | 5476540 | 20241103234105_EAgDT | FR000R | 2024-11-05T14:15:35.611Z | 2024-11-12T14:28:06.448Z |
5476328 | 5476328 | 20241103230913_XwrdO | FR000R | 2024-11-05T14:15:04.710Z | 2024-11-12T14:28:05.509Z |
5476295 | 5476295 | 20241103230234_NrpMs | FR000R | 2024-11-05T14:15:01.024Z | 2024-11-12T14:28:04.938Z |
5476214 | 5476214 | 20241103224453_anKl7 | FR000R | 2024-11-05T14:14:52.860Z | 2024-11-12T14:28:03.859Z |
5476192 | 5476192 | 20241103224032_nZ50k | FR000R | 2024-11-05T14:14:50.718Z | 2024-11-12T14:28:03.723Z |
5476159 | 5476159 | 20241103223600_8KChw | FR000R | 2024-11-05T14:14:49.041Z | 2024-11-12T14:28:03.436Z |
5475786 | 5475786 | 20241103212340_gw4Nx | FR000R | 2024-11-05T14:14:12.321Z | 2024-11-12T14:28:00.972Z |
5475457 | 5475457 | 20241103200942_sLSC1 | FR000R | 2024-11-05T14:13:41.274Z | 2024-11-12T14:27:58.648Z |
5475407 | 5475407 | 20241103200116_uyN1j | FR000R | 2024-11-05T14:13:28.329Z | 2024-11-12T14:27:58.472Z |
5474909 | 5474909 | 20241103183616_VmX2v | FR000R | 2024-11-05T14:12:15.600Z | 2024-11-12T14:27:55.402Z |
5454534 | 5454534 | 20241031043621_J7nkm | FR000R | 2024-11-02T12:23:10.502Z | 2024-11-08T14:23:23.585Z |
5454314 | 5454314 | 20241031040748_w27y3 | FR000R | 2024-11-02T12:23:00.371Z | 2024-11-08T14:23:22.156Z |
5453751 | 5453751 | 20241031025521_ErQZ7 | FR000R | 2024-11-02T12:22:41.843Z | 2024-11-08T14:23:18.979Z |
5443919 | 5443919 | 20241031002914_yXTdz | FR000R | 2024-11-01T12:20:57.143Z | 2024-11-08T14:23:13.201Z |
5443827 | 5443827 | 20241031001827_KUS72 | FR000R | 2024-11-01T12:20:53.362Z | 2024-11-08T14:23:12.696Z |
5440332 | 5440332 | 20241030215806_iYX3l | FR000R | 2024-11-01T12:15:24.629Z | 2024-11-08T14:23:08.981Z |
5440225 | 5440225 | 20241030214442_ZUlkG | FR000R | 2024-11-01T12:15:02.133Z | 2024-11-08T14:23:07.979Z |
5440116 | 5440116 | 20241030212418_jBC2M | FR000R | 2024-11-01T12:14:51.517Z | 2024-11-08T14:23:07.376Z |
5439958 | 5439958 | 20241030205725_loTv7 | FR000R | 2024-11-01T12:14:40.581Z | 2024-11-08T14:23:06.570Z |
5439383 | 5439383 | 20241030195001_GmnZe | FR000R | 2024-11-01T12:13:46.284Z | 2024-11-08T14:23:03.232Z |
5433443 | 5433443 | 20241029195922_rIwv8 | FR000R | 2024-10-31T12:22:15.931Z | 2024-11-07T14:26:39.604Z |
5419531 | 5419531 | 20241028001514_X3hcd | FR000R | 2024-10-30T12:17:32.066Z | 2024-11-05T14:27:13.382Z |
5419500 | 5419500 | 20241028001132_cYMs9 | FR000R | 2024-10-30T12:17:30.297Z | 2024-11-05T14:27:13.271Z |
5418117 | 5418117 | 20241027195637_IyrLP | FR000R | 2024-10-30T12:14:56.153Z | 2024-11-05T14:27:09.155Z |
5400630 | 5400630 | 20241024042344_GcL0X | FR000R | 2024-10-28T12:24:25.208Z | 2024-11-01T12:27:01.921Z |
5399658 | 5399658 | 20241026044559_4dbJi | FR000R | 2024-10-28T12:20:05.047Z | 2024-11-03T14:27:40.171Z |
5399456 | 5399456 | 20241026042024_sgO9a | FR000R | 2024-10-28T12:19:59.850Z | 2024-11-03T14:27:39.749Z |
5398972 | 5398972 | 20241026034239_VMQ9D | FR000R | 2024-10-28T12:19:42.923Z | 2024-11-03T14:27:38.779Z |
5398483 | 5398483 | 20241026030228_JTVOQ | FR000R | 2024-10-28T12:19:19.090Z | 2024-11-03T14:27:36.594Z |
5398472 | 5398472 | 20241026025955_zGZ4T | FR000R | 2024-10-28T12:19:18.640Z | 2024-11-03T14:27:36.395Z |
5398403 | 5398403 | 20241026025356_bbzgR | FR000R | 2024-10-28T12:19:13.940Z | 2024-11-03T14:27:36.255Z |
5397906 | 5397906 | 20241026020636_ApiYW | FR000R | 2024-10-28T12:18:50.121Z | 2024-11-03T14:27:34.499Z |
5397098 | 5397098 | 20241026010158_EJhYi | FR000R | 2024-10-28T12:18:07.719Z | 2024-11-03T14:27:32.023Z |
5397066 | 5397066 | 20241026010010_WxIhu | FR000R | 2024-10-28T12:18:05.455Z | 2024-11-03T14:27:31.981Z |
5396754 | 5396754 | 20241026003024_o8yM1 | FR000R | 2024-10-28T12:17:55.123Z | 2024-11-03T14:27:30.855Z |
5394998 | 5394998 | 20241025215819_8ZLeP | FR000R | 2024-10-28T12:15:52.241Z | 2024-11-03T14:27:23.630Z |
5394810 | 5394810 | 20241025212935_cCfFm | FR000R | 2024-10-28T12:15:27.579Z | 2024-11-03T14:27:22.803Z |
5394787 | 5394787 | 20241025212542_NGz2A | FR000R | 2024-10-28T12:15:25.474Z | 2024-11-03T14:27:22.773Z |
5393943 | 5393943 | 20241025191730_rsFCv | FR000R | 2024-10-28T12:13:54.347Z | 2024-11-03T14:27:19.137Z |
5393828 | 5393828 | 20241025185333_PXoMP | FR000R | 2024-10-28T12:13:32.647Z | 2024-11-03T14:27:18.601Z |
5393663 | 5393663 | 20241025182713_Q77wA | FR000R | 2024-10-28T12:12:58.126Z | 2024-11-03T14:27:17.357Z |
5393576 | 5393576 | 20241025181422_9YXx9 | FR000R | 2024-10-28T12:12:48.093Z | 2024-11-03T14:27:16.392Z |
5386511 | 5386511 | 20241025005045_Ve33k | FR000R | 2024-10-27T12:20:08.716Z | 2024-11-02T12:28:31.297Z |
5386499 | 5386499 | 20241025004931_DMT1v | FR000R | 2024-10-27T12:20:08.249Z | 2024-11-02T12:28:31.290Z |
5386161 | 5386161 | 20241025001003_S7EAv | FR000R | 2024-10-27T12:19:53.152Z | 2024-11-02T12:28:30.761Z |
5386084 | 5386084 | 20241025000208_EP3CT | FR000R | 2024-10-27T12:19:49.540Z | 2024-11-02T12:28:30.680Z |
5385966 | 5385966 | 20241024234743_trnkP | FR000R | 2024-10-27T12:19:40.989Z | 2024-11-02T12:28:30.530Z |
5385617 | 5385617 | 20241024230720_b3R1L | FR000R | 2024-10-27T12:19:11.000Z | 2024-11-02T12:28:29.977Z |
5377786 | 5377786 | 20241024051006_ANNZF | FR000R | 2024-10-26T12:22:46.940Z | 2024-11-01T12:27:02.896Z |
5377626 | 5377626 | 20241024050020_5kLtU | FR000R | 2024-10-26T12:22:42.819Z | 2024-11-01T12:27:02.683Z |
5377487 | 5377487 | 20241024045405_Bi1aW | FR000R | 2024-10-26T12:22:38.549Z | 2024-11-01T12:27:02.459Z |
5377386 | 5377386 | 20241024044837_sOS50 | FR000R | 2024-10-26T12:22:35.498Z | 2024-11-01T12:27:02.414Z |
5376902 | 5376902 | 20241024042216_11D2P | FR000R | 2024-10-26T12:22:16.418Z | 2024-11-01T12:27:01.911Z |
5376449 | 5376449 | 20241024035554_O4V5F | FR000R | 2024-10-26T12:22:02.617Z | 2024-11-01T12:27:01.561Z |
5376014 | 5376014 | 20241024033745_qeqcf | FR000R | 2024-10-26T12:21:46.138Z | 2024-11-01T12:27:01.314Z |
5375645 | 5375645 | 20241024032233_8h9Cc | FR000R | 2024-10-26T12:21:34.564Z | 2024-11-01T12:27:01.145Z |
5375499 | 5375499 | 20241024031631_P0ztj | FR000R | 2024-10-26T12:21:28.996Z | 2024-11-01T12:27:00.729Z |
5374674 | 5374674 | 20241024023941_R2g3w | FR000R | 2024-10-26T12:20:56.686Z | 2024-11-01T12:26:59.531Z |
5374455 | 5374455 | 20241024022754_wJxIq | FR000R | 2024-10-26T12:20:49.545Z | 2024-11-01T12:26:59.393Z |
5374389 | 5374389 | 20241024022514_UkW53 | FR000R | 2024-10-26T12:20:47.217Z | 2024-11-01T12:26:59.354Z |
5374223 | 5374223 | 20241024021749_h24T4 | FR000R | 2024-10-26T12:20:40.624Z | 2024-11-01T12:26:58.779Z |
5373962 | 5373962 | 20241024020300_siH75 | FR000R | 2024-10-26T12:20:32.994Z | 2024-11-01T12:26:58.612Z |
5373593 | 5373593 | 20241024014608_D522E | FR000R | 2024-10-26T12:20:17.952Z | 2024-11-01T12:26:58.334Z |
5373511 | 5373511 | 20241024014114_MLNGE | FR000R | 2024-10-26T12:20:14.738Z | 2024-11-01T12:26:58.311Z |
5373277 | 5373277 | 20241024013103_h21I4 | FR000R | 2024-10-26T12:20:03.681Z | 2024-11-01T12:26:58.207Z |
5373270 | 5373270 | 20241024013031_cZITC | FR000R | 2024-10-26T12:20:03.628Z | 2024-11-01T12:26:58.205Z |
5372307 | 5372307 | 20241024004342_WuBC0 | FR000R | 2024-10-26T12:19:19.436Z | 2024-11-01T12:26:57.373Z |
5372232 | 5372232 | 20241024003933_xmUBY | FR000R | 2024-10-26T12:19:15.808Z | 2024-11-01T12:26:57.317Z |
5372203 | 5372203 | 20241024003745_fLsN9 | FR000R | 2024-10-26T12:19:14.315Z | 2024-11-01T12:26:57.305Z |
5366939 | 5366939 | 20241023044408_ospmI | FR000R | 2024-10-25T12:21:36.996Z | 2024-10-31T12:30:09.369Z |
5366858 | 5366858 | 20241023042832_qnEV2 | FR000R | 2024-10-25T12:21:33.611Z | 2024-10-31T12:30:09.073Z |
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);