participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,675 rows where station_code = "KR0011" 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 |
---|---|---|---|---|---|
5044501 | 5044501 | 20240908150717_dq5fi | KR0011 | 2024-09-13T12:02:17.043Z | 2024-09-17T12:18:54.528Z |
5043833 | 5043833 | 20240908131931_aTWXt | KR0011 | 2024-09-13T12:00:47.187Z | 2024-09-17T12:18:52.934Z |
5043544 | 5043544 | 20240907112527_bP567 | KR0011 | 2024-09-12T12:17:36.346Z | 2024-09-15T12:21:42.065Z |
5042741 | 5042741 | 20240907123521_oWXWb | KR0011 | 2024-09-12T12:17:17.814Z | 2024-09-16T12:20:54.068Z |
5042734 | 5042734 | 20240907123331_2hum5 | KR0011 | 2024-09-12T12:17:17.742Z | 2024-09-16T12:20:54.052Z |
5042714 | 5042714 | 20240907122954_7UkYj | KR0011 | 2024-09-12T12:17:17.026Z | 2024-09-16T12:20:53.967Z |
4896003 | 4896003 | 20240807140010_myjzh | KR0011 | 2024-08-28T12:13:55.212Z | 2024-08-28T12:13:55.212Z |
4895765 | 4895765 | 20240807131942_3QweO | KR0011 | 2024-08-28T12:13:37.844Z | 2024-08-28T12:13:37.844Z |
4849777 | 4849777 | 20240805180506_wpD9a | KR0011 | 2024-08-17T12:12:16.039Z | 2024-08-19T12:22:30.833Z |
4849725 | 4849725 | 20240805180242_IglFB | KR0011 | 2024-08-17T12:12:09.543Z | 2024-08-19T12:22:27.459Z |
4849080 | 4849080 | 20240805173314_XC7kJ | KR0011 | 2024-08-17T12:11:19.064Z | 2024-08-19T12:21:53.387Z |
4849049 | 4849049 | 20240805173140_oPPmV | KR0011 | 2024-08-17T12:11:17.223Z | 2024-08-19T12:21:52.273Z |
4673750 | 4673750 | 20240719123959_vZe1d | KR0011 | 2024-07-21T12:08:13.865Z | 2024-07-27T12:17:29.240Z |
4519289 | 4519289 | 20240628184729_2SF4F | KR0011 | 2024-06-30T12:02:46.288Z | 2024-07-07T12:13:44.803Z |
4519094 | 4519094 | 20240628181710_vR5JJ | KR0011 | 2024-06-30T12:02:30.682Z | 2024-07-07T12:13:44.610Z |
4519015 | 4519015 | 20240628180151_2acwW | KR0011 | 2024-06-30T12:02:26.644Z | 2024-07-07T12:13:44.534Z |
4518993 | 4518993 | 20240628180028_onXZd | KR0011 | 2024-06-30T12:02:25.937Z | 2024-07-07T12:13:44.527Z |
4518913 | 4518913 | 20240628174720_GMLDo | KR0011 | 2024-06-30T12:02:21.528Z | 2024-07-07T12:13:44.447Z |
4518767 | 4518767 | 20240628172620_H5FNs | KR0011 | 2024-06-30T12:02:11.915Z | 2024-07-07T12:13:44.360Z |
4518689 | 4518689 | 20240628171543_cGhBV | KR0011 | 2024-06-30T12:02:03.919Z | 2024-07-07T12:13:44.299Z |
4518521 | 4518521 | 20240628164552_OOyd2 | KR0011 | 2024-06-30T12:01:54.006Z | 2024-07-07T12:13:44.158Z |
4518380 | 4518380 | 20240628161642_ENhsG | KR0011 | 2024-06-30T12:01:44.546Z | 2024-07-07T12:13:43.995Z |
4518159 | 4518159 | 20240628154705_3GDaL | KR0011 | 2024-06-30T12:01:24.843Z | 2024-07-07T12:13:42.907Z |
4518035 | 4518035 | 20240628152828_ejXq4 | KR0011 | 2024-06-30T12:01:16.495Z | 2024-07-07T12:13:42.099Z |
4517797 | 4517797 | 20240628145517_mecdz | KR0011 | 2024-06-30T12:00:56.968Z | 2024-07-07T12:13:41.776Z |
4517750 | 4517750 | 20240628144914_Twf2V | KR0011 | 2024-06-30T12:00:53.900Z | 2024-07-07T12:13:41.745Z |
4517656 | 4517656 | 20240628143447_3v3md | KR0011 | 2024-06-30T12:00:46.751Z | 2024-07-07T12:13:41.441Z |
4512930 | 4512930 | 20240627182500_2T2y3 | KR0011 | 2024-06-29T12:04:27.296Z | 2024-07-06T12:16:14.558Z |
4512806 | 4512806 | 20240627180646_VvJ22 | KR0011 | 2024-06-29T12:04:18.108Z | 2024-07-06T12:16:14.170Z |
4512679 | 4512679 | 20240627175213_b0Op4 | KR0011 | 2024-06-29T12:04:12.571Z | 2024-07-06T12:16:13.983Z |
4507266 | 4507266 | 20240627165747_zm2SM | KR0011 | 2024-06-28T12:01:15.628Z | 2024-07-06T12:16:13.070Z |
4507263 | 4507263 | 20240627165707_sYvMl | KR0011 | 2024-06-28T12:01:15.360Z | 2024-07-06T12:16:13.065Z |
4507242 | 4507242 | 20240627164853_JBxpC | KR0011 | 2024-06-28T12:01:13.533Z | 2024-07-06T12:16:12.664Z |
4507195 | 4507195 | 20240627163230_DACUE | KR0011 | 2024-06-28T12:01:10.452Z | 2024-07-06T12:16:12.334Z |
4507171 | 4507171 | 20240627162316_D4PVY | KR0011 | 2024-06-28T12:01:08.206Z | 2024-07-06T12:16:12.269Z |
4507070 | 4507070 | 20240627155401_cYVUI | KR0011 | 2024-06-28T12:01:02.459Z | 2024-07-06T12:16:12.069Z |
4507033 | 4507033 | 20240627154347_Ll39P | KR0011 | 2024-06-28T12:01:00.259Z | 2024-07-06T12:16:11.984Z |
4507014 | 4507014 | 20240627154030_XZJT0 | KR0011 | 2024-06-28T12:00:59.238Z | 2024-07-06T12:16:11.807Z |
4506732 | 4506732 | 20240627142151_gYm2U | KR0011 | 2024-06-28T12:00:37.676Z | 2024-07-06T12:16:09.944Z |
4506667 | 4506667 | 20240627140507_f2iQ8 | KR0011 | 2024-06-28T12:00:33.148Z | 2024-07-06T12:16:09.704Z |
4506528 | 4506528 | 20240627131811_OyaQo | KR0011 | 2024-06-28T12:00:22.178Z | 2024-07-06T12:16:09.132Z |
4498699 | 4498699 | 20240625180244_0SPMT | KR0011 | 2024-06-26T12:01:05.604Z | 2024-07-04T12:08:45.930Z |
4498691 | 4498691 | 20240625180206_5k255 | KR0011 | 2024-06-26T12:01:05.264Z | 2024-07-04T12:08:45.929Z |
4498687 | 4498687 | 20240625180129_JWFQ7 | KR0011 | 2024-06-26T12:01:04.988Z | 2024-07-04T12:08:45.924Z |
4498677 | 4498677 | 20240625173433_wY3bG | KR0011 | 2024-06-26T12:01:03.537Z | 2024-07-04T12:08:45.880Z |
4498651 | 4498651 | 20240625171733_oCgv4 | KR0011 | 2024-06-26T12:01:00.243Z | 2024-07-04T12:08:45.640Z |
4498414 | 4498414 | 20240625133421_cMtu3 | KR0011 | 2024-06-26T12:00:29.240Z | 2024-07-04T12:08:44.474Z |
4487744 | 4487744 | 20240619184238_wVylw | KR0011 | 2024-06-21T12:04:20.423Z | 2024-06-28T12:09:34.406Z |
4487698 | 4487698 | 20240619183250_t6PUI | KR0011 | 2024-06-21T12:04:15.261Z | 2024-06-28T12:09:34.312Z |
4487651 | 4487651 | 20240619182608_0LfB4 | KR0011 | 2024-06-21T12:04:12.887Z | 2024-06-28T12:09:34.171Z |
4487598 | 4487598 | 20240619182108_DseOg | KR0011 | 2024-06-21T12:04:10.371Z | 2024-06-28T12:09:34.013Z |
4487495 | 4487495 | 20240619175505_ETZPJ | KR0011 | 2024-06-21T12:04:04.882Z | 2024-06-28T12:09:33.760Z |
4487448 | 4487448 | 20240619175008_Y2T8s | KR0011 | 2024-06-21T12:04:01.933Z | 2024-06-28T12:09:33.625Z |
4487133 | 4487133 | 20240619162611_S46kU | KR0011 | 2024-06-21T12:03:28.883Z | 2024-06-28T12:09:32.656Z |
4474185 | 4474185 | 20240616173536_Kvlwg | KR0011 | 2024-06-18T12:04:56.027Z | 2024-06-24T12:11:39.826Z |
4474171 | 4474171 | 20240616173136_sjZnR | KR0011 | 2024-06-18T12:04:54.661Z | 2024-06-24T12:11:39.493Z |
4474138 | 4474138 | 20240616172539_LVZ9g | KR0011 | 2024-06-18T12:04:52.136Z | 2024-06-24T12:11:39.190Z |
4474059 | 4474059 | 20240616171034_pYUa3 | KR0011 | 2024-06-18T12:04:46.831Z | 2024-06-24T12:11:37.953Z |
4474033 | 4474033 | 20240616170536_O3kc2 | KR0011 | 2024-06-18T12:04:45.581Z | 2024-06-24T12:11:37.732Z |
4473991 | 4473991 | 20240616165709_JOH1l | KR0011 | 2024-06-18T12:04:43.404Z | 2024-06-24T12:11:37.105Z |
4473929 | 4473929 | 20240616164512_vQWlU | KR0011 | 2024-06-18T12:04:39.533Z | 2024-06-24T12:11:35.223Z |
4473899 | 4473899 | 20240616164122_g4Ha4 | KR0011 | 2024-06-18T12:04:37.798Z | 2024-06-24T12:11:35.019Z |
4473756 | 4473756 | 20240616154447_U1WD6 | KR0011 | 2024-06-18T12:04:25.133Z | 2024-06-24T12:11:32.545Z |
4473517 | 4473517 | 20240616140150_arypu | KR0011 | 2024-06-18T12:04:06.027Z | 2024-06-24T12:11:28.878Z |
4473350 | 4473350 | 20240616123154_u8hQU | KR0011 | 2024-06-18T12:03:50.091Z | 2024-06-24T12:11:26.760Z |
4463156 | 4463156 | 20240613185048_5zxWc | KR0011 | 2024-06-15T12:09:31.137Z | 2024-06-21T12:11:48.079Z |
4463143 | 4463143 | 20240613184639_sPwzK | KR0011 | 2024-06-15T12:09:30.102Z | 2024-06-21T12:11:48.064Z |
4463110 | 4463110 | 20240613184113_1CC16 | KR0011 | 2024-06-15T12:09:26.819Z | 2024-06-21T12:11:47.892Z |
4463074 | 4463074 | 20240613183545_4npMm | KR0011 | 2024-06-15T12:09:24.848Z | 2024-06-21T12:11:47.873Z |
4463041 | 4463041 | 20240613183257_hZ3AS | KR0011 | 2024-06-15T12:09:23.682Z | 2024-06-21T12:11:47.842Z |
4463026 | 4463026 | 20240613183157_xVgOo | KR0011 | 2024-06-15T12:09:23.285Z | 2024-06-21T12:11:47.802Z |
4462981 | 4462981 | 20240613181730_2MCDI | KR0011 | 2024-06-15T12:09:20.720Z | 2024-06-21T12:11:47.716Z |
4462918 | 4462918 | 20240613181008_uUvFW | KR0011 | 2024-06-15T12:09:17.197Z | 2024-06-21T12:11:47.637Z |
4462881 | 4462881 | 20240613180222_a3N9c | KR0011 | 2024-06-15T12:09:14.794Z | 2024-06-21T12:11:47.538Z |
4462839 | 4462839 | 20240613175646_gS2Oz | KR0011 | 2024-06-15T12:09:12.770Z | 2024-06-21T12:11:47.516Z |
4462785 | 4462785 | 20240613174535_j6Ab2 | KR0011 | 2024-06-15T12:09:09.264Z | 2024-06-21T12:11:47.442Z |
4462694 | 4462694 | 20240613173038_uRY6I | KR0011 | 2024-06-15T12:09:04.680Z | 2024-06-21T12:11:47.341Z |
4462613 | 4462613 | 20240613172309_rIBPN | KR0011 | 2024-06-15T12:08:58.032Z | 2024-06-21T12:11:47.241Z |
4462596 | 4462596 | 20240613171954_4xqhG | KR0011 | 2024-06-15T12:08:55.259Z | 2024-06-21T12:11:47.216Z |
4462584 | 4462584 | 20240613171915_0rjWf | KR0011 | 2024-06-15T12:08:54.535Z | 2024-06-21T12:11:47.210Z |
4462578 | 4462578 | 20240613171655_EbR6F | KR0011 | 2024-06-15T12:08:53.905Z | 2024-06-21T12:11:47.208Z |
4462531 | 4462531 | 20240613170940_m6hvY | KR0011 | 2024-06-15T12:08:48.909Z | 2024-06-21T12:11:47.168Z |
4462475 | 4462475 | 20240613170203_th13U | KR0011 | 2024-06-15T12:08:43.207Z | 2024-06-21T12:11:46.989Z |
4462374 | 4462374 | 20240613164536_VVIzl | KR0011 | 2024-06-15T12:08:34.092Z | 2024-06-21T12:11:46.860Z |
4462327 | 4462327 | 20240613163326_Tjiut | KR0011 | 2024-06-15T12:08:27.876Z | 2024-06-21T12:11:46.734Z |
4462260 | 4462260 | 20240613162517_mg1eo | KR0011 | 2024-06-15T12:08:21.655Z | 2024-06-21T12:11:46.516Z |
4462142 | 4462142 | 20240613160511_IUJj5 | KR0011 | 2024-06-15T12:08:09.826Z | 2024-06-21T12:11:46.366Z |
4462003 | 4462003 | 20240613152927_OviIZ | KR0011 | 2024-06-15T12:07:58.085Z | 2024-06-21T12:11:46.160Z |
4461919 | 4461919 | 20240613145555_twcnE | KR0011 | 2024-06-15T12:07:50.015Z | 2024-06-21T12:11:45.711Z |
4461906 | 4461906 | 20240613145145_1bI97 | KR0011 | 2024-06-15T12:07:48.938Z | 2024-06-21T12:11:45.689Z |
4461888 | 4461888 | 20240613144617_sKWiy | KR0011 | 2024-06-15T12:07:47.665Z | 2024-06-21T12:11:45.667Z |
4461813 | 4461813 | 20240613142043_Ar3QK | KR0011 | 2024-06-15T12:07:40.036Z | 2024-06-21T12:11:45.429Z |
4461540 | 4461540 | 20240613122946_C7HPV | KR0011 | 2024-06-15T12:07:08.098Z | 2024-06-21T12:11:44.414Z |
4447957 | 4447957 | 20240610162324_oVaRN | KR0011 | 2024-06-12T12:06:00.571Z | 2024-06-18T12:11:15.990Z |
4415650 | 4415650 | 20240604183454_zmUsi | KR0011 | 2024-06-06T12:05:10.081Z | 2024-06-13T12:08:30.166Z |
4415551 | 4415551 | 20240604182304_0Nwg2 | KR0011 | 2024-06-06T12:04:53.525Z | 2024-06-13T12:08:30.062Z |
4415547 | 4415547 | 20240604182207_ghz9S | KR0011 | 2024-06-06T12:04:53.089Z | 2024-06-13T12:08:30.053Z |
4415200 | 4415200 | 20240604172832_0UMgD | KR0011 | 2024-06-06T12:04:25.655Z | 2024-06-13T12:08:29.755Z |
4415077 | 4415077 | 20240604171014_Yldhv | KR0011 | 2024-06-06T12:04:17.596Z | 2024-06-13T12:08:29.688Z |
4414923 | 4414923 | 20240604164654_6uyBn | KR0011 | 2024-06-06T12:03:53.037Z | 2024-06-13T12:08:29.546Z |
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);