participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,854 rows where station_code = "LU0001" 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 |
---|---|---|---|---|---|
5131590 | 5131590 | 20240915202338_qe2bb | LU0001 | 2024-09-19T12:15:10.479Z | 2024-09-19T12:15:10.479Z |
5131394 | 5131394 | 20240915193400_bxmuQ | LU0001 | 2024-09-19T12:15:00.785Z | 2024-09-19T12:15:00.785Z |
5129427 | 5129427 | 20240917035543_kdYoE | LU0001 | 2024-09-19T12:11:36.494Z | 2024-09-19T12:11:36.494Z |
5128934 | 5128934 | 20240917025755_MG5ic | LU0001 | 2024-09-19T12:11:08.255Z | 2024-09-19T12:11:08.255Z |
5128687 | 5128687 | 20240917022419_3XHC2 | LU0001 | 2024-09-19T12:10:56.518Z | 2024-09-19T12:10:56.518Z |
5125792 | 5125792 | 20240918035512_j2mi2 | LU0001 | 2024-09-19T12:04:07.043Z | 2024-09-19T12:06:42.086Z |
5125579 | 5125579 | 20240918030347_wsHcJ | LU0001 | 2024-09-19T12:03:34.021Z | 2024-09-19T12:06:42.053Z |
5125268 | 5125268 | 20240918014459_dMb39 | LU0001 | 2024-09-19T12:02:38.143Z | 2024-09-19T12:06:42.002Z |
5125209 | 5125209 | 20240918011203_auyLu | LU0001 | 2024-09-19T12:02:30.446Z | 2024-09-19T12:06:41.992Z |
5125086 | 5125086 | 20240918000601_JEmmY | LU0001 | 2024-09-19T12:02:13.378Z | 2024-09-19T12:06:41.974Z |
5121340 | 5121340 | 20240914035816_eAFvx | LU0001 | 2024-09-18T12:10:54.584Z | 2024-09-19T12:20:01.625Z |
5121272 | 5121272 | 20240914035653_tRMt7 | LU0001 | 2024-09-18T12:10:53.783Z | 2024-09-19T12:20:01.552Z |
5121269 | 5121269 | 20240914035653_5wVal | LU0001 | 2024-09-18T12:10:53.700Z | 2024-09-19T12:20:01.551Z |
5121185 | 5121185 | 20240914035441_Z0JUc | LU0001 | 2024-09-18T12:10:52.171Z | 2024-09-19T12:20:01.472Z |
5120590 | 5120590 | 20240914032933_hUohF | LU0001 | 2024-09-18T12:10:43.493Z | 2024-09-19T12:20:00.624Z |
5120372 | 5120372 | 20240914031817_Patgp | LU0001 | 2024-09-18T12:10:38.739Z | 2024-09-19T12:20:00.070Z |
5120309 | 5120309 | 20240914031413_d0A9k | LU0001 | 2024-09-18T12:10:36.918Z | 2024-09-19T12:19:59.864Z |
5120208 | 5120208 | 20240914030619_87wf3 | LU0001 | 2024-09-18T12:10:34.604Z | 2024-09-19T12:19:59.694Z |
5120170 | 5120170 | 20240914030317_D0fuL | LU0001 | 2024-09-18T12:10:33.525Z | 2024-09-19T12:19:59.533Z |
5120150 | 5120150 | 20240914030246_x1AUG | LU0001 | 2024-09-18T12:10:33.006Z | 2024-09-19T12:19:59.500Z |
5119491 | 5119491 | 20240914023629_yFB33 | LU0001 | 2024-09-18T12:10:21.698Z | 2024-09-19T12:19:58.366Z |
5119480 | 5119480 | 20240914023608_5GN5k | LU0001 | 2024-09-18T12:10:21.546Z | 2024-09-19T12:19:58.292Z |
5119087 | 5119087 | 20240914020746_W4pOG | LU0001 | 2024-09-18T12:10:15.661Z | 2024-09-19T12:19:57.030Z |
5116749 | 5116749 | 20240915033836_lRzJd | LU0001 | 2024-09-18T12:07:19.491Z | 2024-09-19T12:19:12.257Z |
5116732 | 5116732 | 20240915033756_e2CxP | LU0001 | 2024-09-18T12:07:18.029Z | 2024-09-19T12:19:12.164Z |
5116666 | 5116666 | 20240915033423_EpXvA | LU0001 | 2024-09-18T12:07:15.010Z | 2024-09-19T12:19:11.872Z |
5116633 | 5116633 | 20240915033351_AIM6Q | LU0001 | 2024-09-18T12:07:13.597Z | 2024-09-19T12:19:11.731Z |
5116572 | 5116572 | 20240915033222_TqQU5 | LU0001 | 2024-09-18T12:07:10.541Z | 2024-09-19T12:19:11.566Z |
5115524 | 5115524 | 20240915024416_9fFuF | LU0001 | 2024-09-18T12:06:16.934Z | 2024-09-19T12:19:05.176Z |
5115382 | 5115382 | 20240915023521_dGnrX | LU0001 | 2024-09-18T12:06:12.172Z | 2024-09-19T12:19:04.134Z |
5114447 | 5114447 | 20240915014253_xh6g2 | LU0001 | 2024-09-18T12:05:17.618Z | 2024-09-19T12:18:58.253Z |
5114237 | 5114237 | 20240915013253_vuJpc | LU0001 | 2024-09-18T12:05:08.325Z | 2024-09-19T12:18:57.159Z |
5113963 | 5113963 | 20240915012109_R3D9l | LU0001 | 2024-09-18T12:04:56.625Z | 2024-09-19T12:18:54.882Z |
5113824 | 5113824 | 20240915011426_98EFN | LU0001 | 2024-09-18T12:04:51.649Z | 2024-09-19T12:18:52.906Z |
5113707 | 5113707 | 20240915010814_EJFy0 | LU0001 | 2024-09-18T12:04:45.598Z | 2024-09-19T12:18:51.737Z |
5113390 | 5113390 | 20240915004430_5nEmx | LU0001 | 2024-09-18T12:04:12.240Z | 2024-09-19T12:18:48.812Z |
5112918 | 5112918 | 20240915000600_W4XkB | LU0001 | 2024-09-18T12:03:46.834Z | 2024-09-19T12:18:45.769Z |
5112903 | 5112903 | 20240915000431_ek2vg | LU0001 | 2024-09-18T12:03:45.719Z | 2024-09-19T12:18:45.540Z |
5112865 | 5112865 | 20240915000131_L3lfC | LU0001 | 2024-09-18T12:03:43.928Z | 2024-09-19T12:18:45.433Z |
5112822 | 5112822 | 20240914235809_RpJEW | LU0001 | 2024-09-18T12:03:41.078Z | 2024-09-19T12:18:45.085Z |
5112241 | 5112241 | 20240914224251_9rB4A | LU0001 | 2024-09-18T12:02:55.314Z | 2024-09-19T12:18:39.925Z |
5112112 | 5112112 | 20240914221600_CCY3y | LU0001 | 2024-09-18T12:02:48.287Z | 2024-09-19T12:18:38.383Z |
5112079 | 5112079 | 20240914220901_Hl1TP | LU0001 | 2024-09-18T12:02:46.195Z | 2024-09-19T12:18:37.942Z |
5111901 | 5111901 | 20240914213447_O44xt | LU0001 | 2024-09-18T12:02:29.287Z | 2024-09-19T12:18:35.079Z |
5111478 | 5111478 | 20240914204220_LzxWb | LU0001 | 2024-09-18T12:01:59.029Z | 2024-09-19T12:18:30.717Z |
5111449 | 5111449 | 20240914203740_4Dybq | LU0001 | 2024-09-18T12:01:56.792Z | 2024-09-19T12:18:30.326Z |
5111030 | 5111030 | 20240914194243_3cVEl | LU0001 | 2024-09-18T12:01:21.087Z | 2024-09-19T12:18:25.448Z |
5110865 | 5110865 | 20240914191624_RgIpB | LU0001 | 2024-09-18T12:01:06.786Z | 2024-09-19T12:18:24.357Z |
5106845 | 5106845 | 20240913033716_JVrRp | LU0001 | 2024-09-17T12:13:02.985Z | 2024-09-19T12:20:46.484Z |
5102811 | 5102811 | 20240914014627_oGNWx | LU0001 | 2024-09-17T12:07:37.904Z | 2024-09-19T12:19:55.741Z |
5101976 | 5101976 | 20240914005757_0vJ5x | LU0001 | 2024-09-17T12:06:33.893Z | 2024-09-19T12:19:52.046Z |
5101404 | 5101404 | 20240914002404_GWOBW | LU0001 | 2024-09-17T12:05:42.422Z | 2024-09-19T12:19:50.440Z |
5101338 | 5101338 | 20240914002116_K5spJ | LU0001 | 2024-09-17T12:05:36.477Z | 2024-09-19T12:19:50.296Z |
5101233 | 5101233 | 20240914001528_bmy4P | LU0001 | 2024-09-17T12:05:28.813Z | 2024-09-19T12:19:50.082Z |
5101153 | 5101153 | 20240914000730_N2Lm3 | LU0001 | 2024-09-17T12:05:22.899Z | 2024-09-19T12:19:49.883Z |
5101063 | 5101063 | 20240913235923_v8RF9 | LU0001 | 2024-09-17T12:05:17.060Z | 2024-09-19T12:19:49.624Z |
5101047 | 5101047 | 20240913235842_f34Sc | LU0001 | 2024-09-17T12:05:16.413Z | 2024-09-19T12:19:49.577Z |
5100918 | 5100918 | 20240913235346_bUrXf | LU0001 | 2024-09-17T12:05:10.716Z | 2024-09-19T12:19:49.334Z |
5100867 | 5100867 | 20240913235012_YCaY2 | LU0001 | 2024-09-17T12:05:05.131Z | 2024-09-19T12:19:48.896Z |
5100857 | 5100857 | 20240913234754_3Vgvx | LU0001 | 2024-09-17T12:05:02.312Z | 2024-09-19T12:19:48.835Z |
5100477 | 5100477 | 20240913232835_Br8ED | LU0001 | 2024-09-17T12:04:36.009Z | 2024-09-19T12:19:48.052Z |
5100281 | 5100281 | 20240913231434_3uQI7 | LU0001 | 2024-09-17T12:04:24.538Z | 2024-09-19T12:19:47.664Z |
5099786 | 5099786 | 20240913215959_ne2A7 | LU0001 | 2024-09-17T12:03:34.684Z | 2024-09-19T12:19:45.920Z |
5099658 | 5099658 | 20240913214511_FS0bY | LU0001 | 2024-09-17T12:03:18.415Z | 2024-09-19T12:19:45.551Z |
5099345 | 5099345 | 20240913210354_p0cUa | LU0001 | 2024-09-17T12:02:48.446Z | 2024-09-19T12:19:44.564Z |
5099270 | 5099270 | 20240913204817_1ffJl | LU0001 | 2024-09-17T12:02:38.483Z | 2024-09-19T12:19:44.351Z |
5097444 | 5097444 | 20240913004717_9ZJbS | LU0001 | 2024-09-16T12:17:12.766Z | 2024-09-19T12:20:38.638Z |
5097339 | 5097339 | 20240913004136_9mh6D | LU0001 | 2024-09-16T12:17:11.102Z | 2024-09-19T12:20:38.279Z |
5093419 | 5093419 | 20240912032031_Jqpvr | LU0001 | 2024-09-16T12:14:16.616Z | 2024-09-19T12:21:15.309Z |
5089343 | 5089343 | 20240912003636_d6xwW | LU0001 | 2024-09-16T12:11:21.000Z | 2024-09-19T12:21:09.892Z |
5089035 | 5089035 | 20240912002241_DPZoD | LU0001 | 2024-09-16T12:11:13.202Z | 2024-09-19T12:21:09.703Z |
5088543 | 5088543 | 20240913001543_qw529 | LU0001 | 2024-09-16T12:08:10.029Z | 2024-09-19T12:20:37.005Z |
5088271 | 5088271 | 20240913000419_IuMMO | LU0001 | 2024-09-16T12:07:51.345Z | 2024-09-19T12:20:36.591Z |
5088204 | 5088204 | 20240913000142_GbC3H | LU0001 | 2024-09-16T12:07:48.075Z | 2024-09-19T12:20:36.494Z |
5088012 | 5088012 | 20240912235329_92HlQ | LU0001 | 2024-09-16T12:07:40.518Z | 2024-09-19T12:20:36.041Z |
5087957 | 5087957 | 20240912235023_Sa3vw | LU0001 | 2024-09-16T12:07:38.222Z | 2024-09-19T12:20:35.982Z |
5087173 | 5087173 | 20240912231329_P32VN | LU0001 | 2024-09-16T12:06:44.726Z | 2024-09-19T12:20:34.115Z |
5087016 | 5087016 | 20240912230241_BAAWv | LU0001 | 2024-09-16T12:06:23.848Z | 2024-09-19T12:20:33.416Z |
5086746 | 5086746 | 20240912224630_QBg0Q | LU0001 | 2024-09-16T12:05:59.705Z | 2024-09-19T12:20:31.613Z |
5086739 | 5086739 | 20240912224614_eBjBn | LU0001 | 2024-09-16T12:05:58.848Z | 2024-09-19T12:20:31.547Z |
5086614 | 5086614 | 20240912224334_SBfnX | LU0001 | 2024-09-16T12:05:54.741Z | 2024-09-19T12:20:31.464Z |
5086284 | 5086284 | 20240912222345_GyhLI | LU0001 | 2024-09-16T12:05:28.317Z | 2024-09-19T12:20:30.741Z |
5084362 | 5084362 | 20240912192732_ewpip | LU0001 | 2024-09-16T12:01:57.376Z | 2024-09-19T12:20:25.184Z |
5084332 | 5084332 | 20240912192343_rDi8Y | LU0001 | 2024-09-16T12:01:53.910Z | 2024-09-19T12:20:24.996Z |
5075824 | 5075824 | 20240912000912_hMnHZ | LU0001 | 2024-09-15T12:10:16.565Z | 2024-09-19T12:21:09.577Z |
5075803 | 5075803 | 20240912000813_SvwgV | LU0001 | 2024-09-15T12:10:14.888Z | 2024-09-19T12:21:09.535Z |
5075708 | 5075708 | 20240912000158_uICmb | LU0001 | 2024-09-15T12:10:08.975Z | 2024-09-19T12:21:09.437Z |
5075602 | 5075602 | 20240911235709_uTgOz | LU0001 | 2024-09-15T12:10:04.183Z | 2024-09-19T12:21:09.328Z |
5075352 | 5075352 | 20240911234208_aqNpB | LU0001 | 2024-09-15T12:09:37.095Z | 2024-09-19T12:21:09.136Z |
5075177 | 5075177 | 20240911233430_j7Yp4 | LU0001 | 2024-09-15T12:09:29.079Z | 2024-09-19T12:21:08.722Z |
5075056 | 5075056 | 20240911232531_3vTVp | LU0001 | 2024-09-15T12:09:21.140Z | 2024-09-19T12:21:08.061Z |
5074886 | 5074886 | 20240911231312_ydmmO | LU0001 | 2024-09-15T12:09:10.994Z | 2024-09-19T12:21:07.884Z |
5074777 | 5074777 | 20240911230222_lWAPW | LU0001 | 2024-09-15T12:08:52.810Z | 2024-09-19T12:21:07.745Z |
5074640 | 5074640 | 20240911225201_W34VO | LU0001 | 2024-09-15T12:08:41.859Z | 2024-09-19T12:21:07.557Z |
5074307 | 5074307 | 20240911222856_nNGpq | LU0001 | 2024-09-15T12:08:20.092Z | 2024-09-19T12:21:07.028Z |
5073842 | 5073842 | 20240911215121_CtXI2 | LU0001 | 2024-09-15T12:07:40.939Z | 2024-09-19T12:21:06.318Z |
5073510 | 5073510 | 20240911212826_myTY2 | LU0001 | 2024-09-15T12:07:14.121Z | 2024-09-19T12:21:05.836Z |
5072686 | 5072686 | 20240911203650_exS43 | LU0001 | 2024-09-15T12:06:01.316Z | 2024-09-19T12:21:04.640Z |
5072109 | 5072109 | 20240911193658_SYA4m | LU0001 | 2024-09-15T12:04:40.670Z | 2024-09-19T12:21:03.526Z |
5072053 | 5072053 | 20240911192706_6J1NE | LU0001 | 2024-09-15T12:04:32.723Z | 2024-09-19T12:21:03.365Z |
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);