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

691 rows where station_code = "UK00DA" 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
8682219 8682219 20251203050246_iIocV UK00DA 2025-12-04T14:16:38.383Z 2025-12-05T14:22:18.933Z
8682142 8682142 20251203045452_RaBBZ UK00DA 2025-12-04T14:16:29.961Z 2025-12-05T14:22:15.709Z
8682099 8682099 20251203045047_XLHfP UK00DA 2025-12-04T14:16:26.701Z 2025-12-05T14:22:14.592Z
8682085 8682085 20251203044702_c94mT UK00DA 2025-12-04T14:16:22.115Z 2025-12-05T14:22:13.699Z
8681941 8681941 20251203043132_VvwKk UK00DA 2025-12-04T14:16:02.607Z 2025-12-05T14:22:09.005Z
8681913 8681913 20251203042704_QSlR0 UK00DA 2025-12-04T14:15:59.382Z 2025-12-05T14:22:06.939Z
8681879 8681879 20251203041836_arPv5 UK00DA 2025-12-04T14:15:49.944Z 2025-12-05T14:22:04.953Z
8681575 8681575 20251203032552_Ogp2S UK00DA 2025-12-04T14:15:04.206Z 2025-12-05T14:21:41.705Z
8681525 8681525 20251203032141_7g0RN UK00DA 2025-12-04T14:14:51.981Z 2025-12-05T14:21:40.114Z
8681455 8681455 20251203031203_XUJWE UK00DA 2025-12-04T14:14:44.923Z 2025-12-05T14:21:37.820Z
8681450 8681450 20251203031203_muCHB UK00DA 2025-12-04T14:14:44.474Z 2025-12-05T14:21:37.717Z
8681411 8681411 20251203030522_l2iZg UK00DA 2025-12-04T14:14:40.041Z 2025-12-05T14:21:35.983Z
8681381 8681381 20251203030138_keE2i UK00DA 2025-12-04T14:14:35.817Z 2025-12-05T14:21:34.557Z
8681279 8681279 20251203025225_t5qDJ UK00DA 2025-12-04T14:14:14.924Z 2025-12-05T14:21:30.248Z
8677057 8677057 20251202064306_axwXM UK00DA 2025-12-03T14:26:14.366Z 2025-12-05T14:29:19.556Z
8676853 8676853 20251202062759_i9Ph2 UK00DA 2025-12-03T14:25:52.815Z 2025-12-05T14:29:14.703Z
8676635 8676635 20251202060933_T3bUR UK00DA 2025-12-03T14:25:22.801Z 2025-12-05T14:29:09.246Z
8676626 8676626 20251202060852_GTz42 UK00DA 2025-12-03T14:25:22.449Z 2025-12-05T14:29:09.133Z
8676542 8676542 20251202060101_SXPEA UK00DA 2025-12-03T14:25:17.423Z 2025-12-05T14:29:01.123Z
8676497 8676497 20251202055527_gyFsG UK00DA 2025-12-03T14:25:14.529Z 2025-12-05T14:28:57.255Z
8676427 8676427 20251202055148_BwZvy UK00DA 2025-12-03T14:25:11.972Z 2025-12-05T14:28:56.189Z
8676194 8676194 20251202053955_Z1Qhy UK00DA 2025-12-03T14:24:48.658Z 2025-12-05T14:28:50.179Z
8675361 8675361 20251202043132_w7ZIK UK00DA 2025-12-03T14:23:33.657Z 2025-12-05T14:28:20.907Z
8675304 8675304 20251202042601_vsoN5 UK00DA 2025-12-03T14:23:30.010Z 2025-12-05T14:28:19.345Z
8675221 8675221 20251202041801_1TvKz UK00DA 2025-12-03T14:23:21.465Z 2025-12-05T14:28:17.003Z
8675210 8675210 20251202041758_3s3pA UK00DA 2025-12-03T14:23:20.672Z 2025-12-05T14:28:16.802Z
8675017 8675017 20251202035228_JBv6E UK00DA 2025-12-03T14:22:50.749Z 2025-12-05T14:28:09.296Z
8675004 8675004 20251202035141_fSF32 UK00DA 2025-12-03T14:22:49.753Z 2025-12-05T14:28:08.958Z
8674969 8674969 20251202034514_bEb57 UK00DA 2025-12-03T14:22:46.932Z 2025-12-05T14:28:07.984Z
8674897 8674897 20251202033652_pT7HE UK00DA 2025-12-03T14:22:40.649Z 2025-12-05T14:28:05.953Z
8674761 8674761 20251202032036_oWjBH UK00DA 2025-12-03T14:22:18.352Z 2025-12-05T14:28:02.019Z
8674681 8674681 20251202030653_G3pzT UK00DA 2025-12-03T14:22:12.245Z 2025-12-05T14:27:59.537Z
8674543 8674543 20251202024330_YrlcO UK00DA 2025-12-03T14:21:46.577Z 2025-12-05T14:27:54.777Z
8674506 8674506 20251202023708_Vt95J UK00DA 2025-12-03T14:21:42.982Z 2025-12-05T14:27:45.269Z
8674490 8674490 20251202023306_d0ZQJ UK00DA 2025-12-03T14:21:41.831Z 2025-12-05T14:27:42.991Z
8674378 8674378 20251202021337_rXUfK UK00DA 2025-12-03T14:21:33.166Z 2025-12-05T14:27:39.562Z
8674356 8674356 20251202020727_2o3qX UK00DA 2025-12-03T14:21:27.557Z 2025-12-05T14:27:38.794Z
8674350 8674350 20251202020608_eXtt3 UK00DA 2025-12-03T14:21:27.019Z 2025-12-05T14:27:38.463Z
8674282 8674282 20251202015624_GPLjI UK00DA 2025-12-03T14:21:21.200Z 2025-12-05T14:27:34.886Z
8674244 8674244 20251202015312_pHR02 UK00DA 2025-12-03T14:21:16.929Z 2025-12-05T14:27:33.632Z
8674220 8674220 20251202014759_9JXrz UK00DA 2025-12-03T14:21:10.860Z 2025-12-05T14:27:32.923Z
8674124 8674124 20251202013005_B8EpP UK00DA 2025-12-03T14:20:57.512Z 2025-12-05T14:27:29.534Z
8674065 8674065 20251202012337_xuayj UK00DA 2025-12-03T14:20:52.821Z 2025-12-05T14:27:27.902Z
8674043 8674043 20251202011559_aZDtO UK00DA 2025-12-03T14:20:47.138Z 2025-12-05T14:27:27.115Z
8673953 8673953 20251202004617_EGpAI UK00DA 2025-12-03T14:20:25.829Z 2025-12-05T14:27:23.774Z
8673917 8673917 20251202002659_KF3Kx UK00DA 2025-12-03T14:20:20.867Z 2025-12-05T14:27:22.871Z
8662320 8662320 20251130183047_VODJH UK00DA 2025-12-02T14:15:07.467Z 2025-12-05T14:33:16.725Z
8658144 8658144 20251130065151_Yz7Ks UK00DA 2025-12-01T14:34:58.172Z 2025-12-05T14:46:03.932Z
8657246 8657246 20251130053609_xUeUx UK00DA 2025-12-01T14:34:02.328Z 2025-12-05T14:45:27.444Z
8655710 8655710 20251130041158_vrx7E UK00DA 2025-12-01T14:27:21.692Z 2025-12-05T14:44:37.255Z
8655602 8655602 20251130040815_GqLlJ UK00DA 2025-12-01T14:27:15.360Z 2025-12-05T14:44:36.044Z
8654012 8654012 20251130025159_qoEtY UK00DA 2025-12-01T14:24:44.380Z 2025-12-05T14:43:44.939Z
8653982 8653982 20251130025000_gAhit UK00DA 2025-12-01T14:24:34.009Z 2025-12-05T14:43:43.812Z
8652647 8652647 20251130012603_acxvx UK00DA 2025-12-01T14:21:55.175Z 2025-12-05T14:42:49.348Z
8652353 8652353 20251130010357_z43NI UK00DA 2025-12-01T14:21:17.257Z 2025-12-05T14:42:43.019Z
8652133 8652133 20251130004916_tLlCX UK00DA 2025-12-01T14:20:46.756Z 2025-12-05T14:42:25.780Z
8651908 8651908 20251130003243_fcdgj UK00DA 2025-12-01T14:20:14.677Z 2025-12-05T14:42:11.050Z
8651808 8651808 20251130002042_BaekV UK00DA 2025-12-01T14:19:57.583Z 2025-12-05T14:42:06.627Z
8651134 8651134 20251129224625_Ln573 UK00DA 2025-12-01T14:18:04.316Z 2025-12-05T14:41:49.777Z
8642961 8642961 20251128170740_2AxsC UK00DA 2025-11-30T14:19:03.966Z 2025-12-05T14:49:07.816Z
8637711 8637711 20251128062150_DrrRc UK00DA 2025-11-29T14:27:45.103Z 2025-12-05T15:00:15.898Z
8637618 8637618 20251128055952_3q2Ed UK00DA 2025-11-29T14:27:37.702Z 2025-12-05T15:00:10.428Z
8637511 8637511 20251128054606_PYuwC UK00DA 2025-11-29T14:27:31.433Z 2025-12-05T14:59:56.779Z
8637402 8637402 20251128053721_32SiV UK00DA 2025-11-29T14:27:12.464Z 2025-12-05T14:59:50.883Z
8637106 8637106 20251128050116_RCwjW UK00DA 2025-11-29T14:26:50.700Z 2025-12-05T14:59:37.185Z
8637068 8637068 20251128045551_a5L4D UK00DA 2025-11-29T14:26:48.241Z 2025-12-05T14:59:36.613Z
8636866 8636866 20251128043128_L0fD8 UK00DA 2025-11-29T14:26:16.458Z 2025-12-05T14:59:30.927Z
8636804 8636804 20251128042830_la2h8 UK00DA 2025-11-29T14:26:12.972Z 2025-12-05T14:59:29.990Z
8636722 8636722 20251128041935_fTGnY UK00DA 2025-11-29T14:26:07.551Z 2025-12-05T14:59:28.633Z
8636393 8636393 20251128034137_H7cWS UK00DA 2025-11-29T14:25:26.806Z 2025-12-05T14:59:23.506Z
8636335 8636335 20251128033722_TWEYv UK00DA 2025-11-29T14:25:23.249Z 2025-12-05T14:59:22.909Z
8636262 8636262 20251128032953_V7dAi UK00DA 2025-11-29T14:25:17.351Z 2025-12-05T14:59:21.953Z
8636162 8636162 20251128032343_W86Go UK00DA 2025-11-29T14:24:58.777Z 2025-12-05T14:59:20.568Z
8635660 8635660 20251128023536_loXZN UK00DA 2025-11-29T14:23:59.051Z 2025-12-05T14:59:12.674Z
8634715 8634715 20251128011113_g8ON2 UK00DA 2025-11-29T14:21:57.595Z 2025-12-05T14:58:23.908Z
8634135 8634135 20251128002302_SL3a4 UK00DA 2025-11-29T14:20:48.161Z 2025-12-05T14:58:16.632Z
8634080 8634080 20251128002023_j1ThN UK00DA 2025-11-29T14:20:41.943Z 2025-12-05T14:58:16.209Z
8633956 8633956 20251128000815_4PUkB UK00DA 2025-11-29T14:20:32.806Z 2025-12-05T14:58:14.553Z
8633685 8633685 20251127234527_rzeJH UK00DA 2025-11-29T14:20:05.733Z 2025-12-05T14:57:54.434Z
8633248 8633248 20251127225640_uT8ei UK00DA 2025-11-29T14:19:18.537Z 2025-12-05T14:57:23.555Z
8632416 8632416 20251127210425_ECCz2 UK00DA 2025-11-29T14:17:26.654Z 2025-12-05T14:56:20.772Z
8632286 8632286 20251127204738_0i3F9 UK00DA 2025-11-29T14:17:12.738Z 2025-12-05T14:56:19.307Z
8632123 8632123 20251127203317_ZIVWw UK00DA 2025-11-29T14:17:01.664Z 2025-12-05T14:56:16.061Z
8616601 8616601 20251126061358_ILlPr UK00DA 2025-11-27T14:31:22.177Z 2025-12-04T15:11:41.261Z
8615937 8615937 20251126052850_lQMZF UK00DA 2025-11-27T14:30:17.716Z 2025-12-04T15:11:33.868Z
8615819 8615819 20251126052003_0UP29 UK00DA 2025-11-27T14:30:12.383Z 2025-12-04T15:11:32.700Z
8615732 8615732 20251126051447_2xkq9 UK00DA 2025-11-27T14:30:06.613Z 2025-12-04T15:11:31.562Z
8615664 8615664 20251126051212_2sPtS UK00DA 2025-11-27T14:30:04.304Z 2025-12-04T15:11:31.136Z
8615070 8615070 20251126044316_L1rB4 UK00DA 2025-11-27T14:28:57.789Z 2025-12-04T15:11:25.767Z
8614665 8614665 20251126042257_TkdfS UK00DA 2025-11-27T14:28:25.003Z 2025-12-04T15:10:57.535Z
8614150 8614150 20251126035351_pVWmn UK00DA 2025-11-27T14:27:23.273Z 2025-12-04T15:10:25.320Z
8614092 8614092 20251126035029_eI3o3 UK00DA 2025-11-27T14:27:12.417Z 2025-12-04T15:10:19.420Z
8613800 8613800 20251126033401_rvA6b UK00DA 2025-11-27T14:26:38.142Z 2025-12-04T15:09:51.827Z
8613425 8613425 20251126031650_Utn2h UK00DA 2025-11-27T14:25:51.779Z 2025-12-04T15:09:40.375Z
8612986 8612986 20251126025747_KVrZE UK00DA 2025-11-27T14:25:03.996Z 2025-12-04T15:09:36.285Z
8612976 8612976 20251126025742_ShdOT UK00DA 2025-11-27T14:25:03.464Z 2025-12-04T15:09:36.198Z
8612660 8612660 20251126024137_h44Z0 UK00DA 2025-11-27T14:24:26.337Z 2025-12-04T15:09:32.548Z
8612633 8612633 20251126024036_eFjhK UK00DA 2025-11-27T14:24:25.295Z 2025-12-04T15:09:32.308Z
8612446 8612446 20251126023159_Xav7Z UK00DA 2025-11-27T14:24:13.542Z 2025-12-04T15:09:30.773Z
8612188 8612188 20251126022115_gmuz8 UK00DA 2025-11-27T14:23:35.592Z 2025-12-04T15:09:28.132Z

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