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,613 rows where station_code = "US0054" 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
8638057 8638057 20251128081547_hrNQn US0054 2025-11-29T14:28:26.972Z 2025-12-05T15:00:45.379Z
8637964 8637964 20251128074026_s2LRv US0054 2025-11-29T14:28:20.359Z 2025-12-05T15:00:38.585Z
8637915 8637915 20251128072934_UdtbH US0054 2025-11-29T14:28:06.843Z 2025-12-05T15:00:34.478Z
8637849 8637849 20251128065218_tUFiV US0054 2025-11-29T14:27:55.501Z 2025-12-05T15:00:32.072Z
8637786 8637786 20251128064050_C6t2K US0054 2025-11-29T14:27:52.137Z 2025-12-05T15:00:27.178Z
8637257 8637257 20251128052101_sK6Q2 US0054 2025-11-29T14:27:01.500Z 2025-12-05T14:59:39.397Z
8637180 8637180 20251128051204_kaKDW US0054 2025-11-29T14:26:56.599Z 2025-12-05T14:59:38.352Z
8636539 8636539 20251128035557_azUk6 US0054 2025-11-29T14:25:38.099Z 2025-12-05T14:59:25.644Z
8627535 8627535 20251128111132_4xMQV US0054 2025-11-29T14:03:55.417Z 2025-12-05T14:47:01.535Z
8626716 8626716 20251128092701_F2Akm US0054 2025-11-29T14:01:18.367Z 2025-12-05T14:46:17.379Z
8626531 8626531 20251128085512_7mC3b US0054 2025-11-29T14:00:38.847Z 2025-12-05T14:46:12.573Z
8626400 8626400 20251128083203_52qQE US0054 2025-11-29T14:00:14.281Z 2025-12-05T14:46:10.173Z
8592644 8592644 20251124085049_4KyGg US0054 2025-11-25T14:27:23.466Z 2025-12-02T15:13:06.041Z
8582885 8582885 20251123090429_Xhrtp US0054 2025-11-24T14:34:35.531Z 2025-12-01T15:22:29.110Z
8582874 8582874 20251123090221_g7re5 US0054 2025-11-24T14:34:34.993Z 2025-12-01T15:22:28.891Z
8582749 8582749 20251123081945_TVd2X US0054 2025-11-24T14:34:28.881Z 2025-12-01T15:22:27.473Z
8582393 8582393 20251123060006_czrlk US0054 2025-11-24T14:33:33.242Z 2025-12-01T15:22:23.113Z
8582012 8582012 20251123033811_H66WR US0054 2025-11-24T14:33:04.328Z 2025-12-01T15:22:13.878Z
8501351 8501351 20251116104944_I2L2i US0054 2025-11-18T14:47:20.952Z 2025-11-24T15:06:28.815Z
8500445 8500445 20251116085805_leTbA US0054 2025-11-18T14:46:19.000Z 2025-11-24T15:05:41.895Z
8500371 8500371 20251116084621_HNrfw US0054 2025-11-18T14:46:09.106Z 2025-11-24T15:05:40.341Z
8500217 8500217 20251116081333_35EXK US0054 2025-11-18T14:45:39.472Z 2025-11-24T15:05:36.259Z
8500168 8500168 20251116075453_2SgY3 US0054 2025-11-18T14:45:35.344Z 2025-11-24T15:05:35.081Z
8500153 8500153 20251116075144_cagpF US0054 2025-11-18T14:45:34.663Z 2025-11-24T15:05:34.755Z
8500053 8500053 20251116072518_fYxy3 US0054 2025-11-18T14:45:28.895Z 2025-11-24T15:05:30.723Z
8500041 8500041 20251116072131_2Ejpq US0054 2025-11-18T14:45:28.165Z 2025-11-24T15:05:30.561Z
8486679 8486679 20251116112950_cPyCT US0054 2025-11-18T14:00:29.263Z 2025-11-25T15:06:00.017Z
8482231 8482231 20251116055049_fn2wv US0054 2025-11-17T14:22:55.639Z 2025-11-24T15:05:22.422Z
8482225 8482225 20251116055000_lmjzr US0054 2025-11-17T14:22:54.995Z 2025-11-24T15:05:22.354Z
8480874 8480874 20251116003520_DX9L0 US0054 2025-11-17T14:19:20.452Z 2025-11-24T15:04:56.828Z
8469023 8469023 20251115015155_8tLzZ US0054 2025-11-16T14:19:14.031Z 2025-11-23T15:17:33.517Z
8461897 8461897 20251114101503_QPADJ US0054 2025-11-15T14:25:02.326Z 2025-11-22T15:23:44.609Z
8461023 8461023 20251114082852_MwqAm US0054 2025-11-15T14:23:27.988Z 2025-11-22T15:23:00.805Z
8460427 8460427 20251114065731_rnZcS US0054 2025-11-15T14:22:05.689Z 2025-11-22T15:22:37.002Z
8459645 8459645 20251114041809_Oi8kL US0054 2025-11-15T14:20:10.934Z 2025-11-22T15:22:07.650Z
8452037 8452037 20251113103131_xe8T2 US0054 2025-11-14T14:27:23.171Z 2025-11-21T15:13:39.227Z
8448891 8448891 20251113004012_OnbjL US0054 2025-11-14T14:18:50.177Z 2025-11-21T15:11:40.566Z
8370467 8370467 20251104021024_nKROx US0054 2025-11-05T14:11:09.780Z 2025-11-12T15:10:41.307Z
8357822 8357822 20251102071645_PB2f8 US0054 2025-11-03T14:43:44.126Z 2025-11-10T15:09:59.274Z
8338720 8338720 20251031091310_J35rZ US0054 2025-11-02T14:33:11.337Z 2025-11-08T15:17:09.887Z
8327559 8327559 20251030112305_jLO5S US0054 2025-11-01T12:37:29.035Z 2025-11-07T15:19:03.236Z
8327243 8327243 20251030105509_Mok4X US0054 2025-11-01T12:37:15.490Z 2025-11-07T15:18:52.397Z
8327203 8327203 20251030105110_mpjxc US0054 2025-11-01T12:37:05.173Z 2025-11-07T15:18:49.769Z
8326478 8326478 20251030094505_OLnhT US0054 2025-11-01T12:35:34.794Z 2025-11-07T15:18:07.004Z
8326351 8326351 20251030093413_wFp9r US0054 2025-11-01T12:35:27.727Z 2025-11-07T15:17:51.582Z
8326044 8326044 20251030085934_y4Tls US0054 2025-11-01T12:35:12.801Z 2025-11-07T15:17:40.080Z
8325708 8325708 20251030081415_3jrsR US0054 2025-11-01T12:34:23.205Z 2025-11-07T15:17:28.427Z
8325476 8325476 20251030075207_LQ0l3 US0054 2025-11-01T12:34:11.140Z 2025-11-07T15:17:22.947Z
8325468 8325468 20251030074940_iAqaf US0054 2025-11-01T12:34:10.658Z 2025-11-07T15:17:22.814Z
8324723 8324723 20251030062021_TLA2h US0054 2025-11-01T12:33:00.382Z 2025-11-07T15:17:12.182Z
8323312 8323312 20251030044932_ofyau US0054 2025-11-01T12:30:32.389Z 2025-11-07T15:15:56.315Z
8307605 8307605 20251029095636_r9XUW US0054 2025-10-31T12:28:12.260Z 2025-11-06T15:15:40.380Z
8306296 8306296 20251029075033_yIPwE US0054 2025-10-31T12:24:57.118Z 2025-11-06T15:15:02.910Z
8306288 8306288 20251029074946_Ln0go US0054 2025-10-31T12:24:56.314Z 2025-11-06T15:15:01.901Z
8305868 8305868 20251029065124_z22lt US0054 2025-10-31T12:23:50.394Z 2025-11-06T15:14:52.625Z
8294771 8294771 20251028105716_FoHhc US0054 2025-10-30T12:41:16.434Z 2025-11-05T15:24:47.731Z
8294491 8294491 20251028103735_26CMN US0054 2025-10-30T12:41:04.292Z 2025-11-05T15:24:31.702Z
8294438 8294438 20251028103522_h3ztW US0054 2025-10-30T12:41:02.151Z 2025-11-05T15:24:30.261Z
8293781 8293781 20251028095622_o4CRT US0054 2025-10-30T12:39:52.562Z 2025-11-05T15:24:05.598Z
8293696 8293696 20251028095226_2gdFP US0054 2025-10-30T12:39:45.995Z 2025-11-05T15:24:04.085Z
8293456 8293456 20251028093641_znWIx US0054 2025-10-30T12:39:34.895Z 2025-11-05T15:23:59.959Z
8293293 8293293 20251028092823_9pHKf US0054 2025-10-30T12:39:27.627Z 2025-11-05T15:23:53.897Z
8293172 8293172 20251028092159_elt6D US0054 2025-10-30T12:38:55.265Z 2025-11-05T15:23:50.095Z
8293143 8293143 20251028091925_OUm0p US0054 2025-10-30T12:38:49.004Z 2025-11-05T15:23:48.236Z
8292952 8292952 20251028090344_NHDHE US0054 2025-10-30T12:38:35.925Z 2025-11-05T15:23:40.989Z
8292863 8292863 20251028085552_eiovR US0054 2025-10-30T12:38:30.340Z 2025-11-05T15:23:37.224Z
8292724 8292724 20251028084605_KcQeP US0054 2025-10-30T12:38:24.413Z 2025-11-05T15:23:33.739Z
8292657 8292657 20251028084334_a0N01 US0054 2025-10-30T12:38:22.042Z 2025-11-05T15:23:33.325Z
8292622 8292622 20251028083927_vqHFp US0054 2025-10-30T12:38:20.080Z 2025-11-05T15:23:32.674Z
8292442 8292442 20251028082605_ke2ss US0054 2025-10-30T12:37:36.431Z 2025-11-05T15:23:30.504Z
8292341 8292341 20251028081759_0P39z US0054 2025-10-30T12:37:30.742Z 2025-11-05T15:23:29.466Z
8291903 8291903 20251028074435_pGiqA US0054 2025-10-30T12:36:32.655Z 2025-11-05T15:23:22.243Z
8291555 8291555 20251028071308_O1VWm US0054 2025-10-30T12:36:12.325Z 2025-11-05T15:23:14.572Z
8291466 8291466 20251028070051_abRpd US0054 2025-10-30T12:36:07.467Z 2025-11-05T15:23:13.787Z
8291229 8291229 20251028062832_0BhSN US0054 2025-10-30T12:35:27.374Z 2025-11-05T15:23:11.409Z
8291213 8291213 20251028062644_Rv6Pq US0054 2025-10-30T12:35:26.335Z 2025-11-05T15:23:11.271Z
8291153 8291153 20251028061717_iknGw US0054 2025-10-30T12:35:22.686Z 2025-11-05T15:23:08.915Z
8290932 8290932 20251028055333_8bTuk US0054 2025-10-30T12:34:35.650Z 2025-11-05T15:23:06.061Z
8290836 8290836 20251028054005_OZYKe US0054 2025-10-30T12:34:26.403Z 2025-11-05T15:23:02.748Z
8284968 8284968 20251028052758_33dcO US0054 2025-10-29T12:46:49.714Z 2025-11-05T15:22:59.505Z
8284966 8284966 20251028052745_KR50N US0054 2025-10-29T12:46:49.660Z 2025-11-05T15:22:59.504Z
8284931 8284931 20251028052547_Oist8 US0054 2025-10-29T12:46:48.730Z 2025-11-05T15:22:58.764Z
8284853 8284853 20251028052008_X4RS7 US0054 2025-10-29T12:46:46.143Z 2025-11-05T15:22:58.307Z
8284812 8284812 20251028051717_3fPKS US0054 2025-10-29T12:46:44.789Z 2025-11-05T15:22:58.087Z
8284575 8284575 20251028045710_eIQlz US0054 2025-10-29T12:46:02.622Z 2025-11-05T15:22:51.834Z
8284307 8284307 20251028043352_ujJHm US0054 2025-10-29T12:45:29.120Z 2025-11-05T15:22:44.502Z
8284076 8284076 20251028042027_L0xiq US0054 2025-10-29T12:45:18.220Z 2025-11-05T15:22:39.940Z
8283978 8283978 20251028041217_Djfq3 US0054 2025-10-29T12:45:14.867Z 2025-11-05T15:22:38.123Z
8283913 8283913 20251028040852_zz2Hf US0054 2025-10-29T12:45:12.647Z 2025-11-05T15:22:34.884Z
8283799 8283799 20251028040204_6QXFF US0054 2025-10-29T12:45:08.831Z 2025-11-05T15:22:33.007Z
8281228 8281228 20251028010110_beSBj US0054 2025-10-29T12:40:40.007Z 2025-11-05T15:21:19.787Z
8281163 8281163 20251028005613_qRdus US0054 2025-10-29T12:40:33.149Z 2025-11-05T15:21:18.742Z
8276623 8276623 20251027090719_OO17p US0054 2025-10-29T12:30:08.212Z 2025-11-04T15:47:00.910Z
8276394 8276394 20251027084208_NTC2t US0054 2025-10-29T12:29:54.009Z 2025-11-04T15:46:55.690Z
8276333 8276333 20251027083456_Eowf3 US0054 2025-10-29T12:29:50.693Z 2025-11-04T15:46:54.363Z
8276292 8276292 20251027083120_dWcxm US0054 2025-10-29T12:29:47.650Z 2025-11-04T15:46:53.431Z
8276114 8276114 20251027080911_eMk0s US0054 2025-10-29T12:29:07.359Z 2025-11-04T15:46:48.919Z
8276094 8276094 20251027080715_jrh33 US0054 2025-10-29T12:29:06.848Z 2025-11-04T15:46:48.722Z
8276033 8276033 20251027080032_aFtIy US0054 2025-10-29T12:29:04.022Z 2025-11-04T15:46:47.882Z
8275945 8275945 20251027075223_Tr3Kd US0054 2025-10-29T12:28:59.672Z 2025-11-04T15:46:40.475Z

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