participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,972 rows where station_code = "UK0090" 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 |
---|---|---|---|---|---|
5573191 | 5573191 | 20241121040526_9WRYq | UK0090 | 2024-11-22T14:19:14.993Z | 2024-11-22T14:19:22.466Z |
5573086 | 5573086 | 20241121035002_69YPk | UK0090 | 2024-11-22T14:19:09.072Z | 2024-11-22T14:19:22.446Z |
5572992 | 5572992 | 20241121033537_sKrDj | UK0090 | 2024-11-22T14:19:02.691Z | 2024-11-22T14:19:22.428Z |
5572981 | 5572981 | 20241121033340_oyQsq | UK0090 | 2024-11-22T14:19:02.502Z | 2024-11-22T14:19:22.427Z |
5572974 | 5572974 | 20241121033216_CyJMO | UK0090 | 2024-11-22T14:19:01.682Z | 2024-11-22T14:19:22.425Z |
5572948 | 5572948 | 20241121032822_KRwuG | UK0090 | 2024-11-22T14:19:00.300Z | 2024-11-22T14:19:22.419Z |
5572945 | 5572945 | 20241121032807_KOWm2 | UK0090 | 2024-11-22T14:19:00.163Z | 2024-11-22T14:19:22.418Z |
5572934 | 5572934 | 20241121032635_cO6Rd | UK0090 | 2024-11-22T14:18:59.441Z | 2024-11-22T14:19:22.417Z |
5572845 | 5572845 | 20241121031612_BXH4O | UK0090 | 2024-11-22T14:18:53.161Z | 2024-11-22T14:19:22.401Z |
5572818 | 5572818 | 20241121031300_3mR8C | UK0090 | 2024-11-22T14:18:51.296Z | 2024-11-22T14:19:22.395Z |
5572798 | 5572798 | 20241121031028_Ai9WK | UK0090 | 2024-11-22T14:18:50.579Z | 2024-11-22T14:19:22.393Z |
5572620 | 5572620 | 20241121025019_nmQbI | UK0090 | 2024-11-22T14:18:39.773Z | 2024-11-22T14:19:22.363Z |
5572587 | 5572587 | 20241121024503_D9vow | UK0090 | 2024-11-22T14:18:38.303Z | 2024-11-22T14:19:22.356Z |
5572463 | 5572463 | 20241121022318_zwZJy | UK0090 | 2024-11-22T14:18:27.844Z | 2024-11-22T14:19:22.332Z |
5572404 | 5572404 | 20241121021830_7oxmS | UK0090 | 2024-11-22T14:18:23.787Z | 2024-11-22T14:19:22.324Z |
5572304 | 5572304 | 20241121020726_n1CJu | UK0090 | 2024-11-22T14:18:14.577Z | 2024-11-22T14:19:22.302Z |
5572298 | 5572298 | 20241121020653_AZ2SE | UK0090 | 2024-11-22T14:18:14.431Z | 2024-11-22T14:19:22.301Z |
5572187 | 5572187 | 20241121014450_iLf13 | UK0090 | 2024-11-22T14:18:03.836Z | 2024-11-22T14:19:22.276Z |
5572087 | 5572087 | 20241121013200_fd3l4 | UK0090 | 2024-11-22T14:17:56.846Z | 2024-11-22T14:19:22.256Z |
5571876 | 5571876 | 20241121005944_675bG | UK0090 | 2024-11-22T14:17:44.281Z | 2024-11-22T14:19:22.213Z |
5571723 | 5571723 | 20241121003606_0w2fj | UK0090 | 2024-11-22T14:17:36.129Z | 2024-11-22T14:19:22.181Z |
5571581 | 5571581 | 20241121001042_zFArK | UK0090 | 2024-11-22T14:17:20.185Z | 2024-11-22T14:19:22.153Z |
5571546 | 5571546 | 20241121000541_cVZ6E | UK0090 | 2024-11-22T14:17:15.620Z | 2024-11-22T14:19:22.146Z |
5571331 | 5571331 | 20241120232350_pgLXV | UK0090 | 2024-11-22T14:16:51.302Z | 2024-11-22T14:19:22.102Z |
5571315 | 5571315 | 20241120232228_0KZLx | UK0090 | 2024-11-22T14:16:50.476Z | 2024-11-22T14:19:22.099Z |
5571282 | 5571282 | 20241120231251_OJh04 | UK0090 | 2024-11-22T14:16:47.781Z | 2024-11-22T14:19:22.089Z |
5571254 | 5571254 | 20241120230828_POSt4 | UK0090 | 2024-11-22T14:16:43.906Z | 2024-11-22T14:19:22.079Z |
5571133 | 5571133 | 20241120223141_UwFEC | UK0090 | 2024-11-22T14:16:28.730Z | 2024-11-22T14:19:22.049Z |
5571010 | 5571010 | 20241120215438_tm8Tf | UK0090 | 2024-11-22T14:16:18.614Z | 2024-11-22T14:19:22.022Z |
5570910 | 5570910 | 20241120212650_3OTtQ | UK0090 | 2024-11-22T14:16:11.771Z | 2024-11-22T14:19:22.004Z |
5570828 | 5570828 | 20241120210944_0hZ3p | UK0090 | 2024-11-22T14:16:07.852Z | 2024-11-22T14:19:21.989Z |
5570505 | 5570505 | 20241120195049_8DHTy | UK0090 | 2024-11-22T14:15:37.939Z | 2024-11-22T14:19:21.928Z |
5570488 | 5570488 | 20241120194714_prux6 | UK0090 | 2024-11-22T14:15:36.490Z | 2024-11-22T14:19:21.926Z |
5570418 | 5570418 | 20241120193416_khYO0 | UK0090 | 2024-11-22T14:15:21.069Z | 2024-11-22T14:19:21.914Z |
5570196 | 5570196 | 20241120190142_unrGr | UK0090 | 2024-11-22T14:15:00.377Z | 2024-11-22T14:19:21.879Z |
5569996 | 5569996 | 20241120182124_lE2op | UK0090 | 2024-11-22T14:14:43.773Z | 2024-11-22T14:19:21.844Z |
5569905 | 5569905 | 20241120175540_Z3mmg | UK0090 | 2024-11-22T14:14:33.229Z | 2024-11-22T14:19:21.826Z |
5566089 | 5566089 | 20241121053105_5LWJf | UK0090 | 2024-11-22T14:01:47.018Z | 2024-11-22T14:01:47.018Z |
5566036 | 5566036 | 20241121052004_gAZiF | UK0090 | 2024-11-22T14:01:35.870Z | 2024-11-22T14:01:35.870Z |
5565882 | 5565882 | 20241121050006_fHtuo | UK0090 | 2024-11-22T14:01:19.514Z | 2024-11-22T14:01:19.514Z |
5565715 | 5565715 | 20241121043722_cKcde | UK0090 | 2024-11-22T14:00:45.808Z | 2024-11-22T14:00:45.808Z |
5565602 | 5565602 | 20241121042442_fkZOm | UK0090 | 2024-11-22T14:00:23.343Z | 2024-11-22T14:00:23.343Z |
5565546 | 5565546 | 20241121042103_2vZtR | UK0090 | 2024-11-22T14:00:15.496Z | 2024-11-22T14:00:15.496Z |
5564452 | 5564452 | 20241120025841_RVY30 | UK0090 | 2024-11-21T14:17:38.966Z | 2024-11-22T14:21:32.225Z |
5564400 | 5564400 | 20241120025231_Rvoz9 | UK0090 | 2024-11-21T14:17:32.947Z | 2024-11-22T14:21:31.212Z |
5564393 | 5564393 | 20241120025216_7Xw20 | UK0090 | 2024-11-21T14:17:32.283Z | 2024-11-22T14:21:31.138Z |
5564368 | 5564368 | 20241120025003_9WlQq | UK0090 | 2024-11-21T14:17:30.998Z | 2024-11-22T14:21:30.890Z |
5563872 | 5563872 | 20241120021138_Y8r33 | UK0090 | 2024-11-21T14:16:52.331Z | 2024-11-22T14:21:24.159Z |
5563809 | 5563809 | 20241120020535_lRDxZ | UK0090 | 2024-11-21T14:16:45.186Z | 2024-11-22T14:21:23.491Z |
5563650 | 5563650 | 20241120015430_O6XYk | UK0090 | 2024-11-21T14:16:31.604Z | 2024-11-22T14:21:20.309Z |
5563283 | 5563283 | 20241120011411_nldKo | UK0090 | 2024-11-21T14:15:50.816Z | 2024-11-22T14:21:12.315Z |
5563243 | 5563243 | 20241120011029_IFqzH | UK0090 | 2024-11-21T14:15:44.628Z | 2024-11-22T14:21:11.621Z |
5563180 | 5563180 | 20241120010238_qEg3N | UK0090 | 2024-11-21T14:15:39.667Z | 2024-11-22T14:21:10.569Z |
5563063 | 5563063 | 20241120004816_rqHn5 | UK0090 | 2024-11-21T14:15:34.305Z | 2024-11-22T14:21:08.997Z |
5562905 | 5562905 | 20241120002615_NrxiU | UK0090 | 2024-11-21T14:15:26.918Z | 2024-11-22T14:21:05.925Z |
5562546 | 5562546 | 20241119234945_QXzoC | UK0090 | 2024-11-21T14:15:07.021Z | 2024-11-22T14:21:00.220Z |
5562513 | 5562513 | 20241119234654_vu1Ot | UK0090 | 2024-11-21T14:15:04.064Z | 2024-11-22T14:20:59.613Z |
5562388 | 5562388 | 20241119233339_OtG0Y | UK0090 | 2024-11-21T14:14:46.319Z | 2024-11-22T14:20:57.025Z |
5562295 | 5562295 | 20241119231956_clME5 | UK0090 | 2024-11-21T14:14:40.899Z | 2024-11-22T14:20:55.369Z |
5562283 | 5562283 | 20241119231951_0jSkf | UK0090 | 2024-11-21T14:14:40.153Z | 2024-11-22T14:20:55.279Z |
5562155 | 5562155 | 20241119230623_Tyc0K | UK0090 | 2024-11-21T14:14:29.368Z | 2024-11-22T14:20:53.498Z |
5562105 | 5562105 | 20241119230023_7Ldkr | UK0090 | 2024-11-21T14:14:25.429Z | 2024-11-22T14:20:52.945Z |
5562040 | 5562040 | 20241119224959_2TBbn | UK0090 | 2024-11-21T14:14:21.557Z | 2024-11-22T14:20:51.874Z |
5561781 | 5561781 | 20241119220626_OuItH | UK0090 | 2024-11-21T14:14:05.191Z | 2024-11-22T14:20:46.234Z |
5561678 | 5561678 | 20241119213051_bIf85 | UK0090 | 2024-11-21T14:13:43.249Z | 2024-11-22T14:20:42.781Z |
5561671 | 5561671 | 20241119212819_WQebg | UK0090 | 2024-11-21T14:13:42.196Z | 2024-11-22T14:20:42.687Z |
5558302 | 5558302 | 20241120055255_bP7R8 | UK0090 | 2024-11-21T14:02:57.944Z | 2024-11-22T14:19:21.207Z |
5558175 | 5558175 | 20241120054212_4oc2A | UK0090 | 2024-11-21T14:02:39.462Z | 2024-11-22T14:19:21.188Z |
5557701 | 5557701 | 20241120050517_GLhx3 | UK0090 | 2024-11-21T14:01:32.083Z | 2024-11-22T14:19:21.113Z |
5553893 | 5553893 | 20241118044302_PC8WY | UK0090 | 2024-11-19T14:11:32.045Z | 2024-11-22T14:22:57.105Z |
5553733 | 5553733 | 20241118040348_fcifL | UK0090 | 2024-11-19T14:11:22.139Z | 2024-11-22T14:22:55.906Z |
5553612 | 5553612 | 20241118033123_aexTp | UK0090 | 2024-11-19T14:11:04.273Z | 2024-11-22T14:22:54.626Z |
5553603 | 5553603 | 20241118033107_hQPxr | UK0090 | 2024-11-19T14:11:03.802Z | 2024-11-22T14:22:54.576Z |
5553579 | 5553579 | 20241118032408_lLnJM | UK0090 | 2024-11-19T14:10:57.138Z | 2024-11-22T14:22:54.374Z |
5553552 | 5553552 | 20241118031857_aFpLA | UK0090 | 2024-11-19T14:10:50.453Z | 2024-11-22T14:22:54.154Z |
5539095 | 5539095 | 20241113054200_Cf8Lp | UK0090 | 2024-11-14T14:14:13.133Z | 2024-11-21T14:26:31.592Z |
5539082 | 5539082 | 20241113054117_OtVyS | UK0090 | 2024-11-14T14:14:11.869Z | 2024-11-21T14:26:31.590Z |
5539049 | 5539049 | 20241113053652_70hl9 | UK0090 | 2024-11-14T14:14:09.903Z | 2024-11-21T14:26:31.072Z |
5538691 | 5538691 | 20241113043713_PUQid | UK0090 | 2024-11-14T14:13:49.488Z | 2024-11-21T14:26:28.532Z |
5538556 | 5538556 | 20241113041009_ujwtG | UK0090 | 2024-11-14T14:13:37.732Z | 2024-11-21T14:26:27.136Z |
5538550 | 5538550 | 20241113040933_iRFu7 | UK0090 | 2024-11-14T14:13:37.500Z | 2024-11-21T14:26:27.115Z |
5538471 | 5538471 | 20241113035159_Abn6O | UK0090 | 2024-11-14T14:13:30.693Z | 2024-11-21T14:26:26.419Z |
5538419 | 5538419 | 20241113033557_C8i2h | UK0090 | 2024-11-14T14:13:24.834Z | 2024-11-21T14:26:25.356Z |
5538381 | 5538381 | 20241113032356_a8MWM | UK0090 | 2024-11-14T14:13:21.838Z | 2024-11-21T14:26:25.070Z |
5538304 | 5538304 | 20241113030255_HB3iZ | UK0090 | 2024-11-14T14:13:12.608Z | 2024-11-21T14:26:22.944Z |
5538283 | 5538283 | 20241113025758_ZPn9w | UK0090 | 2024-11-14T14:13:11.199Z | 2024-11-21T14:26:22.931Z |
5538276 | 5538276 | 20241113025758_bmRB2 | UK0090 | 2024-11-14T14:13:11.035Z | 2024-11-21T14:26:22.921Z |
5537410 | 5537410 | 20241112224431_2OAw7 | UK0090 | 2024-11-14T14:11:45.733Z | 2024-11-21T14:26:12.738Z |
5537370 | 5537370 | 20241112222416_u7sUz | UK0090 | 2024-11-14T14:11:41.203Z | 2024-11-21T14:26:11.516Z |
5537289 | 5537289 | 20241112215518_GtoU4 | UK0090 | 2024-11-14T14:11:31.159Z | 2024-11-21T14:26:10.825Z |
5537263 | 5537263 | 20241112213937_SYlaR | UK0090 | 2024-11-14T14:11:28.712Z | 2024-11-21T14:26:10.716Z |
5532199 | 5532199 | 20241112045157_suJov | UK0090 | 2024-11-13T14:16:26.831Z | 2024-11-20T14:26:20.873Z |
5531683 | 5531683 | 20241112040002_LgjzV | UK0090 | 2024-11-13T14:15:50.552Z | 2024-11-20T14:26:13.433Z |
5531610 | 5531610 | 20241112035218_z6aT8 | UK0090 | 2024-11-13T14:15:46.570Z | 2024-11-20T14:26:12.711Z |
5531603 | 5531603 | 20241112035049_EpaEA | UK0090 | 2024-11-13T14:15:46.226Z | 2024-11-20T14:26:12.655Z |
5531225 | 5531225 | 20241112032331_7iYBG | UK0090 | 2024-11-13T14:15:26.780Z | 2024-11-20T14:26:08.636Z |
5531213 | 5531213 | 20241112032207_EyB2L | UK0090 | 2024-11-13T14:15:25.585Z | 2024-11-20T14:26:08.578Z |
5531001 | 5531001 | 20241112030513_0mqWT | UK0090 | 2024-11-13T14:14:58.973Z | 2024-11-20T14:26:05.863Z |
5530435 | 5530435 | 20241112021723_Qr3BQ | UK0090 | 2024-11-13T14:14:15.306Z | 2024-11-20T14:25:59.777Z |
5528778 | 5528778 | 20241111223808_qpVMP | UK0090 | 2024-11-13T14:11:25.763Z | 2024-11-20T14:25:35.646Z |
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);