participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,347 rows where station_code = "RU000F" 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 |
---|---|---|---|---|---|
5598695 | 5598695 | 20241123183036_J5CXE | RU000F | 2024-11-25T14:15:49.284Z | 2024-11-26T14:21:06.745Z |
5598557 | 5598557 | 20241123160424_m2B0s | RU000F | 2024-11-25T14:15:13.919Z | 2024-11-26T14:20:42.570Z |
5598549 | 5598549 | 20241123153750_6tZXW | RU000F | 2024-11-25T14:15:09.180Z | 2024-11-26T14:20:39.097Z |
5592354 | 5592354 | 20241123031125_V5aJC | RU000F | 2024-11-24T14:20:57.274Z | 2024-11-26T14:23:45.623Z |
5592177 | 5592177 | 20241123022849_hmq09 | RU000F | 2024-11-24T14:20:43.705Z | 2024-11-26T14:23:39.906Z |
5591935 | 5591935 | 20241123013314_Uhccq | RU000F | 2024-11-24T14:20:27.526Z | 2024-11-26T14:23:33.119Z |
5591186 | 5591186 | 20241122215029_vLsSE | RU000F | 2024-11-24T14:19:34.059Z | 2024-11-26T14:23:17.627Z |
5591101 | 5591101 | 20241122212305_98yGH | RU000F | 2024-11-24T14:19:26.877Z | 2024-11-26T14:23:16.250Z |
5591089 | 5591089 | 20241122212046_mFUxn | RU000F | 2024-11-24T14:19:25.543Z | 2024-11-26T14:23:16.123Z |
5590979 | 5590979 | 20241122205335_f1sUD | RU000F | 2024-11-24T14:19:15.349Z | 2024-11-26T14:23:14.906Z |
5590970 | 5590970 | 20241122204858_GI3Me | RU000F | 2024-11-24T14:19:14.729Z | 2024-11-26T14:23:14.850Z |
5590875 | 5590875 | 20241122203058_7eyCN | RU000F | 2024-11-24T14:19:06.328Z | 2024-11-26T14:23:13.933Z |
5590762 | 5590762 | 20241122200329_6oDTb | RU000F | 2024-11-24T14:18:56.707Z | 2024-11-26T14:23:12.244Z |
5590658 | 5590658 | 20241122194659_IO4CA | RU000F | 2024-11-24T14:18:49.069Z | 2024-11-26T14:23:11.139Z |
5590608 | 5590608 | 20241122194029_Z9E9K | RU000F | 2024-11-24T14:18:45.479Z | 2024-11-26T14:23:10.532Z |
5590561 | 5590561 | 20241122193558_Gvgop | RU000F | 2024-11-24T14:18:42.774Z | 2024-11-26T14:23:09.211Z |
5589983 | 5589983 | 20241122181120_CVKFA | RU000F | 2024-11-24T14:17:57.336Z | 2024-11-26T14:23:00.604Z |
5589949 | 5589949 | 20241122180334_CnqqN | RU000F | 2024-11-24T14:17:54.032Z | 2024-11-26T14:23:00.351Z |
5589759 | 5589759 | 20241122172544_To6GB | RU000F | 2024-11-24T14:17:41.498Z | 2024-11-26T14:22:58.843Z |
5589757 | 5589757 | 20241122172544_zGOsu | RU000F | 2024-11-24T14:17:41.469Z | 2024-11-26T14:22:58.842Z |
5577464 | 5577464 | 20241121161409_fPpKA | RU000F | 2024-11-23T14:15:17.033Z | 2024-11-26T14:24:35.232Z |
5572715 | 5572715 | 20241121030121_D53RG | RU000F | 2024-11-22T14:18:45.499Z | 2024-11-26T14:26:52.212Z |
5572534 | 5572534 | 20241121023317_KQwum | RU000F | 2024-11-22T14:18:32.882Z | 2024-11-26T14:26:50.136Z |
5572525 | 5572525 | 20241121023258_9s20f | RU000F | 2024-11-22T14:18:32.317Z | 2024-11-22T14:19:22.344Z |
5571348 | 5571348 | 20241120232641_b6OQ4 | RU000F | 2024-11-22T14:16:55.042Z | 2024-11-26T14:26:33.915Z |
5571297 | 5571297 | 20241120231716_3G7yb | RU000F | 2024-11-22T14:16:49.297Z | 2024-11-26T14:26:33.629Z |
5571123 | 5571123 | 20241120222829_D3SGv | RU000F | 2024-11-22T14:16:28.323Z | 2024-11-26T14:26:32.374Z |
5571076 | 5571076 | 20241120221454_OH2Nw | RU000F | 2024-11-22T14:16:21.760Z | 2024-11-26T14:26:32.061Z |
5570930 | 5570930 | 20241120213221_Dd333 | RU000F | 2024-11-22T14:16:12.454Z | 2024-11-26T14:26:31.129Z |
5570889 | 5570889 | 20241120212523_t4Iwo | RU000F | 2024-11-22T14:16:10.879Z | 2024-11-26T14:26:31.020Z |
5570868 | 5570868 | 20241120212107_fC8S8 | RU000F | 2024-11-22T14:16:09.938Z | 2024-11-26T14:26:30.824Z |
5570567 | 5570567 | 20241120201055_adZj6 | RU000F | 2024-11-22T14:15:48.171Z | 2024-11-26T14:26:24.281Z |
5570523 | 5570523 | 20241120195351_X94CV | RU000F | 2024-11-22T14:15:40.521Z | 2024-11-26T14:26:22.838Z |
5570349 | 5570349 | 20241120192320_Y2NLY | RU000F | 2024-11-22T14:15:13.676Z | 2024-11-26T14:26:18.339Z |
5569910 | 5569910 | 20241120175906_uPHvB | RU000F | 2024-11-22T14:14:33.892Z | 2024-11-26T14:26:11.660Z |
5569772 | 5569772 | 20241120172309_nUikt | RU000F | 2024-11-22T14:14:07.302Z | 2024-11-26T14:26:10.442Z |
5569727 | 5569727 | 20241120163038_KYVI9 | RU000F | 2024-11-22T14:13:58.070Z | 2024-11-26T14:26:09.319Z |
5562151 | 5562151 | 20241119230401_kHCOd | RU000F | 2024-11-21T14:14:29.155Z | 2024-11-26T14:27:35.107Z |
5561051 | 5561051 | 20241119172627_91T9O | RU000F | 2024-11-21T14:12:14.741Z | 2024-11-26T14:27:22.913Z |
5553542 | 5553542 | 20241118031201_9wuZU | RU000F | 2024-11-19T14:10:48.787Z | 2024-11-26T14:28:51.575Z |
5553511 | 5553511 | 20241118030417_Mq6Z3 | RU000F | 2024-11-19T14:10:45.030Z | 2024-11-26T14:28:51.301Z |
5553494 | 5553494 | 20241118025758_MFkZI | RU000F | 2024-11-19T14:10:42.959Z | 2024-11-26T14:28:51.264Z |
5553455 | 5553455 | 20241118024603_CtzBz | RU000F | 2024-11-19T14:10:37.339Z | 2024-11-19T14:11:35.688Z |
5552914 | 5552914 | 20241117232346_sHKAG | RU000F | 2024-11-19T14:09:45.372Z | 2024-11-26T14:28:48.026Z |
5552823 | 5552823 | 20241117221432_YZ9DP | RU000F | 2024-11-19T14:09:21.843Z | 2024-11-26T14:28:46.887Z |
5552781 | 5552781 | 20241117214614_GXj6a | RU000F | 2024-11-19T14:09:12.688Z | 2024-11-26T14:28:46.257Z |
5552778 | 5552778 | 20241117214029_q73Zd | RU000F | 2024-11-19T14:09:12.391Z | 2024-11-26T14:28:46.182Z |
5552741 | 5552741 | 20241117210647_Y23ip | RU000F | 2024-11-19T14:09:05.369Z | 2024-11-26T14:28:45.660Z |
5552677 | 5552677 | 20241117200358_ISQYP | RU000F | 2024-11-19T14:08:54.119Z | 2024-11-26T14:28:45.025Z |
5552582 | 5552582 | 20241117185552_zFuWY | RU000F | 2024-11-19T14:08:42.232Z | 2024-11-26T14:28:44.121Z |
5552505 | 5552505 | 20241117175138_vz77K | RU000F | 2024-11-19T14:08:18.677Z | 2024-11-26T14:28:41.799Z |
5552461 | 5552461 | 20241117161339_7OXUr | RU000F | 2024-11-19T14:08:03.340Z | 2024-11-26T14:28:40.075Z |
5552448 | 5552448 | 20241117155758_jS56T | RU000F | 2024-11-19T14:08:01.687Z | 2024-11-26T14:28:39.847Z |
5552442 | 5552442 | 20241117155614_ZgMr3 | RU000F | 2024-11-19T14:08:00.869Z | 2024-11-26T14:28:38.631Z |
5549109 | 5549109 | 20241117031043_sGbTv | RU000F | 2024-11-18T14:10:57.533Z | 2024-11-25T14:22:46.284Z |
5549025 | 5549025 | 20241117024454_l2MpK | RU000F | 2024-11-18T14:10:42.879Z | 2024-11-25T14:22:46.027Z |
5548805 | 5548805 | 20241117014653_2HWRo | RU000F | 2024-11-18T14:10:14.656Z | 2024-11-25T14:22:45.454Z |
5548281 | 5548281 | 20241116220420_fgmvm | RU000F | 2024-11-18T14:08:39.200Z | 2024-11-25T14:22:43.042Z |
5548166 | 5548166 | 20241116204140_I8DcP | RU000F | 2024-11-18T14:08:22.734Z | 2024-11-25T14:22:42.357Z |
5548123 | 5548123 | 20241116195821_7qpVC | RU000F | 2024-11-18T14:08:17.121Z | 2024-11-25T14:22:42.095Z |
5548101 | 5548101 | 20241116194748_022Hq | RU000F | 2024-11-18T14:08:09.863Z | 2024-11-25T14:22:41.967Z |
5548078 | 5548078 | 20241116191641_OqSjl | RU000F | 2024-11-18T14:08:00.355Z | 2024-11-25T14:22:41.538Z |
5548025 | 5548025 | 20241116181901_Aylrv | RU000F | 2024-11-18T14:07:48.811Z | 2024-11-25T14:22:40.822Z |
5548003 | 5548003 | 20241116171235_JB3CR | RU000F | 2024-11-18T14:07:44.233Z | 2024-11-25T14:22:40.610Z |
5541552 | 5541552 | 20241114023510_vQcwj | RU000F | 2024-11-15T14:07:50.079Z | 2024-11-22T14:24:19.385Z |
5541456 | 5541456 | 20241114015827_lyF3I | RU000F | 2024-11-15T14:07:39.867Z | 2024-11-22T14:24:19.060Z |
5541187 | 5541187 | 20241113185944_p2ZSI | RU000F | 2024-11-15T14:06:51.787Z | 2024-11-22T14:24:16.393Z |
5541176 | 5541176 | 20241113184940_G0pbg | RU000F | 2024-11-15T14:06:50.666Z | 2024-11-22T14:24:16.285Z |
5541163 | 5541163 | 20241113174610_aafHp | RU000F | 2024-11-15T14:06:48.293Z | 2024-11-22T14:24:15.989Z |
5541157 | 5541157 | 20241113155452_9nvIC | RU000F | 2024-11-15T14:06:45.474Z | 2024-11-22T14:24:15.585Z |
5537980 | 5537980 | 20241113014715_sGexy | RU000F | 2024-11-14T14:12:41.130Z | 2024-11-21T14:26:18.292Z |
5537881 | 5537881 | 20241113011952_tfuUt | RU000F | 2024-11-14T14:12:35.226Z | 2024-11-21T14:26:16.622Z |
5537865 | 5537865 | 20241113011045_tSwM2 | RU000F | 2024-11-14T14:12:34.294Z | 2024-11-21T14:26:16.509Z |
5537851 | 5537851 | 20241113010714_tlhrC | RU000F | 2024-11-14T14:12:33.691Z | 2024-11-21T14:26:16.481Z |
5537710 | 5537710 | 20241113001502_F3jcW | RU000F | 2024-11-14T14:12:25.984Z | 2024-11-21T14:26:15.479Z |
5537333 | 5537333 | 20241112221032_GLERS | RU000F | 2024-11-14T14:11:36.610Z | 2024-11-21T14:26:11.287Z |
5537240 | 5537240 | 20241112211935_sJQX1 | RU000F | 2024-11-14T14:11:24.233Z | 2024-11-21T14:26:10.363Z |
5537025 | 5537025 | 20241112200719_faVgc | RU000F | 2024-11-14T14:10:51.614Z | 2024-11-21T14:26:08.195Z |
5530126 | 5530126 | 20241112014844_0W9Z3 | RU000F | 2024-11-13T14:13:58.010Z | 2024-11-20T14:25:54.722Z |
5529804 | 5529804 | 20241112010543_HELs8 | RU000F | 2024-11-13T14:13:11.896Z | 2024-11-20T14:25:48.330Z |
5529430 | 5529430 | 20241112001827_5gOOe | RU000F | 2024-11-13T14:12:47.144Z | 2024-11-20T14:25:44.677Z |
5529280 | 5529280 | 20241111235714_nSRBp | RU000F | 2024-11-13T14:12:18.533Z | 2024-11-20T14:25:42.531Z |
5529228 | 5529228 | 20241111235239_NGK8w | RU000F | 2024-11-13T14:12:14.670Z | 2024-11-20T14:25:42.022Z |
5529027 | 5529027 | 20241111231957_FYHba | RU000F | 2024-11-13T14:11:58.603Z | 2024-11-20T14:25:38.625Z |
5528735 | 5528735 | 20241111222834_Bhefb | RU000F | 2024-11-13T14:11:21.162Z | 2024-11-20T14:25:34.575Z |
5527913 | 5527913 | 20241111185912_JpxZB | RU000F | 2024-11-13T14:09:33.043Z | 2024-11-20T14:25:22.984Z |
5523576 | 5523576 | 20241111014912_PPebw | RU000F | 2024-11-12T14:16:01.633Z | 2024-11-19T14:22:13.455Z |
5522825 | 5522825 | 20241110220410_owGJI | RU000F | 2024-11-12T14:14:21.802Z | 2024-11-19T14:22:07.297Z |
5522790 | 5522790 | 20241110214027_hMaZQ | RU000F | 2024-11-12T14:14:18.742Z | 2024-11-19T14:22:06.353Z |
5522720 | 5522720 | 20241110210914_7zASC | RU000F | 2024-11-12T14:14:01.244Z | 2024-11-19T14:22:05.449Z |
5522669 | 5522669 | 20241110205719_j7jg9 | RU000F | 2024-11-12T14:13:55.410Z | 2024-11-19T14:22:05.167Z |
5522416 | 5522416 | 20241110195942_5NpHM | RU000F | 2024-11-12T14:13:13.884Z | 2024-11-19T14:22:01.798Z |
5521702 | 5521702 | 20241110180214_7u3l3 | RU000F | 2024-11-12T14:11:52.019Z | 2024-11-19T14:21:54.401Z |
5521591 | 5521591 | 20241110173922_GFzZo | RU000F | 2024-11-12T14:11:41.869Z | 2024-11-19T14:21:53.665Z |
5516462 | 5516462 | 20241110010335_fzLrN | RU000F | 2024-11-11T14:13:02.546Z | 2024-11-18T14:26:31.310Z |
5516337 | 5516337 | 20241110004124_zD05M | RU000F | 2024-11-11T14:12:47.551Z | 2024-11-18T14:26:30.714Z |
5516328 | 5516328 | 20241110004041_gkZ7D | RU000F | 2024-11-11T14:12:44.596Z | 2024-11-18T14:26:30.697Z |
5515973 | 5515973 | 20241109232259_n6MdX | RU000F | 2024-11-11T14:11:52.094Z | 2024-11-18T14:26:28.754Z |
5515887 | 5515887 | 20241109230356_G6EW3 | RU000F | 2024-11-11T14:11:43.280Z | 2024-11-18T14:26:28.334Z |
5515847 | 5515847 | 20241109225633_LfDKG | RU000F | 2024-11-11T14:11:36.920Z | 2024-11-18T14:26:28.163Z |
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);