participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "US0004" 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 |
---|---|---|---|---|---|
5491493 | 5491493 | 20241106032701_Or391 | US0004 | 2024-11-07T14:16:14.571Z | 2024-11-09T14:20:09.739Z |
5491224 | 5491224 | 20241106023007_I26L4 | US0004 | 2024-11-07T14:15:34.437Z | 2024-11-09T14:20:05.743Z |
5480291 | 5480291 | 20241105121859_596Bw | US0004 | 2024-11-06T14:05:10.067Z | 2024-11-09T14:19:22.161Z |
5480283 | 5480283 | 20241105121705_83TaO | US0004 | 2024-11-06T14:05:08.759Z | 2024-11-09T14:19:22.062Z |
5480260 | 5480260 | 20241105121123_fUnQV | US0004 | 2024-11-06T14:05:05.246Z | 2024-11-09T14:19:21.502Z |
5480159 | 5480159 | 20241105115428_P2wY4 | US0004 | 2024-11-06T14:04:41.617Z | 2024-11-09T14:19:19.707Z |
5480107 | 5480107 | 20241105113937_Lyo7s | US0004 | 2024-11-06T14:04:31.730Z | 2024-11-09T14:19:17.870Z |
5480009 | 5480009 | 20241105111740_D8AhN | US0004 | 2024-11-06T14:04:18.896Z | 2024-11-09T14:19:15.055Z |
5479913 | 5479913 | 20241105105914_IlnVZ | US0004 | 2024-11-06T14:03:53.320Z | 2024-11-09T14:19:13.839Z |
5479863 | 5479863 | 20241105105414_dpKbH | US0004 | 2024-11-06T14:03:46.255Z | 2024-11-09T14:19:13.319Z |
5479630 | 5479630 | 20241105100736_ZPrCY | US0004 | 2024-11-06T14:02:56.114Z | 2024-11-09T14:19:10.039Z |
5469575 | 5469575 | 20241103034647_TSGr3 | US0004 | 2024-11-04T14:16:37.164Z | 2024-11-09T14:23:03.104Z |
5469444 | 5469444 | 20241103032818_T8lBQ | US0004 | 2024-11-04T14:16:28.526Z | 2024-11-09T14:23:02.594Z |
5465508 | 5465508 | 20241103123148_otlt4 | US0004 | 2024-11-04T14:03:51.092Z | 2024-11-09T14:21:34.467Z |
5465506 | 5465506 | 20241103122320_3CfXt | US0004 | 2024-11-04T14:03:50.666Z | 2024-11-09T14:21:34.000Z |
5464703 | 5464703 | 20241103085652_knFHo | US0004 | 2024-11-04T14:01:25.943Z | 2024-11-09T14:21:28.005Z |
5464027 | 5464027 | 20241102063831_47KIo | US0004 | 2024-11-03T14:19:30.243Z | 2024-11-09T14:23:45.354Z |
5463958 | 5463958 | 20241102062120_9S0NX | US0004 | 2024-11-03T14:19:27.035Z | 2024-11-09T14:23:45.007Z |
5463921 | 5463921 | 20241102061318_x9SBj | US0004 | 2024-11-03T14:19:25.704Z | 2024-11-09T14:23:44.580Z |
5462836 | 5462836 | 20241102014242_mfBPx | US0004 | 2024-11-03T14:18:07.158Z | 2024-11-09T14:23:36.471Z |
5459830 | 5459830 | 20241101115910_3ys3M | US0004 | 2024-11-03T14:12:38.730Z | 2024-11-09T14:23:21.103Z |
5459658 | 5459658 | 20241101113052_mvgkY | US0004 | 2024-11-03T14:12:25.464Z | 2024-11-09T14:23:20.078Z |
5459593 | 5459593 | 20241101112156_YrA6S | US0004 | 2024-11-03T14:12:21.038Z | 2024-11-09T14:23:19.957Z |
5459541 | 5459541 | 20241101111602_3O8gq | US0004 | 2024-11-03T14:12:16.077Z | 2024-11-09T14:23:19.038Z |
5458957 | 5458957 | 20241101095126_LpJ9j | US0004 | 2024-11-03T14:10:52.487Z | 2024-11-09T14:23:15.548Z |
5458493 | 5458493 | 20241101083514_V6tWB | US0004 | 2024-11-03T14:09:51.337Z | 2024-11-09T14:23:12.602Z |
5458269 | 5458269 | 20241101075909_0y6Ft | US0004 | 2024-11-03T14:09:25.492Z | 2024-11-09T14:23:11.169Z |
5456907 | 5456907 | 20241102124842_6yqXb | US0004 | 2024-11-03T14:05:56.810Z | 2024-11-09T14:22:46.059Z |
5456888 | 5456888 | 20241102124415_aeP0J | US0004 | 2024-11-03T14:05:53.655Z | 2024-11-09T14:22:45.939Z |
5456848 | 5456848 | 20241102123819_GdZDv | US0004 | 2024-11-03T14:05:49.187Z | 2024-11-09T14:22:45.856Z |
5456843 | 5456843 | 20241102123808_J1wNa | US0004 | 2024-11-03T14:05:48.652Z | 2024-11-09T14:22:45.833Z |
5456778 | 5456778 | 20241102122229_A529F | US0004 | 2024-11-03T14:05:40.390Z | 2024-11-09T14:22:45.594Z |
5456628 | 5456628 | 20241102115619_h8j3F | US0004 | 2024-11-03T14:05:10.033Z | 2024-11-09T14:22:44.789Z |
5456612 | 5456612 | 20241102115111_GvDAL | US0004 | 2024-11-03T14:05:07.139Z | 2024-11-09T14:22:44.697Z |
5456542 | 5456542 | 20241102114312_xLwEW | US0004 | 2024-11-03T14:04:57.734Z | 2024-11-09T14:22:44.374Z |
5456497 | 5456497 | 20241102113434_V9ocQ | US0004 | 2024-11-03T14:04:51.100Z | 2024-11-09T14:22:44.172Z |
5456384 | 5456384 | 20241102111123_gYvAv | US0004 | 2024-11-03T14:04:22.040Z | 2024-11-09T14:22:43.503Z |
5456378 | 5456378 | 20241102110908_iPiAU | US0004 | 2024-11-03T14:04:20.403Z | 2024-11-09T14:22:43.427Z |
5456368 | 5456368 | 20241102110515_6Ffvj | US0004 | 2024-11-03T14:04:19.087Z | 2024-11-09T14:22:43.298Z |
5456329 | 5456329 | 20241102110127_ipnNf | US0004 | 2024-11-03T14:04:13.971Z | 2024-11-09T14:22:42.910Z |
5456169 | 5456169 | 20241102103410_PihDi | US0004 | 2024-11-03T14:03:39.119Z | 2024-11-09T14:22:42.278Z |
5456120 | 5456120 | 20241102102503_iICos | US0004 | 2024-11-03T14:03:24.131Z | 2024-11-09T14:22:42.012Z |
5456106 | 5456106 | 20241102102234_Z0jHi | US0004 | 2024-11-03T14:03:21.862Z | 2024-11-09T14:22:41.970Z |
5456102 | 5456102 | 20241102102133_IjelU | US0004 | 2024-11-03T14:03:21.529Z | 2024-11-09T14:22:41.950Z |
5456093 | 5456093 | 20241102102122_CNs2j | US0004 | 2024-11-03T14:03:20.245Z | 2024-11-09T14:22:41.901Z |
5456065 | 5456065 | 20241102101620_uXFYo | US0004 | 2024-11-03T14:03:15.275Z | 2024-11-09T14:22:41.725Z |
5456045 | 5456045 | 20241102101106_qI5v3 | US0004 | 2024-11-03T14:03:11.591Z | 2024-11-09T14:22:41.525Z |
5455839 | 5455839 | 20241102092927_BV31l | US0004 | 2024-11-03T14:02:28.105Z | 2024-11-09T14:22:40.050Z |
5455816 | 5455816 | 20241102092246_nhVsO | US0004 | 2024-11-03T14:02:24.130Z | 2024-11-09T14:22:39.878Z |
5455777 | 5455777 | 20241102091537_tLXMo | US0004 | 2024-11-03T14:02:17.797Z | 2024-11-09T14:22:39.413Z |
5455693 | 5455693 | 20241102085848_4co29 | US0004 | 2024-11-03T14:01:57.208Z | 2024-11-09T14:22:38.132Z |
5455683 | 5455683 | 20241102085539_4zJVa | US0004 | 2024-11-03T14:01:54.840Z | 2024-11-09T14:22:38.018Z |
5455642 | 5455642 | 20241102084927_piqjJ | US0004 | 2024-11-03T14:01:46.508Z | 2024-11-09T14:22:37.634Z |
5455547 | 5455547 | 20241102082345_4Fiw9 | US0004 | 2024-11-03T14:01:20.771Z | 2024-11-09T14:22:36.751Z |
5455461 | 5455461 | 20241102075711_yiSj5 | US0004 | 2024-11-03T14:01:00.846Z | 2024-11-09T14:22:35.894Z |
5455447 | 5455447 | 20241102074920_JpcoO | US0004 | 2024-11-03T14:00:57.122Z | 2024-11-09T14:22:35.644Z |
5455443 | 5455443 | 20241102074716_ddw7z | US0004 | 2024-11-03T14:00:56.660Z | 2024-11-09T14:22:35.639Z |
5455294 | 5455294 | 20241102071403_xWffi | US0004 | 2024-11-03T14:00:28.317Z | 2024-11-09T14:22:34.354Z |
5455271 | 5455271 | 20241102070746_20dAr | US0004 | 2024-11-03T14:00:24.235Z | 2024-11-09T14:22:34.120Z |
5455252 | 5455252 | 20241102070052_L0bRW | US0004 | 2024-11-03T14:00:20.530Z | 2024-11-09T14:22:33.842Z |
5455197 | 5455197 | 20241031065000_I8Wgt | US0004 | 2024-11-02T12:23:32.523Z | 2024-11-08T14:23:27.867Z |
5455155 | 5455155 | 20241031064316_IM0HQ | US0004 | 2024-11-02T12:23:32.048Z | 2024-11-08T14:23:27.727Z |
5455116 | 5455116 | 20241031063343_GIxxt | US0004 | 2024-11-02T12:23:31.339Z | 2024-11-08T14:23:27.490Z |
5455006 | 5455006 | 20241031060646_MpGWb | US0004 | 2024-11-02T12:23:29.474Z | 2024-11-08T14:23:26.815Z |
5454992 | 5454992 | 20241031060215_sLszx | US0004 | 2024-11-02T12:23:29.144Z | 2024-11-08T14:23:26.630Z |
5454892 | 5454892 | 20241031054014_4ohNe | US0004 | 2024-11-02T12:23:25.856Z | 2024-11-08T14:23:26.130Z |
5454568 | 5454568 | 20241031044010_4W423 | US0004 | 2024-11-02T12:23:11.917Z | 2024-11-08T14:23:24.129Z |
5454544 | 5454544 | 20241031043645_egEgN | US0004 | 2024-11-02T12:23:11.379Z | 2024-11-08T14:23:23.851Z |
5454447 | 5454447 | 20241031042415_X3doy | US0004 | 2024-11-02T12:23:06.373Z | 2024-11-08T14:23:23.023Z |
5454056 | 5454056 | 20241031033651_de95f | US0004 | 2024-11-02T12:22:49.793Z | 2024-11-08T14:23:20.218Z |
5454011 | 5454011 | 20241031033057_uds4a | US0004 | 2024-11-02T12:22:47.871Z | 2024-11-08T14:23:19.987Z |
5453578 | 5453578 | 20241031022644_EQX4h | US0004 | 2024-11-02T12:22:36.439Z | 2024-11-08T14:23:18.133Z |
5453494 | 5453494 | 20241031021537_D4F1Z | US0004 | 2024-11-02T12:22:34.583Z | 2024-11-08T14:23:17.610Z |
5453438 | 5453438 | 20241031021230_Uot2R | US0004 | 2024-11-02T12:22:33.733Z | 2024-11-08T14:23:17.401Z |
5453111 | 5453111 | 20241031014018_0D97H | US0004 | 2024-11-02T12:22:27.050Z | 2024-11-08T14:23:16.010Z |
5448047 | 5448047 | 20241031123603_wa4lW | US0004 | 2024-11-02T12:09:50.081Z | 2024-11-09T14:24:02.542Z |
5447978 | 5447978 | 20241031122842_7J8zA | US0004 | 2024-11-02T12:09:33.756Z | 2024-11-09T14:24:02.029Z |
5447947 | 5447947 | 20241031122530_8bRzI | US0004 | 2024-11-02T12:09:29.475Z | 2024-11-09T14:24:01.967Z |
5447917 | 5447917 | 20241031122236_JIFrc | US0004 | 2024-11-02T12:09:25.652Z | 2024-11-09T14:24:01.709Z |
5447819 | 5447819 | 20241031121347_d8gL3 | US0004 | 2024-11-02T12:09:12.936Z | 2024-11-09T14:24:01.445Z |
5447773 | 5447773 | 20241031120935_7VZBj | US0004 | 2024-11-02T12:09:04.296Z | 2024-11-09T14:24:01.361Z |
5447448 | 5447448 | 20241031114332_4Nprr | US0004 | 2024-11-02T12:08:12.613Z | 2024-11-09T14:23:59.860Z |
5447401 | 5447401 | 20241031113907_tIneq | US0004 | 2024-11-02T12:08:05.460Z | 2024-11-09T14:23:59.630Z |
5447314 | 5447314 | 20241031112959_Bcd0C | US0004 | 2024-11-02T12:07:45.479Z | 2024-11-09T14:23:58.786Z |
5447178 | 5447178 | 20241031111622_o7BOO | US0004 | 2024-11-02T12:07:27.095Z | 2024-11-09T14:23:58.182Z |
5447151 | 5447151 | 20241031111321_Nlqnv | US0004 | 2024-11-02T12:07:23.669Z | 2024-11-09T14:23:58.082Z |
5447104 | 5447104 | 20241031110803_c88yJ | US0004 | 2024-11-02T12:07:18.888Z | 2024-11-09T14:23:57.940Z |
5447067 | 5447067 | 20241031110459_ABMuU | US0004 | 2024-11-02T12:07:06.866Z | 2024-11-09T14:23:57.731Z |
5446943 | 5446943 | 20241031105101_yLec0 | US0004 | 2024-11-02T12:06:45.791Z | 2024-11-09T14:23:57.186Z |
5446936 | 5446936 | 20241031104953_BikxO | US0004 | 2024-11-02T12:06:44.509Z | 2024-11-09T14:23:57.159Z |
5446922 | 5446922 | 20241031104830_uJP7h | US0004 | 2024-11-02T12:06:43.336Z | 2024-11-09T14:23:57.139Z |
5446855 | 5446855 | 20241031104026_kLy0x | US0004 | 2024-11-02T12:06:32.414Z | 2024-11-09T14:23:56.842Z |
5446795 | 5446795 | 20241031103300_SFnx5 | US0004 | 2024-11-02T12:06:18.382Z | 2024-11-09T14:23:56.517Z |
5446647 | 5446647 | 20241031101840_m8Ajl | US0004 | 2024-11-02T12:05:58.310Z | 2024-11-09T14:23:55.489Z |
5446262 | 5446262 | 20241031094201_8eAhk | US0004 | 2024-11-02T12:04:43.659Z | 2024-11-09T14:23:54.006Z |
5446138 | 5446138 | 20241031093202_6grZ9 | US0004 | 2024-11-02T12:04:20.858Z | 2024-11-09T14:23:53.133Z |
5445728 | 5445728 | 20241031084005_PL43X | US0004 | 2024-11-02T12:02:57.808Z | 2024-11-09T14:23:51.201Z |
5445445 | 5445445 | 20241031080323_u1h3J | US0004 | 2024-11-02T12:02:04.083Z | 2024-11-09T14:23:50.060Z |
5445377 | 5445377 | 20241031075351_1BJbj | US0004 | 2024-11-02T12:01:55.211Z | 2024-11-09T14:23:49.626Z |
5445301 | 5445301 | 20241031073542_iudmX | US0004 | 2024-11-02T12:01:37.182Z | 2024-11-09T14:23:48.871Z |
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);