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 = "UK002F" 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
8680271 8680271 20251202225456_yyOco UK002F 2025-12-04T14:11:32.399Z 2025-12-05T14:20:30.540Z
8679398 8679398 20251202200000_tqJOJ UK002F 2025-12-04T14:09:43.895Z 2025-12-05T14:19:41.346Z
8676832 8676832 20251202062756_Dpbv2 UK002F 2025-12-03T14:25:52.369Z 2025-12-05T14:29:14.581Z
8676583 8676583 20251202060414_X52Ag UK002F 2025-12-03T14:25:20.320Z 2025-12-05T14:29:08.330Z
8676448 8676448 20251202055315_g4Ivq UK002F 2025-12-03T14:25:13.099Z 2025-12-05T14:28:56.569Z
8676430 8676430 20251202055207_MmdIZ UK002F 2025-12-03T14:25:12.459Z 2025-12-05T14:28:56.341Z
8676153 8676153 20251202053907_eBwmt UK002F 2025-12-03T14:24:47.195Z 2025-12-05T14:28:49.702Z
8676128 8676128 20251202053845_NKTYF UK002F 2025-12-03T14:24:44.835Z 2025-12-05T14:28:49.378Z
8676110 8676110 20251202053707_eUJbc UK002F 2025-12-03T14:24:43.168Z 2025-12-05T14:28:48.961Z
8676093 8676093 20251202053701_ezluA UK002F 2025-12-03T14:24:42.202Z 2025-12-05T14:28:48.593Z
8668120 8668120 20251130061300_Qi18J UK002F 2025-12-02T14:42:03.129Z 2025-12-05T14:45:43.720Z
8667418 8667418 20251130010552_m4ZoX UK002F 2025-12-02T14:38:02.879Z 2025-12-05T14:42:43.629Z
8663151 8663151 20251130201558_XrzL2 UK002F 2025-12-02T14:17:33.091Z 2025-12-05T14:33:58.608Z
8663109 8663109 20251130201148_sry1U UK002F 2025-12-02T14:17:28.653Z 2025-12-05T14:33:57.515Z
8663058 8663058 20251130200100_KmeTX UK002F 2025-12-02T14:17:21.757Z 2025-12-05T14:33:55.825Z
8662116 8662116 20251130180121_MzLhK UK002F 2025-12-02T14:14:22.311Z 2025-12-05T14:33:07.984Z
8661895 8661895 20251130173013_3GTHD UK002F 2025-12-02T14:13:34.117Z 2025-12-05T14:32:40.971Z
8657973 8657973 20251130062416_HXXzu UK002F 2025-12-01T14:34:48.656Z 2025-12-05T14:45:59.878Z
8657854 8657854 20251130061300_fUrG7 UK002F 2025-12-01T14:34:43.770Z 2025-12-01T14:35:23.441Z
8657824 8657824 20251130061105_U9pvH UK002F 2025-12-01T14:34:42.673Z 2025-12-05T14:45:42.170Z
8657807 8657807 20251130061009_RyVs9 UK002F 2025-12-01T14:34:42.100Z 2025-12-05T14:45:41.887Z
8657771 8657771 20251130060809_7vVBo UK002F 2025-12-01T14:34:40.925Z 2025-12-05T14:45:36.703Z
8657759 8657759 20251130060625_Cpcoo UK002F 2025-12-01T14:34:40.261Z 2025-12-05T14:45:36.557Z
8657518 8657518 20251130055059_E4Wha UK002F 2025-12-01T14:34:32.057Z 2025-12-05T14:45:32.895Z
8657145 8657145 20251130053152_kQ8fR UK002F 2025-12-01T14:33:56.150Z 2025-12-05T14:45:25.996Z
8657131 8657131 20251130053152_rraPH UK002F 2025-12-01T14:33:55.926Z 2025-12-05T14:45:25.906Z
8657120 8657120 20251130053130_23gBX UK002F 2025-12-01T14:33:55.316Z 2025-12-05T14:45:25.755Z
8657079 8657079 20251130052915_wt8fP UK002F 2025-12-01T14:33:53.777Z 2025-12-05T14:45:25.331Z
8656947 8656947 20251130052028_qI00i UK002F 2025-12-01T14:33:49.767Z 2025-12-05T14:45:23.873Z
8656908 8656908 20251130051728_2a1FR UK002F 2025-12-01T14:33:49.010Z 2025-12-05T14:45:23.242Z
8656876 8656876 20251130051512_5gFhx UK002F 2025-12-01T14:33:48.032Z 2025-12-05T14:45:22.925Z
8656673 8656673 20251130050601_MNGtd UK002F 2025-12-01T14:28:53.811Z 2025-12-05T14:45:19.930Z
8656653 8656653 20251130050507_0dAMX UK002F 2025-12-01T14:28:52.221Z 2025-12-05T14:45:19.667Z
8656552 8656552 20251130045901_ZCWIc UK002F 2025-12-01T14:28:44.628Z 2025-12-05T14:45:17.630Z
8656549 8656549 20251130045858_GbEn6 UK002F 2025-12-01T14:28:44.354Z 2025-12-05T14:45:17.553Z
8656469 8656469 20251130045657_WEu37 UK002F 2025-12-01T14:28:40.091Z 2025-12-05T14:45:16.547Z
8656266 8656266 20251130044551_bJ6Hi UK002F 2025-12-01T14:28:14.787Z 2025-12-05T14:44:49.489Z
8656129 8656129 20251130043928_fnf9t UK002F 2025-12-01T14:28:05.579Z 2025-12-05T14:44:46.435Z
8655899 8655899 20251130042408_RUocl UK002F 2025-12-01T14:27:39.505Z 2025-12-05T14:44:40.968Z
8655828 8655828 20251130042032_6po1V UK002F 2025-12-01T14:27:31.976Z 2025-12-05T14:44:39.710Z
8655765 8655765 20251130041716_FBBEC UK002F 2025-12-01T14:27:27.599Z 2025-12-05T14:44:38.667Z
8655760 8655760 20251130041702_3hIt4 UK002F 2025-12-01T14:27:27.320Z 2025-12-05T14:44:38.480Z
8655661 8655661 20251130041056_A22B0 UK002F 2025-12-01T14:27:20.554Z 2025-12-05T14:44:36.780Z
8655540 8655540 20251130040648_Wzx2z UK002F 2025-12-01T14:27:02.794Z 2025-12-05T14:44:35.174Z
8655339 8655339 20251130035540_EkKSV UK002F 2025-12-01T14:26:48.128Z 2025-12-05T14:44:32.289Z
8655261 8655261 20251130035130_ooMXG UK002F 2025-12-01T14:26:42.377Z 2025-12-05T14:44:30.768Z
8655248 8655248 20251130035034_aUEw7 UK002F 2025-12-01T14:26:41.544Z 2025-12-05T14:44:30.324Z
8655176 8655176 20251130034740_3q2Pm UK002F 2025-12-01T14:26:37.212Z 2025-12-05T14:44:29.405Z
8655166 8655166 20251130034658_X93Rf UK002F 2025-12-01T14:26:37.001Z 2025-12-05T14:44:29.364Z
8655140 8655140 20251130034542_Sav5u UK002F 2025-12-01T14:26:27.106Z 2025-12-05T14:44:28.781Z
8655030 8655030 20251130034110_zS9us UK002F 2025-12-01T14:26:16.533Z 2025-12-05T14:44:26.970Z
8654797 8654797 20251130033318_7YSAb UK002F 2025-12-01T14:26:03.065Z 2025-12-05T14:44:24.022Z
8654587 8654587 20251130032105_vb2YR UK002F 2025-12-01T14:25:36.007Z 2025-12-05T14:44:12.580Z
8654511 8654511 20251130031904_hLvpE UK002F 2025-12-01T14:25:32.341Z 2025-12-05T14:44:08.054Z
8654420 8654420 20251130031503_lq7ve UK002F 2025-12-01T14:25:23.867Z 2025-12-05T14:43:55.521Z
8654385 8654385 20251130031358_qnYxp UK002F 2025-12-01T14:25:21.570Z 2025-12-05T14:43:54.815Z
8654335 8654335 20251130031127_IA0Ix UK002F 2025-12-01T14:25:09.988Z 2025-12-05T14:43:53.999Z
8654229 8654229 20251130030443_kVFAs UK002F 2025-12-01T14:25:00.242Z 2025-12-05T14:43:51.496Z
8654121 8654121 20251130025958_Xm0PE UK002F 2025-12-01T14:24:53.640Z 2025-12-05T14:43:47.683Z
8653893 8653893 20251130024701_4mrQP UK002F 2025-12-01T14:24:26.908Z 2025-12-05T14:43:42.426Z
8653877 8653877 20251130024515_i9L2z UK002F 2025-12-01T14:24:24.861Z 2025-12-05T14:43:41.927Z
8653721 8653721 20251130023759_RtHpr UK002F 2025-12-01T14:24:07.736Z 2025-12-05T14:43:38.523Z
8653679 8653679 20251130023353_aFu7a UK002F 2025-12-01T14:23:55.589Z 2025-12-05T14:43:37.540Z
8653586 8653586 20251130022733_6F331 UK002F 2025-12-01T14:23:44.398Z 2025-12-05T14:43:35.673Z
8653490 8653490 20251130021901_dXJlw UK002F 2025-12-01T14:23:35.178Z 2025-12-05T14:43:32.869Z
8653472 8653472 20251130021800_YOCk4 UK002F 2025-12-01T14:23:33.453Z 2025-12-05T14:43:32.302Z
8653377 8653377 20251130021317_HXdn0 UK002F 2025-12-01T14:23:18.998Z 2025-12-05T14:43:30.205Z
8653357 8653357 20251130021224_k2NR8 UK002F 2025-12-01T14:23:17.937Z 2025-12-05T14:43:29.992Z
8653349 8653349 20251130021146_7FcLo UK002F 2025-12-01T14:23:15.802Z 2025-12-05T14:43:29.659Z
8653304 8653304 20251130020933_sdTHo UK002F 2025-12-01T14:23:12.308Z 2025-12-05T14:43:28.483Z
8653271 8653271 20251130020509_Ufqfg UK002F 2025-12-01T14:23:08.572Z 2025-12-05T14:43:06.958Z
8653241 8653241 20251130020447_2B8Ps UK002F 2025-12-01T14:23:07.362Z 2025-12-05T14:43:06.444Z
8653123 8653123 20251130015922_l3bSW UK002F 2025-12-01T14:22:51.679Z 2025-12-05T14:43:04.283Z
8653085 8653085 20251130015540_3dMTR UK002F 2025-12-01T14:22:45.989Z 2025-12-05T14:43:03.177Z
8653061 8653061 20251130015339_LXacU UK002F 2025-12-01T14:22:43.607Z 2025-12-05T14:43:02.286Z
8653006 8653006 20251130015056_uzveL UK002F 2025-12-01T14:22:38.429Z 2025-12-05T14:42:59.070Z
8652977 8652977 20251130014859_jkAJM UK002F 2025-12-01T14:22:36.502Z 2025-12-05T14:42:58.659Z
8652910 8652910 20251130014512_xoj6p UK002F 2025-12-01T14:22:30.451Z 2025-12-05T14:42:57.345Z
8652905 8652905 20251130014449_gDmx1 UK002F 2025-12-01T14:22:30.040Z 2025-12-05T14:42:57.282Z
8652817 8652817 20251130013640_gvUad UK002F 2025-12-01T14:22:10.334Z 2025-12-05T14:42:53.590Z
8652635 8652635 20251130012534_3vcfP UK002F 2025-12-01T14:21:53.890Z 2025-12-05T14:42:49.127Z
8652561 8652561 20251130012106_yu2iw UK002F 2025-12-01T14:21:41.515Z 2025-12-05T14:42:47.935Z
8652328 8652328 20251130010316_tv79o UK002F 2025-12-01T14:21:16.452Z 2025-12-05T14:42:42.895Z
8652273 8652273 20251130010134_3CP8U UK002F 2025-12-01T14:21:05.850Z 2025-12-05T14:42:41.458Z
8652236 8652236 20251130005715_SbOhc UK002F 2025-12-01T14:20:58.728Z 2025-12-05T14:42:40.089Z
8652176 8652176 20251130005142_TNYTs UK002F 2025-12-01T14:20:51.700Z 2025-12-05T14:42:28.858Z
8652100 8652100 20251130004738_LoXoP UK002F 2025-12-01T14:20:43.274Z 2025-12-05T14:42:20.800Z
8652022 8652022 20251130004144_igd3d UK002F 2025-12-01T14:20:29.684Z 2025-12-05T14:42:13.864Z
8650380 8650380 20251129200522_kIsX9 UK002F 2025-12-01T14:15:56.842Z 2025-12-05T14:41:05.337Z
8650299 8650299 20251129195116_IedoS UK002F 2025-12-01T14:15:45.193Z 2025-12-05T14:41:03.067Z
8650183 8650183 20251129193534_lSvWj UK002F 2025-12-01T14:15:20.638Z 2025-12-05T14:40:58.667Z
8649976 8649976 20251129185950_2f3nG UK002F 2025-12-01T14:14:37.214Z 2025-12-05T14:40:43.843Z
8649879 8649879 20251129184746_XkD18 UK002F 2025-12-01T14:14:12.565Z 2025-12-05T14:40:25.764Z
8649658 8649658 20251129180343_G79as UK002F 2025-12-01T14:13:26.312Z 2025-12-05T14:40:15.742Z
8649412 8649412 20251129172229_a82I3 UK002F 2025-12-01T14:12:28.409Z 2025-12-05T14:40:07.582Z
8649403 8649403 20251129172205_yVzl0 UK002F 2025-12-01T14:12:26.717Z 2025-12-05T14:40:07.207Z
8646166 8646166 20251129011740_Ov6Jf UK002F 2025-11-30T14:25:19.093Z 2025-12-05T14:51:34.648Z
8646119 8646119 20251129010838_vYK2c UK002F 2025-11-30T14:25:14.127Z 2025-12-05T14:51:33.519Z
8646106 8646106 20251129010617_6B2zQ UK002F 2025-11-30T14:25:12.283Z 2025-12-05T14:51:33.174Z
8643820 8643820 20251128182920_n2BGH UK002F 2025-11-30T14:20:42.864Z 2025-12-05T14:49:47.729Z

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