participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,358 rows where station_code = "KR0019" 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 |
---|---|---|---|---|---|
5118976 | 5118976 | 20240915115210_bUU63 | KR0019 | 2024-09-18T12:09:16.309Z | 2024-09-18T12:12:19.211Z |
5070452 | 5070452 | 20240909125444_QzMXd | KR0019 | 2024-09-14T12:21:21.940Z | 2024-09-17T12:19:12.473Z |
5068822 | 5068822 | 20240910123332_wrbDn | KR0019 | 2024-09-14T12:19:21.766Z | 2024-09-18T12:15:26.716Z |
5068409 | 5068409 | 20240910112843_wiB6D | KR0019 | 2024-09-14T12:19:14.537Z | 2024-09-18T12:15:26.083Z |
5068405 | 5068405 | 20240910112805_V82dQ | KR0019 | 2024-09-14T12:19:14.134Z | 2024-09-18T12:15:26.065Z |
5068368 | 5068368 | 20240910112431_nlSUj | KR0019 | 2024-09-14T12:19:13.323Z | 2024-09-18T12:15:25.984Z |
5063135 | 5063135 | 20240909200140_3Jgz3 | KR0019 | 2024-09-14T12:13:33.757Z | 2024-09-18T12:15:13.083Z |
5063097 | 5063097 | 20240909195133_9bNg2 | KR0019 | 2024-09-14T12:13:27.712Z | 2024-09-18T12:15:13.004Z |
5063063 | 5063063 | 20240909194719_BqAke | KR0019 | 2024-09-14T12:13:23.618Z | 2024-09-18T12:15:12.940Z |
5063046 | 5063046 | 20240909194309_keFuA | KR0019 | 2024-09-14T12:13:22.340Z | 2024-09-18T12:15:12.937Z |
5062970 | 5062970 | 20240909192313_TKlW1 | KR0019 | 2024-09-14T12:13:11.315Z | 2024-09-18T12:15:12.721Z |
5062927 | 5062927 | 20240909190910_Kt2nP | KR0019 | 2024-09-14T12:13:04.129Z | 2024-09-18T12:15:12.562Z |
5062877 | 5062877 | 20240909185018_BpqX9 | KR0019 | 2024-09-14T12:13:00.267Z | 2024-09-18T12:15:12.383Z |
5062870 | 5062870 | 20240909184904_d2h8d | KR0019 | 2024-09-14T12:12:59.830Z | 2024-09-18T12:15:12.381Z |
5062795 | 5062795 | 20240909182541_v86vE | KR0019 | 2024-09-14T12:12:52.265Z | 2024-09-18T12:15:12.070Z |
5062773 | 5062773 | 20240909182136_2t8WD | KR0019 | 2024-09-14T12:12:49.615Z | 2024-09-18T12:15:12.058Z |
5062753 | 5062753 | 20240909181545_YSLtT | KR0019 | 2024-09-14T12:12:47.343Z | 2024-09-18T12:15:12.024Z |
5062746 | 5062746 | 20240909181237_eV3oH | KR0019 | 2024-09-14T12:12:46.971Z | 2024-09-18T12:15:12.000Z |
5062732 | 5062732 | 20240909180747_fawPU | KR0019 | 2024-09-14T12:12:46.031Z | 2024-09-18T12:15:11.970Z |
5062689 | 5062689 | 20240909180041_TaH0r | KR0019 | 2024-09-14T12:12:43.179Z | 2024-09-18T12:15:11.907Z |
5062678 | 5062678 | 20240909180010_mu9H2 | KR0019 | 2024-09-14T12:12:42.721Z | 2024-09-18T12:15:11.881Z |
5062652 | 5062652 | 20240909175437_7CjwO | KR0019 | 2024-09-14T12:12:40.865Z | 2024-09-18T12:15:11.777Z |
5062638 | 5062638 | 20240909175233_E2tRT | KR0019 | 2024-09-14T12:12:39.988Z | 2024-09-18T12:15:11.771Z |
5062424 | 5062424 | 20240909172330_3m9Nc | KR0019 | 2024-09-14T12:12:19.265Z | 2024-09-18T12:15:11.319Z |
5062019 | 5062019 | 20240909163352_QRW2j | KR0019 | 2024-09-14T12:11:45.096Z | 2024-09-18T12:15:10.318Z |
5062009 | 5062009 | 20240909163315_SwhxY | KR0019 | 2024-09-14T12:11:44.549Z | 2024-09-18T12:15:10.301Z |
5061801 | 5061801 | 20240909160110_gUj7F | KR0019 | 2024-09-14T12:11:26.426Z | 2024-09-18T12:15:09.996Z |
5061691 | 5061691 | 20240909154253_a7EJA | KR0019 | 2024-09-14T12:11:12.044Z | 2024-09-18T12:15:09.870Z |
5061525 | 5061525 | 20240909152043_6ByY9 | KR0019 | 2024-09-14T12:10:55.367Z | 2024-09-18T12:15:09.495Z |
5061430 | 5061430 | 20240909150552_ApLYo | KR0019 | 2024-09-14T12:10:49.724Z | 2024-09-18T12:15:09.212Z |
5061385 | 5061385 | 20240909145843_vd2J2 | KR0019 | 2024-09-14T12:10:45.754Z | 2024-09-18T12:15:09.079Z |
5061376 | 5061376 | 20240909145805_mdzcw | KR0019 | 2024-09-14T12:10:45.245Z | 2024-09-18T12:15:09.077Z |
5061229 | 5061229 | 20240909143422_hTa6G | KR0019 | 2024-09-14T12:10:36.084Z | 2024-09-18T12:15:08.646Z |
5060945 | 5060945 | 20240909133244_odYO4 | KR0019 | 2024-09-14T12:09:58.382Z | 2024-09-18T12:15:07.482Z |
5059982 | 5059982 | 20240910192638_54pNz | KR0019 | 2024-09-14T12:07:52.602Z | 2024-09-18T12:14:34.231Z |
5059870 | 5059870 | 20240910190940_JmHpI | KR0019 | 2024-09-14T12:07:28.981Z | 2024-09-18T12:14:33.951Z |
5059819 | 5059819 | 20240910185922_UtvF9 | KR0019 | 2024-09-14T12:07:20.554Z | 2024-09-18T12:14:33.531Z |
5059763 | 5059763 | 20240910184545_8JX9C | KR0019 | 2024-09-14T12:07:08.431Z | 2024-09-18T12:14:33.290Z |
5059751 | 5059751 | 20240910184313_i55hK | KR0019 | 2024-09-14T12:07:05.029Z | 2024-09-18T12:14:33.163Z |
5059643 | 5059643 | 20240910182225_8Y6Oh | KR0019 | 2024-09-14T12:06:38.980Z | 2024-09-18T12:14:32.700Z |
5059610 | 5059610 | 20240910181734_Y0e7d | KR0019 | 2024-09-14T12:06:35.335Z | 2024-09-18T12:14:32.659Z |
5059532 | 5059532 | 20240910180209_Z8IaH | KR0019 | 2024-09-14T12:06:20.169Z | 2024-09-18T12:14:32.362Z |
5059517 | 5059517 | 20240910175912_PAmMn | KR0019 | 2024-09-14T12:06:15.731Z | 2024-09-18T12:14:32.237Z |
5059507 | 5059507 | 20240910175416_Lk8uj | KR0019 | 2024-09-14T12:06:14.526Z | 2024-09-18T12:14:32.228Z |
5059448 | 5059448 | 20240910174413_oTUi9 | KR0019 | 2024-09-14T12:06:06.779Z | 2024-09-18T12:14:32.109Z |
5059432 | 5059432 | 20240910174216_gVnIa | KR0019 | 2024-09-14T12:06:02.044Z | 2024-09-18T12:14:31.904Z |
5059418 | 5059418 | 20240910173924_6QopE | KR0019 | 2024-09-14T12:05:55.559Z | 2024-09-18T12:14:31.801Z |
5059230 | 5059230 | 20240910172502_QOsy4 | KR0019 | 2024-09-14T12:05:29.078Z | 2024-09-18T12:14:31.414Z |
5059184 | 5059184 | 20240910172040_7Eu1M | KR0019 | 2024-09-14T12:05:24.905Z | 2024-09-18T12:14:31.371Z |
5058979 | 5058979 | 20240910170547_gvM7x | KR0019 | 2024-09-14T12:05:03.561Z | 2024-09-18T12:14:30.966Z |
5058841 | 5058841 | 20240910165109_rjevo | KR0019 | 2024-09-14T12:04:38.366Z | 2024-09-18T12:14:30.515Z |
5058756 | 5058756 | 20240910164138_jSbyv | KR0019 | 2024-09-14T12:04:27.287Z | 2024-09-18T12:14:30.150Z |
5058653 | 5058653 | 20240910163349_TvLTG | KR0019 | 2024-09-14T12:04:15.861Z | 2024-09-18T12:14:29.862Z |
5058611 | 5058611 | 20240910163110_OAaPA | KR0019 | 2024-09-14T12:04:08.405Z | 2024-09-18T12:14:29.798Z |
5058446 | 5058446 | 20240910161234_Ap14u | KR0019 | 2024-09-14T12:03:42.964Z | 2024-09-18T12:14:29.257Z |
5058356 | 5058356 | 20240910160642_cV63v | KR0019 | 2024-09-14T12:03:34.996Z | 2024-09-18T12:14:28.920Z |
5058128 | 5058128 | 20240910154703_Z7qmF | KR0019 | 2024-09-14T12:03:00.547Z | 2024-09-18T12:14:27.594Z |
5058118 | 5058118 | 20240910154651_O6Lu1 | KR0019 | 2024-09-14T12:02:59.606Z | 2024-09-18T12:14:27.578Z |
5058041 | 5058041 | 20240910153945_BTIX9 | KR0019 | 2024-09-14T12:02:42.743Z | 2024-09-18T12:14:27.304Z |
5057987 | 5057987 | 20240910153328_CAsHm | KR0019 | 2024-09-14T12:02:33.352Z | 2024-09-18T12:14:27.011Z |
5057486 | 5057486 | 20240910143422_IlPdx | KR0019 | 2024-09-14T12:01:12.225Z | 2024-09-18T12:14:23.334Z |
5057229 | 5057229 | 20240910140210_quvPv | KR0019 | 2024-09-14T12:00:35.435Z | 2024-09-18T12:14:20.781Z |
5052101 | 5052101 | 20240907194101_Vm96s | KR0019 | 2024-09-13T12:14:56.612Z | 2024-09-16T12:21:03.718Z |
5052038 | 5052038 | 20240907193000_5o3NB | KR0019 | 2024-09-13T12:14:54.472Z | 2024-09-16T12:21:03.308Z |
5051902 | 5051902 | 20240907190259_GWctJ | KR0019 | 2024-09-13T12:14:43.462Z | 2024-09-16T12:21:02.459Z |
5051897 | 5051897 | 20240907190129_93dMW | KR0019 | 2024-09-13T12:14:43.382Z | 2024-09-16T12:21:02.432Z |
5051868 | 5051868 | 20240907185806_x8IPg | KR0019 | 2024-09-13T12:14:39.834Z | 2024-09-16T12:21:02.330Z |
5051764 | 5051764 | 20240907183336_YHrPH | KR0019 | 2024-09-13T12:14:32.712Z | 2024-09-16T12:21:01.826Z |
5051724 | 5051724 | 20240907182934_rw0JV | KR0019 | 2024-09-13T12:14:31.510Z | 2024-09-16T12:21:01.667Z |
5051708 | 5051708 | 20240907182637_0wh1F | KR0019 | 2024-09-13T12:14:30.329Z | 2024-09-16T12:21:01.645Z |
5050130 | 5050130 | 20240909125339_2wRNT | KR0019 | 2024-09-13T12:12:42.209Z | 2024-09-17T12:19:12.422Z |
5049792 | 5049792 | 20240909114112_Lx3qH | KR0019 | 2024-09-13T12:12:26.649Z | 2024-09-17T12:19:11.496Z |
5049404 | 5049404 | 20240909105050_uCU8j | KR0019 | 2024-09-13T12:12:07.844Z | 2024-09-17T12:19:10.339Z |
5045453 | 5045453 | 20240908170544_J9J7l | KR0019 | 2024-09-13T12:04:10.046Z | 2024-09-17T12:18:56.583Z |
5044015 | 5044015 | 20240908135353_9E911 | KR0019 | 2024-09-13T12:01:15.534Z | 2024-09-17T12:18:53.312Z |
5043795 | 5043795 | 20240908130802_SMS25 | KR0019 | 2024-09-13T12:00:41.369Z | 2024-09-17T12:18:52.864Z |
5042637 | 5042637 | 20240907121054_G982l | KR0019 | 2024-09-12T12:17:16.426Z | 2024-09-16T12:20:53.827Z |
5018579 | 5018579 | 20240904185516_6tZ28 | KR0019 | 2024-09-10T12:10:53.039Z | 2024-09-13T12:19:48.179Z |
5018550 | 5018550 | 20240904184702_Xg2iK | KR0019 | 2024-09-10T12:10:50.530Z | 2024-09-13T12:19:48.146Z |
5018462 | 5018462 | 20240904181439_3n8J3 | KR0019 | 2024-09-10T12:10:40.113Z | 2024-09-13T12:19:47.929Z |
5018458 | 5018458 | 20240904181406_6XijX | KR0019 | 2024-09-10T12:10:39.593Z | 2024-09-13T12:19:47.926Z |
5018370 | 5018370 | 20240904174959_uM76a | KR0019 | 2024-09-10T12:10:31.513Z | 2024-09-13T12:19:47.659Z |
5018230 | 5018230 | 20240904172941_z5fhk | KR0019 | 2024-09-10T12:10:15.039Z | 2024-09-13T12:19:47.460Z |
5018224 | 5018224 | 20240904172820_RzvQO | KR0019 | 2024-09-10T12:10:13.892Z | 2024-09-13T12:19:47.447Z |
5017896 | 5017896 | 20240904165008_T23hT | KR0019 | 2024-09-10T12:09:43.153Z | 2024-09-13T12:19:47.124Z |
5017487 | 5017487 | 20240904161201_TBiem | KR0019 | 2024-09-10T12:09:12.124Z | 2024-09-13T12:19:46.894Z |
5017354 | 5017354 | 20240904160043_VDIgR | KR0019 | 2024-09-10T12:09:05.311Z | 2024-09-13T12:19:46.803Z |
5017309 | 5017309 | 20240904155723_65W9E | KR0019 | 2024-09-10T12:09:03.418Z | 2024-09-13T12:19:46.789Z |
5017304 | 5017304 | 20240904155521_Z2kez | KR0019 | 2024-09-10T12:09:03.021Z | 2024-09-13T12:19:46.763Z |
5017257 | 5017257 | 20240904154916_WTcqK | KR0019 | 2024-09-10T12:08:59.840Z | 2024-09-13T12:19:46.734Z |
5017155 | 5017155 | 20240904153600_2rJT8 | KR0019 | 2024-09-10T12:08:53.103Z | 2024-09-13T12:19:46.618Z |
5016563 | 5016563 | 20240904142719_l5bYb | KR0019 | 2024-09-10T12:07:57.979Z | 2024-09-13T12:19:45.860Z |
5016506 | 5016506 | 20240904142207_w6Fs0 | KR0019 | 2024-09-10T12:07:54.451Z | 2024-09-13T12:19:45.827Z |
5016379 | 5016379 | 20240904141036_zcK2k | KR0019 | 2024-09-10T12:07:45.859Z | 2024-09-13T12:19:45.582Z |
5016286 | 5016286 | 20240904135655_60AFT | KR0019 | 2024-09-10T12:07:38.735Z | 2024-09-13T12:19:45.427Z |
5015971 | 5015971 | 20240904131139_6j3g2 | KR0019 | 2024-09-10T12:07:06.429Z | 2024-09-13T12:19:45.083Z |
5015966 | 5015966 | 20240904131048_SpT38 | KR0019 | 2024-09-10T12:07:05.974Z | 2024-09-13T12:19:45.081Z |
5015891 | 5015891 | 20240904125425_oQozC | KR0019 | 2024-09-10T12:06:56.431Z | 2024-09-13T12:19:44.841Z |
5007155 | 5007155 | 20240903201001_clh4f | KR0019 | 2024-09-09T12:05:29.240Z | 2024-09-12T12:19:11.716Z |
5007063 | 5007063 | 20240903195348_8y4VB | KR0019 | 2024-09-09T12:05:22.424Z | 2024-09-12T12:19:11.221Z |
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);