participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,721 rows where station_code = "KR0023" 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 |
---|---|---|---|---|---|
5131410 | 5131410 | 20240915193855_48AMa | KR0023 | 2024-09-19T12:15:01.759Z | 2024-09-19T12:15:01.759Z |
5131352 | 5131352 | 20240915192409_ggZtR | KR0023 | 2024-09-19T12:14:58.408Z | 2024-09-19T12:14:58.408Z |
5131349 | 5131349 | 20240915192253_MYGln | KR0023 | 2024-09-19T12:14:58.242Z | 2024-09-19T12:14:58.242Z |
5124184 | 5124184 | 20240914155621_rKBB1 | KR0023 | 2024-09-18T12:12:10.579Z | 2024-09-19T12:20:18.468Z |
5110878 | 5110878 | 20240914191845_233nG | KR0023 | 2024-09-18T12:01:08.044Z | 2024-09-19T12:18:24.487Z |
5110723 | 5110723 | 20240914181357_5C2Nf | KR0023 | 2024-09-18T12:00:45.783Z | 2024-09-19T12:18:22.945Z |
5110619 | 5110619 | 20240914173732_w05my | KR0023 | 2024-09-18T12:00:34.430Z | 2024-09-19T12:18:21.879Z |
5110565 | 5110565 | 20240914171133_KIwg9 | KR0023 | 2024-09-18T12:00:27.419Z | 2024-09-19T12:18:21.411Z |
5110358 | 5110358 | 20240913153022_V5ji0 | KR0023 | 2024-09-17T12:15:07.283Z | 2024-09-19T12:20:56.845Z |
5098754 | 5098754 | 20240913192029_7GJBE | KR0023 | 2024-09-17T12:01:30.709Z | 2024-09-19T12:19:40.591Z |
5098696 | 5098696 | 20240913190118_KQ26W | KR0023 | 2024-09-17T12:01:22.725Z | 2024-09-19T12:19:40.250Z |
5098547 | 5098547 | 20240913180357_ZHdYk | KR0023 | 2024-09-17T12:00:53.229Z | 2024-09-19T12:19:38.776Z |
5098371 | 5098371 | 20240913163944_gLNbP | KR0023 | 2024-09-17T12:00:22.769Z | 2024-09-19T12:19:36.599Z |
5068597 | 5068597 | 20240910115313_pQt7M | KR0023 | 2024-09-14T12:19:19.048Z | 2024-09-18T12:15:26.357Z |
5063166 | 5063166 | 20240909200820_fhVF3 | KR0023 | 2024-09-14T12:13:36.208Z | 2024-09-18T12:15:13.107Z |
5063059 | 5063059 | 20240909194713_aRn35 | KR0023 | 2024-09-14T12:13:23.328Z | 2024-09-18T12:15:12.940Z |
5063043 | 5063043 | 20240909194305_bNpbE | KR0023 | 2024-09-14T12:13:21.935Z | 2024-09-18T12:15:12.930Z |
5062903 | 5062903 | 20240909185517_s220I | KR0023 | 2024-09-14T12:13:01.843Z | 2024-09-18T12:15:12.479Z |
5062884 | 5062884 | 20240909185236_OuNNa | KR0023 | 2024-09-14T12:13:00.758Z | 2024-09-18T12:15:12.416Z |
5062882 | 5062882 | 20240909185140_bUR3G | KR0023 | 2024-09-14T12:13:00.606Z | 2024-09-18T12:15:12.409Z |
5062856 | 5062856 | 20240909184253_5ZL3h | KR0023 | 2024-09-14T12:12:58.948Z | 2024-09-18T12:15:12.311Z |
5062568 | 5062568 | 20240909174108_9Bo1r | KR0023 | 2024-09-14T12:12:33.716Z | 2024-09-18T12:15:11.497Z |
5062561 | 5062561 | 20240909174101_Vlc1B | KR0023 | 2024-09-14T12:12:33.372Z | 2024-09-18T12:15:11.463Z |
5062496 | 5062496 | 20240909173354_n31R0 | KR0023 | 2024-09-14T12:12:28.129Z | 2024-09-18T12:15:11.400Z |
5062147 | 5062147 | 20240909165058_gvOrA | KR0023 | 2024-09-14T12:11:52.361Z | 2024-09-18T12:15:10.438Z |
5061847 | 5061847 | 20240909160939_kck8p | KR0023 | 2024-09-14T12:11:32.283Z | 2024-09-18T12:15:10.062Z |
5061628 | 5061628 | 20240909153038_33uxb | KR0023 | 2024-09-14T12:11:02.946Z | 2024-09-18T12:15:09.776Z |
5061501 | 5061501 | 20240909151617_DUjx5 | KR0023 | 2024-09-14T12:10:53.230Z | 2024-09-18T12:15:09.449Z |
5061382 | 5061382 | 20240909145840_F3FxH | KR0023 | 2024-09-14T12:10:45.477Z | 2024-09-18T12:15:09.077Z |
5061323 | 5061323 | 20240909144619_5M15G | KR0023 | 2024-09-14T12:10:42.109Z | 2024-09-18T12:15:08.920Z |
5061073 | 5061073 | 20240909140520_oJODX | KR0023 | 2024-09-14T12:10:13.408Z | 2024-09-18T12:15:08.018Z |
5058788 | 5058788 | 20240910164640_T5d5x | KR0023 | 2024-09-14T12:04:32.145Z | 2024-09-19T12:21:30.099Z |
5058745 | 5058745 | 20240910164043_Btc1d | KR0023 | 2024-09-14T12:04:26.021Z | 2024-09-19T12:21:29.940Z |
5058177 | 5058177 | 20240910155010_YXx1b | KR0023 | 2024-09-14T12:03:05.723Z | 2024-09-19T12:21:29.257Z |
5057924 | 5057924 | 20240910152625_VE6Cs | KR0023 | 2024-09-14T12:02:25.713Z | 2024-09-19T12:21:28.951Z |
5057882 | 5057882 | 20240910152149_vk2Ck | KR0023 | 2024-09-14T12:02:19.096Z | 2024-09-19T12:21:28.881Z |
5057405 | 5057405 | 20240910142311_Ctdq0 | KR0023 | 2024-09-14T12:01:00.340Z | 2024-09-19T12:21:27.750Z |
5057350 | 5057350 | 20240910141335_6siN6 | KR0023 | 2024-09-14T12:00:54.077Z | 2024-09-19T12:21:27.609Z |
5057192 | 5057192 | 20240910135717_bvb8K | KR0023 | 2024-09-14T12:00:28.807Z | 2024-09-19T12:21:27.251Z |
5044445 | 5044445 | 20240908150258_9L2FC | KR0023 | 2024-09-13T12:02:12.162Z | 2024-09-17T12:18:54.399Z |
5044181 | 5044181 | 20240908142257_lyg6f | KR0023 | 2024-09-13T12:01:37.574Z | 2024-09-17T12:18:53.639Z |
5044007 | 5044007 | 20240908135148_5Y1Ho | KR0023 | 2024-09-13T12:01:14.737Z | 2024-09-17T12:18:53.302Z |
5043211 | 5043211 | 20240907140749_VcfPw | KR0023 | 2024-09-12T12:17:25.315Z | 2024-09-16T12:20:55.896Z |
5018728 | 5018728 | 20240904195657_nDxoF | KR0023 | 2024-09-10T12:11:27.072Z | 2024-09-13T12:19:48.603Z |
5018704 | 5018704 | 20240904194654_u4rf3 | KR0023 | 2024-09-10T12:11:20.170Z | 2024-09-13T12:19:48.561Z |
5018684 | 5018684 | 20240904193203_KTJHT | KR0023 | 2024-09-10T12:11:13.083Z | 2024-09-13T12:19:48.525Z |
5018619 | 5018619 | 20240904191255_3RI83 | KR0023 | 2024-09-10T12:10:59.622Z | 2024-09-13T12:19:48.327Z |
5018547 | 5018547 | 20240904184640_0WP1t | KR0023 | 2024-09-10T12:10:50.334Z | 2024-09-13T12:19:48.146Z |
5018508 | 5018508 | 20240904182906_cYE6E | KR0023 | 2024-09-10T12:10:44.788Z | 2024-09-13T12:19:47.994Z |
5018495 | 5018495 | 20240904182721_wt8rG | KR0023 | 2024-09-10T12:10:43.156Z | 2024-09-13T12:19:47.968Z |
5018482 | 5018482 | 20240904182055_ZuA6k | KR0023 | 2024-09-10T12:10:41.898Z | 2024-09-13T12:19:47.954Z |
5018467 | 5018467 | 20240904181521_gIt8c | KR0023 | 2024-09-10T12:10:40.509Z | 2024-09-13T12:19:47.941Z |
5018430 | 5018430 | 20240904180620_2lTDh | KR0023 | 2024-09-10T12:10:36.891Z | 2024-09-13T12:19:47.883Z |
5018427 | 5018427 | 20240904180419_nTdNm | KR0023 | 2024-09-10T12:10:36.471Z | 2024-09-13T12:19:47.882Z |
5017957 | 5017957 | 20240904165843_y6oBN | KR0023 | 2024-09-10T12:09:47.422Z | 2024-09-13T12:19:47.141Z |
5017922 | 5017922 | 20240904165335_4tNQC | KR0023 | 2024-09-10T12:09:45.341Z | 2024-09-13T12:19:47.131Z |
5017447 | 5017447 | 20240904160911_u2L2F | KR0023 | 2024-09-10T12:09:11.038Z | 2024-09-13T12:19:46.887Z |
5017306 | 5017306 | 20240904155521_Z2kez | KR0023 | 2024-09-10T12:09:03.021Z | 2024-09-13T12:19:46.763Z |
5016396 | 5016396 | 20240904141220_oW2Xt | KR0023 | 2024-09-10T12:07:47.056Z | 2024-09-13T12:19:45.666Z |
5007104 | 5007104 | 20240903195747_HbgJo | KR0023 | 2024-09-09T12:05:26.336Z | 2024-09-12T12:19:11.362Z |
5006921 | 5006921 | 20240903193003_TTBPW | KR0023 | 2024-09-09T12:05:13.144Z | 2024-09-12T12:19:10.861Z |
5006890 | 5006890 | 20240903192156_d2j8g | KR0023 | 2024-09-09T12:05:11.165Z | 2024-09-12T12:19:10.789Z |
5006761 | 5006761 | 20240903185029_Eycqh | KR0023 | 2024-09-09T12:05:00.040Z | 2024-09-12T12:19:09.426Z |
5006718 | 5006718 | 20240903183759_soTvm | KR0023 | 2024-09-09T12:04:57.159Z | 2024-09-12T12:19:09.308Z |
5005713 | 5005713 | 20240903160010_2259S | KR0023 | 2024-09-09T12:03:56.764Z | 2024-09-12T12:19:06.501Z |
5005443 | 5005443 | 20240903151358_5J0Ir | KR0023 | 2024-09-09T12:03:43.020Z | 2024-09-12T12:19:05.949Z |
5005363 | 5005363 | 20240903145905_pMu58 | KR0023 | 2024-09-09T12:03:38.809Z | 2024-09-12T12:19:05.815Z |
5005054 | 5005054 | 20240903135138_DHGW6 | KR0023 | 2024-09-09T12:03:17.744Z | 2024-09-12T12:19:05.186Z |
5004968 | 5004968 | 20240903134030_H0B4V | KR0023 | 2024-09-09T12:03:14.133Z | 2024-09-12T12:19:04.621Z |
5004786 | 5004786 | 20240903123907_I0dk3 | KR0023 | 2024-09-09T12:03:02.504Z | 2024-09-12T12:19:04.101Z |
4987930 | 4987930 | 20240901192038_IbShc | KR0023 | 2024-09-07T12:06:29.412Z | 2024-09-10T12:19:11.856Z |
4987587 | 4987587 | 20240901180305_mFIqb | KR0023 | 2024-09-07T12:05:58.030Z | 2024-09-10T12:19:11.009Z |
4987491 | 4987491 | 20240901174258_N0IgL | KR0023 | 2024-09-07T12:05:51.271Z | 2024-09-10T12:19:10.871Z |
4985792 | 4985792 | 20240901133344_cFBfM | KR0023 | 2024-09-07T12:03:46.732Z | 2024-09-10T12:19:08.351Z |
4962883 | 4962883 | 20240811193001_Zw3ar | KR0023 | 2024-09-04T12:04:57.604Z | 2024-09-06T12:04:10.171Z |
4962832 | 4962832 | 20240811192636_40a79 | KR0023 | 2024-09-04T12:04:54.853Z | 2024-09-06T12:04:08.102Z |
4962725 | 4962725 | 20240811191848_UNBxW | KR0023 | 2024-09-04T12:04:48.903Z | 2024-09-06T12:03:59.969Z |
4962671 | 4962671 | 20240811191559_R3kZ1 | KR0023 | 2024-09-04T12:04:46.594Z | 2024-09-06T12:03:55.772Z |
4962605 | 4962605 | 20240811191156_rjRjp | KR0023 | 2024-09-04T12:04:43.338Z | 2024-09-06T12:03:53.331Z |
4962585 | 4962585 | 20240811191039_RnDsL | KR0023 | 2024-09-04T12:04:42.345Z | 2024-09-06T12:03:52.493Z |
4962566 | 4962566 | 20240811190920_ch9lF | KR0023 | 2024-09-04T12:04:38.926Z | 2024-09-06T12:03:51.538Z |
4962497 | 4962497 | 20240811190252_XfOIT | KR0023 | 2024-09-04T12:04:35.722Z | 2024-09-06T12:03:48.692Z |
4962383 | 4962383 | 20240811185225_tqDbA | KR0023 | 2024-09-04T12:04:27.714Z | 2024-09-06T12:03:44.127Z |
4962371 | 4962371 | 20240811185200_3oPsM | KR0023 | 2024-09-04T12:04:27.168Z | 2024-09-06T12:03:43.639Z |
4962339 | 4962339 | 20240811184955_jPdhX | KR0023 | 2024-09-04T12:04:26.005Z | 2024-09-06T12:03:42.664Z |
4962334 | 4962334 | 20240811184930_McAvl | KR0023 | 2024-09-04T12:04:25.856Z | 2024-09-06T12:03:42.507Z |
4962282 | 4962282 | 20240811184618_UKP3O | KR0023 | 2024-09-04T12:04:23.800Z | 2024-09-06T12:03:38.957Z |
4962208 | 4962208 | 20240811184138_quX4q | KR0023 | 2024-09-04T12:04:21.051Z | 2024-09-06T12:03:33.536Z |
4962197 | 4962197 | 20240811184116_Dmsz2 | KR0023 | 2024-09-04T12:04:20.705Z | 2024-09-06T12:03:33.177Z |
4962177 | 4962177 | 20240811183925_Oy2zI | KR0023 | 2024-09-04T12:04:19.929Z | 2024-09-06T12:03:32.387Z |
4962158 | 4962158 | 20240811183823_tebr0 | KR0023 | 2024-09-04T12:04:19.210Z | 2024-09-06T12:03:31.836Z |
4962017 | 4962017 | 20240811182634_7Kn27 | KR0023 | 2024-09-04T12:04:11.816Z | 2024-09-06T12:03:24.191Z |
4961975 | 4961975 | 20240811182114_1WiL6 | KR0023 | 2024-09-04T12:04:06.351Z | 2024-09-06T12:03:22.192Z |
4961965 | 4961965 | 20240811182102_Gs3VS | KR0023 | 2024-09-04T12:04:06.034Z | 2024-09-06T12:03:21.925Z |
4961941 | 4961941 | 20240811181821_8umiq | KR0023 | 2024-09-04T12:04:05.022Z | 2024-09-06T12:03:21.237Z |
4961907 | 4961907 | 20240811181543_n26J4 | KR0023 | 2024-09-04T12:04:03.282Z | 2024-09-06T12:03:19.715Z |
4961887 | 4961887 | 20240811181235_DbXGX | KR0023 | 2024-09-04T12:04:02.254Z | 2024-09-06T12:03:18.809Z |
4961840 | 4961840 | 20240811180852_r5Wvv | KR0023 | 2024-09-04T12:03:57.929Z | 2024-09-06T12:03:16.679Z |
4961729 | 4961729 | 20240811175911_2sbOL | KR0023 | 2024-09-04T12:03:52.401Z | 2024-09-06T12:03:11.938Z |
4961286 | 4961286 | 20240811172933_cDomk | KR0023 | 2024-09-04T12:03:27.032Z | 2024-09-06T12:02:51.018Z |
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);