participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
13,801 rows where station_code = "BE0001" 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 |
---|---|---|---|---|---|
5098243 | 5098243 | 20240913012251_fraF2 | BE0001 | 2024-09-16T12:17:21.799Z | 2024-09-16T12:17:21.799Z |
5098151 | 5098151 | 20240913012028_sv4iZ | BE0001 | 2024-09-16T12:17:20.934Z | 2024-09-16T12:17:20.934Z |
5098133 | 5098133 | 20240913011921_sYfXS | BE0001 | 2024-09-16T12:17:20.632Z | 2024-09-16T12:17:20.632Z |
5098099 | 5098099 | 20240913011703_WFPy1 | BE0001 | 2024-09-16T12:17:19.559Z | 2024-09-16T12:17:19.559Z |
5098021 | 5098021 | 20240913011318_dH2aV | BE0001 | 2024-09-16T12:17:18.494Z | 2024-09-16T12:17:18.494Z |
5097991 | 5097991 | 20240913011141_IiiHQ | BE0001 | 2024-09-16T12:17:17.842Z | 2024-09-16T12:17:17.842Z |
5097910 | 5097910 | 20240913010935_NqU7f | BE0001 | 2024-09-16T12:17:16.892Z | 2024-09-16T12:17:16.892Z |
5094248 | 5094248 | 20240912035432_fCysh | BE0001 | 2024-09-16T12:14:40.003Z | 2024-09-16T12:17:31.294Z |
5093816 | 5093816 | 20240912033821_X59Hf | BE0001 | 2024-09-16T12:14:26.140Z | 2024-09-16T12:17:31.238Z |
5093663 | 5093663 | 20240912033206_fkpY5 | BE0001 | 2024-09-16T12:14:23.720Z | 2024-09-16T12:17:31.216Z |
5093478 | 5093478 | 20240912032339_d54gA | BE0001 | 2024-09-16T12:14:18.205Z | 2024-09-16T12:17:31.188Z |
5092097 | 5092097 | 20240912023645_5yBeI | BE0001 | 2024-09-16T12:13:40.789Z | 2024-09-16T12:17:30.989Z |
5092043 | 5092043 | 20240912023533_6yc8k | BE0001 | 2024-09-16T12:13:38.504Z | 2024-09-16T12:17:30.982Z |
5091520 | 5091520 | 20240912021217_cBdzN | BE0001 | 2024-09-16T12:13:09.258Z | 2024-09-16T12:17:30.904Z |
5090372 | 5090372 | 20240912012304_Sobsh | BE0001 | 2024-09-16T12:12:16.555Z | 2024-09-16T12:17:30.742Z |
5088902 | 5088902 | 20240913003251_zsF2F | BE0001 | 2024-09-16T12:08:35.605Z | 2024-09-16T12:17:05.915Z |
5088878 | 5088878 | 20240913003221_D2ghT | BE0001 | 2024-09-16T12:08:34.747Z | 2024-09-16T12:17:05.910Z |
5088710 | 5088710 | 20240913002207_HkE5a | BE0001 | 2024-09-16T12:08:22.079Z | 2024-09-16T12:17:05.857Z |
5088708 | 5088708 | 20240913002137_kHoer | BE0001 | 2024-09-16T12:08:21.170Z | 2024-09-16T12:17:05.855Z |
5088623 | 5088623 | 20240913001959_ClBal | BE0001 | 2024-09-16T12:08:17.379Z | 2024-09-16T12:17:05.836Z |
5088275 | 5088275 | 20240913000437_HGjte | BE0001 | 2024-09-16T12:07:51.991Z | 2024-09-16T12:17:05.741Z |
5088013 | 5088013 | 20240912235341_Ek5pz | BE0001 | 2024-09-16T12:07:40.865Z | 2024-09-16T12:17:05.668Z |
5087151 | 5087151 | 20240912231144_5ZLf7 | BE0001 | 2024-09-16T12:06:42.270Z | 2024-09-16T12:17:05.391Z |
5086963 | 5086963 | 20240912225837_gM4rW | BE0001 | 2024-09-16T12:06:17.818Z | 2024-09-16T12:17:05.330Z |
5086935 | 5086935 | 20240912225741_XUbDq | BE0001 | 2024-09-16T12:06:14.643Z | 2024-09-16T12:17:05.322Z |
5086781 | 5086781 | 20240912224851_MhpiS | BE0001 | 2024-09-16T12:06:03.251Z | 2024-09-16T12:17:05.264Z |
5086754 | 5086754 | 20240912224656_5yrKI | BE0001 | 2024-09-16T12:06:01.108Z | 2024-09-16T12:17:05.248Z |
5086513 | 5086513 | 20240912223939_1KfGr | BE0001 | 2024-09-16T12:05:50.777Z | 2024-09-16T12:17:05.198Z |
5086416 | 5086416 | 20240912223257_6OeNb | BE0001 | 2024-09-16T12:05:43.956Z | 2024-09-16T12:17:05.141Z |
5086180 | 5086180 | 20240912221615_Tf2zl | BE0001 | 2024-09-16T12:05:19.135Z | 2024-09-16T12:17:05.045Z |
5085774 | 5085774 | 20240912215055_y3Hdl | BE0001 | 2024-09-16T12:04:54.766Z | 2024-09-16T12:17:04.862Z |
5075277 | 5075277 | 20240911233804_kSKWx | BE0001 | 2024-09-15T12:09:34.337Z | 2024-09-16T12:17:29.531Z |
5075144 | 5075144 | 20240911233105_Q3Fil | BE0001 | 2024-09-15T12:09:26.449Z | 2024-09-16T12:17:29.512Z |
5075011 | 5075011 | 20240911232211_gdjWj | BE0001 | 2024-09-15T12:09:18.605Z | 2024-09-16T12:17:29.490Z |
5075001 | 5075001 | 20240911232154_X5g4r | BE0001 | 2024-09-15T12:09:17.802Z | 2024-09-16T12:17:29.488Z |
5074175 | 5074175 | 20240911222155_oLjXc | BE0001 | 2024-09-15T12:08:06.742Z | 2024-09-16T12:17:29.341Z |
5074001 | 5074001 | 20240911220608_f8WR3 | BE0001 | 2024-09-15T12:07:50.660Z | 2024-09-16T12:17:29.315Z |
5072614 | 5072614 | 20240911203004_aMxGE | BE0001 | 2024-09-15T12:05:48.725Z | 2024-09-16T12:17:29.120Z |
5072454 | 5072454 | 20240911201031_lczei | BE0001 | 2024-09-15T12:05:24.782Z | 2024-09-16T12:17:29.089Z |
5072165 | 5072165 | 20240911194251_BJl85 | BE0001 | 2024-09-15T12:04:47.191Z | 2024-09-16T12:17:29.036Z |
5054648 | 5054648 | 20240908032908_VyjHd | BE0001 | 2024-09-13T12:16:50.917Z | 2024-09-16T12:21:16.402Z |
5032655 | 5032655 | 20240907012625_g3jH2 | BE0001 | 2024-09-12T12:07:48.865Z | 2024-09-15T12:21:27.289Z |
4999769 | 4999769 | 20240902005831_jQzZv | BE0001 | 2024-09-08T12:14:44.735Z | 2024-09-10T12:19:22.459Z |
4999623 | 4999623 | 20240902004135_QKWBE | BE0001 | 2024-09-08T12:14:38.035Z | 2024-09-10T12:19:21.329Z |
4999588 | 4999588 | 20240902003759_rkPPC | BE0001 | 2024-09-08T12:14:36.263Z | 2024-09-10T12:19:21.021Z |
4999543 | 4999543 | 20240902003340_VbxDl | BE0001 | 2024-09-08T12:14:30.339Z | 2024-09-10T12:19:20.454Z |
4999450 | 4999450 | 20240902002253_WLKXR | BE0001 | 2024-09-08T12:14:20.945Z | 2024-09-10T12:19:19.388Z |
4999437 | 4999437 | 20240902002120_kQ3PX | BE0001 | 2024-09-08T12:14:20.375Z | 2024-09-10T12:19:19.199Z |
4998452 | 4998452 | 20240903030550_g0Kxv | BE0001 | 2024-09-08T12:07:40.388Z | 2024-09-11T12:21:12.903Z |
4998431 | 4998431 | 20240903030152_nv0mT | BE0001 | 2024-09-08T12:07:37.860Z | 2024-09-11T12:21:12.713Z |
4998403 | 4998403 | 20240903025656_V7JUN | BE0001 | 2024-09-08T12:07:35.937Z | 2024-09-11T12:21:12.598Z |
4996518 | 4996518 | 20240902195216_5zxq1 | BE0001 | 2024-09-08T12:04:53.956Z | 2024-09-11T12:20:55.560Z |
4991747 | 4991747 | 20240901030913_vEBIy | BE0001 | 2024-09-07T12:12:27.924Z | 2024-09-09T12:27:18.550Z |
4991709 | 4991709 | 20240901030402_zu9vF | BE0001 | 2024-09-07T12:12:25.537Z | 2024-09-09T12:27:16.375Z |
4991685 | 4991685 | 20240901025829_RfN7i | BE0001 | 2024-09-07T12:12:23.810Z | 2024-09-09T12:27:15.685Z |
4991592 | 4991592 | 20240901024919_hTxHl | BE0001 | 2024-09-07T12:12:13.939Z | 2024-09-09T12:27:13.245Z |
4991438 | 4991438 | 20240901023248_mLi2I | BE0001 | 2024-09-07T12:12:02.864Z | 2024-09-09T12:27:08.031Z |
4991412 | 4991412 | 20240901023101_Fsyjr | BE0001 | 2024-09-07T12:12:01.482Z | 2024-09-09T12:27:07.474Z |
4991252 | 4991252 | 20240901021315_U208Z | BE0001 | 2024-09-07T12:11:48.239Z | 2024-09-09T12:27:03.565Z |
4991227 | 4991227 | 20240901020923_e2wLn | BE0001 | 2024-09-07T12:11:45.227Z | 2024-09-09T12:27:02.990Z |
4991154 | 4991154 | 20240901020332_C7QQC | BE0001 | 2024-09-07T12:11:37.424Z | 2024-09-09T12:27:01.348Z |
4990392 | 4990392 | 20240901001108_K3Ida | BE0001 | 2024-09-07T12:10:31.500Z | 2024-09-09T12:26:18.592Z |
4990363 | 4990363 | 20240901000722_0Grp9 | BE0001 | 2024-09-07T12:10:27.013Z | 2024-09-09T12:26:17.744Z |
4989594 | 4989594 | 20240901235551_hShrx | BE0001 | 2024-09-07T12:09:10.310Z | 2024-09-10T12:19:18.108Z |
4989528 | 4989528 | 20240901234709_G7zMe | BE0001 | 2024-09-07T12:09:05.839Z | 2024-09-10T12:19:17.852Z |
4989485 | 4989485 | 20240901234200_ZcJd5 | BE0001 | 2024-09-07T12:09:02.559Z | 2024-09-10T12:19:17.781Z |
4989482 | 4989482 | 20240901234158_Mc3Kf | BE0001 | 2024-09-07T12:09:02.332Z | 2024-09-10T12:19:17.770Z |
4989424 | 4989424 | 20240901233318_2n1Vy | BE0001 | 2024-09-07T12:08:56.687Z | 2024-09-10T12:19:17.630Z |
4989319 | 4989319 | 20240901231143_7aav2 | BE0001 | 2024-09-07T12:08:47.730Z | 2024-09-10T12:19:17.355Z |
4989286 | 4989286 | 20240901230641_B9YXs | BE0001 | 2024-09-07T12:08:45.479Z | 2024-09-10T12:19:17.279Z |
4989275 | 4989275 | 20240901230609_ykyLm | BE0001 | 2024-09-07T12:08:44.076Z | 2024-09-10T12:19:17.274Z |
4988828 | 4988828 | 20240901213904_XNrLh | BE0001 | 2024-09-07T12:07:59.799Z | 2024-09-10T12:19:15.611Z |
4988796 | 4988796 | 20240901213714_iwhuk | BE0001 | 2024-09-07T12:07:57.905Z | 2024-09-10T12:19:15.530Z |
4988525 | 4988525 | 20240901210037_1t8w7 | BE0001 | 2024-09-07T12:07:35.574Z | 2024-09-10T12:19:14.534Z |
4988245 | 4988245 | 20240901201659_9g5X0 | BE0001 | 2024-09-07T12:07:07.163Z | 2024-09-10T12:19:13.268Z |
4988174 | 4988174 | 20240901200847_GvRTz | BE0001 | 2024-09-07T12:07:00.515Z | 2024-09-10T12:19:12.986Z |
4982212 | 4982212 | 20240812003133_36K8m | BE0001 | 2024-09-06T12:14:47.252Z | 2024-09-06T12:14:47.252Z |
4982181 | 4982181 | 20240812003112_4EeIb | BE0001 | 2024-09-06T12:14:46.396Z | 2024-09-06T12:14:46.396Z |
4982090 | 4982090 | 20240812003003_vlUzU | BE0001 | 2024-09-06T12:14:42.664Z | 2024-09-06T12:14:42.664Z |
4981943 | 4981943 | 20240812002828_INPv5 | BE0001 | 2024-09-06T12:14:40.462Z | 2024-09-06T12:14:40.462Z |
4981688 | 4981688 | 20240812002604_KU63k | BE0001 | 2024-09-06T12:14:35.757Z | 2024-09-06T12:14:35.757Z |
4981495 | 4981495 | 20240812002240_QoG8Q | BE0001 | 2024-09-06T12:14:32.451Z | 2024-09-06T12:14:32.451Z |
4980927 | 4980927 | 20240812001719_Zm0il | BE0001 | 2024-09-06T12:14:24.427Z | 2024-09-06T12:14:24.427Z |
4980857 | 4980857 | 20240812001637_89xGe | BE0001 | 2024-09-06T12:14:21.320Z | 2024-09-06T12:14:21.320Z |
4980127 | 4980127 | 20240812000901_nDORz | BE0001 | 2024-09-06T12:13:48.475Z | 2024-09-06T12:13:48.475Z |
4979529 | 4979529 | 20240812000224_fnPcU | BE0001 | 2024-09-06T12:13:17.933Z | 2024-09-06T12:13:17.933Z |
4977892 | 4977892 | 20240811234559_fPnaX | BE0001 | 2024-09-06T12:12:26.094Z | 2024-09-06T12:12:26.094Z |
4977672 | 4977672 | 20240811234320_F2a11 | BE0001 | 2024-09-06T12:12:21.783Z | 2024-09-06T12:12:21.783Z |
4977517 | 4977517 | 20240811234029_w29Wx | BE0001 | 2024-09-06T12:12:18.676Z | 2024-09-06T12:12:18.676Z |
4977371 | 4977371 | 20240811233904_V4L5Z | BE0001 | 2024-09-06T12:12:13.654Z | 2024-09-06T12:12:13.654Z |
4976948 | 4976948 | 20240811233512_kVj97 | BE0001 | 2024-09-06T12:12:00.055Z | 2024-09-06T12:12:00.055Z |
4976850 | 4976850 | 20240811233352_hn83a | BE0001 | 2024-09-06T12:11:53.358Z | 2024-09-06T12:11:53.358Z |
4976464 | 4976464 | 20240811233018_TrKLW | BE0001 | 2024-09-06T12:11:32.898Z | 2024-09-06T12:11:32.898Z |
4976389 | 4976389 | 20240811232952_DTbch | BE0001 | 2024-09-06T12:11:31.097Z | 2024-09-06T12:11:31.097Z |
4975988 | 4975988 | 20240811232418_GGWFr | BE0001 | 2024-09-06T12:11:00.839Z | 2024-09-06T12:11:00.839Z |
4975482 | 4975482 | 20240811231902_Y5V6I | BE0001 | 2024-09-05T12:11:51.344Z | 2024-09-06T12:10:42.033Z |
4975203 | 4975203 | 20240811231609_lQKGs | BE0001 | 2024-09-05T12:11:41.647Z | 2024-09-06T12:10:38.520Z |
4975153 | 4975153 | 20240811231532_g3Mkr | BE0001 | 2024-09-05T12:11:41.167Z | 2024-09-06T12:10:38.200Z |
4974990 | 4974990 | 20240811231329_tC3VY | BE0001 | 2024-09-05T12:11:37.956Z | 2024-09-06T12:10:35.473Z |
4974875 | 4974875 | 20240811231227_Ay7b0 | BE0001 | 2024-09-05T12:11:34.341Z | 2024-09-06T12:10:34.107Z |
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);