participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "US0005" 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 |
---|---|---|---|---|---|
5583723 | 5583723 | 20241118114509_38gnv | US0005 | 2024-11-23T14:24:57.588Z | 2024-11-23T14:24:57.588Z |
5583600 | 5583600 | 20241120033801_xKFti | US0005 | 2024-11-23T14:24:44.753Z | 2024-11-23T14:24:44.753Z |
5583358 | 5583358 | 20241119095227_7xwR5 | US0005 | 2024-11-23T14:24:06.567Z | 2024-11-23T14:24:06.567Z |
5582419 | 5582419 | 20241122033303_wQRgW | US0005 | 2024-11-23T14:21:04.963Z | 2024-11-23T14:21:25.721Z |
5581824 | 5581824 | 20241122023823_cOmym | US0005 | 2024-11-23T14:20:45.948Z | 2024-11-23T14:21:25.623Z |
5580710 | 5580710 | 20241122010758_P0O69 | US0005 | 2024-11-23T14:19:38.289Z | 2024-11-23T14:21:25.438Z |
5580662 | 5580662 | 20241122010210_9z067 | US0005 | 2024-11-23T14:19:36.115Z | 2024-11-23T14:21:25.429Z |
5577181 | 5577181 | 20241121120708_2Fh00 | US0005 | 2024-11-23T14:13:52.606Z | 2024-11-23T14:21:24.222Z |
5576652 | 5576652 | 20241122124538_fTfcB | US0005 | 2024-11-23T14:10:00.000Z | 2024-11-23T14:10:00.000Z |
5576566 | 5576566 | 20241122123239_YDjVT | US0005 | 2024-11-23T14:09:50.130Z | 2024-11-23T14:09:50.130Z |
5576403 | 5576403 | 20241122120002_qsebt | US0005 | 2024-11-23T14:09:22.776Z | 2024-11-23T14:09:22.776Z |
5576378 | 5576378 | 20241122115444_s2Z53 | US0005 | 2024-11-23T14:09:20.535Z | 2024-11-23T14:09:20.535Z |
5576326 | 5576326 | 20241122114805_uH3Pm | US0005 | 2024-11-23T14:09:13.240Z | 2024-11-23T14:09:13.240Z |
5576268 | 5576268 | 20241122113811_gC6wB | US0005 | 2024-11-23T14:09:03.667Z | 2024-11-23T14:09:03.667Z |
5576179 | 5576179 | 20241122112717_TYwFJ | US0005 | 2024-11-23T14:08:43.500Z | 2024-11-23T14:08:43.500Z |
5576109 | 5576109 | 20241122111538_x35He | US0005 | 2024-11-23T14:08:34.883Z | 2024-11-23T14:08:34.883Z |
5575990 | 5575990 | 20241122105737_kbym7 | US0005 | 2024-11-23T14:08:13.438Z | 2024-11-23T14:08:13.438Z |
5575939 | 5575939 | 20241122104859_gSVAn | US0005 | 2024-11-23T14:08:05.760Z | 2024-11-23T14:08:05.760Z |
5575844 | 5575844 | 20241122102915_3kG7o | US0005 | 2024-11-23T14:07:50.029Z | 2024-11-23T14:07:50.029Z |
5575824 | 5575824 | 20241122102453_NTUwg | US0005 | 2024-11-23T14:07:42.338Z | 2024-11-23T14:07:42.338Z |
5575738 | 5575738 | 20241122100955_gxKw9 | US0005 | 2024-11-23T14:07:28.127Z | 2024-11-23T14:07:28.127Z |
5575709 | 5575709 | 20241122100345_azddy | US0005 | 2024-11-23T14:07:22.838Z | 2024-11-23T14:07:22.838Z |
5575654 | 5575654 | 20241122095538_bJaWf | US0005 | 2024-11-23T14:07:08.177Z | 2024-11-23T14:07:08.177Z |
5575644 | 5575644 | 20241122095452_xrRC3 | US0005 | 2024-11-23T14:07:06.519Z | 2024-11-23T14:07:06.519Z |
5575570 | 5575570 | 20241122094256_roQJ9 | US0005 | 2024-11-23T14:06:49.523Z | 2024-11-23T14:06:49.523Z |
5575566 | 5575566 | 20241122094211_7wm9A | US0005 | 2024-11-23T14:06:49.238Z | 2024-11-23T14:06:49.238Z |
5575539 | 5575539 | 20241122093846_Qs3zD | US0005 | 2024-11-23T14:06:46.202Z | 2024-11-23T14:06:46.202Z |
5575436 | 5575436 | 20241122092207_pTFSY | US0005 | 2024-11-23T14:06:34.457Z | 2024-11-23T14:06:34.457Z |
5575398 | 5575398 | 20241122091331_tfvzH | US0005 | 2024-11-23T14:06:23.923Z | 2024-11-23T14:06:23.923Z |
5575008 | 5575008 | 20241122073657_ENDjl | US0005 | 2024-11-23T14:05:03.968Z | 2024-11-23T14:05:03.968Z |
5574924 | 5574924 | 20241122070418_eR3nQ | US0005 | 2024-11-23T14:04:49.604Z | 2024-11-23T14:04:49.604Z |
5574920 | 5574920 | 20241122070337_3uVKH | US0005 | 2024-11-23T14:04:49.294Z | 2024-11-23T14:04:49.294Z |
5574903 | 5574903 | 20241122065907_XzrAO | US0005 | 2024-11-23T14:04:47.247Z | 2024-11-23T14:04:47.247Z |
5574845 | 5574845 | 20241122064549_i3f6Y | US0005 | 2024-11-23T14:04:36.593Z | 2024-11-23T14:04:36.593Z |
5574834 | 5574834 | 20241122064046_g0vtK | US0005 | 2024-11-23T14:04:32.546Z | 2024-11-23T14:04:32.546Z |
5574825 | 5574825 | 20241122063818_6I3J2 | US0005 | 2024-11-23T14:04:31.248Z | 2024-11-23T14:04:31.248Z |
5574631 | 5574631 | 20241122060707_Lmpb9 | US0005 | 2024-11-23T14:03:53.349Z | 2024-11-23T14:03:53.349Z |
5574469 | 5574469 | 20241122054824_kCBBg | US0005 | 2024-11-23T14:03:29.744Z | 2024-11-23T14:03:29.744Z |
5574378 | 5574378 | 20241122053936_qulWy | US0005 | 2024-11-23T14:03:09.875Z | 2024-11-23T14:03:09.875Z |
5574305 | 5574305 | 20241122053340_reDgJ | US0005 | 2024-11-23T14:03:00.938Z | 2024-11-23T14:03:00.938Z |
5574009 | 5574009 | 20241122045953_D2TwY | US0005 | 2024-11-23T14:02:09.329Z | 2024-11-23T14:02:09.329Z |
5573266 | 5573266 | 20241121041759_r41M1 | US0005 | 2024-11-22T14:19:19.402Z | 2024-11-23T14:23:53.682Z |
5573034 | 5573034 | 20241121034249_JqGnE | US0005 | 2024-11-22T14:19:06.782Z | 2024-11-23T14:23:50.916Z |
5572732 | 5572732 | 20241121030329_Sm71L | US0005 | 2024-11-22T14:18:46.760Z | 2024-11-23T14:23:48.430Z |
5572126 | 5572126 | 20241121013536_c2ttz | US0005 | 2024-11-22T14:17:59.847Z | 2024-11-23T14:23:40.426Z |
5572113 | 5572113 | 20241121013435_ssM3j | US0005 | 2024-11-22T14:17:58.549Z | 2024-11-23T14:23:40.281Z |
5568448 | 5568448 | 20241121124911_BE8oX | US0005 | 2024-11-22T14:08:58.895Z | 2024-11-23T14:21:24.286Z |
5568428 | 5568428 | 20241121124800_2J1Uv | US0005 | 2024-11-22T14:08:56.593Z | 2024-11-23T14:21:24.281Z |
5568356 | 5568356 | 20241121123016_VgL4w | US0005 | 2024-11-22T14:08:47.452Z | 2024-11-23T14:21:24.261Z |
5568290 | 5568290 | 20241121121919_oK2tI | US0005 | 2024-11-22T14:08:39.143Z | 2024-11-23T14:21:24.245Z |
5568202 | 5568202 | 20241121120449_HLswg | US0005 | 2024-11-22T14:08:25.151Z | 2024-11-23T14:21:24.218Z |
5568140 | 5568140 | 20241121115442_WZOpq | US0005 | 2024-11-22T14:08:12.312Z | 2024-11-23T14:21:24.203Z |
5568016 | 5568016 | 20241121114131_535Gj | US0005 | 2024-11-22T14:07:57.080Z | 2024-11-23T14:21:24.173Z |
5567868 | 5567868 | 20241121112014_zybj7 | US0005 | 2024-11-22T14:07:27.767Z | 2024-11-23T14:21:24.134Z |
5567778 | 5567778 | 20241121110448_QbP1b | US0005 | 2024-11-22T14:07:15.103Z | 2024-11-23T14:21:24.111Z |
5567762 | 5567762 | 20241121110249_DE9Tx | US0005 | 2024-11-22T14:07:13.465Z | 2024-11-23T14:21:24.108Z |
5567460 | 5567460 | 20241121102139_ceu2u | US0005 | 2024-11-22T14:06:19.639Z | 2024-11-23T14:21:24.018Z |
5567418 | 5567418 | 20241121101538_cwZTH | US0005 | 2024-11-22T14:06:13.610Z | 2024-11-23T14:21:24.007Z |
5567363 | 5567363 | 20241121100630_wFBnD | US0005 | 2024-11-22T14:05:59.854Z | 2024-11-23T14:21:23.991Z |
5567341 | 5567341 | 20241121100313_zP68x | US0005 | 2024-11-22T14:05:56.604Z | 2024-11-23T14:21:23.987Z |
5567319 | 5567319 | 20241121100243_LSHqi | US0005 | 2024-11-22T14:05:52.856Z | 2024-11-23T14:21:23.983Z |
5567280 | 5567280 | 20241121095757_vLedb | US0005 | 2024-11-22T14:05:45.932Z | 2024-11-23T14:21:23.973Z |
5567241 | 5567241 | 20241121094821_07Car | US0005 | 2024-11-22T14:05:40.136Z | 2024-11-23T14:21:23.958Z |
5567231 | 5567231 | 20241121094614_SDP1s | US0005 | 2024-11-22T14:05:38.454Z | 2024-11-23T14:21:23.955Z |
5567226 | 5567226 | 20241121094533_mSAdp | US0005 | 2024-11-22T14:05:37.665Z | 2024-11-23T14:21:23.954Z |
5567174 | 5567174 | 20241121093643_JIF2u | US0005 | 2024-11-22T14:05:29.922Z | 2024-11-23T14:21:23.936Z |
5567152 | 5567152 | 20241121093550_3f2n5 | US0005 | 2024-11-22T14:05:27.713Z | 2024-11-23T14:21:23.929Z |
5567137 | 5567137 | 20241121093255_Bv2zY | US0005 | 2024-11-22T14:05:26.433Z | 2024-11-23T14:21:23.923Z |
5567126 | 5567126 | 20241121092919_PqsXa | US0005 | 2024-11-22T14:05:24.765Z | 2024-11-23T14:21:23.918Z |
5567086 | 5567086 | 20241121091538_X7zAX | US0005 | 2024-11-22T14:05:07.069Z | 2024-11-23T14:21:23.904Z |
5567016 | 5567016 | 20241121085713_yB6J8 | US0005 | 2024-11-22T14:04:53.589Z | 2024-11-23T14:21:23.876Z |
5566956 | 5566956 | 20241121084844_stFLG | US0005 | 2024-11-22T14:04:45.449Z | 2024-11-23T14:21:23.861Z |
5566951 | 5566951 | 20241121084725_IXjLZ | US0005 | 2024-11-22T14:04:44.193Z | 2024-11-23T14:21:23.859Z |
5566923 | 5566923 | 20241121084048_TBwCc | US0005 | 2024-11-22T14:04:31.011Z | 2024-11-23T14:21:23.850Z |
5566895 | 5566895 | 20241121082853_jwepH | US0005 | 2024-11-22T14:04:24.285Z | 2024-11-23T14:21:23.840Z |
5566891 | 5566891 | 20241121082757_qutty | US0005 | 2024-11-22T14:04:23.330Z | 2024-11-23T14:21:23.839Z |
5566719 | 5566719 | 20241121073157_vGHq0 | US0005 | 2024-11-22T14:03:44.487Z | 2024-11-23T14:21:23.788Z |
5566706 | 5566706 | 20241121072854_vqo53 | US0005 | 2024-11-22T14:03:42.564Z | 2024-11-23T14:21:23.783Z |
5566650 | 5566650 | 20241121071035_snOGf | US0005 | 2024-11-22T14:03:33.590Z | 2024-11-23T14:21:23.767Z |
5566604 | 5566604 | 20241121070002_dCz0r | US0005 | 2024-11-22T14:03:25.711Z | 2024-11-23T14:21:23.754Z |
5566602 | 5566602 | 20241121065803_rrYTO | US0005 | 2024-11-22T14:03:25.352Z | 2024-11-23T14:21:23.753Z |
5566599 | 5566599 | 20241121065655_5XuF8 | US0005 | 2024-11-22T14:03:23.988Z | 2024-11-23T14:21:23.753Z |
5566543 | 5566543 | 20241121063246_0iebb | US0005 | 2024-11-22T14:03:09.490Z | 2024-11-23T14:21:23.728Z |
5566480 | 5566480 | 20241121062050_sgaxq | US0005 | 2024-11-22T14:02:59.751Z | 2024-11-23T14:21:23.714Z |
5566444 | 5566444 | 20241121061154_hJiTU | US0005 | 2024-11-22T14:02:54.380Z | 2024-11-23T14:21:23.705Z |
5566417 | 5566417 | 20241121061040_eda8a | US0005 | 2024-11-22T14:02:52.181Z | 2024-11-23T14:21:23.701Z |
5566365 | 5566365 | 20241121060504_abqwO | US0005 | 2024-11-22T14:02:32.992Z | 2024-11-23T14:21:23.688Z |
5566293 | 5566293 | 20241121055536_WN2TX | US0005 | 2024-11-22T14:02:22.853Z | 2024-11-23T14:21:23.674Z |
5566211 | 5566211 | 20241121054719_wQMtG | US0005 | 2024-11-22T14:02:13.927Z | 2024-11-23T14:21:23.657Z |
5566067 | 5566067 | 20241121052511_23Jp1 | US0005 | 2024-11-22T14:01:43.568Z | 2024-11-23T14:21:23.607Z |
5565634 | 5565634 | 20241121042944_H3eM1 | US0005 | 2024-11-22T14:00:28.926Z | 2024-11-23T14:21:23.490Z |
5565244 | 5565244 | 20241120040751_7WrOs | US0005 | 2024-11-21T14:18:43.737Z | 2024-11-23T14:24:46.407Z |
5564848 | 5564848 | 20241120033052_9BPlT | US0005 | 2024-11-21T14:18:07.625Z | 2024-11-23T14:24:44.144Z |
5564683 | 5564683 | 20241120031941_c3KIn | US0005 | 2024-11-21T14:17:57.992Z | 2024-11-23T14:24:43.611Z |
5564148 | 5564148 | 20241120023401_0d52Z | US0005 | 2024-11-21T14:17:14.600Z | 2024-11-23T14:24:40.966Z |
5564125 | 5564125 | 20241120023147_IUrkE | US0005 | 2024-11-21T14:17:12.618Z | 2024-11-23T14:24:40.813Z |
5564121 | 5564121 | 20241120023115_WYrax | US0005 | 2024-11-21T14:17:12.538Z | 2024-11-23T14:24:40.782Z |
5563472 | 5563472 | 20241120013313_BrV5A | US0005 | 2024-11-21T14:16:09.688Z | 2024-11-23T14:24:36.150Z |
5560328 | 5560328 | 20241120123902_lqzTl | US0005 | 2024-11-21T14:08:40.233Z | 2024-11-23T14:22:33.855Z |
5560315 | 5560315 | 20241120123519_Yg8PY | US0005 | 2024-11-21T14:08:35.569Z | 2024-11-23T14:22:33.598Z |
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);