participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,927 rows where station_code = "FR0011" 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 |
---|---|---|---|---|---|
5590782 | 5590782 | 20241122200510_IshL1 | FR0011 | 2024-11-24T14:18:58.021Z | 2024-11-26T14:23:12.614Z |
5580170 | 5580170 | 20241122001153_TQo4P | FR0011 | 2024-11-23T14:19:09.191Z | 2024-11-26T14:25:03.830Z |
5579815 | 5579815 | 20241121232345_xMroG | FR0011 | 2024-11-23T14:18:51.667Z | 2024-11-26T14:25:01.385Z |
5579752 | 5579752 | 20241121231427_hXBvS | FR0011 | 2024-11-23T14:18:48.503Z | 2024-11-26T14:25:00.943Z |
5579395 | 5579395 | 20241121223638_X127K | FR0011 | 2024-11-23T14:18:20.965Z | 2024-11-26T14:24:58.172Z |
5579315 | 5579315 | 20241121222520_PD2kV | FR0011 | 2024-11-23T14:18:10.374Z | 2024-11-26T14:24:57.185Z |
5579193 | 5579193 | 20241121215959_BGMyD | FR0011 | 2024-11-23T14:17:58.072Z | 2024-11-26T14:24:55.691Z |
5579155 | 5579155 | 20241121215400_OZkgQ | FR0011 | 2024-11-23T14:17:55.953Z | 2024-11-26T14:24:55.337Z |
5578828 | 5578828 | 20241121210547_PDlwN | FR0011 | 2024-11-23T14:17:35.099Z | 2024-11-26T14:24:52.899Z |
5578777 | 5578777 | 20241121210048_uwDth | FR0011 | 2024-11-23T14:17:33.299Z | 2024-11-26T14:24:52.514Z |
5578603 | 5578603 | 20241121202945_AE8uG | FR0011 | 2024-11-23T14:17:24.464Z | 2024-11-26T14:24:50.092Z |
5478722 | 5478722 | 20241104051835_nY2lT | FR0011 | 2024-11-05T14:18:44.690Z | 2024-11-12T14:28:16.768Z |
5478671 | 5478671 | 20241104045745_yl0gC | FR0011 | 2024-11-05T14:18:39.732Z | 2024-11-12T14:28:16.537Z |
5478661 | 5478661 | 20241104045532_PREvZ | FR0011 | 2024-11-05T14:18:38.630Z | 2024-11-12T14:28:16.479Z |
5478473 | 5478473 | 20241104041603_VSGAS | FR0011 | 2024-11-05T14:18:24.217Z | 2024-11-12T14:28:15.557Z |
5478446 | 5478446 | 20241104041327_pNqj0 | FR0011 | 2024-11-05T14:18:23.236Z | 2024-11-12T14:28:15.409Z |
5478428 | 5478428 | 20241104040922_Wd0JL | FR0011 | 2024-11-05T14:18:21.800Z | 2024-11-12T14:28:15.280Z |
5478397 | 5478397 | 20241104040156_XD0YN | FR0011 | 2024-11-05T14:18:18.337Z | 2024-11-12T14:28:15.221Z |
5478373 | 5478373 | 20241104035827_EyhKi | FR0011 | 2024-11-05T14:18:16.356Z | 2024-11-12T14:28:15.037Z |
5478313 | 5478313 | 20241104035118_l7RA8 | FR0011 | 2024-11-05T14:18:13.131Z | 2024-11-12T14:28:14.917Z |
5478227 | 5478227 | 20241104033919_Jhrha | FR0011 | 2024-11-05T14:18:05.095Z | 2024-11-12T14:28:14.628Z |
5478057 | 5478057 | 20241104031522_0zGfp | FR0011 | 2024-11-05T14:17:48.845Z | 2024-11-12T14:28:13.984Z |
5478053 | 5478053 | 20241104031500_No5vR | FR0011 | 2024-11-05T14:17:48.073Z | 2024-11-12T14:28:13.961Z |
5477970 | 5477970 | 20241104030220_T8jqM | FR0011 | 2024-11-05T14:17:41.304Z | 2024-11-12T14:28:13.669Z |
5477966 | 5477966 | 20241104030139_UJv6f | FR0011 | 2024-11-05T14:17:40.628Z | 2024-11-12T14:28:13.665Z |
5477958 | 5477958 | 20241104030024_23WwZ | FR0011 | 2024-11-05T14:17:40.312Z | 2024-11-12T14:28:13.648Z |
5477928 | 5477928 | 20241104025412_2GTzL | FR0011 | 2024-11-05T14:17:37.202Z | 2024-11-12T14:28:13.311Z |
5477650 | 5477650 | 20241104021717_lw8Qe | FR0011 | 2024-11-05T14:17:12.537Z | 2024-11-12T14:28:12.234Z |
5477617 | 5477617 | 20241104021333_DvCWC | FR0011 | 2024-11-05T14:17:09.473Z | 2024-11-12T14:28:12.150Z |
5477598 | 5477598 | 20241104021158_3NIdS | FR0011 | 2024-11-05T14:17:07.881Z | 2024-11-12T14:28:12.123Z |
5477596 | 5477596 | 20241104021154_YFWJZ | FR0011 | 2024-11-05T14:17:06.866Z | 2024-11-12T14:28:12.120Z |
5477436 | 5477436 | 20241104015127_sCMxD | FR0011 | 2024-11-05T14:16:53.324Z | 2024-11-12T14:28:11.753Z |
5477247 | 5477247 | 20241104012547_qqiWv | FR0011 | 2024-11-05T14:16:36.210Z | 2024-11-12T14:28:10.447Z |
5477146 | 5477146 | 20241104010816_czJ17 | FR0011 | 2024-11-05T14:16:26.901Z | 2024-11-12T14:28:09.858Z |
5477087 | 5477087 | 20241104005919_MzJl8 | FR0011 | 2024-11-05T14:16:21.295Z | 2024-11-12T14:28:08.783Z |
5477018 | 5477018 | 20241104005250_ywSp1 | FR0011 | 2024-11-05T14:16:17.664Z | 2024-11-12T14:28:08.277Z |
5477010 | 5477010 | 20241104005217_c3wVU | FR0011 | 2024-11-05T14:16:17.177Z | 2024-11-12T14:28:08.068Z |
5476918 | 5476918 | 20241104004139_XCh1m | FR0011 | 2024-11-05T14:16:12.197Z | 2024-11-12T14:28:07.892Z |
5476780 | 5476780 | 20241104002104_js2rS | FR0011 | 2024-11-05T14:16:04.358Z | 2024-11-12T14:28:07.415Z |
5476755 | 5476755 | 20241104001753_5PCya | FR0011 | 2024-11-05T14:16:03.055Z | 2024-11-12T14:28:07.165Z |
5476738 | 5476738 | 20241104001431_zATz4 | FR0011 | 2024-11-05T14:16:01.812Z | 2024-11-12T14:28:07.056Z |
5476619 | 5476619 | 20241103235439_ntUAd | FR0011 | 2024-11-05T14:15:45.431Z | 2024-11-12T14:28:06.608Z |
5476546 | 5476546 | 20241103234311_2OZJK | FR0011 | 2024-11-05T14:15:36.373Z | 2024-11-12T14:28:06.455Z |
5476443 | 5476443 | 20241103232720_vBK4F | FR0011 | 2024-11-05T14:15:24.290Z | 2024-11-12T14:28:06.098Z |
5476330 | 5476330 | 20241103230920_gOo5C | FR0011 | 2024-11-05T14:15:05.093Z | 2024-11-12T14:28:05.509Z |
5476292 | 5476292 | 20241103230113_xchVC | FR0011 | 2024-11-05T14:15:00.841Z | 2024-11-12T14:28:04.935Z |
5476284 | 5476284 | 20241103225835_rh74E | FR0011 | 2024-11-05T14:15:00.055Z | 2024-11-12T14:28:04.853Z |
5476196 | 5476196 | 20241103224059_vm7Pb | FR0011 | 2024-11-05T14:14:51.163Z | 2024-11-12T14:28:03.730Z |
5476099 | 5476099 | 20241103222416_KLD4Y | FR0011 | 2024-11-05T14:14:45.197Z | 2024-11-12T14:28:02.864Z |
5476003 | 5476003 | 20241103220618_hN5mx | FR0011 | 2024-11-05T14:14:38.599Z | 2024-11-12T14:28:02.162Z |
5475934 | 5475934 | 20241103215552_GxHEb | FR0011 | 2024-11-05T14:14:34.328Z | 2024-11-12T14:28:01.839Z |
5475816 | 5475816 | 20241103213023_BYP3N | FR0011 | 2024-11-05T14:14:17.627Z | 2024-11-12T14:28:01.144Z |
5475739 | 5475739 | 20241103211241_HOHLA | FR0011 | 2024-11-05T14:14:04.759Z | 2024-11-12T14:28:00.780Z |
5475552 | 5475552 | 20241103203433_tDBFb | FR0011 | 2024-11-05T14:13:48.489Z | 2024-11-12T14:27:59.775Z |
5475459 | 5475459 | 20241103200942_OfNb2 | FR0011 | 2024-11-05T14:13:41.416Z | 2024-11-12T14:27:58.653Z |
5475011 | 5475011 | 20241103184913_bVxV8 | FR0011 | 2024-11-05T14:12:24.257Z | 2024-11-12T14:27:56.115Z |
5474948 | 5474948 | 20241103184114_szroN | FR0011 | 2024-11-05T14:12:18.976Z | 2024-11-12T14:27:55.723Z |
5454598 | 5454598 | 20241031044232_9lBzc | FR0011 | 2024-11-02T12:23:13.811Z | 2024-11-08T14:23:24.322Z |
5454522 | 5454522 | 20241031043315_CH8Q5 | FR0011 | 2024-11-02T12:23:09.681Z | 2024-11-08T14:23:23.461Z |
5454429 | 5454429 | 20241031042036_VON2d | FR0011 | 2024-11-02T12:23:06.193Z | 2024-11-08T14:23:22.940Z |
5454385 | 5454385 | 20241031041409_qPhLK | FR0011 | 2024-11-02T12:23:04.845Z | 2024-11-08T14:23:22.547Z |
5454331 | 5454331 | 20241031040935_RwJXB | FR0011 | 2024-11-02T12:23:01.519Z | 2024-11-08T14:23:22.394Z |
5454312 | 5454312 | 20241031040715_fPZSs | FR0011 | 2024-11-02T12:23:00.195Z | 2024-11-08T14:23:22.097Z |
5440537 | 5440537 | 20241030222530_BTYEM | FR0011 | 2024-11-01T12:15:35.629Z | 2024-11-08T14:23:09.853Z |
5440362 | 5440362 | 20241030220233_53Zlc | FR0011 | 2024-11-01T12:15:26.635Z | 2024-11-08T14:23:09.204Z |
5440298 | 5440298 | 20241030215333_QspSX | FR0011 | 2024-11-01T12:15:16.996Z | 2024-11-08T14:23:08.660Z |
5440189 | 5440189 | 20241030213907_GOCQt | FR0011 | 2024-11-01T12:14:56.307Z | 2024-11-08T14:23:07.687Z |
5440087 | 5440087 | 20241030212206_ATF26 | FR0011 | 2024-11-01T12:14:49.482Z | 2024-11-08T14:23:07.302Z |
5439509 | 5439509 | 20241030200106_zg4cl | FR0011 | 2024-11-01T12:13:54.905Z | 2024-11-08T14:23:03.634Z |
5439384 | 5439384 | 20241030195001_GmnZe | FR0011 | 2024-11-01T12:13:46.299Z | 2024-11-08T14:23:03.232Z |
5418536 | 5418536 | 20241027210703_Y1uET | FR0011 | 2024-10-30T12:15:48.708Z | 2024-11-05T14:27:10.409Z |
5418151 | 5418151 | 20241027200127_UeHX6 | FR0011 | 2024-10-30T12:15:00.103Z | 2024-11-05T14:27:09.277Z |
5417971 | 5417971 | 20241027193534_IDXtj | FR0011 | 2024-10-30T12:14:41.403Z | 2024-11-05T14:27:08.736Z |
5401903 | 5401903 | 20241026180314_tLaMV | FR0011 | 2024-10-29T12:05:46.898Z | 2024-11-04T14:28:40.853Z |
5399099 | 5399099 | 20241026035242_6iOpK | FR0011 | 2024-10-28T12:19:48.397Z | 2024-11-03T14:27:39.018Z |
5398850 | 5398850 | 20241026033327_zlFax | FR0011 | 2024-10-28T12:19:37.205Z | 2024-11-03T14:27:38.298Z |
5398577 | 5398577 | 20241026030922_ljD2A | FR0011 | 2024-10-28T12:19:22.791Z | 2024-11-03T14:27:36.835Z |
5398443 | 5398443 | 20241026025829_RyWhf | FR0011 | 2024-10-28T12:19:17.541Z | 2024-11-03T14:27:36.379Z |
5398327 | 5398327 | 20241026024424_BaWKf | FR0011 | 2024-10-28T12:19:10.710Z | 2024-11-03T14:27:35.897Z |
5398151 | 5398151 | 20241026023000_l20sf | FR0011 | 2024-10-28T12:19:02.849Z | 2024-11-03T14:27:35.587Z |
5397135 | 5397135 | 20241026010405_YwGnL | FR0011 | 2024-10-28T12:18:08.927Z | 2024-11-03T14:27:32.066Z |
5397102 | 5397102 | 20241026010204_6oTC7 | FR0011 | 2024-10-28T12:18:08.108Z | 2024-11-03T14:27:32.026Z |
5394999 | 5394999 | 20241025215819_8ZLeP | FR0011 | 2024-10-28T12:15:52.241Z | 2024-11-03T14:27:23.630Z |
5394933 | 5394933 | 20241025214716_K40R5 | FR0011 | 2024-10-28T12:15:45.090Z | 2024-11-03T14:27:23.500Z |
5394856 | 5394856 | 20241025213513_lwh2d | FR0011 | 2024-10-28T12:15:32.839Z | 2024-11-03T14:27:22.913Z |
5394819 | 5394819 | 20241025213031_OzUby | FR0011 | 2024-10-28T12:15:29.131Z | 2024-11-03T14:27:22.824Z |
5394788 | 5394788 | 20241025212542_NGz2A | FR0011 | 2024-10-28T12:15:25.474Z | 2024-11-03T14:27:22.773Z |
5394704 | 5394704 | 20241025211254_I9YSy | FR0011 | 2024-10-28T12:15:15.813Z | 2024-11-03T14:27:22.359Z |
5394079 | 5394079 | 20241025193335_29Ce9 | FR0011 | 2024-10-28T12:14:02.522Z | 2024-11-03T14:27:19.825Z |
5394027 | 5394027 | 20241025192540_TmpgR | FR0011 | 2024-10-28T12:13:59.386Z | 2024-11-03T14:27:19.623Z |
5393613 | 5393613 | 20241025181905_Bbk4X | FR0011 | 2024-10-28T12:12:53.386Z | 2024-11-03T14:27:16.687Z |
5393476 | 5393476 | 20241025174929_3jerZ | FR0011 | 2024-10-28T12:12:37.897Z | 2024-11-03T14:27:15.547Z |
5386663 | 5386663 | 20241025011033_WPIF9 | FR0011 | 2024-10-27T12:20:15.606Z | 2024-11-02T12:28:31.477Z |
5386241 | 5386241 | 20241025001715_TEnhM | FR0011 | 2024-10-27T12:19:56.303Z | 2024-11-02T12:28:30.871Z |
5386215 | 5386215 | 20241025001417_Yojhc | FR0011 | 2024-10-27T12:19:55.232Z | 2024-11-02T12:28:30.841Z |
5386207 | 5386207 | 20241025001356_2cZ19 | FR0011 | 2024-10-27T12:19:54.893Z | 2024-11-02T12:28:30.839Z |
5386153 | 5386153 | 20241025000834_FOPHw | FR0011 | 2024-10-27T12:19:52.674Z | 2024-11-02T12:28:30.731Z |
5385236 | 5385236 | 20241024221156_I0spU | FR0011 | 2024-10-27T12:18:36.523Z | 2024-11-02T12:28:29.355Z |
5377611 | 5377611 | 20241024045926_woXun | FR0011 | 2024-10-26T12:22:42.330Z | 2024-11-01T12:27:02.676Z |
5377541 | 5377541 | 20241024045624_AlEKc | FR0011 | 2024-10-26T12:22:40.235Z | 2024-11-01T12:27:02.575Z |
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);