participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,867 rows where station_code = "FR000V" 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 |
---|---|---|---|---|---|
5604500 | 5604500 | 20241124233144_kIxRG | FR000V | 2024-11-26T14:17:11.828Z | 2024-11-26T14:18:45.038Z |
5603970 | 5603970 | 20241124191941_fudFB | FR000V | 2024-11-26T14:15:55.576Z | 2024-11-26T14:18:44.796Z |
5583166 | 5583166 | 20241120215230_biBuz | FR000V | 2024-11-23T14:23:21.322Z | 2024-11-26T14:26:31.399Z |
5582245 | 5582245 | 20241122031403_rUITn | FR000V | 2024-11-23T14:21:00.194Z | 2024-11-26T14:25:25.095Z |
5582130 | 5582130 | 20241122030539_p3ypl | FR000V | 2024-11-23T14:20:57.389Z | 2024-11-26T14:25:24.284Z |
5582052 | 5582052 | 20241122025956_8aAh8 | FR000V | 2024-11-23T14:20:54.810Z | 2024-11-26T14:25:23.397Z |
5582003 | 5582003 | 20241122025534_1QXLS | FR000V | 2024-11-23T14:20:53.662Z | 2024-11-26T14:25:21.258Z |
5581802 | 5581802 | 20241122023524_686BO | FR000V | 2024-11-23T14:20:44.086Z | 2024-11-26T14:25:19.041Z |
5581106 | 5581106 | 20241122014134_Q9efZ | FR000V | 2024-11-23T14:20:05.168Z | 2024-11-26T14:25:14.218Z |
5580729 | 5580729 | 20241122011001_CapT6 | FR000V | 2024-11-23T14:19:39.809Z | 2024-11-26T14:25:08.300Z |
5580686 | 5580686 | 20241122010257_V1Ml5 | FR000V | 2024-11-23T14:19:37.004Z | 2024-11-26T14:25:07.229Z |
5580361 | 5580361 | 20241122003334_rtYSi | FR000V | 2024-11-23T14:19:18.100Z | 2024-11-26T14:25:05.225Z |
5580284 | 5580284 | 20241122002621_og1qU | FR000V | 2024-11-23T14:19:15.668Z | 2024-11-26T14:25:04.767Z |
5580095 | 5580095 | 20241122000007_SUKjL | FR000V | 2024-11-23T14:19:04.480Z | 2024-11-26T14:25:03.071Z |
5570795 | 5570795 | 20241120210305_hEQ23 | FR000V | 2024-11-22T14:16:05.999Z | 2024-11-26T14:26:30.013Z |
5570766 | 5570766 | 20241120205322_kB7fh | FR000V | 2024-11-22T14:16:04.464Z | 2024-11-26T14:26:28.231Z |
5467980 | 5467980 | 20241102230634_2Qoyx | FR000V | 2024-11-04T14:13:03.959Z | 2024-11-11T14:22:50.650Z |
5431427 | 5431427 | 20241029011005_P4hcM | FR000V | 2024-10-31T12:20:07.858Z | 2024-11-06T14:27:23.713Z |
5431415 | 5431415 | 20241029010822_pbNJ0 | FR000V | 2024-10-31T12:20:06.488Z | 2024-11-06T14:27:23.526Z |
5431178 | 5431178 | 20241029003855_qtSKu | FR000V | 2024-10-31T12:19:43.440Z | 2024-11-06T14:27:22.916Z |
5430823 | 5430823 | 20241028234519_0Ugzw | FR000V | 2024-10-31T12:19:06.631Z | 2024-11-06T14:27:21.720Z |
5430814 | 5430814 | 20241028234322_DBpi7 | FR000V | 2024-10-31T12:19:05.469Z | 2024-11-06T14:27:21.713Z |
5430696 | 5430696 | 20241028232403_296mq | FR000V | 2024-10-31T12:18:53.053Z | 2024-11-06T14:27:21.086Z |
5430425 | 5430425 | 20241028223238_Ie7Ax | FR000V | 2024-10-31T12:18:22.008Z | 2024-11-06T14:27:19.957Z |
5430269 | 5430269 | 20241028215042_5Ukep | FR000V | 2024-10-31T12:18:00.488Z | 2024-11-06T14:27:19.482Z |
5428670 | 5428670 | 20241028175136_cfWed | FR000V | 2024-10-31T12:15:22.834Z | 2024-11-06T14:27:14.201Z |
5421051 | 5421051 | 20241028042349_8dHJR | FR000V | 2024-10-30T12:19:33.993Z | 2024-11-05T14:27:17.180Z |
5420986 | 5420986 | 20241028040911_HBpiD | FR000V | 2024-10-30T12:19:31.131Z | 2024-11-05T14:27:16.890Z |
5420709 | 5420709 | 20241028032503_L4GLY | FR000V | 2024-10-30T12:19:12.312Z | 2024-11-05T14:27:16.099Z |
5420639 | 5420639 | 20241028031049_YAUlW | FR000V | 2024-10-30T12:19:06.619Z | 2024-11-05T14:27:15.951Z |
5420146 | 5420146 | 20241028020419_eVmI2 | FR000V | 2024-10-30T12:18:25.126Z | 2024-11-05T14:27:14.670Z |
5419825 | 5419825 | 20241028011519_adV5j | FR000V | 2024-10-30T12:17:55.395Z | 2024-11-05T14:27:13.976Z |
5419664 | 5419664 | 20241028004134_6dEY7 | FR000V | 2024-10-30T12:17:42.413Z | 2024-11-05T14:27:13.682Z |
5419532 | 5419532 | 20241028001514_X3hcd | FR000V | 2024-10-30T12:17:32.066Z | 2024-11-05T14:27:13.382Z |
5419326 | 5419326 | 20241027233806_DPdJV | FR000V | 2024-10-30T12:17:20.606Z | 2024-11-05T14:27:12.733Z |
5419064 | 5419064 | 20241027225407_qkSCe | FR000V | 2024-10-30T12:17:02.049Z | 2024-11-05T14:27:12.307Z |
5418851 | 5418851 | 20241027221033_l8rCo | FR000V | 2024-10-30T12:16:23.323Z | 2024-11-05T14:27:11.478Z |
5418772 | 5418772 | 20241027215429_2ftBs | FR000V | 2024-10-30T12:16:09.255Z | 2024-11-05T14:27:11.112Z |
5418118 | 5418118 | 20241027195637_IyrLP | FR000V | 2024-10-30T12:14:56.194Z | 2024-11-05T14:27:09.155Z |
5417951 | 5417951 | 20241027193430_TFvRA | FR000V | 2024-10-30T12:14:39.702Z | 2024-11-05T14:27:08.712Z |
5417267 | 5417267 | 20241027180715_a7g0j | FR000V | 2024-10-30T12:13:26.847Z | 2024-11-05T14:27:06.877Z |
5395882 | 5395882 | 20241025231758_lwVM2 | FR000V | 2024-10-28T12:17:03.102Z | 2024-11-03T14:27:27.544Z |
5393416 | 5393416 | 20241025173315_sfnHw | FR000V | 2024-10-28T12:12:31.416Z | 2024-11-03T14:27:15.312Z |
5388362 | 5388362 | 20241025043824_F4OET | FR000V | 2024-10-27T12:22:10.778Z | 2024-11-02T12:28:34.033Z |
5388342 | 5388342 | 20241025043703_rtdC3 | FR000V | 2024-10-27T12:22:10.351Z | 2024-11-02T12:28:33.968Z |
5388294 | 5388294 | 20241025042708_Ix8HN | FR000V | 2024-10-27T12:22:08.370Z | 2024-11-02T12:28:33.916Z |
5388287 | 5388287 | 20241025042630_dE0q3 | FR000V | 2024-10-27T12:22:08.009Z | 2024-11-02T12:28:33.911Z |
5388155 | 5388155 | 20241025041029_lJkJr | FR000V | 2024-10-27T12:22:02.544Z | 2024-11-02T12:28:33.797Z |
5387361 | 5387361 | 20241025022642_2DY62 | FR000V | 2024-10-27T12:21:15.625Z | 2024-11-02T12:28:32.417Z |
5387319 | 5387319 | 20241025022336_92Q3A | FR000V | 2024-10-27T12:21:10.765Z | 2024-11-02T12:28:32.384Z |
5387317 | 5387317 | 20241025022227_qZCeA | FR000V | 2024-10-27T12:21:10.663Z | 2024-11-02T12:28:32.383Z |
5387294 | 5387294 | 20241025022028_ni1xr | FR000V | 2024-10-27T12:21:08.673Z | 2024-11-02T12:28:32.368Z |
5387241 | 5387241 | 20241025021602_rQrtX | FR000V | 2024-10-27T12:21:02.923Z | 2024-11-02T12:28:32.313Z |
5386791 | 5386791 | 20241025012622_wWPbQ | FR000V | 2024-10-27T12:20:28.363Z | 2024-11-02T12:28:31.603Z |
5386500 | 5386500 | 20241025004931_DMT1v | FR000V | 2024-10-27T12:20:08.249Z | 2024-11-02T12:28:31.290Z |
5386274 | 5386274 | 20241025002106_DuAsX | FR000V | 2024-10-27T12:19:58.247Z | 2024-11-02T12:28:30.917Z |
5386162 | 5386162 | 20241025001003_S7EAv | FR000V | 2024-10-27T12:19:53.152Z | 2024-11-02T12:28:30.761Z |
5386085 | 5386085 | 20241025000208_EP3CT | FR000V | 2024-10-27T12:19:49.540Z | 2024-11-02T12:28:30.680Z |
5385967 | 5385967 | 20241024234743_trnkP | FR000V | 2024-10-27T12:19:40.989Z | 2024-11-02T12:28:30.530Z |
5385930 | 5385930 | 20241024234453_H9inr | FR000V | 2024-10-27T12:19:38.160Z | 2024-11-02T12:28:30.500Z |
5385646 | 5385646 | 20241024231224_CsQJO | FR000V | 2024-10-27T12:19:12.796Z | 2024-11-02T12:28:30.008Z |
5385537 | 5385537 | 20241024225854_FgJN1 | FR000V | 2024-10-27T12:19:04.506Z | 2024-11-02T12:28:29.901Z |
5385519 | 5385519 | 20241024225600_cFT72 | FR000V | 2024-10-27T12:19:01.026Z | 2024-11-02T12:28:29.892Z |
5385123 | 5385123 | 20241024215504_zrT4L | FR000V | 2024-10-27T12:18:26.304Z | 2024-11-02T12:28:29.162Z |
5385121 | 5385121 | 20241024215447_uS3id | FR000V | 2024-10-27T12:18:26.162Z | 2024-11-02T12:28:29.160Z |
5385021 | 5385021 | 20241024213854_tAR8v | FR000V | 2024-10-27T12:18:14.377Z | 2024-11-02T12:28:28.957Z |
5374456 | 5374456 | 20241024022754_wJxIq | FR000V | 2024-10-26T12:20:49.545Z | 2024-11-01T12:26:59.393Z |
5374390 | 5374390 | 20241024022514_UkW53 | FR000V | 2024-10-26T12:20:47.217Z | 2024-11-01T12:26:59.354Z |
5374297 | 5374297 | 20241024022038_XMhV6 | FR000V | 2024-10-26T12:20:44.192Z | 2024-11-01T12:26:58.833Z |
5374224 | 5374224 | 20241024021749_h24T4 | FR000V | 2024-10-26T12:20:40.624Z | 2024-11-01T12:26:58.779Z |
5374093 | 5374093 | 20241024021001_SntTc | FR000V | 2024-10-26T12:20:36.796Z | 2024-11-01T12:26:58.694Z |
5373963 | 5373963 | 20241024020300_siH75 | FR000V | 2024-10-26T12:20:32.994Z | 2024-11-01T12:26:58.612Z |
5373594 | 5373594 | 20241024014608_D522E | FR000V | 2024-10-26T12:20:17.952Z | 2024-11-01T12:26:58.334Z |
5373509 | 5373509 | 20241024014109_ceNFc | FR000V | 2024-10-26T12:20:14.387Z | 2024-11-01T12:26:58.310Z |
5373271 | 5373271 | 20241024013031_cZITC | FR000V | 2024-10-26T12:20:03.628Z | 2024-11-01T12:26:58.205Z |
5373107 | 5373107 | 20241024012426_EcMvg | FR000V | 2024-10-26T12:19:57.997Z | 2024-11-01T12:26:58.134Z |
5372783 | 5372783 | 20241024010807_VtWOT | FR000V | 2024-10-26T12:19:42.989Z | 2024-11-01T12:26:57.916Z |
5372604 | 5372604 | 20241024005726_gtb4y | FR000V | 2024-10-26T12:19:32.806Z | 2024-11-01T12:26:57.745Z |
5372308 | 5372308 | 20241024004342_WuBC0 | FR000V | 2024-10-26T12:19:19.437Z | 2024-11-01T12:26:57.373Z |
5372204 | 5372204 | 20241024003745_fLsN9 | FR000V | 2024-10-26T12:19:14.315Z | 2024-11-01T12:26:57.305Z |
5366425 | 5366425 | 20241024002011_MxeP4 | FR000V | 2024-10-25T12:18:26.019Z | 2024-11-01T12:26:56.956Z |
5366150 | 5366150 | 20241024000714_3IZax | FR000V | 2024-10-25T12:18:17.939Z | 2024-11-01T12:26:56.772Z |
5366010 | 5366010 | 20241024000110_7mK48 | FR000V | 2024-10-25T12:18:14.158Z | 2024-11-01T12:26:56.531Z |
5365946 | 5365946 | 20241023235833_wZRNs | FR000V | 2024-10-25T12:18:10.870Z | 2024-11-01T12:26:56.499Z |
5365902 | 5365902 | 20241023235516_EULlU | FR000V | 2024-10-25T12:18:10.143Z | 2024-11-01T12:26:56.480Z |
5365827 | 5365827 | 20241023235100_F827z | FR000V | 2024-10-25T12:18:08.276Z | 2024-11-01T12:26:56.443Z |
5365406 | 5365406 | 20241023233048_AcDFj | FR000V | 2024-10-25T12:17:57.334Z | 2024-11-01T12:26:56.083Z |
5365366 | 5365366 | 20241023232759_xbMkH | FR000V | 2024-10-25T12:17:56.757Z | 2024-11-01T12:26:56.067Z |
5365327 | 5365327 | 20241023232551_hpWGb | FR000V | 2024-10-25T12:17:55.855Z | 2024-11-01T12:26:56.053Z |
5365114 | 5365114 | 20241023231521_Muli4 | FR000V | 2024-10-25T12:17:46.345Z | 2024-11-01T12:26:55.881Z |
5364459 | 5364459 | 20241023222826_bk8v5 | FR000V | 2024-10-25T12:17:21.205Z | 2024-11-01T12:26:55.084Z |
5364304 | 5364304 | 20241023221958_LpP07 | FR000V | 2024-10-25T12:17:16.035Z | 2024-11-01T12:26:54.663Z |
5364263 | 5364263 | 20241023221747_cLMyu | FR000V | 2024-10-25T12:17:14.222Z | 2024-11-01T12:26:54.626Z |
5364152 | 5364152 | 20241023220955_6JB4t | FR000V | 2024-10-25T12:17:10.719Z | 2024-11-01T12:26:54.563Z |
5363862 | 5363862 | 20241023215337_q3mO2 | FR000V | 2024-10-25T12:16:55.982Z | 2024-11-01T12:26:53.899Z |
5363794 | 5363794 | 20241023214436_VuZda | FR000V | 2024-10-25T12:16:46.404Z | 2024-11-01T12:26:53.635Z |
5363302 | 5363302 | 20241023204337_cABMI | FR000V | 2024-10-25T12:15:52.565Z | 2024-11-01T12:26:53.062Z |
5362971 | 5362971 | 20241023201445_T04A8 | FR000V | 2024-10-25T12:15:20.764Z | 2024-11-01T12:26:52.751Z |
5362677 | 5362677 | 20241023195344_nbPxX | FR000V | 2024-10-25T12:15:00.653Z | 2024-11-01T12:26:52.244Z |
5361379 | 5361379 | 20241023180950_6yk46 | FR000V | 2024-10-25T12:12:37.778Z | 2024-11-01T12:26:49.838Z |
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);