participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,617 rows where station_code = "UK00AF" 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 |
---|---|---|---|---|---|
5439791 | 5439791 | 20241030203300_HkYnL | UK00AF | 2024-11-01T12:14:29.395Z | 2024-11-08T14:23:05.705Z |
5439710 | 5439710 | 20241030202109_Nr1Qd | UK00AF | 2024-11-01T12:14:12.959Z | 2024-11-08T14:23:04.964Z |
5430894 | 5430894 | 20241028235940_5HrwS | UK00AF | 2024-10-31T12:19:15.970Z | 2024-11-06T14:27:22.139Z |
5430867 | 5430867 | 20241028235410_efkh2 | UK00AF | 2024-10-31T12:19:12.142Z | 2024-11-06T14:27:21.940Z |
5430860 | 5430860 | 20241028235319_27tOC | UK00AF | 2024-10-31T12:19:11.443Z | 2024-11-06T14:27:21.849Z |
5430852 | 5430852 | 20241028235237_FtEm0 | UK00AF | 2024-10-31T12:19:10.374Z | 2024-11-06T14:27:21.815Z |
5422999 | 5422999 | 20241027033453_49xrV | UK00AF | 2024-10-30T12:22:58.323Z | 2024-11-04T14:28:59.809Z |
5422990 | 5422990 | 20241027013029_R2UDR | UK00AF | 2024-10-30T12:22:38.855Z | 2024-11-04T14:28:55.509Z |
5418172 | 5418172 | 20241027200445_wisrL | UK00AF | 2024-10-30T12:15:02.656Z | 2024-11-05T14:27:09.414Z |
5417699 | 5417699 | 20241027190231_u4h2Z | UK00AF | 2024-10-30T12:14:14.150Z | 2024-11-05T14:27:08.086Z |
5410506 | 5410506 | 20241027051551_t69Ip | UK00AF | 2024-10-29T12:17:57.133Z | 2024-11-04T14:29:04.656Z |
5410104 | 5410104 | 20241027045401_25B5I | UK00AF | 2024-10-29T12:17:48.055Z | 2024-11-04T14:29:03.786Z |
5410077 | 5410077 | 20241027045200_Qcfdh | UK00AF | 2024-10-29T12:17:47.152Z | 2024-11-04T14:29:03.660Z |
5410020 | 5410020 | 20241027044750_J1byC | UK00AF | 2024-10-29T12:17:45.924Z | 2024-11-04T14:29:03.445Z |
5409955 | 5409955 | 20241027044414_ziM9D | UK00AF | 2024-10-29T12:17:44.918Z | 2024-11-04T14:29:03.108Z |
5409446 | 5409446 | 20241027041830_tIy3I | UK00AF | 2024-10-29T12:17:24.251Z | 2024-11-04T14:29:01.741Z |
5409349 | 5409349 | 20241027041203_ktV9o | UK00AF | 2024-10-29T12:17:17.074Z | 2024-11-04T14:29:01.595Z |
5409328 | 5409328 | 20241027041115_SFESB | UK00AF | 2024-10-29T12:17:16.723Z | 2024-11-04T14:29:01.584Z |
5409164 | 5409164 | 20241027040335_t2uFM | UK00AF | 2024-10-29T12:17:09.339Z | 2024-11-04T14:29:01.230Z |
5408934 | 5408934 | 20241027035037_CA3NZ | UK00AF | 2024-10-29T12:16:57.440Z | 2024-11-04T14:29:00.828Z |
5408833 | 5408833 | 20241027034515_XxIix | UK00AF | 2024-10-29T12:16:54.393Z | 2024-11-04T14:29:00.613Z |
5408672 | 5408672 | 20241027033536_LwT62 | UK00AF | 2024-10-29T12:16:43.888Z | 2024-11-04T14:28:59.829Z |
5408652 | 5408652 | 20241027033431_fnzhI | UK00AF | 2024-10-29T12:16:42.323Z | 2024-11-04T14:28:59.779Z |
5408619 | 5408619 | 20241027033232_wxbnM | UK00AF | 2024-10-29T12:16:39.508Z | 2024-11-04T14:28:59.678Z |
5408293 | 5408293 | 20241027032153_H745r | UK00AF | 2024-10-29T12:16:21.220Z | 2024-11-04T14:28:59.065Z |
5408255 | 5408255 | 20241027031943_YdRX2 | UK00AF | 2024-10-29T12:16:19.995Z | 2024-11-04T14:28:59.037Z |
5408154 | 5408154 | 20241027031142_IB6ey | UK00AF | 2024-10-29T12:16:12.462Z | 2024-11-04T14:28:58.935Z |
5408149 | 5408149 | 20241027031142_2Iczn | UK00AF | 2024-10-29T12:16:12.105Z | 2024-11-04T14:28:58.920Z |
5408074 | 5408074 | 20241027030532_rtsX5 | UK00AF | 2024-10-29T12:16:03.739Z | 2024-11-04T14:28:58.750Z |
5407971 | 5407971 | 20241027030048_OBkfw | UK00AF | 2024-10-29T12:15:55.978Z | 2024-11-04T14:28:58.535Z |
5407967 | 5407967 | 20241027030033_2mrzP | UK00AF | 2024-10-29T12:15:55.667Z | 2024-11-04T14:28:58.534Z |
5407751 | 5407751 | 20241027025023_O1W3U | UK00AF | 2024-10-29T12:15:36.986Z | 2024-11-04T14:28:58.093Z |
5407484 | 5407484 | 20241027023845_UqzIV | UK00AF | 2024-10-29T12:15:26.626Z | 2024-11-04T14:28:57.767Z |
5407401 | 5407401 | 20241027023438_s3aUe | UK00AF | 2024-10-29T12:15:23.661Z | 2024-11-04T14:28:57.489Z |
5406991 | 5406991 | 20241027021551_326ji | UK00AF | 2024-10-29T12:15:06.048Z | 2024-11-04T14:28:56.759Z |
5406834 | 5406834 | 20241027020212_iXR1P | UK00AF | 2024-10-29T12:14:47.863Z | 2024-11-04T14:28:56.490Z |
5406801 | 5406801 | 20241027020000_RsDrd | UK00AF | 2024-10-29T12:14:43.350Z | 2024-11-04T14:28:56.400Z |
5406688 | 5406688 | 20241027015356_gDssW | UK00AF | 2024-10-29T12:14:32.240Z | 2024-11-04T14:28:56.033Z |
5406601 | 5406601 | 20241027014715_3vhRa | UK00AF | 2024-10-29T12:14:23.243Z | 2024-11-04T14:28:55.895Z |
5406572 | 5406572 | 20241027014608_S6zYW | UK00AF | 2024-10-29T12:14:22.328Z | 2024-11-04T14:28:55.884Z |
5406480 | 5406480 | 20241027013944_1aYMh | UK00AF | 2024-10-29T12:14:12.262Z | 2024-11-04T14:28:55.740Z |
5406456 | 5406456 | 20241027013824_kkpkl | UK00AF | 2024-10-29T12:14:10.696Z | 2024-11-04T14:28:55.715Z |
5406125 | 5406125 | 20241027011754_A24cT | UK00AF | 2024-10-29T12:13:52.832Z | 2024-11-04T14:28:55.149Z |
5405949 | 5405949 | 20241027010959_x3nGo | UK00AF | 2024-10-29T12:13:37.832Z | 2024-11-04T14:28:54.663Z |
5405839 | 5405839 | 20241027010247_3H2ma | UK00AF | 2024-10-29T12:13:21.456Z | 2024-11-04T14:28:54.421Z |
5405592 | 5405592 | 20241027004711_mp5yq | UK00AF | 2024-10-29T12:13:03.710Z | 2024-11-04T14:28:53.648Z |
5404891 | 5404891 | 20241026235904_JgdKl | UK00AF | 2024-10-29T12:12:05.493Z | 2024-11-04T14:28:52.372Z |
5404632 | 5404632 | 20241026234105_8I0kh | UK00AF | 2024-10-29T12:11:47.007Z | 2024-11-04T14:28:51.446Z |
5404429 | 5404429 | 20241026232607_E4IWH | UK00AF | 2024-10-29T12:11:23.907Z | 2024-11-04T14:28:50.995Z |
5404393 | 5404393 | 20241026232245_d3wlO | UK00AF | 2024-10-29T12:11:18.023Z | 2024-11-04T14:28:50.846Z |
5404290 | 5404290 | 20241026231423_MNKg2 | UK00AF | 2024-10-29T12:11:05.042Z | 2024-11-04T14:28:50.582Z |
5403961 | 5403961 | 20241026224822_NUqTY | UK00AF | 2024-10-29T12:10:38.410Z | 2024-11-04T14:28:50.109Z |
5403912 | 5403912 | 20241026224510_atRJZ | UK00AF | 2024-10-29T12:10:26.921Z | 2024-11-04T14:28:50.002Z |
5403624 | 5403624 | 20241026221633_TxrGX | UK00AF | 2024-10-29T12:10:02.407Z | 2024-11-04T14:28:49.339Z |
5403514 | 5403514 | 20241026220528_LK5cF | UK00AF | 2024-10-29T12:09:39.896Z | 2024-11-04T14:28:49.094Z |
5403447 | 5403447 | 20241026215708_dbU80 | UK00AF | 2024-10-29T12:09:31.581Z | 2024-11-04T14:28:48.876Z |
5403393 | 5403393 | 20241026215039_3i3Uv | UK00AF | 2024-10-29T12:09:26.816Z | 2024-11-04T14:28:48.683Z |
5403014 | 5403014 | 20241026210248_YapMr | UK00AF | 2024-10-29T12:08:44.520Z | 2024-11-04T14:28:47.372Z |
5403010 | 5403010 | 20241026210152_4Davd | UK00AF | 2024-10-29T12:08:44.183Z | 2024-11-04T14:28:47.346Z |
5400470 | 5400470 | 20241025012145_PFRAy | UK00AF | 2024-10-28T12:22:53.335Z | 2024-11-02T12:28:31.552Z |
5397920 | 5397920 | 20241026020645_1TBcY | UK00AF | 2024-10-28T12:18:50.392Z | 2024-11-03T14:27:34.533Z |
5397653 | 5397653 | 20241026014543_c6IEs | UK00AF | 2024-10-28T12:18:31.034Z | 2024-11-03T14:27:33.666Z |
5397617 | 5397617 | 20241026014323_9073P | UK00AF | 2024-10-28T12:18:30.272Z | 2024-11-03T14:27:33.607Z |
5397584 | 5397584 | 20241026014147_o1YmO | UK00AF | 2024-10-28T12:18:28.749Z | 2024-11-03T14:27:33.431Z |
5397556 | 5397556 | 20241026013937_hXSjq | UK00AF | 2024-10-28T12:18:27.207Z | 2024-11-03T14:27:33.376Z |
5397398 | 5397398 | 20241026012513_qNFwW | UK00AF | 2024-10-28T12:18:19.510Z | 2024-11-03T14:27:32.774Z |
5397147 | 5397147 | 20241026010528_7ELys | UK00AF | 2024-10-28T12:18:09.299Z | 2024-11-03T14:27:32.098Z |
5397000 | 5397000 | 20241026005514_5o4vq | UK00AF | 2024-10-28T12:18:01.791Z | 2024-11-03T14:27:31.659Z |
5396983 | 5396983 | 20241026005427_6Xeat | UK00AF | 2024-10-28T12:18:01.546Z | 2024-11-03T14:27:31.616Z |
5396980 | 5396980 | 20241026005415_7NryW | UK00AF | 2024-10-28T12:18:01.532Z | 2024-11-03T14:27:31.612Z |
5396925 | 5396925 | 20241026004645_A43DX | UK00AF | 2024-10-28T12:17:59.516Z | 2024-11-03T14:27:31.342Z |
5396657 | 5396657 | 20241026001954_3IKcj | UK00AF | 2024-10-28T12:17:52.154Z | 2024-11-03T14:27:30.546Z |
5396530 | 5396530 | 20241026000941_62k6o | UK00AF | 2024-10-28T12:17:48.833Z | 2024-11-03T14:27:30.068Z |
5396523 | 5396523 | 20241026000934_7LQKz | UK00AF | 2024-10-28T12:17:48.590Z | 2024-11-03T14:27:30.054Z |
5396446 | 5396446 | 20241026000512_DSlgK | UK00AF | 2024-10-28T12:17:43.280Z | 2024-11-03T14:27:29.881Z |
5396407 | 5396407 | 20241026000202_jkMCJ | UK00AF | 2024-10-28T12:17:39.412Z | 2024-11-03T14:27:29.737Z |
5396401 | 5396401 | 20241026000152_9T5zA | UK00AF | 2024-10-28T12:17:38.805Z | 2024-11-03T14:27:29.720Z |
5393754 | 5393754 | 20241025183807_Nk5pz | UK00AF | 2024-10-28T12:13:13.262Z | 2024-11-03T14:27:17.888Z |
5387892 | 5387892 | 20241025033553_C1cTv | UK00AF | 2024-10-27T12:21:47.557Z | 2024-11-02T12:28:33.384Z |
5387712 | 5387712 | 20241025031057_axTGV | UK00AF | 2024-10-27T12:21:37.144Z | 2024-11-02T12:28:33.152Z |
5387622 | 5387622 | 20241025030248_cHNIP | UK00AF | 2024-10-27T12:21:31.247Z | 2024-11-02T12:28:32.844Z |
5387459 | 5387459 | 20241025024011_72Mkt | UK00AF | 2024-10-27T12:21:21.984Z | 2024-11-02T12:28:32.609Z |
5387227 | 5387227 | 20241025021414_nFi8t | UK00AF | 2024-10-27T12:21:01.615Z | 2024-11-02T12:28:32.256Z |
5387183 | 5387183 | 20241025020812_wAgzs | UK00AF | 2024-10-27T12:20:58.951Z | 2024-11-02T12:28:32.197Z |
5387174 | 5387174 | 20241025020749_U34Ok | UK00AF | 2024-10-27T12:20:58.036Z | 2024-11-02T12:28:32.170Z |
5387169 | 5387169 | 20241025020743_aCFaz | UK00AF | 2024-10-27T12:20:57.952Z | 2024-11-02T12:28:32.170Z |
5387057 | 5387057 | 20241025015604_oYw4t | UK00AF | 2024-10-27T12:20:50.134Z | 2024-11-02T12:28:32.051Z |
5386990 | 5386990 | 20241025014704_xkJ9j | UK00AF | 2024-10-27T12:20:46.009Z | 2024-11-02T12:28:31.792Z |
5386957 | 5386957 | 20241025014359_7O5X9 | UK00AF | 2024-10-27T12:20:43.237Z | 2024-11-02T12:28:31.754Z |
5386928 | 5386928 | 20241025014139_W6wM7 | UK00AF | 2024-10-27T12:20:39.968Z | 2024-11-02T12:28:31.700Z |
5386754 | 5386754 | 20241025012144_v71pW | UK00AF | 2024-10-27T12:20:25.125Z | 2024-11-02T12:28:31.546Z |
5386632 | 5386632 | 20241025010714_bQdE9 | UK00AF | 2024-10-27T12:20:12.397Z | 2024-11-02T12:28:31.402Z |
5386489 | 5386489 | 20241025004810_rd2zz | UK00AF | 2024-10-27T12:20:07.784Z | 2024-11-02T12:28:31.272Z |
5386421 | 5386421 | 20241025003913_xNtfa | UK00AF | 2024-10-27T12:20:04.041Z | 2024-11-02T12:28:31.211Z |
5386407 | 5386407 | 20241025003704_Qxtv0 | UK00AF | 2024-10-27T12:20:03.648Z | 2024-11-02T12:28:31.196Z |
5386347 | 5386347 | 20241025002759_mOXIH | UK00AF | 2024-10-27T12:20:00.978Z | 2024-11-02T12:28:31.104Z |
5386303 | 5386303 | 20241025002357_hD3FI | UK00AF | 2024-10-27T12:19:59.142Z | 2024-11-02T12:28:30.946Z |
5386259 | 5386259 | 20241025001851_LEGHc | UK00AF | 2024-10-27T12:19:57.327Z | 2024-11-02T12:28:30.880Z |
5386178 | 5386178 | 20241025001148_jxwvP | UK00AF | 2024-10-27T12:19:54.033Z | 2024-11-02T12:28:30.825Z |
5386028 | 5386028 | 20241024235423_LicKM | UK00AF | 2024-10-27T12:19:46.365Z | 2024-11-02T12:28:30.590Z |
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);