participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,456 rows where station_code = "RU000Q" 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 |
---|---|---|---|---|---|
5132348 | 5132348 | 20240916004408_56kRX | RU000Q | 2024-09-19T12:16:08.617Z | 2024-09-19T12:16:08.617Z |
5131484 | 5131484 | 20240915200142_xq2cN | RU000Q | 2024-09-19T12:15:05.840Z | 2024-09-19T12:15:05.840Z |
5112694 | 5112694 | 20240914234223_Z34w6 | RU000Q | 2024-09-18T12:03:22.536Z | 2024-09-19T12:18:43.495Z |
5112167 | 5112167 | 20240914222736_DbFqS | RU000Q | 2024-09-18T12:02:50.956Z | 2024-09-19T12:18:38.814Z |
5103267 | 5103267 | 20240912230437_iTmBR | RU000Q | 2024-09-17T12:09:49.316Z | 2024-09-19T12:20:33.700Z |
5102824 | 5102824 | 20240914014732_jgzfJ | RU000Q | 2024-09-17T12:07:38.846Z | 2024-09-19T12:19:55.842Z |
5102662 | 5102662 | 20240914013548_9mWVA | RU000Q | 2024-09-17T12:07:29.851Z | 2024-09-19T12:19:55.364Z |
5102560 | 5102560 | 20240914013138_s72jA | RU000Q | 2024-09-17T12:07:24.738Z | 2024-09-19T12:19:55.117Z |
5101149 | 5101149 | 20240914000652_TbSRZ | RU000Q | 2024-09-17T12:05:22.201Z | 2024-09-19T12:19:49.862Z |
5074351 | 5074351 | 20240911223257_92uDX | RU000Q | 2024-09-15T12:08:25.902Z | 2024-09-19T12:21:07.115Z |
5064298 | 5064298 | 20240910004046_efmox | RU000Q | 2024-09-14T12:15:14.468Z | 2024-09-18T12:15:16.100Z |
5064140 | 5064140 | 20240910000819_aDDI3 | RU000Q | 2024-09-14T12:14:59.267Z | 2024-09-18T12:15:15.621Z |
5062677 | 5062677 | 20240909175956_Bg3KL | RU000Q | 2024-09-14T12:12:42.499Z | 2024-09-18T12:15:11.881Z |
5059542 | 5059542 | 20240910180352_U8w12 | RU000Q | 2024-09-14T12:06:25.556Z | 2024-09-19T12:21:30.870Z |
5053369 | 5053369 | 20240908002036_xXON2 | RU000Q | 2024-09-13T12:16:00.624Z | 2024-09-16T12:21:10.440Z |
5052026 | 5052026 | 20240907192758_5oU84 | RU000Q | 2024-09-13T12:14:53.891Z | 2024-09-16T12:21:03.234Z |
5039559 | 5039559 | 20240906012440_iPObm | RU000Q | 2024-09-12T12:15:37.453Z | 2024-09-14T12:23:03.531Z |
5031912 | 5031912 | 20240906233953_HMWUO | RU000Q | 2024-09-12T12:06:03.584Z | 2024-09-15T12:21:24.653Z |
5031590 | 5031590 | 20240906223748_RwUeA | RU000Q | 2024-09-12T12:05:13.897Z | 2024-09-15T12:21:23.382Z |
5031570 | 5031570 | 20240906223308_b3n3U | RU000Q | 2024-09-12T12:05:11.770Z | 2024-09-15T12:21:23.123Z |
5031376 | 5031376 | 20240906213603_tPlFH | RU000Q | 2024-09-12T12:04:39.163Z | 2024-09-15T12:21:22.137Z |
5031251 | 5031251 | 20240906210018_NP3nh | RU000Q | 2024-09-12T12:04:22.757Z | 2024-09-15T12:21:21.855Z |
5031124 | 5031124 | 20240906203332_toaiA | RU000Q | 2024-09-12T12:03:58.800Z | 2024-09-15T12:21:21.488Z |
5031057 | 5031057 | 20240906201546_KuDt9 | RU000Q | 2024-09-12T12:03:49.152Z | 2024-09-15T12:21:21.253Z |
5030837 | 5030837 | 20240906190120_NOBeZ | RU000Q | 2024-09-12T12:03:12.510Z | 2024-09-15T12:21:19.998Z |
5025213 | 5025213 | 20240906012440_2lb1A | RU000Q | 2024-09-11T12:06:00.399Z | 2024-09-11T12:16:32.524Z |
5019825 | 5019825 | 20240904235853_EQeT3 | RU000Q | 2024-09-10T12:13:35.146Z | 2024-09-13T12:19:53.989Z |
5019678 | 5019678 | 20240904233201_mw5P7 | RU000Q | 2024-09-10T12:13:09.612Z | 2024-09-13T12:19:53.381Z |
4990571 | 4990571 | 20240901004040_OaSBn | RU000Q | 2024-09-07T12:10:47.437Z | 2024-09-09T12:26:23.732Z |
4989738 | 4989738 | 20240831221934_WiO39 | RU000Q | 2024-09-07T12:09:26.690Z | 2024-09-09T12:25:43.152Z |
4982317 | 4982317 | 20240812003222_53uBy | RU000Q | 2024-09-06T12:14:49.142Z | 2024-09-06T12:14:49.142Z |
4982166 | 4982166 | 20240812003054_1O3gc | RU000Q | 2024-09-06T12:14:45.109Z | 2024-09-06T12:14:45.109Z |
4982053 | 4982053 | 20240812002941_x6r33 | RU000Q | 2024-09-06T12:14:41.911Z | 2024-09-06T12:14:41.911Z |
4981734 | 4981734 | 20240812002654_ibEGR | RU000Q | 2024-09-06T12:14:36.946Z | 2024-09-06T12:14:36.946Z |
4978555 | 4978555 | 20240811235226_vXTK3 | RU000Q | 2024-09-06T12:12:35.875Z | 2024-09-06T12:12:35.875Z |
4976745 | 4976745 | 20240811233249_ka27z | RU000Q | 2024-09-06T12:11:44.406Z | 2024-09-06T12:11:44.406Z |
4976561 | 4976561 | 20240811233145_0Kng0 | RU000Q | 2024-09-06T12:11:37.145Z | 2024-09-06T12:11:37.145Z |
4973291 | 4973291 | 20240811225527_VfXFY | RU000Q | 2024-09-05T12:10:46.802Z | 2024-09-06T12:09:51.409Z |
4972526 | 4972526 | 20240811224715_TZlUW | RU000Q | 2024-09-05T12:10:27.114Z | 2024-09-06T12:09:17.112Z |
4971863 | 4971863 | 20240811224027_S9Hdq | RU000Q | 2024-09-05T12:10:05.348Z | 2024-09-06T12:08:59.094Z |
4971592 | 4971592 | 20240811223724_f5XME | RU000Q | 2024-09-05T12:09:48.886Z | 2024-09-06T12:08:55.147Z |
4971284 | 4971284 | 20240811223333_6xixy | RU000Q | 2024-09-05T12:09:42.244Z | 2024-09-06T12:08:51.509Z |
4971122 | 4971122 | 20240811223210_Q76yd | RU000Q | 2024-09-05T12:09:39.699Z | 2024-09-06T12:08:49.596Z |
4970912 | 4970912 | 20240811222943_c127w | RU000Q | 2024-09-05T12:09:34.347Z | 2024-09-06T12:08:46.492Z |
4964040 | 4964040 | 20240811204400_Iv2bL | RU000Q | 2024-09-04T12:06:05.371Z | 2024-09-06T12:05:09.211Z |
4963326 | 4963326 | 20240811195815_zfwo3 | RU000Q | 2024-09-04T12:05:27.404Z | 2024-09-06T12:04:30.058Z |
4962522 | 4962522 | 20240811190531_xPISL | RU000Q | 2024-09-04T12:04:37.052Z | 2024-09-06T12:03:49.697Z |
4939963 | 4939963 | 20240810230141_mTeXW | RU000Q | 2024-09-01T12:10:14.117Z | 2024-09-06T12:23:29.528Z |
4939214 | 4939214 | 20240810224037_NNqP1 | RU000Q | 2024-09-01T12:09:41.149Z | 2024-09-06T12:23:17.828Z |
4939040 | 4939040 | 20240810223507_2jdhY | RU000Q | 2024-09-01T12:09:35.151Z | 2024-09-06T12:23:11.261Z |
4935895 | 4935895 | 20240810205022_63ORz | RU000Q | 2024-09-01T12:06:59.133Z | 2024-09-06T12:21:05.870Z |
4921420 | 4921420 | 20240810005457_TIwKN | RU000Q | 2024-08-30T12:14:09.514Z | 2024-09-02T12:27:00.352Z |
4921195 | 4921195 | 20240810004914_r9Jqt | RU000Q | 2024-08-30T12:13:58.105Z | 2024-09-02T12:26:53.204Z |
4920413 | 4920413 | 20240810003247_sRAcg | RU000Q | 2024-08-30T12:13:22.495Z | 2024-09-02T12:26:23.570Z |
4918871 | 4918871 | 20240810000013_9fBN4 | RU000Q | 2024-08-30T12:12:20.217Z | 2024-09-02T12:25:37.957Z |
4918562 | 4918562 | 20240809235410_KZCXu | RU000Q | 2024-08-30T12:12:05.676Z | 2024-09-02T12:25:33.339Z |
4917356 | 4917356 | 20240809233208_QSS2J | RU000Q | 2024-08-30T12:11:22.433Z | 2024-09-02T12:25:00.334Z |
4916639 | 4916639 | 20240809232034_Tfifd | RU000Q | 2024-08-30T12:10:55.050Z | 2024-09-02T12:24:34.862Z |
4916038 | 4916038 | 20240809230354_M3l2Z | RU000Q | 2024-08-30T12:10:28.613Z | 2024-09-02T12:24:08.954Z |
4915825 | 4915825 | 20240809225847_l83MH | RU000Q | 2024-08-30T12:10:16.707Z | 2024-09-02T12:24:04.837Z |
4913630 | 4913630 | 20240809215358_zsupk | RU000Q | 2024-08-29T12:09:20.951Z | 2024-09-02T12:23:00.735Z |
4911107 | 4911107 | 20240809192411_MCDT6 | RU000Q | 2024-08-29T12:06:59.671Z | 2024-09-02T12:21:17.841Z |
4910552 | 4910552 | 20240809181409_tUU6y | RU000Q | 2024-08-29T12:06:19.869Z | 2024-09-02T12:20:58.167Z |
4910242 | 4910242 | 20240809175254_nlmTS | RU000Q | 2024-08-29T12:05:58.497Z | 2024-09-02T12:20:35.312Z |
4900989 | 4900989 | 20240808005649_ikGjC | RU000Q | 2024-08-28T12:18:24.822Z | 2024-08-28T12:18:24.822Z |
4900579 | 4900579 | 20240808002955_DaUID | RU000Q | 2024-08-28T12:18:07.472Z | 2024-08-28T12:18:07.472Z |
4899088 | 4899088 | 20240807223125_BxON3 | RU000Q | 2024-08-28T12:17:04.558Z | 2024-08-28T12:17:04.558Z |
4897882 | 4897882 | 20240807194704_msYyN | RU000Q | 2024-08-28T12:16:03.651Z | 2024-08-28T12:16:03.651Z |
4891395 | 4891395 | 20240809005405_LPxsJ | RU000Q | 2024-08-28T12:08:59.192Z | 2024-08-30T12:21:11.955Z |
4890925 | 4890925 | 20240809000607_tXhG8 | RU000Q | 2024-08-28T12:08:20.428Z | 2024-08-30T12:20:40.939Z |
4890915 | 4890915 | 20240809000523_QI08f | RU000Q | 2024-08-28T12:08:19.736Z | 2024-08-30T12:20:40.490Z |
4890804 | 4890804 | 20240808235204_HPAwv | RU000Q | 2024-08-28T12:08:10.902Z | 2024-08-30T12:20:31.021Z |
4890275 | 4890275 | 20240808225321_WXSeI | RU000Q | 2024-08-28T12:07:29.618Z | 2024-08-30T12:20:10.220Z |
4890132 | 4890132 | 20240808223640_jS4Z6 | RU000Q | 2024-08-28T12:07:15.230Z | 2024-08-30T12:20:04.383Z |
4889496 | 4889496 | 20240808210706_80eJU | RU000Q | 2024-08-28T12:06:16.602Z | 2024-08-30T12:19:24.421Z |
4889454 | 4889454 | 20240808210338_YfdyB | RU000Q | 2024-08-28T12:06:13.203Z | 2024-08-30T12:19:22.711Z |
4889180 | 4889180 | 20240808200336_NNfQR | RU000Q | 2024-08-28T12:05:43.113Z | 2024-08-30T12:18:57.419Z |
4888857 | 4888857 | 20240808190357_qjFKb | RU000Q | 2024-08-28T12:05:13.181Z | 2024-08-30T12:18:40.953Z |
4888611 | 4888611 | 20240808181255_JPW27 | RU000Q | 2024-08-28T12:04:51.430Z | 2024-08-30T12:18:29.827Z |
4877371 | 4877371 | 20240807000054_pqH5L | RU000Q | 2024-08-19T12:13:20.847Z | 2024-08-27T12:13:09.574Z |
4876162 | 4876162 | 20240806233350_afrhw | RU000Q | 2024-08-19T12:12:42.110Z | 2024-08-27T12:12:36.822Z |
4871012 | 4871012 | 20240806184221_ahbm2 | RU000Q | 2024-08-19T12:08:27.361Z | 2024-08-27T12:09:14.388Z |
4853080 | 4853080 | 20240805223520_3fgI3 | RU000Q | 2024-08-17T12:16:54.695Z | 2024-08-19T12:24:40.565Z |
4852035 | 4852035 | 20240805214014_as6Ox | RU000Q | 2024-08-17T12:15:39.623Z | 2024-08-19T12:24:15.171Z |
4851517 | 4851517 | 20240805211250_88OU4 | RU000Q | 2024-08-17T12:14:51.931Z | 2024-08-19T12:24:05.105Z |
4851075 | 4851075 | 20240805203048_l1Nwj | RU000Q | 2024-08-17T12:14:12.003Z | 2024-08-19T12:23:40.877Z |
4850728 | 4850728 | 20240805194518_4LYb1 | RU000Q | 2024-08-17T12:13:36.542Z | 2024-08-19T12:23:20.505Z |
4850037 | 4850037 | 20240805181948_8Ny3t | RU000Q | 2024-08-17T12:12:35.122Z | 2024-08-19T12:22:42.597Z |
4831866 | 4831866 | 20240804230238_9w2bQ | RU000Q | 2024-08-15T12:12:18.992Z | 2024-08-17T12:30:45.762Z |
4831154 | 4831154 | 20240804222037_RsU9x | RU000Q | 2024-08-15T12:11:26.357Z | 2024-08-17T12:30:19.066Z |
4829218 | 4829218 | 20240804191827_2psRU | RU000Q | 2024-08-15T12:08:16.932Z | 2024-08-17T12:28:46.936Z |
4829046 | 4829046 | 20240804184333_kIThA | RU000Q | 2024-08-15T12:08:00.891Z | 2024-08-17T12:28:37.403Z |
4822564 | 4822564 | 20240803213815_IpIZh | RU000Q | 2024-08-14T12:17:18.961Z | 2024-08-15T12:24:30.453Z |
4804601 | 4804601 | 20240802225342_y7Hbt | RU000Q | 2024-08-12T12:16:44.212Z | 2024-08-13T12:16:59.950Z |
4803292 | 4803292 | 20240802204836_lfpOj | RU000Q | 2024-08-12T12:15:06.858Z | 2024-08-13T12:16:38.109Z |
4784740 | 4784740 | 20240801234414_Rqe6m | RU000Q | 2024-08-10T12:15:22.667Z | 2024-08-11T12:14:35.550Z |
4784118 | 4784118 | 20240801231001_vKOdt | RU000Q | 2024-08-10T12:14:35.881Z | 2024-08-11T12:14:24.402Z |
4783437 | 4783437 | 20240801222722_lYlEO | RU000Q | 2024-08-10T12:13:52.024Z | 2024-08-11T12:14:11.040Z |
4783170 | 4783170 | 20240801220932_QvHOf | RU000Q | 2024-08-10T12:13:26.719Z | 2024-08-11T12:14:05.280Z |
4779415 | 4779415 | 20240801004019_qMdPX | RU000Q | 2024-08-07T12:14:27.458Z | 2024-08-10T12:21:29.001Z |
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);