participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,792 rows where station_code = "UK0021" 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 |
---|---|---|---|---|---|
5522987 | 5522987 | 20241110232553_IiCx6 | UK0021 | 2024-11-12T14:14:36.337Z | 2024-11-12T14:18:07.987Z |
5454873 | 5454873 | 20241031053726_wXM6h | UK0021 | 2024-11-02T12:23:25.648Z | 2024-11-08T14:23:26.075Z |
5454737 | 5454737 | 20241031050500_snRO7 | UK0021 | 2024-11-02T12:23:19.516Z | 2024-11-08T14:23:25.424Z |
5452949 | 5452949 | 20241101054003_bbWVg | UK0021 | 2024-11-02T12:19:36.554Z | 2024-11-09T14:24:36.872Z |
5452910 | 5452910 | 20241101052245_jl134 | UK0021 | 2024-11-02T12:19:33.126Z | 2024-11-09T14:24:35.903Z |
5452886 | 5452886 | 20241101051531_axaJO | UK0021 | 2024-11-02T12:19:31.823Z | 2024-11-09T14:24:35.621Z |
5452801 | 5452801 | 20241101044003_8c103 | UK0021 | 2024-11-02T12:19:23.221Z | 2024-11-09T14:24:34.079Z |
5452619 | 5452619 | 20241101035404_Ngj4b | UK0021 | 2024-11-02T12:19:05.772Z | 2024-11-09T14:24:32.121Z |
5452185 | 5452185 | 20241101022004_o9au3 | UK0021 | 2024-11-02T12:18:24.830Z | 2024-11-09T14:24:28.732Z |
5451991 | 5451991 | 20241101014214_o2cky | UK0021 | 2024-11-02T12:18:09.868Z | 2024-11-09T14:24:27.526Z |
5444149 | 5444149 | 20241031005305_TVn3d | UK0021 | 2024-11-01T12:21:07.852Z | 2024-11-08T14:23:14.026Z |
5444107 | 5444107 | 20241031004829_rhEIx | UK0021 | 2024-11-01T12:21:06.148Z | 2024-11-08T14:23:13.977Z |
5443891 | 5443891 | 20241031002552_F3uSb | UK0021 | 2024-11-01T12:20:55.866Z | 2024-11-08T14:23:13.032Z |
5443690 | 5443690 | 20241031000525_nXwxN | UK0021 | 2024-11-01T12:20:46.488Z | 2024-11-08T14:23:11.997Z |
5440650 | 5440650 | 20241030224044_Z0Yo1 | UK0021 | 2024-11-01T12:15:41.922Z | 2024-11-08T14:23:10.209Z |
5440168 | 5440168 | 20241030213458_HYUD6 | UK0021 | 2024-11-01T12:14:55.711Z | 2024-11-08T14:23:07.632Z |
5432995 | 5432995 | 20241029053857_6mRdw | UK0021 | 2024-10-31T12:21:42.430Z | 2024-11-06T14:27:29.499Z |
5432953 | 5432953 | 20241029052507_3nkkl | UK0021 | 2024-10-31T12:21:40.927Z | 2024-11-06T14:27:29.384Z |
5432939 | 5432939 | 20241029052043_dbTmn | UK0021 | 2024-10-31T12:21:40.616Z | 2024-11-06T14:27:29.357Z |
5432806 | 5432806 | 20241029044145_TUeLS | UK0021 | 2024-10-31T12:21:35.724Z | 2024-11-06T14:27:28.769Z |
5432760 | 5432760 | 20241029043347_TblI5 | UK0021 | 2024-10-31T12:21:34.000Z | 2024-11-06T14:27:28.647Z |
5432620 | 5432620 | 20241029040459_4YUnB | UK0021 | 2024-10-31T12:21:28.977Z | 2024-11-06T14:27:28.249Z |
5432386 | 5432386 | 20241029032504_Xkoph | UK0021 | 2024-10-31T12:21:20.430Z | 2024-11-06T14:27:26.791Z |
5431936 | 5431936 | 20241029021750_StPdA | UK0021 | 2024-10-31T12:20:51.236Z | 2024-11-06T14:27:25.517Z |
5431862 | 5431862 | 20241029020801_bANOy | UK0021 | 2024-10-31T12:20:45.303Z | 2024-11-06T14:27:25.136Z |
5431832 | 5431832 | 20241029020239_aubsc | UK0021 | 2024-10-31T12:20:42.936Z | 2024-11-06T14:27:25.030Z |
5431420 | 5431420 | 20241029010913_jPlpb | UK0021 | 2024-10-31T12:20:06.896Z | 2024-11-06T14:27:23.594Z |
5431373 | 5431373 | 20241029010154_qDyQx | UK0021 | 2024-10-31T12:20:03.128Z | 2024-11-06T14:27:23.376Z |
5431358 | 5431358 | 20241029010056_VfAnq | UK0021 | 2024-10-31T12:20:01.862Z | 2024-11-06T14:27:23.357Z |
5421075 | 5421075 | 20241028042854_soFKn | UK0021 | 2024-10-30T12:19:35.017Z | 2024-11-05T14:27:17.266Z |
5407574 | 5407574 | 20241027024232_Dr9SH | UK0021 | 2024-10-29T12:15:30.259Z | 2024-11-04T14:28:57.899Z |
5407340 | 5407340 | 20241027023200_UU4kf | UK0021 | 2024-10-29T12:15:21.440Z | 2024-11-04T14:28:57.351Z |
5407267 | 5407267 | 20241027022903_412Uj | UK0021 | 2024-10-29T12:15:19.265Z | 2024-11-04T14:28:57.285Z |
5407163 | 5407163 | 20241027022434_c23ut | UK0021 | 2024-10-29T12:15:15.487Z | 2024-11-04T14:28:57.130Z |
5406250 | 5406250 | 20241027012357_3kuD2 | UK0021 | 2024-10-29T12:13:59.470Z | 2024-11-04T14:28:55.258Z |
5406046 | 5406046 | 20241027011309_Rq9zL | UK0021 | 2024-10-29T12:13:49.103Z | 2024-11-04T14:28:54.901Z |
5405709 | 5405709 | 20241027005421_2BXHF | UK0021 | 2024-10-29T12:13:10.550Z | 2024-11-04T14:28:53.926Z |
5405702 | 5405702 | 20241027005421_5oB1l | UK0021 | 2024-10-29T12:13:10.325Z | 2024-11-04T14:28:53.923Z |
5405426 | 5405426 | 20241027003316_GPrPl | UK0021 | 2024-10-29T12:12:55.430Z | 2024-11-04T14:28:53.467Z |
5403328 | 5403328 | 20241026214139_mQhTZ | UK0021 | 2024-10-29T12:09:22.232Z | 2024-11-04T14:28:48.365Z |
5403206 | 5403206 | 20241026212934_XBX7g | UK0021 | 2024-10-29T12:09:13.090Z | 2024-11-04T14:28:47.964Z |
5403030 | 5403030 | 20241026210717_OBaqF | UK0021 | 2024-10-29T12:08:45.866Z | 2024-11-04T14:28:47.449Z |
5402368 | 5402368 | 20241026192324_A5y8Y | UK0021 | 2024-10-29T12:07:06.205Z | 2024-11-04T14:28:44.137Z |
5402340 | 5402340 | 20241026191856_UCJ35 | UK0021 | 2024-10-29T12:07:02.338Z | 2024-11-04T14:28:43.765Z |
5402248 | 5402248 | 20241026190615_7Ca0D | UK0021 | 2024-10-29T12:06:44.434Z | 2024-11-04T14:28:43.331Z |
5401897 | 5401897 | 20241026180251_29qWN | UK0021 | 2024-10-29T12:05:46.284Z | 2024-11-04T14:28:40.847Z |
5400187 | 5400187 | 20241026055149_UUsPW | UK0021 | 2024-10-28T12:20:25.699Z | 2024-11-03T14:27:41.524Z |
5400081 | 5400081 | 20241026053722_jV2o3 | UK0021 | 2024-10-28T12:20:21.857Z | 2024-11-03T14:27:41.269Z |
5399929 | 5399929 | 20241026051303_oyNEc | UK0021 | 2024-10-28T12:20:17.129Z | 2024-11-03T14:27:40.870Z |
5399839 | 5399839 | 20241026050603_vQtw8 | UK0021 | 2024-10-28T12:20:13.190Z | 2024-11-03T14:27:40.601Z |
5399610 | 5399610 | 20241026043919_ErU0z | UK0021 | 2024-10-28T12:20:04.032Z | 2024-11-03T14:27:40.081Z |
5399532 | 5399532 | 20241026043233_5buxY | UK0021 | 2024-10-28T12:20:01.657Z | 2024-11-03T14:27:39.939Z |
5399245 | 5399245 | 20241026040459_FIVN3 | UK0021 | 2024-10-28T12:19:52.437Z | 2024-11-03T14:27:39.281Z |
5399064 | 5399064 | 20241026034824_FPicK | UK0021 | 2024-10-28T12:19:47.012Z | 2024-11-03T14:27:38.959Z |
5399036 | 5399036 | 20241026034611_eikYZ | UK0021 | 2024-10-28T12:19:45.243Z | 2024-11-03T14:27:38.913Z |
5398991 | 5398991 | 20241026034400_Lpq47 | UK0021 | 2024-10-28T12:19:43.828Z | 2024-11-03T14:27:38.817Z |
5398833 | 5398833 | 20241026033213_krvse | UK0021 | 2024-10-28T12:19:35.778Z | 2024-11-03T14:27:38.274Z |
5398804 | 5398804 | 20241026033023_Mpcd8 | UK0021 | 2024-10-28T12:19:34.063Z | 2024-11-03T14:27:38.138Z |
5398704 | 5398704 | 20241026032054_37ald | UK0021 | 2024-10-28T12:19:28.928Z | 2024-11-03T14:27:37.872Z |
5398282 | 5398282 | 20241026024202_MvdrU | UK0021 | 2024-10-28T12:19:09.367Z | 2024-11-03T14:27:35.832Z |
5398274 | 5398274 | 20241026024009_1HiTy | UK0021 | 2024-10-28T12:19:08.743Z | 2024-11-03T14:27:35.765Z |
5397803 | 5397803 | 20241026015903_4b8bm | UK0021 | 2024-10-28T12:18:43.613Z | 2024-11-03T14:27:34.163Z |
5397538 | 5397538 | 20241026013856_tI2Qi | UK0021 | 2024-10-28T12:18:26.608Z | 2024-11-03T14:27:33.355Z |
5397273 | 5397273 | 20241026011415_9WWx2 | UK0021 | 2024-10-28T12:18:14.034Z | 2024-11-03T14:27:32.478Z |
5397015 | 5397015 | 20241026005613_TUfdc | UK0021 | 2024-10-28T12:18:02.928Z | 2024-11-03T14:27:31.742Z |
5396865 | 5396865 | 20241026004303_xvXvG | UK0021 | 2024-10-28T12:17:58.327Z | 2024-11-03T14:27:31.274Z |
5396614 | 5396614 | 20241026001646_NYLDI | UK0021 | 2024-10-28T12:17:51.231Z | 2024-11-03T14:27:30.456Z |
5396551 | 5396551 | 20241026001135_GXhzF | UK0021 | 2024-10-28T12:17:49.520Z | 2024-11-03T14:27:30.184Z |
5396502 | 5396502 | 20241026000812_pz3O5 | UK0021 | 2024-10-28T12:17:47.258Z | 2024-11-03T14:27:30.021Z |
5396030 | 5396030 | 20241025233229_x2J1l | UK0021 | 2024-10-28T12:17:13.966Z | 2024-11-03T14:27:28.150Z |
5395886 | 5395886 | 20241025231811_FCO7o | UK0021 | 2024-10-28T12:17:03.723Z | 2024-11-03T14:27:27.550Z |
5395674 | 5395674 | 20241025230347_JLJZX | UK0021 | 2024-10-28T12:16:38.172Z | 2024-11-03T14:27:26.387Z |
5395035 | 5395035 | 20241025220237_Qc2Un | UK0021 | 2024-10-28T12:15:54.101Z | 2024-11-03T14:27:23.707Z |
5394802 | 5394802 | 20241025212935_ZuXR3 | UK0021 | 2024-10-28T12:15:27.295Z | 2024-11-03T14:27:22.802Z |
5394211 | 5394211 | 20241025195732_vrc8C | UK0021 | 2024-10-28T12:14:11.500Z | 2024-11-03T14:27:20.300Z |
5393822 | 5393822 | 20241025185254_AfKX2 | UK0021 | 2024-10-28T12:13:32.139Z | 2024-11-03T14:27:18.506Z |
5355843 | 5355843 | 20241023042706_0OhMU | UK0021 | 2024-10-24T12:21:39.406Z | 2024-10-31T12:30:09.069Z |
5355807 | 5355807 | 20241023042141_X1PhP | UK0021 | 2024-10-24T12:21:37.578Z | 2024-10-31T12:30:08.928Z |
5355762 | 5355762 | 20241023041233_V3YV1 | UK0021 | 2024-10-24T12:21:35.076Z | 2024-10-31T12:30:08.655Z |
5355672 | 5355672 | 20241023040053_ukPQd | UK0021 | 2024-10-24T12:21:30.528Z | 2024-10-31T12:30:08.491Z |
5355214 | 5355214 | 20241023032212_qcOy3 | UK0021 | 2024-10-24T12:21:10.360Z | 2024-10-31T12:30:07.382Z |
5355071 | 5355071 | 20241023031302_V3uvy | UK0021 | 2024-10-24T12:21:04.117Z | 2024-10-31T12:30:07.257Z |
5354858 | 5354858 | 20241023025014_ZnpHk | UK0021 | 2024-10-24T12:20:54.419Z | 2024-10-31T12:30:06.398Z |
5354662 | 5354662 | 20241023023852_C63ZW | UK0021 | 2024-10-24T12:20:46.047Z | 2024-10-31T12:30:06.224Z |
5354639 | 5354639 | 20241023023740_0ChRA | UK0021 | 2024-10-24T12:20:45.233Z | 2024-10-31T12:30:06.203Z |
5354234 | 5354234 | 20241023021314_bdn8T | UK0021 | 2024-10-24T12:20:24.271Z | 2024-10-31T12:30:05.538Z |
5354214 | 5354214 | 20241023021209_nLNl8 | UK0021 | 2024-10-24T12:20:23.379Z | 2024-10-31T12:30:05.524Z |
5353838 | 5353838 | 20241023015137_qQHMX | UK0021 | 2024-10-24T12:19:58.059Z | 2024-10-31T12:30:04.911Z |
5353806 | 5353806 | 20241023014916_NcPgV | UK0021 | 2024-10-24T12:19:56.968Z | 2024-10-31T12:30:04.842Z |
5352741 | 5352741 | 20241023004809_539Yc | UK0021 | 2024-10-24T12:19:09.815Z | 2024-10-31T12:30:03.213Z |
5352605 | 5352605 | 20241023004138_JFJ2m | UK0021 | 2024-10-24T12:19:00.545Z | 2024-10-31T12:30:02.987Z |
5352561 | 5352561 | 20241023003850_3x73X | UK0021 | 2024-10-24T12:18:57.245Z | 2024-10-31T12:30:02.891Z |
5352319 | 5352319 | 20241023002604_KtBXT | UK0021 | 2024-10-24T12:18:37.756Z | 2024-10-31T12:30:02.420Z |
5352169 | 5352169 | 20241023001603_JibkD | UK0021 | 2024-10-24T12:18:28.291Z | 2024-10-31T12:30:02.264Z |
5352007 | 5352007 | 20241023000543_HTyJx | UK0021 | 2024-10-24T12:18:13.840Z | 2024-10-31T12:30:01.623Z |
5351576 | 5351576 | 20241022233909_MJt1D | UK0021 | 2024-10-24T12:17:40.478Z | 2024-10-31T12:30:00.558Z |
5351343 | 5351343 | 20241022231822_1uWJV | UK0021 | 2024-10-24T12:17:27.334Z | 2024-10-31T12:30:00.222Z |
5351245 | 5351245 | 20241022231039_BjgaU | UK0021 | 2024-10-24T12:17:22.257Z | 2024-10-31T12:29:59.668Z |
5349265 | 5349265 | 20241022193816_UGbQT | UK0021 | 2024-10-24T12:13:22.823Z | 2024-10-31T12:29:54.951Z |
5345291 | 5345291 | 20241022053310_qVfVS | UK0021 | 2024-10-23T12:19:13.250Z | 2024-10-30T12:26:52.426Z |
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);