participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
7,471 rows where station_code = "BE0008" 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 |
---|---|---|---|---|---|
5091578 | 5091578 | 20240912021405_ieXtn | BE0008 | 2024-09-16T12:13:11.464Z | 2024-09-19T12:21:13.224Z |
5080303 | 5080303 | 20240911034809_REvN6 | BE0008 | 2024-09-15T12:16:57.019Z | 2024-09-19T12:21:43.169Z |
5047319 | 5047319 | 20240909032902_N89YL | BE0008 | 2024-09-13T12:08:47.587Z | 2024-09-17T12:19:02.027Z |
5047264 | 5047264 | 20240909031908_7aPem | BE0008 | 2024-09-13T12:08:43.408Z | 2024-09-17T12:19:01.847Z |
5046081 | 5046081 | 20240908210747_0NbTg | BE0008 | 2024-09-13T12:05:51.532Z | 2024-09-17T12:18:58.513Z |
5046078 | 5046078 | 20240908210706_QmnbW | BE0008 | 2024-09-13T12:05:50.036Z | 2024-09-17T12:18:58.509Z |
5046037 | 5046037 | 20240908204615_h9U3l | BE0008 | 2024-09-13T12:05:38.827Z | 2024-09-17T12:18:58.432Z |
5046015 | 5046015 | 20240908203859_N5Gj9 | BE0008 | 2024-09-13T12:05:34.157Z | 2024-09-17T12:18:58.386Z |
5045964 | 5045964 | 20240908202019_YWhOL | BE0008 | 2024-09-13T12:05:28.205Z | 2024-09-17T12:18:58.292Z |
5045939 | 5045939 | 20240908201523_DIYKN | BE0008 | 2024-09-13T12:05:25.081Z | 2024-09-17T12:18:58.240Z |
5038989 | 5038989 | 20240905225513_6l7AY | BE0008 | 2024-09-12T12:15:11.542Z | 2024-09-14T12:22:59.691Z |
5038810 | 5038810 | 20240905220618_Rc19V | BE0008 | 2024-09-12T12:15:02.630Z | 2024-09-14T12:22:58.187Z |
5038435 | 5038435 | 20240905201343_HDVEY | BE0008 | 2024-09-12T12:14:40.138Z | 2024-09-14T12:22:56.100Z |
5033532 | 5033532 | 20240907030642_XdzEs | BE0008 | 2024-09-12T12:09:38.000Z | 2024-09-15T12:21:30.408Z |
5033156 | 5033156 | 20240907023149_iYjE0 | BE0008 | 2024-09-12T12:08:53.515Z | 2024-09-15T12:21:29.099Z |
5033006 | 5033006 | 20240907021312_JR4Ys | BE0008 | 2024-09-12T12:08:42.642Z | 2024-09-15T12:21:28.774Z |
5024572 | 5024572 | 20240905225513_7S0XA | BE0008 | 2024-09-11T12:04:06.793Z | 2024-09-14T12:22:59.692Z |
5024389 | 5024389 | 20240905220618_y1lQb | BE0008 | 2024-09-11T12:03:31.600Z | 2024-09-11T12:16:32.110Z |
5019790 | 5019790 | 20240904235105_zJ63q | BE0008 | 2024-09-10T12:13:32.387Z | 2024-09-13T12:19:53.807Z |
5019698 | 5019698 | 20240904233637_Zw2hE | BE0008 | 2024-09-10T12:13:13.290Z | 2024-09-13T12:19:53.492Z |
5019429 | 5019429 | 20240904224702_OExlb | BE0008 | 2024-09-10T12:12:44.071Z | 2024-09-13T12:19:51.890Z |
5019355 | 5019355 | 20240904223739_6jSRy | BE0008 | 2024-09-10T12:12:39.799Z | 2024-09-13T12:19:51.504Z |
5019195 | 5019195 | 20240904220756_VfpJL | BE0008 | 2024-09-10T12:12:20.077Z | 2024-09-13T12:19:50.936Z |
5001207 | 5001207 | 20240902034940_OpMTN | BE0008 | 2024-09-08T12:16:14.723Z | 2024-09-10T12:19:32.374Z |
5001167 | 5001167 | 20240902034200_ZCHYy | BE0008 | 2024-09-08T12:16:13.074Z | 2024-09-10T12:19:32.180Z |
5000767 | 5000767 | 20240902024610_OgtqJ | BE0008 | 2024-09-08T12:15:41.825Z | 2024-09-10T12:19:29.628Z |
5000699 | 5000699 | 20240902024030_0lBzu | BE0008 | 2024-09-08T12:15:37.151Z | 2024-09-10T12:19:29.274Z |
5000523 | 5000523 | 20240902022233_92NWn | BE0008 | 2024-09-08T12:15:27.819Z | 2024-09-10T12:19:27.836Z |
5000520 | 5000520 | 20240902022228_4d0Q8 | BE0008 | 2024-09-08T12:15:27.722Z | 2024-09-10T12:19:27.822Z |
5000404 | 5000404 | 20240902020827_4PpzP | BE0008 | 2024-09-08T12:15:23.053Z | 2024-09-10T12:19:26.865Z |
4999939 | 4999939 | 20240902011436_Do3En | BE0008 | 2024-09-08T12:14:53.119Z | 2024-09-10T12:19:23.986Z |
4999753 | 4999753 | 20240902005451_4EhVH | BE0008 | 2024-09-08T12:14:44.090Z | 2024-09-10T12:19:22.209Z |
4999703 | 4999703 | 20240902005059_Kev1p | BE0008 | 2024-09-08T12:14:41.930Z | 2024-09-10T12:19:21.815Z |
4999486 | 4999486 | 20240902002641_8OK4i | BE0008 | 2024-09-08T12:14:22.804Z | 2024-09-10T12:19:19.722Z |
4999407 | 4999407 | 20240902001844_pPuhO | BE0008 | 2024-09-08T12:14:19.423Z | 2024-09-10T12:19:19.166Z |
4998710 | 4998710 | 20240903034009_mT9Og | BE0008 | 2024-09-08T12:08:01.122Z | 2024-09-11T12:21:14.475Z |
4997749 | 4997749 | 20240903012117_pVQn3 | BE0008 | 2024-09-08T12:06:46.248Z | 2024-09-11T12:21:08.251Z |
4997597 | 4997597 | 20240903005116_JFwSz | BE0008 | 2024-09-08T12:06:29.325Z | 2024-09-11T12:21:06.133Z |
4997582 | 4997582 | 20240903004747_At0D6 | BE0008 | 2024-09-08T12:06:28.092Z | 2024-09-11T12:21:05.849Z |
4997528 | 4997528 | 20240903003637_y2S3M | BE0008 | 2024-09-08T12:06:24.373Z | 2024-09-11T12:21:05.367Z |
4991779 | 4991779 | 20240901031318_GKTgg | BE0008 | 2024-09-07T12:12:28.995Z | 2024-09-09T12:27:19.515Z |
4991755 | 4991755 | 20240901031007_9f7bd | BE0008 | 2024-09-07T12:12:28.209Z | 2024-09-09T12:27:18.727Z |
4990974 | 4990974 | 20240901014016_KoS81 | BE0008 | 2024-09-07T12:11:24.460Z | 2024-09-09T12:26:56.718Z |
4989727 | 4989727 | 20240831221837_OkyCW | BE0008 | 2024-09-07T12:09:26.276Z | 2024-09-09T12:25:42.643Z |
4989541 | 4989541 | 20240901234855_1FaOT | BE0008 | 2024-09-07T12:09:06.716Z | 2024-09-10T12:19:17.880Z |
4989433 | 4989433 | 20240901233423_F30N3 | BE0008 | 2024-09-07T12:08:57.291Z | 2024-09-10T12:19:17.652Z |
4989417 | 4989417 | 20240901233300_1aoj2 | BE0008 | 2024-09-07T12:08:56.505Z | 2024-09-10T12:19:17.629Z |
4989324 | 4989324 | 20240901231229_ZpoKP | BE0008 | 2024-09-07T12:08:47.840Z | 2024-09-10T12:19:17.356Z |
4988913 | 4988913 | 20240901220042_ptfyj | BE0008 | 2024-09-07T12:08:12.968Z | 2024-09-10T12:19:15.872Z |
4983498 | 4983498 | 20240812004511_POzbI | BE0008 | 2024-09-06T12:15:35.133Z | 2024-09-06T12:15:35.133Z |
4982799 | 4982799 | 20240812003754_ry8OB | BE0008 | 2024-09-06T12:15:03.256Z | 2024-09-06T12:15:03.256Z |
4982435 | 4982435 | 20240812003333_vqd0p | BE0008 | 2024-09-06T12:14:50.832Z | 2024-09-06T12:14:50.832Z |
4982344 | 4982344 | 20240812003251_LdkSd | BE0008 | 2024-09-06T12:14:49.986Z | 2024-09-06T12:14:49.986Z |
4982271 | 4982271 | 20240812003203_s2Xil | BE0008 | 2024-09-06T12:14:48.409Z | 2024-09-06T12:14:48.409Z |
4982264 | 4982264 | 20240812003154_fBFVh | BE0008 | 2024-09-06T12:14:48.221Z | 2024-09-06T12:14:48.221Z |
4982217 | 4982217 | 20240812003135_I8w8n | BE0008 | 2024-09-06T12:14:47.286Z | 2024-09-06T12:14:47.286Z |
4982098 | 4982098 | 20240812003004_SZQkg | BE0008 | 2024-09-06T12:14:42.716Z | 2024-09-06T12:14:42.716Z |
4981926 | 4981926 | 20240812002824_XKYXJ | BE0008 | 2024-09-06T12:14:40.265Z | 2024-09-06T12:14:40.265Z |
4981805 | 4981805 | 20240812002731_9Ko8m | BE0008 | 2024-09-06T12:14:38.083Z | 2024-09-06T12:14:38.083Z |
4981248 | 4981248 | 20240812001953_E2qbc | BE0008 | 2024-09-06T12:14:28.586Z | 2024-09-06T12:14:28.586Z |
4980816 | 4980816 | 20240812001608_JniNk | BE0008 | 2024-09-06T12:14:18.970Z | 2024-09-06T12:14:18.970Z |
4980755 | 4980755 | 20240812001525_sAO6k | BE0008 | 2024-09-06T12:14:14.686Z | 2024-09-06T12:14:14.686Z |
4980673 | 4980673 | 20240812001446_C3USk | BE0008 | 2024-09-06T12:14:11.312Z | 2024-09-06T12:14:11.312Z |
4980631 | 4980631 | 20240812001426_77M5m | BE0008 | 2024-09-06T12:14:09.060Z | 2024-09-06T12:14:09.060Z |
4980361 | 4980361 | 20240812001125_0vwox | BE0008 | 2024-09-06T12:13:56.400Z | 2024-09-06T12:13:56.400Z |
4980299 | 4980299 | 20240812001114_JPyCr | BE0008 | 2024-09-06T12:13:55.484Z | 2024-09-06T12:13:55.484Z |
4980223 | 4980223 | 20240812001016_i5FKu | BE0008 | 2024-09-06T12:13:53.865Z | 2024-09-06T12:13:53.865Z |
4980010 | 4980010 | 20240812000721_cTnKJ | BE0008 | 2024-09-06T12:13:42.512Z | 2024-09-06T12:13:42.512Z |
4979830 | 4979830 | 20240812000524_hNjLi | BE0008 | 2024-09-06T12:13:31.805Z | 2024-09-06T12:13:31.805Z |
4979777 | 4979777 | 20240812000438_ArD8p | BE0008 | 2024-09-06T12:13:27.584Z | 2024-09-06T12:13:27.584Z |
4979717 | 4979717 | 20240812000354_mw1jp | BE0008 | 2024-09-06T12:13:24.209Z | 2024-09-06T12:13:24.209Z |
4979034 | 4979034 | 20240811235833_lPEyH | BE0008 | 2024-09-06T12:12:53.628Z | 2024-09-06T12:12:53.628Z |
4977798 | 4977798 | 20240811234448_AoTK8 | BE0008 | 2024-09-06T12:12:23.326Z | 2024-09-06T12:12:23.326Z |
4977110 | 4977110 | 20240811233627_VafAM | BE0008 | 2024-09-06T12:12:04.501Z | 2024-09-06T12:12:04.501Z |
4977040 | 4977040 | 20240811233551_JolDN | BE0008 | 2024-09-06T12:12:02.052Z | 2024-09-06T12:12:02.052Z |
4976034 | 4976034 | 20240811232512_tV42z | BE0008 | 2024-09-06T12:11:03.050Z | 2024-09-06T12:11:03.050Z |
4975917 | 4975917 | 20240811232317_oje4h | BE0008 | 2024-09-06T12:10:54.689Z | 2024-09-06T12:10:54.689Z |
4975664 | 4975664 | 20240811232059_EpE73 | BE0008 | 2024-09-06T12:10:47.166Z | 2024-09-06T12:10:47.166Z |
4975275 | 4975275 | 20240811231647_dszAk | BE0008 | 2024-09-05T12:11:44.135Z | 2024-09-06T12:10:39.370Z |
4974545 | 4974545 | 20240811230759_3vmb3 | BE0008 | 2024-09-05T12:11:26.226Z | 2024-09-06T12:10:28.000Z |
4974507 | 4974507 | 20240811230747_3PjIe | BE0008 | 2024-09-05T12:11:25.819Z | 2024-09-06T12:10:27.631Z |
4974132 | 4974132 | 20240811230345_TWLyH | BE0008 | 2024-09-05T12:11:19.202Z | 2024-09-06T12:10:22.243Z |
4973917 | 4973917 | 20240811230140_RVCCV | BE0008 | 2024-09-05T12:11:14.119Z | 2024-09-06T12:10:10.942Z |
4973553 | 4973553 | 20240811225809_EeuK8 | BE0008 | 2024-09-05T12:10:59.337Z | 2024-09-06T12:10:00.065Z |
4973225 | 4973225 | 20240811225455_f446v | BE0008 | 2024-09-05T12:10:44.663Z | 2024-09-06T12:09:49.023Z |
4972677 | 4972677 | 20240811224922_fmJMa | BE0008 | 2024-09-05T12:10:31.621Z | 2024-09-06T12:09:23.637Z |
4971842 | 4971842 | 20240811224026_2nRJ4 | BE0008 | 2024-09-05T12:10:05.117Z | 2024-09-06T12:08:59.040Z |
4971831 | 4971831 | 20240811224025_Jj3bI | BE0008 | 2024-09-05T12:10:04.767Z | 2024-09-06T12:08:59.006Z |
4971310 | 4971310 | 20240811223409_vV2Wy | BE0008 | 2024-09-05T12:09:42.835Z | 2024-09-06T12:08:52.043Z |
4971286 | 4971286 | 20240811223341_DWwgg | BE0008 | 2024-09-05T12:09:42.320Z | 2024-09-06T12:08:51.581Z |
4971248 | 4971248 | 20240811223315_NNpr2 | BE0008 | 2024-09-05T12:09:41.682Z | 2024-09-06T12:08:50.990Z |
4971081 | 4971081 | 20240811223151_RF1eM | BE0008 | 2024-09-05T12:09:37.402Z | 2024-09-06T12:08:48.799Z |
4970782 | 4970782 | 20240811222835_DAUOR | BE0008 | 2024-09-05T12:09:31.985Z | 2024-09-06T12:08:44.608Z |
4970698 | 4970698 | 20240811222807_vhrD5 | BE0008 | 2024-09-05T12:09:31.250Z | 2024-09-06T12:08:44.129Z |
4970573 | 4970573 | 20240811222652_0foBN | BE0008 | 2024-09-05T12:09:28.879Z | 2024-09-06T12:08:42.252Z |
4970264 | 4970264 | 20240811222313_ll8IM | BE0008 | 2024-09-05T12:09:23.265Z | 2024-09-06T12:08:34.190Z |
4970228 | 4970228 | 20240811222241_pkqL8 | BE0008 | 2024-09-05T12:09:22.364Z | 2024-09-06T12:08:31.819Z |
4970101 | 4970101 | 20240811222103_7EFQE | BE0008 | 2024-09-05T12:09:18.744Z | 2024-09-06T12:08:22.417Z |
4969609 | 4969609 | 20240811221331_cMOsp | BE0008 | 2024-09-05T12:08:49.172Z | 2024-09-06T12:07:55.529Z |
4969565 | 4969565 | 20240811221316_b53rT | BE0008 | 2024-09-05T12:08:48.425Z | 2024-09-06T12:07:55.092Z |
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);