participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
7,837 rows where station_code = "US001L" 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 |
---|---|---|---|---|---|
5573185 | 5573185 | 20241121040433_Lq2qo | US001L | 2024-11-22T14:19:14.596Z | 2024-11-22T14:19:22.465Z |
5568158 | 5568158 | 20241121115639_rbC8E | US001L | 2024-11-22T14:08:14.269Z | 2024-11-22T14:08:14.269Z |
5568119 | 5568119 | 20241121115310_joGY6 | US001L | 2024-11-22T14:08:08.608Z | 2024-11-22T14:08:08.608Z |
5567477 | 5567477 | 20241121102600_L4faS | US001L | 2024-11-22T14:06:21.861Z | 2024-11-22T14:06:21.861Z |
5567189 | 5567189 | 20241121093815_DJp5H | US001L | 2024-11-22T14:05:31.849Z | 2024-11-22T14:05:31.849Z |
5566820 | 5566820 | 20241121080328_iervp | US001L | 2024-11-22T14:04:11.100Z | 2024-11-22T14:04:11.100Z |
5566796 | 5566796 | 20241121075226_F2N7P | US001L | 2024-11-22T14:04:06.640Z | 2024-11-22T14:04:06.640Z |
5566756 | 5566756 | 20241121074026_QL31n | US001L | 2024-11-22T14:03:52.306Z | 2024-11-22T14:03:52.306Z |
5566623 | 5566623 | 20241121070704_6ckUe | US001L | 2024-11-22T14:03:29.950Z | 2024-11-22T14:03:29.950Z |
5566150 | 5566150 | 20241121053807_02xPk | US001L | 2024-11-22T14:01:59.379Z | 2024-11-22T14:01:59.379Z |
5566046 | 5566046 | 20241121052038_xkxqD | US001L | 2024-11-22T14:01:37.101Z | 2024-11-22T14:01:37.101Z |
5566014 | 5566014 | 20241121051754_jgujC | US001L | 2024-11-22T14:01:34.581Z | 2024-11-22T14:01:34.581Z |
5565971 | 5565971 | 20241121051213_CeZV9 | US001L | 2024-11-22T14:01:30.166Z | 2024-11-22T14:01:30.166Z |
5565227 | 5565227 | 20241120040618_iMK5f | US001L | 2024-11-21T14:18:43.148Z | 2024-11-22T14:21:44.588Z |
5564881 | 5564881 | 20241120033439_W9q6y | US001L | 2024-11-21T14:18:12.609Z | 2024-11-22T14:21:37.741Z |
5564003 | 5564003 | 20241120022244_236Ho | US001L | 2024-11-21T14:17:04.392Z | 2024-11-22T14:21:26.419Z |
5563553 | 5563553 | 20241120014130_31B2m | US001L | 2024-11-21T14:16:18.861Z | 2024-11-22T14:21:18.460Z |
5560475 | 5560475 | 20241120125517_pwTFU | US001L | 2024-11-21T14:08:55.886Z | 2024-11-22T14:19:21.667Z |
5560101 | 5560101 | 20241120115908_QbhK2 | US001L | 2024-11-21T14:08:02.856Z | 2024-11-22T14:19:21.588Z |
5559592 | 5559592 | 20241120104745_TeTvZ | US001L | 2024-11-21T14:06:41.552Z | 2024-11-22T14:19:21.481Z |
5559559 | 5559559 | 20241120104338_VOwxD | US001L | 2024-11-21T14:06:36.242Z | 2024-11-22T14:19:21.473Z |
5557392 | 5557392 | 20241120044309_1jGbn | US001L | 2024-11-21T14:00:41.581Z | 2024-11-22T14:19:21.062Z |
5557136 | 5557136 | 20241119040826_NzHVr | US001L | 2024-11-20T14:12:20.925Z | 2024-11-22T14:22:22.468Z |
5556966 | 5556966 | 20241119031002_8hhJD | US001L | 2024-11-20T14:11:52.186Z | 2024-11-22T14:22:21.358Z |
5556892 | 5556892 | 20241119024022_RPXok | US001L | 2024-11-20T14:11:37.595Z | 2024-11-22T14:22:20.669Z |
5556876 | 5556876 | 20241119022808_Gnmn5 | US001L | 2024-11-20T14:11:36.295Z | 2024-11-22T14:22:20.548Z |
5551152 | 5551152 | 20241118123342_gnsqM | US001L | 2024-11-19T14:04:00.071Z | 2024-11-22T14:22:08.740Z |
5550841 | 5550841 | 20241118113443_arkXA | US001L | 2024-11-19T14:03:11.847Z | 2024-11-22T14:22:06.098Z |
5548808 | 5548808 | 20241117014706_3COvg | US001L | 2024-11-18T14:10:15.069Z | 2024-11-22T14:23:15.936Z |
5548695 | 5548695 | 20241117011100_AOXr8 | US001L | 2024-11-18T14:09:58.158Z | 2024-11-22T14:23:15.189Z |
5546729 | 5546729 | 20241117122921_zazr8 | US001L | 2024-11-18T14:04:01.833Z | 2024-11-22T14:22:34.292Z |
5546425 | 5546425 | 20241117105256_s96CO | US001L | 2024-11-18T14:03:05.183Z | 2024-11-22T14:22:31.955Z |
5545961 | 5545961 | 20241117081908_de7uJ | US001L | 2024-11-18T14:01:34.208Z | 2024-11-22T14:22:27.580Z |
5544536 | 5544536 | 20241116121805_lA5Md | US001L | 2024-11-17T14:01:29.835Z | 2024-11-22T14:23:03.967Z |
5544534 | 5544534 | 20241116121758_Za2O9 | US001L | 2024-11-17T14:01:29.541Z | 2024-11-22T14:23:03.965Z |
5544470 | 5544470 | 20241116113950_EjvQo | US001L | 2024-11-17T14:01:15.437Z | 2024-11-22T14:23:03.216Z |
5544190 | 5544190 | 20241116075328_cBSj7 | US001L | 2024-11-17T14:00:25.583Z | 2024-11-22T14:23:00.547Z |
5543596 | 5543596 | 20241115022415_NskU0 | US001L | 2024-11-16T14:06:53.770Z | 2024-11-22T14:24:00.238Z |
5542792 | 5542792 | 20241115123706_t37Op | US001L | 2024-11-16T14:02:33.762Z | 2024-11-22T14:23:31.096Z |
5542779 | 5542779 | 20241115122615_9zuLn | US001L | 2024-11-16T14:02:32.591Z | 2024-11-22T14:23:31.069Z |
5542718 | 5542718 | 20241115120336_1af2K | US001L | 2024-11-16T14:02:15.737Z | 2024-11-22T14:23:30.629Z |
5542698 | 5542698 | 20241115115336_w2Vpm | US001L | 2024-11-16T14:02:13.319Z | 2024-11-22T14:23:30.336Z |
5542666 | 5542666 | 20241115114318_0LF71 | US001L | 2024-11-16T14:02:09.337Z | 2024-11-22T14:23:30.051Z |
5542521 | 5542521 | 20241115103708_oPCDc | US001L | 2024-11-16T14:01:34.870Z | 2024-11-22T14:23:26.742Z |
5542415 | 5542415 | 20241115092158_7RVU2 | US001L | 2024-11-16T14:01:13.202Z | 2024-11-22T14:23:25.864Z |
5542412 | 5542412 | 20241115091909_hiUwO | US001L | 2024-11-16T14:01:12.912Z | 2024-11-22T14:23:25.854Z |
5542359 | 5542359 | 20241115085346_S5Qx8 | US001L | 2024-11-16T14:01:03.206Z | 2024-11-22T14:23:25.326Z |
5542312 | 5542312 | 20241115082327_H99Aa | US001L | 2024-11-16T14:00:57.143Z | 2024-11-22T14:23:25.155Z |
5542284 | 5542284 | 20241115075937_Wzaq5 | US001L | 2024-11-16T14:00:53.905Z | 2024-11-22T14:23:24.892Z |
5542268 | 5542268 | 20241115075108_wome7 | US001L | 2024-11-16T14:00:51.113Z | 2024-11-22T14:23:24.778Z |
5542266 | 5542266 | 20241115074847_Uv3gL | US001L | 2024-11-16T14:00:50.720Z | 2024-11-22T14:23:24.760Z |
5542219 | 5542219 | 20241115071815_Lsj7K | US001L | 2024-11-16T14:00:42.431Z | 2024-11-22T14:23:24.175Z |
5540998 | 5540998 | 20241114124222_VNsGI | US001L | 2024-11-15T14:04:54.906Z | 2024-11-22T14:23:54.159Z |
5540851 | 5540851 | 20241114121451_PdvAY | US001L | 2024-11-15T14:04:34.739Z | 2024-11-22T14:23:52.905Z |
5540798 | 5540798 | 20241114120720_fH8D8 | US001L | 2024-11-15T14:04:29.336Z | 2024-11-22T14:23:52.729Z |
5540797 | 5540797 | 20241114120601_Q5Bk4 | US001L | 2024-11-15T14:04:28.811Z | 2024-11-22T14:23:52.727Z |
5540761 | 5540761 | 20241114120326_S62gV | US001L | 2024-11-15T14:04:25.765Z | 2024-11-22T14:23:52.629Z |
5540621 | 5540621 | 20241114114130_QTN0o | US001L | 2024-11-15T14:04:10.442Z | 2024-11-22T14:23:51.830Z |
5540559 | 5540559 | 20241114113118_5atCl | US001L | 2024-11-15T14:04:02.892Z | 2024-11-22T14:23:51.559Z |
5540552 | 5540552 | 20241114112817_6gPKO | US001L | 2024-11-15T14:04:02.015Z | 2024-11-22T14:23:51.542Z |
5540400 | 5540400 | 20241114105559_JL3qq | US001L | 2024-11-15T14:03:36.022Z | 2024-11-22T14:23:50.770Z |
5540340 | 5540340 | 20241114103840_Csimn | US001L | 2024-11-15T14:03:27.905Z | 2024-11-22T14:23:50.498Z |
5540225 | 5540225 | 20241114102431_mTuZS | US001L | 2024-11-15T14:03:09.386Z | 2024-11-22T14:23:50.014Z |
5540217 | 5540217 | 20241114102355_EoTBJ | US001L | 2024-11-15T14:03:08.722Z | 2024-11-22T14:23:50.003Z |
5540175 | 5540175 | 20241114101736_mA3Fj | US001L | 2024-11-15T14:03:04.206Z | 2024-11-22T14:23:49.353Z |
5540144 | 5540144 | 20241114101453_rz2Gr | US001L | 2024-11-15T14:03:01.503Z | 2024-11-22T14:23:49.263Z |
5540091 | 5540091 | 20241114100737_HduCh | US001L | 2024-11-15T14:02:56.020Z | 2024-11-22T14:23:49.060Z |
5540072 | 5540072 | 20241114100123_nP99Y | US001L | 2024-11-15T14:02:50.671Z | 2024-11-22T14:23:48.911Z |
5540017 | 5540017 | 20241114094940_m1JOH | US001L | 2024-11-15T14:02:32.973Z | 2024-11-22T14:23:47.901Z |
5539997 | 5539997 | 20241114094700_IfTGE | US001L | 2024-11-15T14:02:30.517Z | 2024-11-22T14:23:47.738Z |
5539671 | 5539671 | 20241114083205_3dh9E | US001L | 2024-11-15T14:01:39.295Z | 2024-11-22T14:23:45.715Z |
5538695 | 5538695 | 20241113043812_sx2lt | US001L | 2024-11-14T14:13:49.921Z | 2024-11-21T14:26:28.538Z |
5538050 | 5538050 | 20241113020348_3ug3j | US001L | 2024-11-14T14:12:47.672Z | 2024-11-21T14:26:19.818Z |
5535486 | 5535486 | 20241112123743_ABHDl | US001L | 2024-11-14T14:07:59.643Z | 2024-11-21T14:25:48.628Z |
5535129 | 5535129 | 20241112114135_bvNsL | US001L | 2024-11-14T14:07:17.331Z | 2024-11-21T14:25:44.091Z |
5535052 | 5535052 | 20241112112909_TxQcJ | US001L | 2024-11-14T14:07:08.879Z | 2024-11-21T14:25:43.374Z |
5534935 | 5534935 | 20241112111204_5dPDn | US001L | 2024-11-14T14:07:00.507Z | 2024-11-21T14:25:41.758Z |
5534590 | 5534590 | 20241113125154_hUNrk | US001L | 2024-11-14T14:04:38.767Z | 2024-11-22T14:24:14.709Z |
5534519 | 5534519 | 20241113122940_54jjj | US001L | 2024-11-14T14:04:31.214Z | 2024-11-22T14:24:14.397Z |
5534345 | 5534345 | 20241113114845_dTGLV | US001L | 2024-11-14T14:04:17.459Z | 2024-11-22T14:24:13.523Z |
5534123 | 5534123 | 20241113110257_0j46u | US001L | 2024-11-14T14:03:37.599Z | 2024-11-22T14:24:12.466Z |
5534116 | 5534116 | 20241113110135_UZAd2 | US001L | 2024-11-14T14:03:35.121Z | 2024-11-22T14:24:12.385Z |
5534083 | 5534083 | 20241113105607_IO0sy | US001L | 2024-11-14T14:03:32.225Z | 2024-11-22T14:24:12.203Z |
5533871 | 5533871 | 20241113102153_qskJd | US001L | 2024-11-14T14:03:07.904Z | 2024-11-22T14:24:11.580Z |
5533791 | 5533791 | 20241113100904_2JLFn | US001L | 2024-11-14T14:02:49.463Z | 2024-11-22T14:24:11.318Z |
5533634 | 5533634 | 20241113093655_PKh50 | US001L | 2024-11-14T14:02:32.906Z | 2024-11-22T14:24:10.557Z |
5533610 | 5533610 | 20241113093259_5MZif | US001L | 2024-11-14T14:02:30.394Z | 2024-11-22T14:24:10.444Z |
5533583 | 5533583 | 20241113092545_MbVyR | US001L | 2024-11-14T14:02:27.291Z | 2024-11-22T14:24:10.312Z |
5533578 | 5533578 | 20241113092424_IlRxj | US001L | 2024-11-14T14:02:26.578Z | 2024-11-22T14:24:10.293Z |
5533473 | 5533473 | 20241113090604_YypLc | US001L | 2024-11-14T14:02:05.384Z | 2024-11-22T14:24:09.561Z |
5533424 | 5533424 | 20241113085420_t3hJJ | US001L | 2024-11-14T14:01:56.294Z | 2024-11-22T14:24:09.243Z |
5533357 | 5533357 | 20241113084217_GD52A | US001L | 2024-11-14T14:01:47.004Z | 2024-11-22T14:24:08.714Z |
5533263 | 5533263 | 20241113081131_B38Dw | US001L | 2024-11-14T14:01:37.794Z | 2024-11-22T14:24:07.852Z |
5533180 | 5533180 | 20241113074209_l62Py | US001L | 2024-11-14T14:01:19.422Z | 2024-11-22T14:24:07.528Z |
5532938 | 5532938 | 20241113061926_LpuTd | US001L | 2024-11-14T14:00:35.345Z | 2024-11-22T14:24:06.163Z |
5532444 | 5532444 | 20241112052433_mOeGY | US001L | 2024-11-13T14:16:48.573Z | 2024-11-20T14:26:23.472Z |
5532331 | 5532331 | 20241112050846_SJM3d | US001L | 2024-11-13T14:16:37.391Z | 2024-11-20T14:26:22.084Z |
5527102 | 5527102 | 20241112105951_x2h5b | US001L | 2024-11-13T14:05:01.699Z | 2024-11-21T14:25:41.295Z |
5527071 | 5527071 | 20241112105654_wZ3bL | US001L | 2024-11-13T14:04:58.879Z | 2024-11-21T14:25:41.001Z |
5527039 | 5527039 | 20241112105057_MKvyB | US001L | 2024-11-13T14:04:54.418Z | 2024-11-21T14:25:40.770Z |
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);