participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "HR0025" 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 |
---|---|---|---|---|---|
5592391 | 5592391 | 20241123031753_3Yked | HR0025 | 2024-11-24T14:20:59.097Z | 2024-11-24T14:21:11.766Z |
5592301 | 5592301 | 20241123025859_IW0KM | HR0025 | 2024-11-24T14:20:52.523Z | 2024-11-24T14:21:11.741Z |
5592279 | 5592279 | 20241123025232_0ON4U | HR0025 | 2024-11-24T14:20:51.339Z | 2024-11-24T14:21:11.735Z |
5592255 | 5592255 | 20241123024627_4vFo8 | HR0025 | 2024-11-24T14:20:50.122Z | 2024-11-24T14:21:11.727Z |
5592062 | 5592062 | 20241123020608_Er61L | HR0025 | 2024-11-24T14:20:36.339Z | 2024-11-24T14:21:11.673Z |
5592004 | 5592004 | 20241123015205_U6cMm | HR0025 | 2024-11-24T14:20:32.782Z | 2024-11-24T14:21:11.657Z |
5591974 | 5591974 | 20241123014613_cEDuC | HR0025 | 2024-11-24T14:20:30.498Z | 2024-11-24T14:21:11.647Z |
5591972 | 5591972 | 20241123014513_osH8F | HR0025 | 2024-11-24T14:20:30.458Z | 2024-11-24T14:21:11.646Z |
5591893 | 5591893 | 20241123012440_9LsBv | HR0025 | 2024-11-24T14:20:23.947Z | 2024-11-24T14:21:11.624Z |
5591663 | 5591663 | 20241123002434_OTFV6 | HR0025 | 2024-11-24T14:20:09.275Z | 2024-11-24T14:21:11.556Z |
5591499 | 5591499 | 20241122232906_JdZFH | HR0025 | 2024-11-24T14:19:56.010Z | 2024-11-24T14:21:11.507Z |
5591429 | 5591429 | 20241122230818_ZncQh | HR0025 | 2024-11-24T14:19:51.235Z | 2024-11-24T14:21:11.484Z |
5591156 | 5591156 | 20241122214022_sAZQ3 | HR0025 | 2024-11-24T14:19:30.921Z | 2024-11-24T14:21:11.408Z |
5584466 | 5584466 | 20241123044241_FCerr | HR0025 | 2024-11-24T14:01:09.680Z | 2024-11-24T14:01:09.680Z |
5584369 | 5584369 | 20241123042419_CM6Ih | HR0025 | 2024-11-24T14:00:50.857Z | 2024-11-24T14:00:50.857Z |
5584278 | 5584278 | 20241123040732_Jn5ad | HR0025 | 2024-11-24T14:00:26.789Z | 2024-11-24T14:00:26.789Z |
5584244 | 5584244 | 20241123040147_zAReN | HR0025 | 2024-11-24T14:00:21.603Z | 2024-11-24T14:00:21.603Z |
5584201 | 5584201 | 20241123035054_pyEt4 | HR0025 | 2024-11-24T14:00:09.132Z | 2024-11-24T14:00:09.132Z |
5580147 | 5580147 | 20241122000659_O3629 | HR0025 | 2024-11-23T14:19:07.659Z | 2024-11-24T14:22:27.471Z |
5572316 | 5572316 | 20241121020900_YN0lx | HR0025 | 2024-11-22T14:18:15.250Z | 2024-11-24T14:23:53.067Z |
5572282 | 5572282 | 20241121020306_2ap03 | HR0025 | 2024-11-22T14:18:10.965Z | 2024-11-24T14:23:52.817Z |
5572262 | 5572262 | 20241121020039_sA6S1 | HR0025 | 2024-11-22T14:18:08.784Z | 2024-11-24T14:23:52.691Z |
5571914 | 5571914 | 20241121010653_0pv2c | HR0025 | 2024-11-22T14:17:46.624Z | 2024-11-24T14:23:48.322Z |
5571394 | 5571394 | 20241120233648_Ktixg | HR0025 | 2024-11-22T14:17:01.045Z | 2024-11-24T14:23:43.847Z |
5565623 | 5565623 | 20241121042655_8QFrj | HR0025 | 2024-11-22T14:00:26.418Z | 2024-11-24T14:21:15.760Z |
5565595 | 5565595 | 20241121042431_DNm8O | HR0025 | 2024-11-22T14:00:22.760Z | 2024-11-24T14:21:14.938Z |
5549232 | 5549232 | 20241117035751_HznSq | HR0025 | 2024-11-18T14:11:19.963Z | 2024-11-24T14:25:35.605Z |
5549118 | 5549118 | 20241117031338_rFwwA | HR0025 | 2024-11-18T14:10:59.813Z | 2024-11-24T14:25:35.063Z |
5549076 | 5549076 | 20241117025849_4EGPE | HR0025 | 2024-11-18T14:10:49.911Z | 2024-11-24T14:25:34.909Z |
5548896 | 5548896 | 20241117021019_aHZcs | HR0025 | 2024-11-18T14:10:24.434Z | 2024-11-24T14:25:33.789Z |
5545257 | 5545257 | 20241116032552_N1wIE | HR0025 | 2024-11-17T14:04:20.272Z | 2024-11-24T14:25:42.913Z |
5545223 | 5545223 | 20241116025947_d4xmW | HR0025 | 2024-11-17T14:04:11.746Z | 2024-11-24T14:25:42.798Z |
5510350 | 5510350 | 20241109022505_h9L3P | HR0025 | 2024-11-10T14:15:04.137Z | 2024-11-17T14:23:56.430Z |
5510059 | 5510059 | 20241109013802_3Z0nz | HR0025 | 2024-11-10T14:14:31.722Z | 2024-11-17T14:23:52.496Z |
5510046 | 5510046 | 20241109013427_9mrPX | HR0025 | 2024-11-10T14:14:30.491Z | 2024-11-17T14:23:52.353Z |
5509997 | 5509997 | 20241109012503_mCJ52 | HR0025 | 2024-11-10T14:14:25.582Z | 2024-11-17T14:23:51.689Z |
5509823 | 5509823 | 20241109004651_1YdM0 | HR0025 | 2024-11-10T14:14:04.064Z | 2024-11-17T14:23:49.569Z |
5509743 | 5509743 | 20241109002552_MVvX4 | HR0025 | 2024-11-10T14:13:55.775Z | 2024-11-17T14:23:48.647Z |
5509551 | 5509551 | 20241108234408_WdMTS | HR0025 | 2024-11-10T14:13:34.255Z | 2024-11-17T14:23:46.768Z |
5509341 | 5509341 | 20241108225349_dYGRG | HR0025 | 2024-11-10T14:13:13.582Z | 2024-11-17T14:23:43.237Z |
5508688 | 5508688 | 20241108174533_Youa3 | HR0025 | 2024-11-10T14:11:12.062Z | 2024-11-17T14:23:29.176Z |
5505248 | 5505248 | 20241108041557_dPUkT | HR0025 | 2024-11-09T14:15:59.036Z | 2024-11-16T14:28:28.676Z |
5505186 | 5505186 | 20241108040431_9DLhu | HR0025 | 2024-11-09T14:15:54.098Z | 2024-11-16T14:28:28.420Z |
5505042 | 5505042 | 20241108034445_24Sey | HR0025 | 2024-11-09T14:15:38.224Z | 2024-11-16T14:28:25.850Z |
5504731 | 5504731 | 20241108024811_jG13L | HR0025 | 2024-11-09T14:15:07.749Z | 2024-11-16T14:28:22.988Z |
5504651 | 5504651 | 20241108023510_ubUew | HR0025 | 2024-11-09T14:15:01.167Z | 2024-11-16T14:28:22.020Z |
5504615 | 5504615 | 20241108022418_vGj2L | HR0025 | 2024-11-09T14:14:57.020Z | 2024-11-16T14:28:21.687Z |
5504487 | 5504487 | 20241108020505_GM9jQ | HR0025 | 2024-11-09T14:14:44.476Z | 2024-11-16T14:28:20.571Z |
5504407 | 5504407 | 20241108015428_vq0nb | HR0025 | 2024-11-09T14:14:34.195Z | 2024-11-16T14:28:19.634Z |
5504351 | 5504351 | 20241108014526_33U76 | HR0025 | 2024-11-09T14:14:28.428Z | 2024-11-16T14:28:19.311Z |
5504059 | 5504059 | 20241108004634_sA5XN | HR0025 | 2024-11-09T14:14:01.403Z | 2024-11-16T14:28:15.431Z |
5504051 | 5504051 | 20241108004532_NoLTM | HR0025 | 2024-11-09T14:14:00.670Z | 2024-11-16T14:28:15.411Z |
5503543 | 5503543 | 20241107224549_Fz32k | HR0025 | 2024-11-09T14:13:16.644Z | 2024-11-16T14:28:08.726Z |
5503317 | 5503317 | 20241107213629_RIvv6 | HR0025 | 2024-11-09T14:12:48.153Z | 2024-11-16T14:28:05.851Z |
5503214 | 5503214 | 20241107205930_qZp0z | HR0025 | 2024-11-09T14:12:35.018Z | 2024-11-16T14:28:04.510Z |
5501917 | 5501917 | 20241107163847_k3x7x | HR0025 | 2024-11-09T14:10:45.441Z | 2024-11-16T14:27:49.081Z |
5497578 | 5497578 | 20241107040246_X9JIv | HR0025 | 2024-11-08T14:13:59.398Z | 2024-11-15T14:25:04.763Z |
5497562 | 5497562 | 20241107040117_R6y0d | HR0025 | 2024-11-08T14:13:58.766Z | 2024-11-15T14:25:04.731Z |
5497426 | 5497426 | 20241107033724_R2dnz | HR0025 | 2024-11-08T14:13:45.464Z | 2024-11-15T14:25:03.610Z |
5497367 | 5497367 | 20241107032837_IqoJR | HR0025 | 2024-11-08T14:13:38.421Z | 2024-11-15T14:25:03.202Z |
5497355 | 5497355 | 20241107032739_TdS3p | HR0025 | 2024-11-08T14:13:37.600Z | 2024-11-15T14:25:03.127Z |
5497349 | 5497349 | 20241107032627_Mvrs1 | HR0025 | 2024-11-08T14:13:36.602Z | 2024-11-15T14:25:03.040Z |
5497252 | 5497252 | 20241107030603_jSP3y | HR0025 | 2024-11-08T14:13:26.663Z | 2024-11-15T14:25:02.303Z |
5497233 | 5497233 | 20241107030121_nX2Js | HR0025 | 2024-11-08T14:13:25.330Z | 2024-11-15T14:25:02.201Z |
5497229 | 5497229 | 20241107030038_Vij2n | HR0025 | 2024-11-08T14:13:24.923Z | 2024-11-15T14:25:02.181Z |
5497213 | 5497213 | 20241107025807_s2fNi | HR0025 | 2024-11-08T14:13:22.299Z | 2024-11-15T14:25:02.097Z |
5497100 | 5497100 | 20241107024222_Ta163 | HR0025 | 2024-11-08T14:13:10.139Z | 2024-11-15T14:25:01.749Z |
5497092 | 5497092 | 20241107024130_Ry3Ke | HR0025 | 2024-11-08T14:13:09.625Z | 2024-11-15T14:25:01.712Z |
5497090 | 5497090 | 20241107024026_VG7fL | HR0025 | 2024-11-08T14:13:09.498Z | 2024-11-15T14:25:01.709Z |
5496868 | 5496868 | 20241107020152_9ye3e | HR0025 | 2024-11-08T14:12:55.939Z | 2024-11-15T14:25:00.636Z |
5496663 | 5496663 | 20241107011154_qGtcd | HR0025 | 2024-11-08T14:12:38.453Z | 2024-11-15T14:24:58.936Z |
5496569 | 5496569 | 20241107005502_JhjJx | HR0025 | 2024-11-08T14:12:26.193Z | 2024-11-15T14:24:58.516Z |
5496477 | 5496477 | 20241107003305_Gf5Aa | HR0025 | 2024-11-08T14:12:14.362Z | 2024-11-15T14:24:57.919Z |
5496319 | 5496319 | 20241106235458_cyxZK | HR0025 | 2024-11-08T14:11:58.032Z | 2024-11-15T14:24:56.828Z |
5496303 | 5496303 | 20241106235134_YtDzD | HR0025 | 2024-11-08T14:11:56.204Z | 2024-11-15T14:24:56.587Z |
5496298 | 5496298 | 20241106234942_qAM5Y | HR0025 | 2024-11-08T14:11:55.665Z | 2024-11-15T14:24:56.582Z |
5496292 | 5496292 | 20241106234820_BFSoY | HR0025 | 2024-11-08T14:11:54.975Z | 2024-11-15T14:24:56.509Z |
5496254 | 5496254 | 20241106234010_M6NPu | HR0025 | 2024-11-08T14:11:51.674Z | 2024-11-15T14:24:56.359Z |
5495720 | 5495720 | 20241106211157_OxYUi | HR0025 | 2024-11-08T14:10:41.499Z | 2024-11-15T14:24:52.559Z |
5495670 | 5495670 | 20241106205921_61sRH | HR0025 | 2024-11-08T14:10:35.251Z | 2024-11-15T14:24:52.286Z |
5495184 | 5495184 | 20241106185428_4JH69 | HR0025 | 2024-11-08T14:09:33.288Z | 2024-11-15T14:24:47.129Z |
5491678 | 5491678 | 20241106042637_YwdGZ | HR0025 | 2024-11-07T14:16:43.901Z | 2024-11-14T14:23:26.412Z |
5491667 | 5491667 | 20241106041940_VtKc5 | HR0025 | 2024-11-07T14:16:41.597Z | 2024-11-14T14:23:26.393Z |
5491615 | 5491615 | 20241106040259_3St1B | HR0025 | 2024-11-07T14:16:30.868Z | 2024-11-14T14:23:26.318Z |
5491342 | 5491342 | 20241106030047_WQk2F | HR0025 | 2024-11-07T14:15:54.822Z | 2024-11-14T14:23:25.249Z |
5490685 | 5490685 | 20241106000913_PXFB0 | HR0025 | 2024-11-07T14:14:31.330Z | 2024-11-14T14:23:21.209Z |
5490384 | 5490384 | 20241105223047_hIsLM | HR0025 | 2024-11-07T14:13:57.563Z | 2024-11-14T14:23:19.280Z |
5489984 | 5489984 | 20241105203833_2U389 | HR0025 | 2024-11-07T14:12:59.532Z | 2024-11-14T14:23:17.019Z |
5485215 | 5485215 | 20241105042405_yxDgs | HR0025 | 2024-11-06T14:17:54.599Z | 2024-11-13T14:27:41.001Z |
5485172 | 5485172 | 20241105041417_5lfT5 | HR0025 | 2024-11-06T14:17:51.489Z | 2024-11-13T14:27:40.910Z |
5485144 | 5485144 | 20241105040957_csrUN | HR0025 | 2024-11-06T14:17:49.796Z | 2024-11-13T14:27:40.833Z |
5484904 | 5484904 | 20241105034006_J37iR | HR0025 | 2024-11-06T14:17:27.901Z | 2024-11-13T14:27:40.061Z |
5484784 | 5484784 | 20241105033002_BvZwP | HR0025 | 2024-11-06T14:17:16.644Z | 2024-11-13T14:27:39.845Z |
5484782 | 5484782 | 20241105032916_Dx3uj | HR0025 | 2024-11-06T14:17:16.414Z | 2024-11-13T14:27:39.844Z |
5484520 | 5484520 | 20241105030028_v7sRr | HR0025 | 2024-11-06T14:16:59.465Z | 2024-11-13T14:27:38.505Z |
5484380 | 5484380 | 20241105024123_38a15 | HR0025 | 2024-11-06T14:16:51.565Z | 2024-11-13T14:27:37.814Z |
5484344 | 5484344 | 20241105023720_LWVpi | HR0025 | 2024-11-06T14:16:49.797Z | 2024-11-13T14:27:37.774Z |
5484270 | 5484270 | 20241105022935_6Yk8h | HR0025 | 2024-11-06T14:16:41.946Z | 2024-11-13T14:27:37.608Z |
5484208 | 5484208 | 20241105022110_Gm2Qp | HR0025 | 2024-11-06T14:16:32.174Z | 2024-11-13T14:27:37.528Z |
5483906 | 5483906 | 20241105014317_Y3iqR | HR0025 | 2024-11-06T14:15:52.291Z | 2024-11-13T14:27:37.006Z |
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);