participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,332 rows where station_code = "HR0004" 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 |
---|---|---|---|---|---|
5064810 | 5064810 | 20240910020817_7GQ3J | HR0004 | 2024-09-14T12:16:04.147Z | 2024-09-18T12:15:17.431Z |
5063513 | 5063513 | 20240909213113_yYLCx | HR0004 | 2024-09-14T12:14:04.538Z | 2024-09-18T12:15:14.112Z |
5054613 | 5054613 | 20240908031957_vyplB | HR0004 | 2024-09-13T12:16:49.465Z | 2024-09-16T12:21:16.291Z |
5054593 | 5054593 | 20240908031601_PvQbL | HR0004 | 2024-09-13T12:16:47.768Z | 2024-09-16T12:21:16.157Z |
5054450 | 5054450 | 20240908025323_bw2JG | HR0004 | 2024-09-13T12:16:42.306Z | 2024-09-16T12:21:15.631Z |
5053965 | 5053965 | 20240908015622_gZfFU | HR0004 | 2024-09-13T12:16:24.481Z | 2024-09-16T12:21:13.400Z |
5053903 | 5053903 | 20240908014700_f5IsB | HR0004 | 2024-09-13T12:16:21.442Z | 2024-09-16T12:21:13.110Z |
5053835 | 5053835 | 20240908013739_Zx4X3 | HR0004 | 2024-09-13T12:16:19.206Z | 2024-09-16T12:21:12.881Z |
5052747 | 5052747 | 20240907215043_LLw8r | HR0004 | 2024-09-13T12:15:24.851Z | 2024-09-16T12:21:07.506Z |
5052595 | 5052595 | 20240907211150_oXdUb | HR0004 | 2024-09-13T12:15:14.880Z | 2024-09-16T12:21:06.607Z |
5026140 | 5026140 | 20240905022240_h6FJ4 | HR0004 | 2024-09-11T12:11:58.278Z | 2024-09-13T12:19:56.953Z |
5026132 | 5026132 | 20240905022219_T2cFf | HR0004 | 2024-09-11T12:11:57.849Z | 2024-09-13T12:19:56.930Z |
5026122 | 5026122 | 20240905022040_ffr0b | HR0004 | 2024-09-11T12:11:57.111Z | 2024-09-13T12:19:56.897Z |
5026072 | 5026072 | 20240905021226_jh42e | HR0004 | 2024-09-11T12:11:52.427Z | 2024-09-13T12:19:56.740Z |
5025952 | 5025952 | 20240905014615_6U6iq | HR0004 | 2024-09-11T12:11:37.191Z | 2024-09-13T12:19:56.341Z |
5010468 | 5010468 | 20240904030830_6HOjW | HR0004 | 2024-09-09T12:08:47.415Z | 2024-09-12T12:19:27.594Z |
5010051 | 5010051 | 20240904022930_wRmpi | HR0004 | 2024-09-09T12:08:20.142Z | 2024-09-12T12:19:25.676Z |
5009947 | 5009947 | 20240904022009_eTiLL | HR0004 | 2024-09-09T12:08:15.821Z | 2024-09-12T12:19:25.070Z |
5009866 | 5009866 | 20240904021000_DmeVy | HR0004 | 2024-09-09T12:08:11.144Z | 2024-09-12T12:19:24.752Z |
5009116 | 5009116 | 20240904005547_UdTF8 | HR0004 | 2024-09-09T12:07:26.085Z | 2024-09-12T12:19:21.685Z |
5008166 | 5008166 | 20240903230939_N2r6a | HR0004 | 2024-09-09T12:06:29.638Z | 2024-09-12T12:19:16.338Z |
5007483 | 5007483 | 20240903212148_VF0Y6 | HR0004 | 2024-09-09T12:05:48.550Z | 2024-09-12T12:19:13.370Z |
5007238 | 5007238 | 20240903203052_N0SrH | HR0004 | 2024-09-09T12:05:37.991Z | 2024-09-12T12:19:12.228Z |
5007227 | 5007227 | 20240903202836_lDGmi | HR0004 | 2024-09-09T12:05:37.018Z | 2024-09-12T12:19:12.189Z |
4998485 | 4998485 | 20240903030914_7ISYM | HR0004 | 2024-09-08T12:07:42.692Z | 2024-09-11T12:21:13.098Z |
4998062 | 4998062 | 20240903021027_BsgTf | HR0004 | 2024-09-08T12:07:09.992Z | 2024-09-11T12:21:10.814Z |
4998000 | 4998000 | 20240903020226_uIkI5 | HR0004 | 2024-09-08T12:07:03.306Z | 2024-09-11T12:21:10.451Z |
4997611 | 4997611 | 20240903005312_nG7QY | HR0004 | 2024-09-08T12:06:30.308Z | 2024-09-11T12:21:06.318Z |
4997309 | 4997309 | 20240902235253_eD4px | HR0004 | 2024-09-08T12:06:01.837Z | 2024-09-11T12:21:03.196Z |
4997241 | 4997241 | 20240902233603_zjXtk | HR0004 | 2024-09-08T12:05:56.523Z | 2024-09-11T12:21:02.491Z |
4997086 | 4997086 | 20240902230233_tQgT4 | HR0004 | 2024-09-08T12:05:45.361Z | 2024-09-11T12:21:01.101Z |
4996841 | 4996841 | 20240902211547_lRz92 | HR0004 | 2024-09-08T12:05:20.675Z | 2024-09-11T12:20:58.445Z |
4996720 | 4996720 | 20240902204237_32Cmr | HR0004 | 2024-09-08T12:05:12.262Z | 2024-09-11T12:20:57.510Z |
4996600 | 4996600 | 20240902201924_hAVF3 | HR0004 | 2024-09-08T12:04:59.432Z | 2024-09-11T12:20:56.454Z |
4978641 | 4978641 | 20240811235313_2HJFf | HR0004 | 2024-09-06T12:12:38.662Z | 2024-09-06T12:12:38.662Z |
4970044 | 4970044 | 20240811222014_D9h3D | HR0004 | 2024-09-05T12:09:17.375Z | 2024-09-06T12:08:18.815Z |
4969210 | 4969210 | 20240811220813_WIpK3 | HR0004 | 2024-09-05T12:08:37.817Z | 2024-09-06T12:07:45.562Z |
4967956 | 4967956 | 20240811215227_Yb32j | HR0004 | 2024-09-05T12:07:54.825Z | 2024-09-06T12:07:17.517Z |
4967309 | 4967309 | 20240811214201_rCCY6 | HR0004 | 2024-09-05T12:07:35.397Z | 2024-09-06T12:06:56.764Z |
4966332 | 4966332 | 20240811212728_SYTj0 | HR0004 | 2024-09-04T12:07:24.285Z | 2024-09-06T12:06:24.752Z |
4963669 | 4963669 | 20240811202806_DdmpC | HR0004 | 2024-09-04T12:05:50.118Z | 2024-09-06T12:04:48.493Z |
4963633 | 4963633 | 20240811202623_S2MIb | HR0004 | 2024-09-04T12:05:47.774Z | 2024-09-06T12:04:47.445Z |
4963244 | 4963244 | 20240811195141_jFSKJ | HR0004 | 2024-09-04T12:05:22.076Z | 2024-09-06T12:04:25.733Z |
4963139 | 4963139 | 20240811194623_8GV43 | HR0004 | 2024-09-04T12:05:14.872Z | 2024-09-06T12:04:19.666Z |
4953427 | 4953427 | 20240811023818_9BSq6 | HR0004 | 2024-09-03T12:17:41.030Z | 2024-09-06T12:28:26.482Z |
4952538 | 4952538 | 20240811022407_iXszs | HR0004 | 2024-09-03T12:17:00.974Z | 2024-09-06T12:28:04.584Z |
4952247 | 4952247 | 20240811021753_kWSBY | HR0004 | 2024-09-03T12:16:53.087Z | 2024-09-06T12:27:53.902Z |
4949157 | 4949157 | 20240811014619_zOLt3 | HR0004 | 2024-09-02T12:15:38.667Z | 2024-09-06T12:27:30.386Z |
4948739 | 4948739 | 20240811013941_zBfam | HR0004 | 2024-09-02T12:15:13.291Z | 2024-09-06T12:27:25.236Z |
4948298 | 4948298 | 20240811013205_suEkP | HR0004 | 2024-09-02T12:14:59.246Z | 2024-09-06T12:27:14.159Z |
4947791 | 4947791 | 20240811012456_QtfJN | HR0004 | 2024-09-02T12:14:47.666Z | 2024-09-06T12:27:02.278Z |
4947006 | 4947006 | 20240811011140_nzlu5 | HR0004 | 2024-09-02T12:14:13.936Z | 2024-09-06T12:26:42.263Z |
4946686 | 4946686 | 20240811010438_p4rca | HR0004 | 2024-09-02T12:14:03.351Z | 2024-09-06T12:26:30.486Z |
4945853 | 4945853 | 20240811005226_Dk6Mm | HR0004 | 2024-09-02T12:13:26.983Z | 2024-09-06T12:26:06.817Z |
4945162 | 4945162 | 20240811004158_W06eb | HR0004 | 2024-09-02T12:13:11.001Z | 2024-09-06T12:25:48.423Z |
4944454 | 4944454 | 20240811002936_JRn7r | HR0004 | 2024-09-02T12:12:32.491Z | 2024-09-06T12:25:23.022Z |
4942366 | 4942366 | 20240810235044_PYBWy | HR0004 | 2024-09-02T12:11:10.527Z | 2024-09-06T12:24:14.341Z |
4941295 | 4941295 | 20240810233012_VxrX1 | HR0004 | 2024-09-02T12:10:24.935Z | 2024-09-06T12:23:45.809Z |
4938892 | 4938892 | 20240810223143_3GBJJ | HR0004 | 2024-09-01T12:09:30.828Z | 2024-09-06T12:23:07.453Z |
4934995 | 4934995 | 20240810192550_Me5Nz | HR0004 | 2024-09-01T12:05:59.969Z | 2024-09-06T12:20:25.138Z |
4926216 | 4926216 | 20240810014358_aGj1y | HR0004 | 2024-08-31T12:19:32.400Z | 2024-09-02T12:27:43.044Z |
4920842 | 4920842 | 20240810003941_7nh9q | HR0004 | 2024-08-30T12:13:41.154Z | 2024-09-02T12:26:40.787Z |
4920770 | 4920770 | 20240810003850_piMr5 | HR0004 | 2024-08-30T12:13:39.556Z | 2024-09-02T12:26:39.181Z |
4918799 | 4918799 | 20240809235903_HdzHf | HR0004 | 2024-08-30T12:12:15.361Z | 2024-09-02T12:25:36.858Z |
4917683 | 4917683 | 20240809233930_N8nBJ | HR0004 | 2024-08-30T12:11:31.208Z | 2024-09-02T12:25:11.472Z |
4917558 | 4917558 | 20240809233534_rnXi0 | HR0004 | 2024-08-30T12:11:27.092Z | 2024-09-02T12:25:06.050Z |
4917401 | 4917401 | 20240809233305_llJEW | HR0004 | 2024-08-30T12:11:23.567Z | 2024-09-02T12:25:01.570Z |
4917022 | 4917022 | 20240809232749_QPfvV | HR0004 | 2024-08-30T12:11:14.319Z | 2024-09-02T12:24:49.755Z |
4912363 | 4912363 | 20240809211154_H6jyA | HR0004 | 2024-08-29T12:08:26.612Z | 2024-09-02T12:22:29.926Z |
4892284 | 4892284 | 20240809022504_5Ag9B | HR0004 | 2024-08-28T12:10:01.110Z | 2024-08-30T12:21:57.156Z |
4892269 | 4892269 | 20240809022406_rx9hA | HR0004 | 2024-08-28T12:10:00.248Z | 2024-08-30T12:21:54.150Z |
4892243 | 4892243 | 20240809022050_0qh3w | HR0004 | 2024-08-28T12:09:56.868Z | 2024-08-30T12:21:52.084Z |
4891653 | 4891653 | 20240809012440_EmZ93 | HR0004 | 2024-08-28T12:09:15.513Z | 2024-08-30T12:21:21.217Z |
4891504 | 4891504 | 20240809010726_MzK0d | HR0004 | 2024-08-28T12:09:07.061Z | 2024-08-30T12:21:16.131Z |
4891454 | 4891454 | 20240809010141_48gqv | HR0004 | 2024-08-28T12:09:04.467Z | 2024-08-30T12:21:14.644Z |
4891442 | 4891442 | 20240809010006_r76bm | HR0004 | 2024-08-28T12:09:03.724Z | 2024-08-30T12:21:14.036Z |
4882871 | 4882871 | 20240807022552_2K9mU | HR0004 | 2024-08-20T12:14:42.642Z | 2024-08-27T12:15:46.635Z |
4879455 | 4879455 | 20240807005628_g7aWX | HR0004 | 2024-08-20T12:12:52.382Z | 2024-08-27T12:14:14.023Z |
4878822 | 4878822 | 20240807003755_uAtiw | HR0004 | 2024-08-19T12:14:23.122Z | 2024-08-27T12:13:52.312Z |
4873570 | 4873570 | 20240806222446_eDy42 | HR0004 | 2024-08-19T12:10:50.920Z | 2024-08-27T12:11:15.686Z |
4872497 | 4872497 | 20240806214809_2ERwB | HR0004 | 2024-08-19T12:10:04.029Z | 2024-08-27T12:10:34.715Z |
4871808 | 4871808 | 20240806211341_yLWH5 | HR0004 | 2024-08-19T12:09:27.164Z | 2024-08-27T12:10:04.368Z |
4871612 | 4871612 | 20240806205513_Lrw3R | HR0004 | 2024-08-19T12:09:17.835Z | 2024-08-27T12:09:55.070Z |
4871370 | 4871370 | 20240806201436_jU8qe | HR0004 | 2024-08-19T12:08:52.612Z | 2024-08-27T12:09:35.916Z |
4855754 | 4855754 | 20240806005731_SPjr7 | HR0004 | 2024-08-17T12:20:26.301Z | 2024-08-19T12:26:53.749Z |
4855119 | 4855119 | 20240806002313_2Y0Bh | HR0004 | 2024-08-17T12:19:30.987Z | 2024-08-19T12:26:25.049Z |
4852102 | 4852102 | 20240805214515_a34YK | HR0004 | 2024-08-17T12:15:45.578Z | 2024-08-19T12:24:16.770Z |
4851085 | 4851085 | 20240805203248_8xM0V | HR0004 | 2024-08-17T12:14:13.092Z | 2024-08-19T12:23:41.647Z |
4831636 | 4831636 | 20240804224603_9ywao | HR0004 | 2024-08-15T12:11:59.759Z | 2024-08-17T12:30:36.021Z |
4830262 | 4830262 | 20240804212420_sQLO6 | HR0004 | 2024-08-15T12:10:14.760Z | 2024-08-17T12:29:40.349Z |
4829649 | 4829649 | 20240804202357_X9oPf | HR0004 | 2024-08-15T12:09:08.274Z | 2024-08-17T12:29:14.927Z |
4826240 | 4826240 | 20240804022940_pY3cU | HR0004 | 2024-08-14T12:20:51.874Z | 2024-08-15T12:26:12.756Z |
4826230 | 4826230 | 20240804022819_t6pvE | HR0004 | 2024-08-14T12:20:51.363Z | 2024-08-15T12:26:12.155Z |
4825979 | 4825979 | 20240804020029_jCVEh | HR0004 | 2024-08-14T12:20:36.739Z | 2024-08-15T12:26:06.328Z |
4825599 | 4825599 | 20240804012748_1A20X | HR0004 | 2024-08-14T12:20:15.126Z | 2024-08-15T12:25:55.950Z |
4825523 | 4825523 | 20240804012021_EU594 | HR0004 | 2024-08-14T12:20:12.122Z | 2024-08-15T12:25:54.327Z |
4824997 | 4824997 | 20240804003437_2RnWg | HR0004 | 2024-08-14T12:19:49.051Z | 2024-08-15T12:25:41.874Z |
4824479 | 4824479 | 20240803235613_3LJhT | HR0004 | 2024-08-14T12:19:11.083Z | 2024-08-15T12:25:28.235Z |
4824354 | 4824354 | 20240803234825_EF5xJ | HR0004 | 2024-08-14T12:19:04.180Z | 2024-08-15T12:25:24.380Z |
4823657 | 4823657 | 20240803230738_Wfz81 | HR0004 | 2024-08-14T12:18:28.243Z | 2024-08-15T12:25:06.960Z |
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);