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,375 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
9273465 9273465 20260128062356_aHmQi UK004J 2026-01-29T14:29:51.972Z 2026-01-29T14:30:25.819Z
9273048 9273048 20260128042935_Teltu UK004J 2026-01-29T14:28:33.238Z 2026-01-29T14:30:25.742Z
9273043 9273043 20260128042721_8DhL0 UK004J 2026-01-29T14:28:32.386Z 2026-01-29T14:30:25.740Z
9273011 9273011 20260128042338_by3Tx UK004J 2026-01-29T14:28:25.867Z 2026-01-29T14:30:25.735Z
9272985 9272985 20260128041506_ixChu UK004J 2026-01-29T14:28:22.422Z 2026-01-29T14:30:25.729Z
9272792 9272792 20260128033820_vf4lS UK004J 2026-01-29T14:27:50.580Z 2026-01-29T14:30:25.562Z
9272779 9272779 20260128032851_x2Wyl UK004J 2026-01-29T14:27:47.466Z 2026-01-29T14:30:25.553Z
9272302 9272302 20260128012940_HLLk2 UK004J 2026-01-29T14:26:21.961Z 2026-01-29T14:30:25.324Z
9272211 9272211 20260128004829_Kka6d UK004J 2026-01-29T14:25:56.793Z 2026-01-29T14:30:25.308Z
9272166 9272166 20260128002725_3hVeJ UK004J 2026-01-29T14:25:50.111Z 2026-01-29T14:30:25.292Z
9272151 9272151 20260128002645_vVYYC UK004J 2026-01-29T14:25:48.197Z 2026-01-29T14:30:25.290Z
9272088 9272088 20260127235510_OiOP0 UK004J 2026-01-29T14:25:32.646Z 2026-01-29T14:30:25.278Z
9272068 9272068 20260127233326_ShAc0 UK004J 2026-01-29T14:25:26.916Z 2026-01-29T14:30:25.273Z
9271778 9271778 20260127200410_2DxRG UK004J 2026-01-29T14:23:29.222Z 2026-01-29T14:30:25.136Z
9255996 9255996 20260124053613_JvGhj UK004J 2026-01-25T14:15:29.813Z 2026-01-29T14:48:17.025Z
9255075 9255075 20260124004212_oSlKU UK004J 2026-01-25T14:11:47.374Z 2026-01-29T14:47:01.508Z
9254986 9254986 20260124000051_5TCfH UK004J 2026-01-25T14:11:32.173Z 2026-01-29T14:46:58.364Z
9254944 9254944 20260123232219_Fj27R UK004J 2026-01-25T14:11:23.652Z 2026-01-29T14:46:56.637Z
9254749 9254749 20260123210834_dXyyI UK004J 2026-01-25T14:10:34.558Z 2026-01-29T14:46:40.837Z
9254697 9254697 20260123204553_r3944 UK004J 2026-01-25T14:10:23.615Z 2026-01-29T14:46:36.238Z
9254693 9254693 20260123204551_2ABTP UK004J 2026-01-25T14:10:22.974Z 2026-01-29T14:46:36.085Z
9254668 9254668 20260123204125_NgFjt UK004J 2026-01-25T14:10:18.327Z 2026-01-29T14:46:34.805Z
9254417 9254417 20260123190645_lX0Qf UK004J 2026-01-25T14:09:04.236Z 2026-01-29T14:46:14.858Z
9252171 9252171 20260123012940_cFfVP UK004J 2026-01-24T14:14:38.257Z 2026-01-29T14:52:37.640Z
9229928 9229928 20260119025638_q3FDV UK004J 2026-01-20T14:25:01.504Z 2026-01-27T15:04:15.227Z
9214157 9214157 20260116054809_O2di3 UK004J 2026-01-17T14:20:21.685Z 2026-01-24T15:13:18.812Z
9213352 9213352 20260116031635_Q7KjS UK004J 2026-01-17T14:16:35.416Z 2026-01-24T15:12:10.424Z
9213342 9213342 20260116031037_oumko UK004J 2026-01-17T14:16:30.746Z 2026-01-24T15:12:10.162Z
9213227 9213227 20260116024023_fbP1k UK004J 2026-01-17T14:15:59.466Z 2026-01-24T15:11:50.384Z
9212929 9212929 20260116014028_cnMhe UK004J 2026-01-17T14:14:38.187Z 2026-01-24T15:11:34.527Z
9207684 9207684 20260115024209_oLhO3 UK004J 2026-01-16T14:09:39.004Z 2026-01-22T15:03:29.737Z
9207518 9207518 20260115020118_11l08 UK004J 2026-01-16T14:09:03.958Z 2026-01-22T15:03:23.959Z
9203937 9203937 20260114055721_uXDa0 UK004J 2026-01-15T14:25:54.466Z 2026-01-22T15:10:15.875Z
9203440 9203440 20260114045730_IrTtE UK004J 2026-01-15T14:24:25.848Z 2026-01-22T15:10:07.766Z
9203349 9203349 20260114045136_VeqNg UK004J 2026-01-15T14:24:06.490Z 2026-01-22T15:10:06.045Z
9202406 9202406 20260114033618_r5jbg UK004J 2026-01-15T14:21:13.894Z 2026-01-22T15:09:17.310Z
9201716 9201716 20260114024427_7MSLZ UK004J 2026-01-15T14:19:25.264Z 2026-01-22T15:09:08.015Z
9195117 9195117 20260113002339_ZubIX UK004J 2026-01-14T14:12:05.496Z 2026-01-21T15:04:36.609Z
9194709 9194709 20260112221125_nTfS8 UK004J 2026-01-14T14:10:22.380Z 2026-01-21T15:04:20.229Z
9166743 9166743 20260107200830_n2olO UK004J 2026-01-09T14:04:44.212Z 2026-01-16T15:10:21.914Z
9166616 9166616 20260107192901_oaMVY UK004J 2026-01-09T14:04:05.955Z 2026-01-16T15:10:06.599Z
9163356 9163356 20260107062644_1cTOU UK004J 2026-01-08T14:08:52.717Z 2026-01-13T15:03:10.826Z
9163354 9163354 20260107062633_XNJ31 UK004J 2026-01-08T14:08:52.005Z 2026-01-13T15:03:10.580Z
9163279 9163279 20260107061623_gmDc1 UK004J 2026-01-08T14:08:39.664Z 2026-01-13T15:03:07.894Z
9163040 9163040 20260107053344_X0kR0 UK004J 2026-01-08T14:07:54.191Z 2026-01-13T15:02:59.139Z
9162793 9162793 20260107043158_Z7QH4 UK004J 2026-01-08T14:06:52.558Z 2026-01-13T15:02:39.133Z
9160528 9160528 20260106061015_2gVFV UK004J 2026-01-07T14:12:54.749Z 2026-01-13T15:09:31.227Z
9160400 9160400 20260106054620_FTwiC UK004J 2026-01-07T14:12:29.945Z 2026-01-13T15:09:24.748Z
9160231 9160231 20260106051119_AMYgi UK004J 2026-01-07T14:11:55.328Z 2026-01-13T15:09:15.728Z
9160200 9160200 20260106050144_l1YYe UK004J 2026-01-07T14:11:45.961Z 2026-01-13T15:09:07.283Z
9160181 9160181 20260106050000_z2Jjj UK004J 2026-01-07T14:11:39.913Z 2026-01-13T15:09:06.310Z
9160097 9160097 20260106044709_JnbXi UK004J 2026-01-07T14:11:23.430Z 2026-01-13T15:09:00.407Z
9160014 9160014 20260106043026_ThrPe UK004J 2026-01-07T14:11:05.318Z 2026-01-13T15:08:56.494Z
9159799 9159799 20260106035101_tqCKD UK004J 2026-01-07T14:10:27.038Z 2026-01-13T15:08:47.569Z
9159720 9159720 20260106033312_iGCYT UK004J 2026-01-07T14:10:14.724Z 2026-01-13T15:08:38.558Z
9159716 9159716 20260106033204_YDEF2 UK004J 2026-01-07T14:10:13.358Z 2026-01-13T15:08:38.219Z
9159462 9159462 20260106024440_16BaM UK004J 2026-01-07T14:09:22.166Z 2026-01-13T15:08:26.661Z
9159338 9159338 20260106022408_qpwNL UK004J 2026-01-07T14:09:02.297Z 2026-01-13T15:08:21.590Z
9158955 9158955 20260106010457_RPubM UK004J 2026-01-07T14:07:48.162Z 2026-01-13T15:07:52.835Z
9157597 9157597 20260105180542_9YNCw UK004J 2026-01-07T14:02:49.050Z 2026-01-13T15:06:19.581Z
9155877 9155877 20260104062821_zv2A9 UK004J 2026-01-06T14:38:09.130Z 2026-01-12T15:11:31.077Z
9155674 9155674 20260104061410_xkhW4 UK004J 2026-01-06T14:37:53.543Z 2026-01-12T15:11:23.818Z
9155087 9155087 20260104053506_No2aa UK004J 2026-01-06T14:36:47.677Z 2026-01-12T15:10:48.802Z
9154837 9154837 20260104051755_eOXYy UK004J 2026-01-06T14:36:15.383Z 2026-01-12T15:10:21.872Z
9154490 9154490 20260104045932_AI3qo UK004J 2026-01-06T14:35:37.546Z 2026-01-12T15:10:04.313Z
9154285 9154285 20260104045110_GYLc9 UK004J 2026-01-06T14:35:16.467Z 2026-01-12T15:09:44.258Z
9153617 9153617 20260104040419_h3Hs4 UK004J 2026-01-06T14:33:43.794Z 2026-01-12T15:08:58.205Z
9153451 9153451 20260104035702_9dJ21 UK004J 2026-01-06T14:33:22.853Z 2026-01-12T15:08:47.434Z
9150168 9150168 20260105011826_6K0A1 UK004J 2026-01-06T14:08:55.472Z 2026-01-13T15:13:08.996Z
9150150 9150150 20260105011510_2e4UW UK004J 2026-01-06T14:08:47.760Z 2026-01-13T15:13:07.932Z
9150143 9150143 20260105011404_0LqwQ UK004J 2026-01-06T14:08:46.361Z 2026-01-13T15:13:07.336Z
9149043 9149043 20260104183445_JaO3r UK004J 2026-01-06T14:03:35.320Z 2026-01-13T15:11:39.549Z
9148973 9148973 20260104181833_m98OB UK004J 2026-01-06T14:03:16.468Z 2026-01-13T15:11:33.514Z
9148413 9148413 20260103174458_Mv3Zm UK004J 2026-01-05T14:30:29.314Z 2026-01-10T15:04:29.653Z
9147737 9147737 20260104063849_rGxRU UK004J 2026-01-05T14:24:46.666Z 2026-01-12T15:11:35.520Z
9147694 9147694 20260104063110_dghZt UK004J 2026-01-05T14:24:43.543Z 2026-01-12T15:11:32.218Z
9147526 9147526 20260104060147_rLGSa UK004J 2026-01-05T14:24:20.709Z 2026-01-12T15:11:06.178Z
9147514 9147514 20260104060022_FyYUe UK004J 2026-01-05T14:24:19.549Z 2026-01-12T15:11:04.970Z
9147470 9147470 20260104055406_lZ6u0 UK004J 2026-01-05T14:24:12.310Z 2026-01-12T15:10:59.641Z
9147291 9147291 20260104052831_S2gM1 UK004J 2026-01-05T14:24:00.406Z 2026-01-12T15:10:29.092Z
9147210 9147210 20260104051921_I3E92 UK004J 2026-01-05T14:23:40.475Z 2026-01-12T15:10:22.002Z
9147164 9147164 20260104051245_H0rjS UK004J 2026-01-05T14:23:37.050Z 2026-01-12T15:10:18.626Z
9147144 9147144 20260104050950_Ci1Uh UK004J 2026-01-05T14:23:32.144Z 2026-01-12T15:10:15.987Z
9147128 9147128 20260104050703_RYBkZ UK004J 2026-01-05T14:23:29.752Z 2026-01-12T15:10:14.274Z
9147038 9147038 20260104045636_2u0UY UK004J 2026-01-05T14:23:24.121Z 2026-01-12T15:09:50.860Z
9147034 9147034 20260104045613_3agyL UK004J 2026-01-05T14:23:23.944Z 2026-01-12T15:09:50.452Z
9147007 9147007 20260104045409_icaLZ UK004J 2026-01-05T14:23:22.621Z 2026-01-12T15:09:48.924Z
9146963 9146963 20260104045149_JuyPx UK004J 2026-01-05T14:23:19.915Z 2026-01-12T15:09:44.667Z
9146837 9146837 20260104043329_ECzEy UK004J 2026-01-05T14:22:54.928Z 2026-01-12T15:09:34.787Z
9146818 9146818 20260104043231_ok3Yp UK004J 2026-01-05T14:22:53.915Z 2026-01-12T15:09:33.845Z
9146740 9146740 20260104042107_fibaO UK004J 2026-01-05T14:22:46.984Z 2026-01-12T15:09:11.977Z
9146723 9146723 20260104041826_3A3zD UK004J 2026-01-05T14:22:44.983Z 2026-01-05T14:30:34.357Z
9146664 9146664 20260104041359_XVzLt UK004J 2026-01-05T14:22:40.455Z 2026-01-12T15:09:04.696Z
9146574 9146574 20260104040105_qcK30 UK004J 2026-01-05T14:22:31.653Z 2026-01-12T15:08:56.147Z
9146537 9146537 20260104035803_SNgZL UK004J 2026-01-05T14:22:21.384Z 2026-01-12T15:08:52.057Z
9146518 9146518 20260104035708_wFLGu UK004J 2026-01-05T14:22:20.834Z 2026-01-12T15:08:48.867Z
9146485 9146485 20260104035323_Z2zqI UK004J 2026-01-05T14:22:18.968Z 2026-01-12T15:08:34.601Z
9146465 9146465 20260104035242_ew4Gi UK004J 2026-01-05T14:22:16.413Z 2026-01-12T15:08:33.408Z
9146450 9146450 20260104035142_8k94l UK004J 2026-01-05T14:22:15.192Z 2026-01-12T15:08:32.356Z
9146372 9146372 20260104034653_FONVn UK004J 2026-01-05T14:22:09.308Z 2026-01-12T15:08:26.582Z

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