participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,909 rows where station_code = "UK00C7" 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 |
---|---|---|---|---|---|
5570642 | 5570642 | 20241120203251_2IUdo | UK00C7 | 2024-11-22T14:15:57.910Z | 2024-11-22T14:19:21.955Z |
5570518 | 5570518 | 20241120195158_Mn4p4 | UK00C7 | 2024-11-22T14:15:39.341Z | 2024-11-22T14:19:21.929Z |
5570361 | 5570361 | 20241120192342_xkjrh | UK00C7 | 2024-11-22T14:15:14.782Z | 2024-11-22T14:19:21.903Z |
5570158 | 5570158 | 20241120185230_L3ika | UK00C7 | 2024-11-22T14:14:56.208Z | 2024-11-22T14:19:21.872Z |
5570137 | 5570137 | 20241120184910_TWQP0 | UK00C7 | 2024-11-22T14:14:54.400Z | 2024-11-22T14:19:21.868Z |
5570105 | 5570105 | 20241120184222_IUXzY | UK00C7 | 2024-11-22T14:14:52.572Z | 2024-11-22T14:19:21.863Z |
5570074 | 5570074 | 20241120183718_3YXMI | UK00C7 | 2024-11-22T14:14:49.287Z | 2024-11-22T14:19:21.857Z |
5569962 | 5569962 | 20241120181219_30dAF | UK00C7 | 2024-11-22T14:14:41.191Z | 2024-11-22T14:19:21.838Z |
5569946 | 5569946 | 20241120180150_XBCnn | UK00C7 | 2024-11-22T14:14:38.689Z | 2024-11-22T14:19:21.833Z |
5565395 | 5565395 | 20241120042225_W7WOn | UK00C7 | 2024-11-21T14:18:47.695Z | 2024-11-22T14:21:46.349Z |
5565355 | 5565355 | 20241120042057_k2nGT | UK00C7 | 2024-11-21T14:18:47.112Z | 2024-11-22T14:21:46.150Z |
5565258 | 5565258 | 20241120040804_SWrf7 | UK00C7 | 2024-11-21T14:18:43.938Z | 2024-11-22T14:21:44.746Z |
5565197 | 5565197 | 20241120040149_KhDGt | UK00C7 | 2024-11-21T14:18:39.785Z | 2024-11-22T14:21:43.560Z |
5565119 | 5565119 | 20241120035257_J2769 | UK00C7 | 2024-11-21T14:18:31.286Z | 2024-11-22T14:21:41.812Z |
5565105 | 5565105 | 20241120035155_3WpX0 | UK00C7 | 2024-11-21T14:18:30.467Z | 2024-11-22T14:21:41.712Z |
5564947 | 5564947 | 20241120034020_MOrjs | UK00C7 | 2024-11-21T14:18:15.877Z | 2024-11-22T14:21:39.682Z |
5564747 | 5564747 | 20241120032435_ZvQmV | UK00C7 | 2024-11-21T14:18:01.700Z | 2024-11-22T14:21:36.195Z |
5564724 | 5564724 | 20241120032241_3FKZW | UK00C7 | 2024-11-21T14:17:59.585Z | 2024-11-22T14:21:35.907Z |
5564523 | 5564523 | 20241120030621_d77nL | UK00C7 | 2024-11-21T14:17:45.392Z | 2024-11-22T14:21:33.142Z |
5564418 | 5564418 | 20241120025525_6qRmA | UK00C7 | 2024-11-21T14:17:33.315Z | 2024-11-22T14:21:31.330Z |
5564228 | 5564228 | 20241120024052_kYeBY | UK00C7 | 2024-11-21T14:17:20.741Z | 2024-11-22T14:21:29.099Z |
5564132 | 5564132 | 20241120023232_bHGjO | UK00C7 | 2024-11-21T14:17:12.692Z | 2024-11-22T14:21:27.335Z |
5563967 | 5563967 | 20241120021837_v7SIt | UK00C7 | 2024-11-21T14:17:00.542Z | 2024-11-22T14:21:25.655Z |
5563856 | 5563856 | 20241120021031_93Qqm | UK00C7 | 2024-11-21T14:16:51.122Z | 2024-11-22T14:21:23.988Z |
5563727 | 5563727 | 20241120015945_00giz | UK00C7 | 2024-11-21T14:16:36.131Z | 2024-11-22T14:21:21.485Z |
5563569 | 5563569 | 20241120014559_5YSEz | UK00C7 | 2024-11-21T14:16:20.337Z | 2024-11-22T14:21:18.700Z |
5563366 | 5563366 | 20241120012133_83ekw | UK00C7 | 2024-11-21T14:15:59.148Z | 2024-11-22T14:21:13.884Z |
5563349 | 5563349 | 20241120011855_dEI5d | UK00C7 | 2024-11-21T14:15:56.921Z | 2024-11-22T14:21:13.225Z |
5563332 | 5563332 | 20241120011805_juhuF | UK00C7 | 2024-11-21T14:15:54.827Z | 2024-11-22T14:21:13.147Z |
5563268 | 5563268 | 20241120011333_y68eM | UK00C7 | 2024-11-21T14:15:49.547Z | 2024-11-22T14:21:11.993Z |
5563191 | 5563191 | 20241120010334_JwEWt | UK00C7 | 2024-11-21T14:15:40.104Z | 2024-11-22T14:21:10.629Z |
5563140 | 5563140 | 20241120005608_vrAC0 | UK00C7 | 2024-11-21T14:15:37.746Z | 2024-11-22T14:21:09.935Z |
5563097 | 5563097 | 20241120005228_SNP0q | UK00C7 | 2024-11-21T14:15:36.564Z | 2024-11-22T14:21:09.587Z |
5562873 | 5562873 | 20241120002212_gdRA8 | UK00C7 | 2024-11-21T14:15:25.765Z | 2024-11-22T14:21:05.739Z |
5562762 | 5562762 | 20241120000829_EK74G | UK00C7 | 2024-11-21T14:15:20.443Z | 2024-11-22T14:21:03.512Z |
5562610 | 5562610 | 20241119235419_2P6k1 | UK00C7 | 2024-11-21T14:15:13.426Z | 2024-11-22T14:21:00.869Z |
5562594 | 5562594 | 20241119235343_TDzSP | UK00C7 | 2024-11-21T14:15:11.885Z | 2024-11-22T14:21:00.776Z |
5562529 | 5562529 | 20241119234756_nCND0 | UK00C7 | 2024-11-21T14:15:05.449Z | 2024-11-22T14:20:59.797Z |
5562258 | 5562258 | 20241119231727_KD0RT | UK00C7 | 2024-11-21T14:14:38.470Z | 2024-11-22T14:20:54.641Z |
5562021 | 5562021 | 20241119224603_PsVD6 | UK00C7 | 2024-11-21T14:14:20.314Z | 2024-11-22T14:20:51.529Z |
5561724 | 5561724 | 20241119215023_HX9Nr | UK00C7 | 2024-11-21T14:13:51.710Z | 2024-11-22T14:20:44.488Z |
5561540 | 5561540 | 20241119205651_UWJkk | UK00C7 | 2024-11-21T14:13:25.791Z | 2024-11-22T14:20:39.919Z |
5561479 | 5561479 | 20241119204457_5vouy | UK00C7 | 2024-11-21T14:13:20.311Z | 2024-11-22T14:20:37.705Z |
5561353 | 5561353 | 20241119200723_WXxVe | UK00C7 | 2024-11-21T14:13:08.153Z | 2024-11-22T14:20:33.103Z |
5561343 | 5561343 | 20241119200302_kVBAR | UK00C7 | 2024-11-21T14:13:07.389Z | 2024-11-22T14:20:32.633Z |
5561298 | 5561298 | 20241119193819_yqJjA | UK00C7 | 2024-11-21T14:13:02.085Z | 2024-11-22T14:20:30.286Z |
5561270 | 5561270 | 20241119192510_RqJVD | UK00C7 | 2024-11-21T14:12:54.288Z | 2024-11-22T14:20:29.212Z |
5558333 | 5558333 | 20241120055630_DMmN3 | UK00C7 | 2024-11-21T14:03:02.470Z | 2024-11-22T14:19:21.211Z |
5558007 | 5558007 | 20241120053029_594ah | UK00C7 | 2024-11-21T14:02:16.622Z | 2024-11-22T14:19:21.161Z |
5557877 | 5557877 | 20241120052120_YtaAr | UK00C7 | 2024-11-21T14:01:59.456Z | 2024-11-22T14:19:21.140Z |
5557859 | 5557859 | 20241120052001_3ou34 | UK00C7 | 2024-11-21T14:01:57.630Z | 2024-11-22T14:19:21.138Z |
5557738 | 5557738 | 20241120050906_tLQZv | UK00C7 | 2024-11-21T14:01:36.683Z | 2024-11-22T14:19:21.119Z |
5557593 | 5557593 | 20241120045918_90liC | UK00C7 | 2024-11-21T14:01:17.992Z | 2024-11-22T14:19:21.097Z |
5557532 | 5557532 | 20241120045342_7SdTj | UK00C7 | 2024-11-21T14:01:05.740Z | 2024-11-22T14:19:21.085Z |
5557400 | 5557400 | 20241120044342_nhoYI | UK00C7 | 2024-11-21T14:00:42.855Z | 2024-11-22T14:19:21.063Z |
5557391 | 5557391 | 20241120044308_9vebT | UK00C7 | 2024-11-21T14:00:41.015Z | 2024-11-22T14:19:21.061Z |
5557302 | 5557302 | 20241120043424_vNu5u | UK00C7 | 2024-11-21T14:00:27.876Z | 2024-11-22T14:19:21.049Z |
5545005 | 5545005 | 20241115214730_PhyKQ | UK00C7 | 2024-11-17T14:03:35.469Z | 2024-11-22T14:23:35.082Z |
5544990 | 5544990 | 20241115205916_XR6ly | UK00C7 | 2024-11-17T14:03:33.662Z | 2024-11-22T14:23:35.000Z |
5544983 | 5544983 | 20241115205424_SXqOm | UK00C7 | 2024-11-17T14:03:33.369Z | 2024-11-22T14:23:34.990Z |
5532714 | 5532714 | 20241112055403_3xb33 | UK00C7 | 2024-11-13T14:17:11.209Z | 2024-11-20T14:26:25.754Z |
5532622 | 5532622 | 20241112054437_LYIkN | UK00C7 | 2024-11-13T14:17:03.777Z | 2024-11-20T14:26:25.171Z |
5532601 | 5532601 | 20241112054310_J3THw | UK00C7 | 2024-11-13T14:17:02.539Z | 2024-11-20T14:26:25.049Z |
5532023 | 5532023 | 20241112042835_iiSrA | UK00C7 | 2024-11-13T14:16:10.658Z | 2024-11-20T14:26:17.327Z |
5531981 | 5531981 | 20241112042426_5goly | UK00C7 | 2024-11-13T14:16:05.340Z | 2024-11-20T14:26:16.714Z |
5531906 | 5531906 | 20241112041756_GZyao | UK00C7 | 2024-11-13T14:16:01.281Z | 2024-11-20T14:26:15.799Z |
5531795 | 5531795 | 20241112040921_Cr2U7 | UK00C7 | 2024-11-13T14:15:55.318Z | 2024-11-20T14:26:14.367Z |
5531770 | 5531770 | 20241112040804_KiYVV | UK00C7 | 2024-11-13T14:15:54.201Z | 2024-11-20T14:26:14.216Z |
5531618 | 5531618 | 20241112035333_LewPv | UK00C7 | 2024-11-13T14:15:46.625Z | 2024-11-20T14:26:12.731Z |
5531540 | 5531540 | 20241112034801_CMESG | UK00C7 | 2024-11-13T14:15:44.077Z | 2024-11-20T14:26:12.131Z |
5531162 | 5531162 | 20241112031916_9m3XN | UK00C7 | 2024-11-13T14:15:21.886Z | 2024-11-20T14:26:08.393Z |
5531122 | 5531122 | 20241112031535_RJqds | UK00C7 | 2024-11-13T14:15:15.810Z | 2024-11-20T14:26:08.064Z |
5531067 | 5531067 | 20241112031008_2oDeT | UK00C7 | 2024-11-13T14:15:07.580Z | 2024-11-20T14:26:06.942Z |
5531056 | 5531056 | 20241112030941_DnhA8 | UK00C7 | 2024-11-13T14:15:06.746Z | 2024-11-20T14:26:06.803Z |
5530980 | 5530980 | 20241112030334_xk9Lx | UK00C7 | 2024-11-13T14:14:57.361Z | 2024-11-20T14:26:05.737Z |
5530894 | 5530894 | 20241112025813_hGi35 | UK00C7 | 2024-11-13T14:14:48.488Z | 2024-11-20T14:26:05.073Z |
5530598 | 5530598 | 20241112023233_jsGnK | UK00C7 | 2024-11-13T14:14:24.311Z | 2024-11-20T14:26:01.922Z |
5530052 | 5530052 | 20241112013807_Njehl | UK00C7 | 2024-11-13T14:13:44.807Z | 2024-11-20T14:25:53.478Z |
5529784 | 5529784 | 20241112010424_ZWBsh | UK00C7 | 2024-11-13T14:13:10.683Z | 2024-11-20T14:25:48.215Z |
5529779 | 5529779 | 20241112010414_0b0To | UK00C7 | 2024-11-13T14:13:10.372Z | 2024-11-20T14:25:48.190Z |
5529533 | 5529533 | 20241112003021_936QE | UK00C7 | 2024-11-13T14:12:56.604Z | 2024-11-20T14:25:46.058Z |
5528550 | 5528550 | 20241111213107_mYNrN | UK00C7 | 2024-11-13T14:11:05.211Z | 2024-11-20T14:25:32.080Z |
5528506 | 5528506 | 20241111211303_x7UIP | UK00C7 | 2024-11-13T14:10:55.450Z | 2024-11-20T14:25:31.422Z |
5528265 | 5528265 | 20241111200541_MdqIK | UK00C7 | 2024-11-13T14:10:20.993Z | 2024-11-20T14:25:27.443Z |
5528032 | 5528032 | 20241111191907_dmK5d | UK00C7 | 2024-11-13T14:09:43.482Z | 2024-11-20T14:25:24.251Z |
5527799 | 5527799 | 20241111183629_KXg2l | UK00C7 | 2024-11-13T14:09:12.567Z | 2024-11-20T14:25:20.562Z |
5527794 | 5527794 | 20241111183552_z0leG | UK00C7 | 2024-11-13T14:09:09.503Z | 2024-11-20T14:25:20.462Z |
5527628 | 5527628 | 20241111175441_VCFg9 | UK00C7 | 2024-11-13T14:08:47.918Z | 2024-11-20T14:25:15.179Z |
5524497 | 5524497 | 20241111042141_mfZxO | UK00C7 | 2024-11-12T14:17:26.944Z | 2024-11-19T14:22:21.679Z |
5522809 | 5522809 | 20241110214840_H2kpi | UK00C7 | 2024-11-12T14:14:20.127Z | 2024-11-19T14:22:06.480Z |
5522613 | 5522613 | 20241110204408_K6orn | UK00C7 | 2024-11-12T14:13:46.928Z | 2024-11-19T14:22:04.632Z |
5522495 | 5522495 | 20241110201230_Wv4mo | UK00C7 | 2024-11-12T14:13:23.683Z | 2024-11-19T14:22:03.050Z |
5422976 | 5422976 | 20241027010945_kKqFD | UK00C7 | 2024-10-30T12:22:34.342Z | 2024-11-04T14:28:54.649Z |
5418654 | 5418654 | 20241027212852_RtTLT | UK00C7 | 2024-10-30T12:15:57.514Z | 2024-11-05T14:27:10.899Z |
5418458 | 5418458 | 20241027205050_PTTRx | UK00C7 | 2024-10-30T12:15:42.593Z | 2024-11-05T14:27:10.071Z |
5418375 | 5418375 | 20241027203338_0kZ33 | UK00C7 | 2024-10-30T12:15:36.623Z | 2024-11-05T14:27:09.929Z |
5418316 | 5418316 | 20241027202158_k4DnE | UK00C7 | 2024-10-30T12:15:24.869Z | 2024-11-05T14:27:09.618Z |
5418173 | 5418173 | 20241027200445_wisrL | UK00C7 | 2024-10-30T12:15:02.656Z | 2024-11-05T14:27:09.414Z |
5418138 | 5418138 | 20241027195810_mEubV | UK00C7 | 2024-10-30T12:14:58.852Z | 2024-11-05T14:27:09.260Z |
5417770 | 5417770 | 20241027191218_36ro4 | UK00C7 | 2024-10-30T12:14:26.874Z | 2024-11-05T14:27:08.205Z |
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);