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,489 rows where station_code = "UK0055" 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
7847308 7847308 20250916041411_SueFa UK0055 2025-09-17T12:12:53.002Z 2025-09-24T13:16:00.632Z
7846374 7846374 20250916025849_o7X1b UK0055 2025-09-17T12:10:07.460Z 2025-09-24T13:15:50.352Z
7846126 7846126 20250916024329_fjpbw UK0055 2025-09-17T12:09:26.250Z 2025-09-24T13:15:48.874Z
7829245 7829245 20250913200610_9p9EU UK0055 2025-09-15T12:18:03.518Z 2025-09-21T13:09:56.880Z
7828171 7828171 20250914035839_ibUGV UK0055 2025-09-15T12:09:20.013Z 2025-09-22T13:07:28.790Z
7828139 7828139 20250914035606_A5fRp UK0055 2025-09-15T12:09:09.596Z 2025-09-22T13:07:28.140Z
7827953 7827953 20250914032356_MaP7W UK0055 2025-09-15T12:08:46.166Z 2025-09-22T13:07:21.116Z
7827419 7827419 20250914022631_47uN2 UK0055 2025-09-15T12:07:34.935Z 2025-09-22T13:07:09.911Z
7827180 7827180 20250914020327_abMWA UK0055 2025-09-15T12:07:01.537Z 2025-09-22T13:07:05.045Z
7826916 7826916 20250914014325_zN56x UK0055 2025-09-15T12:06:24.328Z 2025-09-22T13:06:57.434Z
7826585 7826585 20250914011708_2lhrU UK0055 2025-09-15T12:05:37.357Z 2025-09-22T13:06:48.475Z
7826046 7826046 20250914002314_l7hqX UK0055 2025-09-15T12:04:30.607Z 2025-09-22T13:06:37.877Z
7826033 7826033 20250914002124_l3al2 UK0055 2025-09-15T12:04:26.538Z 2025-09-22T13:06:37.766Z
7825659 7825659 20250913235110_iBPty UK0055 2025-09-15T12:03:28.377Z 2025-09-22T13:06:29.736Z
7825541 7825541 20250913233647_1DBXp UK0055 2025-09-15T12:03:05.404Z 2025-09-22T13:06:27.666Z
7825395 7825395 20250913232356_PCl2B UK0055 2025-09-15T12:02:43.488Z 2025-09-22T13:06:23.477Z
7825272 7825272 20250913231031_8f2eS UK0055 2025-09-15T12:02:18.552Z 2025-09-22T13:06:21.832Z
7825205 7825205 20250913230426_SCLHS UK0055 2025-09-15T12:02:07.841Z 2025-09-22T13:06:20.642Z
7825071 7825071 20250913224824_xzoA9 UK0055 2025-09-15T12:01:44.170Z 2025-09-22T13:06:18.263Z
7804793 7804793 20250910235605_dBivb UK0055 2025-09-12T12:03:40.248Z 2025-09-19T12:56:49.077Z
7794975 7794975 20250909002905_4qV5S UK0055 2025-09-10T12:05:49.931Z 2025-09-17T12:56:26.729Z
7794507 7794507 20250908230524_bfZVv UK0055 2025-09-10T12:04:25.649Z 2025-09-17T12:56:19.559Z
7794016 7794016 20250908214529_itQEF UK0055 2025-09-10T12:03:10.142Z 2025-09-17T12:56:17.399Z
7793998 7793998 20250908214139_KP9FM UK0055 2025-09-10T12:03:07.612Z 2025-09-17T12:56:17.288Z
7793991 7793991 20250908213404_34464 UK0055 2025-09-10T12:03:05.698Z 2025-09-17T12:56:17.245Z
7772648 7772648 20250905023152_EmMiS UK0055 2025-09-06T13:15:02.315Z 2025-09-13T12:57:40.711Z
7772607 7772607 20250905023016_dyObX UK0055 2025-09-06T13:14:51.490Z 2025-09-13T12:57:40.280Z
7772526 7772526 20250905022727_pJdzp UK0055 2025-09-06T13:14:40.919Z 2025-09-13T12:57:36.077Z
7772075 7772075 20250905020759_gsDG3 UK0055 2025-09-06T13:13:10.293Z 2025-09-13T12:57:26.979Z
7768269 7768269 20250904214902_Rg6oM UK0055 2025-09-06T12:37:13.945Z 2025-09-13T12:55:29.594Z
7768266 7768266 20250904214756_zpgvX UK0055 2025-09-06T12:37:09.275Z 2025-09-13T12:55:29.567Z
7767895 7767895 20250904205849_Ah9aR UK0055 2025-09-06T12:31:42.495Z 2025-09-13T12:55:17.578Z
7767851 7767851 20250904205324_HVf9A UK0055 2025-09-06T12:31:27.810Z 2025-09-13T12:55:14.559Z
7750067 7750067 20250902230744_K8zNH UK0055 2025-09-04T12:12:20.101Z 2025-09-11T12:43:39.748Z
7749518 7749518 20250902204257_T2R0Q UK0055 2025-09-04T12:10:23.264Z 2025-09-11T12:43:35.203Z
7740368 7740368 20250902001137_BYshf UK0055 2025-09-03T12:17:53.131Z 2025-09-10T12:46:25.885Z
7726532 7726532 20250831223451_719D8 UK0055 2025-09-02T12:18:39.987Z 2025-09-09T12:47:29.862Z
7716168 7716168 20250831032650_Bqe22 UK0055 2025-09-01T12:22:15.508Z 2025-09-08T12:53:07.476Z
7715881 7715881 20250831031401_yVbNk UK0055 2025-09-01T12:21:54.455Z 2025-09-08T12:52:57.766Z
7680850 7680850 20250827214502_Lkq2d UK0055 2025-08-29T12:15:34.098Z 2025-09-05T13:05:04.393Z
7670777 7670777 20250826220432_K27O9 UK0055 2025-08-28T12:18:57.045Z 2025-09-04T12:56:02.645Z
7669961 7669961 20250826205901_BU083 UK0055 2025-08-28T12:17:02.737Z 2025-09-04T12:55:39.707Z
7648809 7648809 20250825013930_OaGuk UK0055 2025-08-26T12:29:41.912Z 2025-09-02T12:52:04.516Z
7647495 7647495 20250825004252_5gxzU UK0055 2025-08-26T12:27:26.795Z 2025-09-02T12:51:56.582Z
7646851 7646851 20250825000820_qa4dB UK0055 2025-08-26T12:26:05.272Z 2025-09-02T12:51:52.153Z
7646756 7646756 20250825000221_396Jl UK0055 2025-08-26T12:25:57.083Z 2025-09-02T12:51:51.813Z
7646598 7646598 20250824235229_TKev5 UK0055 2025-08-26T12:25:32.268Z 2025-09-02T12:51:51.159Z
7646592 7646592 20250824235228_fwKGy UK0055 2025-08-26T12:25:32.121Z 2025-09-02T12:51:51.156Z
7645892 7645892 20250824230912_JmRPI UK0055 2025-08-26T12:24:06.711Z 2025-09-02T12:51:47.046Z
7645815 7645815 20250824230259_yU8rG UK0055 2025-08-26T12:24:01.437Z 2025-09-02T12:51:46.937Z
7645358 7645358 20250824222723_8pz6G UK0055 2025-08-26T12:22:52.679Z 2025-09-02T12:51:39.936Z
7645105 7645105 20250824221019_1baZK UK0055 2025-08-26T12:22:13.414Z 2025-09-02T12:51:38.455Z
7644707 7644707 20250824213001_rs9w4 UK0055 2025-08-26T12:21:04.855Z 2025-09-02T12:51:30.806Z
7644662 7644662 20250824212539_tvaVU UK0055 2025-08-26T12:20:56.041Z 2025-09-02T12:51:30.523Z
7644611 7644611 20250824212046_bjdIz UK0055 2025-08-26T12:20:50.592Z 2025-09-02T12:51:29.260Z
7637836 7637836 20250824030221_VK391 UK0055 2025-08-25T12:30:06.306Z 2025-09-01T12:56:12.092Z
7637708 7637708 20250824025533_IMC0M UK0055 2025-08-25T12:30:00.813Z 2025-09-01T12:56:11.979Z
7637454 7637454 20250824023909_5lGt2 UK0055 2025-08-25T12:29:48.738Z 2025-09-01T12:56:11.534Z
7637389 7637389 20250824023532_2yVtB UK0055 2025-08-25T12:29:45.099Z 2025-09-01T12:56:11.491Z
7610410 7610410 20250821223443_sizMU UK0055 2025-08-23T12:20:49.244Z 2025-08-30T12:59:21.024Z
7610400 7610400 20250821223336_4vpSp UK0055 2025-08-23T12:20:47.984Z 2025-08-30T12:59:21.004Z
7610398 7610398 20250821223325_iyGWq UK0055 2025-08-23T12:20:47.775Z 2025-08-30T12:59:20.991Z
7609967 7609967 20250821220103_uQpIc UK0055 2025-08-23T12:19:59.618Z 2025-08-30T12:59:17.161Z
7609829 7609829 20250821215257_T4Bx3 UK0055 2025-08-23T12:19:53.168Z 2025-08-30T12:59:15.632Z
7575658 7575658 20250818003648_uBTwl UK0055 2025-08-20T12:38:09.510Z 2025-08-25T12:52:21.090Z
7575397 7575397 20250818001632_UByHN UK0055 2025-08-20T12:37:46.402Z 2025-08-25T12:52:19.028Z
7575213 7575213 20250818000346_22bG0 UK0055 2025-08-20T12:37:34.896Z 2025-08-25T12:52:16.343Z
7574277 7574277 20250817230706_RjCmk UK0055 2025-08-20T12:36:12.983Z 2025-08-25T12:52:09.779Z
7574204 7574204 20250817230151_Mngkf UK0055 2025-08-20T12:36:07.668Z 2025-08-25T12:52:09.227Z
7573869 7573869 20250817224410_AeCjo UK0055 2025-08-20T12:35:48.582Z 2025-08-25T12:52:08.529Z
7573815 7573815 20250817224050_Hc3An UK0055 2025-08-20T12:35:36.220Z 2025-08-25T12:52:08.471Z
7573562 7573562 20250817222249_mzsSA UK0055 2025-08-20T12:35:19.391Z 2025-08-25T12:52:08.140Z
7573464 7573464 20250817221544_EMwtW UK0055 2025-08-20T12:35:13.330Z 2025-08-25T12:52:07.948Z
7573177 7573177 20250817215313_bAt1d UK0055 2025-08-20T12:34:46.870Z 2025-08-25T12:52:07.213Z
7572923 7572923 20250817213443_UDFmL UK0055 2025-08-20T12:34:21.485Z 2025-08-25T12:52:06.507Z
7572833 7572833 20250817212728_bUqdv UK0055 2025-08-20T12:34:12.750Z 2025-08-25T12:52:06.277Z
7564659 7564659 20250818005521_c2TmV UK0055 2025-08-20T12:00:42.607Z 2025-08-27T13:12:56.323Z
7563614 7563614 20250816234354_h99HU UK0055 2025-08-19T13:03:28.626Z 2025-08-24T12:49:04.971Z
7562661 7562661 20250816230825_wRo0x UK0055 2025-08-19T13:01:56.350Z 2025-08-24T12:49:00.605Z
7561485 7561485 20250816220806_1IuVG UK0055 2025-08-19T12:59:34.698Z 2025-08-24T12:48:52.832Z
7554755 7554755 20250817031818_9PIS4 UK0055 2025-08-19T12:24:24.420Z 2025-08-25T12:51:48.191Z
7554664 7554664 20250817031511_nbABY UK0055 2025-08-19T12:24:16.798Z 2025-08-25T12:51:48.107Z
7554231 7554231 20250817025558_RSfJ3 UK0055 2025-08-19T12:23:16.754Z 2025-08-25T12:51:47.570Z
7553937 7553937 20250817024028_F2TRR UK0055 2025-08-19T12:22:33.644Z 2025-08-25T12:51:46.979Z
7553409 7553409 20250817021509_wHcj1 UK0055 2025-08-19T12:21:16.939Z 2025-08-25T12:51:46.058Z
7552541 7552541 20250817014613_kBUru UK0055 2025-08-19T12:18:07.045Z 2025-08-25T12:51:44.765Z
7552154 7552154 20250817013056_o4ry0 UK0055 2025-08-19T12:16:09.969Z 2025-08-25T12:51:44.020Z
7551069 7551069 20250817004510_atIlX UK0055 2025-08-19T12:10:00.310Z 2025-08-25T12:51:41.972Z
7550963 7550963 20250817004150_2T4ba UK0055 2025-08-19T12:09:34.724Z 2025-08-25T12:51:41.818Z
7550639 7550639 20250817002721_U3MtW UK0055 2025-08-19T12:07:20.922Z 2025-08-25T12:51:41.224Z
7550364 7550364 20250817001758_nOC5k UK0055 2025-08-19T12:05:50.383Z 2025-08-25T12:51:40.687Z
7550215 7550215 20250817001204_d2AhD UK0055 2025-08-19T12:04:45.820Z 2025-08-25T12:51:40.376Z
7529282 7529282 20250814215155_29eiJ UK0055 2025-08-17T12:49:52.904Z 2025-08-22T12:47:35.454Z
7528901 7528901 20250814213919_NNcnK UK0055 2025-08-17T12:49:42.146Z 2025-08-22T12:47:34.903Z
7528813 7528813 20250814213559_AHco2 UK0055 2025-08-17T12:49:39.916Z 2025-08-22T12:47:34.832Z
7528498 7528498 20250814212402_jtujM UK0055 2025-08-17T12:49:30.357Z 2025-08-22T12:47:34.400Z
7521168 7521168 20250815030832_yhMCY UK0055 2025-08-17T12:20:46.800Z 2025-08-23T12:48:48.114Z
7520751 7520751 20250815024923_3QJQw UK0055 2025-08-17T12:20:01.556Z 2025-08-23T12:48:47.530Z
7520197 7520197 20250815023128_vv7Xw UK0055 2025-08-17T12:19:13.321Z 2025-08-17T12:19:13.321Z
7517081 7517081 20250815004313_6woJo UK0055 2025-08-17T12:13:07.081Z 2025-08-23T12:48:33.920Z

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