participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,815 rows where station_code = "AU000Z" 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 |
---|---|---|---|---|---|
5097039 | 5097039 | 20240912140100_H6192 | AU000Z | 2024-09-16T12:16:43.194Z | 2024-09-16T12:17:32.009Z |
5097013 | 5097013 | 20240912133850_Xn4Ko | AU000Z | 2024-09-16T12:16:42.288Z | 2024-09-16T12:17:31.997Z |
5097006 | 5097006 | 20240912133508_HzBfY | AU000Z | 2024-09-16T12:16:42.012Z | 2024-09-16T12:17:31.995Z |
5096967 | 5096967 | 20240912131246_uwaJa | AU000Z | 2024-09-16T12:16:40.842Z | 2024-09-16T12:17:31.982Z |
5096641 | 5096641 | 20240912112654_at913 | AU000Z | 2024-09-16T12:16:30.750Z | 2024-09-16T12:17:31.836Z |
5085392 | 5085392 | 20240912211831_AUdda | AU000Z | 2024-09-16T12:04:12.940Z | 2024-09-16T12:17:04.725Z |
5085110 | 5085110 | 20240912204642_2UXEC | AU000Z | 2024-09-16T12:03:33.047Z | 2024-09-16T12:17:04.590Z |
5084635 | 5084635 | 20240912195930_xZ0Iw | AU000Z | 2024-09-16T12:02:41.319Z | 2024-09-16T12:17:04.397Z |
5084617 | 5084617 | 20240912195709_n2XmW | AU000Z | 2024-09-16T12:02:39.247Z | 2024-09-16T12:17:04.391Z |
5084590 | 5084590 | 20240912195345_BNGcS | AU000Z | 2024-09-16T12:02:35.298Z | 2024-09-16T12:17:04.370Z |
5084580 | 5084580 | 20240912195236_kx3hP | AU000Z | 2024-09-16T12:02:31.970Z | 2024-09-16T12:17:04.366Z |
5084549 | 5084549 | 20240912194945_zp60T | AU000Z | 2024-09-16T12:02:22.645Z | 2024-09-16T12:17:04.356Z |
5084471 | 5084471 | 20240912194106_8UC4E | AU000Z | 2024-09-16T12:02:07.373Z | 2024-09-16T12:17:04.318Z |
5084353 | 5084353 | 20240912192632_eATSL | AU000Z | 2024-09-16T12:01:56.255Z | 2024-09-16T12:17:04.262Z |
5084308 | 5084308 | 20240912191433_Qi0NM | AU000Z | 2024-09-16T12:01:50.674Z | 2024-09-16T12:17:04.240Z |
5084257 | 5084257 | 20240912190333_ema46 | AU000Z | 2024-09-16T12:01:42.582Z | 2024-09-16T12:17:04.205Z |
5084239 | 5084239 | 20240912190208_efzHY | AU000Z | 2024-09-16T12:01:38.333Z | 2024-09-16T12:17:04.196Z |
5084196 | 5084196 | 20240912185402_o7qDT | AU000Z | 2024-09-16T12:01:33.432Z | 2024-09-16T12:17:04.170Z |
5084170 | 5084170 | 20240912184240_jpzqL | AU000Z | 2024-09-16T12:01:23.260Z | 2024-09-16T12:17:04.150Z |
5084110 | 5084110 | 20240912181420_FEIbw | AU000Z | 2024-09-16T12:01:10.628Z | 2024-09-16T12:17:04.100Z |
5083917 | 5083917 | 20240912164339_pYSqV | AU000Z | 2024-09-16T12:00:38.767Z | 2024-09-16T12:17:03.975Z |
5083909 | 5083909 | 20240912164102_mkZ1Z | AU000Z | 2024-09-16T12:00:38.006Z | 2024-09-16T12:17:03.972Z |
5083895 | 5083895 | 20240912163902_Xs5Q8 | AU000Z | 2024-09-16T12:00:36.647Z | 2024-09-16T12:17:03.967Z |
5083756 | 5083756 | 20240912150857_dfcNX | AU000Z | 2024-09-16T12:00:15.883Z | 2024-09-16T12:17:03.875Z |
5083311 | 5083311 | 20240911125218_HO3J3 | AU000Z | 2024-09-15T12:18:38.717Z | 2024-09-16T12:19:17.908Z |
5083240 | 5083240 | 20240911123538_CymLF | AU000Z | 2024-09-15T12:18:37.402Z | 2024-09-16T12:19:17.450Z |
5073422 | 5073422 | 20240911212255_3WlFK | AU000Z | 2024-09-15T12:07:09.498Z | 2024-09-16T12:17:29.244Z |
5073371 | 5073371 | 20240911211729_YWTk7 | AU000Z | 2024-09-15T12:07:06.471Z | 2024-09-16T12:17:29.238Z |
5073249 | 5073249 | 20240911210957_ngDX0 | AU000Z | 2024-09-15T12:06:58.642Z | 2024-09-16T12:17:29.220Z |
5072505 | 5072505 | 20240911201628_07yOB | AU000Z | 2024-09-15T12:05:31.294Z | 2024-09-16T12:17:29.099Z |
5072046 | 5072046 | 20240911192703_qYSIo | AU000Z | 2024-09-15T12:04:32.234Z | 2024-09-16T12:17:29.012Z |
5072020 | 5072020 | 20240911192326_RPjgC | AU000Z | 2024-09-15T12:04:23.035Z | 2024-09-16T12:17:29.006Z |
5072000 | 5072000 | 20240911191940_dAv3R | AU000Z | 2024-09-15T12:04:17.064Z | 2024-09-16T12:17:29.000Z |
5071912 | 5071912 | 20240911185710_I9VuS | AU000Z | 2024-09-15T12:04:00.376Z | 2024-09-16T12:17:28.977Z |
5071800 | 5071800 | 20240911182338_nZwxl | AU000Z | 2024-09-15T12:03:38.759Z | 2024-09-16T12:17:28.945Z |
5071700 | 5071700 | 20240911175431_Ocphq | AU000Z | 2024-09-15T12:03:17.069Z | 2024-09-16T12:17:28.900Z |
5071458 | 5071458 | 20240911165819_7wAXE | AU000Z | 2024-09-15T12:02:36.393Z | 2024-09-16T12:17:28.836Z |
5071293 | 5071293 | 20240911162959_BvMHF | AU000Z | 2024-09-15T12:02:11.204Z | 2024-09-16T12:17:28.778Z |
5071221 | 5071221 | 20240911161746_rS5V0 | AU000Z | 2024-09-15T12:01:57.187Z | 2024-09-16T12:17:28.761Z |
5071096 | 5071096 | 20240911160013_kynh7 | AU000Z | 2024-09-15T12:01:39.219Z | 2024-09-16T12:17:28.733Z |
5070972 | 5070972 | 20240911153623_kKJdz | AU000Z | 2024-09-15T12:01:16.614Z | 2024-09-16T12:17:28.703Z |
5068328 | 5068328 | 20240910112053_xMyxt | AU000Z | 2024-09-14T12:19:12.272Z | 2024-09-16T12:20:13.477Z |
5062497 | 5062497 | 20240909173407_65RMG | AU000Z | 2024-09-14T12:12:28.290Z | 2024-09-16T12:19:37.568Z |
5062485 | 5062485 | 20240909173120_hSDBU | AU000Z | 2024-09-14T12:12:27.474Z | 2024-09-16T12:19:37.539Z |
5062374 | 5062374 | 20240909171655_L6qJw | AU000Z | 2024-09-14T12:12:14.467Z | 2024-09-16T12:19:37.125Z |
5062005 | 5062005 | 20240909163252_6kC0H | AU000Z | 2024-09-14T12:11:44.188Z | 2024-09-16T12:19:35.061Z |
5061872 | 5061872 | 20240909161617_BzjHz | AU000Z | 2024-09-14T12:11:34.785Z | 2024-09-16T12:19:34.416Z |
5061745 | 5061745 | 20240909154951_XL0IV | AU000Z | 2024-09-14T12:11:18.439Z | 2024-09-16T12:19:33.459Z |
5061663 | 5061663 | 20240909153858_MOMYk | AU000Z | 2024-09-14T12:11:08.327Z | 2024-09-16T12:19:32.963Z |
5061488 | 5061488 | 20240909151403_mNmqS | AU000Z | 2024-09-14T12:10:52.630Z | 2024-09-16T12:19:31.762Z |
5061302 | 5061302 | 20240909144323_HJXYK | AU000Z | 2024-09-14T12:10:40.846Z | 2024-09-16T12:19:30.411Z |
5061288 | 5061288 | 20240909144150_LOaOG | AU000Z | 2024-09-14T12:10:40.203Z | 2024-09-16T12:19:30.308Z |
5060821 | 5060821 | 20240910211857_Sf77z | AU000Z | 2024-09-14T12:09:37.825Z | 2024-09-16T12:18:20.131Z |
5060170 | 5060170 | 20240910200042_HpjzG | AU000Z | 2024-09-14T12:08:26.259Z | 2024-09-16T12:18:13.774Z |
5059891 | 5059891 | 20240910191500_LzDeg | AU000Z | 2024-09-14T12:07:33.977Z | 2024-09-16T12:18:09.896Z |
5059827 | 5059827 | 20240910190041_Iz5k3 | AU000Z | 2024-09-14T12:07:21.402Z | 2024-09-16T12:18:09.067Z |
5059805 | 5059805 | 20240910185742_Gb3Bg | AU000Z | 2024-09-14T12:07:16.977Z | 2024-09-16T12:18:08.689Z |
5059797 | 5059797 | 20240910185501_1Yvco | AU000Z | 2024-09-14T12:07:14.646Z | 2024-09-16T12:18:08.631Z |
5059340 | 5059340 | 20240910173257_MwzLI | AU000Z | 2024-09-14T12:05:47.030Z | 2024-09-16T12:18:04.050Z |
5058506 | 5058506 | 20240910161812_7FXu9 | AU000Z | 2024-09-14T12:03:48.770Z | 2024-09-16T12:17:55.410Z |
5058462 | 5058462 | 20240910161424_nzGZ8 | AU000Z | 2024-09-14T12:03:44.780Z | 2024-09-16T12:17:54.844Z |
5058378 | 5058378 | 20240910160830_vOoDm | AU000Z | 2024-09-14T12:03:38.054Z | 2024-09-16T12:17:53.775Z |
5057996 | 5057996 | 20240910153505_Oo5s6 | AU000Z | 2024-09-14T12:02:35.446Z | 2024-09-16T12:17:49.223Z |
5057876 | 5057876 | 20240910152125_CK41m | AU000Z | 2024-09-14T12:02:17.973Z | 2024-09-16T12:17:48.093Z |
5057874 | 5057874 | 20240910152119_f8sZC | AU000Z | 2024-09-14T12:02:17.636Z | 2024-09-16T12:17:48.090Z |
5057037 | 5057037 | 20240908115831_YZQ2a | AU000Z | 2024-09-13T12:17:44.017Z | 2024-09-16T12:21:28.517Z |
5052217 | 5052217 | 20240907195933_HB4LO | AU000Z | 2024-09-13T12:15:00.584Z | 2024-09-16T12:21:04.634Z |
5052031 | 5052031 | 20240907192928_okjWE | AU000Z | 2024-09-13T12:14:54.116Z | 2024-09-16T12:21:03.254Z |
5051925 | 5051925 | 20240907190653_uubpN | AU000Z | 2024-09-13T12:14:45.882Z | 2024-09-16T12:21:02.509Z |
5051728 | 5051728 | 20240907183003_Xisst | AU000Z | 2024-09-13T12:14:31.770Z | 2024-09-16T12:21:01.676Z |
5051367 | 5051367 | 20240907172035_Ug8h7 | AU000Z | 2024-09-13T12:14:12.392Z | 2024-09-16T12:21:00.218Z |
5050824 | 5050824 | 20240907161316_N1gP1 | AU000Z | 2024-09-13T12:13:47.771Z | 2024-09-16T12:20:58.708Z |
5050743 | 5050743 | 20240907160330_DjLxC | AU000Z | 2024-09-13T12:13:45.717Z | 2024-09-16T12:20:58.400Z |
5050343 | 5050343 | 20240907151237_kF303 | AU000Z | 2024-09-13T12:13:26.731Z | 2024-09-16T12:20:57.348Z |
5050320 | 5050320 | 20240907150957_ac3vb | AU000Z | 2024-09-13T12:13:24.585Z | 2024-09-16T12:20:57.048Z |
5050221 | 5050221 | 20240907145041_1F5PN | AU000Z | 2024-09-13T12:13:18.645Z | 2024-09-16T12:20:56.742Z |
5049628 | 5049628 | 20240909112054_JNQtO | AU000Z | 2024-09-13T12:12:20.847Z | 2024-09-16T12:20:43.526Z |
5049594 | 5049594 | 20240909111659_YKF3p | AU000Z | 2024-09-13T12:12:19.411Z | 2024-09-16T12:20:43.376Z |
5044170 | 5044170 | 20240908142131_pw4GP | AU000Z | 2024-09-13T12:01:36.162Z | 2024-09-16T12:20:20.058Z |
5044144 | 5044144 | 20240908141821_7V2Zn | AU000Z | 2024-09-13T12:01:33.030Z | 2024-09-16T12:20:19.960Z |
5038520 | 5038520 | 20240905203622_JmMPa | AU000Z | 2024-09-12T12:14:45.264Z | 2024-09-14T12:22:56.327Z |
5035973 | 5035973 | 20240905121947_lVrQL | AU000Z | 2024-09-12T12:13:14.833Z | 2024-09-14T12:22:51.685Z |
5030903 | 5030903 | 20240906192513_pDVLs | AU000Z | 2024-09-12T12:03:21.811Z | 2024-09-15T12:21:20.348Z |
5030661 | 5030661 | 20240906172917_RaPG7 | AU000Z | 2024-09-12T12:02:35.594Z | 2024-09-15T12:21:19.428Z |
5030551 | 5030551 | 20240906165051_sM3E7 | AU000Z | 2024-09-12T12:02:20.637Z | 2024-09-15T12:21:19.067Z |
5030479 | 5030479 | 20240906160541_AnKHV | AU000Z | 2024-09-12T12:02:04.283Z | 2024-09-15T12:21:18.728Z |
5030272 | 5030272 | 20240906142219_YE3Gt | AU000Z | 2024-09-12T12:01:36.772Z | 2024-09-15T12:21:18.385Z |
5030217 | 5030217 | 20240906134531_F44es | AU000Z | 2024-09-12T12:01:30.006Z | 2024-09-15T12:21:18.276Z |
5030186 | 5030186 | 20240906133124_Hibic | AU000Z | 2024-09-12T12:01:21.866Z | 2024-09-15T12:21:18.193Z |
5029882 | 5029882 | 20240906114133_OmyAa | AU000Z | 2024-09-12T12:00:45.036Z | 2024-09-15T12:21:17.446Z |
5024118 | 5024118 | 20240905203622_CH3Ul | AU000Z | 2024-09-11T12:02:41.356Z | 2024-09-11T12:16:31.950Z |
5018497 | 5018497 | 20240904182741_p9GDp | AU000Z | 2024-09-10T12:10:43.336Z | 2024-09-13T12:19:47.968Z |
5014303 | 5014303 | 20240905121947_ssTMz | AU000Z | 2024-09-10T12:02:44.485Z | 2024-09-14T12:22:51.686Z |
5006654 | 5006654 | 20240903181915_zklSW | AU000Z | 2024-09-09T12:04:51.708Z | 2024-09-12T12:19:09.135Z |
5006642 | 5006642 | 20240903181408_AtP52 | AU000Z | 2024-09-09T12:04:50.841Z | 2024-09-12T12:19:09.120Z |
4996344 | 4996344 | 20240902192204_dZkaG | AU000Z | 2024-09-08T12:04:43.372Z | 2024-09-11T12:20:53.094Z |
4995962 | 4995962 | 20240902182040_9Cx3f | AU000Z | 2024-09-08T12:04:14.433Z | 2024-09-11T12:20:49.992Z |
4995921 | 4995921 | 20240902181039_JLm33 | AU000Z | 2024-09-08T12:04:11.793Z | 2024-09-11T12:20:49.630Z |
4995328 | 4995328 | 20240902164317_MleVZ | AU000Z | 2024-09-08T12:03:33.876Z | 2024-09-11T12:20:44.345Z |
4995294 | 4995294 | 20240902163738_EK8bd | AU000Z | 2024-09-08T12:03:31.966Z | 2024-09-11T12:20:43.330Z |
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);