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

632 rows where station_code = "US005N" 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
9611680 9611680 20260405030831_k130I US005N 2026-04-06T12:15:42.913Z 2026-04-07T12:16:27.097Z
9609827 9609827 20260405102331_nF7gy US005N 2026-04-06T12:04:09.709Z 2026-04-07T12:13:19.093Z
9609642 9609642 20260405085305_n5y53 US005N 2026-04-06T12:03:02.365Z 2026-04-07T12:13:19.019Z
9609365 9609365 20260405051043_SW6EZ US005N 2026-04-06T12:01:28.469Z 2026-04-07T12:13:18.915Z
9609337 9609337 20260405044847_HcM02 US005N 2026-04-06T12:01:17.724Z 2026-04-07T12:13:18.906Z
9609177 9609177 20260405035326_0cOF4 US005N 2026-04-06T12:00:34.482Z 2026-04-07T12:13:18.860Z
9593454 9593454 20260329105453_5iSlc US005N 2026-03-30T12:04:00.094Z 2026-04-07T12:27:10.524Z
9593438 9593438 20260329104203_pRJ4K US005N 2026-03-30T12:03:57.788Z 2026-04-07T12:27:10.126Z
9590762 9590762 20260328111043_R9FPy US005N 2026-03-29T12:03:13.899Z 2026-04-06T12:38:33.639Z
9590646 9590646 20260328103227_o0pzM US005N 2026-03-29T12:03:04.111Z 2026-04-06T12:38:28.652Z
9590616 9590616 20260328102313_4P3vH US005N 2026-03-29T12:03:00.729Z 2026-04-06T12:38:27.370Z
9582805 9582805 20260326093616_VJHmZ US005N 2026-03-27T12:06:51.365Z 2026-04-04T12:40:29.362Z
9582451 9582451 20260326073654_TXC0w US005N 2026-03-27T12:05:48.570Z 2026-04-04T12:40:01.595Z
9582442 9582442 20260326072953_kPNNF US005N 2026-03-27T12:05:46.279Z 2026-04-04T12:40:01.122Z
9580304 9580304 20260320104947_QWFYg US005N 2026-03-26T12:31:32.128Z 2026-03-28T12:35:19.226Z
9580292 9580292 20260320095436_1MYca US005N 2026-03-26T12:31:21.797Z 2026-03-28T12:35:02.318Z
9580284 9580284 20260320090437_u9WqR US005N 2026-03-26T12:31:13.532Z 2026-03-28T12:34:56.264Z
9580282 9580282 20260320090241_kgZtb US005N 2026-03-26T12:31:13.100Z 2026-03-28T12:34:55.821Z
9580280 9580280 20260320084753_bn7iv US005N 2026-03-26T12:31:11.111Z 2026-03-28T12:34:53.963Z
9580276 9580276 20260320075339_XoBZU US005N 2026-03-26T12:30:54.438Z 2026-03-28T12:34:46.155Z
9580274 9580274 20260320073454_7C0ki US005N 2026-03-26T12:30:52.155Z 2026-03-28T12:34:34.963Z
9580270 9580270 20260320065519_vL2P0 US005N 2026-03-26T12:30:48.640Z 2026-03-28T12:34:32.246Z
9580266 9580266 20260320064944_6yIUZ US005N 2026-03-26T12:30:48.098Z 2026-03-28T12:34:31.886Z
9580252 9580252 20260320052512_XZ1mc US005N 2026-03-26T12:30:42.454Z 2026-03-28T12:34:26.639Z
9580240 9580240 20260321110627_ER34W US005N 2026-03-26T12:26:56.225Z 2026-03-29T12:19:43.230Z
9580234 9580234 20260321103507_lEsPj US005N 2026-03-26T12:26:47.198Z 2026-03-29T12:19:40.152Z
9580230 9580230 20260321101131_0820g US005N 2026-03-26T12:26:41.705Z 2026-03-29T12:19:37.862Z
9579119 9579119 20260324091618_sSyfy US005N 2026-03-26T12:10:48.575Z 2026-04-02T12:35:27.367Z
9577754 9577754 20260325082559_Ca3gP US005N 2026-03-26T12:05:59.525Z 2026-04-03T12:37:25.651Z
9577561 9577561 20260325072432_a3tuz US005N 2026-03-26T12:05:31.141Z 2026-04-03T12:37:06.607Z
9577226 9577226 20260325041925_sf4gt US005N 2026-03-26T12:04:28.055Z 2026-04-03T12:36:52.321Z
9544554 9544554 20260321085306_zomQ3 US005N 2026-03-22T12:07:08.855Z 2026-03-29T12:19:31.025Z
9524309 9524309 20260319114117_YuduC US005N 2026-03-20T12:12:48.062Z 2026-03-27T12:41:51.005Z
9523969 9523969 20260319110950_qaROR US005N 2026-03-20T12:12:19.285Z 2026-03-27T12:41:47.713Z
9513824 9513824 20260318100642_26Tbd US005N 2026-03-19T12:16:17.000Z 2026-03-26T12:38:07.982Z
9504395 9504395 20260317113044_tFPqC US005N 2026-03-18T12:07:56.231Z 2026-03-25T12:42:21.461Z
8592720 8592720 20251124091004_i2rJz US005N 2025-11-25T14:27:31.749Z 2025-12-02T15:13:06.763Z
8417017 8417017 20251110105340_3GuKI US005N 2025-11-11T14:27:14.133Z 2025-11-18T15:21:52.199Z
8416963 8416963 20251110104414_ZKp3f US005N 2025-11-11T14:27:08.640Z 2025-11-18T15:21:51.721Z
8416922 8416922 20251110103739_eo5Zg US005N 2025-11-11T14:27:04.900Z 2025-11-18T15:21:51.572Z
8367400 8367400 20251102122500_CfUJl US005N 2025-11-04T14:37:13.667Z 2025-11-10T15:10:42.254Z
8366072 8366072 20251102100718_EPhGF US005N 2025-11-04T14:34:20.568Z 2025-11-10T15:10:28.639Z
8358805 8358805 20251102091625_I05um US005N 2025-11-03T14:46:31.306Z 2025-11-10T15:10:23.929Z
8328089 8328089 20251030121631_1SBkN US005N 2025-11-01T12:38:22.469Z 2025-11-07T15:19:10.491Z
8328019 8328019 20251030121102_bJ7bn US005N 2025-11-01T12:38:19.309Z 2025-11-07T15:19:09.697Z
8328010 8328010 20251030121039_pgVA8 US005N 2025-11-01T12:38:18.785Z 2025-11-07T15:19:09.524Z
8327860 8327860 20251030115728_I6B2P US005N 2025-11-01T12:38:12.497Z 2025-11-07T15:19:07.477Z
8327546 8327546 20251030112220_2xrzn US005N 2025-11-01T12:37:28.494Z 2025-11-07T15:19:03.027Z
8327529 8327529 20251030112044_IkNyG US005N 2025-11-01T12:37:27.824Z 2025-11-07T15:19:02.859Z
8308842 8308842 20251029113517_wPYf6 US005N 2025-10-31T12:30:17.174Z 2025-11-06T15:16:23.742Z
8308433 8308433 20251029110318_K6XMY US005N 2025-10-31T12:29:29.728Z 2025-11-06T15:16:06.776Z
8308285 8308285 20251029105128_431y8 US005N 2025-10-31T12:29:18.437Z 2025-11-06T15:16:00.889Z
8308250 8308250 20251029104509_cU11D US005N 2025-10-31T12:29:16.253Z 2025-11-06T15:15:59.302Z
8306703 8306703 20251029083421_Au43h US005N 2025-10-31T12:26:09.805Z 2025-11-06T15:15:14.547Z
8305961 8305961 20251029070058_txVaq US005N 2025-10-31T12:24:10.166Z 2025-11-06T15:14:54.696Z
8295693 8295693 20251028120607_GVL8M US005N 2025-10-30T12:43:07.749Z 2025-11-05T15:25:21.107Z
8295404 8295404 20251028114353_rpQW0 US005N 2025-10-30T12:42:57.300Z 2025-11-05T15:25:14.634Z
8295333 8295333 20251028113900_k9Q8E US005N 2025-10-30T12:42:54.363Z 2025-11-05T15:25:10.584Z
8295064 8295064 20251028111734_l6Tai US005N 2025-10-30T12:42:06.647Z 2025-11-05T15:24:55.935Z
8295060 8295060 20251028111633_pz3c4 US005N 2025-10-30T12:42:04.250Z 2025-11-05T15:24:55.832Z
8294785 8294785 20251028105719_sn2LJ US005N 2025-10-30T12:41:16.753Z 2025-11-05T15:24:47.818Z
8294535 8294535 20251028104229_Px3kz US005N 2025-10-30T12:41:06.923Z 2025-11-05T15:24:35.611Z
8292956 8292956 20251028090349_CpTyG US005N 2025-10-30T12:38:36.119Z 2025-11-05T15:23:41.351Z
8277583 8277583 20251027104120_Scrku US005N 2025-10-29T12:32:10.782Z 2025-11-04T15:47:47.460Z
8277389 8277389 20251027102127_3mYnh US005N 2025-10-29T12:31:38.598Z 2025-11-04T15:47:42.675Z
8247928 8247928 20251025122331_Hz5sW US005N 2025-10-27T12:42:48.412Z 2025-11-02T15:05:54.202Z
8247683 8247683 20251025120446_JjoNH US005N 2025-10-27T12:42:37.826Z 2025-11-02T15:05:53.454Z
8247562 8247562 20251025115420_XgDBt US005N 2025-10-27T12:42:34.893Z 2025-11-02T15:05:53.210Z
8247490 8247490 20251025115038_azA9e US005N 2025-10-27T12:42:33.279Z 2025-11-02T15:05:53.062Z
8247181 8247181 20251025112302_VqCnI US005N 2025-10-27T12:42:24.184Z 2025-11-02T15:05:52.308Z
8247035 8247035 20251025111236_qeebb US005N 2025-10-27T12:42:11.480Z 2025-11-02T15:05:51.985Z
8247024 8247024 20251025111114_cNkCh US005N 2025-10-27T12:42:10.401Z 2025-11-02T15:05:51.969Z
8246844 8246844 20251025110040_tB8ZN US005N 2025-10-27T12:41:52.483Z 2025-11-02T15:05:51.657Z
8246095 8246095 20251025100021_9Jnhc US005N 2025-10-27T12:40:35.072Z 2025-11-02T15:05:48.963Z
8197945 8197945 20251022120957_Sw9vS US005N 2025-10-24T12:37:25.090Z 2025-10-30T13:14:01.029Z
8197719 8197719 20251022113821_8TIiU US005N 2025-10-24T12:36:29.993Z 2025-10-30T13:13:58.914Z
8197658 8197658 20251022113128_Ya7b8 US005N 2025-10-24T12:36:24.287Z 2025-10-30T13:13:57.303Z
8197634 8197634 20251022112919_3LO2q US005N 2025-10-24T12:36:23.470Z 2025-10-30T13:13:57.202Z
8197622 8197622 20251022112809_RtDco US005N 2025-10-24T12:36:22.621Z 2025-10-30T13:13:57.155Z
8197618 8197618 20251022112803_iSPPH US005N 2025-10-24T12:36:22.419Z 2025-10-30T13:13:57.145Z
8197607 8197607 20251022112731_GTM2u US005N 2025-10-24T12:36:20.713Z 2025-10-30T13:13:57.041Z
8197589 8197589 20251022112559_uH5Ir US005N 2025-10-24T12:36:19.551Z 2025-10-30T13:13:57.007Z
8197454 8197454 20251022110956_lYO9k US005N 2025-10-24T12:36:12.020Z 2025-10-30T13:13:55.160Z
8197190 8197190 20251022104049_iF0gy US005N 2025-10-24T12:35:30.039Z 2025-10-30T13:13:52.780Z
8196372 8196372 20251022091737_lNY2z US005N 2025-10-24T12:33:53.381Z 2025-10-30T13:13:47.870Z
8196329 8196329 20251022091337_cydd9 US005N 2025-10-24T12:33:51.443Z 2025-10-30T13:13:47.801Z
8196309 8196309 20251022091100_YpVXN US005N 2025-10-24T12:33:48.017Z 2025-10-30T13:13:47.711Z
8187252 8187252 20251021115952_8v3R1 US005N 2025-10-23T12:39:14.003Z 2025-10-29T13:08:22.815Z
8187131 8187131 20251021115031_MVI2v US005N 2025-10-23T12:39:10.374Z 2025-10-29T13:08:22.343Z
8187043 8187043 20251021114547_h92xH US005N 2025-10-23T12:39:05.890Z 2025-10-29T13:08:21.506Z
8186524 8186524 20251021110827_m1otL US005N 2025-10-23T12:37:57.434Z 2025-10-29T13:08:16.099Z
8186383 8186383 20251021105754_TIXFz US005N 2025-10-23T12:37:43.056Z 2025-10-29T13:08:15.491Z
8185899 8185899 20251021101925_ykUFb US005N 2025-10-23T12:36:32.054Z 2025-10-29T13:08:13.352Z
8185865 8185865 20251021101644_B3TsB US005N 2025-10-23T12:36:30.811Z 2025-10-29T13:08:13.137Z
8185801 8185801 20251021101232_c8iVG US005N 2025-10-23T12:36:28.923Z 2025-10-29T13:08:12.263Z
8185785 8185785 20251021101122_59i2G US005N 2025-10-23T12:36:28.334Z 2025-10-29T13:08:12.214Z
8171648 8171648 20251020091745_cm5Zh US005N 2025-10-22T12:40:59.596Z 2025-10-28T13:09:17.194Z
8171147 8171147 20251020084353_A37CC US005N 2025-10-22T12:40:41.752Z 2025-10-28T13:09:12.842Z
8170909 8170909 20251020082338_mCoYL US005N 2025-10-22T12:40:33.429Z 2025-10-28T13:09:10.167Z
8170603 8170603 20251020080212_3r6MO US005N 2025-10-22T12:39:56.847Z 2025-10-28T13:09:08.430Z

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