participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,684 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 |
---|---|---|---|---|---|
5544935 | 5544935 | 20241115174445_fRbjJ | HR0021 | 2024-11-17T14:03:22.029Z | 2024-11-24T14:25:41.321Z |
5543715 | 5543715 | 20241115030336_aIYP4 | HR0021 | 2024-11-16T14:07:03.871Z | 2024-11-23T14:26:20.510Z |
5543694 | 5543694 | 20241115030013_Njn23 | HR0021 | 2024-11-16T14:07:02.342Z | 2024-11-23T14:26:20.406Z |
5543005 | 5543005 | 20241114175120_8PrfF | HR0021 | 2024-11-16T14:05:15.437Z | 2024-11-23T14:26:16.993Z |
5542986 | 5542986 | 20241114171208_MhIAP | HR0021 | 2024-11-16T14:05:12.224Z | 2024-11-23T14:26:16.421Z |
5542984 | 5542984 | 20241114170557_sSL2t | HR0021 | 2024-11-16T14:05:11.707Z | 2024-11-23T14:26:15.992Z |
5542982 | 5542982 | 20241114164458_J1hlW | HR0021 | 2024-11-16T14:05:10.405Z | 2024-11-23T14:26:15.904Z |
5538479 | 5538479 | 20241113035443_5pME2 | HR0021 | 2024-11-14T14:13:31.380Z | 2024-11-21T14:26:26.529Z |
5538391 | 5538391 | 20241113032550_3mMRX | HR0021 | 2024-11-14T14:13:22.232Z | 2024-11-21T14:26:25.091Z |
5538346 | 5538346 | 20241113031657_B0G7C | HR0021 | 2024-11-14T14:13:17.271Z | 2024-11-21T14:26:24.258Z |
5538299 | 5538299 | 20241113030242_B3NFx | HR0021 | 2024-11-14T14:13:12.332Z | 2024-11-21T14:26:22.943Z |
5536450 | 5536450 | 20241112180559_MShmU | HR0021 | 2024-11-14T14:09:59.046Z | 2024-11-21T14:26:01.043Z |
5531783 | 5531783 | 20241112040847_JP93D | HR0021 | 2024-11-13T14:15:54.925Z | 2024-11-20T14:26:14.328Z |
5531006 | 5531006 | 20241112030545_cvgxV | HR0021 | 2024-11-13T14:15:00.140Z | 2024-11-20T14:26:05.887Z |
5524420 | 5524420 | 20241111040955_F2aGq | HR0021 | 2024-11-12T14:17:17.591Z | 2024-11-19T14:22:21.210Z |
5524354 | 5524354 | 20241111035959_DWVts | HR0021 | 2024-11-12T14:17:06.310Z | 2024-11-19T14:22:20.480Z |
5524217 | 5524217 | 20241111033504_FNj8p | HR0021 | 2024-11-12T14:16:47.700Z | 2024-11-19T14:22:18.884Z |
5521719 | 5521719 | 20241110180818_vgQys | HR0021 | 2024-11-12T14:11:53.766Z | 2024-11-19T14:21:54.591Z |
5517748 | 5517748 | 20241110044222_z5Wqm | HR0021 | 2024-11-11T14:14:49.421Z | 2024-11-18T14:26:38.042Z |
5515141 | 5515141 | 20241109193448_F827U | HR0021 | 2024-11-11T14:10:08.861Z | 2024-11-18T14:26:24.491Z |
5514978 | 5514978 | 20241109184655_Nv3WT | HR0021 | 2024-11-11T14:09:50.366Z | 2024-11-18T14:26:23.680Z |
5511095 | 5511095 | 20241109042427_wEs3N | HR0021 | 2024-11-10T14:16:14.186Z | 2024-11-17T14:24:04.524Z |
5510714 | 5510714 | 20241109032804_MpOQr | HR0021 | 2024-11-10T14:15:35.598Z | 2024-11-17T14:24:00.598Z |
5510270 | 5510270 | 20241109021342_LSrOO | HR0021 | 2024-11-10T14:14:55.252Z | 2024-11-17T14:23:54.855Z |
5509893 | 5509893 | 20241109010446_Ncby2 | HR0021 | 2024-11-10T14:14:11.001Z | 2024-11-17T14:23:50.490Z |
5509764 | 5509764 | 20241109003010_SC9vr | HR0021 | 2024-11-10T14:13:58.083Z | 2024-11-17T14:23:48.932Z |
5508664 | 5508664 | 20241108170904_iT2xW | HR0021 | 2024-11-10T14:11:04.615Z | 2024-11-17T14:23:27.009Z |
5505312 | 5505312 | 20241108043427_K7pzV | HR0021 | 2024-11-09T14:16:08.302Z | 2024-11-16T14:28:29.942Z |
5505281 | 5505281 | 20241108042509_nP628 | HR0021 | 2024-11-09T14:16:03.842Z | 2024-11-16T14:28:29.393Z |
5502075 | 5502075 | 20241107171335_jewD6 | HR0021 | 2024-11-09T14:10:54.850Z | 2024-11-16T14:27:50.324Z |
5502066 | 5502066 | 20241107170922_fF1ja | HR0021 | 2024-11-09T14:10:54.344Z | 2024-11-16T14:27:50.193Z |
5497567 | 5497567 | 20241107040133_Mzwuh | HR0021 | 2024-11-08T14:13:59.033Z | 2024-11-15T14:25:04.736Z |
5497560 | 5497560 | 20241107040049_EqP89 | HR0021 | 2024-11-08T14:13:58.597Z | 2024-11-15T14:25:04.707Z |
5497549 | 5497549 | 20241107035845_zh1bR | HR0021 | 2024-11-08T14:13:57.722Z | 2024-11-15T14:25:04.693Z |
5497035 | 5497035 | 20241107023156_5OaXP | HR0021 | 2024-11-08T14:13:06.774Z | 2024-11-15T14:25:01.414Z |
5495722 | 5495722 | 20241106211403_naZk8 | HR0021 | 2024-11-08T14:10:41.820Z | 2024-11-15T14:24:52.733Z |
5495593 | 5495593 | 20241106202810_m9JQS | HR0021 | 2024-11-08T14:10:26.742Z | 2024-11-15T14:24:51.032Z |
5495581 | 5495581 | 20241106202518_qeTrk | HR0021 | 2024-11-08T14:10:25.868Z | 2024-11-15T14:24:50.976Z |
5495515 | 5495515 | 20241106200614_uqZE3 | HR0021 | 2024-11-08T14:10:19.827Z | 2024-11-15T14:24:50.218Z |
5495343 | 5495343 | 20241106193215_SWUHM | HR0021 | 2024-11-08T14:10:03.924Z | 2024-11-15T14:24:48.459Z |
5495331 | 5495331 | 20241106193038_KHzsN | HR0021 | 2024-11-08T14:10:01.301Z | 2024-11-15T14:24:48.423Z |
5495242 | 5495242 | 20241106190411_3Zvnz | HR0021 | 2024-11-08T14:09:43.660Z | 2024-11-15T14:24:47.831Z |
5495202 | 5495202 | 20241106185700_WEwjg | HR0021 | 2024-11-08T14:09:37.472Z | 2024-11-15T14:24:47.450Z |
5494729 | 5494729 | 20241106170624_YyMBg | HR0021 | 2024-11-08T14:08:29.933Z | 2024-11-15T14:24:42.005Z |
5494674 | 5494674 | 20241106164822_DN2Fh | HR0021 | 2024-11-08T14:08:18.857Z | 2024-11-15T14:24:41.175Z |
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-11T14:22:42.200Z |
5492022 | 5492022 | 20241103195941_t72U2 | HR0021 | 2024-11-07T14:21:53.700Z | 2024-11-12T14:27:58.427Z |
5492020 | 5492020 | 20241103191450_wbKIF | HR0021 | 2024-11-07T14:21:48.716Z | 2024-11-12T14:27:57.226Z |
5492018 | 5492018 | 20241103182029_mtgbJ | HR0021 | 2024-11-07T14:21:41.234Z | 2024-11-12T14:27:54.865Z |
5491686 | 5491686 | 20241106042809_JmX3v | HR0021 | 2024-11-07T14:16:45.557Z | 2024-11-14T14:23:26.424Z |
5491376 | 5491376 | 20241106030849_58nuN | HR0021 | 2024-11-07T14:16:00.046Z | 2024-11-14T14:23:25.455Z |
5491268 | 5491268 | 20241106024157_NnfMF | HR0021 | 2024-11-07T14:15:44.569Z | 2024-11-14T14:23:25.017Z |
5491057 | 5491057 | 20241106014640_F7ETv | HR0021 | 2024-11-07T14:15:16.218Z | 2024-11-14T14:23:23.522Z |
5490963 | 5490963 | 20241106012328_1q2xd | HR0021 | 2024-11-07T14:15:08.395Z | 2024-11-14T14:23:23.023Z |
5490885 | 5490885 | 20241106010454_i5D9u | HR0021 | 2024-11-07T14:15:02.697Z | 2024-11-14T14:23:22.697Z |
5490843 | 5490843 | 20241106005112_8cqmu | HR0021 | 2024-11-07T14:14:58.742Z | 2024-11-14T14:23:22.586Z |
5490605 | 5490605 | 20241105233657_ztSIz | HR0021 | 2024-11-07T14:14:17.219Z | 2024-11-14T14:23:20.932Z |
5490381 | 5490381 | 20241105222948_2nDwY | HR0021 | 2024-11-07T14:13:57.230Z | 2024-11-14T14:23:19.270Z |
5490290 | 5490290 | 20241105220308_3zIU6 | HR0021 | 2024-11-07T14:13:49.336Z | 2024-11-14T14:23:18.695Z |
5490005 | 5490005 | 20241105204112_JOpns | HR0021 | 2024-11-07T14:13:01.728Z | 2024-11-14T14:23:17.102Z |
5489863 | 5489863 | 20241105202123_NC3Bf | HR0021 | 2024-11-07T14:12:51.021Z | 2024-11-14T14:23:15.993Z |
5489731 | 5489731 | 20241105195251_gQ0oL | HR0021 | 2024-11-07T14:12:41.847Z | 2024-11-14T14:23:15.416Z |
5489171 | 5489171 | 20241105180048_oT678 | HR0021 | 2024-11-07T14:11:24.817Z | 2024-11-14T14:23:10.801Z |
5485117 | 5485117 | 20241105040636_MZf2j | HR0021 | 2024-11-06T14:17:46.954Z | 2024-11-13T14:27:40.783Z |
5478853 | 5478853 | 20241103042008_t2C2O | HR0021 | 2024-11-05T14:21:53.484Z | 2024-11-11T14:23:02.243Z |
5474835 | 5474835 | 20241103182318_3du38 | HR0021 | 2024-11-05T14:12:08.706Z | 2024-11-12T14:27:54.983Z |
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-10T14:26:29.222Z |
5461561 | 5461561 | 20241101195724_t836x | HR0021 | 2024-11-03T14:15:55.553Z | 2024-11-10T14:26:29.169Z |
5461323 | 5461323 | 20241101175734_RPpN5 | HR0021 | 2024-11-03T14:15:09.869Z | 2024-11-10T14:26:28.107Z |
5461256 | 5461256 | 20241101172253_htujm | HR0021 | 2024-11-03T14:14:57.973Z | 2024-11-10T14:26:27.761Z |
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 |
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);