participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,331 rows where station_code = "KR0015" 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 |
---|---|---|---|---|---|
5124077 | 5124077 | 20240914144716_31nZt | KR0015 | 2024-09-18T12:12:05.563Z | 2024-09-19T12:20:17.675Z |
5123699 | 5123699 | 20240914110855_Mqjyq | KR0015 | 2024-09-18T12:11:54.387Z | 2024-09-19T12:20:13.844Z |
5110917 | 5110917 | 20240914192732_rzsdT | KR0015 | 2024-09-18T12:01:12.001Z | 2024-09-19T12:18:24.807Z |
5062314 | 5062314 | 20240909171025_x4d6g | KR0015 | 2024-09-14T12:12:09.123Z | 2024-09-18T12:15:10.867Z |
5051601 | 5051601 | 20240907174857_MmTvn | KR0015 | 2024-09-13T12:14:24.080Z | 2024-09-16T12:21:01.365Z |
5051577 | 5051577 | 20240907174734_6Qmkf | KR0015 | 2024-09-13T12:14:23.420Z | 2024-09-16T12:21:01.351Z |
5050956 | 5050956 | 20240907162934_EaWRY | KR0015 | 2024-09-13T12:13:54.824Z | 2024-09-16T12:20:59.399Z |
5050315 | 5050315 | 20240907150833_hHLnn | KR0015 | 2024-09-13T12:13:24.482Z | 2024-09-16T12:20:57.044Z |
5045880 | 5045880 | 20240908195137_1lQ22 | KR0015 | 2024-09-13T12:05:17.894Z | 2024-09-17T12:18:58.056Z |
5045798 | 5045798 | 20240908192804_xn2MB | KR0015 | 2024-09-13T12:04:59.384Z | 2024-09-17T12:18:57.380Z |
5045780 | 5045780 | 20240908191953_be8HY | KR0015 | 2024-09-13T12:04:56.437Z | 2024-09-17T12:18:57.290Z |
5045608 | 5045608 | 20240908173117_stuKx | KR0015 | 2024-09-13T12:04:26.600Z | 2024-09-17T12:18:56.865Z |
5045422 | 5045422 | 20240908170230_FSLxm | KR0015 | 2024-09-13T12:04:07.884Z | 2024-09-17T12:18:56.481Z |
5043095 | 5043095 | 20240907134910_FWBLD | KR0015 | 2024-09-12T12:17:23.320Z | 2024-09-16T12:20:55.358Z |
5018524 | 5018524 | 20240904183522_33xj5 | KR0015 | 2024-09-10T12:10:46.996Z | 2024-09-13T12:19:48.022Z |
5018085 | 5018085 | 20240904171028_jnP5y | KR0015 | 2024-09-10T12:09:59.464Z | 2024-09-13T12:19:47.187Z |
5017445 | 5017445 | 20240904160911_u2L2F | KR0015 | 2024-09-10T12:09:11.038Z | 2024-09-13T12:19:46.887Z |
5016752 | 5016752 | 20240904144915_Y2t0O | KR0015 | 2024-09-10T12:08:14.720Z | 2024-09-13T12:19:46.260Z |
5015819 | 5015819 | 20240904124106_JQSEf | KR0015 | 2024-09-10T12:06:48.934Z | 2024-09-13T12:19:44.716Z |
5015766 | 5015766 | 20240904122838_OYxu2 | KR0015 | 2024-09-10T12:06:45.373Z | 2024-09-13T12:19:44.653Z |
5007102 | 5007102 | 20240903195747_HbgJo | KR0015 | 2024-09-09T12:05:26.336Z | 2024-09-12T12:19:11.362Z |
5006920 | 5006920 | 20240903193003_TTBPW | KR0015 | 2024-09-09T12:05:13.144Z | 2024-09-12T12:19:10.861Z |
5006605 | 5006605 | 20240903180248_WPyPd | KR0015 | 2024-09-09T12:04:48.733Z | 2024-09-12T12:19:09.024Z |
5006276 | 5006276 | 20240903171047_I05D1 | KR0015 | 2024-09-09T12:04:28.701Z | 2024-09-12T12:19:08.071Z |
5005442 | 5005442 | 20240903151358_5J0Ir | KR0015 | 2024-09-09T12:03:43.020Z | 2024-09-12T12:19:05.949Z |
5004997 | 5004997 | 20240903134439_44orq | KR0015 | 2024-09-09T12:03:15.276Z | 2024-09-12T12:19:04.723Z |
5004966 | 5004966 | 20240903134030_H0B4V | KR0015 | 2024-09-09T12:03:14.133Z | 2024-09-12T12:19:04.621Z |
4987907 | 4987907 | 20240901191534_wwdLq | KR0015 | 2024-09-07T12:06:27.951Z | 2024-09-10T12:19:11.810Z |
4987673 | 4987673 | 20240901182503_KzxGk | KR0015 | 2024-09-07T12:06:06.031Z | 2024-09-10T12:19:11.166Z |
4987594 | 4987594 | 20240901180619_9MEJu | KR0015 | 2024-09-07T12:05:58.583Z | 2024-09-10T12:19:11.015Z |
4935159 | 4935159 | 20240810194518_R0MJh | KR0015 | 2024-09-01T12:06:09.630Z | 2024-09-06T12:20:28.736Z |
4935045 | 4935045 | 20240810193214_VtwWq | KR0015 | 2024-09-01T12:06:02.229Z | 2024-09-06T12:20:26.118Z |
4934878 | 4934878 | 20240810191335_ix9H2 | KR0015 | 2024-09-01T12:05:54.159Z | 2024-09-06T12:20:22.729Z |
4934734 | 4934734 | 20240810185324_zdMe6 | KR0015 | 2024-09-01T12:05:44.521Z | 2024-09-06T12:20:19.396Z |
4934660 | 4934660 | 20240810184542_GQhM4 | KR0015 | 2024-09-01T12:05:37.983Z | 2024-09-06T12:20:17.547Z |
4934533 | 4934533 | 20240810182649_U1Fos | KR0015 | 2024-09-01T12:05:29.451Z | 2024-09-06T12:20:14.189Z |
4934527 | 4934527 | 20240810182632_0fZpR | KR0015 | 2024-09-01T12:05:29.172Z | 2024-09-06T12:20:14.102Z |
4934299 | 4934299 | 20240810180305_EObED | KR0015 | 2024-09-01T12:05:08.644Z | 2024-09-06T12:20:08.395Z |
4934132 | 4934132 | 20240810174821_zjehq | KR0015 | 2024-09-01T12:04:58.964Z | 2024-09-06T12:19:59.628Z |
4933196 | 4933196 | 20240810164825_5RKl2 | KR0015 | 2024-09-01T12:04:02.466Z | 2024-09-06T12:19:01.379Z |
4897490 | 4897490 | 20240807181024_CyDfJ | KR0015 | 2024-08-28T12:15:31.220Z | 2024-08-28T12:15:31.220Z |
4897035 | 4897035 | 20240807170104_qfV2p | KR0015 | 2024-08-28T12:15:00.582Z | 2024-08-28T12:15:00.582Z |
4896991 | 4896991 | 20240807165349_x1srF | KR0015 | 2024-08-28T12:14:58.560Z | 2024-08-28T12:14:58.560Z |
4896849 | 4896849 | 20240807163202_9D90O | KR0015 | 2024-08-28T12:14:49.346Z | 2024-08-28T12:14:49.346Z |
4896469 | 4896469 | 20240807151456_srfRw | KR0015 | 2024-08-28T12:14:21.648Z | 2024-08-28T12:14:21.648Z |
4896466 | 4896466 | 20240807151358_P2CQg | KR0015 | 2024-08-28T12:14:20.825Z | 2024-08-28T12:14:20.825Z |
4896437 | 4896437 | 20240807150933_p7NV7 | KR0015 | 2024-08-28T12:14:18.060Z | 2024-08-28T12:14:18.060Z |
4896330 | 4896330 | 20240807145243_UDSGQ | KR0015 | 2024-08-28T12:14:11.404Z | 2024-08-28T12:14:11.404Z |
4871004 | 4871004 | 20240806184059_46laC | KR0015 | 2024-08-19T12:08:27.037Z | 2024-08-27T12:09:14.062Z |
4870911 | 4870911 | 20240806183505_XeW1d | KR0015 | 2024-08-19T12:08:17.372Z | 2024-08-27T12:09:10.509Z |
4870170 | 4870170 | 20240806174908_8Xp5n | KR0015 | 2024-08-19T12:07:41.552Z | 2024-08-27T12:08:38.051Z |
4869437 | 4869437 | 20240806171758_kClxN | KR0015 | 2024-08-19T12:07:08.563Z | 2024-08-27T12:08:08.768Z |
4869248 | 4869248 | 20240806170901_cvulU | KR0015 | 2024-08-19T12:06:56.682Z | 2024-08-27T12:08:02.800Z |
4867579 | 4867579 | 20240806165215_uLErP | KR0015 | 2024-08-18T12:08:49.426Z | 2024-08-27T12:07:42.661Z |
4867316 | 4867316 | 20240806163550_qV9E6 | KR0015 | 2024-08-18T12:08:40.432Z | 2024-08-27T12:07:32.836Z |
4866644 | 4866644 | 20240806155945_yZ01A | KR0015 | 2024-08-18T12:07:45.673Z | 2024-08-27T12:07:04.505Z |
4866360 | 4866360 | 20240806154346_dpT5h | KR0015 | 2024-08-18T12:07:32.326Z | 2024-08-27T12:06:53.725Z |
4866139 | 4866139 | 20240806153129_kQs6q | KR0015 | 2024-08-18T12:07:24.418Z | 2024-08-27T12:06:45.467Z |
4865991 | 4865991 | 20240806152538_z17T3 | KR0015 | 2024-08-18T12:07:19.713Z | 2024-08-27T12:06:37.693Z |
4864722 | 4864722 | 20240806142902_3g4o6 | KR0015 | 2024-08-18T12:06:15.866Z | 2024-08-27T12:05:47.767Z |
4849644 | 4849644 | 20240805175824_0eSJA | KR0015 | 2024-08-17T12:12:02.800Z | 2024-08-19T12:22:24.425Z |
4849639 | 4849639 | 20240805175756_Pu0gQ | KR0015 | 2024-08-17T12:12:02.292Z | 2024-08-19T12:22:24.315Z |
4846795 | 4846795 | 20240805162845_AbrFn | KR0015 | 2024-08-16T12:10:33.372Z | 2024-08-19T12:21:00.578Z |
4142217 | 4142217 | 20240403165710_938sQ | KR0015 | 2024-04-05T12:01:26.047Z | 2024-04-12T12:19:42.765Z |
3950436 | 3950436 | 20240211171710_Dpao1 | KR0015 | 2024-02-13T14:02:39.176Z | 2024-02-20T14:25:22.172Z |
3946722 | 3946722 | 20240210182647_HDO7Q | KR0015 | 2024-02-12T14:04:20.623Z | 2024-02-19T14:19:09.455Z |
3946672 | 3946672 | 20240210181735_EuHD3 | KR0015 | 2024-02-12T14:04:10.150Z | 2024-02-19T14:19:09.239Z |
3946646 | 3946646 | 20240210181054_y4A8o | KR0015 | 2024-02-12T14:04:07.867Z | 2024-02-19T14:19:09.163Z |
3946530 | 3946530 | 20240210174854_ogZ3B | KR0015 | 2024-02-12T14:03:47.362Z | 2024-02-19T14:19:08.912Z |
3942496 | 3942496 | 20240209165203_Ol0Ha | KR0015 | 2024-02-11T14:03:33.520Z | 2024-02-18T14:22:03.496Z |
3941347 | 3941347 | 20240209143122_teleh | KR0015 | 2024-02-10T14:13:44.112Z | 2024-02-17T14:26:42.793Z |
3938468 | 3938468 | 20240208184057_kqoYa | KR0015 | 2024-02-10T14:03:27.123Z | 2024-02-17T14:26:04.115Z |
3894040 | 3894040 | 20240128200024_DIR34 | KR0015 | 2024-01-30T14:00:59.511Z | 2024-02-06T14:20:36.645Z |
3891337 | 3891337 | 20240127210202_805AM | KR0015 | 2024-01-29T14:00:58.292Z | 2024-02-05T14:19:01.546Z |
3886623 | 3886623 | 20240125195757_8ZQX0 | KR0015 | 2024-01-27T14:00:11.654Z | 2024-02-03T14:24:10.285Z |
3886183 | 3886183 | 20240124200231_G5gpJ | KR0015 | 2024-01-26T14:07:27.556Z | 2024-02-01T14:18:19.052Z |
3884530 | 3884530 | 20240125180445_RlpOr | KR0015 | 2024-01-26T14:03:30.383Z | 2024-02-02T14:19:34.960Z |
3883459 | 3883459 | 20240124203652_aV02h | KR0015 | 2024-01-26T14:00:25.151Z | 2024-02-02T14:19:09.752Z |
3838007 | 3838007 | 20240115214817_dML6H | KR0015 | 2024-01-18T14:15:04.091Z | 2024-01-24T14:19:17.672Z |
3837926 | 3837926 | 20240115214053_8Xjno | KR0015 | 2024-01-18T14:15:01.964Z | 2024-01-24T14:19:17.524Z |
3837700 | 3837700 | 20240115211327_4DVv9 | KR0015 | 2024-01-18T14:14:46.231Z | 2024-01-24T14:19:16.503Z |
3837604 | 3837604 | 20240115210438_cfUG3 | KR0015 | 2024-01-18T14:14:36.107Z | 2024-01-24T14:19:16.038Z |
3837554 | 3837554 | 20240115210253_RKY6c | KR0015 | 2024-01-18T14:14:32.863Z | 2024-01-24T14:19:14.906Z |
3837393 | 3837393 | 20240115204918_rkyLq | KR0015 | 2024-01-18T14:14:20.523Z | 2024-01-24T14:19:14.131Z |
3836800 | 3836800 | 20240115195347_qqWcP | KR0015 | 2024-01-18T14:13:56.390Z | 2024-01-24T14:19:10.852Z |
3836692 | 3836692 | 20240115194631_22KLY | KR0015 | 2024-01-18T14:13:52.634Z | 2024-01-24T14:19:10.590Z |
3836374 | 3836374 | 20240115191405_cbOyl | KR0015 | 2024-01-18T14:13:25.588Z | 2024-01-24T14:19:08.919Z |
3836078 | 3836078 | 20240115184452_jr1TU | KR0015 | 2024-01-18T14:13:09.678Z | 2024-01-24T14:19:06.752Z |
3835046 | 3835046 | 20240115162150_LzA4q | KR0015 | 2024-01-18T14:11:34.881Z | 2024-01-24T14:19:00.944Z |
3830774 | 3830774 | 20240114214518_CWgkU | KR0015 | 2024-01-17T14:13:59.559Z | 2024-01-23T14:25:23.518Z |
3830766 | 3830766 | 20240114214355_Kowou | KR0015 | 2024-01-17T14:13:59.225Z | 2024-01-23T14:25:23.499Z |
3830757 | 3830757 | 20240114214137_SPoQ4 | KR0015 | 2024-01-17T14:13:59.091Z | 2024-01-23T14:25:23.497Z |
3830662 | 3830662 | 20240114212417_f1Ykr | KR0015 | 2024-01-17T14:13:53.082Z | 2024-01-23T14:25:22.527Z |
3830617 | 3830617 | 20240114211800_c8FsP | KR0015 | 2024-01-17T14:13:50.408Z | 2024-01-23T14:25:22.308Z |
3830315 | 3830315 | 20240114201025_VGUoA | KR0015 | 2024-01-17T14:13:27.414Z | 2024-01-23T14:25:19.719Z |
3829975 | 3829975 | 20240114191837_21yMc | KR0015 | 2024-01-17T14:13:10.818Z | 2024-01-23T14:25:16.724Z |
3829787 | 3829787 | 20240114185438_KaPwS | KR0015 | 2024-01-17T14:12:58.649Z | 2024-01-23T14:25:15.755Z |
3829556 | 3829556 | 20240114181528_AeCMg | KR0015 | 2024-01-17T14:12:34.781Z | 2024-01-23T14:25:13.864Z |
3829402 | 3829402 | 20240114174340_TMNZt | KR0015 | 2024-01-17T14:12:24.470Z | 2024-01-23T14:25:12.691Z |
3829213 | 3829213 | 20240114170224_uA0hq | KR0015 | 2024-01-17T14:12:10.845Z | 2024-01-23T14:25:11.591Z |
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);