participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "US000D" 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 |
---|---|---|---|---|---|
5592428 | 5592428 | 20241123032508_QcWuY | US000D | 2024-11-24T14:21:01.448Z | 2024-11-24T14:21:11.777Z |
5592199 | 5592199 | 20241123023354_YJ1J7 | US000D | 2024-11-24T14:20:46.067Z | 2024-11-24T14:21:11.711Z |
5586631 | 5586631 | 20241123125511_kPsxd | US000D | 2024-11-24T14:08:26.708Z | 2024-11-24T14:08:26.708Z |
5586521 | 5586521 | 20241123122327_ua7t5 | US000D | 2024-11-24T14:08:08.336Z | 2024-11-24T14:08:08.336Z |
5586508 | 5586508 | 20241123122209_XrIKY | US000D | 2024-11-24T14:08:07.084Z | 2024-11-24T14:08:07.084Z |
5586313 | 5586313 | 20241123114852_eGQER | US000D | 2024-11-24T14:07:31.856Z | 2024-11-24T14:07:31.856Z |
5586270 | 5586270 | 20241123114212_Zt3Zc | US000D | 2024-11-24T14:07:24.495Z | 2024-11-24T14:07:24.495Z |
5586234 | 5586234 | 20241123113342_a46y2 | US000D | 2024-11-24T14:07:19.209Z | 2024-11-24T14:07:19.209Z |
5586091 | 5586091 | 20241123110342_fsFe2 | US000D | 2024-11-24T14:07:01.039Z | 2024-11-24T14:07:01.039Z |
5586082 | 5586082 | 20241123110330_B1PrR | US000D | 2024-11-24T14:07:00.718Z | 2024-11-24T14:07:00.718Z |
5586051 | 5586051 | 20241123105718_EKm2I | US000D | 2024-11-24T14:06:57.442Z | 2024-11-24T14:06:57.442Z |
5586046 | 5586046 | 20241123105712_T33a3 | US000D | 2024-11-24T14:06:57.096Z | 2024-11-24T14:06:57.096Z |
5586031 | 5586031 | 20241123105619_mNw4X | US000D | 2024-11-24T14:06:55.627Z | 2024-11-24T14:06:55.627Z |
5585921 | 5585921 | 20241123103953_YRPex | US000D | 2024-11-24T14:06:27.602Z | 2024-11-24T14:06:27.602Z |
5585844 | 5585844 | 20241123102602_8ogK3 | US000D | 2024-11-24T14:06:16.944Z | 2024-11-24T14:06:16.944Z |
5585733 | 5585733 | 20241123100421_X6rSM | US000D | 2024-11-24T14:06:01.527Z | 2024-11-24T14:06:01.527Z |
5585728 | 5585728 | 20241123100412_lvqn4 | US000D | 2024-11-24T14:06:00.976Z | 2024-11-24T14:06:00.976Z |
5585720 | 5585720 | 20241123100359_IcE2e | US000D | 2024-11-24T14:05:57.332Z | 2024-11-24T14:05:57.332Z |
5585583 | 5585583 | 20241123093621_2gfUv | US000D | 2024-11-24T14:05:24.022Z | 2024-11-24T14:05:24.022Z |
5585529 | 5585529 | 20241123092258_vdL02 | US000D | 2024-11-24T14:05:07.949Z | 2024-11-24T14:05:07.949Z |
5585444 | 5585444 | 20241123090310_u0YbO | US000D | 2024-11-24T14:04:52.767Z | 2024-11-24T14:04:52.767Z |
5585404 | 5585404 | 20241123085635_4wPCy | US000D | 2024-11-24T14:04:45.875Z | 2024-11-24T14:04:45.875Z |
5585337 | 5585337 | 20241123083659_H33Fj | US000D | 2024-11-24T14:04:24.071Z | 2024-11-24T14:04:24.071Z |
5585182 | 5585182 | 20241123075531_RnY5O | US000D | 2024-11-24T14:03:42.895Z | 2024-11-24T14:03:42.895Z |
5585124 | 5585124 | 20241123074636_vSiFx | US000D | 2024-11-24T14:03:33.852Z | 2024-11-24T14:03:33.852Z |
5585074 | 5585074 | 20241123073525_J0B1k | US000D | 2024-11-24T14:03:28.058Z | 2024-11-24T14:03:28.058Z |
5585022 | 5585022 | 20241123072135_mpZZt | US000D | 2024-11-24T14:03:21.125Z | 2024-11-24T14:03:21.125Z |
5584893 | 5584893 | 20241123064959_XVVOt | US000D | 2024-11-24T14:02:53.337Z | 2024-11-24T14:02:53.337Z |
5584837 | 5584837 | 20241123063446_E8Z0c | US000D | 2024-11-24T14:02:40.480Z | 2024-11-24T14:02:40.480Z |
5584821 | 5584821 | 20241123063251_KgqRB | US000D | 2024-11-24T14:02:38.117Z | 2024-11-24T14:02:38.117Z |
5584777 | 5584777 | 20241123062350_fdr6Q | US000D | 2024-11-24T14:02:29.994Z | 2024-11-24T14:02:29.994Z |
5584186 | 5584186 | 20241117043136_YaTSh | US000D | 2024-11-23T14:25:44.131Z | 2024-11-24T14:25:35.914Z |
5583947 | 5583947 | 20241117064951_7Q664 | US000D | 2024-11-23T14:25:13.585Z | 2024-11-24T14:25:08.746Z |
5582974 | 5582974 | 20241120105005_JUxnx | US000D | 2024-11-23T14:22:20.264Z | 2024-11-24T14:23:08.064Z |
5581853 | 5581853 | 20241122024120_TOpEu | US000D | 2024-11-23T14:20:47.726Z | 2024-11-24T14:22:33.980Z |
5580663 | 5580663 | 20241122010210_9z067 | US000D | 2024-11-23T14:19:36.115Z | 2024-11-24T14:22:29.301Z |
5577132 | 5577132 | 20241121102058_jqHtX | US000D | 2024-11-23T14:13:02.211Z | 2024-11-24T14:21:49.703Z |
5576706 | 5576706 | 20241122125730_4a337 | US000D | 2024-11-23T14:10:13.617Z | 2024-11-24T14:21:10.749Z |
5576653 | 5576653 | 20241122124538_fTfcB | US000D | 2024-11-23T14:10:00.000Z | 2024-11-24T14:21:10.726Z |
5576479 | 5576479 | 20241122121715_m8tSu | US000D | 2024-11-23T14:09:33.888Z | 2024-11-24T14:21:10.677Z |
5576468 | 5576468 | 20241122121635_lp3NQ | US000D | 2024-11-23T14:09:32.790Z | 2024-11-24T14:21:10.675Z |
5576419 | 5576419 | 20241122120448_VvRaD | US000D | 2024-11-23T14:09:25.001Z | 2024-11-24T14:21:10.658Z |
5576413 | 5576413 | 20241122120124_VZwcE | US000D | 2024-11-23T14:09:24.074Z | 2024-11-24T14:21:10.655Z |
5576328 | 5576328 | 20241122114805_uH3Pm | US000D | 2024-11-23T14:09:13.241Z | 2024-11-24T14:21:10.629Z |
5576282 | 5576282 | 20241122114028_OAHi2 | US000D | 2024-11-23T14:09:06.600Z | 2024-11-24T14:21:10.615Z |
5576110 | 5576110 | 20241122111538_x35He | US000D | 2024-11-23T14:08:34.883Z | 2024-11-24T14:21:10.562Z |
5576006 | 5576006 | 20241122110158_LSNbR | US000D | 2024-11-23T14:08:15.345Z | 2024-11-24T14:21:10.532Z |
5575909 | 5575909 | 20241122104529_A24vh | US000D | 2024-11-23T14:08:01.588Z | 2024-11-24T14:21:10.504Z |
5575856 | 5575856 | 20241122103038_ntTz4 | US000D | 2024-11-23T14:07:53.349Z | 2024-11-24T14:21:10.479Z |
5575739 | 5575739 | 20241122100955_gxKw9 | US000D | 2024-11-23T14:07:28.127Z | 2024-11-24T14:21:10.426Z |
5575645 | 5575645 | 20241122095452_xrRC3 | US000D | 2024-11-23T14:07:06.519Z | 2024-11-24T14:21:10.387Z |
5575438 | 5575438 | 20241122092207_pTFSY | US000D | 2024-11-23T14:06:34.457Z | 2024-11-24T14:21:10.319Z |
5575405 | 5575405 | 20241122091509_07b4s | US000D | 2024-11-23T14:06:24.575Z | 2024-11-24T14:21:10.312Z |
5575367 | 5575367 | 20241122090942_zpFoy | US000D | 2024-11-23T14:06:17.324Z | 2024-11-24T14:21:10.301Z |
5574704 | 5574704 | 20241122061748_MGxAJ | US000D | 2024-11-23T14:04:08.792Z | 2024-11-24T14:21:10.107Z |
5574516 | 5574516 | 20241122055744_R91oH | US000D | 2024-11-23T14:03:36.613Z | 2024-11-23T14:03:36.613Z |
5574307 | 5574307 | 20241122053340_reDgJ | US000D | 2024-11-23T14:03:00.938Z | 2024-11-24T14:21:10.030Z |
5572681 | 5572681 | 20241121025706_UC0BY | US000D | 2024-11-22T14:18:42.337Z | 2024-11-24T14:23:58.004Z |
5568244 | 5568244 | 20241121121454_MlVyV | US000D | 2024-11-22T14:08:34.898Z | 2024-11-24T14:22:01.077Z |
5568017 | 5568017 | 20241121114131_535Gj | US000D | 2024-11-22T14:07:57.080Z | 2024-11-24T14:21:57.899Z |
5567869 | 5567869 | 20241121112014_zybj7 | US000D | 2024-11-22T14:07:27.767Z | 2024-11-24T14:21:56.006Z |
5567815 | 5567815 | 20241121111320_fGpQ7 | US000D | 2024-11-22T14:07:19.302Z | 2024-11-24T14:21:55.054Z |
5567779 | 5567779 | 20241121110448_QbP1b | US000D | 2024-11-22T14:07:15.103Z | 2024-11-24T14:21:54.625Z |
5567523 | 5567523 | 20241121103206_KY95O | US000D | 2024-11-22T14:06:27.007Z | 2024-11-24T14:21:50.827Z |
5567458 | 5567458 | 20241121102127_qGzan | US000D | 2024-11-22T14:06:19.303Z | 2024-11-24T14:21:49.890Z |
5567419 | 5567419 | 20241121101538_cwZTH | US000D | 2024-11-22T14:06:13.610Z | 2024-11-24T14:21:49.100Z |
5567364 | 5567364 | 20241121100630_wFBnD | US000D | 2024-11-22T14:05:59.854Z | 2024-11-24T14:21:48.409Z |
5567301 | 5567301 | 20241121100113_B7Gtq | US000D | 2024-11-22T14:05:49.852Z | 2024-11-24T14:21:47.771Z |
5567281 | 5567281 | 20241121095757_vLedb | US000D | 2024-11-22T14:05:45.932Z | 2024-11-24T14:21:47.534Z |
5567139 | 5567139 | 20241121093255_Bv2zY | US000D | 2024-11-22T14:05:26.433Z | 2024-11-24T14:21:44.825Z |
5567070 | 5567070 | 20241121090941_k5Yt3 | US000D | 2024-11-22T14:05:03.245Z | 2024-11-24T14:21:43.211Z |
5567017 | 5567017 | 20241121085713_yB6J8 | US000D | 2024-11-22T14:04:53.589Z | 2024-11-24T14:21:42.376Z |
5566892 | 5566892 | 20241121082757_qutty | US000D | 2024-11-22T14:04:23.331Z | 2024-11-24T14:21:40.413Z |
5566824 | 5566824 | 20241121080417_tHyKQ | US000D | 2024-11-22T14:04:12.100Z | 2024-11-24T14:21:38.911Z |
5566651 | 5566651 | 20241121071035_snOGf | US000D | 2024-11-22T14:03:33.590Z | 2024-11-24T14:21:35.772Z |
5566627 | 5566627 | 20241121070732_gX22c | US000D | 2024-11-22T14:03:30.280Z | 2024-11-24T14:21:35.399Z |
5566419 | 5566419 | 20241121061040_eda8a | US000D | 2024-11-22T14:02:52.181Z | 2024-11-24T14:21:31.376Z |
5566294 | 5566294 | 20241121055536_WN2TX | US000D | 2024-11-22T14:02:22.853Z | 2024-11-24T14:21:29.633Z |
5566162 | 5566162 | 20241121054109_FpUfY | US000D | 2024-11-22T14:02:04.819Z | 2024-11-24T14:21:27.409Z |
5566068 | 5566068 | 20241121052511_23Jp1 | US000D | 2024-11-22T14:01:43.568Z | 2024-11-24T14:21:25.737Z |
5566054 | 5566054 | 20241121052051_F842j | US000D | 2024-11-22T14:01:37.937Z | 2024-11-24T14:21:25.579Z |
5565635 | 5565635 | 20241121042944_H3eM1 | US000D | 2024-11-22T14:00:28.937Z | 2024-11-24T14:21:16.224Z |
5564149 | 5564149 | 20241120023401_0d52Z | US000D | 2024-11-21T14:17:14.600Z | 2024-11-24T14:24:41.003Z |
5563473 | 5563473 | 20241120013313_BrV5A | US000D | 2024-11-21T14:16:09.688Z | 2024-11-24T14:24:37.791Z |
5560338 | 5560338 | 20241120123927_rXn9S | US000D | 2024-11-21T14:08:41.618Z | 2024-11-24T14:23:17.869Z |
5560330 | 5560330 | 20241120123902_lqzTl | US000D | 2024-11-21T14:08:40.233Z | 2024-11-24T14:23:17.853Z |
5560316 | 5560316 | 20241120123519_Yg8PY | US000D | 2024-11-21T14:08:35.569Z | 2024-11-24T14:23:17.749Z |
5560149 | 5560149 | 20241120120801_Pw7CK | US000D | 2024-11-21T14:08:07.755Z | 2024-11-24T14:23:16.042Z |
5560128 | 5560128 | 20241120120531_4kYOI | US000D | 2024-11-21T14:08:06.331Z | 2024-11-24T14:23:15.910Z |
5559992 | 5559992 | 20241120114349_QcybC | US000D | 2024-11-21T14:07:49.681Z | 2024-11-24T14:23:13.392Z |
5559854 | 5559854 | 20241120112504_qT0hb | US000D | 2024-11-21T14:07:20.383Z | 2024-11-24T14:23:11.730Z |
5559836 | 5559836 | 20241120112237_hnmMD | US000D | 2024-11-21T14:07:18.342Z | 2024-11-24T14:23:11.591Z |
5559756 | 5559756 | 20241120111342_Zcp23 | US000D | 2024-11-21T14:07:07.617Z | 2024-11-24T14:23:10.138Z |
5559669 | 5559669 | 20241120105552_kO8mR | US000D | 2024-11-21T14:06:56.213Z | 2024-11-24T14:23:08.374Z |
5559652 | 5559652 | 20241120105426_nC9Pi | US000D | 2024-11-21T14:06:53.056Z | 2024-11-24T14:23:08.296Z |
5559599 | 5559599 | 20241120104835_OpRwD | US000D | 2024-11-21T14:06:42.432Z | 2024-11-24T14:23:07.829Z |
5559594 | 5559594 | 20241120104827_r6Qxc | US000D | 2024-11-21T14:06:42.048Z | 2024-11-24T14:23:07.817Z |
5559536 | 5559536 | 20241120103913_zAkh1 | US000D | 2024-11-21T14:06:33.157Z | 2024-11-24T14:23:07.283Z |
5559496 | 5559496 | 20241120103351_1yycY | US000D | 2024-11-21T14:06:27.560Z | 2024-11-24T14:23:07.072Z |
5559483 | 5559483 | 20241120102929_ZyCp2 | US000D | 2024-11-21T14:06:26.192Z | 2024-11-24T14:23:07.051Z |
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);