participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,699 rows where station_code = "UK00BK" 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 |
---|---|---|---|---|---|
5570225 | 5570225 | 20241120190505_L7Tn8 | UK00BK | 2024-11-22T14:15:02.330Z | 2024-11-22T14:19:21.882Z |
5570206 | 5570206 | 20241120190318_rWMRF | UK00BK | 2024-11-22T14:15:00.652Z | 2024-11-22T14:19:21.880Z |
5570136 | 5570136 | 20241120184910_TWQP0 | UK00BK | 2024-11-22T14:14:54.400Z | 2024-11-22T14:19:21.868Z |
5570112 | 5570112 | 20241120184222_c9yM4 | UK00BK | 2024-11-22T14:14:52.792Z | 2024-11-22T14:19:21.864Z |
5570049 | 5570049 | 20241120182936_zfOy8 | UK00BK | 2024-11-22T14:14:47.258Z | 2024-11-22T14:19:21.851Z |
5570039 | 5570039 | 20241120182642_YomFa | UK00BK | 2024-11-22T14:14:46.740Z | 2024-11-22T14:19:21.850Z |
5570035 | 5570035 | 20241120182640_kBOXE | UK00BK | 2024-11-22T14:14:46.510Z | 2024-11-22T14:19:21.849Z |
5570009 | 5570009 | 20241120182336_22fr3 | UK00BK | 2024-11-22T14:14:44.759Z | 2024-11-22T14:19:21.845Z |
5569909 | 5569909 | 20241120175618_IUGd9 | UK00BK | 2024-11-22T14:14:33.408Z | 2024-11-22T14:19:21.827Z |
5569817 | 5569817 | 20241120173627_6unxg | UK00BK | 2024-11-22T14:14:16.949Z | 2024-11-22T14:19:21.810Z |
5565381 | 5565381 | 20241120042149_x4jjK | UK00BK | 2024-11-21T14:18:47.561Z | 2024-11-22T14:21:46.292Z |
5565354 | 5565354 | 20241120042057_k2nGT | UK00BK | 2024-11-21T14:18:47.112Z | 2024-11-22T14:21:46.150Z |
5565342 | 5565342 | 20241120041945_krqQU | UK00BK | 2024-11-21T14:18:46.705Z | 2024-11-22T14:21:46.034Z |
5565027 | 5565027 | 20241120034526_fDmL4 | UK00BK | 2024-11-21T14:18:22.320Z | 2024-11-22T14:21:40.429Z |
5564705 | 5564705 | 20241120032124_6mw4v | UK00BK | 2024-11-21T14:17:58.786Z | 2024-11-22T14:21:35.740Z |
5564677 | 5564677 | 20241120031814_zV0ON | UK00BK | 2024-11-21T14:17:57.060Z | 2024-11-22T14:21:35.312Z |
5564141 | 5564141 | 20241120023312_DLvZb | UK00BK | 2024-11-21T14:17:14.026Z | 2024-11-22T14:21:27.568Z |
5563689 | 5563689 | 20241120015732_UwyCr | UK00BK | 2024-11-21T14:16:34.333Z | 2024-11-22T14:21:21.036Z |
5563679 | 5563679 | 20241120015700_hsRmB | UK00BK | 2024-11-21T14:16:33.924Z | 2024-11-22T14:21:20.884Z |
5563520 | 5563520 | 20241120013752_Q2EqB | UK00BK | 2024-11-21T14:16:14.619Z | 2024-11-22T14:21:17.225Z |
5563487 | 5563487 | 20241120013358_SqA4s | UK00BK | 2024-11-21T14:16:10.410Z | 2024-11-22T14:21:16.718Z |
5563108 | 5563108 | 20241120005255_SpSvv | UK00BK | 2024-11-21T14:15:36.930Z | 2024-11-22T14:21:09.646Z |
5563066 | 5563066 | 20241120004816_rqHn5 | UK00BK | 2024-11-21T14:15:34.305Z | 2024-11-22T14:21:08.997Z |
5563034 | 5563034 | 20241120004428_2z2J3 | UK00BK | 2024-11-21T14:15:32.277Z | 2024-11-22T14:21:07.925Z |
5562888 | 5562888 | 20241120002358_gYo9I | UK00BK | 2024-11-21T14:15:26.176Z | 2024-11-22T14:21:05.877Z |
5562556 | 5562556 | 20241119235218_3mUva | UK00BK | 2024-11-21T14:15:08.329Z | 2024-11-22T14:21:00.318Z |
5562481 | 5562481 | 20241119234332_iw52E | UK00BK | 2024-11-21T14:14:59.171Z | 2024-11-22T14:20:59.278Z |
5562306 | 5562306 | 20241119232023_Fqa4N | UK00BK | 2024-11-21T14:14:41.402Z | 2024-11-22T14:20:55.637Z |
5562264 | 5562264 | 20241119231747_w28Oy | UK00BK | 2024-11-21T14:14:39.043Z | 2024-11-22T14:20:54.881Z |
5562254 | 5562254 | 20241119231605_1Ydoh | UK00BK | 2024-11-21T14:14:36.362Z | 2024-11-22T14:20:54.546Z |
5562218 | 5562218 | 20241119231046_ICvUB | UK00BK | 2024-11-21T14:14:33.363Z | 2024-11-22T14:20:54.321Z |
5562091 | 5562091 | 20241119225909_FVmM9 | UK00BK | 2024-11-21T14:14:24.236Z | 2024-11-22T14:20:52.639Z |
5561832 | 5561832 | 20241119221514_CIGAA | UK00BK | 2024-11-21T14:14:08.993Z | 2024-11-22T14:20:47.161Z |
5561770 | 5561770 | 20241119220538_WX4WN | UK00BK | 2024-11-21T14:14:03.174Z | 2024-11-22T14:20:45.792Z |
5561723 | 5561723 | 20241119215023_HX9Nr | UK00BK | 2024-11-21T14:13:51.710Z | 2024-11-22T14:20:44.488Z |
5558434 | 5558434 | 20241120060344_X64I7 | UK00BK | 2024-11-21T14:03:14.601Z | 2024-11-22T14:19:21.227Z |
5558148 | 5558148 | 20241120054053_Phihz | UK00BK | 2024-11-21T14:02:36.646Z | 2024-11-22T14:19:21.185Z |
5548258 | 5548258 | 20241116215433_Qmz2d | UK00BK | 2024-11-18T14:08:34.712Z | 2024-11-22T14:23:11.503Z |
5545059 | 5545059 | 20241115230115_0LjLt | UK00BK | 2024-11-17T14:03:42.360Z | 2024-11-22T14:23:35.669Z |
5543338 | 5543338 | 20241115001812_9T6B2 | UK00BK | 2024-11-16T14:06:07.272Z | 2024-11-22T14:23:58.309Z |
5543323 | 5543323 | 20241115001013_3w5J3 | UK00BK | 2024-11-16T14:06:05.469Z | 2024-11-22T14:23:58.171Z |
5543271 | 5543271 | 20241114233508_gu9X1 | UK00BK | 2024-11-16T14:05:56.617Z | 2024-11-22T14:23:57.825Z |
5543240 | 5543240 | 20241114231943_VA9xx | UK00BK | 2024-11-16T14:05:48.904Z | 2024-11-22T14:23:57.670Z |
5543222 | 5543222 | 20241114230947_ZgvAD | UK00BK | 2024-11-16T14:05:47.571Z | 2024-11-22T14:23:57.592Z |
5543197 | 5543197 | 20241114225317_12wdV | UK00BK | 2024-11-16T14:05:42.592Z | 2024-11-22T14:23:57.424Z |
5543178 | 5543178 | 20241114222307_3ZHKW | UK00BK | 2024-11-16T14:05:39.884Z | 2024-11-22T14:23:57.333Z |
5543151 | 5543151 | 20241114215307_Lw0As | UK00BK | 2024-11-16T14:05:37.277Z | 2024-11-22T14:23:57.210Z |
5543111 | 5543111 | 20241114204122_0sfkc | UK00BK | 2024-11-16T14:05:32.343Z | 2024-11-22T14:23:56.932Z |
5543105 | 5543105 | 20241114203346_WQZQO | UK00BK | 2024-11-16T14:05:31.713Z | 2024-11-22T14:23:56.883Z |
5543099 | 5543099 | 20241114201252_Q3DIG | UK00BK | 2024-11-16T14:05:31.030Z | 2024-11-22T14:23:56.862Z |
5543083 | 5543083 | 20241114195422_F5U12 | UK00BK | 2024-11-16T14:05:29.630Z | 2024-11-22T14:23:56.752Z |
5543067 | 5543067 | 20241114193924_FabPq | UK00BK | 2024-11-16T14:05:28.809Z | 2024-11-22T14:23:56.736Z |
5543058 | 5543058 | 20241114193307_2Bthu | UK00BK | 2024-11-16T14:05:28.131Z | 2024-11-22T14:23:56.700Z |
5543013 | 5543013 | 20241114175945_p2U3D | UK00BK | 2024-11-16T14:05:15.940Z | 2024-11-22T14:23:56.080Z |
5536482 | 5536482 | 20241112181134_vf2eH | UK00BK | 2024-11-14T14:10:02.632Z | 2024-11-21T14:26:01.279Z |
5536442 | 5536442 | 20241112180300_6kbEW | UK00BK | 2024-11-14T14:09:57.058Z | 2024-11-21T14:26:00.958Z |
5536404 | 5536404 | 20241112175513_QDsaD | UK00BK | 2024-11-14T14:09:50.420Z | 2024-11-21T14:26:00.756Z |
5536350 | 5536350 | 20241112174008_p1zVJ | UK00BK | 2024-11-14T14:09:40.873Z | 2024-11-21T14:26:00.249Z |
5532883 | 5532883 | 20241113061116_ASQoA | UK00BK | 2024-11-14T14:00:27.190Z | 2024-11-22T14:24:05.908Z |
5532849 | 5532849 | 20241113060316_oQQWv | UK00BK | 2024-11-14T14:00:23.141Z | 2024-11-22T14:24:05.651Z |
5532827 | 5532827 | 20241113060019_0grst | UK00BK | 2024-11-14T14:00:20.351Z | 2024-11-22T14:24:05.540Z |
5532800 | 5532800 | 20241113055553_hX50i | UK00BK | 2024-11-14T14:00:16.475Z | 2024-11-22T14:24:05.408Z |
5532727 | 5532727 | 20241112055442_TXWVr | UK00BK | 2024-11-13T14:17:12.408Z | 2024-11-20T14:26:25.824Z |
5532504 | 5532504 | 20241112053212_T5Rhi | UK00BK | 2024-11-13T14:16:54.046Z | 2024-11-20T14:26:24.039Z |
5532412 | 5532412 | 20241112051854_pPpoi | UK00BK | 2024-11-13T14:16:43.189Z | 2024-11-20T14:26:22.734Z |
5532276 | 5532276 | 20241112050121_a3oAt | UK00BK | 2024-11-13T14:16:32.601Z | 2024-11-20T14:26:21.527Z |
5532212 | 5532212 | 20241112045210_EbI3i | UK00BK | 2024-11-13T14:16:27.342Z | 2024-11-20T14:26:20.910Z |
5532116 | 5532116 | 20241112043808_aRDCk | UK00BK | 2024-11-13T14:16:19.391Z | 2024-11-20T14:26:18.880Z |
5532082 | 5532082 | 20241112043525_8U3yu | UK00BK | 2024-11-13T14:16:16.604Z | 2024-11-20T14:26:18.596Z |
5531901 | 5531901 | 20241112041724_cVsNG | UK00BK | 2024-11-13T14:16:01.149Z | 2024-11-20T14:26:15.753Z |
5531846 | 5531846 | 20241112041246_z2lyL | UK00BK | 2024-11-13T14:15:58.408Z | 2024-11-20T14:26:15.158Z |
5531822 | 5531822 | 20241112041125_125iz | UK00BK | 2024-11-13T14:15:56.686Z | 2024-11-20T14:26:14.807Z |
5531809 | 5531809 | 20241112041027_pHKRI | UK00BK | 2024-11-13T14:15:55.694Z | 2024-11-20T14:26:14.619Z |
5531724 | 5531724 | 20241112040449_npnA4 | UK00BK | 2024-11-13T14:15:52.527Z | 2024-11-20T14:26:13.692Z |
5531547 | 5531547 | 20241112034808_rwUyy | UK00BK | 2024-11-13T14:15:44.226Z | 2024-11-20T14:26:12.139Z |
5531523 | 5531523 | 20241112034655_Z9Z1g | UK00BK | 2024-11-13T14:15:43.716Z | 2024-11-20T14:26:11.914Z |
5531509 | 5531509 | 20241112034419_bJZx1 | UK00BK | 2024-11-13T14:15:43.042Z | 2024-11-20T14:26:11.844Z |
5531421 | 5531421 | 20241112033848_bGux5 | UK00BK | 2024-11-13T14:15:38.370Z | 2024-11-20T14:26:11.170Z |
5531281 | 5531281 | 20241112032838_UxE3o | UK00BK | 2024-11-13T14:15:32.493Z | 2024-11-20T14:26:09.784Z |
5531076 | 5531076 | 20241112031046_6Vq24 | UK00BK | 2024-11-13T14:15:08.496Z | 2024-11-20T14:26:06.993Z |
5530908 | 5530908 | 20241112025906_IKv9G | UK00BK | 2024-11-13T14:14:49.862Z | 2024-11-20T14:26:05.154Z |
5530880 | 5530880 | 20241112025657_rxk41 | UK00BK | 2024-11-13T14:14:46.909Z | 2024-11-20T14:26:04.368Z |
5530821 | 5530821 | 20241112025032_6ROow | UK00BK | 2024-11-13T14:14:41.838Z | 2024-11-20T14:26:03.895Z |
5530796 | 5530796 | 20241112024803_EztuA | UK00BK | 2024-11-13T14:14:39.180Z | 2024-11-20T14:26:03.655Z |
5530662 | 5530662 | 20241112023707_fc7t3 | UK00BK | 2024-11-13T14:14:26.711Z | 2024-11-20T14:26:02.506Z |
5530569 | 5530569 | 20241112022934_zAz1Y | UK00BK | 2024-11-13T14:14:22.549Z | 2024-11-20T14:26:01.662Z |
5530433 | 5530433 | 20241112021641_yvEtG | UK00BK | 2024-11-13T14:14:15.212Z | 2024-11-20T14:25:59.728Z |
5530420 | 5530420 | 20241112021602_H4CHj | UK00BK | 2024-11-13T14:14:14.420Z | 2024-11-20T14:25:58.498Z |
5530411 | 5530411 | 20241112021547_63DUS | UK00BK | 2024-11-13T14:14:14.340Z | 2024-11-20T14:25:58.474Z |
5530311 | 5530311 | 20241112020721_64kxi | UK00BK | 2024-11-13T14:14:08.048Z | 2024-11-20T14:25:56.826Z |
5530119 | 5530119 | 20241112014611_cJLIH | UK00BK | 2024-11-13T14:13:57.201Z | 2024-11-20T14:25:54.381Z |
5529868 | 5529868 | 20241112011329_YBdzv | UK00BK | 2024-11-13T14:13:16.934Z | 2024-11-20T14:25:50.073Z |
5529465 | 5529465 | 20241112002229_B12OI | UK00BK | 2024-11-13T14:12:52.604Z | 2024-11-20T14:25:45.233Z |
5528966 | 5528966 | 20241111231254_39CCW | UK00BK | 2024-11-13T14:11:48.672Z | 2024-11-20T14:25:37.902Z |
5528796 | 5528796 | 20241111223955_eiMuP | UK00BK | 2024-11-13T14:11:26.827Z | 2024-11-20T14:25:35.852Z |
5528786 | 5528786 | 20241111223911_jk4wz | UK00BK | 2024-11-13T14:11:26.336Z | 2024-11-20T14:25:35.686Z |
5528694 | 5528694 | 20241111221949_Zqnei | UK00BK | 2024-11-13T14:11:17.567Z | 2024-11-20T14:25:33.947Z |
5528678 | 5528678 | 20241111221321_XzxLv | UK00BK | 2024-11-13T14:11:15.758Z | 2024-11-20T14:25:33.533Z |
5528593 | 5528593 | 20241111214601_46jti | UK00BK | 2024-11-13T14:11:08.612Z | 2024-11-20T14:25:32.488Z |
5528563 | 5528563 | 20241111213537_0fz8w | UK00BK | 2024-11-13T14:11:06.479Z | 2024-11-20T14:25:32.298Z |
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);