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

596 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
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
8170573 8170573 20251020080036_R8a3o US005N 2025-10-22T12:39:52.042Z 2025-10-28T13:09:08.339Z
8170497 8170497 20251020075424_nwjQ3 US005N 2025-10-22T12:39:49.839Z 2025-10-28T13:09:08.180Z
8168580 8168580 20251020040542_qRH1A US005N 2025-10-22T12:36:16.383Z 2025-10-28T13:08:57.464Z
8167942 8167942 20251020030900_IS72Q US005N 2025-10-22T12:34:29.439Z 2025-10-28T13:08:43.718Z
8163392 8163392 20251021021718_uG08F US005N 2025-10-22T12:17:52.662Z 2025-10-29T13:07:20.069Z
8150894 8150894 20251019113644_cVQLH US005N 2025-10-20T12:31:37.252Z 2025-10-27T13:11:32.161Z
8150548 8150548 20251019110014_8KkrM US005N 2025-10-20T12:30:50.544Z 2025-10-27T13:11:26.678Z
8150171 8150171 20251019101902_1C7nN US005N 2025-10-20T12:30:17.106Z 2025-10-27T13:11:23.469Z
8148414 8148414 20251019074935_nXVCQ US005N 2025-10-20T12:26:58.930Z 2025-10-27T13:11:04.982Z
8148292 8148292 20251019074000_u8l4r US005N 2025-10-20T12:26:51.109Z 2025-10-27T13:11:03.590Z
8145849 8145849 20251019024756_Pycpf US005N 2025-10-20T12:21:08.386Z 2025-10-27T13:10:32.994Z
8139777 8139777 20251019120415_K7uzi US005N 2025-10-20T12:00:40.480Z 2025-10-20T12:00:40.480Z
8093916 8093916 20251013103655_NB0HJ US005N 2025-10-14T12:14:41.341Z 2025-10-21T13:09:55.015Z
8093888 8093888 20251013101459_2YPO3 US005N 2025-10-14T12:14:39.220Z 2025-10-21T13:09:54.466Z
8093871 8093871 20251013095554_Hzot6 US005N 2025-10-14T12:14:37.827Z 2025-10-21T13:09:54.275Z
8093265 8093265 20251013033226_njBAj US005N 2025-10-14T12:12:52.104Z 2025-10-21T13:09:46.468Z
8089152 8089152 20251013105458_eLr5x US005N 2025-10-14T12:00:14.422Z 2025-10-22T13:08:38.336Z
8076195 8076195 20251009080528_uZnM3 US005N 2025-10-10T12:11:47.981Z 2025-10-17T12:38:05.503Z
8072967 8072967 20251009100556_kxq3o US005N 2025-10-10T12:00:23.973Z 2025-10-18T12:59:25.574Z
8072965 8072965 20251009100537_xJcRy US005N 2025-10-10T12:00:23.604Z 2025-10-18T12:59:25.511Z
8072935 8072935 20251009095609_d6Vpm US005N 2025-10-10T12:00:16.631Z 2025-10-18T12:59:21.965Z
8053723 8053723 20251003112816_bxOLq US005N 2025-10-05T12:06:40.766Z 2025-10-12T12:30:54.433Z
8051283 8051283 20251003034435_PiVM5 US005N 2025-10-04T12:43:41.447Z 2025-10-11T12:42:17.909Z
8046470 8046470 20251002113057_4qCaW US005N 2025-10-04T12:09:14.543Z 2025-10-11T12:38:10.084Z
8046428 8046428 20251002112320_lcJQY US005N 2025-10-04T12:09:00.128Z 2025-10-11T12:38:09.109Z
8046421 8046421 20251002112021_Y5iNt US005N 2025-10-04T12:08:58.379Z 2025-10-11T12:38:08.777Z
8046321 8046321 20251002110404_sxsk4 US005N 2025-10-04T12:08:43.438Z 2025-10-11T12:38:04.181Z
8045876 8045876 20251002100152_ih9Hd US005N 2025-10-04T12:06:44.336Z 2025-10-11T12:37:57.350Z
8045245 8045245 20251002085331_XONvd US005N 2025-10-04T12:03:56.967Z 2025-10-11T12:37:44.359Z
8023620 8023620 20250930114947_E47kC US005N 2025-10-02T12:09:49.573Z 2025-10-09T12:35:31.427Z
8023328 8023328 20250930110557_nkqn5 US005N 2025-10-02T12:08:31.877Z 2025-10-09T12:35:27.020Z
8023177 8023177 20250930104252_IjsoU US005N 2025-10-02T12:07:51.722Z 2025-10-09T12:35:25.093Z
8022635 8022635 20250930092658_RZSdp US005N 2025-10-02T12:05:27.777Z 2025-10-09T12:35:18.865Z
8022587 8022587 20250930091806_L94RN US005N 2025-10-02T12:05:04.829Z 2025-10-09T12:35:15.754Z
8022356 8022356 20250930083928_c6gpC US005N 2025-10-02T12:03:46.848Z 2025-10-09T12:34:55.098Z
7999260 7999260 20250929100538_zqlYF US005N 2025-09-30T12:07:12.605Z 2025-10-08T12:41:44.338Z

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