participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
706 rows where station_code = "HR002L" 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 |
---|---|---|---|---|---|
5132159 | 5132159 | 20240915234701_gJRb1 | HR002L | 2024-09-19T12:15:53.526Z | 2024-09-19T12:15:53.526Z |
5132075 | 5132075 | 20240915230321_3e2bT | HR002L | 2024-09-19T12:15:48.636Z | 2024-09-19T12:15:48.636Z |
5131698 | 5131698 | 20240915205020_MAbm6 | HR002L | 2024-09-19T12:15:16.567Z | 2024-09-19T12:15:16.567Z |
5093200 | 5093200 | 20240912031501_7F5pu | HR002L | 2024-09-16T12:14:13.218Z | 2024-09-19T12:21:15.008Z |
5091648 | 5091648 | 20240912021653_ygBiV | HR002L | 2024-09-16T12:13:15.945Z | 2024-09-19T12:21:13.281Z |
5091053 | 5091053 | 20240912015625_i2Kw9 | HR002L | 2024-09-16T12:12:47.378Z | 2024-09-19T12:21:12.485Z |
5090952 | 5090952 | 20240912015424_iKUds | HR002L | 2024-09-16T12:12:45.574Z | 2024-09-19T12:21:12.427Z |
5090904 | 5090904 | 20240912015006_rd2kM | HR002L | 2024-09-16T12:12:40.991Z | 2024-09-19T12:21:12.326Z |
5079453 | 5079453 | 20240911025652_9BEj3 | HR002L | 2024-09-15T12:16:21.254Z | 2024-09-19T12:21:42.280Z |
5079191 | 5079191 | 20240911024042_uJc49 | HR002L | 2024-09-15T12:16:09.920Z | 2024-09-19T12:21:41.251Z |
5079104 | 5079104 | 20240911023321_Ot2YU | HR002L | 2024-09-15T12:16:05.230Z | 2024-09-19T12:21:41.119Z |
5078897 | 5078897 | 20240911021940_J5hKQ | HR002L | 2024-09-15T12:15:54.973Z | 2024-09-19T12:21:40.804Z |
5078876 | 5078876 | 20240911021833_eyLVJ | HR002L | 2024-09-15T12:15:54.418Z | 2024-09-19T12:21:40.779Z |
5078559 | 5078559 | 20240911020334_v3a26 | HR002L | 2024-09-15T12:15:43.342Z | 2024-09-19T12:21:40.505Z |
5078509 | 5078509 | 20240911020200_77r3B | HR002L | 2024-09-15T12:15:40.929Z | 2024-09-19T12:21:40.453Z |
5078093 | 5078093 | 20240911013902_r4wb2 | HR002L | 2024-09-15T12:15:19.668Z | 2024-09-19T12:21:39.981Z |
5075963 | 5075963 | 20240910230201_tLwQz | HR002L | 2024-09-15T12:13:13.417Z | 2024-09-19T12:21:36.259Z |
5075660 | 5075660 | 20240911235938_UW7ut | HR002L | 2024-09-15T12:10:07.097Z | 2024-09-19T12:21:09.410Z |
5075070 | 5075070 | 20240911232716_2kfr9 | HR002L | 2024-09-15T12:09:22.744Z | 2024-09-19T12:21:08.241Z |
5071796 | 5071796 | 20240911182258_mpC1r | HR002L | 2024-09-15T12:03:36.992Z | 2024-09-19T12:21:02.752Z |
5065165 | 5065165 | 20240910031633_CWY22 | HR002L | 2024-09-14T12:16:31.728Z | 2024-09-18T12:15:18.579Z |
5064926 | 5064926 | 20240910023316_RgOYu | HR002L | 2024-09-14T12:16:10.264Z | 2024-09-18T12:15:17.795Z |
5064907 | 5064907 | 20240910022725_aLlb2 | HR002L | 2024-09-14T12:16:09.305Z | 2024-09-18T12:15:17.734Z |
5064213 | 5064213 | 20240910002408_vs3de | HR002L | 2024-09-14T12:15:04.586Z | 2024-09-18T12:15:15.815Z |
5060744 | 5060744 | 20240910210118_4H2lg | HR002L | 2024-09-14T12:09:27.780Z | 2024-09-19T12:21:33.539Z |
5060324 | 5060324 | 20240910201828_p3Ul8 | HR002L | 2024-09-14T12:08:38.674Z | 2024-09-19T12:21:32.179Z |
5054561 | 5054561 | 20240908031022_RspQK | HR002L | 2024-09-13T12:16:46.881Z | 2024-09-16T12:21:16.053Z |
5054167 | 5054167 | 20240908021838_Yt037 | HR002L | 2024-09-13T12:16:32.014Z | 2024-09-16T12:21:14.181Z |
5053937 | 5053937 | 20240908015113_7hbHO | HR002L | 2024-09-13T12:16:23.241Z | 2024-09-16T12:21:13.344Z |
5053283 | 5053283 | 20240908000350_rmi7K | HR002L | 2024-09-13T12:15:56.732Z | 2024-09-16T12:21:10.218Z |
5053216 | 5053216 | 20240907235153_ilPFN | HR002L | 2024-09-13T12:15:53.698Z | 2024-09-16T12:21:10.014Z |
5053145 | 5053145 | 20240907233523_n3dfT | HR002L | 2024-09-13T12:15:49.951Z | 2024-09-16T12:21:09.743Z |
5052854 | 5052854 | 20240907222329_vfHy8 | HR002L | 2024-09-13T12:15:32.624Z | 2024-09-16T12:21:08.259Z |
5033634 | 5033634 | 20240907032136_S3s8S | HR002L | 2024-09-12T12:09:46.474Z | 2024-09-15T12:21:31.305Z |
5033611 | 5033611 | 20240907031722_LtSAg | HR002L | 2024-09-12T12:09:44.824Z | 2024-09-15T12:21:30.701Z |
5033491 | 5033491 | 20240907030253_0mB2Z | HR002L | 2024-09-12T12:09:34.879Z | 2024-09-15T12:21:30.233Z |
5033132 | 5033132 | 20240907022746_nbUAo | HR002L | 2024-09-12T12:08:51.707Z | 2024-09-15T12:21:29.036Z |
5033063 | 5033063 | 20240907022135_99DOF | HR002L | 2024-09-12T12:08:46.915Z | 2024-09-15T12:21:28.954Z |
5033012 | 5033012 | 20240907021321_bZ6Ce | HR002L | 2024-09-12T12:08:43.037Z | 2024-09-15T12:21:28.778Z |
5032698 | 5032698 | 20240907013404_K80oV | HR002L | 2024-09-12T12:07:52.312Z | 2024-09-15T12:21:27.482Z |
5032694 | 5032694 | 20240907013346_NcJze | HR002L | 2024-09-12T12:07:52.108Z | 2024-09-15T12:21:27.479Z |
5032579 | 5032579 | 20240907011758_wOI8p | HR002L | 2024-09-12T12:07:41.737Z | 2024-09-15T12:21:26.822Z |
5032344 | 5032344 | 20240907004906_AG1Sd | HR002L | 2024-09-12T12:07:09.034Z | 2024-09-15T12:21:26.198Z |
5031988 | 5031988 | 20240906234956_3bZS3 | HR002L | 2024-09-12T12:06:21.144Z | 2024-09-15T12:21:24.939Z |
5031809 | 5031809 | 20240906232302_xxX1b | HR002L | 2024-09-12T12:05:50.867Z | 2024-09-15T12:21:24.344Z |
5026024 | 5026024 | 20240905020243_2n7oS | HR002L | 2024-09-11T12:11:46.880Z | 2024-09-13T12:19:56.605Z |
5026007 | 5026007 | 20240905015708_DG58s | HR002L | 2024-09-11T12:11:43.246Z | 2024-09-13T12:19:56.518Z |
5025660 | 5025660 | 20240905005142_d38s1 | HR002L | 2024-09-11T12:10:43.814Z | 2024-09-13T12:19:55.014Z |
5020461 | 5020461 | 20240905020243_vb7a3 | HR002L | 2024-09-10T12:14:30.695Z | 2024-09-10T12:16:55.155Z |
5020444 | 5020444 | 20240905015708_iQr4L | HR002L | 2024-09-10T12:14:28.415Z | 2024-09-10T12:16:55.151Z |
5020079 | 5020079 | 20240905005142_9BDXP | HR002L | 2024-09-10T12:13:54.083Z | 2024-09-10T12:16:55.064Z |
5010419 | 5010419 | 20240904030403_raDwa | HR002L | 2024-09-09T12:08:45.615Z | 2024-09-12T12:19:27.381Z |
5010347 | 5010347 | 20240904025555_2FtGJ | HR002L | 2024-09-09T12:08:41.633Z | 2024-09-12T12:19:26.947Z |
5010170 | 5010170 | 20240904024018_l896b | HR002L | 2024-09-09T12:08:25.907Z | 2024-09-12T12:19:26.149Z |
5010066 | 5010066 | 20240904023037_KMGTJ | HR002L | 2024-09-09T12:08:21.327Z | 2024-09-12T12:19:25.758Z |
5009996 | 5009996 | 20240904022343_aKe19 | HR002L | 2024-09-09T12:08:17.345Z | 2024-09-12T12:19:25.335Z |
5009755 | 5009755 | 20240904015712_MNARO | HR002L | 2024-09-09T12:07:59.952Z | 2024-09-12T12:19:24.243Z |
5009291 | 5009291 | 20240904010833_cr26c | HR002L | 2024-09-09T12:07:33.594Z | 2024-09-12T12:19:22.276Z |
5009246 | 5009246 | 20240904010632_g0lcE | HR002L | 2024-09-09T12:07:32.333Z | 2024-09-12T12:19:22.113Z |
5007699 | 5007699 | 20240903220402_XIkLi | HR002L | 2024-09-09T12:06:02.739Z | 2024-09-12T12:19:14.476Z |
5000843 | 5000843 | 20240902025440_Fvgvr | HR002L | 2024-09-08T12:15:54.974Z | 2024-09-10T12:19:29.950Z |
5000581 | 5000581 | 20240902022543_THCea | HR002L | 2024-09-08T12:15:29.776Z | 2024-09-10T12:19:28.202Z |
5000428 | 5000428 | 20240902021214_3Rotx | HR002L | 2024-09-08T12:15:24.153Z | 2024-09-10T12:19:27.045Z |
5000022 | 5000022 | 20240902012507_7WGtX | HR002L | 2024-09-08T12:14:56.700Z | 2024-09-10T12:19:24.257Z |
4999931 | 4999931 | 20240902011239_brPF1 | HR002L | 2024-09-08T12:14:52.286Z | 2024-09-10T12:19:23.972Z |
4997717 | 4997717 | 20240903011308_ARnfN | HR002L | 2024-09-08T12:06:40.209Z | 2024-09-11T12:21:07.949Z |
4997444 | 4997444 | 20240903001654_Vo2Zp | HR002L | 2024-09-08T12:06:18.424Z | 2024-09-11T12:21:04.571Z |
4996969 | 4996969 | 20240902221236_kXcXo | HR002L | 2024-09-08T12:05:30.156Z | 2024-09-11T12:20:59.489Z |
4996899 | 4996899 | 20240902213155_En6Rm | HR002L | 2024-09-08T12:05:24.234Z | 2024-09-11T12:20:58.851Z |
4991591 | 4991591 | 20240901024918_XXF2C | HR002L | 2024-09-07T12:12:13.814Z | 2024-09-09T12:27:13.222Z |
4991259 | 4991259 | 20240901021355_rk7rq | HR002L | 2024-09-07T12:11:48.414Z | 2024-09-09T12:27:03.664Z |
4990638 | 4990638 | 20240901004814_R4xYZ | HR002L | 2024-09-07T12:10:51.957Z | 2024-09-09T12:26:25.805Z |
4990617 | 4990617 | 20240901004535_aE807 | HR002L | 2024-09-07T12:10:50.505Z | 2024-09-09T12:26:25.209Z |
4990552 | 4990552 | 20240901003300_DjYUk | HR002L | 2024-09-07T12:10:45.961Z | 2024-09-09T12:26:23.206Z |
4990487 | 4990487 | 20240901002202_YZJUZ | HR002L | 2024-09-07T12:10:41.184Z | 2024-09-09T12:26:21.749Z |
4989228 | 4989228 | 20240901225747_ytk0v | HR002L | 2024-09-07T12:08:40.241Z | 2024-09-10T12:19:17.113Z |
4989190 | 4989190 | 20240901225225_gCS0t | HR002L | 2024-09-07T12:08:38.321Z | 2024-09-10T12:19:17.012Z |
4988969 | 4988969 | 20240901221144_UeX2x | HR002L | 2024-09-07T12:08:16.821Z | 2024-09-10T12:19:16.244Z |
4988721 | 4988721 | 20240901212437_Oguw2 | HR002L | 2024-09-07T12:07:51.515Z | 2024-09-10T12:19:15.227Z |
4988504 | 4988504 | 20240901205912_VcqF5 | HR002L | 2024-09-07T12:07:33.582Z | 2024-09-10T12:19:14.447Z |
4983348 | 4983348 | 20240812004331_OZDar | HR002L | 2024-09-06T12:15:28.104Z | 2024-09-06T12:15:28.104Z |
4983264 | 4983264 | 20240812004237_3rxDK | HR002L | 2024-09-06T12:15:23.650Z | 2024-09-06T12:15:23.650Z |
4983087 | 4983087 | 20240812004101_gpu55 | HR002L | 2024-09-06T12:15:14.774Z | 2024-09-06T12:15:14.774Z |
4983032 | 4983032 | 20240812004038_3Bf3o | HR002L | 2024-09-06T12:15:13.793Z | 2024-09-06T12:15:13.793Z |
4982643 | 4982643 | 20240812003522_PjNNm | HR002L | 2024-09-06T12:14:58.090Z | 2024-09-06T12:14:58.090Z |
4982494 | 4982494 | 20240812003416_BiuKs | HR002L | 2024-09-06T12:14:53.497Z | 2024-09-06T12:14:53.497Z |
4981388 | 4981388 | 20240812002111_bQzP2 | HR002L | 2024-09-06T12:14:30.383Z | 2024-09-06T12:14:30.383Z |
4981255 | 4981255 | 20240812001954_PTRms | HR002L | 2024-09-06T12:14:28.785Z | 2024-09-06T12:14:28.785Z |
4980767 | 4980767 | 20240812001535_bmWr2 | HR002L | 2024-09-06T12:14:15.397Z | 2024-09-06T12:14:15.397Z |
4980513 | 4980513 | 20240812001325_7wqdl | HR002L | 2024-09-06T12:14:03.624Z | 2024-09-06T12:14:03.624Z |
4980007 | 4980007 | 20240812000718_5O8MS | HR002L | 2024-09-06T12:13:42.076Z | 2024-09-06T12:13:42.076Z |
4979187 | 4979187 | 20240812000018_3qW2e | HR002L | 2024-09-06T12:13:04.672Z | 2024-09-06T12:13:04.672Z |
4978839 | 4978839 | 20240811235556_sE5MW | HR002L | 2024-09-06T12:12:43.886Z | 2024-09-06T12:12:43.886Z |
4978803 | 4978803 | 20240811235536_NTYAr | HR002L | 2024-09-06T12:12:43.157Z | 2024-09-06T12:12:43.157Z |
4978465 | 4978465 | 20240811235105_x4Tb7 | HR002L | 2024-09-06T12:12:34.369Z | 2024-09-06T12:12:34.369Z |
4978288 | 4978288 | 20240811234922_gkqFU | HR002L | 2024-09-06T12:12:31.803Z | 2024-09-06T12:12:31.803Z |
4978065 | 4978065 | 20240811234745_FaXIA | HR002L | 2024-09-06T12:12:28.838Z | 2024-09-06T12:12:28.838Z |
4977874 | 4977874 | 20240811234543_zfLDb | HR002L | 2024-09-06T12:12:25.448Z | 2024-09-06T12:12:25.448Z |
4977625 | 4977625 | 20240811234220_Cg6De | HR002L | 2024-09-06T12:12:20.865Z | 2024-09-06T12:12:20.865Z |
4977602 | 4977602 | 20240811234158_COk2q | HR002L | 2024-09-06T12:12:20.527Z | 2024-09-06T12:12:20.527Z |
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);