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

>10,000 rows count all where station_code = "UK005G" 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
9273108 9273108 20260128044518_PeI8V UK005G 2026-01-29T14:28:46.079Z 2026-01-29T14:30:25.752Z
9272990 9272990 20260128041653_zwD2w UK005G 2026-01-29T14:28:23.263Z 2026-01-29T14:30:25.730Z
9272947 9272947 20260128040852_cBqZw UK005G 2026-01-29T14:28:17.825Z 2026-01-29T14:30:25.711Z
9272862 9272862 20260128035401_sM26T UK005G 2026-01-29T14:28:04.592Z 2026-01-29T14:30:25.700Z
9272676 9272676 20260128030051_2Ey2F UK005G 2026-01-29T14:27:27.840Z 2026-01-29T14:30:25.437Z
9272616 9272616 20260128024909_Af6ae UK005G 2026-01-29T14:27:14.824Z 2026-01-29T14:30:25.383Z
9272169 9272169 20260128002846_Qt5rB UK005G 2026-01-29T14:25:50.728Z 2026-01-29T14:30:25.292Z
9272129 9272129 20260128001452_DyfWZ UK005G 2026-01-29T14:25:44.790Z 2026-01-29T14:30:25.286Z
9272121 9272121 20260128000759_HqDga UK005G 2026-01-29T14:25:43.201Z 2026-01-29T14:30:25.283Z
9272061 9272061 20260127233250_c6930 UK005G 2026-01-29T14:25:26.351Z 2026-01-29T14:30:25.273Z
9272048 9272048 20260127232832_bVFPm UK005G 2026-01-29T14:25:24.857Z 2026-01-29T14:30:25.270Z
9272008 9272008 20260127225628_T9mkn UK005G 2026-01-29T14:25:17.217Z 2026-01-29T14:30:25.263Z
9271959 9271959 20260127222335_vJcZJ UK005G 2026-01-29T14:25:07.778Z 2026-01-29T14:30:25.252Z
9271867 9271867 20260127211707_DsgGa UK005G 2026-01-29T14:24:40.374Z 2026-01-29T14:30:25.216Z
9258896 9258896 20260124175313_BtvDK UK005G 2026-01-26T14:14:56.087Z 2026-01-29T14:42:17.460Z
9256255 9256255 20260124063032_E28Mw UK005G 2026-01-25T14:16:19.416Z 2026-01-29T14:48:32.145Z
9256238 9256238 20260124062548_4uJNM UK005G 2026-01-25T14:16:17.329Z 2026-01-29T14:48:30.494Z
9256187 9256187 20260124061150_zuscB UK005G 2026-01-25T14:16:08.517Z 2026-01-29T14:48:27.523Z
9256084 9256084 20260124055058_djUpU UK005G 2026-01-25T14:15:44.661Z 2026-01-29T14:48:21.926Z
9256036 9256036 20260124054633_Pijqm UK005G 2026-01-25T14:15:36.894Z 2026-01-29T14:48:19.265Z
9255942 9255942 20260124052954_3l5d0 UK005G 2026-01-25T14:15:13.519Z 2026-01-29T14:48:09.143Z
9255758 9255758 20260124044853_6n5g1 UK005G 2026-01-25T14:14:35.560Z 2026-01-29T14:47:55.761Z
9255708 9255708 20260124043644_gpi6d UK005G 2026-01-25T14:14:27.234Z 2026-01-29T14:47:53.211Z
9255650 9255650 20260124042413_OiFge UK005G 2026-01-25T14:14:10.761Z 2026-01-29T14:47:49.356Z
9255555 9255555 20260124041149_9pjK2 UK005G 2026-01-25T14:13:57.351Z 2026-01-29T14:47:40.120Z
9255361 9255361 20260124030531_Vyybt UK005G 2026-01-25T14:13:03.764Z 2026-01-29T14:47:26.037Z
9255331 9255331 20260124025526_wZf4C UK005G 2026-01-25T14:12:56.421Z 2026-01-29T14:47:23.956Z
9255329 9255329 20260124025354_EY33C UK005G 2026-01-25T14:12:55.891Z 2026-01-29T14:47:23.818Z
9255273 9255273 20260124022324_hUjBi UK005G 2026-01-25T14:12:38.461Z 2026-01-29T14:47:14.372Z
9255242 9255242 20260124021010_Q7mFs UK005G 2026-01-25T14:12:30.568Z 2026-01-29T14:47:11.985Z
9255088 9255088 20260124004508_3FzxE UK005G 2026-01-25T14:11:51.313Z 2026-01-29T14:47:01.762Z
9255058 9255058 20260124003730_fvqu6 UK005G 2026-01-25T14:11:45.525Z 2026-01-29T14:47:01.022Z
9255032 9255032 20260124002827_TWGF5 UK005G 2026-01-25T14:11:42.590Z 2026-01-29T14:47:00.288Z
9255014 9255014 20260124002237_YcetE UK005G 2026-01-25T14:11:38.946Z 2026-01-29T14:46:59.818Z
9255004 9255004 20260124001258_E9L3N UK005G 2026-01-25T14:11:37.080Z 2026-01-29T14:46:59.442Z
9252821 9252821 20260123064256_9LndG UK005G 2026-01-24T14:17:24.271Z 2026-01-29T14:53:35.497Z
9252795 9252795 20260123063141_o3xiy UK005G 2026-01-24T14:17:12.705Z 2026-01-29T14:53:29.198Z
9252728 9252728 20260123055035_KKEPh UK005G 2026-01-24T14:16:56.419Z 2026-01-29T14:53:21.307Z
9244191 9244191 20260121064237_eUqdU UK005G 2026-01-22T14:24:34.750Z 2026-01-29T15:05:55.540Z
9244129 9244129 20260121061824_8tA4U UK005G 2026-01-22T14:24:14.236Z 2026-01-29T15:05:52.604Z
9244105 9244105 20260121061337_sFBil UK005G 2026-01-22T14:24:10.341Z 2026-01-29T15:05:52.057Z
9244037 9244037 20260121055726_6Y4Zo UK005G 2026-01-22T14:23:59.428Z 2026-01-29T15:05:49.374Z
9244011 9244011 20260121055543_f1G0L UK005G 2026-01-22T14:23:56.017Z 2026-01-29T15:05:47.458Z
9243995 9243995 20260121055013_aeUOf UK005G 2026-01-22T14:23:53.241Z 2026-01-29T15:05:37.914Z
9243702 9243702 20260121050708_G1FNP UK005G 2026-01-22T14:22:48.113Z 2026-01-29T15:05:24.157Z
9243567 9243567 20260121044838_Iaeak UK005G 2026-01-22T14:22:13.739Z 2026-01-29T15:05:18.267Z
9243224 9243224 20260121040045_M9eBq UK005G 2026-01-22T14:20:59.447Z 2026-01-29T15:04:51.443Z
9243219 9243219 20260121040033_ftUZ7 UK005G 2026-01-22T14:20:59.020Z 2026-01-29T15:04:51.393Z
9240843 9240843 20260120180356_Ggx3Q UK005G 2026-01-22T14:10:21.336Z 2026-01-29T15:01:57.652Z
9231039 9231039 20260119054838_NDQ1Q UK005G 2026-01-20T14:31:00.225Z 2026-01-27T15:05:54.354Z
9231017 9231017 20260119054341_ZfY5e UK005G 2026-01-20T14:30:55.424Z 2026-01-27T15:05:53.046Z
9231012 9231012 20260119054226_fTqDi UK005G 2026-01-20T14:30:54.188Z 2026-01-27T15:05:52.836Z
9231000 9231000 20260119054146_WeP7X UK005G 2026-01-20T14:30:51.633Z 2026-01-27T15:05:52.344Z
9230713 9230713 20260119045443_i2eve UK005G 2026-01-20T14:29:22.122Z 2026-01-27T15:05:22.348Z
9218045 9218045 20260116225710_JUNvy UK005G 2026-01-18T14:10:10.249Z 2026-01-25T14:57:56.584Z
9217588 9217588 20260116181641_ZPXB5 UK005G 2026-01-18T14:08:06.065Z 2026-01-25T14:57:27.306Z
9214039 9214039 20260116052343_pMfkf UK005G 2026-01-17T14:19:45.055Z 2026-01-24T15:12:59.366Z
9213932 9213932 20260116050239_2MQvV UK005G 2026-01-17T14:19:13.266Z 2026-01-24T15:12:52.042Z
9213860 9213860 20260116045613_ExHPl UK005G 2026-01-17T14:18:51.832Z 2026-01-24T15:12:49.431Z
9213776 9213776 20260116043836_GL0rl UK005G 2026-01-17T14:18:26.999Z 2026-01-24T15:12:46.028Z
9213742 9213742 20260116043316_OgK2a UK005G 2026-01-17T14:18:18.678Z 2026-01-24T15:12:33.001Z
9213683 9213683 20260116042414_IUqUR UK005G 2026-01-17T14:18:08.650Z 2026-01-24T15:12:31.030Z
9213656 9213656 20260116041844_UwwH9 UK005G 2026-01-17T14:17:59.665Z 2026-01-24T15:12:30.222Z
9213627 9213627 20260116040923_prlng UK005G 2026-01-17T14:17:49.371Z 2026-01-24T15:12:26.323Z
9213491 9213491 20260116034704_YhsxW UK005G 2026-01-17T14:17:10.542Z 2026-01-24T15:12:18.110Z
9208450 9208450 20260115052734_bhDDQ UK005G 2026-01-16T14:12:44.407Z 2026-01-22T15:04:14.312Z
9208259 9208259 20260115044954_Lbu9Z UK005G 2026-01-16T14:11:57.099Z 2026-01-22T15:04:05.839Z
9208165 9208165 20260115042338_ewzoM UK005G 2026-01-16T14:11:34.522Z 2026-01-22T15:04:02.775Z
9207977 9207977 20260115034142_DJvq8 UK005G 2026-01-16T14:10:53.157Z 2026-01-22T15:03:57.871Z
9207845 9207845 20260115031832_x0vRr UK005G 2026-01-16T14:10:23.811Z 2026-01-22T15:03:54.655Z
9207831 9207831 20260115031459_TDW3s UK005G 2026-01-16T14:10:17.501Z 2026-01-22T15:03:54.123Z
9207826 9207826 20260115031432_sGfYV UK005G 2026-01-16T14:10:16.959Z 2026-01-22T15:03:54.070Z
9207801 9207801 20260115031105_vrlMf UK005G 2026-01-16T14:10:10.283Z 2026-01-22T15:03:53.148Z
9207698 9207698 20260115024844_feE5n UK005G 2026-01-16T14:09:43.547Z 2026-01-22T15:03:30.300Z
9207513 9207513 20260115015959_gOvzy UK005G 2026-01-16T14:09:02.692Z 2026-01-22T15:03:23.813Z
9204354 9204354 20260114063011_ODaEk UK005G 2026-01-15T14:27:07.639Z 2026-01-22T15:10:25.365Z
9204325 9204325 20260114062801_ZiQEo UK005G 2026-01-15T14:27:03.903Z 2026-01-22T15:10:24.883Z
9204302 9204302 20260114062557_2kYDp UK005G 2026-01-15T14:27:02.050Z 2026-01-22T15:10:24.612Z
9204281 9204281 20260114062513_ngr7k UK005G 2026-01-15T14:27:00.268Z 2026-01-22T15:10:24.409Z
9204218 9204218 20260114061616_qhG6f UK005G 2026-01-15T14:26:50.702Z 2026-01-22T15:10:22.516Z
9204112 9204112 20260114060824_ub68G UK005G 2026-01-15T14:26:26.146Z 2026-01-22T15:10:18.267Z
9203535 9203535 20260114051538_GhtBT UK005G 2026-01-15T14:24:44.892Z 2026-01-22T15:10:09.642Z
9203023 9203023 20260114042917_3EmGE UK005G 2026-01-15T14:23:10.963Z 2026-01-22T15:10:00.775Z
9202407 9202407 20260114033618_r5jbg UK005G 2026-01-15T14:21:13.894Z 2026-01-22T15:09:17.310Z
9202285 9202285 20260114032625_ionhu UK005G 2026-01-15T14:20:53.324Z 2026-01-22T15:09:15.942Z
9202201 9202201 20260114032338_V1Bpp UK005G 2026-01-15T14:20:41.972Z 2026-01-22T15:09:14.843Z
9201921 9201921 20260114030715_7aDXB UK005G 2026-01-15T14:20:08.440Z 2026-01-22T15:09:11.489Z
9201727 9201727 20260114024625_fYjKU UK005G 2026-01-15T14:19:34.409Z 2026-01-22T15:09:08.348Z
9201437 9201437 20260114021750_kF4PX UK005G 2026-01-15T14:18:40.155Z 2026-01-16T14:25:54.079Z
9201232 9201232 20260114015824_09UcW UK005G 2026-01-15T14:17:55.817Z 2026-01-22T15:09:00.108Z
9201056 9201056 20260114013934_MFchs UK005G 2026-01-15T14:17:23.432Z 2026-01-22T15:08:57.211Z
9200973 9200973 20260114012559_t0YtU UK005G 2026-01-15T14:17:07.146Z 2026-01-22T15:08:41.026Z
9200921 9200921 20260114012223_L4Od3 UK005G 2026-01-15T14:17:00.666Z 2026-01-22T15:08:38.848Z
9200797 9200797 20260114010405_cWA14 UK005G 2026-01-15T14:16:26.121Z 2026-01-22T15:08:25.844Z
9200682 9200682 20260114005124_cQorH UK005G 2026-01-15T14:16:07.043Z 2026-01-22T15:08:23.486Z
9200468 9200468 20260114001248_6TRTG UK005G 2026-01-15T14:15:16.692Z 2026-01-22T15:08:16.467Z
9200320 9200320 20260113234246_ZyY6o UK005G 2026-01-15T14:14:44.100Z 2026-01-22T15:08:13.845Z
9200313 9200313 20260113234146_KwiJF UK005G 2026-01-15T14:14:42.698Z 2026-01-22T15:08:13.729Z
9200193 9200193 20260113230856_UrJvH UK005G 2026-01-15T14:14:08.919Z 2026-01-22T15:08:11.025Z
9195577 9195577 20260113015040_MQdFn UK005G 2026-01-14T14:13:52.928Z 2026-01-21T15:04:42.494Z

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