participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,021 rows where station_code = "DE000K" 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 |
---|---|---|---|---|---|
5604092 | 5604092 | 20241124203913_zFXGe | DE000K | 2024-11-26T14:16:28.506Z | 2024-11-26T14:18:44.872Z |
5592505 | 5592505 | 20241123033914_0V25y | DE000K | 2024-11-24T14:21:05.510Z | 2024-11-26T14:23:47.318Z |
5592465 | 5592465 | 20241123033212_laSqf | DE000K | 2024-11-24T14:21:02.733Z | 2024-11-26T14:23:46.833Z |
5592172 | 5592172 | 20241123022831_Tw26P | DE000K | 2024-11-24T14:20:43.537Z | 2024-11-26T14:23:39.048Z |
5591999 | 5591999 | 20241123015042_f3I6n | DE000K | 2024-11-24T14:20:32.094Z | 2024-11-26T14:23:35.305Z |
5591888 | 5591888 | 20241123012251_mqDSA | DE000K | 2024-11-24T14:20:23.609Z | 2024-11-26T14:23:32.043Z |
5591866 | 5591866 | 20241123011526_QXe4G | DE000K | 2024-11-24T14:20:21.400Z | 2024-11-26T14:23:31.802Z |
5591676 | 5591676 | 20241123002914_zlU3Z | DE000K | 2024-11-24T14:20:10.040Z | 2024-11-26T14:23:28.020Z |
5591644 | 5591644 | 20241123001950_YAcFt | DE000K | 2024-11-24T14:20:07.739Z | 2024-11-26T14:23:27.542Z |
5591619 | 5591619 | 20241123000713_Z3Tpj | DE000K | 2024-11-24T14:20:06.316Z | 2024-11-26T14:23:26.899Z |
5591552 | 5591552 | 20241122235110_vWX90 | DE000K | 2024-11-24T14:20:01.032Z | 2024-11-26T14:23:25.284Z |
5591549 | 5591549 | 20241122235056_jNBsJ | DE000K | 2024-11-24T14:20:00.914Z | 2024-11-26T14:23:25.262Z |
5591479 | 5591479 | 20241122232317_l0hUt | DE000K | 2024-11-24T14:19:55.184Z | 2024-11-26T14:23:23.639Z |
5591390 | 5591390 | 20241122225331_7AzjL | DE000K | 2024-11-24T14:19:49.168Z | 2024-11-26T14:23:21.508Z |
5591387 | 5591387 | 20241122225311_fuZ8m | DE000K | 2024-11-24T14:19:48.921Z | 2024-11-26T14:23:21.482Z |
5591360 | 5591360 | 20241122224341_zict3 | DE000K | 2024-11-24T14:19:47.277Z | 2024-11-26T14:23:21.087Z |
5591353 | 5591353 | 20241122224205_qXwwk | DE000K | 2024-11-24T14:19:47.069Z | 2024-11-26T14:23:21.032Z |
5591203 | 5591203 | 20241122215656_rxr4c | DE000K | 2024-11-24T14:19:35.397Z | 2024-11-26T14:23:17.772Z |
5591129 | 5591129 | 20241122213320_h3z2m | DE000K | 2024-11-24T14:19:29.301Z | 2024-11-26T14:23:16.654Z |
5590945 | 5590945 | 20241122204616_NFkat | DE000K | 2024-11-24T14:19:12.445Z | 2024-11-26T14:23:14.608Z |
5590755 | 5590755 | 20241122200212_2Xeqx | DE000K | 2024-11-24T14:18:56.189Z | 2024-11-26T14:23:12.197Z |
5590634 | 5590634 | 20241122194537_xzafY | DE000K | 2024-11-24T14:18:47.915Z | 2024-11-26T14:23:10.967Z |
5590434 | 5590434 | 20241122191918_KnflI | DE000K | 2024-11-24T14:18:31.788Z | 2024-11-26T14:23:06.641Z |
5589652 | 5589652 | 20241122170816_Lchxt | DE000K | 2024-11-24T14:17:37.385Z | 2024-11-26T14:22:58.138Z |
5580513 | 5580513 | 20241122004909_6ii32 | DE000K | 2024-11-23T14:19:25.927Z | 2024-11-26T14:25:06.011Z |
5561574 | 5561574 | 20241119210931_uO0k3 | DE000K | 2024-11-21T14:13:29.372Z | 2024-11-26T14:27:30.549Z |
5561571 | 5561571 | 20241119210718_vBkv6 | DE000K | 2024-11-21T14:13:28.981Z | 2024-11-26T14:27:30.509Z |
5561526 | 5561526 | 20241119205339_EY4dx | DE000K | 2024-11-21T14:13:24.652Z | 2024-11-26T14:27:29.711Z |
5556371 | 5556371 | 20241118200647_3JM6e | DE000K | 2024-11-20T14:10:09.415Z | 2024-11-26T14:28:14.138Z |
5489566 | 5489566 | 20241105191804_UD7V0 | DE000K | 2024-11-07T14:12:13.137Z | 2024-11-14T14:23:13.811Z |
5489285 | 5489285 | 20241105182726_sQ5zT | DE000K | 2024-11-07T14:11:50.355Z | 2024-11-14T14:23:11.817Z |
5489234 | 5489234 | 20241105181211_oCT8s | DE000K | 2024-11-07T14:11:34.200Z | 2024-11-14T14:23:11.102Z |
5483422 | 5483422 | 20241105003911_3hvL3 | DE000K | 2024-11-06T14:15:14.742Z | 2024-11-13T14:27:36.218Z |
5483347 | 5483347 | 20241105002854_IOFnQ | DE000K | 2024-11-06T14:15:01.382Z | 2024-11-13T14:27:36.063Z |
5483312 | 5483312 | 20241105002608_jJ4ww | DE000K | 2024-11-06T14:14:58.560Z | 2024-11-13T14:27:36.026Z |
5483102 | 5483102 | 20241104235830_FlLm0 | DE000K | 2024-11-06T14:14:40.226Z | 2024-11-13T14:27:35.717Z |
5483027 | 5483027 | 20241104234853_Yhkcx | DE000K | 2024-11-06T14:14:35.512Z | 2024-11-13T14:27:35.596Z |
5482431 | 5482431 | 20241104221211_wjCcM | DE000K | 2024-11-06T14:13:10.824Z | 2024-11-13T14:27:34.571Z |
5476970 | 5476970 | 20241104004656_IY6tG | DE000K | 2024-11-05T14:16:15.164Z | 2024-11-12T14:28:07.950Z |
5476936 | 5476936 | 20241104004347_N2qYT | DE000K | 2024-11-05T14:16:13.087Z | 2024-11-12T14:28:07.923Z |
5476471 | 5476471 | 20241103233044_yH9Ta | DE000K | 2024-11-05T14:15:26.665Z | 2024-11-12T14:28:06.154Z |
5476319 | 5476319 | 20241103230743_o21tV | DE000K | 2024-11-05T14:15:03.821Z | 2024-11-12T14:28:05.388Z |
5476221 | 5476221 | 20241103224830_JvfXn | DE000K | 2024-11-05T14:14:54.981Z | 2024-11-12T14:28:03.867Z |
5476184 | 5476184 | 20241103223929_i6NLK | DE000K | 2024-11-05T14:14:50.414Z | 2024-11-12T14:28:03.693Z |
5476128 | 5476128 | 20241103223111_Aae9a | DE000K | 2024-11-05T14:14:47.038Z | 2024-11-12T14:28:03.109Z |
5476050 | 5476050 | 20241103221313_m2r3o | DE000K | 2024-11-05T14:14:41.655Z | 2024-11-12T14:28:02.508Z |
5475956 | 5475956 | 20241103220026_48NBx | DE000K | 2024-11-05T14:14:35.725Z | 2024-11-12T14:28:01.898Z |
5475935 | 5475935 | 20241103215707_eLnMS | DE000K | 2024-11-05T14:14:34.516Z | 2024-11-12T14:28:01.849Z |
5475849 | 5475849 | 20241103213727_7aCew | DE000K | 2024-11-05T14:14:22.432Z | 2024-11-12T14:28:01.369Z |
5475783 | 5475783 | 20241103212332_WLOHf | DE000K | 2024-11-05T14:14:12.071Z | 2024-11-12T14:28:00.971Z |
5475683 | 5475683 | 20241103210139_JBBWA | DE000K | 2024-11-05T14:14:00.528Z | 2024-11-12T14:28:00.474Z |
5475644 | 5475644 | 20241103205449_8b36M | DE000K | 2024-11-05T14:13:55.501Z | 2024-11-12T14:28:00.125Z |
5475360 | 5475360 | 20241103195318_m8Vn5 | DE000K | 2024-11-05T14:13:19.407Z | 2024-11-12T14:27:58.105Z |
5475135 | 5475135 | 20241103191314_3ei4D | DE000K | 2024-11-05T14:12:35.669Z | 2024-11-12T14:27:57.212Z |
5475109 | 5475109 | 20241103190645_Yl0iR | DE000K | 2024-11-05T14:12:32.151Z | 2024-11-12T14:27:57.143Z |
5475021 | 5475021 | 20241103185211_5Cif1 | DE000K | 2024-11-05T14:12:25.257Z | 2024-11-12T14:27:56.447Z |
5474854 | 5474854 | 20241103182615_7bDJF | DE000K | 2024-11-05T14:12:10.961Z | 2024-11-12T14:27:55.139Z |
5474759 | 5474759 | 20241103181205_adVvA | DE000K | 2024-11-05T14:11:54.295Z | 2024-11-12T14:27:54.550Z |
5474731 | 5474731 | 20241103180743_0SQYS | DE000K | 2024-11-05T14:11:47.135Z | 2024-11-12T14:27:54.176Z |
5474631 | 5474631 | 20241103175145_BbeR6 | DE000K | 2024-11-05T14:11:27.546Z | 2024-11-12T14:27:53.683Z |
5474532 | 5474532 | 20241103173447_hymSS | DE000K | 2024-11-05T14:11:12.862Z | 2024-11-12T14:27:52.687Z |
5469942 | 5469942 | 20241103044940_uN5dO | DE000K | 2024-11-04T14:17:24.477Z | 2024-11-11T14:23:03.116Z |
5469807 | 5469807 | 20241103042250_YJDqm | DE000K | 2024-11-04T14:17:05.073Z | 2024-11-11T14:23:02.270Z |
5469778 | 5469778 | 20241103041815_4PPQw | DE000K | 2024-11-04T14:17:02.822Z | 2024-11-11T14:23:02.240Z |
5469738 | 5469738 | 20241103040912_3ksmv | DE000K | 2024-11-04T14:16:58.526Z | 2024-11-11T14:23:02.166Z |
5469589 | 5469589 | 20241103035023_1BMTM | DE000K | 2024-11-04T14:16:39.317Z | 2024-11-11T14:23:01.293Z |
5469529 | 5469529 | 20241103034026_oxUTK | DE000K | 2024-11-04T14:16:34.188Z | 2024-11-11T14:23:00.973Z |
5469316 | 5469316 | 20241103031011_wOQl7 | DE000K | 2024-11-04T14:16:19.084Z | 2024-11-11T14:22:59.840Z |
5469295 | 5469295 | 20241103030453_h2uDm | DE000K | 2024-11-04T14:16:16.234Z | 2024-11-11T14:22:59.606Z |
5469231 | 5469231 | 20241103025429_yvBRB | DE000K | 2024-11-04T14:15:59.763Z | 2024-11-11T14:22:59.354Z |
5469199 | 5469199 | 20241103024711_yzEhQ | DE000K | 2024-11-04T14:15:53.582Z | 2024-11-11T14:22:59.063Z |
5468950 | 5468950 | 20241103021428_bKuOD | DE000K | 2024-11-04T14:15:18.456Z | 2024-11-11T14:22:57.108Z |
5468920 | 5468920 | 20241103021037_NBWzZ | DE000K | 2024-11-04T14:15:14.199Z | 2024-11-11T14:22:57.047Z |
5468819 | 5468819 | 20241103015244_HN1Jv | DE000K | 2024-11-04T14:15:06.149Z | 2024-11-11T14:22:56.019Z |
5468585 | 5468585 | 20241103010218_oX32S | DE000K | 2024-11-04T14:14:31.129Z | 2024-11-11T14:22:54.101Z |
5468427 | 5468427 | 20241103003450_Lr2tb | DE000K | 2024-11-04T14:14:05.893Z | 2024-11-11T14:22:53.434Z |
5468117 | 5468117 | 20241102233356_cB4U7 | DE000K | 2024-11-04T14:13:18.628Z | 2024-11-11T14:22:51.419Z |
5467869 | 5467869 | 20241102224808_zY4lu | DE000K | 2024-11-04T14:12:49.376Z | 2024-11-11T14:22:50.213Z |
5467864 | 5467864 | 20241102224752_qRk1B | DE000K | 2024-11-04T14:12:47.583Z | 2024-11-11T14:22:50.123Z |
5467848 | 5467848 | 20241102224644_4ToSP | DE000K | 2024-11-04T14:12:39.828Z | 2024-11-11T14:22:50.047Z |
5467770 | 5467770 | 20241102223522_FvRx9 | DE000K | 2024-11-04T14:12:30.265Z | 2024-11-11T14:22:49.593Z |
5467767 | 5467767 | 20241102223422_FZU87 | DE000K | 2024-11-04T14:12:29.991Z | 2024-11-11T14:22:49.581Z |
5467674 | 5467674 | 20241102221419_3KEJO | DE000K | 2024-11-04T14:12:19.978Z | 2024-11-11T14:22:48.869Z |
5467654 | 5467654 | 20241102221032_9tufv | DE000K | 2024-11-04T14:12:18.135Z | 2024-11-11T14:22:48.787Z |
5467262 | 5467262 | 20241102203128_ogcZ9 | DE000K | 2024-11-04T14:11:11.434Z | 2024-11-11T14:22:45.864Z |
5467237 | 5467237 | 20241102202653_h66Sh | DE000K | 2024-11-04T14:11:08.726Z | 2024-11-11T14:22:45.752Z |
5466985 | 5466985 | 20241102194132_3Kn8z | DE000K | 2024-11-04T14:10:26.210Z | 2024-11-11T14:22:44.787Z |
5466963 | 5466963 | 20241102193354_OYVut | DE000K | 2024-11-04T14:10:23.693Z | 2024-11-11T14:22:44.689Z |
5466925 | 5466925 | 20241102192349_x3m4l | DE000K | 2024-11-04T14:10:18.607Z | 2024-11-11T14:22:44.344Z |
5466510 | 5466510 | 20241102175257_mUh8m | DE000K | 2024-11-04T14:09:04.816Z | 2024-11-11T14:22:41.204Z |
5420418 | 5420418 | 20241028024008_gqe0b | DE000K | 2024-10-30T12:18:50.415Z | 2024-11-05T14:27:15.383Z |
5420102 | 5420102 | 20241028015819_ykW3W | DE000K | 2024-10-30T12:18:20.668Z | 2024-11-05T14:27:14.499Z |
5420009 | 5420009 | 20241028014352_owod3 | DE000K | 2024-10-30T12:18:14.079Z | 2024-11-05T14:27:14.343Z |
5419595 | 5419595 | 20241028002503_uS7FJ | DE000K | 2024-10-30T12:17:37.104Z | 2024-11-05T14:27:13.533Z |
5419362 | 5419362 | 20241027234228_oCLfV | DE000K | 2024-10-30T12:17:22.638Z | 2024-11-05T14:27:12.872Z |
5419321 | 5419321 | 20241027233652_0FT3O | DE000K | 2024-10-30T12:17:20.410Z | 2024-11-05T14:27:12.723Z |
5419111 | 5419111 | 20241027230434_npl2m | DE000K | 2024-10-30T12:17:10.260Z | 2024-11-05T14:27:12.402Z |
5419015 | 5419015 | 20241027224539_Yp2ge | DE000K | 2024-10-30T12:16:52.809Z | 2024-11-05T14:27:12.221Z |
5418909 | 5418909 | 20241027222258_YF3ed | DE000K | 2024-10-30T12:16:33.008Z | 2024-11-05T14:27:11.720Z |
5418572 | 5418572 | 20241027211322_sGvTz | DE000K | 2024-10-30T12:15:50.887Z | 2024-11-05T14:27:10.615Z |
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);