participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
25,982 rows where station_code = "USL00J" 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 |
---|---|---|---|---|---|
5134838 | 5134838 | 20240916122511_h09rP | USL00J | 2024-09-19T12:18:07.684Z | 2024-09-19T12:18:07.684Z |
5134765 | 5134765 | 20240916114501_EwEhF | USL00J | 2024-09-19T12:18:06.083Z | 2024-09-19T12:18:06.083Z |
5134739 | 5134739 | 20240916113528_G581m | USL00J | 2024-09-19T12:18:05.392Z | 2024-09-19T12:18:05.392Z |
5134682 | 5134682 | 20240916111618_48Pwz | USL00J | 2024-09-19T12:18:03.317Z | 2024-09-19T12:18:03.317Z |
5134608 | 5134608 | 20240916104929_W3BeR | USL00J | 2024-09-19T12:17:55.545Z | 2024-09-19T12:17:55.545Z |
5134522 | 5134522 | 20240916100438_DLD9S | USL00J | 2024-09-19T12:17:48.172Z | 2024-09-19T12:17:48.172Z |
5134442 | 5134442 | 20240916091834_HsAa7 | USL00J | 2024-09-19T12:17:44.113Z | 2024-09-19T12:17:44.113Z |
5134393 | 5134393 | 20240916085128_Pvm0c | USL00J | 2024-09-19T12:17:42.064Z | 2024-09-19T12:17:42.064Z |
5134380 | 5134380 | 20240916084129_gzmHq | USL00J | 2024-09-19T12:17:40.308Z | 2024-09-19T12:17:40.308Z |
5134329 | 5134329 | 20240916081608_gkhHn | USL00J | 2024-09-19T12:17:37.152Z | 2024-09-19T12:17:37.152Z |
5126068 | 5126068 | 20240918074945_jIbzQ | USL00J | 2024-09-19T12:04:53.537Z | 2024-09-19T12:06:42.135Z |
5126057 | 5126057 | 20240918074349_FzRyZ | USL00J | 2024-09-19T12:04:52.289Z | 2024-09-19T12:06:42.133Z |
5125567 | 5125567 | 20240918030201_Fg6tL | USL00J | 2024-09-19T12:03:32.879Z | 2024-09-19T12:06:42.052Z |
5123874 | 5123874 | 20240914115458_QS6r6 | USL00J | 2024-09-18T12:11:59.191Z | 2024-09-19T12:20:15.946Z |
5123365 | 5123365 | 20240914095230_j3hoY | USL00J | 2024-09-18T12:11:46.889Z | 2024-09-19T12:20:10.575Z |
5122999 | 5122999 | 20240914083721_N2MWr | USL00J | 2024-09-18T12:11:37.548Z | 2024-09-19T12:20:07.205Z |
5122899 | 5122899 | 20240914081820_ZcoJ9 | USL00J | 2024-09-18T12:11:33.745Z | 2024-09-19T12:20:06.662Z |
5122483 | 5122483 | 20240914064142_WAjve | USL00J | 2024-09-18T12:11:20.630Z | 2024-09-19T12:20:04.520Z |
5122415 | 5122415 | 20240914061511_axhsA | USL00J | 2024-09-18T12:11:17.794Z | 2024-09-19T12:20:04.251Z |
5121226 | 5121226 | 20240914035608_82nzd | USL00J | 2024-09-18T12:10:52.578Z | 2024-09-19T12:20:01.516Z |
5118990 | 5118990 | 20240915115909_mXfNg | USL00J | 2024-09-18T12:09:17.270Z | 2024-09-19T12:19:28.067Z |
5118970 | 5118970 | 20240915115124_aXD0l | USL00J | 2024-09-18T12:09:15.960Z | 2024-09-19T12:19:27.923Z |
5118845 | 5118845 | 20240915111912_HGtmt | USL00J | 2024-09-18T12:09:07.946Z | 2024-09-19T12:19:26.500Z |
5118803 | 5118803 | 20240915111108_Yx3fm | USL00J | 2024-09-18T12:09:03.773Z | 2024-09-19T12:19:25.611Z |
5118795 | 5118795 | 20240915110906_3hxq9 | USL00J | 2024-09-18T12:09:03.525Z | 2024-09-19T12:19:25.525Z |
5118758 | 5118758 | 20240915110155_Gb24R | USL00J | 2024-09-18T12:09:01.584Z | 2024-09-19T12:19:25.329Z |
5118699 | 5118699 | 20240915104913_65L7Z | USL00J | 2024-09-18T12:08:59.362Z | 2024-09-19T12:19:24.999Z |
5118634 | 5118634 | 20240915103611_TdCo3 | USL00J | 2024-09-18T12:08:54.733Z | 2024-09-19T12:19:24.585Z |
5118628 | 5118628 | 20240915103253_RmSnt | USL00J | 2024-09-18T12:08:54.166Z | 2024-09-19T12:19:24.542Z |
5118477 | 5118477 | 20240915095544_lyK6D | USL00J | 2024-09-18T12:08:47.044Z | 2024-09-19T12:19:23.241Z |
5118423 | 5118423 | 20240915094427_PbXBF | USL00J | 2024-09-18T12:08:43.443Z | 2024-09-19T12:19:22.728Z |
5118162 | 5118162 | 20240915084542_zuLxd | USL00J | 2024-09-18T12:08:27.866Z | 2024-09-19T12:19:20.991Z |
5118032 | 5118032 | 20240915081127_dDvUf | USL00J | 2024-09-18T12:08:19.437Z | 2024-09-19T12:19:19.867Z |
5117952 | 5117952 | 20240915075543_hPHtS | USL00J | 2024-09-18T12:08:10.507Z | 2024-09-19T12:19:19.289Z |
5116904 | 5116904 | 20240915034814_alspD | USL00J | 2024-09-18T12:07:25.276Z | 2024-09-19T12:19:12.648Z |
5110161 | 5110161 | 20240913121812_ld3ww | USL00J | 2024-09-17T12:14:58.093Z | 2024-09-19T12:20:55.877Z |
5110138 | 5110138 | 20240913121100_uL6lb | USL00J | 2024-09-17T12:14:57.299Z | 2024-09-19T12:20:55.821Z |
5110096 | 5110096 | 20240913120318_wF5tw | USL00J | 2024-09-17T12:14:56.874Z | 2024-09-19T12:20:55.752Z |
5110078 | 5110078 | 20240913120247_BclXw | USL00J | 2024-09-17T12:14:56.696Z | 2024-09-19T12:20:55.737Z |
5109973 | 5109973 | 20240913114227_3mAuP | USL00J | 2024-09-17T12:14:52.387Z | 2024-09-19T12:20:55.523Z |
5109902 | 5109902 | 20240913113509_hofyW | USL00J | 2024-09-17T12:14:48.886Z | 2024-09-19T12:20:55.341Z |
5109807 | 5109807 | 20240913110943_cy2KO | USL00J | 2024-09-17T12:14:46.571Z | 2024-09-19T12:20:54.820Z |
5109792 | 5109792 | 20240913110614_Wq9w3 | USL00J | 2024-09-17T12:14:46.115Z | 2024-09-19T12:20:54.761Z |
5109786 | 5109786 | 20240913110525_fBvQ3 | USL00J | 2024-09-17T12:14:46.080Z | 2024-09-19T12:20:54.748Z |
5109781 | 5109781 | 20240913110502_aqdzM | USL00J | 2024-09-17T12:14:46.034Z | 2024-09-19T12:20:54.742Z |
5109764 | 5109764 | 20240913110353_O3jVq | USL00J | 2024-09-17T12:14:45.586Z | 2024-09-19T12:20:54.719Z |
5109705 | 5109705 | 20240913105033_ozsqA | USL00J | 2024-09-17T12:14:44.337Z | 2024-09-19T12:20:54.544Z |
5109679 | 5109679 | 20240913104524_wG2Dq | USL00J | 2024-09-17T12:14:43.598Z | 2024-09-19T12:20:54.439Z |
5109641 | 5109641 | 20240913104014_JTs9d | USL00J | 2024-09-17T12:14:42.641Z | 2024-09-19T12:20:54.005Z |
5109618 | 5109618 | 20240913103626_SUIep | USL00J | 2024-09-17T12:14:42.199Z | 2024-09-19T12:20:53.890Z |
5109613 | 5109613 | 20240913103618_FCtzB | USL00J | 2024-09-17T12:14:42.163Z | 2024-09-19T12:20:53.885Z |
5109593 | 5109593 | 20240913103140_zo9RM | USL00J | 2024-09-17T12:14:41.841Z | 2024-09-19T12:20:53.802Z |
5109570 | 5109570 | 20240913102954_qOeyT | USL00J | 2024-09-17T12:14:41.528Z | 2024-09-19T12:20:53.765Z |
5109549 | 5109549 | 20240913102440_dSLcG | USL00J | 2024-09-17T12:14:41.044Z | 2024-09-19T12:20:53.722Z |
5109404 | 5109404 | 20240913095032_u8XTz | USL00J | 2024-09-17T12:14:37.469Z | 2024-09-19T12:20:53.227Z |
5109314 | 5109314 | 20240913093122_lYA8f | USL00J | 2024-09-17T12:14:35.345Z | 2024-09-19T12:20:52.831Z |
5109293 | 5109293 | 20240913092735_cVYNK | USL00J | 2024-09-17T12:14:34.809Z | 2024-09-19T12:20:52.780Z |
5109162 | 5109162 | 20240913090114_aCOEM | USL00J | 2024-09-17T12:14:32.045Z | 2024-09-19T12:20:52.342Z |
5109156 | 5109156 | 20240913090035_bjTpN | USL00J | 2024-09-17T12:14:31.863Z | 2024-09-19T12:20:52.320Z |
5108907 | 5108907 | 20240913080222_aRa39 | USL00J | 2024-09-17T12:14:16.777Z | 2024-09-19T12:20:51.104Z |
5108887 | 5108887 | 20240913075552_JTSYk | USL00J | 2024-09-17T12:14:14.493Z | 2024-09-19T12:20:51.015Z |
5108775 | 5108775 | 20240913072726_4q3b9 | USL00J | 2024-09-17T12:14:05.826Z | 2024-09-19T12:20:50.730Z |
5108648 | 5108648 | 20240913065354_wawd0 | USL00J | 2024-09-17T12:13:55.644Z | 2024-09-19T12:20:50.170Z |
5108604 | 5108604 | 20240913064057_0e2RC | USL00J | 2024-09-17T12:13:53.234Z | 2024-09-19T12:20:49.790Z |
5108557 | 5108557 | 20240913062647_d4Gwa | USL00J | 2024-09-17T12:13:51.096Z | 2024-09-19T12:20:49.512Z |
5108402 | 5108402 | 20240913052537_hme2T | USL00J | 2024-09-17T12:13:42.956Z | 2024-09-19T12:20:48.675Z |
5108393 | 5108393 | 20240913052010_sFinq | USL00J | 2024-09-17T12:13:42.517Z | 2024-09-19T12:20:48.649Z |
5108346 | 5108346 | 20240913045750_siQpO | USL00J | 2024-09-17T12:13:37.758Z | 2024-09-19T12:20:48.301Z |
5108326 | 5108326 | 20240913045035_9HI9S | USL00J | 2024-09-17T12:13:36.697Z | 2024-09-19T12:20:48.150Z |
5108293 | 5108293 | 20240913044556_2uciR | USL00J | 2024-09-17T12:13:35.142Z | 2024-09-19T12:20:48.020Z |
5108039 | 5108039 | 20240913042048_A45YE | USL00J | 2024-09-17T12:13:29.011Z | 2024-09-19T12:20:47.776Z |
5107414 | 5107414 | 20240913035459_Wnmb3 | USL00J | 2024-09-17T12:13:14.648Z | 2024-09-19T12:20:47.106Z |
5096692 | 5096692 | 20240912113103_2tr8p | USL00J | 2024-09-16T12:16:31.933Z | 2024-09-19T12:21:23.438Z |
5096591 | 5096591 | 20240912111845_sMXtH | USL00J | 2024-09-16T12:16:28.213Z | 2024-09-19T12:21:22.949Z |
5096575 | 5096575 | 20240912111538_SyPrl | USL00J | 2024-09-16T12:16:27.844Z | 2024-09-19T12:21:22.895Z |
5096465 | 5096465 | 20240912105451_wr9GD | USL00J | 2024-09-16T12:16:24.096Z | 2024-09-19T12:21:22.365Z |
5096345 | 5096345 | 20240912103641_Pnyy0 | USL00J | 2024-09-16T12:16:21.099Z | 2024-09-19T12:21:22.154Z |
5096270 | 5096270 | 20240912102715_SQcbY | USL00J | 2024-09-16T12:16:17.579Z | 2024-09-19T12:21:21.996Z |
5096258 | 5096258 | 20240912102532_vvfLq | USL00J | 2024-09-16T12:16:17.418Z | 2024-09-19T12:21:21.982Z |
5096164 | 5096164 | 20240912100932_2dwck | USL00J | 2024-09-16T12:16:12.373Z | 2024-09-19T12:21:21.759Z |
5096134 | 5096134 | 20240912100616_LRD80 | USL00J | 2024-09-16T12:16:11.498Z | 2024-09-19T12:21:21.741Z |
5096018 | 5096018 | 20240912094343_zoH0M | USL00J | 2024-09-16T12:16:05.536Z | 2024-09-19T12:21:20.985Z |
5096002 | 5096002 | 20240912093930_nqaMD | USL00J | 2024-09-16T12:16:05.070Z | 2024-09-19T12:21:20.869Z |
5095985 | 5095985 | 20240912093825_REKrX | USL00J | 2024-09-16T12:16:04.269Z | 2024-09-19T12:21:20.804Z |
5095822 | 5095822 | 20240912090932_YuPAO | USL00J | 2024-09-16T12:15:59.072Z | 2024-09-19T12:21:20.346Z |
5095615 | 5095615 | 20240912082907_AOKu2 | USL00J | 2024-09-16T12:15:51.277Z | 2024-09-19T12:21:19.376Z |
5095483 | 5095483 | 20240912074537_rvQcG | USL00J | 2024-09-16T12:15:43.064Z | 2024-09-19T12:21:18.664Z |
5095345 | 5095345 | 20240912072008_o0FCH | USL00J | 2024-09-16T12:15:34.245Z | 2024-09-19T12:21:18.190Z |
5095320 | 5095320 | 20240912071249_a6c1H | USL00J | 2024-09-16T12:15:32.377Z | 2024-09-19T12:21:18.133Z |
5095282 | 5095282 | 20240912065941_AHcAe | USL00J | 2024-09-16T12:15:29.355Z | 2024-09-19T12:21:17.923Z |
5095227 | 5095227 | 20240912064632_a382S | USL00J | 2024-09-16T12:15:25.100Z | 2024-09-19T12:21:17.568Z |
5095091 | 5095091 | 20240912054935_yboVw | USL00J | 2024-09-16T12:15:13.550Z | 2024-09-19T12:21:17.262Z |
5092437 | 5092437 | 20240912024619_80ONG | USL00J | 2024-09-16T12:13:54.251Z | 2024-09-19T12:21:14.110Z |
5092153 | 5092153 | 20240912023813_VWKxf | USL00J | 2024-09-16T12:13:42.225Z | 2024-09-19T12:21:13.675Z |
5082975 | 5082975 | 20240911113955_T2gpw | USL00J | 2024-09-15T12:18:32.240Z | 2024-09-19T12:21:49.009Z |
5082914 | 5082914 | 20240911112556_gNXH1 | USL00J | 2024-09-15T12:18:30.825Z | 2024-09-19T12:21:48.876Z |
5082804 | 5082804 | 20240911110043_z2v6t | USL00J | 2024-09-15T12:18:25.847Z | 2024-09-19T12:21:48.688Z |
5082547 | 5082547 | 20240911102411_G42SW | USL00J | 2024-09-15T12:18:18.424Z | 2024-09-19T12:21:48.065Z |
5082402 | 5082402 | 20240911100237_TX8Th | USL00J | 2024-09-15T12:18:14.266Z | 2024-09-19T12:21:47.947Z |
5082388 | 5082388 | 20240911100153_AHQni | USL00J | 2024-09-15T12:18:13.145Z | 2024-09-19T12:21:47.938Z |
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);