participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,839 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 |
---|---|---|---|---|---|
5569685 | 5569685 | 20241121205031_GbyI5 | KR0027 | 2024-11-22T14:11:29.470Z | 2024-11-22T14:11:29.470Z |
5569093 | 5569093 | 20241121142954_yRnXN | KR0027 | 2024-11-22T14:10:20.066Z | 2024-11-22T14:10:20.066Z |
5552154 | 5552154 | 20241118183448_JNpHq | KR0027 | 2024-11-19T14:06:03.033Z | 2024-11-22T14:22:15.304Z |
5552138 | 5552138 | 20241118182935_O5a8Z | KR0027 | 2024-11-19T14:06:02.491Z | 2024-11-22T14:22:15.146Z |
5552099 | 5552099 | 20241118181905_hqB1h | KR0027 | 2024-11-19T14:06:00.740Z | 2024-11-22T14:22:14.848Z |
5551520 | 5551520 | 20241118140523_KqDiK | KR0027 | 2024-11-19T14:04:56.430Z | 2024-11-22T14:22:11.222Z |
5551424 | 5551424 | 20241118133451_V0Sp7 | KR0027 | 2024-11-19T14:04:46.083Z | 2024-11-22T14:22:10.616Z |
5550312 | 5550312 | 20241118100444_HHlx9 | KR0027 | 2024-11-19T14:02:10.708Z | 2024-11-22T14:22:01.246Z |
5547651 | 5547651 | 20241117185045_1NrlM | KR0027 | 2024-11-18T14:06:10.973Z | 2024-11-22T14:22:42.284Z |
5547573 | 5547573 | 20241117181043_Pec3x | KR0027 | 2024-11-18T14:06:04.447Z | 2024-11-22T14:22:41.107Z |
5547498 | 5547498 | 20241117172448_7sVd3 | KR0027 | 2024-11-18T14:05:57.951Z | 2024-11-22T14:22:40.388Z |
5547435 | 5547435 | 20241117164221_cxfxf | KR0027 | 2024-11-18T14:05:51.795Z | 2024-11-22T14:22:39.878Z |
5547422 | 5547422 | 20241117164002_iVmqO | KR0027 | 2024-11-18T14:05:50.321Z | 2024-11-22T14:22:39.849Z |
5547413 | 5547413 | 20241117161929_EAGc8 | KR0027 | 2024-11-18T14:05:46.384Z | 2024-11-22T14:22:39.748Z |
5547367 | 5547367 | 20241117154953_85PMb | KR0027 | 2024-11-18T14:05:35.359Z | 2024-11-22T14:22:39.237Z |
5547310 | 5547310 | 20241117153501_McVNW | KR0027 | 2024-11-18T14:05:27.581Z | 2024-11-22T14:22:38.921Z |
5547071 | 5547071 | 20241117143502_z4OcK | KR0027 | 2024-11-18T14:04:53.676Z | 2024-11-22T14:22:36.642Z |
5536934 | 5536934 | 20241112194322_hVX4K | KR0027 | 2024-11-14T14:10:44.009Z | 2024-11-21T14:26:07.242Z |
5536706 | 5536706 | 20241112185602_nNxxB | KR0027 | 2024-11-14T14:10:29.062Z | 2024-11-21T14:26:05.067Z |
5534850 | 5534850 | 20241113205249_sf9IK | KR0027 | 2024-11-14T14:05:33.990Z | 2024-11-22T14:24:17.173Z |
5528452 | 5528452 | 20241111205644_oDSmL | KR0027 | 2024-11-13T14:10:42.195Z | 2024-11-20T14:25:30.730Z |
5528049 | 5528049 | 20241111192127_ZsI32 | KR0027 | 2024-11-13T14:09:45.052Z | 2024-11-20T14:25:24.585Z |
5528010 | 5528010 | 20241111191201_YmO5i | KR0027 | 2024-11-13T14:09:40.765Z | 2024-11-20T14:25:23.910Z |
5527981 | 5527981 | 20241111190854_DY2bO | KR0027 | 2024-11-13T14:09:39.275Z | 2024-11-20T14:25:23.748Z |
5527906 | 5527906 | 20241111185545_GZJ0l | KR0027 | 2024-11-13T14:09:31.931Z | 2024-11-20T14:25:22.816Z |
5527726 | 5527726 | 20241111182441_IHC2Y | KR0027 | 2024-11-13T14:09:00.025Z | 2024-11-20T14:25:18.564Z |
5527712 | 5527712 | 20241111182134_wasIf | KR0027 | 2024-11-13T14:08:58.005Z | 2024-11-20T14:25:18.379Z |
5527596 | 5527596 | 20241111174528_qCP43 | KR0027 | 2024-11-13T14:08:43.956Z | 2024-11-20T14:25:14.601Z |
5527568 | 5527568 | 20241111173917_tcb2a | KR0027 | 2024-11-13T14:08:40.870Z | 2024-11-20T14:25:14.080Z |
5527513 | 5527513 | 20241111172101_T7LIL | KR0027 | 2024-11-13T14:08:26.914Z | 2024-11-20T14:25:12.817Z |
5527493 | 5527493 | 20241111171016_UgooD | KR0027 | 2024-11-13T14:08:22.497Z | 2024-11-20T14:25:12.548Z |
5527482 | 5527482 | 20241111170605_2WUBu | KR0027 | 2024-11-13T14:08:21.082Z | 2024-11-20T14:25:11.913Z |
5527174 | 5527174 | 20241111110832_4y3Yg | KR0027 | 2024-11-13T14:06:33.698Z | 2024-11-20T14:24:48.282Z |
5525575 | 5525575 | 20241105185632_Itdct | KR0027 | 2024-11-12T14:26:42.881Z | 2024-11-14T14:23:13.343Z |
5525541 | 5525541 | 20241105172545_Md3gp | KR0027 | 2024-11-12T14:26:36.894Z | 2024-11-14T14:23:08.779Z |
5525321 | 5525321 | 20241106172424_WdISu | KR0027 | 2024-11-12T14:25:44.564Z | 2024-11-15T14:24:43.058Z |
5525041 | 5525041 | 20241108155644_L8XJy | KR0027 | 2024-11-12T14:22:50.529Z | 2024-11-17T14:23:23.069Z |
5524864 | 5524864 | 20241109143916_7fk07 | KR0027 | 2024-11-12T14:19:25.009Z | 2024-11-18T14:26:19.139Z |
5522658 | 5522658 | 20241110205433_T2ve4 | KR0027 | 2024-11-12T14:13:53.955Z | 2024-11-19T14:22:05.037Z |
5522440 | 5522440 | 20241110200351_vfjGE | KR0027 | 2024-11-12T14:13:16.557Z | 2024-11-19T14:22:02.093Z |
5522331 | 5522331 | 20241110194700_ll8Jy | KR0027 | 2024-11-12T14:13:05.638Z | 2024-11-19T14:22:00.651Z |
5521727 | 5521727 | 20241110180901_JWdrb | KR0027 | 2024-11-12T14:11:54.398Z | 2024-11-19T14:21:54.647Z |
5521587 | 5521587 | 20241110173905_wyGXL | KR0027 | 2024-11-12T14:11:41.289Z | 2024-11-19T14:21:53.634Z |
5521524 | 5521524 | 20241110172537_jYMh3 | KR0027 | 2024-11-12T14:11:26.565Z | 2024-11-19T14:21:53.237Z |
5521511 | 5521511 | 20241110172451_oM4bl | KR0027 | 2024-11-12T14:11:23.702Z | 2024-11-19T14:21:53.213Z |
5521326 | 5521326 | 20241110165142_Nuks4 | KR0027 | 2024-11-12T14:10:49.643Z | 2024-11-19T14:21:51.842Z |
5521174 | 5521174 | 20241110161915_oZ2qY | KR0027 | 2024-11-12T14:10:35.279Z | 2024-11-19T14:21:49.877Z |
5520907 | 5520907 | 20241110151938_UiBdq | KR0027 | 2024-11-12T14:09:44.546Z | 2024-11-19T14:21:45.533Z |
5503177 | 5503177 | 20241107205634_WixVD | KR0027 | 2024-11-09T14:12:31.073Z | 2024-11-16T14:28:03.985Z |
5502784 | 5502784 | 20241107194446_gadcQ | KR0027 | 2024-11-09T14:12:03.464Z | 2024-11-16T14:27:59.584Z |
5502775 | 5502775 | 20241107194407_PSuW8 | KR0027 | 2024-11-09T14:12:03.147Z | 2024-11-16T14:27:59.573Z |
5502702 | 5502702 | 20241107193304_t7aM8 | KR0027 | 2024-11-09T14:11:58.936Z | 2024-11-16T14:27:58.774Z |
5501193 | 5501193 | 20241108205205_VRAZL | KR0027 | 2024-11-09T14:07:49.503Z | 2024-11-17T14:23:37.226Z |
5500981 | 5500981 | 20241108184500_u3xtQ | KR0027 | 2024-11-09T14:07:32.194Z | 2024-11-17T14:23:31.827Z |
5500959 | 5500959 | 20241108184004_uLa2k | KR0027 | 2024-11-09T14:07:30.398Z | 2024-11-17T14:23:31.668Z |
5500935 | 5500935 | 20241108182347_An67d | KR0027 | 2024-11-09T14:07:28.886Z | 2024-11-17T14:23:31.365Z |
5500785 | 5500785 | 20241108173639_dEKAv | KR0027 | 2024-11-09T14:07:06.497Z | 2024-11-17T14:23:28.484Z |
5500693 | 5500693 | 20241108170239_GR7e3 | KR0027 | 2024-11-09T14:06:55.612Z | 2024-11-17T14:23:26.591Z |
5500089 | 5500089 | 20241108144036_YUm1V | KR0027 | 2024-11-09T14:05:40.357Z | 2024-11-17T14:23:18.599Z |
5499874 | 5499874 | 20241108135144_ORwRN | KR0027 | 2024-11-09T14:05:05.733Z | 2024-11-17T14:23:16.582Z |
5495501 | 5495501 | 20241106200410_JCxrQ | KR0027 | 2024-11-08T14:10:18.617Z | 2024-11-15T14:24:50.026Z |
5495152 | 5495152 | 20241106185006_QAudY | KR0027 | 2024-11-08T14:09:26.189Z | 2024-11-15T14:24:46.877Z |
5494483 | 5494483 | 20241106152057_7GUeS | KR0027 | 2024-11-08T14:07:36.246Z | 2024-11-15T14:24:38.320Z |
5490088 | 5490088 | 20241105205524_v5bq8 | KR0027 | 2024-11-07T14:13:09.409Z | 2024-11-14T14:23:17.469Z |
5489903 | 5489903 | 20241105202504_OEh4O | KR0027 | 2024-11-07T14:12:53.901Z | 2024-11-14T14:23:16.453Z |
5489563 | 5489563 | 20241105191617_OzffF | KR0027 | 2024-11-07T14:12:12.612Z | 2024-11-14T14:23:13.763Z |
5489521 | 5489521 | 20241105190830_FCIZR | KR0027 | 2024-11-07T14:12:07.656Z | 2024-11-14T14:23:13.635Z |
5489453 | 5489453 | 20241105185738_BK6mQ | KR0027 | 2024-11-07T14:12:03.189Z | 2024-11-14T14:23:13.359Z |
5489371 | 5489371 | 20241105184054_4GKuK | KR0027 | 2024-11-07T14:11:56.406Z | 2024-11-14T14:23:12.624Z |
5489142 | 5489142 | 20241105175536_0bJwk | KR0027 | 2024-11-07T14:11:22.519Z | 2024-11-14T14:23:10.581Z |
5488909 | 5488909 | 20241105171519_n4Dkj | KR0027 | 2024-11-07T14:10:51.787Z | 2024-11-14T14:23:08.532Z |
5488832 | 5488832 | 20241105170407_2lTZL | KR0027 | 2024-11-07T14:10:40.434Z | 2024-11-14T14:23:08.028Z |
5488735 | 5488735 | 20241105163842_0n217 | KR0027 | 2024-11-07T14:10:32.674Z | 2024-11-14T14:23:07.316Z |
5488638 | 5488638 | 20241105160738_j77Rt | KR0027 | 2024-11-07T14:10:24.441Z | 2024-11-14T14:23:06.904Z |
5488604 | 5488604 | 20241105155638_ldAgR | KR0027 | 2024-11-07T14:10:22.034Z | 2024-11-14T14:23:06.787Z |
5488452 | 5488452 | 20241105145020_DMJMK | KR0027 | 2024-11-07T14:09:55.443Z | 2024-11-14T14:23:05.633Z |
5488445 | 5488445 | 20241105144626_SM0Jd | KR0027 | 2024-11-07T14:09:54.936Z | 2024-11-14T14:23:05.592Z |
5488400 | 5488400 | 20241105142845_tccVV | KR0027 | 2024-11-07T14:09:49.478Z | 2024-11-14T14:23:05.410Z |
5488135 | 5488135 | 20241106210204_wKzVV | KR0027 | 2024-11-07T14:07:36.467Z | 2024-11-15T14:24:52.325Z |
5488012 | 5488012 | 20241106201025_AgM37 | KR0027 | 2024-11-07T14:07:23.194Z | 2024-11-15T14:24:50.314Z |
5487849 | 5487849 | 20241106190718_L2FLj | KR0027 | 2024-11-07T14:06:56.899Z | 2024-11-15T14:24:47.873Z |
5487643 | 5487643 | 20241106174200_sn7uW | KR0027 | 2024-11-07T14:06:22.473Z | 2024-11-15T14:24:43.852Z |
5487628 | 5487628 | 20241106173744_s3Q1V | KR0027 | 2024-11-07T14:06:21.184Z | 2024-11-15T14:24:43.757Z |
5487566 | 5487566 | 20241106171218_MCnjm | KR0027 | 2024-11-07T14:06:13.636Z | 2024-11-15T14:24:42.454Z |
5487448 | 5487448 | 20241106161736_aUUX6 | KR0027 | 2024-11-07T14:05:48.726Z | 2024-11-15T14:24:40.504Z |
5487292 | 5487292 | 20241106153225_QKjUp | KR0027 | 2024-11-07T14:05:28.816Z | 2024-11-15T14:24:38.890Z |
5487114 | 5487114 | 20241106144911_J89sJ | KR0027 | 2024-11-07T14:04:58.788Z | 2024-11-15T14:24:37.223Z |
5487075 | 5487075 | 20241106144052_VUIOG | KR0027 | 2024-11-07T14:04:55.447Z | 2024-11-15T14:24:37.011Z |
5487062 | 5487062 | 20241106143632_guwS2 | KR0027 | 2024-11-07T14:04:53.644Z | 2024-11-15T14:24:36.932Z |
5486686 | 5486686 | 20241106125429_S1qkX | KR0027 | 2024-11-07T14:03:45.808Z | 2024-11-15T14:24:33.050Z |
5480963 | 5480963 | 20241104113536_4pG0O | KR0027 | 2024-11-06T14:08:08.076Z | 2024-11-13T14:27:24.172Z |
5475493 | 5475493 | 20241103201700_2X4Fs | KR0027 | 2024-11-05T14:13:43.901Z | 2024-11-12T14:27:58.858Z |
5475345 | 5475345 | 20241103195140_c9AFu | KR0027 | 2024-11-05T14:13:15.161Z | 2024-11-12T14:27:57.979Z |
5475162 | 5475162 | 20241103192114_HaCkf | KR0027 | 2024-11-05T14:12:37.914Z | 2024-11-12T14:27:57.392Z |
5474937 | 5474937 | 20241103183848_4N96k | KR0027 | 2024-11-05T14:12:17.853Z | 2024-11-12T14:27:55.660Z |
5474898 | 5474898 | 20241103183414_OdJPb | KR0027 | 2024-11-05T14:12:14.592Z | 2024-11-12T14:27:55.286Z |
5474769 | 5474769 | 20241103181304_fte98 | KR0027 | 2024-11-05T14:11:55.689Z | 2024-11-12T14:27:54.613Z |
5474702 | 5474702 | 20241103180114_dUsx1 | KR0027 | 2024-11-05T14:11:38.800Z | 2024-11-12T14:27:53.914Z |
5474661 | 5474661 | 20241103175627_d3D3J | KR0027 | 2024-11-05T14:11:31.008Z | 2024-11-12T14:27:53.790Z |
5474609 | 5474609 | 20241103174759_AjPuF | KR0027 | 2024-11-05T14:11:21.864Z | 2024-11-12T14:27:53.464Z |
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);