participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,287 rows where station_code = "KR0025" 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 |
---|---|---|---|---|---|
6200768 | 6200768 | 20250228184019_D2A34 | KR0025 | 2025-03-02T14:02:35.263Z | 2025-03-04T14:40:12.537Z |
6199884 | 6199884 | 20250228161903_3K1iF | KR0025 | 2025-03-01T14:32:03.301Z | 2025-03-04T15:01:22.667Z |
6199877 | 6199877 | 20250228161748_R3ozy | KR0025 | 2025-03-01T14:32:02.939Z | 2025-03-04T15:01:22.481Z |
6199687 | 6199687 | 20250228155239_kkdgz | KR0025 | 2025-03-01T14:31:26.635Z | 2025-03-04T15:01:07.297Z |
6199579 | 6199579 | 20250228153837_OKQ3C | KR0025 | 2025-03-01T14:31:03.063Z | 2025-03-04T15:00:55.510Z |
6198830 | 6198830 | 20250228130853_2d2tA | KR0025 | 2025-03-01T14:28:47.631Z | 2025-03-04T14:59:52.313Z |
6190388 | 6190388 | 20250228204929_po2QH | KR0025 | 2025-03-01T14:02:56.439Z | 2025-03-04T14:41:17.940Z |
6190230 | 6190230 | 20250228191824_3JkPZ | KR0025 | 2025-03-01T14:02:09.596Z | 2025-03-04T14:40:29.505Z |
6190141 | 6190141 | 20250228184019_sqI9S | KR0025 | 2025-03-01T14:01:40.190Z | 2025-03-01T14:01:40.190Z |
6190132 | 6190132 | 20250228183924_cOGlq | KR0025 | 2025-03-01T14:01:38.631Z | 2025-03-04T14:40:11.046Z |
6189824 | 6189824 | 20250228165929_9N186 | KR0025 | 2025-03-01T14:00:23.889Z | 2025-03-04T14:39:36.930Z |
6189559 | 6189559 | 20250226151354_kE11u | KR0025 | 2025-02-28T14:40:15.819Z | 2025-03-04T15:15:46.166Z |
6181413 | 6181413 | 20250223160918_1tEia | KR0025 | 2025-02-27T15:01:23.514Z | 2025-03-03T15:24:59.338Z |
6181386 | 6181386 | 20250223160300_e2i2p | KR0025 | 2025-02-27T15:01:20.887Z | 2025-03-03T15:24:57.945Z |
6180877 | 6180877 | 20250224104845_aaUYc | KR0025 | 2025-02-27T14:47:40.319Z | 2025-03-04T15:25:02.296Z |
6180787 | 6180787 | 20250223201002_D93hP | KR0025 | 2025-02-27T14:44:10.935Z | 2025-03-04T15:22:44.135Z |
6180773 | 6180773 | 20250223200446_ZXRlk | KR0025 | 2025-02-27T14:44:09.863Z | 2025-03-04T15:22:43.645Z |
6180705 | 6180705 | 20250223190637_S9A5V | KR0025 | 2025-02-27T14:43:31.173Z | 2025-03-04T15:22:27.863Z |
6180308 | 6180308 | 20250224205150_Fg0Cm | KR0025 | 2025-02-27T14:31:22.970Z | 2025-03-04T15:17:15.229Z |
6180238 | 6180238 | 20250224192516_wh8Mp | KR0025 | 2025-02-27T14:29:53.194Z | 2025-03-04T15:16:50.656Z |
6180066 | 6180066 | 20250226170113_2wpax | KR0025 | 2025-02-27T14:27:54.546Z | 2025-03-04T15:16:22.788Z |
6179844 | 6179844 | 20250226163353_nksQd | KR0025 | 2025-02-27T14:27:21.357Z | 2025-03-04T15:16:15.712Z |
6179782 | 6179782 | 20250226162810_ES6CZ | KR0025 | 2025-02-27T14:27:16.895Z | 2025-03-04T15:16:13.945Z |
6179516 | 6179516 | 20250226155650_cKgbA | KR0025 | 2025-02-27T14:26:57.150Z | 2025-03-04T15:16:04.718Z |
6179262 | 6179262 | 20250226152753_wQISC | KR0025 | 2025-02-27T14:26:21.189Z | 2025-03-04T15:15:51.138Z |
6179129 | 6179129 | 20250226151354_3WcQb | KR0025 | 2025-02-27T14:26:10.090Z | 2025-02-27T14:28:03.158Z |
6178125 | 6178125 | 20250226132945_W4uAp | KR0025 | 2025-02-27T14:23:44.782Z | 2025-03-04T15:14:52.307Z |
6177836 | 6177836 | 20250226124803_UOKRx | KR0025 | 2025-02-27T14:22:57.731Z | 2025-03-04T15:14:36.075Z |
6177729 | 6177729 | 20250226123128_vrR1j | KR0025 | 2025-02-27T14:22:36.803Z | 2025-03-04T15:14:31.080Z |
6171250 | 6171250 | 20250226204406_dpRUy | KR0025 | 2025-02-27T14:02:28.395Z | 2025-03-04T15:02:26.143Z |
6171229 | 6171229 | 20250226203254_GSN27 | KR0025 | 2025-02-27T14:02:25.936Z | 2025-03-04T15:02:22.856Z |
6171134 | 6171134 | 20250226201056_L2h43 | KR0025 | 2025-02-27T14:02:10.023Z | 2025-03-04T15:02:17.040Z |
6170969 | 6170969 | 20250226190617_HgjB6 | KR0025 | 2025-02-27T14:01:40.662Z | 2025-03-04T15:01:59.608Z |
6170789 | 6170789 | 20250226180411_dGYaN | KR0025 | 2025-02-27T14:01:05.730Z | 2025-03-04T15:01:50.535Z |
6170769 | 6170769 | 20250226175957_2GHkp | KR0025 | 2025-02-27T14:01:00.532Z | 2025-03-04T15:01:49.455Z |
6170420 | 6170420 | 20250224151802_2sdJ5 | KR0025 | 2025-02-26T14:33:05.929Z | 2025-03-04T15:26:31.721Z |
6170200 | 6170200 | 20250224104845_Jwued | KR0025 | 2025-02-26T14:29:28.748Z | 2025-02-26T14:29:28.748Z |
6164694 | 6164694 | 20250224205150_9mSXy | KR0025 | 2025-02-26T14:04:47.525Z | 2025-02-26T14:21:27.583Z |
6164494 | 6164494 | 20250224201238_AtbZN | KR0025 | 2025-02-26T14:04:08.100Z | 2025-03-04T15:17:04.209Z |
6164489 | 6164489 | 20250224201238_b2cQO | KR0025 | 2025-02-26T14:04:07.660Z | 2025-03-04T15:17:04.125Z |
6164436 | 6164436 | 20250224200046_F5DJc | KR0025 | 2025-02-26T14:03:53.824Z | 2025-03-04T15:16:59.595Z |
6164274 | 6164274 | 20250224193251_3BvMa | KR0025 | 2025-02-26T14:03:17.654Z | 2025-03-04T15:16:53.083Z |
6164225 | 6164225 | 20250224192516_9NGy1 | KR0025 | 2025-02-26T14:02:57.905Z | 2025-02-26T14:21:27.337Z |
6163740 | 6163740 | 20250224175557_WR8uY | KR0025 | 2025-02-26T14:01:32.392Z | 2025-03-04T15:16:33.266Z |
6163655 | 6163655 | 20250225202316_ovjCF | KR0025 | 2025-02-26T14:00:59.248Z | 2025-03-04T15:09:01.289Z |
6163639 | 6163639 | 20250225194707_mvIfY | KR0025 | 2025-02-26T14:00:55.928Z | 2025-03-04T15:08:51.848Z |
6163195 | 6163195 | 20250223171534_D22Mp | KR0025 | 2025-02-25T14:39:50.384Z | 2025-02-26T14:44:58.945Z |
6162379 | 6162379 | 20250224170544_JUHdh | KR0025 | 2025-02-25T14:21:47.000Z | 2025-03-04T15:27:12.781Z |
6162240 | 6162240 | 20250224164718_XkS7t | KR0025 | 2025-02-25T14:21:26.469Z | 2025-03-04T15:27:07.931Z |
6162204 | 6162204 | 20250224164323_meBLv | KR0025 | 2025-02-25T14:21:20.885Z | 2025-03-04T15:27:06.808Z |
6162039 | 6162039 | 20250224162620_HCvH6 | KR0025 | 2025-02-25T14:20:56.867Z | 2025-03-04T15:27:02.209Z |
6161549 | 6161549 | 20250224153030_V0f2T | KR0025 | 2025-02-25T14:19:43.833Z | 2025-03-04T15:26:37.658Z |
6160722 | 6160722 | 20250224133328_DHa47 | KR0025 | 2025-02-25T14:17:30.663Z | 2025-03-04T15:25:58.467Z |
6160632 | 6160632 | 20250224132159_9Lv3c | KR0025 | 2025-02-25T14:17:21.751Z | 2025-03-04T15:25:56.317Z |
6160150 | 6160150 | 20250224122838_Ve3id | KR0025 | 2025-02-25T14:16:01.420Z | 2025-03-04T15:25:38.587Z |
6160063 | 6160063 | 20250224121959_Ei4EK | KR0025 | 2025-02-25T14:15:50.398Z | 2025-03-04T15:25:35.711Z |
6159226 | 6159226 | 20250224104845_d2Ugq | KR0025 | 2025-02-25T14:13:29.144Z | 2025-02-25T14:21:58.678Z |
6155936 | 6155936 | 20250224172503_jPLuD | KR0025 | 2025-02-25T14:00:14.369Z | 2025-03-04T15:16:25.281Z |
6154597 | 6154597 | 20250223172705_7iPeW | KR0025 | 2025-02-24T14:29:54.567Z | 2025-03-03T15:25:29.389Z |
6154572 | 6154572 | 20250223172304_yBYJ9 | KR0025 | 2025-02-24T14:29:52.190Z | 2025-03-03T15:25:28.192Z |
6154512 | 6154512 | 20250223171243_7RmMH | KR0025 | 2025-02-24T14:29:45.058Z | 2025-03-03T15:25:21.660Z |
6154273 | 6154273 | 20250223163415_tSN3k | KR0025 | 2025-02-24T14:29:06.021Z | 2025-03-03T15:25:08.468Z |
6154083 | 6154083 | 20250223160918_Y1bQh | KR0025 | 2025-02-24T14:28:48.356Z | 2025-02-26T14:44:20.433Z |
6154028 | 6154028 | 20250223160300_PQOhq | KR0025 | 2025-02-24T14:28:40.582Z | 2025-02-26T14:44:18.598Z |
6146603 | 6146603 | 20250222204955_SRl11 | KR0025 | 2025-02-24T14:08:08.673Z | 2025-03-03T15:19:40.575Z |
6145508 | 6145508 | 20250223210646_0zfOe | KR0025 | 2025-02-24T14:03:15.237Z | 2025-03-04T15:23:00.668Z |
6145370 | 6145370 | 20250223203400_d9Trz | KR0025 | 2025-02-24T14:02:58.018Z | 2025-03-04T15:22:51.118Z |
6145327 | 6145327 | 20250223202313_MX8bl | KR0025 | 2025-02-24T14:02:47.139Z | 2025-03-04T15:22:48.329Z |
6145283 | 6145283 | 20250223201503_bYjBo | KR0025 | 2025-02-24T14:02:41.405Z | 2025-03-04T15:22:46.222Z |
6145235 | 6145235 | 20250223201002_tc6Vj | KR0025 | 2025-02-24T14:02:34.567Z | 2025-02-26T14:23:21.692Z |
6145211 | 6145211 | 20250223200446_Qbkap | KR0025 | 2025-02-24T14:02:30.928Z | 2025-02-26T14:23:19.493Z |
6144971 | 6144971 | 20250223190637_9GCFw | KR0025 | 2025-02-24T14:01:42.314Z | 2025-02-26T14:22:39.136Z |
6144840 | 6144840 | 20250223183552_Jtqvw | KR0025 | 2025-02-24T14:01:21.426Z | 2025-03-04T15:22:16.693Z |
6144095 | 6144095 | 20250221164929_numb6 | KR0025 | 2025-02-23T14:40:13.926Z | 2025-03-01T15:32:04.752Z |
6143696 | 6143696 | 20250221150240_7YlZ2 | KR0025 | 2025-02-23T14:38:29.368Z | 2025-03-01T15:31:20.375Z |
6143271 | 6143271 | 20250221122509_71bUJ | KR0025 | 2025-02-23T14:35:39.840Z | 2025-03-01T15:29:52.134Z |
6142418 | 6142418 | 20250222160928_Cm4bp | KR0025 | 2025-02-23T14:25:00.369Z | 2025-03-02T15:39:23.751Z |
6142276 | 6142276 | 20250222155304_eO3EK | KR0025 | 2025-02-23T14:24:45.426Z | 2025-03-02T15:39:13.883Z |
6141881 | 6141881 | 20250222150210_Bw57D | KR0025 | 2025-02-23T14:23:51.093Z | 2025-03-02T15:38:45.211Z |
6140449 | 6140449 | 20250222120338_yhGWP | KR0025 | 2025-02-23T14:20:42.830Z | 2025-03-02T15:37:23.669Z |
6135485 | 6135485 | 20250222210809_n2KVj | KR0025 | 2025-02-23T14:01:43.823Z | 2025-03-03T15:19:49.117Z |
6135407 | 6135407 | 20250222204955_5fdsW | KR0025 | 2025-02-23T14:01:30.165Z | 2025-02-23T14:01:30.165Z |
6135352 | 6135352 | 20250222202738_HKC1a | KR0025 | 2025-02-23T14:01:22.030Z | 2025-03-03T15:19:33.836Z |
6135346 | 6135346 | 20250222202423_WjR2F | KR0025 | 2025-02-23T14:01:20.961Z | 2025-03-03T15:19:30.353Z |
6135289 | 6135289 | 20250222201336_oDDZ7 | KR0025 | 2025-02-23T14:01:12.244Z | 2025-03-03T15:19:26.306Z |
6134769 | 6134769 | 20250220174233_afyIC | KR0025 | 2025-02-22T14:38:35.487Z | 2025-02-28T15:29:30.633Z |
6134677 | 6134677 | 20250220171123_i77GN | KR0025 | 2025-02-22T14:38:11.613Z | 2025-02-28T15:29:23.135Z |
6133852 | 6133852 | 20250220101955_aSwxU | KR0025 | 2025-02-22T14:32:15.241Z | 2025-02-28T15:27:54.978Z |
6126519 | 6126519 | 20250220193959_4MHh0 | KR0025 | 2025-02-22T14:03:36.472Z | 2025-03-01T15:26:14.684Z |
6126407 | 6126407 | 20250220192154_c1UXp | KR0025 | 2025-02-22T14:03:01.529Z | 2025-03-01T15:26:10.144Z |
6126319 | 6126319 | 20250220190547_LkQWD | KR0025 | 2025-02-22T14:02:40.732Z | 2025-03-01T15:26:06.571Z |
6126213 | 6126213 | 20250220184648_wFBDn | KR0025 | 2025-02-22T14:02:13.493Z | 2025-03-01T15:26:00.023Z |
6126207 | 6126207 | 20250220184641_oSTmz | KR0025 | 2025-02-22T14:02:12.435Z | 2025-03-01T15:25:59.888Z |
6120006 | 6120006 | 20250219163132_XldIg | KR0025 | 2025-02-20T14:20:25.448Z | 2025-02-27T15:31:26.002Z |
6119941 | 6119941 | 20250219162350_ixUtl | KR0025 | 2025-02-20T14:20:15.381Z | 2025-02-27T15:31:24.421Z |
6119179 | 6119179 | 20250219141231_lwEJG | KR0025 | 2025-02-20T14:17:59.433Z | 2025-02-27T15:30:42.059Z |
6119035 | 6119035 | 20250219134638_gUBLl | KR0025 | 2025-02-20T14:17:40.637Z | 2025-02-27T15:30:38.854Z |
6118909 | 6118909 | 20250219131732_k2N1n | KR0025 | 2025-02-20T14:17:12.420Z | 2025-02-27T15:30:35.516Z |
6118773 | 6118773 | 20250219125530_wd3HY | KR0025 | 2025-02-20T14:16:48.543Z | 2025-02-27T15:30:11.108Z |
6115093 | 6115093 | 20250219212113_pjl2M | KR0025 | 2025-02-20T14:02:37.134Z | 2025-02-28T15:25:33.735Z |
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);