participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,097 rows where station_code = "HR002R" 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 |
---|---|---|---|---|---|
5089983 | 5089983 | 20240912010522_5NfAN | HR002R | 2024-09-16T12:11:53.273Z | 2024-09-19T12:21:10.889Z |
5089500 | 5089500 | 20240912004623_vD9Qx | HR002R | 2024-09-16T12:11:27.445Z | 2024-09-19T12:21:10.012Z |
5088949 | 5088949 | 20240912001503_KMJX8 | HR002R | 2024-09-16T12:11:10.261Z | 2024-09-19T12:21:09.633Z |
5079886 | 5079886 | 20240911031857_ZlkTN | HR002R | 2024-09-15T12:16:40.359Z | 2024-09-19T12:21:42.770Z |
5079858 | 5079858 | 20240911031608_bGmp6 | HR002R | 2024-09-15T12:16:39.059Z | 2024-09-19T12:21:42.703Z |
5079732 | 5079732 | 20240911030834_hDL1Y | HR002R | 2024-09-15T12:16:34.199Z | 2024-09-19T12:21:42.582Z |
5079631 | 5079631 | 20240911030655_hZMAu | HR002R | 2024-09-15T12:16:32.098Z | 2024-09-19T12:21:42.536Z |
5079604 | 5079604 | 20240911030524_ApaeL | HR002R | 2024-09-15T12:16:28.789Z | 2024-09-19T12:21:42.480Z |
5079557 | 5079557 | 20240911030301_3zRz4 | HR002R | 2024-09-15T12:16:25.999Z | 2024-09-19T12:21:42.383Z |
5079141 | 5079141 | 20240911023428_3eKBt | HR002R | 2024-09-15T12:16:07.848Z | 2024-09-19T12:21:41.162Z |
5079075 | 5079075 | 20240911023132_F6mIL | HR002R | 2024-09-15T12:16:03.878Z | 2024-09-19T12:21:41.078Z |
5079054 | 5079054 | 20240911022956_Z7FLC | HR002R | 2024-09-15T12:16:03.214Z | 2024-09-19T12:21:41.044Z |
5078955 | 5078955 | 20240911022419_mi21Z | HR002R | 2024-09-15T12:16:00.070Z | 2024-09-19T12:21:40.921Z |
5078910 | 5078910 | 20240911022040_gbCyG | HR002R | 2024-09-15T12:15:55.657Z | 2024-09-19T12:21:40.814Z |
5078536 | 5078536 | 20240911020314_TwzkD | HR002R | 2024-09-15T12:15:43.020Z | 2024-09-19T12:21:40.500Z |
5078518 | 5078518 | 20240911020245_pR5j3 | HR002R | 2024-09-15T12:15:41.942Z | 2024-09-19T12:21:40.477Z |
5078513 | 5078513 | 20240911020220_fry2Q | HR002R | 2024-09-15T12:15:41.353Z | 2024-09-19T12:21:40.458Z |
5078381 | 5078381 | 20240911015203_cUCxF | HR002R | 2024-09-15T12:15:37.008Z | 2024-09-19T12:21:40.328Z |
5078324 | 5078324 | 20240911015008_bO1qp | HR002R | 2024-09-15T12:15:33.362Z | 2024-09-19T12:21:40.229Z |
5077908 | 5077908 | 20240911012839_w62iU | HR002R | 2024-09-15T12:15:10.544Z | 2024-09-19T12:21:39.775Z |
5077847 | 5077847 | 20240911012155_WjocH | HR002R | 2024-09-15T12:15:07.800Z | 2024-09-19T12:21:39.746Z |
5077798 | 5077798 | 20240911011902_3uYIN | HR002R | 2024-09-15T12:15:05.771Z | 2024-09-19T12:21:39.653Z |
5077406 | 5077406 | 20240911004932_aMqkO | HR002R | 2024-09-15T12:14:43.093Z | 2024-09-19T12:21:38.970Z |
5077191 | 5077191 | 20240911003154_61sno | HR002R | 2024-09-15T12:14:29.142Z | 2024-09-19T12:21:38.488Z |
5077012 | 5077012 | 20240911002046_uXR2x | HR002R | 2024-09-15T12:14:17.372Z | 2024-09-19T12:21:37.960Z |
5076964 | 5076964 | 20240911001818_trvoe | HR002R | 2024-09-15T12:14:15.700Z | 2024-09-19T12:21:37.927Z |
5076847 | 5076847 | 20240911001034_gdbLC | HR002R | 2024-09-15T12:14:06.636Z | 2024-09-19T12:21:37.621Z |
5076722 | 5076722 | 20240911000547_wjDB6 | HR002R | 2024-09-15T12:13:58.651Z | 2024-09-19T12:21:37.518Z |
5076595 | 5076595 | 20240910234928_lMM9o | HR002R | 2024-09-15T12:13:45.411Z | 2024-09-19T12:21:37.369Z |
5076489 | 5076489 | 20240910234056_VE2vj | HR002R | 2024-09-15T12:13:38.255Z | 2024-09-19T12:21:37.300Z |
5076422 | 5076422 | 20240910233343_x2gvB | HR002R | 2024-09-15T12:13:33.570Z | 2024-09-19T12:21:37.166Z |
5076417 | 5076417 | 20240910233315_gjijK | HR002R | 2024-09-15T12:13:33.319Z | 2024-09-19T12:21:37.037Z |
5076125 | 5076125 | 20240910230809_e9Bx7 | HR002R | 2024-09-15T12:13:18.586Z | 2024-09-19T12:21:36.461Z |
5075991 | 5075991 | 20240910230518_3xdoD | HR002R | 2024-09-15T12:13:15.471Z | 2024-09-19T12:21:36.363Z |
5075380 | 5075380 | 20240911234442_Ra5QF | HR002R | 2024-09-15T12:09:40.018Z | 2024-09-19T12:21:09.178Z |
5074942 | 5074942 | 20240911231758_zsaqN | HR002R | 2024-09-15T12:09:14.756Z | 2024-09-19T12:21:07.942Z |
5074869 | 5074869 | 20240911231114_tMuOd | HR002R | 2024-09-15T12:09:06.439Z | 2024-09-19T12:21:07.845Z |
5074287 | 5074287 | 20240911222845_Gsl1U | HR002R | 2024-09-15T12:08:17.631Z | 2024-09-19T12:21:07.024Z |
5073224 | 5073224 | 20240911210658_iVFac | HR002R | 2024-09-15T12:06:56.383Z | 2024-09-19T12:21:05.335Z |
5072552 | 5072552 | 20240911202258_Bp55I | HR002R | 2024-09-15T12:05:37.333Z | 2024-09-19T12:21:04.413Z |
5072380 | 5072380 | 20240911200126_SIH3T | HR002R | 2024-09-15T12:05:16.647Z | 2024-09-19T12:21:04.002Z |
5070032 | 5070032 | 20240910222608_i8fXc | HR002R | 2024-09-14T12:20:12.477Z | 2024-09-19T12:21:35.625Z |
5069494 | 5069494 | 20240910214621_ms3AH | HR002R | 2024-09-14T12:19:58.468Z | 2024-09-19T12:21:34.963Z |
5069319 | 5069319 | 20240910213024_95D93 | HR002R | 2024-09-14T12:19:54.316Z | 2024-09-19T12:21:34.579Z |
5069302 | 5069302 | 20240910212801_FnYdv | HR002R | 2024-09-14T12:19:53.579Z | 2024-09-19T12:21:34.441Z |
5069225 | 5069225 | 20240910212200_2VEmY | HR002R | 2024-09-14T12:19:49.478Z | 2024-09-19T12:21:33.994Z |
5069102 | 5069102 | 20240910210828_YKbtS | HR002R | 2024-09-14T12:19:44.858Z | 2024-09-19T12:21:33.624Z |
5065098 | 5065098 | 20240910030405_meAUE | HR002R | 2024-09-14T12:16:25.148Z | 2024-09-18T12:15:18.377Z |
5065039 | 5065039 | 20240910025716_keOY9 | HR002R | 2024-09-14T12:16:19.260Z | 2024-09-18T12:15:18.224Z |
5064949 | 5064949 | 20240910024031_CcI1g | HR002R | 2024-09-14T12:16:12.064Z | 2024-09-18T12:15:17.909Z |
5064910 | 5064910 | 20240910022900_LDv2D | HR002R | 2024-09-14T12:16:09.582Z | 2024-09-18T12:15:17.758Z |
5064909 | 5064909 | 20240910022758_y4g8j | HR002R | 2024-09-14T12:16:09.452Z | 2024-09-18T12:15:17.744Z |
5064835 | 5064835 | 20240910021239_j37UR | HR002R | 2024-09-14T12:16:05.496Z | 2024-09-18T12:15:17.493Z |
5064820 | 5064820 | 20240910020904_HBKVS | HR002R | 2024-09-14T12:16:04.582Z | 2024-09-18T12:15:17.458Z |
5064730 | 5064730 | 20240910015148_LusbX | HR002R | 2024-09-14T12:15:58.280Z | 2024-09-18T12:15:17.097Z |
5064706 | 5064706 | 20240910014805_26cF6 | HR002R | 2024-09-14T12:15:56.209Z | 2024-09-18T12:15:16.970Z |
5064495 | 5064495 | 20240910012423_gm7q1 | HR002R | 2024-09-14T12:15:33.424Z | 2024-09-18T12:15:16.776Z |
5064284 | 5064284 | 20240910003829_m2f20 | HR002R | 2024-09-14T12:15:12.741Z | 2024-09-18T12:15:16.070Z |
5064253 | 5064253 | 20240910003051_LRmj7 | HR002R | 2024-09-14T12:15:09.461Z | 2024-09-18T12:15:15.964Z |
5063764 | 5063764 | 20240909223712_VDmW3 | HR002R | 2024-09-14T12:14:20.985Z | 2024-09-18T12:15:14.661Z |
5063760 | 5063760 | 20240909223559_yS4Nq | HR002R | 2024-09-14T12:14:20.145Z | 2024-09-18T12:15:14.599Z |
5063757 | 5063757 | 20240909223558_zzDCO | HR002R | 2024-09-14T12:14:19.954Z | 2024-09-18T12:15:14.584Z |
5063456 | 5063456 | 20240909211850_kARSN | HR002R | 2024-09-14T12:14:01.195Z | 2024-09-18T12:15:13.965Z |
5063412 | 5063412 | 20240909210629_rGhnz | HR002R | 2024-09-14T12:13:58.531Z | 2024-09-18T12:15:13.838Z |
5063368 | 5063368 | 20240909210032_AjFS0 | HR002R | 2024-09-14T12:13:56.182Z | 2024-09-18T12:15:13.769Z |
5063271 | 5063271 | 20240909203157_U2DAP | HR002R | 2024-09-14T12:13:47.416Z | 2024-09-18T12:15:13.491Z |
5060786 | 5060786 | 20240910210617_wZg4W | HR002R | 2024-09-14T12:09:32.895Z | 2024-09-19T12:21:33.596Z |
5060727 | 5060727 | 20240910205713_KQ2OM | HR002R | 2024-09-14T12:09:25.639Z | 2024-09-19T12:21:33.511Z |
5060371 | 5060371 | 20240910202413_qVZeN | HR002R | 2024-09-14T12:08:42.395Z | 2024-09-19T12:21:32.295Z |
5060362 | 5060362 | 20240910202320_i2TLx | HR002R | 2024-09-14T12:08:41.210Z | 2024-09-19T12:21:32.212Z |
5060352 | 5060352 | 20240910202137_wuEOh | HR002R | 2024-09-14T12:08:40.586Z | 2024-09-19T12:21:32.195Z |
5060302 | 5060302 | 20240910201647_sljNt | HR002R | 2024-09-14T12:08:36.787Z | 2024-09-19T12:21:32.139Z |
5060135 | 5060135 | 20240910195554_wNOzM | HR002R | 2024-09-14T12:08:16.416Z | 2024-09-19T12:21:31.844Z |
5060011 | 5060011 | 20240910193112_xeeMF | HR002R | 2024-09-14T12:07:57.354Z | 2024-09-19T12:21:31.605Z |
5059684 | 5059684 | 20240910183138_AE253 | HR002R | 2024-09-14T12:06:45.569Z | 2024-09-19T12:21:31.107Z |
5054627 | 5054627 | 20240908032419_jn542 | HR002R | 2024-09-13T12:16:50.093Z | 2024-09-16T12:21:16.327Z |
5054534 | 5054534 | 20240908030520_pmWzL | HR002R | 2024-09-13T12:16:46.133Z | 2024-09-16T12:21:15.922Z |
5054452 | 5054452 | 20240908025323_bw2JG | HR002R | 2024-09-13T12:16:42.306Z | 2024-09-16T12:21:15.631Z |
5054388 | 5054388 | 20240908024522_Pz22U | HR002R | 2024-09-13T12:16:39.942Z | 2024-09-16T12:21:15.438Z |
5054372 | 5054372 | 20240908024301_nCGAn | HR002R | 2024-09-13T12:16:39.541Z | 2024-09-16T12:21:15.416Z |
5054252 | 5054252 | 20240908023229_8ENhl | HR002R | 2024-09-13T12:16:35.444Z | 2024-09-16T12:21:14.681Z |
5054236 | 5054236 | 20240908023044_O0bOp | HR002R | 2024-09-13T12:16:34.914Z | 2024-09-16T12:21:14.627Z |
5054096 | 5054096 | 20240908020906_nEfQq | HR002R | 2024-09-13T12:16:29.454Z | 2024-09-16T12:21:13.948Z |
5053943 | 5053943 | 20240908015227_ErF0S | HR002R | 2024-09-13T12:16:23.394Z | 2024-09-16T12:21:13.353Z |
5053931 | 5053931 | 20240908015012_qLTl2 | HR002R | 2024-09-13T12:16:23.165Z | 2024-09-16T12:21:13.325Z |
5053587 | 5053587 | 20240908010206_MLHHH | HR002R | 2024-09-13T12:16:09.330Z | 2024-09-16T12:21:12.011Z |
5053512 | 5053512 | 20240908005034_KJqYT | HR002R | 2024-09-13T12:16:07.183Z | 2024-09-16T12:21:11.737Z |
5053496 | 5053496 | 20240908004553_Z03D9 | HR002R | 2024-09-13T12:16:06.402Z | 2024-09-16T12:21:11.677Z |
5053431 | 5053431 | 20240908003442_glCwL | HR002R | 2024-09-13T12:16:03.751Z | 2024-09-16T12:21:10.592Z |
5053291 | 5053291 | 20240908000447_k2aZg | HR002R | 2024-09-13T12:15:57.164Z | 2024-09-16T12:21:10.263Z |
5053290 | 5053290 | 20240908000446_2LpQQ | HR002R | 2024-09-13T12:15:57.016Z | 2024-09-16T12:21:10.251Z |
5053192 | 5053192 | 20240907234844_EI2Cp | HR002R | 2024-09-13T12:15:52.952Z | 2024-09-16T12:21:09.975Z |
5053111 | 5053111 | 20240907232951_fWt7u | HR002R | 2024-09-13T12:15:46.926Z | 2024-09-16T12:21:09.516Z |
5053082 | 5053082 | 20240907232008_d0kYV | HR002R | 2024-09-13T12:15:45.323Z | 2024-09-16T12:21:09.446Z |
5052976 | 5052976 | 20240907225118_ul4kE | HR002R | 2024-09-13T12:15:39.826Z | 2024-09-16T12:21:08.832Z |
5052806 | 5052806 | 20240907221103_gVIwN | HR002R | 2024-09-13T12:15:29.179Z | 2024-09-16T12:21:07.944Z |
5052749 | 5052749 | 20240907215043_LLw8r | HR002R | 2024-09-13T12:15:24.851Z | 2024-09-16T12:21:07.506Z |
5052704 | 5052704 | 20240907214014_lcgUt | HR002R | 2024-09-13T12:15:21.738Z | 2024-09-16T12:21:07.236Z |
5052593 | 5052593 | 20240907211125_aXG7g | HR002R | 2024-09-13T12:15:14.771Z | 2024-09-16T12:21:06.586Z |
5052362 | 5052362 | 20240907202650_u2SX1 | HR002R | 2024-09-13T12:15:05.498Z | 2024-09-16T12:21:05.241Z |
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);