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

3,523 rows where station_code = "UK0073" 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
8647524 8647524 20251129044716_qG8Ed UK0073 2025-11-30T14:28:32.624Z 2025-12-06T14:56:40.503Z
8647358 8647358 20251129042715_A0yeW UK0073 2025-11-30T14:28:03.214Z 2025-12-06T14:56:37.426Z
8646665 8646665 20251129023747_hOyu2 UK0073 2025-11-30T14:26:38.154Z 2025-12-06T14:56:23.001Z
8646270 8646270 20251129013528_2MeKE UK0073 2025-11-30T14:25:46.054Z 2025-12-06T14:55:51.402Z
8645554 8645554 20251128224504_PWh28 UK0073 2025-11-30T14:24:01.086Z 2025-12-06T14:55:00.119Z
8645431 8645431 20251128220816_WDoHf UK0073 2025-11-30T14:23:43.387Z 2025-12-06T14:54:57.655Z
8637760 8637760 20251128063137_vwgcA UK0073 2025-11-29T14:27:48.428Z 2025-12-06T15:04:03.899Z
8637720 8637720 20251128062327_NQMQH UK0073 2025-11-29T14:27:46.002Z 2025-12-06T15:04:03.331Z
8637646 8637646 20251128060501_G8K6R UK0073 2025-11-29T14:27:39.672Z 2025-12-06T15:04:02.043Z
8637550 8637550 20251128055036_Q7RzF UK0073 2025-11-29T14:27:33.532Z 2025-12-06T15:04:01.056Z
8637373 8637373 20251128053409_CuLPc UK0073 2025-11-29T14:27:10.317Z 2025-12-06T15:03:59.392Z
8637201 8637201 20251128051500_SSiwh UK0073 2025-11-29T14:26:57.802Z 2025-12-06T15:03:57.605Z
8636935 8636935 20251128043922_VmR0p UK0073 2025-11-29T14:26:22.055Z 2025-12-06T15:03:51.213Z
8636686 8636686 20251128041712_xOKII UK0073 2025-11-29T14:26:05.126Z 2025-12-06T15:03:36.984Z
8636510 8636510 20251128035445_0uOmv UK0073 2025-11-29T14:25:36.038Z 2025-12-06T15:03:22.764Z
8636174 8636174 20251128032603_FxWZ1 UK0073 2025-11-29T14:25:00.134Z 2025-12-06T15:02:57.029Z
8635704 8635704 20251128023959_ayvhI UK0073 2025-11-29T14:24:02.616Z 2025-12-06T15:02:49.109Z
8635523 8635523 20251128022239_6933H UK0073 2025-11-29T14:23:34.686Z 2025-12-06T15:02:45.977Z
8635400 8635400 20251128020934_mX00y UK0073 2025-11-29T14:23:20.993Z 2025-12-06T15:02:44.086Z
8635078 8635078 20251128013938_zcw6X UK0073 2025-11-29T14:22:38.717Z 2025-12-06T15:02:40.406Z
8634801 8634801 20251128011953_9ieo9 UK0073 2025-11-29T14:22:04.556Z 2025-12-06T15:02:36.112Z
8634515 8634515 20251128005457_6ienv UK0073 2025-11-29T14:21:26.523Z 2025-12-06T15:02:08.711Z
8633872 8633872 20251128000034_gZfwf UK0073 2025-11-29T14:20:27.403Z 2025-12-06T15:01:49.058Z
8632915 8632915 20251127221839_AUMCr UK0073 2025-11-29T14:18:34.402Z 2025-12-06T15:01:35.529Z
8632907 8632907 20251127221747_Cny20 UK0073 2025-11-29T14:18:34.163Z 2025-12-06T15:01:35.511Z
8581315 8581315 20251122230427_1jKEx UK0073 2025-11-24T14:31:25.385Z 2025-12-01T15:20:13.451Z
8579497 8579497 20251122235641_e4kCe UK0073 2025-11-24T14:14:28.422Z 2025-12-01T15:20:29.471Z
8579221 8579221 20251122224436_7MAHv UK0073 2025-11-24T14:13:48.967Z 2025-12-01T15:20:07.606Z
8579126 8579126 20251122222712_7Q0Vl UK0073 2025-11-24T14:13:40.255Z 2025-12-01T15:20:04.373Z
8579122 8579122 20251122222614_itQCZ UK0073 2025-11-24T14:13:39.427Z 2025-12-01T15:20:03.890Z
8579094 8579094 20251122222159_Ah3bV UK0073 2025-11-24T14:13:30.293Z 2025-12-01T15:20:02.839Z
8578805 8578805 20251122212858_plqPA UK0073 2025-11-24T14:12:43.626Z 2025-12-01T15:19:53.165Z
8569731 8569731 20251121061118_5cxER UK0073 2025-11-23T14:32:26.682Z 2025-11-29T14:54:48.931Z
8569204 8569204 20251121054839_xVHM7 UK0073 2025-11-23T14:32:02.980Z 2025-11-29T14:54:47.927Z
8568652 8568652 20251121052833_eL7IP UK0073 2025-11-23T14:31:17.768Z 2025-11-29T14:54:47.156Z
8559477 8559477 20251121041209_KP6yM UK0073 2025-11-22T14:41:56.529Z 2025-11-29T14:54:39.138Z
8559433 8559433 20251121041045_LLrpn UK0073 2025-11-22T14:41:55.531Z 2025-11-29T14:54:38.509Z
8557932 8557932 20251121030928_SK44R UK0073 2025-11-22T14:40:53.887Z 2025-11-29T14:54:34.962Z
8557006 8557006 20251121022727_kAqTs UK0073 2025-11-22T14:39:49.199Z 2025-11-29T14:54:33.328Z
8556491 8556491 20251121015644_L2eIC UK0073 2025-11-22T14:39:34.529Z 2025-11-29T14:54:32.400Z
8556387 8556387 20251121015053_EKlpJ UK0073 2025-11-22T14:39:31.496Z 2025-11-29T14:54:32.200Z
8556377 8556377 20251121015053_F2kc9 UK0073 2025-11-22T14:39:31.381Z 2025-11-29T14:54:32.198Z
8555727 8555727 20251121011759_lSUmP UK0073 2025-11-22T14:38:50.049Z 2025-11-29T14:54:30.931Z
8555542 8555542 20251121011037_CJ2t2 UK0073 2025-11-22T14:38:46.623Z 2025-11-29T14:54:30.660Z
8549816 8549816 20251120225803_gqThX UK0073 2025-11-22T14:19:37.373Z 2025-11-29T14:54:25.652Z
8546871 8546871 20251120190440_uVyJ9 UK0073 2025-11-22T14:13:48.420Z 2025-11-29T14:54:17.946Z
8546425 8546425 20251120183117_YMMsX UK0073 2025-11-22T14:12:43.731Z 2025-11-29T14:54:15.330Z
8540904 8540904 20251120014209_4ktmK UK0073 2025-11-21T14:37:01.872Z 2025-11-21T14:37:01.872Z
8540583 8540583 20251120011434_zTYcJ UK0073 2025-11-21T14:36:07.753Z 2025-11-28T14:56:15.776Z
8540546 8540546 20251120011225_KCNo0 UK0073 2025-11-21T14:36:05.021Z 2025-11-28T14:56:15.374Z
8540284 8540284 20251120004932_63vgA UK0073 2025-11-21T14:35:57.063Z 2025-11-28T14:56:10.097Z
8539089 8539089 20251119230145_Qo3g8 UK0073 2025-11-21T14:34:45.482Z 2025-11-28T14:55:41.642Z
8539051 8539051 20251119225929_2a6CV UK0073 2025-11-21T14:34:43.889Z 2025-11-28T14:55:40.893Z
8538914 8538914 20251119223934_Ol2jV UK0073 2025-11-21T14:34:39.067Z 2025-11-28T14:55:39.573Z
8538616 8538616 20251119215438_C5s4R UK0073 2025-11-21T14:34:29.325Z 2025-11-28T14:55:35.470Z
8538353 8538353 20251119211614_BeC9f UK0073 2025-11-21T14:33:38.718Z 2025-11-28T14:55:25.678Z
8529842 8529842 20251118042814_4Gs2J UK0073 2025-11-20T14:45:53.826Z 2025-11-26T15:08:01.230Z
8515460 8515460 20251118042814_a2wJB UK0073 2025-11-19T14:39:46.720Z 2025-11-20T14:32:33.282Z
8510331 8510331 20251118042814_Fc0CH UK0073 2025-11-19T14:21:37.628Z 2025-11-19T14:21:37.628Z
8510039 8510039 20251118035518_W15oU UK0073 2025-11-19T14:20:59.079Z 2025-11-26T15:07:59.523Z
8509942 8509942 20251118034256_TROtk UK0073 2025-11-19T14:20:49.918Z 2025-11-26T15:07:58.825Z
8509903 8509903 20251118033953_qG5NJ UK0073 2025-11-19T14:20:45.042Z 2025-11-26T15:07:58.701Z
8508631 8508631 20251118012135_uTv0l UK0073 2025-11-19T14:18:01.108Z 2025-11-26T15:07:51.653Z
8508605 8508605 20251118011927_yKAS5 UK0073 2025-11-19T14:17:58.801Z 2025-11-26T15:07:51.522Z
8507787 8507787 20251117235716_bQ0qr UK0073 2025-11-19T14:16:05.085Z 2025-11-26T15:07:47.839Z
8507758 8507758 20251117235507_g5Tv9 UK0073 2025-11-19T14:16:00.960Z 2025-11-26T15:07:47.711Z
8496125 8496125 20251117042353_zq3Zq UK0073 2025-11-18T14:27:07.590Z 2025-11-25T15:10:09.305Z
8491942 8491942 20251116233257_4D3hx UK0073 2025-11-18T14:18:45.751Z 2025-11-25T15:08:43.416Z
8491665 8491665 20251116225504_xJXV2 UK0073 2025-11-18T14:18:05.734Z 2025-11-25T15:08:41.195Z
8489876 8489876 20251116175304_q4NM9 UK0073 2025-11-18T14:11:50.921Z 2025-11-25T15:07:46.052Z
8440119 8440119 20251112052446_qgb3k UK0073 2025-11-13T14:28:09.613Z 2025-11-20T15:25:42.450Z
8439752 8439752 20251112043217_t3B4E UK0073 2025-11-13T14:27:17.315Z 2025-11-20T15:25:31.595Z
8438822 8438822 20251112024322_4Guab UK0073 2025-11-13T14:24:59.527Z 2025-11-20T15:24:48.435Z
8437890 8437890 20251112005454_Hv22j UK0073 2025-11-13T14:22:15.724Z 2025-11-20T15:23:56.587Z
8424771 8424771 20251111004738_zA5fS UK0073 2025-11-12T14:21:13.756Z 2025-11-19T15:16:24.922Z
8407853 8407853 20251108183344_3uPG9 UK0073 2025-11-10T14:20:15.471Z 2025-11-17T14:58:08.709Z
8402736 8402736 20251108205923_ctxen UK0073 2025-11-10T14:07:32.813Z 2025-11-17T14:58:27.579Z
8402635 8402635 20251108204301_I5d5L UK0073 2025-11-10T14:07:26.191Z 2025-11-17T14:58:26.698Z
8402603 8402603 20251108203553_sFFUi UK0073 2025-11-10T14:07:23.508Z 2025-11-17T14:58:26.480Z
8402275 8402275 20251108191213_u4jxa UK0073 2025-11-10T14:06:10.564Z 2025-11-17T14:58:13.688Z
8352476 8352476 20251102005847_Zmbrc UK0073 2025-11-03T14:16:19.925Z 2025-11-10T15:06:27.675Z
8352430 8352430 20251102005608_2DO2i UK0073 2025-11-03T14:16:16.192Z 2025-11-10T15:06:24.220Z
8352232 8352232 20251102003913_kK0c5 UK0073 2025-11-03T14:15:46.346Z 2025-11-10T15:06:09.367Z
8351449 8351449 20251101230326_UdkAd UK0073 2025-11-03T14:13:39.819Z 2025-11-10T15:05:50.948Z
8343995 8343995 20251101033803_eQnJ6 UK0073 2025-11-02T14:41:45.409Z 2025-11-09T15:03:21.124Z
8336884 8336884 20251031052701_lq7Rh UK0073 2025-11-02T14:30:16.855Z 2025-11-08T15:16:16.514Z
8323928 8323928 20251030051554_cOZtO UK0073 2025-11-01T12:31:32.485Z 2025-11-07T15:16:45.123Z
8323798 8323798 20251030050946_i9NFB UK0073 2025-11-01T12:31:26.036Z 2025-11-07T15:16:22.878Z
8323603 8323603 20251030050248_vGIqj UK0073 2025-11-01T12:31:10.485Z 2025-11-07T15:16:15.510Z
8323255 8323255 20251030044644_qIqgc UK0073 2025-11-01T12:30:30.098Z 2025-11-07T15:15:55.508Z
8322987 8322987 20251030043451_h94YY UK0073 2025-11-01T12:30:18.791Z 2025-11-07T15:15:53.192Z
8322927 8322927 20251030043100_bzaxl UK0073 2025-11-01T12:30:14.971Z 2025-11-07T15:15:50.243Z
8321580 8321580 20251030034049_ozQrK UK0073 2025-11-01T12:28:02.213Z 2025-11-07T15:15:31.319Z
8320114 8320114 20251030024232_NNqqI UK0073 2025-11-01T12:25:50.477Z 2025-11-07T15:14:03.892Z
8319992 8319992 20251030023635_3LiX2 UK0073 2025-11-01T12:25:43.269Z 2025-11-07T15:13:55.596Z
8319872 8319872 20251030023205_kIGs7 UK0073 2025-11-01T12:25:20.612Z 2025-11-07T15:13:52.798Z
8319434 8319434 20251030020822_pSJ2L UK0073 2025-11-01T12:24:31.628Z 2025-11-07T15:13:41.742Z
8319362 8319362 20251030020435_7txKs UK0073 2025-11-01T12:24:25.574Z 2025-11-07T15:13:40.813Z
8314521 8314521 20251030010002_JFZNS UK0073 2025-10-31T12:39:09.227Z 2025-11-07T15:13:22.567Z
8314241 8314241 20251030004612_ZEOxh UK0073 2025-10-31T12:38:27.446Z 2025-11-07T15:13:18.982Z

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