participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
7,224 rows where station_code = "AU001F" 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 |
---|---|---|---|---|---|
5097064 | 5097064 | 20240912141124_PosUE | AU001F | 2024-09-16T12:16:43.913Z | 2024-09-16T12:17:32.018Z |
5097023 | 5097023 | 20240912134720_kGw5p | AU001F | 2024-09-16T12:16:42.516Z | 2024-09-16T12:17:32.002Z |
5097001 | 5097001 | 20240912132753_rttOO | AU001F | 2024-09-16T12:16:41.965Z | 2024-09-16T12:17:31.993Z |
5096955 | 5096955 | 20240912125229_6O714 | AU001F | 2024-09-16T12:16:40.308Z | 2024-09-16T12:17:31.977Z |
5096859 | 5096859 | 20240912115912_Sfk0q | AU001F | 2024-09-16T12:16:36.297Z | 2024-09-16T12:17:31.941Z |
5096586 | 5096586 | 20240912111805_qhxpR | AU001F | 2024-09-16T12:16:28.117Z | 2024-09-16T12:17:31.803Z |
5085348 | 5085348 | 20240912211240_7Q76Z | AU001F | 2024-09-16T12:04:07.783Z | 2024-09-16T12:17:04.700Z |
5085237 | 5085237 | 20240912210216_GyniH | AU001F | 2024-09-16T12:03:46.535Z | 2024-09-16T12:17:04.660Z |
5084417 | 5084417 | 20240912193712_1Xx3V | AU001F | 2024-09-16T12:02:03.650Z | 2024-09-16T12:17:04.299Z |
5084278 | 5084278 | 20240912190546_k1dBZ | AU001F | 2024-09-16T12:01:46.002Z | 2024-09-16T12:17:04.219Z |
5084265 | 5084265 | 20240912190405_zGrld | AU001F | 2024-09-16T12:01:43.546Z | 2024-09-16T12:17:04.210Z |
5084108 | 5084108 | 20240912181347_l37tO | AU001F | 2024-09-16T12:01:10.235Z | 2024-09-16T12:17:04.099Z |
5084039 | 5084039 | 20240912174441_JvPKQ | AU001F | 2024-09-16T12:00:58.884Z | 2024-09-16T12:17:04.056Z |
5083955 | 5083955 | 20240912170941_saQJo | AU001F | 2024-09-16T12:00:43.521Z | 2024-09-16T12:17:04.000Z |
5083864 | 5083864 | 20240912162607_vWQ32 | AU001F | 2024-09-16T12:00:32.943Z | 2024-09-16T12:17:03.952Z |
5083843 | 5083843 | 20240912161156_srXJG | AU001F | 2024-09-16T12:00:30.406Z | 2024-09-16T12:17:03.943Z |
5083735 | 5083735 | 20240911141456_QrJde | AU001F | 2024-09-15T12:18:45.863Z | 2024-09-16T12:19:20.411Z |
5083184 | 5083184 | 20240911122107_QEC3O | AU001F | 2024-09-15T12:18:36.639Z | 2024-09-16T12:19:17.163Z |
5082907 | 5082907 | 20240911112510_a94IB | AU001F | 2024-09-15T12:18:29.586Z | 2024-09-16T12:19:15.686Z |
5072305 | 5072305 | 20240911195500_HFPEm | AU001F | 2024-09-15T12:05:07.391Z | 2024-09-16T12:17:29.060Z |
5072247 | 5072247 | 20240911195117_sFyro | AU001F | 2024-09-15T12:04:58.791Z | 2024-09-16T12:17:29.053Z |
5072072 | 5072072 | 20240911192934_6EsOe | AU001F | 2024-09-15T12:04:36.164Z | 2024-09-16T12:17:29.019Z |
5072042 | 5072042 | 20240911192635_SDqkh | AU001F | 2024-09-15T12:04:31.808Z | 2024-09-16T12:17:29.011Z |
5071994 | 5071994 | 20240911191749_D6zIF | AU001F | 2024-09-15T12:04:15.421Z | 2024-09-16T12:17:28.999Z |
5071990 | 5071990 | 20240911191737_Adgmx | AU001F | 2024-09-15T12:04:14.939Z | 2024-09-16T12:17:28.998Z |
5071975 | 5071975 | 20240911191355_dpvY7 | AU001F | 2024-09-15T12:04:10.836Z | 2024-09-16T12:17:28.994Z |
5071882 | 5071882 | 20240911184718_Hb2sH | AU001F | 2024-09-15T12:03:55.243Z | 2024-09-16T12:17:28.967Z |
5071818 | 5071818 | 20240911182809_vi4Ut | AU001F | 2024-09-15T12:03:46.518Z | 2024-09-16T12:17:28.950Z |
5071787 | 5071787 | 20240911181926_VlRth | AU001F | 2024-09-15T12:03:33.336Z | 2024-09-16T12:17:28.942Z |
5071783 | 5071783 | 20240911181906_03u0y | AU001F | 2024-09-15T12:03:32.554Z | 2024-09-16T12:17:28.940Z |
5071738 | 5071738 | 20240911180505_F0Mwr | AU001F | 2024-09-15T12:03:22.295Z | 2024-09-16T12:17:28.917Z |
5071685 | 5071685 | 20240911175007_U29mS | AU001F | 2024-09-15T12:03:15.069Z | 2024-09-16T12:17:28.896Z |
5071557 | 5071557 | 20240911171559_sXbbN | AU001F | 2024-09-15T12:02:56.060Z | 2024-09-16T12:17:28.862Z |
5071274 | 5071274 | 20240911162633_lk5tG | AU001F | 2024-09-15T12:02:08.447Z | 2024-09-16T12:17:28.775Z |
5071037 | 5071037 | 20240911154824_qRyTW | AU001F | 2024-09-15T12:01:28.094Z | 2024-09-16T12:17:28.717Z |
5070712 | 5070712 | 20240911145737_AHcax | AU001F | 2024-09-15T12:00:39.939Z | 2024-09-16T12:17:28.651Z |
5070692 | 5070692 | 20240911145536_ozVcF | AU001F | 2024-09-15T12:00:36.141Z | 2024-09-16T12:17:28.646Z |
5068771 | 5068771 | 20240910122127_NqXe3 | AU001F | 2024-09-14T12:19:21.198Z | 2024-09-16T12:20:14.994Z |
5060809 | 5060809 | 20240910211321_zsSCC | AU001F | 2024-09-14T12:09:35.610Z | 2024-09-16T12:18:19.496Z |
5060137 | 5060137 | 20240910195619_woDqR | AU001F | 2024-09-14T12:08:16.707Z | 2024-09-16T12:18:13.478Z |
5060075 | 5060075 | 20240910194714_0jecS | AU001F | 2024-09-14T12:08:09.603Z | 2024-09-16T12:18:12.678Z |
5059778 | 5059778 | 20240910185208_cE24o | AU001F | 2024-09-14T12:07:10.953Z | 2024-09-16T12:18:08.351Z |
5059770 | 5059770 | 20240910184637_of2bL | AU001F | 2024-09-14T12:07:09.889Z | 2024-09-16T12:18:08.296Z |
5059736 | 5059736 | 20240910183923_zE1G1 | AU001F | 2024-09-14T12:06:56.622Z | 2024-09-16T12:18:07.990Z |
5059725 | 5059725 | 20240910183806_XBR0O | AU001F | 2024-09-14T12:06:53.865Z | 2024-09-16T12:18:07.906Z |
5059689 | 5059689 | 20240910183304_Dywhr | AU001F | 2024-09-14T12:06:46.545Z | 2024-09-16T12:18:07.666Z |
5059647 | 5059647 | 20240910182309_cXGq2 | AU001F | 2024-09-14T12:06:39.585Z | 2024-09-16T12:18:06.743Z |
5059627 | 5059627 | 20240910182058_kHQNV | AU001F | 2024-09-14T12:06:37.745Z | 2024-09-16T12:18:06.630Z |
5059608 | 5059608 | 20240910181713_2gbAy | AU001F | 2024-09-14T12:06:34.977Z | 2024-09-16T12:18:06.480Z |
5059563 | 5059563 | 20240910180820_N5Fcd | AU001F | 2024-09-14T12:06:27.795Z | 2024-09-16T12:18:06.080Z |
5059562 | 5059562 | 20240910180724_K3usA | AU001F | 2024-09-14T12:06:27.430Z | 2024-09-16T12:18:06.079Z |
5059520 | 5059520 | 20240910175933_32Elv | AU001F | 2024-09-14T12:06:16.186Z | 2024-09-16T12:18:05.676Z |
5059414 | 5059414 | 20240910173801_c5LIb | AU001F | 2024-09-14T12:05:53.465Z | 2024-09-16T12:18:04.572Z |
5059085 | 5059085 | 20240910171202_XOprz | AU001F | 2024-09-14T12:05:13.239Z | 2024-09-16T12:18:01.672Z |
5058955 | 5058955 | 20240910170324_ndM9C | AU001F | 2024-09-14T12:05:00.326Z | 2024-09-16T12:18:00.082Z |
5058766 | 5058766 | 20240910164302_uzMOD | AU001F | 2024-09-14T12:04:28.551Z | 2024-09-16T12:17:57.684Z |
5058748 | 5058748 | 20240910164101_EubdF | AU001F | 2024-09-14T12:04:26.423Z | 2024-09-16T12:17:57.547Z |
5058567 | 5058567 | 20240910162751_c03Cs | AU001F | 2024-09-14T12:04:01.403Z | 2024-09-16T12:17:56.081Z |
5057904 | 5057904 | 20240910152412_Nk21o | AU001F | 2024-09-14T12:02:22.567Z | 2024-09-16T12:17:48.269Z |
5057408 | 5057408 | 20240910142417_jIq3J | AU001F | 2024-09-14T12:01:00.802Z | 2024-09-16T12:17:43.639Z |
5057043 | 5057043 | 20240908120024_nvsX4 | AU001F | 2024-09-13T12:17:44.168Z | 2024-09-16T12:21:28.556Z |
5057008 | 5057008 | 20240908115138_sy17C | AU001F | 2024-09-13T12:17:43.475Z | 2024-09-16T12:21:28.422Z |
5056743 | 5056743 | 20240908111806_VAZPV | AU001F | 2024-09-13T12:17:38.869Z | 2024-09-16T12:21:27.090Z |
5049967 | 5049967 | 20240909120902_okvCD | AU001F | 2024-09-13T12:12:34.123Z | 2024-09-16T12:20:44.964Z |
5049931 | 5049931 | 20240909115951_ff5BN | AU001F | 2024-09-13T12:12:32.447Z | 2024-09-16T12:20:44.847Z |
5049771 | 5049771 | 20240909113828_Whsni | AU001F | 2024-09-13T12:12:25.796Z | 2024-09-16T12:20:44.136Z |
5045288 | 5045288 | 20240908164902_uooOB | AU001F | 2024-09-13T12:03:51.284Z | 2024-09-16T12:20:25.312Z |
5045252 | 5045252 | 20240908164426_LgLX1 | AU001F | 2024-09-13T12:03:47.091Z | 2024-09-16T12:20:25.237Z |
5045054 | 5045054 | 20240908161429_XaTUe | AU001F | 2024-09-13T12:03:29.180Z | 2024-09-16T12:20:24.409Z |
5045028 | 5045028 | 20240908160844_JhI3w | AU001F | 2024-09-13T12:03:25.939Z | 2024-09-16T12:20:24.332Z |
5044675 | 5044675 | 20240908152801_4V2Wh | AU001F | 2024-09-13T12:02:45.911Z | 2024-09-16T12:20:22.960Z |
5044400 | 5044400 | 20240908145648_8aF83 | AU001F | 2024-09-13T12:02:07.436Z | 2024-09-16T12:20:21.863Z |
5044381 | 5044381 | 20240908145344_UP4Wt | AU001F | 2024-09-13T12:02:05.034Z | 2024-09-16T12:20:21.820Z |
5044215 | 5044215 | 20240908142929_0O5qp | AU001F | 2024-09-13T12:01:41.960Z | 2024-09-16T12:20:20.570Z |
5038729 | 5038729 | 20240905213400_aBQhV | AU001F | 2024-09-12T12:14:57.013Z | 2024-09-14T12:22:57.400Z |
5038708 | 5038708 | 20240905212854_FZGSw | AU001F | 2024-09-12T12:14:55.531Z | 2024-09-14T12:22:57.298Z |
5038619 | 5038619 | 20240905211132_29fWc | AU001F | 2024-09-12T12:14:51.309Z | 2024-09-14T12:22:56.664Z |
5038590 | 5038590 | 20240905210405_NpyHn | AU001F | 2024-09-12T12:14:49.730Z | 2024-09-14T12:22:56.550Z |
5038495 | 5038495 | 20240905203033_NfAIj | AU001F | 2024-09-12T12:14:44.353Z | 2024-09-14T12:22:56.280Z |
5038424 | 5038424 | 20240905201046_00UHV | AU001F | 2024-09-12T12:14:39.406Z | 2024-09-14T12:22:55.987Z |
5038405 | 5038405 | 20240905200408_ex3C7 | AU001F | 2024-09-12T12:14:38.610Z | 2024-09-14T12:22:55.952Z |
5038300 | 5038300 | 20240905190559_JfMnQ | AU001F | 2024-09-12T12:14:32.173Z | 2024-09-14T12:22:55.545Z |
5038188 | 5038188 | 20240905173915_GBxt3 | AU001F | 2024-09-12T12:14:25.413Z | 2024-09-14T12:22:55.252Z |
5038096 | 5038096 | 20240905172310_T3By2 | AU001F | 2024-09-12T12:14:21.995Z | 2024-09-14T12:22:55.029Z |
5038076 | 5038076 | 20240905172149_zeDyS | AU001F | 2024-09-12T12:14:21.452Z | 2024-09-14T12:22:55.012Z |
5038019 | 5038019 | 20240905171603_VOlxv | AU001F | 2024-09-12T12:14:20.187Z | 2024-09-14T12:22:54.919Z |
5036813 | 5036813 | 20240905142910_6hGyH | AU001F | 2024-09-12T12:13:55.200Z | 2024-09-14T12:22:53.285Z |
5036628 | 5036628 | 20240905141111_luTTN | AU001F | 2024-09-12T12:13:50.814Z | 2024-09-14T12:22:53.068Z |
5036067 | 5036067 | 20240905123605_kt1Wq | AU001F | 2024-09-12T12:13:22.079Z | 2024-09-14T12:22:51.836Z |
5030496 | 5030496 | 20240906160912_F8iH9 | AU001F | 2024-09-12T12:02:06.766Z | 2024-09-15T12:21:18.757Z |
5030484 | 5030484 | 20240906160701_2LDPc | AU001F | 2024-09-12T12:02:05.207Z | 2024-09-15T12:21:18.736Z |
5030430 | 5030430 | 20240906154233_WeDWS | AU001F | 2024-09-12T12:01:56.235Z | 2024-09-15T12:21:18.563Z |
5030406 | 5030406 | 20240906153140_6llf3 | AU001F | 2024-09-12T12:01:52.945Z | 2024-09-15T12:21:18.542Z |
5030304 | 5030304 | 20240906144108_VPllv | AU001F | 2024-09-12T12:01:40.603Z | 2024-09-15T12:21:18.413Z |
5030288 | 5030288 | 20240906143033_K9Q38 | AU001F | 2024-09-12T12:01:38.936Z | 2024-09-15T12:21:18.400Z |
5030204 | 5030204 | 20240906134153_damC3 | AU001F | 2024-09-12T12:01:25.724Z | 2024-09-15T12:21:18.249Z |
5030193 | 5030193 | 20240906133639_f31K2 | AU001F | 2024-09-12T12:01:23.385Z | 2024-09-15T12:21:18.209Z |
5030178 | 5030178 | 20240906132746_qiM9l | AU001F | 2024-09-12T12:01:20.546Z | 2024-09-15T12:21:18.183Z |
5030164 | 5030164 | 20240906132108_58At1 | AU001F | 2024-09-12T12:01:18.420Z | 2024-09-15T12:21:18.163Z |
5024304 | 5024304 | 20240905213400_UpoTz | AU001F | 2024-09-11T12:03:17.305Z | 2024-09-11T12:16:32.058Z |
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);