participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,374 rows where station_code = "UK000Y" 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 |
---|---|---|---|---|---|
4252087 | 4252087 | 20240428232549_R3G8J | UK000Y | 2024-04-30T12:12:03.121Z | 2024-05-07T12:18:40.657Z |
4252002 | 4252002 | 20240428231340_KyHEY | UK000Y | 2024-04-30T12:12:00.585Z | 2024-05-07T12:18:39.786Z |
4251978 | 4251978 | 20240428230615_EGyOw | UK000Y | 2024-04-30T12:11:59.301Z | 2024-05-07T12:18:38.790Z |
4251934 | 4251934 | 20240428225142_FAjHL | UK000Y | 2024-04-30T12:11:56.798Z | 2024-05-07T12:18:37.417Z |
4243254 | 4243254 | 20240426233626_zuJbp | UK000Y | 2024-04-28T12:08:53.727Z | 2024-05-05T12:21:44.023Z |
4243213 | 4243213 | 20240426231907_DdFlL | UK000Y | 2024-04-28T12:08:43.639Z | 2024-05-05T12:21:43.609Z |
4243196 | 4243196 | 20240426231519_xTtp1 | UK000Y | 2024-04-28T12:08:40.548Z | 2024-05-05T12:21:43.382Z |
4243183 | 4243183 | 20240426231001_rt0WW | UK000Y | 2024-04-28T12:08:38.720Z | 2024-05-05T12:21:43.277Z |
4243149 | 4243149 | 20240426224529_HitOe | UK000Y | 2024-04-28T12:08:33.276Z | 2024-05-05T12:21:42.457Z |
4243091 | 4243091 | 20240426221440_PXBF9 | UK000Y | 2024-04-28T12:08:25.548Z | 2024-05-05T12:21:40.910Z |
4240138 | 4240138 | 20240424211313_nbnYO | UK000Y | 2024-04-27T12:10:06.943Z | 2024-05-03T12:19:29.105Z |
4237735 | 4237735 | 20240426032750_CPYGz | UK000Y | 2024-04-27T12:00:51.383Z | 2024-05-05T12:21:26.010Z |
4237715 | 4237715 | 20240426030921_IZdbB | UK000Y | 2024-04-27T12:00:44.419Z | 2024-05-05T12:21:25.892Z |
4237641 | 4237641 | 20240426023549_OI1uZ | UK000Y | 2024-04-27T12:00:33.532Z | 2024-05-05T12:21:25.488Z |
4220214 | 4220214 | 20240420033038_FwOk9 | UK000Y | 2024-04-21T12:02:56.731Z | 2024-04-28T12:21:27.964Z |
4220066 | 4220066 | 20240420030752_Qk5Lp | UK000Y | 2024-04-21T12:02:45.584Z | 2024-04-28T12:21:26.109Z |
4220001 | 4220001 | 20240420030239_cQEHV | UK000Y | 2024-04-21T12:02:41.126Z | 2024-04-28T12:21:24.054Z |
4219893 | 4219893 | 20240420025535_WF1o9 | UK000Y | 2024-04-21T12:02:33.631Z | 2024-04-28T12:21:23.345Z |
4219847 | 4219847 | 20240420025334_ARfTE | UK000Y | 2024-04-21T12:02:30.708Z | 2024-04-28T12:21:22.951Z |
4219427 | 4219427 | 20240420020142_vtnl2 | UK000Y | 2024-04-21T12:01:45.438Z | 2024-04-28T12:21:16.360Z |
4219272 | 4219272 | 20240420013216_Xxj7s | UK000Y | 2024-04-21T12:01:28.748Z | 2024-04-28T12:21:12.933Z |
4218358 | 4218358 | 20240419030511_j84ZC | UK000Y | 2024-04-20T12:14:47.260Z | 2024-04-27T12:20:15.029Z |
4213962 | 4213962 | 20240418032307_yqOXO | UK000Y | 2024-04-20T12:04:10.235Z | 2024-04-26T12:16:57.483Z |
4213937 | 4213937 | 20240418032220_gQ6pR | UK000Y | 2024-04-20T12:04:09.800Z | 2024-04-26T12:16:57.428Z |
4213924 | 4213924 | 20240418031916_TabBz | UK000Y | 2024-04-20T12:04:08.670Z | 2024-04-26T12:16:57.305Z |
4213759 | 4213759 | 20240418025901_KjNj3 | UK000Y | 2024-04-20T12:03:48.019Z | 2024-04-26T12:16:56.174Z |
4213615 | 4213615 | 20240418024408_zWsXL | UK000Y | 2024-04-20T12:03:31.596Z | 2024-04-26T12:16:55.031Z |
4213404 | 4213404 | 20240418021453_US0kv | UK000Y | 2024-04-20T12:02:53.593Z | 2024-04-26T12:16:51.095Z |
4213354 | 4213354 | 20240418020926_mxMAX | UK000Y | 2024-04-20T12:02:48.351Z | 2024-04-26T12:16:50.728Z |
4213291 | 4213291 | 20240418015530_R0zOD | UK000Y | 2024-04-20T12:02:36.636Z | 2024-04-26T12:16:49.018Z |
4212920 | 4212920 | 20240418014538_7Oil3 | UK000Y | 2024-04-19T12:10:07.035Z | 2024-04-26T12:16:47.198Z |
4212242 | 4212242 | 20240417205206_3ARJp | UK000Y | 2024-04-19T12:09:31.328Z | 2024-04-25T12:22:41.869Z |
4212188 | 4212188 | 20240417204036_0wyzL | UK000Y | 2024-04-19T12:09:29.043Z | 2024-04-25T12:22:39.889Z |
4206312 | 4206312 | 20240417211643_09UE7 | UK000Y | 2024-04-19T12:00:17.280Z | 2024-04-26T12:16:22.875Z |
4206219 | 4206219 | 20240417035149_P5No2 | UK000Y | 2024-04-18T12:13:34.793Z | 2024-04-25T12:21:28.290Z |
4206171 | 4206171 | 20240417033825_wQv6u | UK000Y | 2024-04-18T12:13:32.439Z | 2024-04-25T12:21:26.914Z |
4206052 | 4206052 | 20240417031432_uyIQm | UK000Y | 2024-04-18T12:13:23.699Z | 2024-04-25T12:21:24.914Z |
4205940 | 4205940 | 20240417025312_DSVGY | UK000Y | 2024-04-18T12:13:13.939Z | 2024-04-25T12:21:23.575Z |
4201463 | 4201463 | 20240417021517_wsKWM | UK000Y | 2024-04-18T12:03:29.652Z | 2024-04-25T12:21:18.156Z |
4201176 | 4201176 | 20240417013507_Ej0sB | UK000Y | 2024-04-18T12:02:58.910Z | 2024-04-25T12:21:14.062Z |
4201071 | 4201071 | 20240417012133_3zVVr | UK000Y | 2024-04-18T12:02:45.766Z | 2024-04-25T12:21:13.210Z |
4201062 | 4201062 | 20240417011731_vdR8E | UK000Y | 2024-04-18T12:02:44.689Z | 2024-04-25T12:21:13.121Z |
4195058 | 4195058 | 20240416015210_EUgmF | UK000Y | 2024-04-17T12:03:07.641Z | 2024-04-24T12:23:24.650Z |
4194829 | 4194829 | 20240416005131_SrsIy | UK000Y | 2024-04-17T12:02:25.615Z | 2024-04-24T12:23:19.169Z |
4194819 | 4194819 | 20240416004544_3OCgc | UK000Y | 2024-04-17T12:02:24.184Z | 2024-04-24T12:23:17.833Z |
4194746 | 4194746 | 20240416002812_a4Xfv | UK000Y | 2024-04-17T12:02:17.079Z | 2024-04-24T12:23:12.745Z |
4186286 | 4186286 | 20240414035454_kKEXb | UK000Y | 2024-04-15T12:06:24.839Z | 2024-04-22T12:22:28.639Z |
4186243 | 4186243 | 20240414034447_xKztl | UK000Y | 2024-04-15T12:06:21.131Z | 2024-04-22T12:22:28.302Z |
4186229 | 4186229 | 20240414034247_YBUn5 | UK000Y | 2024-04-15T12:06:19.063Z | 2024-04-22T12:22:28.237Z |
4186112 | 4186112 | 20240414031416_xiY1X | UK000Y | 2024-04-15T12:06:01.460Z | 2024-04-22T12:22:26.622Z |
4185834 | 4185834 | 20240414021846_JUevw | UK000Y | 2024-04-15T12:05:17.212Z | 2024-04-22T12:22:22.625Z |
4185300 | 4185300 | 20240414004959_DgAfj | UK000Y | 2024-04-15T12:04:06.620Z | 2024-04-22T12:22:17.207Z |
4185207 | 4185207 | 20240414002547_UXfus | UK000Y | 2024-04-15T12:03:53.627Z | 2024-04-22T12:22:16.038Z |
4184450 | 4184450 | 20240413204406_aPcNQ | UK000Y | 2024-04-15T12:01:40.090Z | 2024-04-22T12:22:06.681Z |
4169556 | 4169556 | 20240410013941_IwzzX | UK000Y | 2024-04-11T12:14:52.298Z | 2024-04-18T12:21:15.440Z |
4169418 | 4169418 | 20240410011743_IMl7m | UK000Y | 2024-04-11T12:14:41.907Z | 2024-04-18T12:21:14.818Z |
4169266 | 4169266 | 20240410005746_yKkle | UK000Y | 2024-04-11T12:14:28.151Z | 2024-04-18T12:21:13.718Z |
4166705 | 4166705 | 20240410000921_1XvK9 | UK000Y | 2024-04-11T12:05:57.111Z | 2024-04-18T12:21:11.301Z |
4166299 | 4166299 | 20240409231345_cLZuP | UK000Y | 2024-04-11T12:05:20.849Z | 2024-04-18T12:21:09.033Z |
4166218 | 4166218 | 20240409225636_3QkxQ | UK000Y | 2024-04-11T12:05:12.396Z | 2024-04-18T12:21:08.270Z |
4166088 | 4166088 | 20240409223257_zA5s3 | UK000Y | 2024-04-11T12:04:57.348Z | 2024-04-18T12:21:07.460Z |
4166079 | 4166079 | 20240409223226_um3Ud | UK000Y | 2024-04-11T12:04:56.673Z | 2024-04-18T12:21:07.457Z |
4165588 | 4165588 | 20240409210500_tVHEU | UK000Y | 2024-04-11T12:03:50.294Z | 2024-04-18T12:21:02.261Z |
4165476 | 4165476 | 20240409205324_A3HYc | UK000Y | 2024-04-11T12:03:32.299Z | 2024-04-18T12:21:01.404Z |
4154802 | 4154802 | 20240407025558_zstgU | UK000Y | 2024-04-08T12:07:11.701Z | 2024-04-15T12:19:17.183Z |
4154667 | 4154667 | 20240407023623_S84I2 | UK000Y | 2024-04-08T12:06:59.228Z | 2024-04-15T12:19:16.660Z |
4154444 | 4154444 | 20240407015915_SUKpI | UK000Y | 2024-04-08T12:06:40.246Z | 2024-04-15T12:19:15.784Z |
4154333 | 4154333 | 20240407014258_nRtJt | UK000Y | 2024-04-08T12:06:26.189Z | 2024-04-15T12:19:15.201Z |
4154246 | 4154246 | 20240407012307_Glpek | UK000Y | 2024-04-08T12:06:18.512Z | 2024-04-15T12:19:14.843Z |
4154157 | 4154157 | 20240407010606_aT6GK | UK000Y | 2024-04-08T12:06:11.093Z | 2024-04-15T12:19:14.326Z |
4153752 | 4153752 | 20240406220302_Rm7xl | UK000Y | 2024-04-08T12:05:03.565Z | 2024-04-15T12:19:11.341Z |
4153745 | 4153745 | 20240406215610_HUg8G | UK000Y | 2024-04-08T12:05:02.751Z | 2024-04-15T12:19:11.262Z |
4086583 | 4086583 | 20240318040000_lJkCq | UK000Y | 2024-03-19T12:08:51.638Z | 2024-03-26T12:21:08.419Z |
4086520 | 4086520 | 20240318034332_qx5kz | UK000Y | 2024-03-19T12:08:43.595Z | 2024-03-26T12:21:07.780Z |
4086410 | 4086410 | 20240318031951_MrXIF | UK000Y | 2024-03-19T12:08:31.657Z | 2024-03-26T12:21:06.612Z |
4086227 | 4086227 | 20240318024503_jNnN6 | UK000Y | 2024-03-19T12:08:16.859Z | 2024-03-26T12:21:03.128Z |
4078401 | 4078401 | 20240316050019_roPke | UK000Y | 2024-03-17T12:09:31.250Z | 2024-03-24T12:20:57.490Z |
4078369 | 4078369 | 20240316050006_I7gBA | UK000Y | 2024-03-17T12:09:30.852Z | 2024-03-24T12:20:57.453Z |
4078246 | 4078246 | 20240316045211_5IhlW | UK000Y | 2024-03-17T12:09:24.664Z | 2024-03-24T12:20:56.876Z |
4078044 | 4078044 | 20240316041817_FL9N2 | UK000Y | 2024-03-17T12:09:15.654Z | 2024-03-24T12:20:55.390Z |
4077901 | 4077901 | 20240316035502_p7vJ9 | UK000Y | 2024-03-17T12:09:07.056Z | 2024-03-24T12:20:53.972Z |
4077518 | 4077518 | 20240316031621_vis3H | UK000Y | 2024-03-17T12:08:39.691Z | 2024-03-24T12:20:51.374Z |
4077403 | 4077403 | 20240316030329_O7zpd | UK000Y | 2024-03-17T12:08:35.417Z | 2024-03-24T12:20:50.722Z |
4077149 | 4077149 | 20240316022903_V6ViC | UK000Y | 2024-03-17T12:08:26.181Z | 2024-03-24T12:20:47.969Z |
4077014 | 4077014 | 20240316021526_2o3v2 | UK000Y | 2024-03-17T12:08:22.651Z | 2024-03-24T12:20:47.444Z |
4076904 | 4076904 | 20240316020145_CL9Gn | UK000Y | 2024-03-17T12:08:18.394Z | 2024-03-24T12:20:46.884Z |
4076760 | 4076760 | 20240316015252_d90Bf | UK000Y | 2024-03-17T12:08:07.889Z | 2024-03-24T12:20:46.423Z |
4076547 | 4076547 | 20240316012040_RxF0j | UK000Y | 2024-03-17T12:07:56.051Z | 2024-03-24T12:20:45.438Z |
4076495 | 4076495 | 20240316011455_ZmZK3 | UK000Y | 2024-03-17T12:07:54.464Z | 2024-03-24T12:20:45.212Z |
4041161 | 4041161 | 20240307023021_xdP6x | UK000Y | 2024-03-08T14:08:36.139Z | 2024-03-15T12:19:28.315Z |
4041139 | 4041139 | 20240307022720_9G7uu | UK000Y | 2024-03-08T14:08:35.405Z | 2024-03-15T12:19:28.024Z |
4040850 | 4040850 | 20240307013703_Znr6I | UK000Y | 2024-03-08T14:08:17.734Z | 2024-03-15T12:19:24.817Z |
4040473 | 4040473 | 20240307001544_5awuU | UK000Y | 2024-03-08T14:07:47.286Z | 2024-03-15T12:19:20.155Z |
4040357 | 4040357 | 20240306234116_j2vHl | UK000Y | 2024-03-08T14:07:41.507Z | 2024-03-15T12:19:18.735Z |
4035681 | 4035681 | 20240306041240_lVRxW | UK000Y | 2024-03-07T14:08:24.295Z | 2024-03-14T12:25:25.108Z |
4035663 | 4035663 | 20240306040918_n22u2 | UK000Y | 2024-03-07T14:08:22.694Z | 2024-03-14T12:25:24.673Z |
4035398 | 4035398 | 20240306031650_Cr0ig | UK000Y | 2024-03-07T14:07:51.323Z | 2024-03-14T12:25:19.267Z |
4035098 | 4035098 | 20240306022456_OmJ3o | UK000Y | 2024-03-07T14:07:30.538Z | 2024-03-14T12:25:12.684Z |
4035078 | 4035078 | 20240306022441_JasTL | UK000Y | 2024-03-07T14:07:30.298Z | 2024-03-14T12:25:12.634Z |
4034963 | 4034963 | 20240306015855_B3Cmt | UK000Y | 2024-03-07T14:07:11.736Z | 2024-03-14T12:25:11.321Z |
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);