participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "US0006" 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 |
---|---|---|---|---|---|
5505462 | 5505462 | 20241108052655_XJ54m | US0006 | 2024-11-09T14:16:19.245Z | 2024-11-09T14:16:28.791Z |
5505370 | 5505370 | 20241108045443_ihmzu | US0006 | 2024-11-09T14:16:14.077Z | 2024-11-09T14:16:28.767Z |
5498342 | 5498342 | 20241108081256_gQAZh | US0006 | 2024-11-09T14:01:11.481Z | 2024-11-09T14:01:11.481Z |
5498272 | 5498272 | 20241108074753_MGRwR | US0006 | 2024-11-09T14:01:00.812Z | 2024-11-09T14:01:00.812Z |
5498270 | 5498270 | 20241108074732_ET2wR | US0006 | 2024-11-09T14:01:00.480Z | 2024-11-09T14:01:00.480Z |
5498176 | 5498176 | 20241108072224_NP6Dq | US0006 | 2024-11-09T14:00:43.448Z | 2024-11-09T14:00:43.448Z |
5480339 | 5480339 | 20241105123033_X89lm | US0006 | 2024-11-06T14:05:17.292Z | 2024-11-09T14:19:22.957Z |
5480331 | 5480331 | 20241105122919_xRWd3 | US0006 | 2024-11-06T14:05:16.192Z | 2024-11-09T14:19:22.927Z |
5480306 | 5480306 | 20241105122026_OtVtJ | US0006 | 2024-11-06T14:05:12.491Z | 2024-11-09T14:19:22.472Z |
5480261 | 5480261 | 20241105121123_fUnQV | US0006 | 2024-11-06T14:05:05.246Z | 2024-11-09T14:19:21.502Z |
5480222 | 5480222 | 20241105120354_2LEvI | US0006 | 2024-11-06T14:04:59.436Z | 2024-11-09T14:19:20.577Z |
5480190 | 5480190 | 20241105120059_AHVhw | US0006 | 2024-11-06T14:04:49.556Z | 2024-11-09T14:19:19.961Z |
5480143 | 5480143 | 20241105114641_X0FUc | US0006 | 2024-11-06T14:04:37.807Z | 2024-11-09T14:19:18.914Z |
5480115 | 5480115 | 20241105114256_H0vQH | US0006 | 2024-11-06T14:04:32.988Z | 2024-11-09T14:19:18.479Z |
5480004 | 5480004 | 20241105111517_242UF | US0006 | 2024-11-06T14:04:18.311Z | 2024-11-09T14:19:14.944Z |
5479864 | 5479864 | 20241105105414_dpKbH | US0006 | 2024-11-06T14:03:46.255Z | 2024-11-09T14:19:13.319Z |
5479849 | 5479849 | 20241105105252_SAjpX | US0006 | 2024-11-06T14:03:44.475Z | 2024-11-09T14:19:13.159Z |
5479681 | 5479681 | 20241105101809_X59E0 | US0006 | 2024-11-06T14:03:04.540Z | 2024-11-09T14:19:10.474Z |
5479560 | 5479560 | 20241105095752_36yP3 | US0006 | 2024-11-06T14:02:46.047Z | 2024-11-09T14:19:09.175Z |
5479319 | 5479319 | 20241105090505_PGWvm | US0006 | 2024-11-06T14:01:59.794Z | 2024-11-09T14:19:04.189Z |
5479288 | 5479288 | 20241105085903_ow2XU | US0006 | 2024-11-06T14:01:45.530Z | 2024-11-09T14:19:03.455Z |
5469007 | 5469007 | 20241103022216_gbBpb | US0006 | 2024-11-04T14:15:22.321Z | 2024-11-09T14:23:00.635Z |
5468967 | 5468967 | 20241103021657_zN6yK | US0006 | 2024-11-04T14:15:19.305Z | 2024-11-09T14:23:00.490Z |
5468832 | 5468832 | 20241103015442_0PrIi | US0006 | 2024-11-04T14:15:07.085Z | 2024-11-09T14:22:59.944Z |
5468655 | 5468655 | 20241103011621_qHJ60 | US0006 | 2024-11-04T14:14:46.941Z | 2024-11-09T14:22:59.210Z |
5465519 | 5465519 | 20241102073319_kHz6L | US0006 | 2024-11-04T14:04:14.197Z | 2024-11-09T14:22:35.113Z |
5464028 | 5464028 | 20241102063831_47KIo | US0006 | 2024-11-03T14:19:30.243Z | 2024-11-09T14:23:45.354Z |
5463660 | 5463660 | 20241102043136_nmFKy | US0006 | 2024-11-03T14:19:07.779Z | 2024-11-09T14:23:43.054Z |
5463618 | 5463618 | 20241102042043_dDbm8 | US0006 | 2024-11-03T14:19:02.567Z | 2024-11-09T14:23:42.766Z |
5463544 | 5463544 | 20241102035739_7eM7f | US0006 | 2024-11-03T14:18:56.216Z | 2024-11-09T14:23:41.924Z |
5459594 | 5459594 | 20241101112156_YrA6S | US0006 | 2024-11-03T14:12:21.038Z | 2024-11-09T14:23:19.957Z |
5459536 | 5459536 | 20241101111407_eX2YV | US0006 | 2024-11-03T14:12:15.456Z | 2024-11-09T14:23:18.907Z |
5459500 | 5459500 | 20241101110912_YCAtC | US0006 | 2024-11-03T14:12:02.561Z | 2024-11-09T14:23:18.588Z |
5459263 | 5459263 | 20241101103208_SXvJI | US0006 | 2024-11-03T14:11:35.511Z | 2024-11-09T14:23:17.169Z |
5459226 | 5459226 | 20241101102619_yGjdO | US0006 | 2024-11-03T14:11:31.712Z | 2024-11-09T14:23:17.077Z |
5459162 | 5459162 | 20241101101904_6KQK7 | US0006 | 2024-11-03T14:11:26.271Z | 2024-11-09T14:23:16.848Z |
5459158 | 5459158 | 20241101101826_jPePR | US0006 | 2024-11-03T14:11:25.751Z | 2024-11-09T14:23:16.837Z |
5458922 | 5458922 | 20241101094323_I5Fts | US0006 | 2024-11-03T14:10:49.511Z | 2024-11-09T14:23:15.142Z |
5458891 | 5458891 | 20241101093811_COCRg | US0006 | 2024-11-03T14:10:47.204Z | 2024-11-09T14:23:14.879Z |
5458791 | 5458791 | 20241101091857_V9yNs | US0006 | 2024-11-03T14:10:37.648Z | 2024-11-09T14:23:14.523Z |
5458728 | 5458728 | 20241101090643_SCIeV | US0006 | 2024-11-03T14:10:31.566Z | 2024-11-09T14:23:13.973Z |
5458474 | 5458474 | 20241101083139_Xbg6v | US0006 | 2024-11-03T14:09:49.209Z | 2024-11-09T14:23:12.375Z |
5458397 | 5458397 | 20241101082125_kOW7V | US0006 | 2024-11-03T14:09:42.675Z | 2024-11-09T14:23:11.921Z |
5458376 | 5458376 | 20241101081835_NLa2O | US0006 | 2024-11-03T14:09:40.737Z | 2024-11-09T14:23:11.835Z |
5458303 | 5458303 | 20241101080140_Zwcqa | US0006 | 2024-11-03T14:09:33.820Z | 2024-11-09T14:23:11.448Z |
5458270 | 5458270 | 20241101075909_0y6Ft | US0006 | 2024-11-03T14:09:25.492Z | 2024-11-09T14:23:11.169Z |
5456764 | 5456764 | 20241102121937_key5g | US0006 | 2024-11-03T14:05:39.053Z | 2024-11-09T14:22:45.577Z |
5456743 | 5456743 | 20241102121317_OQZps | US0006 | 2024-11-03T14:05:36.208Z | 2024-11-09T14:22:45.330Z |
5456726 | 5456726 | 20241102121123_3wUl1 | US0006 | 2024-11-03T14:05:33.860Z | 2024-11-09T14:22:45.287Z |
5456641 | 5456641 | 20241102115724_sHlcg | US0006 | 2024-11-03T14:05:11.592Z | 2024-11-09T14:22:44.818Z |
5456518 | 5456518 | 20241102113809_mS3hH | US0006 | 2024-11-03T14:04:54.357Z | 2024-11-09T14:22:44.310Z |
5456516 | 5456516 | 20241102113758_3cGDA | US0006 | 2024-11-03T14:04:54.041Z | 2024-11-09T14:22:44.306Z |
5456494 | 5456494 | 20241102113407_ZXw6W | US0006 | 2024-11-03T14:04:50.599Z | 2024-11-09T14:22:44.120Z |
5456330 | 5456330 | 20241102110127_ipnNf | US0006 | 2024-11-03T14:04:13.971Z | 2024-11-09T14:22:42.910Z |
5456325 | 5456325 | 20241102105935_jlWhU | US0006 | 2024-11-03T14:04:13.138Z | 2024-11-09T14:22:42.867Z |
5456121 | 5456121 | 20241102102503_iICos | US0006 | 2024-11-03T14:03:24.131Z | 2024-11-09T14:22:42.012Z |
5456103 | 5456103 | 20241102102133_IjelU | US0006 | 2024-11-03T14:03:21.529Z | 2024-11-09T14:22:41.950Z |
5455958 | 5455958 | 20241102095247_VcBm5 | US0006 | 2024-11-03T14:02:59.070Z | 2024-11-09T14:22:41.093Z |
5455871 | 5455871 | 20241102093606_ytW7i | US0006 | 2024-11-03T14:02:32.400Z | 2024-11-09T14:22:40.419Z |
5455843 | 5455843 | 20241102093016_OoDe5 | US0006 | 2024-11-03T14:02:28.576Z | 2024-11-09T14:22:40.092Z |
5455778 | 5455778 | 20241102091537_tLXMo | US0006 | 2024-11-03T14:02:17.797Z | 2024-11-09T14:22:39.413Z |
5455694 | 5455694 | 20241102085848_4co29 | US0006 | 2024-11-03T14:01:57.208Z | 2024-11-09T14:22:38.132Z |
5455684 | 5455684 | 20241102085539_4zJVa | US0006 | 2024-11-03T14:01:54.840Z | 2024-11-09T14:22:38.018Z |
5455620 | 5455620 | 20241102084532_MGtAc | US0006 | 2024-11-03T14:01:43.021Z | 2024-11-09T14:22:37.470Z |
5455607 | 5455607 | 20241102084246_vOosp | US0006 | 2024-11-03T14:01:39.905Z | 2024-11-09T14:22:37.391Z |
5455577 | 5455577 | 20241102083507_cwC5o | US0006 | 2024-11-03T14:01:33.656Z | 2024-11-09T14:22:37.185Z |
5455532 | 5455532 | 20241102082007_Xfd08 | US0006 | 2024-11-03T14:01:12.614Z | 2024-11-09T14:22:36.683Z |
5455472 | 5455472 | 20241102075932_5oXSC | US0006 | 2024-11-03T14:01:02.530Z | 2024-11-09T14:22:35.982Z |
5455468 | 5455468 | 20241102075851_cPgby | US0006 | 2024-11-03T14:01:01.771Z | 2024-11-09T14:22:35.930Z |
5455459 | 5455459 | 20241102075707_KEBdo | US0006 | 2024-11-03T14:01:00.263Z | 2024-11-09T14:22:35.851Z |
5455300 | 5455300 | 20241102071422_2Z533 | US0006 | 2024-11-03T14:00:28.955Z | 2024-11-09T14:22:34.391Z |
5455295 | 5455295 | 20241102071403_xWffi | US0006 | 2024-11-03T14:00:28.317Z | 2024-11-09T14:22:34.354Z |
5455292 | 5455292 | 20241102071246_ZswvE | US0006 | 2024-11-03T14:00:27.580Z | 2024-11-09T14:22:34.297Z |
5455258 | 5455258 | 20241102070221_ThDjv | US0006 | 2024-11-03T14:00:21.850Z | 2024-11-09T14:22:33.974Z |
5455117 | 5455117 | 20241031063343_GIxxt | US0006 | 2024-11-02T12:23:31.339Z | 2024-11-08T14:23:27.490Z |
5455061 | 5455061 | 20241031062000_1oxS5 | US0006 | 2024-11-02T12:23:30.272Z | 2024-11-08T14:23:27.163Z |
5455020 | 5455020 | 20241031060853_WyOkC | US0006 | 2024-11-02T12:23:29.683Z | 2024-11-08T14:23:26.892Z |
5454993 | 5454993 | 20241031060215_sLszx | US0006 | 2024-11-02T12:23:29.144Z | 2024-11-08T14:23:26.630Z |
5454882 | 5454882 | 20241031053915_SMRb2 | US0006 | 2024-11-02T12:23:25.741Z | 2024-11-08T14:23:26.122Z |
5454665 | 5454665 | 20241031045325_nTmGY | US0006 | 2024-11-02T12:23:15.988Z | 2024-11-08T14:23:24.659Z |
5454569 | 5454569 | 20241031044010_4W423 | US0006 | 2024-11-02T12:23:11.917Z | 2024-11-08T14:23:24.129Z |
5454057 | 5454057 | 20241031033651_de95f | US0006 | 2024-11-02T12:22:49.793Z | 2024-11-08T14:23:20.218Z |
5453495 | 5453495 | 20241031021537_D4F1Z | US0006 | 2024-11-02T12:22:34.583Z | 2024-11-08T14:23:17.610Z |
5453115 | 5453115 | 20241031014145_BZKhv | US0006 | 2024-11-02T12:22:27.112Z | 2024-11-08T14:23:16.023Z |
5453029 | 5453029 | 20241101064726_cQgkb | US0006 | 2024-11-02T12:19:42.291Z | 2024-11-09T14:24:37.978Z |
5452782 | 5452782 | 20241101043313_3j1Yq | US0006 | 2024-11-02T12:19:21.668Z | 2024-11-09T14:24:33.680Z |
5452718 | 5452718 | 20241101041411_OojLk | US0006 | 2024-11-02T12:19:17.009Z | 2024-11-09T14:24:33.360Z |
5452647 | 5452647 | 20241101035911_ISzjV | US0006 | 2024-11-02T12:19:08.912Z | 2024-11-09T14:24:32.331Z |
5452216 | 5452216 | 20241101022416_QL2jI | US0006 | 2024-11-02T12:18:28.814Z | 2024-11-09T14:24:29.551Z |
5452193 | 5452193 | 20241101022053_cbfh2 | US0006 | 2024-11-02T12:18:25.532Z | 2024-11-09T14:24:28.745Z |
5452071 | 5452071 | 20241101015213_b4yak | US0006 | 2024-11-02T12:18:15.137Z | 2024-11-09T14:24:27.834Z |
5452005 | 5452005 | 20241101014313_SDbbB | US0006 | 2024-11-02T12:18:10.652Z | 2024-11-09T14:24:27.565Z |
5451872 | 5451872 | 20241101011839_JRbYX | US0006 | 2024-11-02T12:18:03.216Z | 2024-11-09T14:24:26.278Z |
5451855 | 5451855 | 20241101011539_LCw8V | US0006 | 2024-11-02T12:18:01.724Z | 2024-11-09T14:24:26.229Z |
5447863 | 5447863 | 20241031121803_YTRvL | US0006 | 2024-11-02T12:09:20.228Z | 2024-11-09T14:24:01.552Z |
5447498 | 5447498 | 20241031114724_Cn3yc | US0006 | 2024-11-02T12:08:19.710Z | 2024-11-09T14:24:00.099Z |
5447361 | 5447361 | 20241031113525_H0twO | US0006 | 2024-11-02T12:07:59.806Z | 2024-11-09T14:23:59.443Z |
5447305 | 5447305 | 20241031112842_qZhf2 | US0006 | 2024-11-02T12:07:44.080Z | 2024-11-09T14:23:58.767Z |
5447212 | 5447212 | 20241031111902_OrY7u | US0006 | 2024-11-02T12:07:30.279Z | 2024-11-09T14:23:58.407Z |
5447023 | 5447023 | 20241031105916_HvT6T | US0006 | 2024-11-02T12:06:57.347Z | 2024-11-09T14:23:57.414Z |
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);