participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
11,220 rows where station_code = "AU000F" 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 |
---|---|---|---|---|---|
5097119 | 5097119 | 20240912144441_yCVmT | AU000F | 2024-09-16T12:16:45.641Z | 2024-09-16T12:17:32.039Z |
5097011 | 5097011 | 20240912133850_Xn4Ko | AU000F | 2024-09-16T12:16:42.288Z | 2024-09-16T12:17:31.997Z |
5096988 | 5096988 | 20240912132228_bqMqv | AU000F | 2024-09-16T12:16:41.757Z | 2024-09-16T12:17:31.990Z |
5096903 | 5096903 | 20240912120939_NJ1va | AU000F | 2024-09-16T12:16:37.072Z | 2024-09-16T12:17:31.956Z |
5096677 | 5096677 | 20240912112947_o1835 | AU000F | 2024-09-16T12:16:31.422Z | 2024-09-16T12:17:31.849Z |
5085390 | 5085390 | 20240912211831_AUdda | AU000F | 2024-09-16T12:04:12.940Z | 2024-09-16T12:17:04.725Z |
5085189 | 5085189 | 20240912205626_wbg3j | AU000F | 2024-09-16T12:03:40.887Z | 2024-09-16T12:17:04.636Z |
5085097 | 5085097 | 20240912204520_sLpHu | AU000F | 2024-09-16T12:03:31.653Z | 2024-09-16T12:17:04.584Z |
5084634 | 5084634 | 20240912195930_xZ0Iw | AU000F | 2024-09-16T12:02:41.319Z | 2024-09-16T12:17:04.397Z |
5084616 | 5084616 | 20240912195709_n2XmW | AU000F | 2024-09-16T12:02:39.247Z | 2024-09-16T12:17:04.391Z |
5084587 | 5084587 | 20240912195345_BNGcS | AU000F | 2024-09-16T12:02:35.298Z | 2024-09-16T12:17:04.370Z |
5084516 | 5084516 | 20240912194549_2ewUB | AU000F | 2024-09-16T12:02:12.615Z | 2024-09-16T12:17:04.334Z |
5084352 | 5084352 | 20240912192632_eATSL | AU000F | 2024-09-16T12:01:56.255Z | 2024-09-16T12:17:04.262Z |
5084306 | 5084306 | 20240912191433_Qi0NM | AU000F | 2024-09-16T12:01:50.674Z | 2024-09-16T12:17:04.240Z |
5084254 | 5084254 | 20240912190333_ema46 | AU000F | 2024-09-16T12:01:42.581Z | 2024-09-16T12:17:04.205Z |
5084238 | 5084238 | 20240912190208_efzHY | AU000F | 2024-09-16T12:01:38.333Z | 2024-09-16T12:17:04.196Z |
5084213 | 5084213 | 20240912185914_cy1FI | AU000F | 2024-09-16T12:01:35.492Z | 2024-09-16T12:17:04.184Z |
5084168 | 5084168 | 20240912184240_jpzqL | AU000F | 2024-09-16T12:01:23.260Z | 2024-09-16T12:17:04.150Z |
5083999 | 5083999 | 20240912173228_ssPwE | AU000F | 2024-09-16T12:00:53.693Z | 2024-09-16T12:17:04.024Z |
5083953 | 5083953 | 20240912170941_saQJo | AU000F | 2024-09-16T12:00:43.520Z | 2024-09-16T12:17:04.000Z |
5083948 | 5083948 | 20240912170654_Rb4gB | AU000F | 2024-09-16T12:00:42.925Z | 2024-09-16T12:17:03.997Z |
5083928 | 5083928 | 20240912165151_Xk6S1 | AU000F | 2024-09-16T12:00:40.474Z | 2024-09-16T12:17:03.987Z |
5083907 | 5083907 | 20240912164102_mkZ1Z | AU000F | 2024-09-16T12:00:38.006Z | 2024-09-16T12:17:03.972Z |
5083892 | 5083892 | 20240912163902_Xs5Q8 | AU000F | 2024-09-16T12:00:36.647Z | 2024-09-16T12:17:03.966Z |
5083874 | 5083874 | 20240912163015_2BKC4 | AU000F | 2024-09-16T12:00:34.398Z | 2024-09-16T12:17:03.958Z |
5083814 | 5083814 | 20240912155424_liNvU | AU000F | 2024-09-16T12:00:26.239Z | 2024-09-16T12:17:03.923Z |
5083799 | 5083799 | 20240912154434_x4iz0 | AU000F | 2024-09-16T12:00:24.266Z | 2024-09-16T12:17:03.916Z |
5083779 | 5083779 | 20240912152710_WkmdH | AU000F | 2024-09-16T12:00:21.138Z | 2024-09-16T12:17:03.903Z |
5083309 | 5083309 | 20240911125218_HO3J3 | AU000F | 2024-09-15T12:18:38.717Z | 2024-09-16T12:19:17.908Z |
5083238 | 5083238 | 20240911123538_CymLF | AU000F | 2024-09-15T12:18:37.402Z | 2024-09-16T12:19:17.450Z |
5083112 | 5083112 | 20240911120554_3lWIp | AU000F | 2024-09-15T12:18:35.886Z | 2024-09-16T12:19:16.727Z |
5082873 | 5082873 | 20240911111802_LD30M | AU000F | 2024-09-15T12:18:28.493Z | 2024-09-16T12:19:15.323Z |
5073421 | 5073421 | 20240911212255_3WlFK | AU000F | 2024-09-15T12:07:09.498Z | 2024-09-16T12:17:29.244Z |
5073368 | 5073368 | 20240911211729_YWTk7 | AU000F | 2024-09-15T12:07:06.471Z | 2024-09-16T12:17:29.238Z |
5073306 | 5073306 | 20240911211437_FHOEY | AU000F | 2024-09-15T12:07:02.921Z | 2024-09-16T12:17:29.229Z |
5073215 | 5073215 | 20240911210613_n5maE | AU000F | 2024-09-15T12:06:55.406Z | 2024-09-16T12:17:29.214Z |
5072676 | 5072676 | 20240911203625_NhaV8 | AU000F | 2024-09-15T12:06:00.596Z | 2024-09-16T12:17:29.134Z |
5072558 | 5072558 | 20240911202339_SHxg3 | AU000F | 2024-09-15T12:05:38.103Z | 2024-09-16T12:17:29.110Z |
5072340 | 5072340 | 20240911195624_w520t | AU000F | 2024-09-15T12:05:12.839Z | 2024-09-16T12:17:29.065Z |
5072191 | 5072191 | 20240911194706_AIkJZ | AU000F | 2024-09-15T12:04:52.088Z | 2024-09-16T12:17:29.044Z |
5072091 | 5072091 | 20240911193300_w9SH5 | AU000F | 2024-09-15T12:04:38.405Z | 2024-09-16T12:17:29.023Z |
5072054 | 5072054 | 20240911192708_yWXM9 | AU000F | 2024-09-15T12:04:33.163Z | 2024-09-16T12:17:29.013Z |
5072023 | 5072023 | 20240911192356_5JVro | AU000F | 2024-09-15T12:04:24.568Z | 2024-09-16T12:17:29.007Z |
5071830 | 5071830 | 20240911183227_HWxQz | AU000F | 2024-09-15T12:03:47.930Z | 2024-09-16T12:17:28.953Z |
5071824 | 5071824 | 20240911182945_OW4Mp | AU000F | 2024-09-15T12:03:47.378Z | 2024-09-16T12:17:28.951Z |
5071799 | 5071799 | 20240911182338_nZwxl | AU000F | 2024-09-15T12:03:38.759Z | 2024-09-16T12:17:28.945Z |
5071771 | 5071771 | 20240911181504_eOV0U | AU000F | 2024-09-15T12:03:29.561Z | 2024-09-16T12:17:28.936Z |
5071764 | 5071764 | 20240911181401_xX5gd | AU000F | 2024-09-15T12:03:27.853Z | 2024-09-16T12:17:28.924Z |
5071699 | 5071699 | 20240911175431_Ocphq | AU000F | 2024-09-15T12:03:17.069Z | 2024-09-16T12:17:28.900Z |
5071457 | 5071457 | 20240911165819_7wAXE | AU000F | 2024-09-15T12:02:36.393Z | 2024-09-16T12:17:28.836Z |
5071291 | 5071291 | 20240911162959_BvMHF | AU000F | 2024-09-15T12:02:11.204Z | 2024-09-16T12:17:28.778Z |
5071219 | 5071219 | 20240911161746_rS5V0 | AU000F | 2024-09-15T12:01:57.187Z | 2024-09-16T12:17:28.761Z |
5071095 | 5071095 | 20240911160013_kynh7 | AU000F | 2024-09-15T12:01:39.219Z | 2024-09-16T12:17:28.733Z |
5070969 | 5070969 | 20240911153623_kKJdz | AU000F | 2024-09-15T12:01:16.614Z | 2024-09-16T12:17:28.703Z |
5070964 | 5070964 | 20240911153611_6HzsZ | AU000F | 2024-09-15T12:01:15.565Z | 2024-09-16T12:17:28.702Z |
5070772 | 5070772 | 20240911151032_R1EtO | AU000F | 2024-09-15T12:00:47.640Z | 2024-09-16T12:17:28.663Z |
5070470 | 5070470 | 20240909125821_QQqd3 | AU000F | 2024-09-14T12:21:21.990Z | 2024-09-16T12:20:45.831Z |
5068851 | 5068851 | 20240910124838_jDopk | AU000F | 2024-09-14T12:19:22.140Z | 2024-09-16T12:20:15.452Z |
5068326 | 5068326 | 20240910112053_xMyxt | AU000F | 2024-09-14T12:19:12.272Z | 2024-09-16T12:20:13.477Z |
5062778 | 5062778 | 20240909182319_su3a5 | AU000F | 2024-09-14T12:12:50.306Z | 2024-09-16T12:19:39.560Z |
5062596 | 5062596 | 20240909174501_Dkoib | AU000F | 2024-09-14T12:12:35.849Z | 2024-09-16T12:19:37.985Z |
5062447 | 5062447 | 20240909172708_XkQzw | AU000F | 2024-09-14T12:12:23.003Z | 2024-09-16T12:19:37.441Z |
5062377 | 5062377 | 20240909171702_tRN8p | AU000F | 2024-09-14T12:12:14.991Z | 2024-09-16T12:19:37.126Z |
5062373 | 5062373 | 20240909171655_L6qJw | AU000F | 2024-09-14T12:12:14.467Z | 2024-09-16T12:19:37.125Z |
5061886 | 5061886 | 20240909161820_957zu | AU000F | 2024-09-14T12:11:35.906Z | 2024-09-16T12:19:34.452Z |
5061838 | 5061838 | 20240909160707_AjLyz | AU000F | 2024-09-14T12:11:31.560Z | 2024-09-16T12:19:34.021Z |
5061661 | 5061661 | 20240909153858_MOMYk | AU000F | 2024-09-14T12:11:08.327Z | 2024-09-16T12:19:32.963Z |
5061485 | 5061485 | 20240909151403_mNmqS | AU000F | 2024-09-14T12:10:52.630Z | 2024-09-16T12:19:31.762Z |
5061477 | 5061477 | 20240909151217_T7M2e | AU000F | 2024-09-14T12:10:52.267Z | 2024-09-16T12:19:31.749Z |
5061307 | 5061307 | 20240909144434_6Axzc | AU000F | 2024-09-14T12:10:41.198Z | 2024-09-16T12:19:30.457Z |
5061299 | 5061299 | 20240909144323_HJXYK | AU000F | 2024-09-14T12:10:40.845Z | 2024-09-16T12:19:30.411Z |
5061287 | 5061287 | 20240909144150_LOaOG | AU000F | 2024-09-14T12:10:40.203Z | 2024-09-16T12:19:30.308Z |
5061280 | 5061280 | 20240909144037_HZvP7 | AU000F | 2024-09-14T12:10:39.970Z | 2024-09-16T12:19:30.291Z |
5061161 | 5061161 | 20240909142357_3F0i5 | AU000F | 2024-09-14T12:10:24.060Z | 2024-09-16T12:19:29.444Z |
5060827 | 5060827 | 20240910212437_8m7Xa | AU000F | 2024-09-14T12:09:39.168Z | 2024-09-16T12:18:20.586Z |
5060814 | 5060814 | 20240910211416_aq2us | AU000F | 2024-09-14T12:09:35.858Z | 2024-09-16T12:18:19.649Z |
5060664 | 5060664 | 20240910205115_srSxI | AU000F | 2024-09-14T12:09:19.721Z | 2024-09-16T12:18:17.337Z |
5060166 | 5060166 | 20240910200042_Jn8AP | AU000F | 2024-09-14T12:08:25.893Z | 2024-09-16T12:18:13.773Z |
5059893 | 5059893 | 20240910191500_EAncF | AU000F | 2024-09-14T12:07:34.155Z | 2024-09-16T12:18:09.914Z |
5059824 | 5059824 | 20240910190041_bLwex | AU000F | 2024-09-14T12:07:21.145Z | 2024-09-16T12:18:09.057Z |
5059799 | 5059799 | 20240910185501_YPxit | AU000F | 2024-09-14T12:07:14.857Z | 2024-09-16T12:18:08.634Z |
5059676 | 5059676 | 20240910182947_xGKaA | AU000F | 2024-09-14T12:06:44.512Z | 2024-09-16T12:18:07.459Z |
5059561 | 5059561 | 20240910180724_K3usA | AU000F | 2024-09-14T12:06:27.430Z | 2024-09-16T12:18:06.079Z |
5059328 | 5059328 | 20240910173159_nR9rA | AU000F | 2024-09-14T12:05:45.883Z | 2024-09-16T12:18:03.997Z |
5059320 | 5059320 | 20240910173046_ikBoL | AU000F | 2024-09-14T12:05:44.179Z | 2024-09-16T12:18:03.862Z |
5059250 | 5059250 | 20240910172629_3i2uE | AU000F | 2024-09-14T12:05:31.516Z | 2024-09-16T12:18:03.072Z |
5059186 | 5059186 | 20240910172058_Du3SC | AU000F | 2024-09-14T12:05:25.128Z | 2024-09-16T12:18:02.672Z |
5058613 | 5058613 | 20240910163150_mM45G | AU000F | 2024-09-14T12:04:09.286Z | 2024-09-16T12:17:56.487Z |
5058589 | 5058589 | 20240910162937_Pqlu8 | AU000F | 2024-09-14T12:04:04.490Z | 2024-09-16T12:17:56.301Z |
5058527 | 5058527 | 20240910161944_fEBfr | AU000F | 2024-09-14T12:03:51.295Z | 2024-09-16T12:17:55.672Z |
5058503 | 5058503 | 20240910161812_AL0BO | AU000F | 2024-09-14T12:03:48.535Z | 2024-09-16T12:17:55.398Z |
5058464 | 5058464 | 20240910161424_MdDUx | AU000F | 2024-09-14T12:03:45.094Z | 2024-09-16T12:17:54.847Z |
5058380 | 5058380 | 20240910160831_TxXde | AU000F | 2024-09-14T12:03:38.355Z | 2024-09-16T12:17:53.801Z |
5058292 | 5058292 | 20240910160131_advcP | AU000F | 2024-09-14T12:03:21.484Z | 2024-09-16T12:17:52.483Z |
5057998 | 5057998 | 20240910153505_jwRos | AU000F | 2024-09-14T12:02:35.779Z | 2024-09-16T12:17:49.233Z |
5057766 | 5057766 | 20240910151117_zXgSX | AU000F | 2024-09-14T12:01:55.139Z | 2024-09-16T12:17:47.174Z |
5057737 | 5057737 | 20240910150750_iRFtY | AU000F | 2024-09-14T12:01:50.988Z | 2024-09-16T12:17:46.843Z |
5057266 | 5057266 | 20240910140626_e2hvh | AU000F | 2024-09-14T12:00:42.675Z | 2024-09-16T12:17:41.954Z |
5057168 | 5057168 | 20240910135223_wXzWF | AU000F | 2024-09-14T12:00:24.811Z | 2024-09-16T12:17:39.794Z |
5052645 | 5052645 | 20240907212115_TfySo | AU000F | 2024-09-13T12:15:17.011Z | 2024-09-16T12:21:06.926Z |
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);