participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,265 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 |
---|---|---|---|---|---|
5524225 | 5524225 | 20241111033600_jnmbM | UK0078 | 2024-11-12T14:16:48.654Z | 2024-11-12T14:18:08.521Z |
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 |
5282419 | 5282419 | 20241010214501_vwXI9 | UK0078 | 2024-10-12T12:15:32.354Z | 2024-10-19T12:27:43.724Z |
5281890 | 5281890 | 20241010195036_6zVr2 | UK0078 | 2024-10-12T12:14:54.933Z | 2024-10-19T12:27:38.191Z |
5276587 | 5276587 | 20241011045117_BTja0 | UK0078 | 2024-10-12T12:01:23.721Z | 2024-10-20T12:23:11.908Z |
5263246 | 5263246 | 20241009035143_raBXr | UK0078 | 2024-10-10T12:00:20.421Z | 2024-10-18T12:21:31.372Z |
5262826 | 5262826 | 20241008022833_WEEfw | UK0078 | 2024-10-09T12:16:18.189Z | 2024-10-16T12:21:20.304Z |
5255357 | 5255357 | 20241008041412_1S33o | UK0078 | 2024-10-09T12:01:04.368Z | 2024-10-17T12:19:51.909Z |
5255168 | 5255168 | 20241008034727_HvswU | UK0078 | 2024-10-09T12:00:44.622Z | 2024-10-17T12:19:51.273Z |
5255103 | 5255103 | 20241008033953_WYNYd | UK0078 | 2024-10-09T12:00:36.117Z | 2024-10-17T12:19:51.015Z |
5255069 | 5255069 | 20241008033718_sLo4h | UK0078 | 2024-10-09T12:00:32.198Z | 2024-10-17T12:19:50.907Z |
5254426 | 5254426 | 20241007021013_nGrGk | UK0078 | 2024-10-08T12:14:25.010Z | 2024-10-15T12:29:15.355Z |
5248135 | 5248135 | 20241007035958_U4g2L | UK0078 | 2024-10-08T12:01:38.653Z | 2024-10-16T12:20:58.386Z |
5247797 | 5247797 | 20241007031944_YwRpa | UK0078 | 2024-10-08T12:00:41.905Z | 2024-10-16T12:20:56.977Z |
5246854 | 5246854 | 20241005012032_8MYVO | UK0078 | 2024-10-07T12:18:47.475Z | 2024-10-13T12:26:25.354Z |
5244754 | 5244754 | 20241005210200_3MJhy | UK0078 | 2024-10-07T12:15:16.116Z | 2024-10-14T12:24:34.231Z |
5244659 | 5244659 | 20241005204302_a9oBb | UK0078 | 2024-10-07T12:15:07.092Z | 2024-10-14T12:24:34.117Z |
5244213 | 5244213 | 20241005193102_Xl8kf | UK0078 | 2024-10-07T12:14:35.507Z | 2024-10-14T12:24:33.057Z |
5244102 | 5244102 | 20241005191859_wPeoH | UK0078 | 2024-10-07T12:14:29.076Z | 2024-10-14T12:24:32.689Z |
5236165 | 5236165 | 20241005002629_im0rj | UK0078 | 2024-10-06T12:17:14.415Z | 2024-10-13T12:26:24.740Z |
5226537 | 5226537 | 20241004002118_sylss | UK0078 | 2024-10-05T12:20:47.430Z | 2024-10-12T12:25:11.823Z |
5226514 | 5226514 | 20241004001855_2cUMM | UK0078 | 2024-10-05T12:20:46.555Z | 2024-10-12T12:25:11.796Z |
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);