participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,227 rows where station_code = "AU0028" 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 |
|---|---|---|---|---|---|
| 9829602 | 9829602 | 20260429113752_d7NRE | AU0028 | 2026-05-01T12:26:44.972Z | 2026-05-01T12:26:44.972Z |
| 9819184 | 9819184 | 20260428212442_1J453 | AU0028 | 2026-04-30T12:10:37.645Z | 2026-05-01T12:23:10.937Z |
| 9819163 | 9819163 | 20260428211602_8wwRF | AU0028 | 2026-04-30T12:10:32.084Z | 2026-05-01T12:23:09.525Z |
| 9819149 | 9819149 | 20260428211108_iIc2a | AU0028 | 2026-04-30T12:10:24.084Z | 2026-05-01T12:23:08.252Z |
| 9819119 | 9819119 | 20260428210137_CkEjw | AU0028 | 2026-04-30T12:10:14.926Z | 2026-05-01T12:23:06.332Z |
| 9818990 | 9818990 | 20260428192801_a9dGc | AU0028 | 2026-04-30T12:09:39.839Z | 2026-05-01T12:22:51.679Z |
| 9812522 | 9812522 | 20260427213701_0T7Mm | AU0028 | 2026-04-29T12:10:20.479Z | 2026-05-01T12:30:15.671Z |
| 9812462 | 9812462 | 20260427210840_2RA7E | AU0028 | 2026-04-29T12:10:07.176Z | 2026-05-01T12:30:12.143Z |
| 9812460 | 9812460 | 20260427210318_Hf3Pg | AU0028 | 2026-04-29T12:10:06.727Z | 2026-05-01T12:30:11.969Z |
| 9812422 | 9812422 | 20260427203045_242DY | AU0028 | 2026-04-29T12:09:54.857Z | 2026-05-01T12:30:09.751Z |
| 9812372 | 9812372 | 20260427195048_84as8 | AU0028 | 2026-04-29T12:09:37.521Z | 2026-05-01T12:30:06.392Z |
| 9811551 | 9811551 | 20260427164632_FQgFt | AU0028 | 2026-04-29T12:06:54.883Z | 2026-05-01T12:29:28.491Z |
| 9797839 | 9797839 | 20260425214231_KL0xN | AU0028 | 2026-04-27T12:21:03.120Z | 2026-04-30T12:44:24.508Z |
| 9797076 | 9797076 | 20260425194013_PI0Pa | AU0028 | 2026-04-27T12:17:59.782Z | 2026-04-30T12:43:35.766Z |
| 9796776 | 9796776 | 20260425185435_ptqLw | AU0028 | 2026-04-27T12:16:40.695Z | 2026-04-30T12:43:22.566Z |
| 9796691 | 9796691 | 20260425183753_QiY2m | AU0028 | 2026-04-27T12:16:13.751Z | 2026-04-30T12:43:19.127Z |
| 9795238 | 9795238 | 20260425164848_uEW0S | AU0028 | 2026-04-27T12:12:00.314Z | 2026-04-30T12:42:18.770Z |
| 9793372 | 9793372 | 20260425143214_mIkK4 | AU0028 | 2026-04-27T12:06:30.898Z | 2026-04-30T12:41:08.409Z |
| 9790827 | 9790827 | 20260424122553_Mp23R | AU0028 | 2026-04-26T12:34:48.988Z | 2026-04-30T13:04:07.969Z |
| 9783812 | 9783812 | 20260424215108_tcbuH | AU0028 | 2026-04-26T12:15:34.589Z | 2026-04-30T12:51:52.896Z |
| 9783433 | 9783433 | 20260424212101_RFcbc | AU0028 | 2026-04-26T12:14:48.555Z | 2026-04-30T12:51:43.476Z |
| 9783007 | 9783007 | 20260424202655_f8x4E | AU0028 | 2026-04-26T12:13:27.743Z | 2026-04-30T12:51:16.755Z |
| 9782850 | 9782850 | 20260424200404_xbvwc | AU0028 | 2026-04-26T12:13:01.425Z | 2026-04-30T12:51:12.575Z |
| 9782431 | 9782431 | 20260424185956_TZ4R6 | AU0028 | 2026-04-26T12:11:58.495Z | 2026-04-30T12:50:45.578Z |
| 9782103 | 9782103 | 20260424180952_XERgB | AU0028 | 2026-04-26T12:11:06.426Z | 2026-04-30T12:50:37.106Z |
| 9781744 | 9781744 | 20260424174454_m32sp | AU0028 | 2026-04-26T12:10:21.213Z | 2026-04-30T12:50:31.206Z |
| 9781454 | 9781454 | 20260424172835_1X9sA | AU0028 | 2026-04-26T12:09:42.781Z | 2026-04-30T12:50:10.640Z |
| 9763545 | 9763545 | 20260423182253_Nq55k | AU0028 | 2026-04-25T12:13:02.179Z | 2026-04-30T12:58:06.545Z |
| 9763485 | 9763485 | 20260423181312_drAr6 | AU0028 | 2026-04-25T12:12:49.823Z | 2026-04-30T12:58:01.794Z |
| 9763255 | 9763255 | 20260423174052_f926e | AU0028 | 2026-04-25T12:12:03.775Z | 2026-04-30T12:57:57.777Z |
| 9747321 | 9747321 | 20260422175848_y4Tyh | AU0028 | 2026-04-24T12:02:38.739Z | 2026-04-30T13:06:53.422Z |
| 9742304 | 9742304 | 20260422123841_UunRq | AU0028 | 2026-04-24T12:00:26.208Z | 2026-04-30T13:04:58.925Z |
| 9742184 | 9742184 | 20260422122638_e6Rso | AU0028 | 2026-04-24T12:00:22.823Z | 2026-04-30T13:04:43.145Z |
| 9742139 | 9742139 | 20260422121936_Yk45w | AU0028 | 2026-04-24T12:00:21.098Z | 2026-04-30T13:04:40.179Z |
| 9731578 | 9731578 | 20260421183129_xwDdP | AU0028 | 2026-04-23T12:06:38.963Z | 2026-04-30T13:16:49.646Z |
| 9731375 | 9731375 | 20260421171619_FR9lS | AU0028 | 2026-04-23T12:05:25.364Z | 2026-04-30T13:16:45.150Z |
| 9731226 | 9731226 | 20260421162039_09G3f | AU0028 | 2026-04-23T12:04:41.332Z | 2026-04-30T13:16:00.547Z |
| 9730691 | 9730691 | 20260421125246_gGI3Z | AU0028 | 2026-04-23T12:01:34.756Z | 2026-04-30T13:15:47.649Z |
| 9730577 | 9730577 | 20260421114252_hvoix | AU0028 | 2026-04-23T12:00:56.802Z | 2026-04-30T13:15:44.954Z |
| 9724314 | 9724314 | 20260420212436_esMQN | AU0028 | 2026-04-22T12:13:49.068Z | 2026-04-29T13:19:14.844Z |
| 9724232 | 9724232 | 20260420211547_acNBb | AU0028 | 2026-04-22T12:13:41.294Z | 2026-04-29T13:19:14.135Z |
| 9724173 | 9724173 | 20260420211001_hu4VI | AU0028 | 2026-04-22T12:13:29.499Z | 2026-04-29T13:19:13.417Z |
| 9724169 | 9724169 | 20260420210910_2bJfw | AU0028 | 2026-04-22T12:13:28.479Z | 2026-04-29T13:19:13.280Z |
| 9717486 | 9717486 | 20260419215042_OXGcw | AU0028 | 2026-04-21T12:19:58.018Z | 2026-04-28T13:37:11.069Z |
| 9717046 | 9717046 | 20260419205314_1RrDh | AU0028 | 2026-04-21T12:18:28.623Z | 2026-04-28T13:37:02.956Z |
| 9716926 | 9716926 | 20260419203026_0CBV9 | AU0028 | 2026-04-21T12:18:00.558Z | 2026-04-28T13:36:54.102Z |
| 9715312 | 9715312 | 20260419143441_ysmDA | AU0028 | 2026-04-21T12:11:11.561Z | 2026-04-28T13:34:47.526Z |
| 9715049 | 9715049 | 20260419132208_LPzcg | AU0028 | 2026-04-21T12:09:42.286Z | 2026-04-28T13:34:40.273Z |
| 9715039 | 9715039 | 20260419132018_mdqxu | AU0028 | 2026-04-21T12:09:37.172Z | 2026-04-28T13:34:40.128Z |
| 9714861 | 9714861 | 20260419121905_3zKkQ | AU0028 | 2026-04-21T12:08:40.448Z | 2026-04-28T13:34:24.550Z |
| 9706418 | 9706418 | 20260418171440_Uee7A | AU0028 | 2026-04-20T12:09:45.528Z | 2026-04-27T13:45:01.203Z |
| 9706299 | 9706299 | 20260418163819_kUXZN | AU0028 | 2026-04-20T12:09:09.681Z | 2026-04-27T13:44:54.463Z |
| 9699844 | 9699844 | 20260417202905_fAJBW | AU0028 | 2026-04-19T12:13:35.012Z | 2026-04-26T13:10:29.396Z |
| 9699702 | 9699702 | 20260417194942_48GPq | AU0028 | 2026-04-19T12:12:53.059Z | 2026-04-26T13:10:27.941Z |
| 9699493 | 9699493 | 20260417185716_VgzOa | AU0028 | 2026-04-19T12:12:04.124Z | 2026-04-26T13:10:12.251Z |
| 9699428 | 9699428 | 20260417182930_kgUdz | AU0028 | 2026-04-19T12:11:48.616Z | 2026-04-26T13:10:08.498Z |
| 9694843 | 9694843 | 20260416203858_MKo5a | AU0028 | 2026-04-18T12:20:54.279Z | 2026-04-25T13:58:12.324Z |
| 9694399 | 9694399 | 20260416180624_sg1wb | AU0028 | 2026-04-18T12:19:16.722Z | 2026-04-25T13:57:30.588Z |
| 9693681 | 9693681 | 20260416163239_jBHg3 | AU0028 | 2026-04-18T12:17:01.972Z | 2026-04-25T13:56:30.830Z |
| 9693396 | 9693396 | 20260416143950_gvEuX | AU0028 | 2026-04-18T12:13:20.438Z | 2026-04-25T13:55:17.342Z |
| 9688517 | 9688517 | 20260415200924_M2Mts | AU0028 | 2026-04-17T12:25:21.864Z | 2026-04-24T12:24:38.677Z |
| 9688493 | 9688493 | 20260415195848_HAOEC | AU0028 | 2026-04-17T12:25:09.300Z | 2026-04-24T12:24:38.425Z |
| 9688174 | 9688174 | 20260415185259_1fvIQ | AU0028 | 2026-04-17T12:24:09.317Z | 2026-04-24T12:24:31.902Z |
| 9687053 | 9687053 | 20260415141214_iy22I | AU0028 | 2026-04-17T12:18:49.633Z | 2026-04-24T12:23:36.327Z |
| 9686726 | 9686726 | 20260415114744_uc7Np | AU0028 | 2026-04-17T12:16:32.670Z | 2026-04-24T12:23:23.633Z |
| 9686716 | 9686716 | 20260415114307_qVBQ3 | AU0028 | 2026-04-17T12:16:26.429Z | 2026-04-24T12:23:23.025Z |
| 9678841 | 9678841 | 20260414150911_7g2lE | AU0028 | 2026-04-16T12:14:05.054Z | 2026-04-23T13:09:48.571Z |
| 9678746 | 9678746 | 20260414125821_VT5P3 | AU0028 | 2026-04-16T12:12:14.917Z | 2026-04-23T13:09:03.768Z |
| 9678711 | 9678711 | 20260414121352_trJTF | AU0028 | 2026-04-16T12:11:54.312Z | 2026-04-23T13:08:54.624Z |
| 9678709 | 9678709 | 20260414121209_mDEtJ | AU0028 | 2026-04-16T12:11:53.610Z | 2026-04-23T13:08:54.394Z |
| 9670683 | 9670683 | 20260413140749_4c28Q | AU0028 | 2026-04-15T12:18:18.770Z | 2026-04-22T13:12:44.859Z |
| 9670478 | 9670478 | 20260413112934_Zx4OY | AU0028 | 2026-04-15T12:16:43.358Z | 2026-04-22T13:11:41.572Z |
| 9662737 | 9662737 | 20260412142318_bcjHj | AU0028 | 2026-04-14T12:17:20.409Z | 2026-04-21T13:15:22.540Z |
| 9662533 | 9662533 | 20260412112334_C1IB1 | AU0028 | 2026-04-14T12:14:48.931Z | 2026-04-21T13:14:19.826Z |
| 9656615 | 9656615 | 20260411214128_pTqRJ | AU0028 | 2026-04-13T12:23:24.997Z | 2026-04-20T13:06:45.800Z |
| 9656223 | 9656223 | 20260411202947_MN3rD | AU0028 | 2026-04-13T12:21:52.153Z | 2026-04-20T13:06:39.449Z |
| 9656079 | 9656079 | 20260411195352_R4no9 | AU0028 | 2026-04-13T12:21:19.079Z | 2026-04-20T13:06:37.504Z |
| 9656077 | 9656077 | 20260411195346_2iUzy | AU0028 | 2026-04-13T12:21:18.580Z | 2026-04-20T13:06:37.474Z |
| 9655852 | 9655852 | 20260411190258_zt99B | AU0028 | 2026-04-13T12:20:16.149Z | 2026-04-20T13:06:33.758Z |
| 9655834 | 9655834 | 20260411185557_r4lVe | AU0028 | 2026-04-13T12:20:07.571Z | 2026-04-20T13:06:33.563Z |
| 9655822 | 9655822 | 20260411185344_nhDO2 | AU0028 | 2026-04-13T12:20:05.381Z | 2026-04-20T13:06:33.369Z |
| 9655797 | 9655797 | 20260411184819_BI3GL | AU0028 | 2026-04-13T12:19:57.449Z | 2026-04-20T13:06:32.719Z |
| 9655710 | 9655710 | 20260411182159_NdbO3 | AU0028 | 2026-04-13T12:19:33.014Z | 2026-04-20T13:06:31.226Z |
| 9655160 | 9655160 | 20260411140953_v7rBp | AU0028 | 2026-04-13T12:16:37.737Z | 2026-04-20T13:05:47.327Z |
| 9655047 | 9655047 | 20260411130814_GtgtA | AU0028 | 2026-04-13T12:16:04.072Z | 2026-04-20T13:05:28.511Z |
| 9648871 | 9648871 | 20260409211619_3Vrdf | AU0028 | 2026-04-12T12:34:28.540Z | 2026-04-18T13:03:03.390Z |
| 9648461 | 9648461 | 20260409195142_LbCri | AU0028 | 2026-04-12T12:33:38.090Z | 2026-04-18T13:02:56.453Z |
| 9648399 | 9648399 | 20260409192020_AsvU2 | AU0028 | 2026-04-12T12:33:31.353Z | 2026-04-18T13:02:51.036Z |
| 9644197 | 9644197 | 20260410204635_FlrNW | AU0028 | 2026-04-12T12:17:03.665Z | 2026-04-19T13:20:49.963Z |
| 9643852 | 9643852 | 20260410183210_WdIj6 | AU0028 | 2026-04-12T12:15:36.044Z | 2026-04-19T13:20:21.491Z |
| 9643592 | 9643592 | 20260410173347_yxoY2 | AU0028 | 2026-04-12T12:14:41.558Z | 2026-04-19T13:19:58.258Z |
| 9643590 | 9643590 | 20260410173253_2QniK | AU0028 | 2026-04-12T12:14:41.197Z | 2026-04-19T13:19:58.102Z |
| 9643513 | 9643513 | 20260410171458_70i9d | AU0028 | 2026-04-12T12:14:17.963Z | 2026-04-19T13:19:54.122Z |
| 9643394 | 9643394 | 20260410165106_SHEah | AU0028 | 2026-04-12T12:13:56.995Z | 2026-04-19T13:19:38.607Z |
| 9643031 | 9643031 | 20260410152530_akrXg | AU0028 | 2026-04-12T12:12:23.980Z | 2026-04-19T13:19:10.503Z |
| 9642521 | 9642521 | 20260410132035_u8uNE | AU0028 | 2026-04-12T12:10:28.852Z | 2026-04-19T13:18:34.002Z |
| 9642284 | 9642284 | 20260410121354_DUZ8U | AU0028 | 2026-04-12T12:09:31.356Z | 2026-04-19T13:18:12.678Z |
| 9642231 | 9642231 | 20260410115812_SZYBt | AU0028 | 2026-04-12T12:09:16.771Z | 2026-04-19T13:18:10.530Z |
| 9642219 | 9642219 | 20260410115534_DvVj7 | AU0028 | 2026-04-12T12:09:09.535Z | 2026-04-19T13:18:09.822Z |
| 9642135 | 9642135 | 20260410113408_aN2pT | AU0028 | 2026-04-12T12:08:56.052Z | 2026-04-19T13:18:05.807Z |
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);