participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
9,683 rows where station_code = "USL00K" 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 |
---|---|---|---|---|---|
5505571 | 5505571 | 20241108061153_ayqzt | USL00K | 2024-11-09T14:16:23.679Z | 2024-11-09T14:16:28.817Z |
5505568 | 5505568 | 20241108061051_x5xV2 | USL00K | 2024-11-09T14:16:23.602Z | 2024-11-09T14:16:28.816Z |
5505561 | 5505561 | 20241108060841_viytc | USL00K | 2024-11-09T14:16:23.381Z | 2024-11-09T14:16:28.815Z |
5505551 | 5505551 | 20241108060601_SagGr | USL00K | 2024-11-09T14:16:23.072Z | 2024-11-09T14:16:28.814Z |
5505398 | 5505398 | 20241108050705_FkY77 | USL00K | 2024-11-09T14:16:16.006Z | 2024-11-09T14:16:28.775Z |
5505339 | 5505339 | 20241108044149_3IThc | USL00K | 2024-11-09T14:16:10.929Z | 2024-11-09T14:16:28.758Z |
5504905 | 5504905 | 20241108031647_1qkhf | USL00K | 2024-11-09T14:15:22.043Z | 2024-11-09T14:16:28.654Z |
5504611 | 5504611 | 20241108022257_Pm27V | USL00K | 2024-11-09T14:14:56.749Z | 2024-11-09T14:16:28.582Z |
5504442 | 5504442 | 20241108015849_d2AJU | USL00K | 2024-11-09T14:14:38.527Z | 2024-11-09T14:16:28.539Z |
5504349 | 5504349 | 20241108014435_Qv214 | USL00K | 2024-11-09T14:14:28.193Z | 2024-11-09T14:16:28.513Z |
5499529 | 5499529 | 20241108123141_pKf8d | USL00K | 2024-11-09T14:04:15.956Z | 2024-11-09T14:04:15.956Z |
5499451 | 5499451 | 20241108122053_YgNMN | USL00K | 2024-11-09T14:04:07.673Z | 2024-11-09T14:04:07.673Z |
5499371 | 5499371 | 20241108120619_YzHKm | USL00K | 2024-11-09T14:03:52.637Z | 2024-11-09T14:03:52.637Z |
5499306 | 5499306 | 20241108115220_29LXi | USL00K | 2024-11-09T14:03:43.168Z | 2024-11-09T14:03:43.168Z |
5499270 | 5499270 | 20241108114721_87SeU | USL00K | 2024-11-09T14:03:39.504Z | 2024-11-09T14:03:39.504Z |
5499211 | 5499211 | 20241108113530_62cNv | USL00K | 2024-11-09T14:03:33.006Z | 2024-11-09T14:03:33.006Z |
5499200 | 5499200 | 20241108113317_VUA3w | USL00K | 2024-11-09T14:03:31.486Z | 2024-11-09T14:03:31.486Z |
5499109 | 5499109 | 20241108111118_S1JER | USL00K | 2024-11-09T14:03:13.715Z | 2024-11-09T14:03:13.715Z |
5499026 | 5499026 | 20241108104926_NFwp3 | USL00K | 2024-11-09T14:03:00.379Z | 2024-11-09T14:03:00.379Z |
5498988 | 5498988 | 20241108103930_zQ4v5 | USL00K | 2024-11-09T14:02:55.742Z | 2024-11-09T14:02:55.742Z |
5498909 | 5498909 | 20241108102416_3AANf | USL00K | 2024-11-09T14:02:45.858Z | 2024-11-09T14:02:45.858Z |
5498887 | 5498887 | 20241108101822_UgKEP | USL00K | 2024-11-09T14:02:42.501Z | 2024-11-09T14:02:42.501Z |
5498691 | 5498691 | 20241108093658_wdyy6 | USL00K | 2024-11-09T14:02:12.131Z | 2024-11-09T14:02:12.131Z |
5498655 | 5498655 | 20241108093232_Eeeo5 | USL00K | 2024-11-09T14:02:06.918Z | 2024-11-09T14:02:06.918Z |
5498644 | 5498644 | 20241108092906_t0b87 | USL00K | 2024-11-09T14:02:04.571Z | 2024-11-09T14:02:04.571Z |
5498634 | 5498634 | 20241108092810_8507B | USL00K | 2024-11-09T14:02:02.698Z | 2024-11-09T14:02:02.698Z |
5498535 | 5498535 | 20241108085727_0DAxj | USL00K | 2024-11-09T14:01:43.315Z | 2024-11-09T14:01:43.315Z |
5498490 | 5498490 | 20241108084107_6SU3p | USL00K | 2024-11-09T14:01:37.610Z | 2024-11-09T14:01:37.610Z |
5498473 | 5498473 | 20241108083818_idFi1 | USL00K | 2024-11-09T14:01:33.999Z | 2024-11-09T14:01:33.999Z |
5498305 | 5498305 | 20241108075538_A8lir | USL00K | 2024-11-09T14:01:05.169Z | 2024-11-09T14:01:05.169Z |
5498288 | 5498288 | 20241108075002_EQf3v | USL00K | 2024-11-09T14:01:02.397Z | 2024-11-09T14:01:02.397Z |
5498255 | 5498255 | 20241108074348_B39bD | USL00K | 2024-11-09T14:00:58.475Z | 2024-11-09T14:00:58.475Z |
5498214 | 5498214 | 20241108073334_Yu7AI | USL00K | 2024-11-09T14:00:51.273Z | 2024-11-09T14:00:51.273Z |
5498128 | 5498128 | 20241108070541_OKgki | USL00K | 2024-11-09T14:00:35.439Z | 2024-11-09T14:00:35.439Z |
5498125 | 5498125 | 20241108070435_gjJq3 | USL00K | 2024-11-09T14:00:35.120Z | 2024-11-09T14:00:35.120Z |
5497900 | 5497900 | 20241107055800_yPEz3 | USL00K | 2024-11-08T14:14:29.709Z | 2024-11-09T14:18:53.442Z |
5497873 | 5497873 | 20241107054036_HhxDT | USL00K | 2024-11-08T14:14:28.552Z | 2024-11-09T14:18:52.964Z |
5497822 | 5497822 | 20241107052250_q5P32 | USL00K | 2024-11-08T14:14:25.145Z | 2024-11-09T14:18:52.445Z |
5497689 | 5497689 | 20241107043009_z30Ij | USL00K | 2024-11-08T14:14:11.841Z | 2024-11-09T14:18:50.609Z |
5493524 | 5493524 | 20241107122511_6QPK2 | USL00K | 2024-11-08T14:03:58.330Z | 2024-11-09T14:16:27.646Z |
5493481 | 5493481 | 20241107122016_F1FzT | USL00K | 2024-11-08T14:03:51.488Z | 2024-11-09T14:16:27.637Z |
5493465 | 5493465 | 20241107121710_XeIUF | USL00K | 2024-11-08T14:03:50.249Z | 2024-11-09T14:16:27.633Z |
5493366 | 5493366 | 20241107115608_ASj0D | USL00K | 2024-11-08T14:03:37.548Z | 2024-11-09T14:16:27.602Z |
5493325 | 5493325 | 20241107114847_M5Xh8 | USL00K | 2024-11-08T14:03:33.573Z | 2024-11-09T14:16:27.588Z |
5493239 | 5493239 | 20241107112301_M3TBc | USL00K | 2024-11-08T14:03:15.699Z | 2024-11-09T14:16:27.566Z |
5493110 | 5493110 | 20241107105620_x89KR | USL00K | 2024-11-08T14:02:51.972Z | 2024-11-09T14:16:27.534Z |
5493072 | 5493072 | 20241107104840_Vbc2Z | USL00K | 2024-11-08T14:02:48.448Z | 2024-11-09T14:16:27.524Z |
5492936 | 5492936 | 20241107102140_gayie | USL00K | 2024-11-08T14:02:36.050Z | 2024-11-09T14:16:27.491Z |
5492840 | 5492840 | 20241107100205_85SBR | USL00K | 2024-11-08T14:02:11.824Z | 2024-11-09T14:16:27.466Z |
5492797 | 5492797 | 20241107095648_O9uPK | USL00K | 2024-11-08T14:02:06.418Z | 2024-11-09T14:16:27.456Z |
5492774 | 5492774 | 20241107095408_qm0GJ | USL00K | 2024-11-08T14:02:04.088Z | 2024-11-09T14:16:27.451Z |
5492706 | 5492706 | 20241107093506_rxoMR | USL00K | 2024-11-08T14:01:55.717Z | 2024-11-09T14:16:27.432Z |
5492683 | 5492683 | 20241107093100_F4BIx | USL00K | 2024-11-08T14:01:53.569Z | 2024-11-09T14:16:27.428Z |
5492641 | 5492641 | 20241107092206_RywMp | USL00K | 2024-11-08T14:01:41.981Z | 2024-11-09T14:16:27.418Z |
5492489 | 5492489 | 20241107084235_8nU9d | USL00K | 2024-11-08T14:01:16.741Z | 2024-11-09T14:16:27.384Z |
5492318 | 5492318 | 20241107080759_eJ3BY | USL00K | 2024-11-08T14:00:46.459Z | 2024-11-09T14:16:27.343Z |
5492300 | 5492300 | 20241107080353_rvxlZ | USL00K | 2024-11-08T14:00:43.934Z | 2024-11-09T14:16:27.339Z |
5492272 | 5492272 | 20241107075300_9Sf72 | USL00K | 2024-11-08T14:00:40.647Z | 2024-11-09T14:16:27.332Z |
5492260 | 5492260 | 20241107074928_uFVK2 | USL00K | 2024-11-08T14:00:39.647Z | 2024-11-09T14:16:27.330Z |
5491827 | 5491827 | 20241106052227_ViEk1 | USL00K | 2024-11-07T14:17:05.080Z | 2024-11-09T14:20:14.995Z |
5491768 | 5491768 | 20241106050544_sU2nE | USL00K | 2024-11-07T14:16:56.640Z | 2024-11-09T14:20:14.386Z |
5486354 | 5486354 | 20241106110305_lG5DH | USL00K | 2024-11-07T14:02:41.420Z | 2024-11-09T14:16:43.467Z |
5485903 | 5485903 | 20241106082728_r03vs | USL00K | 2024-11-07T14:01:05.298Z | 2024-11-09T14:16:34.248Z |
5485531 | 5485531 | 20241105061942_gG8w0 | USL00K | 2024-11-06T14:18:25.596Z | 2024-11-09T14:21:22.652Z |
5485457 | 5485457 | 20241105054716_NSFkT | USL00K | 2024-11-06T14:18:19.410Z | 2024-11-09T14:21:21.745Z |
5485106 | 5485106 | 20241105040506_1dYHJ | USL00K | 2024-11-06T14:17:46.362Z | 2024-11-09T14:21:19.430Z |
5484826 | 5484826 | 20241105033214_1HGBn | USL00K | 2024-11-06T14:17:21.145Z | 2024-11-09T14:21:16.723Z |
5484328 | 5484328 | 20241105023500_7OpFN | USL00K | 2024-11-06T14:16:48.607Z | 2024-11-09T14:21:13.283Z |
5480290 | 5480290 | 20241105121848_jFZO4 | USL00K | 2024-11-06T14:05:09.602Z | 2024-11-09T14:19:22.115Z |
5480053 | 5480053 | 20241105112651_0oWcu | USL00K | 2024-11-06T14:04:23.404Z | 2024-11-09T14:19:16.106Z |
5479907 | 5479907 | 20241105105812_dbvFZ | USL00K | 2024-11-06T14:03:52.159Z | 2024-11-09T14:19:13.754Z |
5479698 | 5479698 | 20241105102217_uFSWj | USL00K | 2024-11-06T14:03:07.070Z | 2024-11-09T14:19:10.643Z |
5479375 | 5479375 | 20241105091328_FyO0x | USL00K | 2024-11-06T14:02:08.264Z | 2024-11-09T14:19:04.964Z |
5479206 | 5479206 | 20241105083114_j1TGN | USL00K | 2024-11-06T14:01:29.685Z | 2024-11-09T14:19:01.516Z |
5479157 | 5479157 | 20241105081907_jmcMa | USL00K | 2024-11-06T14:01:16.106Z | 2024-11-09T14:19:00.456Z |
5479114 | 5479114 | 20241105080724_qxWO2 | USL00K | 2024-11-06T14:01:03.146Z | 2024-11-09T14:18:59.588Z |
5479104 | 5479104 | 20241105080557_gYV2j | USL00K | 2024-11-06T14:01:00.976Z | 2024-11-09T14:18:59.513Z |
5478838 | 5478838 | 20241104063918_A9yX4 | USL00K | 2024-11-05T14:18:54.874Z | 2024-11-09T14:22:31.645Z |
5478744 | 5478744 | 20241104053531_SJ6lX | USL00K | 2024-11-05T14:18:47.026Z | 2024-11-09T14:22:31.085Z |
5471739 | 5471739 | 20241104123210_2Zb2O | USL00K | 2024-11-05T14:04:31.948Z | 2024-11-09T14:20:33.250Z |
5471669 | 5471669 | 20241104122155_QS0Qf | USL00K | 2024-11-05T14:04:17.218Z | 2024-11-09T14:20:32.658Z |
5471280 | 5471280 | 20241104112512_SXd07 | USL00K | 2024-11-05T14:03:17.999Z | 2024-11-09T14:20:30.041Z |
5471221 | 5471221 | 20241104110448_vgPGF | USL00K | 2024-11-05T14:03:09.252Z | 2024-11-09T14:20:29.330Z |
5471184 | 5471184 | 20241104105748_TAanq | USL00K | 2024-11-05T14:03:03.155Z | 2024-11-09T14:20:29.001Z |
5470886 | 5470886 | 20241104095958_Pcr39 | USL00K | 2024-11-05T14:02:11.039Z | 2024-11-09T14:20:25.537Z |
5470761 | 5470761 | 20241104094153_5PEeo | USL00K | 2024-11-05T14:01:46.127Z | 2024-11-09T14:20:24.718Z |
5470679 | 5470679 | 20241104091847_66ge7 | USL00K | 2024-11-05T14:01:31.583Z | 2024-11-09T14:20:22.578Z |
5470433 | 5470433 | 20241104080434_S2EYR | USL00K | 2024-11-05T14:00:38.483Z | 2024-11-09T14:20:19.564Z |
5470403 | 5470403 | 20241104075718_Amq3H | USL00K | 2024-11-05T14:00:31.752Z | 2024-11-09T14:20:19.327Z |
5470147 | 5470147 | 20241103060641_Bz5Ad | USL00K | 2024-11-04T14:17:51.093Z | 2024-11-09T14:23:05.716Z |
5470142 | 5470142 | 20241103055958_NFxU8 | USL00K | 2024-11-04T14:17:50.628Z | 2024-11-09T14:23:05.682Z |
5470085 | 5470085 | 20241103052354_VzPdJ | USL00K | 2024-11-04T14:17:46.698Z | 2024-11-09T14:23:05.346Z |
5470028 | 5470028 | 20241103051124_3PZKo | USL00K | 2024-11-04T14:17:36.280Z | 2024-11-09T14:23:04.841Z |
5469982 | 5469982 | 20241103050030_ntPPS | USL00K | 2024-11-04T14:17:29.377Z | 2024-11-09T14:23:04.548Z |
5465124 | 5465124 | 20241103104209_zF9o7 | USL00K | 2024-11-04T14:02:52.910Z | 2024-11-09T14:21:30.860Z |
5464381 | 5464381 | 20241103065739_nmAKN | USL00K | 2024-11-04T14:00:15.284Z | 2024-11-09T14:21:25.049Z |
5464272 | 5464272 | 20241101063119_2W2PZ | USL00K | 2024-11-03T14:22:10.510Z | 2024-11-09T14:24:37.609Z |
5464181 | 5464181 | 20241101043910_u33in | USL00K | 2024-11-03T14:22:05.734Z | 2024-11-09T14:24:33.908Z |
5464176 | 5464176 | 20241101042844_srNGh | USL00K | 2024-11-03T14:22:05.352Z | 2024-11-09T14:24:33.617Z |
5464157 | 5464157 | 20241101034125_Cs7OT | USL00K | 2024-11-03T14:22:02.624Z | 2024-11-09T14:24:31.531Z |
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);