participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,887 rows where station_code = "KR0026" 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 |
---|---|---|---|---|---|
5584075 | 5584075 | 20241117204643_XCJgi | KR0026 | 2024-11-23T14:25:27.080Z | 2024-11-23T14:25:27.080Z |
5583371 | 5583371 | 20241119104725_4JjlZ | KR0026 | 2024-11-23T14:24:08.947Z | 2024-11-23T14:24:08.947Z |
5570566 | 5570566 | 20241120201005_JRzoo | KR0026 | 2024-11-22T14:15:47.867Z | 2024-11-23T14:23:12.500Z |
5569677 | 5569677 | 20241121202923_LIYkd | KR0026 | 2024-11-22T14:11:28.643Z | 2024-11-23T14:21:24.873Z |
5569643 | 5569643 | 20241121194017_hjLMz | KR0026 | 2024-11-22T14:11:26.012Z | 2024-11-23T14:21:24.827Z |
5568720 | 5568720 | 20241121132717_UDVnk | KR0026 | 2024-11-22T14:09:36.476Z | 2024-11-23T14:21:24.349Z |
5568420 | 5568420 | 20241121124411_3JsYn | KR0026 | 2024-11-22T14:08:55.202Z | 2024-11-23T14:21:24.277Z |
5556177 | 5556177 | 20241119202833_KAHqT | KR0026 | 2024-11-20T14:07:33.843Z | 2024-11-23T14:24:23.838Z |
5556099 | 5556099 | 20241119195835_WmaPP | KR0026 | 2024-11-20T14:07:20.016Z | 2024-11-23T14:24:22.617Z |
5555638 | 5555638 | 20241119141231_AF5fJ | KR0026 | 2024-11-20T14:06:12.280Z | 2024-11-23T14:24:15.415Z |
5555433 | 5555433 | 20241119131306_LrW22 | KR0026 | 2024-11-20T14:05:37.243Z | 2024-11-23T14:24:14.283Z |
5555218 | 5555218 | 20241119121933_69rA1 | KR0026 | 2024-11-20T14:04:51.203Z | 2024-11-23T14:24:12.322Z |
5554934 | 5554934 | 20241119110619_6o9Hc | KR0026 | 2024-11-20T14:03:50.577Z | 2024-11-23T14:24:09.773Z |
5552007 | 5552007 | 20241118170813_Hw3dG | KR0026 | 2024-11-19T14:05:54.029Z | 2024-11-23T14:25:04.033Z |
5551898 | 5551898 | 20241118153707_kJe7H | KR0026 | 2024-11-19T14:05:46.888Z | 2024-11-23T14:25:03.537Z |
5550633 | 5550633 | 20241118110116_4K277 | KR0026 | 2024-11-19T14:02:50.956Z | 2024-11-23T14:24:55.252Z |
5550210 | 5550210 | 20241118094622_zSSGT | KR0026 | 2024-11-19T14:01:46.283Z | 2024-11-23T14:24:53.570Z |
5547948 | 5547948 | 20241117204159_sDln0 | KR0026 | 2024-11-18T14:06:51.260Z | 2024-11-23T14:25:27.048Z |
5547831 | 5547831 | 20241117195919_EoaKo | KR0026 | 2024-11-18T14:06:43.430Z | 2024-11-23T14:25:26.490Z |
5547814 | 5547814 | 20241117195125_NlVPs | KR0026 | 2024-11-18T14:06:40.872Z | 2024-11-23T14:25:26.391Z |
5547785 | 5547785 | 20241117194803_t7t7v | KR0026 | 2024-11-18T14:06:32.710Z | 2024-11-23T14:25:26.293Z |
5547672 | 5547672 | 20241117185951_h4s25 | KR0026 | 2024-11-18T14:06:15.187Z | 2024-11-23T14:25:25.563Z |
5547518 | 5547518 | 20241117173153_3xNRH | KR0026 | 2024-11-18T14:06:00.124Z | 2024-11-23T14:25:23.456Z |
5547497 | 5547497 | 20241117172448_7sVd3 | KR0026 | 2024-11-18T14:05:57.951Z | 2024-11-23T14:25:23.272Z |
5547421 | 5547421 | 20241117164002_iVmqO | KR0026 | 2024-11-18T14:05:50.321Z | 2024-11-23T14:25:22.594Z |
5547366 | 5547366 | 20241117154953_85PMb | KR0026 | 2024-11-18T14:05:35.359Z | 2024-11-23T14:25:21.719Z |
5547348 | 5547348 | 20241117154526_6I4Pk | KR0026 | 2024-11-18T14:05:33.257Z | 2024-11-23T14:25:21.569Z |
5547070 | 5547070 | 20241117143502_z4OcK | KR0026 | 2024-11-18T14:04:53.648Z | 2024-11-23T14:25:20.543Z |
5544061 | 5544061 | 20241113205504_F8jzD | KR0026 | 2024-11-16T14:10:00.557Z | 2024-11-22T14:24:17.180Z |
5544059 | 5544059 | 20241113205353_EsGXm | KR0026 | 2024-11-16T14:10:00.306Z | 2024-11-22T14:24:17.178Z |
5544042 | 5544042 | 20241113175614_nIPWh | KR0026 | 2024-11-16T14:09:51.172Z | 2024-11-22T14:24:16.049Z |
5536776 | 5536776 | 20241112190322_iA1Ld | KR0026 | 2024-11-14T14:10:32.813Z | 2024-11-21T14:26:05.454Z |
5536738 | 5536738 | 20241112190122_9MKnI | KR0026 | 2024-11-14T14:10:31.156Z | 2024-11-21T14:26:05.300Z |
5536699 | 5536699 | 20241112185509_60clf | KR0026 | 2024-11-14T14:10:28.526Z | 2024-11-21T14:26:04.966Z |
5536336 | 5536336 | 20241112173249_krjY4 | KR0026 | 2024-11-14T14:09:39.311Z | 2024-11-21T14:26:00.167Z |
5536226 | 5536226 | 20241112163956_uTzR3 | KR0026 | 2024-11-14T14:09:22.144Z | 2024-11-21T14:25:58.734Z |
5534812 | 5534812 | 20241113193917_35UdN | KR0026 | 2024-11-14T14:05:30.077Z | 2024-11-22T14:24:16.750Z |
5534810 | 5534810 | 20241113193853_fOFz2 | KR0026 | 2024-11-14T14:05:29.796Z | 2024-11-22T14:24:16.735Z |
5534747 | 5534747 | 20241113175510_qD2UJ | KR0026 | 2024-11-14T14:05:15.430Z | 2024-11-22T14:24:16.040Z |
5534729 | 5534729 | 20241113171404_14jWg | KR0026 | 2024-11-14T14:05:10.749Z | 2024-11-22T14:24:15.907Z |
5528426 | 5528426 | 20241111204612_eaNEO | KR0026 | 2024-11-13T14:10:36.642Z | 2024-11-20T14:25:30.384Z |
5528237 | 5528237 | 20241111200032_e53JA | KR0026 | 2024-11-13T14:10:17.986Z | 2024-11-20T14:25:26.918Z |
5527905 | 5527905 | 20241111185545_GZJ0l | KR0026 | 2024-11-13T14:09:31.931Z | 2024-11-20T14:25:22.816Z |
5527853 | 5527853 | 20241111184555_DSqYk | KR0026 | 2024-11-13T14:09:26.689Z | 2024-11-20T14:25:22.171Z |
5527725 | 5527725 | 20241111182441_IHC2Y | KR0026 | 2024-11-13T14:09:00.025Z | 2024-11-20T14:25:18.564Z |
5527711 | 5527711 | 20241111182134_wasIf | KR0026 | 2024-11-13T14:08:58.005Z | 2024-11-20T14:25:18.379Z |
5527675 | 5527675 | 20241111180756_I83b5 | KR0026 | 2024-11-13T14:08:53.435Z | 2024-11-20T14:25:17.584Z |
5527512 | 5527512 | 20241111172101_T7LIL | KR0026 | 2024-11-13T14:08:26.914Z | 2024-11-20T14:25:12.817Z |
5527492 | 5527492 | 20241111171016_UgooD | KR0026 | 2024-11-13T14:08:22.497Z | 2024-11-20T14:25:12.548Z |
5527444 | 5527444 | 20241111164102_OBbUP | KR0026 | 2024-11-13T14:08:15.538Z | 2024-11-20T14:25:11.265Z |
5527173 | 5527173 | 20241111110832_4y3Yg | KR0026 | 2024-11-13T14:06:33.697Z | 2024-11-20T14:24:48.282Z |
5525506 | 5525506 | 20241105163250_NmF6L | KR0026 | 2024-11-12T14:26:35.130Z | 2024-11-14T14:23:07.234Z |
5525354 | 5525354 | 20241106180236_dsEhv | KR0026 | 2024-11-12T14:25:46.794Z | 2024-11-15T14:24:44.972Z |
5525211 | 5525211 | 20241106131541_c8tHI | KR0026 | 2024-11-12T14:25:33.401Z | 2024-11-15T14:24:34.143Z |
5525040 | 5525040 | 20241108155644_L8XJy | KR0026 | 2024-11-12T14:22:50.529Z | 2024-11-17T14:23:23.069Z |
5522465 | 5522465 | 20241110200710_WUuCB | KR0026 | 2024-11-12T14:13:18.775Z | 2024-11-19T14:22:02.571Z |
5521946 | 5521946 | 20241110183737_EAyJb | KR0026 | 2024-11-12T14:12:14.212Z | 2024-11-19T14:21:56.274Z |
5521723 | 5521723 | 20241110180852_lHePn | KR0026 | 2024-11-12T14:11:54.342Z | 2024-11-19T14:21:54.644Z |
5521548 | 5521548 | 20241110173121_TOwuW | KR0026 | 2024-11-12T14:11:33.480Z | 2024-11-19T14:21:53.471Z |
5521546 | 5521546 | 20241110173043_wv99t | KR0026 | 2024-11-12T14:11:33.226Z | 2024-11-19T14:21:53.453Z |
5521346 | 5521346 | 20241110165405_KzLIy | KR0026 | 2024-11-12T14:10:52.499Z | 2024-11-19T14:21:52.170Z |
5521341 | 5521341 | 20241110165354_YgE3h | KR0026 | 2024-11-12T14:10:51.811Z | 2024-11-19T14:21:52.109Z |
5521144 | 5521144 | 20241110161019_byiAD | KR0026 | 2024-11-12T14:10:32.217Z | 2024-11-19T14:21:49.191Z |
5521105 | 5521105 | 20241110160315_zrimk | KR0026 | 2024-11-12T14:10:28.271Z | 2024-11-19T14:21:48.516Z |
5521037 | 5521037 | 20241110155015_jzmEC | KR0026 | 2024-11-12T14:10:16.831Z | 2024-11-19T14:21:47.746Z |
5520960 | 5520960 | 20241110153430_lyV8T | KR0026 | 2024-11-12T14:09:53.139Z | 2024-11-19T14:21:46.506Z |
5520906 | 5520906 | 20241110151938_UiBdq | KR0026 | 2024-11-12T14:09:44.546Z | 2024-11-19T14:21:45.533Z |
5520704 | 5520704 | 20241110134702_OsTAU | KR0026 | 2024-11-12T14:09:02.974Z | 2024-11-19T14:21:42.141Z |
5520566 | 5520566 | 20241110122617_9TqLT | KR0026 | 2024-11-12T14:08:41.075Z | 2024-11-19T14:21:38.455Z |
5508984 | 5508984 | 20241108210323_phByN | KR0026 | 2024-11-10T14:12:12.374Z | 2024-11-17T14:23:38.773Z |
5508969 | 5508969 | 20241108210127_3V6l6 | KR0026 | 2024-11-10T14:12:10.432Z | 2024-11-17T14:23:38.385Z |
5508044 | 5508044 | 20241109134856_XGU1o | KR0026 | 2024-11-10T14:06:43.246Z | 2024-11-18T14:26:18.078Z |
5507697 | 5507697 | 20241109121047_In3tl | KR0026 | 2024-11-10T14:05:48.723Z | 2024-11-18T14:26:13.404Z |
5503127 | 5503127 | 20241107204425_W984J | KR0026 | 2024-11-09T14:12:26.355Z | 2024-11-16T14:28:03.316Z |
5503013 | 5503013 | 20241107202831_DFyqX | KR0026 | 2024-11-09T14:12:19.083Z | 2024-11-16T14:28:01.842Z |
5502927 | 5502927 | 20241107201213_sP1PR | KR0026 | 2024-11-09T14:12:12.748Z | 2024-11-16T14:28:00.724Z |
5502918 | 5502918 | 20241107201132_9qJbm | KR0026 | 2024-11-09T14:12:12.350Z | 2024-11-16T14:28:00.676Z |
5502824 | 5502824 | 20241107195115_yPsWN | KR0026 | 2024-11-09T14:12:05.379Z | 2024-11-16T14:27:59.728Z |
5502701 | 5502701 | 20241107193304_t7aM8 | KR0026 | 2024-11-09T14:11:58.936Z | 2024-11-16T14:27:58.774Z |
5502443 | 5502443 | 20241107183420_clkdL | KR0026 | 2024-11-09T14:11:22.477Z | 2024-11-16T14:27:55.691Z |
5502406 | 5502406 | 20241107182508_4HLuK | KR0026 | 2024-11-09T14:11:16.346Z | 2024-11-16T14:27:55.343Z |
5501859 | 5501859 | 20241107161617_EB0EF | KR0026 | 2024-11-09T14:10:34.936Z | 2024-11-16T14:27:48.795Z |
5501640 | 5501640 | 20241107145600_R653s | KR0026 | 2024-11-09T14:10:08.960Z | 2024-11-16T14:27:43.998Z |
5501620 | 5501620 | 20241107145042_0Fxbi | KR0026 | 2024-11-09T14:10:07.819Z | 2024-11-16T14:27:43.651Z |
5501607 | 5501607 | 20241107144421_brgUc | KR0026 | 2024-11-09T14:10:07.049Z | 2024-11-16T14:27:43.573Z |
5501557 | 5501557 | 20241107141801_Pv9lg | KR0026 | 2024-11-09T14:10:00.849Z | 2024-11-16T14:27:42.604Z |
5501515 | 5501515 | 20241107135331_g0y6F | KR0026 | 2024-11-09T14:09:57.441Z | 2024-11-16T14:27:41.608Z |
5501395 | 5501395 | 20241107124935_rUJqy | KR0026 | 2024-11-09T14:09:26.858Z | 2024-11-16T14:27:37.619Z |
5501275 | 5501275 | 20241107115009_Tfvlm | KR0026 | 2024-11-09T14:09:02.701Z | 2024-11-16T14:27:33.558Z |
5501188 | 5501188 | 20241108205130_jQODT | KR0026 | 2024-11-09T14:07:49.243Z | 2024-11-17T14:23:37.217Z |
5501140 | 5501140 | 20241108203727_IUyWR | KR0026 | 2024-11-09T14:07:45.055Z | 2024-11-17T14:23:36.304Z |
5501122 | 5501122 | 20241108202459_qxQlY | KR0026 | 2024-11-09T14:07:43.236Z | 2024-11-17T14:23:36.071Z |
5501067 | 5501067 | 20241108192818_7vKoZ | KR0026 | 2024-11-09T14:07:38.548Z | 2024-11-17T14:23:33.820Z |
5500980 | 5500980 | 20241108184500_u3xtQ | KR0026 | 2024-11-09T14:07:32.194Z | 2024-11-17T14:23:31.827Z |
5500877 | 5500877 | 20241108180828_d1K2p | KR0026 | 2024-11-09T14:07:25.273Z | 2024-11-17T14:23:30.708Z |
5500169 | 5500169 | 20241108150125_adCXc | KR0026 | 2024-11-09T14:05:56.624Z | 2024-11-17T14:23:19.987Z |
5500088 | 5500088 | 20241108144036_YUm1V | KR0026 | 2024-11-09T14:05:40.357Z | 2024-11-17T14:23:18.599Z |
5499965 | 5499965 | 20241108141526_S3sg5 | KR0026 | 2024-11-09T14:05:24.627Z | 2024-11-17T14:23:17.695Z |
5495589 | 5495589 | 20241106202748_hSniH | KR0026 | 2024-11-08T14:10:26.405Z | 2024-11-15T14:24:51.029Z |
5495572 | 5495572 | 20241106202229_WP3dO | KR0026 | 2024-11-08T14:10:25.034Z | 2024-11-15T14:24:50.710Z |
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);