participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "HR000V" 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 |
---|---|---|---|---|---|
5505361 | 5505361 | 20241108045059_7lyQf | HR000V | 2024-11-09T14:16:13.218Z | 2024-11-09T14:16:28.765Z |
5505276 | 5505276 | 20241108042408_cpi5x | HR000V | 2024-11-09T14:16:03.406Z | 2024-11-09T14:16:28.743Z |
5505266 | 5505266 | 20241108042119_HO3lu | HR000V | 2024-11-09T14:16:01.812Z | 2024-11-09T14:16:28.740Z |
5505232 | 5505232 | 20241108041127_oMkh7 | HR000V | 2024-11-09T14:15:57.317Z | 2024-11-09T14:16:28.732Z |
5505172 | 5505172 | 20241108040342_iyBxS | HR000V | 2024-11-09T14:15:53.083Z | 2024-11-09T14:16:28.718Z |
5505121 | 5505121 | 20241108035557_0BnJO | HR000V | 2024-11-09T14:15:46.152Z | 2024-11-09T14:16:28.706Z |
5504331 | 5504331 | 20241108013902_1QJlP | HR000V | 2024-11-09T14:14:27.002Z | 2024-11-09T14:16:28.509Z |
5504291 | 5504291 | 20241108012833_T1ZCS | HR000V | 2024-11-09T14:14:23.222Z | 2024-11-09T14:16:28.497Z |
5504285 | 5504285 | 20241108012756_Kjbg4 | HR000V | 2024-11-09T14:14:21.950Z | 2024-11-09T14:16:28.496Z |
5504255 | 5504255 | 20241108012025_DnJTm | HR000V | 2024-11-09T14:14:17.722Z | 2024-11-09T14:16:28.487Z |
5504243 | 5504243 | 20241108011910_mbGLh | HR000V | 2024-11-09T14:14:16.369Z | 2024-11-09T14:16:28.484Z |
5504144 | 5504144 | 20241108010312_KgrIR | HR000V | 2024-11-09T14:14:07.904Z | 2024-11-09T14:16:28.460Z |
5504122 | 5504122 | 20241108005828_w10uj | HR000V | 2024-11-09T14:14:06.072Z | 2024-11-09T14:16:28.455Z |
5503965 | 5503965 | 20241108002718_XyHV6 | HR000V | 2024-11-09T14:13:55.378Z | 2024-11-09T14:16:28.413Z |
5503957 | 5503957 | 20241108002626_hGmQ0 | HR000V | 2024-11-09T14:13:54.938Z | 2024-11-09T14:16:28.411Z |
5503932 | 5503932 | 20241108001735_2WzpP | HR000V | 2024-11-09T14:13:51.895Z | 2024-11-09T14:16:28.401Z |
5503867 | 5503867 | 20241108000354_x1lhG | HR000V | 2024-11-09T14:13:48.803Z | 2024-11-09T14:16:28.373Z |
5503855 | 5503855 | 20241107235924_wNtEi | HR000V | 2024-11-09T14:13:48.215Z | 2024-11-09T14:16:28.368Z |
5503672 | 5503672 | 20241107232439_BZxPW | HR000V | 2024-11-09T14:13:31.502Z | 2024-11-09T14:16:28.317Z |
5503644 | 5503644 | 20241107231149_Uq73o | HR000V | 2024-11-09T14:13:28.364Z | 2024-11-09T14:16:28.310Z |
5503641 | 5503641 | 20241107230956_bAhy1 | HR000V | 2024-11-09T14:13:28.254Z | 2024-11-09T14:16:28.310Z |
5503637 | 5503637 | 20241107230851_A3CU0 | HR000V | 2024-11-09T14:13:27.735Z | 2024-11-09T14:16:28.308Z |
5503622 | 5503622 | 20241107230616_tKsRd | HR000V | 2024-11-09T14:13:26.313Z | 2024-11-09T14:16:28.305Z |
5503606 | 5503606 | 20241107230220_25Bid | HR000V | 2024-11-09T14:13:23.697Z | 2024-11-09T14:16:28.300Z |
5503600 | 5503600 | 20241107230003_vMcQ5 | HR000V | 2024-11-09T14:13:23.383Z | 2024-11-09T14:16:28.299Z |
5503457 | 5503457 | 20241107222440_ff2vA | HR000V | 2024-11-09T14:13:07.124Z | 2024-11-09T14:16:28.264Z |
5503398 | 5503398 | 20241107220551_iSb2D | HR000V | 2024-11-09T14:12:58.957Z | 2024-11-09T14:16:28.243Z |
5503124 | 5503124 | 20241107204416_hZEgJ | HR000V | 2024-11-09T14:12:26.199Z | 2024-11-09T14:16:28.172Z |
5503104 | 5503104 | 20241107204151_7k8Uw | HR000V | 2024-11-09T14:12:25.092Z | 2024-11-09T14:16:28.167Z |
5502970 | 5502970 | 20241107202113_NbgCg | HR000V | 2024-11-09T14:12:16.265Z | 2024-11-09T14:16:28.140Z |
5502940 | 5502940 | 20241107201436_kNIQN | HR000V | 2024-11-09T14:12:13.821Z | 2024-11-09T14:16:28.132Z |
5502928 | 5502928 | 20241107201233_SU7d2 | HR000V | 2024-11-09T14:12:13.035Z | 2024-11-09T14:16:28.130Z |
5502898 | 5502898 | 20241107200858_F25pP | HR000V | 2024-11-09T14:12:11.364Z | 2024-11-09T14:16:28.123Z |
5502695 | 5502695 | 20241107193226_fELyI | HR000V | 2024-11-09T14:11:58.568Z | 2024-11-09T14:16:28.079Z |
5502658 | 5502658 | 20241107192830_wzacQ | HR000V | 2024-11-09T14:11:55.988Z | 2024-11-09T14:16:28.073Z |
5502624 | 5502624 | 20241107191935_Lfr66 | HR000V | 2024-11-09T14:11:52.029Z | 2024-11-09T14:16:28.068Z |
5502496 | 5502496 | 20241107185026_Eb9bt | HR000V | 2024-11-09T14:11:33.423Z | 2024-11-09T14:16:28.041Z |
5502177 | 5502177 | 20241107173541_dDimk | HR000V | 2024-11-09T14:11:01.641Z | 2024-11-09T14:16:27.973Z |
5502119 | 5502119 | 20241107172448_x3s53 | HR000V | 2024-11-09T14:10:58.216Z | 2024-11-09T14:16:27.955Z |
5501961 | 5501961 | 20241107164610_hc2qM | HR000V | 2024-11-09T14:10:47.923Z | 2024-11-09T14:16:27.912Z |
5501916 | 5501916 | 20241107163847_k3x7x | HR000V | 2024-11-09T14:10:45.421Z | 2024-11-09T14:16:27.905Z |
5497526 | 5497526 | 20241107035554_Pk2qO | HR000V | 2024-11-08T14:13:56.061Z | 2024-11-09T14:18:45.172Z |
5497421 | 5497421 | 20241107033658_ftkdF | HR000V | 2024-11-08T14:13:45.025Z | 2024-11-09T14:18:42.624Z |
5497333 | 5497333 | 20241107032318_rAhxG | HR000V | 2024-11-08T14:13:34.436Z | 2024-11-09T14:18:40.987Z |
5497297 | 5497297 | 20241107031756_WJgA2 | HR000V | 2024-11-08T14:13:30.731Z | 2024-11-09T14:18:40.216Z |
5497134 | 5497134 | 20241107024847_vru26 | HR000V | 2024-11-08T14:13:14.466Z | 2024-11-09T14:18:35.860Z |
5497121 | 5497121 | 20241107024436_R7euZ | HR000V | 2024-11-08T14:13:12.322Z | 2024-11-09T14:18:35.757Z |
5497069 | 5497069 | 20241107023759_FJsG0 | HR000V | 2024-11-08T14:13:08.300Z | 2024-11-09T14:18:35.099Z |
5497051 | 5497051 | 20241107023521_dfy4K | HR000V | 2024-11-08T14:13:07.523Z | 2024-11-09T14:18:34.813Z |
5496935 | 5496935 | 20241107021206_jJnq7 | HR000V | 2024-11-08T14:12:59.768Z | 2024-11-09T14:18:33.312Z |
5496894 | 5496894 | 20241107020754_ZDXqh | HR000V | 2024-11-08T14:12:57.791Z | 2024-11-09T14:18:32.639Z |
5496855 | 5496855 | 20241107015854_Q1yIA | HR000V | 2024-11-08T14:12:55.347Z | 2024-11-09T14:18:31.373Z |
5496818 | 5496818 | 20241107014801_UtMpL | HR000V | 2024-11-08T14:12:53.505Z | 2024-11-09T14:18:30.862Z |
5496785 | 5496785 | 20241107013837_jy33m | HR000V | 2024-11-08T14:12:51.680Z | 2024-11-09T14:18:30.158Z |
5496740 | 5496740 | 20241107012823_lru59 | HR000V | 2024-11-08T14:12:48.951Z | 2024-11-09T14:18:29.302Z |
5496735 | 5496735 | 20241107012822_qY3OU | HR000V | 2024-11-08T14:12:48.757Z | 2024-11-09T14:18:29.260Z |
5496705 | 5496705 | 20241107012203_93PeC | HR000V | 2024-11-08T14:12:44.525Z | 2024-11-09T14:18:27.851Z |
5496626 | 5496626 | 20241107010454_zRDvM | HR000V | 2024-11-08T14:12:33.178Z | 2024-11-09T14:18:26.717Z |
5496621 | 5496621 | 20241107010355_OmZhR | HR000V | 2024-11-08T14:12:32.252Z | 2024-11-09T14:18:26.630Z |
5496579 | 5496579 | 20241107005603_6r92A | HR000V | 2024-11-08T14:12:28.076Z | 2024-11-09T14:18:25.730Z |
5496566 | 5496566 | 20241107005434_EHUx6 | HR000V | 2024-11-08T14:12:25.885Z | 2024-11-09T14:18:25.377Z |
5496513 | 5496513 | 20241107004058_v341M | HR000V | 2024-11-08T14:12:18.027Z | 2024-11-09T14:18:23.810Z |
5496465 | 5496465 | 20241107003051_e7jSh | HR000V | 2024-11-08T14:12:12.390Z | 2024-11-09T14:18:22.832Z |
5496458 | 5496458 | 20241107003034_gPd8l | HR000V | 2024-11-08T14:12:11.451Z | 2024-11-09T14:18:22.664Z |
5496454 | 5496454 | 20241107002949_c8y4D | HR000V | 2024-11-08T14:12:11.192Z | 2024-11-09T14:18:22.611Z |
5496405 | 5496405 | 20241107001543_eJWBy | HR000V | 2024-11-08T14:12:06.950Z | 2024-11-09T14:18:21.736Z |
5496399 | 5496399 | 20241107001452_vOu23 | HR000V | 2024-11-08T14:12:06.588Z | 2024-11-09T14:18:21.711Z |
5496323 | 5496323 | 20241106235606_Fchr9 | HR000V | 2024-11-08T14:11:58.659Z | 2024-11-09T14:18:20.060Z |
5496321 | 5496321 | 20241106235515_95oYJ | HR000V | 2024-11-08T14:11:58.278Z | 2024-11-09T14:18:20.028Z |
5496311 | 5496311 | 20241106235326_exLM6 | HR000V | 2024-11-08T14:11:57.075Z | 2024-11-09T14:18:19.943Z |
5496309 | 5496309 | 20241106235313_ubwMC | HR000V | 2024-11-08T14:11:56.902Z | 2024-11-09T14:18:19.923Z |
5496278 | 5496278 | 20241106234603_Yi0DK | HR000V | 2024-11-08T14:11:53.508Z | 2024-11-09T14:18:19.444Z |
5496257 | 5496257 | 20241106234101_PpqTH | HR000V | 2024-11-08T14:11:51.746Z | 2024-11-09T14:18:19.188Z |
5496231 | 5496231 | 20241106233237_yXKr0 | HR000V | 2024-11-08T14:11:49.032Z | 2024-11-09T14:18:18.718Z |
5496228 | 5496228 | 20241106233232_IIlAl | HR000V | 2024-11-08T14:11:48.794Z | 2024-11-09T14:18:18.680Z |
5496129 | 5496129 | 20241106230407_OHRle | HR000V | 2024-11-08T14:11:36.950Z | 2024-11-09T14:18:16.568Z |
5496061 | 5496061 | 20241106224956_RZFHN | HR000V | 2024-11-08T14:11:28.960Z | 2024-11-09T14:18:15.275Z |
5495920 | 5495920 | 20241106220556_O3lqH | HR000V | 2024-11-08T14:11:08.197Z | 2024-11-09T14:18:11.637Z |
5495833 | 5495833 | 20241106214236_uR4A4 | HR000V | 2024-11-08T14:10:57.751Z | 2024-11-09T14:18:10.104Z |
5495736 | 5495736 | 20241106211856_FaoIa | HR000V | 2024-11-08T14:10:44.083Z | 2024-11-09T14:18:06.326Z |
5495681 | 5495681 | 20241106210139_nBY4n | HR000V | 2024-11-08T14:10:36.390Z | 2024-11-09T14:18:03.684Z |
5495673 | 5495673 | 20241106205953_1jV4a | HR000V | 2024-11-08T14:10:35.732Z | 2024-11-09T14:18:03.372Z |
5495489 | 5495489 | 20241106200130_tbX88 | HR000V | 2024-11-08T14:10:17.900Z | 2024-11-09T14:17:55.467Z |
5495231 | 5495231 | 20241106190257_jUzt2 | HR000V | 2024-11-08T14:09:42.331Z | 2024-11-09T14:17:46.426Z |
5491663 | 5491663 | 20241106041936_fUFNR | HR000V | 2024-11-07T14:16:41.175Z | 2024-11-09T14:20:12.502Z |
5491656 | 5491656 | 20241106041540_6bUxw | HR000V | 2024-11-07T14:16:39.465Z | 2024-11-09T14:20:12.349Z |
5491646 | 5491646 | 20241106041435_wYzVw | HR000V | 2024-11-07T14:16:37.231Z | 2024-11-09T14:20:12.308Z |
5491629 | 5491629 | 20241106040703_glwmS | HR000V | 2024-11-07T14:16:33.100Z | 2024-11-09T14:20:12.078Z |
5491364 | 5491364 | 20241106030541_JDrYL | HR000V | 2024-11-07T14:15:57.778Z | 2024-11-09T14:20:07.184Z |
5490949 | 5490949 | 20241106012214_CJ3Nj | HR000V | 2024-11-07T14:15:07.384Z | 2024-11-09T14:20:02.235Z |
5490745 | 5490745 | 20241106002727_5qu1H | HR000V | 2024-11-07T14:14:47.776Z | 2024-11-09T14:19:59.107Z |
5489911 | 5489911 | 20241105202634_yD6EM | HR000V | 2024-11-07T14:12:54.474Z | 2024-11-09T14:19:48.954Z |
5485195 | 5485195 | 20241105041845_Nfkk3 | HR000V | 2024-11-06T14:17:53.297Z | 2024-11-09T14:21:19.963Z |
5485158 | 5485158 | 20241105041318_32a2A | HR000V | 2024-11-06T14:17:50.712Z | 2024-11-09T14:21:19.749Z |
5485151 | 5485151 | 20241105041129_pHuW4 | HR000V | 2024-11-06T14:17:50.574Z | 2024-11-09T14:21:19.739Z |
5485137 | 5485137 | 20241105040923_DqTTZ | HR000V | 2024-11-06T14:17:49.350Z | 2024-11-09T14:21:19.640Z |
5485121 | 5485121 | 20241105040721_QjD0b | HR000V | 2024-11-06T14:17:47.651Z | 2024-11-09T14:21:19.543Z |
5485110 | 5485110 | 20241105040511_I5ZlF | HR000V | 2024-11-06T14:17:46.536Z | 2024-11-09T14:21:19.435Z |
5485088 | 5485088 | 20241105040218_m13vg | HR000V | 2024-11-06T14:17:44.204Z | 2024-11-09T14:21:19.200Z |
5485078 | 5485078 | 20241105040150_UFTYc | HR000V | 2024-11-06T14:17:43.882Z | 2024-11-09T14:21:19.198Z |
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);