participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
21,600 rows where station_code = "USL00E" 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 |
---|---|---|---|---|---|
5134764 | 5134764 | 20240916114501_EwEhF | USL00E | 2024-09-19T12:18:06.083Z | 2024-09-19T12:18:06.083Z |
5134688 | 5134688 | 20240916111811_MEwYB | USL00E | 2024-09-19T12:18:03.469Z | 2024-09-19T12:18:03.469Z |
5134645 | 5134645 | 20240916110332_sNX3W | USL00E | 2024-09-19T12:18:00.510Z | 2024-09-19T12:18:00.510Z |
5134576 | 5134576 | 20240916103615_gFVis | USL00E | 2024-09-19T12:17:52.017Z | 2024-09-19T12:17:52.017Z |
5134545 | 5134545 | 20240916101646_ullEs | USL00E | 2024-09-19T12:17:49.625Z | 2024-09-19T12:17:49.625Z |
5134537 | 5134537 | 20240916100746_jLjX8 | USL00E | 2024-09-19T12:17:49.147Z | 2024-09-19T12:17:49.147Z |
5125958 | 5125958 | 20240918051912_LBkPv | USL00E | 2024-09-19T12:04:38.150Z | 2024-09-19T12:06:42.115Z |
5125901 | 5125901 | 20240918042959_lvPL3 | USL00E | 2024-09-19T12:04:31.050Z | 2024-09-19T12:06:42.104Z |
5125827 | 5125827 | 20240918040244_ku3yR | USL00E | 2024-09-19T12:04:10.771Z | 2024-09-19T12:06:42.091Z |
5123888 | 5123888 | 20240914115722_QCa7C | USL00E | 2024-09-18T12:11:59.368Z | 2024-09-19T12:20:16.131Z |
5123092 | 5123092 | 20240914085043_DH8C7 | USL00E | 2024-09-18T12:11:39.705Z | 2024-09-19T12:20:07.601Z |
5122621 | 5122621 | 20240914072426_yNyoL | USL00E | 2024-09-18T12:11:25.499Z | 2024-09-19T12:20:05.427Z |
5122542 | 5122542 | 20240914070414_3Xuca | USL00E | 2024-09-18T12:11:22.485Z | 2024-09-19T12:20:04.884Z |
5122527 | 5122527 | 20240914070320_qOnyB | USL00E | 2024-09-18T12:11:22.089Z | 2024-09-19T12:20:04.801Z |
5122473 | 5122473 | 20240914063405_WMGEz | USL00E | 2024-09-18T12:11:20.230Z | 2024-09-19T12:20:04.496Z |
5118867 | 5118867 | 20240915112200_J2xnY | USL00E | 2024-09-18T12:09:10.428Z | 2024-09-19T12:19:26.722Z |
5118844 | 5118844 | 20240915111912_HGtmt | USL00E | 2024-09-18T12:09:07.946Z | 2024-09-19T12:19:26.500Z |
5118794 | 5118794 | 20240915110906_3hxq9 | USL00E | 2024-09-18T12:09:03.525Z | 2024-09-19T12:19:25.525Z |
5118757 | 5118757 | 20240915110155_Gb24R | USL00E | 2024-09-18T12:09:01.584Z | 2024-09-19T12:19:25.329Z |
5118749 | 5118749 | 20240915110040_d0syr | USL00E | 2024-09-18T12:09:01.270Z | 2024-09-19T12:19:25.284Z |
5118746 | 5118746 | 20240915110014_201m6 | USL00E | 2024-09-18T12:09:01.164Z | 2024-09-19T12:19:25.254Z |
5118456 | 5118456 | 20240915095051_GdXxF | USL00E | 2024-09-18T12:08:45.509Z | 2024-09-19T12:19:23.067Z |
5118432 | 5118432 | 20240915094646_fYAbN | USL00E | 2024-09-18T12:08:43.849Z | 2024-09-19T12:19:22.856Z |
5118161 | 5118161 | 20240915084542_zuLxd | USL00E | 2024-09-18T12:08:27.866Z | 2024-09-19T12:19:20.991Z |
5117936 | 5117936 | 20240915075042_s3TA1 | USL00E | 2024-09-18T12:08:08.473Z | 2024-09-19T12:19:19.127Z |
5117200 | 5117200 | 20240915041112_1aqeO | USL00E | 2024-09-18T12:07:35.373Z | 2024-09-19T12:19:13.856Z |
5116917 | 5116917 | 20240915034955_MoCle | USL00E | 2024-09-18T12:07:26.055Z | 2024-09-19T12:19:12.734Z |
5115765 | 5115765 | 20240915025324_0f5QB | USL00E | 2024-09-18T12:06:23.456Z | 2024-09-19T12:19:07.288Z |
5110045 | 5110045 | 20240913115359_PWZr5 | USL00E | 2024-09-17T12:14:55.742Z | 2024-09-19T12:20:55.682Z |
5110032 | 5110032 | 20240913115127_nftXz | USL00E | 2024-09-17T12:14:55.262Z | 2024-09-19T12:20:55.648Z |
5110023 | 5110023 | 20240913115006_AkLwi | USL00E | 2024-09-17T12:14:54.809Z | 2024-09-19T12:20:55.641Z |
5110013 | 5110013 | 20240913114838_saqY2 | USL00E | 2024-09-17T12:14:54.467Z | 2024-09-19T12:20:55.632Z |
5110010 | 5110010 | 20240913114817_Epf7s | USL00E | 2024-09-17T12:14:54.428Z | 2024-09-19T12:20:55.630Z |
5109954 | 5109954 | 20240913114051_wnxzQ | USL00E | 2024-09-17T12:14:51.702Z | 2024-09-19T12:20:55.499Z |
5109901 | 5109901 | 20240913113509_hofyW | USL00E | 2024-09-17T12:14:48.886Z | 2024-09-19T12:20:55.341Z |
5109810 | 5109810 | 20240913111345_Cxdmd | USL00E | 2024-09-17T12:14:46.636Z | 2024-09-19T12:20:54.825Z |
5109799 | 5109799 | 20240913110708_GcOBU | USL00E | 2024-09-17T12:14:46.296Z | 2024-09-19T12:20:54.789Z |
5109763 | 5109763 | 20240913110353_O3jVq | USL00E | 2024-09-17T12:14:45.586Z | 2024-09-19T12:20:54.719Z |
5109678 | 5109678 | 20240913104524_wG2Dq | USL00E | 2024-09-17T12:14:43.598Z | 2024-09-19T12:20:54.439Z |
5109675 | 5109675 | 20240913104517_Nfr9n | USL00E | 2024-09-17T12:14:43.538Z | 2024-09-19T12:20:54.436Z |
5109592 | 5109592 | 20240913103140_zo9RM | USL00E | 2024-09-17T12:14:41.841Z | 2024-09-19T12:20:53.802Z |
5109558 | 5109558 | 20240913102928_hmGoc | USL00E | 2024-09-17T12:14:41.335Z | 2024-09-19T12:20:53.737Z |
5109509 | 5109509 | 20240913100939_JHEL1 | USL00E | 2024-09-17T12:14:39.873Z | 2024-09-19T12:20:53.598Z |
5109487 | 5109487 | 20240913100645_3aS3j | USL00E | 2024-09-17T12:14:39.370Z | 2024-09-19T12:20:53.523Z |
5109397 | 5109397 | 20240913094856_2pVPJ | USL00E | 2024-09-17T12:14:37.374Z | 2024-09-19T12:20:53.221Z |
5109292 | 5109292 | 20240913092735_cVYNK | USL00E | 2024-09-17T12:14:34.809Z | 2024-09-19T12:20:52.780Z |
5109249 | 5109249 | 20240913092201_E3RGG | USL00E | 2024-09-17T12:14:34.023Z | 2024-09-19T12:20:52.674Z |
5109215 | 5109215 | 20240913091426_MBL7y | USL00E | 2024-09-17T12:14:33.437Z | 2024-09-19T12:20:52.521Z |
5109086 | 5109086 | 20240913084346_GivWI | USL00E | 2024-09-17T12:14:29.815Z | 2024-09-19T12:20:51.657Z |
5108820 | 5108820 | 20240913074116_569l3 | USL00E | 2024-09-17T12:14:08.875Z | 2024-09-19T12:20:50.853Z |
5108800 | 5108800 | 20240913073435_IMPjW | USL00E | 2024-09-17T12:14:07.823Z | 2024-09-19T12:20:50.804Z |
5108629 | 5108629 | 20240913065109_R0wnJ | USL00E | 2024-09-17T12:13:54.577Z | 2024-09-19T12:20:50.045Z |
5096827 | 5096827 | 20240912115501_2GK22 | USL00E | 2024-09-16T12:16:35.426Z | 2024-09-19T12:21:23.991Z |
5096724 | 5096724 | 20240912113427_ZlQWV | USL00E | 2024-09-16T12:16:32.959Z | 2024-09-19T12:21:23.518Z |
5096427 | 5096427 | 20240912104920_7r03D | USL00E | 2024-09-16T12:16:23.294Z | 2024-09-19T12:21:22.293Z |
5096279 | 5096279 | 20240912102740_pG703 | USL00E | 2024-09-16T12:16:18.740Z | 2024-09-19T12:21:22.010Z |
5095892 | 5095892 | 20240912092252_Gj0kf | USL00E | 2024-09-16T12:16:01.516Z | 2024-09-19T12:21:20.602Z |
5095815 | 5095815 | 20240912090844_U8de3 | USL00E | 2024-09-16T12:15:58.927Z | 2024-09-19T12:21:20.336Z |
5095623 | 5095623 | 20240912083017_yN1sc | USL00E | 2024-09-16T12:15:51.480Z | 2024-09-19T12:21:19.395Z |
5095555 | 5095555 | 20240912080249_X5PNS | USL00E | 2024-09-16T12:15:48.991Z | 2024-09-19T12:21:19.011Z |
5095226 | 5095226 | 20240912064632_a382S | USL00E | 2024-09-16T12:15:25.100Z | 2024-09-19T12:21:17.568Z |
5095152 | 5095152 | 20240912061639_JXY5I | USL00E | 2024-09-16T12:15:19.432Z | 2024-09-19T12:21:17.405Z |
5094998 | 5094998 | 20240912050629_ejMR7 | USL00E | 2024-09-16T12:15:08.392Z | 2024-09-19T12:21:16.904Z |
5094982 | 5094982 | 20240912045928_5THRf | USL00E | 2024-09-16T12:15:06.624Z | 2024-09-19T12:21:16.797Z |
5082243 | 5082243 | 20240911094411_VSFGW | USL00E | 2024-09-15T12:18:09.003Z | 2024-09-19T12:21:47.564Z |
5082237 | 5082237 | 20240911094251_ResD5 | USL00E | 2024-09-15T12:18:08.903Z | 2024-09-19T12:21:47.548Z |
5081818 | 5081818 | 20240911084610_0OjJb | USL00E | 2024-09-15T12:17:49.531Z | 2024-09-19T12:21:46.499Z |
5081749 | 5081749 | 20240911083750_PZ0H7 | USL00E | 2024-09-15T12:17:45.759Z | 2024-09-19T12:21:46.365Z |
5081211 | 5081211 | 20240911065558_cZZmi | USL00E | 2024-09-15T12:17:26.947Z | 2024-09-19T12:21:44.760Z |
5081017 | 5081017 | 20240911060141_4M5eI | USL00E | 2024-09-15T12:17:20.625Z | 2024-09-19T12:21:44.395Z |
5080990 | 5080990 | 20240911055414_UFs3f | USL00E | 2024-09-15T12:17:19.869Z | 2024-09-19T12:21:44.251Z |
5080868 | 5080868 | 20240911050825_uM9pd | USL00E | 2024-09-15T12:17:16.212Z | 2024-09-19T12:21:43.953Z |
5080767 | 5080767 | 20240911044310_kzJtt | USL00E | 2024-09-15T12:17:12.702Z | 2024-09-19T12:21:43.622Z |
5068749 | 5068749 | 20240910121700_uyYiF | USL00E | 2024-09-14T12:19:20.998Z | 2024-09-18T12:15:26.590Z |
5067850 | 5067850 | 20240910101949_Krpuo | USL00E | 2024-09-14T12:19:00.412Z | 2024-09-18T12:15:24.962Z |
5067781 | 5067781 | 20240910101126_G283y | USL00E | 2024-09-14T12:18:57.316Z | 2024-09-18T12:15:24.881Z |
5067724 | 5067724 | 20240910100516_7sdXg | USL00E | 2024-09-14T12:18:55.305Z | 2024-09-18T12:15:24.793Z |
5067285 | 5067285 | 20240910091530_9Jgsu | USL00E | 2024-09-14T12:18:38.269Z | 2024-09-18T12:15:23.741Z |
5067254 | 5067254 | 20240910091303_KvM0K | USL00E | 2024-09-14T12:18:37.391Z | 2024-09-18T12:15:23.689Z |
5066871 | 5066871 | 20240910082619_BsJPw | USL00E | 2024-09-14T12:18:17.477Z | 2024-09-18T12:15:22.906Z |
5066841 | 5066841 | 20240910082226_00oUj | USL00E | 2024-09-14T12:18:16.133Z | 2024-09-18T12:15:22.841Z |
5066731 | 5066731 | 20240910081026_4fpec | USL00E | 2024-09-14T12:18:09.680Z | 2024-09-18T12:15:22.632Z |
5066307 | 5066307 | 20240910070945_z3tCj | USL00E | 2024-09-14T12:17:49.379Z | 2024-09-18T12:15:21.580Z |
5066151 | 5066151 | 20240910064354_a9EbU | USL00E | 2024-09-14T12:17:42.189Z | 2024-09-18T12:15:21.253Z |
5065990 | 5065990 | 20240910061427_2a70r | USL00E | 2024-09-14T12:17:33.835Z | 2024-09-18T12:15:20.955Z |
5065368 | 5065368 | 20240910035601_mxPtu | USL00E | 2024-09-14T12:17:02.113Z | 2024-09-18T12:15:19.218Z |
5056708 | 5056708 | 20240908111213_tvIz2 | USL00E | 2024-09-13T12:17:38.101Z | 2024-09-16T12:21:26.825Z |
5056636 | 5056636 | 20240908105451_BGnbD | USL00E | 2024-09-13T12:17:36.542Z | 2024-09-16T12:21:26.270Z |
5055860 | 5055860 | 20240908091138_8etYB | USL00E | 2024-09-13T12:17:24.362Z | 2024-09-16T12:21:22.266Z |
5055839 | 5055839 | 20240908090905_JwsEO | USL00E | 2024-09-13T12:17:23.907Z | 2024-09-16T12:21:22.174Z |
5055316 | 5055316 | 20240908074605_3bfHS | USL00E | 2024-09-13T12:17:09.661Z | 2024-09-16T12:21:18.724Z |
5049957 | 5049957 | 20240909120357_Uk2ys | USL00E | 2024-09-13T12:12:33.624Z | 2024-09-17T12:19:11.971Z |
5049898 | 5049898 | 20240909115420_JVEIP | USL00E | 2024-09-13T12:12:30.677Z | 2024-09-17T12:19:11.799Z |
5049579 | 5049579 | 20240909111512_HkNuc | USL00E | 2024-09-13T12:12:18.880Z | 2024-09-17T12:19:10.960Z |
5049467 | 5049467 | 20240909105906_vs9pq | USL00E | 2024-09-13T12:12:14.039Z | 2024-09-17T12:19:10.550Z |
5049392 | 5049392 | 20240909104910_05QJu | USL00E | 2024-09-13T12:12:05.639Z | 2024-09-17T12:19:10.297Z |
5049053 | 5049053 | 20240909095639_3OpW6 | USL00E | 2024-09-13T12:11:30.179Z | 2024-09-17T12:19:09.067Z |
5048976 | 5048976 | 20240909094129_HSp2s | USL00E | 2024-09-13T12:11:25.635Z | 2024-09-17T12:19:08.754Z |
5048646 | 5048646 | 20240909084540_TCAim | USL00E | 2024-09-13T12:11:07.151Z | 2024-09-17T12:19:07.793Z |
5048256 | 5048256 | 20240909072723_0if2Q | USL00E | 2024-09-13T12:10:23.099Z | 2024-09-17T12:19:06.181Z |
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);