participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
9,215 rows where station_code = "AU000X" 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 |
---|---|---|---|---|---|
5097124 | 5097124 | 20240912145303_XYKNk | AU000X | 2024-09-16T12:16:45.659Z | 2024-09-16T12:17:32.040Z |
5097102 | 5097102 | 20240912143753_2pU7R | AU000X | 2024-09-16T12:16:45.140Z | 2024-09-16T12:17:32.033Z |
5097079 | 5097079 | 20240912142155_EFTZ8 | AU000X | 2024-09-16T12:16:44.447Z | 2024-09-16T12:17:32.024Z |
5097073 | 5097073 | 20240912142008_pGvBj | AU000X | 2024-09-16T12:16:44.305Z | 2024-09-16T12:17:32.022Z |
5097053 | 5097053 | 20240912140718_lamCW | AU000X | 2024-09-16T12:16:43.663Z | 2024-09-16T12:17:32.014Z |
5096970 | 5096970 | 20240912131455_7UTP0 | AU000X | 2024-09-16T12:16:40.988Z | 2024-09-16T12:17:31.984Z |
5085541 | 5085541 | 20240912212809_I2wv5 | AU000X | 2024-09-16T12:04:23.005Z | 2024-09-16T12:17:04.778Z |
5085235 | 5085235 | 20240912210216_GyniH | AU000X | 2024-09-16T12:03:46.535Z | 2024-09-16T12:17:04.660Z |
5084984 | 5084984 | 20240912203804_ohr1m | AU000X | 2024-09-16T12:03:22.393Z | 2024-09-16T12:17:04.542Z |
5084981 | 5084981 | 20240912203747_Rkdca | AU000X | 2024-09-16T12:03:22.050Z | 2024-09-16T12:17:04.540Z |
5084892 | 5084892 | 20240912203207_rR7u8 | AU000X | 2024-09-16T12:03:09.866Z | 2024-09-16T12:17:04.516Z |
5084661 | 5084661 | 20240912200153_MUpUK | AU000X | 2024-09-16T12:02:44.686Z | 2024-09-16T12:17:04.409Z |
5084414 | 5084414 | 20240912193712_1Xx3V | AU000X | 2024-09-16T12:02:03.650Z | 2024-09-16T12:17:04.299Z |
5084412 | 5084412 | 20240912193620_sa262 | AU000X | 2024-09-16T12:02:03.351Z | 2024-09-16T12:17:04.297Z |
5084286 | 5084286 | 20240912191017_vdDwD | AU000X | 2024-09-16T12:01:47.769Z | 2024-09-16T12:17:04.225Z |
5084277 | 5084277 | 20240912190546_k1dBZ | AU000X | 2024-09-16T12:01:46.002Z | 2024-09-16T12:17:04.219Z |
5084221 | 5084221 | 20240912185926_zn9mq | AU000X | 2024-09-16T12:01:36.155Z | 2024-09-16T12:17:04.187Z |
5084115 | 5084115 | 20240912181712_FcViC | AU000X | 2024-09-16T12:01:11.375Z | 2024-09-16T12:17:04.103Z |
5084107 | 5084107 | 20240912181347_l37tO | AU000X | 2024-09-16T12:01:10.235Z | 2024-09-16T12:17:04.099Z |
5084082 | 5084082 | 20240912180325_g3n66 | AU000X | 2024-09-16T12:01:06.439Z | 2024-09-16T12:17:04.085Z |
5083959 | 5083959 | 20240912171122_Vn11d | AU000X | 2024-09-16T12:00:44.123Z | 2024-09-16T12:17:04.003Z |
5083937 | 5083937 | 20240912170044_uxZ38 | AU000X | 2024-09-16T12:00:42.007Z | 2024-09-16T12:17:03.993Z |
5083866 | 5083866 | 20240912162639_zw3wC | AU000X | 2024-09-16T12:00:33.356Z | 2024-09-16T12:17:03.954Z |
5083150 | 5083150 | 20240911121526_czfOD | AU000X | 2024-09-15T12:18:36.235Z | 2024-09-16T12:19:16.943Z |
5082964 | 5082964 | 20240911113646_Angyg | AU000X | 2024-09-15T12:18:31.903Z | 2024-09-16T12:19:16.151Z |
5082874 | 5082874 | 20240911111802_LD30M | AU000X | 2024-09-15T12:18:28.493Z | 2024-09-16T12:19:15.323Z |
5073514 | 5073514 | 20240911212849_qYwuo | AU000X | 2024-09-15T12:07:14.924Z | 2024-09-16T12:17:29.255Z |
5073450 | 5073450 | 20240911212516_kTf2Y | AU000X | 2024-09-15T12:07:11.243Z | 2024-09-16T12:17:29.248Z |
5073415 | 5073415 | 20240911212015_LYdu3 | AU000X | 2024-09-15T12:07:09.149Z | 2024-09-16T12:17:29.243Z |
5072936 | 5072936 | 20240911204821_FipKX | AU000X | 2024-09-15T12:06:19.885Z | 2024-09-16T12:17:29.172Z |
5072594 | 5072594 | 20240911202750_8pmLm | AU000X | 2024-09-15T12:05:43.066Z | 2024-09-16T12:17:29.116Z |
5072559 | 5072559 | 20240911202339_SHxg3 | AU000X | 2024-09-15T12:05:38.103Z | 2024-09-16T12:17:29.110Z |
5072438 | 5072438 | 20240911201005_LOCV7 | AU000X | 2024-09-15T12:05:23.263Z | 2024-09-16T12:17:29.085Z |
5072405 | 5072405 | 20240911200356_JDgU9 | AU000X | 2024-09-15T12:05:18.808Z | 2024-09-16T12:17:29.076Z |
5072342 | 5072342 | 20240911195624_w520t | AU000X | 2024-09-15T12:05:12.839Z | 2024-09-16T12:17:29.065Z |
5072303 | 5072303 | 20240911195500_HFPEm | AU000X | 2024-09-15T12:05:07.391Z | 2024-09-16T12:17:29.060Z |
5072245 | 5072245 | 20240911195117_sFyro | AU000X | 2024-09-15T12:04:58.783Z | 2024-09-16T12:17:29.053Z |
5072134 | 5072134 | 20240911194048_rniJn | AU000X | 2024-09-15T12:04:44.817Z | 2024-09-16T12:17:29.033Z |
5072071 | 5072071 | 20240911192934_6EsOe | AU000X | 2024-09-15T12:04:36.164Z | 2024-09-16T12:17:29.019Z |
5071876 | 5071876 | 20240911184638_73Kic | AU000X | 2024-09-15T12:03:54.547Z | 2024-09-16T12:17:28.965Z |
5071842 | 5071842 | 20240911183416_VBHli | AU000X | 2024-09-15T12:03:49.419Z | 2024-09-16T12:17:28.956Z |
5071737 | 5071737 | 20240911180505_F0Mwr | AU000X | 2024-09-15T12:03:22.295Z | 2024-09-16T12:17:28.917Z |
5071703 | 5071703 | 20240911175525_PjHEK | AU000X | 2024-09-15T12:03:17.418Z | 2024-09-16T12:17:28.900Z |
5071695 | 5071695 | 20240911175257_pnoqM | AU000X | 2024-09-15T12:03:16.761Z | 2024-09-16T12:17:28.899Z |
5071683 | 5071683 | 20240911174852_2LDkt | AU000X | 2024-09-15T12:03:14.631Z | 2024-09-16T12:17:28.896Z |
5071654 | 5071654 | 20240911173703_WZGHT | AU000X | 2024-09-15T12:03:11.275Z | 2024-09-16T12:17:28.889Z |
5071609 | 5071609 | 20240911172552_2DjGD | AU000X | 2024-09-15T12:03:03.920Z | 2024-09-16T12:17:28.875Z |
5071335 | 5071335 | 20240911163501_4uxsV | AU000X | 2024-09-15T12:02:19.444Z | 2024-09-16T12:17:28.786Z |
5071273 | 5071273 | 20240911162633_lk5tG | AU000X | 2024-09-15T12:02:08.447Z | 2024-09-16T12:17:28.775Z |
5071146 | 5071146 | 20240911160617_hr0jv | AU000X | 2024-09-15T12:01:47.181Z | 2024-09-16T12:17:28.746Z |
5071143 | 5071143 | 20240911160512_r2JRl | AU000X | 2024-09-15T12:01:46.761Z | 2024-09-16T12:17:28.745Z |
5071134 | 5071134 | 20240911160243_c0hKK | AU000X | 2024-09-15T12:01:45.631Z | 2024-09-16T12:17:28.743Z |
5071101 | 5071101 | 20240911160041_o94HS | AU000X | 2024-09-15T12:01:40.893Z | 2024-09-16T12:17:28.735Z |
5071093 | 5071093 | 20240911160008_FSaBU | AU000X | 2024-09-15T12:01:38.549Z | 2024-09-16T12:17:28.732Z |
5068970 | 5068970 | 20240910131601_GkRn2 | AU000X | 2024-09-14T12:19:23.402Z | 2024-09-16T12:20:15.968Z |
5068896 | 5068896 | 20240910125624_YVFqf | AU000X | 2024-09-14T12:19:22.644Z | 2024-09-16T12:20:15.613Z |
5068256 | 5068256 | 20240910111423_3327j | AU000X | 2024-09-14T12:19:11.324Z | 2024-09-16T12:20:13.227Z |
5062584 | 5062584 | 20240909174341_8k9P3 | AU000X | 2024-09-14T12:12:34.946Z | 2024-09-16T12:19:37.878Z |
5062511 | 5062511 | 20240909173426_RGk35 | AU000X | 2024-09-14T12:12:30.331Z | 2024-09-16T12:19:37.635Z |
5062240 | 5062240 | 20240909170231_sFgM3 | AU000X | 2024-09-14T12:11:58.803Z | 2024-09-16T12:19:36.698Z |
5061905 | 5061905 | 20240909162205_d0v6Z | AU000X | 2024-09-14T12:11:37.469Z | 2024-09-16T12:19:34.500Z |
5061860 | 5061860 | 20240909161355_e85z1 | AU000X | 2024-09-14T12:11:34.138Z | 2024-09-16T12:19:34.382Z |
5061324 | 5061324 | 20240909144641_VA5ZG | AU000X | 2024-09-14T12:10:42.343Z | 2024-09-16T12:19:30.595Z |
5061194 | 5061194 | 20240909143149_hN1SS | AU000X | 2024-09-14T12:10:34.024Z | 2024-09-16T12:19:29.723Z |
5061089 | 5061089 | 20240909141417_7vvf0 | AU000X | 2024-09-14T12:10:15.191Z | 2024-09-16T12:19:29.284Z |
5061057 | 5061057 | 20240909140003_KvA8E | AU000X | 2024-09-14T12:10:10.967Z | 2024-09-16T12:19:28.846Z |
5060951 | 5060951 | 20240909133648_1umuO | AU000X | 2024-09-14T12:09:58.922Z | 2024-09-16T12:19:28.383Z |
5060808 | 5060808 | 20240910211321_zsSCC | AU000X | 2024-09-14T12:09:35.610Z | 2024-09-16T12:18:19.496Z |
5060619 | 5060619 | 20240910204402_5YKzZ | AU000X | 2024-09-14T12:09:13.409Z | 2024-09-16T12:18:16.782Z |
5060541 | 5060541 | 20240910203722_ZLHA4 | AU000X | 2024-09-14T12:09:06.386Z | 2024-09-16T12:18:16.354Z |
5060405 | 5060405 | 20240910202720_Katw8 | AU000X | 2024-09-14T12:08:45.850Z | 2024-09-16T12:18:15.412Z |
5060257 | 5060257 | 20240910201242_ss21E | AU000X | 2024-09-14T12:08:33.495Z | 2024-09-16T12:18:14.216Z |
5060136 | 5060136 | 20240910195619_woDqR | AU000X | 2024-09-14T12:08:16.707Z | 2024-09-16T12:18:13.478Z |
5060073 | 5060073 | 20240910194714_0jecS | AU000X | 2024-09-14T12:08:09.603Z | 2024-09-16T12:18:12.678Z |
5059937 | 5059937 | 20240910192028_0O9vV | AU000X | 2024-09-14T12:07:46.237Z | 2024-09-16T12:18:10.223Z |
5059933 | 5059933 | 20240910192016_2bwrn | AU000X | 2024-09-14T12:07:44.629Z | 2024-09-16T12:18:10.213Z |
5059927 | 5059927 | 20240910192012_Sb1uz | AU000X | 2024-09-14T12:07:42.053Z | 2024-09-16T12:18:10.208Z |
5059884 | 5059884 | 20240910191408_1Hsvy | AU000X | 2024-09-14T12:07:32.990Z | 2024-09-16T12:18:09.853Z |
5059658 | 5059658 | 20240910182618_P2zmG | AU000X | 2024-09-14T12:06:41.582Z | 2024-09-16T12:18:06.983Z |
5059607 | 5059607 | 20240910181713_2gbAy | AU000X | 2024-09-14T12:06:34.977Z | 2024-09-16T12:18:06.480Z |
5059549 | 5059549 | 20240910180450_Osb0Y | AU000X | 2024-09-14T12:06:26.299Z | 2024-09-16T12:18:06.049Z |
5059519 | 5059519 | 20240910175933_32Elv | AU000X | 2024-09-14T12:06:16.186Z | 2024-09-16T12:18:05.676Z |
5059420 | 5059420 | 20240910174007_hV26q | AU000X | 2024-09-14T12:05:56.613Z | 2024-09-16T12:18:04.637Z |
5059411 | 5059411 | 20240910173801_c5LIb | AU000X | 2024-09-14T12:05:53.465Z | 2024-09-16T12:18:04.571Z |
5059342 | 5059342 | 20240910173317_541NC | AU000X | 2024-09-14T12:05:47.408Z | 2024-09-16T12:18:04.059Z |
5059139 | 5059139 | 20240910171618_uGR5G | AU000X | 2024-09-14T12:05:18.575Z | 2024-09-16T12:18:02.184Z |
5059101 | 5059101 | 20240910171316_JW53v | AU000X | 2024-09-14T12:05:14.654Z | 2024-09-16T12:18:01.785Z |
5058871 | 5058871 | 20240910165336_RsD9Y | AU000X | 2024-09-14T12:04:42.721Z | 2024-09-16T12:17:59.271Z |
5058764 | 5058764 | 20240910164302_uzMOD | AU000X | 2024-09-14T12:04:28.551Z | 2024-09-16T12:17:57.683Z |
5058685 | 5058685 | 20240910163625_ytKGw | AU000X | 2024-09-14T12:04:19.416Z | 2024-09-16T12:17:57.114Z |
5058590 | 5058590 | 20240910162937_Pqlu8 | AU000X | 2024-09-14T12:04:04.490Z | 2024-09-16T12:17:56.301Z |
5058434 | 5058434 | 20240910161213_uOlry | AU000X | 2024-09-14T12:03:42.265Z | 2024-09-16T12:17:54.436Z |
5058329 | 5058329 | 20240910160434_uQ3wd | AU000X | 2024-09-14T12:03:31.787Z | 2024-09-16T12:17:52.964Z |
5058244 | 5058244 | 20240910155750_2Ka0o | AU000X | 2024-09-14T12:03:15.660Z | 2024-09-16T12:17:52.009Z |
5058108 | 5058108 | 20240910154537_2L90y | AU000X | 2024-09-14T12:02:58.277Z | 2024-09-16T12:17:50.192Z |
5058098 | 5058098 | 20240910154346_HL37K | AU000X | 2024-09-14T12:02:56.045Z | 2024-09-16T12:17:50.111Z |
5058075 | 5058075 | 20240910154127_AHbsB | AU000X | 2024-09-14T12:02:52.462Z | 2024-09-16T12:17:49.843Z |
5057929 | 5057929 | 20240910152828_0Olee | AU000X | 2024-09-14T12:02:26.435Z | 2024-09-16T12:17:48.670Z |
5057768 | 5057768 | 20240910151117_zXgSX | AU000X | 2024-09-14T12:01:55.139Z | 2024-09-16T12:17:47.174Z |
5057698 | 5057698 | 20240910150541_YJ7Sp | AU000X | 2024-09-14T12:01:45.912Z | 2024-09-16T12:17:46.304Z |
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);