participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,023 rows where station_code = "KR000L" 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 |
---|---|---|---|---|---|
5521732 | 5521732 | 20241110180903_vDEIw | KR000L | 2024-11-12T14:11:54.550Z | 2024-11-19T14:21:54.675Z |
5488519 | 5488519 | 20241105152552_7dy13 | KR000L | 2024-11-07T14:10:04.305Z | 2024-11-14T14:23:06.402Z |
5488249 | 5488249 | 20241105122511_0Luo4 | KR000L | 2024-11-07T14:09:17.513Z | 2024-11-14T14:23:03.886Z |
5487790 | 5487790 | 20241106183627_oLCWV | KR000L | 2024-11-07T14:06:47.348Z | 2024-11-15T14:24:46.596Z |
4637075 | 4637075 | 20240714144859_3EzrN | KR000L | 2024-07-16T12:02:14.334Z | 2024-07-23T12:08:35.941Z |
4636756 | 4636756 | 20240714130541_jbEOx | KR000L | 2024-07-16T12:01:53.868Z | 2024-07-23T12:08:35.224Z |
4625745 | 4625745 | 20240711155642_Ixucv | KR000L | 2024-07-14T12:06:41.771Z | 2024-07-20T12:13:10.687Z |
4625546 | 4625546 | 20240711153030_o2rgP | KR000L | 2024-07-14T12:06:31.081Z | 2024-07-20T12:13:10.316Z |
4618214 | 4618214 | 20240710190012_6Io2O | KR000L | 2024-07-13T12:07:21.899Z | 2024-07-19T12:13:38.267Z |
4618206 | 4618206 | 20240710185941_64thJ | KR000L | 2024-07-13T12:07:21.482Z | 2024-07-19T12:13:38.253Z |
4618132 | 4618132 | 20240710184938_4l9LQ | KR000L | 2024-07-13T12:07:17.028Z | 2024-07-19T12:13:38.086Z |
4618077 | 4618077 | 20240710183810_bkZp2 | KR000L | 2024-07-13T12:07:13.875Z | 2024-07-19T12:13:38.050Z |
4618066 | 4618066 | 20240710183547_b9vSQ | KR000L | 2024-07-13T12:07:13.363Z | 2024-07-19T12:13:38.046Z |
4617288 | 4617288 | 20240710172618_3oA3A | KR000L | 2024-07-13T12:06:43.167Z | 2024-07-19T12:13:37.443Z |
4617167 | 4617167 | 20240710171541_h6Dp3 | KR000L | 2024-07-13T12:06:40.173Z | 2024-07-19T12:13:37.291Z |
4616201 | 4616201 | 20240710154919_YcryR | KR000L | 2024-07-13T12:05:49.724Z | 2024-07-19T12:13:36.763Z |
4600672 | 4600672 | 20240708161344_U4dHk | KR000L | 2024-07-11T12:07:37.060Z | 2024-07-16T12:09:20.761Z |
4600580 | 4600580 | 20240708160553_WW3jk | KR000L | 2024-07-11T12:07:31.303Z | 2024-07-16T12:09:20.697Z |
4600545 | 4600545 | 20240708160012_JXWRh | KR000L | 2024-07-11T12:07:26.066Z | 2024-07-16T12:09:20.615Z |
4524448 | 4524448 | 20240628131433_dtmQa | KR000L | 2024-06-30T12:07:43.039Z | 2024-07-06T12:16:37.721Z |
4524390 | 4524390 | 20240628130322_3LxFu | KR000L | 2024-06-30T12:07:42.502Z | 2024-07-06T12:16:37.649Z |
4524062 | 4524062 | 20240628121302_nBzQj | KR000L | 2024-06-30T12:07:39.468Z | 2024-07-06T12:16:37.144Z |
4519332 | 4519332 | 20240628190459_26wTm | KR000L | 2024-06-30T12:02:50.444Z | 2024-07-07T12:13:44.863Z |
4519322 | 4519322 | 20240628190039_F37JC | KR000L | 2024-06-30T12:02:49.678Z | 2024-07-07T12:13:44.830Z |
4519306 | 4519306 | 20240628185548_lRsAy | KR000L | 2024-06-30T12:02:48.599Z | 2024-07-07T12:13:44.810Z |
4519223 | 4519223 | 20240628183428_aeJV4 | KR000L | 2024-06-30T12:02:37.961Z | 2024-07-07T12:13:44.743Z |
4519031 | 4519031 | 20240628180644_eM0GX | KR000L | 2024-06-30T12:02:27.726Z | 2024-07-07T12:13:44.546Z |
4519013 | 4519013 | 20240628180151_2acwW | KR000L | 2024-06-30T12:02:26.644Z | 2024-07-07T12:13:44.534Z |
4518969 | 4518969 | 20240628175825_OGm13 | KR000L | 2024-06-30T12:02:24.547Z | 2024-07-07T12:13:44.500Z |
4518891 | 4518891 | 20240628174218_I023w | KR000L | 2024-06-30T12:02:20.300Z | 2024-07-07T12:13:44.428Z |
4518765 | 4518765 | 20240628172620_H5FNs | KR000L | 2024-06-30T12:02:11.915Z | 2024-07-07T12:13:44.360Z |
4518741 | 4518741 | 20240628172322_qNy8b | KR000L | 2024-06-30T12:02:09.612Z | 2024-07-07T12:13:44.335Z |
4518706 | 4518706 | 20240628171735_93mBV | KR000L | 2024-06-30T12:02:04.738Z | 2024-07-07T12:13:44.306Z |
4518492 | 4518492 | 20240628163724_Qe06B | KR000L | 2024-06-30T12:01:52.243Z | 2024-07-07T12:13:44.097Z |
4518457 | 4518457 | 20240628163158_LbWGQ | KR000L | 2024-06-30T12:01:50.219Z | 2024-07-07T12:13:44.073Z |
4518325 | 4518325 | 20240628161008_pXQLB | KR000L | 2024-06-30T12:01:41.090Z | 2024-07-07T12:13:43.936Z |
4518317 | 4518317 | 20240628160911_NhlgB | KR000L | 2024-06-30T12:01:40.783Z | 2024-07-07T12:13:43.927Z |
4518255 | 4518255 | 20240628160131_NX0jm | KR000L | 2024-06-30T12:01:31.645Z | 2024-07-07T12:13:43.864Z |
4518116 | 4518116 | 20240628154132_R3CAN | KR000L | 2024-06-30T12:01:21.688Z | 2024-07-07T12:13:42.600Z |
4510549 | 4510549 | 20240627121451_prrLR | KR000L | 2024-06-28T12:04:46.013Z | 2024-07-05T12:11:33.662Z |
4508044 | 4508044 | 20240626165433_mll2m | KR000L | 2024-06-28T12:02:29.345Z | 2024-07-05T12:11:22.534Z |
4507744 | 4507744 | 20240626160341_972ka | KR000L | 2024-06-28T12:02:10.185Z | 2024-07-05T12:11:22.239Z |
4507631 | 4507631 | 20240626154813_78ahk | KR000L | 2024-06-28T12:02:03.896Z | 2024-07-05T12:11:22.009Z |
4507233 | 4507233 | 20240627164755_ND5Jb | KR000L | 2024-06-28T12:01:13.212Z | 2024-07-06T12:16:12.609Z |
4507105 | 4507105 | 20240627155842_myNGk | KR000L | 2024-06-28T12:01:04.080Z | 2024-07-06T12:16:12.132Z |
4507096 | 4507096 | 20240627155551_qzKUD | KR000L | 2024-06-28T12:01:03.880Z | 2024-07-06T12:16:12.121Z |
4506977 | 4506977 | 20240627153423_nb2AL | KR000L | 2024-06-28T12:00:57.343Z | 2024-07-06T12:16:11.730Z |
4506742 | 4506742 | 20240627142902_KdhZy | KR000L | 2024-06-28T12:00:38.437Z | 2024-07-06T12:16:09.989Z |
4506722 | 4506722 | 20240627141923_26Kou | KR000L | 2024-06-28T12:00:37.424Z | 2024-07-06T12:16:09.931Z |
4506643 | 4506643 | 20240627140032_3CaLB | KR000L | 2024-06-28T12:00:31.542Z | 2024-07-06T12:16:09.648Z |
4506587 | 4506587 | 20240627134405_1rABV | KR000L | 2024-06-28T12:00:27.606Z | 2024-07-06T12:16:09.463Z |
4506527 | 4506527 | 20240627131811_OyaQo | KR000L | 2024-06-28T12:00:22.178Z | 2024-07-06T12:16:09.132Z |
4506487 | 4506487 | 20240627130535_jPO9z | KR000L | 2024-06-28T12:00:18.978Z | 2024-07-06T12:16:09.071Z |
4503423 | 4503423 | 20240626151425_3tHEI | KR000L | 2024-06-27T12:01:36.876Z | 2024-07-05T12:11:21.731Z |
4503168 | 4503168 | 20240626142006_bySUB | KR000L | 2024-06-27T12:01:12.952Z | 2024-07-05T12:11:20.506Z |
4502946 | 4502946 | 20240626135130_1rfXN | KR000L | 2024-06-27T12:01:01.826Z | 2024-07-05T12:11:20.227Z |
4502759 | 4502759 | 20240626132049_Y4mVL | KR000L | 2024-06-27T12:00:51.066Z | 2024-07-05T12:11:20.034Z |
4502707 | 4502707 | 20240626131221_yX8gJ | KR000L | 2024-06-27T12:00:46.283Z | 2024-07-05T12:11:20.003Z |
4498440 | 4498440 | 20240625141026_J9BOy | KR000L | 2024-06-26T12:00:32.429Z | 2024-07-04T12:08:44.560Z |
4491628 | 4491628 | 20240620185906_jmpC6 | KR000L | 2024-06-22T12:04:30.947Z | 2024-06-29T12:13:30.329Z |
4491544 | 4491544 | 20240620184138_2IipS | KR000L | 2024-06-22T12:04:25.875Z | 2024-06-29T12:13:29.563Z |
4491518 | 4491518 | 20240620183853_rC0gk | KR000L | 2024-06-22T12:04:23.125Z | 2024-06-29T12:13:29.491Z |
4491247 | 4491247 | 20240620175449_dp4ei | KR000L | 2024-06-22T12:03:54.918Z | 2024-06-29T12:13:28.284Z |
4491243 | 4491243 | 20240620175444_YwFuS | KR000L | 2024-06-22T12:03:54.619Z | 2024-06-29T12:13:28.273Z |
4491211 | 4491211 | 20240620174357_0isz1 | KR000L | 2024-06-22T12:03:50.734Z | 2024-06-29T12:13:28.182Z |
4487648 | 4487648 | 20240619182608_0LfB4 | KR000L | 2024-06-21T12:04:12.887Z | 2024-06-28T12:09:34.171Z |
4487572 | 4487572 | 20240619181457_v2DMN | KR000L | 2024-06-21T12:04:09.278Z | 2024-06-28T12:09:33.992Z |
4487534 | 4487534 | 20240619180345_eZ83X | KR000L | 2024-06-21T12:04:06.613Z | 2024-06-28T12:09:33.889Z |
4487352 | 4487352 | 20240619173152_Zrfae | KR000L | 2024-06-21T12:03:55.672Z | 2024-06-28T12:09:33.380Z |
4484098 | 4484098 | 20240618183948_7Nwwp | KR000L | 2024-06-20T12:05:03.131Z | 2024-06-27T12:11:27.424Z |
4484066 | 4484066 | 20240618183643_HVN3Y | KR000L | 2024-06-20T12:05:00.469Z | 2024-06-27T12:11:27.192Z |
4483997 | 4483997 | 20240618182428_aDJYg | KR000L | 2024-06-20T12:04:52.860Z | 2024-06-27T12:11:26.609Z |
4483933 | 4483933 | 20240618181644_wZOYY | KR000L | 2024-06-20T12:04:47.783Z | 2024-06-27T12:11:26.311Z |
4483795 | 4483795 | 20240618175929_2SzMa | KR000L | 2024-06-20T12:04:37.853Z | 2024-06-27T12:11:25.276Z |
4483274 | 4483274 | 20240618165320_O72X2 | KR000L | 2024-06-20T12:03:53.878Z | 2024-06-27T12:11:21.245Z |
4483034 | 4483034 | 20240618161032_a3X22 | KR000L | 2024-06-20T12:03:25.381Z | 2024-06-27T12:11:19.985Z |
4479840 | 4479840 | 20240616184401_3LbsF | KR000L | 2024-06-19T12:09:53.714Z | 2024-06-24T12:11:47.787Z |
4479663 | 4479663 | 20240616181035_LHZDI | KR000L | 2024-06-19T12:09:42.457Z | 2024-06-24T12:11:43.395Z |
4479655 | 4479655 | 20240616181013_ViQ3z | KR000L | 2024-06-19T12:09:42.252Z | 2024-06-24T12:11:43.341Z |
4479649 | 4479649 | 20240616180840_hVavk | KR000L | 2024-06-19T12:09:42.115Z | 2024-06-24T12:11:43.310Z |
4479588 | 4479588 | 20240616180008_23oZK | KR000L | 2024-06-19T12:09:37.359Z | 2024-06-24T12:11:42.449Z |
4477862 | 4477862 | 20240617185212_C43wr | KR000L | 2024-06-19T12:06:04.378Z | 2024-06-26T12:14:36.950Z |
4477671 | 4477671 | 20240617182638_afwBg | KR000L | 2024-06-19T12:05:47.702Z | 2024-06-26T12:14:35.397Z |
4477588 | 4477588 | 20240617181118_EsDjb | KR000L | 2024-06-19T12:05:33.584Z | 2024-06-26T12:14:35.054Z |
4477549 | 4477549 | 20240617180742_tD7gH | KR000L | 2024-06-19T12:05:30.409Z | 2024-06-26T12:14:34.554Z |
4477502 | 4477502 | 20240617180214_ECJd9 | KR000L | 2024-06-19T12:05:27.681Z | 2024-06-26T12:14:33.941Z |
4477310 | 4477310 | 20240617173006_Unx3R | KR000L | 2024-06-19T12:05:13.556Z | 2024-06-26T12:14:32.447Z |
4477050 | 4477050 | 20240617165354_F8Hqn | KR000L | 2024-06-19T12:04:45.930Z | 2024-06-26T12:14:29.778Z |
4476938 | 4476938 | 20240617163051_f9OEg | KR000L | 2024-06-19T12:04:38.452Z | 2024-06-26T12:14:28.569Z |
4476739 | 4476739 | 20240617154352_SHEUI | KR000L | 2024-06-19T12:04:23.012Z | 2024-06-26T12:14:25.729Z |
4476707 | 4476707 | 20240617153803_NxOAs | KR000L | 2024-06-19T12:04:18.629Z | 2024-06-26T12:14:25.216Z |
4476601 | 4476601 | 20240617150049_XZJwP | KR000L | 2024-06-19T12:04:01.957Z | 2024-06-26T12:14:24.103Z |
4474108 | 4474108 | 20240616172257_Uk2s5 | KR000L | 2024-06-18T12:04:50.936Z | 2024-06-24T12:11:38.734Z |
4474039 | 4474039 | 20240616170728_o1fZc | KR000L | 2024-06-18T12:04:45.902Z | 2024-06-24T12:11:37.847Z |
4473976 | 4473976 | 20240616165446_SbxC7 | KR000L | 2024-06-18T12:04:42.373Z | 2024-06-24T12:11:36.842Z |
4473964 | 4473964 | 20240616165116_GMWZM | KR000L | 2024-06-18T12:04:41.685Z | 2024-06-24T12:11:36.528Z |
4473912 | 4473912 | 20240616164147_aGXo1 | KR000L | 2024-06-18T12:04:38.400Z | 2024-06-24T12:11:35.060Z |
4473572 | 4473572 | 20240616143318_ygqal | KR000L | 2024-06-18T12:04:10.620Z | 2024-06-24T12:11:29.958Z |
4473556 | 4473556 | 20240616142940_W3i6H | KR000L | 2024-06-18T12:04:09.400Z | 2024-06-24T12:11:29.693Z |
4470971 | 4470971 | 20240615185048_pG871 | KR000L | 2024-06-17T12:07:58.141Z | 2024-06-23T12:12:34.443Z |
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);