participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,125 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 |
|---|---|---|---|---|---|
| 9627591 | 9627591 | 20260407130411_sX7iD | AU0028 | 2026-04-09T12:12:26.633Z | 2026-04-11T12:17:33.656Z |
| 9627575 | 9627575 | 20260407124445_1ikJj | AU0028 | 2026-04-09T12:12:23.545Z | 2026-04-11T12:17:32.587Z |
| 9627567 | 9627567 | 20260407123826_Ywb6X | AU0028 | 2026-04-09T12:12:17.681Z | 2026-04-11T12:17:30.387Z |
| 9627563 | 9627563 | 20260407122759_3H216 | AU0028 | 2026-04-09T12:12:16.373Z | 2026-04-11T12:17:27.903Z |
| 9613127 | 9613127 | 20260406194222_M64px | AU0028 | 2026-04-07T12:03:54.422Z | 2026-04-11T12:26:16.170Z |
| 9613076 | 9613076 | 20260406191356_eXYwf | AU0028 | 2026-04-07T12:03:44.565Z | 2026-04-11T12:26:07.905Z |
| 9613059 | 9613059 | 20260406190354_co9iG | AU0028 | 2026-04-07T12:03:41.882Z | 2026-04-11T12:26:05.960Z |
| 9612869 | 9612869 | 20260406173404_Gqsmg | AU0028 | 2026-04-07T12:03:06.991Z | 2026-04-11T12:25:53.754Z |
| 9612522 | 9612522 | 20260406134008_1zq9S | AU0028 | 2026-04-07T12:02:05.003Z | 2026-04-11T12:25:32.636Z |
| 9605943 | 9605943 | 20260403132333_trP3a | AU0028 | 2026-04-04T12:04:33.709Z | 2026-04-11T12:39:39.099Z |
| 9584384 | 9584384 | 20260325193612_SDGBu | AU0028 | 2026-03-27T12:15:10.822Z | 2026-04-03T12:39:12.584Z |
| 9584368 | 9584368 | 20260325192644_ZDxgH | AU0028 | 2026-03-27T12:15:06.815Z | 2026-04-03T12:39:11.673Z |
| 9584315 | 9584315 | 20260325185351_WBMQ8 | AU0028 | 2026-03-27T12:14:56.737Z | 2026-04-03T12:39:08.667Z |
| 9584294 | 9584294 | 20260325183607_fB0Yk | AU0028 | 2026-03-27T12:14:52.909Z | 2026-04-03T12:39:07.632Z |
| 9584228 | 9584228 | 20260325175219_Bk0tz | AU0028 | 2026-03-27T12:14:36.952Z | 2026-04-03T12:38:52.084Z |
| 9584225 | 9584225 | 20260325175155_AmF99 | AU0028 | 2026-03-27T12:14:36.514Z | 2026-04-03T12:38:51.999Z |
| 9584062 | 9584062 | 20260325150246_vI9WW | AU0028 | 2026-03-27T12:13:52.853Z | 2026-04-03T12:38:34.343Z |
| 9584028 | 9584028 | 20260325141037_6ZShp | AU0028 | 2026-03-27T12:13:40.340Z | 2026-04-03T12:38:30.369Z |
| 9579273 | 9579273 | 20260324150508_7E0yd | AU0028 | 2026-03-26T12:12:24.361Z | 2026-04-02T12:36:36.204Z |
| 9579180 | 9579180 | 20260324120946_eIxa8 | AU0028 | 2026-03-26T12:11:43.687Z | 2026-04-02T12:36:09.464Z |
| 9528014 | 9528014 | 20260318153504_sjtAU | AU0028 | 2026-03-20T12:21:52.548Z | 2026-03-26T12:38:32.603Z |
| 9527835 | 9527835 | 20260318151946_hDv7w | AU0028 | 2026-03-20T12:21:46.003Z | 2026-03-26T12:38:31.737Z |
| 9527780 | 9527780 | 20260318151406_rnPfH | AU0028 | 2026-03-20T12:21:43.144Z | 2026-03-26T12:38:31.295Z |
| 9527777 | 9527777 | 20260318151405_vdRaw | AU0028 | 2026-03-20T12:21:43.058Z | 2026-03-26T12:38:31.264Z |
| 9527134 | 9527134 | 20260318140421_MCg9u | AU0028 | 2026-03-20T12:21:01.403Z | 2026-03-26T12:38:26.254Z |
| 9526820 | 9526820 | 20260318131848_Sr3dR | AU0028 | 2026-03-20T12:20:38.242Z | 2026-03-26T12:38:23.735Z |
| 9516637 | 9516637 | 20260317212127_GFDFn | AU0028 | 2026-03-19T12:26:35.281Z | 2026-03-25T12:43:04.663Z |
| 9516069 | 9516069 | 20260317195032_9hOAw | AU0028 | 2026-03-19T12:25:36.167Z | 2026-03-25T12:42:47.560Z |
| 9515986 | 9515986 | 20260317193954_b0Xo3 | AU0028 | 2026-03-19T12:25:25.966Z | 2026-03-25T12:42:45.186Z |
| 9515780 | 9515780 | 20260317183238_9GfJ4 | AU0028 | 2026-03-19T12:24:52.177Z | 2026-03-25T12:42:36.125Z |
| 9515435 | 9515435 | 20260317134459_snMvv | AU0028 | 2026-03-19T12:23:03.325Z | 2026-03-25T12:42:27.076Z |
| 9515414 | 9515414 | 20260317125803_0wbVt | AU0028 | 2026-03-19T12:22:51.504Z | 2026-03-25T12:42:25.675Z |
| 9514922 | 9514922 | 20260318121907_eTR9t | AU0028 | 2026-03-19T12:18:37.804Z | 2026-03-26T12:38:20.546Z |
| 9514702 | 9514702 | 20260318115709_pT6Sw | AU0028 | 2026-03-19T12:18:11.181Z | 2026-03-26T12:38:18.704Z |
| 9506847 | 9506847 | 20260316193757_VTha2 | AU0028 | 2026-03-18T12:19:27.396Z | 2026-03-24T12:41:35.096Z |
| 9500548 | 9500548 | 20260315153547_gLYFb | AU0028 | 2026-03-17T12:22:43.253Z | 2026-03-23T12:22:37.690Z |
| 9500540 | 9500540 | 20260315153307_GCbJE | AU0028 | 2026-03-17T12:22:41.882Z | 2026-03-23T12:22:37.568Z |
| 9500413 | 9500413 | 20260315130545_GE8Vc | AU0028 | 2026-03-17T12:21:33.589Z | 2026-03-23T12:22:33.744Z |
| 9500358 | 9500358 | 20260315121210_fyJg5 | AU0028 | 2026-03-17T12:21:05.003Z | 2026-03-23T12:22:32.298Z |
| 9497318 | 9497318 | 20260316131719_Zn3nV | AU0028 | 2026-03-17T12:11:47.467Z | 2026-03-24T12:41:22.866Z |
| 9473982 | 9473982 | 20260312184646_JljtE | AU0028 | 2026-03-14T12:21:37.376Z | 2026-03-20T12:37:14.152Z |
| 9473115 | 9473115 | 20260313155253_uVUBT | AU0028 | 2026-03-14T12:14:30.399Z | 2026-03-21T12:49:54.233Z |
| 9472798 | 9472798 | 20260313150253_c3g7x | AU0028 | 2026-03-14T12:13:57.894Z | 2026-03-21T12:49:52.052Z |
| 9472692 | 9472692 | 20260313144528_czeOM | AU0028 | 2026-03-14T12:13:42.915Z | 2026-03-21T12:49:50.902Z |
| 9472311 | 9472311 | 20260313134035_M8MGl | AU0028 | 2026-03-14T12:12:53.401Z | 2026-03-21T12:49:47.718Z |
| 9472245 | 9472245 | 20260313131705_mUCx8 | AU0028 | 2026-03-14T12:12:42.687Z | 2026-03-14T12:22:45.368Z |
| 9472204 | 9472204 | 20260313131057_wKG2g | AU0028 | 2026-03-14T12:12:37.127Z | 2026-03-21T12:49:46.694Z |
| 9468450 | 9468450 | 20260312205912_jSOBc | AU0028 | 2026-03-13T12:21:50.465Z | 2026-03-20T12:37:16.264Z |
| 9468437 | 9468437 | 20260312205539_VMvYE | AU0028 | 2026-03-13T12:21:49.185Z | 2026-03-20T12:37:16.221Z |
| 9468288 | 9468288 | 20260312190629_gXfcv | AU0028 | 2026-03-13T12:21:37.129Z | 2026-03-20T12:37:14.343Z |
| 9467789 | 9467789 | 20260312140336_7eoFp | AU0028 | 2026-03-13T12:19:57.399Z | 2026-03-20T12:37:09.259Z |
| 9462079 | 9462079 | 20260311200807_j8YxU | AU0028 | 2026-03-12T12:18:24.870Z | 2026-03-19T12:45:48.388Z |
| 9461904 | 9461904 | 20260311191505_GxzeA | AU0028 | 2026-03-12T12:18:09.651Z | 2026-03-19T12:45:45.641Z |
| 9461502 | 9461502 | 20260311164719_tOj3i | AU0028 | 2026-03-12T12:17:19.925Z | 2026-03-19T12:45:29.979Z |
| 9461447 | 9461447 | 20260311162247_PiGTY | AU0028 | 2026-03-12T12:17:12.388Z | 2026-03-19T12:45:25.309Z |
| 9461284 | 9461284 | 20260311153513_dadqM | AU0028 | 2026-03-12T12:16:56.254Z | 2026-03-19T12:45:16.490Z |
| 9445306 | 9445306 | 20260307165133_7eeEm | AU0028 | 2026-03-09T12:18:11.433Z | 2026-03-15T12:42:04.543Z |
| 9445298 | 9445298 | 20260307154954_o8Fzg | AU0028 | 2026-03-09T12:17:45.283Z | 2026-03-15T12:42:02.451Z |
| 9445287 | 9445287 | 20260307145746_hCQsU | AU0028 | 2026-03-09T12:17:19.511Z | 2026-03-15T12:41:56.343Z |
| 9444231 | 9444231 | 20260308130206_yZfGh | AU0028 | 2026-03-09T12:10:15.063Z | 2026-03-16T12:44:27.542Z |
| 9440819 | 9440819 | 20260306161006_orMOC | AU0028 | 2026-03-08T12:19:06.569Z | 2026-03-14T12:40:33.054Z |
| 9435255 | 9435255 | 20260306154903_s3K4e | AU0028 | 2026-03-07T14:14:30.095Z | 2026-03-14T12:40:31.554Z |
| 9435247 | 9435247 | 20260306154747_CyyzQ | AU0028 | 2026-03-07T14:14:29.032Z | 2026-03-14T12:40:31.454Z |
| 9434020 | 9434020 | 20260306122029_9irgU | AU0028 | 2026-03-07T14:10:10.441Z | 2026-03-14T12:40:03.545Z |
| 9433870 | 9433870 | 20260306120024_ZDPVf | AU0028 | 2026-03-07T14:09:34.564Z | 2026-03-14T12:40:01.751Z |
| 9431027 | 9431027 | 20260303121208_HMcsA | AU0028 | 2026-03-06T14:27:42.103Z | 2026-03-11T12:28:32.485Z |
| 9428321 | 9428321 | 20260305122757_Cj5ZR | AU0028 | 2026-03-06T14:12:28.699Z | 2026-03-13T12:35:21.967Z |
| 9418603 | 9418603 | 20260301202254_iNVgj | AU0028 | 2026-03-03T14:11:45.314Z | 2026-03-09T12:41:03.296Z |
| 9418517 | 9418517 | 20260301194702_atjtx | AU0028 | 2026-03-03T14:11:33.675Z | 2026-03-09T12:41:00.167Z |
| 9414945 | 9414945 | 20260228185024_K33RU | AU0028 | 2026-03-02T14:07:03.085Z | 2026-03-08T12:42:54.391Z |
| 9414703 | 9414703 | 20260228144711_Howle | AU0028 | 2026-03-02T14:06:21.780Z | 2026-03-08T12:42:28.084Z |
| 9408062 | 9408062 | 20260227122045_3PVAP | AU0028 | 2026-02-28T14:23:20.991Z | 2026-03-07T14:48:50.190Z |
| 9408049 | 9408049 | 20260227121138_tedT5 | AU0028 | 2026-02-28T14:23:17.321Z | 2026-03-07T14:48:48.684Z |
| 9394588 | 9394588 | 20260224204551_fVKqD | AU0028 | 2026-02-26T14:20:09.877Z | 2026-03-04T14:19:24.037Z |
| 9394503 | 9394503 | 20260224202532_tsOIz | AU0028 | 2026-02-26T14:19:58.882Z | 2026-03-04T14:19:22.682Z |
| 9394416 | 9394416 | 20260224200833_6iUAj | AU0028 | 2026-02-26T14:19:45.110Z | 2026-03-04T14:19:21.496Z |
| 9394349 | 9394349 | 20260224195948_jv9Xr | AU0028 | 2026-02-26T14:19:39.623Z | 2026-03-04T14:19:20.905Z |
| 9388506 | 9388506 | 20260224160026_3uoAQ | AU0028 | 2026-02-25T14:22:59.050Z | 2026-03-04T14:18:49.968Z |
| 9388324 | 9388324 | 20260224154043_f2XDe | AU0028 | 2026-02-25T14:22:30.742Z | 2026-03-04T14:18:46.559Z |
| 9388259 | 9388259 | 20260224153336_Tx3Pm | AU0028 | 2026-02-25T14:22:20.696Z | 2026-02-25T14:22:20.696Z |
| 9388024 | 9388024 | 20260224145856_kyHDH | AU0028 | 2026-02-25T14:21:48.147Z | 2026-03-04T14:18:42.053Z |
| 9387922 | 9387922 | 20260224144644_sznyK | AU0028 | 2026-02-25T14:21:38.147Z | 2026-03-04T14:18:40.566Z |
| 9387585 | 9387585 | 20260224140003_BCjIK | AU0028 | 2026-02-25T14:21:01.986Z | 2026-03-04T14:18:35.844Z |
| 9387153 | 9387153 | 20260224123949_kNRwD | AU0028 | 2026-02-25T14:20:07.522Z | 2026-03-04T14:18:28.232Z |
| 9382557 | 9382557 | 20260223170521_cG3h8 | AU0028 | 2026-02-24T14:28:00.170Z | 2026-03-03T14:32:41.934Z |
| 9382392 | 9382392 | 20260223164140_upWFW | AU0028 | 2026-02-24T14:27:50.817Z | 2026-03-03T14:32:40.064Z |
| 9382384 | 9382384 | 20260223164023_cOZ82 | AU0028 | 2026-02-24T14:27:50.561Z | 2026-03-03T14:32:40.047Z |
| 9382144 | 9382144 | 20260223162838_7KXVr | AU0028 | 2026-02-24T14:27:40.184Z | 2026-03-03T14:32:36.776Z |
| 9382139 | 9382139 | 20260223162804_2PCeu | AU0028 | 2026-02-24T14:27:39.380Z | 2026-03-03T14:32:36.555Z |
| 9382081 | 9382081 | 20260223161136_bU2oJ | AU0028 | 2026-02-24T14:27:15.661Z | 2026-03-03T14:32:20.694Z |
| 9382023 | 9382023 | 20260223155500_W7tcv | AU0028 | 2026-02-24T14:27:07.700Z | 2026-03-03T14:32:18.533Z |
| 9381991 | 9381991 | 20260223154739_4AvYr | AU0028 | 2026-02-24T14:27:05.339Z | 2026-03-03T14:32:17.910Z |
| 9381961 | 9381961 | 20260223153353_FieM3 | AU0028 | 2026-02-24T14:26:54.369Z | 2026-03-03T14:32:17.075Z |
| 9381830 | 9381830 | 20260223141136_DxVlV | AU0028 | 2026-02-24T14:26:24.826Z | 2026-03-03T14:32:10.061Z |
| 9381741 | 9381741 | 20260223130822_2r28c | AU0028 | 2026-02-24T14:25:59.926Z | 2026-03-03T14:32:05.088Z |
| 9379665 | 9379665 | 20260222174124_qNL76 | AU0028 | 2026-02-24T14:21:58.534Z | 2026-02-24T14:21:58.534Z |
| 9379631 | 9379631 | 20260222173615_9Ckcr | AU0028 | 2026-02-24T14:21:54.923Z | 2026-02-24T14:21:54.923Z |
| 9379258 | 9379258 | 20260222163239_2vKsZ | AU0028 | 2026-02-24T14:21:05.315Z | 2026-02-24T14:21:05.315Z |
| 9379175 | 9379175 | 20260222162210_lmhlR | AU0028 | 2026-02-24T14:20:57.189Z | 2026-02-24T14:20:57.189Z |
| 9379018 | 9379018 | 20260222155108_iE5XA | AU0028 | 2026-02-24T14:20:27.369Z | 2026-02-24T14:20:27.369Z |
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);