participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,720 rows where station_code = "DK000T" 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 |
|---|---|---|---|---|---|
| 9624070 | 9624070 | 20260405210414_qi4c0 | DK000T | 2026-04-08T12:27:08.466Z | 2026-04-08T12:27:08.466Z |
| 9624067 | 9624067 | 20260405210124_pUz3z | DK000T | 2026-04-08T12:27:07.117Z | 2026-04-08T12:27:07.117Z |
| 9624065 | 9624065 | 20260405205644_52XFy | DK000T | 2026-04-08T12:27:03.870Z | 2026-04-08T12:27:03.870Z |
| 9623260 | 9623260 | 20260407025155_0VZih | DK000T | 2026-04-08T12:23:20.156Z | 2026-04-08T12:23:20.156Z |
| 9623016 | 9623016 | 20260407023100_Yxyr3 | DK000T | 2026-04-08T12:22:36.144Z | 2026-04-08T12:22:36.144Z |
| 9622976 | 9622976 | 20260407022733_xH7eA | DK000T | 2026-04-08T12:22:17.939Z | 2026-04-08T12:22:17.939Z |
| 9622796 | 9622796 | 20260407021308_I8J3Q | DK000T | 2026-04-08T12:21:58.064Z | 2026-04-08T12:21:58.064Z |
| 9622163 | 9622163 | 20260407012414_d98cV | DK000T | 2026-04-08T12:20:12.835Z | 2026-04-08T12:20:12.835Z |
| 9622090 | 9622090 | 20260407011852_7h2hz | DK000T | 2026-04-08T12:20:04.437Z | 2026-04-08T12:20:04.437Z |
| 9621913 | 9621913 | 20260407010544_chNnf | DK000T | 2026-04-08T12:19:31.069Z | 2026-04-08T12:19:31.069Z |
| 9621758 | 9621758 | 20260407005142_bctZV | DK000T | 2026-04-08T12:19:04.652Z | 2026-04-08T12:19:04.652Z |
| 9621528 | 9621528 | 20260407003551_d57Gu | DK000T | 2026-04-08T12:18:35.651Z | 2026-04-08T12:18:35.651Z |
| 9621524 | 9621524 | 20260407003542_f08gi | DK000T | 2026-04-08T12:18:26.180Z | 2026-04-08T12:18:26.180Z |
| 9620791 | 9620791 | 20260406235044_qtBot | DK000T | 2026-04-08T12:16:43.985Z | 2026-04-08T12:16:43.985Z |
| 9618634 | 9618634 | 20260406203743_OZ8xA | DK000T | 2026-04-08T12:10:38.667Z | 2026-04-08T12:10:38.667Z |
| 9618604 | 9618604 | 20260406203255_AQxjw | DK000T | 2026-04-08T12:10:34.283Z | 2026-04-08T12:10:34.283Z |
| 9618348 | 9618348 | 20260406194934_bvV8j | DK000T | 2026-04-08T12:09:33.873Z | 2026-04-08T12:09:33.873Z |
| 9618327 | 9618327 | 20260406194803_HquSC | DK000T | 2026-04-08T12:09:28.576Z | 2026-04-08T12:09:28.576Z |
| 9616388 | 9616388 | 20260406025746_nPAIH | DK000T | 2026-04-07T12:12:41.469Z | 2026-04-08T12:29:31.570Z |
| 9616247 | 9616247 | 20260406024116_JWqyU | DK000T | 2026-04-07T12:12:30.296Z | 2026-04-08T12:29:16.131Z |
| 9615991 | 9615991 | 20260406021213_yG8DN | DK000T | 2026-04-07T12:11:59.970Z | 2026-04-08T12:29:05.932Z |
| 9614985 | 9614985 | 20260406001858_atcU3 | DK000T | 2026-04-07T12:09:51.309Z | 2026-04-08T12:28:23.148Z |
| 9614838 | 9614838 | 20260405235836_x672c | DK000T | 2026-04-07T12:09:27.480Z | 2026-04-08T12:28:08.613Z |
| 9614608 | 9614608 | 20260405233131_vPq3C | DK000T | 2026-04-07T12:09:01.530Z | 2026-04-08T12:27:59.040Z |
| 9614577 | 9614577 | 20260405232355_KLHJB | DK000T | 2026-04-07T12:08:57.892Z | 2026-04-08T12:27:57.808Z |
| 9614480 | 9614480 | 20260405231422_t5ZiV | DK000T | 2026-04-07T12:08:49.018Z | 2026-04-08T12:27:54.941Z |
| 9610473 | 9610473 | 20260404194343_Ue2Xf | DK000T | 2026-04-06T12:09:40.434Z | 2026-04-08T12:31:03.876Z |
| 9606768 | 9606768 | 20260402204717_qFHH0 | DK000T | 2026-04-04T12:11:32.820Z | 2026-04-08T12:37:21.748Z |
| 9604761 | 9604761 | 20260402003057_Vf3rV | DK000T | 2026-04-03T12:11:28.556Z | 2026-04-08T12:39:13.647Z |
| 9604602 | 9604602 | 20260401215900_5kSAT | DK000T | 2026-04-03T12:10:49.496Z | 2026-04-08T12:39:08.983Z |
| 9604585 | 9604585 | 20260401213611_D5Z8M | DK000T | 2026-04-03T12:10:46.512Z | 2026-04-08T12:39:08.660Z |
| 9604578 | 9604578 | 20260401211345_MXDQT | DK000T | 2026-04-03T12:10:34.712Z | 2026-04-08T12:39:07.681Z |
| 9602773 | 9602773 | 20260402031240_plszV | DK000T | 2026-04-03T12:00:32.896Z | 2026-04-08T12:35:32.942Z |
| 9602758 | 9602758 | 20260402030135_BEZWy | DK000T | 2026-04-03T12:00:29.074Z | 2026-04-08T12:35:32.432Z |
| 9602726 | 9602726 | 20260402025128_En8OU | DK000T | 2026-04-03T12:00:22.135Z | 2026-04-08T12:35:31.036Z |
| 9602633 | 9602633 | 20260401004809_36SdC | DK000T | 2026-04-02T12:09:37.246Z | 2026-04-08T12:41:39.433Z |
| 9602628 | 9602628 | 20260401003243_75Gqz | DK000T | 2026-04-02T12:09:34.694Z | 2026-04-08T12:41:39.341Z |
| 9602616 | 9602616 | 20260401002419_sI9YK | DK000T | 2026-04-02T12:09:32.088Z | 2026-04-08T12:41:38.970Z |
| 9602582 | 9602582 | 20260331235842_3WlCX | DK000T | 2026-04-02T12:09:25.864Z | 2026-04-08T12:41:38.167Z |
| 9602560 | 9602560 | 20260331232308_KKRyN | DK000T | 2026-04-02T12:09:20.785Z | 2026-04-08T12:41:37.592Z |
| 9602544 | 9602544 | 20260331225828_Uqq3X | DK000T | 2026-04-02T12:09:16.879Z | 2026-04-08T12:41:37.174Z |
| 9602526 | 9602526 | 20260331222931_Ji72o | DK000T | 2026-04-02T12:09:11.970Z | 2026-04-08T12:41:36.761Z |
| 9602508 | 9602508 | 20260331220318_sFb3N | DK000T | 2026-04-02T12:09:08.861Z | 2026-04-08T12:41:36.333Z |
| 9602491 | 9602491 | 20260331215158_WCCrW | DK000T | 2026-04-02T12:09:04.027Z | 2026-04-08T12:41:35.900Z |
| 9602482 | 9602482 | 20260331213622_X7Zfw | DK000T | 2026-04-02T12:09:02.657Z | 2026-04-08T12:41:35.611Z |
| 9602463 | 9602463 | 20260331211827_angc6 | DK000T | 2026-04-02T12:08:57.952Z | 2026-04-08T12:41:34.951Z |
| 9602456 | 9602456 | 20260331211721_jRD3u | DK000T | 2026-04-02T12:08:56.176Z | 2026-04-08T12:41:34.763Z |
| 9602412 | 9602412 | 20260331205420_SWE7U | DK000T | 2026-04-02T12:08:45.113Z | 2026-04-08T12:41:32.997Z |
| 9602407 | 9602407 | 20260331204945_1xZod | DK000T | 2026-04-02T12:08:43.055Z | 2026-04-08T12:41:32.545Z |
| 9602397 | 9602397 | 20260331204716_Ep39F | DK000T | 2026-04-02T12:08:42.099Z | 2026-04-08T12:41:32.414Z |
| 9602384 | 9602384 | 20260331203902_83t0X | DK000T | 2026-04-02T12:08:37.318Z | 2026-04-08T12:41:31.732Z |
| 9602342 | 9602342 | 20260331200510_hzlfP | DK000T | 2026-04-02T12:08:28.423Z | 2026-04-08T12:41:30.184Z |
| 9602327 | 9602327 | 20260331195411_zfHAy | DK000T | 2026-04-02T12:08:25.203Z | 2026-04-08T12:41:29.714Z |
| 9600791 | 9600791 | 20260401025359_HAJRq | DK000T | 2026-04-02T12:00:18.121Z | 2026-04-08T12:37:48.969Z |
| 9600472 | 9600472 | 20260330223709_dJUZh | DK000T | 2026-04-01T12:10:52.419Z | 2026-04-08T12:44:33.929Z |
| 9600375 | 9600375 | 20260330205501_3XNH5 | DK000T | 2026-04-01T12:10:29.162Z | 2026-04-08T12:44:31.350Z |
| 9600299 | 9600299 | 20260330195521_g1P58 | DK000T | 2026-04-01T12:10:10.746Z | 2026-04-08T12:44:28.688Z |
| 9594949 | 9594949 | 20260329010814_8Q1V1 | DK000T | 2026-03-30T12:10:40.757Z | 2026-04-06T12:40:21.429Z |
| 9594911 | 9594911 | 20260329010042_duq6u | DK000T | 2026-03-30T12:10:36.617Z | 2026-04-06T12:40:20.269Z |
| 9594817 | 9594817 | 20260329003506_70Tye | DK000T | 2026-03-30T12:10:22.079Z | 2026-04-06T12:40:16.718Z |
| 9594785 | 9594785 | 20260329003210_TCMn2 | DK000T | 2026-03-30T12:10:19.274Z | 2026-04-06T12:40:15.893Z |
| 9594740 | 9594740 | 20260329001902_kwxO6 | DK000T | 2026-03-30T12:10:14.731Z | 2026-04-06T12:40:14.334Z |
| 9594721 | 9594721 | 20260329001216_RkvzG | DK000T | 2026-03-30T12:10:13.240Z | 2026-04-06T12:40:13.815Z |
| 9594595 | 9594595 | 20260328232343_Se3KW | DK000T | 2026-03-30T12:09:55.449Z | 2026-04-06T12:40:00.715Z |
| 9594580 | 9594580 | 20260328231146_yUIVv | DK000T | 2026-03-30T12:09:53.072Z | 2026-04-06T12:39:59.942Z |
| 9594501 | 9594501 | 20260328223906_0djd3 | DK000T | 2026-03-30T12:09:41.832Z | 2026-04-06T12:39:54.670Z |
| 9594421 | 9594421 | 20260328221944_JiU1p | DK000T | 2026-03-30T12:09:32.744Z | 2026-04-06T12:39:51.956Z |
| 9594344 | 9594344 | 20260328214056_V3qGT | DK000T | 2026-03-30T12:09:21.281Z | 2026-04-06T12:39:48.769Z |
| 9594312 | 9594312 | 20260328211936_R50eJ | DK000T | 2026-03-30T12:09:17.112Z | 2026-04-06T12:39:47.629Z |
| 9592606 | 9592606 | 20260329024600_41E0l | DK000T | 2026-03-30T12:01:25.775Z | 2026-04-07T12:26:36.014Z |
| 9588674 | 9588674 | 20260327002437_NkG5H | DK000T | 2026-03-28T12:11:37.993Z | 2026-04-04T12:42:25.979Z |
| 9588496 | 9588496 | 20260326232423_v98sM | DK000T | 2026-03-28T12:11:16.493Z | 2026-04-04T12:42:16.522Z |
| 9585931 | 9585931 | 20260327031021_QhZfC | DK000T | 2026-03-28T12:01:46.391Z | 2026-04-05T12:32:53.295Z |
| 9585840 | 9585840 | 20260327024710_cPGaR | DK000T | 2026-03-28T12:01:30.784Z | 2026-04-05T12:32:48.605Z |
| 9585743 | 9585743 | 20260327021906_gRi49 | DK000T | 2026-03-28T12:01:10.241Z | 2026-04-05T12:32:36.999Z |
| 9585527 | 9585527 | 20260327012642_oZEaZ | DK000T | 2026-03-28T12:00:33.895Z | 2026-04-05T12:32:25.114Z |
| 9585454 | 9585454 | 20260327010342_vr3pE | DK000T | 2026-03-28T12:00:23.295Z | 2026-04-05T12:32:21.915Z |
| 9585411 | 9585411 | 20260327005403_pnuAW | DK000T | 2026-03-28T12:00:15.408Z | 2026-04-05T12:32:20.021Z |
| 9570872 | 9570872 | 20260322230441_i4Guw | DK000T | 2026-03-24T12:23:57.339Z | 2026-03-30T12:30:50.875Z |
| 9570627 | 9570627 | 20260322221820_MSbG2 | DK000T | 2026-03-24T12:23:33.105Z | 2026-03-30T12:30:46.748Z |
| 9570496 | 9570496 | 20260322214004_SR98E | DK000T | 2026-03-24T12:23:21.929Z | 2026-03-30T12:30:44.217Z |
| 9570493 | 9570493 | 20260322213931_mSmiZ | DK000T | 2026-03-24T12:23:21.661Z | 2026-03-30T12:30:44.145Z |
| 9570451 | 9570451 | 20260322212856_XSOrY | DK000T | 2026-03-24T12:23:18.067Z | 2026-03-30T12:30:43.285Z |
| 9570426 | 9570426 | 20260322211718_VwwI0 | DK000T | 2026-03-24T12:23:15.722Z | 2026-03-30T12:30:42.522Z |
| 9570403 | 9570403 | 20260322210938_vjMO9 | DK000T | 2026-03-24T12:23:09.770Z | 2026-03-30T12:30:41.915Z |
| 9570375 | 9570375 | 20260322205520_FDdcO | DK000T | 2026-03-24T12:23:06.748Z | 2026-03-30T12:30:41.304Z |
| 9570365 | 9570365 | 20260322204943_Z23x1 | DK000T | 2026-03-24T12:23:04.751Z | 2026-03-30T12:30:40.933Z |
| 9570244 | 9570244 | 20260322201200_zILAO | DK000T | 2026-03-24T12:22:51.952Z | 2026-03-30T12:30:37.853Z |
| 9570231 | 9570231 | 20260322200722_TEwg5 | DK000T | 2026-03-24T12:22:50.702Z | 2026-03-30T12:30:37.532Z |
| 9570198 | 9570198 | 20260322194738_jjEEG | DK000T | 2026-03-24T12:22:47.205Z | 2026-03-30T12:30:30.586Z |
| 9570169 | 9570169 | 20260322193545_UHIJO | DK000T | 2026-03-24T12:22:44.421Z | 2026-03-30T12:30:28.980Z |
| 9570162 | 9570162 | 20260322193430_c6T02 | DK000T | 2026-03-24T12:22:40.536Z | 2026-03-30T12:30:28.925Z |
| 9562746 | 9562746 | 20260323030809_HpiCJ | DK000T | 2026-03-24T12:03:55.874Z | 2026-03-31T12:26:24.875Z |
| 9562738 | 9562738 | 20260323030743_2uq3L | DK000T | 2026-03-24T12:03:53.985Z | 2026-03-31T12:26:24.473Z |
| 9562617 | 9562617 | 20260323024812_JHh3S | DK000T | 2026-03-24T12:03:34.201Z | 2026-03-31T12:26:15.764Z |
| 9562602 | 9562602 | 20260323024548_iOfOU | DK000T | 2026-03-24T12:03:32.539Z | 2026-03-31T12:26:15.450Z |
| 9562537 | 9562537 | 20260323022945_uph2K | DK000T | 2026-03-24T12:03:21.146Z | 2026-03-31T12:26:13.606Z |
| 9562287 | 9562287 | 20260323020434_KO4CA | DK000T | 2026-03-24T12:02:44.312Z | 2026-03-31T12:26:06.701Z |
| 9562252 | 9562252 | 20260323015342_gZcX2 | DK000T | 2026-03-24T12:02:35.664Z | 2026-03-31T12:26:05.121Z |
| 9562217 | 9562217 | 20260323015115_bFdcd | DK000T | 2026-03-24T12:02:29.436Z | 2026-03-31T12:26:04.135Z |
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);