participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,999 rows where station_code = "UK0081" 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 |
---|---|---|---|---|---|
5565491 | 5565491 | 20241120043120_rewQ2 | UK0081 | 2024-11-21T14:18:51.105Z | 2024-11-21T14:18:54.219Z |
5565434 | 5565434 | 20241120042545_2k62R | UK0081 | 2024-11-21T14:18:49.054Z | 2024-11-21T14:18:54.208Z |
5565430 | 5565430 | 20241120042545_9f3bA | UK0081 | 2024-11-21T14:18:48.971Z | 2024-11-21T14:18:54.207Z |
5564861 | 5564861 | 20241120033157_Thqa2 | UK0081 | 2024-11-21T14:18:08.959Z | 2024-11-21T14:18:54.112Z |
5564473 | 5564473 | 20241120025913_nSexN | UK0081 | 2024-11-21T14:17:39.629Z | 2024-11-21T14:18:54.047Z |
5564190 | 5564190 | 20241120023715_A3zgm | UK0081 | 2024-11-21T14:17:17.264Z | 2024-11-21T14:18:54.000Z |
5564166 | 5564166 | 20241120023435_PrZva | UK0081 | 2024-11-21T14:17:15.366Z | 2024-11-21T14:18:53.994Z |
5564097 | 5564097 | 20241120022833_sBY62 | UK0081 | 2024-11-21T14:17:08.830Z | 2024-11-21T14:18:53.979Z |
5564002 | 5564002 | 20241120022227_dHPGI | UK0081 | 2024-11-21T14:17:03.892Z | 2024-11-21T14:18:53.962Z |
5563381 | 5563381 | 20241120012346_aBu72 | UK0081 | 2024-11-21T14:16:01.608Z | 2024-11-21T14:18:53.845Z |
5563213 | 5563213 | 20241120010500_639EG | UK0081 | 2024-11-21T14:15:40.430Z | 2024-11-21T14:18:53.808Z |
5562909 | 5562909 | 20241120002645_4Azje | UK0081 | 2024-11-21T14:15:27.105Z | 2024-11-21T14:18:53.759Z |
5561814 | 5561814 | 20241119221341_YuC2j | UK0081 | 2024-11-21T14:14:08.148Z | 2024-11-21T14:18:53.586Z |
5561624 | 5561624 | 20241119211653_DqhUp | UK0081 | 2024-11-21T14:13:36.094Z | 2024-11-21T14:18:53.550Z |
5561598 | 5561598 | 20241119211227_kidUr | UK0081 | 2024-11-21T14:13:32.817Z | 2024-11-21T14:18:53.546Z |
5561558 | 5561558 | 20241119210217_N64Q2 | UK0081 | 2024-11-21T14:13:27.617Z | 2024-11-21T14:18:53.538Z |
5561525 | 5561525 | 20241119205228_oeFAb | UK0081 | 2024-11-21T14:13:24.247Z | 2024-11-21T14:18:53.529Z |
5561179 | 5561179 | 20241119185340_gYcbC | UK0081 | 2024-11-21T14:12:33.652Z | 2024-11-21T14:18:53.426Z |
5561142 | 5561142 | 20241119183016_6M98Z | UK0081 | 2024-11-21T14:12:27.856Z | 2024-11-21T14:18:53.414Z |
5561116 | 5561116 | 20241119181937_7sR1B | UK0081 | 2024-11-21T14:12:25.245Z | 2024-11-21T14:18:53.407Z |
5561100 | 5561100 | 20241119181157_XvsRa | UK0081 | 2024-11-21T14:12:22.978Z | 2024-11-21T14:18:53.403Z |
5558579 | 5558579 | 20241120064239_i4uEM | UK0081 | 2024-11-21T14:03:44.143Z | 2024-11-21T14:03:44.143Z |
5558567 | 5558567 | 20241120063658_AlWB6 | UK0081 | 2024-11-21T14:03:42.017Z | 2024-11-21T14:03:42.017Z |
5558559 | 5558559 | 20241120062959_v64Lp | UK0081 | 2024-11-21T14:03:39.302Z | 2024-11-21T14:03:39.302Z |
5558552 | 5558552 | 20241120062814_tB1y9 | UK0081 | 2024-11-21T14:03:37.516Z | 2024-11-21T14:03:37.516Z |
5558503 | 5558503 | 20241120061837_4Ncnq | UK0081 | 2024-11-21T14:03:27.156Z | 2024-11-21T14:03:27.156Z |
5558352 | 5558352 | 20241120055832_3efen | UK0081 | 2024-11-21T14:03:05.407Z | 2024-11-21T14:03:05.407Z |
5558162 | 5558162 | 20241120054131_EQVA6 | UK0081 | 2024-11-21T14:02:37.909Z | 2024-11-21T14:02:37.909Z |
5558057 | 5558057 | 20241120053332_5NbPT | UK0081 | 2024-11-21T14:02:24.724Z | 2024-11-21T14:02:24.724Z |
5557466 | 5557466 | 20241120044846_OwiXc | UK0081 | 2024-11-21T14:00:57.273Z | 2024-11-21T14:00:57.273Z |
5557440 | 5557440 | 20241120044533_vToUs | UK0081 | 2024-11-21T14:00:50.632Z | 2024-11-21T14:00:50.632Z |
5557235 | 5557235 | 20241119044311_h1IVk | UK0081 | 2024-11-20T14:12:29.857Z | 2024-11-21T14:20:50.644Z |
5557223 | 5557223 | 20241119044021_Z3Guf | UK0081 | 2024-11-20T14:12:28.850Z | 2024-11-21T14:20:50.288Z |
5557203 | 5557203 | 20241119042953_JC8Mb | UK0081 | 2024-11-20T14:12:27.286Z | 2024-11-21T14:20:49.432Z |
5557194 | 5557194 | 20241119042853_jrcdA | UK0081 | 2024-11-20T14:12:26.591Z | 2024-11-21T14:20:49.373Z |
5557179 | 5557179 | 20241119042000_uNJSk | UK0081 | 2024-11-20T14:12:25.315Z | 2024-11-21T14:20:49.091Z |
5557170 | 5557170 | 20241119041808_02SzF | UK0081 | 2024-11-20T14:12:24.265Z | 2024-11-21T14:20:48.718Z |
5557163 | 5557163 | 20241119041339_pq9Dx | UK0081 | 2024-11-20T14:12:23.507Z | 2024-11-21T14:20:48.636Z |
5557091 | 5557091 | 20241119035029_7Qyn6 | UK0081 | 2024-11-20T14:12:16.291Z | 2024-11-21T14:20:46.005Z |
5557073 | 5557073 | 20241119034552_ROfpM | UK0081 | 2024-11-20T14:12:12.287Z | 2024-11-21T14:20:45.363Z |
5557055 | 5557055 | 20241119033433_Egxez | UK0081 | 2024-11-20T14:12:05.776Z | 2024-11-21T14:20:44.997Z |
5556990 | 5556990 | 20241119031630_LsJXK | UK0081 | 2024-11-20T14:11:55.397Z | 2024-11-21T14:20:42.561Z |
5556965 | 5556965 | 20241119030940_xAReb | UK0081 | 2024-11-20T14:11:51.610Z | 2024-11-21T14:20:42.276Z |
5556956 | 5556956 | 20241119030713_90KoL | UK0081 | 2024-11-20T14:11:48.674Z | 2024-11-21T14:20:42.016Z |
5556899 | 5556899 | 20241119024312_oo2J8 | UK0081 | 2024-11-20T14:11:39.249Z | 2024-11-21T14:20:39.179Z |
5556827 | 5556827 | 20241119020720_1O2Ol | UK0081 | 2024-11-20T14:11:31.710Z | 2024-11-21T14:20:36.819Z |
5556820 | 5556820 | 20241119020404_E2TPq | UK0081 | 2024-11-20T14:11:30.991Z | 2024-11-21T14:20:36.523Z |
5556702 | 5556702 | 20241119011548_wodvp | UK0081 | 2024-11-20T14:11:19.902Z | 2024-11-21T14:20:32.832Z |
5556664 | 5556664 | 20241119005256_GncbQ | UK0081 | 2024-11-20T14:11:08.044Z | 2024-11-21T14:20:32.148Z |
5556624 | 5556624 | 20241119002116_IqLdY | UK0081 | 2024-11-20T14:10:57.048Z | 2024-11-21T14:20:30.066Z |
5556605 | 5556605 | 20241119000340_6htly | UK0081 | 2024-11-20T14:10:51.126Z | 2024-11-21T14:20:29.640Z |
5556418 | 5556418 | 20241118211649_kF5FZ | UK0081 | 2024-11-20T14:10:27.800Z | 2024-11-21T14:20:23.867Z |
5554137 | 5554137 | 20241119062718_18UlI | UK0081 | 2024-11-20T14:00:50.091Z | 2024-11-21T14:18:52.985Z |
5554131 | 5554131 | 20241119062520_kQw33 | UK0081 | 2024-11-20T14:00:49.192Z | 2024-11-21T14:18:52.983Z |
5554127 | 5554127 | 20241119062407_QvK0F | UK0081 | 2024-11-20T14:00:48.843Z | 2024-11-21T14:18:52.983Z |
5554071 | 5554071 | 20241119060139_9k9dT | UK0081 | 2024-11-20T14:00:38.769Z | 2024-11-21T14:18:52.970Z |
5554052 | 5554052 | 20241119054947_l4RCE | UK0081 | 2024-11-20T14:00:34.394Z | 2024-11-21T14:18:52.966Z |
5554044 | 5554044 | 20241119054205_XGLGr | UK0081 | 2024-11-20T14:00:33.348Z | 2024-11-21T14:18:52.964Z |
5554042 | 5554042 | 20241119054120_3kbmL | UK0081 | 2024-11-20T14:00:32.939Z | 2024-11-21T14:18:52.963Z |
5554000 | 5554000 | 20241119052125_Ifb1i | UK0081 | 2024-11-20T14:00:21.637Z | 2024-11-21T14:18:52.953Z |
5553971 | 5553971 | 20241119050131_8nhz4 | UK0081 | 2024-11-20T14:00:15.263Z | 2024-11-21T14:18:52.946Z |
5553887 | 5553887 | 20241118044232_BONTC | UK0081 | 2024-11-19T14:11:31.653Z | 2024-11-21T14:22:23.184Z |
5553784 | 5553784 | 20241118041641_aOAYn | UK0081 | 2024-11-19T14:11:26.428Z | 2024-11-21T14:22:21.167Z |
5553765 | 5553765 | 20241118041254_7Iwrb | UK0081 | 2024-11-19T14:11:25.401Z | 2024-11-21T14:22:20.939Z |
5553762 | 5553762 | 20241118041236_mLupi | UK0081 | 2024-11-19T14:11:25.257Z | 2024-11-21T14:22:20.938Z |
5553689 | 5553689 | 20241118035257_FaXf3 | UK0081 | 2024-11-19T14:11:17.301Z | 2024-11-21T14:22:19.978Z |
5553567 | 5553567 | 20241118032105_ZUCf4 | UK0081 | 2024-11-19T14:10:53.789Z | 2024-11-21T14:22:16.875Z |
5553489 | 5553489 | 20241118025515_M2y3X | UK0081 | 2024-11-19T14:10:41.809Z | 2024-11-21T14:22:15.609Z |
5553406 | 5553406 | 20241118022345_s9Fx8 | UK0081 | 2024-11-19T14:10:29.039Z | 2024-11-21T14:22:13.580Z |
5553342 | 5553342 | 20241118020738_rjPVD | UK0081 | 2024-11-19T14:10:20.347Z | 2024-11-21T14:22:12.508Z |
5553273 | 5553273 | 20241118015522_0SJFV | UK0081 | 2024-11-19T14:10:14.256Z | 2024-11-21T14:22:10.246Z |
5553223 | 5553223 | 20241118014134_N6dJI | UK0081 | 2024-11-19T14:10:10.531Z | 2024-11-21T14:22:09.123Z |
5553195 | 5553195 | 20241118013017_PfBFA | UK0081 | 2024-11-19T14:10:08.899Z | 2024-11-21T14:22:08.398Z |
5553151 | 5553151 | 20241118010630_nRecP | UK0081 | 2024-11-19T14:10:06.387Z | 2024-11-21T14:22:08.083Z |
5553140 | 5553140 | 20241118010006_F2b4P | UK0081 | 2024-11-19T14:10:05.714Z | 2024-11-21T14:22:07.838Z |
5553108 | 5553108 | 20241118004439_m8Jjm | UK0081 | 2024-11-19T14:10:03.798Z | 2024-11-21T14:22:07.326Z |
5553082 | 5553082 | 20241118003903_ENoS1 | UK0081 | 2024-11-19T14:10:02.073Z | 2024-11-21T14:22:06.855Z |
5553038 | 5553038 | 20241118002519_k108b | UK0081 | 2024-11-19T14:09:58.299Z | 2024-11-21T14:22:06.117Z |
5553028 | 5553028 | 20241118002201_dIz3y | UK0081 | 2024-11-19T14:09:57.660Z | 2024-11-21T14:22:06.048Z |
5553008 | 5553008 | 20241118001136_fbAq2 | UK0081 | 2024-11-19T14:09:56.466Z | 2024-11-21T14:22:05.781Z |
5553002 | 5553002 | 20241118000115_i85ub | UK0081 | 2024-11-19T14:09:55.956Z | 2024-11-21T14:22:05.571Z |
5552978 | 5552978 | 20241117235357_xdiFp | UK0081 | 2024-11-19T14:09:54.452Z | 2024-11-21T14:22:05.246Z |
5552944 | 5552944 | 20241117233743_zFb20 | UK0081 | 2024-11-19T14:09:52.496Z | 2024-11-21T14:22:04.918Z |
5552939 | 5552939 | 20241117233250_AZDBB | UK0081 | 2024-11-19T14:09:52.115Z | 2024-11-21T14:22:04.819Z |
5552920 | 5552920 | 20241117232834_h5Ls6 | UK0081 | 2024-11-19T14:09:47.601Z | 2024-11-21T14:22:04.274Z |
5552886 | 5552886 | 20241117230435_zej6l | UK0081 | 2024-11-19T14:09:36.637Z | 2024-11-21T14:22:03.390Z |
5552845 | 5552845 | 20241117223744_3co1q | UK0081 | 2024-11-19T14:09:25.046Z | 2024-11-21T14:22:01.692Z |
5552843 | 5552843 | 20241117223732_4Ly9b | UK0081 | 2024-11-19T14:09:24.349Z | 2024-11-21T14:22:01.681Z |
5552812 | 5552812 | 20241117220801_H5768 | UK0081 | 2024-11-19T14:09:18.142Z | 2024-11-21T14:22:01.179Z |
5552801 | 5552801 | 20241117215935_F1kpD | UK0081 | 2024-11-19T14:09:15.790Z | 2024-11-21T14:22:00.781Z |
5552752 | 5552752 | 20241117211123_wq3Zb | UK0081 | 2024-11-19T14:09:07.293Z | 2024-11-21T14:21:59.446Z |
5552744 | 5552744 | 20241117210722_b88JW | UK0081 | 2024-11-19T14:09:05.593Z | 2024-11-21T14:21:59.159Z |
5552680 | 5552680 | 20241117200925_768AN | UK0081 | 2024-11-19T14:08:54.381Z | 2024-11-21T14:21:54.865Z |
5552638 | 5552638 | 20241117194025_sCMbz | UK0081 | 2024-11-19T14:08:49.474Z | 2024-11-21T14:21:51.994Z |
5552565 | 5552565 | 20241117184434_Lfdja | UK0081 | 2024-11-19T14:08:39.556Z | 2024-11-21T14:21:48.265Z |
5552539 | 5552539 | 20241117183006_Ccby6 | UK0081 | 2024-11-19T14:08:34.069Z | 2024-11-21T14:21:47.372Z |
5552491 | 5552491 | 20241117172926_65xr6 | UK0081 | 2024-11-19T14:08:14.311Z | 2024-11-21T14:21:43.039Z |
5549790 | 5549790 | 20241118064454_bliGB | UK0081 | 2024-11-19T14:00:51.669Z | 2024-11-21T14:19:00.781Z |
5549786 | 5549786 | 20241118063640_OKXET | UK0081 | 2024-11-19T14:00:51.096Z | 2024-11-21T14:19:00.745Z |
5549760 | 5549760 | 20241118062132_rFGs3 | UK0081 | 2024-11-19T14:00:46.664Z | 2024-11-21T14:18:59.938Z |
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);