participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
17,244 rows where station_code = "AU0002" 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 |
---|---|---|---|---|---|
5096944 | 5096944 | 20240912123905_2SJa5 | AU0002 | 2024-09-16T12:16:39.803Z | 2024-09-16T12:17:31.972Z |
5085358 | 5085358 | 20240912211411_kFIyT | AU0002 | 2024-09-16T12:04:08.893Z | 2024-09-16T12:17:04.705Z |
5085183 | 5085183 | 20240912205545_c9soe | AU0002 | 2024-09-16T12:03:40.149Z | 2024-09-16T12:17:04.633Z |
5085092 | 5085092 | 20240912204501_KNXl3 | AU0002 | 2024-09-16T12:03:31.013Z | 2024-09-16T12:17:04.580Z |
5084983 | 5084983 | 20240912203804_ohr1m | AU0002 | 2024-09-16T12:03:22.393Z | 2024-09-16T12:17:04.542Z |
5084891 | 5084891 | 20240912203207_rR7u8 | AU0002 | 2024-09-16T12:03:09.866Z | 2024-09-16T12:17:04.516Z |
5084823 | 5084823 | 20240912201654_S3ohr | AU0002 | 2024-09-16T12:02:58.221Z | 2024-09-16T12:17:04.470Z |
5084770 | 5084770 | 20240912201221_52IUa | AU0002 | 2024-09-16T12:02:53.066Z | 2024-09-16T12:17:04.449Z |
5084702 | 5084702 | 20240912200748_2RXid | AU0002 | 2024-09-16T12:02:49.523Z | 2024-09-16T12:17:04.430Z |
5084696 | 5084696 | 20240912200733_kUBCF | AU0002 | 2024-09-16T12:02:49.222Z | 2024-09-16T12:17:04.428Z |
5084676 | 5084676 | 20240912200406_lrdCH | AU0002 | 2024-09-16T12:02:46.054Z | 2024-09-16T12:17:04.416Z |
5084625 | 5084625 | 20240912195821_9AFWD | AU0002 | 2024-09-16T12:02:40.506Z | 2024-09-16T12:17:04.394Z |
5084273 | 5084273 | 20240912190445_ZdxyJ | AU0002 | 2024-09-16T12:01:45.260Z | 2024-09-16T12:17:04.216Z |
5084187 | 5084187 | 20240912185316_27zLR | AU0002 | 2024-09-16T12:01:30.009Z | 2024-09-16T12:17:04.167Z |
5084098 | 5084098 | 20240912180837_qK8iO | AU0002 | 2024-09-16T12:01:09.038Z | 2024-09-16T12:17:04.096Z |
5083979 | 5083979 | 20240912171352_c4vX2 | AU0002 | 2024-09-16T12:00:46.179Z | 2024-09-16T12:17:04.013Z |
5083966 | 5083966 | 20240912171152_hDL7x | AU0002 | 2024-09-16T12:00:44.843Z | 2024-09-16T12:17:04.006Z |
5083889 | 5083889 | 20240912163847_Gopfa | AU0002 | 2024-09-16T12:00:36.264Z | 2024-09-16T12:17:03.965Z |
5083790 | 5083790 | 20240912153535_q6uth | AU0002 | 2024-09-16T12:00:22.822Z | 2024-09-16T12:17:03.909Z |
5083667 | 5083667 | 20240911140935_x02qs | AU0002 | 2024-09-15T12:18:45.298Z | 2024-09-16T12:19:20.098Z |
5083527 | 5083527 | 20240911134127_kskys | AU0002 | 2024-09-15T12:18:43.372Z | 2024-09-16T12:19:19.395Z |
5083499 | 5083499 | 20240911133327_bkovf | AU0002 | 2024-09-15T12:18:42.754Z | 2024-09-16T12:19:18.723Z |
5083397 | 5083397 | 20240911130856_0KLhs | AU0002 | 2024-09-15T12:18:40.755Z | 2024-09-16T12:19:18.163Z |
5083285 | 5083285 | 20240911124616_hojaY | AU0002 | 2024-09-15T12:18:38.332Z | 2024-09-16T12:19:17.704Z |
5083107 | 5083107 | 20240911120545_IXKFN | AU0002 | 2024-09-15T12:18:35.848Z | 2024-09-16T12:19:16.682Z |
5073164 | 5073164 | 20240911210306_RNlwm | AU0002 | 2024-09-15T12:06:51.038Z | 2024-09-16T12:17:29.205Z |
5073064 | 5073064 | 20240911205732_EZKnM | AU0002 | 2024-09-15T12:06:35.631Z | 2024-09-16T12:17:29.193Z |
5073021 | 5073021 | 20240911205224_ko2nb | AU0002 | 2024-09-15T12:06:27.889Z | 2024-09-16T12:17:29.185Z |
5072935 | 5072935 | 20240911204821_FipKX | AU0002 | 2024-09-15T12:06:19.885Z | 2024-09-16T12:17:29.172Z |
5072858 | 5072858 | 20240911204403_yLohz | AU0002 | 2024-09-15T12:06:12.750Z | 2024-09-16T12:17:29.161Z |
5072817 | 5072817 | 20240911204134_6kkIe | AU0002 | 2024-09-15T12:06:09.553Z | 2024-09-16T12:17:29.153Z |
5072620 | 5072620 | 20240911203009_bpZtL | AU0002 | 2024-09-15T12:05:50.338Z | 2024-09-16T12:17:29.122Z |
5072584 | 5072584 | 20240911202425_TInpX | AU0002 | 2024-09-15T12:05:40.130Z | 2024-09-16T12:17:29.113Z |
5072444 | 5072444 | 20240911201014_KCKIr | AU0002 | 2024-09-15T12:05:23.948Z | 2024-09-16T12:17:29.087Z |
5072416 | 5072416 | 20240911200719_XI34e | AU0002 | 2024-09-15T12:05:20.592Z | 2024-09-16T12:17:29.080Z |
5072350 | 5072350 | 20240911195756_gNSXj | AU0002 | 2024-09-15T12:05:13.651Z | 2024-09-16T12:17:29.066Z |
5071958 | 5071958 | 20240911191101_4WAuR | AU0002 | 2024-09-15T12:04:08.241Z | 2024-09-16T12:17:28.990Z |
5071950 | 5071950 | 20240911191013_nl61n | AU0002 | 2024-09-15T12:04:06.570Z | 2024-09-16T12:17:28.987Z |
5071847 | 5071847 | 20240911183443_qkZ1L | AU0002 | 2024-09-15T12:03:50.094Z | 2024-09-16T12:17:28.957Z |
5071792 | 5071792 | 20240911182028_O6N4f | AU0002 | 2024-09-15T12:03:34.721Z | 2024-09-16T12:17:28.943Z |
5071753 | 5071753 | 20240911181042_3mrFf | AU0002 | 2024-09-15T12:03:25.397Z | 2024-09-16T12:17:28.921Z |
5071733 | 5071733 | 20240911180439_1DJjl | AU0002 | 2024-09-15T12:03:21.829Z | 2024-09-16T12:17:28.916Z |
5071675 | 5071675 | 20240911174340_chVe9 | AU0002 | 2024-09-15T12:03:13.401Z | 2024-09-16T12:17:28.893Z |
5071639 | 5071639 | 20240911173337_E5eLl | AU0002 | 2024-09-15T12:03:08.638Z | 2024-09-16T12:17:28.884Z |
5071581 | 5071581 | 20240911172148_834dl | AU0002 | 2024-09-15T12:03:00.983Z | 2024-09-16T12:17:28.869Z |
5071535 | 5071535 | 20240911171231_hgPDt | AU0002 | 2024-09-15T12:02:51.383Z | 2024-09-16T12:17:28.857Z |
5071373 | 5071373 | 20240911164318_cZr4N | AU0002 | 2024-09-15T12:02:23.986Z | 2024-09-16T12:17:28.795Z |
5070955 | 5070955 | 20240911153502_4UXjB | AU0002 | 2024-09-15T12:01:14.436Z | 2024-09-16T12:17:28.700Z |
5070832 | 5070832 | 20240911151500_U5dvy | AU0002 | 2024-09-15T12:00:58.606Z | 2024-09-16T12:17:28.673Z |
5070657 | 5070657 | 20240911144609_lftT5 | AU0002 | 2024-09-15T12:00:28.770Z | 2024-09-16T12:17:28.637Z |
5070534 | 5070534 | 20240911142817_GwMSl | AU0002 | 2024-09-15T12:00:15.940Z | 2024-09-16T12:17:28.613Z |
5068162 | 5068162 | 20240910110525_6oZzx | AU0002 | 2024-09-14T12:19:10.177Z | 2024-09-16T12:20:13.028Z |
5060838 | 5060838 | 20240910212859_t1r3H | AU0002 | 2024-09-14T12:09:45.298Z | 2024-09-16T12:18:21.499Z |
5060737 | 5060737 | 20240910205833_P6yE5 | AU0002 | 2024-09-14T12:09:26.696Z | 2024-09-16T12:18:18.291Z |
5060648 | 5060648 | 20240910204801_q4jOW | AU0002 | 2024-09-14T12:09:17.166Z | 2024-09-16T12:18:17.042Z |
5060181 | 5060181 | 20240910200335_QTEcx | AU0002 | 2024-09-14T12:08:27.267Z | 2024-09-16T12:18:13.799Z |
5060128 | 5060128 | 20240910195331_lehxE | AU0002 | 2024-09-14T12:08:14.608Z | 2024-09-16T12:18:13.387Z |
5060065 | 5060065 | 20240910194622_a768v | AU0002 | 2024-09-14T12:08:08.006Z | 2024-09-16T12:18:12.531Z |
5060026 | 5060026 | 20240910193515_D38hf | AU0002 | 2024-09-14T12:07:59.281Z | 2024-09-16T12:18:11.630Z |
5059935 | 5059935 | 20240910192028_Hhlnx | AU0002 | 2024-09-14T12:07:45.237Z | 2024-09-16T12:18:10.222Z |
5059931 | 5059931 | 20240910192016_3RuWP | AU0002 | 2024-09-14T12:07:44.420Z | 2024-09-16T12:18:10.212Z |
5059876 | 5059876 | 20240910191157_Zj7vY | AU0002 | 2024-09-14T12:07:30.820Z | 2024-09-16T12:18:09.649Z |
5059803 | 5059803 | 20240910185719_x5yfc | AU0002 | 2024-09-14T12:07:16.094Z | 2024-09-16T12:18:08.689Z |
5059774 | 5059774 | 20240910184905_Znthc | AU0002 | 2024-09-14T12:07:10.327Z | 2024-09-16T12:18:08.299Z |
5059768 | 5059768 | 20240910184637_MnI9F | AU0002 | 2024-09-14T12:07:09.594Z | 2024-09-16T12:18:08.295Z |
5059746 | 5059746 | 20240910184201_3PmWW | AU0002 | 2024-09-14T12:07:00.402Z | 2024-09-16T12:18:08.031Z |
5059179 | 5059179 | 20240910172023_qz6uJ | AU0002 | 2024-09-14T12:05:24.428Z | 2024-09-16T12:18:02.598Z |
5059159 | 5059159 | 20240910171758_TGr4M | AU0002 | 2024-09-14T12:05:21.047Z | 2024-09-16T12:18:02.393Z |
5058675 | 5058675 | 20240910163516_uUCZC | AU0002 | 2024-09-14T12:04:18.023Z | 2024-09-16T12:17:57.067Z |
5058664 | 5058664 | 20240910163433_OSvAR | AU0002 | 2024-09-14T12:04:17.268Z | 2024-09-16T12:17:56.906Z |
5058625 | 5058625 | 20240910163156_59wF8 | AU0002 | 2024-09-14T12:04:10.294Z | 2024-09-16T12:17:56.709Z |
5058582 | 5058582 | 20240910162836_S5kHC | AU0002 | 2024-09-14T12:04:03.313Z | 2024-09-16T12:17:56.233Z |
5058370 | 5058370 | 20240910160815_5ct8M | AU0002 | 2024-09-14T12:03:36.722Z | 2024-09-16T12:17:53.654Z |
5058170 | 5058170 | 20240910154952_pk3Oy | AU0002 | 2024-09-14T12:03:04.861Z | 2024-09-16T12:17:51.277Z |
5058035 | 5058035 | 20240910153830_zjDY2 | AU0002 | 2024-09-14T12:02:40.400Z | 2024-09-16T12:17:49.457Z |
5057968 | 5057968 | 20240910153214_CUBOn | AU0002 | 2024-09-14T12:02:30.802Z | 2024-09-16T12:17:48.969Z |
5057931 | 5057931 | 20240910152828_n25qc | AU0002 | 2024-09-14T12:02:26.716Z | 2024-09-16T12:17:48.695Z |
5056856 | 5056856 | 20240908113256_3TE0t | AU0002 | 2024-09-13T12:17:40.179Z | 2024-09-16T12:21:27.570Z |
5056722 | 5056722 | 20240908111256_Kftd6 | AU0002 | 2024-09-13T12:17:38.459Z | 2024-09-16T12:21:26.844Z |
5050135 | 5050135 | 20240907134953_GCM3K | AU0002 | 2024-09-13T12:13:04.740Z | 2024-09-16T12:20:55.472Z |
5044043 | 5044043 | 20240908140146_lpFPb | AU0002 | 2024-09-13T12:01:19.194Z | 2024-09-16T12:20:19.769Z |
5043728 | 5043728 | 20240908125317_2H1Um | AU0002 | 2024-09-13T12:00:31.911Z | 2024-09-16T12:20:18.727Z |
5038523 | 5038523 | 20240905203706_CxV20 | AU0002 | 2024-09-12T12:14:45.437Z | 2024-09-14T12:22:56.331Z |
5038498 | 5038498 | 20240905203034_1BAmK | AU0002 | 2024-09-12T12:14:44.364Z | 2024-09-14T12:22:56.284Z |
5038490 | 5038490 | 20240905203029_TUbSZ | AU0002 | 2024-09-12T12:14:44.338Z | 2024-09-14T12:22:56.279Z |
5038356 | 5038356 | 20240905194201_gOO9P | AU0002 | 2024-09-12T12:14:35.199Z | 2024-09-14T12:22:55.748Z |
5037842 | 5037842 | 20240905165652_tNwD9 | AU0002 | 2024-09-12T12:14:16.143Z | 2024-09-14T12:22:54.658Z |
5037665 | 5037665 | 20240905163237_05yUx | AU0002 | 2024-09-12T12:14:13.584Z | 2024-09-14T12:22:54.490Z |
5037140 | 5037140 | 20240905151433_as29h | AU0002 | 2024-09-12T12:14:01.565Z | 2024-09-14T12:22:53.785Z |
5036315 | 5036315 | 20240905131425_VmaLc | AU0002 | 2024-09-12T12:13:34.677Z | 2024-09-14T12:22:52.270Z |
5031260 | 5031260 | 20240906210423_3rKcb | AU0002 | 2024-09-12T12:04:24.102Z | 2024-09-15T12:21:21.863Z |
5031196 | 5031196 | 20240906205050_zG62J | AU0002 | 2024-09-12T12:04:16.584Z | 2024-09-15T12:21:21.691Z |
5031030 | 5031030 | 20240906200655_VfKTx | AU0002 | 2024-09-12T12:03:45.765Z | 2024-09-15T12:21:21.199Z |
5030955 | 5030955 | 20240906193926_XxMyP | AU0002 | 2024-09-12T12:03:31.590Z | 2024-09-15T12:21:20.533Z |
5030918 | 5030918 | 20240906192923_L39gs | AU0002 | 2024-09-12T12:03:24.514Z | 2024-09-15T12:21:20.394Z |
5030893 | 5030893 | 20240906192040_yKvb2 | AU0002 | 2024-09-12T12:03:20.935Z | 2024-09-15T12:21:20.309Z |
5030865 | 5030865 | 20240906191345_jXq1a | AU0002 | 2024-09-12T12:03:16.607Z | 2024-09-15T12:21:20.211Z |
5030745 | 5030745 | 20240906180405_loUIx | AU0002 | 2024-09-12T12:02:53.694Z | 2024-09-15T12:21:19.535Z |
5030718 | 5030718 | 20240906175650_6K2F4 | AU0002 | 2024-09-12T12:02:44.484Z | 2024-09-15T12:21:19.500Z |
5030696 | 5030696 | 20240906174512_N0c2B | AU0002 | 2024-09-12T12:02:41.464Z | 2024-09-15T12:21:19.477Z |
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);