participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,595 rows where station_code = "UK0029" 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 |
---|---|---|---|---|---|
5583425 | 5583425 | 20241119201721_npjEP | UK0029 | 2024-11-23T14:24:23.069Z | 2024-11-24T14:24:25.919Z |
5578290 | 5578290 | 20241121192210_jfjKP | UK0029 | 2024-11-23T14:16:43.881Z | 2024-11-24T14:22:19.667Z |
5570635 | 5570635 | 20241120203251_2IUdo | UK0029 | 2024-11-22T14:15:57.910Z | 2024-11-24T14:23:35.827Z |
5563639 | 5563639 | 20241120015409_NDtD6 | UK0029 | 2024-11-21T14:16:31.285Z | 2024-11-24T14:24:38.502Z |
5563041 | 5563041 | 20241120004451_7pxI9 | UK0029 | 2024-11-21T14:15:32.581Z | 2024-11-24T14:24:35.817Z |
5561281 | 5561281 | 20241119193226_pPeru | UK0029 | 2024-11-21T14:12:58.899Z | 2024-11-24T14:24:24.042Z |
5561091 | 5561091 | 20241119180801_Om49e | UK0029 | 2024-11-21T14:12:22.224Z | 2024-11-24T14:24:21.222Z |
5552598 | 5552598 | 20241117190908_k2bam | UK0029 | 2024-11-19T14:08:44.191Z | 2024-11-24T14:25:19.130Z |
5538544 | 5538544 | 20241113040727_f2fYo | UK0029 | 2024-11-14T14:13:36.827Z | 2024-11-21T14:26:27.060Z |
5529220 | 5529220 | 20241111234838_3Mu6I | UK0029 | 2024-11-13T14:12:14.263Z | 2024-11-20T14:25:41.926Z |
5528813 | 5528813 | 20241111224205_yvySE | UK0029 | 2024-11-13T14:11:27.583Z | 2024-11-20T14:25:36.160Z |
5515856 | 5515856 | 20241109225832_TcS92 | UK0029 | 2024-11-11T14:11:38.422Z | 2024-11-18T14:26:28.234Z |
5410471 | 5410471 | 20241027051429_eGK76 | UK0029 | 2024-10-29T12:17:56.612Z | 2024-11-04T14:29:04.636Z |
5410172 | 5410172 | 20241027045834_ZwIQq | UK0029 | 2024-10-29T12:17:49.836Z | 2024-11-04T14:29:03.984Z |
5397031 | 5397031 | 20241026005816_yfAYA | UK0029 | 2024-10-28T12:18:04.160Z | 2024-11-03T14:27:31.936Z |
5396667 | 5396667 | 20241026002020_S1FQJ | UK0029 | 2024-10-28T12:17:52.461Z | 2024-11-03T14:27:30.575Z |
5377811 | 5377811 | 20241024051209_z1LwV | UK0029 | 2024-10-26T12:22:47.546Z | 2024-11-01T12:27:03.075Z |
5377588 | 5377588 | 20241024045819_DjBC3 | UK0029 | 2024-10-26T12:22:41.260Z | 2024-11-01T12:27:02.617Z |
5365918 | 5365918 | 20241023235643_G4lXf | UK0029 | 2024-10-25T12:18:10.449Z | 2024-11-01T12:26:56.488Z |
5365890 | 5365890 | 20241023235514_4Xczn | UK0029 | 2024-10-25T12:18:09.865Z | 2024-11-01T12:26:56.478Z |
5355914 | 5355914 | 20241023043658_GNvYw | UK0029 | 2024-10-24T12:21:42.115Z | 2024-10-31T12:30:09.204Z |
5355880 | 5355880 | 20241023043253_n6Bk4 | UK0029 | 2024-10-24T12:21:41.140Z | 2024-10-31T12:30:09.146Z |
5349907 | 5349907 | 20241022204829_Cz8KH | UK0029 | 2024-10-24T12:14:47.461Z | 2024-10-31T12:29:56.898Z |
5339340 | 5339340 | 20241021222408_ngpFK | UK0029 | 2024-10-23T12:13:00.944Z | 2024-10-30T12:26:44.045Z |
5326450 | 5326450 | 20241019183236_lzOQU | UK0029 | 2024-10-21T12:09:26.835Z | 2024-10-28T12:26:41.698Z |
5321295 | 5321295 | 20241018042702_IhBB4 | UK0029 | 2024-10-19T12:07:09.738Z | 2024-10-26T12:27:56.453Z |
5321138 | 5321138 | 20241018035437_dNvuT | UK0029 | 2024-10-19T12:06:53.922Z | 2024-10-26T12:27:56.218Z |
5320490 | 5320490 | 20241018015043_H2zkL | UK0029 | 2024-10-19T12:05:30.393Z | 2024-10-26T12:27:54.698Z |
5320487 | 5320487 | 20241018015013_f2BLg | UK0029 | 2024-10-19T12:05:30.039Z | 2024-10-26T12:27:54.696Z |
5318676 | 5318676 | 20241017043641_iFJen | UK0029 | 2024-10-18T12:04:16.724Z | 2024-10-25T12:24:36.546Z |
5318454 | 5318454 | 20241017032922_NtvEm | UK0029 | 2024-10-18T12:03:49.891Z | 2024-10-25T12:24:35.629Z |
5318373 | 5318373 | 20241017025345_6FZ8C | UK0029 | 2024-10-18T12:03:40.774Z | 2024-10-25T12:24:35.012Z |
5303796 | 5303796 | 20241013033312_qhOD0 | UK0029 | 2024-10-14T12:17:34.490Z | 2024-10-21T12:24:20.458Z |
5303609 | 5303609 | 20241013031759_IUMsM | UK0029 | 2024-10-14T12:17:30.040Z | 2024-10-21T12:24:18.911Z |
5301282 | 5301282 | 20241012230204_20Wl2 | UK0029 | 2024-10-14T12:15:14.403Z | 2024-10-21T12:23:57.287Z |
5284202 | 5284202 | 20241011022809_bnTcw | UK0029 | 2024-10-12T12:17:12.571Z | 2024-10-19T12:27:54.451Z |
5282741 | 5282741 | 20241010232230_Okw2y | UK0029 | 2024-10-12T12:16:00.778Z | 2024-10-19T12:27:46.024Z |
5282387 | 5282387 | 20241010213425_cX9oq | UK0029 | 2024-10-12T12:15:30.748Z | 2024-10-19T12:27:43.621Z |
5263035 | 5263035 | 20241008025819_19KTp | UK0029 | 2024-10-09T12:16:36.302Z | 2024-10-16T12:21:21.232Z |
5253234 | 5253234 | 20241006231450_CaNqd | UK0029 | 2024-10-08T12:13:03.125Z | 2024-10-15T12:29:08.013Z |
5252901 | 5252901 | 20241006220049_KoKWq | UK0029 | 2024-10-08T12:12:45.861Z | 2024-10-15T12:29:05.439Z |
5239830 | 5239830 | 20241005043102_VWTlq | UK0029 | 2024-10-07T12:07:13.374Z | 2024-10-14T12:24:20.790Z |
5239640 | 5239640 | 20241005041607_TUO2p | UK0029 | 2024-10-07T12:06:55.231Z | 2024-10-14T12:24:20.470Z |
5238282 | 5238282 | 20241005022021_ncNsQ | UK0029 | 2024-10-07T12:04:02.812Z | 2024-10-14T12:24:15.951Z |
5226055 | 5226055 | 20241003233946_4f3oL | UK0029 | 2024-10-05T12:20:25.334Z | 2024-10-12T12:25:11.152Z |
5223779 | 5223779 | 20241003193046_432zm | UK0029 | 2024-10-05T12:17:34.173Z | 2024-10-12T12:25:06.991Z |
5220143 | 5220143 | 20241003044915_rPGbg | UK0029 | 2024-10-05T12:10:19.049Z | 2024-10-12T12:24:56.869Z |
5219748 | 5219748 | 20241003041542_FuDTX | UK0029 | 2024-10-05T12:09:33.429Z | 2024-10-12T12:24:56.287Z |
5216686 | 5216686 | 20241003011632_NiqGG | UK0029 | 2024-10-04T12:13:42.129Z | 2024-10-11T12:23:37.678Z |
5215212 | 5215212 | 20241002230831_g0d6z | UK0029 | 2024-10-04T12:11:36.154Z | 2024-10-11T12:23:35.081Z |
5181330 | 5181330 | 20240927203746_q9cpu | UK0029 | 2024-09-29T12:14:56.634Z | 2024-10-05T12:29:05.601Z |
5181094 | 5181094 | 20240927200633_003b7 | UK0029 | 2024-09-29T12:14:35.166Z | 2024-10-05T12:29:04.602Z |
5128404 | 5128404 | 20240917013727_9HVvq | UK0029 | 2024-09-19T12:10:31.507Z | 2024-09-25T12:22:24.855Z |
5103441 | 5103441 | 20240913013054_BCgK8 | UK0029 | 2024-09-17T12:10:57.980Z | 2024-09-21T12:16:25.027Z |
5103434 | 5103434 | 20240913013054_M5szK | UK0029 | 2024-09-17T12:10:57.765Z | 2024-09-21T12:16:25.009Z |
5097600 | 5097600 | 20240913005648_SR4Vi | UK0029 | 2024-09-16T12:17:13.628Z | 2024-09-21T12:16:21.722Z |
5094909 | 5094909 | 20240912043619_Ir2lF | UK0029 | 2024-09-16T12:15:01.105Z | 2024-09-20T12:21:56.262Z |
5094606 | 5094606 | 20240912041229_dzmcA | UK0029 | 2024-09-16T12:14:52.549Z | 2024-09-20T12:21:55.614Z |
5093364 | 5093364 | 20240912031937_Gkdyr | UK0029 | 2024-09-16T12:14:16.120Z | 2024-09-20T12:21:53.382Z |
5093210 | 5093210 | 20240912031506_uvmvL | UK0029 | 2024-09-16T12:14:13.426Z | 2024-09-20T12:21:53.028Z |
5092240 | 5092240 | 20240912024037_46Lfm | UK0029 | 2024-09-16T12:13:44.479Z | 2024-09-20T12:21:49.966Z |
5090849 | 5090849 | 20240912014933_XtidC | UK0029 | 2024-09-16T12:12:39.076Z | 2024-09-20T12:21:45.923Z |
5089811 | 5089811 | 20240912005830_p3oDi | UK0029 | 2024-09-16T12:11:45.014Z | 2024-09-20T12:21:43.761Z |
5089354 | 5089354 | 20240912003806_JMi9o | UK0029 | 2024-09-16T12:11:21.687Z | 2024-09-20T12:21:41.975Z |
5088633 | 5088633 | 20240913002024_Uqddr | UK0029 | 2024-09-16T12:08:18.052Z | 2024-09-21T12:16:18.752Z |
5087797 | 5087797 | 20240912234445_WPLRd | UK0029 | 2024-09-16T12:07:28.275Z | 2024-09-21T12:16:16.533Z |
5077341 | 5077341 | 20240911004526_clOcq | UK0029 | 2024-09-15T12:14:39.285Z | 2024-09-19T12:21:38.683Z |
5076032 | 5076032 | 20240910230608_3jia2 | UK0029 | 2024-09-15T12:13:16.615Z | 2024-09-19T12:21:36.394Z |
5074290 | 5074290 | 20240911222852_On0H3 | UK0029 | 2024-09-15T12:08:19.142Z | 2024-09-20T12:21:35.727Z |
5074119 | 5074119 | 20240911221710_JJiv3 | UK0029 | 2024-09-15T12:08:00.555Z | 2024-09-20T12:21:35.396Z |
5070346 | 5070346 | 20240910225155_Yn9P4 | UK0029 | 2024-09-14T12:20:19.531Z | 2024-09-19T12:21:36.025Z |
5019758 | 5019758 | 20240904234654_NhZup | UK0029 | 2024-09-10T12:13:25.246Z | 2024-09-13T12:19:53.718Z |
5010942 | 5010942 | 20240904040308_7gL1F | UK0029 | 2024-09-09T12:09:12.665Z | 2024-09-12T12:19:29.742Z |
4955030 | 4955030 | 20240811032523_cT79I | UK0029 | 2024-09-03T12:18:36.151Z | 2024-09-06T12:29:15.418Z |
4954914 | 4954914 | 20240811031621_fM7Oi | UK0029 | 2024-09-03T12:18:25.707Z | 2024-09-06T12:29:11.651Z |
4954657 | 4954657 | 20240811030754_WyBa3 | UK0029 | 2024-09-03T12:18:18.787Z | 2024-09-06T12:29:06.061Z |
4953621 | 4953621 | 20240811024208_YeZLo | UK0029 | 2024-09-03T12:17:51.890Z | 2024-09-06T12:28:33.176Z |
4921035 | 4921035 | 20240810004357_tgz3H | UK0029 | 2024-08-30T12:13:49.102Z | 2024-09-02T12:26:46.972Z |
4903681 | 4903681 | 20240808030926_jpU6k | UK0029 | 2024-08-28T12:19:45.917Z | 2024-08-28T12:19:45.917Z |
4903182 | 4903182 | 20240808024430_XmUaQ | UK0029 | 2024-08-28T12:19:31.544Z | 2024-08-28T12:19:31.544Z |
4903024 | 4903024 | 20240808023756_2ZJZg | UK0029 | 2024-08-28T12:19:28.280Z | 2024-08-28T12:19:28.280Z |
4901653 | 4901653 | 20240808014209_YZQUn | UK0029 | 2024-08-28T12:18:48.449Z | 2024-08-28T12:18:48.449Z |
4884217 | 4884217 | 20240807030533_IRMpU | UK0029 | 2024-08-20T12:15:26.105Z | 2024-08-27T12:16:08.447Z |
4879724 | 4879724 | 20240807010205_mSWcd | UK0029 | 2024-08-20T12:13:00.350Z | 2024-08-27T12:14:21.135Z |
4878701 | 4878701 | 20240807003417_m9TcT | UK0029 | 2024-08-19T12:14:19.085Z | 2024-08-27T12:13:47.605Z |
4876655 | 4876655 | 20240806234411_u40P2 | UK0029 | 2024-08-19T12:12:58.155Z | 2024-08-27T12:12:46.982Z |
4834867 | 4834867 | 20240805011635_OpWf9 | UK0029 | 2024-08-15T12:15:08.268Z | 2024-08-17T12:32:02.059Z |
4797168 | 4797168 | 20240802025814_Bv4lm | UK0029 | 2024-08-11T12:16:20.005Z | 2024-08-11T12:16:20.005Z |
4796741 | 4796741 | 20240802022556_3mKFS | UK0029 | 2024-08-11T12:16:10.653Z | 2024-08-11T12:16:10.653Z |
4796632 | 4796632 | 20240802022043_L7caw | UK0029 | 2024-08-11T12:16:08.901Z | 2024-08-11T12:16:08.901Z |
4796614 | 4796614 | 20240802022035_SqtJI | UK0029 | 2024-08-11T12:16:08.756Z | 2024-08-11T12:16:08.756Z |
4796261 | 4796261 | 20240802020155_xr4ep | UK0029 | 2024-08-11T12:16:01.014Z | 2024-08-11T12:16:01.014Z |
4795769 | 4795769 | 20240802014230_aFsEt | UK0029 | 2024-08-11T12:15:48.319Z | 2024-08-11T12:15:48.319Z |
4785915 | 4785915 | 20240802004017_EofWT | UK0029 | 2024-08-10T12:16:27.962Z | 2024-08-11T12:14:55.451Z |
4785431 | 4785431 | 20240802001719_7uM10 | UK0029 | 2024-08-10T12:16:04.073Z | 2024-08-11T12:14:47.329Z |
4784875 | 4784875 | 20240801235022_IA98y | UK0029 | 2024-08-10T12:15:33.019Z | 2024-08-11T12:14:37.768Z |
4784627 | 4784627 | 20240801233941_8ZByR | UK0029 | 2024-08-10T12:15:15.768Z | 2024-08-11T12:14:33.607Z |
4783673 | 4783673 | 20240801224303_GN1LB | UK0029 | 2024-08-10T12:14:10.752Z | 2024-08-11T12:14:15.849Z |
4762717 | 4762717 | 20240731022903_HKCR8 | UK0029 | 2024-08-06T12:03:01.806Z | 2024-08-10T12:17:53.581Z |
4762300 | 4762300 | 20240731015917_LE4mD | UK0029 | 2024-08-06T12:02:15.905Z | 2024-08-10T12:17:41.854Z |
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);