participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,729 rows where station_code = "USL00X" 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 |
---|---|---|---|---|---|
5096295 | 5096295 | 20240912102904_IjTF7 | USL00X | 2024-09-16T12:16:19.093Z | 2024-09-19T12:21:22.035Z |
5095841 | 5095841 | 20240912091425_hC6yO | USL00X | 2024-09-16T12:16:00.221Z | 2024-09-19T12:21:20.504Z |
5095790 | 5095790 | 20240912090203_TW0Yi | USL00X | 2024-09-16T12:15:58.247Z | 2024-09-19T12:21:20.232Z |
5082823 | 5082823 | 20240911110545_VuAnl | USL00X | 2024-09-15T12:18:26.399Z | 2024-09-19T12:21:48.735Z |
5082741 | 5082741 | 20240911105252_SPaXZ | USL00X | 2024-09-15T12:18:24.521Z | 2024-09-19T12:21:48.495Z |
5081843 | 5081843 | 20240911085024_spDP8 | USL00X | 2024-09-15T12:17:50.779Z | 2024-09-19T12:21:46.564Z |
5081574 | 5081574 | 20240911080430_MG6sE | USL00X | 2024-09-15T12:17:38.167Z | 2024-09-19T12:21:45.790Z |
5081315 | 5081315 | 20240911072031_7qHHK | USL00X | 2024-09-15T12:17:30.104Z | 2024-09-19T12:21:45.073Z |
5080476 | 5080476 | 20240911040150_3t43R | USL00X | 2024-09-15T12:17:04.826Z | 2024-09-19T12:21:43.311Z |
5068562 | 5068562 | 20240910114951_0IJPB | USL00X | 2024-09-14T12:19:18.047Z | 2024-09-18T12:15:26.312Z |
5068040 | 5068040 | 20240910104612_PL0BN | USL00X | 2024-09-14T12:19:07.498Z | 2024-09-18T12:15:25.418Z |
5067595 | 5067595 | 20240910094905_3fVx9 | USL00X | 2024-09-14T12:18:50.396Z | 2024-09-18T12:15:24.519Z |
5067261 | 5067261 | 20240910091319_Jf9BX | USL00X | 2024-09-14T12:18:37.561Z | 2024-09-18T12:15:23.694Z |
5066797 | 5066797 | 20240910081827_FeiwA | USL00X | 2024-09-14T12:18:12.723Z | 2024-09-18T12:15:22.760Z |
5056712 | 5056712 | 20240908111215_PymAU | USL00X | 2024-09-13T12:17:38.106Z | 2024-09-16T12:21:26.827Z |
5056567 | 5056567 | 20240908104417_TuIks | USL00X | 2024-09-13T12:17:35.405Z | 2024-09-16T12:21:25.933Z |
5056390 | 5056390 | 20240908102134_DS5jy | USL00X | 2024-09-13T12:17:31.190Z | 2024-09-16T12:21:24.836Z |
5055953 | 5055953 | 20240908092500_oHQeW | USL00X | 2024-09-13T12:17:25.913Z | 2024-09-16T12:21:22.666Z |
5055556 | 5055556 | 20240908082326_zJxxQ | USL00X | 2024-09-13T12:17:17.143Z | 2024-09-16T12:21:20.365Z |
5049099 | 5049099 | 20240909100610_6C9Qh | USL00X | 2024-09-13T12:11:33.899Z | 2024-09-17T12:19:09.160Z |
5048810 | 5048810 | 20240909091404_Nh8PK | USL00X | 2024-09-13T12:11:16.735Z | 2024-09-17T12:19:08.408Z |
5048699 | 5048699 | 20240909085635_v7h5T | USL00X | 2024-09-13T12:11:10.728Z | 2024-09-17T12:19:08.031Z |
5048621 | 5048621 | 20240909083858_FHKYl | USL00X | 2024-09-13T12:11:01.008Z | 2024-09-17T12:19:07.735Z |
5048148 | 5048148 | 20240909071204_xtkrR | USL00X | 2024-09-13T12:10:17.800Z | 2024-09-17T12:19:05.946Z |
5047884 | 5047884 | 20240909061827_rgYIb | USL00X | 2024-09-13T12:09:54.635Z | 2024-09-17T12:19:04.851Z |
5047743 | 5047743 | 20240909054413_l333G | USL00X | 2024-09-13T12:09:37.766Z | 2024-09-17T12:19:04.149Z |
5047602 | 5047602 | 20240909045721_NeCFZ | USL00X | 2024-09-13T12:09:27.608Z | 2024-09-17T12:19:03.660Z |
5042468 | 5042468 | 20240907114534_IVPJj | USL00X | 2024-09-12T12:17:12.282Z | 2024-09-16T12:20:53.154Z |
5042154 | 5042154 | 20240906100411_SJsBG | USL00X | 2024-09-12T12:16:56.360Z | 2024-09-14T12:23:16.262Z |
5042145 | 5042145 | 20240906100256_dh37y | USL00X | 2024-09-12T12:16:56.169Z | 2024-09-14T12:23:16.167Z |
5034994 | 5034994 | 20240907082803_WdWu2 | USL00X | 2024-09-12T12:11:48.399Z | 2024-09-15T12:21:37.847Z |
4905694 | 4905694 | 20240809111623_Yh2uo | USL00X | 2024-08-29T12:00:48.798Z | 2024-09-02T12:17:00.001Z |
4893649 | 4893649 | 20240809102537_cqh5H | USL00X | 2024-08-28T12:11:36.951Z | 2024-08-30T12:23:05.896Z |
4893615 | 4893615 | 20240809101609_tua6P | USL00X | 2024-08-28T12:11:35.071Z | 2024-08-30T12:23:03.733Z |
4868706 | 4868706 | 20240806070311_IKER4 | USL00X | 2024-08-18T12:24:24.393Z | 2024-08-19T12:28:56.620Z |
4860504 | 4860504 | 20240806104400_5L3W3 | USL00X | 2024-08-18T12:02:49.627Z | 2024-08-27T12:02:49.267Z |
4818022 | 4818022 | 20240804081946_szMix | USL00X | 2024-08-14T12:01:48.584Z | 2024-08-17T12:24:09.243Z |
4809099 | 4809099 | 20240803113857_FPC1p | USL00X | 2024-08-13T12:06:37.673Z | 2024-08-15T12:19:30.724Z |
4808830 | 4808830 | 20240803112152_RS2vK | USL00X | 2024-08-13T12:06:14.549Z | 2024-08-15T12:19:21.770Z |
4807881 | 4807881 | 20240803103043_TrSw2 | USL00X | 2024-08-13T12:04:18.333Z | 2024-08-15T12:18:42.665Z |
4807616 | 4807616 | 20240803101447_Xu8mp | USL00X | 2024-08-13T12:03:38.667Z | 2024-08-15T12:18:33.192Z |
4806984 | 4806984 | 20240803092124_Wk2qg | USL00X | 2024-08-13T12:02:04.024Z | 2024-08-15T12:18:16.952Z |
4798464 | 4798464 | 20240803085256_M5eUT | USL00X | 2024-08-12T12:03:41.188Z | 2024-08-15T12:18:03.743Z |
4797362 | 4797362 | 20240803045413_AFpLc | USL00X | 2024-08-12T12:00:19.304Z | 2024-08-15T12:17:07.267Z |
4787328 | 4787328 | 20240802060715_e2ogY | USL00X | 2024-08-11T12:01:40.292Z | 2024-08-13T12:15:27.625Z |
4787320 | 4787320 | 20240802060415_v7nj3 | USL00X | 2024-08-11T12:01:38.766Z | 2024-08-13T12:15:26.222Z |
4772620 | 4772620 | 20240801074810_6Du1s | USL00X | 2024-08-07T12:04:03.385Z | 2024-08-11T12:11:33.948Z |
4604112 | 4604112 | 20240710105410_1XDFy | USL00X | 2024-07-12T12:02:03.866Z | 2024-07-19T12:13:34.527Z |
4465468 | 4465468 | 20240615100829_urkIk | USL00X | 2024-06-16T12:04:32.790Z | 2024-06-23T12:12:09.978Z |
4465229 | 4465229 | 20240615085356_5sxLg | USL00X | 2024-06-16T12:03:59.357Z | 2024-06-23T12:12:04.395Z |
4465212 | 4465212 | 20240615085214_xBpjs | USL00X | 2024-06-16T12:03:57.869Z | 2024-06-23T12:12:04.127Z |
4465196 | 4465196 | 20240615084640_SO35T | USL00X | 2024-06-16T12:03:56.555Z | 2024-06-23T12:12:03.926Z |
4457670 | 4457670 | 20240613092043_ZyW8T | USL00X | 2024-06-14T12:03:18.741Z | 2024-06-21T12:11:41.412Z |
4457321 | 4457321 | 20240613072858_oMM9u | USL00X | 2024-06-14T12:02:53.085Z | 2024-06-21T12:11:38.544Z |
4456852 | 4456852 | 20240613040644_x3AA8 | USL00X | 2024-06-14T12:02:15.693Z | 2024-06-21T12:11:34.612Z |
4456813 | 4456813 | 20240613033532_tL1B6 | USL00X | 2024-06-14T12:02:10.922Z | 2024-06-21T12:11:34.112Z |
4450834 | 4450834 | 20240612104429_Ky3Sb | USL00X | 2024-06-13T12:03:09.016Z | 2024-06-20T12:12:02.309Z |
4450268 | 4450268 | 20240612074906_wcvch | USL00X | 2024-06-13T12:02:32.637Z | 2024-06-20T12:11:58.263Z |
4450039 | 4450039 | 20240612061955_f6uMu | USL00X | 2024-06-13T12:02:13.750Z | 2024-06-20T12:11:56.960Z |
4449925 | 4449925 | 20240612052809_p3rce | USL00X | 2024-06-13T12:02:02.865Z | 2024-06-20T12:11:55.893Z |
4449870 | 4449870 | 20240612050712_fqHbP | USL00X | 2024-06-13T12:01:57.864Z | 2024-06-20T12:11:55.557Z |
4447006 | 4447006 | 20240611094846_jnLBF | USL00X | 2024-06-12T12:03:38.291Z | 2024-06-19T12:13:39.989Z |
4446919 | 4446919 | 20240611092359_6YEHg | USL00X | 2024-06-12T12:03:32.815Z | 2024-06-19T12:13:39.006Z |
4446869 | 4446869 | 20240611090847_tjTqq | USL00X | 2024-06-12T12:03:29.553Z | 2024-06-19T12:13:38.655Z |
4446861 | 4446861 | 20240611090647_ePMrS | USL00X | 2024-06-12T12:03:28.792Z | 2024-06-19T12:13:38.398Z |
4446744 | 4446744 | 20240611082508_0EyK7 | USL00X | 2024-06-12T12:03:16.990Z | 2024-06-19T12:13:37.084Z |
4446424 | 4446424 | 20240611052317_pMSlr | USL00X | 2024-06-12T12:02:48.642Z | 2024-06-19T12:13:34.086Z |
4430073 | 4430073 | 20240606092555_7ul0k | USL00X | 2024-06-08T12:09:55.307Z | 2024-06-14T12:08:29.301Z |
4430028 | 4430028 | 20240606091421_2Xp9O | USL00X | 2024-06-08T12:09:52.471Z | 2024-06-14T12:08:29.141Z |
4429497 | 4429497 | 20240606054501_BfHJy | USL00X | 2024-06-08T12:09:18.592Z | 2024-06-14T12:08:26.388Z |
4429418 | 4429418 | 20240606034158_zx3hN | USL00X | 2024-06-08T12:09:08.753Z | 2024-06-14T12:08:25.377Z |
4423871 | 4423871 | 20240605094650_HpNiv | USL00X | 2024-06-07T12:11:49.593Z | 2024-06-13T12:08:37.134Z |
4423513 | 4423513 | 20240605083931_k7bC2 | USL00X | 2024-06-07T12:11:28.592Z | 2024-06-13T12:08:36.624Z |
4423415 | 4423415 | 20240605082416_U9Lw5 | USL00X | 2024-06-07T12:11:21.071Z | 2024-06-13T12:08:36.444Z |
4422993 | 4422993 | 20240605063553_vkKId | USL00X | 2024-06-07T12:10:48.404Z | 2024-06-13T12:08:35.482Z |
4195677 | 4195677 | 20240415093610_LMkrM | USL00X | 2024-04-17T12:06:31.120Z | 2024-04-23T12:25:03.093Z |
4195415 | 4195415 | 20240415075905_2YM3d | USL00X | 2024-04-17T12:05:53.399Z | 2024-04-23T12:24:59.494Z |
4189097 | 4189097 | 20240414115856_sOuuQ | USL00X | 2024-04-15T12:13:35.633Z | 2024-04-22T12:22:50.857Z |
4188591 | 4188591 | 20240414101329_PLpHi | USL00X | 2024-04-15T12:12:47.008Z | 2024-04-22T12:22:45.804Z |
4186515 | 4186515 | 20240414063739_sFUoU | USL00X | 2024-04-15T12:06:57.423Z | 2024-04-22T12:22:32.185Z |
4181250 | 4181250 | 20240413112848_f5X00 | USL00X | 2024-04-14T12:07:09.555Z | 2024-04-21T12:21:57.095Z |
4181101 | 4181101 | 20240413105206_BQ3Tm | USL00X | 2024-04-14T12:06:54.029Z | 2024-04-21T12:21:56.294Z |
4180831 | 4180831 | 20240413090538_SQruq | USL00X | 2024-04-14T12:06:09.643Z | 2024-04-21T12:21:55.022Z |
4180565 | 4180565 | 20240413065338_Mnunr | USL00X | 2024-04-14T12:05:25.802Z | 2024-04-21T12:21:49.953Z |
4177523 | 4177523 | 20240411102336_i9LTk | USL00X | 2024-04-13T12:11:52.425Z | 2024-04-19T12:13:24.702Z |
4177301 | 4177301 | 20240411090516_ukirb | USL00X | 2024-04-13T12:11:33.658Z | 2024-04-19T12:13:23.152Z |
4175737 | 4175737 | 20240412032228_fbZQG | USL00X | 2024-04-13T12:06:42.134Z | 2024-04-20T12:25:31.867Z |
4172419 | 4172419 | 20240410065001_Tl1or | USL00X | 2024-04-12T12:09:27.657Z | 2024-04-18T12:21:25.496Z |
4172283 | 4172283 | 20240410053628_1RPkH | USL00X | 2024-04-12T12:09:06.102Z | 2024-04-18T12:21:24.227Z |
4160438 | 4160438 | 20240408061205_tG30F | USL00X | 2024-04-09T12:13:10.666Z | 2024-04-16T12:20:21.742Z |
4160427 | 4160427 | 20240408055949_hHfhL | USL00X | 2024-04-09T12:13:09.001Z | 2024-04-16T12:20:21.671Z |
4160317 | 4160317 | 20240408044419_2i4WB | USL00X | 2024-04-09T12:12:54.568Z | 2024-04-16T12:20:20.830Z |
4157893 | 4157893 | 20240407050325_o8U5L | USL00X | 2024-04-09T12:08:16.653Z | 2024-04-15T12:19:20.108Z |
4144661 | 4144661 | 20240403111339_m2y3z | USL00X | 2024-04-05T12:09:57.547Z | 2024-04-11T12:23:56.010Z |
4144230 | 4144230 | 20240403090146_CDjJM | USL00X | 2024-04-05T12:08:59.004Z | 2024-04-11T12:23:51.086Z |
4143754 | 4143754 | 20240404102710_Rhtpx | USL00X | 2024-04-05T12:05:43.693Z | 2024-04-12T12:19:52.010Z |
4143621 | 4143621 | 20240404093342_x1llg | USL00X | 2024-04-05T12:05:27.981Z | 2024-04-12T12:19:51.246Z |
4140738 | 4140738 | 20240402114101_lpZF0 | USL00X | 2024-04-04T12:11:26.939Z | 2024-04-10T12:18:20.037Z |
4139620 | 4139620 | 20240403070351_1o7GD | USL00X | 2024-04-04T12:07:41.064Z | 2024-04-11T12:23:48.312Z |
4095329 | 4095329 | 20240319104336_aTrrM | USL00X | 2024-03-21T12:11:33.214Z | 2024-03-27T12:19:42.281Z |
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);