participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,455 rows where station_code = "UK006J" 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 |
---|---|---|---|---|---|
5132521 | 5132521 | 20240916012417_VjU0M | UK006J | 2024-09-19T12:16:16.748Z | 2024-09-19T12:16:16.748Z |
5132329 | 5132329 | 20240916003406_NOwYh | UK006J | 2024-09-19T12:16:07.446Z | 2024-09-19T12:16:07.446Z |
5132201 | 5132201 | 20240915235944_fAYNJ | UK006J | 2024-09-19T12:15:58.337Z | 2024-09-19T12:15:58.337Z |
5132109 | 5132109 | 20240915232528_rAaSd | UK006J | 2024-09-19T12:15:50.849Z | 2024-09-19T12:15:50.849Z |
5131880 | 5131880 | 20240915220029_xDUD3 | UK006J | 2024-09-19T12:15:32.238Z | 2024-09-19T12:15:32.238Z |
5131453 | 5131453 | 20240915195639_iNvFO | UK006J | 2024-09-19T12:15:04.287Z | 2024-09-19T12:15:04.287Z |
5129575 | 5129575 | 20240917041036_NcG33 | UK006J | 2024-09-19T12:11:49.616Z | 2024-09-19T12:11:49.616Z |
5129463 | 5129463 | 20240917035905_c8PfO | UK006J | 2024-09-19T12:11:40.597Z | 2024-09-19T12:11:40.597Z |
5129203 | 5129203 | 20240917033625_JsPFf | UK006J | 2024-09-19T12:11:23.051Z | 2024-09-19T12:11:23.051Z |
5129140 | 5129140 | 20240917032528_fq6Pu | UK006J | 2024-09-19T12:11:16.862Z | 2024-09-19T12:11:16.862Z |
5124582 | 5124582 | 20240917211847_BVuvB | UK006J | 2024-09-19T12:01:09.986Z | 2024-09-19T12:06:41.913Z |
5124480 | 5124480 | 20240917204010_33yDb | UK006J | 2024-09-19T12:01:00.331Z | 2024-09-19T12:06:41.901Z |
5107864 | 5107864 | 20240913041241_AfvpN | UK006J | 2024-09-17T12:13:24.976Z | 2024-09-19T12:20:47.611Z |
5107258 | 5107258 | 20240913034944_bhuPa | UK006J | 2024-09-17T12:13:11.937Z | 2024-09-19T12:20:46.967Z |
5106676 | 5106676 | 20240913033221_VNeiw | UK006J | 2024-09-17T12:12:59.366Z | 2024-09-19T12:20:46.276Z |
5106177 | 5106177 | 20240913031431_VXqxS | UK006J | 2024-09-17T12:12:44.006Z | 2024-09-19T12:20:45.598Z |
5106160 | 5106160 | 20240913031331_JTvIb | UK006J | 2024-09-17T12:12:43.613Z | 2024-09-19T12:20:45.553Z |
5106115 | 5106115 | 20240913031146_n7YuO | UK006J | 2024-09-17T12:12:42.511Z | 2024-09-19T12:20:45.502Z |
5105719 | 5105719 | 20240913025549_Fv6C2 | UK006J | 2024-09-17T12:12:27.864Z | 2024-09-19T12:20:44.859Z |
5104132 | 5104132 | 20240913015356_4jKUO | UK006J | 2024-09-17T12:11:26.637Z | 2024-09-19T12:20:41.050Z |
5097185 | 5097185 | 20240913003527_hiq3W | UK006J | 2024-09-16T12:17:07.449Z | 2024-09-19T12:20:37.840Z |
5094555 | 5094555 | 20240912041047_eonnu | UK006J | 2024-09-16T12:14:51.264Z | 2024-09-19T12:21:16.250Z |
5094367 | 5094367 | 20240912035802_hWCem | UK006J | 2024-09-16T12:14:42.359Z | 2024-09-19T12:21:16.093Z |
5094352 | 5094352 | 20240912035747_oN3vz | UK006J | 2024-09-16T12:14:41.750Z | 2024-09-19T12:21:16.077Z |
5094081 | 5094081 | 20240912034717_5kvu9 | UK006J | 2024-09-16T12:14:33.578Z | 2024-09-19T12:21:15.873Z |
5093829 | 5093829 | 20240912033846_7WtuD | UK006J | 2024-09-16T12:14:26.598Z | 2024-09-19T12:21:15.688Z |
5093256 | 5093256 | 20240912031523_vZiHB | UK006J | 2024-09-16T12:14:13.633Z | 2024-09-19T12:21:15.030Z |
5092654 | 5092654 | 20240912025349_kxPAy | UK006J | 2024-09-16T12:14:01.411Z | 2024-09-19T12:21:14.388Z |
5092622 | 5092622 | 20240912025336_POIHD | UK006J | 2024-09-16T12:14:01.048Z | 2024-09-19T12:21:14.379Z |
5092506 | 5092506 | 20240912024830_JTMxq | UK006J | 2024-09-16T12:13:58.451Z | 2024-09-19T12:21:14.283Z |
5092231 | 5092231 | 20240912024016_4O2An | UK006J | 2024-09-16T12:13:44.217Z | 2024-09-19T12:21:13.711Z |
5091813 | 5091813 | 20240912022356_p0T1F | UK006J | 2024-09-16T12:13:24.639Z | 2024-09-19T12:21:13.406Z |
5091748 | 5091748 | 20240912022041_3cknw | UK006J | 2024-09-16T12:13:21.766Z | 2024-09-19T12:21:13.379Z |
5091613 | 5091613 | 20240912021527_QKiRW | UK006J | 2024-09-16T12:13:13.314Z | 2024-09-19T12:21:13.261Z |
5091505 | 5091505 | 20240912021102_vGA9H | UK006J | 2024-09-16T12:13:08.530Z | 2024-09-19T12:21:13.099Z |
5091152 | 5091152 | 20240912015847_9zVnv | UK006J | 2024-09-16T12:12:51.306Z | 2024-09-19T12:21:12.605Z |
5091102 | 5091102 | 20240912015703_IId5Y | UK006J | 2024-09-16T12:12:48.625Z | 2024-09-19T12:21:12.540Z |
5090673 | 5090673 | 20240912013932_CoxfZ | UK006J | 2024-09-16T12:12:28.957Z | 2024-09-19T12:21:11.591Z |
5090575 | 5090575 | 20240912013248_mO11U | UK006J | 2024-09-16T12:12:25.604Z | 2024-09-19T12:21:11.434Z |
5090336 | 5090336 | 20240912012130_1TI2u | UK006J | 2024-09-16T12:12:14.456Z | 2024-09-19T12:21:11.221Z |
5089247 | 5089247 | 20240912003002_1oHpV | UK006J | 2024-09-16T12:11:18.385Z | 2024-09-19T12:21:09.841Z |
5088562 | 5088562 | 20240913001713_HQLW2 | UK006J | 2024-09-16T12:08:12.464Z | 2024-09-19T12:20:37.018Z |
5088228 | 5088228 | 20240913000212_eD686 | UK006J | 2024-09-16T12:07:48.774Z | 2024-09-19T12:20:36.511Z |
5087346 | 5087346 | 20240912232406_fvdz3 | UK006J | 2024-09-16T12:06:52.789Z | 2024-09-19T12:20:34.682Z |
5085927 | 5085927 | 20240912215752_9Mk2k | UK006J | 2024-09-16T12:05:03.148Z | 2024-09-19T12:20:29.794Z |
5085227 | 5085227 | 20240912210113_BWzmH | UK006J | 2024-09-16T12:03:45.789Z | 2024-09-19T12:20:28.258Z |
5085050 | 5085050 | 20240912204321_2FiXI | UK006J | 2024-09-16T12:03:27.947Z | 2024-09-19T12:20:27.867Z |
5078021 | 5078021 | 20240911013538_pbirs | UK006J | 2024-09-15T12:15:16.978Z | 2024-09-19T12:21:39.906Z |
5075375 | 5075375 | 20240911234414_fdYjd | UK006J | 2024-09-15T12:09:39.613Z | 2024-09-19T12:21:09.174Z |
5073182 | 5073182 | 20240911210414_jF0BB | UK006J | 2024-09-15T12:06:52.958Z | 2024-09-19T12:21:05.202Z |
5073170 | 5073170 | 20240911210308_O31mv | UK006J | 2024-09-15T12:06:51.575Z | 2024-09-19T12:21:05.196Z |
5060515 | 5060515 | 20240910203426_AeJcB | UK006J | 2024-09-14T12:08:55.225Z | 2024-09-19T12:21:32.468Z |
5008335 | 5008335 | 20240903233443_xOMdU | UK006J | 2024-09-09T12:06:37.973Z | 2024-09-12T12:19:17.137Z |
5008090 | 5008090 | 20240903230115_YB32r | UK006J | 2024-09-09T12:06:26.023Z | 2024-09-12T12:19:16.175Z |
5007776 | 5007776 | 20240903221906_gdPOz | UK006J | 2024-09-09T12:06:07.263Z | 2024-09-12T12:19:14.829Z |
5007461 | 5007461 | 20240903211254_EZ7ME | UK006J | 2024-09-09T12:05:47.384Z | 2024-09-12T12:19:13.083Z |
5007211 | 5007211 | 20240903202436_Z1skP | UK006J | 2024-09-09T12:05:36.015Z | 2024-09-12T12:19:12.111Z |
4983456 | 4983456 | 20240812004444_jVIw4 | UK006J | 2024-09-06T12:15:34.028Z | 2024-09-06T12:15:34.028Z |
4983377 | 4983377 | 20240812004351_pzU5I | UK006J | 2024-09-06T12:15:30.450Z | 2024-09-06T12:15:30.450Z |
4983318 | 4983318 | 20240812004315_gvex3 | UK006J | 2024-09-06T12:15:26.454Z | 2024-09-06T12:15:26.454Z |
4983313 | 4983313 | 20240812004314_7pidU | UK006J | 2024-09-06T12:15:26.420Z | 2024-09-06T12:15:26.420Z |
4982505 | 4982505 | 20240812003419_0dhCh | UK006J | 2024-09-06T12:14:54.169Z | 2024-09-06T12:14:54.169Z |
4982425 | 4982425 | 20240812003328_ohrfM | UK006J | 2024-09-06T12:14:50.795Z | 2024-09-06T12:14:50.795Z |
4982063 | 4982063 | 20240812002945_lc6jq | UK006J | 2024-09-06T12:14:42.104Z | 2024-09-06T12:14:42.104Z |
4981937 | 4981937 | 20240812002826_70Hgs | UK006J | 2024-09-06T12:14:40.334Z | 2024-09-06T12:14:40.334Z |
4981674 | 4981674 | 20240812002550_zs6pF | UK006J | 2024-09-06T12:14:35.435Z | 2024-09-06T12:14:35.435Z |
4981179 | 4981179 | 20240812001918_4ZvsL | UK006J | 2024-09-06T12:14:27.288Z | 2024-09-06T12:14:27.288Z |
4980936 | 4980936 | 20240812001726_CAPA3 | UK006J | 2024-09-06T12:14:24.522Z | 2024-09-06T12:14:24.522Z |
4980607 | 4980607 | 20240812001414_zlI4r | UK006J | 2024-09-06T12:14:08.162Z | 2024-09-06T12:14:08.162Z |
4980589 | 4980589 | 20240812001404_HbgS4 | UK006J | 2024-09-06T12:14:06.943Z | 2024-09-06T12:14:06.943Z |
4980357 | 4980357 | 20240812001125_TRKVf | UK006J | 2024-09-06T12:13:56.231Z | 2024-09-06T12:13:56.231Z |
4980351 | 4980351 | 20240812001125_3DdpL | UK006J | 2024-09-06T12:13:56.107Z | 2024-09-06T12:13:56.107Z |
4980098 | 4980098 | 20240812000833_dL53w | UK006J | 2024-09-06T12:13:46.958Z | 2024-09-06T12:13:46.958Z |
4980040 | 4980040 | 20240812000742_j53N1 | UK006J | 2024-09-06T12:13:42.927Z | 2024-09-06T12:13:42.927Z |
4979391 | 4979391 | 20240812000142_tWaYw | UK006J | 2024-09-06T12:13:13.873Z | 2024-09-06T12:13:13.873Z |
4978683 | 4978683 | 20240811235356_D2gVU | UK006J | 2024-09-06T12:12:40.895Z | 2024-09-06T12:12:40.895Z |
4978653 | 4978653 | 20240811235314_8taKy | UK006J | 2024-09-06T12:12:38.758Z | 2024-09-06T12:12:38.758Z |
4978398 | 4978398 | 20240811235033_E12Zk | UK006J | 2024-09-06T12:12:33.249Z | 2024-09-06T12:12:33.249Z |
4977650 | 4977650 | 20240811234307_UikP1 | UK006J | 2024-09-06T12:12:21.372Z | 2024-09-06T12:12:21.372Z |
4977262 | 4977262 | 20240811233821_02250 | UK006J | 2024-09-06T12:12:10.405Z | 2024-09-06T12:12:10.405Z |
4976274 | 4976274 | 20240811232753_J43W1 | UK006J | 2024-09-06T12:11:21.761Z | 2024-09-06T12:11:21.761Z |
4976162 | 4976162 | 20240811232620_5QftX | UK006J | 2024-09-06T12:11:14.601Z | 2024-09-06T12:11:14.601Z |
4975647 | 4975647 | 20240811232036_3WCaL | UK006J | 2024-09-06T12:10:46.749Z | 2024-09-06T12:10:46.749Z |
4975601 | 4975601 | 20240811231959_EoLkh | UK006J | 2024-09-06T12:10:45.804Z | 2024-09-06T12:10:45.804Z |
4975455 | 4975455 | 20240811231835_AY32j | UK006J | 2024-09-05T12:11:50.275Z | 2024-09-06T12:10:41.641Z |
4975427 | 4975427 | 20240811231807_2ysEC | UK006J | 2024-09-05T12:11:49.530Z | 2024-09-06T12:10:41.436Z |
4975262 | 4975262 | 20240811231623_u6fyK | UK006J | 2024-09-05T12:11:42.812Z | 2024-09-06T12:10:38.952Z |
4974970 | 4974970 | 20240811231309_yJWrX | UK006J | 2024-09-05T12:11:37.502Z | 2024-09-06T12:10:35.089Z |
4974961 | 4974961 | 20240811231304_xGUAW | UK006J | 2024-09-05T12:11:37.377Z | 2024-09-06T12:10:34.999Z |
4974829 | 4974829 | 20240811231151_ipzL3 | UK006J | 2024-09-05T12:11:33.337Z | 2024-09-06T12:10:33.782Z |
4974609 | 4974609 | 20240811230859_96A9c | UK006J | 2024-09-05T12:11:27.773Z | 2024-09-06T12:10:29.076Z |
4973952 | 4973952 | 20240811230156_ue82v | UK006J | 2024-09-05T12:11:14.996Z | 2024-09-06T12:10:12.432Z |
4973638 | 4973638 | 20240811225840_2oIaN | UK006J | 2024-09-05T12:11:03.364Z | 2024-09-06T12:10:02.166Z |
4972166 | 4972166 | 20240811224331_OUvD3 | UK006J | 2024-09-05T12:10:18.440Z | 2024-09-06T12:09:05.715Z |
4972158 | 4972158 | 20240811224331_U8z2A | UK006J | 2024-09-05T12:10:18.379Z | 2024-09-06T12:09:05.674Z |
4971188 | 4971188 | 20240811223241_nanj2 | UK006J | 2024-09-05T12:09:40.880Z | 2024-09-06T12:08:50.269Z |
4970245 | 4970245 | 20240811222256_fnvSF | UK006J | 2024-09-05T12:09:22.748Z | 2024-09-06T12:08:33.068Z |
4969504 | 4969504 | 20240811221227_FAgHu | UK006J | 2024-09-05T12:08:46.799Z | 2024-09-06T12:07:53.251Z |
4968563 | 4968563 | 20240811215938_rIZX7 | UK006J | 2024-09-05T12:08:22.181Z | 2024-09-06T12:07:32.225Z |
4968494 | 4968494 | 20240811215841_59I8L | UK006J | 2024-09-05T12:08:20.600Z | 2024-09-06T12:07:31.025Z |
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);