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 = "UK009D" 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
9585367 9585367 20260326002504_ASgrP UK009D 2026-03-27T12:17:12.100Z 2026-04-03T12:39:58.074Z
9585224 9585224 20260325234322_kUVHg UK009D 2026-03-27T12:16:55.338Z 2026-04-03T12:39:51.722Z
9585218 9585218 20260325234232_Gm36b UK009D 2026-03-27T12:16:54.827Z 2026-04-03T12:39:51.600Z
9585202 9585202 20260325234015_C2FUG UK009D 2026-03-27T12:16:54.275Z 2026-04-03T12:39:51.378Z
9585143 9585143 20260325233302_zGkxv UK009D 2026-03-27T12:16:50.374Z 2026-04-03T12:39:50.346Z
9585128 9585128 20260325233255_S5b7r UK009D 2026-03-27T12:16:47.359Z 2026-04-03T12:39:50.215Z
9585064 9585064 20260325231838_fSKsR UK009D 2026-03-27T12:16:38.771Z 2026-04-03T12:39:48.485Z
9584898 9584898 20260325223424_53jS1 UK009D 2026-03-27T12:16:19.149Z 2026-04-03T12:39:43.462Z
9584791 9584791 20260325221506_VuK99 UK009D 2026-03-27T12:16:08.495Z 2026-04-03T12:39:41.183Z
9584761 9584761 20260325220033_f4VW6 UK009D 2026-03-27T12:16:04.664Z 2026-04-03T12:39:39.957Z
9584740 9584740 20260325215319_p2mTh UK009D 2026-03-27T12:16:02.176Z 2026-04-03T12:39:34.663Z
9584618 9584618 20260325211036_O86y1 UK009D 2026-03-27T12:15:50.316Z 2026-04-03T12:39:24.368Z
9584564 9584564 20260325204404_8ZBL4 UK009D 2026-03-27T12:15:40.190Z 2026-04-03T12:39:21.965Z
9584548 9584548 20260325203814_c2XJx UK009D 2026-03-27T12:15:37.467Z 2026-04-03T12:39:19.479Z
9584530 9584530 20260325202956_SjQdj UK009D 2026-03-27T12:15:35.335Z 2026-04-03T12:39:18.843Z
9581482 9581482 20260326031743_lVX2U UK009D 2026-03-27T12:03:14.856Z 2026-04-04T12:39:07.939Z
9581235 9581235 20260326024025_sOtmb UK009D 2026-03-27T12:02:28.785Z 2026-04-04T12:38:47.709Z
9580735 9580735 20260326012413_CAkZh UK009D 2026-03-27T12:01:17.359Z 2026-04-04T12:38:21.932Z
9580676 9580676 20260326011457_wfDbY UK009D 2026-03-27T12:01:08.095Z 2026-04-04T12:38:20.329Z
9580566 9580566 20260326010243_olqGo UK009D 2026-03-27T12:00:49.231Z 2026-04-04T12:38:14.350Z
9580474 9580474 20260326005350_gli32 UK009D 2026-03-27T12:00:33.449Z 2026-04-04T12:38:11.515Z
9579695 9579695 20260324221834_Tzx92 UK009D 2026-03-26T12:14:13.271Z 2026-04-02T12:37:26.151Z
9577322 9577322 20260325045414_pLOGD UK009D 2026-03-26T12:04:46.524Z 2026-04-03T12:36:56.615Z
9577311 9577311 20260325044929_1kFVg UK009D 2026-03-26T12:04:45.199Z 2026-04-03T12:36:56.212Z
9576078 9576078 20260325010947_EnWq5 UK009D 2026-03-26T12:01:12.699Z 2026-04-03T12:35:43.426Z
9575798 9575798 20260325001906_1doBG UK009D 2026-03-26T12:00:15.216Z 2026-04-03T12:35:22.733Z
9575782 9575782 20260325001741_6n5j4 UK009D 2026-03-26T12:00:12.149Z 2026-04-03T12:35:22.067Z
9575778 9575778 20260325001542_R2SIV UK009D 2026-03-26T12:00:10.798Z 2026-04-03T12:35:21.866Z
9570488 9570488 20260322213900_QIwHO UK009D 2026-03-24T12:23:21.398Z 2026-03-30T12:30:44.096Z
9562101 9562101 20260323013303_qm4zr UK009D 2026-03-24T12:02:07.890Z 2026-03-31T12:26:01.273Z
9562052 9562052 20260323012613_shCDg UK009D 2026-03-24T12:02:01.646Z 2026-03-31T12:26:00.364Z
9561788 9561788 20260323004340_i2GGL UK009D 2026-03-24T12:01:18.153Z 2026-03-31T12:25:53.738Z
9561648 9561648 20260323001912_v749v UK009D 2026-03-24T12:00:49.872Z 2026-03-31T12:25:49.658Z
9561449 9561449 20260321233425_3grRy UK009D 2026-03-23T12:12:19.291Z 2026-03-29T12:21:07.386Z
9560843 9560843 20260321222614_lzjh9 UK009D 2026-03-23T12:12:05.063Z 2026-03-29T12:21:03.292Z
9560767 9560767 20260321221143_6YjtN UK009D 2026-03-23T12:12:02.969Z 2026-03-29T12:21:02.738Z
9560694 9560694 20260321220456_CzzfJ UK009D 2026-03-23T12:12:01.384Z 2026-03-29T12:21:02.241Z
9560577 9560577 20260321214146_ZSQ4n UK009D 2026-03-23T12:11:53.621Z 2026-03-29T12:21:01.506Z
9560571 9560571 20260321214144_rsIny UK009D 2026-03-23T12:11:53.301Z 2026-03-29T12:21:01.464Z
9560387 9560387 20260321210738_7ftQb UK009D 2026-03-23T12:11:44.917Z 2026-03-29T12:20:59.805Z
9560094 9560094 20260321203220_AUC3J UK009D 2026-03-23T12:11:37.964Z 2026-03-29T12:20:57.951Z
9559835 9559835 20260321195745_7jKq8 UK009D 2026-03-23T12:11:31.706Z 2026-03-29T12:20:56.026Z
9559784 9559784 20260321194700_eIVcQ UK009D 2026-03-23T12:11:29.854Z 2026-03-29T12:20:51.950Z
9559773 9559773 20260321194430_votiG UK009D 2026-03-23T12:11:29.724Z 2026-03-29T12:20:51.684Z
9559755 9559755 20260321193936_mjK18 UK009D 2026-03-23T12:11:29.104Z 2026-03-29T12:20:50.826Z
9559733 9559733 20260321193633_NvLHx UK009D 2026-03-23T12:11:28.386Z 2026-03-29T12:20:48.433Z
9555457 9555457 20260322045718_cSClq UK009D 2026-03-23T12:03:26.402Z 2026-03-30T12:28:26.664Z
9555012 9555012 20260322035437_hH22p UK009D 2026-03-23T12:03:02.672Z 2026-03-30T12:28:13.209Z
9554911 9554911 20260322034329_2pm2k UK009D 2026-03-23T12:02:56.343Z 2026-03-30T12:28:11.413Z
9554061 9554061 20260322023517_SRJTQ UK009D 2026-03-23T12:02:11.570Z 2026-03-30T12:27:57.573Z
9553852 9553852 20260322022107_fXomb UK009D 2026-03-23T12:01:55.440Z 2026-03-30T12:27:53.549Z
9553802 9553802 20260322021514_CrcFW UK009D 2026-03-23T12:01:52.653Z 2026-03-30T12:27:52.801Z
9553762 9553762 20260322021227_CDB9I UK009D 2026-03-23T12:01:50.417Z 2026-03-30T12:27:52.158Z
9553661 9553661 20260322020524_egWsG UK009D 2026-03-23T12:01:45.246Z 2026-03-30T12:27:50.811Z
9553296 9553296 20260322012958_oa3PH UK009D 2026-03-23T12:01:23.428Z 2026-03-30T12:27:39.182Z
9553015 9553015 20260322010440_AGWP8 UK009D 2026-03-23T12:01:09.476Z 2026-03-30T12:27:33.767Z
9552633 9552633 20260322002508_ldDiX UK009D 2026-03-23T12:00:38.494Z 2026-03-30T12:27:27.273Z
9552565 9552565 20260322002048_OOC2V UK009D 2026-03-23T12:00:32.921Z 2026-03-30T12:27:26.128Z
9552491 9552491 20260322001509_s5MJS UK009D 2026-03-23T12:00:28.910Z 2026-03-30T12:27:25.101Z
9552142 9552142 20260320230404_OGs4w UK009D 2026-03-22T12:27:29.503Z 2026-03-28T12:37:07.247Z
9552129 9552129 20260320230305_DtSwO UK009D 2026-03-22T12:27:28.942Z 2026-03-28T12:37:07.166Z
9552115 9552115 20260320230115_Tbc32 UK009D 2026-03-22T12:27:28.167Z 2026-03-28T12:37:07.062Z
9551965 9551965 20260320222414_IGddj UK009D 2026-03-22T12:27:20.026Z 2026-03-28T12:37:05.043Z
9551927 9551927 20260320221347_zheMm UK009D 2026-03-22T12:27:17.938Z 2026-03-28T12:37:04.310Z
9551800 9551800 20260320214117_3FLHW UK009D 2026-03-22T12:27:03.487Z 2026-03-28T12:37:02.314Z
9551748 9551748 20260320212016_SVwi9 UK009D 2026-03-22T12:27:00.494Z 2026-03-28T12:37:01.492Z
9551528 9551528 20260320200942_478UN UK009D 2026-03-22T12:26:45.835Z 2026-03-28T12:36:57.395Z
9549136 9549136 20260319234912_zGaBY UK009D 2026-03-22T12:16:49.354Z 2026-03-28T12:33:21.534Z
9543643 9543643 20260321043450_8xUDP UK009D 2026-03-22T12:04:20.497Z 2026-03-29T12:19:09.673Z
9542342 9542342 20260319231330_DECVW UK009D 2026-03-21T12:29:58.466Z 2026-03-27T12:42:57.486Z
9542228 9542228 20260319230302_rm353 UK009D 2026-03-21T12:29:52.861Z 2026-03-27T12:42:50.419Z
9542209 9542209 20260319225945_Q8mCQ UK009D 2026-03-21T12:29:51.586Z 2026-03-27T12:42:49.740Z
9542093 9542093 20260319224755_mtNbm UK009D 2026-03-21T12:29:39.748Z 2026-03-27T12:42:45.136Z
9542029 9542029 20260319223448_D8Cv3 UK009D 2026-03-21T12:29:36.734Z 2026-03-27T12:42:44.395Z
9541923 9541923 20260319220724_QlX0H UK009D 2026-03-21T12:29:29.946Z 2026-03-27T12:42:43.039Z
9541891 9541891 20260319220051_kWhDC UK009D 2026-03-21T12:29:28.150Z 2026-03-27T12:42:42.736Z
9541754 9541754 20260319213602_RrwxM UK009D 2026-03-21T12:29:19.716Z 2026-03-27T12:42:41.318Z
9541695 9541695 20260319212747_ohBii UK009D 2026-03-21T12:29:16.874Z 2026-03-27T12:42:40.881Z
9541625 9541625 20260319211235_tPbZl UK009D 2026-03-21T12:29:13.558Z 2026-03-27T12:42:40.360Z
9541584 9541584 20260319210750_kf0RW UK009D 2026-03-21T12:29:12.025Z 2026-03-27T12:42:39.046Z
9541558 9541558 20260319210408_gY1Bo UK009D 2026-03-21T12:29:10.555Z 2026-03-27T12:42:38.736Z
9534954 9534954 20260320044805_6JKDS UK009D 2026-03-21T12:09:17.926Z 2026-03-28T12:34:24.114Z
9534900 9534900 20260320043859_E6ipb UK009D 2026-03-21T12:09:08.470Z 2026-03-28T12:34:23.401Z
9534843 9534843 20260320042917_DMIAX UK009D 2026-03-21T12:09:01.095Z 2026-03-28T12:34:22.761Z
9534708 9534708 20260320041421_bXF7y UK009D 2026-03-21T12:08:41.238Z 2026-03-28T12:34:21.164Z
9534661 9534661 20260320041032_S83gi UK009D 2026-03-21T12:08:34.598Z 2026-03-28T12:34:20.631Z
9534640 9534640 20260320041017_wRANd UK009D 2026-03-21T12:08:32.985Z 2026-03-28T12:34:20.481Z
9534436 9534436 20260320034937_yqflr UK009D 2026-03-21T12:08:00.416Z 2026-03-28T12:34:18.346Z
9534260 9534260 20260320033853_bnSjm UK009D 2026-03-21T12:07:35.038Z 2026-03-28T12:34:16.733Z
9533779 9533779 20260320025730_eNwy3 UK009D 2026-03-21T12:06:15.625Z 2026-03-28T12:34:00.417Z
9533441 9533441 20260320023052_zWKQQ UK009D 2026-03-21T12:05:26.633Z 2026-03-28T12:33:53.070Z
9532968 9532968 20260320014328_d1a4p UK009D 2026-03-21T12:04:07.886Z 2026-03-28T12:33:47.146Z
9532726 9532726 20260320012046_SyIvn UK009D 2026-03-21T12:03:28.925Z 2026-03-28T12:33:35.637Z
9532689 9532689 20260320011800_bvNMh UK009D 2026-03-21T12:03:23.243Z 2026-03-28T12:33:35.182Z
9532675 9532675 20260320011743_mDIYH UK009D 2026-03-21T12:03:22.668Z 2026-03-28T12:33:35.124Z
9532345 9532345 20260320004809_LuODk UK009D 2026-03-21T12:02:26.495Z 2026-03-28T12:33:28.067Z
9532295 9532295 20260320004425_keHWw UK009D 2026-03-21T12:02:18.554Z 2026-03-28T12:33:27.235Z
9532244 9532244 20260320004028_frwf3 UK009D 2026-03-21T12:02:09.580Z 2026-03-28T12:33:26.129Z
9532196 9532196 20260320003513_dluaI UK009D 2026-03-21T12:02:01.035Z 2026-03-28T12:33:25.757Z
9532115 9532115 20260320002024_42hgj UK009D 2026-03-21T12:01:45.115Z 2026-03-28T12:33:24.707Z

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