participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,119 rows where station_code = "KR000M" 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 |
---|---|---|---|---|---|
5123675 | 5123675 | 20240914110326_lbRyz | KR000M | 2024-09-18T12:11:53.876Z | 2024-09-22T12:18:09.792Z |
5070448 | 5070448 | 20240909125444_QzMXd | KR000M | 2024-09-14T12:21:21.940Z | 2024-09-17T12:19:12.473Z |
5068989 | 5068989 | 20240910131921_8q1a3 | KR000M | 2024-09-14T12:19:23.483Z | 2024-09-18T12:15:26.957Z |
5068556 | 5068556 | 20240910114817_8EyhN | KR000M | 2024-09-14T12:19:17.923Z | 2024-09-18T12:15:26.309Z |
5063096 | 5063096 | 20240909195133_9bNg2 | KR000M | 2024-09-14T12:13:27.712Z | 2024-09-18T12:15:13.004Z |
5062994 | 5062994 | 20240909193156_3SZQf | KR000M | 2024-09-14T12:13:15.242Z | 2024-09-18T12:15:12.788Z |
5062931 | 5062931 | 20240909191247_ujLYN | KR000M | 2024-09-14T12:13:05.050Z | 2024-09-18T12:15:12.565Z |
5062227 | 5062227 | 20240909170019_K3MGA | KR000M | 2024-09-14T12:11:57.223Z | 2024-09-18T12:15:10.703Z |
5062200 | 5062200 | 20240909165640_Zp6kP | KR000M | 2024-09-14T12:11:55.356Z | 2024-09-18T12:15:10.565Z |
5061851 | 5061851 | 20240909160955_uJe2I | KR000M | 2024-09-14T12:11:32.825Z | 2024-09-18T12:15:10.064Z |
5061471 | 5061471 | 20240909151201_Fv0hn | KR000M | 2024-09-14T12:10:51.820Z | 2024-09-18T12:15:09.333Z |
5060961 | 5060961 | 20240909133743_eMNxz | KR000M | 2024-09-14T12:09:59.639Z | 2024-09-18T12:15:07.547Z |
5060087 | 5060087 | 20240910194902_aftcC | KR000M | 2024-09-14T12:08:11.083Z | 2024-09-19T12:21:31.790Z |
5059952 | 5059952 | 20240910192331_aAH4R | KR000M | 2024-09-14T12:07:49.150Z | 2024-09-19T12:21:31.491Z |
5059883 | 5059883 | 20240910191336_zOmr8 | KR000M | 2024-09-14T12:07:32.713Z | 2024-09-19T12:21:31.345Z |
5059718 | 5059718 | 20240910183602_TqpyG | KR000M | 2024-09-14T12:06:51.312Z | 2024-09-19T12:21:31.152Z |
5059669 | 5059669 | 20240910182738_4LXKJ | KR000M | 2024-09-14T12:06:43.273Z | 2024-09-19T12:21:31.056Z |
5059637 | 5059637 | 20240910182149_27AsR | KR000M | 2024-09-14T12:06:38.734Z | 2024-09-19T12:21:30.956Z |
5059604 | 5059604 | 20240910181603_98jqK | KR000M | 2024-09-14T12:06:34.399Z | 2024-09-19T12:21:30.928Z |
5059506 | 5059506 | 20240910175416_Lk8uj | KR000M | 2024-09-14T12:06:14.526Z | 2024-09-19T12:21:30.832Z |
5059476 | 5059476 | 20240910174829_N2Bgi | KR000M | 2024-09-14T12:06:12.075Z | 2024-09-19T12:21:30.819Z |
5059431 | 5059431 | 20240910174216_gVnIa | KR000M | 2024-09-14T12:06:02.044Z | 2024-09-19T12:21:30.765Z |
5059228 | 5059228 | 20240910172502_QOsy4 | KR000M | 2024-09-14T12:05:29.078Z | 2024-09-19T12:21:30.465Z |
5059092 | 5059092 | 20240910171217_1lxFH | KR000M | 2024-09-14T12:05:13.872Z | 2024-09-19T12:21:30.351Z |
5058845 | 5058845 | 20240910165146_NcKo4 | KR000M | 2024-09-14T12:04:38.741Z | 2024-09-19T12:21:30.171Z |
5058609 | 5058609 | 20240910163110_OAaPA | KR000M | 2024-09-14T12:04:08.405Z | 2024-09-19T12:21:29.791Z |
5058355 | 5058355 | 20240910160642_cV63v | KR000M | 2024-09-14T12:03:34.996Z | 2024-09-19T12:21:29.460Z |
5057485 | 5057485 | 20240910143422_IlPdx | KR000M | 2024-09-14T12:01:12.225Z | 2024-09-19T12:21:27.942Z |
5057419 | 5057419 | 20240910142627_FIUjk | KR000M | 2024-09-14T12:01:02.395Z | 2024-09-19T12:21:27.840Z |
5057022 | 5057022 | 20240908115545_fonw7 | KR000M | 2024-09-13T12:17:43.827Z | 2024-09-16T12:21:28.462Z |
5051909 | 5051909 | 20240907190340_25DJN | KR000M | 2024-09-13T12:14:43.829Z | 2024-09-16T12:21:02.470Z |
5051863 | 5051863 | 20240907185737_ZAHDu | KR000M | 2024-09-13T12:14:39.656Z | 2024-09-16T12:21:02.328Z |
5051763 | 5051763 | 20240907183336_YHrPH | KR000M | 2024-09-13T12:14:32.712Z | 2024-09-16T12:21:01.826Z |
5051750 | 5051750 | 20240907183121_ilKTJ | KR000M | 2024-09-13T12:14:32.454Z | 2024-09-16T12:21:01.809Z |
5051723 | 5051723 | 20240907182934_rw0JV | KR000M | 2024-09-13T12:14:31.510Z | 2024-09-16T12:21:01.667Z |
5051706 | 5051706 | 20240907182637_0wh1F | KR000M | 2024-09-13T12:14:30.329Z | 2024-09-16T12:21:01.645Z |
5051690 | 5051690 | 20240907182442_zrYSJ | KR000M | 2024-09-13T12:14:29.796Z | 2024-09-16T12:21:01.624Z |
5051667 | 5051667 | 20240907181655_P3HLc | KR000M | 2024-09-13T12:14:28.496Z | 2024-09-16T12:21:01.517Z |
5051594 | 5051594 | 20240907174808_zLQFE | KR000M | 2024-09-13T12:14:23.832Z | 2024-09-16T12:21:01.358Z |
5051543 | 5051543 | 20240907174233_vbz60 | KR000M | 2024-09-13T12:14:22.165Z | 2024-09-16T12:21:01.181Z |
5051532 | 5051532 | 20240907174006_MdVLm | KR000M | 2024-09-13T12:14:21.880Z | 2024-09-16T12:21:01.157Z |
5051528 | 5051528 | 20240907173958_BsCRO | KR000M | 2024-09-13T12:14:21.776Z | 2024-09-16T12:21:01.152Z |
5051525 | 5051525 | 20240907173915_JSqfm | KR000M | 2024-09-13T12:14:21.717Z | 2024-09-16T12:21:01.141Z |
5051507 | 5051507 | 20240907173728_rqg8R | KR000M | 2024-09-13T12:14:21.121Z | 2024-09-16T12:21:00.636Z |
5051448 | 5051448 | 20240907172829_r52q4 | KR000M | 2024-09-13T12:14:15.180Z | 2024-09-16T12:21:00.485Z |
5051372 | 5051372 | 20240907172053_eIZlD | KR000M | 2024-09-13T12:14:12.489Z | 2024-09-16T12:21:00.223Z |
5051242 | 5051242 | 20240907170736_RbEsX | KR000M | 2024-09-13T12:14:07.293Z | 2024-09-16T12:20:59.921Z |
5050865 | 5050865 | 20240907161721_RfOAz | KR000M | 2024-09-13T12:13:50.308Z | 2024-09-16T12:20:58.830Z |
5050643 | 5050643 | 20240907155203_bWe6S | KR000M | 2024-09-13T12:13:41.962Z | 2024-09-16T12:20:58.195Z |
5050567 | 5050567 | 20240907154048_hHOMu | KR000M | 2024-09-13T12:13:36.968Z | 2024-09-16T12:20:58.012Z |
5049791 | 5049791 | 20240909114112_Lx3qH | KR000M | 2024-09-13T12:12:26.648Z | 2024-09-17T12:19:11.496Z |
5049620 | 5049620 | 20240909111909_XWykP | KR000M | 2024-09-13T12:12:20.467Z | 2024-09-17T12:19:11.097Z |
5049575 | 5049575 | 20240909111320_v7fXR | KR000M | 2024-09-13T12:12:18.736Z | 2024-09-17T12:19:10.946Z |
5045683 | 5045683 | 20240908180305_p5JUM | KR000M | 2024-09-13T12:04:42.147Z | 2024-09-17T12:18:57.019Z |
5045582 | 5045582 | 20240908172622_0973w | KR000M | 2024-09-13T12:04:23.939Z | 2024-09-17T12:18:56.809Z |
5045467 | 5045467 | 20240908170756_fm7EV | KR000M | 2024-09-13T12:04:11.799Z | 2024-09-17T12:18:56.612Z |
5043810 | 5043810 | 20240908131513_9N3qv | KR000M | 2024-09-13T12:00:44.148Z | 2024-09-17T12:18:52.897Z |
5043447 | 5043447 | 20240907110759_mxAXZ | KR000M | 2024-09-12T12:17:33.946Z | 2024-09-15T12:21:41.710Z |
5043044 | 5043044 | 20240907133925_4Qk9R | KR000M | 2024-09-12T12:17:22.107Z | 2024-09-16T12:20:55.197Z |
5043021 | 5043021 | 20240907133439_R5cXz | KR000M | 2024-09-12T12:17:21.929Z | 2024-09-16T12:20:55.187Z |
5042827 | 5042827 | 20240907125511_2VeJA | KR000M | 2024-09-12T12:17:18.717Z | 2024-09-16T12:20:54.544Z |
5042551 | 5042551 | 20240907120054_3UtSt | KR000M | 2024-09-12T12:17:15.006Z | 2024-09-16T12:20:53.591Z |
5042459 | 5042459 | 20240907114514_1nXk8 | KR000M | 2024-09-12T12:17:12.051Z | 2024-09-16T12:20:53.017Z |
5042441 | 5042441 | 20240907113821_s9SfM | KR000M | 2024-09-12T12:17:11.226Z | 2024-09-16T12:20:52.884Z |
5042409 | 5042409 | 20240907113549_GencZ | KR000M | 2024-09-12T12:17:09.181Z | 2024-09-16T12:20:52.666Z |
5017704 | 5017704 | 20240904163359_bXhhJ | KR000M | 2024-09-10T12:09:25.134Z | 2024-09-13T12:19:47.059Z |
5017238 | 5017238 | 20240904154649_F3Iia | KR000M | 2024-09-10T12:08:57.623Z | 2024-09-13T12:19:46.679Z |
5015643 | 5015643 | 20240904120401_oJPvn | KR000M | 2024-09-10T12:06:34.640Z | 2024-09-13T12:19:44.557Z |
5015621 | 5015621 | 20240904120040_pX97E | KR000M | 2024-09-10T12:06:32.307Z | 2024-09-13T12:19:44.447Z |
5006977 | 5006977 | 20240903193734_1ePvw | KR000M | 2024-09-09T12:05:17.104Z | 2024-09-12T12:19:10.993Z |
5006946 | 5006946 | 20240903193357_AlqE7 | KR000M | 2024-09-09T12:05:14.871Z | 2024-09-12T12:19:10.943Z |
5006917 | 5006917 | 20240903192809_OoLL8 | KR000M | 2024-09-09T12:05:12.953Z | 2024-09-12T12:19:10.860Z |
5006894 | 5006894 | 20240903192250_xF33Z | KR000M | 2024-09-09T12:05:11.595Z | 2024-09-12T12:19:10.815Z |
5006848 | 5006848 | 20240903191202_XiP1U | KR000M | 2024-09-09T12:05:08.524Z | 2024-09-12T12:19:10.387Z |
5006215 | 5006215 | 20240903170557_N2Hhk | KR000M | 2024-09-09T12:04:25.230Z | 2024-09-12T12:19:07.975Z |
5005853 | 5005853 | 20240903162244_LLkpG | KR000M | 2024-09-09T12:04:09.988Z | 2024-09-12T12:19:06.967Z |
5005602 | 5005602 | 20240903154216_IDWfe | KR000M | 2024-09-09T12:03:50.906Z | 2024-09-12T12:19:06.244Z |
5005317 | 5005317 | 20240903145325_2kz2d | KR000M | 2024-09-09T12:03:36.389Z | 2024-09-12T12:19:05.724Z |
5005258 | 5005258 | 20240903143936_dbs0O | KR000M | 2024-09-09T12:03:32.103Z | 2024-09-12T12:19:05.602Z |
5005202 | 5005202 | 20240903143028_LdYOL | KR000M | 2024-09-09T12:03:26.508Z | 2024-09-12T12:19:05.458Z |
5005079 | 5005079 | 20240903135653_sHBV5 | KR000M | 2024-09-09T12:03:19.006Z | 2024-09-12T12:19:05.221Z |
5005039 | 5005039 | 20240903135006_3xg7v | KR000M | 2024-09-09T12:03:17.102Z | 2024-09-12T12:19:05.171Z |
5004959 | 5004959 | 20240903133931_ERlHh | KR000M | 2024-09-09T12:03:13.953Z | 2024-09-12T12:19:04.613Z |
5004947 | 5004947 | 20240903133640_M6iRK | KR000M | 2024-09-09T12:03:13.251Z | 2024-09-12T12:19:04.545Z |
5004907 | 5004907 | 20240903132310_Oq56i | KR000M | 2024-09-09T12:03:10.964Z | 2024-09-12T12:19:04.468Z |
5004865 | 5004865 | 20240903131024_JoXc7 | KR000M | 2024-09-09T12:03:08.727Z | 2024-09-12T12:19:04.393Z |
5004836 | 5004836 | 20240903130259_ZV293 | KR000M | 2024-09-09T12:03:05.544Z | 2024-09-12T12:19:04.339Z |
5004682 | 5004682 | 20240903120549_CWeZH | KR000M | 2024-09-09T12:02:54.485Z | 2024-09-12T12:19:03.503Z |
5004631 | 5004631 | 20240903115702_h7l3M | KR000M | 2024-09-09T12:02:51.792Z | 2024-09-12T12:19:03.328Z |
5004390 | 5004390 | 20240903112415_YT0Kv | KR000M | 2024-09-09T12:02:40.137Z | 2024-09-12T12:19:01.897Z |
4996475 | 4996475 | 20240902194346_jnsM5 | KR000M | 2024-09-08T12:04:51.098Z | 2024-09-11T12:20:54.748Z |
4996082 | 4996082 | 20240902183656_k94Ki | KR000M | 2024-09-08T12:04:21.252Z | 2024-09-11T12:20:50.985Z |
4995878 | 4995878 | 20240902180408_SFzXq | KR000M | 2024-09-08T12:04:09.362Z | 2024-09-11T12:20:49.221Z |
4995794 | 4995794 | 20240902175419_tvZdp | KR000M | 2024-09-08T12:04:04.831Z | 2024-09-11T12:20:48.120Z |
4995642 | 4995642 | 20240902172549_YIEH2 | KR000M | 2024-09-08T12:03:51.203Z | 2024-09-11T12:20:47.165Z |
4995549 | 4995549 | 20240902171729_08Kr9 | KR000M | 2024-09-08T12:03:46.048Z | 2024-09-11T12:20:46.295Z |
4995548 | 4995548 | 20240902171615_2x1ci | KR000M | 2024-09-08T12:03:45.873Z | 2024-09-11T12:20:46.237Z |
4995409 | 4995409 | 20240902165119_e3KeL | KR000M | 2024-09-08T12:03:38.032Z | 2024-09-11T12:20:45.179Z |
4995154 | 4995154 | 20240902162247_gZnLc | KR000M | 2024-09-08T12:03:18.494Z | 2024-09-11T12:20:42.516Z |
4645900 | 4645900 | 20240714182030_M7I07 | KR000M | 2024-07-17T12:04:52.833Z | 2024-07-23T12:08:37.567Z |
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);