participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,645 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 |
---|---|---|---|---|---|
5523908 | 5523908 | 20241111024654_sim4C | RU0008 | 2024-11-12T14:16:19.887Z | 2024-11-12T14:18:08.392Z |
5523904 | 5523904 | 20241111024532_p48GR | RU0008 | 2024-11-12T14:16:19.583Z | 2024-11-12T14:18:08.390Z |
5523600 | 5523600 | 20241111015307_3rqgs | RU0008 | 2024-11-12T14:16:03.077Z | 2024-11-12T14:18:08.267Z |
5523185 | 5523185 | 20241111002356_BnFn1 | RU0008 | 2024-11-12T14:14:55.413Z | 2024-11-12T14:18:08.073Z |
5523060 | 5523060 | 20241110235206_eCFOW | RU0008 | 2024-11-12T14:14:43.176Z | 2024-11-12T14:18:08.015Z |
5522853 | 5522853 | 20241110222138_PTglY | RU0008 | 2024-11-12T14:14:24.398Z | 2024-11-12T14:18:07.926Z |
5522776 | 5522776 | 20241110212703_o9qq8 | RU0008 | 2024-11-12T14:14:14.956Z | 2024-11-12T14:18:07.890Z |
5522763 | 5522763 | 20241110212059_hj90l | RU0008 | 2024-11-12T14:14:10.937Z | 2024-11-12T14:18:07.885Z |
5522752 | 5522752 | 20241110211645_Eu2wz | RU0008 | 2024-11-12T14:14:07.090Z | 2024-11-12T14:18:07.880Z |
5522741 | 5522741 | 20241110211233_JI9l9 | RU0008 | 2024-11-12T14:14:04.755Z | 2024-11-12T14:18:07.875Z |
5522680 | 5522680 | 20241110210238_56TCb | RU0008 | 2024-11-12T14:13:57.811Z | 2024-11-12T14:18:07.853Z |
5522675 | 5522675 | 20241110205848_ZHD4u | RU0008 | 2024-11-12T14:13:57.343Z | 2024-11-12T14:18:07.851Z |
5522576 | 5522576 | 20241110203709_aPOSN | RU0008 | 2024-11-12T14:13:39.368Z | 2024-11-12T14:18:07.808Z |
5522481 | 5522481 | 20241110201010_2UUHS | RU0008 | 2024-11-12T14:13:21.198Z | 2024-11-12T14:18:07.764Z |
5522400 | 5522400 | 20241110195528_9SZEo | RU0008 | 2024-11-12T14:13:11.107Z | 2024-11-12T14:18:07.728Z |
5522201 | 5522201 | 20241110192433_NdwOA | RU0008 | 2024-11-12T14:12:57.690Z | 2024-11-12T14:18:07.646Z |
5522193 | 5522193 | 20241110192347_sUOnK | RU0008 | 2024-11-12T14:12:56.774Z | 2024-11-12T14:18:07.642Z |
5522115 | 5522115 | 20241110190816_mlSZp | RU0008 | 2024-11-12T14:12:51.361Z | 2024-11-12T14:18:07.602Z |
5521927 | 5521927 | 20241110183603_FXtIP | RU0008 | 2024-11-12T14:12:11.515Z | 2024-11-12T14:18:07.521Z |
5521589 | 5521589 | 20241110173921_Bdpt2 | RU0008 | 2024-11-12T14:11:41.588Z | 2024-11-12T14:18:07.370Z |
5521418 | 5521418 | 20241110170738_9QMFH | RU0008 | 2024-11-12T14:11:05.053Z | 2024-11-12T14:18:07.286Z |
5521367 | 5521367 | 20241110165723_Yx5Fc | RU0008 | 2024-11-12T14:10:54.875Z | 2024-11-12T14:18:07.263Z |
5521296 | 5521296 | 20241110164612_XiSFP | RU0008 | 2024-11-12T14:10:44.857Z | 2024-11-12T14:18:07.223Z |
5521253 | 5521253 | 20241110163817_Z1Jn4 | RU0008 | 2024-11-12T14:10:41.219Z | 2024-11-12T14:18:07.206Z |
5521058 | 5521058 | 20241110155244_WvRhF | RU0008 | 2024-11-12T14:10:21.206Z | 2024-11-12T14:18:07.121Z |
5520931 | 5520931 | 20241110152828_HLjfw | RU0008 | 2024-11-12T14:09:50.518Z | 2024-11-12T14:18:07.025Z |
5520912 | 5520912 | 20241110152155_GuzB0 | RU0008 | 2024-11-12T14:09:45.979Z | 2024-11-12T14:18:07.001Z |
5517102 | 5517102 | 20241110024810_Ddb9c | RU0008 | 2024-11-11T14:13:54.496Z | 2024-11-12T14:21:31.744Z |
5517061 | 5517061 | 20241110024112_p7Ala | RU0008 | 2024-11-11T14:13:49.297Z | 2024-11-12T14:21:30.297Z |
5517046 | 5517046 | 20241110023909_aNiIZ | RU0008 | 2024-11-11T14:13:47.451Z | 2024-11-12T14:21:29.669Z |
5517044 | 5517044 | 20241110023906_KLgi2 | RU0008 | 2024-11-11T14:13:46.701Z | 2024-11-12T14:21:29.629Z |
5517001 | 5517001 | 20241110023126_1ciNd | RU0008 | 2024-11-11T14:13:41.974Z | 2024-11-12T14:21:26.205Z |
5516979 | 5516979 | 20241110022915_4hAx2 | RU0008 | 2024-11-11T14:13:40.157Z | 2024-11-12T14:21:25.642Z |
5516883 | 5516883 | 20241110021433_qPDw3 | RU0008 | 2024-11-11T14:13:28.352Z | 2024-11-12T14:21:22.926Z |
5516873 | 5516873 | 20241110021303_XoWrk | RU0008 | 2024-11-11T14:13:27.517Z | 2024-11-12T14:21:22.742Z |
5516819 | 5516819 | 20241110020652_wCzV9 | RU0008 | 2024-11-11T14:13:24.684Z | 2024-11-12T14:21:20.889Z |
5516709 | 5516709 | 20241110014739_XojFw | RU0008 | 2024-11-11T14:13:16.195Z | 2024-11-12T14:21:16.783Z |
5516595 | 5516595 | 20241110012717_Fmzuw | RU0008 | 2024-11-11T14:13:10.454Z | 2024-11-12T14:21:12.951Z |
5516571 | 5516571 | 20241110012329_RyR3U | RU0008 | 2024-11-11T14:13:09.359Z | 2024-11-12T14:21:12.324Z |
5516565 | 5516565 | 20241110012136_qSusc | RU0008 | 2024-11-11T14:13:08.955Z | 2024-11-12T14:21:11.933Z |
5516551 | 5516551 | 20241110011838_Z4Uxi | RU0008 | 2024-11-11T14:13:08.161Z | 2024-11-12T14:21:11.164Z |
5516505 | 5516505 | 20241110010916_ZDmBu | RU0008 | 2024-11-11T14:13:05.434Z | 2024-11-12T14:21:07.757Z |
5516482 | 5516482 | 20241110010604_w46uU | RU0008 | 2024-11-11T14:13:03.850Z | 2024-11-12T14:21:07.092Z |
5516455 | 5516455 | 20241110010315_VCQ2O | RU0008 | 2024-11-11T14:13:02.195Z | 2024-11-12T14:21:05.757Z |
5516399 | 5516399 | 20241110005231_ZAUVv | RU0008 | 2024-11-11T14:12:58.881Z | 2024-11-12T14:21:04.415Z |
5516371 | 5516371 | 20241110004850_NWtvG | RU0008 | 2024-11-11T14:12:53.838Z | 2024-11-12T14:21:03.471Z |
5516352 | 5516352 | 20241110004454_lvGgA | RU0008 | 2024-11-11T14:12:50.846Z | 2024-11-12T14:21:02.590Z |
5516314 | 5516314 | 20241110003748_uKKhr | RU0008 | 2024-11-11T14:12:43.701Z | 2024-11-12T14:20:59.994Z |
5516202 | 5516202 | 20241110001245_M1vJa | RU0008 | 2024-11-11T14:12:27.076Z | 2024-11-12T14:20:53.678Z |
5516111 | 5516111 | 20241109235341_3Ycr6 | RU0008 | 2024-11-11T14:12:15.861Z | 2024-11-12T14:20:50.686Z |
5516107 | 5516107 | 20241109235318_eIJwM | RU0008 | 2024-11-11T14:12:13.890Z | 2024-11-12T14:20:50.550Z |
5516105 | 5516105 | 20241109235310_0w4SB | RU0008 | 2024-11-11T14:12:13.647Z | 2024-11-12T14:20:50.494Z |
5516103 | 5516103 | 20241109235308_zrpWX | RU0008 | 2024-11-11T14:12:13.405Z | 2024-11-12T14:20:50.454Z |
5516070 | 5516070 | 20241109234515_lfuI3 | RU0008 | 2024-11-11T14:12:07.205Z | 2024-11-12T14:20:48.636Z |
5516065 | 5516065 | 20241109234408_eBnmu | RU0008 | 2024-11-11T14:12:06.776Z | 2024-11-12T14:20:48.438Z |
5516044 | 5516044 | 20241109234056_yR85u | RU0008 | 2024-11-11T14:12:02.650Z | 2024-11-12T14:20:47.948Z |
5515877 | 5515877 | 20241109230159_3iJvu | RU0008 | 2024-11-11T14:11:40.837Z | 2024-11-12T14:20:42.558Z |
5515865 | 5515865 | 20241109230002_boxhB | RU0008 | 2024-11-11T14:11:39.778Z | 2024-11-12T14:20:41.700Z |
5515861 | 5515861 | 20241109225941_DnQzx | RU0008 | 2024-11-11T14:11:39.271Z | 2024-11-12T14:20:41.598Z |
5515859 | 5515859 | 20241109225917_oehxO | RU0008 | 2024-11-11T14:11:38.903Z | 2024-11-12T14:20:41.406Z |
5515832 | 5515832 | 20241109225342_7xCrk | RU0008 | 2024-11-11T14:11:35.120Z | 2024-11-12T14:20:40.333Z |
5515814 | 5515814 | 20241109225004_mW52M | RU0008 | 2024-11-11T14:11:32.127Z | 2024-11-12T14:20:39.785Z |
5515759 | 5515759 | 20241109223703_ULMuO | RU0008 | 2024-11-11T14:11:26.827Z | 2024-11-12T14:20:36.710Z |
5515749 | 5515749 | 20241109223503_l94y5 | RU0008 | 2024-11-11T14:11:26.145Z | 2024-11-12T14:20:36.308Z |
5515706 | 5515706 | 20241109222804_YH2Ob | RU0008 | 2024-11-11T14:11:23.561Z | 2024-11-12T14:20:34.903Z |
5515666 | 5515666 | 20241109221803_Ar0T0 | RU0008 | 2024-11-11T14:11:20.528Z | 2024-11-12T14:20:32.523Z |
5515662 | 5515662 | 20241109221638_fMjg5 | RU0008 | 2024-11-11T14:11:20.210Z | 2024-11-12T14:20:32.397Z |
5515625 | 5515625 | 20241109221142_vpcLE | RU0008 | 2024-11-11T14:11:18.046Z | 2024-11-12T14:20:30.453Z |
5515615 | 5515615 | 20241109221011_fPF6G | RU0008 | 2024-11-11T14:11:17.553Z | 2024-11-12T14:20:30.243Z |
5515599 | 5515599 | 20241109220719_GRGCB | RU0008 | 2024-11-11T14:11:16.390Z | 2024-11-12T14:20:29.657Z |
5515597 | 5515597 | 20241109220657_bCUil | RU0008 | 2024-11-11T14:11:16.238Z | 2024-11-12T14:20:29.544Z |
5515568 | 5515568 | 20241109220101_mOlIT | RU0008 | 2024-11-11T14:11:13.958Z | 2024-11-12T14:20:27.438Z |
5515553 | 5515553 | 20241109215657_pk2cb | RU0008 | 2024-11-11T14:11:13.100Z | 2024-11-12T14:20:26.695Z |
5515499 | 5515499 | 20241109213954_z8ms2 | RU0008 | 2024-11-11T14:11:08.743Z | 2024-11-12T14:20:24.431Z |
5515497 | 5515497 | 20241109213904_cOETO | RU0008 | 2024-11-11T14:11:08.483Z | 2024-11-12T14:20:24.374Z |
5515418 | 5515418 | 20241109212054_MCn4E | RU0008 | 2024-11-11T14:11:01.230Z | 2024-11-12T14:20:21.715Z |
5515398 | 5515398 | 20241109210915_I3I82 | RU0008 | 2024-11-11T14:10:55.863Z | 2024-11-12T14:20:20.891Z |
5515330 | 5515330 | 20241109203716_7Hg1a | RU0008 | 2024-11-11T14:10:45.987Z | 2024-11-12T14:20:17.913Z |
5515313 | 5515313 | 20241109203016_WTeaD | RU0008 | 2024-11-11T14:10:41.912Z | 2024-11-12T14:20:17.383Z |
5515165 | 5515165 | 20241109194310_0CDlD | RU0008 | 2024-11-11T14:10:13.419Z | 2024-11-12T14:20:11.081Z |
5515072 | 5515072 | 20241109191525_RtuOP | RU0008 | 2024-11-11T14:10:00.367Z | 2024-11-12T14:20:06.216Z |
5514950 | 5514950 | 20241109184023_eTxg1 | RU0008 | 2024-11-11T14:09:47.405Z | 2024-11-12T14:19:58.645Z |
5514883 | 5514883 | 20241109181831_2Tebq | RU0008 | 2024-11-11T14:09:40.479Z | 2024-11-12T14:19:54.673Z |
5514841 | 5514841 | 20241109180031_1YC20 | RU0008 | 2024-11-11T14:09:29.939Z | 2024-11-12T14:19:52.355Z |
5514743 | 5514743 | 20241109171752_jsK3B | RU0008 | 2024-11-11T14:09:06.120Z | 2024-11-12T14:19:45.337Z |
5514736 | 5514736 | 20241109171221_kgytX | RU0008 | 2024-11-11T14:09:05.551Z | 2024-11-12T14:19:44.803Z |
5504644 | 5504644 | 20241108023203_2AmVO | RU0008 | 2024-11-09T14:15:00.273Z | 2024-11-12T14:25:05.728Z |
5490310 | 5490310 | 20241105220846_z4wKM | RU0008 | 2024-11-07T14:13:51.413Z | 2024-11-12T14:26:47.747Z |
5462558 | 5462558 | 20241102004531_zTHtj | RU0008 | 2024-11-03T14:17:40.495Z | 2024-11-10T14:26:32.808Z |
5462523 | 5462523 | 20241102004112_9FXu4 | RU0008 | 2024-11-03T14:17:36.577Z | 2024-11-10T14:26:32.771Z |
5462362 | 5462362 | 20241101235932_8JTJw | RU0008 | 2024-11-03T14:17:19.677Z | 2024-11-10T14:26:32.405Z |
5461886 | 5461886 | 20241101215829_c5kX5 | RU0008 | 2024-11-03T14:16:35.359Z | 2024-11-10T14:26:30.741Z |
5453560 | 5453560 | 20241031022510_20KxA | RU0008 | 2024-11-02T12:22:36.053Z | 2024-11-08T14:23:18.087Z |
5442293 | 5442293 | 20241030010928_V3rFu | RU0008 | 2024-11-01T12:19:40.336Z | 2024-11-07T14:26:46.027Z |
5442096 | 5442096 | 20241030003616_GiZ33 | RU0008 | 2024-11-01T12:19:25.023Z | 2024-11-07T14:26:44.990Z |
5441339 | 5441339 | 20241029214736_a0DAn | RU0008 | 2024-11-01T12:18:27.738Z | 2024-11-07T14:26:41.754Z |
5429231 | 5429231 | 20241028190251_yklzF | RU0008 | 2024-10-31T12:16:15.309Z | 2024-11-06T14:27:15.569Z |
5386823 | 5386823 | 20241025013130_PcRIG | RU0008 | 2024-10-27T12:20:34.722Z | 2024-11-02T12:28:31.654Z |
5363244 | 5363244 | 20241023203901_2qDf0 | RU0008 | 2024-10-25T12:15:44.353Z | 2024-11-01T12:26:52.996Z |
5361975 | 5361975 | 20241023185936_SHhn5 | RU0008 | 2024-10-25T12:13:42.999Z | 2024-11-01T12:26:50.781Z |
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);