participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,066 rows where station_code = "UK0083" 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 |
---|---|---|---|---|---|
5573250 | 5573250 | 20241121041330_wq2AX | UK0083 | 2024-11-22T14:19:18.013Z | 2024-11-22T14:19:22.476Z |
5573084 | 5573084 | 20241121035002_69YPk | UK0083 | 2024-11-22T14:19:09.072Z | 2024-11-22T14:19:22.446Z |
5572990 | 5572990 | 20241121033537_sKrDj | UK0083 | 2024-11-22T14:19:02.691Z | 2024-11-22T14:19:22.428Z |
5572972 | 5572972 | 20241121033216_CyJMO | UK0083 | 2024-11-22T14:19:01.682Z | 2024-11-22T14:19:22.425Z |
5572941 | 5572941 | 20241121032736_Phj3k | UK0083 | 2024-11-22T14:19:00.072Z | 2024-11-22T14:19:22.418Z |
5572891 | 5572891 | 20241121032244_yubup | UK0083 | 2024-11-22T14:18:56.888Z | 2024-11-22T14:19:22.409Z |
5572863 | 5572863 | 20241121031756_LYYPu | UK0083 | 2024-11-22T14:18:53.931Z | 2024-11-22T14:19:22.404Z |
5572816 | 5572816 | 20241121031300_3mR8C | UK0083 | 2024-11-22T14:18:51.295Z | 2024-11-22T14:19:22.395Z |
5572618 | 5572618 | 20241121025019_nmQbI | UK0083 | 2024-11-22T14:18:39.773Z | 2024-11-22T14:19:22.363Z |
5571314 | 5571314 | 20241120232228_0KZLx | UK0083 | 2024-11-22T14:16:50.476Z | 2024-11-22T14:19:22.099Z |
5570969 | 5570969 | 20241120214638_h3p7l | UK0083 | 2024-11-22T14:16:14.784Z | 2024-11-22T14:19:22.015Z |
5570908 | 5570908 | 20241120212650_3OTtQ | UK0083 | 2024-11-22T14:16:11.771Z | 2024-11-22T14:19:22.004Z |
5570442 | 5570442 | 20241120194114_p6uiR | UK0083 | 2024-11-22T14:15:26.390Z | 2024-11-22T14:19:21.918Z |
5569878 | 5569878 | 20241120175338_OvrqZ | UK0083 | 2024-11-22T14:14:29.346Z | 2024-11-22T14:19:21.821Z |
5569810 | 5569810 | 20241120173541_2oF5y | UK0083 | 2024-11-22T14:14:15.966Z | 2024-11-22T14:19:21.810Z |
5566479 | 5566479 | 20241121062045_RAm22 | UK0083 | 2024-11-22T14:02:59.130Z | 2024-11-22T14:02:59.130Z |
5566458 | 5566458 | 20241121061517_r5sSQ | UK0083 | 2024-11-22T14:02:56.399Z | 2024-11-22T14:02:56.399Z |
5566266 | 5566266 | 20241121055413_lubIt | UK0083 | 2024-11-22T14:02:20.114Z | 2024-11-22T14:02:20.114Z |
5566051 | 5566051 | 20241121052042_AO8co | UK0083 | 2024-11-22T14:01:37.454Z | 2024-11-22T14:01:37.454Z |
5566035 | 5566035 | 20241121052004_gAZiF | UK0083 | 2024-11-22T14:01:35.870Z | 2024-11-22T14:01:35.870Z |
5565985 | 5565985 | 20241121051340_k1tqs | UK0083 | 2024-11-22T14:01:31.251Z | 2024-11-22T14:01:31.251Z |
5565913 | 5565913 | 20241121050531_p3t5y | UK0083 | 2024-11-22T14:01:23.577Z | 2024-11-22T14:01:23.577Z |
5565824 | 5565824 | 20241121045144_hL0gM | UK0083 | 2024-11-22T14:01:01.607Z | 2024-11-22T14:01:01.607Z |
5565767 | 5565767 | 20241121044239_CWd9f | UK0083 | 2024-11-22T14:00:54.011Z | 2024-11-22T14:00:54.011Z |
5565748 | 5565748 | 20241121044148_VZLZh | UK0083 | 2024-11-22T14:00:51.507Z | 2024-11-22T14:00:51.507Z |
5565697 | 5565697 | 20241121043629_KbmVR | UK0083 | 2024-11-22T14:00:42.979Z | 2024-11-22T14:00:42.979Z |
5565545 | 5565545 | 20241121042103_2vZtR | UK0083 | 2024-11-22T14:00:15.496Z | 2024-11-22T14:00:15.496Z |
5565527 | 5565527 | 20241121041930_gzd8a | UK0083 | 2024-11-22T14:00:11.951Z | 2024-11-22T14:00:11.951Z |
5562282 | 5562282 | 20241119231951_0jSkf | UK0083 | 2024-11-21T14:14:40.153Z | 2024-11-22T14:20:55.279Z |
5562199 | 5562199 | 20241119230919_uMTyK | UK0083 | 2024-11-21T14:14:31.654Z | 2024-11-22T14:20:53.891Z |
5561373 | 5561373 | 20241119201722_KBj8m | UK0083 | 2024-11-21T14:13:10.739Z | 2024-11-22T14:20:33.931Z |
5561276 | 5561276 | 20241119192548_ycJnq | UK0083 | 2024-11-21T14:12:55.964Z | 2024-11-22T14:20:29.331Z |
5545050 | 5545050 | 20241115225356_P7Abs | UK0083 | 2024-11-17T14:03:41.375Z | 2024-11-22T14:23:35.593Z |
5543169 | 5543169 | 20241114221335_Utfva | UK0083 | 2024-11-16T14:05:38.781Z | 2024-11-22T14:23:57.304Z |
5539093 | 5539093 | 20241113054200_Cf8Lp | UK0083 | 2024-11-14T14:14:13.133Z | 2024-11-21T14:26:31.592Z |
5539048 | 5539048 | 20241113053652_70hl9 | UK0083 | 2024-11-14T14:14:09.903Z | 2024-11-21T14:26:31.072Z |
5538939 | 5538939 | 20241113052252_36M8F | UK0083 | 2024-11-14T14:14:04.648Z | 2024-11-21T14:26:30.081Z |
5538924 | 5538924 | 20241113051955_SY2VF | UK0083 | 2024-11-14T14:14:04.093Z | 2024-11-21T14:26:29.760Z |
5538910 | 5538910 | 20241113051756_ZB5Bq | UK0083 | 2024-11-14T14:14:03.604Z | 2024-11-21T14:26:29.724Z |
5538823 | 5538823 | 20241113050235_MwxOZ | UK0083 | 2024-11-14T14:13:59.193Z | 2024-11-21T14:26:28.829Z |
5538662 | 5538662 | 20241113043227_wTvLw | UK0083 | 2024-11-14T14:13:48.047Z | 2024-11-21T14:26:28.470Z |
5538574 | 5538574 | 20241113041428_0fg1l | UK0083 | 2024-11-14T14:13:39.332Z | 2024-11-21T14:26:27.221Z |
5538554 | 5538554 | 20241113041009_ujwtG | UK0083 | 2024-11-14T14:13:37.732Z | 2024-11-21T14:26:27.136Z |
5538463 | 5538463 | 20241113034947_B0ak3 | UK0083 | 2024-11-14T14:13:30.023Z | 2024-11-21T14:26:26.102Z |
5537409 | 5537409 | 20241112224431_2OAw7 | UK0083 | 2024-11-14T14:11:45.733Z | 2024-11-21T14:26:12.738Z |
5537368 | 5537368 | 20241112222416_u7sUz | UK0083 | 2024-11-14T14:11:41.203Z | 2024-11-21T14:26:11.516Z |
5537286 | 5537286 | 20241112215518_GtoU4 | UK0083 | 2024-11-14T14:11:31.159Z | 2024-11-21T14:26:10.825Z |
5532881 | 5532881 | 20241113061116_ASQoA | UK0083 | 2024-11-14T14:00:27.190Z | 2024-11-22T14:24:05.908Z |
5532847 | 5532847 | 20241113060316_oQQWv | UK0083 | 2024-11-14T14:00:23.127Z | 2024-11-22T14:24:05.651Z |
5532488 | 5532488 | 20241112052906_9PnEE | UK0083 | 2024-11-13T14:16:52.457Z | 2024-11-20T14:26:23.918Z |
5531212 | 5531212 | 20241112032207_EyB2L | UK0083 | 2024-11-13T14:15:25.585Z | 2024-11-20T14:26:08.578Z |
5530899 | 5530899 | 20241112025856_2nYQc | UK0083 | 2024-11-13T14:14:49.259Z | 2024-11-20T14:26:05.129Z |
5530752 | 5530752 | 20241112024334_4C15K | UK0083 | 2024-11-13T14:14:34.256Z | 2024-11-20T14:26:02.992Z |
5530555 | 5530555 | 20241112022802_FuL6p | UK0083 | 2024-11-13T14:14:22.050Z | 2024-11-20T14:26:01.607Z |
5530383 | 5530383 | 20241112021443_qBBBz | UK0083 | 2024-11-13T14:14:12.837Z | 2024-11-20T14:25:58.312Z |
5530138 | 5530138 | 20241112014932_1CaAt | UK0083 | 2024-11-13T14:13:58.282Z | 2024-11-20T14:25:54.833Z |
5529198 | 5529198 | 20241111234632_kacXY | UK0083 | 2024-11-13T14:12:13.334Z | 2024-11-20T14:25:41.774Z |
5529002 | 5529002 | 20241111231734_o0Afu | UK0083 | 2024-11-13T14:11:56.724Z | 2024-11-20T14:25:38.512Z |
5528534 | 5528534 | 20241111212804_sVkof | UK0083 | 2024-11-13T14:11:04.334Z | 2024-11-20T14:25:31.950Z |
5528307 | 5528307 | 20241111201908_VmAUG | UK0083 | 2024-11-13T14:10:26.035Z | 2024-11-20T14:25:28.254Z |
5524801 | 5524801 | 20241111054914_YdrUU | UK0083 | 2024-11-12T14:18:02.035Z | 2024-11-19T14:22:24.144Z |
5524728 | 5524728 | 20241111052141_RrT3d | UK0083 | 2024-11-12T14:17:58.233Z | 2024-11-19T14:22:23.569Z |
5524231 | 5524231 | 20241111033739_CZLPv | UK0083 | 2024-11-12T14:16:49.677Z | 2024-11-19T14:22:19.095Z |
5432588 | 5432588 | 20241029035551_K6bCW | UK0083 | 2024-10-31T12:21:27.957Z | 2024-11-06T14:27:28.137Z |
5432545 | 5432545 | 20241029035135_9wrcS | UK0083 | 2024-10-31T12:21:26.667Z | 2024-11-06T14:27:27.817Z |
5410699 | 5410699 | 20241027052903_M1m7L | UK0083 | 2024-10-29T12:18:02.744Z | 2024-11-04T14:29:05.236Z |
5410612 | 5410612 | 20241027052324_C8RfW | UK0083 | 2024-10-29T12:17:59.573Z | 2024-11-04T14:29:05.099Z |
5410497 | 5410497 | 20241027051544_zFtsH | UK0083 | 2024-10-29T12:17:56.983Z | 2024-11-04T14:29:04.651Z |
5410446 | 5410446 | 20241027051311_2TBK8 | UK0083 | 2024-10-29T12:17:55.799Z | 2024-11-04T14:29:04.602Z |
5410202 | 5410202 | 20241027045939_2YCSm | UK0083 | 2024-10-29T12:17:50.640Z | 2024-11-04T14:29:04.040Z |
5410169 | 5410169 | 20241027045832_yZY1r | UK0083 | 2024-10-29T12:17:49.746Z | 2024-11-04T14:29:03.980Z |
5410051 | 5410051 | 20241027044921_a0NsN | UK0083 | 2024-10-29T12:17:46.601Z | 2024-11-04T14:29:03.633Z |
5409697 | 5409697 | 20241027043055_OcZwY | UK0083 | 2024-10-29T12:17:38.061Z | 2024-11-04T14:29:02.157Z |
5409682 | 5409682 | 20241027043024_nzHgl | UK0083 | 2024-10-29T12:17:37.562Z | 2024-11-04T14:29:02.149Z |
5409668 | 5409668 | 20241027042959_eyu1f | UK0083 | 2024-10-29T12:17:36.363Z | 2024-11-04T14:29:02.061Z |
5409595 | 5409595 | 20241027042736_61ERe | UK0083 | 2024-10-29T12:17:32.048Z | 2024-11-04T14:29:01.970Z |
5409189 | 5409189 | 20241027040511_pf95o | UK0083 | 2024-10-29T12:17:10.694Z | 2024-11-04T14:29:01.357Z |
5409171 | 5409171 | 20241027040355_02mPc | UK0083 | 2024-10-29T12:17:09.544Z | 2024-11-04T14:29:01.235Z |
5408858 | 5408858 | 20241027034647_9Rrkv | UK0083 | 2024-10-29T12:16:55.008Z | 2024-11-04T14:29:00.733Z |
5406858 | 5406858 | 20241027020439_0A7AZ | UK0083 | 2024-10-29T12:14:50.745Z | 2024-11-04T14:28:56.519Z |
5406522 | 5406522 | 20241027014237_CZ3Fi | UK0083 | 2024-10-29T12:14:17.407Z | 2024-11-04T14:28:55.822Z |
5403776 | 5403776 | 20241026223014_JBCOm | UK0083 | 2024-10-29T12:10:13.221Z | 2024-11-04T14:28:49.652Z |
5403654 | 5403654 | 20241026222121_uQvh2 | UK0083 | 2024-10-29T12:10:05.187Z | 2024-11-04T14:28:49.400Z |
5403323 | 5403323 | 20241026214045_GDS6I | UK0083 | 2024-10-29T12:09:21.896Z | 2024-11-04T14:28:48.330Z |
5378057 | 5378057 | 20241024052542_Uh2EC | UK0083 | 2024-10-26T12:22:53.814Z | 2024-11-01T12:27:03.268Z |
5377903 | 5377903 | 20241024051709_aQMcx | UK0083 | 2024-10-26T12:22:49.418Z | 2024-11-01T12:27:03.158Z |
5377826 | 5377826 | 20241024051243_Hn47e | UK0083 | 2024-10-26T12:22:47.850Z | 2024-11-01T12:27:03.080Z |
5376686 | 5376686 | 20241024040833_Ga2b6 | UK0083 | 2024-10-26T12:22:10.289Z | 2024-11-01T12:27:01.741Z |
5376534 | 5376534 | 20241024035912_Z9JHc | UK0083 | 2024-10-26T12:22:04.646Z | 2024-11-01T12:27:01.591Z |
5376388 | 5376388 | 20241024035306_WJG2e | UK0083 | 2024-10-26T12:22:00.212Z | 2024-11-01T12:27:01.520Z |
5376341 | 5376341 | 20241024035152_wesRX | UK0083 | 2024-10-26T12:21:58.170Z | 2024-11-01T12:27:01.505Z |
5376306 | 5376306 | 20241024035030_pLWSq | UK0083 | 2024-10-26T12:21:56.015Z | 2024-11-01T12:27:01.488Z |
5376193 | 5376193 | 20241024034509_9Ahpq | UK0083 | 2024-10-26T12:21:53.063Z | 2024-11-01T12:27:01.447Z |
5376174 | 5376174 | 20241024034449_RVzJc | UK0083 | 2024-10-26T12:21:52.690Z | 2024-11-01T12:27:01.417Z |
5376084 | 5376084 | 20241024034034_awEbb | UK0083 | 2024-10-26T12:21:50.023Z | 2024-11-01T12:27:01.384Z |
5376044 | 5376044 | 20241024033904_9DYTP | UK0083 | 2024-10-26T12:21:48.130Z | 2024-11-01T12:27:01.343Z |
5375438 | 5375438 | 20241024031333_r0yrd | UK0083 | 2024-10-26T12:21:25.784Z | 2024-11-01T12:27:00.690Z |
5365070 | 5365070 | 20241023231209_4HC1j | UK0083 | 2024-10-25T12:17:44.952Z | 2024-11-01T12:26:55.848Z |
5364774 | 5364774 | 20241023225211_o2Fbj | UK0083 | 2024-10-25T12:17:33.874Z | 2024-11-01T12:26:55.624Z |
5364567 | 5364567 | 20241023223829_Q3TOu | UK0083 | 2024-10-25T12:17:25.075Z | 2024-11-01T12:26:55.221Z |
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);