participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
34 rows where station_code = "US0043" 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 |
---|---|---|---|---|---|
5117766 | 5117766 | 20240915065514_YzsiZ | US0043 | 2024-09-18T12:07:57.090Z | 2024-09-20T12:17:13.080Z |
5108366 | 5108366 | 20240913050212_uzhr3 | US0043 | 2024-09-17T12:13:38.772Z | 2024-09-20T12:20:50.327Z |
5107573 | 5107573 | 20240913040158_tKhXc | US0043 | 2024-09-17T12:13:17.432Z | 2024-09-20T12:20:45.268Z |
5103433 | 5103433 | 20240913013041_h3Ehh | US0043 | 2024-09-17T12:10:57.432Z | 2024-09-20T12:20:31.091Z |
5095585 | 5095585 | 20240912081232_ETIHA | US0043 | 2024-09-16T12:15:49.689Z | 2024-09-20T12:22:01.759Z |
5095304 | 5095304 | 20240912070404_O97RW | US0043 | 2024-09-16T12:15:31.429Z | 2024-09-20T12:21:59.043Z |
5095110 | 5095110 | 20240912055556_9fl75 | US0043 | 2024-09-16T12:15:14.620Z | 2024-09-20T12:21:57.443Z |
5095002 | 5095002 | 20240912050630_wmtoC | US0043 | 2024-09-16T12:15:08.527Z | 2024-09-20T12:21:56.706Z |
5091590 | 5091590 | 20240912021423_bYOBq | US0043 | 2024-09-16T12:13:11.888Z | 2024-09-20T12:21:48.872Z |
5067066 | 5067066 | 20240910085151_NJog2 | US0043 | 2024-09-14T12:18:28.997Z | 2024-09-18T12:15:23.317Z |
5048848 | 5048848 | 20240909092043_l3Ef6 | US0043 | 2024-09-13T12:11:19.065Z | 2024-09-17T12:19:08.528Z |
5048239 | 5048239 | 20240909072600_vs0HK | US0043 | 2024-09-13T12:10:22.135Z | 2024-09-17T12:19:06.164Z |
5047473 | 5047473 | 20240909042334_Ut654 | US0043 | 2024-09-13T12:09:07.206Z | 2024-09-17T12:19:02.779Z |
5047225 | 5047225 | 20240909030813_NbKrZ | US0043 | 2024-09-13T12:08:41.044Z | 2024-09-17T12:19:01.728Z |
5040393 | 5040393 | 20240906035701_B523S | US0043 | 2024-09-12T12:16:08.315Z | 2024-09-14T12:23:08.912Z |
5039635 | 5039635 | 20240906014028_crigL | US0043 | 2024-09-12T12:15:40.584Z | 2024-09-14T12:23:03.849Z |
5032307 | 5032307 | 20240907004342_nTz3I | US0043 | 2024-09-12T12:07:05.826Z | 2024-09-15T12:21:25.984Z |
5028166 | 5028166 | 20240905090949_qko2f | US0043 | 2024-09-11T12:14:55.880Z | 2024-09-13T12:20:05.620Z |
5027278 | 5027278 | 20240905071739_WNeTX | US0043 | 2024-09-11T12:14:03.656Z | 2024-09-13T12:20:02.227Z |
5025299 | 5025299 | 20240906014028_fNhj5 | US0043 | 2024-09-11T12:06:10.553Z | 2024-09-14T12:23:03.846Z |
5022602 | 5022602 | 20240905090949_Fsw3R | US0043 | 2024-09-10T12:16:24.618Z | 2024-09-10T12:16:55.580Z |
5021731 | 5021731 | 20240905071739_ill0F | US0043 | 2024-09-10T12:15:49.757Z | 2024-09-10T12:16:55.429Z |
5003329 | 5003329 | 20240903083745_XTlGp | US0043 | 2024-09-09T12:01:36.519Z | 2024-09-12T12:18:55.874Z |
4957499 | 4957499 | 20240811085026_XP6b7 | US0043 | 2024-09-03T12:21:22.567Z | 2024-09-06T12:31:21.596Z |
4955847 | 4955847 | 20240811061155_FDdNR | US0043 | 2024-09-03T12:19:29.443Z | 2024-09-06T12:30:01.231Z |
4904326 | 4904326 | 20240808051155_kuWi7 | US0043 | 2024-08-28T12:20:18.168Z | 2024-08-28T12:20:18.168Z |
4904249 | 4904249 | 20240808044208_bHlTl | US0043 | 2024-08-28T12:20:12.727Z | 2024-08-28T12:20:12.727Z |
4797203 | 4797203 | 20240802030525_9K35a | US0043 | 2024-08-11T12:16:21.704Z | 2024-08-11T12:16:21.704Z |
4787448 | 4787448 | 20240802064750_gsJOJ | US0043 | 2024-08-11T12:02:05.050Z | 2024-08-13T12:15:32.149Z |
4787316 | 4787316 | 20240802060334_4138W | US0043 | 2024-08-11T12:01:37.511Z | 2024-08-13T12:15:25.977Z |
4786984 | 4786984 | 20240802035247_ed4RE | US0043 | 2024-08-11T12:00:33.712Z | 2024-08-13T12:15:13.696Z |
4772655 | 4772655 | 20240801075536_wOqm4 | US0043 | 2024-08-07T12:04:08.351Z | 2024-08-11T12:11:35.158Z |
4762549 | 4762549 | 20240731021618_3Y7s0 | US0043 | 2024-08-06T12:02:48.233Z | 2024-08-10T12:17:49.794Z |
4761657 | 4761657 | 20240731012534_sbcS2 | US0043 | 2024-08-06T12:00:47.290Z | 2024-08-10T12:17:23.235Z |
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);