participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,060 rows where station_code = "DK000J" 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 |
|---|---|---|---|---|---|
| 9615359 | 9615359 | 20260406010458_NpN2L | DK000J | 2026-04-07T12:10:39.974Z | 2026-04-07T12:13:19.787Z |
| 9615213 | 9615213 | 20260406004830_52Ias | DK000J | 2026-04-07T12:10:17.226Z | 2026-04-07T12:13:19.758Z |
| 9614202 | 9614202 | 20260405223123_NTnDI | DK000J | 2026-04-07T12:08:12.466Z | 2026-04-07T12:13:19.542Z |
| 9611080 | 9611080 | 20260405000304_z2tRJ | DK000J | 2026-04-06T12:12:56.657Z | 2026-04-07T12:15:50.554Z |
| 9611021 | 9611021 | 20260404232509_2v5He | DK000J | 2026-04-06T12:12:36.299Z | 2026-04-07T12:15:45.358Z |
| 9611018 | 9611018 | 20260404232302_3h8j2 | DK000J | 2026-04-06T12:12:35.621Z | 2026-04-07T12:15:45.134Z |
| 9610886 | 9610886 | 20260404224320_pAIGU | DK000J | 2026-04-06T12:11:55.499Z | 2026-04-07T12:15:38.310Z |
| 9610634 | 9610634 | 20260404205711_9SI0N | DK000J | 2026-04-06T12:10:32.186Z | 2026-04-07T12:15:21.369Z |
| 9610627 | 9610627 | 20260404205706_pJzMZ | DK000J | 2026-04-06T12:10:31.379Z | 2026-04-07T12:15:21.155Z |
| 9610609 | 9610609 | 20260404204758_MsGKk | DK000J | 2026-04-06T12:10:22.648Z | 2026-04-07T12:15:20.174Z |
| 9610607 | 9610607 | 20260404204751_sdQGz | DK000J | 2026-04-06T12:10:21.942Z | 2026-04-07T12:15:20.051Z |
| 9610594 | 9610594 | 20260404204559_6xU2N | DK000J | 2026-04-06T12:10:15.995Z | 2026-04-07T12:15:19.523Z |
| 9610587 | 9610587 | 20260404204531_KGMH3 | DK000J | 2026-04-06T12:10:14.936Z | 2026-04-07T12:15:19.268Z |
| 9610537 | 9610537 | 20260404201802_7hmKb | DK000J | 2026-04-06T12:10:04.246Z | 2026-04-07T12:15:15.136Z |
| 9610492 | 9610492 | 20260404195151_NHwAM | DK000J | 2026-04-06T12:09:44.564Z | 2026-04-07T12:15:12.246Z |
| 9602640 | 9602640 | 20260401012508_3mkLh | DK000J | 2026-04-02T12:09:39.578Z | 2026-04-07T12:23:38.428Z |
| 9600813 | 9600813 | 20260401031427_oA33o | DK000J | 2026-04-02T12:00:25.085Z | 2026-04-07T12:20:36.615Z |
| 9600764 | 9600764 | 20260401022723_5YuRY | DK000J | 2026-04-02T12:00:10.612Z | 2026-04-07T12:20:27.199Z |
| 9600499 | 9600499 | 20260330224346_KBSAM | DK000J | 2026-04-01T12:10:56.560Z | 2026-04-07T12:26:06.137Z |
| 9592718 | 9592718 | 20260329030610_ji08I | DK000J | 2026-03-30T12:01:42.782Z | 2026-04-07T12:26:39.282Z |
| 9592671 | 9592671 | 20260329025721_3wLHj | DK000J | 2026-03-30T12:01:34.950Z | 2026-04-07T12:26:38.163Z |
| 9592536 | 9592536 | 20260329022457_XcLYy | DK000J | 2026-03-30T12:01:13.825Z | 2026-04-07T12:26:34.450Z |
| 9592483 | 9592483 | 20260329021714_MBxGP | DK000J | 2026-03-30T12:01:06.428Z | 2026-04-07T12:26:33.505Z |
| 9591792 | 9591792 | 20260327213322_6fT0L | DK000J | 2026-03-29T12:06:45.677Z | 2026-04-05T12:35:13.970Z |
| 9591721 | 9591721 | 20260327185734_hNjeR | DK000J | 2026-03-29T12:06:35.887Z | 2026-04-05T12:35:07.832Z |
| 9589241 | 9589241 | 20260328025845_hPG1f | DK000J | 2026-03-29T12:00:58.212Z | 2026-04-06T12:37:09.582Z |
| 9588686 | 9588686 | 20260327003336_gIRCb | DK000J | 2026-03-28T12:11:39.115Z | 2026-04-04T12:42:26.892Z |
| 9588666 | 9588666 | 20260327002155_hmDNH | DK000J | 2026-03-28T12:11:37.349Z | 2026-04-04T12:42:25.545Z |
| 9588652 | 9588652 | 20260327001720_CFTWt | DK000J | 2026-03-28T12:11:31.424Z | 2026-04-04T12:42:24.435Z |
| 9588614 | 9588614 | 20260327000641_ataq9 | DK000J | 2026-03-28T12:11:28.300Z | 2026-04-04T12:42:21.994Z |
| 9588505 | 9588505 | 20260326232708_UPL3I | DK000J | 2026-03-28T12:11:17.633Z | 2026-04-04T12:42:17.108Z |
| 9586024 | 9586024 | 20260327033727_V0ZZP | DK000J | 2026-03-28T12:02:00.045Z | 2026-04-05T12:32:57.250Z |
| 9585856 | 9585856 | 20260327025100_ey5vp | DK000J | 2026-03-28T12:01:34.464Z | 2026-04-05T12:32:49.492Z |
| 9585854 | 9585854 | 20260327025059_DseoW | DK000J | 2026-03-28T12:01:34.010Z | 2026-04-05T12:32:49.335Z |
| 9585490 | 9585490 | 20260327011946_3Dms9 | DK000J | 2026-03-28T12:00:29.940Z | 2026-04-05T12:32:23.738Z |
| 9585437 | 9585437 | 20260327005806_hAh1M | DK000J | 2026-03-28T12:00:20.849Z | 2026-04-05T12:32:21.195Z |
| 9584692 | 9584692 | 20260325213810_7WeZw | DK000J | 2026-03-27T12:15:58.253Z | 2026-04-03T12:39:26.583Z |
| 9584590 | 9584590 | 20260325205248_gdOET | DK000J | 2026-03-27T12:15:43.670Z | 2026-04-03T12:39:22.977Z |
| 9584584 | 9584584 | 20260325204805_eBvS3 | DK000J | 2026-03-27T12:15:42.920Z | 2026-04-03T12:39:22.777Z |
| 9584498 | 9584498 | 20260325201122_IRVla | DK000J | 2026-03-27T12:15:29.478Z | 2026-04-03T12:39:17.024Z |
| 9576643 | 9576643 | 20260325024654_qzKmH | DK000J | 2026-03-26T12:02:52.858Z | 2026-04-03T12:36:15.665Z |
| 9575503 | 9575503 | 20260323224935_NWiC5 | DK000J | 2026-03-25T12:21:16.715Z | 2026-03-31T12:29:00.320Z |
| 9575363 | 9575363 | 20260323212743_2rN0m | DK000J | 2026-03-25T12:20:55.813Z | 2026-03-31T12:28:55.747Z |
| 9570881 | 9570881 | 20260322230732_Ka3yZ | DK000J | 2026-03-24T12:23:58.062Z | 2026-03-30T12:30:51.126Z |
| 9570794 | 9570794 | 20260322224934_MxCBM | DK000J | 2026-03-24T12:23:49.829Z | 2026-03-30T12:30:49.525Z |
| 9570791 | 9570791 | 20260322224756_GZKYJ | DK000J | 2026-03-24T12:23:49.514Z | 2026-03-30T12:30:49.471Z |
| 9570760 | 9570760 | 20260322224306_wTZ6A | DK000J | 2026-03-24T12:23:47.198Z | 2026-03-30T12:30:48.940Z |
| 9570575 | 9570575 | 20260322220706_wl5wL | DK000J | 2026-03-24T12:23:29.331Z | 2026-03-30T12:30:45.763Z |
| 9570535 | 9570535 | 20260322215607_wXf5E | DK000J | 2026-03-24T12:23:25.630Z | 2026-03-30T12:30:44.976Z |
| 9570454 | 9570454 | 20260322212933_ZTmgM | DK000J | 2026-03-24T12:23:18.843Z | 2026-03-30T12:30:43.438Z |
| 9570415 | 9570415 | 20260322211621_Qqv5q | DK000J | 2026-03-24T12:23:10.958Z | 2026-03-30T12:30:42.355Z |
| 9570305 | 9570305 | 20260322202728_PoATa | DK000J | 2026-03-24T12:22:58.162Z | 2026-03-30T12:30:39.468Z |
| 9570178 | 9570178 | 20260322193915_4IuL4 | DK000J | 2026-03-24T12:22:45.650Z | 2026-03-30T12:30:29.129Z |
| 9570158 | 9570158 | 20260322193344_UrV25 | DK000J | 2026-03-24T12:22:40.040Z | 2026-03-30T12:30:28.830Z |
| 9562725 | 9562725 | 20260323030549_zpBtQ | DK000J | 2026-03-24T12:03:52.035Z | 2026-03-31T12:26:24.152Z |
| 9562644 | 9562644 | 20260323025512_y8uKg | DK000J | 2026-03-24T12:03:39.376Z | 2026-03-31T12:26:16.536Z |
| 9562492 | 9562492 | 20260323022552_BjatC | DK000J | 2026-03-24T12:03:16.169Z | 2026-03-31T12:26:12.886Z |
| 9562335 | 9562335 | 20260323020917_y2Iz2 | DK000J | 2026-03-24T12:02:50.988Z | 2026-03-31T12:26:07.965Z |
| 9561802 | 9561802 | 20260323004347_7NwAV | DK000J | 2026-03-24T12:01:19.388Z | 2026-03-31T12:25:53.903Z |
| 9561782 | 9561782 | 20260323004337_1EZnm | DK000J | 2026-03-24T12:01:17.498Z | 2026-03-31T12:25:53.673Z |
| 9561523 | 9561523 | 20260322235631_ucnde | DK000J | 2026-03-24T12:00:16.799Z | 2026-03-31T12:25:45.921Z |
| 9561162 | 9561162 | 20260321230418_EOYEh | DK000J | 2026-03-23T12:12:12.598Z | 2026-03-29T12:21:05.428Z |
| 9561054 | 9561054 | 20260321225113_cpSva | DK000J | 2026-03-23T12:12:10.731Z | 2026-03-29T12:21:04.930Z |
| 9560908 | 9560908 | 20260321223450_3nn52 | DK000J | 2026-03-23T12:12:07.093Z | 2026-03-29T12:21:03.859Z |
| 9560875 | 9560875 | 20260321223009_EzKBw | DK000J | 2026-03-23T12:12:06.128Z | 2026-03-29T12:21:03.536Z |
| 9560813 | 9560813 | 20260321222039_USmD4 | DK000J | 2026-03-23T12:12:04.515Z | 2026-03-29T12:21:03.027Z |
| 9560481 | 9560481 | 20260321213058_2tIvi | DK000J | 2026-03-23T12:11:48.696Z | 2026-03-29T12:21:00.643Z |
| 9560380 | 9560380 | 20260321210716_vo3br | DK000J | 2026-03-23T12:11:44.825Z | 2026-03-29T12:20:59.790Z |
| 9559824 | 9559824 | 20260321195528_ZkEy8 | DK000J | 2026-03-23T12:11:31.433Z | 2026-03-29T12:20:55.964Z |
| 9559798 | 9559798 | 20260321194853_lsvDz | DK000J | 2026-03-23T12:11:30.395Z | 2026-03-29T12:20:55.368Z |
| 9554549 | 9554549 | 20260322031710_EKJHM | DK000J | 2026-03-23T12:02:39.953Z | 2026-03-30T12:28:05.399Z |
| 9554546 | 9554546 | 20260322031627_ad175 | DK000J | 2026-03-23T12:02:39.728Z | 2026-03-30T12:28:05.357Z |
| 9554495 | 9554495 | 20260322031330_pOKQI | DK000J | 2026-03-23T12:02:37.553Z | 2026-03-30T12:28:04.776Z |
| 9554450 | 9554450 | 20260322030929_qbupz | DK000J | 2026-03-23T12:02:32.549Z | 2026-03-30T12:28:04.005Z |
| 9554412 | 9554412 | 20260322030615_WpiFN | DK000J | 2026-03-23T12:02:31.141Z | 2026-03-30T12:28:03.548Z |
| 9553875 | 9553875 | 20260322022254_PdEJl | DK000J | 2026-03-23T12:01:56.825Z | 2026-03-30T12:27:53.965Z |
| 9553711 | 9553711 | 20260322020831_KXUg7 | DK000J | 2026-03-23T12:01:47.455Z | 2026-03-30T12:27:51.384Z |
| 9553393 | 9553393 | 20260322013809_dKLi0 | DK000J | 2026-03-23T12:01:27.610Z | 2026-03-30T12:27:40.321Z |
| 9553174 | 9553174 | 20260322012248_VK93v | DK000J | 2026-03-23T12:01:18.207Z | 2026-03-30T12:27:36.096Z |
| 9552999 | 9552999 | 20260322010238_iV2XN | DK000J | 2026-03-23T12:01:08.427Z | 2026-03-30T12:27:33.557Z |
| 9552929 | 9552929 | 20260322005652_fik3O | DK000J | 2026-03-23T12:01:01.012Z | 2026-03-30T12:27:32.386Z |
| 9552854 | 9552854 | 20260322004823_VF8Zp | DK000J | 2026-03-23T12:00:56.500Z | 2026-03-30T12:27:31.373Z |
| 9552812 | 9552812 | 20260322004517_7uhrY | DK000J | 2026-03-23T12:00:53.514Z | 2026-03-30T12:27:30.732Z |
| 9552791 | 9552791 | 20260322004401_2qDrH | DK000J | 2026-03-23T12:00:51.948Z | 2026-03-30T12:27:30.336Z |
| 9552283 | 9552283 | 20260321234829_7nXbJ | DK000J | 2026-03-23T12:00:11.298Z | 2026-03-30T12:27:21.763Z |
| 9552205 | 9552205 | 20260320232004_dAbjE | DK000J | 2026-03-22T12:27:32.842Z | 2026-03-28T12:37:07.893Z |
| 9552105 | 9552105 | 20260320225829_Na3Sq | DK000J | 2026-03-22T12:27:27.657Z | 2026-03-28T12:37:06.992Z |
| 9551967 | 9551967 | 20260320222504_36VIV | DK000J | 2026-03-22T12:27:20.182Z | 2026-03-28T12:37:05.062Z |
| 9551894 | 9551894 | 20260320220617_FGQZe | DK000J | 2026-03-22T12:27:16.067Z | 2026-03-28T12:37:03.806Z |
| 9551881 | 9551881 | 20260320220503_WUAjl | DK000J | 2026-03-22T12:27:15.345Z | 2026-03-28T12:37:03.549Z |
| 9551651 | 9551651 | 20260320204130_oxnOx | DK000J | 2026-03-22T12:26:53.928Z | 2026-03-28T12:36:59.419Z |
| 9542725 | 9542725 | 20260321010111_yl8dr | DK000J | 2026-03-22T12:01:25.440Z | 2026-03-29T12:18:57.628Z |
| 9542687 | 9542687 | 20260321004730_2h2Im | DK000J | 2026-03-22T12:01:15.308Z | 2026-03-29T12:18:57.037Z |
| 9542525 | 9542525 | 20260321000104_FA92q | DK000J | 2026-03-22T12:00:37.440Z | 2026-03-29T12:18:45.188Z |
| 9542523 | 9542523 | 20260321000011_gWt4I | DK000J | 2026-03-22T12:00:36.835Z | 2026-03-29T12:18:45.119Z |
| 9542513 | 9542513 | 20260320235708_0Vl7B | DK000J | 2026-03-22T12:00:34.058Z | 2026-03-29T12:18:44.980Z |
| 9534190 | 9534190 | 20260320033425_bDlym | DK000J | 2026-03-21T12:07:24.643Z | 2026-03-28T12:34:15.752Z |
| 9534165 | 9534165 | 20260320033312_Bz8C8 | DK000J | 2026-03-21T12:07:19.811Z | 2026-03-28T12:34:15.278Z |
| 9531168 | 9531168 | 20260318223917_jjzKN | DK000J | 2026-03-20T12:25:00.521Z | 2026-03-26T12:39:17.935Z |
| 9530467 | 9530467 | 20260318205914_z84zM | DK000J | 2026-03-20T12:24:25.370Z | 2026-03-26T12:39:12.647Z |
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);