participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,381 rows where station_code = "BE000K" 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 |
---|---|---|---|---|---|
5133256 | 5133256 | 20240916031322_LkybN | BE000K | 2024-09-19T12:16:51.625Z | 2024-09-19T12:16:51.625Z |
5133021 | 5133021 | 20240916024354_yb4FB | BE000K | 2024-09-19T12:16:41.256Z | 2024-09-19T12:16:41.256Z |
5132976 | 5132976 | 20240916023850_HyE80 | BE000K | 2024-09-19T12:16:39.806Z | 2024-09-19T12:16:39.806Z |
5129327 | 5129327 | 20240917034820_Ae2I2 | BE000K | 2024-09-19T12:11:29.027Z | 2024-09-19T12:11:29.027Z |
5129180 | 5129180 | 20240917033304_xPfLL | BE000K | 2024-09-19T12:11:21.749Z | 2024-09-19T12:11:21.749Z |
5128523 | 5128523 | 20240917015548_n37Pa | BE000K | 2024-09-19T12:10:40.485Z | 2024-09-19T12:10:40.485Z |
5128373 | 5128373 | 20240917013118_16KTh | BE000K | 2024-09-19T12:10:29.414Z | 2024-09-19T12:10:29.414Z |
5128150 | 5128150 | 20240917005315_I1EpZ | BE000K | 2024-09-19T12:10:11.152Z | 2024-09-19T12:10:11.152Z |
5128037 | 5128037 | 20240917002640_KPVPb | BE000K | 2024-09-19T12:09:55.816Z | 2024-09-19T12:09:55.816Z |
5127971 | 5127971 | 20240917001315_GinwI | BE000K | 2024-09-19T12:09:50.560Z | 2024-09-19T12:09:50.560Z |
5127841 | 5127841 | 20240916234822_3THuB | BE000K | 2024-09-19T12:09:43.088Z | 2024-09-19T12:09:43.088Z |
5121798 | 5121798 | 20240914041441_9rVaE | BE000K | 2024-09-18T12:11:01.423Z | 2024-09-19T12:20:02.370Z |
5121438 | 5121438 | 20240914040227_SGHXz | BE000K | 2024-09-18T12:10:55.466Z | 2024-09-19T12:20:01.846Z |
5121270 | 5121270 | 20240914035653_tRMt7 | BE000K | 2024-09-18T12:10:53.783Z | 2024-09-19T12:20:01.552Z |
5120518 | 5120518 | 20240914032617_gBymw | BE000K | 2024-09-18T12:10:42.646Z | 2024-09-19T12:20:00.525Z |
5120318 | 5120318 | 20240914031438_5unwJ | BE000K | 2024-09-18T12:10:37.115Z | 2024-09-19T12:19:59.867Z |
5120048 | 5120048 | 20240914025821_HQf6T | BE000K | 2024-09-18T12:10:31.512Z | 2024-09-19T12:19:59.348Z |
5119488 | 5119488 | 20240914023626_puAU2 | BE000K | 2024-09-18T12:10:21.648Z | 2024-09-19T12:19:58.354Z |
5119348 | 5119348 | 20240914022701_rAiS2 | BE000K | 2024-09-18T12:10:20.451Z | 2024-09-19T12:19:58.045Z |
5117037 | 5117037 | 20240915035811_l0aQb | BE000K | 2024-09-18T12:07:30.857Z | 2024-09-19T12:19:13.175Z |
5117007 | 5117007 | 20240915035557_3vQF3 | BE000K | 2024-09-18T12:07:28.212Z | 2024-09-19T12:19:12.994Z |
5116889 | 5116889 | 20240915034642_mPKqN | BE000K | 2024-09-18T12:07:24.619Z | 2024-09-19T12:19:12.605Z |
5116735 | 5116735 | 20240915033815_4rbVI | BE000K | 2024-09-18T12:07:18.260Z | 2024-09-19T12:19:12.169Z |
5116314 | 5116314 | 20240915032114_e9r9H | BE000K | 2024-09-18T12:06:56.841Z | 2024-09-19T12:19:10.332Z |
5116111 | 5116111 | 20240915030904_T6I4t | BE000K | 2024-09-18T12:06:40.683Z | 2024-09-19T12:19:08.752Z |
5115387 | 5115387 | 20240915023610_3b5gx | BE000K | 2024-09-18T12:06:12.577Z | 2024-09-19T12:19:04.428Z |
5115153 | 5115153 | 20240915022252_9ckTF | BE000K | 2024-09-18T12:06:04.105Z | 2024-09-19T12:19:02.617Z |
5114860 | 5114860 | 20240915020201_q1sdb | BE000K | 2024-09-18T12:05:38.624Z | 2024-09-19T12:19:00.419Z |
5114690 | 5114690 | 20240915015359_M2Uy3 | BE000K | 2024-09-18T12:05:28.212Z | 2024-09-19T12:18:59.259Z |
5114565 | 5114565 | 20240915014836_AxQSd | BE000K | 2024-09-18T12:05:21.968Z | 2024-09-19T12:18:58.867Z |
5114224 | 5114224 | 20240915013226_XI9w2 | BE000K | 2024-09-18T12:05:07.453Z | 2024-09-19T12:18:57.009Z |
5114113 | 5114113 | 20240915012731_6V1fX | BE000K | 2024-09-18T12:05:02.810Z | 2024-09-19T12:18:56.128Z |
5113576 | 5113576 | 20240915005908_bmDyB | BE000K | 2024-09-18T12:04:32.429Z | 2024-09-19T12:18:50.462Z |
5113524 | 5113524 | 20240915005521_QH03i | BE000K | 2024-09-18T12:04:25.817Z | 2024-09-19T12:18:49.862Z |
5113112 | 5113112 | 20240915002243_Tplip | BE000K | 2024-09-18T12:03:56.829Z | 2024-09-19T12:18:47.108Z |
5113072 | 5113072 | 20240915001754_y8WaD | BE000K | 2024-09-18T12:03:54.349Z | 2024-09-19T12:18:46.860Z |
5112908 | 5112908 | 20240915000530_pYjpg | BE000K | 2024-09-18T12:03:46.323Z | 2024-09-19T12:18:45.629Z |
5112720 | 5112720 | 20240914234517_2ZuYJ | BE000K | 2024-09-18T12:03:24.789Z | 2024-09-19T12:18:43.642Z |
5112627 | 5112627 | 20240914233716_d1b35 | BE000K | 2024-09-18T12:03:17.979Z | 2024-09-19T12:18:42.470Z |
5112318 | 5112318 | 20240914225810_d30kW | BE000K | 2024-09-18T12:03:00.030Z | 2024-09-19T12:18:40.525Z |
5106420 | 5106420 | 20240913032413_Tw3rV | BE000K | 2024-09-17T12:12:53.539Z | 2024-09-19T12:20:46.062Z |
5105899 | 5105899 | 20240913030230_Gaiam | BE000K | 2024-09-17T12:12:32.344Z | 2024-09-19T12:20:45.040Z |
5104712 | 5104712 | 20240913021932_gN01q | BE000K | 2024-09-17T12:11:43.420Z | 2024-09-19T12:20:42.807Z |
5104221 | 5104221 | 20240913015919_gDIyS | BE000K | 2024-09-17T12:11:29.696Z | 2024-09-19T12:20:41.258Z |
5104070 | 5104070 | 20240913015020_6BKoi | BE000K | 2024-09-17T12:11:24.003Z | 2024-09-19T12:20:40.947Z |
5104013 | 5104013 | 20240913014714_c2Urv | BE000K | 2024-09-17T12:11:21.972Z | 2024-09-19T12:20:40.828Z |
5103940 | 5103940 | 20240913014512_HlfpI | BE000K | 2024-09-17T12:11:20.119Z | 2024-09-19T12:20:40.685Z |
5103310 | 5103310 | 20240913012429_Uf5NS | BE000K | 2024-09-17T12:10:49.931Z | 2024-09-19T12:20:40.005Z |
5100947 | 5100947 | 20240913235417_Ey7iV | BE000K | 2024-09-17T12:05:11.645Z | 2024-09-19T12:19:49.342Z |
5100306 | 5100306 | 20240913231836_GdIr9 | BE000K | 2024-09-17T12:04:26.899Z | 2024-09-19T12:19:47.769Z |
5100276 | 5100276 | 20240913231411_UUCfC | BE000K | 2024-09-17T12:04:23.862Z | 2024-09-19T12:19:47.593Z |
5099994 | 5099994 | 20240913223446_SUdhj | BE000K | 2024-09-17T12:03:49.042Z | 2024-09-19T12:19:46.649Z |
5099476 | 5099476 | 20240913211844_F7hCW | BE000K | 2024-09-17T12:03:00.862Z | 2024-09-19T12:19:45.029Z |
5099446 | 5099446 | 20240913211556_dVR1E | BE000K | 2024-09-17T12:02:58.056Z | 2024-09-19T12:19:44.959Z |
5099265 | 5099265 | 20240913204817_1ffJl | BE000K | 2024-09-17T12:02:38.445Z | 2024-09-19T12:19:44.351Z |
5098189 | 5098189 | 20240913012127_EAoX3 | BE000K | 2024-09-16T12:17:21.549Z | 2024-09-19T12:20:39.835Z |
5097755 | 5097755 | 20240913010033_3iBcX | BE000K | 2024-09-16T12:17:14.492Z | 2024-09-19T12:20:38.951Z |
5097568 | 5097568 | 20240913005430_C4Me1 | BE000K | 2024-09-16T12:17:13.449Z | 2024-09-19T12:20:38.720Z |
5097501 | 5097501 | 20240913005209_XJffv | BE000K | 2024-09-16T12:17:12.991Z | 2024-09-19T12:20:38.671Z |
5097485 | 5097485 | 20240913005128_BpyNF | BE000K | 2024-09-16T12:17:12.973Z | 2024-09-19T12:20:38.658Z |
5097375 | 5097375 | 20240913004427_JGYnb | BE000K | 2024-09-16T12:17:11.780Z | 2024-09-19T12:20:38.446Z |
5097358 | 5097358 | 20240913004359_eFgrr | BE000K | 2024-09-16T12:17:11.618Z | 2024-09-19T12:20:38.416Z |
5097213 | 5097213 | 20240913003656_QWgeN | BE000K | 2024-09-16T12:17:08.284Z | 2024-09-19T12:20:37.864Z |
5094092 | 5094092 | 20240912034749_JVnBY | BE000K | 2024-09-16T12:14:33.952Z | 2024-09-19T12:21:15.881Z |
5091933 | 5091933 | 20240912022859_J4Zvv | BE000K | 2024-09-16T12:13:32.080Z | 2024-09-19T12:21:13.497Z |
5090428 | 5090428 | 20240912012446_ARPri | BE000K | 2024-09-16T12:12:19.939Z | 2024-09-19T12:21:11.316Z |
5090344 | 5090344 | 20240912012201_Admoo | BE000K | 2024-09-16T12:12:15.270Z | 2024-09-19T12:21:11.227Z |
5090267 | 5090267 | 20240912011932_yzyPL | BE000K | 2024-09-16T12:12:10.246Z | 2024-09-19T12:21:11.153Z |
5088872 | 5088872 | 20240913003046_7JGE2 | BE000K | 2024-09-16T12:08:34.414Z | 2024-09-19T12:20:37.362Z |
5088301 | 5088301 | 20240913000550_1MzSc | BE000K | 2024-09-16T12:07:53.493Z | 2024-09-19T12:20:36.664Z |
5087698 | 5087698 | 20240912234013_uHrL4 | BE000K | 2024-09-16T12:07:16.476Z | 2024-09-19T12:20:35.565Z |
5086733 | 5086733 | 20240912224614_eBjBn | BE000K | 2024-09-16T12:05:58.848Z | 2024-09-19T12:20:31.546Z |
5086725 | 5086725 | 20240912224610_SlakL | BE000K | 2024-09-16T12:05:58.462Z | 2024-09-19T12:20:31.540Z |
5086609 | 5086609 | 20240912224334_SBfnX | BE000K | 2024-09-16T12:05:54.741Z | 2024-09-19T12:20:31.463Z |
5086571 | 5086571 | 20240912224155_R2r33 | BE000K | 2024-09-16T12:05:53.559Z | 2024-09-19T12:20:31.448Z |
5086078 | 5086078 | 20240912220739_GX1ZY | BE000K | 2024-09-16T12:05:12.612Z | 2024-09-19T12:20:30.101Z |
5085381 | 5085381 | 20240912211631_AGiy0 | BE000K | 2024-09-16T12:04:12.253Z | 2024-09-19T12:20:28.536Z |
5084856 | 5084856 | 20240912202404_mLADs | BE000K | 2024-09-16T12:03:02.920Z | 2024-09-19T12:20:27.352Z |
5084322 | 5084322 | 20240912192031_1AQjy | BE000K | 2024-09-16T12:01:52.639Z | 2024-09-19T12:20:24.959Z |
5079059 | 5079059 | 20240911023054_vMf0U | BE000K | 2024-09-15T12:16:03.483Z | 2024-09-19T12:21:41.048Z |
5073209 | 5073209 | 20240911210548_qqu8C | BE000K | 2024-09-15T12:06:54.741Z | 2024-09-19T12:21:05.232Z |
5073024 | 5073024 | 20240911205253_J9xKH | BE000K | 2024-09-15T12:06:28.363Z | 2024-09-19T12:21:05.081Z |
5072076 | 5072076 | 20240911192939_KedRF | BE000K | 2024-09-15T12:04:36.546Z | 2024-09-19T12:21:03.434Z |
5065031 | 5065031 | 20240910025627_0Mq62 | BE000K | 2024-09-14T12:16:18.791Z | 2024-09-18T12:15:18.180Z |
5064027 | 5064027 | 20240909233211_ED3Fk | BE000K | 2024-09-14T12:14:43.614Z | 2024-09-18T12:15:15.234Z |
5054735 | 5054735 | 20240908034818_sdmEb | BE000K | 2024-09-13T12:16:54.678Z | 2024-09-16T12:21:16.762Z |
5054610 | 5054610 | 20240908031954_Ugo35 | BE000K | 2024-09-13T12:16:49.136Z | 2024-09-16T12:21:16.256Z |
5054503 | 5054503 | 20240908030256_2IIf2 | BE000K | 2024-09-13T12:16:44.947Z | 2024-09-16T12:21:15.804Z |
5054499 | 5054499 | 20240908030227_c0h6p | BE000K | 2024-09-13T12:16:44.705Z | 2024-09-16T12:21:15.746Z |
5054427 | 5054427 | 20240908024942_E7Egu | BE000K | 2024-09-13T12:16:40.896Z | 2024-09-16T12:21:15.536Z |
5054292 | 5054292 | 20240908023653_n63eK | BE000K | 2024-09-13T12:16:36.223Z | 2024-09-16T12:21:14.758Z |
5054259 | 5054259 | 20240908023336_7US9v | BE000K | 2024-09-13T12:16:35.661Z | 2024-09-16T12:21:14.691Z |
5054203 | 5054203 | 20240908022634_8hbfs | BE000K | 2024-09-13T12:16:33.797Z | 2024-09-16T12:21:14.290Z |
5053828 | 5053828 | 20240908013719_ckaqt | BE000K | 2024-09-13T12:16:18.865Z | 2024-09-16T12:21:12.868Z |
5053784 | 5053784 | 20240908012944_UOVgp | BE000K | 2024-09-13T12:16:17.523Z | 2024-09-16T12:21:12.772Z |
5053686 | 5053686 | 20240908011729_32JtT | BE000K | 2024-09-13T12:16:13.439Z | 2024-09-16T12:21:12.414Z |
5032336 | 5032336 | 20240907004705_XuiWD | BE000K | 2024-09-12T12:07:08.356Z | 2024-09-15T12:21:26.093Z |
5032285 | 5032285 | 20240907004027_3oKbZ | BE000K | 2024-09-12T12:07:03.580Z | 2024-09-15T12:21:25.801Z |
5032203 | 5032203 | 20240907002936_ycFBI | BE000K | 2024-09-12T12:06:44.990Z | 2024-09-15T12:21:25.584Z |
5001134 | 5001134 | 20240902033541_5xUYO | BE000K | 2024-09-08T12:16:11.347Z | 2024-09-10T12:19:32.029Z |
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);