participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,850 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 |
---|---|---|---|---|---|
5431427 | 5431427 | 20241029011005_P4hcM | FR000V | 2024-10-31T12:20:07.858Z | 2024-11-03T14:25:10.461Z |
5431415 | 5431415 | 20241029010822_pbNJ0 | FR000V | 2024-10-31T12:20:06.488Z | 2024-11-03T14:25:10.111Z |
5431178 | 5431178 | 20241029003855_qtSKu | FR000V | 2024-10-31T12:19:43.440Z | 2024-11-03T14:25:08.200Z |
5430823 | 5430823 | 20241028234519_0Ugzw | FR000V | 2024-10-31T12:19:06.631Z | 2024-11-03T14:25:04.788Z |
5430814 | 5430814 | 20241028234322_DBpi7 | FR000V | 2024-10-31T12:19:05.469Z | 2024-11-03T14:25:04.708Z |
5430696 | 5430696 | 20241028232403_296mq | FR000V | 2024-10-31T12:18:53.053Z | 2024-11-03T14:25:03.262Z |
5430425 | 5430425 | 20241028223238_Ie7Ax | FR000V | 2024-10-31T12:18:22.008Z | 2024-11-03T14:25:01.165Z |
5430269 | 5430269 | 20241028215042_5Ukep | FR000V | 2024-10-31T12:18:00.488Z | 2024-11-03T14:25:00.721Z |
5428670 | 5428670 | 20241028175136_cfWed | FR000V | 2024-10-31T12:15:22.834Z | 2024-11-03T14:24:53.292Z |
5421051 | 5421051 | 20241028042349_8dHJR | FR000V | 2024-10-30T12:19:33.993Z | 2024-11-03T14:26:04.290Z |
5420986 | 5420986 | 20241028040911_HBpiD | FR000V | 2024-10-30T12:19:31.131Z | 2024-11-03T14:26:03.899Z |
5420709 | 5420709 | 20241028032503_L4GLY | FR000V | 2024-10-30T12:19:12.312Z | 2024-11-03T14:26:02.953Z |
5420639 | 5420639 | 20241028031049_YAUlW | FR000V | 2024-10-30T12:19:06.619Z | 2024-11-03T14:26:02.693Z |
5420146 | 5420146 | 20241028020419_eVmI2 | FR000V | 2024-10-30T12:18:25.126Z | 2024-11-03T14:26:01.152Z |
5419825 | 5419825 | 20241028011519_adV5j | FR000V | 2024-10-30T12:17:55.395Z | 2024-11-03T14:26:00.170Z |
5419664 | 5419664 | 20241028004134_6dEY7 | FR000V | 2024-10-30T12:17:42.413Z | 2024-11-03T14:25:59.767Z |
5419532 | 5419532 | 20241028001514_X3hcd | FR000V | 2024-10-30T12:17:32.066Z | 2024-11-03T14:25:59.167Z |
5419326 | 5419326 | 20241027233806_DPdJV | FR000V | 2024-10-30T12:17:20.606Z | 2024-11-03T14:25:58.068Z |
5419064 | 5419064 | 20241027225407_qkSCe | FR000V | 2024-10-30T12:17:02.049Z | 2024-11-03T14:25:56.471Z |
5418851 | 5418851 | 20241027221033_l8rCo | FR000V | 2024-10-30T12:16:23.323Z | 2024-11-03T14:25:55.130Z |
5418772 | 5418772 | 20241027215429_2ftBs | FR000V | 2024-10-30T12:16:09.255Z | 2024-11-03T14:25:54.783Z |
5418118 | 5418118 | 20241027195637_IyrLP | FR000V | 2024-10-30T12:14:56.194Z | 2024-11-03T14:25:49.718Z |
5417951 | 5417951 | 20241027193430_TFvRA | FR000V | 2024-10-30T12:14:39.702Z | 2024-11-03T14:25:48.201Z |
5417267 | 5417267 | 20241027180715_a7g0j | FR000V | 2024-10-30T12:13:26.847Z | 2024-11-03T14:25:44.504Z |
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 |
5131851 | 5131851 | 20240915214544_MExkj | FR000V | 2024-09-19T12:15:30.120Z | 2024-09-24T12:15:38.307Z |
5112767 | 5112767 | 20240914235234_rzWgt | FR000V | 2024-09-18T12:03:29.895Z | 2024-09-23T12:16:05.673Z |
5111917 | 5111917 | 20240914214129_KAenb | FR000V | 2024-09-18T12:02:30.838Z | 2024-09-23T12:16:01.232Z |
5103470 | 5103470 | 20240913013107_ngaL2 | FR000V | 2024-09-17T12:10:58.727Z | 2024-09-21T12:16:25.085Z |
5103321 | 5103321 | 20240913012505_pQjFO | FR000V | 2024-09-17T12:10:50.587Z | 2024-09-21T12:16:24.735Z |
5102888 | 5102888 | 20240914015153_MJM8w | FR000V | 2024-09-17T12:07:41.909Z | 2024-09-22T12:17:54.167Z |
5102771 | 5102771 | 20240914014257_oVkyx | FR000V | 2024-09-17T12:07:35.560Z | 2024-09-22T12:17:53.906Z |
5102547 | 5102547 | 20240914013051_3Tp2B | FR000V | 2024-09-17T12:07:20.817Z | 2024-09-22T12:17:53.569Z |
5102458 | 5102458 | 20240914012657_3GSI3 | FR000V | 2024-09-17T12:07:13.967Z | 2024-09-22T12:17:53.450Z |
5102033 | 5102033 | 20240914010202_m5uWz | FR000V | 2024-09-17T12:06:43.218Z | 2024-09-22T12:17:52.474Z |
5100573 | 5100573 | 20240913233115_hUKkU | FR000V | 2024-09-17T12:04:39.265Z | 2024-09-22T12:17:49.843Z |
5099052 | 5099052 | 20240913201615_saO2R | FR000V | 2024-09-17T12:02:14.958Z | 2024-09-22T12:17:45.816Z |
5097997 | 5097997 | 20240913011159_li2Mz | FR000V | 2024-09-16T12:17:17.950Z | 2024-09-21T12:16:23.490Z |
5074732 | 5074732 | 20240911225927_89yOF | FR000V | 2024-09-15T12:08:47.213Z | 2024-09-20T12:21:36.850Z |
5046612 | 5046612 | 20240909002518_JUB12 | FR000V | 2024-09-13T12:07:07.283Z | 2024-09-17T12:18:59.617Z |
5046578 | 5046578 | 20240909001524_BsJM8 | FR000V | 2024-09-13T12:06:58.209Z | 2024-09-17T12:18:59.576Z |
5046564 | 5046564 | 20240909001334_pi3P2 | FR000V | 2024-09-13T12:06:57.001Z | 2024-09-17T12:18:59.528Z |
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);