participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,870 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 |
---|---|---|---|---|---|
5454598 | 5454598 | 20241031044232_9lBzc | FR0011 | 2024-11-02T12:23:13.811Z | 2024-11-03T14:23:19.771Z |
5454522 | 5454522 | 20241031043315_CH8Q5 | FR0011 | 2024-11-02T12:23:09.681Z | 2024-11-03T14:23:19.135Z |
5454429 | 5454429 | 20241031042036_VON2d | FR0011 | 2024-11-02T12:23:06.193Z | 2024-11-03T14:23:18.355Z |
5454385 | 5454385 | 20241031041409_qPhLK | FR0011 | 2024-11-02T12:23:04.845Z | 2024-11-03T14:23:17.774Z |
5454331 | 5454331 | 20241031040935_RwJXB | FR0011 | 2024-11-02T12:23:01.519Z | 2024-11-03T14:23:16.836Z |
5454312 | 5454312 | 20241031040715_fPZSs | FR0011 | 2024-11-02T12:23:00.195Z | 2024-11-03T14:23:16.514Z |
5440537 | 5440537 | 20241030222530_BTYEM | FR0011 | 2024-11-01T12:15:35.629Z | 2024-11-03T14:22:53.260Z |
5440362 | 5440362 | 20241030220233_53Zlc | FR0011 | 2024-11-01T12:15:26.635Z | 2024-11-03T14:22:52.684Z |
5440298 | 5440298 | 20241030215333_QspSX | FR0011 | 2024-11-01T12:15:16.996Z | 2024-11-03T14:22:52.340Z |
5440189 | 5440189 | 20241030213907_GOCQt | FR0011 | 2024-11-01T12:14:56.307Z | 2024-11-03T14:22:51.750Z |
5440087 | 5440087 | 20241030212206_ATF26 | FR0011 | 2024-11-01T12:14:49.482Z | 2024-11-03T14:22:51.228Z |
5439509 | 5439509 | 20241030200106_zg4cl | FR0011 | 2024-11-01T12:13:54.905Z | 2024-11-03T14:22:48.289Z |
5439384 | 5439384 | 20241030195001_GmnZe | FR0011 | 2024-11-01T12:13:46.299Z | 2024-11-03T14:22:47.459Z |
5418536 | 5418536 | 20241027210703_Y1uET | FR0011 | 2024-10-30T12:15:48.708Z | 2024-11-03T14:25:52.591Z |
5418151 | 5418151 | 20241027200127_UeHX6 | FR0011 | 2024-10-30T12:15:00.103Z | 2024-11-03T14:25:49.866Z |
5417971 | 5417971 | 20241027193534_IDXtj | FR0011 | 2024-10-30T12:14:41.403Z | 2024-11-03T14:25:48.237Z |
5401903 | 5401903 | 20241026180314_tLaMV | FR0011 | 2024-10-29T12:05:46.898Z | 2024-11-03T14:26:20.007Z |
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 |
5376929 | 5376929 | 20241024042344_2ZTV9 | FR0011 | 2024-10-26T12:22:17.387Z | 2024-11-01T12:27:01.919Z |
5376790 | 5376790 | 20241024041656_g2PcI | FR0011 | 2024-10-26T12:22:13.231Z | 2024-11-01T12:27:01.854Z |
5376557 | 5376557 | 20241024040016_Dbc2s | FR0011 | 2024-10-26T12:22:05.154Z | 2024-11-01T12:27:01.599Z |
5376516 | 5376516 | 20241024035833_ezfSj | FR0011 | 2024-10-26T12:22:04.277Z | 2024-11-01T12:27:01.584Z |
5376432 | 5376432 | 20241024035522_qqOzh | FR0011 | 2024-10-26T12:22:02.445Z | 2024-11-01T12:27:01.556Z |
5376409 | 5376409 | 20241024035403_KfaJw | FR0011 | 2024-10-26T12:22:01.450Z | 2024-11-01T12:27:01.530Z |
5376246 | 5376246 | 20241024034720_zun4e | FR0011 | 2024-10-26T12:21:54.853Z | 2024-11-01T12:27:01.472Z |
5375862 | 5375862 | 20241024033356_g2hh0 | FR0011 | 2024-10-26T12:21:42.497Z | 2024-11-01T12:27:01.238Z |
5375764 | 5375764 | 20241024032858_jIkzV | FR0011 | 2024-10-26T12:21:38.962Z | 2024-11-01T12:27:01.187Z |
5375415 | 5375415 | 20241024031224_Hd9IR | FR0011 | 2024-10-26T12:21:24.147Z | 2024-11-01T12:27:00.678Z |
5375319 | 5375319 | 20241024030632_eJGSr | FR0011 | 2024-10-26T12:21:20.224Z | 2024-11-01T12:27:00.506Z |
5374926 | 5374926 | 20241024024957_obFwQ | FR0011 | 2024-10-26T12:21:06.010Z | 2024-11-01T12:27:00.040Z |
5374887 | 5374887 | 20241024024822_Ky3MB | FR0011 | 2024-10-26T12:21:04.993Z | 2024-11-01T12:27:00.027Z |
5374464 | 5374464 | 20241024022836_eum6H | FR0011 | 2024-10-26T12:20:49.998Z | 2024-11-01T12:26:59.398Z |
5374294 | 5374294 | 20241024022034_XHUT3 | FR0011 | 2024-10-26T12:20:44.063Z | 2024-11-01T12:26:58.830Z |
5374209 | 5374209 | 20241024021558_2K3FM | FR0011 | 2024-10-26T12:20:39.342Z | 2024-11-01T12:26:58.761Z |
5374192 | 5374192 | 20241024021507_7sV7W | FR0011 | 2024-10-26T12:20:38.933Z | 2024-11-01T12:26:58.753Z |
5373941 | 5373941 | 20241024020117_ShMEl | FR0011 | 2024-10-26T12:20:31.525Z | 2024-11-01T12:26:58.576Z |
5373635 | 5373635 | 20241024014745_v3HTY | FR0011 | 2024-10-26T12:20:19.320Z | 2024-11-01T12:26:58.345Z |
5373319 | 5373319 | 20241024013241_ZF3mP | FR0011 | 2024-10-26T12:20:06.523Z | 2024-11-01T12:26:58.220Z |
5373290 | 5373290 | 20241024013148_eNQu3 | FR0011 | 2024-10-26T12:20:03.994Z | 2024-11-01T12:26:58.211Z |
5372952 | 5372952 | 20241024011602_2sja7 | FR0011 | 2024-10-26T12:19:49.658Z | 2024-11-01T12:26:58.042Z |
5367025 | 5367025 | 20241023050629_DbEJ9 | FR0011 | 2024-10-25T12:21:41.452Z | 2024-10-31T12:30:10.568Z |
5366975 | 5366975 | 20241023045308_mz2Ty | FR0011 | 2024-10-25T12:21:39.634Z | 2024-10-31T12:30:09.733Z |
5366968 | 5366968 | 20241023045119_oDwKo | FR0011 | 2024-10-25T12:21:39.421Z | 2024-10-31T12:30:09.653Z |
5366966 | 5366966 | 20241023045119_Rzm5x | FR0011 | 2024-10-25T12:21:39.400Z | 2024-10-31T12:30:09.642Z |
5366907 | 5366907 | 20241023043746_13c92 | FR0011 | 2024-10-25T12:21:36.066Z | 2024-10-31T12:30:09.226Z |
5366778 | 5366778 | 20241023040830_Tweyy | FR0011 | 2024-10-25T12:21:30.233Z | 2024-10-31T12:30:08.608Z |
5366775 | 5366775 | 20241023040715_miwvn | FR0011 | 2024-10-25T12:21:30.170Z | 2024-10-31T12:30:08.593Z |
5366753 | 5366753 | 20241023035739_N8OPv | FR0011 | 2024-10-25T12:21:28.909Z | 2024-10-31T12:30:08.258Z |
5366733 | 5366733 | 20241023035331_RAFhh | FR0011 | 2024-10-25T12:21:28.574Z | 2024-10-31T12:30:08.085Z |
5366725 | 5366725 | 20241023035156_q2l0F | FR0011 | 2024-10-25T12:21:28.491Z | 2024-10-31T12:30:08.071Z |
5366684 | 5366684 | 20241023033432_KuB0N | FR0011 | 2024-10-25T12:21:25.838Z | 2024-10-31T12:30:07.557Z |
5366669 | 5366669 | 20241023032700_ms9sJ | FR0011 | 2024-10-25T12:21:24.844Z | 2024-10-31T12:30:07.474Z |
5366655 | 5366655 | 20241023031917_pE5Cs | FR0011 | 2024-10-25T12:21:23.499Z | 2024-10-31T12:30:07.361Z |
5366624 | 5366624 | 20241023031053_YpWHI | FR0011 | 2024-10-25T12:21:20.946Z | 2024-10-31T12:30:07.230Z |
5366583 | 5366583 | 20241023025241_EocZd | FR0011 | 2024-10-25T12:21:18.202Z | 2024-10-31T12:30:06.472Z |
5366548 | 5366548 | 20241023024401_sk911 | FR0011 | 2024-10-25T12:21:16.148Z | 2024-10-31T12:30:06.297Z |
5366536 | 5366536 | 20241023023432_Hejrq | FR0011 | 2024-10-25T12:21:14.861Z | 2024-10-31T12:30:06.111Z |
5366496 | 5366496 | 20241023022119_laPhG | FR0011 | 2024-10-25T12:21:10.066Z | 2024-10-31T12:30:05.674Z |
5366492 | 5366492 | 20241023022003_TAj6Y | FR0011 | 2024-10-25T12:21:09.747Z | 2024-10-31T12:30:05.640Z |
5366346 | 5366346 | 20241024001639_d9jhx | FR0011 | 2024-10-25T12:18:23.714Z | 2024-11-01T12:26:56.879Z |
5366283 | 5366283 | 20241024001344_gfD0s | FR0011 | 2024-10-25T12:18:20.391Z | 2024-11-01T12:26:56.834Z |
5365404 | 5365404 | 20241023233008_6Si3w | FR0011 | 2024-10-25T12:17:57.200Z | 2024-11-01T12:26:56.081Z |
5365102 | 5365102 | 20241023231424_KbyPJ | FR0011 | 2024-10-25T12:17:46.120Z | 2024-11-01T12:26:55.875Z |
5364915 | 5364915 | 20241023230149_oBmsf | FR0011 | 2024-10-25T12:17:39.951Z | 2024-11-01T12:26:55.752Z |
5364879 | 5364879 | 20241023225902_hdol7 | FR0011 | 2024-10-25T12:17:38.550Z | 2024-11-01T12:26:55.735Z |
5364745 | 5364745 | 20241023225039_h3yic | FR0011 | 2024-10-25T12:17:31.893Z | 2024-11-01T12:26:55.605Z |
5364549 | 5364549 | 20241023223745_W336s | FR0011 | 2024-10-25T12:17:24.400Z | 2024-11-01T12:26:55.213Z |
5364470 | 5364470 | 20241023223011_pUbvQ | FR0011 | 2024-10-25T12:17:21.877Z | 2024-11-01T12:26:55.102Z |
5364434 | 5364434 | 20241023222745_tunMh | FR0011 | 2024-10-25T12:17:20.455Z | 2024-11-01T12:26:55.074Z |
5364362 | 5364362 | 20241023222324_dVb6x | FR0011 | 2024-10-25T12:17:18.262Z | 2024-11-01T12:26:55.019Z |
5364114 | 5364114 | 20241023220749_4dTvE | FR0011 | 2024-10-25T12:17:09.531Z | 2024-11-01T12:26:54.548Z |
5364092 | 5364092 | 20241023220625_3CYeD | FR0011 | 2024-10-25T12:17:08.597Z | 2024-11-01T12:26:54.527Z |
5364000 | 5364000 | 20241023220135_Gma4M | FR0011 | 2024-10-25T12:17:05.320Z | 2024-11-01T12:26:54.292Z |
5363930 | 5363930 | 20241023215834_23T7Y | FR0011 | 2024-10-25T12:17:02.441Z | 2024-11-01T12:26:54.208Z |
5363886 | 5363886 | 20241023215518_OQ6C4 | FR0011 | 2024-10-25T12:16:58.251Z | 2024-11-01T12:26:54.023Z |
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);