participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
882 rows where station_code = "KR001Y" 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 |
---|---|---|---|---|---|
5068955 | 5068955 | 20240910131242_MVW4q | KR001Y | 2024-09-14T12:19:23.270Z | 2024-09-16T12:20:15.910Z |
5062696 | 5062696 | 20240909180258_0rc11 | KR001Y | 2024-09-14T12:12:43.825Z | 2024-09-16T12:19:38.822Z |
5062070 | 5062070 | 20240909164126_hWCCn | KR001Y | 2024-09-14T12:11:47.567Z | 2024-09-16T12:19:35.411Z |
5061408 | 5061408 | 20240909150405_MtuHt | KR001Y | 2024-09-14T12:10:47.860Z | 2024-09-16T12:19:31.405Z |
5061293 | 5061293 | 20240909144209_2VMkR | KR001Y | 2024-09-14T12:10:40.526Z | 2024-09-16T12:19:30.365Z |
5061244 | 5061244 | 20240909143641_Fu0ze | KR001Y | 2024-09-14T12:10:37.048Z | 2024-09-16T12:19:29.911Z |
5059547 | 5059547 | 20240910180437_TrEw7 | KR001Y | 2024-09-14T12:06:26.130Z | 2024-09-16T12:18:06.045Z |
5059311 | 5059311 | 20240910172951_GkEfn | KR001Y | 2024-09-14T12:05:41.502Z | 2024-09-16T12:18:03.740Z |
5058061 | 5058061 | 20240910154035_NlkAi | KR001Y | 2024-09-14T12:02:46.195Z | 2024-09-16T12:17:49.553Z |
5057348 | 5057348 | 20240910141335_6siN6 | KR001Y | 2024-09-14T12:00:54.064Z | 2024-09-16T12:17:42.828Z |
5050388 | 5050388 | 20240907151559_s23sj | KR001Y | 2024-09-13T12:13:29.826Z | 2024-09-16T12:20:57.537Z |
5045898 | 5045898 | 20240908195856_2rf9J | KR001Y | 2024-09-13T12:05:20.122Z | 2024-09-16T12:20:28.028Z |
5045882 | 5045882 | 20240908195137_1lQ22 | KR001Y | 2024-09-13T12:05:17.895Z | 2024-09-16T12:20:27.918Z |
5045781 | 5045781 | 20240908191953_be8HY | KR001Y | 2024-09-13T12:04:56.437Z | 2024-09-16T12:20:27.405Z |
5045764 | 5045764 | 20240908191201_liBv1 | KR001Y | 2024-09-13T12:04:54.235Z | 2024-09-16T12:20:27.338Z |
5045751 | 5045751 | 20240908185050_yKYAB | KR001Y | 2024-09-13T12:04:52.089Z | 2024-09-16T12:20:27.261Z |
5045725 | 5045725 | 20240908183009_BEhGD | KR001Y | 2024-09-13T12:04:48.325Z | 2024-09-16T12:20:27.074Z |
5045711 | 5045711 | 20240908182248_9tZRN | KR001Y | 2024-09-13T12:04:46.302Z | 2024-09-16T12:20:26.888Z |
5045691 | 5045691 | 20240908180822_RuftQ | KR001Y | 2024-09-13T12:04:43.469Z | 2024-09-16T12:20:26.775Z |
5045446 | 5045446 | 20240908170544_C0dbo | KR001Y | 2024-09-13T12:04:09.415Z | 2024-09-16T12:20:25.703Z |
5045369 | 5045369 | 20240908165838_uyAcw | KR001Y | 2024-09-13T12:04:03.754Z | 2024-09-16T12:20:25.564Z |
5044910 | 5044910 | 20240908155436_334kX | KR001Y | 2024-09-13T12:03:09.191Z | 2024-09-16T12:20:23.818Z |
5044180 | 5044180 | 20240908142257_lyg6f | KR001Y | 2024-09-13T12:01:37.572Z | 2024-09-16T12:20:20.187Z |
5042616 | 5042616 | 20240907120919_i082R | KR001Y | 2024-09-12T12:17:15.823Z | 2024-09-16T12:20:53.752Z |
5042449 | 5042449 | 20240907114116_I00pj | KR001Y | 2024-09-12T12:17:11.677Z | 2024-09-16T12:20:52.948Z |
5018727 | 5018727 | 20240904195657_nDxoF | KR001Y | 2024-09-10T12:11:27.072Z | 2024-09-13T12:19:48.603Z |
5018525 | 5018525 | 20240904183522_33xj5 | KR001Y | 2024-09-10T12:10:46.996Z | 2024-09-13T12:19:48.022Z |
5018429 | 5018429 | 20240904180620_2lTDh | KR001Y | 2024-09-10T12:10:36.891Z | 2024-09-13T12:19:47.883Z |
5018194 | 5018194 | 20240904172433_sqNRQ | KR001Y | 2024-09-10T12:10:08.787Z | 2024-09-13T12:19:47.385Z |
5018167 | 5018167 | 20240904171729_0yOSg | KR001Y | 2024-09-10T12:10:05.831Z | 2024-09-13T12:19:47.347Z |
5018087 | 5018087 | 20240904171028_jnP5y | KR001Y | 2024-09-10T12:09:59.464Z | 2024-09-13T12:19:47.187Z |
5017591 | 5017591 | 20240904162250_yA8B0 | KR001Y | 2024-09-10T12:09:18.831Z | 2024-09-13T12:19:46.983Z |
5016753 | 5016753 | 20240904144915_Y2t0O | KR001Y | 2024-09-10T12:08:14.720Z | 2024-09-13T12:19:46.260Z |
5016520 | 5016520 | 20240904142330_hkevn | KR001Y | 2024-09-10T12:07:55.715Z | 2024-09-13T12:19:45.835Z |
5016318 | 5016318 | 20240904135951_gP7U3 | KR001Y | 2024-09-10T12:07:41.135Z | 2024-09-13T12:19:45.488Z |
5016098 | 5016098 | 20240904133131_hENAL | KR001Y | 2024-09-10T12:07:21.950Z | 2024-09-13T12:19:45.246Z |
5015820 | 5015820 | 20240904124106_JQSEf | KR001Y | 2024-09-10T12:06:48.934Z | 2024-09-13T12:19:44.716Z |
5015769 | 5015769 | 20240904122838_OYxu2 | KR001Y | 2024-09-10T12:06:45.374Z | 2024-09-13T12:19:44.653Z |
5006015 | 5006015 | 20240903164426_or335 | KR001Y | 2024-09-09T12:04:16.802Z | 2024-09-12T12:19:07.235Z |
4996507 | 4996507 | 20240902195006_WaYl9 | KR001Y | 2024-09-08T12:04:53.041Z | 2024-09-11T12:20:55.353Z |
4985791 | 4985791 | 20240901133344_cFBfM | KR001Y | 2024-09-07T12:03:46.731Z | 2024-09-10T12:19:08.351Z |
4963025 | 4963025 | 20240811193749_tMxIl | KR001Y | 2024-09-04T12:05:07.158Z | 2024-09-06T12:04:15.416Z |
4962718 | 4962718 | 20240811191827_FbeQj | KR001Y | 2024-09-04T12:04:48.757Z | 2024-09-06T12:03:59.853Z |
4962674 | 4962674 | 20240811191603_0s6pa | KR001Y | 2024-09-04T12:04:46.764Z | 2024-09-06T12:03:55.907Z |
4962615 | 4962615 | 20240811191227_urrvq | KR001Y | 2024-09-04T12:04:43.598Z | 2024-09-06T12:03:53.543Z |
4962590 | 4962590 | 20240811191049_KutdU | KR001Y | 2024-09-04T12:04:42.424Z | 2024-09-06T12:03:52.560Z |
4962268 | 4962268 | 20240811184522_Z1suF | KR001Y | 2024-09-04T12:04:23.235Z | 2024-09-06T12:03:37.393Z |
4962244 | 4962244 | 20240811184346_wD3UN | KR001Y | 2024-09-04T12:04:22.247Z | 2024-09-06T12:03:34.749Z |
4962221 | 4962221 | 20240811184241_rydI7 | KR001Y | 2024-09-04T12:04:21.569Z | 2024-09-06T12:03:33.918Z |
4962196 | 4962196 | 20240811184116_Dmsz2 | KR001Y | 2024-09-04T12:04:20.705Z | 2024-09-06T12:03:33.177Z |
4962187 | 4962187 | 20240811184037_iHma3 | KR001Y | 2024-09-04T12:04:20.424Z | 2024-09-06T12:03:32.926Z |
4962176 | 4962176 | 20240811183925_Oy2zI | KR001Y | 2024-09-04T12:04:19.929Z | 2024-09-06T12:03:32.387Z |
4962156 | 4962156 | 20240811183823_tebr0 | KR001Y | 2024-09-04T12:04:19.210Z | 2024-09-06T12:03:31.836Z |
4961824 | 4961824 | 20240811180735_VJrYO | KR001Y | 2024-09-04T12:03:57.230Z | 2024-09-06T12:03:16.149Z |
4961817 | 4961817 | 20240811180658_zyhW4 | KR001Y | 2024-09-04T12:03:56.980Z | 2024-09-06T12:03:15.982Z |
4961707 | 4961707 | 20240811175807_BPOHN | KR001Y | 2024-09-04T12:03:51.579Z | 2024-09-06T12:03:11.207Z |
4961651 | 4961651 | 20240811175340_iRkUy | KR001Y | 2024-09-04T12:03:48.814Z | 2024-09-06T12:03:08.799Z |
4961546 | 4961546 | 20240811174640_lu1Tz | KR001Y | 2024-09-04T12:03:44.808Z | 2024-09-06T12:03:04.781Z |
4961534 | 4961534 | 20240811174618_lGSk4 | KR001Y | 2024-09-04T12:03:44.463Z | 2024-09-06T12:03:04.497Z |
4961180 | 4961180 | 20240811172244_5BvDI | KR001Y | 2024-09-04T12:03:21.767Z | 2024-09-06T12:02:46.662Z |
4961099 | 4961099 | 20240811171701_tkw6r | KR001Y | 2024-09-04T12:03:17.259Z | 2024-09-06T12:02:43.633Z |
4961064 | 4961064 | 20240811171439_3Y4T3 | KR001Y | 2024-09-04T12:03:15.397Z | 2024-09-06T12:02:42.441Z |
4960696 | 4960696 | 20240811164257_MpaW7 | KR001Y | 2024-09-04T12:02:50.404Z | 2024-09-06T12:02:22.607Z |
4960660 | 4960660 | 20240811164109_t8Cot | KR001Y | 2024-09-04T12:02:48.684Z | 2024-09-06T12:02:21.151Z |
4960525 | 4960525 | 20240811163203_2Wa1R | KR001Y | 2024-09-04T12:02:40.764Z | 2024-09-06T12:02:14.812Z |
4960506 | 4960506 | 20240811162851_GaCW2 | KR001Y | 2024-09-04T12:02:37.453Z | 2024-09-06T12:02:13.855Z |
4960017 | 4960017 | 20240811155706_sJE28 | KR001Y | 2024-09-04T12:02:07.663Z | 2024-09-06T12:01:47.850Z |
4960013 | 4960013 | 20240811155643_Hs8Wy | KR001Y | 2024-09-04T12:02:07.520Z | 2024-09-06T12:01:47.751Z |
4959909 | 4959909 | 20240811154800_2C2BS | KR001Y | 2024-09-04T12:02:02.429Z | 2024-09-06T12:01:42.963Z |
4959735 | 4959735 | 20240811153255_ruabp | KR001Y | 2024-09-04T12:01:52.785Z | 2024-09-06T12:01:34.858Z |
4959634 | 4959634 | 20240811152315_6h0qB | KR001Y | 2024-09-04T12:01:46.105Z | 2024-09-06T12:01:28.436Z |
4959520 | 4959520 | 20240811151328_jvBiM | KR001Y | 2024-09-04T12:01:39.346Z | 2024-09-06T12:01:20.773Z |
4959436 | 4959436 | 20240811150454_g1hNQ | KR001Y | 2024-09-04T12:01:33.818Z | 2024-09-06T12:01:16.594Z |
4951904 | 4951904 | 20240811144345_ytKOc | KR001Y | 2024-09-03T12:01:34.402Z | 2024-09-06T12:01:04.983Z |
4951328 | 4951328 | 20240811133056_EeZJ1 | KR001Y | 2024-09-03T12:00:51.758Z | 2024-09-06T12:00:38.740Z |
4951217 | 4951217 | 20240811131950_IlcMT | KR001Y | 2024-09-03T12:00:41.017Z | 2024-09-06T12:00:31.445Z |
4951185 | 4951185 | 20240811131608_Yw1NX | KR001Y | 2024-09-03T12:00:37.039Z | 2024-09-06T12:00:29.272Z |
4951095 | 4951095 | 20240811130426_91Okq | KR001Y | 2024-09-03T12:00:28.119Z | 2024-09-06T12:00:23.294Z |
4951038 | 4951038 | 20240811125745_QOSi6 | KR001Y | 2024-09-03T12:00:22.038Z | 2024-09-06T12:00:18.729Z |
4950987 | 4950987 | 20240811124933_lz4DO | KR001Y | 2024-09-03T12:00:16.760Z | 2024-09-06T12:00:14.842Z |
4935161 | 4935161 | 20240810194518_R0MJh | KR001Y | 2024-09-01T12:06:09.630Z | 2024-09-06T12:20:28.736Z |
4935033 | 4935033 | 20240810193009_xPLE1 | KR001Y | 2024-09-01T12:06:01.857Z | 2024-09-06T12:20:26.000Z |
4934962 | 4934962 | 20240810192344_Ub6g6 | KR001Y | 2024-09-01T12:05:58.278Z | 2024-09-06T12:20:24.562Z |
4934920 | 4934920 | 20240810191738_xGgMj | KR001Y | 2024-09-01T12:05:55.808Z | 2024-09-06T12:20:23.448Z |
4934894 | 4934894 | 20240810191453_uUAm6 | KR001Y | 2024-09-01T12:05:54.653Z | 2024-09-06T12:20:22.912Z |
4934842 | 4934842 | 20240810191020_NLjFU | KR001Y | 2024-09-01T12:05:52.598Z | 2024-09-06T12:20:22.094Z |
4934711 | 4934711 | 20240810185147_fOr46 | KR001Y | 2024-09-01T12:05:40.899Z | 2024-09-06T12:20:18.794Z |
4934639 | 4934639 | 20240810184233_LwAwb | KR001Y | 2024-09-01T12:05:36.497Z | 2024-09-06T12:20:17.034Z |
4934529 | 4934529 | 20240810182632_0fZpR | KR001Y | 2024-09-01T12:05:29.172Z | 2024-09-06T12:20:14.102Z |
4934525 | 4934525 | 20240810182632_RK0hK | KR001Y | 2024-09-01T12:05:29.024Z | 2024-09-06T12:20:14.084Z |
4934361 | 4934361 | 20240810180758_Tgvhf | KR001Y | 2024-09-01T12:05:12.913Z | 2024-09-06T12:20:09.751Z |
4934302 | 4934302 | 20240810180305_EObED | KR001Y | 2024-09-01T12:05:08.644Z | 2024-09-06T12:20:08.395Z |
4934133 | 4934133 | 20240810174821_zjehq | KR001Y | 2024-09-01T12:04:58.964Z | 2024-09-06T12:19:59.628Z |
4933498 | 4933498 | 20240810170651_o9gLR | KR001Y | 2024-09-01T12:04:22.140Z | 2024-09-06T12:19:17.800Z |
4933381 | 4933381 | 20240810170028_K3hdb | KR001Y | 2024-09-01T12:04:16.650Z | 2024-09-06T12:19:09.767Z |
4933309 | 4933309 | 20240810165607_w9kcJ | KR001Y | 2024-09-01T12:04:12.036Z | 2024-09-06T12:19:04.297Z |
4933235 | 4933235 | 20240810165151_7uC0F | KR001Y | 2024-09-01T12:04:04.884Z | 2024-09-06T12:19:02.574Z |
4932891 | 4932891 | 20240810162818_144OR | KR001Y | 2024-09-01T12:03:46.892Z | 2024-09-06T12:18:50.843Z |
4932849 | 4932849 | 20240810162307_SaVSw | KR001Y | 2024-09-01T12:03:44.265Z | 2024-09-06T12:18:49.465Z |
4932479 | 4932479 | 20240810160022_wI23T | KR001Y | 2024-09-01T12:03:23.964Z | 2024-09-06T12:18:40.133Z |
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);