participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
638 rows where station_code = "KR0038" 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 |
---|---|---|---|---|---|
5569625 | 5569625 | 20241121184052_udNfp | KR0038 | 2024-11-22T14:11:24.348Z | 2024-11-22T14:11:24.348Z |
5569623 | 5569623 | 20241121182837_yZ5U2 | KR0038 | 2024-11-22T14:11:24.166Z | 2024-11-22T14:11:24.166Z |
5559184 | 5559184 | 20241120093525_JHpmp | KR0038 | 2024-11-21T14:05:33.327Z | 2024-11-22T14:19:21.381Z |
5554812 | 5554812 | 20241119104348_dgJbd | KR0038 | 2024-11-20T14:03:21.551Z | 2024-11-22T14:19:51.911Z |
5536692 | 5536692 | 20241112185326_nVqWe | KR0038 | 2024-11-14T14:10:28.136Z | 2024-11-21T14:26:04.676Z |
5536519 | 5536519 | 20241112182316_PnGnC | KR0038 | 2024-11-14T14:10:09.445Z | 2024-11-21T14:26:01.784Z |
5536502 | 5536502 | 20241112181835_STOhM | KR0038 | 2024-11-14T14:10:06.169Z | 2024-11-21T14:26:01.515Z |
5536456 | 5536456 | 20241112180733_nr7gm | KR0038 | 2024-11-14T14:09:59.963Z | 2024-11-21T14:26:01.085Z |
5508405 | 5508405 | 20241109171751_bOZUJ | KR0038 | 2024-11-10T14:07:45.159Z | 2024-11-18T14:26:22.207Z |
5508195 | 5508195 | 20241109150625_OjwuW | KR0038 | 2024-11-10T14:07:14.272Z | 2024-11-18T14:26:19.919Z |
5508193 | 5508193 | 20241109150532_cUoNY | KR0038 | 2024-11-10T14:07:14.011Z | 2024-11-18T14:26:19.840Z |
5501025 | 5501025 | 20241108190205_CERa3 | KR0038 | 2024-11-09T14:07:34.433Z | 2024-11-17T14:23:32.066Z |
5461661 | 5461661 | 20241101204544_PspDm | KR0038 | 2024-11-03T14:16:02.753Z | 2024-11-10T14:26:29.620Z |
5461650 | 5461650 | 20241101204202_EMmA3 | KR0038 | 2024-11-03T14:16:01.828Z | 2024-11-10T14:26:29.598Z |
5461614 | 5461614 | 20241101202712_E4fyf | KR0038 | 2024-11-03T14:15:58.534Z | 2024-11-10T14:26:29.320Z |
5449283 | 5449283 | 20241031151640_nDgNr | KR0038 | 2024-11-02T12:12:24.333Z | 2024-11-09T14:24:10.084Z |
5439925 | 5439925 | 20241030205017_2YKSL | KR0038 | 2024-11-01T12:14:38.483Z | 2024-11-08T14:23:06.155Z |
5439875 | 5439875 | 20241030204222_dsKEv | KR0038 | 2024-11-01T12:14:34.830Z | 2024-11-08T14:23:05.930Z |
5439132 | 5439132 | 20241030190448_LueMI | KR0038 | 2024-11-01T12:13:10.349Z | 2024-11-08T14:23:02.223Z |
5438706 | 5438706 | 20241030175204_524FU | KR0038 | 2024-11-01T12:12:18.452Z | 2024-11-08T14:23:00.599Z |
5436293 | 5436293 | 20241030124704_KdGtT | KR0038 | 2024-11-01T12:07:14.413Z | 2024-11-08T14:22:53.746Z |
5429558 | 5429558 | 20241028193511_ylxgn | KR0038 | 2024-10-31T12:16:46.128Z | 2024-11-06T14:27:16.600Z |
5428410 | 5428410 | 20241028170826_x053D | KR0038 | 2024-10-31T12:15:07.986Z | 2024-11-06T14:27:13.590Z |
5428076 | 5428076 | 20241028161850_z6CeL | KR0038 | 2024-10-31T12:14:32.159Z | 2024-11-06T14:27:12.949Z |
5427462 | 5427462 | 20241028150834_mLso4 | KR0038 | 2024-10-31T12:13:33.210Z | 2024-11-06T14:27:11.785Z |
5427071 | 5427071 | 20241028142829_iYd0P | KR0038 | 2024-10-31T12:13:03.499Z | 2024-11-06T14:27:11.358Z |
5425628 | 5425628 | 20241029172441_sUWqS | KR0038 | 2024-10-31T12:08:13.045Z | 2024-11-07T14:26:35.454Z |
5424786 | 5424786 | 20241029151141_W2RYJ | KR0038 | 2024-10-31T12:06:01.834Z | 2024-11-07T14:26:32.695Z |
5424757 | 5424757 | 20241029150904_xo8Kb | KR0038 | 2024-10-31T12:05:58.874Z | 2024-11-07T14:26:32.633Z |
5416657 | 5416657 | 20241027162758_JhFUs | KR0038 | 2024-10-30T12:12:02.032Z | 2024-11-05T14:27:05.140Z |
5416650 | 5416650 | 20241027162652_iiZey | KR0038 | 2024-10-30T12:12:00.957Z | 2024-11-05T14:27:05.113Z |
5416470 | 5416470 | 20241027155731_zb5Lh | KR0038 | 2024-10-30T12:11:39.266Z | 2024-11-05T14:27:04.869Z |
5415536 | 5415536 | 20241027140845_3jGjY | KR0038 | 2024-10-30T12:09:53.971Z | 2024-11-05T14:27:03.717Z |
5415415 | 5415415 | 20241027135041_aWOlt | KR0038 | 2024-10-30T12:09:41.835Z | 2024-11-05T14:27:03.607Z |
5394096 | 5394096 | 20241025193543_z2i3G | KR0038 | 2024-10-28T12:14:03.471Z | 2024-11-03T14:27:19.861Z |
5393845 | 5393845 | 20241025185636_8jNG3 | KR0038 | 2024-10-28T12:13:36.332Z | 2024-11-03T14:27:18.638Z |
5393842 | 5393842 | 20241025185636_OvOGt | KR0038 | 2024-10-28T12:13:35.453Z | 2024-11-03T14:27:18.634Z |
5393677 | 5393677 | 20241025182922_CIoOt | KR0038 | 2024-10-28T12:12:59.824Z | 2024-11-03T14:27:17.374Z |
5393411 | 5393411 | 20241025173132_2su0N | KR0038 | 2024-10-28T12:12:29.320Z | 2024-11-03T14:27:15.264Z |
5392340 | 5392340 | 20241026160231_2ZDSd | KR0038 | 2024-10-28T12:07:45.772Z | 2024-11-04T14:28:38.204Z |
5391830 | 5391830 | 20241026132939_MZ2sN | KR0038 | 2024-10-28T12:06:33.611Z | 2024-11-04T14:28:36.699Z |
5305801 | 5305801 | 20241013181516_aKGQ3 | KR0038 | 2024-10-15T12:05:25.865Z | 2024-10-22T12:24:28.704Z |
5290297 | 5290297 | 20241011171030_r3lQH | KR0038 | 2024-10-13T12:12:08.910Z | 2024-10-20T12:24:14.557Z |
5287514 | 5287514 | 20241011114220_4VZBY | KR0038 | 2024-10-13T12:07:22.256Z | 2024-10-20T12:23:50.538Z |
5287316 | 5287316 | 20241011112033_vKs36 | KR0038 | 2024-10-13T12:07:00.573Z | 2024-10-20T12:23:48.288Z |
5287189 | 5287189 | 20241011110940_90h63 | KR0038 | 2024-10-13T12:06:35.047Z | 2024-10-20T12:23:47.083Z |
5280884 | 5280884 | 20241010165610_dLP7R | KR0038 | 2024-10-12T12:13:00.292Z | 2024-10-19T12:27:27.472Z |
5280726 | 5280726 | 20241010163207_63lRz | KR0038 | 2024-10-12T12:12:47.471Z | 2024-10-19T12:27:26.143Z |
5273119 | 5273119 | 20241009162605_T8Hj0 | KR0038 | 2024-10-11T12:12:01.558Z | 2024-10-18T12:21:59.785Z |
5272479 | 5272479 | 20241009142749_zDmMf | KR0038 | 2024-10-11T12:10:44.965Z | 2024-10-18T12:21:56.945Z |
5272451 | 5272451 | 20241009142415_mOlIo | KR0038 | 2024-10-11T12:10:42.215Z | 2024-10-18T12:21:56.530Z |
5244604 | 5244604 | 20241005203228_9EcBl | KR0038 | 2024-10-07T12:15:04.077Z | 2024-10-14T12:24:33.960Z |
5242690 | 5242690 | 20241005145236_gCYEG | KR0038 | 2024-10-07T12:12:31.513Z | 2024-10-14T12:24:29.498Z |
5222938 | 5222938 | 20241003154605_CyfLJ | KR0038 | 2024-10-05T12:16:14.303Z | 2024-10-12T12:25:04.555Z |
5222776 | 5222776 | 20241003151359_ESkBA | KR0038 | 2024-10-05T12:16:04.238Z | 2024-10-12T12:25:04.030Z |
5210029 | 5210029 | 20241001182808_TyA3b | KR0038 | 2024-10-03T12:14:17.579Z | 2024-10-10T12:24:44.614Z |
5209939 | 5209939 | 20241001180420_2dTMl | KR0038 | 2024-10-03T12:14:01.624Z | 2024-10-10T12:24:44.376Z |
5209480 | 5209480 | 20241001151333_2vb1W | KR0038 | 2024-10-03T12:13:21.855Z | 2024-10-10T12:24:43.057Z |
5203270 | 5203270 | 20240930142951_WNMHY | KR0038 | 2024-10-02T12:10:07.450Z | 2024-10-09T12:29:07.738Z |
5190264 | 5190264 | 20240928163203_OMZ25 | KR0038 | 2024-09-30T12:16:40.126Z | 2024-10-06T12:28:19.226Z |
5174574 | 5174574 | 20240927183954_Qa3RH | KR0038 | 2024-09-28T12:14:05.300Z | 2024-10-05T12:29:00.097Z |
5174028 | 5174028 | 20240927161820_KQarT | KR0038 | 2024-09-28T12:13:14.890Z | 2024-10-05T12:28:56.605Z |
5173971 | 5173971 | 20240927161312_KAtx2 | KR0038 | 2024-09-28T12:13:10.378Z | 2024-10-05T12:28:56.483Z |
5172957 | 5172957 | 20240927140213_BpyNm | KR0038 | 2024-09-28T12:11:36.543Z | 2024-10-05T12:28:54.448Z |
5168075 | 5168075 | 20240926190843_o18Uf | KR0038 | 2024-09-27T12:06:31.858Z | 2024-10-04T12:25:32.841Z |
5168073 | 5168073 | 20240926190802_0Q3ES | KR0038 | 2024-09-27T12:06:31.605Z | 2024-10-04T12:25:32.830Z |
5131331 | 5131331 | 20240915191756_Gps52 | KR0038 | 2024-09-19T12:14:56.837Z | 2024-09-24T12:15:32.563Z |
5062995 | 5062995 | 20240909193156_3SZQf | KR0038 | 2024-09-14T12:13:15.242Z | 2024-09-18T12:15:12.788Z |
5062666 | 5062666 | 20240909175817_WhEcE | KR0038 | 2024-09-14T12:12:41.482Z | 2024-09-18T12:15:11.845Z |
5062583 | 5062583 | 20240909174316_hzOIk | KR0038 | 2024-09-14T12:12:34.691Z | 2024-09-18T12:15:11.548Z |
5062509 | 5062509 | 20240909173426_7rKCO | KR0038 | 2024-09-14T12:12:30.175Z | 2024-09-18T12:15:11.417Z |
5062465 | 5062465 | 20240909172828_yPbAQ | KR0038 | 2024-09-14T12:12:24.421Z | 2024-09-18T12:15:11.359Z |
5062228 | 5062228 | 20240909170019_K3MGA | KR0038 | 2024-09-14T12:11:57.223Z | 2024-09-18T12:15:10.703Z |
5062062 | 5062062 | 20240909164110_mBRhW | KR0038 | 2024-09-14T12:11:47.412Z | 2024-09-18T12:15:10.357Z |
5061474 | 5061474 | 20240909151201_Fv0hn | KR0038 | 2024-09-14T12:10:51.820Z | 2024-09-18T12:15:09.333Z |
5061415 | 5061415 | 20240909150423_MNcSA | KR0038 | 2024-09-14T12:10:48.460Z | 2024-09-18T12:15:09.095Z |
5060053 | 5060053 | 20240910194342_vNME3 | KR0038 | 2024-09-14T12:08:05.520Z | 2024-09-19T12:21:31.710Z |
5060049 | 5060049 | 20240910194308_t4sI7 | KR0038 | 2024-09-14T12:08:04.631Z | 2024-09-19T12:21:31.699Z |
5059908 | 5059908 | 20240910191748_Aup3J | KR0038 | 2024-09-14T12:07:36.323Z | 2024-09-19T12:21:31.391Z |
5059708 | 5059708 | 20240910183417_zHUnF | KR0038 | 2024-09-14T12:06:48.930Z | 2024-09-19T12:21:31.117Z |
5059640 | 5059640 | 20240910182149_27AsR | KR0038 | 2024-09-14T12:06:38.734Z | 2024-09-19T12:21:30.956Z |
5059478 | 5059478 | 20240910174829_N2Bgi | KR0038 | 2024-09-14T12:06:12.075Z | 2024-09-19T12:21:30.819Z |
5059093 | 5059093 | 20240910171217_1lxFH | KR0038 | 2024-09-14T12:05:13.872Z | 2024-09-19T12:21:30.351Z |
5057713 | 5057713 | 20240910150626_Z3wYK | KR0038 | 2024-09-14T12:01:47.367Z | 2024-09-19T12:21:28.626Z |
5057421 | 5057421 | 20240910142627_FIUjk | KR0038 | 2024-09-14T12:01:02.421Z | 2024-09-19T12:21:27.840Z |
5057320 | 5057320 | 20240910141111_uXUgj | KR0038 | 2024-09-14T12:00:49.928Z | 2024-09-19T12:21:27.544Z |
5052224 | 5052224 | 20240907195949_nWWg2 | KR0038 | 2024-09-13T12:15:00.690Z | 2024-09-16T12:21:04.663Z |
5052076 | 5052076 | 20240907193920_0lsOX | KR0038 | 2024-09-13T12:14:55.962Z | 2024-09-16T12:21:03.631Z |
5051987 | 5051987 | 20240907192025_BBm4Y | KR0038 | 2024-09-13T12:14:51.917Z | 2024-09-16T12:21:02.741Z |
5050451 | 5050451 | 20240907152207_sQcDu | KR0038 | 2024-09-13T12:13:32.316Z | 2024-09-16T12:20:57.700Z |
5050226 | 5050226 | 20240907145053_O19in | KR0038 | 2024-09-13T12:13:19.013Z | 2024-09-16T12:20:56.784Z |
5045601 | 5045601 | 20240908172825_I6i29 | KR0038 | 2024-09-13T12:04:25.145Z | 2024-09-17T12:18:56.831Z |
5045469 | 5045469 | 20240908170756_fm7EV | KR0038 | 2024-09-13T12:04:11.799Z | 2024-09-17T12:18:56.612Z |
5044933 | 5044933 | 20240908155706_ubJT8 | KR0038 | 2024-09-13T12:03:14.026Z | 2024-09-17T12:18:55.439Z |
5044283 | 5044283 | 20240908144040_WRcfG | KR0038 | 2024-09-13T12:01:51.681Z | 2024-09-17T12:18:54.005Z |
5043665 | 5043665 | 20240908123403_ZF53w | KR0038 | 2024-09-13T12:00:21.508Z | 2024-09-17T12:18:52.601Z |
5043337 | 5043337 | 20240907143425_luzxA | KR0038 | 2024-09-12T12:17:26.551Z | 2024-09-16T12:20:56.394Z |
5043299 | 5043299 | 20240907142654_3VcdV | KR0038 | 2024-09-12T12:17:26.106Z | 2024-09-16T12:20:56.226Z |
5042690 | 5042690 | 20240907122415_6B9N2 | KR0038 | 2024-09-12T12:17:16.731Z | 2024-09-16T12:20:53.901Z |
5017811 | 5017811 | 20240904164347_rEWg1 | KR0038 | 2024-09-10T12:09:34.676Z | 2024-09-13T12:19:47.091Z |
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);