participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,948 rows where station_code = "BE0007" 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 |
---|---|---|---|---|---|
5563514 | 5563514 | 20241120013744_ltWLr | BE0007 | 2024-11-21T14:16:14.501Z | 2024-11-22T14:21:17.171Z |
5558063 | 5558063 | 20241120053339_8T63O | BE0007 | 2024-11-21T14:02:25.620Z | 2024-11-22T14:19:21.172Z |
5485298 | 5485298 | 20241105044235_DWbx3 | BE0007 | 2024-11-06T14:18:04.384Z | 2024-11-13T14:27:41.578Z |
5485296 | 5485296 | 20241105044121_qNhQV | BE0007 | 2024-11-06T14:18:04.319Z | 2024-11-13T14:27:41.577Z |
5485246 | 5485246 | 20241105043004_TXd9S | BE0007 | 2024-11-06T14:17:58.886Z | 2024-11-13T14:27:41.414Z |
5485100 | 5485100 | 20241105040455_qopNO | BE0007 | 2024-11-06T14:17:45.978Z | 2024-11-13T14:27:40.746Z |
5485093 | 5485093 | 20241105040335_hu94m | BE0007 | 2024-11-06T14:17:44.757Z | 2024-11-13T14:27:40.706Z |
5484864 | 5484864 | 20241105033506_C3BtF | BE0007 | 2024-11-06T14:17:24.009Z | 2024-11-13T14:27:39.998Z |
5484690 | 5484690 | 20241105032018_ICuw4 | BE0007 | 2024-11-06T14:17:10.189Z | 2024-11-13T14:27:39.347Z |
5484661 | 5484661 | 20241105031817_Q2f0O | BE0007 | 2024-11-06T14:17:08.521Z | 2024-11-13T14:27:39.035Z |
5484186 | 5484186 | 20241105021847_xmVYK | BE0007 | 2024-11-06T14:16:29.187Z | 2024-11-13T14:27:37.483Z |
5484106 | 5484106 | 20241105021012_nmPFB | BE0007 | 2024-11-06T14:16:16.838Z | 2024-11-13T14:27:37.295Z |
5483880 | 5483880 | 20241105014024_lpnKX | BE0007 | 2024-11-06T14:15:49.573Z | 2024-11-13T14:27:36.959Z |
5482815 | 5482815 | 20241104231714_rWTIK | BE0007 | 2024-11-06T14:14:05.981Z | 2024-11-13T14:27:35.208Z |
5482787 | 5482787 | 20241104231447_RRtPf | BE0007 | 2024-11-06T14:14:00.148Z | 2024-11-13T14:27:35.139Z |
5482704 | 5482704 | 20241104230503_3cUaP | BE0007 | 2024-11-06T14:13:40.740Z | 2024-11-13T14:27:35.048Z |
5482148 | 5482148 | 20241104211443_dRKin | BE0007 | 2024-11-06T14:12:28.399Z | 2024-11-13T14:27:34.006Z |
5482067 | 5482067 | 20241104210003_lyxNY | BE0007 | 2024-11-06T14:12:20.152Z | 2024-11-13T14:27:33.830Z |
5481912 | 5481912 | 20241104201811_MWOiz | BE0007 | 2024-11-06T14:11:50.040Z | 2024-11-13T14:27:33.444Z |
5481798 | 5481798 | 20241104194526_T7Ie8 | BE0007 | 2024-11-06T14:11:36.123Z | 2024-11-13T14:27:32.841Z |
5481687 | 5481687 | 20241104191610_f5lF0 | BE0007 | 2024-11-06T14:11:22.265Z | 2024-11-13T14:27:31.644Z |
5481656 | 5481656 | 20241104190426_yUOfO | BE0007 | 2024-11-06T14:11:08.575Z | 2024-11-13T14:27:31.455Z |
5481557 | 5481557 | 20241104182544_lB5Ec | BE0007 | 2024-11-06T14:10:48.723Z | 2024-11-13T14:27:30.510Z |
5475009 | 5475009 | 20241103184913_bVxV8 | BE0007 | 2024-11-05T14:12:24.257Z | 2024-11-12T14:27:56.115Z |
5474621 | 5474621 | 20241103174946_qbPtg | BE0007 | 2024-11-05T14:11:24.003Z | 2024-11-12T14:27:53.484Z |
5468505 | 5468505 | 20241103004901_yZfDt | BE0007 | 2024-11-04T14:14:16.094Z | 2024-11-11T14:22:53.911Z |
5467985 | 5467985 | 20241102230912_jlja9 | BE0007 | 2024-11-04T14:13:04.773Z | 2024-11-11T14:22:50.666Z |
5450303 | 5450303 | 20241031183718_bSYjT | BE0007 | 2024-11-02T12:14:55.471Z | 2024-11-09T14:24:15.347Z |
5450193 | 5450193 | 20241031180953_KqbCl | BE0007 | 2024-11-02T12:14:43.544Z | 2024-11-09T14:24:14.598Z |
5430343 | 5430343 | 20241028221316_tWG3v | BE0007 | 2024-10-31T12:18:09.667Z | 2024-11-06T14:27:19.556Z |
5429820 | 5429820 | 20241028200925_SUGkd | BE0007 | 2024-10-31T12:17:06.381Z | 2024-11-06T14:27:17.673Z |
5418840 | 5418840 | 20241027220657_eBMf6 | BE0007 | 2024-10-30T12:16:21.492Z | 2024-11-05T14:27:11.415Z |
5418828 | 5418828 | 20241027220356_EtmpF | BE0007 | 2024-10-30T12:16:19.481Z | 2024-11-05T14:27:11.314Z |
5418600 | 5418600 | 20241027211805_Wgj5Q | BE0007 | 2024-10-30T12:15:52.780Z | 2024-11-05T14:27:10.772Z |
5418366 | 5418366 | 20241027203047_CLDH0 | BE0007 | 2024-10-30T12:15:36.042Z | 2024-11-05T14:27:09.877Z |
5418149 | 5418149 | 20241027200127_UeHX6 | BE0007 | 2024-10-30T12:15:00.103Z | 2024-11-05T14:27:09.277Z |
5417827 | 5417827 | 20241027192027_HnzWv | BE0007 | 2024-10-30T12:14:30.876Z | 2024-11-05T14:27:08.416Z |
5417274 | 5417274 | 20241027180842_KPhXn | BE0007 | 2024-10-30T12:13:27.577Z | 2024-11-05T14:27:06.887Z |
5402771 | 5402771 | 20241026202345_T8JxY | BE0007 | 2024-10-29T12:08:07.344Z | 2024-11-04T14:28:46.495Z |
5402569 | 5402569 | 20241026195733_J1tfb | BE0007 | 2024-10-29T12:07:43.561Z | 2024-11-04T14:28:45.334Z |
5402546 | 5402546 | 20241026195416_pJH22 | BE0007 | 2024-10-29T12:07:38.734Z | 2024-11-04T14:28:45.189Z |
5402262 | 5402262 | 20241026190725_7xFjU | BE0007 | 2024-10-29T12:06:46.229Z | 2024-11-04T14:28:43.392Z |
5399657 | 5399657 | 20241026044559_4dbJi | BE0007 | 2024-10-28T12:20:05.047Z | 2024-11-03T14:27:40.171Z |
5399177 | 5399177 | 20241026035839_vKCd4 | BE0007 | 2024-10-28T12:19:50.650Z | 2024-11-03T14:27:39.188Z |
5399087 | 5399087 | 20241026034935_lugbq | BE0007 | 2024-10-28T12:19:48.200Z | 2024-11-03T14:27:39.011Z |
5398884 | 5398884 | 20241026033500_GYsRJ | BE0007 | 2024-10-28T12:19:38.910Z | 2024-11-03T14:27:38.350Z |
5398849 | 5398849 | 20241026033327_zlFax | BE0007 | 2024-10-28T12:19:37.205Z | 2024-11-03T14:27:38.298Z |
5398442 | 5398442 | 20241026025829_RyWhf | BE0007 | 2024-10-28T12:19:17.540Z | 2024-11-03T14:27:36.379Z |
5397655 | 5397655 | 20241026014551_RkKyj | BE0007 | 2024-10-28T12:18:31.043Z | 2024-11-03T14:27:33.678Z |
5396966 | 5396966 | 20241026005121_RUtFH | BE0007 | 2024-10-28T12:18:01.106Z | 2024-11-03T14:27:31.581Z |
5396953 | 5396953 | 20241026004914_Ht5vh | BE0007 | 2024-10-28T12:18:00.563Z | 2024-11-03T14:27:31.528Z |
5396692 | 5396692 | 20241026002401_mckft | BE0007 | 2024-10-28T12:17:53.430Z | 2024-11-03T14:27:30.704Z |
5396582 | 5396582 | 20241026001410_JDMeU | BE0007 | 2024-10-28T12:17:50.293Z | 2024-11-03T14:27:30.394Z |
5396075 | 5396075 | 20241025233745_dTE3x | BE0007 | 2024-10-28T12:17:17.536Z | 2024-11-03T14:27:28.363Z |
5396036 | 5396036 | 20241025233409_3SAcJ | BE0007 | 2024-10-28T12:17:14.499Z | 2024-11-03T14:27:28.169Z |
5396001 | 5396001 | 20241025232914_igGrc | BE0007 | 2024-10-28T12:17:10.107Z | 2024-11-03T14:27:27.959Z |
5395879 | 5395879 | 20241025231741_TXlSS | BE0007 | 2024-10-28T12:17:02.928Z | 2024-11-03T14:27:27.518Z |
5395815 | 5395815 | 20241025231244_N9bt8 | BE0007 | 2024-10-28T12:16:54.861Z | 2024-11-03T14:27:26.711Z |
5395757 | 5395757 | 20241025230910_amt87 | BE0007 | 2024-10-28T12:16:46.916Z | 2024-11-03T14:27:26.657Z |
5395739 | 5395739 | 20241025230722_1HOp0 | BE0007 | 2024-10-28T12:16:44.761Z | 2024-11-03T14:27:26.586Z |
5395462 | 5395462 | 20241025224500_xLd5e | BE0007 | 2024-10-28T12:16:16.514Z | 2024-11-03T14:27:25.591Z |
5395378 | 5395378 | 20241025223735_SdS5F | BE0007 | 2024-10-28T12:16:11.505Z | 2024-11-03T14:27:25.402Z |
5395365 | 5395365 | 20241025223629_uVluJ | BE0007 | 2024-10-28T12:16:10.986Z | 2024-11-03T14:27:25.228Z |
5395256 | 5395256 | 20241025222833_HB81y | BE0007 | 2024-10-28T12:16:03.572Z | 2024-11-03T14:27:24.452Z |
5395053 | 5395053 | 20241025220317_JrdyT | BE0007 | 2024-10-28T12:15:54.652Z | 2024-11-03T14:27:23.820Z |
5394994 | 5394994 | 20241025215819_8ZLeP | BE0007 | 2024-10-28T12:15:52.241Z | 2024-11-03T14:27:23.630Z |
5394932 | 5394932 | 20241025214716_K40R5 | BE0007 | 2024-10-28T12:15:45.090Z | 2024-11-03T14:27:23.500Z |
5394855 | 5394855 | 20241025213513_lwh2d | BE0007 | 2024-10-28T12:15:32.839Z | 2024-11-03T14:27:22.913Z |
5394784 | 5394784 | 20241025212542_NGz2A | BE0007 | 2024-10-28T12:15:25.474Z | 2024-11-03T14:27:22.773Z |
5394703 | 5394703 | 20241025211254_I9YSy | BE0007 | 2024-10-28T12:15:15.813Z | 2024-11-03T14:27:22.359Z |
5394586 | 5394586 | 20241025205321_mKcMj | BE0007 | 2024-10-28T12:15:01.388Z | 2024-11-03T14:27:21.765Z |
5393612 | 5393612 | 20241025181905_Bbk4X | BE0007 | 2024-10-28T12:12:53.386Z | 2024-11-03T14:27:16.687Z |
5393473 | 5393473 | 20241025174929_3jerZ | BE0007 | 2024-10-28T12:12:37.824Z | 2024-11-03T14:27:15.547Z |
5388051 | 5388051 | 20241025035536_ONEIW | BE0007 | 2024-10-27T12:21:56.730Z | 2024-11-02T12:28:33.724Z |
5387802 | 5387802 | 20241025032424_rBoZ6 | BE0007 | 2024-10-27T12:21:40.887Z | 2024-11-02T12:28:33.275Z |
5387486 | 5387486 | 20241025024436_aVoOr | BE0007 | 2024-10-27T12:21:25.039Z | 2024-11-02T12:28:32.630Z |
5387189 | 5387189 | 20241025020836_kPTx2 | BE0007 | 2024-10-27T12:20:59.239Z | 2024-11-02T12:28:32.200Z |
5366582 | 5366582 | 20241023025241_EocZd | BE0007 | 2024-10-25T12:21:18.202Z | 2024-10-31T12:30:06.472Z |
5366555 | 5366555 | 20241023024634_rg4Hj | BE0007 | 2024-10-25T12:21:16.606Z | 2024-10-31T12:30:06.342Z |
5366534 | 5366534 | 20241023023432_Hejrq | BE0007 | 2024-10-25T12:21:14.861Z | 2024-10-31T12:30:06.111Z |
5366527 | 5366527 | 20241023023216_Qu2nW | BE0007 | 2024-10-25T12:21:14.177Z | 2024-10-31T12:30:05.970Z |
5365836 | 5365836 | 20241023235139_q49ru | BE0007 | 2024-10-25T12:18:08.536Z | 2024-11-01T12:26:56.447Z |
5363490 | 5363490 | 20241023211244_cM0sH | BE0007 | 2024-10-25T12:16:16.165Z | 2024-11-01T12:26:53.323Z |
5363254 | 5363254 | 20241023204014_Yr4Z8 | BE0007 | 2024-10-25T12:15:47.179Z | 2024-11-01T12:26:53.003Z |
5362276 | 5362276 | 20241023192152_vfIVI | BE0007 | 2024-10-25T12:14:09.353Z | 2024-11-01T12:26:51.172Z |
5361196 | 5361196 | 20241023175910_mtA17 | BE0007 | 2024-10-25T12:12:27.004Z | 2024-11-01T12:26:49.511Z |
5356078 | 5356078 | 20241023045400_gznSX | BE0007 | 2024-10-24T12:21:49.930Z | 2024-10-31T12:30:09.757Z |
5356028 | 5356028 | 20241023045120_fXf8D | BE0007 | 2024-10-24T12:21:48.001Z | 2024-10-31T12:30:09.654Z |
5355876 | 5355876 | 20241023043246_G9vxW | BE0007 | 2024-10-24T12:21:40.942Z | 2024-10-31T12:30:09.143Z |
5355373 | 5355373 | 20241023033613_w06TD | BE0007 | 2024-10-24T12:21:17.120Z | 2024-10-31T12:30:07.571Z |
5355353 | 5355353 | 20241023033453_4IiMo | BE0007 | 2024-10-24T12:21:16.233Z | 2024-10-31T12:30:07.561Z |
5355335 | 5355335 | 20241023033226_wHWWC | BE0007 | 2024-10-24T12:21:15.066Z | 2024-10-31T12:30:07.544Z |
5355008 | 5355008 | 20241023030419_HuPNO | BE0007 | 2024-10-24T12:20:59.848Z | 2024-10-31T12:30:06.994Z |
5354998 | 5354998 | 20241023030328_MRxFs | BE0007 | 2024-10-24T12:20:59.609Z | 2024-10-31T12:30:06.842Z |
5354529 | 5354529 | 20241023023021_uFsAq | BE0007 | 2024-10-24T12:20:38.484Z | 2024-10-31T12:30:05.892Z |
5354427 | 5354427 | 20241023022603_kXJ1Y | BE0007 | 2024-10-24T12:20:33.594Z | 2024-10-31T12:30:05.849Z |
5354296 | 5354296 | 20241023021854_ZUxpk | BE0007 | 2024-10-24T12:20:27.074Z | 2024-10-31T12:30:05.626Z |
5353294 | 5353294 | 20241023011910_0wm9J | BE0007 | 2024-10-24T12:19:38.440Z | 2024-10-31T12:30:04.101Z |
5353107 | 5353107 | 20241023010800_w424S | BE0007 | 2024-10-24T12:19:32.557Z | 2024-10-31T12:30:03.829Z |
5352921 | 5352921 | 20241023005631_lzDKU | BE0007 | 2024-10-24T12:19:25.849Z | 2024-10-31T12:30:03.542Z |
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);