participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
747 rows where station_code = "KR002H" 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 |
---|---|---|---|---|---|
5131472 | 5131472 | 20240915200008_QirUE | KR002H | 2024-09-19T12:15:05.262Z | 2024-09-19T12:15:05.262Z |
5131292 | 5131292 | 20240915190750_loFEt | KR002H | 2024-09-19T12:14:53.798Z | 2024-09-19T12:14:53.798Z |
5131235 | 5131235 | 20240915184523_JhyTl | KR002H | 2024-09-19T12:14:42.726Z | 2024-09-19T12:14:42.726Z |
5131200 | 5131200 | 20240915182808_kxC6y | KR002H | 2024-09-19T12:14:37.329Z | 2024-09-19T12:14:37.329Z |
5111037 | 5111037 | 20240914194421_RtzTE | KR002H | 2024-09-18T12:01:21.702Z | 2024-09-19T12:18:25.536Z |
5110767 | 5110767 | 20240914183103_ffVxt | KR002H | 2024-09-18T12:00:56.664Z | 2024-09-19T12:18:23.580Z |
5110713 | 5110713 | 20240914181301_ce3TN | KR002H | 2024-09-18T12:00:44.830Z | 2024-09-19T12:18:22.889Z |
5110654 | 5110654 | 20240914174914_23OME | KR002H | 2024-09-18T12:00:38.580Z | 2024-09-19T12:18:22.384Z |
5110608 | 5110608 | 20240914173457_082SF | KR002H | 2024-09-18T12:00:33.142Z | 2024-09-19T12:18:21.780Z |
5110599 | 5110599 | 20240914172831_JRhuZ | KR002H | 2024-09-18T12:00:31.950Z | 2024-09-19T12:18:21.717Z |
5052286 | 5052286 | 20240907200907_31jGs | KR002H | 2024-09-13T12:15:02.929Z | 2024-09-16T12:21:04.982Z |
5052060 | 5052060 | 20240907193724_WyPQW | KR002H | 2024-09-13T12:14:55.519Z | 2024-09-16T12:21:03.520Z |
5050625 | 5050625 | 20240907154850_2o2fB | KR002H | 2024-09-13T12:13:40.586Z | 2024-09-16T12:20:58.107Z |
4963101 | 4963101 | 20240811194313_jR4Cq | KR002H | 2024-09-04T12:05:10.704Z | 2024-09-06T12:04:18.218Z |
4962783 | 4962783 | 20240811192239_ODXNy | KR002H | 2024-09-04T12:04:52.215Z | 2024-09-06T12:04:02.695Z |
4962755 | 4962755 | 20240811192100_N8duz | KR002H | 2024-09-04T12:04:50.274Z | 2024-09-06T12:04:01.166Z |
4962644 | 4962644 | 20240811191401_uqiYt | KR002H | 2024-09-04T12:04:44.988Z | 2024-09-06T12:03:54.627Z |
4962636 | 4962636 | 20240811191343_dWqws | KR002H | 2024-09-04T12:04:44.731Z | 2024-09-06T12:03:54.422Z |
4962554 | 4962554 | 20240811190738_n3tDj | KR002H | 2024-09-04T12:04:38.540Z | 2024-09-06T12:03:51.030Z |
4962519 | 4962519 | 20240811190529_zcvIK | KR002H | 2024-09-04T12:04:36.921Z | 2024-09-06T12:03:49.571Z |
4962484 | 4962484 | 20240811190231_yQ7ZH | KR002H | 2024-09-04T12:04:35.416Z | 2024-09-06T12:03:48.357Z |
4962466 | 4962466 | 20240811190016_OnSWP | KR002H | 2024-09-04T12:04:32.957Z | 2024-09-06T12:03:47.538Z |
4962428 | 4962428 | 20240811185541_LKXrT | KR002H | 2024-09-04T12:04:29.955Z | 2024-09-06T12:03:45.877Z |
4962366 | 4962366 | 20240811185142_YCehk | KR002H | 2024-09-04T12:04:27.053Z | 2024-09-06T12:03:43.529Z |
4962352 | 4962352 | 20240811185034_prVGn | KR002H | 2024-09-04T12:04:26.254Z | 2024-09-06T12:03:42.931Z |
4962331 | 4962331 | 20240811184924_RQ1cI | KR002H | 2024-09-04T12:04:25.731Z | 2024-09-06T12:03:42.305Z |
4962231 | 4962231 | 20240811184249_71qZs | KR002H | 2024-09-04T12:04:21.727Z | 2024-09-06T12:03:34.048Z |
4962142 | 4962142 | 20240811183732_AL18H | KR002H | 2024-09-04T12:04:18.538Z | 2024-09-06T12:03:31.289Z |
4961883 | 4961883 | 20240811181231_ChC2w | KR002H | 2024-09-04T12:04:02.076Z | 2024-09-06T12:03:18.732Z |
4961878 | 4961878 | 20240811181146_glngU | KR002H | 2024-09-04T12:04:00.395Z | 2024-09-06T12:03:18.458Z |
4961803 | 4961803 | 20240811180554_HJawz | KR002H | 2024-09-04T12:03:56.403Z | 2024-09-06T12:03:15.498Z |
4961676 | 4961676 | 20240811175548_9dfz5 | KR002H | 2024-09-04T12:03:49.878Z | 2024-09-06T12:03:09.669Z |
4961616 | 4961616 | 20240811175159_N7SRY | KR002H | 2024-09-04T12:03:47.192Z | 2024-09-06T12:03:07.432Z |
4961339 | 4961339 | 20240811173144_94ymW | KR002H | 2024-09-04T12:03:32.051Z | 2024-09-06T12:02:52.686Z |
4961297 | 4961297 | 20240811173011_fR25C | KR002H | 2024-09-04T12:03:27.557Z | 2024-09-06T12:02:51.417Z |
4961128 | 4961128 | 20240811171854_kzwQv | KR002H | 2024-09-04T12:03:18.951Z | 2024-09-06T12:02:44.716Z |
4960957 | 4960957 | 20240811170557_3ATDj | KR002H | 2024-09-04T12:03:07.867Z | 2024-09-06T12:02:36.942Z |
4960907 | 4960907 | 20240811170046_nwkTu | KR002H | 2024-09-04T12:03:04.614Z | 2024-09-06T12:02:32.252Z |
4960738 | 4960738 | 20240811164453_atYxu | KR002H | 2024-09-04T12:02:52.479Z | 2024-09-06T12:02:24.215Z |
4960728 | 4960728 | 20240811164441_xeuht | KR002H | 2024-09-04T12:02:52.072Z | 2024-09-06T12:02:23.875Z |
4960663 | 4960663 | 20240811164109_t8Cot | KR002H | 2024-09-04T12:02:48.684Z | 2024-09-06T12:02:21.151Z |
4960643 | 4960643 | 20240811163952_mFq0o | KR002H | 2024-09-04T12:02:47.913Z | 2024-09-06T12:02:20.537Z |
4960568 | 4960568 | 20240811163428_ILOnF | KR002H | 2024-09-04T12:02:42.937Z | 2024-09-06T12:02:16.242Z |
4960445 | 4960445 | 20240811162608_QrPHU | KR002H | 2024-09-04T12:02:32.934Z | 2024-09-06T12:02:09.673Z |
4960386 | 4960386 | 20240811162241_nwXp2 | KR002H | 2024-09-04T12:02:29.780Z | 2024-09-06T12:02:06.822Z |
4960241 | 4960241 | 20240811161147_eJ2RC | KR002H | 2024-09-04T12:02:21.430Z | 2024-09-06T12:01:59.858Z |
4960171 | 4960171 | 20240811160626_SK6A6 | KR002H | 2024-09-04T12:02:16.914Z | 2024-09-06T12:01:56.475Z |
4960015 | 4960015 | 20240811155643_Hs8Wy | KR002H | 2024-09-04T12:02:07.524Z | 2024-09-06T12:01:47.751Z |
4960000 | 4960000 | 20240811155518_kyCzt | KR002H | 2024-09-04T12:02:06.438Z | 2024-09-06T12:01:46.764Z |
4959977 | 4959977 | 20240811155237_2EmvH | KR002H | 2024-09-04T12:02:05.241Z | 2024-09-06T12:01:45.697Z |
4959928 | 4959928 | 20240811154920_lkNkP | KR002H | 2024-09-04T12:02:03.007Z | 2024-09-06T12:01:43.650Z |
4959819 | 4959819 | 20240811154020_wT3ST | KR002H | 2024-09-04T12:01:57.455Z | 2024-09-06T12:01:38.889Z |
4959761 | 4959761 | 20240811153524_eBDWS | KR002H | 2024-09-04T12:01:54.645Z | 2024-09-06T12:01:36.371Z |
4959738 | 4959738 | 20240811153255_ruabp | KR002H | 2024-09-04T12:01:52.785Z | 2024-09-06T12:01:34.858Z |
4959640 | 4959640 | 20240811152315_6h0qB | KR002H | 2024-09-04T12:01:46.129Z | 2024-09-06T12:01:28.436Z |
4959531 | 4959531 | 20240811151449_6KO7I | KR002H | 2024-09-04T12:01:39.775Z | 2024-09-06T12:01:21.330Z |
4959416 | 4959416 | 20240811150304_sDJ2N | KR002H | 2024-09-04T12:01:32.665Z | 2024-09-06T12:01:15.724Z |
4951855 | 4951855 | 20240811143650_foQWI | KR002H | 2024-09-03T12:01:29.878Z | 2024-09-06T12:01:01.995Z |
4951726 | 4951726 | 20240811141756_wMYRJ | KR002H | 2024-09-03T12:01:21.164Z | 2024-09-06T12:00:56.095Z |
4951444 | 4951444 | 20240811134925_UtNSn | KR002H | 2024-09-03T12:01:02.285Z | 2024-09-06T12:00:44.319Z |
4951059 | 4951059 | 20240811125933_1OBfs | KR002H | 2024-09-03T12:00:23.915Z | 2024-09-06T12:00:19.990Z |
4950990 | 4950990 | 20240811124933_lz4DO | KR002H | 2024-09-03T12:00:16.767Z | 2024-09-06T12:00:14.842Z |
4935129 | 4935129 | 20240810194322_YX3qK | KR002H | 2024-09-01T12:06:08.150Z | 2024-09-06T12:20:27.813Z |
4935108 | 4935108 | 20240810193854_Vx2dd | KR002H | 2024-09-01T12:06:05.404Z | 2024-09-06T12:20:27.477Z |
4935055 | 4935055 | 20240810193253_CwoA0 | KR002H | 2024-09-01T12:06:02.395Z | 2024-09-06T12:20:26.151Z |
4935017 | 4935017 | 20240810192755_0fn6K | KR002H | 2024-09-01T12:06:00.921Z | 2024-09-06T12:20:25.501Z |
4934986 | 4934986 | 20240810192524_V6SiJ | KR002H | 2024-09-01T12:05:59.350Z | 2024-09-06T12:20:24.907Z |
4934892 | 4934892 | 20240810191448_Zl0QW | KR002H | 2024-09-01T12:05:54.536Z | 2024-09-06T12:20:22.880Z |
4934877 | 4934877 | 20240810191314_gbtDA | KR002H | 2024-09-01T12:05:54.045Z | 2024-09-06T12:20:22.679Z |
4934852 | 4934852 | 20240810191150_6mn1t | KR002H | 2024-09-01T12:05:52.983Z | 2024-09-06T12:20:22.222Z |
4934749 | 4934749 | 20240810185509_E280b | KR002H | 2024-09-01T12:05:45.335Z | 2024-09-06T12:20:19.603Z |
4934684 | 4934684 | 20240810184752_Zk74q | KR002H | 2024-09-01T12:05:38.707Z | 2024-09-06T12:20:17.790Z |
4934633 | 4934633 | 20240810184049_bYAA7 | KR002H | 2024-09-01T12:05:35.948Z | 2024-09-06T12:20:16.794Z |
4934574 | 4934574 | 20240810183242_cQJCF | KR002H | 2024-09-01T12:05:31.701Z | 2024-09-06T12:20:15.082Z |
4934555 | 4934555 | 20240810183033_z0L4R | KR002H | 2024-09-01T12:05:30.778Z | 2024-09-06T12:20:14.707Z |
4934339 | 4934339 | 20240810180458_M83eJ | KR002H | 2024-09-01T12:05:10.907Z | 2024-09-06T12:20:09.238Z |
4934306 | 4934306 | 20240810180305_EObED | KR002H | 2024-09-01T12:05:08.644Z | 2024-09-06T12:20:08.395Z |
4934264 | 4934264 | 20240810180048_iPSQ5 | KR002H | 2024-09-01T12:05:06.355Z | 2024-09-06T12:20:07.202Z |
4932847 | 4932847 | 20240810162246_W2wUp | KR002H | 2024-09-01T12:03:43.460Z | 2024-09-06T12:18:49.314Z |
4932544 | 4932544 | 20240810160531_7m9Pi | KR002H | 2024-09-01T12:03:26.706Z | 2024-09-06T12:18:41.535Z |
4932482 | 4932482 | 20240810160022_wI23T | KR002H | 2024-09-01T12:03:23.968Z | 2024-09-06T12:18:40.134Z |
4924427 | 4924427 | 20240810133228_Yc34A | KR002H | 2024-08-31T12:02:01.880Z | 2024-09-06T12:17:01.953Z |
4924402 | 4924402 | 20240810132937_Ia7WN | KR002H | 2024-08-31T12:02:00.492Z | 2024-09-06T12:17:01.206Z |
4850500 | 4850500 | 20240805191010_ImcHb | KR002H | 2024-08-17T12:13:15.818Z | 2024-08-19T12:23:07.320Z |
4850121 | 4850121 | 20240805182551_OrwMY | KR002H | 2024-08-17T12:12:38.805Z | 2024-08-19T12:22:45.514Z |
4850114 | 4850114 | 20240805182518_52Pag | KR002H | 2024-08-17T12:12:38.510Z | 2024-08-19T12:22:45.310Z |
4828162 | 4828162 | 20240804173051_2xhuS | KR002H | 2024-08-15T12:06:38.961Z | 2024-08-17T12:27:52.725Z |
4827985 | 4827985 | 20240804171544_Jtu5v | KR002H | 2024-08-15T12:06:25.532Z | 2024-08-17T12:27:42.978Z |
4826930 | 4826930 | 20240804153445_8XnBc | KR002H | 2024-08-15T12:04:45.892Z | 2024-08-17T12:27:08.584Z |
4670593 | 4670593 | 20240719182149_22Lis | KR002H | 2024-07-21T12:01:32.072Z | 2024-07-28T12:14:49.828Z |
4645513 | 4645513 | 20240714170410_MyeLH | KR002H | 2024-07-17T12:04:14.382Z | 2024-07-23T12:08:36.834Z |
4633729 | 4633729 | 20240712170653_t2cDv | KR002H | 2024-07-15T12:06:06.390Z | 2024-07-21T12:13:26.997Z |
4524068 | 4524068 | 20240628121302_nBzQj | KR002H | 2024-06-30T12:07:39.472Z | 2024-07-06T12:16:37.144Z |
4512860 | 4512860 | 20240627181444_2f5ZT | KR002H | 2024-06-29T12:04:23.472Z | 2024-07-06T12:16:14.287Z |
4512496 | 4512496 | 20240627172942_YWWFk | KR002H | 2024-06-29T12:03:58.215Z | 2024-07-06T12:16:13.634Z |
4507876 | 4507876 | 20240626162921_uhVpE | KR002H | 2024-06-28T12:02:20.088Z | 2024-07-05T12:11:22.348Z |
4507281 | 4507281 | 20240627170710_Vrmdp | KR002H | 2024-06-28T12:01:16.955Z | 2024-07-06T12:16:13.170Z |
4507114 | 4507114 | 20240627155842_myNGk | KR002H | 2024-06-28T12:01:04.080Z | 2024-07-06T12:16:12.132Z |
4506972 | 4506972 | 20240627153312_OTxFL | KR002H | 2024-06-28T12:00:56.838Z | 2024-07-06T12:16:11.559Z |
4506759 | 4506759 | 20240627143210_yQ8VQ | KR002H | 2024-06-28T12:00:40.002Z | 2024-07-06T12:16:10.070Z |
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);