participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
26,618 rows where station_code = "USL003" 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 |
---|---|---|---|---|---|
5130161 | 5130161 | 20240917095246_iLU8R | USL003 | 2024-09-19T12:12:42.151Z | 2024-09-19T12:12:42.151Z |
5130078 | 5130078 | 20240917084811_xs5RF | USL003 | 2024-09-19T12:12:32.771Z | 2024-09-19T12:12:32.771Z |
5129936 | 5129936 | 20240917063955_hC6ub | USL003 | 2024-09-19T12:12:18.246Z | 2024-09-19T12:12:18.246Z |
5129900 | 5129900 | 20240917054902_WDlGb | USL003 | 2024-09-19T12:12:14.649Z | 2024-09-19T12:12:14.649Z |
5129018 | 5129018 | 20240917030825_GeMsC | USL003 | 2024-09-19T12:11:11.607Z | 2024-09-19T12:11:11.607Z |
5126470 | 5126470 | 20240918120604_9qsUP | USL003 | 2024-09-19T12:06:01.767Z | 2024-09-19T12:06:42.206Z |
5096840 | 5096840 | 20240912115532_DGmyN | USL003 | 2024-09-16T12:16:35.613Z | 2024-09-19T12:21:24.010Z |
5096791 | 5096791 | 20240912114319_bIk3I | USL003 | 2024-09-16T12:16:34.788Z | 2024-09-19T12:21:23.733Z |
5096782 | 5096782 | 20240912114207_m2WkG | USL003 | 2024-09-16T12:16:34.645Z | 2024-09-19T12:21:23.705Z |
5096733 | 5096733 | 20240912113514_gDRke | USL003 | 2024-09-16T12:16:33.150Z | 2024-09-19T12:21:23.520Z |
5096717 | 5096717 | 20240912113408_BPE7q | USL003 | 2024-09-16T12:16:32.505Z | 2024-09-19T12:21:23.504Z |
5096668 | 5096668 | 20240912112809_TbXyZ | USL003 | 2024-09-16T12:16:31.190Z | 2024-09-19T12:21:23.394Z |
5096578 | 5096578 | 20240912111643_D1rXZ | USL003 | 2024-09-16T12:16:27.878Z | 2024-09-19T12:21:22.905Z |
5096417 | 5096417 | 20240912104914_eKPMo | USL003 | 2024-09-16T12:16:23.218Z | 2024-09-19T12:21:22.288Z |
5096399 | 5096399 | 20240912104545_4O4Q1 | USL003 | 2024-09-16T12:16:22.640Z | 2024-09-19T12:21:22.249Z |
5096349 | 5096349 | 20240912103701_AsUHq | USL003 | 2024-09-16T12:16:21.190Z | 2024-09-19T12:21:22.168Z |
5096290 | 5096290 | 20240912102802_sP76c | USL003 | 2024-09-16T12:16:18.850Z | 2024-09-19T12:21:22.020Z |
5096266 | 5096266 | 20240912102546_phlzu | USL003 | 2024-09-16T12:16:17.468Z | 2024-09-19T12:21:21.986Z |
5096224 | 5096224 | 20240912102110_CLN7B | USL003 | 2024-09-16T12:16:16.177Z | 2024-09-19T12:21:21.926Z |
5096145 | 5096145 | 20240912100819_1WO5I | USL003 | 2024-09-16T12:16:11.798Z | 2024-09-19T12:21:21.751Z |
5096128 | 5096128 | 20240912100532_fdOAL | USL003 | 2024-09-16T12:16:11.472Z | 2024-09-19T12:21:21.641Z |
5096028 | 5096028 | 20240912094442_964i8 | USL003 | 2024-09-16T12:16:05.882Z | 2024-09-19T12:21:21.022Z |
5095997 | 5095997 | 20240912093903_EmRaC | USL003 | 2024-09-16T12:16:04.806Z | 2024-09-19T12:21:20.849Z |
5095933 | 5095933 | 20240912092911_KvvU6 | USL003 | 2024-09-16T12:16:02.331Z | 2024-09-19T12:21:20.671Z |
5095862 | 5095862 | 20240912091954_0a6T5 | USL003 | 2024-09-16T12:16:00.920Z | 2024-09-19T12:21:20.564Z |
5095798 | 5095798 | 20240912090734_mteLj | USL003 | 2024-09-16T12:15:58.594Z | 2024-09-19T12:21:20.320Z |
5095775 | 5095775 | 20240912090037_1f98r | USL003 | 2024-09-16T12:15:58.042Z | 2024-09-19T12:21:20.155Z |
5095719 | 5095719 | 20240912084946_1VHZ1 | USL003 | 2024-09-16T12:15:54.756Z | 2024-09-19T12:21:19.932Z |
5095628 | 5095628 | 20240912083017_WstIn | USL003 | 2024-09-16T12:15:51.571Z | 2024-09-19T12:21:19.479Z |
5095612 | 5095612 | 20240912082907_AOKu2 | USL003 | 2024-09-16T12:15:51.277Z | 2024-09-19T12:21:19.376Z |
5095528 | 5095528 | 20240912080002_umHV3 | USL003 | 2024-09-16T12:15:46.028Z | 2024-09-19T12:21:18.833Z |
5095450 | 5095450 | 20240912073616_DL4FT | USL003 | 2024-09-16T12:15:40.682Z | 2024-09-19T12:21:18.561Z |
5095443 | 5095443 | 20240912073242_oLuWB | USL003 | 2024-09-16T12:15:40.271Z | 2024-09-19T12:21:18.538Z |
5095389 | 5095389 | 20240912072745_yl8X1 | USL003 | 2024-09-16T12:15:38.334Z | 2024-09-19T12:21:18.397Z |
5095322 | 5095322 | 20240912071406_jqFIL | USL003 | 2024-09-16T12:15:32.453Z | 2024-09-19T12:21:18.136Z |
5095253 | 5095253 | 20240912065331_m6eEJ | USL003 | 2024-09-16T12:15:28.244Z | 2024-09-19T12:21:17.756Z |
5095245 | 5095245 | 20240912065136_uHyDS | USL003 | 2024-09-16T12:15:27.725Z | 2024-09-19T12:21:17.746Z |
5095197 | 5095197 | 20240912063246_ow0XI | USL003 | 2024-09-16T12:15:21.812Z | 2024-09-19T12:21:17.474Z |
5095120 | 5095120 | 20240912060345_eXHjy | USL003 | 2024-09-16T12:15:15.560Z | 2024-09-19T12:21:17.302Z |
5095018 | 5095018 | 20240912051436_ZCcIJ | USL003 | 2024-09-16T12:15:09.745Z | 2024-09-19T12:21:16.980Z |
5094990 | 5094990 | 20240912050610_whFgs | USL003 | 2024-09-16T12:15:08.058Z | 2024-09-19T12:21:16.890Z |
5093319 | 5093319 | 20240912031819_gPkEP | USL003 | 2024-09-16T12:14:15.354Z | 2024-09-19T12:21:15.240Z |
5093264 | 5093264 | 20240912031526_Z2og4 | USL003 | 2024-09-16T12:14:13.763Z | 2024-09-19T12:21:15.070Z |
5093201 | 5093201 | 20240912031502_dHyXE | USL003 | 2024-09-16T12:14:13.311Z | 2024-09-19T12:21:15.019Z |
5092149 | 5092149 | 20240912023813_VWKxf | USL003 | 2024-09-16T12:13:42.008Z | 2024-09-19T12:21:13.674Z |
5082752 | 5082752 | 20240911105541_agmE2 | USL003 | 2024-09-15T12:18:24.845Z | 2024-09-19T12:21:48.526Z |
5082670 | 5082670 | 20240911104330_w2wCz | USL003 | 2024-09-15T12:18:22.254Z | 2024-09-19T12:21:48.337Z |
5082630 | 5082630 | 20240911103748_zQHSa | USL003 | 2024-09-15T12:18:21.594Z | 2024-09-19T12:21:48.270Z |
5082602 | 5082602 | 20240911103510_fQWSe | USL003 | 2024-09-15T12:18:20.867Z | 2024-09-19T12:21:48.180Z |
5082487 | 5082487 | 20240911101550_7bEfu | USL003 | 2024-09-15T12:18:16.424Z | 2024-09-19T12:21:47.998Z |
5082315 | 5082315 | 20240911095209_hn5UD | USL003 | 2024-09-15T12:18:10.851Z | 2024-09-19T12:21:47.757Z |
5082307 | 5082307 | 20240911095207_3KLn8 | USL003 | 2024-09-15T12:18:10.742Z | 2024-09-19T12:21:47.744Z |
5082289 | 5082289 | 20240911094935_A0EZq | USL003 | 2024-09-15T12:18:10.085Z | 2024-09-19T12:21:47.663Z |
5082219 | 5082219 | 20240911093757_KWyzS | USL003 | 2024-09-15T12:18:06.989Z | 2024-09-19T12:21:47.535Z |
5082214 | 5082214 | 20240911093728_qpvI3 | USL003 | 2024-09-15T12:18:06.912Z | 2024-09-19T12:21:47.533Z |
5082146 | 5082146 | 20240911092828_kwGYG | USL003 | 2024-09-15T12:18:04.878Z | 2024-09-19T12:21:47.244Z |
5081974 | 5081974 | 20240911090837_Rh9wj | USL003 | 2024-09-15T12:17:56.875Z | 2024-09-19T12:21:46.827Z |
5081951 | 5081951 | 20240911090557_F09GI | USL003 | 2024-09-15T12:17:56.047Z | 2024-09-19T12:21:46.818Z |
5081847 | 5081847 | 20240911085144_XT9eu | USL003 | 2024-09-15T12:17:51.050Z | 2024-09-19T12:21:46.566Z |
5081831 | 5081831 | 20240911084935_Nl2yt | USL003 | 2024-09-15T12:17:50.328Z | 2024-09-19T12:21:46.551Z |
5081784 | 5081784 | 20240911084212_CO3SY | USL003 | 2024-09-15T12:17:47.228Z | 2024-09-19T12:21:46.418Z |
5081522 | 5081522 | 20240911075550_u52cA | USL003 | 2024-09-15T12:17:36.691Z | 2024-09-19T12:21:45.633Z |
5081481 | 5081481 | 20240911074903_AHnWP | USL003 | 2024-09-15T12:17:35.649Z | 2024-09-19T12:21:45.529Z |
5081440 | 5081440 | 20240911074421_hraCQ | USL003 | 2024-09-15T12:17:33.345Z | 2024-09-19T12:21:45.376Z |
5081345 | 5081345 | 20240911072921_qM4rm | USL003 | 2024-09-15T12:17:30.859Z | 2024-09-19T12:21:45.147Z |
5081317 | 5081317 | 20240911072121_dk2oc | USL003 | 2024-09-15T12:17:30.160Z | 2024-09-19T12:21:45.075Z |
5081299 | 5081299 | 20240911071841_aBtiJ | USL003 | 2024-09-15T12:17:29.800Z | 2024-09-19T12:21:45.064Z |
5081035 | 5081035 | 20240911060911_kEdMW | USL003 | 2024-09-15T12:17:21.232Z | 2024-09-19T12:21:44.406Z |
5080906 | 5080906 | 20240911052214_xXTFJ | USL003 | 2024-09-15T12:17:16.973Z | 2024-09-19T12:21:44.038Z |
5080824 | 5080824 | 20240911045729_NFEPu | USL003 | 2024-09-15T12:17:14.694Z | 2024-09-19T12:21:43.839Z |
5080814 | 5080814 | 20240911045512_CS48C | USL003 | 2024-09-15T12:17:14.294Z | 2024-09-19T12:21:43.710Z |
5080776 | 5080776 | 20240911044601_PJ3XZ | USL003 | 2024-09-15T12:17:12.951Z | 2024-09-19T12:21:43.641Z |
5080686 | 5080686 | 20240911042431_kkDml | USL003 | 2024-09-15T12:17:10.283Z | 2024-09-19T12:21:43.400Z |
5080382 | 5080382 | 20240911035157_Lh2PV | USL003 | 2024-09-15T12:17:00.373Z | 2024-09-19T12:21:43.204Z |
5080183 | 5080183 | 20240911034218_IX2Kp | USL003 | 2024-09-15T12:16:53.738Z | 2024-09-19T12:21:43.126Z |
5079428 | 5079428 | 20240911025547_O1dWL | USL003 | 2024-09-15T12:16:20.732Z | 2024-09-19T12:21:42.272Z |
5079315 | 5079315 | 20240911024740_FQwNQ | USL003 | 2024-09-15T12:16:15.023Z | 2024-09-19T12:21:41.413Z |
5070437 | 5070437 | 20240909111049_mVxoM | USL003 | 2024-09-14T12:21:19.509Z | 2024-09-17T12:19:10.825Z |
5068637 | 5068637 | 20240910115657_tBdJk | USL003 | 2024-09-14T12:19:19.808Z | 2024-09-18T12:15:26.429Z |
5068552 | 5068552 | 20240910114745_9PfHg | USL003 | 2024-09-14T12:19:17.897Z | 2024-09-18T12:15:26.307Z |
5068523 | 5068523 | 20240910114601_hCwF2 | USL003 | 2024-09-14T12:19:17.127Z | 2024-09-18T12:15:26.260Z |
5068469 | 5068469 | 20240910113728_1oGgu | USL003 | 2024-09-14T12:19:16.201Z | 2024-09-18T12:15:26.191Z |
5068397 | 5068397 | 20240910112634_ZUuPz | USL003 | 2024-09-14T12:19:14.005Z | 2024-09-18T12:15:26.042Z |
5068354 | 5068354 | 20240910112340_lMbI3 | USL003 | 2024-09-14T12:19:13.086Z | 2024-09-18T12:15:25.973Z |
5068297 | 5068297 | 20240910111901_8Ow92 | USL003 | 2024-09-14T12:19:11.879Z | 2024-09-18T12:15:25.887Z |
5068291 | 5068291 | 20240910111849_8dfe3 | USL003 | 2024-09-14T12:19:11.845Z | 2024-09-18T12:15:25.884Z |
5068186 | 5068186 | 20240910110742_212d3 | USL003 | 2024-09-14T12:19:10.455Z | 2024-09-18T12:15:25.730Z |
5067994 | 5067994 | 20240910103948_Af8iz | USL003 | 2024-09-14T12:19:06.570Z | 2024-09-18T12:15:25.345Z |
5067973 | 5067973 | 20240910103810_dZxKO | USL003 | 2024-09-14T12:19:06.023Z | 2024-09-18T12:15:25.301Z |
5067941 | 5067941 | 20240910103518_6tgk9 | USL003 | 2024-09-14T12:19:05.462Z | 2024-09-18T12:15:25.168Z |
5067931 | 5067931 | 20240910103234_pwjir | USL003 | 2024-09-14T12:19:05.308Z | 2024-09-18T12:15:25.129Z |
5067926 | 5067926 | 20240910103226_rLwtb | USL003 | 2024-09-14T12:19:05.237Z | 2024-09-18T12:15:25.117Z |
5067858 | 5067858 | 20240910102119_YpqqK | USL003 | 2024-09-14T12:19:01.247Z | 2024-09-18T12:15:24.992Z |
5067725 | 5067725 | 20240910100526_3TKMB | USL003 | 2024-09-14T12:18:55.395Z | 2024-09-18T12:15:24.797Z |
5067615 | 5067615 | 20240910095319_YINo9 | USL003 | 2024-09-14T12:18:50.804Z | 2024-09-18T12:15:24.559Z |
5067603 | 5067603 | 20240910094948_Phj1e | USL003 | 2024-09-14T12:18:50.573Z | 2024-09-18T12:15:24.541Z |
5067586 | 5067586 | 20240910094653_uo5JC | USL003 | 2024-09-14T12:18:49.951Z | 2024-09-18T12:15:24.476Z |
5067533 | 5067533 | 20240910094238_QqFoi | USL003 | 2024-09-14T12:18:47.515Z | 2024-09-18T12:15:24.316Z |
5067518 | 5067518 | 20240910094128_kS1HD | USL003 | 2024-09-14T12:18:47.009Z | 2024-09-18T12:15:24.302Z |
5067513 | 5067513 | 20240910094057_Vq0Sn | USL003 | 2024-09-14T12:18:46.827Z | 2024-09-18T12:15:24.291Z |
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);