participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
978 rows where station_code = "UK00A3" 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 |
---|---|---|---|---|---|
5131884 | 5131884 | 20240915220029_xDUD3 | UK00A3 | 2024-09-19T12:15:32.238Z | 2024-09-19T12:15:32.238Z |
5131522 | 5131522 | 20240915200850_koie8 | UK00A3 | 2024-09-19T12:15:07.407Z | 2024-09-19T12:15:07.407Z |
5129828 | 5129828 | 20240917043803_3TXdS | UK00A3 | 2024-09-19T12:12:07.586Z | 2024-09-19T12:12:07.586Z |
5129806 | 5129806 | 20240917043553_4Zu1t | UK00A3 | 2024-09-19T12:12:06.230Z | 2024-09-19T12:12:06.230Z |
5129702 | 5129702 | 20240917042320_qWoHt | UK00A3 | 2024-09-19T12:12:01.421Z | 2024-09-19T12:12:01.421Z |
5129618 | 5129618 | 20240917041350_8Ytfi | UK00A3 | 2024-09-19T12:11:54.024Z | 2024-09-19T12:11:54.024Z |
5129466 | 5129466 | 20240917035905_c8PfO | UK00A3 | 2024-09-19T12:11:40.597Z | 2024-09-19T12:11:40.597Z |
5129178 | 5129178 | 20240917033229_xPsAK | UK00A3 | 2024-09-19T12:11:20.422Z | 2024-09-19T12:11:20.422Z |
5129047 | 5129047 | 20240917031136_L1khT | UK00A3 | 2024-09-19T12:11:12.675Z | 2024-09-19T12:11:12.675Z |
5128966 | 5128966 | 20240917030254_NjTz1 | UK00A3 | 2024-09-19T12:11:09.512Z | 2024-09-19T12:11:09.512Z |
5128951 | 5128951 | 20240917030146_KRAl1 | UK00A3 | 2024-09-19T12:11:09.333Z | 2024-09-19T12:11:09.333Z |
5128807 | 5128807 | 20240917024150_rcFBd | UK00A3 | 2024-09-19T12:11:02.693Z | 2024-09-19T12:11:02.693Z |
5127450 | 5127450 | 20240916215228_fyYNu | UK00A3 | 2024-09-19T12:09:07.598Z | 2024-09-19T12:09:07.598Z |
5127373 | 5127373 | 20240916213800_XYuxG | UK00A3 | 2024-09-19T12:09:00.372Z | 2024-09-19T12:09:00.372Z |
5127340 | 5127340 | 20240916213349_JBE61 | UK00A3 | 2024-09-19T12:08:55.257Z | 2024-09-19T12:08:55.257Z |
5127108 | 5127108 | 20240916202354_hctKj | UK00A3 | 2024-09-19T12:08:12.563Z | 2024-09-19T12:08:12.563Z |
5126996 | 5126996 | 20240916200351_LJ4N3 | UK00A3 | 2024-09-19T12:07:50.490Z | 2024-09-19T12:07:50.490Z |
5125706 | 5125706 | 20240918032323_noyc7 | UK00A3 | 2024-09-19T12:03:55.187Z | 2024-09-19T12:06:42.072Z |
5125618 | 5125618 | 20240918030921_2oCNg | UK00A3 | 2024-09-19T12:03:44.231Z | 2024-09-19T12:06:42.059Z |
5125605 | 5125605 | 20240918030813_7iGdt | UK00A3 | 2024-09-19T12:03:39.236Z | 2024-09-19T12:06:42.057Z |
5125574 | 5125574 | 20240918030226_UqiMr | UK00A3 | 2024-09-19T12:03:33.508Z | 2024-09-19T12:06:42.053Z |
5125529 | 5125529 | 20240918025434_wsLK5 | UK00A3 | 2024-09-19T12:03:27.256Z | 2024-09-19T12:06:42.047Z |
5125420 | 5125420 | 20240918023424_eVrc3 | UK00A3 | 2024-09-19T12:03:12.469Z | 2024-09-19T12:06:42.030Z |
5125318 | 5125318 | 20240918020530_3UEta | UK00A3 | 2024-09-19T12:02:48.302Z | 2024-09-19T12:06:42.011Z |
5124824 | 5124824 | 20240917221045_2PT9s | UK00A3 | 2024-09-19T12:01:38.289Z | 2024-09-19T12:06:41.939Z |
5124744 | 5124744 | 20240917215711_Pr9ND | UK00A3 | 2024-09-19T12:01:30.815Z | 2024-09-19T12:06:41.930Z |
5116248 | 5116248 | 20240915031733_AnGNx | UK00A3 | 2024-09-18T12:06:50.909Z | 2024-09-19T12:19:09.969Z |
5116214 | 5116214 | 20240915031627_Ym6j5 | UK00A3 | 2024-09-18T12:06:49.288Z | 2024-09-19T12:19:09.905Z |
5114718 | 5114718 | 20240915015631_n0HEH | UK00A3 | 2024-09-18T12:05:31.661Z | 2024-09-19T12:18:59.594Z |
5113533 | 5113533 | 20240915005619_DAKxN | UK00A3 | 2024-09-18T12:04:26.685Z | 2024-09-19T12:18:50.056Z |
5113128 | 5113128 | 20240915002347_Y6L38 | UK00A3 | 2024-09-18T12:03:57.706Z | 2024-09-19T12:18:47.176Z |
5112749 | 5112749 | 20240914234820_iCJNL | UK00A3 | 2024-09-18T12:03:27.224Z | 2024-09-19T12:18:44.245Z |
5112681 | 5112681 | 20240914234107_Ez1zg | UK00A3 | 2024-09-18T12:03:21.471Z | 2024-09-19T12:18:42.997Z |
5112593 | 5112593 | 20240914233034_ABu4f | UK00A3 | 2024-09-18T12:03:15.509Z | 2024-09-19T12:18:41.527Z |
5112463 | 5112463 | 20240914231847_2KZA0 | UK00A3 | 2024-09-18T12:03:09.177Z | 2024-09-19T12:18:41.085Z |
5112176 | 5112176 | 20240914222909_kcMX7 | UK00A3 | 2024-09-18T12:02:51.441Z | 2024-09-19T12:18:38.895Z |
5112019 | 5112019 | 20240914215552_GbIcL | UK00A3 | 2024-09-18T12:02:40.190Z | 2024-09-19T12:18:36.592Z |
5111967 | 5111967 | 20240914214807_yraDw | UK00A3 | 2024-09-18T12:02:33.643Z | 2024-09-19T12:18:35.830Z |
5111894 | 5111894 | 20240914213134_Iov9u | UK00A3 | 2024-09-18T12:02:28.899Z | 2024-09-19T12:18:34.928Z |
5111870 | 5111870 | 20240914212821_HSXZa | UK00A3 | 2024-09-18T12:02:27.022Z | 2024-09-19T12:18:34.792Z |
5110421 | 5110421 | 20240910224240_Q1l5m | UK00A3 | 2024-09-17T12:17:51.503Z | 2024-09-19T12:21:35.911Z |
5107378 | 5107378 | 20240913035337_cxzYp | UK00A3 | 2024-09-17T12:13:13.774Z | 2024-09-19T12:20:47.026Z |
5107299 | 5107299 | 20240913035206_SCEhV | UK00A3 | 2024-09-17T12:13:12.728Z | 2024-09-19T12:20:46.989Z |
5107265 | 5107265 | 20240913034944_bhuPa | UK00A3 | 2024-09-17T12:13:11.937Z | 2024-09-19T12:20:46.967Z |
5106939 | 5106939 | 20240913033909_P0dHA | UK00A3 | 2024-09-17T12:13:04.334Z | 2024-09-19T12:20:46.587Z |
5106863 | 5106863 | 20240913033726_7td3P | UK00A3 | 2024-09-17T12:13:03.267Z | 2024-09-19T12:20:46.496Z |
5106727 | 5106727 | 20240913033253_CvuB0 | UK00A3 | 2024-09-17T12:12:59.907Z | 2024-09-19T12:20:46.301Z |
5102276 | 5102276 | 20240914011508_5KWPl | UK00A3 | 2024-09-17T12:06:57.493Z | 2024-09-19T12:19:53.183Z |
5098065 | 5098065 | 20240913011525_idCZ7 | UK00A3 | 2024-09-16T12:17:19.217Z | 2024-09-19T12:20:39.592Z |
5098039 | 5098039 | 20240913011427_WFnVw | UK00A3 | 2024-09-16T12:17:18.701Z | 2024-09-19T12:20:39.553Z |
5097834 | 5097834 | 20240913010517_XnRX4 | UK00A3 | 2024-09-16T12:17:15.292Z | 2024-09-19T12:20:39.042Z |
5097200 | 5097200 | 20240913003528_pZ3pP | UK00A3 | 2024-09-16T12:17:07.463Z | 2024-09-19T12:20:37.842Z |
5097189 | 5097189 | 20240913003527_hiq3W | UK00A3 | 2024-09-16T12:17:07.449Z | 2024-09-19T12:20:37.840Z |
5092734 | 5092734 | 20240912025521_FWK32 | UK00A3 | 2024-09-16T12:14:02.785Z | 2024-09-19T12:21:14.441Z |
5092647 | 5092647 | 20240912025337_I2LM8 | UK00A3 | 2024-09-16T12:14:01.311Z | 2024-09-19T12:21:14.385Z |
5092624 | 5092624 | 20240912025336_POIHD | UK00A3 | 2024-09-16T12:14:01.048Z | 2024-09-19T12:21:14.379Z |
5091944 | 5091944 | 20240912023113_Uiz0k | UK00A3 | 2024-09-16T12:13:33.167Z | 2024-09-19T12:21:13.524Z |
5091874 | 5091874 | 20240912022558_vgYRn | UK00A3 | 2024-09-16T12:13:28.422Z | 2024-09-19T12:21:13.430Z |
5091817 | 5091817 | 20240912022400_HsYyS | UK00A3 | 2024-09-16T12:13:25.412Z | 2024-09-19T12:21:13.407Z |
5091542 | 5091542 | 20240912021305_deW3K | UK00A3 | 2024-09-16T12:13:09.941Z | 2024-09-19T12:21:13.187Z |
5089083 | 5089083 | 20240912002541_eQh3U | UK00A3 | 2024-09-16T12:11:14.830Z | 2024-09-19T12:21:09.740Z |
5088527 | 5088527 | 20240913001444_yxaui | UK00A3 | 2024-09-16T12:08:08.729Z | 2024-09-19T12:20:36.984Z |
5088004 | 5088004 | 20240912235300_5F02O | UK00A3 | 2024-09-16T12:07:40.233Z | 2024-09-19T12:20:36.036Z |
5087352 | 5087352 | 20240912232406_fvdz3 | UK00A3 | 2024-09-16T12:06:52.789Z | 2024-09-19T12:20:34.682Z |
5087141 | 5087141 | 20240912230949_liacV | UK00A3 | 2024-09-16T12:06:41.077Z | 2024-09-19T12:20:34.039Z |
5086836 | 5086836 | 20240912225134_xVkP4 | UK00A3 | 2024-09-16T12:06:09.109Z | 2024-09-19T12:20:32.704Z |
5086294 | 5086294 | 20240912222528_j5yYN | UK00A3 | 2024-09-16T12:05:29.481Z | 2024-09-19T12:20:30.748Z |
5084927 | 5084927 | 20240912203250_OUYjx | UK00A3 | 2024-09-16T12:03:13.205Z | 2024-09-19T12:20:27.487Z |
5078131 | 5078131 | 20240911014006_hWJHV | UK00A3 | 2024-09-15T12:15:20.963Z | 2024-09-19T12:21:40.009Z |
5077955 | 5077955 | 20240911013233_sac27 | UK00A3 | 2024-09-15T12:15:12.351Z | 2024-09-19T12:21:39.808Z |
5077775 | 5077775 | 20240911011636_wlNEQ | UK00A3 | 2024-09-15T12:15:04.165Z | 2024-09-19T12:21:39.632Z |
5077568 | 5077568 | 20240911010340_VShdo | UK00A3 | 2024-09-15T12:14:52.814Z | 2024-09-19T12:21:39.377Z |
5077550 | 5077550 | 20240911010335_fgfZw | UK00A3 | 2024-09-15T12:14:52.340Z | 2024-09-19T12:21:39.374Z |
5077446 | 5077446 | 20240911005326_jfFqt | UK00A3 | 2024-09-15T12:14:45.437Z | 2024-09-19T12:21:38.999Z |
5077378 | 5077378 | 20240911004817_zM5Vh | UK00A3 | 2024-09-15T12:14:40.439Z | 2024-09-19T12:21:38.791Z |
5077150 | 5077150 | 20240911002609_hNzOa | UK00A3 | 2024-09-15T12:14:25.089Z | 2024-09-19T12:21:38.283Z |
5077131 | 5077131 | 20240911002559_5PHBU | UK00A3 | 2024-09-15T12:14:24.486Z | 2024-09-19T12:21:38.217Z |
5077055 | 5077055 | 20240911002232_UOycP | UK00A3 | 2024-09-15T12:14:19.012Z | 2024-09-19T12:21:37.984Z |
5077032 | 5077032 | 20240911002206_32bac | UK00A3 | 2024-09-15T12:14:18.338Z | 2024-09-19T12:21:37.983Z |
5076951 | 5076951 | 20240911001619_p32iF | UK00A3 | 2024-09-15T12:14:14.202Z | 2024-09-19T12:21:37.869Z |
5075059 | 5075059 | 20240911232531_2Pxpf | UK00A3 | 2024-09-15T12:09:21.442Z | 2024-09-19T12:21:08.063Z |
5074559 | 5074559 | 20240911224523_TV37J | UK00A3 | 2024-09-15T12:08:36.644Z | 2024-09-19T12:21:07.381Z |
5074017 | 5074017 | 20240911220645_MqLLh | UK00A3 | 2024-09-15T12:07:51.425Z | 2024-09-19T12:21:06.853Z |
5073656 | 5073656 | 20240911213807_8EJit | UK00A3 | 2024-09-15T12:07:29.377Z | 2024-09-19T12:21:06.130Z |
5073622 | 5073622 | 20240911213331_4GPJi | UK00A3 | 2024-09-15T12:07:23.466Z | 2024-09-19T12:21:06.056Z |
5070101 | 5070101 | 20240910223342_6lxPN | UK00A3 | 2024-09-14T12:20:14.307Z | 2024-09-19T12:21:35.757Z |
5060595 | 5060595 | 20240910204043_LX9k3 | UK00A3 | 2024-09-14T12:09:10.644Z | 2024-09-19T12:21:33.105Z |
5039416 | 5039416 | 20240906005221_0DFmz | UK00A3 | 2024-09-12T12:15:31.601Z | 2024-09-14T12:23:01.982Z |
5039351 | 5039351 | 20240906002910_akrxp | UK00A3 | 2024-09-12T12:15:27.577Z | 2024-09-14T12:23:01.469Z |
5039241 | 5039241 | 20240905235842_7fOCb | UK00A3 | 2024-09-12T12:15:22.204Z | 2024-09-14T12:23:01.036Z |
5039096 | 5039096 | 20240905232017_NfuAM | UK00A3 | 2024-09-12T12:15:15.432Z | 2024-09-14T12:23:00.086Z |
5038872 | 5038872 | 20240905222436_Px93M | UK00A3 | 2024-09-12T12:15:05.648Z | 2024-09-14T12:22:58.904Z |
5038850 | 5038850 | 20240905221802_E6NYE | UK00A3 | 2024-09-12T12:15:04.650Z | 2024-09-14T12:22:58.632Z |
5033287 | 5033287 | 20240907024431_2a1Da | UK00A3 | 2024-09-12T12:09:05.026Z | 2024-09-15T12:21:29.503Z |
5032670 | 5032670 | 20240907012716_MI5ty | UK00A3 | 2024-09-12T12:07:50.189Z | 2024-09-15T12:21:27.308Z |
5032615 | 5032615 | 20240907012121_CcRAA | UK00A3 | 2024-09-12T12:07:45.138Z | 2024-09-15T12:21:27.150Z |
5032609 | 5032609 | 20240907012105_Yuk2E | UK00A3 | 2024-09-12T12:07:44.594Z | 2024-09-15T12:21:27.022Z |
5031857 | 5031857 | 20240906233231_KJL0L | UK00A3 | 2024-09-12T12:05:56.948Z | 2024-09-15T12:21:24.442Z |
5031801 | 5031801 | 20240906232033_BrgT6 | UK00A3 | 2024-09-12T12:05:50.198Z | 2024-09-15T12:21:24.335Z |
5025051 | 5025051 | 20240906005221_iuzSI | UK00A3 | 2024-09-11T12:05:30.332Z | 2024-09-14T12:23:01.972Z |
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);