participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,682 rows where station_code = "AU001N" 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 |
---|---|---|---|---|---|
5084285 | 5084285 | 20240912190926_UeVeo | AU001N | 2024-09-16T12:01:47.166Z | 2024-09-16T12:17:04.223Z |
5084026 | 5084026 | 20240912174018_7YX25 | AU001N | 2024-09-16T12:00:57.247Z | 2024-09-16T12:17:04.043Z |
5083927 | 5083927 | 20240912164807_cqY7T | AU001N | 2024-09-16T12:00:40.134Z | 2024-09-16T12:17:03.980Z |
5083905 | 5083905 | 20240912164048_BSZvr | AU001N | 2024-09-16T12:00:37.586Z | 2024-09-16T12:17:03.971Z |
5062694 | 5062694 | 20240909180146_UCkVS | AU001N | 2024-09-14T12:12:43.544Z | 2024-09-16T12:19:38.811Z |
5062405 | 5062405 | 20240909172155_rAK35 | AU001N | 2024-09-14T12:12:18.435Z | 2024-09-16T12:19:37.190Z |
5062276 | 5062276 | 20240909170556_AcI89 | AU001N | 2024-09-14T12:12:04.507Z | 2024-09-16T12:19:36.832Z |
5062174 | 5062174 | 20240909165410_A65oS | AU001N | 2024-09-14T12:11:54.045Z | 2024-09-16T12:19:36.194Z |
5062171 | 5062171 | 20240909165354_c60Bh | AU001N | 2024-09-14T12:11:53.921Z | 2024-09-16T12:19:36.191Z |
5061821 | 5061821 | 20240909160503_ffrqx | AU001N | 2024-09-14T12:11:29.863Z | 2024-09-16T12:19:33.955Z |
5061695 | 5061695 | 20240909154339_uVUke | AU001N | 2024-09-14T12:11:12.598Z | 2024-09-16T12:19:33.190Z |
5061274 | 5061274 | 20240909143942_XK3lD | AU001N | 2024-09-14T12:10:39.547Z | 2024-09-16T12:19:30.257Z |
5061174 | 5061174 | 20240909142530_ub963 | AU001N | 2024-09-14T12:10:25.771Z | 2024-09-16T12:19:29.471Z |
5059486 | 5059486 | 20240910174843_0GXXS | AU001N | 2024-09-14T12:06:12.620Z | 2024-09-16T12:18:05.335Z |
5059167 | 5059167 | 20240910171902_HaATC | AU001N | 2024-09-14T12:05:22.876Z | 2024-09-16T12:18:02.467Z |
5058836 | 5058836 | 20240910165031_3olkj | AU001N | 2024-09-14T12:04:37.651Z | 2024-09-16T12:17:58.655Z |
5058727 | 5058727 | 20240910164020_V3bE7 | AU001N | 2024-09-14T12:04:24.648Z | 2024-09-16T12:17:57.477Z |
5057995 | 5057995 | 20240910153405_InnHY | AU001N | 2024-09-14T12:02:34.910Z | 2024-09-16T12:17:49.163Z |
5057847 | 5057847 | 20240910151845_f3YBr | AU001N | 2024-09-14T12:02:14.009Z | 2024-09-16T12:17:47.991Z |
5057559 | 5057559 | 20240910144910_tRJXA | AU001N | 2024-09-14T12:01:26.318Z | 2024-09-16T12:17:44.961Z |
5057446 | 5057446 | 20240910143102_5Rb3X | AU001N | 2024-09-14T12:01:04.587Z | 2024-09-16T12:17:43.991Z |
5057386 | 5057386 | 20240910141953_J9R84 | AU001N | 2024-09-14T12:00:58.573Z | 2024-09-16T12:17:43.502Z |
5051754 | 5051754 | 20240907183157_uRIHl | AU001N | 2024-09-13T12:14:32.534Z | 2024-09-16T12:21:01.810Z |
5051547 | 5051547 | 20240907174251_Ilijz | AU001N | 2024-09-13T12:14:22.271Z | 2024-09-16T12:21:01.185Z |
5051463 | 5051463 | 20240907173021_anaoa | AU001N | 2024-09-13T12:14:17.407Z | 2024-09-16T12:21:00.531Z |
5051434 | 5051434 | 20240907172647_33Uzs | AU001N | 2024-09-13T12:14:14.202Z | 2024-09-16T12:21:00.457Z |
5051144 | 5051144 | 20240907165349_bcNi9 | AU001N | 2024-09-13T12:14:03.868Z | 2024-09-16T12:20:59.650Z |
5051131 | 5051131 | 20240907165147_pZ0wY | AU001N | 2024-09-13T12:14:03.313Z | 2024-09-16T12:20:59.629Z |
5051118 | 5051118 | 20240907165028_7UjKT | AU001N | 2024-09-13T12:14:02.781Z | 2024-09-16T12:20:59.613Z |
5049655 | 5049655 | 20240909112636_XkS8v | AU001N | 2024-09-13T12:12:22.152Z | 2024-09-16T12:20:43.635Z |
5043302 | 5043302 | 20240907142657_QOQnU | AU001N | 2024-09-12T12:17:26.134Z | 2024-09-16T12:20:56.306Z |
5043249 | 5043249 | 20240907141419_OsTm8 | AU001N | 2024-09-12T12:17:25.723Z | 2024-09-16T12:20:56.039Z |
5043025 | 5043025 | 20240907133454_jB2hm | AU001N | 2024-09-12T12:17:21.942Z | 2024-09-16T12:20:55.188Z |
5042769 | 5042769 | 20240907124348_JlVEy | AU001N | 2024-09-12T12:17:18.204Z | 2024-09-16T12:20:54.184Z |
5042030 | 5042030 | 20240906094127_oFEcz | AU001N | 2024-09-12T12:16:54.416Z | 2024-09-14T12:23:15.818Z |
5038304 | 5038304 | 20240905190748_J4rEg | AU001N | 2024-09-12T12:14:32.289Z | 2024-09-14T12:22:55.550Z |
5038288 | 5038288 | 20240905185406_AqUcO | AU001N | 2024-09-12T12:14:31.013Z | 2024-09-14T12:22:55.490Z |
5038274 | 5038274 | 20240905183906_C17QJ | AU001N | 2024-09-12T12:14:30.198Z | 2024-09-14T12:22:55.476Z |
5038270 | 5038270 | 20240905182848_PLyhL | AU001N | 2024-09-12T12:14:29.942Z | 2024-09-14T12:22:55.458Z |
5038248 | 5038248 | 20240905180344_4UrrW | AU001N | 2024-09-12T12:14:28.704Z | 2024-09-14T12:22:55.418Z |
5038214 | 5038214 | 20240905174737_5OKEs | AU001N | 2024-09-12T12:14:26.048Z | 2024-09-14T12:22:55.329Z |
5038080 | 5038080 | 20240905172154_7cdk7 | AU001N | 2024-09-12T12:14:21.634Z | 2024-09-14T12:22:55.019Z |
5037922 | 5037922 | 20240905170523_uEtYz | AU001N | 2024-09-12T12:14:17.516Z | 2024-09-14T12:22:54.800Z |
5037874 | 5037874 | 20240905165851_aty2c | AU001N | 2024-09-12T12:14:16.612Z | 2024-09-14T12:22:54.751Z |
5037682 | 5037682 | 20240905163601_25crA | AU001N | 2024-09-12T12:14:13.845Z | 2024-09-14T12:22:54.502Z |
5037632 | 5037632 | 20240905162610_PpJPG | AU001N | 2024-09-12T12:14:13.083Z | 2024-09-14T12:22:54.475Z |
5037620 | 5037620 | 20240905162347_qoTLV | AU001N | 2024-09-12T12:14:12.618Z | 2024-09-14T12:22:54.459Z |
5037097 | 5037097 | 20240905150521_8Ccn7 | AU001N | 2024-09-12T12:14:00.939Z | 2024-09-14T12:22:53.705Z |
5036928 | 5036928 | 20240905144613_z2HSK | AU001N | 2024-09-12T12:13:57.641Z | 2024-09-14T12:22:53.547Z |
5036926 | 5036926 | 20240905144516_UNv6F | AU001N | 2024-09-12T12:13:57.543Z | 2024-09-14T12:22:53.545Z |
5036638 | 5036638 | 20240905141215_tRhPC | AU001N | 2024-09-12T12:13:51.040Z | 2024-09-14T12:22:53.075Z |
5036241 | 5036241 | 20240905130137_3nCVl | AU001N | 2024-09-12T12:13:30.605Z | 2024-09-14T12:22:52.131Z |
5035990 | 5035990 | 20240905122412_XaRqa | AU001N | 2024-09-12T12:13:16.180Z | 2024-09-14T12:22:51.744Z |
5035978 | 5035978 | 20240905122005_223pk | AU001N | 2024-09-12T12:13:15.469Z | 2024-09-14T12:22:51.692Z |
5030850 | 5030850 | 20240906190633_pRlty | AU001N | 2024-09-12T12:03:14.361Z | 2024-09-15T12:21:20.150Z |
5030829 | 5030829 | 20240906185921_qXaN7 | AU001N | 2024-09-12T12:03:10.989Z | 2024-09-15T12:21:19.974Z |
5030791 | 5030791 | 20240906183845_3SePJ | AU001N | 2024-09-12T12:03:05.642Z | 2024-09-15T12:21:19.733Z |
5030740 | 5030740 | 20240906180313_HT5Nn | AU001N | 2024-09-12T12:02:51.644Z | 2024-09-15T12:21:19.530Z |
5030738 | 5030738 | 20240906180235_aYp9N | AU001N | 2024-09-12T12:02:50.953Z | 2024-09-15T12:21:19.528Z |
5030690 | 5030690 | 20240906174209_LiJaG | AU001N | 2024-09-12T12:02:40.432Z | 2024-09-15T12:21:19.471Z |
5030644 | 5030644 | 20240906172653_hAu4t | AU001N | 2024-09-12T12:02:33.051Z | 2024-09-15T12:21:19.392Z |
5030572 | 5030572 | 20240906165919_6NPqf | AU001N | 2024-09-12T12:02:23.461Z | 2024-09-15T12:21:19.159Z |
5030389 | 5030389 | 20240906151915_LB39X | AU001N | 2024-09-12T12:01:51.088Z | 2024-09-15T12:21:18.522Z |
5030373 | 5030373 | 20240906151227_xfqeF | AU001N | 2024-09-12T12:01:48.876Z | 2024-09-15T12:21:18.506Z |
5030310 | 5030310 | 20240906144408_CLG6T | AU001N | 2024-09-12T12:01:41.255Z | 2024-09-15T12:21:18.418Z |
5030283 | 5030283 | 20240906142503_w7eg3 | AU001N | 2024-09-12T12:01:37.986Z | 2024-09-15T12:21:18.394Z |
5030249 | 5030249 | 20240906140137_Irlay | AU001N | 2024-09-12T12:01:33.778Z | 2024-09-15T12:21:18.349Z |
5030247 | 5030247 | 20240906140136_88zOT | AU001N | 2024-09-12T12:01:33.420Z | 2024-09-15T12:21:18.336Z |
5030211 | 5030211 | 20240906134319_aqzvX | AU001N | 2024-09-12T12:01:27.722Z | 2024-09-15T12:21:18.265Z |
5030109 | 5030109 | 20240906125651_ns2Gk | AU001N | 2024-09-12T12:01:09.755Z | 2024-09-15T12:21:18.102Z |
5028764 | 5028764 | 20240905104601_ySJr3 | AU001N | 2024-09-11T12:15:49.047Z | 2024-09-14T12:22:49.324Z |
5024063 | 5024063 | 20240905190748_dHPXs | AU001N | 2024-09-11T12:02:30.004Z | 2024-09-11T12:16:31.917Z |
5024059 | 5024059 | 20240905185406_cZ3oj | AU001N | 2024-09-11T12:02:29.383Z | 2024-09-11T12:16:31.915Z |
5024049 | 5024049 | 20240905182848_b3EBy | AU001N | 2024-09-11T12:02:26.499Z | 2024-09-11T12:16:31.908Z |
5024042 | 5024042 | 20240905180344_2reSz | AU001N | 2024-09-11T12:02:23.491Z | 2024-09-11T12:16:31.903Z |
5024024 | 5024024 | 20240905174737_y5zMP | AU001N | 2024-09-11T12:02:19.444Z | 2024-09-11T12:16:31.892Z |
5023915 | 5023915 | 20240905172154_bLhxW | AU001N | 2024-09-10T12:16:51.685Z | 2024-09-14T12:22:55.014Z |
5023763 | 5023763 | 20240905170523_Q2C04 | AU001N | 2024-09-10T12:16:50.107Z | 2024-09-11T12:16:31.776Z |
5023717 | 5023717 | 20240905165851_t1Enx | AU001N | 2024-09-10T12:16:49.517Z | 2024-09-11T12:16:31.753Z |
5023540 | 5023540 | 20240905163601_a86tM | AU001N | 2024-09-10T12:16:47.415Z | 2024-09-11T12:16:31.697Z |
5023490 | 5023490 | 20240905162610_8qmaJ | AU001N | 2024-09-10T12:16:46.681Z | 2024-09-11T12:16:31.681Z |
5023484 | 5023484 | 20240905162347_3Cly6 | AU001N | 2024-09-10T12:16:46.245Z | 2024-09-11T12:16:31.677Z |
5018601 | 5018601 | 20240904190735_3TITx | AU001N | 2024-09-10T12:10:58.268Z | 2024-09-13T12:19:48.279Z |
5018309 | 5018309 | 20240904173832_K21b2 | AU001N | 2024-09-10T12:10:22.738Z | 2024-09-13T12:19:47.519Z |
5017232 | 5017232 | 20240904154450_c2OZN | AU001N | 2024-09-10T12:08:57.276Z | 2024-09-13T12:19:46.676Z |
5016655 | 5016655 | 20240904143859_5RSUx | AU001N | 2024-09-10T12:08:04.323Z | 2024-09-13T12:19:45.972Z |
5015800 | 5015800 | 20240904123731_CMdZL | AU001N | 2024-09-10T12:06:47.400Z | 2024-09-13T12:19:44.662Z |
5015708 | 5015708 | 20240904121851_36odJ | AU001N | 2024-09-10T12:06:40.374Z | 2024-09-13T12:19:44.611Z |
5015698 | 5015698 | 20240904121614_ZDlQB | AU001N | 2024-09-10T12:06:39.589Z | 2024-09-13T12:19:44.608Z |
5015691 | 5015691 | 20240904121424_wgxqr | AU001N | 2024-09-10T12:06:38.670Z | 2024-09-13T12:19:44.597Z |
5015633 | 5015633 | 20240904120215_c2Fxf | AU001N | 2024-09-10T12:06:33.674Z | 2024-09-13T12:19:44.493Z |
5015587 | 5015587 | 20240904115558_3oMu4 | AU001N | 2024-09-10T12:06:28.695Z | 2024-09-13T12:19:44.358Z |
5015390 | 5015390 | 20240905150521_AbNRI | AU001N | 2024-09-10T12:05:13.025Z | 2024-09-11T12:16:31.491Z |
5015221 | 5015221 | 20240905144613_pdj3n | AU001N | 2024-09-10T12:04:42.998Z | 2024-09-11T12:16:31.425Z |
5015219 | 5015219 | 20240905144516_S1iF7 | AU001N | 2024-09-10T12:04:42.086Z | 2024-09-14T12:22:53.545Z |
5014960 | 5014960 | 20240905141215_ISw3V | AU001N | 2024-09-10T12:04:20.270Z | 2024-09-11T12:16:31.340Z |
5014564 | 5014564 | 20240905130137_b9mow | AU001N | 2024-09-10T12:03:28.157Z | 2024-09-11T12:16:31.205Z |
5014318 | 5014318 | 20240905122412_m466B | AU001N | 2024-09-10T12:02:46.154Z | 2024-09-11T12:16:31.121Z |
5014306 | 5014306 | 20240905122005_BUm4K | AU001N | 2024-09-10T12:02:44.833Z | 2024-09-11T12:16:31.113Z |
5013573 | 5013573 | 20240905104601_pO4qo | AU001N | 2024-09-10T12:00:59.064Z | 2024-09-11T12:00:25.632Z |
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);