participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,452 rows where station_code = "DK0001" 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 |
---|---|---|---|---|---|
5135656 | 5135656 | 20240914030411_GAnZK | DK0001 | 2024-09-19T12:19:59.607Z | 2024-09-19T12:19:59.607Z |
5127555 | 5127555 | 20240916222942_R59jI | DK0001 | 2024-09-19T12:09:23.044Z | 2024-09-19T12:09:23.044Z |
5120706 | 5120706 | 20240914033248_cvgVK | DK0001 | 2024-09-18T12:10:46.018Z | 2024-09-19T12:20:00.782Z |
5120577 | 5120577 | 20240914032820_z23NM | DK0001 | 2024-09-18T12:10:43.236Z | 2024-09-19T12:20:00.608Z |
5120362 | 5120362 | 20240914031800_RofvF | DK0001 | 2024-09-18T12:10:38.476Z | 2024-09-19T12:20:00.067Z |
5120132 | 5120132 | 20240914030105_elny2 | DK0001 | 2024-09-18T12:10:32.542Z | 2024-09-19T12:19:59.459Z |
5119357 | 5119357 | 20240914022735_My7ON | DK0001 | 2024-09-18T12:10:20.509Z | 2024-09-19T12:19:58.058Z |
5119220 | 5119220 | 20240914021831_2SKUF | DK0001 | 2024-09-18T12:10:18.738Z | 2024-09-19T12:19:57.469Z |
5116231 | 5116231 | 20240915031653_DA969 | DK0001 | 2024-09-18T12:06:50.126Z | 2024-09-19T12:19:09.920Z |
5115853 | 5115853 | 20240915025623_arBZ3 | DK0001 | 2024-09-18T12:06:28.848Z | 2024-09-19T12:19:07.526Z |
5115424 | 5115424 | 20240915023716_4yEZs | DK0001 | 2024-09-18T12:06:13.567Z | 2024-09-19T12:19:04.604Z |
5115324 | 5115324 | 20240915023243_FQFUI | DK0001 | 2024-09-18T12:06:10.958Z | 2024-09-19T12:19:03.945Z |
5115193 | 5115193 | 20240915022632_95Mmm | DK0001 | 2024-09-18T12:06:05.633Z | 2024-09-19T12:19:02.905Z |
5114846 | 5114846 | 20240915020042_A3bGE | DK0001 | 2024-09-18T12:05:37.102Z | 2024-09-19T12:19:00.267Z |
5114587 | 5114587 | 20240915015112_u049m | DK0001 | 2024-09-18T12:05:23.326Z | 2024-09-19T12:18:59.014Z |
5113672 | 5113672 | 20240915010501_KMGKK | DK0001 | 2024-09-18T12:04:39.142Z | 2024-09-19T12:18:50.977Z |
5113546 | 5113546 | 20240915005745_zlMy0 | DK0001 | 2024-09-18T12:04:27.870Z | 2024-09-19T12:18:50.160Z |
5113437 | 5113437 | 20240915004946_ibZ97 | DK0001 | 2024-09-18T12:04:17.279Z | 2024-09-19T12:18:49.129Z |
5112778 | 5112778 | 20240914235356_a5Yak | DK0001 | 2024-09-18T12:03:32.401Z | 2024-09-19T12:18:44.689Z |
5112367 | 5112367 | 20240914230556_nZ0TC | DK0001 | 2024-09-18T12:03:01.476Z | 2024-09-19T12:18:40.735Z |
5112285 | 5112285 | 20240914225106_wZgfh | DK0001 | 2024-09-18T12:02:58.448Z | 2024-09-19T12:18:40.373Z |
5112109 | 5112109 | 20240914221552_pvlWj | DK0001 | 2024-09-18T12:02:48.158Z | 2024-09-19T12:18:38.368Z |
5112084 | 5112084 | 20240914221019_3S3Do | DK0001 | 2024-09-18T12:02:46.996Z | 2024-09-19T12:18:38.026Z |
5111194 | 5111194 | 20240914201012_Lb4gj | DK0001 | 2024-09-18T12:01:42.722Z | 2024-09-19T12:18:27.318Z |
5106916 | 5106916 | 20240913033834_Q8NT4 | DK0001 | 2024-09-17T12:13:03.954Z | 2024-09-19T12:20:46.516Z |
5106375 | 5106375 | 20240913032225_5M5sf | DK0001 | 2024-09-17T12:12:51.500Z | 2024-09-19T12:20:46.012Z |
5106329 | 5106329 | 20240913031936_6i1Oy | DK0001 | 2024-09-17T12:12:50.304Z | 2024-09-19T12:20:45.910Z |
5105984 | 5105984 | 20240913030509_R2EMQ | DK0001 | 2024-09-17T12:12:34.822Z | 2024-09-19T12:20:45.103Z |
5105712 | 5105712 | 20240913025533_38VWk | DK0001 | 2024-09-17T12:12:27.423Z | 2024-09-19T12:20:44.834Z |
5105157 | 5105157 | 20240913023407_Cls96 | DK0001 | 2024-09-17T12:11:59.761Z | 2024-09-19T12:20:44.011Z |
5105114 | 5105114 | 20240913023138_864BY | DK0001 | 2024-09-17T12:11:56.664Z | 2024-09-19T12:20:43.711Z |
5105086 | 5105086 | 20240913023005_SZnmf | DK0001 | 2024-09-17T12:11:54.465Z | 2024-09-19T12:20:43.503Z |
5103216 | 5103216 | 20240914020539_EAPia | DK0001 | 2024-09-17T12:07:58.984Z | 2024-09-19T12:19:56.915Z |
5102663 | 5102663 | 20240914013655_Q4aEV | DK0001 | 2024-09-17T12:07:30.178Z | 2024-09-19T12:19:55.365Z |
5102435 | 5102435 | 20240914012543_qVWYe | DK0001 | 2024-09-17T12:07:09.633Z | 2024-09-19T12:19:54.139Z |
5102431 | 5102431 | 20240914012543_urZiu | DK0001 | 2024-09-17T12:07:09.325Z | 2024-09-19T12:19:54.136Z |
5102309 | 5102309 | 20240914011724_tZwOf | DK0001 | 2024-09-17T12:06:59.915Z | 2024-09-19T12:19:53.404Z |
5102189 | 5102189 | 20240914011145_dzkrJ | DK0001 | 2024-09-17T12:06:53.899Z | 2024-09-19T12:19:52.727Z |
5097786 | 5097786 | 20240913010429_20v2O | DK0001 | 2024-09-16T12:17:14.902Z | 2024-09-19T12:20:38.981Z |
5097591 | 5097591 | 20240913005611_I2vF8 | DK0001 | 2024-09-16T12:17:13.558Z | 2024-09-19T12:20:38.741Z |
5092062 | 5092062 | 20240912023605_hC253 | DK0001 | 2024-09-16T12:13:39.679Z | 2024-09-19T12:21:13.620Z |
5091480 | 5091480 | 20240912021033_332yQ | DK0001 | 2024-09-16T12:13:07.561Z | 2024-09-19T12:21:13.077Z |
5091371 | 5091371 | 20240912020714_jUwlz | DK0001 | 2024-09-16T12:13:03.535Z | 2024-09-19T12:21:12.961Z |
5090651 | 5090651 | 20240912013607_V9bfD | DK0001 | 2024-09-16T12:12:27.611Z | 2024-09-19T12:21:11.538Z |
5090559 | 5090559 | 20240912013026_QODia | DK0001 | 2024-09-16T12:12:23.227Z | 2024-09-19T12:21:11.400Z |
5090537 | 5090537 | 20240912012909_p53oY | DK0001 | 2024-09-16T12:12:22.805Z | 2024-09-19T12:21:11.369Z |
5090252 | 5090252 | 20240912011920_5HSn7 | DK0001 | 2024-09-16T12:12:09.509Z | 2024-09-19T12:21:11.139Z |
5090120 | 5090120 | 20240912011143_F0l8j | DK0001 | 2024-09-16T12:12:01.443Z | 2024-09-19T12:21:10.987Z |
5089827 | 5089827 | 20240912005844_4Gfg8 | DK0001 | 2024-09-16T12:11:45.181Z | 2024-09-19T12:21:10.519Z |
5089695 | 5089695 | 20240912005340_An7gv | DK0001 | 2024-09-16T12:11:37.236Z | 2024-09-19T12:21:10.199Z |
5089495 | 5089495 | 20240912004615_X9Kmc | DK0001 | 2024-09-16T12:11:27.226Z | 2024-09-19T12:21:09.994Z |
5089194 | 5089194 | 20240912002844_1HUb3 | DK0001 | 2024-09-16T12:11:17.114Z | 2024-09-19T12:21:09.819Z |
5088713 | 5088713 | 20240913002210_EHj21 | DK0001 | 2024-09-16T12:08:22.436Z | 2024-09-19T12:20:37.198Z |
5088677 | 5088677 | 20240913002105_3705H | DK0001 | 2024-09-16T12:08:20.130Z | 2024-09-19T12:20:37.177Z |
5087961 | 5087961 | 20240912235046_bge42 | DK0001 | 2024-09-16T12:07:38.634Z | 2024-09-19T12:20:35.990Z |
5087559 | 5087559 | 20240912233147_3Mn5W | DK0001 | 2024-09-16T12:07:04.294Z | 2024-09-19T12:20:35.467Z |
5086867 | 5086867 | 20240912225249_EXQpf | DK0001 | 2024-09-16T12:06:10.384Z | 2024-09-19T12:20:32.776Z |
5086802 | 5086802 | 20240912225000_1Jnug | DK0001 | 2024-09-16T12:06:05.334Z | 2024-09-19T12:20:32.491Z |
5086492 | 5086492 | 20240912223713_kFEag | DK0001 | 2024-09-16T12:05:49.036Z | 2024-09-19T12:20:31.313Z |
5085681 | 5085681 | 20240912214320_pXTnu | DK0001 | 2024-09-16T12:04:39.439Z | 2024-09-19T12:20:29.438Z |
5085443 | 5085443 | 20240912212104_spLwR | DK0001 | 2024-09-16T12:04:16.044Z | 2024-09-19T12:20:28.628Z |
5085166 | 5085166 | 20240912205405_mYdbf | DK0001 | 2024-09-16T12:03:38.269Z | 2024-09-19T12:20:28.148Z |
5084986 | 5084986 | 20240912203821_B2lLn | DK0001 | 2024-09-16T12:03:22.813Z | 2024-09-19T12:20:27.632Z |
5084335 | 5084335 | 20240912192459_IZ3Un | DK0001 | 2024-09-16T12:01:54.979Z | 2024-09-19T12:20:25.041Z |
5075839 | 5075839 | 20240912000954_A8bJx | DK0001 | 2024-09-15T12:10:17.965Z | 2024-09-19T12:21:09.602Z |
5075805 | 5075805 | 20240912000832_qCo8B | DK0001 | 2024-09-15T12:10:15.106Z | 2024-09-19T12:21:09.536Z |
5075755 | 5075755 | 20240912000524_Bhm6g | DK0001 | 2024-09-15T12:10:11.418Z | 2024-09-19T12:21:09.475Z |
5075739 | 5075739 | 20240912000447_QXWbU | DK0001 | 2024-09-15T12:10:10.816Z | 2024-09-19T12:21:09.460Z |
5075737 | 5075737 | 20240912000402_Bjqgr | DK0001 | 2024-09-15T12:10:10.584Z | 2024-09-19T12:21:09.457Z |
5075532 | 5075532 | 20240911235323_t2a0a | DK0001 | 2024-09-15T12:09:59.233Z | 2024-09-19T12:21:09.274Z |
5074873 | 5074873 | 20240911231141_3V7Fv | DK0001 | 2024-09-15T12:09:07.545Z | 2024-09-19T12:21:07.855Z |
5074418 | 5074418 | 20240911223800_2Gq2f | DK0001 | 2024-09-15T12:08:31.909Z | 2024-09-19T12:21:07.269Z |
5074153 | 5074153 | 20240911222010_UngR9 | DK0001 | 2024-09-15T12:08:03.524Z | 2024-09-19T12:21:06.959Z |
5074083 | 5074083 | 20240911221152_nw2aR | DK0001 | 2024-09-15T12:07:56.456Z | 2024-09-19T12:21:06.876Z |
5072509 | 5072509 | 20240911201635_2E13W | DK0001 | 2024-09-15T12:05:31.689Z | 2024-09-19T12:21:04.307Z |
5072468 | 5072468 | 20240911201137_TLH3s | DK0001 | 2024-09-15T12:05:26.419Z | 2024-09-19T12:21:04.231Z |
5064743 | 5064743 | 20240910015526_3IwlY | DK0001 | 2024-09-14T12:15:58.955Z | 2024-09-18T12:15:17.151Z |
5054582 | 5054582 | 20240908031300_jvtXc | DK0001 | 2024-09-13T12:16:47.581Z | 2024-09-16T12:21:16.126Z |
5054506 | 5054506 | 20240908030303_TOHGk | DK0001 | 2024-09-13T12:16:45.015Z | 2024-09-16T12:21:15.805Z |
5054202 | 5054202 | 20240908022558_ICcB2 | DK0001 | 2024-09-13T12:16:33.763Z | 2024-09-16T12:21:14.289Z |
5053151 | 5053151 | 20240907233837_R8GcQ | DK0001 | 2024-09-13T12:15:50.118Z | 2024-09-16T12:21:09.747Z |
5053054 | 5053054 | 20240907231147_ABulP | DK0001 | 2024-09-13T12:15:43.746Z | 2024-09-16T12:21:09.215Z |
5040006 | 5040006 | 20240906024400_3ERVA | DK0001 | 2024-09-12T12:15:54.916Z | 2024-09-14T12:23:06.627Z |
5039908 | 5039908 | 20240906022543_zEQYv | DK0001 | 2024-09-12T12:15:50.585Z | 2024-09-14T12:23:05.798Z |
5039500 | 5039500 | 20240906011113_WW03b | DK0001 | 2024-09-12T12:15:35.686Z | 2024-09-14T12:23:03.195Z |
5039427 | 5039427 | 20240906005521_1pyKX | DK0001 | 2024-09-12T12:15:32.237Z | 2024-09-14T12:23:02.028Z |
5039316 | 5039316 | 20240906001920_TDt6w | DK0001 | 2024-09-12T12:15:26.255Z | 2024-09-14T12:23:01.392Z |
5039263 | 5039263 | 20240906000326_gxCQD | DK0001 | 2024-09-12T12:15:23.132Z | 2024-09-14T12:23:01.125Z |
5039198 | 5039198 | 20240905234843_xSocs | DK0001 | 2024-09-12T12:15:21.019Z | 2024-09-14T12:23:00.765Z |
5038716 | 5038716 | 20240905213051_GDZny | DK0001 | 2024-09-12T12:14:56.115Z | 2024-09-14T12:22:57.333Z |
5038609 | 5038609 | 20240905210743_NA1DV | DK0001 | 2024-09-12T12:14:50.472Z | 2024-09-14T12:22:56.602Z |
5038466 | 5038466 | 20240905202334_MXUg2 | DK0001 | 2024-09-12T12:14:42.842Z | 2024-09-14T12:22:56.199Z |
5038432 | 5038432 | 20240905201225_KTT9K | DK0001 | 2024-09-12T12:14:39.659Z | 2024-09-14T12:22:56.075Z |
5033617 | 5033617 | 20240907031729_UBSzx | DK0001 | 2024-09-12T12:09:45.334Z | 2024-09-15T12:21:30.708Z |
5033613 | 5033613 | 20240907031725_2dYcB | DK0001 | 2024-09-12T12:09:44.977Z | 2024-09-15T12:21:30.705Z |
5033471 | 5033471 | 20240907030134_6jCaj | DK0001 | 2024-09-12T12:09:33.897Z | 2024-09-15T12:21:30.206Z |
5033026 | 5033026 | 20240907021456_DtghH | DK0001 | 2024-09-12T12:08:44.142Z | 2024-09-15T12:21:28.851Z |
5032943 | 5032943 | 20240907020634_TUBdN | DK0001 | 2024-09-12T12:08:33.749Z | 2024-09-15T12:21:28.500Z |
5031432 | 5031432 | 20240906215513_T37mo | DK0001 | 2024-09-12T12:04:47.837Z | 2024-09-15T12:21:22.427Z |
5031399 | 5031399 | 20240906214109_BLsY9 | DK0001 | 2024-09-12T12:04:41.880Z | 2024-09-15T12:21:22.206Z |
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);