participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,802 rows where station_code = "US002X" 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 |
---|---|---|---|---|---|
5524816 | 5524816 | 20241111055617_Wb2LU | US002X | 2024-11-12T14:18:02.546Z | 2024-11-12T14:18:08.792Z |
5524210 | 5524210 | 20241111033314_pcic8 | US002X | 2024-11-12T14:16:46.149Z | 2024-11-12T14:18:08.515Z |
5523665 | 5523665 | 20241111020242_6CWQd | US002X | 2024-11-12T14:16:06.560Z | 2024-11-12T14:18:08.294Z |
5523547 | 5523547 | 20241111014307_iL5GU | US002X | 2024-11-12T14:15:56.662Z | 2024-11-12T14:18:08.242Z |
5519547 | 5519547 | 20241111115541_LZVvF | US002X | 2024-11-12T14:04:28.969Z | 2024-11-12T14:04:28.969Z |
5519525 | 5519525 | 20241111114614_44ue9 | US002X | 2024-11-12T14:04:22.750Z | 2024-11-12T14:04:22.750Z |
5519457 | 5519457 | 20241111112810_BXehV | US002X | 2024-11-12T14:04:05.576Z | 2024-11-12T14:04:05.576Z |
5519455 | 5519455 | 20241111112746_qDBYv | US002X | 2024-11-12T14:04:05.288Z | 2024-11-12T14:04:05.288Z |
5519363 | 5519363 | 20241111111001_fl2pU | US002X | 2024-11-12T14:03:51.606Z | 2024-11-12T14:03:51.606Z |
5519346 | 5519346 | 20241111110350_Pd0I7 | US002X | 2024-11-12T14:03:48.457Z | 2024-11-12T14:03:48.457Z |
5519340 | 5519340 | 20241111110317_7SLI5 | US002X | 2024-11-12T14:03:47.867Z | 2024-11-12T14:03:47.867Z |
5519271 | 5519271 | 20241111105141_LJRJL | US002X | 2024-11-12T14:03:31.982Z | 2024-11-12T14:03:31.982Z |
5519213 | 5519213 | 20241111104121_g3aza | US002X | 2024-11-12T14:03:21.703Z | 2024-11-12T14:03:21.703Z |
5519143 | 5519143 | 20241111102316_Pyxux | US002X | 2024-11-12T14:03:11.261Z | 2024-11-12T14:03:11.261Z |
5519141 | 5519141 | 20241111102256_VZYOt | US002X | 2024-11-12T14:03:10.688Z | 2024-11-12T14:03:10.688Z |
5519113 | 5519113 | 20241111101827_vyhs8 | US002X | 2024-11-12T14:03:06.841Z | 2024-11-12T14:03:06.841Z |
5518999 | 5518999 | 20241111095212_wH1ZT | US002X | 2024-11-12T14:02:36.075Z | 2024-11-12T14:02:36.075Z |
5518997 | 5518997 | 20241111095159_ZUeu5 | US002X | 2024-11-12T14:02:35.715Z | 2024-11-12T14:02:35.715Z |
5518976 | 5518976 | 20241111094613_STFwn | US002X | 2024-11-12T14:02:31.638Z | 2024-11-12T14:02:31.638Z |
5518934 | 5518934 | 20241111093730_5Ia83 | US002X | 2024-11-12T14:02:23.968Z | 2024-11-12T14:02:23.968Z |
5518895 | 5518895 | 20241111092852_bKsOC | US002X | 2024-11-12T14:02:17.823Z | 2024-11-12T14:02:17.823Z |
5518844 | 5518844 | 20241111092034_8XalC | US002X | 2024-11-12T14:02:12.373Z | 2024-11-12T14:02:12.373Z |
5518801 | 5518801 | 20241111091346_fm30q | US002X | 2024-11-12T14:02:07.039Z | 2024-11-12T14:02:07.039Z |
5518795 | 5518795 | 20241111091128_4880d | US002X | 2024-11-12T14:02:05.695Z | 2024-11-12T14:02:05.695Z |
5518765 | 5518765 | 20241111090324_D535W | US002X | 2024-11-12T14:01:57.224Z | 2024-11-12T14:01:57.224Z |
5518755 | 5518755 | 20241111090237_yTYG0 | US002X | 2024-11-12T14:01:51.547Z | 2024-11-12T14:01:51.547Z |
5518718 | 5518718 | 20241111085801_2SMLG | US002X | 2024-11-12T14:01:46.500Z | 2024-11-12T14:01:46.500Z |
5518678 | 5518678 | 20241111084854_tfApE | US002X | 2024-11-12T14:01:39.055Z | 2024-11-12T14:01:39.055Z |
5518600 | 5518600 | 20241111083144_ruBUu | US002X | 2024-11-12T14:01:28.200Z | 2024-11-12T14:01:28.200Z |
5518515 | 5518515 | 20241111080820_brgU4 | US002X | 2024-11-12T14:01:10.925Z | 2024-11-12T14:01:10.925Z |
5518365 | 5518365 | 20241111071552_NmaAH | US002X | 2024-11-12T14:00:45.345Z | 2024-11-12T14:00:45.345Z |
5518358 | 5518358 | 20241111071452_IU3Dv | US002X | 2024-11-12T14:00:42.646Z | 2024-11-12T14:00:42.646Z |
5518318 | 5518318 | 20241111070300_WUE25 | US002X | 2024-11-12T14:00:33.837Z | 2024-11-12T14:00:33.837Z |
5518316 | 5518316 | 20241111070247_gkzIv | US002X | 2024-11-12T14:00:33.273Z | 2024-11-12T14:00:33.273Z |
5518308 | 5518308 | 20241111070125_Qqknm | US002X | 2024-11-12T14:00:31.147Z | 2024-11-12T14:00:31.147Z |
5518293 | 5518293 | 20241111065846_XrWD0 | US002X | 2024-11-12T14:00:29.037Z | 2024-11-12T14:00:29.037Z |
5518285 | 5518285 | 20241111065339_hY8aq | US002X | 2024-11-12T14:00:27.717Z | 2024-11-12T14:00:27.717Z |
5518242 | 5518242 | 20241111063034_xGSyS | US002X | 2024-11-12T14:00:20.648Z | 2024-11-12T14:00:20.648Z |
5518117 | 5518117 | 20241110060328_XuVPe | US002X | 2024-11-11T14:15:13.970Z | 2024-11-12T14:22:02.406Z |
5518004 | 5518004 | 20241110053612_Mme8g | US002X | 2024-11-11T14:15:07.241Z | 2024-11-12T14:22:00.230Z |
5517857 | 5517857 | 20241110050326_1XY06 | US002X | 2024-11-11T14:14:56.858Z | 2024-11-12T14:21:57.173Z |
5517739 | 5517739 | 20241110044003_JeXCP | US002X | 2024-11-11T14:14:48.755Z | 2024-11-12T14:21:53.792Z |
5516995 | 5516995 | 20241110023110_bTisi | US002X | 2024-11-11T14:13:41.515Z | 2024-11-12T14:21:26.039Z |
5516641 | 5516641 | 20241110013245_FVh77 | US002X | 2024-11-11T14:13:12.725Z | 2024-11-12T14:21:14.755Z |
5516427 | 5516427 | 20241110005830_8TNpm | US002X | 2024-11-11T14:13:00.750Z | 2024-11-12T14:21:04.962Z |
5513666 | 5513666 | 20241110120143_I7BRa | US002X | 2024-11-11T14:05:08.333Z | 2024-11-12T14:18:06.595Z |
5513633 | 5513633 | 20241110115838_ug79A | US002X | 2024-11-11T14:05:03.124Z | 2024-11-12T14:18:06.584Z |
5513491 | 5513491 | 20241110113841_dvlM8 | US002X | 2024-11-11T14:04:43.285Z | 2024-11-12T14:18:06.520Z |
5513374 | 5513374 | 20241110112341_4SwRQ | US002X | 2024-11-11T14:04:33.377Z | 2024-11-12T14:18:06.468Z |
5513354 | 5513354 | 20241110112000_o20O7 | US002X | 2024-11-11T14:04:31.111Z | 2024-11-12T14:18:06.458Z |
5513335 | 5513335 | 20241110111657_3R3M4 | US002X | 2024-11-11T14:04:29.407Z | 2024-11-12T14:18:06.451Z |
5513300 | 5513300 | 20241110111332_LH22L | US002X | 2024-11-11T14:04:26.287Z | 2024-11-12T14:18:06.437Z |
5513286 | 5513286 | 20241110111102_bcNHq | US002X | 2024-11-11T14:04:23.819Z | 2024-11-12T14:18:06.430Z |
5513280 | 5513280 | 20241110110913_SMpx2 | US002X | 2024-11-11T14:04:20.752Z | 2024-11-12T14:18:06.425Z |
5513193 | 5513193 | 20241110105618_Fveyx | US002X | 2024-11-11T14:04:07.243Z | 2024-11-12T14:18:06.390Z |
5513093 | 5513093 | 20241110103707_s8OxS | US002X | 2024-11-11T14:03:52.707Z | 2024-11-12T14:18:06.345Z |
5513046 | 5513046 | 20241110102822_n9RCu | US002X | 2024-11-11T14:03:48.038Z | 2024-11-12T14:18:06.323Z |
5513005 | 5513005 | 20241110102057_Hcw4M | US002X | 2024-11-11T14:03:43.872Z | 2024-11-12T14:18:06.301Z |
5512951 | 5512951 | 20241110101523_iTA8d | US002X | 2024-11-11T14:03:39.535Z | 2024-11-12T14:18:06.284Z |
5512786 | 5512786 | 20241110094755_4irKu | US002X | 2024-11-11T14:03:08.733Z | 2024-11-12T14:18:06.223Z |
5512712 | 5512712 | 20241110093450_yf6wW | US002X | 2024-11-11T14:03:00.324Z | 2024-11-12T14:18:06.191Z |
5512547 | 5512547 | 20241110090633_AYL3c | US002X | 2024-11-11T14:02:38.327Z | 2024-11-12T14:18:06.118Z |
5512531 | 5512531 | 20241110090351_tQZZT | US002X | 2024-11-11T14:02:32.402Z | 2024-11-12T14:18:06.111Z |
5512403 | 5512403 | 20241110084343_Ori1X | US002X | 2024-11-11T14:02:15.165Z | 2024-11-12T14:18:06.062Z |
5512388 | 5512388 | 20241110084148_FUgHY | US002X | 2024-11-11T14:02:13.444Z | 2024-11-12T14:18:06.057Z |
5512357 | 5512357 | 20241110083721_cxrSZ | US002X | 2024-11-11T14:02:10.078Z | 2024-11-12T14:18:06.043Z |
5512330 | 5512330 | 20241110083304_Xro98 | US002X | 2024-11-11T14:02:07.205Z | 2024-11-12T14:18:06.034Z |
5512227 | 5512227 | 20241110081751_FzLaM | US002X | 2024-11-11T14:01:49.629Z | 2024-11-12T14:18:05.988Z |
5512223 | 5512223 | 20241110081733_jGu8s | US002X | 2024-11-11T14:01:47.306Z | 2024-11-12T14:18:05.985Z |
5511988 | 5511988 | 20241110073921_7HIIe | US002X | 2024-11-11T14:01:20.313Z | 2024-11-12T14:18:05.890Z |
5511688 | 5511688 | 20241110063814_BT5SA | US002X | 2024-11-11T14:00:32.780Z | 2024-11-12T14:18:05.755Z |
5497946 | 5497946 | 20241107061705_Si32B | US002X | 2024-11-08T14:14:31.662Z | 2024-11-12T14:26:15.859Z |
5497925 | 5497925 | 20241107060800_40Qc8 | US002X | 2024-11-08T14:14:30.854Z | 2024-11-12T14:26:15.596Z |
5497885 | 5497885 | 20241107054743_ZrXH4 | US002X | 2024-11-08T14:14:28.921Z | 2024-11-12T14:26:15.263Z |
5497857 | 5497857 | 20241107053656_S3hI7 | US002X | 2024-11-08T14:14:27.926Z | 2024-11-12T14:26:15.027Z |
5497853 | 5497853 | 20241107053454_NVdWA | US002X | 2024-11-08T14:14:27.757Z | 2024-11-12T14:26:15.024Z |
5497846 | 5497846 | 20241107053424_zK2zv | US002X | 2024-11-08T14:14:26.739Z | 2024-11-12T14:26:15.021Z |
5497762 | 5497762 | 20241107050117_cnTAQ | US002X | 2024-11-08T14:14:19.277Z | 2024-11-12T14:26:14.439Z |
5497751 | 5497751 | 20241107045920_t1lA1 | US002X | 2024-11-08T14:14:18.223Z | 2024-11-12T14:26:14.388Z |
5497591 | 5497591 | 20241107040712_nzXx6 | US002X | 2024-11-08T14:14:00.927Z | 2024-11-12T14:26:12.910Z |
5496761 | 5496761 | 20241107013136_w63cA | US002X | 2024-11-08T14:12:50.143Z | 2024-11-12T14:26:06.477Z |
5496587 | 5496587 | 20241107005814_nPEax | US002X | 2024-11-08T14:12:29.088Z | 2024-11-12T14:26:05.336Z |
5496525 | 5496525 | 20241107004540_cRKyc | US002X | 2024-11-08T14:12:19.945Z | 2024-11-12T14:26:04.990Z |
5493002 | 5493002 | 20241107103402_jNLSS | US002X | 2024-11-08T14:02:41.559Z | 2024-11-12T14:24:04.901Z |
5492664 | 5492664 | 20241107092846_2NkgE | US002X | 2024-11-08T14:01:50.818Z | 2024-11-12T14:23:59.731Z |
5492615 | 5492615 | 20241107091754_M9YAa | US002X | 2024-11-08T14:01:35.541Z | 2024-11-12T14:23:58.649Z |
5492602 | 5492602 | 20241107091413_GpJVt | US002X | 2024-11-08T14:01:32.075Z | 2024-11-12T14:23:58.455Z |
5492463 | 5492463 | 20241107083824_jQ3eA | US002X | 2024-11-08T14:01:14.177Z | 2024-11-12T14:23:57.065Z |
5492356 | 5492356 | 20241107081357_rHzbk | US002X | 2024-11-08T14:00:52.010Z | 2024-11-12T14:23:55.319Z |
5492335 | 5492335 | 20241107081012_JHGzC | US002X | 2024-11-08T14:00:48.582Z | 2024-11-12T14:23:54.882Z |
5492282 | 5492282 | 20241107075504_jMqhH | US002X | 2024-11-08T14:00:41.632Z | 2024-11-12T14:23:54.327Z |
5492281 | 5492281 | 20241107075440_VsNnj | US002X | 2024-11-08T14:00:41.365Z | 2024-11-12T14:23:54.325Z |
5492234 | 5492234 | 20241107073955_JNxS2 | US002X | 2024-11-08T14:00:35.493Z | 2024-11-12T14:23:54.066Z |
5492232 | 5492232 | 20241107073921_T3lQK | US002X | 2024-11-08T14:00:35.196Z | 2024-11-12T14:23:54.064Z |
5492105 | 5492105 | 20241107064034_C15Ve | US002X | 2024-11-08T14:00:11.813Z | 2024-11-12T14:23:52.407Z |
5492090 | 5492090 | 20241107063151_9u92u | US002X | 2024-11-08T14:00:09.027Z | 2024-11-12T14:23:52.169Z |
5491904 | 5491904 | 20241106061336_AbX6E | US002X | 2024-11-07T14:17:18.991Z | 2024-11-12T14:26:56.627Z |
5491857 | 5491857 | 20241106053601_rIsZ3 | US002X | 2024-11-07T14:17:13.119Z | 2024-11-12T14:26:56.533Z |
5491848 | 5491848 | 20241106053307_O5Dbl | US002X | 2024-11-07T14:17:10.306Z | 2024-11-12T14:26:56.503Z |
5491747 | 5491747 | 20241106045546_W8yJD | US002X | 2024-11-07T14:16:54.010Z | 2024-11-12T14:26:55.913Z |
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);