participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,166 rows where station_code = "UK005L" 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 |
---|---|---|---|---|---|
5565378 | 5565378 | 20241120042149_x4jjK | UK005L | 2024-11-21T14:18:47.561Z | 2024-11-21T14:18:54.200Z |
5565165 | 5565165 | 20241120035838_c3qp1 | UK005L | 2024-11-21T14:18:34.726Z | 2024-11-21T14:18:54.165Z |
5565143 | 5565143 | 20241120035640_BCjQl | UK005L | 2024-11-21T14:18:33.820Z | 2024-11-21T14:18:54.162Z |
5564926 | 5564926 | 20241120033942_SXlR2 | UK005L | 2024-11-21T14:18:15.432Z | 2024-11-21T14:18:54.127Z |
5564403 | 5564403 | 20241120025250_gdKlR | UK005L | 2024-11-21T14:17:33.047Z | 2024-11-21T14:18:54.036Z |
5563789 | 5563789 | 20241120020425_FHfTL | UK005L | 2024-11-21T14:16:43.969Z | 2024-11-21T14:18:53.918Z |
5563675 | 5563675 | 20241120015700_hsRmB | UK005L | 2024-11-21T14:16:33.924Z | 2024-11-21T14:18:53.899Z |
5563649 | 5563649 | 20241120015430_O6XYk | UK005L | 2024-11-21T14:16:31.604Z | 2024-11-21T14:18:53.895Z |
5563518 | 5563518 | 20241120013752_Q2EqB | UK005L | 2024-11-21T14:16:14.619Z | 2024-11-21T14:18:53.868Z |
5563356 | 5563356 | 20241120011935_0sJJ1 | UK005L | 2024-11-21T14:15:58.463Z | 2024-11-21T14:18:53.839Z |
5563281 | 5563281 | 20241120011411_nldKo | UK005L | 2024-11-21T14:15:50.816Z | 2024-11-21T14:18:53.824Z |
5563103 | 5563103 | 20241120005255_SpSvv | UK005L | 2024-11-21T14:15:36.930Z | 2024-11-21T14:18:53.791Z |
5563030 | 5563030 | 20241120004428_2z2J3 | UK005L | 2024-11-21T14:15:32.277Z | 2024-11-21T14:18:53.779Z |
5563003 | 5563003 | 20241120003931_y0m2p | UK005L | 2024-11-21T14:15:31.480Z | 2024-11-21T14:18:53.775Z |
5562883 | 5562883 | 20241120002358_gYo9I | UK005L | 2024-11-21T14:15:26.176Z | 2024-11-21T14:18:53.755Z |
5562803 | 5562803 | 20241120001502_OqK8O | UK005L | 2024-11-21T14:15:22.894Z | 2024-11-21T14:18:53.742Z |
5562790 | 5562790 | 20241120001315_dKFjk | UK005L | 2024-11-21T14:15:22.077Z | 2024-11-21T14:18:53.739Z |
5562690 | 5562690 | 20241120000409_CHZ72 | UK005L | 2024-11-21T14:15:17.074Z | 2024-11-21T14:18:53.722Z |
5562687 | 5562687 | 20241120000409_gFlSP | UK005L | 2024-11-21T14:15:16.951Z | 2024-11-21T14:18:53.721Z |
5562600 | 5562600 | 20241119235356_h5w2P | UK005L | 2024-11-21T14:15:12.606Z | 2024-11-21T14:18:53.707Z |
5562512 | 5562512 | 20241119234654_vu1Ot | UK005L | 2024-11-21T14:15:04.064Z | 2024-11-21T14:18:53.696Z |
5562491 | 5562491 | 20241119234356_QWnVi | UK005L | 2024-11-21T14:15:01.604Z | 2024-11-21T14:18:53.693Z |
5562301 | 5562301 | 20241119232023_Fqa4N | UK005L | 2024-11-21T14:14:41.402Z | 2024-11-21T14:18:53.664Z |
5562260 | 5562260 | 20241119231747_w28Oy | UK005L | 2024-11-21T14:14:39.043Z | 2024-11-21T14:18:53.658Z |
5562250 | 5562250 | 20241119231605_1Ydoh | UK005L | 2024-11-21T14:14:36.362Z | 2024-11-21T14:18:53.657Z |
5562216 | 5562216 | 20241119231045_6WxJN | UK005L | 2024-11-21T14:14:33.036Z | 2024-11-21T14:18:53.650Z |
5562087 | 5562087 | 20241119225909_FVmM9 | UK005L | 2024-11-21T14:14:24.236Z | 2024-11-21T14:18:53.632Z |
5561980 | 5561980 | 20241119224031_2Cfjb | UK005L | 2024-11-21T14:14:17.943Z | 2024-11-21T14:18:53.614Z |
5561911 | 5561911 | 20241119222847_Ty2v9 | UK005L | 2024-11-21T14:14:13.547Z | 2024-11-21T14:18:53.601Z |
5561828 | 5561828 | 20241119221514_CIGAA | UK005L | 2024-11-21T14:14:08.993Z | 2024-11-21T14:18:53.588Z |
5561801 | 5561801 | 20241119221228_Hsg7k | UK005L | 2024-11-21T14:14:07.285Z | 2024-11-21T14:18:53.584Z |
5561768 | 5561768 | 20241119220538_WX4WN | UK005L | 2024-11-21T14:14:03.174Z | 2024-11-21T14:18:53.578Z |
5561741 | 5561741 | 20241119215520_AkOLm | UK005L | 2024-11-21T14:13:54.662Z | 2024-11-21T14:18:53.572Z |
5561510 | 5561510 | 20241119205046_pkfsv | UK005L | 2024-11-21T14:13:22.755Z | 2024-11-21T14:18:53.527Z |
5561282 | 5561282 | 20241119193226_pPeru | UK005L | 2024-11-21T14:12:58.899Z | 2024-11-21T14:18:53.456Z |
5561274 | 5561274 | 20241119192548_ycJnq | UK005L | 2024-11-21T14:12:55.964Z | 2024-11-21T14:18:53.454Z |
5561170 | 5561170 | 20241119184908_B1FYX | UK005L | 2024-11-21T14:12:32.393Z | 2024-11-21T14:18:53.423Z |
5561079 | 5561079 | 20241119180057_87fUf | UK005L | 2024-11-21T14:12:20.876Z | 2024-11-21T14:18:53.396Z |
5558542 | 5558542 | 20241120062705_PX2o4 | UK005L | 2024-11-21T14:03:33.631Z | 2024-11-21T14:03:33.631Z |
5558301 | 5558301 | 20241120055255_bP7R8 | UK005L | 2024-11-21T14:02:57.944Z | 2024-11-21T14:02:57.944Z |
5558182 | 5558182 | 20241120054237_zA8hM | UK005L | 2024-11-21T14:02:40.093Z | 2024-11-21T14:02:40.093Z |
5558174 | 5558174 | 20241120054212_4oc2A | UK005L | 2024-11-21T14:02:39.462Z | 2024-11-21T14:02:39.462Z |
5558145 | 5558145 | 20241120054053_Phihz | UK005L | 2024-11-21T14:02:36.615Z | 2024-11-21T14:02:36.615Z |
5543417 | 5543417 | 20241115011343_KGWjg | UK005L | 2024-11-16T14:06:16.210Z | 2024-11-21T14:24:28.030Z |
5543361 | 5543361 | 20241115003749_VDPMs | UK005L | 2024-11-16T14:06:08.948Z | 2024-11-21T14:24:26.840Z |
5543318 | 5543318 | 20241115001013_3w5J3 | UK005L | 2024-11-16T14:06:05.468Z | 2024-11-21T14:24:25.988Z |
5543312 | 5543312 | 20241115000623_h2yWb | UK005L | 2024-11-16T14:06:04.960Z | 2024-11-21T14:24:25.882Z |
5543310 | 5543310 | 20241115000547_Fh97o | UK005L | 2024-11-16T14:06:04.743Z | 2024-11-21T14:24:25.872Z |
5543294 | 5543294 | 20241114235256_f8K3k | UK005L | 2024-11-16T14:06:01.708Z | 2024-11-21T14:24:25.688Z |
5543267 | 5543267 | 20241114233508_gu9X1 | UK005L | 2024-11-16T14:05:56.617Z | 2024-11-21T14:24:25.549Z |
5543236 | 5543236 | 20241114231943_VA9xx | UK005L | 2024-11-16T14:05:48.903Z | 2024-11-21T14:24:25.417Z |
5543220 | 5543220 | 20241114230947_ZgvAD | UK005L | 2024-11-16T14:05:47.570Z | 2024-11-21T14:24:25.337Z |
5543175 | 5543175 | 20241114221848_jDirO | UK005L | 2024-11-16T14:05:39.627Z | 2024-11-21T14:24:24.374Z |
5543168 | 5543168 | 20241114221335_Utfva | UK005L | 2024-11-16T14:05:38.781Z | 2024-11-21T14:24:24.293Z |
5543119 | 5543119 | 20241114210121_IYEN3 | UK005L | 2024-11-16T14:05:33.211Z | 2024-11-21T14:24:23.608Z |
5543095 | 5543095 | 20241114201252_Q3DIG | UK005L | 2024-11-16T14:05:31.030Z | 2024-11-21T14:24:23.002Z |
5543090 | 5543090 | 20241114200356_zTzyC | UK005L | 2024-11-16T14:05:30.459Z | 2024-11-21T14:24:22.930Z |
5543081 | 5543081 | 20241114195422_F5U12 | UK005L | 2024-11-16T14:05:29.630Z | 2024-11-21T14:24:22.810Z |
5543070 | 5543070 | 20241114194418_eLFlK | UK005L | 2024-11-16T14:05:29.064Z | 2024-11-21T14:24:22.759Z |
5543063 | 5543063 | 20241114193924_FabPq | UK005L | 2024-11-16T14:05:28.808Z | 2024-11-21T14:24:22.758Z |
5543055 | 5543055 | 20241114193307_2Bthu | UK005L | 2024-11-16T14:05:28.131Z | 2024-11-21T14:24:22.713Z |
5543027 | 5543027 | 20241114181153_o53Br | UK005L | 2024-11-16T14:05:21.748Z | 2024-11-21T14:24:21.704Z |
5543008 | 5543008 | 20241114175945_p2U3D | UK005L | 2024-11-16T14:05:15.930Z | 2024-11-21T14:24:21.247Z |
5537813 | 5537813 | 20241113004503_ocUPH | UK005L | 2024-11-14T14:12:31.481Z | 2024-11-21T14:26:16.354Z |
5537591 | 5537591 | 20241112235046_GY6A2 | UK005L | 2024-11-14T14:12:14.454Z | 2024-11-21T14:26:14.876Z |
5537436 | 5537436 | 20241112230034_OgL9R | UK005L | 2024-11-14T14:11:47.909Z | 2024-11-21T14:26:12.989Z |
5536468 | 5536468 | 20241112180849_WyCnM | UK005L | 2024-11-14T14:10:00.916Z | 2024-11-21T14:26:01.189Z |
5532879 | 5532879 | 20241113061116_ASQoA | UK005L | 2024-11-14T14:00:27.180Z | 2024-11-21T14:24:41.058Z |
5532702 | 5532702 | 20241112055354_42gIk | UK005L | 2024-11-13T14:17:10.755Z | 2024-11-20T14:26:25.716Z |
5532609 | 5532609 | 20241112054358_jkDzG | UK005L | 2024-11-13T14:17:03.114Z | 2024-11-20T14:26:25.117Z |
5532548 | 5532548 | 20241112053631_2FUZe | UK005L | 2024-11-13T14:16:59.169Z | 2024-11-20T14:26:24.544Z |
5532486 | 5532486 | 20241112052906_9PnEE | UK005L | 2024-11-13T14:16:52.457Z | 2024-11-20T14:26:23.918Z |
5532423 | 5532423 | 20241112051905_X3ecm | UK005L | 2024-11-13T14:16:43.690Z | 2024-11-20T14:26:22.794Z |
5532415 | 5532415 | 20241112051905_73Gir | UK005L | 2024-11-13T14:16:43.359Z | 2024-11-20T14:26:22.752Z |
5532334 | 5532334 | 20241112050905_2DNAF | UK005L | 2024-11-13T14:16:37.771Z | 2024-11-20T14:26:22.105Z |
5532209 | 5532209 | 20241112045210_EbI3i | UK005L | 2024-11-13T14:16:27.342Z | 2024-11-20T14:26:20.910Z |
5532169 | 5532169 | 20241112044706_a7zrw | UK005L | 2024-11-13T14:16:24.226Z | 2024-11-20T14:26:20.546Z |
5531519 | 5531519 | 20241112034655_Z9Z1g | UK005L | 2024-11-13T14:15:43.716Z | 2024-11-20T14:26:11.913Z |
5531503 | 5531503 | 20241112034419_bJZx1 | UK005L | 2024-11-13T14:15:43.042Z | 2024-11-20T14:26:11.844Z |
5531393 | 5531393 | 20241112033532_Ma1gr | UK005L | 2024-11-13T14:15:37.357Z | 2024-11-20T14:26:11.091Z |
5531356 | 5531356 | 20241112033335_rzhbH | UK005L | 2024-11-13T14:15:35.512Z | 2024-11-20T14:26:10.456Z |
5531335 | 5531335 | 20241112033237_gdkef | UK005L | 2024-11-13T14:15:34.805Z | 2024-11-20T14:26:10.408Z |
5531279 | 5531279 | 20241112032838_UxE3o | UK005L | 2024-11-13T14:15:32.493Z | 2024-11-20T14:26:09.784Z |
5530905 | 5530905 | 20241112025906_IKv9G | UK005L | 2024-11-13T14:14:49.862Z | 2024-11-20T14:26:05.154Z |
5530898 | 5530898 | 20241112025856_2nYQc | UK005L | 2024-11-13T14:14:49.259Z | 2024-11-20T14:26:05.129Z |
5530430 | 5530430 | 20241112021641_yvEtG | UK005L | 2024-11-13T14:14:15.212Z | 2024-11-20T14:25:59.728Z |
5530381 | 5530381 | 20241112021443_qBBBz | UK005L | 2024-11-13T14:14:12.837Z | 2024-11-20T14:25:58.312Z |
5530136 | 5530136 | 20241112014932_1CaAt | UK005L | 2024-11-13T14:13:58.282Z | 2024-11-20T14:25:54.833Z |
5530071 | 5530071 | 20241112013942_3ikrN | UK005L | 2024-11-13T14:13:48.124Z | 2024-11-20T14:25:54.060Z |
5529951 | 5529951 | 20241112012839_shM0z | UK005L | 2024-11-13T14:13:27.941Z | 2024-11-20T14:25:51.344Z |
5529862 | 5529862 | 20241112011329_YBdzv | UK005L | 2024-11-13T14:13:16.930Z | 2024-11-20T14:25:50.073Z |
5529768 | 5529768 | 20241112010349_O3R9k | UK005L | 2024-11-13T14:13:09.860Z | 2024-11-20T14:25:48.137Z |
5529477 | 5529477 | 20241112002410_sD5o8 | UK005L | 2024-11-13T14:12:53.249Z | 2024-11-20T14:25:45.450Z |
5528861 | 5528861 | 20241111225642_J67ZV | UK005L | 2024-11-13T14:11:32.274Z | 2024-11-20T14:25:36.773Z |
5528692 | 5528692 | 20241111221949_Zqnei | UK005L | 2024-11-13T14:11:17.567Z | 2024-11-20T14:25:33.947Z |
5528589 | 5528589 | 20241111214601_46jti | UK005L | 2024-11-13T14:11:08.612Z | 2024-11-20T14:25:32.488Z |
5528560 | 5528560 | 20241111213537_0fz8w | UK005L | 2024-11-13T14:11:06.479Z | 2024-11-20T14:25:32.298Z |
5528463 | 5528463 | 20241111210042_hTxoQ | UK005L | 2024-11-13T14:10:45.494Z | 2024-11-20T14:25:30.893Z |
5528220 | 5528220 | 20241111195532_uWUAh | UK005L | 2024-11-13T14:10:16.499Z | 2024-11-20T14:25:26.746Z |
5528191 | 5528191 | 20241111195116_hgeZP | UK005L | 2024-11-13T14:10:14.119Z | 2024-11-20T14:25:26.481Z |
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);