participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,507 rows where station_code = "RU0009" 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 |
---|---|---|---|---|---|
5128537 | 5128537 | 20240917020027_rS62s | RU0009 | 2024-09-19T12:10:42.516Z | 2024-09-19T12:10:42.516Z |
5114524 | 5114524 | 20240915014647_R2zQ6 | RU0009 | 2024-09-18T12:05:20.771Z | 2024-09-19T12:18:58.749Z |
5114522 | 5114522 | 20240915014641_CnF9G | RU0009 | 2024-09-18T12:05:20.533Z | 2024-09-19T12:18:58.699Z |
5113720 | 5113720 | 20240915010916_JK5VU | RU0009 | 2024-09-18T12:04:46.623Z | 2024-09-19T12:18:51.789Z |
5113527 | 5113527 | 20240915005610_eLuO8 | RU0009 | 2024-09-18T12:04:26.160Z | 2024-09-19T12:18:49.891Z |
5113397 | 5113397 | 20240915004653_rvnrZ | RU0009 | 2024-09-18T12:04:14.813Z | 2024-09-19T12:18:48.934Z |
5113166 | 5113166 | 20240915002921_JF28y | RU0009 | 2024-09-18T12:04:00.731Z | 2024-09-19T12:18:47.773Z |
5113076 | 5113076 | 20240915001800_Y4KXP | RU0009 | 2024-09-18T12:03:54.888Z | 2024-09-19T12:18:46.918Z |
5103918 | 5103918 | 20240913014404_781nW | RU0009 | 2024-09-17T12:11:17.144Z | 2024-09-19T12:20:40.668Z |
5102798 | 5102798 | 20240914014530_FjUGm | RU0009 | 2024-09-17T12:07:37.171Z | 2024-09-19T12:19:55.708Z |
5102518 | 5102518 | 20240914013032_4ypEQ | RU0009 | 2024-09-17T12:07:18.882Z | 2024-09-19T12:19:54.719Z |
5102166 | 5102166 | 20240914010910_TqlLb | RU0009 | 2024-09-17T12:06:52.473Z | 2024-09-19T12:19:52.682Z |
5102155 | 5102155 | 20240914010726_zsgHD | RU0009 | 2024-09-17T12:06:51.008Z | 2024-09-19T12:19:52.548Z |
5102136 | 5102136 | 20240914010642_xvnC3 | RU0009 | 2024-09-17T12:06:49.925Z | 2024-09-19T12:19:52.515Z |
5102069 | 5102069 | 20240914010428_U21pP | RU0009 | 2024-09-17T12:06:46.057Z | 2024-09-19T12:19:52.357Z |
5101905 | 5101905 | 20240914005527_CZOI1 | RU0009 | 2024-09-17T12:06:23.415Z | 2024-09-19T12:19:51.857Z |
5101878 | 5101878 | 20240914005400_ds8at | RU0009 | 2024-09-17T12:06:20.185Z | 2024-09-19T12:19:51.787Z |
5101874 | 5101874 | 20240914005339_Vno1S | RU0009 | 2024-09-17T12:06:19.588Z | 2024-09-19T12:19:51.773Z |
5101767 | 5101767 | 20240914004603_bnvGF | RU0009 | 2024-09-17T12:06:11.985Z | 2024-09-19T12:19:51.479Z |
5101594 | 5101594 | 20240914003811_Jlp0o | RU0009 | 2024-09-17T12:06:04.194Z | 2024-09-19T12:19:51.077Z |
5101565 | 5101565 | 20240914003542_UdF5A | RU0009 | 2024-09-17T12:06:02.330Z | 2024-09-19T12:19:50.931Z |
5101499 | 5101499 | 20240914003115_KJhPm | RU0009 | 2024-09-17T12:05:56.920Z | 2024-09-19T12:19:50.786Z |
5101332 | 5101332 | 20240914001942_1eUz5 | RU0009 | 2024-09-17T12:05:35.618Z | 2024-09-19T12:19:50.277Z |
5101301 | 5101301 | 20240914001836_cAFcT | RU0009 | 2024-09-17T12:05:32.882Z | 2024-09-19T12:19:50.216Z |
5101255 | 5101255 | 20240914001652_KKNcR | RU0009 | 2024-09-17T12:05:30.259Z | 2024-09-19T12:19:50.105Z |
5101202 | 5101202 | 20240914001248_7LDA4 | RU0009 | 2024-09-17T12:05:26.020Z | 2024-09-19T12:19:50.033Z |
5100896 | 5100896 | 20240913235219_SRzE2 | RU0009 | 2024-09-17T12:05:08.980Z | 2024-09-19T12:19:49.311Z |
5100858 | 5100858 | 20240913234807_sF2E0 | RU0009 | 2024-09-17T12:05:03.502Z | 2024-09-19T12:19:48.856Z |
5100723 | 5100723 | 20240913234400_guqtx | RU0009 | 2024-09-17T12:04:50.570Z | 2024-09-19T12:19:48.634Z |
5100596 | 5100596 | 20240913233327_a2R8i | RU0009 | 2024-09-17T12:04:40.888Z | 2024-09-19T12:19:48.170Z |
5100507 | 5100507 | 20240913232917_joftQ | RU0009 | 2024-09-17T12:04:37.228Z | 2024-09-19T12:19:48.082Z |
5097418 | 5097418 | 20240913004551_DhMOS | RU0009 | 2024-09-16T12:17:12.387Z | 2024-09-19T12:20:38.488Z |
5097331 | 5097331 | 20240913004126_pNz0Z | RU0009 | 2024-09-16T12:17:10.910Z | 2024-09-19T12:20:38.264Z |
5097164 | 5097164 | 20240913003428_ORWGH | RU0009 | 2024-09-16T12:17:06.585Z | 2024-09-19T12:20:37.748Z |
5088428 | 5088428 | 20240913001101_9uO42 | RU0009 | 2024-09-16T12:07:59.749Z | 2024-09-19T12:20:36.772Z |
5088263 | 5088263 | 20240913000329_k2Q2z | RU0009 | 2024-09-16T12:07:50.568Z | 2024-09-19T12:20:36.569Z |
5087338 | 5087338 | 20240912232355_m6vkU | RU0009 | 2024-09-16T12:06:52.537Z | 2024-09-19T12:20:34.678Z |
5087155 | 5087155 | 20240912231154_pfj3i | RU0009 | 2024-09-16T12:06:42.553Z | 2024-09-19T12:20:34.059Z |
5085597 | 5085597 | 20240912213243_4r53R | RU0009 | 2024-09-16T12:04:26.910Z | 2024-09-19T12:20:29.158Z |
5085502 | 5085502 | 20240912212419_fA293 | RU0009 | 2024-09-16T12:04:20.188Z | 2024-09-19T12:20:28.845Z |
5085362 | 5085362 | 20240912211414_Vgo3u | RU0009 | 2024-09-16T12:04:09.234Z | 2024-09-19T12:20:28.515Z |
5085005 | 5085005 | 20240912203956_Vzw92 | RU0009 | 2024-09-16T12:03:25.355Z | 2024-09-19T12:20:27.686Z |
5084932 | 5084932 | 20240912203312_MXbtv | RU0009 | 2024-09-16T12:03:15.041Z | 2024-09-19T12:20:27.514Z |
5084688 | 5084688 | 20240912200634_B2SEp | RU0009 | 2024-09-16T12:02:48.120Z | 2024-09-19T12:20:26.937Z |
5084410 | 5084410 | 20240912193558_qzNV1 | RU0009 | 2024-09-16T12:02:03.004Z | 2024-09-19T12:20:25.686Z |
5084280 | 5084280 | 20240912190602_5UwUk | RU0009 | 2024-09-16T12:01:46.388Z | 2024-09-19T12:20:24.458Z |
5077971 | 5077971 | 20240911013316_Ntnfm | RU0009 | 2024-09-15T12:15:13.298Z | 2024-09-19T12:21:39.844Z |
5077960 | 5077960 | 20240911013234_L4xrr | RU0009 | 2024-09-15T12:15:12.568Z | 2024-09-19T12:21:39.814Z |
5077750 | 5077750 | 20240911011522_tzThK | RU0009 | 2024-09-15T12:15:03.131Z | 2024-09-19T12:21:39.600Z |
5077673 | 5077673 | 20240911011000_Ag6Hl | RU0009 | 2024-09-15T12:14:57.974Z | 2024-09-19T12:21:39.496Z |
5077427 | 5077427 | 20240911005104_YGMgt | RU0009 | 2024-09-15T12:14:44.952Z | 2024-09-19T12:21:38.993Z |
5077425 | 5077425 | 20240911005101_Ksu2w | RU0009 | 2024-09-15T12:14:44.632Z | 2024-09-19T12:21:38.985Z |
5077396 | 5077396 | 20240911004855_iIQNS | RU0009 | 2024-09-15T12:14:41.246Z | 2024-09-19T12:21:38.857Z |
5077258 | 5077258 | 20240911003812_5xg79 | RU0009 | 2024-09-15T12:14:34.922Z | 2024-09-19T12:21:38.602Z |
5077222 | 5077222 | 20240911003515_i64uu | RU0009 | 2024-09-15T12:14:31.466Z | 2024-09-19T12:21:38.524Z |
5077185 | 5077185 | 20240911003117_4TU36 | RU0009 | 2024-09-15T12:14:28.348Z | 2024-09-19T12:21:38.326Z |
5077169 | 5077169 | 20240911002909_gRaCn | RU0009 | 2024-09-15T12:14:26.651Z | 2024-09-19T12:21:38.308Z |
5077122 | 5077122 | 20240911002547_djVOY | RU0009 | 2024-09-15T12:14:24.152Z | 2024-09-19T12:21:38.216Z |
5076992 | 5076992 | 20240911001957_OHk1g | RU0009 | 2024-09-15T12:14:16.954Z | 2024-09-19T12:21:37.939Z |
5076842 | 5076842 | 20240911001024_pVtXA | RU0009 | 2024-09-15T12:14:06.468Z | 2024-09-19T12:21:37.619Z |
5076781 | 5076781 | 20240911000908_sOgvw | RU0009 | 2024-09-15T12:14:03.394Z | 2024-09-19T12:21:37.597Z |
5076688 | 5076688 | 20240911000015_aMO9P | RU0009 | 2024-09-15T12:13:55.455Z | 2024-09-19T12:21:37.464Z |
5076650 | 5076650 | 20240910235549_xyeCh | RU0009 | 2024-09-15T12:13:50.573Z | 2024-09-19T12:21:37.426Z |
5076534 | 5076534 | 20240910234428_QUeB0 | RU0009 | 2024-09-15T12:13:42.136Z | 2024-09-19T12:21:37.330Z |
5076469 | 5076469 | 20240910233757_ym9Vu | RU0009 | 2024-09-15T12:13:35.841Z | 2024-09-19T12:21:37.281Z |
5076333 | 5076333 | 20240910232209_aqmft | RU0009 | 2024-09-15T12:13:28.211Z | 2024-09-19T12:21:36.716Z |
5076331 | 5076331 | 20240910232129_3rQNi | RU0009 | 2024-09-15T12:13:27.951Z | 2024-09-19T12:21:36.715Z |
5076017 | 5076017 | 20240910230538_dbleW | RU0009 | 2024-09-15T12:13:16.006Z | 2024-09-19T12:21:36.382Z |
5075993 | 5075993 | 20240910230527_eNZn6 | RU0009 | 2024-09-15T12:13:15.686Z | 2024-09-19T12:21:36.367Z |
5071892 | 5071892 | 20240911185046_AzmHN | RU0009 | 2024-09-15T12:03:57.398Z | 2024-09-19T12:21:02.975Z |
5071858 | 5071858 | 20240911183852_kPhPo | RU0009 | 2024-09-15T12:03:51.803Z | 2024-09-19T12:21:02.872Z |
5071852 | 5071852 | 20240911183601_fmlBj | RU0009 | 2024-09-15T12:03:50.558Z | 2024-09-19T12:21:02.851Z |
5070300 | 5070300 | 20240910225012_gorzp | RU0009 | 2024-09-14T12:20:18.634Z | 2024-09-19T12:21:35.989Z |
5070018 | 5070018 | 20240910222347_bDpHP | RU0009 | 2024-09-14T12:20:11.960Z | 2024-09-19T12:21:35.586Z |
5069569 | 5069569 | 20240910215152_Fkw35 | RU0009 | 2024-09-14T12:20:00.159Z | 2024-09-19T12:21:35.068Z |
5069565 | 5069565 | 20240910215137_VhVj2 | RU0009 | 2024-09-14T12:19:59.968Z | 2024-09-19T12:21:35.063Z |
5069466 | 5069466 | 20240910214434_eH3j3 | RU0009 | 2024-09-14T12:19:57.913Z | 2024-09-19T12:21:34.938Z |
5069171 | 5069171 | 20240910211513_D2ZNo | RU0009 | 2024-09-14T12:19:47.064Z | 2024-09-19T12:21:33.770Z |
5064267 | 5064267 | 20240910003226_9BBW1 | RU0009 | 2024-09-14T12:15:11.136Z | 2024-09-18T12:15:16.014Z |
5064224 | 5064224 | 20240910002620_b1KeV | RU0009 | 2024-09-14T12:15:06.179Z | 2024-09-18T12:15:15.909Z |
5063142 | 5063142 | 20240909200432_K0H4K | RU0009 | 2024-09-14T12:13:34.518Z | 2024-09-18T12:15:13.090Z |
5063082 | 5063082 | 20240909194829_g6rsx | RU0009 | 2024-09-14T12:13:25.293Z | 2024-09-18T12:15:12.970Z |
5063018 | 5063018 | 20240909193859_cBJKj | RU0009 | 2024-09-14T12:13:18.572Z | 2024-09-18T12:15:12.885Z |
5062978 | 5062978 | 20240909192602_tf28l | RU0009 | 2024-09-14T12:13:12.978Z | 2024-09-18T12:15:12.760Z |
5062961 | 5062961 | 20240909192208_j2VvO | RU0009 | 2024-09-14T12:13:09.519Z | 2024-09-18T12:15:12.696Z |
5060623 | 5060623 | 20240910204437_Rs4vD | RU0009 | 2024-09-14T12:09:14.115Z | 2024-09-19T12:21:33.142Z |
5059969 | 5059969 | 20240910192551_KPeo6 | RU0009 | 2024-09-14T12:07:51.587Z | 2024-09-19T12:21:31.543Z |
5059709 | 5059709 | 20240910183431_hcJoC | RU0009 | 2024-09-14T12:06:49.720Z | 2024-09-19T12:21:31.118Z |
5059572 | 5059572 | 20240910180912_EIpwT | RU0009 | 2024-09-14T12:06:29.436Z | 2024-09-19T12:21:30.900Z |
5058923 | 5058923 | 20240910170044_t0mY3 | RU0009 | 2024-09-14T12:04:51.356Z | 2024-09-19T12:21:30.246Z |
5053826 | 5053826 | 20240908013711_SUC8b | RU0009 | 2024-09-13T12:16:18.567Z | 2024-09-16T12:21:12.832Z |
5053582 | 5053582 | 20240908010113_gatml | RU0009 | 2024-09-13T12:16:09.086Z | 2024-09-16T12:21:12.005Z |
5052301 | 5052301 | 20240907201318_uxBNv | RU0009 | 2024-09-13T12:15:03.425Z | 2024-09-16T12:21:05.045Z |
5045625 | 5045625 | 20240908173239_w8Iua | RU0009 | 2024-09-13T12:04:28.920Z | 2024-09-17T12:18:56.879Z |
5038755 | 5038755 | 20240905213814_k3Lyz | RU0009 | 2024-09-12T12:14:59.376Z | 2024-09-14T12:22:57.693Z |
5038733 | 5038733 | 20240905213522_RYGBt | RU0009 | 2024-09-12T12:14:57.204Z | 2024-09-14T12:22:57.427Z |
5038587 | 5038587 | 20240905210344_1mSTy | RU0009 | 2024-09-12T12:14:49.497Z | 2024-09-14T12:22:56.548Z |
5032744 | 5032744 | 20240907014301_03fNH | RU0009 | 2024-09-12T12:07:56.407Z | 2024-09-15T12:21:27.642Z |
5032481 | 5032481 | 20240907010730_uUM6v | RU0009 | 2024-09-12T12:07:23.453Z | 2024-09-15T12:21:26.572Z |
5032435 | 5032435 | 20240907010201_lohc3 | RU0009 | 2024-09-12T12:07:17.905Z | 2024-09-15T12:21:26.450Z |
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);