participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "US000K" 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 |
---|---|---|---|---|---|
5524850 | 5524850 | 20241111060239_mHwv2 | US000K | 2024-11-12T14:18:03.591Z | 2024-11-12T14:18:08.803Z |
5524772 | 5524772 | 20241111053526_0l6pS | US000K | 2024-11-12T14:18:00.581Z | 2024-11-12T14:18:08.772Z |
5524695 | 5524695 | 20241111051320_ZWv2S | US000K | 2024-11-12T14:17:55.724Z | 2024-11-12T14:18:08.740Z |
5518557 | 5518557 | 20241111081539_qVp3U | US000K | 2024-11-12T14:01:19.003Z | 2024-11-12T14:01:19.003Z |
5518273 | 5518273 | 20241111064648_l3hiZ | US000K | 2024-11-12T14:00:25.884Z | 2024-11-12T14:00:25.884Z |
5518081 | 5518081 | 20241110055411_MrDNE | US000K | 2024-11-11T14:15:11.814Z | 2024-11-12T14:22:01.675Z |
5518020 | 5518020 | 20241110054013_Fo9oG | US000K | 2024-11-11T14:15:08.252Z | 2024-11-12T14:22:00.423Z |
5517964 | 5517964 | 20241110052446_R5UI3 | US000K | 2024-11-11T14:15:05.317Z | 2024-11-12T14:21:59.653Z |
5517680 | 5517680 | 20241110042712_jthDq | US000K | 2024-11-11T14:14:44.189Z | 2024-11-12T14:21:51.622Z |
5517642 | 5517642 | 20241110041753_R2Iq5 | US000K | 2024-11-11T14:14:41.642Z | 2024-11-12T14:21:50.175Z |
5517498 | 5517498 | 20241110035424_UuVXL | US000K | 2024-11-11T14:14:30.220Z | 2024-11-12T14:21:44.041Z |
5516582 | 5516582 | 20241110012402_l6TK7 | US000K | 2024-11-11T14:13:09.734Z | 2024-11-12T14:21:12.596Z |
5513887 | 5513887 | 20241110123756_qSwuw | US000K | 2024-11-11T14:05:35.770Z | 2024-11-12T14:18:06.689Z |
5513841 | 5513841 | 20241110122641_IxcUz | US000K | 2024-11-11T14:05:31.989Z | 2024-11-12T14:18:06.665Z |
5513814 | 5513814 | 20241110122314_axUuM | US000K | 2024-11-11T14:05:30.118Z | 2024-11-12T14:18:06.654Z |
5513777 | 5513777 | 20241110122045_f3It9 | US000K | 2024-11-11T14:05:27.429Z | 2024-11-12T14:18:06.643Z |
5513710 | 5513710 | 20241110120830_kPL6I | US000K | 2024-11-11T14:05:20.434Z | 2024-11-12T14:18:06.615Z |
5513647 | 5513647 | 20241110120038_TIqbu | US000K | 2024-11-11T14:05:05.998Z | 2024-11-12T14:18:06.589Z |
5513598 | 5513598 | 20241110115456_SrtHM | US000K | 2024-11-11T14:04:56.499Z | 2024-11-12T14:18:06.569Z |
5513577 | 5513577 | 20241110114948_3sBtI | US000K | 2024-11-11T14:04:52.283Z | 2024-11-12T14:18:06.556Z |
5513234 | 5513234 | 20241110110136_VcM6q | US000K | 2024-11-11T14:04:12.042Z | 2024-11-12T14:18:06.404Z |
5513203 | 5513203 | 20241110105640_W7rVN | US000K | 2024-11-11T14:04:08.220Z | 2024-11-12T14:18:06.393Z |
5513189 | 5513189 | 20241110105316_aRWxL | US000K | 2024-11-11T14:04:05.987Z | 2024-11-12T14:18:06.388Z |
5512967 | 5512967 | 20241110101615_Vxm46 | US000K | 2024-11-11T14:03:40.953Z | 2024-11-12T14:18:06.289Z |
5512924 | 5512924 | 20241110101246_bphOi | US000K | 2024-11-11T14:03:37.542Z | 2024-11-12T14:18:06.274Z |
5512855 | 5512855 | 20241110100052_KSC5C | US000K | 2024-11-11T14:03:18.684Z | 2024-11-12T14:18:06.247Z |
5512835 | 5512835 | 20241110095702_JozrB | US000K | 2024-11-11T14:03:16.297Z | 2024-11-12T14:18:06.240Z |
5512761 | 5512761 | 20241110094503_v2SI0 | US000K | 2024-11-11T14:03:05.999Z | 2024-11-12T14:18:06.213Z |
5512366 | 5512366 | 20241110083737_aQj5H | US000K | 2024-11-11T14:02:10.667Z | 2024-11-12T14:18:06.046Z |
5512253 | 5512253 | 20241110082228_f2uCS | US000K | 2024-11-11T14:01:57.526Z | 2024-11-12T14:18:06.000Z |
5512206 | 5512206 | 20241110081450_NvSO9 | US000K | 2024-11-11T14:01:42.871Z | 2024-11-12T14:18:05.976Z |
5512172 | 5512172 | 20241110080853_E53Ho | US000K | 2024-11-11T14:01:40.086Z | 2024-11-12T14:18:05.963Z |
5512130 | 5512130 | 20241110080104_Wklxf | US000K | 2024-11-11T14:01:35.251Z | 2024-11-12T14:18:05.945Z |
5512064 | 5512064 | 20241110074959_6DZzn | US000K | 2024-11-11T14:01:28.058Z | 2024-11-12T14:18:05.919Z |
5512053 | 5512053 | 20241110074741_ryX9J | US000K | 2024-11-11T14:01:27.011Z | 2024-11-12T14:18:05.915Z |
5511890 | 5511890 | 20241110071600_64Oc1 | US000K | 2024-11-11T14:00:59.637Z | 2024-11-12T14:18:05.843Z |
5511840 | 5511840 | 20241110070705_nJueB | US000K | 2024-11-11T14:00:54.898Z | 2024-11-12T14:18:05.825Z |
5511761 | 5511761 | 20241110065447_0aY3z | US000K | 2024-11-11T14:00:45.793Z | 2024-11-12T14:18:05.793Z |
5511338 | 5511338 | 20241109054749_q2bZ0 | US000K | 2024-11-10T14:16:41.192Z | 2024-11-12T14:23:48.501Z |
5511113 | 5511113 | 20241109042927_EAd63 | US000K | 2024-11-10T14:16:16.813Z | 2024-11-12T14:23:45.067Z |
5510154 | 5510154 | 20241109015021_w8w5N | US000K | 2024-11-10T14:14:40.333Z | 2024-11-12T14:23:31.208Z |
5507866 | 5507866 | 20241109124056_at8go | US000K | 2024-11-10T14:06:20.919Z | 2024-11-12T14:19:13.651Z |
5507831 | 5507831 | 20241109123354_8EOQa | US000K | 2024-11-10T14:06:17.031Z | 2024-11-12T14:19:12.442Z |
5507655 | 5507655 | 20241109120431_A5K3A | US000K | 2024-11-10T14:05:42.906Z | 2024-11-12T14:19:05.986Z |
5507613 | 5507613 | 20241109115758_aAk7V | US000K | 2024-11-10T14:05:37.236Z | 2024-11-12T14:19:03.893Z |
5507595 | 5507595 | 20241109115616_ghkLa | US000K | 2024-11-10T14:05:35.957Z | 2024-11-12T14:19:03.424Z |
5507522 | 5507522 | 20241109114313_NIqU3 | US000K | 2024-11-10T14:05:28.002Z | 2024-11-12T14:19:00.166Z |
5507495 | 5507495 | 20241109113757_MTP2x | US000K | 2024-11-10T14:05:24.659Z | 2024-11-12T14:18:59.084Z |
5507389 | 5507389 | 20241109112316_Uk9rl | US000K | 2024-11-10T14:04:59.776Z | 2024-11-12T14:18:55.407Z |
5507373 | 5507373 | 20241109112146_UOlUq | US000K | 2024-11-10T14:04:58.254Z | 2024-11-12T14:18:54.215Z |
5507253 | 5507253 | 20241109105707_03om5 | US000K | 2024-11-10T14:04:42.348Z | 2024-11-12T14:18:50.596Z |
5507188 | 5507188 | 20241109104927_HBwBt | US000K | 2024-11-10T14:04:36.403Z | 2024-11-12T14:18:49.678Z |
5507102 | 5507102 | 20241109102902_3DkLt | US000K | 2024-11-10T14:04:15.762Z | 2024-11-12T14:18:46.080Z |
5506822 | 5506822 | 20241109094244_hU9Fp | US000K | 2024-11-10T14:03:24.537Z | 2024-11-12T14:18:34.675Z |
5506798 | 5506798 | 20241109093604_bKo5m | US000K | 2024-11-10T14:03:20.996Z | 2024-11-12T14:18:34.063Z |
5506653 | 5506653 | 20241109091429_6j4RP | US000K | 2024-11-10T14:02:49.064Z | 2024-11-12T14:18:28.650Z |
5506634 | 5506634 | 20241109091058_xX05X | US000K | 2024-11-10T14:02:44.792Z | 2024-11-12T14:18:27.311Z |
5506380 | 5506380 | 20241109083207_fIPM3 | US000K | 2024-11-10T14:01:58.961Z | 2024-11-12T14:18:23.365Z |
5506306 | 5506306 | 20241109081819_hclAW | US000K | 2024-11-10T14:01:47.751Z | 2024-11-12T14:18:22.249Z |
5506278 | 5506278 | 20241109081103_NbmU2 | US000K | 2024-11-10T14:01:43.927Z | 2024-11-12T14:18:21.860Z |
5506253 | 5506253 | 20241109080420_PIpb2 | US000K | 2024-11-10T14:01:40.210Z | 2024-11-12T14:18:21.447Z |
5505849 | 5505849 | 20241109065055_II8hG | US000K | 2024-11-10T14:00:34.662Z | 2024-11-12T14:18:13.182Z |
5505725 | 5505725 | 20241109062513_34JoR | US000K | 2024-11-10T14:00:16.154Z | 2024-11-12T14:18:11.525Z |
5486234 | 5486234 | 20241106100956_Q6bJF | US000K | 2024-11-07T14:02:17.088Z | 2024-11-12T14:25:27.933Z |
5486153 | 5486153 | 20241106095349_0B23l | US000K | 2024-11-07T14:02:04.734Z | 2024-11-12T14:25:26.894Z |
5485525 | 5485525 | 20241105061754_tGP1f | US000K | 2024-11-06T14:18:24.985Z | 2024-11-12T14:27:39.131Z |
5478905 | 5478905 | 20241105065223_wIfa5 | US000K | 2024-11-06T14:00:18.951Z | 2024-11-12T14:26:18.602Z |
5478891 | 5478891 | 20241105064631_0HgbS | US000K | 2024-11-06T14:00:14.887Z | 2024-11-12T14:26:18.256Z |
5463961 | 5463961 | 20241102062120_9S0NX | US000K | 2024-11-03T14:19:27.035Z | 2024-11-10T14:26:37.399Z |
5463926 | 5463926 | 20241102061318_x9SBj | US000K | 2024-11-03T14:19:25.704Z | 2024-11-10T14:26:37.334Z |
5463861 | 5463861 | 20241102054630_00Vfg | US000K | 2024-11-03T14:19:21.176Z | 2024-11-10T14:26:37.012Z |
5463753 | 5463753 | 20241102045444_V0FFx | US000K | 2024-11-03T14:19:14.118Z | 2024-11-10T14:26:36.626Z |
5463730 | 5463730 | 20241102044650_AOVH0 | US000K | 2024-11-03T14:19:12.077Z | 2024-11-10T14:26:36.531Z |
5459964 | 5459964 | 20241101122433_alHg5 | US000K | 2024-11-03T14:12:58.809Z | 2024-11-10T14:26:21.788Z |
5459791 | 5459791 | 20241101115134_pj2YG | US000K | 2024-11-03T14:12:36.285Z | 2024-11-10T14:26:21.075Z |
5459784 | 5459784 | 20241101114938_MJ0oM | US000K | 2024-11-03T14:12:35.495Z | 2024-11-10T14:26:21.054Z |
5459686 | 5459686 | 20241101113726_Q6G8y | US000K | 2024-11-03T14:12:28.112Z | 2024-11-10T14:26:20.495Z |
5459003 | 5459003 | 20241101095704_bNb1C | US000K | 2024-11-03T14:10:57.706Z | 2024-11-10T14:26:17.440Z |
5458984 | 5458984 | 20241101095259_mWroP | US000K | 2024-11-03T14:10:54.747Z | 2024-11-10T14:26:17.370Z |
5458913 | 5458913 | 20241101094121_OsZF2 | US000K | 2024-11-03T14:10:48.696Z | 2024-11-10T14:26:16.969Z |
5458844 | 5458844 | 20241101092532_gWN18 | US000K | 2024-11-03T14:10:41.785Z | 2024-11-10T14:26:16.344Z |
5458757 | 5458757 | 20241101091300_qD4wY | US000K | 2024-11-03T14:10:34.309Z | 2024-11-10T14:26:15.546Z |
5458712 | 5458712 | 20241101090519_2hs8U | US000K | 2024-11-03T14:10:29.878Z | 2024-11-10T14:26:15.431Z |
5458698 | 5458698 | 20241101090412_fh3Hj | US000K | 2024-11-03T14:10:28.958Z | 2024-11-10T14:26:15.365Z |
5458485 | 5458485 | 20241101083452_2pDFd | US000K | 2024-11-03T14:09:50.412Z | 2024-11-10T14:26:14.001Z |
5458431 | 5458431 | 20241101082502_1n2fU | US000K | 2024-11-03T14:09:44.922Z | 2024-11-10T14:26:13.643Z |
5458386 | 5458386 | 20241101081905_r21FU | US000K | 2024-11-03T14:09:41.316Z | 2024-11-10T14:26:13.483Z |
5458290 | 5458290 | 20241101080033_ZQNh4 | US000K | 2024-11-03T14:09:29.782Z | 2024-11-10T14:26:12.811Z |
5456545 | 5456545 | 20241102114312_xLwEW | US000K | 2024-11-03T14:04:57.734Z | 2024-11-11T14:22:29.728Z |
5456109 | 5456109 | 20241102102234_Z0jHi | US000K | 2024-11-03T14:03:21.862Z | 2024-11-11T14:22:26.589Z |
5455754 | 5455754 | 20241102091139_Zfamx | US000K | 2024-11-03T14:02:13.209Z | 2024-11-11T14:22:24.289Z |
5455745 | 5455745 | 20241102091023_5oByE | US000K | 2024-11-03T14:02:08.952Z | 2024-11-11T14:22:24.028Z |
5455645 | 5455645 | 20241102084927_piqjJ | US000K | 2024-11-03T14:01:46.508Z | 2024-11-11T14:22:23.167Z |
5455425 | 5455425 | 20241102074257_3W25y | US000K | 2024-11-03T14:00:54.270Z | 2024-11-11T14:22:21.436Z |
5455411 | 5455411 | 20241102074034_0d78I | US000K | 2024-11-03T14:00:51.762Z | 2024-11-11T14:22:21.237Z |
5455327 | 5455327 | 20241102072138_iRCnb | US000K | 2024-11-03T14:00:33.677Z | 2024-11-11T14:22:20.468Z |
5455011 | 5455011 | 20241031060720_XBkne | US000K | 2024-11-02T12:23:29.544Z | 2024-11-08T14:23:26.829Z |
5454943 | 5454943 | 20241031055223_0k1Ly | US000K | 2024-11-02T12:23:27.340Z | 2024-11-08T14:23:26.361Z |
5454925 | 5454925 | 20241031054629_5CMxS | US000K | 2024-11-02T12:23:26.813Z | 2024-11-08T14:23:26.268Z |
5454194 | 5454194 | 20241031035442_xdFJd | US000K | 2024-11-02T12:22:54.272Z | 2024-11-08T14:23:21.036Z |
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);