participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,761 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 |
---|---|---|---|---|---|
5591334 | 5591334 | 20241122223413_ijD6Y | UK00CA | 2024-11-24T14:19:44.922Z | 2024-11-24T14:21:11.456Z |
5582746 | 5582746 | 20241122035254_WXrgj | UK00CA | 2024-11-23T14:21:16.638Z | 2024-11-24T14:22:37.878Z |
5582598 | 5582598 | 20241122034333_K9V9I | UK00CA | 2024-11-23T14:21:10.858Z | 2024-11-24T14:22:37.451Z |
5582305 | 5582305 | 20241122031947_WLHO8 | UK00CA | 2024-11-23T14:21:02.065Z | 2024-11-24T14:22:36.511Z |
5582225 | 5582225 | 20241122031252_3kKDB | UK00CA | 2024-11-23T14:20:59.794Z | 2024-11-24T14:22:36.188Z |
5582034 | 5582034 | 20241122025816_9RcUC | UK00CA | 2024-11-23T14:20:54.440Z | 2024-11-24T14:22:35.612Z |
5581786 | 5581786 | 20241122023432_rrQXx | UK00CA | 2024-11-23T14:20:43.151Z | 2024-11-24T14:22:33.321Z |
5581616 | 5581616 | 20241122021855_nl2IF | UK00CA | 2024-11-23T14:20:33.011Z | 2024-11-24T14:22:32.295Z |
5581432 | 5581432 | 20241122020230_nzJ5n | UK00CA | 2024-11-23T14:20:23.585Z | 2024-11-24T14:22:31.795Z |
5580029 | 5580029 | 20241121234818_FO243 | UK00CA | 2024-11-23T14:19:01.667Z | 2024-11-24T14:22:26.961Z |
5579831 | 5579831 | 20241121232646_MkWu4 | UK00CA | 2024-11-23T14:18:52.480Z | 2024-11-24T14:22:26.242Z |
5579798 | 5579798 | 20241121232126_opJUR | UK00CA | 2024-11-23T14:18:51.291Z | 2024-11-24T14:22:26.167Z |
5579542 | 5579542 | 20241121225828_GKdLJ | UK00CA | 2024-11-23T14:18:33.915Z | 2024-11-24T14:22:25.432Z |
5579442 | 5579442 | 20241121224337_tXerN | UK00CA | 2024-11-23T14:18:25.123Z | 2024-11-24T14:22:25.105Z |
5578834 | 5578834 | 20241121210549_LjOfh | UK00CA | 2024-11-23T14:17:35.201Z | 2024-11-24T14:22:22.378Z |
5578539 | 5578539 | 20241121202104_FEjlM | UK00CA | 2024-11-23T14:17:21.522Z | 2024-11-24T14:22:20.951Z |
5578286 | 5578286 | 20241121192108_4LWnN | UK00CA | 2024-11-23T14:16:42.333Z | 2024-11-24T14:22:19.644Z |
5578246 | 5578246 | 20241121191533_5ZZM6 | UK00CA | 2024-11-23T14:16:37.872Z | 2024-11-24T14:22:19.551Z |
5578106 | 5578106 | 20241121185228_dJVTh | UK00CA | 2024-11-23T14:16:28.680Z | 2024-11-24T14:22:18.849Z |
5573445 | 5573445 | 20241122041838_ozhC5 | UK00CA | 2024-11-23T14:00:32.572Z | 2024-11-24T14:21:09.834Z |
5570596 | 5570596 | 20241120202152_8vsve | UK00CA | 2024-11-22T14:15:52.038Z | 2024-11-24T14:23:35.611Z |
5570594 | 5570594 | 20241120202149_2a37A | UK00CA | 2024-11-22T14:15:51.456Z | 2024-11-24T14:23:35.584Z |
5570380 | 5570380 | 20241120192912_cWwwG | UK00CA | 2024-11-22T14:15:17.278Z | 2024-11-24T14:23:33.234Z |
5570332 | 5570332 | 20241120191917_DM5DF | UK00CA | 2024-11-22T14:15:10.244Z | 2024-11-24T14:23:32.847Z |
5569839 | 5569839 | 20241120174329_PMpiD | UK00CA | 2024-11-22T14:14:24.001Z | 2024-11-24T14:23:25.201Z |
5569763 | 5569763 | 20241120171935_qxzMm | UK00CA | 2024-11-22T14:14:05.360Z | 2024-11-24T14:23:23.582Z |
5569754 | 5569754 | 20241120171759_FIsno | UK00CA | 2024-11-22T14:14:04.393Z | 2024-11-24T14:23:23.536Z |
5565459 | 5565459 | 20241120042807_EXWOu | UK00CA | 2024-11-21T14:18:49.803Z | 2024-11-24T14:24:47.174Z |
5565259 | 5565259 | 20241120040804_SWrf7 | UK00CA | 2024-11-21T14:18:43.938Z | 2024-11-24T14:24:46.491Z |
5564826 | 5564826 | 20241120032930_uefJG | UK00CA | 2024-11-21T14:18:05.782Z | 2024-11-24T14:24:44.631Z |
5564758 | 5564758 | 20241120032508_85llB | UK00CA | 2024-11-21T14:18:02.258Z | 2024-11-24T14:24:43.924Z |
5564377 | 5564377 | 20241120025050_zzCsN | UK00CA | 2024-11-21T14:17:31.153Z | 2024-11-24T14:24:42.733Z |
5564133 | 5564133 | 20241120023232_bHGjO | UK00CA | 2024-11-21T14:17:12.692Z | 2024-11-24T14:24:40.857Z |
5564111 | 5564111 | 20241120022838_6rg10 | UK00CA | 2024-11-21T14:17:10.604Z | 2024-11-24T14:24:40.777Z |
5562752 | 5562752 | 20241120000736_tfowD | UK00CA | 2024-11-21T14:15:19.848Z | 2024-11-24T14:24:33.683Z |
5562611 | 5562611 | 20241119235419_2P6k1 | UK00CA | 2024-11-21T14:15:13.426Z | 2024-11-24T14:24:33.069Z |
5562433 | 5562433 | 20241119233622_oWshd | UK00CA | 2024-11-21T14:14:49.068Z | 2024-11-24T14:24:32.094Z |
5562318 | 5562318 | 20241119232153_a15jI | UK00CA | 2024-11-21T14:14:41.809Z | 2024-11-24T14:24:31.755Z |
5562022 | 5562022 | 20241119224603_PsVD6 | UK00CA | 2024-11-21T14:14:20.314Z | 2024-11-24T14:24:30.366Z |
5561954 | 5561954 | 20241119223856_VpJYd | UK00CA | 2024-11-21T14:14:16.772Z | 2024-11-24T14:24:29.970Z |
5561876 | 5561876 | 20241119222412_MgUPG | UK00CA | 2024-11-21T14:14:11.927Z | 2024-11-24T14:24:29.580Z |
5561873 | 5561873 | 20241119222103_rra76 | UK00CA | 2024-11-21T14:14:11.668Z | 2024-11-24T14:24:29.569Z |
5561857 | 5561857 | 20241119221811_opfaj | UK00CA | 2024-11-21T14:14:10.302Z | 2024-11-24T14:24:29.489Z |
5561536 | 5561536 | 20241119205446_txdYY | UK00CA | 2024-11-21T14:13:25.337Z | 2024-11-24T14:24:27.508Z |
5561480 | 5561480 | 20241119204457_5vouy | UK00CA | 2024-11-21T14:13:20.311Z | 2024-11-24T14:24:27.046Z |
5558414 | 5558414 | 20241120060228_5NrA2 | UK00CA | 2024-11-21T14:03:13.141Z | 2024-11-24T14:22:51.435Z |
5558366 | 5558366 | 20241120055924_KFYWV | UK00CA | 2024-11-21T14:03:08.048Z | 2024-11-24T14:22:50.994Z |
5558260 | 5558260 | 20241120054954_SUK0A | UK00CA | 2024-11-21T14:02:52.628Z | 2024-11-24T14:22:49.468Z |
5557840 | 5557840 | 20241120051721_wS6c8 | UK00CA | 2024-11-21T14:01:53.811Z | 2024-11-24T14:22:45.387Z |
5557805 | 5557805 | 20241120051312_2zbrh | UK00CA | 2024-11-21T14:01:47.974Z | 2024-11-24T14:22:45.020Z |
5557342 | 5557342 | 20241120043939_s6VBt | UK00CA | 2024-11-21T14:00:34.235Z | 2024-11-24T14:22:40.029Z |
5557334 | 5557334 | 20241120043934_HcyN3 | UK00CA | 2024-11-21T14:00:33.563Z | 2024-11-24T14:22:40.022Z |
5532686 | 5532686 | 20241112055243_Qhw9u | UK00CA | 2024-11-13T14:17:09.090Z | 2024-11-20T14:26:25.645Z |
5532568 | 5532568 | 20241112053751_svKGI | UK00CA | 2024-11-13T14:17:00.765Z | 2024-11-20T14:26:24.856Z |
5532561 | 5532561 | 20241112053724_T22XF | UK00CA | 2024-11-13T14:16:59.780Z | 2024-11-20T14:26:24.577Z |
5530954 | 5530954 | 20241112030141_skQ3R | UK00CA | 2024-11-13T14:14:54.878Z | 2024-11-20T14:26:05.642Z |
5530941 | 5530941 | 20241112030112_UmMcE | UK00CA | 2024-11-13T14:14:52.423Z | 2024-11-20T14:26:05.382Z |
5530874 | 5530874 | 20241112025649_bhCAO | UK00CA | 2024-11-13T14:14:46.563Z | 2024-11-20T14:26:04.296Z |
5530599 | 5530599 | 20241112023233_jsGnK | UK00CA | 2024-11-13T14:14:24.311Z | 2024-11-20T14:26:01.922Z |
5530389 | 5530389 | 20241112021458_DZp1I | UK00CA | 2024-11-13T14:14:13.196Z | 2024-11-20T14:25:58.414Z |
5530170 | 5530170 | 20241112015313_GLukE | UK00CA | 2024-11-13T14:13:59.695Z | 2024-11-20T14:25:55.076Z |
5530022 | 5530022 | 20241112013720_WQZNh | UK00CA | 2024-11-13T14:13:40.239Z | 2024-11-20T14:25:53.081Z |
5530009 | 5530009 | 20241112013613_7O8C4 | UK00CA | 2024-11-13T14:13:38.142Z | 2024-11-20T14:25:52.453Z |
5529835 | 5529835 | 20241112010725_HZqjI | UK00CA | 2024-11-13T14:13:13.923Z | 2024-11-20T14:25:48.896Z |
5529757 | 5529757 | 20241112010220_38bUj | UK00CA | 2024-11-13T14:13:09.320Z | 2024-11-20T14:25:47.933Z |
5529747 | 5529747 | 20241112010120_YqAhD | UK00CA | 2024-11-13T14:13:08.732Z | 2024-11-20T14:25:47.889Z |
5529667 | 5529667 | 20241112005116_YhDOy | UK00CA | 2024-11-13T14:13:05.338Z | 2024-11-20T14:25:47.334Z |
5529659 | 5529659 | 20241112005045_13g4Q | UK00CA | 2024-11-13T14:13:04.735Z | 2024-11-20T14:25:47.186Z |
5529502 | 5529502 | 20241112002719_2mV38 | UK00CA | 2024-11-13T14:12:54.763Z | 2024-11-20T14:25:45.719Z |
5529160 | 5529160 | 20241111233849_FWfE7 | UK00CA | 2024-11-13T14:12:09.554Z | 2024-11-20T14:25:40.840Z |
5529046 | 5529046 | 20241111232240_40XSz | UK00CA | 2024-11-13T14:12:00.679Z | 2024-11-20T14:25:39.240Z |
5529026 | 5529026 | 20241111231939_bFfSs | UK00CA | 2024-11-13T14:11:58.313Z | 2024-11-20T14:25:38.616Z |
5528555 | 5528555 | 20241111213211_H4Q3o | UK00CA | 2024-11-13T14:11:05.855Z | 2024-11-20T14:25:32.130Z |
5482094 | 5482094 | 20241104210434_tPnmu | UK00CA | 2024-11-06T14:12:22.329Z | 2024-11-13T14:27:33.876Z |
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 |
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);