participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,960 rows where station_code = "BG000C" 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 |
---|---|---|---|---|---|
5565493 | 5565493 | 20241119000021_FfOgw | BG000C | 2024-11-21T14:20:29.611Z | 2024-11-21T14:20:29.611Z |
5557171 | 5557171 | 20241119041926_SkUh2 | BG000C | 2024-11-20T14:12:24.631Z | 2024-11-21T14:20:48.804Z |
5557156 | 5557156 | 20241119041214_3OmW2 | BG000C | 2024-11-20T14:12:22.948Z | 2024-11-21T14:20:48.536Z |
5557107 | 5557107 | 20241119035710_xBlgm | BG000C | 2024-11-20T14:12:18.153Z | 2024-11-21T14:20:46.624Z |
5557037 | 5557037 | 20241119033018_m5PdM | BG000C | 2024-11-20T14:12:03.411Z | 2024-11-21T14:20:44.220Z |
5557033 | 5557033 | 20241119033005_p5eUP | BG000C | 2024-11-20T14:12:03.010Z | 2024-11-21T14:20:44.151Z |
5557014 | 5557014 | 20241119032309_CSmWN | BG000C | 2024-11-20T14:12:00.111Z | 2024-11-21T14:20:43.250Z |
5557002 | 5557002 | 20241119032018_gDSN6 | BG000C | 2024-11-20T14:11:57.885Z | 2024-11-21T14:20:42.937Z |
5556774 | 5556774 | 20241119014819_1sLfF | BG000C | 2024-11-20T14:11:27.004Z | 2024-11-21T14:20:34.909Z |
5556539 | 5556539 | 20241118231722_RIAFZ | BG000C | 2024-11-20T14:10:41.906Z | 2024-11-21T14:20:27.390Z |
5556526 | 5556526 | 20241118225723_vj1P2 | BG000C | 2024-11-20T14:10:40.610Z | 2024-11-21T14:20:27.128Z |
5556508 | 5556508 | 20241118224549_mF5pN | BG000C | 2024-11-20T14:10:38.699Z | 2024-11-21T14:20:26.595Z |
5556484 | 5556484 | 20241118221815_CCcfW | BG000C | 2024-11-20T14:10:36.258Z | 2024-11-21T14:20:25.997Z |
5556471 | 5556471 | 20241118220434_cU3Vs | BG000C | 2024-11-20T14:10:34.610Z | 2024-11-21T14:20:25.568Z |
5556461 | 5556461 | 20241118215753_nLskY | BG000C | 2024-11-20T14:10:33.329Z | 2024-11-21T14:20:25.243Z |
5556456 | 5556456 | 20241118215647_23bDf | BG000C | 2024-11-20T14:10:33.060Z | 2024-11-21T14:20:25.038Z |
5556443 | 5556443 | 20241118214358_LihUG | BG000C | 2024-11-20T14:10:31.044Z | 2024-11-21T14:20:24.232Z |
5556434 | 5556434 | 20241118213004_c0co8 | BG000C | 2024-11-20T14:10:30.202Z | 2024-11-21T14:20:24.152Z |
5556422 | 5556422 | 20241118212011_l2792 | BG000C | 2024-11-20T14:10:28.196Z | 2024-11-21T14:20:23.940Z |
5556388 | 5556388 | 20241118203946_Bprth | BG000C | 2024-11-20T14:10:22.766Z | 2024-11-21T14:20:22.186Z |
5556382 | 5556382 | 20241118202647_YAfqu | BG000C | 2024-11-20T14:10:20.004Z | 2024-11-21T14:20:20.678Z |
5556346 | 5556346 | 20241118191937_jtxZ2 | BG000C | 2024-11-20T14:10:00.148Z | 2024-11-21T14:20:18.274Z |
5556331 | 5556331 | 20241118185722_fUSMI | BG000C | 2024-11-20T14:09:57.509Z | 2024-11-21T14:20:17.368Z |
5556327 | 5556327 | 20241118185117_3t9D2 | BG000C | 2024-11-20T14:09:56.699Z | 2024-11-21T14:20:17.066Z |
5556317 | 5556317 | 20241118183045_H6gRz | BG000C | 2024-11-20T14:09:53.153Z | 2024-11-21T14:20:16.323Z |
5556297 | 5556297 | 20241118181208_AtVKP | BG000C | 2024-11-20T14:09:49.189Z | 2024-11-21T14:20:15.336Z |
5556289 | 5556289 | 20241118174904_jbL60 | BG000C | 2024-11-20T14:09:47.419Z | 2024-11-21T14:20:13.898Z |
5556267 | 5556267 | 20241118172013_XsMqe | BG000C | 2024-11-20T14:09:42.421Z | 2024-11-21T14:20:11.551Z |
5553741 | 5553741 | 20241118040858_3KdP3 | BG000C | 2024-11-19T14:11:24.416Z | 2024-11-21T14:22:20.747Z |
5553722 | 5553722 | 20241118035859_iQTsI | BG000C | 2024-11-19T14:11:21.015Z | 2024-11-21T14:22:20.507Z |
5553719 | 5553719 | 20241118035829_jpb5X | BG000C | 2024-11-19T14:11:20.787Z | 2024-11-21T14:22:20.494Z |
5553704 | 5553704 | 20241118035416_WiGOA | BG000C | 2024-11-19T14:11:18.433Z | 2024-11-21T14:22:20.231Z |
5553608 | 5553608 | 20241118033122_KImyt | BG000C | 2024-11-19T14:11:04.212Z | 2024-11-21T14:22:17.873Z |
5553585 | 5553585 | 20241118032758_vOA2L | BG000C | 2024-11-19T14:10:58.771Z | 2024-11-21T14:22:17.148Z |
5553570 | 5553570 | 20241118032139_tjVp6 | BG000C | 2024-11-19T14:10:55.445Z | 2024-11-21T14:22:16.891Z |
5553515 | 5553515 | 20241118030507_53Rqx | BG000C | 2024-11-19T14:10:45.154Z | 2024-11-21T14:22:15.992Z |
5553439 | 5553439 | 20241118023818_A5gyH | BG000C | 2024-11-19T14:10:35.134Z | 2024-11-21T14:22:14.284Z |
5553403 | 5553403 | 20241118022138_Uiv51 | BG000C | 2024-11-19T14:10:28.880Z | 2024-11-21T14:22:13.557Z |
5553318 | 5553318 | 20241118020315_VfOdm | BG000C | 2024-11-19T14:10:17.756Z | 2024-11-21T14:22:11.609Z |
5553261 | 5553261 | 20241118015227_9MjqJ | BG000C | 2024-11-19T14:10:13.172Z | 2024-11-21T14:22:09.852Z |
5553248 | 5553248 | 20241118014930_b1N2J | BG000C | 2024-11-19T14:10:12.418Z | 2024-11-21T14:22:09.639Z |
5553185 | 5553185 | 20241118012907_FrlHp | BG000C | 2024-11-19T14:10:08.525Z | 2024-11-21T14:22:08.352Z |
5553165 | 5553165 | 20241118011201_njNcb | BG000C | 2024-11-19T14:10:07.331Z | 2024-11-21T14:22:08.199Z |
5553156 | 5553156 | 20241118010844_ciw6E | BG000C | 2024-11-19T14:10:06.784Z | 2024-11-21T14:22:08.166Z |
5553138 | 5553138 | 20241118005914_aDiI2 | BG000C | 2024-11-19T14:10:05.598Z | 2024-11-21T14:22:07.802Z |
5553086 | 5553086 | 20241118003920_DTsAz | BG000C | 2024-11-19T14:10:02.225Z | 2024-11-21T14:22:06.885Z |
5553069 | 5553069 | 20241118003621_SubgP | BG000C | 2024-11-19T14:10:01.260Z | 2024-11-21T14:22:06.539Z |
5553058 | 5553058 | 20241118003503_cM0sq | BG000C | 2024-11-19T14:10:00.511Z | 2024-11-21T14:22:06.441Z |
5553010 | 5553010 | 20241118001153_oYV4e | BG000C | 2024-11-19T14:09:56.591Z | 2024-11-21T14:22:05.808Z |
5552990 | 5552990 | 20241117235538_unleR | BG000C | 2024-11-19T14:09:55.140Z | 2024-11-21T14:22:05.411Z |
5552981 | 5552981 | 20241117235357_D3kIN | BG000C | 2024-11-19T14:09:54.686Z | 2024-11-21T14:22:05.376Z |
5510964 | 5510964 | 20241109040043_bnE5V | BG000C | 2024-11-10T14:15:59.615Z | 2024-11-17T14:24:02.953Z |
5510831 | 5510831 | 20241109034202_PxMEk | BG000C | 2024-11-10T14:15:45.474Z | 2024-11-17T14:24:01.684Z |
5510638 | 5510638 | 20241109031756_lMvQa | BG000C | 2024-11-10T14:15:31.066Z | 2024-11-17T14:23:59.894Z |
5510548 | 5510548 | 20241109025736_Rb2nF | BG000C | 2024-11-10T14:15:25.871Z | 2024-11-17T14:23:58.870Z |
5510475 | 5510475 | 20241109024504_v5ZYW | BG000C | 2024-11-10T14:15:19.888Z | 2024-11-17T14:23:58.118Z |
5510455 | 5510455 | 20241109024322_0hS2t | BG000C | 2024-11-10T14:15:17.339Z | 2024-11-17T14:23:57.935Z |
5510424 | 5510424 | 20241109023905_2DLyh | BG000C | 2024-11-10T14:15:12.720Z | 2024-11-17T14:23:57.366Z |
5510302 | 5510302 | 20241109021846_c1RlL | BG000C | 2024-11-10T14:14:58.787Z | 2024-11-17T14:23:55.720Z |
5510238 | 5510238 | 20241109020329_W7LQ3 | BG000C | 2024-11-10T14:14:50.806Z | 2024-11-17T14:23:54.463Z |
5510188 | 5510188 | 20241109015712_pJwho | BG000C | 2024-11-10T14:14:45.824Z | 2024-11-17T14:23:53.779Z |
5510043 | 5510043 | 20241109013324_c09wN | BG000C | 2024-11-10T14:14:30.057Z | 2024-11-17T14:23:52.328Z |
5509960 | 5509960 | 20241109011637_sKvBj | BG000C | 2024-11-10T14:14:19.650Z | 2024-11-17T14:23:51.393Z |
5509902 | 5509902 | 20241109010540_c84IV | BG000C | 2024-11-10T14:14:12.223Z | 2024-11-17T14:23:50.516Z |
5509817 | 5509817 | 20241109004609_v3NxP | BG000C | 2024-11-10T14:14:03.677Z | 2024-11-17T14:23:49.512Z |
5509776 | 5509776 | 20241109003239_XRJph | BG000C | 2024-11-10T14:13:59.788Z | 2024-11-17T14:23:48.979Z |
5509765 | 5509765 | 20241109003010_hqgOE | BG000C | 2024-11-10T14:13:58.280Z | 2024-11-17T14:23:48.959Z |
5509759 | 5509759 | 20241109002939_WC86p | BG000C | 2024-11-10T14:13:57.662Z | 2024-11-17T14:23:48.834Z |
5509705 | 5509705 | 20241109001529_T2MWn | BG000C | 2024-11-10T14:13:52.621Z | 2024-11-17T14:23:48.458Z |
5509703 | 5509703 | 20241109001512_jjd8M | BG000C | 2024-11-10T14:13:52.461Z | 2024-11-17T14:23:48.451Z |
5509493 | 5509493 | 20241108233229_BrwHO | BG000C | 2024-11-10T14:13:27.710Z | 2024-11-17T14:23:46.180Z |
5509359 | 5509359 | 20241108225618_gQBli | BG000C | 2024-11-10T14:13:15.589Z | 2024-11-17T14:23:43.528Z |
5509350 | 5509350 | 20241108225523_zLJDa | BG000C | 2024-11-10T14:13:14.836Z | 2024-11-17T14:23:43.461Z |
5509309 | 5509309 | 20241108225049_6ZcG7 | BG000C | 2024-11-10T14:13:11.541Z | 2024-11-17T14:23:43.015Z |
5509151 | 5509151 | 20241108220658_eKzNk | BG000C | 2024-11-10T14:12:45.236Z | 2024-11-17T14:23:41.010Z |
5509090 | 5509090 | 20241108214646_aOmbl | BG000C | 2024-11-10T14:12:32.329Z | 2024-11-17T14:23:40.201Z |
5509081 | 5509081 | 20241108214516_5NCNP | BG000C | 2024-11-10T14:12:29.454Z | 2024-11-17T14:23:40.111Z |
5509044 | 5509044 | 20241108213410_y6EV2 | BG000C | 2024-11-10T14:12:24.513Z | 2024-11-17T14:23:39.752Z |
5508874 | 5508874 | 20241108201453_vQcSM | BG000C | 2024-11-10T14:11:58.880Z | 2024-11-17T14:23:35.773Z |
5508789 | 5508789 | 20241108192532_apCYE | BG000C | 2024-11-10T14:11:49.074Z | 2024-11-17T14:23:33.732Z |
5508777 | 5508777 | 20241108191921_svxvI | BG000C | 2024-11-10T14:11:47.997Z | 2024-11-17T14:23:33.346Z |
5508733 | 5508733 | 20241108182821_HK82h | BG000C | 2024-11-10T14:11:29.392Z | 2024-11-17T14:23:31.443Z |
5508719 | 5508719 | 20241108181131_eJmFc | BG000C | 2024-11-10T14:11:23.151Z | 2024-11-17T14:23:31.018Z |
5508646 | 5508646 | 20241108165609_K70GF | BG000C | 2024-11-10T14:11:02.087Z | 2024-11-17T14:23:26.354Z |
5505036 | 5505036 | 20241108034112_bE22L | BG000C | 2024-11-09T14:15:37.575Z | 2024-11-16T14:28:25.817Z |
5505028 | 5505028 | 20241108033629_3tyDQ | BG000C | 2024-11-09T14:15:36.961Z | 2024-11-16T14:28:25.796Z |
5504830 | 5504830 | 20241108030343_yn1l3 | BG000C | 2024-11-09T14:15:14.442Z | 2024-11-16T14:28:23.748Z |
5504805 | 5504805 | 20241108030007_DNfNA | BG000C | 2024-11-09T14:15:12.385Z | 2024-11-16T14:28:23.586Z |
5504695 | 5504695 | 20241108024151_1P1EE | BG000C | 2024-11-09T14:15:04.401Z | 2024-11-16T14:28:22.490Z |
5504685 | 5504685 | 20241108024049_HtGDR | BG000C | 2024-11-09T14:15:04.138Z | 2024-11-16T14:28:22.440Z |
5504598 | 5504598 | 20241108022112_4uObt | BG000C | 2024-11-09T14:14:55.612Z | 2024-11-16T14:28:21.593Z |
5504595 | 5504595 | 20241108022107_KL720 | BG000C | 2024-11-09T14:14:55.552Z | 2024-11-16T14:28:21.582Z |
5504586 | 5504586 | 20241108021931_FGBZu | BG000C | 2024-11-09T14:14:54.118Z | 2024-11-16T14:28:21.546Z |
5504567 | 5504567 | 20241108021558_rEqMH | BG000C | 2024-11-09T14:14:51.716Z | 2024-11-16T14:28:21.465Z |
5504538 | 5504538 | 20241108021343_8GPTp | BG000C | 2024-11-09T14:14:49.494Z | 2024-11-16T14:28:21.288Z |
5504514 | 5504514 | 20241108020857_fNyRq | BG000C | 2024-11-09T14:14:46.901Z | 2024-11-16T14:28:21.065Z |
5504503 | 5504503 | 20241108020822_tAOft | BG000C | 2024-11-09T14:14:45.812Z | 2024-11-16T14:28:20.632Z |
5504427 | 5504427 | 20241108015641_rxv2M | BG000C | 2024-11-09T14:14:37.333Z | 2024-11-16T14:28:19.851Z |
5504335 | 5504335 | 20241108013909_jYxmo | BG000C | 2024-11-09T14:14:27.102Z | 2024-11-16T14:28:19.207Z |
5504316 | 5504316 | 20241108013432_t3dYi | BG000C | 2024-11-09T14:14:24.787Z | 2024-11-16T14:28:18.990Z |
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);