participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,264 rows where station_code = "US004C" 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 |
---|---|---|---|---|---|
5497944 | 5497944 | 20241107061600_UpbLQ | US004C | 2024-11-08T14:14:31.623Z | 2024-11-09T14:18:54.116Z |
5497941 | 5497941 | 20241107061505_qP3BY | US004C | 2024-11-08T14:14:31.577Z | 2024-11-09T14:18:54.070Z |
5497919 | 5497919 | 20241107060534_2aIqi | US004C | 2024-11-08T14:14:30.694Z | 2024-11-09T14:18:53.672Z |
5497897 | 5497897 | 20241107055750_p6XnY | US004C | 2024-11-08T14:14:29.587Z | 2024-11-09T14:18:53.431Z |
5497880 | 5497880 | 20241107054315_aYJYc | US004C | 2024-11-08T14:14:28.798Z | 2024-11-09T14:18:53.074Z |
5497739 | 5497739 | 20241107045153_uj3cI | US004C | 2024-11-08T14:14:17.345Z | 2024-11-09T14:18:51.238Z |
5497737 | 5497737 | 20241107045133_325RI | US004C | 2024-11-08T14:14:17.255Z | 2024-11-09T14:18:51.230Z |
5497723 | 5497723 | 20241107044334_UzO91 | US004C | 2024-11-08T14:14:15.724Z | 2024-11-09T14:18:51.044Z |
5497718 | 5497718 | 20241107044302_bHPis | US004C | 2024-11-08T14:14:15.588Z | 2024-11-09T14:18:50.998Z |
5497708 | 5497708 | 20241107044056_5FEli | US004C | 2024-11-08T14:14:15.206Z | 2024-11-09T14:18:50.947Z |
5497703 | 5497703 | 20241107043743_uh27N | US004C | 2024-11-08T14:14:13.866Z | 2024-11-09T14:18:50.891Z |
5497592 | 5497592 | 20241107040712_nzXx6 | US004C | 2024-11-08T14:14:00.927Z | 2024-11-09T14:18:46.776Z |
5497530 | 5497530 | 20241107035616_Dl0wT | US004C | 2024-11-08T14:13:56.203Z | 2024-11-09T14:18:45.199Z |
5497235 | 5497235 | 20241107030207_MFJwh | US004C | 2024-11-08T14:13:25.443Z | 2024-11-09T14:18:37.863Z |
5497038 | 5497038 | 20241107023217_Dbb2e | US004C | 2024-11-08T14:13:06.942Z | 2024-11-09T14:18:34.634Z |
5493003 | 5493003 | 20241107103402_jNLSS | US004C | 2024-11-08T14:02:41.559Z | 2024-11-09T14:16:27.504Z |
5492864 | 5492864 | 20241107100928_vodu9 | US004C | 2024-11-08T14:02:18.653Z | 2024-11-09T14:16:27.472Z |
5492852 | 5492852 | 20241107100716_D6sd2 | US004C | 2024-11-08T14:02:15.338Z | 2024-11-09T14:16:27.469Z |
5492833 | 5492833 | 20241107100136_XkT7W | US004C | 2024-11-08T14:02:10.811Z | 2024-11-09T14:16:27.464Z |
5492802 | 5492802 | 20241107095730_2LlCT | US004C | 2024-11-08T14:02:07.482Z | 2024-11-09T14:16:27.457Z |
5492748 | 5492748 | 20241107094912_ZcGH6 | US004C | 2024-11-08T14:02:01.449Z | 2024-11-09T14:16:27.445Z |
5492745 | 5492745 | 20241107094850_Ktkw2 | US004C | 2024-11-08T14:02:01.183Z | 2024-11-09T14:16:27.444Z |
5492732 | 5492732 | 20241107094638_0jOPY | US004C | 2024-11-08T14:01:59.436Z | 2024-11-09T14:16:27.440Z |
5492687 | 5492687 | 20241107093219_aP5Hq | US004C | 2024-11-08T14:01:53.893Z | 2024-11-09T14:16:27.429Z |
5492667 | 5492667 | 20241107092927_HkD4L | US004C | 2024-11-08T14:01:51.409Z | 2024-11-09T14:16:27.424Z |
5492635 | 5492635 | 20241107092138_nrIYi | US004C | 2024-11-08T14:01:40.863Z | 2024-11-09T14:16:27.417Z |
5492627 | 5492627 | 20241107092016_IBF3V | US004C | 2024-11-08T14:01:38.610Z | 2024-11-09T14:16:27.415Z |
5492592 | 5492592 | 20241107091218_uBHdU | US004C | 2024-11-08T14:01:30.958Z | 2024-11-09T14:16:27.408Z |
5492570 | 5492570 | 20241107090620_cFdbI | US004C | 2024-11-08T14:01:28.065Z | 2024-11-09T14:16:27.403Z |
5492520 | 5492520 | 20241107084903_xS7BF | US004C | 2024-11-08T14:01:20.456Z | 2024-11-09T14:16:27.391Z |
5492498 | 5492498 | 20241107084347_FYUMI | US004C | 2024-11-08T14:01:17.866Z | 2024-11-09T14:16:27.386Z |
5492486 | 5492486 | 20241107084208_siClx | US004C | 2024-11-08T14:01:16.411Z | 2024-11-09T14:16:27.383Z |
5492469 | 5492469 | 20241107083957_zSHMo | US004C | 2024-11-08T14:01:15.110Z | 2024-11-09T14:16:27.381Z |
5492465 | 5492465 | 20241107083941_3qNSY | US004C | 2024-11-08T14:01:14.437Z | 2024-11-09T14:16:27.379Z |
5492432 | 5492432 | 20241107083232_WUWbC | US004C | 2024-11-08T14:01:06.817Z | 2024-11-09T14:16:27.371Z |
5492416 | 5492416 | 20241107083047_tQyEF | US004C | 2024-11-08T14:01:01.880Z | 2024-11-09T14:16:27.368Z |
5492353 | 5492353 | 20241107081345_ImJ4F | US004C | 2024-11-08T14:00:51.285Z | 2024-11-09T14:16:27.352Z |
5492341 | 5492341 | 20241107081146_V6H22 | US004C | 2024-11-08T14:00:49.663Z | 2024-11-09T14:16:27.349Z |
5492248 | 5492248 | 20241107074537_YVMU0 | US004C | 2024-11-08T14:00:36.831Z | 2024-11-09T14:16:27.328Z |
5492212 | 5492212 | 20241107073041_ot6zn | US004C | 2024-11-08T14:00:30.516Z | 2024-11-09T14:16:27.316Z |
5492170 | 5492170 | 20241107071859_dh37E | US004C | 2024-11-08T14:00:23.112Z | 2024-11-09T14:16:27.302Z |
5492162 | 5492162 | 20241107071715_lvZpf | US004C | 2024-11-08T14:00:21.711Z | 2024-11-09T14:16:27.299Z |
5492139 | 5492139 | 20241107070443_cTbFq | US004C | 2024-11-08T14:00:17.957Z | 2024-11-09T14:16:27.289Z |
5491907 | 5491907 | 20241106061337_8aEsu | US004C | 2024-11-07T14:17:19.139Z | 2024-11-09T14:20:16.038Z |
5491897 | 5491897 | 20241106060643_5YBti | US004C | 2024-11-07T14:17:18.654Z | 2024-11-09T14:20:15.924Z |
5491876 | 5491876 | 20241106054952_aXkUT | US004C | 2024-11-07T14:17:16.026Z | 2024-11-09T14:20:15.740Z |
5491874 | 5491874 | 20241106054839_0N8sE | US004C | 2024-11-07T14:17:15.954Z | 2024-11-09T14:20:15.497Z |
5491869 | 5491869 | 20241106054505_x7rLS | US004C | 2024-11-07T14:17:14.780Z | 2024-11-09T14:20:15.479Z |
5491858 | 5491858 | 20241106053601_rIsZ3 | US004C | 2024-11-07T14:17:13.119Z | 2024-11-09T14:20:15.446Z |
5491836 | 5491836 | 20241106053031_jq5ET | US004C | 2024-11-07T14:17:08.427Z | 2024-11-09T14:20:15.279Z |
5491823 | 5491823 | 20241106052143_zbEX9 | US004C | 2024-11-07T14:17:04.841Z | 2024-11-09T14:20:14.973Z |
5491797 | 5491797 | 20241106051137_ICFGG | US004C | 2024-11-07T14:17:00.422Z | 2024-11-09T14:20:14.743Z |
5491794 | 5491794 | 20241106051101_Z7A8H | US004C | 2024-11-07T14:17:00.368Z | 2024-11-09T14:20:14.742Z |
5491781 | 5491781 | 20241106050720_kN4W3 | US004C | 2024-11-07T14:16:57.701Z | 2024-11-09T14:20:14.609Z |
5491745 | 5491745 | 20241106045323_k7um2 | US004C | 2024-11-07T14:16:53.797Z | 2024-11-09T14:20:14.078Z |
5491737 | 5491737 | 20241106045026_tLRVo | US004C | 2024-11-07T14:16:52.646Z | 2024-11-09T14:20:14.043Z |
5491672 | 5491672 | 20241106042232_MCujM | US004C | 2024-11-07T14:16:43.627Z | 2024-11-09T14:20:12.671Z |
5491626 | 5491626 | 20241106040615_d2Z53 | US004C | 2024-11-07T14:16:32.531Z | 2024-11-09T14:20:12.026Z |
5491617 | 5491617 | 20241106040340_GVxyH | US004C | 2024-11-07T14:16:31.119Z | 2024-11-09T14:20:11.912Z |
5491559 | 5491559 | 20241106034747_9Ab2K | US004C | 2024-11-07T14:16:23.066Z | 2024-11-09T14:20:10.808Z |
5491508 | 5491508 | 20241106032945_qDV2F | US004C | 2024-11-07T14:16:15.933Z | 2024-11-09T14:20:09.799Z |
5491305 | 5491305 | 20241106025230_OU99S | US004C | 2024-11-07T14:15:49.892Z | 2024-11-09T14:20:06.500Z |
5491278 | 5491278 | 20241106024641_p4FH6 | US004C | 2024-11-07T14:15:46.184Z | 2024-11-09T14:20:06.300Z |
5490994 | 5490994 | 20241106013323_WrtJJ | US004C | 2024-11-07T14:15:10.751Z | 2024-11-09T14:20:02.733Z |
5486509 | 5486509 | 20241106115448_u1omj | US004C | 2024-11-07T14:03:15.075Z | 2024-11-09T14:16:49.339Z |
5486423 | 5486423 | 20241106113331_mfFwj | US004C | 2024-11-07T14:02:55.977Z | 2024-11-09T14:16:46.053Z |
5486360 | 5486360 | 20241106110644_2YmSZ | US004C | 2024-11-07T14:02:42.745Z | 2024-11-09T14:16:43.579Z |
5486327 | 5486327 | 20241106104802_bVWxK | US004C | 2024-11-07T14:02:37.791Z | 2024-11-09T14:16:42.689Z |
5486252 | 5486252 | 20241106101445_F7eaN | US004C | 2024-11-07T14:02:20.222Z | 2024-11-09T14:16:40.269Z |
5486114 | 5486114 | 20241106094327_0IaAe | US004C | 2024-11-07T14:01:54.185Z | 2024-11-09T14:16:38.135Z |
5486098 | 5486098 | 20241106093343_w32s0 | US004C | 2024-11-07T14:01:48.098Z | 2024-11-09T14:16:37.785Z |
5486072 | 5486072 | 20241106092733_iJ5r3 | US004C | 2024-11-07T14:01:43.982Z | 2024-11-09T14:16:37.410Z |
5486048 | 5486048 | 20241106092154_Ko1MP | US004C | 2024-11-07T14:01:39.375Z | 2024-11-09T14:16:36.937Z |
5486045 | 5486045 | 20241106092125_1hGrT | US004C | 2024-11-07T14:01:38.899Z | 2024-11-09T14:16:36.828Z |
5486007 | 5486007 | 20241106090553_vQKi2 | US004C | 2024-11-07T14:01:28.264Z | 2024-11-09T14:16:35.996Z |
5485947 | 5485947 | 20241106085305_AaYk1 | US004C | 2024-11-07T14:01:14.521Z | 2024-11-09T14:16:34.971Z |
5485924 | 5485924 | 20241106083449_f75z3 | US004C | 2024-11-07T14:01:10.115Z | 2024-11-09T14:16:34.656Z |
5485920 | 5485920 | 20241106083430_XbSqx | US004C | 2024-11-07T14:01:09.267Z | 2024-11-09T14:16:34.593Z |
5485895 | 5485895 | 20241106082147_3C7r4 | US004C | 2024-11-07T14:01:02.441Z | 2024-11-09T14:16:34.157Z |
5485883 | 5485883 | 20241106081436_lWDa2 | US004C | 2024-11-07T14:01:00.195Z | 2024-11-09T14:16:33.946Z |
5485881 | 5485881 | 20241106081435_sItU9 | US004C | 2024-11-07T14:00:59.754Z | 2024-11-09T14:16:33.889Z |
5485864 | 5485864 | 20241106080635_52Kez | US004C | 2024-11-07T14:00:53.358Z | 2024-11-09T14:16:33.701Z |
5485812 | 5485812 | 20241106073919_nlWyV | US004C | 2024-11-07T14:00:42.778Z | 2024-11-09T14:16:32.896Z |
5485796 | 5485796 | 20241106073040_DQZnj | US004C | 2024-11-07T14:00:39.208Z | 2024-11-09T14:16:32.531Z |
5485770 | 5485770 | 20241106072403_34MX3 | US004C | 2024-11-07T14:00:34.973Z | 2024-11-09T14:16:32.069Z |
5485730 | 5485730 | 20241106070548_XhlLW | US004C | 2024-11-07T14:00:25.174Z | 2024-11-09T14:16:31.186Z |
5485724 | 5485724 | 20241106070026_qPrcO | US004C | 2024-11-07T14:00:23.929Z | 2024-11-09T14:16:31.101Z |
5485698 | 5485698 | 20241106064650_Emw9V | US004C | 2024-11-07T14:00:18.221Z | 2024-11-09T14:16:30.824Z |
5470783 | 5470783 | 20241104094709_nlKBZ | US004C | 2024-11-05T14:01:51.337Z | 2024-11-09T14:20:25.155Z |
5459487 | 5459487 | 20241101110735_JQDPX | US004C | 2024-11-03T14:12:00.701Z | 2024-11-09T14:23:18.321Z |
5459400 | 5459400 | 20241101105524_GqaQS | US004C | 2024-11-03T14:11:49.362Z | 2024-11-09T14:23:17.732Z |
5459308 | 5459308 | 20241101104027_okHvX | US004C | 2024-11-03T14:11:41.213Z | 2024-11-09T14:23:17.349Z |
5459048 | 5459048 | 20241101100200_8ju6i | US004C | 2024-11-03T14:11:06.440Z | 2024-11-09T14:23:16.026Z |
5458937 | 5458937 | 20241101094601_IiVw6 | US004C | 2024-11-03T14:10:50.972Z | 2024-11-09T14:23:15.298Z |
5458784 | 5458784 | 20241101091828_qI53G | US004C | 2024-11-03T14:10:37.056Z | 2024-11-09T14:23:14.449Z |
5458777 | 5458777 | 20241101091751_cZIdk | US004C | 2024-11-03T14:10:36.455Z | 2024-11-09T14:23:14.438Z |
5458773 | 5458773 | 20241101091717_0dszH | US004C | 2024-11-03T14:10:35.782Z | 2024-11-09T14:23:14.402Z |
5458524 | 5458524 | 20241101083749_EunIZ | US004C | 2024-11-03T14:09:55.022Z | 2024-11-09T14:23:12.764Z |
5458489 | 5458489 | 20241101083500_ZXlc3 | US004C | 2024-11-03T14:09:50.815Z | 2024-11-09T14:23:12.480Z |
5453032 | 5453032 | 20241101064918_G36lN | US004C | 2024-11-02T12:19:42.367Z | 2024-11-09T14:24:37.983Z |
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);