participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,147 rows where station_code = "UK003D" 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 |
---|---|---|---|---|---|
5523999 | 5523999 | 20241111030109_zKSRD | UK003D | 2024-11-12T14:16:25.383Z | 2024-11-12T14:18:08.428Z |
5454269 | 5454269 | 20241031040417_rKXbw | UK003D | 2024-11-02T12:22:57.452Z | 2024-11-08T14:23:21.969Z |
5454116 | 5454116 | 20241031034342_BqoDO | UK003D | 2024-11-02T12:22:51.348Z | 2024-11-08T14:23:20.606Z |
5454105 | 5454105 | 20241031034216_6zmAl | UK003D | 2024-11-02T12:22:50.827Z | 2024-11-08T14:23:20.465Z |
5418134 | 5418134 | 20241027195810_mEubV | UK003D | 2024-10-30T12:14:58.819Z | 2024-11-05T14:27:09.260Z |
5418110 | 5418110 | 20241027195635_XPV1a | UK003D | 2024-10-30T12:14:54.855Z | 2024-11-05T14:27:09.139Z |
5410776 | 5410776 | 20241027053555_b8hq1 | UK003D | 2024-10-29T12:18:04.877Z | 2024-11-04T14:29:05.466Z |
5410607 | 5410607 | 20241027052258_g8hjr | UK003D | 2024-10-29T12:17:59.492Z | 2024-11-04T14:29:05.096Z |
5410514 | 5410514 | 20241027051622_VhkyR | UK003D | 2024-10-29T12:17:57.451Z | 2024-11-04T14:29:04.714Z |
5409859 | 5409859 | 20241027043845_IEzAP | UK003D | 2024-10-29T12:17:42.495Z | 2024-11-04T14:29:02.822Z |
5409824 | 5409824 | 20241027043718_TPpRm | UK003D | 2024-10-29T12:17:41.961Z | 2024-11-04T14:29:02.773Z |
5409781 | 5409781 | 20241027043601_1aKFi | UK003D | 2024-10-29T12:17:40.839Z | 2024-11-04T14:29:02.637Z |
5409714 | 5409714 | 20241027043152_h6tiy | UK003D | 2024-10-29T12:17:38.611Z | 2024-11-04T14:29:02.172Z |
5406595 | 5406595 | 20241027014715_3vhRa | UK003D | 2024-10-29T12:14:23.243Z | 2024-11-04T14:28:55.895Z |
5406589 | 5406589 | 20241027014711_DH0VP | UK003D | 2024-10-29T12:14:23.149Z | 2024-11-04T14:28:55.893Z |
5406408 | 5406408 | 20241027013605_O2Shq | UK003D | 2024-10-29T12:14:07.381Z | 2024-11-04T14:28:55.664Z |
5405997 | 5405997 | 20241027011200_6Ip7s | UK003D | 2024-10-29T12:13:47.293Z | 2024-11-04T14:28:54.832Z |
5405717 | 5405717 | 20241027005426_BE5eI | UK003D | 2024-10-29T12:13:10.676Z | 2024-11-04T14:28:53.929Z |
5405264 | 5405264 | 20241027002606_Peah2 | UK003D | 2024-10-29T12:12:46.806Z | 2024-11-04T14:28:53.208Z |
5405117 | 5405117 | 20241027001428_SrH8F | UK003D | 2024-10-29T12:12:29.796Z | 2024-11-04T14:28:52.692Z |
5404924 | 5404924 | 20241027000055_S3oYq | UK003D | 2024-10-29T12:12:07.563Z | 2024-11-04T14:28:52.407Z |
5404050 | 5404050 | 20241026225453_4WnQH | UK003D | 2024-10-29T12:10:50.997Z | 2024-11-04T14:28:50.276Z |
5398712 | 5398712 | 20241026032144_Fl0F8 | UK003D | 2024-10-28T12:19:29.458Z | 2024-11-03T14:27:37.888Z |
5398646 | 5398646 | 20241026031459_Sb0av | UK003D | 2024-10-28T12:19:25.389Z | 2024-11-03T14:27:37.450Z |
5398338 | 5398338 | 20241026024537_22W41 | UK003D | 2024-10-28T12:19:11.132Z | 2024-11-03T14:27:35.920Z |
5398102 | 5398102 | 20241026022707_35KPn | UK003D | 2024-10-28T12:19:01.008Z | 2024-11-03T14:27:35.417Z |
5397998 | 5397998 | 20241026021450_MFIxW | UK003D | 2024-10-28T12:18:55.442Z | 2024-11-03T14:27:34.811Z |
5397599 | 5397599 | 20241026014226_xNO5C | UK003D | 2024-10-28T12:18:29.513Z | 2024-11-03T14:27:33.556Z |
5397166 | 5397166 | 20241026010709_WliwO | UK003D | 2024-10-28T12:18:10.174Z | 2024-11-03T14:27:32.133Z |
5396718 | 5396718 | 20241026002611_emrFn | UK003D | 2024-10-28T12:17:54.022Z | 2024-11-03T14:27:30.742Z |
5395997 | 5395997 | 20241025232804_42iMe | UK003D | 2024-10-28T12:17:09.887Z | 2024-11-03T14:27:27.958Z |
5395987 | 5395987 | 20241025232730_a29Gv | UK003D | 2024-10-28T12:17:09.384Z | 2024-11-03T14:27:27.937Z |
5393889 | 5393889 | 20241025190616_bOfS5 | UK003D | 2024-10-28T12:13:48.498Z | 2024-11-03T14:27:18.802Z |
5386834 | 5386834 | 20241025013215_HZcrY | UK003D | 2024-10-27T12:20:35.397Z | 2024-11-02T12:28:31.659Z |
5386605 | 5386605 | 20241025010520_8ZqpW | UK003D | 2024-10-27T12:20:11.898Z | 2024-11-02T12:28:31.392Z |
5386486 | 5386486 | 20241025004810_rd2zz | UK003D | 2024-10-27T12:20:07.784Z | 2024-11-02T12:28:31.272Z |
5386405 | 5386405 | 20241025003704_Qxtv0 | UK003D | 2024-10-27T12:20:03.648Z | 2024-11-02T12:28:31.196Z |
5384747 | 5384747 | 20241024204911_RM2b2 | UK003D | 2024-10-27T12:17:37.505Z | 2024-11-02T12:28:27.696Z |
5377413 | 5377413 | 20241024044958_u4YMr | UK003D | 2024-10-26T12:22:36.771Z | 2024-11-01T12:27:02.424Z |
5376941 | 5376941 | 20241024042510_vq2vr | UK003D | 2024-10-26T12:22:17.677Z | 2024-11-01T12:27:01.925Z |
5376144 | 5376144 | 20241024034337_VEFOB | UK003D | 2024-10-26T12:21:52.366Z | 2024-11-01T12:27:01.413Z |
5375994 | 5375994 | 20241024033730_1yIx2 | UK003D | 2024-10-26T12:21:45.820Z | 2024-11-01T12:27:01.308Z |
5374647 | 5374647 | 20241024023804_c6gNt | UK003D | 2024-10-26T12:20:55.523Z | 2024-11-01T12:26:59.526Z |
5374572 | 5374572 | 20241024023455_wDu5d | UK003D | 2024-10-26T12:20:53.694Z | 2024-11-01T12:26:59.472Z |
5374095 | 5374095 | 20241024021002_oDD4v | UK003D | 2024-10-26T12:20:36.814Z | 2024-11-01T12:26:58.696Z |
5366188 | 5366188 | 20241024000849_G8bwe | UK003D | 2024-10-25T12:18:18.789Z | 2024-11-01T12:26:56.788Z |
5365675 | 5365675 | 20241023234254_EE416 | UK003D | 2024-10-25T12:18:04.676Z | 2024-11-01T12:26:56.335Z |
5365515 | 5365515 | 20241023233557_RJkSf | UK003D | 2024-10-25T12:17:59.750Z | 2024-11-01T12:26:56.185Z |
5365055 | 5365055 | 20241023231159_q4Qjc | UK003D | 2024-10-25T12:17:44.717Z | 2024-11-01T12:26:55.837Z |
5364518 | 5364518 | 20241023223519_r8wM6 | UK003D | 2024-10-25T12:17:23.392Z | 2024-11-01T12:26:55.167Z |
5363770 | 5363770 | 20241023214253_PZ3o9 | UK003D | 2024-10-25T12:16:43.570Z | 2024-11-01T12:26:53.617Z |
5363733 | 5363733 | 20241023213945_i2zrE | UK003D | 2024-10-25T12:16:38.677Z | 2024-11-01T12:26:53.587Z |
5363590 | 5363590 | 20241023212611_DkPbL | UK003D | 2024-10-25T12:16:26.545Z | 2024-11-01T12:26:53.454Z |
5363219 | 5363219 | 20241023203730_MUJjd | UK003D | 2024-10-25T12:15:42.339Z | 2024-11-01T12:26:52.964Z |
5363165 | 5363165 | 20241023203241_AC6sz | UK003D | 2024-10-25T12:15:36.055Z | 2024-11-01T12:26:52.893Z |
5361985 | 5361985 | 20241023190036_00FD1 | UK003D | 2024-10-25T12:13:44.328Z | 2024-11-01T12:26:50.795Z |
5350393 | 5350393 | 20241022214216_3cFym | UK003D | 2024-10-24T12:15:40.860Z | 2024-10-31T12:29:58.107Z |
5349885 | 5349885 | 20241022204409_7sle2 | UK003D | 2024-10-24T12:14:45.848Z | 2024-10-31T12:29:56.829Z |
5344291 | 5344291 | 20241022041352_uTSxR | UK003D | 2024-10-23T12:18:30.750Z | 2024-10-30T12:26:51.113Z |
5343842 | 5343842 | 20241022034955_1A9ZU | UK003D | 2024-10-23T12:18:10.857Z | 2024-10-30T12:26:50.646Z |
5343699 | 5343699 | 20241022034030_3S9Kx | UK003D | 2024-10-23T12:18:01.737Z | 2024-10-30T12:26:50.449Z |
5342854 | 5342854 | 20241022025029_pQA76 | UK003D | 2024-10-23T12:17:26.668Z | 2024-10-30T12:26:48.994Z |
5342697 | 5342697 | 20241022023941_nXyrp | UK003D | 2024-10-23T12:17:15.702Z | 2024-10-30T12:26:48.831Z |
5342002 | 5342002 | 20241022020308_jSvYx | UK003D | 2024-10-23T12:16:28.031Z | 2024-10-30T12:26:47.786Z |
5341700 | 5341700 | 20241022014902_gpsDC | UK003D | 2024-10-23T12:16:07.753Z | 2024-10-30T12:26:47.359Z |
5341171 | 5341171 | 20241022011905_5BkGh | UK003D | 2024-10-23T12:15:26.847Z | 2024-10-30T12:26:46.646Z |
5340755 | 5340755 | 20241022004657_cGqzT | UK003D | 2024-10-23T12:14:52.790Z | 2024-10-30T12:26:46.261Z |
5340742 | 5340742 | 20241022004539_pN2D6 | UK003D | 2024-10-23T12:14:52.130Z | 2024-10-30T12:26:46.257Z |
5340653 | 5340653 | 20241022004025_2PaPq | UK003D | 2024-10-23T12:14:46.233Z | 2024-10-30T12:26:46.116Z |
5333336 | 5333336 | 20241021001809_iYCSs | UK003D | 2024-10-22T12:15:12.882Z | 2024-10-29T12:26:34.293Z |
5333201 | 5333201 | 20241020235856_LfSsb | UK003D | 2024-10-22T12:14:55.065Z | 2024-10-29T12:26:34.178Z |
5333162 | 5333162 | 20241020235208_dFULL | UK003D | 2024-10-22T12:14:49.024Z | 2024-10-29T12:26:34.154Z |
5332979 | 5332979 | 20241020231745_PA3lh | UK003D | 2024-10-22T12:14:33.796Z | 2024-10-29T12:26:34.007Z |
5332574 | 5332574 | 20241020205604_qP5pS | UK003D | 2024-10-22T12:13:38.211Z | 2024-10-29T12:26:33.562Z |
5332395 | 5332395 | 20241020192545_Y8zS5 | UK003D | 2024-10-22T12:12:52.885Z | 2024-10-29T12:26:33.071Z |
5326790 | 5326790 | 20241019202322_rdw7P | UK003D | 2024-10-21T12:10:21.565Z | 2024-10-28T12:26:42.503Z |
5319843 | 5319843 | 20241017212832_SMQnm | UK003D | 2024-10-19T12:03:58.450Z | 2024-10-26T12:27:53.311Z |
5304344 | 5304344 | 20241013043847_UlC77 | UK003D | 2024-10-14T12:17:48.351Z | 2024-10-21T12:24:24.852Z |
5304217 | 5304217 | 20241013042909_C9c2o | UK003D | 2024-10-14T12:17:45.024Z | 2024-10-21T12:24:24.439Z |
5302017 | 5302017 | 20241013002236_wehV8 | UK003D | 2024-10-14T12:15:47.708Z | 2024-10-21T12:24:03.468Z |
5285376 | 5285376 | 20241011035339_QlKnb | UK003D | 2024-10-12T12:18:07.533Z | 2024-10-19T12:28:02.327Z |
5284408 | 5284408 | 20241011024124_TLjjl | UK003D | 2024-10-12T12:17:21.001Z | 2024-10-19T12:27:55.806Z |
5283895 | 5283895 | 20241011020443_TPbbl | UK003D | 2024-10-12T12:17:00.912Z | 2024-10-19T12:27:53.310Z |
5283600 | 5283600 | 20241011013805_6elQr | UK003D | 2024-10-12T12:16:48.023Z | 2024-10-19T12:27:52.246Z |
5282717 | 5282717 | 20241010231611_p3En1 | UK003D | 2024-10-12T12:15:59.490Z | 2024-10-19T12:27:45.769Z |
5282711 | 5282711 | 20241010231605_8d2YY | UK003D | 2024-10-12T12:15:59.402Z | 2024-10-19T12:27:45.766Z |
5281827 | 5281827 | 20241010193759_z7OX2 | UK003D | 2024-10-12T12:14:46.427Z | 2024-10-19T12:27:37.306Z |
5281733 | 5281733 | 20241010192511_VEOsq | UK003D | 2024-10-12T12:14:38.409Z | 2024-10-19T12:27:36.018Z |
5276481 | 5276481 | 20241011044339_MODZ2 | UK003D | 2024-10-12T12:01:14.748Z | 2024-10-20T12:23:10.012Z |
5276310 | 5276310 | 20241011043030_8T2gV | UK003D | 2024-10-12T12:00:51.859Z | 2024-10-20T12:23:07.781Z |
5276151 | 5276151 | 20241011042157_0ZFgE | UK003D | 2024-10-12T12:00:30.458Z | 2024-10-20T12:23:06.189Z |
5182253 | 5182253 | 20240927222317_F3w9Q | UK003D | 2024-09-29T12:15:50.230Z | 2024-10-05T12:29:08.234Z |
5181934 | 5181934 | 20240927214848_KHOy6 | UK003D | 2024-09-29T12:15:35.997Z | 2024-10-05T12:29:07.505Z |
5181743 | 5181743 | 20240927213156_R6aUs | UK003D | 2024-09-29T12:15:26.087Z | 2024-10-05T12:29:06.702Z |
5179894 | 5179894 | 20240928045853_RNdZz | UK003D | 2024-09-29T12:08:39.630Z | 2024-10-06T12:28:05.843Z |
5179864 | 5179864 | 20240928045304_koo5Z | UK003D | 2024-09-29T12:08:37.319Z | 2024-10-06T12:28:05.634Z |
5179679 | 5179679 | 20240928043453_O43A8 | UK003D | 2024-09-29T12:08:19.782Z | 2024-10-06T12:28:05.034Z |
5179608 | 5179608 | 20240928042642_l0PHe | UK003D | 2024-09-29T12:08:15.577Z | 2024-10-06T12:28:04.766Z |
5179286 | 5179286 | 20240928035716_N9uZB | UK003D | 2024-09-29T12:07:42.237Z | 2024-10-06T12:28:03.273Z |
5178948 | 5178948 | 20240928033119_EJ89p | UK003D | 2024-09-29T12:07:16.488Z | 2024-10-06T12:28:01.453Z |
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);