participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,374 rows where station_code = "UK001R" 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 |
---|---|---|---|---|---|
5124478 | 5124478 | 20240917204010_33yDb | UK001R | 2024-09-19T12:01:00.331Z | 2024-09-19T12:06:41.901Z |
5112151 | 5112151 | 20240914222702_bt3gt | UK001R | 2024-09-18T12:02:50.345Z | 2024-09-19T12:18:38.714Z |
5085521 | 5085521 | 20240912212453_BqznV | UK001R | 2024-09-16T12:04:21.215Z | 2024-09-19T12:20:28.987Z |
5019217 | 5019217 | 20240904221100_bmSD9 | UK001R | 2024-09-10T12:12:23.850Z | 2024-09-13T12:19:51.017Z |
5007458 | 5007458 | 20240903211254_EZ7ME | UK001R | 2024-09-09T12:05:47.376Z | 2024-09-12T12:19:13.083Z |
4978023 | 4978023 | 20240811234712_Q3eLb | UK001R | 2024-09-06T12:12:27.917Z | 2024-09-06T12:12:27.917Z |
4977984 | 4977984 | 20240811234644_yeA6z | UK001R | 2024-09-06T12:12:27.490Z | 2024-09-06T12:12:27.490Z |
4976273 | 4976273 | 20240811232753_J43W1 | UK001R | 2024-09-06T12:11:21.761Z | 2024-09-06T12:11:21.761Z |
4976073 | 4976073 | 20240811232531_ODTjs | UK001R | 2024-09-06T12:11:08.479Z | 2024-09-06T12:11:08.479Z |
4973631 | 4973631 | 20240811225840_2oIaN | UK001R | 2024-09-05T12:11:03.349Z | 2024-09-06T12:10:02.166Z |
4972621 | 4972621 | 20240811224845_q3Tz5 | UK001R | 2024-09-05T12:10:30.081Z | 2024-09-06T12:09:21.337Z |
4968030 | 4968030 | 20240811215326_KWtCy | UK001R | 2024-09-05T12:07:58.038Z | 2024-09-06T12:07:21.936Z |
4967974 | 4967974 | 20240811215249_jnBOI | UK001R | 2024-09-05T12:07:55.441Z | 2024-09-06T12:07:18.825Z |
4967113 | 4967113 | 20240811213859_rY1It | UK001R | 2024-09-05T12:07:30.678Z | 2024-09-06T12:06:53.470Z |
4954588 | 4954588 | 20240811030556_9gWsB | UK001R | 2024-09-03T12:18:17.237Z | 2024-09-06T12:29:04.451Z |
4953672 | 4953672 | 20240811024254_ZcJc1 | UK001R | 2024-09-03T12:17:53.394Z | 2024-09-06T12:28:34.316Z |
4950713 | 4950713 | 20240811021050_RdSsX | UK001R | 2024-09-02T12:16:34.399Z | 2024-09-06T12:27:47.320Z |
4950643 | 4950643 | 20240811021016_yzq42 | UK001R | 2024-09-02T12:16:33.116Z | 2024-09-06T12:27:46.678Z |
4927635 | 4927635 | 20240810021650_QTEQm | UK001R | 2024-08-31T12:20:46.241Z | 2024-09-02T12:28:45.352Z |
4927530 | 4927530 | 20240810021517_XRF4L | UK001R | 2024-08-31T12:20:42.411Z | 2024-09-02T12:28:40.233Z |
4883791 | 4883791 | 20240807024853_uxTdg | UK001R | 2024-08-20T12:15:11.036Z | 2024-08-27T12:16:00.620Z |
4875352 | 4875352 | 20240806231322_IBDh8 | UK001R | 2024-08-19T12:12:07.321Z | 2024-08-27T12:12:13.455Z |
4872716 | 4872716 | 20240806215529_zy2hO | UK001R | 2024-08-19T12:10:13.393Z | 2024-08-27T12:10:45.822Z |
4833293 | 4833293 | 20240805001300_dx3b6 | UK001R | 2024-08-15T12:13:54.436Z | 2024-08-17T12:31:32.154Z |
4832328 | 4832328 | 20240804232634_q3OBl | UK001R | 2024-08-15T12:12:54.964Z | 2024-08-17T12:31:01.440Z |
4795254 | 4795254 | 20240802011853_Hub70 | UK001R | 2024-08-11T12:15:19.629Z | 2024-08-11T12:15:19.629Z |
4786682 | 4786682 | 20240802010750_LaWul | UK001R | 2024-08-10T12:17:11.093Z | 2024-08-11T12:15:07.264Z |
4786142 | 4786142 | 20240802004955_ANrSh | UK001R | 2024-08-10T12:16:43.051Z | 2024-08-11T12:14:59.894Z |
4784121 | 4784121 | 20240801231036_bOrcc | UK001R | 2024-08-10T12:14:36.221Z | 2024-08-11T12:14:24.546Z |
4784022 | 4784022 | 20240801230507_Heudc | UK001R | 2024-08-10T12:14:32.234Z | 2024-08-11T12:14:21.894Z |
4783928 | 4783928 | 20240801225833_DuAod | UK001R | 2024-08-10T12:14:23.762Z | 2024-08-11T12:14:20.260Z |
4783831 | 4783831 | 20240801225335_AP3Cv | UK001R | 2024-08-10T12:14:19.744Z | 2024-08-11T12:14:18.518Z |
4783763 | 4783763 | 20240801224711_DEMUj | UK001R | 2024-08-10T12:14:16.132Z | 2024-08-11T12:14:16.940Z |
4751188 | 4751188 | 20240729235231_5wEaN | UK001R | 2024-08-04T12:16:32.511Z | 2024-08-06T12:15:32.931Z |
4744976 | 4744976 | 20240730020746_TE3Mt | UK001R | 2024-08-04T12:07:02.438Z | 2024-08-08T12:18:06.567Z |
4744398 | 4744398 | 20240730014606_EpfkS | UK001R | 2024-08-04T12:06:15.544Z | 2024-08-08T12:17:52.383Z |
4735613 | 4735613 | 20240729022046_aKk3l | UK001R | 2024-08-01T12:05:12.266Z | 2024-08-06T12:14:53.048Z |
4735410 | 4735410 | 20240729021446_Zg68D | UK001R | 2024-08-01T12:05:03.220Z | 2024-08-06T12:14:52.697Z |
4713596 | 4713596 | 20240727232612_Sfpnc | UK001R | 2024-07-30T12:02:53.951Z | 2024-08-05T12:19:32.133Z |
4705356 | 4705356 | 20240727225847_xw9tK | UK001R | 2024-07-29T12:01:40.550Z | 2024-08-05T12:19:25.848Z |
4704725 | 4704725 | 20240727222046_Gv82u | UK001R | 2024-07-29T12:00:47.818Z | 2024-08-05T12:19:18.984Z |
4699010 | 4699010 | 20240727014119_7jHPC | UK001R | 2024-07-28T12:06:11.783Z | 2024-08-04T12:19:16.739Z |
4691442 | 4691442 | 20240726015248_71OTn | UK001R | 2024-07-27T12:05:34.037Z | 2024-08-03T12:21:20.185Z |
4691297 | 4691297 | 20240726013238_FTN3S | UK001R | 2024-07-27T12:05:14.791Z | 2024-08-03T12:21:18.992Z |
4691126 | 4691126 | 20240726011158_Wwtm5 | UK001R | 2024-07-27T12:04:53.914Z | 2024-08-03T12:21:16.843Z |
4690741 | 4690741 | 20240726003021_Oj342 | UK001R | 2024-07-27T12:04:03.539Z | 2024-08-03T12:21:12.520Z |
4666849 | 4666849 | 20240719001234_ADQYq | UK001R | 2024-07-20T12:03:05.945Z | 2024-07-27T12:17:07.889Z |
4655302 | 4655302 | 20240717002407_fD5G5 | UK001R | 2024-07-18T12:05:48.447Z | 2024-07-25T12:14:01.480Z |
4649715 | 4649715 | 20240715010102_NO13E | UK001R | 2024-07-17T12:08:45.301Z | 2024-07-23T12:08:46.058Z |
4588478 | 4588478 | 20240708010843_LiFhd | UK001R | 2024-07-10T12:01:51.315Z | 2024-07-16T12:09:08.111Z |
4587529 | 4587529 | 20240708002159_CWZ8M | UK001R | 2024-07-10T12:00:43.988Z | 2024-07-16T12:09:05.779Z |
4587378 | 4587378 | 20240708001208_3nCG3 | UK001R | 2024-07-10T12:00:30.243Z | 2024-07-16T12:09:05.298Z |
4587194 | 4587194 | 20240708000521_i2fFV | UK001R | 2024-07-10T12:00:17.117Z | 2024-07-16T12:09:04.776Z |
4577504 | 4577504 | 20240706233701_VNv91 | UK001R | 2024-07-09T12:00:47.922Z | 2024-07-15T12:11:52.239Z |
4576834 | 4576834 | 20240706224933_zP81v | UK001R | 2024-07-09T12:00:09.292Z | 2024-07-15T12:11:50.024Z |
4562178 | 4562178 | 20240704233615_u1ciU | UK001R | 2024-07-07T12:02:43.362Z | 2024-07-13T12:12:46.267Z |
4553666 | 4553666 | 20240704011206_JFH6r | UK001R | 2024-07-06T12:02:26.325Z | 2024-07-12T12:08:53.729Z |
4553630 | 4553630 | 20240704010943_X2BUJ | UK001R | 2024-07-06T12:02:21.325Z | 2024-07-12T12:08:53.692Z |
4553386 | 4553386 | 20240704004647_jSO2d | UK001R | 2024-07-06T12:01:53.609Z | 2024-07-12T12:08:53.460Z |
4553290 | 4553290 | 20240704003347_q4PNT | UK001R | 2024-07-06T12:01:46.716Z | 2024-07-12T12:08:53.303Z |
4545272 | 4545272 | 20240704000309_rXSet | UK001R | 2024-07-05T12:01:40.154Z | 2024-07-12T12:08:52.875Z |
4545208 | 4545208 | 20240703235746_LlNYH | UK001R | 2024-07-05T12:01:37.586Z | 2024-07-12T12:08:52.827Z |
4531387 | 4531387 | 20240630231829_STFSt | UK001R | 2024-07-02T12:02:48.090Z | 2024-07-09T12:08:01.830Z |
4500448 | 4500448 | 20240624233555_TNK5C | UK001R | 2024-06-26T12:04:11.949Z | 2024-07-03T12:13:14.249Z |
4500072 | 4500072 | 20240624225540_400Ui | UK001R | 2024-06-26T12:03:46.072Z | 2024-07-03T12:13:11.074Z |
4497781 | 4497781 | 20240624011336_GYyoI | UK001R | 2024-06-25T12:04:36.783Z | 2024-07-02T12:10:17.967Z |
4497190 | 4497190 | 20240623234018_aeGQc | UK001R | 2024-06-25T12:03:40.404Z | 2024-07-02T12:10:16.543Z |
4492547 | 4492547 | 20240621011031_sorat | UK001R | 2024-06-22T12:05:48.756Z | 2024-06-29T12:13:35.079Z |
4492245 | 4492245 | 20240620234225_Pongs | UK001R | 2024-06-22T12:05:27.971Z | 2024-06-29T12:13:33.118Z |
4488957 | 4488957 | 20240620004900_as3uO | UK001R | 2024-06-21T12:05:39.469Z | 2024-06-28T12:09:40.147Z |
4488938 | 4488938 | 20240620004407_xpS22 | UK001R | 2024-06-21T12:05:36.709Z | 2024-06-28T12:09:39.897Z |
4455921 | 4455921 | 20240613000039_kaB2F | UK001R | 2024-06-14T12:01:18.841Z | 2024-06-21T12:11:30.346Z |
4445255 | 4445255 | 20240610233347_zpr36 | UK001R | 2024-06-12T12:01:28.247Z | 2024-06-19T12:13:27.816Z |
4438163 | 4438163 | 20240609003428_ot2NJ | UK001R | 2024-06-10T12:01:25.494Z | 2024-06-17T12:15:10.396Z |
4437682 | 4437682 | 20240608235836_p4q0F | UK001R | 2024-06-10T12:01:13.909Z | 2024-06-17T12:15:08.501Z |
4436987 | 4436987 | 20240608230640_qv70j | UK001R | 2024-06-10T12:00:52.793Z | 2024-06-17T12:15:04.353Z |
4428563 | 4428563 | 20240607013833_jP0In | UK001R | 2024-06-08T12:06:23.522Z | 2024-06-15T12:16:59.674Z |
4422067 | 4422067 | 20240605005909_mgAdA | UK001R | 2024-06-07T12:09:40.189Z | 2024-06-13T12:08:33.290Z |
4421992 | 4421992 | 20240605005226_lLs03 | UK001R | 2024-06-07T12:09:36.044Z | 2024-06-13T12:08:33.169Z |
4421963 | 4421963 | 20240605004846_9bmJu | UK001R | 2024-06-07T12:09:32.329Z | 2024-06-13T12:08:33.108Z |
4417416 | 4417416 | 20240604015322_n0YD9 | UK001R | 2024-06-06T12:09:13.331Z | 2024-06-12T12:10:41.647Z |
4417378 | 4417378 | 20240604014211_p4d2o | UK001R | 2024-06-06T12:09:11.607Z | 2024-06-12T12:10:41.555Z |
4417360 | 4417360 | 20240604012558_GdW2U | UK001R | 2024-06-06T12:09:09.601Z | 2024-06-12T12:10:41.379Z |
4416955 | 4416955 | 20240603223525_R5Dps | UK001R | 2024-06-06T12:08:33.691Z | 2024-06-12T12:10:37.975Z |
4416531 | 4416531 | 20240605002226_UgZza | UK001R | 2024-06-06T12:06:31.953Z | 2024-06-13T12:08:32.656Z |
4416523 | 4416523 | 20240605002226_TOob7 | UK001R | 2024-06-06T12:06:31.603Z | 2024-06-13T12:08:32.647Z |
4416385 | 4416385 | 20240604235625_9RLYL | UK001R | 2024-06-06T12:06:20.997Z | 2024-06-13T12:08:32.293Z |
4400572 | 4400572 | 20240601235747_JXGM2 | UK001R | 2024-06-03T12:06:10.839Z | 2024-06-10T12:06:46.641Z |
4400329 | 4400329 | 20240601223814_zXobZ | UK001R | 2024-06-03T12:05:48.812Z | 2024-06-10T12:06:46.095Z |
4387697 | 4387697 | 20240528012636_jZkCY | UK001R | 2024-05-29T12:08:22.107Z | 2024-06-05T12:18:11.460Z |
4374753 | 4374753 | 20240520013906_mG2It | UK001R | 2024-05-27T12:08:50.586Z | 2024-05-28T12:13:23.341Z |
4372887 | 4372887 | 20240520233451_i5E36 | UK001R | 2024-05-27T12:05:30.478Z | 2024-05-29T12:13:29.537Z |
4372801 | 4372801 | 20240520224140_BnlhW | UK001R | 2024-05-27T12:05:14.608Z | 2024-05-29T12:13:27.457Z |
4366436 | 4366436 | 20240519021529_CPcKk | UK001R | 2024-05-26T12:02:27.129Z | 2024-05-27T12:10:45.321Z |
4366320 | 4366320 | 20240519013449_lWVjo | UK001R | 2024-05-26T12:02:21.555Z | 2024-05-27T12:10:43.196Z |
4366251 | 4366251 | 20240519012802_e3jGK | UK001R | 2024-05-26T12:02:18.098Z | 2024-05-27T12:10:42.357Z |
4366104 | 4366104 | 20240519010950_WhWeI | UK001R | 2024-05-26T12:02:09.736Z | 2024-05-27T12:10:39.180Z |
4365891 | 4365891 | 20240519000526_FjJIZ | UK001R | 2024-05-26T12:01:46.597Z | 2024-05-27T12:10:33.030Z |
4342351 | 4342351 | 20240510003206_tBpJ3 | UK001R | 2024-05-19T12:10:45.946Z | 2024-05-21T12:10:41.900Z |
4342251 | 4342251 | 20240510002213_N99uO | UK001R | 2024-05-19T12:10:32.842Z | 2024-05-21T12:10:39.139Z |
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);