participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,056 rows where station_code = "UK004M" 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 |
---|---|---|---|---|---|
5134082 | 5134082 | 20240916044441_W5pWv | UK004M | 2024-09-19T12:17:18.307Z | 2024-09-19T12:17:18.307Z |
5133909 | 5133909 | 20240916041721_E4s3T | UK004M | 2024-09-19T12:17:12.837Z | 2024-09-19T12:17:12.837Z |
5133749 | 5133749 | 20240916040217_ygZwe | UK004M | 2024-09-19T12:17:07.115Z | 2024-09-19T12:17:07.115Z |
5133606 | 5133606 | 20240916034705_PIoWD | UK004M | 2024-09-19T12:17:03.786Z | 2024-09-19T12:17:03.786Z |
5133365 | 5133365 | 20240916032738_ALLtX | UK004M | 2024-09-19T12:16:55.567Z | 2024-09-19T12:16:55.567Z |
5133360 | 5133360 | 20240916032711_nyjfs | UK004M | 2024-09-19T12:16:55.473Z | 2024-09-19T12:16:55.473Z |
5133313 | 5133313 | 20240916032117_7nvEr | UK004M | 2024-09-19T12:16:54.232Z | 2024-09-19T12:16:54.232Z |
5133247 | 5133247 | 20240916031230_utz8P | UK004M | 2024-09-19T12:16:51.182Z | 2024-09-19T12:16:51.182Z |
5133216 | 5133216 | 20240916030722_sFNPr | UK004M | 2024-09-19T12:16:49.281Z | 2024-09-19T12:16:49.281Z |
5132914 | 5132914 | 20240916022850_E6Oav | UK004M | 2024-09-19T12:16:35.911Z | 2024-09-19T12:16:35.911Z |
5132825 | 5132825 | 20240916021859_71Yfn | UK004M | 2024-09-19T12:16:33.753Z | 2024-09-19T12:16:33.753Z |
5132807 | 5132807 | 20240916021515_8gZYt | UK004M | 2024-09-19T12:16:33.366Z | 2024-09-19T12:16:33.366Z |
5132781 | 5132781 | 20240916021145_oEK6D | UK004M | 2024-09-19T12:16:32.426Z | 2024-09-19T12:16:32.426Z |
5132605 | 5132605 | 20240916014141_JHh9m | UK004M | 2024-09-19T12:16:22.142Z | 2024-09-19T12:16:22.142Z |
5132417 | 5132417 | 20240916010337_TVfA4 | UK004M | 2024-09-19T12:16:11.783Z | 2024-09-19T12:16:11.783Z |
5132280 | 5132280 | 20240916002247_DHiwZ | UK004M | 2024-09-19T12:16:03.153Z | 2024-09-19T12:16:03.153Z |
5132090 | 5132090 | 20240915231547_3YwJz | UK004M | 2024-09-19T12:15:49.660Z | 2024-09-19T12:15:49.660Z |
5132054 | 5132054 | 20240915225744_eOKkS | UK004M | 2024-09-19T12:15:46.649Z | 2024-09-19T12:15:46.649Z |
5132016 | 5132016 | 20240915224843_JvzYU | UK004M | 2024-09-19T12:15:43.933Z | 2024-09-19T12:15:43.933Z |
5129868 | 5129868 | 20240917044809_ht3nv | UK004M | 2024-09-19T12:12:11.478Z | 2024-09-19T12:12:11.478Z |
5129835 | 5129835 | 20240917043812_1G37g | UK004M | 2024-09-19T12:12:08.082Z | 2024-09-19T12:12:08.082Z |
5129788 | 5129788 | 20240917042906_nevS9 | UK004M | 2024-09-19T12:12:04.758Z | 2024-09-19T12:12:04.758Z |
5129655 | 5129655 | 20240917042119_UWnWe | UK004M | 2024-09-19T12:12:00.121Z | 2024-09-19T12:12:00.121Z |
5129295 | 5129295 | 20240917034630_6Zgnr | UK004M | 2024-09-19T12:11:26.313Z | 2024-09-19T12:11:26.313Z |
5129228 | 5129228 | 20240917033849_JFQoF | UK004M | 2024-09-19T12:11:23.654Z | 2024-09-19T12:11:23.654Z |
5129186 | 5129186 | 20240917033424_3aRqg | UK004M | 2024-09-19T12:11:22.582Z | 2024-09-19T12:11:22.582Z |
5128990 | 5128990 | 20240917030359_i26mR | UK004M | 2024-09-19T12:11:10.426Z | 2024-09-19T12:11:10.426Z |
5128927 | 5128927 | 20240917025710_dO20e | UK004M | 2024-09-19T12:11:07.994Z | 2024-09-19T12:11:07.994Z |
5128798 | 5128798 | 20240917024140_PzyIq | UK004M | 2024-09-19T12:11:02.444Z | 2024-09-19T12:11:02.444Z |
5128756 | 5128756 | 20240917023136_SKu3T | UK004M | 2024-09-19T12:10:59.997Z | 2024-09-19T12:10:59.997Z |
5128587 | 5128587 | 20240917020759_7vm3g | UK004M | 2024-09-19T12:10:46.472Z | 2024-09-19T12:10:46.472Z |
5128296 | 5128296 | 20240917012201_PHVbY | UK004M | 2024-09-19T12:10:25.679Z | 2024-09-19T12:10:25.679Z |
5128186 | 5128186 | 20240917010457_029vC | UK004M | 2024-09-19T12:10:19.784Z | 2024-09-19T12:10:19.784Z |
5128064 | 5128064 | 20240917003155_vMecy | UK004M | 2024-09-19T12:09:59.460Z | 2024-09-19T12:09:59.460Z |
5127978 | 5127978 | 20240917001543_z3xIM | UK004M | 2024-09-19T12:09:51.875Z | 2024-09-19T12:09:51.875Z |
5127968 | 5127968 | 20240917001114_tyHjc | UK004M | 2024-09-19T12:09:49.525Z | 2024-09-19T12:09:49.525Z |
5127830 | 5127830 | 20240916234359_kBzyE | UK004M | 2024-09-19T12:09:41.821Z | 2024-09-19T12:09:41.821Z |
5127801 | 5127801 | 20240916233537_Vtufh | UK004M | 2024-09-19T12:09:40.029Z | 2024-09-19T12:09:40.029Z |
5127731 | 5127731 | 20240916231523_C4vek | UK004M | 2024-09-19T12:09:34.971Z | 2024-09-19T12:09:34.971Z |
5127382 | 5127382 | 20240916214237_wssGw | UK004M | 2024-09-19T12:09:01.131Z | 2024-09-19T12:09:01.131Z |
5127192 | 5127192 | 20240916205107_WsenZ | UK004M | 2024-09-19T12:08:29.555Z | 2024-09-19T12:08:29.555Z |
5125880 | 5125880 | 20240918041720_CEfQ8 | UK004M | 2024-09-19T12:04:27.810Z | 2024-09-19T12:06:42.100Z |
5125830 | 5125830 | 20240918040312_AqG2m | UK004M | 2024-09-19T12:04:11.508Z | 2024-09-19T12:06:42.092Z |
5125815 | 5125815 | 20240918040130_YLfjc | UK004M | 2024-09-19T12:04:09.922Z | 2024-09-19T12:06:42.090Z |
5125487 | 5125487 | 20240918024913_3ePAR | UK004M | 2024-09-19T12:03:21.989Z | 2024-09-19T12:06:42.041Z |
5125485 | 5125485 | 20240918024811_fOyKe | UK004M | 2024-09-19T12:03:21.446Z | 2024-09-19T12:06:42.041Z |
5125426 | 5125426 | 20240918023604_GEYsf | UK004M | 2024-09-19T12:03:13.502Z | 2024-09-19T12:06:42.031Z |
5125287 | 5125287 | 20240918015530_VE2UK | UK004M | 2024-09-19T12:02:41.158Z | 2024-09-19T12:06:42.005Z |
5125184 | 5125184 | 20240918010155_AU8rk | UK004M | 2024-09-19T12:02:27.873Z | 2024-09-19T12:06:41.988Z |
5125148 | 5125148 | 20240918003320_5ZH52 | UK004M | 2024-09-19T12:02:24.056Z | 2024-09-19T12:06:41.982Z |
5125052 | 5125052 | 20240917235057_vWFUY | UK004M | 2024-09-19T12:02:03.105Z | 2024-09-19T12:06:41.968Z |
5125026 | 5125026 | 20240917233324_zj5tc | UK004M | 2024-09-19T12:01:57.513Z | 2024-09-19T12:06:41.963Z |
5124945 | 5124945 | 20240917225608_CRlD2 | UK004M | 2024-09-19T12:01:50.474Z | 2024-09-19T12:06:41.955Z |
5124836 | 5124836 | 20240917221520_RcOc1 | UK004M | 2024-09-19T12:01:39.490Z | 2024-09-19T12:06:41.941Z |
5124782 | 5124782 | 20240917220112_DZ7h4 | UK004M | 2024-09-19T12:01:35.012Z | 2024-09-19T12:06:41.935Z |
5124682 | 5124682 | 20240917214723_Gu1OG | UK004M | 2024-09-19T12:01:19.282Z | 2024-09-19T12:06:41.924Z |
5121612 | 5121612 | 20240914041027_ZjFMf | UK004M | 2024-09-18T12:10:58.865Z | 2024-09-19T12:20:02.185Z |
5120902 | 5120902 | 20240914034045_yYbUJ | UK004M | 2024-09-18T12:10:48.587Z | 2024-09-19T12:20:01.026Z |
5112925 | 5112925 | 20240915000653_3UA7I | UK004M | 2024-09-18T12:03:47.606Z | 2024-09-19T12:18:45.881Z |
5112789 | 5112789 | 20240914235504_i9EIY | UK004M | 2024-09-18T12:03:33.113Z | 2024-09-19T12:18:44.783Z |
5112137 | 5112137 | 20240914222523_j8gmB | UK004M | 2024-09-18T12:02:49.675Z | 2024-09-19T12:18:38.641Z |
5112117 | 5112117 | 20240914221653_IlpIA | UK004M | 2024-09-18T12:02:48.815Z | 2024-09-19T12:18:38.503Z |
5111356 | 5111356 | 20240914202700_N5sBV | UK004M | 2024-09-18T12:01:51.851Z | 2024-09-19T12:18:29.324Z |
5111284 | 5111284 | 20240914201839_S28a3 | UK004M | 2024-09-18T12:01:47.175Z | 2024-09-19T12:18:28.365Z |
5111187 | 5111187 | 20240914201007_8Xvja | UK004M | 2024-09-18T12:01:42.468Z | 2024-09-19T12:18:27.298Z |
5107505 | 5107505 | 20240913035831_fqGqQ | UK004M | 2024-09-17T12:13:16.408Z | 2024-09-19T12:20:47.195Z |
5107466 | 5107466 | 20240913035738_DTVj0 | UK004M | 2024-09-17T12:13:15.823Z | 2024-09-19T12:20:47.166Z |
5107337 | 5107337 | 20240913035258_hNvZE | UK004M | 2024-09-17T12:13:13.458Z | 2024-09-19T12:20:47.004Z |
5107046 | 5107046 | 20240913034223_r2lZE | UK004M | 2024-09-17T12:13:08.371Z | 2024-09-19T12:20:46.793Z |
5105653 | 5105653 | 20240913025422_EJDL8 | UK004M | 2024-09-17T12:12:24.660Z | 2024-09-19T12:20:44.774Z |
5105606 | 5105606 | 20240913025303_QHYDa | UK004M | 2024-09-17T12:12:23.394Z | 2024-09-19T12:20:44.720Z |
5105529 | 5105529 | 20240913025045_RQ9P7 | UK004M | 2024-09-17T12:12:20.511Z | 2024-09-19T12:20:44.646Z |
5105071 | 5105071 | 20240913022912_8OVX2 | UK004M | 2024-09-17T12:11:52.624Z | 2024-09-19T12:20:43.461Z |
5104814 | 5104814 | 20240913022148_1xM2P | UK004M | 2024-09-17T12:11:45.169Z | 2024-09-19T12:20:42.918Z |
5104588 | 5104588 | 20240913021608_X6kAk | UK004M | 2024-09-17T12:11:40.204Z | 2024-09-19T12:20:42.527Z |
5104002 | 5104002 | 20240913014710_Rac2v | UK004M | 2024-09-17T12:11:21.840Z | 2024-09-19T12:20:40.824Z |
5103578 | 5103578 | 20240913013228_L7h3t | UK004M | 2024-09-17T12:11:04.164Z | 2024-09-19T12:20:40.295Z |
5102059 | 5102059 | 20240914010355_421f7 | UK004M | 2024-09-17T12:06:45.459Z | 2024-09-19T12:19:52.324Z |
5101550 | 5101550 | 20240914003434_G09VS | UK004M | 2024-09-17T12:06:00.757Z | 2024-09-19T12:19:50.925Z |
5101248 | 5101248 | 20240914001545_NA6Y0 | UK004M | 2024-09-17T12:05:29.326Z | 2024-09-19T12:19:50.093Z |
5101238 | 5101238 | 20240914001528_ZXffw | UK004M | 2024-09-17T12:05:29.036Z | 2024-09-19T12:19:50.090Z |
5101211 | 5101211 | 20240914001349_Agbl2 | UK004M | 2024-09-17T12:05:26.830Z | 2024-09-19T12:19:50.061Z |
5101106 | 5101106 | 20240914000502_3zCoJ | UK004M | 2024-09-17T12:05:20.732Z | 2024-09-19T12:19:49.797Z |
5098265 | 5098265 | 20240913012337_vixWd | UK004M | 2024-09-16T12:17:22.125Z | 2024-09-19T12:20:39.984Z |
5098184 | 5098184 | 20240913012113_r9smX | UK004M | 2024-09-16T12:17:21.527Z | 2024-09-19T12:20:39.830Z |
5097273 | 5097273 | 20240913003832_Ye3ds | UK004M | 2024-09-16T12:17:09.387Z | 2024-09-19T12:20:38.025Z |
5093487 | 5093487 | 20240912032416_GPhfk | UK004M | 2024-09-16T12:14:18.684Z | 2024-09-19T12:21:15.372Z |
5092980 | 5092980 | 20240912030408_lW41p | UK004M | 2024-09-16T12:14:08.734Z | 2024-09-19T12:21:14.778Z |
5092916 | 5092916 | 20240912030140_a5chr | UK004M | 2024-09-16T12:14:07.127Z | 2024-09-19T12:21:14.709Z |
5089406 | 5089406 | 20240912003901_d5ceS | UK004M | 2024-09-16T12:11:22.643Z | 2024-09-19T12:21:09.914Z |
5088757 | 5088757 | 20240913002513_hof5S | UK004M | 2024-09-16T12:08:29.354Z | 2024-09-19T12:20:37.273Z |
5088555 | 5088555 | 20240913001629_5UXsP | UK004M | 2024-09-16T12:08:11.854Z | 2024-09-19T12:20:37.012Z |
5087588 | 5087588 | 20240912233251_v8XIb | UK004M | 2024-09-16T12:07:05.518Z | 2024-09-19T12:20:35.476Z |
5087432 | 5087432 | 20240912232741_wONYc | UK004M | 2024-09-16T12:06:55.873Z | 2024-09-19T12:20:34.822Z |
5087414 | 5087414 | 20240912232647_kEZSY | UK004M | 2024-09-16T12:06:55.583Z | 2024-09-19T12:20:34.822Z |
5086529 | 5086529 | 20240912223949_nIAn3 | UK004M | 2024-09-16T12:05:51.326Z | 2024-09-19T12:20:31.399Z |
5085637 | 5085637 | 20240912213757_9prHO | UK004M | 2024-09-16T12:04:32.668Z | 2024-09-19T12:20:29.314Z |
5084937 | 5084937 | 20240912203401_fFShU | UK004M | 2024-09-16T12:03:16.052Z | 2024-09-19T12:20:27.518Z |
5084838 | 5084838 | 20240912201936_l1Y3q | UK004M | 2024-09-16T12:03:00.673Z | 2024-09-19T12:20:27.301Z |
5076106 | 5076106 | 20240910230738_weRAL | UK004M | 2024-09-15T12:13:18.231Z | 2024-09-19T12:21:36.452Z |
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);