participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all sorted by created_at descending
This data as json, copyable, CSV (advanced)
Suggested facets: station_code, created_at (date), updated_at (date)
Link | rowid | meteor_unique_trajectory_identifier | station_code | created_at ▲ | updated_at |
---|---|---|---|---|---|
5498017 | 5498017 | 20241102200706_uViCZ | AU003H | 2024-11-08T14:20:52.009Z | 2024-11-08T14:20:52.009Z |
5498016 | 5498016 | 20241102200706_uViCZ | AU000G | 2024-11-08T14:20:52.009Z | 2024-11-08T14:20:52.009Z |
5498015 | 5498015 | 20241102200706_uViCZ | AU000F | 2024-11-08T14:20:52.009Z | 2024-11-08T14:20:52.009Z |
5498014 | 5498014 | 20241102183023_Ge62C | AU003H | 2024-11-08T14:20:48.404Z | 2024-11-08T14:20:48.404Z |
5498013 | 5498013 | 20241102183023_Ge62C | AU000Y | 2024-11-08T14:20:48.404Z | 2024-11-08T14:20:48.404Z |
5498012 | 5498012 | 20241103200322_wHAM3 | AU003H | 2024-11-08T14:19:39.643Z | 2024-11-08T14:19:39.643Z |
5498011 | 5498011 | 20241103200322_wHAM3 | AU002A | 2024-11-08T14:19:39.643Z | 2024-11-08T14:19:39.643Z |
5498010 | 5498010 | 20241103195006_Fj47m | AU003H | 2024-11-08T14:19:38.764Z | 2024-11-08T14:19:38.764Z |
5498009 | 5498009 | 20241103195006_Fj47m | AU000G | 2024-11-08T14:19:38.764Z | 2024-11-08T14:19:38.764Z |
5498008 | 5498008 | 20241103195006_Fj47m | AU000A | 2024-11-08T14:19:38.763Z | 2024-11-08T14:19:38.763Z |
5498007 | 5498007 | 20241103184249_md6Oj | AU003H | 2024-11-08T14:19:33.639Z | 2024-11-08T14:19:33.639Z |
5498006 | 5498006 | 20241103184249_md6Oj | AU000G | 2024-11-08T14:19:33.639Z | 2024-11-08T14:19:33.639Z |
5498005 | 5498005 | 20241103184249_md6Oj | AU000F | 2024-11-08T14:19:33.639Z | 2024-11-08T14:19:33.639Z |
5498004 | 5498004 | 20241103184224_ThYWd | AU003H | 2024-11-08T14:19:33.611Z | 2024-11-08T14:19:33.611Z |
5498003 | 5498003 | 20241103184224_ThYWd | AU002A | 2024-11-08T14:19:33.611Z | 2024-11-08T14:19:33.611Z |
5498002 | 5498002 | 20241103174338_9yBxd | AU003H | 2024-11-08T14:19:27.816Z | 2024-11-08T14:19:27.816Z |
5498001 | 5498001 | 20241103174338_9yBxd | AU001Y | 2024-11-08T14:19:27.816Z | 2024-11-08T14:19:27.816Z |
5498000 | 5498000 | 20241103174338_9yBxd | AU000F | 2024-11-08T14:19:27.816Z | 2024-11-08T14:19:27.816Z |
5497999 | 5497999 | 20241103171255_t0yl0 | AU003H | 2024-11-08T14:19:25.742Z | 2024-11-08T14:19:25.742Z |
5497998 | 5497998 | 20241103171255_t0yl0 | AU000X | 2024-11-08T14:19:25.711Z | 2024-11-08T14:19:25.711Z |
5497997 | 5497997 | 20241103164533_UyHpz | AU003H | 2024-11-08T14:19:23.680Z | 2024-11-08T14:19:23.680Z |
5497996 | 5497996 | 20241103164533_UyHpz | AU002A | 2024-11-08T14:19:23.680Z | 2024-11-08T14:19:23.680Z |
5497995 | 5497995 | 20241103161648_oF4ZU | AU003H | 2024-11-08T14:19:22.073Z | 2024-11-08T14:19:22.073Z |
5497994 | 5497994 | 20241103161648_oF4ZU | AU000Y | 2024-11-08T14:19:22.073Z | 2024-11-08T14:19:22.073Z |
5497993 | 5497993 | 20241103154119_d6A3I | AU003H | 2024-11-08T14:19:20.140Z | 2024-11-08T14:19:20.140Z |
5497992 | 5497992 | 20241103154119_d6A3I | AU002A | 2024-11-08T14:19:20.140Z | 2024-11-08T14:19:20.140Z |
5497991 | 5497991 | 20241103145118_c6g0y | AU003H | 2024-11-08T14:19:18.422Z | 2024-11-08T14:19:18.422Z |
5497990 | 5497990 | 20241103145118_c6g0y | AU000Y | 2024-11-08T14:19:18.422Z | 2024-11-08T14:19:18.422Z |
5497989 | 5497989 | 20241103135632_SHLuT | AU003H | 2024-11-08T14:19:14.902Z | 2024-11-08T14:19:14.902Z |
5497988 | 5497988 | 20241103135632_SHLuT | AU000G | 2024-11-08T14:19:14.902Z | 2024-11-08T14:19:14.902Z |
5497987 | 5497987 | 20241103135303_BJgln | AU003H | 2024-11-08T14:19:14.801Z | 2024-11-08T14:19:14.801Z |
5497986 | 5497986 | 20241103135303_BJgln | AU000Y | 2024-11-08T14:19:14.801Z | 2024-11-08T14:19:14.801Z |
5497985 | 5497985 | 20241103134210_Uuexh | AU003H | 2024-11-08T14:19:14.202Z | 2024-11-08T14:19:14.202Z |
5497984 | 5497984 | 20241103134210_Uuexh | AU000Z | 2024-11-08T14:19:14.202Z | 2024-11-08T14:19:14.202Z |
5497983 | 5497983 | 20241103113956_h8iuH | AU003H | 2024-11-08T14:19:08.268Z | 2024-11-08T14:19:08.268Z |
5497982 | 5497982 | 20241103113956_h8iuH | AU001X | 2024-11-08T14:19:08.268Z | 2024-11-08T14:19:08.268Z |
5497981 | 5497981 | 20241104185150_7rjse | AU003H | 2024-11-08T14:18:07.028Z | 2024-11-08T14:18:07.028Z |
5497980 | 5497980 | 20241104185150_7rjse | AU001Y | 2024-11-08T14:18:07.028Z | 2024-11-08T14:18:07.028Z |
5497979 | 5497979 | 20241104163936_M2Z81 | AU003H | 2024-11-08T14:17:58.202Z | 2024-11-08T14:17:58.202Z |
5497978 | 5497978 | 20241104163936_M2Z81 | AU001F | 2024-11-08T14:17:58.202Z | 2024-11-08T14:17:58.202Z |
5497977 | 5497977 | 20241104154108_3xyUR | AU003H | 2024-11-08T14:17:56.131Z | 2024-11-08T14:17:56.131Z |
5497976 | 5497976 | 20241104154108_3xyUR | AU002A | 2024-11-08T14:17:56.131Z | 2024-11-08T14:17:56.131Z |
5497975 | 5497975 | 20241104132133_QjPBt | AU003H | 2024-11-08T14:17:45.362Z | 2024-11-08T14:17:45.362Z |
5497974 | 5497974 | 20241104132133_QjPBt | AU000G | 2024-11-08T14:17:45.362Z | 2024-11-08T14:17:45.362Z |
5497973 | 5497973 | 20241104132133_QjPBt | AU000F | 2024-11-08T14:17:45.362Z | 2024-11-08T14:17:45.362Z |
5497972 | 5497972 | 20241104113736_FkG7w | AU003H | 2024-11-08T14:17:33.150Z | 2024-11-08T14:17:33.150Z |
5497971 | 5497971 | 20241104113736_FkG7w | AU000Z | 2024-11-08T14:17:33.145Z | 2024-11-08T14:17:33.145Z |
5497970 | 5497970 | 20241104113736_FkG7w | AU000Y | 2024-11-08T14:17:33.118Z | 2024-11-08T14:17:33.118Z |
5497969 | 5497969 | 20241105172916_R2v7C | KR003S | 2024-11-08T14:15:50.969Z | 2024-11-08T14:15:50.969Z |
5497968 | 5497968 | 20241105172916_R2v7C | KR003K | 2024-11-08T14:15:50.969Z | 2024-11-08T14:15:50.969Z |
5497967 | 5497967 | 20241105135709_2bn1W | AU003H | 2024-11-08T14:15:30.091Z | 2024-11-08T14:15:30.091Z |
5497966 | 5497966 | 20241105135709_2bn1W | AU000F | 2024-11-08T14:15:30.091Z | 2024-11-08T14:15:30.091Z |
5497965 | 5497965 | 20241107062646_fBsHb | USL01D | 2024-11-08T14:14:32.456Z | 2024-11-08T14:14:35.461Z |
5497964 | 5497964 | 20241107062646_fBsHb | USL00Q | 2024-11-08T14:14:32.456Z | 2024-11-08T14:14:35.461Z |
5497963 | 5497963 | 20241107062646_fBsHb | USL00G | 2024-11-08T14:14:32.456Z | 2024-11-08T14:14:35.461Z |
5497962 | 5497962 | 20241107062646_fBsHb | USL00D | 2024-11-08T14:14:32.456Z | 2024-11-08T14:14:35.461Z |
5497961 | 5497961 | 20241107062432_4VQK8 | US0051 | 2024-11-08T14:14:32.308Z | 2024-11-08T14:14:35.460Z |
5497960 | 5497960 | 20241107062432_4VQK8 | US001V | 2024-11-08T14:14:32.308Z | 2024-11-08T14:14:35.460Z |
5497959 | 5497959 | 20241107062249_s43EE | MX000F | 2024-11-08T14:14:32.170Z | 2024-11-08T14:14:35.460Z |
5497958 | 5497958 | 20241107062249_s43EE | MX000E | 2024-11-08T14:14:32.170Z | 2024-11-08T14:14:35.460Z |
5497957 | 5497957 | 20241107062249_s43EE | MX0006 | 2024-11-08T14:14:32.170Z | 2024-11-08T14:14:35.460Z |
5497956 | 5497956 | 20241107062249_s43EE | MX0002 | 2024-11-08T14:14:32.170Z | 2024-11-08T14:14:35.460Z |
5497955 | 5497955 | 20241107061935_N38HG | MX000F | 2024-11-08T14:14:32.097Z | 2024-11-08T14:14:35.459Z |
5497954 | 5497954 | 20241107061935_N38HG | MX000E | 2024-11-08T14:14:32.097Z | 2024-11-08T14:14:35.459Z |
5497953 | 5497953 | 20241107061935_N38HG | MX0006 | 2024-11-08T14:14:32.097Z | 2024-11-08T14:14:35.459Z |
5497952 | 5497952 | 20241107061935_N38HG | MX0002 | 2024-11-08T14:14:32.097Z | 2024-11-08T14:14:35.459Z |
5497951 | 5497951 | 20241107061923_6fgPp | USL00Q | 2024-11-08T14:14:31.904Z | 2024-11-08T14:14:35.458Z |
5497950 | 5497950 | 20241107061923_6fgPp | USL00D | 2024-11-08T14:14:31.904Z | 2024-11-08T14:14:35.458Z |
5497949 | 5497949 | 20241107061740_Di3Sj | USL00Z | 2024-11-08T14:14:31.786Z | 2024-11-08T14:14:35.458Z |
5497948 | 5497948 | 20241107061740_Di3Sj | US0021 | 2024-11-08T14:14:31.786Z | 2024-11-08T14:14:35.458Z |
5497947 | 5497947 | 20241107061705_Si32B | US004Q | 2024-11-08T14:14:31.662Z | 2024-11-08T14:14:35.457Z |
5497946 | 5497946 | 20241107061705_Si32B | US002X | 2024-11-08T14:14:31.662Z | 2024-11-08T14:14:35.457Z |
5497945 | 5497945 | 20241107061600_UpbLQ | US004P | 2024-11-08T14:14:31.623Z | 2024-11-08T14:14:35.457Z |
5497944 | 5497944 | 20241107061600_UpbLQ | US004C | 2024-11-08T14:14:31.623Z | 2024-11-08T14:14:35.457Z |
5497943 | 5497943 | 20241107061600_UpbLQ | US004B | 2024-11-08T14:14:31.623Z | 2024-11-08T14:14:35.457Z |
5497942 | 5497942 | 20241107061505_qP3BY | US004P | 2024-11-08T14:14:31.577Z | 2024-11-08T14:14:35.456Z |
5497941 | 5497941 | 20241107061505_qP3BY | US004C | 2024-11-08T14:14:31.577Z | 2024-11-08T14:14:35.456Z |
5497940 | 5497940 | 20241107061505_qP3BY | US002Y | 2024-11-08T14:14:31.577Z | 2024-11-08T14:14:35.456Z |
5497939 | 5497939 | 20241107061351_3zHy3 | US004J | 2024-11-08T14:14:31.361Z | 2024-11-08T14:14:35.455Z |
5497938 | 5497938 | 20241107061351_3zHy3 | US0031 | 2024-11-08T14:14:31.361Z | 2024-11-08T14:14:35.455Z |
5497937 | 5497937 | 20241107061351_3zHy3 | US001G | 2024-11-08T14:14:31.361Z | 2024-11-08T14:14:35.455Z |
5497936 | 5497936 | 20241107061250_2Brp8 | US002A | 2024-11-08T14:14:31.343Z | 2024-11-08T14:14:35.455Z |
5497935 | 5497935 | 20241107061250_2Brp8 | US001U | 2024-11-08T14:14:31.343Z | 2024-11-08T14:14:35.455Z |
5497934 | 5497934 | 20241107061054_PnOvi | USL00M | 2024-11-08T14:14:31.277Z | 2024-11-08T14:14:35.454Z |
5497933 | 5497933 | 20241107061054_PnOvi | USL00G | 2024-11-08T14:14:31.277Z | 2024-11-08T14:14:35.454Z |
5497932 | 5497932 | 20241107061054_PnOvi | US000U | 2024-11-08T14:14:31.277Z | 2024-11-08T14:14:35.454Z |
5497931 | 5497931 | 20241107060846_UkASG | USL016 | 2024-11-08T14:14:31.061Z | 2024-11-08T14:14:35.454Z |
5497930 | 5497930 | 20241107060846_UkASG | USL012 | 2024-11-08T14:14:31.061Z | 2024-11-08T14:14:35.454Z |
5497929 | 5497929 | 20241107060846_UkASG | US0021 | 2024-11-08T14:14:31.061Z | 2024-11-08T14:14:35.454Z |
5497928 | 5497928 | 20241107060846_UkASG | US0020 | 2024-11-08T14:14:31.061Z | 2024-11-08T14:14:35.454Z |
5497927 | 5497927 | 20241107060821_roqzF | USL00M | 2024-11-08T14:14:31.026Z | 2024-11-08T14:14:35.453Z |
5497926 | 5497926 | 20241107060821_roqzF | USL00F | 2024-11-08T14:14:31.026Z | 2024-11-08T14:14:35.453Z |
5497925 | 5497925 | 20241107060800_40Qc8 | US002X | 2024-11-08T14:14:30.854Z | 2024-11-08T14:14:35.453Z |
5497924 | 5497924 | 20241107060800_40Qc8 | US002R | 2024-11-08T14:14:30.854Z | 2024-11-08T14:14:35.453Z |
5497923 | 5497923 | 20241107060716_r3eYS | USL018 | 2024-11-08T14:14:30.784Z | 2024-11-08T14:14:35.452Z |
5497922 | 5497922 | 20241107060716_r3eYS | USL014 | 2024-11-08T14:14:30.784Z | 2024-11-08T14:14:35.452Z |
5497921 | 5497921 | 20241107060716_r3eYS | USL00Q | 2024-11-08T14:14:30.784Z | 2024-11-08T14:14:35.452Z |
5497920 | 5497920 | 20241107060534_2aIqi | US004P | 2024-11-08T14:14:30.694Z | 2024-11-08T14:14:35.451Z |
5497919 | 5497919 | 20241107060534_2aIqi | US004C | 2024-11-08T14:14:30.694Z | 2024-11-08T14:14:35.451Z |
5497918 | 5497918 | 20241107060122_XkVmv | USL011 | 2024-11-08T14:14:30.507Z | 2024-11-08T14:14:35.451Z |
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);