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 = "KR000J" 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
8688891 8688891 20251205130751_eiWnV KR000J 2025-12-06T14:06:14.609Z 2025-12-06T14:06:14.609Z
8688739 8688739 20251205123040_0xZ7V KR000J 2025-12-06T14:05:37.281Z 2025-12-06T14:05:37.281Z
8688412 8688412 20251205112712_LiRsM KR000J 2025-12-06T14:04:30.324Z 2025-12-06T14:04:30.324Z
8687812 8687812 20251205091246_Pip0g KR000J 2025-12-06T14:01:54.799Z 2025-12-06T14:01:54.799Z
8686956 8686956 20251203212325_KWSv3 KR000J 2025-12-05T14:13:15.308Z 2025-12-06T14:22:13.390Z
8686933 8686933 20251203211906_1TgGV KR000J 2025-12-05T14:13:13.200Z 2025-12-06T14:22:12.419Z
8686925 8686925 20251203211413_AmO5A KR000J 2025-12-05T14:13:12.475Z 2025-12-06T14:22:12.151Z
8686907 8686907 20251203211327_RLfdH KR000J 2025-12-05T14:13:11.259Z 2025-12-06T14:22:11.427Z
8686866 8686866 20251203210700_8WhGG KR000J 2025-12-05T14:13:08.250Z 2025-12-06T14:22:10.397Z
8686831 8686831 20251203205921_MjUVd KR000J 2025-12-05T14:12:53.475Z 2025-12-06T14:22:09.493Z
8686818 8686818 20251203205817_2Y5WR KR000J 2025-12-05T14:12:52.164Z 2025-12-06T14:22:08.114Z
8686806 8686806 20251203205704_lCV5j KR000J 2025-12-05T14:12:50.924Z 2025-12-06T14:22:07.684Z
8686754 8686754 20251203204403_2Qv43 KR000J 2025-12-05T14:12:42.656Z 2025-12-06T14:22:05.087Z
8686652 8686652 20251203202540_kvpNe KR000J 2025-12-05T14:12:33.621Z 2025-12-06T14:22:01.036Z
8686636 8686636 20251203202307_WIyqu KR000J 2025-12-05T14:12:31.614Z 2025-12-06T14:22:00.383Z
8686627 8686627 20251203202115_p2QFL KR000J 2025-12-05T14:12:30.909Z 2025-12-06T14:22:00.152Z
8686612 8686612 20251203201520_POskx KR000J 2025-12-05T14:12:29.273Z 2025-12-06T14:21:59.523Z
8686576 8686576 20251203200642_LgeRo KR000J 2025-12-05T14:12:25.789Z 2025-12-06T14:21:58.450Z
8686552 8686552 20251203200123_lbKqg KR000J 2025-12-05T14:12:17.240Z 2025-12-06T14:21:57.442Z
8686393 8686393 20251203194121_7BWj9 KR000J 2025-12-05T14:11:49.974Z 2025-12-06T14:21:49.797Z
8686387 8686387 20251203194120_FCI9H KR000J 2025-12-05T14:11:49.613Z 2025-12-06T14:21:49.715Z
8686314 8686314 20251203193121_ZKNGy KR000J 2025-12-05T14:11:43.286Z 2025-12-06T14:21:40.956Z
8686135 8686135 20251203185005_TwbeI KR000J 2025-12-05T14:11:07.796Z 2025-12-06T14:21:31.719Z
8686030 8686030 20251203181559_AYhx9 KR000J 2025-12-05T14:10:45.750Z 2025-12-06T14:21:26.800Z
8685931 8685931 20251203174701_Th67p KR000J 2025-12-05T14:10:30.826Z 2025-12-06T14:21:21.641Z
8685750 8685750 20251203163658_jxx2v KR000J 2025-12-05T14:09:53.019Z 2025-12-06T14:20:58.965Z
8685687 8685687 20251203160512_ynO3v KR000J 2025-12-05T14:09:42.189Z 2025-12-06T14:20:55.114Z
8685623 8685623 20251203153456_tGbfo KR000J 2025-12-05T14:09:24.469Z 2025-12-06T14:20:49.344Z
8685536 8685536 20251203143438_f7olU KR000J 2025-12-05T14:08:53.117Z 2025-12-06T14:20:31.193Z
8685422 8685422 20251203121738_dEeun KR000J 2025-12-05T14:08:03.808Z 2025-12-06T14:20:01.681Z
8685412 8685412 20251203121034_qbnEF KR000J 2025-12-05T14:08:00.016Z 2025-12-06T14:20:00.611Z
8685390 8685390 20251203095604_G57uQ KR000J 2025-12-05T14:07:30.331Z 2025-12-06T14:19:26.999Z
8680057 8680057 20251202212805_0Cti5 KR000J 2025-12-04T14:11:00.275Z 2025-12-06T14:26:49.364Z
8680039 8680039 20251202212336_1BQIf KR000J 2025-12-04T14:10:57.630Z 2025-12-06T14:26:48.285Z
8680022 8680022 20251202211855_d4FcF KR000J 2025-12-04T14:10:55.009Z 2025-12-06T14:26:47.703Z
8680001 8680001 20251202211706_pE0vm KR000J 2025-12-04T14:10:53.227Z 2025-12-06T14:26:47.121Z
8679934 8679934 20251202211143_e9zZy KR000J 2025-12-04T14:10:47.581Z 2025-12-06T14:26:44.897Z
8679914 8679914 20251202211127_diSyS KR000J 2025-12-04T14:10:46.666Z 2025-12-06T14:26:44.237Z
8679867 8679867 20251202210339_YjKgg KR000J 2025-12-04T14:10:35.311Z 2025-12-06T14:26:41.862Z
8679742 8679742 20251202204519_Hy2XJ KR000J 2025-12-04T14:10:21.415Z 2025-12-06T14:26:38.347Z
8679718 8679718 20251202204210_pTwxq KR000J 2025-12-04T14:10:18.943Z 2025-12-06T14:26:37.696Z
8679674 8679674 20251202203817_s30iv KR000J 2025-12-04T14:10:15.819Z 2025-12-06T14:26:34.422Z
8679640 8679640 20251202203440_DlU0v KR000J 2025-12-04T14:10:12.553Z 2025-12-06T14:26:29.248Z
8679596 8679596 20251202202623_mDu08 KR000J 2025-12-04T14:10:04.421Z 2025-12-06T14:26:28.066Z
8679514 8679514 20251202201925_iWOSD KR000J 2025-12-04T14:09:55.646Z 2025-12-06T14:26:25.200Z
8679502 8679502 20251202201907_9t88N KR000J 2025-12-04T14:09:54.862Z 2025-12-06T14:26:23.578Z
8679471 8679471 20251202201314_zBRic KR000J 2025-12-04T14:09:52.148Z 2025-12-06T14:26:21.775Z
8679458 8679458 20251202201138_urniF KR000J 2025-12-04T14:09:50.733Z 2025-12-06T14:26:20.930Z
8679325 8679325 20251202194243_wPjvw KR000J 2025-12-04T14:09:27.943Z 2025-12-06T14:26:12.141Z
8679321 8679321 20251202194241_SKN2T KR000J 2025-12-04T14:09:27.360Z 2025-12-06T14:26:12.021Z
8679277 8679277 20251202193525_TOgQH KR000J 2025-12-04T14:09:20.768Z 2025-12-06T14:26:09.960Z
8679200 8679200 20251202192308_IFFS9 KR000J 2025-12-04T14:09:12.592Z 2025-12-06T14:26:06.280Z
8679167 8679167 20251202191342_CjhK7 KR000J 2025-12-04T14:09:08.986Z 2025-12-06T14:26:04.258Z
8679145 8679145 20251202190458_f9t2b KR000J 2025-12-04T14:09:06.113Z 2025-12-06T14:25:57.404Z
8679136 8679136 20251202190234_8NPJ3 KR000J 2025-12-04T14:09:05.375Z 2025-12-06T14:25:57.205Z
8679117 8679117 20251202185607_nf1pn KR000J 2025-12-04T14:08:59.831Z 2025-12-06T14:25:55.888Z
8679070 8679070 20251202184934_3eZ3U KR000J 2025-12-04T14:08:52.414Z 2025-12-06T14:25:52.445Z
8679061 8679061 20251202184923_U9YR9 KR000J 2025-12-04T14:08:51.953Z 2025-12-06T14:25:52.310Z
8678979 8678979 20251202182606_GQFy8 KR000J 2025-12-04T14:08:43.014Z 2025-12-06T14:25:48.262Z
8678895 8678895 20251202180459_MH762 KR000J 2025-12-04T14:08:26.680Z 2025-12-06T14:25:36.465Z
8678833 8678833 20251202174446_fXtS2 KR000J 2025-12-04T14:08:19.447Z 2025-12-06T14:25:31.402Z
8678621 8678621 20251202160236_yeXpt KR000J 2025-12-04T14:07:36.936Z 2025-12-06T14:25:03.443Z
8678604 8678604 20251202155242_PtmDo KR000J 2025-12-04T14:07:30.043Z 2025-12-06T14:25:00.454Z
8678487 8678487 20251202141748_jmanw KR000J 2025-12-04T14:07:05.498Z 2025-12-06T14:24:48.116Z
8678404 8678404 20251202122834_BE7kc KR000J 2025-12-04T14:06:36.021Z 2025-12-06T14:24:27.394Z
8678353 8678353 20251202101501_749QX KR000J 2025-12-04T14:05:21.936Z 2025-12-06T14:23:33.880Z
8678322 8678322 20251202091801_LBQZq KR000J 2025-12-04T14:04:59.538Z 2025-12-06T14:23:19.582Z
8673696 8673696 20251201211603_apEHQ KR000J 2025-12-03T14:19:45.244Z 2025-12-06T14:33:29.180Z
8673687 8673687 20251201211543_uddJ3 KR000J 2025-12-03T14:19:44.621Z 2025-12-06T14:33:29.064Z
8673663 8673663 20251201205901_IVgkI KR000J 2025-12-03T14:19:42.058Z 2025-12-06T14:33:27.772Z
8673642 8673642 20251201205302_4embO KR000J 2025-12-03T14:19:40.176Z 2025-12-06T14:33:26.793Z
8673629 8673629 20251201204732_mccEr KR000J 2025-12-03T14:19:29.702Z 2025-12-06T14:33:26.018Z
8673602 8673602 20251201203334_QGh0i KR000J 2025-12-03T14:19:26.269Z 2025-12-06T14:33:24.866Z
8673595 8673595 20251201203220_Lza02 KR000J 2025-12-03T14:19:25.236Z 2025-12-06T14:33:24.544Z
8671690 8671690 20251201124837_q00cm KR000J 2025-12-03T14:13:20.442Z 2025-12-06T14:31:16.119Z
8670921 8670921 20251201104653_shCYM KR000J 2025-12-03T14:10:44.210Z 2025-12-06T14:30:36.683Z
8670743 8670743 20251201100645_gJUnc KR000J 2025-12-03T14:09:58.957Z 2025-12-06T14:30:20.277Z
8670663 8670663 20251201095427_33UCB KR000J 2025-12-03T14:09:41.177Z 2025-12-06T14:30:15.230Z
8670550 8670550 20251201092510_Qv8Wj KR000J 2025-12-03T14:09:14.665Z 2025-12-06T14:30:09.152Z
8663672 8663672 20251130212257_Cdwls KR000J 2025-12-02T14:18:50.850Z 2025-12-06T14:40:06.835Z
8663607 8663607 20251130210853_B43zY KR000J 2025-12-02T14:18:34.117Z 2025-12-06T14:40:04.821Z
8663537 8663537 20251130205819_8fJ8J KR000J 2025-12-02T14:18:25.486Z 2025-12-06T14:40:02.599Z
8663487 8663487 20251130204942_MiWI3 KR000J 2025-12-02T14:18:22.072Z 2025-12-06T14:40:01.615Z
8663465 8663465 20251130204901_b8gLd KR000J 2025-12-02T14:18:20.422Z 2025-12-06T14:40:01.255Z
8663402 8663402 20251130204352_lE5bK KR000J 2025-12-02T14:18:15.177Z 2025-12-06T14:40:00.257Z
8663368 8663368 20251130203827_1YcXf KR000J 2025-12-02T14:18:03.351Z 2025-12-06T14:39:59.043Z
8663312 8663312 20251130202941_qv8PH KR000J 2025-12-02T14:17:57.965Z 2025-12-06T14:39:57.782Z
8663298 8663298 20251130202841_PcngH KR000J 2025-12-02T14:17:57.246Z 2025-12-06T14:39:57.704Z
8663210 8663210 20251130202122_8iPSF KR000J 2025-12-02T14:17:47.645Z 2025-12-06T14:39:56.149Z
8663199 8663199 20251130202039_rRP0N KR000J 2025-12-02T14:17:40.591Z 2025-12-06T14:39:55.952Z
8662999 8662999 20251130195503_PuE6t KR000J 2025-12-02T14:17:16.401Z 2025-12-06T14:39:38.178Z
8662968 8662968 20251130195040_wd0u0 KR000J 2025-12-02T14:17:13.202Z 2025-12-06T14:39:36.767Z
8662935 8662935 20251130194822_xWaFt KR000J 2025-12-02T14:17:03.735Z 2025-12-06T14:39:36.124Z
8662871 8662871 20251130194241_dApIu KR000J 2025-12-02T14:16:54.353Z 2025-12-06T14:39:33.988Z
8662665 8662665 20251130191901_83zrY KR000J 2025-12-02T14:16:16.790Z 2025-12-06T14:39:25.720Z
8662572 8662572 20251130191135_7yzZT KR000J 2025-12-02T14:15:55.460Z 2025-12-06T14:39:22.778Z
8662216 8662216 20251130181907_q1UWU KR000J 2025-12-02T14:14:43.575Z 2025-12-06T14:38:56.266Z
8662192 8662192 20251130181634_quhpV KR000J 2025-12-02T14:14:39.960Z 2025-12-06T14:38:55.126Z
8662144 8662144 20251130180638_p3UOe KR000J 2025-12-02T14:14:29.682Z 2025-12-06T14:38:51.497Z
8661995 8661995 20251130174108_xUMcI KR000J 2025-12-02T14:13:55.661Z 2025-12-06T14:38:45.763Z

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