participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,514 rows where station_code = "CA000R" 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 |
---|---|---|---|---|---|
5504055 | 5504055 | 20241108004559_Y4XmF | CA000R | 2024-11-09T14:14:01.061Z | 2024-11-09T14:16:28.438Z |
5503676 | 5503676 | 20241107232532_tLydi | CA000R | 2024-11-09T14:13:33.208Z | 2024-11-09T14:16:28.318Z |
5503674 | 5503674 | 20241107232450_z82QU | CA000R | 2024-11-09T14:13:32.072Z | 2024-11-09T14:16:28.318Z |
5496675 | 5496675 | 20241107011333_PMQf5 | CA000R | 2024-11-08T14:12:40.081Z | 2024-11-09T14:18:27.434Z |
5477232 | 5477232 | 20241104012253_pFPHR | CA000R | 2024-11-05T14:16:33.919Z | 2024-11-09T14:22:16.020Z |
5476345 | 5476345 | 20241103231045_NcrUf | CA000R | 2024-11-05T14:15:07.831Z | 2024-11-09T14:22:08.539Z |
5470227 | 5470227 | 20241103064302_jScds | CA000R | 2024-11-04T14:17:55.004Z | 2024-11-09T14:23:05.971Z |
5470209 | 5470209 | 20241103063816_hdEl6 | CA000R | 2024-11-04T14:17:54.078Z | 2024-11-09T14:23:05.928Z |
5470179 | 5470179 | 20241103062209_9uyVo | CA000R | 2024-11-04T14:17:52.931Z | 2024-11-09T14:23:05.851Z |
5464554 | 5464554 | 20241103081504_GrnQf | CA000R | 2024-11-04T14:00:56.563Z | 2024-11-09T14:21:26.593Z |
5464546 | 5464546 | 20241103081043_NEye3 | CA000R | 2024-11-04T14:00:55.304Z | 2024-11-09T14:21:26.519Z |
5464473 | 5464473 | 20241103073317_u1f1N | CA000R | 2024-11-04T14:00:36.472Z | 2024-11-09T14:21:25.872Z |
5464445 | 5464445 | 20241103072418_em8fY | CA000R | 2024-11-04T14:00:30.503Z | 2024-11-09T14:21:25.577Z |
5464392 | 5464392 | 20241103070140_3qDRv | CA000R | 2024-11-04T14:00:18.906Z | 2024-11-09T14:21:25.149Z |
5463694 | 5463694 | 20241102043805_XEhHs | CA000R | 2024-11-03T14:19:10.470Z | 2024-11-09T14:23:43.511Z |
5463593 | 5463593 | 20241102041554_0XD5S | CA000R | 2024-11-03T14:19:00.499Z | 2024-11-09T14:23:42.500Z |
5433045 | 5433045 | 20241029055630_vPd3C | CA000R | 2024-10-31T12:21:44.141Z | 2024-11-06T14:27:29.751Z |
5431961 | 5431961 | 20241029022303_yEuA2 | CA000R | 2024-10-31T12:20:53.808Z | 2024-11-06T14:27:25.615Z |
5431742 | 5431742 | 20241029015333_2OL16 | CA000R | 2024-10-31T12:20:35.783Z | 2024-11-06T14:27:24.656Z |
5430968 | 5430968 | 20241029000956_2KZMk | CA000R | 2024-10-31T12:19:23.294Z | 2024-11-06T14:27:22.355Z |
5430744 | 5430744 | 20241028233251_SE1Mm | CA000R | 2024-10-31T12:18:56.648Z | 2024-11-06T14:27:21.199Z |
5423234 | 5423234 | 20241029084558_M2IrG | CA000R | 2024-10-31T12:00:44.580Z | 2024-11-07T14:26:24.596Z |
5421431 | 5421431 | 20241028063339_8HAWe | CA000R | 2024-10-30T12:19:55.761Z | 2024-11-05T14:27:18.681Z |
5421394 | 5421394 | 20241028061721_WYrLp | CA000R | 2024-10-30T12:19:54.048Z | 2024-11-05T14:27:18.565Z |
5421376 | 5421376 | 20241028061159_9eoLT | CA000R | 2024-10-30T12:19:53.195Z | 2024-11-05T14:27:18.446Z |
5421360 | 5421360 | 20241028060714_X6TRL | CA000R | 2024-10-30T12:19:52.586Z | 2024-11-05T14:27:18.381Z |
5421356 | 5421356 | 20241028060648_Fa2Yk | CA000R | 2024-10-30T12:19:52.452Z | 2024-11-05T14:27:18.378Z |
5421316 | 5421316 | 20241028054517_YVSDw | CA000R | 2024-10-30T12:19:50.713Z | 2024-11-05T14:27:18.174Z |
5421127 | 5421127 | 20241028044306_i1RdX | CA000R | 2024-10-30T12:19:37.048Z | 2024-11-05T14:27:17.431Z |
5421019 | 5421019 | 20241028041846_CXF6U | CA000R | 2024-10-30T12:19:32.856Z | 2024-11-05T14:27:17.029Z |
5421017 | 5421017 | 20241028041806_3MVsN | CA000R | 2024-10-30T12:19:32.688Z | 2024-11-05T14:27:17.027Z |
5420905 | 5420905 | 20241028035336_mBQ7E | CA000R | 2024-10-30T12:19:25.455Z | 2024-11-05T14:27:16.710Z |
5420873 | 5420873 | 20241028034909_MEMQB | CA000R | 2024-10-30T12:19:23.647Z | 2024-11-05T14:27:16.615Z |
5420576 | 5420576 | 20241028030130_fIkPb | CA000R | 2024-10-30T12:19:02.331Z | 2024-11-05T14:27:15.783Z |
5420210 | 5420210 | 20241028021325_uTquC | CA000R | 2024-10-30T12:18:32.484Z | 2024-11-05T14:27:14.840Z |
5420137 | 5420137 | 20241028020258_z38jK | CA000R | 2024-10-30T12:18:24.112Z | 2024-11-05T14:27:14.656Z |
5420028 | 5420028 | 20241028014756_C5KmC | CA000R | 2024-10-30T12:18:15.280Z | 2024-11-05T14:27:14.388Z |
5419883 | 5419883 | 20241028012552_le3ef | CA000R | 2024-10-30T12:18:00.582Z | 2024-11-05T14:27:14.080Z |
5419730 | 5419730 | 20241028005810_lC8GQ | CA000R | 2024-10-30T12:17:48.875Z | 2024-11-05T14:27:13.820Z |
5419474 | 5419474 | 20241028000554_CQVa3 | CA000R | 2024-10-30T12:17:28.871Z | 2024-11-05T14:27:13.186Z |
5419182 | 5419182 | 20241027231134_QduU7 | CA000R | 2024-10-30T12:17:13.596Z | 2024-11-05T14:27:12.491Z |
5413504 | 5413504 | 20241028100942_7idyd | CA000R | 2024-10-30T12:03:20.590Z | 2024-11-06T14:27:06.220Z |
5413314 | 5413314 | 20241028093720_mMJbZ | CA000R | 2024-10-30T12:02:41.871Z | 2024-11-06T14:27:05.240Z |
5413307 | 5413307 | 20241028093347_Oq2RS | CA000R | 2024-10-30T12:02:40.491Z | 2024-11-06T14:27:05.235Z |
5413265 | 5413265 | 20241028092630_3xuER | CA000R | 2024-10-30T12:02:28.134Z | 2024-11-06T14:27:05.121Z |
5413252 | 5413252 | 20241028092242_Ugw3r | CA000R | 2024-10-30T12:02:25.085Z | 2024-11-06T14:27:05.111Z |
5413171 | 5413171 | 20241028090332_X3rPX | CA000R | 2024-10-30T12:02:09.508Z | 2024-11-06T14:27:04.567Z |
5413166 | 5413166 | 20241028090301_Sxr2l | CA000R | 2024-10-30T12:02:08.582Z | 2024-11-06T14:27:04.543Z |
5413160 | 5413160 | 20241028090145_oNR8O | CA000R | 2024-10-30T12:02:07.751Z | 2024-11-06T14:27:04.531Z |
5413132 | 5413132 | 20241028085544_4HYoY | CA000R | 2024-10-30T12:02:02.379Z | 2024-11-06T14:27:04.458Z |
5413108 | 5413108 | 20241028085116_fpTBz | CA000R | 2024-10-30T12:01:52.957Z | 2024-11-06T14:27:04.416Z |
5413063 | 5413063 | 20241028083856_y3aa1 | CA000R | 2024-10-30T12:01:43.065Z | 2024-11-06T14:27:04.270Z |
5413027 | 5413027 | 20241028083509_uZTZM | CA000R | 2024-10-30T12:01:36.854Z | 2024-11-06T14:27:04.100Z |
5412969 | 5412969 | 20241028082551_qN0FL | CA000R | 2024-10-30T12:01:24.046Z | 2024-11-06T14:27:03.864Z |
5412946 | 5412946 | 20241028081923_YBqSx | CA000R | 2024-10-30T12:01:16.218Z | 2024-11-06T14:27:03.656Z |
5412873 | 5412873 | 20241028075700_7ljvS | CA000R | 2024-10-30T12:01:02.354Z | 2024-11-06T14:27:03.438Z |
5412863 | 5412863 | 20241028075144_LmDyA | CA000R | 2024-10-30T12:01:00.030Z | 2024-11-06T14:27:03.404Z |
5412853 | 5412853 | 20241028074744_M0QBB | CA000R | 2024-10-30T12:00:57.986Z | 2024-11-06T14:27:03.191Z |
5412776 | 5412776 | 20241028073136_ZqIzv | CA000R | 2024-10-30T12:00:38.185Z | 2024-11-06T14:27:02.533Z |
5412771 | 5412771 | 20241028072816_1FaW4 | CA000R | 2024-10-30T12:00:37.261Z | 2024-11-06T14:27:02.504Z |
5412734 | 5412734 | 20241028071434_Q4WWV | CA000R | 2024-10-30T12:00:29.755Z | 2024-11-06T14:27:01.940Z |
5412669 | 5412669 | 20241028070232_EVYF8 | CA000R | 2024-10-30T12:00:17.479Z | 2024-11-06T14:27:01.611Z |
5411662 | 5411662 | 20241027090936_BAGjx | CA000R | 2024-10-29T12:19:06.528Z | 2024-11-05T14:26:55.484Z |
5407118 | 5407118 | 20241027022309_kqnBQ | CA000R | 2024-10-29T12:15:13.302Z | 2024-11-04T14:28:56.960Z |
5406767 | 5406767 | 20241027015857_wVp9b | CA000R | 2024-10-29T12:14:40.618Z | 2024-11-04T14:28:56.367Z |
5401266 | 5401266 | 20241027073234_OsBhi | CA000R | 2024-10-29T12:00:59.865Z | 2024-11-05T14:26:50.936Z |
5401232 | 5401232 | 20241027072829_ILueg | CA000R | 2024-10-29T12:00:54.127Z | 2024-11-05T14:26:50.702Z |
5401175 | 5401175 | 20241027072343_pBNb5 | CA000R | 2024-10-29T12:00:46.000Z | 2024-11-05T14:26:50.431Z |
5401170 | 5401170 | 20241027072152_aEBs5 | CA000R | 2024-10-29T12:00:45.062Z | 2024-11-05T14:26:50.412Z |
5401143 | 5401143 | 20241027071419_L422L | CA000R | 2024-10-29T12:00:41.048Z | 2024-11-05T14:26:50.271Z |
5401127 | 5401127 | 20241027071315_JocFV | CA000R | 2024-10-29T12:00:38.278Z | 2024-11-05T14:26:50.187Z |
5401093 | 5401093 | 20241027070812_1mLMK | CA000R | 2024-10-29T12:00:31.906Z | 2024-11-05T14:26:50.069Z |
5401040 | 5401040 | 20241027065721_pu9dh | CA000R | 2024-10-29T12:00:21.997Z | 2024-11-05T14:26:49.819Z |
5400968 | 5400968 | 20241027064725_TikdR | CA000R | 2024-10-29T12:00:09.829Z | 2024-11-05T14:26:49.458Z |
5388903 | 5388903 | 20241025062831_q3d8U | CA000R | 2024-10-27T12:22:35.272Z | 2024-11-02T12:28:35.128Z |
5388846 | 5388846 | 20241025061727_Fv6kR | CA000R | 2024-10-27T12:22:32.901Z | 2024-11-02T12:28:35.058Z |
5388844 | 5388844 | 20241025061635_pNSpQ | CA000R | 2024-10-27T12:22:32.679Z | 2024-11-02T12:28:35.056Z |
5388800 | 5388800 | 20241025060945_z34St | CA000R | 2024-10-27T12:22:31.365Z | 2024-11-02T12:28:34.992Z |
5388790 | 5388790 | 20241025060752_MsZS0 | CA000R | 2024-10-27T12:22:30.967Z | 2024-11-02T12:28:34.985Z |
5388759 | 5388759 | 20241025060306_oGe9s | CA000R | 2024-10-27T12:22:29.899Z | 2024-11-02T12:28:34.877Z |
5388755 | 5388755 | 20241025060220_P22bm | CA000R | 2024-10-27T12:22:29.513Z | 2024-11-02T12:28:34.874Z |
5388602 | 5388602 | 20241025053426_ZE27A | CA000R | 2024-10-27T12:22:23.101Z | 2024-11-02T12:28:34.635Z |
5388593 | 5388593 | 20241025053127_GgzNG | CA000R | 2024-10-27T12:22:22.199Z | 2024-11-02T12:28:34.499Z |
5388577 | 5388577 | 20241025052730_zaUmE | CA000R | 2024-10-27T12:22:21.694Z | 2024-11-02T12:28:34.462Z |
5388567 | 5388567 | 20241025052552_QMadI | CA000R | 2024-10-27T12:22:21.408Z | 2024-11-02T12:28:34.443Z |
5388531 | 5388531 | 20241025051942_ihhDA | CA000R | 2024-10-27T12:22:19.784Z | 2024-11-02T12:28:34.345Z |
5388459 | 5388459 | 20241025050031_6BkAu | CA000R | 2024-10-27T12:22:15.204Z | 2024-11-02T12:28:34.209Z |
5388450 | 5388450 | 20241025045404_tqgqx | CA000R | 2024-10-27T12:22:14.623Z | 2024-11-02T12:28:34.169Z |
5388448 | 5388448 | 20241025045400_oOp2a | CA000R | 2024-10-27T12:22:14.535Z | 2024-11-02T12:28:34.169Z |
5388426 | 5388426 | 20241025044921_xklGJ | CA000R | 2024-10-27T12:22:13.671Z | 2024-11-02T12:28:34.159Z |
5388409 | 5388409 | 20241025044714_3l3P4 | CA000R | 2024-10-27T12:22:12.894Z | 2024-11-02T12:28:34.108Z |
5388396 | 5388396 | 20241025044527_U2iXA | CA000R | 2024-10-27T12:22:12.263Z | 2024-11-02T12:28:34.050Z |
5388201 | 5388201 | 20241025041708_9eLRK | CA000R | 2024-10-27T12:22:03.989Z | 2024-11-02T12:28:33.839Z |
5388143 | 5388143 | 20241025040832_t4Iix | CA000R | 2024-10-27T12:22:01.564Z | 2024-11-02T12:28:33.780Z |
5388138 | 5388138 | 20241025040809_P6CHQ | CA000R | 2024-10-27T12:22:01.528Z | 2024-11-02T12:28:33.778Z |
5388114 | 5388114 | 20241025040436_TUvGr | CA000R | 2024-10-27T12:22:00.069Z | 2024-11-02T12:28:33.752Z |
5388109 | 5388109 | 20241025040406_54dZi | CA000R | 2024-10-27T12:21:59.937Z | 2024-11-02T12:28:33.750Z |
5387623 | 5387623 | 20241025030305_y13pW | CA000R | 2024-10-27T12:21:31.328Z | 2024-11-02T12:28:32.844Z |
5387581 | 5387581 | 20241025025751_JFGI0 | CA000R | 2024-10-27T12:21:29.417Z | 2024-11-02T12:28:32.790Z |
5387387 | 5387387 | 20241025023005_HN3Ti | CA000R | 2024-10-27T12:21:18.121Z | 2024-11-02T12:28:32.445Z |
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);