participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "US000C" 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 |
---|---|---|---|---|---|
5491226 | 5491226 | 20241106023007_I26L4 | US000C | 2024-11-07T14:15:34.505Z | 2024-11-08T14:16:48.522Z |
5486469 | 5486469 | 20241106114823_Kr099 | US000C | 2024-11-07T14:03:06.887Z | 2024-11-08T14:14:34.246Z |
5486394 | 5486394 | 20241106111959_3Y1ym | US000C | 2024-11-07T14:02:47.946Z | 2024-11-08T14:14:34.226Z |
5486233 | 5486233 | 20241106100956_Q6bJF | US000C | 2024-11-07T14:02:17.088Z | 2024-11-08T14:14:34.192Z |
5486231 | 5486231 | 20241106100849_QjnIk | US000C | 2024-11-07T14:02:16.769Z | 2024-11-08T14:14:34.191Z |
5486157 | 5486157 | 20241106095421_0G7FN | US000C | 2024-11-07T14:02:05.587Z | 2024-11-08T14:14:34.175Z |
5485872 | 5485872 | 20241106080756_iEnlm | US000C | 2024-11-07T14:00:54.782Z | 2024-11-08T14:14:34.105Z |
5485736 | 5485736 | 20241106070721_P6Yln | US000C | 2024-11-07T14:00:25.990Z | 2024-11-08T14:14:34.071Z |
5485719 | 5485719 | 20241106065614_5bVRf | US000C | 2024-11-07T14:00:23.484Z | 2024-11-08T14:14:34.067Z |
5485695 | 5485695 | 20241106064607_Qq7ae | US000C | 2024-11-07T14:00:17.703Z | 2024-11-08T14:14:34.062Z |
5485678 | 5485678 | 20241106063826_FuFW2 | US000C | 2024-11-07T14:00:12.913Z | 2024-11-08T14:14:34.056Z |
5485524 | 5485524 | 20241105061754_tGP1f | US000C | 2024-11-06T14:18:24.985Z | 2024-11-08T14:18:52.132Z |
5485520 | 5485520 | 20241105061551_4b5l4 | US000C | 2024-11-06T14:18:24.225Z | 2024-11-08T14:18:52.084Z |
5485463 | 5485463 | 20241105054945_Mzq2g | US000C | 2024-11-06T14:18:19.978Z | 2024-11-08T14:18:51.784Z |
5485451 | 5485451 | 20241105054439_YuzMR | US000C | 2024-11-06T14:18:18.804Z | 2024-11-08T14:18:51.639Z |
5485442 | 5485442 | 20241105054010_gv8pi | US000C | 2024-11-06T14:18:18.266Z | 2024-11-08T14:18:51.581Z |
5480318 | 5480318 | 20241105122141_RTKqc | US000C | 2024-11-06T14:05:14.349Z | 2024-11-08T14:15:22.108Z |
5480292 | 5480292 | 20241105121859_596Bw | US000C | 2024-11-06T14:05:10.067Z | 2024-11-08T14:15:21.444Z |
5480282 | 5480282 | 20241105121535_GPLI2 | US000C | 2024-11-06T14:05:08.153Z | 2024-11-08T14:15:21.128Z |
5480262 | 5480262 | 20241105121123_fUnQV | US000C | 2024-11-06T14:05:05.246Z | 2024-11-08T14:15:20.608Z |
5480229 | 5480229 | 20241105120407_U7Il9 | US000C | 2024-11-06T14:05:00.287Z | 2024-11-08T14:15:19.925Z |
5480158 | 5480158 | 20241105115343_IVoAK | US000C | 2024-11-06T14:04:40.737Z | 2024-11-08T14:15:18.011Z |
5480109 | 5480109 | 20241105113937_Lyo7s | US000C | 2024-11-06T14:04:31.730Z | 2024-11-08T14:15:16.595Z |
5480093 | 5480093 | 20241105113508_BJqpd | US000C | 2024-11-06T14:04:29.671Z | 2024-11-08T14:15:16.101Z |
5480056 | 5480056 | 20241105112753_pa6Eo | US000C | 2024-11-06T14:04:24.479Z | 2024-11-08T14:15:14.350Z |
5480033 | 5480033 | 20241105112428_WQg7G | US000C | 2024-11-06T14:04:21.546Z | 2024-11-08T14:15:13.352Z |
5479979 | 5479979 | 20241105111328_72yBQ | US000C | 2024-11-06T14:04:14.956Z | 2024-11-08T14:15:11.718Z |
5479932 | 5479932 | 20241105110159_JqrbE | US000C | 2024-11-06T14:03:57.869Z | 2024-11-08T14:15:09.937Z |
5479804 | 5479804 | 20241105104343_qCMy1 | US000C | 2024-11-06T14:03:37.083Z | 2024-11-08T14:15:06.084Z |
5479762 | 5479762 | 20241105103434_6acCo | US000C | 2024-11-06T14:03:30.791Z | 2024-11-08T14:15:03.800Z |
5479756 | 5479756 | 20241105103348_teW5S | US000C | 2024-11-06T14:03:29.815Z | 2024-11-08T14:15:03.701Z |
5479723 | 5479723 | 20241105102556_dTLSY | US000C | 2024-11-06T14:03:16.646Z | 2024-11-08T14:15:02.190Z |
5479722 | 5479722 | 20241105102541_PN3xI | US000C | 2024-11-06T14:03:14.876Z | 2024-11-08T14:15:01.936Z |
5479682 | 5479682 | 20241105101809_X59E0 | US000C | 2024-11-06T14:03:04.540Z | 2024-11-08T14:15:00.731Z |
5479626 | 5479626 | 20241105100703_x5Z2j | US000C | 2024-11-06T14:02:55.157Z | 2024-11-08T14:14:59.032Z |
5479601 | 5479601 | 20241105100359_7wLQ8 | US000C | 2024-11-06T14:02:51.967Z | 2024-11-08T14:14:58.571Z |
5479524 | 5479524 | 20241105094935_ULLun | US000C | 2024-11-06T14:02:41.032Z | 2024-11-08T14:14:56.417Z |
5479499 | 5479499 | 20241105094359_uUBTe | US000C | 2024-11-06T14:02:28.344Z | 2024-11-08T14:14:55.538Z |
5479480 | 5479480 | 20241105093800_PakfF | US000C | 2024-11-06T14:02:23.557Z | 2024-11-08T14:14:54.679Z |
5479477 | 5479477 | 20241105093732_MlENT | US000C | 2024-11-06T14:02:23.110Z | 2024-11-08T14:14:54.491Z |
5479456 | 5479456 | 20241105093333_1SZFe | US000C | 2024-11-06T14:02:20.286Z | 2024-11-08T14:14:53.796Z |
5479454 | 5479454 | 20241105093154_Lno70 | US000C | 2024-11-06T14:02:18.868Z | 2024-11-08T14:14:53.731Z |
5479381 | 5479381 | 20241105091506_ikF9a | US000C | 2024-11-06T14:02:09.458Z | 2024-11-08T14:14:51.743Z |
5479358 | 5479358 | 20241105091103_bEoW7 | US000C | 2024-11-06T14:02:05.985Z | 2024-11-08T14:14:50.795Z |
5479338 | 5479338 | 20241105090638_u6vLF | US000C | 2024-11-06T14:02:03.735Z | 2024-11-08T14:14:50.494Z |
5479321 | 5479321 | 20241105090505_PGWvm | US000C | 2024-11-06T14:01:59.794Z | 2024-11-08T14:14:49.984Z |
5479309 | 5479309 | 20241105090411_NBVWz | US000C | 2024-11-06T14:01:56.227Z | 2024-11-08T14:14:49.740Z |
5479294 | 5479294 | 20241105090059_H2xUB | US000C | 2024-11-06T14:01:47.371Z | 2024-11-08T14:14:49.337Z |
5479283 | 5479283 | 20241105085643_n213q | US000C | 2024-11-06T14:01:44.301Z | 2024-11-08T14:14:48.875Z |
5479249 | 5479249 | 20241105084646_0FvK2 | US000C | 2024-11-06T14:01:36.479Z | 2024-11-08T14:14:47.974Z |
5479236 | 5479236 | 20241105083846_6sH9o | US000C | 2024-11-06T14:01:35.287Z | 2024-11-08T14:14:47.329Z |
5479222 | 5479222 | 20241105083409_MHEIj | US000C | 2024-11-06T14:01:32.588Z | 2024-11-08T14:14:46.549Z |
5479213 | 5479213 | 20241105083219_ivrIh | US000C | 2024-11-06T14:01:30.720Z | 2024-11-08T14:14:46.080Z |
5479165 | 5479165 | 20241105081926_PKEGB | US000C | 2024-11-06T14:01:16.862Z | 2024-11-08T14:14:43.646Z |
5479140 | 5479140 | 20241105081631_fbcyU | US000C | 2024-11-06T14:01:13.351Z | 2024-11-08T14:14:43.129Z |
5479012 | 5479012 | 20241105072831_p9Ar6 | US000C | 2024-11-06T14:00:39.045Z | 2024-11-08T14:14:39.612Z |
5478974 | 5478974 | 20241105071844_6z01m | US000C | 2024-11-06T14:00:31.473Z | 2024-11-08T14:14:38.991Z |
5478963 | 5478963 | 20241105071601_detCf | US000C | 2024-11-06T14:00:29.180Z | 2024-11-08T14:14:38.785Z |
5478949 | 5478949 | 20241105070158_VSSc2 | US000C | 2024-11-06T14:00:26.751Z | 2024-11-08T14:14:38.561Z |
5478920 | 5478920 | 20241105065424_1mY7C | US000C | 2024-11-06T14:00:21.562Z | 2024-11-08T14:14:38.020Z |
5478918 | 5478918 | 20241105065423_2rEfW | US000C | 2024-11-06T14:00:21.046Z | 2024-11-08T14:14:37.932Z |
5478911 | 5478911 | 20241105065230_nin5a | US000C | 2024-11-06T14:00:19.967Z | 2024-11-08T14:14:37.833Z |
5478890 | 5478890 | 20241105064631_0HgbS | US000C | 2024-11-06T14:00:14.879Z | 2024-11-08T14:14:37.366Z |
5468621 | 5468621 | 20241103010908_q3YAT | US000C | 2024-11-04T14:14:36.710Z | 2024-11-08T14:21:03.181Z |
5464704 | 5464704 | 20241103085652_knFHo | US000C | 2024-11-04T14:01:26.040Z | 2024-11-08T14:19:00.697Z |
5464037 | 5464037 | 20241102064057_U2UHa | US000C | 2024-11-03T14:19:30.619Z | 2024-11-08T14:21:56.532Z |
5464035 | 5464035 | 20241102064053_uMNsL | US000C | 2024-11-03T14:19:30.405Z | 2024-11-08T14:21:56.520Z |
5464031 | 5464031 | 20241102063831_47KIo | US000C | 2024-11-03T14:19:30.243Z | 2024-11-08T14:21:56.499Z |
5464016 | 5464016 | 20241102063428_MREPP | US000C | 2024-11-03T14:19:29.449Z | 2024-11-08T14:21:56.366Z |
5463967 | 5463967 | 20241102062158_YJzpO | US000C | 2024-11-03T14:19:27.138Z | 2024-11-08T14:21:55.818Z |
5463959 | 5463959 | 20241102062120_9S0NX | US000C | 2024-11-03T14:19:27.035Z | 2024-11-08T14:21:55.800Z |
5463923 | 5463923 | 20241102061318_x9SBj | US000C | 2024-11-03T14:19:25.704Z | 2024-11-08T14:21:55.367Z |
5463913 | 5463913 | 20241102060906_SWjwb | US000C | 2024-11-03T14:19:24.805Z | 2024-11-08T14:21:55.349Z |
5463880 | 5463880 | 20241102055651_zLus6 | US000C | 2024-11-03T14:19:21.826Z | 2024-11-08T14:21:55.290Z |
5463864 | 5463864 | 20241102055432_QZmV2 | US000C | 2024-11-03T14:19:21.427Z | 2024-11-08T14:21:55.270Z |
5463848 | 5463848 | 20241102054249_UEPED | US000C | 2024-11-03T14:19:20.509Z | 2024-11-08T14:21:55.169Z |
5463830 | 5463830 | 20241102052900_p8nZK | US000C | 2024-11-03T14:19:19.138Z | 2024-11-08T14:21:55.102Z |
5463819 | 5463819 | 20241102052222_VqlMJ | US000C | 2024-11-03T14:19:18.464Z | 2024-11-08T14:21:55.078Z |
5463761 | 5463761 | 20241102045756_0Poa7 | US000C | 2024-11-03T14:19:15.191Z | 2024-11-08T14:21:54.814Z |
5463751 | 5463751 | 20241102045444_V0FFx | US000C | 2024-11-03T14:19:14.118Z | 2024-11-08T14:21:54.794Z |
5463728 | 5463728 | 20241102044650_AOVH0 | US000C | 2024-11-03T14:19:12.077Z | 2024-11-08T14:21:54.621Z |
5463709 | 5463709 | 20241102044153_zt87q | US000C | 2024-11-03T14:19:11.362Z | 2024-11-08T14:21:54.521Z |
5463690 | 5463690 | 20241102043541_vFePU | US000C | 2024-11-03T14:19:10.056Z | 2024-11-08T14:21:54.441Z |
5463545 | 5463545 | 20241102035739_7eM7f | US000C | 2024-11-03T14:18:56.216Z | 2024-11-08T14:21:53.493Z |
5460001 | 5460001 | 20241101122847_dircv | US000C | 2024-11-03T14:13:04.891Z | 2024-11-08T14:21:36.101Z |
5459963 | 5459963 | 20241101122433_alHg5 | US000C | 2024-11-03T14:12:58.809Z | 2024-11-08T14:21:35.567Z |
5459790 | 5459790 | 20241101115134_pj2YG | US000C | 2024-11-03T14:12:36.285Z | 2024-11-08T14:21:33.674Z |
5459683 | 5459683 | 20241101113726_Q6G8y | US000C | 2024-11-03T14:12:28.112Z | 2024-11-08T14:21:32.943Z |
5459638 | 5459638 | 20241101112816_m6nlG | US000C | 2024-11-03T14:12:23.783Z | 2024-11-08T14:21:32.698Z |
5459589 | 5459589 | 20241101112135_LJQBc | US000C | 2024-11-03T14:12:20.746Z | 2024-11-08T14:21:32.304Z |
5459578 | 5459578 | 20241101111929_avoKq | US000C | 2024-11-03T14:12:19.797Z | 2024-11-08T14:21:31.693Z |
5459532 | 5459532 | 20241101111353_drlyj | US000C | 2024-11-03T14:12:14.964Z | 2024-11-08T14:21:31.170Z |
5459501 | 5459501 | 20241101110912_YCAtC | US000C | 2024-11-03T14:12:02.561Z | 2024-11-08T14:21:31.052Z |
5459464 | 5459464 | 20241101110251_j4YiT | US000C | 2024-11-03T14:11:58.545Z | 2024-11-08T14:21:30.734Z |
5459443 | 5459443 | 20241101110121_oaR5j | US000C | 2024-11-03T14:11:56.007Z | 2024-11-08T14:21:30.671Z |
5459301 | 5459301 | 20241101104011_8L77t | US000C | 2024-11-03T14:11:38.758Z | 2024-11-08T14:21:30.110Z |
5459206 | 5459206 | 20241101102331_zps8t | US000C | 2024-11-03T14:11:29.918Z | 2024-11-08T14:21:29.599Z |
5459164 | 5459164 | 20241101101904_6KQK7 | US000C | 2024-11-03T14:11:26.271Z | 2024-11-08T14:21:29.395Z |
5459159 | 5459159 | 20241101101826_jPePR | US000C | 2024-11-03T14:11:25.751Z | 2024-11-08T14:21:29.384Z |
5459118 | 5459118 | 20241101101059_vaFr3 | US000C | 2024-11-03T14:11:21.464Z | 2024-11-08T14:21:29.261Z |
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);