participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,846 rows where station_code = "RU0008" 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 |
---|---|---|---|---|---|
5572661 | 5572661 | 20241121025410_2T0Oe | RU0008 | 2024-11-22T14:18:41.855Z | 2024-11-22T14:19:22.370Z |
5572288 | 5572288 | 20241121020341_V4qbB | RU0008 | 2024-11-22T14:18:11.994Z | 2024-11-22T14:19:22.298Z |
5572273 | 5572273 | 20241121020138_C2s5v | RU0008 | 2024-11-22T14:18:09.787Z | 2024-11-22T14:19:22.294Z |
5572032 | 5572032 | 20241121012225_9ZJOF | RU0008 | 2024-11-22T14:17:53.635Z | 2024-11-22T14:19:22.246Z |
5571924 | 5571924 | 20241121010823_VM3X4 | RU0008 | 2024-11-22T14:17:47.362Z | 2024-11-22T14:19:22.224Z |
5571473 | 5571473 | 20241120235351_bRYYa | RU0008 | 2024-11-22T14:17:09.733Z | 2024-11-22T14:19:22.133Z |
5571443 | 5571443 | 20241120234734_T2ziq | RU0008 | 2024-11-22T14:17:07.234Z | 2024-11-22T14:19:22.126Z |
5571391 | 5571391 | 20241120233630_U3Fck | RU0008 | 2024-11-22T14:17:00.900Z | 2024-11-22T14:19:22.116Z |
5571343 | 5571343 | 20241120232542_XISwH | RU0008 | 2024-11-22T14:16:54.033Z | 2024-11-22T14:19:22.106Z |
5571222 | 5571222 | 20241120225847_wkL4Z | RU0008 | 2024-11-22T14:16:39.529Z | 2024-11-22T14:19:22.071Z |
5571091 | 5571091 | 20241120222011_hzRY4 | RU0008 | 2024-11-22T14:16:23.628Z | 2024-11-22T14:19:22.040Z |
5571069 | 5571069 | 20241120221157_jGfle | RU0008 | 2024-11-22T14:16:21.269Z | 2024-11-22T14:19:22.035Z |
5570942 | 5570942 | 20241120213824_Lu5U2 | RU0008 | 2024-11-22T14:16:13.553Z | 2024-11-22T14:19:22.010Z |
5570800 | 5570800 | 20241120210411_QDuUp | RU0008 | 2024-11-22T14:16:06.222Z | 2024-11-22T14:19:21.984Z |
5570119 | 5570119 | 20241120184435_3mxP9 | RU0008 | 2024-11-22T14:14:53.638Z | 2024-11-22T14:19:21.865Z |
5570064 | 5570064 | 20241120183537_RDmyV | RU0008 | 2024-11-22T14:14:48.906Z | 2024-11-22T14:19:21.855Z |
5569998 | 5569998 | 20241120182201_KRff7 | RU0008 | 2024-11-22T14:14:44.162Z | 2024-11-22T14:19:21.844Z |
5569950 | 5569950 | 20241120180421_L2E0H | RU0008 | 2024-11-22T14:14:39.363Z | 2024-11-22T14:19:21.835Z |
5569948 | 5569948 | 20241120180239_Hzk22 | RU0008 | 2024-11-22T14:14:38.919Z | 2024-11-22T14:19:21.834Z |
5564526 | 5564526 | 20241120030705_wWuGL | RU0008 | 2024-11-21T14:17:46.908Z | 2024-11-22T14:21:33.341Z |
5564484 | 5564484 | 20241120030048_vq3Xw | RU0008 | 2024-11-21T14:17:41.777Z | 2024-11-22T14:21:32.758Z |
5564423 | 5564423 | 20241120025628_jDd47 | RU0008 | 2024-11-21T14:17:34.811Z | 2024-11-22T14:21:31.760Z |
5564112 | 5564112 | 20241120022910_nUpvu | RU0008 | 2024-11-21T14:17:10.856Z | 2024-11-22T14:21:26.978Z |
5564084 | 5564084 | 20241120022747_dTCWH | RU0008 | 2024-11-21T14:17:08.172Z | 2024-11-22T14:21:26.854Z |
5564051 | 5564051 | 20241120022618_XJEex | RU0008 | 2024-11-21T14:17:06.918Z | 2024-11-22T14:21:26.708Z |
5564015 | 5564015 | 20241120022324_ep06N | RU0008 | 2024-11-21T14:17:04.983Z | 2024-11-22T14:21:26.493Z |
5563996 | 5563996 | 20241120022145_ISJIA | RU0008 | 2024-11-21T14:17:03.141Z | 2024-11-22T14:21:26.155Z |
5563983 | 5563983 | 20241120022018_aYL8i | RU0008 | 2024-11-21T14:17:02.182Z | 2024-11-22T14:21:25.969Z |
5563630 | 5563630 | 20241120015334_YGdm2 | RU0008 | 2024-11-21T14:16:30.373Z | 2024-11-22T14:21:20.206Z |
5563594 | 5563594 | 20241120014931_mZehw | RU0008 | 2024-11-21T14:16:26.171Z | 2024-11-22T14:21:19.600Z |
5563574 | 5563574 | 20241120014636_QTjZB | RU0008 | 2024-11-21T14:16:23.581Z | 2024-11-22T14:21:18.992Z |
5563408 | 5563408 | 20241120012801_q3I4H | RU0008 | 2024-11-21T14:16:03.116Z | 2024-11-22T14:21:15.078Z |
5563377 | 5563377 | 20241120012303_L6I22 | RU0008 | 2024-11-21T14:16:01.066Z | 2024-11-22T14:21:14.788Z |
5563264 | 5563264 | 20241120011309_OXzbq | RU0008 | 2024-11-21T14:15:48.833Z | 2024-11-22T14:21:11.873Z |
5563238 | 5563238 | 20241120010923_qFMYC | RU0008 | 2024-11-21T14:15:44.146Z | 2024-11-22T14:21:11.528Z |
5563036 | 5563036 | 20241120004438_rCDPR | RU0008 | 2024-11-21T14:15:32.459Z | 2024-11-22T14:21:07.934Z |
5562825 | 5562825 | 20241120001548_MG9LO | RU0008 | 2024-11-21T14:15:23.992Z | 2024-11-22T14:21:05.135Z |
5562674 | 5562674 | 20241120000354_4dlJU | RU0008 | 2024-11-21T14:15:16.296Z | 2024-11-22T14:21:02.092Z |
5562625 | 5562625 | 20241119235829_yHh6c | RU0008 | 2024-11-21T14:15:14.048Z | 2024-11-22T14:21:01.059Z |
5562603 | 5562603 | 20241119235357_iBNcA | RU0008 | 2024-11-21T14:15:13.197Z | 2024-11-22T14:21:00.831Z |
5562468 | 5562468 | 20241119234155_MvqCJ | RU0008 | 2024-11-21T14:14:55.237Z | 2024-11-22T14:20:58.930Z |
5562332 | 5562332 | 20241119232407_93KI6 | RU0008 | 2024-11-21T14:14:43.065Z | 2024-11-22T14:20:56.340Z |
5562052 | 5562052 | 20241119225254_jiBhb | RU0008 | 2024-11-21T14:14:22.121Z | 2024-11-22T14:20:52.116Z |
5562012 | 5562012 | 20241119224349_UgHn7 | RU0008 | 2024-11-21T14:14:19.509Z | 2024-11-22T14:20:51.345Z |
5561715 | 5561715 | 20241119215008_wWwuM | RU0008 | 2024-11-21T14:13:50.451Z | 2024-11-22T14:20:44.345Z |
5561442 | 5561442 | 20241119203716_JAhDI | RU0008 | 2024-11-21T14:13:17.552Z | 2024-11-22T14:20:36.737Z |
5561440 | 5561440 | 20241119203404_JzayA | RU0008 | 2024-11-21T14:13:16.982Z | 2024-11-22T14:20:36.376Z |
5561366 | 5561366 | 20241119201351_fHdoC | RU0008 | 2024-11-21T14:13:10.163Z | 2024-11-22T14:20:33.596Z |
5553939 | 5553939 | 20241117005528_U2M7P | RU0008 | 2024-11-19T14:13:08.800Z | 2024-11-22T14:23:14.949Z |
5553924 | 5553924 | 20241116203104_vtWjh | RU0008 | 2024-11-19T14:12:30.921Z | 2024-11-22T14:23:10.396Z |
5553541 | 5553541 | 20241118031201_9wuZU | RU0008 | 2024-11-19T14:10:48.787Z | 2024-11-22T14:22:54.096Z |
5553528 | 5553528 | 20241118030848_zSW35 | RU0008 | 2024-11-19T14:10:46.641Z | 2024-11-22T14:22:53.993Z |
5553501 | 5553501 | 20241118030105_wi9TZ | RU0008 | 2024-11-19T14:10:43.726Z | 2024-11-22T14:22:53.835Z |
5553471 | 5553471 | 20241118025135_Koktr | RU0008 | 2024-11-19T14:10:39.165Z | 2024-11-22T14:22:53.474Z |
5553386 | 5553386 | 20241118021709_hvC7T | RU0008 | 2024-11-19T14:10:26.796Z | 2024-11-22T14:22:52.582Z |
5553259 | 5553259 | 20241118015157_ckHUX | RU0008 | 2024-11-19T14:10:13.033Z | 2024-11-22T14:22:51.490Z |
5553142 | 5553142 | 20241118010028_8S9Vh | RU0008 | 2024-11-19T14:10:05.819Z | 2024-11-22T14:22:50.757Z |
5553127 | 5553127 | 20241118005518_TVUhh | RU0008 | 2024-11-19T14:10:05.069Z | 2024-11-22T14:22:50.705Z |
5553116 | 5553116 | 20241118005111_HqT3x | RU0008 | 2024-11-19T14:10:04.270Z | 2024-11-22T14:22:50.638Z |
5553079 | 5553079 | 20241118003858_c9ZrH | RU0008 | 2024-11-19T14:10:01.907Z | 2024-11-22T14:22:50.378Z |
5553063 | 5553063 | 20241118003529_L5NAu | RU0008 | 2024-11-19T14:10:00.898Z | 2024-11-22T14:22:50.302Z |
5552983 | 5552983 | 20241117235438_AKLPk | RU0008 | 2024-11-19T14:09:54.795Z | 2024-11-22T14:22:49.684Z |
5552973 | 5552973 | 20241117235109_i0vkL | RU0008 | 2024-11-19T14:09:54.340Z | 2024-11-22T14:22:49.656Z |
5552966 | 5552966 | 20241117234853_LX81G | RU0008 | 2024-11-19T14:09:53.945Z | 2024-11-22T14:22:49.618Z |
5552923 | 5552923 | 20241117232913_6I8c7 | RU0008 | 2024-11-19T14:09:48.119Z | 2024-11-22T14:22:49.208Z |
5552908 | 5552908 | 20241117232105_uFE3J | RU0008 | 2024-11-19T14:09:42.211Z | 2024-11-22T14:22:49.046Z |
5552870 | 5552870 | 20241117225325_Y3WaF | RU0008 | 2024-11-19T14:09:30.973Z | 2024-11-22T14:22:47.819Z |
5552859 | 5552859 | 20241117224613_yMql0 | RU0008 | 2024-11-19T14:09:27.938Z | 2024-11-22T14:22:47.742Z |
5552856 | 5552856 | 20241117224538_Hl1WL | RU0008 | 2024-11-19T14:09:27.006Z | 2024-11-22T14:22:47.714Z |
5552849 | 5552849 | 20241117223955_OWHk7 | RU0008 | 2024-11-19T14:09:25.644Z | 2024-11-22T14:22:47.675Z |
5552810 | 5552810 | 20241117220511_zrZ4H | RU0008 | 2024-11-19T14:09:17.629Z | 2024-11-22T14:22:47.209Z |
5552802 | 5552802 | 20241117220119_0YTMx | RU0008 | 2024-11-19T14:09:16.360Z | 2024-11-22T14:22:47.170Z |
5552790 | 5552790 | 20241117215753_7JfSS | RU0008 | 2024-11-19T14:09:14.245Z | 2024-11-22T14:22:47.126Z |
5552777 | 5552777 | 20241117214029_q73Zd | RU0008 | 2024-11-19T14:09:12.391Z | 2024-11-22T14:22:46.845Z |
5552720 | 5552720 | 20241117204547_VKgyO | RU0008 | 2024-11-19T14:09:01.766Z | 2024-11-22T14:22:45.920Z |
5552687 | 5552687 | 20241117202038_GqQZw | RU0008 | 2024-11-19T14:08:55.689Z | 2024-11-22T14:22:45.343Z |
5552671 | 5552671 | 20241117195702_RPGRh | RU0008 | 2024-11-19T14:08:53.398Z | 2024-11-22T14:22:44.941Z |
5552555 | 5552555 | 20241117184134_3B2xj | RU0008 | 2024-11-19T14:08:38.727Z | 2024-11-22T14:22:42.042Z |
5552444 | 5552444 | 20241117155629_O3xSU | RU0008 | 2024-11-19T14:08:01.279Z | 2024-11-22T14:22:39.427Z |
5549046 | 5549046 | 20241117024946_eNlHy | RU0008 | 2024-11-18T14:10:46.520Z | 2024-11-22T14:23:17.695Z |
5549032 | 5549032 | 20241117024607_HBKyz | RU0008 | 2024-11-18T14:10:44.221Z | 2024-11-22T14:23:17.643Z |
5548933 | 5548933 | 20241117022341_x2KtX | RU0008 | 2024-11-18T14:10:28.289Z | 2024-11-22T14:23:17.135Z |
5548891 | 5548891 | 20241117020901_2Objv | RU0008 | 2024-11-18T14:10:24.031Z | 2024-11-22T14:23:16.710Z |
5548830 | 5548830 | 20241117015454_tOPGS | RU0008 | 2024-11-18T14:10:18.076Z | 2024-11-22T14:23:16.183Z |
5548794 | 5548794 | 20241117014129_sTdq3 | RU0008 | 2024-11-18T14:10:13.499Z | 2024-11-22T14:23:15.827Z |
5548775 | 5548775 | 20241117013700_1XmZD | RU0008 | 2024-11-18T14:10:11.818Z | 2024-11-22T14:23:15.661Z |
5548745 | 5548745 | 20241117012547_WyzeJ | RU0008 | 2024-11-18T14:10:08.855Z | 2024-11-22T14:23:15.426Z |
5548684 | 5548684 | 20241117010644_rHgqr | RU0008 | 2024-11-18T14:09:53.481Z | 2024-11-22T14:23:15.140Z |
5548679 | 5548679 | 20241117010531_qCzGP | RU0008 | 2024-11-18T14:09:50.824Z | 2024-11-22T14:23:15.115Z |
5548561 | 5548561 | 20241117002015_d3t22 | RU0008 | 2024-11-18T14:09:28.767Z | 2024-11-22T14:23:14.361Z |
5548538 | 5548538 | 20241117001048_p3jmx | RU0008 | 2024-11-18T14:09:25.439Z | 2024-11-22T14:23:14.194Z |
5548498 | 5548498 | 20241116235759_eUQ5A | RU0008 | 2024-11-18T14:09:21.513Z | 2024-11-22T14:23:13.707Z |
5548483 | 5548483 | 20241116235042_cb83i | RU0008 | 2024-11-18T14:09:19.729Z | 2024-11-22T14:23:13.578Z |
5548433 | 5548433 | 20241116232956_a0E93 | RU0008 | 2024-11-18T14:09:12.955Z | 2024-11-22T14:23:13.093Z |
5548388 | 5548388 | 20241116230530_xTQ6T | RU0008 | 2024-11-18T14:09:06.100Z | 2024-11-22T14:23:12.502Z |
5548361 | 5548361 | 20241116225030_N3J3k | RU0008 | 2024-11-18T14:08:55.599Z | 2024-11-22T14:23:12.278Z |
5548317 | 5548317 | 20241116222517_vR6p3 | RU0008 | 2024-11-18T14:08:44.300Z | 2024-11-22T14:23:11.906Z |
5548298 | 5548298 | 20241116221255_zNGmI | RU0008 | 2024-11-18T14:08:41.502Z | 2024-11-22T14:23:11.784Z |
5548296 | 5548296 | 20241116221202_Dh2el | RU0008 | 2024-11-18T14:08:41.392Z | 2024-11-22T14:23:11.771Z |
5548288 | 5548288 | 20241116220821_Vzeeg | RU0008 | 2024-11-18T14:08:40.053Z | 2024-11-22T14:23:11.721Z |
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);