participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "US0004" 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 |
---|---|---|---|---|---|
5586255 | 5586255 | 20241123113929_CFWic | US0004 | 2024-11-24T14:07:21.708Z | 2024-11-24T14:07:21.708Z |
5585765 | 5585765 | 20241123100921_HSdtI | US0004 | 2024-11-24T14:06:05.230Z | 2024-11-24T14:06:05.230Z |
5585095 | 5585095 | 20241123074128_stWYk | US0004 | 2024-11-24T14:03:30.702Z | 2024-11-24T14:03:30.702Z |
5584953 | 5584953 | 20241123070149_skWYS | US0004 | 2024-11-24T14:03:05.742Z | 2024-11-24T14:03:05.742Z |
5584733 | 5584733 | 20241123060552_h5N2G | US0004 | 2024-11-24T14:02:16.683Z | 2024-11-24T14:02:16.683Z |
5584453 | 5584453 | 20241123044105_AIwaq | US0004 | 2024-11-24T14:01:06.731Z | 2024-11-24T14:01:06.731Z |
5583918 | 5583918 | 20241119032841_tVFjg | US0004 | 2024-11-23T14:25:09.768Z | 2024-11-24T14:25:05.471Z |
5583332 | 5583332 | 20241119071354_665yi | US0004 | 2024-11-23T14:24:00.232Z | 2024-11-24T14:24:09.425Z |
5577098 | 5577098 | 20241121083921_L6itc | US0004 | 2024-11-23T14:12:39.092Z | 2024-11-24T14:21:40.879Z |
5577073 | 5577073 | 20241121061154_OEgWU | US0004 | 2024-11-23T14:12:07.779Z | 2024-11-24T14:21:31.563Z |
5577069 | 5577069 | 20241121054618_E3D54 | US0004 | 2024-11-23T14:11:53.275Z | 2024-11-24T14:21:28.082Z |
5576651 | 5576651 | 20241122124538_fTfcB | US0004 | 2024-11-23T14:10:00.000Z | 2024-11-24T14:21:10.726Z |
5576588 | 5576588 | 20241122123645_83XT1 | US0004 | 2024-11-23T14:09:52.881Z | 2024-11-24T14:21:10.709Z |
5576555 | 5576555 | 20241122123031_QJKDw | US0004 | 2024-11-23T14:09:49.408Z | 2024-11-24T14:21:10.701Z |
5576509 | 5576509 | 20241122122245_JYIHE | US0004 | 2024-11-23T14:09:41.235Z | 2024-11-24T14:21:10.687Z |
5576337 | 5576337 | 20241122114927_afp9c | US0004 | 2024-11-23T14:09:15.537Z | 2024-11-24T14:21:10.633Z |
5576098 | 5576098 | 20241122111508_lSuJ7 | US0004 | 2024-11-23T14:08:34.323Z | 2024-11-24T14:21:10.558Z |
5576005 | 5576005 | 20241122110158_LSNbR | US0004 | 2024-11-23T14:08:15.345Z | 2024-11-24T14:21:10.532Z |
5575975 | 5575975 | 20241122105432_NmdMk | US0004 | 2024-11-23T14:08:11.888Z | 2024-11-24T14:21:10.523Z |
5575898 | 5575898 | 20241122104333_8iymU | US0004 | 2024-11-23T14:08:00.438Z | 2024-11-24T14:21:10.501Z |
5575867 | 5575867 | 20241122103526_B2hYg | US0004 | 2024-11-23T14:07:56.052Z | 2024-11-24T14:21:10.482Z |
5575823 | 5575823 | 20241122102453_NTUwg | US0004 | 2024-11-23T14:07:42.338Z | 2024-11-24T14:21:10.465Z |
5575708 | 5575708 | 20241122100345_azddy | US0004 | 2024-11-23T14:07:22.838Z | 2024-11-24T14:21:10.412Z |
5575643 | 5575643 | 20241122095452_xrRC3 | US0004 | 2024-11-23T14:07:06.519Z | 2024-11-24T14:21:10.387Z |
5575579 | 5575579 | 20241122094430_KMlyt | US0004 | 2024-11-23T14:06:51.143Z | 2024-11-24T14:21:10.367Z |
5574870 | 5574870 | 20241122065141_bEM8i | US0004 | 2024-11-23T14:04:42.492Z | 2024-11-24T14:21:10.150Z |
5574859 | 5574859 | 20241122064935_QAUhA | US0004 | 2024-11-23T14:04:40.731Z | 2024-11-24T14:21:10.148Z |
5572731 | 5572731 | 20241121030329_Sm71L | US0004 | 2024-11-22T14:18:46.760Z | 2024-11-24T14:23:58.461Z |
5572685 | 5572685 | 20241121025706_XzIgg | US0004 | 2024-11-22T14:18:42.449Z | 2024-11-24T14:23:58.025Z |
5572423 | 5572423 | 20241121022020_pgW5b | US0004 | 2024-11-22T14:18:25.437Z | 2024-11-24T14:23:55.409Z |
5568325 | 5568325 | 20241121122457_e8qHp | US0004 | 2024-11-22T14:08:43.808Z | 2024-11-24T14:22:02.051Z |
5568311 | 5568311 | 20241121122215_bWZ0s | US0004 | 2024-11-22T14:08:41.064Z | 2024-11-24T14:22:01.784Z |
5567852 | 5567852 | 20241121111926_zwIsD | US0004 | 2024-11-22T14:07:25.164Z | 2024-11-24T14:21:55.704Z |
5567683 | 5567683 | 20241121105214_6jkLT | US0004 | 2024-11-22T14:06:54.141Z | 2024-11-24T14:21:52.888Z |
5567525 | 5567525 | 20241121103206_5f5iO | US0004 | 2024-11-22T14:06:27.319Z | 2024-11-24T14:21:50.833Z |
5567500 | 5567500 | 20241121102911_SFXID | US0004 | 2024-11-22T14:06:24.890Z | 2024-11-24T14:21:50.559Z |
5567454 | 5567454 | 20241121102127_w3ysi | US0004 | 2024-11-22T14:06:19.068Z | 2024-11-24T14:21:49.785Z |
5567400 | 5567400 | 20241121101054_5tpGP | US0004 | 2024-11-22T14:06:07.915Z | 2024-11-24T14:21:48.955Z |
5567318 | 5567318 | 20241121100243_LSHqi | US0004 | 2024-11-22T14:05:52.856Z | 2024-11-24T14:21:47.953Z |
5567284 | 5567284 | 20241121095757_L5BG2 | US0004 | 2024-11-22T14:05:46.220Z | 2024-11-24T14:21:47.535Z |
5566979 | 5566979 | 20241121085321_faKbT | US0004 | 2024-11-22T14:04:49.276Z | 2024-11-24T14:21:41.828Z |
5566881 | 5566881 | 20241121082414_zHQhM | US0004 | 2024-11-22T14:04:21.774Z | 2024-11-24T14:21:40.191Z |
5566843 | 5566843 | 20241121081219_Ed3YR | US0004 | 2024-11-22T14:04:15.752Z | 2024-11-24T14:21:39.287Z |
5566653 | 5566653 | 20241121071035_kCXaX | US0004 | 2024-11-22T14:03:33.906Z | 2024-11-24T14:21:35.970Z |
5566546 | 5566546 | 20241121063357_t2iUl | US0004 | 2024-11-22T14:03:09.872Z | 2024-11-24T14:21:33.765Z |
5566412 | 5566412 | 20241121061040_eEy4g | US0004 | 2024-11-22T14:02:51.831Z | 2024-11-24T14:21:31.355Z |
5560214 | 5560214 | 20241120121926_3uiqk | US0004 | 2024-11-21T14:08:17.988Z | 2024-11-24T14:23:17.042Z |
5560147 | 5560147 | 20241120120801_Pw7CK | US0004 | 2024-11-21T14:08:07.755Z | 2024-11-24T14:23:16.042Z |
5559966 | 5559966 | 20241120113949_IFWsQ | US0004 | 2024-11-21T14:07:42.590Z | 2024-11-24T14:23:12.995Z |
5559782 | 5559782 | 20241120111713_Q9xRR | US0004 | 2024-11-21T14:07:11.144Z | 2024-11-24T14:23:10.311Z |
5559676 | 5559676 | 20241120105735_S3zXY | US0004 | 2024-11-21T14:06:56.880Z | 2024-11-24T14:23:08.842Z |
5559411 | 5559411 | 20241120102016_eZ4KZ | US0004 | 2024-11-21T14:06:16.427Z | 2024-11-24T14:23:06.230Z |
5558915 | 5558915 | 20241120085000_vMPA2 | US0004 | 2024-11-21T14:04:48.333Z | 2024-11-24T14:22:57.989Z |
5558783 | 5558783 | 20241120080125_G6WAl | US0004 | 2024-11-21T14:04:21.930Z | 2024-11-24T14:22:56.378Z |
5558766 | 5558766 | 20241120075903_MHTYq | US0004 | 2024-11-21T14:04:18.898Z | 2024-11-24T14:22:56.216Z |
5558640 | 5558640 | 20241120071542_sIkKk | US0004 | 2024-11-21T14:03:55.541Z | 2024-11-24T14:22:53.979Z |
5558591 | 5558591 | 20241120064844_fBm5z | US0004 | 2024-11-21T14:03:46.169Z | 2024-11-24T14:22:52.969Z |
5558201 | 5558201 | 20241120054507_2D26O | US0004 | 2024-11-21T14:02:43.476Z | 2024-11-24T14:22:48.932Z |
5558110 | 5558110 | 20241120053754_i8zD5 | US0004 | 2024-11-21T14:02:32.201Z | 2024-11-24T14:22:48.283Z |
5557878 | 5557878 | 20241120052146_VqhJE | US0004 | 2024-11-21T14:01:59.974Z | 2024-11-24T14:22:45.611Z |
5557784 | 5557784 | 20241120051129_oYbgh | US0004 | 2024-11-21T14:01:45.166Z | 2024-11-24T14:22:44.952Z |
5557076 | 5557076 | 20241119034634_FKnuQ | US0004 | 2024-11-20T14:12:12.856Z | 2024-11-24T14:25:05.779Z |
5557017 | 5557017 | 20241119032416_q1l4H | US0004 | 2024-11-20T14:12:00.482Z | 2024-11-24T14:25:05.408Z |
5556780 | 5556780 | 20241119014850_8mG68 | US0004 | 2024-11-20T14:11:27.647Z | 2024-11-24T14:25:03.917Z |
5554953 | 5554953 | 20241119111031_iEX4N | US0004 | 2024-11-20T14:03:53.344Z | 2024-11-24T14:24:15.068Z |
5554851 | 5554851 | 20241119105033_X9Hbk | US0004 | 2024-11-20T14:03:33.489Z | 2024-11-24T14:24:13.738Z |
5554778 | 5554778 | 20241119103717_88xEX | US0004 | 2024-11-20T14:03:16.460Z | 2024-11-24T14:24:13.382Z |
5554463 | 5554463 | 20241119090920_mWNQs | US0004 | 2024-11-20T14:02:14.310Z | 2024-11-24T14:24:11.428Z |
5554436 | 5554436 | 20241119085939_bHrd0 | US0004 | 2024-11-20T14:02:03.426Z | 2024-11-24T14:24:11.023Z |
5554414 | 5554414 | 20241119084808_FKShj | US0004 | 2024-11-20T14:01:58.432Z | 2024-11-24T14:24:10.712Z |
5554345 | 5554345 | 20241119082335_dZcKy | US0004 | 2024-11-20T14:01:43.817Z | 2024-11-24T14:24:10.178Z |
5554244 | 5554244 | 20241119072414_pB6Y3 | US0004 | 2024-11-20T14:01:14.253Z | 2024-11-24T14:24:09.530Z |
5554198 | 5554198 | 20241119070518_luF2z | US0004 | 2024-11-20T14:01:05.567Z | 2024-11-24T14:24:08.628Z |
5554036 | 5554036 | 20241119054002_CFb6X | US0004 | 2024-11-20T14:00:31.438Z | 2024-11-24T14:24:06.512Z |
5554013 | 5554013 | 20241119052646_LEzk9 | US0004 | 2024-11-20T14:00:24.353Z | 2024-11-24T14:24:06.381Z |
5553960 | 5553960 | 20241119045854_Qn4L9 | US0004 | 2024-11-20T14:00:12.505Z | 2024-11-24T14:24:05.607Z |
5548841 | 5548841 | 20241117015832_FSHom | US0004 | 2024-11-18T14:10:19.204Z | 2024-11-24T14:25:33.670Z |
5546159 | 5546159 | 20241117093305_K77h4 | US0004 | 2024-11-18T14:02:20.463Z | 2024-11-24T14:25:11.242Z |
5545902 | 5545902 | 20241117074512_eubY2 | US0004 | 2024-11-18T14:01:21.949Z | 2024-11-24T14:25:09.813Z |
5545890 | 5545890 | 20241117074234_L97zc | US0004 | 2024-11-18T14:01:19.095Z | 2024-11-24T14:25:09.601Z |
5545879 | 5545879 | 20241117074155_wtFNH | US0004 | 2024-11-18T14:01:18.258Z | 2024-11-24T14:25:09.598Z |
5545865 | 5545865 | 20241117073513_S9RV8 | US0004 | 2024-11-18T14:01:15.412Z | 2024-11-24T14:25:09.507Z |
5545789 | 5545789 | 20241117070029_ZtbJW | US0004 | 2024-11-18T14:00:58.065Z | 2024-11-24T14:25:08.825Z |
5545758 | 5545758 | 20241117064331_kmq2q | US0004 | 2024-11-18T14:00:52.871Z | 2024-11-24T14:25:08.704Z |
5545298 | 5545298 | 20241116041047_BMJMA | US0004 | 2024-11-17T14:04:25.392Z | 2024-11-24T14:25:43.257Z |
5545279 | 5545279 | 20241116035456_ZuqRg | US0004 | 2024-11-17T14:04:23.472Z | 2024-11-24T14:25:43.007Z |
5544493 | 5544493 | 20241116114832_DiFOs | US0004 | 2024-11-17T14:01:17.994Z | 2024-11-24T14:25:26.418Z |
5544480 | 5544480 | 20241116114401_q52h0 | US0004 | 2024-11-17T14:01:16.585Z | 2024-11-24T14:25:26.339Z |
5544385 | 5544385 | 20241116104225_b3Md3 | US0004 | 2024-11-17T14:01:00.047Z | 2024-11-24T14:25:26.049Z |
5544353 | 5544353 | 20241116101825_j6eQO | US0004 | 2024-11-17T14:00:56.013Z | 2024-11-24T14:25:25.980Z |
5544315 | 5544315 | 20241116095741_sqi6o | US0004 | 2024-11-17T14:00:50.778Z | 2024-11-24T14:25:25.842Z |
5543939 | 5543939 | 20241115044443_qQUS8 | US0004 | 2024-11-16T14:07:43.156Z | 2024-11-23T14:26:22.400Z |
5543874 | 5543874 | 20241115035809_6IKd4 | US0004 | 2024-11-16T14:07:34.738Z | 2024-11-23T14:26:21.755Z |
5543568 | 5543568 | 20241115021343_Wh231 | US0004 | 2024-11-16T14:06:45.297Z | 2024-11-23T14:26:19.814Z |
5543544 | 5543544 | 20241115020047_FARfT | US0004 | 2024-11-16T14:06:39.674Z | 2024-11-23T14:26:19.602Z |
5543515 | 5543515 | 20241115015335_Ftlb7 | US0004 | 2024-11-16T14:06:34.293Z | 2024-11-23T14:26:19.455Z |
5542692 | 5542692 | 20241115115101_gOmmM | US0004 | 2024-11-16T14:02:12.312Z | 2024-11-24T14:25:40.208Z |
5542674 | 5542674 | 20241115114443_SQenv | US0004 | 2024-11-16T14:02:10.270Z | 2024-11-24T14:25:40.146Z |
5542632 | 5542632 | 20241115112340_vTlwL | US0004 | 2024-11-16T14:02:04.821Z | 2024-11-24T14:25:40.030Z |
5542570 | 5542570 | 20241115110047_MsPnX | US0004 | 2024-11-16T14:01:49.385Z | 2024-11-24T14:25:39.871Z |
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);