participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,699 rows where station_code = "AU001V" 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 |
---|---|---|---|---|---|
5083547 | 5083547 | 20240911134624_YrxDl | AU001V | 2024-09-15T12:18:43.609Z | 2024-09-16T12:19:19.417Z |
5083523 | 5083523 | 20240911134056_MHVAh | AU001V | 2024-09-15T12:18:43.276Z | 2024-09-16T12:19:19.066Z |
5083412 | 5083412 | 20240911131316_jbN87 | AU001V | 2024-09-15T12:18:41.565Z | 2024-09-16T12:19:18.303Z |
5083289 | 5083289 | 20240911124637_NuJ3c | AU001V | 2024-09-15T12:18:38.458Z | 2024-09-16T12:19:17.706Z |
5082815 | 5082815 | 20240911110430_S771g | AU001V | 2024-09-15T12:18:26.177Z | 2024-09-16T12:19:14.501Z |
5073305 | 5073305 | 20240911211437_O7eUH | AU001V | 2024-09-15T12:07:02.618Z | 2024-09-16T12:17:29.229Z |
5073166 | 5073166 | 20240911210306_RNlwm | AU001V | 2024-09-15T12:06:51.038Z | 2024-09-16T12:17:29.205Z |
5073127 | 5073127 | 20240911210030_yIhx3 | AU001V | 2024-09-15T12:06:45.029Z | 2024-09-16T12:17:29.199Z |
5073035 | 5073035 | 20240911205456_P1kv1 | AU001V | 2024-09-15T12:06:30.647Z | 2024-09-16T12:17:29.189Z |
5072963 | 5072963 | 20240911205019_9V0Wf | AU001V | 2024-09-15T12:06:22.334Z | 2024-09-16T12:17:29.177Z |
5072759 | 5072759 | 20240911203945_mxJ6I | AU001V | 2024-09-15T12:06:06.509Z | 2024-09-16T12:17:29.147Z |
5072586 | 5072586 | 20240911202425_TInpX | AU001V | 2024-09-15T12:05:40.130Z | 2024-09-16T12:17:29.113Z |
5072488 | 5072488 | 20240911201317_xEgrC | AU001V | 2024-09-15T12:05:29.064Z | 2024-09-16T12:17:29.095Z |
5072339 | 5072339 | 20240911195623_0Bygx | AU001V | 2024-09-15T12:05:12.429Z | 2024-09-16T12:17:29.064Z |
5072282 | 5072282 | 20240911195309_sGks3 | AU001V | 2024-09-15T12:05:05.415Z | 2024-09-16T12:17:29.057Z |
5072064 | 5072064 | 20240911192804_2A63A | AU001V | 2024-09-15T12:04:34.655Z | 2024-09-16T12:17:29.016Z |
5072032 | 5072032 | 20240911192438_Y8sE2 | AU001V | 2024-09-15T12:04:28.588Z | 2024-09-16T12:17:29.008Z |
5071891 | 5071891 | 20240911185026_oQgbX | AU001V | 2024-09-15T12:03:56.962Z | 2024-09-16T12:17:28.970Z |
5071889 | 5071889 | 20240911184858_zPBjx | AU001V | 2024-09-15T12:03:56.642Z | 2024-09-16T12:17:28.969Z |
5071835 | 5071835 | 20240911183328_xsn6D | AU001V | 2024-09-15T12:03:48.255Z | 2024-09-16T12:17:28.954Z |
5071736 | 5071736 | 20240911180439_1DJjl | AU001V | 2024-09-15T12:03:21.829Z | 2024-09-16T12:17:28.916Z |
5071728 | 5071728 | 20240911180309_LcCGo | AU001V | 2024-09-15T12:03:20.921Z | 2024-09-16T12:17:28.914Z |
5071674 | 5071674 | 20240911174300_DS5xH | AU001V | 2024-09-15T12:03:13.022Z | 2024-09-16T12:17:28.893Z |
5071649 | 5071649 | 20240911173528_HYN7D | AU001V | 2024-09-15T12:03:10.035Z | 2024-09-16T12:17:28.887Z |
5071644 | 5071644 | 20240911173406_HEZLT | AU001V | 2024-09-15T12:03:09.265Z | 2024-09-16T12:17:28.885Z |
5071642 | 5071642 | 20240911173341_S5fid | AU001V | 2024-09-15T12:03:08.948Z | 2024-09-16T12:17:28.884Z |
5071640 | 5071640 | 20240911173337_E5eLl | AU001V | 2024-09-15T12:03:08.638Z | 2024-09-16T12:17:28.884Z |
5071614 | 5071614 | 20240911172809_gn3W3 | AU001V | 2024-09-15T12:03:04.662Z | 2024-09-16T12:17:28.876Z |
5071612 | 5071612 | 20240911172710_XRf7h | AU001V | 2024-09-15T12:03:04.252Z | 2024-09-16T12:17:28.876Z |
5071526 | 5071526 | 20240911171122_XHDrD | AU001V | 2024-09-15T12:02:48.329Z | 2024-09-16T12:17:28.854Z |
5071435 | 5071435 | 20240911165226_DdGr7 | AU001V | 2024-09-15T12:02:32.005Z | 2024-09-16T12:17:28.809Z |
5071360 | 5071360 | 20240911163831_7h3aL | AU001V | 2024-09-15T12:02:22.001Z | 2024-09-16T12:17:28.792Z |
5071339 | 5071339 | 20240911163503_ApwRC | AU001V | 2024-09-15T12:02:19.826Z | 2024-09-16T12:17:28.787Z |
5071329 | 5071329 | 20240911163420_9LkCL | AU001V | 2024-09-15T12:02:18.561Z | 2024-09-16T12:17:28.785Z |
5071090 | 5071090 | 20240911155936_iUFVk | AU001V | 2024-09-15T12:01:37.912Z | 2024-09-16T12:17:28.731Z |
5070982 | 5070982 | 20240911153746_2z2TP | AU001V | 2024-09-15T12:01:18.014Z | 2024-09-16T12:17:28.706Z |
5070958 | 5070958 | 20240911153502_4UXjB | AU001V | 2024-09-15T12:01:14.436Z | 2024-09-16T12:17:28.700Z |
5070937 | 5070937 | 20240911153034_0kCip | AU001V | 2024-09-15T12:01:11.628Z | 2024-09-16T12:17:28.695Z |
5070905 | 5070905 | 20240911152736_YY3zj | AU001V | 2024-09-15T12:01:07.418Z | 2024-09-16T12:17:28.687Z |
5070817 | 5070817 | 20240911151244_wM9qY | AU001V | 2024-09-15T12:00:56.427Z | 2024-09-16T12:17:28.669Z |
5070725 | 5070725 | 20240911150056_rFFp4 | AU001V | 2024-09-15T12:00:42.291Z | 2024-09-16T12:17:28.654Z |
5070632 | 5070632 | 20240911144311_81cld | AU001V | 2024-09-15T12:00:26.876Z | 2024-09-16T12:17:28.633Z |
5070592 | 5070592 | 20240911143633_x2Dkk | AU001V | 2024-09-15T12:00:22.009Z | 2024-09-16T12:17:28.624Z |
5068745 | 5068745 | 20240910121645_yBoqW | AU001V | 2024-09-14T12:19:20.988Z | 2024-09-16T12:20:14.956Z |
5063216 | 5063216 | 20240909202134_hfYGz | AU001V | 2024-09-14T12:13:42.983Z | 2024-09-16T12:19:42.696Z |
5063162 | 5063162 | 20240909200753_V4i4p | AU001V | 2024-09-14T12:13:35.525Z | 2024-09-16T12:19:42.277Z |
5063115 | 5063115 | 20240909195822_90nhy | AU001V | 2024-09-14T12:13:31.292Z | 2024-09-16T12:19:41.857Z |
5063101 | 5063101 | 20240909195139_LERmO | AU001V | 2024-09-14T12:13:28.013Z | 2024-09-16T12:19:41.735Z |
5062960 | 5062960 | 20240909192205_UmUDP | AU001V | 2024-09-14T12:13:09.153Z | 2024-09-16T12:19:40.615Z |
5062836 | 5062836 | 20240909183541_LyJYg | AU001V | 2024-09-14T12:12:56.223Z | 2024-09-16T12:19:39.779Z |
5062595 | 5062595 | 20240909174406_972eE | AU001V | 2024-09-14T12:12:35.601Z | 2024-09-16T12:19:37.976Z |
5062593 | 5062593 | 20240909174357_XcSnH | AU001V | 2024-09-14T12:12:35.383Z | 2024-09-16T12:19:37.949Z |
5062245 | 5062245 | 20240909170258_5fsxR | AU001V | 2024-09-14T12:11:59.388Z | 2024-09-16T12:19:36.711Z |
5062192 | 5062192 | 20240909165547_p3UNh | AU001V | 2024-09-14T12:11:54.827Z | 2024-09-16T12:19:36.354Z |
5061953 | 5061953 | 20240909162845_s0dRf | AU001V | 2024-09-14T12:11:41.331Z | 2024-09-16T12:19:34.928Z |
5061707 | 5061707 | 20240909154522_kfAFn | AU001V | 2024-09-14T12:11:13.555Z | 2024-09-16T12:19:33.213Z |
5061660 | 5061660 | 20240909153849_VHhQV | AU001V | 2024-09-14T12:11:08.141Z | 2024-09-16T12:19:32.963Z |
5061167 | 5061167 | 20240909142506_9VFvx | AU001V | 2024-09-14T12:10:24.380Z | 2024-09-16T12:19:29.445Z |
5060862 | 5060862 | 20240909130714_tMLpL | AU001V | 2024-09-14T12:09:50.319Z | 2024-09-16T12:19:27.776Z |
5059949 | 5059949 | 20240910192319_ymXux | AU001V | 2024-09-14T12:07:48.385Z | 2024-09-16T12:18:10.278Z |
5059741 | 5059741 | 20240910184139_ud0fG | AU001V | 2024-09-14T12:06:57.503Z | 2024-09-16T12:18:08.015Z |
5059697 | 5059697 | 20240910183338_g4mF0 | AU001V | 2024-09-14T12:06:47.203Z | 2024-09-16T12:18:07.691Z |
5059514 | 5059514 | 20240910175536_Y1cDr | AU001V | 2024-09-14T12:06:15.224Z | 2024-09-16T12:18:05.606Z |
5057210 | 5057210 | 20240910135848_cvh2S | AU001V | 2024-09-14T12:00:32.164Z | 2024-09-16T12:17:40.438Z |
5057015 | 5057015 | 20240908115313_5Hfg9 | AU001V | 2024-09-13T12:17:43.500Z | 2024-09-16T12:21:28.447Z |
5052473 | 5052473 | 20240907204919_1FLlB | AU001V | 2024-09-13T12:15:10.194Z | 2024-09-16T12:21:05.750Z |
5052444 | 5052444 | 20240907204331_0aI3B | AU001V | 2024-09-13T12:15:09.346Z | 2024-09-16T12:21:05.601Z |
5052393 | 5052393 | 20240907203204_xmzP0 | AU001V | 2024-09-13T12:15:07.297Z | 2024-09-16T12:21:05.356Z |
5052041 | 5052041 | 20240907193015_DDyd2 | AU001V | 2024-09-13T12:14:54.560Z | 2024-09-16T12:21:03.310Z |
5051975 | 5051975 | 20240907191727_FPjI3 | AU001V | 2024-09-13T12:14:51.078Z | 2024-09-16T12:21:02.666Z |
5051549 | 5051549 | 20240907174254_kMmlX | AU001V | 2024-09-13T12:14:22.820Z | 2024-09-16T12:21:01.186Z |
5051499 | 5051499 | 20240907173548_hnblC | AU001V | 2024-09-13T12:14:19.367Z | 2024-09-16T12:21:00.583Z |
5051436 | 5051436 | 20240907172717_lWM3A | AU001V | 2024-09-13T12:14:14.604Z | 2024-09-16T12:21:00.459Z |
5051150 | 5051150 | 20240907165406_dzoVN | AU001V | 2024-09-13T12:14:04.313Z | 2024-09-16T12:20:59.659Z |
5050615 | 5050615 | 20240907154754_TuVCl | AU001V | 2024-09-13T12:13:40.306Z | 2024-09-16T12:20:58.101Z |
5050265 | 5050265 | 20240907150039_sZ8W3 | AU001V | 2024-09-13T12:13:21.598Z | 2024-09-16T12:20:56.839Z |
5050241 | 5050241 | 20240907145755_37nAE | AU001V | 2024-09-13T12:13:20.212Z | 2024-09-16T12:20:56.805Z |
5049839 | 5049839 | 20240909114920_Mcsqo | AU001V | 2024-09-13T12:12:28.635Z | 2024-09-16T12:20:44.528Z |
5044619 | 5044619 | 20240908152339_pBYuY | AU001V | 2024-09-13T12:02:34.435Z | 2024-09-16T12:20:22.832Z |
5044614 | 5044614 | 20240908152154_BjVjU | AU001V | 2024-09-13T12:02:33.011Z | 2024-09-16T12:20:22.826Z |
5044279 | 5044279 | 20240908144022_h13Lv | AU001V | 2024-09-13T12:01:50.891Z | 2024-09-16T12:20:21.335Z |
5044174 | 5044174 | 20240908142144_oaB3z | AU001V | 2024-09-13T12:01:36.583Z | 2024-09-16T12:20:20.059Z |
5044076 | 5044076 | 20240908141106_Or3EN | AU001V | 2024-09-13T12:01:25.097Z | 2024-09-16T12:20:19.865Z |
5043952 | 5043952 | 20240908134105_qGLPa | AU001V | 2024-09-13T12:01:02.520Z | 2024-09-16T12:20:19.543Z |
5043731 | 5043731 | 20240908125317_2H1Um | AU001V | 2024-09-13T12:00:31.920Z | 2024-09-16T12:20:18.727Z |
5043722 | 5043722 | 20240908125108_QrYP2 | AU001V | 2024-09-13T12:00:30.336Z | 2024-09-16T12:20:18.708Z |
5043565 | 5043565 | 20240907112926_oO2pL | AU001V | 2024-09-12T12:17:36.767Z | 2024-09-15T12:21:42.112Z |
5043247 | 5043247 | 20240907141416_E4lJ1 | AU001V | 2024-09-12T12:17:25.704Z | 2024-09-16T12:20:56.037Z |
5043058 | 5043058 | 20240907134347_XR2Nn | AU001V | 2024-09-12T12:17:22.320Z | 2024-09-16T12:20:55.264Z |
5042727 | 5042727 | 20240907123243_grMw7 | AU001V | 2024-09-12T12:17:17.415Z | 2024-09-16T12:20:53.990Z |
5042611 | 5042611 | 20240907120909_262d9 | AU001V | 2024-09-12T12:17:15.670Z | 2024-09-16T12:20:53.722Z |
5042553 | 5042553 | 20240907120128_UTBSH | AU001V | 2024-09-12T12:17:15.014Z | 2024-09-16T12:20:53.592Z |
5038562 | 5038562 | 20240905205433_WSXa2 | AU001V | 2024-09-12T12:14:47.883Z | 2024-09-14T12:22:56.410Z |
5038539 | 5038539 | 20240905204650_5HNNJ | AU001V | 2024-09-12T12:14:46.070Z | 2024-09-14T12:22:56.367Z |
5038480 | 5038480 | 20240905202729_tVdh9 | AU001V | 2024-09-12T12:14:43.769Z | 2024-09-14T12:22:56.224Z |
5038329 | 5038329 | 20240905192818_cbP3e | AU001V | 2024-09-12T12:14:33.618Z | 2024-09-14T12:22:55.589Z |
5038326 | 5038326 | 20240905192511_i2Bez | AU001V | 2024-09-12T12:14:33.534Z | 2024-09-14T12:22:55.586Z |
5038238 | 5038238 | 20240905175415_38IkW | AU001V | 2024-09-12T12:14:27.913Z | 2024-09-14T12:22:55.358Z |
5038220 | 5038220 | 20240905174900_a54PS | AU001V | 2024-09-12T12:14:26.370Z | 2024-09-14T12:22:55.337Z |
5038197 | 5038197 | 20240905174140_AOO6y | AU001V | 2024-09-12T12:14:25.517Z | 2024-09-14T12:22:55.256Z |
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);