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

1,338 rows where station_code = "KR003F" 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
8644013 8644013 20251128185006_bV5S1 KR003F 2025-11-30T14:21:10.377Z 2025-12-06T14:54:36.860Z
8643254 8643254 20251128173848_ptJMJ KR003F 2025-11-30T14:19:48.177Z 2025-12-06T14:53:44.610Z
8643096 8643096 20251128172033_HAxIu KR003F 2025-11-30T14:19:19.231Z 2025-12-06T14:53:40.477Z
8643059 8643059 20251128171608_2ubj3 KR003F 2025-11-30T14:19:16.567Z 2025-12-06T14:53:39.948Z
8643046 8643046 20251128171527_7Xmyg KR003F 2025-11-30T14:19:15.954Z 2025-12-06T14:53:39.773Z
8642404 8642404 20251128160047_o8WTp KR003F 2025-11-30T14:17:52.261Z 2025-12-06T14:53:31.172Z
8632108 8632108 20251127203256_O7tRq KR003F 2025-11-29T14:17:00.796Z 2025-12-06T15:00:53.153Z
8631571 8631571 20251127192716_P7dEk KR003F 2025-11-29T14:15:46.322Z 2025-12-06T15:00:20.808Z
8631536 8631536 20251127192225_WzbuN KR003F 2025-11-29T14:15:42.224Z 2025-12-06T15:00:15.794Z
8565557 8565557 20251121204803_KkFne KR003F 2025-11-23T14:13:39.893Z 2025-11-30T15:05:05.808Z
8565179 8565179 20251121195937_ZQExl KR003F 2025-11-23T14:12:41.922Z 2025-11-30T15:04:44.310Z
8565154 8565154 20251121195656_IIPSl KR003F 2025-11-23T14:12:39.797Z 2025-11-30T15:04:43.776Z
8564981 8564981 20251121193537_GV1zG KR003F 2025-11-23T14:12:12.003Z 2025-11-30T15:04:36.934Z
8564966 8564966 20251121193435_d3Nqf KR003F 2025-11-23T14:12:10.478Z 2025-11-30T15:04:36.678Z
8563383 8563383 20251121155909_Tkphe KR003F 2025-11-23T14:08:06.576Z 2025-11-30T15:03:39.064Z
8563370 8563370 20251121155839_9iLt0 KR003F 2025-11-23T14:08:04.749Z 2025-11-30T15:03:38.976Z
8562797 8562797 20251121144718_S4J3R KR003F 2025-11-23T14:06:33.512Z 2025-11-30T15:03:33.112Z
8548625 8548625 20251120210514_6Wwwo KR003F 2025-11-22T14:17:21.692Z 2025-11-29T14:54:22.995Z
8548524 8548524 20251120205941_3G2Fb KR003F 2025-11-22T14:17:07.375Z 2025-11-29T14:54:22.794Z
8548185 8548185 20251120204106_qjgVs KR003F 2025-11-22T14:16:26.827Z 2025-11-29T14:54:22.144Z
8548096 8548096 20251120203702_CCVZE KR003F 2025-11-22T14:16:18.213Z 2025-11-29T14:54:21.930Z
8547641 8547641 20251120200453_rUyIb KR003F 2025-11-22T14:15:24.764Z 2025-11-29T14:54:20.642Z
8547220 8547220 20251120193230_3cSdq KR003F 2025-11-22T14:14:35.626Z 2025-11-29T14:54:19.044Z
8547130 8547130 20251120192607_YBv9C KR003F 2025-11-22T14:14:23.216Z 2025-11-29T14:54:18.683Z
8547026 8547026 20251120191715_Wpf2g KR003F 2025-11-22T14:14:02.778Z 2025-11-29T14:54:18.342Z
8547003 8547003 20251120191629_loE4R KR003F 2025-11-22T14:14:01.552Z 2025-11-29T14:54:18.319Z
8533755 8533755 20251119200647_FU2mF KR003F 2025-11-21T14:11:54.123Z 2025-11-28T14:55:04.189Z
8533659 8533659 20251119194541_JHZm3 KR003F 2025-11-21T14:11:33.660Z 2025-11-28T14:54:58.000Z
8533534 8533534 20251119191336_ON333 KR003F 2025-11-21T14:11:09.998Z 2025-11-28T14:54:52.049Z
8520315 8520315 20251118191441_1bPm3 KR003F 2025-11-20T14:09:33.020Z 2025-11-27T15:11:32.570Z
8520311 8520311 20251118191419_9iz3C KR003F 2025-11-20T14:09:31.216Z 2025-11-27T15:11:32.557Z
8520279 8520279 20251118191136_mTGhf KR003F 2025-11-20T14:09:28.235Z 2025-11-27T15:11:32.438Z
8505523 8505523 20251117202318_ffWQ5 KR003F 2025-11-19T14:10:44.307Z 2025-11-26T15:07:38.852Z
8480115 8480115 20251115203315_fAq9B KR003F 2025-11-17T14:17:29.854Z 2025-11-24T15:04:50.602Z
8480083 8480083 20251115203005_p17HD KR003F 2025-11-17T14:17:24.642Z 2025-11-24T15:04:50.392Z
8479664 8479664 20251115194303_1D3G5 KR003F 2025-11-17T14:16:27.472Z 2025-11-24T15:04:46.842Z
8476948 8476948 20251115150829_PVAJs KR003F 2025-11-17T14:10:04.500Z 2025-11-24T15:03:19.595Z
8464499 8464499 20251114145450_OAdCC KR003F 2025-11-16T14:06:27.864Z 2025-11-23T15:16:20.417Z
8463782 8463782 20251114134159_RDI2U KR003F 2025-11-16T14:04:23.961Z 2025-11-23T15:16:04.140Z
8463329 8463329 20251114125711_VvhKM KR003F 2025-11-16T14:02:50.405Z 2025-11-23T15:15:49.798Z
8435582 8435582 20251111194918_U1nsD KR003F 2025-11-13T14:15:50.130Z 2025-11-20T15:22:23.499Z
8435533 8435533 20251111194504_1iOTt KR003F 2025-11-13T14:15:41.904Z 2025-11-20T15:22:22.260Z
8435478 8435478 20251111194025_6AWBC KR003F 2025-11-13T14:15:37.000Z 2025-11-20T15:22:19.215Z
8435304 8435304 20251111192538_faUAB KR003F 2025-11-13T14:15:07.057Z 2025-11-20T15:22:11.731Z
8435248 8435248 20251111192151_Ms7DN KR003F 2025-11-13T14:14:59.901Z 2025-11-20T15:22:07.485Z
8434906 8434906 20251111185445_GGKaB KR003F 2025-11-13T14:13:55.622Z 2025-11-20T15:21:53.675Z
8434752 8434752 20251111184102_zQAJq KR003F 2025-11-13T14:13:37.465Z 2025-11-20T15:21:49.459Z
8434586 8434586 20251111182430_En4lV KR003F 2025-11-13T14:13:08.401Z 2025-11-20T15:21:45.691Z
8434447 8434447 20251111181423_WXUU2 KR003F 2025-11-13T14:12:53.668Z 2025-11-20T15:21:39.952Z
8433390 8433390 20251111165608_oD2DK KR003F 2025-11-13T14:10:10.661Z 2025-11-20T15:20:45.304Z
8433274 8433274 20251111164740_2MGpd KR003F 2025-11-13T14:09:44.100Z 2025-11-20T15:20:37.297Z
8433206 8433206 20251111164242_ZuRRI KR003F 2025-11-13T14:09:40.495Z 2025-11-20T15:20:36.406Z
8433099 8433099 20251111163516_eQl5I KR003F 2025-11-13T14:09:26.304Z 2025-11-20T15:20:34.412Z
8432934 8432934 20251111161913_J7Uzs KR003F 2025-11-13T14:08:59.932Z 2025-11-20T15:20:27.783Z
8432484 8432484 20251111153259_8yMaK KR003F 2025-11-13T14:07:46.771Z 2025-11-20T15:20:15.382Z
8432326 8432326 20251111152115_WEqP3 KR003F 2025-11-13T14:07:14.718Z 2025-11-20T15:20:12.002Z
8431470 8431470 20251111141023_FKOyu KR003F 2025-11-13T14:04:43.918Z 2025-11-20T15:19:57.085Z
8431342 8431342 20251111135619_PWVvE KR003F 2025-11-13T14:04:16.967Z 2025-11-20T15:19:55.362Z
8431227 8431227 20251111134622_kzXrT KR003F 2025-11-13T14:03:46.973Z 2025-11-20T15:19:53.336Z
8431160 8431160 20251111134223_Rf3gt KR003F 2025-11-13T14:03:36.951Z 2025-11-20T15:19:52.192Z
8430980 8430980 20251111132548_1gMX8 KR003F 2025-11-13T14:03:00.567Z 2025-11-20T15:19:46.591Z
8430547 8430547 20251111124123_yDK9m KR003F 2025-11-13T14:01:34.892Z 2025-11-20T15:19:34.448Z
8421273 8421273 20251110202302_9lYOC KR003F 2025-11-12T14:13:32.832Z 2025-11-19T15:14:28.765Z
8419010 8419010 20251110151636_6A88S KR003F 2025-11-12T14:04:53.397Z 2025-11-19T15:12:55.766Z
8418959 8418959 20251110150619_iben9 KR003F 2025-11-12T14:04:33.942Z 2025-11-19T15:12:54.190Z
8418758 8418758 20251110143033_3mbLX KR003F 2025-11-12T14:03:32.136Z 2025-11-19T15:12:45.109Z
8418334 8418334 20251110132634_PQbQ2 KR003F 2025-11-12T14:01:40.446Z 2025-11-19T15:12:29.507Z
8363725 8363725 20251102204750_7BRnY KR003F 2025-11-04T14:15:09.256Z 2025-11-11T15:05:17.745Z
8363701 8363701 20251102204616_ZVLGq KR003F 2025-11-04T14:15:07.063Z 2025-11-11T15:05:17.053Z
8363689 8363689 20251102204508_MKyWF KR003F 2025-11-04T14:15:04.700Z 2025-11-11T15:05:16.650Z
8363115 8363115 20251102195158_VhrZi KR003F 2025-11-04T14:13:11.649Z 2025-11-11T15:04:35.183Z
8363094 8363094 20251102195100_f2Rda KR003F 2025-11-04T14:13:09.954Z 2025-11-11T15:04:33.690Z
8362822 8362822 20251102193035_Qt2Yo KR003F 2025-11-04T14:12:27.599Z 2025-11-11T15:04:03.824Z
8362550 8362550 20251102191351_u2SY8 KR003F 2025-11-04T14:11:45.045Z 2025-11-11T15:03:48.736Z
8302693 8302693 20251029153740_Sh9Fn KR003F 2025-10-31T12:04:28.041Z 2025-11-07T15:09:19.686Z
8302422 8302422 20251029151109_CIcIo KR003F 2025-10-31T12:03:49.825Z 2025-11-07T15:09:16.400Z
8301520 8301520 20251029135556_XKMtq KR003F 2025-10-31T12:01:35.748Z 2025-11-07T15:08:48.237Z
8301473 8301473 20251029135247_bp5Rh KR003F 2025-10-31T12:01:25.266Z 2025-11-07T15:08:44.974Z
8290564 8290564 20251028202725_RrQM5 KR003F 2025-10-30T12:17:15.885Z 2025-11-06T15:12:08.576Z
8272473 8272473 20251027202529_ci86Q KR003F 2025-10-29T12:09:59.518Z 2025-11-05T15:20:30.022Z
8272414 8272414 20251027201859_5lUEr KR003F 2025-10-29T12:09:50.678Z 2025-11-05T15:20:28.296Z
8272037 8272037 20251027195119_2PaXo KR003F 2025-10-29T12:09:14.039Z 2025-11-05T15:20:19.303Z
8271753 8271753 20251027192922_n3hGC KR003F 2025-10-29T12:08:36.312Z 2025-11-05T15:20:10.398Z
8271653 8271653 20251027192008_iJRei KR003F 2025-10-29T12:08:25.518Z 2025-11-05T15:20:04.037Z
8271636 8271636 20251027191814_CcCLu KR003F 2025-10-29T12:08:23.163Z 2025-11-05T15:20:03.608Z
8270070 8270070 20251027171351_FkMiJ KR003F 2025-10-29T12:05:00.716Z 2025-11-05T15:19:02.135Z
8269185 8269185 20251027155523_Zn9AA KR003F 2025-10-29T12:03:07.622Z 2025-11-05T15:18:40.547Z
8269133 8269133 20251027155253_Jjsfm KR003F 2025-10-29T12:02:59.527Z 2025-11-05T15:18:40.253Z
8269124 8269124 20251027155240_B7yhK KR003F 2025-10-29T12:02:56.392Z 2025-11-05T15:18:40.187Z
8269047 8269047 20251027153727_8lvR3 KR003F 2025-10-29T12:02:40.597Z 2025-11-05T15:18:39.144Z
8268390 8268390 20251027135623_R82QJ KR003F 2025-10-29T12:01:00.512Z 2025-11-05T15:18:29.960Z
8268385 8268385 20251027135603_AxWhv KR003F 2025-10-29T12:01:00.071Z 2025-11-05T15:18:29.945Z
8268345 8268345 20251027134906_8zX3U KR003F 2025-10-29T12:00:56.853Z 2025-11-05T15:18:29.760Z
8268262 8268262 20251027133331_p305D KR003F 2025-10-29T12:00:45.043Z 2025-11-05T15:18:29.224Z
8211195 8211195 20251023203626_undgv KR003F 2025-10-26T12:23:07.982Z 2025-11-01T13:10:01.664Z
8211115 8211115 20251023203118_6g4tQ KR003F 2025-10-26T12:23:02.298Z 2025-11-01T13:10:01.535Z
8211099 8211099 20251023203110_XXHca KR003F 2025-10-26T12:23:01.302Z 2025-11-01T13:10:01.496Z
8211088 8211088 20251023203100_5sDiZ KR003F 2025-10-26T12:23:00.861Z 2025-11-01T13:10:01.488Z
8209019 8209019 20251023160631_RKmnS KR003F 2025-10-26T12:16:11.382Z 2025-11-01T13:09:30.180Z
8208561 8208561 20251023142309_zIqKG KR003F 2025-10-26T12:13:44.444Z 2025-11-01T13:09:10.613Z

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