participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,091 rows where station_code = "BE000L" 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 |
---|---|---|---|---|---|
5133458 | 5133458 | 20240916033123_3N2hZ | BE000L | 2024-09-19T12:16:57.372Z | 2024-09-19T12:16:57.372Z |
5133258 | 5133258 | 20240916031345_Kfe1s | BE000L | 2024-09-19T12:16:51.735Z | 2024-09-19T12:16:51.735Z |
5133257 | 5133257 | 20240916031322_LkybN | BE000L | 2024-09-19T12:16:51.625Z | 2024-09-19T12:16:51.625Z |
5133051 | 5133051 | 20240916024833_fwT6H | BE000L | 2024-09-19T12:16:42.769Z | 2024-09-19T12:16:42.769Z |
5133030 | 5133030 | 20240916024451_3SY9v | BE000L | 2024-09-19T12:16:41.763Z | 2024-09-19T12:16:41.763Z |
5133025 | 5133025 | 20240916024414_OlnXX | BE000L | 2024-09-19T12:16:41.514Z | 2024-09-19T12:16:41.514Z |
5133022 | 5133022 | 20240916024354_yb4FB | BE000L | 2024-09-19T12:16:41.256Z | 2024-09-19T12:16:41.256Z |
5133008 | 5133008 | 20240916024224_Lbkrq | BE000L | 2024-09-19T12:16:40.660Z | 2024-09-19T12:16:40.660Z |
5132926 | 5132926 | 20240916022931_Gx2xK | BE000L | 2024-09-19T12:16:36.270Z | 2024-09-19T12:16:36.270Z |
5132662 | 5132662 | 20240916015118_2lweE | BE000L | 2024-09-19T12:16:25.640Z | 2024-09-19T12:16:25.640Z |
5132546 | 5132546 | 20240916012737_rXiyu | BE000L | 2024-09-19T12:16:18.336Z | 2024-09-19T12:16:18.336Z |
5125855 | 5125855 | 20240918041157_e3MtU | BE000L | 2024-09-19T12:04:19.205Z | 2024-09-19T12:06:42.096Z |
5125728 | 5125728 | 20240918033107_d2XTW | BE000L | 2024-09-19T12:03:58.197Z | 2024-09-19T12:06:42.076Z |
5125416 | 5125416 | 20240918023145_D2Byc | BE000L | 2024-09-19T12:03:12.112Z | 2024-09-19T12:06:42.029Z |
5125341 | 5125341 | 20240918021407_aA52j | BE000L | 2024-09-19T12:03:00.852Z | 2024-09-19T12:06:42.016Z |
5125240 | 5125240 | 20240918012932_Sd38K | BE000L | 2024-09-19T12:02:33.976Z | 2024-09-19T12:06:41.997Z |
5125228 | 5125228 | 20240918012250_OGdbc | BE000L | 2024-09-19T12:02:32.744Z | 2024-09-19T12:06:41.995Z |
5125222 | 5125222 | 20240918012035_GzvUw | BE000L | 2024-09-19T12:02:31.997Z | 2024-09-19T12:06:41.994Z |
5125143 | 5125143 | 20240918003312_QRYVO | BE000L | 2024-09-19T12:02:23.731Z | 2024-09-19T12:06:41.982Z |
5124815 | 5124815 | 20240917220839_bSakV | BE000L | 2024-09-19T12:01:37.364Z | 2024-09-19T12:06:41.938Z |
5121439 | 5121439 | 20240914040227_SGHXz | BE000L | 2024-09-18T12:10:55.466Z | 2024-09-19T12:20:01.846Z |
5119489 | 5119489 | 20240914023626_puAU2 | BE000L | 2024-09-18T12:10:21.648Z | 2024-09-19T12:19:58.354Z |
5119431 | 5119431 | 20240914023326_d3xeg | BE000L | 2024-09-18T12:10:21.251Z | 2024-09-19T12:19:58.238Z |
5119349 | 5119349 | 20240914022701_rAiS2 | BE000L | 2024-09-18T12:10:20.451Z | 2024-09-19T12:19:58.045Z |
5119285 | 5119285 | 20240914022147_7UP2g | BE000L | 2024-09-18T12:10:19.487Z | 2024-09-19T12:19:57.630Z |
5119209 | 5119209 | 20240914021800_o2k60 | BE000L | 2024-09-18T12:10:18.573Z | 2024-09-19T12:19:57.402Z |
5119141 | 5119141 | 20240914021234_6merW | BE000L | 2024-09-18T12:10:16.557Z | 2024-09-19T12:19:57.227Z |
5119094 | 5119094 | 20240914020906_umCjY | BE000L | 2024-09-18T12:10:16.038Z | 2024-09-19T12:19:57.095Z |
5119064 | 5119064 | 20240914020708_GXTQz | BE000L | 2024-09-18T12:10:15.513Z | 2024-09-19T12:19:57.007Z |
5119037 | 5119037 | 20240914020602_ucobm | BE000L | 2024-09-18T12:10:15.264Z | 2024-09-19T12:19:56.960Z |
5117038 | 5117038 | 20240915035811_l0aQb | BE000L | 2024-09-18T12:07:30.857Z | 2024-09-19T12:19:13.175Z |
5116890 | 5116890 | 20240915034642_mPKqN | BE000L | 2024-09-18T12:07:24.619Z | 2024-09-19T12:19:12.605Z |
5116674 | 5116674 | 20240915033447_IjksM | BE000L | 2024-09-18T12:07:15.814Z | 2024-09-19T12:19:11.965Z |
5116670 | 5116670 | 20240915033433_wT2kh | BE000L | 2024-09-18T12:07:15.626Z | 2024-09-19T12:19:11.943Z |
5116629 | 5116629 | 20240915033351_AIM6Q | BE000L | 2024-09-18T12:07:13.597Z | 2024-09-19T12:19:11.730Z |
5116315 | 5116315 | 20240915032114_e9r9H | BE000L | 2024-09-18T12:06:56.841Z | 2024-09-19T12:19:10.332Z |
5115388 | 5115388 | 20240915023610_3b5gx | BE000L | 2024-09-18T12:06:12.577Z | 2024-09-19T12:19:04.428Z |
5115154 | 5115154 | 20240915022252_9ckTF | BE000L | 2024-09-18T12:06:04.105Z | 2024-09-19T12:19:02.617Z |
5115077 | 5115077 | 20240915021839_RjlJE | BE000L | 2024-09-18T12:05:56.735Z | 2024-09-19T12:19:01.501Z |
5114965 | 5114965 | 20240915021153_3H5t8 | BE000L | 2024-09-18T12:05:47.503Z | 2024-09-19T12:19:00.895Z |
5114961 | 5114961 | 20240915021050_bdI9Q | BE000L | 2024-09-18T12:05:46.939Z | 2024-09-19T12:19:00.893Z |
5114944 | 5114944 | 20240915020921_jJkiU | BE000L | 2024-09-18T12:05:45.271Z | 2024-09-19T12:19:00.702Z |
5114861 | 5114861 | 20240915020201_q1sdb | BE000L | 2024-09-18T12:05:38.625Z | 2024-09-19T12:19:00.419Z |
5114808 | 5114808 | 20240915020019_VS3Gr | BE000L | 2024-09-18T12:05:35.655Z | 2024-09-19T12:19:00.055Z |
5114712 | 5114712 | 20240915015619_23Z9S | BE000L | 2024-09-18T12:05:31.351Z | 2024-09-19T12:18:59.488Z |
5114693 | 5114693 | 20240915015420_GoMeI | BE000L | 2024-09-18T12:05:28.587Z | 2024-09-19T12:18:59.322Z |
5114605 | 5114605 | 20240915015220_S7fbB | BE000L | 2024-09-18T12:05:25.373Z | 2024-09-19T12:18:59.077Z |
5114566 | 5114566 | 20240915014836_AxQSd | BE000L | 2024-09-18T12:05:21.968Z | 2024-09-19T12:18:58.867Z |
5114082 | 5114082 | 20240915012534_QuMfY | BE000L | 2024-09-18T12:05:01.181Z | 2024-09-19T12:18:55.797Z |
5114031 | 5114031 | 20240915012343_uLoP5 | BE000L | 2024-09-18T12:04:59.511Z | 2024-09-19T12:18:55.397Z |
5114005 | 5114005 | 20240915012223_X1xKl | BE000L | 2024-09-18T12:04:57.962Z | 2024-09-19T12:18:55.208Z |
5113996 | 5113996 | 20240915012206_ktf2f | BE000L | 2024-09-18T12:04:57.575Z | 2024-09-19T12:18:55.040Z |
5113960 | 5113960 | 20240915012109_R3D9l | BE000L | 2024-09-18T12:04:56.625Z | 2024-09-19T12:18:54.882Z |
5113577 | 5113577 | 20240915005908_bmDyB | BE000L | 2024-09-18T12:04:32.429Z | 2024-09-19T12:18:50.462Z |
5113486 | 5113486 | 20240915005248_mApmO | BE000L | 2024-09-18T12:04:23.515Z | 2024-09-19T12:18:49.682Z |
5113230 | 5113230 | 20240915003247_32jMC | BE000L | 2024-09-18T12:04:04.093Z | 2024-09-19T12:18:48.217Z |
5113168 | 5113168 | 20240915002935_5NL7Y | BE000L | 2024-09-18T12:04:00.891Z | 2024-09-19T12:18:47.784Z |
5112909 | 5112909 | 20240915000530_pYjpg | BE000L | 2024-09-18T12:03:46.323Z | 2024-09-19T12:18:45.629Z |
5112811 | 5112811 | 20240914235708_g1Cwg | BE000L | 2024-09-18T12:03:38.214Z | 2024-09-19T12:18:44.981Z |
5112791 | 5112791 | 20240914235530_hJDa7 | BE000L | 2024-09-18T12:03:33.558Z | 2024-09-19T12:18:44.791Z |
5112697 | 5112697 | 20240914234226_gILFR | BE000L | 2024-09-18T12:03:23.060Z | 2024-09-19T12:18:43.529Z |
5112688 | 5112688 | 20240914234146_KTYPD | BE000L | 2024-09-18T12:03:21.995Z | 2024-09-19T12:18:43.199Z |
5112636 | 5112636 | 20240914233815_3HsAf | BE000L | 2024-09-18T12:03:18.573Z | 2024-09-19T12:18:42.517Z |
5112628 | 5112628 | 20240914233716_d1b35 | BE000L | 2024-09-18T12:03:17.979Z | 2024-09-19T12:18:42.470Z |
5112453 | 5112453 | 20240914231706_QKode | BE000L | 2024-09-18T12:03:07.792Z | 2024-09-19T12:18:41.046Z |
5112075 | 5112075 | 20240914220901_Hl1TP | BE000L | 2024-09-18T12:02:46.195Z | 2024-09-19T12:18:37.942Z |
5112002 | 5112002 | 20240914215245_ekpUF | BE000L | 2024-09-18T12:02:37.517Z | 2024-09-19T12:18:36.374Z |
5111897 | 5111897 | 20240914213447_O44xt | BE000L | 2024-09-18T12:02:29.287Z | 2024-09-19T12:18:35.079Z |
5111445 | 5111445 | 20240914203740_4Dybq | BE000L | 2024-09-18T12:01:56.792Z | 2024-09-19T12:18:30.326Z |
5111437 | 5111437 | 20240914203716_m5CD8 | BE000L | 2024-09-18T12:01:56.329Z | 2024-09-19T12:18:30.188Z |
5111081 | 5111081 | 20240914195109_hWRLm | BE000L | 2024-09-18T12:01:27.743Z | 2024-09-19T12:18:26.197Z |
5111016 | 5111016 | 20240914194130_nc6zC | BE000L | 2024-09-18T12:01:19.815Z | 2024-09-19T12:18:25.333Z |
5110855 | 5110855 | 20240914191402_Yp2Bc | BE000L | 2024-09-18T12:01:06.018Z | 2024-09-19T12:18:24.294Z |
5105403 | 5105403 | 20240913024405_ByScO | BE000L | 2024-09-17T12:12:12.741Z | 2024-09-19T12:20:44.396Z |
5105241 | 5105241 | 20240913023918_Xa9Ou | BE000L | 2024-09-17T12:12:05.327Z | 2024-09-19T12:20:44.165Z |
5105008 | 5105008 | 20240913022640_U51R6 | BE000L | 2024-09-17T12:11:49.409Z | 2024-09-19T12:20:43.407Z |
5104713 | 5104713 | 20240913021932_gN01q | BE000L | 2024-09-17T12:11:43.420Z | 2024-09-19T12:20:42.807Z |
5104535 | 5104535 | 20240913021458_JH3nV | BE000L | 2024-09-17T12:11:38.669Z | 2024-09-19T12:20:41.683Z |
5104222 | 5104222 | 20240913015919_gDIyS | BE000L | 2024-09-17T12:11:29.696Z | 2024-09-19T12:20:41.258Z |
5104071 | 5104071 | 20240913015020_6BKoi | BE000L | 2024-09-17T12:11:24.003Z | 2024-09-19T12:20:40.947Z |
5103941 | 5103941 | 20240913014512_HlfpI | BE000L | 2024-09-17T12:11:20.119Z | 2024-09-19T12:20:40.685Z |
5103509 | 5103509 | 20240913013152_4lIUk | BE000L | 2024-09-17T12:11:00.855Z | 2024-09-19T12:20:40.232Z |
5103311 | 5103311 | 20240913012429_Uf5NS | BE000L | 2024-09-17T12:10:49.931Z | 2024-09-19T12:20:40.005Z |
5103211 | 5103211 | 20240914020535_b95x9 | BE000L | 2024-09-17T12:07:58.586Z | 2024-09-19T12:19:56.909Z |
5103014 | 5103014 | 20240914015755_Xe22d | BE000L | 2024-09-17T12:07:47.042Z | 2024-09-19T12:19:56.323Z |
5102867 | 5102867 | 20240914015012_D2aQ1 | BE000L | 2024-09-17T12:07:41.048Z | 2024-09-19T12:19:55.983Z |
5102745 | 5102745 | 20240914014120_5kdkb | BE000L | 2024-09-17T12:07:34.283Z | 2024-09-19T12:19:55.514Z |
5102590 | 5102590 | 20240914013228_2HMNN | BE000L | 2024-09-17T12:07:26.583Z | 2024-09-19T12:19:55.172Z |
5102514 | 5102514 | 20240914013029_96lpR | BE000L | 2024-09-17T12:07:18.626Z | 2024-09-19T12:19:54.694Z |
5102462 | 5102462 | 20240914012722_nIun6 | BE000L | 2024-09-17T12:07:14.597Z | 2024-09-19T12:19:54.528Z |
5102391 | 5102391 | 20240914012352_3XpQy | BE000L | 2024-09-17T12:07:06.698Z | 2024-09-19T12:19:53.952Z |
5102359 | 5102359 | 20240914012149_FogmS | BE000L | 2024-09-17T12:07:04.719Z | 2024-09-19T12:19:53.897Z |
5102307 | 5102307 | 20240914011715_phYkN | BE000L | 2024-09-17T12:06:59.603Z | 2024-09-19T12:19:53.399Z |
5102302 | 5102302 | 20240914011654_cpofW | BE000L | 2024-09-17T12:06:59.313Z | 2024-09-19T12:19:53.392Z |
5102268 | 5102268 | 20240914011349_WnjbE | BE000L | 2024-09-17T12:06:56.950Z | 2024-09-19T12:19:53.147Z |
5102231 | 5102231 | 20240914011246_Wxz6m | BE000L | 2024-09-17T12:06:55.379Z | 2024-09-19T12:19:52.906Z |
5102053 | 5102053 | 20240914010331_rz0ut | BE000L | 2024-09-17T12:06:44.926Z | 2024-09-19T12:19:52.320Z |
5101977 | 5101977 | 20240914005800_3sWsa | BE000L | 2024-09-17T12:06:34.331Z | 2024-09-19T12:19:52.047Z |
5101892 | 5101892 | 20240914005436_7257Z | BE000L | 2024-09-17T12:06:22.119Z | 2024-09-19T12:19:51.816Z |
5101480 | 5101480 | 20240914002957_DibfU | BE000L | 2024-09-17T12:05:55.448Z | 2024-09-19T12:19:50.691Z |
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);