participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,283 rows where station_code = "UK008S" 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 |
---|---|---|---|---|---|
5573085 | 5573085 | 20241121035002_69YPk | UK008S | 2024-11-22T14:19:09.072Z | 2024-11-22T14:19:22.446Z |
5572991 | 5572991 | 20241121033537_sKrDj | UK008S | 2024-11-22T14:19:02.691Z | 2024-11-22T14:19:22.428Z |
5572973 | 5572973 | 20241121033216_CyJMO | UK008S | 2024-11-22T14:19:01.682Z | 2024-11-22T14:19:22.425Z |
5572942 | 5572942 | 20241121032736_Phj3k | UK008S | 2024-11-22T14:19:00.072Z | 2024-11-22T14:19:22.418Z |
5572933 | 5572933 | 20241121032635_cO6Rd | UK008S | 2024-11-22T14:18:59.440Z | 2024-11-22T14:19:22.416Z |
5572892 | 5572892 | 20241121032244_yubup | UK008S | 2024-11-22T14:18:56.888Z | 2024-11-22T14:19:22.409Z |
5572844 | 5572844 | 20241121031612_BXH4O | UK008S | 2024-11-22T14:18:53.161Z | 2024-11-22T14:19:22.401Z |
5572817 | 5572817 | 20241121031300_3mR8C | UK008S | 2024-11-22T14:18:51.295Z | 2024-11-22T14:19:22.395Z |
5572797 | 5572797 | 20241121031028_Ai9WK | UK008S | 2024-11-22T14:18:50.579Z | 2024-11-22T14:19:22.393Z |
5572619 | 5572619 | 20241121025019_nmQbI | UK008S | 2024-11-22T14:18:39.773Z | 2024-11-22T14:19:22.363Z |
5572586 | 5572586 | 20241121024503_D9vow | UK008S | 2024-11-22T14:18:38.303Z | 2024-11-22T14:19:22.356Z |
5572381 | 5572381 | 20241121021552_4aCY4 | UK008S | 2024-11-22T14:18:20.933Z | 2024-11-22T14:19:22.318Z |
5572303 | 5572303 | 20241121020726_n1CJu | UK008S | 2024-11-22T14:18:14.577Z | 2024-11-22T14:19:22.302Z |
5572186 | 5572186 | 20241121014450_iLf13 | UK008S | 2024-11-22T14:18:03.836Z | 2024-11-22T14:19:22.276Z |
5572086 | 5572086 | 20241121013200_fd3l4 | UK008S | 2024-11-22T14:17:56.846Z | 2024-11-22T14:19:22.256Z |
5571900 | 5571900 | 20241121010335_ZjdWw | UK008S | 2024-11-22T14:17:46.075Z | 2024-11-22T14:19:22.218Z |
5571875 | 5571875 | 20241121005944_675bG | UK008S | 2024-11-22T14:17:44.281Z | 2024-11-22T14:19:22.213Z |
5571722 | 5571722 | 20241121003606_0w2fj | UK008S | 2024-11-22T14:17:36.129Z | 2024-11-22T14:19:22.181Z |
5571580 | 5571580 | 20241121001042_zFArK | UK008S | 2024-11-22T14:17:20.185Z | 2024-11-22T14:19:22.153Z |
5571480 | 5571480 | 20241120235447_WCCpl | UK008S | 2024-11-22T14:17:10.297Z | 2024-11-22T14:19:22.134Z |
5571382 | 5571382 | 20241120233514_mpndf | UK008S | 2024-11-22T14:16:59.832Z | 2024-11-22T14:19:22.114Z |
5571358 | 5571358 | 20241120232750_70g2P | UK008S | 2024-11-22T14:16:56.563Z | 2024-11-22T14:19:22.109Z |
5571330 | 5571330 | 20241120232350_pgLXV | UK008S | 2024-11-22T14:16:51.302Z | 2024-11-22T14:19:22.102Z |
5571281 | 5571281 | 20241120231251_OJh04 | UK008S | 2024-11-22T14:16:47.781Z | 2024-11-22T14:19:22.089Z |
5571253 | 5571253 | 20241120230828_POSt4 | UK008S | 2024-11-22T14:16:43.906Z | 2024-11-22T14:19:22.079Z |
5570909 | 5570909 | 20241120212650_3OTtQ | UK008S | 2024-11-22T14:16:11.771Z | 2024-11-22T14:19:22.004Z |
5570827 | 5570827 | 20241120210944_0hZ3p | UK008S | 2024-11-22T14:16:07.852Z | 2024-11-22T14:19:21.989Z |
5570504 | 5570504 | 20241120195049_8DHTy | UK008S | 2024-11-22T14:15:37.939Z | 2024-11-22T14:19:21.928Z |
5569904 | 5569904 | 20241120175540_Z3mmg | UK008S | 2024-11-22T14:14:33.229Z | 2024-11-22T14:19:21.826Z |
5569811 | 5569811 | 20241120173541_2oF5y | UK008S | 2024-11-22T14:14:15.966Z | 2024-11-22T14:19:21.810Z |
5566267 | 5566267 | 20241121055413_lubIt | UK008S | 2024-11-22T14:02:20.114Z | 2024-11-22T14:02:20.114Z |
5565881 | 5565881 | 20241121050006_fHtuo | UK008S | 2024-11-22T14:01:19.514Z | 2024-11-22T14:01:19.514Z |
5565825 | 5565825 | 20241121045144_hL0gM | UK008S | 2024-11-22T14:01:01.607Z | 2024-11-22T14:01:01.607Z |
5565714 | 5565714 | 20241121043722_cKcde | UK008S | 2024-11-22T14:00:45.808Z | 2024-11-22T14:00:45.808Z |
5565601 | 5565601 | 20241121042442_fkZOm | UK008S | 2024-11-22T14:00:23.340Z | 2024-11-22T14:00:23.340Z |
5563282 | 5563282 | 20241120011411_nldKo | UK008S | 2024-11-21T14:15:50.816Z | 2024-11-22T14:21:12.315Z |
5563271 | 5563271 | 20241120011340_ZIjrS | UK008S | 2024-11-21T14:15:50.018Z | 2024-11-22T14:21:12.030Z |
5563062 | 5563062 | 20241120004816_rqHn5 | UK008S | 2024-11-21T14:15:34.305Z | 2024-11-22T14:21:08.997Z |
5562953 | 5562953 | 20241120003434_BjLPD | UK008S | 2024-11-21T14:15:30.010Z | 2024-11-22T14:21:06.970Z |
5562294 | 5562294 | 20241119231956_clME5 | UK008S | 2024-11-21T14:14:40.899Z | 2024-11-22T14:20:55.369Z |
5562039 | 5562039 | 20241119224959_2TBbn | UK008S | 2024-11-21T14:14:21.557Z | 2024-11-22T14:20:51.874Z |
5561830 | 5561830 | 20241119221514_CIGAA | UK008S | 2024-11-21T14:14:08.993Z | 2024-11-22T14:20:47.161Z |
5558390 | 5558390 | 20241120060139_ItavS | UK008S | 2024-11-21T14:03:10.710Z | 2024-11-22T14:19:21.222Z |
5558383 | 5558383 | 20241120060136_cL2x0 | UK008S | 2024-11-21T14:03:10.330Z | 2024-11-22T14:19:21.221Z |
5558378 | 5558378 | 20241120060132_nm3SC | UK008S | 2024-11-21T14:03:09.753Z | 2024-11-22T14:19:21.221Z |
5541876 | 5541876 | 20241114050230_Gs3do | UK008S | 2024-11-15T14:08:36.710Z | 2024-11-22T14:24:20.767Z |
5538877 | 5538877 | 20241113050727_LpapR | UK008S | 2024-11-14T14:14:01.609Z | 2024-11-21T14:26:29.352Z |
5538690 | 5538690 | 20241113043713_PUQid | UK008S | 2024-11-14T14:13:49.488Z | 2024-11-21T14:26:28.532Z |
5538663 | 5538663 | 20241113043227_wTvLw | UK008S | 2024-11-14T14:13:48.047Z | 2024-11-21T14:26:28.470Z |
5538555 | 5538555 | 20241113041009_ujwtG | UK008S | 2024-11-14T14:13:37.732Z | 2024-11-21T14:26:27.136Z |
5538470 | 5538470 | 20241113035159_Abn6O | UK008S | 2024-11-14T14:13:30.693Z | 2024-11-21T14:26:26.419Z |
5538418 | 5538418 | 20241113033557_C8i2h | UK008S | 2024-11-14T14:13:24.834Z | 2024-11-21T14:26:25.356Z |
5538387 | 5538387 | 20241113032505_zqJ6Y | UK008S | 2024-11-14T14:13:22.011Z | 2024-11-21T14:26:25.071Z |
5538282 | 5538282 | 20241113025758_ZPn9w | UK008S | 2024-11-14T14:13:11.199Z | 2024-11-21T14:26:22.931Z |
5538057 | 5538057 | 20241113020500_Lbjl1 | UK008S | 2024-11-14T14:12:48.129Z | 2024-11-21T14:26:19.961Z |
5537954 | 5537954 | 20241113013949_H3wRs | UK008S | 2024-11-14T14:12:39.642Z | 2024-11-21T14:26:17.473Z |
5537743 | 5537743 | 20241113002640_zoxQw | UK008S | 2024-11-14T14:12:27.635Z | 2024-11-21T14:26:15.621Z |
5537599 | 5537599 | 20241112235151_4134Z | UK008S | 2024-11-14T14:12:16.014Z | 2024-11-21T14:26:14.925Z |
5537565 | 5537565 | 20241112234026_Eqvh1 | UK008S | 2024-11-14T14:12:10.691Z | 2024-11-21T14:26:14.246Z |
5537468 | 5537468 | 20241112231301_J2OHx | UK008S | 2024-11-14T14:11:53.689Z | 2024-11-21T14:26:13.237Z |
5537437 | 5537437 | 20241112230034_OgL9R | UK008S | 2024-11-14T14:11:47.909Z | 2024-11-21T14:26:12.989Z |
5537394 | 5537394 | 20241112223832_EnUyf | UK008S | 2024-11-14T14:11:44.035Z | 2024-11-21T14:26:12.619Z |
5537369 | 5537369 | 20241112222416_u7sUz | UK008S | 2024-11-14T14:11:41.203Z | 2024-11-21T14:26:11.516Z |
5537328 | 5537328 | 20241112220850_ekY8o | UK008S | 2024-11-14T14:11:35.846Z | 2024-11-21T14:26:11.267Z |
5537288 | 5537288 | 20241112215518_GtoU4 | UK008S | 2024-11-14T14:11:31.159Z | 2024-11-21T14:26:10.825Z |
5537262 | 5537262 | 20241112213937_SYlaR | UK008S | 2024-11-14T14:11:28.704Z | 2024-11-21T14:26:10.716Z |
5531788 | 5531788 | 20241112040906_atty8 | UK008S | 2024-11-13T14:15:55.054Z | 2024-11-20T14:26:14.329Z |
5531609 | 5531609 | 20241112035218_z6aT8 | UK008S | 2024-11-13T14:15:46.570Z | 2024-11-20T14:26:12.711Z |
5531196 | 5531196 | 20241112032055_uNFXm | UK008S | 2024-11-13T14:15:23.531Z | 2024-11-20T14:26:08.517Z |
5531000 | 5531000 | 20241112030513_0mqWT | UK008S | 2024-11-13T14:14:58.973Z | 2024-11-20T14:26:05.863Z |
5530753 | 5530753 | 20241112024334_4C15K | UK008S | 2024-11-13T14:14:34.256Z | 2024-11-20T14:26:02.992Z |
5530427 | 5530427 | 20241112021620_3ziRH | UK008S | 2024-11-13T14:14:14.989Z | 2024-11-20T14:25:58.913Z |
5530257 | 5530257 | 20241112020235_9M4Gi | UK008S | 2024-11-13T14:14:04.739Z | 2024-11-20T14:25:56.122Z |
5529966 | 5529966 | 20241112012939_pQEH8 | UK008S | 2024-11-13T14:13:30.364Z | 2024-11-20T14:25:51.639Z |
5529929 | 5529929 | 20241112012444_EhUIF | UK008S | 2024-11-13T14:13:24.940Z | 2024-11-20T14:25:51.075Z |
5529451 | 5529451 | 20241112002136_3ORQr | UK008S | 2024-11-13T14:12:51.167Z | 2024-11-20T14:25:45.057Z |
5529439 | 5529439 | 20241112002058_xt98l | UK008S | 2024-11-13T14:12:47.850Z | 2024-11-20T14:25:44.713Z |
5529173 | 5529173 | 20241111234114_YHhpC | UK008S | 2024-11-13T14:12:10.909Z | 2024-11-20T14:25:41.281Z |
5528777 | 5528777 | 20241111223808_qpVMP | UK008S | 2024-11-13T14:11:25.763Z | 2024-11-20T14:25:35.646Z |
5524578 | 5524578 | 20241111044035_7r3Al | UK008S | 2024-11-12T14:17:42.839Z | 2024-11-19T14:22:22.472Z |
5523835 | 5523835 | 20241111023210_fe9B3 | UK008S | 2024-11-12T14:16:16.171Z | 2024-11-19T14:22:15.474Z |
5410498 | 5410498 | 20241027051544_zFtsH | UK008S | 2024-10-29T12:17:56.983Z | 2024-11-04T14:29:04.651Z |
5409190 | 5409190 | 20241027040511_pf95o | UK008S | 2024-10-29T12:17:10.694Z | 2024-11-04T14:29:01.357Z |
5409157 | 5409157 | 20241027040324_piW2n | UK008S | 2024-10-29T12:17:09.260Z | 2024-11-04T14:29:01.228Z |
5409006 | 5409006 | 20241027035415_GA0Rd | UK008S | 2024-10-29T12:17:01.296Z | 2024-11-04T14:29:00.921Z |
5408968 | 5408968 | 20241027035141_O3X66 | UK008S | 2024-10-29T12:16:58.445Z | 2024-11-04T14:29:00.879Z |
5408608 | 5408608 | 20241027033204_cQPv8 | UK008S | 2024-10-29T12:16:39.108Z | 2024-11-04T14:28:59.674Z |
5408564 | 5408564 | 20241027033030_vnuBv | UK008S | 2024-10-29T12:16:36.124Z | 2024-11-04T14:28:59.618Z |
5408546 | 5408546 | 20241027033015_S6h1q | UK008S | 2024-10-29T12:16:35.713Z | 2024-11-04T14:28:59.614Z |
5408359 | 5408359 | 20241027032326_g33z3 | UK008S | 2024-10-29T12:16:24.794Z | 2024-11-04T14:28:59.284Z |
5402631 | 5402631 | 20241026200704_cNJ5P | UK008S | 2024-10-29T12:07:50.489Z | 2024-11-04T14:28:45.815Z |
5402437 | 5402437 | 20241026193709_Y7PnR | UK008S | 2024-10-29T12:07:17.284Z | 2024-11-04T14:28:44.444Z |
5399342 | 5399342 | 20241026041140_R376e | UK008S | 2024-10-28T12:19:55.327Z | 2024-11-03T14:27:39.506Z |
5399325 | 5399325 | 20241026041019_VVEFi | UK008S | 2024-10-28T12:19:54.718Z | 2024-11-03T14:27:39.448Z |
5399048 | 5399048 | 20241026034658_XAPTn | UK008S | 2024-10-28T12:19:45.704Z | 2024-11-03T14:27:38.944Z |
5399024 | 5399024 | 20241026034526_9a8Io | UK008S | 2024-10-28T12:19:44.692Z | 2024-11-03T14:27:38.906Z |
5398938 | 5398938 | 20241026033936_W3sJg | UK008S | 2024-10-28T12:19:40.644Z | 2024-11-03T14:27:38.663Z |
5398755 | 5398755 | 20241026032600_aDLHv | UK008S | 2024-10-28T12:19:31.368Z | 2024-11-03T14:27:37.986Z |
5398741 | 5398741 | 20241026032349_hdf7j | UK008S | 2024-10-28T12:19:30.069Z | 2024-11-03T14:27:37.942Z |
5398726 | 5398726 | 20241026032150_7NVzB | UK008S | 2024-10-28T12:19:29.672Z | 2024-11-03T14:27:37.899Z |
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);