participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
646 rows where station_code = "KR0021" 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 |
---|---|---|---|---|---|
5124219 | 5124219 | 20240914161943_xO4ry | KR0021 | 2024-09-18T12:12:11.137Z | 2024-09-18T12:12:29.099Z |
5124209 | 5124209 | 20240914161526_hEJlE | KR0021 | 2024-09-18T12:12:11.035Z | 2024-09-18T12:12:29.096Z |
5124117 | 5124117 | 20240914152604_Kgo38 | KR0021 | 2024-09-18T12:12:08.354Z | 2024-09-18T12:12:29.051Z |
5123811 | 5123811 | 20240914113317_9TJAm | KR0021 | 2024-09-18T12:11:58.208Z | 2024-09-18T12:12:28.917Z |
5123642 | 5123642 | 20240914105348_fxC2N | KR0021 | 2024-09-18T12:11:52.871Z | 2024-09-18T12:12:28.852Z |
5111339 | 5111339 | 20240914202316_qa3QM | KR0021 | 2024-09-18T12:01:50.209Z | 2024-09-18T12:12:17.975Z |
5111033 | 5111033 | 20240914194421_RtzTE | KR0021 | 2024-09-18T12:01:21.702Z | 2024-09-18T12:12:17.916Z |
5110762 | 5110762 | 20240914183103_ffVxt | KR0021 | 2024-09-18T12:00:56.664Z | 2024-09-18T12:12:17.850Z |
5110710 | 5110710 | 20240914181301_ce3TN | KR0021 | 2024-09-18T12:00:44.830Z | 2024-09-18T12:12:17.835Z |
5110361 | 5110361 | 20240913153034_A8pUf | KR0021 | 2024-09-17T12:15:07.339Z | 2024-09-18T12:13:32.962Z |
5109989 | 5109989 | 20240913114349_KgLLR | KR0021 | 2024-09-17T12:14:53.211Z | 2024-09-18T12:13:29.283Z |
5098798 | 5098798 | 20240913193429_U9x6s | KR0021 | 2024-09-17T12:01:38.065Z | 2024-09-18T12:12:26.094Z |
5098721 | 5098721 | 20240913190849_SYd7W | KR0021 | 2024-09-17T12:01:25.391Z | 2024-09-18T12:12:26.049Z |
5098647 | 5098647 | 20240913184723_dPSVm | KR0021 | 2024-09-17T12:01:13.114Z | 2024-09-18T12:12:26.005Z |
5098639 | 5098639 | 20240913184638_Ufy1T | KR0021 | 2024-09-17T12:01:11.523Z | 2024-09-18T12:12:26.003Z |
5098513 | 5098513 | 20240913174516_R3UPY | KR0021 | 2024-09-17T12:00:48.224Z | 2024-09-18T12:12:25.917Z |
5069062 | 5069062 | 20240910133438_ls1BY | KR0021 | 2024-09-14T12:19:25.069Z | 2024-09-18T12:15:27.086Z |
5068122 | 5068122 | 20240910105743_rWaMT | KR0021 | 2024-09-14T12:19:09.236Z | 2024-09-18T12:15:25.626Z |
5062071 | 5062071 | 20240909164126_hWCCn | KR0021 | 2024-09-14T12:11:47.567Z | 2024-09-18T12:15:10.359Z |
5061956 | 5061956 | 20240909162918_r3AXW | KR0021 | 2024-09-14T12:11:41.655Z | 2024-09-18T12:15:10.237Z |
5061238 | 5061238 | 20240909143528_M0H7E | KR0021 | 2024-09-14T12:10:36.570Z | 2024-09-18T12:15:08.725Z |
5059443 | 5059443 | 20240910174400_24IhB | KR0021 | 2024-09-14T12:06:05.216Z | 2024-09-18T12:14:32.030Z |
5058760 | 5058760 | 20240910164201_1G5ni | KR0021 | 2024-09-14T12:04:27.660Z | 2024-09-18T12:14:30.177Z |
5058494 | 5058494 | 20240910161655_FiCoe | KR0021 | 2024-09-14T12:03:47.699Z | 2024-09-18T12:14:29.460Z |
5058399 | 5058399 | 20240910160911_mcnib | KR0021 | 2024-09-14T12:03:39.289Z | 2024-09-18T12:14:29.165Z |
5058148 | 5058148 | 20240910154759_cbUg2 | KR0021 | 2024-09-14T12:03:02.588Z | 2024-09-18T12:14:27.706Z |
5057514 | 5057514 | 20240910143929_lI6wL | KR0021 | 2024-09-14T12:01:18.094Z | 2024-09-18T12:14:23.592Z |
5056943 | 5056943 | 20240908114440_JlR1S | KR0021 | 2024-09-13T12:17:41.497Z | 2024-09-16T12:21:27.926Z |
5050288 | 5050288 | 20240907150424_kozuQ | KR0021 | 2024-09-13T12:13:22.664Z | 2024-09-16T12:20:56.927Z |
5050271 | 5050271 | 20240907150146_YdBPN | KR0021 | 2024-09-13T12:13:22.093Z | 2024-09-16T12:20:56.870Z |
5045920 | 5045920 | 20240908200554_zU923 | KR0021 | 2024-09-13T12:05:22.878Z | 2024-09-17T12:18:58.200Z |
5045878 | 5045878 | 20240908195102_Zqk9L | KR0021 | 2024-09-13T12:05:17.594Z | 2024-09-17T12:18:58.048Z |
5045820 | 5045820 | 20240908193733_Ihpox | KR0021 | 2024-09-13T12:05:03.253Z | 2024-09-17T12:18:57.455Z |
5045802 | 5045802 | 20240908192929_oQL2d | KR0021 | 2024-09-13T12:05:00.295Z | 2024-09-17T12:18:57.396Z |
5045756 | 5045756 | 20240908185512_jt8nA | KR0021 | 2024-09-13T12:04:52.918Z | 2024-09-17T12:18:57.219Z |
5045748 | 5045748 | 20240908185042_0r6xN | KR0021 | 2024-09-13T12:04:51.740Z | 2024-09-17T12:18:57.196Z |
5045746 | 5045746 | 20240908185039_tahep | KR0021 | 2024-09-13T12:04:51.307Z | 2024-09-17T12:18:57.195Z |
5045121 | 5045121 | 20240908162218_Upoxr | KR0021 | 2024-09-13T12:03:34.530Z | 2024-09-17T12:18:55.937Z |
5044911 | 5044911 | 20240908155436_334kX | KR0021 | 2024-09-13T12:03:09.191Z | 2024-09-17T12:18:55.396Z |
5044505 | 5044505 | 20240908150721_DcBPO | KR0021 | 2024-09-13T12:02:17.643Z | 2024-09-17T12:18:54.552Z |
5044027 | 5044027 | 20240908135912_U2aRn | KR0021 | 2024-09-13T12:01:17.050Z | 2024-09-17T12:18:53.337Z |
5044025 | 5044025 | 20240908135838_kGVtb | KR0021 | 2024-09-13T12:01:16.668Z | 2024-09-17T12:18:53.336Z |
5043882 | 5043882 | 20240908133057_PH4LH | KR0021 | 2024-09-13T12:00:54.047Z | 2024-09-17T12:18:52.996Z |
5043594 | 5043594 | 20240908121834_ertpr | KR0021 | 2024-09-13T12:00:10.501Z | 2024-09-17T12:18:52.445Z |
5043148 | 5043148 | 20240907135754_LKYmL | KR0021 | 2024-09-12T12:17:24.017Z | 2024-09-16T12:20:55.616Z |
5018612 | 5018612 | 20240904190904_rfoTs | KR0021 | 2024-09-10T12:10:58.938Z | 2024-09-13T12:19:48.315Z |
5018607 | 5018607 | 20240904190836_g0O29 | KR0021 | 2024-09-10T12:10:58.562Z | 2024-09-13T12:19:48.301Z |
5018479 | 5018479 | 20240904182018_slLPz | KR0021 | 2024-09-10T12:10:41.730Z | 2024-09-13T12:19:47.952Z |
5018437 | 5018437 | 20240904180720_ttLWB | KR0021 | 2024-09-10T12:10:37.129Z | 2024-09-13T12:19:47.896Z |
5018232 | 5018232 | 20240904172959_00zl2 | KR0021 | 2024-09-10T12:10:15.797Z | 2024-09-13T12:19:47.461Z |
5018096 | 5018096 | 20240904171106_9T8gB | KR0021 | 2024-09-10T12:09:59.978Z | 2024-09-13T12:19:47.206Z |
5017610 | 5017610 | 20240904162408_M2pxf | KR0021 | 2024-09-10T12:09:19.700Z | 2024-09-13T12:19:47.006Z |
5017592 | 5017592 | 20240904162250_yA8B0 | KR0021 | 2024-09-10T12:09:18.831Z | 2024-09-13T12:19:46.983Z |
5017267 | 5017267 | 20240904155133_Jelr3 | KR0021 | 2024-09-10T12:09:00.349Z | 2024-09-13T12:19:46.747Z |
5016521 | 5016521 | 20240904142330_hkevn | KR0021 | 2024-09-10T12:07:55.715Z | 2024-09-13T12:19:45.835Z |
5016080 | 5016080 | 20240904132919_lG97c | KR0021 | 2024-09-10T12:07:19.586Z | 2024-09-13T12:19:45.195Z |
5016065 | 5016065 | 20240904132618_5fc8M | KR0021 | 2024-09-10T12:07:18.321Z | 2024-09-13T12:19:45.172Z |
5015905 | 5015905 | 20240904130033_ggjNQ | KR0021 | 2024-09-10T12:06:58.147Z | 2024-09-13T12:19:44.925Z |
5006151 | 5006151 | 20240903170106_bqyXZ | KR0021 | 2024-09-09T12:04:22.725Z | 2024-09-12T12:19:07.735Z |
5005846 | 5005846 | 20240903162242_ceXzr | KR0021 | 2024-09-09T12:04:09.777Z | 2024-09-12T12:19:06.965Z |
4996319 | 4996319 | 20240902191820_GUYNB | KR0021 | 2024-09-08T12:04:41.896Z | 2024-09-11T12:20:52.959Z |
4986530 | 4986530 | 20240901151855_QbZDc | KR0021 | 2024-09-07T12:04:40.908Z | 2024-09-10T12:19:09.387Z |
4986471 | 4986471 | 20240901151300_2ajBn | KR0021 | 2024-09-07T12:04:37.257Z | 2024-09-10T12:19:09.349Z |
4985777 | 4985777 | 20240901133135_Mnkb3 | KR0021 | 2024-09-07T12:03:45.420Z | 2024-09-10T12:19:08.345Z |
4962893 | 4962893 | 20240811193023_PBC3c | KR0021 | 2024-09-04T12:04:57.888Z | 2024-09-06T12:04:10.441Z |
4962523 | 4962523 | 20240811190554_RYX9s | KR0021 | 2024-09-04T12:04:37.239Z | 2024-09-06T12:03:49.847Z |
4962481 | 4962481 | 20240811190231_yQ7ZH | KR0021 | 2024-09-04T12:04:35.416Z | 2024-09-06T12:03:48.356Z |
4962328 | 4962328 | 20240811184924_RQ1cI | KR0021 | 2024-09-04T12:04:25.731Z | 2024-09-06T12:03:42.305Z |
4962188 | 4962188 | 20240811184037_iHma3 | KR0021 | 2024-09-04T12:04:20.424Z | 2024-09-06T12:03:32.926Z |
4961875 | 4961875 | 20240811181146_glngU | KR0021 | 2024-09-04T12:04:00.395Z | 2024-09-06T12:03:18.458Z |
4961737 | 4961737 | 20240811175939_2O8ZP | KR0021 | 2024-09-04T12:03:52.801Z | 2024-09-06T12:03:12.254Z |
4961673 | 4961673 | 20240811175548_9dfz5 | KR0021 | 2024-09-04T12:03:49.878Z | 2024-09-06T12:03:09.669Z |
4961622 | 4961622 | 20240811175238_aHZZC | KR0021 | 2024-09-04T12:03:47.464Z | 2024-09-06T12:03:07.672Z |
4961468 | 4961468 | 20240811174258_EkDc2 | KR0021 | 2024-09-04T12:03:41.244Z | 2024-09-06T12:03:01.801Z |
4961379 | 4961379 | 20240811173623_NeJ23 | KR0021 | 2024-09-04T12:03:34.178Z | 2024-09-06T12:02:54.545Z |
4960526 | 4960526 | 20240811163203_2Wa1R | KR0021 | 2024-09-04T12:02:40.764Z | 2024-09-06T12:02:14.812Z |
4960441 | 4960441 | 20240811162608_QrPHU | KR0021 | 2024-09-04T12:02:32.934Z | 2024-09-06T12:02:09.673Z |
4960238 | 4960238 | 20240811161147_eJ2RC | KR0021 | 2024-09-04T12:02:21.430Z | 2024-09-06T12:01:59.858Z |
4960025 | 4960025 | 20240811155715_96Fwp | KR0021 | 2024-09-04T12:02:07.853Z | 2024-09-06T12:01:48.016Z |
4960002 | 4960002 | 20240811155552_KKD12 | KR0021 | 2024-09-04T12:02:06.704Z | 2024-09-06T12:01:46.980Z |
4959976 | 4959976 | 20240811155237_2EmvH | KR0021 | 2024-09-04T12:02:05.241Z | 2024-09-06T12:01:45.697Z |
4959760 | 4959760 | 20240811153524_eBDWS | KR0021 | 2024-09-04T12:01:54.645Z | 2024-09-06T12:01:36.371Z |
4959521 | 4959521 | 20240811151328_jvBiM | KR0021 | 2024-09-04T12:01:39.346Z | 2024-09-06T12:01:20.773Z |
4959511 | 4959511 | 20240811151231_9piAL | KR0021 | 2024-09-04T12:01:38.795Z | 2024-09-06T12:01:20.232Z |
4951966 | 4951966 | 20240811144956_Kc8vC | KR0021 | 2024-09-03T12:01:40.312Z | 2024-09-06T12:01:09.038Z |
4951852 | 4951852 | 20240811143650_foQWI | KR0021 | 2024-09-03T12:01:29.878Z | 2024-09-06T12:01:01.995Z |
4951723 | 4951723 | 20240811141756_wMYRJ | KR0021 | 2024-09-03T12:01:21.164Z | 2024-09-06T12:00:56.095Z |
4951442 | 4951442 | 20240811134925_UtNSn | KR0021 | 2024-09-03T12:01:02.285Z | 2024-09-06T12:00:44.318Z |
4951248 | 4951248 | 20240811132201_VMz30 | KR0021 | 2024-09-03T12:00:44.247Z | 2024-09-06T12:00:33.466Z |
4951195 | 4951195 | 20240811131719_Ou6R2 | KR0021 | 2024-09-03T12:00:38.644Z | 2024-09-06T12:00:30.031Z |
4951071 | 4951071 | 20240811130221_SyefW | KR0021 | 2024-09-03T12:00:25.347Z | 2024-09-06T12:00:21.198Z |
4935076 | 4935076 | 20240810193430_Fy58f | KR0021 | 2024-09-01T12:06:03.446Z | 2024-09-06T12:20:26.671Z |
4935008 | 4935008 | 20240810192730_K3pne | KR0021 | 2024-09-01T12:06:00.802Z | 2024-09-06T12:20:25.446Z |
4934998 | 4934998 | 20240810192649_s8uz9 | KR0021 | 2024-09-01T12:06:00.113Z | 2024-09-06T12:20:25.165Z |
4934983 | 4934983 | 20240810192524_V6SiJ | KR0021 | 2024-09-01T12:05:59.350Z | 2024-09-06T12:20:24.907Z |
4934872 | 4934872 | 20240810191314_gbtDA | KR0021 | 2024-09-01T12:05:54.045Z | 2024-09-06T12:20:22.679Z |
4934866 | 4934866 | 20240810191302_7FV1d | KR0021 | 2024-09-01T12:05:53.796Z | 2024-09-06T12:20:22.585Z |
4934746 | 4934746 | 20240810185509_E280b | KR0021 | 2024-09-01T12:05:45.335Z | 2024-09-06T12:20:19.603Z |
4934583 | 4934583 | 20240810183502_EC6N3 | KR0021 | 2024-09-01T12:05:32.569Z | 2024-09-06T12:20:15.442Z |
4933739 | 4933739 | 20240810172432_gIVq8 | KR0021 | 2024-09-01T12:04:36.078Z | 2024-09-06T12:19:32.438Z |
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);