participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,369 rows where station_code = "BE000E" 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 |
---|---|---|---|---|---|
5097374 | 5097374 | 20240913004427_JGYnb | BE000E | 2024-09-16T12:17:11.780Z | 2024-09-16T12:17:11.780Z |
5097231 | 5097231 | 20240913003803_w8iHl | BE000E | 2024-09-16T12:17:08.893Z | 2024-09-16T12:17:08.893Z |
5090644 | 5090644 | 20240912013551_X6yoD | BE000E | 2024-09-16T12:12:27.512Z | 2024-09-16T12:17:30.776Z |
5090563 | 5090563 | 20240912013205_YMsC6 | BE000E | 2024-09-16T12:12:24.551Z | 2024-09-16T12:17:30.766Z |
5090453 | 5090453 | 20240912012559_czsYD | BE000E | 2024-09-16T12:12:20.675Z | 2024-09-16T12:17:30.754Z |
5088531 | 5088531 | 20240913001448_XKEqP | BE000E | 2024-09-16T12:08:09.263Z | 2024-09-16T12:17:05.816Z |
5088511 | 5088511 | 20240913001432_VaHSd | BE000E | 2024-09-16T12:08:08.101Z | 2024-09-16T12:17:05.806Z |
5088411 | 5088411 | 20240913001011_R97lg | BE000E | 2024-09-16T12:07:58.855Z | 2024-09-16T12:17:05.774Z |
5087564 | 5087564 | 20240912233242_vSBr0 | BE000E | 2024-09-16T12:07:04.937Z | 2024-09-16T12:17:05.532Z |
5087363 | 5087363 | 20240912232607_aKwMZ | BE000E | 2024-09-16T12:06:54.083Z | 2024-09-16T12:17:05.463Z |
5087248 | 5087248 | 20240912231753_pbhIF | BE000E | 2024-09-16T12:06:49.021Z | 2024-09-16T12:17:05.433Z |
5087174 | 5087174 | 20240912231353_fHPTU | BE000E | 2024-09-16T12:06:45.107Z | 2024-09-16T12:17:05.411Z |
5087165 | 5087165 | 20240912231214_EnA22 | BE000E | 2024-09-16T12:06:43.939Z | 2024-09-16T12:17:05.398Z |
5087145 | 5087145 | 20240912231121_OIll3 | BE000E | 2024-09-16T12:06:41.572Z | 2024-09-16T12:17:05.388Z |
5086924 | 5086924 | 20240912225713_t0Twa | BE000E | 2024-09-16T12:06:13.257Z | 2024-09-16T12:17:05.318Z |
5086724 | 5086724 | 20240912224610_SlakL | BE000E | 2024-09-16T12:05:58.462Z | 2024-09-16T12:17:05.235Z |
5086236 | 5086236 | 20240912222104_4J3ev | BE000E | 2024-09-16T12:05:23.863Z | 2024-09-16T12:17:05.069Z |
5086209 | 5086209 | 20240912221824_NZ2P9 | BE000E | 2024-09-16T12:05:21.209Z | 2024-09-16T12:17:05.060Z |
5085835 | 5085835 | 20240912215337_bYrkT | BE000E | 2024-09-16T12:04:57.726Z | 2024-09-16T12:17:04.874Z |
5084497 | 5084497 | 20240912194347_vNhMS | BE000E | 2024-09-16T12:02:10.732Z | 2024-09-16T12:17:04.326Z |
5065379 | 5065379 | 20240910035800_BKj85 | BE000E | 2024-09-14T12:17:02.619Z | 2024-09-16T12:19:56.901Z |
5064534 | 5064534 | 20240910012849_b0ylu | BE000E | 2024-09-14T12:15:36.036Z | 2024-09-16T12:19:51.246Z |
5054734 | 5054734 | 20240908034818_sdmEb | BE000E | 2024-09-13T12:16:54.678Z | 2024-09-16T12:21:16.762Z |
5054196 | 5054196 | 20240908022416_337qs | BE000E | 2024-09-13T12:16:33.697Z | 2024-09-16T12:21:14.276Z |
5054178 | 5054178 | 20240908022057_LfD0u | BE000E | 2024-09-13T12:16:32.517Z | 2024-09-16T12:21:14.211Z |
5053872 | 5053872 | 20240908014245_WkDIV | BE000E | 2024-09-13T12:16:20.290Z | 2024-09-16T12:21:12.948Z |
5053685 | 5053685 | 20240908011729_32JtT | BE000E | 2024-09-13T12:16:13.439Z | 2024-09-16T12:21:12.414Z |
5053454 | 5053454 | 20240908003749_iE3an | BE000E | 2024-09-13T12:16:04.702Z | 2024-09-16T12:21:11.274Z |
5053358 | 5053358 | 20240908001915_Ih2vB | BE000E | 2024-09-13T12:16:00.274Z | 2024-09-16T12:21:10.404Z |
5039307 | 5039307 | 20240906001803_DE701 | BE000E | 2024-09-12T12:15:25.728Z | 2024-09-14T12:23:01.362Z |
5033232 | 5033232 | 20240907024025_WNH31 | BE000E | 2024-09-12T12:08:59.864Z | 2024-09-15T12:21:29.266Z |
5032716 | 5032716 | 20240907013923_3OnuA | BE000E | 2024-09-12T12:07:53.765Z | 2024-09-15T12:21:27.545Z |
5032005 | 5032005 | 20240906235303_Rmv4G | BE000E | 2024-09-12T12:06:22.866Z | 2024-09-15T12:21:24.978Z |
5031935 | 5031935 | 20240906234348_aZA71 | BE000E | 2024-09-12T12:06:07.336Z | 2024-09-15T12:21:24.714Z |
5024935 | 5024935 | 20240906001803_RZWY6 | BE000E | 2024-09-11T12:05:16.244Z | 2024-09-11T12:16:32.390Z |
5010006 | 5010006 | 20240904022457_dVVdW | BE000E | 2024-09-09T12:08:17.854Z | 2024-09-12T12:19:25.385Z |
5009596 | 5009596 | 20240904014033_V7YmY | BE000E | 2024-09-09T12:07:51.408Z | 2024-09-12T12:19:23.628Z |
5008508 | 5008508 | 20240903234957_nuaYK | BE000E | 2024-09-09T12:06:50.885Z | 2024-09-12T12:19:17.944Z |
5007952 | 5007952 | 20240903224344_67j9c | BE000E | 2024-09-09T12:06:17.090Z | 2024-09-12T12:19:15.589Z |
5001252 | 5001252 | 20240902040128_2Zxp1 | BE000E | 2024-09-08T12:16:16.674Z | 2024-09-10T12:19:32.519Z |
5001215 | 5001215 | 20240902035047_rmQMW | BE000E | 2024-09-08T12:16:15.113Z | 2024-09-10T12:19:32.423Z |
5001160 | 5001160 | 20240902034038_q1S4X | BE000E | 2024-09-08T12:16:12.659Z | 2024-09-10T12:19:32.146Z |
5001133 | 5001133 | 20240902033541_5xUYO | BE000E | 2024-09-08T12:16:11.347Z | 2024-09-10T12:19:32.029Z |
5001021 | 5001021 | 20240902031557_oTCYg | BE000E | 2024-09-08T12:16:06.189Z | 2024-09-10T12:19:31.092Z |
5000865 | 5000865 | 20240902025702_FfvGN | BE000E | 2024-09-08T12:15:57.826Z | 2024-09-10T12:19:30.128Z |
5000852 | 5000852 | 20240902025539_w96ri | BE000E | 2024-09-08T12:15:56.550Z | 2024-09-10T12:19:30.066Z |
5000835 | 5000835 | 20240902025346_3PsAO | BE000E | 2024-09-08T12:15:53.513Z | 2024-09-10T12:19:29.938Z |
5000746 | 5000746 | 20240902024514_aZEEd | BE000E | 2024-09-08T12:15:38.884Z | 2024-09-10T12:19:29.564Z |
5000711 | 5000711 | 20240902024144_1QqRl | BE000E | 2024-09-08T12:15:37.533Z | 2024-09-10T12:19:29.518Z |
5000690 | 5000690 | 20240902023904_Sis1y | BE000E | 2024-09-08T12:15:36.801Z | 2024-09-10T12:19:29.265Z |
5000611 | 5000611 | 20240902022953_hS3ny | BE000E | 2024-09-08T12:15:31.191Z | 2024-09-10T12:19:28.620Z |
5000606 | 5000606 | 20240902022843_pMYVB | BE000E | 2024-09-08T12:15:30.926Z | 2024-09-10T12:19:28.572Z |
5000586 | 5000586 | 20240902022606_9JRI2 | BE000E | 2024-09-08T12:15:30.133Z | 2024-09-10T12:19:28.217Z |
5000496 | 5000496 | 20240902021916_ifVyD | BE000E | 2024-09-08T12:15:26.656Z | 2024-09-10T12:19:27.570Z |
5000226 | 5000226 | 20240902014736_exgUG | BE000E | 2024-09-08T12:15:16.702Z | 2024-09-10T12:19:26.268Z |
5000093 | 5000093 | 20240902013310_2Wb6u | BE000E | 2024-09-08T12:15:09.795Z | 2024-09-10T12:19:24.897Z |
4999863 | 4999863 | 20240902010427_nCuO6 | BE000E | 2024-09-08T12:14:47.913Z | 2024-09-10T12:19:23.701Z |
4999750 | 4999750 | 20240902005445_3xA32 | BE000E | 2024-09-08T12:14:43.904Z | 2024-09-10T12:19:22.195Z |
4999744 | 4999744 | 20240902005442_4dAgU | BE000E | 2024-09-08T12:14:43.812Z | 2024-09-10T12:19:22.187Z |
4997248 | 4997248 | 20240902233831_d3WOq | BE000E | 2024-09-08T12:05:57.010Z | 2024-09-11T12:21:02.634Z |
4997084 | 4997084 | 20240902230222_Nve3E | BE000E | 2024-09-08T12:05:45.223Z | 2024-09-11T12:21:01.059Z |
4997068 | 4997068 | 20240902225639_mCJ3W | BE000E | 2024-09-08T12:05:43.836Z | 2024-09-11T12:21:00.884Z |
4996447 | 4996447 | 20240902194114_5f8k4 | BE000E | 2024-09-08T12:04:49.647Z | 2024-09-11T12:20:54.519Z |
4990442 | 4990442 | 20240901001500_FBKl3 | BE000E | 2024-09-07T12:10:35.846Z | 2024-09-09T12:26:19.847Z |
4989604 | 4989604 | 20240901235632_86cBe | BE000E | 2024-09-07T12:09:11.113Z | 2024-09-10T12:19:18.141Z |
4989573 | 4989573 | 20240901235110_DUko1 | BE000E | 2024-09-07T12:09:08.461Z | 2024-09-10T12:19:17.976Z |
4989474 | 4989474 | 20240901233959_pxH14 | BE000E | 2024-09-07T12:09:01.395Z | 2024-09-10T12:19:17.736Z |
4989338 | 4989338 | 20240901231703_O5UJo | BE000E | 2024-09-07T12:08:48.485Z | 2024-09-10T12:19:17.405Z |
4989092 | 4989092 | 20240901223746_saGx0 | BE000E | 2024-09-07T12:08:29.868Z | 2024-09-10T12:19:16.629Z |
4988976 | 4988976 | 20240901221350_5Bbyc | BE000E | 2024-09-07T12:08:17.382Z | 2024-09-10T12:19:16.273Z |
4988925 | 4988925 | 20240901220100_LQtLQ | BE000E | 2024-09-07T12:08:13.496Z | 2024-09-10T12:19:15.889Z |
4988893 | 4988893 | 20240901215421_ZYiPV | BE000E | 2024-09-07T12:08:09.429Z | 2024-09-10T12:19:15.796Z |
4988060 | 4988060 | 20240901194712_wKr9z | BE000E | 2024-09-07T12:06:46.994Z | 2024-09-10T12:19:12.424Z |
4983350 | 4983350 | 20240812004335_CH2rS | BE000E | 2024-09-06T12:15:28.192Z | 2024-09-06T12:15:28.192Z |
4983321 | 4983321 | 20240812004317_MMteY | BE000E | 2024-09-06T12:15:26.563Z | 2024-09-06T12:15:26.563Z |
4982665 | 4982665 | 20240812003532_2RGzD | BE000E | 2024-09-06T12:14:58.280Z | 2024-09-06T12:14:58.280Z |
4982196 | 4982196 | 20240812003119_jWgpy | BE000E | 2024-09-06T12:14:46.875Z | 2024-09-06T12:14:46.875Z |
4981121 | 4981121 | 20240812001853_Kq3q2 | BE000E | 2024-09-06T12:14:26.597Z | 2024-09-06T12:14:26.597Z |
4981049 | 4981049 | 20240812001828_43KFJ | BE000E | 2024-09-06T12:14:25.839Z | 2024-09-06T12:14:25.839Z |
4980919 | 4980919 | 20240812001705_rQeZU | BE000E | 2024-09-06T12:14:24.224Z | 2024-09-06T12:14:24.224Z |
4980865 | 4980865 | 20240812001646_uQ8vL | BE000E | 2024-09-06T12:14:22.142Z | 2024-09-06T12:14:22.142Z |
4980778 | 4980778 | 20240812001540_2f8W1 | BE000E | 2024-09-06T12:14:16.265Z | 2024-09-06T12:14:16.265Z |
4980491 | 4980491 | 20240812001301_o1Gb6 | BE000E | 2024-09-06T12:14:03.098Z | 2024-09-06T12:14:03.098Z |
4979657 | 4979657 | 20240812000311_hxIww | BE000E | 2024-09-06T12:13:20.281Z | 2024-09-06T12:13:20.281Z |
4979450 | 4979450 | 20240812000212_NKJ5l | BE000E | 2024-09-06T12:13:16.148Z | 2024-09-06T12:13:16.148Z |
4979145 | 4979145 | 20240811235936_f3ET8 | BE000E | 2024-09-06T12:12:59.394Z | 2024-09-06T12:12:59.394Z |
4978983 | 4978983 | 20240811235803_zL1EV | BE000E | 2024-09-06T12:12:49.078Z | 2024-09-06T12:12:49.078Z |
4978739 | 4978739 | 20240811235435_s4TxH | BE000E | 2024-09-06T12:12:41.665Z | 2024-09-06T12:12:41.665Z |
4978347 | 4978347 | 20240811234959_O8TVS | BE000E | 2024-09-06T12:12:32.885Z | 2024-09-06T12:12:32.885Z |
4978105 | 4978105 | 20240811234805_EnvL8 | BE000E | 2024-09-06T12:12:29.689Z | 2024-09-06T12:12:29.689Z |
4977294 | 4977294 | 20240811233831_Dwi0E | BE000E | 2024-09-06T12:12:11.414Z | 2024-09-06T12:12:11.414Z |
4977122 | 4977122 | 20240811233631_PF2E8 | BE000E | 2024-09-06T12:12:04.873Z | 2024-09-06T12:12:04.873Z |
4976885 | 4976885 | 20240811233435_8Mo6K | BE000E | 2024-09-06T12:11:56.287Z | 2024-09-06T12:11:56.287Z |
4976713 | 4976713 | 20240811233242_c5eLx | BE000E | 2024-09-06T12:11:43.616Z | 2024-09-06T12:11:43.616Z |
4976536 | 4976536 | 20240811233130_3I4EA | BE000E | 2024-09-06T12:11:36.018Z | 2024-09-06T12:11:36.018Z |
4976493 | 4976493 | 20240811233042_Tmmnl | BE000E | 2024-09-06T12:11:34.110Z | 2024-09-06T12:11:34.110Z |
4975839 | 4975839 | 20240811232229_eAsrI | BE000E | 2024-09-06T12:10:50.711Z | 2024-09-06T12:10:50.711Z |
4975660 | 4975660 | 20240811232054_V7HEn | BE000E | 2024-09-06T12:10:47.005Z | 2024-09-06T12:10:47.005Z |
4974209 | 4974209 | 20240811230438_1ZiSn | BE000E | 2024-09-05T12:11:20.668Z | 2024-09-06T12:10:23.620Z |
4973768 | 4973768 | 20240811225941_qjm3g | BE000E | 2024-09-05T12:11:08.648Z | 2024-09-06T12:10:04.804Z |
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);