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,331 rows where station_code = "UK008J" 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
9604786 9604786 20260402003926_xluEo UK008J 2026-04-03T12:11:32.856Z 2026-04-06T12:26:19.132Z
9604770 9604770 20260402003201_veO7o UK008J 2026-04-03T12:11:30.331Z 2026-04-06T12:26:18.239Z
9604677 9604677 20260401232859_EhX8a UK008J 2026-04-03T12:11:07.020Z 2026-04-06T12:26:11.131Z
9604675 9604675 20260401232823_cDztc UK008J 2026-04-03T12:11:06.533Z 2026-04-06T12:26:10.938Z
9604643 9604643 20260401230303_9Ds35 UK008J 2026-04-03T12:10:58.241Z 2026-04-06T12:26:08.969Z
9602950 9602950 20260402041437_r1GZX UK008J 2026-04-03T12:01:19.703Z 2026-04-06T12:21:22.283Z
9602895 9602895 20260402035637_qzASv UK008J 2026-04-03T12:01:05.857Z 2026-04-06T12:21:19.637Z
9598569 9598569 20260330012026_TdOOw UK008J 2026-03-31T12:10:57.008Z 2026-04-06T12:36:46.576Z
9598558 9598558 20260330011826_5VlO9 UK008J 2026-03-31T12:10:55.709Z 2026-04-06T12:36:46.078Z
9598539 9598539 20260330010323_qfQii UK008J 2026-03-31T12:10:50.022Z 2026-04-06T12:36:44.876Z
9598521 9598521 20260330005639_VGsUG UK008J 2026-03-31T12:10:47.966Z 2026-04-06T12:36:44.047Z
9598397 9598397 20260329234642_bFVzQ UK008J 2026-03-31T12:10:31.887Z 2026-04-06T12:36:28.967Z
9595078 9595078 20260330021434_l32IR UK008J 2026-03-31T12:00:23.909Z 2026-04-06T12:29:39.314Z
9594633 9594633 20260328233756_T23TM UK008J 2026-03-30T12:10:00.965Z 2026-04-06T12:40:02.047Z
9594432 9594432 20260328222337_KHrC8 UK008J 2026-03-30T12:09:33.380Z 2026-04-06T12:39:52.166Z
9594321 9594321 20260328212525_ajrol UK008J 2026-03-30T12:09:18.088Z 2026-04-06T12:39:47.924Z
9589866 9589866 20260328041259_hRXlJ UK008J 2026-03-29T12:01:41.468Z 2026-04-06T12:37:36.765Z
9589815 9589815 20260328040906_Q7ble UK008J 2026-03-29T12:01:39.241Z 2026-04-06T12:37:35.644Z
9589687 9589687 20260328035907_e6h6C UK008J 2026-03-29T12:01:33.861Z 2026-04-06T12:37:31.524Z
9589487 9589487 20260328033503_3BTdl UK008J 2026-03-29T12:01:19.865Z 2026-04-06T12:37:25.580Z
9589337 9589337 20260328031735_FteuQ UK008J 2026-03-29T12:01:07.175Z 2026-04-06T12:37:20.441Z
9589133 9589133 20260328023159_xczG2 UK008J 2026-03-29T12:00:45.273Z 2026-04-06T12:37:02.716Z
9589087 9589087 20260328022531_m3itC UK008J 2026-03-29T12:00:42.409Z 2026-04-06T12:37:01.382Z
9589010 9589010 20260328021248_jcZ1E UK008J 2026-03-29T12:00:37.466Z 2026-04-06T12:36:59.192Z
9588930 9588930 20260328015616_qf6QD UK008J 2026-03-29T12:00:31.072Z 2026-04-06T12:36:56.957Z
9585127 9585127 20260325233255_S5b7r UK008J 2026-03-27T12:16:47.359Z 2026-04-03T12:39:50.215Z
9584492 9584492 20260325200801_raHcF UK008J 2026-03-27T12:15:28.174Z 2026-04-03T12:39:16.535Z
9581359 9581359 20260326025923_L7LT6 UK008J 2026-03-27T12:02:50.560Z 2026-04-04T12:38:54.081Z
9577320 9577320 20260325045414_pLOGD UK008J 2026-03-26T12:04:46.503Z 2026-04-03T12:36:56.615Z
9576633 9576633 20260325024501_oPGOH UK008J 2026-03-26T12:02:50.830Z 2026-04-03T12:36:15.271Z
9576530 9576530 20260325022825_lKbYb UK008J 2026-03-26T12:02:32.158Z 2026-04-03T12:36:11.527Z
9576408 9576408 20260325020202_CBPH9 UK008J 2026-03-26T12:02:07.743Z 2026-04-03T12:35:57.530Z
9570578 9570578 20260322220805_yEpvH UK008J 2026-03-24T12:23:29.555Z 2026-03-30T12:30:45.849Z
9570487 9570487 20260322213900_QIwHO UK008J 2026-03-24T12:23:21.398Z 2026-03-30T12:30:44.096Z
9561735 9561735 20260323003623_lCC8R UK008J 2026-03-24T12:01:07.957Z 2026-03-31T12:25:52.346Z
9560799 9560799 20260321221535_L273u UK008J 2026-03-23T12:12:03.887Z 2026-03-29T12:21:02.940Z
9554320 9554320 20260322025837_EmDXY UK008J 2026-03-23T12:02:26.634Z 2026-03-30T12:28:02.422Z
9553851 9553851 20260322022107_fXomb UK008J 2026-03-23T12:01:55.440Z 2026-03-30T12:27:53.549Z
9553774 9553774 20260322021301_KfKho UK008J 2026-03-23T12:01:51.339Z 2026-03-30T12:27:52.440Z
9553332 9553332 20260322013144_r1lAU UK008J 2026-03-23T12:01:24.525Z 2026-03-30T12:27:39.556Z
9553006 9553006 20260322010440_umfJ3 UK008J 2026-03-23T12:01:09.214Z 2026-03-30T12:27:33.732Z
9552988 9552988 20260322010145_Px1Kd UK008J 2026-03-23T12:01:07.557Z 2026-03-30T12:27:33.403Z
9552501 9552501 20260322001511_k6PBJ UK008J 2026-03-23T12:00:29.237Z 2026-03-30T12:27:25.188Z
9552490 9552490 20260322001509_s5MJS UK008J 2026-03-23T12:00:28.896Z 2026-03-30T12:27:25.101Z
9543686 9543686 20260321044314_rG85K UK008J 2026-03-22T12:04:26.939Z 2026-03-29T12:19:10.141Z
9543633 9543633 20260321043314_nP39g UK008J 2026-03-22T12:04:19.378Z 2026-03-29T12:19:09.607Z
9543568 9543568 20260321042424_Gpa3r UK008J 2026-03-22T12:04:11.029Z 2026-03-29T12:19:08.993Z
9542091 9542091 20260319224755_mtNbm UK008J 2026-03-21T12:29:39.748Z 2026-03-27T12:42:45.136Z
9541922 9541922 20260319220724_QlX0H UK008J 2026-03-21T12:29:29.946Z 2026-03-27T12:42:43.039Z
9541624 9541624 20260319211235_tPbZl UK008J 2026-03-21T12:29:13.558Z 2026-03-27T12:42:40.360Z
9541583 9541583 20260319210750_kf0RW UK008J 2026-03-21T12:29:12.025Z 2026-03-27T12:42:39.046Z
9534706 9534706 20260320041421_bXF7y UK008J 2026-03-21T12:08:41.238Z 2026-03-28T12:34:21.164Z
9534660 9534660 20260320041032_S83gi UK008J 2026-03-21T12:08:34.598Z 2026-03-28T12:34:20.631Z
9534639 9534639 20260320041017_wRANd UK008J 2026-03-21T12:08:32.985Z 2026-03-28T12:34:20.481Z
9534435 9534435 20260320034937_yqflr UK008J 2026-03-21T12:08:00.416Z 2026-03-28T12:34:18.346Z
9534096 9534096 20260320032517_dPUCM UK008J 2026-03-21T12:07:08.804Z 2026-03-28T12:34:13.761Z
9533884 9533884 20260320030700_E9Klw UK008J 2026-03-21T12:06:33.141Z 2026-03-28T12:34:01.887Z
9533777 9533777 20260320025730_eNwy3 UK008J 2026-03-21T12:06:15.625Z 2026-03-28T12:34:00.417Z
9533438 9533438 20260320023052_zWKQQ UK008J 2026-03-21T12:05:26.633Z 2026-03-28T12:33:53.070Z
9533375 9533375 20260320022606_Z4HMs UK008J 2026-03-21T12:05:16.929Z 2026-03-28T12:33:52.514Z
9532967 9532967 20260320014328_d1a4p UK008J 2026-03-21T12:04:07.886Z 2026-03-28T12:33:47.146Z
9532724 9532724 20260320012046_SyIvn UK008J 2026-03-21T12:03:28.925Z 2026-03-28T12:33:35.637Z
9532687 9532687 20260320011800_bvNMh UK008J 2026-03-21T12:03:23.243Z 2026-03-28T12:33:35.182Z
9532673 9532673 20260320011743_mDIYH UK008J 2026-03-21T12:03:22.668Z 2026-03-28T12:33:35.124Z
9532563 9532563 20260320010633_WvyPl UK008J 2026-03-21T12:03:03.821Z 2026-03-28T12:33:33.959Z
9532293 9532293 20260320004425_keHWw UK008J 2026-03-21T12:02:18.554Z 2026-03-28T12:33:27.235Z
9532049 9532049 20260320001302_4L3r0 UK008J 2026-03-21T12:01:34.346Z 2026-03-28T12:33:24.213Z
9531800 9531800 20260319234939_6KDd5 UK008J 2026-03-21T12:00:53.111Z 2026-03-28T12:33:21.666Z
9531580 9531580 20260319232547_XfnGV UK008J 2026-03-21T12:00:17.355Z 2026-03-28T12:33:18.879Z
9530471 9530471 20260318205947_Tp4KU UK008J 2026-03-20T12:24:25.543Z 2026-03-26T12:39:12.729Z
9530219 9530219 20260318202636_oaSaP UK008J 2026-03-20T12:24:13.185Z 2026-03-26T12:39:10.520Z
9529873 9529873 20260318193840_l71hU UK008J 2026-03-20T12:23:46.767Z 2026-03-26T12:39:07.084Z
9521899 9521899 20260319045259_Aiz6Q UK008J 2026-03-20T12:08:43.514Z 2026-03-27T12:41:11.724Z
9521877 9521877 20260319045001_QQ9hD UK008J 2026-03-20T12:08:41.598Z 2026-03-27T12:41:11.514Z
9521191 9521191 20260319035644_3YCBY UK008J 2026-03-20T12:07:40.997Z 2026-03-27T12:40:52.478Z
9520536 9520536 20260319032150_oYxSL UK008J 2026-03-20T12:06:31.030Z 2026-03-27T12:40:44.536Z
9520255 9520255 20260319030639_asNLI UK008J 2026-03-20T12:06:03.876Z 2026-03-27T12:40:41.040Z
9519873 9519873 20260319024139_zVJzg UK008J 2026-03-20T12:05:20.555Z 2026-03-27T12:40:36.755Z
9519776 9519776 20260319023540_49dk7 UK008J 2026-03-20T12:05:06.093Z 2026-03-27T12:40:35.531Z
9519513 9519513 20260319021452_2GP3d UK008J 2026-03-20T12:04:34.463Z 2026-03-27T12:40:31.938Z
9519285 9519285 20260319015943_QOnUu UK008J 2026-03-20T12:04:14.754Z 2026-03-27T12:40:19.833Z
9519165 9519165 20260319015352_CmsTF UK008J 2026-03-20T12:04:02.542Z 2026-03-27T12:40:18.771Z
9519155 9519155 20260319015352_fSQHn UK008J 2026-03-20T12:04:02.235Z 2026-03-27T12:40:18.743Z
9518982 9518982 20260319013951_qAr54 UK008J 2026-03-20T12:03:42.662Z 2026-03-27T12:40:16.972Z
9518110 9518110 20260319003027_uW5Zc UK008J 2026-03-20T12:01:53.901Z 2026-03-27T12:40:06.394Z
9518064 9518064 20260319002613_Nrnfw UK008J 2026-03-20T12:01:50.497Z 2026-03-27T12:40:06.055Z
9517710 9517710 20260318235627_FNwcz UK008J 2026-03-20T12:01:04.370Z 2026-03-27T12:40:02.536Z
9517588 9517588 20260318234324_TqXEw UK008J 2026-03-20T12:00:46.902Z 2026-03-27T12:40:01.167Z
9517505 9517505 20260318233426_uoR4h UK008J 2026-03-20T12:00:33.982Z 2026-03-27T12:40:00.373Z
9516687 9516687 20260317213654_dKk25 UK008J 2026-03-19T12:26:39.608Z 2026-03-25T12:43:06.159Z
9516616 9516616 20260317211615_Tq0Pz UK008J 2026-03-19T12:26:33.292Z 2026-03-25T12:43:04.046Z
9516362 9516362 20260317203825_M5hJ1 UK008J 2026-03-19T12:26:04.025Z 2026-03-25T12:42:54.619Z
9512064 9512064 20260318043941_tae0u UK008J 2026-03-19T12:11:38.207Z 2026-03-26T12:37:42.062Z
9511622 9511622 20260318040548_P3TJ4 UK008J 2026-03-19T12:10:38.662Z 2026-03-26T12:37:38.353Z
9511569 9511569 20260318040228_WOygA UK008J 2026-03-19T12:10:29.960Z 2026-03-26T12:37:37.959Z
9509855 9509855 20260318021934_3ex93 UK008J 2026-03-19T12:06:22.774Z 2026-03-26T12:37:08.325Z
9508827 9508827 20260318011149_2hDnI UK008J 2026-03-19T12:03:52.202Z 2026-03-26T12:37:01.128Z
9508399 9508399 20260318005108_ruBVY UK008J 2026-03-19T12:03:00.249Z 2026-03-26T12:36:58.225Z
9507996 9507996 20260317235947_uTIZ6 UK008J 2026-03-19T12:01:51.912Z 2026-03-26T12:36:54.879Z
9507889 9507889 20260317235140_2AuGP UK008J 2026-03-19T12:01:34.322Z 2026-03-26T12:36:54.231Z

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