participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,279 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 |
---|---|---|---|---|---|
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 |
5356128 | 5356128 | 20241023050401_N2yyJ | UK007R | 2024-10-24T12:21:53.713Z | 2024-10-31T12:30:10.516Z |
5356082 | 5356082 | 20241023045401_vi0RV | UK007R | 2024-10-24T12:21:50.028Z | 2024-10-31T12:30:09.765Z |
5356016 | 5356016 | 20241023044928_eiDMK | UK007R | 2024-10-24T12:21:47.571Z | 2024-10-31T12:30:09.540Z |
5355985 | 5355985 | 20241023044718_3sRza | UK007R | 2024-10-24T12:21:45.805Z | 2024-10-31T12:30:09.453Z |
5355932 | 5355932 | 20241023044133_AUAeC | UK007R | 2024-10-24T12:21:42.669Z | 2024-10-31T12:30:09.283Z |
5355898 | 5355898 | 20241023043332_5G372 | UK007R | 2024-10-24T12:21:41.457Z | 2024-10-31T12:30:09.151Z |
5355883 | 5355883 | 20241023043253_n6Bk4 | UK007R | 2024-10-24T12:21:41.140Z | 2024-10-31T12:30:09.146Z |
5355858 | 5355858 | 20241023043008_lhXw2 | UK007R | 2024-10-24T12:21:39.997Z | 2024-10-31T12:30:09.109Z |
5355803 | 5355803 | 20241023042042_vAsVA | UK007R | 2024-10-24T12:21:37.114Z | 2024-10-31T12:30:08.902Z |
5355751 | 5355751 | 20241023040949_BLdig | UK007R | 2024-10-24T12:21:34.615Z | 2024-10-31T12:30:08.640Z |
5355687 | 5355687 | 20241023040135_Xw4Bf | UK007R | 2024-10-24T12:21:30.915Z | 2024-10-31T12:30:08.509Z |
5355592 | 5355592 | 20241023035329_K14j8 | UK007R | 2024-10-24T12:21:26.806Z | 2024-10-31T12:30:08.085Z |
5355551 | 5355551 | 20241023034922_IT6fL | UK007R | 2024-10-24T12:21:25.890Z | 2024-10-31T12:30:08.061Z |
5355452 | 5355452 | 20241023034110_QDCpV | UK007R | 2024-10-24T12:21:21.291Z | 2024-10-31T12:30:07.698Z |
5355379 | 5355379 | 20241023033616_fvxp4 | UK007R | 2024-10-24T12:21:17.284Z | 2024-10-31T12:30:07.573Z |
5355269 | 5355269 | 20241023032551_Azc6y | UK007R | 2024-10-24T12:21:11.872Z | 2024-10-31T12:30:07.460Z |
5354729 | 5354729 | 20241023024309_yL3LN | UK007R | 2024-10-24T12:20:48.086Z | 2024-10-31T12:30:06.285Z |
5354687 | 5354687 | 20241023024013_2RfYb | UK007R | 2024-10-24T12:20:46.490Z | 2024-10-31T12:30:06.239Z |
5354548 | 5354548 | 20241023023142_kSDUO | UK007R | 2024-10-24T12:20:40.253Z | 2024-10-31T12:30:05.966Z |
5354181 | 5354181 | 20241023020944_tX95S | UK007R | 2024-10-24T12:20:20.758Z | 2024-10-31T12:30:05.493Z |
5353019 | 5353019 | 20241023010201_HrdXJ | UK007R | 2024-10-24T12:19:29.387Z | 2024-10-31T12:30:03.680Z |
5349547 | 5349547 | 20241022201105_8ICUw | UK007R | 2024-10-24T12:13:57.107Z | 2024-10-31T12:29:55.769Z |
5349539 | 5349539 | 20241022201104_A3xHi | UK007R | 2024-10-24T12:13:56.733Z | 2024-10-31T12:29:55.759Z |
5345309 | 5345309 | 20241022053418_Q0EvT | UK007R | 2024-10-23T12:19:13.837Z | 2024-10-30T12:26:52.438Z |
5345255 | 5345255 | 20241022053015_eypZb | UK007R | 2024-10-23T12:19:12.339Z | 2024-10-30T12:26:52.364Z |
5345141 | 5345141 | 20241022051502_d88ED | UK007R | 2024-10-23T12:19:07.341Z | 2024-10-30T12:26:52.226Z |
5345026 | 5345026 | 20241022050718_uSe2O | UK007R | 2024-10-23T12:19:03.001Z | 2024-10-30T12:26:52.121Z |
5344999 | 5344999 | 20241022050553_Ewqhe | UK007R | 2024-10-23T12:19:02.150Z | 2024-10-30T12:26:52.073Z |
5344770 | 5344770 | 20241022044500_lbGEG | UK007R | 2024-10-23T12:18:50.318Z | 2024-10-30T12:26:51.657Z |
5344709 | 5344709 | 20241022044135_vqgeG | UK007R | 2024-10-23T12:18:48.513Z | 2024-10-30T12:26:51.568Z |
5344578 | 5344578 | 20241022043318_2sb7S | UK007R | 2024-10-23T12:18:42.085Z | 2024-10-30T12:26:51.379Z |
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);