participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
7,851 rows where station_code = "UK006B" 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 |
---|---|---|---|---|---|
5441886 | 5441886 | 20241029235607_GfAsF | UK006B | 2024-11-01T12:19:11.146Z | 2024-11-07T14:26:44.231Z |
5441686 | 5441686 | 20241029231033_zoQCL | UK006B | 2024-11-01T12:18:52.973Z | 2024-11-07T14:26:42.995Z |
5441614 | 5441614 | 20241029225045_1BHJl | UK006B | 2024-11-01T12:18:47.912Z | 2024-11-07T14:26:42.752Z |
5441529 | 5441529 | 20241029223132_lpjfL | UK006B | 2024-11-01T12:18:42.945Z | 2024-11-07T14:26:42.615Z |
5441329 | 5441329 | 20241029214306_w3mEN | UK006B | 2024-11-01T12:18:26.469Z | 2024-11-07T14:26:41.722Z |
5441239 | 5441239 | 20241029211820_bMcvI | UK006B | 2024-11-01T12:18:20.749Z | 2024-11-07T14:26:41.357Z |
5433648 | 5433648 | 20241029203618_4yN3D | UK006B | 2024-10-31T12:22:26.106Z | 2024-11-07T14:26:40.486Z |
5433451 | 5433451 | 20241029200007_RdE4V | UK006B | 2024-10-31T12:22:16.541Z | 2024-11-07T14:26:39.654Z |
5422998 | 5422998 | 20241027033453_49xrV | UK006B | 2024-10-30T12:22:58.298Z | 2024-11-04T14:28:59.809Z |
5410191 | 5410191 | 20241027045924_nrQwp | UK006B | 2024-10-29T12:17:50.511Z | 2024-11-04T14:29:04.035Z |
5410115 | 5410115 | 20241027045423_jYoi2 | UK006B | 2024-10-29T12:17:48.284Z | 2024-11-04T14:29:03.794Z |
5409970 | 5409970 | 20241027044630_VpkuQ | UK006B | 2024-10-29T12:17:45.189Z | 2024-11-04T14:29:03.165Z |
5409861 | 5409861 | 20241027043845_IEzAP | UK006B | 2024-10-29T12:17:42.495Z | 2024-11-04T14:29:02.822Z |
5409826 | 5409826 | 20241027043718_TPpRm | UK006B | 2024-10-29T12:17:41.961Z | 2024-11-04T14:29:02.773Z |
5409755 | 5409755 | 20241027043416_YLCoo | UK006B | 2024-10-29T12:17:40.250Z | 2024-11-04T14:29:02.617Z |
5409619 | 5409619 | 20241027042822_BqxLZ | UK006B | 2024-10-29T12:17:33.873Z | 2024-11-04T14:29:02.017Z |
5409528 | 5409528 | 20241027042329_wiHUZ | UK006B | 2024-10-29T12:17:28.485Z | 2024-11-04T14:29:01.938Z |
5409457 | 5409457 | 20241027041930_hQEPn | UK006B | 2024-10-29T12:17:25.074Z | 2024-11-04T14:29:01.830Z |
5409425 | 5409425 | 20241027041722_Iz5YN | UK006B | 2024-10-29T12:17:22.888Z | 2024-11-04T14:29:01.729Z |
5408838 | 5408838 | 20241027034524_MdEft | UK006B | 2024-10-29T12:16:54.655Z | 2024-11-04T14:29:00.616Z |
5408677 | 5408677 | 20241027033613_0V4hV | UK006B | 2024-10-29T12:16:44.859Z | 2024-11-04T14:29:00.301Z |
5408648 | 5408648 | 20241027033423_U9diu | UK006B | 2024-10-29T12:16:42.188Z | 2024-11-04T14:28:59.776Z |
5408218 | 5408218 | 20241027031655_u4K2R | UK006B | 2024-10-29T12:16:17.424Z | 2024-11-04T14:28:58.999Z |
5408070 | 5408070 | 20241027030532_rtsX5 | UK006B | 2024-10-29T12:16:03.739Z | 2024-11-04T14:28:58.750Z |
5407844 | 5407844 | 20241027025517_nXNAb | UK006B | 2024-10-29T12:15:48.501Z | 2024-11-04T14:28:58.242Z |
5407747 | 5407747 | 20241027025023_O1W3U | UK006B | 2024-10-29T12:15:36.986Z | 2024-11-04T14:28:58.092Z |
5407258 | 5407258 | 20241027022841_QfjO2 | UK006B | 2024-10-29T12:15:19.103Z | 2024-11-04T14:28:57.274Z |
5406951 | 5406951 | 20241027021252_Iw03g | UK006B | 2024-10-29T12:15:02.586Z | 2024-11-04T14:28:56.728Z |
5406698 | 5406698 | 20241027015528_SZFYe | UK006B | 2024-10-29T12:14:33.158Z | 2024-11-04T14:28:56.043Z |
5406453 | 5406453 | 20241027013824_kkpkl | UK006B | 2024-10-29T12:14:10.696Z | 2024-11-04T14:28:55.715Z |
5405974 | 5405974 | 20241027011126_7gWv5 | UK006B | 2024-10-29T12:13:42.790Z | 2024-11-04T14:28:54.803Z |
5405928 | 5405928 | 20241027010849_WtxI4 | UK006B | 2024-10-29T12:13:34.531Z | 2024-11-04T14:28:54.620Z |
5405727 | 5405727 | 20241027005443_3f52Q | UK006B | 2024-10-29T12:13:10.863Z | 2024-11-04T14:28:54.119Z |
5405693 | 5405693 | 20241027005351_oqV7D | UK006B | 2024-10-29T12:13:09.984Z | 2024-11-04T14:28:53.917Z |
5405682 | 5405682 | 20241027005316_bssPK | UK006B | 2024-10-29T12:13:09.536Z | 2024-11-04T14:28:53.898Z |
5405673 | 5405673 | 20241027005237_6cjxi | UK006B | 2024-10-29T12:13:09.047Z | 2024-11-04T14:28:53.887Z |
5405422 | 5405422 | 20241027003309_mIghY | UK006B | 2024-10-29T12:12:55.159Z | 2024-11-04T14:28:53.464Z |
5405036 | 5405036 | 20241027001001_5ODqS | UK006B | 2024-10-29T12:12:19.052Z | 2024-11-04T14:28:52.615Z |
5404955 | 5404955 | 20241027000250_hZG38 | UK006B | 2024-10-29T12:12:10.720Z | 2024-11-04T14:28:52.451Z |
5404909 | 5404909 | 20241027000030_kqAoN | UK006B | 2024-10-29T12:12:06.753Z | 2024-11-04T14:28:52.402Z |
5404628 | 5404628 | 20241026234105_8I0kh | UK006B | 2024-10-29T12:11:47.007Z | 2024-11-04T14:28:51.446Z |
5404465 | 5404465 | 20241026232939_9d72X | UK006B | 2024-10-29T12:11:31.528Z | 2024-11-04T14:28:51.080Z |
5404086 | 5404086 | 20241026225640_Mx9Bw | UK006B | 2024-10-29T12:10:52.615Z | 2024-11-04T14:28:50.320Z |
5403669 | 5403669 | 20241026222240_C47Zp | UK006B | 2024-10-29T12:10:06.535Z | 2024-11-04T14:28:49.438Z |
5403433 | 5403433 | 20241026215616_gM3Z8 | UK006B | 2024-10-29T12:09:30.127Z | 2024-11-04T14:28:48.821Z |
5403345 | 5403345 | 20241026214332_3Ty5J | UK006B | 2024-10-29T12:09:23.415Z | 2024-11-04T14:28:48.440Z |
5402980 | 5402980 | 20241026205724_0uW0d | UK006B | 2024-10-29T12:08:42.014Z | 2024-11-04T14:28:47.254Z |
5402013 | 5402013 | 20241026182437_Npo1r | UK006B | 2024-10-29T12:06:04.045Z | 2024-11-04T14:28:41.575Z |
5399933 | 5399933 | 20241026051344_tLaUs | UK006B | 2024-10-28T12:20:17.143Z | 2024-11-03T14:27:40.871Z |
5399778 | 5399778 | 20241026050210_q3etH | UK006B | 2024-10-28T12:20:10.902Z | 2024-11-03T14:27:40.493Z |
5399750 | 5399750 | 20241026045922_Yn5dP | UK006B | 2024-10-28T12:20:10.092Z | 2024-11-03T14:27:40.420Z |
5399642 | 5399642 | 20241026044418_1ORQT | UK006B | 2024-10-28T12:20:04.600Z | 2024-11-03T14:27:40.159Z |
5399515 | 5399515 | 20241026043056_RzaNs | UK006B | 2024-10-28T12:20:01.428Z | 2024-11-03T14:27:39.902Z |
5399412 | 5399412 | 20241026041555_liYDh | UK006B | 2024-10-28T12:19:58.541Z | 2024-11-03T14:27:39.656Z |
5399354 | 5399354 | 20241026041145_Q3JZ0 | UK006B | 2024-10-28T12:19:55.694Z | 2024-11-03T14:27:39.537Z |
5399346 | 5399346 | 20241026041141_BepxY | UK006B | 2024-10-28T12:19:55.373Z | 2024-11-03T14:27:39.527Z |
5399297 | 5399297 | 20241026040914_uoC5V | UK006B | 2024-10-28T12:19:53.561Z | 2024-11-03T14:27:39.350Z |
5399237 | 5399237 | 20241026040412_FjTZg | UK006B | 2024-10-28T12:19:52.306Z | 2024-11-03T14:27:39.275Z |
5399081 | 5399081 | 20241026034919_IsFTH | UK006B | 2024-10-28T12:19:48.143Z | 2024-11-03T14:27:39.008Z |
5399069 | 5399069 | 20241026034824_qfmVA | UK006B | 2024-10-28T12:19:47.164Z | 2024-11-03T14:27:38.960Z |
5399000 | 5399000 | 20241026034411_4L5Kh | UK006B | 2024-10-28T12:19:44.002Z | 2024-11-03T14:27:38.857Z |
5398995 | 5398995 | 20241026034411_0wBnx | UK006B | 2024-10-28T12:19:43.957Z | 2024-11-03T14:27:38.856Z |
5398829 | 5398829 | 20241026033159_tE9sf | UK006B | 2024-10-28T12:19:35.734Z | 2024-11-03T14:27:38.273Z |
5398714 | 5398714 | 20241026032144_Fl0F8 | UK006B | 2024-10-28T12:19:29.484Z | 2024-11-03T14:27:37.888Z |
5398648 | 5398648 | 20241026031459_Sb0av | UK006B | 2024-10-28T12:19:25.389Z | 2024-11-03T14:27:37.450Z |
5398523 | 5398523 | 20241026030532_aH7kG | UK006B | 2024-10-28T12:19:20.808Z | 2024-11-03T14:27:36.742Z |
5398293 | 5398293 | 20241026024255_mbexz | UK006B | 2024-10-28T12:19:10.091Z | 2024-11-03T14:27:35.872Z |
5398074 | 5398074 | 20241026022220_sB5N3 | UK006B | 2024-10-28T12:18:59.512Z | 2024-11-03T14:27:35.264Z |
5397677 | 5397677 | 20241026014716_XVu2Z | UK006B | 2024-10-28T12:18:33.407Z | 2024-11-03T14:27:33.725Z |
5397553 | 5397553 | 20241026013937_hXSjq | UK006B | 2024-10-28T12:18:27.207Z | 2024-11-03T14:27:33.376Z |
5397040 | 5397040 | 20241026005836_gvWzk | UK006B | 2024-10-28T12:18:04.295Z | 2024-11-03T14:27:31.946Z |
5396997 | 5396997 | 20241026005514_5o4vq | UK006B | 2024-10-28T12:18:01.791Z | 2024-11-03T14:27:31.659Z |
5396643 | 5396643 | 20241026001938_dm3er | UK006B | 2024-10-28T12:17:52.039Z | 2024-11-03T14:27:30.545Z |
5395300 | 5395300 | 20241025223130_FI0FP | UK006B | 2024-10-28T12:16:05.838Z | 2024-11-03T14:27:24.903Z |
5385735 | 5385735 | 20241024232305_gkBON | UK006B | 2024-10-27T12:19:20.209Z | 2024-11-02T12:28:30.128Z |
5385723 | 5385723 | 20241024232141_Oi2Zp | UK006B | 2024-10-27T12:19:19.731Z | 2024-11-02T12:28:30.103Z |
5385698 | 5385698 | 20241024231951_Cs1DG | UK006B | 2024-10-27T12:19:17.668Z | 2024-11-02T12:28:30.060Z |
5385672 | 5385672 | 20241024231706_3EVco | UK006B | 2024-10-27T12:19:15.481Z | 2024-11-02T12:28:30.026Z |
5385626 | 5385626 | 20241024231028_BaraV | UK006B | 2024-10-27T12:19:11.788Z | 2024-11-02T12:28:29.996Z |
5385508 | 5385508 | 20241024225515_xYHc2 | UK006B | 2024-10-27T12:19:00.752Z | 2024-11-02T12:28:29.889Z |
5385489 | 5385489 | 20241024225328_njVJz | UK006B | 2024-10-27T12:18:59.769Z | 2024-11-02T12:28:29.882Z |
5385394 | 5385394 | 20241024223618_2Fmt2 | UK006B | 2024-10-27T12:18:50.324Z | 2024-11-02T12:28:29.705Z |
5385345 | 5385345 | 20241024222746_uF1qN | UK006B | 2024-10-27T12:18:46.692Z | 2024-11-02T12:28:29.654Z |
5384963 | 5384963 | 20241024212517_03Ftp | UK006B | 2024-10-27T12:18:04.429Z | 2024-11-02T12:28:28.796Z |
5384897 | 5384897 | 20241024211316_agnBZ | UK006B | 2024-10-27T12:17:56.655Z | 2024-11-02T12:28:28.579Z |
5384622 | 5384622 | 20241024202935_nE6VV | UK006B | 2024-10-27T12:17:19.806Z | 2024-11-02T12:28:27.442Z |
5384440 | 5384440 | 20241024200826_IOL3Z | UK006B | 2024-10-27T12:17:04.595Z | 2024-11-02T12:28:27.199Z |
5384026 | 5384026 | 20241024192555_qmi2x | UK006B | 2024-10-27T12:16:43.608Z | 2024-11-02T12:28:26.674Z |
5383786 | 5383786 | 20241024185907_cHM7V | UK006B | 2024-10-27T12:16:09.658Z | 2024-11-02T12:28:26.341Z |
5383335 | 5383335 | 20241024180956_G1gOy | UK006B | 2024-10-27T12:15:16.180Z | 2024-11-02T12:28:24.959Z |
5376325 | 5376325 | 20241024035140_ZaP1s | UK006B | 2024-10-26T12:21:56.829Z | 2024-11-01T12:27:01.501Z |
5374648 | 5374648 | 20241024023804_c6gNt | UK006B | 2024-10-26T12:20:55.523Z | 2024-11-01T12:26:59.526Z |
5374117 | 5374117 | 20241024021106_DwKQA | UK006B | 2024-10-26T12:20:37.507Z | 2024-11-01T12:26:58.704Z |
5373768 | 5373768 | 20241024015342_wGAX5 | UK006B | 2024-10-26T12:20:25.518Z | 2024-11-01T12:26:58.473Z |
5373702 | 5373702 | 20241024015108_evVDU | UK006B | 2024-10-26T12:20:21.968Z | 2024-11-01T12:26:58.378Z |
5373481 | 5373481 | 20241024013922_JpXbm | UK006B | 2024-10-26T12:20:13.723Z | 2024-11-01T12:26:58.293Z |
5373018 | 5373018 | 20241024012016_zXKw5 | UK006B | 2024-10-26T12:19:53.929Z | 2024-11-01T12:26:58.096Z |
5372914 | 5372914 | 20241024011343_DSdbL | UK006B | 2024-10-26T12:19:47.864Z | 2024-11-01T12:26:58.025Z |
5372878 | 5372878 | 20241024011240_SHtBZ | UK006B | 2024-10-26T12:19:46.560Z | 2024-11-01T12:26:58.012Z |
5372849 | 5372849 | 20241024011155_eMD1T | UK006B | 2024-10-26T12:19:45.941Z | 2024-11-01T12:26:58.003Z |
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);