participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
7,087 rows where station_code = "UK005G" 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 |
---|---|---|---|---|---|
5441638 | 5441638 | 20241029225700_Hxbci | UK005G | 2024-11-01T12:18:49.596Z | 2024-11-07T14:26:42.794Z |
5441613 | 5441613 | 20241029225045_1BHJl | UK005G | 2024-11-01T12:18:47.912Z | 2024-11-07T14:26:42.752Z |
5441439 | 5441439 | 20241029221609_5SX8V | UK005G | 2024-11-01T12:18:36.087Z | 2024-11-07T14:26:42.114Z |
5441232 | 5441232 | 20241029211814_rf6aQ | UK005G | 2024-11-01T12:18:20.161Z | 2024-11-07T14:26:41.332Z |
5441171 | 5441171 | 20241029210308_BF4SN | UK005G | 2024-11-01T12:18:14.315Z | 2024-11-07T14:26:41.145Z |
5428903 | 5428903 | 20241028182032_ntlqa | UK005G | 2024-10-31T12:15:39.346Z | 2024-11-06T14:27:14.753Z |
5410586 | 5410586 | 20241027052007_cYzv3 | UK005G | 2024-10-29T12:17:58.907Z | 2024-11-04T14:29:05.067Z |
5410287 | 5410287 | 20241027050523_sT1ol | UK005G | 2024-10-29T12:17:52.434Z | 2024-11-04T14:29:04.303Z |
5410209 | 5410209 | 20241027045948_Tf9ip | UK005G | 2024-10-29T12:17:50.647Z | 2024-11-04T14:29:04.045Z |
5410140 | 5410140 | 20241027045526_BQ6Hg | UK005G | 2024-10-29T12:17:48.871Z | 2024-11-04T14:29:03.885Z |
5409456 | 5409456 | 20241027041930_hQEPn | UK005G | 2024-10-29T12:17:25.074Z | 2024-11-04T14:29:01.830Z |
5409336 | 5409336 | 20241027041119_jU0ix | UK005G | 2024-10-29T12:17:16.824Z | 2024-11-04T14:29:01.588Z |
5409317 | 5409317 | 20241027041050_KcRo2 | UK005G | 2024-10-29T12:17:16.302Z | 2024-11-04T14:29:01.518Z |
5409296 | 5409296 | 20241027041019_PAQMx | UK005G | 2024-10-29T12:17:15.280Z | 2024-11-04T14:29:01.495Z |
5409244 | 5409244 | 20241027040710_iXP1J | UK005G | 2024-10-29T12:17:13.998Z | 2024-11-04T14:29:01.423Z |
5408295 | 5408295 | 20241027032206_Zsote | UK005G | 2024-10-29T12:16:21.326Z | 2024-11-04T14:28:59.067Z |
5408285 | 5408285 | 20241027032126_NTzP5 | UK005G | 2024-10-29T12:16:20.975Z | 2024-11-04T14:28:59.055Z |
5408224 | 5408224 | 20241027031714_m04iw | UK005G | 2024-10-29T12:16:17.952Z | 2024-11-04T14:28:59.010Z |
5408047 | 5408047 | 20241027030455_2FlrU | UK005G | 2024-10-29T12:16:02.821Z | 2024-11-04T14:28:58.743Z |
5407891 | 5407891 | 20241027025702_sDJt4 | UK005G | 2024-10-29T12:15:50.900Z | 2024-11-04T14:28:58.306Z |
5407446 | 5407446 | 20241027023705_f6jLH | UK005G | 2024-10-29T12:15:24.945Z | 2024-11-04T14:28:57.582Z |
5407088 | 5407088 | 20241027022148_6zXmV | UK005G | 2024-10-29T12:15:12.001Z | 2024-11-04T14:28:56.842Z |
5404525 | 5404525 | 20241026233423_43tt7 | UK005G | 2024-10-29T12:11:40.873Z | 2024-11-04T14:28:51.294Z |
5403949 | 5403949 | 20241026224815_POq5j | UK005G | 2024-10-29T12:10:36.195Z | 2024-11-04T14:28:50.071Z |
5403827 | 5403827 | 20241026223441_2udXN | UK005G | 2024-10-29T12:10:17.024Z | 2024-11-04T14:28:49.835Z |
5403795 | 5403795 | 20241026223214_GHj0r | UK005G | 2024-10-29T12:10:14.241Z | 2024-11-04T14:28:49.743Z |
5403148 | 5403148 | 20241026212355_WraZH | UK005G | 2024-10-29T12:09:06.268Z | 2024-11-04T14:28:47.868Z |
5402461 | 5402461 | 20241026193937_lb3Oc | UK005G | 2024-10-29T12:07:21.063Z | 2024-11-04T14:28:44.682Z |
5399500 | 5399500 | 20241026042902_PL2t4 | UK005G | 2024-10-28T12:20:01.173Z | 2024-11-03T14:27:39.878Z |
5399445 | 5399445 | 20241026041841_xDpik | UK005G | 2024-10-28T12:19:59.745Z | 2024-11-03T14:27:39.733Z |
5399411 | 5399411 | 20241026041555_liYDh | UK005G | 2024-10-28T12:19:58.541Z | 2024-11-03T14:27:39.656Z |
5399296 | 5399296 | 20241026040914_uoC5V | UK005G | 2024-10-28T12:19:53.561Z | 2024-11-03T14:27:39.350Z |
5399236 | 5399236 | 20241026040412_FjTZg | UK005G | 2024-10-28T12:19:52.306Z | 2024-11-03T14:27:39.275Z |
5399090 | 5399090 | 20241026034943_nvooH | UK005G | 2024-10-28T12:19:48.206Z | 2024-11-03T14:27:39.012Z |
5397010 | 5397010 | 20241026005605_x9ve1 | UK005G | 2024-10-28T12:18:02.506Z | 2024-11-03T14:27:31.731Z |
5396465 | 5396465 | 20241026000600_MOjRm | UK005G | 2024-10-28T12:17:44.968Z | 2024-11-03T14:27:29.945Z |
5396433 | 5396433 | 20241026000418_TYapn | UK005G | 2024-10-28T12:17:43.073Z | 2024-11-03T14:27:29.830Z |
5386231 | 5386231 | 20241025001648_ZHSBU | UK005G | 2024-10-27T12:19:55.917Z | 2024-11-02T12:28:30.855Z |
5386136 | 5386136 | 20241025000635_h1IYE | UK005G | 2024-10-27T12:19:52.066Z | 2024-11-02T12:28:30.724Z |
5385560 | 5385560 | 20241024230125_NaYbz | UK005G | 2024-10-27T12:19:06.413Z | 2024-11-02T12:28:29.940Z |
5385511 | 5385511 | 20241024225552_yzjFF | UK005G | 2024-10-27T12:19:00.872Z | 2024-11-02T12:28:29.890Z |
5385451 | 5385451 | 20241024224736_qp2ua | UK005G | 2024-10-27T12:18:56.994Z | 2024-11-02T12:28:29.846Z |
5384835 | 5384835 | 20241024210210_JSU2a | UK005G | 2024-10-27T12:17:48.541Z | 2024-11-02T12:28:28.424Z |
5383361 | 5383361 | 20241024181444_84610 | UK005G | 2024-10-27T12:15:20.900Z | 2024-11-02T12:28:25.080Z |
5375557 | 5375557 | 20241024031944_IEoTM | UK005G | 2024-10-26T12:21:31.225Z | 2024-11-01T12:27:00.774Z |
5374393 | 5374393 | 20241024022519_giMIj | UK005G | 2024-10-26T12:20:47.255Z | 2024-11-01T12:26:59.356Z |
5372722 | 5372722 | 20241024010503_I0yNi | UK005G | 2024-10-26T12:19:40.018Z | 2024-11-01T12:26:57.894Z |
5372417 | 5372417 | 20241024004705_jGtYc | UK005G | 2024-10-26T12:19:23.533Z | 2024-11-01T12:26:57.435Z |
5372276 | 5372276 | 20241024004212_cKoEp | UK005G | 2024-10-26T12:19:17.600Z | 2024-11-01T12:26:57.337Z |
5372054 | 5372054 | 20241024002950_AMb2B | UK005G | 2024-10-26T12:19:05.500Z | 2024-11-01T12:26:57.078Z |
5371932 | 5371932 | 20241024002333_sbiDE | UK005G | 2024-10-26T12:18:58.845Z | 2024-11-01T12:26:57.003Z |
5366397 | 5366397 | 20241024001849_YPKLy | UK005G | 2024-10-25T12:18:25.543Z | 2024-11-01T12:26:56.945Z |
5365875 | 5365875 | 20241023235407_qh5Op | UK005G | 2024-10-25T12:18:09.507Z | 2024-11-01T12:26:56.460Z |
5365655 | 5365655 | 20241023234152_GVFt3 | UK005G | 2024-10-25T12:18:04.078Z | 2024-11-01T12:26:56.329Z |
5365632 | 5365632 | 20241023234133_N4k7n | UK005G | 2024-10-25T12:18:03.763Z | 2024-11-01T12:26:56.310Z |
5365471 | 5365471 | 20241023233331_tUAE5 | UK005G | 2024-10-25T12:17:58.649Z | 2024-11-01T12:26:56.158Z |
5365409 | 5365409 | 20241023233051_RNfBS | UK005G | 2024-10-25T12:17:57.476Z | 2024-11-01T12:26:56.084Z |
5365318 | 5365318 | 20241023232537_mJ2nF | UK005G | 2024-10-25T12:17:55.689Z | 2024-11-01T12:26:56.052Z |
5365045 | 5365045 | 20241023231145_UwF0H | UK005G | 2024-10-25T12:17:44.193Z | 2024-11-01T12:26:55.835Z |
5364511 | 5364511 | 20241023223519_sEjUB | UK005G | 2024-10-25T12:17:23.346Z | 2024-11-01T12:26:55.165Z |
5364248 | 5364248 | 20241023221627_ju949 | UK005G | 2024-10-25T12:17:13.640Z | 2024-11-01T12:26:54.621Z |
5364227 | 5364227 | 20241023221432_RUfUc | UK005G | 2024-10-25T12:17:12.835Z | 2024-11-01T12:26:54.613Z |
5355001 | 5355001 | 20241023030350_ma0Nr | UK005G | 2024-10-24T12:20:59.766Z | 2024-10-31T12:30:06.924Z |
5352850 | 5352850 | 20241023005313_1Rq3J | UK005G | 2024-10-24T12:19:18.573Z | 2024-10-31T12:30:03.414Z |
5352237 | 5352237 | 20241023002138_YUO1Q | UK005G | 2024-10-24T12:18:33.829Z | 2024-10-31T12:30:02.350Z |
5352200 | 5352200 | 20241023001718_QHRKg | UK005G | 2024-10-24T12:18:30.209Z | 2024-10-31T12:30:02.290Z |
5352157 | 5352157 | 20241023001555_AaL3O | UK005G | 2024-10-24T12:18:27.520Z | 2024-10-31T12:30:02.254Z |
5351087 | 5351087 | 20241022225612_2soM9 | UK005G | 2024-10-24T12:17:12.710Z | 2024-10-31T12:29:59.446Z |
5350915 | 5350915 | 20241022224029_LkXYk | UK005G | 2024-10-24T12:16:48.870Z | 2024-10-31T12:29:59.034Z |
5350431 | 5350431 | 20241022214843_ppZ31 | UK005G | 2024-10-24T12:15:45.553Z | 2024-10-31T12:29:58.165Z |
5349046 | 5349046 | 20241022192252_5bwNr | UK005G | 2024-10-24T12:13:01.221Z | 2024-10-31T12:29:54.519Z |
5344847 | 5344847 | 20241022045053_6Tg5T | UK005G | 2024-10-23T12:18:53.847Z | 2024-10-30T12:26:51.858Z |
5344616 | 5344616 | 20241022043416_pwdRu | UK005G | 2024-10-23T12:18:43.267Z | 2024-10-30T12:26:51.419Z |
5344531 | 5344531 | 20241022042939_CIHxY | UK005G | 2024-10-23T12:18:40.742Z | 2024-10-30T12:26:51.348Z |
5344481 | 5344481 | 20241022042621_efzGZ | UK005G | 2024-10-23T12:18:39.603Z | 2024-10-30T12:26:51.286Z |
5343959 | 5343959 | 20241022035808_77Plz | UK005G | 2024-10-23T12:18:15.999Z | 2024-10-30T12:26:50.817Z |
5343948 | 5343948 | 20241022035805_bKBc4 | UK005G | 2024-10-23T12:18:15.710Z | 2024-10-30T12:26:50.815Z |
5343705 | 5343705 | 20241022034040_IAl2H | UK005G | 2024-10-23T12:18:02.087Z | 2024-10-30T12:26:50.461Z |
5343403 | 5343403 | 20241022032743_4hNa3 | UK005G | 2024-10-23T12:17:45.762Z | 2024-10-30T12:26:50.004Z |
5343311 | 5343311 | 20241022032138_QUjPf | UK005G | 2024-10-23T12:17:42.195Z | 2024-10-30T12:26:49.910Z |
5342994 | 5342994 | 20241022025856_s6suu | UK005G | 2024-10-23T12:17:31.097Z | 2024-10-30T12:26:49.125Z |
5342886 | 5342886 | 20241022025204_kb8g8 | UK005G | 2024-10-23T12:17:27.840Z | 2024-10-30T12:26:49.031Z |
5342571 | 5342571 | 20241022023429_4Qq3l | UK005G | 2024-10-23T12:17:05.033Z | 2024-10-30T12:26:48.683Z |
5339488 | 5339488 | 20241021224606_LOn3B | UK005G | 2024-10-23T12:13:10.460Z | 2024-10-30T12:26:44.286Z |
5339376 | 5339376 | 20241021222851_OpRtp | UK005G | 2024-10-23T12:13:03.164Z | 2024-10-30T12:26:44.063Z |
5339266 | 5339266 | 20241021221743_JzsNL | UK005G | 2024-10-23T12:12:56.457Z | 2024-10-30T12:26:43.932Z |
5339258 | 5339258 | 20241021221637_1GpVf | UK005G | 2024-10-23T12:12:55.962Z | 2024-10-30T12:26:43.917Z |
5339185 | 5339185 | 20241021220443_3U1Pg | UK005G | 2024-10-23T12:12:49.382Z | 2024-10-30T12:26:43.765Z |
5339081 | 5339081 | 20241021214703_KVHBn | UK005G | 2024-10-23T12:12:28.776Z | 2024-10-30T12:26:43.538Z |
5338998 | 5338998 | 20241021213445_KvRxR | UK005G | 2024-10-23T12:12:21.075Z | 2024-10-30T12:26:43.363Z |
5338948 | 5338948 | 20241021212533_FGxLy | UK005G | 2024-10-23T12:12:17.441Z | 2024-10-30T12:26:43.301Z |
5332304 | 5332304 | 20241020181046_OXfQs | UK005G | 2024-10-22T12:12:21.543Z | 2024-10-29T12:26:32.691Z |
5326414 | 5326414 | 20241019182223_ikUvt | UK005G | 2024-10-21T12:09:22.604Z | 2024-10-28T12:26:41.626Z |
5326388 | 5326388 | 20241019181638_KNfjn | UK005G | 2024-10-21T12:09:19.455Z | 2024-10-28T12:26:41.572Z |
5321491 | 5321491 | 20241018045949_Hidzg | UK005G | 2024-10-19T12:07:40.439Z | 2024-10-26T12:27:56.889Z |
5321460 | 5321460 | 20241018045407_r0EPu | UK005G | 2024-10-19T12:07:31.162Z | 2024-10-26T12:27:56.870Z |
5321436 | 5321436 | 20241018045155_o5281 | UK005G | 2024-10-19T12:07:28.451Z | 2024-10-26T12:27:56.839Z |
5321343 | 5321343 | 20241018043425_g7lWY | UK005G | 2024-10-19T12:07:13.935Z | 2024-10-26T12:27:56.556Z |
5321259 | 5321259 | 20241018041842_xpdn7 | UK005G | 2024-10-19T12:07:06.347Z | 2024-10-26T12:27:56.416Z |
5321247 | 5321247 | 20241018041531_YgoQq | UK005G | 2024-10-19T12:07:04.781Z | 2024-10-26T12:27:56.399Z |
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);