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 |
---|---|---|---|---|---|
5505248 | 5505248 | 20241108041557_dPUkT | HR0025 | 2024-11-09T14:15:59.036Z | 2024-11-09T14:16:28.735Z |
5505186 | 5505186 | 20241108040431_9DLhu | HR0025 | 2024-11-09T14:15:54.098Z | 2024-11-09T14:16:28.721Z |
5505042 | 5505042 | 20241108034445_24Sey | HR0025 | 2024-11-09T14:15:38.224Z | 2024-11-09T14:16:28.687Z |
5504731 | 5504731 | 20241108024811_jG13L | HR0025 | 2024-11-09T14:15:07.749Z | 2024-11-09T14:16:28.612Z |
5504651 | 5504651 | 20241108023510_ubUew | HR0025 | 2024-11-09T14:15:01.167Z | 2024-11-09T14:16:28.592Z |
5504615 | 5504615 | 20241108022418_vGj2L | HR0025 | 2024-11-09T14:14:57.020Z | 2024-11-09T14:16:28.582Z |
5504487 | 5504487 | 20241108020505_GM9jQ | HR0025 | 2024-11-09T14:14:44.476Z | 2024-11-09T14:16:28.552Z |
5504407 | 5504407 | 20241108015428_vq0nb | HR0025 | 2024-11-09T14:14:34.195Z | 2024-11-09T14:16:28.528Z |
5504351 | 5504351 | 20241108014526_33U76 | HR0025 | 2024-11-09T14:14:28.428Z | 2024-11-09T14:16:28.514Z |
5504059 | 5504059 | 20241108004634_sA5XN | HR0025 | 2024-11-09T14:14:01.403Z | 2024-11-09T14:16:28.438Z |
5504051 | 5504051 | 20241108004532_NoLTM | HR0025 | 2024-11-09T14:14:00.670Z | 2024-11-09T14:16:28.437Z |
5503543 | 5503543 | 20241107224549_Fz32k | HR0025 | 2024-11-09T14:13:16.644Z | 2024-11-09T14:16:28.286Z |
5503317 | 5503317 | 20241107213629_RIvv6 | HR0025 | 2024-11-09T14:12:48.153Z | 2024-11-09T14:16:28.216Z |
5503214 | 5503214 | 20241107205930_qZp0z | HR0025 | 2024-11-09T14:12:35.018Z | 2024-11-09T14:16:28.191Z |
5501917 | 5501917 | 20241107163847_k3x7x | HR0025 | 2024-11-09T14:10:45.441Z | 2024-11-09T14:16:27.905Z |
5497578 | 5497578 | 20241107040246_X9JIv | HR0025 | 2024-11-08T14:13:59.398Z | 2024-11-09T14:18:46.418Z |
5497562 | 5497562 | 20241107040117_R6y0d | HR0025 | 2024-11-08T14:13:58.766Z | 2024-11-09T14:18:46.289Z |
5497426 | 5497426 | 20241107033724_R2dnz | HR0025 | 2024-11-08T14:13:45.464Z | 2024-11-09T14:18:42.751Z |
5497367 | 5497367 | 20241107032837_IqoJR | HR0025 | 2024-11-08T14:13:38.421Z | 2024-11-09T14:18:41.657Z |
5497355 | 5497355 | 20241107032739_TdS3p | HR0025 | 2024-11-08T14:13:37.600Z | 2024-11-09T14:18:41.500Z |
5497349 | 5497349 | 20241107032627_Mvrs1 | HR0025 | 2024-11-08T14:13:36.602Z | 2024-11-09T14:18:41.273Z |
5497252 | 5497252 | 20241107030603_jSP3y | HR0025 | 2024-11-08T14:13:26.663Z | 2024-11-09T14:18:38.936Z |
5497233 | 5497233 | 20241107030121_nX2Js | HR0025 | 2024-11-08T14:13:25.330Z | 2024-11-09T14:18:37.725Z |
5497229 | 5497229 | 20241107030038_Vij2n | HR0025 | 2024-11-08T14:13:24.923Z | 2024-11-09T14:18:37.705Z |
5497213 | 5497213 | 20241107025807_s2fNi | HR0025 | 2024-11-08T14:13:22.299Z | 2024-11-09T14:18:37.321Z |
5497100 | 5497100 | 20241107024222_Ta163 | HR0025 | 2024-11-08T14:13:10.139Z | 2024-11-09T14:18:35.534Z |
5497092 | 5497092 | 20241107024130_Ry3Ke | HR0025 | 2024-11-08T14:13:09.625Z | 2024-11-09T14:18:35.449Z |
5497090 | 5497090 | 20241107024026_VG7fL | HR0025 | 2024-11-08T14:13:09.498Z | 2024-11-09T14:18:35.432Z |
5496868 | 5496868 | 20241107020152_9ye3e | HR0025 | 2024-11-08T14:12:55.939Z | 2024-11-09T14:18:31.805Z |
5496663 | 5496663 | 20241107011154_qGtcd | HR0025 | 2024-11-08T14:12:38.453Z | 2024-11-09T14:18:27.144Z |
5496569 | 5496569 | 20241107005502_JhjJx | HR0025 | 2024-11-08T14:12:26.193Z | 2024-11-09T14:18:25.378Z |
5496477 | 5496477 | 20241107003305_Gf5Aa | HR0025 | 2024-11-08T14:12:14.362Z | 2024-11-09T14:18:23.005Z |
5496319 | 5496319 | 20241106235458_cyxZK | HR0025 | 2024-11-08T14:11:58.032Z | 2024-11-09T14:18:20.004Z |
5496303 | 5496303 | 20241106235134_YtDzD | HR0025 | 2024-11-08T14:11:56.204Z | 2024-11-09T14:18:19.868Z |
5496298 | 5496298 | 20241106234942_qAM5Y | HR0025 | 2024-11-08T14:11:55.665Z | 2024-11-09T14:18:19.832Z |
5496292 | 5496292 | 20241106234820_BFSoY | HR0025 | 2024-11-08T14:11:54.975Z | 2024-11-09T14:18:19.678Z |
5496254 | 5496254 | 20241106234010_M6NPu | HR0025 | 2024-11-08T14:11:51.674Z | 2024-11-09T14:18:19.181Z |
5495720 | 5495720 | 20241106211157_OxYUi | HR0025 | 2024-11-08T14:10:41.499Z | 2024-11-09T14:18:05.763Z |
5495670 | 5495670 | 20241106205921_61sRH | HR0025 | 2024-11-08T14:10:35.251Z | 2024-11-09T14:18:03.323Z |
5495184 | 5495184 | 20241106185428_4JH69 | HR0025 | 2024-11-08T14:09:33.288Z | 2024-11-09T14:17:44.401Z |
5491678 | 5491678 | 20241106042637_YwdGZ | HR0025 | 2024-11-07T14:16:43.901Z | 2024-11-09T14:20:12.747Z |
5491667 | 5491667 | 20241106041940_VtKc5 | HR0025 | 2024-11-07T14:16:41.597Z | 2024-11-09T14:20:12.505Z |
5491615 | 5491615 | 20241106040259_3St1B | HR0025 | 2024-11-07T14:16:30.868Z | 2024-11-09T14:20:11.876Z |
5491342 | 5491342 | 20241106030047_WQk2F | HR0025 | 2024-11-07T14:15:54.822Z | 2024-11-09T14:20:06.950Z |
5490685 | 5490685 | 20241106000913_PXFB0 | HR0025 | 2024-11-07T14:14:31.330Z | 2024-11-09T14:19:58.534Z |
5490384 | 5490384 | 20241105223047_hIsLM | HR0025 | 2024-11-07T14:13:57.563Z | 2024-11-09T14:19:54.687Z |
5489984 | 5489984 | 20241105203833_2U389 | HR0025 | 2024-11-07T14:12:59.532Z | 2024-11-09T14:19:49.702Z |
5485215 | 5485215 | 20241105042405_yxDgs | HR0025 | 2024-11-06T14:17:54.599Z | 2024-11-09T14:21:20.040Z |
5485172 | 5485172 | 20241105041417_5lfT5 | HR0025 | 2024-11-06T14:17:51.489Z | 2024-11-09T14:21:19.801Z |
5485144 | 5485144 | 20241105040957_csrUN | HR0025 | 2024-11-06T14:17:49.796Z | 2024-11-09T14:21:19.653Z |
5484904 | 5484904 | 20241105034006_J37iR | HR0025 | 2024-11-06T14:17:27.901Z | 2024-11-09T14:21:17.260Z |
5484784 | 5484784 | 20241105033002_BvZwP | HR0025 | 2024-11-06T14:17:16.644Z | 2024-11-09T14:21:16.510Z |
5484782 | 5484782 | 20241105032916_Dx3uj | HR0025 | 2024-11-06T14:17:16.414Z | 2024-11-09T14:21:16.504Z |
5484520 | 5484520 | 20241105030028_v7sRr | HR0025 | 2024-11-06T14:16:59.465Z | 2024-11-09T14:21:14.837Z |
5484380 | 5484380 | 20241105024123_38a15 | HR0025 | 2024-11-06T14:16:51.565Z | 2024-11-09T14:21:13.659Z |
5484344 | 5484344 | 20241105023720_LWVpi | HR0025 | 2024-11-06T14:16:49.797Z | 2024-11-09T14:21:13.406Z |
5484270 | 5484270 | 20241105022935_6Yk8h | HR0025 | 2024-11-06T14:16:41.946Z | 2024-11-09T14:21:12.613Z |
5484208 | 5484208 | 20241105022110_Gm2Qp | HR0025 | 2024-11-06T14:16:32.174Z | 2024-11-09T14:21:11.931Z |
5483906 | 5483906 | 20241105014317_Y3iqR | HR0025 | 2024-11-06T14:15:52.291Z | 2024-11-09T14:21:09.348Z |
5483850 | 5483850 | 20241105013833_eyISZ | HR0025 | 2024-11-06T14:15:46.057Z | 2024-11-09T14:21:08.727Z |
5483843 | 5483843 | 20241105013753_6QMiE | HR0025 | 2024-11-06T14:15:45.646Z | 2024-11-09T14:21:08.725Z |
5483730 | 5483730 | 20241105012520_omxL1 | HR0025 | 2024-11-06T14:15:38.494Z | 2024-11-09T14:21:07.189Z |
5483715 | 5483715 | 20241105012329_E2NNQ | HR0025 | 2024-11-06T14:15:37.649Z | 2024-11-09T14:21:06.973Z |
5483564 | 5483564 | 20241105005803_tqMIO | HR0025 | 2024-11-06T14:15:29.014Z | 2024-11-09T14:21:05.917Z |
5483463 | 5483463 | 20241105004355_vq8Oj | HR0025 | 2024-11-06T14:15:22.396Z | 2024-11-09T14:21:05.552Z |
5483429 | 5483429 | 20241105003939_jTIbu | HR0025 | 2024-11-06T14:15:16.347Z | 2024-11-09T14:21:05.364Z |
5483335 | 5483335 | 20241105002752_M6INB | HR0025 | 2024-11-06T14:14:59.956Z | 2024-11-09T14:21:04.844Z |
5483254 | 5483254 | 20241105001931_tH1tt | HR0025 | 2024-11-06T14:14:50.161Z | 2024-11-09T14:21:04.386Z |
5483133 | 5483133 | 20241105000137_YWJdk | HR0025 | 2024-11-06T14:14:41.671Z | 2024-11-09T14:21:03.617Z |
5483131 | 5483131 | 20241105000114_Qgxtu | HR0025 | 2024-11-06T14:14:41.470Z | 2024-11-09T14:21:03.616Z |
5483060 | 5483060 | 20241104235202_Y0I5Z | HR0025 | 2024-11-06T14:14:37.305Z | 2024-11-09T14:21:03.163Z |
5482903 | 5482903 | 20241104233147_8dVx2 | HR0025 | 2024-11-06T14:14:17.443Z | 2024-11-09T14:21:02.296Z |
5482899 | 5482899 | 20241104233134_JGvt6 | HR0025 | 2024-11-06T14:14:17.215Z | 2024-11-09T14:21:02.285Z |
5482890 | 5482890 | 20241104233015_z9HO5 | HR0025 | 2024-11-06T14:14:16.058Z | 2024-11-09T14:21:02.250Z |
5482859 | 5482859 | 20241104232609_ZXIfm | HR0025 | 2024-11-06T14:14:11.744Z | 2024-11-09T14:21:02.011Z |
5482857 | 5482857 | 20241104232557_BGe6I | HR0025 | 2024-11-06T14:14:11.645Z | 2024-11-09T14:21:01.994Z |
5482766 | 5482766 | 20241104231023_3TTZu | HR0025 | 2024-11-06T14:13:52.250Z | 2024-11-09T14:21:01.374Z |
5482682 | 5482682 | 20241104230205_UJVl9 | HR0025 | 2024-11-06T14:13:36.545Z | 2024-11-09T14:21:00.998Z |
5482645 | 5482645 | 20241104225319_0gYDY | HR0025 | 2024-11-06T14:13:29.789Z | 2024-11-09T14:21:00.729Z |
5482609 | 5482609 | 20241104224830_dL2iu | HR0025 | 2024-11-06T14:13:26.247Z | 2024-11-09T14:21:00.509Z |
5482528 | 5482528 | 20241104223444_wpsEj | HR0025 | 2024-11-06T14:13:18.599Z | 2024-11-09T14:21:00.021Z |
5482484 | 5482484 | 20241104222722_yQVFb | HR0025 | 2024-11-06T14:13:15.418Z | 2024-11-09T14:20:59.754Z |
5482249 | 5482249 | 20241104213528_igOsz | HR0025 | 2024-11-06T14:12:42.383Z | 2024-11-09T14:20:57.187Z |
5482134 | 5482134 | 20241104211056_MZ9SP | HR0025 | 2024-11-06T14:12:26.950Z | 2024-11-09T14:20:55.670Z |
5482096 | 5482096 | 20241104210508_79RQP | HR0025 | 2024-11-06T14:12:22.518Z | 2024-11-09T14:20:55.296Z |
5482026 | 5482026 | 20241104205212_B8fnC | HR0025 | 2024-11-06T14:12:15.764Z | 2024-11-09T14:20:54.278Z |
5481869 | 5481869 | 20241104200344_zrv3s | HR0025 | 2024-11-06T14:11:44.209Z | 2024-11-09T14:20:52.062Z |
5481807 | 5481807 | 20241104194713_u45CD | HR0025 | 2024-11-06T14:11:37.141Z | 2024-11-09T14:20:51.421Z |
5481760 | 5481760 | 20241104193612_hhxA3 | HR0025 | 2024-11-06T14:11:32.052Z | 2024-11-09T14:20:50.529Z |
5481609 | 5481609 | 20241104184740_s7rg4 | HR0025 | 2024-11-06T14:10:55.981Z | 2024-11-09T14:20:47.928Z |
5478516 | 5478516 | 20241104042257_H2TPv | HR0025 | 2024-11-05T14:18:27.284Z | 2024-11-09T14:22:28.804Z |
5478389 | 5478389 | 20241104040057_utAdp | HR0025 | 2024-11-05T14:18:17.847Z | 2024-11-09T14:22:27.709Z |
5478371 | 5478371 | 20241104035734_t3tNb | HR0025 | 2024-11-05T14:18:16.286Z | 2024-11-09T14:22:27.417Z |
5478338 | 5478338 | 20241104035450_s73d6 | HR0025 | 2024-11-05T14:18:14.941Z | 2024-11-09T14:22:27.251Z |
5478076 | 5478076 | 20241104031755_Vs1b7 | HR0025 | 2024-11-05T14:17:52.055Z | 2024-11-09T14:22:24.847Z |
5478074 | 5478074 | 20241104031751_WzHMp | HR0025 | 2024-11-05T14:17:51.758Z | 2024-11-09T14:22:24.842Z |
5477981 | 5477981 | 20241104030356_9GJcr | HR0025 | 2024-11-05T14:17:42.432Z | 2024-11-09T14:22:23.242Z |
5477930 | 5477930 | 20241104025448_fcuNz | HR0025 | 2024-11-05T14:17:37.388Z | 2024-11-09T14:22:22.912Z |
5477658 | 5477658 | 20241104021740_ElrOL | HR0025 | 2024-11-05T14:17:13.420Z | 2024-11-09T14:22:20.529Z |
5477566 | 5477566 | 20241104020912_D6w42 | HR0025 | 2024-11-05T14:17:03.958Z | 2024-11-09T14:22:19.580Z |
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);