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

4,721 rows where station_code = "UK000J" 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
9167251 9167251 20260107235630_LPbkL UK000J 2026-01-09T14:06:53.423Z 2026-01-16T15:10:58.517Z
9167125 9167125 20260107225322_H0vyl UK000J 2026-01-09T14:06:22.308Z 2026-01-16T15:10:51.364Z
9167096 9167096 20260107224133_mfsPc UK000J 2026-01-09T14:06:15.487Z 2026-01-16T15:10:49.790Z
9166762 9166762 20260107201322_vbcSj UK000J 2026-01-09T14:04:48.664Z 2026-01-16T15:10:22.759Z
9166724 9166724 20260107200213_O8KnX UK000J 2026-01-09T14:04:37.439Z 2026-01-16T15:10:21.220Z
9166597 9166597 20260107192522_uKQ7G UK000J 2026-01-09T14:03:59.381Z 2026-01-16T15:10:05.400Z
9166361 9166361 20260107180139_ma956 UK000J 2026-01-09T14:02:52.391Z 2026-01-16T15:09:49.529Z
9166204 9166204 20260107171907_DPNNp UK000J 2026-01-09T14:02:07.943Z 2026-01-16T15:09:31.651Z
9163438 9163438 20260107064024_uWf7u UK000J 2026-01-08T14:09:10.481Z 2026-01-13T15:03:15.746Z
9163376 9163376 20260107062742_jmmmY UK000J 2026-01-08T14:08:58.168Z 2026-01-13T15:03:11.363Z
9163244 9163244 20260107061243_itZ8p UK000J 2026-01-08T14:08:36.866Z 2026-01-13T15:03:07.172Z
9160298 9160298 20260106052550_iR2gx UK000J 2026-01-07T14:12:09.989Z 2026-01-13T15:09:19.136Z
9159926 9159926 20260106041848_1qW6Y UK000J 2026-01-07T14:10:52.550Z 2026-01-13T15:08:53.339Z
9159699 9159699 20260106032957_hyMQT UK000J 2026-01-07T14:10:07.895Z 2026-01-13T15:08:37.687Z
9158388 9158388 20260105221436_rfk83 UK000J 2026-01-07T14:05:54.852Z 2026-01-13T15:07:20.161Z
9158312 9158312 20260105215426_Gk3LJ UK000J 2026-01-07T14:05:44.450Z 2026-01-13T15:07:18.042Z
9158158 9158158 20260105203522_Vd46p UK000J 2026-01-07T14:05:07.091Z 2026-01-13T15:07:00.481Z
9158059 9158059 20260105194827_AWukz UK000J 2026-01-07T14:04:39.800Z 2026-01-13T15:06:52.175Z
9157994 9157994 20260105193629_J7I23 UK000J 2026-01-07T14:04:25.353Z 2026-01-13T15:06:48.910Z
9157906 9157906 20260105192433_qeyTh UK000J 2026-01-07T14:04:08.645Z 2026-01-13T15:06:45.200Z
9157719 9157719 20260105183157_xj2pt UK000J 2026-01-07T14:03:19.435Z 2026-01-13T15:06:25.853Z
9157694 9157694 20260105182448_r2Rhz UK000J 2026-01-07T14:03:12.127Z 2026-01-13T15:06:24.521Z
9154130 9154130 20260104044001_Edho1 UK000J 2026-01-06T14:34:49.929Z 2026-01-12T15:09:37.943Z
9151836 9151836 20260105064239_S52ja UK000J 2026-01-06T14:14:53.297Z 2026-01-13T15:15:08.800Z
9151672 9151672 20260105061655_DjjId UK000J 2026-01-06T14:14:22.231Z 2026-01-13T15:15:00.763Z
9151616 9151616 20260105060322_6PZ86 UK000J 2026-01-06T14:14:10.243Z 2026-01-13T15:14:57.872Z
9151413 9151413 20260105052851_40uYq UK000J 2026-01-06T14:13:36.395Z 2026-01-13T15:14:41.676Z
9151186 9151186 20260105045019_UijnM UK000J 2026-01-06T14:12:53.096Z 2026-01-13T15:14:30.382Z
9151164 9151164 20260105044819_iLGqL UK000J 2026-01-06T14:12:49.476Z 2026-01-13T15:14:29.509Z
9151101 9151101 20260105044146_FHi93 UK000J 2026-01-06T14:12:36.210Z 2026-01-13T15:14:19.094Z
9151037 9151037 20260105042600_PMUIk UK000J 2026-01-06T14:12:25.842Z 2026-01-13T15:14:16.026Z
9151003 9151003 20260105041506_oBfVT UK000J 2026-01-06T14:12:17.176Z 2026-01-13T15:14:13.048Z
9150884 9150884 20260105035429_N7Y6Q UK000J 2026-01-06T14:11:48.556Z 2026-01-13T15:14:06.143Z
9150834 9150834 20260105033843_o9Xum UK000J 2026-01-06T14:11:36.060Z 2026-01-13T15:14:03.534Z
9150832 9150832 20260105033830_CRGQ3 UK000J 2026-01-06T14:11:35.497Z 2026-01-13T15:14:03.371Z
9148852 9148852 20260104174034_b4SKz UK000J 2026-01-06T14:02:39.026Z 2026-01-13T15:11:22.305Z
9148283 9148283 20260103173852_IiCbI UK000J 2026-01-05T14:30:23.982Z 2026-01-10T15:04:24.844Z
9148020 9148020 20260103172750_0VqYI UK000J 2026-01-05T14:30:14.489Z 2026-01-10T15:04:12.918Z
9147991 9147991 20260103172642_xGJQS UK000J 2026-01-05T14:30:04.165Z 2026-01-10T15:04:11.581Z
9147666 9147666 20260104062647_Zgof0 UK000J 2026-01-05T14:24:41.568Z 2026-01-12T15:11:30.252Z
9147515 9147515 20260104060035_y453D UK000J 2026-01-05T14:24:19.977Z 2026-01-12T15:11:05.337Z
9147425 9147425 20260104054939_Ds4dP UK000J 2026-01-05T14:24:09.148Z 2026-01-12T15:10:56.038Z
9147373 9147373 20260104054200_kVml9 UK000J 2026-01-05T14:24:06.679Z 2026-01-12T15:10:52.804Z
9147354 9147354 20260104053704_IB7IC UK000J 2026-01-05T14:24:05.803Z 2026-01-12T15:10:50.148Z
9147228 9147228 20260104052026_Cd3pQ UK000J 2026-01-05T14:23:53.580Z 2026-01-12T15:10:22.914Z
9147093 9147093 20260104050300_c7HrI UK000J 2026-01-05T14:23:27.297Z 2026-01-12T15:10:11.040Z
9147076 9147076 20260104050213_MW9Z4 UK000J 2026-01-05T14:23:26.689Z 2026-01-12T15:10:10.301Z
9147041 9147041 20260104045717_HcNlm UK000J 2026-01-05T14:23:24.424Z 2026-01-12T15:09:51.214Z
9147008 9147008 20260104045445_1uF05 UK000J 2026-01-05T14:23:22.815Z 2026-01-12T15:09:49.282Z
9146918 9146918 20260104044342_9ihG8 UK000J 2026-01-05T14:23:16.323Z 2026-01-12T15:09:41.089Z
9146898 9146898 20260104044201_s2bAV UK000J 2026-01-05T14:23:14.419Z 2026-01-12T15:09:39.836Z
9146761 9146761 20260104042435_n1oQb UK000J 2026-01-05T14:22:49.269Z 2026-01-12T15:09:23.028Z
9146675 9146675 20260104041459_ybPHT UK000J 2026-01-05T14:22:41.429Z 2026-01-12T15:09:05.664Z
9146655 9146655 20260104041157_iZ3cF UK000J 2026-01-05T14:22:40.141Z 2026-01-12T15:09:04.048Z
9146632 9146632 20260104041013_roGlI UK000J 2026-01-05T14:22:37.826Z 2026-01-12T15:09:02.447Z
9146564 9146564 20260104040100_ISFyP UK000J 2026-01-05T14:22:31.223Z 2026-01-12T15:08:55.736Z
9146562 9146562 20260104040054_QQkPm UK000J 2026-01-05T14:22:31.003Z 2026-01-12T15:08:55.524Z
9146526 9146526 20260104035800_otduR UK000J 2026-01-05T14:22:21.180Z 2026-01-12T15:08:51.345Z
9146476 9146476 20260104035304_ImWfw UK000J 2026-01-05T14:22:18.765Z 2026-01-12T15:08:34.213Z
9146459 9146459 20260104035217_3uAcL UK000J 2026-01-05T14:22:16.067Z 2026-01-12T15:08:33.349Z
9146413 9146413 20260104034920_lD3un UK000J 2026-01-05T14:22:13.028Z 2026-01-12T15:08:28.807Z
9146351 9146351 20260104034639_h3dsa UK000J 2026-01-05T14:22:08.423Z 2026-01-12T15:08:26.423Z
9146029 9146029 20260104033428_johgt UK000J 2026-01-05T14:21:34.822Z 2026-01-12T15:08:18.505Z
9145902 9145902 20260104033047_9e3pB UK000J 2026-01-05T14:21:24.966Z 2026-01-12T15:08:15.396Z
9145889 9145889 20260104033027_gqPa6 UK000J 2026-01-05T14:21:24.177Z 2026-01-12T15:08:15.083Z
9145825 9145825 20260104032855_gtIiK UK000J 2026-01-05T14:21:20.154Z 2026-01-12T15:08:02.151Z
9145692 9145692 20260104032522_R8aUL UK000J 2026-01-05T14:21:04.343Z 2026-01-12T15:07:58.480Z
9145120 9145120 20260104030515_9hK7R UK000J 2026-01-05T14:20:12.210Z 2026-01-12T15:07:41.800Z
9144912 9144912 20260104025824_ctdIi UK000J 2026-01-05T14:19:41.118Z 2026-01-12T15:07:19.264Z
9144470 9144470 20260104024457_xYMxm UK000J 2026-01-05T14:19:11.174Z 2026-01-12T15:07:08.395Z
9144408 9144408 20260104024332_503n2 UK000J 2026-01-05T14:19:02.677Z 2026-01-12T15:07:06.557Z
9144396 9144396 20260104024248_38Gnj UK000J 2026-01-05T14:19:00.639Z 2026-01-12T15:07:06.047Z
9144380 9144380 20260104024224_CKyuE UK000J 2026-01-05T14:18:59.438Z 2026-01-12T15:07:05.632Z
9144075 9144075 20260104023317_tzVpd UK000J 2026-01-05T14:18:34.212Z 2026-01-12T15:06:58.590Z
9143894 9143894 20260104022755_aKF9r UK000J 2026-01-05T14:18:12.381Z 2026-01-12T15:06:36.723Z
9143878 9143878 20260104022755_ZVR3F UK000J 2026-01-05T14:18:12.008Z 2026-01-12T15:06:36.059Z
9143708 9143708 20260104022125_mL2el UK000J 2026-01-05T14:18:01.679Z 2026-01-12T15:06:31.744Z
9143410 9143410 20260104020833_1qkjF UK000J 2026-01-05T14:17:28.684Z 2026-01-12T15:06:22.432Z
9143342 9143342 20260104020625_3ZlE8 UK000J 2026-01-05T14:17:24.479Z 2026-01-12T15:06:20.571Z
9143170 9143170 20260104015906_OtJkq UK000J 2026-01-05T14:17:09.217Z 2026-01-12T15:06:16.360Z
9142873 9142873 20260104014933_RBUTu UK000J 2026-01-05T14:16:41.945Z 2026-01-12T15:05:55.976Z
9142726 9142726 20260104014559_TeGS6 UK000J 2026-01-05T14:16:22.301Z 2026-01-12T15:05:52.471Z
9142324 9142324 20260104013123_ZZBCr UK000J 2026-01-05T14:15:58.739Z 2026-01-12T15:05:40.262Z
9142317 9142317 20260104013050_huzqg UK000J 2026-01-05T14:15:58.333Z 2026-01-12T15:05:40.025Z
9136710 9136710 20260103201204_FjxQ5 UK000J 2026-01-05T14:07:11.396Z 2026-01-12T15:01:37.217Z
9136703 9136703 20260103201203_mbGLR UK000J 2026-01-05T14:07:11.182Z 2026-01-12T15:01:37.071Z
9136657 9136657 20260103201025_Qs08R UK000J 2026-01-05T14:07:09.534Z 2026-01-12T15:01:36.242Z
9135757 9135757 20260103190942_jep4v UK000J 2026-01-05T14:05:10.884Z 2026-01-12T15:00:45.509Z
9135585 9135585 20260103190207_1ZuCK UK000J 2026-01-05T14:04:50.150Z 2026-01-12T15:00:41.189Z
9135287 9135287 20260103184911_33mPj UK000J 2026-01-05T14:04:09.982Z 2026-01-12T15:00:21.419Z
9135143 9135143 20260103184305_GEVZo UK000J 2026-01-05T14:03:47.772Z 2026-01-12T15:00:12.088Z
9135136 9135136 20260103184236_kIq5Q UK000J 2026-01-05T14:03:46.987Z 2026-01-12T15:00:11.621Z
9135043 9135043 20260103183615_YzQUH UK000J 2026-01-05T14:03:30.378Z 2026-01-12T15:00:00.770Z
9135033 9135033 20260103183558_C4J5m UK000J 2026-01-05T14:03:29.874Z 2026-01-12T15:00:00.581Z
9134960 9134960 20260103183306_8F8wY UK000J 2026-01-05T14:03:20.548Z 2026-01-12T14:59:56.634Z
9134913 9134913 20260103183115_AX28e UK000J 2026-01-05T14:03:14.934Z 2026-01-12T14:59:55.238Z
9134884 9134884 20260103182739_hWhVM UK000J 2026-01-05T14:03:05.825Z 2026-01-12T14:59:53.972Z
9134655 9134655 20260103181435_8n8BV UK000J 2026-01-05T14:02:31.293Z 2026-01-12T14:59:43.243Z
9134585 9134585 20260103181259_urlTg UK000J 2026-01-05T14:02:19.801Z 2026-01-12T14:59:41.271Z
9134044 9134044 20260103174904_vtXIJ UK000J 2026-01-05T14:00:26.211Z 2026-01-12T14:59:06.503Z

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