participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,309 rows where station_code = "RU000M" 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 |
---|---|---|---|---|---|
5114341 | 5114341 | 20240915013728_jKGSk | RU000M | 2024-09-18T12:05:11.729Z | 2024-09-19T12:18:57.619Z |
5113693 | 5113693 | 20240915010650_r9glN | RU000M | 2024-09-18T12:04:41.925Z | 2024-09-19T12:18:51.485Z |
5113645 | 5113645 | 20240915010147_MRm4A | RU000M | 2024-09-18T12:04:36.000Z | 2024-09-19T12:18:50.732Z |
5113584 | 5113584 | 20240915005954_oZwkr | RU000M | 2024-09-18T12:04:33.737Z | 2024-09-19T12:18:50.509Z |
5113320 | 5113320 | 20240915003813_yW38y | RU000M | 2024-09-18T12:04:08.370Z | 2024-09-19T12:18:48.484Z |
5112696 | 5112696 | 20240914234223_IbN3H | RU000M | 2024-09-18T12:03:22.715Z | 2024-09-19T12:18:43.511Z |
5104104 | 5104104 | 20240913015253_O2Xgu | RU000M | 2024-09-17T12:11:25.566Z | 2024-09-19T12:20:41.032Z |
5103791 | 5103791 | 20240913014001_2XfH8 | RU000M | 2024-09-17T12:11:10.610Z | 2024-09-19T12:20:40.560Z |
5103354 | 5103354 | 20240913012858_CofcA | RU000M | 2024-09-17T12:10:54.998Z | 2024-09-19T12:20:40.108Z |
5103331 | 5103331 | 20240913012631_2iaBQ | RU000M | 2024-09-17T12:10:51.149Z | 2024-09-19T12:20:40.034Z |
5103266 | 5103266 | 20240912230437_iTmBR | RU000M | 2024-09-17T12:09:49.316Z | 2024-09-19T12:20:33.700Z |
5101365 | 5101365 | 20240914002213_mxmIy | RU000M | 2024-09-17T12:05:39.093Z | 2024-09-19T12:19:50.381Z |
5101148 | 5101148 | 20240914000652_TbSRZ | RU000M | 2024-09-17T12:05:22.201Z | 2024-09-19T12:19:49.862Z |
5100966 | 5100966 | 20240913235519_3VpEI | RU000M | 2024-09-17T12:05:12.247Z | 2024-09-19T12:19:49.409Z |
5100622 | 5100622 | 20240913233532_opW1P | RU000M | 2024-09-17T12:04:44.132Z | 2024-09-19T12:19:48.232Z |
5098214 | 5098214 | 20240913012242_ecR2G | RU000M | 2024-09-16T12:17:21.766Z | 2024-09-19T12:20:39.903Z |
5097676 | 5097676 | 20240913005755_jcJdj | RU000M | 2024-09-16T12:17:13.982Z | 2024-09-19T12:20:38.891Z |
5097206 | 5097206 | 20240913003614_idA0E | RU000M | 2024-09-16T12:17:07.747Z | 2024-09-19T12:20:37.849Z |
5097204 | 5097204 | 20240913003553_ADL3i | RU000M | 2024-09-16T12:17:07.676Z | 2024-09-19T12:20:37.846Z |
5088577 | 5088577 | 20240913001749_XQYbb | RU000M | 2024-09-16T12:08:13.990Z | 2024-09-19T12:20:37.035Z |
5088054 | 5088054 | 20240912235510_Kmt32 | RU000M | 2024-09-16T12:07:42.644Z | 2024-09-19T12:20:36.326Z |
5087265 | 5087265 | 20240912231920_zmwdi | RU000M | 2024-09-16T12:06:49.995Z | 2024-09-19T12:20:34.546Z |
5086996 | 5086996 | 20240912230056_igkIp | RU000M | 2024-09-16T12:06:22.264Z | 2024-09-19T12:20:33.406Z |
5086409 | 5086409 | 20240912223244_Jh3pO | RU000M | 2024-09-16T12:05:42.977Z | 2024-09-19T12:20:31.157Z |
5085172 | 5085172 | 20240912205418_nrVfw | RU000M | 2024-09-16T12:03:38.983Z | 2024-09-19T12:20:28.165Z |
5084999 | 5084999 | 20240912203908_47dAG | RU000M | 2024-09-16T12:03:24.293Z | 2024-09-19T12:20:27.665Z |
5077887 | 5077887 | 20240911012701_qqbEN | RU000M | 2024-09-15T12:15:09.894Z | 2024-09-19T12:21:39.765Z |
5077744 | 5077744 | 20240911011438_lj9UV | RU000M | 2024-09-15T12:15:02.749Z | 2024-09-19T12:21:39.591Z |
5077689 | 5077689 | 20240911011051_X72lQ | RU000M | 2024-09-15T12:14:59.784Z | 2024-09-19T12:21:39.511Z |
5077645 | 5077645 | 20240911010728_riLux | RU000M | 2024-09-15T12:14:56.219Z | 2024-09-19T12:21:39.463Z |
5077619 | 5077619 | 20240911010624_Z65EA | RU000M | 2024-09-15T12:14:54.772Z | 2024-09-19T12:21:39.448Z |
5077583 | 5077583 | 20240911010429_o9ffi | RU000M | 2024-09-15T12:14:53.183Z | 2024-09-19T12:21:39.390Z |
5077508 | 5077508 | 20240911010026_7n3Br | RU000M | 2024-09-15T12:14:49.905Z | 2024-09-19T12:21:39.311Z |
5077270 | 5077270 | 20240911004007_kiJp5 | RU000M | 2024-09-15T12:14:35.985Z | 2024-09-19T12:21:38.611Z |
5077261 | 5077261 | 20240911003905_1i6Hl | RU000M | 2024-09-15T12:14:35.099Z | 2024-09-19T12:21:38.605Z |
5076959 | 5076959 | 20240911001749_g5kkl | RU000M | 2024-09-15T12:14:14.957Z | 2024-09-19T12:21:37.909Z |
5076687 | 5076687 | 20240910235951_67THE | RU000M | 2024-09-15T12:13:55.116Z | 2024-09-19T12:21:37.461Z |
5076476 | 5076476 | 20240910233914_7VZC0 | RU000M | 2024-09-15T12:13:37.523Z | 2024-09-19T12:21:37.288Z |
5076457 | 5076457 | 20240910233704_SCcKd | RU000M | 2024-09-15T12:13:35.164Z | 2024-09-19T12:21:37.228Z |
5076455 | 5076455 | 20240910233641_0zIjb | RU000M | 2024-09-15T12:13:35.003Z | 2024-09-19T12:21:37.223Z |
5076410 | 5076410 | 20240910233217_O8RLv | RU000M | 2024-09-15T12:13:33.001Z | 2024-09-19T12:21:37.032Z |
5076367 | 5076367 | 20240910232818_BIWy6 | RU000M | 2024-09-15T12:13:30.205Z | 2024-09-19T12:21:36.757Z |
5076242 | 5076242 | 20240910231633_7lPQH | RU000M | 2024-09-15T12:13:24.633Z | 2024-09-19T12:21:36.655Z |
5076214 | 5076214 | 20240910231446_twa56 | RU000M | 2024-09-15T12:13:22.910Z | 2024-09-19T12:21:36.618Z |
5076157 | 5076157 | 20240910230952_uC8Up | RU000M | 2024-09-15T12:13:20.387Z | 2024-09-19T12:21:36.504Z |
5076122 | 5076122 | 20240910230745_CHcl2 | RU000M | 2024-09-15T12:13:18.464Z | 2024-09-19T12:21:36.459Z |
5076089 | 5076089 | 20240910230711_K2QgI | RU000M | 2024-09-15T12:13:17.698Z | 2024-09-19T12:21:36.436Z |
5076078 | 5076078 | 20240910230634_AjybW | RU000M | 2024-09-15T12:13:17.131Z | 2024-09-19T12:21:36.421Z |
5074423 | 5074423 | 20240911223907_MDdf2 | RU000M | 2024-09-15T12:08:32.452Z | 2024-09-19T12:21:07.313Z |
5074350 | 5074350 | 20240911223257_92uDX | RU000M | 2024-09-15T12:08:25.902Z | 2024-09-19T12:21:07.115Z |
5073900 | 5073900 | 20240911215253_XlAPB | RU000M | 2024-09-15T12:07:43.223Z | 2024-09-19T12:21:06.384Z |
5073808 | 5073808 | 20240911214503_2QYdv | RU000M | 2024-09-15T12:07:38.943Z | 2024-09-19T12:21:06.254Z |
5073358 | 5073358 | 20240911211600_dbLI1 | RU000M | 2024-09-15T12:07:05.535Z | 2024-09-19T12:21:05.690Z |
5072014 | 5072014 | 20240911192204_FC15r | RU000M | 2024-09-15T12:04:21.094Z | 2024-09-19T12:21:03.302Z |
5072008 | 5072008 | 20240911192049_5Jvid | RU000M | 2024-09-15T12:04:19.004Z | 2024-09-19T12:21:03.265Z |
5071864 | 5071864 | 20240911183947_602UQ | RU000M | 2024-09-15T12:03:52.492Z | 2024-09-19T12:21:02.896Z |
5071501 | 5071501 | 20240911170846_t2kHv | RU000M | 2024-09-15T12:02:43.252Z | 2024-09-19T12:21:02.021Z |
5070085 | 5070085 | 20240910223337_27Qxb | RU000M | 2024-09-14T12:20:14.229Z | 2024-09-19T12:21:35.756Z |
5070055 | 5070055 | 20240910222702_rnWpD | RU000M | 2024-09-14T12:20:13.525Z | 2024-09-19T12:21:35.697Z |
5069248 | 5069248 | 20240910212258_w53wN | RU000M | 2024-09-14T12:19:50.077Z | 2024-09-19T12:21:34.071Z |
5069186 | 5069186 | 20240910211646_8gDMc | RU000M | 2024-09-14T12:19:47.721Z | 2024-09-19T12:21:33.816Z |
5069136 | 5069136 | 20240910211420_EHnHm | RU000M | 2024-09-14T12:19:46.484Z | 2024-09-19T12:21:33.752Z |
5069110 | 5069110 | 20240910211010_VLlLW | RU000M | 2024-09-14T12:19:45.544Z | 2024-09-19T12:21:33.664Z |
5060731 | 5060731 | 20240910205749_mw4Er | RU000M | 2024-09-14T12:09:25.883Z | 2024-09-19T12:21:33.513Z |
5060650 | 5060650 | 20240910204805_axj7x | RU000M | 2024-09-14T12:09:17.437Z | 2024-09-19T12:21:33.400Z |
5060528 | 5060528 | 20240910203543_2gtBr | RU000M | 2024-09-14T12:08:57.963Z | 2024-09-19T12:21:32.509Z |
5060524 | 5060524 | 20240910203447_Vkl4A | RU000M | 2024-09-14T12:08:56.290Z | 2024-09-19T12:21:32.475Z |
5060473 | 5060473 | 20240910203233_AmvFF | RU000M | 2024-09-14T12:08:50.903Z | 2024-09-19T12:21:32.426Z |
5059823 | 5059823 | 20240910190022_nRvaN | RU000M | 2024-09-14T12:07:20.889Z | 2024-09-19T12:21:31.299Z |
5059808 | 5059808 | 20240910185826_UZ09f | RU000M | 2024-09-14T12:07:17.921Z | 2024-09-19T12:21:31.281Z |
5059753 | 5059753 | 20240910184425_IB6zH | RU000M | 2024-09-14T12:07:06.214Z | 2024-09-19T12:21:31.219Z |
5059651 | 5059651 | 20240910182438_923ju | RU000M | 2024-09-14T12:06:39.951Z | 2024-09-19T12:21:30.974Z |
5053668 | 5053668 | 20240908011347_Tq2A7 | RU000M | 2024-09-13T12:16:13.029Z | 2024-09-16T12:21:12.369Z |
5046755 | 5046755 | 20240909011253_uLqs5 | RU000M | 2024-09-13T12:07:27.215Z | 2024-09-17T12:19:00.256Z |
5046499 | 5046499 | 20240908235259_PhKsS | RU000M | 2024-09-13T12:06:48.615Z | 2024-09-17T12:18:59.430Z |
5038649 | 5038649 | 20240905211814_e3jnE | RU000M | 2024-09-12T12:14:53.236Z | 2024-09-14T12:22:57.023Z |
5025823 | 5025823 | 20240905012336_C7MMW | RU000M | 2024-09-11T12:11:09.739Z | 2024-09-13T12:19:55.805Z |
5025662 | 5025662 | 20240905005149_bSAI2 | RU000M | 2024-09-11T12:10:44.227Z | 2024-09-13T12:19:55.102Z |
5024219 | 5024219 | 20240905211814_wuny2 | RU000M | 2024-09-11T12:02:59.349Z | 2024-09-11T12:16:32.014Z |
5020259 | 5020259 | 20240905012336_YKcw3 | RU000M | 2024-09-10T12:14:11.313Z | 2024-09-10T12:16:55.111Z |
5020083 | 5020083 | 20240905005149_Job9p | RU000M | 2024-09-10T12:13:54.601Z | 2024-09-13T12:19:55.029Z |
5019956 | 5019956 | 20240905002448_jWA26 | RU000M | 2024-09-10T12:13:45.751Z | 2024-09-13T12:19:54.617Z |
5019901 | 5019901 | 20240905001556_0Zv6p | RU000M | 2024-09-10T12:13:41.774Z | 2024-09-13T12:19:54.386Z |
5019777 | 5019777 | 20240904234902_qBBE0 | RU000M | 2024-09-10T12:13:28.658Z | 2024-09-13T12:19:53.732Z |
5019751 | 5019751 | 20240904234611_BCn35 | RU000M | 2024-09-10T12:13:24.494Z | 2024-09-13T12:19:53.684Z |
5019448 | 5019448 | 20240904225008_IBe1M | RU000M | 2024-09-10T12:12:45.704Z | 2024-09-13T12:19:52.039Z |
5019383 | 5019383 | 20240904224103_j3pUI | RU000M | 2024-09-10T12:12:41.158Z | 2024-09-13T12:19:51.612Z |
5019313 | 5019313 | 20240904222943_wJuQU | RU000M | 2024-09-10T12:12:36.084Z | 2024-09-13T12:19:51.359Z |
5018940 | 5018940 | 20240904211042_5k76a | RU000M | 2024-09-10T12:11:47.600Z | 2024-09-13T12:19:49.890Z |
5009395 | 5009395 | 20240904011839_oiWhk | RU000M | 2024-09-09T12:07:41.896Z | 2024-09-12T12:19:22.627Z |
5009104 | 5009104 | 20240904005448_FDPPO | RU000M | 2024-09-09T12:07:25.172Z | 2024-09-12T12:19:21.584Z |
5008892 | 5008892 | 20240904003313_wrh2C | RU000M | 2024-09-09T12:07:10.199Z | 2024-09-12T12:19:20.468Z |
5008561 | 5008561 | 20240903235422_mgOpa | RU000M | 2024-09-09T12:06:53.058Z | 2024-09-12T12:19:18.075Z |
5008530 | 5008530 | 20240903235123_2K2E8 | RU000M | 2024-09-09T12:06:51.753Z | 2024-09-12T12:19:18.029Z |
5008456 | 5008456 | 20240903234520_lQe7x | RU000M | 2024-09-09T12:06:45.462Z | 2024-09-12T12:19:17.711Z |
5008404 | 5008404 | 20240903234030_tpTTP | RU000M | 2024-09-09T12:06:42.580Z | 2024-09-12T12:19:17.471Z |
5008311 | 5008311 | 20240903233231_yr2h6 | RU000M | 2024-09-09T12:06:36.803Z | 2024-09-12T12:19:17.066Z |
5008186 | 5008186 | 20240903231639_cdcgq | RU000M | 2024-09-09T12:06:30.893Z | 2024-09-12T12:19:16.410Z |
5008050 | 5008050 | 20240903225644_26Mhs | RU000M | 2024-09-09T12:06:20.771Z | 2024-09-12T12:19:15.956Z |
5006570 | 5006570 | 20240903175512_yqCAD | RU000M | 2024-09-09T12:04:46.771Z | 2024-09-12T12:19:08.936Z |
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);