participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,052 rows where station_code = "UK000X" 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 |
---|---|---|---|---|---|
4716666 | 4716666 | 20240728014510_S2ku8 | UK000X | 2024-07-30T12:08:02.036Z | 2024-08-05T12:19:50.212Z |
4715144 | 4715144 | 20240728010135_jrMch | UK000X | 2024-07-30T12:05:56.684Z | 2024-08-05T12:19:42.965Z |
4713766 | 4713766 | 20240727234446_rJ1af | UK000X | 2024-07-30T12:03:22.669Z | 2024-08-05T12:19:34.466Z |
4713670 | 4713670 | 20240727233353_HAs23 | UK000X | 2024-07-30T12:03:10.223Z | 2024-08-05T12:19:32.781Z |
4713595 | 4713595 | 20240727232612_Sfpnc | UK000X | 2024-07-30T12:02:53.951Z | 2024-08-05T12:19:32.133Z |
4713346 | 4713346 | 20240727230435_LNPbn | UK000X | 2024-07-30T12:02:03.622Z | 2024-08-05T12:19:27.758Z |
4712908 | 4712908 | 20240727222108_ayDXv | UK000X | 2024-07-30T12:00:46.633Z | 2024-08-05T12:19:19.130Z |
4697288 | 4697288 | 20240727000117_rUGX4 | UK000X | 2024-07-28T12:04:08.856Z | 2024-08-04T12:19:13.888Z |
4697096 | 4697096 | 20240726235052_OuBra | UK000X | 2024-07-28T12:03:54.584Z | 2024-08-04T12:19:13.076Z |
4697043 | 4697043 | 20240726234457_nKVi9 | UK000X | 2024-07-28T12:03:50.368Z | 2024-08-04T12:19:12.822Z |
4696887 | 4696887 | 20240726233407_JgWew | UK000X | 2024-07-28T12:03:38.757Z | 2024-08-04T12:19:12.349Z |
4696737 | 4696737 | 20240726232709_icFf4 | UK000X | 2024-07-28T12:03:18.830Z | 2024-08-04T12:19:11.741Z |
4691444 | 4691444 | 20240726015304_phrzS | UK000X | 2024-07-27T12:05:34.283Z | 2024-08-03T12:21:20.194Z |
4691296 | 4691296 | 20240726013238_FTN3S | UK000X | 2024-07-27T12:05:14.791Z | 2024-08-03T12:21:18.992Z |
4691253 | 4691253 | 20240726013018_yI2Sy | UK000X | 2024-07-27T12:05:10.150Z | 2024-08-03T12:21:18.555Z |
4691125 | 4691125 | 20240726011158_Wwtm5 | UK000X | 2024-07-27T12:04:53.914Z | 2024-08-03T12:21:16.843Z |
4690951 | 4690951 | 20240726005653_uisBY | UK000X | 2024-07-27T12:04:24.136Z | 2024-08-03T12:21:14.746Z |
4672465 | 4672465 | 20240720013355_ybG17 | UK000X | 2024-07-21T12:04:02.355Z | 2024-07-28T12:14:56.124Z |
4663824 | 4663824 | 20240717005047_EikSH | UK000X | 2024-07-19T12:08:32.655Z | 2024-07-25T12:14:02.821Z |
4562416 | 4562416 | 20240705001217_JXOaf | UK000X | 2024-07-07T12:03:09.925Z | 2024-07-13T12:12:47.282Z |
4562177 | 4562177 | 20240704233615_u1ciU | UK000X | 2024-07-07T12:02:43.362Z | 2024-07-13T12:12:46.267Z |
4553706 | 4553706 | 20240704011846_Qx1Q1 | UK000X | 2024-07-06T12:02:31.025Z | 2024-07-12T12:08:53.756Z |
4553411 | 4553411 | 20240704004957_2BBzM | UK000X | 2024-07-06T12:01:57.902Z | 2024-07-12T12:08:53.497Z |
4553401 | 4553401 | 20240704004705_ZMHvE | UK000X | 2024-07-06T12:01:54.063Z | 2024-07-12T12:08:53.469Z |
4553385 | 4553385 | 20240704004647_jSO2d | UK000X | 2024-07-06T12:01:53.600Z | 2024-07-12T12:08:53.460Z |
4545270 | 4545270 | 20240704000309_rXSet | UK000X | 2024-07-05T12:01:40.154Z | 2024-07-12T12:08:52.875Z |
4545075 | 4545075 | 20240703234703_DjqxO | UK000X | 2024-07-05T12:01:30.340Z | 2024-07-12T12:08:52.676Z |
4545059 | 4545059 | 20240703234613_5kQdn | UK000X | 2024-07-05T12:01:29.980Z | 2024-07-12T12:08:52.675Z |
4492242 | 4492242 | 20240620234225_Pongs | UK000X | 2024-06-22T12:05:27.971Z | 2024-06-29T12:13:33.118Z |
4467582 | 4467582 | 20240616000628_aKMEg | UK000X | 2024-06-17T12:00:15.874Z | 2024-06-24T12:10:56.330Z |
4463838 | 4463838 | 20240614235758_fb7Eq | UK000X | 2024-06-16T12:00:38.879Z | 2024-06-23T12:11:31.791Z |
4428165 | 4428165 | 20240607004858_RLOaE | UK000X | 2024-06-08T12:05:48.629Z | 2024-06-15T12:16:57.695Z |
4421652 | 4421652 | 20240606005507_Hra9u | UK000X | 2024-06-07T12:06:53.718Z | 2024-06-14T12:08:23.757Z |
4421307 | 4421307 | 20240605233623_BHDdm | UK000X | 2024-06-07T12:06:10.684Z | 2024-06-14T12:08:21.310Z |
4421273 | 4421273 | 20240605233033_bkVCb | UK000X | 2024-06-07T12:06:06.861Z | 2024-06-14T12:08:20.959Z |
4416539 | 4416539 | 20240605002348_Y3swO | UK000X | 2024-06-06T12:06:32.295Z | 2024-06-13T12:08:32.658Z |
4400901 | 4400901 | 20240602010052_Tq1e9 | UK000X | 2024-06-03T12:06:39.379Z | 2024-06-10T12:06:47.280Z |
4400570 | 4400570 | 20240601235747_JXGM2 | UK000X | 2024-06-03T12:06:10.826Z | 2024-06-10T12:06:46.641Z |
4387294 | 4387294 | 20240527233435_4KkU7 | UK000X | 2024-05-29T12:07:41.027Z | 2024-06-05T12:18:05.425Z |
4373188 | 4373188 | 20240521014647_uJizo | UK000X | 2024-05-27T12:06:06.568Z | 2024-05-29T12:13:38.474Z |
4372997 | 4372997 | 20240521003432_0Pbkp | UK000X | 2024-05-27T12:05:45.346Z | 2024-05-29T12:13:32.929Z |
4372885 | 4372885 | 20240520233451_i5E36 | UK000X | 2024-05-27T12:05:30.477Z | 2024-05-29T12:13:29.537Z |
4243263 | 4243263 | 20240426234136_GAAkE | UK000X | 2024-04-28T12:08:54.620Z | 2024-05-05T12:21:44.073Z |
4243154 | 4243154 | 20240426225058_hhTKi | UK000X | 2024-04-28T12:08:34.655Z | 2024-05-05T12:21:42.503Z |
4243134 | 4243134 | 20240426223706_CaUpi | UK000X | 2024-04-28T12:08:30.090Z | 2024-05-05T12:21:42.195Z |
4239730 | 4239730 | 20240425231714_L3JTu | UK000X | 2024-04-27T12:07:05.367Z | 2024-05-04T12:21:22.253Z |
4219594 | 4219594 | 20240420021423_dEOpS | UK000X | 2024-04-21T12:02:01.010Z | 2024-04-28T12:21:18.618Z |
4218025 | 4218025 | 20240418211950_7bhKY | UK000X | 2024-04-20T12:13:42.071Z | 2024-04-26T12:17:43.257Z |
4217996 | 4217996 | 20240418211159_e3j7I | UK000X | 2024-04-20T12:13:36.609Z | 2024-04-26T12:17:42.960Z |
4214048 | 4214048 | 20240418033315_xY6SK | UK000X | 2024-04-20T12:04:17.137Z | 2024-04-26T12:16:57.951Z |
4213021 | 4213021 | 20240417214725_WJeSR | UK000X | 2024-04-20T12:00:36.057Z | 2024-04-26T12:16:25.669Z |
4201236 | 4201236 | 20240417014704_L44rd | UK000X | 2024-04-18T12:03:06.195Z | 2024-04-25T12:21:15.321Z |
4201161 | 4201161 | 20240417013327_TaetL | UK000X | 2024-04-18T12:02:57.544Z | 2024-04-25T12:21:13.798Z |
4190133 | 4190133 | 20240414233611_JzTer | UK000X | 2024-04-16T12:02:59.119Z | 2024-04-23T12:24:42.996Z |
4185147 | 4185147 | 20240414001317_SFvZ5 | UK000X | 2024-04-15T12:03:44.289Z | 2024-04-22T12:22:14.664Z |
4185059 | 4185059 | 20240413235014_mGA38 | UK000X | 2024-04-15T12:03:30.105Z | 2024-04-22T12:22:13.703Z |
4184725 | 4184725 | 20240413214200_hDd5a | UK000X | 2024-04-15T12:02:30.059Z | 2024-04-22T12:22:09.378Z |
4184648 | 4184648 | 20240413212119_sawAg | UK000X | 2024-04-15T12:02:17.100Z | 2024-04-22T12:22:08.716Z |
4171481 | 4171481 | 20240410022715_G5mji | UK000X | 2024-04-12T12:07:47.700Z | 2024-04-18T12:21:18.201Z |
4171433 | 4171433 | 20240410022153_S1VO4 | UK000X | 2024-04-12T12:07:44.774Z | 2024-04-18T12:21:18.089Z |
4170992 | 4170992 | 20240411030509_Vlr9i | UK000X | 2024-04-12T12:04:33.506Z | 2024-04-19T12:13:20.036Z |
4170949 | 4170949 | 20240411024402_SkWqW | UK000X | 2024-04-12T12:04:26.297Z | 2024-04-19T12:13:19.865Z |
4169176 | 4169176 | 20240410004702_PBXOo | UK000X | 2024-04-11T12:14:17.709Z | 2024-04-18T12:21:13.054Z |
4166479 | 4166479 | 20240409234337_sMrWQ | UK000X | 2024-04-11T12:05:40.277Z | 2024-04-18T12:21:09.945Z |
4165881 | 4165881 | 20240409214514_qiYtm | UK000X | 2024-04-11T12:04:32.051Z | 2024-04-18T12:21:04.908Z |
4165731 | 4165731 | 20240409211621_KDdzp | UK000X | 2024-04-11T12:04:04.882Z | 2024-04-18T12:21:03.192Z |
4157583 | 4157583 | 20240408021216_dpwot | UK000X | 2024-04-09T12:05:10.429Z | 2024-04-16T12:20:17.911Z |
4157517 | 4157517 | 20240408013600_4233s | UK000X | 2024-04-09T12:05:00.501Z | 2024-04-16T12:20:17.117Z |
4157506 | 4157506 | 20240408012914_Xtt2B | UK000X | 2024-04-09T12:04:59.248Z | 2024-04-16T12:20:17.062Z |
4157422 | 4157422 | 20240408004853_QH6mA | UK000X | 2024-04-09T12:04:38.959Z | 2024-04-16T12:20:16.416Z |
4157405 | 4157405 | 20240408003427_YC1E5 | UK000X | 2024-04-09T12:04:36.232Z | 2024-04-16T12:20:16.285Z |
4157280 | 4157280 | 20240407225913_B4OW7 | UK000X | 2024-04-09T12:04:12.330Z | 2024-04-16T12:20:14.917Z |
4157271 | 4157271 | 20240407225500_gYzqB | UK000X | 2024-04-09T12:04:10.117Z | 2024-04-16T12:20:14.831Z |
4157256 | 4157256 | 20240407225053_e5B9h | UK000X | 2024-04-09T12:04:08.163Z | 2024-04-16T12:20:14.777Z |
4157247 | 4157247 | 20240407224736_YvglI | UK000X | 2024-04-09T12:04:06.266Z | 2024-04-16T12:20:14.625Z |
4154955 | 4154955 | 20240407032815_TQCy3 | UK000X | 2024-04-08T12:07:26.984Z | 2024-04-15T12:19:17.920Z |
4154931 | 4154931 | 20240407031907_LsFb3 | UK000X | 2024-04-08T12:07:25.381Z | 2024-04-15T12:19:17.796Z |
4136177 | 4136177 | 20240402040451_tIolk | UK000X | 2024-04-03T12:06:48.144Z | 2024-04-10T12:18:02.583Z |
4124485 | 4124485 | 20240330032202_jWvZ6 | UK000X | 2024-03-31T12:08:09.244Z | 2024-04-07T12:24:24.773Z |
4123790 | 4123790 | 20240330012118_WsxBY | UK000X | 2024-03-31T12:07:15.756Z | 2024-04-07T12:24:21.629Z |
4122937 | 4122937 | 20240329213015_YySKg | UK000X | 2024-03-31T12:06:10.251Z | 2024-04-07T12:24:17.926Z |
4119153 | 4119153 | 20240327204042_3Uzrn | UK000X | 2024-03-30T12:11:28.684Z | 2024-04-05T12:18:40.374Z |
4105177 | 4105177 | 20240322044347_gwNMk | UK000X | 2024-03-23T12:08:03.541Z | 2024-03-30T12:18:10.412Z |
3878776 | 3878776 | 20240122063016_YRTF2 | UK000X | 2024-01-24T14:03:50.684Z | 2024-01-30T14:18:59.867Z |
3871236 | 3871236 | 20240121062537_Yr23u | UK000X | 2024-01-23T14:04:04.907Z | 2024-01-29T14:18:20.097Z |
3866146 | 3866146 | 20240119045027_GNrOO | UK000X | 2024-01-22T14:06:09.046Z | 2024-01-27T14:20:10.465Z |
3865556 | 3865556 | 20240119042549_e4reB | UK000X | 2024-01-22T14:05:40.868Z | 2024-01-27T14:20:06.342Z |
3865270 | 3865270 | 20240119041331_NeK5z | UK000X | 2024-01-22T14:05:24.129Z | 2024-01-27T14:20:03.187Z |
3862482 | 3862482 | 20240119013348_5pqGG | UK000X | 2024-01-22T14:02:07.375Z | 2024-01-27T14:19:02.773Z |
3861904 | 3861904 | 20240119001232_KaIah | UK000X | 2024-01-22T14:01:07.677Z | 2024-01-27T14:18:45.137Z |
3861769 | 3861769 | 20240119000603_0hpfT | UK000X | 2024-01-22T14:00:59.703Z | 2024-01-27T14:18:42.473Z |
3860883 | 3860883 | 20240118214749_8khPI | UK000X | 2024-01-21T14:18:46.912Z | 2024-01-26T14:22:58.815Z |
3860681 | 3860681 | 20240118211013_I1JQ3 | UK000X | 2024-01-21T14:18:38.275Z | 2024-01-26T14:22:56.750Z |
3859983 | 3859983 | 20240118180232_oup2t | UK000X | 2024-01-21T14:17:33.613Z | 2024-01-26T14:22:42.313Z |
3859937 | 3859937 | 20240118175721_e90xj | UK000X | 2024-01-21T14:17:31.615Z | 2024-01-26T14:22:41.502Z |
3857626 | 3857626 | 20240118065529_Jm3qY | UK000X | 2024-01-21T14:11:40.406Z | 2024-01-26T14:21:41.521Z |
3854560 | 3854560 | 20240117230633_QrZeB | UK000X | 2024-01-20T14:14:54.085Z | 2024-01-21T14:21:51.202Z |
3854169 | 3854169 | 20240117214753_s3AKN | UK000X | 2024-01-20T14:14:41.555Z | 2024-01-21T14:21:42.464Z |
3853573 | 3853573 | 20240117191210_PzMOz | UK000X | 2024-01-20T14:14:00.417Z | 2024-01-21T14:21:28.132Z |
3851141 | 3851141 | 20240117070643_xSik3 | UK000X | 2024-01-20T14:10:09.130Z | 2024-01-21T14:20:25.306Z |
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);