participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,739 rows where station_code = "KR0009" 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 |
---|---|---|---|---|---|
5069093 | 5069093 | 20240910134117_M5Nml | KR0009 | 2024-09-14T12:19:25.514Z | 2024-09-18T12:15:27.120Z |
5068987 | 5068987 | 20240910131921_8q1a3 | KR0009 | 2024-09-14T12:19:23.483Z | 2024-09-18T12:15:26.957Z |
5068980 | 5068980 | 20240910131902_IH6hn | KR0009 | 2024-09-14T12:19:23.476Z | 2024-09-18T12:15:26.953Z |
5068555 | 5068555 | 20240910114817_8EyhN | KR0009 | 2024-09-14T12:19:17.923Z | 2024-09-18T12:15:26.309Z |
5068363 | 5068363 | 20240910112431_nlSUj | KR0009 | 2024-09-14T12:19:13.323Z | 2024-09-18T12:15:25.984Z |
5060079 | 5060079 | 20240910194818_SgTM3 | KR0009 | 2024-09-14T12:08:10.443Z | 2024-09-18T12:14:34.594Z |
5060050 | 5060050 | 20240910194342_vNME3 | KR0009 | 2024-09-14T12:08:05.520Z | 2024-09-18T12:14:34.424Z |
5059991 | 5059991 | 20240910192804_F2KZF | KR0009 | 2024-09-14T12:07:54.114Z | 2024-09-18T12:14:34.302Z |
5059838 | 5059838 | 20240910190358_siW0Z | KR0009 | 2024-09-14T12:07:24.279Z | 2024-09-18T12:14:33.793Z |
5059817 | 5059817 | 20240910185922_UtvF9 | KR0009 | 2024-09-14T12:07:20.554Z | 2024-09-18T12:14:33.531Z |
5059761 | 5059761 | 20240910184545_8JX9C | KR0009 | 2024-09-14T12:07:08.431Z | 2024-09-18T12:14:33.290Z |
5059705 | 5059705 | 20240910183417_zHUnF | KR0009 | 2024-09-14T12:06:48.930Z | 2024-09-18T12:14:32.980Z |
5059635 | 5059635 | 20240910182149_27AsR | KR0009 | 2024-09-14T12:06:38.734Z | 2024-09-18T12:14:32.698Z |
5059505 | 5059505 | 20240910175416_Lk8uj | KR0009 | 2024-09-14T12:06:14.525Z | 2024-09-18T12:14:32.228Z |
5059474 | 5059474 | 20240910174829_N2Bgi | KR0009 | 2024-09-14T12:06:12.075Z | 2024-09-18T12:14:32.201Z |
5059227 | 5059227 | 20240910172502_QOsy4 | KR0009 | 2024-09-14T12:05:29.078Z | 2024-09-18T12:14:31.414Z |
5059090 | 5059090 | 20240910171217_1lxFH | KR0009 | 2024-09-14T12:05:13.872Z | 2024-09-18T12:14:31.217Z |
5058843 | 5058843 | 20240910165146_NcKo4 | KR0009 | 2024-09-14T12:04:38.741Z | 2024-09-18T12:14:30.515Z |
5058604 | 5058604 | 20240910163059_fgQ0D | KR0009 | 2024-09-14T12:04:07.473Z | 2024-09-18T12:14:29.794Z |
5058354 | 5058354 | 20240910160642_cV63v | KR0009 | 2024-09-14T12:03:34.996Z | 2024-09-18T12:14:28.920Z |
5058196 | 5058196 | 20240910155218_li1zq | KR0009 | 2024-09-14T12:03:08.270Z | 2024-09-18T12:14:28.075Z |
5058079 | 5058079 | 20240910154206_ZIVkM | KR0009 | 2024-09-14T12:02:53.223Z | 2024-09-18T12:14:27.393Z |
5057919 | 5057919 | 20240910152538_ZSgKU | KR0009 | 2024-09-14T12:02:25.344Z | 2024-09-18T12:14:26.579Z |
5057893 | 5057893 | 20240910152259_2jB33 | KR0009 | 2024-09-14T12:02:20.319Z | 2024-09-18T12:14:26.460Z |
5052176 | 5052176 | 20240907195419_3OD1w | KR0009 | 2024-09-13T12:14:59.406Z | 2024-09-16T12:21:04.311Z |
5052172 | 5052172 | 20240907195401_4eH3T | KR0009 | 2024-09-13T12:14:59.333Z | 2024-09-16T12:21:04.309Z |
5052097 | 5052097 | 20240907194101_Vm96s | KR0009 | 2024-09-13T12:14:56.612Z | 2024-09-16T12:21:03.718Z |
5052073 | 5052073 | 20240907193920_0lsOX | KR0009 | 2024-09-13T12:14:55.961Z | 2024-09-16T12:21:03.631Z |
5051972 | 5051972 | 20240907191720_uzjZD | KR0009 | 2024-09-13T12:14:50.973Z | 2024-09-16T12:21:02.662Z |
5051914 | 5051914 | 20240907190441_dM3Vh | KR0009 | 2024-09-13T12:14:45.155Z | 2024-09-16T12:21:02.476Z |
5051907 | 5051907 | 20240907190340_25DJN | KR0009 | 2024-09-13T12:14:43.829Z | 2024-09-16T12:21:02.470Z |
5051798 | 5051798 | 20240907184020_9TM9t | KR0009 | 2024-09-13T12:14:34.704Z | 2024-09-16T12:21:01.964Z |
5051761 | 5051761 | 20240907183336_YHrPH | KR0009 | 2024-09-13T12:14:32.711Z | 2024-09-16T12:21:01.826Z |
5051748 | 5051748 | 20240907183121_ilKTJ | KR0009 | 2024-09-13T12:14:32.454Z | 2024-09-16T12:21:01.809Z |
5051721 | 5051721 | 20240907182934_rw0JV | KR0009 | 2024-09-13T12:14:31.509Z | 2024-09-16T12:21:01.667Z |
5051712 | 5051712 | 20240907182647_XEdwp | KR0009 | 2024-09-13T12:14:30.478Z | 2024-09-16T12:21:01.653Z |
5051704 | 5051704 | 20240907182637_0wh1F | KR0009 | 2024-09-13T12:14:30.329Z | 2024-09-16T12:21:01.645Z |
5051665 | 5051665 | 20240907181655_P3HLc | KR0009 | 2024-09-13T12:14:28.496Z | 2024-09-16T12:21:01.517Z |
5051638 | 5051638 | 20240907180135_ImTKW | KR0009 | 2024-09-13T12:14:26.239Z | 2024-09-16T12:21:01.442Z |
5051592 | 5051592 | 20240907174808_zLQFE | KR0009 | 2024-09-13T12:14:23.832Z | 2024-09-16T12:21:01.358Z |
5051526 | 5051526 | 20240907173958_BsCRO | KR0009 | 2024-09-13T12:14:21.776Z | 2024-09-16T12:21:01.152Z |
5051446 | 5051446 | 20240907172829_r52q4 | KR0009 | 2024-09-13T12:14:15.180Z | 2024-09-16T12:21:00.485Z |
5051403 | 5051403 | 20240907172505_9Uefc | KR0009 | 2024-09-13T12:14:13.459Z | 2024-09-16T12:21:00.346Z |
5051370 | 5051370 | 20240907172053_eIZlD | KR0009 | 2024-09-13T12:14:12.489Z | 2024-09-16T12:21:00.223Z |
5051275 | 5051275 | 20240907171051_CtB2j | KR0009 | 2024-09-13T12:14:08.554Z | 2024-09-16T12:21:00.001Z |
5051240 | 5051240 | 20240907170736_RbEsX | KR0009 | 2024-09-13T12:14:07.293Z | 2024-09-16T12:20:59.921Z |
5051056 | 5051056 | 20240907164105_UBoOS | KR0009 | 2024-09-13T12:14:00.376Z | 2024-09-16T12:20:59.525Z |
5051040 | 5051040 | 20240907163925_LWY6Q | KR0009 | 2024-09-13T12:13:58.445Z | 2024-09-16T12:20:59.509Z |
5050864 | 5050864 | 20240907161721_RfOAz | KR0009 | 2024-09-13T12:13:50.308Z | 2024-09-16T12:20:58.830Z |
5050819 | 5050819 | 20240907161303_gknnl | KR0009 | 2024-09-13T12:13:47.596Z | 2024-09-16T12:20:58.704Z |
5050566 | 5050566 | 20240907154048_hHOMu | KR0009 | 2024-09-13T12:13:36.968Z | 2024-09-16T12:20:58.012Z |
5050415 | 5050415 | 20240907151948_B3zl6 | KR0009 | 2024-09-13T12:13:30.953Z | 2024-09-16T12:20:57.589Z |
5050403 | 5050403 | 20240907151835_Pn3K8 | KR0009 | 2024-09-13T12:13:30.591Z | 2024-09-16T12:20:57.580Z |
5050299 | 5050299 | 20240907150527_Pme6E | KR0009 | 2024-09-13T12:13:23.138Z | 2024-09-16T12:20:56.974Z |
5050184 | 5050184 | 20240907144605_a96df | KR0009 | 2024-09-13T12:13:16.062Z | 2024-09-16T12:20:56.674Z |
5050148 | 5050148 | 20240907144001_ABzy3 | KR0009 | 2024-09-13T12:13:12.483Z | 2024-09-16T12:20:56.447Z |
5043335 | 5043335 | 20240907143425_luzxA | KR0009 | 2024-09-12T12:17:26.551Z | 2024-09-16T12:20:56.394Z |
5042687 | 5042687 | 20240907122415_6B9N2 | KR0009 | 2024-09-12T12:17:16.731Z | 2024-09-16T12:20:53.900Z |
5042664 | 5042664 | 20240907122235_Wekko | KR0009 | 2024-09-12T12:17:16.635Z | 2024-09-16T12:20:53.884Z |
5042633 | 5042633 | 20240907121054_G982l | KR0009 | 2024-09-12T12:17:16.421Z | 2024-09-16T12:20:53.827Z |
5042457 | 5042457 | 20240907114514_1nXk8 | KR0009 | 2024-09-12T12:17:12.050Z | 2024-09-16T12:20:53.017Z |
5042440 | 5042440 | 20240907113821_s9SfM | KR0009 | 2024-09-12T12:17:11.226Z | 2024-09-16T12:20:52.884Z |
5042407 | 5042407 | 20240907113549_GencZ | KR0009 | 2024-09-12T12:17:09.163Z | 2024-09-16T12:20:52.666Z |
5017702 | 5017702 | 20240904163359_bXhhJ | KR0009 | 2024-09-10T12:09:25.134Z | 2024-09-13T12:19:47.059Z |
5015874 | 5015874 | 20240904125009_JV5LX | KR0009 | 2024-09-10T12:06:54.559Z | 2024-09-13T12:19:44.774Z |
5015641 | 5015641 | 20240904120401_oJPvn | KR0009 | 2024-09-10T12:06:34.640Z | 2024-09-13T12:19:44.557Z |
5015619 | 5015619 | 20240904120040_pX97E | KR0009 | 2024-09-10T12:06:32.305Z | 2024-09-13T12:19:44.447Z |
5015493 | 5015493 | 20240904114535_oMOlM | KR0009 | 2024-09-10T12:06:15.748Z | 2024-09-13T12:19:44.161Z |
5007049 | 5007049 | 20240903195155_EpKpt | KR0009 | 2024-09-09T12:05:21.471Z | 2024-09-12T12:19:11.188Z |
5007033 | 5007033 | 20240903194844_0kCvp | KR0009 | 2024-09-09T12:05:20.851Z | 2024-09-12T12:19:11.169Z |
5007010 | 5007010 | 20240903194749_O1amS | KR0009 | 2024-09-09T12:05:19.594Z | 2024-09-12T12:19:11.116Z |
5006722 | 5006722 | 20240903183821_VjPEi | KR0009 | 2024-09-09T12:04:57.421Z | 2024-09-12T12:19:09.313Z |
5006710 | 5006710 | 20240903183747_D52PW | KR0009 | 2024-09-09T12:04:56.767Z | 2024-09-12T12:19:09.295Z |
5006623 | 5006623 | 20240903180823_jNX2u | KR0009 | 2024-09-09T12:04:49.645Z | 2024-09-12T12:19:09.066Z |
5006505 | 5006505 | 20240903174510_qbL2w | KR0009 | 2024-09-09T12:04:42.928Z | 2024-09-12T12:19:08.355Z |
5006485 | 5006485 | 20240903174136_VP6Ac | KR0009 | 2024-09-09T12:04:41.935Z | 2024-09-12T12:19:08.339Z |
5006391 | 5006391 | 20240903173203_8Gh5x | KR0009 | 2024-09-09T12:04:36.409Z | 2024-09-12T12:19:08.244Z |
5006370 | 5006370 | 20240903173043_mKA3Y | KR0009 | 2024-09-09T12:04:33.316Z | 2024-09-12T12:19:08.216Z |
5006356 | 5006356 | 20240903172751_2VGyK | KR0009 | 2024-09-09T12:04:32.357Z | 2024-09-12T12:19:08.196Z |
5006352 | 5006352 | 20240903172738_IZ7d3 | KR0009 | 2024-09-09T12:04:32.167Z | 2024-09-12T12:19:08.193Z |
5005943 | 5005943 | 20240903163726_SqBCQ | KR0009 | 2024-09-09T12:04:13.983Z | 2024-09-12T12:19:07.105Z |
5005851 | 5005851 | 20240903162244_LLkpG | KR0009 | 2024-09-09T12:04:09.988Z | 2024-09-12T12:19:06.967Z |
5005828 | 5005828 | 20240903161929_uw7R8 | KR0009 | 2024-09-09T12:04:09.076Z | 2024-09-12T12:19:06.952Z |
5005723 | 5005723 | 20240903160112_iWYYI | KR0009 | 2024-09-09T12:04:00.013Z | 2024-09-12T12:19:06.512Z |
5005689 | 5005689 | 20240903155605_gOkok | KR0009 | 2024-09-09T12:03:55.411Z | 2024-09-12T12:19:06.432Z |
5005600 | 5005600 | 20240903154216_IDWfe | KR0009 | 2024-09-09T12:03:50.906Z | 2024-09-12T12:19:06.244Z |
5005455 | 5005455 | 20240903151629_35Bnz | KR0009 | 2024-09-09T12:03:43.489Z | 2024-09-12T12:19:05.957Z |
5005336 | 5005336 | 20240903145559_V50so | KR0009 | 2024-09-09T12:03:37.701Z | 2024-09-12T12:19:05.773Z |
5005315 | 5005315 | 20240903145325_2kz2d | KR0009 | 2024-09-09T12:03:36.389Z | 2024-09-12T12:19:05.724Z |
5005256 | 5005256 | 20240903143936_dbs0O | KR0009 | 2024-09-09T12:03:32.103Z | 2024-09-12T12:19:05.602Z |
5005211 | 5005211 | 20240903143135_MdMDc | KR0009 | 2024-09-09T12:03:26.999Z | 2024-09-12T12:19:05.464Z |
5005111 | 5005111 | 20240903140140_i1T1j | KR0009 | 2024-09-09T12:03:20.718Z | 2024-09-12T12:19:05.293Z |
5005077 | 5005077 | 20240903135653_sHBV5 | KR0009 | 2024-09-09T12:03:19.006Z | 2024-09-12T12:19:05.221Z |
5004957 | 5004957 | 20240903133931_ERlHh | KR0009 | 2024-09-09T12:03:13.940Z | 2024-09-12T12:19:04.612Z |
5004945 | 5004945 | 20240903133640_M6iRK | KR0009 | 2024-09-09T12:03:13.251Z | 2024-09-12T12:19:04.545Z |
5004904 | 5004904 | 20240903132310_Oq56i | KR0009 | 2024-09-09T12:03:10.964Z | 2024-09-12T12:19:04.468Z |
5004864 | 5004864 | 20240903131024_JoXc7 | KR0009 | 2024-09-09T12:03:08.727Z | 2024-09-12T12:19:04.393Z |
5004835 | 5004835 | 20240903130259_ZV293 | KR0009 | 2024-09-09T12:03:05.544Z | 2024-09-12T12:19:04.339Z |
5004727 | 5004727 | 20240903121836_x11Wq | KR0009 | 2024-09-09T12:02:56.778Z | 2024-09-12T12:19:03.665Z |
5004681 | 5004681 | 20240903120549_CWeZH | KR0009 | 2024-09-09T12:02:54.485Z | 2024-09-12T12:19:03.503Z |
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);