participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
626 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 |
---|---|---|---|---|---|
5461661 | 5461661 | 20241101204544_PspDm | KR0038 | 2024-11-03T14:16:02.753Z | 2024-11-03T14:19:33.814Z |
5461650 | 5461650 | 20241101204202_EMmA3 | KR0038 | 2024-11-03T14:16:01.828Z | 2024-11-03T14:19:33.811Z |
5461614 | 5461614 | 20241101202712_E4fyf | KR0038 | 2024-11-03T14:15:58.534Z | 2024-11-03T14:19:33.802Z |
5449283 | 5449283 | 20241031151640_nDgNr | KR0038 | 2024-11-02T12:12:24.333Z | 2024-11-03T14:20:50.857Z |
5439925 | 5439925 | 20241030205017_2YKSL | KR0038 | 2024-11-01T12:14:38.483Z | 2024-11-03T14:22:50.389Z |
5439875 | 5439875 | 20241030204222_dsKEv | KR0038 | 2024-11-01T12:14:34.830Z | 2024-11-03T14:22:50.170Z |
5439132 | 5439132 | 20241030190448_LueMI | KR0038 | 2024-11-01T12:13:10.349Z | 2024-11-03T14:22:46.203Z |
5438706 | 5438706 | 20241030175204_524FU | KR0038 | 2024-11-01T12:12:18.452Z | 2024-11-03T14:22:43.874Z |
5436293 | 5436293 | 20241030124704_KdGtT | KR0038 | 2024-11-01T12:07:14.413Z | 2024-11-03T14:22:36.143Z |
5429558 | 5429558 | 20241028193511_ylxgn | KR0038 | 2024-10-31T12:16:46.128Z | 2024-11-03T14:24:57.864Z |
5428410 | 5428410 | 20241028170826_x053D | KR0038 | 2024-10-31T12:15:07.986Z | 2024-11-03T14:24:51.676Z |
5428076 | 5428076 | 20241028161850_z6CeL | KR0038 | 2024-10-31T12:14:32.159Z | 2024-11-03T14:24:49.568Z |
5427462 | 5427462 | 20241028150834_mLso4 | KR0038 | 2024-10-31T12:13:33.210Z | 2024-11-03T14:24:47.777Z |
5427071 | 5427071 | 20241028142829_iYd0P | KR0038 | 2024-10-31T12:13:03.499Z | 2024-11-03T14:24:45.761Z |
5425628 | 5425628 | 20241029172441_sUWqS | KR0038 | 2024-10-31T12:08:13.045Z | 2024-11-03T14:23:45.485Z |
5424786 | 5424786 | 20241029151141_W2RYJ | KR0038 | 2024-10-31T12:06:01.834Z | 2024-11-03T14:23:38.791Z |
5424757 | 5424757 | 20241029150904_xo8Kb | KR0038 | 2024-10-31T12:05:58.874Z | 2024-11-03T14:23:38.743Z |
5416657 | 5416657 | 20241027162758_JhFUs | KR0038 | 2024-10-30T12:12:02.032Z | 2024-11-03T14:25:42.732Z |
5416650 | 5416650 | 20241027162652_iiZey | KR0038 | 2024-10-30T12:12:00.957Z | 2024-11-03T14:25:42.721Z |
5416470 | 5416470 | 20241027155731_zb5Lh | KR0038 | 2024-10-30T12:11:39.266Z | 2024-11-03T14:25:42.263Z |
5415536 | 5415536 | 20241027140845_3jGjY | KR0038 | 2024-10-30T12:09:53.971Z | 2024-11-03T14:25:39.849Z |
5415415 | 5415415 | 20241027135041_aWOlt | KR0038 | 2024-10-30T12:09:41.835Z | 2024-11-03T14:25:39.616Z |
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-03T14:26:18.064Z |
5391830 | 5391830 | 20241026132939_MZ2sN | KR0038 | 2024-10-28T12:06:33.611Z | 2024-11-03T14:26:15.792Z |
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 |
5017705 | 5017705 | 20240904163359_bXhhJ | KR0038 | 2024-09-10T12:09:25.134Z | 2024-09-13T12:19:47.059Z |
5017695 | 5017695 | 20240904163301_mMseo | KR0038 | 2024-09-10T12:09:24.427Z | 2024-09-13T12:19:47.056Z |
5016282 | 5016282 | 20240904135519_rk5U9 | KR0038 | 2024-09-10T12:07:38.457Z | 2024-09-13T12:19:45.408Z |
5006508 | 5006508 | 20240903174510_qbL2w | KR0038 | 2024-09-09T12:04:42.928Z | 2024-09-12T12:19:08.355Z |
5006487 | 5006487 | 20240903174136_VP6Ac | KR0038 | 2024-09-09T12:04:41.935Z | 2024-09-12T12:19:08.339Z |
5005259 | 5005259 | 20240903143936_dbs0O | KR0038 | 2024-09-09T12:03:32.103Z | 2024-09-12T12:19:05.602Z |
5005214 | 5005214 | 20240903143135_MdMDc | KR0038 | 2024-09-09T12:03:26.999Z | 2024-09-12T12:19:05.464Z |
5005155 | 5005155 | 20240903141754_2CuID | KR0038 | 2024-09-09T12:03:23.265Z | 2024-09-12T12:19:05.369Z |
5005118 | 5005118 | 20240903140240_zNUxp | KR0038 | 2024-09-09T12:03:21.080Z | 2024-09-12T12:19:05.306Z |
5005060 | 5005060 | 20240903135220_iI7Hx | KR0038 | 2024-09-09T12:03:18.094Z | 2024-09-12T12:19:05.192Z |
4996439 | 4996439 | 20240902194037_hs2zY | KR0038 | 2024-09-08T12:04:49.260Z | 2024-09-11T12:20:54.345Z |
4995815 | 4995815 | 20240902175730_sJmTQ | KR0038 | 2024-09-08T12:04:05.932Z | 2024-09-11T12:20:48.605Z |
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);