participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,667 rows where station_code = "KR0006" 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 |
---|---|---|---|---|---|
4524318 | 4524318 | 20240628125313_Kf3SM | KR0006 | 2024-06-30T12:07:41.785Z | 2024-07-06T12:16:37.577Z |
4524036 | 4524036 | 20240628120956_alA0v | KR0006 | 2024-06-30T12:07:39.115Z | 2024-07-06T12:16:37.122Z |
4519331 | 4519331 | 20240628190459_26wTm | KR0006 | 2024-06-30T12:02:50.444Z | 2024-07-07T12:13:44.863Z |
4518860 | 4518860 | 20240628173814_zCi3f | KR0006 | 2024-06-30T12:02:18.205Z | 2024-07-07T12:13:44.403Z |
4518479 | 4518479 | 20240628163531_Yia5N | KR0006 | 2024-06-30T12:01:51.487Z | 2024-07-07T12:13:44.081Z |
4518314 | 4518314 | 20240628160911_NhlgB | KR0006 | 2024-06-30T12:01:40.783Z | 2024-07-07T12:13:43.927Z |
4518060 | 4518060 | 20240628153353_Xgfs0 | KR0006 | 2024-06-30T12:01:18.293Z | 2024-07-07T12:13:42.339Z |
4517697 | 4517697 | 20240628144127_TNNM8 | KR0006 | 2024-06-30T12:00:49.968Z | 2024-07-07T12:13:41.591Z |
4517634 | 4517634 | 20240628143236_9On8A | KR0006 | 2024-06-30T12:00:45.819Z | 2024-07-07T12:13:41.361Z |
4517381 | 4517381 | 20240628140206_sg0A7 | KR0006 | 2024-06-30T12:00:25.396Z | 2024-07-07T12:13:40.510Z |
4517278 | 4517278 | 20240628134239_Frlwr | KR0006 | 2024-06-30T12:00:17.542Z | 2024-07-07T12:13:40.323Z |
4510538 | 4510538 | 20240627121303_Ku3WT | KR0006 | 2024-06-28T12:04:45.747Z | 2024-07-05T12:11:33.636Z |
4508682 | 4508682 | 20240626183901_zieeo | KR0006 | 2024-06-28T12:03:01.720Z | 2024-07-05T12:11:23.620Z |
4507916 | 4507916 | 20240626163351_rJHk3 | KR0006 | 2024-06-28T12:02:23.314Z | 2024-07-05T12:11:22.391Z |
4507844 | 4507844 | 20240626162356_MiN1h | KR0006 | 2024-06-28T12:02:16.125Z | 2024-07-05T12:11:22.317Z |
4507629 | 4507629 | 20240626154813_78ahk | KR0006 | 2024-06-28T12:02:03.896Z | 2024-07-05T12:11:22.009Z |
4507476 | 4507476 | 20240626153108_rLbyz | KR0006 | 2024-06-28T12:01:56.741Z | 2024-07-05T12:11:21.949Z |
4506874 | 4506874 | 20240627150616_psGay | KR0006 | 2024-06-28T12:00:49.528Z | 2024-07-06T12:16:11.234Z |
4506750 | 4506750 | 20240627143053_S7F5v | KR0006 | 2024-06-28T12:00:39.459Z | 2024-07-06T12:16:10.022Z |
4506740 | 4506740 | 20240627142902_KdhZy | KR0006 | 2024-06-28T12:00:38.437Z | 2024-07-06T12:16:09.989Z |
4506721 | 4506721 | 20240627141923_26Kou | KR0006 | 2024-06-28T12:00:37.424Z | 2024-07-06T12:16:09.931Z |
4506690 | 4506690 | 20240627141107_aQZJW | KR0006 | 2024-06-28T12:00:35.060Z | 2024-07-06T12:16:09.746Z |
4506586 | 4506586 | 20240627134405_1rABV | KR0006 | 2024-06-28T12:00:27.606Z | 2024-07-06T12:16:09.463Z |
4506485 | 4506485 | 20240627130535_jPO9z | KR0006 | 2024-06-28T12:00:18.978Z | 2024-07-06T12:16:09.071Z |
4503281 | 4503281 | 20240626144443_6aXq0 | KR0006 | 2024-06-27T12:01:25.388Z | 2024-07-05T12:11:21.511Z |
4503187 | 4503187 | 20240626142258_SPx3k | KR0006 | 2024-06-27T12:01:14.242Z | 2024-07-05T12:11:21.233Z |
4503078 | 4503078 | 20240626140657_8rI8D | KR0006 | 2024-06-27T12:01:08.912Z | 2024-07-05T12:11:20.395Z |
4503048 | 4503048 | 20240626140535_TFOM2 | KR0006 | 2024-06-27T12:01:07.542Z | 2024-07-05T12:11:20.368Z |
4502984 | 4502984 | 20240626135915_iRtOI | KR0006 | 2024-06-27T12:01:04.221Z | 2024-07-05T12:11:20.330Z |
4502836 | 4502836 | 20240626133708_7Qojw | KR0006 | 2024-06-27T12:00:56.426Z | 2024-07-05T12:11:20.143Z |
4502780 | 4502780 | 20240626132746_gvgXI | KR0006 | 2024-06-27T12:00:52.760Z | 2024-07-05T12:11:20.052Z |
4502758 | 4502758 | 20240626132049_Y4mVL | KR0006 | 2024-06-27T12:00:51.066Z | 2024-07-05T12:11:20.034Z |
4502753 | 4502753 | 20240626132014_8wsVe | KR0006 | 2024-06-27T12:00:50.645Z | 2024-07-05T12:11:20.015Z |
4502634 | 4502634 | 20240626125359_jloBN | KR0006 | 2024-06-27T12:00:37.568Z | 2024-07-05T12:11:19.786Z |
4495939 | 4495939 | 20240624134851_BlxZn | KR0006 | 2024-06-25T12:00:21.803Z | 2024-07-03T12:13:04.701Z |
4494491 | 4494491 | 20240623124426_3jcfP | KR0006 | 2024-06-24T12:00:31.724Z | 2024-07-02T12:10:13.509Z |
4493438 | 4493438 | 20240621130451_HOKCe | KR0006 | 2024-06-23T12:01:19.450Z | 2024-06-30T12:09:36.399Z |
4491566 | 4491566 | 20240620184445_B5BJa | KR0006 | 2024-06-22T12:04:27.236Z | 2024-06-29T12:13:29.904Z |
4491555 | 4491555 | 20240620184350_DjZNz | KR0006 | 2024-06-22T12:04:26.484Z | 2024-06-29T12:13:29.873Z |
4491532 | 4491532 | 20240620183918_PQx8Z | KR0006 | 2024-06-22T12:04:25.286Z | 2024-06-29T12:13:29.515Z |
4491379 | 4491379 | 20240620181605_TJq64 | KR0006 | 2024-06-22T12:04:14.716Z | 2024-06-29T12:13:28.913Z |
4487764 | 4487764 | 20240619184745_iTPgL | KR0006 | 2024-06-21T12:04:21.608Z | 2024-06-28T12:09:34.434Z |
4487736 | 4487736 | 20240619184224_t5x3V | KR0006 | 2024-06-21T12:04:19.567Z | 2024-06-28T12:09:34.398Z |
4487700 | 4487700 | 20240619183302_232xe | KR0006 | 2024-06-21T12:04:15.363Z | 2024-06-28T12:09:34.316Z |
4487571 | 4487571 | 20240619181457_v2DMN | KR0006 | 2024-06-21T12:04:09.278Z | 2024-06-28T12:09:33.992Z |
4487491 | 4487491 | 20240619175429_TefIV | KR0006 | 2024-06-21T12:04:04.715Z | 2024-06-28T12:09:33.737Z |
4487457 | 4487457 | 20240619175208_rE13L | KR0006 | 2024-06-21T12:04:02.709Z | 2024-06-28T12:09:33.670Z |
4484029 | 4484029 | 20240618182935_xsx2M | KR0006 | 2024-06-20T12:04:56.102Z | 2024-06-27T12:11:26.993Z |
4483987 | 4483987 | 20240618182314_9FrZ3 | KR0006 | 2024-06-20T12:04:51.697Z | 2024-06-27T12:11:26.590Z |
4483949 | 4483949 | 20240618181929_OjkRL | KR0006 | 2024-06-20T12:04:48.378Z | 2024-06-27T12:11:26.409Z |
4483804 | 4483804 | 20240618180032_yUWAM | KR0006 | 2024-06-20T12:04:38.111Z | 2024-06-27T12:11:25.300Z |
4483781 | 4483781 | 20240618175740_2L3ZZ | KR0006 | 2024-06-20T12:04:37.347Z | 2024-06-27T12:11:25.158Z |
4483757 | 4483757 | 20240618175603_nB0TC | KR0006 | 2024-06-20T12:04:34.543Z | 2024-06-27T12:11:24.935Z |
4483661 | 4483661 | 20240618174231_x0LiX | KR0006 | 2024-06-20T12:04:29.241Z | 2024-06-27T12:11:24.263Z |
4483072 | 4483072 | 20240618161402_682y4 | KR0006 | 2024-06-20T12:03:30.362Z | 2024-06-27T12:11:20.156Z |
4483063 | 4483063 | 20240618161325_AG07N | KR0006 | 2024-06-20T12:03:28.614Z | 2024-06-27T12:11:20.104Z |
4482576 | 4482576 | 20240618142020_D8Egd | KR0006 | 2024-06-20T12:02:53.884Z | 2024-06-27T12:11:17.637Z |
4479586 | 4479586 | 20240616180008_23oZK | KR0006 | 2024-06-19T12:09:37.359Z | 2024-06-24T12:11:42.449Z |
4477816 | 4477816 | 20240617184738_P2Ob7 | KR0006 | 2024-06-19T12:06:01.829Z | 2024-06-26T12:14:36.697Z |
4477767 | 4477767 | 20240617183738_o03mL | KR0006 | 2024-06-19T12:05:59.009Z | 2024-06-26T12:14:35.845Z |
4477759 | 4477759 | 20240617183632_T27Qn | KR0006 | 2024-06-19T12:05:58.377Z | 2024-06-26T12:14:35.806Z |
4477687 | 4477687 | 20240617182645_p7Yuj | KR0006 | 2024-06-19T12:05:49.045Z | 2024-06-26T12:14:35.448Z |
4477610 | 4477610 | 20240617181445_xcB3K | KR0006 | 2024-06-19T12:05:36.704Z | 2024-06-26T12:14:35.160Z |
4477598 | 4477598 | 20240617181141_e9A42 | KR0006 | 2024-06-19T12:05:34.669Z | 2024-06-26T12:14:35.095Z |
4477586 | 4477586 | 20240617181118_EsDjb | KR0006 | 2024-06-19T12:05:33.584Z | 2024-06-26T12:14:35.054Z |
4477500 | 4477500 | 20240617180214_ECJd9 | KR0006 | 2024-06-19T12:05:27.681Z | 2024-06-26T12:14:33.941Z |
4477391 | 4477391 | 20240617174646_nyvuT | KR0006 | 2024-06-19T12:05:19.221Z | 2024-06-26T12:14:33.214Z |
4477309 | 4477309 | 20240617173006_Unx3R | KR0006 | 2024-06-19T12:05:13.556Z | 2024-06-26T12:14:32.447Z |
4477047 | 4477047 | 20240617165354_F8Hqn | KR0006 | 2024-06-19T12:04:45.916Z | 2024-06-26T12:14:29.778Z |
4473961 | 4473961 | 20240616165116_GMWZM | KR0006 | 2024-06-18T12:04:41.685Z | 2024-06-24T12:11:36.528Z |
4473949 | 4473949 | 20240616165041_feBBb | KR0006 | 2024-06-18T12:04:41.236Z | 2024-06-24T12:11:35.417Z |
4473407 | 4473407 | 20240616130149_3DXf3 | KR0006 | 2024-06-18T12:03:53.507Z | 2024-06-24T12:11:27.352Z |
4470880 | 4470880 | 20240615183536_E3bFQ | KR0006 | 2024-06-17T12:07:50.477Z | 2024-06-23T12:12:33.844Z |
4466814 | 4466814 | 20240614185245_muRQh | KR0006 | 2024-06-16T12:07:56.792Z | 2024-06-22T12:16:38.415Z |
4466756 | 4466756 | 20240614183057_JNmZF | KR0006 | 2024-06-16T12:07:53.051Z | 2024-06-22T12:16:37.117Z |
4466727 | 4466727 | 20240614182558_uOi75 | KR0006 | 2024-06-16T12:07:49.810Z | 2024-06-22T12:16:36.891Z |
4466505 | 4466505 | 20240614173434_l8paY | KR0006 | 2024-06-16T12:07:22.257Z | 2024-06-22T12:16:35.662Z |
4466395 | 4466395 | 20240614170718_83CTb | KR0006 | 2024-06-16T12:07:07.601Z | 2024-06-22T12:16:35.282Z |
4463167 | 4463167 | 20240613185053_SBfeK | KR0006 | 2024-06-15T12:09:31.439Z | 2024-06-21T12:11:48.091Z |
4462972 | 4462972 | 20240613181610_6uHHT | KR0006 | 2024-06-15T12:09:20.399Z | 2024-06-21T12:11:47.704Z |
4462808 | 4462808 | 20240613175042_CE9o5 | KR0006 | 2024-06-15T12:09:10.744Z | 2024-06-21T12:11:47.489Z |
4462776 | 4462776 | 20240613174515_NOnAl | KR0006 | 2024-06-15T12:09:09.086Z | 2024-06-21T12:11:47.440Z |
4462737 | 4462737 | 20240613173656_sWWJR | KR0006 | 2024-06-15T12:09:07.168Z | 2024-06-21T12:11:47.384Z |
4462720 | 4462720 | 20240613173327_Ezgda | KR0006 | 2024-06-15T12:09:06.283Z | 2024-06-21T12:11:47.369Z |
4462644 | 4462644 | 20240613172556_GFqBf | KR0006 | 2024-06-15T12:09:01.832Z | 2024-06-21T12:11:47.273Z |
4462486 | 4462486 | 20240613170245_N39BZ | KR0006 | 2024-06-15T12:08:44.045Z | 2024-06-21T12:11:46.996Z |
4462289 | 4462289 | 20240613163048_gUzcB | KR0006 | 2024-06-15T12:08:24.804Z | 2024-06-21T12:11:46.547Z |
4462214 | 4462214 | 20240613161825_op7hg | KR0006 | 2024-06-15T12:08:15.793Z | 2024-06-21T12:11:46.454Z |
4462201 | 4462201 | 20240613161636_xKrA2 | KR0006 | 2024-06-15T12:08:14.821Z | 2024-06-21T12:11:46.439Z |
4462186 | 4462186 | 20240613161419_Mtdzb | KR0006 | 2024-06-15T12:08:12.209Z | 2024-06-21T12:11:46.415Z |
4462154 | 4462154 | 20240613160848_x87c3 | KR0006 | 2024-06-15T12:08:10.778Z | 2024-06-21T12:11:46.400Z |
4462120 | 4462120 | 20240613160002_kRBzk | KR0006 | 2024-06-15T12:08:08.902Z | 2024-06-21T12:11:46.350Z |
4462010 | 4462010 | 20240613153404_Xb3wg | KR0006 | 2024-06-15T12:07:58.528Z | 2024-06-21T12:11:46.162Z |
4461932 | 4461932 | 20240613145959_b11MA | KR0006 | 2024-06-15T12:07:51.150Z | 2024-06-21T12:11:45.813Z |
4461909 | 4461909 | 20240613145325_opHEU | KR0006 | 2024-06-15T12:07:49.108Z | 2024-06-21T12:11:45.703Z |
4461881 | 4461881 | 20240613144544_SMqWs | KR0006 | 2024-06-15T12:07:47.344Z | 2024-06-21T12:11:45.665Z |
4461800 | 4461800 | 20240613141637_mUhcK | KR0006 | 2024-06-15T12:07:39.159Z | 2024-06-21T12:11:45.418Z |
4461777 | 4461777 | 20240613140614_4Py4z | KR0006 | 2024-06-15T12:07:34.880Z | 2024-06-21T12:11:45.192Z |
4461700 | 4461700 | 20240613133243_rljN8 | KR0006 | 2024-06-15T12:07:25.659Z | 2024-06-21T12:11:45.085Z |
4461610 | 4461610 | 20240613125817_gEbMf | KR0006 | 2024-06-15T12:07:14.325Z | 2024-06-21T12:11:44.555Z |
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);