participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
25,467 rows where station_code = "USL004" 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 |
---|---|---|---|---|---|
5130312 | 5130312 | 20240917111301_EF3dh | USL004 | 2024-09-19T12:12:58.979Z | 2024-09-19T12:12:58.979Z |
5130307 | 5130307 | 20240917111133_AocNU | USL004 | 2024-09-19T12:12:58.337Z | 2024-09-19T12:12:58.337Z |
5130286 | 5130286 | 20240917110453_IBt25 | USL004 | 2024-09-19T12:12:56.246Z | 2024-09-19T12:12:56.246Z |
5130248 | 5130248 | 20240917104642_wjYtg | USL004 | 2024-09-19T12:12:51.254Z | 2024-09-19T12:12:51.254Z |
5130235 | 5130235 | 20240917103532_2c2rK | USL004 | 2024-09-19T12:12:49.329Z | 2024-09-19T12:12:49.329Z |
5130204 | 5130204 | 20240917101939_07rht | USL004 | 2024-09-19T12:12:46.317Z | 2024-09-19T12:12:46.317Z |
5130197 | 5130197 | 20240917101520_CR7AM | USL004 | 2024-09-19T12:12:45.722Z | 2024-09-19T12:12:45.722Z |
5130162 | 5130162 | 20240917095246_iLU8R | USL004 | 2024-09-19T12:12:42.151Z | 2024-09-19T12:12:42.151Z |
5130147 | 5130147 | 20240917093424_oChzf | USL004 | 2024-09-19T12:12:40.177Z | 2024-09-19T12:12:40.177Z |
5130125 | 5130125 | 20240917091749_pmK6x | USL004 | 2024-09-19T12:12:37.954Z | 2024-09-19T12:12:37.954Z |
5130121 | 5130121 | 20240917091648_oc6tx | USL004 | 2024-09-19T12:12:37.034Z | 2024-09-19T12:12:37.034Z |
5130079 | 5130079 | 20240917084811_xs5RF | USL004 | 2024-09-19T12:12:32.771Z | 2024-09-19T12:12:32.771Z |
5130046 | 5130046 | 20240917082911_JQV2F | USL004 | 2024-09-19T12:12:29.429Z | 2024-09-19T12:12:29.429Z |
5130009 | 5130009 | 20240917075021_fuyX8 | USL004 | 2024-09-19T12:12:25.431Z | 2024-09-19T12:12:25.431Z |
5130002 | 5130002 | 20240917074230_3VKPr | USL004 | 2024-09-19T12:12:25.030Z | 2024-09-19T12:12:25.030Z |
5129996 | 5129996 | 20240917073951_MoiQX | USL004 | 2024-09-19T12:12:24.459Z | 2024-09-19T12:12:24.459Z |
5129937 | 5129937 | 20240917063955_hC6ub | USL004 | 2024-09-19T12:12:18.246Z | 2024-09-19T12:12:18.246Z |
5129926 | 5129926 | 20240917062555_7wMPZ | USL004 | 2024-09-19T12:12:17.712Z | 2024-09-19T12:12:17.712Z |
5129635 | 5129635 | 20240917041548_Ws3ae | USL004 | 2024-09-19T12:11:56.459Z | 2024-09-19T12:11:56.459Z |
5108375 | 5108375 | 20240913051419_zSJsA | USL004 | 2024-09-17T12:13:41.834Z | 2024-09-19T12:20:48.536Z |
5108361 | 5108361 | 20240913050207_3JXcf | USL004 | 2024-09-17T12:13:38.567Z | 2024-09-19T12:20:48.420Z |
5108308 | 5108308 | 20240913044842_ElbEz | USL004 | 2024-09-17T12:13:36.139Z | 2024-09-19T12:20:48.116Z |
5108297 | 5108297 | 20240913044614_8TvTq | USL004 | 2024-09-17T12:13:35.321Z | 2024-09-19T12:20:48.050Z |
5108290 | 5108290 | 20240913044556_2uciR | USL004 | 2024-09-17T12:13:35.128Z | 2024-09-19T12:20:48.020Z |
5108036 | 5108036 | 20240913042048_A45YE | USL004 | 2024-09-17T12:13:28.990Z | 2024-09-19T12:20:47.776Z |
5096882 | 5096882 | 20240912120210_Y3WwD | USL004 | 2024-09-16T12:16:36.601Z | 2024-09-19T12:21:24.055Z |
5096874 | 5096874 | 20240912120128_BZ8iw | USL004 | 2024-09-16T12:16:36.542Z | 2024-09-19T12:21:24.049Z |
5096861 | 5096861 | 20240912120027_Stbf8 | USL004 | 2024-09-16T12:16:36.330Z | 2024-09-19T12:21:24.033Z |
5096855 | 5096855 | 20240912115814_OQg78 | USL004 | 2024-09-16T12:16:36.136Z | 2024-09-19T12:21:24.028Z |
5096833 | 5096833 | 20240912115520_Md4Vc | USL004 | 2024-09-16T12:16:35.546Z | 2024-09-19T12:21:24.006Z |
5096821 | 5096821 | 20240912115424_ly2K1 | USL004 | 2024-09-16T12:16:35.371Z | 2024-09-19T12:21:23.974Z |
5096792 | 5096792 | 20240912114319_bIk3I | USL004 | 2024-09-16T12:16:34.789Z | 2024-09-19T12:21:23.733Z |
5096783 | 5096783 | 20240912114207_m2WkG | USL004 | 2024-09-16T12:16:34.645Z | 2024-09-19T12:21:23.705Z |
5096718 | 5096718 | 20240912113408_BPE7q | USL004 | 2024-09-16T12:16:32.505Z | 2024-09-19T12:21:23.504Z |
5096695 | 5096695 | 20240912113103_QuZ1Q | USL004 | 2024-09-16T12:16:31.960Z | 2024-09-19T12:21:23.447Z |
5096669 | 5096669 | 20240912112809_TbXyZ | USL004 | 2024-09-16T12:16:31.190Z | 2024-09-19T12:21:23.394Z |
5096661 | 5096661 | 20240912112737_UF8u0 | USL004 | 2024-09-16T12:16:31.035Z | 2024-09-19T12:21:23.379Z |
5096623 | 5096623 | 20240912112517_GWyUh | USL004 | 2024-09-16T12:16:30.001Z | 2024-09-19T12:21:23.301Z |
5096607 | 5096607 | 20240912112223_UGcEs | USL004 | 2024-09-16T12:16:29.561Z | 2024-09-19T12:21:23.202Z |
5096573 | 5096573 | 20240912111538_SyPrl | USL004 | 2024-09-16T12:16:27.844Z | 2024-09-19T12:21:22.895Z |
5096569 | 5096569 | 20240912111319_F9ufE | USL004 | 2024-09-16T12:16:27.587Z | 2024-09-19T12:21:22.803Z |
5096531 | 5096531 | 20240912110857_QnwQc | USL004 | 2024-09-16T12:16:26.613Z | 2024-09-19T12:21:22.583Z |
5096445 | 5096445 | 20240912105351_H16q9 | USL004 | 2024-09-16T12:16:23.746Z | 2024-09-19T12:21:22.336Z |
5096418 | 5096418 | 20240912104914_eKPMo | USL004 | 2024-09-16T12:16:23.218Z | 2024-09-19T12:21:22.289Z |
5096400 | 5096400 | 20240912104545_4O4Q1 | USL004 | 2024-09-16T12:16:22.640Z | 2024-09-19T12:21:22.249Z |
5096359 | 5096359 | 20240912103847_vOzZZ | USL004 | 2024-09-16T12:16:21.362Z | 2024-09-19T12:21:22.193Z |
5096254 | 5096254 | 20240912102532_vvfLq | USL004 | 2024-09-16T12:16:17.418Z | 2024-09-19T12:21:21.982Z |
5096195 | 5096195 | 20240912101505_FKdKt | USL004 | 2024-09-16T12:16:14.427Z | 2024-09-19T12:21:21.842Z |
5096192 | 5096192 | 20240912101501_uIfWg | USL004 | 2024-09-16T12:16:14.315Z | 2024-09-19T12:21:21.838Z |
5096146 | 5096146 | 20240912100819_1WO5I | USL004 | 2024-09-16T12:16:11.798Z | 2024-09-19T12:21:21.751Z |
5096139 | 5096139 | 20240912100748_QPBCI | USL004 | 2024-09-16T12:16:11.758Z | 2024-09-19T12:21:21.747Z |
5096129 | 5096129 | 20240912100532_fdOAL | USL004 | 2024-09-16T12:16:11.472Z | 2024-09-19T12:21:21.642Z |
5096084 | 5096084 | 20240912095444_E5RVu | USL004 | 2024-09-16T12:16:08.943Z | 2024-09-19T12:21:21.332Z |
5096048 | 5096048 | 20240912094836_VtSw3 | USL004 | 2024-09-16T12:16:06.462Z | 2024-09-19T12:21:21.178Z |
5095980 | 5095980 | 20240912093825_REKrX | USL004 | 2024-09-16T12:16:04.269Z | 2024-09-19T12:21:20.804Z |
5095939 | 5095939 | 20240912092916_5urC6 | USL004 | 2024-09-16T12:16:02.465Z | 2024-09-19T12:21:20.678Z |
5095896 | 5095896 | 20240912092332_q3f37 | USL004 | 2024-09-16T12:16:01.556Z | 2024-09-19T12:21:20.626Z |
5095826 | 5095826 | 20240912090943_VadTl | USL004 | 2024-09-16T12:15:59.141Z | 2024-09-19T12:21:20.350Z |
5095820 | 5095820 | 20240912090932_YuPAO | USL004 | 2024-09-16T12:15:59.072Z | 2024-09-19T12:21:20.346Z |
5095805 | 5095805 | 20240912090832_RJJhU | USL004 | 2024-09-16T12:15:58.814Z | 2024-09-19T12:21:20.329Z |
5095799 | 5095799 | 20240912090734_mteLj | USL004 | 2024-09-16T12:15:58.594Z | 2024-09-19T12:21:20.320Z |
5095765 | 5095765 | 20240912085750_aR1Be | USL004 | 2024-09-16T12:15:57.508Z | 2024-09-19T12:21:20.108Z |
5095761 | 5095761 | 20240912085539_3B5UB | USL004 | 2024-09-16T12:15:56.630Z | 2024-09-19T12:21:20.069Z |
5095728 | 5095728 | 20240912084951_8GIt3 | USL004 | 2024-09-16T12:15:55.020Z | 2024-09-19T12:21:19.943Z |
5095673 | 5095673 | 20240912083803_gI2pE | USL004 | 2024-09-16T12:15:52.703Z | 2024-09-19T12:21:19.658Z |
5095667 | 5095667 | 20240912083637_HPL1g | USL004 | 2024-09-16T12:15:52.642Z | 2024-09-19T12:21:19.649Z |
5095641 | 5095641 | 20240912083325_sA3Ep | USL004 | 2024-09-16T12:15:51.933Z | 2024-09-19T12:21:19.580Z |
5095639 | 5095639 | 20240912083308_bsPzA | USL004 | 2024-09-16T12:15:51.882Z | 2024-09-19T12:21:19.554Z |
5095629 | 5095629 | 20240912083017_WstIn | USL004 | 2024-09-16T12:15:51.571Z | 2024-09-19T12:21:19.479Z |
5095613 | 5095613 | 20240912082907_AOKu2 | USL004 | 2024-09-16T12:15:51.277Z | 2024-09-19T12:21:19.376Z |
5095593 | 5095593 | 20240912081819_GfVX2 | USL004 | 2024-09-16T12:15:50.035Z | 2024-09-19T12:21:19.185Z |
5095570 | 5095570 | 20240912080810_VCYfq | USL004 | 2024-09-16T12:15:49.386Z | 2024-09-19T12:21:19.143Z |
5095529 | 5095529 | 20240912080002_umHV3 | USL004 | 2024-09-16T12:15:46.028Z | 2024-09-19T12:21:18.833Z |
5095522 | 5095522 | 20240912075821_LMBBe | USL004 | 2024-09-16T12:15:45.818Z | 2024-09-19T12:21:18.783Z |
5095481 | 5095481 | 20240912074537_rvQcG | USL004 | 2024-09-16T12:15:43.064Z | 2024-09-19T12:21:18.664Z |
5095464 | 5095464 | 20240912073955_DbkbN | USL004 | 2024-09-16T12:15:41.767Z | 2024-09-19T12:21:18.597Z |
5095390 | 5095390 | 20240912072745_yl8X1 | USL004 | 2024-09-16T12:15:38.334Z | 2024-09-19T12:21:18.397Z |
5095355 | 5095355 | 20240912072124_EtimU | USL004 | 2024-09-16T12:15:35.515Z | 2024-09-19T12:21:18.202Z |
5095335 | 5095335 | 20240912071922_onrgW | USL004 | 2024-09-16T12:15:33.466Z | 2024-09-19T12:21:18.175Z |
5095323 | 5095323 | 20240912071406_jqFIL | USL004 | 2024-09-16T12:15:32.453Z | 2024-09-19T12:21:18.136Z |
5095279 | 5095279 | 20240912065941_AHcAe | USL004 | 2024-09-16T12:15:29.355Z | 2024-09-19T12:21:17.923Z |
5095271 | 5095271 | 20240912065724_uGZkQ | USL004 | 2024-09-16T12:15:28.872Z | 2024-09-19T12:21:17.903Z |
5095254 | 5095254 | 20240912065331_m6eEJ | USL004 | 2024-09-16T12:15:28.244Z | 2024-09-19T12:21:17.756Z |
5095198 | 5095198 | 20240912063246_ow0XI | USL004 | 2024-09-16T12:15:21.812Z | 2024-09-19T12:21:17.474Z |
5095187 | 5095187 | 20240912063043_FMI4m | USL004 | 2024-09-16T12:15:21.336Z | 2024-09-19T12:21:17.458Z |
5095180 | 5095180 | 20240912062914_sD8PT | USL004 | 2024-09-16T12:15:20.735Z | 2024-09-19T12:21:17.453Z |
5095060 | 5095060 | 20240912053422_He8TW | USL004 | 2024-09-16T12:15:12.178Z | 2024-09-19T12:21:17.160Z |
5095038 | 5095038 | 20240912052035_MxvBy | USL004 | 2024-09-16T12:15:10.734Z | 2024-09-19T12:21:17.052Z |
5095019 | 5095019 | 20240912051436_ZCcIJ | USL004 | 2024-09-16T12:15:09.745Z | 2024-09-19T12:21:16.980Z |
5095004 | 5095004 | 20240912050756_nS3Km | USL004 | 2024-09-16T12:15:08.801Z | 2024-09-19T12:21:16.923Z |
5094991 | 5094991 | 20240912050610_whFgs | USL004 | 2024-09-16T12:15:08.058Z | 2024-09-19T12:21:16.890Z |
5094944 | 5094944 | 20240912044751_oPUMl | USL004 | 2024-09-16T12:15:02.552Z | 2024-09-19T12:21:16.617Z |
5093202 | 5093202 | 20240912031502_dHyXE | USL004 | 2024-09-16T12:14:13.311Z | 2024-09-19T12:21:15.019Z |
5092150 | 5092150 | 20240912023813_VWKxf | USL004 | 2024-09-16T12:13:42.072Z | 2024-09-19T12:21:13.674Z |
5082871 | 5082871 | 20240911111623_nf672 | USL004 | 2024-09-15T12:18:27.946Z | 2024-09-19T12:21:48.798Z |
5082771 | 5082771 | 20240911105629_ceOOg | USL004 | 2024-09-15T12:18:25.212Z | 2024-09-19T12:21:48.653Z |
5082757 | 5082757 | 20240911105617_q72rt | USL004 | 2024-09-15T12:18:24.881Z | 2024-09-19T12:21:48.564Z |
5082753 | 5082753 | 20240911105541_agmE2 | USL004 | 2024-09-15T12:18:24.845Z | 2024-09-19T12:21:48.526Z |
5082710 | 5082710 | 20240911104841_D6EMZ | USL004 | 2024-09-15T12:18:23.358Z | 2024-09-19T12:21:48.436Z |
5082706 | 5082706 | 20240911104801_gD6RL | USL004 | 2024-09-15T12:18:22.991Z | 2024-09-19T12:21:48.375Z |
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);