participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,855 rows where station_code = "UK001V" 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 |
---|---|---|---|---|---|
4953476 | 4953476 | 20240811023909_4Vl11 | UK001V | 2024-09-03T12:17:43.119Z | 2024-09-06T12:28:27.795Z |
4945875 | 4945875 | 20240811005247_zqh0U | UK001V | 2024-09-02T12:13:27.399Z | 2024-09-06T12:26:07.192Z |
4940321 | 4940321 | 20240810230952_Lm5rk | UK001V | 2024-09-01T12:10:24.632Z | 2024-09-06T12:23:33.941Z |
4912234 | 4912234 | 20240809210544_nTJ8T | UK001V | 2024-08-29T12:08:19.432Z | 2024-09-02T12:22:18.097Z |
4912229 | 4912229 | 20240809210544_43BSa | UK001V | 2024-08-29T12:08:19.236Z | 2024-09-02T12:22:17.980Z |
4903778 | 4903778 | 20240808031359_4wLFL | UK001V | 2024-08-28T12:19:55.036Z | 2024-08-28T12:19:55.036Z |
4903724 | 4903724 | 20240808031202_OtHtF | UK001V | 2024-08-28T12:19:50.608Z | 2024-08-28T12:19:50.608Z |
4874357 | 4874357 | 20240806224740_YyHUm | UK001V | 2024-08-19T12:11:22.037Z | 2024-08-27T12:11:42.833Z |
4872026 | 4872026 | 20240806212546_3FX40 | UK001V | 2024-08-19T12:09:44.429Z | 2024-08-27T12:10:14.929Z |
4834542 | 4834542 | 20240805010216_E9tdC | UK001V | 2024-08-15T12:14:46.957Z | 2024-08-17T12:31:58.439Z |
4795167 | 4795167 | 20240802011309_88bUw | UK001V | 2024-08-11T12:15:13.710Z | 2024-08-11T12:15:13.710Z |
4783978 | 4783978 | 20240801230137_qvgep | UK001V | 2024-08-10T12:14:27.651Z | 2024-08-11T12:14:21.163Z |
4736249 | 4736249 | 20240729024023_A4CW3 | UK001V | 2024-08-01T12:05:24.987Z | 2024-08-06T12:14:54.930Z |
4736229 | 4736229 | 20240729023939_7tCNe | UK001V | 2024-08-01T12:05:24.757Z | 2024-08-06T12:14:54.920Z |
4677735 | 4677735 | 20240723001124_EtOO3 | UK001V | 2024-07-24T12:01:54.138Z | 2024-07-31T12:17:53.747Z |
4578626 | 4578626 | 20240707003833_zSvFg | UK001V | 2024-07-09T12:01:42.927Z | 2024-07-15T12:11:57.839Z |
4489172 | 4489172 | 20240620013603_xQJZk | UK001V | 2024-06-21T12:06:01.451Z | 2024-06-28T12:09:41.540Z |
4438386 | 4438386 | 20240609005625_gtAuu | UK001V | 2024-06-10T12:01:35.148Z | 2024-06-17T12:15:12.430Z |
4436918 | 4436918 | 20240608225644_LsEt0 | UK001V | 2024-06-10T12:00:49.156Z | 2024-06-17T12:15:04.139Z |
4436903 | 4436903 | 20240608225533_uEZpo | UK001V | 2024-06-10T12:00:48.968Z | 2024-06-17T12:15:04.126Z |
4400376 | 4400376 | 20240601225705_9gOiF | UK001V | 2024-06-03T12:05:56.120Z | 2024-06-10T12:06:46.270Z |
4350419 | 4350419 | 20240510234603_Za7BS | UK001V | 2024-05-21T12:04:29.163Z | 2024-05-22T12:11:29.715Z |
4296355 | 4296355 | 20240505020946_whEIO | UK001V | 2024-05-08T12:11:42.217Z | 2024-05-13T12:12:17.621Z |
4086836 | 4086836 | 20240318045308_jxdpc | UK001V | 2024-03-19T12:09:06.693Z | 2024-03-26T12:21:10.693Z |
4086793 | 4086793 | 20240318044454_RY0qb | UK001V | 2024-03-19T12:09:04.440Z | 2024-03-26T12:21:10.277Z |
4086329 | 4086329 | 20240318030744_A0wmp | UK001V | 2024-03-19T12:08:24.358Z | 2024-03-26T12:21:05.366Z |
4086015 | 4086015 | 20240318014705_fbOuX | UK001V | 2024-03-19T12:07:54.544Z | 2024-03-26T12:21:00.288Z |
4085956 | 4085956 | 20240318011451_qjYD6 | UK001V | 2024-03-19T12:07:47.381Z | 2024-03-26T12:20:59.826Z |
4085935 | 4085935 | 20240318010315_b3zWH | UK001V | 2024-03-19T12:07:44.961Z | 2024-03-26T12:20:59.418Z |
4077297 | 4077297 | 20240316024525_zwNKi | UK001V | 2024-03-17T12:08:31.822Z | 2024-03-24T12:20:48.749Z |
4077282 | 4077282 | 20240316024220_xs8xR | UK001V | 2024-03-17T12:08:31.088Z | 2024-03-24T12:20:48.614Z |
4076873 | 4076873 | 20240316020039_2exi8 | UK001V | 2024-03-17T12:08:17.352Z | 2024-03-24T12:20:46.755Z |
4076755 | 4076755 | 20240316015212_n5VIP | UK001V | 2024-03-17T12:08:07.532Z | 2024-03-24T12:20:46.393Z |
4076692 | 4076692 | 20240316013911_GtRo5 | UK001V | 2024-03-17T12:08:03.492Z | 2024-03-24T12:20:46.054Z |
4040496 | 4040496 | 20240307002122_dAD21 | UK001V | 2024-03-08T14:07:48.122Z | 2024-03-15T12:19:20.348Z |
4039912 | 4039912 | 20240306214943_1BDJh | UK001V | 2024-03-08T14:07:04.286Z | 2024-03-15T12:19:13.436Z |
4039725 | 4039725 | 20240306203815_Vboph | UK001V | 2024-03-08T14:06:51.354Z | 2024-03-15T12:19:11.261Z |
4039382 | 4039382 | 20240306194402_3h7Dw | UK001V | 2024-03-08T14:06:11.987Z | 2024-03-15T12:19:06.495Z |
4039283 | 4039283 | 20240306192004_xuON1 | UK001V | 2024-03-08T14:06:00.750Z | 2024-03-15T12:19:05.134Z |
4034025 | 4034025 | 20240305221535_bqUb8 | UK001V | 2024-03-07T14:05:45.991Z | 2024-03-14T12:25:01.728Z |
4024106 | 4024106 | 20240304001223_ad6g6 | UK001V | 2024-03-05T14:05:10.204Z | 2024-03-12T12:15:21.440Z |
4023894 | 4023894 | 20240303234623_AGca3 | UK001V | 2024-03-05T14:04:51.936Z | 2024-03-12T12:15:20.605Z |
4023458 | 4023458 | 20240303230149_zKUmL | UK001V | 2024-03-05T14:04:11.104Z | 2024-03-12T12:15:18.274Z |
4023399 | 4023399 | 20240303225723_V0ilF | UK001V | 2024-03-05T14:04:08.057Z | 2024-03-12T12:15:17.958Z |
4023391 | 4023391 | 20240303225439_5oGLg | UK001V | 2024-03-05T14:04:07.352Z | 2024-03-12T12:15:17.930Z |
4023363 | 4023363 | 20240303224858_DK8wo | UK001V | 2024-03-05T14:04:04.364Z | 2024-03-12T12:15:17.464Z |
4023171 | 4023171 | 20240303221836_5t6CW | UK001V | 2024-03-05T14:03:49.264Z | 2024-03-12T12:15:17.090Z |
4022642 | 4022642 | 20240303194350_Z3vW5 | UK001V | 2024-03-05T14:02:40.816Z | 2024-03-12T12:15:14.264Z |
4019927 | 4019927 | 20240302234206_d8Rbn | UK001V | 2024-03-04T14:05:06.039Z | 2024-03-11T12:18:34.171Z |
4016674 | 4016674 | 20240301214053_23E3s | UK001V | 2024-03-03T14:06:01.908Z | 2024-03-10T12:21:18.144Z |
4013134 | 4013134 | 20240301025757_lPA6t | UK001V | 2024-03-02T14:08:20.311Z | 2024-03-09T14:17:47.185Z |
4012692 | 4012692 | 20240301013806_hxDnq | UK001V | 2024-03-02T14:07:41.841Z | 2024-03-09T14:17:45.992Z |
4012681 | 4012681 | 20240301013433_jC4yv | UK001V | 2024-03-02T14:07:39.571Z | 2024-03-09T14:17:45.957Z |
4012410 | 4012410 | 20240301004456_nxCF4 | UK001V | 2024-03-02T14:07:23.833Z | 2024-03-09T14:17:44.675Z |
4012358 | 4012358 | 20240301003244_eDTEx | UK001V | 2024-03-02T14:07:15.599Z | 2024-03-09T14:17:44.419Z |
4012302 | 4012302 | 20240301002029_5ZrBL | UK001V | 2024-03-02T14:07:11.799Z | 2024-03-09T14:17:44.344Z |
4012120 | 4012120 | 20240229233626_6M4Kd | UK001V | 2024-03-02T14:06:56.660Z | 2024-03-09T14:17:43.867Z |
4012062 | 4012062 | 20240229231852_c2O4f | UK001V | 2024-03-02T14:06:51.133Z | 2024-03-09T14:17:43.673Z |
4012015 | 4012015 | 20240229231037_obYGS | UK001V | 2024-03-02T14:06:45.444Z | 2024-03-09T14:17:43.603Z |
4011752 | 4011752 | 20240229203441_fHi1L | UK001V | 2024-03-02T14:06:08.439Z | 2024-03-09T14:17:42.663Z |
4006867 | 4006867 | 20240227194243_U3U9b | UK001V | 2024-02-29T14:03:53.409Z | 2024-03-07T14:19:00.234Z |
4004434 | 4004434 | 20240226205135_orr8Q | UK001V | 2024-02-28T14:02:32.779Z | 2024-03-06T14:19:36.752Z |
4003379 | 4003379 | 20240226041250_l23F3 | UK001V | 2024-02-27T14:02:45.278Z | 2024-03-05T14:18:54.441Z |
4003330 | 4003330 | 20240226032557_3YsI8 | UK001V | 2024-02-27T14:02:32.887Z | 2024-03-05T14:18:53.902Z |
4003327 | 4003327 | 20240226032024_a4Sgs | UK001V | 2024-02-27T14:02:32.514Z | 2024-03-05T14:18:53.885Z |
4003320 | 4003320 | 20240226031636_ZpmDh | UK001V | 2024-02-27T14:02:31.693Z | 2024-03-05T14:18:53.838Z |
4003274 | 4003274 | 20240226023908_dS2FK | UK001V | 2024-02-27T14:02:20.741Z | 2024-03-05T14:18:53.407Z |
4003231 | 4003231 | 20240226015143_okBsi | UK001V | 2024-02-27T14:02:12.132Z | 2024-03-05T14:18:52.895Z |
4003145 | 4003145 | 20240225232913_dU2Z0 | UK001V | 2024-02-27T14:01:48.850Z | 2024-03-05T14:18:51.964Z |
4001925 | 4001925 | 20240224212030_OCkQY | UK001V | 2024-02-26T14:01:13.237Z | 2024-03-04T14:18:51.332Z |
3999560 | 3999560 | 20240223000009_19Hsd | UK001V | 2024-02-24T14:05:04.883Z | 2024-03-02T14:20:30.528Z |
3999021 | 3999021 | 20240222190706_gICbo | UK001V | 2024-02-24T14:03:57.499Z | 2024-03-02T14:20:19.626Z |
3997342 | 3997342 | 20240221214337_OKCce | UK001V | 2024-02-23T14:04:47.829Z | 2024-03-01T14:14:58.179Z |
3959280 | 3959280 | 20240213043717_NK9qw | UK001V | 2024-02-14T14:09:18.229Z | 2024-02-21T14:20:43.875Z |
3959269 | 3959269 | 20240213043615_bKuhR | UK001V | 2024-02-14T14:09:17.763Z | 2024-02-21T14:20:43.418Z |
3959142 | 3959142 | 20240213040918_zL0ut | UK001V | 2024-02-14T14:08:58.575Z | 2024-02-21T14:20:41.637Z |
3958978 | 3958978 | 20240213032318_mhq6h | UK001V | 2024-02-14T14:08:41.534Z | 2024-02-21T14:20:39.108Z |
3958793 | 3958793 | 20240213024320_thypA | UK001V | 2024-02-14T14:08:18.337Z | 2024-02-21T14:20:36.406Z |
3958457 | 3958457 | 20240213010947_xJkWo | UK001V | 2024-02-14T14:07:40.693Z | 2024-02-21T14:20:33.880Z |
3957230 | 3957230 | 20240212192125_4W3Xn | UK001V | 2024-02-14T14:05:05.075Z | 2024-02-21T14:20:21.772Z |
3954386 | 3954386 | 20240212053734_E3mrP | UK001V | 2024-02-13T14:08:56.171Z | 2024-02-20T14:26:06.782Z |
3954029 | 3954029 | 20240212045243_WFJnE | UK001V | 2024-02-13T14:08:30.584Z | 2024-02-20T14:26:04.096Z |
3953465 | 3953465 | 20240212034734_BpS3G | UK001V | 2024-02-13T14:07:51.725Z | 2024-02-20T14:26:01.050Z |
3953398 | 3953398 | 20240212034638_Hfkk5 | UK001V | 2024-02-13T14:07:49.610Z | 2024-02-20T14:26:00.863Z |
3953344 | 3953344 | 20240212033727_o93Np | UK001V | 2024-02-13T14:07:44.106Z | 2024-02-20T14:26:00.352Z |
3952365 | 3952365 | 20240212003156_1inZg | UK001V | 2024-02-13T14:06:17.092Z | 2024-02-20T14:25:48.366Z |
3952359 | 3952359 | 20240212003103_3PpU6 | UK001V | 2024-02-13T14:06:16.745Z | 2024-02-20T14:25:48.241Z |
3952322 | 3952322 | 20240212002456_nk8xM | UK001V | 2024-02-13T14:06:11.788Z | 2024-02-20T14:25:47.782Z |
3952213 | 3952213 | 20240212000321_4hmcX | UK001V | 2024-02-13T14:06:04.604Z | 2024-02-20T14:25:46.702Z |
3952058 | 3952058 | 20240211233943_AsXdQ | UK001V | 2024-02-13T14:05:47.192Z | 2024-02-20T14:25:45.757Z |
3952038 | 3952038 | 20240211233852_P3bfL | UK001V | 2024-02-13T14:05:46.113Z | 2024-02-20T14:25:45.667Z |
3952031 | 3952031 | 20240211233740_2TBxZ | UK001V | 2024-02-13T14:05:45.296Z | 2024-02-20T14:25:45.426Z |
3951970 | 3951970 | 20240211232737_Q3nhU | UK001V | 2024-02-13T14:05:36.355Z | 2024-02-20T14:25:44.619Z |
3951959 | 3951959 | 20240211232450_o30WA | UK001V | 2024-02-13T14:05:35.192Z | 2024-02-20T14:25:43.623Z |
3951201 | 3951201 | 20240211202806_QbEm3 | UK001V | 2024-02-13T14:04:25.151Z | 2024-02-20T14:25:34.824Z |
3951189 | 3951189 | 20240211202657_Aegp2 | UK001V | 2024-02-13T14:04:24.450Z | 2024-02-20T14:25:34.715Z |
3950773 | 3950773 | 20240211190030_uR5mQ | UK001V | 2024-02-13T14:03:24.353Z | 2024-02-20T14:25:27.703Z |
3950750 | 3950750 | 20240211185423_Y4YuW | UK001V | 2024-02-13T14:03:23.004Z | 2024-02-20T14:25:27.544Z |
3943745 | 3943745 | 20240210010350_1b28y | UK001V | 2024-02-11T14:06:28.605Z | 2024-02-18T14:22:11.141Z |
3931695 | 3931695 | 20240207054720_tWTNv | UK001V | 2024-02-08T14:05:26.302Z | 2024-02-15T14:18:39.620Z |
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);