participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
760 rows where station_code = "KR001L" 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 |
---|---|---|---|---|---|
5487276 | 5487276 | 20241106152822_cj284 | KR001L | 2024-11-07T14:05:26.534Z | 2024-11-15T14:24:38.729Z |
5131577 | 5131577 | 20240915202019_MTazI | KR001L | 2024-09-19T12:15:10.027Z | 2024-09-24T12:15:34.999Z |
5131260 | 5131260 | 20240915185715_nfopt | KR001L | 2024-09-19T12:14:48.705Z | 2024-09-24T12:15:32.149Z |
5131150 | 5131150 | 20240915180956_ZEuAF | KR001L | 2024-09-19T12:14:30.011Z | 2024-09-24T12:15:31.515Z |
5131130 | 5131130 | 20240915175957_0OjR8 | KR001L | 2024-09-19T12:14:27.671Z | 2024-09-24T12:15:31.351Z |
5098720 | 5098720 | 20240913190849_SYd7W | KR001L | 2024-09-17T12:01:25.391Z | 2024-09-22T12:17:43.283Z |
5098658 | 5098658 | 20240913185114_pIW8L | KR001L | 2024-09-17T12:01:14.540Z | 2024-09-22T12:17:42.639Z |
5098637 | 5098637 | 20240913184638_Ufy1T | KR001L | 2024-09-17T12:01:11.523Z | 2024-09-22T12:17:42.476Z |
5098503 | 5098503 | 20240913174259_qXmEA | KR001L | 2024-09-17T12:00:46.828Z | 2024-09-22T12:17:40.984Z |
5098428 | 5098428 | 20240913171043_XxOxm | KR001L | 2024-09-17T12:00:32.919Z | 2024-09-22T12:17:40.153Z |
5098420 | 5098420 | 20240913170723_Txuk4 | KR001L | 2024-09-17T12:00:31.847Z | 2024-09-22T12:17:39.964Z |
5098308 | 5098308 | 20240913154537_EzYJn | KR001L | 2024-09-17T12:00:07.843Z | 2024-09-22T12:17:37.805Z |
4962888 | 4962888 | 20240811193021_tTYME | KR001L | 2024-09-04T12:04:57.732Z | 2024-09-06T12:04:10.316Z |
4962700 | 4962700 | 20240811191644_8gIDD | KR001L | 2024-09-04T12:04:47.834Z | 2024-09-06T12:03:58.480Z |
4962687 | 4962687 | 20240811191639_3itnt | KR001L | 2024-09-04T12:04:47.504Z | 2024-09-06T12:03:57.703Z |
4962609 | 4962609 | 20240811191221_l3Uv0 | KR001L | 2024-09-04T12:04:43.459Z | 2024-09-06T12:03:53.419Z |
4962424 | 4962424 | 20240811185541_LKXrT | KR001L | 2024-09-04T12:04:29.955Z | 2024-09-06T12:03:45.877Z |
4962396 | 4962396 | 20240811185320_RKLpe | KR001L | 2024-09-04T12:04:28.713Z | 2024-09-06T12:03:44.803Z |
4961800 | 4961800 | 20240811180554_HJawz | KR001L | 2024-09-04T12:03:56.403Z | 2024-09-06T12:03:15.498Z |
4961735 | 4961735 | 20240811175939_2O8ZP | KR001L | 2024-09-04T12:03:52.801Z | 2024-09-06T12:03:12.254Z |
4961620 | 4961620 | 20240811175238_aHZZC | KR001L | 2024-09-04T12:03:47.455Z | 2024-09-06T12:03:07.672Z |
4960625 | 4960625 | 20240811163914_9mNum | KR001L | 2024-09-04T12:02:47.310Z | 2024-09-06T12:02:20.020Z |
4960471 | 4960471 | 20240811162705_p92IH | KR001L | 2024-09-04T12:02:34.371Z | 2024-09-06T12:02:10.799Z |
4960158 | 4960158 | 20240811160530_kDbiu | KR001L | 2024-09-04T12:02:16.065Z | 2024-09-06T12:01:55.724Z |
4960023 | 4960023 | 20240811155715_96Fwp | KR001L | 2024-09-04T12:02:07.848Z | 2024-09-06T12:01:48.016Z |
4960001 | 4960001 | 20240811155552_KKD12 | KR001L | 2024-09-04T12:02:06.695Z | 2024-09-06T12:01:46.980Z |
4935075 | 4935075 | 20240810193430_Fy58f | KR001L | 2024-09-01T12:06:03.446Z | 2024-09-06T12:20:26.671Z |
4935006 | 4935006 | 20240810192730_K3pne | KR001L | 2024-09-01T12:06:00.802Z | 2024-09-06T12:20:25.446Z |
4934889 | 4934889 | 20240810191448_Zl0QW | KR001L | 2024-09-01T12:05:54.536Z | 2024-09-06T12:20:22.880Z |
4934839 | 4934839 | 20240810191010_5YCQL | KR001L | 2024-09-01T12:05:52.385Z | 2024-09-06T12:20:21.975Z |
4934806 | 4934806 | 20240810190700_3tPsp | KR001L | 2024-09-01T12:05:48.966Z | 2024-09-06T12:20:20.966Z |
4934757 | 4934757 | 20240810185540_fkKzE | KR001L | 2024-09-01T12:05:45.798Z | 2024-09-06T12:20:19.777Z |
4934679 | 4934679 | 20240810184752_Zk74q | KR001L | 2024-09-01T12:05:38.707Z | 2024-09-06T12:20:17.790Z |
4934567 | 4934567 | 20240810183148_f6nAk | KR001L | 2024-09-01T12:05:31.563Z | 2024-09-06T12:20:15.026Z |
4934540 | 4934540 | 20240810182724_jEcdS | KR001L | 2024-09-01T12:05:29.710Z | 2024-09-06T12:20:14.251Z |
4934391 | 4934391 | 20240810181031_ZychE | KR001L | 2024-09-01T12:05:15.669Z | 2024-09-06T12:20:10.646Z |
4934263 | 4934263 | 20240810180048_iPSQ5 | KR001L | 2024-09-01T12:05:06.355Z | 2024-09-06T12:20:07.202Z |
4933738 | 4933738 | 20240810172432_gIVq8 | KR001L | 2024-09-01T12:04:36.078Z | 2024-09-06T12:19:32.438Z |
4933261 | 4933261 | 20240810165312_kWEKS | KR001L | 2024-09-01T12:04:06.049Z | 2024-09-06T12:19:03.076Z |
4897851 | 4897851 | 20240807194129_N3xJP | KR001L | 2024-08-28T12:16:02.193Z | 2024-08-28T12:16:02.193Z |
4897765 | 4897765 | 20240807192432_OlYUb | KR001L | 2024-08-28T12:15:51.340Z | 2024-08-28T12:15:51.340Z |
4897699 | 4897699 | 20240807191114_dxFsZ | KR001L | 2024-08-28T12:15:48.178Z | 2024-08-28T12:15:48.178Z |
4897543 | 4897543 | 20240807182449_7heg9 | KR001L | 2024-08-28T12:15:34.000Z | 2024-08-28T12:15:34.000Z |
4897456 | 4897456 | 20240807180648_JHuo3 | KR001L | 2024-08-28T12:15:29.804Z | 2024-08-28T12:15:29.804Z |
4897408 | 4897408 | 20240807175902_n3nXU | KR001L | 2024-08-28T12:15:28.036Z | 2024-08-28T12:15:28.036Z |
4897321 | 4897321 | 20240807174443_l2S7j | KR001L | 2024-08-28T12:15:23.923Z | 2024-08-28T12:15:23.923Z |
4897150 | 4897150 | 20240807171743_OTW2C | KR001L | 2024-08-28T12:15:11.467Z | 2024-08-28T12:15:11.467Z |
4897118 | 4897118 | 20240807171122_Zonjv | KR001L | 2024-08-28T12:15:07.186Z | 2024-08-28T12:15:07.186Z |
4897044 | 4897044 | 20240807170209_ggzlj | KR001L | 2024-08-28T12:15:01.227Z | 2024-08-28T12:15:01.227Z |
4896890 | 4896890 | 20240807163732_kcu3l | KR001L | 2024-08-28T12:14:51.237Z | 2024-08-28T12:14:51.237Z |
4896781 | 4896781 | 20240807161842_hLDo3 | KR001L | 2024-08-28T12:14:45.860Z | 2024-08-28T12:14:45.860Z |
4896779 | 4896779 | 20240807161830_hYKKp | KR001L | 2024-08-28T12:14:45.727Z | 2024-08-28T12:14:45.727Z |
4888966 | 4888966 | 20240808192510_q81mt | KR001L | 2024-08-28T12:05:25.712Z | 2024-08-30T12:18:45.179Z |
4888836 | 4888836 | 20240808185943_NnGYp | KR001L | 2024-08-28T12:05:11.659Z | 2024-08-30T12:18:40.034Z |
4888780 | 4888780 | 20240808184434_9vKM8 | KR001L | 2024-08-28T12:05:07.745Z | 2024-08-30T12:18:37.892Z |
4888670 | 4888670 | 20240808182905_2HhY6 | KR001L | 2024-08-28T12:04:57.116Z | 2024-08-30T12:18:32.618Z |
4870010 | 4870010 | 20240806174110_xVUJD | KR001L | 2024-08-19T12:07:28.459Z | 2024-08-27T12:08:27.517Z |
4849126 | 4849126 | 20240805173509_H6zVG | KR001L | 2024-08-17T12:11:24.350Z | 2024-08-19T12:21:55.517Z |
4848904 | 4848904 | 20240805172644_zZjSl | KR001L | 2024-08-17T12:11:04.717Z | 2024-08-19T12:21:46.380Z |
4848169 | 4848169 | 20240805165552_zDq1Z | KR001L | 2024-08-17T12:10:16.006Z | 2024-08-19T12:21:14.163Z |
4847149 | 4847149 | 20240805164554_u55te | KR001L | 2024-08-16T12:10:53.020Z | 2024-08-19T12:21:06.877Z |
4821225 | 4821225 | 20240803193232_oGqKK | KR001L | 2024-08-14T12:15:17.576Z | 2024-08-15T12:23:33.104Z |
4821074 | 4821074 | 20240803191748_Bcc7S | KR001L | 2024-08-14T12:15:07.634Z | 2024-08-15T12:23:27.845Z |
4817108 | 4817108 | 20240803183808_Hn2Lz | KR001L | 2024-08-13T12:14:48.737Z | 2024-08-15T12:23:11.656Z |
4816692 | 4816692 | 20240803181323_qRR9Z | KR001L | 2024-08-13T12:14:30.882Z | 2024-08-15T12:23:04.103Z |
4815668 | 4815668 | 20240803171716_5ezDo | KR001L | 2024-08-13T12:13:43.650Z | 2024-08-15T12:22:48.626Z |
4815577 | 4815577 | 20240803171350_uol43 | KR001L | 2024-08-13T12:13:40.306Z | 2024-08-15T12:22:46.557Z |
4814634 | 4814634 | 20240803163503_hUaKK | KR001L | 2024-08-13T12:12:53.529Z | 2024-08-15T12:22:12.470Z |
4813863 | 4813863 | 20240803160211_AK753 | KR001L | 2024-08-13T12:12:23.926Z | 2024-08-15T12:21:45.952Z |
4777921 | 4777921 | 20240801180630_B8dDd | KR001L | 2024-08-07T12:10:58.797Z | 2024-08-11T12:13:24.655Z |
4777870 | 4777870 | 20240801180150_yNv2U | KR001L | 2024-08-07T12:10:57.482Z | 2024-08-11T12:13:23.716Z |
4769018 | 4769018 | 20240731190429_ksNPD | KR001L | 2024-08-06T12:10:27.125Z | 2024-08-10T12:20:20.710Z |
4766953 | 4766953 | 20240731140821_sSFuN | KR001L | 2024-08-06T12:08:53.973Z | 2024-08-10T12:19:34.913Z |
4766950 | 4766950 | 20240731140808_jLuWZ | KR001L | 2024-08-06T12:08:53.898Z | 2024-08-10T12:19:34.630Z |
4766396 | 4766396 | 20240731130022_v43y9 | KR001L | 2024-08-06T12:08:32.554Z | 2024-08-10T12:19:23.221Z |
4755387 | 4755387 | 20240730163422_2n4mc | KR001L | 2024-08-05T12:11:02.169Z | 2024-08-08T12:21:14.089Z |
4754975 | 4754975 | 20240730155235_Prprg | KR001L | 2024-08-05T12:10:34.300Z | 2024-08-08T12:21:06.635Z |
4754761 | 4754761 | 20240730152540_DKUwE | KR001L | 2024-08-05T12:10:15.377Z | 2024-08-08T12:21:02.975Z |
4754426 | 4754426 | 20240730144938_8bhjv | KR001L | 2024-08-05T12:09:45.073Z | 2024-08-08T12:20:57.442Z |
4754037 | 4754037 | 20240730140339_2isp3 | KR001L | 2024-08-05T12:09:09.555Z | 2024-08-08T12:20:51.336Z |
4740322 | 4740322 | 20240729193422_xBrM6 | KR001L | 2024-08-03T12:12:02.620Z | 2024-08-06T12:15:16.616Z |
4738787 | 4738787 | 20240729131924_334Nd | KR001L | 2024-08-03T12:09:16.782Z | 2024-08-06T12:15:11.287Z |
4727009 | 4727009 | 20240728194245_mg58T | KR001L | 2024-07-31T12:12:44.242Z | 2024-08-05T12:20:24.871Z |
4726877 | 4726877 | 20240728190531_LoMtp | KR001L | 2024-07-31T12:12:40.635Z | 2024-08-05T12:20:24.422Z |
4726273 | 4726273 | 20240728165627_sq4Hl | KR001L | 2024-07-31T12:12:16.331Z | 2024-08-05T12:20:23.005Z |
4726254 | 4726254 | 20240728165133_vU743 | KR001L | 2024-07-31T12:12:14.325Z | 2024-08-05T12:20:22.912Z |
4726087 | 4726087 | 20240728160114_NLQcV | KR001L | 2024-07-31T12:12:00.644Z | 2024-08-05T12:20:22.439Z |
4725978 | 4725978 | 20240728153735_AeGvM | KR001L | 2024-07-31T12:11:54.288Z | 2024-08-05T12:20:22.005Z |
4712039 | 4712039 | 20240727191959_j193R | KR001L | 2024-07-29T12:12:39.783Z | 2024-08-04T12:20:05.506Z |
4688990 | 4688990 | 20240724164907_pq6Cq | KR001L | 2024-07-26T12:11:06.712Z | 2024-08-01T12:12:08.338Z |
4688903 | 4688903 | 20240724162549_Jp9JU | KR001L | 2024-07-26T12:11:02.815Z | 2024-08-01T12:12:08.200Z |
4670622 | 4670622 | 20240719190201_gHHLU | KR001L | 2024-07-21T12:01:39.393Z | 2024-07-28T12:14:49.927Z |
4513100 | 4513100 | 20240627191846_h8FQp | KR001L | 2024-06-29T12:04:39.792Z | 2024-07-06T12:16:14.781Z |
4513079 | 4513079 | 20240627190141_5rKlT | KR001L | 2024-06-29T12:04:37.687Z | 2024-07-06T12:16:14.724Z |
4512727 | 4512727 | 20240627175801_SNaxl | KR001L | 2024-06-29T12:04:14.402Z | 2024-07-06T12:16:14.040Z |
4507199 | 4507199 | 20240627163440_AFmpP | KR001L | 2024-06-28T12:01:10.912Z | 2024-07-06T12:16:12.341Z |
4507145 | 4507145 | 20240627161220_it3Hw | KR001L | 2024-06-28T12:01:06.239Z | 2024-07-06T12:16:12.182Z |
4507080 | 4507080 | 20240627155425_0CW1Y | KR001L | 2024-06-28T12:01:02.924Z | 2024-07-06T12:16:12.074Z |
4506711 | 4506711 | 20240627141753_30v32 | KR001L | 2024-06-28T12:00:36.884Z | 2024-07-06T12:16:09.919Z |
4477650 | 4477650 | 20240617182234_Ha9l0 | KR001L | 2024-06-19T12:05:43.089Z | 2024-06-26T12:14:35.317Z |
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);