home / gmn_data_store / participating_station

Menu
  • Dashboards

participating_station

Each row represents a station recording a meteor sighting.

Data license: CC BY 4.0 license · Data source: Global Meteor Network

7,319 rows where station_code = "UK00B2" sorted by created_at descending

✎ View and edit SQL

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
8691393 8691393 20251205051329_YiJqg UK00B2 2025-12-06T14:17:33.835Z 2025-12-06T14:18:01.102Z
8691270 8691270 20251205041819_JUpI4 UK00B2 2025-12-06T14:17:04.543Z 2025-12-06T14:18:01.073Z
8691264 8691264 20251205041819_6MtF5 UK00B2 2025-12-06T14:17:04.196Z 2025-12-06T14:18:01.072Z
8691147 8691147 20251205034405_ah7cb UK00B2 2025-12-06T14:16:43.626Z 2025-12-06T14:18:01.042Z
8690864 8690864 20251205020637_BjNEa UK00B2 2025-12-06T14:15:43.515Z 2025-12-06T14:18:00.976Z
8680701 8680701 20251203010652_cFYcd UK00B2 2025-12-04T14:12:45.977Z 2025-12-06T14:27:23.016Z
8680613 8680613 20251203004712_rHAeM UK00B2 2025-12-04T14:12:28.420Z 2025-12-06T14:27:19.764Z
8680447 8680447 20251203000133_qkFHX UK00B2 2025-12-04T14:12:01.265Z 2025-12-06T14:27:12.247Z
8680429 8680429 20251202235508_yT5Ur UK00B2 2025-12-04T14:11:58.717Z 2025-12-06T14:27:11.476Z
8680340 8680340 20251202233055_AseiN UK00B2 2025-12-04T14:11:48.886Z 2025-12-06T14:27:03.146Z
8677050 8677050 20251202064220_Unh26 UK00B2 2025-12-03T14:26:13.271Z 2025-12-06T14:35:33.397Z
8676623 8676623 20251202060852_GTz42 UK00B2 2025-12-03T14:25:22.448Z 2025-12-06T14:35:24.872Z
8676540 8676540 20251202060101_SXPEA UK00B2 2025-12-03T14:25:17.423Z 2025-12-06T14:35:23.241Z
8676268 8676268 20251202054246_u2aGA UK00B2 2025-12-03T14:24:52.128Z 2025-12-06T14:35:19.374Z
8676120 8676120 20251202053729_sV63r UK00B2 2025-12-03T14:24:43.576Z 2025-12-06T14:35:10.736Z
8675573 8675573 20251202045706_TVoSY UK00B2 2025-12-03T14:23:51.990Z 2025-12-06T14:34:56.425Z
8675563 8675563 20251202045633_0g8Ha UK00B2 2025-12-03T14:23:51.596Z 2025-12-06T14:34:56.343Z
8675466 8675466 20251202044357_Kx77Z UK00B2 2025-12-03T14:23:45.215Z 2025-12-06T14:34:53.694Z
8675209 8675209 20251202041758_3s3pA UK00B2 2025-12-03T14:23:20.672Z 2025-12-06T14:34:47.409Z
8674647 8674647 20251202030317_q3Aif UK00B2 2025-12-03T14:22:10.640Z 2025-12-06T14:34:14.717Z
8674476 8674476 20251202023152_1fI2d UK00B2 2025-12-03T14:21:40.973Z 2025-12-06T14:34:09.941Z
8674464 8674464 20251202022852_8uqgC UK00B2 2025-12-03T14:21:40.483Z 2025-12-06T14:34:09.691Z
8674280 8674280 20251202015624_GPLjI UK00B2 2025-12-03T14:21:21.200Z 2025-12-06T14:34:02.985Z
8674243 8674243 20251202015312_pHR02 UK00B2 2025-12-03T14:21:16.929Z 2025-12-06T14:34:02.366Z
8674227 8674227 20251202015014_Hs2R8 UK00B2 2025-12-03T14:21:15.950Z 2025-12-06T14:34:02.178Z
8674211 8674211 20251202014628_uxHyW UK00B2 2025-12-03T14:21:09.913Z 2025-12-06T14:34:01.494Z
8674202 8674202 20251202014536_XYICU UK00B2 2025-12-03T14:21:09.124Z 2025-12-06T14:34:01.235Z
8674179 8674179 20251202014340_YkC0A UK00B2 2025-12-03T14:21:07.718Z 2025-12-06T14:34:00.626Z
8674070 8674070 20251202012410_UXkjc UK00B2 2025-12-03T14:20:53.756Z 2025-12-06T14:33:55.763Z
8673944 8673944 20251202004437_3UJAk UK00B2 2025-12-03T14:20:25.121Z 2025-12-06T14:33:42.989Z
8658094 8658094 20251130063643_VAtuD UK00B2 2025-12-01T14:34:54.056Z 2025-12-06T14:50:26.345Z
8657530 8657530 20251130055059_E4Wha UK00B2 2025-12-01T14:34:32.058Z 2025-12-06T14:50:05.226Z
8657199 8657199 20251130053332_Eb2AW UK00B2 2025-12-01T14:34:00.336Z 2025-12-06T14:49:45.748Z
8657171 8657171 20251130053213_jVUGf UK00B2 2025-12-01T14:33:57.214Z 2025-12-06T14:49:45.360Z
8657093 8657093 20251130052936_101eh UK00B2 2025-12-01T14:33:54.132Z 2025-12-06T14:49:44.772Z
8656964 8656964 20251130052232_o6sTk UK00B2 2025-12-01T14:33:51.041Z 2025-12-06T14:49:43.717Z
8655764 8655764 20251130041702_3hIt4 UK00B2 2025-12-01T14:27:27.320Z 2025-12-06T14:49:27.372Z
8655697 8655697 20251130041152_4eH3J UK00B2 2025-12-01T14:27:21.460Z 2025-12-06T14:49:26.576Z
8655399 8655399 20251130040048_N1CRV UK00B2 2025-12-01T14:26:52.957Z 2025-12-06T14:49:13.841Z
8655087 8655087 20251130034318_XEU8R UK00B2 2025-12-01T14:26:22.386Z 2025-12-06T14:48:51.392Z
8654038 8654038 20251130025353_9u0BD UK00B2 2025-12-01T14:24:45.926Z 2025-12-06T14:48:36.270Z
8653642 8653642 20251130023240_y0O9Z UK00B2 2025-12-01T14:23:53.567Z 2025-12-06T14:48:23.951Z
8653464 8653464 20251130021724_Iaxik UK00B2 2025-12-01T14:23:32.809Z 2025-12-06T14:47:58.789Z
8653402 8653402 20251130021457_93gj2 UK00B2 2025-12-01T14:23:21.155Z 2025-12-06T14:47:57.346Z
8653246 8653246 20251130020447_2B8Ps UK00B2 2025-12-01T14:23:07.362Z 2025-12-06T14:47:52.167Z
8653137 8653137 20251130015926_rTlnS UK00B2 2025-12-01T14:22:52.043Z 2025-12-06T14:47:50.616Z
8653016 8653016 20251130015056_uzveL UK00B2 2025-12-01T14:22:38.430Z 2025-12-06T14:47:47.589Z
8652972 8652972 20251130014804_Y0hxu UK00B2 2025-12-01T14:22:35.709Z 2025-12-06T14:47:47.189Z
8652946 8652946 20251130014610_D3wQI UK00B2 2025-12-01T14:22:33.903Z 2025-12-06T14:47:46.543Z
8652904 8652904 20251130014428_Mv12R UK00B2 2025-12-01T14:22:29.521Z 2025-12-06T14:47:45.239Z
8652721 8652721 20251130012839_FiUaZ UK00B2 2025-12-01T14:22:01.729Z 2025-12-06T14:47:41.432Z
8652690 8652690 20251130012713_7hhQX UK00B2 2025-12-01T14:21:58.801Z 2025-12-06T14:47:40.992Z
8652605 8652605 20251130012250_ulDaA UK00B2 2025-12-01T14:21:51.162Z 2025-12-06T14:47:40.035Z
8652554 8652554 20251130012038_akbnN UK00B2 2025-12-01T14:21:40.590Z 2025-12-06T14:47:39.193Z
8652218 8652218 20251130005520_2a072 UK00B2 2025-12-01T14:20:55.765Z 2025-12-06T14:47:31.435Z
8652105 8652105 20251130004738_LoXoP UK00B2 2025-12-01T14:20:43.274Z 2025-12-06T14:47:17.599Z
8652067 8652067 20251130004421_ZnlL2 UK00B2 2025-12-01T14:20:39.215Z 2025-12-06T14:47:11.230Z
8651866 8651866 20251130002818_T9NVx UK00B2 2025-12-01T14:20:08.876Z 2025-12-06T14:46:55.264Z
8651822 8651822 20251130002348_bRPqM UK00B2 2025-12-01T14:20:03.872Z 2025-12-06T14:46:54.732Z
8651565 8651565 20251129235617_Adjej UK00B2 2025-12-01T14:19:20.577Z 2025-12-06T14:46:48.474Z
8643329 8643329 20251128174347_UmZ3d UK00B2 2025-11-30T14:19:53.971Z 2025-12-06T14:53:47.808Z
8637764 8637764 20251128063208_836Ow UK00B2 2025-11-29T14:27:48.666Z 2025-12-06T15:04:03.925Z
8637654 8637654 20251128060634_RIkq1 UK00B2 2025-11-29T14:27:40.124Z 2025-12-06T15:04:02.106Z
8637588 8637588 20251128055558_H61gU UK00B2 2025-11-29T14:27:36.175Z 2025-12-06T15:04:01.499Z
8637495 8637495 20251128054550_k3w2B UK00B2 2025-11-29T14:27:30.674Z 2025-12-06T15:04:00.594Z
8636864 8636864 20251128043128_L0fD8 UK00B2 2025-11-29T14:26:16.458Z 2025-12-06T15:03:46.784Z
8634812 8634812 20251128011957_HtUbV UK00B2 2025-11-29T14:22:04.704Z 2025-12-06T15:02:36.179Z
8634786 8634786 20251128011734_RCV3k UK00B2 2025-11-29T14:22:03.338Z 2025-12-06T15:02:35.898Z
8634294 8634294 20251128003424_DmZK9 UK00B2 2025-11-29T14:21:10.121Z 2025-12-06T15:01:58.038Z
8634177 8634177 20251128002943_Sk2Xq UK00B2 2025-11-29T14:20:51.999Z 2025-12-06T15:01:51.996Z
8633794 8633794 20251127235453_VwQft UK00B2 2025-11-29T14:20:23.661Z 2025-12-06T15:01:48.674Z
8633534 8633534 20251127233002_eSqpX UK00B2 2025-11-29T14:19:50.889Z 2025-12-06T15:01:45.240Z
8633365 8633365 20251127230647_rPhRA UK00B2 2025-11-29T14:19:29.510Z 2025-12-06T15:01:43.075Z
8633178 8633178 20251127224915_2xKdh UK00B2 2025-11-29T14:19:11.858Z 2025-12-06T15:01:40.810Z
8632618 8632618 20251127212555_1IVMp UK00B2 2025-11-29T14:17:52.080Z 2025-12-06T15:01:31.534Z
8632394 8632394 20251127210202_ShCg2 UK00B2 2025-11-29T14:17:25.653Z 2025-12-06T15:01:14.810Z
8632105 8632105 20251127203247_iVcdt UK00B2 2025-11-29T14:17:00.586Z 2025-12-06T15:00:53.117Z
8632019 8632019 20251127202340_Qda5V UK00B2 2025-11-29T14:16:40.945Z 2025-12-06T15:00:49.935Z
8616638 8616638 20251126061405_8VxTA UK00B2 2025-11-27T14:31:23.589Z 2025-12-04T15:11:41.442Z
8616627 8616627 20251126061405_1nZkY UK00B2 2025-11-27T14:31:23.247Z 2025-12-04T15:11:41.406Z
8616370 8616370 20251126055304_kvlTP UK00B2 2025-11-27T14:31:06.918Z 2025-12-04T15:11:38.380Z
8616064 8616064 20251126053457_d3bgi UK00B2 2025-11-27T14:30:27.189Z 2025-12-04T15:11:35.018Z
8615987 8615987 20251126053039_f2Wl9 UK00B2 2025-11-27T14:30:19.849Z 2025-12-04T15:11:34.212Z
8615785 8615785 20251126051904_VjE3p UK00B2 2025-11-27T14:30:10.451Z 2025-12-04T15:11:32.304Z
8615678 8615678 20251126051245_cv8ct UK00B2 2025-11-27T14:30:04.593Z 2025-12-04T15:11:31.152Z
8615411 8615411 20251126050146_qjh82 UK00B2 2025-11-27T14:29:30.665Z 2025-12-04T15:11:28.411Z
8615377 8615377 20251126050051_iOx22 UK00B2 2025-11-27T14:29:29.300Z 2025-12-04T15:11:28.199Z
8614897 8614897 20251126043436_7j4Es UK00B2 2025-11-27T14:28:41.554Z 2025-12-04T15:11:17.759Z
8614695 8614695 20251126042346_4o5Dx UK00B2 2025-11-27T14:28:27.740Z 2025-12-04T15:10:57.894Z
8614581 8614581 20251126041816_7fcMS UK00B2 2025-11-27T14:28:03.187Z 2025-12-04T15:10:51.741Z
8614440 8614440 20251126040850_IkmD2 UK00B2 2025-11-27T14:27:52.264Z 2025-12-04T15:10:40.799Z
8614199 8614199 20251126035611_XIlik UK00B2 2025-11-27T14:27:38.283Z 2025-12-04T15:10:29.330Z
8614076 8614076 20251126035010_q3w8d UK00B2 2025-11-27T14:27:11.260Z 2025-12-04T15:10:17.784Z
8613046 8613046 20251126030015_M03OO UK00B2 2025-11-27T14:25:20.404Z 2025-12-04T15:09:36.692Z
8612963 8612963 20251126025740_93pjF UK00B2 2025-11-27T14:25:02.890Z 2025-12-04T15:09:36.120Z
8612941 8612941 20251126025705_i2qF7 UK00B2 2025-11-27T14:25:01.822Z 2025-12-04T15:09:35.977Z
8612838 8612838 20251126025006_TPfc7 UK00B2 2025-11-27T14:24:53.764Z 2025-12-04T15:09:34.726Z
8612699 8612699 20251126024213_ZOfdS UK00B2 2025-11-27T14:24:28.561Z 2025-12-04T15:09:32.829Z
8612618 8612618 20251126023941_t32Vt UK00B2 2025-11-27T14:24:24.519Z 2025-12-04T15:09:32.200Z
8612609 8612609 20251126023902_0l3CJ UK00B2 2025-11-27T14:24:24.199Z 2025-12-04T15:09:32.198Z

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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);
Powered by Datasette · Queries took 1.2ms · Data license: CC BY 4.0 license · Data source: Global Meteor Network