participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,779 rows where station_code = "KR0027" 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 |
---|---|---|---|---|---|
5495501 | 5495501 | 20241106200410_JCxrQ | KR0027 | 2024-11-08T14:10:18.617Z | 2024-11-08T14:14:34.844Z |
5495152 | 5495152 | 20241106185006_QAudY | KR0027 | 2024-11-08T14:09:26.189Z | 2024-11-08T14:14:34.729Z |
5494483 | 5494483 | 20241106152057_7GUeS | KR0027 | 2024-11-08T14:07:36.246Z | 2024-11-08T14:14:34.461Z |
5490088 | 5490088 | 20241105205524_v5bq8 | KR0027 | 2024-11-07T14:13:09.409Z | 2024-11-08T14:16:16.880Z |
5489903 | 5489903 | 20241105202504_OEh4O | KR0027 | 2024-11-07T14:12:53.901Z | 2024-11-08T14:16:12.714Z |
5489563 | 5489563 | 20241105191617_OzffF | KR0027 | 2024-11-07T14:12:12.612Z | 2024-11-08T14:16:04.347Z |
5489521 | 5489521 | 20241105190830_FCIZR | KR0027 | 2024-11-07T14:12:07.656Z | 2024-11-08T14:16:03.314Z |
5489453 | 5489453 | 20241105185738_BK6mQ | KR0027 | 2024-11-07T14:12:03.189Z | 2024-11-08T14:16:02.047Z |
5489371 | 5489371 | 20241105184054_4GKuK | KR0027 | 2024-11-07T14:11:56.406Z | 2024-11-08T14:16:00.911Z |
5489142 | 5489142 | 20241105175536_0bJwk | KR0027 | 2024-11-07T14:11:22.519Z | 2024-11-08T14:15:56.262Z |
5488909 | 5488909 | 20241105171519_n4Dkj | KR0027 | 2024-11-07T14:10:51.787Z | 2024-11-08T14:15:49.482Z |
5488832 | 5488832 | 20241105170407_2lTZL | KR0027 | 2024-11-07T14:10:40.434Z | 2024-11-08T14:15:48.215Z |
5488735 | 5488735 | 20241105163842_0n217 | KR0027 | 2024-11-07T14:10:32.674Z | 2024-11-08T14:15:46.123Z |
5488638 | 5488638 | 20241105160738_j77Rt | KR0027 | 2024-11-07T14:10:24.441Z | 2024-11-08T14:15:41.905Z |
5488604 | 5488604 | 20241105155638_ldAgR | KR0027 | 2024-11-07T14:10:22.034Z | 2024-11-08T14:15:41.081Z |
5488452 | 5488452 | 20241105145020_DMJMK | KR0027 | 2024-11-07T14:09:55.443Z | 2024-11-08T14:15:35.999Z |
5488445 | 5488445 | 20241105144626_SM0Jd | KR0027 | 2024-11-07T14:09:54.936Z | 2024-11-08T14:15:35.874Z |
5488400 | 5488400 | 20241105142845_tccVV | KR0027 | 2024-11-07T14:09:49.478Z | 2024-11-08T14:15:33.278Z |
5488135 | 5488135 | 20241106210204_wKzVV | KR0027 | 2024-11-07T14:07:36.467Z | 2024-11-08T14:14:34.914Z |
5488012 | 5488012 | 20241106201025_AgM37 | KR0027 | 2024-11-07T14:07:23.194Z | 2024-11-08T14:14:34.854Z |
5487849 | 5487849 | 20241106190718_L2FLj | KR0027 | 2024-11-07T14:06:56.899Z | 2024-11-08T14:14:34.763Z |
5487643 | 5487643 | 20241106174200_sn7uW | KR0027 | 2024-11-07T14:06:22.473Z | 2024-11-08T14:14:34.635Z |
5487628 | 5487628 | 20241106173744_s3Q1V | KR0027 | 2024-11-07T14:06:21.184Z | 2024-11-08T14:14:34.627Z |
5487566 | 5487566 | 20241106171218_MCnjm | KR0027 | 2024-11-07T14:06:13.636Z | 2024-11-08T14:14:34.593Z |
5487448 | 5487448 | 20241106161736_aUUX6 | KR0027 | 2024-11-07T14:05:48.726Z | 2024-11-08T14:14:34.536Z |
5487292 | 5487292 | 20241106153225_QKjUp | KR0027 | 2024-11-07T14:05:28.816Z | 2024-11-08T14:14:34.482Z |
5487114 | 5487114 | 20241106144911_J89sJ | KR0027 | 2024-11-07T14:04:58.788Z | 2024-11-08T14:14:34.420Z |
5487075 | 5487075 | 20241106144052_VUIOG | KR0027 | 2024-11-07T14:04:55.447Z | 2024-11-08T14:14:34.412Z |
5487062 | 5487062 | 20241106143632_guwS2 | KR0027 | 2024-11-07T14:04:53.644Z | 2024-11-08T14:14:34.407Z |
5486686 | 5486686 | 20241106125429_S1qkX | KR0027 | 2024-11-07T14:03:45.808Z | 2024-11-08T14:14:34.302Z |
5480963 | 5480963 | 20241104113536_4pG0O | KR0027 | 2024-11-06T14:08:08.076Z | 2024-11-08T14:17:32.931Z |
5475493 | 5475493 | 20241103201700_2X4Fs | KR0027 | 2024-11-05T14:13:43.901Z | 2024-11-08T14:19:40.852Z |
5475345 | 5475345 | 20241103195140_c9AFu | KR0027 | 2024-11-05T14:13:15.161Z | 2024-11-08T14:19:38.866Z |
5475162 | 5475162 | 20241103192114_HaCkf | KR0027 | 2024-11-05T14:12:37.914Z | 2024-11-08T14:19:36.921Z |
5474937 | 5474937 | 20241103183848_4N96k | KR0027 | 2024-11-05T14:12:17.853Z | 2024-11-08T14:19:33.124Z |
5474898 | 5474898 | 20241103183414_OdJPb | KR0027 | 2024-11-05T14:12:14.592Z | 2024-11-08T14:19:32.397Z |
5474769 | 5474769 | 20241103181304_fte98 | KR0027 | 2024-11-05T14:11:55.689Z | 2024-11-08T14:19:30.391Z |
5474702 | 5474702 | 20241103180114_dUsx1 | KR0027 | 2024-11-05T14:11:38.800Z | 2024-11-08T14:19:29.239Z |
5474661 | 5474661 | 20241103175627_d3D3J | KR0027 | 2024-11-05T14:11:31.008Z | 2024-11-08T14:19:28.705Z |
5474609 | 5474609 | 20241103174759_AjPuF | KR0027 | 2024-11-05T14:11:21.864Z | 2024-11-08T14:19:28.093Z |
5474411 | 5474411 | 20241103171220_mesA2 | KR0027 | 2024-11-05T14:11:03.210Z | 2024-11-08T14:19:25.707Z |
5474374 | 5474374 | 20241103170706_L29i2 | KR0027 | 2024-11-05T14:11:00.292Z | 2024-11-08T14:19:25.412Z |
5474221 | 5474221 | 20241103162911_Gn1q7 | KR0027 | 2024-11-05T14:10:27.582Z | 2024-11-08T14:19:22.734Z |
5474198 | 5474198 | 20241103162335_Vu95P | KR0027 | 2024-11-05T14:10:23.235Z | 2024-11-08T14:19:22.452Z |
5474054 | 5474054 | 20241103154341_V3zbI | KR0027 | 2024-11-05T14:10:03.352Z | 2024-11-08T14:19:20.460Z |
5473917 | 5473917 | 20241103152040_FdVj8 | KR0027 | 2024-11-05T14:09:53.394Z | 2024-11-08T14:19:19.342Z |
5473818 | 5473818 | 20241103150755_ZK7F2 | KR0027 | 2024-11-05T14:09:46.394Z | 2024-11-08T14:19:18.859Z |
5467104 | 5467104 | 20241102200751_cf42y | KR0027 | 2024-11-04T14:10:38.553Z | 2024-11-08T14:20:52.025Z |
5467026 | 5467026 | 20241102194729_W1GnZ | KR0027 | 2024-11-04T14:10:28.950Z | 2024-11-08T14:20:50.927Z |
5467018 | 5467018 | 20241102194703_Dqbd5 | KR0027 | 2024-11-04T14:10:28.609Z | 2024-11-08T14:20:50.903Z |
5466819 | 5466819 | 20241102190255_QYfeE | KR0027 | 2024-11-04T14:09:54.474Z | 2024-11-08T14:20:49.457Z |
5466691 | 5466691 | 20241102183516_bMWL4 | KR0027 | 2024-11-04T14:09:34.129Z | 2024-11-08T14:20:48.586Z |
5466617 | 5466617 | 20241102181723_2yQ26 | KR0027 | 2024-11-04T14:09:25.494Z | 2024-11-08T14:20:47.782Z |
5466604 | 5466604 | 20241102181632_KfxO2 | KR0027 | 2024-11-04T14:09:24.883Z | 2024-11-08T14:20:47.765Z |
5466467 | 5466467 | 20241102174748_iU9Qi | KR0027 | 2024-11-04T14:08:56.453Z | 2024-11-08T14:20:45.969Z |
5466311 | 5466311 | 20241102170914_SK3Ge | KR0027 | 2024-11-04T14:08:36.017Z | 2024-11-08T14:20:44.425Z |
5466179 | 5466179 | 20241102164024_3N5FO | KR0027 | 2024-11-04T14:08:11.073Z | 2024-11-08T14:20:43.251Z |
5466067 | 5466067 | 20241102161420_A6dr0 | KR0027 | 2024-11-04T14:07:57.916Z | 2024-11-08T14:20:42.616Z |
5466046 | 5466046 | 20241102160558_A6rgq | KR0027 | 2024-11-04T14:07:55.630Z | 2024-11-08T14:20:42.378Z |
5466019 | 5466019 | 20241102155904_YCjZE | KR0027 | 2024-11-04T14:07:52.614Z | 2024-11-08T14:20:42.262Z |
5465995 | 5465995 | 20241102155216_tZ6ou | KR0027 | 2024-11-04T14:07:49.399Z | 2024-11-08T14:20:42.029Z |
5465976 | 5465976 | 20241102154434_NdNRg | KR0027 | 2024-11-04T14:07:39.890Z | 2024-11-08T14:20:41.914Z |
5465823 | 5465823 | 20241102142328_aAX83 | KR0027 | 2024-11-04T14:06:51.708Z | 2024-11-08T14:20:39.111Z |
5465796 | 5465796 | 20241102140920_y4A45 | KR0027 | 2024-11-04T14:06:45.031Z | 2024-11-08T14:20:38.911Z |
5439701 | 5439701 | 20241030202051_iRpSp | KR0027 | 2024-11-01T12:14:11.100Z | 2024-11-08T14:23:04.960Z |
5438223 | 5438223 | 20241030164208_YMu75 | KR0027 | 2024-11-01T12:11:22.251Z | 2024-11-08T14:22:59.207Z |
5438162 | 5438162 | 20241030163051_VgTFL | KR0027 | 2024-11-01T12:11:06.416Z | 2024-11-08T14:22:58.878Z |
5437472 | 5437472 | 20241030151058_JLpH5 | KR0027 | 2024-11-01T12:09:44.989Z | 2024-11-08T14:22:57.231Z |
5426249 | 5426249 | 20241029191713_EY4aO | KR0027 | 2024-10-31T12:09:43.267Z | 2024-11-07T14:26:38.579Z |
5426089 | 5426089 | 20241029184012_0ZdMH | KR0027 | 2024-10-31T12:09:15.720Z | 2024-11-07T14:26:37.418Z |
5425849 | 5425849 | 20241029180307_6gY2W | KR0027 | 2024-10-31T12:08:50.756Z | 2024-11-07T14:26:36.229Z |
5425785 | 5425785 | 20241029175447_Yrj3c | KR0027 | 2024-10-31T12:08:38.195Z | 2024-11-07T14:26:35.996Z |
5425502 | 5425502 | 20241029170246_Zy5yv | KR0027 | 2024-10-31T12:07:56.033Z | 2024-11-07T14:26:34.695Z |
5424689 | 5424689 | 20241029150042_KGmRV | KR0027 | 2024-10-31T12:05:51.118Z | 2024-11-07T14:26:32.548Z |
5424247 | 5424247 | 20241029134631_0fF3g | KR0027 | 2024-10-31T12:04:23.382Z | 2024-11-07T14:26:30.762Z |
5424011 | 5424011 | 20241029123542_PHYVY | KR0027 | 2024-10-31T12:03:33.395Z | 2024-11-07T14:26:29.894Z |
5418337 | 5418337 | 20241027202624_3B3gS | KR0027 | 2024-10-30T12:15:31.341Z | 2024-11-05T14:27:09.695Z |
5418017 | 5418017 | 20241027194058_ykOsS | KR0027 | 2024-10-30T12:14:45.186Z | 2024-11-05T14:27:08.869Z |
5417989 | 5417989 | 20241027193742_6VgCz | KR0027 | 2024-10-30T12:14:42.790Z | 2024-11-05T14:27:08.788Z |
5417511 | 5417511 | 20241027183944_irW3z | KR0027 | 2024-10-30T12:13:45.658Z | 2024-11-05T14:27:07.444Z |
5417228 | 5417228 | 20241027175852_DbYS6 | KR0027 | 2024-10-30T12:13:23.458Z | 2024-11-05T14:27:06.826Z |
5417008 | 5417008 | 20241027173451_iMWUk | KR0027 | 2024-10-30T12:12:43.458Z | 2024-11-05T14:27:06.166Z |
5416946 | 5416946 | 20241027172637_LNENr | KR0027 | 2024-10-30T12:12:37.881Z | 2024-11-05T14:27:06.001Z |
5394452 | 5394452 | 20241025203732_q2fHA | KR0027 | 2024-10-28T12:14:42.269Z | 2024-11-03T14:27:21.255Z |
5392755 | 5392755 | 20241026195506_DfU7Y | KR0027 | 2024-10-28T12:08:42.322Z | 2024-11-04T14:28:45.196Z |
5392724 | 5392724 | 20241026193735_6g3Tz | KR0027 | 2024-10-28T12:08:39.624Z | 2024-11-04T14:28:44.483Z |
5392717 | 5392717 | 20241026193641_TbU2M | KR0027 | 2024-10-28T12:08:38.782Z | 2024-11-04T14:28:44.422Z |
5392634 | 5392634 | 20241026185705_3oycT | KR0027 | 2024-10-28T12:08:23.018Z | 2024-11-04T14:28:42.838Z |
5392499 | 5392499 | 20241026173941_2ElzH | KR0027 | 2024-10-28T12:08:02.076Z | 2024-11-04T14:28:39.632Z |
5392460 | 5392460 | 20241026171702_hSpmY | KR0027 | 2024-10-28T12:07:58.588Z | 2024-11-04T14:28:39.127Z |
5392443 | 5392443 | 20241026170321_3joz3 | KR0027 | 2024-10-28T12:07:56.667Z | 2024-11-04T14:28:38.967Z |
5392404 | 5392404 | 20241026164049_jdegj | KR0027 | 2024-10-28T12:07:52.029Z | 2024-11-04T14:28:38.609Z |
5392384 | 5392384 | 20241026161715_Rodt7 | KR0027 | 2024-10-28T12:07:49.897Z | 2024-11-04T14:28:38.384Z |
5392215 | 5392215 | 20241026153035_FDCLQ | KR0027 | 2024-10-28T12:07:20.743Z | 2024-11-04T14:28:37.528Z |
5392173 | 5392173 | 20241026152544_YzPV3 | KR0027 | 2024-10-28T12:07:17.279Z | 2024-11-04T14:28:37.477Z |
5392028 | 5392028 | 20241026144115_dHUGE | KR0027 | 2024-10-28T12:07:03.489Z | 2024-11-04T14:28:37.231Z |
5391747 | 5391747 | 20241026130509_udqk4 | KR0027 | 2024-10-28T12:06:21.270Z | 2024-11-04T14:28:36.406Z |
5391194 | 5391194 | 20241026112212_BadKO | KR0027 | 2024-10-28T12:04:52.703Z | 2024-11-04T14:28:33.732Z |
5389221 | 5389221 | 20241023192508_EZGqB | KR0027 | 2024-10-27T12:24:32.722Z | 2024-11-01T12:26:51.236Z |
5389213 | 5389213 | 20241023191324_8oXKY | KR0027 | 2024-10-27T12:24:31.024Z | 2024-11-01T12:26:51.054Z |
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);