participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
751 rows where station_code = "UK00CD" 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 |
---|---|---|---|---|---|
5583264 | 5583264 | 20241121020832_kdZE3 | UK00CD | 2024-11-23T14:23:42.799Z | 2024-11-24T14:23:52.961Z |
5581276 | 5581276 | 20241122015143_prE52 | UK00CD | 2024-11-23T14:20:12.658Z | 2024-11-24T14:22:31.201Z |
5579519 | 5579519 | 20241121225427_Te9GJ | UK00CD | 2024-11-23T14:18:32.656Z | 2024-11-24T14:22:25.385Z |
5579269 | 5579269 | 20241121221706_J7njT | UK00CD | 2024-11-23T14:18:06.398Z | 2024-11-24T14:22:24.273Z |
5578756 | 5578756 | 20241121205537_Io7d5 | UK00CD | 2024-11-23T14:17:31.943Z | 2024-11-24T14:22:22.081Z |
5573029 | 5573029 | 20241121034226_bQbpx | UK00CD | 2024-11-22T14:19:06.124Z | 2024-11-24T14:24:01.728Z |
5573009 | 5573009 | 20241121033914_HNLq1 | UK00CD | 2024-11-22T14:19:03.929Z | 2024-11-24T14:24:01.432Z |
5572982 | 5572982 | 20241121033340_oyQsq | UK00CD | 2024-11-22T14:19:02.503Z | 2024-11-24T14:24:01.046Z |
5572859 | 5572859 | 20241121031731_cYwHC | UK00CD | 2024-11-22T14:18:53.808Z | 2024-11-24T14:23:59.303Z |
5572809 | 5572809 | 20241121031034_qdsCo | UK00CD | 2024-11-22T14:18:50.670Z | 2024-11-24T14:23:58.986Z |
5572589 | 5572589 | 20241121024503_D9vow | UK00CD | 2024-11-22T14:18:38.303Z | 2024-11-24T14:23:57.442Z |
5572457 | 5572457 | 20241121022237_Tlv1x | UK00CD | 2024-11-22T14:18:27.329Z | 2024-11-24T14:23:55.614Z |
5572306 | 5572306 | 20241121020726_n1CJu | UK00CD | 2024-11-22T14:18:14.578Z | 2024-11-24T14:23:52.944Z |
5572189 | 5572189 | 20241121014450_iLf13 | UK00CD | 2024-11-22T14:18:03.836Z | 2024-11-24T14:23:52.261Z |
5571817 | 5571817 | 20241121004928_Rnzt7 | UK00CD | 2024-11-22T14:17:40.616Z | 2024-11-24T14:23:47.486Z |
5571653 | 5571653 | 20241121002657_1awaK | UK00CD | 2024-11-22T14:17:32.326Z | 2024-11-24T14:23:46.563Z |
5571360 | 5571360 | 20241120232750_70g2P | UK00CD | 2024-11-22T14:16:56.563Z | 2024-11-24T14:23:43.491Z |
5571283 | 5571283 | 20241120231251_OJh04 | UK00CD | 2024-11-22T14:16:47.781Z | 2024-11-24T14:23:42.861Z |
5571255 | 5571255 | 20241120230828_POSt4 | UK00CD | 2024-11-22T14:16:43.906Z | 2024-11-24T14:23:42.689Z |
5570854 | 5570854 | 20241120211504_vFlRu | UK00CD | 2024-11-22T14:16:09.380Z | 2024-11-24T14:23:39.025Z |
5569906 | 5569906 | 20241120175540_Z3mmg | UK00CD | 2024-11-22T14:14:33.229Z | 2024-11-24T14:23:25.926Z |
5566489 | 5566489 | 20241121062210_ys52B | UK00CD | 2024-11-22T14:03:00.191Z | 2024-11-24T14:21:32.481Z |
5566442 | 5566442 | 20241121061138_fE4Kn | UK00CD | 2024-11-22T14:02:54.009Z | 2024-11-24T14:21:31.536Z |
5566434 | 5566434 | 20241121061137_NnT4V | UK00CD | 2024-11-22T14:02:53.784Z | 2024-11-24T14:21:31.527Z |
5566344 | 5566344 | 20241121060207_aXcBg | UK00CD | 2024-11-22T14:02:29.622Z | 2024-11-24T14:21:30.266Z |
5566316 | 5566316 | 20241121055932_BmSaK | UK00CD | 2024-11-22T14:02:25.722Z | 2024-11-24T14:21:29.979Z |
5565980 | 5565980 | 20241121051237_AK4hA | UK00CD | 2024-11-22T14:01:30.411Z | 2024-11-24T14:21:24.646Z |
5565716 | 5565716 | 20241121043722_cKcde | UK00CD | 2024-11-22T14:00:45.808Z | 2024-11-24T14:21:18.360Z |
5565603 | 5565603 | 20241121042442_fkZOm | UK00CD | 2024-11-22T14:00:23.343Z | 2024-11-24T14:21:15.098Z |
5563513 | 5563513 | 20241120013730_B0J2I | UK00CD | 2024-11-21T14:16:13.658Z | 2024-11-24T14:24:37.869Z |
5563458 | 5563458 | 20241120013119_CN6jy | UK00CD | 2024-11-21T14:16:07.421Z | 2024-11-24T14:24:37.745Z |
5563390 | 5563390 | 20241120012418_BX0eD | UK00CD | 2024-11-21T14:16:01.911Z | 2024-11-24T14:24:37.505Z |
5562954 | 5562954 | 20241120003434_BjLPD | UK00CD | 2024-11-21T14:15:30.010Z | 2024-11-24T14:24:35.432Z |
5562405 | 5562405 | 20241119233359_JQ5Mm | UK00CD | 2024-11-21T14:14:46.663Z | 2024-11-24T14:24:32.034Z |
5543235 | 5543235 | 20241114231841_o46PO | UK00CD | 2024-11-16T14:05:48.704Z | 2024-11-23T14:26:18.266Z |
5543158 | 5543158 | 20241114215426_3K1wF | UK00CD | 2024-11-16T14:05:37.582Z | 2024-11-23T14:26:17.965Z |
5539083 | 5539083 | 20241113054117_OtVyS | UK00CD | 2024-11-14T14:14:11.869Z | 2024-11-21T14:26:31.590Z |
5539050 | 5539050 | 20241113053652_70hl9 | UK00CD | 2024-11-14T14:14:09.903Z | 2024-11-21T14:26:31.072Z |
5538277 | 5538277 | 20241113025758_bmRB2 | UK00CD | 2024-11-14T14:13:11.035Z | 2024-11-21T14:26:22.921Z |
5538270 | 5538270 | 20241113025629_5llqs | UK00CD | 2024-11-14T14:13:10.509Z | 2024-11-21T14:26:22.862Z |
5538087 | 5538087 | 20241113020732_i633r | UK00CD | 2024-11-14T14:12:49.964Z | 2024-11-21T14:26:20.617Z |
5538058 | 5538058 | 20241113020500_Lbjl1 | UK00CD | 2024-11-14T14:12:48.129Z | 2024-11-21T14:26:19.961Z |
5537957 | 5537957 | 20241113013949_H3wRs | UK00CD | 2024-11-14T14:12:39.642Z | 2024-11-21T14:26:17.473Z |
5537745 | 5537745 | 20241113002640_zoxQw | UK00CD | 2024-11-14T14:12:27.635Z | 2024-11-21T14:26:15.621Z |
5537635 | 5537635 | 20241112235604_ShkYw | UK00CD | 2024-11-14T14:12:19.876Z | 2024-11-21T14:26:15.012Z |
5537568 | 5537568 | 20241112234026_Eqvh1 | UK00CD | 2024-11-14T14:12:10.691Z | 2024-11-21T14:26:14.246Z |
5531613 | 5531613 | 20241112035218_z6aT8 | UK00CD | 2024-11-13T14:15:46.570Z | 2024-11-20T14:26:12.711Z |
5531199 | 5531199 | 20241112032055_uNFXm | UK00CD | 2024-11-13T14:15:23.531Z | 2024-11-20T14:26:08.517Z |
5531003 | 5531003 | 20241112030513_0mqWT | UK00CD | 2024-11-13T14:14:58.973Z | 2024-11-20T14:26:05.863Z |
5530163 | 5530163 | 20241112015306_36z6E | UK00CD | 2024-11-13T14:13:59.452Z | 2024-11-20T14:25:55.063Z |
5530159 | 5530159 | 20241112015211_xaFZy | UK00CD | 2024-11-13T14:13:59.090Z | 2024-11-20T14:25:55.018Z |
5529932 | 5529932 | 20241112012444_EhUIF | UK00CD | 2024-11-13T14:13:24.940Z | 2024-11-20T14:25:51.075Z |
5529815 | 5529815 | 20241112010555_hes3A | UK00CD | 2024-11-13T14:13:12.749Z | 2024-11-20T14:25:48.477Z |
5529794 | 5529794 | 20241112010512_cEo2D | UK00CD | 2024-11-13T14:13:11.379Z | 2024-11-20T14:25:48.235Z |
5529675 | 5529675 | 20241112005244_3l3qq | UK00CD | 2024-11-13T14:13:05.612Z | 2024-11-20T14:25:47.341Z |
5529453 | 5529453 | 20241112002136_3ORQr | UK00CD | 2024-11-13T14:12:51.167Z | 2024-11-20T14:25:45.057Z |
5529371 | 5529371 | 20241112000840_YL0w3 | UK00CD | 2024-11-13T14:12:27.391Z | 2024-11-20T14:25:43.416Z |
5529175 | 5529175 | 20241111234114_YHhpC | UK00CD | 2024-11-13T14:12:10.909Z | 2024-11-20T14:25:41.281Z |
5528757 | 5528757 | 20241111223250_JG3gM | UK00CD | 2024-11-13T14:11:23.244Z | 2024-11-20T14:25:34.966Z |
5528006 | 5528006 | 20241111191117_aSfQW | UK00CD | 2024-11-13T14:09:40.438Z | 2024-11-20T14:25:23.898Z |
5527989 | 5527989 | 20241111190937_kihwN | UK00CD | 2024-11-13T14:09:39.476Z | 2024-11-20T14:25:23.756Z |
5410700 | 5410700 | 20241027052903_M1m7L | UK00CD | 2024-10-29T12:18:02.744Z | 2024-11-04T14:29:05.236Z |
5409591 | 5409591 | 20241027042722_QJHXP | UK00CD | 2024-10-29T12:17:31.883Z | 2024-11-04T14:29:01.968Z |
5409484 | 5409484 | 20241027042043_mwgwH | UK00CD | 2024-10-29T12:17:25.724Z | 2024-11-04T14:29:01.853Z |
5409048 | 5409048 | 20241027035711_CXkwG | UK00CD | 2024-10-29T12:17:03.308Z | 2024-11-04T14:29:00.993Z |
5408970 | 5408970 | 20241027035141_O3X66 | UK00CD | 2024-10-29T12:16:58.445Z | 2024-11-04T14:29:00.879Z |
5408303 | 5408303 | 20241027032207_Qopv8 | UK00CD | 2024-10-29T12:16:21.841Z | 2024-11-04T14:28:59.069Z |
5407440 | 5407440 | 20241027023700_3iYrH | UK00CD | 2024-10-29T12:15:24.742Z | 2024-11-04T14:28:57.570Z |
5406934 | 5406934 | 20241027021029_8YxqV | UK00CD | 2024-10-29T12:15:01.387Z | 2024-11-04T14:28:56.707Z |
5402717 | 5402717 | 20241026201632_GlOge | UK00CD | 2024-10-29T12:07:59.752Z | 2024-11-04T14:28:46.315Z |
5402679 | 5402679 | 20241026201324_3Z43O | UK00CD | 2024-10-29T12:07:56.615Z | 2024-11-04T14:28:46.088Z |
5402510 | 5402510 | 20241026194751_3613L | UK00CD | 2024-10-29T12:07:27.368Z | 2024-11-04T14:28:44.974Z |
5402480 | 5402480 | 20241026194141_DwF31 | UK00CD | 2024-10-29T12:07:22.501Z | 2024-11-04T14:28:44.742Z |
5399571 | 5399571 | 20241026043500_C44VJ | UK00CD | 2024-10-28T12:20:02.615Z | 2024-11-03T14:27:39.991Z |
5399344 | 5399344 | 20241026041140_R376e | UK00CD | 2024-10-28T12:19:55.327Z | 2024-11-03T14:27:39.506Z |
5399326 | 5399326 | 20241026041019_VVEFi | UK00CD | 2024-10-28T12:19:54.718Z | 2024-11-03T14:27:39.448Z |
5398373 | 5398373 | 20241026025047_KUrZ5 | UK00CD | 2024-10-28T12:19:13.032Z | 2024-11-03T14:27:36.138Z |
5397903 | 5397903 | 20241026020619_C4SMr | UK00CD | 2024-10-28T12:18:49.860Z | 2024-11-03T14:27:34.458Z |
5397633 | 5397633 | 20241026014401_WmO0e | UK00CD | 2024-10-28T12:18:30.447Z | 2024-11-03T14:27:33.622Z |
5397580 | 5397580 | 20241026014114_FHRGo | UK00CD | 2024-10-28T12:18:28.606Z | 2024-11-03T14:27:33.428Z |
5397529 | 5397529 | 20241026013752_5bShE | UK00CD | 2024-10-28T12:18:26.336Z | 2024-11-03T14:27:33.346Z |
5397481 | 5397481 | 20241026013301_J22ig | UK00CD | 2024-10-28T12:18:24.490Z | 2024-11-03T14:27:33.144Z |
5397476 | 5397476 | 20241026013248_pQQM4 | UK00CD | 2024-10-28T12:18:24.430Z | 2024-11-03T14:27:33.141Z |
5397468 | 5397468 | 20241026013143_eEpEZ | UK00CD | 2024-10-28T12:18:24.090Z | 2024-11-03T14:27:33.119Z |
5397461 | 5397461 | 20241026013130_9KjkZ | UK00CD | 2024-10-28T12:18:23.304Z | 2024-11-03T14:27:33.032Z |
5397380 | 5397380 | 20241026012420_u8aPb | UK00CD | 2024-10-28T12:18:18.751Z | 2024-11-03T14:27:32.758Z |
5397311 | 5397311 | 20241026011649_g33Cl | UK00CD | 2024-10-28T12:18:15.465Z | 2024-11-03T14:27:32.560Z |
5397249 | 5397249 | 20241026011311_udF3Z | UK00CD | 2024-10-28T12:18:13.062Z | 2024-11-03T14:27:32.433Z |
5396960 | 5396960 | 20241026004957_bYmW8 | UK00CD | 2024-10-28T12:18:00.673Z | 2024-11-03T14:27:31.545Z |
5396860 | 5396860 | 20241026004245_5IlXr | UK00CD | 2024-10-28T12:17:58.115Z | 2024-11-03T14:27:31.269Z |
5396784 | 5396784 | 20241026003248_AGjxn | UK00CD | 2024-10-28T12:17:55.540Z | 2024-11-03T14:27:30.888Z |
5396736 | 5396736 | 20241026002804_J27Ol | UK00CD | 2024-10-28T12:17:54.459Z | 2024-11-03T14:27:30.830Z |
5396535 | 5396535 | 20241026000955_0KhG3 | UK00CD | 2024-10-28T12:17:48.938Z | 2024-11-03T14:27:30.157Z |
5396500 | 5396500 | 20241026000809_cadJN | UK00CD | 2024-10-28T12:17:47.224Z | 2024-11-03T14:27:30.018Z |
5396482 | 5396482 | 20241026000636_1MjHf | UK00CD | 2024-10-28T12:17:45.605Z | 2024-11-03T14:27:29.966Z |
5395820 | 5395820 | 20241025231248_uGeg7 | UK00CD | 2024-10-28T12:16:55.082Z | 2024-11-03T14:27:26.785Z |
5395744 | 5395744 | 20241025230723_A3VDj | UK00CD | 2024-10-28T12:16:44.961Z | 2024-11-03T14:27:26.599Z |
5395395 | 5395395 | 20241025223936_PELed | UK00CD | 2024-10-28T12:16:12.021Z | 2024-11-03T14:27:25.423Z |
5395277 | 5395277 | 20241025222922_9Fo8Q | UK00CD | 2024-10-28T12:16:04.280Z | 2024-11-03T14:27:24.553Z |
5385186 | 5385186 | 20241024220336_UiDNZ | UK00CD | 2024-10-27T12:18:32.987Z | 2024-11-02T12:28:29.251Z |
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);