participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "US000C" 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 |
---|---|---|---|---|---|
5583908 | 5583908 | 20241119024820_Mz4r2 | US000C | 2024-11-23T14:25:09.271Z | 2024-11-23T14:25:09.271Z |
5583906 | 5583906 | 20241119024819_TPCJG | US000C | 2024-11-23T14:25:09.238Z | 2024-11-23T14:25:09.238Z |
5583394 | 5583394 | 20241119124237_6Y5PN | US000C | 2024-11-23T14:24:13.405Z | 2024-11-23T14:24:13.405Z |
5583379 | 5583379 | 20241119114150_iYD10 | US000C | 2024-11-23T14:24:11.457Z | 2024-11-23T14:24:11.457Z |
5583360 | 5583360 | 20241119100130_Z5TPb | US000C | 2024-11-23T14:24:06.990Z | 2024-11-23T14:24:06.990Z |
5582966 | 5582966 | 20241120103435_FS7Jw | US000C | 2024-11-23T14:22:18.052Z | 2024-11-23T14:22:18.052Z |
5582945 | 5582945 | 20241120093546_wl2v5 | US000C | 2024-11-23T14:22:09.757Z | 2024-11-23T14:22:09.757Z |
5582763 | 5582763 | 20241122035517_X1GCG | US000C | 2024-11-23T14:21:17.905Z | 2024-11-23T14:21:25.772Z |
5582494 | 5582494 | 20241122033842_8b8dq | US000C | 2024-11-23T14:21:06.619Z | 2024-11-23T14:21:25.730Z |
5582421 | 5582421 | 20241122033303_wQRgW | US000C | 2024-11-23T14:21:04.963Z | 2024-11-23T14:21:25.721Z |
5582312 | 5582312 | 20241122032107_60ryb | US000C | 2024-11-23T14:21:02.504Z | 2024-11-23T14:21:25.704Z |
5581826 | 5581826 | 20241122023823_cOmym | US000C | 2024-11-23T14:20:45.948Z | 2024-11-23T14:21:25.623Z |
5580732 | 5580732 | 20241122011040_Vqt5d | US000C | 2024-11-23T14:19:40.213Z | 2024-11-23T14:21:25.443Z |
5580711 | 5580711 | 20241122010758_P0O69 | US000C | 2024-11-23T14:19:38.289Z | 2024-11-23T14:21:25.438Z |
5577099 | 5577099 | 20241121083921_L6itc | US000C | 2024-11-23T14:12:39.092Z | 2024-11-23T14:21:23.847Z |
5577085 | 5577085 | 20241121070202_4yZyl | US000C | 2024-11-23T14:12:16.137Z | 2024-11-23T14:21:23.756Z |
5577070 | 5577070 | 20241121054618_E3D54 | US000C | 2024-11-23T14:11:53.275Z | 2024-11-23T14:21:23.655Z |
5576591 | 5576591 | 20241122123645_83XT1 | US000C | 2024-11-23T14:09:52.881Z | 2024-11-23T14:09:52.881Z |
5576557 | 5576557 | 20241122123031_QJKDw | US000C | 2024-11-23T14:09:49.408Z | 2024-11-23T14:09:49.408Z |
5576548 | 5576548 | 20241122122950_BTJel | US000C | 2024-11-23T14:09:48.903Z | 2024-11-23T14:09:48.903Z |
5576511 | 5576511 | 20241122122245_JYIHE | US000C | 2024-11-23T14:09:41.235Z | 2024-11-23T14:09:41.235Z |
5576411 | 5576411 | 20241122120038_RjXQX | US000C | 2024-11-23T14:09:23.472Z | 2024-11-23T14:09:23.472Z |
5576380 | 5576380 | 20241122115444_s2Z53 | US000C | 2024-11-23T14:09:20.535Z | 2024-11-23T14:09:20.535Z |
5576355 | 5576355 | 20241122115241_h3LDN | US000C | 2024-11-23T14:09:17.796Z | 2024-11-23T14:09:17.796Z |
5576338 | 5576338 | 20241122114927_afp9c | US000C | 2024-11-23T14:09:15.537Z | 2024-11-23T14:09:15.537Z |
5576235 | 5576235 | 20241122113456_jyIUI | US000C | 2024-11-23T14:08:51.897Z | 2024-11-23T14:08:51.897Z |
5576192 | 5576192 | 20241122112814_DwPsn | US000C | 2024-11-23T14:08:45.156Z | 2024-11-23T14:08:45.156Z |
5576180 | 5576180 | 20241122112717_TYwFJ | US000C | 2024-11-23T14:08:43.500Z | 2024-11-23T14:08:43.500Z |
5576158 | 5576158 | 20241122112325_aAZuc | US000C | 2024-11-23T14:08:41.803Z | 2024-11-23T14:08:41.803Z |
5575978 | 5575978 | 20241122105432_NmdMk | US000C | 2024-11-23T14:08:11.888Z | 2024-11-23T14:08:11.888Z |
5575963 | 5575963 | 20241122105241_oafyc | US000C | 2024-11-23T14:08:10.189Z | 2024-11-23T14:08:10.189Z |
5575839 | 5575839 | 20241122102907_Z5DTP | US000C | 2024-11-23T14:07:49.606Z | 2024-11-23T14:07:49.606Z |
5575795 | 5575795 | 20241122102050_t6FXn | US000C | 2024-11-23T14:07:37.259Z | 2024-11-23T14:07:37.259Z |
5575580 | 5575580 | 20241122094430_KMlyt | US000C | 2024-11-23T14:06:51.143Z | 2024-11-23T14:06:51.143Z |
5575541 | 5575541 | 20241122093846_Qs3zD | US000C | 2024-11-23T14:06:46.202Z | 2024-11-23T14:06:46.202Z |
5575472 | 5575472 | 20241122092807_Pwkaa | US000C | 2024-11-23T14:06:38.222Z | 2024-11-23T14:06:38.222Z |
5575465 | 5575465 | 20241122092510_v9UEC | US000C | 2024-11-23T14:06:37.721Z | 2024-11-23T14:06:37.721Z |
5575458 | 5575458 | 20241122092437_TMqmp | US000C | 2024-11-23T14:06:36.618Z | 2024-11-23T14:06:36.618Z |
5575437 | 5575437 | 20241122092207_pTFSY | US000C | 2024-11-23T14:06:34.457Z | 2024-11-23T14:06:34.457Z |
5575413 | 5575413 | 20241122091518_jp7tq | US000C | 2024-11-23T14:06:24.880Z | 2024-11-23T14:06:24.880Z |
5575402 | 5575402 | 20241122091414_QtREF | US000C | 2024-11-23T14:06:24.283Z | 2024-11-23T14:06:24.283Z |
5575399 | 5575399 | 20241122091331_tfvzH | US000C | 2024-11-23T14:06:23.923Z | 2024-11-23T14:06:23.923Z |
5575270 | 5575270 | 20241122085614_BGNPp | US000C | 2024-11-23T14:06:01.632Z | 2024-11-23T14:06:01.632Z |
5575232 | 5575232 | 20241122084923_inp8F | US000C | 2024-11-23T14:05:55.935Z | 2024-11-23T14:05:55.935Z |
5575009 | 5575009 | 20241122073657_ENDjl | US000C | 2024-11-23T14:05:03.968Z | 2024-11-23T14:05:03.968Z |
5574974 | 5574974 | 20241122072348_PCiKs | US000C | 2024-11-23T14:04:58.764Z | 2024-11-23T14:04:58.764Z |
5574872 | 5574872 | 20241122065141_bEM8i | US000C | 2024-11-23T14:04:42.492Z | 2024-11-23T14:04:42.492Z |
5574861 | 5574861 | 20241122064935_QAUhA | US000C | 2024-11-23T14:04:40.744Z | 2024-11-23T14:04:40.744Z |
5574826 | 5574826 | 20241122063818_6I3J2 | US000C | 2024-11-23T14:04:31.248Z | 2024-11-23T14:04:31.248Z |
5574379 | 5574379 | 20241122053936_qulWy | US000C | 2024-11-23T14:03:09.875Z | 2024-11-23T14:03:09.875Z |
5574330 | 5574330 | 20241122053520_fRFPv | US000C | 2024-11-23T14:03:03.025Z | 2024-11-23T14:03:03.025Z |
5574306 | 5574306 | 20241122053340_reDgJ | US000C | 2024-11-23T14:03:00.938Z | 2024-11-23T14:03:00.938Z |
5574010 | 5574010 | 20241122045953_D2TwY | US000C | 2024-11-23T14:02:09.391Z | 2024-11-23T14:02:09.391Z |
5572733 | 5572733 | 20241121030329_Sm71L | US000C | 2024-11-22T14:18:46.760Z | 2024-11-23T14:23:48.430Z |
5572425 | 5572425 | 20241121022020_pgW5b | US000C | 2024-11-22T14:18:25.437Z | 2024-11-23T14:23:45.332Z |
5572137 | 5572137 | 20241121014014_8lp91 | US000C | 2024-11-22T14:18:00.748Z | 2024-11-23T14:23:40.532Z |
5568326 | 5568326 | 20241121122457_e8qHp | US000C | 2024-11-22T14:08:43.808Z | 2024-11-23T14:21:24.253Z |
5568291 | 5568291 | 20241121121919_oK2tI | US000C | 2024-11-22T14:08:39.143Z | 2024-11-23T14:21:24.245Z |
5568229 | 5568229 | 20241121121125_bzpRZ | US000C | 2024-11-22T14:08:32.908Z | 2024-11-23T14:21:24.231Z |
5568203 | 5568203 | 20241121120449_HLswg | US000C | 2024-11-22T14:08:25.151Z | 2024-11-23T14:21:24.218Z |
5568167 | 5568167 | 20241121115814_toWV2 | US000C | 2024-11-22T14:08:15.543Z | 2024-11-23T14:21:24.210Z |
5568138 | 5568138 | 20241121115442_guNeQ | US000C | 2024-11-22T14:08:12.012Z | 2024-11-23T14:21:24.202Z |
5567996 | 5567996 | 20241121114057_wIeE1 | US000C | 2024-11-22T14:07:55.320Z | 2024-11-23T14:21:24.170Z |
5567853 | 5567853 | 20241121111926_zwIsD | US000C | 2024-11-22T14:07:25.164Z | 2024-11-23T14:21:24.131Z |
5567788 | 5567788 | 20241121110915_ZW0Tp | US000C | 2024-11-22T14:07:16.177Z | 2024-11-23T14:21:24.115Z |
5567763 | 5567763 | 20241121110249_DE9Tx | US000C | 2024-11-22T14:07:13.465Z | 2024-11-23T14:21:24.108Z |
5567736 | 5567736 | 20241121105803_Dr8oy | US000C | 2024-11-22T14:07:10.055Z | 2024-11-23T14:21:24.101Z |
5567695 | 5567695 | 20241121105239_cUgtV | US000C | 2024-11-22T14:07:01.496Z | 2024-11-23T14:21:24.089Z |
5567684 | 5567684 | 20241121105214_6jkLT | US000C | 2024-11-22T14:06:54.141Z | 2024-11-23T14:21:24.086Z |
5567632 | 5567632 | 20241121104709_63TZ4 | US000C | 2024-11-22T14:06:41.421Z | 2024-11-23T14:21:24.064Z |
5567501 | 5567501 | 20241121102911_SFXID | US000C | 2024-11-22T14:06:24.890Z | 2024-11-23T14:21:24.030Z |
5567285 | 5567285 | 20241121095757_L5BG2 | US000C | 2024-11-22T14:05:46.220Z | 2024-11-23T14:21:23.973Z |
5567221 | 5567221 | 20241121094408_0p7Vl | US000C | 2024-11-22T14:05:36.957Z | 2024-11-23T14:21:23.952Z |
5567160 | 5567160 | 20241121093619_FvB9M | US000C | 2024-11-22T14:05:28.694Z | 2024-11-23T14:21:23.933Z |
5567105 | 5567105 | 20241121092307_gDXCS | US000C | 2024-11-22T14:05:16.509Z | 2024-11-23T14:21:23.911Z |
5566997 | 5566997 | 20241121085435_0RHeO | US000C | 2024-11-22T14:04:50.911Z | 2024-11-23T14:21:23.871Z |
5566790 | 5566790 | 20241121074951_e2OK6 | US000C | 2024-11-22T14:04:04.675Z | 2024-11-23T14:21:23.807Z |
5566770 | 5566770 | 20241121074445_UlUNP | US000C | 2024-11-22T14:03:54.407Z | 2024-11-23T14:21:23.800Z |
5566721 | 5566721 | 20241121073157_Cwepj | US000C | 2024-11-22T14:03:44.747Z | 2024-11-23T14:21:23.788Z |
5566701 | 5566701 | 20241121072800_LIbnC | US000C | 2024-11-22T14:03:41.818Z | 2024-11-23T14:21:23.782Z |
5566606 | 5566606 | 20241121070002_PtZUu | US000C | 2024-11-22T14:03:26.195Z | 2024-11-23T14:21:23.755Z |
5566600 | 5566600 | 20241121065655_5XuF8 | US000C | 2024-11-22T14:03:23.988Z | 2024-11-23T14:21:23.753Z |
5566513 | 5566513 | 20241121062549_CPpMJ | US000C | 2024-11-22T14:03:02.641Z | 2024-11-23T14:21:23.719Z |
5565620 | 5565620 | 20241121042644_HxI32 | US000C | 2024-11-22T14:00:25.907Z | 2024-11-23T14:21:23.485Z |
5565245 | 5565245 | 20241120040751_7WrOs | US000C | 2024-11-21T14:18:43.737Z | 2024-11-23T14:24:46.407Z |
5564856 | 5564856 | 20241120033149_Y5Zb7 | US000C | 2024-11-21T14:18:08.410Z | 2024-11-23T14:24:44.196Z |
5564736 | 5564736 | 20241120032409_eNtcM | US000C | 2024-11-21T14:18:01.395Z | 2024-11-23T14:24:43.778Z |
5564719 | 5564719 | 20241120032239_5MOas | US000C | 2024-11-21T14:17:59.517Z | 2024-11-23T14:24:43.738Z |
5564684 | 5564684 | 20241120031941_c3KIn | US000C | 2024-11-21T14:17:57.992Z | 2024-11-23T14:24:43.611Z |
5563737 | 5563737 | 20241120020032_2rUsg | US000C | 2024-11-21T14:16:37.452Z | 2024-11-23T14:24:38.733Z |
5560388 | 5560388 | 20241120124624_n2peD | US000C | 2024-11-21T14:08:46.719Z | 2024-11-23T14:22:34.811Z |
5560333 | 5560333 | 20241120123909_6eJF1 | US000C | 2024-11-21T14:08:41.320Z | 2024-11-23T14:22:34.150Z |
5560217 | 5560217 | 20241120121926_3uiqk | US000C | 2024-11-21T14:08:17.988Z | 2024-11-23T14:22:32.252Z |
5560041 | 5560041 | 20241120114950_YQzXy | US000C | 2024-11-21T14:07:55.697Z | 2024-11-23T14:22:28.457Z |
5559968 | 5559968 | 20241120113949_IFWsQ | US000C | 2024-11-21T14:07:42.590Z | 2024-11-23T14:22:26.893Z |
5559913 | 5559913 | 20241120113335_7oghP | US000C | 2024-11-21T14:07:33.135Z | 2024-11-23T14:22:26.180Z |
5559812 | 5559812 | 20241120112127_NoRsY | US000C | 2024-11-21T14:07:14.397Z | 2024-11-23T14:22:24.401Z |
5559793 | 5559793 | 20241120111817_JE5Wq | US000C | 2024-11-21T14:07:12.278Z | 2024-11-23T14:22:24.023Z |
5559785 | 5559785 | 20241120111713_Q9xRR | US000C | 2024-11-21T14:07:11.144Z | 2024-11-23T14:22:23.865Z |
5559750 | 5559750 | 20241120111222_BHY8x | US000C | 2024-11-21T14:07:06.883Z | 2024-11-23T14:22:23.067Z |
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);