participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
8,608 rows where station_code = "FR000Y" 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 |
---|---|---|---|---|---|
5454779 | 5454779 | 20241031051341_2Pdb2 | FR000Y | 2024-11-02T12:23:22.520Z | 2024-11-03T14:23:20.943Z |
5454539 | 5454539 | 20241031043631_NJ2PZ | FR000Y | 2024-11-02T12:23:10.930Z | 2024-11-03T14:23:19.365Z |
5454507 | 5454507 | 20241031043120_CJSo7 | FR000Y | 2024-11-02T12:23:08.949Z | 2024-11-03T14:23:19.041Z |
5454483 | 5454483 | 20241031042817_nn7rW | FR000Y | 2024-11-02T12:23:07.212Z | 2024-11-03T14:23:18.674Z |
5454478 | 5454478 | 20241031042752_42xBI | FR000Y | 2024-11-02T12:23:07.137Z | 2024-11-03T14:23:18.604Z |
5454457 | 5454457 | 20241031042520_CQq2h | FR000Y | 2024-11-02T12:23:06.480Z | 2024-11-03T14:23:18.510Z |
5454267 | 5454267 | 20241031040415_qXBCD | FR000Y | 2024-11-02T12:22:57.287Z | 2024-11-03T14:23:16.105Z |
5454175 | 5454175 | 20241031035052_Ai2U1 | FR000Y | 2024-11-02T12:22:53.452Z | 2024-11-03T14:23:14.867Z |
5454173 | 5454173 | 20241031035044_IZsBA | FR000Y | 2024-11-02T12:22:53.308Z | 2024-11-03T14:23:14.744Z |
5454120 | 5454120 | 20241031034419_KMgGK | FR000Y | 2024-11-02T12:22:51.437Z | 2024-11-03T14:23:14.086Z |
5454060 | 5454060 | 20241031033716_pL4QT | FR000Y | 2024-11-02T12:22:49.817Z | 2024-11-03T14:23:13.341Z |
5453891 | 5453891 | 20241031031256_RL5co | FR000Y | 2024-11-02T12:22:44.364Z | 2024-11-03T14:23:10.960Z |
5453868 | 5453868 | 20241031031047_DJdkA | FR000Y | 2024-11-02T12:22:43.927Z | 2024-11-03T14:23:10.633Z |
5453864 | 5453864 | 20241031031022_Xl7fs | FR000Y | 2024-11-02T12:22:43.907Z | 2024-11-03T14:23:10.556Z |
5453786 | 5453786 | 20241031025916_WxV03 | FR000Y | 2024-11-02T12:22:42.594Z | 2024-11-03T14:23:09.642Z |
5453740 | 5453740 | 20241031025414_4xVSW | FR000Y | 2024-11-02T12:22:41.511Z | 2024-11-03T14:23:09.221Z |
5453664 | 5453664 | 20241031024030_jfaeV | FR000Y | 2024-11-02T12:22:39.107Z | 2024-11-03T14:23:08.346Z |
5453545 | 5453545 | 20241031022201_S2hxf | FR000Y | 2024-11-02T12:22:35.742Z | 2024-11-03T14:23:06.696Z |
5453516 | 5453516 | 20241031021752_RlgPH | FR000Y | 2024-11-02T12:22:34.987Z | 2024-11-03T14:23:05.712Z |
5453471 | 5453471 | 20241031021454_QtYYM | FR000Y | 2024-11-02T12:22:34.317Z | 2024-11-03T14:23:05.337Z |
5444398 | 5444398 | 20241031011558_VdAKj | FR000Y | 2024-11-01T12:21:15.619Z | 2024-11-03T14:23:00.889Z |
5444217 | 5444217 | 20241031005954_G8bx6 | FR000Y | 2024-11-01T12:21:10.373Z | 2024-11-03T14:22:59.050Z |
5444112 | 5444112 | 20241031004832_3IOHh | FR000Y | 2024-11-01T12:21:06.416Z | 2024-11-03T14:22:58.507Z |
5443748 | 5443748 | 20241031001050_9HbhA | FR000Y | 2024-11-01T12:20:48.400Z | 2024-11-03T14:22:55.879Z |
5443640 | 5443640 | 20241030235809_q619E | FR000Y | 2024-11-01T12:20:43.369Z | 2024-11-03T14:22:55.497Z |
5440895 | 5440895 | 20241030231947_ZstDw | FR000Y | 2024-11-01T12:15:58.042Z | 2024-11-03T14:22:54.636Z |
5440818 | 5440818 | 20241030231053_9Z3Qj | FR000Y | 2024-11-01T12:15:52.747Z | 2024-11-03T14:22:54.352Z |
5440676 | 5440676 | 20241030224553_rLfSo | FR000Y | 2024-11-01T12:15:43.514Z | 2024-11-03T14:22:53.800Z |
5440624 | 5440624 | 20241030223639_MGJdv | FR000Y | 2024-11-01T12:15:39.841Z | 2024-11-03T14:22:53.596Z |
5440518 | 5440518 | 20241030222247_Yf3y5 | FR000Y | 2024-11-01T12:15:34.351Z | 2024-11-03T14:22:53.191Z |
5440516 | 5440516 | 20241030222227_aIyUw | FR000Y | 2024-11-01T12:15:34.174Z | 2024-11-03T14:22:53.177Z |
5440424 | 5440424 | 20241030220951_YxfFl | FR000Y | 2024-11-01T12:15:30.037Z | 2024-11-03T14:22:52.925Z |
5440380 | 5440380 | 20241030220452_fiNFy | FR000Y | 2024-11-01T12:15:27.825Z | 2024-11-03T14:22:52.751Z |
5440374 | 5440374 | 20241030220348_xoUwX | FR000Y | 2024-11-01T12:15:27.367Z | 2024-11-03T14:22:52.709Z |
5440227 | 5440227 | 20241030214445_PwJEJ | FR000Y | 2024-11-01T12:15:02.314Z | 2024-11-03T14:22:51.969Z |
5440150 | 5440150 | 20241030213034_CYD6Z | FR000Y | 2024-11-01T12:14:54.314Z | 2024-11-03T14:22:51.581Z |
5440032 | 5440032 | 20241030211348_0amnl | FR000Y | 2024-11-01T12:14:46.101Z | 2024-11-03T14:22:50.997Z |
5439970 | 5439970 | 20241030205849_36Lsl | FR000Y | 2024-11-01T12:14:41.641Z | 2024-11-03T14:22:50.644Z |
5439856 | 5439856 | 20241030203855_m83BN | FR000Y | 2024-11-01T12:14:33.824Z | 2024-11-03T14:22:50.088Z |
5439549 | 5439549 | 20241030200602_5OmIP | FR000Y | 2024-11-01T12:13:58.439Z | 2024-11-03T14:22:48.600Z |
5439298 | 5439298 | 20241030193921_kpote | FR000Y | 2024-11-01T12:13:34.032Z | 2024-11-03T14:22:46.919Z |
5439290 | 5439290 | 20241030193846_4gf1q | FR000Y | 2024-11-01T12:13:32.703Z | 2024-11-03T14:22:46.889Z |
5439264 | 5439264 | 20241030193509_aoQE3 | FR000Y | 2024-11-01T12:13:24.744Z | 2024-11-03T14:22:46.713Z |
5439095 | 5439095 | 20241030185749_a1ZbL | FR000Y | 2024-11-01T12:13:07.093Z | 2024-11-03T14:22:46.027Z |
5438923 | 5438923 | 20241030183057_PdiWX | FR000Y | 2024-11-01T12:12:44.580Z | 2024-11-03T14:22:44.938Z |
5438903 | 5438903 | 20241030182637_4bSho | FR000Y | 2024-11-01T12:12:38.065Z | 2024-11-03T14:22:44.838Z |
5433516 | 5433516 | 20241029201252_Rar6T | FR000Y | 2024-10-31T12:22:19.328Z | 2024-11-03T14:23:56.036Z |
5419537 | 5419537 | 20241028001522_QtqCP | FR000Y | 2024-10-30T12:17:32.378Z | 2024-11-03T14:25:59.278Z |
5419529 | 5419529 | 20241028001430_k0FXH | FR000Y | 2024-10-30T12:17:32.014Z | 2024-11-03T14:25:59.157Z |
5419486 | 5419486 | 20241028000851_52b11 | FR000Y | 2024-10-30T12:17:29.769Z | 2024-11-03T14:25:58.895Z |
5418556 | 5418556 | 20241027211028_S494b | FR000Y | 2024-10-30T12:15:49.675Z | 2024-11-03T14:25:53.602Z |
5418514 | 5418514 | 20241027210254_arER8 | FR000Y | 2024-10-30T12:15:46.878Z | 2024-11-03T14:25:52.262Z |
5418478 | 5418478 | 20241027205457_V4C0w | FR000Y | 2024-10-30T12:15:43.758Z | 2024-11-03T14:25:51.820Z |
5418367 | 5418367 | 20241027203047_CLDH0 | FR000Y | 2024-10-30T12:15:36.042Z | 2024-11-03T14:25:51.190Z |
5418354 | 5418354 | 20241027202857_lFQhp | FR000Y | 2024-10-30T12:15:34.884Z | 2024-11-03T14:25:51.136Z |
5418102 | 5418102 | 20241027195509_8WBVB | FR000Y | 2024-10-30T12:14:53.028Z | 2024-11-03T14:25:49.173Z |
5417982 | 5417982 | 20241027193632_8dZt1 | FR000Y | 2024-10-30T12:14:42.140Z | 2024-11-03T14:25:48.284Z |
5417851 | 5417851 | 20241027192147_IbekQ | FR000Y | 2024-10-30T12:14:32.685Z | 2024-11-03T14:25:47.354Z |
5417832 | 5417832 | 20241027192027_HnzWv | FR000Y | 2024-10-30T12:14:30.894Z | 2024-11-03T14:25:46.758Z |
5417668 | 5417668 | 20241027185937_5euCc | FR000Y | 2024-10-30T12:14:09.444Z | 2024-11-03T14:25:45.853Z |
5417640 | 5417640 | 20241027185629_Yrwjd | FR000Y | 2024-10-30T12:14:04.516Z | 2024-11-03T14:25:45.755Z |
5417584 | 5417584 | 20241027184905_3aaZL | FR000Y | 2024-10-30T12:13:54.253Z | 2024-11-03T14:25:45.594Z |
5417508 | 5417508 | 20241027183943_ylq5w | FR000Y | 2024-10-30T12:13:45.496Z | 2024-11-03T14:25:45.315Z |
5417275 | 5417275 | 20241027180842_KPhXn | FR000Y | 2024-10-30T12:13:27.588Z | 2024-11-03T14:25:44.537Z |
5417246 | 5417246 | 20241027180043_RyLTB | FR000Y | 2024-10-30T12:13:24.735Z | 2024-11-03T14:25:44.427Z |
5404840 | 5404840 | 20241026235601_UVSXb | FR000Y | 2024-10-29T12:12:01.370Z | 2024-11-03T14:26:40.847Z |
5402776 | 5402776 | 20241026202414_ZIg9Q | FR000Y | 2024-10-29T12:08:07.606Z | 2024-11-03T14:26:28.196Z |
5402772 | 5402772 | 20241026202345_T8JxY | FR000Y | 2024-10-29T12:08:07.344Z | 2024-11-03T14:26:28.163Z |
5402570 | 5402570 | 20241026195733_J1tfb | FR000Y | 2024-10-29T12:07:43.561Z | 2024-11-03T14:26:26.433Z |
5402547 | 5402547 | 20241026195416_pJH22 | FR000Y | 2024-10-29T12:07:38.734Z | 2024-11-03T14:26:26.301Z |
5401981 | 5401981 | 20241026181540_pX23N | FR000Y | 2024-10-29T12:05:58.016Z | 2024-11-03T14:26:20.551Z |
5401939 | 5401939 | 20241026181003_42Ivg | FR000Y | 2024-10-29T12:05:52.606Z | 2024-11-03T14:26:20.289Z |
5401836 | 5401836 | 20241026174326_391VQ | FR000Y | 2024-10-29T12:05:27.667Z | 2024-11-03T14:26:19.235Z |
5399484 | 5399484 | 20241026042701_EeRyd | FR000Y | 2024-10-28T12:20:00.534Z | 2024-11-03T14:27:39.843Z |
5399440 | 5399440 | 20241026041827_PPgTd | FR000Y | 2024-10-28T12:19:59.474Z | 2024-11-03T14:27:39.720Z |
5399382 | 5399382 | 20241026041422_ifhAr | FR000Y | 2024-10-28T12:19:57.602Z | 2024-11-03T14:27:39.579Z |
5399362 | 5399362 | 20241026041333_y3UGN | FR000Y | 2024-10-28T12:19:55.728Z | 2024-11-03T14:27:39.538Z |
5399336 | 5399336 | 20241026041113_jMiFM | FR000Y | 2024-10-28T12:19:55.103Z | 2024-11-03T14:27:39.491Z |
5399259 | 5399259 | 20241026040559_CdqMb | FR000Y | 2024-10-28T12:19:52.641Z | 2024-11-03T14:27:39.286Z |
5399233 | 5399233 | 20241026040352_CSfDU | FR000Y | 2024-10-28T12:19:52.261Z | 2024-11-03T14:27:39.273Z |
5399178 | 5399178 | 20241026035839_vKCd4 | FR000Y | 2024-10-28T12:19:50.650Z | 2024-11-03T14:27:39.188Z |
5399088 | 5399088 | 20241026034935_lugbq | FR000Y | 2024-10-28T12:19:48.200Z | 2024-11-03T14:27:39.011Z |
5399030 | 5399030 | 20241026034531_DZJak | FR000Y | 2024-10-28T12:19:44.858Z | 2024-11-03T14:27:38.909Z |
5398985 | 5398985 | 20241026034316_3UsjC | FR000Y | 2024-10-28T12:19:43.394Z | 2024-11-03T14:27:38.812Z |
5398885 | 5398885 | 20241026033500_GYsRJ | FR000Y | 2024-10-28T12:19:38.910Z | 2024-11-03T14:27:38.350Z |
5398607 | 5398607 | 20241026031109_GGP0D | FR000Y | 2024-10-28T12:19:23.747Z | 2024-11-03T14:27:36.919Z |
5398576 | 5398576 | 20241026030922_ljD2A | FR000Y | 2024-10-28T12:19:22.791Z | 2024-11-03T14:27:36.835Z |
5398574 | 5398574 | 20241026030900_zl64D | FR000Y | 2024-10-28T12:19:22.646Z | 2024-11-03T14:27:36.821Z |
5398520 | 5398520 | 20241026030522_Mwg6D | FR000Y | 2024-10-28T12:19:20.765Z | 2024-11-03T14:27:36.688Z |
5398349 | 5398349 | 20241026024726_7WVer | FR000Y | 2024-10-28T12:19:11.638Z | 2024-11-03T14:27:35.929Z |
5398324 | 5398324 | 20241026024422_xsIQ0 | FR000Y | 2024-10-28T12:19:10.659Z | 2024-11-03T14:27:35.894Z |
5398317 | 5398317 | 20241026024422_J9KFR | FR000Y | 2024-10-28T12:19:10.596Z | 2024-11-03T14:27:35.889Z |
5398291 | 5398291 | 20241026024225_m75gC | FR000Y | 2024-10-28T12:19:09.697Z | 2024-11-03T14:27:35.862Z |
5398169 | 5398169 | 20241026023111_wYlWB | FR000Y | 2024-10-28T12:19:03.506Z | 2024-11-03T14:27:35.612Z |
5398125 | 5398125 | 20241026022742_EQc1Q | FR000Y | 2024-10-28T12:19:01.496Z | 2024-11-03T14:27:35.517Z |
5398121 | 5398121 | 20241026022741_YjtkI | FR000Y | 2024-10-28T12:19:01.455Z | 2024-11-03T14:27:35.463Z |
5397969 | 5397969 | 20241026021058_VaxOP | FR000Y | 2024-10-28T12:18:52.753Z | 2024-11-03T14:27:34.702Z |
5397051 | 5397051 | 20241026005911_JY7I7 | FR000Y | 2024-10-28T12:18:04.419Z | 2024-11-03T14:27:31.952Z |
5396954 | 5396954 | 20241026004914_Ht5vh | FR000Y | 2024-10-28T12:18:00.563Z | 2024-11-03T14:27:31.528Z |
5396947 | 5396947 | 20241026004852_KXgJj | FR000Y | 2024-10-28T12:18:00.388Z | 2024-11-03T14:27:31.521Z |
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);