participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,310 rows where station_code = "UK007R" 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 |
---|---|---|---|---|---|
5570427 | 5570427 | 20241120193535_42Yk1 | UK007R | 2024-11-22T14:15:24.920Z | 2024-11-22T14:19:21.916Z |
5570277 | 5570277 | 20241120191243_3Vaop | UK007R | 2024-11-22T14:15:05.925Z | 2024-11-22T14:19:21.891Z |
5570154 | 5570154 | 20241120185230_L3ika | UK007R | 2024-11-22T14:14:56.208Z | 2024-11-22T14:19:21.872Z |
5569784 | 5569784 | 20241120173150_X66Wl | UK007R | 2024-11-22T14:14:11.016Z | 2024-11-22T14:19:21.805Z |
5561211 | 5561211 | 20241119190339_ra1y3 | UK007R | 2024-11-21T14:12:36.924Z | 2024-11-22T14:20:26.284Z |
5543286 | 5543286 | 20241114234951_Rx6zR | UK007R | 2024-11-16T14:06:00.250Z | 2024-11-22T14:23:57.911Z |
5543229 | 5543229 | 20241114231722_fjfrZ | UK007R | 2024-11-16T14:05:48.192Z | 2024-11-22T14:23:57.630Z |
5543194 | 5543194 | 20241114224825_cujyV | UK007R | 2024-11-16T14:05:42.416Z | 2024-11-22T14:23:57.410Z |
5532680 | 5532680 | 20241112055201_cRjHr | UK007R | 2024-11-13T14:17:08.893Z | 2024-11-20T14:26:25.607Z |
5532542 | 5532542 | 20241112053628_7NWEH | UK007R | 2024-11-13T14:16:58.751Z | 2024-11-20T14:26:24.470Z |
5532476 | 5532476 | 20241112052812_4BBgp | UK007R | 2024-11-13T14:16:51.697Z | 2024-11-20T14:26:23.824Z |
5532402 | 5532402 | 20241112051837_2jsja | UK007R | 2024-11-13T14:16:42.683Z | 2024-11-20T14:26:22.712Z |
5532358 | 5532358 | 20241112051319_SUlgr | UK007R | 2024-11-13T14:16:39.089Z | 2024-11-20T14:26:22.209Z |
5532037 | 5532037 | 20241112042950_9wUpx | UK007R | 2024-11-13T14:16:11.901Z | 2024-11-20T14:26:17.756Z |
5531905 | 5531905 | 20241112041756_GZyao | UK007R | 2024-11-13T14:16:01.281Z | 2024-11-20T14:26:15.799Z |
5531798 | 5531798 | 20241112040959_4QB9e | UK007R | 2024-11-13T14:15:55.501Z | 2024-11-20T14:26:14.594Z |
5531767 | 5531767 | 20241112040804_KiYVV | UK007R | 2024-11-13T14:15:54.201Z | 2024-11-20T14:26:14.216Z |
5531528 | 5531528 | 20241112034705_xDmWY | UK007R | 2024-11-13T14:15:43.905Z | 2024-11-20T14:26:12.095Z |
5531436 | 5531436 | 20241112033941_tNiRL | UK007R | 2024-11-13T14:15:39.491Z | 2024-11-20T14:26:11.279Z |
5530991 | 5530991 | 20241112030429_hPE2K | UK007R | 2024-11-13T14:14:58.738Z | 2024-11-20T14:26:05.814Z |
5530976 | 5530976 | 20241112030334_xk9Lx | UK007R | 2024-11-13T14:14:57.361Z | 2024-11-20T14:26:05.737Z |
5530690 | 5530690 | 20241112023807_9HB72 | UK007R | 2024-11-13T14:14:27.855Z | 2024-11-20T14:26:02.599Z |
5530532 | 5530532 | 20241112022626_2VeHV | UK007R | 2024-11-13T14:14:20.641Z | 2024-11-20T14:26:01.230Z |
5530326 | 5530326 | 20241112020747_6fpxx | UK007R | 2024-11-13T14:14:08.485Z | 2024-11-20T14:25:56.967Z |
5529990 | 5529990 | 20241112013234_1FIKg | UK007R | 2024-11-13T14:13:34.333Z | 2024-11-20T14:25:52.059Z |
5529764 | 5529764 | 20241112010340_l9Aae | UK007R | 2024-11-13T14:13:09.732Z | 2024-11-20T14:25:48.059Z |
5529494 | 5529494 | 20241112002642_JXaBI | UK007R | 2024-11-13T14:12:54.534Z | 2024-11-20T14:25:45.701Z |
5529307 | 5529307 | 20241112000024_TINoe | UK007R | 2024-11-13T14:12:21.120Z | 2024-11-20T14:25:42.683Z |
5528524 | 5528524 | 20241111212245_BPSHE | UK007R | 2024-11-13T14:11:03.346Z | 2024-11-20T14:25:31.852Z |
5528501 | 5528501 | 20241111211303_x7UIP | UK007R | 2024-11-13T14:10:55.438Z | 2024-11-20T14:25:31.422Z |
5527714 | 5527714 | 20241111182151_Z6dWd | UK007R | 2024-11-13T14:08:58.436Z | 2024-11-20T14:25:18.405Z |
5440963 | 5440963 | 20241030233030_DIGlF | UK007R | 2024-11-01T12:16:04.425Z | 2024-11-08T14:23:11.355Z |
5440836 | 5440836 | 20241030231422_zBdcA | UK007R | 2024-11-01T12:15:53.961Z | 2024-11-08T14:23:10.805Z |
5440590 | 5440590 | 20241030223045_4mckj | UK007R | 2024-11-01T12:15:38.373Z | 2024-11-08T14:23:09.953Z |
5440241 | 5440241 | 20241030214604_HKiF0 | UK007R | 2024-11-01T12:15:04.198Z | 2024-11-08T14:23:08.188Z |
5439998 | 5439998 | 20241030210438_SsIqy | UK007R | 2024-11-01T12:14:43.623Z | 2024-11-08T14:23:06.692Z |
5439979 | 5439979 | 20241030210032_W42aY | UK007R | 2024-11-01T12:14:41.987Z | 2024-11-08T14:23:06.586Z |
5439799 | 5439799 | 20241030203329_rxcN1 | UK007R | 2024-11-01T12:14:30.824Z | 2024-11-08T14:23:05.829Z |
5439622 | 5439622 | 20241030201316_Go3k8 | UK007R | 2024-11-01T12:14:04.693Z | 2024-11-08T14:23:04.326Z |
5439610 | 5439610 | 20241030201154_Yz2Eo | UK007R | 2024-11-01T12:14:02.805Z | 2024-11-08T14:23:04.278Z |
5439587 | 5439587 | 20241030201130_sH7Xc | UK007R | 2024-11-01T12:14:00.772Z | 2024-11-08T14:23:04.239Z |
5432756 | 5432756 | 20241029043318_zzFNt | UK007R | 2024-10-31T12:21:33.864Z | 2024-11-06T14:27:28.643Z |
5431524 | 5431524 | 20241029012446_JiIcB | UK007R | 2024-10-31T12:20:18.366Z | 2024-11-06T14:27:23.997Z |
5431508 | 5431508 | 20241029012215_9zvT7 | UK007R | 2024-10-31T12:20:16.241Z | 2024-11-06T14:27:23.958Z |
5431470 | 5431470 | 20241029011723_AhU7A | UK007R | 2024-10-31T12:20:11.576Z | 2024-11-06T14:27:23.858Z |
5431466 | 5431466 | 20241029011703_yEhlD | UK007R | 2024-10-31T12:20:11.073Z | 2024-11-06T14:27:23.824Z |
5408404 | 5408404 | 20241027032534_834Qh | UK007R | 2024-10-29T12:16:26.787Z | 2024-11-04T14:28:59.321Z |
5408313 | 5408313 | 20241027032209_2JJ6D | UK007R | 2024-10-29T12:16:22.104Z | 2024-11-04T14:28:59.079Z |
5407939 | 5407939 | 20241027025839_GLXBN | UK007R | 2024-10-29T12:15:54.213Z | 2024-11-04T14:28:58.515Z |
5407915 | 5407915 | 20241027025819_JBq2F | UK007R | 2024-10-29T12:15:52.334Z | 2024-11-04T14:28:58.350Z |
5407541 | 5407541 | 20241027024103_Hk8Wo | UK007R | 2024-10-29T12:15:28.532Z | 2024-11-04T14:28:57.860Z |
5407259 | 5407259 | 20241027022841_QfjO2 | UK007R | 2024-10-29T12:15:19.103Z | 2024-11-04T14:28:57.274Z |
5406743 | 5406743 | 20241027015741_DEZLL | UK007R | 2024-10-29T12:14:38.484Z | 2024-11-04T14:28:56.332Z |
5406498 | 5406498 | 20241027014127_5lw44 | UK007R | 2024-10-29T12:14:13.667Z | 2024-11-04T14:28:55.779Z |
5405719 | 5405719 | 20241027005426_BE5eI | UK007R | 2024-10-29T12:13:10.676Z | 2024-11-04T14:28:53.929Z |
5405674 | 5405674 | 20241027005237_6cjxi | UK007R | 2024-10-29T12:13:09.047Z | 2024-11-04T14:28:53.887Z |
5405277 | 5405277 | 20241027002634_Jtu4X | UK007R | 2024-10-29T12:12:47.249Z | 2024-11-04T14:28:53.233Z |
5405044 | 5405044 | 20241027001005_sYxuw | UK007R | 2024-10-29T12:12:19.220Z | 2024-11-04T14:28:52.617Z |
5404957 | 5404957 | 20241027000250_hZG38 | UK007R | 2024-10-29T12:12:10.720Z | 2024-11-04T14:28:52.451Z |
5404612 | 5404612 | 20241026234047_H30uQ | UK007R | 2024-10-29T12:11:46.007Z | 2024-11-04T14:28:51.410Z |
5404467 | 5404467 | 20241026232939_9d72X | UK007R | 2024-10-29T12:11:31.528Z | 2024-11-04T14:28:51.080Z |
5404401 | 5404401 | 20241026232310_huiNO | UK007R | 2024-10-29T12:11:18.993Z | 2024-11-04T14:28:50.851Z |
5404106 | 5404106 | 20241026225817_hOpOJ | UK007R | 2024-10-29T12:10:54.032Z | 2024-11-04T14:28:50.337Z |
5403670 | 5403670 | 20241026222240_C47Zp | UK007R | 2024-10-29T12:10:06.535Z | 2024-11-04T14:28:49.438Z |
5403633 | 5403633 | 20241026221849_qC8hl | UK007R | 2024-10-29T12:10:03.494Z | 2024-11-04T14:28:49.373Z |
5403608 | 5403608 | 20241026221548_wu8lY | UK007R | 2024-10-29T12:10:01.829Z | 2024-11-04T14:28:49.325Z |
5403524 | 5403524 | 20241026220558_dzQr2 | UK007R | 2024-10-29T12:09:42.015Z | 2024-11-04T14:28:49.117Z |
5403434 | 5403434 | 20241026215616_gM3Z8 | UK007R | 2024-10-29T12:09:30.127Z | 2024-11-04T14:28:48.821Z |
5403071 | 5403071 | 20241026211440_wPGmK | UK007R | 2024-10-29T12:08:52.192Z | 2024-11-04T14:28:47.661Z |
5402815 | 5402815 | 20241026202902_ZJYYP | UK007R | 2024-10-29T12:08:17.911Z | 2024-11-04T14:28:46.630Z |
5402697 | 5402697 | 20241026201529_2JLqC | UK007R | 2024-10-29T12:07:58.503Z | 2024-11-04T14:28:46.214Z |
5402576 | 5402576 | 20241026195745_Q4t2b | UK007R | 2024-10-29T12:07:43.910Z | 2024-11-04T14:28:45.359Z |
5402525 | 5402525 | 20241026195115_IJwcy | UK007R | 2024-10-29T12:07:32.872Z | 2024-11-04T14:28:45.085Z |
5402377 | 5402377 | 20241026192444_MS5ox | UK007R | 2024-10-29T12:07:07.014Z | 2024-11-04T14:28:44.162Z |
5377994 | 5377994 | 20241024052241_e90z3 | UK007R | 2024-10-26T12:22:52.158Z | 2024-11-01T12:27:03.216Z |
5377814 | 5377814 | 20241024051209_z1LwV | UK007R | 2024-10-26T12:22:47.546Z | 2024-11-01T12:27:03.075Z |
5377674 | 5377674 | 20241024050353_ZMqkP | UK007R | 2024-10-26T12:22:43.722Z | 2024-11-01T12:27:02.715Z |
5377591 | 5377591 | 20241024045819_DjBC3 | UK007R | 2024-10-26T12:22:41.322Z | 2024-11-01T12:27:02.617Z |
5377492 | 5377492 | 20241024045413_eAbke | UK007R | 2024-10-26T12:22:38.784Z | 2024-11-01T12:27:02.473Z |
5377267 | 5377267 | 20241024044136_Ew0Pi | UK007R | 2024-10-26T12:22:32.470Z | 2024-11-01T12:27:02.341Z |
5377243 | 5377243 | 20241024044105_nt2NM | UK007R | 2024-10-26T12:22:31.788Z | 2024-11-01T12:27:02.335Z |
5376906 | 5376906 | 20241024042225_bPXhT | UK007R | 2024-10-26T12:22:16.518Z | 2024-11-01T12:27:01.911Z |
5376258 | 5376258 | 20241024034739_6zwLw | UK007R | 2024-10-26T12:21:55.064Z | 2024-11-01T12:27:01.474Z |
5376055 | 5376055 | 20241024033924_TwvSR | UK007R | 2024-10-26T12:21:48.476Z | 2024-11-01T12:27:01.346Z |
5375899 | 5375899 | 20241024033513_hDt3O | UK007R | 2024-10-26T12:21:43.736Z | 2024-11-01T12:27:01.252Z |
5375690 | 5375690 | 20241024032459_rHgjz | UK007R | 2024-10-26T12:21:35.762Z | 2024-11-01T12:27:01.162Z |
5374573 | 5374573 | 20241024023455_wDu5d | UK007R | 2024-10-26T12:20:53.694Z | 2024-11-01T12:26:59.472Z |
5374106 | 5374106 | 20241024021042_HOMDd | UK007R | 2024-10-26T12:20:37.260Z | 2024-11-01T12:26:58.702Z |
5373666 | 5373666 | 20241024014900_Fjb2V | UK007R | 2024-10-26T12:20:20.516Z | 2024-11-01T12:26:58.358Z |
5367142 | 5367142 | 20241023053605_Gx4A8 | UK007R | 2024-10-25T12:21:46.760Z | 2024-10-31T12:30:11.553Z |
5366093 | 5366093 | 20241024000427_7yUSb | UK007R | 2024-10-25T12:18:16.099Z | 2024-11-01T12:26:56.744Z |
5364427 | 5364427 | 20241023222706_iAGYV | UK007R | 2024-10-25T12:17:20.323Z | 2024-11-01T12:26:55.071Z |
5364109 | 5364109 | 20241023220748_BUUIT | UK007R | 2024-10-25T12:17:09.427Z | 2024-11-01T12:26:54.546Z |
5363990 | 5363990 | 20241023220114_6SC0b | UK007R | 2024-10-25T12:17:04.844Z | 2024-11-01T12:26:54.266Z |
5363734 | 5363734 | 20241023213945_i2zrE | UK007R | 2024-10-25T12:16:38.677Z | 2024-11-01T12:26:53.587Z |
5363168 | 5363168 | 20241023203241_AC6sz | UK007R | 2024-10-25T12:15:36.055Z | 2024-11-01T12:26:52.893Z |
5362892 | 5362892 | 20241023200939_sneYk | UK007R | 2024-10-25T12:15:15.520Z | 2024-11-01T12:26:52.505Z |
5362159 | 5362159 | 20241023191221_sBmjD | UK007R | 2024-10-25T12:13:57.102Z | 2024-11-01T12:26:51.049Z |
5356295 | 5356295 | 20241023053320_XgB3y | UK007R | 2024-10-24T12:21:57.084Z | 2024-10-31T12:30:11.378Z |
5356175 | 5356175 | 20241023051225_IeCyy | UK007R | 2024-10-24T12:21:55.017Z | 2024-10-31T12:30:10.754Z |
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);