participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,749 rows where station_code = "RU000E" 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 |
---|---|---|---|---|---|
5128535 | 5128535 | 20240917015856_u28fT | RU000E | 2024-09-19T12:10:41.862Z | 2024-09-20T12:10:55.046Z |
5113867 | 5113867 | 20240915011605_4bEZF | RU000E | 2024-09-18T12:04:53.697Z | 2024-09-20T12:16:04.693Z |
5113698 | 5113698 | 20240915010707_kspo9 | RU000E | 2024-09-18T12:04:44.210Z | 2024-09-20T12:16:02.132Z |
5113153 | 5113153 | 20240915002700_bshmF | RU000E | 2024-09-18T12:03:59.304Z | 2024-09-20T12:15:48.513Z |
5103414 | 5103414 | 20240913013003_TFZL7 | RU000E | 2024-09-17T12:10:56.627Z | 2024-09-20T12:20:31.065Z |
5102459 | 5102459 | 20240914012717_eTfm0 | RU000E | 2024-09-17T12:07:14.243Z | 2024-09-20T12:18:53.562Z |
5102162 | 5102162 | 20240914010834_J3j0M | RU000E | 2024-09-17T12:06:51.841Z | 2024-09-20T12:18:52.162Z |
5101505 | 5101505 | 20240914003119_67R22 | RU000E | 2024-09-17T12:05:57.693Z | 2024-09-20T12:18:47.535Z |
5101497 | 5101497 | 20240914003035_wmzLs | RU000E | 2024-09-17T12:05:56.587Z | 2024-09-20T12:18:47.354Z |
5101267 | 5101267 | 20240914001723_meblk | RU000E | 2024-09-17T12:05:30.790Z | 2024-09-20T12:18:43.233Z |
5100367 | 5100367 | 20240913232354_mFN9F | RU000E | 2024-09-17T12:04:31.088Z | 2024-09-20T12:18:32.261Z |
5100333 | 5100333 | 20240913232040_ZTxdt | RU000E | 2024-09-17T12:04:28.692Z | 2024-09-20T12:18:31.848Z |
5097304 | 5097304 | 20240913003909_UNB0a | RU000E | 2024-09-16T12:17:09.562Z | 2024-09-20T12:20:25.163Z |
5097211 | 5097211 | 20240913003644_QF2Tg | RU000E | 2024-09-16T12:17:08.105Z | 2024-09-20T12:20:24.641Z |
5088908 | 5088908 | 20240913003317_uDPyo | RU000E | 2024-09-16T12:08:36.181Z | 2024-09-20T12:20:23.739Z |
5088804 | 5088804 | 20240913002755_GOwEM | RU000E | 2024-09-16T12:08:31.391Z | 2024-09-20T12:20:23.285Z |
5087358 | 5087358 | 20240912232518_2bA3I | RU000E | 2024-09-16T12:06:53.434Z | 2024-09-20T12:20:15.857Z |
5084938 | 5084938 | 20240912203514_1RRfu | RU000E | 2024-09-16T12:03:17.049Z | 2024-09-20T12:20:00.234Z |
5084543 | 5084543 | 20240912194907_uzKDk | RU000E | 2024-09-16T12:02:20.435Z | 2024-09-20T12:19:56.042Z |
5077758 | 5077758 | 20240911011609_A9hHF | RU000E | 2024-09-15T12:15:03.505Z | 2024-09-19T12:21:39.610Z |
5077698 | 5077698 | 20240911011210_ud7B0 | RU000E | 2024-09-15T12:15:00.837Z | 2024-09-19T12:21:39.534Z |
5076659 | 5076659 | 20240910235752_6LkKy | RU000E | 2024-09-15T12:13:52.579Z | 2024-09-19T12:21:37.432Z |
5071898 | 5071898 | 20240911185410_scjQ3 | RU000E | 2024-09-15T12:03:58.648Z | 2024-09-20T12:21:24.021Z |
5063174 | 5063174 | 20240909201113_MyF0t | RU000E | 2024-09-14T12:13:37.437Z | 2024-09-18T12:15:13.216Z |
5063104 | 5063104 | 20240909195344_mCyB8 | RU000E | 2024-09-14T12:13:29.338Z | 2024-09-18T12:15:13.020Z |
5062277 | 5062277 | 20240909170611_0YTxm | RU000E | 2024-09-14T12:12:05.023Z | 2024-09-18T12:15:10.830Z |
5062022 | 5062022 | 20240909163401_MO9cY | RU000E | 2024-09-14T12:11:45.314Z | 2024-09-18T12:15:10.324Z |
5060562 | 5060562 | 20240910203818_Q3wcu | RU000E | 2024-09-14T12:09:09.097Z | 2024-09-19T12:21:32.834Z |
5060350 | 5060350 | 20240910202048_C68eP | RU000E | 2024-09-14T12:08:40.295Z | 2024-09-19T12:21:32.191Z |
5052419 | 5052419 | 20240907203730_vAwXN | RU000E | 2024-09-13T12:15:08.383Z | 2024-09-16T12:21:05.484Z |
5052394 | 5052394 | 20240907203219_UDT2G | RU000E | 2024-09-13T12:15:07.447Z | 2024-09-16T12:21:05.374Z |
5052297 | 5052297 | 20240907201204_0zH93 | RU000E | 2024-09-13T12:15:03.244Z | 2024-09-16T12:21:05.027Z |
5045676 | 5045676 | 20240908175525_pSceC | RU000E | 2024-09-13T12:04:41.043Z | 2024-09-17T12:18:57.010Z |
5038633 | 5038633 | 20240905211359_gi8sF | RU000E | 2024-09-12T12:14:52.144Z | 2024-09-14T12:22:56.719Z |
5038574 | 5038574 | 20240905210149_ZpXCZ | RU000E | 2024-09-12T12:14:48.531Z | 2024-09-14T12:22:56.489Z |
5038552 | 5038552 | 20240905205020_3wQpm | RU000E | 2024-09-12T12:14:47.655Z | 2024-09-14T12:22:56.389Z |
5025898 | 5025898 | 20240905013714_oX5gH | RU000E | 2024-09-11T12:11:26.523Z | 2024-09-13T12:19:56.117Z |
5024203 | 5024203 | 20240905211359_N2CFM | RU000E | 2024-09-11T12:02:55.307Z | 2024-09-11T12:16:32.005Z |
5024144 | 5024144 | 20240905210149_iLSkO | RU000E | 2024-09-11T12:02:45.381Z | 2024-09-11T12:16:31.967Z |
5020340 | 5020340 | 20240905013714_YJ56J | RU000E | 2024-09-10T12:14:20.347Z | 2024-09-10T12:16:55.129Z |
5019864 | 5019864 | 20240905000906_0c33j | RU000E | 2024-09-10T12:13:38.533Z | 2024-09-13T12:19:54.089Z |
5019798 | 5019798 | 20240904235153_guPbT | RU000E | 2024-09-10T12:13:32.967Z | 2024-09-13T12:19:53.819Z |
5019702 | 5019702 | 20240904233745_f6F8g | RU000E | 2024-09-10T12:13:14.085Z | 2024-09-13T12:19:53.556Z |
5019664 | 5019664 | 20240904232821_L0QrQ | RU000E | 2024-09-10T12:13:07.543Z | 2024-09-13T12:19:53.292Z |
5019554 | 5019554 | 20240904230937_nN3Ns | RU000E | 2024-09-10T12:12:54.970Z | 2024-09-13T12:19:52.409Z |
5019544 | 5019544 | 20240904230721_eATpm | RU000E | 2024-09-10T12:12:54.188Z | 2024-09-13T12:19:52.372Z |
5019528 | 5019528 | 20240904230411_SbH5J | RU000E | 2024-09-10T12:12:51.752Z | 2024-09-13T12:19:52.321Z |
5018861 | 5018861 | 20240904205445_w10yv | RU000E | 2024-09-10T12:11:40.805Z | 2024-09-13T12:19:49.535Z |
5007999 | 5007999 | 20240903225402_tSyw4 | RU000E | 2024-09-09T12:06:19.075Z | 2024-09-12T12:19:15.821Z |
4999895 | 4999895 | 20240902010931_Uxyqq | RU000E | 2024-09-08T12:14:49.564Z | 2024-09-10T12:19:23.933Z |
4999764 | 4999764 | 20240902005748_6RTHf | RU000E | 2024-09-08T12:14:44.557Z | 2024-09-10T12:19:22.243Z |
4999737 | 4999737 | 20240902005427_4RhVG | RU000E | 2024-09-08T12:14:43.572Z | 2024-09-10T12:19:22.186Z |
4988344 | 4988344 | 20240901203541_26Ut6 | RU000E | 2024-09-07T12:07:16.367Z | 2024-09-10T12:19:13.588Z |
4987913 | 4987913 | 20240901191608_wbUvi | RU000E | 2024-09-07T12:06:28.206Z | 2024-09-10T12:19:11.810Z |
4987833 | 4987833 | 20240901190422_0aLOb | RU000E | 2024-09-07T12:06:22.908Z | 2024-09-10T12:19:11.504Z |
4987732 | 4987732 | 20240901184210_2Y63L | RU000E | 2024-09-07T12:06:11.252Z | 2024-09-10T12:19:11.233Z |
4987292 | 4987292 | 20240901170951_nYOXf | RU000E | 2024-09-07T12:05:34.183Z | 2024-09-10T12:19:10.400Z |
4982824 | 4982824 | 20240812003808_AUP0V | RU000E | 2024-09-06T12:15:03.709Z | 2024-09-06T12:15:03.709Z |
4921080 | 4921080 | 20240810004531_PTsQ9 | RU000E | 2024-08-30T12:13:51.522Z | 2024-09-02T12:26:49.531Z |
4920677 | 4920677 | 20240810003654_cqD2j | RU000E | 2024-08-30T12:13:36.236Z | 2024-09-02T12:26:34.446Z |
4920473 | 4920473 | 20240810003356_voyKd | RU000E | 2024-08-30T12:13:29.228Z | 2024-09-02T12:26:26.267Z |
4920385 | 4920385 | 20240810003214_P2oLw | RU000E | 2024-08-30T12:13:20.131Z | 2024-09-02T12:26:23.018Z |
4917186 | 4917186 | 20240809233014_8S3Cq | RU000E | 2024-08-30T12:11:19.073Z | 2024-09-02T12:24:54.889Z |
4917101 | 4917101 | 20240809232918_2nMT9 | RU000E | 2024-08-30T12:11:16.297Z | 2024-09-02T12:24:52.122Z |
4900939 | 4900939 | 20240808005416_2P8Wx | RU000E | 2024-08-28T12:18:20.032Z | 2024-08-28T12:18:20.032Z |
4900524 | 4900524 | 20240808002744_tjgWH | RU000E | 2024-08-28T12:18:05.817Z | 2024-08-28T12:18:05.817Z |
4900325 | 4900325 | 20240808001726_12xoV | RU000E | 2024-08-28T12:18:00.955Z | 2024-08-28T12:18:00.955Z |
4899920 | 4899920 | 20240807233525_eIIHF | RU000E | 2024-08-28T12:17:36.153Z | 2024-08-28T12:17:36.153Z |
4899838 | 4899838 | 20240807232537_cUsDJ | RU000E | 2024-08-28T12:17:30.583Z | 2024-08-28T12:17:30.583Z |
4899709 | 4899709 | 20240807231616_95wuP | RU000E | 2024-08-28T12:17:26.574Z | 2024-08-28T12:17:26.574Z |
4891349 | 4891349 | 20240809005111_hecCM | RU000E | 2024-08-28T12:08:54.443Z | 2024-08-30T12:21:10.443Z |
4891241 | 4891241 | 20240809003919_epjiH | RU000E | 2024-08-28T12:08:45.537Z | 2024-08-30T12:21:04.886Z |
4890862 | 4890862 | 20240808235830_sC9ZT | RU000E | 2024-08-28T12:08:15.011Z | 2024-08-30T12:20:36.897Z |
4890800 | 4890800 | 20240808235157_YprsZ | RU000E | 2024-08-28T12:08:10.683Z | 2024-08-30T12:20:30.729Z |
4872554 | 4872554 | 20240806214928_zVku5 | RU000E | 2024-08-19T12:10:05.462Z | 2024-08-27T12:10:36.372Z |
4871352 | 4871352 | 20240806201126_phpN3 | RU000E | 2024-08-19T12:08:51.433Z | 2024-08-27T12:09:34.968Z |
4853815 | 4853815 | 20240805231506_Z72Lg | RU000E | 2024-08-17T12:17:53.642Z | 2024-08-19T12:25:20.643Z |
4851743 | 4851743 | 20240805212311_zJ2fN | RU000E | 2024-08-17T12:15:15.465Z | 2024-08-19T12:24:09.794Z |
4832649 | 4832649 | 20240804234519_0ROJ3 | RU000E | 2024-08-15T12:13:07.772Z | 2024-08-17T12:31:11.765Z |
4830831 | 4830831 | 20240804220125_I5QY4 | RU000E | 2024-08-15T12:11:00.843Z | 2024-08-17T12:30:04.500Z |
4830142 | 4830142 | 20240804211628_FTHe0 | RU000E | 2024-08-15T12:10:01.845Z | 2024-08-17T12:29:37.613Z |
4829448 | 4829448 | 20240804195558_24UOj | RU000E | 2024-08-15T12:08:50.765Z | 2024-08-17T12:29:07.449Z |
4825036 | 4825036 | 20240804003830_75gEe | RU000E | 2024-08-14T12:19:52.500Z | 2024-08-15T12:25:42.699Z |
4823931 | 4823931 | 20240803232213_2Jfqb | RU000E | 2024-08-14T12:18:41.179Z | 2024-08-15T12:25:14.950Z |
4822354 | 4822354 | 20240803212405_2Epy3 | RU000E | 2024-08-14T12:17:08.251Z | 2024-08-15T12:24:21.716Z |
4821448 | 4821448 | 20240803195633_wYH8T | RU000E | 2024-08-14T12:15:28.478Z | 2024-08-15T12:23:41.088Z |
4821394 | 4821394 | 20240803195145_Fdb0B | RU000E | 2024-08-14T12:15:25.875Z | 2024-08-15T12:23:39.531Z |
4803659 | 4803659 | 20240802212435_Hbkke | RU000E | 2024-08-12T12:15:30.804Z | 2024-08-13T12:16:44.688Z |
4803200 | 4803200 | 20240802203715_2y2zA | RU000E | 2024-08-12T12:15:01.148Z | 2024-08-13T12:16:37.274Z |
4785445 | 4785445 | 20240802001720_2cnX2 | RU000E | 2024-08-10T12:16:04.238Z | 2024-08-11T12:14:47.424Z |
4785225 | 4785225 | 20240802000805_r2tg2 | RU000E | 2024-08-10T12:15:54.080Z | 2024-08-11T12:14:43.889Z |
4785223 | 4785223 | 20240802000741_PAYCc | RU000E | 2024-08-10T12:15:53.827Z | 2024-08-11T12:14:43.822Z |
4750410 | 4750410 | 20240729232353_XgMEA | RU000E | 2024-08-04T12:16:11.029Z | 2024-08-06T12:15:30.969Z |
4749618 | 4749618 | 20240729225948_UeQuT | RU000E | 2024-08-04T12:15:49.873Z | 2024-08-06T12:15:28.445Z |
4748350 | 4748350 | 20240729221424_WWDUp | RU000E | 2024-08-04T12:15:13.899Z | 2024-08-06T12:15:24.661Z |
4748324 | 4748324 | 20240729221238_cWABz | RU000E | 2024-08-04T12:15:12.787Z | 2024-08-06T12:15:24.480Z |
4747981 | 4747981 | 20240729215659_363aJ | RU000E | 2024-08-04T12:14:58.683Z | 2024-08-06T12:15:23.600Z |
4747871 | 4747871 | 20240729215227_42Z7N | RU000E | 2024-08-04T12:14:56.558Z | 2024-08-06T12:15:23.301Z |
4747845 | 4747845 | 20240729215014_Dwuaz | RU000E | 2024-08-04T12:14:55.908Z | 2024-08-06T12:15:23.247Z |
4747454 | 4747454 | 20240729212427_uq6dR | RU000E | 2024-08-04T12:14:43.428Z | 2024-08-06T12:15:21.376Z |
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);