participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,702 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 |
|---|---|---|---|---|---|
| 9616388 | 9616388 | 20260406025746_nPAIH | DK000T | 2026-04-07T12:12:41.469Z | 2026-04-07T12:13:19.971Z |
| 9616247 | 9616247 | 20260406024116_JWqyU | DK000T | 2026-04-07T12:12:30.296Z | 2026-04-07T12:13:19.943Z |
| 9615991 | 9615991 | 20260406021213_yG8DN | DK000T | 2026-04-07T12:11:59.970Z | 2026-04-07T12:13:19.895Z |
| 9614985 | 9614985 | 20260406001858_atcU3 | DK000T | 2026-04-07T12:09:51.309Z | 2026-04-07T12:13:19.712Z |
| 9614838 | 9614838 | 20260405235836_x672c | DK000T | 2026-04-07T12:09:27.480Z | 2026-04-07T12:13:19.680Z |
| 9614608 | 9614608 | 20260405233131_vPq3C | DK000T | 2026-04-07T12:09:01.530Z | 2026-04-07T12:13:19.637Z |
| 9614577 | 9614577 | 20260405232355_KLHJB | DK000T | 2026-04-07T12:08:57.892Z | 2026-04-07T12:13:19.630Z |
| 9614480 | 9614480 | 20260405231422_t5ZiV | DK000T | 2026-04-07T12:08:49.018Z | 2026-04-07T12:13:19.613Z |
| 9610473 | 9610473 | 20260404194343_Ue2Xf | DK000T | 2026-04-06T12:09:40.434Z | 2026-04-07T12:15:11.432Z |
| 9606768 | 9606768 | 20260402204717_qFHH0 | DK000T | 2026-04-04T12:11:32.820Z | 2026-04-07T12:20:15.877Z |
| 9604761 | 9604761 | 20260402003057_Vf3rV | DK000T | 2026-04-03T12:11:28.556Z | 2026-04-07T12:21:49.608Z |
| 9604602 | 9604602 | 20260401215900_5kSAT | DK000T | 2026-04-03T12:10:49.496Z | 2026-04-07T12:21:44.763Z |
| 9604585 | 9604585 | 20260401213611_D5Z8M | DK000T | 2026-04-03T12:10:46.512Z | 2026-04-07T12:21:44.345Z |
| 9604578 | 9604578 | 20260401211345_MXDQT | DK000T | 2026-04-03T12:10:34.712Z | 2026-04-07T12:21:43.278Z |
| 9602773 | 9602773 | 20260402031240_plszV | DK000T | 2026-04-03T12:00:32.896Z | 2026-04-07T12:18:43.926Z |
| 9602758 | 9602758 | 20260402030135_BEZWy | DK000T | 2026-04-03T12:00:29.074Z | 2026-04-07T12:18:43.294Z |
| 9602726 | 9602726 | 20260402025128_En8OU | DK000T | 2026-04-03T12:00:22.135Z | 2026-04-07T12:18:42.039Z |
| 9602633 | 9602633 | 20260401004809_36SdC | DK000T | 2026-04-02T12:09:37.246Z | 2026-04-07T12:23:38.057Z |
| 9602628 | 9602628 | 20260401003243_75Gqz | DK000T | 2026-04-02T12:09:34.694Z | 2026-04-07T12:23:37.884Z |
| 9602616 | 9602616 | 20260401002419_sI9YK | DK000T | 2026-04-02T12:09:32.088Z | 2026-04-07T12:23:37.561Z |
| 9602582 | 9602582 | 20260331235842_3WlCX | DK000T | 2026-04-02T12:09:25.864Z | 2026-04-07T12:23:36.599Z |
| 9602560 | 9602560 | 20260331232308_KKRyN | DK000T | 2026-04-02T12:09:20.785Z | 2026-04-07T12:23:35.917Z |
| 9602544 | 9602544 | 20260331225828_Uqq3X | DK000T | 2026-04-02T12:09:16.879Z | 2026-04-07T12:23:35.521Z |
| 9602526 | 9602526 | 20260331222931_Ji72o | DK000T | 2026-04-02T12:09:11.970Z | 2026-04-07T12:23:34.941Z |
| 9602508 | 9602508 | 20260331220318_sFb3N | DK000T | 2026-04-02T12:09:08.861Z | 2026-04-07T12:23:34.432Z |
| 9602491 | 9602491 | 20260331215158_WCCrW | DK000T | 2026-04-02T12:09:04.027Z | 2026-04-07T12:23:33.961Z |
| 9602482 | 9602482 | 20260331213622_X7Zfw | DK000T | 2026-04-02T12:09:02.657Z | 2026-04-07T12:23:33.687Z |
| 9602463 | 9602463 | 20260331211827_angc6 | DK000T | 2026-04-02T12:08:57.952Z | 2026-04-07T12:23:32.976Z |
| 9602456 | 9602456 | 20260331211721_jRD3u | DK000T | 2026-04-02T12:08:56.176Z | 2026-04-07T12:23:32.735Z |
| 9602412 | 9602412 | 20260331205420_SWE7U | DK000T | 2026-04-02T12:08:45.113Z | 2026-04-07T12:23:30.702Z |
| 9602407 | 9602407 | 20260331204945_1xZod | DK000T | 2026-04-02T12:08:43.055Z | 2026-04-07T12:23:30.129Z |
| 9602397 | 9602397 | 20260331204716_Ep39F | DK000T | 2026-04-02T12:08:42.099Z | 2026-04-07T12:23:29.946Z |
| 9602384 | 9602384 | 20260331203902_83t0X | DK000T | 2026-04-02T12:08:37.318Z | 2026-04-07T12:23:29.375Z |
| 9602342 | 9602342 | 20260331200510_hzlfP | DK000T | 2026-04-02T12:08:28.423Z | 2026-04-07T12:23:27.801Z |
| 9602327 | 9602327 | 20260331195411_zfHAy | DK000T | 2026-04-02T12:08:25.203Z | 2026-04-07T12:23:27.235Z |
| 9600791 | 9600791 | 20260401025359_HAJRq | DK000T | 2026-04-02T12:00:18.121Z | 2026-04-07T12:20:35.559Z |
| 9600472 | 9600472 | 20260330223709_dJUZh | DK000T | 2026-04-01T12:10:52.419Z | 2026-04-07T12:26:05.509Z |
| 9600375 | 9600375 | 20260330205501_3XNH5 | DK000T | 2026-04-01T12:10:29.162Z | 2026-04-07T12:26:01.651Z |
| 9600299 | 9600299 | 20260330195521_g1P58 | DK000T | 2026-04-01T12:10:10.746Z | 2026-04-07T12:25:58.831Z |
| 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 |
| 9562163 | 9562163 | 20260323013938_eOWQ2 | DK000T | 2026-03-24T12:02:20.106Z | 2026-03-31T12:26:02.597Z |
| 9562112 | 9562112 | 20260323013308_6KMHz | DK000T | 2026-03-24T12:02:10.394Z | 2026-03-31T12:26:01.510Z |
| 9562028 | 9562028 | 20260323011852_zyRHB | DK000T | 2026-03-24T12:01:57.548Z | 2026-03-31T12:25:59.777Z |
| 9562026 | 9562026 | 20260323011631_T8HXJ | DK000T | 2026-03-24T12:01:56.912Z | 2026-03-31T12:25:59.675Z |
| 9561995 | 9561995 | 20260323010945_4QIrW | DK000T | 2026-03-24T12:01:48.904Z | 2026-03-31T12:25:58.619Z |
| 9561814 | 9561814 | 20260323004716_2RMvl | DK000T | 2026-03-24T12:01:22.429Z | 2026-03-31T12:25:54.164Z |
| 9561699 | 9561699 | 20260323002901_vcNT7 | DK000T | 2026-03-24T12:00:58.851Z | 2026-03-31T12:25:51.066Z |
| 9561677 | 9561677 | 20260323002242_naedo | DK000T | 2026-03-24T12:00:53.715Z | 2026-03-31T12:25:50.301Z |
| 9561657 | 9561657 | 20260323001956_k3QPz | DK000T | 2026-03-24T12:00:50.459Z | 2026-03-31T12:25:49.732Z |
| 9561555 | 9561555 | 20260323000227_yd7rZ | DK000T | 2026-03-24T12:00:26.622Z | 2026-03-31T12:25:46.879Z |
| 9561334 | 9561334 | 20260321232350_Sq8Wc | DK000T | 2026-03-23T12:12:16.896Z | 2026-03-29T12:21:06.544Z |
| 9561298 | 9561298 | 20260321231856_01Gve | DK000T | 2026-03-23T12:12:15.849Z | 2026-03-29T12:21:06.235Z |
| 9560916 | 9560916 | 20260321223531_k2nFU | DK000T | 2026-03-23T12:12:07.352Z | 2026-03-29T12:21:03.914Z |
| 9560465 | 9560465 | 20260321212903_C3hI2 | DK000T | 2026-03-23T12:11:48.312Z | 2026-03-29T12:21:00.567Z |
| 9560456 | 9560456 | 20260321212547_o3QXp | DK000T | 2026-03-23T12:11:47.662Z | 2026-03-29T12:21:00.402Z |
| 9559863 | 9559863 | 20260321200336_Vi6FH | DK000T | 2026-03-23T12:11:32.529Z | 2026-03-29T12:20:56.162Z |
| 9555005 | 9555005 | 20260322035339_2bQhF | DK000T | 2026-03-23T12:03:01.742Z | 2026-03-30T12:28:13.016Z |
| 9554564 | 9554564 | 20260322031727_cm5nt | DK000T | 2026-03-23T12:02:40.794Z | 2026-03-30T12:28:05.643Z |
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);