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

1,732 rows where station_code = "UK00D6" 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
9273466 9273466 20260128062356_aHmQi UK00D6 2026-01-29T14:29:51.972Z 2026-01-29T14:30:25.819Z
9273375 9273375 20260128055439_ihrXX UK00D6 2026-01-29T14:29:29.384Z 2026-01-29T14:30:25.797Z
9273366 9273366 20260128055136_XH6va UK00D6 2026-01-29T14:29:28.247Z 2026-01-29T14:30:25.795Z
9273248 9273248 20260128051329_q6Rrx UK00D6 2026-01-29T14:29:11.696Z 2026-01-29T14:30:25.775Z
9272987 9272987 20260128041506_ixChu UK00D6 2026-01-29T14:28:22.422Z 2026-01-29T14:30:25.729Z
9272858 9272858 20260128035108_3VaGp UK00D6 2026-01-29T14:28:03.673Z 2026-01-29T14:30:25.583Z
9272793 9272793 20260128033820_vf4lS UK00D6 2026-01-29T14:27:50.580Z 2026-01-29T14:30:25.562Z
9272776 9272776 20260128032618_PO19j UK00D6 2026-01-29T14:27:46.594Z 2026-01-29T14:30:25.552Z
9272774 9272774 20260128032555_6UMER UK00D6 2026-01-29T14:27:46.103Z 2026-01-29T14:30:25.551Z
9272753 9272753 20260128031610_QyJGA UK00D6 2026-01-29T14:27:42.111Z 2026-01-29T14:30:25.447Z
9272725 9272725 20260128031058_EX559 UK00D6 2026-01-29T14:27:37.627Z 2026-01-29T14:30:25.443Z
9272551 9272551 20260128023420_c8iQ9 UK00D6 2026-01-29T14:27:08.661Z 2026-01-29T14:30:25.376Z
9272500 9272500 20260128021831_Ge4OP UK00D6 2026-01-29T14:26:59.854Z 2026-01-29T14:30:25.356Z
9272304 9272304 20260128012940_HLLk2 UK00D6 2026-01-29T14:26:21.961Z 2026-01-29T14:30:25.324Z
9272190 9272190 20260128003802_Jzh0t UK00D6 2026-01-29T14:25:53.252Z 2026-01-29T14:30:25.296Z
9272035 9272035 20260127231054_3TOsT UK00D6 2026-01-29T14:25:21.445Z 2026-01-29T14:30:25.267Z
9272003 9272003 20260127225541_PIXBx UK00D6 2026-01-29T14:25:16.603Z 2026-01-29T14:30:25.262Z
9271972 9271972 20260127223911_IO1va UK00D6 2026-01-29T14:25:11.342Z 2026-01-29T14:30:25.256Z
9271968 9271968 20260127223127_QctJh UK00D6 2026-01-29T14:25:10.270Z 2026-01-29T14:30:25.255Z
9271921 9271921 20260127214944_32Sgy UK00D6 2026-01-29T14:24:55.386Z 2026-01-29T14:30:25.229Z
9260309 9260309 20260125033412_Q2qm3 UK00D6 2026-01-26T14:21:07.965Z 2026-01-29T14:44:04.898Z
9259619 9259619 20260124221850_Xql8f UK00D6 2026-01-26T14:17:42.620Z 2026-01-29T14:43:09.362Z
9259599 9259599 20260124215243_0lfd3 UK00D6 2026-01-26T14:17:33.930Z 2026-01-29T14:43:08.105Z
9259428 9259428 20260124204509_x2Hqx UK00D6 2026-01-26T14:16:58.160Z 2026-01-29T14:42:54.170Z
9259158 9259158 20260124191249_XEj2O UK00D6 2026-01-26T14:15:56.405Z 2026-01-29T14:42:39.725Z
9259019 9259019 20260124182350_tE4R6 UK00D6 2026-01-26T14:15:26.567Z 2026-01-29T14:42:26.328Z
9256249 9256249 20260124062917_563K7 UK00D6 2026-01-25T14:16:18.190Z 2026-01-29T14:48:30.796Z
9255819 9255819 20260124050301_jExt1 UK00D6 2026-01-25T14:14:53.967Z 2026-01-29T14:47:59.706Z
9255684 9255684 20260124042944_NsbL4 UK00D6 2026-01-25T14:14:16.971Z 2026-01-29T14:47:50.858Z
9255633 9255633 20260124042240_OAv2G UK00D6 2026-01-25T14:14:08.478Z 2026-01-29T14:47:48.387Z
9255613 9255613 20260124041934_lP5px UK00D6 2026-01-25T14:14:06.308Z 2026-01-29T14:47:42.683Z
9255585 9255585 20260124041700_bbM6S UK00D6 2026-01-25T14:14:01.909Z 2026-01-29T14:47:41.270Z
9255576 9255576 20260124041525_cuoME UK00D6 2026-01-25T14:14:00.633Z 2026-01-29T14:47:40.859Z
9255508 9255508 20260124035249_WaIk2 UK00D6 2026-01-25T14:13:42.850Z 2026-01-29T14:47:35.007Z
9255495 9255495 20260124035105_fDLtJ UK00D6 2026-01-25T14:13:37.824Z 2026-01-29T14:47:34.146Z
9255238 9255238 20260124015935_mUDcT UK00D6 2026-01-25T14:12:29.265Z 2026-01-29T14:47:11.717Z
9255211 9255211 20260124014642_Ta21h UK00D6 2026-01-25T14:12:23.327Z 2026-01-29T14:47:10.175Z
9255200 9255200 20260124013610_Klqnw UK00D6 2026-01-25T14:12:15.973Z 2026-01-29T14:47:07.766Z
9255155 9255155 20260124012046_2u358 UK00D6 2026-01-25T14:12:04.043Z 2026-01-29T14:47:04.997Z
9255149 9255149 20260124011831_CEMPO UK00D6 2026-01-25T14:12:03.037Z 2026-01-29T14:47:04.745Z
9255080 9255080 20260124004212_oSlKU UK00D6 2026-01-25T14:11:47.375Z 2026-01-29T14:47:01.509Z
9254950 9254950 20260123232635_G4cpg UK00D6 2026-01-25T14:11:25.791Z 2026-01-29T14:46:56.801Z
9254904 9254904 20260123222609_jrzin UK00D6 2026-01-25T14:11:11.357Z 2026-01-29T14:46:54.378Z
9254751 9254751 20260123210834_dXyyI UK00D6 2026-01-25T14:10:34.558Z 2026-01-29T14:46:40.837Z
9254745 9254745 20260123210743_pnX2u UK00D6 2026-01-25T14:10:32.917Z 2026-01-29T14:46:38.434Z
9254670 9254670 20260123204125_NgFjt UK00D6 2026-01-25T14:10:18.327Z 2026-01-29T14:46:34.805Z
9254628 9254628 20260123203101_rmhbu UK00D6 2026-01-25T14:10:05.426Z 2026-01-29T14:46:32.785Z
9254418 9254418 20260123190645_lX0Qf UK00D6 2026-01-25T14:09:04.250Z 2026-01-29T14:46:14.858Z
9252258 9252258 20260123015822_Vtc6C UK00D6 2026-01-24T14:14:51.988Z 2026-01-29T14:52:42.264Z
9228117 9228117 20260118195720_ebYoU UK00D6 2026-01-20T14:16:06.326Z 2026-01-27T15:01:27.232Z
9217696 9217696 20260116190837_vP7aI UK00D6 2026-01-18T14:08:34.154Z 2026-01-25T14:57:44.685Z
9214201 9214201 20260116055334_Pc4gj UK00D6 2026-01-17T14:20:33.894Z 2026-01-24T15:13:22.110Z
9214159 9214159 20260116054809_O2di3 UK00D6 2026-01-17T14:20:21.685Z 2026-01-24T15:13:18.812Z
9213830 9213830 20260116044904_4rwrz UK00D6 2026-01-17T14:18:43.582Z 2026-01-24T15:12:48.273Z
9213805 9213805 20260116044512_8UD9g UK00D6 2026-01-17T14:18:38.702Z 2026-01-24T15:12:47.259Z
9213758 9213758 20260116043522_8p3jo UK00D6 2026-01-17T14:18:23.353Z 2026-01-24T15:12:44.388Z
9213550 9213550 20260116040037_fkXws UK00D6 2026-01-17T14:17:29.760Z 2026-01-24T15:12:21.472Z
9213503 9213503 20260116034754_w0foT UK00D6 2026-01-17T14:17:13.002Z 2026-01-24T15:12:18.555Z
9213391 9213391 20260116031932_DmUDP UK00D6 2026-01-17T14:16:42.516Z 2026-01-24T15:12:11.614Z
9213236 9213236 20260116024220_ide4t UK00D6 2026-01-17T14:16:00.976Z 2026-01-24T15:11:50.678Z
9212952 9212952 20260116014242_ZLFFc UK00D6 2026-01-17T14:14:43.918Z 2026-01-24T15:11:35.507Z
9212931 9212931 20260116014029_MXGMO UK00D6 2026-01-17T14:14:38.707Z 2026-01-24T15:11:34.617Z
9205590 9205590 20260114061742_Ct2Gb UK00D6 2026-01-15T14:31:35.992Z 2026-01-22T15:10:22.860Z
9204238 9204238 20260114061741_awTup UK00D6 2026-01-15T14:26:52.205Z 2026-01-22T15:10:22.686Z
9204203 9204203 20260114061511_qj5r9 UK00D6 2026-01-15T14:26:39.746Z 2026-01-22T15:10:22.276Z
9204194 9204194 20260114061408_I5cfw UK00D6 2026-01-15T14:26:38.294Z 2026-01-22T15:10:22.038Z
9203856 9203856 20260114054440_74pV3 UK00D6 2026-01-15T14:25:41.322Z 2026-01-22T15:10:14.335Z
9203684 9203684 20260114052855_KbsHh UK00D6 2026-01-15T14:25:11.086Z 2026-01-22T15:10:12.132Z
9203450 9203450 20260114045753_o2Z5k UK00D6 2026-01-15T14:24:27.377Z 2026-01-22T15:10:07.992Z
9203391 9203391 20260114045330_VR2Cb UK00D6 2026-01-15T14:24:12.911Z 2026-01-22T15:10:06.675Z
9202650 9202650 20260114035750_wiXep UK00D6 2026-01-15T14:21:55.461Z 2026-01-22T15:09:24.294Z
9180222 9180222 20260110193933_YNK7T UK00D6 2026-01-12T14:06:16.752Z 2026-01-19T15:15:52.162Z
9171507 9171507 20260108222546_31xx8 UK00D6 2026-01-10T14:07:47.410Z 2026-01-17T15:24:04.337Z
9166617 9166617 20260107192901_oaMVY UK00D6 2026-01-09T14:04:05.968Z 2026-01-16T15:10:06.599Z
9160604 9160604 20260106063127_NipS0 UK00D6 2026-01-07T14:13:07.831Z 2026-01-13T15:09:34.882Z
9160427 9160427 20260106055137_ZvHp1 UK00D6 2026-01-07T14:12:35.894Z 2026-01-13T15:09:25.841Z
9160408 9160408 20260106054621_KvRGM UK00D6 2026-01-07T14:12:30.430Z 2026-01-13T15:09:24.918Z
9160171 9160171 20260106045618_V07L1 UK00D6 2026-01-07T14:11:37.992Z 2026-01-13T15:09:05.786Z
9158268 9158268 20260105213413_YuWig UK00D6 2026-01-07T14:05:36.604Z 2026-01-13T15:07:15.860Z
9157947 9157947 20260105193145_dMTq1 UK00D6 2026-01-07T14:04:17.443Z 2026-01-13T15:06:47.385Z
9157943 9157943 20260105193103_R3O6Y UK00D6 2026-01-07T14:04:16.325Z 2026-01-13T15:06:47.230Z
9156033 9156033 20260104063848_AsMyH UK00D6 2026-01-06T14:38:25.879Z 2026-01-12T15:11:34.991Z
9155917 9155917 20260104063059_M1v8s UK00D6 2026-01-06T14:38:11.448Z 2026-01-12T15:11:32.039Z
9155664 9155664 20260104061106_sSD6K UK00D6 2026-01-06T14:37:52.694Z 2026-01-12T15:11:23.471Z
9155660 9155660 20260104061105_U7qJ1 UK00D6 2026-01-06T14:37:52.578Z 2026-01-12T15:11:23.421Z
9155538 9155538 20260104060152_VY6GS UK00D6 2026-01-06T14:37:30.305Z 2026-01-12T15:11:06.253Z
9155502 9155502 20260104055835_trJji UK00D6 2026-01-06T14:37:26.160Z 2026-01-12T15:11:04.619Z
9155110 9155110 20260104053608_JQjsu UK00D6 2026-01-06T14:36:49.493Z 2026-01-12T15:10:49.770Z
9155010 9155010 20260104053049_Ktkyc UK00D6 2026-01-06T14:36:29.996Z 2026-01-12T15:10:40.752Z
9154985 9154985 20260104052831_rJpw4 UK00D6 2026-01-06T14:36:27.930Z 2026-01-12T15:10:29.023Z
9154862 9154862 20260104052022_VPw3g UK00D6 2026-01-06T14:36:17.841Z 2026-01-12T15:10:22.870Z
9154841 9154841 20260104051921_zwzkc UK00D6 2026-01-06T14:36:15.731Z 2026-01-12T15:10:22.041Z
9154729 9154729 20260104051122_Yp0r3 UK00D6 2026-01-06T14:36:07.066Z 2026-01-12T15:10:18.048Z
9154697 9154697 20260104050955_6ErCe UK00D6 2026-01-06T14:35:58.259Z 2026-01-12T15:10:16.325Z
9154670 9154670 20260104050703_a2iLC UK00D6 2026-01-06T14:35:50.745Z 2026-01-12T15:10:14.240Z
9154457 9154457 20260104045800_biE6R UK00D6 2026-01-06T14:35:35.656Z 2026-01-12T15:10:01.862Z
9154428 9154428 20260104045636_pk9BW UK00D6 2026-01-06T14:35:34.306Z 2026-01-12T15:09:50.809Z
9154417 9154417 20260104045613_EfXvf UK00D6 2026-01-06T14:35:33.690Z 2026-01-12T15:09:50.342Z
9154054 9154054 20260104043231_qoYp7 UK00D6 2026-01-06T14:34:42.260Z 2026-01-12T15:09:33.939Z
9154023 9154023 20260104043102_D1bck UK00D6 2026-01-06T14:34:39.786Z 2026-01-12T15:09:32.259Z

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