participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,575 rows where station_code = "BE0004" 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 |
---|---|---|---|---|---|
4394161 | 4394161 | 20240530003536_yhwBY | BE0004 | 2024-05-31T12:09:37.316Z | 2024-06-07T12:16:05.577Z |
4394136 | 4394136 | 20240530002055_eof41 | BE0004 | 2024-05-31T12:09:35.684Z | 2024-06-07T12:16:05.425Z |
4393687 | 4393687 | 20240529212431_zp8jo | BE0004 | 2024-05-31T12:08:42.533Z | 2024-06-07T12:16:00.473Z |
4387688 | 4387688 | 20240528012442_SX2Zw | BE0004 | 2024-05-29T12:08:21.514Z | 2024-06-05T12:18:11.367Z |
4387548 | 4387548 | 20240528003611_U3hOl | BE0004 | 2024-05-29T12:08:09.945Z | 2024-06-05T12:18:09.221Z |
4387423 | 4387423 | 20240528001215_xnOFd | BE0004 | 2024-05-29T12:07:51.016Z | 2024-06-05T12:18:07.833Z |
4387417 | 4387417 | 20240528001108_f17zi | BE0004 | 2024-05-29T12:07:50.361Z | 2024-06-05T12:18:07.711Z |
4387228 | 4387228 | 20240527231713_V9FrC | BE0004 | 2024-05-29T12:07:36.071Z | 2024-06-05T12:18:04.196Z |
4387098 | 4387098 | 20240527223323_6Pbb7 | BE0004 | 2024-05-29T12:07:17.182Z | 2024-06-05T12:18:01.974Z |
4386966 | 4386966 | 20240527212900_1h87F | BE0004 | 2024-05-29T12:07:01.421Z | 2024-06-05T12:17:59.444Z |
4382217 | 4382217 | 20240525214249_bsxZX | BE0004 | 2024-05-28T12:09:30.957Z | 2024-06-03T12:16:58.299Z |
4382205 | 4382205 | 20240525211642_tVRI2 | BE0004 | 2024-05-28T12:09:30.025Z | 2024-06-03T12:16:58.195Z |
4372705 | 4372705 | 20240522225625_i4xYK | BE0004 | 2024-05-27T12:04:53.519Z | 2024-05-30T12:13:43.015Z |
4372675 | 4372675 | 20240522215632_xlBQp | BE0004 | 2024-05-27T12:04:49.487Z | 2024-05-30T12:13:41.810Z |
4372604 | 4372604 | 20240522211525_GIOVd | BE0004 | 2024-05-27T12:04:44.859Z | 2024-05-30T12:13:38.412Z |
4356190 | 4356190 | 20240512022232_9lLmV | BE0004 | 2024-05-22T12:06:50.435Z | 2024-05-22T12:06:50.435Z |
4355358 | 4355358 | 20240511235257_NLhwQ | BE0004 | 2024-05-22T12:05:45.457Z | 2024-05-22T12:05:45.457Z |
4355332 | 4355332 | 20240511234722_d3oqN | BE0004 | 2024-05-22T12:05:42.087Z | 2024-05-22T12:05:42.087Z |
4355234 | 4355234 | 20240511232452_02Udf | BE0004 | 2024-05-22T12:05:29.350Z | 2024-05-22T12:05:29.350Z |
4355118 | 4355118 | 20240511231245_jt6KD | BE0004 | 2024-05-22T12:05:22.870Z | 2024-05-22T12:05:22.870Z |
4351404 | 4351404 | 20240511023533_ceil5 | BE0004 | 2024-05-21T12:05:48.466Z | 2024-05-22T12:12:06.172Z |
4351388 | 4351388 | 20240511023131_Ya98f | BE0004 | 2024-05-21T12:05:46.997Z | 2024-05-22T12:12:05.765Z |
4351362 | 4351362 | 20240511022813_Cw4FF | BE0004 | 2024-05-21T12:05:46.396Z | 2024-05-22T12:12:05.622Z |
4351358 | 4351358 | 20240511022755_iT4qR | BE0004 | 2024-05-21T12:05:45.999Z | 2024-05-22T12:12:05.542Z |
4351350 | 4351350 | 20240511022656_inSU4 | BE0004 | 2024-05-21T12:05:45.730Z | 2024-05-22T12:12:05.481Z |
4351101 | 4351101 | 20240511013825_soQsE | BE0004 | 2024-05-21T12:05:24.266Z | 2024-05-22T12:12:00.128Z |
4350484 | 4350484 | 20240510235341_YN6tA | BE0004 | 2024-05-21T12:04:33.361Z | 2024-05-22T12:11:32.613Z |
4349959 | 4349959 | 20240510211735_YF6Q7 | BE0004 | 2024-05-21T12:03:44.126Z | 2024-05-22T12:11:14.204Z |
4341998 | 4341998 | 20240509235822_Slc7b | BE0004 | 2024-05-19T12:10:17.978Z | 2024-05-21T12:10:33.132Z |
4341938 | 4341938 | 20240509235010_P7Llk | BE0004 | 2024-05-19T12:10:14.185Z | 2024-05-21T12:10:28.992Z |
4341887 | 4341887 | 20240509234101_dqKz6 | BE0004 | 2024-05-19T12:10:09.913Z | 2024-05-21T12:10:27.349Z |
4341773 | 4341773 | 20240509232550_hTDkt | BE0004 | 2024-05-19T12:10:01.414Z | 2024-05-21T12:10:22.433Z |
4341366 | 4341366 | 20240509221116_7SQRw | BE0004 | 2024-05-19T12:09:04.839Z | 2024-05-21T12:10:07.210Z |
4341053 | 4341053 | 20240509211954_Dt2LE | BE0004 | 2024-05-19T12:08:26.707Z | 2024-05-21T12:09:53.820Z |
4333467 | 4333467 | 20240508224642_KrXtD | BE0004 | 2024-05-18T12:09:54.966Z | 2024-05-19T12:14:48.584Z |
4333354 | 4333354 | 20240508220159_2WQLQ | BE0004 | 2024-05-18T12:09:32.243Z | 2024-05-19T12:14:44.681Z |
4333249 | 4333249 | 20240508213944_Xv9Jq | BE0004 | 2024-05-18T12:09:22.907Z | 2024-05-19T12:14:42.426Z |
4333176 | 4333176 | 20240508211903_4URqL | BE0004 | 2024-05-18T12:09:17.101Z | 2024-05-19T12:14:39.759Z |
4333013 | 4333013 | 20240508202647_MsXHt | BE0004 | 2024-05-18T12:08:47.152Z | 2024-05-19T12:14:35.440Z |
4290705 | 4290705 | 20240504023730_SVdhO | BE0004 | 2024-05-07T12:13:19.853Z | 2024-05-12T12:20:52.894Z |
4290596 | 4290596 | 20240504021930_txEXj | BE0004 | 2024-05-07T12:13:13.564Z | 2024-05-12T12:20:48.953Z |
4290560 | 4290560 | 20240504021537_fHFJN | BE0004 | 2024-05-07T12:13:11.039Z | 2024-05-12T12:20:47.509Z |
4290500 | 4290500 | 20240504020827_juqtq | BE0004 | 2024-05-07T12:13:05.185Z | 2024-05-12T12:20:45.162Z |
4290400 | 4290400 | 20240504015203_9Z8Ri | BE0004 | 2024-05-07T12:12:55.945Z | 2024-05-12T12:20:39.922Z |
4285321 | 4285321 | 20240504014349_aDttx | BE0004 | 2024-05-06T12:14:19.540Z | 2024-05-12T12:20:37.630Z |
4285293 | 4285293 | 20240504013756_PV6IG | BE0004 | 2024-05-06T12:14:17.537Z | 2024-05-12T12:20:35.976Z |
4285248 | 4285248 | 20240504013059_ghs9J | BE0004 | 2024-05-06T12:14:15.921Z | 2024-05-12T12:20:33.336Z |
4285204 | 4285204 | 20240504011641_3hBOP | BE0004 | 2024-05-06T12:14:12.792Z | 2024-05-12T12:20:30.527Z |
4285036 | 4285036 | 20240504003947_60d3r | BE0004 | 2024-05-06T12:13:55.240Z | 2024-05-12T12:20:24.662Z |
4284825 | 4284825 | 20240503234529_BiO3A | BE0004 | 2024-05-06T12:13:32.741Z | 2024-05-12T12:20:10.823Z |
4284371 | 4284371 | 20240503214611_43NB2 | BE0004 | 2024-05-06T12:12:35.127Z | 2024-05-12T12:19:37.766Z |
4266480 | 4266480 | 20240501235203_6aaL1 | BE0004 | 2024-05-03T12:07:54.290Z | 2024-05-10T12:23:40.593Z |
4256839 | 4256839 | 20240429020722_ud3xO | BE0004 | 2024-05-01T12:12:53.886Z | 2024-05-07T12:18:53.101Z |
4256409 | 4256409 | 20240429010329_7friC | BE0004 | 2024-05-01T12:12:30.778Z | 2024-05-07T12:18:48.881Z |
4252503 | 4252503 | 20240429004503_XtIzK | BE0004 | 2024-04-30T12:12:24.527Z | 2024-05-07T12:18:45.831Z |
4252434 | 4252434 | 20240429003342_ESrfK | BE0004 | 2024-04-30T12:12:17.703Z | 2024-05-07T12:18:44.829Z |
4252392 | 4252392 | 20240429002544_kX6CT | BE0004 | 2024-04-30T12:12:16.024Z | 2024-05-07T12:18:43.910Z |
4252378 | 4252378 | 20240429002333_tLpYI | BE0004 | 2024-04-30T12:12:15.268Z | 2024-05-07T12:18:43.801Z |
4251057 | 4251057 | 20240428205050_XrJNp | BE0004 | 2024-04-30T12:07:50.463Z | 2024-05-07T12:18:28.508Z |
4035941 | 4035941 | 20240306045010_jCgLm | BE0004 | 2024-03-07T14:08:43.937Z | 2024-03-14T12:25:29.563Z |
4035830 | 4035830 | 20240306043133_7J3D2 | BE0004 | 2024-03-07T14:08:33.299Z | 2024-03-14T12:25:27.198Z |
4035810 | 4035810 | 20240306042653_RGx1m | BE0004 | 2024-03-07T14:08:32.088Z | 2024-03-14T12:25:26.524Z |
4035767 | 4035767 | 20240306042012_QhgDJ | BE0004 | 2024-03-07T14:08:29.994Z | 2024-03-14T12:25:26.267Z |
4035743 | 4035743 | 20240306041709_BHKph | BE0004 | 2024-03-07T14:08:27.492Z | 2024-03-14T12:25:25.776Z |
4035572 | 4035572 | 20240306035624_XkBib | BE0004 | 2024-03-07T14:08:16.874Z | 2024-03-14T12:25:23.189Z |
4035501 | 4035501 | 20240306034201_c93af | BE0004 | 2024-03-07T14:08:11.923Z | 2024-03-14T12:25:22.123Z |
4035494 | 4035494 | 20240306033958_tiZQt | BE0004 | 2024-03-07T14:08:10.579Z | 2024-03-14T12:25:21.942Z |
4035492 | 4035492 | 20240306033906_oWfWP | BE0004 | 2024-03-07T14:08:09.127Z | 2024-03-14T12:25:21.540Z |
4035422 | 4035422 | 20240306031856_uIFLS | BE0004 | 2024-03-07T14:07:53.128Z | 2024-03-14T12:25:19.490Z |
4035338 | 4035338 | 20240306030952_482F3 | BE0004 | 2024-03-07T14:07:49.014Z | 2024-03-14T12:25:18.286Z |
4035288 | 4035288 | 20240306025600_uNUQH | BE0004 | 2024-03-07T14:07:44.179Z | 2024-03-14T12:25:15.989Z |
4035185 | 4035185 | 20240306023955_YhT1f | BE0004 | 2024-03-07T14:07:36.735Z | 2024-03-14T12:25:14.249Z |
4035110 | 4035110 | 20240306022523_i8Swa | BE0004 | 2024-03-07T14:07:30.777Z | 2024-03-14T12:25:12.705Z |
4034837 | 4034837 | 20240306012801_nvWmm | BE0004 | 2024-03-07T14:06:59.442Z | 2024-03-14T12:25:09.961Z |
4007149 | 4007149 | 20240228033509_03eWA | BE0004 | 2024-02-29T14:04:55.610Z | 2024-03-07T14:19:06.923Z |
4007133 | 4007133 | 20240228030259_ohUZd | BE0004 | 2024-02-29T14:04:51.066Z | 2024-03-07T14:19:06.530Z |
4007053 | 4007053 | 20240228012706_yadRm | BE0004 | 2024-02-29T14:04:37.924Z | 2024-03-07T14:19:04.391Z |
3959084 | 3959084 | 20240213034915_ydH2x | BE0004 | 2024-02-14T14:08:50.910Z | 2024-02-21T14:20:40.616Z |
3958980 | 3958980 | 20240213032321_JadVp | BE0004 | 2024-02-14T14:08:41.889Z | 2024-02-21T14:20:39.144Z |
3958414 | 3958414 | 20240213005841_7pQgh | BE0004 | 2024-02-14T14:07:33.685Z | 2024-02-21T14:20:33.466Z |
3958091 | 3958091 | 20240212230133_fhb7d | BE0004 | 2024-02-14T14:06:49.065Z | 2024-02-21T14:20:29.213Z |
3958072 | 3958072 | 20240212225424_ekXuS | BE0004 | 2024-02-14T14:06:45.549Z | 2024-02-21T14:20:29.013Z |
3958024 | 3958024 | 20240212223534_aXKT3 | BE0004 | 2024-02-14T14:06:41.547Z | 2024-02-21T14:20:28.755Z |
3958006 | 3958006 | 20240212223207_GRou6 | BE0004 | 2024-02-14T14:06:40.068Z | 2024-02-21T14:20:28.555Z |
3957888 | 3957888 | 20240212214249_NZ23Z | BE0004 | 2024-02-14T14:06:29.119Z | 2024-02-21T14:20:27.652Z |
3957646 | 3957646 | 20240212203556_1jquU | BE0004 | 2024-02-14T14:06:02.702Z | 2024-02-21T14:20:25.256Z |
3956968 | 3956968 | 20240212183414_fYUgh | BE0004 | 2024-02-14T14:04:29.385Z | 2024-02-21T14:20:19.432Z |
3943923 | 3943923 | 20240210022939_OWpbk | BE0004 | 2024-02-11T14:06:54.952Z | 2024-02-18T14:22:13.798Z |
3943816 | 3943816 | 20240210014415_uMtO2 | BE0004 | 2024-02-11T14:06:37.068Z | 2024-02-18T14:22:12.358Z |
3908593 | 3908593 | 20240201202331_MV2yU | BE0004 | 2024-02-03T14:02:37.325Z | 2024-02-10T14:24:37.062Z |
3896763 | 3896763 | 20240128175307_LyS33 | BE0004 | 2024-01-30T14:11:05.322Z | 2024-02-05T14:19:43.214Z |
3896756 | 3896756 | 20240128175050_3k9AW | BE0004 | 2024-01-30T14:11:04.273Z | 2024-02-05T14:19:42.682Z |
3894616 | 3894616 | 20240129022449_vldpx | BE0004 | 2024-01-30T14:03:06.883Z | 2024-02-06T14:20:45.563Z |
3893984 | 3893984 | 20240128193105_6Nih4 | BE0004 | 2024-01-30T14:00:45.937Z | 2024-02-06T14:20:35.732Z |
3893684 | 3893684 | 20240127174955_VGDVJ | BE0004 | 2024-01-29T14:10:37.080Z | 2024-02-04T14:19:07.590Z |
3892284 | 3892284 | 20240128053124_JnfNE | BE0004 | 2024-01-29T14:03:57.637Z | 2024-02-05T14:19:26.775Z |
3892244 | 3892244 | 20240128051806_kG3Nj | BE0004 | 2024-01-29T14:03:53.029Z | 2024-02-05T14:19:25.905Z |
3892048 | 3892048 | 20240128042151_pIIR2 | BE0004 | 2024-01-29T14:03:23.905Z | 2024-02-05T14:19:22.231Z |
3891619 | 3891619 | 20240128015436_SUYsA | BE0004 | 2024-01-29T14:02:07.614Z | 2024-02-05T14:19:11.786Z |
3889620 | 3889620 | 20240127045106_ChYoR | BE0004 | 2024-01-28T14:04:02.740Z | 2024-02-04T14:18:48.182Z |
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);