participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,688 rows where station_code = "UK00CA" 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 |
---|---|---|---|---|---|
5482094 | 5482094 | 20241104210434_tPnmu | UK00CA | 2024-11-06T14:12:22.329Z | 2024-11-09T14:20:55.287Z |
5454715 | 5454715 | 20241031045841_iq3av | UK00CA | 2024-11-02T12:23:18.601Z | 2024-11-08T14:23:24.854Z |
5454672 | 5454672 | 20241031045405_Z44CO | UK00CA | 2024-11-02T12:23:16.267Z | 2024-11-08T14:23:24.702Z |
5454243 | 5454243 | 20241031040144_uoLSq | UK00CA | 2024-11-02T12:22:56.101Z | 2024-11-08T14:23:21.685Z |
5454107 | 5454107 | 20241031034216_6zmAl | UK00CA | 2024-11-02T12:22:50.858Z | 2024-11-08T14:23:20.465Z |
5453903 | 5453903 | 20241031031356_sLb72 | UK00CA | 2024-11-02T12:22:44.739Z | 2024-11-08T14:23:19.656Z |
5453880 | 5453880 | 20241031031138_dvJx7 | UK00CA | 2024-11-02T12:22:44.167Z | 2024-11-08T14:23:19.601Z |
5453617 | 5453617 | 20241031023126_i1KFG | UK00CA | 2024-11-02T12:22:37.166Z | 2024-11-08T14:23:18.258Z |
5453549 | 5453549 | 20241031022321_Ys3p3 | UK00CA | 2024-11-02T12:22:35.837Z | 2024-11-08T14:23:18.046Z |
5453531 | 5453531 | 20241031022001_hcJTu | UK00CA | 2024-11-02T12:22:35.247Z | 2024-11-08T14:23:17.880Z |
5453396 | 5453396 | 20241031020833_kQIcv | UK00CA | 2024-11-02T12:22:32.933Z | 2024-11-08T14:23:17.243Z |
5453351 | 5453351 | 20241031020438_hY25q | UK00CA | 2024-11-02T12:22:32.188Z | 2024-11-08T14:23:16.919Z |
5453306 | 5453306 | 20241031015935_5jjKd | UK00CA | 2024-11-02T12:22:31.478Z | 2024-11-08T14:23:16.526Z |
5444419 | 5444419 | 20241031011916_qceGX | UK00CA | 2024-11-01T12:21:17.070Z | 2024-11-08T14:23:15.394Z |
5444255 | 5444255 | 20241031010400_3BhDQ | UK00CA | 2024-11-01T12:21:11.674Z | 2024-11-08T14:23:14.252Z |
5444247 | 5444247 | 20241031010230_6wNae | UK00CA | 2024-11-01T12:21:11.436Z | 2024-11-08T14:23:14.183Z |
5444035 | 5444035 | 20241031004036_FvqxB | UK00CA | 2024-11-01T12:21:02.560Z | 2024-11-08T14:23:13.586Z |
5443979 | 5443979 | 20241031003439_vQ3J7 | UK00CA | 2024-11-01T12:21:00.359Z | 2024-11-08T14:23:13.410Z |
5443807 | 5443807 | 20241031001701_kE2F2 | UK00CA | 2024-11-01T12:20:52.731Z | 2024-11-08T14:23:12.668Z |
5439792 | 5439792 | 20241030203300_HkYnL | UK00CA | 2024-11-01T12:14:29.395Z | 2024-11-08T14:23:05.705Z |
5439721 | 5439721 | 20241030202208_j2rh3 | UK00CA | 2024-11-01T12:14:15.402Z | 2024-11-08T14:23:05.319Z |
5439712 | 5439712 | 20241030202109_Nr1Qd | UK00CA | 2024-11-01T12:14:12.972Z | 2024-11-08T14:23:04.964Z |
5432450 | 5432450 | 20241029033626_Xd2Vh | UK00CA | 2024-10-31T12:21:22.881Z | 2024-11-06T14:27:27.499Z |
5432396 | 5432396 | 20241029032606_zoc4V | UK00CA | 2024-10-31T12:21:20.709Z | 2024-11-06T14:27:26.805Z |
5431994 | 5431994 | 20241029022804_Yz6ui | UK00CA | 2024-10-31T12:20:55.483Z | 2024-11-06T14:27:25.666Z |
5431629 | 5431629 | 20241029013849_t92oO | UK00CA | 2024-10-31T12:20:26.838Z | 2024-11-06T14:27:24.274Z |
5431525 | 5431525 | 20241029012446_JiIcB | UK00CA | 2024-10-31T12:20:18.366Z | 2024-11-06T14:27:23.998Z |
5431509 | 5431509 | 20241029012215_9zvT7 | UK00CA | 2024-10-31T12:20:16.241Z | 2024-11-06T14:27:23.958Z |
5431471 | 5431471 | 20241029011723_AhU7A | UK00CA | 2024-10-31T12:20:11.576Z | 2024-11-06T14:27:23.858Z |
5431467 | 5431467 | 20241029011703_yEhlD | UK00CA | 2024-10-31T12:20:11.091Z | 2024-11-06T14:27:23.824Z |
5431438 | 5431438 | 20241029011159_G83pe | UK00CA | 2024-10-31T12:20:08.198Z | 2024-11-06T14:27:23.732Z |
5431301 | 5431301 | 20241029005257_Ufvuo | UK00CA | 2024-10-31T12:19:52.164Z | 2024-11-06T14:27:23.157Z |
5423064 | 5423064 | 20241026015012_Pkuv1 | UK00CA | 2024-10-30T12:24:15.941Z | 2024-11-03T14:27:33.846Z |
5418317 | 5418317 | 20241027202158_k4DnE | UK00CA | 2024-10-30T12:15:24.869Z | 2024-11-05T14:27:09.618Z |
5418174 | 5418174 | 20241027200445_wisrL | UK00CA | 2024-10-30T12:15:02.656Z | 2024-11-05T14:27:09.414Z |
5417700 | 5417700 | 20241027190231_u4h2Z | UK00CA | 2024-10-30T12:14:14.164Z | 2024-11-05T14:27:08.086Z |
5409351 | 5409351 | 20241027041203_ktV9o | UK00CA | 2024-10-29T12:17:17.074Z | 2024-11-04T14:29:01.595Z |
5409329 | 5409329 | 20241027041115_SFESB | UK00CA | 2024-10-29T12:17:16.723Z | 2024-11-04T14:29:01.584Z |
5409176 | 5409176 | 20241027040405_YjGsg | UK00CA | 2024-10-29T12:17:09.962Z | 2024-11-04T14:29:01.347Z |
5408674 | 5408674 | 20241027033536_LwT62 | UK00CA | 2024-10-29T12:16:43.888Z | 2024-11-04T14:28:59.829Z |
5408653 | 5408653 | 20241027033431_fnzhI | UK00CA | 2024-10-29T12:16:42.323Z | 2024-11-04T14:28:59.779Z |
5408620 | 5408620 | 20241027033232_wxbnM | UK00CA | 2024-10-29T12:16:39.508Z | 2024-11-04T14:28:59.678Z |
5408294 | 5408294 | 20241027032153_H745r | UK00CA | 2024-10-29T12:16:21.220Z | 2024-11-04T14:28:59.065Z |
5408256 | 5408256 | 20241027031943_YdRX2 | UK00CA | 2024-10-29T12:16:19.995Z | 2024-11-04T14:28:59.037Z |
5408175 | 5408175 | 20241027031328_t4IqU | UK00CA | 2024-10-29T12:16:13.908Z | 2024-11-04T14:28:58.947Z |
5408096 | 5408096 | 20241027030729_cSdSx | UK00CA | 2024-10-29T12:16:05.386Z | 2024-11-04T14:28:58.846Z |
5407952 | 5407952 | 20241027025847_95Suf | UK00CA | 2024-10-29T12:15:54.575Z | 2024-11-04T14:28:58.526Z |
5407878 | 5407878 | 20241027025620_UOH2t | UK00CA | 2024-10-29T12:15:50.445Z | 2024-11-04T14:28:58.287Z |
5407849 | 5407849 | 20241027025517_nXNAb | UK00CA | 2024-10-29T12:15:48.501Z | 2024-11-04T14:28:58.243Z |
5407402 | 5407402 | 20241027023438_s3aUe | UK00CA | 2024-10-29T12:15:23.661Z | 2024-11-04T14:28:57.489Z |
5406804 | 5406804 | 20241027020000_RsDrd | UK00CA | 2024-10-29T12:14:43.350Z | 2024-11-04T14:28:56.401Z |
5406602 | 5406602 | 20241027014715_3vhRa | UK00CA | 2024-10-29T12:14:23.243Z | 2024-11-04T14:28:55.895Z |
5406573 | 5406573 | 20241027014608_S6zYW | UK00CA | 2024-10-29T12:14:22.328Z | 2024-11-04T14:28:55.884Z |
5406184 | 5406184 | 20241027012013_ViZe0 | UK00CA | 2024-10-29T12:13:55.760Z | 2024-11-04T14:28:55.190Z |
5406010 | 5406010 | 20241027011202_lpyJm | UK00CA | 2024-10-29T12:13:47.561Z | 2024-11-04T14:28:54.843Z |
5405764 | 5405764 | 20241027005551_3TGSo | UK00CA | 2024-10-29T12:13:13.244Z | 2024-11-04T14:28:54.154Z |
5405731 | 5405731 | 20241027005443_3f52Q | UK00CA | 2024-10-29T12:13:10.863Z | 2024-11-04T14:28:54.119Z |
5405698 | 5405698 | 20241027005351_oqV7D | UK00CA | 2024-10-29T12:13:09.984Z | 2024-11-04T14:28:53.918Z |
5405602 | 5405602 | 20241027004754_a9jpq | UK00CA | 2024-10-29T12:13:04.347Z | 2024-11-04T14:28:53.698Z |
5405593 | 5405593 | 20241027004711_mp5yq | UK00CA | 2024-10-29T12:13:03.710Z | 2024-11-04T14:28:53.648Z |
5405503 | 5405503 | 20241027003951_Cvc8n | UK00CA | 2024-10-29T12:12:59.374Z | 2024-11-04T14:28:53.576Z |
5405280 | 5405280 | 20241027002634_Jtu4X | UK00CA | 2024-10-29T12:12:47.249Z | 2024-11-04T14:28:53.233Z |
5404928 | 5404928 | 20241027000055_S3oYq | UK00CA | 2024-10-29T12:12:07.563Z | 2024-11-04T14:28:52.407Z |
5404893 | 5404893 | 20241026235904_JgdKl | UK00CA | 2024-10-29T12:12:05.493Z | 2024-11-04T14:28:52.372Z |
5404480 | 5404480 | 20241026233029_LcZ2Z | UK00CA | 2024-10-29T12:11:32.332Z | 2024-11-04T14:28:51.102Z |
5404475 | 5404475 | 20241026233002_OJpbe | UK00CA | 2024-10-29T12:11:32.203Z | 2024-11-04T14:28:51.091Z |
5404396 | 5404396 | 20241026232245_d3wlO | UK00CA | 2024-10-29T12:11:18.023Z | 2024-11-04T14:28:50.846Z |
5404291 | 5404291 | 20241026231423_MNKg2 | UK00CA | 2024-10-29T12:11:05.042Z | 2024-11-04T14:28:50.582Z |
5404013 | 5404013 | 20241026225255_PE3NF | UK00CA | 2024-10-29T12:10:47.518Z | 2024-11-04T14:28:50.217Z |
5403962 | 5403962 | 20241026224822_NUqTY | UK00CA | 2024-10-29T12:10:38.410Z | 2024-11-04T14:28:50.109Z |
5403914 | 5403914 | 20241026224510_atRJZ | UK00CA | 2024-10-29T12:10:26.921Z | 2024-11-04T14:28:50.002Z |
5403625 | 5403625 | 20241026221633_TxrGX | UK00CA | 2024-10-29T12:10:02.407Z | 2024-11-04T14:28:49.339Z |
5402415 | 5402415 | 20241026193153_3dp7a | UK00CA | 2024-10-29T12:07:12.644Z | 2024-11-04T14:28:44.239Z |
5398213 | 5398213 | 20241026023526_zqt05 | UK00CA | 2024-10-28T12:19:06.410Z | 2024-11-03T14:27:35.700Z |
5398070 | 5398070 | 20241026022155_PWO61 | UK00CA | 2024-10-28T12:18:59.455Z | 2024-11-03T14:27:35.262Z |
5398019 | 5398019 | 20241026021756_x2hND | UK00CA | 2024-10-28T12:18:56.631Z | 2024-11-03T14:27:34.891Z |
5397654 | 5397654 | 20241026014543_c6IEs | UK00CA | 2024-10-28T12:18:31.034Z | 2024-11-03T14:27:33.666Z |
5397585 | 5397585 | 20241026014147_o1YmO | UK00CA | 2024-10-28T12:18:28.749Z | 2024-11-03T14:27:33.431Z |
5397184 | 5397184 | 20241026010756_Gmx8X | UK00CA | 2024-10-28T12:18:10.534Z | 2024-11-03T14:27:32.145Z |
5396984 | 5396984 | 20241026005427_6Xeat | UK00CA | 2024-10-28T12:18:01.546Z | 2024-11-03T14:27:31.616Z |
5396834 | 5396834 | 20241026004010_9k5Tc | UK00CA | 2024-10-28T12:17:57.076Z | 2024-11-03T14:27:31.023Z |
5395794 | 5395794 | 20241025231025_1dHdr | UK00CA | 2024-10-28T12:16:51.680Z | 2024-11-03T14:27:26.695Z |
5395754 | 5395754 | 20241025230818_Q0h0g | UK00CA | 2024-10-28T12:16:46.075Z | 2024-11-03T14:27:26.644Z |
5395352 | 5395352 | 20241025223503_s22qS | UK00CA | 2024-10-28T12:16:10.464Z | 2024-11-03T14:27:25.190Z |
5393598 | 5393598 | 20241025181727_8YTtu | UK00CA | 2024-10-28T12:12:51.120Z | 2024-11-03T14:27:16.645Z |
5386706 | 5386706 | 20241025011744_fi8kF | UK00CA | 2024-10-27T12:20:20.508Z | 2024-11-02T12:28:31.501Z |
5386490 | 5386490 | 20241025004810_rd2zz | UK00CA | 2024-10-27T12:20:07.784Z | 2024-11-02T12:28:31.272Z |
5386408 | 5386408 | 20241025003704_Qxtv0 | UK00CA | 2024-10-27T12:20:03.648Z | 2024-11-02T12:28:31.196Z |
5386304 | 5386304 | 20241025002357_hD3FI | UK00CA | 2024-10-27T12:19:59.142Z | 2024-11-02T12:28:30.946Z |
5386167 | 5386167 | 20241025001028_qEq7t | UK00CA | 2024-10-27T12:19:53.431Z | 2024-11-02T12:28:30.761Z |
5377961 | 5377961 | 20241024051937_918K6 | UK00CA | 2024-10-26T12:22:50.896Z | 2024-11-01T12:27:03.200Z |
5377214 | 5377214 | 20241024043909_Br4jl | UK00CA | 2024-10-26T12:22:31.481Z | 2024-11-01T12:27:02.327Z |
5377093 | 5377093 | 20241024043316_RTcC9 | UK00CA | 2024-10-26T12:22:25.999Z | 2024-11-01T12:27:02.175Z |
5376700 | 5376700 | 20241024040930_urofi | UK00CA | 2024-10-26T12:22:10.624Z | 2024-11-01T12:27:01.745Z |
5376669 | 5376669 | 20241024040729_uHMrJ | UK00CA | 2024-10-26T12:22:10.169Z | 2024-11-01T12:27:01.737Z |
5376440 | 5376440 | 20241024035544_pGR5N | UK00CA | 2024-10-26T12:22:02.504Z | 2024-11-01T12:27:01.558Z |
5376375 | 5376375 | 20241024035250_Ehu2q | UK00CA | 2024-10-26T12:21:59.400Z | 2024-11-01T12:27:01.515Z |
5376254 | 5376254 | 20241024034727_LY5cB | UK00CA | 2024-10-26T12:21:54.953Z | 2024-11-01T12:27:01.473Z |
5376150 | 5376150 | 20241024034337_VEFOB | UK00CA | 2024-10-26T12:21:52.366Z | 2024-11-01T12:27:01.413Z |
5375225 | 5375225 | 20241024030308_y3e3z | UK00CA | 2024-10-26T12:21:17.014Z | 2024-11-01T12:27:00.445Z |
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);