participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "US0001" 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 |
---|---|---|---|---|---|
5524846 | 5524846 | 20241111060239_mHwv2 | US0001 | 2024-11-12T14:18:03.591Z | 2024-11-12T14:18:08.802Z |
5524825 | 5524825 | 20241111055732_pH0iW | US0001 | 2024-11-12T14:18:02.655Z | 2024-11-12T14:18:08.794Z |
5524818 | 5524818 | 20241111055731_1Illr | US0001 | 2024-11-12T14:18:02.588Z | 2024-11-12T14:18:08.793Z |
5524714 | 5524714 | 20241111051833_4gEA1 | US0001 | 2024-11-12T14:17:57.619Z | 2024-11-12T14:18:08.746Z |
5524634 | 5524634 | 20241111045035_wFPUm | US0001 | 2024-11-12T14:17:48.869Z | 2024-11-12T14:18:08.712Z |
5524269 | 5524269 | 20241111034248_3UY22 | US0001 | 2024-11-12T14:16:53.563Z | 2024-11-12T14:18:08.536Z |
5523517 | 5523517 | 20241111013855_UsHAC | US0001 | 2024-11-12T14:15:52.207Z | 2024-11-12T14:18:08.231Z |
5519731 | 5519731 | 20241111124334_V52q7 | US0001 | 2024-11-12T14:04:51.821Z | 2024-11-12T14:04:51.821Z |
5519717 | 5519717 | 20241111123747_uFs35 | US0001 | 2024-11-12T14:04:49.712Z | 2024-11-12T14:04:49.712Z |
5519635 | 5519635 | 20241111121739_70r32 | US0001 | 2024-11-12T14:04:38.944Z | 2024-11-12T14:04:38.944Z |
5519620 | 5519620 | 20241111121551_Xt8lD | US0001 | 2024-11-12T14:04:37.301Z | 2024-11-12T14:04:37.301Z |
5519495 | 5519495 | 20241111114004_g2j8l | US0001 | 2024-11-12T14:04:17.186Z | 2024-11-12T14:04:17.186Z |
5519423 | 5519423 | 20241111112107_jht3f | US0001 | 2024-11-12T14:03:58.646Z | 2024-11-12T14:03:58.646Z |
5519199 | 5519199 | 20241111103945_CmK5L | US0001 | 2024-11-12T14:03:20.514Z | 2024-11-12T14:03:20.514Z |
5519054 | 5519054 | 20241111100722_3JAqI | US0001 | 2024-11-12T14:02:57.960Z | 2024-11-12T14:02:57.960Z |
5518779 | 5518779 | 20241111090818_0xH2p | US0001 | 2024-11-12T14:02:02.707Z | 2024-11-12T14:02:02.707Z |
5518654 | 5518654 | 20241111084420_3ljhA | US0001 | 2024-11-12T14:01:35.996Z | 2024-11-12T14:01:35.996Z |
5518649 | 5518649 | 20241111084410_2geXh | US0001 | 2024-11-12T14:01:35.581Z | 2024-11-12T14:01:35.581Z |
5518586 | 5518586 | 20241111082346_2oSgh | US0001 | 2024-11-12T14:01:25.620Z | 2024-11-12T14:01:25.620Z |
5518572 | 5518572 | 20241111082322_3i3IA | US0001 | 2024-11-12T14:01:24.230Z | 2024-11-12T14:01:24.230Z |
5518535 | 5518535 | 20241111081219_viL52 | US0001 | 2024-11-12T14:01:14.438Z | 2024-11-12T14:01:14.438Z |
5518407 | 5518407 | 20241111073156_WQxpc | US0001 | 2024-11-12T14:00:52.016Z | 2024-11-12T14:00:52.016Z |
5518388 | 5518388 | 20241111072418_xhxDP | US0001 | 2024-11-12T14:00:49.132Z | 2024-11-12T14:00:49.132Z |
5518366 | 5518366 | 20241111071621_JG821 | US0001 | 2024-11-12T14:00:46.303Z | 2024-11-12T14:00:46.303Z |
5518287 | 5518287 | 20241111065647_apK36 | US0001 | 2024-11-12T14:00:28.097Z | 2024-11-12T14:00:28.097Z |
5518261 | 5518261 | 20241111064527_f25l3 | US0001 | 2024-11-12T14:00:24.593Z | 2024-11-12T14:00:24.593Z |
5518235 | 5518235 | 20241111063007_3B2iG | US0001 | 2024-11-12T14:00:20.138Z | 2024-11-12T14:00:20.138Z |
5518226 | 5518226 | 20241111062249_mq3Qi | US0001 | 2024-11-12T14:00:17.940Z | 2024-11-12T14:00:17.940Z |
5518207 | 5518207 | 20241111061229_mm9vC | US0001 | 2024-11-12T14:00:14.221Z | 2024-11-12T14:00:14.221Z |
5518189 | 5518189 | 20241111060432_yMwWv | US0001 | 2024-11-12T14:00:09.868Z | 2024-11-12T14:00:09.868Z |
5518132 | 5518132 | 20241110060535_EAD2V | US0001 | 2024-11-11T14:15:14.987Z | 2024-11-12T14:22:02.723Z |
5518008 | 5518008 | 20241110053647_ywXgE | US0001 | 2024-11-11T14:15:07.843Z | 2024-11-12T14:22:00.357Z |
5517992 | 5517992 | 20241110053306_gAXOR | US0001 | 2024-11-11T14:15:06.863Z | 2024-11-12T14:22:00.015Z |
5517942 | 5517942 | 20241110052221_bro99 | US0001 | 2024-11-11T14:15:04.496Z | 2024-11-12T14:21:59.160Z |
5517866 | 5517866 | 20241110050454_GdQFa | US0001 | 2024-11-11T14:14:57.570Z | 2024-11-12T14:21:57.390Z |
5517803 | 5517803 | 20241110045058_u7Y6y | US0001 | 2024-11-11T14:14:53.064Z | 2024-11-12T14:21:55.218Z |
5517435 | 5517435 | 20241110034335_mztzU | US0001 | 2024-11-11T14:14:23.986Z | 2024-11-12T14:21:41.333Z |
5516928 | 5516928 | 20241110022256_AzQG0 | US0001 | 2024-11-11T14:13:33.723Z | 2024-11-12T14:21:24.536Z |
5516540 | 5516540 | 20241110011613_kooDx | US0001 | 2024-11-11T14:13:07.368Z | 2024-11-12T14:21:10.276Z |
5516507 | 5516507 | 20241110010942_cu56E | US0001 | 2024-11-11T14:13:05.602Z | 2024-11-12T14:21:07.943Z |
5513819 | 5513819 | 20241110122417_lZiOY | US0001 | 2024-11-11T14:05:30.738Z | 2024-11-12T14:18:06.657Z |
5513728 | 5513728 | 20241110121016_H52tv | US0001 | 2024-11-11T14:05:23.479Z | 2024-11-12T14:18:06.623Z |
5513720 | 5513720 | 20241110121007_dy5nF | US0001 | 2024-11-11T14:05:22.896Z | 2024-11-12T14:18:06.620Z |
5513706 | 5513706 | 20241110120830_kPL6I | US0001 | 2024-11-11T14:05:20.433Z | 2024-11-12T14:18:06.615Z |
5513696 | 5513696 | 20241110120732_xHBjG | US0001 | 2024-11-11T14:05:18.297Z | 2024-11-12T14:18:06.611Z |
5513636 | 5513636 | 20241110115915_9eSIv | US0001 | 2024-11-11T14:05:03.859Z | 2024-11-12T14:18:06.586Z |
5513588 | 5513588 | 20241110115354_gencx | US0001 | 2024-11-11T14:04:55.774Z | 2024-11-12T14:18:06.567Z |
5513380 | 5513380 | 20241110112435_0lGx1 | US0001 | 2024-11-11T14:04:33.881Z | 2024-11-12T14:18:06.471Z |
5513247 | 5513247 | 20241110110425_KI2Lj | US0001 | 2024-11-11T14:04:14.250Z | 2024-11-12T14:18:06.411Z |
5513095 | 5513095 | 20241110103721_w8KeE | US0001 | 2024-11-11T14:03:52.993Z | 2024-11-12T14:18:06.346Z |
5513050 | 5513050 | 20241110102903_rqGvN | US0001 | 2024-11-11T14:03:48.605Z | 2024-11-12T14:18:06.325Z |
5512985 | 5512985 | 20241110101802_RfzVU | US0001 | 2024-11-11T14:03:42.725Z | 2024-11-12T14:18:06.296Z |
5512830 | 5512830 | 20241110095702_JozrB | US0001 | 2024-11-11T14:03:16.296Z | 2024-11-12T14:18:06.240Z |
5512793 | 5512793 | 20241110094835_JNWvm | US0001 | 2024-11-11T14:03:09.167Z | 2024-11-12T14:18:06.225Z |
5512788 | 5512788 | 20241110094808_XoiBN | US0001 | 2024-11-11T14:03:08.937Z | 2024-11-12T14:18:06.224Z |
5512707 | 5512707 | 20241110093431_auD7G | US0001 | 2024-11-11T14:03:00.154Z | 2024-11-12T14:18:06.189Z |
5512597 | 5512597 | 20241110091544_2a4r1 | US0001 | 2024-11-11T14:02:48.282Z | 2024-11-12T14:18:06.138Z |
5512469 | 5512469 | 20241110085544_B7pnc | US0001 | 2024-11-11T14:02:22.945Z | 2024-11-12T14:18:06.090Z |
5512389 | 5512389 | 20241110084209_jDAPj | US0001 | 2024-11-11T14:02:13.727Z | 2024-11-12T14:18:06.057Z |
5512335 | 5512335 | 20241110083355_URBQn | US0001 | 2024-11-11T14:02:08.299Z | 2024-11-12T14:18:06.037Z |
5512250 | 5512250 | 20241110082228_f2uCS | US0001 | 2024-11-11T14:01:57.526Z | 2024-11-12T14:18:06.000Z |
5512092 | 5512092 | 20241110075505_7ZdPB | US0001 | 2024-11-11T14:01:32.058Z | 2024-11-12T14:18:05.932Z |
5512039 | 5512039 | 20241110074715_6lTKz | US0001 | 2024-11-11T14:01:26.078Z | 2024-11-12T14:18:05.911Z |
5511993 | 5511993 | 20241110073935_y1Im0 | US0001 | 2024-11-11T14:01:21.019Z | 2024-11-12T14:18:05.892Z |
5511886 | 5511886 | 20241110071600_64Oc1 | US0001 | 2024-11-11T14:00:59.637Z | 2024-11-12T14:18:05.843Z |
5511734 | 5511734 | 20241110064801_DQGAC | US0001 | 2024-11-11T14:00:41.569Z | 2024-11-12T14:18:05.778Z |
5511621 | 5511621 | 20241110062901_aPZ5o | US0001 | 2024-11-11T14:00:21.739Z | 2024-11-12T14:18:05.725Z |
5511590 | 5511590 | 20241110061917_ECXVE | US0001 | 2024-11-11T14:00:15.743Z | 2024-11-12T14:18:05.704Z |
5511334 | 5511334 | 20241109054749_q2bZ0 | US0001 | 2024-11-10T14:16:41.192Z | 2024-11-12T14:23:48.501Z |
5511277 | 5511277 | 20241109053136_GesrP | US0001 | 2024-11-10T14:16:37.533Z | 2024-11-12T14:23:47.945Z |
5511203 | 5511203 | 20241109050335_2s4bg | US0001 | 2024-11-10T14:16:29.726Z | 2024-11-12T14:23:46.332Z |
5511191 | 5511191 | 20241109045951_cew31 | US0001 | 2024-11-10T14:16:28.456Z | 2024-11-12T14:23:46.043Z |
5511153 | 5511153 | 20241109044356_rhFbc | US0001 | 2024-11-10T14:16:21.353Z | 2024-11-12T14:23:45.634Z |
5511100 | 5511100 | 20241109042728_m2Idp | US0001 | 2024-11-10T14:16:14.746Z | 2024-11-12T14:23:44.884Z |
5511025 | 5511025 | 20241109040940_3ALxg | US0001 | 2024-11-10T14:16:06.285Z | 2024-11-12T14:23:43.435Z |
5511002 | 5511002 | 20241109040634_6HFBK | US0001 | 2024-11-10T14:16:02.875Z | 2024-11-12T14:23:43.130Z |
5510976 | 5510976 | 20241109040134_DhkLM | US0001 | 2024-11-10T14:16:00.742Z | 2024-11-12T14:23:42.930Z |
5510971 | 5510971 | 20241109040114_mdJxr | US0001 | 2024-11-10T14:16:00.354Z | 2024-11-12T14:23:42.920Z |
5510834 | 5510834 | 20241109034220_vl6xn | US0001 | 2024-11-10T14:15:45.623Z | 2024-11-12T14:23:41.506Z |
5510695 | 5510695 | 20241109032719_RnfT3 | US0001 | 2024-11-10T14:15:34.658Z | 2024-11-12T14:23:39.687Z |
5510213 | 5510213 | 20241109020039_KD5zb | US0001 | 2024-11-10T14:14:48.269Z | 2024-11-12T14:23:32.210Z |
5510193 | 5510193 | 20241109015726_hZkmi | US0001 | 2024-11-10T14:14:46.474Z | 2024-11-12T14:23:31.832Z |
5507636 | 5507636 | 20241109120302_Ws2Av | US0001 | 2024-11-10T14:05:40.772Z | 2024-11-12T14:19:05.278Z |
5507590 | 5507590 | 20241109115616_ghkLa | US0001 | 2024-11-10T14:05:35.957Z | 2024-11-12T14:19:03.424Z |
5507407 | 5507407 | 20241109112447_HAxle | US0001 | 2024-11-10T14:05:01.237Z | 2024-11-12T14:18:55.685Z |
5507399 | 5507399 | 20241109112348_PBfDK | US0001 | 2024-11-10T14:05:00.953Z | 2024-11-12T14:18:55.619Z |
5507378 | 5507378 | 20241109112218_cVcfc | US0001 | 2024-11-10T14:04:58.991Z | 2024-11-12T14:18:55.010Z |
5507246 | 5507246 | 20241109105707_03om5 | US0001 | 2024-11-10T14:04:42.348Z | 2024-11-12T14:18:50.596Z |
5507184 | 5507184 | 20241109104927_HBwBt | US0001 | 2024-11-10T14:04:36.403Z | 2024-11-12T14:18:49.678Z |
5507098 | 5507098 | 20241109102902_3DkLt | US0001 | 2024-11-10T14:04:15.762Z | 2024-11-12T14:18:46.080Z |
5506974 | 5506974 | 20241109100852_DRmYP | US0001 | 2024-11-10T14:03:59.008Z | 2024-11-12T14:18:42.327Z |
5506793 | 5506793 | 20241109093604_bKo5m | US0001 | 2024-11-10T14:03:20.996Z | 2024-11-12T14:18:34.063Z |
5506791 | 5506791 | 20241109093604_lPK22 | US0001 | 2024-11-10T14:03:20.780Z | 2024-11-12T14:18:33.980Z |
5506675 | 5506675 | 20241109091946_o2Grw | US0001 | 2024-11-10T14:03:02.671Z | 2024-11-12T14:18:29.721Z |
5506616 | 5506616 | 20241109091000_iPVIH | US0001 | 2024-11-10T14:02:43.080Z | 2024-11-12T14:18:26.837Z |
5506610 | 5506610 | 20241109090838_Yxvgo | US0001 | 2024-11-10T14:02:42.259Z | 2024-11-12T14:18:26.697Z |
5506548 | 5506548 | 20241109085642_9qgCZ | US0001 | 2024-11-10T14:02:32.500Z | 2024-11-12T14:18:25.639Z |
5506334 | 5506334 | 20241109082125_CU4S2 | US0001 | 2024-11-10T14:01:51.373Z | 2024-11-12T14:18:22.666Z |
5506292 | 5506292 | 20241109081540_EkuX5 | US0001 | 2024-11-10T14:01:45.754Z | 2024-11-12T14:18:22.046Z |
5506258 | 5506258 | 20241109080745_3slRZ | US0001 | 2024-11-10T14:01:41.656Z | 2024-11-12T14:18:21.698Z |
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);