participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
298 rows where station_code = "UK00CS" 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 |
---|---|---|---|---|---|
5573258 | 5573258 | 20241121041636_xYWe0 | UK00CS | 2024-11-22T14:19:18.566Z | 2024-11-22T14:19:22.478Z |
5573197 | 5573197 | 20241121040641_AB5Fx | UK00CS | 2024-11-22T14:19:15.199Z | 2024-11-22T14:19:22.468Z |
5573140 | 5573140 | 20241121035938_q23lD | UK00CS | 2024-11-22T14:19:12.206Z | 2024-11-22T14:19:22.458Z |
5573138 | 5573138 | 20241121035846_tyZCm | UK00CS | 2024-11-22T14:19:11.935Z | 2024-11-22T14:19:22.457Z |
5573131 | 5573131 | 20241121035709_3y8Lp | UK00CS | 2024-11-22T14:19:11.433Z | 2024-11-22T14:19:22.456Z |
5573105 | 5573105 | 20241121035144_9m4Tq | UK00CS | 2024-11-22T14:19:09.871Z | 2024-11-22T14:19:22.450Z |
5573019 | 5573019 | 20241121033951_U4JXJ | UK00CS | 2024-11-22T14:19:04.589Z | 2024-11-22T14:19:22.434Z |
5572965 | 5572965 | 20241121033142_RDydx | UK00CS | 2024-11-22T14:19:01.361Z | 2024-11-22T14:19:22.423Z |
5572914 | 5572914 | 20241121032407_ZN3ZM | UK00CS | 2024-11-22T14:18:58.065Z | 2024-11-22T14:19:22.412Z |
5572847 | 5572847 | 20241121031655_xSVSF | UK00CS | 2024-11-22T14:18:53.245Z | 2024-11-22T14:19:22.401Z |
5572842 | 5572842 | 20241121031508_gieeP | UK00CS | 2024-11-22T14:18:52.859Z | 2024-11-22T14:19:22.400Z |
5572780 | 5572780 | 20241121030911_2WXyC | UK00CS | 2024-11-22T14:18:49.030Z | 2024-11-22T14:19:22.390Z |
5572722 | 5572722 | 20241121030153_iFVfQ | UK00CS | 2024-11-22T14:18:45.971Z | 2024-11-22T14:19:22.380Z |
5572708 | 5572708 | 20241121030055_mungx | UK00CS | 2024-11-22T14:18:44.900Z | 2024-11-22T14:19:22.378Z |
5572638 | 5572638 | 20241121025237_V3KFk | UK00CS | 2024-11-22T14:18:40.996Z | 2024-11-22T14:19:22.366Z |
5572607 | 5572607 | 20241121024929_fjZqu | UK00CS | 2024-11-22T14:18:39.403Z | 2024-11-22T14:19:22.361Z |
5572420 | 5572420 | 20241121022016_3yQoS | UK00CS | 2024-11-22T14:18:25.180Z | 2024-11-22T14:19:22.326Z |
5572242 | 5572242 | 20241121015750_d9h7j | UK00CS | 2024-11-22T14:18:07.113Z | 2024-11-22T14:19:22.287Z |
5572174 | 5572174 | 20241121014307_bGVhU | UK00CS | 2024-11-22T14:18:03.184Z | 2024-11-22T14:19:22.273Z |
5572002 | 5572002 | 20241121011651_VLFc4 | UK00CS | 2024-11-22T14:17:51.465Z | 2024-11-22T14:19:22.239Z |
5571986 | 5571986 | 20241121011624_sga12 | UK00CS | 2024-11-22T14:17:50.809Z | 2024-11-22T14:19:22.236Z |
5571895 | 5571895 | 20241121010309_zD16a | UK00CS | 2024-11-22T14:17:45.600Z | 2024-11-22T14:19:22.217Z |
5571859 | 5571859 | 20241121005702_Vd50H | UK00CS | 2024-11-22T14:17:43.092Z | 2024-11-22T14:19:22.209Z |
5571806 | 5571806 | 20241121004851_TRVwJ | UK00CS | 2024-11-22T14:17:40.410Z | 2024-11-22T14:19:22.198Z |
5571749 | 5571749 | 20241121004013_iBVHN | UK00CS | 2024-11-22T14:17:37.377Z | 2024-11-22T14:19:22.186Z |
5571683 | 5571683 | 20241121003134_nq24d | UK00CS | 2024-11-22T14:17:34.561Z | 2024-11-22T14:19:22.173Z |
5571611 | 5571611 | 20241121001628_Rm7IX | UK00CS | 2024-11-22T14:17:22.666Z | 2024-11-22T14:19:22.158Z |
5571597 | 5571597 | 20241121001220_yxeHR | UK00CS | 2024-11-22T14:17:21.686Z | 2024-11-22T14:19:22.155Z |
5571501 | 5571501 | 20241120235835_v5gs3 | UK00CS | 2024-11-22T14:17:11.734Z | 2024-11-22T14:19:22.138Z |
5571492 | 5571492 | 20241120235706_C9Oo0 | UK00CS | 2024-11-22T14:17:11.157Z | 2024-11-22T14:19:22.136Z |
5571489 | 5571489 | 20241120235607_ZnOGs | UK00CS | 2024-11-22T14:17:11.087Z | 2024-11-22T14:19:22.136Z |
5571449 | 5571449 | 20241120234822_3zDwu | UK00CS | 2024-11-22T14:17:07.326Z | 2024-11-22T14:19:22.127Z |
5571431 | 5571431 | 20241120234233_JhJwG | UK00CS | 2024-11-22T14:17:05.384Z | 2024-11-22T14:19:22.123Z |
5571429 | 5571429 | 20241120234229_WoECR | UK00CS | 2024-11-22T14:17:05.163Z | 2024-11-22T14:19:22.122Z |
5571311 | 5571311 | 20241120232035_MRqFu | UK00CS | 2024-11-22T14:16:50.315Z | 2024-11-22T14:19:22.098Z |
5571275 | 5571275 | 20241120231233_ISWBb | UK00CS | 2024-11-22T14:16:47.174Z | 2024-11-22T14:19:22.087Z |
5571232 | 5571232 | 20241120230521_ZGSGX | UK00CS | 2024-11-22T14:16:40.725Z | 2024-11-22T14:19:22.074Z |
5571199 | 5571199 | 20241120225042_jlPNH | UK00CS | 2024-11-22T14:16:36.504Z | 2024-11-22T14:19:22.061Z |
5571060 | 5571060 | 20241120220640_Hd8Wv | UK00CS | 2024-11-22T14:16:20.491Z | 2024-11-22T14:19:22.031Z |
5571044 | 5571044 | 20241120220417_Vbi8j | UK00CS | 2024-11-22T14:16:19.829Z | 2024-11-22T14:19:22.028Z |
5571027 | 5571027 | 20241120215932_u2DQx | UK00CS | 2024-11-22T14:16:19.214Z | 2024-11-22T14:19:22.025Z |
5570982 | 5570982 | 20241120215116_jNqlN | UK00CS | 2024-11-22T14:16:15.636Z | 2024-11-22T14:19:22.017Z |
5570963 | 5570963 | 20241120214616_TWBpJ | UK00CS | 2024-11-22T14:16:14.447Z | 2024-11-22T14:19:22.014Z |
5570816 | 5570816 | 20241120210550_sJyum | UK00CS | 2024-11-22T14:16:06.934Z | 2024-11-22T14:19:21.987Z |
5570666 | 5570666 | 20241120203728_AG5WC | UK00CS | 2024-11-22T14:15:59.778Z | 2024-11-22T14:19:21.960Z |
5570627 | 5570627 | 20241120203048_zCOLu | UK00CS | 2024-11-22T14:15:57.048Z | 2024-11-22T14:19:21.952Z |
5570553 | 5570553 | 20241120200146_aDn6G | UK00CS | 2024-11-22T14:15:44.557Z | 2024-11-22T14:19:21.935Z |
5570532 | 5570532 | 20241120195640_oZys4 | UK00CS | 2024-11-22T14:15:41.056Z | 2024-11-22T14:19:21.932Z |
5570421 | 5570421 | 20241120193449_Et5zu | UK00CS | 2024-11-22T14:15:22.553Z | 2024-11-22T14:19:21.914Z |
5570264 | 5570264 | 20241120190936_QrZ3M | UK00CS | 2024-11-22T14:15:04.926Z | 2024-11-22T14:19:21.889Z |
5570172 | 5570172 | 20241120185542_Qm231 | UK00CS | 2024-11-22T14:14:57.023Z | 2024-11-22T14:19:21.875Z |
5570059 | 5570059 | 20241120183036_tcydt | UK00CS | 2024-11-22T14:14:47.732Z | 2024-11-22T14:19:21.853Z |
5569899 | 5569899 | 20241120175526_0Pmp8 | UK00CS | 2024-11-22T14:14:32.686Z | 2024-11-22T14:19:21.825Z |
5569831 | 5569831 | 20241120174128_WY90L | UK00CS | 2024-11-22T14:14:20.561Z | 2024-11-22T14:19:21.813Z |
5569801 | 5569801 | 20241120173508_gvgSf | UK00CS | 2024-11-22T14:14:13.539Z | 2024-11-22T14:19:21.808Z |
5569795 | 5569795 | 20241120173219_cKKA8 | UK00CS | 2024-11-22T14:14:11.964Z | 2024-11-22T14:19:21.806Z |
5566554 | 5566554 | 20241121063838_LXTlY | UK00CS | 2024-11-22T14:03:10.523Z | 2024-11-22T14:03:10.523Z |
5566499 | 5566499 | 20241121062353_hNJMf | UK00CS | 2024-11-22T14:03:01.123Z | 2024-11-22T14:03:01.123Z |
5566430 | 5566430 | 20241121061119_eGqDS | UK00CS | 2024-11-22T14:02:53.394Z | 2024-11-22T14:02:53.394Z |
5566373 | 5566373 | 20241121060531_rABoX | UK00CS | 2024-11-22T14:02:36.304Z | 2024-11-22T14:02:36.304Z |
5566324 | 5566324 | 20241121060057_wuDMm | UK00CS | 2024-11-22T14:02:27.421Z | 2024-11-22T14:02:27.421Z |
5566289 | 5566289 | 20241121055518_jMCEU | UK00CS | 2024-11-22T14:02:22.023Z | 2024-11-22T14:02:22.023Z |
5566195 | 5566195 | 20241121054451_Urxar | UK00CS | 2024-11-22T14:02:10.814Z | 2024-11-22T14:02:10.814Z |
5565969 | 5565969 | 20241121051210_3tU58 | UK00CS | 2024-11-22T14:01:29.837Z | 2024-11-22T14:01:29.837Z |
5565954 | 5565954 | 20241121051045_4Fd2I | UK00CS | 2024-11-22T14:01:28.568Z | 2024-11-22T14:01:28.568Z |
5565936 | 5565936 | 20241121050813_7HyLU | UK00CS | 2024-11-22T14:01:26.540Z | 2024-11-22T14:01:26.540Z |
5565922 | 5565922 | 20241121050651_5Abbp | UK00CS | 2024-11-22T14:01:24.301Z | 2024-11-22T14:01:24.301Z |
5565848 | 5565848 | 20241121045409_2Z7Th | UK00CS | 2024-11-22T14:01:07.765Z | 2024-11-22T14:01:07.765Z |
5565827 | 5565827 | 20241121045144_hL0gM | UK00CS | 2024-11-22T14:01:01.607Z | 2024-11-22T14:01:01.607Z |
5565802 | 5565802 | 20241121044843_iD5pr | UK00CS | 2024-11-22T14:00:59.227Z | 2024-11-22T14:00:59.227Z |
5565671 | 5565671 | 20241121043359_pW6zr | UK00CS | 2024-11-22T14:00:38.209Z | 2024-11-22T14:00:38.209Z |
5565630 | 5565630 | 20241121042758_x2m3j | UK00CS | 2024-11-22T14:00:27.926Z | 2024-11-22T14:00:27.926Z |
5565566 | 5565566 | 20241121042305_32Jao | UK00CS | 2024-11-22T14:00:18.615Z | 2024-11-22T14:00:18.615Z |
5565437 | 5565437 | 20241120042555_wL9TV | UK00CS | 2024-11-21T14:18:49.247Z | 2024-11-22T14:21:47.179Z |
5565403 | 5565403 | 20241120042318_aTjUq | UK00CS | 2024-11-21T14:18:48.078Z | 2024-11-22T14:21:46.473Z |
5565278 | 5565278 | 20241120041307_59M2Q | UK00CS | 2024-11-21T14:18:44.538Z | 2024-11-22T14:21:45.071Z |
5565251 | 5565251 | 20241120040801_0Nlhr | UK00CS | 2024-11-21T14:18:43.892Z | 2024-11-22T14:21:44.739Z |
5565200 | 5565200 | 20241120040226_x4j2I | UK00CS | 2024-11-21T14:18:40.081Z | 2024-11-22T14:21:43.724Z |
5564993 | 5564993 | 20241120034406_L0Fqn | UK00CS | 2024-11-21T14:18:18.235Z | 2024-11-22T14:21:40.164Z |
5564855 | 5564855 | 20241120033131_XML8L | UK00CS | 2024-11-21T14:18:07.986Z | 2024-11-22T14:21:37.002Z |
5564853 | 5564853 | 20241120033105_e5wgs | UK00CS | 2024-11-21T14:18:07.919Z | 2024-11-22T14:21:36.998Z |
5564718 | 5564718 | 20241120032219_gHO4P | UK00CS | 2024-11-21T14:17:59.228Z | 2024-11-22T14:21:35.859Z |
5564607 | 5564607 | 20241120031309_YhpJk | UK00CS | 2024-11-21T14:17:52.592Z | 2024-11-22T14:21:34.186Z |
5564533 | 5564533 | 20241120030713_WRWKR | UK00CS | 2024-11-21T14:17:47.002Z | 2024-11-22T14:21:33.345Z |
5564513 | 5564513 | 20241120030449_VROSs | UK00CS | 2024-11-21T14:17:44.436Z | 2024-11-22T14:21:32.919Z |
5564476 | 5564476 | 20241120025913_nSexN | UK00CS | 2024-11-21T14:17:39.629Z | 2024-11-22T14:21:32.609Z |
5564315 | 5564315 | 20241120024736_r9Dr5 | UK00CS | 2024-11-21T14:17:26.839Z | 2024-11-22T14:21:30.410Z |
5564295 | 5564295 | 20241120024644_RjdeP | UK00CS | 2024-11-21T14:17:25.607Z | 2024-11-22T14:21:30.073Z |
5564187 | 5564187 | 20241120023646_g4qf3 | UK00CS | 2024-11-21T14:17:16.851Z | 2024-11-22T14:21:28.574Z |
5563907 | 5563907 | 20241120021456_frYdJ | UK00CS | 2024-11-21T14:16:56.744Z | 2024-11-22T14:21:24.916Z |
5563859 | 5563859 | 20241120021035_o1ih9 | UK00CS | 2024-11-21T14:16:51.224Z | 2024-11-22T14:21:24.028Z |
5563775 | 5563775 | 20241120020330_RMCuk | UK00CS | 2024-11-21T14:16:43.021Z | 2024-11-22T14:21:22.376Z |
5563656 | 5563656 | 20241120015512_PGPgi | UK00CS | 2024-11-21T14:16:31.716Z | 2024-11-22T14:21:20.324Z |
5563622 | 5563622 | 20241120015311_PueTR | UK00CS | 2024-11-21T14:16:29.767Z | 2024-11-22T14:21:20.148Z |
5563448 | 5563448 | 20241120013102_xXW1g | UK00CS | 2024-11-21T14:16:06.968Z | 2024-11-22T14:21:15.782Z |
5563407 | 5563407 | 20241120012717_3L026 | UK00CS | 2024-11-21T14:16:02.870Z | 2024-11-22T14:21:14.979Z |
5563331 | 5563331 | 20241120011705_nQ13M | UK00CS | 2024-11-21T14:15:54.572Z | 2024-11-22T14:21:13.101Z |
5563205 | 5563205 | 20241120010447_MQvIA | UK00CS | 2024-11-21T14:15:40.331Z | 2024-11-22T14:21:10.825Z |
5563202 | 5563202 | 20241120010351_zx3Fn | UK00CS | 2024-11-21T14:15:40.250Z | 2024-11-22T14:21:10.672Z |
5563172 | 5563172 | 20241120010047_SdKJL | UK00CS | 2024-11-21T14:15:39.285Z | 2024-11-22T14:21:10.508Z |
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);