participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,657 rows where station_code = "HR0021" 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 |
---|---|---|---|---|---|
5505312 | 5505312 | 20241108043427_K7pzV | HR0021 | 2024-11-09T14:16:08.302Z | 2024-11-09T14:16:28.752Z |
5505281 | 5505281 | 20241108042509_nP628 | HR0021 | 2024-11-09T14:16:03.842Z | 2024-11-09T14:16:28.743Z |
5502075 | 5502075 | 20241107171335_jewD6 | HR0021 | 2024-11-09T14:10:54.850Z | 2024-11-09T14:16:27.937Z |
5502066 | 5502066 | 20241107170922_fF1ja | HR0021 | 2024-11-09T14:10:54.344Z | 2024-11-09T14:16:27.934Z |
5497567 | 5497567 | 20241107040133_Mzwuh | HR0021 | 2024-11-08T14:13:59.033Z | 2024-11-09T14:18:46.308Z |
5497560 | 5497560 | 20241107040049_EqP89 | HR0021 | 2024-11-08T14:13:58.597Z | 2024-11-09T14:18:46.264Z |
5497549 | 5497549 | 20241107035845_zh1bR | HR0021 | 2024-11-08T14:13:57.722Z | 2024-11-09T14:18:45.958Z |
5497035 | 5497035 | 20241107023156_5OaXP | HR0021 | 2024-11-08T14:13:06.774Z | 2024-11-09T14:18:34.596Z |
5495722 | 5495722 | 20241106211403_naZk8 | HR0021 | 2024-11-08T14:10:41.820Z | 2024-11-09T14:18:05.946Z |
5495593 | 5495593 | 20241106202810_m9JQS | HR0021 | 2024-11-08T14:10:26.742Z | 2024-11-09T14:18:00.140Z |
5495581 | 5495581 | 20241106202518_qeTrk | HR0021 | 2024-11-08T14:10:25.868Z | 2024-11-09T14:17:59.803Z |
5495515 | 5495515 | 20241106200614_uqZE3 | HR0021 | 2024-11-08T14:10:19.827Z | 2024-11-09T14:17:56.396Z |
5495343 | 5495343 | 20241106193215_SWUHM | HR0021 | 2024-11-08T14:10:03.924Z | 2024-11-09T14:17:51.513Z |
5495331 | 5495331 | 20241106193038_KHzsN | HR0021 | 2024-11-08T14:10:01.301Z | 2024-11-09T14:17:51.369Z |
5495242 | 5495242 | 20241106190411_3Zvnz | HR0021 | 2024-11-08T14:09:43.660Z | 2024-11-09T14:17:46.710Z |
5495202 | 5495202 | 20241106185700_WEwjg | HR0021 | 2024-11-08T14:09:37.472Z | 2024-11-09T14:17:45.200Z |
5494729 | 5494729 | 20241106170624_YyMBg | HR0021 | 2024-11-08T14:08:29.933Z | 2024-11-09T14:17:26.829Z |
5494674 | 5494674 | 20241106164822_DN2Fh | HR0021 | 2024-11-08T14:08:18.857Z | 2024-11-09T14:17:25.147Z |
5492078 | 5492078 | 20241031212556_I1v35 | HR0021 | 2024-11-07T14:25:10.954Z | 2024-11-09T14:24:19.536Z |
5492076 | 5492076 | 20241031211034_RyGYx | HR0021 | 2024-11-07T14:25:10.531Z | 2024-11-09T14:24:18.172Z |
5492074 | 5492074 | 20241031201825_j9z9b | HR0021 | 2024-11-07T14:25:09.095Z | 2024-11-09T14:24:17.512Z |
5492067 | 5492067 | 20241031165618_ATC3C | HR0021 | 2024-11-07T14:25:00.570Z | 2024-11-09T14:24:12.205Z |
5492038 | 5492038 | 20241102182404_pfOs2 | HR0021 | 2024-11-07T14:23:38.781Z | 2024-11-09T14:22:51.859Z |
5492022 | 5492022 | 20241103195941_t72U2 | HR0021 | 2024-11-07T14:21:53.700Z | 2024-11-09T14:21:57.835Z |
5492020 | 5492020 | 20241103191450_wbKIF | HR0021 | 2024-11-07T14:21:48.716Z | 2024-11-09T14:21:56.145Z |
5492018 | 5492018 | 20241103182029_mtgbJ | HR0021 | 2024-11-07T14:21:41.234Z | 2024-11-09T14:21:52.796Z |
5491686 | 5491686 | 20241106042809_JmX3v | HR0021 | 2024-11-07T14:16:45.557Z | 2024-11-09T14:20:12.877Z |
5491376 | 5491376 | 20241106030849_58nuN | HR0021 | 2024-11-07T14:16:00.046Z | 2024-11-09T14:20:07.230Z |
5491268 | 5491268 | 20241106024157_NnfMF | HR0021 | 2024-11-07T14:15:44.569Z | 2024-11-09T14:20:06.227Z |
5491057 | 5491057 | 20241106014640_F7ETv | HR0021 | 2024-11-07T14:15:16.218Z | 2024-11-09T14:20:03.485Z |
5490963 | 5490963 | 20241106012328_1q2xd | HR0021 | 2024-11-07T14:15:08.395Z | 2024-11-09T14:20:02.422Z |
5490885 | 5490885 | 20241106010454_i5D9u | HR0021 | 2024-11-07T14:15:02.697Z | 2024-11-09T14:20:01.004Z |
5490843 | 5490843 | 20241106005112_8cqmu | HR0021 | 2024-11-07T14:14:58.742Z | 2024-11-09T14:20:00.135Z |
5490605 | 5490605 | 20241105233657_ztSIz | HR0021 | 2024-11-07T14:14:17.219Z | 2024-11-09T14:19:57.237Z |
5490381 | 5490381 | 20241105222948_2nDwY | HR0021 | 2024-11-07T14:13:57.230Z | 2024-11-09T14:19:54.490Z |
5490290 | 5490290 | 20241105220308_3zIU6 | HR0021 | 2024-11-07T14:13:49.336Z | 2024-11-09T14:19:53.463Z |
5490005 | 5490005 | 20241105204112_JOpns | HR0021 | 2024-11-07T14:13:01.728Z | 2024-11-09T14:19:49.898Z |
5489863 | 5489863 | 20241105202123_NC3Bf | HR0021 | 2024-11-07T14:12:51.021Z | 2024-11-09T14:19:47.262Z |
5489731 | 5489731 | 20241105195251_gQ0oL | HR0021 | 2024-11-07T14:12:41.847Z | 2024-11-09T14:19:46.287Z |
5489171 | 5489171 | 20241105180048_oT678 | HR0021 | 2024-11-07T14:11:24.817Z | 2024-11-09T14:19:37.865Z |
5485117 | 5485117 | 20241105040636_MZf2j | HR0021 | 2024-11-06T14:17:46.954Z | 2024-11-09T14:21:19.494Z |
5478853 | 5478853 | 20241103042008_t2C2O | HR0021 | 2024-11-05T14:21:53.484Z | 2024-11-09T14:23:03.803Z |
5474835 | 5474835 | 20241103182318_3du38 | HR0021 | 2024-11-05T14:12:08.706Z | 2024-11-09T14:21:53.136Z |
5469791 | 5469791 | 20241103042008_OCKay | HR0021 | 2024-11-04T14:17:03.284Z | 2024-11-04T14:18:01.591Z |
5461587 | 5461587 | 20241101200716_nZnkX | HR0021 | 2024-11-03T14:15:57.244Z | 2024-11-09T14:23:29.959Z |
5461561 | 5461561 | 20241101195724_t836x | HR0021 | 2024-11-03T14:15:55.553Z | 2024-11-09T14:23:29.800Z |
5461323 | 5461323 | 20241101175734_RPpN5 | HR0021 | 2024-11-03T14:15:09.869Z | 2024-11-09T14:23:27.853Z |
5461256 | 5461256 | 20241101172253_htujm | HR0021 | 2024-11-03T14:14:57.973Z | 2024-11-09T14:23:27.578Z |
5452693 | 5452693 | 20241101040932_syEeD | HR0021 | 2024-11-02T12:19:14.702Z | 2024-11-09T14:24:32.860Z |
5451170 | 5451170 | 20241031225513_TypS9 | HR0021 | 2024-11-02T12:16:40.789Z | 2024-11-09T14:24:22.070Z |
5450715 | 5450715 | 20241031203230_LUDOd | HR0021 | 2024-11-02T12:15:47.035Z | 2024-11-09T14:24:17.683Z |
5450561 | 5450561 | 20241031194929_ZKpFS | HR0021 | 2024-11-02T12:15:35.705Z | 2024-11-09T14:24:16.498Z |
5450255 | 5450255 | 20241031182644_NF443 | HR0021 | 2024-11-02T12:14:51.503Z | 2024-11-09T14:24:14.927Z |
5450147 | 5450147 | 20241031180317_nKkXu | HR0021 | 2024-11-02T12:14:38.863Z | 2024-11-09T14:24:13.887Z |
5450121 | 5450121 | 20241031175637_KjKoF | HR0021 | 2024-11-02T12:14:37.014Z | 2024-11-09T14:24:13.701Z |
5450105 | 5450105 | 20241031175436_LFyzx | HR0021 | 2024-11-02T12:14:34.339Z | 2024-11-09T14:24:13.658Z |
5441089 | 5441089 | 20241029204152_KUzHp | HR0021 | 2024-11-01T12:18:05.599Z | 2024-11-07T14:26:40.620Z |
5439556 | 5439556 | 20241030200711_hpxa3 | HR0021 | 2024-11-01T12:13:59.008Z | 2024-11-08T14:23:04.090Z |
5438991 | 5438991 | 20241030184128_0gzm0 | HR0021 | 2024-11-01T12:12:57.062Z | 2024-11-08T14:23:01.685Z |
5438627 | 5438627 | 20241030174332_KrC2H | HR0021 | 2024-11-01T12:12:11.472Z | 2024-11-08T14:23:00.468Z |
5438435 | 5438435 | 20241030171729_mVBdN | HR0021 | 2024-11-01T12:11:41.728Z | 2024-11-08T14:22:59.973Z |
5433600 | 5433600 | 20241029203021_Hs3Cw | HR0021 | 2024-10-31T12:22:24.072Z | 2024-11-07T14:26:40.269Z |
5433413 | 5433413 | 20241029194854_F6F85 | HR0021 | 2024-10-31T12:22:13.635Z | 2024-11-07T14:26:39.284Z |
5433386 | 5433386 | 20241029192948_es5F9 | HR0021 | 2024-10-31T12:22:11.828Z | 2024-11-07T14:26:38.798Z |
5433267 | 5433267 | 20241029184052_2ZREJ | HR0021 | 2024-10-31T12:22:02.951Z | 2024-11-07T14:26:37.429Z |
5433170 | 5433170 | 20241029175129_Z3pbI | HR0021 | 2024-10-31T12:21:53.827Z | 2024-11-07T14:26:35.957Z |
5433163 | 5433163 | 20241029174925_QFnQd | HR0021 | 2024-10-31T12:21:53.723Z | 2024-11-07T14:26:35.869Z |
5433125 | 5433125 | 20241029170250_vLAbF | HR0021 | 2024-10-31T12:21:50.382Z | 2024-11-07T14:26:34.706Z |
5432716 | 5432716 | 20241029042436_jqalw | HR0021 | 2024-10-31T12:21:32.307Z | 2024-11-06T14:27:28.540Z |
5432543 | 5432543 | 20241029035058_yRTlC | HR0021 | 2024-10-31T12:21:26.537Z | 2024-11-06T14:27:27.808Z |
5430174 | 5430174 | 20241028212704_ZFZ9X | HR0021 | 2024-10-31T12:17:49.196Z | 2024-11-06T14:27:19.118Z |
5428677 | 5428677 | 20241028175307_R2g9V | HR0021 | 2024-10-31T12:15:23.434Z | 2024-11-06T14:27:14.249Z |
5420365 | 5420365 | 20241028023336_7cpBf | HR0021 | 2024-10-30T12:18:45.626Z | 2024-11-05T14:27:15.283Z |
5420267 | 5420267 | 20241028022320_9tANg | HR0021 | 2024-10-30T12:18:39.438Z | 2024-11-05T14:27:15.025Z |
5407853 | 5407853 | 20241027025531_oYKUd | HR0021 | 2024-10-29T12:15:49.187Z | 2024-11-04T14:28:58.246Z |
5405596 | 5405596 | 20241027004735_Wdf5K | HR0021 | 2024-10-29T12:13:04.152Z | 2024-11-04T14:28:53.670Z |
5403051 | 5403051 | 20241026211026_vPDxY | HR0021 | 2024-10-29T12:08:50.285Z | 2024-11-04T14:28:47.610Z |
5366462 | 5366462 | 20241022203640_U9ZSv | HR0021 | 2024-10-25T12:20:14.319Z | 2024-10-31T12:29:56.547Z |
5350355 | 5350355 | 20241022213740_t3SiQ | HR0021 | 2024-10-24T12:15:38.114Z | 2024-10-31T12:29:58.039Z |
5349841 | 5349841 | 20241022204007_r58Gj | HR0021 | 2024-10-24T12:14:42.725Z | 2024-10-31T12:29:56.777Z |
5348815 | 5348815 | 20241022190003_2xbmh | HR0021 | 2024-10-24T12:12:22.667Z | 2024-10-31T12:29:53.820Z |
5348666 | 5348666 | 20241022184100_8XPym | HR0021 | 2024-10-24T12:11:59.461Z | 2024-10-31T12:29:53.257Z |
5348190 | 5348190 | 20241022173920_ErAbw | HR0021 | 2024-10-24T12:10:29.791Z | 2024-10-31T12:29:51.743Z |
5348017 | 5348017 | 20241022171023_Pm5ni | HR0021 | 2024-10-24T12:10:00.093Z | 2024-10-31T12:29:51.376Z |
5338567 | 5338567 | 20241021195945_o2EDy | HR0021 | 2024-10-23T12:11:23.932Z | 2024-10-30T12:26:42.508Z |
5338235 | 5338235 | 20241021185735_epl5H | HR0021 | 2024-10-23T12:10:33.109Z | 2024-10-30T12:26:41.918Z |
5338060 | 5338060 | 20241021182754_z8OKc | HR0021 | 2024-10-23T12:10:01.833Z | 2024-10-30T12:26:41.432Z |
5332660 | 5332660 | 20241020213522_r952y | HR0021 | 2024-10-22T12:13:54.503Z | 2024-10-29T12:26:33.665Z |
5332460 | 5332460 | 20241020200031_HXYJl | HR0021 | 2024-10-22T12:13:11.365Z | 2024-10-29T12:26:33.307Z |
5332266 | 5332266 | 20241020173640_PJo7g | HR0021 | 2024-10-22T12:12:13.456Z | 2024-10-29T12:26:31.983Z |
5316999 | 5316999 | 20241016022248_e8FEh | HR0021 | 2024-10-17T12:07:32.634Z | 2024-10-24T12:27:58.527Z |
5299907 | 5299907 | 20241012194528_uVyqT | HR0021 | 2024-10-14T12:13:16.859Z | 2024-10-21T12:23:44.866Z |
5299714 | 5299714 | 20241012192245_izzNH | HR0021 | 2024-10-14T12:13:00.163Z | 2024-10-21T12:23:43.281Z |
5299091 | 5299091 | 20241012180253_u3oCr | HR0021 | 2024-10-14T12:11:47.336Z | 2024-10-21T12:23:34.233Z |
5291416 | 5291416 | 20241011205209_FmZD5 | HR0021 | 2024-10-13T12:14:29.844Z | 2024-10-20T12:24:30.532Z |
5290422 | 5290422 | 20241011174509_cGvkj | HR0021 | 2024-10-13T12:12:22.279Z | 2024-10-20T12:24:15.881Z |
5290409 | 5290409 | 20241011174422_mxxHC | HR0021 | 2024-10-13T12:12:20.991Z | 2024-10-20T12:24:15.779Z |
5285641 | 5285641 | 20241012042502_dLi3I | HR0021 | 2024-10-13T12:00:10.583Z | 2024-10-21T12:22:39.644Z |
5263194 | 5263194 | 20241006222542_SHE73 | HR0021 | 2024-10-09T12:19:57.854Z | 2024-10-15T12:29:06.308Z |
5263186 | 5263186 | 20241006195750_8mqeF | HR0021 | 2024-10-09T12:19:26.271Z | 2024-10-15T12:29:00.136Z |
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);