participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,590 rows where station_code = "UK009V" 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 |
---|---|---|---|---|---|
5262963 | 5262963 | 20241008024917_3u37Q | UK009V | 2024-10-09T12:16:31.422Z | 2024-10-16T12:21:20.622Z |
5262773 | 5262773 | 20241008022035_1elxX | UK009V | 2024-10-09T12:16:12.353Z | 2024-10-16T12:21:19.950Z |
5262749 | 5262749 | 20241008021743_bz04q | UK009V | 2024-10-09T12:16:11.087Z | 2024-10-16T12:21:19.894Z |
5262727 | 5262727 | 20241008021634_uwiNA | UK009V | 2024-10-09T12:16:09.920Z | 2024-10-16T12:21:19.846Z |
5255555 | 5255555 | 20241008044232_82Whd | UK009V | 2024-10-09T12:01:22.155Z | 2024-10-17T12:19:52.668Z |
5255492 | 5255492 | 20241008043454_A1Md4 | UK009V | 2024-10-09T12:01:17.064Z | 2024-10-17T12:19:52.386Z |
5255394 | 5255394 | 20241008042042_xTz32 | UK009V | 2024-10-09T12:01:09.046Z | 2024-10-17T12:19:52.030Z |
5255381 | 5255381 | 20241008041913_SoGMG | UK009V | 2024-10-09T12:01:08.193Z | 2024-10-17T12:19:51.985Z |
5255218 | 5255218 | 20241008035454_axjmi | UK009V | 2024-10-09T12:00:49.229Z | 2024-10-17T12:19:51.368Z |
5255089 | 5255089 | 20241008033850_yPT1I | UK009V | 2024-10-09T12:00:34.254Z | 2024-10-17T12:19:51.002Z |
5254922 | 5254922 | 20241008031911_ojENf | UK009V | 2024-10-09T12:00:14.947Z | 2024-10-17T12:19:50.039Z |
5254127 | 5254127 | 20241007013801_cRzhg | UK009V | 2024-10-08T12:14:06.323Z | 2024-10-15T12:29:13.072Z |
5253359 | 5253359 | 20241006233858_HXPcA | UK009V | 2024-10-08T12:13:09.528Z | 2024-10-15T12:29:08.964Z |
5247327 | 5247327 | 20241005015622_vL2IW | UK009V | 2024-10-07T12:18:53.592Z | 2024-10-13T12:26:26.057Z |
5247262 | 5247262 | 20241005014848_vBplX | UK009V | 2024-10-07T12:18:52.462Z | 2024-10-13T12:26:25.953Z |
5247041 | 5247041 | 20241005013354_rNIyG | UK009V | 2024-10-07T12:18:50.025Z | 2024-10-13T12:26:25.644Z |
5246999 | 5246999 | 20241005013002_fz82O | UK009V | 2024-10-07T12:18:49.735Z | 2024-10-13T12:26:25.627Z |
5246981 | 5246981 | 20241005012906_p3Mjv | UK009V | 2024-10-07T12:18:49.639Z | 2024-10-13T12:26:25.624Z |
5240099 | 5240099 | 20241005050138_awfg2 | UK009V | 2024-10-07T12:07:41.609Z | 2024-10-14T12:24:21.182Z |
5239931 | 5239931 | 20241005044048_xzOAQ | UK009V | 2024-10-07T12:07:21.952Z | 2024-10-14T12:24:21.000Z |
5239824 | 5239824 | 20241005042930_eZZ50 | UK009V | 2024-10-07T12:07:11.763Z | 2024-10-14T12:24:20.782Z |
5239053 | 5239053 | 20241005032353_jTE3n | UK009V | 2024-10-07T12:05:42.135Z | 2024-10-14T12:24:18.093Z |
5238839 | 5238839 | 20241005030222_T2Ffq | UK009V | 2024-10-07T12:05:20.830Z | 2024-10-14T12:24:17.325Z |
5238687 | 5238687 | 20241005025211_2CDDb | UK009V | 2024-10-07T12:04:53.680Z | 2024-10-14T12:24:16.971Z |
5238511 | 5238511 | 20241005023722_LWhBf | UK009V | 2024-10-07T12:04:37.549Z | 2024-10-14T12:24:16.651Z |
5238310 | 5238310 | 20241005022333_cToWQ | UK009V | 2024-10-07T12:04:05.975Z | 2024-10-14T12:24:15.982Z |
5236660 | 5236660 | 20241005011616_dDH02 | UK009V | 2024-10-06T12:17:41.231Z | 2024-10-13T12:26:25.303Z |
5236602 | 5236602 | 20241005010909_pkGe4 | UK009V | 2024-10-06T12:17:38.692Z | 2024-10-13T12:26:25.235Z |
5236359 | 5236359 | 20241005004358_29lVC | UK009V | 2024-10-06T12:17:29.679Z | 2024-10-13T12:26:24.882Z |
5236120 | 5236120 | 20241005002241_gosk9 | UK009V | 2024-10-06T12:17:13.001Z | 2024-10-13T12:26:24.707Z |
5235187 | 5235187 | 20241004230124_09S1T | UK009V | 2024-10-06T12:15:53.666Z | 2024-10-13T12:26:24.015Z |
5234971 | 5234971 | 20241004223813_8Bwba | UK009V | 2024-10-06T12:15:44.177Z | 2024-10-13T12:26:23.269Z |
5234810 | 5234810 | 20241004221609_L8mSM | UK009V | 2024-10-06T12:15:22.516Z | 2024-10-13T12:26:22.832Z |
5234644 | 5234644 | 20241004220401_Qf3o3 | UK009V | 2024-10-06T12:15:07.019Z | 2024-10-13T12:26:22.726Z |
5234420 | 5234420 | 20241004213329_JHTWO | UK009V | 2024-10-06T12:14:53.818Z | 2024-10-13T12:26:22.492Z |
5233955 | 5233955 | 20241004203212_LTSyI | UK009V | 2024-10-06T12:14:07.701Z | 2024-10-13T12:26:21.728Z |
5233436 | 5233436 | 20241004194239_yJ6ZN | UK009V | 2024-10-06T12:13:28.978Z | 2024-10-13T12:26:21.125Z |
5233264 | 5233264 | 20241004191828_QTOxD | UK009V | 2024-10-06T12:13:05.340Z | 2024-10-13T12:26:20.776Z |
5233087 | 5233087 | 20241004185827_Y4DL3 | UK009V | 2024-10-06T12:12:53.204Z | 2024-10-13T12:26:20.423Z |
5227204 | 5227204 | 20241004010902_KsADI | UK009V | 2024-10-05T12:21:18.357Z | 2024-10-12T12:25:12.607Z |
5227123 | 5227123 | 20241004010230_257AE | UK009V | 2024-10-05T12:21:13.678Z | 2024-10-12T12:25:12.503Z |
5226577 | 5226577 | 20241004002449_uelq8 | UK009V | 2024-10-05T12:20:50.678Z | 2024-10-12T12:25:11.915Z |
5226538 | 5226538 | 20241004002118_sylss | UK009V | 2024-10-05T12:20:47.430Z | 2024-10-12T12:25:11.823Z |
5226371 | 5226371 | 20241004000920_Bfaw9 | UK009V | 2024-10-05T12:20:39.065Z | 2024-10-12T12:25:11.627Z |
5226237 | 5226237 | 20241003235702_Zz6wW | UK009V | 2024-10-05T12:20:33.998Z | 2024-10-12T12:25:11.399Z |
5226168 | 5226168 | 20241003235016_dGnqW | UK009V | 2024-10-05T12:20:31.342Z | 2024-10-12T12:25:11.333Z |
5225663 | 5225663 | 20241003230524_rPCj5 | UK009V | 2024-10-05T12:20:00.963Z | 2024-10-12T12:25:10.584Z |
5225630 | 5225630 | 20241003230251_kennM | UK009V | 2024-10-05T12:19:59.590Z | 2024-10-12T12:25:10.529Z |
5225330 | 5225330 | 20241003222445_3kOj5 | UK009V | 2024-10-05T12:19:38.712Z | 2024-10-12T12:25:09.870Z |
5225180 | 5225180 | 20241003220529_7iM4U | UK009V | 2024-10-05T12:19:26.483Z | 2024-10-12T12:25:09.685Z |
5225063 | 5225063 | 20241003215629_Xlega | UK009V | 2024-10-05T12:19:21.645Z | 2024-10-12T12:25:09.540Z |
5224772 | 5224772 | 20241003212034_TlOMA | UK009V | 2024-10-05T12:19:02.770Z | 2024-10-12T12:25:08.896Z |
5224523 | 5224523 | 20241003205212_ZIjU3 | UK009V | 2024-10-05T12:18:37.866Z | 2024-10-12T12:25:08.585Z |
5220003 | 5220003 | 20241003043520_TTero | UK009V | 2024-10-05T12:10:03.606Z | 2024-10-12T12:24:56.577Z |
5219992 | 5219992 | 20241003043448_clBY8 | UK009V | 2024-10-05T12:10:02.778Z | 2024-10-12T12:24:56.562Z |
5219813 | 5219813 | 20241003042037_fIpuO | UK009V | 2024-10-05T12:09:41.585Z | 2024-10-12T12:24:56.367Z |
5218917 | 5218917 | 20241004042134_Y35tF | UK009V | 2024-10-05T12:05:37.532Z | 2024-10-13T12:26:09.196Z |
5218805 | 5218805 | 20241004041118_MjXKC | UK009V | 2024-10-05T12:05:26.162Z | 2024-10-13T12:26:09.090Z |
5218601 | 5218601 | 20241004035247_vdbL3 | UK009V | 2024-10-05T12:04:46.645Z | 2024-10-13T12:26:08.756Z |
5218564 | 5218564 | 20241004035012_PoWf3 | UK009V | 2024-10-05T12:04:43.072Z | 2024-10-13T12:26:08.737Z |
5218556 | 5218556 | 20241004034936_lPAis | UK009V | 2024-10-05T12:04:41.654Z | 2024-10-13T12:26:08.734Z |
5218506 | 5218506 | 20241004034507_euYCG | UK009V | 2024-10-05T12:04:30.056Z | 2024-10-13T12:26:08.659Z |
5218441 | 5218441 | 20241004034033_gptxx | UK009V | 2024-10-05T12:04:22.956Z | 2024-10-13T12:26:08.584Z |
5218436 | 5218436 | 20241004034029_eztSX | UK009V | 2024-10-05T12:04:22.484Z | 2024-10-13T12:26:08.535Z |
5217754 | 5217754 | 20241004025302_tnRxS | UK009V | 2024-10-05T12:02:30.228Z | 2024-10-13T12:26:07.425Z |
5217716 | 5217716 | 20241004024931_z32H3 | UK009V | 2024-10-05T12:02:25.269Z | 2024-10-13T12:26:07.345Z |
5217521 | 5217521 | 20241004023349_a95n6 | UK009V | 2024-10-05T12:01:45.153Z | 2024-10-13T12:26:07.091Z |
5217053 | 5217053 | 20241004020356_xYcdv | UK009V | 2024-10-05T12:00:31.600Z | 2024-10-13T12:26:06.320Z |
5216935 | 5216935 | 20241004015837_s2Onc | UK009V | 2024-10-05T12:00:14.263Z | 2024-10-13T12:26:06.004Z |
5215852 | 5215852 | 20241003001113_R8INa | UK009V | 2024-10-04T12:12:38.148Z | 2024-10-11T12:23:36.171Z |
5215780 | 5215780 | 20241003000448_WKuxk | UK009V | 2024-10-04T12:12:29.674Z | 2024-10-11T12:23:36.063Z |
5215740 | 5215740 | 20241002235931_Sci4h | UK009V | 2024-10-04T12:12:22.124Z | 2024-10-11T12:23:35.955Z |
5215514 | 5215514 | 20241002233649_HXrHh | UK009V | 2024-10-04T12:11:57.792Z | 2024-10-11T12:23:35.488Z |
5215441 | 5215441 | 20241002232935_3a72t | UK009V | 2024-10-04T12:11:50.446Z | 2024-10-11T12:23:35.353Z |
5215408 | 5215408 | 20241002232634_F0Nvi | UK009V | 2024-10-04T12:11:48.781Z | 2024-10-11T12:23:35.340Z |
5215317 | 5215317 | 20241002231424_MC2PV | UK009V | 2024-10-04T12:11:42.435Z | 2024-10-11T12:23:35.192Z |
5215304 | 5215304 | 20241002231348_A3447 | UK009V | 2024-10-04T12:11:41.980Z | 2024-10-11T12:23:35.186Z |
5215153 | 5215153 | 20241002230022_NUAlU | UK009V | 2024-10-04T12:11:30.224Z | 2024-10-11T12:23:34.973Z |
5214950 | 5214950 | 20241002224150_CRqC5 | UK009V | 2024-10-04T12:11:02.009Z | 2024-10-11T12:23:34.593Z |
5214563 | 5214563 | 20241002215607_7wnYJ | UK009V | 2024-10-04T12:10:31.817Z | 2024-10-11T12:23:33.896Z |
5214452 | 5214452 | 20241002214315_mlGhy | UK009V | 2024-10-04T12:10:18.919Z | 2024-10-11T12:23:33.594Z |
5214390 | 5214390 | 20241002213149_OJV2E | UK009V | 2024-10-04T12:10:09.992Z | 2024-10-11T12:23:33.551Z |
5214103 | 5214103 | 20241002205152_MJtlc | UK009V | 2024-10-04T12:09:40.990Z | 2024-10-11T12:23:32.766Z |
5213395 | 5213395 | 20241003035738_DEswM | UK009V | 2024-10-04T12:05:00.094Z | 2024-10-12T12:24:55.813Z |
5213255 | 5213255 | 20241003035117_X2uD9 | UK009V | 2024-10-04T12:04:51.701Z | 2024-10-12T12:24:55.647Z |
5212431 | 5212431 | 20241003025819_yCPG6 | UK009V | 2024-10-04T12:02:59.418Z | 2024-10-12T12:24:54.661Z |
5212130 | 5212130 | 20241003023655_B4gYd | UK009V | 2024-10-04T12:02:19.708Z | 2024-10-12T12:24:54.350Z |
5212053 | 5212053 | 20241003023224_4wBgr | UK009V | 2024-10-04T12:02:09.219Z | 2024-10-12T12:24:54.234Z |
5211827 | 5211827 | 20241003021901_OXTt5 | UK009V | 2024-10-04T12:01:33.330Z | 2024-10-12T12:24:53.925Z |
5211767 | 5211767 | 20241003021516_1qzAW | UK009V | 2024-10-04T12:01:26.077Z | 2024-10-12T12:24:53.854Z |
5211557 | 5211557 | 20241003020118_UPqi2 | UK009V | 2024-10-04T12:00:55.215Z | 2024-10-12T12:24:53.709Z |
5211436 | 5211436 | 20241003014947_B6NSK | UK009V | 2024-10-04T12:00:32.063Z | 2024-10-12T12:24:53.479Z |
5204941 | 5204941 | 20240930213058_tMjN9 | UK009V | 2024-10-02T12:12:12.337Z | 2024-10-09T12:29:15.214Z |
5204913 | 5204913 | 20240930212052_F7UOt | UK009V | 2024-10-02T12:12:10.765Z | 2024-10-09T12:29:15.170Z |
5192942 | 5192942 | 20240928233625_N8BSz | UK009V | 2024-09-30T12:19:00.111Z | 2024-10-06T12:28:26.613Z |
5192889 | 5192889 | 20240928232859_gCSVa | UK009V | 2024-09-30T12:18:58.023Z | 2024-10-06T12:28:26.538Z |
5192715 | 5192715 | 20240928230645_GNg4t | UK009V | 2024-09-30T12:18:51.974Z | 2024-10-06T12:28:26.113Z |
5192604 | 5192604 | 20240928225312_WfKf1 | UK009V | 2024-09-30T12:18:48.389Z | 2024-10-06T12:28:25.973Z |
5192559 | 5192559 | 20240928224742_sqyt4 | UK009V | 2024-09-30T12:18:45.770Z | 2024-10-06T12:28:25.902Z |
5192426 | 5192426 | 20240928223703_dEZRd | UK009V | 2024-09-30T12:18:40.580Z | 2024-10-06T12:28:25.700Z |
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);