participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,285 rows where station_code = "UK0078" 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 |
---|---|---|---|---|---|
5564505 | 5564505 | 20241120030420_tcm7Q | UK0078 | 2024-11-21T14:17:42.904Z | 2024-11-22T14:21:32.877Z |
5564130 | 5564130 | 20241120023232_bHGjO | UK0078 | 2024-11-21T14:17:12.692Z | 2024-11-22T14:21:27.335Z |
5563096 | 5563096 | 20241120005228_SNP0q | UK0078 | 2024-11-21T14:15:36.564Z | 2024-11-22T14:21:09.587Z |
5562761 | 5562761 | 20241120000829_EK74G | UK0078 | 2024-11-21T14:15:20.443Z | 2024-11-22T14:21:03.512Z |
5562672 | 5562672 | 20241120000341_X7YVy | UK0078 | 2024-11-21T14:15:16.190Z | 2024-11-22T14:21:02.088Z |
5562257 | 5562257 | 20241119231727_KD0RT | UK0078 | 2024-11-21T14:14:38.470Z | 2024-11-22T14:20:54.641Z |
5562242 | 5562242 | 20241119231600_UtJs0 | UK0078 | 2024-11-21T14:14:35.908Z | 2024-11-22T14:20:54.544Z |
5561202 | 5561202 | 20241119190315_fEy3y | UK0078 | 2024-11-21T14:12:36.132Z | 2024-11-22T14:20:26.162Z |
5558131 | 5558131 | 20241120053912_RZl1O | UK0078 | 2024-11-21T14:02:34.067Z | 2024-11-22T14:19:21.182Z |
5545004 | 5545004 | 20241115214730_PhyKQ | UK0078 | 2024-11-17T14:03:35.447Z | 2024-11-22T14:23:35.082Z |
5532597 | 5532597 | 20241112054310_J3THw | UK0078 | 2024-11-13T14:17:02.538Z | 2024-11-20T14:26:25.049Z |
5531794 | 5531794 | 20241112040921_Cr2U7 | UK0078 | 2024-11-13T14:15:55.318Z | 2024-11-20T14:26:14.367Z |
5531052 | 5531052 | 20241112030941_DnhA8 | UK0078 | 2024-11-13T14:15:06.746Z | 2024-11-20T14:26:06.802Z |
5530890 | 5530890 | 20241112025759_jEHKG | UK0078 | 2024-11-13T14:14:47.944Z | 2024-11-20T14:26:04.652Z |
5530738 | 5530738 | 20241112024152_NikYY | UK0078 | 2024-11-13T14:14:33.758Z | 2024-11-20T14:26:02.981Z |
5530652 | 5530652 | 20241112023659_ou9RS | UK0078 | 2024-11-13T14:14:26.431Z | 2024-11-20T14:26:02.319Z |
5529684 | 5529684 | 20241112005416_foSVe | UK0078 | 2024-11-13T14:13:05.961Z | 2024-11-20T14:25:47.384Z |
5529531 | 5529531 | 20241112003021_936QE | UK0078 | 2024-11-13T14:12:56.604Z | 2024-11-20T14:25:46.058Z |
5529007 | 5529007 | 20241111231852_R2Wiv | UK0078 | 2024-11-13T14:11:57.401Z | 2024-11-20T14:25:38.533Z |
5528064 | 5528064 | 20241111192537_TyYAl | UK0078 | 2024-11-13T14:09:46.449Z | 2024-11-20T14:25:24.748Z |
5524225 | 5524225 | 20241111033600_jnmbM | UK0078 | 2024-11-12T14:16:48.654Z | 2024-11-19T14:22:18.971Z |
5439797 | 5439797 | 20241030203301_3RAUX | UK0078 | 2024-11-01T12:14:30.342Z | 2024-11-08T14:23:05.717Z |
5439790 | 5439790 | 20241030203300_HkYnL | UK0078 | 2024-11-01T12:14:29.395Z | 2024-11-08T14:23:05.704Z |
5439436 | 5439436 | 20241030195312_iWDnU | UK0078 | 2024-11-01T12:13:49.686Z | 2024-11-08T14:23:03.306Z |
5430573 | 5430573 | 20241028230606_MiIeE | UK0078 | 2024-10-31T12:18:37.764Z | 2024-11-06T14:27:20.607Z |
5418171 | 5418171 | 20241027200445_wisrL | UK0078 | 2024-10-30T12:15:02.656Z | 2024-11-05T14:27:09.414Z |
5417594 | 5417594 | 20241027185016_b34gl | UK0078 | 2024-10-30T12:13:57.505Z | 2024-11-05T14:27:07.699Z |
5410150 | 5410150 | 20241027045550_gD33j | UK0078 | 2024-10-29T12:17:48.973Z | 2024-11-04T14:29:03.900Z |
5409347 | 5409347 | 20241027041203_ktV9o | UK0078 | 2024-10-29T12:17:17.073Z | 2024-11-04T14:29:01.593Z |
5408762 | 5408762 | 20241027034205_8ZCpx | UK0078 | 2024-10-29T12:16:49.206Z | 2024-11-04T14:29:00.463Z |
5405863 | 5405863 | 20241027010344_I3rAV | UK0078 | 2024-10-29T12:13:26.129Z | 2024-11-04T14:28:54.545Z |
5405031 | 5405031 | 20241027000946_K376n | UK0078 | 2024-10-29T12:12:18.766Z | 2024-11-04T14:28:52.602Z |
5403599 | 5403599 | 20241026221520_kQWq2 | UK0078 | 2024-10-29T12:10:01.034Z | 2024-11-04T14:28:49.309Z |
5398491 | 5398491 | 20241026030316_TItz2 | UK0078 | 2024-10-28T12:19:19.996Z | 2024-11-03T14:27:36.614Z |
5398250 | 5398250 | 20241026023730_Nb3Ai | UK0078 | 2024-10-28T12:19:07.674Z | 2024-11-03T14:27:35.725Z |
5398099 | 5398099 | 20241026022704_Bn2mt | UK0078 | 2024-10-28T12:19:00.926Z | 2024-11-03T14:27:35.416Z |
5398066 | 5398066 | 20241026022155_PWO61 | UK0078 | 2024-10-28T12:18:59.455Z | 2024-11-03T14:27:35.262Z |
5397647 | 5397647 | 20241026014536_wwB4u | UK0078 | 2024-10-28T12:18:30.839Z | 2024-11-03T14:27:33.657Z |
5396923 | 5396923 | 20241026004645_A43DX | UK0078 | 2024-10-28T12:17:59.516Z | 2024-11-03T14:27:31.342Z |
5396807 | 5396807 | 20241026003550_bX4hR | UK0078 | 2024-10-28T12:17:56.167Z | 2024-11-03T14:27:30.951Z |
5396522 | 5396522 | 20241026000934_7LQKz | UK0078 | 2024-10-28T12:17:48.590Z | 2024-11-03T14:27:30.054Z |
5395781 | 5395781 | 20241025231016_db4D6 | UK0078 | 2024-10-28T12:16:50.894Z | 2024-11-03T14:27:26.690Z |
5395350 | 5395350 | 20241025223503_s22qS | UK0078 | 2024-10-28T12:16:10.464Z | 2024-11-03T14:27:25.190Z |
5395224 | 5395224 | 20241025222249_SuusY | UK0078 | 2024-10-28T12:16:01.811Z | 2024-11-03T14:27:24.331Z |
5376997 | 5376997 | 20241024042807_fIKpI | UK0078 | 2024-10-26T12:22:21.877Z | 2024-11-01T12:27:02.120Z |
5376869 | 5376869 | 20241024042013_nqbi4 | UK0078 | 2024-10-26T12:22:15.230Z | 2024-11-01T12:27:01.902Z |
5376768 | 5376768 | 20241024041440_FJ620 | UK0078 | 2024-10-26T12:22:12.965Z | 2024-11-01T12:27:01.847Z |
5376283 | 5376283 | 20241024034922_VSi2W | UK0078 | 2024-10-26T12:21:55.490Z | 2024-11-01T12:27:01.482Z |
5376207 | 5376207 | 20241024034529_Poqkj | UK0078 | 2024-10-26T12:21:53.429Z | 2024-11-01T12:27:01.458Z |
5372865 | 5372865 | 20241024011157_5mYti | UK0078 | 2024-10-26T12:19:46.291Z | 2024-11-01T12:26:58.006Z |
5364453 | 5364453 | 20241023222803_hdtGW | UK0078 | 2024-10-25T12:17:21.048Z | 2024-11-01T12:26:55.081Z |
5364199 | 5364199 | 20241023221319_MHeJw | UK0078 | 2024-10-25T12:17:12.010Z | 2024-11-01T12:26:54.602Z |
5364174 | 5364174 | 20241023221142_U2oRQ | UK0078 | 2024-10-25T12:17:11.382Z | 2024-11-01T12:26:54.593Z |
5362945 | 5362945 | 20241023201318_Oa8oi | UK0078 | 2024-10-25T12:15:18.764Z | 2024-11-01T12:26:52.533Z |
5362730 | 5362730 | 20241023195623_RJMiG | UK0078 | 2024-10-25T12:15:04.365Z | 2024-11-01T12:26:52.316Z |
5356259 | 5356259 | 20241023052626_YJL1E | UK0078 | 2024-10-24T12:21:56.791Z | 2024-10-31T12:30:11.186Z |
5350529 | 5350529 | 20241022215929_FDZXA | UK0078 | 2024-10-24T12:15:53.823Z | 2024-10-31T12:29:58.405Z |
5345030 | 5345030 | 20241022050729_xnK7J | UK0078 | 2024-10-23T12:19:03.152Z | 2024-10-30T12:26:52.124Z |
5344160 | 5344160 | 20241022040858_ypLxv | UK0078 | 2024-10-23T12:18:27.026Z | 2024-10-30T12:26:50.972Z |
5342472 | 5342472 | 20241022022814_f5Cyg | UK0078 | 2024-10-23T12:16:56.856Z | 2024-10-30T12:26:48.536Z |
5341027 | 5341027 | 20241022010941_pPCv3 | UK0078 | 2024-10-23T12:15:14.116Z | 2024-10-30T12:26:46.524Z |
5339793 | 5339793 | 20241021231708_Hsw4l | UK0078 | 2024-10-23T12:13:51.149Z | 2024-10-30T12:26:44.926Z |
5339573 | 5339573 | 20241021225441_iHZUs | UK0078 | 2024-10-23T12:13:20.961Z | 2024-10-30T12:26:44.455Z |
5339458 | 5339458 | 20241021224207_IuAjE | UK0078 | 2024-10-23T12:13:08.455Z | 2024-10-30T12:26:44.230Z |
5338854 | 5338854 | 20241021210433_fzxR3 | UK0078 | 2024-10-23T12:12:06.412Z | 2024-10-30T12:26:43.063Z |
5338783 | 5338783 | 20241021203752_RClmx | UK0078 | 2024-10-23T12:11:55.629Z | 2024-10-30T12:26:42.768Z |
5338746 | 5338746 | 20241021203030_5okxr | UK0078 | 2024-10-23T12:11:49.705Z | 2024-10-30T12:26:42.734Z |
5334465 | 5334465 | 20241021023752_SXgFe | UK0078 | 2024-10-22T12:16:54.024Z | 2024-10-29T12:26:35.215Z |
5334179 | 5334179 | 20241021020347_paubo | UK0078 | 2024-10-22T12:16:24.580Z | 2024-10-29T12:26:34.865Z |
5333848 | 5333848 | 20241021013220_ivxDJ | UK0078 | 2024-10-22T12:16:08.804Z | 2024-10-29T12:26:34.640Z |
5333441 | 5333441 | 20241021003439_OvWLb | UK0078 | 2024-10-22T12:15:20.437Z | 2024-10-29T12:26:34.352Z |
5332607 | 5332607 | 20241020210602_UbCs2 | UK0078 | 2024-10-22T12:13:44.845Z | 2024-10-29T12:26:33.601Z |
5332522 | 5332522 | 20241020202849_JUeBh | UK0078 | 2024-10-22T12:13:23.783Z | 2024-10-29T12:26:33.470Z |
5321430 | 5321430 | 20241018045032_KRosb | UK0078 | 2024-10-19T12:07:27.278Z | 2024-10-26T12:27:56.827Z |
5321386 | 5321386 | 20241018044502_LyR5M | UK0078 | 2024-10-19T12:07:20.375Z | 2024-10-26T12:27:56.606Z |
5321235 | 5321235 | 20241018041400_NEl9N | UK0078 | 2024-10-19T12:07:03.055Z | 2024-10-26T12:27:56.361Z |
5321219 | 5321219 | 20241018041058_mq90k | UK0078 | 2024-10-19T12:07:01.949Z | 2024-10-26T12:27:56.351Z |
5321162 | 5321162 | 20241018035830_ccUGF | UK0078 | 2024-10-19T12:06:58.426Z | 2024-10-26T12:27:56.261Z |
5319809 | 5319809 | 20241017210533_bcDd0 | UK0078 | 2024-10-19T12:03:46.739Z | 2024-10-26T12:27:53.103Z |
5319660 | 5319660 | 20241017193953_NOglZ | UK0078 | 2024-10-19T12:03:29.824Z | 2024-10-26T12:27:52.817Z |
5318560 | 5318560 | 20241017035629_cbZzt | UK0078 | 2024-10-18T12:04:00.644Z | 2024-10-25T12:24:36.270Z |
5318550 | 5318550 | 20241017035327_n52Zh | UK0078 | 2024-10-18T12:03:59.507Z | 2024-10-25T12:24:36.202Z |
5318416 | 5318416 | 20241017031502_cdhIS | UK0078 | 2024-10-18T12:03:45.637Z | 2024-10-25T12:24:35.335Z |
5304221 | 5304221 | 20241013042909_C9c2o | UK0078 | 2024-10-14T12:17:45.024Z | 2024-10-21T12:24:24.439Z |
5302285 | 5302285 | 20241013004743_JDcth | UK0078 | 2024-10-14T12:16:05.553Z | 2024-10-21T12:24:06.258Z |
5301857 | 5301857 | 20241013001132_tavQy | UK0078 | 2024-10-14T12:15:40.963Z | 2024-10-21T12:24:02.619Z |
5301853 | 5301853 | 20241013001045_3qt82 | UK0078 | 2024-10-14T12:15:40.815Z | 2024-10-21T12:24:02.551Z |
5301707 | 5301707 | 20241012235618_No1vi | UK0078 | 2024-10-14T12:15:35.290Z | 2024-10-21T12:24:00.232Z |
5300871 | 5300871 | 20241012220343_JJvDJ | UK0078 | 2024-10-14T12:14:34.543Z | 2024-10-21T12:23:53.582Z |
5300822 | 5300822 | 20241012215649_WSrJY | UK0078 | 2024-10-14T12:14:28.941Z | 2024-10-21T12:23:52.753Z |
5300776 | 5300776 | 20241012214013_3PlE9 | UK0078 | 2024-10-14T12:14:26.563Z | 2024-10-21T12:23:52.448Z |
5300579 | 5300579 | 20241012205628_RPNWB | UK0078 | 2024-10-14T12:14:16.822Z | 2024-10-21T12:23:50.008Z |
5299585 | 5299585 | 20241012190813_2ysi9 | UK0078 | 2024-10-14T12:12:34.434Z | 2024-10-21T12:23:41.926Z |
5299241 | 5299241 | 20241012182312_csU2n | UK0078 | 2024-10-14T12:12:03.729Z | 2024-10-21T12:23:36.130Z |
5292128 | 5292128 | 20241011224225_a2KUG | UK0078 | 2024-10-13T12:15:43.908Z | 2024-10-20T12:24:40.552Z |
5291304 | 5291304 | 20241011203323_fJbYh | UK0078 | 2024-10-13T12:14:15.886Z | 2024-10-20T12:24:29.119Z |
5284587 | 5284587 | 20241011025520_c34iu | UK0078 | 2024-10-12T12:17:28.575Z | 2024-10-19T12:27:56.430Z |
5282798 | 5282798 | 20241010234457_NMXrq | UK0078 | 2024-10-12T12:16:03.982Z | 2024-10-19T12:27:46.599Z |
5282790 | 5282790 | 20241010233923_QTnB8 | UK0078 | 2024-10-12T12:16:03.477Z | 2024-10-19T12:27:46.597Z |
5282476 | 5282476 | 20241010215602_P57J1 | UK0078 | 2024-10-12T12:15:36.081Z | 2024-10-19T12:27:44.073Z |
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);