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

>10,000 rows count all where station_code = "US0004" 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
8691425 8691425 20251205052645_qKTeH US0004 2025-12-06T14:17:44.419Z 2025-12-06T14:18:01.111Z
8691383 8691383 20251205051253_04mS7 US0004 2025-12-06T14:17:33.382Z 2025-12-06T14:18:01.101Z
8691379 8691379 20251205051154_Ywtt8 US0004 2025-12-06T14:17:32.746Z 2025-12-06T14:18:01.101Z
8691348 8691348 20251205045146_I3Ikc US0004 2025-12-06T14:17:26.848Z 2025-12-06T14:18:01.093Z
8690955 8690955 20251205023308_QTail US0004 2025-12-06T14:15:59.914Z 2025-12-06T14:18:00.999Z
8690848 8690848 20251205020507_Ws6Fp US0004 2025-12-06T14:15:41.129Z 2025-12-06T14:18:00.972Z
8690722 8690722 20251205013112_lQ2TA US0004 2025-12-06T14:15:15.764Z 2025-12-06T14:18:00.946Z
8690658 8690658 20251205011614_7Eaq8 US0004 2025-12-06T14:15:05.809Z 2025-12-06T14:18:00.931Z
8688779 8688779 20251205124257_KWDCd US0004 2025-12-06T14:05:45.482Z 2025-12-06T14:05:45.482Z
8688755 8688755 20251205123742_TerFk US0004 2025-12-06T14:05:40.917Z 2025-12-06T14:05:40.917Z
8688624 8688624 20251205121507_OBSIn US0004 2025-12-06T14:05:12.799Z 2025-12-06T14:05:12.799Z
8688568 8688568 20251205120416_qI7ix US0004 2025-12-06T14:05:03.739Z 2025-12-06T14:05:03.739Z
8688542 8688542 20251205115746_74T1S US0004 2025-12-06T14:04:53.617Z 2025-12-06T14:04:53.617Z
8688504 8688504 20251205114717_dA7e1 US0004 2025-12-06T14:04:45.459Z 2025-12-06T14:04:45.459Z
8688197 8688197 20251205104431_sNWnK US0004 2025-12-06T14:03:37.676Z 2025-12-06T14:03:37.676Z
8687825 8687825 20251205091355_rZ57j US0004 2025-12-06T14:01:57.098Z 2025-12-06T14:01:57.098Z
8687660 8687660 20251205081854_FiRgh US0004 2025-12-06T14:01:17.670Z 2025-12-06T14:01:17.670Z
8681251 8681251 20251203025021_mpM8f US0004 2025-12-04T14:14:10.793Z 2025-12-06T14:27:58.229Z
8681108 8681108 20251203022502_LcX7i US0004 2025-12-04T14:13:52.448Z 2025-12-06T14:27:49.946Z
8680849 8680849 20251203013123_jC4A0 US0004 2025-12-04T14:13:04.953Z 2025-12-06T14:27:29.252Z
8677151 8677151 20251202071037_kQ6zQ US0004 2025-12-03T14:26:22.201Z 2025-12-06T14:35:36.910Z
8677072 8677072 20251202064423_CAqEn US0004 2025-12-03T14:26:16.513Z 2025-12-06T14:35:34.180Z
8674695 8674695 20251202030739_oJU2q US0004 2025-12-03T14:22:13.366Z 2025-12-06T14:34:15.893Z
8674629 8674629 20251202030206_bBYAv US0004 2025-12-03T14:22:09.877Z 2025-12-06T14:34:14.371Z
8674508 8674508 20251202023738_YmHkS US0004 2025-12-03T14:21:43.377Z 2025-12-06T14:34:10.567Z
8674365 8674365 20251202021300_aCFKp US0004 2025-12-03T14:21:32.560Z 2025-12-06T14:34:06.720Z
8671807 8671807 20251201130150_YbVy0 US0004 2025-12-03T14:13:51.314Z 2025-12-06T14:31:20.527Z
8670051 8670051 20251202125626_GtEWp US0004 2025-12-03T14:06:37.979Z 2025-12-06T14:24:32.563Z
8670001 8670001 20251202124516_OorD2 US0004 2025-12-03T14:06:28.343Z 2025-12-06T14:24:30.466Z
8669972 8669972 20251202123912_19HbO US0004 2025-12-03T14:06:14.183Z 2025-12-06T14:24:28.995Z
8669890 8669890 20251202122235_TjGT2 US0004 2025-12-03T14:05:56.680Z 2025-12-06T14:24:25.147Z
8669852 8669852 20251202121807_ULrQw US0004 2025-12-03T14:05:50.595Z 2025-12-06T14:24:23.484Z
8669816 8669816 20251202121307_55Kvw US0004 2025-12-03T14:05:34.811Z 2025-12-06T14:24:21.692Z
8669801 8669801 20251202121258_5eZcg US0004 2025-12-03T14:05:32.473Z 2025-12-06T14:24:21.382Z
8669767 8669767 20251202120857_v2g89 US0004 2025-12-03T14:05:24.028Z 2025-12-06T14:24:19.251Z
8669725 8669725 20251202120529_nEn5c US0004 2025-12-03T14:05:17.760Z 2025-12-06T14:24:17.562Z
8669713 8669713 20251202120329_AYVL2 US0004 2025-12-03T14:05:15.408Z 2025-12-06T14:24:17.019Z
8669636 8669636 20251202114836_BR93H US0004 2025-12-03T14:04:46.863Z 2025-12-06T14:24:12.410Z
8669592 8669592 20251202113859_ZUyAw US0004 2025-12-03T14:04:39.119Z 2025-12-06T14:24:05.009Z
8669531 8669531 20251202112806_R6CuX US0004 2025-12-03T14:04:20.354Z 2025-12-06T14:23:59.861Z
8669427 8669427 20251202111052_LXnqK US0004 2025-12-03T14:03:42.784Z 2025-12-06T14:23:53.996Z
8669363 8669363 20251202110018_FTSPb US0004 2025-12-03T14:03:28.124Z 2025-12-06T14:23:50.641Z
8669266 8669266 20251202104255_TGH7e US0004 2025-12-03T14:03:06.069Z 2025-12-06T14:23:46.835Z
8669257 8669257 20251202104140_FaflD US0004 2025-12-03T14:03:05.128Z 2025-12-06T14:23:46.555Z
8669224 8669224 20251202103424_6GPbt US0004 2025-12-03T14:02:54.632Z 2025-12-06T14:23:41.163Z
8669102 8669102 20251202101224_oqijY US0004 2025-12-03T14:02:25.131Z 2025-12-06T14:23:32.587Z
8669060 8669060 20251202100704_UqzTo US0004 2025-12-03T14:02:11.992Z 2025-12-06T14:23:30.064Z
8669030 8669030 20251202095458_31t2u US0004 2025-12-03T14:02:04.066Z 2025-12-06T14:23:26.821Z
8669021 8669021 20251202095412_cZhv3 US0004 2025-12-03T14:02:02.907Z 2025-12-06T14:23:26.299Z
8668998 8668998 20251202095037_VHFJc US0004 2025-12-03T14:01:58.751Z 2025-12-06T14:23:25.086Z
8668967 8668967 20251202094106_2Hl5u US0004 2025-12-03T14:01:46.006Z 2025-12-06T14:23:23.554Z
8668918 8668918 20251202092723_QtHln US0004 2025-12-03T14:01:36.150Z 2025-12-06T14:23:21.597Z
8668879 8668879 20251202091722_2vcNx US0004 2025-12-03T14:01:31.510Z 2025-12-06T14:23:16.137Z
8668856 8668856 20251202091249_3VBnw US0004 2025-12-03T14:01:28.246Z 2025-12-06T14:23:14.396Z
8668838 8668838 20251202090942_SEcey US0004 2025-12-03T14:01:25.876Z 2025-12-06T14:23:13.819Z
8668796 8668796 20251202090130_NgKpG US0004 2025-12-03T14:01:20.238Z 2025-12-06T14:23:10.340Z
8668781 8668781 20251202085950_oW7sJ US0004 2025-12-03T14:01:13.772Z 2025-12-06T14:23:09.778Z
8668636 8668636 20251202080451_Fc63z US0004 2025-12-03T14:00:38.246Z 2025-12-06T14:22:58.768Z
8668541 8668541 20251202072923_8P3gQ US0004 2025-12-03T14:00:17.200Z 2025-12-06T14:22:47.326Z
8668369 8668369 20251130074417_ZAZsI US0004 2025-12-02T14:42:21.467Z 2025-12-06T14:50:31.139Z
8668261 8668261 20251130070052_9oWgU US0004 2025-12-02T14:42:15.251Z 2025-12-06T14:50:28.926Z
8668144 8668144 20251130061727_BWCxF US0004 2025-12-02T14:42:04.846Z 2025-12-06T14:50:23.932Z
8668086 8668086 20251130060027_gaaEt US0004 2025-12-02T14:42:00.165Z 2025-12-06T14:50:21.186Z
8668008 8668008 20251130054000_wbCIK US0004 2025-12-02T14:41:29.799Z 2025-12-06T14:49:53.432Z
8667932 8667932 20251130051213_rxKLm US0004 2025-12-02T14:41:19.444Z 2025-12-06T14:49:41.994Z
8667922 8667922 20251130050916_GVmch US0004 2025-12-02T14:41:18.116Z 2025-12-06T14:49:41.128Z
8667810 8667810 20251130041143_zRxIl US0004 2025-12-02T14:40:27.870Z 2025-12-06T14:49:26.549Z
8667667 8667667 20251130031436_S7fPz US0004 2025-12-02T14:39:40.128Z 2025-12-06T14:48:41.918Z
8667602 8667602 20251130024434_wInnE US0004 2025-12-02T14:39:24.568Z 2025-12-06T14:48:33.665Z
8660544 8660544 20251130130248_P57MK US0004 2025-12-02T14:08:15.292Z 2025-12-06T14:37:18.714Z
8660518 8660518 20251130130134_KGVA9 US0004 2025-12-02T14:08:12.676Z 2025-12-06T14:37:18.268Z
8660437 8660437 20251130125216_8Rqxp US0004 2025-12-02T14:07:51.278Z 2025-12-06T14:37:16.007Z
8660415 8660415 20251130125103_vUZvR US0004 2025-12-02T14:07:48.458Z 2025-12-06T14:37:15.652Z
8660325 8660325 20251130122858_THO1g US0004 2025-12-02T14:07:23.543Z 2025-12-06T14:37:00.279Z
8660284 8660284 20251130122349_F99nL US0004 2025-12-02T14:07:13.889Z 2025-12-06T14:36:59.041Z
8660189 8660189 20251130120357_iRaqx US0004 2025-12-02T14:06:51.936Z 2025-12-06T14:36:54.990Z
8660175 8660175 20251130120250_TLmfZ US0004 2025-12-02T14:06:48.897Z 2025-12-06T14:36:54.510Z
8660169 8660169 20251130120153_B9YZG US0004 2025-12-02T14:06:47.803Z 2025-12-06T14:36:54.229Z
8660157 8660157 20251130120104_gpO1V US0004 2025-12-02T14:06:45.850Z 2025-12-06T14:36:54.034Z
8660106 8660106 20251130115715_70ZXe US0004 2025-12-02T14:06:30.756Z 2025-12-06T14:36:52.868Z
8660078 8660078 20251130115425_GHlvI US0004 2025-12-02T14:06:27.080Z 2025-12-06T14:36:52.197Z
8660059 8660059 20251130115101_ZgQXl US0004 2025-12-02T14:06:23.550Z 2025-12-06T14:36:51.556Z
8659950 8659950 20251130113258_Saptm US0004 2025-12-02T14:05:54.471Z 2025-12-06T14:36:48.283Z
8659914 8659914 20251130112942_EFaJW US0004 2025-12-02T14:05:48.313Z 2025-12-06T14:36:47.075Z
8659869 8659869 20251130112416_t2Z53 US0004 2025-12-02T14:05:39.605Z 2025-12-06T14:36:45.280Z
8659727 8659727 20251130110948_JSsG3 US0004 2025-12-02T14:05:09.636Z 2025-12-06T14:36:40.697Z
8659701 8659701 20251130110657_Jt6we US0004 2025-12-02T14:05:05.199Z 2025-12-06T14:36:40.065Z
8659665 8659665 20251130110311_zJGcJ US0004 2025-12-02T14:04:48.538Z 2025-12-06T14:36:32.017Z
8659650 8659650 20251130110133_cP52n US0004 2025-12-02T14:04:45.740Z 2025-12-06T14:36:28.392Z
8659624 8659624 20251130105631_9gtik US0004 2025-12-02T14:04:40.592Z 2025-12-06T14:36:25.616Z
8659586 8659586 20251130105249_wdQIe US0004 2025-12-02T14:04:34.868Z 2025-12-06T14:36:24.338Z
8659533 8659533 20251130104247_p3QV1 US0004 2025-12-02T14:04:21.108Z 2025-12-06T14:36:22.908Z
8659527 8659527 20251130104205_59Ej3 US0004 2025-12-02T14:04:20.071Z 2025-12-06T14:36:22.797Z
8659381 8659381 20251130101815_p3wJ0 US0004 2025-12-02T14:03:45.612Z 2025-12-06T14:36:16.842Z
8659337 8659337 20251130101136_s5JOm US0004 2025-12-02T14:03:32.523Z 2025-12-06T14:36:15.072Z
8659286 8659286 20251130100356_myCln US0004 2025-12-02T14:03:23.392Z 2025-12-06T14:36:13.319Z
8659141 8659141 20251130094103_3vhfo US0004 2025-12-02T14:02:45.377Z 2025-12-06T14:36:08.894Z
8659095 8659095 20251130093226_F3mbs US0004 2025-12-02T14:02:33.439Z 2025-12-06T14:36:06.656Z
8648496 8648496 20251129080840_fh8e4 US0004 2025-11-30T14:30:15.708Z 2025-12-06T14:57:45.524Z
8648434 8648434 20251129075314_DEDXa US0004 2025-11-30T14:30:10.082Z 2025-12-06T14:57:41.071Z

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