participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
992 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 |
---|---|---|---|---|---|
5489566 | 5489566 | 20241105191804_UD7V0 | DE000K | 2024-11-07T14:12:13.137Z | 2024-11-12T14:26:43.783Z |
5489285 | 5489285 | 20241105182726_sQ5zT | DE000K | 2024-11-07T14:11:50.355Z | 2024-11-12T14:26:41.935Z |
5489234 | 5489234 | 20241105181211_oCT8s | DE000K | 2024-11-07T14:11:34.200Z | 2024-11-12T14:26:40.563Z |
5483422 | 5483422 | 20241105003911_3hvL3 | DE000K | 2024-11-06T14:15:14.742Z | 2024-11-12T14:27:28.095Z |
5483347 | 5483347 | 20241105002854_IOFnQ | DE000K | 2024-11-06T14:15:01.382Z | 2024-11-12T14:27:27.749Z |
5483312 | 5483312 | 20241105002608_jJ4ww | DE000K | 2024-11-06T14:14:58.560Z | 2024-11-12T14:27:27.618Z |
5483102 | 5483102 | 20241104235830_FlLm0 | DE000K | 2024-11-06T14:14:40.226Z | 2024-11-12T14:27:25.759Z |
5483027 | 5483027 | 20241104234853_Yhkcx | DE000K | 2024-11-06T14:14:35.512Z | 2024-11-12T14:27:25.351Z |
5482431 | 5482431 | 20241104221211_wjCcM | DE000K | 2024-11-06T14:13:10.824Z | 2024-11-12T14:27:22.477Z |
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 |
5418503 | 5418503 | 20241027205823_8hJZv | DE000K | 2024-10-30T12:15:45.930Z | 2024-11-05T14:27:10.292Z |
5418391 | 5418391 | 20241027203653_dXHj1 | DE000K | 2024-10-30T12:15:38.085Z | 2024-11-05T14:27:09.952Z |
5404409 | 5404409 | 20241026232353_uXGm0 | DE000K | 2024-10-29T12:11:19.948Z | 2024-11-04T14:28:50.857Z |
5404321 | 5404321 | 20241026231754_sRIlf | DE000K | 2024-10-29T12:11:09.845Z | 2024-11-04T14:28:50.629Z |
5403996 | 5403996 | 20241026225222_2qApI | DE000K | 2024-10-29T12:10:46.606Z | 2024-11-04T14:28:50.177Z |
5403994 | 5403994 | 20241026225212_i1mmG | DE000K | 2024-10-29T12:10:45.930Z | 2024-11-04T14:28:50.175Z |
5403963 | 5403963 | 20241026224831_4Eb37 | DE000K | 2024-10-29T12:10:39.012Z | 2024-11-04T14:28:50.109Z |
5403351 | 5403351 | 20241026214511_3nAco | DE000K | 2024-10-29T12:09:24.082Z | 2024-11-04T14:28:48.518Z |
5403226 | 5403226 | 20241026213105_YYIMC | DE000K | 2024-10-29T12:09:14.523Z | 2024-11-04T14:28:47.975Z |
5403083 | 5403083 | 20241026211706_OKHji | DE000K | 2024-10-29T12:08:53.201Z | 2024-11-04T14:28:47.690Z |
5402775 | 5402775 | 20241026202414_ZIg9Q | DE000K | 2024-10-29T12:08:07.606Z | 2024-11-04T14:28:46.498Z |
5402586 | 5402586 | 20241026195954_tm1Rt | DE000K | 2024-10-29T12:07:45.824Z | 2024-11-04T14:28:45.399Z |
5402264 | 5402264 | 20241026190737_m0sbA | DE000K | 2024-10-29T12:06:46.832Z | 2024-11-04T14:28:43.405Z |
5402143 | 5402143 | 20241026184923_cCS9h | DE000K | 2024-10-29T12:06:30.655Z | 2024-11-04T14:28:42.482Z |
5401951 | 5401951 | 20241026181139_EjGLd | DE000K | 2024-10-29T12:05:54.051Z | 2024-11-04T14:28:41.096Z |
5399014 | 5399014 | 20241026034455_vHPyj | DE000K | 2024-10-28T12:19:44.534Z | 2024-11-03T14:27:38.888Z |
5398038 | 5398038 | 20241026021936_2MHfh | DE000K | 2024-10-28T12:18:58.330Z | 2024-11-03T14:27:35.095Z |
5397991 | 5397991 | 20241026021410_eOWvf | DE000K | 2024-10-28T12:18:55.017Z | 2024-11-03T14:27:34.782Z |
5397668 | 5397668 | 20241026014635_3DAEW | DE000K | 2024-10-28T12:18:32.914Z | 2024-11-03T14:27:33.700Z |
5397049 | 5397049 | 20241026005911_JY7I7 | DE000K | 2024-10-28T12:18:04.419Z | 2024-11-03T14:27:31.952Z |
5396890 | 5396890 | 20241026004355_Uu2Z0 | DE000K | 2024-10-28T12:17:58.709Z | 2024-11-03T14:27:31.287Z |
5396792 | 5396792 | 20241026003439_Ssp3k | DE000K | 2024-10-28T12:17:55.763Z | 2024-11-03T14:27:30.923Z |
5396698 | 5396698 | 20241026002501_9R62K | DE000K | 2024-10-28T12:17:53.586Z | 2024-11-03T14:27:30.727Z |
5396174 | 5396174 | 20241025234604_dQ6p5 | DE000K | 2024-10-28T12:17:24.229Z | 2024-11-03T14:27:28.795Z |
5396085 | 5396085 | 20241025233843_pIk46 | DE000K | 2024-10-28T12:17:17.960Z | 2024-11-03T14:27:28.382Z |
5395963 | 5395963 | 20241025232647_w06uq | DE000K | 2024-10-28T12:17:08.420Z | 2024-11-03T14:27:27.831Z |
5395935 | 5395935 | 20241025232358_0j3G5 | DE000K | 2024-10-28T12:17:06.142Z | 2024-11-03T14:27:27.676Z |
5395163 | 5395163 | 20241025221621_ezBFw | DE000K | 2024-10-28T12:15:59.666Z | 2024-11-03T14:27:24.150Z |
5394601 | 5394601 | 20241025205520_D697V | DE000K | 2024-10-28T12:15:03.470Z | 2024-11-03T14:27:21.814Z |
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);