participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,832 rows where station_code = "UK0086" 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 |
---|---|---|---|---|---|
5129722 | 5129722 | 20240917042446_4c0yQ | UK0086 | 2024-09-19T12:12:02.430Z | 2024-09-19T12:12:02.430Z |
5129405 | 5129405 | 20240917035457_VPmvh | UK0086 | 2024-09-19T12:11:34.640Z | 2024-09-19T12:11:34.640Z |
5129378 | 5129378 | 20240917035455_GRAvj | UK0086 | 2024-09-19T12:11:34.191Z | 2024-09-19T12:11:34.191Z |
5129350 | 5129350 | 20240917035057_b0sYZ | UK0086 | 2024-09-19T12:11:30.380Z | 2024-09-19T12:11:30.380Z |
5128982 | 5128982 | 20240917030348_39vM3 | UK0086 | 2024-09-19T12:11:10.147Z | 2024-09-19T12:11:10.147Z |
5128962 | 5128962 | 20240917030254_NjTz1 | UK0086 | 2024-09-19T12:11:09.512Z | 2024-09-19T12:11:09.512Z |
5128820 | 5128820 | 20240917024456_2qPrg | UK0086 | 2024-09-19T12:11:03.169Z | 2024-09-19T12:11:03.169Z |
5128703 | 5128703 | 20240917022511_pyqVJ | UK0086 | 2024-09-19T12:10:57.603Z | 2024-09-19T12:10:57.603Z |
5116039 | 5116039 | 20240915030422_BjdsF | UK0086 | 2024-09-18T12:06:35.056Z | 2024-09-19T12:19:08.235Z |
5115836 | 5115836 | 20240915025433_9ZS2s | UK0086 | 2024-09-18T12:06:26.622Z | 2024-09-19T12:19:07.441Z |
5115804 | 5115804 | 20240915025401_fOiNa | UK0086 | 2024-09-18T12:06:24.114Z | 2024-09-19T12:19:07.364Z |
5115568 | 5115568 | 20240915024434_7N2Sy | UK0086 | 2024-09-18T12:06:17.831Z | 2024-09-19T12:19:05.367Z |
5114625 | 5114625 | 20240915015225_PAl02 | UK0086 | 2024-09-18T12:05:25.859Z | 2024-09-19T12:18:59.081Z |
5112471 | 5112471 | 20240914231854_40L2a | UK0086 | 2024-09-18T12:03:09.635Z | 2024-09-19T12:18:41.111Z |
5111981 | 5111981 | 20240914214910_80rid | UK0086 | 2024-09-18T12:02:34.800Z | 2024-09-19T12:18:35.985Z |
5107834 | 5107834 | 20240913041158_IXYqC | UK0086 | 2024-09-17T12:13:24.420Z | 2024-09-19T12:20:47.585Z |
5107768 | 5107768 | 20240913040937_NdYVv | UK0086 | 2024-09-17T12:13:23.553Z | 2024-09-19T12:20:47.532Z |
5107667 | 5107667 | 20240913040748_x4tvX | UK0086 | 2024-09-17T12:13:20.791Z | 2024-09-19T12:20:47.446Z |
5106987 | 5106987 | 20240913034133_xmreC | UK0086 | 2024-09-17T12:13:06.308Z | 2024-09-19T12:20:46.740Z |
5106242 | 5106242 | 20240913031554_OvOOU | UK0086 | 2024-09-17T12:12:45.346Z | 2024-09-19T12:20:45.682Z |
5105315 | 5105315 | 20240913024136_GZ2H1 | UK0086 | 2024-09-17T12:12:09.274Z | 2024-09-19T12:20:44.284Z |
5104698 | 5104698 | 20240913021915_IR323 | UK0086 | 2024-09-17T12:11:43.154Z | 2024-09-19T12:20:42.701Z |
5104661 | 5104661 | 20240913021814_1HhV8 | UK0086 | 2024-09-17T12:11:41.919Z | 2024-09-19T12:20:42.659Z |
5098953 | 5098953 | 20240913195847_dt6ZV | UK0086 | 2024-09-17T12:02:04.222Z | 2024-09-19T12:19:42.729Z |
5097464 | 5097464 | 20240913004754_J6VyA | UK0086 | 2024-09-16T12:17:12.871Z | 2024-09-19T12:20:38.647Z |
5089075 | 5089075 | 20240912002541_eQh3U | UK0086 | 2024-09-16T12:11:14.830Z | 2024-09-19T12:21:09.740Z |
5088189 | 5088189 | 20240913000137_JRvC6 | UK0086 | 2024-09-16T12:07:47.876Z | 2024-09-19T12:20:36.490Z |
5088075 | 5088075 | 20240912235528_jrW6p | UK0086 | 2024-09-16T12:07:43.160Z | 2024-09-19T12:20:36.363Z |
5087998 | 5087998 | 20240912235300_5F02O | UK0086 | 2024-09-16T12:07:40.233Z | 2024-09-19T12:20:36.036Z |
5087577 | 5087577 | 20240912233246_VEOWw | UK0086 | 2024-09-16T12:07:05.192Z | 2024-09-19T12:20:35.472Z |
5086674 | 5086674 | 20240912224522_DWUEI | UK0086 | 2024-09-16T12:05:57.448Z | 2024-09-19T12:20:31.529Z |
5086125 | 5086125 | 20240912221057_3Dx3W | UK0086 | 2024-09-16T12:05:15.741Z | 2024-09-19T12:20:30.270Z |
5086049 | 5086049 | 20240912220603_XiyJ3 | UK0086 | 2024-09-16T12:05:11.244Z | 2024-09-19T12:20:30.031Z |
5080630 | 5080630 | 20240911041428_qz1V7 | UK0086 | 2024-09-15T12:17:09.263Z | 2024-09-19T12:21:43.360Z |
5080443 | 5080443 | 20240911035655_GDpAs | UK0086 | 2024-09-15T12:17:03.355Z | 2024-09-19T12:21:43.284Z |
5079126 | 5079126 | 20240911023410_BD2bS | UK0086 | 2024-09-15T12:16:05.913Z | 2024-09-19T12:21:41.146Z |
5079005 | 5079005 | 20240911022847_JrKYR | UK0086 | 2024-09-15T12:16:02.035Z | 2024-09-19T12:21:41.004Z |
5078432 | 5078432 | 20240911015702_JgGz4 | UK0086 | 2024-09-15T12:15:38.674Z | 2024-09-19T12:21:40.390Z |
5077484 | 5077484 | 20240911005815_2yfYi | UK0086 | 2024-09-15T12:14:48.481Z | 2024-09-19T12:21:39.123Z |
5075586 | 5075586 | 20240911235601_smNz5 | UK0086 | 2024-09-15T12:10:02.808Z | 2024-09-19T12:21:09.311Z |
5074190 | 5074190 | 20240911222228_LIrlt | UK0086 | 2024-09-15T12:08:07.487Z | 2024-09-19T12:21:06.975Z |
5073293 | 5073293 | 20240911211315_WGHGw | UK0086 | 2024-09-15T12:07:01.539Z | 2024-09-19T12:21:05.401Z |
5070208 | 5070208 | 20240910224233_3brZu | UK0086 | 2024-09-14T12:20:16.722Z | 2024-09-19T12:21:35.908Z |
5069235 | 5069235 | 20240910212210_LGXr3 | UK0086 | 2024-09-14T12:19:49.482Z | 2024-09-19T12:21:33.995Z |
5060197 | 5060197 | 20240910200706_xPGRx | UK0086 | 2024-09-14T12:08:29.181Z | 2024-09-19T12:21:32.002Z |
5038774 | 5038774 | 20240905214625_ai7Kv | UK0086 | 2024-09-12T12:15:00.410Z | 2024-09-14T12:22:57.926Z |
5038688 | 5038688 | 20240905212437_7AFVq | UK0086 | 2024-09-12T12:14:54.766Z | 2024-09-14T12:22:57.240Z |
5031728 | 5031728 | 20240906230635_PSqd9 | UK0086 | 2024-09-12T12:05:39.971Z | 2024-09-15T12:21:23.955Z |
5031669 | 5031669 | 20240906225504_nXf26 | UK0086 | 2024-09-12T12:05:23.825Z | 2024-09-15T12:21:23.829Z |
5025975 | 5025975 | 20240905015048_QuhmA | UK0086 | 2024-09-11T12:11:39.543Z | 2024-09-13T12:19:56.442Z |
5025920 | 5025920 | 20240905013952_K99S2 | UK0086 | 2024-09-11T12:11:30.292Z | 2024-09-13T12:19:56.203Z |
5025762 | 5025762 | 20240905011152_vrg32 | UK0086 | 2024-09-11T12:10:57.458Z | 2024-09-13T12:19:55.530Z |
5025648 | 5025648 | 20240905004853_aNGYi | UK0086 | 2024-09-11T12:10:42.564Z | 2024-09-13T12:19:54.946Z |
5024349 | 5024349 | 20240905214625_x2kJ0 | UK0086 | 2024-09-11T12:03:25.174Z | 2024-09-11T12:16:32.088Z |
5024262 | 5024262 | 20240905212437_tlFrl | UK0086 | 2024-09-11T12:03:08.454Z | 2024-09-11T12:16:32.039Z |
5020412 | 5020412 | 20240905015048_auHNf | UK0086 | 2024-09-10T12:14:25.224Z | 2024-09-10T12:16:55.145Z |
5020360 | 5020360 | 20240905013952_qkgyI | UK0086 | 2024-09-10T12:14:21.423Z | 2024-09-10T12:16:55.133Z |
5020181 | 5020181 | 20240905011152_ZVdX2 | UK0086 | 2024-09-10T12:14:02.396Z | 2024-09-10T12:16:55.090Z |
5020065 | 5020065 | 20240905004853_OkZWg | UK0086 | 2024-09-10T12:13:53.102Z | 2024-09-10T12:16:55.060Z |
5020033 | 5020033 | 20240905004317_pzyxz | UK0086 | 2024-09-10T12:13:51.056Z | 2024-09-13T12:19:54.880Z |
5019967 | 5019967 | 20240905002946_fzM91 | UK0086 | 2024-09-10T12:13:46.556Z | 2024-09-13T12:19:54.687Z |
5019862 | 5019862 | 20240905000835_txOMo | UK0086 | 2024-09-10T12:13:38.380Z | 2024-09-13T12:19:54.087Z |
5019763 | 5019763 | 20240904234654_NhZup | UK0086 | 2024-09-10T12:13:25.269Z | 2024-09-13T12:19:53.718Z |
5019715 | 5019715 | 20240904234054_AdtPd | UK0086 | 2024-09-10T12:13:17.783Z | 2024-09-13T12:19:53.598Z |
5019627 | 5019627 | 20240904232228_3Sb9P | UK0086 | 2024-09-10T12:13:01.311Z | 2024-09-13T12:19:53.131Z |
5019248 | 5019248 | 20240904221714_SJ5xu | UK0086 | 2024-09-10T12:12:29.233Z | 2024-09-13T12:19:51.135Z |
5019152 | 5019152 | 20240904215655_zBBQ7 | UK0086 | 2024-09-10T12:12:12.583Z | 2024-09-13T12:19:50.751Z |
5019120 | 5019120 | 20240904215326_DzEbh | UK0086 | 2024-09-10T12:12:08.938Z | 2024-09-13T12:19:50.599Z |
5018949 | 5018949 | 20240904211128_YmTYt | UK0086 | 2024-09-10T12:11:48.788Z | 2024-09-13T12:19:49.900Z |
5018907 | 5018907 | 20240904210120_lv9uQ | UK0086 | 2024-09-10T12:11:44.585Z | 2024-09-13T12:19:49.716Z |
5010905 | 5010905 | 20240904035715_0n76X | UK0086 | 2024-09-09T12:09:07.906Z | 2024-09-12T12:19:29.625Z |
5010897 | 5010897 | 20240904035641_GKdJg | UK0086 | 2024-09-09T12:09:07.788Z | 2024-09-12T12:19:29.624Z |
5010714 | 5010714 | 20240904033440_S44Tr | UK0086 | 2024-09-09T12:08:58.317Z | 2024-09-12T12:19:28.756Z |
5010579 | 5010579 | 20240904032005_xOB3r | UK0086 | 2024-09-09T12:08:52.231Z | 2024-09-12T12:19:28.026Z |
5007889 | 5007889 | 20240903223236_2YgVU | UK0086 | 2024-09-09T12:06:11.827Z | 2024-09-12T12:19:15.253Z |
5007840 | 5007840 | 20240903222957_6s3SZ | UK0086 | 2024-09-09T12:06:09.623Z | 2024-09-12T12:19:15.074Z |
5007823 | 5007823 | 20240903222929_OCFB2 | UK0086 | 2024-09-09T12:06:09.423Z | 2024-09-12T12:19:15.051Z |
5007532 | 5007532 | 20240903213359_WIR4i | UK0086 | 2024-09-09T12:05:52.128Z | 2024-09-12T12:19:13.698Z |
4983426 | 4983426 | 20240812004417_Q3cuQ | UK0086 | 2024-09-06T12:15:31.902Z | 2024-09-06T12:15:31.902Z |
4983063 | 4983063 | 20240812004054_1I9gZ | UK0086 | 2024-09-06T12:15:14.249Z | 2024-09-06T12:15:14.249Z |
4983044 | 4983044 | 20240812004045_4i3nE | UK0086 | 2024-09-06T12:15:13.941Z | 2024-09-06T12:15:13.941Z |
4982743 | 4982743 | 20240812003652_ATA90 | UK0086 | 2024-09-06T12:15:00.516Z | 2024-09-06T12:15:00.516Z |
4982649 | 4982649 | 20240812003523_nCcXp | UK0086 | 2024-09-06T12:14:58.125Z | 2024-09-06T12:14:58.125Z |
4982593 | 4982593 | 20240812003455_6SulE | UK0086 | 2024-09-06T12:14:57.086Z | 2024-09-06T12:14:57.086Z |
4981948 | 4981948 | 20240812002833_4A4VD | UK0086 | 2024-09-06T12:14:40.509Z | 2024-09-06T12:14:40.509Z |
4981631 | 4981631 | 20240812002442_AdKGl | UK0086 | 2024-09-06T12:14:34.643Z | 2024-09-06T12:14:34.643Z |
4981562 | 4981562 | 20240812002349_NSHDB | UK0086 | 2024-09-06T12:14:33.508Z | 2024-09-06T12:14:33.508Z |
4981465 | 4981465 | 20240812002230_iu4Lq | UK0086 | 2024-09-06T12:14:32.036Z | 2024-09-06T12:14:32.036Z |
4981361 | 4981361 | 20240812002102_RUdWB | UK0086 | 2024-09-06T12:14:30.046Z | 2024-09-06T12:14:30.046Z |
4981111 | 4981111 | 20240812001850_CDmDw | UK0086 | 2024-09-06T12:14:26.504Z | 2024-09-06T12:14:26.504Z |
4980622 | 4980622 | 20240812001425_S7TA2 | UK0086 | 2024-09-06T12:14:08.837Z | 2024-09-06T12:14:08.837Z |
4980541 | 4980541 | 20240812001342_xpVTU | UK0086 | 2024-09-06T12:14:04.120Z | 2024-09-06T12:14:04.120Z |
4979981 | 4979981 | 20240812000703_mi3b5 | UK0086 | 2024-09-06T12:13:40.066Z | 2024-09-06T12:13:40.066Z |
4979559 | 4979559 | 20240812000229_SGisG | UK0086 | 2024-09-06T12:13:18.872Z | 2024-09-06T12:13:18.872Z |
4979502 | 4979502 | 20240812000217_W2GMv | UK0086 | 2024-09-06T12:13:17.314Z | 2024-09-06T12:13:17.314Z |
4979478 | 4979478 | 20240812000217_9S523 | UK0086 | 2024-09-06T12:13:16.989Z | 2024-09-06T12:13:16.989Z |
4979320 | 4979320 | 20240812000104_LFqNY | UK0086 | 2024-09-06T12:13:09.530Z | 2024-09-06T12:13:09.530Z |
4979298 | 4979298 | 20240812000104_EZSac | UK0086 | 2024-09-06T12:13:09.277Z | 2024-09-06T12:13:09.277Z |
4979239 | 4979239 | 20240812000030_F6Ar5 | UK0086 | 2024-09-06T12:13:06.117Z | 2024-09-06T12:13:06.117Z |
4978902 | 4978902 | 20240811235626_eMuyG | UK0086 | 2024-09-06T12:12:44.856Z | 2024-09-06T12:12:44.856Z |
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);