participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,950 rows where station_code = "KR0002" 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 |
---|---|---|---|---|---|
5467223 | 5467223 | 20241102202529_AFO18 | KR0002 | 2024-11-04T14:11:07.441Z | 2024-11-04T14:18:00.277Z |
5467059 | 5467059 | 20241102200021_vkwBO | KR0002 | 2024-11-04T14:10:33.472Z | 2024-11-04T14:18:00.167Z |
5466943 | 5466943 | 20241102192733_eTt60 | KR0002 | 2024-11-04T14:10:20.826Z | 2024-11-04T14:18:00.113Z |
5466908 | 5466908 | 20241102192222_FNMb0 | KR0002 | 2024-11-04T14:10:16.871Z | 2024-11-04T14:18:00.100Z |
5466792 | 5466792 | 20241102185732_kM8ex | KR0002 | 2024-11-04T14:09:49.994Z | 2024-11-04T14:18:00.057Z |
5466757 | 5466757 | 20241102184758_im2Av | KR0002 | 2024-11-04T14:09:43.871Z | 2024-11-04T14:18:00.044Z |
5466721 | 5466721 | 20241102184130_wAaQj | KR0002 | 2024-11-04T14:09:37.474Z | 2024-11-04T14:18:00.027Z |
5466650 | 5466650 | 20241102182459_cbXSG | KR0002 | 2024-11-04T14:09:29.960Z | 2024-11-04T14:17:59.996Z |
5466489 | 5466489 | 20241102175034_Mvj2Q | KR0002 | 2024-11-04T14:08:59.488Z | 2024-11-04T14:17:59.917Z |
5466472 | 5466472 | 20241102174918_oJZoe | KR0002 | 2024-11-04T14:08:56.993Z | 2024-11-04T14:17:59.911Z |
5466397 | 5466397 | 20241102173335_QU2Lf | KR0002 | 2024-11-04T14:08:47.290Z | 2024-11-04T14:17:59.879Z |
5466386 | 5466386 | 20241102172942_Ae8r1 | KR0002 | 2024-11-04T14:08:45.589Z | 2024-11-04T14:17:59.872Z |
5466282 | 5466282 | 20241102170143_lnGOC | KR0002 | 2024-11-04T14:08:32.487Z | 2024-11-04T14:17:59.784Z |
5466275 | 5466275 | 20241102170130_KDHYI | KR0002 | 2024-11-04T14:08:32.094Z | 2024-11-04T14:17:59.775Z |
5466241 | 5466241 | 20241102165627_Fue4u | KR0002 | 2024-11-04T14:08:25.138Z | 2024-11-04T14:17:59.699Z |
5466199 | 5466199 | 20241102164729_THEiF | KR0002 | 2024-11-04T14:08:13.884Z | 2024-11-04T14:17:59.676Z |
5466159 | 5466159 | 20241102163749_ed3fe | KR0002 | 2024-11-04T14:08:07.736Z | 2024-11-04T14:17:59.648Z |
5466149 | 5466149 | 20241102163526_Lthf7 | KR0002 | 2024-11-04T14:08:06.295Z | 2024-11-04T14:17:59.643Z |
5466133 | 5466133 | 20241102163120_VwQr6 | KR0002 | 2024-11-04T14:08:05.037Z | 2024-11-04T14:17:59.632Z |
5466089 | 5466089 | 20241102161802_klTg2 | KR0002 | 2024-11-04T14:07:59.744Z | 2024-11-04T14:17:59.598Z |
5465989 | 5465989 | 20241102154755_GrWMd | KR0002 | 2024-11-04T14:07:46.783Z | 2024-11-04T14:17:59.491Z |
5465902 | 5465902 | 20241102151353_6L2cr | KR0002 | 2024-11-04T14:07:21.378Z | 2024-11-04T14:17:59.195Z |
5465892 | 5465892 | 20241102151018_3J6Xw | KR0002 | 2024-11-04T14:07:19.977Z | 2024-11-04T14:17:59.121Z |
5465851 | 5465851 | 20241102145518_5WPS3 | KR0002 | 2024-11-04T14:07:13.952Z | 2024-11-04T14:17:59.067Z |
5465816 | 5465816 | 20241102142059_ejNov | KR0002 | 2024-11-04T14:06:49.863Z | 2024-11-04T14:17:58.871Z |
5465811 | 5465811 | 20241102141856_ZNJxS | KR0002 | 2024-11-04T14:06:47.991Z | 2024-11-04T14:17:58.851Z |
5465807 | 5465807 | 20241102141128_khxcE | KR0002 | 2024-11-04T14:06:46.664Z | 2024-11-04T14:17:58.837Z |
5465768 | 5465768 | 20241102135703_unz7D | KR0002 | 2024-11-04T14:06:39.223Z | 2024-11-04T14:17:58.731Z |
5465762 | 5465762 | 20241102135259_tzE2n | KR0002 | 2024-11-04T14:06:38.248Z | 2024-11-04T14:17:58.721Z |
5465731 | 5465731 | 20241102133010_y7LlB | KR0002 | 2024-11-04T14:06:31.085Z | 2024-11-04T14:17:58.643Z |
5465681 | 5465681 | 20241102130840_w0yP8 | KR0002 | 2024-11-04T14:06:14.465Z | 2024-11-04T14:17:58.521Z |
5434638 | 5434638 | 20241030095228_U2TNj | KR0002 | 2024-11-01T12:03:00.414Z | 2024-11-04T14:24:02.354Z |
5430012 | 5430012 | 20241028204550_Lh9Gu | KR0002 | 2024-10-31T12:17:23.820Z | 2024-11-04T14:27:06.683Z |
5429908 | 5429908 | 20241028202252_d3fgn | KR0002 | 2024-10-31T12:17:12.607Z | 2024-11-04T14:27:06.402Z |
5429832 | 5429832 | 20241028201109_MA4Zu | KR0002 | 2024-10-31T12:17:07.466Z | 2024-11-04T14:27:06.078Z |
5429830 | 5429830 | 20241028201106_M2Q1e | KR0002 | 2024-10-31T12:17:07.236Z | 2024-11-04T14:27:06.073Z |
5429812 | 5429812 | 20241028200914_7tQt9 | KR0002 | 2024-10-31T12:17:05.819Z | 2024-11-04T14:27:05.916Z |
5429803 | 5429803 | 20241028200716_060i6 | KR0002 | 2024-10-31T12:17:03.639Z | 2024-11-04T14:27:05.879Z |
5429766 | 5429766 | 20241028200101_BFZ3e | KR0002 | 2024-10-31T12:17:00.935Z | 2024-11-04T14:27:05.824Z |
5429744 | 5429744 | 20241028195628_SNZih | KR0002 | 2024-10-31T12:16:59.162Z | 2024-11-04T14:27:05.778Z |
5429714 | 5429714 | 20241028195408_hET1U | KR0002 | 2024-10-31T12:16:56.903Z | 2024-11-04T14:27:05.699Z |
5429661 | 5429661 | 20241028194628_sn33E | KR0002 | 2024-10-31T12:16:52.094Z | 2024-11-04T14:27:05.501Z |
5429565 | 5429565 | 20241028193737_mVARp | KR0002 | 2024-10-31T12:16:46.628Z | 2024-11-04T14:27:04.933Z |
5429482 | 5429482 | 20241028192738_AJute | KR0002 | 2024-10-31T12:16:38.364Z | 2024-11-04T14:27:04.557Z |
5429456 | 5429456 | 20241028192618_tu2bT | KR0002 | 2024-10-31T12:16:36.145Z | 2024-11-04T14:27:04.509Z |
5429448 | 5429448 | 20241028192439_y3NZk | KR0002 | 2024-10-31T12:16:35.151Z | 2024-11-04T14:27:04.488Z |
5429395 | 5429395 | 20241028191928_cgvFZ | KR0002 | 2024-10-31T12:16:31.030Z | 2024-11-04T14:27:04.383Z |
5429355 | 5429355 | 20241028191457_eFsTA | KR0002 | 2024-10-31T12:16:26.350Z | 2024-11-04T14:27:04.299Z |
5429040 | 5429040 | 20241028183954_R696V | KR0002 | 2024-10-31T12:15:55.327Z | 2024-11-04T14:27:02.181Z |
5428826 | 5428826 | 20241028181118_Xe2fJ | KR0002 | 2024-10-31T12:15:33.254Z | 2024-11-04T14:27:00.596Z |
5428739 | 5428739 | 20241028180154_iBHlm | KR0002 | 2024-10-31T12:15:29.017Z | 2024-11-04T14:26:59.499Z |
5428476 | 5428476 | 20241028171945_80KKf | KR0002 | 2024-10-31T12:15:11.700Z | 2024-11-04T14:26:57.348Z |
5428432 | 5428432 | 20241028171317_blVoJ | KR0002 | 2024-10-31T12:15:08.927Z | 2024-11-04T14:26:57.242Z |
5428346 | 5428346 | 20241028165710_JrlX9 | KR0002 | 2024-10-31T12:15:04.064Z | 2024-11-04T14:26:57.017Z |
5428320 | 5428320 | 20241028165318_zyvob | KR0002 | 2024-10-31T12:15:00.089Z | 2024-11-04T14:26:56.908Z |
5428300 | 5428300 | 20241028164935_3L0ro | KR0002 | 2024-10-31T12:14:57.504Z | 2024-11-04T14:26:56.860Z |
5428256 | 5428256 | 20241028164225_ZR3mL | KR0002 | 2024-10-31T12:14:52.999Z | 2024-11-04T14:26:56.641Z |
5428205 | 5428205 | 20241028163723_ZM2W6 | KR0002 | 2024-10-31T12:14:46.092Z | 2024-11-04T14:26:56.331Z |
5428172 | 5428172 | 20241028163414_A2dHE | KR0002 | 2024-10-31T12:14:42.121Z | 2024-11-04T14:26:56.115Z |
5428005 | 5428005 | 20241028161204_dpvLQ | KR0002 | 2024-10-31T12:14:25.754Z | 2024-11-04T14:26:55.643Z |
5427947 | 5427947 | 20241028160514_FyHYR | KR0002 | 2024-10-31T12:14:17.372Z | 2024-11-04T14:26:55.577Z |
5427884 | 5427884 | 20241028155650_C5Ptv | KR0002 | 2024-10-31T12:14:09.300Z | 2024-11-04T14:26:55.458Z |
5427738 | 5427738 | 20241028153925_8IKfa | KR0002 | 2024-10-31T12:13:53.796Z | 2024-11-04T14:26:54.891Z |
5427659 | 5427659 | 20241028152823_QiZuR | KR0002 | 2024-10-31T12:13:45.361Z | 2024-11-04T14:26:54.772Z |
5427003 | 5427003 | 20241028142033_jsrCL | KR0002 | 2024-10-31T12:12:49.212Z | 2024-11-04T14:26:52.842Z |
5422656 | 5422656 | 20241028132621_J1Pcb | KR0002 | 2024-10-30T12:20:29.724Z | 2024-11-04T14:26:50.897Z |
5422467 | 5422467 | 20241028130634_KxYCy | KR0002 | 2024-10-30T12:20:27.046Z | 2024-11-04T14:26:49.468Z |
5384685 | 5384685 | 20241024203919_JpJ7i | KR0002 | 2024-10-27T12:17:29.372Z | 2024-11-02T12:28:27.628Z |
5384321 | 5384321 | 20241024195601_jMbI8 | KR0002 | 2024-10-27T12:16:56.672Z | 2024-11-02T12:28:26.953Z |
5384293 | 5384293 | 20241024195330_3yhju | KR0002 | 2024-10-27T12:16:55.585Z | 2024-11-02T12:28:26.925Z |
5383951 | 5383951 | 20241024191829_rXL1W | KR0002 | 2024-10-27T12:16:33.083Z | 2024-11-02T12:28:26.602Z |
5383666 | 5383666 | 20241024184511_63UZx | KR0002 | 2024-10-27T12:15:58.583Z | 2024-11-02T12:28:26.128Z |
5383242 | 5383242 | 20241024180032_G03vS | KR0002 | 2024-10-27T12:15:00.368Z | 2024-11-02T12:28:24.841Z |
5382975 | 5382975 | 20241024173017_dmIkC | KR0002 | 2024-10-27T12:14:38.131Z | 2024-11-02T12:28:24.605Z |
5382847 | 5382847 | 20241024171256_zAvDc | KR0002 | 2024-10-27T12:14:30.527Z | 2024-11-02T12:28:24.453Z |
5382760 | 5382760 | 20241024170340_oxR26 | KR0002 | 2024-10-27T12:14:22.460Z | 2024-11-02T12:28:24.294Z |
5382750 | 5382750 | 20241024170247_aiDhC | KR0002 | 2024-10-27T12:14:20.675Z | 2024-11-02T12:28:24.288Z |
5382744 | 5382744 | 20241024170214_8rRRg | KR0002 | 2024-10-27T12:14:18.362Z | 2024-11-02T12:28:24.284Z |
5382651 | 5382651 | 20241024165040_X2XSf | KR0002 | 2024-10-27T12:14:09.532Z | 2024-11-02T12:28:24.192Z |
5382596 | 5382596 | 20241024164611_UwFv4 | KR0002 | 2024-10-27T12:14:05.809Z | 2024-11-02T12:28:24.143Z |
5382454 | 5382454 | 20241024162845_8QuJY | KR0002 | 2024-10-27T12:13:46.507Z | 2024-11-02T12:28:23.665Z |
5381721 | 5381721 | 20241024153257_VMJUm | KR0002 | 2024-10-27T12:12:33.441Z | 2024-11-02T12:28:23.090Z |
5371756 | 5371756 | 20241024151842_N3Sxd | KR0002 | 2024-10-26T12:12:34.290Z | 2024-11-02T12:28:22.764Z |
5371688 | 5371688 | 20241024151402_E3Pu7 | KR0002 | 2024-10-26T12:12:22.239Z | 2024-11-02T12:28:22.612Z |
5371668 | 5371668 | 20241024151237_zwJ06 | KR0002 | 2024-10-26T12:12:20.739Z | 2024-11-02T12:28:22.567Z |
5371647 | 5371647 | 20241024151052_cclRu | KR0002 | 2024-10-26T12:12:18.931Z | 2024-11-02T12:28:22.496Z |
5371494 | 5371494 | 20241024145723_NRYI6 | KR0002 | 2024-10-26T12:12:03.943Z | 2024-11-02T12:28:22.322Z |
5371492 | 5371492 | 20241024145700_Zs36O | KR0002 | 2024-10-26T12:12:03.691Z | 2024-11-02T12:28:22.316Z |
5371329 | 5371329 | 20241024144257_TEqPN | KR0002 | 2024-10-26T12:11:38.521Z | 2024-11-02T12:28:21.948Z |
5371297 | 5371297 | 20241024144039_fYSyx | KR0002 | 2024-10-26T12:11:33.232Z | 2024-11-02T12:28:21.933Z |
5370994 | 5370994 | 20241024141217_0kCl2 | KR0002 | 2024-10-26T12:10:50.510Z | 2024-11-02T12:28:21.648Z |
5370897 | 5370897 | 20241024140338_Gs1BW | KR0002 | 2024-10-26T12:10:37.063Z | 2024-11-02T12:28:21.570Z |
5370872 | 5370872 | 20241024140322_Dj3d4 | KR0002 | 2024-10-26T12:10:34.827Z | 2024-11-02T12:28:21.523Z |
5370837 | 5370837 | 20241024135946_4ozK2 | KR0002 | 2024-10-26T12:10:32.153Z | 2024-11-02T12:28:21.508Z |
5370695 | 5370695 | 20241024133934_N3Hhq | KR0002 | 2024-10-26T12:10:10.537Z | 2024-11-02T12:28:21.087Z |
5370578 | 5370578 | 20241024132744_QENTu | KR0002 | 2024-10-26T12:09:55.673Z | 2024-11-02T12:28:20.924Z |
5370387 | 5370387 | 20241024130108_Xlkrg | KR0002 | 2024-10-26T12:09:26.344Z | 2024-11-02T12:28:20.685Z |
5370367 | 5370367 | 20241024125938_EfYnA | KR0002 | 2024-10-26T12:09:24.141Z | 2024-11-02T12:28:20.664Z |
5370329 | 5370329 | 20241024125536_i02qP | KR0002 | 2024-10-26T12:09:18.306Z | 2024-11-02T12:28:20.618Z |
5370024 | 5370024 | 20241024121856_Zm51R | KR0002 | 2024-10-26T12:08:29.699Z | 2024-11-02T12:28:19.767Z |
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);