participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "USL00M" 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 |
---|---|---|---|---|---|
5573170 | 5573170 | 20241121040146_U3Klz | USL00M | 2024-11-22T14:19:13.729Z | 2024-11-22T14:19:22.462Z |
5573080 | 5573080 | 20241121035000_V9xut | USL00M | 2024-11-22T14:19:09.007Z | 2024-11-22T14:19:22.446Z |
5573064 | 5573064 | 20241121034654_Mt5Mb | USL00M | 2024-11-22T14:19:08.019Z | 2024-11-22T14:19:22.443Z |
5573040 | 5573040 | 20241121034304_qFv0s | USL00M | 2024-11-22T14:19:06.908Z | 2024-11-22T14:19:22.438Z |
5572713 | 5572713 | 20241121030101_bZsqy | USL00M | 2024-11-22T14:18:45.169Z | 2024-11-22T14:19:22.378Z |
5572520 | 5572520 | 20241121023146_I95AU | USL00M | 2024-11-22T14:18:31.914Z | 2024-11-22T14:19:22.343Z |
5572498 | 5572498 | 20241121022855_KeUC4 | USL00M | 2024-11-22T14:18:30.205Z | 2024-11-22T14:19:22.339Z |
5572486 | 5572486 | 20241121022730_7KKpm | USL00M | 2024-11-22T14:18:29.522Z | 2024-11-22T14:19:22.337Z |
5572147 | 5572147 | 20241121014102_Atjpg | USL00M | 2024-11-22T14:18:01.443Z | 2024-11-22T14:19:22.268Z |
5568300 | 5568300 | 20241121122042_rNu2p | USL00M | 2024-11-22T14:08:39.948Z | 2024-11-22T14:08:39.948Z |
5568280 | 5568280 | 20241121121714_kT6fP | USL00M | 2024-11-22T14:08:38.183Z | 2024-11-22T14:08:38.183Z |
5568066 | 5568066 | 20241121114559_3Ime9 | USL00M | 2024-11-22T14:08:02.580Z | 2024-11-22T14:08:02.580Z |
5568034 | 5568034 | 20241121114230_Dn7LD | USL00M | 2024-11-22T14:07:58.669Z | 2024-11-22T14:07:58.669Z |
5567956 | 5567956 | 20241121113552_rydiC | USL00M | 2024-11-22T14:07:51.480Z | 2024-11-22T14:07:51.480Z |
5567835 | 5567835 | 20241121111655_Wz4n0 | USL00M | 2024-11-22T14:07:21.756Z | 2024-11-22T14:07:21.756Z |
5567828 | 5567828 | 20241121111624_gT16t | USL00M | 2024-11-22T14:07:21.003Z | 2024-11-22T14:07:21.003Z |
5567657 | 5567657 | 20241121104917_PyC5O | USL00M | 2024-11-22T14:06:46.247Z | 2024-11-22T14:06:46.247Z |
5567542 | 5567542 | 20241121103315_hIjyG | USL00M | 2024-11-22T14:06:28.949Z | 2024-11-22T14:06:28.949Z |
5567497 | 5567497 | 20241121102843_WzvDV | USL00M | 2024-11-22T14:06:24.486Z | 2024-11-22T14:06:24.486Z |
5567436 | 5567436 | 20241121101758_2BqXh | USL00M | 2024-11-22T14:06:16.381Z | 2024-11-22T14:06:16.381Z |
5567413 | 5567413 | 20241121101414_bZm6E | USL00M | 2024-11-22T14:06:12.709Z | 2024-11-22T14:06:12.709Z |
5567346 | 5567346 | 20241121100406_oH2UF | USL00M | 2024-11-22T14:05:57.032Z | 2024-11-22T14:05:57.032Z |
5567234 | 5567234 | 20241121094644_x13x7 | USL00M | 2024-11-22T14:05:38.810Z | 2024-11-22T14:05:38.810Z |
5567205 | 5567205 | 20241121094052_ULWjJ | USL00M | 2024-11-22T14:05:34.217Z | 2024-11-22T14:05:34.217Z |
5567136 | 5567136 | 20241121093209_aKMxT | USL00M | 2024-11-22T14:05:26.214Z | 2024-11-22T14:05:26.214Z |
5567103 | 5567103 | 20241121092248_p9aT4 | USL00M | 2024-11-22T14:05:14.845Z | 2024-11-22T14:05:14.845Z |
5567072 | 5567072 | 20241121090941_k5Yt3 | USL00M | 2024-11-22T14:05:03.245Z | 2024-11-22T14:05:03.245Z |
5567043 | 5567043 | 20241121090004_8vv2W | USL00M | 2024-11-22T14:04:57.836Z | 2024-11-22T14:04:57.836Z |
5567030 | 5567030 | 20241121085816_GKKiS | USL00M | 2024-11-22T14:04:55.470Z | 2024-11-22T14:04:55.470Z |
5566960 | 5566960 | 20241121084918_Td3AU | USL00M | 2024-11-22T14:04:45.870Z | 2024-11-22T14:04:45.870Z |
5566911 | 5566911 | 20241121083618_iQw2i | USL00M | 2024-11-22T14:04:28.545Z | 2024-11-22T14:04:28.545Z |
5566863 | 5566863 | 20241121081925_9BGVW | USL00M | 2024-11-22T14:04:18.702Z | 2024-11-22T14:04:18.702Z |
5566856 | 5566856 | 20241121081702_MhLEm | USL00M | 2024-11-22T14:04:17.716Z | 2024-11-22T14:04:17.716Z |
5566850 | 5566850 | 20241121081432_Ibja2 | USL00M | 2024-11-22T14:04:17.104Z | 2024-11-22T14:04:17.104Z |
5566716 | 5566716 | 20241121073123_RiXGJ | USL00M | 2024-11-22T14:03:44.029Z | 2024-11-22T14:03:44.029Z |
5566598 | 5566598 | 20241121065613_UPM3I | USL00M | 2024-11-22T14:03:22.473Z | 2024-11-22T14:03:22.473Z |
5566559 | 5566559 | 20241121063907_AH9X2 | USL00M | 2024-11-22T14:03:10.872Z | 2024-11-22T14:03:10.872Z |
5566477 | 5566477 | 20241121062031_ITRlU | USL00M | 2024-11-22T14:02:58.830Z | 2024-11-22T14:02:58.830Z |
5566460 | 5566460 | 20241121061549_e5rLm | USL00M | 2024-11-22T14:02:56.800Z | 2024-11-22T14:02:56.800Z |
5566371 | 5566371 | 20241121060520_264Ut | USL00M | 2024-11-22T14:02:35.236Z | 2024-11-22T14:02:35.236Z |
5566115 | 5566115 | 20241121053422_32dvy | USL00M | 2024-11-22T14:01:51.650Z | 2024-11-22T14:01:51.650Z |
5566091 | 5566091 | 20241121053128_WGMoY | USL00M | 2024-11-22T14:01:47.856Z | 2024-11-22T14:01:47.856Z |
5565773 | 5565773 | 20241121044358_3idQU | USL00M | 2024-11-22T14:00:54.548Z | 2024-11-22T14:00:54.548Z |
5565758 | 5565758 | 20241121044159_79l5T | USL00M | 2024-11-22T14:00:52.895Z | 2024-11-22T14:00:52.895Z |
5565653 | 5565653 | 20241121043154_9mWaG | USL00M | 2024-11-22T14:00:35.839Z | 2024-11-22T14:00:35.839Z |
5565514 | 5565514 | 20241121041830_BXG2W | USL00M | 2024-11-22T14:00:09.222Z | 2024-11-22T14:00:09.222Z |
5565411 | 5565411 | 20241120042343_fp3m0 | USL00M | 2024-11-21T14:18:48.332Z | 2024-11-22T14:21:46.540Z |
5565226 | 5565226 | 20241120040538_WIYzn | USL00M | 2024-11-21T14:18:42.789Z | 2024-11-22T14:21:44.347Z |
5565220 | 5565220 | 20241120040505_fdZmU | USL00M | 2024-11-21T14:18:41.734Z | 2024-11-22T14:21:44.145Z |
5565107 | 5565107 | 20241120035207_mcynr | USL00M | 2024-11-21T14:18:31.007Z | 2024-11-22T14:21:41.784Z |
5565071 | 5565071 | 20241120035006_GUjWS | USL00M | 2024-11-21T14:18:28.319Z | 2024-11-22T14:21:41.331Z |
5563988 | 5563988 | 20241120022047_FW0pE | USL00M | 2024-11-21T14:17:02.569Z | 2024-11-22T14:21:26.013Z |
5563799 | 5563799 | 20241120020437_yUFAA | USL00M | 2024-11-21T14:16:44.188Z | 2024-11-22T14:21:23.389Z |
5563695 | 5563695 | 20241120015741_F0P43 | USL00M | 2024-11-21T14:16:34.782Z | 2024-11-22T14:21:21.150Z |
5563538 | 5563538 | 20241120013927_4hnya | USL00M | 2024-11-21T14:16:15.989Z | 2024-11-22T14:21:17.848Z |
5560520 | 5560520 | 20241120130647_OePeb | USL00M | 2024-11-21T14:09:01.049Z | 2024-11-22T14:19:21.678Z |
5560442 | 5560442 | 20241120125210_q223g | USL00M | 2024-11-21T14:08:52.193Z | 2024-11-22T14:19:21.659Z |
5560268 | 5560268 | 20241120122904_GPk3l | USL00M | 2024-11-21T14:08:27.120Z | 2024-11-22T14:19:21.625Z |
5560261 | 5560261 | 20241120122653_PQAgY | USL00M | 2024-11-21T14:08:26.149Z | 2024-11-22T14:19:21.623Z |
5560231 | 5560231 | 20241120122050_Wg72H | USL00M | 2024-11-21T14:08:20.237Z | 2024-11-22T14:19:21.616Z |
5560212 | 5560212 | 20241120121829_tKoQK | USL00M | 2024-11-21T14:08:17.301Z | 2024-11-22T14:19:21.613Z |
5560062 | 5560062 | 20241120115308_Wod0O | USL00M | 2024-11-21T14:07:57.748Z | 2024-11-22T14:19:21.578Z |
5560053 | 5560053 | 20241120115144_noqZo | USL00M | 2024-11-21T14:07:56.346Z | 2024-11-22T14:19:21.576Z |
5560010 | 5560010 | 20241120114605_cZIxp | USL00M | 2024-11-21T14:07:51.521Z | 2024-11-22T14:19:21.568Z |
5559938 | 5559938 | 20241120113604_AIPQO | USL00M | 2024-11-21T14:07:36.707Z | 2024-11-22T14:19:21.553Z |
5559615 | 5559615 | 20241120104922_negQB | USL00M | 2024-11-21T14:06:44.104Z | 2024-11-22T14:19:21.485Z |
5559351 | 5559351 | 20241120100808_FjgEn | USL00M | 2024-11-21T14:06:04.336Z | 2024-11-22T14:19:21.424Z |
5559333 | 5559333 | 20241120100525_IU83O | USL00M | 2024-11-21T14:06:00.536Z | 2024-11-22T14:19:21.419Z |
5559221 | 5559221 | 20241120093956_UpMxN | USL00M | 2024-11-21T14:05:38.374Z | 2024-11-22T14:19:21.390Z |
5559012 | 5559012 | 20241120090453_ZcLk9 | USL00M | 2024-11-21T14:05:02.393Z | 2024-11-22T14:19:21.347Z |
5558736 | 5558736 | 20241120075304_yy1Cm | USL00M | 2024-11-21T14:04:13.017Z | 2024-11-22T14:19:21.291Z |
5558606 | 5558606 | 20241120065921_qhtSM | USL00M | 2024-11-21T14:03:48.227Z | 2024-11-22T14:19:21.261Z |
5558589 | 5558589 | 20241120064653_utnB7 | USL00M | 2024-11-21T14:03:45.724Z | 2024-11-22T14:19:21.257Z |
5558311 | 5558311 | 20241120055457_C3ypp | USL00M | 2024-11-21T14:02:59.607Z | 2024-11-22T14:19:21.208Z |
5558081 | 5558081 | 20241120053547_aBBsc | USL00M | 2024-11-21T14:02:28.946Z | 2024-11-22T14:19:21.176Z |
5557722 | 5557722 | 20241120050754_stRD4 | USL00M | 2024-11-21T14:01:35.399Z | 2024-11-22T14:19:21.117Z |
5557324 | 5557324 | 20241120043928_4ZChK | USL00M | 2024-11-21T14:00:32.653Z | 2024-11-22T14:19:21.054Z |
5557264 | 5557264 | 20241120043159_2W0kR | USL00M | 2024-11-21T14:00:18.655Z | 2024-11-22T14:19:21.040Z |
5556935 | 5556935 | 20241119025736_tj7Ii | USL00M | 2024-11-20T14:11:42.804Z | 2024-11-22T14:22:20.985Z |
5556854 | 5556854 | 20241119021836_aWYcQ | USL00M | 2024-11-20T14:11:34.293Z | 2024-11-22T14:22:20.395Z |
5556755 | 5556755 | 20241119014354_XQAKj | USL00M | 2024-11-20T14:11:25.612Z | 2024-11-22T14:22:19.739Z |
5555336 | 5555336 | 20241119124834_3uP8n | USL00M | 2024-11-20T14:05:13.430Z | 2024-11-22T14:20:04.335Z |
5555268 | 5555268 | 20241119122646_bXKnF | USL00M | 2024-11-20T14:05:03.221Z | 2024-11-22T14:20:02.580Z |
5555067 | 5555067 | 20241119113217_bSwZd | USL00M | 2024-11-20T14:04:22.691Z | 2024-11-22T14:19:56.713Z |
5554984 | 5554984 | 20241119111535_JhcM4 | USL00M | 2024-11-20T14:04:00.047Z | 2024-11-22T14:19:54.906Z |
5554891 | 5554891 | 20241119105554_tIkBJ | USL00M | 2024-11-20T14:03:44.205Z | 2024-11-22T14:19:53.314Z |
5554861 | 5554861 | 20241119105046_TJX2R | USL00M | 2024-11-20T14:03:39.142Z | 2024-11-22T14:19:52.732Z |
5554665 | 5554665 | 20241119100207_2HqqY | USL00M | 2024-11-20T14:02:58.284Z | 2024-11-22T14:19:48.563Z |
5554611 | 5554611 | 20241119094805_USGXg | USL00M | 2024-11-20T14:02:40.028Z | 2024-11-22T14:19:45.544Z |
5554602 | 5554602 | 20241119094657_F6OEw | USL00M | 2024-11-20T14:02:36.486Z | 2024-11-22T14:19:45.197Z |
5554589 | 5554589 | 20241119094243_HySlS | USL00M | 2024-11-20T14:02:33.267Z | 2024-11-22T14:19:44.588Z |
5554555 | 5554555 | 20241119093528_1APF3 | USL00M | 2024-11-20T14:02:26.735Z | 2024-11-22T14:19:43.774Z |
5554548 | 5554548 | 20241119093218_wH9Kw | USL00M | 2024-11-20T14:02:25.247Z | 2024-11-22T14:19:43.463Z |
5554461 | 5554461 | 20241119090854_E6ML9 | USL00M | 2024-11-20T14:02:13.936Z | 2024-11-22T14:19:41.295Z |
5554433 | 5554433 | 20241119085855_bWZ4Z | USL00M | 2024-11-20T14:02:02.613Z | 2024-11-22T14:19:40.618Z |
5554404 | 5554404 | 20241119084603_TDjo2 | USL00M | 2024-11-20T14:01:55.709Z | 2024-11-22T14:19:39.902Z |
5554381 | 5554381 | 20241119083756_KU49f | USL00M | 2024-11-20T14:01:49.295Z | 2024-11-22T14:19:38.836Z |
5554373 | 5554373 | 20241119083522_KSScR | USL00M | 2024-11-20T14:01:47.852Z | 2024-11-22T14:19:38.750Z |
5554330 | 5554330 | 20241119081714_klnuP | USL00M | 2024-11-20T14:01:40.681Z | 2024-11-22T14:19:37.326Z |
5554260 | 5554260 | 20241119073153_5m5yg | USL00M | 2024-11-20T14:01:15.746Z | 2024-11-22T14:19:34.391Z |
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);