participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "USL008" 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 |
---|---|---|---|---|---|
5505605 | 5505605 | 20241108062236_52ryu | USL008 | 2024-11-09T14:16:25.113Z | 2024-11-09T14:16:28.826Z |
5505598 | 5505598 | 20241108062020_mL3vw | USL008 | 2024-11-09T14:16:24.811Z | 2024-11-09T14:16:28.824Z |
5505595 | 5505595 | 20241108061952_QdQ68 | USL008 | 2024-11-09T14:16:24.687Z | 2024-11-09T14:16:28.823Z |
5505375 | 5505375 | 20241108045654_wYfy3 | USL008 | 2024-11-09T14:16:14.352Z | 2024-11-09T14:16:28.768Z |
5505358 | 5505358 | 20241108044937_dCYB1 | USL008 | 2024-11-09T14:16:12.948Z | 2024-11-09T14:16:28.764Z |
5505128 | 5505128 | 20241108035642_y9K82 | USL008 | 2024-11-09T14:15:46.550Z | 2024-11-09T14:16:28.707Z |
5504742 | 5504742 | 20241108025106_YODoZ | USL008 | 2024-11-09T14:15:08.447Z | 2024-11-09T14:16:28.614Z |
5499637 | 5499637 | 20241108124729_0npy4 | USL008 | 2024-11-09T14:04:30.942Z | 2024-11-09T14:04:30.942Z |
5499593 | 5499593 | 20241108124045_2Zdv2 | USL008 | 2024-11-09T14:04:24.838Z | 2024-11-09T14:04:24.838Z |
5499498 | 5499498 | 20241108122802_CNW43 | USL008 | 2024-11-09T14:04:13.083Z | 2024-11-09T14:04:13.083Z |
5499480 | 5499480 | 20241108122733_TihtQ | USL008 | 2024-11-09T14:04:11.119Z | 2024-11-09T14:04:11.119Z |
5499420 | 5499420 | 20241108121738_ZfyKo | USL008 | 2024-11-09T14:04:05.311Z | 2024-11-09T14:04:05.311Z |
5499378 | 5499378 | 20241108120851_nnZcP | USL008 | 2024-11-09T14:03:54.659Z | 2024-11-09T14:03:54.659Z |
5499274 | 5499274 | 20241108114844_UIolV | USL008 | 2024-11-09T14:03:40.751Z | 2024-11-09T14:03:40.751Z |
5499262 | 5499262 | 20241108114712_uHJPs | USL008 | 2024-11-09T14:03:39.057Z | 2024-11-09T14:03:39.057Z |
5499230 | 5499230 | 20241108114007_7zssE | USL008 | 2024-11-09T14:03:35.105Z | 2024-11-09T14:03:35.105Z |
5499138 | 5499138 | 20241108111748_rvA7d | USL008 | 2024-11-09T14:03:24.547Z | 2024-11-09T14:03:24.547Z |
5499118 | 5499118 | 20241108111159_tkHen | USL008 | 2024-11-09T14:03:15.880Z | 2024-11-09T14:03:15.880Z |
5499067 | 5499067 | 20241108105814_DO5ce | USL008 | 2024-11-09T14:03:05.330Z | 2024-11-09T14:03:05.330Z |
5498825 | 5498825 | 20241108100937_g3BIS | USL008 | 2024-11-09T14:02:30.023Z | 2024-11-09T14:02:30.023Z |
5498781 | 5498781 | 20241108095855_7ACGk | USL008 | 2024-11-09T14:02:23.910Z | 2024-11-09T14:02:23.910Z |
5498764 | 5498764 | 20241108095428_qKQ9P | USL008 | 2024-11-09T14:02:22.118Z | 2024-11-09T14:02:22.118Z |
5498714 | 5498714 | 20241108094059_x0gbk | USL008 | 2024-11-09T14:02:15.137Z | 2024-11-09T14:02:15.137Z |
5498649 | 5498649 | 20241108093021_u3dP8 | USL008 | 2024-11-09T14:02:05.861Z | 2024-11-09T14:02:05.861Z |
5498518 | 5498518 | 20241108085533_vHjQ3 | USL008 | 2024-11-09T14:01:41.598Z | 2024-11-09T14:01:41.598Z |
5498447 | 5498447 | 20241108083356_bSHZo | USL008 | 2024-11-09T14:01:31.086Z | 2024-11-09T14:01:31.086Z |
5498443 | 5498443 | 20241108083349_IaPCD | USL008 | 2024-11-09T14:01:30.729Z | 2024-11-09T14:01:30.729Z |
5498392 | 5498392 | 20241108082533_tlMCI | USL008 | 2024-11-09T14:01:23.430Z | 2024-11-09T14:01:23.430Z |
5498266 | 5498266 | 20241108074710_4QRDV | USL008 | 2024-11-09T14:00:59.603Z | 2024-11-09T14:00:59.603Z |
5498242 | 5498242 | 20241108074124_Bpyed | USL008 | 2024-11-09T14:00:55.939Z | 2024-11-09T14:00:55.939Z |
5498227 | 5498227 | 20241108073455_JM7mD | USL008 | 2024-11-09T14:00:53.479Z | 2024-11-09T14:00:53.479Z |
5498217 | 5498217 | 20241108073419_ptD6E | USL008 | 2024-11-09T14:00:52.067Z | 2024-11-09T14:00:52.067Z |
5498164 | 5498164 | 20241108071934_IdMNF | USL008 | 2024-11-09T14:00:42.145Z | 2024-11-09T14:00:42.145Z |
5498153 | 5498153 | 20241108071553_d3sac | USL008 | 2024-11-09T14:00:39.791Z | 2024-11-09T14:00:39.791Z |
5498142 | 5498142 | 20241108071253_fu5Vz | USL008 | 2024-11-09T14:00:37.856Z | 2024-11-09T14:00:37.856Z |
5498084 | 5498084 | 20241108064619_vIMXL | USL008 | 2024-11-09T14:00:26.157Z | 2024-11-09T14:00:26.157Z |
5498076 | 5498076 | 20241108064410_PqbsX | USL008 | 2024-11-09T14:00:24.754Z | 2024-11-09T14:00:24.754Z |
5498052 | 5498052 | 20241108063506_iTAji | USL008 | 2024-11-09T14:00:20.213Z | 2024-11-09T14:00:20.213Z |
5498018 | 5498018 | 20241108062502_m437o | USL008 | 2024-11-09T14:00:10.179Z | 2024-11-09T14:00:10.179Z |
5497909 | 5497909 | 20241107060012_2v0nc | USL008 | 2024-11-08T14:14:30.315Z | 2024-11-09T14:18:53.559Z |
5497802 | 5497802 | 20241107051857_HTF3f | USL008 | 2024-11-08T14:14:23.194Z | 2024-11-09T14:18:52.299Z |
5497784 | 5497784 | 20241107051446_3drxF | USL008 | 2024-11-08T14:14:20.941Z | 2024-11-09T14:18:52.008Z |
5497777 | 5497777 | 20241107051111_pTNym | USL008 | 2024-11-08T14:14:20.223Z | 2024-11-09T14:18:51.816Z |
5497571 | 5497571 | 20241107040206_Antia | USL008 | 2024-11-08T14:13:59.339Z | 2024-11-09T14:18:46.399Z |
5497499 | 5497499 | 20241107035040_a5dTb | USL008 | 2024-11-08T14:13:54.599Z | 2024-11-09T14:18:44.818Z |
5497095 | 5497095 | 20241107024144_7whu4 | USL008 | 2024-11-08T14:13:09.984Z | 2024-11-09T14:18:35.504Z |
5496907 | 5496907 | 20241107020845_gecdm | USL008 | 2024-11-08T14:12:58.374Z | 2024-11-09T14:18:32.896Z |
5496862 | 5496862 | 20241107020014_9FveL | USL008 | 2024-11-08T14:12:55.675Z | 2024-11-09T14:18:31.496Z |
5493659 | 5493659 | 20241107125626_1ItMX | USL008 | 2024-11-08T14:04:26.877Z | 2024-11-09T14:16:27.687Z |
5493519 | 5493519 | 20241107122452_L3Eiw | USL008 | 2024-11-08T14:03:56.855Z | 2024-11-09T14:16:27.646Z |
5493475 | 5493475 | 20241107121941_5IiuS | USL008 | 2024-11-08T14:03:51.193Z | 2024-11-09T14:16:27.636Z |
5493462 | 5493462 | 20241107121627_GfuAn | USL008 | 2024-11-08T14:03:49.944Z | 2024-11-09T14:16:27.631Z |
5493314 | 5493314 | 20241107114632_TWnrT | USL008 | 2024-11-08T14:03:32.283Z | 2024-11-09T14:16:27.585Z |
5493173 | 5493173 | 20241107111238_zlYKh | USL008 | 2024-11-08T14:03:02.543Z | 2024-11-09T14:16:27.553Z |
5492997 | 5492997 | 20241107103338_3lBxG | USL008 | 2024-11-08T14:02:41.285Z | 2024-11-09T14:16:27.504Z |
5492993 | 5492993 | 20241107103310_pptud | USL008 | 2024-11-08T14:02:40.998Z | 2024-11-09T14:16:27.503Z |
5492932 | 5492932 | 20241107102136_4jyrb | USL008 | 2024-11-08T14:02:35.837Z | 2024-11-09T14:16:27.491Z |
5492762 | 5492762 | 20241107095253_DbU0K | USL008 | 2024-11-08T14:02:02.944Z | 2024-11-09T14:16:27.448Z |
5492698 | 5492698 | 20241107093337_c5eDN | USL008 | 2024-11-08T14:01:55.168Z | 2024-11-09T14:16:27.431Z |
5492606 | 5492606 | 20241107091427_r3hgt | USL008 | 2024-11-08T14:01:32.897Z | 2024-11-09T14:16:27.412Z |
5492554 | 5492554 | 20241107085935_3wEzI | USL008 | 2024-11-08T14:01:24.676Z | 2024-11-09T14:16:27.400Z |
5492537 | 5492537 | 20241107085533_2L21m | USL008 | 2024-11-08T14:01:22.432Z | 2024-11-09T14:16:27.395Z |
5492477 | 5492477 | 20241107084011_gTjV7 | USL008 | 2024-11-08T14:01:15.697Z | 2024-11-09T14:16:27.382Z |
5492459 | 5492459 | 20241107083817_knmHn | USL008 | 2024-11-08T14:01:13.899Z | 2024-11-09T14:16:27.378Z |
5492448 | 5492448 | 20241107083540_BQV8N | USL008 | 2024-11-08T14:01:12.490Z | 2024-11-09T14:16:27.376Z |
5492441 | 5492441 | 20241107083459_dtn8r | USL008 | 2024-11-08T14:01:11.268Z | 2024-11-09T14:16:27.374Z |
5492438 | 5492438 | 20241107083424_673Z9 | USL008 | 2024-11-08T14:01:10.218Z | 2024-11-09T14:16:27.373Z |
5492435 | 5492435 | 20241107083325_YEDKH | USL008 | 2024-11-08T14:01:08.035Z | 2024-11-09T14:16:27.372Z |
5492399 | 5492399 | 20241107082337_CYA5A | USL008 | 2024-11-08T14:01:00.064Z | 2024-11-09T14:16:27.364Z |
5492387 | 5492387 | 20241107082101_flxdQ | USL008 | 2024-11-08T14:00:58.450Z | 2024-11-09T14:16:27.361Z |
5492344 | 5492344 | 20241107081156_CazBR | USL008 | 2024-11-08T14:00:50.043Z | 2024-11-09T14:16:27.350Z |
5492251 | 5492251 | 20241107074705_fiJcL | USL008 | 2024-11-08T14:00:37.803Z | 2024-11-09T14:16:27.328Z |
5492240 | 5492240 | 20241107074202_hevPN | USL008 | 2024-11-08T14:00:36.189Z | 2024-11-09T14:16:27.326Z |
5492173 | 5492173 | 20241107071933_fWwq4 | USL008 | 2024-11-08T14:00:23.495Z | 2024-11-09T14:16:27.303Z |
5492016 | 5492016 | 20241105051745_N3YY7 | USL008 | 2024-11-07T14:20:32.039Z | 2024-11-09T14:21:21.343Z |
5491925 | 5491925 | 20241106062639_A3QMp | USL008 | 2024-11-07T14:17:19.751Z | 2024-11-09T14:20:16.273Z |
5491913 | 5491913 | 20241106061943_YmDVN | USL008 | 2024-11-07T14:17:19.432Z | 2024-11-09T14:20:16.206Z |
5491891 | 5491891 | 20241106060418_6O8Pr | USL008 | 2024-11-07T14:17:18.548Z | 2024-11-09T14:20:15.921Z |
5491860 | 5491860 | 20241106053622_SCrb2 | USL008 | 2024-11-07T14:17:13.698Z | 2024-11-09T14:20:15.457Z |
5491845 | 5491845 | 20241106053228_2zl0K | USL008 | 2024-11-07T14:17:10.247Z | 2024-11-09T14:20:15.367Z |
5491782 | 5491782 | 20241106050947_s125G | USL008 | 2024-11-07T14:16:59.257Z | 2024-11-09T14:20:14.643Z |
5491777 | 5491777 | 20241106050658_zCz2N | USL008 | 2024-11-07T14:16:57.295Z | 2024-11-09T14:20:14.569Z |
5491739 | 5491739 | 20241106045208_9DUR9 | USL008 | 2024-11-07T14:16:52.996Z | 2024-11-09T14:20:14.056Z |
5491029 | 5491029 | 20241106014034_yIAMc | USL008 | 2024-11-07T14:15:14.140Z | 2024-11-09T14:20:03.234Z |
5485886 | 5485886 | 20241106081617_QC00d | USL008 | 2024-11-07T14:01:00.607Z | 2024-11-09T14:16:33.969Z |
5485776 | 5485776 | 20241106072549_fjSCQ | USL008 | 2024-11-07T14:00:35.907Z | 2024-11-09T14:16:32.104Z |
5485706 | 5485706 | 20241106064950_f22mF | USL008 | 2024-11-07T14:00:20.597Z | 2024-11-09T14:16:30.943Z |
5485685 | 5485685 | 20241106064224_3soaU | USL008 | 2024-11-07T14:00:14.861Z | 2024-11-09T14:16:30.592Z |
5485682 | 5485682 | 20241106064048_qCoQE | USL008 | 2024-11-07T14:00:14.270Z | 2024-11-09T14:16:30.545Z |
5485673 | 5485673 | 20241106063826_SE5sp | USL008 | 2024-11-07T14:00:12.294Z | 2024-11-09T14:16:30.429Z |
5485516 | 5485516 | 20241105061533_bpzZg | USL008 | 2024-11-06T14:18:24.080Z | 2024-11-09T14:21:22.415Z |
5485508 | 5485508 | 20241105061316_2FBl2 | USL008 | 2024-11-06T14:18:23.661Z | 2024-11-09T14:21:22.340Z |
5485502 | 5485502 | 20241105060850_iFp2p | USL008 | 2024-11-06T14:18:23.122Z | 2024-11-09T14:21:22.295Z |
5485449 | 5485449 | 20241105054424_JfB3O | USL008 | 2024-11-06T14:18:18.676Z | 2024-11-09T14:21:21.655Z |
5485423 | 5485423 | 20241105053219_WUwXO | USL008 | 2024-11-06T14:18:15.252Z | 2024-11-09T14:21:21.536Z |
5485414 | 5485414 | 20241105053113_iQ5fg | USL008 | 2024-11-06T14:18:14.538Z | 2024-11-09T14:21:21.518Z |
5485392 | 5485392 | 20241105051743_BOB97 | USL008 | 2024-11-06T14:18:12.044Z | 2024-11-09T14:21:21.329Z |
5485318 | 5485318 | 20241105044809_Mz1a0 | USL008 | 2024-11-06T14:18:07.396Z | 2024-11-09T14:21:20.759Z |
5485251 | 5485251 | 20241105043045_33URY | USL008 | 2024-11-06T14:17:59.475Z | 2024-11-09T14:21:20.296Z |
5485211 | 5485211 | 20241105042243_m4294 | USL008 | 2024-11-06T14:17:54.356Z | 2024-11-09T14:21:20.025Z |
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);