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

2,621 rows where station_code = "UK004J" 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
9609015 9609015 20260404030558_KQKtT UK004J 2026-04-05T12:12:36.997Z 2026-04-06T12:20:57.150Z
9607088 9607088 20260404033015_SMDpc UK004J 2026-04-05T12:00:23.469Z 2026-04-06T12:16:14.358Z
9607043 9607043 20260404031846_6WQ5H UK004J 2026-04-05T12:00:14.320Z 2026-04-06T12:16:14.349Z
9607027 9607027 20260404031551_p4H6A UK004J 2026-04-05T12:00:10.691Z 2026-04-06T12:16:14.345Z
9602662 9602662 20260401015854_jaP2H UK004J 2026-04-02T12:09:46.317Z 2026-04-06T12:29:31.651Z
9600558 9600558 20260330233206_Yw3Av UK004J 2026-04-01T12:11:10.293Z 2026-04-06T12:33:34.253Z
9600485 9600485 20260330223924_zOPp8 UK004J 2026-04-01T12:10:53.780Z 2026-04-06T12:33:27.929Z
9598553 9598553 20260330011606_V2z5f UK004J 2026-03-31T12:10:54.883Z 2026-04-06T12:36:45.753Z
9598493 9598493 20260330004456_pmnnU UK004J 2026-03-31T12:10:44.534Z 2026-04-06T12:36:35.333Z
9598444 9598444 20260330001344_D5W7k UK004J 2026-03-31T12:10:37.189Z 2026-04-06T12:36:32.723Z
9595451 9595451 20260330040730_TN1Qu UK004J 2026-03-31T12:01:27.551Z 2026-04-06T12:30:04.349Z
9595303 9595303 20260330032112_fEj6O UK004J 2026-03-31T12:01:02.365Z 2026-04-06T12:29:56.125Z
9595018 9595018 20260330014000_3KJWx UK004J 2026-03-31T12:00:12.097Z 2026-04-06T12:29:35.116Z
9594820 9594820 20260329003531_2Pq2k UK004J 2026-03-30T12:10:22.498Z 2026-04-06T12:40:16.829Z
9594534 9594534 20260328225355_IRLWJ UK004J 2026-03-30T12:09:46.649Z 2026-04-06T12:39:56.177Z
9594409 9594409 20260328221615_niDek UK004J 2026-03-30T12:09:30.891Z 2026-04-06T12:39:51.387Z
9594255 9594255 20260328204145_SRwLI UK004J 2026-03-30T12:09:06.426Z 2026-04-06T12:39:45.004Z
9593008 9593008 20260329041639_mtpag UK004J 2026-03-30T12:02:35.908Z 2026-04-06T12:34:45.071Z
9592946 9592946 20260329040043_NQ5V3 UK004J 2026-03-30T12:02:24.102Z 2026-04-06T12:34:41.901Z
9592822 9592822 20260329033121_zOoM5 UK004J 2026-03-30T12:02:00.304Z 2026-04-06T12:34:29.628Z
9592170 9592170 20260329011843_EFND1 UK004J 2026-03-30T12:00:16.426Z 2026-04-06T12:33:52.323Z
9589910 9589910 20260328041852_FsMz8 UK004J 2026-03-29T12:01:44.149Z 2026-04-06T12:37:37.928Z
9585301 9585301 20260326001058_zG7BU UK004J 2026-03-27T12:17:05.665Z 2026-04-03T12:39:54.369Z
9585299 9585299 20260326000919_8sTgZ UK004J 2026-03-27T12:17:05.305Z 2026-04-03T12:39:54.224Z
9585282 9585282 20260326000757_EfM3Z UK004J 2026-03-27T12:17:04.569Z 2026-04-03T12:39:54.045Z
9585068 9585068 20260325232021_2U3Y9 UK004J 2026-03-27T12:16:39.273Z 2026-04-03T12:39:48.579Z
9584580 9584580 20260325204719_TdLsA UK004J 2026-03-27T12:15:42.238Z 2026-04-03T12:39:22.580Z
9584556 9584556 20260325203834_M3jeb UK004J 2026-03-27T12:15:37.896Z 2026-04-03T12:39:19.571Z
9584378 9584378 20260325193422_2OnLR UK004J 2026-03-27T12:15:09.949Z 2026-04-03T12:39:12.394Z
9581732 9581732 20260326035351_tsBIR UK004J 2026-03-27T12:03:46.312Z 2026-04-04T12:39:17.392Z
9581721 9581721 20260326035045_9yGef UK004J 2026-03-27T12:03:45.014Z 2026-04-04T12:39:16.679Z
9581702 9581702 20260326034537_3L7BY UK004J 2026-03-27T12:03:41.806Z 2026-04-04T12:39:15.678Z
9581494 9581494 20260326031826_8xMQt UK004J 2026-03-27T12:03:16.608Z 2026-04-04T12:39:08.403Z
9580686 9580686 20260326011707_8js8L UK004J 2026-03-27T12:01:10.101Z 2026-04-04T12:38:20.616Z
9580491 9580491 20260326005545_CZz23 UK004J 2026-03-27T12:00:37.522Z 2026-04-04T12:38:12.133Z
9580342 9580342 20260326003545_jke0g UK004J 2026-03-27T12:00:13.645Z 2026-04-04T12:38:06.767Z
9576745 9576745 20260325030304_onYmm UK004J 2026-03-26T12:03:10.567Z 2026-04-03T12:36:19.677Z
9576345 9576345 20260325015548_TXDyV UK004J 2026-03-26T12:01:59.611Z 2026-04-03T12:35:53.988Z
9576322 9576322 20260325015410_2gt7t UK004J 2026-03-26T12:01:56.724Z 2026-04-03T12:35:53.339Z
9576317 9576317 20260325015348_Eeq6n UK004J 2026-03-26T12:01:55.553Z 2026-04-03T12:35:53.113Z
9576168 9576168 20260325012738_rIsHq UK004J 2026-03-26T12:01:28.708Z 2026-04-03T12:35:46.972Z
9575650 9575650 20260322010855_3boq5 UK004J 2026-03-25T12:22:09.913Z 2026-03-30T12:27:34.413Z
9562931 9562931 20260323035326_YNrSU UK004J 2026-03-24T12:04:29.429Z 2026-03-31T12:26:29.736Z
9562927 9562927 20260323035034_tApwR UK004J 2026-03-24T12:04:28.907Z 2026-03-31T12:26:29.558Z
9562894 9562894 20260323033418_ufeRZ UK004J 2026-03-24T12:04:20.994Z 2026-03-31T12:26:28.603Z
9562807 9562807 20260323031643_8ND4G UK004J 2026-03-24T12:04:07.028Z 2026-03-31T12:26:26.386Z
9562610 9562610 20260323024617_i93BF UK004J 2026-03-24T12:03:32.867Z 2026-03-31T12:26:15.499Z
9562145 9562145 20260323013703_o9Tca UK004J 2026-03-24T12:02:18.111Z 2026-03-31T12:26:02.351Z
9561442 9561442 20260321233423_k2Xyf UK004J 2026-03-23T12:12:19.206Z 2026-03-29T12:21:07.330Z
9561217 9561217 20260321230906_ybUYw UK004J 2026-03-23T12:12:13.918Z 2026-03-29T12:21:05.724Z
9561109 9561109 20260321230118_YmuKo UK004J 2026-03-23T12:12:11.765Z 2026-03-29T12:21:05.202Z
9560467 9560467 20260321213007_ED5Qf UK004J 2026-03-23T12:11:48.498Z 2026-03-29T12:21:00.597Z
9560275 9560275 20260321205521_vAIvy UK004J 2026-03-23T12:11:40.963Z 2026-03-29T12:20:58.859Z
9560173 9560173 20260321203958_k2CdF UK004J 2026-03-23T12:11:39.441Z 2026-03-29T12:20:58.345Z
9559932 9559932 20260321201124_ltnjI UK004J 2026-03-23T12:11:34.033Z 2026-03-29T12:20:56.674Z
9553073 9553073 20260322010853_PBRag UK004J 2026-03-23T12:01:11.487Z 2026-03-30T12:27:34.310Z
9552572 9552572 20260322002052_dwPUh UK004J 2026-03-23T12:00:33.247Z 2026-03-24T12:24:26.862Z
9552356 9552356 20260321235532_u7nZu UK004J 2026-03-23T12:00:16.886Z 2026-03-30T12:27:22.695Z
9552212 9552212 20260320232235_W9ciJ UK004J 2026-03-22T12:27:33.028Z 2026-03-28T12:37:07.923Z
9551879 9551879 20260320220231_rDIMF UK004J 2026-03-22T12:27:15.160Z 2026-03-28T12:37:03.543Z
9542809 9542809 20260321012607_Wxo6z UK004J 2026-03-22T12:01:41.173Z 2026-03-29T12:18:58.612Z
9534536 9534536 20260320035740_X4r1K UK004J 2026-03-21T12:08:12.939Z 2026-03-28T12:34:19.126Z
9534348 9534348 20260320034249_i03z3 UK004J 2026-03-21T12:07:44.453Z 2026-03-28T12:34:17.430Z
9534090 9534090 20260320032223_Nv3Fs UK004J 2026-03-21T12:07:07.523Z 2026-03-28T12:34:11.728Z
9534084 9534084 20260320032146_epK6D UK004J 2026-03-21T12:07:07.051Z 2026-03-28T12:34:10.909Z
9533808 9533808 20260320025956_BIcQ5 UK004J 2026-03-21T12:06:21.678Z 2026-03-28T12:34:00.848Z
9533710 9533710 20260320025226_33baH UK004J 2026-03-21T12:06:05.210Z 2026-03-28T12:33:58.935Z
9533235 9533235 20260320021724_N3SaY UK004J 2026-03-21T12:04:52.712Z 2026-03-28T12:33:50.786Z
9533069 9533069 20260320015653_NXQwW UK004J 2026-03-21T12:04:20.944Z 2026-03-28T12:33:48.280Z
9532942 9532942 20260320014033_FHfQ1 UK004J 2026-03-21T12:04:03.160Z 2026-03-28T12:33:46.850Z
9532922 9532922 20260320013822_SgOwd UK004J 2026-03-21T12:03:58.978Z 2026-03-28T12:33:46.465Z
9532891 9532891 20260320013559_2VctK UK004J 2026-03-21T12:03:54.229Z 2026-03-28T12:33:45.900Z
9532814 9532814 20260320012800_0CBFl UK004J 2026-03-21T12:03:43.092Z 2026-03-28T12:33:44.474Z
9532387 9532387 20260320004954_cucGR UK004J 2026-03-21T12:02:32.749Z 2026-03-28T12:33:29.084Z
9532157 9532157 20260320002340_dhJM9 UK004J 2026-03-21T12:01:51.544Z 2026-03-28T12:33:24.979Z
9531910 9531910 20260320000004_5V6ys UK004J 2026-03-21T12:01:10.129Z 2026-03-28T12:33:22.711Z
9531848 9531848 20260319235455_1NNJ4 UK004J 2026-03-21T12:01:00.976Z 2026-03-28T12:33:22.110Z
9531774 9531774 20260319234738_TjYSO UK004J 2026-03-21T12:00:51.753Z 2026-03-28T12:33:21.492Z
9530879 9530879 20260318215652_QiZYH UK004J 2026-03-20T12:24:50.604Z 2026-03-26T12:39:16.385Z
9520891 9520891 20260319034414_jlfFM UK004J 2026-03-20T12:07:12.596Z 2026-03-27T12:40:48.877Z
9520370 9520370 20260319031211_OvQqb UK004J 2026-03-20T12:06:17.076Z 2026-03-27T12:40:42.390Z
9520228 9520228 20260319030501_ATvIL UK004J 2026-03-20T12:06:00.247Z 2026-03-27T12:40:40.710Z
9519532 9519532 20260319021532_v8QAx UK004J 2026-03-20T12:04:36.409Z 2026-03-27T12:40:32.164Z
9519257 9519257 20260319015715_U9k3Y UK004J 2026-03-20T12:04:11.772Z 2026-03-27T12:40:19.617Z
9518815 9518815 20260319012753_Adkay UK004J 2026-03-20T12:03:26.900Z 2026-03-27T12:40:15.338Z
9518703 9518703 20260319012008_2vNps UK004J 2026-03-20T12:03:09.016Z 2026-03-27T12:40:12.810Z
9518282 9518282 20260319004736_M18nB UK004J 2026-03-20T12:02:15.427Z 2026-03-27T12:40:08.182Z
9517229 9517229 20260317225759_DPyzu UK004J 2026-03-19T12:27:21.162Z 2026-03-25T12:43:09.507Z
9517187 9517187 20260317225039_rooIn UK004J 2026-03-19T12:27:17.772Z 2026-03-25T12:43:09.167Z
9517123 9517123 20260317224425_ru7Yc UK004J 2026-03-19T12:27:13.222Z 2026-03-25T12:43:08.863Z
9516140 9516140 20260317200603_2uCaZ UK004J 2026-03-19T12:25:42.950Z 2026-03-25T12:42:49.310Z
9516099 9516099 20260317200259_ecXyd UK004J 2026-03-19T12:25:40.317Z 2026-03-25T12:42:48.448Z
9515961 9515961 20260317193730_LeeC0 UK004J 2026-03-19T12:25:23.904Z 2026-03-25T12:42:44.598Z
9511989 9511989 20260318043227_NOsgh UK004J 2026-03-19T12:11:25.793Z 2026-03-26T12:37:41.305Z
9511903 9511903 20260318042758_VZahA UK004J 2026-03-19T12:11:17.896Z 2026-03-26T12:37:40.684Z
9511720 9511720 20260318041239_5Igkq UK004J 2026-03-19T12:10:49.729Z 2026-03-26T12:37:39.119Z
9511666 9511666 20260318040822_5TBwO UK004J 2026-03-19T12:10:42.012Z 2026-03-26T12:37:38.578Z
9511494 9511494 20260318035634_P0mVc UK004J 2026-03-19T12:10:20.381Z 2026-03-26T12:37:37.383Z
9511379 9511379 20260318034828_oNzdg UK004J 2026-03-19T12:10:04.381Z 2026-03-26T12:37:36.482Z
9511353 9511353 20260318034731_qSeyL UK004J 2026-03-19T12:10:00.322Z 2026-03-26T12:37:36.213Z

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