participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,910 rows where station_code = "UK002S" 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 |
---|---|---|---|---|---|
3933664 | 3933664 | 20240201034507_JfSCp | UK002S | 2024-02-08T14:19:25.479Z | 2024-02-09T14:20:15.016Z |
3922177 | 3922177 | 20240205055312_7rImN | UK002S | 2024-02-06T14:06:47.738Z | 2024-02-13T14:27:14.918Z |
3920864 | 3920864 | 20240204204758_fTETr | UK002S | 2024-02-06T14:02:51.335Z | 2024-02-13T14:26:43.781Z |
3911628 | 3911628 | 20240202193230_1G1zb | UK002S | 2024-02-04T14:00:53.725Z | 2024-02-11T14:22:36.517Z |
3906750 | 3906750 | 20240201062440_1EBKH | UK002S | 2024-02-02T14:06:28.466Z | 2024-02-09T14:20:28.710Z |
3906687 | 3906687 | 20240201060132_KKV3K | UK002S | 2024-02-02T14:06:22.942Z | 2024-02-09T14:20:27.722Z |
3906487 | 3906487 | 20240201050951_AJrMs | UK002S | 2024-02-02T14:05:52.502Z | 2024-02-09T14:20:23.934Z |
3906460 | 3906460 | 20240201050633_LOq2G | UK002S | 2024-02-02T14:05:50.678Z | 2024-02-09T14:20:23.729Z |
3906412 | 3906412 | 20240201045815_2Jw9A | UK002S | 2024-02-02T14:05:47.029Z | 2024-02-09T14:20:23.163Z |
3906306 | 3906306 | 20240201043321_JY3k9 | UK002S | 2024-02-02T14:05:38.762Z | 2024-02-09T14:20:20.421Z |
3905866 | 3905866 | 20240201023214_jhXYG | UK002S | 2024-02-02T14:04:23.664Z | 2024-02-09T14:20:09.458Z |
3905813 | 3905813 | 20240201021754_IbqQU | UK002S | 2024-02-02T14:04:16.576Z | 2024-02-09T14:20:08.140Z |
3905538 | 3905538 | 20240201004253_ihBv8 | UK002S | 2024-02-02T14:03:24.640Z | 2024-02-09T14:20:02.931Z |
3901864 | 3901864 | 20240131031104_Fe3tf | UK002S | 2024-02-01T14:04:35.265Z | 2024-02-08T14:20:19.118Z |
3901765 | 3901765 | 20240131024655_NoTi9 | UK002S | 2024-02-01T14:04:18.270Z | 2024-02-08T14:20:18.347Z |
3901727 | 3901727 | 20240131023220_Q3o30 | UK002S | 2024-02-01T14:04:09.942Z | 2024-02-08T14:20:17.347Z |
3901531 | 3901531 | 20240131011915_ZO7Zs | UK002S | 2024-02-01T14:03:38.265Z | 2024-02-08T14:20:14.715Z |
3901472 | 3901472 | 20240131004807_GY7T1 | UK002S | 2024-02-01T14:03:30.022Z | 2024-02-08T14:20:13.588Z |
3900510 | 3900510 | 20240130185718_F8upf | UK002S | 2024-02-01T14:00:42.720Z | 2024-02-08T14:20:00.781Z |
3887118 | 3887118 | 20240126063610_2vG00 | UK002S | 2024-01-27T14:01:50.273Z | 2024-02-03T14:24:26.242Z |
3887036 | 3887036 | 20240126061522_S6Wt2 | UK002S | 2024-01-27T14:01:38.541Z | 2024-02-03T14:24:24.577Z |
3880456 | 3880456 | 20240123032413_VXFHO | UK002S | 2024-01-25T14:02:05.005Z | 2024-01-31T14:18:04.579Z |
3880352 | 3880352 | 20240123024917_u4OFx | UK002S | 2024-01-25T14:01:47.091Z | 2024-01-31T14:18:02.717Z |
3879925 | 3879925 | 20240123004332_J2bAJ | UK002S | 2024-01-25T14:00:59.881Z | 2024-01-31T14:17:52.567Z |
3879864 | 3879864 | 20240122233235_eIYr3 | UK002S | 2024-01-25T14:00:48.503Z | 2024-01-31T14:17:50.589Z |
3878799 | 3878799 | 20240122063419_RKnna | UK002S | 2024-01-24T14:03:51.954Z | 2024-01-30T14:19:00.139Z |
3878437 | 3878437 | 20240122053533_tVnYi | UK002S | 2024-01-24T14:03:20.590Z | 2024-01-30T14:18:54.410Z |
3878406 | 3878406 | 20240122053120_Uif4t | UK002S | 2024-01-24T14:03:18.068Z | 2024-01-30T14:18:54.076Z |
3877058 | 3877058 | 20240119052418_Tei6I | UK002S | 2024-01-23T14:15:31.293Z | 2024-01-27T14:20:15.899Z |
3871276 | 3871276 | 20240121064437_FV3v3 | UK002S | 2024-01-23T14:04:11.977Z | 2024-01-29T14:18:20.707Z |
3871166 | 3871166 | 20240121053830_wACG6 | UK002S | 2024-01-23T14:03:47.005Z | 2024-01-29T14:18:17.767Z |
3871153 | 3871153 | 20240121053235_N9Kio | UK002S | 2024-01-23T14:03:44.794Z | 2024-01-29T14:18:17.446Z |
3868008 | 3868008 | 20240119064110_1Y8FY | UK002S | 2024-01-22T14:07:56.808Z | 2024-01-27T14:20:30.714Z |
3867760 | 3867760 | 20240119062644_PGLT8 | UK002S | 2024-01-22T14:07:44.270Z | 2024-01-27T14:20:26.090Z |
3867388 | 3867388 | 20240119060725_TwFE6 | UK002S | 2024-01-22T14:07:33.761Z | 2024-01-27T14:20:22.595Z |
3866975 | 3866975 | 20240119053959_mxhd3 | UK002S | 2024-01-22T14:07:01.246Z | 2024-01-27T14:20:19.308Z |
3866712 | 3866712 | 20240119052418_55DUv | UK002S | 2024-01-22T14:06:47.587Z | 2024-01-22T14:15:44.782Z |
3866482 | 3866482 | 20240119051036_z1UN2 | UK002S | 2024-01-22T14:06:36.067Z | 2024-01-27T14:20:13.701Z |
3866465 | 3866465 | 20240119050958_39jTD | UK002S | 2024-01-22T14:06:32.813Z | 2024-01-27T14:20:13.160Z |
3866098 | 3866098 | 20240119044946_Mlpb8 | UK002S | 2024-01-22T14:06:07.653Z | 2024-01-27T14:20:10.135Z |
3865913 | 3865913 | 20240119044041_aJR91 | UK002S | 2024-01-22T14:05:59.920Z | 2024-01-27T14:20:08.589Z |
3865808 | 3865808 | 20240119043718_k8y2N | UK002S | 2024-01-22T14:05:57.007Z | 2024-01-27T14:20:08.025Z |
3865482 | 3865482 | 20240119042408_YA3Uj | UK002S | 2024-01-22T14:05:36.492Z | 2024-01-27T14:20:05.961Z |
3864863 | 3864863 | 20240119035531_eQrkf | UK002S | 2024-01-22T14:05:01.154Z | 2024-01-27T14:19:57.199Z |
3864670 | 3864670 | 20240119034438_lxyOL | UK002S | 2024-01-22T14:04:45.997Z | 2024-01-27T14:19:52.041Z |
3864464 | 3864464 | 20240119033557_2oQpy | UK002S | 2024-01-22T14:04:38.213Z | 2024-01-27T14:19:47.928Z |
3864393 | 3864393 | 20240119033429_eMDfF | UK002S | 2024-01-22T14:04:36.471Z | 2024-01-27T14:19:46.772Z |
3864257 | 3864257 | 20240119032843_ob055 | UK002S | 2024-01-22T14:04:30.001Z | 2024-01-27T14:19:44.195Z |
3864237 | 3864237 | 20240119032654_IYPvZ | UK002S | 2024-01-22T14:04:27.790Z | 2024-01-27T14:19:43.010Z |
3864215 | 3864215 | 20240119032629_4V3rT | UK002S | 2024-01-22T14:04:27.075Z | 2024-01-27T14:19:42.628Z |
3864182 | 3864182 | 20240119032506_B7DUX | UK002S | 2024-01-22T14:04:25.061Z | 2024-01-27T14:19:41.939Z |
3863980 | 3863980 | 20240119031728_rXh1i | UK002S | 2024-01-22T14:04:11.864Z | 2024-01-27T14:19:39.685Z |
3863792 | 3863792 | 20240119030822_y1b2d | UK002S | 2024-01-22T14:04:00.787Z | 2024-01-27T14:19:35.862Z |
3863516 | 3863516 | 20240119025217_be56i | UK002S | 2024-01-22T14:03:44.054Z | 2024-01-27T14:19:30.761Z |
3862500 | 3862500 | 20240119013600_m3YgA | UK002S | 2024-01-22T14:02:12.933Z | 2024-01-27T14:19:03.843Z |
3862146 | 3862146 | 20240119004411_5g22D | UK002S | 2024-01-22T14:01:29.117Z | 2024-01-27T14:18:50.721Z |
3862123 | 3862123 | 20240119004055_pi76Y | UK002S | 2024-01-22T14:01:23.946Z | 2024-01-27T14:18:49.925Z |
3862086 | 3862086 | 20240119003719_t3dCt | UK002S | 2024-01-22T14:01:21.719Z | 2024-01-27T14:18:49.035Z |
3861485 | 3861485 | 20240118232656_BCvm8 | UK002S | 2024-01-22T14:00:31.881Z | 2024-01-27T14:18:38.703Z |
3861167 | 3861167 | 20240118224224_Qnupf | UK002S | 2024-01-21T14:19:12.821Z | 2024-01-26T14:23:03.610Z |
3861111 | 3861111 | 20240118223123_tFNyE | UK002S | 2024-01-21T14:19:10.205Z | 2024-01-26T14:23:02.850Z |
3861064 | 3861064 | 20240118222241_ZS2EY | UK002S | 2024-01-21T14:19:05.646Z | 2024-01-26T14:23:02.228Z |
3860761 | 3860761 | 20240118213014_8Ab3P | UK002S | 2024-01-21T14:18:40.854Z | 2024-01-26T14:22:57.580Z |
3860575 | 3860575 | 20240118203730_qcRlG | UK002S | 2024-01-21T14:18:31.084Z | 2024-01-26T14:22:55.873Z |
3857649 | 3857649 | 20240118070502_3XIr5 | UK002S | 2024-01-21T14:11:44.947Z | 2024-01-26T14:21:42.093Z |
3857298 | 3857298 | 20240118063619_wIQeA | UK002S | 2024-01-21T14:11:11.950Z | 2024-01-26T14:21:38.335Z |
3856927 | 3856927 | 20240118060312_UMmID | UK002S | 2024-01-21T14:10:11.909Z | 2024-01-26T14:21:30.630Z |
3856553 | 3856553 | 20240118054445_LRGii | UK002S | 2024-01-21T14:09:17.604Z | 2024-01-26T14:21:24.881Z |
3856320 | 3856320 | 20240118053219_tCNUe | UK002S | 2024-01-21T14:08:45.752Z | 2024-01-26T14:21:22.384Z |
3855403 | 3855403 | 20240118045129_uP2UN | UK002S | 2024-01-21T14:06:11.816Z | 2024-01-26T14:21:15.620Z |
3855316 | 3855316 | 20240118044836_FxnPB | UK002S | 2024-01-21T14:05:54.899Z | 2024-01-26T14:21:15.103Z |
3855183 | 3855183 | 20240118043847_dpEYF | UK002S | 2024-01-21T14:05:09.520Z | 2024-01-26T14:21:13.569Z |
3854753 | 3854753 | 20240118040855_M4ehq | UK002S | 2024-01-21T14:04:15.957Z | 2024-01-26T14:21:09.757Z |
3854733 | 3854733 | 20240118040833_Y6Zou | UK002S | 2024-01-21T14:04:15.376Z | 2024-01-26T14:21:09.715Z |
3854625 | 3854625 | 20240116232457_BkOOZ | UK002S | 2024-01-20T14:17:55.521Z | 2024-01-25T14:22:39.147Z |
3854193 | 3854193 | 20240117220023_mQd3E | UK002S | 2024-01-20T14:14:43.030Z | 2024-01-21T14:21:43.128Z |
3854152 | 3854152 | 20240117214038_ZDgaT | UK002S | 2024-01-20T14:14:40.694Z | 2024-01-21T14:21:42.108Z |
3854143 | 3854143 | 20240117213557_IuSOL | UK002S | 2024-01-20T14:14:40.029Z | 2024-01-21T14:21:41.712Z |
3853971 | 3853971 | 20240117210629_b4VdG | UK002S | 2024-01-20T14:14:29.801Z | 2024-01-21T14:21:39.750Z |
3853817 | 3853817 | 20240117202957_qjHbF | UK002S | 2024-01-20T14:14:21.493Z | 2024-01-21T14:21:36.670Z |
3849794 | 3849794 | 20240117025310_g8xW6 | UK002S | 2024-01-20T14:07:19.739Z | 2024-01-21T14:19:31.849Z |
3849315 | 3849315 | 20240116234920_M85Vv | UK002S | 2024-01-20T14:06:09.470Z | 2024-01-21T14:19:15.980Z |
3849179 | 3849179 | 20240118035937_MXVSD | UK002S | 2024-01-20T14:05:47.967Z | 2024-01-26T14:21:08.411Z |
3848524 | 3848524 | 20240118031551_k0QSY | UK002S | 2024-01-20T14:04:54.031Z | 2024-01-26T14:21:03.239Z |
3847683 | 3847683 | 20240118022420_SQ5aD | UK002S | 2024-01-20T14:03:44.864Z | 2024-01-26T14:20:56.037Z |
3847667 | 3847667 | 20240118022304_TIR8w | UK002S | 2024-01-20T14:03:44.575Z | 2024-01-26T14:20:55.976Z |
3847651 | 3847651 | 20240118022258_78H0H | UK002S | 2024-01-20T14:03:43.705Z | 2024-01-26T14:20:55.894Z |
3847553 | 3847553 | 20240118021604_OehGI | UK002S | 2024-01-20T14:03:27.679Z | 2024-01-26T14:20:54.808Z |
3847521 | 3847521 | 20240118021320_IYyA2 | UK002S | 2024-01-20T14:03:21.594Z | 2024-01-26T14:20:54.238Z |
3847469 | 3847469 | 20240118021223_Df5BL | UK002S | 2024-01-20T14:03:20.330Z | 2024-01-26T14:20:53.929Z |
3847440 | 3847440 | 20240118020903_UDF0v | UK002S | 2024-01-20T14:03:17.881Z | 2024-01-26T14:20:53.498Z |
3847256 | 3847256 | 20240118014656_WgnMq | UK002S | 2024-01-20T14:02:50.153Z | 2024-01-26T14:20:48.454Z |
3847143 | 3847143 | 20240118013715_1Jchs | UK002S | 2024-01-20T14:02:43.249Z | 2024-01-26T14:20:46.802Z |
3846526 | 3846526 | 20240118005241_0rJ36 | UK002S | 2024-01-20T14:01:47.910Z | 2024-01-26T14:20:34.903Z |
3845793 | 3845793 | 20240117233957_FY2IE | UK002S | 2024-01-20T14:00:29.894Z | 2024-01-26T14:20:22.203Z |
3845511 | 3845511 | 20240116231123_aljGj | UK002S | 2024-01-19T14:14:12.279Z | 2024-01-25T14:22:37.857Z |
3845166 | 3845166 | 20240116202740_sHHk8 | UK002S | 2024-01-19T14:13:40.688Z | 2024-01-25T14:22:25.476Z |
3845081 | 3845081 | 20240116195138_vWeVG | UK002S | 2024-01-19T14:13:32.296Z | 2024-01-25T14:22:23.439Z |
3839967 | 3839967 | 20240116060943_l3QAO | UK002S | 2024-01-19T14:04:06.140Z | 2024-01-25T14:21:28.604Z |
3838211 | 3838211 | 20240115224353_OvASg | UK002S | 2024-01-18T14:15:10.077Z | 2024-01-24T14:19:18.138Z |
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);