participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
154 rows where station_code = "RU0017" 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 |
---|---|---|---|---|---|
5114573 | 5114573 | 20240915014840_JVtGM | RU0017 | 2024-09-18T12:05:22.204Z | 2024-09-20T12:16:17.450Z |
5114055 | 5114055 | 20240915012354_Mdilh | RU0017 | 2024-09-18T12:05:00.061Z | 2024-09-20T12:16:08.482Z |
5113876 | 5113876 | 20240915011654_BX6xd | RU0017 | 2024-09-18T12:04:54.182Z | 2024-09-20T12:16:06.032Z |
5113491 | 5113491 | 20240915005311_2MkoV | RU0017 | 2024-09-18T12:04:24.628Z | 2024-09-20T12:15:57.929Z |
5087359 | 5087359 | 20240912232518_2bA3I | RU0017 | 2024-09-16T12:06:53.434Z | 2024-09-20T12:20:15.857Z |
5087340 | 5087340 | 20240912232355_m6vkU | RU0017 | 2024-09-16T12:06:52.537Z | 2024-09-20T12:20:15.780Z |
5087086 | 5087086 | 20240912230755_69hGy | RU0017 | 2024-09-16T12:06:36.510Z | 2024-09-20T12:20:14.393Z |
5086968 | 5086968 | 20240912225946_XPxMR | RU0017 | 2024-09-16T12:06:18.944Z | 2024-09-20T12:20:13.607Z |
5084940 | 5084940 | 20240912203514_1RRfu | RU0017 | 2024-09-16T12:03:17.049Z | 2024-09-20T12:20:00.234Z |
5084545 | 5084545 | 20240912194907_uzKDk | RU0017 | 2024-09-16T12:02:20.435Z | 2024-09-20T12:19:56.042Z |
5084276 | 5084276 | 20240912190543_NxHWG | RU0017 | 2024-09-16T12:01:45.632Z | 2024-09-20T12:19:52.054Z |
5084234 | 5084234 | 20240912190137_WMSO5 | RU0017 | 2024-09-16T12:01:37.633Z | 2024-09-20T12:19:51.151Z |
5077759 | 5077759 | 20240911011609_A9hHF | RU0017 | 2024-09-15T12:15:03.505Z | 2024-09-19T12:21:39.610Z |
5077752 | 5077752 | 20240911011522_tzThK | RU0017 | 2024-09-15T12:15:03.131Z | 2024-09-19T12:21:39.600Z |
5076932 | 5076932 | 20240911001429_DxGAD | RU0017 | 2024-09-15T12:14:12.558Z | 2024-09-19T12:21:37.790Z |
5076661 | 5076661 | 20240910235752_6LkKy | RU0017 | 2024-09-15T12:13:52.579Z | 2024-09-19T12:21:37.432Z |
5076191 | 5076191 | 20240910231246_thxtg | RU0017 | 2024-09-15T12:13:21.959Z | 2024-09-19T12:21:36.579Z |
5070109 | 5070109 | 20240910223419_3OY21 | RU0017 | 2024-09-14T12:20:14.888Z | 2024-09-19T12:21:35.778Z |
5070061 | 5070061 | 20240910222901_Zpx9m | RU0017 | 2024-09-14T12:20:13.588Z | 2024-09-19T12:21:35.713Z |
5069273 | 5069273 | 20240910212506_uA3KW | RU0017 | 2024-09-14T12:19:51.960Z | 2024-09-19T12:21:34.399Z |
5069173 | 5069173 | 20240910211513_D2ZNo | RU0017 | 2024-09-14T12:19:47.064Z | 2024-09-19T12:21:33.770Z |
5064226 | 5064226 | 20240910002620_b1KeV | RU0017 | 2024-09-14T12:15:06.179Z | 2024-09-18T12:15:15.909Z |
5064219 | 5064219 | 20240910002510_mXFOv | RU0017 | 2024-09-14T12:15:05.297Z | 2024-09-18T12:15:15.867Z |
5063714 | 5063714 | 20240909221926_4N7e4 | RU0017 | 2024-09-14T12:14:14.689Z | 2024-09-18T12:15:14.407Z |
5063553 | 5063553 | 20240909214315_b22wK | RU0017 | 2024-09-14T12:14:06.102Z | 2024-09-18T12:15:14.166Z |
5063508 | 5063508 | 20240909213038_Ei1m1 | RU0017 | 2024-09-14T12:14:04.046Z | 2024-09-18T12:15:14.094Z |
5063106 | 5063106 | 20240909195344_mCyB8 | RU0017 | 2024-09-14T12:13:29.338Z | 2024-09-18T12:15:13.020Z |
5062963 | 5062963 | 20240909192208_j2VvO | RU0017 | 2024-09-14T12:13:09.519Z | 2024-09-18T12:15:12.696Z |
5060710 | 5060710 | 20240910205506_u9JUq | RU0017 | 2024-09-14T12:09:24.690Z | 2024-09-19T12:21:33.495Z |
5060041 | 5060041 | 20240910194007_wRid6 | RU0017 | 2024-09-14T12:08:02.729Z | 2024-09-19T12:21:31.673Z |
5059574 | 5059574 | 20240910180912_EIpwT | RU0017 | 2024-09-14T12:06:29.436Z | 2024-09-19T12:21:30.900Z |
5059464 | 5059464 | 20240910174737_wl4h3 | RU0017 | 2024-09-14T12:06:09.719Z | 2024-09-19T12:21:30.809Z |
5053583 | 5053583 | 20240908010113_gatml | RU0017 | 2024-09-13T12:16:09.086Z | 2024-09-16T12:21:12.005Z |
5052395 | 5052395 | 20240907203219_UDT2G | RU0017 | 2024-09-13T12:15:07.447Z | 2024-09-16T12:21:05.374Z |
5045724 | 5045724 | 20240908182803_ddhSw | RU0017 | 2024-09-13T12:04:48.052Z | 2024-09-17T12:18:57.119Z |
5038743 | 5038743 | 20240905213639_M4kLk | RU0017 | 2024-09-12T12:14:57.418Z | 2024-09-14T12:22:57.464Z |
5038698 | 5038698 | 20240905212519_Xyemd | RU0017 | 2024-09-12T12:14:55.154Z | 2024-09-14T12:22:57.277Z |
5038635 | 5038635 | 20240905211359_gi8sF | RU0017 | 2024-09-12T12:14:52.144Z | 2024-09-14T12:22:56.719Z |
5038589 | 5038589 | 20240905210344_1mSTy | RU0017 | 2024-09-12T12:14:49.497Z | 2024-09-14T12:22:56.548Z |
5032745 | 5032745 | 20240907014301_03fNH | RU0017 | 2024-09-12T12:07:56.407Z | 2024-09-15T12:21:27.642Z |
5032583 | 5032583 | 20240907011808_hGhLX | RU0017 | 2024-09-12T12:07:42.249Z | 2024-09-15T12:21:26.840Z |
5032569 | 5032569 | 20240907011647_3MokJ | RU0017 | 2024-09-12T12:07:40.837Z | 2024-09-15T12:21:26.799Z |
5024318 | 5024318 | 20240905213639_H4ci8 | RU0017 | 2024-09-11T12:03:19.331Z | 2024-09-11T12:16:32.064Z |
5024268 | 5024268 | 20240905212519_OB1Xm | RU0017 | 2024-09-11T12:03:10.518Z | 2024-09-11T12:16:32.040Z |
5024205 | 5024205 | 20240905211359_N2CFM | RU0017 | 2024-09-11T12:02:55.307Z | 2024-09-11T12:16:32.005Z |
5024159 | 5024159 | 20240905210344_MKezx | RU0017 | 2024-09-11T12:02:47.491Z | 2024-09-11T12:16:31.974Z |
5009486 | 5009486 | 20240904012831_sXRWE | RU0017 | 2024-09-09T12:07:46.490Z | 2024-09-12T12:19:23.095Z |
5008771 | 5008771 | 20240904001840_hWjqI | RU0017 | 2024-09-09T12:07:03.197Z | 2024-09-12T12:19:19.193Z |
5008157 | 5008157 | 20240903230756_hyfIM | RU0017 | 2024-09-09T12:06:29.012Z | 2024-09-12T12:19:16.324Z |
5008001 | 5008001 | 20240903225402_tSyw4 | RU0017 | 2024-09-09T12:06:19.082Z | 2024-09-12T12:19:15.821Z |
4999917 | 4999917 | 20240902011127_1WRmq | RU0017 | 2024-09-08T12:14:50.306Z | 2024-09-10T12:19:23.965Z |
4999869 | 4999869 | 20240902010437_oT0b3 | RU0017 | 2024-09-08T12:14:48.283Z | 2024-09-10T12:19:23.712Z |
4999739 | 4999739 | 20240902005427_4RhVG | RU0017 | 2024-09-08T12:14:43.572Z | 2024-09-10T12:19:22.186Z |
4999528 | 4999528 | 20240902003132_OOpXL | RU0017 | 2024-09-08T12:14:25.493Z | 2024-09-10T12:19:20.208Z |
4999519 | 4999519 | 20240902003005_8gKah | RU0017 | 2024-09-08T12:14:24.022Z | 2024-09-10T12:19:20.170Z |
4988879 | 4988879 | 20240901215126_ZRvOZ | RU0017 | 2024-09-07T12:08:06.121Z | 2024-09-10T12:19:15.736Z |
4988729 | 4988729 | 20240901212519_v3IqC | RU0017 | 2024-09-07T12:07:52.553Z | 2024-09-10T12:19:15.240Z |
4988669 | 4988669 | 20240901211857_H3PUw | RU0017 | 2024-09-07T12:07:48.600Z | 2024-09-10T12:19:14.959Z |
4988543 | 4988543 | 20240901210143_cFMLK | RU0017 | 2024-09-07T12:07:38.979Z | 2024-09-10T12:19:14.627Z |
4988470 | 4988470 | 20240901205422_IVpPK | RU0017 | 2024-09-07T12:07:31.004Z | 2024-09-10T12:19:14.328Z |
4988264 | 4988264 | 20240901202027_vHzPT | RU0017 | 2024-09-07T12:07:09.894Z | 2024-09-10T12:19:13.319Z |
4988181 | 4988181 | 20240901200946_s0yBA | RU0017 | 2024-09-07T12:07:01.245Z | 2024-09-10T12:19:12.989Z |
4988129 | 4988129 | 20240901195936_xAmmT | RU0017 | 2024-09-07T12:06:54.335Z | 2024-09-10T12:19:12.788Z |
4987983 | 4987983 | 20240901193448_XkY3E | RU0017 | 2024-09-07T12:06:38.394Z | 2024-09-10T12:19:12.153Z |
4987915 | 4987915 | 20240901191608_wbUvi | RU0017 | 2024-09-07T12:06:28.206Z | 2024-09-10T12:19:11.810Z |
4987865 | 4987865 | 20240901190815_6r8fZ | RU0017 | 2024-09-07T12:06:25.322Z | 2024-09-10T12:19:11.663Z |
4987834 | 4987834 | 20240901190422_0aLOb | RU0017 | 2024-09-07T12:06:22.908Z | 2024-09-10T12:19:11.504Z |
4987789 | 4987789 | 20240901185551_IGnlA | RU0017 | 2024-09-07T12:06:17.475Z | 2024-09-10T12:19:11.359Z |
4987402 | 4987402 | 20240901172508_P2MBP | RU0017 | 2024-09-07T12:05:43.538Z | 2024-09-10T12:19:10.711Z |
4983369 | 4983369 | 20240812004348_FSSL2 | RU0017 | 2024-09-06T12:15:29.891Z | 2024-09-06T12:15:29.891Z |
4982826 | 4982826 | 20240812003808_AUP0V | RU0017 | 2024-09-06T12:15:03.713Z | 2024-09-06T12:15:03.713Z |
4972606 | 4972606 | 20240811224825_bfPNh | RU0017 | 2024-09-05T12:10:29.121Z | 2024-09-06T12:09:19.998Z |
4921205 | 4921205 | 20240810004936_UgCCi | RU0017 | 2024-08-30T12:13:59.023Z | 2024-09-02T12:26:53.715Z |
4921082 | 4921082 | 20240810004531_PTsQ9 | RU0017 | 2024-08-30T12:13:51.522Z | 2024-09-02T12:26:49.531Z |
4920892 | 4920892 | 20240810004120_0MxZk | RU0017 | 2024-08-30T12:13:44.432Z | 2024-09-02T12:26:42.999Z |
4920678 | 4920678 | 20240810003654_cqD2j | RU0017 | 2024-08-30T12:13:36.236Z | 2024-09-02T12:26:34.446Z |
4919924 | 4919924 | 20240810002134_x8qp5 | RU0017 | 2024-08-30T12:13:03.227Z | 2024-09-02T12:26:06.859Z |
4918637 | 4918637 | 20240809235512_e6y5J | RU0017 | 2024-08-30T12:12:07.780Z | 2024-09-02T12:25:34.214Z |
4918306 | 4918306 | 20240809234934_1v7Cx | RU0017 | 2024-08-30T12:11:58.682Z | 2024-09-02T12:25:29.604Z |
4917191 | 4917191 | 20240809233018_ADZnx | RU0017 | 2024-08-30T12:11:19.408Z | 2024-09-02T12:24:55.635Z |
4917102 | 4917102 | 20240809232918_2nMT9 | RU0017 | 2024-08-30T12:11:16.302Z | 2024-09-02T12:24:52.122Z |
4916702 | 4916702 | 20240809232134_26mzB | RU0017 | 2024-08-30T12:10:56.331Z | 2024-09-02T12:24:37.626Z |
4915056 | 4915056 | 20240809223723_3g33d | RU0017 | 2024-08-30T12:09:40.233Z | 2024-09-02T12:23:49.548Z |
4913758 | 4913758 | 20240809215625_B3hTb | RU0017 | 2024-08-29T12:09:24.221Z | 2024-09-02T12:23:03.696Z |
4900796 | 4900796 | 20240808004613_TRzXZ | RU0017 | 2024-08-28T12:18:15.532Z | 2024-08-28T12:18:15.532Z |
4900708 | 4900708 | 20240808004003_SJ5d7 | RU0017 | 2024-08-28T12:18:10.432Z | 2024-08-28T12:18:10.432Z |
4900525 | 4900525 | 20240808002744_tjgWH | RU0017 | 2024-08-28T12:18:05.817Z | 2024-08-28T12:18:05.817Z |
4900263 | 4900263 | 20240808001000_CMYFs | RU0017 | 2024-08-28T12:17:58.606Z | 2024-08-28T12:17:58.606Z |
4899959 | 4899959 | 20240807233936_XtTRE | RU0017 | 2024-08-28T12:17:37.536Z | 2024-08-28T12:17:37.536Z |
4899921 | 4899921 | 20240807233525_eIIHF | RU0017 | 2024-08-28T12:17:36.153Z | 2024-08-28T12:17:36.153Z |
4899839 | 4899839 | 20240807232537_cUsDJ | RU0017 | 2024-08-28T12:17:30.584Z | 2024-08-28T12:17:30.584Z |
4899737 | 4899737 | 20240807231812_baGL5 | RU0017 | 2024-08-28T12:17:27.373Z | 2024-08-28T12:17:27.373Z |
4899710 | 4899710 | 20240807231616_95wuP | RU0017 | 2024-08-28T12:17:26.574Z | 2024-08-28T12:17:26.574Z |
4898068 | 4898068 | 20240807204413_o3cWY | RU0017 | 2024-08-28T12:16:12.177Z | 2024-08-28T12:16:12.177Z |
4891412 | 4891412 | 20240809005537_XPZeO | RU0017 | 2024-08-28T12:09:01.330Z | 2024-08-30T12:21:12.584Z |
4891380 | 4891380 | 20240809005257_bOpgy | RU0017 | 2024-08-28T12:08:55.844Z | 2024-08-30T12:21:11.430Z |
4891368 | 4891368 | 20240809005232_2881g | RU0017 | 2024-08-28T12:08:55.466Z | 2024-08-30T12:21:11.143Z |
4891350 | 4891350 | 20240809005111_hecCM | RU0017 | 2024-08-28T12:08:54.443Z | 2024-08-30T12:21:10.443Z |
4891009 | 4891009 | 20240809001555_GYgNT | RU0017 | 2024-08-28T12:08:29.030Z | 2024-08-30T12:20:47.931Z |
4890863 | 4890863 | 20240808235830_sC9ZT | RU0017 | 2024-08-28T12:08:15.011Z | 2024-08-30T12:20:36.898Z |
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);