participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
14,744 rows where station_code = "HR0024" 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 |
---|---|---|---|---|---|
5125712 | 5125712 | 20240918032634_ZDXPj | HR0024 | 2024-09-19T12:03:56.216Z | 2024-09-19T12:06:42.074Z |
5125404 | 5125404 | 20240918022846_C3f3j | HR0024 | 2024-09-19T12:03:09.886Z | 2024-09-19T12:06:42.027Z |
5125361 | 5125361 | 20240918022038_FuBVz | HR0024 | 2024-09-19T12:03:04.578Z | 2024-09-19T12:06:42.020Z |
5125256 | 5125256 | 20240918014354_kwgcz | HR0024 | 2024-09-19T12:02:37.054Z | 2024-09-19T12:06:42.000Z |
5125099 | 5125099 | 20240918001410_1RWE8 | HR0024 | 2024-09-19T12:02:19.665Z | 2024-09-19T12:06:41.977Z |
5125033 | 5125033 | 20240917233931_aIuVh | HR0024 | 2024-09-19T12:01:58.482Z | 2024-09-19T12:06:41.964Z |
5110465 | 5110465 | 20240911020025_uzyqh | HR0024 | 2024-09-17T12:18:00.391Z | 2024-09-19T12:21:40.435Z |
5093046 | 5093046 | 20240912030908_VrSmh | HR0024 | 2024-09-16T12:14:10.739Z | 2024-09-19T12:21:14.914Z |
5092961 | 5092961 | 20240912030259_XohS0 | HR0024 | 2024-09-16T12:14:08.156Z | 2024-09-19T12:21:14.764Z |
5092868 | 5092868 | 20240912030012_yPyVZ | HR0024 | 2024-09-16T12:14:05.691Z | 2024-09-19T12:21:14.620Z |
5092694 | 5092694 | 20240912025450_31bse | HR0024 | 2024-09-16T12:14:02.226Z | 2024-09-19T12:21:14.421Z |
5092610 | 5092610 | 20240912025223_ngbyg | HR0024 | 2024-09-16T12:14:00.644Z | 2024-09-19T12:21:14.361Z |
5091528 | 5091528 | 20240912021233_Q3zV0 | HR0024 | 2024-09-16T12:13:09.787Z | 2024-09-19T12:21:13.181Z |
5090925 | 5090925 | 20240912015104_0HKzU | HR0024 | 2024-09-16T12:12:42.737Z | 2024-09-19T12:21:12.362Z |
5090783 | 5090783 | 20240912014526_x4q39 | HR0024 | 2024-09-16T12:12:35.875Z | 2024-09-19T12:21:12.075Z |
5090580 | 5090580 | 20240912013253_6SChk | HR0024 | 2024-09-16T12:12:25.848Z | 2024-09-19T12:21:11.449Z |
5090385 | 5090385 | 20240912012349_0lsI1 | HR0024 | 2024-09-16T12:12:17.900Z | 2024-09-19T12:21:11.280Z |
5089954 | 5089954 | 20240912010412_NYQhj | HR0024 | 2024-09-16T12:11:51.675Z | 2024-09-19T12:21:10.825Z |
5089860 | 5089860 | 20240912010000_uAbcu | HR0024 | 2024-09-16T12:11:46.639Z | 2024-09-19T12:21:10.585Z |
5089648 | 5089648 | 20240912005206_1Fk8Y | HR0024 | 2024-09-16T12:11:35.093Z | 2024-09-19T12:21:10.148Z |
5089558 | 5089558 | 20240912004916_Ruv7R | HR0024 | 2024-09-16T12:11:29.309Z | 2024-09-19T12:21:10.046Z |
5089439 | 5089439 | 20240912004129_OVlWY | HR0024 | 2024-09-16T12:11:25.301Z | 2024-09-19T12:21:09.962Z |
5089344 | 5089344 | 20240912003700_vV2Jk | HR0024 | 2024-09-16T12:11:21.137Z | 2024-09-19T12:21:09.896Z |
5089132 | 5089132 | 20240912002724_PpGnR | HR0024 | 2024-09-16T12:11:16.023Z | 2024-09-19T12:21:09.806Z |
5089042 | 5089042 | 20240912002311_QeMcD | HR0024 | 2024-09-16T12:11:13.857Z | 2024-09-19T12:21:09.714Z |
5080044 | 5080044 | 20240911032911_RZrwQ | HR0024 | 2024-09-15T12:16:48.297Z | 2024-09-19T12:21:43.065Z |
5079650 | 5079650 | 20240911030704_hdrOb | HR0024 | 2024-09-15T12:16:32.420Z | 2024-09-19T12:21:42.546Z |
5079609 | 5079609 | 20240911030554_yHprY | HR0024 | 2024-09-15T12:16:29.713Z | 2024-09-19T12:21:42.496Z |
5079500 | 5079500 | 20240911025848_40P0t | HR0024 | 2024-09-15T12:16:23.255Z | 2024-09-19T12:21:42.301Z |
5079157 | 5079157 | 20240911023609_1SEX8 | HR0024 | 2024-09-15T12:16:09.081Z | 2024-09-19T12:21:41.210Z |
5078975 | 5078975 | 20240911022731_jCavH | HR0024 | 2024-09-15T12:16:01.208Z | 2024-09-19T12:21:40.949Z |
5078962 | 5078962 | 20240911022543_3canK | HR0024 | 2024-09-15T12:16:00.793Z | 2024-09-19T12:21:40.934Z |
5078920 | 5078920 | 20240911022158_QV1F9 | HR0024 | 2024-09-15T12:15:57.670Z | 2024-09-19T12:21:40.836Z |
5078914 | 5078914 | 20240911022048_mKgxw | HR0024 | 2024-09-15T12:15:55.706Z | 2024-09-19T12:21:40.816Z |
5078746 | 5078746 | 20240911021332_DcxNb | HR0024 | 2024-09-15T12:15:50.949Z | 2024-09-19T12:21:40.694Z |
5078570 | 5078570 | 20240911020400_97h15 | HR0024 | 2024-09-15T12:15:43.811Z | 2024-09-19T12:21:40.512Z |
5078469 | 5078469 | 20240911020014_ZfKIC | HR0024 | 2024-09-15T12:15:39.815Z | 2024-09-19T12:21:40.430Z |
5078450 | 5078450 | 20240911015739_WX2NO | HR0024 | 2024-09-15T12:15:39.047Z | 2024-09-19T12:21:40.418Z |
5077339 | 5077339 | 20240911004514_r72iS | HR0024 | 2024-09-15T12:14:39.114Z | 2024-09-19T12:21:38.682Z |
5077292 | 5077292 | 20240911004109_n2G2l | HR0024 | 2024-09-15T12:14:37.146Z | 2024-09-19T12:21:38.635Z |
5075709 | 5075709 | 20240912000215_CDM0o | HR0024 | 2024-09-15T12:10:09.190Z | 2024-09-19T12:21:09.448Z |
5075626 | 5075626 | 20240911235819_fYNX0 | HR0024 | 2024-09-15T12:10:05.420Z | 2024-09-19T12:21:09.359Z |
5075164 | 5075164 | 20240911233404_8CWEs | HR0024 | 2024-09-15T12:09:28.523Z | 2024-09-19T12:21:08.705Z |
5074999 | 5074999 | 20240911232142_ipsBg | HR0024 | 2024-09-15T12:09:17.554Z | 2024-09-19T12:21:07.988Z |
5074909 | 5074909 | 20240911231552_hXmu3 | HR0024 | 2024-09-15T12:09:13.208Z | 2024-09-19T12:21:07.910Z |
5074834 | 5074834 | 20240911230814_P4OYB | HR0024 | 2024-09-15T12:09:02.431Z | 2024-09-19T12:21:07.825Z |
5074771 | 5074771 | 20240911230209_8vqLJ | HR0024 | 2024-09-15T12:08:52.346Z | 2024-09-19T12:21:07.745Z |
5074495 | 5074495 | 20240911224152_RKjVs | HR0024 | 2024-09-15T12:08:34.567Z | 2024-09-19T12:21:07.366Z |
5074354 | 5074354 | 20240911223338_ZRruD | HR0024 | 2024-09-15T12:08:26.465Z | 2024-09-19T12:21:07.142Z |
5074312 | 5074312 | 20240911222915_5DQRM | HR0024 | 2024-09-15T12:08:22.109Z | 2024-09-19T12:21:07.046Z |
5074308 | 5074308 | 20240911222857_PLUVC | HR0024 | 2024-09-15T12:08:20.637Z | 2024-09-19T12:21:07.042Z |
5074219 | 5074219 | 20240911222542_qHTPe | HR0024 | 2024-09-15T12:08:11.472Z | 2024-09-19T12:21:07.013Z |
5073835 | 5073835 | 20240911214745_plT7j | HR0024 | 2024-09-15T12:07:39.933Z | 2024-09-19T12:21:06.282Z |
5073351 | 5073351 | 20240911211511_3MnrF | HR0024 | 2024-09-15T12:07:04.555Z | 2024-09-19T12:21:05.687Z |
5073250 | 5073250 | 20240911211036_cRwhP | HR0024 | 2024-09-15T12:06:59.140Z | 2024-09-19T12:21:05.380Z |
5073029 | 5073029 | 20240911205307_wx9hr | HR0024 | 2024-09-15T12:06:29.295Z | 2024-09-19T12:21:05.086Z |
5072682 | 5072682 | 20240911203646_IldpE | HR0024 | 2024-09-15T12:06:00.902Z | 2024-09-19T12:21:04.636Z |
5072672 | 5072672 | 20240911203615_IsXwa | HR0024 | 2024-09-15T12:05:59.878Z | 2024-09-19T12:21:04.601Z |
5072537 | 5072537 | 20240911202154_g57lI | HR0024 | 2024-09-15T12:05:35.639Z | 2024-09-19T12:21:04.386Z |
5072515 | 5072515 | 20240911202010_6bDSn | HR0024 | 2024-09-15T12:05:33.341Z | 2024-09-19T12:21:04.319Z |
5072428 | 5072428 | 20240911200837_xdS5n | HR0024 | 2024-09-15T12:05:21.814Z | 2024-09-19T12:21:04.167Z |
5072392 | 5072392 | 20240911200309_AnsaW | HR0024 | 2024-09-15T12:05:17.825Z | 2024-09-19T12:21:04.057Z |
5071956 | 5071956 | 20240911191046_sfixq | HR0024 | 2024-09-15T12:04:07.683Z | 2024-09-19T12:21:03.116Z |
5071944 | 5071944 | 20240911190847_qOCue | HR0024 | 2024-09-15T12:04:05.576Z | 2024-09-19T12:21:03.093Z |
5071941 | 5071941 | 20240911190847_CeCU7 | HR0024 | 2024-09-15T12:04:05.156Z | 2024-09-19T12:21:03.086Z |
5071886 | 5071886 | 20240911184828_Knpil | HR0024 | 2024-09-15T12:03:56.083Z | 2024-09-19T12:21:02.947Z |
5071759 | 5071759 | 20240911181113_nrwqC | HR0024 | 2024-09-15T12:03:26.744Z | 2024-09-19T12:21:02.667Z |
5060525 | 5060525 | 20240910203529_12yUv | HR0024 | 2024-09-14T12:08:57.204Z | 2024-09-19T12:21:32.493Z |
5060242 | 5060242 | 20240910201021_D4926 | HR0024 | 2024-09-14T12:08:31.912Z | 2024-09-19T12:21:32.011Z |
5059857 | 5059857 | 20240910190601_QtD5k | HR0024 | 2024-09-14T12:07:26.549Z | 2024-09-19T12:21:31.332Z |
5059663 | 5059663 | 20240910182717_gJbyU | HR0024 | 2024-09-14T12:06:42.508Z | 2024-09-19T12:21:31.027Z |
5059656 | 5059656 | 20240910182611_mqsET | HR0024 | 2024-09-14T12:06:41.284Z | 2024-09-19T12:21:31.013Z |
5054501 | 5054501 | 20240908030251_4mf4g | HR0024 | 2024-09-13T12:16:44.853Z | 2024-09-16T12:21:15.760Z |
5054401 | 5054401 | 20240908024638_JmeUz | HR0024 | 2024-09-13T12:16:40.168Z | 2024-09-16T12:21:15.455Z |
5054340 | 5054340 | 20240908024126_rIplK | HR0024 | 2024-09-13T12:16:38.729Z | 2024-09-16T12:21:15.150Z |
5054334 | 5054334 | 20240908024101_DAhCn | HR0024 | 2024-09-13T12:16:38.628Z | 2024-09-16T12:21:15.102Z |
5054244 | 5054244 | 20240908023156_pQ64r | HR0024 | 2024-09-13T12:16:35.343Z | 2024-09-16T12:21:14.671Z |
5054207 | 5054207 | 20240908022645_3BxQF | HR0024 | 2024-09-13T12:16:33.918Z | 2024-09-16T12:21:14.375Z |
5054181 | 5054181 | 20240908022229_NJPMF | HR0024 | 2024-09-13T12:16:32.613Z | 2024-09-16T12:21:14.217Z |
5054150 | 5054150 | 20240908021626_QE6jS | HR0024 | 2024-09-13T12:16:31.408Z | 2024-09-16T12:21:14.146Z |
5054078 | 5054078 | 20240908020703_vCRpy | HR0024 | 2024-09-13T12:16:29.028Z | 2024-09-16T12:21:13.886Z |
5054054 | 5054054 | 20240908020434_PJMNy | HR0024 | 2024-09-13T12:16:27.617Z | 2024-09-16T12:21:13.846Z |
5054043 | 5054043 | 20240908020324_LVG9P | HR0024 | 2024-09-13T12:16:27.249Z | 2024-09-16T12:21:13.814Z |
5053988 | 5053988 | 20240908015753_Tu0S2 | HR0024 | 2024-09-13T12:16:25.308Z | 2024-09-16T12:21:13.444Z |
5053985 | 5053985 | 20240908015750_5KSWp | HR0024 | 2024-09-13T12:16:25.250Z | 2024-09-16T12:21:13.436Z |
5053957 | 5053957 | 20240908015606_VO2h8 | HR0024 | 2024-09-13T12:16:24.407Z | 2024-09-16T12:21:13.385Z |
5053938 | 5053938 | 20240908015132_irLqm | HR0024 | 2024-09-13T12:16:23.276Z | 2024-09-16T12:21:13.347Z |
5053901 | 5053901 | 20240908014607_Th08w | HR0024 | 2024-09-13T12:16:21.258Z | 2024-09-16T12:21:13.105Z |
5053896 | 5053896 | 20240908014544_aN3h4 | HR0024 | 2024-09-13T12:16:21.126Z | 2024-09-16T12:21:13.079Z |
5053879 | 5053879 | 20240908014425_i6x8r | HR0024 | 2024-09-13T12:16:20.634Z | 2024-09-16T12:21:12.974Z |
5053810 | 5053810 | 20240908013338_1nxF9 | HR0024 | 2024-09-13T12:16:17.939Z | 2024-09-16T12:21:12.796Z |
5053794 | 5053794 | 20240908013143_WRbCz | HR0024 | 2024-09-13T12:16:17.682Z | 2024-09-16T12:21:12.783Z |
5053743 | 5053743 | 20240908012300_L9vVt | HR0024 | 2024-09-13T12:16:16.199Z | 2024-09-16T12:21:12.627Z |
5053738 | 5053738 | 20240908012245_yWd6L | HR0024 | 2024-09-13T12:16:15.999Z | 2024-09-16T12:21:12.622Z |
5053694 | 5053694 | 20240908011754_PIkp5 | HR0024 | 2024-09-13T12:16:13.585Z | 2024-09-16T12:21:12.445Z |
5053670 | 5053670 | 20240908011357_UcapY | HR0024 | 2024-09-13T12:16:13.055Z | 2024-09-16T12:21:12.371Z |
5053644 | 5053644 | 20240908011131_ljzbS | HR0024 | 2024-09-13T12:16:11.285Z | 2024-09-16T12:21:12.240Z |
5053641 | 5053641 | 20240908011120_rZrak | HR0024 | 2024-09-13T12:16:11.185Z | 2024-09-16T12:21:12.221Z |
5053635 | 5053635 | 20240908011022_M6Eqs | HR0024 | 2024-09-13T12:16:10.989Z | 2024-09-16T12:21:12.204Z |
5053568 | 5053568 | 20240908005725_GBGI3 | HR0024 | 2024-09-13T12:16:08.650Z | 2024-09-16T12:21:11.924Z |
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);