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

6,783 rows where station_code = "KR003Q" 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
9607950 9607950 20260404200727_dh5DV KR003Q 2026-04-05T12:05:01.759Z 2026-04-06T12:16:14.587Z
9607942 9607942 20260404200000_BZFq7 KR003Q 2026-04-05T12:05:00.190Z 2026-04-06T12:16:14.583Z
9607936 9607936 20260404193024_LWVBa KR003Q 2026-04-05T12:04:58.525Z 2026-04-06T12:16:14.568Z
9603688 9603688 20260402115017_zcVaY KR003Q 2026-04-03T12:04:11.175Z 2026-04-06T12:22:22.183Z
9600081 9600081 20260331191511_uMBNZ KR003Q 2026-04-01T12:05:54.062Z 2026-04-06T12:28:50.669Z
9591703 9591703 20260328193857_PEXK1 KR003Q 2026-03-29T12:04:52.640Z 2026-04-06T12:39:40.691Z
9591688 9591688 20260328190455_zrwTt KR003Q 2026-03-29T12:04:51.084Z 2026-04-06T12:39:39.151Z
9591678 9591678 20260328185459_ykS84 KR003Q 2026-03-29T12:04:50.037Z 2026-04-06T12:39:38.603Z
9591618 9591618 20260328173031_aVnMn KR003Q 2026-03-29T12:04:45.112Z 2026-04-06T12:39:25.503Z
9591613 9591613 20260328172548_dm9uU KR003Q 2026-03-29T12:04:44.888Z 2026-04-06T12:39:25.431Z
9591516 9591516 20260328165918_ApiY0 KR003Q 2026-03-29T12:04:31.770Z 2026-04-06T12:39:19.205Z
9588140 9588140 20260327195332_HEb0T KR003Q 2026-03-28T12:07:14.190Z 2026-04-05T12:35:10.785Z
9588125 9588125 20260327192944_UElss KR003Q 2026-03-28T12:07:12.620Z 2026-04-05T12:35:09.536Z
9588114 9588114 20260327192529_tOdp4 KR003Q 2026-03-28T12:07:11.794Z 2026-04-05T12:35:09.146Z
9588076 9588076 20260327182831_ofCfn KR003Q 2026-03-28T12:07:07.512Z 2026-04-05T12:35:07.108Z
9588071 9588071 20260327182338_BUtDp KR003Q 2026-03-28T12:07:07.255Z 2026-04-05T12:35:06.996Z
9588017 9588017 20260327172935_SuGXT KR003Q 2026-03-28T12:06:56.571Z 2026-04-05T12:35:04.280Z
9583857 9583857 20260326191249_GfJ3G KR003Q 2026-03-27T12:09:56.529Z 2026-04-04T12:41:41.515Z
9583772 9583772 20260326175452_Z5Mbc KR003Q 2026-03-27T12:09:43.077Z 2026-04-04T12:41:38.016Z
9583520 9583520 20260326154429_N8nkB KR003Q 2026-03-27T12:09:02.958Z 2026-04-04T12:41:22.466Z
9583468 9583468 20260326151250_ossf4 KR003Q 2026-03-27T12:08:53.661Z 2026-04-04T12:41:14.014Z
9578887 9578887 20260325154203_apW1Q KR003Q 2026-03-26T12:08:46.033Z 2026-04-03T12:38:38.805Z
9578813 9578813 20260325150317_fXQPW KR003Q 2026-03-26T12:08:35.764Z 2026-04-03T12:38:34.578Z
9578756 9578756 20260325141633_g15Yq KR003Q 2026-03-26T12:08:25.258Z 2026-04-03T12:38:30.725Z
9575315 9575315 20260323203207_jgF2u KR003Q 2026-03-25T12:20:48.842Z 2026-03-31T12:28:54.532Z
9575250 9575250 20260323195330_rQs6w KR003Q 2026-03-25T12:20:40.691Z 2026-03-31T12:28:52.226Z
9575130 9575130 20260323185045_P3nna KR003Q 2026-03-25T12:20:21.714Z 2026-03-31T12:28:49.239Z
9575029 9575029 20260323182127_YX5sH KR003Q 2026-03-25T12:20:05.617Z 2026-03-31T12:28:46.701Z
9570066 9570066 20260322190416_gWV8Y KR003Q 2026-03-24T12:22:32.191Z 2026-03-30T12:30:27.243Z
9570039 9570039 20260322190029_JHCH7 KR003Q 2026-03-24T12:22:30.207Z 2026-03-30T12:30:26.824Z
9569186 9569186 20260322135732_g1fjx KR003Q 2026-03-24T12:20:01.090Z 2026-03-30T12:29:37.124Z
9569154 9569154 20260322134712_GZGtD KR003Q 2026-03-24T12:19:55.252Z 2026-03-30T12:29:35.624Z
9569125 9569125 20260322132955_zIHm0 KR003Q 2026-03-24T12:19:50.574Z 2026-03-30T12:29:33.937Z
9569056 9569056 20260322125517_ix2y3 KR003Q 2026-03-24T12:19:35.183Z 2026-03-30T12:29:29.040Z
9568884 9568884 20260322105838_7YPeb KR003Q 2026-03-24T12:18:47.275Z 2026-03-30T12:29:03.703Z
9568634 9568634 20260323170746_QULH9 KR003Q 2026-03-24T12:15:25.530Z 2026-03-31T12:28:39.137Z
9568505 9568505 20260323165059_Q9RAF KR003Q 2026-03-24T12:15:12.456Z 2026-03-31T12:28:30.021Z
9567354 9567354 20260323150938_zK15F KR003Q 2026-03-24T12:13:25.882Z 2026-03-24T12:24:25.263Z
9551127 9551127 20260320183406_dTv31 KR003Q 2026-03-22T12:26:12.383Z 2026-03-28T12:36:40.273Z
9548718 9548718 20260321153002_GKKFh KR003Q 2026-03-22T12:15:52.675Z 2026-03-29T12:20:28.397Z
9548181 9548181 20260321143912_GWC91 KR003Q 2026-03-22T12:15:00.373Z 2026-03-29T12:20:24.524Z
9547826 9547826 20260321140114_3NH3Y KR003Q 2026-03-22T12:14:22.192Z 2026-03-29T12:20:21.603Z
9546765 9546765 20260321122538_zJZMz KR003Q 2026-03-22T12:12:22.017Z 2026-03-29T12:20:04.117Z
9541274 9541274 20260319201232_CQdG6 KR003Q 2026-03-21T12:28:47.551Z 2026-03-27T12:42:36.061Z
9541027 9541027 20260319190231_CdYAc KR003Q 2026-03-21T12:28:24.552Z 2026-03-27T12:42:33.191Z
9540961 9540961 20260319184238_hCoSB KR003Q 2026-03-21T12:28:19.339Z 2026-03-27T12:42:32.499Z
9540852 9540852 20260319181523_E1Zsl KR003Q 2026-03-21T12:28:13.138Z 2026-03-27T12:42:31.499Z
9540804 9540804 20260319180747_r9kZH KR003Q 2026-03-21T12:28:10.077Z 2026-03-27T12:42:31.129Z
9540776 9540776 20260319175305_9wHZr KR003Q 2026-03-21T12:28:08.629Z 2026-03-27T12:42:30.858Z
9540557 9540557 20260319162934_Q0IH6 KR003Q 2026-03-21T12:27:17.377Z 2026-03-27T12:42:25.276Z
9540431 9540431 20260319154024_hog6R KR003Q 2026-03-21T12:26:59.873Z 2026-03-27T12:42:21.726Z
9540425 9540425 20260319153918_v8S23 KR003Q 2026-03-21T12:26:59.607Z 2026-03-27T12:42:21.670Z
9540189 9540189 20260319141437_B8rlP KR003Q 2026-03-21T12:26:25.765Z 2026-03-27T12:42:02.868Z
9540142 9540142 20260319133336_SXi8d KR003Q 2026-03-21T12:26:13.004Z 2026-03-27T12:42:00.944Z
9540126 9540126 20260319132650_FkVSN KR003Q 2026-03-21T12:26:11.570Z 2026-03-27T12:41:59.875Z
9540107 9540107 20260319130726_923xu KR003Q 2026-03-21T12:26:06.667Z 2026-03-27T12:41:58.912Z
9539916 9539916 20260319105806_Elbcs KR003Q 2026-03-21T12:25:16.416Z 2026-03-27T12:41:46.400Z
9530198 9530198 20260318202356_wVOWz KR003Q 2026-03-20T12:24:11.555Z 2026-03-26T12:39:10.254Z
9527933 9527933 20260318152925_tC3Qj KR003Q 2026-03-20T12:21:49.331Z 2026-03-26T12:38:32.176Z
9507074 9507074 20260316201431_OkkBK KR003Q 2026-03-18T12:19:50.801Z 2026-03-24T12:41:38.833Z
9506768 9506768 20260316192416_0hg6H KR003Q 2026-03-18T12:19:20.248Z 2026-03-24T12:41:34.680Z
9504598 9504598 20260317120329_bGAcY KR003Q 2026-03-18T12:08:27.356Z 2026-03-25T12:42:23.114Z
9499974 9499974 20260316170933_3TfDK KR003Q 2026-03-17T12:16:31.872Z 2026-03-24T12:41:32.057Z
9499910 9499910 20260316170312_g2wU6 KR003Q 2026-03-17T12:16:22.506Z 2026-03-24T12:41:31.819Z
9498726 9498726 20260316152219_Zququ KR003Q 2026-03-17T12:14:21.042Z 2026-03-24T12:41:26.858Z
9498470 9498470 20260316150730_quoFL KR003Q 2026-03-17T12:13:59.138Z 2026-03-24T12:41:26.193Z
9498236 9498236 20260316144703_cHi8O KR003Q 2026-03-17T12:13:30.417Z 2026-03-24T12:41:25.311Z
9498061 9498061 20260316143401_z2pIe KR003Q 2026-03-17T12:13:11.897Z 2026-03-24T12:41:24.936Z
9497600 9497600 20260316134911_3cm3t KR003Q 2026-03-17T12:12:19.344Z 2026-03-24T12:41:23.556Z
9497466 9497466 20260316133821_U5kiD KR003Q 2026-03-17T12:12:00.737Z 2026-03-24T12:41:23.266Z
9496567 9496567 20260316115348_cPnCa KR003Q 2026-03-17T12:10:05.341Z 2026-03-17T12:25:25.004Z
9496565 9496565 20260316115334_k2bgk KR003Q 2026-03-17T12:10:04.880Z 2026-03-24T12:41:20.326Z
9491865 9491865 20260315204046_EecQC KR003Q 2026-03-16T12:22:00.655Z 2026-03-23T12:22:42.796Z
9491838 9491838 20260315202902_tukL0 KR003Q 2026-03-16T12:21:57.368Z 2026-03-23T12:22:42.557Z
9491819 9491819 20260315201801_aV9hg KR003Q 2026-03-16T12:21:53.630Z 2026-03-23T12:22:42.493Z
9491762 9491762 20260315193111_97h3f KR003Q 2026-03-16T12:21:46.381Z 2026-03-23T12:22:41.670Z
9491745 9491745 20260315191455_IeaJc KR003Q 2026-03-16T12:21:44.012Z 2026-03-23T12:22:41.368Z
9491711 9491711 20260315184731_jF4u2 KR003Q 2026-03-16T12:21:39.082Z 2026-03-23T12:22:41.028Z
9491661 9491661 20260315174746_hlALu KR003Q 2026-03-16T12:21:29.020Z 2026-03-23T12:22:40.377Z
9491380 9491380 20260315164109_iIBd2 KR003Q 2026-03-16T12:20:52.406Z 2026-03-23T12:22:39.319Z
9489229 9489229 20260315130020_tE6Pi KR003Q 2026-03-16T12:16:45.502Z 2026-03-23T12:22:33.569Z
9489039 9489039 20260315124237_K1e5w KR003Q 2026-03-16T12:16:19.996Z 2026-03-23T12:22:32.979Z
9488930 9488930 20260315123525_h2RuK KR003Q 2026-03-16T12:16:09.327Z 2026-03-23T12:22:32.665Z
9482111 9482111 20260314163008_gy3Sp KR003Q 2026-03-15T12:19:02.327Z 2026-03-22T12:42:46.748Z
9480080 9480080 20260314125423_Ps4kP KR003Q 2026-03-15T12:15:11.287Z 2026-03-22T12:42:40.321Z
9473863 9473863 20260313203247_viWnx KR003Q 2026-03-14T12:16:06.147Z 2026-03-21T12:50:18.090Z
9473748 9473748 20260313185545_67VUl KR003Q 2026-03-14T12:15:45.187Z 2026-03-21T12:50:01.174Z
9473741 9473741 20260313184400_wzxLK KR003Q 2026-03-14T12:15:44.147Z 2026-03-21T12:50:00.901Z
9473692 9473692 20260313182405_ZQN5w KR003Q 2026-03-14T12:15:38.161Z 2026-03-21T12:50:00.238Z
9473635 9473635 20260313174154_MrxaT KR003Q 2026-03-14T12:15:29.814Z 2026-03-21T12:49:58.982Z
9473570 9473570 20260313172238_h9KBU KR003Q 2026-03-14T12:15:19.821Z 2026-03-21T12:49:58.669Z
9473564 9473564 20260313172237_GINRQ KR003Q 2026-03-14T12:15:19.371Z 2026-03-21T12:49:58.645Z
9473430 9473430 20260313165500_aM5Sf KR003Q 2026-03-14T12:15:03.878Z 2026-03-21T12:49:57.491Z
9473017 9473017 20260313153645_mOlh6 KR003Q 2026-03-14T12:14:19.134Z 2026-03-21T12:49:53.364Z
9473005 9473005 20260313153327_FoBGa KR003Q 2026-03-14T12:14:17.387Z 2026-03-21T12:49:53.216Z
9472988 9472988 20260313153134_2D1gE KR003Q 2026-03-14T12:14:16.617Z 2026-03-21T12:49:53.203Z
9472744 9472744 20260313145533_MAtBK KR003Q 2026-03-14T12:13:49.245Z 2026-03-21T12:49:51.633Z
9472737 9472737 20260313145446_82lD2 KR003Q 2026-03-14T12:13:48.025Z 2026-03-21T12:49:51.630Z
9472497 9472497 20260313141231_m8OW2 KR003Q 2026-03-14T12:13:17.638Z 2026-03-21T12:49:49.065Z
9472054 9472054 20260313124008_3dJZV KR003Q 2026-03-14T12:12:13.943Z 2026-03-21T12:49:45.817Z

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