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,760 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
9611536 9611536 20260405023305_Sj6pI UK000J 2026-04-06T12:15:01.430Z 2026-04-06T12:16:14.818Z
9611530 9611530 20260405023245_RDU6P UK000J 2026-04-06T12:15:00.504Z 2026-04-06T12:16:14.817Z
9608563 9608563 20260403234038_Q98Qs UK000J 2026-04-05T12:10:49.963Z 2026-04-06T12:20:20.882Z
9592689 9592689 20260329030410_sXqtD UK000J 2026-03-30T12:01:38.599Z 2026-04-06T12:34:21.517Z
9592587 9592587 20260329024139_nS1d7 UK000J 2026-03-30T12:01:23.254Z 2026-04-06T12:34:16.567Z
9592520 9592520 20260329022254_nJGGf UK000J 2026-03-30T12:01:11.248Z 2026-04-06T12:34:13.702Z
9592324 9592324 20260329015318_xquoK UK000J 2026-03-30T12:00:41.552Z 2026-04-06T12:34:00.806Z
9592128 9592128 20260328005440_yo3rT UK000J 2026-03-29T12:07:12.604Z 2026-04-05T12:35:38.349Z
9592029 9592029 20260328000032_ZB01h UK000J 2026-03-29T12:07:07.074Z 2026-04-05T12:35:24.762Z
9591935 9591935 20260327231700_YQPAv UK000J 2026-03-29T12:07:00.133Z 2026-04-05T12:35:21.496Z
9591914 9591914 20260327230400_q4ARq UK000J 2026-03-29T12:06:58.313Z 2026-04-05T12:35:19.463Z
9590009 9590009 20260328042810_HZopq UK000J 2026-03-29T12:01:51.903Z 2026-04-06T12:37:46.995Z
9588967 9588967 20260328020419_m384H UK000J 2026-03-29T12:00:35.296Z 2026-04-06T12:36:58.365Z
9570404 9570404 20260322211049_iWqOV UK000J 2026-03-24T12:23:10.025Z 2026-03-30T12:30:41.975Z
9521159 9521159 20260319035545_sFD3v UK000J 2026-03-20T12:07:38.684Z 2026-03-27T12:40:52.264Z
9520505 9520505 20260319032026_6v53H UK000J 2026-03-20T12:06:28.896Z 2026-03-27T12:40:44.191Z
9520441 9520441 20260319031615_yKvlS UK000J 2026-03-20T12:06:23.389Z 2026-03-27T12:40:43.340Z
9520066 9520066 20260319025045_35qVn UK000J 2026-03-20T12:05:38.155Z 2026-03-27T12:40:38.453Z
9520036 9520036 20260319024914_U76iQ UK000J 2026-03-20T12:05:35.048Z 2026-03-27T12:40:38.176Z
9517814 9517814 20260319000540_voHUO UK000J 2026-03-20T12:01:21.699Z 2026-03-27T12:40:03.743Z
9517163 9517163 20260317224915_Hh0ix UK000J 2026-03-19T12:27:16.276Z 2026-03-25T12:43:09.075Z
9516416 9516416 20260317204734_WBN2j UK000J 2026-03-19T12:26:10.533Z 2026-03-25T12:42:58.325Z
9516045 9516045 20260317194817_qOZj9 UK000J 2026-03-19T12:25:34.712Z 2026-03-25T12:42:47.050Z
9512005 9512005 20260318043452_kNUVv UK000J 2026-03-19T12:11:29.436Z 2026-03-26T12:37:41.521Z
9511956 9511956 20260318043030_n3Ujk UK000J 2026-03-19T12:11:22.882Z 2026-03-26T12:37:40.981Z
9511927 9511927 20260318042925_8P69h UK000J 2026-03-19T12:11:21.211Z 2026-03-26T12:37:40.847Z
9511905 9511905 20260318042837_jTXfv UK000J 2026-03-19T12:11:18.412Z 2026-03-26T12:37:40.702Z
9511342 9511342 20260318034730_Fofi0 UK000J 2026-03-19T12:09:59.646Z 2026-03-26T12:37:36.192Z
9511237 9511237 20260318034155_GyJPF UK000J 2026-03-19T12:09:45.517Z 2026-03-26T12:37:31.860Z
9511170 9511170 20260318033857_UA3KD UK000J 2026-03-19T12:09:35.504Z 2026-03-26T12:37:25.533Z
9511156 9511156 20260318033857_sK6u3 UK000J 2026-03-19T12:09:35.397Z 2026-03-26T12:37:25.530Z
9510629 9510629 20260318030516_hKCNo UK000J 2026-03-19T12:08:10.344Z 2026-03-26T12:37:15.130Z
9510431 9510431 20260318025106_vtE8f UK000J 2026-03-19T12:07:37.432Z 2026-03-26T12:37:12.451Z
9510226 9510226 20260318024003_lgjw8 UK000J 2026-03-19T12:07:11.172Z 2026-03-26T12:37:11.013Z
9508655 9508655 20260318010736_U5iI1 UK000J 2026-03-19T12:03:36.884Z 2026-03-26T12:37:00.074Z
9508644 9508644 20260318010736_sXu1b UK000J 2026-03-19T12:03:36.000Z 2026-03-26T12:37:00.014Z
9507499 9507499 20260317231112_e8Lkq UK000J 2026-03-19T12:00:18.440Z 2026-03-26T12:36:37.548Z
9493688 9493688 20260316002229_3rLLd UK000J 2026-03-17T12:01:44.303Z 2026-03-24T12:40:41.341Z
9467151 9467151 20260311202520_dOJ03 UK000J 2026-03-13T12:18:34.146Z 2026-03-19T12:45:49.528Z
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

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