participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,396 rows where station_code = "RU000T" 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 |
---|---|---|---|---|---|
5135338 | 5135338 | 20240915123525_WQSJF | RU000T | 2024-09-19T12:19:28.750Z | 2024-09-19T12:19:28.750Z |
5135229 | 5135229 | 20240916171019_Dt8KR | RU000T | 2024-09-19T12:18:16.968Z | 2024-09-19T12:18:16.968Z |
5135207 | 5135207 | 20240916170131_2qS1X | RU000T | 2024-09-19T12:18:16.633Z | 2024-09-19T12:18:16.633Z |
5135160 | 5135160 | 20240916164926_TuPRF | RU000T | 2024-09-19T12:18:16.049Z | 2024-09-19T12:18:16.049Z |
5135128 | 5135128 | 20240916163227_c0XtH | RU000T | 2024-09-19T12:18:15.357Z | 2024-09-19T12:18:15.357Z |
5135026 | 5135026 | 20240916152918_8ujmf | RU000T | 2024-09-19T12:18:13.010Z | 2024-09-19T12:18:13.010Z |
5134863 | 5134863 | 20240916131148_EEy1K | RU000T | 2024-09-19T12:18:08.568Z | 2024-09-19T12:18:08.568Z |
5134691 | 5134691 | 20240916111923_Ej8Kg | RU000T | 2024-09-19T12:18:03.572Z | 2024-09-19T12:18:03.572Z |
5126729 | 5126729 | 20240916184126_Vrh2e | RU000T | 2024-09-19T12:06:56.302Z | 2024-09-19T12:06:56.302Z |
5126673 | 5126673 | 20240916174341_1aYiB | RU000T | 2024-09-19T12:06:46.278Z | 2024-09-19T12:06:46.278Z |
5124199 | 5124199 | 20240914161028_mCLbS | RU000T | 2024-09-18T12:12:10.854Z | 2024-09-19T12:20:18.518Z |
5124121 | 5124121 | 20240914152754_y7Oi6 | RU000T | 2024-09-18T12:12:08.557Z | 2024-09-19T12:20:17.989Z |
5124027 | 5124027 | 20240914135811_mosCV | RU000T | 2024-09-18T12:12:03.846Z | 2024-09-19T12:20:17.430Z |
5123980 | 5123980 | 20240914130726_i2wPJ | RU000T | 2024-09-18T12:12:02.207Z | 2024-09-19T12:20:16.932Z |
5123704 | 5123704 | 20240914111139_ASJ9G | RU000T | 2024-09-18T12:11:54.583Z | 2024-09-19T12:20:14.052Z |
5110349 | 5110349 | 20240913152539_jzhEv | RU000T | 2024-09-17T12:15:06.344Z | 2024-09-19T12:20:56.786Z |
5110329 | 5110329 | 20240913151049_BzMS0 | RU000T | 2024-09-17T12:15:05.379Z | 2024-09-19T12:20:56.680Z |
5110187 | 5110187 | 20240913130437_C53AO | RU000T | 2024-09-17T12:14:58.904Z | 2024-09-19T12:20:56.040Z |
5098440 | 5098440 | 20240913171647_WKpmh | RU000T | 2024-09-17T12:00:36.578Z | 2024-09-19T12:19:37.049Z |
5098408 | 5098408 | 20240913170257_QbAvI | RU000T | 2024-09-17T12:00:30.053Z | 2024-09-19T12:19:36.925Z |
5098406 | 5098406 | 20240913165945_SUvH8 | RU000T | 2024-09-17T12:00:29.523Z | 2024-09-19T12:19:36.908Z |
5098375 | 5098375 | 20240913164504_5ki2n | RU000T | 2024-09-17T12:00:23.684Z | 2024-09-19T12:19:36.648Z |
5098335 | 5098335 | 20240913161439_s7831 | RU000T | 2024-09-17T12:00:15.635Z | 2024-09-19T12:19:36.325Z |
5098331 | 5098331 | 20240913160849_aTOdR | RU000T | 2024-09-17T12:00:14.313Z | 2024-09-19T12:19:36.286Z |
5084292 | 5084292 | 20240912191236_vi4TR | RU000T | 2024-09-16T12:01:48.865Z | 2024-09-19T12:20:24.623Z |
5084252 | 5084252 | 20240912190328_N7bcP | RU000T | 2024-09-16T12:01:42.263Z | 2024-09-19T12:20:24.261Z |
5084231 | 5084231 | 20240912190133_dly1R | RU000T | 2024-09-16T12:01:37.211Z | 2024-09-19T12:20:23.955Z |
5084228 | 5084228 | 20240912190059_BERmh | RU000T | 2024-09-16T12:01:36.981Z | 2024-09-19T12:20:23.948Z |
5084079 | 5084079 | 20240912180249_9qvTO | RU000T | 2024-09-16T12:01:06.096Z | 2024-09-19T12:20:23.200Z |
5083935 | 5083935 | 20240912165909_64X1z | RU000T | 2024-09-16T12:00:41.538Z | 2024-09-19T12:20:22.777Z |
5083887 | 5083887 | 20240912163600_VpPhA | RU000T | 2024-09-16T12:00:36.058Z | 2024-09-19T12:20:21.654Z |
5083849 | 5083849 | 20240912161433_ST06r | RU000T | 2024-09-16T12:00:31.270Z | 2024-09-19T12:20:21.420Z |
5083626 | 5083626 | 20240911140023_VtJrX | RU000T | 2024-09-15T12:18:44.807Z | 2024-09-19T12:21:49.732Z |
5083610 | 5083610 | 20240911135656_leLwY | RU000T | 2024-09-15T12:18:44.571Z | 2024-09-19T12:21:49.720Z |
5083468 | 5083468 | 20240911132748_QmjxG | RU000T | 2024-09-15T12:18:42.408Z | 2024-09-19T12:21:49.594Z |
5072128 | 5072128 | 20240911193946_eGOpx | RU000T | 2024-09-15T12:04:43.569Z | 2024-09-19T12:21:03.558Z |
5071722 | 5071722 | 20240911180159_QJ2wB | RU000T | 2024-09-15T12:03:20.428Z | 2024-09-19T12:21:02.432Z |
5071591 | 5071591 | 20240911172309_NzvlP | RU000T | 2024-09-15T12:03:02.168Z | 2024-09-19T12:21:02.170Z |
5071436 | 5071436 | 20240911165400_VwKh5 | RU000T | 2024-09-15T12:02:32.499Z | 2024-09-19T12:21:01.934Z |
5071243 | 5071243 | 20240911162138_i2cyT | RU000T | 2024-09-15T12:02:00.521Z | 2024-09-19T12:21:01.307Z |
5071229 | 5071229 | 20240911161928_dwxMv | RU000T | 2024-09-15T12:01:58.445Z | 2024-09-19T12:21:01.264Z |
5071212 | 5071212 | 20240911161553_dVYRp | RU000T | 2024-09-15T12:01:54.940Z | 2024-09-19T12:21:01.221Z |
5070743 | 5070743 | 20240911150521_kCw3T | RU000T | 2024-09-15T12:00:44.727Z | 2024-09-19T12:21:00.186Z |
5069099 | 5069099 | 20240910134157_ft3DG | RU000T | 2024-09-14T12:19:25.569Z | 2024-09-18T12:15:27.126Z |
5068849 | 5068849 | 20240910124731_4c2gm | RU000T | 2024-09-14T12:19:22.090Z | 2024-09-18T12:15:26.749Z |
5068778 | 5068778 | 20240910122255_glXWD | RU000T | 2024-09-14T12:19:21.369Z | 2024-09-18T12:15:26.646Z |
5062917 | 5062917 | 20240909190259_qLw8Q | RU000T | 2024-09-14T12:13:02.963Z | 2024-09-18T12:15:12.494Z |
5062879 | 5062879 | 20240909185129_qrUx1 | RU000T | 2024-09-14T12:13:00.498Z | 2024-09-18T12:15:12.403Z |
5062868 | 5062868 | 20240909184829_rL4aJ | RU000T | 2024-09-14T12:12:59.686Z | 2024-09-18T12:15:12.379Z |
5062860 | 5062860 | 20240909184409_Lxsnd | RU000T | 2024-09-14T12:12:59.215Z | 2024-09-18T12:15:12.344Z |
5062849 | 5062849 | 20240909184118_nHpGr | RU000T | 2024-09-14T12:12:58.455Z | 2024-09-18T12:15:12.292Z |
5062725 | 5062725 | 20240909180616_tDg4z | RU000T | 2024-09-14T12:12:45.602Z | 2024-09-18T12:15:11.967Z |
5062627 | 5062627 | 20240909175100_2kyUj | RU000T | 2024-09-14T12:12:38.532Z | 2024-09-18T12:15:11.669Z |
5062610 | 5062610 | 20240909174636_6TkhU | RU000T | 2024-09-14T12:12:37.151Z | 2024-09-18T12:15:11.607Z |
5062602 | 5062602 | 20240909174623_Sj6nb | RU000T | 2024-09-14T12:12:36.241Z | 2024-09-18T12:15:11.571Z |
5062564 | 5062564 | 20240909174106_zz3k2 | RU000T | 2024-09-14T12:12:33.582Z | 2024-09-18T12:15:11.463Z |
5062537 | 5062537 | 20240909173818_d93Wi | RU000T | 2024-09-14T12:12:32.150Z | 2024-09-18T12:15:11.440Z |
5062535 | 5062535 | 20240909173813_QXedR | RU000T | 2024-09-14T12:12:31.758Z | 2024-09-18T12:15:11.439Z |
5061818 | 5061818 | 20240909160417_wwES1 | RU000T | 2024-09-14T12:11:29.571Z | 2024-09-18T12:15:10.010Z |
5061813 | 5061813 | 20240909160257_i8jcx | RU000T | 2024-09-14T12:11:28.735Z | 2024-09-18T12:15:10.005Z |
5061765 | 5061765 | 20240909155521_SemRS | RU000T | 2024-09-14T12:11:22.136Z | 2024-09-18T12:15:09.957Z |
5061637 | 5061637 | 20240909153244_QLx23 | RU000T | 2024-09-14T12:11:04.815Z | 2024-09-18T12:15:09.812Z |
5061575 | 5061575 | 20240909152443_HJoBB | RU000T | 2024-09-14T12:10:58.568Z | 2024-09-18T12:15:09.683Z |
5061246 | 5061246 | 20240909143735_XPjOw | RU000T | 2024-09-14T12:10:37.328Z | 2024-09-18T12:15:08.786Z |
5061126 | 5061126 | 20240909142029_Uormm | RU000T | 2024-09-14T12:10:19.203Z | 2024-09-18T12:15:08.234Z |
5061037 | 5061037 | 20240909135621_SIQ7Q | RU000T | 2024-09-14T12:10:07.820Z | 2024-09-18T12:15:07.892Z |
5059757 | 5059757 | 20240910184514_8P1we | RU000T | 2024-09-14T12:07:07.828Z | 2024-09-19T12:21:31.248Z |
5059680 | 5059680 | 20240910183058_2q7bM | RU000T | 2024-09-14T12:06:44.883Z | 2024-09-19T12:21:31.064Z |
5059670 | 5059670 | 20240910182805_ZRPga | RU000T | 2024-09-14T12:06:43.688Z | 2024-09-19T12:21:31.058Z |
5059588 | 5059588 | 20240910181432_O6NUc | RU000T | 2024-09-14T12:06:32.103Z | 2024-09-19T12:21:30.912Z |
5059491 | 5059491 | 20240910175132_BJ41Q | RU000T | 2024-09-14T12:06:13.495Z | 2024-09-19T12:21:30.827Z |
5059472 | 5059472 | 20240910174806_2Pm7A | RU000T | 2024-09-14T12:06:11.593Z | 2024-09-19T12:21:30.818Z |
5059391 | 5059391 | 20240910173631_b0KSm | RU000T | 2024-09-14T12:05:50.600Z | 2024-09-19T12:21:30.712Z |
5058153 | 5058153 | 20240910154840_6XZGJ | RU000T | 2024-09-14T12:03:03.600Z | 2024-09-19T12:21:29.243Z |
5058115 | 5058115 | 20240910154620_MNmsM | RU000T | 2024-09-14T12:02:59.249Z | 2024-09-19T12:21:29.154Z |
5057895 | 5057895 | 20240910152308_kM7GZ | RU000T | 2024-09-14T12:02:20.961Z | 2024-09-19T12:21:28.914Z |
5056990 | 5056990 | 20240908114929_8TQtt | RU000T | 2024-09-13T12:17:42.391Z | 2024-09-16T12:21:28.265Z |
5051871 | 5051871 | 20240907185853_6vqX1 | RU000T | 2024-09-13T12:14:40.276Z | 2024-09-16T12:21:02.336Z |
5045187 | 5045187 | 20240908163052_6O5Bx | RU000T | 2024-09-13T12:03:38.833Z | 2024-09-17T12:18:56.035Z |
5044605 | 5044605 | 20240908152124_VQIEK | RU000T | 2024-09-13T12:02:28.637Z | 2024-09-17T12:18:54.748Z |
5044574 | 5044574 | 20240908151830_VpfaD | RU000T | 2024-09-13T12:02:26.178Z | 2024-09-17T12:18:54.717Z |
5044032 | 5044032 | 20240908135918_GJlLW | RU000T | 2024-09-13T12:01:17.449Z | 2024-09-17T12:18:53.341Z |
5043759 | 5043759 | 20240908125945_eOwFN | RU000T | 2024-09-13T12:00:34.207Z | 2024-09-17T12:18:52.807Z |
5038245 | 5038245 | 20240905180240_dPcMR | RU000T | 2024-09-12T12:14:28.596Z | 2024-09-14T12:22:55.415Z |
5038142 | 5038142 | 20240905173010_RK2C0 | RU000T | 2024-09-12T12:14:24.144Z | 2024-09-14T12:22:55.220Z |
5037151 | 5037151 | 20240905151707_GwZli | RU000T | 2024-09-12T12:14:01.907Z | 2024-09-14T12:22:53.810Z |
5036541 | 5036541 | 20240905134712_1Sw5U | RU000T | 2024-09-12T12:13:47.500Z | 2024-09-14T12:22:52.562Z |
5035939 | 5035939 | 20240905121423_jLrR1 | RU000T | 2024-09-12T12:13:12.675Z | 2024-09-14T12:22:51.657Z |
5030834 | 5030834 | 20240906190032_6ZvGA | RU000T | 2024-09-12T12:03:12.079Z | 2024-09-15T12:21:19.990Z |
5030700 | 5030700 | 20240906174633_Oh23n | RU000T | 2024-09-12T12:02:41.840Z | 2024-09-15T12:21:19.479Z |
5030682 | 5030682 | 20240906173522_vRnP0 | RU000T | 2024-09-12T12:02:39.585Z | 2024-09-15T12:21:19.466Z |
5030649 | 5030649 | 20240906172716_VYpj3 | RU000T | 2024-09-12T12:02:33.704Z | 2024-09-15T12:21:19.400Z |
5030592 | 5030592 | 20240906170524_9i3XY | RU000T | 2024-09-12T12:02:25.912Z | 2024-09-15T12:21:19.192Z |
5030498 | 5030498 | 20240906161135_AalNu | RU000T | 2024-09-12T12:02:07.262Z | 2024-09-15T12:21:18.775Z |
5030455 | 5030455 | 20240906155356_EpslJ | RU000T | 2024-09-12T12:02:00.498Z | 2024-09-15T12:21:18.600Z |
5030381 | 5030381 | 20240906151526_DQNXs | RU000T | 2024-09-12T12:01:50.278Z | 2024-09-15T12:21:18.515Z |
5030259 | 5030259 | 20240906141133_25Tq7 | RU000T | 2024-09-12T12:01:35.210Z | 2024-09-15T12:21:18.372Z |
5030075 | 5030075 | 20240906123504_BjQMU | RU000T | 2024-09-12T12:01:05.767Z | 2024-09-15T12:21:18.018Z |
5029939 | 5029939 | 20240906115250_qeLjG | RU000T | 2024-09-12T12:00:51.340Z | 2024-09-15T12:21:17.668Z |
5024039 | 5024039 | 20240905180240_2QRy3 | RU000T | 2024-09-11T12:02:22.620Z | 2024-09-11T12:16:31.901Z |
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);