participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "UK003X" 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 |
---|---|---|---|---|---|
5570508 | 5570508 | 20241120195109_55SNH | UK003X | 2024-11-22T14:15:38.227Z | 2024-11-22T14:19:21.929Z |
5570424 | 5570424 | 20241120193535_Mam9W | UK003X | 2024-11-22T14:15:24.430Z | 2024-11-22T14:19:21.915Z |
5570388 | 5570388 | 20241120193141_b32Gz | UK003X | 2024-11-22T14:15:19.210Z | 2024-11-22T14:19:21.910Z |
5570339 | 5570339 | 20241120192031_Mpv0p | UK003X | 2024-11-22T14:15:12.168Z | 2024-11-22T14:19:21.901Z |
5570284 | 5570284 | 20241120191243_506qi | UK003X | 2024-11-22T14:15:06.112Z | 2024-11-22T14:19:21.892Z |
5570248 | 5570248 | 20241120190801_DUO2M | UK003X | 2024-11-22T14:15:04.159Z | 2024-11-22T14:19:21.887Z |
5570160 | 5570160 | 20241120185230_3bO2T | UK003X | 2024-11-22T14:14:56.354Z | 2024-11-22T14:19:21.872Z |
5570121 | 5570121 | 20241120184529_qiOFO | UK003X | 2024-11-22T14:14:53.802Z | 2024-11-22T14:19:21.866Z |
5569791 | 5569791 | 20241120173150_0YG34 | UK003X | 2024-11-22T14:14:11.249Z | 2024-11-22T14:19:21.805Z |
5565260 | 5565260 | 20241120040846_SL1dO | UK003X | 2024-11-21T14:18:44.025Z | 2024-11-22T14:21:44.777Z |
5565128 | 5565128 | 20241120035432_PW6Ms | UK003X | 2024-11-21T14:18:32.947Z | 2024-11-22T14:21:42.222Z |
5565072 | 5565072 | 20241120035033_dxUny | UK003X | 2024-11-21T14:18:28.415Z | 2024-11-22T14:21:41.341Z |
5565004 | 5565004 | 20241120034414_5Vdek | UK003X | 2024-11-21T14:18:18.844Z | 2024-11-22T14:21:40.215Z |
5564960 | 5564960 | 20241120034218_74CSR | UK003X | 2024-11-21T14:18:16.541Z | 2024-11-22T14:21:39.810Z |
5564842 | 5564842 | 20241120033011_gSD9H | UK003X | 2024-11-21T14:18:06.804Z | 2024-11-22T14:21:36.887Z |
5564662 | 5564662 | 20241120031703_WCQnX | UK003X | 2024-11-21T14:17:55.901Z | 2024-11-22T14:21:34.958Z |
5564586 | 5564586 | 20241120031131_tfBi2 | UK003X | 2024-11-21T14:17:51.799Z | 2024-11-22T14:21:33.783Z |
5564490 | 5564490 | 20241120030300_tdre2 | UK003X | 2024-11-21T14:17:42.057Z | 2024-11-22T14:21:32.807Z |
5564353 | 5564353 | 20241120024903_ivbyU | UK003X | 2024-11-21T14:17:28.692Z | 2024-11-22T14:21:30.723Z |
5564317 | 5564317 | 20241120024738_3Tnx3 | UK003X | 2024-11-21T14:17:27.288Z | 2024-11-22T14:21:30.422Z |
5564241 | 5564241 | 20241120024056_lXHGV | UK003X | 2024-11-21T14:17:21.434Z | 2024-11-22T14:21:29.289Z |
5564195 | 5564195 | 20241120023755_w0pr4 | UK003X | 2024-11-21T14:17:18.019Z | 2024-11-22T14:21:28.743Z |
5564177 | 5564177 | 20241120023502_YHXWw | UK003X | 2024-11-21T14:17:15.565Z | 2024-11-22T14:21:27.884Z |
5564025 | 5564025 | 20241120022444_BK3Sv | UK003X | 2024-11-21T14:17:05.246Z | 2024-11-22T14:21:26.537Z |
5563309 | 5563309 | 20241120011610_KC4wl | UK003X | 2024-11-21T14:15:52.391Z | 2024-11-22T14:21:12.603Z |
5563158 | 5563158 | 20241120005916_dF3r2 | UK003X | 2024-11-21T14:15:38.705Z | 2024-11-22T14:21:10.191Z |
5563152 | 5563152 | 20241120005856_a8L3l | UK003X | 2024-11-21T14:15:38.500Z | 2024-11-22T14:21:10.151Z |
5563038 | 5563038 | 20241120004448_EVpqN | UK003X | 2024-11-21T14:15:32.484Z | 2024-11-22T14:21:07.935Z |
5562775 | 5562775 | 20241120001107_JzmB3 | UK003X | 2024-11-21T14:15:21.567Z | 2024-11-22T14:21:03.893Z |
5562708 | 5562708 | 20241120000441_lzEId | UK003X | 2024-11-21T14:15:17.604Z | 2024-11-22T14:21:02.746Z |
5562575 | 5562575 | 20241119235306_Nak4W | UK003X | 2024-11-21T14:15:10.815Z | 2024-11-22T14:21:00.730Z |
5562358 | 5562358 | 20241119232932_rdCXM | UK003X | 2024-11-21T14:14:44.638Z | 2024-11-22T14:20:56.638Z |
5562192 | 5562192 | 20241119230854_n9Ivt | UK003X | 2024-11-21T14:14:31.599Z | 2024-11-22T14:20:53.890Z |
5562076 | 5562076 | 20241119225836_Gb8zI | UK003X | 2024-11-21T14:14:23.585Z | 2024-11-22T14:20:52.447Z |
5562056 | 5562056 | 20241119225319_SbN4P | UK003X | 2024-11-21T14:14:22.470Z | 2024-11-22T14:20:52.201Z |
5561330 | 5561330 | 20241119195748_hIfUb | UK003X | 2024-11-21T14:13:06.387Z | 2024-11-22T14:20:32.322Z |
5561250 | 5561250 | 20241119191937_qsgCK | UK003X | 2024-11-21T14:12:49.022Z | 2024-11-22T14:20:28.673Z |
5561210 | 5561210 | 20241119190339_ra1y3 | UK003X | 2024-11-21T14:12:36.924Z | 2024-11-22T14:20:26.284Z |
5561107 | 5561107 | 20241119181704_EZ5U2 | UK003X | 2024-11-21T14:12:24.006Z | 2024-11-22T14:20:20.935Z |
5561092 | 5561092 | 20241119180801_Om49e | UK003X | 2024-11-21T14:12:22.252Z | 2024-11-22T14:20:20.202Z |
5558485 | 5558485 | 20241120061428_2WU2U | UK003X | 2024-11-21T14:03:25.277Z | 2024-11-22T14:19:21.239Z |
5558171 | 5558171 | 20241120054136_vIE3M | UK003X | 2024-11-21T14:02:38.981Z | 2024-11-22T14:19:21.187Z |
5558093 | 5558093 | 20241120053638_H7GHG | UK003X | 2024-11-21T14:02:29.850Z | 2024-11-22T14:19:21.177Z |
5558072 | 5558072 | 20241120053426_GQzDv | UK003X | 2024-11-21T14:02:26.718Z | 2024-11-22T14:19:21.173Z |
5545167 | 5545167 | 20241116015028_ddyfs | UK003X | 2024-11-17T14:03:56.582Z | 2024-11-22T14:23:36.958Z |
5543886 | 5543886 | 20241115041237_uuLdv | UK003X | 2024-11-16T14:07:36.659Z | 2024-11-22T14:24:02.276Z |
5543854 | 5543854 | 20241115035345_2Rqy2 | UK003X | 2024-11-16T14:07:27.886Z | 2024-11-22T14:24:01.962Z |
5543733 | 5543733 | 20241115031058_9nTMh | UK003X | 2024-11-16T14:07:06.465Z | 2024-11-22T14:24:00.996Z |
5543716 | 5543716 | 20241115030433_28ReI | UK003X | 2024-11-16T14:07:04.177Z | 2024-11-22T14:24:00.916Z |
5543650 | 5543650 | 20241115024254_rW6gI | UK003X | 2024-11-16T14:06:58.263Z | 2024-11-22T14:24:00.574Z |
5543643 | 5543643 | 20241115024147_dcgI8 | UK003X | 2024-11-16T14:06:57.947Z | 2024-11-22T14:24:00.553Z |
5543588 | 5543588 | 20241115022224_MK7E5 | UK003X | 2024-11-16T14:06:53.429Z | 2024-11-22T14:24:00.237Z |
5543578 | 5543578 | 20241115021646_46wcC | UK003X | 2024-11-16T14:06:49.058Z | 2024-11-22T14:24:00.124Z |
5543494 | 5543494 | 20241115014728_6SQi4 | UK003X | 2024-11-16T14:06:31.983Z | 2024-11-22T14:23:59.724Z |
5543468 | 5543468 | 20241115013715_97cn7 | UK003X | 2024-11-16T14:06:26.538Z | 2024-11-22T14:23:59.411Z |
5543453 | 5543453 | 20241115012859_dQ8jg | UK003X | 2024-11-16T14:06:23.773Z | 2024-11-22T14:23:59.371Z |
5543356 | 5543356 | 20241115003504_qX5qM | UK003X | 2024-11-16T14:06:08.730Z | 2024-11-22T14:23:58.376Z |
5543308 | 5543308 | 20241115000331_TL6kl | UK003X | 2024-11-16T14:06:04.330Z | 2024-11-22T14:23:58.041Z |
5543250 | 5543250 | 20241114232513_9FEm2 | UK003X | 2024-11-16T14:05:49.809Z | 2024-11-22T14:23:57.736Z |
5543246 | 5543246 | 20241114232047_e8L0E | UK003X | 2024-11-16T14:05:49.517Z | 2024-11-22T14:23:57.686Z |
5543228 | 5543228 | 20241114231722_fjfrZ | UK003X | 2024-11-16T14:05:48.192Z | 2024-11-22T14:23:57.630Z |
5543193 | 5543193 | 20241114224825_cujyV | UK003X | 2024-11-16T14:05:42.416Z | 2024-11-22T14:23:57.410Z |
5543174 | 5543174 | 20241114221848_jDirO | UK003X | 2024-11-16T14:05:39.627Z | 2024-11-22T14:23:57.316Z |
5543131 | 5543131 | 20241114212757_kQDJV | UK003X | 2024-11-16T14:05:35.423Z | 2024-11-22T14:23:57.063Z |
5537603 | 5537603 | 20241112235324_tScIs | UK003X | 2024-11-14T14:12:16.289Z | 2024-11-21T14:26:14.937Z |
5536467 | 5536467 | 20241112180849_WyCnM | UK003X | 2024-11-14T14:10:00.916Z | 2024-11-21T14:26:01.189Z |
5532811 | 5532811 | 20241113055734_VG8lK | UK003X | 2024-11-14T14:00:18.153Z | 2024-11-22T14:24:05.499Z |
5532776 | 5532776 | 20241113054951_7PnWu | UK003X | 2024-11-14T14:00:11.111Z | 2024-11-22T14:24:04.921Z |
5406584 | 5406584 | 20241027014709_n6cY3 | UK003X | 2024-10-29T12:14:22.810Z | 2024-11-04T14:28:55.890Z |
5406302 | 5406302 | 20241027012647_e1hSo | UK003X | 2024-10-29T12:14:01.490Z | 2024-11-04T14:28:55.422Z |
5406153 | 5406153 | 20241027011941_us5rC | UK003X | 2024-10-29T12:13:54.080Z | 2024-11-04T14:28:55.168Z |
5406076 | 5406076 | 20241027011419_PO33W | UK003X | 2024-10-29T12:13:50.498Z | 2024-11-04T14:28:54.974Z |
5405992 | 5405992 | 20241027011156_4fZZZ | UK003X | 2024-10-29T12:13:45.289Z | 2024-11-04T14:28:54.829Z |
5405879 | 5405879 | 20241027010546_fxSH3 | UK003X | 2024-10-29T12:13:27.709Z | 2024-11-04T14:28:54.559Z |
5405767 | 5405767 | 20241027005652_q7IMQ | UK003X | 2024-10-29T12:13:14.401Z | 2024-11-04T14:28:54.169Z |
5405290 | 5405290 | 20241027002707_xYNQt | UK003X | 2024-10-29T12:12:48.269Z | 2024-11-04T14:28:53.254Z |
5405253 | 5405253 | 20241027002547_lNBYz | UK003X | 2024-10-29T12:12:46.320Z | 2024-11-04T14:28:53.177Z |
5405042 | 5405042 | 20241027001005_sYxuw | UK003X | 2024-10-29T12:12:19.220Z | 2024-11-04T14:28:52.617Z |
5404676 | 5404676 | 20241026234422_CluJZ | UK003X | 2024-10-29T12:11:50.205Z | 2024-11-04T14:28:51.517Z |
5404610 | 5404610 | 20241026234047_H30uQ | UK003X | 2024-10-29T12:11:46.007Z | 2024-11-04T14:28:51.410Z |
5404400 | 5404400 | 20241026232310_huiNO | UK003X | 2024-10-29T12:11:18.993Z | 2024-11-04T14:28:50.851Z |
5404270 | 5404270 | 20241026231312_2dMb8 | UK003X | 2024-10-29T12:11:04.002Z | 2024-11-04T14:28:50.571Z |
5404169 | 5404169 | 20241026230351_UeIko | UK003X | 2024-10-29T12:10:57.482Z | 2024-11-04T14:28:50.393Z |
5404141 | 5404141 | 20241026230210_OO3ek | UK003X | 2024-10-29T12:10:55.886Z | 2024-11-04T14:28:50.356Z |
5404085 | 5404085 | 20241026225640_Mx9Bw | UK003X | 2024-10-29T12:10:52.615Z | 2024-11-04T14:28:50.320Z |
5404016 | 5404016 | 20241026225307_zY5cN | UK003X | 2024-10-29T12:10:48.284Z | 2024-11-04T14:28:50.242Z |
5403733 | 5403733 | 20241026222636_tlNb2 | UK003X | 2024-10-29T12:10:10.593Z | 2024-11-04T14:28:49.527Z |
5403666 | 5403666 | 20241026222240_C47Zp | UK003X | 2024-10-29T12:10:06.535Z | 2024-11-04T14:28:49.438Z |
5403432 | 5403432 | 20241026215616_gM3Z8 | UK003X | 2024-10-29T12:09:30.127Z | 2024-11-04T14:28:48.821Z |
5403275 | 5403275 | 20241026213540_6RNrh | UK003X | 2024-10-29T12:09:18.338Z | 2024-11-04T14:28:48.259Z |
5403074 | 5403074 | 20241026211518_74PqD | UK003X | 2024-10-29T12:08:52.434Z | 2024-11-04T14:28:47.680Z |
5403041 | 5403041 | 20241026210855_8qLR2 | UK003X | 2024-10-29T12:08:48.264Z | 2024-11-04T14:28:47.607Z |
5402909 | 5402909 | 20241026204325_eInjn | UK003X | 2024-10-29T12:08:35.112Z | 2024-11-04T14:28:46.934Z |
5402787 | 5402787 | 20241026202432_iupb7 | UK003X | 2024-10-29T12:08:08.247Z | 2024-11-04T14:28:46.528Z |
5402746 | 5402746 | 20241026201918_PXVF6 | UK003X | 2024-10-29T12:08:04.947Z | 2024-11-04T14:28:46.433Z |
5402533 | 5402533 | 20241026195313_LVKHv | UK003X | 2024-10-29T12:07:34.956Z | 2024-11-04T14:28:45.114Z |
5402484 | 5402484 | 20241026194441_2luwM | UK003X | 2024-10-29T12:07:23.496Z | 2024-11-04T14:28:44.772Z |
5402375 | 5402375 | 20241026192444_MS5ox | UK003X | 2024-10-29T12:07:07.006Z | 2024-11-04T14:28:44.162Z |
5402276 | 5402276 | 20241026190926_Fh2Md | UK003X | 2024-10-29T12:06:52.216Z | 2024-11-04T14:28:43.594Z |
5402237 | 5402237 | 20241026190525_zPSdF | UK003X | 2024-10-29T12:06:43.391Z | 2024-11-04T14:28:43.326Z |
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);